1. Tables and Views for SCM
  2. CST_I_TRADE_EVENT_COSTS

CST_I_TRADE_EVENT_COSTS

This table stores all the trade event cost details for each component.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

CST_I_TRADE_EVENT_COSTS_PK

EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, TRANSFER_PRICE_COMPONENT

Columns

Name Datatype Length Precision Not-null Comments Status
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 Indentifies Transfer Price Component for Trade Event Active
UNIT_COST NUMBER Identifies Unit Cost for Trade Event record Active
TRANSACTION_AMOUNT NUMBER Transaction amount for service line type purchase orders.
MARKUP_RATE NUMBER Markup rate. In supplier facing node it will be 1. For other nodes it will dependent based on transfer price compared supplier face node.
CURRENCY_CODE VARCHAR2 15 Yes Currency of the Unit Cost Active
UOM_CODE VARCHAR2 3 UOM of the Unit Cost 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.
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.
PROCESS_FLAG VARCHAR2 5 This attribute introduced for incremental logic to tell whether rows are processed or not from interface table.
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

Foreign Keys

Table Foreign Table Foreign Key Column
CST_I_TRADE_EVENT_COSTS cst_i_trade_events EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID

Indexes

Index Uniqueness Tablespace Columns
CST_I_TRADE_EVENT_COSTS_PK Unique Default EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, TRANSFER_PRICE_COMPONENT