Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            WHSLCRTNIN FILE

UPDATED BY

WH52.3    WH520

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

WCL-INT-REF-USER4    Alpha 30                                    WH52.3
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