WORDER – Work Order Header

System: WO (WO)
Prefix: WOR
Primary key: COMPANY, LOCATION, WORK-ORDER, WORK-ORDER-SUF
Fields: 54
Updated by: 2 programs
Referenced by: 5 programs

WORDER is the Work Order Header table in Lawson WO (prefix WOR). It is indexed by COMPANY, LOCATION, WORK-ORDER, WORK-ORDER-SUF (WORSET1); alternate indexes: WORSET2, WORSET3, WORSET4, WORSET5 and WORSET7. It is related 1:1 to APCOMPANY, APVENMAST, ARCOMP, CUSTORDER, HOLDCODES, ICCOMPANY, ICLOCATION, ITEMLOC and 3 more and 1:M to WODETAIL, WOITEM, WHDEMAND and WOBYPROD. It is updated by WH20.7 and WHD3.1 and referenced by IC01.1, IC02.1, IC62.1, IC62.4 and WHD2.1. The table has 54 fields, 6 indexes and 22 documented relations.

About WORDER

The Work Order Header file contains the primary information associated with producing a finished good.

Fields (54)

Column = COBOL field name without the WOR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`WOR-COMPANY` PK COMPANY	Numeric 4	This field contains the company number, as defined in the Inventory Control system.	—
`WOR-LOCATION` PK LOCATION	Alpha 5	This field contains a valid stock location within the company inventory. It is also the production facility where finished goods are produced.	—
`WOR-WORK-ORDER` PK WORK_ORDER	Numeric 8	This identifies the work order and may be automatically assigned or manually assigned, depending on the option defined for each production (inventory) location.	—
`WOR-WORK-ORDER-SUF` PK WORK_ORDER_SUF	Numeric 2	This will normally be zero for a work order. If you chose to split a work order so the completed part of the finished goods can be available for allocation, the work order created for the remaining quantity will have a non-zero value in this field.	—
`WOR-ITEM` ITEM	Alpha 32	This field contains the item identifier of the finished good produced for the work order, as defined in the Inventory Control system.	—
`WOR-START-DATE` START_DATE	Numeric 8 (yyyymmdd)	This is the production start date for the work order.	—
`WOR-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	This is the production end date for the work order.	—
`WOR-EXP-DELIV-DT` EXP_DELIV_DT	Numeric 8 (yyyymmdd)	This is the date needed for the finished good.	—
`WOR-STATUS` STATUS	Numeric 1	The work order statuses indicate the progression of the work order through pre and post production stages. `1` Unreleased `2` Released `3` Exploded `4` In Production `8` Canceled `9` Completed	—
`WOR-PICK-FDBK-STAT` PICK_FDBK_STAT	Numeric 1	Each picking feedback status indicates a stage within the picking feedback process. `0` Picking Fdbk Not Started `1` Picking Fdbk In Process `2` Picking Fdbk Finished `3` Picking Fdbk Complete	—
`WOR-PROD-FDBK-STAT` PROD_FDBK_STAT	Numeric 1	Each production feedback status indicates a stage within the production feedback process for the work order. `0` Production Fdbk Not Started `1` Production Fdbk In Process `2` Production Fdbk Finished `3` Production Fdbk Completed	—
`WOR-WALK-THRU-REQ` WALK_THRU_REQ	Alpha 1	This field indicates that a transaction line is out of balance. For example, if lot, bin, or serial number quantities do not equal the transaction quantity, select the WalkThru form action to balance the transaction quantities.	—
`WOR-HOLD-CODE` HOLD_CODE	Alpha 4	This is the offsite hold code which indicates if the work order is currently sent offsite during the production process to be performed by a vendor.	—
`WOR-PRINTED-FL` PRINTED_FL	Alpha 1	This flag indicates if this work order has been printed by the work order print program. " " = No `Y` Yes	—
`WOR-PRTED-PL-FL` PRTED_PL_FL	Alpha 1	This flag indicates if this work order has been printed by the work order pick list program. " " = No `Y` Yes	—
`WOR-OPR-CODE` OPR_CODE	Alpha 10 (Lower Case)	This field contains the operator code. This is the user ID of the person who last maintained this record.	—
`WOR-SYSTEM-CD` SYSTEM_CD	Alpha 2	This field indicates on what system the transaction originated. `OE` Order Entry `RQ` Requisitions `WO` Work Order	WH20.7
`WOR-DOC-NBR-NUM` DOC_NBR_NUM	Numeric 10	This is the order or requisition number when the work order is for a specific order or requisition.	WH20.7
`WOR-LINE-NBR` LINE_NBR	Numeric 6	This field contains the line number of the order or requisition when the work order is for a specific order or requisition.	WH20.7
`WOR-ORIG-WORK-ORDR` ORIG_WORK_ORDR	Numeric 8	This is the original work order that is being reversed by this work order. This field will only have a value on reverse work orders.	—
`WOR-ORIG-WO-SUF` ORIG_WO_SUF	Numeric 2	This is the suffix of original work order that is being reversed by this work order. This field will only have a value on reverse work orders.	—
`WOR-PLAN-QTY` PLAN_QTY	Signed 13.4	This field contains the planned quantity for the finished good being produced by this work order.	—
`WOR-ACTUAL-QTY` ACTUAL_QTY	Signed 13.4	This field contains the actual quantity of the finished good produced by this work order.	—
`WOR-DETAIL-QTY` DETAIL_QTY	Signed 13.4	This field shows the total quantity of details defined for a detail tracked item. It is matched against the line quantity field to determine if details are in balance.	—
`WOR-SHRINK-QTY` SHRINK_QTY	Signed 13.4	Shrinkage quantity is the difference between the total of the components and the total of the finished good when all components are in the same unit of measure as the finished good. This is a quantity that may be entered at production feedback and is for information only.	—
`WOR-EST-COMP-COST` EST_COMP_COST	Signed 18.5	This is the total of the estimated costs for 'C' type components that will used to produce the finished goods.	—
`WOR-ACT-COMP-COST` ACT_COMP_COST	Signed 18.5	This is the total of actual component inventory costs for 'C' type components that were used (not wasted) to produce the finished goods.	—
`WOR-EST-PACK-COST` EST_PACK_COST	Signed 18.5	This is the total of the estimated cost for packaging components that will be used for the finished goods.	—
`WOR-ACT-PACK-COST` ACT_PACK_COST	Signed 18.5	This is the total of the actual costs for packaging components that were used for the finished goods.	—
`WOR-EST-BRDN-COST` EST_BRDN_COST	Signed 18.2	This is the total estimated burden cost related to producing the finished goods.	—
`WOR-ACT-BRDN-COST` ACT_BRDN_COST	Signed 18.2	This is the total actual burden cost related to producing the finished goods.	—
`WOR-FGV-AMOUNT` FGV_AMOUNT	Signed 18.5	The finished good variance amount is used only on reverse work orders. It is used when the cost of the finished good returned from inventory is not the same as the cost of producing the finished good on the original work order. This field will contain the difference, which will post to the variance account set up for the finished good.	—
`WOR-VENDOR` VENDOR	Alpha 9 (Right Justified)	This is the identification code of the vendor that is currently doing all or part of the production process while the work order is on offsite hold.	—
`WOR-OFFSITE-DATE` OFFSITE_DATE	Numeric 8 (yyyymmdd)	This is the date that the work order was sent offsite if it is currently on offsite hold.	—
`WOR-RETURNED-DATE` RETURNED_DATE	Numeric 8 (yyyymmdd)	This is the date the work order was returned from a vendor performing a process that had placed the work order on offsite hold.	—
`WOR-REVERSED-BY-WO` REVERSED_BY_WO	Numeric 8	This is the number of the work order that reverses this work order.	—
`WOR-WF-PROD-FL` WF_PROD_FL	Alpha 1	The Workflow Management system production flag is set to Yes when the work order is in the production process. `Y` Yes `N` No	—
`WOR-WF-OFFSITE-FL` WF_OFFSITE_FL	Alpha 1	The Workflow Management system offsite flag is set to Yes when the work order is in the offsite production process. `Y` Yes `N` No	—
`WOR-LAST-COMP-SEQ` LAST_COMP_SEQ	Numeric 3	This is the last sequence number used for components added to the work order item file for this work order.	—
`WOR-LAST-BRDN-SEQ` LAST_BRDN_SEQ	Numeric 3	This is the last sequence used for burdens added to this work order.	—
`WOR-LAST-BYPRO-SEQ` LAST_BYPRO_SEQ	Numeric 3	This is the last sequence number used for byproducts added to this work order.	—
`WOR-WO-ALPHA` WO_ALPHA	Derived	The system displays a group field that contains work order (WORK-ORDER) and work order suffix (WORK-ORDER-SUF).	—
`WOR-DISP-DOC` DISP_DOC	Derived	The system displays a conditional field that contains a label stating that it is a customer order or requisition if the system code (SYSTEM-CD) is Order Entry or Requisition.	—
`WOR-EST-FG-COST` EST_FG_COST	Derived	The system displays the result of estimated component cost + estimated packaging cost + estimated burden cost (computed as EST-COMP-COST + EST-PACK-COST + EST-BRDN-COST).	—
`WOR-ACT-FG-COST` ACT_FG_COST	Derived	The system displays the result of actual component cost + actual packaging cost + actual burden cost (computed as ACT-COMP-COST + ACT-PACK-COST + ACT-BRDN-COST).	—
`WOR-WO-USER-FLD-1` WO_USER_FLD_1	Alpha 10 (Lower Case)	This field contains user-defined data and can be used to cross reference work order numbers.	—
`WOR-WO-USER-FLD-2` WO_USER_FLD_2	Alpha 15 (Lower Case)	This field contains user-defined information.	—
`WOR-WO-USER-DATE-1` WO_USER_DATE_1	Numeric 8 (yyyymmdd)	This field contains user-defined dates.	—
`WOR-BA-ACCT-UNIT` BA_ACCT_UNIT	Alpha 15	This field identifies the burden absorption account unit to record burden expenses associated with a production facility.	—
`WOR-BA-ACCOUNT` BA_ACCOUNT	Numeric 6	This field identifies the burden absorption account to record burden expenses associated with a production facility.	—
`WOR-BA-SUB-ACCT` BA_SUB_ACCT	Numeric 4	This field identifies the burden absorption subaccount to record burden expenses associated with a production facility.	—
`WOR-PC-ACCT-UNIT` PC_ACCT_UNIT	Alpha 15	This field identifies the production credit account unit to record credit to a production facility for finished goods produced.	—
`WOR-PC-ACCOUNT` PC_ACCOUNT	Numeric 6	This field identifies the production credit account to record credit to a production facility for finished goods produced.	—
`WOR-PC-SUB-ACCT` PC_SUB_ACCT	Numeric 4	This field identifies the production credit subaccount to record credit to a production facility for finished goods produced.	—

Indexes (6)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`WORSET1`	`COMPANY`, `LOCATION`, `WORK-ORDER`, `WORK-ORDER-SUF`	Primary		IC01.1, WH20.7, WHD2.1, WHD3.1
`WORSET2`	`COMPANY`, `LOCATION`, `STATUS`, `WORK-ORDER`, `WORK-ORDER-SUF`	KeyChange		IC02.1
`WORSET3`	`COMPANY`, `LOCATION`, `STATUS`, `START-DATE`, `WORK-ORDER`, `WORK-ORDER-SUF`	KeyChange		—
`WORSET4`	`COMPANY`, `LOCATION`, `ITEM`, `WORK-ORDER*`, `WORK-ORDER-SUF`	KeyChange		IC62.1, IC62.4
`WORSET5`	`COMPANY`, `LOCATION`, `END-DATE`, `WORK-ORDER`, `WORK-ORDER-SUF`	KeyChange		—
`WORSET7`	`COMPANY`, `LOCATION`, `WO-USER-FLD-1`, `WORK-ORDER`, `WORK-ORDER-SUF`	KeyChange, Subset	Where WO-USER-FLD-1 != Spaces	—

Relations

One to one (11) — lookups and parents

Relation	Table	Rules	Condition	Field map
Apcompany	APCOMPANY	Not Required	Valid When WOR-VENDOR != Spaces	`WOR-COMPANY` → `-COMPANY`
Apvenmast	APVENMAST	Not Required	Valid When WOR-VENDOR != Spaces	`CPY-VENDOR-GROUP` → `VEN-VENDOR-GROUP`, `WOR-VENDOR` → `VEN-VENDOR`
Arcomp	ARCOMP	Required		`WOR-COMPANY` → `ACO-COMPANY`
Custorder	CUSTORDER	Required	When WOR-SYSTEM-CD = "OE" And WOR-DOC-NBR-NUM != Zeroes	`WOR-COMPANY` → `COR-COMPANY`, `WOR-DOC-NBR-NUM` → `COR-ORDER-NBR`
Holdcodes	HOLDCODES	Required	When WOR-HOLD-CODE != Spaces	`ACO-CUST-GROUP` → `HDD-CUST-GROUP`, `WOR-HOLD-CODE` → `HDD-HOLD-CODE`
Iccompany	ICCOMPANY	Required		`WOR-COMPANY` → `ICC-COMPANY`
Iclocation	ICLOCATION	Required		`WOR-COMPANY` → `ICL-COMPANY`, `WOR-LOCATION` → `ICL-LOCATION`
Itemloc	ITEMLOC	Required		`WOR-COMPANY` → `ITL-COMPANY`, `WOR-LOCATION` → `ITL-LOCATION`, `WOR-ITEM` → `ITL-ITEM`
Itemmast	ITEMMAST	Not Required		`ICC-ITEM-GROUP` → `ITE-ITEM-GROUP`, `WOR-ITEM` → `ITE-ITEM`
Reqheader	REQHEADER	Required	When WOR-SYSTEM-CD = "RQ" And WOR-DOC-NBR-NUM != Zeroes	`WOR-COMPANY` → `RQH-COMPANY`, `WOR-DOC-NBR-NUM` → `RQH-REQ-NUMBER`
Woworuf	WOWORUF	Not Required		`WOR-COMPANY` → `WRU-COMPANY`, `WOR-LOCATION` → `WRU-LOCATION`, `WOR-WORK-ORDER` → `WRU-WORK-ORDER`, `WOR-WORK-ORDER-SUF` → `WRU-WORK-ORDER-SUF`

One to many (11) — child tables

Relation	Table	Rules	Condition	Field map
Bin Details	WODETAIL		Valid When ITE-LOT-TRACK-FL = "N" And ITE-SER-TRACK-FL = "N" And ITL-BIN-TRACK-FL = "Y"	`WOR-COMPANY` → `WOD-COMPANY`, `WOR-LOCATION` → `WOD-LOCATION`, `WOR-WORK-ORDER` → `WOD-WORK-ORDER`, `WOR-WORK-ORDER-SUF` → `WOD-WORK-ORDER-SUF`, `"F"` → `WOD-DETAIL-TYPE`, `Zeroes` → `WOD-COMPONENT-SEQ`, → `WOD-BIN`, → `WOD-LOT`, → `WOD-SUBLOT`, → `WOD-SERIAL`, → `WOD-UOM`
Items By Loc	WOITEM			`WOR-COMPANY` → `WOI-COMPANY`, `WOR-LOCATION` → `WOI-LOCATION`, `WOR-WORK-ORDER` → `WOI-WORK-ORDER`, `WOR-WORK-ORDER-SUF` → `WOI-WORK-ORDER-SUF`, → `WOI-INV-LOCATION`, → `WOI-COMPONENT-SEQ`
Lot Details	WODETAIL		Valid When ITE-LOT-TRACK-FL = "Y"	`WOR-COMPANY` → `WOD-COMPANY`, `WOR-LOCATION` → `WOD-LOCATION`, `WOR-WORK-ORDER` → `WOD-WORK-ORDER`, `WOR-WORK-ORDER-SUF` → `WOD-WORK-ORDER-SUF`, `"F"` → `WOD-DETAIL-TYPE`, `Zeroes` → `WOD-COMPONENT-SEQ`, → `WOD-BIN`, → `WOD-LOT`, → `WOD-SUBLOT`, → `WOD-SERIAL`, → `WOD-UOM`
Serial Details	WODETAIL		Valid When ITE-SER-TRACK-FL != "N"	`WOR-COMPANY` → `WOD-COMPANY`, `WOR-LOCATION` → `WOD-LOCATION`, `WOR-WORK-ORDER` → `WOD-WORK-ORDER`, `WOR-WORK-ORDER-SUF` → `WOD-WORK-ORDER-SUF`, `"F"` → `WOD-DETAIL-TYPE`, `Zeroes` → `WOD-COMPONENT-SEQ`, → `WOD-BIN`, → `WOD-LOT`, → `WOD-SUBLOT`, → `WOD-SERIAL`, → `WOD-UOM`
Uom Details	WODETAIL			`WOR-COMPANY` → `WOD-COMPANY`, `WOR-LOCATION` → `WOD-LOCATION`, `WOR-WORK-ORDER` → `WOD-WORK-ORDER`, `WOR-WORK-ORDER-SUF` → `WOD-WORK-ORDER-SUF`, `"F"` → `WOD-DETAIL-TYPE`, `Zeroes` → `WOD-COMPONENT-SEQ`, → `WOD-BIN`, → `WOD-LOT`, → `WOD-SUBLOT`, → `WOD-SERIAL`, → `WOD-UOM`
Whdemand	WHDEMAND			`WOR-COMPANY` → `WDM-COMPANY`, `WOR-LOCATION` → `WDM-LOCATION`, → `WDM-ITEM`, → `WDM-EST-TRAN-DT`, → `WDM-SYSTEM-CD`, → `WDM-DOC-NBR`, → `WDM-LINE-NBR`, → `WDM-COMPONENT-SEQ`
Whsupply	WHDEMAND			`WOR-COMPANY` → `WDM-COMPANY`, `WOR-LOCATION` → `WDM-LOCATION`, `"WO"` → `WDM-SYSTEM-CD`, `WOR-WO-ALPHA` → `WDM-DOC-NBR`, → `WDM-LINE-NBR`, → `WDM-COMPONENT-SEQ`
Wobyprod	WOBYPROD	Delete Restricted		`WOR-COMPANY` → `WOB-COMPANY`, `WOR-LOCATION` → `WOB-LOCATION`, `WOR-WORK-ORDER` → `WOB-WORK-ORDER`, `WOR-WORK-ORDER-SUF` → `WOB-WORK-ORDER-SUF`, → `WOB-SEQ`
Wocomp	WOITEM	Delete Restricted		`WOR-COMPANY` → `WOI-COMPANY`, `WOR-LOCATION` → `WOI-LOCATION`, `WOR-WORK-ORDER` → `WOI-WORK-ORDER`, `WOR-WORK-ORDER-SUF` → `WOI-WORK-ORDER-SUF`, → `WOI-COMPONENT-SEQ`
Wodetail	WODETAIL			`WOR-COMPANY` → `WOD-COMPANY`, `WOR-LOCATION` → `WOD-LOCATION`, `WOR-WORK-ORDER` → `WOD-WORK-ORDER`, `WOR-WORK-ORDER-SUF` → `WOD-WORK-ORDER-SUF`, `"F"` → `WOD-DETAIL-TYPE`, `Zeroes` → `WOD-COMPONENT-SEQ`, → `WOD-BIN`, → `WOD-LOT`, → `WOD-SUBLOT`, → `WOD-SERIAL`, → `WOD-UOM`
Woitem	WOITEM			`WOR-COMPANY` → `WOI-COMPANY`, `WOR-LOCATION` → `WOI-LOCATION`, `WOR-WORK-ORDER` → `WOI-WORK-ORDER`, `WOR-WORK-ORDER-SUF` → `WOI-WORK-ORDER-SUF`, → `WOI-COMPONENT-SEQ`

Programs

Updated by (2)

WH20.7 Substitute Location
WHD3.1 WH-IC Detail Integrity Check

Referenced by (5)

IC01.1 Company
IC02.1 Location
IC62.1 Finished Goods
IC62.4 Component Finished Goods
WHD2.1 WH-IC Integrity Check