CREATE TABLE cst_i_trade_event_costs (
    EXTERNAL_SYSTEM_REFERENCE     VARCHAR2(240) ,
    EXTERNAL_SYSTEM_REF_ID        VARCHAR2(120) ,
    TRANSFER_PRICE_COMPONENT      VARCHAR2(400) ,
    UNIT_COST                     NUMBER        ,
    TRANSACTION_AMOUNT            NUMBER        ,
    MARKUP_RATE                   NUMBER        ,
    CURRENCY_CODE                 VARCHAR2(60)      NOT NULL,
    UOM_CODE                      VARCHAR2(12)  ,
    TRANSFER_PRICING_UOM_CODE     VARCHAR2(12)  ,
    TRANSFER_PRICING_UNIT_COST    NUMBER        ,
    EXTENDED_AMOUNT               NUMBER        ,
    PROCESS_FLAG                  VARCHAR2(20)  ,
    CREATED_BY                    VARCHAR2(256)     NOT NULL,
    CREATION_DATE                 TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY               VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE              TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN             VARCHAR2(128) ,
    REQUEST_ID                    NUMBER(18, 0) ,
    JOB_DEFINITION_NAME           VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE        VARCHAR2(3600),
    EXTERNAL_SYSTEM_REFERENCE     VARCHAR2(240) ,
    EXTERNAL_SYSTEM_REF_ID        VARCHAR2(120) ,
    TRANSFER_PRICE_COMPONENT      VARCHAR2(400) ,
    UNIT_COST                     NUMBER        ,
    TRANSACTION_AMOUNT            NUMBER        ,
    MARKUP_RATE                   NUMBER        ,
    CURRENCY_CODE                 VARCHAR2(60)      NOT NULL,
    UOM_CODE                      VARCHAR2(12)  ,
    CREATED_BY                    VARCHAR2(256)     NOT NULL,
    CREATION_DATE                 TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY               VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE              TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN             VARCHAR2(128) ,
    REQUEST_ID                    NUMBER(18, 0) ,
    JOB_DEFINITION_NAME           VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE        VARCHAR2(3600),
    PROCESS_FLAG                  VARCHAR2(20)  ,
    EXTENDED_AMOUNT               NUMBER        ,
    TRANSFER_PRICING_UOM_CODE     VARCHAR2(12)  ,
    TRANSFER_PRICING_UNIT_COST    NUMBER        ,
    CONSTRAINT pk_cst_i_trade_event_costs PRIMARY KEY (EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, TRANSFER_PRICE_COMPONENT, EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, TRANSFER_PRICE_COMPONENT)
);
