This table stores structure data about key flexfields.
A structure is the entire definition of all columns and meaning of the key flexfield. Structure definitions for the accounting flexfield are stored in this table in record where ID_FLEX_CODE=GL#.
The accounting key flexfield can have multiple structures, each identified by a unique combination of ID_FLEX_CODE and ID_FLEX_NUM.
Major Columns - Application_ID, ID_FLEX_CODE, ID_FLEX_NUM
This table stores valid account combinations for each accounting flexfield structure in Oracle General Ledger.
Associated with each account are certain codes and flags, including whether the account is enabled and whether detail posting or detail budgeting is allowed.
This table references the CODE_COMBINATION_ID which is the foreign key used by Oracle Applications to track accounting entries.
Journal Entry Tables
The major tables storing journal entries related information are as follows:
This table stores details of journal entry batches. A batch is group of journal entries.
In General Ledger, Journal entries are posted in Batches.
Each row in this table includes the batch name, status, running total debits and credits for all entries in the batch and other information.
STATUS : POSTED or Unposted
This table stores journal entry information. There is a one to many relationship between journal entry batches and journal entries.
Each row in this table includes the associated , batch id, journal entry name and description, and other information about the journal entry.
This table stores journal entry lines. There is a one to man relationship between journal entries headers and journal entry lines. This table contains the information about the account and amount for each line of the entry.
This table stores net debit and net credit information for detail and summary accounts.
This information is stored actual, budget, and encumbrance amounts. It also stores functional currency, foreign currency, and statistical balances for each accounting period that has ever been opened.
GL_BALANCES is populated by the system during the GL Post and Summary Account template definition.
It is used for standard account inquires and for Financial Statement Generator(FSG) reporting.
This table stores activity rather than the actual balance.
Use the following formula to calculate the period to date balance:
(PERIOD_NET_DR- PERIOD_NE_CR)= PERIOD TO DATE BALANCE
Use this formula to calculate the year to date balance
(BEGIN_BALANCE_DR-BEGIN_BALANCE_CR)+ (PERIOD_NET_DR-PERIOD_NET_CR)=YEAR-TO-DATE BALANCE.