Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WOBYPROD


                             WOBYPROD FILE

                         Work Order Byproducts

The Work Order Byproducts file contains information about byproducts that are
produced as a result of the process that creates the finished good.

REFERENCED BY

WO132     WO133     WO140     WO252     WO256

UPDATED BY

WO120     WO20.1    WO30.1    WO30.2    WO300     WO32.1
WO32.2    WO32.3    WO32.4    WO32.5    WO40.1    WO40.2
WO40.3    WO40.4    WO40.5    WO41.1    WO41.2    WO41.3
WO41.4    WO42.1    WO42.2    WO42.3    WO42.4    WO42.5
WO45.1    WOD0.1    WOEX.1    WOSP.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WOB-COMPANY            Numeric 4                                 WO30.2  WO42.1
Element: Company       This field contains the company number,   WOEX.1
                       as defined in the Inventory Control
                       system.

WOB-LOCATION           Alpha 5                                   WO30.2  WO42.1
Element: Location Code This field contains a valid stock         WOEX.1
                       location within the company inventory.
                       It is also the production facility
                       where finished goods are produced.

WOB-WORK-ORDER         Numeric 8                                 WO30.2  WO42.1
Element: Work Order    This identifies the work order and may    WO45.1  WOEX.1
                       be automatically assigned or manually
                       assigned, depending on the option
                       defined for each production (inventory)
                       location.


WOB-WORK-ORDER-SUF     Numeric 2                                 WO30.2  WO42.1
Element: Work Order SufThis will normally be zero for a work     WO45.1  WOEX.1
                       order.  If you chose to split a work      WOSP.1
                       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.



WOB-SEQ                Numeric 3                                 WO30.2  WO42.1
Element: Sequence NumbeThis field contains the sequence number   WOEX.1
                       of the byproduct on the work order.

WOB-ITEM               Alpha 32                                  WO30.2  WO42.1
Element: Item Number   This field contains the item identifier   WOEX.1
                       of the byproduct, as defined in the
                       Inventory Control system.

WOB-QUANTITY           Signed 13.4                               WO30.2  WOEX.1
Element: Quantity      This is the estimated quantity of the     WOSP.1
                       byproduct that will be produced by this
                       work order.

WOB-ACTUAL-QTY         Signed 13.4                               WO40.1  WO40.2
Element: Quantity      This is the actual quantity of the        WO40.3  WO40.4
                       byproduct that was produced for the work  WO40.5  WO41.1
                       order.                                    WO41.2  WO41.3
                                                                 WO41.4  WO42.1
                                                                 WO42.2  WO42.3
                                                                 WO42.4  WO42.5
                                                                 WOSP.1

WOB-DETAIL-QTY         Signed 13.4
Element: Quantity      This field shows the total quantity of
                       details defined for a detail tracked
                       item. It is matched against the line
                       quantity field to determine if details
                       are in balance.

WOB-WALK-THRU-REQ      Alpha 1                                   WO120   WO20.1
Element: Req Comments  This field indicates that a transaction   WO30.1  WO30.2
                       line is out of balance.  For example, if  WO32.1  WO32.2
                       lot, bin, or serial number quantities do  WO32.3  WO32.4
                       not equal the transaction quantity,       WO32.5  WO40.1
                       select the WalkThru form action to        WO40.2  WO40.3
                       balance the transaction quantities.       WO40.4  WO40.5
                                                                 WO41.1  WO41.2
                                                                 WO41.3  WO41.4
                                                                 WO42.1  WO42.2
                                                                 WO42.3  WO42.4
                                                                 WO42.5  WOEX.1

WOB-FGV-AMOUNT         Signed 13.5
Element: Base Cost     The finished good variance amount on a
                       work order byproduct is the result of a
                       cost being returned from inventory for a
                       byproduct on a reverse work order.

                         WOBYPROD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WOBSET1   COMPANY       This index is used to access Work Order  WO120   WO132
          LOCATION      byproduct records for a specific work    WO133   WO140
          WORK-ORDER    order and  byproduct sequence number at  WO20.1  WO252
          WORK-ORDER-SUFa production location.                   WO256   WO30.1
          SEQ                                                    WO30.2  WO300
                                                                 WO32.1  WO32.2
                                                                 WO32.3  WO32.4
                                                                 WO32.5  WO40.1
                                                                 WO40.2  WO40.3
                                                                 WO40.4  WO40.5
                                                                 WO41.1  WO41.2
                                                                 WO41.3  WO41.4
                                                                 WO42.1  WO42.2
                                                                 WO42.3  WO42.4
                                                                 WO42.5  WO45.1
                                                                 ...

WOBSET2   COMPANY       This index is used to access Work Order  WO120   WO20.1
          LOCATION      byproduct records (within the feedback   WO30.1  WO32.1
          WORK-ORDER    process if WalkThru is required) for a   WO32.2  WO32.3
          WORK-ORDER-SUFspecific work order and byproduct        WO32.4  WO32.5
          SEQ           sequence number at a production          WO40.1  WO40.2
                        location.                                WO40.3  WO40.4
                        KeyChange, Subset                        WO40.5  WO41.1
                        Where (WALK-THRU-REQ = "Y" )             WO41.2  WO41.3
                                                                 WO41.4  WO42.1
                                                                 WO42.2  WO42.3
                                                                 WO42.4  WO42.5

                         WOBYPROD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccompany      ICCOMPANY    Required

                            WOB-COMPANY           -> ICC-COMPANY

Iclocation     ICLOCATION   Required

                            WOB-COMPANY           -> ICL-COMPANY
                            WOB-LOCATION          -> ICL-LOCATION

Itemloc        ITEMLOC      Required

                            WOB-COMPANY           -> ITL-COMPANY
                            WOB-LOCATION          -> ITL-LOCATION
                            WOB-ITEM              -> ITL-ITEM

Itemmast       ITEMMAST     Required

                            ICC-ITEM-GROUP        -> ITE-ITEM-GROUP
                            WOB-ITEM              -> ITE-ITEM

Worder         WORDER       Required

                            WOB-COMPANY           -> WOR-COMPANY
                            WOB-LOCATION          -> WOR-LOCATION
                            WOB-WORK-ORDER        -> WOR-WORK-ORDER
                            WOB-WORK-ORDER-SUF    -> WOR-WORK-ORDER-SUF

                         WOBYPROD FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bins           WODETAIL
                            Valid When ITE-LOT-TRACK-FL = "N"
                                  And  ITE-SER-TRACK-FL = "N"
                                  And  ITL-BIN-TRACK-FL = "Y"

                            WOB-COMPANY           -> WOD-COMPANY
                            WOB-LOCATION          -> WOD-LOCATION
                            WOB-WORK-ORDER        -> WOD-WORK-ORDER
                            WOB-WORK-ORDER-SUF    -> WOD-WORK-ORDER-SUF
                            "B"                   -> WOD-DETAIL-TYPE
                            WOB-SEQ               -> WOD-COMPONENT-SEQ
                                                     WOD-BIN
                                                     WOD-LOT
                                                     WOD-SUBLOT
                                                     WOD-SERIAL
                                                     WOD-UOM

Lots           WODETAIL
                            Valid When ITE-LOT-TRACK-FL = "Y"

                            WOB-COMPANY           -> WOD-COMPANY
                            WOB-LOCATION          -> WOD-LOCATION
                            WOB-WORK-ORDER        -> WOD-WORK-ORDER
                            WOB-WORK-ORDER-SUF    -> WOD-WORK-ORDER-SUF
                            "B"                   -> WOD-DETAIL-TYPE
                            WOB-SEQ               -> WOD-COMPONENT-SEQ
                                                     WOD-BIN
                                                     WOD-LOT
                                                     WOD-SUBLOT
                                                     WOD-SERIAL
                                                     WOD-UOM

Serials        WODETAIL
                            Valid When ITE-SER-TRACK-FL != "N"

                            WOB-COMPANY           -> WOD-COMPANY
                            WOB-LOCATION          -> WOD-LOCATION
                            WOB-WORK-ORDER        -> WOD-WORK-ORDER
                            WOB-WORK-ORDER-SUF    -> WOD-WORK-ORDER-SUF
                            "B"                   -> WOD-DETAIL-TYPE
                            WOB-SEQ               -> WOD-COMPONENT-SEQ
                                                     WOD-BIN
                                                     WOD-LOT
                                                     WOD-SUBLOT
                                                     WOD-SERIAL
                                                     WOD-UOM

Uoms           WODETAIL

                            WOB-COMPANY           -> WOD-COMPANY
                            WOB-LOCATION          -> WOD-LOCATION
                            WOB-WORK-ORDER        -> WOD-WORK-ORDER
                            WOB-WORK-ORDER-SUF    -> WOD-WORK-ORDER-SUF
                            "B"                   -> WOD-DETAIL-TYPE
                            WOB-SEQ               -> WOD-COMPONENT-SEQ
                                                     WOD-BIN
                                                     WOD-LOT
                                                     WOD-SUBLOT
                                                     WOD-SERIAL
                                                     WOD-UOM

Wodetail       WODETAIL

                            WOB-COMPANY           -> WOD-COMPANY
                            WOB-LOCATION          -> WOD-LOCATION
                            WOB-WORK-ORDER        -> WOD-WORK-ORDER
                            WOB-WORK-ORDER-SUF    -> WOD-WORK-ORDER-SUF
                            "B"                   -> WOD-DETAIL-TYPE
                            WOB-SEQ               -> WOD-COMPONENT-SEQ
                                                     WOD-BIN
                                                     WOD-LOT
                                                     WOD-SUBLOT
                                                     WOD-SERIAL
                                                     WOD-UOM