FND Design Data [Home] [Help]

Table: FA_DEPRN_SUMMARY

Product: OFA - Assets
Description: Depreciation information at the asset level
Implementation/DBA Data: TableFA.FA_DEPRN_SUMMARY
Primary Key: FA_DEPRN_SUMMARY_PK
  1. ColumnBOOK_TYPE_CODE
  2. ColumnASSET_ID
  3. ColumnPERIOD_COUNTER
Foreign Keys
Table
Foreign Table Foreign Key Column
FA_DEPRN_SUMMARY FK Joins to TableFA_BOOK_CONTROLS FA_DEPRN_SUMMARY.BOOK_TYPE_CODE
FA_DEPRN_SUMMARY FK Joins to TableFA_ADDITIONS_B FA_DEPRN_SUMMARY.ASSET_ID
FA_DEPRN_SUMMARY FK Joins to TableFA_DEPRN_PERIODS FA_DEPRN_SUMMARY.BOOK_TYPE_CODE
FA_DEPRN_SUMMARY.PERIOD_COUNTER
TableFA_DEPRN_DETAIL FK Joins to FA_DEPRN_SUMMARY FA_DEPRN_DETAIL.BOOK_TYPE_CODE
FA_DEPRN_DETAIL.ASSET_ID
FA_DEPRN_DETAIL.PERIOD_COUNTER