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.

UPDATED BY

WHD3.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

WOB-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.

WOB-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.


WOB-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.


WOB-SEQ                Numeric 3
Element: Seq           This field contains the sequence number
                       of the byproduct on the work order.

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

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

WOB-ACTUAL-QTY         Signed 13.4
Element: Quantity      This is the actual quantity of the
                       byproduct that was produced for the work
                       order.

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
Element: Req Comments  This field indicates that a transaction
                       line is out of balance.  For example, if
                       lot, bin, or serial number quantities do
                       not equal the transaction quantity,
                       select the WalkThru form action to
                       balance the transaction quantities.

WOB-FGV-AMOUNT         Signed 18.5
Element: Intl 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                                                WHD3.1
          LOCATION
          WORK-ORDER
          WORK-ORDER-SUF
          SEQ

WOBSET2   COMPANY       KeyChange, Subset
          LOCATION      Where (WALK-THRU-REQ = "Y" )
          WORK-ORDER
          WORK-ORDER-SUF
          SEQ

                         WOBYPROD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccompany      ICCOMPANY    Required

                            WOB-COMPANY           -> ICC-COMPANY  (ICCSET1)

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