1. Tables and Views for SCM
  2. CST_FDC_TXN_PREPROCESS_S_GT

CST_FDC_TXN_PREPROCESS_S_GT

Global temporary table used in the cost preprocessor. It holds the PO related fiscal doc inventory transaction information that came in from the Inventory transaction interface and needs to be processed by the cost preprocessor to derive the transaction cost.

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 transaction whose incoming cost needs to be computed.
PRIMARY_QTY NUMBER Transaction Quantity in Primary unit of measure.
PRIMARY_UOM VARCHAR2 25 Inventory Items Primary UOM Code.
SECONDARY_QTY NUMBER Transaction quantity in secondary unit of measure.
SECONDARY_UOM VARCHAR2 25 Secondary unit of measure of the item.
PARENT_DELIVERY_TXN_ID NUMBER 18 Identifies the parent delivery transaction if this is a PO adjustment or return transaction.
CMR_PO_DISTRIBUTION_ID NUMBER 18 Single column FK: Identifies the PO distribution associated with the transaction.
CMR_PO_LINE_LOCATION_ID NUMBER 18 Single column FK: Identifies the PO schedule associated with the transaction.
CMR_ROOT_RCV_TXN_ID NUMBER 18 Single column FK: Identifies the root receipt transaction associated with the transaction.
ROOT_RCV_TXN_ID NUMBER 18 Identifies the root receipt transaction associated with the transaction.
PO_PRICE_FLAG VARCHAR2 1 Indicates if the transaction cost can directly be obtained from the PO price. This is the case when there are no invoices for the associated PO.
TRANSACTION_SOURCE_TYPE_ID NUMBER 18 Transaction source type identifier.
TRANSACTION_ACTION_ID NUMBER 18 Transaction action identifier maps inventory transaction action.
ROOT_RCPT_CURR_CONV_RATE NUMBER Currency conversion rate specified on the root receive transaction associated with this delivery. This rate is used for currency conversion for deliveries against PO's whose invoices are matched to receipts.
FISCAL_DOC_HEADER_ID NUMBER 18 Fiscal document header identifier.
FISCAL_DOC_LINE_ID NUMBER 18 Fiscal document line identifier.
FISCAL_DOC_SCHEDULE_ID NUMBER 18 Fiscal document schedule identifier.
ROW_UPDATED_FLAG VARCHAR2 1 Indicates if this row has been updated during the process.
COST_PREPROCESSING_STATUS VARCHAR2 30 The status of cost processing of transactions.
CURRENCY_CONVERSION_RATE NUMBER The conversion rate from the entered currency on the purchase order to the functional currency of the Bill to business unit on the purchase order.
EXTERNAL_SYSTEM_REFERENCE VARCHAR2 60 Identifies the external source system. In case of inventory transfers it is CST with parent transaction identifier relating to original row.
EXTERNAL_SYSTEM_REF_ID VARCHAR2 30 Stores a value that uniquely identifies a certain instance of an object within the external system.
INVENTORY_ORG_ID NUMBER 18 Indicates the inventory organization to which the item belongs.
TRANSACTION_QTY NUMBER Transaction quantity of trade event.
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.