1. Tables and Views for SCM
  2. CST_I_TRADE_EVENT_COSTS_I_GT

CST_I_TRADE_EVENT_COSTS_I_GT

This table is used to temporarily store a subset of data from cst_i_trade_event_costs table to support internal processing within the Cost Processor

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

CST_I_TRADE_EVNT_COSTS_I_GT_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
TRANSFER_PRICING_UNIT_COST NUMBER Unit cost in transfer price unit of measure code for trade events.
TRANSFER_PRICING_UOM_CODE VARCHAR2 3 Unit of measure code of the transfer price unit cost.
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
UNIT_COST NUMBER Indicates Trade Event Unit Cost 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 in the Trade Event Active
UOM_CODE VARCHAR2 3 UOM of the Unit Cost in the Trade Event Active
PROCESS_FLAG VARCHAR2 20 Internal Flag to indicate processed rows
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

Indexes

Index Uniqueness Columns
CST_I_TRADE_EVNT_COSTS_I_GT_U1 Unique EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, TRANSFER_PRICE_COMPONENT