FND Design Data [Home] [Help]

Table: FA_DEPRN_DETAIL

Product: OFA - Assets
Description: Depreciation amounts charged to the depreciation expense account in each distribution line
Implementation/DBA Data: TableFA.FA_DEPRN_DETAIL
Primary Key: FA_DEPRN_DETAIL_PK
  1. ColumnBOOK_TYPE_CODE
  2. ColumnASSET_ID
  3. ColumnDISTRIBUTION_ID
  4. ColumnPERIOD_COUNTER
Foreign Keys
Table
Foreign Table Foreign Key Column
FA_DEPRN_DETAIL FK Joins to TableFA_BOOK_CONTROLS FA_DEPRN_DETAIL.BOOK_TYPE_CODE
FA_DEPRN_DETAIL FK Joins to TableFA_DEPRN_SUMMARY FA_DEPRN_DETAIL.BOOK_TYPE_CODE
FA_DEPRN_DETAIL.ASSET_ID
FA_DEPRN_DETAIL.PERIOD_COUNTER
FA_DEPRN_DETAIL FK Joins to TableGL_JE_LINES FA_DEPRN_DETAIL.JE_HEADER_ID
FA_DEPRN_DETAIL.BONUS_DEPRN_EXP_JE_LINE_NUM
FA_DEPRN_DETAIL FK Joins to TableGL_JE_LINES FA_DEPRN_DETAIL.JE_HEADER_ID
FA_DEPRN_DETAIL.BONUS_DEPRN_RSV_JE_LINE_NUM
FA_DEPRN_DETAIL FK Joins to TableGL_CODE_COMBINATIONS FA_DEPRN_DETAIL.DEPRN_EXPENSE_CCID
FA_DEPRN_DETAIL FK Joins to TableGL_CODE_COMBINATIONS FA_DEPRN_DETAIL.DEPRN_RESERVE_CCID
FA_DEPRN_DETAIL FK Joins to TableGL_CODE_COMBINATIONS FA_DEPRN_DETAIL.BONUS_DEPRN_EXPENSE_CCID
FA_DEPRN_DETAIL FK Joins to TableGL_CODE_COMBINATIONS FA_DEPRN_DETAIL.BONUS_DEPRN_RESERVE_CCID
FA_DEPRN_DETAIL FK Joins to TableGL_CODE_COMBINATIONS FA_DEPRN_DETAIL.REVAL_AMORT_CCID
FA_DEPRN_DETAIL FK Joins to TableGL_CODE_COMBINATIONS FA_DEPRN_DETAIL.REVAL_RESERVE_CCID
FA_DEPRN_DETAIL FK Joins to TableFA_ADDITIONS_B FA_DEPRN_DETAIL.ASSET_ID
FA_DEPRN_DETAIL FK Joins to TableFA_DISTRIBUTION_HISTORY FA_DEPRN_DETAIL.DISTRIBUTION_ID
FA_DEPRN_DETAIL FK Joins to TableFA_DEPRN_PERIODS FA_DEPRN_DETAIL.BOOK_TYPE_CODE
FA_DEPRN_DETAIL.PERIOD_COUNTER
FA_DEPRN_DETAIL FK Joins to TableGL_JE_LINES FA_DEPRN_DETAIL.JE_HEADER_ID
FA_DEPRN_DETAIL.DEPRN_EXPENSE_JE_LINE_NUM
FA_DEPRN_DETAIL FK Joins to TableGL_JE_LINES FA_DEPRN_DETAIL.JE_HEADER_ID
FA_DEPRN_DETAIL.DEPRN_RESERVE_JE_LINE_NUM
FA_DEPRN_DETAIL FK Joins to TableGL_JE_LINES FA_DEPRN_DETAIL.JE_HEADER_ID
FA_DEPRN_DETAIL.REVAL_AMORT_JE_LINE_NUM
FA_DEPRN_DETAIL FK Joins to TableGL_JE_LINES FA_DEPRN_DETAIL.JE_HEADER_ID
FA_DEPRN_DETAIL.REVAL_RESERVE_JE_LINE_NUM
FA_DEPRN_DETAIL FK Joins to TableGL_JE_HEADERS FA_DEPRN_DETAIL.JE_HEADER_ID