Tables [dbo].[SCAccrualLeases]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:59:04 AM Thursday, March 21, 2019
Last Modified1:14:23 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_SCAccrualLeases: AccrualID\ContractDetailID\DetailIDForeign Keys FK_SCAccrualLeases_AccrualID_SCAccrualContracts: [dbo].[SCAccrualContracts].AccrualID\ContractDetailIDAccrualIDint4
False
Cluster Primary Key PK_SCAccrualLeases: AccrualID\ContractDetailID\DetailIDForeign Keys FK_SCAccrualLeases_AccrualID_SCAccrualContracts: [dbo].[SCAccrualContracts].AccrualID\ContractDetailIDContractDetailIDint4
False
Cluster Primary Key PK_SCAccrualLeases: AccrualID\ContractDetailID\DetailIDDetailIDint4
False
Foreign Keys FK_SCAccrualLeases_BillingGLID_GLAccounts: [dbo].[GLAccounts].BillingGLIDBillingGLIDint4
False
Foreign Keys FK_SCAccrualLeases_BillingDeptID_GLDepts: [dbo].[GLDepts].BillingDeptIDBillingDeptIDint4
True
Foreign Keys FK_SCAccrualLeases_AccrualGLID_GLAccounts: [dbo].[GLAccounts].AccrualGLIDAccrualGLIDint4
False
Foreign Keys FK_SCAccrualLeases_AccrualDeptID_GLDepts: [dbo].[GLDepts].AccrualDeptIDAccrualDeptIDint4
True
Amountmoney8
False
Foreign Keys FK_SCAccrualLeases_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_SCAccrualLeases_DivisionID_GLDivisions: [dbo].[GLDivisions].DivisionIDDivisionIDint4
False
Foreign Keys FK_SCAccrualLeases_BalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].BalanceSheetGroupIDBalanceSheetGroupIDint4
False
DistCodeIDint4
True
Distributiondecimal(18,6)9
False
Foreign Keys FK_SCAccrualLeases_DistCodeDetailTypeID_SCContractBaseDistCodeDetailTypes: [dbo].[SCContractBaseDistCodeDetailTypes].DistCodeDetailTypeIDDistCodeDetailTypeIDint4
False
((1))
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCAccrualLeases: AccrualID\ContractDetailID\DetailIDPK_SCAccrualLeasesAccrualID, ContractDetailID, DetailID
True
80
NameColumns
FK_SCAccrualLeases_AccrualDeptID_GLDeptsAccrualDeptID->[dbo].[GLDepts].[DeptID]
FK_SCAccrualLeases_AccrualGLID_GLAccountsAccrualGLID->[dbo].[GLAccounts].[AccountID]
FK_SCAccrualLeases_AccrualID_SCAccrualContractsAccrualID->[dbo].[SCAccrualContracts].[AccrualID]
ContractDetailID->[dbo].[SCAccrualContracts].[ContractDetailID]
FK_SCAccrualLeases_BalanceSheetGroupID_GLBalanceSheetGroupsBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_SCAccrualLeases_BillingDeptID_GLDeptsBillingDeptID->[dbo].[GLDepts].[DeptID]
FK_SCAccrualLeases_BillingGLID_GLAccountsBillingGLID->[dbo].[GLAccounts].[AccountID]
FK_SCAccrualLeases_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_SCAccrualLeases_DistCodeDetailTypeID_SCContractBaseDistCodeDetailTypesDistCodeDetailTypeID->[dbo].[SCContractBaseDistCodeDetailTypes].[BaseDistCodeDetailTypeID]
FK_SCAccrualLeases_DivisionID_GLDivisionsDivisionID->[dbo].[GLDivisions].[DivisionID]
CREATE TABLE [dbo].[SCAccrualLeases]
(
[AccrualID] [int] NOT NULL,
[ContractDetailID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[BillingGLID] [int] NOT NULL,
[BillingDeptID] [int] NULL,
[AccrualGLID] [int] NOT NULL,
[AccrualDeptID] [int] NULL,
[Amount] [money] NOT NULL,
[BranchID] [int] NOT NULL,
[DivisionID] [int] NOT NULL,
[BalanceSheetGroupID] [int] NOT NULL,
[DistCodeID] [int] NULL,
[Distribution] [decimal] (18, 6) NOT NULL,
[DistCodeDetailTypeID] [int] NOT NULL CONSTRAINT [DF_SCAccrualLeases_DistCodeDetailTypeID] DEFAULT ((1)),
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_SCAccrualLeases_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCAccrualLeases_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCAccrualLeases] ADD CONSTRAINT [PK_SCAccrualLeases] PRIMARY KEY CLUSTERED  ([AccrualID], [ContractDetailID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCAccrualLeases] ADD CONSTRAINT [FK_SCAccrualLeases_AccrualDeptID_GLDepts] FOREIGN KEY ([AccrualDeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[SCAccrualLeases] ADD CONSTRAINT [FK_SCAccrualLeases_AccrualGLID_GLAccounts] FOREIGN KEY ([AccrualGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[SCAccrualLeases] ADD CONSTRAINT [FK_SCAccrualLeases_AccrualID_SCAccrualContracts] FOREIGN KEY ([AccrualID], [ContractDetailID]) REFERENCES [dbo].[SCAccrualContracts] ([AccrualID], [ContractDetailID])
GO
ALTER TABLE [dbo].[SCAccrualLeases] ADD CONSTRAINT [FK_SCAccrualLeases_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SCAccrualLeases] ADD CONSTRAINT [FK_SCAccrualLeases_BillingDeptID_GLDepts] FOREIGN KEY ([BillingDeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[SCAccrualLeases] ADD CONSTRAINT [FK_SCAccrualLeases_BillingGLID_GLAccounts] FOREIGN KEY ([BillingGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[SCAccrualLeases] ADD CONSTRAINT [FK_SCAccrualLeases_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCAccrualLeases] ADD CONSTRAINT [FK_SCAccrualLeases_DistCodeDetailTypeID_SCContractBaseDistCodeDetailTypes] FOREIGN KEY ([DistCodeDetailTypeID]) REFERENCES [dbo].[SCContractBaseDistCodeDetailTypes] ([BaseDistCodeDetailTypeID])
GO
ALTER TABLE [dbo].[SCAccrualLeases] ADD CONSTRAINT [FK_SCAccrualLeases_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO