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

IC120

UPDATED BY

DR100	IC12.1	IC19.1	IC219	IC239	IC300
IC330	IC519	IC589

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
IFO-COMPANY Element: Company	Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	IC19.1 IC519 IC589
IFO-LOCATION Element: Location	Alpha 5 This field contains a valid stocking location within the company inventory.	IC19.1 IC519 IC589
IFO-ITEM Element: Item	Alpha 32 This field contains the item identifier.	IC19.1 IC519 IC589
IFO-FORECAST-YEAR Element: Forecast Year	Numeric 4 This field contains the inventory year of the forecast.	IC19.1 IC519 IC589
IFO-FORECAST-NBR Element: Forecast Nbr	Numeric 4 This field contains the number assigned to a forecast for an item. An item can have multiple forecasts at the same location.	IC19.1 IC519 IC589
IFO-QUARTER Element: Quarter	Numeric 1 This field is used if weekly periods 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	IC19.1 IC519 IC589
IFO-FORECAST-QTY Element: Forecast Qty	Numeric 9 Occurs 14 Times This field contains the forecast quantity.	IC19.1 IC519 IC589
IFO-FORECAST-AMT Element: Forecast Amt	Numeric 13 Occurs 14 Times This field contains the forecast amount.	IC19.1 IC519 IC589

ICFORECAST FILE INDEX

ICFORECAST FILE RELATIONS

ONE TO ONE RELATIONS

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