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 |
---|---|---|---|
Technician | nvarchar(50) | 100 | True |
Territory | nvarchar(50) | 100 | True |
OrgTech | nvarchar(50) | 100 | True |
OrgTechName | nvarchar(50) | 100 | True |
CallCloseDate | smalldatetime | 4 | True |
InvoiceNumber | nvarchar(50) | 100 | True |
CallNumber | nvarchar(50) | 100 | True |
CustomerID | int | 4 | True |
EquipmentID | int | 4 | True |
Model | nvarchar(50) | 100 | True |
Preffullname | nvarchar(50) | 100 | True |
ResponseTime | float | 8 | True |
Contract | nvarchar(50) | 100 | True |
ContractCode | nvarchar(50) | 100 | True |
DownHours | float | 8 | True |
RepairHours | float | 8 | True |
Invoiced | int | 4 | True |
OpenDate | smalldatetime | 4 | True |
ReleaseDate | smalldatetime | 4 | True |
TotalDownTime | float | 8 | True |
OnHoldTime | float | 8 | True |
ReleaseDownTime | float | 8 | True |
Callid | int | 4 | True |
RescheduleCallID | int | 4 | True |
MasterCallid | int | 4 | True |
IncidentCloseDate | smalldatetime | 4 | True |
OnHoldCode | nvarchar(50) | 100 | True |
Category | nvarchar(50) | 100 | True |
CallType | nvarchar(50) | 100 | True |
MasterCallNumber | nvarchar(50) | 100 | True |
CreateDate | smalldatetime | 4 | True |
CreateYear | int | 4 | True |
CreateMonth | int | 4 | True |
CreateDay | int | 4 | True |
CreateQuarter | int | 4 | True |
CloseDate | smalldatetime | 4 | True |
CloseYear | int | 4 | True |
CloseMonth | int | 4 | True |
CloseDay | int | 4 | True |
CloseQuarter | int | 4 | True |
FCFix | int | 4 | True |
IsContract | int | 4 | True |