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