CST_QPP_TRADE_SERVICE_REPLY_GT
The table is used to store the status of the trade agreement service call
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_QPP_TRADE_SERVICE_REP_PK |
CST_INV_TRANSACTION_ID, SOURCE_DOCUMENT_SYSTEM_CODE, TRANSACTION_TYPE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_TYPE_ID | NUMBER | 18 | Yes | Transaction Type Identifier | |
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Yes | Costinv inventory transaction identifier | |
| SOURCE_DOCUMENT_ID | VARCHAR2 | 30 | Source Document Identifier | ||
| SOURCE_DOCUMENT_TYPE_CODE | VARCHAR2 | 30 | Source Document Type, IOT - Inter Org Transfer, SO - Sales Order | ||
| SOURCE_DOCUMENT_SYSTEM_CODE | VARCHAR2 | 30 | Yes | Source Document External System Reference | |
| TRANSACTION_DATE | DATE | Transaction Date | |||
| FROM_ORG_ID | NUMBER | 18 | Transfer From Organization Identifier | ||
| TO_ORG_ID | NUMBER | 18 | Transfer To Organization Identifier | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory Item Identifier | ||
| RMA_SOURCE_DOCUMENT_ID | VARCHAR2 | 30 | RMA Source Document Identifier | ||
| STATUS | VARCHAR2 | 30 | Denotes whether the shipment transaction (and the transfer) has a trade agreement defined or not. In case of Dropship, the status is UnKnown till trade agreement is defined | ||
| TRADE_AGREEMENT_PTR_ID | NUMBER | 18 | Trade Agreement PTR Identifier | ||
| SUCCESSOR_BUSINESS_UNIT_ID | NUMBER | 18 | Successor Business Unit Identifier in the Transfer | ||
| SUCCESSOR_INVENTORY_ORG_ID | NUMBER | 18 | Successor Business Unit Identifier in the Transfer | ||
| TRANSACTION_ID | NUMBER | 18 | Deprecated |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_QPP_TRADE_SERVICE_REP_PK | Unique | CST_INV_TRANSACTION_ID, SOURCE_DOCUMENT_SYSTEM_CODE, TRANSACTION_TYPE_ID |