Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WHSHCRTNIN


                            WHSHCRTNIN FILE

UPDATED BY

WH52.4    WH520

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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


WCN-CARTON-NBR         Alpha 20                                  WH52.4
Element: Carton Nbr

WCN-PROCESS-DATE       Numeric 8  (yyyymmdd)                     WH52.4
Element: Process Date

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

WCN-CRTN-TRACK-NBR     Alpha 30                                  WH52.4
Element: Crtn Track Nbr

WCN-CARTON-TYPE        Alpha 3                                   WH52.4
Element: Carton Type

WCN-CARTON-SIZE        Alpha 3                                   WH52.4
Element: Carton Size

WCN-CRTN-SHIP-UNIT     Alpha 1                                   WH52.4
Element: Crtn Ship Unit

WCN-CARTON-CUBIC       Signed 9.3                                WH52.4
Element: Carton Cubic

WCN-CRTN-EST-WT        Signed 9.3                                WH52.4
Element: Crtn Est Wt

WCN-CRTN-ACTUAL-WT     Signed 9.3                                WH52.4
Element: Crtn Actual Wt

WCN-CRTN-TOTAL-QTY     Signed 13.4                               WH52.4
Element: Crtn Total Qty

WCN-FRT-CHG-CURR       Signed 18.2                               WH52.4
Element: Intl Amt

WCN-PACKAGE-DESC       Alpha 30                                  WH52.4
Element: Package Desc

WCN-INT-REF-USER1      Alpha 20                                  WH52.4
Element: Int Ref User1

WCN-INT-REF-USER2      Alpha 30                                  WH52.4
Element: Int Ref User2

                         WHSHCRTNIN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WCNSET1   COMPANY                                                WH52.4  WH520
          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
                            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