CREATE TABLE [dbo].[SCAccrualContracts]
(
[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_SCAccrualContracts_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCAccrualContracts_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[BranchID] [int] NOT NULL,
[JobID] [int] NULL,
[SalesRepID] [int] NULL,
[Void] [bit] NOT NULL CONSTRAINT [DF_SCAccrualContracts_Void] DEFAULT ((0)),
[BaseAccrualCycleID] [int] NULL,
[MGBaseAmount] [money] NOT NULL CONSTRAINT [DF_SCAccrualContracts_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_SCAccrualContracts_AccumulatedCopies] DEFAULT ((0)),
[ExtendedTypeID] [int] NULL,
[LeaseAmount] [money] NOT NULL CONSTRAINT [DF_SCAccrualContracts_LeaseAmount] DEFAULT ((0)),
[PrincipalAmount] [money] NOT NULL CONSTRAINT [DF_SCAccrualContracts_PrincipalAmount] DEFAULT ((0)),
[InterestAmount] [money] NOT NULL CONSTRAINT [DF_SCAccrualContracts_InterestAmount] DEFAULT ((0)),
[LeasePostTermAmount] [money] NOT NULL CONSTRAINT [DF_SCAccrualContracts_LeasePostTermAmount] DEFAULT ((0)),
[DiscAmount] [money] NOT NULL CONSTRAINT [DF_SCAccrualContracts_DiscAmount] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCAccrualContracts] ADD CONSTRAINT [PK_SCAccrualContracts] PRIMARY KEY CLUSTERED ([AccrualID], [ContractDetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCAccrualContracts] ADD CONSTRAINT [FK_SCAccrualContracts_AccrualID_SCAccruals] FOREIGN KEY ([AccrualID]) REFERENCES [dbo].[SCAccruals] ([AccrualID])
GO
ALTER TABLE [dbo].[SCAccrualContracts] ADD CONSTRAINT [FK_SCAccrualContracts_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SCAccrualContracts] ADD CONSTRAINT [FK_SCAccrualContracts_BaseAccrualCycleID_SCBillingCycles] FOREIGN KEY ([BaseAccrualCycleID]) REFERENCES [dbo].[SCBillingCycles] ([BillingCycleID])
GO
ALTER TABLE [dbo].[SCAccrualContracts] ADD CONSTRAINT [FK_SCAccrualContracts_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCAccrualContracts] ADD CONSTRAINT [FK_SCAccrualContracts_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO
ALTER TABLE [dbo].[SCAccrualContracts] ADD CONSTRAINT [FK_SCAccrualContracts_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SCAccrualContracts] ADD CONSTRAINT [FK_SCAccrualContracts_ExtendedTypeID_SCExtendedContractTypes] FOREIGN KEY ([ExtendedTypeID]) REFERENCES [dbo].[SCExtendedContractTypes] ([ExtendedContractTypeID])
GO
ALTER TABLE [dbo].[SCAccrualContracts] ADD CONSTRAINT [FK_SCAccrualContracts_JobID_ICJobs] FOREIGN KEY ([JobID]) REFERENCES [dbo].[ICJobs] ([JobID])
GO
ALTER TABLE [dbo].[SCAccrualContracts] ADD CONSTRAINT [FK_SCAccrualContracts_SalesRepID_ShAgents] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ShAgents] ([AgentID])
GO