CREATE TABLE [dbo].[ARFinChargeDetailDistributions]
(
[FinChargeDetailDistributionID] [int] NOT NULL IDENTITY(1, 1),
[FinChargeID] [int] NOT NULL,
[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,
[BalanceSheetGroupID] [int] NOT NULL,
[CreatorID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_ARFinChargeDetailDistributions_CreateDate] DEFAULT (getdate()),
[UpdatorID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ARFinChargeDetailDistributions_LastUpdate] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARFinChargeDetailDistributions] ADD CONSTRAINT [PK__ARFinCha__E3EF3A5BBCC04C74] PRIMARY KEY CLUSTERED ([FinChargeDetailDistributionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARFinChargeDetailDistributions] ADD CONSTRAINT [FK_ARFinChargeDetailDistributions_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[ARFinChargeDetailDistributions] ADD CONSTRAINT [FK_ARFinChargeDetailDistributions_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[ARFinChargeDetailDistributions] ADD CONSTRAINT [FK_ARFinChargeDetailDistributions_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[ARFinChargeDetailDistributions] ADD CONSTRAINT [FK_ARFinChargeDetailDistributions_FinChargeID_ARFinChargeDetails] FOREIGN KEY ([FinChargeID], [CustomerID]) REFERENCES [dbo].[ARFinChargeDetails] ([FinChargeID], [CustomerID])
GO
ALTER TABLE [dbo].[ARFinChargeDetailDistributions] ADD CONSTRAINT [FK_ARFinChargeDetailDistributions_InvoiceID_ARInvoices] FOREIGN KEY ([InvoiceID]) REFERENCES [dbo].[ARInvoices] ([InvoiceID])
GO
ALTER TABLE [dbo].[ARFinChargeDetailDistributions] ADD CONSTRAINT [FK_ARFinChargeDetailDistributions_ReceiptID_ARReceipts] FOREIGN KEY ([ReceiptID]) REFERENCES [dbo].[ARReceipts] ([ReceiptID])
GO
ALTER TABLE [dbo].[ARFinChargeDetailDistributions] ADD CONSTRAINT [FK_ARFinChargeDetailDistributions_ReceivablePayableDistributionID_ARAPReceivablePayableDistributions] FOREIGN KEY ([ReceivablePayableDistributionID]) REFERENCES [dbo].[ARAPReceivablePayableDistributions] ([ReceivablePayableDistributionID])
GO
ALTER TABLE [dbo].[ARFinChargeDetailDistributions] ADD CONSTRAINT [FK_ARFinChargeDetailDistributions_ReceivablePayableID_ARAPReceivablePayables] FOREIGN KEY ([ReceivablePayableID]) REFERENCES [dbo].[ARAPReceivablePayables] ([ReceivablePayableID])
GO