|
|
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 IC62.1 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
Element: Company This field contains the company number, WO10.1 WO510
as defined in the Inventory Control
system.
WDF-LOCATION Alpha 5 DR100 IC143
Element: Location Code 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
Element: Date This field contains the expected date WO10.1 WO510
needed for the finished good.
WDF-ITEM Alpha 32 DR100 IC143
Element: Item Number 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
Element: Quantity This field contains the forecasted WO10.1 WO510
quantity of the finished good needed.
WDF-STATUS Numeric 1 DR100 IC143
Element: 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 The demand object ID is the identifier
Identification 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
Element: Sequence NumbeThis 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, Subset
Where (OBJ-ID-DMND != Zeroes )
WDFSET4 COMPANY This index is used to access Work Order IC62.1 WO120
LOCATION forecast demand records for a specific WO20.1 WO220
ITEM finished good that should be selected WO82.1
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
|
