Depreciation Extracts

The Depreciation Extracts view object contains information about fixed assets and their depreciation accounting.

Data Store Key : FscmTopModelAM.FinExtractAM.FaBiccExtractAM.DepreciationExtractExtractPVO

Primary Keys : FaDeprnExtractDeprnExtractId

Initial Extract Date : FaDeprnExtractCreationDate

Incremental Extract Date : FaDeprnExtractLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
FaDeprnExtractAHTransactionHeaderId	The unique identifier of the asset transaction.
FaDeprnExtractAccDeprnAdjustmentAmount	Adjustment amount calculated for retroactive adjustments included in the accelerated depreciation for the period.
FaDeprnExtractAcceleratedAdjustedCost	Base amount on which the accelerated depreciation is calculated.
FaDeprnExtractAcceleratedDeprnAmount	Adjustment to the accelerated depreciation amount for retroactive asset transactions.
FaDeprnExtractAcceleratedDeprnReserve	Accelerated depreciation reserve balance for the period.
FaDeprnExtractAcceleratedYtdDeprn	Year-to-date accelerated depreciation balance for the period.
FaDeprnExtractAdjustedCost	Depreciable basis of the asset, calculated as the recoverable cost for cost basis depreciation methods and the recoverable cost minus the accumulated depreciation for net book value basis methods.
FaDeprnExtractAssetId	Identifier of the asset number.
FaDeprnExtractAssetType	Types of assets allowed in Oracle Fusion Assets. The asset types allowed are Capitalized, Construction-in-Process, Expensed, and Group.
FaDeprnExtractBonusAdjustedCost	Base amount on which the bonus depreciation is calculated.
FaDeprnExtractBonusDeprnAdjustmentAmount	Adjustment to the bonus depreciation amount for retroactive asset transactions.
FaDeprnExtractBonusDeprnAmount	Depreciation expense calculated due to bonus depreciation.
FaDeprnExtractBonusDeprnReserve	Life-to-date backlog depreciation amount.
FaDeprnExtractBonusRuleId	Unique identifier for the bonus rule.
FaDeprnExtractBonusYtdDeprn	Accelerated bonus depreciation year-to-date balance for the period.
FaDeprnExtractBookTypeCode	The name of the asset book.
FaDeprnExtractBooksTransactionHeaderId	Unique identifier of the asset transaction.
FaDeprnExtractCapitalAdjustment	Capital adjustment balance for the period.
FaDeprnExtractCategoryBookDefaultId	The identifier of the default depreciation rules for the category in the book.
FaDeprnExtractCategoryId	The identifier of the asset category.
FaDeprnExtractCeilingTypeId	The identifier of the depreciation ceiling.
FaDeprnExtractCodeCombinationId	Depreciation expense account identifier.
FaDeprnExtractConventionTypeId	Unique identifier of the prorate convention.
FaDeprnExtractCost	Total recorded cost of the asset.
FaDeprnExtractCreatedBy	The user who created the row in the Depreciation Extracts table.
FaDeprnExtractCreationDate	The date a row was created in Depreciation Extracts table.
FaDeprnExtractCurrencyCode	The currency code of the primary ledger.
FaDeprnExtractDeprnAdjustmentAmount	Adjustment to the depreciation amount for retroactive asset transactions.
FaDeprnExtractDeprnAmount	Total depreciation amount for the period including bonus and accelerated depreciation amounts.
FaDeprnExtractDeprnExtractId	Unique sequence-generated identifier for the row in the depreciation extract.
FaDeprnExtractDeprnReserve	The accumulated depreciation of the transaction.
FaDeprnExtractDeprnRunDate	Date the Calculate Depreciation process was run.
FaDeprnExtractDeprnRunId	The identification number of the Calculate Depreciation process instance. This attribute is used in the SLA subject area to analyze accounting information for the asset depreciation.
FaDeprnExtractDeprnSourceCode	Indicates whether the depreciation record was created by running the Calculate Depreciation process or by the Member Asset Tracking functionality.
FaDeprnExtractDistributionId	Identifier of the asset distribution line.
FaDeprnExtractEmployeeId	The unique identification number of an employee.
FaDeprnExtractFlatRateId	Identifies the rates for flat rate depreciation methods.
FaDeprnExtractGeneralFund	Account used to book the capital asset utilization in the business operation.
FaDeprnExtractGroupAssetId	Group asset that is selected automatically when assets are added with this asset category.
FaDeprnExtractImpairmentAmount	Impairment loss balance of the asset immediately after the impairment.
FaDeprnExtractImpairmentReserve	The impairment reserve amount.
FaDeprnExtractLastUpdateDate	The date of the most recent change.
FaDeprnExtractLastUpdateLogin	The session login associated with the user who last updated the row in the Depreciation Extracts table.
FaDeprnExtractLastUpdatedBy	The user who last updated the Depreciation Extracts table.
FaDeprnExtractLatestFlag	The latest transaction.
FaDeprnExtractLedgerId	Unique identifier of the ledger.
FaDeprnExtractLedgerSetId	Unique identifier of the ledger set.
FaDeprnExtractLocationId	The unique identification number of the Location flexfield.
FaDeprnExtractLtdProduction	Life-to-date production for a units of production depreciation method.
FaDeprnExtractMethodId	The identifier of the depreciation method.
FaDeprnExtractNetBookValue	The net book value of an asset, calculated as the current cost minus the total reserve, multiplied by the accumulated depreciation plus the bonus reserve.
FaDeprnExtractOriginalCost	The original cost of the asset.
FaDeprnExtractPeriodCounter	Identifier of the depreciation period.
FaDeprnExtractPeriodName	The name of the depreciation period.
FaDeprnExtractProduction	The periodic production amount of the asset for this row.
FaDeprnExtractRecoverableCost	Indicates the cost of an asset minus the salvage value.
FaDeprnExtractRevalAmortization	Amount of revaluation reserve amortized during this period.
FaDeprnExtractRevalDeprnExpense	Portion of depreciation expense generated due to revaluation of the asset cost. Oracle Fusion Assets doesn't create any journal entries for this amount. It is for reporting purposes only.
FaDeprnExtractRevalReserve	Periodic revaluation reserve amortization amount for the asset.
FaDeprnExtractSalvageValue	Value an asset will realize upon its sale at the end of its useful life.
FaDeprnExtractSourceDistributionType	The table from which each row was extracted.
FaDeprnExtractSourceTable	The table from which each row was extracted.
FaDeprnExtractTotalAccDeprnReserve	The accelerated accumulated bonus depreciation of the asset for this row.
FaDeprnExtractTotalBonusDeprnReserve	The total amount of bonus depreciation recorded against an asset.
FaDeprnExtractTotalDeprnReserve	Total depreciation expense including the bonus depreciation recognized for the asset.
FaDeprnExtractTotalUnits	Total number of units assigned to the asset.
FaDeprnExtractTransactionHeaderId	The unique identifier of the asset transaction.
FaDeprnExtractUnitRatio	Ratio of the individual distribution to total units of the asset.
FaDeprnExtractUnitsAssigned	Number of assets assigned to an employee, depreciation expense account, or location.
FaDeprnExtractYtdDeprn	Year-to-date depreciation expense.
FaDeprnExtractYtdImpairment	Year-to-date impairment amount.
FaDeprnExtractYtdProduction	Year-to-date production for assets depreciating in units of production methods.
FaDeprnExtractYtdRevalDeprnExpense	Year-to-date depreciation expense due to revaluation. Oracle Fusion Assets does' nt create any journal entries for this amount. It is for reporting only.