CREATE TABLE trans_requests_reps ( 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, new_col11 DATE, new_col12 VARCHAR(50), merch_data1 VARCHAR(50), surname VARCHAR(20), instance_id VARCHAR(4), PRIMARY KEY (trace_audit_no) );