CREATE TABLE [dbo].[SAConfigQuoteCreditDetails]
(
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_SAConfigQuoteCreditDetails_CreateDate] DEFAULT (getdate()),
[CreditApp] [xml] NULL,
[CreditAppDate] [datetime] NULL,
[CreditAppID] [int] NULL,
[CreditAppMessage] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreditAppStatus] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreditAppStatusDate] [datetime] NULL,
[CreditUserID] [int] NULL,
[DetailID] [int] NULL,
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SAConfigQuoteCreditDetails_LastUpdate] DEFAULT (getdate()),
[LesseeId] [int] NULL,
[RateAdvPayment] [int] NOT NULL,
[RateCalcPayment] [money] NOT NULL,
[RateCard] [xml] NOT NULL,
[RateID] [int] NOT NULL,
[RateMaintAmount] [money] NOT NULL,
[RateMaintType] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[RatePoints] [int] NOT NULL,
[RatePurchaseOption] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[RateSubmitDate] [datetime] NOT NULL,
[RateTerm] [int] NOT NULL,
[RateUserID] [int] NOT NULL,
[SAConfigQuoteCreditDetailID] [int] NOT NULL IDENTITY(1, 1),
[SAConfigQuoteID] [int] NOT NULL,
[TermsLeasePlan] [int] NULL,
[TermsTotalCost] [money] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAConfigQuoteCreditDetails] ADD CONSTRAINT [FK_SAConfigQuoteCreditDetails_LesseeId_ARCustomers] FOREIGN KEY ([LesseeId]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SAConfigQuoteCreditDetails] ADD CONSTRAINT [FK_SAConfigQuoteCreditDetails_SAConfigQuoteID_SAConfigQuotes] FOREIGN KEY ([SAConfigQuoteID]) REFERENCES [dbo].[SAConfigQuotes] ([ConfigQuoteID])
GO