Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 105717 payment_means : CB transmission_date : 20151022085717 payment_time : 110055 payment_date : 20151022 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4972.61 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jl.hidelot08 order_id : 8023 customer_email : jl.hidelot08@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_NOTENROLLED statement_reference : card_validity : 201705 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8023" select * from cms_frontusers where identifiant = "jl.hidelot08" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8023" select * from cotisations where identifiant = "jl.hidelot08" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 110232 payment_means : VISA transmission_date : 20151022090232 payment_time : 110541 payment_date : 20151022 response_code : 00 payment_certificate : 783c8d3b2b7f authorisation_id : 136649 currency_code : 978 card_number : 4972.61 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jl.hidelot08 order_id : 8023 customer_email : jl.hidelot08@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201705 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8024" select * from cms_frontusers where identifiant = "b.nauleau15" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8024" select * from cotisations where identifiant = "b.nauleau15" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 121843 payment_means : VISA transmission_date : 20151022101843 payment_time : 122414 payment_date : 20151022 response_code : 00 payment_certificate : a8a32b8fdae1 authorisation_id : 951926 currency_code : 978 card_number : 4972.37 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.nauleau15 order_id : 8024 customer_email : b.nauleau15@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201804 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8027" select * from cms_frontusers where identifiant = "b.mignoni01" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8027" select * from cotisations where identifiant = "b.mignoni01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183422 payment_means : MASTERCARD transmission_date : 20151022163422 payment_time : 183617 payment_date : 20151022 response_code : 00 payment_certificate : 04150336d6c1 authorisation_id : 835262 currency_code : 978 card_number : 5132.22 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.mignoni01 order_id : 8027 customer_email : b.mignoni01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201606 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8028" select * from cms_frontusers where identifiant = "e.courant09" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8028" select * from cotisations where identifiant = "a.couhier26" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 183952 payment_means : VISA transmission_date : 20151022163952 payment_time : 184203 payment_date : 20151022 response_code : 00 payment_certificate : bb174cdd6f62 authorisation_id : 416955 currency_code : 978 card_number : 4975.46 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.courant09 order_id : 8028 customer_email : e.courant09@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201804 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8029" select * from cms_frontusers where identifiant = "p.merel15" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8029" select * from cotisations where identifiant = "p.merel15" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191545 payment_means : MASTERCARD transmission_date : 20151022171545 payment_time : 191924 payment_date : 20151022 response_code : 00 payment_certificate : e18ea20bc0bd authorisation_id : 156515 currency_code : 978 card_number : 5132.03 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.merel15 order_id : 8029 customer_email : p.merel15@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201611 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8030" select * from cms_frontusers where identifiant = "l.mabire16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8030" select * from cotisations where identifiant = "l.mabire16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 192914 payment_means : MASTERCARD transmission_date : 20151022172914 payment_time : 193306 payment_date : 20151022 response_code : 00 payment_certificate : 308b8741ad10 authorisation_id : 364111 currency_code : 978 card_number : 5131.49 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.mabire16 order_id : 8030 customer_email : l.mabire16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8032" select * from cms_frontusers where identifiant = "l.girard20" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8032" select * from cotisations where identifiant = "l.girard20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195932 payment_means : MASTERCARD transmission_date : 20151022175932 payment_time : 200501 payment_date : 20151022 response_code : 00 payment_certificate : 282c4b025689 authorisation_id : 260163 currency_code : 978 card_number : 5132.14 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.girard20 order_id : 8032 customer_email : l.girard20@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8034" select * from cms_frontusers where identifiant = "g.wagner09" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8034" select * from cotisations where identifiant = "g.wagner09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202554 payment_means : MASTERCARD transmission_date : 20151022182554 payment_time : 202712 payment_date : 20151022 response_code : 00 payment_certificate : 7d2f100bbb41 authorisation_id : 566682 currency_code : 978 card_number : 5131.99 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.wagner09 order_id : 8034 customer_email : g.wagner09@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202351 payment_means : MASTERCARD transmission_date : 20151022182351 payment_time : 202921 payment_date : 20151022 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.86 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.boyer02 order_id : 8033 customer_email : j.boyer02@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201705 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202943 payment_means : MASTERCARD transmission_date : 20151022182943 payment_time : 203813 payment_date : 20151022 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.86 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.boyer02 order_id : 8033 customer_email : j.boyer02@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201705 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 204052 payment_means : MASTERCARD transmission_date : 20151022184052 payment_time : 204549 payment_date : 20151022 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.86 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.boyer02 order_id : 8033 customer_email : j.boyer02@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201705 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 205437 payment_means : MASTERCARD transmission_date : 20151022185437 payment_time : 211036 payment_date : 20151022 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5817.13 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.ide16 order_id : 8035 customer_email : c.ide16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 211138 payment_means : MASTERCARD transmission_date : 20151022191138 payment_time : 211723 payment_date : 20151022 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5817.13 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.ide16 order_id : 8037 customer_email : c.ide16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8038" select * from cms_frontusers where identifiant = "y.lartigau16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8038" select * from cotisations where identifiant = "y.lartigau16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212607 payment_means : VISA transmission_date : 20151022192607 payment_time : 212948 payment_date : 20151022 response_code : 00 payment_certificate : ea7fdd61c2c9 authorisation_id : 447323 currency_code : 978 card_number : 4150.47 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : y.lartigau16 order_id : 8038 customer_email : y.lartigau16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201601 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8039" select * from cms_frontusers where identifiant = "r.legray14" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8039" select * from cotisations where identifiant = "r.legray14" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212934 payment_means : MASTERCARD transmission_date : 20151022192934 payment_time : 213113 payment_date : 20151022 response_code : 00 payment_certificate : 8db2b4821187 authorisation_id : 323715 currency_code : 978 card_number : 5131.41 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.legray14 order_id : 8039 customer_email : r.legray14@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8040" select * from cms_frontusers where identifiant = "g.beaujardguerin30" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8040" select * from cotisations where identifiant = "g.beaujardguerin30" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 213540 payment_means : VISA transmission_date : 20151022193540 payment_time : 213721 payment_date : 20151022 response_code : 00 payment_certificate : 221771d4a138 authorisation_id : 504919 currency_code : 978 card_number : 4978.05 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.beaujardguerin30 order_id : 8040 customer_email : g.beaujardguerin30@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201710 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 213656 payment_means : VISA transmission_date : 20151022193656 payment_time : 214131 payment_date : 20151022 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.15 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 54 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.dailcroix17 order_id : 8041 customer_email : j.dailcroix17@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201605 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8042" select * from cms_frontusers where identifiant = "j.happle01" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8042" select * from cotisations where identifiant = "r.claudin07" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 220431 payment_means : MASTERCARD transmission_date : 20151022200431 payment_time : 220649 payment_date : 20151022 response_code : 00 payment_certificate : 505d9c32195a authorisation_id : 637511 currency_code : 978 card_number : 5341.33 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.happle01 order_id : 8042 customer_email : j.happle01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201705 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------