FOS_SOURCE_TXN_EVENTS
This table is used to store event payload which is in source system format.
Details
-
Schema: FUSION
-
Object owner: FOS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FOS_SOURCE_TXN_EVENTS_PK |
TRANSACTION_LOG_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_LOG_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. | ||
| PJC_PROJECT_ID | NUMBER | 18 | Project Identifier to which the item is associated. | ||
| EVENT_GROUP | VARCHAR2 | 200 | Identifies the group of events that were received together. | ||
| 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. | |
| EVENT_TYPE | VARCHAR2 | 100 | Yes | Represents the type of the event (E.g.: Receiving, ASN) | |
| EVENT_DATE | TIMESTAMP | Yes | Represents the date the event occurred. | ||
| EVENT_DATA_ID | VARCHAR2 | 100 | Yes | Event identifier which is received in the payload of the event. | |
| EVENT_NUMBER | VARCHAR2 | 30 | Represents the user key for shipment and receiving. | ||
| EVENT_BATCH_ID | NUMBER | 18 | Identifies the set of events that are to be processed together. | ||
| TRANSACTION_TYPE_ID | VARCHAR2 | 30 | Identifies the transaction type related to the event. | ||
| EVENT_LINE_NUMBER | NUMBER | 18 | Represents the line number for shipment and receiving. | ||
| DOCUMENT_TYPE | VARCHAR2 | 50 | 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. | |
| SYSTEM_CODE | VARCHAR2 | 100 | Yes | The sytem code 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_CODE | VARCHAR2 | 100 | Yes | Identifier for the document source system. | |
| STATUS | VARCHAR2 | 30 | Identifies the processing status for this event. Valid values are contained within the FOS_SOURCE_TXN_EVENT_STATUS lookup type. | ||
| PREVIOUS_STATUS | VARCHAR2 | 30 | This column stores the status of the event during event submission. Valid values are contained within the FOS_SOURCE_TXN_EVENT_STATUS lookup type. | ||
| GROUP_ID | VARCHAR2 | 30 | Represents the identifier for a group of events that needs to be processed together during event submission. | ||
| 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 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. | |||
| 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. | |
| PHYSICAL_SHIPMENT_COSTED_FLAG | VARCHAR2 | 1 | Yes | Flag used to indicate whether costing has invoked the callback for an INTERORG_SHIPMENT event type. | |
| DROPSHIP_FLAG | VARCHAR2 | 1 | Yes | Flag used to indicate if the event was raised for a drop shipment flow. | |
| RETURN_CONSIGNMENT_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_TYPE | VARCHAR2 | 100 | Represents the parent event's type if available. | ||
| PARENT_EVENT_SYSTEM_CODE | VARCHAR2 | 100 | Represents the parent event's system code if available. | ||
| REFERENCE_EVENT_DATA_ID | VARCHAR2 | 100 | Represents the reference event's data identifier if available. | ||
| REFERENCE_EVENT_TYPE | VARCHAR2 | 100 | Represents the reference event's type identifier if available. | ||
| REFERENCE_EVENT_SYSTEM_CODE | VARCHAR2 | 100 | Represents the reference event's system code if available. | ||
| UNREFERENCED_EVENT_FLAG | VARCHAR2 | 1 | Yes | Flag used to indicate whether the event manager should process this event as an unreferenced event. | |
| TRANSACTION_ORG_CODE | VARCHAR2 | 18 | Represents the organization code from which the event originated. | ||
| INFLIGHT_TRANSACTION_FLAG | VARCHAR2 | 1 | Yes | Flag used to indicate whether this event corresponds to an in-flight transaction. | |
| PROCESSED_FLAG | VARCHAR2 | 1 | Indicates whether the event interfaced to Financial Orchestration Source Events is processed or not. | ||
| 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. | ||
| 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 | ||
| PROCESS_BATCH_ID | NUMBER | 18 | A unique batch identifier used to represent a group of orchestration tasks that have been submitted for processing. | ||
| 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 sales order line. This column is applicable only for events related to Sales Order. | |||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FOS_SOURCE_TXN_EVENTS_N1 | Non Unique | Default | SOURCE_DOCUMENT_ID, DOCUMENT_TYPE, DOCUMENT_SOURCE_SYSTEM_CODE |
| FOS_SOURCE_TXN_EVENTS_N2 | Non Unique | Default | MESSAGE_TYPE |
| FOS_SOURCE_TXN_EVENTS_N3 | Non Unique | Default | PROCESS_BATCH_ID, GROUP_ID |
| FOS_SOURCE_TXN_EVENTS_N4 | Non Unique | Default | STATUS |
| FOS_SOURCE_TXN_EVENTS_N5 | Non Unique | Default | EVENT_DATE, EVENT_TYPE |
| FOS_SOURCE_TXN_EVENTS_N6 | Non Unique | Default | EVENT_NUMBER |
| FOS_SOURCE_TXN_EVENTS_N7 | Non Unique | Default | EVENT_BATCH_ID |
| FOS_SOURCE_TXN_EVENTS_N8 | Non Unique | Default | PROCESSED_FLAG |
| FOS_SOURCE_TXN_EVENTS_N9 | Non Unique | Default | UPPER("EVENT_NUMBER") |
| FOS_SOURCE_TXN_EVENTS_U1 | Unique | Default | TRANSACTION_LOG_ID |
| FOS_SOURCE_TXN_EVENTS_U2 | Unique | Default | EVENT_TYPE, EVENT_DATA_ID, SYSTEM_CODE |