FND Design Data [Home] [Help]

Table: GL_HISTORICAL_RATES

Product: GL - General Ledger
Description: Foreign currency translation rates for historical accounts
Implementation/DBA Data: TableGL.GL_HISTORICAL_RATES
Primary Key: GL_HISTORICAL_RATES_PK
  1. ColumnLEDGER_ID
  2. ColumnCODE_COMBINATION_ID
  3. ColumnPERIOD_NAME
  4. ColumnTARGET_CURRENCY
  5. ColumnUSAGE_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
GL_HISTORICAL_RATES FK Joins to TableFND_CURRENCIES GL_HISTORICAL_RATES.TARGET_CURRENCY
GL_HISTORICAL_RATES FK Joins to TableGL_CODE_COMBINATIONS GL_HISTORICAL_RATES.CODE_COMBINATION_ID
GL_HISTORICAL_RATES FK Joins to TableGL_SETS_OF_BOOKS_11I GL_HISTORICAL_RATES.LEDGER_ID