FA_RETIREMENTS
FA_RETIREMENTS contains information about asset retirements. Oracle Fusion Assets inserts a row into this table when you retire an asset and updates it if you reinstate the asset. When you perform a retirement, the row that Oracle Assets inserts has a TRANSACTION_HEADER_ID_IN and DATE_EFFECTIVE that matches the TRANSACTION_HEADER_ID and DATE_EFFECTIVE in FA_TRANSACTION_HEADERS. The TRANSACTION_HEADER_ID_OUT and DATE_INEFFECTIVE are NULL. If you reinstate a retirement for which Oracle Assets has calculated the gain or loss, Oracle Assets updates TRANSACTION_HEADER_ID_OUT and DATE_INEFFECTIVE with the TRANSACTION_HEADER_ID and DATE_EFFECTIVE from the FA_TRANSACTION_HEADERS row.
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FA_RETIREMENTS_PK |
RETIREMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| RETIREMENT_ID | NUMBER | 18 | Yes | Identifier of the asset retirement transaction. | ||
| BOOK_TYPE_CODE | VARCHAR2 | 30 | Yes | Unique book identification name. | ||
| ASSET_ID | NUMBER | 18 | Yes | Identifier of the asset number. | ||
| TRANSACTION_HEADER_ID_IN | NUMBER | 18 | Yes | Identifier of the transaction that created the row. | ||
| DATE_RETIRED | DATE | Yes | Date on which an asset was retired. | |||
| DATE_EFFECTIVE | DATE | Yes | Date when the row became effective. | |||
| COST_RETIRED | NUMBER | Yes | Amount of cost retired from the asset. | |||
| STATUS | VARCHAR2 | 15 | Yes | Status of the retirement transaction. | ||
| RETIREMENT_CONVENTION_TYPE_ID | NUMBER | 18 | Identifier of the prorate convention. | |||
| TRANSACTION_HEADER_ID_OUT | NUMBER | 18 | Identifier of the transaction that terminated the row. | |||
| UNITS | NUMBER | Number of units retired in the transaction. | ||||
| COST_OF_REMOVAL | NUMBER | Amount required to remove the retired asset. | ||||
| NBV_RETIRED | NUMBER | Net book value of an asset at the time of retirement. | ||||
| GAIN_LOSS_AMOUNT | NUMBER | Gain or loss amount from retiring an asset. | ||||
| PROCEEDS_OF_SALE | NUMBER | Amount received from the sale of an asset. | ||||
| GAIN_LOSS_TYPE_CODE | VARCHAR2 | 15 | Indicator of whether the retirement resulted in a gain or loss. | |||
| RETIREMENT_TYPE_CODE | VARCHAR2 | 30 | Reason why the asset is retired in the system. | |||
| REFERENCE_NUM | VARCHAR2 | 15 | Unique internal reference number for retirement transactions. | |||
| SOLD_TO | VARCHAR2 | 30 | Name of the party to whom the asset was sold as part of retirement. | |||
| TRADE_IN_ASSET_ID | NUMBER | 18 | Asset identification number of the new asset for which the retired asset was traded. | |||
| STL_METHOD_ID | NUMBER | 18 | Identifier of the straight line depreciation method used to calculate the depreciation for retirement transaction. | |||
| STL_DEPRN_AMOUNT | NUMBER | Straight line depreciation amount for reporting of 1250 property in a tax book. | ||||
| REVAL_RESERVE_RETIRED | NUMBER | Revaluation reserve retired at the time of retiring an asset. | ||||
| UNREVALUED_COST_RETIRED | NUMBER | Cost retired without any regard to any revaluations. | ||||
| BONUS_RESERVE_RETIRED | NUMBER | Bonus depreciation reserve retired. | ||||
| RECOGNIZE_GAIN_LOSS | VARCHAR2 | 30 | Option indicating whether gain or loss should be recognized for member asset retirement or not. | |||
| REDUCTION_RATE | NUMBER | Depreciation reduction percentage for the group and its member assets. | ||||
| RECAPTURE_RESERVE_FLAG | VARCHAR2 | 1 | Option indicating whether reserve for the group asset can exceed its recoverable cost or not. | |||
| LIMIT_PROCEEDS_FLAG | VARCHAR2 | 1 | Option indicating whether the member asset proceed of sale should be limited to its recoverable cost or not. | |||
| TERMINAL_GAIN_LOSS | VARCHAR2 | 30 | Option indicating how terminal gain or loss should be recognized for member asset retirement. | |||
| RESERVE_RETIRED | NUMBER | Depreciation reserve retired along with the asset. | ||||
| RECAPTURE_AMOUNT | NUMBER | Recaptured accumulated depreciation amount. | ||||
| EOFY_RESERVE | NUMBER | Depreciation reserve at the end of the previous fiscal year. | ||||
| IMPAIR_RESERVE_RETIRED | NUMBER | Impairment reserve amount which is retired. | ||||
| ITC_RECAPTURED | NUMBER | Recaptured amount from investment tax credits. | ||||
| ITC_RECAPTURE_ID | NUMBER | Identifier for the investment tax credits recapture rate. | ||||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
| ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| REVALUED_COST_RETIRED | NUMBER | Revalued cost amount retired for the asset. | ||||
| BACKLOG_RESERVE_RETIRED | NUMBER | Backlog depreciation reserve amount retired for the asset. | ||||
| REVAL_AMORTIZATION_RETIRED | NUMBER | Life-to-date revaluation reserve amortization amount for retirement. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| FA_RETIREMENTS | fa_book_controls | BOOK_TYPE_CODE |
| FA_RETIREMENTS | fa_additions_b | ASSET_ID |
| FA_RETIREMENTS | fa_transaction_headers | TRANSACTION_HEADER_ID_IN, BOOK_TYPE_CODE |
| FA_RETIREMENTS | fa_transaction_headers | TRANSACTION_HEADER_ID_OUT, BOOK_TYPE_CODE |
| FA_RETIREMENTS | fa_convention_types | RETIREMENT_CONVENTION_TYPE_ID |
| FA_RETIREMENTS | fa_additions_b | TRADE_IN_ASSET_ID |
| FA_RETIREMENTS | fa_methods | STL_METHOD_ID |
| FA_RETIREMENTS | fa_itc_recapture_rates | ITC_RECAPTURE_ID |
| fa_distribution_history | fa_retirements | RETIREMENT_ID |
| fa_mc_books | fa_retirements | RETIREMENT_ID |
| fa_books | fa_retirements | RETIREMENT_ID |
| fa_retirements_t | fa_retirements | RETIREMENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FA_RETIREMENTS_N1 | Non Unique | Default | ASSET_ID, BOOK_TYPE_CODE |
| FA_RETIREMENTS_N2 | Non Unique | Default | TRANSACTION_HEADER_ID_OUT |
| FA_RETIREMENTS_U1 | Unique | Default | RETIREMENT_ID |
| FA_RETIREMENTS_U2 | Unique | Default | TRANSACTION_HEADER_ID_IN |