[Home] [Help] [Dependency Information]
Object Name: | IGI_MHC_GEN_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | IGI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_SEQ_ID | NUMBER | (15) | Yes | |
LATEST_MASS_REVAL_ID | NUMBER | (15) | Yes | |
LATEST_TXN_HEADER_ID | NUMBER | (15) | Yes | |
LAST_DEPRN_PERIOD_COUNTER | NUMBER | (15) | Yes | |
ASSET_ID | NUMBER | (15) | Yes | |
DISTRIBUTION_ID | NUMBER | (15) | Yes | |
CATEGORY_ID | NUMBER | (15) | Yes | |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | |
CURRENT_MHC_PERIOD_COUNTER | NUMBER | (15) | Yes | |
PERIOD_COUNTER | NUMBER | Yes | ||
TRANSFER_DATA_FLAG | VARCHAR2 | (1) | Yes | |
UPGRADE_DATA_FLAG | VARCHAR2 | (1) | Yes | |
PURGE_DATA_FLAG | VARCHAR2 | (1) | Yes | |
NUMBER_OF_UNITS_ASSIGNED | NUMBER | (15) | ||
NUMBER_OF_UNITS_RETIRED | NUMBER | (15) | ||
ASSET_COST | NUMBER | |||
SALVAGE_VALUE | NUMBER | |||
ACCUMULATED_DEPRECIATION | NUMBER | |||
PRIOR_YRS_ACCUM_DEPRECIATION | NUMBER | |||
YTD_DEPRECIATION_RESERVE | NUMBER | |||
CURR_MHC_PRD_BACKLOG_DEPRN | NUMBER | |||
ACCUMULATED_BACKLOG_DEPRN | NUMBER | |||
NET_BOOK_VALUE | NUMBER | |||
REVALUATION_RESERVE | NUMBER | |||
DEPRECIATION_EXPENSE | NUMBER | |||
CURR_YEAR_OPERATING_EXPENSE | NUMBER | |||
CURR_YR_PRIOR_PRDS_DEPRN | NUMBER | |||
CURR_YR_PRIOR_PRDS_DEPRN_REVAL | NUMBER | |||
PRIOR_YEAR_OPERATING_EXPENSE | NUMBER | |||
GENERAL_FUND | NUMBER | |||
ACCUMULATED_GENERAL_FUND | NUMBER | |||
PRORATE_PERCENT | NUMBER | |||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
LAST_TXN_TYPE | VARCHAR2 | (30) | ||
GENERATE_SEQ_ID_IMPORT | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_SEQ_ID
, LATEST_MASS_REVAL_ID
, LATEST_TXN_HEADER_ID
, LAST_DEPRN_PERIOD_COUNTER
, ASSET_ID
, DISTRIBUTION_ID
, CATEGORY_ID
, BOOK_TYPE_CODE
, CURRENT_MHC_PERIOD_COUNTER
, PERIOD_COUNTER
, TRANSFER_DATA_FLAG
, UPGRADE_DATA_FLAG
, PURGE_DATA_FLAG
, NUMBER_OF_UNITS_ASSIGNED
, NUMBER_OF_UNITS_RETIRED
, ASSET_COST
, SALVAGE_VALUE
, ACCUMULATED_DEPRECIATION
, PRIOR_YRS_ACCUM_DEPRECIATION
, YTD_DEPRECIATION_RESERVE
, CURR_MHC_PRD_BACKLOG_DEPRN
, ACCUMULATED_BACKLOG_DEPRN
, NET_BOOK_VALUE
, REVALUATION_RESERVE
, DEPRECIATION_EXPENSE
, CURR_YEAR_OPERATING_EXPENSE
, CURR_YR_PRIOR_PRDS_DEPRN
, CURR_YR_PRIOR_PRDS_DEPRN_REVAL
, PRIOR_YEAR_OPERATING_EXPENSE
, GENERAL_FUND
, ACCUMULATED_GENERAL_FUND
, PRORATE_PERCENT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_BY
, LAST_UPDATE_LOGIN
, LAST_TXN_TYPE
, GENERATE_SEQ_ID_IMPORT
FROM IGI.IGI_MHC_GEN_INTERFACE#;
|
|
|