Product Data Management Tables

JD Edwards EnterpriseOne Product Data Management uses these tables:

Table	Description
Business Unit Master table (F0006)	Stores branch, plant, warehouse, and business unit information, such as company, description, and category codes that are assigned to that entity.
Workday Calendar table (F0007)	Contains workday types for month, year, century, and shift of each branch/plant.
Address Book Master table (F0101)	Stores all address information pertaining to customers, vendors, employees, and prospects.
Work Center Master File table (F30006)	Contains labor, machine, and overhead rates for each work center.
Work Center Rates File table (F30008)	Stores work center rate information, such as simulated and frozen rates for setup, labor, and machines.
Bill of Material Master File table (F3002)	Stores information at the business unit level about bills of materials, such as component requirements, quantity per, issue type, revision level, features and options.
Routing Master File table (F3003)	Stores information about routings, including work centers, operation sequences, yield percentages, and run, setup, and machine time. The system uses this information to calculate labor, machine, and overhead costs.
Work Center Resource Units table (F3007)	Stores daily and monthly capacity information for work centers at each branch by shift.
Manufacturing Constants table (F3009)	Stores general branch/plant information, such as bill of material validation, commitment control, work hours per day and shift, and costing options.
Bill of Materials Change File table (F3011)	Stores all changes to any bill of material, including dates, ECO reasons, and effective dates.
ECO Parts List Detail table (F3013)	Lists the parts that are affected by the ECO.
Component Locator File table (F3015)	Stores the location of a component that you define within a subassembly.
Kanban Master table (F3016)	Stores the set of kanban cards that are associated with an item. Each kanban defines the supplying location, consuming location, quantity, and unit of measure. The system uses next numbers to control the kanban identification number. If the system obtains the item from an external source, the supplier's number is included.
Kanban Card Detail table (F30161)	Stores information that is related to the kanban, such as status, transaction quantity, and date updated.
Work Order Routing table (F3112)	Contains the routing steps for work order or ECO implementation.
Item Master table (F4101)	Stores basic information about each defined inventory item, such as item number, description, category codes, and units of measure.
Line Type Control Constants File table (F40205)	Stores constants for maintaining line types, such as general ledger classification, order type, and record variance.
Item Manufacturing Data table (F4101M)	Stores manufacturing data for each item, such as leadtime, document type, and issue type code.
Item Branch File table (F4102)	Stores the warehouse or plant-level information for an item, such as costs, quantities, category codes, and physical locations.
Item Location File table (F41021)	Stores all inventory locations for an item.
Item Cross Reference File table (F4104)	Stores information that enables you to relate item numbers for a specific purpose.
Work Order Master File table (F4801)	Stores the work order and rate schedule information, such as item numbers, quantities, dates, and status.
Order Routing Approval Master table (F4808)	Contains the address book numbers for the people who are responsible for approving ECOs and the order in which those people should be notified.
WO Supplemental DB User Defined table (F48092)	Stores additional information about ECOs, such as implementation costs.
Order Approval Audit table (F4818)	Contains the approval history of an ECO.