ReportingBookAssetRetirement

A retirement transaction stores information such as the retirement date, cost retired, retirement convention, and gain or loss in the reporting asset book.

Expand all

Collapse all

Business Views

** Available for extracting data

• reportingBookAssetRetirementsExtract**

  A retirement transaction stores information such as the retirement date, cost retired, retirement convention, and gain or loss in the reporting asset book.

  Label

  Reporting Book Asset Retirements

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • bonusReserveRetired (big-decimal)

    Reduction in the bonus depreciation reserve balance due to asset retirement.

    Label

    Bonus Reserve Retired

    Properties

    • searchable
    • sortable
  • conversionStatus (string)

    Indicates whether amounts have been converted to the reporting currency.

    Label

    Conversion Status

    Properties

    • searchable
    • sortable
  • costOfRemoval (big-decimal)

    Amount required to remove the retired asset.

    Label

    Cost of Removal

    Properties

    • searchable
    • sortable
  • costRetired (big-decimal)

    A term used to describe how much of the current asset amount is retired.

    Label

    Cost Retired

    Properties

    • searchable
    • sortable
    • not nullable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • searchable
    • sortable
    • not nullable
  • depreciationReserveRetired (big-decimal)

    Depreciation reserve retired along with the asset.

    Label

    Depreciation Reserve Retired

    Properties

    • searchable
    • sortable
  • effectiveDate (date)

    The date on which the retirement transaction is effective.

    Label

    Effective Date

    Properties

    • searchable
    • sortable
    • not nullable
  • gainOrLossAmount (big-decimal)

    The gain or loss generated due to a retirement transaction.

    Label

    Gain or Loss Amount

    Properties

    • searchable
    • sortable
  • historicalCostRetired (big-decimal)

    Cost retired without regard to any revaluations.

    Label

    Historical Cost Retired

    Properties

    • searchable
    • sortable
  • impairmentReserveRetired (big-decimal)

    The impairment reserve retired adjustment amount for the period.

    Label

    Impairment Reserve Retired

    Properties

    • searchable
    • sortable
  • ledgerId (int64)

    Code that identifies the ledger the accounting entry is created for.

    Label

    Ledger ID

    Properties

    • searchable
    • sortable
    • not nullable
  • limitNetProceedsToCostFlag (boolean)

    Indicates whether the member asset proceeds of sale should be limited to its recoverable cost.

    Label

    Limit net proceeds to cost

    Properties

    • searchable
    • sortable
  • netBookValueRetired (big-decimal)

    Net book value of an asset at the time of retirement.

    Label

    Net Book Value Retired

    Properties

    • searchable
    • sortable
  • priorYearDepreciationReserve (big-decimal)

    The depreciation reserve at the end of the previous fiscal year.

    Label

    Prior Year Depreciation Reserve

    Properties

    • searchable
    • sortable
  • proceedsOfSale (big-decimal)

    Amount received from the sale of an asset.

    Label

    Proceeds of Sale

    Properties

    • searchable
    • sortable
  • recaptureExcessReserveFlag (boolean)

    Indicates whether the accumulated depreciation of a group asset can exceed its recoverable cost without triggering the recognition of a gain.

    Label

    Recapture excess reserve

    Properties

    • searchable
    • sortable
  • recapturedReserveAmount (big-decimal)

    The amount the sales proceeds of a member asset retirement exceed the group asset depreciation reserve.

    Label

    Recaptured Reserve Amount

    Properties

    • searchable
    • sortable
  • recognizeGainOrLossFlag (boolean)

    Indicates whether gain or loss should be recognized for member asset retirements.

    Label

    Recognize Gain or Loss

    Properties

    • searchable
    • sortable
  • reductionRate (big-decimal)

    Rate used by a group asset to calculate reduced depreciation for its member assets based on the depreciable basis rule.

    Label

    Reduction Rate

    Properties

    • searchable
    • sortable
  • retirementDate (date)

    The date of the asset retirement.

    Label

    Retirement Date

    Properties

    • searchable
    • sortable
    • not nullable
  • retirementId (int64)

    The identifier of the asset retirement transaction.

    Label

    Retirement Identifier

    Properties

    • searchable
    • sortable
    • not nullable
  • retirementReason (string)

    Reason for the retirement of an asset.

    Label

    Retirement Reason

    Properties

    • searchable
    • sortable
  • retirementReinstatedFlag (boolean)

    Indicates whether the retirement transaction is reinstated.

    Label

    Retirement Reinstated

    Properties

    • searchable
    • sortable
  • retirementStraightLineAmount (big-decimal)

    Straight line depreciation amount for the reporting of 1250 property in a tax book.

    Label

    Retirement Straight Line Amount

    Properties

    • searchable
    • sortable
  • revaluationReserveRetired (big-decimal)

    The amount of revaluation reserve that was retired.

    Label

    Revaluation Reserve Retired

    Properties

    • searchable
    • sortable
  • status (enumeration: RetirementStatus)

    Status of the retirement transaction.

    Label

    Status

    Type

    • Module: oraErpCoreFixedAssets

    • Enumeration Type: RetirementStatus

    Properties

    • searchable
    • sortable
    • not nullable

    Valid Values

    • DELETE
    • DELETED
    • NEW
    • PROCESSED
  • terminalGainOrLoss (enumeration: TerminalGainOrLoss)

    Indicates how terminal gain or loss is recognized for member asset retirements.

    Label

    Terminal Gain or Loss

    Type

    • Module: oraErpCoreFixedAssets

    • Enumeration Type: TerminalGainOrLoss

    Properties

    • searchable
    • sortable

    Valid Values

    • END_OF_YEAR
    • NO
    • Yes
  • terminateInstalledBaseAssetFlag (boolean)

    Identifies the period in which the asset was fully transferred to another book.

    Label

    Terminate installed base asset

    Properties

    • searchable
    • sortable
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • searchable
    • sortable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • sortable
    • not nullable
  • unitsRetired (big-decimal)

    Number of units retired in the transaction.

    Label

    Units Retired

    Properties

    • searchable
    • sortable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • searchable
    • sortable
    • not nullable

  Expand all

  Collapse all

  Reference Object

  • asset (Asset)

    An asset contains the descriptive information such as units, asset type, tag number, manufacturer number, serial number, and model number added in the asset book.

    Business Object

    Asset

    Expand all

    Collapse all

    Fields

    • assetId (int64)

      The identifier of the asset number.

      Label

      Asset ID

      Properties

      • searchable
      • sortable
      • not nullable

  • assetReportingBook (AssetReportingBook)

    A book represents the grouping in which fixed assets of the entity are recorded, tracked, depreciated, reported, and accounted for in the primary ledger.

    Business Object

    AssetReportingBook

    Expand all

    Collapse all

    Fields

    • ledgerId (int64)

      Code that identifies the ledger the accounting entry is created for.

      Label

      Ledger ID

      Properties

      • searchable
      • sortable
      • not nullable
    • name (string)

      The name of the asset book.

      Label

      Book

      Properties

      • searchable
      • sortable
      • not nullable

  • reinstatementTransaction (AssetTransaction)

    A retirement transaction stores information such as the retirement date, cost retired, retirement convention, and gain or loss in the reporting asset book.

    Business Object

    AssetTransaction

    Expand all

    Collapse all

    Fields

    • bookName (string)

      The name of the asset book.

      Label

      Book

      Properties

      • searchable
      • sortable
      • not nullable
    • transactionHeaderId (int64)

      Unique identifier of the asset transaction.

      Label

      Transaction Header ID

      Properties

      • searchable
      • sortable
      • not nullable

  • retirementConvention (AssetProrateConvention)

    A prorate convention contains the date that maps a date placed in service to a prorate date for depreciation calculation.

    Business Object

    AssetProrateConvention

    Expand all

    Collapse all

    Fields

    • conventionTypeId (int64)

      Unique identifier of the prorate convention.

      Label

      Prorate Convention ID

      Properties

      • searchable
      • sortable
      • not nullable

  • retirementTransaction (AssetTransaction)

    A retirement transaction stores information such as the retirement date, cost retired, retirement convention, and gain or loss in the reporting asset book.

    Business Object

    AssetTransaction

    Expand all

    Collapse all

    Fields

    • bookName (string)

      The name of the asset book.

      Label

      Book

      Properties

      • searchable
      • sortable
      • not nullable
    • transactionHeaderId (int64)

      Unique identifier of the asset transaction.

      Label

      Transaction Header ID

      Properties

      • searchable
      • sortable
      • not nullable

  • straightLineDepreciationMethod (AssetDepreciationMethod)

    A depreciation method contains the definitions for depreciation methods, such as the name, description, type, depreciation calculation basis, and life that's used to depreciate the fixed assets.

    Business Object

    AssetDepreciationMethod

    Expand all

    Collapse all

    Fields

    • methodId (int64)

      Identifier of the depreciation method.

      Label

      Method ID

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top