Property | Value |
---|---|
Collation | SQL_Latin1_General_CP1_CI_AS |
Heap | True |
Row Count (~) | 0 |
Created | 12:59:08 AM Thursday, March 21, 2019 |
Last Modified | 12:59:08 AM Thursday, March 21, 2019 |
Name | Data Type | Max Length (Bytes) | Allow Nulls |
---|---|---|---|
CallID | int | 4 | False |
EquipmentID | int | 4 | True |
FinalCallID | int | 4 | True |
OpenDate | datetime | 8 | True |
CloseDate | datetime | 8 | True |
RescheduledCallID | int | 4 | True |
RescheduledCall | bit | 1 | False |
CallTypeCategory | varchar(10) | 10 | False |
DownHours | decimal(18,2) | 9 | True |
MeterReadingGroupID | int | 4 | True |
MeterReadingDate | datetime | 8 | True |
MeterTotal | decimal(18,0) | 9 | True |
MeterTypesTotal | varchar(255) | 255 | True |
MeterBW | decimal(18,0) | 9 | True |
MeterTypesBW | varchar(255) | 255 | True |
MeterColor | decimal(18,0) | 9 | True |
MeterTypesColor | varchar(255) | 255 | True |
MeterScanner | decimal(18,0) | 9 | True |
MeterTypesScanner | varchar(255) | 255 | True |
MeterOther | decimal(18,0) | 9 | True |
MeterTypesOther | varchar(255) | 255 | True |
NextCallID | int | 4 | True |
NextCMCallID | int | 4 | True |
NextPMCallID | int | 4 | True |
CBCBW | decimal(18,0) | 9 | True |
CBCCMBW | decimal(18,0) | 9 | True |
CBCPMBW | decimal(18,0) | 9 | True |
CBCColor | decimal(18,0) | 9 | True |
CBCCMColor | decimal(18,0) | 9 | True |
CBCPMColor | decimal(18,0) | 9 | True |
CBCScanner | decimal(18,0) | 9 | True |
CBCCMScanner | decimal(18,0) | 9 | True |
CBCPMScanner | decimal(18,0) | 9 | True |
OnHoldHours | decimal(18,2) | 9 | True |