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. |
|
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 |
|
| |||||||||||||||||||
WODSET2 |
COMPANY LOCATION WORK-ORDER WORK-ORDER-SUF SERIAL |
|
||||||||||||||||||||
WODSET3 |
COMPANY ITEM SERIAL |
|
||||||||||||||||||||
WODSET4 |
COMPANY ITEM LOT SUBLOT LOCATION WORK-ORDER WORK-ORDER-SUF DETAIL-TYPE COMPONENT-SEQ UOM |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Iccompany | ICCOMPANY |
Required
| |||||||||||||||||||||
Itemloc | ITEMLOC |
Required
| |||||||||||||||||||||
Itemmast | ITEMMAST |
Required
| |||||||||||||||||||||
Sohdetail | SOHDETAIL |
Not Required
| |||||||||||||||||||||
Woitem | WOITEM |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.