Field Listing for Table CALLNOTEACTIONS
Field: | TICKETID | Type: | INTEGER |
Field: | STAGESEQUENCE | Type: | INTEGER |
Field: | STAGENAME | Type: | VARCHAR Length: 20 |
Field: | ACTIONSEQUENCE | Type: | INTEGER |
Field: | ACTIONDESCRIPTION | Type: | VARCHAR Length: 200 |
Field: | ACTIONASSIGNEDTO | Type: | VARCHAR Length: 30 |
Field: | ACTIONCCEDTO | Type: | VARCHAR Length: 30 |
Field: | ACTIONREQUIREDDATE | Type: | DATE |
Field: | ACTIONTODO | Type: | VARCHAR Length: 20 |
Field: | ACTIONREQUIREDTIME | Type: | TIME |
Field: | ACTIONREQUIREDTIMETO | Type: | TIME |
Field: | ACTIONHISTORY | Type: | BLOB |
Field: | ACTIONCOMPLETED | Type: | BOOLEAN |
Field: | ACTIONSIGNOFFDATE | Type: | DATE |
Field: | ACTIONSIGNOFFBY | Type: | VARCHAR Length: 30 |
Field: | ACTIONEMAILED | Type: | BOOLEAN |
Field: | ACTIONEMAILEDDATE | Type: | DATE |
Field: | AUTOEMAIL | Type: | BOOLEAN |
Field: | AUTOEMAILLEADTIME | Type: | INTEGER |
Field: | ACTIONCOLOUR | Type: | INTEGER |
Field: | ACTIONINDICATORPOSITION | Type: | INTEGER |
Field: | ACTIONINDICATORCOLOUR | Type: | INTEGER |
Field: | ACTIONINDICATORSHAPE | Type: | INTEGER |
Field: | ACTIONINDICATORFIXED | Type: | BOOLEAN |
Field: | ACTIONINDICATORIMAGE | Type: | BLOB |
Field: | ACTIONRESPONSESTYLE | Type: | VARCHAR Length: 10 |
Field: | ACTIONRESPONSE | Type: | VARCHAR Length: 50 |
Field: | ACTIONFONTCOLOUR | Type: | INTEGER |
Field: | REMOVEACTION | Type: | BOOLEAN |
Field: | TICKETANDACTION | Type: | VARCHAR Length: 233 |
Field: | ASSIGNMENTID | Type: | DOUBLE |
Field: | SYSDATECREATED | Type: | TIMESTAMP |
Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
Field: | SYSUNIQUEID | Type: | DOUBLE |
Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |
Field: | ACTIONENDDATE | Type: | DATE |