CST_PREP_COST_CONV_GT

This is a global temporary table to help process cost element mapping and currency conversion. This table is to get the eligible reference RMA transactions for processing.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TRANSACTION_ID	NUMBER		18	Yes	Transaction identifier which identifies the transaction in costing
TRANSACTION_DATE	TIMESTAMP				The date when transaction happened
BASE_TXN_TYPE_ID	NUMBER		18		Inventory transaction type identifier
BASE_TXN_SOURCE_TYPE_ID	NUMBER		18		Inventory transaction source type identifier
BASE_TXN_ACTION_ID	NUMBER		18		Inventory transaction action identifier
INTERNAL_PROFIT_TRACKING	NUMBER		18		This column indicates whether profit tracking should be done or not. It can hold the values 'Y' and 'N'
COST_TRANSACTION_TYPE	VARCHAR2	10			Costing transaction type ISSUE or RECEIPT
ADDITIONAL_PROCESSING_CODE	VARCHAR2	40			Code specifying what kind of processing needs to be done. The value is defined in CST_INTERNAL_TXN_TYPE for the transaction type and is used by cost processor for additional processing
LOGICAL_FLAG	VARCHAR2	1			This column indicates whether this transaction type is logical. Logical transactions have no on-hand quantity impact
COST_ORG_ID	NUMBER		18	Yes	Identifies the cost organization associated with the inventory organization for which the transaction is being processed
COST_BOOK_ID	NUMBER		18	Yes	Identifies the cost book associated with the cost organization
CST_INV_TRANSACTION_ID	NUMBER		18	Yes	The inventory transaction identifier that references costing's inventory transaction table
REFERENCE_DOO_FULFILL_LINE_ID	NUMBER		18		Referenced fulfillment identifier
REFERENCE_DELIVERY_ID	NUMBER		18		This column has the reference delivery identifier that points to delivery identifier of the forward flow