Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WHSHLINEIN


                            WHSHLINEIN FILE

                         WH Shipment Line Input

Input table for shipment confirmation line information.

UPDATED BY

WH52.1    WH520

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WLI-COMPANY            Numeric 4                                 WH52.1
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

WLI-LOCATION           Alpha 5                                   WH52.1
Element: Location Code This field contains a valid stocking
                       location within the company inventory.

WLI-SHIPMENT-NBR       Numeric 10                                WH52.1
Element: Shipment NumbeThis field contains the shipment
                       number.  One order can have several
                       shipment numbers if the items of the
                       order were not shipped at the same time.


WLI-LINE-NBR           Numeric 6                                 WH52.1
Element: Line Number   This field contains the line number.

WLI-PROCESS-DATE       Numeric 8  (yyyymmdd)                     WH52.1
Element: Date

WLI-UPDATE-TIME        Numeric 6                                 WH52.1
Element: Update Time   This field contains the system time
                       when the record was updated.

WLI-ITEM               Alpha 32                                  WH52.1
Element: Item Number   This field contains the item
                       identifier.

WLI-LINE-TYPE          Alpha 1                                   WH52.1
Element: Line Type     This field contains the type of
                       inventory on this line.

WLI-STOCK-UOM          Alpha 4                                   WH52.1
Element: Unit of Measure

WLI-TRAN-UOM           Alpha 4                                   WH52.1
Element: Unit of Measure

WLI-TRAN-UOM-MULT      Signed 13.7                               WH52.1
Unit of Measure
Multiplier

WLI-IN-PROCESS-QTY     Signed 13.4                               WH52.1
Element: Quantity

WLI-SHIPPED-QTY        Signed 13.4                               WH52.1
Element: Quantity

WLI-CATCH-WT-QTY       Signed 13.4                               WH52.1
Element: Quantity

WLI-PRE-ASMBLD-KIT     Signed 13.4                               WH52.1
Element: Document Total

WLI-DETAIL-QTY         Signed 13.4                               WH52.1
Element: Quantity

WLI-DTL-CTW-QTY        Signed 13.4                               WH52.1
Element: Quantity

WLI-UNIT-COST          Signed 13.5                               WH52.1
Element: Base Cost

WLI-WEIGHT             Signed 9.3                                WH52.1
Element: Unit Weight   This field contains the unit weight of
                       the item based on the stocking UOM.

WLI-CUBIC-FEET         Signed 9.3                                WH52.1
Element: Cubic Feet    This field contains the unit cubic feet
                       of the item based on the stocking UOM.

WLI-MSDS-DT            Numeric 8  (yyyymmdd)                     WH52.1
Element: Date

                         WHSHLINEIN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WLISET1   COMPANY                                                WH52.1  WH52.2
          LOCATION                                               WH52.3  WH520
          SHIPMENT-NBR
          LINE-NBR

WLISET2   COMPANY
          LOCATION
          PROCESS-DATE
          SHIPMENT-NBR
          LINE-NBR

                         WHSHLINEIN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Whshpmntin     WHSHPMNTIN   Required

                            WLI-COMPANY         -> WSI-COMPANY  (WSISET1)
                            WLI-LOCATION        -> WSI-LOCATION
                            WLI-SHIPMENT-NBR    -> WSI-SHIPMENT-NBR

                         WHSHLINEIN FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Whslcrtnin     WHSLCRTNIN

                            WLI-COMPANY         -> WCL-COMPANY
                            WLI-LOCATION        -> WCL-LOCATION
                            WLI-SHIPMENT-NBR    -> WCL-SHIPMENT-NBR
                            WLI-LINE-NBR        -> WCL-SHIP-LINE-NBR
                                                   WCL-CARTON-NBR