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     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP30.4    API1.1    BL120
BL122     BL130     BL20.1    BL20.3    BL21.2    BL21.5
BL29.1    BL29.2    BL520     BL820     MA180     MA41.1
MA41.2    MA41.4    MA41.7    MA43.1    MA43.2    MA43.3
MA43.7    MA530     MA531     MA60.2    MA60.3    MA60.5
MA61.1    MA66.2    MA66.3    MA67.2    MA67.3    MA68.2
MA68.3    MA68.5    MA70.1    MA75.1    MA80.1    MAI1.1
PD10.1    PD10.2    PD130     PD20.1    PD20.2    PD20.3
PO100     PO101     PO122     PO131     PO190     PO20.1
PO21.1    PO21.2    PO21.3    PO21.4    PO21.5    PO22.1
PO23.1    PO24.1    PO25.1    PO25.5    PO25.6    PO25.7
PO27.2    PO29.1    PO30.1    PO30.2    PO30.3    PO300
PO31.1    PO31.2    PO32.2    PO32.4    PO33.1    PO34.1
PO35.1    PO36.1    PO36.2    PO38.1    PO39.1    PO39.2
PO44.1    PO50.1    PO52.1    PO520     PO536     POI3.1
POID.1    POII.1    POIJ.1    RQ10.1    RQ10.2    RQ35.1
RQD1.1    WH20.2    WH20.7    WH224     WHD2.1

UPDATED BY

BL92.1    RQ300     WH130     WH132     WH190     WH222
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     WHD0.1


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WHA-COMPANY            Numeric 4                                 BL92.1  WH130
Element: Company       This field contains the company number.   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  WH130
Element: Location      This field contains a valid stock         WH132   WH190
                       location within the company inventory.    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  WH130
Element: System Cd     This field indicates on which Lawson      WH132   WH190
                       system the document originated.           WH30.1  WH30.2
                       OE = Customer Order                       WH30.3  WH30.4
                       RQ = Requisitions                         WH31.1  WH31.2
                       CX = Case Cart                            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  WH130
Element: Doc Nbr       This field indicates the document         WH132   WH190
                       number for the shipment line.             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  WH130
Element: Shipment Nbr  This field contains the shipment          WH132   WH190
                       number. One document can have several     WH30.1  WH30.2
                       shipment numbers if the items were not    WH30.3  WH30.4
                       shipped at the same time.                 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  WH130
Element: Line Nbr      This field contains the shipment line     WH132   WH190
                       number.                                   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  WH130
Element: Status        This field indicates the shipment         WH132   WH190
                       status.                                   WH30.1  WH30.2
                       0 = Printed                               WH30.3  WH30.4
                       1 = Picked                                WH31.1  WH31.2
                       2 = Packed                                WH31.3  WH31.4
                       3 = Shipped                               WH32.1  WH32.2
                       4 = Released                              WH32.3  WH32.4
                       5 = Closed                                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  WH130
Element: Pre-Assembled This field  contains the make-to-order    WH132   WH190
                       kit quantity.                             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  WH130
Element: Quantity      This field contains the backordered,      WH132   WH190
                       voided, or overshipped shipment line      WH30.1  WH30.2
                       quantity.                                 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  WH130
Element: Action Code   This field indicates the action taken     WH132   WH190
                       on the shipment line (backorder, void,    WH30.1  WH30.2
                       or overship).                             WH30.3  WH30.4
                       B = Backorder                             WH31.1  WH31.2
                       V = Void                                  WH31.3  WH31.4
                       O = Overship                              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                                                AP125   AP126
          LOCATION                                               AP131   AP20.1
          SHIPMENT-NBR                                           AP20.2  AP20.3
          LINE-NBR                                               AP20.4  AP20.5
          STATUS                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  MA180
                                                                 ...

WHASET2   COMPANY       KeyChange                                BL92.1  WH130
          LOCATION                                               WH132   WH190
          SHIPMENT-NBR                                           WH30.1  WH30.2
          STATUS                                                 WH30.3  WH30.4
          LINE-NBR                                               WH31.1  WH31.2
          ACTION-CD                                              WH31.3  WH31.4
                                                                 WH32.1  WH32.2
                                                                 WH32.3  WH32.4
                                                                 WH33.5  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830