WHDEMNDHDR – Demand Header

System
Warehouse (WH)
Prefix
WDH
Primary key
COMPANY, SYSTEM-CD, DOC-NBR
Fields
50
Updated by
243 programs
Referenced by
7 programs

WHDEMNDHDR is the Demand Header table in Lawson Warehouse (prefix WDH). It is indexed by COMPANY, SYSTEM-CD, DOC-NBR (WDHSET1); alternate indexes: WDHSET3. It is related 1:1 to CUSTORDER, REQHEADER and RETURNHDR and 1:M to CXCASEHEAD and WHDEMAND. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 235 more and referenced by IC45.1, WH140, WH220, WH224, WH225, WH226 and WH80.1. The table has 50 fields, 2 indexes and 5 documented relations.

About WHDEMNDHDR

The Demand Header file contains document header records.

Fields (50)

Column = COBOL field name without the WDH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
WDH-COMPANY PK
COMPANY
Numeric 4This field contains the company number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-SYSTEM-CD PK
SYSTEM_CD
Alpha 2This field indicates from which Lawson system the document originated.
  • OE Customer Order
  • RQ Requisitions
  • CX Case Cart
  • WO Work Order
  • PH Pharmacy
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-DOC-NBR PK
DOC_NBR
Alpha 10 (Right Justified)This field contains the document number for this document header.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-DOC-NBR-NUM
DOC_NBR_NUM
Numeric 10This field contains the numeric value of the document number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-SHIP-COMP-FL
SHIP_COMP_FL
Alpha 1This field indicates whether or not the customer requires complete shipments.
  • Y Ship Complete Only
  • N Partial Shipment Allowed
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-SHIP-COMP-FAIL
SHIP_COMP_FAIL
Alpha 1This field indicates whether or not the document is ready for ship complete.
  • Y Not Ready for Ship Complete
  • N Ready for Ship Complete
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-HOLD-FL
HOLD_FL
Alpha 1This field indicates whether or not the document is on hold.
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-PROCESS-TYPE
PROCESS_TYPE
Alpha 2This field contains the process type assigned to this document.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-PICKING-REQ
PICKING_REQ
Alpha 1This field indicates whether or not the process type assigned to the document requires picking feedback.
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-PACKING-REQ
PACKING_REQ
Alpha 1This field indicates whether or not the process type assigned to the document requires packing feedback.
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-FREIGHT-REQ
FREIGHT_REQ
Alpha 1This field indicates whether or not freight charges need to be captured at shipping feedback time. The value comes from the Lawson Order Entry system.
  • N Not Allowed
  • O Optional
  • R Required
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-FREIGHT-CODE
FREIGHT_CODE
Alpha 2This field contains the freight code. This must be valid in the Order Entry Freight Code file. This determines whether carrier and charge are allowed for the shipment.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-METHOD
METHOD
Alpha 10This field contains the shipping method which defines how documents are to be shipped.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-TRANS-ID
TRANS_ID
Alpha 20This field contains the transportation identification, which prints on the invoice and Bill of Lading.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-CURRENCY-CODE
CURRENCY_CODE
Alpha 5This field contains the company's base currency code defined in the Lawson General Ledger system.
WDH-CURR-ND
CURR_ND
Numeric 1This field represents the number of decimals defined for the currency of the document.
WDH-COD-FL
COD_FL
Alpha 1This field indicates whether or not the document is defined as Cash On Delivery.
WDH-CUSTOMER
CUSTOMER
Alpha 9 (Right Justified)This field contains the number that represents a customer.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-DESTINATION
DESTINATION
Alpha 15This field contains the destination for the document.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-DEST-NAME
DEST_NAME
Alpha 30 (Lower Case)This field contains the destination name for the document.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-DEST-ADDR1
DEST_ADDR1
Alpha 30 (Lower Case)This field contains the first line of the destination address.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-DEST-ADDR2
DEST_ADDR2
Alpha 30 (Lower Case)This field contains the second line of the destination address.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-DEST-ADDR3
DEST_ADDR3
Alpha 30 (Lower Case)This field contains the third line of the destination address.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-DEST-ADDR4
DEST_ADDR4
Alpha 30 (Lower Case)This field contains the fourth line of the destination address.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-DEST-CITY
DEST_CITY
Alpha 18This field contains the city of the destination.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-DEST-STATE
DEST_STATE
Alpha 2This field contains the state of the destination.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-DEST-ZIP
DEST_ZIP
Alpha 10This field contains the ZIP code of the destination.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-DEST-CNTRY
DEST_CNTRY
Alpha 30 (Lower Case)This field contains the Country of the destination.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-DEST-COUNTY
DEST_COUNTY
Alpha 25 (Lower Case)This field contains the County of the destination.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-BILL-NAME
BILL_NAME
Alpha 30 (Lower Case)This field contains the name of the company being billed.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-BILL-ADDR1
BILL_ADDR1
Alpha 30 (Lower Case)This field contains the first line of the billing address.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-BILL-ADDR2
BILL_ADDR2
Alpha 30 (Lower Case)This field contains the second line of the billing address.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-BILL-ADDR3
BILL_ADDR3
Alpha 30 (Lower Case)This field contains the third line of the billing address.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-BILL-ADDR4
BILL_ADDR4
Alpha 30 (Lower Case)This field contains the fourth line of the billing address.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-BILL-CITY
BILL_CITY
Alpha 18This field contains the billing city.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-BILL-STATE
BILL_STATE
Alpha 2This field contains the billing state.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-BILL-ZIP
BILL_ZIP
Alpha 10This field contains the billing ZIP code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-BILL-CNTRY
BILL_CNTRY
Alpha 30 (Lower Case)This field contains the billing Country.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-BILL-COUNTY
BILL_COUNTY
Alpha 25 (Lower Case)This field contains the billing County.
WDH-INTRAN-DOC-CTR
INTRAN_DOC_CTR
Numeric 3This field contains the intransit document counter, which the system uses to keep track of partial demands.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WDH-ORIGIN
ORIGIN
DerivedThis field indicates the Lawson system from which the document originated.
WDH-RQST-SHIP-DT
RQST_SHIP_DT
DerivedThis field contains the customer requested ship date for the document header.
WDH-DEST-CTRY-CD
DEST_CTRY_CD
Alpha 2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-DEST-REGION
DEST_REGION
Alpha 2The region of the country to which the goods were shipped, if required. Must be a valid region in IN02.1 (Region Maintenance)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-DEST-EC-CTRY
DEST_EC_CTRY
Numeric 3AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-DEST-ISO-CTRY
DEST_ISO_CTRY
Numeric 3AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-BILL-CTRY-CD
BILL_CTRY_CD
Alpha 2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-BILL-REGION
BILL_REGION
Alpha 2The Bill-To region code. Must be a valid region for the country, defined in IN02.1 (Region Maintenance).
WDH-BILL-EC-CTRY
BILL_EC_CTRY
Numeric 3AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
WDH-BILL-ISO-CTRY
BILL_ISO_CTRY
Numeric 3AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (2)

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

IndexKeysFlagsConditionUsed in
WDHSET1COMPANY, SYSTEM-CD, DOC-NBRPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
WDHSET3COMPANY, SYSTEM-CD, DOC-NBR-NUMSubsetWhere DOC-NBR-NUM != ZeroesWH20.7

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CustorderCUSTORDERRequiredWhen WDH-SYSTEM-CD = "OE"WDH-COMPANYCOR-COMPANY, WDH-DOC-NBR-NUMCOR-ORDER-NBR
RequistionREQHEADERRequiredWhen WDH-SYSTEM-CD = "RQ"WDH-COMPANYRQH-COMPANY, WDH-DOC-NBR-NUMRQH-REQ-NUMBER
ReturnRETURNHDRRequiredWhen WDH-SYSTEM-CD = "RT"WDH-COMPANYRTN-COMPANY, WDH-DOC-NBR-NUMRTN-AUTH-NO

One to many (2) — child tables

RelationTableRulesConditionField map
CaseheaderCXCASEHEADValid When WDH-SYSTEM-CD = "CX"WDH-COMPANYCXH-COMPANY, WDH-DOC-NBRCXH-CASE, CXH-REQ-LOCATION
WhdemandWHDEMANDWDH-COMPANYWDM-COMPANY, WDH-SYSTEM-CDWDM-SYSTEM-CD, WDH-DOC-NBRWDM-DOC-NBR, WDM-LINE-NBR, WDM-COMPONENT-SEQ, WDM-LOCATION

Programs

Updated by (243)

Referenced by (7)