1. Tables and Views for SCM
  2. CST_QPP_TXN_GROUPS_GT

CST_QPP_TXN_GROUPS_GT

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_GT_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
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_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.
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 Columns Status
CST_QPP_TXN_GROUPS_GT_PK Unique SOURCE_SYSTEM_REFERENCE, TRANSACTION_GROUPING_CODE, INVENTORY_ORG_ID, TXN_TYPE, TRANSACTION_FLOW_TYPE, TXN_GROUP_TYPE_CODE, TXN_GROUP_TAB_COL_CODE Active