WOITEM – Work Order Items
- System
- WO (WO)
- Prefix
WOI- Primary key
COMPANY,LOCATION,WORK-ORDER,WORK-ORDER-SUF,COMPONENT-SEQ- Fields
- 33
- Updated by
- 1 program
- Referenced by
- 1 program
WOITEM is the Work Order Items table in Lawson WO (prefix WOI). It is indexed by COMPANY, LOCATION, WORK-ORDER, WORK-ORDER-SUF, COMPONENT-SEQ (WOISET1); alternate indexes: WOISET2, WOISET3, WOISET4 and WOISET5. It is related 1:1 to ICCOMPANY, ICLOCATION, ITEMLOC, ITEMMAST, GLMASTER, WORDER and WOWOIUF and 1:M to WODETAIL, ITEMSUB, ITSERIAL and SOHDETAIL. It is updated by WHD3.1 and referenced by WHD2.1. The table has 33 fields, 5 indexes and 17 documented relations.
About WOITEM
The Work Order Items file contains information about components used in the process of producing a finished good for a specific work order.
Fields (33)
Column = COBOL field name without the WOI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
WOI-COMPANY PKCOMPANY | Numeric 4 | This field contains the company number, as defined in the Inventory Control system. | — |
WOI-LOCATION PKLOCATION | Alpha 5 | This field contains a valid stock location within the company inventory. It is also the production facility where finished goods are produced. | — |
WOI-WORK-ORDER PKWORK_ORDER | Numeric 8 | This field identifies the work order and may be automatically assigned or manually assigned, depending on the option defined for each production (inventory) location. | — |
WOI-WORK-ORDER-SUF PKWORK_ORDER_SUF | Numeric 2 | This field 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. | — |
WOI-COMPONENT-SEQ PKCOMPONENT_SEQ | Numeric 3 | The component sequence number is the order in which this component is added to the finished good during the production process. | — |
WOI-COMPONENT-TYPECOMPONENT_TYPE | Alpha 1 | The component type specifies whether the component is an inventory component used in the production of the finished good, a packaging item, or an offsite item.
| — |
WOI-ITEMITEM | Alpha 32 | This field contains the item identifier of the component, as defined in the Inventory Control system. | — |
WOI-INV-LOCATIONINV_LOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | — |
WOI-PLAN-QTYPLAN_QTY | Signed 13.4 | This field contains the planned quantity for an item for a work order. | — |
WOI-ACTUAL-QTYACTUAL_QTY | Signed 13.4 | This is the actual quantity of the component used to make the finished goods for this work order. | — |
WOI-ACT-CTW-QTYACT_CTW_QTY | Signed 13.4 | This is the actual catch weight quantity of the component used to make the finished goods for this work order. | — |
WOI-PICKED-QTYPICKED_QTY | Signed 13.4 | This is the quantity of the component that was picked for the work order. | — |
WOI-DETAIL-QTYDETAIL_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. | — |
WOI-CATCH-WT-QTYCATCH_WT_QTY | Signed 13.4 | This is the catch weight quantity of the component that was picked for the work order. | — |
WOI-DTL-CTW-QTYDTL_CTW_QTY | Signed 13.4 | This field is not currently used by the Work Order system. | — |
WOI-WST-ACCT-UNITWST_ACCT_UNIT | Alpha 15 | The waste account unit is part of the account where the cost of components that were wasted during the work order production process are posted. The cost of wasted components are not included in the cost of the finished good. | — |
WOI-WST-ACCOUNTWST_ACCOUNT | Numeric 6 | The waste account is part of the account where the cost of the components that were wasted during the work order production process are posted. The cost of wasted components are not included in the cost the finished good. | — |
WOI-WST-SUB-ACCTWST_SUB_ACCT | Numeric 4 | The waste subaccount is part of the account where the cost of components that were wasted during the work order process are posted. The cost of wasted components are not included in the cost of the finished good. | — |
WOI-WASTE-QTYWASTE_QTY | Signed 13.4 | This is the quantity of the component that was wasted during the work order production process and was not used in the finished good. | — |
WOI-WST-CTW-QTYWST_CTW_QTY | Signed 13.4 | This is the catch weight quantity of the component that was wasted during the work order production process and was not used in the finished good. | — |
WOI-EST-COMP-COSTEST_COMP_COST | Signed 18.5 | This is the estimated unit cost of the component. | — |
WOI-ACT-COMP-COSTACT_COMP_COST | Signed 18.5 | This is the actual unit cost of components that were not picked but were consumed, that is, used in the finished good or wasted. This field will be zero if the picked quantity is greater than the sum of the actual quantity and the waste quantity. | — |
WOI-PICKED-COSTPICKED_COST | Signed 18.5 | This is the unit cost for components that were picked. | — |
WOI-TOT-ACT-COSTTOT_ACT_COST | Signed 18.5 | This is the extended cost of the components used to make the finished goods for this work order. The cost of any wasted components is not included in this field. | — |
WOI-TOT-WASTE-COSTTOT_WASTE_COST | Signed 18.5 | This is the extended cost of components that were wasted during the production process for this work order. This cost is not included in the inventory costs of the finished good produced. | — |
WOI-QTY-TOL-PCTQTY_TOL_PCT | Percent 5.3 (Percent) | This field contains the quantity tolerance percent of the component. | — |
WOI-ZERO-QTY-FLZERO_QTY_FL | Alpha 1 | The zero quantity tolerance flag is used to indicate if zero tolerance is allowed for the component on this work order. This field is loaded from the component definition on the finished good template when the component is added to the work order through work order explosion or another entry method.
| — |
WOI-WALK-THRU-REQWALK_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. | — |
WOI-DISP-INV-LOCDISP_INV_LOC | Derived | The system displays a string that contains inventory location (INV-LOCATION) preceded by a label for the inventory location. | — |
WOI-DISP-LOCATIONDISP_LOCATION | Derived | The system displays a conditional field that will contain display inventory location (DISP-INV-LOC) if the value of inventory location (INV-LOCATION) is different than location (LOCATION). | — |
WOI-ME-ACCT-UNITME_ACCT_UNIT | Alpha 15 | The material expense account unit is used to record component costs associated with the production of finished goods. | — |
WOI-ME-ACCOUNTME_ACCOUNT | Numeric 6 | The material expense account is used to record component costs associated with the production of finished goods. | — |
WOI-ME-SUB-ACCTME_SUB_ACCT | Numeric 4 | The material expense subaccount is used to record component costs associated with the production of finished goods. | — |
Indexes (5)
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 |
|---|---|---|---|---|
WOISET1 | COMPANY, LOCATION, WORK-ORDER, WORK-ORDER-SUF, COMPONENT-SEQ | Primary | WHD2.1, WHD3.1 | |
WOISET2 | COMPANY, LOCATION, WORK-ORDER, WORK-ORDER-SUF, INV-LOCATION, COMPONENT-SEQ | KeyChange | — | |
WOISET3 | COMPANY, LOCATION, WORK-ORDER, WORK-ORDER-SUF, COMPONENT-TYPE, COMPONENT-SEQ | KeyChange | — | |
WOISET4 | COMPANY, LOCATION, WORK-ORDER, WORK-ORDER-SUF, COMPONENT-SEQ | KeyChange, Subset | Where (WALK-THRU-REQ = "Y") | — |
WOISET5 | COMPANY, LOCATION, WORK-ORDER, WORK-ORDER-SUF, COMPONENT-SEQ | KeyChange, Subset | Where COMPONENT-TYPE != "O" | — |
Relations
One to one (8) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Iccompany | ICCOMPANY | Required | WOI-COMPANY → ICC-COMPANY (ICCSET1) | |
| Iclocation | ICLOCATION | Required | WOI-COMPANY → ICL-COMPANY, WOI-INV-LOCATION → ICL-LOCATION | |
| Itemloc | ITEMLOC | Not Required | WOI-COMPANY → ITL-COMPANY, WOI-INV-LOCATION → ITL-LOCATION, WOI-ITEM → ITL-ITEM | |
| Itemmast | ITEMMAST | Required | ICC-ITEM-GROUP → ITE-ITEM-GROUP, WOI-ITEM → ITE-ITEM | |
| Waste Account | GLMASTER | Not Required | Valid When WOI-WST-ACCT-UNIT != Spaces Or WOI-WST-ACCOUNT != Zeroes Or WOI-WST-SUB-ACCT != Zeroes | WOI-COMPANY → GLM-COMPANY, WOI-WST-ACCT-UNIT → GLM-ACCT-UNIT, WOI-WST-ACCOUNT → GLM-ACCOUNT, WOI-WST-SUB-ACCT → GLM-SUB-ACCOUNT |
| Wo Location | ICLOCATION | Required | WOI-COMPANY → ICL-COMPANY, WOI-LOCATION → ICL-LOCATION | |
| Worder | WORDER | Required | WOI-COMPANY → WOR-COMPANY, WOI-LOCATION → WOR-LOCATION, WOI-WORK-ORDER → WOR-WORK-ORDER, WOI-WORK-ORDER-SUF → WOR-WORK-ORDER-SUF | |
| Wowoiuf | WOWOIUF | Not Required | WOI-COMPANY → WIU-COMPANY, WOI-LOCATION → WIU-LOCATION, WOI-WORK-ORDER → WIU-WORK-ORDER, WOI-WORK-ORDER-SUF → WIU-WORK-ORDER-SUF, WOI-COMPONENT-SEQ → WIU-COMPONENT-SEQ |
One to many (9) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Bins | WODETAIL | Valid When ITE-LOT-TRACK-FL = "N" And ITE-SER-TRACK-FL = "N" And ITL-BIN-TRACK-FL = "Y" | WOI-COMPANY → WOD-COMPANY, WOI-LOCATION → WOD-LOCATION, WOI-WORK-ORDER → WOD-WORK-ORDER, WOI-WORK-ORDER-SUF → WOD-WORK-ORDER-SUF, "C" → WOD-DETAIL-TYPE, WOI-COMPONENT-SEQ → WOD-COMPONENT-SEQ, WOD-BIN, WOD-LOT, WOD-SUBLOT, WOD-SERIAL, WOD-UOM | |
| Itemsub | ITEMSUB | ICC-ITEM-GROUP → ITS-ITEM-GROUP, WOI-ITEM → ITS-ITEM, "S" → ITS-SUBTYPE, ITS-SUB-ITEM | ||
| Itserial | ITSERIAL | Valid When ITE-SER-TRACK-FL != "N" | WOI-COMPANY → SER-COMPANY, WOI-ITEM → SER-ITEM, SER-SERIAL | |
| Lots | WODETAIL | Valid When ITE-LOT-TRACK-FL = "Y" | WOI-COMPANY → WOD-COMPANY, WOI-LOCATION → WOD-LOCATION, WOI-WORK-ORDER → WOD-WORK-ORDER, WOI-WORK-ORDER-SUF → WOD-WORK-ORDER-SUF, "C" → WOD-DETAIL-TYPE, WOI-COMPONENT-SEQ → WOD-COMPONENT-SEQ, WOD-BIN, WOD-LOT, WOD-SUBLOT, WOD-SERIAL, WOD-UOM | |
| Serials | WODETAIL | Valid When ITE-SER-TRACK-FL != "N" | WOI-COMPANY → WOD-COMPANY, WOI-LOCATION → WOD-LOCATION, WOI-WORK-ORDER → WOD-WORK-ORDER, WOI-WORK-ORDER-SUF → WOD-WORK-ORDER-SUF, "C" → WOD-DETAIL-TYPE, WOI-COMPONENT-SEQ → WOD-COMPONENT-SEQ, WOD-BIN, WOD-LOT, WOD-SUBLOT, WOD-SERIAL, WOD-UOM | |
| Sohbins | SOHDETAIL | Valid When ITE-LOT-TRACK-FL = "N" And ITE-SER-TRACK-FL = "N" And ITL-BIN-TRACK-FL = "Y" | WOI-COMPANY → SDT-COMPANY, WOI-LOCATION → SDT-LOCATION, WOI-ITEM → SDT-ITEM, SDT-UOM, SDT-LOT, SDT-SUBLOT, SDT-BIN | |
| Sohlots | SOHDETAIL | Valid When ITE-LOT-TRACK-FL = "Y" | WOI-COMPANY → SDT-COMPANY, WOI-LOCATION → SDT-LOCATION, WOI-ITEM → SDT-ITEM, SDT-UOM, SDT-LOT, SDT-SUBLOT, SDT-BIN | |
| Uoms | WODETAIL | WOI-COMPANY → WOD-COMPANY, WOI-LOCATION → WOD-LOCATION, WOI-WORK-ORDER → WOD-WORK-ORDER, WOI-WORK-ORDER-SUF → WOD-WORK-ORDER-SUF, "C" → WOD-DETAIL-TYPE, WOI-COMPONENT-SEQ → WOD-COMPONENT-SEQ, WOD-BIN, WOD-LOT, WOD-SUBLOT, WOD-SERIAL, WOD-UOM | ||
| Wodetail | WODETAIL | WOI-COMPANY → WOD-COMPANY, WOI-LOCATION → WOD-LOCATION, WOI-WORK-ORDER → WOD-WORK-ORDER, WOI-WORK-ORDER-SUF → WOD-WORK-ORDER-SUF, "C" → WOD-DETAIL-TYPE, WOI-COMPONENT-SEQ → WOD-COMPONENT-SEQ, WOD-BIN, WOD-LOT, WOD-SUBLOT, WOD-SERIAL, WOD-UOM |
Programs
Updated by (1)
- WHD3.1 WH-IC Detail Integrity Check
Referenced by (1)
- WHD2.1 WH-IC Integrity Check