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: IGI.IGI_MHC_RESERVE_LEDGER#

Source

View Text - Preformatted


select ASSET_ID ASSET_ID, DH_CCID DH_CCID, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE, METHOD_CODE METHOD_CODE, LIFE LIFE, RATE RATE, CAPACITY CAPACITY, COST COST, DEPRN_AMOUNT DEPRN_AMOUNT, YTD_DEPRN YTD_DEPRN, PERCENT PERCENT, TRANSACTION_TYPE TRANSACTION_TYPE, DEPRN_RESERVE DEPRN_RESERVE, PERIOD_COUNTER PERIOD_COUNTER, DATE_EFFECTIVE DATE_EFFECTIVE, DEPRN_RESERVE_ACCT DEPRN_RESERVE_ACCT, RESERVE_ACCT RESERVE_ACCT, DISTRIBUTION_ID DISTRIBUTION_ID, REVAL_RESERVE REVAL_RESERVE, BACKLOG_RESERVE BACKLOG_RESERVE, BACKLOG_RESERVE_ACCT BACKLOG_RESERVE_ACCT from "IGI"."IGI_MHC_RESERVE_LEDGER"

View Text - HTML Formatted

SELECT ASSET_ID ASSET_ID
, DH_CCID DH_CCID
, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE
, METHOD_CODE METHOD_CODE
, LIFE LIFE
, RATE RATE
, CAPACITY CAPACITY
, COST COST
, DEPRN_AMOUNT DEPRN_AMOUNT
, YTD_DEPRN YTD_DEPRN
, PERCENT PERCENT
, TRANSACTION_TYPE TRANSACTION_TYPE
, DEPRN_RESERVE DEPRN_RESERVE
, PERIOD_COUNTER PERIOD_COUNTER
, DATE_EFFECTIVE DATE_EFFECTIVE
, DEPRN_RESERVE_ACCT DEPRN_RESERVE_ACCT
, RESERVE_ACCT RESERVE_ACCT
, DISTRIBUTION_ID DISTRIBUTION_ID
, REVAL_RESERVE REVAL_RESERVE
, BACKLOG_RESERVE BACKLOG_RESERVE
, BACKLOG_RESERVE_ACCT BACKLOG_RESERVE_ACCT
FROM "IGI"."IGI_MHC_RESERVE_LEDGER"