Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms

                            WHSHCRTNIN FILE

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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


WCN-CARTON-NBR       Alpha 20
Carton Nbr

WCN-PROCESS-DATE     Numeric 8  (yyyymmdd)
Process Date

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

WCN-CRTN-TRACK-NBR   Alpha 30
Crtn Track Nbr

WCN-CARTON-TYPE      Alpha 3
Carton Type

WCN-CARTON-SIZE      Alpha 3
Carton Size

WCN-CRTN-SHIP-UNIT   Alpha 1
Crtn Ship Unit

WCN-CARTON-CUBIC     Signed 9.3
Carton Cubic

WCN-CRTN-EST-WT      Signed 9.3
Crtn Est Wt

WCN-CRTN-ACTUAL-WT   Signed 9.3
Crtn Actual Wt

WCN-CRTN-TOTAL-QTY   Signed 13.4
Crtn Total Qty

WCN-FRT-CHG-CURR     Signed 15.2
Frt Chg Curr

WCN-PACKAGE-DESC     Alpha 30
Package Desc

                         WHSHCRTNIN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WCNSET1   COMPANY
          LOCATION
          SHIPMENT-NBR
          CARTON-NBR

                         WHSHCRTNIN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Whshpmntin     WHSHPMNTIN   Required

                            WCN-COMPANY         -> WSI-COMPANY  (WSISET1)
                            WCN-LOCATION        -> WSI-LOCATION
                            WCN-SHIPMENT-NBR    -> WSI-SHIPMENT-NBR

                         WHSHCRTNIN FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Whslcrtnin     WHSLCRTNIN

                            WCN-COMPANY         -> WCL-COMPANY
                            WCN-LOCATION        -> WCL-LOCATION
                            WCN-SHIPMENT-NBR    -> WCL-SHIPMENT-NBR
                            WCN-CARTON-NBR      -> WCL-CARTON-NBR
                                                   WCL-SHIP-LINE-NBR

Whslcrtnline   WHSLCRTNIN

                            WCN-COMPANY         -> WCL-COMPANY
                            WCN-LOCATION        -> WCL-LOCATION
                            WCN-SHIPMENT-NBR    -> WCL-SHIPMENT-NBR
                            WCN-CARTON-NBR      -> WCL-CARTON-NBR
                                                   WCL-CRTN-LINE-NBR