eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: FA_MC_DEPRN_DETAIL

Product:	OFA - Assets
Description:	Depreciation amounts in the reporting currency, charged to the depreciation expense account in each distribution line
Implementation/DBA Data:	FA.FA_MC_DEPRN_DETAIL

Primary Key: FA_MC_DEPRN_DETAIL_PK

BOOK_TYPE_CODE
ASSET_ID
PERIOD_COUNTER
DISTRIBUTION_ID
SET_OF_BOOKS_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
FA_MC_DEPRN_DETAIL	FA_BOOK_CONTROLS	FA_MC_DEPRN_DETAIL.BOOK_TYPE_CODE
FA_MC_DEPRN_DETAIL	GL_CODE_COMBINATIONS	FA_MC_DEPRN_DETAIL.DEPRN_EXPENSE_CCID
FA_MC_DEPRN_DETAIL	GL_CODE_COMBINATIONS	FA_MC_DEPRN_DETAIL.DEPRN_RESERVE_CCID
FA_MC_DEPRN_DETAIL	GL_CODE_COMBINATIONS	FA_MC_DEPRN_DETAIL.BONUS_DEPRN_EXPENSE_CCID
FA_MC_DEPRN_DETAIL	GL_CODE_COMBINATIONS	FA_MC_DEPRN_DETAIL.BONUS_DEPRN_RESERVE_CCID
FA_MC_DEPRN_DETAIL	GL_CODE_COMBINATIONS	FA_MC_DEPRN_DETAIL.REVAL_AMORT_CCID
FA_MC_DEPRN_DETAIL	GL_CODE_COMBINATIONS	FA_MC_DEPRN_DETAIL.REVAL_RESERVE_CCID
FA_MC_DEPRN_DETAIL	FA_ADDITIONS_B	FA_MC_DEPRN_DETAIL.ASSET_ID
FA_MC_DEPRN_DETAIL	FA_DISTRIBUTION_HISTORY	FA_MC_DEPRN_DETAIL.DISTRIBUTION_ID
FA_MC_DEPRN_DETAIL	FA_DEPRN_PERIODS	FA_MC_DEPRN_DETAIL.BOOK_TYPE_CODE FA_MC_DEPRN_DETAIL.PERIOD_COUNTER
FA_MC_DEPRN_DETAIL	GL_JE_LINES	FA_MC_DEPRN_DETAIL.JE_HEADER_ID FA_MC_DEPRN_DETAIL.DEPRN_EXPENSE_JE_LINE_NUM
FA_MC_DEPRN_DETAIL	GL_JE_LINES	FA_MC_DEPRN_DETAIL.JE_HEADER_ID FA_MC_DEPRN_DETAIL.DEPRN_RESERVE_JE_LINE_NUM
FA_MC_DEPRN_DETAIL	GL_JE_LINES	FA_MC_DEPRN_DETAIL.JE_HEADER_ID FA_MC_DEPRN_DETAIL.REVAL_AMORT_JE_LINE_NUM
FA_MC_DEPRN_DETAIL	GL_JE_LINES	FA_MC_DEPRN_DETAIL.JE_HEADER_ID FA_MC_DEPRN_DETAIL.REVAL_RESERVE_JE_LINE_NUM
FA_MC_DEPRN_DETAIL	GL_JE_HEADERS	FA_MC_DEPRN_DETAIL.JE_HEADER_ID