Archived Subledger Transaction Entities

The Archived Subledger Transaction Entities view object contains the archived subledger transaction entities.

Data Store Key : FscmTopModelAM.FinExtractAM.FinArchiveBiccExtractAM.ArchiveXlaTransactionEntityExtractPVO

Primary Keys : EntityId

Initial Extract Date : CreationDate

Incremental Extract Date :

Attributes

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

Name Description
ApplicationId The unique identifier of the application to which the transaction is applied using the business flow feature.
CreatedBy The user who created the subledger transaction entity.
CreationDate The date and time when the subledger transaction entity was created.
EntityCode The code that identifies an entity and used for reporting or as a reference to an option. A list of accepted values is defined in the XLA_ENTITY_TYPES_B table.
EntityId The unique identifier of the subledger transactions associated with the accounting events.
LastUpdateDate The date when the subledger transaction entity row was last updated.
LastUpdateLogin The session login associated with the user who last updated the subledger transaction entity.
LastUpdatedBy The user who last updated the subledger transaction entity row.
LedgerId The unique identifier of the Ledgers view object.
LegalEntityId The identifier of a recognized party that has rights and responsibilities assigned by legislation.
ObjectVersionNumber The number of times the subledger transaction entity row has been updated.
SecurityIdChar1 The value passed by each subledger to Subledger Accounting based on its security model.
SecurityIdChar2 The value passed by each subledger to Subledger Accounting based on its security model.
SecurityIdChar3 The value passed by each subledger to Subledger Accounting based on its security model.
SecurityIdInt1 The value passed by each subledger to Subledger Accounting based on its security model.
SecurityIdInt2 The value passed by each subledger to Subledger Accounting based on its security model.
SecurityIdInt3 The value passed by each subledger to Subledger Accounting based on its security model.
SourceApplicationId The internal identifier of the source application.
SourceIdChar1 The value passed by each subledger to Subledger Accounting based on its data model.
SourceIdChar2 The value passed by each subledger to Subledger Accounting based on its data model.
SourceIdChar3 The value passed by each subledger to Subledger Accounting based on its data model.
SourceIdChar4 The value passed by each subledger to Subledger Accounting based on its data model.
SourceIdInt1 The value passed by each subledger to Subledger Accounting based on its data model.
SourceIdInt2 The value passed by each subledger to Subledger Accounting based on its data model.
SourceIdInt3 The value passed by each subledger to Subledger Accounting based on its data model.
SourceIdInt4 The value passed by each subledger to Subledger Accounting based on its data model.
TransactionNumber The alphanumeric transaction number that uniquely identifies a transaction within the application.
ValuationMethod The valuation of an underlying accounting event that can be valued with a different monetary value and accounted differently.