Retirements
The Retirements view object contains information about asset retirements. Oracle Fusion Assets inserts a row into this table when you retire an asset and updates it upon reinstatement.
Data Store Key : FscmTopModelAM.FinExtractAM.FaBiccExtractAM.RetirementExtractPVO
Primary Keys : RetirementRetirementId
Initial Extract Date : RetirementCreationDate
Incremental Extract Date : RetirementLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| RetirementAssetId | Identifier of the asset number. |
| RetirementAttribute1 | A segment for the Retirements descriptive flexfield. |
| RetirementAttribute10 | A segment for the Retirements descriptive flexfield. |
| RetirementAttribute11 | A segment for the Retirements descriptive flexfield. |
| RetirementAttribute12 | A segment for the Retirements descriptive flexfield. |
| RetirementAttribute13 | A segment for the Retirements descriptive flexfield. |
| RetirementAttribute14 | A segment for the Retirements descriptive flexfield. |
| RetirementAttribute15 | A segment for the Retirements descriptive flexfield. |
| RetirementAttribute2 | A segment for the Retirements descriptive flexfield. |
| RetirementAttribute3 | A segment for the Retirements descriptive flexfield. |
| RetirementAttribute4 | A segment for the Retirements descriptive flexfield. |
| RetirementAttribute5 | A segment for the Retirements descriptive flexfield. |
| RetirementAttribute6 | A segment for the Retirements descriptive flexfield. |
| RetirementAttribute7 | A segment for the Retirements descriptive flexfield. |
| RetirementAttribute8 | A segment for the Retirements descriptive flexfield. |
| RetirementAttribute9 | A segment for the Retirements descriptive flexfield. |
| RetirementAttributeCategoryCode | The context name for the Retirements descriptive flexfield. |
| RetirementAttributeDate1 | A date segment for the Retirements descriptive flexfield. |
| RetirementAttributeDate2 | A date segment for the Retirements descriptive flexfield. |
| RetirementAttributeDate3 | A date segment for the Retirements descriptive flexfield. |
| RetirementAttributeDate4 | A date segment for the Retirements descriptive flexfield. |
| RetirementAttributeDate5 | A date segment for the Retirements descriptive flexfield. |
| RetirementAttributeNumber1 | A number segment for the Retirements descriptive flexfield. |
| RetirementAttributeNumber2 | A number segment for the Retirements descriptive flexfield. |
| RetirementAttributeNumber3 | A number segment for the Retirements descriptive flexfield. |
| RetirementAttributeNumber4 | A number segment for the Retirements descriptive flexfield. |
| RetirementAttributeNumber5 | A number segment for the Retirements descriptive flexfield. |
| RetirementBonusReserveRetired | Reduction in the bonus depreciation reserve balance due to asset retirement. |
| RetirementBookTypeCode | Name of the asset book. |
| RetirementCostOfRemoval | Amount required to remove the retired asset. |
| RetirementCostRetired | A term used to describe how much of the current asset amount is retired. |
| RetirementCreatedBy | The user who created the retirement transaction. |
| RetirementCreationDate | The date the retirement transaction was created. |
| RetirementDateEffective | The date on which the retirement transaction is effective. |
| RetirementDateRetired | The date of the asset retirement. |
| RetirementEofyReserve | Depreciation reserve at the end of the previous fiscal year. |
| RetirementGainLossAmount | The gain or loss generated due to a retirement transaction. |
| RetirementGainLossTypeCode | Amount obtained as a result of disposing an asset. |
| RetirementImpairReserveRetired | Indicates the impairment reserve amount that is retired. |
| RetirementItcRecaptureId | Identifier for the investment tax credits recapture rate. |
| RetirementItcRecaptured | Recaptured amount from investment tax credits. |
| RetirementLastUpdateDate | The date of the most recent change. |
| RetirementLastUpdateLogin | The session login associated with the user who last updated the retirement transaction. |
| RetirementLastUpdatedBy | The user who last updated the retirement transaction. |
| RetirementLimitProceedsFlag | Indicates whether the member asset proceeds of sale should be limited to its recoverable cost. |
| RetirementNbvRetired | Net book value of an asset at the time of retirement. |
| RetirementObjectVersionNumber | The number of times the Reporting Retirements row has been updated. |
| RetirementProceedsOfSale | Amount received from the sale of an asset. |
| RetirementRecaptureAmount | The amount the sales proceeds of a member asset retirement exceed the group asset depreciation reserve. |
| RetirementRecaptureReserveFlag | Indicates whether the accumulated depreciation of a group asset can exceed its recoverable cost without triggering the recognition of a gain. |
| RetirementRecognizeGainLoss | Indicates whether to recognize gain or loss immediately for member assets. |
| RetirementReductionRate | Rate used by a group asset to calculate reduced depreciation for its member assets based on the depreciable basis rule. |
| RetirementReferenceNum | Unique internal reference number for retirement transactions. |
| RetirementReserveRetired | Depreciation reserve retired along with the asset. |
| RetirementRetirementConventionTypeId | The identifier of the prorate convention for retirements. |
| RetirementRetirementId | Identifier of the asset retirement transaction. |
| RetirementRetirementTypeCode | Reason for the retirement of an asset. |
| RetirementRevalReserveRetired | The amount of revaluation reserve that was retired. |
| RetirementSoldTo | Name of the party to whom the asset was sold as part of retirement. |
| RetirementStatus | Status of the retirement transaction. |
| RetirementStlDeprnAmount | Straight line depreciation amount for the reporting of 1250 property in a tax book. |
| RetirementStlMethodId | Identifier of the straight line depreciation method used to calculate the depreciation for a retirement transaction. |
| RetirementTerminalGainLoss | Indicates how the remaining accumulated depreciation balance in the group asset is treated when the member asset being retired or transferred out is the last member asset in the group asset, and no additional asset will be added to the group asset. |
| RetirementTradeInAssetId | Asset identification number of the new asset for which the retired asset was traded in. |
| RetirementTransactionHeaderIdIn | Identifier of the transaction that created the row. |
| RetirementTransactionHeaderIdOut | Identifier of the transaction that terminated the row. |
| RetirementUnits | Number of units retired in the transaction. |
| RetirementUnrevaluedCostRetired | Cost retired without regard to any revaluations. |