Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WODETAIL


                             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    WOD0.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WOD-COMPANY            Numeric 4                                 WO32.2  WO32.3
Element: 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
Element: Location Code 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
Element: 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
Element: Work Order SufThis 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
Element: 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
Element: Sequence NumbeThis 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
Element: 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
Element: Lot Number    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
Element: Sublot Number 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
Element: Serial Number 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
Element: Unit of MeasurThis 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.4  WO40.5
                                                                 WO41.1  WO41.2
                                                                 WO41.4  WO42.2
                                                                 WO42.3  WO42.5

WOD-ACTUAL-QTY         Signed 13.4                               WO120   WO20.1
Element: 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
Element: Quantity      This is the actual catch weight           WO40.3  WO40.4
                       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
Element: 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
Element: Quantity      This is the catch weight quantity of      WO32.4  WO40.2
                       the component that was picked for this    WO40.3  WO40.4
                       detail.  This would be zero for finished
                       goods and byproducts.

WOD-KIT-SERIAL         Alpha 16                                  WO40.2  WO40.3
Element: Serial Number When this detail is for a component       WO40.4  WO40.6
                       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
Element: 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
Element: Quantity      For component details, this is the        WO40.3  WO40.4
                       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
Element: Item Number   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-EXPIRE-DATE        Numeric 8  (yyyymmdd)                     WO40.3  WO42.3
Element: Date

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       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  WOD0.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, 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, 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