ICFORECAST – Inventory Forecast

System: Inventory Control (IC)
Prefix: IFO
Primary key: COMPANY, LOCATION, ITEM, FORECAST-YEAR, FORECAST-NBR, QUARTER
Fields: 8
Updated by: 4 programs
Referenced by: 6 programs

ICFORECAST is the Inventory Forecast table in Lawson Inventory Control (prefix IFO). It is indexed by COMPANY, LOCATION, ITEM, FORECAST-YEAR, FORECAST-NBR, QUARTER (IFOSET1). It is related 1:1 to ICCOMPANY, ICHISTORY, ITEMMAST and ICLOCATION. It is updated by IC19.1, IC300, IC519 and IC589 and referenced by DR100, IC12.1, IC120, IC219, IC239 and IC330. The table has 8 fields, 1 index and 4 documented relations.

About ICFORECAST

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).

Fields (8)

Column = COBOL field name without the IFO- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`IFO-COMPANY` PK 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` PK LOCATION	Alpha 5	This field contains a valid stocking location within the company inventory.	IC19.1, IC519, IC589
`IFO-ITEM` PK ITEM	Alpha 32	This field contains the item identifier.	IC19.1, IC519, IC589
`IFO-FORECAST-YEAR` PK FORECAST_YEAR	Numeric 4	This field contains the inventory year of the forecast.	IC19.1, IC519, IC589
`IFO-FORECAST-NBR` PK 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` PK 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` FORECAST_QTY	Numeric 9 Occurs 14 Times ×14	This field contains the forecast quantity.	IC19.1, IC519, IC589
`IFO-FORECAST-AMT` FORECAST_AMT	Numeric 13 Occurs 14 Times ×14	This field contains the forecast amount.	IC19.1, IC519, IC589

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`IFOSET1`	`COMPANY`, `LOCATION`, `ITEM`, `FORECAST-YEAR`, `FORECAST-NBR`, `QUARTER`	Primary		DR100, IC12.1, IC120, IC19.1, IC219, IC239, IC300, IC330 +2 more

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Field map
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`

Programs

Updated by (4)

IC19.1 Forecasts
IC300 Inventory Purge
IC519 Forecast Interface
IC589 Forecast Transfer

Referenced by (6)

DR100 Distribution Requirements Report
IC12.1 Item Location
IC120 Economic Order Quantity and Reorder Calculation
IC219 Forecast Listing
IC239 Forecast Variance
IC330 Item Mass Change