
CREATE TABLE
    mcp.trans_requests_reps_new
    (
        trace_audit_no BIGSERIAL NOT NULL,
        card_prg_id VARCHAR(20),
        trans_date DATE,
        fparam_code VARCHAR(20),
        org_trace_audit BIGINT,
        service_id VARCHAR(20),
        switch_prefixdata VARCHAR(36),
        reported_date DATE,
        imc_cics_trancode VARCHAR(36),
        trans_time DATETIME HOUR TO SECOND,
        switch_header VARCHAR(9),
        reported_time DATETIME HOUR TO SECOND,
        device_type VARCHAR(10),
        primary_bitmap VARCHAR(64),
        device_id VARCHAR(64),
        second_bitmap VARCHAR(64),
        request_no VARCHAR(4),
        org_trans_date VARCHAR(40),
        trans_code CHAR(2),
        trans_type CHAR(2),
        multi_clearing_seq SMALLINT,
        card_no VARCHAR(19),
        account_type CHAR(2),
        account_no_from VARCHAR(31),
        comp_code VARCHAR(16),
        comp_time DATETIME YEAR TO SECOND,
        trans_status CHAR(1),
        card_expiry_on DATE,
        amount_requested DECIMAL(15,2),
        amount_processed DECIMAL(15,2),
        currency_code VARCHAR(3),
        capture_date DATE,
        account_no_to VARCHAR(31),
        merchant_cat_code VARCHAR(4) DEFAULT '0',
        description VARCHAR(255),
        track2_data VARCHAR(156),
        business_date DATE,
        process_mode CHAR(2),
        commission_amount DECIMAL(13,2),
        exch_rate DECIMAL(16,8) DEFAULT 1.00000000,
        retrieval_ref_no VARCHAR(80),
        bank_auth_code VARCHAR(24),
        response_code CHAR(2),
        auth_code VARCHAR(16),
        rev_resp_code CHAR(2),
        add_response_data VARCHAR(27),
        trans_source CHAR(1) DEFAULT '0',
        iso_flag CHAR(1),
        process_code VARCHAR(6),
        terminal_data VARCHAR(240),
        sys_trace_auditno VARCHAR(24),
        issuer_authr_cat VARCHAR(23,16),
        trans_local_dtime DATETIME YEAR TO SECOND,
        acq_country_code VARCHAR(3),
        org_data_elements VARCHAR(42),
        point_of_srv_code VARCHAR(48),
        replace_amounts VARCHAR(42),
        receiving_inst VARCHAR(44),
        function_code VARCHAR(12),
        acq_inst_code VARCHAR(44),
        device_address VARCHAR(144),
        card_aceptor_code VARCHAR(60),
        card_aceptor_name VARCHAR(99,40),
        deposit_cr_amount VARCHAR(255),
        pin_data VARCHAR(16),
        additional_amounts DECIMAL(12,2),
        switch_visa_data VARCHAR(255),
        iso_serial_no BIGINT,
        bill_curr_code VARCHAR(3),
        settlement_date DATE,
        iso_message_type VARCHAR(4),
        totproduct_comms DECIMAL(13,2),
        curr_hold_amount DECIMAL(13,2),
        discounted_price DECIMAL(12,2),
        ach_batch_no INTEGER,
        clerk_id VARCHAR(40),
        shift_no VARCHAR(12),
        trans_process_fee DECIMAL(8,2),
        load_amount DECIMAL(12,2),
        social_sec_no INTEGER,
        date_of_birth DATE,
        ncards SMALLINT,
        comm_protocol_id CHAR(5),
        first_name VARCHAR(60),
        last_name VARCHAR(60),
        email_address VARCHAR(200),
        address_line1 VARCHAR(255),
        address_line2 VARCHAR(255),
        city VARCHAR(100),
        state CHAR(2),
        zip VARCHAR(40),
        work_phone VARCHAR(40),
        home_phone VARCHAR(40),
        cell_phone VARCHAR(80),
        foreign_id VARCHAR(80),
        country_code VARCHAR(3),
        type_id VARCHAR(12),
        card_status CHAR(1),
        atm_terminal_addr VARCHAR(132),
        nduplicate_trans SMALLINT DEFAULT 0,
        atm_postal_code VARCHAR(44),
        atm_off_premises CHAR(1),
        charged CHAR(1) DEFAULT 'Y',
        trans_batch_no INTEGER,
        remaining_balance DECIMAL(12,2),
        fee_trace_audit BIGINT,
        rev_trace_audit BIGINT,
        switch_id VARCHAR(10),
        amount_trans_fee DECIMAL(12,2),
        third_bitmap VARCHAR(64),
        amount_setlment DECIMAL(12,2),
        ex_rate_setlment DECIMAL(16,8),
        ex_rate_bill DECIMAL(16,8),
        ex_date DATE,
        acq_contry_code VARCHAR(3),
        isuer_contry_code VARCHAR(3),
        fwin_contry_code VARCHAR(3),
        card_seq_no VARCHAR(3),
        net_intl_id VARCHAR(12),
        pos_cond_code VARCHAR(12),
        pin_capture_code CHAR(2),
        auth_id_resp_len CHAR(1),
        amount_stl_fee DECIMAL(12,2),
        amount_tp_fee DECIMAL(12,2),
        amount_sp_fee DECIMAL(12,2),
        forwd_inst_id VARCHAR(44),
        pan_extended VARCHAR(28),
        auth_id_resp VARCHAR(24),
        service_rest_code VARCHAR(12),
        add_data_iso VARCHAR(255),
        add_nat_data VARCHAR(255),
        merchant_name VARCHAR(100),
        settlement_cc VARCHAR(3),
        bill_cc VARCHAR(3),
        sec_ctrl_info VARCHAR(64),
        additional_fee VARCHAR(88),
        repl_add_fee VARCHAR(88),
        auth_life_cycle VARCHAR(3),
        nat_pos_cc VARCHAR(120),
        misc_amount VARCHAR(68),
        adv_reason_code VARCHAR(6),
        acq_trans_data VARCHAR(100),
        iss_trans_data VARCHAR(255),
        efund_data VARCHAR(255),
        stl_code CHAR(1),
        payee VARCHAR(100),
        trans_description VARCHAR(255),
        auth_agent_id VARCHAR(44),
        auth_agent_cc VARCHAR(3),
        issuer_pvt_data VARCHAR(255),
        sub_service VARCHAR(30),
        data2 VARCHAR(120),
        data3 VARCHAR(120),
        acq_user_id VARCHAR(80),
        virtual_account VARCHAR(64),
        receiver_name VARCHAR(88),
        avsresp VARCHAR(20),
        cvv2resp VARCHAR(5),
        efunddatapseudoter VARCHAR(6),
        efunddataacqnetid VARCHAR(3) DEFAULT 'I2C',
        efunddataissnetid VARCHAR(3),
        efunddataprocssrid VARCHAR(6),
        cal_ic_fee DECIMAL(16,9),
        interchange_fee DECIMAL(18,9),
        mult_curr_cnv_rate DECIMAL(18,9),
        surcharge_fee DECIMAL(18,9),
        optional_isuer_fee DECIMAL(18,9),
        is_pin_based CHAR(1),
        is_international CHAR(1),
        interface VARCHAR(20),
        load_center VARCHAR(80),
        available_balance DECIMAL(12,2),
        auto_expire_preauth CHAR(1) DEFAULT 'Y' NOT NULL,
        excep_code CHAR(2),
        merchant_vol_ind VARCHAR(3),
        trans_geo_data VARCHAR(68),
        visa_dr_pos_data VARCHAR(255),
        post_card_sts CHAR(1),
        partial_tr_org_amt DECIMAL(12,2),
        po_id INTEGER,
        payment_srno INTEGER,
        settlement_status CHAR(1),
        pnding_pros_count BIGINT,
        switch_type VARCHAR(25),
        is_multi_currency CHAR(1),
        partial_trans_flag CHAR(1) DEFAULT '0',
        cash_back_flag CHAR(1),
        avs_data VARCHAR(200),
        additional_data VARCHAR(200),
        transmission_dtime DATETIME MONTH TO SECOND,
        chargeback_flag CHAR(1),
        switch_sr_no VARCHAR(30),
        multi_clearing_cnt INTEGER,
        switch_data VARCHAR(255),
        sys_control_no VARCHAR(20),
        bill_amount DECIMAL(12,2),
        exec_time INTEGER,
        acnresp VARCHAR(5),
        trans_indicator INTEGER,
        trns_expense_tag VARCHAR(20),
        payment_stl_status CHAR(1),
        is_cc_payment_trns CHAR(1),
        adjusted_amt DECIMAL(12,2),
        statement_date DATE,
        cash_amount DECIMAL(12,2),
        is_cash_adv CHAR(1),
        last_updated_at DATETIME YEAR TO SECOND,
        card_category CHAR(1),
        primary_card_no VARCHAR(19),
        card_verif_result VARCHAR(40),
        trmnl_verif_result VARCHAR(40),
        switch_risk_codes VARCHAR(11),
        pri_card_prg_id VARCHAR(39),
        network_oif DECIMAL(12,4),
        optional_acq_fee DECIMAL(12,4),
        amount_setlmnt_req DECIMAL(12,4),
        unpredictable_no VARCHAR(8),
        cavv_data VARCHAR(100),
        add_resp_amounts VARCHAR(120),
        add_res_data VARCHAR(40),
        token_data VARCHAR(40),
        depository_type VARCHAR(255),
        token_trans_id VARCHAR(64),
        prev_expiry_date VARCHAR(20),
        file_cycle_no INTEGER,
        ext_pay_method VARCHAR(15),
        ext_interface_id VARCHAR(15),
        token_no VARCHAR(19),
        token_assure_level CHAR(2),
        token_req_id VARCHAR(15),
        token_expiry DATE,
        token_mob_type CHAR(2),
        token_otp VARCHAR(8),
        token_otp_expiry DATETIME MONTH TO SECOND,
        auth_mode CHAR(1),
        total_auth_amount DECIMAL(15,3),
        fee_in_multi_curr DECIMAL(12,2),
        bank_account_no VARCHAR(20),
        bank_routing_no VARCHAR(9),
        bank_account_title VARCHAR(40),
        network_prod_code VARCHAR(5),
        switch_service_fee DECIMAL(16,8),
        data4 VARCHAR(100),
        dispt_control_num VARCHAR(11),
        pay_acnt_reference VARCHAR(35),
        trans_analysis_data VARCHAR(100),
        swt_sec_srv_data VARCHAR(120),
        on_behlf_srv_reslt VARCHAR(50),
        dcc_indicator CHAR(1),
        token_add_data1 VARCHAR(255),
        token_add_data2 VARCHAR(255),
        emv_dki SMALLINT,
        emv_cvn SMALLINT,
        emv_app_int_prof VARCHAR(16),
        emv_ter_cap_prof VARCHAR(24),
        emv_iss_script VARCHAR(255),
        emv_iss_script_res VARCHAR(40),
        emv_data VARCHAR(255),
        fix_rate_fee DECIMAL(13,2),
        cp_card_prg_id VARCHAR(20),
        is_intl_ntw CHAR(1),
        is_multi_curr_ntw CHAR(1),
        network_file_id VARCHAR(30),
        msg_rvsl_data VARCHAR(10),
        chargeback_data VARCHAR(130),
        crbk_doc_ind CHAR(1),
        card_iss_ref_data VARCHAR(255),
        payment_fund_src CHAR(1),
        fee_dtl_serial INTEGER,
        fee_dtl_tab_id SMALLINT,
        data5 VARCHAR(255),
        misc_tagged_data VARCHAR(255),
        consumer_entry DATETIME YEAR TO SECOND,
        crd_acnt_trace_audit BIGINT,
        trans_value_type VARCHAR(255),
        trans_value_cat VARCHAR(255),
        trans_value_cate VARCHAR(255),
        trans_ind VARCHAR(255),
        trans_inds VARCHAR(255),
        new_add INTEGER,
        new_add2 INTEGER,
        new_add3 INTEGER,
        PRIMARY KEY (trace_audit_no)
    );