Tables [dbo].[ARQFinChargeDetailDistributions]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:56:59 AM Thursday, March 21, 2019
Last Modified1:10:22 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK__ARQFinCh__D561E03DE805E732: QFinChargeDetailDistributionIDQFinChargeDetailDistributionIDint4
False
1 - 1
Foreign Keys FK_ARQFinChargeDetailDistributions_CustomerID_ARCustomers: [dbo].[ARCustomers].CustomerIDCustomerIDint4
False
Foreign Keys FK_ARQFinChargeDetailDistributions_InvoiceID_ARInvoices: [dbo].[ARInvoices].InvoiceIDInvoiceIDint4
True
Foreign Keys FK_ARQFinChargeDetailDistributions_ReceiptID_ARReceipts: [dbo].[ARReceipts].ReceiptIDReceiptIDint4
True
Foreign Keys FK_ARQFinChargeDetailDistributions_ReceivablePayableID_ARAPReceivablePayables: [dbo].[ARAPReceivablePayables].ReceivablePayableIDReceivablePayableIDint4
False
Foreign Keys FK_ARQFinChargeDetailDistributions_ReceivablePayableDistributionID_ARAPReceivablePayableDistributions: [dbo].[ARAPReceivablePayableDistributions].ReceivablePayableDistributionIDReceivablePayableDistributionIDint4
False
Descriptionvarchar(255)255
False
Duemoney8
False
AvgDailymoney8
False
CalcAmountmoney8
False
Amountmoney8
False
Foreign Keys FK_ARQFinChargeDetailDistributions_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_ARQFinChargeDetailDistributions_DivisionID_GLDivisions: [dbo].[GLDivisions].DivisionIDDivisionIDint4
False
CreatorIDvarchar(8)8
True
CreateDatedatetime8
False
(getdate())
UpdatorIDvarchar(8)8
True
LastUpdatedatetime8
False
(getdate())
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK__ARQFinCh__D561E03DE805E732: QFinChargeDetailDistributionIDPK__ARQFinCh__D561E03DE805E732QFinChargeDetailDistributionID
True
80
NameColumns
FK_ARQFinChargeDetailDistributions_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_ARQFinChargeDetailDistributions_CustomerID_ARCustomersCustomerID->[dbo].[ARCustomers].[CustomerID]
FK_ARQFinChargeDetailDistributions_DivisionID_GLDivisionsDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_ARQFinChargeDetailDistributions_InvoiceID_ARInvoicesInvoiceID->[dbo].[ARInvoices].[InvoiceID]
FK_ARQFinChargeDetailDistributions_ReceiptID_ARReceiptsReceiptID->[dbo].[ARReceipts].[ReceiptID]
FK_ARQFinChargeDetailDistributions_ReceivablePayableDistributionID_ARAPReceivablePayableDistributionsReceivablePayableDistributionID->[dbo].[ARAPReceivablePayableDistributions].[ReceivablePayableDistributionID]
FK_ARQFinChargeDetailDistributions_ReceivablePayableID_ARAPReceivablePayablesReceivablePayableID->[dbo].[ARAPReceivablePayables].[ReceivablePayableID]
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