## Appendix: General Accounting Tables

The JD Edwards EnterpriseOne General Accounting system uses these types of tables:

- Primary tables

- Supplemental tables

### Primary Tables

The General Account system uses these primary tables:

Table Name (Number) | Description
Account Master (F0901) | Stores account definitions, including account numbers and descriptions. One record exists for each account.
Account Balances (F0902) | Stores account balances including net postings for each period and prior year balances (net and cumulative). One record exists for each account/ledger type/subledger/subledger type/fiscal year and, if you post by currency, transaction currency.
Account Ledger (F0911) | Stores detail transactions in the general ledger. One record exists for each transaction. When you use multiple currencies, two records exist for each transaction.

### Supplemental Tables

The JD Edwards EnterpriseOne General Accounting system uses these supplemental tables:

Table Name (Number) | Description
Next Numbers - Automatic (F0002) | Stores the next available number for all automatically assigned numbers in the system, such as batch numbers and transaction numbers.
User-Defined Codes (F0005) | Stores user-defined codes and their descriptions.
Business Unit Master (F0006) | Stores business unit definitions, including name and number, company, and category codes.
Date Effective Business Unit Master (F0006S) | Stores business unit definitions including name and number, company, and category codes by effective date.
Date Fiscal Patterns (F0008) | Stores each company's fiscal date pattern.
General Constants (F0009) | Stores the rules that control system-wide functions, such as account coding, batch control, batch approval, date validation, intercompany settlements, and batch balancing.
Company Constants (F0010) | Stores company definitions, including number and name, fiscal date pattern, and current period.
Batch Control Records (F0011) | Stores identification header records for each batch.
Automatic Accounting Instructions Master (F0012) | Stores the rules that control how the system creates automatic balancing entries, special interim totals for reports, and general information about the chart of accounts.
Taxes (F0018) | Stores the transaction detail for each item that is subject to tax.
Tax Reconciliation Repository (F0018R) | Stores tax information by general ledger account.
Ledger Type Master File (F0025) | Stores rules for specific ledger types, such as: Attached ledger types for units Financial rules, such as balancing required Column titles for ledger comparisons
Organization Structure Master File (F0050) | Stores parent/child relationships for business units by structure type.
Structure Definition File (F0050A) | Stores the organization structures that you define for grouping business units by category codes.
Supplemental Database Data Types (F00091) | Stores the definitions of the data types that you use to track additional information about business units.
Supplemental Data (F00092) | Stores additional information that you enter about business units, categorized by data types.
Address Book Master (F0101) | Stores address book information, including companies, suppliers, and customers.
WF - Account Ledger Reconciliation (F0911R) | Stores unreconciled transaction detail. The system replaces the contents of this table after each reconciliation.
Cost Allocations/Flex Budgeting (F0912) | Stores information about recurring journal entries (allocations).
Index Computation Entry File (F0912A) | Stores information about indexed allocations.
Variable Allocation File (F0912B) | Stores information about variable numerator allocations.
Bank Statement Header (F0916) | Stores header information about bank statements.
Bank Statement Detail (F0917) | Stores detail information about the transactions on bank statements.
Inter/Intra Company Account Relationships (F09190) | Stores information about configured hubs for intercompany settlements.