ICFORECAST

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IFOSET1 COMPANY
LOCATION
ITEM
FORECAST-YEAR
FORECAST-NBR
QUARTER
DR100 IC12.1
IC120 IC19.1
IC219 IC239
IC300 IC330
IC519 IC589


ICFORECAST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:16:55 2016

Home
Contact Us



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