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
-
Table: GL_BALANCES
12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_BALANCES, object_name:GL_BALANCES, status:VALID, product: GL - General Ledger , description: Account balances for both detail and summary accounts , implementation_dba_data: GL.GL_BALANCES ,
-
Table: GL_BALANCES
12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_BALANCES, object_name:GL_BALANCES, status:VALID, product: GL - General Ledger , description: Account balances for both detail and summary accounts , implementation_dba_data: GL.GL_BALANCES ,
-
View: GL_BUDGET_DEPENDENT_AMTS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_BUDGET_DEPENDENT_AMTS_V, object_name:GL_BUDGET_DEPENDENT_AMTS_V, status:VALID, product: GL - General Ledger , description: 10SC ONLY , implementation_dba_data: APPS.GL_BUDGET_DEPENDENT_AMTS_V ,
-
Table: GL_BUDGET_VERSIONS
12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_BUDGET_VERSIONS, object_name:GL_BUDGET_VERSIONS, status:VALID, product: GL - General Ledger , description: Budget version definitions , implementation_dba_data: GL.GL_BUDGET_VERSIONS ,
-
View: GL_BUDGET_DEPENDENT_AMTS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_BUDGET_DEPENDENT_AMTS_V, object_name:GL_BUDGET_DEPENDENT_AMTS_V, status:VALID, product: GL - General Ledger , description: 10SC ONLY , implementation_dba_data: APPS.GL_BUDGET_DEPENDENT_AMTS_V ,
-
Table: GL_BUDGET_VERSIONS
12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_BUDGET_VERSIONS, object_name:GL_BUDGET_VERSIONS, status:VALID, product: GL - General Ledger , description: Budget version definitions , implementation_dba_data: GL.GL_BUDGET_VERSIONS ,
-
Table: GL_PERIOD_TYPES
12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_PERIOD_TYPES, object_name:GL_PERIOD_TYPES, status:VALID, product: GL - General Ledger , description: Calendar period types , implementation_dba_data: GL.GL_PERIOD_TYPES ,
-
Table: GL_PERIOD_TYPES
12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_PERIOD_TYPES, object_name:GL_PERIOD_TYPES, status:VALID, product: GL - General Ledger , description: Calendar period types , implementation_dba_data: GL.GL_PERIOD_TYPES ,
-
View: GLBV_ENCUMBRANCE_BALANCES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GLBV_ENCUMBRANCE_BALANCES, object_name:GLBV_ENCUMBRANCE_BALANCES, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GLBV_ENCUMBRANCE_BALANCES ,
-
Table: GL_ENCUMBRANCE_TYPES
12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_ENCUMBRANCE_TYPES, object_name:GL_ENCUMBRANCE_TYPES, status:VALID, product: GL - General Ledger , description: Encumbrance type definitions , implementation_dba_data: GL.GL_ENCUMBRANCE_TYPES ,
-
Table: GL_SUMMARY_TEMPLATES
12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_SUMMARY_TEMPLATES, object_name:GL_SUMMARY_TEMPLATES, status:VALID, product: GL - General Ledger , description: Summary account templates , implementation_dba_data: GL.GL_SUMMARY_TEMPLATES ,
-
Table: GL_ENCUMBRANCE_TYPES
12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_ENCUMBRANCE_TYPES, object_name:GL_ENCUMBRANCE_TYPES, status:VALID, product: GL - General Ledger , description: Encumbrance type definitions , implementation_dba_data: GL.GL_ENCUMBRANCE_TYPES ,
-
Table: GL_SUMMARY_TEMPLATES
12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_SUMMARY_TEMPLATES, object_name:GL_SUMMARY_TEMPLATES, status:VALID, product: GL - General Ledger , description: Summary account templates , implementation_dba_data: GL.GL_SUMMARY_TEMPLATES ,
-
View: GLFV_ENCUMBRANCE_BALANCES
12.2.2
product: GL - General Ledger , description: Encumbrance Balances are commitments, obligations, and other planned expenditures. You may only have functional currency encumbrance balances. , implementation_dba_data: Not implemented in this database ,
-
View: GLBV_ENCUMBRANCE_BALANCES
12.2.2
product: GL - General Ledger , implementation_dba_data: Not implemented in this database ,
-
View: GLBV_BUDGET_BALANCES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GLBV_BUDGET_BALANCES, object_name:GLBV_BUDGET_BALANCES, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GLBV_BUDGET_BALANCES ,
-
View: GLFV_BUDGET_BALANCES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GLFV_BUDGET_BALANCES, object_name:GLFV_BUDGET_BALANCES, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GLFV_BUDGET_BALANCES ,
-
View: GLFV_ENCUMBRANCE_BALANCES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GLFV_ENCUMBRANCE_BALANCES, object_name:GLFV_ENCUMBRANCE_BALANCES, status:VALID, product: GL - General Ledger , description: Encumbrance Balances are commitments, obligations, and other planned expenditures. You may only have functional currency encumbrance balances. , implementation_dba_data: APPS.GLFV_ENCUMBRANCE_BALANCES ,
-
View: GLFV_BUDGET_BALANCES
12.2.2
product: GL - General Ledger , implementation_dba_data: Not implemented in this database ,
-
View: GLBV_BUDGET_BALANCES
12.2.2
product: GL - General Ledger , implementation_dba_data: Not implemented in this database ,
-
View: GLBV_ACTUAL_BALANCES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GLBV_ACTUAL_BALANCES, object_name:GLBV_ACTUAL_BALANCES, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GLBV_ACTUAL_BALANCES ,
-
View: GL_CONTROL_BUDGET_BALANCES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_CONTROL_BUDGET_BALANCES_V, object_name:GL_CONTROL_BUDGET_BALANCES_V, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GL_CONTROL_BUDGET_BALANCES_V ,
-
View: GL_BUDGET_DETAIL_BALANCES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_BUDGET_DETAIL_BALANCES_V, object_name:GL_BUDGET_DETAIL_BALANCES_V, status:VALID, product: GL - General Ledger , description: 10SC ONLY , implementation_dba_data: APPS.GL_BUDGET_DETAIL_BALANCES_V ,
-
View: GLFV_ACTUAL_BALANCES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GLFV_ACTUAL_BALANCES, object_name:GLFV_ACTUAL_BALANCES, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GLFV_ACTUAL_BALANCES ,
-
View: GLBV_ACTUAL_BALANCES
12.2.2
product: GL - General Ledger , implementation_dba_data: Not implemented in this database ,
-
View: GL_CONTROL_BUDGET_BALANCES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_CONTROL_BUDGET_BALANCES_V, object_name:GL_CONTROL_BUDGET_BALANCES_V, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GL_CONTROL_BUDGET_BALANCES_V ,
-
View: GL_BUDGET_DETAIL_BALANCES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_BUDGET_DETAIL_BALANCES_V, object_name:GL_BUDGET_DETAIL_BALANCES_V, status:VALID, product: GL - General Ledger , description: 10SC ONLY , implementation_dba_data: APPS.GL_BUDGET_DETAIL_BALANCES_V ,
-
View: GLFV_ACTUAL_BALANCES
12.2.2
product: GL - General Ledger , implementation_dba_data: Not implemented in this database ,
-
View: GLFV_GL_STANDARD_BALANCES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GLFV_GL_STANDARD_BALANCES, object_name:GLFV_GL_STANDARD_BALANCES, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GLFV_GL_STANDARD_BALANCES ,
-
View: GLBV_GL_STANDARD_BALANCES
12.2.2
product: GL - General Ledger , implementation_dba_data: Not implemented in this database ,
-
View: GL_BUDGET_DEP_BALANCES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_BUDGET_DEP_BALANCES_V, object_name:GL_BUDGET_DEP_BALANCES_V, status:VALID, product: GL - General Ledger , description: 10SC ONLY , implementation_dba_data: APPS.GL_BUDGET_DEP_BALANCES_V ,
-
View: GLBV_GL_STANDARD_BALANCES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GLBV_GL_STANDARD_BALANCES, object_name:GLBV_GL_STANDARD_BALANCES, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GLBV_GL_STANDARD_BALANCES ,
-
View: GLFV_GL_STANDARD_BALANCES
12.2.2
product: GL - General Ledger , implementation_dba_data: Not implemented in this database ,
-
View: GL_BUDGET_DEP_BALANCES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_BUDGET_DEP_BALANCES_V, object_name:GL_BUDGET_DEP_BALANCES_V, status:VALID, product: GL - General Ledger , description: 10SC ONLY , implementation_dba_data: APPS.GL_BUDGET_DEP_BALANCES_V ,
-
View: GL_JE_CONS_BALANCES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_JE_CONS_BALANCES_V, object_name:GL_JE_CONS_BALANCES_V, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GL_JE_CONS_BALANCES_V ,
-
View: GL_JE_CONS_BALANCES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_JE_CONS_BALANCES_V, object_name:GL_JE_CONS_BALANCES_V, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GL_JE_CONS_BALANCES_V ,
-
View: GL_VARIANCE_SEC_BALANCES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_VARIANCE_SEC_BALANCES_V, object_name:GL_VARIANCE_SEC_BALANCES_V, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GL_VARIANCE_SEC_BALANCES_V ,
-
View: GL_VARIANCE_BALANCES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_VARIANCE_BALANCES_V, object_name:GL_VARIANCE_BALANCES_V, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GL_VARIANCE_BALANCES_V ,
-
View: GL_VARIANCE_BALANCES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_VARIANCE_BALANCES_V, object_name:GL_VARIANCE_BALANCES_V, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GL_VARIANCE_BALANCES_V ,
-
View: GL_VARIANCE_SEC_BALANCES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_VARIANCE_SEC_BALANCES_V, object_name:GL_VARIANCE_SEC_BALANCES_V, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GL_VARIANCE_SEC_BALANCES_V ,
-
View: GL_BALANCES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_BALANCES_V, object_name:GL_BALANCES_V, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GL_BALANCES_V ,
-
View: GL_BALANCES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_BALANCES_V, object_name:GL_BALANCES_V, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GL_BALANCES_V ,
-
View: GL_FUNCTIONAL_BALANCES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_FUNCTIONAL_BALANCES_V, object_name:GL_FUNCTIONAL_BALANCES_V, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GL_FUNCTIONAL_BALANCES_V ,
-
View: GL_FUNCTIONAL_BALANCES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_FUNCTIONAL_BALANCES_V, object_name:GL_FUNCTIONAL_BALANCES_V, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GL_FUNCTIONAL_BALANCES_V ,
-
View: GL_DETAIL_BALANCES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_DETAIL_BALANCES_V, object_name:GL_DETAIL_BALANCES_V, status:VALID, product: GL - General Ledger , description: 10SC ONLY , implementation_dba_data: APPS.GL_DETAIL_BALANCES_V ,
-
View: GL_DETAIL_BALANCES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_DETAIL_BALANCES_V, object_name:GL_DETAIL_BALANCES_V, status:VALID, product: GL - General Ledger , description: 10SC ONLY , implementation_dba_data: APPS.GL_DETAIL_BALANCES_V ,
-
View: GL_SUMMARY_BALANCES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_SUMMARY_BALANCES_V, object_name:GL_SUMMARY_BALANCES_V, status:VALID, product: GL - General Ledger , description: 10SC ONLY , implementation_dba_data: APPS.GL_SUMMARY_BALANCES_V ,
-
View: GL_SUMMARY_BALANCES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_SUMMARY_BALANCES_V, object_name:GL_SUMMARY_BALANCES_V, status:VALID, product: GL - General Ledger , description: 10SC ONLY , implementation_dba_data: APPS.GL_SUMMARY_BALANCES_V ,
-
Table: GL_CODE_COMBINATIONS
12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_CODE_COMBINATIONS, object_name:GL_CODE_COMBINATIONS, status:VALID, product: GL - General Ledger , description: Account combinations , implementation_dba_data: GL.GL_CODE_COMBINATIONS ,
-
Table: GL_CODE_COMBINATIONS
12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_CODE_COMBINATIONS, object_name:GL_CODE_COMBINATIONS, status:VALID, product: GL - General Ledger , description: Account combinations , implementation_dba_data: GL.GL_CODE_COMBINATIONS ,