Field Listing for Table SCHEDULERESOURCES
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 |