Tables [dbo].[SOSLeaseExpGE]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created1:00:53 AM Thursday, March 21, 2019
Last Modified1:00:53 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow Nulls
Account Numbervarchar(50)50
True
Customervarchar(50)50
True
Address1varchar(50)50
True
Address2varchar(50)50
True
Address3varchar(50)50
True
Cityvarchar(30)30
True
Statevarchar(10)10
True
Zipvarchar(15)15
True
EndDateTextvarchar(8)8
True
StartDatetextvarchar(8)8
True
Asset_Descriptionvarchar(50)50
True
Modelvarchar(50)50
True
Serial_Numbervarchar(50)50
True
Rentvarchar(50)50
True
Remainingvarchar(8)8
True
OriginalTermsvarchar(4)4
True
PurchaseOptionvarchar(50)50
True
AsOfDatedatetime8
True
EquipmentIDint4
True
ContractIDint4
True
TerritoryIDchar(10)10
True
CustomerIDint4
True
SalesRepIDint4
True
ModelIDint4
True
Reviewedbit1
True
Startdatedatetime8
True
Enddatedatetime8
True
GEIDuniqueidentifier16
True
CREATE TABLE [dbo].[SOSLeaseExpGE]
(
[Account Number] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Customer] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Address1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Address2] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Address3] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[City] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[State] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Zip] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EndDateText] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StartDatetext] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Asset_Description] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Model] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Serial_Number] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Rent] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Remaining] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OriginalTerms] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PurchaseOption] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AsOfDate] [datetime] NULL,
[EquipmentID] [int] NULL,
[ContractID] [int] NULL,
[TerritoryID] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerID] [int] NULL,
[SalesRepID] [int] NULL,
[ModelID] [int] NULL,
[Reviewed] [bit] NULL,
[Startdate] [datetime] NULL,
[Enddate] [datetime] NULL,
[GEID] [uniqueidentifier] NULL
) ON [PRIMARY]
GO