Property | Value |
---|---|
Collation | SQL_Latin1_General_CP1_CI_AS |
Heap | True |
Row Count (~) | 0 |
Created | 1:00:52 AM Thursday, March 21, 2019 |
Last Modified | 1:00:52 AM Thursday, March 21, 2019 |
Name | Data Type | Max Length (Bytes) | Allow Nulls |
---|---|---|---|
CallNumber | int | 4 | True |
CallDate | datetime | 8 | True |
InvoiceNumber | int | 4 | True |
CompanyName | varchar(50) | 50 | True |
Address | varchar(50) | 50 | True |
City | varchar(50) | 50 | False |
State | varchar(16) | 16 | True |
Zip | varchar(16) | 16 | True |
CustomerID | int | 4 | True |
CustomerNumber | varchar(50) | 50 | True |
PONumber | varchar(50) | 50 | True |
Model | varchar(50) | 50 | True |
SerialNumber | varchar(50) | 50 | True |
RecDate | datetime | 8 | True |
RecHrs | int | 4 | True |
RecMin | int | 4 | True |
DispDate | datetime | 8 | True |
DispHrs | int | 4 | True |
DispMin | int | 4 | True |
ArrDate | datetime | 8 | True |
ArrHrs | int | 4 | True |
ArrMin | int | 4 | True |
RetDate | datetime | 8 | True |
RetHrs | int | 4 | True |
RetMin | int | 4 | True |
ResponseTime | numeric(18,0) | 9 | True |
RepairTime | numeric(18,0) | 9 | True |
ProbCode | varchar(10) | 10 | True |
ProbCodeDesc | varchar(50) | 50 | True |
CallBack | bit | 1 | True |
PrevCallnumber | varchar(15) | 15 | True |
ReturnYN | varchar(1) | 1 | True |
Meter | int | 4 | True |
ContractNumber | varchar(15) | 15 | True |
ContractID | int | 4 | True |
Notes | varchar(250) | 250 | True |
CallNotes | varchar(250) | 250 | True |
Technician | varchar(6) | 6 | True |
TechnicianID | int | 4 | True |
TechDesc | varchar(50) | 50 | True |
Team | varchar(50) | 50 | True |
EquipmentNumber | varchar(20) | 20 | True |
EquipmentiD | int | 4 | True |
Rescheduled | bit | 1 | True |