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. |