Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 080426 payment_means : VISA transmission_date : 20141122070426 payment_time : 080641 payment_date : 20141122 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.95 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.guillat03 order_id : 3087 customer_email : n.guillat03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201512 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3089" select * from cms_frontusers where identifiant = "b.nauleau29" 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 = "3089" select * from cotisations where identifiant = "b.nauleau29" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 080938 payment_means : VISA transmission_date : 20141122070938 payment_time : 081106 payment_date : 20141122 response_code : 00 payment_certificate : 654d683a7d72 authorisation_id : 110751 currency_code : 978 card_number : 4978.99 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.nauleau29 order_id : 3089 customer_email : b.nauleau29@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 080701 payment_means : VISA transmission_date : 20141122070701 payment_time : 081233 payment_date : 20141122 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.95 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.guillat03 order_id : 3088 customer_email : n.guillat03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201512 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 082001 payment_means : MASTERCARD transmission_date : 20141122072001 payment_time : 082146 payment_date : 20141122 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.46 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.theroude02 order_id : 3090 customer_email : a.theroude02@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201601 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3092" select * from cms_frontusers where identifiant = "n.guillat03" 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 = "3092" select * from cotisations where identifiant = "n.guillat03" and annee = "2014" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 083524 payment_means : VISA transmission_date : 20141122073524 payment_time : 083641 payment_date : 20141122 response_code : 00 payment_certificate : 8d5a0b134468 authorisation_id : 241241 currency_code : 978 card_number : 4973.95 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.guillat03 order_id : 3092 customer_email : n.guillat03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201512 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3091" select * from cms_frontusers where identifiant = "l.burel25" 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 = "3091" select * from cotisations where identifiant = "l.burel25" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 083322 payment_means : VISA transmission_date : 20141122073322 payment_time : 083712 payment_date : 20141122 response_code : 00 payment_certificate : 1c82f6ec81d1 authorisation_id : 865922 currency_code : 978 card_number : 4973.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.burel25 order_id : 3091 customer_email : l.burel25@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 = "3093" select * from cms_frontusers where identifiant = "n.guillat03" 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 = "3093" select * from cotisations where identifiant = "n.guillat03" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 083744 payment_means : VISA transmission_date : 20141122073744 payment_time : 083910 payment_date : 20141122 response_code : 00 payment_certificate : 3a58088ec6ee authorisation_id : 596501 currency_code : 978 card_number : 4973.95 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.guillat03 order_id : 3093 customer_email : n.guillat03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201512 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 084445 payment_means : VISA transmission_date : 20141122074445 payment_time : 085023 payment_date : 20141122 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.72 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.asnar24 order_id : 3094 customer_email : v.asnar24@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 : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3096" select * from cms_frontusers where identifiant = "m.navet07" 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 = "3096" select * from cotisations where identifiant = "m.navet07" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 093940 payment_means : MASTERCARD transmission_date : 20141122083940 payment_time : 094411 payment_date : 20141122 response_code : 00 payment_certificate : f3c58d764fcb authorisation_id : 709153 currency_code : 978 card_number : 5131.38 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.navet07 order_id : 3096 customer_email : m.navet07@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201512 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 094300 payment_means : MASTERCARD transmission_date : 20141122084300 payment_time : 094529 payment_date : 20141122 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.10 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.lesne05 order_id : 3097 customer_email : c.lesne05@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 : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3098" select * from cms_frontusers where identifiant = "c.nunes02" 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 = "3098" select * from cotisations where identifiant = "c.nunes02" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 094845 payment_means : VISA transmission_date : 20141122084845 payment_time : 095013 payment_date : 20141122 response_code : 00 payment_certificate : 2912430c0d82 authorisation_id : 573423 currency_code : 978 card_number : 4974.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 : c.nunes02 order_id : 3098 customer_email : c.nunes02@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 : 201502 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3099" select * from cms_frontusers where identifiant = "c.nunes02" 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 = "3099" select * from cotisations where identifiant = "j.sauvage11" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 095140 payment_means : MASTERCARD transmission_date : 20141122085140 payment_time : 095332 payment_date : 20141122 response_code : 00 payment_certificate : 3202a33fbc8d authorisation_id : 762121 currency_code : 978 card_number : 5131.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 : c.nunes02 order_id : 3099 customer_email : c.nunes02@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 = "3100" select * from cms_frontusers where identifiant = "c.pichierri03" 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 = "3100" select * from cotisations where identifiant = "p.lebeller31" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 095616 payment_means : MASTERCARD transmission_date : 20141122085616 payment_time : 095918 payment_date : 20141122 response_code : 00 payment_certificate : c01d80beb5aa authorisation_id : 412232 currency_code : 978 card_number : 5136.71 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.pichierri03 order_id : 3100 customer_email : c.pichierri03@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 : 201501 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 : 095909 payment_means : VISA transmission_date : 20141122085909 payment_time : 100131 payment_date : 20141122 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.20 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.nunes02 order_id : 3101 customer_email : c.nunes02@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 : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3105" select * from cms_frontusers where identifiant = "a.calvino06" 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 = "3105" select * from cotisations where identifiant = "a.calvino06" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 103554 payment_means : MASTERCARD transmission_date : 20141122093554 payment_time : 103756 payment_date : 20141122 response_code : 00 payment_certificate : 977b3ad4c26a authorisation_id : 567536 currency_code : 978 card_number : 5132.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 : a.calvino06 order_id : 3105 customer_email : a.calvino06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3106" select * from cms_frontusers where identifiant = "f.miquet13" 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 = "3106" select * from cotisations where identifiant = "f.miquet13" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 103804 payment_means : VISA transmission_date : 20141122093804 payment_time : 104004 payment_date : 20141122 response_code : 00 payment_certificate : 5a0ba1a9081b authorisation_id : 816265 currency_code : 978 card_number : 4975.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 : f.miquet13 order_id : 3106 customer_email : f.miquet13@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 : 201505 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3104" select * from cms_frontusers where identifiant = "m.gabillard17" 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 = "3104" select * from cotisations where identifiant = "m.gabillard17" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 102804 payment_means : MASTERCARD transmission_date : 20141122092804 payment_time : 104211 payment_date : 20141122 response_code : 00 payment_certificate : 31eaff3220e8 authorisation_id : 415361 currency_code : 978 card_number : 5132.74 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.gabillard17 order_id : 3104 customer_email : m.gabillard17@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 : 201502 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3107" select * from cms_frontusers where identifiant = "l.mentzer26" 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 = "3107" select * from cotisations where identifiant = "l.mentzer26" and annee = "2015" and montant <> 0 select * from cotisations_commande where id = "3108" select * from cms_frontusers where identifiant = "m.coquelin06" 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 = "3108" select * from cotisations where identifiant = "m.coquelin06" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 104037 payment_means : MASTERCARD transmission_date : 20141122094037 payment_time : 104447 payment_date : 20141122 response_code : 00 payment_certificate : 143a45701707 authorisation_id : 548244 currency_code : 978 card_number : 5132.93 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.mentzer26 order_id : 3107 customer_email : l.mentzer26@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 : 201505 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 104305 payment_means : MASTERCARD transmission_date : 20141122094305 payment_time : 104506 payment_date : 20141122 response_code : 00 payment_certificate : c5b48dcb1f0a authorisation_id : 182974 currency_code : 978 card_number : 5131.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 : m.coquelin06 order_id : 3108 customer_email : m.coquelin06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201611 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3110" select * from cms_frontusers where identifiant = "m.navet07" 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 = "3110" select * from cotisations where identifiant = "l.poiret27" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 104918 payment_means : VISA transmission_date : 20141122094918 payment_time : 105035 payment_date : 20141122 response_code : 00 payment_certificate : ad3264adb59e authorisation_id : 716489 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 : m.navet07 order_id : 3110 customer_email : m.navet07@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 : 201501 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3109" select * from cms_frontusers where identifiant = "g.tartini06" 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 = "3109" select * from cotisations where identifiant = "g.tartini06" and annee = "2014" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 104335 payment_means : VISA transmission_date : 20141122094335 payment_time : 105416 payment_date : 20141122 response_code : 00 payment_certificate : cc7d438581cf authorisation_id : 0443 currency_code : 978 card_number : 4978.20 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.tartini06 order_id : 3109 customer_email : g.tartini06@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 = "3103" select * from cms_frontusers where identifiant = "m.renault02" select * from cotisations_commande where id = "3113" select * from cms_frontusers where identifiant = "g.tartini06" 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 = "3113" 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 = "3103" select * from cotisations where identifiant = "g.tartini06" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "m.renault02" and annee = "2015" and montant <> 0 code : 0 code : 0 error : error : merchant_id : 077566202600019 merchant_id : 077566202600019 merchant_country : fr merchant_country : fr amount : 8000 amount : 4000 transaction_id : 102500 transaction_id : 105623 payment_means : MASTERCARD payment_means : VISA transmission_date : 20141122092500 transmission_date : 20141122095623 payment_time : 105734 payment_time : 105801 payment_date : 20141122 payment_date : 20141122 response_code : 00 response_code : 00 payment_certificate : 3000e99e1456 payment_certificate : dcf9d07e5778 authorisation_id : 242306 authorisation_id : 913480 currency_code : 978 currency_code : 978 card_number : 5131.60 card_number : 4978.20 cvv_flag : 1 cvv_flag : 1 cvv_response_code : ?? cvv_response_code : ?? bank_response_code : 00 bank_response_code : 00 complementary_code : 00 complementary_code : 00 complementary_info : complementary_info : return_context : return_context : caddie : caddie : receipt_complement : receipt_complement : merchant_language : fr merchant_language : fr language : fr language : fr customer_id : m.renault02 customer_id : g.tartini06 order_id : 3103 order_id : 3113 customer_email : m.renault02@compagnons-du-devoir.fr customer_email : g.tartini06@compagnons-du-devoir.fr customer_ip_address : customer_ip_address : capture_day : 0 capture_day : 0 capture_mode : AUTHOR_CAPTURE capture_mode : AUTHOR_CAPTURE data : data : order_validity : 02 order_validity : 02 transaction_condition : 3D_SUCCESS transaction_condition : 3D_SUCCESS statement_reference : statement_reference : card_validity : 201603 card_validity : 201706 score_value : score_value : score_color : score_color : score_info : score_info : score_threshold : score_threshold : score_profile : score_profile : ------------------------------------------- ------------------------------------------- select * from cotisations_commande where id = "3114" select * from cms_frontusers where identifiant = "m.navet07" 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 = "3114" select * from cotisations where identifiant = "b.clement10" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 110013 payment_means : VISA transmission_date : 20141122100013 payment_time : 110202 payment_date : 20141122 response_code : 00 payment_certificate : 7f35f2004c88 authorisation_id : 776774 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 : m.navet07 order_id : 3114 customer_email : m.navet07@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 : 201501 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 : 110159 payment_means : VISA transmission_date : 20141122100159 payment_time : 110344 payment_date : 20141122 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4658.28 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 51 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.guelennoc05 order_id : 3115 customer_email : t.guelennoc05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201704 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3116" select * from cms_frontusers where identifiant = "g.dixneuf10" 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 = "3116" select * from cotisations where identifiant = "g.dixneuf10" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 110203 payment_means : VISA transmission_date : 20141122100203 payment_time : 110407 payment_date : 20141122 response_code : 00 payment_certificate : 5472264f5b35 authorisation_id : 262265 currency_code : 978 card_number : 4977.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 : g.dixneuf10 order_id : 3116 customer_email : g.dixneuf10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201606 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3115" select * from cms_frontusers where identifiant = "t.guelennoc05" 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 = "3115" select * from cotisations where identifiant = "t.guelennoc05" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 110400 payment_means : VISA transmission_date : 20141122100400 payment_time : 110700 payment_date : 20141122 response_code : 00 payment_certificate : 6cc6d47ee815 authorisation_id : 7143 currency_code : 978 card_number : 4978.72 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.guelennoc05 order_id : 3115 customer_email : t.guelennoc05@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 : 201501 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3118" select * from cms_frontusers where identifiant = "m.navet07" 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 = "3118" select * from cotisations where identifiant = "m.adam29" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 110609 payment_means : MASTERCARD transmission_date : 20141122100609 payment_time : 111037 payment_date : 20141122 response_code : 00 payment_certificate : 76286829d704 authorisation_id : 363157 currency_code : 978 card_number : 5131.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 : m.navet07 order_id : 3118 customer_email : m.navet07@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201704 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 111243 payment_means : VISA transmission_date : 20141122101243 payment_time : 111542 payment_date : 20141122 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4975.11 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.navet07 order_id : 3120 customer_email : m.navet07@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 : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3122" 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 = "3122" select * from cotisations where identifiant = "l.sbrava12" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114602 payment_means : VISA transmission_date : 20141122104602 payment_time : 114753 payment_date : 20141122 response_code : 00 payment_certificate : 8b30081c5484 authorisation_id : 161711 currency_code : 978 card_number : 4975.63 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.sbrava12 order_id : 3122 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 = "3124" select * from cms_frontusers where identifiant = "f.beauvisage15" 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 = "3124" select * from cotisations where identifiant = "f.beauvisage15" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 121902 payment_means : VISA transmission_date : 20141122111902 payment_time : 122057 payment_date : 20141122 response_code : 00 payment_certificate : 10e0300ff97f authorisation_id : 659091 currency_code : 978 card_number : 4974.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 : f.beauvisage15 order_id : 3124 customer_email : f.beauvisage15@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 : 201502 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3125" select * from cms_frontusers where identifiant = "j.demarle05" 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 = "3125" select * from cotisations where identifiant = "j.demarle05" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 125325 payment_means : MASTERCARD transmission_date : 20141122115325 payment_time : 125511 payment_date : 20141122 response_code : 00 payment_certificate : ebbf4d0233fb authorisation_id : 927805 currency_code : 978 card_number : 5131.88 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.demarle05 order_id : 3125 customer_email : j.demarle05@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 : 201509 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3127" select * from cms_frontusers where identifiant = "c.ledevendec03" 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 = "3127" select * from cotisations where identifiant = "c.ledevendec03" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 131913 payment_means : MASTERCARD transmission_date : 20141122121913 payment_time : 132109 payment_date : 20141122 response_code : 00 payment_certificate : 095e90670fcd authorisation_id : 241514 currency_code : 978 card_number : 5131.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 : c.ledevendec03 order_id : 3127 customer_email : c.ledevendec03@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 : 201501 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 : 131633 payment_means : MASTERCARD transmission_date : 20141122121633 payment_time : 132202 payment_date : 20141122 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5341.93 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.sabourault09 order_id : 3126 customer_email : v.sabourault09@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 : 201501 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3128" select * from cms_frontusers where identifiant = "a.roy13" 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 = "3128" select * from cotisations where identifiant = "ma.chotard02" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 132640 payment_means : VISA transmission_date : 20141122122640 payment_time : 133028 payment_date : 20141122 response_code : 00 payment_certificate : 831a4cada7b6 authorisation_id : 067636 currency_code : 978 card_number : 4970.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 : a.roy13 order_id : 3128 customer_email : a.roy13@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 : 201603 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3129" select * from cms_frontusers where identifiant = "s.beraud03" 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 = "3129" select * from cotisations where identifiant = "s.beraud03" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 133210 payment_means : MASTERCARD transmission_date : 20141122123210 payment_time : 133346 payment_date : 20141122 response_code : 00 payment_certificate : cca7bd29f82a authorisation_id : 434340 currency_code : 978 card_number : 5138.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 : s.beraud03 order_id : 3129 customer_email : s.beraud03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201604 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3132" select * from cms_frontusers where identifiant = "n.lecomte31" 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 = "3132" select * from cotisations where identifiant = "n.lecomte31" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 143909 payment_means : MASTERCARD transmission_date : 20141122133909 payment_time : 144321 payment_date : 20141122 response_code : 00 payment_certificate : ae444caeec4e authorisation_id : 162283 currency_code : 978 card_number : 5132.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 : n.lecomte31 order_id : 3132 customer_email : n.lecomte31@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 152940 payment_means : MASTERCARD transmission_date : 20141122142940 payment_time : 153537 payment_date : 20141122 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.66 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.galichet25 order_id : 3133 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_FAILURE statement_reference : card_validity : 201605 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3134" select * from cms_frontusers where identifiant = "p.mercier10" 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 = "3134" select * from cotisations where identifiant = "k.hurbain05" and annee = "2014" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 153633 payment_means : MASTERCARD transmission_date : 20141122143633 payment_time : 153805 payment_date : 20141122 response_code : 00 payment_certificate : 76baeba98ef0 authorisation_id : 703676 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 : p.mercier10 order_id : 3134 customer_email : p.mercier10@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 = "3135" select * from cms_frontusers where identifiant = "l.haeringer25" 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 = "3135" select * from cotisations where identifiant = "k.courand18" and annee = "2014" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 172055 payment_means : MASTERCARD transmission_date : 20141122162055 payment_time : 172210 payment_date : 20141122 response_code : 00 payment_certificate : e5e4cee28230 authorisation_id : 921106 currency_code : 978 card_number : 5131.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 : l.haeringer25 order_id : 3135 customer_email : l.haeringer25@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 : 201504 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 : 174510 payment_means : MASTERCARD transmission_date : 20141122164510 payment_time : 175215 payment_date : 20141122 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.27 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.vuidel10 order_id : 3136 customer_email : j.vuidel10@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 : 201505 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3138" select * from cms_frontusers where identifiant = "d.audureau10" 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 = "3138" select * from cotisations where identifiant = "d.audureau10" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185307 payment_means : VISA transmission_date : 20141122175307 payment_time : 185441 payment_date : 20141122 response_code : 00 payment_certificate : 4d2719684673 authorisation_id : 681331 currency_code : 978 card_number : 4975.41 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.audureau10 order_id : 3138 customer_email : d.audureau10@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 : 8000 transaction_id : 222503 payment_means : VISA transmission_date : 20141122212503 payment_time : 222939 payment_date : 20141122 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.86 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.menzel22 order_id : 3140 customer_email : n.menzel22@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 : 201606 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3140" select * from cms_frontusers where identifiant = "n.menzel22" 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 = "3140" select * from cotisations where identifiant = "n.menzel22" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 223952 payment_means : MASTERCARD transmission_date : 20141122213952 payment_time : 224150 payment_date : 20141122 response_code : 00 payment_certificate : f036e98cdfac authorisation_id : 448031 currency_code : 978 card_number : 5100.79 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.menzel22 order_id : 3140 customer_email : n.menzel22@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 : 201505 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------