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.
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WOB-COMPANY Numeric 4
Company This field contains the company number,
as defined in the Inventory Control
system.
WOB-LOCATION Alpha 5
Location Code 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 Numeric 8
Work Order 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 Numeric 2
Work Order Suf 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 Numeric 3
Sequence Number This field contains the sequence number
of the byproduct on the work order.
WOB-ITEM Alpha 32
Item Number This field contains the item identifier
of the byproduct, as defined in the
Inventory Control system.
WOB-QUANTITY Signed 13.4
Quantity This is the estimated quantity of the
byproduct that will be produced by this
work order.
WOB-ACTUAL-QTY Signed 13.4
Actual Qty This is the actual quantity of the
byproduct that was produced for the work
order.
WOB-DETAIL-QTY Signed 13.4
Detail Qty 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
Walk Thru Req 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 Signed 13.5
Fgv Amount 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.
WOBYPROD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WOBSET1 COMPANY This index is used to access Work Order
LOCATION byproduct records for a specific work
WORK-ORDER order and byproduct sequence number at
WORK-ORDER-SUFa production location.
SEQ
WOBSET2 COMPANY This index is used to access Work Order
LOCATION byproduct records (within the feedback
WORK-ORDER process if WalkThru is required) for a
WORK-ORDER-SUFspecific work order and byproduct
SEQ sequence number at a production
location.
KeyChange, Subset
Where (WALK-THRU-REQ = "Y" )
WOBYPROD FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
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
|
