[Home] [Help] [Dependency Information]
Object Name: | IGI_MHC_REVALUATION_DETAIL |
---|---|
Object Type: | TABLE |
Owner: | IGI |
FND Design Data: | IGI.IGI_MHC_REVALUATION_DETAIL |
Subobject Name: | |
Status: | VALID |
IGI_MHC_REVALUATION_DETAIL holds the details of an asset at the distribution level after it has been Revalued.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGI_MHC_REVALUATION_DETAIL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BOOK_TYPE_CODE
ASSET_ID |
IGI_MHC_REVALUATION_DETAIL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
MASS_REVAL_ID
ASSET_ID |
IGI_MHC_REVALUATION_DETAIL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DETAIL_SEQ_ID |
IGI_MHC_REVAL_DETAIL_T_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ASSET_ID
BOOK_TYPE_CODE PERIOD_COUNTER REVAL_MODE RUN_MODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DETAIL_SEQ_ID | NUMBER | (15) | Yes | Sequence to order the records in order of their creation. |
MASS_REVAL_ID | NUMBER | (15) | Yes | MASS_REVAL_ID from the IGI_MHC_IDX_REVALUATION table which identifies each run of Revaluation. |
ASSET_ID | NUMBER | (15) | Yes | Asset Identifier |
CATEGORY_ID | NUMBER | (15) | Yes | Category Identifier to which the asset belongs. |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Name of the book |
DISTRIBUTION_ID | NUMBER | (15) | Yes | Identifies the distribution line that contains the asset |
CURRENT_MHC_PERIOD_COUNTER | NUMBER | (15) | Yes | Current Modified Historic Cost Accounting Counter |
PERIOD_COUNTER | NUMBER | Yes | Current Depreciation Period Counter | |
REVAL_MODE | VARCHAR2 | (30) | The type of Revaluation that resulted in this record. For example INDEXED, CATCHUP or ADHOC | |
NUMBER_OF_UNITS_ASSIGNED | NUMBER | (15) | The number of units that have been assigned for this distribution. | |
NUMBER_OF_UNITS_RETIRED | NUMBER | (15) | The number of units which have been retired for this distribution. | |
LIFE_CHANGE_COUNT | NUMBER | (15) | The number of times the Life of the asset has been changed. | |
RUN_MODE | VARCHAR2 | (1) | The mode in which the Revaluation process was run , For example Preview (P) or Live (L) | |
ACTIVE_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate the latest active record. This flag is used if there were many transactions that the asset has been through in the same period. |
ASSET_COST | NUMBER | Asset Cost apportioned for the Distribution Unit | ||
SALVAGE_VALUE | NUMBER | Salvage Value of the Asset, which is the value of the asset after it has been fully depreciated. | ||
ACCUMULATED_DEPRECIATION | NUMBER | Depreciation reserve for the asset allocated to the distribution line as calculated by the Modified Historic Cost Accounting processes. | ||
PRIOR_YRS_ACCUM_DEPRECIATION | NUMBER | Depreciation reserve for the asset allocated to the distribution line for the previous years. | ||
YTD_DEPRECIATION_RESERVE | NUMBER | Year-to-date depreciation expense allocated to the distribution line as calculated by the Modified Historic Cost Accounting processes. | ||
CURR_MHC_PRD_BACKLOG_DEPRN | NUMBER | Extra Depreciation calculated for the current period as a result of Revaluation. | ||
ACCUMULATED_BACKLOG_DEPRN | NUMBER | Sum of the extra Depreciation calculated over the periods as a result of Revaluation for the distribution | ||
NET_BOOK_VALUE | NUMBER | Net Book Value, which equals the Recoverable Cost less the Depreciation Reserve | ||
REVALUATION_RESERVE | NUMBER | For a period in which this asset was revalued: change in net book value due to revaluation of the asset cost and sometimes also revaluation of depreciation reserve. For all other periods: revaluation reserve amount after depreciation run. This figure is as calcuated by the Modified Historic Cost Accounting Revaluation Engine. | ||
DEPRECIATION_EXPENSE | NUMBER | Depreciation expense allocated to the distribution line for the current period | ||
CURR_YEAR_OPERATING_EXPENSE | NUMBER | Amount in the Profit Loss Accounts for the Current Year | ||
CURR_YR_PRIOR_PRDS_DEPRN | NUMBER | Current Year Depreciation portion attributed till the last period | ||
CURR_YR_PRIOR_PRDS_DEPRN_REVAL | NUMBER | Revaluation of the Current year Depreciation Expense | ||
PRIOR_YEAR_OPERATING_EXPENSE | NUMBER | Amount in the Profit Loss Accounts for the Previous Year | ||
GENERAL_FUND | NUMBER | General Fund holds the Initial capital, apart from that financed from long term borrowing or Public Dividend Capital, plus subsequent movements in net assets, except where separate reserve accounts are operated. | ||
ACCUMULATED_GENERAL_FUND | NUMBER | The Sum of the General Fund for each distribution of the Asset for the fiscal year | ||
PROCESS_STATUS_CODE | VARCHAR2 | (1) | Processing status code. Upwards revaluation ('U'), Downwards revaluation ('D'), Temporary Negative ('T'), Not Revalued ('N') and Excluded from Revaluation ('X'). | |
DEPRN_PROCESSED_FLAG | VARCHAR2 | (240) | Whether the record has been processed by Depreciation Post process. Valid values are 'Y','N' and 'R' | |
PRORATE_PERCENT | NUMBER | Prorate Percent is the ratio of the period between the Assets Date Placed in Service and the Prorate Start Date. This is used by the Revaluation Engine in the calculation of the Catchup Revaluation. | ||
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATE_BY | NUMBER | (15) | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
Cut, paste (and edit) the following text to query this object:
SELECT DETAIL_SEQ_ID
, MASS_REVAL_ID
, ASSET_ID
, CATEGORY_ID
, BOOK_TYPE_CODE
, DISTRIBUTION_ID
, CURRENT_MHC_PERIOD_COUNTER
, PERIOD_COUNTER
, REVAL_MODE
, NUMBER_OF_UNITS_ASSIGNED
, NUMBER_OF_UNITS_RETIRED
, LIFE_CHANGE_COUNT
, RUN_MODE
, ACTIVE_FLAG
, 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
, PROCESS_STATUS_CODE
, DEPRN_PROCESSED_FLAG
, PRORATE_PERCENT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_BY
, LAST_UPDATE_LOGIN
FROM IGI.IGI_MHC_REVALUATION_DETAIL;
IGI.IGI_MHC_REVALUATION_DETAIL does not reference any database object
IGI.IGI_MHC_REVALUATION_DETAIL is referenced by following:
|
|
|