| Field: | ORDERNUMBER | Type: | VARCHAR Length: 15 |
| Field: | ORDERSTATUS | Type: | VARCHAR Length: 20 |
| Field: | ORDERDATE | Type: | DATE |
| Field: | PRINTSTATUS | Type: | VARCHAR Length: 20 |
| Field: | ITEMCODE | Type: | VARCHAR Length: 50 |
| Field: | ITEMDESCRIPTION | Type: | VARCHAR Length: 255 |
| Field: | ITEMUNIT | Type: | VARCHAR Length: 15 |
| Field: | REQUIREDDATE | Type: | DATE |
| Field: | WORKFLOWSTATUS | Type: | VARCHAR Length: 20 |
| Field: | TRACKINGCOLOUR | Type: | INTEGER |
| Field: | LEADTIME | Type: | INTEGER |
| Field: | ORDERDURATION | Type: | DOUBLE |
| Field: | DURATIONSCALE | Type: | VARCHAR Length: 10 |
| Field: | ORDERSETUPDURATION | Type: | DOUBLE |
| Field: | SETUPDURATIONSCALE | Type: | VARCHAR Length: 10 |
| Field: | ORDERSTARTDATE | Type: | DATE |
| Field: | ORDERFINISHDATE | Type: | DATE |
| Field: | SOURCETYPE | Type: | VARCHAR Length: 20 |
| Field: | SOURCEREFERENCE | Type: | VARCHAR Length: 15 |
| Field: | SOURCESYSUNIQUEID | Type: | DOUBLE |
| Field: | SOURCENAME | Type: | VARCHAR Length: 50 |
| Field: | ORDERQTY | Type: | DOUBLE |
| Field: | COMPLETEQTY | Type: | DOUBLE |
| Field: | SCRAPEDQTY | Type: | DOUBLE |
| Field: | REMAININGQTY | Type: | DOUBLE |
| Field: | QTYPERCENTAGE | Type: | INT64 |
| Field: | PLANNEDCOSTS | Type: | DOUBLE |
| Field: | PLANNEDSETUPCOSTS | Type: | DOUBLE |
| Field: | PLANNEDRUNCOSTS | Type: | DOUBLE |
| Field: | PLANNEDTOTALCOSTS | Type: | DOUBLE |
| Field: | ACTUALCOSTS | Type: | DOUBLE |
| Field: | ACTUALSETUPCOSTS | Type: | DOUBLE |
| Field: | ACTUALRUNCOSTS | Type: | DOUBLE |
| Field: | ACTUALTOTALCOSTS | Type: | DOUBLE |
| Field: | SETUPCOSTPERCENT | Type: | INT64 |
| Field: | RUNCOSTPERCENT | Type: | INT64 |
| Field: | TOTALCOSTPERCENT | Type: | INT64 |
| Field: | RECEIPTCOSTS | Type: | DOUBLE |
| Field: | COSTPERCENTAGE | Type: | INT64 |
| Field: | WIPVALUE | Type: | DOUBLE |
| Field: | ORDERNOTES | Type: | BLOB |
| Field: | CUSTOMPRODUCT | Type: | BOOLEAN |
| Field: | CUSTOMRECEIPTBATCHNO | Type: | VARCHAR Length: 20 |
| Field: | CUSTOMPRODUCTBOMID | Type: | DOUBLE |
| Field: | COSTCALCULATEDPERCENT | Type: | DOUBLE |
| Field: | COSTCOMPLETIONCOMMENT | Type: | VARCHAR Length: 30 |
| Field: | TIMECALCULATEDPERCENT | Type: | DOUBLE |
| Field: | TIMECOMPLETIONCOMMENT | Type: | VARCHAR Length: 30 |
| Field: | REMAININGCOSTS | Type: | DOUBLE |
| Field: | ACTPLANCOSTPERCENT | Type: | DOUBLE |
| Field: | PLANNEDTIME | Type: | DOUBLE |
| Field: | ACTUALTIME | Type: | DOUBLE |
| Field: | REMAININGTIME | Type: | DOUBLE |
| Field: | ACTPLANTIMEPERCENT | Type: | DOUBLE |
| Field: | PROJECTEDCOSTS | Type: | DOUBLE |
| Field: | PROJECTEDTIME | Type: | DOUBLE |
| Field: | COSTCALCULATEDTODATE | Type: | DOUBLE |
| Field: | COSTCALCULATEDTOTAL | Type: | DOUBLE |
| Field: | TIMECALCULATEDTODATE | Type: | DOUBLE |
| Field: | TIMECALCULATEDTOTAL | Type: | DOUBLE |
| Field: | PROPLANCOSTPERCENT | Type: | DOUBLE |
| Field: | PROPLANTIMEPERCENT | Type: | DOUBLE |
| Field: | HIGHERCOSTS | Type: | BOOLEAN |
| Field: | HIGHERUSAGE | Type: | BOOLEAN |
| Field: | LOWERUSAGE | Type: | BOOLEAN |
| Field: | HIGHERTIME | Type: | BOOLEAN |
| Field: | LOWERTIME | Type: | BOOLEAN |
| Field: | LOWERCOSTS | Type: | BOOLEAN |
| Field: | ADDITIONALFIELD_1 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_2 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_3 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_4 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_5 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_6 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_7 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_8 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALDATEFIELD_1 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_2 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_3 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_4 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_5 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_6 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_7 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_8 | Type: | DATE |
| Field: | ASSEMBLYTYPE | Type: | VARCHAR Length: 20 |
| Field: | ASSEMBLYSTYLE | Type: | VARCHAR Length: 20 |
| Field: | COPRODUCTORDERQTY | Type: | DOUBLE |
| Field: | COPRODUCTCOMPLETEQTY | Type: | DOUBLE |
| Field: | COPRODUCTQTYPERCENTAGE | Type: | INT64 |
| Field: | COPRODUCTSCRAPQTY | Type: | DOUBLE |
| Field: | PLANNEDTOTALWEIGHT | Type: | DOUBLE |
| Field: | PLANNEDTOTALVOLUME | Type: | DOUBLE |
| Field: | PLANNEDTOTALAREA | Type: | DOUBLE |
| Field: | ACTUALTOTALWEIGHT | Type: | DOUBLE |
| Field: | ACTUALTOTALVOLUME | Type: | DOUBLE |
| Field: | ACTUALTOTALAREA | Type: | DOUBLE |
| Field: | SITENAME | Type: | VARCHAR Length: 50 |
| Field: | ORDERSCRIPTRUN | Type: | BOOLEAN |
| Field: | STATUSCOLOUR | Type: | INTEGER |
| Field: | FULLDELIVERYONLY | Type: | BOOLEAN |
| Field: | ORDERPRIORITY | Type: | BOOLEAN |
| Field: | WIPVARPOSTEDVALUE | Type: | DOUBLE |
| Field: | CURRENTSTEPNAME | Type: | VARCHAR Length: 20 |
| Field: | OVERRIDELOCATIONS | Type: | BOOLEAN |
| Field: | DEFAULTISSUEWAREHOUSE | Type: | VARCHAR Length: 20 |
| Field: | DEFAULTISSUELOCATION | Type: | VARCHAR Length: 20 |
| Field: | DEFAULTRECEIPTWAREHOUSE | Type: | VARCHAR Length: 20 |
| Field: | DEFAULTRECEIPTLOCATION | Type: | VARCHAR Length: 20 |
| Field: | PLANNINGNOTE | Type: | VARCHAR Length: 200 |
| Field: | NOEXPEDITING | Type: | BOOLEAN |
| Field: | AUTOCREATION | Type: | BOOLEAN |
| Field: | SCHEDULEFIXED | Type: | BOOLEAN |
| Field: | SCHEDULESEQ | Type: | INTEGER |
| Field: | MINSTARTDATE | Type: | DATE |
| Field: | ORDERSEQUENCE | Type: | INTEGER |
| Field: | TOPLEVELORDERNUMBER | Type: | VARCHAR Length: 15 |
| Field: | TOPLEVELSOURCENAME | Type: | VARCHAR Length: 50 |
| Field: | TOPLEVELSOURCEREFERENCE | Type: | VARCHAR Length: 15 |
| Field: | TOPLEVELSOURCETYPE | Type: | VARCHAR Length: 20 |
| Field: | CURRENTDUECOLOUR | Type: | INTEGER |
| Field: | PLANNEDDUECOLOUR | Type: | INTEGER |
| Field: | LASTFIRMSCHEDULETIME | Type: | TIMESTAMP |
| Field: | SUBASSEMBLYEXPLOSION | Type: | VARCHAR Length: 30 |
| Field: | ASSEMBLYVERSION | Type: | VARCHAR Length: 20 |
| Field: | PLANNEDITEMSETUPCOST | Type: | DOUBLE |
| Field: | PLANNEDDESCRIPTORSETUPCOST | Type: | DOUBLE |
| Field: | PLANNEDLABOURSETUPCOST | Type: | DOUBLE |
| Field: | ACTUALITEMSETUPCOST | Type: | DOUBLE |
| Field: | ACTUALDESCRIPTORSETUPCOST | Type: | DOUBLE |
| Field: | ACTUALLABOURSETUPCOST | Type: | DOUBLE |
| Field: | PLANNEDITEMRUNCOST | Type: | DOUBLE |
| Field: | PLANNEDDESCRIPTORRUNCOST | Type: | DOUBLE |
| Field: | PLANNEDLABOURRUNCOST | Type: | DOUBLE |
| Field: | ACTUALITEMRUNCOST | Type: | DOUBLE |
| Field: | ACTUALDESCRIPTORRUNCOST | Type: | DOUBLE |
| Field: | ACTUALLABOURRUNCOST | Type: | DOUBLE |
| Field: | GENERATEDID | Type: | DOUBLE |
| Field: | ASSEMBLYCLOSEDATE | Type: | DATE |
| Field: | ITEMBACKFLUSHED | Type: | BOOLEAN |
| Field: | PLANNEDRECEIPTWEIGHT | Type: | DOUBLE |
| Field: | PLANNEDYIELDPERCENT | Type: | DOUBLE |
| Field: | ACTUALYIELDPERCENT | Type: | DOUBLE |
| Field: | FINANCIALCATEGORY | Type: | VARCHAR Length: 200 |
| Field: | PLANNEDORDERDATE | Type: | DATE |
| Field: | ORIGINALREQUIREDDATE | Type: | DATE |
| Field: | ASSEMBLYASSIGNED | Type: | BOOLEAN |
| Field: | URGENTORDER | 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 |
| Field: | USEVIRTUALCONTAINER | Type: | BOOLEAN |