Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WHSHIPLINE


                            WHSHIPLINE FILE

                             Shipment Line

The Shipment Line file contains shipment line records.

REFERENCED BY

BL120     BL122     BL123     BL130     BL20.1    BL20.3
BL21.2    BL21.5    BL29.1    BL29.2    BL520     BL820
OE129     OE229     OE30.1    OE30.2    OE30.3    OE30.4
OE30.5    OE30.6    OE30.7    OE30.9    OE530     OE81.1
OE830     OE88.1    SA100     WH126     WH131     WH140
WH224     WH38.1    WH80.1    WH81.1    OE270     OE271
POIF.1    POIG.1    RQ10.1    RQ35.1    RQ44.1    RQ44.2

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    WH34.5    WH40.1    WH40.2    WH520     WH830
RQ300     WH222

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WHL-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.7
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

WHL-SYSTEM-CD          Alpha 2                                   BL92.1  OE114
Element: System Code   This field indicates from 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.7
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

WHL-DOC-NBR            Alpha 10  (Right Justified)               BL92.1  OE114
Element: Doc Nbr       This field contains the document number   WH130   WH132
                       assigned to this 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.7
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

WHL-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.7
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

WHL-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.7
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

WHL-LINE-TYPE          Alpha 1                                   BL92.1  OE114
Element: Line Type     This field contains the type of item      WH130   WH132
                       found on this shipment line.              WH190   WH30.1
                       I = Inventoried Item                      WH30.2  WH30.3
                       N = Nonstock Item                         WH30.4  WH31.1
                       X = Special Item                          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

WHL-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.7
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

WHL-DESCRIPTION        Alpha 30  (Lower Case)                    BL92.1  OE114
Element: Description   This field contains the description of    WH130   WH132
                       the line item.                            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

WHL-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.7
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

WHL-PRINTED-QTY        Signed 13.4                               BL92.1  OE114
Element: Quantity      This field contains the quantity that     WH130   WH132
                       was printed on the pick list 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.7
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

WHL-TRAN-UOM           Alpha 4                                   BL92.1  OE114
Element: Unit of MeasurThis field indicates the unit of          WH130   WH132
                       measure from the document.                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

WHL-TRAN-UOM-MULT      Signed 13.7                               BL92.1  OE114
Unit of Measure        This field is the conversion factor to    WH130   WH132
Multiplier             convert to stock unit of measure.         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

WHL-IN-PROCESS-QTY     Signed 13.4                               BL92.1  OE114
Element: In-Process QuaThis field contains the in-process        WH130   WH132
                       quantity, which is the shipment line      WH190   WH30.1
                       quantity currently in process.            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

WHL-SHIPPED-QTY        Signed 13.4                               BL92.1  OE114
Element: Quantity      This field contains the quantity that     OE270   WH130
                       was shipped in stock unit of measure.     WH132   WH190
                       For catch weight items, the shipped       WH30.1  WH30.2
                       quantity is in secondary unit of          WH30.3  WH30.4
                       measure.                                  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

WHL-DELIVERED-QTY      Signed 13.4
Element: Delivered QuanThis is the quantity that has been
                       issued or transferred to the requesting
                       location.  This quantity is updated by
                       PO221 (Delivery Ticket).

WHL-CATCH-WT-QTY       Signed 13.4                               BL92.1  OE114
Element: Quantity      This field contains the catch weight      WH130   WH132
                       quantity in stock unit of measure.        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  WH34.5
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

WHL-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

WHL-KIT-COMP-QTY       Signed 13.4                               BL92.1  OE114
Element: Quantity      The total component quantity of the       WH130   WH132
                       shipping line kit item.                   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

WHL-DETAIL-QTY         Signed 13.4                               BL92.1  OE114
Element: Detail QuantitThis field shows the total quantity of    WH130   WH132
                       details assigned to 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.7
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

WHL-DTL-CTW-QTY        Signed 13.4                               BL92.1  OE114
Detail Catch Weight    This field contains the catch weight      WH130   WH132
Quantity               quantity for shipment lines with          WH190   WH30.1
                       details.                                  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
                                                                 WH34.5  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WHL-DETAIL-REQ         Alpha 1                                   BL92.1  OE114
Element: Detail RequireThis field indicates whether or not       WH130   WH132
                       details are required for shipment lines.  WH190   WH30.1
                       Y = Yes                                   WH30.2  WH30.3
                       N = No                                    WH30.4  WH31.1
                       I = Interfaced                            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

WHL-WALK-THRU-REQ      Alpha 1                                   BL92.1  OE114
Element: Walk Thru RequThis field indicates that a shipment      WH130   WH132
                       line is out of balance.                   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
                                                                 WH34.5  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

WHL-UNIT-COST          Signed 18.5                               BL92.1  OE114
Element: Intl Cost     This field contains the unit cost of      WH130   WH132
                       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.7
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

WHL-WEIGHT             Signed 9.3                                BL92.1  OE114
Element: Unit Weight   This field contains the shipment line's   WH130   WH132
                       calculated weight based on the item       WH190   WH30.1
                       master stock weight and the line's        WH30.2  WH30.3
                       quantity in stock unit of measure.        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

WHL-CUBIC-FEET         Signed 9.3                                BL92.1  OE114
Element: Cubic Feet    This field contains the shipment line's   WH130   WH132
                       calculated cubic measurement based on     WH190   WH30.1
                       the item master stock cubic and the       WH30.2  WH30.3
                       shipment line's quantity in stock unit    WH30.4  WH31.1
                       of measure.                               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

WHL-MSDS-REQ-FL        Alpha 1                                   BL92.1  OE114
Element: All Flag      This field indicates if a Material        WH130   WH132
                       Safety Data Sheet is required for the     WH190   WH30.1
                       item of this shipment line. This flag is  WH30.2  WH30.3
                       originally set at item master.            WH30.4  WH31.1
                       Y = Yes                                   WH31.2  WH31.3
                       N = No                                    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

WHL-MSDS-DT            Numeric 8  (yyyymmdd)                     BL92.1  OE114
Element: MSDS Date     This field contains the date that a       WH130   WH132
                       Material Safety Data Sheet is being sent  WH190   WH30.1
                       to a customer ship to for this shipment   WH30.2  WH30.3
                       line.                                     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

WHL-MSDS-DOCUMENT      Alpha 30                                  BL92.1  OE114
Element: Msds Document The document number that references the   WH130   WH132
                       Material Safety Data Sheet that is being  WH190   WH30.1
                       sent for this shipment line.              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

WHL-MSDS-VERSION       Alpha 4                                   BL92.1  OE114
Element: Msds Version  The version number of the MSDS document   WH130   WH132
                       that is being sent with this shipment     WH190   WH30.1
                       line.                                     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

WHL-OPR-CODE           Alpha 10  (Lower Case)                    BL92.1  OE114
Element: Operator Code This field contains the operator code     WH130   WH132
                       or user ID of the person who last         WH190   WH30.1
                       updated 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.7
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

WHL-UPDATE-DATE        Numeric 8  (yyyymmdd)                     BL92.1  OE114
Element: Update Date   This field contains the date the record   WH130   WH132
                       was updated.                              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

WHL-UPDATE-TIME        Numeric 6                                 BL92.1  OE114
Element: Update Time   This field contains the system time       WH130   WH132
                       when the record was updated.              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

WHL-FULL-VOID-FL       Alpha 1                                   BL92.1  OE114
Element: Full Void Fl  Indicates that shipment line has been     WH130   WH132
                       voided.  No quantities will be shipped    WH190   WH30.1
                       from this line.                           WH30.2  WH30.3
                       Y = Voided                                WH30.4  WH31.1
                       N = Not Voided                            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

WHL-REQ-COMPANY        Numeric 4
Element: Company       This field contains the requesting
                       company.

WHL-OPEN-QUANTITY      Derived
Element: Open Quantity This field contains the total of the
                       in-process quantity and the backorder
                       quantity.

WHL-PARTIAL            Derived
Element: Partial       This field is used to help determine if
                       a shipment is partial or not.

WHL-PARTIAL-VALUE      Derived
Element: Partial Value This field indicates whether or not a
                       shipment is partial.

WHL-SUPLMNTARY-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

WHL-SUPLMNTARY-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

WHL-ICN-CODE           Alpha 8                                   BL92.1  OE114
Element: Icn 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

WHL-RQSRC-MACHINE      Alpha 6                                   BL92.1  OE114
Element: Rqsrc Machine                                           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

WHL-PAR-ORDER-ID       Alpha 20                                  BL92.1  OE114
Element: Par Order Id                                            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

                         WHSHIPLINE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WHLSET1   COMPANY       Primary index used for accessing and     BL120   BL122
          LOCATION      updating the table.                      BL123   BL130
          SHIPMENT-NBR                                           BL20.1  BL20.3
          LINE-NBR                                               BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  OE114
                                                                 OE129   OE229
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE310   OE530
                                                                 OE81.1  OE830
                                                                 OE88.1  RQ300
                                                                 ...

WHLSET2   COMPANY       Used to find shipment lines by the       BL92.1  OE114
          SYSTEM-CD     originating system.                      OE270   OE271
          DOC-NBR                                                OE81.1  POIF.1
          LINE-NBR                                               POIG.1  RQ10.1
          SHIPMENT-NBR                                           RQ35.1  RQ44.1
                                                                 RQ44.2  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
                                                                 ...

WHLSET3   COMPANY       Used to find shipment lines that need    BL92.1  OE114
          LOCATION      to have details assigned.                WH130   WH132
          SHIPMENT-NBR  Subset                                   WH190   WH30.1
          LINE-NBR      Where (WALK-THRU-REQ = "Y" )             WH30.2  WH30.3
          ITEM                                                   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
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH38.1  WH40.1
                                                                 WH40.2  WH520
                                                                 ...

WHLSET4   COMPANY       Used to find shipment lines that do not
          LOCATION      require details (but other lines on the
          SHIPMENT-NBR  same shipment do require details).
          LINE-NBR      Subset
                        Where DETAIL-REQ = "N"

WHLSET5   COMPANY       KeyChange
          LOCATION
          SHIPMENT-NBR
          FULL-VOID-FL
          LINE-NBR

WHLSET6   COMPANY       This index was created as a solution to  WH30.1  WH30.2
          LOCATION      the Find Next/Prev Flag error. It is     WH31.1  WH31.2
          LINE-NBR      only used where a modify must be done    WH32.1  WH32.2
          SHIPMENT-NBR  within a 850-FIND-NLT or 850-FIND-BEGRNG WH33.1  WH33.2
                        loop.                                    WH33.3  WH33.4
                                                                 WH33.7  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

                         WHSHIPLINE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Caseline       CXPREFITEM   Required
                            When WHL-SYSTEM-CD = "CX"

                            WHL-COMPANY         -> CPI-COMPANY
                            WHS-REQ-LOCATION    -> CPI-REQ-LOCATION
                            WHL-DOC-NBR         -> CPI-CASE
                            WHL-LINE-NBR        -> CPI-IF-REF-NBR

Coline         COLINE       Required
                            When WHS-SYSTEM-CD = "OE"

                            WHL-COMPANY         -> COL-COMPANY
                            WDH-DOC-NBR-NUM     -> COL-ORDER-NBR
                            WHL-LINE-NBR        -> COL-LINE-NBR

Iccompany      ICCOMPANY    Required

                            WHL-COMPANY         -> ICC-COMPANY

Iclocation     ICLOCATION   Required

                            WHL-COMPANY         -> ICL-COMPANY
                            WHL-LOCATION        -> ICL-LOCATION

Itemloc        ITEMLOC      Required
                            When WHL-LINE-TYPE = "I"

                            WHL-COMPANY         -> ITL-COMPANY
                            WHL-LOCATION        -> ITL-LOCATION
                            WHL-ITEM            -> ITL-ITEM

Itemmast       ITEMMAST     Required
                            When WHL-LINE-TYPE = "I"
                            Or   WHL-LINE-TYPE = "N"

                            ICC-ITEM-GROUP      -> ITE-ITEM-GROUP
                            WHL-ITEM            -> ITE-ITEM

Reqline        REQLINE      Required
                            When -SYSTEM-CD = "R"

                            WDM-REQ-COMPANY     -> RLN-COMPANY
                            WDM-DOC-NBR-NUM     -> RLN-REQ-NUMBER
                            WHL-LINE-NBR        -> RLN-LINE-NBR

Shipment       WHSHIPMENT   Required

                            WHL-COMPANY         -> WHS-COMPANY
                            WHL-LOCATION        -> WHS-LOCATION
                            WHL-SHIPMENT-NBR    -> WHS-SHIPMENT-NBR

Whdemand       WHDEMAND     Required

                            WHL-COMPANY         -> WDM-COMPANY
                            WHL-SYSTEM-CD       -> WDM-SYSTEM-CD
                            WHL-DOC-NBR         -> WDM-DOC-NBR
                            WHL-LINE-NBR        -> WDM-LINE-NBR
                            Zeroes              -> WDM-COMPONENT-SEQ
                            WHL-LOCATION        -> WDM-LOCATION

Whdemndhdr     WHDEMNDHDR   Required

                            WHL-COMPANY         -> WDH-COMPANY
                            WHL-SYSTEM-CD       -> WDH-SYSTEM-CD
                            WHL-DOC-NBR         -> WDH-DOC-NBR

Whwebtrack     WHWEBTRACK   Not Required

                            WHL-COMPANY         -> WST-COMPANY
                            WHL-LOCATION        -> WST-LOCATION
                            WHL-SHIPMENT-NBR    -> WST-SHIPMENT-NBR
                            WHL-LINE-NBR        -> WST-LINE-NBR

Whwhluf        WHWHLUF      Not Required

                            WHL-COMPANY         -> WLU-COMPANY
                            WHL-LOCATION        -> WLU-LOCATION
                            WHL-SHIPMENT-NBR    -> WLU-SHIPMENT-NBR
                            WHL-LINE-NBR        -> WLU-LINE-NBR

                         WHSHIPLINE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Atch Ser Recpt WHSHLDTL
                            Valid When ITE-SER-TRACK-FL = "R"

                            WHL-COMPANY         -> WHD-COMPANY
                            WHL-LOCATION        -> WHD-LOCATION
                            WHL-SHIPMENT-NBR    -> WHD-SHIPMENT-NBR
                            WHL-LINE-NBR        -> WHD-LINE-NBR
                            Zeroes              -> WHD-COMPONENT-SEQ
                                                   WHD-BIN
                                                   WHD-LOT
                                                   WHD-SUBLOT
                                                   WHD-UOM
                                                   WHD-SERIAL

Attached Bins  WHSHLDTL
                            Valid When ITE-LOT-TRACK-FL = "N"
                                  And  ITL-BIN-TRACK-FL = "Y"
                                  And  ITE-SER-TRACK-FL = "N"

                            WHL-COMPANY         -> WHD-COMPANY
                            WHL-LOCATION        -> WHD-LOCATION
                            WHL-SHIPMENT-NBR    -> WHD-SHIPMENT-NBR
                            WHL-LINE-NBR        -> WHD-LINE-NBR
                            Zeroes              -> WHD-COMPONENT-SEQ
                                                   WHD-BIN
                                                   WHD-LOT
                                                   WHD-SUBLOT
                                                   WHD-UOM
                                                   WHD-SERIAL

Attached Lots  WHSHLDTL
                            Valid When ITE-LOT-TRACK-FL = "Y"

                            WHL-COMPANY         -> WHD-COMPANY
                            WHL-LOCATION        -> WHD-LOCATION
                            WHL-SHIPMENT-NBR    -> WHD-SHIPMENT-NBR
                            WHL-LINE-NBR        -> WHD-LINE-NBR
                            Zeroes              -> WHD-COMPONENT-SEQ
                                                   WHD-BIN
                                                   WHD-LOT
                                                   WHD-SUBLOT
                                                   WHD-UOM
                                                   WHD-SERIAL

Attached Sers  WHSHLDTL
                            Valid When ITE-SER-TRACK-FL = "I"

                            WHL-COMPANY         -> WHD-COMPANY
                            WHL-LOCATION        -> WHD-LOCATION
                            WHL-SHIPMENT-NBR    -> WHD-SHIPMENT-NBR
                            WHL-LINE-NBR        -> WHD-LINE-NBR
                            Zeroes              -> WHD-COMPONENT-SEQ
                                                   WHD-BIN
                                                   WHD-LOT
                                                   WHD-SUBLOT
                                                   WHD-UOM
                                                   WHD-SERIAL

Attached Uoms  WHSHLDTL
                            Valid When SDT-             = WHL-
                                  And  ITE-LOT-TRACK-FL = "N"
                                  And  ITE-SER-TRACK-FL = "N"
                                  And  ITL-BIN-TRACK-FL = "N"

                            WHL-COMPANY         -> WHD-COMPANY
                            WHL-LOCATION        -> WHD-LOCATION
                            WHL-SHIPMENT-NBR    -> WHD-SHIPMENT-NBR
                            WHL-LINE-NBR        -> WHD-LINE-NBR
                            Zeroes              -> WHD-COMPONENT-SEQ
                                                   WHD-BIN
                                                   WHD-LOT
                                                   WHD-SUBLOT
                                                   WHD-UOM
                                                   WHD-SERIAL

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

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

Itcomment      ITCOMMENT

                            ICC-ITEM-GROUP      -> ICO-ITEM-GROUP
                            WHL-ITEM            -> ICO-ITEM
                                                   ICO-LANGUAGE-CODE
                                                   ICO-SEQ

Itserial       ITSERIAL
                            Valid When ITE-SER-TRACK-FL = "R"

                            WHL-COMPANY         -> SER-COMPANY
                            WHL-ITEM            -> SER-ITEM
                                                   SER-SERIAL

Itserials      ITSERIAL
                            Valid When ITE-SER-TRACK-FL = "I"

                            WHL-COMPANY         -> SER-COMPANY
                            WHL-ITEM            -> SER-ITEM
                                                   SER-SERIAL

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

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

Shiplnedtl     WHSHLDTL

                            WHL-COMPANY         -> WHD-COMPANY
                            WHL-LOCATION        -> WHD-LOCATION
                            WHL-SHIPMENT-NBR    -> WHD-SHIPMENT-NBR
                            WHL-LINE-NBR        -> WHD-LINE-NBR
                                                   WHD-COMPONENT-SEQ
                                                   WHD-BIN
                                                   WHD-LOT
                                                   WHD-SUBLOT
                                                   WHD-UOM
                                                   WHD-SERIAL

Sohdetail      SOHDETAIL

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

Uoms           SOHDETAIL
                            Valid When SDT-             = WHL-
                                  And  ITE-LOT-TRACK-FL = "N"
                                  And  ITE-SER-TRACK-FL = "N"
                                  And  ITL-BIN-TRACK-FL = "N"

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

Whshipcomp     WHSHIPCOMP

                            WHL-COMPANY         -> WHC-COMPANY
                            WHL-LOCATION        -> WHC-LOCATION
                            WHL-SHIPMENT-NBR    -> WHC-SHIPMENT-NBR
                            WHL-LINE-NBR        -> WHC-LINE-NBR
                                                   WHC-COMPONENT-SEQ

Whshlaud       WHSHLAUD

                            WHL-COMPANY         -> WHA-COMPANY
                            WHL-LOCATION        -> WHA-LOCATION
                            WHL-SHIPMENT-NBR    -> WHA-SHIPMENT-NBR
                            WHL-LINE-NBR        -> WHA-LINE-NBR
                                                   WHA-STATUS