CREATE TABLE cml_trop_charges_to_process_gt (
    TRADE_OPERATION_ID              NUMBER(18, 0),
    TRADE_OPERATION_CHARGE_ID       NUMBER(18, 0),
    CHARGE_LINE_OVN                 NUMBER(9, 0)     NOT NULL,
    CURRENCY_CONVERSION_TYPE        VARCHAR2(120),
    CURRENCY_CONVERSION_DATE        DATE         ,
    ESTIMATE_AMOUNT                 NUMBER       ,
    NR_TAX                          NUMBER       ,
    INVOICE_FUNC_AMOUNT             NUMBER       ,
    INVOICE_FUNC_TAX                NUMBER       ,
    TROP_CURRENCY_CODE              VARCHAR2(60) ,
    CHARGE_CURRENCY_CODE            VARCHAR2(60) ,
    REQ_BU_CURRENCY_CODE            VARCHAR2(60) ,
    CHARGE_REQ_BU_CURR_CONV_RATE    NUMBER       ,
    TROP_DOC_CURRENCY_CONV_RATE     NUMBER       ,
    TENTATIVE_FLAG                  VARCHAR2(4)      NOT NULL,
    STATUS                          VARCHAR2(120),
    TAX_STATUS                      VARCHAR2(120),
    ERROR_MESSAGE                   VARCHAR2(120),
    TOKEN1_NAME                     VARCHAR2(120),
    TOKEN1_VALUE                    VARCHAR2(960),
    TOKEN2_NAME                     VARCHAR2(120),
    TOKEN2_VALUE                    VARCHAR2(960),
    TOKEN3_NAME                     VARCHAR2(120),
    TOKEN3_VALUE                    VARCHAR2(960),
    TOKEN4_NAME                     VARCHAR2(120),
    TOKEN4_VALUE                    VARCHAR2(960),
    TOKEN5_NAME                     VARCHAR2(120),
    TOKEN5_VALUE                    VARCHAR2(960),
    TOKEN6_NAME                     VARCHAR2(120),
    TOKEN6_VALUE                    VARCHAR2(960),
    TROP_TRANSACTION_TYPE           VARCHAR2(120)    NOT NULL,
    TRADE_OPERATION_ID              NUMBER(18, 0),
    TRADE_OPERATION_CHARGE_ID       NUMBER(18, 0),
    CHARGE_LINE_OVN                 NUMBER(9, 0)     NOT NULL,
    CURRENCY_CONVERSION_TYPE        VARCHAR2(120),
    CURRENCY_CONVERSION_DATE        DATE         ,
    ESTIMATE_AMOUNT                 NUMBER       ,
    NR_TAX                          NUMBER       ,
    INVOICE_FUNC_AMOUNT             NUMBER       ,
    INVOICE_FUNC_TAX                NUMBER       ,
    TROP_CURRENCY_CODE              VARCHAR2(60) ,
    CHARGE_CURRENCY_CODE            VARCHAR2(60) ,
    REQ_BU_CURRENCY_CODE            VARCHAR2(60) ,
    CHARGE_REQ_BU_CURR_CONV_RATE    NUMBER       ,
    TROP_DOC_CURRENCY_CONV_RATE     NUMBER       ,
    TENTATIVE_FLAG                  VARCHAR2(4)      NOT NULL,
    STATUS                          VARCHAR2(120),
    TAX_STATUS                      VARCHAR2(120),
    ERROR_MESSAGE                   VARCHAR2(120),
    TOKEN1_NAME                     VARCHAR2(120),
    TOKEN1_VALUE                    VARCHAR2(960),
    TOKEN2_NAME                     VARCHAR2(120),
    TOKEN2_VALUE                    VARCHAR2(960),
    TOKEN3_NAME                     VARCHAR2(120),
    TOKEN3_VALUE                    VARCHAR2(960),
    TOKEN4_NAME                     VARCHAR2(120),
    TOKEN4_VALUE                    VARCHAR2(960),
    TOKEN5_NAME                     VARCHAR2(120),
    TOKEN5_VALUE                    VARCHAR2(960),
    TOKEN6_NAME                     VARCHAR2(120),
    TOKEN6_VALUE                    VARCHAR2(960),
    TROP_TRANSACTION_TYPE           VARCHAR2(120)    NOT NULL,
    CONSTRAINT pk_cml_trop_charges_to_process_gt PRIMARY KEY (TRADE_OPERATION_ID, TRADE_OPERATION_CHARGE_ID, TRADE_OPERATION_ID, TRADE_OPERATION_CHARGE_ID)
);
