Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WOITEM


                              WOITEM FILE

                            Work Order Items

The Work Order Items file contains information about components used in the
process of producing a finished good for a specific work order.

REFERENCED BY

WO133     WO232     WO250     WO256     WO293     WO35.1
WOD1.1    WO131     WO252

UPDATED BY

WO120     WO132     WO140     WO20.1    WO30.1    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

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

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

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

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


WOI-COMPONENT-SEQ      Numeric 3                                 WO30.1  WO32.1
Element: Sequence NumbeThe component sequence number is the      WO40.1  WOEX.1
                       order in which this component is added
                       to the finished good during the
                       production process.

WOI-COMPONENT-TYPE     Alpha 1                                   WO30.1  WOEX.1
Element: Component TypeThe component type specifies whether
                       the component is an inventory component
                       used in the production of the finished
                       good, a packaging item, or an offsite
                       item.
                       C = Component
                       P = Packaging
                       O = Offsite Component
                       R = Rework

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

WOI-INV-LOCATION       Alpha 5                                   WO30.1  WO32.1
Element: Location Code                                           WOEX.1

WOI-PLAN-QTY           Signed 13.4                               WO30.1  WO40.1
Element: Quantity      This field contains the planned           WO40.2  WO40.3
                       quantity for an item for a work order.    WO40.4  WO40.5
                                                                 WO41.1  WO41.2
                                                                 WO41.3  WO41.4
                                                                 WO42.1  WO42.2
                                                                 WO42.3  WO42.4
                                                                 WO42.5  WOEX.1
                                                                 WOSP.1

WOI-ACTUAL-QTY         Signed 13.4                               WO40.1  WO40.2
Element: Quantity      This is the actual quantity of the        WO40.3  WO40.4
                       component used to make the finished       WO40.5  WO41.1
                       goods for this work order.                WO41.2  WO41.3
                                                                 WO41.4  WO42.1
                                                                 WO42.2  WO42.3
                                                                 WO42.4  WO42.5
                                                                 WOSP.1

WOI-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 used to make    WO40.5  WO41.1
                       the finished goods for this work order.   WO41.2  WO41.3
                                                                 WO41.4  WO42.1
                                                                 WO42.2  WO42.3
                                                                 WO42.4  WO42.5
                                                                 WOSP.1

WOI-PICKED-QTY         Signed 13.4                               WO32.1  WO40.1
Element: Quantity      This is the quantity of the component     WO40.2  WO40.3
                       that was picked for the work order.       WO40.4  WO40.5
                                                                 WO41.1  WO41.2
                                                                 WO41.3  WO41.4
                                                                 WO42.1  WO42.2
                                                                 WO42.3  WO42.4
                                                                 WO42.5  WOSP.1

WOI-DETAIL-QTY         Signed 13.4                               WO32.2  WO32.3
Element: Quantity      This field shows the total quantity of    WO32.4  WO32.5
                       details defined for a detail tracked      WO40.1  WO40.2
                       item. It is matched against the line      WO40.3  WO40.4
                       quantity field to determine if details    WO40.5  WO41.1
                       are in balance.                           WO41.2  WO41.3
                                                                 WO41.4  WO42.1
                                                                 WO42.2  WO42.3
                                                                 WO42.4  WO42.5
                                                                 WOSP.1

WOI-CATCH-WT-QTY       Signed 13.4                               WO32.1  WO40.1
Element: Quantity      This is the catch weight quantity of      WO40.2  WO40.3
                       the component that was picked for the     WO40.4  WO40.5
                       work order.                               WO41.1  WO41.2
                                                                 WO41.3  WO41.4
                                                                 WO42.1  WO42.2
                                                                 WO42.3  WO42.4
                                                                 WO42.5  WOSP.1

WOI-DTL-CTW-QTY        Signed 13.4                               WOSP.1
Element: Quantity      This field is not currently used by the
                       Work Order system.

WOI-WST-ACCT-UNIT      Alpha 15                                  WO30.1  WOEX.1
Element: Accounting UniThe waste account unit is part of the
                       account where the cost of components
                       that were wasted during the work order
                       production process are posted. The cost
                       of wasted components are not included in
                       the cost of the finished good.

WOI-WST-ACCOUNT        Numeric 6                                 WO30.1  WOEX.1
Element: Account       The waste account is part of the
                       account where the cost of the components
                       that were wasted during the work order
                       production process are posted. The cost
                       of wasted components are not included in
                       the cost the finished good.

WOI-WST-SUB-ACCT       Numeric 4                                 WO30.1  WOEX.1
Element: Subaccount    The waste subaccount is part of the
                       account where the cost of components
                       that were wasted during the work order
                       process are posted.  The cost of wasted
                       components are not included in the cost
                       of the finished good.

WOI-WASTE-QTY          Signed 13.4                               WO40.1  WO40.2
Element: Quantity      This is the quantity of the component     WO40.3  WO40.4
                       that was wasted during the work order     WO40.5  WO41.1
                       production process and was not used in    WO41.2  WO41.3
                       the finished good.                        WO41.4  WO42.1
                                                                 WO42.2  WO42.3
                                                                 WO42.4  WO42.5
                                                                 WOSP.1

WOI-WST-CTW-QTY        Signed 13.4                               WO40.1  WO40.2
Element: Quantity      This is the catch weight quantity of      WO40.3  WO40.4
                       the component that was wasted during the  WO40.5  WO41.1
                       work order production process and was     WO41.2  WO41.3
                       not used in the finished good.            WO41.4  WO42.1
                                                                 WO42.2  WO42.3
                                                                 WO42.4  WO42.5
                                                                 WOSP.1

WOI-EST-COMP-COST      Signed 13.5                               WO30.1  WOEX.1
Element: Base Cost     This is the estimated unit cost of the
                       component.

WOI-ACT-COMP-COST      Signed 13.5                               WO140   WO40.1
Element: Base Cost     This is the actual unit cost of           WO40.2  WO40.3
                       components that were not picked but were  WO40.4  WO40.5
                       consumed, that is, used in the finished   WO41.1  WO41.2
                       good or wasted.  This field will be zero  WO41.3  WO41.4
                       if the picked quantity is greater than    WO42.1  WO42.2
                       the sum of the actual quantity and the    WO42.3  WO42.4
                       waste quantity.                           WO42.5  WOSP.1

WOI-PICKED-COST        Signed 13.5                               WO132   WO40.1
Element: Base Cost     This is the unit cost for components      WO40.2  WO40.3
                       that were picked.                         WO40.4  WO40.5
                                                                 WO41.1  WO41.2
                                                                 WO41.3  WO41.4
                                                                 WO42.1  WO42.2
                                                                 WO42.3  WO42.4
                                                                 WO42.5

WOI-TOT-ACT-COST       Signed 13.5                               WO140
Element: Base Cost     This is the extended cost of the
                       components used to make the finished
                       goods for this work order.  The cost of
                       any wasted components is not included in
                       this field.

WOI-TOT-WASTE-COST     Signed 13.5                               WO140
Element: Base Cost     This is the extended cost of components
                       that were wasted during the production
                       process for this work order.  This cost
                       is not included in the inventory costs
                       of the finished good produced.

WOI-QTY-TOL-PCT        Percent 5.3  (Percent)                    WO30.1  WOEX.1
Element: Cost Pct      This field contains the quantity
                       tolerance percent of the component.

WOI-ZERO-QTY-FL        Alpha 1                                   WO30.1  WOEX.1
Element: All Flag      The zero quantity tolerance flag is
                       used to indicate if zero tolerance is
                       allowed for the component on this work
                       order.  This field is loaded from the
                       component definition on the finished
                       good template when the component is
                       added to the work order through work
                       order explosion or another entry method.
                       Y = Yes
                       N = No

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

WOI-DISP-INV-LOC       Derived
Element: Disp Inv Loc  The system displays a string that
                       contains inventory location
                       (INV-LOCATION) preceded by a label for
                       the inventory location.

WOI-DISP-LOCATION      Derived
Element: Disp Location The system displays a conditional field
                       that will contain display inventory
                       location (DISP-INV-LOC) if the value of
                       inventory location (INV-LOCATION) is
                       different than location (LOCATION).

WOI-ME-ACCT-UNIT       Alpha 15                                  WO30.1  WOEX.1
Element: Me Acct Unit  The material expense account unit is
                       used to record component costs
                       associated with the production of
                       finished goods.

WOI-ME-ACCOUNT         Numeric 6                                 WO30.1  WOEX.1
Element: Me Account    The material expense account is used to
                       record component costs associated with
                       the production of finished goods.

WOI-ME-SUB-ACCT        Numeric 4                                 WO30.1  WOEX.1
Element: Me Sub Acct   The material expense subaccount is used
                       to record component costs associated
                       with the production of finished goods.

                         WOITEM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WOISET1   COMPANY       This index is used to access component   WO120   WO132
          LOCATION      records for a specific work order and    WO133   WO140
          WORK-ORDER    component sequence number for a          WO20.1  WO232
          WORK-ORDER-SUFproduction location.                     WO250   WO256
          COMPONENT-SEQ                                          WO293   WO30.1
                                                                 WO300   WO32.1
                                                                 WO32.2  WO32.3
                                                                 WO32.4  WO32.5
                                                                 WO35.1  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
                                                                 ...

WOISET2   COMPANY       This index is used to access component   WO131   WO132
          LOCATION      records for a specific work order,       WO140   WO32.1
          WORK-ORDER    inventory location, and component
          WORK-ORDER-SUFsequence number for a production
          INV-LOCATION  location.
          COMPONENT-SEQ KeyChange

WOISET3   COMPANY       This index is used to access component   WO252
          LOCATION      records for a specific work order and
          WORK-ORDER    component type and sequence for a
          WORK-ORDER-SUFproduction location.
          COMPONENT-TYPEKeyChange
          COMPONENT-SEQ

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

WOISET5   COMPANY       This index is used to access regular     WO40.1
          LOCATION      and packaging component records for a
          WORK-ORDER    specific work order and component
          WORK-ORDER-SUFsequence number for a production
          COMPONENT-SEQ location.
                        KeyChange, Subset
                        Where COMPONENT-TYPE != "O"

                         WOITEM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccompany      ICCOMPANY    Required

                            WOI-COMPANY           -> ICC-COMPANY

Iclocation     ICLOCATION   Required

                            WOI-COMPANY           -> ICL-COMPANY
                            WOI-INV-LOCATION      -> ICL-LOCATION

Itemloc        ITEMLOC      Not Required

                            WOI-COMPANY           -> ITL-COMPANY
                            WOI-INV-LOCATION      -> ITL-LOCATION
                            WOI-ITEM              -> ITL-ITEM

Itemmast       ITEMMAST     Required

                            ICC-ITEM-GROUP        -> ITE-ITEM-GROUP
                            WOI-ITEM              -> ITE-ITEM

Waste Account  GLMASTER     Not Required
                            Valid When WOI-WST-ACCT-UNIT != Spaces
                                  Or   WOI-WST-ACCOUNT   != Zeroes
                                  Or   WOI-WST-SUB-ACCT  != Zeroes

                            WOI-COMPANY           -> GLM-COMPANY
                            WOI-WST-ACCT-UNIT     -> GLM-ACCT-UNIT
                            WOI-WST-ACCOUNT       -> GLM-ACCOUNT
                            WOI-WST-SUB-ACCT      -> GLM-SUB-ACCOUNT

Wo Location    ICLOCATION   Required

                            WOI-COMPANY           -> ICL-COMPANY
                            WOI-LOCATION          -> ICL-LOCATION

Worder         WORDER       Required

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

Wosgblk        WOSGBLK      Not Required

                            WOI-COMPANY           -> WSB-COMPANY
                            WOI-LOCATION          -> WSB-LOCATION
                            WOI-WORK-ORDER        -> WSB-WORK-ORDER
                            WOI-WORK-ORDER-SUF    -> WSB-WORK-ORDER-SUF
                            WOI-COMPONENT-SEQ     -> WSB-COMPONENT-SEQ
                            Zeroes                -> WSB-SEQ

Wowoiuf        WOWOIUF      Not Required

                            WOI-COMPANY           -> WIU-COMPANY
                            WOI-LOCATION          -> WIU-LOCATION
                            WOI-WORK-ORDER        -> WIU-WORK-ORDER
                            WOI-WORK-ORDER-SUF    -> WIU-WORK-ORDER-SUF
                            WOI-COMPONENT-SEQ     -> WIU-COMPONENT-SEQ

                         WOITEM 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"

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

Itemsub        ITEMSUB

                            ICC-ITEM-GROUP        -> ITS-ITEM-GROUP
                            WOI-ITEM              -> ITS-ITEM
                            "S"                   -> ITS-SUBTYPE
                                                     ITS-SUB-ITEM

Itserial       ITSERIAL
                            Valid When ITE-SER-TRACK-FL != "N"

                            WOI-COMPANY           -> SER-COMPANY
                            WOI-ITEM              -> SER-ITEM
                                                     SER-SERIAL

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

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

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

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

Sohbins        SOHDETAIL
                            Valid When ITE-LOT-TRACK-FL = "N"
                                  And  ITE-SER-TRACK-FL = "N"
                                  And  ITL-BIN-TRACK-FL = "Y"

                            WOI-COMPANY           -> SDT-COMPANY
                            WOI-LOCATION          -> SDT-LOCATION
                            WOI-ITEM              -> SDT-ITEM
                                                     SDT-UOM
                                                     SDT-LOT
                                                     SDT-SUBLOT
                                                     SDT-BIN

Sohlots        SOHDETAIL
                            Valid When ITE-LOT-TRACK-FL = "Y"

                            WOI-COMPANY           -> SDT-COMPANY
                            WOI-LOCATION          -> SDT-LOCATION
                            WOI-ITEM              -> SDT-ITEM
                                                     SDT-UOM
                                                     SDT-LOT
                                                     SDT-SUBLOT
                                                     SDT-BIN

Uoms           WODETAIL

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

Wodetail       WODETAIL

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