WODETAIL FILE
Work Order Item Details
The Work Order detail information for finished goods, byproducts, and
components are contained in this file, whenever the items are bin, lot, or
serial number tracked or have multiple units of measure.
REFERENCED BY
WO120 WO132 WO133 WO140 WO20.1 WO30.1
WO256 WO81.2 WO81.1
UPDATED BY
WO300 WO32.2 WO32.3 WO32.4 WO32.5 WO40.1
WO40.2 WO40.3 WO40.4 WO40.5 WO40.6 WO41.1
WO41.2 WO41.3 WO41.4 WO42.1 WO42.2 WO42.3
WO42.4 WO42.5 WO45.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WOD-COMPANY Numeric 4 WO32.2 WO32.3
Company This field contains the company number, WO32.4 WO32.5
as defined in the Inventory Control WO40.2 WO40.3
system. WO40.4 WO40.5
WO41.1 WO41.2
WO41.3 WO41.4
WO42.2 WO42.3
WO42.4 WO42.5
WOD-LOCATION Alpha 5 WO32.2 WO32.3
Location This field contains a valid stock WO32.4 WO32.5
location within the company inventory. WO40.2 WO40.3
It is also the production facility WO40.4 WO40.5
where finished goods are produced. WO41.1 WO41.2
WO41.3 WO41.4
WO42.2 WO42.3
WO42.4 WO42.5
WOD-WORK-ORDER Numeric 8 WO32.2 WO32.3
Work Order This identifies the work order and may WO32.4 WO32.5
be automatically assigned or manually WO40.2 WO40.3
assigned, depending on the option WO40.4 WO40.5
defined for each production (inventory) WO41.1 WO41.2
location. WO41.3 WO41.4
WO42.2 WO42.3
WO42.4 WO42.5
WO45.1
WOD-WORK-ORDER-SUF Numeric 2 WO32.2 WO32.3
Work Order Suffix This will normally be zero for a work WO32.4 WO32.5
order. If you chose to split a work WO40.2 WO40.3
order so the completed part of the WO40.4 WO40.5
finished goods can be available for WO41.1 WO41.2
allocation, the work order created for WO41.3 WO41.4
the remaining quantity will have a WO42.2 WO42.3
non-zero value in this field. WO42.4 WO42.5
WO45.1
WOD-DETAIL-TYPE Alpha 1 WO32.2 WO32.3
Detail Type The detail type indicates whether this WO32.4 WO32.5
record is for the finished good, a WO40.2 WO40.3
byproduct or a component. WO40.4 WO40.5
B = Byproduct WO41.1 WO41.2
C = Component WO41.3 WO41.4
F = Finished Good WO42.2 WO42.3
WO42.4 WO42.5
WOD-COMPONENT-SEQ Numeric 3 WO32.2 WO32.3
Component Sequence This field contains the component WO32.4 WO32.5
sequence number or the byproduct WO40.2 WO40.3
sequence number when the record is for a WO40.4 WO40.5
component or a byproduct. WO41.1 WO41.2
WO41.3 WO41.4
WO42.2 WO42.3
WO42.4 WO42.5
WOD-BIN Alpha 7 WO32.2 WO32.3
Bin This field contains a storage area for WO32.4 WO32.5
an item or any number of items. WO40.2 WO40.3
WO40.4 WO40.5
WO41.1 WO41.2
WO41.3 WO41.4
WO42.2 WO42.3
WO42.4 WO42.5
WOD-LOT Alpha 10 WO32.2 WO32.3
Lot This field contains the identifier for WO32.4 WO32.5
the homogeneous quantity of material. WO40.2 WO40.3
WO40.4 WO40.5
WO41.1 WO41.2
WO41.3 WO41.4
WO42.2 WO42.3
WO42.4 WO42.5
WOD-SUBLOT Alpha 6 WO32.2 WO32.3
Sublot This field contains the identifier for WO32.4 WO32.5
a detail breakdown of a lot number. WO40.2 WO40.3
WO40.4 WO40.5
WO41.1 WO41.2
WO41.3 WO41.4
WO42.2 WO42.3
WO42.4 WO42.5
WOD-SERIAL Alpha 16 WO32.2 WO32.3
Serial This field contains the identification WO32.4 WO32.5
number for an individual unit. This WO40.2 WO40.3
number is used for tracking purposes. WO40.4 WO40.5
WO41.1 WO41.2
WO41.3 WO41.4
WO42.2 WO42.3
WO42.4 WO42.5
WOD-UOM Alpha 4 WO32.2 WO32.3
Unit of Measure This field contains the unit of measure WO32.4 WO32.5
for the quantity in this detail record. WO40.2 WO40.3
WO40.4 WO40.5
WO41.1 WO41.2
WO41.3 WO41.4
WO42.2 WO42.3
WO42.4 WO42.5
WOD-UOM-MULT Signed 13.7 WO32.2 WO32.3
Unit of Measure This field contains the multiplier for WO32.4 WO32.5
Multiplier converting this unit of measure to the WO40.2 WO40.3
stock unit of measure. WO40.5 WO41.1
WO41.2 WO41.4
WO42.2 WO42.3
WO42.5
WOD-ACTUAL-QTY Signed 13.4 WO120 WO20.1
Actual Quantity This is the actual quantity of a WO30.1 WO32.1
component that was used (not wasted) for WO32.2 WO32.3
the process of making the finished good. WO32.4 WO32.5
For finished good and byproduct detail WO40.1 WO40.2
records, this field is the actual WO40.3 WO40.4
quantity produced for this detail. WO40.5 WO41.1
WO41.2 WO41.3
WO41.4 WO42.1
WO42.2 WO42.3
WO42.4 WO42.5
WOD-ACT-CTW-QTY Signed 13.4 WO40.1 WO40.2
Actual Catch Weight This is the actual catch weight WO40.3 WO40.4
Quantity quantity of the component that was used WO40.5 WO41.1
(not wasted) for the process of making WO41.2 WO41.3
the finished good. This field would WO41.4 WO42.1
always be zero for finished goods and WO42.2 WO42.3
byproducts. WO42.4 WO42.5
WOD-QUANTITY Signed 13.4 WO32.2 WO32.3
Quantity This is the quantity of the component WO32.4 WO32.5
that was picked for this detail. This WO40.1 WO40.2
would be zero for finished goods and WO40.3 WO40.4
byproducts. WO40.5 WO41.1
WO41.2 WO41.3
WO41.4 WO42.1
WO42.2 WO42.3
WO42.4 WO42.5
WOD-CATCH-WT-QTY Signed 13.4 WO32.2 WO32.3
Catch Weight This is the catch weight quantity of WO32.4
Quantity the component that was picked for this
detail. This would be zero for finished
goods and byproducts.
WOD-KIT-SERIAL Alpha 16 WO40.6
Kit Serial When this detail is for a component
that is serial number tracked and the
finished good is serial number tracked,
the serial number for the finished good
will be in this field if the finished
good and component have been linked
together by serial numbers during
production feedback.
WOD-WASTE-QTY Signed 13.4 WO120 WO20.1
Waste Quantity For component details, this is the WO30.1 WO32.1
quantity that was wasted rather than WO32.2 WO32.3
actually being used in the finished WO32.4 WO32.5
good. This field will be zero for WO40.1 WO40.2
finished good and byproduct detail WO40.3 WO40.4
records. WO40.5 WO41.1
WO41.2 WO41.3
WO41.4 WO42.1
WO42.2 WO42.3
WO42.4 WO42.5
WOD-WST-CTW-QTY Signed 13.4 WO40.1 WO40.2
Waste Catch Weight For component details, this is the WO40.3 WO40.4
Quantity catch weight quantity that was wasted WO40.5 WO41.1
rather than actually being used in the WO41.2 WO41.3
finished good. This field will be zero WO41.4 WO42.1
for finished good and byproduct detail WO42.2 WO42.3
records. WO42.4 WO42.5
WOD-ITEM Alpha 32 WO32.2 WO32.3
Item This field contains the item identifier WO32.4 WO32.5
for the finished good, byproduct or WO40.2 WO40.3
component that the detail record is for. WO40.4 WO40.5
WO41.1 WO41.2
WO41.3 WO41.4
WO42.2 WO42.3
WO42.4 WO42.5
WOD-LOT-STRING Derived
Lot String The system displays a string field that
contains LOT, SUBLOT, BIN, and UOM
fields.
WOD-BIN-STRING Derived
Bin String The system displays a string field that
contains BIN and UOM fields.
WOD-SERIAL-STRING Derived
Serial String The system displays a string field that
contains BIN, SERIAL, and UOM fields.
WOD-UOM-STRING Derived
Unit of Measure The system displays a string field that
String contains the UOM field.
WOD-PRINT-STRING Derived
Print String The system displays a conditional field
that contains SERIAL-STRING, LOT-STRING,
BIN-STRING or UOM-STRING depending on
the type of detail tracked item.
WODETAIL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WODSET1 COMPANY This index is used to access Work Order WO120 WO132
LOCATION detail records for finished goods, WO133 WO140
WORK-ORDER components, or byproducts for a work WO20.1 WO30.1
WORK-ORDER-SUForder at a production location. This WO300 WO32.1
DETAIL-TYPE index accesses a specific bin, lot, WO32.2 WO32.3
COMPONENT-SEQ sublot, serial number, or unit of WO32.4 WO32.5
BIN measure record for the finished goods, WO40.1 WO40.2
LOT components, or byproducts. WO40.3 WO40.4
SUBLOT WO40.5 WO41.1
SERIAL WO41.2 WO41.3
UOM WO41.4 WO42.1
WO42.2 WO42.3
WO42.4 WO42.5
WO45.1
WODSET2 COMPANY This index is used to access Work Order WO40.6
LOCATION detail records for a finished good that
WORK-ORDER is serial number tracked for a specific
WORK-ORDER-SUFwork order at a production location.
SERIAL Subset
Where DETAIL-TYPE = "F"
And SERIAL != Spaces
WODSET3 COMPANY This index is used to access Work Order WO256 WO40.6
ITEM detail records for finished goods, WO81.2
SERIAL components, or byproducts that are
tracked by serial number.
KeyChange, Duplicates, Subset
Where SERIAL != Spaces
WODSET4 COMPANY This index is used to access Work Order WO256 WO81.1
ITEM detail records for finished goods,
LOT components, or byproducts that are
SUBLOT tracked by lot number for a specific
LOCATION work order at a production location.
WORK-ORDER KeyChange, Duplicates, Subset
WORK-ORDER-SUFWhere LOT != Spaces
DETAIL-TYPE Or SUBLOT != Spaces
COMPONENT-SEQ
UOM
WODETAIL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
WOD-COMPANY -> ICC-COMPANY
Itemloc ITEMLOC Required
WOD-COMPANY -> ITL-COMPANY
WOD-LOCATION -> ITL-LOCATION
WOI-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
WOI-ITEM -> ITE-ITEM
Sohdetail SOHDETAIL Not Required
WOD-COMPANY -> SDT-COMPANY
WOD-LOCATION -> SDT-LOCATION
WOI-ITEM -> SDT-ITEM
WOD-UOM -> SDT-UOM
WOD-LOT -> SDT-LOT
WOD-SUBLOT -> SDT-SUBLOT
WOD-BIN -> SDT-BIN
Woitem WOITEM Required
WOD-COMPANY -> WOI-COMPANY
WOD-LOCATION -> WOI-LOCATION
WOD-WORK-ORDER -> WOI-WORK-ORDER
WOD-WORK-ORDER-SUF -> WOI-WORK-ORDER-SUF
WOD-COMPONENT-SEQ -> WOI-COMPONENT-SEQ
WODETAIL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ictransdtl ICTRANSDTL
WOD-COMPANY -> ICD-COMPANY
WOD-LOCATION -> ICD-LOCATION
WOD-ITEM -> ICD-ITEM
WOD-SERIAL -> ICD-LOT-SERIAL
ICD-UPDATE-DATE
ICD-UPDATE-TIME
ICD-SHIPMENT-NBR
ICD-LINE-NBR
ICD-COMPONENT-SEQ
ICD-SEQ
|