CREATE TABLE [dbo].[SAConfigQuoteLeaseOptions]
(
[ConfigQuoteID] [int] NOT NULL,
[DetailID] [int] NOT NULL IDENTITY(1, 1),
[Selected] [bit] NOT NULL,
[LeasingTermID] [int] NULL,
[LeaseCompany] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LeaseName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PurchaseOption] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TermMonths] [tinyint] NOT NULL,
[LeaseFactor] [decimal] (10, 6) NOT NULL,
[MinLeaseAmount] [money] NOT NULL,
[LeasePoints] [decimal] (10, 6) NULL,
[LeasePayment] [money] NULL,
[PrintOption] [bit] NOT NULL,
[DetailLeaseTermDetails] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAConfigQuoteLeaseOptions] ADD CONSTRAINT [PK_SAConfigQuoteLeaseOptions] PRIMARY KEY CLUSTERED ([ConfigQuoteID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAConfigQuoteLeaseOptions] ADD CONSTRAINT [FK_SAConfigQuoteLeaseOptions_ConfigQuoteID_SAConfigQuotes] FOREIGN KEY ([ConfigQuoteID]) REFERENCES [dbo].[SAConfigQuotes] ([ConfigQuoteID])
GO