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_DEPRN_DETAIL#

Source

View Text - Preformatted


select 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, DEPRN_EXPENSE_JE_LINE_NUM DEPRN_EXPENSE_JE_LINE_NUM, DEPRN_RESERVE_JE_LINE_NUM DEPRN_RESERVE_JE_LINE_NUM, REVAL_AMORT_JE_LINE_NUM REVAL_AMORT_JE_LINE_NUM, REVAL_RESERVE_JE_LINE_NUM REVAL_RESERVE_JE_LINE_NUM, JE_HEADER_ID JE_HEADER_ID, 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, BONUS_DEPRN_EXP_JE_LINE_NUM BONUS_DEPRN_EXP_JE_LINE_NUM, BONUS_DEPRN_RSV_JE_LINE_NUM BONUS_DEPRN_RSV_JE_LINE_NUM, 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, IMPAIRMENT_AMOUNT IMPAIRMENT_AMOUNT, YTD_IMPAIRMENT YTD_IMPAIRMENT, IMPAIRMENT_RESERVE IMPAIRMENT_RESERVE, CAPITAL_ADJUSTMENT CAPITAL_ADJUSTMENT, GENERAL_FUND GENERAL_FUND from "FA"."FA_DEPRN_DETAIL"

View Text - HTML Formatted

SELECT 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
, DEPRN_EXPENSE_JE_LINE_NUM DEPRN_EXPENSE_JE_LINE_NUM
, DEPRN_RESERVE_JE_LINE_NUM DEPRN_RESERVE_JE_LINE_NUM
, REVAL_AMORT_JE_LINE_NUM REVAL_AMORT_JE_LINE_NUM
, REVAL_RESERVE_JE_LINE_NUM REVAL_RESERVE_JE_LINE_NUM
, JE_HEADER_ID JE_HEADER_ID
, 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
, BONUS_DEPRN_EXP_JE_LINE_NUM BONUS_DEPRN_EXP_JE_LINE_NUM
, BONUS_DEPRN_RSV_JE_LINE_NUM BONUS_DEPRN_RSV_JE_LINE_NUM
, 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
, IMPAIRMENT_AMOUNT IMPAIRMENT_AMOUNT
, YTD_IMPAIRMENT YTD_IMPAIRMENT
, IMPAIRMENT_RESERVE IMPAIRMENT_RESERVE
, CAPITAL_ADJUSTMENT CAPITAL_ADJUSTMENT
, GENERAL_FUND GENERAL_FUND
FROM "FA"."FA_DEPRN_DETAIL"