Tables [dbo].[SAConfigQuoteCreditDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:58:57 AM Thursday, March 21, 2019
Last Modified1:14:09 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
CreateDatedatetime8
False
(getdate())
CreditAppxmlmax
True
CreditAppDatedatetime8
True
CreditAppIDint4
True
CreditAppMessagevarchar(max)max
True
CreditAppStatusnvarchar(50)100
True
CreditAppStatusDatedatetime8
True
CreditUserIDint4
True
DetailIDint4
True
LastUpdatedatetime8
False
(getdate())
Foreign Keys FK_SAConfigQuoteCreditDetails_LesseeId_ARCustomers: [dbo].[ARCustomers].LesseeIdLesseeIdint4
True
RateAdvPaymentint4
False
RateCalcPaymentmoney8
False
RateCardxmlmax
False
RateIDint4
False
RateMaintAmountmoney8
False
RateMaintTypenvarchar(50)100
False
RatePointsint4
False
RatePurchaseOptionnvarchar(50)100
False
RateSubmitDatedatetime8
False
RateTermint4
False
RateUserIDint4
False
SAConfigQuoteCreditDetailIDint4
False
1 - 1
Foreign Keys FK_SAConfigQuoteCreditDetails_SAConfigQuoteID_SAConfigQuotes: [dbo].[SAConfigQuotes].SAConfigQuoteIDSAConfigQuoteIDint4
False
TermsLeasePlanint4
True
TermsTotalCostmoney8
True
NameColumns
FK_SAConfigQuoteCreditDetails_LesseeId_ARCustomersLesseeId->[dbo].[ARCustomers].[CustomerID]
FK_SAConfigQuoteCreditDetails_SAConfigQuoteID_SAConfigQuotesSAConfigQuoteID->[dbo].[SAConfigQuotes].[ConfigQuoteID]
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