CST_TXN_PREPROCESS_GT

Global temporary table used in the cost preprocessor. It holds the PO related 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.
TRANSACTION_SOURCE_TYPE_ID	NUMBER		18	Transaction source type identifier.
TRANSACTION_ACTION_ID	NUMBER		18	Transaction action identifer.
PRIMARY_QTY	NUMBER			Transaction Quantity in Primary unit of measure.
PRIMARY_UOM	VARCHAR2	25		Inventory Items Primary UOM Code.
SECONDARY_QTY	NUMBER			Secondary Transaction Quantity.
SECONDARY_UOM	VARCHAR2	25		Secondary unit of measure of the item.
SOURCE_DOC_QTY	NUMBER			Transaction Quantity in source document unit of measure.
SOURCE_DOC_UOM	VARCHAR2	25		Source document unit of measure.
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_ROOT_RCV_TXN_ID	NUMBER		18	Single column FK: Identifies the root receipt transaction associated with the transaction.
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 POs whose invoices are matched to receipts.
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.
MATCH_OPTION	VARCHAR2	25		Purchase order invoicing match option against a order or receipt.

Indexes

Index	Uniqueness	Columns
CST_TXN_PREPROCESS_GT_N1	Non Unique	CMR_PO_DISTRIBUTION_ID