Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WHSHLDTLIN


                            WHSHLDTLIN FILE

UPDATED BY

WH52.2    WH520

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WDI-COMPANY            Numeric 4                                 WH52.2
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.

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

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


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

WDI-COMPONENT-SEQ      Numeric 3                                 WH52.2
Element: Seq           This field contains the record sequence
                       number.

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

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

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

WDI-SERIAL             Alpha 16                                  WH52.2
Element: Serial

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


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

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

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

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

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

                         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