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.

VIEW: FA.FA_MC_GROUP_DEPRN_DETAIL#

Source

View Text - Preformatted


select SET_OF_BOOKS_ID SET_OF_BOOKS_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, GROUP_ASSET_ID GROUP_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, SOURCE_DEPRN_AMOUNT SOURCE_DEPRN_AMOUNT, SOURCE_YTD_DEPRN SOURCE_YTD_DEPRN, SOURCE_DEPRN_RESERVE SOURCE_DEPRN_RESERVE, SOURCE_ADDITION_COST_TO_CLEAR SOURCE_ADDITION_COST_TO_CLEAR, SOURCE_DEPRN_ADJUSTMENT_AMOUNT SOURCE_DEPRN_ADJUSTMENT_AMOUNT, SOURCE_REVAL_AMORTIZATION SOURCE_REVAL_AMORTIZATION, SOURCE_REVAL_DEPRN_EXPENSE SOURCE_REVAL_DEPRN_EXPENSE, SOURCE_REVAL_RESERVE SOURCE_REVAL_RESERVE, SOURCE_YTD_REVAL_DEPRN_EXPENSE SOURCE_YTD_REVAL_DEPRN_EXPENSE, CONVERTED_FLAG CONVERTED_FLAG from "FA"."FA_MC_GROUP_DEPRN_DETAIL"

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, GROUP_ASSET_ID GROUP_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
, SOURCE_DEPRN_AMOUNT SOURCE_DEPRN_AMOUNT
, SOURCE_YTD_DEPRN SOURCE_YTD_DEPRN
, SOURCE_DEPRN_RESERVE SOURCE_DEPRN_RESERVE
, SOURCE_ADDITION_COST_TO_CLEAR SOURCE_ADDITION_COST_TO_CLEAR
, SOURCE_DEPRN_ADJUSTMENT_AMOUNT SOURCE_DEPRN_ADJUSTMENT_AMOUNT
, SOURCE_REVAL_AMORTIZATION SOURCE_REVAL_AMORTIZATION
, SOURCE_REVAL_DEPRN_EXPENSE SOURCE_REVAL_DEPRN_EXPENSE
, SOURCE_REVAL_RESERVE SOURCE_REVAL_RESERVE
, SOURCE_YTD_REVAL_DEPRN_EXPENSE SOURCE_YTD_REVAL_DEPRN_EXPENSE
, CONVERTED_FLAG CONVERTED_FLAG
FROM "FA"."FA_MC_GROUP_DEPRN_DETAIL"