ICFORECAST FILE
Inventory Forecast
The Inventory Forecast file stores the forecasted demand of an item at a
location. This demand is in units and/or amounts by year and period. These
valid forecast numbers can be attached to the Item Location records using
IC12.1 (Item Location).
REFERENCED BY
DR100 IC12.1 IC120 IC219 IC239 IC330
UPDATED BY
IC19.1 IC300 IC519 IC589
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IFO-COMPANY Numeric 4 IC19.1 IC519
Company The company number represents an IC589
established company and is entered on
all function codes.
IFO-LOCATION Alpha 5 IC19.1 IC519
Location Code This field contains a valid stocking IC589
location within the company inventory.
IFO-ITEM Alpha 32 IC19.1 IC519
Item Number This field contains the item IC589
identifier.
IFO-FORECAST-YEAR Numeric 4 IC19.1 IC519
Forecast Year This field contains the inventory year IC589
of the forecast.
IFO-FORECAST-NBR Numeric 4 IC19.1 IC519
Forecast Number This field contains the number assigned IC589
to a forecast for an item. An item can
have multiple forecasts at the same
location.
IFO-QUARTER Numeric 1 IC19.1 IC519
Quarter This field is used if weekly periods IC589
are defined in IC01.2 (Dates). Enter
weekly period forecasts by the quarter.
First quarter (1-13).
Second quarter (14-26)
Third quarter (27-39).
Fourth quarter (40-52).*
*Leap year only fourth quarter (40-53).
During leap year only, you can set up
14 weekly periods in the fourth quarter.
0 = For Monthly Companies
1 = 1st Quarter
2 = 2nd Quarter
3 = 3rd Quarter
4 = 4th Quarter
IFO-FORECAST-QTY Numeric 9 Occurs 14 Times IC19.1 IC519
Forecast Quantity This field contains the forecast IC589
quantity.
IFO-FORECAST-AMT Numeric 13 Occurs 14 Times IC19.1 IC519
Forecast Amount This field contains the forecast amount. IC589
ICFORECAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IFOSET1 COMPANY DR100 IC12.1
LOCATION IC120 IC19.1
ITEM IC219 IC239
FORECAST-YEAR IC300 IC330
FORECAST-NBR IC519 IC589
QUARTER
ICFORECAST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company ICCOMPANY Required
IFO-COMPANY -> ICC-COMPANY
Ichistory ICHISTORY Required
IFO-COMPANY -> ICH-COMPANY
IFO-LOCATION -> ICH-LOCATION
IFO-ITEM -> ICH-ITEM
IFO-FORECAST-YEAR -> ICH-YEAR
IFO-QUARTER -> ICH-QUARTER
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
IFO-ITEM -> ITE-ITEM
Location ICLOCATION Required
IFO-COMPANY -> ICL-COMPANY
IFO-LOCATION -> ICL-LOCATION
|
