Tables [dbo].[SCQAccrualContracts]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:59:33 AM Thursday, March 21, 2019
Last Modified1:15:12 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_SCQAccrualContracts: AccrualID\ContractDetailIDForeign Keys FK_SCQAccrualContracts_AccrualID_SCQAccruals: [dbo].[SCQAccruals].AccrualIDAccrualIDint4
False
Cluster Primary Key PK_SCQAccrualContracts: AccrualID\ContractDetailIDContractDetailIDint4
False
Foreign Keys FK_SCQAccrualContracts_ContractID_SCContracts: [dbo].[SCContracts].ContractIDContractIDint4
False
BaseFromDatedatetime8
True
BaseToDatedatetime8
True
SumIndividualBaseRatesbit1
False
BaseAmountmoney8
False
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
Foreign Keys FK_SCQAccrualContracts_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_SCQAccrualContracts_JobID_ICJobs: [dbo].[ICJobs].JobIDJobIDint4
True
Foreign Keys FK_SCQAccrualContracts_SalesRepID_ShAgents: [dbo].[ShAgents].SalesRepIDSalesRepIDint4
True
Foreign Keys FK_SCQAccrualContracts_BaseAccrualCycleID_SCBillingCycles: [dbo].[SCBillingCycles].BaseAccrualCycleIDBaseAccrualCycleIDint4
True
MGBaseAmountmoney8
False
((0))
NonAdjustedBaseLastAccrualDatedatetime8
True
NonAdjustedBaseNextAccrualDatedatetime8
True
BaseCyclesAccruedint4
False
Foreign Keys FK_SCQAccrualContracts_DivisionID_GLDivisions: [dbo].[GLDivisions].DivisionIDDivisionIDint4
False
Foreign Keys FK_SCQAccrualContracts_BalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].BalanceSheetGroupIDBalanceSheetGroupIDint4
False
NonAdjustedBaseAccrualStartDatedatetime8
True
AccumulatedCopiesdecimal(18,6)9
False
((0))
Foreign Keys FK_SCQAccrualContracts_ExtendedTypeID_SCExtendedContractTypes: [dbo].[SCExtendedContractTypes].ExtendedTypeIDExtendedTypeIDint4
True
LeaseAmountmoney8
False
((0))
PrincipalAmountmoney8
False
((0))
InterestAmountmoney8
False
((0))
LeasePostTermAmountmoney8
False
((0))
DiscAmountmoney8
False
((0))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCQAccrualContracts: AccrualID\ContractDetailIDPK_SCQAccrualContractsAccrualID, ContractDetailID
True
80
NameColumns
FK_SCQAccrualContracts_AccrualID_SCQAccrualsAccrualID->[dbo].[SCQAccruals].[AccrualID]
FK_SCQAccrualContracts_BalanceSheetGroupID_GLBalanceSheetGroupsBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_SCQAccrualContracts_BaseAccrualCycleID_SCBillingCyclesBaseAccrualCycleID->[dbo].[SCBillingCycles].[BillingCycleID]
FK_SCQAccrualContracts_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_SCQAccrualContracts_ContractID_SCContractsContractID->[dbo].[SCContracts].[ContractID]
FK_SCQAccrualContracts_DivisionID_GLDivisionsDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_SCQAccrualContracts_ExtendedTypeID_SCExtendedContractTypesExtendedTypeID->[dbo].[SCExtendedContractTypes].[ExtendedContractTypeID]
FK_SCQAccrualContracts_JobID_ICJobsJobID->[dbo].[ICJobs].[JobID]
FK_SCQAccrualContracts_SalesRepID_ShAgentsSalesRepID->[dbo].[ShAgents].[AgentID]
CREATE TABLE [dbo].[SCQAccrualContracts]
(
[AccrualID] [int] NOT NULL,
[ContractDetailID] [int] NOT NULL,
[ContractID] [int] NOT NULL,
[BaseFromDate] [datetime] NULL,
[BaseToDate] [datetime] NULL,
[SumIndividualBaseRates] [bit] NOT NULL,
[BaseAmount] [money] NOT NULL,
[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_SCQAccrualContracts_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCQAccrualContracts_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[BranchID] [int] NOT NULL,
[JobID] [int] NULL,
[SalesRepID] [int] NULL,
[BaseAccrualCycleID] [int] NULL,
[MGBaseAmount] [money] NOT NULL CONSTRAINT [DF_SCQAccrualContracts_MGBaseAmount] DEFAULT ((0)),
[NonAdjustedBaseLastAccrualDate] [datetime] NULL,
[NonAdjustedBaseNextAccrualDate] [datetime] NULL,
[BaseCyclesAccrued] [int] NOT NULL,
[DivisionID] [int] NOT NULL,
[BalanceSheetGroupID] [int] NOT NULL,
[NonAdjustedBaseAccrualStartDate] [datetime] NULL,
[AccumulatedCopies] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCQAccrualContracts_AccumulatedCopies] DEFAULT ((0)),
[ExtendedTypeID] [int] NULL,
[LeaseAmount] [money] NOT NULL CONSTRAINT [DF_SCQAccrualContracts_LeaseAmount] DEFAULT ((0)),
[PrincipalAmount] [money] NOT NULL CONSTRAINT [DF_SCQAccrualContracts_PrincipalAmount] DEFAULT ((0)),
[InterestAmount] [money] NOT NULL CONSTRAINT [DF_SCQAccrualContracts_InterestAmount] DEFAULT ((0)),
[LeasePostTermAmount] [money] NOT NULL CONSTRAINT [DF_SCQAccrualContracts_LeasePostTermAmount] DEFAULT ((0)),
[DiscAmount] [money] NOT NULL CONSTRAINT [DF_SCQAccrualContracts_DiscAmount] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQAccrualContracts] ADD CONSTRAINT [PK_SCQAccrualContracts] PRIMARY KEY CLUSTERED  ([AccrualID], [ContractDetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQAccrualContracts] ADD CONSTRAINT [FK_SCQAccrualContracts_AccrualID_SCQAccruals] FOREIGN KEY ([AccrualID]) REFERENCES [dbo].[SCQAccruals] ([AccrualID])
GO
ALTER TABLE [dbo].[SCQAccrualContracts] ADD CONSTRAINT [FK_SCQAccrualContracts_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SCQAccrualContracts] ADD CONSTRAINT [FK_SCQAccrualContracts_BaseAccrualCycleID_SCBillingCycles] FOREIGN KEY ([BaseAccrualCycleID]) REFERENCES [dbo].[SCBillingCycles] ([BillingCycleID])
GO
ALTER TABLE [dbo].[SCQAccrualContracts] ADD CONSTRAINT [FK_SCQAccrualContracts_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCQAccrualContracts] ADD CONSTRAINT [FK_SCQAccrualContracts_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO
ALTER TABLE [dbo].[SCQAccrualContracts] ADD CONSTRAINT [FK_SCQAccrualContracts_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SCQAccrualContracts] ADD CONSTRAINT [FK_SCQAccrualContracts_ExtendedTypeID_SCExtendedContractTypes] FOREIGN KEY ([ExtendedTypeID]) REFERENCES [dbo].[SCExtendedContractTypes] ([ExtendedContractTypeID])
GO
ALTER TABLE [dbo].[SCQAccrualContracts] ADD CONSTRAINT [FK_SCQAccrualContracts_JobID_ICJobs] FOREIGN KEY ([JobID]) REFERENCES [dbo].[ICJobs] ([JobID])
GO
ALTER TABLE [dbo].[SCQAccrualContracts] ADD CONSTRAINT [FK_SCQAccrualContracts_SalesRepID_ShAgents] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ShAgents] ([AgentID])
GO