WHSHLDTL – Shipment Line Detail
- System
- Warehouse (WH)
- Prefix
WHD- Primary key
COMPANY,LOCATION,SHIPMENT-NBR,LINE-NBR,COMPONENT-SEQ,BIN,LOT,SUBLOT,UOM,SERIAL- Fields
- 24
- Updated by
- 48 programs
- Referenced by
- 3 programs
WHSHLDTL is the Shipment Line Detail table in Lawson Warehouse (prefix WHD). It is indexed by COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBR, COMPONENT-SEQ, BIN, LOT, SUBLOT, UOM, SERIAL (WHDSET1); alternate indexes: WHDSET2. It is related 1:1 to ICCOMPANY, ICLOCATION, ITEMLOC, ITEMMAST, WHSHIPCOMP, WHSHIPLINE, WHSHIPMENT and SOHDETAIL and 1:M to ITCOMMENT and SOHDETAIL. It is updated by CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 and 40 more and referenced by WH126, WH131 and WH224. The table has 24 fields, 2 indexes and 11 documented relations.
About WHSHLDTL
The Shipment Line Detail file holds records of shipment line items that are tracked by bin, lot, serial number, or multiple unit of measure.
Fields (24)
Column = COBOL field name without the WHD- 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 |
|---|---|---|---|
#WHD-COMPANY PKCOMPANY | Numeric 4 | This field contains the company number. | WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more |
#WHD-SYSTEM-CDSYSTEM_CD | Alpha 2 | This field indicates on which Lawson system the document originated.
| WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more |
#WHD-DOC-NBRDOC_NBR | Alpha 10 (Right Justified) | This field contains the document number of the shipment line that contains details. | WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more |
#WHD-LOCATION PKLOCATION | Alpha 5 | This field contains a valid stock location within the company inventory. | WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more |
#WHD-SHIPMENT-NBR PKSHIPMENT_NBR | Numeric 10 | This field contains the shipment number. One document can have several shipment numbers if the items were not shipped at the same time. | WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more |
#WHD-LINE-NBR PKLINE_NBR | Numeric 6 | This field contains the shipment line number. | WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more |
#WHD-COMPONENT-SEQ PKCOMPONENT_SEQ | Numeric 3 | This field contains the component sequence number of the component item that contains details. | WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more |
#WHD-BIN PKBIN | Alpha 7 | This field contains the bin assigned to the shipment line. | WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more |
#WHD-LOT PKLOT | Alpha 10 | This field contains the lot assigned to the shipment line. | WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more |
#WHD-SUBLOT PKSUBLOT | Alpha 6 | This field contains the sublot assigned to the shipment line. | WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more |
#WHD-SERIAL PKSERIAL | Alpha 16 | This field contains the serial number assigned to the shipment line. | WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more |
#WHD-UOM PKUOM | Alpha 4 | This field contains the unit of measure assigned to the shipment line. | WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more |
#WHD-UOM-MULTUOM_MULT | Signed 13.7 | This field contains the multiplier for converting this unit of measure to the stock unit of measure. | WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more |
#WHD-QUANTITYQUANTITY | Signed 13.4 | This field contains the requested shipment line quantity. | WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more |
#WHD-CATCH-WT-QTYCATCH_WT_QTY | Signed 13.4 | This field contains the catch weight quantity in stock unit of measure. | WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +27 more |
#WHD-UPDATE-DATEUPDATE_DATE | Numeric 8 (yyyymmdd) | This field contains the date the record was updated. | WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more |
#WHD-UPDATE-TIMEUPDATE_TIME | Numeric 6 | This field contains the system time when the record was updated. | WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more |
#WHD-LOT-STRINGLOT_STRING | Derived | This field contains the string that represents the lot/sublot or serial number (they are mutually exclusive). | — |
#WHD-BIN-STRINGBIN_STRING | Derived | This field contains the bin/serial string for printing pick lists. | — |
#WHD-SERIAL-STRINGSERIAL_STRING | Derived | This field contains the string field that represents the serial number. | — |
#WHD-UOM-STRINGUOM_STRING | Derived | This field contains the string representing the unit of measure. | — |
#WHD-PRINT-STRINGPRINT_STRING | Derived | This field indicates the lot, bin, serial number, or unit of measure to print on the pick list. | — |
#WHD-ITEM-XITEM_X | Derived | This field indicates either the shipment line or the component line item. | — |
#WHD-ITEM-XGITEM_XG | Derived | This field is used to help display the shipment line or component line item. | — |
Indexes (2)
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 |
|---|---|---|---|---|
WHDSET1 |
| Primary | CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +22 more (list truncated in source) | |
WHDSET2 |
| KeyChange | WH130, WH30.4, WH31.4, WH32.4, WH33.7, WHD3.1 |
Relations
One to one (9) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Iccompany | ICCOMPANY | Required |
| ||||||||||||||||||||||
| Iclocation | ICLOCATION | Not Required |
| ||||||||||||||||||||||
| Itemloc | ITEMLOC | Required |
| ||||||||||||||||||||||
| Itemmast | ITEMMAST | Required |
| ||||||||||||||||||||||
| Itemmast X | ITEMMAST | Not Required |
| ||||||||||||||||||||||
| Shipcomp | WHSHIPCOMP | Required | When WHD-COMPONENT-SEQ > Zeroes |
| |||||||||||||||||||||
| Shipline | WHSHIPLINE | Required |
| ||||||||||||||||||||||
| Shipment | WHSHIPMENT | Required |
| ||||||||||||||||||||||
| Sohdetail | SOHDETAIL | Required | When ITL-BIN-TRACK-FL = "Y" |
|
One to many (2) — child tables
Programs
Updated by (48)
- 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.1 Bins
- WH33.2 Lots
- WH33.3 Serials
- WH33.4 UOMs
- WH33.5 Additional Shipment Information
- WH33.6 Catch Weight
- WH33.7 Merge Shipments
- WH33.8 Preassembled Kits
- WH33.9 Line Options
- WH34.1 Component Bins
- WH34.2 Component Lots
- WH34.3 Component Serials
- WH34.4 Component UOMs
- WH34.5 Catch Weight
- WH40.1 Bill of Lading
- WH40.2 Bill of Lading Feedback
- WH520 Batch Feedback Interface
- WH830 Shipment Load Program
- WHD0.1 WH Orphan Record Check
- WHD2.1 WH-IC Integrity Check
- WHD3.1 WH-IC Detail Integrity Check