|
|
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.
UPDATED BY
WHD3.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WOD-COMPANY Numeric 4
Element: Company This field contains the company number,
as defined in the Inventory Control
system.
WOD-LOCATION Alpha 5
Element: Location 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
Element: 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
Element: Work Order SufThis 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
Element: 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
Element: Seq This field contains the component
sequence number or the byproduct
sequence number when the record is for a
component or a byproduct.
WOD-BIN Alpha 7
Element: Bin This field contains a storage area for
an item or any number of items.
WOD-LOT Alpha 10
Element: Lot This field contains the identifier for
the homogeneous quantity of material.
WOD-SUBLOT Alpha 6
Element: Sublot This field contains the identifier for
a detail breakdown of a lot number.
WOD-SERIAL Alpha 16
Element: Serial This field contains the identification
number for an individual unit. This
number is used for tracking purposes.
WOD-UOM Alpha 4
Element: Uom This field contains the unit of measure
for the quantity in this detail record.
WOD-UOM-MULT Signed 13.7
Element: Uom Mult This field contains the multiplier for
converting this unit of measure to the
stock unit of measure.
WOD-ACTUAL-QTY Signed 13.4
Element: Quantity 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
Element: Quantity 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
Element: 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
Element: Quantity This is the catch weight quantity of
the component that was picked for this
detail. This would be zero for finished
goods and byproducts.
WOD-KIT-SERIAL Alpha 16
Element: 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
Element: Quantity 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
Element: Quantity 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
Element: Item This field contains the item identifier
for the finished good, byproduct or
component that the detail record is for.
WOD-EXPIRE-DATE Numeric 8 (yyyymmdd)
Element: Expire Date This field contains the expiration date
for an entire lot.
WOD-LOT-STRING Derived
Element: Lot String The system displays a string field that
contains LOT, SUBLOT, BIN, and UOM
fields.
WOD-BIN-STRING Derived
Element: Bin String The system displays a string field that
contains BIN and UOM fields.
WOD-SERIAL-STRING Derived
Element: Serial String The system displays a string field that
contains BIN, SERIAL, and UOM fields.
WOD-UOM-STRING Derived
Element: Uom String The system displays a string field that
contains the UOM field.
WOD-PRINT-STRING Derived
Element: 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 WHD3.1
LOCATION
WORK-ORDER
WORK-ORDER-SUF
DETAIL-TYPE
COMPONENT-SEQ
BIN
LOT
SUBLOT
SERIAL
UOM
WODSET2 COMPANY Subset
LOCATION Where DETAIL-TYPE = "F"
WORK-ORDER And SERIAL != Spaces
WORK-ORDER-SUF
SERIAL
WODSET3 COMPANY KeyChange, Subset
ITEM Where SERIAL != Spaces
SERIAL
WODSET4 COMPANY KeyChange, Subset
ITEM Where LOT != Spaces
LOT Or SUBLOT != Spaces
SUBLOT
LOCATION
WORK-ORDER
WORK-ORDER-SUF
DETAIL-TYPE
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
|
