WODETAIL

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


WODETAIL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 02:34:40 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.