Field Listing for Table JOBTASKRESOURCES
| Field: | ORDERNUMBER | Type: | VARCHAR Length: 15 |
| Field: | TASKNAME | Type: | VARCHAR Length: 20 |
| Field: | RESOURCETYPE | Type: | VARCHAR Length: 20 |
| Field: | RESOURCENAME | Type: | VARCHAR Length: 30 |
| Field: | RESOURCESTATUS | Type: | VARCHAR Length: 20 |
| Field: | RESOURCESTART | Type: | TIMESTAMP |
| Field: | RESOURCESTARTDATE | Type: | DATE |
| Field: | RESOURCESTARTTIME | Type: | TIME |
| Field: | RESOURCEFINISH | Type: | TIMESTAMP |
| Field: | RESOURCEFINISHDATE | Type: | DATE |
| Field: | RESOURCEFINISHTIME | Type: | TIME |
| Field: | TASKSTATUS | Type: | VARCHAR Length: 20 |
| Field: | TASKSTATUSID | Type: | INTEGER |
| Field: | TRACKINGCOLOUR | Type: | INTEGER |
| Field: | TASKCUSTOMER | Type: | VARCHAR Length: 50 |
| Field: | ORDERANDTASK | Type: | VARCHAR Length: 36 |
| Field: | TASKINSTRUCTIONS | Type: | BLOB |
| Field: | BOOKINGSTATUS | Type: | VARCHAR Length: 20 |
| Field: | NOSCHEDULING | Type: | BOOLEAN |
| Field: | PLANNEDLABOURCODE | Type: | VARCHAR Length: 50 |
| Field: | RESOURCEINSTRUCTIONS | Type: | BLOB |
| Field: | TASKDURATIONHOURS | Type: | DOUBLE |
| Field: | CALENDARRESOURCEID | Type: | INTEGER |
| Field: | RESOURCEDURATION | Type: | INT64 |
| Field: | ALLOCATIONHOURSUPDATE | Type: | INTEGER |
| Field: | TASKALLOCATIONHOURS | Type: | DOUBLE |
| Field: | HEADERSYSUNIQUEID | Type: | DOUBLE |
| Field: | ACTUALRECORD | Type: | BOOLEAN |
| Field: | ACTUALFINISHTIME | Type: | TIMESTAMP |
| Field: | SOURCEID | Type: | DOUBLE |
| Field: | ASSIGNMENTID | Type: | DOUBLE |
| Field: | ASSIGNMENTUPDATE | Type: | BOOLEAN |
| Field: | SYSDATECREATED | Type: | TIMESTAMP |
| Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
| Field: | SYSUNIQUEID | Type: | DOUBLE |
| Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
| Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |