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.

Field / column	Type	Description & values	Updated by
`WHD-COMPANY` PK COMPANY	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-CD` SYSTEM_CD	Alpha 2	This field indicates on which Lawson system the document originated. `OE` Customer Order `RQ` Requisitions `CX` Case Cart	WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
`WHD-DOC-NBR` DOC_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` PK LOCATION	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` PK SHIPMENT_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` PK LINE_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` PK COMPONENT_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` PK BIN	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` PK LOT	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` PK SUBLOT	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` PK SERIAL	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` PK UOM	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-MULT` UOM_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-QUANTITY` QUANTITY	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-QTY` CATCH_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-DATE` UPDATE_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-TIME` UPDATE_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-STRING` LOT_STRING	Derived	This field contains the string that represents the lot/sublot or serial number (they are mutually exclusive).	—
`WHD-BIN-STRING` BIN_STRING	Derived	This field contains the bin/serial string for printing pick lists.	—
`WHD-SERIAL-STRING` SERIAL_STRING	Derived	This field contains the string field that represents the serial number.	—
`WHD-UOM-STRING` UOM_STRING	Derived	This field contains the string representing the unit of measure.	—
`WHD-PRINT-STRING` PRINT_STRING	Derived	This field indicates the lot, bin, serial number, or unit of measure to print on the pick list.	—
`WHD-ITEM-X` ITEM_X	Derived	This field indicates either the shipment line or the component line item.	—
`WHD-ITEM-XG` ITEM_XG	Derived	This field is used to help display the shipment line or component line item.	—

Indexes (2)

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

Index	Keys	Flags	Condition	Used in
`WHDSET1`	`COMPANY`, `LOCATION`, `SHIPMENT-NBR`, `LINE-NBR`, `COMPONENT-SEQ`, `BIN`, `LOT`, `SUBLOT`, `UOM`, `SERIAL`	Primary		CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +22 more (list truncated in source)
`WHDSET2`	`COMPANY`, `LOCATION`, `SHIPMENT-NBR`, `BIN`, `LOT`, `SUBLOT`, `SERIAL`, `UOM`, `LINE-NBR`, `COMPONENT-SEQ`	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		`WHD-COMPANY` → `ICC-COMPANY`
Iclocation	ICLOCATION	Not Required		`WHD-COMPANY` → `ICL-COMPANY`, `WHD-LOCATION` → `ICL-LOCATION`
Itemloc	ITEMLOC	Required		`WHD-COMPANY` → `ITL-COMPANY`, `WHD-LOCATION` → `ITL-LOCATION`, `WHD-ITEM-XG` → `ITL-ITEM`
Itemmast	ITEMMAST	Required		`ICC-ITEM-GROUP` → `ITE-ITEM-GROUP`, `WHD-ITEM-XG` → `ITE-ITEM`
Itemmast X	ITEMMAST	Not Required		`ICC-ITEM-GROUP` → `ITE-ITEM-GROUP`, `WHD-ITEM-XG` → `ITE-ITEM`
Shipcomp	WHSHIPCOMP	Required	When WHD-COMPONENT-SEQ > Zeroes	`WHD-COMPANY` → `WHC-COMPANY`, `WHD-LOCATION` → `WHC-LOCATION`, `WHD-SHIPMENT-NBR` → `WHC-SHIPMENT-NBR`, `WHD-LINE-NBR` → `WHC-LINE-NBR`, `WHD-COMPONENT-SEQ` → `WHC-COMPONENT-SEQ`
Shipline	WHSHIPLINE	Required		`WHD-COMPANY` → `WHL-COMPANY`, `WHD-LOCATION` → `WHL-LOCATION`, `WHD-SHIPMENT-NBR` → `WHL-SHIPMENT-NBR`, `WHD-LINE-NBR` → `WHL-LINE-NBR`
Shipment	WHSHIPMENT	Required		`WHD-COMPANY` → `WHS-COMPANY`, `WHD-LOCATION` → `WHS-LOCATION`, `WHD-SHIPMENT-NBR` → `WHS-SHIPMENT-NBR`
Sohdetail	SOHDETAIL	Required	When ITL-BIN-TRACK-FL = "Y"	`WHD-COMPANY` → `SDT-COMPANY`, `WHD-LOCATION` → `SDT-LOCATION`, `WHL-ITEM` → `SDT-ITEM`, `WHD-BIN` → `SDT-BIN`, `WHD-UOM` → `SDT-UOM`, `WHD-LOT` → `SDT-LOT`, `WHD-SUBLOT` → `SDT-SUBLOT`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Com Itcomment	ITCOMMENT			`ICC-ITEM-GROUP` → `ICO-ITEM-GROUP`, `WHC-ITEM` → `ICO-ITEM`, → `ICO-LANGUAGE-CODE`, → `ICO-SEQ`
Soh	SOHDETAIL			`WHD-COMPANY` → `SDT-COMPANY`, `WHD-LOCATION` → `SDT-LOCATION`, `WHL-ITEM` → `SDT-ITEM`, `WHD-UOM` → `SDT-UOM`, → `SDT-LOT`, → `SDT-SUBLOT`, → `SDT-BIN`

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

Referenced by (3)

WH126 POD Print
WH131 Bulk Pick List
WH224 Packing List Print