Tables [dbo].[SAConfigQuoteLeaseOptions]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:58:58 AM Thursday, March 21, 2019
Last Modified1:14:12 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_SAConfigQuoteLeaseOptions: ConfigQuoteID\DetailIDForeign Keys FK_SAConfigQuoteLeaseOptions_ConfigQuoteID_SAConfigQuotes: [dbo].[SAConfigQuotes].ConfigQuoteIDConfigQuoteIDint4
False
Cluster Primary Key PK_SAConfigQuoteLeaseOptions: ConfigQuoteID\DetailIDDetailIDint4
False
1 - 1
Selectedbit1
False
LeasingTermIDint4
True
LeaseCompanyvarchar(50)50
False
LeaseNamevarchar(50)50
False
PurchaseOptionvarchar(50)50
False
TermMonthstinyint1
False
LeaseFactordecimal(10,6)9
False
MinLeaseAmountmoney8
False
LeasePointsdecimal(10,6)9
True
LeasePaymentmoney8
True
PrintOptionbit1
False
DetailLeaseTermDetailsint4
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SAConfigQuoteLeaseOptions: ConfigQuoteID\DetailIDPK_SAConfigQuoteLeaseOptionsConfigQuoteID, DetailID
True
80
NameColumns
FK_SAConfigQuoteLeaseOptions_ConfigQuoteID_SAConfigQuotesConfigQuoteID->[dbo].[SAConfigQuotes].[ConfigQuoteID]
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