Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 073223 payment_means : MASTERCARD transmission_date : 20160129063223 payment_time : 073402 payment_date : 20160129 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.22 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.jung23 order_id : 13291 customer_email : s.jung23@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 = "13291" select * from cms_frontusers where identifiant = "s.jung23" 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 = "13291" select * from cotisations where identifiant = "j.pernot06" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 073429 payment_means : MASTERCARD transmission_date : 20160129063429 payment_time : 073532 payment_date : 20160129 response_code : 00 payment_certificate : ce72d2faaf4b authorisation_id : 745229 currency_code : 978 card_number : 5132.22 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.jung23 order_id : 13291 customer_email : s.jung23@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 = "13292" select * from cms_frontusers where identifiant = "c.valente24" 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 = "13292" select * from cotisations where identifiant = "c.valente24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 084615 payment_means : CB transmission_date : 20160129074615 payment_time : 084648 payment_date : 20160129 response_code : 00 payment_certificate : 5c9cfb49490d authorisation_id : 068052 currency_code : 978 card_number : 4971.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 : c.valente24 order_id : 13292 customer_email : c.valente24@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 = "13293" select * from cms_frontusers where identifiant = "a.gury09" 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 = "13293" select * from cotisations where identifiant = "a.gury09" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "a.gury09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 090312 payment_means : MASTERCARD transmission_date : 20160129080312 payment_time : 090606 payment_date : 20160129 response_code : 00 payment_certificate : 2fb47c8d95af authorisation_id : 904164 currency_code : 978 card_number : 5136.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 : a.gury09 order_id : 13293 customer_email : a.gury09@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 = "13294" select * from cms_frontusers where identifiant = "jp.jusselme01" 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 = "13294" select * from cotisations where identifiant = "jp.jusselme01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 100210 payment_means : MASTERCARD transmission_date : 20160129090210 payment_time : 100412 payment_date : 20160129 response_code : 00 payment_certificate : 486d81500c2e authorisation_id : 542184 currency_code : 978 card_number : 5137.73 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jp.jusselme01 order_id : 13294 customer_email : jp.jusselme01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201603 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13295" select * from cms_frontusers where identifiant = "j.sablin16" 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 = "13295" select * from cotisations where identifiant = "j.sablin16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 101210 payment_means : VISA transmission_date : 20160129091210 payment_time : 101434 payment_date : 20160129 response_code : 00 payment_certificate : 8f57c6d3c488 authorisation_id : 603114 currency_code : 978 card_number : 4973.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 : j.sablin16 order_id : 13295 customer_email : j.sablin16@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 = "13297" select * from cms_frontusers where identifiant = "j.gaillard09" 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 = "13297" select * from cotisations where identifiant = "j.gaillard09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 133054 payment_means : VISA transmission_date : 20160129123054 payment_time : 133245 payment_date : 20160129 response_code : 00 payment_certificate : 0870db9addf4 authorisation_id : 890915 currency_code : 978 card_number : 4975.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.gaillard09 order_id : 13297 customer_email : j.gaillard09@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 = "13298" select * from cms_frontusers where identifiant = "pm.meillerand04" 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 = "13298" select * from cotisations where identifiant = "pm.meillerand04" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 135121 payment_means : MASTERCARD transmission_date : 20160129125121 payment_time : 135227 payment_date : 20160129 response_code : 00 payment_certificate : 80e8a665a20c authorisation_id : 224202 currency_code : 978 card_number : 5131.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 : pm.meillerand04 order_id : 13298 customer_email : pm.meillerand04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 140127 payment_means : CB transmission_date : 20160129130127 payment_time : 140218 payment_date : 20160129 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.chauveau21 order_id : 13299 customer_email : m.chauveau21@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 : 201901 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13300" select * from cms_frontusers where identifiant = "e.baraton07" 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 = "13300" select * from cotisations where identifiant = "e.baraton07" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 140215 payment_means : MASTERCARD transmission_date : 20160129130215 payment_time : 140412 payment_date : 20160129 response_code : 00 payment_certificate : ac5d26f4b0c2 authorisation_id : 514572 currency_code : 978 card_number : 5137.20 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.baraton07 order_id : 13300 customer_email : e.baraton07@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 140443 payment_means : CB transmission_date : 20160129130443 payment_time : 140540 payment_date : 20160129 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.19 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : q.ruellan17 order_id : 13301 customer_email : q.ruellan17@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 : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13299" select * from cms_frontusers where identifiant = "m.chauveau21" 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 = "13299" select * from cotisations where identifiant = "m.chauveau21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 140242 payment_means : VISA transmission_date : 20160129130242 payment_time : 140620 payment_date : 20160129 response_code : 00 payment_certificate : 2cda99fb77fb authorisation_id : 565530 currency_code : 978 card_number : 4978.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 : m.chauveau21 order_id : 13299 customer_email : m.chauveau21@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 = "13301" select * from cms_frontusers where identifiant = "q.ruellan17" 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 = "13301" select * from cotisations where identifiant = "q.ruellan17" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 140552 payment_means : CB transmission_date : 20160129130552 payment_time : 140639 payment_date : 20160129 response_code : 00 payment_certificate : 360a0ee309d8 authorisation_id : 433969 currency_code : 978 card_number : 4978.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 : q.ruellan17 order_id : 13301 customer_email : q.ruellan17@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 : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13302" select * from cms_frontusers where identifiant = "d.vonin28" 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 = "13302" select * from cotisations where identifiant = "d.vonin28" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 163034 payment_means : VISA transmission_date : 20160129153034 payment_time : 163139 payment_date : 20160129 response_code : 00 payment_certificate : 7a2a32856070 authorisation_id : 943494 currency_code : 978 card_number : 4974.28 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.vonin28 order_id : 13302 customer_email : d.vonin28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13303" select * from cms_frontusers where identifiant = "d.vonin28" 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 = "13303" select * from cotisations where identifiant = "d.vonin28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 163221 payment_means : VISA transmission_date : 20160129153221 payment_time : 163310 payment_date : 20160129 response_code : 00 payment_certificate : 3ac967cae431 authorisation_id : 589775 currency_code : 978 card_number : 4974.28 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.vonin28 order_id : 13303 customer_email : d.vonin28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13305" select * from cms_frontusers where identifiant = "s.jung23" 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 = "13305" select * from cotisations where identifiant = "a.gradt01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 164334 payment_means : MASTERCARD transmission_date : 20160129154334 payment_time : 164443 payment_date : 20160129 response_code : 00 payment_certificate : 0f5e9e25d50a authorisation_id : 953422 currency_code : 978 card_number : 5132.22 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.jung23 order_id : 13305 customer_email : s.jung23@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 = "13306" select * from cms_frontusers where identifiant = "n.borderieux21" 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 = "13306" select * from cotisations where identifiant = "d.colombier01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 170816 payment_means : VISA transmission_date : 20160129160816 payment_time : 171039 payment_date : 20160129 response_code : 00 payment_certificate : 86a55dc624f9 authorisation_id : 960222 currency_code : 978 card_number : 4973.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 : n.borderieux21 order_id : 13306 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13310" select * from cms_frontusers where identifiant = "n.borderieux21" 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 = "13310" select * from cotisations where identifiant = "s.court07" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 171506 payment_means : VISA transmission_date : 20160129161506 payment_time : 171612 payment_date : 20160129 response_code : 00 payment_certificate : 024cc21c5d8d authorisation_id : 612774 currency_code : 978 card_number : 4973.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 : n.borderieux21 order_id : 13310 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13311" select * from cms_frontusers where identifiant = "j.combalot09" 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 = "13311" select * from cotisations where identifiant = "j.combalot09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 171546 payment_means : VISA transmission_date : 20160129161546 payment_time : 171738 payment_date : 20160129 response_code : 00 payment_certificate : 52a745253ac8 authorisation_id : 084625 currency_code : 978 card_number : 4978.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 : j.combalot09 order_id : 13311 customer_email : j.combalot09@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 = "13309" select * from cms_frontusers where identifiant = "jy.lebeller04" 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 = "13309" select * from cotisations where identifiant = "jy.lebeller04" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 171404 payment_means : MASTERCARD transmission_date : 20160129161404 payment_time : 171808 payment_date : 20160129 response_code : 00 payment_certificate : 5e2d35c30150 authorisation_id : 394692 currency_code : 978 card_number : 5137.01 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jy.lebeller04 order_id : 13309 customer_email : jy.lebeller04@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 = "13312" select * from cms_frontusers where identifiant = "n.borderieux21" 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 = "13312" select * from cotisations where identifiant = "r.challancin12" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "r.challancin12" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 171807 payment_means : VISA transmission_date : 20160129161807 payment_time : 171954 payment_date : 20160129 response_code : 00 payment_certificate : 3cf87cac9b9d authorisation_id : 382363 currency_code : 978 card_number : 4973.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 : n.borderieux21 order_id : 13312 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13313" select * from cms_frontusers where identifiant = "n.borderieux21" 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 = "13313" select * from cotisations where identifiant = "d.chapeland23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 172052 payment_means : VISA transmission_date : 20160129162052 payment_time : 172213 payment_date : 20160129 response_code : 00 payment_certificate : 3bf86fc9a9d6 authorisation_id : 913483 currency_code : 978 card_number : 4973.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 : n.borderieux21 order_id : 13313 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13315" select * from cms_frontusers where identifiant = "n.borderieux21" 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 = "13315" select * from cotisations where identifiant = "g.guillemard21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 172310 payment_means : VISA transmission_date : 20160129162310 payment_time : 172405 payment_date : 20160129 response_code : 00 payment_certificate : 135b0e9fd3b1 authorisation_id : 364314 currency_code : 978 card_number : 4973.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 : n.borderieux21 order_id : 13315 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 172636 payment_means : VISA transmission_date : 20160129162636 payment_time : 172733 payment_date : 20160129 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13316 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 172844 payment_means : VISA transmission_date : 20160129162844 payment_time : 172926 payment_date : 20160129 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13317 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 173023 payment_means : VISA transmission_date : 20160129163023 payment_time : 173059 payment_date : 20160129 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13318 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 173142 payment_means : VISA transmission_date : 20160129163142 payment_time : 173328 payment_date : 20160129 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13319 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 173404 payment_means : VISA transmission_date : 20160129163404 payment_time : 173438 payment_date : 20160129 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13320 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 173624 payment_means : VISA transmission_date : 20160129163624 payment_time : 173701 payment_date : 20160129 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13321 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 173748 payment_means : VISA transmission_date : 20160129163748 payment_time : 173843 payment_date : 20160129 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13322 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13324" select * from cms_frontusers where identifiant = "m.cochard10" 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 = "13324" select * from cotisations where identifiant = "p.sorin21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 174119 payment_means : VISA transmission_date : 20160129164119 payment_time : 174223 payment_date : 20160129 response_code : 00 payment_certificate : 7d4c32ce4719 authorisation_id : 052756 currency_code : 978 card_number : 4950.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 : m.cochard10 order_id : 13324 customer_email : m.cochard10@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 : 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 : 174803 payment_means : VISA transmission_date : 20160129164803 payment_time : 174857 payment_date : 20160129 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13327 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 175120 payment_means : CB transmission_date : 20160129165120 payment_time : 175149 payment_date : 20160129 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13328 customer_email : n.borderieux21@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 : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 175203 payment_means : VISA transmission_date : 20160129165203 payment_time : 175245 payment_date : 20160129 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13328 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 175424 payment_means : VISA transmission_date : 20160129165424 payment_time : 175508 payment_date : 20160129 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13329 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 175618 payment_means : VISA transmission_date : 20160129165618 payment_time : 175718 payment_date : 20160129 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13330 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 180227 payment_means : VISA transmission_date : 20160129170227 payment_time : 180345 payment_date : 20160129 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13332 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 180422 payment_means : VISA transmission_date : 20160129170422 payment_time : 180508 payment_date : 20160129 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13333 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 180554 payment_means : VISA transmission_date : 20160129170554 payment_time : 180636 payment_date : 20160129 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13334 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13335" select * from cms_frontusers where identifiant = "b.rochette25" 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 = "13335" select * from cotisations where identifiant = "b.rochette25" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "b.rochette25" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 180713 payment_means : VISA transmission_date : 20160129170713 payment_time : 181000 payment_date : 20160129 response_code : 00 payment_certificate : ad836c923152 authorisation_id : 837052 currency_code : 978 card_number : 4570.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 : b.rochette25 order_id : 13335 customer_email : b.rochette25@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 = "13336" select * from cms_frontusers where identifiant = "jb.chalmey01" 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 = "13336" select * from cotisations where identifiant = "m.maio04" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 180923 payment_means : CB transmission_date : 20160129170923 payment_time : 181055 payment_date : 20160129 response_code : 00 payment_certificate : 5caa0b6a3aeb authorisation_id : 865212 currency_code : 978 card_number : 4976.04 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jb.chalmey01 order_id : 13336 customer_email : jb.chalmey01@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 : 201606 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13337" select * from cms_frontusers where identifiant = "m.sanchez20" 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 = "13337" select * from cotisations where identifiant = "m.sanchez20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 184130 payment_means : MASTERCARD transmission_date : 20160129174130 payment_time : 184402 payment_date : 20160129 response_code : 00 payment_certificate : a9b074ceb051 authorisation_id : 265605 currency_code : 978 card_number : 5132.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 : m.sanchez20 order_id : 13337 customer_email : m.sanchez20@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 = "13338" select * from cms_frontusers where identifiant = "j.pouly09" 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 = "13338" select * from cotisations where identifiant = "j.pouly09" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "j.pouly09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 184158 payment_means : VISA transmission_date : 20160129174158 payment_time : 184830 payment_date : 20160129 response_code : 00 payment_certificate : ebbe943d230c authorisation_id : 029644 currency_code : 978 card_number : 4659.18 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.pouly09 order_id : 13338 customer_email : j.pouly09@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 = "13339" select * from cms_frontusers where identifiant = "x.arnold03" 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 = "13339" select * from cotisations where identifiant = "x.arnold03" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185042 payment_means : MASTERCARD transmission_date : 20160129175042 payment_time : 185243 payment_date : 20160129 response_code : 00 payment_certificate : 5d1cc2749fe4 authorisation_id : 383064 currency_code : 978 card_number : 5132.47 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : x.arnold03 order_id : 13339 customer_email : x.arnold03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201703 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13342" select * from cms_frontusers where identifiant = "c.soulard15" 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 = "13342" select * from cotisations where identifiant = "c.soulard15" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200251 payment_means : MASTERCARD transmission_date : 20160129190251 payment_time : 200702 payment_date : 20160129 response_code : 00 payment_certificate : df68b01e05dc authorisation_id : 808743 currency_code : 978 card_number : 5137.17 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.soulard15 order_id : 13342 customer_email : c.soulard15@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 = "13343" select * from cms_frontusers where identifiant = "m.guenantin29" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "13343" select * from cotisations where identifiant = "m.guenantin29" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203315 payment_means : MASTERCARD transmission_date : 20160129193315 payment_time : 203557 payment_date : 20160129 response_code : 00 payment_certificate : d373fe968005 authorisation_id : 461070 currency_code : 978 card_number : 5138.34 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.guenantin29 order_id : 13343 customer_email : m.guenantin29@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13344" select * from cms_frontusers where identifiant = "t.rossetto06" 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 = "13344" select * from cotisations where identifiant = "t.rossetto06" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203350 payment_means : VISA transmission_date : 20160129193350 payment_time : 203817 payment_date : 20160129 response_code : 00 payment_certificate : 9d467f6f8397 authorisation_id : 517565 currency_code : 978 card_number : 4974.33 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.rossetto06 order_id : 13344 customer_email : t.rossetto06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203710 payment_means : VISA transmission_date : 20160129193710 payment_time : 204302 payment_date : 20160129 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.17 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.guenantin29 order_id : 13345 customer_email : m.guenantin29@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13346" select * from cms_frontusers where identifiant = "p.gaubert01" 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 = "13346" select * from cotisations where identifiant = "p.gaubert01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 214214 payment_means : MASTERCARD transmission_date : 20160129204214 payment_time : 214451 payment_date : 20160129 response_code : 00 payment_certificate : 86c9415c1a75 authorisation_id : 634620 currency_code : 978 card_number : 5136.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 : p.gaubert01 order_id : 13346 customer_email : p.gaubert01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13348" select * from cms_frontusers where identifiant = "e.romieu05" 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 = "13348" select * from cotisations where identifiant = "e.romieu05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214615 payment_means : MASTERCARD transmission_date : 20160129204615 payment_time : 214804 payment_date : 20160129 response_code : 00 payment_certificate : 1adb69c3226f authorisation_id : 626313 currency_code : 978 card_number : 5137.38 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.romieu05 order_id : 13348 customer_email : e.romieu05@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 = "13349" select * from cms_frontusers where identifiant = "c.catherin24" 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 = "13349" select * from cotisations where identifiant = "c.catherin24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 215218 payment_means : MASTERCARD transmission_date : 20160129205218 payment_time : 215416 payment_date : 20160129 response_code : 00 payment_certificate : 2cb34ab42cf5 authorisation_id : 151901 currency_code : 978 card_number : 5135.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 : c.catherin24 order_id : 13349 customer_email : c.catherin24@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 215323 payment_means : MASTERCARD transmission_date : 20160129205323 payment_time : 215500 payment_date : 20160129 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5341.80 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.blond06 order_id : 13350 customer_email : s.blond06@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 = "13351" select * from cms_frontusers where identifiant = "b.dias30" 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 = "13351" select * from cotisations where identifiant = "b.dias30" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 215616 payment_means : MASTERCARD transmission_date : 20160129205616 payment_time : 215828 payment_date : 20160129 response_code : 00 payment_certificate : 6ed756ece955 authorisation_id : 997967 currency_code : 978 card_number : 5131.17 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.dias30 order_id : 13351 customer_email : b.dias30@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 = "13352" select * from cms_frontusers where identifiant = "a.laurent04" 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 = "13352" select * from cotisations where identifiant = "a.laurent04" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 233903 payment_means : MASTERCARD transmission_date : 20160129223903 payment_time : 234347 payment_date : 20160129 response_code : 00 payment_certificate : bd00445393c2 authorisation_id : 098562 currency_code : 978 card_number : 5131.49 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.laurent04 order_id : 13352 customer_email : a.laurent04@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 = "13353" select * from cms_frontusers where identifiant = "z.mouhot25" 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 = "13353" select * from cotisations where identifiant = "y.cantener31" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "y.cantener31" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 235006 payment_means : MASTERCARD transmission_date : 20160129225006 payment_time : 235131 payment_date : 20160129 response_code : 00 payment_certificate : 0e6f42f697f3 authorisation_id : 153656 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 : z.mouhot25 order_id : 13353 customer_email : z.mouhot25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201603 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------