CST_TRANSACTION_EVENTS
This table contains the information about the SLA events corresponding to the transaction types of the inventory transactions in costing.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
CST_TRANSACTION_EVENTS_PK |
TRANSACTION_EVENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_EVENT_ID | NUMBER | 18 | Yes | Surrogate key that identifies a row in this table. | |
| ALLOW_PROJECT_TXN | VARCHAR2 | 1 | Indicates if an event class for which accounting template is defined can be transferred to projects | ||
| PROJECT_OVERRIDE_FLAG | VARCHAR2 | 1 | Indicates if the behavior needs to be modified for a flow | ||
| TRANSACTION_SOURCE_TYPE_ID | NUMBER | 18 | Transaction Source | ||
| TRANSACTION_ACTION_ID | NUMBER | 18 | Transaction Action | ||
| CONSIGNED_FLAG | VARCHAR2 | 1 | Yes | Indiacates if the Event is for the Supplier Consigned transactions. | |
| COST_TRANSACTION_TYPE | VARCHAR2 | 10 | This mainly used to identify the correct event type for direct transfers. In this case, for the same source & action, 2 different event types are possible depending upon issue or receipt of the transfer. | ||
| DEFAULT_COST_TXN_TYPE | VARCHAR2 | 10 | Default Transaction type. Only used for information purposes. | ||
| ADDITIONAL_PROCESSING_CODE | VARCHAR2 | 20 | Additional Processing Code is an optional further definition of the Cost Transaction Type such as TRANSFER of an issue transaction, or an adjustment transaction due to USER, ACQUISITION or an ITEM. | ||
| TRANSACTION_SUB_TYPE | VARCHAR2 | 30 | Further qualifies a transaction source/type. This allows having different events generated from same transaction type depending on transaction context e.g. DISCRETE_MANUFACTURING, MAINTENANCE. | ||
| TRANSACTION_FLOW_TYPE | NUMBER | 18 | Transaction Flow Identifier, 1 - Internal Drop Shipment, 2 - Global Procurement, 3 - Customer Drop Shipment, 4 - Intransit Interorg Transfer, 5 - Direct Interorg Transfer, 6 - Intraorg Transfer, 7 - Transfer Order Intransit Interorg Transfer, 8 - Transfer Order Direct Interorg Transfer, 9 - Transfer Order Intraorg Transfer, 10 - TIR/TIRR at ownership change in procuring org for consigned PO, 11 - TIRR of TO Return with Scrap or null for others. | ||
| SOURCE_TABLE | VARCHAR2 | 30 | Indicates the the source_table from which the distribution is created. | ||
| 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_CLASS_CODE | VARCHAR2 | 30 | Yes | Reference to event class for which the accounting template is defined. | |
| EVENT_TYPE_CODE | VARCHAR2 | 30 | Yes | Reference to the event type mapped to the transaction type. | |
| ENTITY_CODE | VARCHAR2 | 30 | Yes | Reference to the entity code of the event. | |
| 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. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CST_TRANSACTION_EVENTS | inv_txn_source_types_b | TRANSACTION_SOURCE_TYPE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_TRANSACTION_EVENTS_N1 | Non Unique | FUSION_TS_TX_DATA | TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_ACTION_ID, ADDITIONAL_PROCESSING_CODE, TRANSACTION_FLOW_TYPE |
| CST_TRANSACTION_EVENTS_N2 | Non Unique | FUSION_TS_TX_DATA | ADDITIONAL_PROCESSING_CODE |
| CST_TRANSACTION_EVENTS_U1 | Unique | FUSION_TS_TX_DATA | TRANSACTION_EVENT_ID, ORA_SEED_SET1 |
| CST_TRANSACTION_EVENTS_U11 | Unique | FUSION_TS_TX_DATA | TRANSACTION_EVENT_ID, ORA_SEED_SET2 |