WODMNDFCST

Work Order Forecast Demand

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.
UPDATED BY
DR100 IC143 IC62.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WDF-COMPANY
Element: Company
Numeric 4
This field contains the company number, as defined in the Inventory Control system.
DR100 IC143
WDF-LOCATION
Element: Location
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
Element: Date
Numeric 8 (yyyymmdd)
This field contains the expected date needed for the finished good.
DR100 IC143
WDF-ITEM
Element: Item
Alpha 32
This field contains the item identifier for the finished good, as defined in the Inventory Control system.
DR100 IC143
WDF-QUANTITY
Element: Quantity
Signed 13.4
This field contains the forecasted quantity of the finished good needed.
DR100 IC143
WDF-STATUS
Element: Status
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).
1 = Unreleased
2 = Released
3 = In Scheduling
DR100 IC143
WDF-OBJ-ID-DMND
Element: Obj Id
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-SEQ
Element: Seq
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.


WODMNDFCST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WDFSET1 COMPANY
LOCATION
EXP-DELIV-DT
ITEM
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


WODMNDFCST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Thu Jun 09 11:30:46 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.