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.

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

IndexKeysFlagsConditionUsed in
WDDSET1COMPANY, LOCATION, SYSTEM-CD, DOC-NBR, LINE-NBR, COMPONENT-SEQ, BIN, LOT, SUBLOT, SERIAL, UOMPrimaryCX100, RQD0.1, WH130, WH132, WH190, WH20.3, WH20.4, WH20.5 +22 more (list truncated in source)

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
IccompanyICCOMPANYRequiredWDD-COMPANY → ICC-COMPANY
IclocationICLOCATIONRequiredWDD-COMPANY → ICL-COMPANY, WDD-LOCATION → ICL-LOCATION
ItemlocITEMLOCRequiredWDD-COMPANY → ITL-COMPANY, WDD-LOCATION → ITL-LOCATION, WDM-ITEM → ITL-ITEM
SohdetailSOHDETAILRequiredWDD-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
WhdemandWHDEMANDRequiredWDD-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)