WHDEMNDDTL – Demand Detail

System
Warehouse (WH)
Prefix
WDD
Primary key
COMPANY, LOCATION, SYSTEM-CD, DOC-NBR, LINE-NBR, COMPONENT-SEQ, BIN, LOT, SUBLOT, SERIAL, UOM
Fields
17
Updated by
40 programs
Referenced by
2 programs

WHDEMNDDTL is the Demand Detail table in Lawson Warehouse (prefix WDD). It is indexed by COMPANY, LOCATION, SYSTEM-CD, DOC-NBR, LINE-NBR, COMPONENT-SEQ, BIN, LOT, SUBLOT, SERIAL, UOM (WDDSET1). It is related 1:1 to ICCOMPANY, ICLOCATION, ITEMLOC, SOHDETAIL and WHDEMAND. It is updated by RQD0.1, WH130, WH132, WH190, WH20.3, WH20.4, WH20.5, WH20.6 and 32 more and referenced by CX100 and WH210. The table has 17 fields, 1 index and 5 documented relations.

About WHDEMNDDTL

The Demand Detail file contains details (bin, lot, serial number, and multiple unit of measure) assigned to the document line.

Fields (17)

Column = COBOL field name without the WDD- 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
#WDD-COMPANY PK
COMPANY		Numeric 4This field contains the company number.WH20.3, WH20.4, WH20.5, WH20.6, WHD3.1
#WDD-SYSTEM-CD PK
SYSTEM_CD		Alpha 2This field indicates on which Lawson system the document originated.
  • OE Customer Order
  • RQ Requisitions
  • CX Case Cart
WH20.3, WH20.4, WH20.5, WH20.6, WHD3.1
#WDD-DOC-NBR PK
DOC_NBR		Alpha 10 (Right Justified)This field contains the document number for the document line requiring details.WH20.3, WH20.4, WH20.5, WH20.6, WHD3.1
#WDD-DOC-NBR-NUM
DOC_NBR_NUM		Numeric 10This field contains the numeric value of the document number.WHD3.1
#WDD-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the document line number.WH20.3, WH20.4, WH20.5, WH20.6, WHD3.1
#WDD-COMPONENT-SEQ PK
COMPONENT_SEQ		Numeric 3This field contains the component sequence number for kit component items on the document line.WH20.3, WH20.4, WH20.5, WH20.6, WHD3.1
#WDD-BIN PK
BIN		Alpha 7This field contains the bin assigned to the document line.WH20.3, WH20.4, WH20.5, WH20.6, WHD3.1
#WDD-LOT PK
LOT		Alpha 10This field contains the lot assigned to the document line.WH20.3, WH20.4, WH20.5, WH20.6
#WDD-SUBLOT PK
SUBLOT		Alpha 6This field contains the sublot assigned to the document line.WH20.3, WH20.4, WH20.5, WH20.6, WHD3.1
#WDD-SERIAL PK
SERIAL		Alpha 16This field contains the serial number assigned to the document line.WH20.3, WH20.4, WH20.5, WHD3.1
#WDD-UOM PK
UOM		Alpha 4This field contains the unit of measure assigned to the document line.WH20.3, WH20.4, WH20.5, WH20.6, WHD3.1
#WDD-LOCATION PK
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.WH20.3, WH20.4, WH20.5, WH20.6, WHD3.1
#WDD-UOM-MULT
UOM_MULT		Signed 13.7This field contains the multiplier for converting this unit of measure to the stock unit of measure.WH20.3, WH20.4, WH20.5, WH20.6, WHD3.1
#WDD-QUANTITY
QUANTITY		Signed 13.4This field contains the requested document line quantity.WH20.3, WH20.4, WH20.5, WH20.6, WHD3.1
#WDD-CATCH-WT-QTY
CATCH_WT_QTY		Signed 13.4This field contains the catch weight quantity in secondary unit of measure.WHD3.1
#WDD-UPDATE-DATE
UPDATE_DATE		Numeric 8 (yyyymmdd)This field contains the date the record was updated.WHD3.1
#WDD-UPDATE-TIME
UPDATE_TIME		Numeric 6This field contains the system time when the record was updated.WHD3.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.

IndexKeysFlagsConditionUsed in
WDDSET1
  1. COMPANY
  2. LOCATION
  3. SYSTEM-CD
  4. DOC-NBR
  5. LINE-NBR
  6. COMPONENT-SEQ
  7. BIN
  8. LOT
  9. SUBLOT
  10. SERIAL
  11. UOM
PrimaryCX100, RQD0.1, WH130, WH132, WH190, WH20.3, WH20.4, WH20.5 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ICCOMPANYICLOCATIONITEMLOCSOHDETAILWHDEMANDWHDEMNDDTL

One to one (5) — lookups and parents

RelationTableRulesConditionField map
IccompanyICCOMPANYRequired
WDD-COMPANY→ICC-COMPANY
IclocationICLOCATIONRequired
WDD-COMPANY→ICL-COMPANY
WDD-LOCATION→ICL-LOCATION
ItemlocITEMLOCRequired
WDD-COMPANY→ITL-COMPANY
WDD-LOCATION→ITL-LOCATION
WDM-ITEM→ITL-ITEM
SohdetailSOHDETAILRequired
WDD-COMPANY→SDT-COMPANY
WDD-LOCATION→SDT-LOCATION
WDM-ITEM→SDT-ITEM
WDD-UOM→SDT-UOM
WDD-LOT→SDT-LOT
WDD-SUBLOT→SDT-SUBLOT
WDD-BIN→SDT-BIN
WhdemandWHDEMANDRequired
WDD-COMPANY→WDM-COMPANY
WDD-SYSTEM-CD→WDM-SYSTEM-CD
WDD-DOC-NBR→WDM-DOC-NBR
WDD-LINE-NBR→WDM-LINE-NBR
WDD-COMPONENT-SEQ→WDM-COMPONENT-SEQ
WDD-LOCATION→WDM-LOCATION

Programs

Updated by (40)

Referenced by (2)