select * from cotisations_commande where id = "17792" select * from cms_frontusers where identifiant = "a.bonnaventure22" 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 = "17792" select * from cotisations where identifiant = "a.bonnaventure22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 234146 payment_means : VISA transmission_date : 20161208224146 payment_time : 000224 payment_date : 20161209 response_code : 00 payment_certificate : 598a884ca92b authorisation_id : 424696 currency_code : 978 card_number : 4970.40 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.bonnaventure22 order_id : 17792 customer_email : a.bonnaventure22@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 : 201612 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 : 012052 payment_means : MASTERCARD transmission_date : 20161209002052 payment_time : 012252 payment_date : 20161209 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.05 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.naudi25 order_id : 17794 customer_email : e.naudi25@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 : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17795" select * from cms_frontusers where identifiant = "s.malriat18" 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 = "17795" select * from cotisations where identifiant = "s.malriat18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 063302 payment_means : MASTERCARD transmission_date : 20161209053302 payment_time : 063540 payment_date : 20161209 response_code : 00 payment_certificate : 64f8b2b6c443 authorisation_id : 810879 currency_code : 978 card_number : 5132.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 : s.malriat18 order_id : 17795 customer_email : s.malriat18@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 : 201707 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17796" select * from cms_frontusers where identifiant = "j.regnier16" 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 = "17796" select * from cotisations where identifiant = "p.monnier08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 081132 payment_means : MASTERCARD transmission_date : 20161209071132 payment_time : 081429 payment_date : 20161209 response_code : 00 payment_certificate : e3083792c697 authorisation_id : 142323 currency_code : 978 card_number : 5137.85 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.regnier16 order_id : 17796 customer_email : j.regnier16@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 : 083258 payment_means : VISA transmission_date : 20161209073258 payment_time : 083435 payment_date : 20161209 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4975.33 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.zordan05 order_id : 17797 customer_email : s.zordan05@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 : 201902 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17798" select * from cms_frontusers where identifiant = "p.lefebvre06" 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 = "17798" select * from cotisations where identifiant = "p.balme18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 084825 payment_means : VISA transmission_date : 20161209074825 payment_time : 084938 payment_date : 20161209 response_code : 00 payment_certificate : e4410932d178 authorisation_id : 037539 currency_code : 978 card_number : 4533.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 : p.lefebvre06 order_id : 17798 customer_email : p.lefebvre06@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 : ------------------------------------------- select * from cotisations_commande where id = "17799" select * from cms_frontusers where identifiant = "m.conti12" 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 = "17799" select * from cotisations where identifiant = "m.conti12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 085307 payment_means : VISA transmission_date : 20161209075307 payment_time : 085450 payment_date : 20161209 response_code : 00 payment_certificate : bddb37696be2 authorisation_id : 471661 currency_code : 978 card_number : 4970.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 : m.conti12 order_id : 17799 customer_email : m.conti12@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 : 201802 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17800" select * from cms_frontusers where identifiant = "jb.paguessorhaye20" 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 = "17800" select * from cotisations where identifiant = "jb.paguessorhaye20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 085841 payment_means : VISA transmission_date : 20161209075841 payment_time : 090004 payment_date : 20161209 response_code : 00 payment_certificate : 5935404b4962 authorisation_id : 049532 currency_code : 978 card_number : 4979.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 : jb.paguessorhaye20 order_id : 17800 customer_email : jb.paguessorhaye20@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 090436 payment_means : VISA transmission_date : 20161209080436 payment_time : 090626 payment_date : 20161209 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4975.61 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 59 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.flotterer06 order_id : 17801 customer_email : l.flotterer06@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 = "17801" select * from cms_frontusers where identifiant = "l.flotterer06" 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 = "17801" select * from cotisations where identifiant = "l.flotterer06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 090632 payment_means : VISA transmission_date : 20161209080632 payment_time : 090728 payment_date : 20161209 response_code : 00 payment_certificate : a29a91ba7fa9 authorisation_id : 346472 currency_code : 978 card_number : 4975.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 : l.flotterer06 order_id : 17801 customer_email : l.flotterer06@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 = "17802" select * from cms_frontusers where identifiant = "i.berland18" 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 = "17802" select * from cotisations where identifiant = "i.berland18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 091355 payment_means : VISA transmission_date : 20161209081355 payment_time : 091557 payment_date : 20161209 response_code : 00 payment_certificate : 7b72126adb1f authorisation_id : 254222 currency_code : 978 card_number : 4978.40 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 : i.berland18 order_id : 17802 customer_email : i.berland18@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 : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17803" select * from cms_frontusers where identifiant = "jp.casala18" 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 = "17803" select * from cotisations where identifiant = "f.kerberenes28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 091406 payment_means : VISA transmission_date : 20161209081406 payment_time : 091741 payment_date : 20161209 response_code : 00 payment_certificate : a6af843d8a4e authorisation_id : 486651 currency_code : 978 card_number : 4975.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 : jp.casala18 order_id : 17803 customer_email : jp.casala18@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 : 201905 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 : 092456 payment_means : VISA transmission_date : 20161209082456 payment_time : 093023 payment_date : 20161209 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.02 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.mendes21 order_id : 17804 customer_email : b.mendes21@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 : 201910 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17805" select * from cms_frontusers where identifiant = "m.henriot12" 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 = "17805" select * from cotisations where identifiant = "m.henriot12" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "m.henriot12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 095801 payment_means : MASTERCARD transmission_date : 20161209085801 payment_time : 100048 payment_date : 20161209 response_code : 00 payment_certificate : cb720bd58d2c authorisation_id : 183247 currency_code : 978 card_number : 5132.34 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.henriot12 order_id : 17805 customer_email : m.henriot12@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 = "17806" select * from cms_frontusers where identifiant = "g.lucido21" 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 = "17806" select * from cotisations where identifiant = "g.lucido21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 101817 payment_means : VISA transmission_date : 20161209091817 payment_time : 102112 payment_date : 20161209 response_code : 00 payment_certificate : ea8b2cac9805 authorisation_id : 198314 currency_code : 978 card_number : 4970.48 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.lucido21 order_id : 17806 customer_email : g.lucido21@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 : 201612 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 : 102846 payment_means : VISA transmission_date : 20161209092846 payment_time : 103438 payment_date : 20161209 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4976.39 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.cheyrol29 order_id : 17808 customer_email : j.cheyrol29@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 : 201911 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17809" select * from cms_frontusers where identifiant = "g.lecomte01" 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 = "17809" select * from cotisations where identifiant = "g.lecomte01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 104954 payment_means : MASTERCARD transmission_date : 20161209094954 payment_time : 105115 payment_date : 20161209 response_code : 00 payment_certificate : 77523087ba68 authorisation_id : 126554 currency_code : 978 card_number : 5131.66 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.lecomte01 order_id : 17809 customer_email : g.lecomte01@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 105443 payment_means : MASTERCARD transmission_date : 20161209095443 payment_time : 105627 payment_date : 20161209 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.66 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.delafosse25 order_id : 17810 customer_email : e.delafosse25@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 = "17810" select * from cms_frontusers where identifiant = "e.delafosse25" 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 = "17810" select * from cotisations where identifiant = "e.delafosse25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 105725 payment_means : MASTERCARD transmission_date : 20161209095725 payment_time : 105859 payment_date : 20161209 response_code : 00 payment_certificate : e6d0b559fd02 authorisation_id : 272563 currency_code : 978 card_number : 5132.66 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.delafosse25 order_id : 17810 customer_email : e.delafosse25@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 : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17812" select * from cms_frontusers where identifiant = "p.mangin01" 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 = "17812" select * from cotisations where identifiant = "p.mangin01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 112615 payment_means : VISA transmission_date : 20161209102615 payment_time : 112842 payment_date : 20161209 response_code : 00 payment_certificate : 9e9dceaec42b authorisation_id : 631468 currency_code : 978 card_number : 4970.48 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.mangin01 order_id : 17812 customer_email : p.mangin01@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 : 201612 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17813" select * from cms_frontusers where identifiant = "r.nogales03" 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 = "17813" select * from cotisations where identifiant = "r.nogales03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 113028 payment_means : MASTERCARD transmission_date : 20161209103028 payment_time : 113352 payment_date : 20161209 response_code : 00 payment_certificate : bcf9fb606677 authorisation_id : 724613 currency_code : 978 card_number : 5132.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 : r.nogales03 order_id : 17813 customer_email : r.nogales03@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 = "17814" select * from cms_frontusers where identifiant = "b.lamontagne18" 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 = "17814" select * from cotisations where identifiant = "j.cheyrol29" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 115007 payment_means : VISA transmission_date : 20161209105007 payment_time : 115342 payment_date : 20161209 response_code : 00 payment_certificate : 8a6219054d4a authorisation_id : 688166 currency_code : 978 card_number : 4976.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 : b.lamontagne18 order_id : 17814 customer_email : b.lamontagne18@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 : 201911 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17815" select * from cms_frontusers where identifiant = "w.renard16" 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 = "17815" select * from cotisations where identifiant = "w.renard16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 120200 payment_means : MASTERCARD transmission_date : 20161209110200 payment_time : 120317 payment_date : 20161209 response_code : 00 payment_certificate : 9483ad5f97cb authorisation_id : 245333 currency_code : 978 card_number : 5341.48 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 : w.renard16 order_id : 17815 customer_email : w.renard16@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 : 201812 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 : 120446 payment_means : VISA transmission_date : 20161209110446 payment_time : 120554 payment_date : 20161209 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4552.84 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.meneyrol14 order_id : 17816 customer_email : e.meneyrol14@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 : 201701 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 : 120611 payment_means : VISA transmission_date : 20161209110611 payment_time : 120838 payment_date : 20161209 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.24 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.kouyoumdjian07 order_id : 17817 customer_email : c.kouyoumdjian07@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 : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17816" select * from cms_frontusers where identifiant = "e.meneyrol14" 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 = "17816" select * from cotisations where identifiant = "e.meneyrol14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 120623 payment_means : VISA transmission_date : 20161209110623 payment_time : 120948 payment_date : 20161209 response_code : 00 payment_certificate : 8147cb082882 authorisation_id : 765167 currency_code : 978 card_number : 4972.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 : e.meneyrol14 order_id : 17816 customer_email : e.meneyrol14@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 = "17811" select * from cms_frontusers where identifiant = "a.gleye15" 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 = "17811" select * from cotisations where identifiant = "a.gleye15" and annee = "2017" and montant <> 0 Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 120852 payment_means : VISA transmission_date : 20161209110852 payment_time : 121520 payment_date : 20161209 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.05 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.kouyoumdjian07 order_id : 17817 customer_email : c.kouyoumdjian07@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 : ------------------------------------------- code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 105638 payment_means : VISA transmission_date : 20161209095638 payment_time : 121258 payment_date : 20161209 response_code : 00 payment_certificate : 904fc874c267 authorisation_id : 968509 currency_code : 978 card_number : 4970.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 : a.gleye15 order_id : 17811 customer_email : a.gleye15@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 : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17817" select * from cms_frontusers where identifiant = "c.kouyoumdjian07" 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 = "17817" select * from cotisations where identifiant = "c.kouyoumdjian07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 121543 payment_means : VISA transmission_date : 20161209111543 payment_time : 122004 payment_date : 20161209 response_code : 00 payment_certificate : 8557b23b6ec9 authorisation_id : 961251 currency_code : 978 card_number : 4978.08 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 : c.kouyoumdjian07 order_id : 17817 customer_email : c.kouyoumdjian07@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 = "17818" select * from cms_frontusers where identifiant = "a.charron20" 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 = "17818" select * from cotisations where identifiant = "a.charron20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 132807 payment_means : MASTERCARD transmission_date : 20161209122807 payment_time : 132952 payment_date : 20161209 response_code : 00 payment_certificate : 2ba6a64c7a6b authorisation_id : 444489 currency_code : 978 card_number : 5132.19 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.charron20 order_id : 17818 customer_email : a.charron20@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 : 201711 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 : 135147 payment_means : MASTERCARD transmission_date : 20161209125147 payment_time : 135513 payment_date : 20161209 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5100.89 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.rassineux17 order_id : 17819 customer_email : p.rassineux17@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 = "17820" select * from cms_frontusers where identifiant = "m.guenantin29" 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 = "17820" select * from cotisations where identifiant = "m.guenantin29" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 142511 payment_means : MASTERCARD transmission_date : 20161209132511 payment_time : 142732 payment_date : 20161209 response_code : 00 payment_certificate : b565dbbd88b2 authorisation_id : 160120 currency_code : 978 card_number : 5138.34 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.guenantin29 order_id : 17820 customer_email : m.guenantin29@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 = "17821" select * from cms_frontusers where identifiant = "p.rassineux17" 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 = "17821" select * from cotisations where identifiant = "p.rassineux17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 142622 payment_means : MASTERCARD transmission_date : 20161209132622 payment_time : 142749 payment_date : 20161209 response_code : 00 payment_certificate : 8a2b9057fb6e authorisation_id : 024955 currency_code : 978 card_number : 5100.89 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.rassineux17 order_id : 17821 customer_email : p.rassineux17@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 : 201708 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17822" select * from cms_frontusers where identifiant = "p.huchet03" 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 = "17822" select * from cotisations where identifiant = "p.huchet03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 143041 payment_means : MASTERCARD transmission_date : 20161209133041 payment_time : 143252 payment_date : 20161209 response_code : 00 payment_certificate : f11961940db1 authorisation_id : 623837 currency_code : 978 card_number : 5131.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 : p.huchet03 order_id : 17822 customer_email : p.huchet03@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 = "17824" select * from cms_frontusers where identifiant = "p.lahaye03" 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 = "17824" select * from cotisations where identifiant = "p.lahaye03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 150228 payment_means : VISA transmission_date : 20161209140228 payment_time : 150421 payment_date : 20161209 response_code : 00 payment_certificate : c23d64cc7867 authorisation_id : 417131 currency_code : 978 card_number : 4970.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 : p.lahaye03 order_id : 17824 customer_email : p.lahaye03@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 = "17823" select * from cms_frontusers where identifiant = "jl.dubosq28" 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 = "17823" select * from cotisations where identifiant = "jl.dubosq28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 145950 payment_means : VISA transmission_date : 20161209135950 payment_time : 150517 payment_date : 20161209 response_code : 00 payment_certificate : 515d805e7b9b authorisation_id : 522411 currency_code : 978 card_number : 4974.35 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.dubosq28 order_id : 17823 customer_email : jl.dubosq28@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 : 201805 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 : 152935 payment_means : VISA transmission_date : 20161209142935 payment_time : 153756 payment_date : 20161209 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4975.37 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.caubet02 order_id : 17825 customer_email : g.caubet02@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 : 201806 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 : 153805 payment_means : VISA transmission_date : 20161209143805 payment_time : 154706 payment_date : 20161209 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4975.37 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.caubet02 order_id : 17825 customer_email : g.caubet02@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 : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17827" select * from cms_frontusers where identifiant = "l.sbrava12" 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 = "17827" select * from cotisations where identifiant = "g.lebigot08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 155504 payment_means : VISA transmission_date : 20161209145504 payment_time : 155659 payment_date : 20161209 response_code : 00 payment_certificate : e34ff395e843 authorisation_id : 346566 currency_code : 978 card_number : 4771.82 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.sbrava12 order_id : 17827 customer_email : l.sbrava12@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 = "17826" select * from cms_frontusers where identifiant = "c.triconnet01" 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 = "17826" select * from cotisations where identifiant = "c.triconnet01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 155247 payment_means : VISA transmission_date : 20161209145247 payment_time : 155752 payment_date : 20161209 response_code : 00 payment_certificate : 85fc01b68905 authorisation_id : 553632 currency_code : 978 card_number : 4975.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 : c.triconnet01 order_id : 17826 customer_email : c.triconnet01@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 : 201910 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 : 154824 payment_means : VISA transmission_date : 20161209144824 payment_time : 161612 payment_date : 20161209 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4975.37 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.caubet02 order_id : 17825 customer_email : g.caubet02@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 : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17829" select * from cms_frontusers where identifiant = "a.roger02" 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 = "17829" select * from cotisations where identifiant = "a.roger02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 162524 payment_means : MASTERCARD transmission_date : 20161209152524 payment_time : 162637 payment_date : 20161209 response_code : 00 payment_certificate : 659e50238b8a authorisation_id : 908546 currency_code : 978 card_number : 5134.69 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.roger02 order_id : 17829 customer_email : a.roger02@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 : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17831" select * from cms_frontusers where identifiant = "a.branchu11" 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 = "17831" select * from cotisations where identifiant = "a.branchu11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 170639 payment_means : VISA transmission_date : 20161209160639 payment_time : 170757 payment_date : 20161209 response_code : 00 payment_certificate : ed41315ea253 authorisation_id : 897224 currency_code : 978 card_number : 4970.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 : a.branchu11 order_id : 17831 customer_email : a.branchu11@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 170557 payment_means : VISA transmission_date : 20161209160557 payment_time : 170824 payment_date : 20161209 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.31 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.dege10 order_id : 17830 customer_email : r.dege10@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 : 201910 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17832" select * from cms_frontusers where identifiant = "h.achy24" 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 = "17832" select * from cotisations where identifiant = "h.achy24" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 173057 payment_means : VISA transmission_date : 20161209163057 payment_time : 173345 payment_date : 20161209 response_code : 00 payment_certificate : 5dd1a1db15c7 authorisation_id : 566593 currency_code : 978 card_number : 4970.54 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.achy24 order_id : 17832 customer_email : h.achy24@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 = "17833" select * from cms_frontusers where identifiant = "l.sbrava12" 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 = "17833" select * from cotisations where identifiant = "x.leger14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 173506 payment_means : MASTERCARD transmission_date : 20161209163506 payment_time : 173618 payment_date : 20161209 response_code : 00 payment_certificate : 6dc444c8c832 authorisation_id : 486194 currency_code : 978 card_number : 5132.18 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.sbrava12 order_id : 17833 customer_email : l.sbrava12@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 = "17834" select * from cms_frontusers where identifiant = "l.sbrava12" 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 = "17834" select * from cotisations where identifiant = "jb.chegaray13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 173756 payment_means : VISA transmission_date : 20161209163756 payment_time : 173853 payment_date : 20161209 response_code : 00 payment_certificate : 8cb1171c3b88 authorisation_id : 012939 currency_code : 978 card_number : 4970.27 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.sbrava12 order_id : 17834 customer_email : l.sbrava12@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 : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17836" select * from cms_frontusers where identifiant = "l.sbrava12" 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 = "17836" select * from cotisations where identifiant = "a.calixte13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 174022 payment_means : MASTERCARD transmission_date : 20161209164022 payment_time : 174125 payment_date : 20161209 response_code : 00 payment_certificate : db8dece64042 authorisation_id : 483644 currency_code : 978 card_number : 5131.55 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.sbrava12 order_id : 17836 customer_email : l.sbrava12@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 = "17830" select * from cms_frontusers where identifiant = "r.dege10" 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 = "17830" select * from cotisations where identifiant = "r.dege10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 170836 payment_means : VISA transmission_date : 20161209160836 payment_time : 174215 payment_date : 20161209 response_code : 00 payment_certificate : b38d48290b47 authorisation_id : 201164 currency_code : 978 card_number : 4974.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.dege10 order_id : 17830 customer_email : r.dege10@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 : 201911 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17839" select * from cms_frontusers where identifiant = "d.tudon14" 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 = "17839" select * from cotisations where identifiant = "d.tudon14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 175244 payment_means : VISA transmission_date : 20161209165244 payment_time : 175739 payment_date : 20161209 response_code : 00 payment_certificate : bfa884cb6426 authorisation_id : 612338 currency_code : 978 card_number : 4974.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 : d.tudon14 order_id : 17839 customer_email : d.tudon14@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 : 174959 payment_means : MASTERCARD transmission_date : 20161209164959 payment_time : 175829 payment_date : 20161209 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.32 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.parnaud27 order_id : 17838 customer_email : g.parnaud27@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 : ------------------------------------------- select * from cotisations_commande where id = "17840" select * from cms_frontusers where identifiant = "a.gleyze24" 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 = "17840" select * from cotisations where identifiant = "t.jannier01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 180512 payment_means : VISA transmission_date : 20161209170512 payment_time : 181037 payment_date : 20161209 response_code : 00 payment_certificate : 326e7c8c97b5 authorisation_id : 456823 currency_code : 978 card_number : 4978.12 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.gleyze24 order_id : 17840 customer_email : a.gleyze24@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 = "17841" select * from cms_frontusers where identifiant = "b.villefranque25" 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 = "17841" select * from cotisations where identifiant = "b.villefranque25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181706 payment_means : VISA transmission_date : 20161209171706 payment_time : 181912 payment_date : 20161209 response_code : 00 payment_certificate : bc5512d8f582 authorisation_id : 605388 currency_code : 978 card_number : 4276.04 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.villefranque25 order_id : 17841 customer_email : b.villefranque25@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 : 201707 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17842" select * from cms_frontusers where identifiant = "a.caullireau22" 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 = "17842" select * from cotisations where identifiant = "a.caullireau22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 182930 payment_means : MASTERCARD transmission_date : 20161209172930 payment_time : 183045 payment_date : 20161209 response_code : 00 payment_certificate : 44da994ef0df authorisation_id : 342745 currency_code : 978 card_number : 5131.04 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.caullireau22 order_id : 17842 customer_email : a.caullireau22@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 : ------------------------------------------- select * from cotisations_commande where id = "17843" select * from cms_frontusers where identifiant = "j.balsan11" 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 = "17843" select * from cotisations where identifiant = "j.balsan11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 184046 payment_means : VISA transmission_date : 20161209174046 payment_time : 184229 payment_date : 20161209 response_code : 00 payment_certificate : e6482113d0d1 authorisation_id : 297614 currency_code : 978 card_number : 4974.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 : j.balsan11 order_id : 17843 customer_email : j.balsan11@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 : 201907 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17844" select * from cms_frontusers where identifiant = "j.ineichen07" 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 = "17844" select * from cotisations where identifiant = "j.ineichen07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 184746 payment_means : VISA transmission_date : 20161209174746 payment_time : 184954 payment_date : 20161209 response_code : 00 payment_certificate : 873d185635ee authorisation_id : 637731 currency_code : 978 card_number : 4970.68 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.ineichen07 order_id : 17844 customer_email : j.ineichen07@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 185010 payment_means : MASTERCARD transmission_date : 20161209175010 payment_time : 185151 payment_date : 20161209 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.07 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.goullieux05 order_id : 17845 customer_email : r.goullieux05@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 : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17846" select * from cms_frontusers where identifiant = "a.dasilvacarvalho22" 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 = "17846" select * from cotisations where identifiant = "a.dasilvacarvalho22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185017 payment_means : VISA transmission_date : 20161209175017 payment_time : 185258 payment_date : 20161209 response_code : 00 payment_certificate : 462de4b379e1 authorisation_id : 688281 currency_code : 978 card_number : 4974.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 : a.dasilvacarvalho22 order_id : 17846 customer_email : a.dasilvacarvalho22@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 185646 payment_means : MASTERCARD transmission_date : 20161209175646 payment_time : 185753 payment_date : 20161209 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.07 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.goullieux05 order_id : 17847 customer_email : r.goullieux05@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 : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17847" select * from cms_frontusers where identifiant = "r.goullieux05" 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 = "17847" select * from cotisations where identifiant = "r.goullieux05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 185800 payment_means : MASTERCARD transmission_date : 20161209175800 payment_time : 185920 payment_date : 20161209 response_code : 00 payment_certificate : b83c06013ed2 authorisation_id : 003775 currency_code : 978 card_number : 5131.00 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.goullieux05 order_id : 17847 customer_email : r.goullieux05@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 : 201801 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17848" select * from cms_frontusers where identifiant = "r.fondabegue29" 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 = "17848" select * from cotisations where identifiant = "r.fondabegue29" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 190034 payment_means : MASTERCARD transmission_date : 20161209180034 payment_time : 190201 payment_date : 20161209 response_code : 00 payment_certificate : f9c469fbfca6 authorisation_id : 502463 currency_code : 978 card_number : 5131.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 : r.fondabegue29 order_id : 17848 customer_email : r.fondabegue29@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 = "17849" select * from cms_frontusers where identifiant = "g.mazier27" 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 = "17849" select * from cotisations where identifiant = "g.mazier27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 190920 payment_means : VISA transmission_date : 20161209180920 payment_time : 191128 payment_date : 20161209 response_code : 00 payment_certificate : 24bc7e8895bb authorisation_id : 464124 currency_code : 978 card_number : 4975.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 : g.mazier27 order_id : 17849 customer_email : g.mazier27@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 : 201901 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17850" select * from cms_frontusers where identifiant = "b.galichet25" 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 = "17850" select * from cotisations where identifiant = "b.galichet25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191110 payment_means : VISA transmission_date : 20161209181110 payment_time : 191429 payment_date : 20161209 response_code : 00 payment_certificate : da73f798b6b2 authorisation_id : 821242 currency_code : 978 card_number : 4970.34 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.galichet25 order_id : 17850 customer_email : b.galichet25@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 = "17852" select * from cms_frontusers where identifiant = "x.garles29" 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 = "17852" select * from cotisations where identifiant = "x.garles29" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 192816 payment_means : VISA transmission_date : 20161209182816 payment_time : 193013 payment_date : 20161209 response_code : 00 payment_certificate : 42f46e1f6875 authorisation_id : 228160 currency_code : 978 card_number : 4976.16 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 : x.garles29 order_id : 17852 customer_email : x.garles29@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 = "17853" select * from cms_frontusers where identifiant = "e.naudi25" 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 = "17853" select * from cotisations where identifiant = "e.naudi25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 194227 payment_means : MASTERCARD transmission_date : 20161209184227 payment_time : 194424 payment_date : 20161209 response_code : 00 payment_certificate : 34cf5d9b3b68 authorisation_id : 733939 currency_code : 978 card_number : 5137.10 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.naudi25 order_id : 17853 customer_email : e.naudi25@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 = "17854" select * from cms_frontusers where identifiant = "m.begue20" 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 = "17854" select * from cotisations where identifiant = "m.begue20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200531 payment_means : MASTERCARD transmission_date : 20161209190531 payment_time : 200713 payment_date : 20161209 response_code : 00 payment_certificate : f90bd5c19adf authorisation_id : 701029 currency_code : 978 card_number : 5341.40 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.begue20 order_id : 17854 customer_email : m.begue20@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 : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17855" select * from cms_frontusers where identifiant = "a.berger06" 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 = "17855" select * from cotisations where identifiant = "a.berger06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200904 payment_means : MASTERCARD transmission_date : 20161209190904 payment_time : 201050 payment_date : 20161209 response_code : 00 payment_certificate : 3b7951c933c0 authorisation_id : 922647 currency_code : 978 card_number : 5131.36 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.berger06 order_id : 17855 customer_email : a.berger06@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 : ------------------------------------------- select * from cotisations_commande where id = "17857" select * from cms_frontusers where identifiant = "a.berger06" 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 = "17857" select * from cotisations where identifiant = "a.biver22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201258 payment_means : VISA transmission_date : 20161209191258 payment_time : 201551 payment_date : 20161209 response_code : 00 payment_certificate : 18194c4deb03 authorisation_id : 537845 currency_code : 978 card_number : 4978.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 : a.berger06 order_id : 17857 customer_email : a.berger06@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 = "17858" select * from cms_frontusers where identifiant = "d.jean20" 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 = "17858" select * from cotisations where identifiant = "d.jean20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202032 payment_means : MASTERCARD transmission_date : 20161209192032 payment_time : 202334 payment_date : 20161209 response_code : 00 payment_certificate : 9d2d8767dcd8 authorisation_id : 447555 currency_code : 978 card_number : 5131.07 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.jean20 order_id : 17858 customer_email : d.jean20@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 = "17859" select * from cms_frontusers where identifiant = "d.bourgier05" 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 = "17859" select * from cotisations where identifiant = "d.bourgier05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202325 payment_means : VISA transmission_date : 20161209192325 payment_time : 202608 payment_date : 20161209 response_code : 00 payment_certificate : 1a19bad17cfc authorisation_id : 152325 currency_code : 978 card_number : 4973.52 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.bourgier05 order_id : 17859 customer_email : d.bourgier05@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 : 201902 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17862" select * from cms_frontusers where identifiant = "a.marion13" 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 = "17862" select * from cotisations where identifiant = "a.marion13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205133 payment_means : MASTERCARD transmission_date : 20161209195133 payment_time : 205249 payment_date : 20161209 response_code : 00 payment_certificate : 91d85907244b authorisation_id : 559152 currency_code : 978 card_number : 5131.53 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.marion13 order_id : 17862 customer_email : a.marion13@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 : 201903 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17863" select * from cms_frontusers where identifiant = "b.demaintenant11" 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 = "17863" select * from cotisations where identifiant = "b.demaintenant11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 205509 payment_means : VISA transmission_date : 20161209195509 payment_time : 205733 payment_date : 20161209 response_code : 00 payment_certificate : d8bea9c8ac3d authorisation_id : 392856 currency_code : 978 card_number : 4973.69 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.demaintenant11 order_id : 17863 customer_email : b.demaintenant11@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 : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17864" select * from cms_frontusers where identifiant = "g.popek23" 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 = "17864" select * from cotisations where identifiant = "g.popek23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205626 payment_means : MASTERCARD transmission_date : 20161209195626 payment_time : 205852 payment_date : 20161209 response_code : 00 payment_certificate : 79d0e35c251d authorisation_id : 587710 currency_code : 978 card_number : 5137.80 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.popek23 order_id : 17864 customer_email : g.popek23@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 : 204931 payment_means : VISA transmission_date : 20161209194931 payment_time : 210151 payment_date : 20161209 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.02 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.bardet07 order_id : 17861 customer_email : c.bardet07@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 : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17861" select * from cms_frontusers where identifiant = "c.bardet07" 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 = "17861" select * from cotisations where identifiant = "t.devos19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 210204 payment_means : VISA transmission_date : 20161209200204 payment_time : 210341 payment_date : 20161209 response_code : 00 payment_certificate : 693958706277 authorisation_id : 335017 currency_code : 978 card_number : 4973.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 : c.bardet07 order_id : 17861 customer_email : c.bardet07@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 = "17866" select * from cms_frontusers where identifiant = "t.maure23" 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 = "17866" select * from cotisations where identifiant = "t.maure23" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "t.maure23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 210144 payment_means : VISA transmission_date : 20161209200144 payment_time : 210555 payment_date : 20161209 response_code : 00 payment_certificate : e1945411b40f authorisation_id : 955393 currency_code : 978 card_number : 4978.16 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.maure23 order_id : 17866 customer_email : t.maure23@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 = "17867" select * from cms_frontusers where identifiant = "t.hatton21" 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 = "17867" select * from cotisations where identifiant = "t.hatton21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 210411 payment_means : MASTERCARD transmission_date : 20161209200411 payment_time : 210830 payment_date : 20161209 response_code : 00 payment_certificate : 43bc395ec614 authorisation_id : 843081 currency_code : 978 card_number : 5131.58 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.hatton21 order_id : 17867 customer_email : t.hatton21@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 : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17868" select * from cms_frontusers where identifiant = "m.matray18" 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 = "17868" select * from cotisations where identifiant = "m.miquel26" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 210910 payment_means : VISA transmission_date : 20161209200910 payment_time : 211201 payment_date : 20161209 response_code : 00 payment_certificate : bc9f956b3cce authorisation_id : 957961 currency_code : 978 card_number : 4974.21 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.matray18 order_id : 17868 customer_email : m.matray18@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 : ------------------------------------------- select * from cotisations_commande where id = "17869" select * from cms_frontusers where identifiant = "a.gilles26" 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 = "17869" select * from cotisations where identifiant = "l.spitzer04" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "l.spitzer04" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211055 payment_means : MASTERCARD transmission_date : 20161209201055 payment_time : 211257 payment_date : 20161209 response_code : 00 payment_certificate : cc12b3b8b811 authorisation_id : 345646 currency_code : 978 card_number : 5132.68 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.gilles26 order_id : 17869 customer_email : a.gilles26@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 : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17875" select * from cms_frontusers where identifiant = "js.huot16" 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 = "17875" select * from cotisations where identifiant = "js.huot16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214945 payment_means : VISA transmission_date : 20161209204945 payment_time : 215128 payment_date : 20161209 response_code : 00 payment_certificate : 7f4bdea0ff88 authorisation_id : 611622 currency_code : 978 card_number : 4975.35 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 : js.huot16 order_id : 17875 customer_email : js.huot16@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 220000 payment_means : VISA transmission_date : 20161209210000 payment_time : 220133 payment_date : 20161209 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.31 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.dandoy11 order_id : 17876 customer_email : f.dandoy11@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 : 201910 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17877" select * from cms_frontusers where identifiant = "m.voinet29" 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 = "17877" select * from cotisations where identifiant = "m.voinet29" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 220710 payment_means : VISA transmission_date : 20161209210710 payment_time : 220913 payment_date : 20161209 response_code : 00 payment_certificate : 441bbbae3f0b authorisation_id : 881421 currency_code : 978 card_number : 4974.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 : m.voinet29 order_id : 17877 customer_email : m.voinet29@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 : 201908 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17878" select * from cms_frontusers where identifiant = "t.bonin22" 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 = "17878" select * from cotisations where identifiant = "t.bonin22" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "t.bonin22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 220740 payment_means : MASTERCARD transmission_date : 20161209210740 payment_time : 220918 payment_date : 20161209 response_code : 00 payment_certificate : 4d440ef53804 authorisation_id : 783339 currency_code : 978 card_number : 5134.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 : t.bonin22 order_id : 17878 customer_email : t.bonin22@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 = "17879" select * from cms_frontusers where identifiant = "s.amsellem06" 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 = "17879" select * from cotisations where identifiant = "s.amsellem06" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 221228 payment_means : VISA transmission_date : 20161209211228 payment_time : 221344 payment_date : 20161209 response_code : 00 payment_certificate : 8c4b0bbc7f20 authorisation_id : 463396 currency_code : 978 card_number : 4978.13 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.amsellem06 order_id : 17879 customer_email : s.amsellem06@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 : 201909 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 : 220138 payment_means : MASTERCARD transmission_date : 20161209210138 payment_time : 221444 payment_date : 20161209 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5133.76 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.dandoy11 order_id : 17876 customer_email : f.dandoy11@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 : 201702 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17880" select * from cms_frontusers where identifiant = "s.amsellem06" 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 = "17880" select * from cotisations where identifiant = "s.amsellem06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 221407 payment_means : VISA transmission_date : 20161209211407 payment_time : 221457 payment_date : 20161209 response_code : 00 payment_certificate : b43b66fa1980 authorisation_id : 656416 currency_code : 978 card_number : 4978.13 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.amsellem06 order_id : 17880 customer_email : s.amsellem06@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 : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17881" select * from cms_frontusers where identifiant = "b.riviere15" 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 = "17881" select * from cotisations where identifiant = "b.riviere15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 223336 payment_means : MASTERCARD transmission_date : 20161209213336 payment_time : 223606 payment_date : 20161209 response_code : 00 payment_certificate : a3c5b8c4d50e authorisation_id : 192152 currency_code : 978 card_number : 5293.13 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.riviere15 order_id : 17881 customer_email : b.riviere15@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 = "17882" select * from cms_frontusers where identifiant = "r.bouchard09" 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 = "17882" select * from cotisations where identifiant = "r.bouchard09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 223519 payment_means : VISA transmission_date : 20161209213519 payment_time : 223826 payment_date : 20161209 response_code : 00 payment_certificate : 55ad739e031f authorisation_id : 611844 currency_code : 978 card_number : 4978.25 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.bouchard09 order_id : 17882 customer_email : r.bouchard09@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 = "17876" select * from cms_frontusers where identifiant = "f.dandoy11" 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 = "17876" select * from cotisations where identifiant = "f.dandoy11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 221450 payment_means : MASTERCARD transmission_date : 20161209211450 payment_time : 224829 payment_date : 20161209 response_code : 00 payment_certificate : 431d32bfa334 authorisation_id : 264047 currency_code : 978 card_number : 5817.23 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.dandoy11 order_id : 17876 customer_email : f.dandoy11@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 : 201702 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17884" select * from cms_frontusers where identifiant = "a.breuil30" 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 = "17884" select * from cotisations where identifiant = "n.francois11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 233521 payment_means : MASTERCARD transmission_date : 20161209223521 payment_time : 233705 payment_date : 20161209 response_code : 00 payment_certificate : 2a5a5ae222f6 authorisation_id : 651810 currency_code : 978 card_number : 5131.23 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.breuil30 order_id : 17884 customer_email : a.breuil30@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 : 8000 transaction_id : 233831 payment_means : VISA transmission_date : 20161209223831 payment_time : 233954 payment_date : 20161209 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4533.96 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.breuil30 order_id : 17885 customer_email : a.breuil30@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 = "17886" select * from cms_frontusers where identifiant = "a.breuil30" 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 = "17886" select * from cotisations where identifiant = "pa.charbonneau23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 234102 payment_means : MASTERCARD transmission_date : 20161209224102 payment_time : 234219 payment_date : 20161209 response_code : 00 payment_certificate : fa9dac7dd67c authorisation_id : 013240 currency_code : 978 card_number : 5131.23 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.breuil30 order_id : 17886 customer_email : a.breuil30@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 : 201912 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "17887" select * from cms_frontusers where identifiant = "a.breuil30" 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 = "17887" select * from cotisations where identifiant = "a.charoloy11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 234255 payment_means : MASTERCARD transmission_date : 20161209224255 payment_time : 234426 payment_date : 20161209 response_code : 00 payment_certificate : d7e69a74dfee authorisation_id : 612965 currency_code : 978 card_number : 5136.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.breuil30 order_id : 17887 customer_email : a.breuil30@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 : 202009 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------