AssetPeriodicFinancialDetail

A periodic financial detail stores information about group asset periodical financial information. It also stores information about group financial information changes, such as group additions, adjustments, member asset additions, member asset adjustments, member asset retirements, group reclassifications, and unplanned depreciation transactions.

Expand all

Collapse all

Business Views

** Available for extracting data

• assetPeriodFinancialDetailsExtract**

  A periodic financial detail stores information about group asset periodical financial information. It also stores information about group financial information changes, such as group additions, adjustments, member asset additions, member asset adjustments, member asset retirements, group reclassifications, and unplanned depreciation transactions.

  Label

  Asset Periodic Financial Details

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • acceleratedAdjustedCost (big-decimal)

    The base amount on which the accelerated depreciation is calculated.

    Label

    Accelerated Adjusted Cost

    Properties

    • searchable
    • sortable
  • adjustedCost (big-decimal)

    Amount used to calculate the periodic depreciation amount.

    Label

    Adjusted Cost

    Properties

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

    The adjusted portion of the current cost that can be depreciated.

    Label

    Adjusted Recoverable Cost

    Properties

    • searchable
    • sortable
  • amortizeFlag (boolean)

    Indicates whether amortized transactions are allowed for the book.

    Label

    Amortize

    Properties

    • searchable
    • sortable
  • annuityInterestAmount (big-decimal)

    A field label for entering the year-to-date annuity interest expense amount for an asset.

    Label

    Annuity Interest Amount

    Properties

    • searchable
    • sortable
  • annuityInterestRate (big-decimal)

    Annual interest rate used to calculate annual interest expense.

    Label

    Annuity Interest Rate

    Properties

    • searchable
    • sortable
  • assetCalendarPeriodEndDate (date)

    The End date of the asset calendar period.

    Label

    Asset Calendar Period End Date

    Properties

    • searchable
    • sortable
  • assetCalendarPeriodStartDate (date)

    The start date of the calendar period.

    Label

    Asset Calendar Period Start Date

    Properties

    • searchable
    • sortable
  • assetFiscalYear (int64)

    Number that uniquely identifies the fiscal year.

    Label

    Asset Fiscal Year

    Properties

    • searchable
    • sortable
  • assetId (int64)

    The identifier of the asset number.

    Label

    Asset ID

    Properties

    • searchable
    • sortable
    • not nullable
  • assetType (enumeration: AssetType)

    Indicates the types of assets allowed in Oracle Fusion Assets. The asset types are Capitalized, Construction-in-Process, Expensed, and Group.

    Label

    Asset Type

    Type

    • Module: oraErpCoreFixedAssets

    • Enumeration Type: AssetType

    Properties

    • searchable
    • sortable

    Valid Values

    • CAPITALIZED
    • CIP
    • EXPENSED
    • GROUP
  • bonusAdjustedCost (big-decimal)

    Amount used to calculate the periodic bonus depreciation amount.

    Label

    Bonus Adjusted Cost

    Properties

    • searchable
    • sortable
  • bonusDepreciationAmount (big-decimal)

    Depreciation expense calculated due to bonus depreciation.

    Label

    Bonus Depreciation Amount

    Properties

    • searchable
    • sortable
  • bonusDepreciationReserve (big-decimal)

    The total amount of bonus depreciation recorded against an asset.

    Label

    Bonus Depreciation Reserve

    Properties

    • searchable
    • sortable
  • bonusExpenseAdjustmentAmount (big-decimal)

    The bonus depreciation expense adjustment amount for the period.

    Label

    Bonus Expense Adjustment Amount

    Properties

    • searchable
    • sortable
  • bonusRate (big-decimal)

    Rate for calculating bonus depreciation amounts.

    Label

    Bonus Rate

    Properties

    • searchable
    • sortable
  • bonusReserveAdjustmentAmount (big-decimal)

    The bonus depreciation expense adjustment amount for the period.

    Label

    Bonus Reserve Adjustment Amount

    Properties

    • searchable
    • sortable
  • bonusReserveRetirementAdjustmentAmount (big-decimal)

    Bonus depreciation reserve retired adjustment amount for the period.

    Label

    Bonus Reserve Retirement Adjustment Amount

    Properties

    • searchable
    • sortable
  • bonusYtdDepreciation (big-decimal)

    Year-to-date bonus depreciation amount.

    Label

    Bonus YTD Depreciation

    Properties

    • searchable
    • sortable
  • bookName (string)

    The name of the asset book.

    Label

    Book

    Properties

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

    Capital adjustment balance for the period.

    Label

    Capital Adjustment

    Properties

    • searchable
    • sortable
  • capitalizedFlag (boolean)

    Indicates whether the asset is a capitalized asset.

    Label

    Capitalized

    Properties

    • searchable
    • sortable
  • changeInCipCost (big-decimal)

    Change in the cost of the construction-in-process asset.

    Label

    Change in CIP Cost

    Properties

    • searchable
    • sortable
  • changeInCost (big-decimal)

    Total change in the cost of the asset for the period.

    Label

    Change in Cost

    Properties

    • searchable
    • sortable
  • changeInEofyReserve (big-decimal)

    Change in depreciation reserve at the end of the previous fiscal year.

    Label

    Change in EOFY Reserve

    Properties

    • searchable
    • sortable
  • cipCost (big-decimal)

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

    Label

    CIP Cost

    Properties

    • searchable
    • sortable
  • cost (big-decimal)

    Total recorded cost of the asset.

    Label

    Cost

    Properties

    • searchable
    • sortable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

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

    Date on which the asset was placed in service.

    Label

    Date Placed in Service

    Properties

    • searchable
    • sortable
  • depreciateFlag (boolean)

    Indicates whether the asset is depreciating.

    Label

    Depreciate

    Properties

    • searchable
    • sortable
  • depreciationAdjustmentAmount (big-decimal)

    Adjustment to the depreciation amount for retroactive asset transactions.

    Label

    Depreciation Adjustment Amount

    Properties

    • searchable
    • sortable
  • depreciationAdjustmentFactor (big-decimal)

    The internal adjustment factor used to calculate the depreciation.

    Label

    Depreciation Adjustment Factor

    Properties

    • searchable
    • sortable
  • depreciationAmount (big-decimal)

    Asset depreciation expense amount.

    Label

    Depreciation Amount

    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

    Valid Values

    • AMT
    • NONE
    • PCT
    • SUM
  • depreciationOverride (string)

    Indicates whether a depreciation override amount is allowed for assets in the book.

    Label

    Depreciation Override Indicator

    Properties

    • searchable
    • sortable
  • depreciationRateAdjustmentFactor (big-decimal)

    The internal adjustment factor used to calculate the depreciation.

    Label

    Depreciation Rate Adjustment Factor

    Properties

    • searchable
    • sortable
  • depreciationReserve (big-decimal)

    The depreciation reserve amount for the asset book.

    Label

    Depreciation Reserve

    Properties

    • searchable
    • sortable
  • depreciationReserveAdjustmentAmount (big-decimal)

    The depreciation reserve adjustment amount for the period.

    Label

    Depreciation Reserve Adjustment Amount

    Properties

    • searchable
    • sortable
  • disableGroupAssetFlag (boolean)

    Indicates whether the group asset is enabled.

    Label

    Disable group asset

    Properties

    • searchable
    • sortable
  • endOfFiscalYearFormulaFactor (big-decimal)

    Formula factor at the end of the previous fiscal year.

    Label

    End of Fiscal Year Formula Factor

    Properties

    • searchable
    • sortable
  • expenseAdjustmentAmount (big-decimal)

    The depreciation expense adjustment amount for the period.

    Label

    Expense Adjustment Amount

    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
  • 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
  • fullyReservedFlag (boolean)

    Indicates whether the asset is fully reserved.

    Label

    Fully reserved

    Properties

    • searchable
    • sortable
  • fullyRetiredFlag (boolean)

    Indicates whether the asset is fully retired.

    Label

    Fully Retired Indicator

    Properties

    • searchable
    • sortable
  • generalFund (big-decimal)

    General fund balance for the period.

    Label

    General Fund Amount

    Properties

    • searchable
    • sortable
  • impairmentAmount (big-decimal)

    Impairment loss expense balance for the period.

    Label

    Impairment Amount

    Properties

    • searchable
    • sortable
  • impairmentLossBalance (big-decimal)

    Impairment loss balance of the asset immediately after the impairment.

    Label

    Impairment Loss Balance

    Properties

    • searchable
    • sortable
  • impairmentReserve (big-decimal)

    Total impairment loss recognized for the asset.

    Label

    Impairment Reserve

    Properties

    • searchable
    • sortable
  • impairmentReserveAdjustmentAmount (big-decimal)

    The impairment reserve adjustment amount for the period.

    Label

    Impairment Reserve Adjustment Amount

    Properties

    • searchable
    • sortable
  • impairmentReserveRetiredAdjustmentAmount (big-decimal)

    The impairment reserve retired adjustment amount for the period.

    Label

    Impairment Reserve Retirement Adjustment Amount

    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
  • lifeCompleteFlag (boolean)

    Option that indicates whether the asset life is completed.

    Label

    Life Complete Indicator

    Properties

    • searchable
    • sortable
  • lifeToDateAnnuityInterest (big-decimal)

    A field label for displaying the life-to-date annuity interest expense amount for an asset.

    Label

    Life-to-Date Annuity Interest Amount

    Properties

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

    The life-to-date proceeds of sale amount for the asset.

    Label

    Life to Date Sale Proceeds

    Properties

    • searchable
    • sortable
  • memberDepreciationLimitAmount (big-decimal)

    Sum of the depreciation limit amount subtracted from the cost.

    Label

    Member Depreciation Limit Amount

    Properties

    • searchable
    • sortable
  • memberSalvageValue (big-decimal)

    Sum of the salvage value of all the member assets.

    Label

    Member Salvage Value

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

    The identifier of the asset calendar period.

    Label

    Period ID

    Properties

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

    Identifier of the depreciation period.

    Label

    Period Number

    Properties

    • searchable
    • sortable
  • polishAdjustmentRecoverableCost (big-decimal)

    Adjusted recoverable cost used for assets with a Polish depreciation basis rule.

    Label

    Polish Adjustment Recoverable Cost

    Properties

    • searchable
    • sortable
  • polishDepreciationBasis (big-decimal)

    Depreciation basis amount used for assets with a Polish depreciation basis rule.

    Label

    Polish Depreciation Basis

    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
  • recoverableCost (big-decimal)

    The cost of an asset minus the salvage value.

    Label

    Recoverable Cost

    Properties

    • searchable
    • sortable
  • reserveRetiredAdjustmentAmount (big-decimal)

    Depreciation reserve retired adjustment amount for the period.

    Label

    Reserve Retired Adjustment Amount

    Properties

    • searchable
    • sortable
  • resetAdjustedCostFlag (boolean)

    Option that indicates whether there's an adjustment that requires you to recalculate the adjusted cost of the asset.

    Label

    Reset Adjusted Cost Indicator

    Properties

    • searchable
    • sortable
  • revaluationAmortizationBalance (big-decimal)

    Revaluation reserve amortization balance of the asset immediately after the impairment.

    Label

    Revaluation Amortization Balance

    Properties

    • searchable
    • sortable
  • revaluationLossBalance (big-decimal)

    The revaluation loss balance of the asset after revaluation.

    Label

    Revaluation Loss Balance

    Properties

    • searchable
    • sortable
  • revaluationReserveAdjustmentAmount (big-decimal)

    Change in the net book value due to a depreciation reserve adjustment for a revaluation period. For all other periods, the revaluation reserve amount after the Calculate Depreciation process is run.

    Label

    Revaluation Reserve Adjustment Amount

    Properties

    • searchable
    • sortable
  • revaluationReserveRetiredAdjustmentAmount (big-decimal)

    The revaluation reserve retired adjustment amount for the period.

    Label

    Revaluation Reserve Retired Adjustment Amount

    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

    Valid Values

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

    Salvage value amount for the asset.

    Label

    Salvage Value Amount

    Properties

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

    Option indicating whether the asset is added in a short tax year.

    Label

    Short year

    Properties

    • searchable
    • sortable
  • switchCode (string)

    Current depreciation code for a Polish depreciation basis that's in use for the asset.

    Label

    Switch Code

    Properties

    • searchable
    • sortable
  • systemBonusDepreciation (big-decimal)

    Bonus depreciation amount calculated by the application.

    Label

    System Bonus Depreciation

    Properties

    • searchable
    • sortable
  • systemDepreciation (big-decimal)

    Depreciation amount calculated by the application.

    Label

    System Depreciation

    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
  • 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
  • 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
  • unplannedAmount (big-decimal)

    Unplanned depreciation amount for the asset.

    Label

    Unplanned Depreciation

    Properties

    • searchable
    • sortable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

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

    A field label for entering the year-to-date annuity interest expense amount for an asset.

    Label

    YTD Annuity Interest

    Properties

    • searchable
    • sortable
  • ytdCostOfRemoval (big-decimal)

    Year-to-date amount of the cost of removal of the asset.

    Label

    YTD Cost of Removal

    Properties

    • searchable
    • sortable
  • ytdDepreciation (big-decimal)

    Year-to-date depreciation amount.

    Label

    YTD Depreciation

    Properties

    • searchable
    • sortable
  • ytdImpairment (big-decimal)

    Year-to-date impairment amount.

    Label

    YTD Impairment

    Properties

    • searchable
    • sortable
  • 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

  • assetLease (AssetLease)

    A lease stores information about assets that are leased, such as the lease terms, lessor, and whether the lease is an operating or capital lease asset.

    Business Object

    AssetLease

    Expand all

    Collapse all

    Fields

    • leaseId (int64)

      The unique identifier of the asset lease number.

      Label

      Lease ID

      Properties

      • searchable
      • sortable
      • not nullable

  • 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

  • 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

  • flatRateMethod (AssetDepreciationMethodFlatRate)

    A flat-rate depreciation method stores the annual depreciation rates entered for flat-rate depreciation methods.

    Business Object

    AssetDepreciationMethodFlatRate

    Expand all

    Collapse all

    Fields

    • flatRateId (int64)

      Number that identifies the flat rate depreciation method.

      Label

      Flat Rate ID

      Properties

      • searchable
      • sortable
      • not nullable

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

  • sourceTransaction (AssetTransaction)

    A transaction stores addition, adjustment, transfer, retirement, CIP capitalization, and mass copy information for an asset in the 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

  • terminatedTransaction (AssetTransaction)

    A transaction stores addition, adjustment, transfer, retirement, CIP capitalization, and mass copy information for an asset in the 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

Back to Top