CREATE TABLE [dbo].[SCContractLeases]
(
[ContractLeaseID] [int] NOT NULL IDENTITY(1, 1),
[LeaseNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LeaseCodeID] [int] NOT NULL,
[Term] [int] NOT NULL,
[DepositAmount] [money] NOT NULL,
[FinancedAmount] [money] NOT NULL,
[PaymentAmount] [money] NOT NULL,
[InterestRate] [decimal] (16, 6) NOT NULL,
[GLAccountID] [int] NULL,
[GLDeptID] [int] NULL,
[TaxFlag] [int] NULL,
[Inventory] [money] NOT NULL,
[Purchases] [money] NOT NULL,
[TerminationDate] [datetime] NULL,
[StartDate] [datetime] NOT NULL,
[TerminationCodeID] [int] NULL,
[BuyoutLeaseID] [int] NULL,
[Notes] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PayoffBeforeDeposit] [money] NULL,
[DepositReturned] [money] NULL,
[GLAdjustmentsCompletedDate] [datetime] NULL,
[Locked] [bit] NOT NULL CONSTRAINT [DF_SCContractLeases_Locked] DEFAULT ((0)),
[Active] [bit] NOT NULL CONSTRAINT [DF_SCContractLeases_Active] 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_SCContractLeases_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCContractLeases_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[LeaseCompanyID] [int] NOT NULL,
[CustomerID] [int] NOT NULL,
[DBFileHeaderID] [int] NOT NULL CONSTRAINT [DF_SCContractLeases_DBFileHeaderID] DEFAULT ((1)),
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_SCContractLeases_NoteFlag] DEFAULT ((0)),
[UseIndividualTaxCodes] [bit] NOT NULL CONSTRAINT [DF_SCContractLeases_UseIndividualTaxCodes] DEFAULT ((0)),
[SumIndividualAmounts] [bit] NOT NULL CONSTRAINT [DF_SCContractLeases_SumIndividualAmounts] DEFAULT ((0)),
[NoteCount] [int] NOT NULL CONSTRAINT [DF_SCContractLeases_NoteCount] DEFAULT ((0)),
[TaxFlagID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCContractLeases] ADD CONSTRAINT [PK__SCContra__80D303B775FABE7F] PRIMARY KEY CLUSTERED ([ContractLeaseID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCContractLeases] WITH NOCHECK ADD CONSTRAINT [FK_SCContractLeases_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCContractLeases] ADD CONSTRAINT [FK_SCContractLeases_GLAccountID_GLAccounts] FOREIGN KEY ([GLAccountID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[SCContractLeases] ADD CONSTRAINT [FK_SCContractLeases_GLDeptID_GLDepts] FOREIGN KEY ([GLDeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[SCContractLeases] ADD CONSTRAINT [FK_SCContractLeases_LeaseCodeID_SCLeaseCodes] FOREIGN KEY ([LeaseCodeID]) REFERENCES [dbo].[SCLeaseCodes] ([LeaseCodeID])
GO
ALTER TABLE [dbo].[SCContractLeases] WITH NOCHECK ADD CONSTRAINT [FK_SCContractLeases_LeaseCompanyID_ARCustomers] FOREIGN KEY ([LeaseCompanyID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCContractLeases] ADD CONSTRAINT [FK_SCContractLeases_NoteID_SCContractLeaseNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[SCContractLeaseNotes] ([NoteID])
GO
ALTER TABLE [dbo].[SCContractLeases] ADD CONSTRAINT [FK_SCContractLeases_TaxFlagID_ShTaxFlags] FOREIGN KEY ([TaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO