1. Tables and Views for SCM
  2. CST_QPP_TXN_GROUPS

CST_QPP_TXN_GROUPS

This table is used to persist the transaction group and transfer transactions group identifiers for transfer transactions

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

CST_QPP_TXN_GROUPS_PK

SOURCE_SYSTEM_REFERENCE, TRANSACTION_GROUPING_CODE, INVENTORY_ORG_ID, TXN_TYPE, TRANSACTION_FLOW_TYPE, TXN_GROUP_TYPE_CODE, TXN_GROUP_TAB_COL_CODE

Columns

Name Datatype Length Precision Not-null Comments Status
TRANSACTION_GROUP_ID NUMBER 18 Yes Transaction group identifier Active
SOURCE_SYSTEM_REFERENCE VARCHAR2 60 Yes Refers to the source system Active
TRANSACTION_GROUPING_CODE VARCHAR2 100 Yes The identifier or code based on which the trans actions are grouped
INVENTORY_ORG_ID NUMBER 18 Yes Inventory organization identifier Active
COST_ORG_ID NUMBER 18 Cost organization identifier
BASE_TXN_ACTION_ID NUMBER 18 The base transaction action identifier Active
BASE_TXN_SOURCE_TYPE_ID NUMBER 18 The base transaction source type identifier Active
TXN_TYPE VARCHAR2 30 Yes Transaction type code which maps to task type for trade events Active
TRANSACTION_FLOW_TYPE NUMBER 18 Yes 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. Active
TXN_GROUP_TYPE_CODE VARCHAR2 20 Yes The code denotes the type of flow for the transaction group columns.
TXN_GROUP_TAB_COL_CODE VARCHAR2 20 Yes The table and column comination that transaction group id is derived from
DOC_SOURCE_SYSTEM_REFERENCE VARCHAR2 60 the doc shource system code Active
TRANSFER_TXN_GROUPING_CODE VARCHAR2 100 Transfer transaction column identifier or code
TRANSFER_INVENTORY_ORG_ID NUMBER 18 Transfer Inventory organization identifier Active
TRANSFER_COST_ORG_ID NUMBER 18 Transfer cost organization identifier
TRANSFER_TXN_TYPE VARCHAR2 30 Transfer transaction type code Active
TRANSFER_TRANSACTION_GROUP_ID NUMBER 18 Transfer transaction group identifier which links the transactions Active
TRANSFER_TXN_FLOW_TYPE NUMBER 18 The transaction flow type of the transfer txn that this needs to link to.
TRANSFER_TXN_GROUP_TYPE_CODE VARCHAR2 20 The code denotes the type of flow the transaction group needs to link to.
TXFR_TXN_GROUP_TAB_COL_CODE VARCHAR2 20 The table and column comination that transaction group id is to be linked to.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
TXN_GROUP_COLUMN_ID NUMBER 18 The identifier based on which the transactions are grouped Active
TRANSFER_TXN_GROUP_COLUMN_ID NUMBER 18 Transfer transaction column identifier Active

Indexes

Index Uniqueness Tablespace Columns Status
CST_QPP_TXN_GROUPS_N1 Non Unique FUSION_TS_TX_DATA TRANSACTION_GROUP_ID, NVL("TRANSFER_TRANSACTION_GROUP_ID", 0), INVENTORY_ORG_ID, BASE_TXN_SOURCE_TYPE_ID, BASE_TXN_ACTION_ID, TRANSACTION_FLOW_TYPE
CST_QPP_TXN_GROUPS_N2 Non Unique FUSION_TS_TX_DATA TXN_GROUP_TAB_COL_CODE, TRANSACTION_GROUPING_CODE
CST_QPP_TXN_GROUPS_PK Unique FUSION_TS_TX_IDX SOURCE_SYSTEM_REFERENCE, TRANSACTION_GROUPING_CODE, INVENTORY_ORG_ID, TXN_TYPE, TRANSACTION_FLOW_TYPE, TXN_GROUP_TYPE_CODE, TXN_GROUP_TAB_COL_CODE Active