Thursday, 13 August 2015

Oracle R12 GL Tables



Sr. No Category Table Name Description/ Uses
1 General Ledger GL_CODE_COMBINATION Stores Valid account combinations
2 GL_SETS_OF_BOOKS Stores Information about the sets of books
3 GL_IMPORT_REFERENCES Stores Individual transactions from subledgers
4 GL_DAILY_RATES Stores the daily conversion rates for foreign currency
5 Transactions GL_PERIODS Stores Information about the Accounting Periods
6 GL_JE_HEADERS Stores Journal Entries
7 GL_JE_LINES Stores Journal Entries lines that we enter in the Enter Journals Form
8 GL_JE_BATCHES Stores Journal Entry Batches
9 GL_BALANCES Stores Actual, Budget and encumbrance balances for details and summary accounts
10 GL_BUDGETS Stores Budget defintions
11 GL_INTERFACE Import journal entry batches
12 GL_BUDGET_INTERFACE Upload budget data from external sources
13 GL_DAILY_RATES_INTERFACE Import daily conversion rates

No comments:

Post a Comment

Total Pageviews