Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            WHSHLDTLIN FILE

UPDATED BY

WH52.2    WH520

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


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

WDI-SHIPMENT-NBR     Numeric 10                                  WH52.2
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.


WDI-LINE-NBR         Numeric 6                                   WH52.2
Line Number          This field contains the line number.

WDI-COMPONENT-SEQ    Numeric 3                                   WH52.2
Component Sequence   This field contains the component
Number               sequence number.

WDI-BIN              Alpha 7                                     WH52.2
Bin                  This field contains a storage area for
                     an item or any number of items.

WDI-LOT              Alpha 10                                    WH52.2
Lot Number           This field contains the identifier for
                     the homogeneous quantity of material.

WDI-SUBLOT           Alpha 6                                     WH52.2
Sublot Number        This field contains the identifier for
                     a detail breakdown of a lot number.

WDI-SERIAL           Alpha 16                                    WH52.2
Serial Number

WDI-UOM              Alpha 4                                     WH52.2
Unit of Measure      This field contains the valid stock
                     unit of measure for this item.


WDI-PROCESS-DATE     Numeric 8  (yyyymmdd)                       WH52.2
Process Date

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

WDI-UOM-MULT         Signed 13.7                                 WH52.2
Unit of Measure      This field contains the multiplier for
Multiplier           converting this unit of measure to the
                     stock unit of measure.

WDI-QUANTITY         Signed 13.4                                 WH52.2
Quantity             This field contains the desired
                     quantity.

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

                         WHSHLDTLIN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WDISET1   COMPANY                                                WH52.1  WH52.2
          LOCATION                                               WH520
          SHIPMENT-NBR
          LINE-NBR
          COMPONENT-SEQ
          BIN
          LOT
          SUBLOT
          SERIAL
          UOM

WDISET2   COMPANY
          LOCATION
          PROCESS-DATE
          SHIPMENT-NBR
          LINE-NBR
          COMPONENT-SEQ
          BIN
          LOT
          SUBLOT
          SERIAL
          UOM

                         WHSHLDTLIN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Whshlinein     WHSHLINEIN   Required

                            WDI-COMPANY         -> WLI-COMPANY  (WLISET1)
                            WDI-LOCATION        -> WLI-LOCATION
                            WDI-SHIPMENT-NBR    -> WLI-SHIPMENT-NBR
                            WDI-LINE-NBR        -> WLI-LINE-NBR