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. | ||
INV_PROJECT_ID | NUMBER | 18 | Inventory 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 | Status |
---|---|---|---|---|
FOS_TXN_EVENTS_N1 | Non Unique | Default | EVENT_DEFINITION_ID | Obsolete |
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 |