Assets History

The Assets History view object contains information about asset category change, capitalizations, unit adjustments, and partial unit retirements.

Data Store Key : FscmTopModelAM.FinExtractAM.FaBiccExtractAM.AssetHistoryExtractPVO

Primary Keys : AssetHistoryAssetId, AssetHistoryTransactionHeaderIdIn

Initial Extract Date : AssetHistoryCreationDate

Incremental Extract Date : AssetHistoryLastUpdateDate

Attributes

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

Name Description
AssetHistoryAssetId The identifier of the asset number.
AssetHistoryAssetType The type of asset. It can have these values: Capitalized, CIP, Expensed, or Group.
AssetHistoryAttribute1 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute10 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute11 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute12 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute13 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute14 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute15 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute16 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute17 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute18 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute19 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute2 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute20 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute21 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute22 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute23 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute24 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute25 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute26 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute27 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute28 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute29 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute3 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute30 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute4 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute5 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute6 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute7 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute8 A segment for the Asset History descriptive flexfield.
AssetHistoryAttribute9 A segment for the Asset History descriptive flexfield.
AssetHistoryAttributeCategoryCode The category code of the descriptive flexfield.
AssetHistoryAttributeDate1 A date segment for the Asset History descriptive flexfield.
AssetHistoryAttributeDate2 A date segment for the Asset History descriptive flexfield.
AssetHistoryAttributeDate3 A date segment for the Asset History descriptive flexfield.
AssetHistoryAttributeDate4 A date segment for the Asset History descriptive flexfield.
AssetHistoryAttributeDate5 A date segment for the Asset History descriptive flexfield.
AssetHistoryAttributeNumber1 A number segment for the Asset History descriptive flexfield.
AssetHistoryAttributeNumber2 A number segment for the Asset History descriptive flexfield.
AssetHistoryAttributeNumber3 A number segment for the Asset History descriptive flexfield.
AssetHistoryAttributeNumber4 A number segment for the Asset History descriptive flexfield.
AssetHistoryAttributeNumber5 A number segment for the Asset History descriptive flexfield.
AssetHistoryBookTypeCode The name of the asset book.
AssetHistoryCategoryId Identifier of the asset category.
AssetHistoryContext The context name for the Asset History descriptive flexfield.
AssetHistoryCreatedBy The user who created the transaction.
AssetHistoryCreationDate The date when the transaction was created.
AssetHistoryDateEffective The date from when the transaction is in effect.
AssetHistoryDateIneffective The date from when the transaction is inactive.
AssetHistoryLastUpdateDate The user who last updated the transaction.
AssetHistoryLastUpdateLogin The date when the transaction was last updated.
AssetHistoryLastUpdatedBy The session login associated to the user who last updated the transaction.
AssetHistoryLeaseTypeCode The code that identifies whether the lease is a capital or operating lease.
AssetHistoryObjectVersionNumber The number of times the transaction was updated.
AssetHistoryTransactionHeaderIdIn The identifier of the transaction that is created.
AssetHistoryTransactionHeaderIdOut The identifier of the transaction that is terminated.
AssetHistoryUnits The total number of units for the asset.