WODMNDFCST – Work Order Forecast Demand

System
WO (WO)
Prefix
WDF
Primary key
COMPANY, LOCATION, EXP-DELIV-DT, ITEM
Fields
8
Updated by
2 programs
Referenced by
1 program

WODMNDFCST is the Work Order Forecast Demand table in Lawson WO (prefix WDF). It is indexed by COMPANY, LOCATION, EXP-DELIV-DT, ITEM (WDFSET1); alternate indexes: WDFSET2, WDFSET3 and WDFSET4. It is related 1:1 to ICCOMPANY, ICLOCATION and ITEMMAST. It is updated by DR100 and IC143 and referenced by IC62.1. The table has 8 fields, 4 indexes and 3 documented relations.

About WODMNDFCST

The Work Order Forecast Demand file is used to allow for a source of non-document demand to be used as input into the production scheduling process for work orders.

Fields (8)

Column = COBOL field name without the WDF- 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
#WDF-COMPANY PK
COMPANY		Numeric 4This field contains the company number, as defined in the Inventory Control system.DR100, IC143
#WDF-LOCATION PK
LOCATION		Alpha 5This field contains a valid stock location within the company inventory. It is also the production facility where finished goods are produced.DR100, IC143
#WDF-EXP-DELIV-DT PK
EXP_DELIV_DT		Numeric 8 (yyyymmdd)This field contains the expected date needed for the finished good.DR100, IC143
#WDF-ITEM PK
ITEM		Alpha 32This field contains the item identifier for the finished good, as defined in the Inventory Control system.DR100, IC143
#WDF-QUANTITY
QUANTITY		Signed 13.4This field contains the forecasted quantity of the finished good needed.DR100, IC143
#WDF-STATUS
STATUS		Numeric 1This is the status of the forecast demand record, which indicates that it is ready to use for the production scheduling process (if released).
  • 1 Unreleased
  • 2 Released
  • 3 In Scheduling
DR100, IC143
#WDF-OBJ-ID-DMND SET3
OBJ_ID_DMND		Numeric 12The demand object ID is the identifier used to associate forecast demand records to schedule records based on a unique value in this field for all forecast demand records to associate with a particular schedule record.—
#WDF-SEQ SET3
SEQ		Numeric 3This field is used to create a value that is associated with the demand object ID in the access path that gets forecast demand records by demand object ID.—

Indexes (4)

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
WDFSET1
  1. COMPANY
  2. LOCATION
  3. EXP-DELIV-DT
  4. ITEM
PrimaryDR100, IC143
WDFSET2
  1. COMPANY
  2. LOCATION
  3. ITEM
  4. EXP-DELIV-DT
KeyChange—
WDFSET3
  1. OBJ-ID-DMND
  2. SEQ
KeyChange, SubsetWhere (OBJ-ID-DMND != Zeroes)—
WDFSET4
  1. COMPANY
  2. LOCATION
  3. ITEM
  4. EXP-DELIV-DT
KeyChange, SubsetWhere (STATUS = 2) And (OBJ-ID-DMND = Zeroes)IC62.1

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
IccompanyICCOMPANYRequired
WDF-COMPANY→ICC-COMPANY
IclocationICLOCATIONRequired
WDF-COMPANY→ICL-COMPANY
WDF-LOCATION→ICL-LOCATION
ItemmastITEMMASTRequired
ICC-ITEM-GROUP→ITE-ITEM-GROUP
WDF-ITEM→ITE-ITEM

Programs

Updated by (2)

Referenced by (1)