This appendix contains the following topics:
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. |
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. |