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

Source

View Text - Preformatted


select GROUP_ASSET_ID GROUP_ASSET_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, DEPRN_RUN_DATE DEPRN_RUN_DATE, DEPRN_AMOUNT DEPRN_AMOUNT, YTD_DEPRN YTD_DEPRN, DEPRN_RESERVE DEPRN_RESERVE, DEPRN_SOURCE_CODE DEPRN_SOURCE_CODE, ADJUSTED_COST ADJUSTED_COST, BONUS_RATE BONUS_RATE, LTD_PRODUCTION LTD_PRODUCTION, PERIOD_COUNTER PERIOD_COUNTER, PRODUCTION PRODUCTION, REVAL_AMORTIZATION REVAL_AMORTIZATION, REVAL_AMORTIZATION_BASIS REVAL_AMORTIZATION_BASIS, REVAL_DEPRN_EXPENSE REVAL_DEPRN_EXPENSE, REVAL_RESERVE REVAL_RESERVE, YTD_PRODUCTION YTD_PRODUCTION, YTD_REVAL_DEPRN_EXPENSE YTD_REVAL_DEPRN_EXPENSE, PRIOR_FY_EXPENSE PRIOR_FY_EXPENSE, DEPRN_RATE DEPRN_RATE from "FA"."FA_GROUP_DEPRN_SUMMARY"

View Text - HTML Formatted

SELECT GROUP_ASSET_ID GROUP_ASSET_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, DEPRN_RUN_DATE DEPRN_RUN_DATE
, DEPRN_AMOUNT DEPRN_AMOUNT
, YTD_DEPRN YTD_DEPRN
, DEPRN_RESERVE DEPRN_RESERVE
, DEPRN_SOURCE_CODE DEPRN_SOURCE_CODE
, ADJUSTED_COST ADJUSTED_COST
, BONUS_RATE BONUS_RATE
, LTD_PRODUCTION LTD_PRODUCTION
, PERIOD_COUNTER PERIOD_COUNTER
, PRODUCTION PRODUCTION
, REVAL_AMORTIZATION REVAL_AMORTIZATION
, REVAL_AMORTIZATION_BASIS REVAL_AMORTIZATION_BASIS
, REVAL_DEPRN_EXPENSE REVAL_DEPRN_EXPENSE
, REVAL_RESERVE REVAL_RESERVE
, YTD_PRODUCTION YTD_PRODUCTION
, YTD_REVAL_DEPRN_EXPENSE YTD_REVAL_DEPRN_EXPENSE
, PRIOR_FY_EXPENSE PRIOR_FY_EXPENSE
, DEPRN_RATE DEPRN_RATE
FROM "FA"."FA_GROUP_DEPRN_SUMMARY"