CST_QPP_TRADE_SERVICE_CALL_GT
This table is used to gather the data that would be passed to SFO service to check if the shipment transaction has a trade agreement defined or not.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_TYPE_ID | NUMBER | 18 | Transaction type identifier | ||
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Yes | Cost inventory transaction identifier | |
| RECEIPT_TRANSACTION_ID | NUMBER | 18 | Receipt Transaction Identifier | ||
| SOURCE_DOCUMENT_ID | VARCHAR2 | 30 | Source Doucument Identifier | ||
| SOURCE_DOCUMENT_TYPE_CODE | VARCHAR2 | 30 | Source Document Type, IOT - Interorg transfer, SO - Sales Order | ||
| SOURCE_DOCUMENT_SYSTEM_CODE | VARCHAR2 | 30 | Source documents 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 | ||
| TRANSACTION_ID | NUMBER | 18 | Deprecated |