Search Results gl_balances




Here's a comprehensive description of the GL_BALANCES table in Oracle E-Business Suite's General Ledger module:

Table Name: GL_BALANCES

Purpose:
- Stores summarized financial account balance information
- Tracks cumulative balances for general ledger accounts across different periods and currencies

Key Columns:
1. LEDGER_ID
- Identifies the specific ledger/set of books
- Typically links to GL_LEDGERS table

2. PERIOD_NAME
- Represents accounting period (e.g., JAN-22, FEB-22)
- Links to GL_PERIODS table

3. CURRENCY_CODE
- Stores the currency for the balance
- Typically links to FND_CURRENCIES table

4. CODE_COMBINATION_ID
- Unique identifier for the account combination
- Links to GL_CODE_COMBINATIONS table

5. ACTUAL_FLAG
- Indicates balance type (actual, budget, etc.)

6. BALANCE_TYPE
- Represents balance type (period, quarter, year-to-date)

Balance Amount Columns:
- PERIOD_NET_DR
- PERIOD_NET_CR
- PERIOD_NET_TOTAL
- PERIOD_BEGINNING_BALANCE
- YEAR_TO_DATE_BALANCE

Additional Attributes:
- Creation Date
- Last Update Date
- Last Updated By

Primary Key: Combination of LEDGER_ID, PERIOD_NAME, CURRENCY_CODE, CODE_COMBINATION_ID

Typical Usage:
- Financial reporting
- Account reconciliation
- Balance tracking across periods