|
|
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 This field contains a valid stocking
location within the company inventory.
WCN-SHIPMENT-NBR Numeric 10 WH52.4
Element: Shipment Nbr 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 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
|
