Archived Subledger Accounting Events
The Archived Subledger Accounting Events view object contains the archived subledger accounting events.
Data Store Key : FscmTopModelAM.FinExtractAM.FinArchiveBiccExtractAM.ArchiveXlaEventExtractPVO
Primary Keys : EventId
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 a functional area within a software suite of products. |
| BudgetaryControlFlag | Indicates whether the event is a budgetary control event. |
| CreatedBy | The user who created the accounting event. |
| CreationDate | The date and time when the subledger accounting event was created. |
| DataSetName | The name of a set of events that are processed by a specific Create Accounting process. |
| EntityId | The internal identifier of the entity. |
| EventDate | The date when a subledger accounting event was created. |
| EventId | The unique identifier of the category of accounting events within an application and event class. |
| EventNumber | The number which identifies an accounting event. |
| EventStatusCode | The code representing the short name of the status associated with the accounting entries generated for this event. A list of accepted values is defined in the lookup type XLA_EVENT_STATUS. |
| EventTypeCode | The code representing the event type 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. |
| FileIdentifier | File Name or OCI object storage identifier of the data file using which the transaction was created. |
| HasWarningsFlag | Indicates whether an event has a warning message that resulted from the accounting process. A list of accepted values is defined in the lookup type YES_NO. |
| JobDefinitionName | The name of the job that created or last updated the row. |
| JobDefinitionPackage | The package name of the job that created or last updated the row. |
| LastUpdateDate | The date when the subledger accounting event was last updated. |
| LastUpdateLogin | The session login associated with the user who last updated the subledger accounting event. |
| LastUpdatedBy | The user who last updated the subledger accounting event. |
| ObjectVersionNumber | The number of times the subledger accounting event row has been updated. |
| OnHoldFlag | Indicates whether the event is on hold. A list of accepted values is defined in the lookup type YES_NO. |
| ProcessStatusCode | The abbreviated code that tracks the status of generated accounting entries. A list of accepted values is defined in the lookup type XLA_EVENT_PROCESS_STATUS. |
| ReferenceChar1 | The additional reference of an accounting event in the Subledger Accounting Events table stored in the character format. The caller passes this value to Subledger Accounting when the event is created. |
| ReferenceChar2 | The additional reference of an accounting event in the Subledger Accounting Events table stored in the character format. The caller passes this value to Subledger Accounting when the event is created. |
| ReferenceChar3 | The additional reference of an accounting event in the Subledger Accounting Events table stored in the character format. The caller passes this value to Subledger Accounting when the event is created. |
| ReferenceChar4 | The additional reference of an accounting event in the Subledger Accounting Events table stored in the character format. The caller passes this value to Subledger Accounting when the event is created. |
| ReferenceDate1 | The additional reference of an accounting event in the Subledger Accounting Events table stored in the date format. The caller passes this value to Subledger Accounting when the event is created. |
| ReferenceDate2 | The additional reference of an accounting event in the Subledger Accounting Events table stored in the date format. The caller passes this value to Subledger Accounting when the event is created. |
| ReferenceDate3 | The additional reference of an accounting event in the Subledger Accounting Events table stored in the date format. The caller passes this value to Subledger Accounting when the event is created. |
| ReferenceDate4 | The additional reference of an accounting event in the Subledger Accounting Events table stored in the date format. The caller passes this value to Subledger Accounting when the event is created. |
| ReferenceNum1 | The additional reference of an accounting event in the Subledger Accounting Events table stored in the numeric format. The caller passes this value to Subledger Accounting when the event is created. |
| ReferenceNum2 | The additional reference of an accounting event in the Subledger Accounting Events table stored in the numeric format. The caller passes this value to Subledger Accounting when the event is created. |
| ReferenceNum3 | The additional reference of an accounting event in the Subledger Accounting Events table stored in the numeric format. The caller passes this value to Subledger Accounting when the event is created. |
| ReferenceNum4 | The additional reference of an accounting event in the Subledger Accounting Events table stored in the numeric format. The caller passes this value to Subledger Accounting when the event is created. |
| RequestId | The unique identifier of the job that created or last updated the row. |
| TransactionDate | The date when a business transaction occurred. |
| TransactionLedgerId | The unique identifier of the ledger for which the accounting event is created. |