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
|
