Tables [dbo].[ARAPQReceivablePayableDistributions]
PropertyValue
Row Count (~)0
Created12:56:40 AM Thursday, March 21, 2019
Last Modified1:10:00 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK__ARAPQRec__7EFF043E4B3308E9: ReceivablePayableDistributionIDReceivablePayableDistributionIDint4
False
1 - 1
Foreign Keys FK_ARAPQReceivablePayableDistributions_ReceivablePayableID_ARAPQReceivablePayables: [dbo].[ARAPQReceivablePayables].ReceivablePayableIDReceivablePayableIDint4
False
SourceDetailIDint4
True
SourceDetailID2int4
True
Foreign Keys FK_ARAPQReceivablePayableDistributions_GLID_GLAccounts: [dbo].[GLAccounts].GLIDGLIDint4
False
Foreign Keys FK_ARAPQReceivablePayableDistributions_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_ARAPQReceivablePayableDistributions_DivisionID_GLDivisions: [dbo].[GLDivisions].DivisionIDDivisionIDint4
False
Foreign Keys FK_ARAPQReceivablePayableDistributions_BalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].BalanceSheetGroupIDBalanceSheetGroupIDint4
False
GLTypeIDint4
False
DistTypeIDint4
False
Amountmoney8
False
TermDiscountmoney8
False
OpenAmountmoney8
False
Freightmoney8
False
((0))
Discountmoney8
False
((0))
Taxmoney8
False
((0))
Feemoney8
False
((0))
TermDiscountBaseAmountmoney8
False
((0))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK__ARAPQRec__7EFF043E4B3308E9: ReceivablePayableDistributionIDPK__ARAPQRec__7EFF043E4B3308E9ReceivablePayableDistributionID
True
80
NameColumns
FK_ARAPQReceivablePayableDistributions_BalanceSheetGroupID_GLBalanceSheetGroupsBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_ARAPQReceivablePayableDistributions_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_ARAPQReceivablePayableDistributions_DivisionID_GLDivisionsDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_ARAPQReceivablePayableDistributions_GLID_GLAccountsGLID->[dbo].[GLAccounts].[AccountID]
FK_ARAPQReceivablePayableDistributions_ReceivablePayableID_ARAPQReceivablePayablesReceivablePayableID->[dbo].[ARAPQReceivablePayables].[ReceivablePayableID]
CREATE TABLE [dbo].[ARAPQReceivablePayableDistributions]
(
[ReceivablePayableDistributionID] [int] NOT NULL IDENTITY(1, 1),
[ReceivablePayableID] [int] NOT NULL,
[SourceDetailID] [int] NULL,
[SourceDetailID2] [int] NULL,
[GLID] [int] NOT NULL,
[BranchID] [int] NOT NULL,
[DivisionID] [int] NOT NULL,
[BalanceSheetGroupID] [int] NOT NULL,
[GLTypeID] [int] NOT NULL,
[DistTypeID] [int] NOT NULL,
[Amount] [money] NOT NULL,
[TermDiscount] [money] NOT NULL,
[OpenAmount] [money] NOT NULL,
[Freight] [money] NOT NULL CONSTRAINT [DF_ARAPQReceivablePayableDistributions_Freight] DEFAULT ((0)),
[Discount] [money] NOT NULL CONSTRAINT [DF_ARAPQReceivablePayableDistributions_Discount] DEFAULT ((0)),
[Tax] [money] NOT NULL CONSTRAINT [DF_ARAPQReceivablePayableDistributions_Tax] DEFAULT ((0)),
[Fee] [money] NOT NULL CONSTRAINT [DF_ARAPQReceivablePayableDistributions_Fee] DEFAULT ((0)),
[TermDiscountBaseAmount] [money] NOT NULL CONSTRAINT [DF_ARAPQReceivablePayableDistributions_TermDiscountBaseAmount] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARAPQReceivablePayableDistributions] ADD CONSTRAINT [PK__ARAPQRec__7EFF043E4B3308E9] PRIMARY KEY CLUSTERED  ([ReceivablePayableDistributionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARAPQReceivablePayableDistributions] ADD CONSTRAINT [FK_ARAPQReceivablePayableDistributions_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[ARAPQReceivablePayableDistributions] ADD CONSTRAINT [FK_ARAPQReceivablePayableDistributions_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[ARAPQReceivablePayableDistributions] ADD CONSTRAINT [FK_ARAPQReceivablePayableDistributions_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[ARAPQReceivablePayableDistributions] ADD CONSTRAINT [FK_ARAPQReceivablePayableDistributions_GLID_GLAccounts] FOREIGN KEY ([GLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[ARAPQReceivablePayableDistributions] ADD CONSTRAINT [FK_ARAPQReceivablePayableDistributions_ReceivablePayableID_ARAPQReceivablePayables] FOREIGN KEY ([ReceivablePayableID]) REFERENCES [dbo].[ARAPQReceivablePayables] ([ReceivablePayableID])
GO