Tables [dbo].[SCLeaseAmortizations]
PropertyValue
Row Count (~)0
Created12:59:20 AM Thursday, March 21, 2019
Last Modified1:08:09 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK__SCLeaseA__C829B67664219DFC: LeaseAmortizationIDLeaseAmortizationIDint4
False
1 - 1
LinkIDint4
False
Orderint4
False
ExpectedPaymentmoney8
False
ExpectedDatedatetime8
False
AllocatedPrincipalmoney8
False
AllocatedInterestmoney8
False
EndBalancemoney8
False
InvoiceIDint4
True
ReceiptIDint4
True
PaymentMadebit1
False
((0))
Buyoutbit1
True
ActualPaidAmountmoney8
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK__SCLeaseA__C829B67664219DFC: LeaseAmortizationIDPK__SCLeaseA__C829B67664219DFCLeaseAmortizationID
True
80
CREATE TABLE [dbo].[SCLeaseAmortizations]
(
[LeaseAmortizationID] [int] NOT NULL IDENTITY(1, 1),
[LinkID] [int] NOT NULL,
[Order] [int] NOT NULL,
[ExpectedPayment] [money] NOT NULL,
[ExpectedDate] [datetime] NOT NULL,
[AllocatedPrincipal] [money] NOT NULL,
[AllocatedInterest] [money] NOT NULL,
[EndBalance] [money] NOT NULL,
[InvoiceID] [int] NULL,
[ReceiptID] [int] NULL,
[PaymentMade] [bit] NOT NULL CONSTRAINT [DF_SCLeaseAmortizations_PaymentMade] DEFAULT ((0)),
[Buyout] [bit] NULL,
[ActualPaidAmount] [money] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCLeaseAmortizations] ADD CONSTRAINT [PK__SCLeaseA__C829B67664219DFC] PRIMARY KEY CLUSTERED  ([LeaseAmortizationID]) ON [PRIMARY]
GO