1. Tables and Views for SCM
  2. CST_INV_GP_TXNS2_GT

CST_INV_GP_TXNS2_GT

This temp table is used by the PreProcessor to captures GP txns which do not have transfer_transaction_id stamped. This table is the second temp table. It uses data from CST_INV_GP_TXNS1_GT & CMR_RCV_TRANSACTIONS to get the RT PARENT_TRANSACTION_ID which is used to chain the transactions together.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length 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
GP_FWD_FLOW_RCV_PARENT NUMBER 1 If not null, it specifies if the transaction is a part of Global Procurement Forward Flow. Its values are -1 when parent rcv_transaction_id needs to be -1 and 1 when parent rcv_transaction_id is a number other than -1.
GP_FWD_FLOW_INV_ORG_TYPE VARCHAR2 4 Possible values are 'INV' which means transfer transaction is the same inv org, 'XFER' which means that transfer transaction is from the transfer organization specified in ORIG_TRANSFER_INV_ORG & Null whcih means that it is not a Forward Flow Global Procurement (GP) transaction.
GP_MAP_TO_XFER_GROUP VARCHAR2 1 It specifies the GP_XFER_GROUP to which the transaction type maps to.
GP_XFER_GROUP VARCHAR2 1 It gives the transfer group for global procurement transactions. This grouping helps in deriving the transfer transaction id for GP txns.
ORIG_TRANSFER_INVENTORY_ORG_ID NUMBER 18 Original transfer inventory organization on the transaction. Once the transfer_transaction_id is determinted, the transfer_organiation_id is updated accordingly for the Cost Processor to be able to linkup the transactions. But using this column, PreProcessor can still figure out the link.
TXN_QTY_SIGN NUMBER 1 Sign of transaction quantity, -1 is for Issue & 1 is for Receipt. Needed since some transfer transactions have same source & action for issue and receipt legs.