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	Trade Event Cost identifier	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.
TRADE_EVENT_ID	NUMBER		18	Yes	Foreign key reference to the Trade Events	Active
EXTERNAL_SYSTEM_REFERENCE	VARCHAR2	60		Yes	EXTERNAL_SYSTEM_REFERENCE	Active
EXTERNAL_SYSTEM_REF_ID	VARCHAR2	30		Yes	EXTERNAL_SYSTEM_REF_ID	Active
TRANSFER_PRICE_COMPONENT	VARCHAR2	100		Yes	Transfer Price Component	Active
CURRENCY_CODE	VARCHAR2	15		Yes	Currency of the Unit Cost	Active
UNIT_COST	NUMBER				Unit Cost in source document unit of measure code for trade receipt accrual transaction.	Active
INTF_UNIT_COST	NUMBER				Interfaced Unit cost in the source transaction unit of measure.
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				Transaction Amount is event amount for Service line type POs
MARKUP_RATE	NUMBER				Transfer price mark up ratio rate between the nodes of a global service line type POs.
UOM_CODE	VARCHAR2	3			UOM of the Unit Cost	Active
CURRENCY_CONVERSION_RATE	NUMBER				Currency converions rate - it is populated receipt acct dist process for receipt accrual trade events only.
EXTENDED_AMOUNT	NUMBER				This column is used to hold the transfer value (transfer price * quantity in transactional UOM of the item) interfaced by Supply Chain Financial Orchestration.
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 the external source
SOURCE_SYSTEM	VARCHAR2	10			Source from which the Cost is inserted into the table. Possible Values are INTF, TXFR
TAX_INCLUSIVE_FLAG	VARCHAR2	1			Value Y determines the UNIT_Cost is Tax inclusive.

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	Active