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