Property | Value |
---|---|
Collation | SQL_Latin1_General_CP1_CI_AS |
Heap | True |
Row Count (~) | 0 |
Created | 1:00:51 AM Thursday, March 21, 2019 |
Last Modified | 1:00:51 AM Thursday, March 21, 2019 |
Name | Data Type | Max Length (Bytes) | Allow Nulls |
---|---|---|---|
Account Number | char(20) | 20 | False |
Customer Name | varchar(50) | 50 | True |
Address1 | varchar(50) | 50 | True |
Address3 | varchar(50) | 50 | True |
City | varchar(50) | 50 | True |
State | varchar(10) | 10 | True |
Zip | varchar(10) | 10 | True |
EndDate | varchar(10) | 10 | True |
PurchaseDate | varchar(10) | 10 | True |
AssetDesc | varchar(50) | 50 | True |
Model | varchar(50) | 50 | True |
SerialNumber | varchar(50) | 50 | True |
Rent | numeric(18,0) | 9 | True |
Remaining | numeric(18,0) | 9 | True |
OriginalTerm | numeric(18,0) | 9 | True |
PurchaseOption | varchar(20) | 20 | True |
AsOfDate | datetime | 8 | True |
CustomerID | int | 4 | True |
EquipmentID | int | 4 | True |
ItemId | int | 4 | True |