Transaction Extracts

The Transaction Extracts view object contains information about fixed assets and their transactions.

Data Store Key : FscmTopModelAM.FinExtractAM.FaBiccExtractAM.TrxExtractExtractPVO

Primary Keys : TrxExtractTrxExtractId

Initial Extract Date :

Incremental Extract Date : TrxExtractLastUpdateDate

Attributes

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

Name	Description
TrxExtractAHTransactionHeaderId	Unique identifier of the asset transaction.
TrxExtractAdjustmentLineId	Identifier of the asset accounting line.
TrxExtractAdjustmentType	The type of account that the adjustment affects.
TrxExtractAssetId	Identifier of the asset number.
TrxExtractAssetType	Types of assets allowed in Oracle Fusion Assets. The asset types allowed are Capitalized, Construction-in-Process, Expensed, and Group.
TrxExtractBonusExpense	The bonus depreciation amount of the transaction.
TrxExtractBonusReserve	The accumulated bonus depreciation of the transaction.
TrxExtractBookTypeCode	The name of the asset book.
TrxExtractBooksTransactionHeaderId	The unique identifier of the asset transaction.
TrxExtractCapitalizationFlag	Indicates whether the asset is a capitalized asset.
TrxExtractCategoryBookDefaultId	The identifier of the default depreciation rules for the category in the book.
TrxExtractCategoryId	The identifier of the asset category.
TrxExtractCipCost	The CIP cost of the transaction for this row.
TrxExtractCipCostClearing	The CIP cost clearing amount of the transaction.
TrxExtractCodeCombinationId	Depreciation expense account identifier.
TrxExtractCost	The cost of the transaction.
TrxExtractCostClearing	The cost clearing amount of the transaction.
TrxExtractCostOfRemoval	Amount required to remove the retired asset.
TrxExtractCreatedBy	The user who created a row in the Transaction Extracts table.
TrxExtractCreationDate	The date the row was created in the Transaction Extracts table.
TrxExtractCurrencyCode	The currency code of the primary ledger.
TrxExtractDeprnOverrideFlag	Indicates whether a depreciation override amount is allowed for assets in the book.
TrxExtractDistributionId	Identifier of the asset distribution.
TrxExtractEmployeeId	Identifier of the employee to whom the asset is assigned.
TrxExtractExpense	The depreciation amount for the transaction.
TrxExtractImpairmentExpense	Impairment loss balance of the asset immediately after the impairment.
TrxExtractImpairmentId	Identifier of the impairment transaction.
TrxExtractImpairmentReserve	The impairment reserve amount.
TrxExtractInvoiceTransactionId	Unique identifier of the invoice transaction.
TrxExtractInvoiceTransactionType	Identifier of the invoice transaction type that was performed.
TrxExtractLastUpdateDate	The date of the most recent change.
TrxExtractLastUpdateLogin	The session login associated with the user who last updated the Transaction Extracts table.
TrxExtractLastUpdatedBy	The user who last updated the Transaction Extracts table.
TrxExtractLedgerId	The unique identifier of the ledger.
TrxExtractLedgerSetId	The unique identifier of the ledger set.
TrxExtractLocationId	The unique identification number of the Location flexfield.
TrxExtractMassTransactionId	Identifier of the mass transaction.
TrxExtractNbvRetired	Net book value of an asset at the time of retirement.
TrxExtractNewBooksTrxIdIn	The unique identifier of the latest transaction that was performed.
TrxExtractOldBooksTrxIdIn	The unique identifier of the transaction before the latest transaction was performed.
TrxExtractOriginalCost	The original cost of the transaction.
TrxExtractPeriodCounter	Identifier of the depreciation period.
TrxExtractPeriodName	The name of the depreciation period.
TrxExtractProceedsOfSale	Amount received from the sale of an asset.
TrxExtractRecoverableCost	The cost of an asset minus the salvage value.
TrxExtractReserve	The accumulated depreciation of the transaction.
TrxExtractRetirementId	The identifier of the asset retirement transaction.
TrxExtractRetirementTrxId	Identifier of the asset retirement transaction.
TrxExtractRevalReserve	Periodic revaluation reserve amortization amount for the asset.
TrxExtractSalvageValue	Value an asset will realize upon its sale at the end of its useful life.
TrxExtractSourceDestCode	Indicates whether this line is on the source or destination side of a transaction.
TrxExtractSourceDistributionType	Indicates whether the row was extracted for a transaction or periodic depreciation row.
TrxExtractSourceLineId	Identifier of the asset source line.
TrxExtractSourceTable	The table from which each row was extracted.
TrxExtractSourceTypeCode	Asset transaction type of the accounting line.
TrxExtractTotalUnits	Total number of units assigned to the asset.
TrxExtractTrackMemberFlag	Option indicating whether the account information is created at the member asset level or at group asset level.
TrxExtractTransactionHeaderId	Unique identifier of the asset transaction.
TrxExtractTransactionKey	A subclassification of an asset transaction. For example, amortized, expensed, or impairment.
TrxExtractTransactionTypeCode	A classification of events that can occur during an asset's life. For example, additions, adjustments, or retirements.
TrxExtractTrxExtractId	Unique sequence-generated identifier for the row in the transaction extract.
TrxExtractUnitRatio	Ratio of the individual distribution to total units of the asset.
TrxExtractUnitsAssigned	Number of assets assigned to an employee, depreciation expense account, or location.
TrxExtractUnplannedTrxId	Identifier of the asset unplanned depreciation transaction.