CST_QPP_UPDATE_TXN_GROUPS_GT
Global temporary table to support updating of data in the CST_QPP_TXN_GROUPS table.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Refers to the source system | |
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | External system reference identifier | |
| INVENTORY_ORG_ID | NUMBER | 18 | Inventory organization identifier | |
| BASE_TXN_SOURCE_TYPE_ID | NUMBER | 18 | The base transaction action identifier | |
| BASE_TXN_ACTION_ID | NUMBER | 18 | The base transaction source type identifier | |
| TRANSACTION_FLOW_TYPE | NUMBER | 18 | Transaction flow identifier | |
| TRANSACTION_GROUP_ID | NUMBER | 18 | Transaction group identifier | |
| TRANSFER_TRANSACTION_GROUP_ID | NUMBER | 18 | Transfer transaction group identifier which links the transactions |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_QPP_UPD_TXN_GRPS_GT_N1 | Non Unique | EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, INVENTORY_ORG_ID, BASE_TXN_SOURCE_TYPE_ID, BASE_TXN_ACTION_ID, TRANSACTION_FLOW_TYPE |