Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 021436 payment_means : MASTERCARD transmission_date : 20160301011436 payment_time : 021558 payment_date : 20160301 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.36 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.balcon05 order_id : 14281 customer_email : v.balcon05@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 : 201704 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "14281" select * from cms_frontusers where identifiant = "v.balcon05" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "14281" select * from cotisations where identifiant = "v.balcon05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 021602 payment_means : MASTERCARD transmission_date : 20160301011602 payment_time : 021825 payment_date : 20160301 response_code : 00 payment_certificate : d070dbbedb60 authorisation_id : 820749 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 : v.balcon05 order_id : 14281 customer_email : v.balcon05@compagnons-du-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 = "14282" select * from cms_frontusers where identifiant = "t.boulay25" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "14282" select * from cotisations where identifiant = "j.pasquer14" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 061604 payment_means : MASTERCARD transmission_date : 20160301051604 payment_time : 061800 payment_date : 20160301 response_code : 00 payment_certificate : 053549fa24db authorisation_id : 925413 currency_code : 978 card_number : 5136.94 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.boulay25 order_id : 14282 customer_email : t.boulay25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201712 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "14283" select * from cms_frontusers where identifiant = "e.egloff03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "14283" select * from cotisations where identifiant = "e.egloff03" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 081206 payment_means : VISA transmission_date : 20160301071206 payment_time : 081432 payment_date : 20160301 response_code : 00 payment_certificate : e1f648da3aed authorisation_id : 503169 currency_code : 978 card_number : 4751.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 : e.egloff03 order_id : 14283 customer_email : e.egloff03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201902 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "14284" select * from cms_frontusers where identifiant = "r.viault28" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "14284" select * from cotisations where identifiant = "s.forget29" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 115243 payment_means : MASTERCARD transmission_date : 20160301105243 payment_time : 115439 payment_date : 20160301 response_code : 00 payment_certificate : 27d53fa510d8 authorisation_id : 433499 currency_code : 978 card_number : 5137.44 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.viault28 order_id : 14284 customer_email : r.viault28@compagnons-du-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 : 181847 payment_means : VISA transmission_date : 20160301171847 payment_time : 182157 payment_date : 20160301 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4976.81 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 : v.delannoy21 order_id : 14285 customer_email : v.delannoy21@compagnons-du-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 = "14287" select * from cms_frontusers where identifiant = "g.dezest23" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "14287" select * from cotisations where identifiant = "a.charles20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183514 payment_means : VISA transmission_date : 20160301173514 payment_time : 183705 payment_date : 20160301 response_code : 00 payment_certificate : f6b223e3adc2 authorisation_id : 667747 currency_code : 978 card_number : 4975.47 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.dezest23 order_id : 14287 customer_email : g.dezest23@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201901 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185018 payment_means : MASTERCARD transmission_date : 20160301175018 payment_time : 185533 payment_date : 20160301 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.25 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.vuidel10 order_id : 14288 customer_email : j.vuidel10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "14289" select * from cms_frontusers where identifiant = "j.vuidel10" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "14289" select * from cotisations where identifiant = "a.botos05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185644 payment_means : MASTERCARD transmission_date : 20160301175644 payment_time : 185814 payment_date : 20160301 response_code : 00 payment_certificate : 02c036c39c51 authorisation_id : 468100 currency_code : 978 card_number : 5131.25 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.vuidel10 order_id : 14289 customer_email : j.vuidel10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "14290" select * from cms_frontusers where identifiant = "s.champalou02" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "14290" select * from cotisations where identifiant = "s.champalou02" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "s.champalou02" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195030 payment_means : VISA transmission_date : 20160301185030 payment_time : 195253 payment_date : 20160301 response_code : 00 payment_certificate : 23dd0ceb83e2 authorisation_id : 725655 currency_code : 978 card_number : 4970.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 : s.champalou02 order_id : 14290 customer_email : s.champalou02@compagnons-du-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 = "14292" select * from cms_frontusers where identifiant = "gs.fabre03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "14292" select * from cotisations where identifiant = "n.beltrandominguez15" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203124 payment_means : VISA transmission_date : 20160301193124 payment_time : 203319 payment_date : 20160301 response_code : 00 payment_certificate : 9e919384a4b6 authorisation_id : 102432 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 : gs.fabre03 order_id : 14292 customer_email : gs.fabre03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "14296" select * from cms_frontusers where identifiant = "c.romien16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "14296" select * from cotisations where identifiant = "v.marcq31" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 220103 payment_means : VISA transmission_date : 20160301210103 payment_time : 220432 payment_date : 20160301 response_code : 00 payment_certificate : d885237309e2 authorisation_id : 045515 currency_code : 978 card_number : 4978.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 : c.romien16 order_id : 14296 customer_email : c.romien16@compagnons-du-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 = "14298" select * from cms_frontusers where identifiant = "c.prunieres17" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "14298" select * from cotisations where identifiant = "c.prunieres17" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 220231 payment_means : MASTERCARD transmission_date : 20160301210231 payment_time : 220511 payment_date : 20160301 response_code : 00 payment_certificate : 3d87dcb3d4c1 authorisation_id : 523469 currency_code : 978 card_number : 5131.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 : c.prunieres17 order_id : 14298 customer_email : c.prunieres17@compagnons-du-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 : -------------------------------------------