Field Listing for Table ASSEMBLYHEADER

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:ADDITIONALFIELD_9 Type: VARCHAR Length: 100