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