WHSLCRTNIN

UPDATED BY
WH52.3 WH520

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


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
WH52.1 WH52.3
WH520
WCLSET3 COMPANY
LOCATION
SHIPMENT-NBR
CARTON-NBR
CRTN-LINE-NBR


WHSLCRTNIN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 02:33:59 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.