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

Source

View Text - Preformatted


select SET_OF_BOOKS_ID SET_OF_BOOKS_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, ASSET_ID ASSET_ID, 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, BONUS_DEPRN_AMOUNT BONUS_DEPRN_AMOUNT, BONUS_YTD_DEPRN BONUS_YTD_DEPRN, BONUS_DEPRN_RESERVE BONUS_DEPRN_RESERVE, PRIOR_FY_BONUS_EXPENSE PRIOR_FY_BONUS_EXPENSE, DEPRN_OVERRIDE_FLAG DEPRN_OVERRIDE_FLAG, SYSTEM_DEPRN_AMOUNT SYSTEM_DEPRN_AMOUNT, SYSTEM_BONUS_DEPRN_AMOUNT SYSTEM_BONUS_DEPRN_AMOUNT, EVENT_ID EVENT_ID, DEPRN_RUN_ID DEPRN_RUN_ID, REVERSAL_EVENT_ID REVERSAL_EVENT_ID, REVERSAL_DATE REVERSAL_DATE, DEPRN_ADJUSTMENT_AMOUNT DEPRN_ADJUSTMENT_AMOUNT, BONUS_DEPRN_ADJUSTMENT_AMOUNT BONUS_DEPRN_ADJUSTMENT_AMOUNT, IMPAIRMENT_AMOUNT IMPAIRMENT_AMOUNT, YTD_IMPAIRMENT YTD_IMPAIRMENT, IMPAIRMENT_RESERVE IMPAIRMENT_RESERVE, CAPITAL_ADJUSTMENT CAPITAL_ADJUSTMENT, GENERAL_FUND GENERAL_FUND, REVAL_LOSS_BALANCE REVAL_LOSS_BALANCE from "FA"."FA_MC_DEPRN_SUMMARY_H"

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, ASSET_ID ASSET_ID
, 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
, BONUS_DEPRN_AMOUNT BONUS_DEPRN_AMOUNT
, BONUS_YTD_DEPRN BONUS_YTD_DEPRN
, BONUS_DEPRN_RESERVE BONUS_DEPRN_RESERVE
, PRIOR_FY_BONUS_EXPENSE PRIOR_FY_BONUS_EXPENSE
, DEPRN_OVERRIDE_FLAG DEPRN_OVERRIDE_FLAG
, SYSTEM_DEPRN_AMOUNT SYSTEM_DEPRN_AMOUNT
, SYSTEM_BONUS_DEPRN_AMOUNT SYSTEM_BONUS_DEPRN_AMOUNT
, EVENT_ID EVENT_ID
, DEPRN_RUN_ID DEPRN_RUN_ID
, REVERSAL_EVENT_ID REVERSAL_EVENT_ID
, REVERSAL_DATE REVERSAL_DATE
, DEPRN_ADJUSTMENT_AMOUNT DEPRN_ADJUSTMENT_AMOUNT
, BONUS_DEPRN_ADJUSTMENT_AMOUNT BONUS_DEPRN_ADJUSTMENT_AMOUNT
, IMPAIRMENT_AMOUNT IMPAIRMENT_AMOUNT
, YTD_IMPAIRMENT YTD_IMPAIRMENT
, IMPAIRMENT_RESERVE IMPAIRMENT_RESERVE
, CAPITAL_ADJUSTMENT CAPITAL_ADJUSTMENT
, GENERAL_FUND GENERAL_FUND
, REVAL_LOSS_BALANCE REVAL_LOSS_BALANCE
FROM "FA"."FA_MC_DEPRN_SUMMARY_H"