select * from cotisations_commande where id = "10750" select * from cms_frontusers where identifiant = "c.guyard17" 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 = "10750" select * from cotisations where identifiant = "l.bonneau16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 070720 payment_means : VISA transmission_date : 20151214060720 payment_time : 070839 payment_date : 20151214 response_code : 00 payment_certificate : 9fcbe66a9062 authorisation_id : 227754 currency_code : 978 card_number : 4975.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 : c.guyard17 order_id : 10750 customer_email : c.guyard17@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 = "10751" select * from cms_frontusers where identifiant = "jg.joly13" 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 = "10751" select * from cotisations where identifiant = "v.cussonneau20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 073423 payment_means : VISA transmission_date : 20151214063423 payment_time : 073734 payment_date : 20151214 response_code : 00 payment_certificate : 36bd98618b56 authorisation_id : 150447 currency_code : 978 card_number : 4978.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 : jg.joly13 order_id : 10751 customer_email : jg.joly13@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 : 080612 payment_means : VISA transmission_date : 20151214070612 payment_time : 081128 payment_date : 20151214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4972.52 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.gruet21 order_id : 10752 customer_email : b.gruet21@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 : 8000 transaction_id : 081138 payment_means : VISA transmission_date : 20151214071138 payment_time : 081607 payment_date : 20151214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4972.52 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.gruet21 order_id : 10752 customer_email : b.gruet21@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 = "10752" select * from cms_frontusers where identifiant = "b.gruet21" 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 = "10752" select * from cotisations where identifiant = "b.gruet21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 081616 payment_means : VISA transmission_date : 20151214071616 payment_time : 081826 payment_date : 20151214 response_code : 00 payment_certificate : 97226b871fd1 authorisation_id : 834515 currency_code : 978 card_number : 4533.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 : b.gruet21 order_id : 10752 customer_email : b.gruet21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201605 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10753" select * from cms_frontusers where identifiant = "a.sanson19" 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 = "10753" select * from cotisations where identifiant = "a.sanson19" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 084149 payment_means : VISA transmission_date : 20151214074149 payment_time : 084303 payment_date : 20151214 response_code : 00 payment_certificate : 108f48a96fee authorisation_id : 203474 currency_code : 978 card_number : 4970.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 : a.sanson19 order_id : 10753 customer_email : a.sanson19@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 : 085939 payment_means : VISA transmission_date : 20151214075939 payment_time : 090634 payment_date : 20151214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4976.09 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 : jp.conraud03 order_id : 10754 customer_email : jp.conraud03@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 = "10755" select * from cms_frontusers where identifiant = "f.fortier07" 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 = "10755" select * from cotisations where identifiant = "f.fortier07" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 100924 payment_means : MASTERCARD transmission_date : 20151214090924 payment_time : 101126 payment_date : 20151214 response_code : 00 payment_certificate : 21f3da067e21 authorisation_id : 565673 currency_code : 978 card_number : 5131.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 : f.fortier07 order_id : 10755 customer_email : f.fortier07@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 = "10756" select * from cms_frontusers where identifiant = "p.dufils08" 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 = "10756" select * from cotisations where identifiant = "p.dufils08" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 103719 payment_means : VISA transmission_date : 20151214093719 payment_time : 103941 payment_date : 20151214 response_code : 00 payment_certificate : a54a37fec359 authorisation_id : 238612 currency_code : 978 card_number : 4975.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 : p.dufils08 order_id : 10756 customer_email : p.dufils08@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 = "10757" select * from cms_frontusers where identifiant = "jm.aupee28" 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 = "10757" select * from cotisations where identifiant = "j.aube25" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 104513 payment_means : VISA transmission_date : 20151214094513 payment_time : 104639 payment_date : 20151214 response_code : 00 payment_certificate : 5f9db6ffc426 authorisation_id : 319005 currency_code : 978 card_number : 4978.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 : jm.aupee28 order_id : 10757 customer_email : jm.aupee28@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 = "10758" select * from cms_frontusers where identifiant = "gs.fabre03" 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 = "10758" select * from cotisations where identifiant = "gs.fabre03" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 110950 payment_means : VISA transmission_date : 20151214100950 payment_time : 111107 payment_date : 20151214 response_code : 00 payment_certificate : a50cd5df16a8 authorisation_id : 541223 currency_code : 978 card_number : 4970.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 : gs.fabre03 order_id : 10758 customer_email : gs.fabre03@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 = "10759" select * from cms_frontusers where identifiant = "j.rousseau18" 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 = "10759" select * from cotisations where identifiant = "j.rousseau18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 112741 payment_means : CB transmission_date : 20151214102741 payment_time : 112854 payment_date : 20151214 response_code : 00 payment_certificate : 6b5794e62e65 authorisation_id : 349537 currency_code : 978 card_number : 4970.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 : j.rousseau18 order_id : 10759 customer_email : j.rousseau18@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_NOTENROLLED statement_reference : card_validity : 201701 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10760" select * from cms_frontusers where identifiant = "j.rousseau18" 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 = "10760" select * from cotisations where identifiant = "f.merlet08" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 113037 payment_means : CB transmission_date : 20151214103037 payment_time : 113141 payment_date : 20151214 response_code : 00 payment_certificate : 2657aed5b4d0 authorisation_id : 981644 currency_code : 978 card_number : 4970.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 : j.rousseau18 order_id : 10760 customer_email : j.rousseau18@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_ERROR statement_reference : card_validity : 201701 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10761" select * from cms_frontusers where identifiant = "j.rousseau18" 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 = "10761" select * from cotisations where identifiant = "j.choiselle10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 113248 payment_means : CB transmission_date : 20151214103248 payment_time : 113337 payment_date : 20151214 response_code : 00 payment_certificate : 58c099ec1112 authorisation_id : 519335 currency_code : 978 card_number : 4970.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 : j.rousseau18 order_id : 10761 customer_email : j.rousseau18@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_NOTENROLLED statement_reference : card_validity : 201701 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10762" select * from cms_frontusers where identifiant = "j.rousseau18" 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 = "10762" select * from cotisations where identifiant = "m.tremblais12" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 113427 payment_means : VISA transmission_date : 20151214103427 payment_time : 113552 payment_date : 20151214 response_code : 00 payment_certificate : 8a2b6468841c authorisation_id : 406419 currency_code : 978 card_number : 4970.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 : j.rousseau18 order_id : 10762 customer_email : j.rousseau18@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 = "10764" select * from cms_frontusers where identifiant = "e.fant18" 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 = "10764" select * from cotisations where identifiant = "e.fant18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 120228 payment_means : VISA transmission_date : 20151214110228 payment_time : 120520 payment_date : 20151214 response_code : 00 payment_certificate : 0ad9715a5252 authorisation_id : 567748 currency_code : 978 card_number : 4977.01 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.fant18 order_id : 10764 customer_email : e.fant18@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 = "10765" select * from cms_frontusers where identifiant = "n.beaussier25" 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 = "10765" select * from cotisations where identifiant = "n.beaussier25" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 120519 payment_means : MASTERCARD transmission_date : 20151214110519 payment_time : 120832 payment_date : 20151214 response_code : 00 payment_certificate : d14cd68394c4 authorisation_id : 472135 currency_code : 978 card_number : 5132.83 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.beaussier25 order_id : 10765 customer_email : n.beaussier25@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 : 8000 transaction_id : 132035 payment_means : VISA transmission_date : 20151214122035 payment_time : 132203 payment_date : 20151214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.16 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 : r.drouet10 order_id : 10766 customer_email : r.drouet10@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 : 201703 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10766" select * from cms_frontusers where identifiant = "r.drouet10" 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 = "10766" select * from cotisations where identifiant = "r.drouet10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 132211 payment_means : VISA transmission_date : 20151214122211 payment_time : 140452 payment_date : 20151214 response_code : 00 payment_certificate : ccd3799c4e10 authorisation_id : 419964 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 : r.drouet10 order_id : 10766 customer_email : r.drouet10@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 150257 payment_means : MASTERCARD transmission_date : 20151214140257 payment_time : 150816 payment_date : 20151214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.61 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.delale28 order_id : 10767 customer_email : a.delale28@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 = "10768" select * from cms_frontusers where identifiant = "f.lequellec12" 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 = "10768" select * from cotisations where identifiant = "f.lequellec12" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 151828 payment_means : VISA transmission_date : 20151214141828 payment_time : 151958 payment_date : 20151214 response_code : 00 payment_certificate : c6849e20501a authorisation_id : 235514 currency_code : 978 card_number : 4975.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 : f.lequellec12 order_id : 10768 customer_email : f.lequellec12@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 = "10769" select * from cms_frontusers where identifiant = "f.choletais05" 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 = "10769" select * from cotisations where identifiant = "y.richard01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 153529 payment_means : VISA transmission_date : 20151214143529 payment_time : 153630 payment_date : 20151214 response_code : 00 payment_certificate : 668808dbc2b9 authorisation_id : 545983 currency_code : 978 card_number : 4533.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 : f.choletais05 order_id : 10769 customer_email : f.choletais05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201601 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10770" select * from cms_frontusers where identifiant = "a.fourmet17" 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 = "10770" select * from cotisations where identifiant = "a.fourmet17" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 164253 payment_means : CB transmission_date : 20151214154253 payment_time : 164333 payment_date : 20151214 response_code : 00 payment_certificate : 8c0fab6fe17f authorisation_id : 524250 currency_code : 978 card_number : 5136.05 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.fourmet17 order_id : 10770 customer_email : a.fourmet17@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_NOTENROLLED statement_reference : card_validity : 201703 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 : 172012 payment_means : MASTERCARD transmission_date : 20151214162012 payment_time : 172108 payment_date : 20151214 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.21 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 : j.boulic10 order_id : 10771 customer_email : j.boulic10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_ATTEMPT statement_reference : card_validity : 201701 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10771" select * from cms_frontusers where identifiant = "j.boulic10" 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 = "10771" select * from cotisations where identifiant = "j.boulic10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 172126 payment_means : MASTERCARD transmission_date : 20151214162126 payment_time : 172238 payment_date : 20151214 response_code : 00 payment_certificate : 6845a749bf47 authorisation_id : 609256 currency_code : 978 card_number : 5137.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 : j.boulic10 order_id : 10771 customer_email : j.boulic10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_ATTEMPT statement_reference : card_validity : 201705 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10772" select * from cms_frontusers where identifiant = "m.jatczak05" 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 = "10772" select * from cotisations where identifiant = "m.jatczak05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 175356 payment_means : MASTERCARD transmission_date : 20151214165356 payment_time : 180513 payment_date : 20151214 response_code : 00 payment_certificate : e78286909329 authorisation_id : 401208 currency_code : 978 card_number : 5132.98 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.jatczak05 order_id : 10772 customer_email : m.jatczak05@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 = "10773" select * from cms_frontusers where identifiant = "d.coeur05" 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 = "10773" select * from cotisations where identifiant = "d.coeur05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181409 payment_means : VISA transmission_date : 20151214171409 payment_time : 181547 payment_date : 20151214 response_code : 00 payment_certificate : 3c235731d189 authorisation_id : 502851 currency_code : 978 card_number : 4970.98 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.coeur05 order_id : 10773 customer_email : d.coeur05@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 = "10775" select * from cms_frontusers where identifiant = "n.siegfried26" 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 = "10775" select * from cotisations where identifiant = "n.siegfried26" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181634 payment_means : VISA transmission_date : 20151214171634 payment_time : 181845 payment_date : 20151214 response_code : 00 payment_certificate : 3338fca2632e authorisation_id : 622556 currency_code : 978 card_number : 4972.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 : n.siegfried26 order_id : 10775 customer_email : n.siegfried26@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 = "10774" select * from cms_frontusers where identifiant = "s.charrier21" 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 = "10774" select * from cotisations where identifiant = "s.charrier21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181553 payment_means : MASTERCARD transmission_date : 20151214171553 payment_time : 181903 payment_date : 20151214 response_code : 00 payment_certificate : a484861aca11 authorisation_id : 545606 currency_code : 978 card_number : 5131.56 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.charrier21 order_id : 10774 customer_email : s.charrier21@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 = "10777" select * from cms_frontusers where identifiant = "m.bauer02" 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 = "10777" select * from cotisations where identifiant = "m.bauer02" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 183513 payment_means : VISA transmission_date : 20151214173513 payment_time : 183705 payment_date : 20151214 response_code : 00 payment_certificate : 7d413e2e55ec authorisation_id : 967801 currency_code : 978 card_number : 4974.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 : m.bauer02 order_id : 10777 customer_email : m.bauer02@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201602 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183228 payment_means : MASTERCARD transmission_date : 20151214173228 payment_time : 183830 payment_date : 20151214 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 : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.chartiezix01 order_id : 10776 customer_email : b.chartiezix01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201705 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185814 payment_means : VISA transmission_date : 20151214175814 payment_time : 190000 payment_date : 20151214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4561.56 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.gouret14 order_id : 10778 customer_email : c.gouret14@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 : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10780" select * from cms_frontusers where identifiant = "l.fournier13" 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 = "10780" select * from cotisations where identifiant = "l.fournier13" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 190747 payment_means : MASTERCARD transmission_date : 20151214180747 payment_time : 190956 payment_date : 20151214 response_code : 00 payment_certificate : deb65180e200 authorisation_id : 285394 currency_code : 978 card_number : 5137.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 : l.fournier13 order_id : 10780 customer_email : l.fournier13@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 : 4000 transaction_id : 194433 payment_means : VISA transmission_date : 20151214184433 payment_time : 194737 payment_date : 20151214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.16 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.duveau03 order_id : 10782 customer_email : c.duveau03@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 : 201710 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10783" select * from cms_frontusers where identifiant = "c.duveau03" 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 = "10783" select * from cotisations where identifiant = "a.berard24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 194824 payment_means : VISA transmission_date : 20151214184824 payment_time : 194938 payment_date : 20151214 response_code : 00 payment_certificate : c208b462071f authorisation_id : 835406 currency_code : 978 card_number : 4975.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 : c.duveau03 order_id : 10783 customer_email : c.duveau03@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 : 195902 payment_means : MASTERCARD transmission_date : 20151214185902 payment_time : 200455 payment_date : 20151214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.35 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.parnaud09 order_id : 10784 customer_email : m.parnaud09@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201705 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200032 payment_means : VISA transmission_date : 20151214190032 payment_time : 200638 payment_date : 20151214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.38 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 : r.vee31 order_id : 10786 customer_email : r.vee31@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 : ------------------------------------------- select * from cotisations_commande where id = "10784" select * from cms_frontusers where identifiant = "m.parnaud09" 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 = "10784" select * from cotisations where identifiant = "m.parnaud09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 200503 payment_means : MASTERCARD transmission_date : 20151214190503 payment_time : 200744 payment_date : 20151214 response_code : 00 payment_certificate : cedb77534ae2 authorisation_id : 952916 currency_code : 978 card_number : 5131.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 : m.parnaud09 order_id : 10784 customer_email : m.parnaud09@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 = "10787" select * from cms_frontusers where identifiant = "c.fredou12" 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 = "10787" select * from cotisations where identifiant = "c.fredou12" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200647 payment_means : MASTERCARD transmission_date : 20151214190647 payment_time : 201159 payment_date : 20151214 response_code : 00 payment_certificate : 0e750e849913 authorisation_id : 694060 currency_code : 978 card_number : 5132.44 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.fredou12 order_id : 10787 customer_email : c.fredou12@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201602 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10788" select * from cms_frontusers where identifiant = "n.martin30" 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 = "10788" select * from cotisations where identifiant = "n.martin30" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200926 payment_means : MASTERCARD transmission_date : 20151214190926 payment_time : 201200 payment_date : 20151214 response_code : 00 payment_certificate : 9dd5385bb9b6 authorisation_id : 976345 currency_code : 978 card_number : 5133.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 : n.martin30 order_id : 10788 customer_email : n.martin30@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201710 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10790" select * from cms_frontusers where identifiant = "j.guerisse10" 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 = "10790" select * from cotisations where identifiant = "j.guerisse10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201051 payment_means : VISA transmission_date : 20151214191051 payment_time : 201202 payment_date : 20151214 response_code : 00 payment_certificate : 1f252f4be946 authorisation_id : 877614 currency_code : 978 card_number : 4974.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 : j.guerisse10 order_id : 10790 customer_email : j.guerisse10@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 200002 payment_means : MASTERCARD transmission_date : 20151214190002 payment_time : 191303 payment_date : 20151214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : cvv_flag : cvv_response_code : bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jg.perez05 order_id : 10785 customer_email : jg.perez05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : SSL statement_reference : card_validity : score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10789" select * from cms_frontusers where identifiant = "r.cupillard05" 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 = "10789" select * from cotisations where identifiant = "r.cupillard05" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200956 payment_means : VISA transmission_date : 20151214190956 payment_time : 201347 payment_date : 20151214 response_code : 00 payment_certificate : a246f4d56230 authorisation_id : 755206 currency_code : 978 card_number : 4562.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 : r.cupillard05 order_id : 10789 customer_email : r.cupillard05@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 = "10793" select * from cms_frontusers where identifiant = "f.ebert19" 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 = "10793" select * from cotisations where identifiant = "f.ebert19" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201915 payment_means : CB transmission_date : 20151214191915 payment_time : 202101 payment_date : 20151214 response_code : 00 payment_certificate : bbbc8102f7c4 authorisation_id : 410939 currency_code : 978 card_number : 5136.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 : f.ebert19 order_id : 10793 customer_email : f.ebert19@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_NOTENROLLED statement_reference : card_validity : 201705 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10792" select * from cms_frontusers where identifiant = "jg.perez05" 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 = "10792" select * from cotisations where identifiant = "jg.perez05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201820 payment_means : MASTERCARD transmission_date : 20151214191820 payment_time : 202214 payment_date : 20151214 response_code : 00 payment_certificate : e155132c31db authorisation_id : 198264 currency_code : 978 card_number : 5132.78 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jg.perez05 order_id : 10792 customer_email : jg.perez05@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 = "10796" 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 = "10796" select * from cotisations where identifiant = "x.garles29" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 203007 payment_means : VISA transmission_date : 20151214193007 payment_time : 203158 payment_date : 20151214 response_code : 00 payment_certificate : 245def186ac6 authorisation_id : 073553 currency_code : 978 card_number : 4976.87 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : x.garles29 order_id : 10796 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 : 201601 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10797" select * from cms_frontusers where identifiant = "p.blanche17" 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 = "10797" select * from cotisations where identifiant = "p.blanche17" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203651 payment_means : MASTERCARD transmission_date : 20151214193651 payment_time : 203926 payment_date : 20151214 response_code : 00 payment_certificate : 78d837938ebc authorisation_id : 537461 currency_code : 978 card_number : 5341.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.blanche17 order_id : 10797 customer_email : p.blanche17@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 = "10798" select * from cms_frontusers where identifiant = "m.guerard12" 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 = "10798" select * from cotisations where identifiant = "m.guerard12" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 203829 payment_means : VISA transmission_date : 20151214193829 payment_time : 204015 payment_date : 20151214 response_code : 00 payment_certificate : 75f03593b363 authorisation_id : 294443 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 : m.guerard12 order_id : 10798 customer_email : m.guerard12@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 = "10800" select * from cms_frontusers where identifiant = "n.scherrer14" 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 = "10800" select * from cotisations where identifiant = "n.scherrer14" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 204350 payment_means : VISA transmission_date : 20151214194350 payment_time : 204523 payment_date : 20151214 response_code : 00 payment_certificate : c4818521fde6 authorisation_id : 962310 currency_code : 978 card_number : 4533.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 : n.scherrer14 order_id : 10800 customer_email : n.scherrer14@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 : 4000 transaction_id : 204652 payment_means : MASTERCARD transmission_date : 20151214194652 payment_time : 204820 payment_date : 20151214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.87 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.michon05 order_id : 10802 customer_email : c.michon05@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 : ------------------------------------------- select * from cotisations_commande where id = "10805" select * from cms_frontusers where identifiant = "a.gaudin04" 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 = "10805" select * from cotisations where identifiant = "a.gaudin04" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 205435 payment_means : MASTERCARD transmission_date : 20151214195435 payment_time : 205613 payment_date : 20151214 response_code : 00 payment_certificate : 14511e861a43 authorisation_id : 854536 currency_code : 978 card_number : 5131.01 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.gaudin04 order_id : 10805 customer_email : a.gaudin04@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 : 201610 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10806" select * from cms_frontusers where identifiant = "p.pagnon13" 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 = "10806" select * from cotisations where identifiant = "p.pagnon13" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 210009 payment_means : MASTERCARD transmission_date : 20151214200009 payment_time : 210202 payment_date : 20151214 response_code : 00 payment_certificate : 922fadba0bf6 authorisation_id : 129248 currency_code : 978 card_number : 5137.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 : p.pagnon13 order_id : 10806 customer_email : p.pagnon13@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 = "10809" select * from cms_frontusers where identifiant = "d.goujard17" 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 = "10809" select * from cotisations where identifiant = "m.thual20" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211531 payment_means : MASTERCARD transmission_date : 20151214201531 payment_time : 211802 payment_date : 20151214 response_code : 00 payment_certificate : edcb96f129df authorisation_id : 321524 currency_code : 978 card_number : 5131.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 : d.goujard17 order_id : 10809 customer_email : d.goujard17@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211427 payment_means : VISA transmission_date : 20151214201427 payment_time : 211945 payment_date : 20151214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.08 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.boutoille13 order_id : 10808 customer_email : j.boutoille13@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 : 201610 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10811" select * from cms_frontusers where identifiant = "d.goujard17" 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 = "10811" select * from cotisations where identifiant = "d.goujard17" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211834 payment_means : MASTERCARD transmission_date : 20151214201834 payment_time : 211945 payment_date : 20151214 response_code : 00 payment_certificate : ae5e6a60b0e8 authorisation_id : 599730 currency_code : 978 card_number : 5131.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 : d.goujard17 order_id : 10811 customer_email : d.goujard17@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 = "10813" select * from cms_frontusers where identifiant = "d.goujard17" select * from cotisations_commande where id = "10814" select * from cms_frontusers where identifiant = "m.hollinger21" 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 = "10814" 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 = "10813" select * from cotisations where identifiant = "m.hollinger21" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "m.thual20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 212157 payment_means : MASTERCARD transmission_date : 20151214202157 payment_time : 212349 payment_date : 20151214 response_code : 00 payment_certificate : 1dc1ba7a674e authorisation_id : 357375 currency_code : 978 card_number : 5131.64 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.hollinger21 order_id : 10814 customer_email : m.hollinger21@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 : 201607 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 212130 payment_means : MASTERCARD transmission_date : 20151214202130 payment_time : 212249 payment_date : 20151214 response_code : 00 payment_certificate : 24553561bd90 authorisation_id : 291851 currency_code : 978 card_number : 5131.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 : d.goujard17 order_id : 10813 customer_email : d.goujard17@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 = "10817" select * from cms_frontusers where identifiant = "el.marechal21" 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 = "10817" select * from cotisations where identifiant = "el.marechal21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 214300 payment_means : VISA transmission_date : 20151214204300 payment_time : 214409 payment_date : 20151214 response_code : 00 payment_certificate : 84ff7d13d289 authorisation_id : 260116 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 : el.marechal21 order_id : 10817 customer_email : el.marechal21@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 = "10815" select * from cms_frontusers where identifiant = "f.colas01" 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 = "10815" select * from cotisations where identifiant = "f.colas01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214236 payment_means : VISA transmission_date : 20151214204236 payment_time : 214417 payment_date : 20151214 response_code : 00 payment_certificate : 07acb1f4daa3 authorisation_id : 646524 currency_code : 978 card_number : 4533.91 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.colas01 order_id : 10815 customer_email : f.colas01@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 = "10820" select * from cms_frontusers where identifiant = "g.turi21" 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 = "10820" select * from cotisations where identifiant = "g.turi21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214358 payment_means : VISA transmission_date : 20151214204358 payment_time : 214607 payment_date : 20151214 response_code : 00 payment_certificate : 989e83c048f9 authorisation_id : 528517 currency_code : 978 card_number : 4975.26 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.turi21 order_id : 10820 customer_email : g.turi21@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 = "10819" select * from cms_frontusers where identifiant = "t.boulay25" 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 = "10819" select * from cotisations where identifiant = "j.gloriant26" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214344 payment_means : MASTERCARD transmission_date : 20151214204344 payment_time : 214622 payment_date : 20151214 response_code : 00 payment_certificate : c54e9d55c929 authorisation_id : 388309 currency_code : 978 card_number : 5137.75 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.boulay25 order_id : 10819 customer_email : t.boulay25@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 = "10822" select * from cms_frontusers where identifiant = "g.epp28" 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 = "10822" select * from cotisations where identifiant = "g.epp28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 214530 payment_means : VISA transmission_date : 20151214204530 payment_time : 214651 payment_date : 20151214 response_code : 00 payment_certificate : 7312f77aff7d authorisation_id : 491635 currency_code : 978 card_number : 4975.29 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.epp28 order_id : 10822 customer_email : g.epp28@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 = "10823" select * from cms_frontusers where identifiant = "m.fresil28" 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 = "10823" select * from cotisations where identifiant = "m.fresil28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 214821 payment_means : VISA transmission_date : 20151214204821 payment_time : 215105 payment_date : 20151214 response_code : 00 payment_certificate : 4275dd48086f authorisation_id : 061526 currency_code : 978 card_number : 4972.44 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.fresil28 order_id : 10823 customer_email : m.fresil28@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 = "10821" select * from cms_frontusers where identifiant = "v.jung15" 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 = "10821" select * from cotisations where identifiant = "v.jung15" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214403 payment_means : VISA transmission_date : 20151214204403 payment_time : 215250 payment_date : 20151214 response_code : 00 payment_certificate : 2aef11788b2b authorisation_id : 018403 currency_code : 978 card_number : 4977.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 : v.jung15 order_id : 10821 customer_email : v.jung15@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 205211 payment_means : VISA transmission_date : 20151214195211 payment_time : 215517 payment_date : 20151214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.53 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 : r.bonnefond06 order_id : 10804 customer_email : r.bonnefond06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10826" select * from cms_frontusers where identifiant = "t.alliot16" 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 = "10826" select * from cotisations where identifiant = "t.alliot16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 215458 payment_means : VISA transmission_date : 20151214205458 payment_time : 215714 payment_date : 20151214 response_code : 00 payment_certificate : c9b770f90b33 authorisation_id : 436670 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 : t.alliot16 order_id : 10826 customer_email : t.alliot16@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 215541 payment_means : VISA transmission_date : 20151214205541 payment_time : 220047 payment_date : 20151214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.53 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 : r.bonnefond06 order_id : 10827 customer_email : r.bonnefond06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10831" select * from cms_frontusers where identifiant = "t.franchon13" 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 = "10831" select * from cotisations where identifiant = "t.franchon13" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 220013 payment_means : VISA transmission_date : 20151214210013 payment_time : 220227 payment_date : 20151214 response_code : 00 payment_certificate : 426eaedb1e4d authorisation_id : 451075 currency_code : 978 card_number : 4562.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 : t.franchon13 order_id : 10831 customer_email : t.franchon13@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 = "10832" select * from cms_frontusers where identifiant = "r.bonnefond06" 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 = "10832" select * from cotisations where identifiant = "r.bonnefond06" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 220246 payment_means : VISA transmission_date : 20151214210246 payment_time : 220655 payment_date : 20151214 response_code : 00 payment_certificate : 926a891117d8 authorisation_id : 476141 currency_code : 978 card_number : 4970.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 : r.bonnefond06 order_id : 10832 customer_email : r.bonnefond06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 220309 payment_means : MASTERCARD transmission_date : 20151214210309 payment_time : 220958 payment_date : 20151214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.73 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.chataigner01 order_id : 10833 customer_email : a.chataigner01@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 : 4000 transaction_id : 221011 payment_means : MASTERCARD transmission_date : 20151214211011 payment_time : 221431 payment_date : 20151214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.73 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.chataigner01 order_id : 10833 customer_email : a.chataigner01@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 : 4000 transaction_id : 221835 payment_means : MASTERCARD transmission_date : 20151214211835 payment_time : 221953 payment_date : 20151214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.73 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.chataigner01 order_id : 10833 customer_email : a.chataigner01@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 = "10835" select * from cms_frontusers where identifiant = "j.boutoille13" 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 = "10835" select * from cotisations where identifiant = "j.boutoille13" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "j.boutoille13" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 222241 payment_means : VISA transmission_date : 20151214212241 payment_time : 222829 payment_date : 20151214 response_code : 00 payment_certificate : c9ea1e63b919 authorisation_id : 622552 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 : j.boutoille13 order_id : 10835 customer_email : j.boutoille13@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 : 201610 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10837" select * from cms_frontusers where identifiant = "d.fabien03" 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 = "10837" select * from cotisations where identifiant = "d.fabien03" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 223445 payment_means : MASTERCARD transmission_date : 20151214213445 payment_time : 223621 payment_date : 20151214 response_code : 00 payment_certificate : 0b4e4d67e4ea authorisation_id : 347155 currency_code : 978 card_number : 5131.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 : d.fabien03 order_id : 10837 customer_email : d.fabien03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201710 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10838" select * from cms_frontusers where identifiant = "t.pochet24" 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 = "10838" select * from cotisations where identifiant = "t.pochet24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 224643 payment_means : VISA transmission_date : 20151214214643 payment_time : 224852 payment_date : 20151214 response_code : 00 payment_certificate : 46c1e91eb650 authorisation_id : 488142 currency_code : 978 card_number : 4978.81 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.pochet24 order_id : 10838 customer_email : t.pochet24@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 : 4000 transaction_id : 234841 payment_means : VISA transmission_date : 20151214224841 payment_time : 235013 payment_date : 20151214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.13 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a1.chevalier05 order_id : 10840 customer_email : a1.chevalier05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------