1. Tables and Views for SCM
  2. FOS_TXN_EVENTS

FOS_TXN_EVENTS

This table holds payload of the events received during online processing and the processed data from the events interface table

Details

  • Schema: FUSION

  • Object owner: FOS

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

FOS_TXN_EVENTS_PK

TRANSACTION_EVENT_ID

Columns

Name Datatype Length Precision Not-null Comments
TRANSACTION_EVENT_ID NUMBER 18 Yes This is the primary key and its value is an application generated unique id.
COUNTRY_OF_ORIGIN_CODE VARCHAR2 2 Represents country of origin for the transaction.
AGREEMENT_PTR_ID NUMBER 18 This is a foreign key to the FOS_AGREEMENTS_PTR_F table.
LINK_TO_AGREEMENT_PTR_ID NUMBER 18 Represents the Primary Route identified for the document to which the event is linked to in a Drop ship scenario, otherwise it is blank.
PJC_PROJECT_ID NUMBER 18 Project Identifier to which the item is associated.
GROUP_ID NUMBER 18 This column is used by dropship receiving service to identify the transaction event records to be sent to receiving system.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
SOURCE_TXN_EVENT_ID NUMBER 18 Represents the source transaction event reference. This column is not mandatory because, in some cases, financial orchestration processes cross referenced records directly.
EVENT_DATA_ID VARCHAR2 100 Yes Event identifier which is received in the payload of the event.
EVENT_DATE TIMESTAMP Yes Represents the date the event occurred in the source system.
EVENT_NUMBER VARCHAR2 30 Represents the user key for shipment and receiving.
EVENT_LINE_NUMBER NUMBER 18 Represents the line number for shipment and receiving.
DOCUMENT_TYPE VARCHAR2 30 Yes 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.
EVENT_DEFINITION_ID NUMBER 18 Yes Foreign key reference for the event definition type from FOS_EVENT_DEFINITIONS_B table
SYSTEM_ID NUMBER 18 Yes The system identifier of the system from which the event is received.
SOURCE_DOCUMENT_ID VARCHAR2 100 Yes Represents the event source document identifier. For example, in procurement it would store the PO_LINE_LOCATION_ID; for distributed order orchestration it would store the FULFILLMENT_LINE_DETAIL_ID; and for internal material transfers it would store the LINE_ID.
DOCUMENT_SOURCE_SYSTEM_ID NUMBER 18 Yes Identifier for the document source system.
STATUS VARCHAR2 30 Identifies the processing status for this event. Valid values are contained within the FOS_TXN_EVENT_STATUS lookup type.
QUANTITY NUMBER Represents the quantity of the items or material.
UOM VARCHAR2 3 Represents the unit of measure in which the quantity is measured.
ITEM_COST NUMBER Represents the transaction cost entered for the item in the source system.
COST_CURRENCY_CODE VARCHAR2 15 Represents the currency code for transaction cost.
SECONDARY_QTY NUMBER Represents the secondary quantity.
UNREFERENCED_EVENT_FLAG VARCHAR2 1 Yes Flag used to indicate whether the event manager should process this event as an unreferenced event.
SECONDARY_UOM VARCHAR2 3 Secondary unit of measure that may have been used to do the material transaction.
CONSIGNED_FLAG VARCHAR2 1 Yes Flag used to indicate if the event was raised due to a consigment.
CORRECTION_FLAG VARCHAR2 1 Yes Flag used to indicate if the event is raised for the correction of an event that was previously raised.
DROPSHIP_FLAG VARCHAR2 1 Yes Flag used to indicate if the event was raised for a drop shipment flow.
RETURN_CONSIGNMENT_STOCK_FLAG VARCHAR2 1 Yes Flag used to determine if the event was raised for return consignment stock.
PARENT_EVENT_DATA_ID VARCHAR2 100 Represents the parent event identifier which is received in the data.
PARENT_EVENT_SYSTEM_ID NUMBER 18 Represents the parent event's type if available.
PARENT_EVENT_DEFINITION_ID NUMBER 18 Represents the parent's event definition which is identified within the FOS_EVENT_DEFINITIONS_B table.
REFERENCE_EVENT_DATA_ID VARCHAR2 100 Represents the reference event's data identifier if available.
REFERENCE_EVENT_SYSTEM_ID NUMBER 18 Represents the reference event's system identifier if available.
REFERENCE_EVENT_DEFINITION_ID NUMBER 18 Represents the reference event definition identifier which is identified within the FOS_EVENT_DEFINITIONS_B table.
TRANSACTION_ORG_CODE VARCHAR2 18 Represents the organization code from which the event originated.
ENTERPRISE_ID NUMBER 18 Yes Identifier of Enterprise, used for multi-tenancy partitioning
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
DOCUMENT_HEADER_ID NUMBER 18 Surrogate key that identifies the Fiscal Document Header.
FISCAL_DOC_LINE_ID NUMBER 18 Surrogate key that identifies the Fiscal Document Line.
FISCAL_DOC_SCHEDULE_ID NUMBER 18 Surrogate key that identifies the Fiscal Document Schedule.
ACCESS_KEY_NUMBER VARCHAR2 64 Access Key Number generated by issuer for each electronic fiscal document/electronic freight fiscal document. Unique alternative key to identify the Fiscal Document.
DOCUMENT_NUMBER VARCHAR2 30 Number for the Fiscal Document given on the Fiscal Document sent by the Supplier.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
RECEIPT_AMOUNT NUMBER Stores the receipt amount comes from receiving event.
RECEIPT_CURRENCY_CODE VARCHAR2 15 Represents currency code for the receipt Amount
MESSAGE_TYPE VARCHAR2 1 Identifies the classification of processing message for this event. Valid values are E (Error), W (Warning) and B (Both).
TAX_INVOICE_DATE DATE Tax Determinant: Date of the fiscal document.
TAX_INVOICE_NUMBER VARCHAR2 150 Tax Determinant: The number of the fiscal document.
ORDERED_UOM_QUANTITY NUMBER The converted quantity as per the unit of measure on the sales order line. This column is applicable only for events related to Sales Orders.
ORDERED_UNIT_PRICE NUMBER Price per unit of the item that is being transacted.
ORDERED_FULFILL_LINE_ID VARCHAR2 100 Represents the event source document identifier. It would store the FULFILLMENT_LINE_ID from DOO_FULFILL_LINE_DETAILS.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table Foreign Table Foreign Key Column
FOS_TXN_EVENTS fos_event_definitions_b EVENT_DEFINITION_ID

Indexes

Index Uniqueness Tablespace Columns
FOS_TXN_EVENTS_N1 Non Unique Default EVENT_DEFINITION_ID
FOS_TXN_EVENTS_N2 Non Unique Default STATUS
FOS_TXN_EVENTS_N3 Non Unique Default SOURCE_DOCUMENT_ID, DOCUMENT_TYPE, DOCUMENT_SOURCE_SYSTEM_ID
FOS_TXN_EVENTS_N4 Non Unique Default MESSAGE_TYPE
FOS_TXN_EVENTS_N5 Non Unique Default EVENT_DATE, EVENT_DEFINITION_ID
FOS_TXN_EVENTS_N6 Non Unique Default EVENT_NUMBER
FOS_TXN_EVENTS_N7 Non Unique Default UPPER("EVENT_DATA_ID"), EVENT_DEFINITION_ID, SYSTEM_ID
FOS_TXN_EVENTS_N8 Non Unique Default UPPER("EVENT_NUMBER")
FOS_TXN_EVENTS_PK Unique Default TRANSACTION_EVENT_ID
FOS_TXN_EVENTS_U1 Unique Default EVENT_DATA_ID, EVENT_DEFINITION_ID, SYSTEM_ID
FOS_TXN_EVENTS_U2 Unique Default SOURCE_TXN_EVENT_ID