Field Listing for Table SCHEDULEORDERS
| Field: | ASSEMBLYORJOB | Type: | VARCHAR Length: 15 |
| Field: | ORDERSTATUS | Type: | VARCHAR Length: 20 |
| Field: | ORDERNUMBER | Type: | VARCHAR Length: 15 |
| Field: | REQUIREDDATE | Type: | DATE |
| Field: | ORDERDATE | Type: | DATE |
| Field: | LEADTIME | Type: | INTEGER |
| Field: | SCHEDULEHOURS | Type: | DOUBLE |
| Field: | SCHEDULETIME | Type: | TIMESTAMP |
| Field: | SCHEDULEENDTIME | Type: | TIMESTAMP |
| Field: | GENERATEDSEQ | Type: | INTEGER |
| Field: | SCHEDULESEQ | Type: | INTEGER |
| Field: | ORDERSETUPDURATION | Type: | DOUBLE |
| Field: | SETUPDURATIONSCALE | Type: | VARCHAR Length: 10 |
| Field: | ORDERSTARTDATE | Type: | DATE |
| Field: | ORDERFINISHDATE | Type: | DATE |
| Field: | ORDERQTY | Type: | DOUBLE |
| Field: | COMPLETEQTY | Type: | DOUBLE |
| Field: | SCRAPEDQTY | Type: | DOUBLE |
| Field: | REMAININGQTY | Type: | DOUBLE |
| Field: | SCHEDULEFIXED | Type: | BOOLEAN |
| Field: | MINSTARTDATE | Type: | DATE |
| Field: | ORDERDESCRIPTION | Type: | VARCHAR Length: 200 |
| Field: | ORDERSEQUENCENUMBER | Type: | INTEGER |
| Field: | ORDERSTARTED | Type: | BOOLEAN |
| Field: | ORDERPRIORITY | Type: | INTEGER |
| Field: | CRITICALRATIO | Type: | DOUBLE |
| Field: | ORDERSYSUNIQUEID | Type: | DOUBLE |
| Field: | WORKFLOWSTATUS | Type: | VARCHAR Length: 20 |
| Field: | TRACKINGCOLOUR | Type: | INTEGER |
| Field: | EXCLUDEORDER | Type: | BOOLEAN |
| Field: | EXCLUDEFIRM | Type: | BOOLEAN |
| Field: | FIRMORDER | Type: | BOOLEAN |
| Field: | SOURCEREFERENCE | Type: | VARCHAR Length: 50 |
| Field: | SOURCENAME | Type: | VARCHAR Length: 50 |
| Field: | UPDATESTATICDATA | Type: | INTEGER |
| Field: | PARENTORDER | Type: | VARCHAR Length: 30 |
| Field: | PARENTDESCRIPTION | Type: | VARCHAR Length: 200 |
| Field: | SYSDATECREATED | Type: | TIMESTAMP |
| Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
| Field: | SYSUNIQUEID | Type: | DOUBLE |
| Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
| Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |