CREATE TABLE [dbo].[SCAccrualEquipments]
(
[AccrualID] [int] NOT NULL,
[ContractDetailID] [int] NOT NULL,
[EquipmentDetailID] [int] NOT NULL,
[EquipmentID] [int] 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_SCAccrualEquipments_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCAccrualEquipments_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[BaseFromDate] [datetime] NULL,
[BaseToDate] [datetime] NULL,
[SCContractDetailID] [int] NULL,
[DistCodeID] [int] NULL,
[BranchID] [int] NOT NULL,
[DivisionID] [int] NOT NULL,
[BalanceSheetGroupID] [int] NOT NULL,
[BillBaseFromDate] [datetime] NULL,
[BillBaseToDate] [datetime] NULL,
[LeaseAmount] [money] NOT NULL CONSTRAINT [DF_SCAccrualEquipments_LeaseAmount] DEFAULT ((0)),
[PrincipalAmount] [money] NOT NULL CONSTRAINT [DF_SCAccrualEquipments_PrincipalAmount] DEFAULT ((0)),
[InterestAmount] [money] NOT NULL CONSTRAINT [DF_SCAccrualEquipments_InterestAmount] DEFAULT ((0)),
[LeasePostTermAmount] [money] NOT NULL CONSTRAINT [DF_SCAccrualEquipments_LeasePostTermAmount] DEFAULT ((0)),
[ContractDetailTypeID] [int] NOT NULL CONSTRAINT [DF_SCAccrualEquipments_ContractDetailTypeID] DEFAULT ((1)),
[SCContractDetailInstance] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCAccrualEquipments_SCContractDetailInstance] DEFAULT ((0)),
[BaseAccrualTypeID] [int] NOT NULL CONSTRAINT [DF_SCAccrualEquipments_BaseAccrualTypeID] DEFAULT ((1)),
[ItemID] [int] NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCAccrualEquipments_Description] DEFAULT (''),
[LocationID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCAccrualEquipments] ADD CONSTRAINT [PK_SCAccrualEquipments] PRIMARY KEY CLUSTERED ([AccrualID], [ContractDetailID], [EquipmentDetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCAccrualEquipments] ADD CONSTRAINT [FK_SCAccrualEquipments_AccrualID_SCAccrualContracts] FOREIGN KEY ([AccrualID], [ContractDetailID]) REFERENCES [dbo].[SCAccrualContracts] ([AccrualID], [ContractDetailID])
GO
ALTER TABLE [dbo].[SCAccrualEquipments] ADD CONSTRAINT [FK_SCAccrualEquipments_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SCAccrualEquipments] ADD CONSTRAINT [FK_SCAccrualEquipments_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCAccrualEquipments] ADD CONSTRAINT [FK_SCAccrualEquipments_ContractDetailTypeID_SCContractDetailTypes] FOREIGN KEY ([ContractDetailTypeID]) REFERENCES [dbo].[SCContractDetailTypes] ([ContractDetailTypeID])
GO
ALTER TABLE [dbo].[SCAccrualEquipments] ADD CONSTRAINT [FK_SCAccrualEquipments_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SCAccrualEquipments] ADD CONSTRAINT [FK_SCAccrualEquipments_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SCAccrualEquipments] ADD CONSTRAINT [FK_SCAccrualEquipments_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[SCAccrualEquipments] ADD CONSTRAINT [FK_SCAccrualEquipments_LocationID_ARCustomers] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCAccrualEquipments] ADD CONSTRAINT [FK_SCAccrualEquipments_SCContractDetailID_SCContractDetails] FOREIGN KEY ([SCContractDetailID]) REFERENCES [dbo].[SCContractDetails] ([ContractDetailID])
GO