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]

VIEW: FA.FA_MC_DEPRN_DETAIL_H#

Source

View Text - Preformatted


select SET_OF_BOOKS_ID SET_OF_BOOKS_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, ASSET_ID ASSET_ID, PERIOD_COUNTER PERIOD_COUNTER, DISTRIBUTION_ID DISTRIBUTION_ID, DEPRN_SOURCE_CODE DEPRN_SOURCE_CODE, DEPRN_RUN_DATE DEPRN_RUN_DATE, DEPRN_AMOUNT DEPRN_AMOUNT, YTD_DEPRN YTD_DEPRN, DEPRN_RESERVE DEPRN_RESERVE, ADDITION_COST_TO_CLEAR ADDITION_COST_TO_CLEAR, COST COST, DEPRN_ADJUSTMENT_AMOUNT DEPRN_ADJUSTMENT_AMOUNT, REVAL_AMORTIZATION REVAL_AMORTIZATION, REVAL_DEPRN_EXPENSE REVAL_DEPRN_EXPENSE, REVAL_RESERVE REVAL_RESERVE, YTD_REVAL_DEPRN_EXPENSE YTD_REVAL_DEPRN_EXPENSE, BONUS_DEPRN_AMOUNT BONUS_DEPRN_AMOUNT, BONUS_YTD_DEPRN BONUS_YTD_DEPRN, BONUS_DEPRN_RESERVE BONUS_DEPRN_RESERVE, BONUS_DEPRN_ADJUSTMENT_AMOUNT BONUS_DEPRN_ADJUSTMENT_AMOUNT, DEPRN_EXPENSE_CCID DEPRN_EXPENSE_CCID, DEPRN_RESERVE_CCID DEPRN_RESERVE_CCID, BONUS_DEPRN_EXPENSE_CCID BONUS_DEPRN_EXPENSE_CCID, BONUS_DEPRN_RESERVE_CCID BONUS_DEPRN_RESERVE_CCID, REVAL_AMORT_CCID REVAL_AMORT_CCID, REVAL_RESERVE_CCID REVAL_RESERVE_CCID, EVENT_ID EVENT_ID, DEPRN_RUN_ID DEPRN_RUN_ID, REVERSAL_EVENT_ID REVERSAL_EVENT_ID, REVERSAL_DATE REVERSAL_DATE, IMPAIRMENT_AMOUNT IMPAIRMENT_AMOUNT, YTD_IMPAIRMENT YTD_IMPAIRMENT, IMPAIRMENT_RESERVE IMPAIRMENT_RESERVE, CAPITAL_ADJUSTMENT CAPITAL_ADJUSTMENT, GENERAL_FUND GENERAL_FUND from "FA"."FA_MC_DEPRN_DETAIL_H"

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, ASSET_ID ASSET_ID
, PERIOD_COUNTER PERIOD_COUNTER
, DISTRIBUTION_ID DISTRIBUTION_ID
, DEPRN_SOURCE_CODE DEPRN_SOURCE_CODE
, DEPRN_RUN_DATE DEPRN_RUN_DATE
, DEPRN_AMOUNT DEPRN_AMOUNT
, YTD_DEPRN YTD_DEPRN
, DEPRN_RESERVE DEPRN_RESERVE
, ADDITION_COST_TO_CLEAR ADDITION_COST_TO_CLEAR
, COST COST
, DEPRN_ADJUSTMENT_AMOUNT DEPRN_ADJUSTMENT_AMOUNT
, REVAL_AMORTIZATION REVAL_AMORTIZATION
, REVAL_DEPRN_EXPENSE REVAL_DEPRN_EXPENSE
, REVAL_RESERVE REVAL_RESERVE
, YTD_REVAL_DEPRN_EXPENSE YTD_REVAL_DEPRN_EXPENSE
, BONUS_DEPRN_AMOUNT BONUS_DEPRN_AMOUNT
, BONUS_YTD_DEPRN BONUS_YTD_DEPRN
, BONUS_DEPRN_RESERVE BONUS_DEPRN_RESERVE
, BONUS_DEPRN_ADJUSTMENT_AMOUNT BONUS_DEPRN_ADJUSTMENT_AMOUNT
, DEPRN_EXPENSE_CCID DEPRN_EXPENSE_CCID
, DEPRN_RESERVE_CCID DEPRN_RESERVE_CCID
, BONUS_DEPRN_EXPENSE_CCID BONUS_DEPRN_EXPENSE_CCID
, BONUS_DEPRN_RESERVE_CCID BONUS_DEPRN_RESERVE_CCID
, REVAL_AMORT_CCID REVAL_AMORT_CCID
, REVAL_RESERVE_CCID REVAL_RESERVE_CCID
, EVENT_ID EVENT_ID
, DEPRN_RUN_ID DEPRN_RUN_ID
, REVERSAL_EVENT_ID REVERSAL_EVENT_ID
, REVERSAL_DATE REVERSAL_DATE
, IMPAIRMENT_AMOUNT IMPAIRMENT_AMOUNT
, YTD_IMPAIRMENT YTD_IMPAIRMENT
, IMPAIRMENT_RESERVE IMPAIRMENT_RESERVE
, CAPITAL_ADJUSTMENT CAPITAL_ADJUSTMENT
, GENERAL_FUND GENERAL_FUND
FROM "FA"."FA_MC_DEPRN_DETAIL_H"