Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICFORECAST


                            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
Element: Company       The company number represents an          IC589
                       established company and is entered on
                       all function codes.

IFO-LOCATION           Alpha 5                                   IC19.1  IC519
Element: Location Code This field contains a valid stocking      IC589
                       location within the company inventory.

IFO-ITEM               Alpha 32                                  IC19.1  IC519
Element: Item Number   This field contains the item              IC589
                       identifier.

IFO-FORECAST-YEAR      Numeric 4                                 IC19.1  IC519
Element: Last Closed YeThis field contains the inventory year    IC589
                       of the forecast.

IFO-FORECAST-NBR       Numeric 4                                 IC19.1  IC519
Element: Number of ItemThis 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
Element: 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
Element: Forecast QuantThis field contains the forecast          IC589
                       quantity.

IFO-FORECAST-AMT       Numeric 13 Occurs 14 Times                IC19.1  IC519
Element: Forecast AmounThis 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