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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
WDF-COMPANY PKCOMPANY | Numeric 4 | This field contains the company number, as defined in the Inventory Control system. | DR100, IC143 |
WDF-LOCATION PKLOCATION | Alpha 5 | This 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 PKEXP_DELIV_DT | Numeric 8 (yyyymmdd) | This field contains the expected date needed for the finished good. | DR100, IC143 |
WDF-ITEM PKITEM | Alpha 32 | This field contains the item identifier for the finished good, as defined in the Inventory Control system. | DR100, IC143 |
WDF-QUANTITYQUANTITY | Signed 13.4 | This field contains the forecasted quantity of the finished good needed. | DR100, IC143 |
WDF-STATUSSTATUS | Numeric 1 | This is the status of the forecast demand record, which indicates that it is ready to use for the production scheduling process (if released).
| DR100, IC143 |
WDF-OBJ-ID-DMNDOBJ_ID_DMND | Numeric 12 | The 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-SEQSEQ | Numeric 3 | This 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
WDFSET1 | COMPANY, LOCATION, EXP-DELIV-DT, ITEM | Primary | DR100, IC143 | |
WDFSET2 | COMPANY, LOCATION, ITEM, EXP-DELIV-DT | KeyChange | — | |
WDFSET3 | OBJ-ID-DMND, SEQ | KeyChange, Subset | Where (OBJ-ID-DMND != Zeroes) | — |
WDFSET4 | COMPANY, LOCATION, ITEM, EXP-DELIV-DT | KeyChange, Subset | Where (STATUS = 2) And (OBJ-ID-DMND = Zeroes) | IC62.1 |
Relations
One to one (3) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Iccompany | ICCOMPANY | Required | WDF-COMPANY → ICC-COMPANY | |
| Iclocation | ICLOCATION | Required | WDF-COMPANY → ICL-COMPANY, WDF-LOCATION → ICL-LOCATION | |
| Itemmast | ITEMMAST | Required | ICC-ITEM-GROUP → ITE-ITEM-GROUP, WDF-ITEM → ITE-ITEM |
Programs
Updated by (2)
Referenced by (1)
- IC62.1 Finished Goods