[Home] [Help] [Dependency Information]
Object Name: | IGI_IAC_REVAL_HISTORY |
---|---|
Object Type: | TABLE |
Owner: | IGI |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSET_ID | NUMBER | (15) | Yes | Asset identifier |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Book to which asset belongs. |
ADJUSTMENT_ID | NUMBER | (15) | Yes | Adjustment from the transaction headers |
PERIOD_COUNTER | NUMBER | (15) | Period in which the transaction had been performed | |
REVALUATION_TYPE | VARCHAR2 | (30) | Type of Reavaluation performed on the asset | |
REVALUATION_METHOD | VARCHAR2 | (30) | Method of Revaluation - Indexed or Professional | |
EFFECTIVE_PERIOD | VARCHAR2 | (30) | Effective period for catchup due to reclassification, adjustment or prior period addition | |
PERIOD_ENTERED | VARCHAR2 | (30) | Period when the transaction has been performed. | |
PRE_REVAL_COST | NUMBER | Previous revalued cost before the transaction happened | ||
NEW_REVAL_COST | NUMBER | Current revalued cost after the transaction happened |
Cut, paste (and edit) the following text to query this object:
SELECT ASSET_ID
, BOOK_TYPE_CODE
, ADJUSTMENT_ID
, PERIOD_COUNTER
, REVALUATION_TYPE
, REVALUATION_METHOD
, EFFECTIVE_PERIOD
, PERIOD_ENTERED
, PRE_REVAL_COST
, NEW_REVAL_COST
FROM IGI.IGI_IAC_REVAL_HISTORY;
IGI.IGI_IAC_REVAL_HISTORY does not reference any database object
IGI.IGI_IAC_REVAL_HISTORY is referenced by following:
|
|
|