Property | Value |
---|---|
Collation | SQL_Latin1_General_CP1_CI_AS |
Heap | True |
Row Count (~) | 0 |
Created | 12:57:02 AM Thursday, March 21, 2019 |
Last Modified | 1:01:48 AM Thursday, March 21, 2019 |
Name | Data Type | Max Length (Bytes) | Allow Nulls | Default |
---|---|---|---|---|
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 | ((1)) |
LastUpdate | datetime | 8 | True | |
ModifiedDate | datetime | 8 | False | (getdate()) |
CreateDate | datetime | 8 | False | (getdate()) |
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 |