FND Design Data [Home] [Help]

Table: GL_ARCHIVE_DAILY_BALANCES

Product: GL - General Ledger
Description: Archive daily aggregate balances
Implementation/DBA Data: Not implemented in this database
Primary Key: GL_ARCHIVE_DAILY_BALANCES_PK
  1. ColumnSET_OF_BOOKS_ID
  2. ColumnCODE_COMBINATION_ID
  3. ColumnCURRENCY_CODE
  4. ColumnCURRENCY_TYPE
  5. ColumnACTUAL_FLAG
  6. ColumnPERIOD_NAME
  7. ColumnCONVERTED_FROM_CURRENCY
Primary Key: GL_ARCHIVE_DAILY_BALANCES_U1
  1. ColumnCODE_COMBINATION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
GL_ARCHIVE_DAILY_BALANCES FK Joins to TableGL_CODE_COMBINATIONS GL_ARCHIVE_DAILY_BALANCES.CODE_COMBINATION_ID
GL_ARCHIVE_DAILY_BALANCES FK Joins to TableGL_PERIOD_TYPES GL_ARCHIVE_DAILY_BALANCES.PERIOD_TYPE
GL_ARCHIVE_DAILY_BALANCES FK Joins to TableGL_SUMMARY_TEMPLATES GL_ARCHIVE_DAILY_BALANCES.TEMPLATE_ID
GL_ARCHIVE_DAILY_BALANCES FK Joins to TableGL_SETS_OF_BOOKS GL_ARCHIVE_DAILY_BALANCES.SET_OF_BOOKS_ID
GL_ARCHIVE_DAILY_BALANCES FK Joins to TableFND_CURRENCIES GL_ARCHIVE_DAILY_BALANCES.CURRENCY_CODE