supportcase
The supportcase table.
Columns
Name | Type | References | Description |
id [KEY] | Integer | Internal ID | |
assigned | String | Assigned To | |
casenumber | String | ID | |
company | String | Company | |
datecreated | Date | Creation Date/Time | |
escalateto | String | Escalate To | |
externalid | String | External ID | |
helpdesk | Boolean | Help Desk | |
initialresponsetime | Double | Initial Response Time | |
isinactive | Boolean | Inactive | |
issue | String | Case Issue | |
issues | String | Issues | |
item | String | Item | |
lastcustomermessagereceived | Date | Last Customer Message Received | |
origin | String | Origin | |
priority | String | Priority | |
profile | String | Profile | |
serialnumber | String | Serial/Lot Number | |
solutions | String | Solutions | |
startdate | Date | Incident Date | |
status | String | Status | |
subsidiary | String | Subsidiary | |
supportfirstreply | Date | Support First Reply | |
timeelapsed | Double | Time Elapsed | |
timeonhold | Double | Time On Hold | |
timeopen | Double | Time Open | |
timetoassign | Double | Time To Assign | |
timetoclose | Double | Time To Close | |
title | String | Subject |