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 |