Tables Used for Product Costing and Manufacturing Accounting
This is a list of the tables that are used throughout the JD Edwards EnterpriseOne Product Costing and Manufacturing Accounting systems:
Table |
Description |
|---|---|
Account Balances (F0902) |
Contains net postings for each period and prior-year balances (net and cumulative). This table contains one record per account, ledger type, subledger, fiscal year, and transaction currency table. |
Account Ledger (F0911) |
Contains detailed transactions in the general ledger. |
Account Master (F0901) |
Contains account definitions, including numbers and descriptions. |
Address Book Master (F0101) |
Contains information about customers, suppliers, employees, and prospects. |
Distribution/Manufacturing - AAI Values (F4095) |
Contains account numbers that are used when journal entries are created. |
Batch Control Records (F0011) |
Contains system-generated batch header information, including the batch number, batch status, and batch entry date. |
Bill of Material Master (F3002) |
Contains information at the business unit level about bills of material, such as quantities of components. The system uses this information to calculate material costs. |
Item Branch (F4102) |
Defines and maintains warehouse or plant-level information, such as branch-level category codes. |
Business Unit Master (F0006) |
Identifies information about business units, such as company names and category codes assigned to the business unit. |
Item Cost Component Add-Ons (F30026) |
Contains standard costs by cost component. |
Item Cost Component Detail (F300261) |
Stores item cost components by work center. |
Item Cost (F4105) |
Contains the summarized item costs and inventory valuation method. |
Equipment Rates (F1301) |
Contains equipment rates that can be used for actual costing if you select this table as a machine rate source in the Manufacturing Constants program (P3009). |
Generic Message/Rates (F00191) |
Contains rate and factor tables, including:
|
Item Ledger (F4111) |
Contains transactions that indicate changes in inventory value. |
Item Location (F41021) |
Determines the GL class code that is used in manufacturing accounting transactions. |
Item Master (F4101) |
Stores basic information, such as item numbers, descriptions, category codes, and units of measure, about each defined inventory item. |
Job Shop Manufacturing Constants (F3009) |
Stores variables that indicate which overhead values to use. For actual costing, you can specify the sources for labor and machine rates. |
Item Manufacturing Data (F4101M) |
Stores the accounting cost quantity, which the system uses as the standard quantity produced to determine the allocation of fixed setup costs for an item. |
Work Order Parts List (F3111) |
Contains the parts list that is attached to a work order or rate schedule. It contains one record for each part. |
Production Cost (F3102) |
Contains all costs that are associated with a particular work order. |
Purchase Order Detail (F4311) |
Contains transactions that are related to a purchase order. |
Routing Master (F3003) |
Stores routing information, including operation sequence, work center, run time, setup time, and machine time. The system uses this information to calculate labor, machine, and overhead costs. |
Sales Flex Accounting (F4096) |
Determines the information to use for flex accounting. |
User Defined Codes (F0005) |
Contains user-defined codes (UDCs) and their descriptions. |
Work Center Master (F30006) |
Contains detailed data about all defined work centers, including efficiency. |
Work Center Rates (F30008) |
Contains simulated and frozen rates, such as rates for overhead, labor, and machine time, for each work center. |
Work Order Master (F4801) |
Contains all work order header information. The data from this table appears on shop floor paperwork. The system updates this table when completion transactions occur for a work order. |
Work Order Master Tag (F4801T) |
Stores the cost method for the work order, which determines whether a work order is processed as standard or actual costing. Additionally, it includes the unaccounted amount and quantity for scrap units and the unaccounted work order completions. |
Work Order Routing (F3112) |
Contains the routing steps that are attached to a work order or rate schedule. It contains one record for each operation sequence number and work center. |
Work Order Time Transactions (F31122) |
Contains labor and machine time transactions by work order. |