Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WHSHLINEIN


                            WHSHLINEIN FILE

UPDATED BY

WH52.1    WH520

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WLI-COMPANY            Numeric 4                                 WH52.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

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

WLI-SHIPMENT-NBR       Numeric 10                                WH52.1
Element: Shipment Nbr  This 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 Nbr      This field contains the line number.

WLI-PROCESS-DATE       Numeric 8  (yyyymmdd)                     WH52.1
Element: Process 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          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: Uom           This field contains the valid stock
                       unit of measure for this item.


WLI-TRAN-UOM           Alpha 4                                   WH52.1
Element: Uom           This field contains the valid stock
                       unit of measure for this item.


WLI-TRAN-UOM-MULT      Signed 13.7                               WH52.1
Element: Uom Mult      This field contains the multiplier for
                       converting this unit of measure to the
                       stock unit of measure.

WLI-IN-PROCESS-QTY     Signed 13.4                               WH52.1
Element: Quantity      This field contains the desired
                       quantity.

WLI-SHIPPED-QTY        Signed 13.4                               WH52.1
Element: Quantity      This field contains the desired
                       quantity.

WLI-CATCH-WT-QTY       Signed 13.4                               WH52.1
Element: Quantity      This field contains the desired
                       quantity.

WLI-PRE-ASMBLD-KIT     Signed 13.4                               WH52.1
Element: Pre Asmbld Kit

WLI-DETAIL-QTY         Signed 13.4                               WH52.1
Element: Quantity      This field contains the desired
                       quantity.

WLI-DTL-CTW-QTY        Signed 13.4                               WH52.1
Element: Quantity      This field contains the desired
                       quantity.

WLI-UNIT-COST          Signed 18.5                               WH52.1
Element: Intl Cost

WLI-WEIGHT             Signed 9.3                                WH52.1
Element: 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: Msds Dt       This date is the date that a new
                       Material Safety Data Sheet should be
                       sent from the vendor.

                         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