Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WHSHPMNTIN


                            WHSHPMNTIN FILE

UPDATED BY

WH52.1    WH520

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WSI-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.

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

WSI-SHIPMENT-NBR       Numeric 10                                WH52.1
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.


WSI-BATCH-NBR          Numeric 6                                 WH52.1
Element: Batch Number  This identifies the batch the entered
                       invoices, debit memos, and credit memos
                       are a part of.

WSI-STATUS             Numeric 1                                 WH52.1
Element: Status        This field displays the status of the
                       transaction.

WSI-PROCESS-DATE       Numeric 8  (yyyymmdd)                     WH52.1
Element: Process Date

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

WSI-GL-DATE            Numeric 8  (yyyymmdd)                     WH52.1
Element: General LedgerThis field contains the general ledger
                       posting date.

WSI-BOL-NBR            Alpha 22                                  WH52.1
Bill of Lading         This field contains the Bill of Lading
Number                 number.

WSI-CARRIER            Alpha 9  (Right Justified)                WH52.1
Element: Vendor ID     This is the carrier vendor number. It
                       must be a valid vendor.

WSI-METHOD             Alpha 10                                  WH52.1
Element: Method Code   The method.

WSI-TRANS-ID           Alpha 20                                  WH52.1
Element: Trans Id

WSI-FREIGHT-CODE       Alpha 2                                   WH52.1
Element: Freight Code  This field contains the freight code.
                       This is must be valid in OEFRTCODE. This
                       determines whether carrier and charge
                       are allowed for the shipment.

WSI-FRT-CHG-CURR       Signed 18.2                               WH52.1
Element: Intl Amt

WSI-WHS-CARTONS        Numeric 6                                 WH52.1
Element: Whs Cartons

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

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

WSI-POD-RETRN-DT       Numeric 8  (yyyymmdd)                     WH52.1
Element: Date          This field contains the date the POD is
                       returned with an acknowledgment.

WSI-PICK-DATE          Numeric 8  (yyyymmdd)                     WH52.1
Element: Date          This field contains the pick date.
                       The system date defaults.

WSI-PACK-DATE          Numeric 8  (yyyymmdd)                     WH52.1
Element: Date          This field contains the pack date. The
                       system date defaults but can be
                       overridden if you are using OE20.1 (On
                       Line Allocation).

WSI-SHIP-DATE          Numeric 8  (yyyymmdd)                     WH52.1
Element: Date          This field contains the ship date.  If
                       left blank, the system date defaults.

WSI-CUST-PO-NBR        Alpha 22                                  WH52.1
Element: Customer P.O. Number

WSI-VENDOR             Alpha 9  (Right Justified)                WH52.1
Element: Vendor ID     The vendor's identification code.



                         WHSHPMNTIN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WSISET1   COMPANY                                                WH52.1  WH52.2
          LOCATION                                               WH52.3  WH52.4
          SHIPMENT-NBR                                           WH520

WSISET2   COMPANY
          LOCATION
          PROCESS-DATE
          SHIPMENT-NBR

WSISET3   COMPANY
          LOCATION
          BATCH-NBR

                         WHSHPMNTIN FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Whshcrtnin     WHSHCRTNIN

                            WSI-COMPANY         -> WCN-COMPANY  (WCNSET1)
                            WSI-LOCATION        -> WCN-LOCATION
                            WSI-SHIPMENT-NBR    -> WCN-SHIPMENT-NBR
                                                   WCN-CARTON-NBR

Whshlinein     WHSHLINEIN

                            WSI-COMPANY         -> WLI-COMPANY
                            WSI-LOCATION        -> WLI-LOCATION
                            WSI-SHIPMENT-NBR    -> WLI-SHIPMENT-NBR
                                                   WLI-LINE-NBR