CREATE TABLE [dbo].[SCContractLeaseDetailsImport]
(
[ContractLeaseImportID] [int] NOT NULL,
[ContractLeaseID] [int] NOT NULL,
[CustomerName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CustomerAddress1] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerAddress2] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerPhone] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ApplicationNumber] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AgreementNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OriginalCost] [money] NULL,
[EquipmentPayment] [money] NULL,
[PaymentsRemaining] [int] NULL,
[OutstandingBalance] [money] NULL,
[AgreementTerms] [int] NULL,
[FundingDate] [datetime] NULL,
[MaturityDate] [datetime] NULL,
[LeaseEndOption] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ProgramType] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ClientEquipmentNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Model] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Serialnumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AssetEquipPayment] [money] NULL,
[EquipAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ServicePayment] [money] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCContractLeaseDetailsImport] ADD CONSTRAINT [PK_SCContractLeaseDetailsImport] PRIMARY KEY CLUSTERED ([ContractLeaseImportID]) ON [PRIMARY]
GO