FND Design Data [Home] [Help]

Table: GL_DAILY_BALANCES

Product: GL - General Ledger
Description: Daily aggregate balances for both detail and summary accounts
Implementation/DBA Data: TableGL.GL_DAILY_BALANCES
Primary Key: GL_DAILY_BALANCES_PK
  1. ColumnLEDGER_ID
  2. ColumnCODE_COMBINATION_ID
  3. ColumnCURRENCY_CODE
  4. ColumnCURRENCY_TYPE
  5. ColumnACTUAL_FLAG
  6. ColumnPERIOD_NAME
  7. ColumnCONVERTED_FROM_CURRENCY
Primary Key: GL_DAILY_BALANCES_U1
  1. ColumnCODE_COMBINATION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
GL_DAILY_BALANCES FK Joins to TableGL_CODE_COMBINATIONS GL_DAILY_BALANCES.CODE_COMBINATION_ID
GL_DAILY_BALANCES FK Joins to TableGL_PERIOD_TYPES GL_DAILY_BALANCES.PERIOD_TYPE
GL_DAILY_BALANCES FK Joins to TableGL_SUMMARY_TEMPLATES GL_DAILY_BALANCES.TEMPLATE_ID
GL_DAILY_BALANCES FK Joins to Table% GL_DAILY_BALANCES.LEDGER_ID
GL_DAILY_BALANCES FK Joins to TableFND_CURRENCIES GL_DAILY_BALANCES.CURRENCY_CODE