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. |