Property | Value |
---|---|
Collation | SQL_Latin1_General_CP1_CI_AS |
Heap | True |
Row Count (~) | 0 |
Created | 1:00:53 AM Thursday, March 21, 2019 |
Last Modified | 1:00:53 AM Thursday, March 21, 2019 |
Name | Data Type | Max Length (Bytes) | Allow Nulls |
---|---|---|---|
Account Number | varchar(50) | 50 | True |
Customer | varchar(50) | 50 | True |
Address1 | varchar(50) | 50 | True |
Address2 | varchar(50) | 50 | True |
Address3 | varchar(50) | 50 | True |
City | varchar(30) | 30 | True |
State | varchar(10) | 10 | True |
Zip | varchar(15) | 15 | True |
EndDateText | varchar(8) | 8 | True |
StartDatetext | varchar(8) | 8 | True |
Asset_Description | varchar(50) | 50 | True |
Model | varchar(50) | 50 | True |
Serial_Number | varchar(50) | 50 | True |
Rent | varchar(50) | 50 | True |
Remaining | varchar(8) | 8 | True |
OriginalTerms | varchar(4) | 4 | True |
PurchaseOption | varchar(50) | 50 | True |
AsOfDate | datetime | 8 | True |
EquipmentID | int | 4 | True |
ContractID | int | 4 | True |
TerritoryID | char(10) | 10 | True |
CustomerID | int | 4 | True |
SalesRepID | int | 4 | True |
ModelID | int | 4 | True |
Reviewed | bit | 1 | True |
Startdate | datetime | 8 | True |
Enddate | datetime | 8 | True |
GEID | uniqueidentifier | 16 | True |