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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

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

Programs

Updated by (38)