FND Design Data [Home] [Help]

Table: FA_DEFERRED_DEPRN

Product: OFA - Assets
Description: Deferred depreciation calculated for each distribution line
Implementation/DBA Data: TableFA.FA_DEFERRED_DEPRN
Primary Key: FA_DEFERRED_DEPRN_PK
  1. ColumnTAX_BOOK_TYPE_CODE
  2. ColumnEXPENSE_JE_LINE_NUM
Primary Key: FA_DEFERRED_DEPRN_UK1
  1. ColumnCORP_BOOK_TYPE_CODE
  2. ColumnTAX_BOOK_TYPE_CODE
  3. ColumnRESERVE_JE_LINE_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
FA_DEFERRED_DEPRN FK Joins to TableFA_BOOK_CONTROLS FA_DEFERRED_DEPRN.CORP_BOOK_TYPE_CODE
FA_DEFERRED_DEPRN FK Joins to TableGL_CODE_COMBINATIONS FA_DEFERRED_DEPRN.DEFERRED_DEPRN_EXPENSE_CCID
FA_DEFERRED_DEPRN FK Joins to TableGL_CODE_COMBINATIONS FA_DEFERRED_DEPRN.DEFERRED_DEPRN_RESERVE_CCID
FA_DEFERRED_DEPRN FK Joins to TableFA_BOOK_CONTROLS FA_DEFERRED_DEPRN.TAX_BOOK_TYPE_CODE
FA_DEFERRED_DEPRN FK Joins to TableFA_ADDITIONS_B FA_DEFERRED_DEPRN.ASSET_ID
FA_DEFERRED_DEPRN FK Joins to TableFA_DISTRIBUTION_HISTORY FA_DEFERRED_DEPRN.DISTRIBUTION_ID
FA_DEFERRED_DEPRN FK Joins to TableFA_DEPRN_PERIODS FA_DEFERRED_DEPRN.CORP_BOOK_TYPE_CODE
FA_DEFERRED_DEPRN.CORP_PERIOD_COUNTER
FA_DEFERRED_DEPRN FK Joins to TableFA_DEPRN_PERIODS FA_DEFERRED_DEPRN.TAX_BOOK_TYPE_CODE
FA_DEFERRED_DEPRN.TAX_PERIOD_COUNTER
FA_DEFERRED_DEPRN FK Joins to TableGL_JE_HEADERS FA_DEFERRED_DEPRN.JE_HEADER_ID
FA_DEFERRED_DEPRN FK Joins to TableGL_JE_LINES FA_DEFERRED_DEPRN.JE_HEADER_ID
FA_DEFERRED_DEPRN.EXPENSE_JE_LINE_NUM
FA_DEFERRED_DEPRN FK Joins to TableGL_JE_LINES FA_DEFERRED_DEPRN.JE_HEADER_ID
FA_DEFERRED_DEPRN.RESERVE_JE_LINE_NUM