Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WHSHLAUD


                             WHSHLAUD FILE

                          Shipment Line Audit

The Shipment Line Audit file contains changes made to shipment lines.

REFERENCED BY

AP125     AP126     AP131     AP25.1    AP25.2    AP26.1
AP27.1    AP30.4    BL120     BL122     BL130     BL20.1
BL20.3    BL21.2    BL21.5    BL29.1    BL29.2    BL520
BL820     IC28.1    MA180     MA530     MA531     MA60.2
MA60.3    MA60.5    MA61.1    MA66.2    MA66.3    MA67.1
MA67.2    MA70.1    MA75.1    MA80.1    MAI1.1    OE10.1
OE10.2    OE10.3    OE10.4    OE10.5    OE10.6    OE10.7
OE10.8    OE11.1    OE11.4    OE11.8    OE11.9    OE110
OE111     OE113     OE116     OE129     OE13.2    OE13.3
OE13.5    OE13.6    OE14.4    OE30.1    OE30.2    OE30.3
OE30.4    OE30.5    OE30.6    OE30.7    OE30.9    OE510
OE530     OE81.1    OE810     OE830     OE90.1    OE90.2
PO100     PO101     PO122     PO131     PO20.1    PO21.2
PO21.3    PO21.4    PO21.5    PO22.1    PO23.1    PO29.1
PO30.1    PO30.2    PO30.3    PO300     PO31.1    PO31.2
PO32.2    PO33.1    PO34.1    PO35.1    PO38.1    PO39.1
PO39.2    PO44.1    PO50.1    PO52.1    PO520     POI3.1
POIE.1    POII.1    POIJ.1    RQ10.1    RQ10.2    RQ35.1
WH20.2    WH20.7    WH224     WO132     WO140

UPDATED BY

BL92.1    OE114     OE310     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.7    WH33.8    WH33.9    WH34.1    WH34.2    WH34.3
WH34.4    WH40.1    WH40.2    WH520     WH830     RQ300
WH222

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WHA-COMPANY            Numeric 4                                 BL92.1  OE114
Element: Company       This field contains the company 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

WHA-LOCATION           Alpha 5                                   BL92.1  OE114
Element: Location Code This field contains a valid stock         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

WHA-SYSTEM-CD          Alpha 2                                   BL92.1  OE114
Element: System Code   This field indicates on which Lawson      WH130   WH132
                       system the document originated.           WH190   WH30.1
                       OE = Customer Order                       WH30.2  WH30.3
                       RQ = Requisitions                         WH30.4  WH31.1
                       CX = Case Cart                            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

WHA-DOC-NBR            Alpha 10  (Right Justified)               BL92.1  OE114
Element: Doc Nbr       This field indicates the document         WH130   WH132
                       number for the shipment 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

WHA-SHIPMENT-NBR       Numeric 10                                BL92.1  OE114
Element: Shipment NumbeThis field contains the shipment          WH130   WH132
                       number. One document can have several     WH190   WH30.1
                       shipment numbers if the items were not    WH30.2  WH30.3
                       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

WHA-LINE-NBR           Numeric 6                                 BL92.1  OE114
Element: Line Number   This field contains the shipment line     WH130   WH132
                       number.                                   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

WHA-STATUS             Numeric 1                                 BL92.1  OE114
Element: Status        This field indicates the shipment         WH130   WH132
                       status.                                   WH190   WH30.1
                       0 = Printed                               WH30.2  WH30.3
                       1 = Picked                                WH30.4  WH31.1
                       2 = Packed                                WH31.2  WH31.3
                       3 = Shipped                               WH31.4  WH32.1
                       4 = Released                              WH32.2  WH32.3
                       5 = Closed                                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

WHA-PRE-ASMBLD-KIT     Signed 13.4                               BL92.1  OE114
Element: Pre-Assembled This field  contains the make-to-order    WH130   WH132
                       kit quantity.                             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

WHA-QUANTITY           Signed 13.4                               BL92.1  OE114
Element: Quantity      This field contains the backordered,      WH130   WH132
                       voided, or overshipped shipment line      WH190   WH30.1
                       quantity.                                 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

WHA-ACTION-CD          Alpha 1                                   BL92.1  OE114
Element: Action Code   This field indicates the action taken     WH130   WH132
                       on the shipment line (backorder, void,    WH190   WH30.1
                       or overship).                             WH30.2  WH30.3
                       B = Backorder                             WH30.4  WH31.1
                       V = Void                                  WH31.2  WH31.3
                       O = Overship                              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

                         WHSHLAUD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WHASET1   COMPANY       Primary index used for accessing and     AP125   AP126
          LOCATION      updating the table.                      AP131   AP25.1
          SHIPMENT-NBR                                           AP25.2  AP26.1
          LINE-NBR                                               AP27.1  AP30.4
          STATUS                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC28.1  MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 ...

WHASET2   COMPANY       Used to find any changes that were made  WH520
          LOCATION      to shipment lines by shipment status.
          SHIPMENT-NBR  KeyChange
          STATUS
          LINE-NBR
          ACTION-CD