WOBYPROD FILE
Work Order Byproducts
The Work Order Byproducts file contains information about byproducts that are
produced as a result of the process that creates the finished good.
REFERENCED BY
WO132 WO133 WO140 WO252 WO256
UPDATED BY
WO120 WO20.1 WO30.1 WO30.2 WO300 WO32.1
WO32.2 WO32.3 WO32.4 WO32.5 WO40.1 WO40.2
WO40.3 WO40.4 WO40.5 WO41.1 WO41.2 WO41.3
WO41.4 WO42.1 WO42.2 WO42.3 WO42.4 WO42.5
WO45.1 WOEX.1 WOSP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WOB-COMPANY Numeric 4 WO30.2 WO42.1
Company This field contains the company number, WOEX.1
as defined in the Inventory Control
system.
WOB-LOCATION Alpha 5 WO30.2 WO42.1
Location This field contains a valid stock WOEX.1
location within the company inventory.
It is also the production facility
where finished goods are produced.
WOB-WORK-ORDER Numeric 8 WO30.2 WO42.1
Work Order This identifies the work order and may WO45.1 WOEX.1
be automatically assigned or manually
assigned, depending on the option
defined for each production (inventory)
location.
WOB-WORK-ORDER-SUF Numeric 2 WO30.2 WO42.1
Work Order Suffix This will normally be zero for a work WO45.1 WOEX.1
order. If you chose to split a work WOSP.1
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 Numeric 3 WO30.2 WO42.1
Sequence This field contains the sequence number WOEX.1
of the byproduct on the work order.
WOB-ITEM Alpha 32 WO30.2 WO42.1
Item This field contains the item identifier WOEX.1
of the byproduct, as defined in the
Inventory Control system.
WOB-QUANTITY Signed 13.4 WO30.2 WOEX.1
Quantity This is the estimated quantity of the WOSP.1
byproduct that will be produced by this
work order.
WOB-ACTUAL-QTY Signed 13.4 WO40.1 WO40.2
Actual Quantity This is the actual quantity of the WO40.3 WO40.4
byproduct that was produced for the work WO40.5 WO41.1
order. WO41.2 WO41.3
WO41.4 WO42.1
WO42.2 WO42.3
WO42.4 WO42.5
WOSP.1
WOB-DETAIL-QTY Signed 13.4
Detail Quantity 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 Alpha 1 WO120 WO20.1
Walkthrough Required This field indicates that a transaction WO30.1 WO30.2
line is out of balance. For example, if WO32.1 WO32.2
lot, bin, or serial number quantities do WO32.3 WO32.4
not equal the transaction quantity, WO32.5 WO40.1
select the WalkThru form action to WO40.2 WO40.3
balance the transaction quantities. WO40.4 WO40.5
WO41.1 WO41.2
WO41.3 WO41.4
WO42.1 WO42.2
WO42.3 WO42.4
WO42.5 WOEX.1
WOB-FGV-AMOUNT Signed 13.5
Finished Good The finished good variance amount on a
Variance Amount work order byproduct is the result of a
cost being returned from inventory for a
byproduct on a reverse work order.
WOBYPROD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WOBSET1 COMPANY This index is used to access Work Order WO120 WO132
LOCATION byproduct records for a specific work WO133 WO140
WORK-ORDER order and byproduct sequence number at WO20.1 WO252
WORK-ORDER-SUFa production location. WO256 WO30.1
SEQ WO30.2 WO300
WO32.1 WO32.2
WO32.3 WO32.4
WO32.5 WO40.1
WO40.2 WO40.3
WO40.4 WO40.5
WO41.1 WO41.2
WO41.3 WO41.4
WO42.1 WO42.2
WO42.3 WO42.4
WO42.5 WO45.1
...
WOBSET2 COMPANY This index is used to access Work Order WO120 WO20.1
LOCATION byproduct records (within the feedback WO30.1 WO32.1
WORK-ORDER process if WalkThru is required) for a WO32.2 WO32.3
WORK-ORDER-SUFspecific work order and byproduct WO32.4 WO32.5
SEQ sequence number at a production WO40.1 WO40.2
location. WO40.3 WO40.4
KeyChange, Subset WO40.5 WO41.1
Where (WALK-THRU-REQ = "Y" ) WO41.2 WO41.3
WO41.4 WO42.1
WO42.2 WO42.3
WO42.4 WO42.5
WOBYPROD FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
WOB-COMPANY -> ICC-COMPANY
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
WOBYPROD FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bins WODETAIL
Valid When WOB-LOT-TRACK-FL = "N"
And WOB-SER-TRACK-FL = "N"
And WOB-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 WOB-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 WOB-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
|