Transaction Events
The Transaction Events view object holds payload of the events received during online processing and the processed data from the events interface table.
Data Store Key : FscmTopModelAM.ScmExtractAM.FosBiccExtractAM.FosTransactionEventExtractPVO
Primary Keys : TransactionEventPEOTransactionEventId
Initial Extract Date : TransactionEventPEOCreationDate
Incremental Extract Date : TransactionEventPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| TransactionEventPEOAccessKeyNumber | Value that identifies the issuer for each electronic fiscal document or electronic freight fiscal document. This is a unique alternative key to identify the fiscal document. |
| TransactionEventPEOConsignedFlag | Value that indicates if event was raised due to a consignment. |
| TransactionEventPEOCorrectionFlag | Value that indicates if the event is raised for the correction of an event that was previously raised. |
| TransactionEventPEOCostCurrencyCode | Value that identifies the currency code for transaction cost. |
| TransactionEventPEOCreatedBy | User who created the transaction event. |
| TransactionEventPEOCreationDate | Date when the transaction event was created. |
| TransactionEventPEODocumentHeaderId | Value that identifies the fiscal document header. |
| TransactionEventPEODocumentNumber | Value that identifies the number for the fiscal document given on the fiscal document sent by the supplier. |
| TransactionEventPEODocumentSourceSystemId | Value that identifies the document source system. |
| TransactionEventPEODocumentType | Value that identifies the type of the document to which this event belongs. Valid values are contained within the FOS_IMT_DOCUMENT_TYPES, FOS_PROCUREMENT_DOCUMENT_TYPES, and FOS_SHIPMENT_DOCUMENT_TYPES lookup types. |
| TransactionEventPEODropshipFlag | Value that indicates if the event was raised for a drop shipment flow. |
| TransactionEventPEOEnterpriseId | Value that identifies the enterprise that's used for multiple tenancy partitioning |
| TransactionEventPEOEventDataId | Value that identifies the event identifier which is received in the payload of the event. |
| TransactionEventPEOEventDate | Value that identifies the date the event occurred in the source system. |
| TransactionEventPEOEventDefinitionId | Value that identifies the foreign key reference for the event definition type from Event Definitions view object |
| TransactionEventPEOEventLineNumber | Value that identifies the line number for shipment and receiving. |
| TransactionEventPEOEventNumber | Value that identifies the user key for shipment and receiving. |
| TransactionEventPEOFiscalDocLineId | Value that identifies the fiscal document line. |
| TransactionEventPEOFiscalDocScheduleId | Value that identifies the fiscal document schedule. |
| TransactionEventPEOGroupId | Value that's used by the drop ship receiving service to identify the transaction event records to be sent to the receiving system. |
| TransactionEventPEOItemCost | Value that identifies the transaction cost entered for the item in the source system. |
| TransactionEventPEOJobDefinitionName | Value that identifies the name of the job that created or last updated the row. |
| TransactionEventPEOJobDefinitionPackage | Value that identifies the package name of the job that created or last updated the row. |
| TransactionEventPEOLastUpdateDate | Date when the transaction event was last updated. |
| TransactionEventPEOLastUpdateLogin | Session login associated with the user who last updated the transaction event. |
| TransactionEventPEOLastUpdatedBy | User who last updated the transaction event. |
| TransactionEventPEOMessageType | Value that identifies the classification of processing message for this event. Valid values are E, W, and B. If E then the messages is an error, if W, then the message is a warning, If B, then the message is both a warning and an error. |
| TransactionEventPEOObjectVersionNumber | Value that identifies the number of times the transaction event row has been updated. |
| TransactionEventPEOParentEventDataId | Value that identifies the parent event identifier which is received in the data. |
| TransactionEventPEOParentEventDefinitionId | Value that identifies the parent event definition which is identified within the Event Definitions view object. |
| TransactionEventPEOParentEventSystemId | Value that identifies the parent events type, if available. |
| TransactionEventPEOQuantity | Value that identifies the quantity of the items or material. |
| TransactionEventPEOReceiptAmount | Value that identifies the receipt amount comes from receiving event. |
| TransactionEventPEOReceiptCurrencyCode | Value that identifies the currency code for the receipt Amount |
| TransactionEventPEOReferenceEventDataId | Value that identifies the reference event data identifier, if available. |
| TransactionEventPEOReferenceEventDefinitionId | Value that identifies the reference of event definition identifier which is identified within the Event Definitions view object. |
| TransactionEventPEOReferenceEventSystemId | Value that identifies the reference event's system identifier if available. |
| TransactionEventPEORequestId | Value that identifies the request ID of the job that created or last updated the row. |
| TransactionEventPEOReturnConsignmentStockFlag | Value that indicates if the event was raised for return consignment stock. |
| TransactionEventPEOSecondaryQty | Value that identifies the secondary quantity. |
| TransactionEventPEOSecondaryUom | Value that identifies the secondary unit of measure that may have been used to do the material transaction. |
| TransactionEventPEOSourceDocumentId | Value that identifies the event source document identifier. For example, in procurement it stores the PO_LINE_LOCATION_ID, for distributed order orchestration it would store the FULFILLMENT_LINE_DETAIL_ID, and for internal material transfer it would store the LINE_ID. |
| TransactionEventPEOSourceTxnEventId | Value that identifies the source transaction event reference. This column isn't mandatory because, in some cases, financial orchestration processes cross referenced transactions directly. |
| TransactionEventPEOStatus | Value that identifies the processing status for this event. Valid values are contained within the FOS_TXN_EVENT_STATUS lookup type. |
| TransactionEventPEOSystemId | Value that identifies the system identifier of the system from which the event is received. |
| TransactionEventPEOTaxInvoiceDate | Date of the fiscal document. |
| TransactionEventPEOTaxInvoiceNumber | Value that identifies the number of the fiscal document. |
| TransactionEventPEOTransactionEventId | Value that uniquely identifies the transaction events. This is the primary key of the Transaction Events view object. |
| TransactionEventPEOTransactionOrgCode | Value that identifies the organization code from which the event originated. |
| TransactionEventPEOUnreferencedEventFlag | Value that indicates whether the event manager should process this event as an unreferenced event. |
| TransactionEventPEOUom | Value that identifies the unit of measure in which the quantity is measured. |