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