INSERT
INTO
    mcp.trans_requests_reps_new
    (
        trans_date,
        fparam_code,
        org_trace_audit,
        service_id,
        switch_prefixdata,
        reported_date,
        imc_cics_trancode,
        switch_header,
        device_type,
        primary_bitmap,
        device_id,
        second_bitmap,
        request_no,
        org_trans_date,
        trans_code,
        trans_type,
        multi_clearing_seq,
        card_no,
        account_type,
        account_no_from,
        comp_code,
        comp_time,
        trans_status,
        card_expiry_on,
        amount_requested,
        amount_processed,
        currency_code,
        capture_date,
        account_no_to,
        merchant_cat_code,
        description,
        track2_data,
        business_date,
        process_mode,
        commission_amount,
        exch_rate,
        retrieval_ref_no,
        bank_auth_code,
        response_code,
        auth_code,
        rev_resp_code,
        add_response_data,
        trans_source,
        iso_flag,
        process_code,
        terminal_data,
        sys_trace_auditno,
        issuer_authr_cat,
        trans_local_dtime,
        acq_country_code,
        org_data_elements,
        point_of_srv_code,
        replace_amounts,
        receiving_inst,
        function_code,
        acq_inst_code,
        device_address,
        card_aceptor_code,
        card_aceptor_name,
        deposit_cr_amount,
        pin_data,
        additional_amounts,
        switch_visa_data,
        iso_serial_no,
        bill_curr_code,
        settlement_date,
        iso_message_type,
        totproduct_comms,
        curr_hold_amount,
        discounted_price,
        ach_batch_no,
        clerk_id,
        shift_no,
        trans_process_fee,
        load_amount,
        social_sec_no,
        date_of_birth,
        ncards,
        comm_protocol_id,
        first_name,
        last_name,
        email_address,
        address_line1,
        address_line2,
        city,
        state,
        zip,
        work_phone,
        home_phone,
        cell_phone,
        foreign_id,
        country_code,
        type_id,
        card_status,
        atm_terminal_addr,
        nduplicate_trans,
        atm_postal_code,
        atm_off_premises,
        charged,
        trans_batch_no,
        remaining_balance,
        fee_trace_audit,
        rev_trace_audit,
        switch_id,
        amount_trans_fee,
        third_bitmap,
        amount_setlment,
        ex_rate_setlment,
        ex_rate_bill,
        ex_date,
        acq_contry_code,
        isuer_contry_code,
        fwin_contry_code,
        card_seq_no,
        net_intl_id,
        pos_cond_code,
        pin_capture_code,
        auth_id_resp_len,
        amount_stl_fee,
        amount_tp_fee,
        amount_sp_fee,
        forwd_inst_id,
        pan_extended,
        auth_id_resp,
        service_rest_code,
        add_data_iso,
        add_nat_data,
        merchant_name,
        settlement_cc,
        bill_cc,
        sec_ctrl_info,
        additional_fee,
        repl_add_fee,
        auth_life_cycle,
        nat_pos_cc,
        misc_amount,
        adv_reason_code,
        acq_trans_data,
        iss_trans_data,
        efund_data,
        stl_code,
        payee,
        trans_description,
        auth_agent_id,
        auth_agent_cc,
        issuer_pvt_data,
        sub_service,
        data2,
        data3,
        acq_user_id,
        virtual_account,
        receiver_name,
        avsresp,
        cvv2resp,
        efunddatapseudoter,
        efunddataacqnetid,
        efunddataissnetid,
        efunddataprocssrid,
        cal_ic_fee,
        interchange_fee,
        mult_curr_cnv_rate,
        surcharge_fee,
        optional_isuer_fee,
        is_pin_based,
        is_international,
        interface,
        load_center,
        available_balance,
        auto_expire_preauth,
        excep_code,
        merchant_vol_ind,
        trans_geo_data,
        visa_dr_pos_data,
        post_card_sts,
        partial_tr_org_amt,
        po_id,
        payment_srno,
        settlement_status,
        pnding_pros_count,
        switch_type,
        is_multi_currency,
        partial_trans_flag,
        cash_back_flag,
        avs_data,
        additional_data,
        transmission_dtime,
        chargeback_flag,
        switch_sr_no,
        multi_clearing_cnt,
        switch_data,
        sys_control_no,
        bill_amount,
        exec_time,
        acnresp,
        trans_indicator,
        trns_expense_tag,
        payment_stl_status,
        is_cc_payment_trns,
        adjusted_amt,
        statement_date,
        cash_amount,
        is_cash_adv,
        last_updated_at,
        card_category,
        primary_card_no,
        card_verif_result,
        trmnl_verif_result,
        switch_risk_codes,
        pri_card_prg_id,
        network_oif,
        optional_acq_fee,
        amount_setlmnt_req,
        unpredictable_no,
        cavv_data,
        add_resp_amounts,
        add_res_data,
        token_data,
        depository_type,
        token_trans_id,
        prev_expiry_date,
        file_cycle_no,
        ext_pay_method,
        ext_interface_id,
        token_no,
        token_assure_level,
        token_req_id,
        token_expiry,
        token_mob_type,
        token_otp,
        auth_mode,
        total_auth_amount,
        fee_in_multi_curr,
        bank_account_no,
        bank_routing_no,
        bank_account_title,
        network_prod_code,
        switch_service_fee,
        data4,
        dispt_control_num,
        pay_acnt_reference,
        trans_analysis_data,
        swt_sec_srv_data,
        on_behlf_srv_reslt,
        dcc_indicator,
        token_add_data1,
        token_add_data2,
        emv_dki,
        emv_cvn,
        emv_app_int_prof,
        emv_ter_cap_prof,
        emv_iss_script,
        emv_iss_script_res,
        emv_data,
        fix_rate_fee,
        cp_card_prg_id,
        is_intl_ntw,
        is_multi_curr_ntw,
        network_file_id,
        msg_rvsl_data,
        chargeback_data,
        crbk_doc_ind,
        card_iss_ref_data,
        payment_fund_src,
        fee_dtl_serial,
        fee_dtl_tab_id,
        data5,
        misc_tagged_data,
        consumer_entry,
        token_otp_expiry,
        trans_time,
        card_prg_id,
        reported_time,
        crd_acnt_trace_audit
    )
    VALUES
    (
        TO_DATE('2023-12-05', '%Y-%m-%d'),
        'F',
        '234',
        'S1',
        'data',
        TO_DATE('2022-10-05', '%Y-%m-%d'),
        '123',
        'SwitchHeader123',
        'H',
        '1101111',
        'TERMID01',
        '1101111',
        '16*',
        '2023-12-05',
        'ML',
        '00',
        '1',
        '9317015090680189',
        'Savings',
        '1234567890',
        'ABC123',
        TO_DATE('2023-06-06 17:50:10', '%Y-%m-%d %H:%M:%S') ,
        'Completed',
        TO_DATE('2023-12-05', '%Y-%m-%d'),
        '1000.00',
        '1000.00',
        'USD',
        TO_DATE('2023-12-05', '%Y-%m-%d'),
        '0987654321',
        '1234',
        'Transaction description',
        'Track2Data123',
        TO_DATE('2023-12-05', '%Y-%m-%d'),
        'Online',
        '10.50',
        '1.00000000',
        '123456789012',
        'AUTH1234',
        '00',
        'A12345',
        'R01',
        'AdditionalData123',
        '1',
        'Y',
        '100',
        'TerminalData123',
        '987654',
        'A',
        TO_DATE('2023-06-06 17:50:10', '%Y-%m-%d %H:%M:%S') ,
        'USD',
        'OrgData123',
        'POS123',
        'N',
        'ReceivingInst123',
        '200',
        'AcqInst123',
        'DeviceAddress123',
        '123456',
        'MerchantName',
        '500.00',
        'PIN123',
        '323',
        'SwitchVisaData123',
        '987654321',
        'USD',
        TO_DATE('2023-12-05', '%Y-%m-%d'),
        '0200',
        '5',
        '1500.00',
        '1200.00',
        '123',
        'Clerk001',
        'Shift123',
        '10.00',
        '500.00',
        '123789',
        TO_DATE('2023-12-05', '%Y-%m-%d'),
        '3',
        'CommProtocol001',
        'John',
        'Doe',
        'john.doe@example.com',
        '123 Main St',
        'Apt 456',
        'Cityville',
        'CA',
        '12345',
        '555-1234',
        '555-5678',
        '555-8765',
        '9876543210',
        'USA',
        'Type001',
        'Active',
        'ATM Address 123',
        '1',
        '54321',
        'Y',
        'N',
        '123',
        '1000.00',
        '434123',
        '4324456',
        'SwitchID001',
        5.00,
        'ThirdBitmap001',
        1000.00,
        1.25,
        1.20,
        '2023-12-10',
        'CAN',
        'USA',
        'GBR',
        '001',
        'NetIntlID001',
        'POS001',
        'Y',
        '8',
        2.50,
        1.50,
        3.00,
        'ForwardInst001',
        'PanExtended001',
        'AuthID123',
        'ServiceRest001',
        'AdditionalDataISO001',
        'AdditionalNatData001',
        'MerchantXYZ',
        'USD',
        'USD',
        'SecurityInfo001',
        1.00,
        0.50,
        'Complete',
        'USD',
        2.00,
        'Reason001',
        'AcqTransData001',
        'IssTransData001',
        'EfundData001',
        'StlCode001',
        'Payee001',
        'TransactionDescription001',
        'AuthAgentID001',
        'AuthAgentCC001',
        'IssuerPvtData001',
        'SubService001',
        'Data2001',
        'Data3001',
        'AcqUserID001',
        'VirtualAccount001',
        'ReceiverName001',
        'AVSResp001',
        'CVV2Resp001',
        'EfundDataPseudoter001',
        'I2C',
        'IssNetID001',
        'ProcssrID001',
        2.50,
        1.00,
        1.30,
        0.75,
        0.25,
        'Y',
        'Y',
        'Interface001',
        'LoadCenter001',
        800.00,
        'N',
        'Exception001',
        'MerchantVolInd001',
        'TransGeoData001',
        'VisaDrPosData001',
        'PostCardSts001',
        300.00,
        '001',
        '001',
        'SettlementStatus001',
        2,
        'SwitchType001',
        'N',
        '1',
        'Y',
        'AVSData001',
        'AdditionalData001',
        TO_DATE('06-06 17:50:10', '%m-%d %H:%M:%S') ,
        'N',
        'SwitchSRNo001',
        3,
        'SwitchData001',
        'SysControlNo001',
        1200.00,
        '20230606' ,
        'ACNResp001',
        '001',
        'ExpenseTag001',
        'PaymentStlStatus001',
        'Y',
        100.00,
        TO_DATE('2023-12-05', '%Y-%m-%d'),
        50.00,
        'N',
        TO_DATE('2023-06-06 17:50:10', '%Y-%m-%d %H:%M:%S') ,
        'Gold',
        'PrimaryCardNo001',
        'CardVerifResult001',
        'TrmnlVerifResult001',
        'RiskCodes001',
        'CardPrgID001',
        '13.5',
        1.25,
        1100.00,
        '987654321',
        'CAVVData123',
        15.00,
        'AdditionalResponseData123',
        'TokenData123',
        'Checking',
        'TokenTransID123',
        '2023-12-05',
        '123',
        'CreditCard',
        'ExtInterfaceID123',
        'TokenNo123',
        'TokenAssureLevel123',
        'TokenReqID123',
        TO_DATE('2023-12-05', '%Y-%m-%d'),
        'Mobile',
        'TokenOTP123',
        'Online',
        2000.00,
        5.00,
        'BankAccountNo123',
        'BankRoutingNo123',
        'BankAccountTitle123',
        'NetworkProdCode123',
        2.50,
        'Data4123',
        'DisptControlNum123',
        'PayAcntReference123',
        'TransAnalysisData123',
        'SwtSecSrvData123',
        'OnBehlfSrvReslt123',
        'Y',
        'TokenAddData1123',
        'TokenAddData2123',
        '23',
        '123',
        'EMV_AppIntProf123',
        'EMV_TerCapProf123',
        'EMV_IssScript123',
        'EMV_IssScriptRes123',
        'EMV_Data123',
        3.00,
        'CPCardPrgID123',
        'Y',
        'N',
        'NetworkFileID123',
        'MsgRvslData123',
        'ChargebackData123',
        'CrBkDocInd123',
        'CardIssRefData123',
        'PaymentFundSrc123',
        '123',
        '2123',
        'Data5123',
        'MiscTaggedData123',
        TO_DATE('2023-06-06 17:50:10', '%Y-%m-%d %H:%M:%S') ,
        TO_DATE('2023-06-06 17:50:10', '%Y-%m-%d %H:%M:%S'),
       tO_DATE('17:50:10', '%H:%M:%S'),
        "TORONTO",
   TO_DATE('17:50:10', '%H:%M:%S'),

        '123465'
    ) ;