WHDEMAND – Demand

System
Warehouse (WH)
Prefix
WDM
Primary key
COMPANY, SYSTEM-CD, DOC-NBR, LINE-NBR, COMPONENT-SEQ, LOCATION
Fields
80
Updated by
255 programs
Referenced by
19 programs

WHDEMAND is the Demand table in Lawson Warehouse (prefix WDM). It is indexed by COMPANY, SYSTEM-CD, DOC-NBR, LINE-NBR, COMPONENT-SEQ, LOCATION (WDMSET1); alternate indexes: WDMSET2, WDMSET3, WDMSET4, WDMSET5, WDMSET6, WDMSET7, WDMSET8 and WDMSET9. It is related 1:1 to APCOMPANY, APVENMAST, CXCASEHEAD, CXPREFITEM, COLINE, CUSTORDER, ICCOMPANY, ICLOCATION and 8 more and 1:M to WHDEMNDDTL, ITEMLOC and SOHDETAIL. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 247 more and referenced by IC10.2, IC130, IC44.1, IC45.1, PO228, POIF.1, POIG.1, RQ140 and 11 more. The table has 80 fields, 9 indexes and 24 documented relations.

About WHDEMAND

The Demand file contains all the records that the Lawson Warehouse system needs for processing demands.

Fields (80)

Column = COBOL field name without the WDM- 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
#WDM-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)
#WDM-SYSTEM-CD PK
SYSTEM_CD		Alpha 2This field indicates from which Lawson system the document originated.
  • OE Customer Order
  • RQ Requisition
  • IC Intransit
  • PO Purchase Order
  • 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)
#WDM-DOC-NBR PK
DOC_NBR		Alpha 10 (Right Justified)This field contains the document number for the shipment line. If this record was created from a purchase order, it will be the object ID from the POLINE since the PO Number is too long for this field.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-DOC-NBR-NUM
DOC_NBR_NUM		Numeric 10This field contains the numeric version of the document number. Order Entry and Requisitions use this field. For PO, this field will be the PLI-PO-RELEASE field.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the document line number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-COMPONENT-SEQ PK
COMPONENT_SEQ		Numeric 3This field contains the component sequence number of the component item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-DOC-TYPE SET5
DOC_TYPE		Alpha 2This field contains the type of document. For warehouse purposes, this is the shipping document.
  • DT Direct Transfer
  • IR Intransit Receiving
  • IS Issue
  • IT Transfer Issue
  • SH Shipment
  • PO Purchase Order
  • WO Work Order
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-RECORD-TYPE
RECORD_TYPE		Alpha 1This field identifies the type of demand record defined. Demand records are processed in the Lawson Warehouse system and supply records are not.
  • D Demand
  • S Supply
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-ITEM SET2 SET4 SET5 SET6
ITEM		Alpha 32This field contains the item identifier.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-ITEM-DESC
ITEM_DESC		Alpha 30This field contains the description for inventoried and nonstock items.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-LOCATION PK
LOCATION		Alpha 5This field contains a valid stock location within the company inventory.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-DESTINATION
DESTINATION		Alpha 15This field contains the destination name for the shipment (ship-to customer).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-ROUTE
ROUTE		Numeric 4This field contains the route number. The route assigned to the ship-to customer defaults from the Order Entry Route file.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-STOP
STOP		Numeric 4This field contains the stop within the route. If left blank, the stop associated with the ship-to customer defaults from the Route file.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-RTE-CREATE-FL
RTE_CREATE_FL		Alpha 1This field indicates whether a route record exists for this document line.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-STATUS
STATUS		Numeric 1This field contains the demand status.
  • 0 Unreleased
  • 1 Released for Processing
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-ALLOCABLE-FL
ALLOCABLE_FL		Alpha 1This field indicates whether demand lines are ready to be allocated or not.
  • Y Allocatable
  • N Not Ready for Allocation
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-ALLOC-BASIS
ALLOC_BASIS		Alpha 1This field is used to determine if the batch allocation program should allocate demand based on requested date or the priority.WHD1.1, WHD2.1
#WDM-LINE-TYPE SET2
LINE_TYPE		Alpha 1This field contains the type of item on this demand line.
  • I Inventoried
  • N Nonstock
  • X Special
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-QUANTITY
QUANTITY		Signed 13.4This field contains the demand quantity.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-ALLOC-QTY
ALLOC_QTY		Signed 13.4This field contains the quantity that has been allocated for this demand line.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-BACKORD-QTY
BACKORD_QTY		Signed 13.4This field contains the backordered quantity that is not available in inventory for allocation.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-PRINTED-QTY
PRINTED_QTY		Signed 13.4This field contains the quantity that was printed on the pick list to be picked.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-IN-PROC-QTY
IN_PROC_QTY		Signed 13.4This field contains the in-process quantity for the demand.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-SHIPPED-QTY
SHIPPED_QTY		Signed 13.4This field contains the quantity that was shipped.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-PRE-ASMBLD-KIT
PRE_ASMBLD_KIT		Signed 13.4This field contains the quantity of make-to-order kits you want to preassemble.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-DETAIL-QTY
DETAIL_QTY		Signed 13.4This field shows the quantity of demand lines with details.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-UNIT-PRICE
UNIT_PRICE		Signed 18.5—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-UNIT-COST
UNIT_COST		Signed 18.5This field contains the unit cost for the document line.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-TRAN-UOM
TRAN_UOM		Alpha 4This field contains the unit of measure used for the document.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-TRAN-UOM-MULT
TRAN_UOM_MULT		Signed 13.7This field contains the multiplier used to convert the document unit of measure to the stock unit of measure.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-FUTURE-FL
FUTURE_FL		Alpha 1This field indicates if the document line has a future status.
  • Y Future Demand
  • N Current Demand
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-FIRM-FL
FIRM_FL		Alpha 1This field indicates whether allocation is firm or not for a document line item. If the allocation is set to Confirmed Demand, WH110 (Batch Allocation) will not let you deallocate this item later.
  • Y Confirmed Demand
  • N Open For Confirmation
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-SHIP-COMP-FL
SHIP_COMP_FL		Alpha 1This field indicates whether or not the customer requires complete shipments.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-BACK-ORD-FL
BACK_ORD_FL		Alpha 1This field indicates whether or not the customer accepts backorders.
  • Y Backorder Allowed
  • N Backorder Not Allowed
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-KIT-FL
KIT_FL		Alpha 1This field indicates the kind of kit item found on the document line.
  • O Make-to-Order Kit
  • S Make-to-Stock Kit
  • N Not a Kit
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-KIT-COMPLETE
KIT_COMPLETE		Alpha 1This field indicates whether or not all kit options have been reviewed and selected for a kit item.
  • Y All kit options are reviewed
  • N All kit options not reviewed
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-PO-FLAG
PO_FLAG		Alpha 1This field indicates whether or not the line is related to a purchase order.
  • Y Based on PO Receipt
  • N Not Related to PO
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-PICKING-REQ
PICKING_REQ		Alpha 1This field indicates whether the process type for the document requires picking feedback.
  • Y Picking is Required
  • N Picking is not Required
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-PACKING-REQ
PACKING_REQ		Alpha 1This field indicates whether or not the process type for this document requires packing feedback.
  • Y Packing is Required
  • N Packing is not Required
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-DETAIL-REQ
DETAIL_REQ		Alpha 1This field indicates whether or not details are required for the document line item.
  • Y Details are Required
  • N Details are not Required
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-ALLOC-PRI SET2
ALLOC_PRI		Numeric 2This field indicates what allocation priority you gave to a document line.
  • 00 Priority of Allocation
  • 99 Priority of Allocation
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-HOLD-FL
HOLD_FL		Alpha 1This field indicates if the document line is on hold. The source for this field is the originating Lawson system.
  • Y Document Line is on Hold
  • N Document Line is not on Hold
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-MSDS-REQ-FL
MSDS_REQ_FL		Alpha 1—
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-VENDOR
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-CARRIER
CARRIER		Alpha 9 (Right Justified)The vendor's identification code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-CUST-SHIP-TO
CUST_SHIP_TO		Numeric 4This field contains the ship-to customer number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-REQ-LOCATION
REQ_LOCATION		Alpha 5The location that is requesting items. This location can be an inventory or nonstock location.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-REQ-COMPANY
REQ_COMPANY		Numeric 4This field contains the requesting company.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-ALLOCATE-DT SET2
ALLOCATE_DT		Numeric 8 (yyyymmdd)This field contains the date that you want the document line to be allocated.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-EST-TRAN-DT SET5 SET6
EST_TRAN_DT		Numeric 8 (yyyymmdd)This field contains the expected ship date for the line. If you leave the field blank and no ship days are defined on the document's process level, the document date defaults. If ship dates exist on the process level, ship days are added to the document date to calculate the expected ship date.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-SUGGESTED-LOT
SUGGESTED_LOT		Alpha 10This field contains the suggested lot for lot-tracked items.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-SHIP-ACCT-UNIT
SHIP_ACCT_UNIT		Alpha 15This field contains a temporary general ledger shipping account unit.WHD2.1
#WDM-SHIP-ACCOUNT
SHIP_ACCOUNT		Numeric 6This field contains a temporary general ledger shipping account.WHD2.1
#WDM-SHIP-SUB-ACCT
SHIP_SUB_ACCT		Numeric 4This field contains a temporary general ledger shipping subaccount.WHD2.1
#WDM-RUSH-FL
RUSH_FL		Alpha 1The rush flag indicates if the document has a 'rush' placed on it.
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-OBJ-ID-DMND SET8
OBJ_ID_DMND		Numeric 12This field contains the demand object identifier.WHD2.1
#WDM-SEQ SET8
SEQ		Numeric 3This field is used to create a value that is associated with the demand object id in the access path that gets demand records by demand object id.WHD2.1
#WDM-FILL-OR-KILL
FILL_OR_KILL		Alpha 1—
  • F Fill Backorders
  • K Kill Backorders
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-ORIGIN
ORIGIN		DerivedThis literal helps to determine from which Lawson system a document originated.—
#WDM-DOC-ALPHA
DOC_ALPHA		DerivedThis field contains the alpha version of the document number.—
#WDM-OPEN-DEMAND
OPEN_DEMAND		DerivedThis field contains the total of the in-process quantity and the backorder quantity for a document line.—
#WDM-SRC-ITEM-DESC
SRC_ITEM_DESC		DerivedThis field contains either the item master description or the document line description of an item.—
#WDM-TRAN-QUANTITY
TRAN_QUANTITY		DerivedThis field shows the transaction quantity.—
#WDM-TRAN-ALLOCATED
TRAN_ALLOCATED		DerivedThis field shows the transaction quantity allocated.—
#WDM-TRAN-BACKORD
TRAN_BACKORD		DerivedThis field shows the amount of the transaction that is backordered.—
#WDM-TRAN-PRINTED
TRAN_PRINTED		DerivedThis field shows the transaction amount that is printed.—
#WDM-TRAN-IN-PROC
TRAN_IN_PROC		DerivedThis field shows the transaction that is currently in process.—
#WDM-TRAN-SHIPPED
TRAN_SHIPPED		DerivedThis field shows the transaction that has been shipped.—
#WDM-DISP-QUANTITY
DISP_QUANTITY		DerivedThis field shows the displayed line quantity.—
#WDM-DISP-ALLOCATED
DISP_ALLOCATED		DerivedThis field shows the displayed line quantity that is allocated.—
#WDM-DISP-BACKORD
DISP_BACKORD		DerivedThis field shows the displayed line quantity that is backordered.—
#WDM-DISP-PRINTED
DISP_PRINTED		DerivedThis field shows the displayed line quantity that is printed.—
#WDM-DISP-IN-PROC
DISP_IN_PROC		DerivedThis field shows the displayed line quantity that is currently in process.—
#WDM-DISP-SHIPPED
DISP_SHIPPED		DerivedThis field shows the displayed line quantity that has been shipped.—
#WDM-DISP-DOC-NBR
DISP_DOC_NBR		Derived——
#WDM-ENTERED-ITEM
ENTERED_ITEM		Alpha 25—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-ENTRY-FL
ENTRY_FL		Alpha 1—
  • 1 Item
  • 2 UPC
  • 3 UPN1
  • 4 UPN2
  • 5 NDC
  • 6 SKU
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-RQSRC-MACHINE
RQSRC_MACHINE		Alpha 6ESIOB DROYAL HBOC OMNICL PAREXE PERSE PYXIS SSIAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#WDM-PAR-ORDER-ID
PAR_ORDER_ID		Alpha 20—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (9)

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
WDMSET1
  1. COMPANY
  2. SYSTEM-CD
  3. DOC-NBR
  4. LINE-NBR
  5. COMPONENT-SEQ
  6. LOCATION
Primary, SubsetWhere (RECORD-TYPE = "D")AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
WDMSET2
  1. COMPANY
  2. LOCATION
  3. LINE-TYPE
  4. ITEM
  5. ALLOC-PRI
  6. DOC-NBR
  7. LINE-NBR
  8. ALLOCATE-DT
  9. SYSTEM-CD
KeyChange, SubsetWhere (RECORD-TYPE = "D") And (ALLOCABLE-FL = "Y") And (COMPONENT-SEQ = Zeroes) And (QUANTITY > PRINTED-QTY)MA531, PO21.2, PO21.4, PO21.5, PO30.1, PO30.2, PO30.3, PO30.4 +11 more
WDMSET3
  1. COMPANY
  2. LOCATION
  3. SYSTEM-CD
  4. DOC-NBR
  5. LINE-NBR
KeyChange, SubsetWhere (RECORD-TYPE = "D") And (STATUS = 1) And (COMPONENT-SEQ = Zeroes) And (ALLOC-QTY > PRINTED-QTY) And (SYSTEM-CD != "WO")WH130
WDMSET4
  1. COMPANY
  2. SYSTEM-CD
  3. DOC-NBR
  4. LINE-NBR
  5. COMPONENT-SEQ
  6. ITEM
  7. LOCATION
KeyChange, SubsetWhere (RECORD-TYPE = "D") And (LINE-TYPE = "I") And (DETAIL-REQ = "Y")—
WDMSET5
  1. COMPANY
  2. LOCATION
  3. ITEM
  4. EST-TRAN-DT
  5. DOC-TYPE
  6. SYSTEM-CD
  7. DOC-NBR
  8. LINE-NBR
  9. COMPONENT-SEQ
KeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
WDMSET6
  1. COMPANY
  2. LOCATION
  3. ITEM
  4. EST-TRAN-DT
  5. SYSTEM-CD
  6. DOC-NBR
  7. LINE-NBR
  8. COMPONENT-SEQ
KeyChange, SubsetWhere (RECORD-TYPE = "D" And ALLOCABLE-FL = "Y" And BACKORD-QTY > Zeroes And KIT-FL = "S" And STATUS = 1 And OBJ-ID-DMND = Zeroes)—
WDMSET7
  1. COMPANY
  2. LOCATION
  3. SYSTEM-CD
  4. DOC-NBR
  5. LINE-NBR
  6. COMPONENT-SEQ
KeyChange, SubsetWhere RECORD-TYPE = "S"AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
WDMSET8
  1. OBJ-ID-DMND
  2. SEQ
KeyChange, SubsetWhere (OBJ-ID-DMND > Zeroes And OBJ-ID-DMND < 999999999999)—
WDMSET9
  1. COMPANY
  2. SYSTEM-CD
  3. DOC-NBR
  4. LINE-NBR
  5. LOCATION
  6. COMPONENT-SEQ
SubsetWhere (RECORD-TYPE = "D")AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.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)
APCOMPANYAPVENMASTCXCASEHEADCXPREFITEMCOLINECUSTORDERICCOMPANYICLOCATIONITEMLOCITEMMASTPOLINEREQHEADERREQLINERETURNHDR+2 more belowWHDEMNDDTLITEMLOCSOHDETAILWHDEMAND

One to one (16) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYNot RequiredValid When WDM-RECORD-TYPE = "S" And WDM-SYSTEM-CD = "PO"
WDM-COMPANY→CPY-COMPANY
ApvenmastAPVENMASTNot RequiredValid When WDM-RECORD-TYPE = "S" And WDM-SYSTEM-CD = "PO"
CPY-VENDOR-GROUP→VEN-VENDOR-GROUP
WDM-VENDOR→VEN-VENDOR
CaseheaderCXCASEHEADRequiredWhen WDM-SYSTEM-CD = "CX"
WDM-COMPANY→CXH-COMPANY
WDM-REQ-LOCATION→CXH-REQ-LOCATION
WDM-DOC-NBR→CXH-CASE
CaselineCXPREFITEMRequiredWhen WDM-SYSTEM-CD = "CX"
WDM-COMPANY→CPI-COMPANY
WDM-REQ-LOCATION→CPI-REQ-LOCATION
WDM-DOC-NBR→CPI-CASE
WDM-LINE-NBR→CPI-IF-REF-NBR
ColineCOLINERequiredWhen WDM-SYSTEM-CD = "OE"
WDM-COMPANY→COL-COMPANY
WDM-DOC-NBR-NUM→COL-ORDER-NBR
WDM-LINE-NBR→COL-LINE-NBR
CustorderCUSTORDERRequiredWhen WDM-SYSTEM-CD = "OE"
WDM-COMPANY→COR-COMPANY
WDM-DOC-NBR-NUM→COR-ORDER-NBR
IccompanyICCOMPANYRequired
WDM-COMPANY→ICC-COMPANY
IclocationICLOCATIONRequiredWhen WDM-LINE-TYPE = "I"
WDM-COMPANY→ICL-COMPANY
WDM-LOCATION→ICL-LOCATION
ItemlocITEMLOCRequiredWhen WDM-LINE-TYPE = "I"
WDM-COMPANY→ITL-COMPANY
WDM-LOCATION→ITL-LOCATION
WDM-ITEM→ITL-ITEM
ItemmastITEMMASTRequiredWhen WDM-LINE-TYPE = "I" Or WDM-LINE-TYPE = "N"
ICC-ITEM-GROUP→ITE-ITEM-GROUP
WDM-ITEM→ITE-ITEM
PolinePOLINERequiredWhen WDM-RECORD-TYPE = "S" And WDM-SYSTEM-CD = "PO"
WDM-DOC-NBR→PLI-PO-OBJ-ID
WDM-LINE-NBR→PLI-LINE-NBR
ReqheaderREQHEADERRequiredWhen WDM-SYSTEM-CD = "RQ"
WDM-REQ-COMPANY→RQH-COMPANY
WDM-DOC-NBR-NUM→RQH-REQ-NUMBER
ReqlineREQLINERequiredWhen WDM-SYSTEM-CD = "RQ"
WDM-REQ-COMPANY→RLN-COMPANY
WDM-DOC-NBR-NUM→RLN-REQ-NUMBER
WDM-LINE-NBR→RLN-LINE-NBR
ReturnhdrRETURNHDRRequiredWhen WDM-SYSTEM-CD = "RT"
WDM-COMPANY→RTN-COMPANY
WDM-DOC-NBR-NUM→RTN-AUTH-NO
ReturnlineRETURNLINERequiredWhen WDM-SYSTEM-CD = "RT"
WDM-COMPANY→RTL-COMPANY
WDM-DOC-NBR-NUM→RTL-AUTH-NO
WDM-LINE-NBR→RTL-LINE-NBR
WhdemndhdrWHDEMNDHDRRequired
WDM-COMPANY→WDH-COMPANY
WDM-SYSTEM-CD→WDH-SYSTEM-CD
WDM-DOC-NBR→WDH-DOC-NBR

One to many (8) — child tables

RelationTableRulesConditionField map
BinsWHDEMNDDTL
WDM-COMPANY→WDD-COMPANY
WDM-LOCATION→WDD-LOCATION
WDM-SYSTEM-CD→WDD-SYSTEM-CD
WDM-DOC-NBR→WDD-DOC-NBR
WDM-LINE-NBR→WDD-LINE-NBR
WDM-COMPONENT-SEQ→WDD-COMPONENT-SEQ
—→WDD-BIN
—→WDD-LOT
—→WDD-SUBLOT
—→WDD-SERIAL
—→WDD-UOM
ItemlocsITEMLOCValid When WDM-LINE-TYPE = "I"
WDM-COMPANY→ITL-COMPANY
WDM-ITEM→ITL-ITEM
—→ITL-LOCATION
LotsWHDEMNDDTL
WDM-COMPANY→WDD-COMPANY
WDM-LOCATION→WDD-LOCATION
WDM-SYSTEM-CD→WDD-SYSTEM-CD
WDM-DOC-NBR→WDD-DOC-NBR
WDM-LINE-NBR→WDD-LINE-NBR
WDM-COMPONENT-SEQ→WDD-COMPONENT-SEQ
—→WDD-BIN
—→WDD-LOT
—→WDD-SUBLOT
—→WDD-SERIAL
—→WDD-UOM
SerialsWHDEMNDDTL
WDM-COMPANY→WDD-COMPANY
WDM-LOCATION→WDD-LOCATION
WDM-SYSTEM-CD→WDD-SYSTEM-CD
WDM-DOC-NBR→WDD-DOC-NBR
WDM-LINE-NBR→WDD-LINE-NBR
WDM-COMPONENT-SEQ→WDD-COMPONENT-SEQ
—→WDD-BIN
—→WDD-LOT
—→WDD-SUBLOT
—→WDD-SERIAL
—→WDD-UOM
SohdetailSOHDETAIL
WDM-COMPANY→SDT-COMPANY
WDM-LOCATION→SDT-LOCATION
WDM-ITEM→SDT-ITEM
—→SDT-UOM
—→SDT-LOT
—→SDT-SUBLOT
—→SDT-BIN
SublocITEMLOC
WDM-COMPANY→ITL-COMPANY
WDM-ITEM→ITL-ITEM
—→ITL-LOCATION
UomsWHDEMNDDTL
WDM-COMPANY→WDD-COMPANY
WDM-LOCATION→WDD-LOCATION
WDM-SYSTEM-CD→WDD-SYSTEM-CD
WDM-DOC-NBR→WDD-DOC-NBR
WDM-LINE-NBR→WDD-LINE-NBR
WDM-COMPONENT-SEQ→WDD-COMPONENT-SEQ
—→WDD-BIN
—→WDD-LOT
—→WDD-SUBLOT
—→WDD-SERIAL
—→WDD-UOM
WhdemnddtlWHDEMNDDTL
WDM-COMPANY→WDD-COMPANY
WDM-LOCATION→WDD-LOCATION
WDM-SYSTEM-CD→WDD-SYSTEM-CD
WDM-DOC-NBR→WDD-DOC-NBR
WDM-LINE-NBR→WDD-LINE-NBR
WDM-COMPONENT-SEQ→WDD-COMPONENT-SEQ
—→WDD-BIN
—→WDD-LOT
—→WDD-SUBLOT
—→WDD-SERIAL
—→WDD-UOM

Programs

Updated by (255)

Referenced by (19)