WHSHTRKDTL – No description in the Lawson data dictionary

System
Warehouse (WH)
Prefix
WTD
Primary key
COMPANY, LOCATION, SHIPMENT-NBR, TRACKING-NBR, TRK-LINE-NBR
Fields
8
Updated by
38 programs
Referenced by
0 programs

WHSHTRKDTL is a Lawson Warehouse table (prefix WTD); no description in the lawson data dictionary. It is indexed by COMPANY, LOCATION, SHIPMENT-NBR, TRACKING-NBR, TRK-LINE-NBR (WTDSET1). It is updated by CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 and 30 more. The table has 8 fields, 1 index and 0 documented relations.

About WHSHTRKDTL

No description in the Lawson data dictionary.

Fields (8)

Column = COBOL field name without the WTD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#WTD-COMPANY PK
COMPANY		Numeric 4—WH39.1, WH39.2
#WTD-LOCATION PK
LOCATION		Alpha 5—WH39.1, WH39.2
#WTD-SHIPMENT-NBR PK
SHIPMENT_NBR		Numeric 10—WH39.1, WH39.2
#WTD-TRACKING-NBR PK
TRACKING_NBR		Alpha 40—WH39.1, WH39.2
#WTD-TRK-LINE-NBR PK
TRK_LINE_NBR		Numeric 6—WH39.1, WH39.2
#WTD-ITEM
ITEM		Alpha 32This field contains the item identifier.WH39.1, WH39.2
#WTD-QUANTITY
QUANTITY		Signed 13.4This field contains the item quantity.WH39.1, WH39.2
#WTD-UOM
UOM		Alpha 4This field contains the unit of measure from the shipment line.WH39.1, WH39.2

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
WTDSET1
  1. COMPANY
  2. LOCATION
  3. SHIPMENT-NBR
  4. TRACKING-NBR
  5. TRK-LINE-NBR
PrimaryCX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +22 more (list truncated in source)

Programs

Updated by (38)