Field Listing for Table FIRMRESOURCES
| Field: | ASSEMBLYORJOB | Type: | VARCHAR Length: 15 |
| Field: | ORDERNUMBER | Type: | VARCHAR Length: 15 |
| Field: | STEPORTASK | Type: | VARCHAR Length: 20 |
| Field: | LABOURCODE | Type: | VARCHAR Length: 50 |
| Field: | SCHEDULEHOURS | Type: | DOUBLE |
| Field: | REMAININGHOURS | Type: | DOUBLE |
| Field: | SCHEDULETIME | Type: | TIMESTAMP |
| Field: | SCHEDULESEQ | Type: | INTEGER |
| Field: | SCHEDULEENDTIME | Type: | TIMESTAMP |
| Field: | STEPORTASKSEQ | Type: | INTEGER |
| Field: | STEPOVERLAP | Type: | VARCHAR Length: 20 |
| Field: | OVERLAPMINUTES | Type: | DOUBLE |
| Field: | CAPACITYTYPE | Type: | VARCHAR Length: 10 |
| Field: | NOOFRESOURCES | Type: | INTEGER |
| Field: | EARLIESTSTART | Type: | TIMESTAMP |
| Field: | ORDERLINEID | Type: | DOUBLE |
| Field: | BACKWARDSCHEDULE | Type: | BOOLEAN |
| Field: | BALANCEID | Type: | DOUBLE |
| Field: | SCHEDULEFIXED | Type: | BOOLEAN |
| Field: | SCHEDULECAPTION | Type: | VARCHAR Length: 38 |
| Field: | ORDERDESCRIPTION | Type: | VARCHAR Length: 200 |
| Field: | RESOURCEID | Type: | INTEGER |
| Field: | TRACKINGCOLOUR | Type: | INTEGER |
| Field: | DEPARTMENTCODE | Type: | VARCHAR Length: 20 |
| Field: | RESOURCESTATE | Type: | INTEGER |
| Field: | BUFFERMINUTES | Type: | DOUBLE |
| Field: | SOURCEREFERENCE | Type: | VARCHAR Length: 50 |
| Field: | SOURCENAME | Type: | VARCHAR Length: 50 |
| Field: | WORKFLOWSTATUS | Type: | VARCHAR Length: 20 |
| Field: | ORDERREQUIREDDATE | Type: | DATE |
| Field: | UPDATESTATICDATA | Type: | INTEGER |
| Field: | ORDERSCHEDULEENDDATE | Type: | DATE |
| Field: | PLANNEDDUECOLOUR | Type: | INTEGER |
| Field: | LABOURDESCRIPTION | Type: | VARCHAR Length: 255 |
| Field: | DEPARTMENTDESCRIPTION | Type: | VARCHAR Length: 50 |
| Field: | PARENTORDER | Type: | VARCHAR Length: 30 |
| Field: | PARENTDESCRIPTION | Type: | VARCHAR Length: 200 |
| Field: | HEADERSYSUNIQUEID | 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 |