FND Design Data [Home] [Help]

Table: FA_MC_RETIREMENTS

Product: OFA - Assets
Description: Currency and financial information about retirements in each reporting book
Implementation/DBA Data: TableFA.FA_MC_RETIREMENTS
Primary Key: FA_MC_RETIREMENTS_PK
  1. ColumnRETIREMENT_ID
  2. ColumnSET_OF_BOOKS_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
FA_MC_RETIREMENTS FK Joins to TableGL_SETS_OF_BOOKS_11I FA_MC_RETIREMENTS.SET_OF_BOOKS_ID
FA_MC_RETIREMENTS FK Joins to TableFA_MC_BOOK_CONTROLS FA_MC_RETIREMENTS.BOOK_TYPE_CODE
FA_MC_RETIREMENTS.SET_OF_BOOKS_ID
FA_MC_RETIREMENTS FK Joins to TableFA_ADDITIONS_B FA_MC_RETIREMENTS.ASSET_ID
FA_MC_RETIREMENTS FK Joins to TableFA_TRANSACTION_HEADERS FA_MC_RETIREMENTS.TRANSACTION_HEADER_ID_IN
FA_MC_RETIREMENTS FK Joins to TableFA_TRANSACTION_HEADERS FA_MC_RETIREMENTS.TRANSACTION_HEADER_ID_OUT
FA_MC_RETIREMENTS FK Joins to TableFA_ITC_RECAPTURE_RATES FA_MC_RETIREMENTS.ITC_RECAPTURE_ID
FA_MC_RETIREMENTS FK Joins to TableFA_CONVENTION_TYPES FA_MC_RETIREMENTS.RETIREMENT_PRORATE_CONVENTION
FA_MC_RETIREMENTS FK Joins to TableFA_ADDITIONS_B FA_MC_RETIREMENTS.TRADE_IN_ASSET_ID
FA_MC_RETIREMENTS FK Joins to TableFA_METHODS FA_MC_RETIREMENTS.STL_METHOD_CODE
FA_MC_RETIREMENTS.STL_LIFE_IN_MONTHS
TableFA_MC_BOOKS FK Joins to FA_MC_RETIREMENTS FA_MC_BOOKS.RETIREMENT_ID
FA_MC_BOOKS.SET_OF_BOOKS_ID