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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#WHT-COMPANY PKCOMPANY | Numeric 4 | — | WH32.1, WH32.2, WH32.4, WH39.1, WH520 |
#WHT-LOCATION PKLOCATION | Alpha 5 | — | WH32.1, WH32.2, WH32.4, WH39.1, WH520 |
#WHT-SHIPMENT-NBR PKSHIPMENT_NBR | Numeric 10 | — | WH32.1, WH32.2, WH32.4, WH39.1, WH520 |
#WHT-TRACKING-NBR PKTRACKING_NBR | Alpha 40 | — | WH32.1, WH32.2, WH32.4, WH39.1, WH520 |
#WHT-CONTAINER-TYPECONTAINER_TYPE | Alpha 20 | — | WH32.1, WH32.2, WH32.4, WH39.1, WH520 |
#WHT-PICKING-SOURCEPICKING_SOURCE | Numeric 1 | —
| WH32.1, WH32.2, WH32.4, WH39.1, WH520 |
#WHT-LAST-LINE-NBRLAST_LINE_NBR | Numeric 6 | — | WH39.1 |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
WHTSET1 |
| Primary | CX100, 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
| Relation | Table | Rules | Condition | Field map | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Whshtrkdtl | WHSHTRKDTL |
|
Programs
Updated by (37)
- CX100 Pick List Print
- CX20.1 Case Build
- CX20.2 Case Detail
- CX20.4 Substitute Items
- CX20.5 Insert line
- CX220 Case, Preference Listing
- CX30.1 Case Completion Feedback
- CX300 Preference List Purge
- CX506 HL7 Schedules Import Interface
- RQ300 Requisition Purge
- WH130 Pick List Print
- WH132 Batch Feedback
- WH190 Shipment Release
- WH222 Shipments In Process
- WH30.1 Picking Feedback by Document
- WH30.2 Picking Feedback by Shipment
- WH30.3 Picking by Batch
- WH30.4 Bin Sequence Picking Feedback
- WH31.1 Packing Feedback by Document
- WH31.2 Packing Feedback by Shipment
- WH31.3 Packing by Batch
- WH31.4 Bin Sequence Packing Feedback
- WH32.1 Shipping Feedback by Document
- WH32.2 Shipping Feedback by Shipment
- WH32.3 Shipping by Batch
- WH32.4 Bin Sequence Shipping Feedback
- WH32.5 Shipping Line Feedback
- WH33.5 Additional Shipment Information
- WH34.1 Component Bins
- WH34.2 Component Lots
- WH34.3 Component Serials
- WH34.4 Component UOMs
- WH39.1 Shipment Container Id
- WH40.1 Bill of Lading
- WH40.2 Bill of Lading Feedback
- WH520 Batch Feedback Interface
- WH830 Shipment Load Program