Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WHSHINTREF


                            WHSHINTREF FILE

UPDATED BY

WH520

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WIR-COMPANY            Numeric 4                                 WH520
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.

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

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


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

WIR-SEQ                Numeric 3                                 WH520
Element: Sequence NumbeThis field contains the record sequence
                       number.

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

                       Valid values are:
                       S = Summary
                       D = Detail

WIR-CARTON-NBR         Alpha 20                                  WH520
Element: Carton Nbr

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

WIR-CARTON-TYPE        Alpha 3                                   WH520
Element: Carton Type

WIR-CARTON-SIZE        Alpha 3                                   WH520
Element: Carton Size

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

WIR-CARTON-CUBIC       Signed 9.3                                WH520
Element: Carton Cubic

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

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

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

WIR-FRT-CHG-CURR       Signed 18.2                               WH520
Element: Intl Amt

WIR-PACKAGE-DESC       Alpha 30                                  WH520
Element: Package Desc

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

WIR-PACKGE-BARCODE     Alpha 20                                  WH520
Element: Packge Barcode

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

WIR-UNITS-PACKED       Signed 9.3                                WH520
Element: Units Packed

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

WIR-BOXES-PACKED       Signed 9.3                                WH520
Element: Boxes Packed

WIR-ASSORTMENT-NBR     Alpha 12                                  WH520
Element: Assortment Nbr

WIR-PALLET-ID          Alpha 20                                  WH520
Element: Pallet Id

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

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

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

WIR-INT-REF-USER4      Alpha 30                                  WH520
Element: 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