Tables [dbo].[ARFinChargeDetailDistributions]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:56:44 AM Thursday, March 21, 2019
Last Modified1:10:09 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK__ARFinCha__E3EF3A5BBCC04C74: FinChargeDetailDistributionIDFinChargeDetailDistributionIDint4
False
1 - 1
Foreign Keys FK_ARFinChargeDetailDistributions_FinChargeID_ARFinChargeDetails: [dbo].[ARFinChargeDetails].FinChargeID\CustomerIDFinChargeIDint4
False
Foreign Keys FK_ARFinChargeDetailDistributions_CustomerID_ARCustomers: [dbo].[ARCustomers].CustomerIDForeign Keys FK_ARFinChargeDetailDistributions_FinChargeID_ARFinChargeDetails: [dbo].[ARFinChargeDetails].FinChargeID\CustomerIDCustomerIDint4
False
Foreign Keys FK_ARFinChargeDetailDistributions_InvoiceID_ARInvoices: [dbo].[ARInvoices].InvoiceIDInvoiceIDint4
True
Foreign Keys FK_ARFinChargeDetailDistributions_ReceiptID_ARReceipts: [dbo].[ARReceipts].ReceiptIDReceiptIDint4
True
Foreign Keys FK_ARFinChargeDetailDistributions_ReceivablePayableID_ARAPReceivablePayables: [dbo].[ARAPReceivablePayables].ReceivablePayableIDReceivablePayableIDint4
False
Foreign Keys FK_ARFinChargeDetailDistributions_ReceivablePayableDistributionID_ARAPReceivablePayableDistributions: [dbo].[ARAPReceivablePayableDistributions].ReceivablePayableDistributionIDReceivablePayableDistributionIDint4
False
Descriptionvarchar(255)255
False
Duemoney8
False
AvgDailymoney8
False
CalcAmountmoney8
False
Amountmoney8
False
Foreign Keys FK_ARFinChargeDetailDistributions_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_ARFinChargeDetailDistributions_DivisionID_GLDivisions: [dbo].[GLDivisions].DivisionIDDivisionIDint4
False
BalanceSheetGroupIDint4
False
CreatorIDvarchar(8)8
True
CreateDatedatetime8
False
(getdate())
UpdatorIDvarchar(8)8
True
LastUpdatedatetime8
False
(getdate())
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK__ARFinCha__E3EF3A5BBCC04C74: FinChargeDetailDistributionIDPK__ARFinCha__E3EF3A5BBCC04C74FinChargeDetailDistributionID
True
80
NameColumns
FK_ARFinChargeDetailDistributions_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_ARFinChargeDetailDistributions_CustomerID_ARCustomersCustomerID->[dbo].[ARCustomers].[CustomerID]
FK_ARFinChargeDetailDistributions_DivisionID_GLDivisionsDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_ARFinChargeDetailDistributions_FinChargeID_ARFinChargeDetailsFinChargeID->[dbo].[ARFinChargeDetails].[FinChargeID]
CustomerID->[dbo].[ARFinChargeDetails].[CustomerID]
FK_ARFinChargeDetailDistributions_InvoiceID_ARInvoicesInvoiceID->[dbo].[ARInvoices].[InvoiceID]
FK_ARFinChargeDetailDistributions_ReceiptID_ARReceiptsReceiptID->[dbo].[ARReceipts].[ReceiptID]
FK_ARFinChargeDetailDistributions_ReceivablePayableDistributionID_ARAPReceivablePayableDistributionsReceivablePayableDistributionID->[dbo].[ARAPReceivablePayableDistributions].[ReceivablePayableDistributionID]
FK_ARFinChargeDetailDistributions_ReceivablePayableID_ARAPReceivablePayablesReceivablePayableID->[dbo].[ARAPReceivablePayables].[ReceivablePayableID]
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