Tables [dbo].[SOS_Leasing]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created1:00:51 AM Thursday, March 21, 2019
Last Modified1:00:51 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow Nulls
Account Numberchar(20)20
False
Customer Namevarchar(50)50
True
Address1varchar(50)50
True
Address3varchar(50)50
True
Cityvarchar(50)50
True
Statevarchar(10)10
True
Zipvarchar(10)10
True
EndDatevarchar(10)10
True
PurchaseDatevarchar(10)10
True
AssetDescvarchar(50)50
True
Modelvarchar(50)50
True
SerialNumbervarchar(50)50
True
Rentnumeric(18,0)9
True
Remainingnumeric(18,0)9
True
OriginalTermnumeric(18,0)9
True
PurchaseOptionvarchar(20)20
True
AsOfDatedatetime8
True
CustomerIDint4
True
EquipmentIDint4
True
ItemIdint4
True
CREATE TABLE [dbo].[SOS_Leasing]
(
[Account Number] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Customer Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Address1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Address3] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[City] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[State] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Zip] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EndDate] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PurchaseDate] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AssetDesc] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Model] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SerialNumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Rent] [numeric] (18, 0) NULL,
[Remaining] [numeric] (18, 0) NULL,
[OriginalTerm] [numeric] (18, 0) NULL,
[PurchaseOption] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AsOfDate] [datetime] NULL,
[CustomerID] [int] NULL,
[EquipmentID] [int] NULL,
[ItemId] [int] NULL
) ON [PRIMARY]
GO