Property | Value |
---|---|
Collation | SQL_Latin1_General_CP1_CI_AS |
Heap | True |
Row Count (~) | 0 |
Created | 1:00:54 AM Thursday, March 21, 2019 |
Last Modified | 1:00:54 AM Thursday, March 21, 2019 |
Name | Data Type | Max Length (Bytes) | Allow Nulls |
---|---|---|---|
CallID | int | 4 | False |
ServerCallID | int | 4 | True |
UserID | varchar(50) | 50 | False |
CallNumber | varchar(255) | 255 | True |
CallTypeID | int | 4 | True |
PriorityID | int | 4 | True |
Rank | int | 4 | True |
StatusID | char(3) | 3 | True |
WorkOrderNumber | varchar(255) | 255 | True |
WorkOrderID | int | 4 | True |
EquipmentID | int | 4 | True |
Caller | varchar(255) | 255 | True |
CustomerID | int | 4 | True |
CustomerName | varchar(128) | 128 | True |
CallDate | datetime | 8 | True |
EstStartDate | datetime | 8 | True |
DueDate | datetime | 8 | True |
EstimatedDuration | int | 4 | True |
Territory | varchar(50) | 50 | True |
Address | varchar(64) | 64 | True |
City | varchar(32) | 32 | True |
State | varchar(16) | 16 | True |
Country | varchar(16) | 16 | True |
PostalCode | varchar(16) | 16 | True |
Description | varchar(255) | 255 | True |
IncompleteCodeID | int | 4 | True |
IncompleteDeliveryMethodID | int | 4 | True |
IncompleteRequiredDate | datetime | 8 | True |
IncompleteRemarks | varchar(255) | 255 | True |
Notes1 | varchar(255) | 255 | True |
Notes2 | varchar(255) | 255 | True |
Notes3 | varchar(255) | 255 | True |
Notes4 | varchar(255) | 255 | True |
OnHoldCode | int | 4 | True |
MiscDescription | varchar(255) | 255 | True |
MiscAmount | decimal(18,4) | 9 | True |
PreventativeMaintenance | bit | 1 | True |
MeterDisplay | int | 4 | True |
CopyCredits | int | 4 | True |
IsActive | bit | 1 | False |
LastUpdate | datetime | 8 | True |
ModifiedDate | datetime | 8 | False |
CreateDate | datetime | 8 | False |
ForceSave | bit | 1 | True |
ExistsOnServer | bit | 1 | False |
WarrantyDate | datetime | 8 | True |
CloseDate | datetime | 8 | True |
CancelCodeID | int | 4 | True |
CancelDescription | varchar(255) | 255 | True |
Fresh | bit | 1 | True |
TermID | int | 4 | True |
CheckOutTime | datetime | 8 | True |
CallType | varchar(255) | 255 | True |
FailType | int | 4 | True |
FailMessage | varchar(1024) | 1024 | True |
BillCode | varchar(50) | 50 | True |
DelayCodeID | int | 4 | True |
ServerHold | bit | 1 | True |