|
|
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.
REFERENCED BY
WO220 WO82.1
UPDATED BY
DR100 IC143 WO10.1 WO120 WO20.1 WO510
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WDF-COMPANY Numeric 4 DR100 IC143
Company This field contains the company number, WO10.1 WO510
as defined in the Inventory Control
system.
WDF-LOCATION Alpha 5 DR100 IC143
Location This field contains a valid stock WO10.1 WO510
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
Expected Delivery This field contains the expected date WO10.1 WO510
Date needed for the finished good.
WDF-ITEM Alpha 32 DR100 IC143
Item This field contains the item identifier WO10.1 WO510
for the finished good, as defined in the
Inventory Control system.
WDF-QUANTITY Signed 13.4 DR100 IC143
Quantity This field contains the forecasted WO10.1 WO510
quantity of the finished good needed.
WDF-STATUS Numeric 1 DR100 IC143
Status This is the status of the forecast WO10.1 WO20.1
demand record, which indicates that it WO510
is ready to use for the production
scheduling process (if released).
1 = Unreleased
2 = Released
3 = In Scheduling
WDF-OBJ-ID-DMND Numeric 12 WO20.1
Object ID Demand 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 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 WO10.1 WO220
EXP-DELIV-DT delivery date and finished good. WO510
ITEM
WDFSET2 COMPANY This index is used to access Work Order WO10.1
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 WO20.1
SEQ forecast demand records for a demand
object ID and a sequencing for that
object ID.
KeyChange, Duplicates, Subset
Where (OBJ-ID-DMND != Zeroes )
WDFSET4 COMPANY This index is used to access Work Order WO120 WO20.1
LOCATION forecast demand records for a specific WO220 WO82.1
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
Iclocation ICLOCATION Required
WDF-COMPANY -> ICL-COMPANY
WDF-LOCATION -> ICL-LOCATION
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
WDF-ITEM -> ITE-ITEM
Woschedule WOSCHEDULE Not Required
WDF-OBJ-ID-DMND -> WOS-OBJ-ID-DMND
|