Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WHSLINEOUT


                            WHSLINEOUT FILE

UPDATED BY

BL92.1    OE114     WH130     WH132     WH190     WH30.1
WH30.2    WH30.3    WH30.4    WH31.1    WH31.2    WH31.3
WH31.4    WH32.1    WH32.2    WH32.3    WH32.4    WH33.1
WH33.2    WH33.3    WH33.4    WH33.5    WH33.6    WH33.8
WH33.9    WH330     WH34.1    WH34.2    WH34.3    WH34.4
WH40.1    WH40.2    WH520     WH830

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WLO-COMPANY            Numeric 4                                 BL92.1  OE114
Element: Company       Identifies the AP company if the          WH130   WH132
                       resource type = V.  Identifies the HR     WH190   WH30.1
                       company if the resource type = E.  It is  WH30.2  WH30.3
                       blank for type A, P or Q resources.       WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-LOCATION           Alpha 5                                   BL92.1  OE114
Element: Location Code This field contains a valid stocking      WH130   WH132
                       location within the company inventory.    WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-SHIPMENT-NBR       Numeric 10                                BL92.1  OE114
Element: Shipment NumbeThis field contains the shipment          WH130   WH132
                       number.  One order can have several       WH190   WH30.1
                       shipment numbers if the items of the      WH30.2  WH30.3
                       order were not shipped at the same time.  WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-LINE-NBR           Numeric 6                                 BL92.1  OE114
Element: Line Number   This field contains the line number.      WH130   WH132
                                                                 WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-CREATION-DATE      Numeric 8  (yyyymmdd)                     BL92.1  OE114
Element: Creation Date This is the date that this line was       WH130   WH132
                       added to the requisition.                 WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-CREATION-TIME      Numeric 6  (hhmmss)                       BL92.1  OE114
Element: Creation Time The creation time.                        WH130   WH132
                                                                 WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-INTERFACE-STS      Numeric 1                                 BL92.1  OE114
Element: Interface Sts                                           WH130   WH132
                                                                 WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-SYSTEM-CD          Alpha 2                                   BL92.1  OE114
Element: System Code   This field indicates on what system the   WH130   WH132
                       transaction originated.                   WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-DOC-NBR            Alpha 10  (Right Justified)               BL92.1  OE114
Element: Doc Nbr                                                 WH130   WH132
                                                                 WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-OPR-CODE           Alpha 10  (Lower Case)                    BL92.1  OE114
Element: Operator Code This field contains the operator code.    WH130   WH132
                       This is the user ID of the person who     WH190   WH30.1
                       last maintained this record.              WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-LINE-TYPE          Alpha 1                                   BL92.1  OE114
Element: Line Type     This field contains the type of           WH130   WH132
                       inventory on this line.                   WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-ITEM               Alpha 32                                  BL92.1  OE114
Element: Item Number   This field contains the item              WH130   WH132
                       identifier.                               WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-DESCRIPTION        Alpha 30  (Lower Case)                    BL92.1  OE114
Element: Description   This field displays the description.      WH130   WH132
                                                                 WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-TRAN-UOM           Alpha 4                                   BL92.1  OE114
Element: Unit of Measure                                         WH130   WH132
                                                                 WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-TRAN-UOM-MULT      Signed 13.7                               BL92.1  OE114
Unit of Measure                                                  WH130   WH132
Multiplier                                                       WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-PRINTED-QTY        Signed 13.4                               BL92.1  OE114
Element: Quantity      This field contains the quantity that     WH130   WH132
                       was printed on the picklist to be         WH190   WH30.1
                       picked.                                   WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-IN-PROCESS-QTY     Signed 13.4                               BL92.1  OE114
Element: Quantity                                                WH130   WH132
                                                                 WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-SHIPPED-QTY        Signed 13.4                               BL92.1  OE114
Element: Quantity                                                WH130   WH132
                                                                 WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-CATCH-WT-QTY       Signed 13.4                               BL92.1  OE114
Element: Quantity      This field contains the quantity          WH130   WH132
                       received for catch weight shipments.      WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-PRE-ASMBLD-KIT     Signed 13.4                               BL92.1  OE114
Element: Pre Asmbld Kit                                          WH130   WH132
                                                                 WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-DETAIL-QTY         Signed 13.4                               BL92.1  OE114
Element: Quantity      This field shows the total quantity of    WH130   WH132
                       details defined for a detail tracked      WH190   WH30.1
                       item. It is matched against the line      WH30.2  WH30.3
                       quantity field to determine if details    WH30.4  WH31.1
                       are in balance.                           WH31.2  WH31.3
                       In the item detail screen, it is the      WH31.4  WH32.1
                       quantity for a particular lot or bin.     WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-DTL-CTW-QTY        Signed 13.4                               BL92.1  OE114
Element: Quantity                                                WH130   WH132
                                                                 WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-DETAIL-REQ         Alpha 1                                   BL92.1  OE114
Element: Detail Req                                              WH130   WH132
                                                                 WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-WALK-THRU-REQ      Alpha 1                                   BL92.1  OE114
Element: Req Comments  This field indicates that a transaction   WH130   WH132
                       line is out of balance.   For example,    WH190   WH30.1
                       if lot, bin or serial quantities do not   WH30.2  WH30.3
                       equal the transaction quantity, use the   WH30.4  WH31.1
                       (W)alkThru screen function code to        WH31.2  WH31.3
                       balance the transaction quantities.       WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-UNIT-COST          Signed 18.5                               BL92.1  OE114
Element: Intl Cost     This field contains the unit cost.        WH130   WH132
                                                                 WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-WEIGHT             Signed 9.3                                BL92.1  OE114
Element: Unit Weight   This field contains the unit weight of    WH130   WH132
                       the item based on the stocking UOM.       WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-CUBIC-FEET         Signed 9.3                                BL92.1  OE114
Element: Cubic Feet    This field contains the unit cubit feet   WH130   WH132
                       of the item based on the stocking UOM.    WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-MSDS-DT            Numeric 8  (yyyymmdd)                     BL92.1  OE114
Material Safety        This date is the date that a new          WH130   WH132
DataSheet Date         Material Safety Data Sheet should be      WH190   WH30.1
                       sent from the vendor.                     WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-UPC-CODE           Alpha 13                                  BL92.1  OE114
Element: Upc Code                                                WH130   WH132
                                                                 WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WLO-KIT-FLAG           Alpha 1                                   BL92.1  OE114
Element: Kit Flag                                                WH130   WH132
                                                                 WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

                         WHSLINEOUT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WLOSET1   COMPANY                                                BL92.1  OE114
          LOCATION                                               WH130   WH132
          SHIPMENT-NBR                                           WH190   WH30.1
          LINE-NBR                                               WH30.2  WH30.3
          CREATION-DATE                                          WH30.4  WH31.1
          CREATION-TIME                                          WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH330
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 ...

WLOSET2   COMPANY
          LOCATION
          INTERFACE-STS
          SHIPMENT-NBR
          LINE-NBR
          CREATION-DATE
          CREATION-TIME