WHSLCRTNIN FILE
UPDATED BY
WH52.3 WH520
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WCL-COMPANY Numeric 4 WH52.3
Company The company number represents an
established company and is entered on
all function codes.
WCL-LOCATION Alpha 5 WH52.3
Location Code This field contains a valid stocking
location within the company inventory.
WCL-SHIPMENT-NBR Numeric 10 WH52.3
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.
WCL-CARTON-NBR Alpha 20 WH52.3
Carton Nbr
WCL-SHIP-LINE-NBR Numeric 6 WH52.3
Ship Line Nbr
WCL-CRTN-LINE-NBR Numeric 6 WH52.3
Crtn Line Nbr
WCL-PROCESS-DATE Numeric 8 (yyyymmdd) WH52.3
Process Date
WCL-UPDATE-TIME Numeric 6 WH52.3
Update Time This field contains the system time
when the record was updated.
WCL-PACKGE-BARCODE Alpha 20 WH52.3
Packge Barcode
WCL-TO-BE-PCK-UNIT Signed 9.3 WH52.3
To Be Pck Unit
WCL-UNITS-PACKED Signed 9.3 WH52.3
Units Packed
WCL-TO-BE-PCK-BOXS Signed 9.3 WH52.3
To Be Pck Boxs
WCL-BOXES-PACKED Signed 9.3 WH52.3
Boxes Packed
WCL-ASSORTMENT-NBR Alpha 12 WH52.3
Assortment Nbr
WCL-PALLET-ID Alpha 20 WH52.3
Pallet Id
WCL-INT-REF-USER3 Alpha 20 WH52.3
Int Ref User3
WCL-INT-REF-USER4 Alpha 30 WH52.3
Int Ref User4
WHSLCRTNIN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WCLSET1 COMPANY
LOCATION
SHIPMENT-NBR
CARTON-NBR
SHIP-LINE-NBR
WCLSET2 COMPANY WH52.1 WH52.3
LOCATION WH520
SHIPMENT-NBR
SHIP-LINE-NBR
CARTON-NBR
WCLSET3 COMPANY
LOCATION
SHIPMENT-NBR
CARTON-NBR
CRTN-LINE-NBR
WHSLCRTNIN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Whshcrtnin WHSHCRTNIN Required
WCL-COMPANY -> WCN-COMPANY (WCNSET1)
WCL-LOCATION -> WCN-LOCATION
WCL-SHIPMENT-NBR -> WCN-SHIPMENT-NBR
WCL-CARTON-NBR -> WCN-CARTON-NBR
|
