Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 075123 payment_means : MASTERCARD transmission_date : 20151125065123 payment_time : 075626 payment_date : 20151125 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.72 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 : s.darvesblanc21 order_id : 9340 customer_email : s.darvesblanc21@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 : 201512 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9340" select * from cms_frontusers where identifiant = "s.darvesblanc21" 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 = "9340" select * from cotisations where identifiant = "s.darvesblanc21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 080035 payment_means : MASTERCARD transmission_date : 20151125070035 payment_time : 080209 payment_date : 20151125 response_code : 00 payment_certificate : 72da49348922 authorisation_id : 879271 currency_code : 978 card_number : 5131.72 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 : s.darvesblanc21 order_id : 9340 customer_email : s.darvesblanc21@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 : 201512 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9342" select * from cms_frontusers where identifiant = "v.etienne12" 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 = "9342" select * from cotisations where identifiant = "v.etienne12" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 085352 payment_means : MASTERCARD transmission_date : 20151125075352 payment_time : 085638 payment_date : 20151125 response_code : 00 payment_certificate : 182cd4b3b1e1 authorisation_id : 126230 currency_code : 978 card_number : 5131.71 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 : v.etienne12 order_id : 9342 customer_email : v.etienne12@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 : 201703 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9343" select * from cms_frontusers where identifiant = "p.coulin15" 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 = "9343" select * from cotisations where identifiant = "p.coulin15" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 090456 payment_means : MASTERCARD transmission_date : 20151125080456 payment_time : 090952 payment_date : 20151125 response_code : 00 payment_certificate : 91c9b30070e0 authorisation_id : 314151 currency_code : 978 card_number : 5131.63 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.coulin15 order_id : 9343 customer_email : p.coulin15@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 : 201602 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9344" select * from cms_frontusers where identifiant = "e.landais12" 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 = "9344" select * from cotisations where identifiant = "e.landais12" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 090830 payment_means : MASTERCARD transmission_date : 20151125080830 payment_time : 091022 payment_date : 20151125 response_code : 00 payment_certificate : 56b6ac670671 authorisation_id : 418563 currency_code : 978 card_number : 5137.24 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.landais12 order_id : 9344 customer_email : e.landais12@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 = "9345" select * from cms_frontusers where identifiant = "l.pesenti23" 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 = "9345" select * from cotisations where identifiant = "l.pesenti23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 091007 payment_means : MASTERCARD transmission_date : 20151125081007 payment_time : 091234 payment_date : 20151125 response_code : 00 payment_certificate : b01fcbed00a8 authorisation_id : 235551 currency_code : 978 card_number : 5137.01 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.pesenti23 order_id : 9345 customer_email : l.pesenti23@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 : ------------------------------------------- select * from cotisations_commande where id = "9346" select * from cms_frontusers where identifiant = "l.devaud11" 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 = "9346" select * from cotisations where identifiant = "l.devaud11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 100553 payment_means : MASTERCARD transmission_date : 20151125090553 payment_time : 100755 payment_date : 20151125 response_code : 00 payment_certificate : 4f8e4ad0d1d7 authorisation_id : 254241 currency_code : 978 card_number : 5131.28 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.devaud11 order_id : 9346 customer_email : l.devaud11@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 : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9347" select * from cms_frontusers where identifiant = "jm.schaffner20" 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 = "9347" select * from cotisations where identifiant = "jm.schaffner20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 102520 payment_means : MASTERCARD transmission_date : 20151125092520 payment_time : 102705 payment_date : 20151125 response_code : 00 payment_certificate : d9f991589454 authorisation_id : 632819 currency_code : 978 card_number : 5137.42 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 : jm.schaffner20 order_id : 9347 customer_email : jm.schaffner20@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 : 201712 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9348" select * from cms_frontusers where identifiant = "r.girault27" 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 = "9348" select * from cotisations where identifiant = "r.girault27" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 113341 payment_means : MASTERCARD transmission_date : 20151125103341 payment_time : 114008 payment_date : 20151125 response_code : 00 payment_certificate : 1d35cbee4825 authorisation_id : 037613 currency_code : 978 card_number : 5131.62 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.girault27 order_id : 9348 customer_email : r.girault27@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 : 201701 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9351" select * from cms_frontusers where identifiant = "r.marolleau29" 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 = "9351" select * from cotisations where identifiant = "r.marolleau29" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 155608 payment_means : VISA transmission_date : 20151125145608 payment_time : 155800 payment_date : 20151125 response_code : 00 payment_certificate : ab77c4718890 authorisation_id : 131646 currency_code : 978 card_number : 4978.11 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.marolleau29 order_id : 9351 customer_email : r.marolleau29@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 : 201706 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 : 174259 payment_means : MASTERCARD transmission_date : 20151125164259 payment_time : 174716 payment_date : 20151125 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5133.29 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.petit02 order_id : 9352 customer_email : j.petit02@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 : 201601 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9353" select * from cms_frontusers where identifiant = "jj.limandat04" 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 = "9353" select * from cotisations where identifiant = "jj.limandat04" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 174724 payment_means : MASTERCARD transmission_date : 20151125164724 payment_time : 174925 payment_date : 20151125 response_code : 00 payment_certificate : 02c519a2b96d authorisation_id : 200223 currency_code : 978 card_number : 5131.38 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 : jj.limandat04 order_id : 9353 customer_email : jj.limandat04@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 : 201703 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9354" select * from cms_frontusers where identifiant = "e.chegaray28" 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 = "9354" select * from cotisations where identifiant = "e.chegaray28" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "e.chegaray28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 175334 payment_means : VISA transmission_date : 20151125165334 payment_time : 175514 payment_date : 20151125 response_code : 00 payment_certificate : 57d53a1f5c57 authorisation_id : 266057 currency_code : 978 card_number : 4970.97 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.chegaray28 order_id : 9354 customer_email : e.chegaray28@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 : 201604 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 : 8000 transaction_id : 183910 payment_means : VISA transmission_date : 20151125173910 payment_time : 184141 payment_date : 20151125 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4977.03 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 : n.ourdouillie17 order_id : 9355 customer_email : n.ourdouillie17@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 : 201708 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9356" select * from cms_frontusers where identifiant = "l.cerf14" 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 = "9356" select * from cotisations where identifiant = "l.cerf14" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183949 payment_means : VISA transmission_date : 20151125173949 payment_time : 184152 payment_date : 20151125 response_code : 00 payment_certificate : 7907aa8d2318 authorisation_id : 341616 currency_code : 978 card_number : 4972.88 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.cerf14 order_id : 9356 customer_email : l.cerf14@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 : 201512 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9357" select * from cms_frontusers where identifiant = "r.lacipiere22" 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 = "9357" select * from cotisations where identifiant = "b.galmiche11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185043 payment_means : VISA transmission_date : 20151125175043 payment_time : 185217 payment_date : 20151125 response_code : 00 payment_certificate : dc475104d944 authorisation_id : 457150 currency_code : 978 card_number : 4977.72 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.lacipiere22 order_id : 9357 customer_email : r.lacipiere22@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 : 201604 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9358" select * from cms_frontusers where identifiant = "y.duhal14" 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 = "9358" select * from cotisations where identifiant = "y.duhal14" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 190741 payment_means : MASTERCARD transmission_date : 20151125180741 payment_time : 191309 payment_date : 20151125 response_code : 00 payment_certificate : 6fd415c6c3d3 authorisation_id : 611514 currency_code : 978 card_number : 5131.90 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.duhal14 order_id : 9358 customer_email : y.duhal14@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 = "9359" select * from cms_frontusers where identifiant = "p.jouan06" 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 = "9359" select * from cotisations where identifiant = "p.jouan06" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 190912 payment_means : MASTERCARD transmission_date : 20151125180912 payment_time : 191937 payment_date : 20151125 response_code : 00 payment_certificate : a902d10f22ee authorisation_id : 450931 currency_code : 978 card_number : 5406.09 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.jouan06 order_id : 9359 customer_email : p.jouan06@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 : 201602 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9360" select * from cms_frontusers where identifiant = "a.pinet22" 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 = "9360" select * from cotisations where identifiant = "a.pinet22" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 192653 payment_means : VISA transmission_date : 20151125182653 payment_time : 192904 payment_date : 20151125 response_code : 00 payment_certificate : 7c377dfa693f authorisation_id : 213571 currency_code : 978 card_number : 4976.65 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 : a.pinet22 order_id : 9360 customer_email : a.pinet22@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 = "9362" select * from cms_frontusers where identifiant = "r.heno10" 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 = "9362" select * from cotisations where identifiant = "r.heno10" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 195924 payment_means : MASTERCARD transmission_date : 20151125185924 payment_time : 200208 payment_date : 20151125 response_code : 00 payment_certificate : 3fb53492af09 authorisation_id : 937130 currency_code : 978 card_number : 5132.60 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.heno10 order_id : 9362 customer_email : r.heno10@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 : 201512 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9363" select * from cms_frontusers where identifiant = "d.loustau17" 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 = "9363" select * from cotisations where identifiant = "d.loustau17" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 200501 payment_means : MASTERCARD transmission_date : 20151125190501 payment_time : 200648 payment_date : 20151125 response_code : 00 payment_certificate : fc5e9b885fc7 authorisation_id : 453181 currency_code : 978 card_number : 5137.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 : d.loustau17 order_id : 9363 customer_email : d.loustau17@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 : ------------------------------------------- select * from cotisations_commande where id = "9364" select * from cms_frontusers where identifiant = "m.picaut17" 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 = "9364" select * from cotisations where identifiant = "m.picaut17" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 200535 payment_means : MASTERCARD transmission_date : 20151125190535 payment_time : 200756 payment_date : 20151125 response_code : 00 payment_certificate : 5b278c6dff56 authorisation_id : 323664 currency_code : 978 card_number : 5131.73 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 : m.picaut17 order_id : 9364 customer_email : m.picaut17@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201003 payment_means : VISA transmission_date : 20151125191003 payment_time : 201224 payment_date : 20151125 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.55 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 : t.menicagli26 order_id : 9365 customer_email : t.menicagli26@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 : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9368" select * from cms_frontusers where identifiant = "jc.xambo27" 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 = "9368" select * from cotisations where identifiant = "jc.xambo27" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202422 payment_means : VISA transmission_date : 20151125192422 payment_time : 202644 payment_date : 20151125 response_code : 00 payment_certificate : fc254fd719e4 authorisation_id : 449304 currency_code : 978 card_number : 4970.30 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 : jc.xambo27 order_id : 9368 customer_email : jc.xambo27@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 = "9370" select * from cms_frontusers where identifiant = "j.guenneugues25" 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 = "9370" select * from cotisations where identifiant = "j.guenneugues25" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203047 payment_means : MASTERCARD transmission_date : 20151125193047 payment_time : 203251 payment_date : 20151125 response_code : 00 payment_certificate : cbf4245300d3 authorisation_id : 659035 currency_code : 978 card_number : 5341.39 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.guenneugues25 order_id : 9370 customer_email : j.guenneugues25@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 = "9361" select * from cms_frontusers where identifiant = "h.caprani24" 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 = "9361" select * from cotisations where identifiant = "h.caprani24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 194809 payment_means : MASTERCARD transmission_date : 20151125184809 payment_time : 203431 payment_date : 20151125 response_code : 00 payment_certificate : 36399f322d06 authorisation_id : 416785 currency_code : 978 card_number : 5137.64 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 : h.caprani24 order_id : 9361 customer_email : h.caprani24@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 : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9373" select * from cms_frontusers where identifiant = "r.chalmeau06" 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 = "9373" select * from cotisations where identifiant = "f.lemercier31" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 213442 payment_means : VISA transmission_date : 20151125203442 payment_time : 213657 payment_date : 20151125 response_code : 00 payment_certificate : 95ee66988760 authorisation_id : 204446 currency_code : 978 card_number : 4975.45 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.chalmeau06 order_id : 9373 customer_email : r.chalmeau06@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 = "9375" select * from cms_frontusers where identifiant = "t.gossedegorre16" 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 = "9375" select * from cotisations where identifiant = "t.gossedegorre16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 215401 payment_means : MASTERCARD transmission_date : 20151125205401 payment_time : 215822 payment_date : 20151125 response_code : 00 payment_certificate : 95de4e279809 authorisation_id : 310323 currency_code : 978 card_number : 5131.15 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 : t.gossedegorre16 order_id : 9375 customer_email : t.gossedegorre16@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 = "9376" select * from cms_frontusers where identifiant = "t.assemat28" 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 = "9376" select * from cotisations where identifiant = "t.assemat28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 215850 payment_means : VISA transmission_date : 20151125205850 payment_time : 220233 payment_date : 20151125 response_code : 00 payment_certificate : 44307cda1d29 authorisation_id : 006274 currency_code : 978 card_number : 4659.87 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 : t.assemat28 order_id : 9376 customer_email : t.assemat28@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 : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9377" select * from cms_frontusers where identifiant = "s.frouin07" 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 = "9377" select * from cotisations where identifiant = "s.frouin07" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 220959 payment_means : MASTERCARD transmission_date : 20151125210959 payment_time : 221312 payment_date : 20151125 response_code : 00 payment_certificate : 6ef038d31754 authorisation_id : 629714 currency_code : 978 card_number : 5132.78 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 : s.frouin07 order_id : 9377 customer_email : s.frouin07@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 : 201704 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9378" select * from cms_frontusers where identifiant = "n.gonin08" 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 = "9378" select * from cotisations where identifiant = "n.gonin08" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 221355 payment_means : VISA transmission_date : 20151125211355 payment_time : 221617 payment_date : 20151125 response_code : 00 payment_certificate : 15babc12c00b authorisation_id : 637441 currency_code : 978 card_number : 4975.28 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 : n.gonin08 order_id : 9378 customer_email : n.gonin08@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 = "9379" select * from cms_frontusers where identifiant = "f.trochou17" 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 = "9379" select * from cotisations where identifiant = "f.trochou17" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 222522 payment_means : VISA transmission_date : 20151125212522 payment_time : 222700 payment_date : 20151125 response_code : 00 payment_certificate : 9b617f2cc569 authorisation_id : 693925 currency_code : 978 card_number : 4978.02 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 : f.trochou17 order_id : 9379 customer_email : f.trochou17@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 : 201811 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 : 8000 transaction_id : 230842 payment_means : MASTERCARD transmission_date : 20151125220842 payment_time : 231118 payment_date : 20151125 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.69 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 : y.pantaleon13 order_id : 9380 customer_email : y.pantaleon13@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 : 201810 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------