WODMNDFCST FILE
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WDF-COMPANY Numeric 4 DR100 IC143
Company This field contains the company number,
as defined in the Inventory Control
system.
WDF-LOCATION Alpha 5 DR100 IC143
Location Code This field contains a valid stock
location within the company inventory.
It is also the production facility
where finished goods are produced.
WDF-EXP-DELIV-DT Numeric 8 (yyyymmdd) DR100 IC143
Exp Deliv Dt This field contains the expected date
needed for the finished good.
WDF-ITEM Alpha 32 DR100 IC143
Item Number This field contains the item identifier
for the finished good, as defined in the
Inventory Control system.
WDF-QUANTITY Signed 13.4 DR100 IC143
Quantity This field contains the forecasted
quantity of the finished good needed.
WDF-STATUS Numeric 1 DR100 IC143
Status 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
WDF-OBJ-ID-DMND Numeric 12
Obj Id Dmnd 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 Numeric 3
Sequence Number 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 This index is used to access Work Order DR100 IC143
LOCATION forecast demand records for a specific
EXP-DELIV-DT delivery date and finished good.
ITEM
WDFSET2 COMPANY This index is used to access Work Order
LOCATION forecast demand records for a specific
ITEM finished good and delivery date.
EXP-DELIV-DT KeyChange
WDFSET3 OBJ-ID-DMND This index is used to access Work Order
SEQ forecast demand records for a demand
object ID and a sequencing for that
object ID.
KeyChange, Subset
Where (OBJ-ID-DMND != Zeroes )
WDFSET4 COMPANY This index is used to access Work Order
LOCATION forecast demand records for a specific
ITEM finished good that should be selected
EXP-DELIV-DT for production scheduling and delivery
date for a production location.
KeyChange, Subset
Where (STATUS = 2 )
And (OBJ-ID-DMND = Zeroes )
WODMNDFCST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
WDF-COMPANY -> ICC-COMPANY (ICCSET1)
Iclocation ICLOCATION Required
WDF-COMPANY -> ICL-COMPANY
WDF-LOCATION -> ICL-LOCATION
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
WDF-ITEM -> ITE-ITEM
|
