Requirements Planning Tables

These tables are used throughout the JD Edwards EnterpriseOne Requirements Planning system:

Table	Description
Item Master (F4101)	Contains basic information about each item that is defined in inventory, such as: Item numbers and descriptions Category codes Units of measure
Item Branch File (F4102)	Contains warehouse or plant-level information, such as: Costs Quantities Location Branch level category codes Lead times Planning fences Order policy codes
Bill of Material Master File (F3002)	Contains information at the business unit level about bills of material, such as: Costs and quantities of components. Features and options. Levels of detail for each bill.
Capacity Message File (F3311)	Contains the action messages that are generated by the RRP, RCCP, and CRP programs.
Forecast File (F3460)	Contains the forecast data that MPS uses for calculations and that RRP validates.
Routing Master File (F3003)	Stores routing information, including operation sequence, work center, run, setup, and machine time.
Work Center Resource Units (F3007)	Contains the available capacity for each work center by day, month, and year.
Work Center Master File (F30006)	Contains detail data about all defined work centers.
Capacity Resource Profile (F3303)	Contains all of the resource profiles that are used in Resource Requirements Planning.
Branch Relationships Master File (F3403)	Contains the supply and demand relationship among the branches.
MPS/MRP/DRP Message File (F3411)	Contains the action messages that are generated by MPS, MRP, or DRP.
MPS/MRP/DRP Lower Level Requirements File (F3412)	Contains the source of gross requirements that are posted to items from parent items.
MPS/MRP/DRP Summary File (F3413)	Contains the time series data for forms and reports.
Supplier Schedule Master File (F4321)	Contains most of the data that controls scheduling arrangements with the supplier. This table also contains information that is required for creating and maintaining the schedule, including: Ship lead time Schedule days Ship pattern Shipment quantity Delivery location The system uses information from the Supplier Schedule Master File table for each line item on a blanket order that you use in the supplier scheduling process.
Supplier Schedule Master File (F43211)	Contains the data that identifies predetermined split percentages between suppliers, by item.