CST_TXN_COST_SERVICE_OUT_GT

Global temporary table used in the bulk processing of transaction cost service requests

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CST_TXN_COST_SERVICE_ID	NUMBER		18	Yes	Unique identifier
EXTERNAL_SYSTEM_REFERENCE	VARCHAR2	60			Reference Information from an External system (external to Cost Management)
EXTERNAL_SYSTEM_REF_ID	VARCHAR2	30			Stores a value that uniquely identifies a certain instance of an object within the external system
TRANSACTION_TYPE	VARCHAR2	30			Type of transaction to retrieve the cost for. Values are 'INVENTORY', 'TRADEEVENT','CONSIGNEDOWNERSHIPCHANGE'.
COST_BOOK_CODE	VARCHAR2	30			Cost book code to retrieve the cost for
CURRENCY_CODE_IN	VARCHAR2	15			Currency code passed to the transaction cost service
FROM_CURRENCY_CODE	VARCHAR2	15			From currency code used during currency conversion.
UOM_CODE_IN	VARCHAR2	3			UOM code passed to the transaction cost service
FROM_UOM_CODE	VARCHAR2	3			From UOM code used during unit of measure conversion.
COST_BOOK_ID	NUMBER		18		Cost book identifier
INVENTORY_ITEM_ID	NUMBER		18		Inventory item identifier
CURRENCY_CONVERSION_TYPE	VARCHAR2	30			Currency conversion type
CURRENCY_CONVERSION_DATE	DATE				Currency conversion date
TRANSACTION_COST	NUMBER				Transaction cost retrieved by the transaction cost service
CURRENCY_CODE	VARCHAR2	15			Currency code retrieved by the transaction cost service
UOM_CODE	VARCHAR2	3			UOM code retrieved by the transaction cost service
ERROR_FLAG	VARCHAR2	1			Error flag indicating error. 'Y' = error, 'N' = no error.
UNIT_OF_MEASURE_IN	VARCHAR2	25			Unit of measure

Indexes

Index	Uniqueness	Columns
CST_TXN_COST_SERVICE_OUT_GT_U1	Unique	CST_TXN_COST_SERVICE_ID