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.
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WOD-COMPANY Numeric 4
Company This field contains the company number,
as defined in the Inventory Control
system.
WOD-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.
WOD-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.
WOD-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.
WOD-DETAIL-TYPE Alpha 1
Detail Type The detail type indicates whether this
record is for the finished good, a
byproduct or a component.
B = Byproduct
C = Component
F = Finished Good
WOD-COMPONENT-SEQ Numeric 3
Component Sequence This field contains the component
Number sequence number or the byproduct
sequence number when the record is for a
component or a byproduct.
WOD-BIN Alpha 7
Bin This field contains a storage area for
an item or any number of items.
WOD-LOT Alpha 10
Lot Number This field contains the identifier for
the homogeneous quantity of material.
WOD-SUBLOT Alpha 6
Sublot Number This field contains the identifier for
a detail breakdown of a lot number.
WOD-SERIAL Alpha 16
Serial Number This field contains the identification
number for an individual unit. This
number is used for tracking purposes.
WOD-UOM Alpha 4
Unit of Measure This field contains the unit of measure
for the quantity in this detail record.
WOD-UOM-MULT Signed 13.7
Unit of Measure This field contains the multiplier for
Multiplier converting this unit of measure to the
stock unit of measure.
WOD-ACTUAL-QTY Signed 13.4
Actual Qty This is the actual quantity of a
component that was used (not wasted) for
the process of making the finished good.
For finished good and byproduct detail
records, this field is the actual
quantity produced for this detail.
WOD-ACT-CTW-QTY Signed 13.4
Act Ctw Qty This is the actual catch weight
quantity of the component that was used
(not wasted) for the process of making
the finished good. This field would
always be zero for finished goods and
byproducts.
WOD-QUANTITY Signed 13.4
Quantity This is the quantity of the component
that was picked for this detail. This
would be zero for finished goods and
byproducts.
WOD-CATCH-WT-QTY Signed 13.4
Catch Weight This is the catch weight quantity of
Quantity the component that was picked for this
detail. This would be zero for finished
goods and byproducts.
WOD-KIT-SERIAL Alpha 16
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
Waste Qty For component details, this is the
quantity that was wasted rather than
actually being used in the finished
good. This field will be zero for
finished good and byproduct detail
records.
WOD-WST-CTW-QTY Signed 13.4
Wst Ctw Qty For component details, this is the
catch weight quantity that was wasted
rather than actually being used in the
finished good. This field will be zero
for finished good and byproduct detail
records.
WOD-ITEM Alpha 32
Item Number This field contains the item identifier
for the finished good, byproduct or
component that the detail record is for.
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
Uom String The system displays a string field that
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
LOCATION detail records for finished goods,
WORK-ORDER components, or byproducts for a work
WORK-ORDER-SUForder at a production location. This
DETAIL-TYPE index accesses a specific bin, lot,
COMPONENT-SEQ sublot, serial number, or unit of
BIN measure record for the finished goods,
LOT components, or byproducts.
SUBLOT
SERIAL
UOM
WODSET2 COMPANY This index is used to access Work Order
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
ITEM detail records for finished goods,
SERIAL components, or byproducts that are
tracked by serial number.
KeyChange, Subset
Where SERIAL != Spaces
WODSET4 COMPANY This index is used to access Work Order
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, 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 (ICCSET1)
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
|
