FND Design Data [Home] [Help]

Table: FA_MC_CONVERSION_RATES

Product: OFA - Assets
Description: Table to store the exchange rate information to convert assets from primary to reporting book
Implementation/DBA Data: TableFA.FA_MC_CONVERSION_RATES
Primary Key: FA_MC_CONVERSION_RATES_PK
  1. ColumnASSET_ID
  2. ColumnSET_OF_BOOKS_ID
  3. ColumnBOOK_TYPE_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
FA_MC_CONVERSION_RATES FK Joins to TableFA_ADDITIONS_B FA_MC_CONVERSION_RATES.ASSET_ID
FA_MC_CONVERSION_RATES FK Joins to TableFA_BOOK_CONTROLS FA_MC_CONVERSION_RATES.BOOK_TYPE_CODE
FA_MC_CONVERSION_RATES FK Joins to TableGL_SETS_OF_BOOKS_11I FA_MC_CONVERSION_RATES.SET_OF_BOOKS_ID
FA_MC_CONVERSION_RATES FK Joins to TableFA_DEPRN_PERIODS FA_MC_CONVERSION_RATES.BOOK_TYPE_CODE
FA_MC_CONVERSION_RATES.LAST_PERIOD_COUNTER