Oracle GL Important Tables Lession1

FND_ID_FLEX_STRUCTURES
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
CONCATENATED_SEGMENT_DELIMITER
CROSS_SEGMENT_VALIDATION_FLAG
DYNAMIC_INSERTS_ALLOWED_FLAG
ENABLED_fLAG
FREEZE_FLEX_DEFINITION_FLAG
FREEZE_STRUCTURED_HIER_FLAG
STRUCTURE_VIEW_NAME

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

Major Columns
CODE_COMBINATION_ID
CHART_OF_ACCOUNTS_ID
ACCOUNT_TYPE
ENABLED_FLAG
SEGMENT1... SEGMENT20.

Journal Entry Tables
The major tables storing journal entries related information are as follows:
GL_JE_BATCHES
GL_JE_HEADERS
GL_JE_LINES
GL_CODE_COMBINATIONS
GL_BALANCES

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

Major Columns
JE_BATCH_ID
NAME
STATUS : POSTED or Unposted
POSTED_DATE
.........


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

Major Columns
JE_HEADERS_ID
JE_CATEGORY
JE_SOURCE
STATUS
PERIOD_NAME

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

Major Columns
JE_HEADERS_ID
JE_LINE_NUM
CODE_COMBINATION_ID
PERIOD_NAME
EFFECTIVE_DATE
STATUS

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

Major Columns
SET_OF_BOOKS_ID
CODE_COMBINATION_ID
CURRENCY_CODE
PERIOD_NAME
ACTUAL_FLAG
ENCUMBRANCE_TYPE_ID
TRANSLATED_FLAG
PERIOD_NET_DR
PERIOD_NET_CR
BEGIN_BALANCE_DR
BEGIN_BALANCE_CR