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

Source

View Text - Preformatted


select ADJUSTMENT_ID ADJUSTMENT_ID, ASSET_ID ASSET_ID, DISTRIBUTION_ID DISTRIBUTION_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, PERIOD_COUNTER PERIOD_COUNTER, ADJUSTMENT_COST ADJUSTMENT_COST, NET_BOOK_VALUE NET_BOOK_VALUE, REVAL_RESERVE_COST REVAL_RESERVE_COST, REVAL_RESERVE_BACKLOG REVAL_RESERVE_BACKLOG, REVAL_RESERVE_GEN_FUND REVAL_RESERVE_GEN_FUND, REVAL_RESERVE_NET REVAL_RESERVE_NET, OPERATING_ACCT_COST OPERATING_ACCT_COST, OPERATING_ACCT_BACKLOG OPERATING_ACCT_BACKLOG, OPERATING_ACCT_NET OPERATING_ACCT_NET, OPERATING_ACCT_YTD OPERATING_ACCT_YTD, DEPRN_PERIOD DEPRN_PERIOD, DEPRN_YTD DEPRN_YTD, DEPRN_RESERVE DEPRN_RESERVE, DEPRN_RESERVE_BACKLOG DEPRN_RESERVE_BACKLOG, GENERAL_FUND_PER GENERAL_FUND_PER, GENERAL_FUND_ACC GENERAL_FUND_ACC, LAST_REVAL_DATE LAST_REVAL_DATE, CURRENT_REVAL_FACTOR CURRENT_REVAL_FACTOR, CUMULATIVE_REVAL_FACTOR CUMULATIVE_REVAL_FACTOR, ACTIVE_FLAG ACTIVE_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY from "IGI"."IGI_IAC_DET_BALANCES"

View Text - HTML Formatted

SELECT ADJUSTMENT_ID ADJUSTMENT_ID
, ASSET_ID ASSET_ID
, DISTRIBUTION_ID DISTRIBUTION_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, PERIOD_COUNTER PERIOD_COUNTER
, ADJUSTMENT_COST ADJUSTMENT_COST
, NET_BOOK_VALUE NET_BOOK_VALUE
, REVAL_RESERVE_COST REVAL_RESERVE_COST
, REVAL_RESERVE_BACKLOG REVAL_RESERVE_BACKLOG
, REVAL_RESERVE_GEN_FUND REVAL_RESERVE_GEN_FUND
, REVAL_RESERVE_NET REVAL_RESERVE_NET
, OPERATING_ACCT_COST OPERATING_ACCT_COST
, OPERATING_ACCT_BACKLOG OPERATING_ACCT_BACKLOG
, OPERATING_ACCT_NET OPERATING_ACCT_NET
, OPERATING_ACCT_YTD OPERATING_ACCT_YTD
, DEPRN_PERIOD DEPRN_PERIOD
, DEPRN_YTD DEPRN_YTD
, DEPRN_RESERVE DEPRN_RESERVE
, DEPRN_RESERVE_BACKLOG DEPRN_RESERVE_BACKLOG
, GENERAL_FUND_PER GENERAL_FUND_PER
, GENERAL_FUND_ACC GENERAL_FUND_ACC
, LAST_REVAL_DATE LAST_REVAL_DATE
, CURRENT_REVAL_FACTOR CURRENT_REVAL_FACTOR
, CUMULATIVE_REVAL_FACTOR CUMULATIVE_REVAL_FACTOR
, ACTIVE_FLAG ACTIVE_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
FROM "IGI"."IGI_IAC_DET_BALANCES"