AssetFinancialDetail
Financial detail transactions store the financial information and depreciation rules required for calculating depreciation in the primary asset book.
Business Views
** Available for extracting data- assetFinancialDetailsExtract**
This view contains financial information, descriptive details, depreciation rules, and the period details of the asset.
Label
Asset Financial Details
Data Source
Read-optimized data store
Fields
- activeFlag (boolean)
Latest record of the transaction.
Label
Active Indicator
Properties
- searchable
- sortable
- not nullable
- 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)
The adjusted cost of an asset.
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)
The adjusted portion of the current cost that can be depreciated.
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)
The historical cost of an adjusted asset.
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
- 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
- disableGroupAssetFlag (boolean)
Indicates whether the group asset is enabled.
Label
Disable group asset
Properties
- searchable
- sortable
- 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
- 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)
The original cost of the asset.
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
- reductionRateAdditionFlag (boolean)
Indicates whether the reduction rate should be applied for member asset additions.
Label
Reduction Rate for Addition
Properties
- searchable
- sortable
- reductionRateAdjustmentFlag (boolean)
Indicates whether the reduction rate should be applied for member asset adjustments.
Label
Reduction Rate for Financial Transaction
Properties
- searchable
- sortable
- reductionRateRetirementFlag (boolean)
Indicates whether the reduction rate should be applied for member asset retirements.
Label
Reduction Rate for Retirement
Properties
- searchable
- sortable
- remainingLifeFromInServiceDate (int32)
Remaining life of the asset calculated as of the fiscal year start date.
Label
Remaining Life as of Fiscal Year Start Date
Properties
- searchable
- sortable
- remainingLifeFromProrateDate (int32)
Remaining life of the asset calculated as of the conversion date, prorate date, or fiscal year start date.
Label
Remaining Life as of Conversion Date
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 (int32)
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)
Option indicating whether the asset is added in a short tax year.
Label
Short year
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
- useBooksSummaryFlag (boolean)
Indicates whether the FA_BOOKS_SUMMARY table for the asset was populated.
Label
Use Books Summary
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
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
AssetLeaseFields
- leaseId (int64)
The unique identifier of the asset lease number.
Label
Lease ID
Properties
- searchable
- sortable
- not nullable
- leaseId (int64)
- 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
AssetBonusDepreciationRuleFields
- bonusRuleId (int64)
Code that identifies the depreciation bonus rule.
Label
Bonus Rule ID
Properties
- searchable
- sortable
- not nullable
- bonusRuleId (int64)
- 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
AssetBookPeriodFields
- 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
- bookName (string)
- 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
AssetCashGeneratingUnitFields
- ceilingType (AssetDepreciationCeiling)
A ceiling value stores the ceiling type, such as the expense ceiling or cost ceiling, and the currency code for the asset book.
Business Object
AssetDepreciationCeilingFields
- ceilingTypeId (int64)
Number that uniquely identifies the ceiling type.
Label
Ceiling Type ID
Properties
- searchable
- sortable
- not nullable
- ceilingTypeId (int64)
- 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
AssetDepreciationMethodFields
- methodId (int64)
Identifier of the depreciation method.
Label
Method ID
Properties
- searchable
- sortable
- not nullable
- methodId (int64)
- 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
AssetBookPeriodFields
- 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
- bookName (string)
- 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
AssetBookPeriodFields
- 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
- bookName (string)
- fullyTransferredPeriod (AssetBookPeriod)
A book period contains information about the depreciation period status, period open date, and period close date for each asset book.
Business Object
AssetBookPeriodFields
- 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
- bookName (string)
- 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
AssetFields
- assetId (int64)
The identifier of the asset number.
Label
Asset ID
Properties
- searchable
- sortable
- not nullable
- assetId (int64)
- 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
AssetBookPeriodFields
- 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
- bookName (string)
- 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
AssetDepreciationMethodFields
- methodId (int64)
Identifier of the depreciation method.
Label
Method ID
Properties
- searchable
- sortable
- not nullable
- methodId (int64)
- prorateConvention (AssetProrateConvention)
A prorate convention contains the date that maps a date placed in service to a prorate date for depreciation calculation.
Business Object
AssetProrateConventionFields
- conventionTypeId (int64)
Unique identifier of the prorate convention.
Label
Prorate Convention ID
Properties
- searchable
- sortable
- not nullable
- conventionTypeId (int64)
- retirement (AssetRetirement)
A retirement transaction stores information such as the retirement date, cost retired, retirement convention, and gain or loss in the primary asset book.
Business Object
AssetRetirementFields
- retirementId (int64)
The identifier of the asset retirement transaction.
Label
Retirement Identifier
Properties
- searchable
- sortable
- not nullable
- retirementId (int64)
- sourceTransaction (AssetTransaction)
A transaction stores addition, adjustment, transfer, retirement, CIP capitalization, and mass copy information for an asset in the asset book.
Business Object
AssetTransactionFields
- 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
- bookName (string)
- terminatedTransaction (AssetTransaction)
A transaction stores addition, adjustment, transfer, retirement, CIP capitalization, and mass copy information for an asset in the asset book.
Business Object
AssetTransactionFields
- 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
- bookName (string)
- activeFlag (boolean)