CST_INV_GP_TXNS4_GT
This temp table is used by the PreProcessor and contains the transfer_transaction_id for the Global Procurement (GP) transactions. It is derived from CST_INV_GP_TXNS2_GT (which has GP transactions & parent rcv_transaction_id) & CST_INV_GP_TXNS3_GT (which contains the transactions that get linked to using the parent rcv_transaction_id the mapping columns). The insert is done in two steps, first is to get transfer_transaction_id only for the forward flow of GP transactions and the second step is to find it for all the other flows.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Precision | Comments |
|---|---|---|---|
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Single column FK: Identifies the Inventory transaction. |
| INVENTORY_ORG_ID | NUMBER | 18 | Indicates The Inventory Org To Which The Item Belongs |
| TRANSACTION_FLOW_TYPE | NUMBER | 18 | 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. |
| RCV_TRANSACTION_ID | NUMBER | 18 | Identifier to Rcv_transactions table |
| PARENT_TRANSACTION_ID | NUMBER | 18 | Parent Receiving Transaction identifier in Rcv_transactions table |
| TRANSFER_CST_INV_TXN_ID | NUMBER | 18 | Source inventory transaction identifying the other leg of transfer transaction |
| TRANSFER_TRANSACTION_ID | NUMBER | 18 | Transfer transaction identifier to source inventory table |
| TRANSFER_INVENTORY_ORG_ID | NUMBER | 18 | Inventory Organization identifier associated with the other leg of transfer transaction |