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 |