CST_TRADE_EVENT

Details

Schema: FUSION
Object owner: CST
Object type: TABLE
Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CST_TRADE_EVENT_COSTS_PK	TRADE_EVENT_COST_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
TRADE_EVENT_COST_ID	NUMBER		18	Yes	Surrogate key that uniquely identifies the trade event cost record.	Active
TRANSFER_PRICING_UOM_CODE	VARCHAR2	3			Unit of measure code of the transfer price unit cost.
TRANSFER_PRICING_UNIT_COST	NUMBER				Unit cost in transfer price unit of measure code for trade events in Supply Chain Financial Orchestration currency.
TRADE_EVENT_ID	NUMBER		18	Yes	Foreign key reference to the Trade Events.	Active
EXTERNAL_SYSTEM_REFERENCE	VARCHAR2	60		Yes	Reference information from an external system (external to Cost Management).	Active
EXTERNAL_SYSTEM_REF_ID	VARCHAR2	30		Yes	Stores a value that uniquely identifies a certain instance of an object within the external system.	Active
TRANSFER_PRICE_COMPONENT	VARCHAR2	100		Yes	Indicates transfer price component for trade event cost.	Active
CURRENCY_CODE	VARCHAR2	15		Yes	Indicates the unit cost of the cost element.	Active
UNIT_COST	NUMBER				Unit Cost in Supply Chain Financial Orchestration currency.	Active
INTF_UNIT_COST	NUMBER				Interfaced unit cost by Supply Chain Financial Orchestration.
UNIT_COST_UOM_FACTOR	NUMBER				Unit cost unit of measure factor indicates the conversion rate to source document unit of measure code from unit cost UOM code.
TRANSACTION_AMOUNT	NUMBER				Trade Event transaction cost in Supply Chain Financial Orchestration currency.
MARKUP_RATE	NUMBER				In supplier facing node, it will be 1. For other nodes, it will be based on transfer price compared to supplier face node.
UOM_CODE	VARCHAR2	3			UOM of the unit cost in the trade event.	Active
CURRENCY_CONVERSION_RATE	NUMBER				Currency conversions rate for the receipt accrual trade event.
EXTENDED_AMOUNT	NUMBER				This column is used to hold the transfer value (transfer price * quantity in transactional UOM of the item) in Supply Chain Financial Orchestration currency.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.	Active
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.	Active
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.	Active
ORIGINAL_UNIT_COST	NUMBER				Original unit cost received from source document or external source.
SOURCE_SYSTEM	VARCHAR2	10			Source from which the cost is inserted into the table. Possible Values are INTF, TXFR. INTF: Interfaced from Supply Chain Orchestration, TXFR: generated by costing product.
TAX_INCLUSIVE_FLAG	VARCHAR2	1			Value Y determines the UNIT_COST is tax inclusive.
LOT_NUMBER	VARCHAR2	80			This stores lot number information for inventory item.
SERIAL_NUMBER	VARCHAR2	80			This stores serial number information for inventory item.
LOT_SER_TRANS_QTY	NUMBER				Quantity in the transaction unit of measure. TRANSACTION_QTY value from CST_INV_TRANSACTION_DTLS.
LOT_SER_PRIMARY_QTY	NUMBER				Quantity in the item primary unit of measure. PRIMARY_QTY value from CST_INV_TRANSACTION_DTLS.
LOT_SER_SECON_TRANS_QTY	NUMBER				Quantity in the item secondary unit of measure. SECONDARY_TRANSACTION_QTY value from CST_INV_TRANSACTION_DTLS.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CST_TRADE_EVENT_COSTS	cst_trade_events	TRADE_EVENT_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
CST_TRADE_EVENT_COSTS_N1	Non Unique	FUSION_TS_TX_IDX	TRADE_EVENT_ID	Active
CST_TRADE_EVENT_COSTS_PK	Unique	FUSION_TS_TX_IDX	TRADE_EVENT_COST_ID	Active
CST_TRADE_EVENT_COSTS_U1	Unique	FUSION_TS_TX_IDX	EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, TRANSFER_PRICE_COMPONENT, LOT_NUMBER, SERIAL_NUMBER	Active