FND Design Data [Home] [Help]

Table: FA_MC_DEFERRED_DEPRN

Product: OFA - Assets
Description: Deferred depreciation calculated for each distribution line in the reporting currency
Implementation/DBA Data: TableFA.FA_MC_DEFERRED_DEPRN
Primary Key: FA_MC_DEFERRED_DEPRN_PK
  1. ColumnASSET_ID
  2. ColumnTAX_BOOK_TYPE_CODE
  3. ColumnTAX_PERIOD_COUNTER
  4. ColumnDISTRIBUTION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
FA_MC_DEFERRED_DEPRN FK Joins to TableFA_BOOK_CONTROLS FA_MC_DEFERRED_DEPRN.CORP_BOOK_TYPE_CODE
FA_MC_DEFERRED_DEPRN FK Joins to TableGL_CODE_COMBINATIONS FA_MC_DEFERRED_DEPRN.DEFERRED_DEPRN_EXPENSE_CCID
FA_MC_DEFERRED_DEPRN FK Joins to TableGL_CODE_COMBINATIONS FA_MC_DEFERRED_DEPRN.DEFERRED_DEPRN_RESERVE_CCID
FA_MC_DEFERRED_DEPRN FK Joins to TableFA_BOOK_CONTROLS FA_MC_DEFERRED_DEPRN.TAX_BOOK_TYPE_CODE
FA_MC_DEFERRED_DEPRN FK Joins to TableFA_ADDITIONS_B FA_MC_DEFERRED_DEPRN.ASSET_ID
FA_MC_DEFERRED_DEPRN FK Joins to TableFA_DISTRIBUTION_HISTORY FA_MC_DEFERRED_DEPRN.DISTRIBUTION_ID
FA_MC_DEFERRED_DEPRN FK Joins to TableGL_JE_HEADERS FA_MC_DEFERRED_DEPRN.JE_HEADER_ID
FA_MC_DEFERRED_DEPRN FK Joins to TableGL_JE_LINES FA_MC_DEFERRED_DEPRN.JE_HEADER_ID
FA_MC_DEFERRED_DEPRN.EXPENSE_JE_LINE_NUM
FA_MC_DEFERRED_DEPRN FK Joins to TableGL_JE_LINES FA_MC_DEFERRED_DEPRN.JE_HEADER_ID
FA_MC_DEFERRED_DEPRN.RESERVE_JE_LINE_NUM