ReportingBookAssetRevaluation

A reporting book revaluation transaction contains the carrying value of a company's fixed asset or group of fixed assets to account for any major changes in their fair market value.

Expand all

Collapse all

Business Views

** Available for extracting data

• reportingBookAssetRevaluationsExtract**

  A reporting book revaluation transaction contains the carrying value of a company's fixed asset or group of fixed assets to account for any major changes in their fair market value.

  Label

  Reporting Book Asset Revaluations

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • allowCapitalFundAccountingFlag (boolean)

    Allows capital fund accounting for the asset book.

    Label

    Allow capital fund accounting

    Properties

    • searchable
    • sortable
  • amortizeRevaluationReserveFlag (boolean)

    Option indicating whether to amortize the revaluation reserve of the assets.

    Label

    Amortize revaluation reserve

    Properties

    • searchable
    • sortable
  • amount (big-decimal)

    Revaluation amount value used for the revaluation.

    Label

    Amount

    Properties

    • searchable
    • sortable
  • bonusDepreciationReserve (big-decimal)

    Bonus depreciation reserve of an asset after revaluation.

    Label

    Bonus Depreciation Reserve

    Properties

    • searchable
    • sortable
  • bonusDepreciationReserveBeforeRevaluation (big-decimal)

    Bonus depreciation reserve of an asset before revaluation.

    Label

    Bonus Depreciation Reserve Before Revaluation

    Properties

    • searchable
    • sortable
  • cost (big-decimal)

    Cost of an asset after revaluation.

    Label

    Cost

    Properties

    • searchable
    • sortable
  • costBeforeRevaluation (big-decimal)

    Cost of the asset immediately before the revaluation transaction.

    Label

    Cost Before Revaluation

    Properties

    • searchable
    • sortable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

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

    Depreciation reserve of an asset after revaluation.

    Label

    Depreciation Reserve

    Properties

    • searchable
    • sortable
  • depreciationReserveBeforeRevaluation (big-decimal)

    Depreciation reserve of the asset immediately before the revaluation transaction.

    Label

    Depreciation Reserve Before Revaluation

    Properties

    • searchable
    • sortable
  • fairMarketValueBeforeRevaluation (big-decimal)

    Fair market value of the asset immediately before the revaluation transaction.

    Label

    Fair Market Value Before Revaluation

    Properties

    • searchable
    • sortable
  • fairValue (big-decimal)

    Fair market value of the asset.

    Label

    Fair Value

    Properties

    • searchable
    • sortable
  • impairmentLossBalance (big-decimal)

    Impairment loss of an asset after revaluation.

    Label

    Impairment Loss Balance

    Properties

    • searchable
    • sortable
  • impairmentLossBalanceBeforeRevaluation (big-decimal)

    Impairment reserve of the asset immediately before the revaluation transaction.

    Label

    Impairment Loss Balance Before Revaluation

    Properties

    • searchable
    • sortable
  • impairmentReserve (big-decimal)

    Impairment reserve of an asset after revaluation.

    Label

    Impairment Reserve

    Properties

    • searchable
    • sortable
  • impairmentReserveBeforeRevaluation (big-decimal)

    Impairment loss balance of the asset immediately before the revaluation transaction.

    Label

    Impairment Reserve Before Revaluation

    Properties

    • searchable
    • sortable
  • ledgerId (int64)

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

    Label

    Ledger ID

    Properties

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

    The maximum life of the fully reserved asset.

    Label

    Life Extension Ceiling

    Properties

    • searchable
    • sortable
  • lifeExtensionFactor (big-decimal)

    The factor used to calculate the new life for fully reserved assets.

    Label

    Life Extension Factor

    Properties

    • searchable
    • sortable
  • lifeInMonthsAfterRevaluation (int32)

    Life of an asset in months after revaluation.

    Label

    Life in Months After Revaluation

    Properties

    • searchable
    • sortable
  • lifeInMonthsBeforeRevaluation (int32)

    Asset life in months immediately before the revaluation transaction.

    Label

    Life in Months Before Revaluation

    Properties

    • searchable
    • sortable
  • maximumRevaluations (int64)

    Default value of the maximum number of revaluations allowed on a fully reserved asset.

    Label

    Maximum Revaluations

    Properties

    • searchable
    • sortable
  • percent (big-decimal)

    Percentage used to increase or decrease the current net book value or cost of the asset.

    Label

    Percent

    Properties

    • searchable
    • sortable
  • periodEndRevaluationFlag (boolean)

    Indicates whether to include the current period depreciation amount in revaluation calculations.

    Label

    Include Current Period Depreciation

    Properties

    • searchable
    • sortable
  • priceIndexValue (big-decimal)

    Price index value to be used to revalue the asset's net book value.

    Label

    Price Index Value

    Properties

    • searchable
    • sortable
  • revaluationAmortizationBasisAfterRevaluation (big-decimal)

    Revaluation amortization basis of the asset immediately after the revaluation transaction.

    Label

    Revaluation Amortization Basis After Revaluation

    Properties

    • searchable
    • sortable
  • revaluationAmortizationBasisBeforeRevaluation (big-decimal)

    Revaluation amortization basis of the asset immediately before the revaluation transaction.

    Label

    Revaluation Amortization Basis Before Revaluation

    Properties

    • searchable
    • sortable
  • revaluationGainOrLoss (big-decimal)

    The gain or loss on revaluation of a fixed asset.

    Label

    Revaluation Gain or Loss

    Properties

    • searchable
    • sortable
  • revaluationLossBalance (big-decimal)

    The revaluation loss balance of the asset after revaluation.

    Label

    Revaluation Loss Balance

    Properties

    • searchable
    • sortable
  • revaluationLossBalanceBeforeRevaluation (big-decimal)

    Revaluation loss balance of the asset immediately before the revaluation transaction.

    Label

    Revaluation Loss Balance Before Revaluation

    Properties

    • searchable
    • sortable
  • revaluationMethod (string)

    The method used to revalue the asset.

    Label

    Revaluation Method

    Properties

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

    Revaluation reserve of an asset after revaluation.

    Label

    Revaluation Reserve

    Properties

    • searchable
    • sortable
  • revaluationReserveBeforeRevaluation (big-decimal)

    Revaluation reserve of the asset immediately before the revaluation transaction.

    Label

    Revaluation Reserve Before Revaluation

    Properties

    • searchable
    • sortable
  • revalueDepreciationReserveFlag (boolean)

    Revaluation reserve of an asset after revaluation.

    Label

    Revalue depreciation reserve

    Properties

    • searchable
    • sortable
  • revalueFullyReservedAssetsFlag (boolean)

    Indicates whether fully reserved assets can be revalued.

    Label

    Revalue Fully Reserved Assets

    Properties

    • searchable
    • sortable
  • revalueYtdDepreciationFlag (boolean)

    Allows you to revalue the YTD depreciation of the assets.

    Label

    Revalue YTD depreciation

    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
  • transactionHeaderId (int64)

    Unique identifier of the asset transaction.

    Label

    Transaction Header ID

    Properties

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

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • searchable
    • sortable
    • not nullable
  • valueType (enumeration: RevaluationValueType)

    Stores the value type used for revaluation.

    Label

    Value Type

    Type

    • Module: oraErpCoreFixedAssets

    • Enumeration Type: RevaluationValueType

    Properties

    • searchable
    • sortable
    • not nullable

    Valid Values

    • AFV
    • AMT
    • FMV
    • IND
    • PER
    • PFV

  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 reporting book accounting line contains journal entry lines for every asset transaction that has a financial impact on the reporting asset book. These accounting lines are used to create journal entries in Oracle Subledger Accounting and transfer them to Oracle General 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

Back to Top