Tables Used by Forecast Management

The tables that are used by JD Edwards EnterpriseOne Forecast Management must identify data and processing information to support the forecasting process:

Table	Description
Business Unit Master (F0006)	Identifies branch, plant, warehouse, or business unit information, such as company, description, and assigned category codes.
Address Book Master (F0101)	Stores all of the address information pertaining to customers, vendors, employees, prospects, and others.
Forecast Summary File (F3400)	Contains the summary forecasts that are generated by the system and the summarized sales order history that is created by the Refresh Actuals program (R3465).
Forecast Summary Work File (F34006)	Connects the summary records from the Forecast Summary File table (F3400) to the detail records in the Forecast File table (F3460).
Forecast Prices (F34007)	Stores price information for item, branch, customer, and forecast type combinations.
Forecast File (F3460)	Contains the detail forecasts that are generated by the system and the sales order history that is created by the Refresh Actuals program (R3465).
Category Code Key Position File (F4091)	Stores the summary constants that you set up for each product hierarchy.
Item Master (F4101)	Stores basic information about each defined inventory item, such as item number, description, category codes, and unit of measure.
Item Branch File (F4102)	Defines and maintains warehouse or plant level information, such as costs, quantities, physical locations, and branch level category codes.
Sales Order Detail File (F4211)	Provides sales order demand by the requested date. The system uses this table to update the Sales Order History File table (F42119) for forecast calculations.
Sales Order History File (F42119)	Contains past sales data, which provide the basis for the forecast calculations.