Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WHSHLDTLIN


                            WHSHLDTLIN FILE

                     WH Shipment Line Detail Input

UPDATED BY

WH52.2    WH520

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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


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

WDI-COMPONENT-SEQ      Numeric 3                                 WH52.2
Element: 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 Number    This field contains the identifier for
                       the homogeneous quantity of material.

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

WDI-SERIAL             Alpha 16                                  WH52.2
Element: Serial Number

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


WDI-PROCESS-DATE       Numeric 8  (yyyymmdd)                     WH52.2
Element: 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
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
Element: Quantity      This field contains the desired
                       quantity.

WDI-CATCH-WT-QTY       Signed 13.4                               WH52.2
Element: 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