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

Source

View Text - Preformatted


select INTERFACE_SEQ_ID INTERFACE_SEQ_ID, LATEST_MASS_REVAL_ID LATEST_MASS_REVAL_ID, LATEST_TXN_HEADER_ID LATEST_TXN_HEADER_ID, LAST_DEPRN_PERIOD_COUNTER LAST_DEPRN_PERIOD_COUNTER, ASSET_ID ASSET_ID, DISTRIBUTION_ID DISTRIBUTION_ID, CATEGORY_ID CATEGORY_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, CURRENT_MHC_PERIOD_COUNTER CURRENT_MHC_PERIOD_COUNTER, PERIOD_COUNTER PERIOD_COUNTER, TRANSFER_DATA_FLAG TRANSFER_DATA_FLAG, UPGRADE_DATA_FLAG UPGRADE_DATA_FLAG, PURGE_DATA_FLAG PURGE_DATA_FLAG, NUMBER_OF_UNITS_ASSIGNED NUMBER_OF_UNITS_ASSIGNED, NUMBER_OF_UNITS_RETIRED NUMBER_OF_UNITS_RETIRED, ASSET_COST ASSET_COST, SALVAGE_VALUE SALVAGE_VALUE, ACCUMULATED_DEPRECIATION ACCUMULATED_DEPRECIATION, PRIOR_YRS_ACCUM_DEPRECIATION PRIOR_YRS_ACCUM_DEPRECIATION, YTD_DEPRECIATION_RESERVE YTD_DEPRECIATION_RESERVE, CURR_MHC_PRD_BACKLOG_DEPRN CURR_MHC_PRD_BACKLOG_DEPRN, ACCUMULATED_BACKLOG_DEPRN ACCUMULATED_BACKLOG_DEPRN, NET_BOOK_VALUE NET_BOOK_VALUE, REVALUATION_RESERVE REVALUATION_RESERVE, DEPRECIATION_EXPENSE DEPRECIATION_EXPENSE, CURR_YEAR_OPERATING_EXPENSE CURR_YEAR_OPERATING_EXPENSE, CURR_YR_PRIOR_PRDS_DEPRN CURR_YR_PRIOR_PRDS_DEPRN, CURR_YR_PRIOR_PRDS_DEPRN_REVAL CURR_YR_PRIOR_PRDS_DEPRN_REVAL, PRIOR_YEAR_OPERATING_EXPENSE PRIOR_YEAR_OPERATING_EXPENSE, GENERAL_FUND GENERAL_FUND, ACCUMULATED_GENERAL_FUND ACCUMULATED_GENERAL_FUND, PRORATE_PERCENT PRORATE_PERCENT, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_BY LAST_UPDATE_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_TXN_TYPE LAST_TXN_TYPE, GENERATE_SEQ_ID_IMPORT GENERATE_SEQ_ID_IMPORT from "IGI"."IGI_MHC_GEN_INTERFACE"

View Text - HTML Formatted

SELECT INTERFACE_SEQ_ID INTERFACE_SEQ_ID
, LATEST_MASS_REVAL_ID LATEST_MASS_REVAL_ID
, LATEST_TXN_HEADER_ID LATEST_TXN_HEADER_ID
, LAST_DEPRN_PERIOD_COUNTER LAST_DEPRN_PERIOD_COUNTER
, ASSET_ID ASSET_ID
, DISTRIBUTION_ID DISTRIBUTION_ID
, CATEGORY_ID CATEGORY_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, CURRENT_MHC_PERIOD_COUNTER CURRENT_MHC_PERIOD_COUNTER
, PERIOD_COUNTER PERIOD_COUNTER
, TRANSFER_DATA_FLAG TRANSFER_DATA_FLAG
, UPGRADE_DATA_FLAG UPGRADE_DATA_FLAG
, PURGE_DATA_FLAG PURGE_DATA_FLAG
, NUMBER_OF_UNITS_ASSIGNED NUMBER_OF_UNITS_ASSIGNED
, NUMBER_OF_UNITS_RETIRED NUMBER_OF_UNITS_RETIRED
, ASSET_COST ASSET_COST
, SALVAGE_VALUE SALVAGE_VALUE
, ACCUMULATED_DEPRECIATION ACCUMULATED_DEPRECIATION
, PRIOR_YRS_ACCUM_DEPRECIATION PRIOR_YRS_ACCUM_DEPRECIATION
, YTD_DEPRECIATION_RESERVE YTD_DEPRECIATION_RESERVE
, CURR_MHC_PRD_BACKLOG_DEPRN CURR_MHC_PRD_BACKLOG_DEPRN
, ACCUMULATED_BACKLOG_DEPRN ACCUMULATED_BACKLOG_DEPRN
, NET_BOOK_VALUE NET_BOOK_VALUE
, REVALUATION_RESERVE REVALUATION_RESERVE
, DEPRECIATION_EXPENSE DEPRECIATION_EXPENSE
, CURR_YEAR_OPERATING_EXPENSE CURR_YEAR_OPERATING_EXPENSE
, CURR_YR_PRIOR_PRDS_DEPRN CURR_YR_PRIOR_PRDS_DEPRN
, CURR_YR_PRIOR_PRDS_DEPRN_REVAL CURR_YR_PRIOR_PRDS_DEPRN_REVAL
, PRIOR_YEAR_OPERATING_EXPENSE PRIOR_YEAR_OPERATING_EXPENSE
, GENERAL_FUND GENERAL_FUND
, ACCUMULATED_GENERAL_FUND ACCUMULATED_GENERAL_FUND
, PRORATE_PERCENT PRORATE_PERCENT
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_BY LAST_UPDATE_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_TXN_TYPE LAST_TXN_TYPE
, GENERATE_SEQ_ID_IMPORT GENERATE_SEQ_ID_IMPORT
FROM "IGI"."IGI_MHC_GEN_INTERFACE"