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