|
|
WHSLCRTNIN FILE
UPDATED BY
WH52.3 WH520
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WCL-COMPANY Numeric 4 WH52.3
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.
WCL-LOCATION Alpha 5 WH52.3
Element: Location This field contains a valid stocking
location within the company inventory.
WCL-SHIPMENT-NBR Numeric 10 WH52.3
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.
WCL-CARTON-NBR Alpha 20 WH52.3
Element: Carton Nbr
WCL-SHIP-LINE-NBR Numeric 6 WH52.3
Element: Ship Line Nbr
WCL-CRTN-LINE-NBR Numeric 6 WH52.3
Element: Crtn Line Nbr
WCL-PROCESS-DATE Numeric 8 (yyyymmdd) WH52.3
Element: Process Date
WCL-UPDATE-TIME Numeric 6 WH52.3
Element: Update Time This field contains the system time
when the record was updated.
WCL-PACKGE-BARCODE Alpha 20 WH52.3
Element: Packge Barcode
WCL-TO-BE-PCK-UNIT Signed 9.3 WH52.3
Element: To Be Pck Unit
WCL-UNITS-PACKED Signed 9.3 WH52.3
Element: Units Packed
WCL-TO-BE-PCK-BOXS Signed 9.3 WH52.3
Element: To Be Pck Boxs
WCL-BOXES-PACKED Signed 9.3 WH52.3
Element: Boxes Packed
WCL-ASSORTMENT-NBR Alpha 12 WH52.3
Element: Assortment Nbr
WCL-PALLET-ID Alpha 20 WH52.3
Element: Pallet Id
WCL-INT-REF-USER3 Alpha 20 WH52.3
Element: Int Ref User3
WCL-INT-REF-USER4 Alpha 30 WH52.3
Element: 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
|
