Tables [dbo].[SCContractLeaseDetailsImport]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:59:13 AM Thursday, March 21, 2019
Last Modified12:59:13 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_SCContractLeaseDetailsImport: ContractLeaseImportIDContractLeaseImportIDint4
False
ContractLeaseIDint4
False
CustomerNamevarchar(128)128
False
CustomerAddress1varchar(64)64
True
CustomerAddress2varchar(64)64
True
CustomerCityvarchar(32)32
True
CustomerStatevarchar(16)16
True
CustomerZipvarchar(16)16
True
CustomerCountryvarchar(16)16
True
CustomerPhonevarchar(20)20
True
ApplicationNumbervarchar(12)12
True
AgreementNumbervarchar(32)32
True
OriginalCostmoney8
True
EquipmentPaymentmoney8
True
PaymentsRemainingint4
True
OutstandingBalancemoney8
True
AgreementTermsint4
True
FundingDatedatetime8
True
MaturityDatedatetime8
True
LeaseEndOptionvarchar(50)50
True
ProgramTypevarchar(50)50
True
ClientEquipmentNumbervarchar(32)32
True
Modelvarchar(64)64
True
Serialnumbervarchar(30)30
True
AssetEquipPaymentmoney8
True
EquipAddressvarchar(64)64
True
EquipCityvarchar(32)32
True
EquipStatevarchar(16)16
True
EquipZipvarchar(16)16
True
ServicePaymentmoney8
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCContractLeaseDetailsImport: ContractLeaseImportIDPK_SCContractLeaseDetailsImportContractLeaseImportID
True
80
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