Subledger Accounting Events
The subledger accounting events view object contains all information related to a specific event. The combination of EventPEOApplicationId and EventPEOEventId forms the unique identifier of the Subledger Accounting Events view object.
Data Store Key : FscmTopModelAM.FinExtractAM.XlaBiccExtractAM.SubledgerJournalEventExtractPVO
Primary Keys : EventPEOEventId, EventPEOApplicationId
Initial Extract Date : EventPEOCreationDate
Incremental Extract Date : EventPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| EventPEOApplicationId | The identifier of a functional area within a software suite of products. This attribute is a part of the composite key of the Subledger Accounting Events view object. This is a foreign key of the applications view object. |
| EventPEOCreationDate | The date and time when the subledger accounting event was created. |
| EventPEOEntityId | The unique identifier of the subledger transactions associated with the accounting events. This is a foreign key of the Subledger Transaction Entities view object. |
| EventPEOEventDate | The date when a subledger accounting event is created. |
| EventPEOEventId | The identifier of the category of accounting events. This is unique within an application and event class. This attribute is a part of the composite key of the Subledger Accounting Events view object. |
| EventPEOEventNumber | The number which identifies an accounting event. |
| EventPEOEventPEOBudgetaryControlFlag | Indicates whether it's a budgetary control event. A list of accepted values is defined in the lookup type YES_NO. |
| EventPEOEventPEOCreatedBy | The user who created the subledger accounting event. |
| EventPEOEventStatusCode | 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. |
| EventPEOEventTypeCode | The unique abbreviated name assigned to an event type and used for reporting or in reference to an option. A list of accepted values are defined in the xla_entity_types_b table. |
| EventPEOFileIdentifier | File Name or OCI object storage identifier of the data file using which the transaction was created. |
| EventPEOHasWarningsFlag | 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. |
| EventPEOLanguage | The code of the language set up by the user into which the contents of the translatable attributes are translated. |
| EventPEOLastUpdateDate | The date when the subledger accounting event was last updated. |
| EventPEOLastUpdateLogin | The session login associated with the user who last updated the subledger accounting event. |
| EventPEOLastUpdatedBy | The user who last updated the subledger accounting event. |
| EventPEOMergeEventSetId | The unique identifier of merge event set, which is used in the third-party merge. The EventPEOMergeEventSetId attribute is passed to the EventPEOEventId attribute for the first event to be processed in the third-party merge as a reference. |
| EventPEOObjectVersionNumber | The number of times the subledger accounting event row has been updated. |
| EventPEOOnHoldFlag | Indicates whether the event is on hold. A list of accepted values is defined in the lookup type YES_NO. |
| EventPEOProcessStatusCode | 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. |
| EventPEOReferenceChar1 | The additional reference stored in the character format. It's used by Subledger Accounting to store additional information of an accounting event in the Subledger Accounting Events table. Information is passed by the caller to Subledger Accounting when the event is created. |
| EventPEOReferenceChar2 | The additional reference stored in the character format. It's used by Subledger Accounting to store additional information of an accounting event in the Subledger Accounting Events table. Information is passed by the caller to Subledger Accounting when the event is created. |
| EventPEOReferenceChar3 | The additional reference stored in the character format. It's used by Subledger Accounting to store additional information of an accounting event in the Subledger Accounting Events table. Information is passed by the caller to Subledger Accounting when the event is created. |
| EventPEOReferenceChar4 | The additional reference stored in the character format. It's used by Subledger Accounting to store additional information of an accounting event in the Subledger Accounting Events table. Information is passed by the caller to Subledger Accounting when the event is created. |
| EventPEOReferenceDate1 | The additional reference stored in the date format. It's used by Subledger Accounting to store additional information of an accounting event in the Subledger Accounting Events table. Information is passed by the caller to Subledger Accounting when the event is created. |
| EventPEOReferenceDate2 | The additional reference stored in the date format. It's used by Subledger Accounting to store additional information of an accounting event in the Subledger Accounting Events table. Information is passed by the caller to Subledger Accounting when the event is created. |
| EventPEOReferenceDate3 | The additional reference stored in the date format. It's used by Subledger Accounting to store additional information of an accounting event in the Subledger Accounting Events table. Information is passed by the caller to Subledger Accounting when the event is created. |
| EventPEOReferenceDate4 | The additional reference stored in the date format. It's used by Subledger Accounting to store additional information of an accounting event in the Subledger Accounting Events table. Information is passed by the caller to Subledger Accounting when the event is created. |
| EventPEOReferenceNum1 | The additional reference stored in the number format. It's used by Subledger Accounting to store additional information of an accounting event in the Subledger Accounting Events table. Information is passed by the caller to Subledger Accounting when the event is created. |
| EventPEOReferenceNum2 | The additional reference stored in the number format. It's used by Subledger Accounting to store additional information of an accounting event in the Subledger Accounting Events table. Information is passed by the caller to Subledger Accounting when the event is created. |
| EventPEOReferenceNum3 | The additional reference stored in the number format. It's used by Subledger Accounting to store additional information of an accounting event in the Subledger Accounting Events table. Information is passed by the caller to Subledger Accounting when the event is created. |
| EventPEOReferenceNum4 | The additional reference stored in the number format. It's used by Subledger Accounting to store additional information of an accounting event in the Subledger Accounting Events table. Information is passed by the caller to Subledger Accounting when the event is created. |
| EventPEORequestId | The unique identifier of the job that created or last updated the row. |
| EventPEOTransactionDate | The date when a business transaction occurred. |