ReportingBookAssetFinancialDetail

Reporting book financial detail transactions store the financial information and depreciation rules required for calculating depreciation in the reporting asset book.

Expand all

Collapse all

Business Views

** Available for extracting data

• reportingBookAssetFinancialDetailsExtract**

  Reporting book financial detail transactions store the financial information and depreciation rules required for calculating depreciation in the reporting asset book.

  Label

  Reporting Book Asset Financial Details

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • adjustedCapacity (big-decimal)

    Remaining production capacity used to depreciate assets that use units of production methods.

    Label

    Adjusted Capacity

    Properties

    • searchable
    • sortable
  • adjustedCost (big-decimal)

    Amount used to calculate the periodic depreciation amount.

    Label

    Adjusted Cost

    Properties

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

    Adjusted cost at the end of the previous fiscal year.

    Label

    Adjusted Cost at the End of Fiscal Year

    Properties

    • searchable
    • sortable
  • adjustedRecoverableCost (big-decimal)

    Adjusted recoverable cost with special depreciation limits taken into account.

    Label

    Adjusted Recoverable Cost

    Properties

    • searchable
    • sortable
  • allocateGroupDepreciationToFullyReitredAssetsFlag (boolean)

    Indicates whether the group asset depreciation amount is allocated to all of the member assets, including fully retired member assets.

    Label

    Allocate group depreciation to fully retired assets

    Properties

    • searchable
    • sortable
  • allocateGroupDepreciationToFullyReservedAssetsFlag (boolean)

    Indicates whether the group asset depreciation amount is allocated to all of the member assets, including fully reserved member assets.

    Label

    Allocate group depreciation to fully reserved assets

    Properties

    • searchable
    • sortable
  • annualDepreciationRounding (string)

    Annual depreciation rounding option that can be selected from the predefined options.

    Label

    Annual Depreciation Rounding

    Properties

    • searchable
    • sortable
  • assetId (int64)

    The identifier of the asset number.

    Label

    Asset ID

    Properties

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

    Cost before the adjustment transaction for an asset depreciating under a formula net book value-based depreciation method.

    Label

    Asset Old Adjusted Cost

    Properties

    • searchable
    • sortable
  • bonusAdjustedCost (big-decimal)

    Amount used to calculate the periodic bonus depreciation amount.

    Label

    Bonus Adjusted Cost

    Properties

    • searchable
    • sortable
  • bookName (string)

    The name of the asset book.

    Label

    Book

    Properties

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

    Indicates whether the asset is a capitalized asset.

    Label

    Capitalized

    Properties

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

    Account used to reflect the cost of a construction-in-process asset.

    Label

    CIP Cost

    Properties

    • searchable
    • sortable
  • conversionDate (date)

    The date on which a conversion rate is used to convert an amount into another currency.

    Label

    Conversion Date

    Properties

    • searchable
    • sortable
  • conversionStatus (string)

    Indicates whether amounts have been converted to the reporting currency.

    Label

    Conversion Status

    Properties

    • searchable
    • sortable
  • cost (big-decimal)

    Total recorded cost of the asset.

    Label

    Cost

    Properties

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

    The user who created the record.

    Label

    Created By

    Properties

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

    The identifier of the transaction that's created.

    Label

    Creating Transaction ID

    Properties

    • searchable
    • sortable
    • not nullable
  • datePlacedInService (date)

    Date on which the asset was placed in service.

    Label

    Date Placed in Service

    Properties

    • searchable
    • sortable
    • not nullable
  • depreciateByGroupAsset (enumeration: GroupDepreciationOption)

    Indicates whether the depreciation expense of a member asset is calculated using its group asset depreciation rules or the member asset depreciation rules.

    Label

    Depreciate by Group Asset

    Type

    • Module: oraErpCoreFixedAssets

    • Enumeration Type: GroupDepreciationOption

    Properties

    • searchable
    • sortable

    Valid Values

    • GROUP
    • MEMBER
  • depreciateFlag (boolean)

    Indicates whether the asset is depreciating.

    Label

    Depreciate

    Properties

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

    Unique identifier for an in-progress asset retirement transaction.

    Label

    Depreciate Group Asset for the Members Retired

    Properties

    • searchable
    • sortable
  • depreciationAdjustmentFactor (big-decimal)

    The internal adjustment factor used to calculate the depreciation.

    Label

    Depreciation Adjustment Factor

    Properties

    • searchable
    • sortable
  • depreciationLimitAmount (big-decimal)

    Depreciation limit amount that's applied automatically when assets are added with this asset category.

    Label

    Depreciation Limit Amount

    Properties

    • searchable
    • sortable
  • depreciationLimitPercent (big-decimal)

    Depreciation limit percentage that's applied automatically when assets are added with this asset category.

    Label

    Depreciation Limit Percent

    Properties

    • searchable
    • sortable
  • depreciationLimitType (enumeration: SalvageDepreciationLimitType)

    Depreciation limit type assigned to the asset. It can be either the amount, percentage, sum of member assets, or none.

    Label

    Depreciation Limit Type

    Type

    • Module: oraErpCoreFixedAssets

    • Enumeration Type: SalvageDepreciationLimitType

    Properties

    • searchable
    • sortable
    • not nullable

    Valid Values

    • AMT
    • NONE
    • PCT
    • SUM
  • depreciationRateAdjustmentFactor (big-decimal)

    Internal factor used to adjust depreciation rates to depreciate the net book value over the remaining life.

    Label

    Depreciation Rate Adjustment Factor

    Properties

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

    Depreciation rates used to depreciate the net book value over the remaining life.

    Label

    Depreciation Rate in Use

    Properties

    • searchable
    • sortable
  • depreciationStartDate (date)

    The original depreciation start date.

    Label

    Depreciation Start Date

    Properties

    • searchable
    • sortable
    • not nullable
  • effectiveDate (date)

    Date when the row became effective.

    Label

    Effective Date

    Properties

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

    Formula factor at the end of the previous fiscal year.

    Label

    End of Fiscal Year Formula Factor

    Properties

    • searchable
    • sortable
  • excessAllocationOption (enumeration: GroupExcessAllocationOption)

    Indicates whether excess depreciation of the group asset is allocated to its member assets or reduced from the group asset depreciation.

    Label

    Excess Allocation Option

    Type

    • Module: oraErpCoreFixedAssets

    • Enumeration Type: GroupExcessAllocationOption

    Properties

    • searchable
    • sortable

    Valid Values

    • DISTRIBUTE
    • REDUCE
  • excludeFullyReservedAssetFlag (boolean)

    Indicates whether the depreciable basis of fully reserved assets should be excluded from the depreciable basis of group assets.

    Label

    Exclude Fully Reserved Asset

    Properties

    • searchable
    • sortable
  • excludeSaleProceedsForDepreciationBasisFlag (boolean)

    The group asset retirement rule that indicates whether proceeds of sale should be excluded when calculating the depreciable basis for group assets.

    Label

    Exclude Sale Proceeds for Depreciation Basis

    Properties

    • searchable
    • sortable
  • extendedDepreciation (enumeration: ExtendedDepreciation)

    Indicates whether to extend depreciation beyond the useful life of the asset.

    Label

    Extended Depreciation Status

    Type

    • Module: oraErpCoreFixedAssets

    • Enumeration Type: ExtendedDepreciation

    Properties

    • searchable
    • sortable

    Valid Values

    • D
    • N
    • Y
  • extendedDepreciationStartPeriod (int64)

    The period in which extended depreciation starts for the asset.

    Label

    Extended Depreciation Start Period

    Properties

    • searchable
    • sortable
  • fairValue (big-decimal)

    Fair market value of the asset.

    Label

    Fair Value

    Properties

    • searchable
    • sortable
  • formulaFactor (big-decimal)

    Formula factor at the end of the previous period.

    Label

    Formula Factor

    Properties

    • searchable
    • sortable
  • fullyReserveOnAdditionFlag (boolean)

    Indicates whether to fully depreciate an asset when the asset is added.

    Label

    Fully depreciate in current period

    Properties

    • searchable
    • sortable
  • historicalCost (big-decimal)

    Cost without regard to any revaluations.

    Label

    Historical Cost

    Properties

    • searchable
    • sortable
    • not nullable
  • ineffectiveDate (date)

    Date on which the book becomes inactive.

    Label

    Ineffective Date

    Properties

    • searchable
    • sortable
  • lastUsedPriceIndexValue (big-decimal)

    Stores the value of the price index used during index-based revaluation for future revaluations.

    Label

    Last Used Price Index Value

    Properties

    • searchable
    • sortable
  • leaseAdjustmentFactor (big-decimal)

    Internal factor used to amortize the lease basis over the remaining lease term of the asset.

    Label

    Lease Adjustment Factor

    Properties

    • searchable
    • sortable
  • leaseExpenseBasis (big-decimal)

    The basis used for calculating the periodic lease expense of the asset.

    Label

    Lease Expense Basis

    Properties

    • searchable
    • sortable
  • ledgerId (int64)

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

    Label

    Ledger ID

    Properties

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

    Indicates whether the net of the cost of removal that can be added to the accumulated depreciation is limited to the recoverable cost of the retiring member asset.

    Label

    Life to Date Cost of Removal

    Properties

    • searchable
    • sortable
  • lifeToDateSaleProceeds (big-decimal)

    Indicates whether the net of proceeds that can be added to accumulated depreciation is limited to the recoverable cost of the retiring member asset.

    Label

    Life to Date Sale Proceeds

    Properties

    • searchable
    • sortable
  • 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
  • lowValueAssetFlag (boolean)

    Indicates whether the asset is a low value asset.

    Label

    Low Value Asset Indicator

    Properties

    • searchable
    • sortable
  • memberRollupFlag (boolean)

    Option indicating whether group asset depreciation is the sum of member asset depreciation or calculated separately.

    Label

    Member Rollup

    Properties

    • searchable
    • sortable
  • nbvAtSwitch (big-decimal)

    The net book value of the asset at the time you switch the depreciation method from declining balance to straight line.

    Label

    NBV at Switch

    Properties

    • searchable
    • sortable
  • oldAdjustedCapacity (big-decimal)

    Production capacity used to calculate the periodic depreciation amount.

    Label

    Old Adjusted Capacity

    Properties

    • searchable
    • sortable
  • originalCost (big-decimal)

    Original cost of the asset at the time of its addition.

    Label

    Original Cost

    Properties

    • searchable
    • sortable
    • not nullable
  • originalDepreciationStartDate (date)

    The original depreciation start date of the asset.

    Label

    Original Depreciation Start Date

    Properties

    • searchable
    • sortable
  • overDepreciate (string)

    Indicates whether a group asset should stop depreciating beyond its depreciation limit.

    Label

    Over Depreciate

    Properties

    • searchable
    • sortable
  • periodEndAdjustedCost (big-decimal)

    Adjusted cost at the end of the previous period.

    Label

    Period End Adjusted Cost

    Properties

    • searchable
    • sortable
  • periodEndFormulaFactor (big-decimal)

    Formula factor at the end of the previous period.

    Label

    Period End Formula Factor

    Properties

    • searchable
    • sortable
  • priorDepreciationLimitAmount (big-decimal)

    The depreciation limit amount of the asset before its depreciation is extended.

    Label

    Prior Depreciation Limit Amount

    Properties

    • searchable
    • sortable
  • priorDepreciationLimitPercent (big-decimal)

    The depreciation limit percentage of the asset before its depreciation is extended.

    Label

    Prior Depreciation Limit Percent

    Properties

    • searchable
    • sortable
  • priorDepreciationLimitType (enumeration: SalvageDepreciationLimitType)

    The depreciation limit type used for the asset before its depreciation is extended.

    Label

    Prior Depreciation Limit Type

    Type

    • Module: oraErpCoreFixedAssets

    • Enumeration Type: SalvageDepreciationLimitType

    Properties

    • searchable
    • sortable

    Valid Values

    • AMT
    • NONE
    • PCT
    • SUM
  • priorYearDepreciationReserve (big-decimal)

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

    Label

    Prior Year Depreciation Reserve

    Properties

    • searchable
    • sortable
  • priorYearDepreciationReserveBeforeTransaction (big-decimal)

    Previous accumulated depreciation at the end of the previous fiscal year.

    Label

    Prior Year Depreciation Reserve Before Transaction

    Properties

    • searchable
    • sortable
  • priorYearRevaluationReserve (big-decimal)

    Revaluation reserve at the end of the previous fiscal year.

    Label

    Prior Year Revaluation Reserve

    Properties

    • searchable
    • sortable
  • priorYearRevaluationReserveBeforeTransaction (big-decimal)

    Revaluation reserve at the end of the previous fiscal year.

    Label

    Prior Year Revaluation Reserve Before Transaction

    Properties

    • searchable
    • sortable
  • productionCapacity (big-decimal)

    Production capacity used to calculate the periodic depreciation amount.

    Label

    Production Capacity

    Properties

    • searchable
    • sortable
  • prorateDate (date)

    Date used to calculate the annual depreciation for assets.

    Label

    Prorate Date

    Properties

    • searchable
    • sortable
    • not nullable
  • 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
  • recognizeGainOrLossFlag (boolean)

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

    Label

    Recognize Gain or Loss

    Properties

    • searchable
    • sortable
  • recoverableCost (big-decimal)

    The cost of an asset minus the salvage value.

    Label

    Recoverable Cost

    Properties

    • searchable
    • sortable
    • not nullable
  • 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
  • revaluationAmortizationBasis (big-decimal)

    Revaluation reserve amount used to calculate amortization of revaluation reserve. This amount changes only when the asset is revalued or an amortized adjustment is performed.

    Label

    Revaluation Amortization Basis

    Properties

    • searchable
    • sortable
  • revaluationCostCeiling (big-decimal)

    Upper limit for revaluing asset cost.

    Label

    Revaluation Cost Ceiling

    Properties

    • searchable
    • sortable
  • revaluedCost (big-decimal)

    Increase or decrease in cost due to revaluation of an asset. Can be a positive or negative amount.

    Label

    Revalued Cost

    Properties

    • searchable
    • sortable
  • revaluedFullyReserved (big-decimal)

    Number of times the asset has been revalued as fully reserved.

    Label

    Revalued Fully Reserved

    Properties

    • searchable
    • sortable
  • salvageType (enumeration: SalvageDepreciationLimitType)

    Salvage type assigned to the asset. It can be either the amount, percentage, or sum of member assets.

    Label

    Salvage Type

    Type

    • Module: oraErpCoreFixedAssets

    • Enumeration Type: SalvageDepreciationLimitType

    Properties

    • searchable
    • sortable
    • not nullable

    Valid Values

    • AMT
    • NONE
    • PCT
    • SUM
  • salvageValueAmount (big-decimal)

    Salvage value amount for the asset.

    Label

    Salvage Value Amount

    Properties

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

    Value an asset will realize upon its sale at the end of its useful life.

    Label

    Salvage Value Percent

    Properties

    • searchable
    • sortable
  • shortFiscalYearFlag (boolean)

    Indicates whether the asset is added in a short tax year.

    Label

    Short year

    Properties

    • searchable
    • sortable
  • sourceCost (big-decimal)

    Current cost of the asset in the primary functional currency.

    Label

    Source Cost

    Properties

    • searchable
    • sortable
  • sourceOriginalCost (big-decimal)

    Original cost of the asset in the primary functional currency.

    Label

    Original Cost

    Properties

    • searchable
    • sortable
  • terminalGainLossFlag (boolean)

    Option indicating whether the terminal gain or loss amount must be processed by the Calculate Gains and Losses process when it's running for the last period of the fiscal year.

    Label

    Terminal Gain or Loss

    Properties

    • searchable
    • sortable
  • 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
  • terminalGainOrLossAmount (big-decimal)

    Accumulated depreciation remaining for the group asset after the last member asset of the group asset is retired.

    Label

    Terminal Gain or Loss Amount

    Properties

    • searchable
    • sortable
  • terminatingTransactionId (int64)

    The identifier of the transaction that's terminated.

    Label

    Terminating Transaction ID

    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
  • trackingMethod (enumeration: TrackingMethod)

    The group asset tracking method that's used to calculate group depreciation and member asset depreciation.

    Label

    Tracking Method

    Type

    • Module: oraErpCoreFixedAssets

    • Enumeration Type: TrackingMethod

    Properties

    • searchable
    • sortable

    Valid Values

    • ALLOCATE
    • CALCULATE
    • NONE
  • unitOfMeasure (string)

    Unit of measure used to select candidate assets depreciating under a units of production depreciation method.

    Label

    Unit of Measure

    Properties

    • searchable
    • sortable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

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

    The year-to-date proceeds of sale for an asset.

    Label

    Year to Date Sale Proceeds

    Properties

    • searchable
    • sortable

  Expand all

  Collapse all

  Reference Object

  • bonusRule (AssetBonusDepreciationRule)

    Bonus depreciation rules are rules used to increase the annual depreciation expense for assets in the early years of an asset's life using either flat-rate, straight-line, table-based, or formula-based methods.

    Business Object

    AssetBonusDepreciationRule

    Expand all

    Collapse all

    Fields

    • bonusRuleId (int64)

      Code that identifies the depreciation bonus rule.

      Label

      Bonus Rule ID

      Properties

      • searchable
      • sortable
      • not nullable

  • capitalizationPeriod (AssetBookPeriod)

    A book period contains information about the depreciation period status, period open date, and period close date for each asset book.

    Business Object

    AssetBookPeriod

    Expand all

    Collapse all

    Fields

    • bookName (string)

      The name of the asset book.

      Label

      Book

      Properties

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

      Identifier of the depreciation period.

      Label

      Period ID

      Properties

      • searchable
      • sortable
      • not nullable

  • cashGeneratingUnit (AssetCashGeneratingUnit)

    A cash generating unit represents the smallest identifiable group of assets that generates cash inflows that are largely independent of the cash inflows from other assets or groups of assets.

    Business Object

    AssetCashGeneratingUnit

    Expand all

    Collapse all

    Fields

    • cashGeneratingUnitId (int64)

      The unique identifier of the cash generating unit.

      Label

      Cash Generating Unit ID

      Properties

      • searchable
      • sortable
      • not nullable

  • ceilingType (AssetDepreciationCeiling)

    A depreciation ceiling stores the depreciation expense, depreciation cost, and investment tax credit information for an asset book.

    Business Object

    AssetDepreciationCeiling

    Expand all

    Collapse all

    Fields

    • ceilingTypeId (int64)

      Number that uniquely identifies the ceiling type.

      Label

      Ceiling Type ID

      Properties

      • searchable
      • sortable
      • not nullable

  • depreciationMethod (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

  • fullyReservedPeriod (AssetBookPeriod)

    A book period contains information about the depreciation period status, period open date, and period close date for each asset book.

    Business Object

    AssetBookPeriod

    Expand all

    Collapse all

    Fields

    • bookName (string)

      The name of the asset book.

      Label

      Book

      Properties

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

      Identifier of the depreciation period.

      Label

      Period ID

      Properties

      • searchable
      • sortable
      • not nullable

  • fullyRetiredPeriod (AssetBookPeriod)

    A book period contains information about the depreciation period status, period open date, and period close date for each asset book.

    Business Object

    AssetBookPeriod

    Expand all

    Collapse all

    Fields

    • bookName (string)

      The name of the asset book.

      Label

      Book

      Properties

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

      Identifier of the depreciation period.

      Label

      Period ID

      Properties

      • searchable
      • sortable
      • not nullable

  • lifeCompletePeriod (AssetBookPeriod)

    A book period contains information about the depreciation period status, period open date, and period close date for each asset book.

    Business Object

    AssetBookPeriod

    Expand all

    Collapse all

    Fields

    • bookName (string)

      The name of the asset book.

      Label

      Book

      Properties

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

      Identifier of the depreciation period.

      Label

      Period ID

      Properties

      • searchable
      • sortable
      • not nullable

  • priorDepreciationMethod (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

  • prorateConvention (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

Back to Top