WHSHCRTNIN

UPDATED BY
WH52.4 WH520

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WCN-COMPANY
Element: Company
Numeric 4
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.
WH52.4
WCN-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
WH52.4
WCN-SHIPMENT-NBR
Element: Shipment Nbr
Numeric 10
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.
WH52.4
WCN-CARTON-NBR
Element: Carton Nbr
Alpha 20
WH52.4
WCN-PROCESS-DATE
Element: Process Date
Numeric 8 (yyyymmdd)
WH52.4
WCN-UPDATE-TIME
Element: Update Time
Numeric 6
This field contains the system time when the record was updated.
WH52.4
WCN-CRTN-TRACK-NBR
Element: Crtn Track Nbr
Alpha 30
WH52.4
WCN-CARTON-TYPE
Element: Carton Type
Alpha 3
WH52.4
WCN-CARTON-SIZE
Element: Carton Size
Alpha 3
WH52.4
WCN-CRTN-SHIP-UNIT
Element: Crtn Ship Unit
Alpha 1
WH52.4
WCN-CARTON-CUBIC
Element: Carton Cubic
Signed 9.3
WH52.4
WCN-CRTN-EST-WT
Element: Crtn Est Wt
Signed 9.3
WH52.4
WCN-CRTN-ACTUAL-WT
Element: Crtn Actual Wt
Signed 9.3
WH52.4
WCN-CRTN-TOTAL-QTY
Element: Crtn Total Qty
Signed 13.4
WH52.4
WCN-FRT-CHG-CURR
Element: Intl Amt
Signed 18.2
WH52.4
WCN-PACKAGE-DESC
Element: Package Desc
Alpha 30
WH52.4
WCN-INT-REF-USER1
Element: Int Ref User1
Alpha 20
WH52.4
WCN-INT-REF-USER2
Element: Int Ref User2
Alpha 30
WH52.4


WHSHCRTNIN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WCNSET1 COMPANY
LOCATION
SHIPMENT-NBR
CARTON-NBR
WH52.4 WH520


WHSHCRTNIN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 02:33:51 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.