WOBYPROD – Work Order Byproducts

System: WO (WO)
Prefix: WOB
Primary key: COMPANY, LOCATION, WORK-ORDER, WORK-ORDER-SUF, SEQ
Fields: 11
Updated by: 1 program
Referenced by: 0 programs

WOBYPROD is the Work Order Byproducts table in Lawson WO (prefix WOB). It is indexed by COMPANY, LOCATION, WORK-ORDER, WORK-ORDER-SUF, SEQ (WOBSET1); alternate indexes: WOBSET2. It is related 1:1 to ICCOMPANY, ICLOCATION, ITEMLOC, ITEMMAST and WORDER and 1:M to WODETAIL. It is updated by WHD3.1. The table has 11 fields, 2 indexes and 10 documented relations.

About WOBYPROD

No description in the Lawson data dictionary.

Fields (11)

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

Field / column	Type	Description & values	Updated by
`WOB-COMPANY` PK COMPANY	Numeric 4	This field contains the company number, as defined in the Inventory Control system.	—
`WOB-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.	—
`WOB-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.	—
`WOB-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.	—
`WOB-SEQ` PK SEQ	Numeric 3	This field contains the sequence number of the byproduct on the work order.	—
`WOB-ITEM` ITEM	Alpha 32	This field contains the item identifier of the byproduct, as defined in the Inventory Control system.	—
`WOB-QUANTITY` QUANTITY	Signed 13.4	This is the estimated quantity of the byproduct that will be produced by this work order.	—
`WOB-ACTUAL-QTY` ACTUAL_QTY	Signed 13.4	This is the actual quantity of the byproduct that was produced for the work order.	—
`WOB-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.	—
`WOB-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.	—
`WOB-FGV-AMOUNT` FGV_AMOUNT	Signed 18.5	The finished good variance amount on a work order byproduct is the result of a cost being returned from inventory for a byproduct on a reverse work order.	—

Indexes (2)

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
`WOBSET1`	`COMPANY`, `LOCATION`, `WORK-ORDER`, `WORK-ORDER-SUF`, `SEQ`	Primary		WHD3.1
`WOBSET2`	`COMPANY`, `LOCATION`, `WORK-ORDER`, `WORK-ORDER-SUF`, `SEQ`	KeyChange, Subset	Where (WALK-THRU-REQ = "Y")	—

Relations

One to one (5) — lookups and parents

Relation	Table	Rules	Field map
Iccompany	ICCOMPANY	Required	`WOB-COMPANY` → `ICC-COMPANY (ICCSET1)`
Iclocation	ICLOCATION	Required	`WOB-COMPANY` → `ICL-COMPANY`, `WOB-LOCATION` → `ICL-LOCATION`
Itemloc	ITEMLOC	Required	`WOB-COMPANY` → `ITL-COMPANY`, `WOB-LOCATION` → `ITL-LOCATION`, `WOB-ITEM` → `ITL-ITEM`
Itemmast	ITEMMAST	Required	`ICC-ITEM-GROUP` → `ITE-ITEM-GROUP`, `WOB-ITEM` → `ITE-ITEM`
Worder	WORDER	Required	`WOB-COMPANY` → `WOR-COMPANY`, `WOB-LOCATION` → `WOR-LOCATION`, `WOB-WORK-ORDER` → `WOR-WORK-ORDER`, `WOB-WORK-ORDER-SUF` → `WOR-WORK-ORDER-SUF`

One to many (5) — child tables

Relation	Table	Condition	Field map
Bins	WODETAIL	Valid When ITE-LOT-TRACK-FL = "N" And ITE-SER-TRACK-FL = "N" And ITL-BIN-TRACK-FL = "Y"	`WOB-COMPANY` → `WOD-COMPANY`, `WOB-LOCATION` → `WOD-LOCATION`, `WOB-WORK-ORDER` → `WOD-WORK-ORDER`, `WOB-WORK-ORDER-SUF` → `WOD-WORK-ORDER-SUF`, `"B"` → `WOD-DETAIL-TYPE`, `WOB-SEQ` → `WOD-COMPONENT-SEQ`, → `WOD-BIN`, → `WOD-LOT`, → `WOD-SUBLOT`, → `WOD-SERIAL`, → `WOD-UOM`
Lots	WODETAIL	Valid When ITE-LOT-TRACK-FL = "Y"	`WOB-COMPANY` → `WOD-COMPANY`, `WOB-LOCATION` → `WOD-LOCATION`, `WOB-WORK-ORDER` → `WOD-WORK-ORDER`, `WOB-WORK-ORDER-SUF` → `WOD-WORK-ORDER-SUF`, `"B"` → `WOD-DETAIL-TYPE`, `WOB-SEQ` → `WOD-COMPONENT-SEQ`, → `WOD-BIN`, → `WOD-LOT`, → `WOD-SUBLOT`, → `WOD-SERIAL`, → `WOD-UOM`
Serials	WODETAIL	Valid When ITE-SER-TRACK-FL != "N"	`WOB-COMPANY` → `WOD-COMPANY`, `WOB-LOCATION` → `WOD-LOCATION`, `WOB-WORK-ORDER` → `WOD-WORK-ORDER`, `WOB-WORK-ORDER-SUF` → `WOD-WORK-ORDER-SUF`, `"B"` → `WOD-DETAIL-TYPE`, `WOB-SEQ` → `WOD-COMPONENT-SEQ`, → `WOD-BIN`, → `WOD-LOT`, → `WOD-SUBLOT`, → `WOD-SERIAL`, → `WOD-UOM`
Uoms	WODETAIL		`WOB-COMPANY` → `WOD-COMPANY`, `WOB-LOCATION` → `WOD-LOCATION`, `WOB-WORK-ORDER` → `WOD-WORK-ORDER`, `WOB-WORK-ORDER-SUF` → `WOD-WORK-ORDER-SUF`, `"B"` → `WOD-DETAIL-TYPE`, `WOB-SEQ` → `WOD-COMPONENT-SEQ`, → `WOD-BIN`, → `WOD-LOT`, → `WOD-SUBLOT`, → `WOD-SERIAL`, → `WOD-UOM`
Wodetail	WODETAIL		`WOB-COMPANY` → `WOD-COMPANY`, `WOB-LOCATION` → `WOD-LOCATION`, `WOB-WORK-ORDER` → `WOD-WORK-ORDER`, `WOB-WORK-ORDER-SUF` → `WOD-WORK-ORDER-SUF`, `"B"` → `WOD-DETAIL-TYPE`, `WOB-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