WHSHTRK – No description in the Lawson data dictionary

System
Warehouse (WH)
Prefix
WHT
Primary key
COMPANY, LOCATION, SHIPMENT-NBR, TRACKING-NBR
Fields
7
Updated by
37 programs
Referenced by
0 programs

WHSHTRK is a Lawson Warehouse table (prefix WHT); no description in the lawson data dictionary. It is indexed by COMPANY, LOCATION, SHIPMENT-NBR, TRACKING-NBR (WHTSET1). It is related 1:M to WHSHTRKDTL. It is updated by CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 and 29 more. The table has 7 fields, 1 index and 1 documented relation.

About WHSHTRK

No description in the Lawson data dictionary.

Fields (7)

Column = COBOL field name without the WHT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
WHT-COMPANY PK
COMPANY		Numeric 4—WH32.1, WH32.2, WH32.4, WH39.1, WH520
WHT-LOCATION PK
LOCATION		Alpha 5—WH32.1, WH32.2, WH32.4, WH39.1, WH520
WHT-SHIPMENT-NBR PK
SHIPMENT_NBR		Numeric 10—WH32.1, WH32.2, WH32.4, WH39.1, WH520
WHT-TRACKING-NBR PK
TRACKING_NBR		Alpha 40—WH32.1, WH32.2, WH32.4, WH39.1, WH520
WHT-CONTAINER-TYPE
CONTAINER_TYPE		Alpha 20—WH32.1, WH32.2, WH32.4, WH39.1, WH520
WHT-PICKING-SOURCE
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
LAST_LINE_NBR		Numeric 6—WH39.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
WHTSET1COMPANY, LOCATION, SHIPMENT-NBR, TRACKING-NBRPrimaryCX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +22 more (list truncated in source)

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
WhshtrkdtlWHSHTRKDTLWHT-COMPANY → WTD-COMPANY, WHT-LOCATION → WTD-LOCATION, WHT-SHIPMENT-NBR → WTD-SHIPMENT-NBR, WHT-TRACKING-NBR → WTD-TRACKING-NBR, → WTD-TRK-LINE-NBR

Programs

Updated by (37)