Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            WHSHINTREF FILE

UPDATED BY

WH520

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

WIR-COMPANY          Numeric 4                                   WH520
Company              The company number represents an
                     established company and is entered on
                     all function codes.


WIR-LOCATION         Alpha 5                                     WH520
Location Code        This field contains a valid stocking
                     location within the company inventory.

WIR-SHIPMENT-NBR     Numeric 10                                  WH520
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.


WIR-SHIP-LINE-NBR    Numeric 6                                   WH520
Ship Line Nbr

WIR-SEQ              Numeric 3                                   WH520
Sequence Number      This field contains the record sequence
                     number.


WIR-RECORD-TYPE      Alpha 1                                     WH520
Record Type          This field identifies the type of
                     record defined.

                     Valid values are:
                     S = Summary
                     D = Detail

WIR-CARTON-NBR       Alpha 20                                    WH520
Carton Nbr

WIR-CRTN-TRACK-NBR   Alpha 30                                    WH520
Crtn Track Nbr

WIR-CARTON-TYPE      Alpha 3                                     WH520
Carton Type

WIR-CARTON-SIZE      Alpha 3                                     WH520
Carton Size

WIR-CRTN-SHIP-UNIT   Alpha 1                                     WH520
Crtn Ship Unit

WIR-CARTON-CUBIC     Signed 9.3                                  WH520
Carton Cubic

WIR-CRTN-EST-WT      Signed 9.3                                  WH520
Crtn Est Wt

WIR-CRTN-ACTUAL-WT   Signed 9.3                                  WH520
Crtn Actual Wt

WIR-CRTN-TOTAL-QTY   Signed 13.4                                 WH520
Crtn Total Qty

WIR-FRT-CHG-CURR     Signed 15.2                                 WH520
Frt Chg Curr

WIR-PACKAGE-DESC     Alpha 30                                    WH520
Package Desc

WIR-CRTN-LINE-NBR    Numeric 6                                   WH520
Crtn Line Nbr

WIR-PACKGE-BARCODE   Alpha 20                                    WH520
Packge Barcode

WIR-TO-BE-PCK-UNIT   Signed 9.3                                  WH520
To Be Pck Unit

WIR-UNITS-PACKED     Signed 9.3                                  WH520
Units Packed

WIR-TO-BE-PCK-BOXS   Signed 9.3                                  WH520
To Be Pck Boxs

WIR-BOXES-PACKED     Signed 9.3                                  WH520
Boxes Packed

WIR-ASSORTMENT-NBR   Alpha 12                                    WH520
Assortment Nbr

WIR-PALLET-ID        Alpha 20                                    WH520
Pallet Id

WIR-INT-REF-USER1    Alpha 20                                    WH520
Int Ref User1

WIR-INT-REF-USER2    Alpha 30                                    WH520
Int Ref User2

WIR-INT-REF-USER3    Alpha 20                                    WH520
Int Ref User3

WIR-INT-REF-USER4    Alpha 30                                    WH520
Int Ref User4

                         WHSHINTREF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WIRSET1   COMPANY
          LOCATION
          SHIPMENT-NBR
          SHIP-LINE-NBR
          SEQ

WIRSET2   COMPANY
          LOCATION
          SHIPMENT-NBR
          CARTON-NBR
          CRTN-LINE-NBR

WIRSET3   COMPANY
          LOCATION
          SHIPMENT-NBR
          SHIP-LINE-NBR
          CARTON-NBR
          CRTN-LINE-NBR