Property | Value |
---|---|
Collation | SQL_Latin1_General_CP1_CI_AS |
Heap | True |
Row Count (~) | 0 |
Created | 12:58:42 AM Thursday, March 21, 2019 |
Last Modified | 12:58:42 AM Thursday, March 21, 2019 |
Name | Data Type | Max Length (Bytes) | Allow Nulls |
---|---|---|---|
CallID | int | 4 | True |
EquipmentID | int | 4 | True |
ItemID | int | 4 | True |
CustomerID | int | 4 | True |
TechnicianID | int | 4 | True |
CallDate | datetime | 8 | True |
UseableCallDate | datetime | 8 | True |
CallTypeID | int | 4 | True |
ContractID | int | 4 | True |
ReportID | int | 4 | True |
MeterDate | datetime | 8 | True |
MeterDisplay | int | 4 | True |
MeterActual | int | 4 | True |
TerritoryID | int | 4 | True |
NextReportID | int | 4 | True |
NextCallDate | datetime | 8 | True |
NextMeterDate | datetime | 8 | True |
NextMeterDisplay | int | 4 | True |
NextMeterActual | int | 4 | True |
UsableMeter | int | 4 | True |
CallDays | int | 4 | True |
CBC | int | 4 | True |
OnHoldCode | varchar(50) | 50 | True |
OnHoldCodeType | varchar(32) | 32 | True |
incompletecodeid | int | 4 | True |
Partscost | money | 8 | True |
Travelhours | float | 8 | True |
Repairhours | float | 8 | True |
ResponseHours | float | 8 | True |
DownHours | float | 8 | True |
NextOnHoldCode | varchar(50) | 50 | True |
NextOnHoldType | varchar(32) | 32 | True |
NextPartscost | money | 8 | True |
NextTravelhours | float | 8 | True |
NextRepairhours | float | 8 | True |
NextResponseHours | float | 8 | True |
NextDownHours | float | 8 | True |
NextCallNumber | varchar(50) | 50 | True |
CallBackCallid | int | 4 | True |
CallBackNumber | varchar(255) | 255 | True |
Rescheduledcallid | int | 4 | True |
MonthlyAvgRunRate | int | 4 | True |
TotalMeterActual | int | 4 | True |
TotalMeterActualMeters | varchar(255) | 255 | True |
NextTotalMeterActual | int | 4 | True |
NextTotalMeterActualMeters | varchar(255) | 255 | True |
TotalCBC | int | 4 | True |
MeterReadingGroupID | int | 4 | True |