WHSHTRK

UPDATED BY
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 RQ300 WH130 WH132
WH190 WH222 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH32.5 WH33.5 WH34.1 WH34.2
WH34.3 WH34.4 WH39.1 WH40.1 WH40.2 WH520
WH830

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHT-COMPANY
Element: Company		Numeric 4
WH32.1 WH32.2
WH32.4 WH39.1
WH520
WHT-LOCATION
Element: Location		Alpha 5
WH32.1 WH32.2
WH32.4 WH39.1
WH520
WHT-SHIPMENT-NBR
Element: Shipment Nbr		Numeric 10
WH32.1 WH32.2
WH32.4 WH39.1
WH520
WHT-TRACKING-NBR
Element: Tracking Nbr		Alpha 40
WH32.1 WH32.2
WH32.4 WH39.1
WH520
WHT-CONTAINER-TYPE
Element: Container Type		Alpha 20
WH32.1 WH32.2
WH32.4 WH39.1
WH520
WHT-PICKING-SOURCE
Element: Picking Source		Numeric 1

1 = Third Party WMS
2 = Picked Internally in WH
WH32.1 WH32.2
WH32.4 WH39.1
WH520
WHT-LAST-LINE-NBR
Element: Line Nbr		Numeric 6
WH39.1


WHSHTRK FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WHTSET1 COMPANY
LOCATION
SHIPMENT-NBR
TRACKING-NBR
...
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 RQ300
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH33.7 WH34.1


WHSHTRK FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Whshtrkdtl WHSHTRKDTL
WHT-COMPANY->WTD-COMPANY
WHT-LOCATION->WTD-LOCATION
WHT-SHIPMENT-NBR->WTD-SHIPMENT-NBR
WHT-TRACKING-NBR->WTD-TRACKING-NBR
  WTD-TRK-LINE-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.