[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FA_MASS_REVAL_REP_ITF |
|---|---|
| Object Type: | TABLE |
| Owner: | FA |
| FND Design Data: |  OFA.FA_MASS_REVAL_REP_ITF
|
| Subobject Name: | |
| Status: | VALID |
FA_MASS_REVAL_REP_ITF is an interface table that tracks mass revaluation transactions for preview reporting.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REQUEST_ID | NUMBER | (15) | Concurrent request identification number for the mass revaluation | |
| MASS_REVAL_ID | NUMBER | (15) | Unique mass revaluation identification number | |
| BOOK_TYPE_CODE | VARCHAR2 | (15) | Book name | |
| TRANSACTION_DATE_ENTERED | DATE | Date when transaction occurred | ||
| ASSET_ID | NUMBER | (15) | System generated asset identification number | |
| ASSET_NUMBER | VARCHAR2 | (15) | User assigned asset number | |
| DESCRIPTION | VARCHAR2 | (80) | Description of the asset | |
| ASSET_TYPE | VARCHAR2 | (15) | Indicates whether the asset is CIP, capitalized, expensed, or group | |
| ASSET_CATEGORY_ID | NUMBER | (15) | Unique identification number for the asset category key flexfield | |
| CATEGORY | VARCHAR2 | (240) | Concatenated segment values from the asset category key flexfield | |
| OLD_LIFE | NUMBER | Old life of the asset represented in months | ||
| NEW_LIFE | NUMBER | New life of the asset represented in months | ||
| OLD_COST | NUMBER | Old cost of the asset | ||
| NEW_COST | NUMBER | New cost of the asset | ||
| OLD_DEPRN_RESERVE | NUMBER | Old depreciation reserve | ||
| NEW_DEPRN_RESERVE | NUMBER | New depreciation reserve | ||
| OLD_REVAL_RESERVE | NUMBER | Old revaluation reserve | ||
| NEW_REVAL_RESERVE | NUMBER | New revaluation reserve | ||
| REVAL_CEILING | NUMBER | Upper limit for revaluing the asset cost | ||
| REVAL_PERCENT | NUMBER | Revaluation rate | ||
| OVERRIDE_DEFAULTS | VARCHAR2 | (80) | Indicates whether or not to override default revaluation rules | |
| REVAL_FULLY_RSVD | VARCHAR2 | (80) | Indicates whether or not to revalue fully reserved assets | |
| LIFE_EXTENSION_FACTOR | NUMBER | Factor by which to extend the life when revaluing a fully reserved asset | ||
| LIFE_EXTENSION_CEILING | NUMBER | Maximum factor by which the life of an asset can be multiplied when backing out depreciation during revaluation. Does not affect the actual asset life | ||
| MAX_FULLY_RSVD_REVALS | NUMBER | (15) | Maximum number of times an asset can be revalued as fully reserved | |
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
| CREATED_BY | NUMBER | (15) | Standard Who column | |
| CREATION_DATE | DATE | Standard Who column | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| OLD_NBV | NUMBER | Old Net Book Value. Used for SORP Compliance only | ||
| NEW_NBV | NUMBER | New Net Book Value . Used for SORP Compliance only |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, MASS_REVAL_ID
, BOOK_TYPE_CODE
, TRANSACTION_DATE_ENTERED
, ASSET_ID
, ASSET_NUMBER
, DESCRIPTION
, ASSET_TYPE
, ASSET_CATEGORY_ID
, CATEGORY
, OLD_LIFE
, NEW_LIFE
, OLD_COST
, NEW_COST
, OLD_DEPRN_RESERVE
, NEW_DEPRN_RESERVE
, OLD_REVAL_RESERVE
, NEW_REVAL_RESERVE
, REVAL_CEILING
, REVAL_PERCENT
, OVERRIDE_DEFAULTS
, REVAL_FULLY_RSVD
, LIFE_EXTENSION_FACTOR
, LIFE_EXTENSION_CEILING
, MAX_FULLY_RSVD_REVALS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, OLD_NBV
, NEW_NBV
FROM FA.FA_MASS_REVAL_REP_ITF;
FA.FA_MASS_REVAL_REP_ITF does not reference any database object
FA.FA_MASS_REVAL_REP_ITF is referenced by following:
FA
FA_MASS_REVAL_REP_ITF#
|
|
|
|