select * from cotisations_commande where id = "12030" select * from cms_frontusers where identifiant = "l.tropee11" 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 = "12030" select * from cotisations where identifiant = "l.tropee11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 005000 payment_means : MASTERCARD transmission_date : 20160103235000 payment_time : 005210 payment_date : 20160104 response_code : 00 payment_certificate : 8338b0ff1e2b authorisation_id : 760376 currency_code : 978 card_number : 5131.50 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.tropee11 order_id : 12030 customer_email : l.tropee11@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 = "12031" select * from cms_frontusers where identifiant = "p.lossouarn03" 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 = "12031" select * from cotisations where identifiant = "p.lossouarn03" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 014005 payment_means : MASTERCARD transmission_date : 20160104004005 payment_time : 014140 payment_date : 20160104 response_code : 00 payment_certificate : d42da074993b authorisation_id : 577811 currency_code : 978 card_number : 5132.19 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.lossouarn03 order_id : 12031 customer_email : p.lossouarn03@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 = "12033" select * from cms_frontusers where identifiant = "y.depuy09" 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 = "12033" select * from cotisations where identifiant = "y.depuy09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 9000 transaction_id : 053028 payment_means : VISA transmission_date : 20160104043028 payment_time : 053129 payment_date : 20160104 response_code : 00 payment_certificate : 374d4979e6dc authorisation_id : 427365 currency_code : 978 card_number : 4978.11 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : y.depuy09 order_id : 12033 customer_email : y.depuy09@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 = "12034" select * from cms_frontusers where identifiant = "m.mallier28" 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 = "12034" select * from cotisations where identifiant = "m.mallier28" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "m.mallier28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 081916 payment_means : VISA transmission_date : 20160104071916 payment_time : 082053 payment_date : 20160104 response_code : 00 payment_certificate : d2569f5d22e5 authorisation_id : 350355 currency_code : 978 card_number : 4974.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 : m.mallier28 order_id : 12034 customer_email : m.mallier28@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 = "12035" select * from cms_frontusers where identifiant = "m.joannard18" 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 = "12035" select * from cotisations where identifiant = "m.joannard18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 082624 payment_means : MASTERCARD transmission_date : 20160104072624 payment_time : 082821 payment_date : 20160104 response_code : 00 payment_certificate : 0f37535cb677 authorisation_id : 302671 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 : m.joannard18 order_id : 12035 customer_email : m.joannard18@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 = "12036" select * from cms_frontusers where identifiant = "c.kouyoumdjian07" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "12036" select * from cotisations where identifiant = "c.kouyoumdjian07" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 090717 payment_means : VISA transmission_date : 20160104080717 payment_time : 090903 payment_date : 20160104 response_code : 00 payment_certificate : a453550e1318 authorisation_id : 969562 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 : c.kouyoumdjian07 order_id : 12036 customer_email : c.kouyoumdjian07@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12038" select * from cms_frontusers where identifiant = "t.hemery21" 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 = "12038" select * from cotisations where identifiant = "t.hemery21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 094321 payment_means : VISA transmission_date : 20160104084321 payment_time : 094453 payment_date : 20160104 response_code : 00 payment_certificate : fed8a892f488 authorisation_id : 155242 currency_code : 978 card_number : 4970.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 : t.hemery21 order_id : 12038 customer_email : t.hemery21@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 = "12041" select * from cms_frontusers where identifiant = "e.sergent01" 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 = "12041" select * from cotisations where identifiant = "e.sergent01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 103756 payment_means : VISA transmission_date : 20160104093756 payment_time : 103956 payment_date : 20160104 response_code : 00 payment_certificate : 661232ec934d authorisation_id : 574352 currency_code : 978 card_number : 4977.74 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.sergent01 order_id : 12041 customer_email : e.sergent01@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 = "12042" select * from cms_frontusers where identifiant = "s.meunier29" 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 = "12042" select * from cotisations where identifiant = "s.meunier29" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 110721 payment_means : MASTERCARD transmission_date : 20160104100721 payment_time : 110928 payment_date : 20160104 response_code : 00 payment_certificate : c13da1cf847a authorisation_id : 254913 currency_code : 978 card_number : 5131.74 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.meunier29 order_id : 12042 customer_email : s.meunier29@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 : 120125 payment_means : MASTERCARD transmission_date : 20160104110125 payment_time : 120351 payment_date : 20160104 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.29 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 : d.payet18 order_id : 12044 customer_email : d.payet18@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 = "12044" select * from cms_frontusers where identifiant = "d.payet18" 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 = "12044" select * from cotisations where identifiant = "d.payet18" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "d.payet18" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 120458 payment_means : MASTERCARD transmission_date : 20160104110458 payment_time : 120613 payment_date : 20160104 response_code : 00 payment_certificate : d9d85d18db59 authorisation_id : 958484 currency_code : 978 card_number : 5131.76 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.payet18 order_id : 12044 customer_email : d.payet18@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 = "12045" select * from cms_frontusers where identifiant = "f.dattler14" 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 = "12045" select * from cotisations where identifiant = "f.dattler14" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 124252 payment_means : VISA transmission_date : 20160104114252 payment_time : 124603 payment_date : 20160104 response_code : 00 payment_certificate : 1fd6b333c09e authorisation_id : 740476 currency_code : 978 card_number : 4975.00 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.dattler14 order_id : 12045 customer_email : f.dattler14@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 = "12046" select * from cms_frontusers where identifiant = "a.marion13" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "12046" select * from cotisations where identifiant = "a.marion13" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 125303 payment_means : MASTERCARD transmission_date : 20160104115303 payment_time : 125416 payment_date : 20160104 response_code : 00 payment_certificate : c893ba2ee384 authorisation_id : 148026 currency_code : 978 card_number : 5138.59 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.marion13 order_id : 12046 customer_email : a.marion13@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12049" select * from cms_frontusers where identifiant = "pq.bani16" 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 = "12049" select * from cotisations where identifiant = "pq.bani16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 130731 payment_means : VISA transmission_date : 20160104120731 payment_time : 130806 payment_date : 20160104 response_code : 00 payment_certificate : 3ed7b5473870 authorisation_id : 004246 currency_code : 978 card_number : 4921.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 : pq.bani16 order_id : 12049 customer_email : pq.bani16@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 130718 payment_means : VISA transmission_date : 20160104120718 payment_time : 131226 payment_date : 20160104 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4976.82 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 : h.dubreucq19 order_id : 12048 customer_email : h.dubreucq19@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 : 201801 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12051" select * from cms_frontusers where identifiant = "r.perrigot11" 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 = "12051" select * from cotisations where identifiant = "r.perrigot11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 133207 payment_means : VISA transmission_date : 20160104123207 payment_time : 133531 payment_date : 20160104 response_code : 00 payment_certificate : 7cd16620c30c authorisation_id : 440756 currency_code : 978 card_number : 4976.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.perrigot11 order_id : 12051 customer_email : r.perrigot11@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 = "12052" select * from cms_frontusers where identifiant = "i.momprive27" 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 = "12052" select * from cotisations where identifiant = "i.momprive27" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 133330 payment_means : VISA transmission_date : 20160104123330 payment_time : 133623 payment_date : 20160104 response_code : 00 payment_certificate : 6ae2692486fd authorisation_id : 467432 currency_code : 978 card_number : 4970.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 : i.momprive27 order_id : 12052 customer_email : i.momprive27@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 = "12053" select * from cms_frontusers where identifiant = "i.momprive27" 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 = "12053" select * from cotisations where identifiant = "i.momprive27" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 133701 payment_means : VISA transmission_date : 20160104123701 payment_time : 133832 payment_date : 20160104 response_code : 00 payment_certificate : ad36c1d17f81 authorisation_id : 143664 currency_code : 978 card_number : 4970.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 : i.momprive27 order_id : 12053 customer_email : i.momprive27@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 133821 payment_means : MASTERCARD transmission_date : 20160104123821 payment_time : 134151 payment_date : 20160104 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.40 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 59 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jc.robin12 order_id : 12054 customer_email : jc.robin12@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 = "12055" select * from cms_frontusers where identifiant = "c.mandrou03" 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 = "12055" select * from cotisations where identifiant = "c.mandrou03" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 134004 payment_means : MASTERCARD transmission_date : 20160104124004 payment_time : 134236 payment_date : 20160104 response_code : 00 payment_certificate : 7a3dacdb89bc authorisation_id : 682662 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 : c.mandrou03 order_id : 12055 customer_email : c.mandrou03@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 = "12056" select * from cms_frontusers where identifiant = "c.mandrou03" 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 = "12056" select * from cotisations where identifiant = "c.mandrou03" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 134257 payment_means : MASTERCARD transmission_date : 20160104124257 payment_time : 134417 payment_date : 20160104 response_code : 00 payment_certificate : 352804a1fa5e authorisation_id : 455228 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 : c.mandrou03 order_id : 12056 customer_email : c.mandrou03@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 = "12054" select * from cms_frontusers where identifiant = "jc.robin12" 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 = "12054" select * from cotisations where identifiant = "jc.robin12" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 134249 payment_means : MASTERCARD transmission_date : 20160104124249 payment_time : 134515 payment_date : 20160104 response_code : 00 payment_certificate : 8b2b990de7cb authorisation_id : 195195 currency_code : 978 card_number : 5137.40 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jc.robin12 order_id : 12054 customer_email : jc.robin12@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 = "12057" select * from cms_frontusers where identifiant = "f.cheron28" 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 = "12057" select * from cotisations where identifiant = "f.cheron28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 135535 payment_means : VISA transmission_date : 20160104125535 payment_time : 135823 payment_date : 20160104 response_code : 00 payment_certificate : a0c1b19901cf authorisation_id : 302141 currency_code : 978 card_number : 4974.24 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.cheron28 order_id : 12057 customer_email : f.cheron28@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 = "12058" select * from cms_frontusers where identifiant = "j.colle13" 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 = "12058" select * from cotisations where identifiant = "j.colle13" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 135916 payment_means : MASTERCARD transmission_date : 20160104125916 payment_time : 140220 payment_date : 20160104 response_code : 00 payment_certificate : e79aace1878b authorisation_id : 447512 currency_code : 978 card_number : 5136.32 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.colle13 order_id : 12058 customer_email : j.colle13@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 = "12061" select * from cms_frontusers where identifiant = "n.douaud08" 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 = "12061" select * from cotisations where identifiant = "n.douaud08" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 153259 payment_means : MASTERCARD transmission_date : 20160104143259 payment_time : 153852 payment_date : 20160104 response_code : 00 payment_certificate : e436fede6297 authorisation_id : 446307 currency_code : 978 card_number : 5131.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 : n.douaud08 order_id : 12061 customer_email : n.douaud08@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 = "12064" select * from cms_frontusers where identifiant = "v.lesourne23" 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 = "12064" select * from cotisations where identifiant = "v.lesourne23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 154430 payment_means : MASTERCARD transmission_date : 20160104144430 payment_time : 154741 payment_date : 20160104 response_code : 00 payment_certificate : 89743c886d10 authorisation_id : 302253 currency_code : 978 card_number : 5131.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 : v.lesourne23 order_id : 12064 customer_email : v.lesourne23@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 = "12065" select * from cms_frontusers where identifiant = "d.hamon20" 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 = "12065" select * from cotisations where identifiant = "d.hamon20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 155300 payment_means : MASTERCARD transmission_date : 20160104145300 payment_time : 155446 payment_date : 20160104 response_code : 00 payment_certificate : 9048ffe4798d authorisation_id : 154231 currency_code : 978 card_number : 5137.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 : d.hamon20 order_id : 12065 customer_email : d.hamon20@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 = "12066" select * from cms_frontusers where identifiant = "h.bernard23" 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 = "12066" select * from cotisations where identifiant = "h.bernard23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 155430 payment_means : MASTERCARD transmission_date : 20160104145430 payment_time : 155547 payment_date : 20160104 response_code : 00 payment_certificate : b55188089f69 authorisation_id : 353640 currency_code : 978 card_number : 5131.53 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : h.bernard23 order_id : 12066 customer_email : h.bernard23@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12068" select * from cms_frontusers where identifiant = "f.auger24" 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 = "12068" select * from cotisations where identifiant = "f.auger24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 155616 payment_means : MASTERCARD transmission_date : 20160104145616 payment_time : 155804 payment_date : 20160104 response_code : 00 payment_certificate : 346f23e056ba authorisation_id : 336973 currency_code : 978 card_number : 5132.50 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.auger24 order_id : 12068 customer_email : f.auger24@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12067" select * from cms_frontusers where identifiant = "j.perras06" 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 = "12067" select * from cotisations where identifiant = "j.perras06" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 155530 payment_means : VISA transmission_date : 20160104145530 payment_time : 160549 payment_date : 20160104 response_code : 00 payment_certificate : 99f84755b2c5 authorisation_id : 761436 currency_code : 978 card_number : 4975.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 : j.perras06 order_id : 12067 customer_email : j.perras06@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 = "12069" 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 = "12069" select * from cotisations where identifiant = "c.martinez07" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 164240 payment_means : VISA transmission_date : 20160104154240 payment_time : 164516 payment_date : 20160104 response_code : 00 payment_certificate : 5e8dfc0dc6b6 authorisation_id : 117435 currency_code : 978 card_number : 4971.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.pagnon13 order_id : 12069 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 : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12070" 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 = "12070" select * from cotisations where identifiant = "v.dupuis19" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 164838 payment_means : VISA transmission_date : 20160104154838 payment_time : 165240 payment_date : 20160104 response_code : 00 payment_certificate : 780817ace002 authorisation_id : 520419 currency_code : 978 card_number : 4978.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 : p.pagnon13 order_id : 12070 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 : 201604 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 170606 payment_means : VISA transmission_date : 20160104160606 payment_time : 170731 payment_date : 20160104 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.12 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.niel06 order_id : 12071 customer_email : c.niel06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201702 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12073" select * from cms_frontusers where identifiant = "c.niel06" 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 = "12073" select * from cotisations where identifiant = "f.gardet16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 171245 payment_means : VISA transmission_date : 20160104161245 payment_time : 171353 payment_date : 20160104 response_code : 00 payment_certificate : c7447a5e7e82 authorisation_id : 446328 currency_code : 978 card_number : 4973.95 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.niel06 order_id : 12073 customer_email : c.niel06@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 = "12075" select * from cms_frontusers where identifiant = "c.niel06" 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 = "12075" select * from cotisations where identifiant = "a.lamoureux11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 171408 payment_means : VISA transmission_date : 20160104161408 payment_time : 171605 payment_date : 20160104 response_code : 00 payment_certificate : 133f1fd259c5 authorisation_id : 298516 currency_code : 978 card_number : 4533.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 : c.niel06 order_id : 12075 customer_email : c.niel06@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 = "12076" select * from cms_frontusers where identifiant = "c.niel06" 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 = "12076" select * from cotisations where identifiant = "c.fave21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 171749 payment_means : VISA transmission_date : 20160104161749 payment_time : 171845 payment_date : 20160104 response_code : 00 payment_certificate : 7a19ffd86080 authorisation_id : 237521 currency_code : 978 card_number : 4533.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 : c.niel06 order_id : 12076 customer_email : c.niel06@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 = "12077" select * from cms_frontusers where identifiant = "p.duboy29" 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 = "12077" select * from cotisations where identifiant = "p.duboy29" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 172852 payment_means : MASTERCARD transmission_date : 20160104162852 payment_time : 173122 payment_date : 20160104 response_code : 00 payment_certificate : 49c1fceb64d0 authorisation_id : 202434 currency_code : 978 card_number : 5341.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 : p.duboy29 order_id : 12077 customer_email : p.duboy29@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 = "12078" select * from cms_frontusers where identifiant = "b.coste23" 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 = "12078" select * from cotisations where identifiant = "b.coste23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 172911 payment_means : MASTERCARD transmission_date : 20160104162911 payment_time : 173325 payment_date : 20160104 response_code : 00 payment_certificate : 3be17ffb17a9 authorisation_id : 625305 currency_code : 978 card_number : 5131.62 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.coste23 order_id : 12078 customer_email : b.coste23@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 = "12080" select * from cms_frontusers where identifiant = "p.bernut23" 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 = "12080" select * from cotisations where identifiant = "e.schach22" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 175800 payment_means : MASTERCARD transmission_date : 20160104165800 payment_time : 175942 payment_date : 20160104 response_code : 00 payment_certificate : a1ca0b88a459 authorisation_id : 825649 currency_code : 978 card_number : 5132.63 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.bernut23 order_id : 12080 customer_email : p.bernut23@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 180905 payment_means : CB transmission_date : 20160104170905 payment_time : 180944 payment_date : 20160104 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.63 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 59 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.struzyk24 order_id : 12081 customer_email : j.struzyk24@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 : 201601 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12081" select * from cms_frontusers where identifiant = "j.struzyk24" 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 = "12081" select * from cotisations where identifiant = "j.struzyk24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181006 payment_means : MASTERCARD transmission_date : 20160104171006 payment_time : 181220 payment_date : 20160104 response_code : 00 payment_certificate : 4be83e560eb5 authorisation_id : 043346 currency_code : 978 card_number : 5131.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 : j.struzyk24 order_id : 12081 customer_email : j.struzyk24@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12083" select * from cms_frontusers where identifiant = "c.moreau19" 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 = "12083" select * from cotisations where identifiant = "b.rimaud22" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "b.rimaud22" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 181218 payment_means : VISA transmission_date : 20160104171218 payment_time : 181326 payment_date : 20160104 response_code : 00 payment_certificate : f2522863d41e authorisation_id : 172623 currency_code : 978 card_number : 4975.48 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.moreau19 order_id : 12083 customer_email : c.moreau19@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 = "12084" select * from cms_frontusers where identifiant = "r.fernandez18" 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 = "12084" select * from cotisations where identifiant = "r.fernandez18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181404 payment_means : VISA transmission_date : 20160104171404 payment_time : 181510 payment_date : 20160104 response_code : 00 payment_certificate : 925b3a02bcd6 authorisation_id : 301154 currency_code : 978 card_number : 4976.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.fernandez18 order_id : 12084 customer_email : r.fernandez18@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 : 181533 payment_means : MASTERCARD transmission_date : 20160104171533 payment_time : 182032 payment_date : 20160104 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.39 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 : p.theoleyre22 order_id : 12085 customer_email : p.theoleyre22@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12082" select * from cms_frontusers where identifiant = "p.girondeau04" 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 = "12082" select * from cotisations where identifiant = "p.girondeau04" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181854 payment_means : VISA transmission_date : 20160104171854 payment_time : 182214 payment_date : 20160104 response_code : 00 payment_certificate : 2bc7eca8844a authorisation_id : 931734 currency_code : 978 card_number : 4976.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 : p.girondeau04 order_id : 12082 customer_email : p.girondeau04@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 = "12087" select * from cms_frontusers where identifiant = "jp.dupont28" 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 = "12087" select * from cotisations where identifiant = "jn.bertrel19" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183629 payment_means : VISA transmission_date : 20160104173629 payment_time : 183737 payment_date : 20160104 response_code : 00 payment_certificate : 354790060de4 authorisation_id : 258149 currency_code : 978 card_number : 4970.85 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jp.dupont28 order_id : 12087 customer_email : jp.dupont28@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 = "12088" select * from cms_frontusers where identifiant = "p.breze19" 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 = "12088" select * from cotisations where identifiant = "p.breze19" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183901 payment_means : MASTERCARD transmission_date : 20160104173901 payment_time : 184324 payment_date : 20160104 response_code : 00 payment_certificate : dcd6847421b7 authorisation_id : 115577 currency_code : 978 card_number : 5131.46 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.breze19 order_id : 12088 customer_email : p.breze19@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 = "12089" select * from cms_frontusers where identifiant = "e.taugourdeau11" 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 = "12089" select * from cotisations where identifiant = "e.taugourdeau11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 184354 payment_means : MASTERCARD transmission_date : 20160104174354 payment_time : 184636 payment_date : 20160104 response_code : 00 payment_certificate : 718abf18ab19 authorisation_id : 622514 currency_code : 978 card_number : 5132.82 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.taugourdeau11 order_id : 12089 customer_email : e.taugourdeau11@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201702 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12093" select * from cms_frontusers where identifiant = "c.moreau19" 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 = "12093" select * from cotisations where identifiant = "f.vandenbroucque11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185659 payment_means : VISA transmission_date : 20160104175659 payment_time : 185900 payment_date : 20160104 response_code : 00 payment_certificate : a123454b910b authorisation_id : 942351 currency_code : 978 card_number : 4975.57 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.moreau19 order_id : 12093 customer_email : c.moreau19@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 = "12092" select * from cms_frontusers where identifiant = "a.vogt19" 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 = "12092" select * from cotisations where identifiant = "a.vogt19" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185440 payment_means : VISA transmission_date : 20160104175440 payment_time : 190117 payment_date : 20160104 response_code : 00 payment_certificate : 7d7cc66db5f1 authorisation_id : 402449 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 : a.vogt19 order_id : 12092 customer_email : a.vogt19@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 = "12095" select * from cms_frontusers where identifiant = "s.debortoli05" 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 = "12095" select * from cotisations where identifiant = "s.debortoli05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191127 payment_means : VISA transmission_date : 20160104181127 payment_time : 191331 payment_date : 20160104 response_code : 00 payment_certificate : 45b1e135cfb0 authorisation_id : 161513 currency_code : 978 card_number : 4975.51 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.debortoli05 order_id : 12095 customer_email : s.debortoli05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201604 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191553 payment_means : VISA transmission_date : 20160104181553 payment_time : 191734 payment_date : 20160104 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4975.57 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.szczuczynski31 order_id : 12097 customer_email : e.szczuczynski31@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 = "12097" select * from cms_frontusers where identifiant = "e.szczuczynski31" 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 = "12097" select * from cotisations where identifiant = "e.szczuczynski31" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191824 payment_means : VISA transmission_date : 20160104181824 payment_time : 192000 payment_date : 20160104 response_code : 00 payment_certificate : c7e39ada1a84 authorisation_id : 486632 currency_code : 978 card_number : 4975.57 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.szczuczynski31 order_id : 12097 customer_email : e.szczuczynski31@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 192710 payment_means : VISA transmission_date : 20160104182710 payment_time : 193911 payment_date : 20160104 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4977.84 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 : g.jolivel01 order_id : 12098 customer_email : g.jolivel01@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 = "12098" select * from cms_frontusers where identifiant = "g.jolivel01" 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 = "12098" select * from cotisations where identifiant = "g.jolivel01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 193921 payment_means : VISA transmission_date : 20160104183921 payment_time : 194114 payment_date : 20160104 response_code : 00 payment_certificate : 4b6c218bf209 authorisation_id : 773117 currency_code : 978 card_number : 4977.84 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.jolivel01 order_id : 12098 customer_email : g.jolivel01@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 = "12099" select * from cms_frontusers where identifiant = "v.richard23" 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 = "12099" select * from cotisations where identifiant = "v.richard23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195318 payment_means : MASTERCARD transmission_date : 20160104185318 payment_time : 195450 payment_date : 20160104 response_code : 00 payment_certificate : 1d25d6fcc5a2 authorisation_id : 140532 currency_code : 978 card_number : 5133.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 : v.richard23 order_id : 12099 customer_email : v.richard23@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201701 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195811 payment_means : MASTERCARD transmission_date : 20160104185811 payment_time : 200157 payment_date : 20160104 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.73 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 : pm.chauvigne08 order_id : 12101 customer_email : pm.chauvigne08@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 : 201702 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 : 200226 payment_means : MASTERCARD transmission_date : 20160104190226 payment_time : 200455 payment_date : 20160104 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.73 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 : pm.chauvigne08 order_id : 12101 customer_email : pm.chauvigne08@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 : 201702 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12101" select * from cms_frontusers where identifiant = "pm.chauvigne08" 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 = "12101" select * from cotisations where identifiant = "pm.chauvigne08" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 200651 payment_means : MASTERCARD transmission_date : 20160104190651 payment_time : 201002 payment_date : 20160104 response_code : 00 payment_certificate : 8d3a9c5c6c67 authorisation_id : 622231 currency_code : 978 card_number : 5138.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 : pm.chauvigne08 order_id : 12101 customer_email : pm.chauvigne08@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 = "12103" select * from cms_frontusers where identifiant = "j.dupre24" 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 = "12103" select * from cotisations where identifiant = "j.dupre24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201212 payment_means : MASTERCARD transmission_date : 20160104191212 payment_time : 201443 payment_date : 20160104 response_code : 00 payment_certificate : a33711fadcf0 authorisation_id : 924153 currency_code : 978 card_number : 5132.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 : j.dupre24 order_id : 12103 customer_email : j.dupre24@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 = "12104" select * from cms_frontusers where identifiant = "a.thoelen23" 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 = "12104" select * from cotisations where identifiant = "a.thoelen23" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201245 payment_means : MASTERCARD transmission_date : 20160104191245 payment_time : 201447 payment_date : 20160104 response_code : 00 payment_certificate : fe1a42d5d024 authorisation_id : 357907 currency_code : 978 card_number : 5134.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 : a.thoelen23 order_id : 12104 customer_email : a.thoelen23@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 = "12105" select * from cms_frontusers where identifiant = "m.goustiaux26" 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 = "12105" select * from cotisations where identifiant = "m.goustiaux26" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201552 payment_means : VISA transmission_date : 20160104191552 payment_time : 201737 payment_date : 20160104 response_code : 00 payment_certificate : bdbaaea80477 authorisation_id : 563332 currency_code : 978 card_number : 4975.30 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.goustiaux26 order_id : 12105 customer_email : m.goustiaux26@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 = "12106" select * from cms_frontusers where identifiant = "p.paget25" 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 = "12106" select * from cotisations where identifiant = "p.paget25" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201928 payment_means : VISA transmission_date : 20160104191928 payment_time : 202139 payment_date : 20160104 response_code : 00 payment_certificate : bb15e99acc08 authorisation_id : 057532 currency_code : 978 card_number : 4978.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 : p.paget25 order_id : 12106 customer_email : p.paget25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 204428 payment_means : MASTERCARD transmission_date : 20160104194428 payment_time : 204730 payment_date : 20160104 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5134.78 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 : s.mahler28 order_id : 12109 customer_email : s.mahler28@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 = "12113" select * from cms_frontusers where identifiant = "v.caumont26" 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 = "12113" select * from cotisations where identifiant = "a.caruso02" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 210254 payment_means : VISA transmission_date : 20160104200254 payment_time : 210500 payment_date : 20160104 response_code : 00 payment_certificate : fc856aa7291c authorisation_id : 926541 currency_code : 978 card_number : 4970.82 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.caumont26 order_id : 12113 customer_email : v.caumont26@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 : 4000 transaction_id : 210614 payment_means : VISA transmission_date : 20160104200614 payment_time : 210828 payment_date : 20160104 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.82 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 57 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.caumont26 order_id : 12114 customer_email : v.caumont26@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 = "12116" select * from cms_frontusers where identifiant = "p.pouligny28" 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 = "12116" select * from cotisations where identifiant = "p.pouligny28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 211615 payment_means : VISA transmission_date : 20160104201615 payment_time : 211735 payment_date : 20160104 response_code : 00 payment_certificate : aa254016523f authorisation_id : 796655 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 : p.pouligny28 order_id : 12116 customer_email : p.pouligny28@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 = "12117" select * from cms_frontusers where identifiant = "s.henry29" 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 = "12117" select * from cotisations where identifiant = "s.henry29" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211854 payment_means : VISA transmission_date : 20160104201854 payment_time : 212124 payment_date : 20160104 response_code : 00 payment_certificate : 17fdae5552ce authorisation_id : 892766 currency_code : 978 card_number : 4972.03 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.henry29 order_id : 12117 customer_email : s.henry29@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 = "12115" select * from cms_frontusers where identifiant = "c.regnault30" 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 = "12115" select * from cotisations where identifiant = "c.regnault30" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212038 payment_means : VISA transmission_date : 20160104202038 payment_time : 212238 payment_date : 20160104 response_code : 00 payment_certificate : f60ed01d29df authorisation_id : 434726 currency_code : 978 card_number : 4975.10 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.regnault30 order_id : 12115 customer_email : c.regnault30@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 = "12119" select * from cms_frontusers where identifiant = "n.grosbois01" 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 = "12119" select * from cotisations where identifiant = "n.grosbois01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 212155 payment_means : VISA transmission_date : 20160104202155 payment_time : 212330 payment_date : 20160104 response_code : 00 payment_certificate : 75248716540e authorisation_id : 256260 currency_code : 978 card_number : 4970.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 : n.grosbois01 order_id : 12119 customer_email : n.grosbois01@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 : 212314 payment_means : MASTERCARD transmission_date : 20160104202314 payment_time : 212559 payment_date : 20160104 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.63 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 : d.vilcocq07 order_id : 12120 customer_email : d.vilcocq07@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 = "12118" select * from cms_frontusers where identifiant = "c.pacault05" 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 = "12118" select * from cotisations where identifiant = "c.pacault05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 212110 payment_means : MASTERCARD transmission_date : 20160104202110 payment_time : 212610 payment_date : 20160104 response_code : 00 payment_certificate : d206d655ffee authorisation_id : 615754 currency_code : 978 card_number : 5137.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 : c.pacault05 order_id : 12118 customer_email : c.pacault05@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 = "12121" select * from cms_frontusers where identifiant = "c.berthezene22" 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 = "12121" select * from cotisations where identifiant = "c.berthezene22" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212838 payment_means : VISA transmission_date : 20160104202838 payment_time : 212958 payment_date : 20160104 response_code : 00 payment_certificate : e109aac165ae authorisation_id : 157148 currency_code : 978 card_number : 4970.31 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.berthezene22 order_id : 12121 customer_email : c.berthezene22@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 = "12122" select * from cms_frontusers where identifiant = "c.fuchs09" 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 = "12122" select * from cotisations where identifiant = "c.fuchs09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 213048 payment_means : VISA transmission_date : 20160104203048 payment_time : 213351 payment_date : 20160104 response_code : 00 payment_certificate : 27bdc338b7a3 authorisation_id : 555317 currency_code : 978 card_number : 4978.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.fuchs09 order_id : 12122 customer_email : c.fuchs09@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 = "12124" select * from cms_frontusers where identifiant = "v.felix04" 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 = "12124" select * from cotisations where identifiant = "v.felix04" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "v.felix04" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 213412 payment_means : VISA transmission_date : 20160104203412 payment_time : 213639 payment_date : 20160104 response_code : 00 payment_certificate : 5922ca416c8a authorisation_id : 922445 currency_code : 978 card_number : 4978.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 : v.felix04 order_id : 12124 customer_email : v.felix04@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 = "12125" select * from cms_frontusers where identifiant = "t.louis30" 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 = "12125" select * from cotisations where identifiant = "t.louis30" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 213642 payment_means : MASTERCARD transmission_date : 20160104203642 payment_time : 213835 payment_date : 20160104 response_code : 00 payment_certificate : 171222d6fba2 authorisation_id : 067109 currency_code : 978 card_number : 5133.87 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.louis30 order_id : 12125 customer_email : t.louis30@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 = "12126" select * from cms_frontusers where identifiant = "f.aulino15" 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 = "12126" select * from cotisations where identifiant = "f.aulino15" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214407 payment_means : VISA transmission_date : 20160104204407 payment_time : 214622 payment_date : 20160104 response_code : 00 payment_certificate : e566cafc6834 authorisation_id : 728629 currency_code : 978 card_number : 4972.55 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.aulino15 order_id : 12126 customer_email : f.aulino15@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 = "12127" select * from cms_frontusers where identifiant = "a.gaudin16" 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 = "12127" select * from cotisations where identifiant = "f.jacquemet20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 214445 payment_means : MASTERCARD transmission_date : 20160104204445 payment_time : 214757 payment_date : 20160104 response_code : 00 payment_certificate : 2e1b94f7dd62 authorisation_id : 338366 currency_code : 978 card_number : 5131.43 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.gaudin16 order_id : 12127 customer_email : a.gaudin16@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 = "12128" select * from cms_frontusers where identifiant = "a.gaudin16" 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 = "12128" select * from cotisations where identifiant = "a.mazy12" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "a.mazy12" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 215110 payment_means : VISA transmission_date : 20160104205110 payment_time : 215339 payment_date : 20160104 response_code : 00 payment_certificate : 14a7eb412b5b authorisation_id : 003538 currency_code : 978 card_number : 4978.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 : a.gaudin16 order_id : 12128 customer_email : a.gaudin16@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 = "12129" select * from cms_frontusers where identifiant = "c.fessard21" 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 = "12129" select * from cotisations where identifiant = "c.fessard21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 215254 payment_means : VISA transmission_date : 20160104205254 payment_time : 215500 payment_date : 20160104 response_code : 00 payment_certificate : 291ed9fd8745 authorisation_id : 666432 currency_code : 978 card_number : 4976.85 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.fessard21 order_id : 12129 customer_email : c.fessard21@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 = "12132" select * from cms_frontusers where identifiant = "jb.henry28" 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 = "12132" select * from cotisations where identifiant = "jb.henry28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 221347 payment_means : VISA transmission_date : 20160104211347 payment_time : 221452 payment_date : 20160104 response_code : 00 payment_certificate : 9d5d49decc97 authorisation_id : 437992 currency_code : 978 card_number : 4970.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.henry28 order_id : 12132 customer_email : jb.henry28@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 = "12131" select * from cms_frontusers where identifiant = "m.pani25" 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 = "12131" select * from cotisations where identifiant = "m.pani25" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "m.pani25" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 221748 payment_means : VISA transmission_date : 20160104211748 payment_time : 221919 payment_date : 20160104 response_code : 00 payment_certificate : 7f6ee36476dd authorisation_id : 635021 currency_code : 978 card_number : 4978.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.pani25 order_id : 12131 customer_email : m.pani25@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 = "12134" select * from cms_frontusers where identifiant = "k.thebaud24" 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 = "12134" select * from cotisations where identifiant = "k.thebaud24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 222050 payment_means : MASTERCARD transmission_date : 20160104212050 payment_time : 222223 payment_date : 20160104 response_code : 00 payment_certificate : d1d1497135f3 authorisation_id : 316421 currency_code : 978 card_number : 5132.72 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : k.thebaud24 order_id : 12134 customer_email : k.thebaud24@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 = "12135" select * from cms_frontusers where identifiant = "a.valette18" 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 = "12135" select * from cotisations where identifiant = "t.waegeneire16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 222131 payment_means : VISA transmission_date : 20160104212131 payment_time : 222358 payment_date : 20160104 response_code : 00 payment_certificate : 6db4d1dd39f8 authorisation_id : 925196 currency_code : 978 card_number : 4974.12 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.valette18 order_id : 12135 customer_email : a.valette18@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 = "12136" select * from cms_frontusers where identifiant = "a.brech30" 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 = "12136" select * from cotisations where identifiant = "l.mathieu31" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 222523 payment_means : VISA transmission_date : 20160104212523 payment_time : 222718 payment_date : 20160104 response_code : 00 payment_certificate : 8b0deb23f183 authorisation_id : 125405 currency_code : 978 card_number : 4973.92 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.brech30 order_id : 12136 customer_email : a.brech30@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 = "12137" select * from cms_frontusers where identifiant = "b.verot27" 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 = "12137" select * from cotisations where identifiant = "s.journoud13" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "jj.neufond30" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 222655 payment_means : MASTERCARD transmission_date : 20160104212655 payment_time : 222906 payment_date : 20160104 response_code : 00 payment_certificate : e4cbfae6cbf1 authorisation_id : 405433 currency_code : 978 card_number : 5137.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 : b.verot27 order_id : 12137 customer_email : b.verot27@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 = "12138" select * from cms_frontusers where identifiant = "a.brech30" 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 = "12138" select * from cotisations where identifiant = "j.kervella27" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 222803 payment_means : VISA transmission_date : 20160104212803 payment_time : 222924 payment_date : 20160104 response_code : 00 payment_certificate : 8cd9fd319143 authorisation_id : 343220 currency_code : 978 card_number : 4973.92 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.brech30 order_id : 12138 customer_email : a.brech30@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 232819 payment_means : MASTERCARD transmission_date : 20160104222819 payment_time : 233019 payment_date : 20160104 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5341.87 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 : p.joncour09 order_id : 12140 customer_email : p.joncour09@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 = "12139" select * from cms_frontusers where identifiant = "a.beynet28" 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 = "12139" select * from cotisations where identifiant = "a.beynet28" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "a.beynet28" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 232747 payment_means : VISA transmission_date : 20160104222747 payment_time : 233205 payment_date : 20160104 response_code : 00 payment_certificate : ae13e587220f authorisation_id : 845952 currency_code : 978 card_number : 4978.76 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.beynet28 order_id : 12139 customer_email : a.beynet28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12140" select * from cms_frontusers where identifiant = "p.joncour09" 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 = "12140" select * from cotisations where identifiant = "p.joncour09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 233223 payment_means : MASTERCARD transmission_date : 20160104223223 payment_time : 233419 payment_date : 20160104 response_code : 00 payment_certificate : 8057dd6fcf5f authorisation_id : 381286 currency_code : 978 card_number : 5341.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 : p.joncour09 order_id : 12140 customer_email : p.joncour09@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 : -------------------------------------------