select * from cotisations_commande where id = "13354" select * from cms_frontusers where identifiant = "f.letrange09" 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 = "13354" select * from cotisations where identifiant = "f.letrange09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 000612 payment_means : MASTERCARD transmission_date : 20160129230612 payment_time : 000938 payment_date : 20160130 response_code : 00 payment_certificate : d989f8abc5ea authorisation_id : 169611 currency_code : 978 card_number : 5135.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 : f.letrange09 order_id : 13354 customer_email : f.letrange09@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 = "13355" select * from cms_frontusers where identifiant = "a.delimal23" 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 = "13355" select * from cotisations where identifiant = "a.delimal23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 001832 payment_means : MASTERCARD transmission_date : 20160129231832 payment_time : 002020 payment_date : 20160130 response_code : 00 payment_certificate : c493b47ac233 authorisation_id : 292252 currency_code : 978 card_number : 5135.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 : a.delimal23 order_id : 13355 customer_email : a.delimal23@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 = "13357" select * from cms_frontusers where identifiant = "t.claparede10" 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 = "13357" select * from cotisations where identifiant = "t.claparede10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 073048 payment_means : VISA transmission_date : 20160130063048 payment_time : 073208 payment_date : 20160130 response_code : 00 payment_certificate : 5b1a4c4e6d7d authorisation_id : 205393 currency_code : 978 card_number : 4972.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 : t.claparede10 order_id : 13357 customer_email : t.claparede10@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 = "13359" select * from cms_frontusers where identifiant = "a.guilbert25" 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 = "13359" select * from cotisations where identifiant = "a.guilbert25" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 085440 payment_means : MASTERCARD transmission_date : 20160130075440 payment_time : 085626 payment_date : 20160130 response_code : 00 payment_certificate : 93af86206718 authorisation_id : 449721 currency_code : 978 card_number : 5131.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 : a.guilbert25 order_id : 13359 customer_email : a.guilbert25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 085804 payment_means : MASTERCARD transmission_date : 20160130075804 payment_time : 090012 payment_date : 20160130 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.19 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.morel21 order_id : 13361 customer_email : g.morel21@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 : 202412 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13360" select * from cms_frontusers where identifiant = "s.dubois07" 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 = "13360" select * from cotisations where identifiant = "s.dubois07" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 085756 payment_means : VISA transmission_date : 20160130075756 payment_time : 090333 payment_date : 20160130 response_code : 00 payment_certificate : e5f3bbae86d6 authorisation_id : 135231 currency_code : 978 card_number : 4977.64 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.dubois07 order_id : 13360 customer_email : s.dubois07@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 : 090057 payment_means : VISA transmission_date : 20160130080057 payment_time : 090356 payment_date : 20160130 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13362 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13363" select * from cms_frontusers where identifiant = "j.rizzetto26" 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 = "13363" select * from cotisations where identifiant = "b.houyvet30" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 091742 payment_means : VISA transmission_date : 20160130081742 payment_time : 091835 payment_date : 20160130 response_code : 00 payment_certificate : ad57bd1f54bc authorisation_id : 165174 currency_code : 978 card_number : 4970.78 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.rizzetto26 order_id : 13363 customer_email : j.rizzetto26@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 093544 payment_means : VISA transmission_date : 20160130083544 payment_time : 093729 payment_date : 20160130 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13364 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13365" select * from cms_frontusers where identifiant = "e.schneider18" 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 = "13365" select * from cotisations where identifiant = "e.schneider18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 093939 payment_means : MASTERCARD transmission_date : 20160130083939 payment_time : 094200 payment_date : 20160130 response_code : 00 payment_certificate : 3fc66ede4765 authorisation_id : 710173 currency_code : 978 card_number : 5132.65 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.schneider18 order_id : 13365 customer_email : e.schneider18@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 = "13366" select * from cms_frontusers where identifiant = "a.decorte13" 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 = "13366" select * from cotisations where identifiant = "a.decorte13" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 094938 payment_means : MASTERCARD transmission_date : 20160130084938 payment_time : 095145 payment_date : 20160130 response_code : 00 payment_certificate : d0dcb6292243 authorisation_id : 967312 currency_code : 978 card_number : 5136.39 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.decorte13 order_id : 13366 customer_email : a.decorte13@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 = "13368" select * from cms_frontusers where identifiant = "s.huchet16" 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 = "13368" select * from cotisations where identifiant = "g.jamet07" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 100632 payment_means : VISA transmission_date : 20160130090632 payment_time : 100812 payment_date : 20160130 response_code : 00 payment_certificate : 5b184ad4155a authorisation_id : 571939 currency_code : 978 card_number : 4627.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 : s.huchet16 order_id : 13368 customer_email : s.huchet16@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 = "13369" select * from cms_frontusers where identifiant = "s.huchet16" 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 = "13369" select * from cotisations where identifiant = "s.huchet16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 100950 payment_means : VISA transmission_date : 20160130090950 payment_time : 101052 payment_date : 20160130 response_code : 00 payment_certificate : c7b89e328c45 authorisation_id : 551298 currency_code : 978 card_number : 4627.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 : s.huchet16 order_id : 13369 customer_email : s.huchet16@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 = "13370" select * from cms_frontusers where identifiant = "s.vallet18" 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 = "13370" select * from cotisations where identifiant = "s.vallet18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 101822 payment_means : VISA transmission_date : 20160130091822 payment_time : 102027 payment_date : 20160130 response_code : 00 payment_certificate : 1a11676e14a4 authorisation_id : 103285 currency_code : 978 card_number : 4150.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 : s.vallet18 order_id : 13370 customer_email : s.vallet18@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 : 102732 payment_means : VISA transmission_date : 20160130092732 payment_time : 103411 payment_date : 20160130 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.80 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.terrien14 order_id : 13372 customer_email : j.terrien14@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201610 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13373" select * from cms_frontusers where identifiant = "b.mauduit23" 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 = "13373" select * from cotisations where identifiant = "b.mauduit23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 103220 payment_means : MASTERCARD transmission_date : 20160130093220 payment_time : 103546 payment_date : 20160130 response_code : 00 payment_certificate : 3ef72463218b authorisation_id : 531230 currency_code : 978 card_number : 5137.17 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.mauduit23 order_id : 13373 customer_email : b.mauduit23@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 : 102701 payment_means : VISA transmission_date : 20160130092701 payment_time : 104022 payment_date : 20160130 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.57 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.lebot03 order_id : 13371 customer_email : j.lebot03@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 : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13371" select * from cms_frontusers where identifiant = "j.lebot03" 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 = "13371" select * from cotisations where identifiant = "j.lebot03" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 104031 payment_means : VISA transmission_date : 20160130094031 payment_time : 104206 payment_date : 20160130 response_code : 00 payment_certificate : 01eede2e8b14 authorisation_id : 393227 currency_code : 978 card_number : 4973.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 : j.lebot03 order_id : 13371 customer_email : j.lebot03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 136000 transaction_id : 104201 payment_means : VISA transmission_date : 20160130094201 payment_time : 104625 payment_date : 20160130 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13374 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 136000 transaction_id : 104636 payment_means : VISA transmission_date : 20160130094636 payment_time : 104903 payment_date : 20160130 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13374 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13376" select * from cms_frontusers where identifiant = "p.berrue01" 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 = "13376" select * from cotisations where identifiant = "p.berrue01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 105739 payment_means : VISA transmission_date : 20160130095739 payment_time : 110244 payment_date : 20160130 response_code : 00 payment_certificate : f641d56b0dd5 authorisation_id : 544528 currency_code : 978 card_number : 4975.19 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.berrue01 order_id : 13376 customer_email : p.berrue01@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 : 136000 transaction_id : 112607 payment_means : VISA transmission_date : 20160130102607 payment_time : 112947 payment_date : 20160130 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13379 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 136000 transaction_id : 113056 payment_means : VISA transmission_date : 20160130103056 payment_time : 113220 payment_date : 20160130 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13379 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13380" select * from cms_frontusers where identifiant = "s.jung23" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "13380" select * from cotisations where identifiant = "j.castilla01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 113442 payment_means : VISA transmission_date : 20160130103442 payment_time : 113644 payment_date : 20160130 response_code : 00 payment_certificate : 26074cee655f authorisation_id : 370037 currency_code : 978 card_number : 4979.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 : s.jung23 order_id : 13380 customer_email : s.jung23@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201702 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13381" select * from cms_frontusers where identifiant = "p.sodji05" 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 = "13381" select * from cotisations where identifiant = "p.sodji05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 114834 payment_means : VISA transmission_date : 20160130104834 payment_time : 115019 payment_date : 20160130 response_code : 00 payment_certificate : 3036383f6a1c authorisation_id : 350417 currency_code : 978 card_number : 4970.02 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.sodji05 order_id : 13381 customer_email : p.sodji05@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 136000 transaction_id : 113346 payment_means : VISA transmission_date : 20160130103346 payment_time : 120048 payment_date : 20160130 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13379 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13382" select * from cms_frontusers where identifiant = "j.petit16" 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 = "13382" select * from cotisations where identifiant = "j.petit16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 120106 payment_means : VISA transmission_date : 20160130110106 payment_time : 120339 payment_date : 20160130 response_code : 00 payment_certificate : 63e3565b1d82 authorisation_id : 498139 currency_code : 978 card_number : 4978.15 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.petit16 order_id : 13382 customer_email : j.petit16@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 = "13383" select * from cms_frontusers where identifiant = "o.fronteau09" 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 = "13383" select * from cotisations where identifiant = "o.fronteau09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 120936 payment_means : VISA transmission_date : 20160130110936 payment_time : 121256 payment_date : 20160130 response_code : 00 payment_certificate : 426cbf3e3d7c authorisation_id : 666193 currency_code : 978 card_number : 4972.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 : o.fronteau09 order_id : 13383 customer_email : o.fronteau09@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 = "13384" select * from cms_frontusers where identifiant = "j.cazin17" 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 = "13384" select * from cotisations where identifiant = "jf.potel20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 121204 payment_means : MASTERCARD transmission_date : 20160130111204 payment_time : 121614 payment_date : 20160130 response_code : 00 payment_certificate : 0d521ef1155c authorisation_id : 354530 currency_code : 978 card_number : 5131.23 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.cazin17 order_id : 13384 customer_email : j.cazin17@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 : 136000 transaction_id : 122435 payment_means : VISA transmission_date : 20160130112435 payment_time : 122558 payment_date : 20160130 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.borderieux21 order_id : 13385 customer_email : n.borderieux21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13386" select * from cms_frontusers where identifiant = "r.wulfranck30" 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 = "13386" select * from cotisations where identifiant = "r.wulfranck30" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 122529 payment_means : MASTERCARD transmission_date : 20160130112529 payment_time : 122715 payment_date : 20160130 response_code : 00 payment_certificate : 7f62441be322 authorisation_id : 535909 currency_code : 978 card_number : 5131.61 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.wulfranck30 order_id : 13386 customer_email : r.wulfranck30@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 = "13387" select * from cms_frontusers where identifiant = "jb.chalmey01" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "13387" select * from cotisations where identifiant = "j.voisin23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 123455 payment_means : MASTERCARD transmission_date : 20160130113455 payment_time : 123631 payment_date : 20160130 response_code : 00 payment_certificate : 85f495dfc879 authorisation_id : 606018 currency_code : 978 card_number : 5137.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 : jb.chalmey01 order_id : 13387 customer_email : jb.chalmey01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13389" select * from cms_frontusers where identifiant = "v.bedel07" 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 = "13389" select * from cotisations where identifiant = "d.dehove11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 125604 payment_means : VISA transmission_date : 20160130115604 payment_time : 125723 payment_date : 20160130 response_code : 00 payment_certificate : 67e148edbd0b authorisation_id : 145133 currency_code : 978 card_number : 4201.42 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.bedel07 order_id : 13389 customer_email : v.bedel07@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 = "13390" select * from cms_frontusers where identifiant = "p.berrue01" 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 = "13390" select * from cotisations where identifiant = "c.labouesse02" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 130619 payment_means : VISA transmission_date : 20160130120619 payment_time : 131023 payment_date : 20160130 response_code : 00 payment_certificate : c3fa7ca61ade authorisation_id : 123154 currency_code : 978 card_number : 4975.19 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.berrue01 order_id : 13390 customer_email : p.berrue01@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 : 4000 transaction_id : 143247 payment_means : MASTERCARD transmission_date : 20160130133247 payment_time : 143405 payment_date : 20160130 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5341.38 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 : a.claude31 order_id : 13391 customer_email : a.claude31@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 : 4000 transaction_id : 143413 payment_means : MASTERCARD transmission_date : 20160130133413 payment_time : 143534 payment_date : 20160130 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5341.38 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 : a.claude31 order_id : 13391 customer_email : a.claude31@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 = "13392" select * from cms_frontusers where identifiant = "j.petre18" 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 = "13392" select * from cotisations where identifiant = "j.petre18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 144201 payment_means : VISA transmission_date : 20160130134201 payment_time : 144538 payment_date : 20160130 response_code : 00 payment_certificate : 4e8116027b97 authorisation_id : 853638 currency_code : 978 card_number : 4970.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 : j.petre18 order_id : 13392 customer_email : j.petre18@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201611 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13378" select * from cms_frontusers where identifiant = "o.lovichi21" 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 = "13378" select * from cotisations where identifiant = "o.lovichi21" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 110315 payment_means : MASTERCARD transmission_date : 20160130100315 payment_time : 163919 payment_date : 20160130 response_code : 00 payment_certificate : 2ac202f0b11f authorisation_id : 543616 currency_code : 978 card_number : 5136.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 : o.lovichi21 order_id : 13378 customer_email : o.lovichi21@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 = "13394" select * from cms_frontusers where identifiant = "o.lovichi21" 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 = "13394" select * from cotisations where identifiant = "o.lovichi21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 164351 payment_means : MASTERCARD transmission_date : 20160130154351 payment_time : 164607 payment_date : 20160130 response_code : 00 payment_certificate : f3a3965d9d78 authorisation_id : 557730 currency_code : 978 card_number : 5136.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 : o.lovichi21 order_id : 13394 customer_email : o.lovichi21@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 = "13395" select * from cms_frontusers where identifiant = "d.boulanger20" 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 = "13395" select * from cotisations where identifiant = "d.boulanger20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 165136 payment_means : VISA transmission_date : 20160130155136 payment_time : 165428 payment_date : 20160130 response_code : 00 payment_certificate : ae3175c1caf6 authorisation_id : 438527 currency_code : 978 card_number : 4978.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 : d.boulanger20 order_id : 13395 customer_email : d.boulanger20@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 165934 payment_means : VISA transmission_date : 20160130155934 payment_time : 170624 payment_date : 20160130 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.64 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.virich23 order_id : 13396 customer_email : r.virich23@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 : 201602 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13398" select * from cms_frontusers where identifiant = "g.chouly30" 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 = "13398" select * from cotisations where identifiant = "g.chouly30" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 182309 payment_means : MASTERCARD transmission_date : 20160130172309 payment_time : 182634 payment_date : 20160130 response_code : 00 payment_certificate : 36df13fda165 authorisation_id : 812002 currency_code : 978 card_number : 5137.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 : g.chouly30 order_id : 13398 customer_email : g.chouly30@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201801 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13399" select * from cms_frontusers where identifiant = "r.concari11" 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 = "13399" select * from cotisations where identifiant = "r.concari11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185147 payment_means : MASTERCARD transmission_date : 20160130175147 payment_time : 185412 payment_date : 20160130 response_code : 00 payment_certificate : 4d93b09fe77f authorisation_id : 486203 currency_code : 978 card_number : 5131.80 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.concari11 order_id : 13399 customer_email : r.concari11@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 = "13401" select * from cms_frontusers where identifiant = "jp.cavero26" 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 = "13401" select * from cotisations where identifiant = "jp.cavero26" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185909 payment_means : MASTERCARD transmission_date : 20160130175909 payment_time : 190158 payment_date : 20160130 response_code : 00 payment_certificate : 22a252224790 authorisation_id : 112345 currency_code : 978 card_number : 5132.89 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.cavero26 order_id : 13401 customer_email : jp.cavero26@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 = "13402" select * from cms_frontusers where identifiant = "f.ortscheid09" 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 = "13402" select * from cotisations where identifiant = "s.popovitch29" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "p.kieffer28" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "f.rodrigue01" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "t.bisch04" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "m.bleesz08" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 40000 transaction_id : 193341 payment_means : MASTERCARD transmission_date : 20160130183341 payment_time : 193614 payment_date : 20160130 response_code : 00 payment_certificate : d6e7313422c4 authorisation_id : 546842 currency_code : 978 card_number : 5132.70 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.ortscheid09 order_id : 13402 customer_email : f.ortscheid09@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 = "13404" select * from cms_frontusers where identifiant = "e.chartier19" 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 = "13404" select * from cotisations where identifiant = "e.chartier19" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 194604 payment_means : VISA transmission_date : 20160130184604 payment_time : 194910 payment_date : 20160130 response_code : 00 payment_certificate : 184d932d3702 authorisation_id : 174669 currency_code : 978 card_number : 4977.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.chartier19 order_id : 13404 customer_email : e.chartier19@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 : -------------------------------------------