Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WHSLCRTNIN


                            WHSLCRTNIN FILE

UPDATED BY

WH52.3    WH520

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WCL-COMPANY            Numeric 4                                 WH52.3
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.

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

WCL-SHIPMENT-NBR       Numeric 10                                WH52.3
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.


WCL-CARTON-NBR         Alpha 20                                  WH52.3
Element: Carton Nbr

WCL-SHIP-LINE-NBR      Numeric 6                                 WH52.3
Element: Ship Line Nbr

WCL-CRTN-LINE-NBR      Numeric 6                                 WH52.3
Element: Crtn Line Nbr

WCL-PROCESS-DATE       Numeric 8  (yyyymmdd)                     WH52.3
Element: Process Date

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

WCL-PACKGE-BARCODE     Alpha 20                                  WH52.3
Element: Packge Barcode

WCL-TO-BE-PCK-UNIT     Signed 9.3                                WH52.3
Element: To Be Pck Unit

WCL-UNITS-PACKED       Signed 9.3                                WH52.3
Element: Units Packed

WCL-TO-BE-PCK-BOXS     Signed 9.3                                WH52.3
Element: To Be Pck Boxs

WCL-BOXES-PACKED       Signed 9.3                                WH52.3
Element: Boxes Packed

WCL-ASSORTMENT-NBR     Alpha 12                                  WH52.3
Element: Assortment Nbr

WCL-PALLET-ID          Alpha 20                                  WH52.3
Element: Pallet Id

WCL-INT-REF-USER3      Alpha 20                                  WH52.3
Element: Int Ref User3

WCL-INT-REF-USER4      Alpha 30                                  WH52.3
Element: Int Ref User4

                         WHSLCRTNIN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WCLSET1   COMPANY
          LOCATION
          SHIPMENT-NBR
          CARTON-NBR
          SHIP-LINE-NBR

WCLSET2   COMPANY                                                WH52.1  WH52.3
          LOCATION                                               WH520
          SHIPMENT-NBR
          SHIP-LINE-NBR
          CARTON-NBR

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

                         WHSLCRTNIN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Whshcrtnin     WHSHCRTNIN   Required

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