FND Design Data [Home] [Help]

Table: GL_BALANCES

Product: GL - General Ledger
Description: Account balances for both detail and summary accounts
Implementation/DBA Data: TableGL.GL_BALANCES
Primary Key: GL_BALANCES_PK
  1. ColumnLEDGER_ID
  2. ColumnCODE_COMBINATION_ID
  3. ColumnCURRENCY_CODE
  4. ColumnPERIOD_NAME
  5. ColumnACTUAL_FLAG
  6. ColumnBUDGET_VERSION_ID
  7. ColumnENCUMBRANCE_TYPE_ID
  8. ColumnTRANSLATED_FLAG
Foreign Keys
Table
Foreign Table Foreign Key Column
GL_BALANCES FK Joins to TableGL_BUDGET_VERSIONS GL_BALANCES.BUDGET_VERSION_ID
GL_BALANCES FK Joins to TableGL_CODE_COMBINATIONS GL_BALANCES.CODE_COMBINATION_ID
GL_BALANCES FK Joins to TableGL_BUDGET_VERSIONS GL_BALANCES.BUDGET_VERSION_ID
GL_BALANCES FK Joins to TableGL_ENCUMBRANCE_TYPES GL_BALANCES.ENCUMBRANCE_TYPE_ID
GL_BALANCES FK Joins to TableGL_PERIOD_TYPES GL_BALANCES.PERIOD_TYPE
GL_BALANCES FK Joins to TableGL_SUMMARY_TEMPLATES GL_BALANCES.TEMPLATE_ID
GL_BALANCES FK Joins to Table% GL_BALANCES.LEDGER_ID
GL_BALANCES FK Joins to TableFND_CURRENCIES GL_BALANCES.CURRENCY_CODE
GL_BALANCES FK Joins to TableFND_CURRENCIES GL_BALANCES.CURRENCY_CODE