Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            WHSHLINEIN FILE

UPDATED BY

WH52.1    WH520

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


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

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

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

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

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

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

WLI-STOCK-UOM        Alpha 4                                     WH52.1
Stocking Unit of     This is the stock unit of measure for
Measure              the item.

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

WLI-TRAN-UOM-MULT    Signed 13.7                                 WH52.1
Transaction UOM
Multiplier

WLI-IN-PROCESS-QTY   Signed 13.4                                 WH52.1
In Process Qty

WLI-SHIPPED-QTY      Signed 13.4                                 WH52.1
Shipped Quantity

WLI-CATCH-WT-QTY     Signed 13.4                                 WH52.1
Catch Weight         This field contains the quantity
Quantity             received for catch weight shipments.

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

WLI-DETAIL-QTY       Signed 13.4                                 WH52.1
Detail Qty           This field shows the total quantity of
                     details defined for a detail tracked
                     item. It is matched against the line
                     quantity field to determine if details
                     are in balance.
                     In the item detail screen, it is the
                     quantity for a particular lot or bin.

WLI-DTL-CTW-QTY      Signed 13.4                                 WH52.1
Dtl Ctw Qty

WLI-UNIT-COST        Signed 13.5                                 WH52.1
Unit Cost            This field contains the unit cost.

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

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

WLI-MSDS-DT          Numeric 8  (yyyymmdd)                       WH52.1
Material Safety      This date is the date that a new
DataSheet Date       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