Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            WHSHPMNTIN FILE

UPDATED BY

WH52.1    WH520

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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


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

WSI-STATUS           Numeric 1                                   WH52.1
Status               This field contains the status of the
                     transaction.

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

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

WSI-GL-DATE          Numeric 8  (yyyymmdd)                       WH52.1
General Ledger Date  This field contains the general ledger
                     posting date.

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


WSI-CARRIER          Alpha 9                                     WH52.1
Carrier Vendor       This is the carrier vendor number. It
Number               must be a valid vendor.

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

WSI-TRANS-ID         Alpha 10                                    WH52.1
Trans Id


WSI-FREIGHT-CODE     Alpha 2                                     WH52.1
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 15.2                                 WH52.1
Frt Chg Curr


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

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

WSI-WEIGHT           Signed 9.3                                  WH52.1
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
Pod Retrn Dt         This field contains the date the POD is
                     returned with an acknowledgment.

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

WSI-PACK-DATE        Numeric 8  (yyyymmdd)                       WH52.1
Pack 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
Ship Date            This field contains the ship date.  If
                     left blank, the system date defaults.

WSI-CUST-PO-NBR      Alpha 20                                    WH52.1
Customer P.O. Number

WSI-VENDOR           Alpha 9                                     WH52.1
Vendor ID            The vendor's identification code.



                         WHSHPMNTIN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WSISET1   COMPANY                                                WH52.1  WH520
          LOCATION
          SHIPMENT-NBR

WSISET2   COMPANY
          LOCATION
          PROCESS-DATE
          SHIPMENT-NBR

WSISET3   COMPANY
          LOCATION
          BATCH-NBR
          SHIPMENT-NBR