1. Tables and Views for Financials
  2. FA_MC_RETIREMENTS

FA_MC_RETIREMENTS

FA_MC_RETIREMENTS contains currency and financial information about asset retirements in each reporting book, associated with the parent record in FA_RETIREMENTS. Oracle Fusion Assets uses the information in this table to calculate the gains and losses on asset retirements in the reporting book. It is an MRC sub-table of FA_RETIREMENTS.

Details

  • Schema: FUSION

  • Object owner: FA

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

FA_MC_RETIREMENTS_PK

SET_OF_BOOKS_ID, RETIREMENT_ID

Columns

Name Datatype Length Precision Not-null Comments
SET_OF_BOOKS_ID NUMBER 18 Yes Identifier of the accounting ledger.
RETIREMENT_ID NUMBER 18 Yes Identifier of the asset retirement transaction.
COST_RETIRED NUMBER Yes Amount of cost retired from the asset.
STATUS VARCHAR2 15 Yes Status of the retirement 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.
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 the 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.
CONVERTED_FLAG VARCHAR2 1 Yes Status Indicating whether the transaction amounts have been converted to the reporting currency.
BONUS_RESERVE_RETIRED NUMBER Bonus depreciation reserve retired.
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.
TRANSACTION_HEADER_ID_OUT NUMBER 18 Identifier of the transaction that terminated the row.
DATE_RETIRED DATE Yes Date on which an asset was retired.
DATE_EFFECTIVE DATE Yes Date when the row became effective.
RETIREMENT_CONVENTION_TYPE_ID NUMBER 18 Identifier of the prorate convention.
UNITS NUMBER Number of units retired in the transaction.
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 in.
RECOGNIZE_GAIN_LOSS VARCHAR2 30 Option indicating whether gain or loss should be recognized for member asset retirement.
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.
LIMIT_PROCEEDS_FLAG VARCHAR2 1 Option indicating whether the member asset proceed of sale to be limited to its recoverable cost.
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.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
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.
ATTRIBUTE_CATEGORY_CODE VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield.
TERMINATE_IB_ASSET_FLAG VARCHAR2 1 Indicates whether to terminate the associated installed base asset when a fixed asset is retired.

Foreign Keys

Table Foreign Table Foreign Key Column
FA_MC_RETIREMENTS fa_book_controls BOOK_TYPE_CODE
FA_MC_RETIREMENTS fa_itc_recapture_rates ITC_RECAPTURE_ID
FA_MC_RETIREMENTS fa_mc_book_controls SET_OF_BOOKS_ID, BOOK_TYPE_CODE
FA_MC_RETIREMENTS fa_additions_b ASSET_ID
FA_MC_RETIREMENTS fa_transaction_headers TRANSACTION_HEADER_ID_IN, BOOK_TYPE_CODE
FA_MC_RETIREMENTS fa_transaction_headers TRANSACTION_HEADER_ID_OUT, BOOK_TYPE_CODE
FA_MC_RETIREMENTS gl_ledgers SET_OF_BOOKS_ID
FA_MC_RETIREMENTS fa_convention_types RETIREMENT_CONVENTION_TYPE_ID
FA_MC_RETIREMENTS fa_additions_b TRADE_IN_ASSET_ID
FA_MC_RETIREMENTS fa_methods STL_METHOD_ID
fa_mc_books fa_mc_retirements SET_OF_BOOKS_ID, RETIREMENT_ID

Indexes

Index Uniqueness Tablespace Columns
FA_MC_RETIREMENTS_N1 Non Unique Default SET_OF_BOOKS_ID, ASSET_ID, BOOK_TYPE_CODE
FA_MC_RETIREMENTS_N2 Non Unique Default SET_OF_BOOKS_ID, TRANSACTION_HEADER_ID_OUT
FA_MC_RETIREMENTS_U1 Unique Default SET_OF_BOOKS_ID, RETIREMENT_ID
FA_MC_RETIREMENTS_U2 Unique Default SET_OF_BOOKS_ID, TRANSACTION_HEADER_ID_IN