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 |
IC19.1 | IC300 | 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. |
|
||||
IFO-LOCATION Element: Location | Alpha 5 This field contains a valid stocking location within the company inventory. |
|
||||
IFO-ITEM Element: Item | Alpha 32 This field contains the item identifier. |
|
||||
IFO-FORECAST-YEAR Element: Forecast Year | Numeric 4 This field contains the inventory year of the forecast. |
|
||||
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. |
|
||||
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 |
|
||||
IFO-FORECAST-QTY Element: Forecast Qty | Numeric 9 Occurs 14 Times This field contains the forecast quantity. |
|
||||
IFO-FORECAST-AMT Element: Forecast Amt | Numeric 13 Occurs 14 Times This field contains the forecast amount. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
IFOSET1 |
COMPANY LOCATION ITEM FORECAST-YEAR FORECAST-NBR QUARTER |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Company | ICCOMPANY |
Required
| |||||||||||||||
Ichistory | ICHISTORY |
Required
| |||||||||||||||
Itemmast | ITEMMAST |
Required
| |||||||||||||||
Location | ICLOCATION |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.