CREATE TABLE [dbo].[ARQFinChargeDetailDistributions]
(
[QFinChargeDetailDistributionID] [int] NOT NULL IDENTITY(1, 1),
[CustomerID] [int] NOT NULL,
[InvoiceID] [int] NULL,
[ReceiptID] [int] NULL,
[ReceivablePayableID] [int] NOT NULL,
[ReceivablePayableDistributionID] [int] NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Due] [money] NOT NULL,
[AvgDaily] [money] NOT NULL,
[CalcAmount] [money] NOT NULL,
[Amount] [money] NOT NULL,
[BranchID] [int] NOT NULL,
[DivisionID] [int] NOT NULL,
[CreatorID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_ARQFinChargeDetailDistributions_CreateDate] DEFAULT (getdate()),
[UpdatorID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ARQFinChargeDetailDistributions_LastUpdate] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARQFinChargeDetailDistributions] ADD CONSTRAINT [PK__ARQFinCh__D561E03DE805E732] PRIMARY KEY CLUSTERED ([QFinChargeDetailDistributionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARQFinChargeDetailDistributions] ADD CONSTRAINT [FK_ARQFinChargeDetailDistributions_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[ARQFinChargeDetailDistributions] ADD CONSTRAINT [FK_ARQFinChargeDetailDistributions_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[ARQFinChargeDetailDistributions] ADD CONSTRAINT [FK_ARQFinChargeDetailDistributions_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[ARQFinChargeDetailDistributions] ADD CONSTRAINT [FK_ARQFinChargeDetailDistributions_InvoiceID_ARInvoices] FOREIGN KEY ([InvoiceID]) REFERENCES [dbo].[ARInvoices] ([InvoiceID])
GO
ALTER TABLE [dbo].[ARQFinChargeDetailDistributions] ADD CONSTRAINT [FK_ARQFinChargeDetailDistributions_ReceiptID_ARReceipts] FOREIGN KEY ([ReceiptID]) REFERENCES [dbo].[ARReceipts] ([ReceiptID])
GO
ALTER TABLE [dbo].[ARQFinChargeDetailDistributions] ADD CONSTRAINT [FK_ARQFinChargeDetailDistributions_ReceivablePayableDistributionID_ARAPReceivablePayableDistributions] FOREIGN KEY ([ReceivablePayableDistributionID]) REFERENCES [dbo].[ARAPReceivablePayableDistributions] ([ReceivablePayableDistributionID])
GO
ALTER TABLE [dbo].[ARQFinChargeDetailDistributions] ADD CONSTRAINT [FK_ARQFinChargeDetailDistributions_ReceivablePayableID_ARAPReceivablePayables] FOREIGN KEY ([ReceivablePayableID]) REFERENCES [dbo].[ARAPReceivablePayables] ([ReceivablePayableID])
GO