· 8 years ago · Dec 13, 2017, 08:02 AM
1CREATE DATABASE IF NOT EXISTS `gsb_frais` /*!40100 DEFAULT CHARACTER SET latin1 */;
2USE `gsb_frais`;
3-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)
4--
5-- Host: 127.0.0.1 Database: gsb_frais
6-- ------------------------------------------------------
7-- Server version 5.5.5-10.1.26-MariaDB
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12/*!40101 SET NAMES utf8 */;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `comptable`
22--
23
24DROP TABLE IF EXISTS `comptable`;
25/*!40101 SET @saved_cs_client = @@character_set_client */;
26/*!40101 SET character_set_client = utf8 */;
27CREATE TABLE `comptable` (
28 `id` char(3) NOT NULL,
29 `nom` char(30) NOT NULL,
30 `prenom` char(30) NOT NULL,
31 `login` char(20) NOT NULL,
32 `mdp` char(128) NOT NULL,
33 PRIMARY KEY (`id`)
34) ENGINE=InnoDB DEFAULT CHARSET=latin1;
35/*!40101 SET character_set_client = @saved_cs_client */;
36
37--
38-- Dumping data for table `comptable`
39--
40
41LOCK TABLES `comptable` WRITE;
42/*!40000 ALTER TABLE `comptable` DISABLE KEYS */;
43INSERT INTO `comptable` VALUES ('c01','Febvre','Ludovic','lfebvre','4eb954bef4596a8a3ae69bc17d98ac8fa64804ee5e1e3cf569cdb80d1eeea6725a6465ec1ab8c89395745cc359434e0152f2d732b855a5be702ce3aed865dad1'),('c02','Laure','Thomas','tlaure','9b70c07a5d5a3055ea4a1301dbf80d8c303da340cc6ada6dc020a5897876e9bceb73ad8e3f878d13f376d181f6daa4e8a234267881f392fe57856021d28d23f4'),('c03','Delaunay','Loic','ldelaunay','6f506b30000336fc418916fcde48ce0178e965dff0d02c4620c60032e410c42d690c59fee1e662ecaa35576f8fb29b43e1f16c9a4179362f15d56f0687af833d'),('c04','Gil','José','jgil','79dc8a26a612c6f1ea7300b2c844857a100c5c4793a712249b52b96749a7ff1f82f911f9c47804c4a8a40a1530efc150cf388a7b5bddfadb4d839505cf1e22c6'),('c05','Roche','Benoit','broche','f74e5008f372c8e39d95b66c5fa5f390ace2ac7b8095545c842fe6cb437012ea9111381f14f5ce60cd2a890d561f69fa5877ec2c7dadb8c83ffb142d0080fae2');
44/*!40000 ALTER TABLE `comptable` ENABLE KEYS */;
45UNLOCK TABLES;
46
47--
48-- Table structure for table `etat`
49--
50
51DROP TABLE IF EXISTS `etat`;
52/*!40101 SET @saved_cs_client = @@character_set_client */;
53/*!40101 SET character_set_client = utf8 */;
54CREATE TABLE `etat` (
55 `id` char(2) NOT NULL,
56 `libelle` varchar(30) DEFAULT NULL,
57 PRIMARY KEY (`id`)
58) ENGINE=InnoDB DEFAULT CHARSET=latin1;
59/*!40101 SET character_set_client = @saved_cs_client */;
60
61--
62-- Dumping data for table `etat`
63--
64
65LOCK TABLES `etat` WRITE;
66/*!40000 ALTER TABLE `etat` DISABLE KEYS */;
67INSERT INTO `etat` VALUES ('CL','Saisie clôturée'),('CR','Fiche créée, saisie en cours'),('RB','Remboursée'),('VA','Validée et mise en paiement');
68/*!40000 ALTER TABLE `etat` ENABLE KEYS */;
69UNLOCK TABLES;
70
71--
72-- Table structure for table `fichefrais`
73--
74
75DROP TABLE IF EXISTS `fichefrais`;
76/*!40101 SET @saved_cs_client = @@character_set_client */;
77/*!40101 SET character_set_client = utf8 */;
78CREATE TABLE `fichefrais` (
79 `idvisiteur` char(4) NOT NULL,
80 `mois` char(6) NOT NULL,
81 `nbjustificatifs` int(11) DEFAULT NULL,
82 `montantvalide` decimal(10,2) DEFAULT NULL,
83 `datemodif` date DEFAULT NULL,
84 `idetat` char(2) DEFAULT 'CR',
85 PRIMARY KEY (`idvisiteur`,`mois`),
86 KEY `idetat` (`idetat`),
87 CONSTRAINT `fichefrais_ibfk_1` FOREIGN KEY (`idetat`) REFERENCES `etat` (`id`),
88 CONSTRAINT `fichefrais_ibfk_2` FOREIGN KEY (`idvisiteur`) REFERENCES `visiteur` (`id`)
89) ENGINE=InnoDB DEFAULT CHARSET=latin1;
90/*!40101 SET character_set_client = @saved_cs_client */;
91
92--
93-- Dumping data for table `fichefrais`
94--
95
96LOCK TABLES `fichefrais` WRITE;
97/*!40000 ALTER TABLE `fichefrais` DISABLE KEYS */;
98INSERT INTO `fichefrais` VALUES ('a131','201609',8,3157.19,'2016-11-01','RB'),('a131','201610',7,3885.74,'2016-12-01','RB'),('a131','201611',11,3831.82,'2017-01-03','RB'),('a131','201612',10,3565.94,'2017-02-07','RB'),('a131','201701',11,3219.13,'2017-03-06','RB'),('a131','201702',0,1816.03,'2017-04-02','RB'),('a131','201703',1,2254.01,'2017-05-07','RB'),('a131','201704',6,3572.78,'2017-06-07','RB'),('a131','201705',8,4888.24,'2017-07-06','RB'),('a131','201706',9,3543.84,'2017-08-01','RB'),('a131','201707',0,3468.31,'2017-09-05','RB'),('a131','201708',2,5430.98,'2017-10-01','RB'),('a131','201709',10,4260.28,'2017-11-08','RB'),('a131','201710',9,4537.74,'2017-11-04','VA'),('a131','201711',5,0.00,'2017-11-01','CR'),('a131','Janv',1,2532.90,'2017-10-31','RB'),('a17','201609',4,1510.46,'2016-11-04','RB'),('a17','201610',12,2049.16,'2016-12-07','RB'),('a17','201611',8,1799.67,'2017-01-05','RB'),('a17','201612',2,3183.16,'2017-02-08','RB'),('a17','201701',4,1619.53,'2017-03-07','RB'),('a17','201702',9,2736.41,'2017-04-03','RB'),('a17','201703',2,4577.47,'2017-05-08','RB'),('a17','201704',3,4647.95,'2017-06-04','RB'),('a17','201705',8,3986.67,'2017-07-06','RB'),('a17','201706',1,2583.92,'2017-08-06','RB'),('a17','201707',5,5030.94,'2017-09-01','RB'),('a17','201708',8,2875.51,'2017-10-08','RB'),('a17','201709',0,2421.74,'2017-11-07','RB'),('a17','201710',0,1967.47,'2017-11-04','VA'),('a17','201711',12,0.00,'2017-11-07','CR'),('a17','Fev',1,2617.28,'2017-10-30','RB'),('a55','201609',9,4090.70,'2016-11-01','RB'),('a55','201610',8,2194.25,'2016-12-07','RB'),('a55','201611',0,4547.27,'2017-01-08','RB'),('a55','201612',0,3292.85,'2017-02-06','RB'),('a55','201701',8,2054.37,'2017-03-07','RB'),('a55','201702',9,4106.95,'2017-04-04','RB'),('a55','201703',12,3512.63,'2017-05-06','RB'),('a55','201704',0,2702.05,'2017-06-03','RB'),('a55','201705',3,2955.53,'2017-07-05','RB'),('a55','201706',3,2932.36,'2017-08-05','RB'),('a55','201707',9,3184.60,'2017-09-07','RB'),('a55','201708',7,3304.05,'2017-10-03','RB'),('a55','201709',1,3533.86,'2017-11-05','RB'),('a55','201710',8,4498.10,'2017-11-02','VA'),('a55','201711',0,0.00,'2017-11-02','CR'),('a55','Mars',1,1803.25,'2017-10-29','RB'),('a93','201609',12,2831.01,'2016-11-08','RB'),('a93','201610',11,2264.77,'2016-12-02','RB'),('a93','201611',1,4488.13,'2017-01-06','RB'),('a93','201612',3,2583.41,'2017-02-01','RB'),('a93','201701',1,3326.36,'2017-03-07','RB'),('a93','201702',3,4131.65,'2017-04-03','RB'),('a93','201703',11,2279.65,'2017-05-03','RB'),('a93','201704',4,4258.01,'2017-06-05','RB'),('a93','201705',9,2524.10,'2017-07-06','RB'),('a93','201706',6,3473.37,'2017-08-04','RB'),('a93','201707',0,2767.76,'2017-09-08','RB'),('a93','201708',12,1991.17,'2017-10-04','RB'),('a93','201709',10,3562.16,'2017-11-08','RB'),('a93','201710',0,3016.05,'2017-11-08','VA'),('a93','201711',6,0.00,'2017-11-01','CR'),('a93','Avril',1,2488.84,'2017-10-28','RB'),('b13','201609',6,3955.48,'2016-11-04','RB'),('b13','201610',5,2335.85,'2016-12-04','RB'),('b13','201611',10,3140.77,'2017-01-06','RB'),('b13','201612',10,3860.64,'2017-02-02','RB'),('b13','201701',0,2411.47,'2017-03-08','RB'),('b13','201702',4,3641.89,'2017-04-06','RB'),('b13','201703',11,3393.19,'2017-05-08','RB'),('b13','201704',0,4193.32,'2017-06-02','RB'),('b13','201705',2,3939.18,'2017-07-02','RB'),('b13','201706',11,2859.08,'2017-08-03','RB'),('b13','201707',1,2685.59,'2017-09-02','RB'),('b13','201708',2,3523.77,'2017-10-06','RB'),('b13','201709',0,3913.80,'2017-11-08','RB'),('b13','201710',8,4288.20,'2017-11-08','VA'),('b13','201711',8,0.00,'2017-11-08','CR'),('b13','Mai',1,1929.58,'2017-10-27','RB'),('b16','201609',0,1972.54,'2016-11-05','RB'),('b16','201610',11,4034.78,'2016-12-07','RB'),('b16','201611',5,3873.64,'2017-01-07','RB'),('b16','201612',11,3665.22,'2017-02-02','RB'),('b16','201701',7,3020.97,'2017-03-03','RB'),('b16','201702',2,4152.82,'2017-04-07','RB'),('b16','201703',4,3150.91,'2017-05-02','RB'),('b16','201704',8,2428.87,'2017-06-08','RB'),('b16','201705',1,4128.59,'2017-07-08','RB'),('b16','201706',6,2908.90,'2017-08-04','RB'),('b16','201707',10,3698.60,'2017-09-01','RB'),('b16','201708',10,2687.91,'2017-10-08','RB'),('b16','201709',12,4346.26,'2017-11-05','RB'),('b16','201710',7,3689.73,'2017-11-06','VA'),('b16','201711',2,0.00,'2017-11-05','CR'),('b19','201609',5,2911.46,'2016-11-05','RB'),('b19','201610',9,997.00,'2016-12-05','RB'),('b19','201611',6,4567.15,'2017-01-07','RB'),('b19','201612',4,2726.75,'2017-02-05','RB'),('b19','201701',8,2209.64,'2017-03-08','RB'),('b19','201702',3,4052.60,'2017-04-01','RB'),('b19','201703',10,2371.32,'2017-05-01','RB'),('b19','201704',1,5943.42,'2017-06-07','RB'),('b19','201705',3,2892.15,'2017-07-04','RB'),('b19','201706',8,1425.60,'2017-08-05','RB'),('b19','201707',4,2964.83,'2017-09-05','RB'),('b19','201708',5,2651.41,'2017-10-08','RB'),('b19','201709',12,4279.14,'2017-11-04','RB'),('b19','201710',2,3549.44,'2017-11-08','VA'),('b19','201711',1,0.00,'2017-11-01','CR'),('b25','201609',4,5025.96,'2016-11-08','RB'),('b25','201610',5,2976.37,'2016-12-02','RB'),('b25','201611',1,3862.60,'2017-01-06','RB'),('b25','201612',12,3676.06,'2017-02-04','RB'),('b25','201701',1,3449.58,'2017-03-04','RB'),('b25','201702',8,2040.58,'2017-04-04','RB'),('b25','201703',9,3240.18,'2017-05-07','RB'),('b25','201704',7,3949.05,'2017-06-04','RB'),('b25','201705',11,3226.61,'2017-07-08','RB'),('b25','201706',9,3202.66,'2017-08-04','RB'),('b25','201707',7,2568.38,'2017-09-03','RB'),('b25','201708',2,2856.56,'2017-10-06','RB'),('b25','201709',3,3180.67,'2017-11-04','RB'),('b25','201710',0,4159.48,'2017-11-02','VA'),('b25','201711',1,0.00,'2017-11-02','CR'),('b28','201609',5,2662.59,'2016-11-04','RB'),('b28','201610',9,2833.45,'2016-12-03','RB'),('b28','201611',11,3525.98,'2017-01-03','RB'),('b28','201612',5,4054.97,'2017-02-07','RB'),('b28','201701',10,3224.61,'2017-03-04','RB'),('b28','201702',0,2872.92,'2017-04-03','RB'),('b28','201703',10,4297.81,'2017-05-08','RB'),('b28','201704',12,3843.47,'2017-06-04','RB'),('b28','201705',6,3590.60,'2017-07-02','RB'),('b28','201706',5,3378.66,'2017-08-03','RB'),('b28','201707',3,2937.64,'2017-09-05','RB'),('b28','201708',6,3458.38,'2017-10-06','RB'),('b28','201709',11,3026.97,'2017-11-07','RB'),('b28','201710',6,2047.89,'2017-11-06','VA'),('b28','201711',6,0.00,'2017-11-03','CR'),('b34','201609',1,1578.74,'2016-11-08','RB'),('b34','201610',5,3752.16,'2016-12-02','RB'),('b34','201611',11,4084.58,'2017-01-06','RB'),('b34','201612',6,2935.53,'2017-02-03','RB'),('b34','201701',4,3291.25,'2017-03-07','RB'),('b34','201702',12,3182.26,'2017-04-02','RB'),('b34','201703',3,2602.87,'2017-05-06','RB'),('b34','201704',2,2572.67,'2017-06-01','RB'),('b34','201705',1,3401.57,'2017-07-05','RB'),('b34','201706',2,3424.59,'2017-08-06','RB'),('b34','201707',8,2906.68,'2017-09-08','RB'),('b34','201708',6,4738.42,'2017-10-06','RB'),('b34','201709',2,1324.92,'2017-11-03','RB'),('b34','201710',10,3328.00,'2017-11-07','VA'),('b34','201711',0,0.00,'2017-11-02','CR'),('b4','201609',7,4550.39,'2016-11-07','RB'),('b4','201610',7,4542.73,'2016-12-06','RB'),('b4','201611',0,1844.86,'2017-01-07','RB'),('b4','201612',6,2874.85,'2017-02-03','RB'),('b4','201701',6,3915.03,'2017-03-05','RB'),('b4','201702',3,3088.87,'2017-04-06','RB'),('b4','201703',9,1874.64,'2017-05-05','RB'),('b4','201704',8,3767.73,'2017-06-07','RB'),('b4','201705',2,4014.33,'2017-07-01','RB'),('b4','201706',4,2232.22,'2017-08-03','RB'),('b4','201707',5,3611.31,'2017-09-01','RB'),('b4','201708',8,3669.59,'2017-10-06','RB'),('b4','201709',12,6829.09,'2017-11-04','RB'),('b4','201710',2,3504.72,'2017-11-06','VA'),('b4','201711',8,0.00,'2017-11-03','CR'),('b50','201609',5,2616.59,'2016-11-01','RB'),('b50','201610',11,1983.08,'2016-12-06','RB'),('b50','201611',10,4306.34,'2017-01-02','RB'),('b50','201612',4,5324.06,'2017-02-05','RB'),('b50','201701',1,3586.92,'2017-03-07','RB'),('b50','201702',6,3252.25,'2017-04-02','RB'),('b50','201703',12,2787.70,'2017-05-03','RB'),('b50','201704',7,2346.95,'2017-06-02','RB'),('b50','201705',0,3659.52,'2017-07-03','RB'),('b50','201706',2,2834.55,'2017-08-08','RB'),('b50','201707',5,2891.79,'2017-09-06','RB'),('b50','201708',3,2486.02,'2017-10-05','RB'),('b50','201709',2,1837.69,'2017-11-05','RB'),('b50','201710',8,3544.73,'2017-11-04','VA'),('b50','201711',12,0.00,'2017-11-03','CR'),('b59','201609',1,4061.93,'2016-11-07','RB'),('b59','201610',8,4443.06,'2016-12-04','RB'),('b59','201611',10,2066.54,'2017-01-01','RB'),('b59','201612',9,3220.01,'2017-02-06','RB'),('b59','201701',9,3371.01,'2017-03-08','RB'),('b59','201702',8,2571.71,'2017-04-02','RB'),('b59','201703',8,2500.31,'2017-05-06','RB'),('b59','201704',9,2932.29,'2017-06-01','RB'),('b59','201705',5,3261.87,'2017-07-03','RB'),('b59','201706',8,2680.02,'2017-08-01','RB'),('b59','201707',7,2350.82,'2017-09-06','RB'),('b59','201708',9,1667.37,'2017-10-02','RB'),('b59','201709',9,2112.61,'2017-11-04','RB'),('b59','201710',10,3192.69,'2017-11-03','VA'),('b59','201711',12,0.00,'2017-11-05','CR'),('c14','201609',1,2517.19,'2016-11-08','RB'),('c14','201610',7,2721.88,'2016-12-02','RB'),('c14','201611',9,2983.64,'2017-01-05','RB'),('c14','201612',1,3720.39,'2017-02-08','RB'),('c14','201701',0,1254.13,'2017-03-05','RB'),('c14','201702',12,4418.83,'2017-04-04','RB'),('c14','201703',9,2497.13,'2017-05-01','RB'),('c14','201704',9,2471.68,'2017-06-03','RB'),('c14','201705',5,4039.76,'2017-07-03','RB'),('c14','201706',10,2462.95,'2017-08-03','RB'),('c14','201707',11,1820.10,'2017-09-03','RB'),('c14','201708',4,4403.75,'2017-10-01','RB'),('c14','201709',9,4076.58,'2017-11-08','RB'),('c14','201710',6,2876.81,'2017-11-03','VA'),('c14','201711',5,0.00,'2017-11-03','CR'),('c3','201609',9,1894.06,'2016-11-01','RB'),('c3','201610',1,4028.21,'2016-12-08','RB'),('c3','201611',3,2112.99,'2017-01-05','RB'),('c3','201612',12,5281.44,'2017-02-04','RB'),('c3','201701',3,4505.57,'2017-03-05','RB'),('c3','201702',9,3840.00,'2017-04-07','RB'),('c3','201703',10,4117.61,'2017-05-03','RB'),('c3','201704',3,3739.39,'2017-06-02','RB'),('c3','201705',9,3090.88,'2017-07-08','RB'),('c3','201706',9,2977.63,'2017-08-02','RB'),('c3','201707',9,2991.67,'2017-09-06','RB'),('c3','201708',8,2928.64,'2017-10-02','RB'),('c3','201709',2,2690.27,'2017-11-01','RB'),('c3','201710',6,1843.81,'2017-11-04','VA'),('c3','201711',3,0.00,'2017-11-08','CR'),('c54','201609',8,3007.42,'2016-11-08','RB'),('c54','201610',9,3035.93,'2016-12-05','RB'),('c54','201611',11,3051.52,'2017-01-03','RB'),('c54','201612',6,3194.24,'2017-02-03','RB'),('c54','201701',1,4326.76,'2017-03-05','RB'),('c54','201702',9,2510.24,'2017-04-02','RB'),('c54','201703',0,3219.42,'2017-05-03','RB'),('c54','201704',3,4708.36,'2017-06-03','RB'),('c54','201705',2,4156.31,'2017-07-03','RB'),('c54','201706',1,1447.06,'2017-08-02','RB'),('c54','201707',11,3433.14,'2017-09-08','RB'),('c54','201708',7,3969.39,'2017-10-02','RB'),('c54','201709',12,1869.82,'2017-11-05','RB'),('c54','201710',6,3733.52,'2017-11-04','VA'),('c54','201711',8,0.00,'2017-11-07','CR'),('d13','201609',8,2521.22,'2016-11-01','RB'),('d13','201610',3,3884.60,'2016-12-05','RB'),('d13','201611',4,1814.47,'2017-01-05','RB'),('d13','201612',0,3254.02,'2017-02-04','RB'),('d13','201701',8,4003.15,'2017-03-05','RB'),('d13','201702',8,2388.57,'2017-04-02','RB'),('d13','201703',10,2826.51,'2017-05-05','RB'),('d13','201704',1,2189.92,'2017-06-04','RB'),('d13','201705',3,2658.65,'2017-07-01','RB'),('d13','201706',5,4696.13,'2017-08-08','RB'),('d13','201707',0,2243.38,'2017-09-01','RB'),('d13','201708',5,2401.89,'2017-10-07','RB'),('d13','201709',6,3298.78,'2017-11-07','RB'),('d13','201710',3,2698.85,'2017-11-02','VA'),('d13','201711',2,0.00,'2017-11-03','CR'),('d51','201609',11,4937.89,'2016-11-04','RB'),('d51','201610',1,2725.13,'2016-12-07','RB'),('d51','201611',1,2759.31,'2017-01-05','RB'),('d51','201612',8,2815.80,'2017-02-08','RB'),('d51','201701',11,3304.69,'2017-03-03','RB'),('d51','201702',1,2914.00,'2017-04-07','RB'),('d51','201703',8,4495.78,'2017-05-03','RB'),('d51','201704',5,3826.33,'2017-06-03','RB'),('d51','201705',9,2543.75,'2017-07-02','RB'),('d51','201706',8,2760.20,'2017-08-05','RB'),('d51','201707',1,3091.62,'2017-09-07','RB'),('d51','201708',2,1950.50,'2017-10-02','RB'),('d51','201709',3,3726.20,'2017-11-06','RB'),('d51','201710',11,4006.29,'2017-11-06','VA'),('d51','201711',7,0.00,'2017-11-02','CR'),('e22','201609',10,2634.95,'2016-11-06','RB'),('e22','201610',3,4050.96,'2016-12-03','RB'),('e22','201611',10,4229.95,'2017-01-01','RB'),('e22','201612',1,3150.69,'2017-02-07','RB'),('e22','201701',5,2907.96,'2017-03-04','RB'),('e22','201702',5,5178.92,'2017-04-08','RB'),('e22','201703',7,2293.92,'2017-05-07','RB'),('e22','201704',2,2548.04,'2017-06-03','RB'),('e22','201705',8,1782.50,'2017-07-05','RB'),('e22','201706',3,6209.28,'2017-08-03','RB'),('e22','201707',9,2544.92,'2017-09-03','RB'),('e22','201708',7,2371.98,'2017-10-03','RB'),('e22','201709',0,2078.78,'2017-11-02','RB'),('e22','201710',0,3354.13,'2017-11-02','VA'),('e22','201711',3,0.00,'2017-11-08','CR'),('e24','201609',12,2200.76,'2016-11-03','RB'),('e24','201610',1,3127.79,'2016-12-06','RB'),('e24','201611',3,2735.07,'2017-01-06','RB'),('e24','201612',3,2834.10,'2017-02-06','RB'),('e24','201701',2,4437.52,'2017-03-06','RB'),('e24','201702',0,1880.60,'2017-04-05','RB'),('e24','201703',11,3382.86,'2017-05-03','RB'),('e24','201704',12,4075.97,'2017-06-08','RB'),('e24','201705',6,1383.64,'2017-07-05','RB'),('e24','201706',12,3055.85,'2017-08-07','RB'),('e24','201707',6,1770.78,'2017-09-05','RB'),('e24','201708',3,2950.28,'2017-10-06','RB'),('e24','201709',8,2856.44,'2017-11-01','RB'),('e24','201710',11,2791.53,'2017-11-02','VA'),('e24','201711',4,0.00,'2017-11-02','CR'),('e39','201609',0,4601.97,'2016-11-02','RB'),('e39','201610',10,1515.32,'2016-12-01','RB'),('e39','201611',3,1949.80,'2017-01-06','RB'),('e39','201612',11,2418.74,'2017-02-01','RB'),('e39','201701',12,3557.57,'2017-03-07','RB'),('e39','201702',1,3872.82,'2017-04-04','RB'),('e39','201703',10,5044.90,'2017-05-02','RB'),('e39','201704',7,2720.79,'2017-06-03','RB'),('e39','201705',12,2886.16,'2017-07-01','RB'),('e39','201706',11,2194.24,'2017-08-04','RB'),('e39','201707',11,2354.74,'2017-09-02','RB'),('e39','201708',6,3645.14,'2017-10-07','RB'),('e39','201709',2,2129.07,'2017-11-07','RB'),('e39','201710',8,2884.38,'2017-11-06','VA'),('e39','201711',9,0.00,'2017-11-02','CR'),('e49','201609',9,1941.97,'2016-11-02','RB'),('e49','201610',9,3705.01,'2016-12-05','RB'),('e49','201611',5,5250.62,'2017-01-07','RB'),('e49','201612',11,3651.70,'2017-02-06','RB'),('e49','201701',0,4048.74,'2017-03-06','RB'),('e49','201702',11,3637.85,'2017-04-05','RB'),('e49','201703',12,1415.26,'2017-05-02','RB'),('e49','201704',10,4050.43,'2017-06-04','RB'),('e49','201705',6,3170.27,'2017-07-01','RB'),('e49','201706',2,2319.00,'2017-08-08','RB'),('e49','201707',7,3510.40,'2017-09-06','RB'),('e49','201708',0,3489.79,'2017-10-01','RB'),('e49','201709',12,4402.40,'2017-11-05','RB'),('e49','201710',12,2342.34,'2017-11-03','VA'),('e49','201711',8,0.00,'2017-11-05','CR'),('e5','201609',6,2105.42,'2016-11-05','RB'),('e5','201610',0,3745.88,'2016-12-04','RB'),('e5','201611',1,3255.35,'2017-01-08','RB'),('e5','201612',0,3423.60,'2017-02-04','RB'),('e5','201701',11,4969.58,'2017-03-03','RB'),('e5','201702',9,2885.81,'2017-04-08','RB'),('e5','201703',1,3359.03,'2017-05-01','RB'),('e5','201704',2,2453.02,'2017-06-01','RB'),('e5','201705',5,4280.79,'2017-07-06','RB'),('e5','201706',9,1055.47,'2017-08-08','RB'),('e5','201707',2,2485.73,'2017-09-06','RB'),('e5','201708',8,3913.96,'2017-10-05','RB'),('e5','201709',6,3686.26,'2017-11-08','RB'),('e5','201710',1,2080.88,'2017-11-06','VA'),('e5','201711',8,0.00,'2017-11-08','CR'),('e52','201609',1,2399.95,'2016-11-01','RB'),('e52','201610',2,3203.89,'2016-12-01','RB'),('e52','201611',11,5104.18,'2017-01-07','RB'),('e52','201612',5,3635.89,'2017-02-05','RB'),('e52','201701',9,1487.00,'2017-03-08','RB'),('e52','201702',9,3447.77,'2017-04-06','RB'),('e52','201703',5,2711.37,'2017-05-06','RB'),('e52','201704',1,3658.18,'2017-06-07','RB'),('e52','201705',6,2112.96,'2017-07-03','RB'),('e52','201706',9,2323.78,'2017-08-06','RB'),('e52','201707',6,2363.07,'2017-09-01','RB'),('e52','201708',7,2260.39,'2017-10-06','RB'),('e52','201709',9,1502.42,'2017-11-01','RB'),('e52','201710',0,3662.53,'2017-11-04','VA'),('e52','201711',0,0.00,'2017-11-07','CR'),('f21','201609',10,5009.76,'2016-11-08','RB'),('f21','201610',1,3629.88,'2016-12-08','RB'),('f21','201611',8,3602.19,'2017-01-08','RB'),('f21','201612',12,2266.58,'2017-02-02','RB'),('f21','201701',5,2274.02,'2017-03-07','RB'),('f21','201702',4,3035.06,'2017-04-07','RB'),('f21','201703',9,1687.74,'2017-05-03','RB'),('f21','201704',9,3338.35,'2017-06-06','RB'),('f21','201705',10,4233.41,'2017-07-07','RB'),('f21','201706',0,2250.31,'2017-08-02','RB'),('f21','201707',4,2440.28,'2017-09-08','RB'),('f21','201708',2,2199.20,'2017-10-06','RB'),('f21','201709',0,4293.11,'2017-11-04','RB'),('f21','201710',3,2581.20,'2017-11-04','VA'),('f21','201711',6,0.00,'2017-11-05','CR'),('f39','201609',9,2760.08,'2016-11-02','RB'),('f39','201610',5,2300.80,'2016-12-06','RB'),('f39','201611',5,2803.45,'2017-01-02','RB'),('f39','201612',10,5333.05,'2017-02-07','RB'),('f39','201701',12,3164.64,'2017-03-01','RB'),('f39','201702',9,4022.66,'2017-04-04','RB'),('f39','201703',4,2873.71,'2017-05-04','RB'),('f39','201704',0,3220.33,'2017-06-07','RB'),('f39','201705',5,2342.00,'2017-07-05','RB'),('f39','201706',7,4538.58,'2017-08-08','RB'),('f39','201707',1,4237.37,'2017-09-08','RB'),('f39','201708',12,3556.39,'2017-10-02','RB'),('f39','201709',11,4101.89,'2017-11-02','RB'),('f39','201710',6,2040.23,'2017-11-03','VA'),('f39','201711',1,0.00,'2017-11-04','CR'),('f4','201609',1,3097.27,'2016-11-01','RB'),('f4','201610',1,2920.55,'2016-12-06','RB'),('f4','201611',12,4010.04,'2017-01-07','RB'),('f4','201612',0,2964.96,'2017-02-05','RB'),('f4','201701',10,3721.00,'2017-03-07','RB'),('f4','201702',9,2208.26,'2017-04-03','RB'),('f4','201703',12,1489.92,'2017-05-04','RB'),('f4','201704',2,3177.88,'2017-06-05','RB'),('f4','201705',3,3131.32,'2017-07-06','RB'),('f4','201706',10,2831.65,'2017-08-08','RB'),('f4','201707',5,3962.33,'2017-09-07','RB'),('f4','201708',1,3638.16,'2017-10-01','RB'),('f4','201709',12,2941.21,'2017-11-07','RB'),('f4','201710',10,4572.52,'2017-11-03','VA'),('f4','201711',8,0.00,'2017-11-02','CR');
99/*!40000 ALTER TABLE `fichefrais` ENABLE KEYS */;
100UNLOCK TABLES;
101
102--
103-- Table structure for table `fraisforfait`
104--
105
106DROP TABLE IF EXISTS `fraisforfait`;
107/*!40101 SET @saved_cs_client = @@character_set_client */;
108/*!40101 SET character_set_client = utf8 */;
109CREATE TABLE `fraisforfait` (
110 `id` char(3) NOT NULL,
111 `libelle` char(40) DEFAULT NULL,
112 `montant` decimal(5,2) DEFAULT NULL,
113 PRIMARY KEY (`id`)
114) ENGINE=InnoDB DEFAULT CHARSET=latin1;
115/*!40101 SET character_set_client = @saved_cs_client */;
116
117--
118-- Dumping data for table `fraisforfait`
119--
120
121LOCK TABLES `fraisforfait` WRITE;
122/*!40000 ALTER TABLE `fraisforfait` DISABLE KEYS */;
123INSERT INTO `fraisforfait` VALUES ('ETP','Forfait Etape',110.00),('KM','Frais Kilométrique',0.52),('NUI','Nuitée Hôtel',80.00),('REP','Repas Restaurant',25.00);
124/*!40000 ALTER TABLE `fraisforfait` ENABLE KEYS */;
125UNLOCK TABLES;
126
127--
128-- Table structure for table `fraisvalides`
129--
130
131DROP TABLE IF EXISTS `fraisvalides`;
132/*!40101 SET @saved_cs_client = @@character_set_client */;
133/*!40101 SET character_set_client = utf8 */;
134CREATE TABLE `fraisvalides` (
135 `id` int(11) NOT NULL AUTO_INCREMENT,
136 `visiteur` varchar(50) NOT NULL,
137 `montantforfait` int(11) NOT NULL,
138 `montanthorsforfait` int(11) NOT NULL,
139 `mois` char(4) NOT NULL,
140 `total` int(11) NOT NULL,
141 PRIMARY KEY (`id`)
142) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
143/*!40101 SET character_set_client = @saved_cs_client */;
144
145--
146-- Dumping data for table `fraisvalides`
147--
148
149LOCK TABLES `fraisvalides` WRITE;
150/*!40000 ALTER TABLE `fraisvalides` DISABLE KEYS */;
151INSERT INTO `fraisvalides` VALUES (1,'Villechalane Louis',150,50,'janv',200),(2,'Andre David',200,60,'fev',260);
152/*!40000 ALTER TABLE `fraisvalides` ENABLE KEYS */;
153UNLOCK TABLES;
154
155--
156-- Table structure for table `lignefraisforfait`
157--
158
159DROP TABLE IF EXISTS `lignefraisforfait`;
160/*!40101 SET @saved_cs_client = @@character_set_client */;
161/*!40101 SET character_set_client = utf8 */;
162CREATE TABLE `lignefraisforfait` (
163 `idvisiteur` char(4) NOT NULL,
164 `mois` char(6) NOT NULL,
165 `idfraisforfait` char(4) NOT NULL,
166 `quantite` int(11) DEFAULT NULL,
167 PRIMARY KEY (`idvisiteur`,`mois`,`idfraisforfait`),
168 KEY `idfraisforfait` (`idfraisforfait`),
169 CONSTRAINT `lignefraisforfait_ibfk_1` FOREIGN KEY (`idvisiteur`, `mois`) REFERENCES `fichefrais` (`idvisiteur`, `mois`),
170 CONSTRAINT `lignefraisforfait_ibfk_2` FOREIGN KEY (`idfraisforfait`) REFERENCES `fraisforfait` (`id`)
171) ENGINE=InnoDB DEFAULT CHARSET=latin1;
172/*!40101 SET character_set_client = @saved_cs_client */;
173
174--
175-- Dumping data for table `lignefraisforfait`
176--
177
178LOCK TABLES `lignefraisforfait` WRITE;
179/*!40000 ALTER TABLE `lignefraisforfait` DISABLE KEYS */;
180INSERT INTO `lignefraisforfait` VALUES ('a131','201609','ETP',12),('a131','201609','KM',568),('a131','201609','NUI',10),('a131','201609','REP',16),('a131','201610','ETP',16),('a131','201610','KM',719),('a131','201610','NUI',17),('a131','201610','REP',5),('a131','201611','ETP',17),('a131','201611','KM',587),('a131','201611','NUI',17),('a131','201611','REP',19),('a131','201612','ETP',16),('a131','201612','KM',885),('a131','201612','NUI',15),('a131','201612','REP',4),('a131','201701','ETP',7),('a131','201701','KM',775),('a131','201701','NUI',20),('a131','201701','REP',10),('a131','201702','ETP',3),('a131','201702','KM',977),('a131','201702','NUI',6),('a131','201702','REP',10),('a131','201703','ETP',7),('a131','201703','KM',432),('a131','201703','NUI',3),('a131','201703','REP',19),('a131','201704','ETP',7),('a131','201704','KM',838),('a131','201704','NUI',14),('a131','201704','REP',13),('a131','201705','ETP',15),('a131','201705','KM',821),('a131','201705','NUI',17),('a131','201705','REP',11),('a131','201706','ETP',18),('a131','201706','KM',340),('a131','201706','NUI',7),('a131','201706','REP',19),('a131','201707','ETP',16),('a131','201707','KM',846),('a131','201707','NUI',18),('a131','201707','REP',14),('a131','201708','ETP',18),('a131','201708','KM',667),('a131','201708','NUI',20),('a131','201708','REP',9),('a131','201709','ETP',7),('a131','201709','KM',552),('a131','201709','NUI',13),('a131','201709','REP',20),('a131','201710','ETP',20),('a131','201710','KM',951),('a131','201710','NUI',18),('a131','201710','REP',20),('a131','201711','ETP',7),('a131','201711','KM',667),('a131','201711','NUI',8),('a131','201711','REP',6),('a131','Janv','ETP',10),('a131','Janv','KM',968),('a131','Janv','NUI',11),('a131','Janv','REP',4),('a17','201609','ETP',5),('a17','201609','KM',408),('a17','201609','NUI',4),('a17','201609','REP',4),('a17','201610','ETP',8),('a17','201610','KM',483),('a17','201610','NUI',7),('a17','201610','REP',2),('a17','201611','ETP',4),('a17','201611','KM',664),('a17','201611','NUI',3),('a17','201611','REP',12),('a17','201612','ETP',18),('a17','201612','KM',599),('a17','201612','NUI',14),('a17','201612','REP',7),('a17','201701','ETP',2),('a17','201701','KM',362),('a17','201701','NUI',4),('a17','201701','REP',2),('a17','201702','ETP',19),('a17','201702','KM',414),('a17','201702','NUI',4),('a17','201702','REP',2),('a17','201703','ETP',12),('a17','201703','KM',335),('a17','201703','NUI',20),('a17','201703','REP',16),('a17','201704','ETP',17),('a17','201704','KM',390),('a17','201704','NUI',15),('a17','201704','REP',12),('a17','201705','ETP',18),('a17','201705','KM',448),('a17','201705','NUI',14),('a17','201705','REP',15),('a17','201706','ETP',5),('a17','201706','KM',958),('a17','201706','NUI',10),('a17','201706','REP',9),('a17','201707','ETP',15),('a17','201707','KM',953),('a17','201707','NUI',13),('a17','201707','REP',18),('a17','201708','ETP',12),('a17','201708','KM',541),('a17','201708','NUI',4),('a17','201708','REP',6),('a17','201709','ETP',10),('a17','201709','KM',485),('a17','201709','NUI',5),('a17','201709','REP',17),('a17','201710','ETP',4),('a17','201710','KM',929),('a17','201710','NUI',9),('a17','201710','REP',10),('a17','201711','ETP',6),('a17','201711','KM',513),('a17','201711','NUI',12),('a17','201711','REP',20),('a17','Fev','ETP',7),('a17','Fév','KM',11),('a17','Fev','NUI',13),('a17','Fev','REP',8),('a55','201609','ETP',18),('a55','201609','KM',601),('a55','201609','NUI',9),('a55','201609','REP',17),('a55','201610','ETP',3),('a55','201610','KM',384),('a55','201610','NUI',13),('a55','201610','REP',11),('a55','201611','ETP',16),('a55','201611','KM',951),('a55','201611','NUI',15),('a55','201611','REP',6),('a55','201612','ETP',19),('a55','201612','KM',594),('a55','201612','NUI',5),('a55','201612','REP',10),('a55','201701','ETP',6),('a55','201701','KM',489),('a55','201701','NUI',9),('a55','201701','REP',17),('a55','201702','ETP',3),('a55','201702','KM',889),('a55','201702','NUI',20),('a55','201702','REP',10),('a55','201703','ETP',5),('a55','201703','KM',666),('a55','201703','NUI',19),('a55','201703','REP',9),('a55','201704','ETP',6),('a55','201704','KM',764),('a55','201704','NUI',7),('a55','201704','REP',19),('a55','201705','ETP',4),('a55','201705','KM',840),('a55','201705','NUI',17),('a55','201705','REP',19),('a55','201706','ETP',12),('a55','201706','KM',548),('a55','201706','NUI',16),('a55','201706','REP',2),('a55','201707','ETP',10),('a55','201707','KM',847),('a55','201707','NUI',16),('a55','201707','REP',16),('a55','201708','ETP',7),('a55','201708','KM',861),('a55','201708','NUI',16),('a55','201708','REP',3),('a55','201709','ETP',6),('a55','201709','KM',924),('a55','201709','NUI',16),('a55','201709','REP',17),('a55','201710','ETP',15),('a55','201710','KM',802),('a55','201710','NUI',20),('a55','201710','REP',2),('a55','201711','ETP',10),('a55','201711','KM',568),('a55','201711','NUI',3),('a55','201711','REP',10),('a55','Mars','ETP',7),('a55','Mars','KM',15),('a55','Mars','NUI',3),('a55','Mars','REP',18),('a93','201609','ETP',16),('a93','201609','KM',613),('a93','201609','NUI',17),('a93','201609','REP',4),('a93','201610','ETP',3),('a93','201610','KM',922),('a93','201610','NUI',19),('a93','201610','REP',11),('a93','201611','ETP',19),('a93','201611','KM',436),('a93','201611','NUI',9),('a93','201611','REP',19),('a93','201612','ETP',7),('a93','201612','KM',347),('a93','201612','NUI',13),('a93','201612','REP',3),('a93','201701','ETP',8),('a93','201701','KM',773),('a93','201701','NUI',17),('a93','201701','REP',11),('a93','201702','ETP',17),('a93','201702','KM',871),('a93','201702','NUI',6),('a93','201702','REP',17),('a93','201703','ETP',19),('a93','201703','KM',903),('a93','201703','NUI',3),('a93','201703','REP',2),('a93','201704','ETP',10),('a93','201704','KM',656),('a93','201704','NUI',19),('a93','201704','REP',12),('a93','201705','ETP',7),('a93','201705','KM',333),('a93','201705','NUI',13),('a93','201705','REP',16),('a93','201706','ETP',15),('a93','201706','KM',765),('a93','201706','NUI',13),('a93','201706','REP',3),('a93','201707','ETP',4),('a93','201707','KM',641),('a93','201707','NUI',8),('a93','201707','REP',7),('a93','201708','ETP',7),('a93','201708','KM',564),('a93','201708','NUI',6),('a93','201708','REP',17),('a93','201709','ETP',11),('a93','201709','KM',858),('a93','201709','NUI',6),('a93','201709','REP',17),('a93','201710','ETP',5),('a93','201710','KM',951),('a93','201710','NUI',19),('a93','201710','REP',18),('a93','201711','ETP',15),('a93','201711','KM',618),('a93','201711','NUI',6),('a93','201711','REP',17),('a93','Avril','ETP',10),('a93','Avril','KM',932),('a93','Avril','NUI',6),('a93','Avril','REP',11),('b13','201609','ETP',16),('b13','201609','KM',474),('b13','201609','NUI',12),('b13','201609','REP',11),('b13','201610','ETP',12),('b13','201610','KM',339),('b13','201610','NUI',9),('b13','201610','REP',15),('b13','201611','ETP',3),('b13','201611','KM',604),('b13','201611','NUI',13),('b13','201611','REP',11),('b13','201612','ETP',20),('b13','201612','KM',626),('b13','201612','NUI',13),('b13','201612','REP',12),('b13','201701','ETP',6),('b13','201701','KM',826),('b13','201701','NUI',6),('b13','201701','REP',18),('b13','201702','ETP',9),('b13','201702','KM',432),('b13','201702','NUI',12),('b13','201702','REP',14),('b13','201703','ETP',2),('b13','201703','KM',897),('b13','201703','NUI',14),('b13','201703','REP',13),('b13','201704','ETP',4),('b13','201704','KM',548),('b13','201704','NUI',18),('b13','201704','REP',5),('b13','201705','ETP',20),('b13','201705','KM',511),('b13','201705','NUI',17),('b13','201705','REP',14),('b13','201706','ETP',8),('b13','201706','KM',463),('b13','201706','NUI',13),('b13','201706','REP',20),('b13','201707','ETP',13),('b13','201707','KM',936),('b13','201707','NUI',4),('b13','201707','REP',5),('b13','201708','ETP',16),('b13','201708','KM',673),('b13','201708','NUI',14),('b13','201708','REP',19),('b13','201709','ETP',8),('b13','201709','KM',564),('b13','201709','NUI',20),('b13','201709','REP',13),('b13','201710','ETP',20),('b13','201710','KM',439),('b13','201710','NUI',20),('b13','201710','REP',4),('b13','201711','ETP',16),('b13','201711','KM',876),('b13','201711','NUI',8),('b13','201711','REP',11),('b13','Mai','ETP',3),('b13','Mai','KM',923),('b13','Mai','NUI',11),('b13','Mai','REP',5),('b16','201609','ETP',14),('b16','201609','KM',512),('b16','201609','NUI',5),('b16','201609','REP',4),('b16','201610','ETP',20),('b16','201610','KM',809),('b16','201610','NUI',20),('b16','201610','REP',13),('b16','201611','ETP',7),('b16','201611','KM',835),('b16','201611','NUI',16),('b16','201611','REP',5),('b16','201612','ETP',20),('b16','201612','KM',443),('b16','201612','NUI',6),('b16','201612','REP',14),('b16','201701','ETP',7),('b16','201701','KM',749),('b16','201701','NUI',7),('b16','201701','REP',5),('b16','201702','ETP',9),('b16','201702','KM',895),('b16','201702','NUI',20),('b16','201702','REP',4),('b16','201703','ETP',9),('b16','201703','KM',457),('b16','201703','NUI',14),('b16','201703','REP',6),('b16','201704','ETP',8),('b16','201704','KM',340),('b16','201704','NUI',12),('b16','201704','REP',8),('b16','201705','ETP',15),('b16','201705','KM',505),('b16','201705','NUI',14),('b16','201705','REP',5),('b16','201706','ETP',5),('b16','201706','KM',464),('b16','201706','NUI',15),('b16','201706','REP',17),('b16','201707','ETP',11),('b16','201707','KM',430),('b16','201707','NUI',16),('b16','201707','REP',2),('b16','201708','ETP',13),('b16','201708','KM',822),('b16','201708','NUI',10),('b16','201708','REP',8),('b16','201709','ETP',18),('b16','201709','KM',681),('b16','201709','NUI',19),('b16','201709','REP',13),('b16','201710','ETP',10),('b16','201710','KM',825),('b16','201710','NUI',17),('b16','201710','REP',15),('b16','201711','ETP',17),('b16','201711','KM',855),('b16','201711','NUI',18),('b16','201711','REP',4),('b19','201609','ETP',12),('b19','201609','KM',541),('b19','201609','NUI',15),('b19','201609','REP',8),('b19','201610','ETP',3),('b19','201610','KM',842),('b19','201610','NUI',2),('b19','201610','REP',4),('b19','201611','ETP',14),('b19','201611','KM',768),('b19','201611','NUI',20),('b19','201611','REP',20),('b19','201612','ETP',2),('b19','201612','KM',665),('b19','201612','NUI',13),('b19','201612','REP',6),('b19','201701','ETP',3),('b19','201701','KM',307),('b19','201701','NUI',8),('b19','201701','REP',10),('b19','201702','ETP',14),('b19','201702','KM',763),('b19','201702','NUI',16),('b19','201702','REP',17),('b19','201703','ETP',6),('b19','201703','KM',328),('b19','201703','NUI',8),('b19','201703','REP',16),('b19','201704','ETP',19),('b19','201704','KM',878),('b19','201704','NUI',15),('b19','201704','REP',14),('b19','201705','ETP',19),('b19','201705','KM',323),('b19','201705','NUI',8),('b19','201705','REP',13),('b19','201706','ETP',2),('b19','201706','KM',875),('b19','201706','NUI',12),('b19','201706','REP',2),('b19','201707','ETP',9),('b19','201707','KM',302),('b19','201707','NUI',4),('b19','201707','REP',9),('b19','201708','ETP',9),('b19','201708','KM',323),('b19','201708','NUI',6),('b19','201708','REP',18),('b19','201709','ETP',13),('b19','201709','KM',924),('b19','201709','NUI',18),('b19','201709','REP',7),('b19','201710','ETP',15),('b19','201710','KM',769),('b19','201710','NUI',17),('b19','201710','REP',4),('b19','201711','ETP',2),('b19','201711','KM',520),('b19','201711','NUI',14),('b19','201711','REP',8),('b25','201609','ETP',20),('b25','201609','KM',795),('b25','201609','NUI',8),('b25','201609','REP',8),('b25','201610','ETP',10),('b25','201610','KM',536),('b25','201610','NUI',19),('b25','201610','REP',2),('b25','201611','ETP',20),('b25','201611','KM',791),('b25','201611','NUI',9),('b25','201611','REP',8),('b25','201612','ETP',18),('b25','201612','KM',679),('b25','201612','NUI',3),('b25','201612','REP',14),('b25','201701','ETP',14),('b25','201701','KM',915),('b25','201701','NUI',13),('b25','201701','REP',15),('b25','201702','ETP',11),('b25','201702','KM',411),('b25','201702','NUI',4),('b25','201702','REP',16),('b25','201703','ETP',12),('b25','201703','KM',550),('b25','201703','NUI',15),('b25','201703','REP',10),('b25','201704','ETP',7),('b25','201704','KM',828),('b25','201704','NUI',20),('b25','201704','REP',12),('b25','201705','ETP',17),('b25','201705','KM',424),('b25','201705','NUI',8),('b25','201705','REP',3),('b25','201706','ETP',18),('b25','201706','KM',911),('b25','201706','NUI',5),('b25','201706','REP',14),('b25','201707','ETP',12),('b25','201707','KM',858),('b25','201707','NUI',8),('b25','201707','REP',20),('b25','201708','ETP',7),('b25','201708','KM',753),('b25','201708','NUI',6),('b25','201708','REP',8),('b25','201709','ETP',7),('b25','201709','KM',754),('b25','201709','NUI',17),('b25','201709','REP',4),('b25','201710','ETP',18),('b25','201710','KM',945),('b25','201710','NUI',16),('b25','201710','REP',8),('b25','201711','ETP',9),('b25','201711','KM',522),('b25','201711','NUI',6),('b25','201711','REP',3),('b28','201609','ETP',10),('b28','201609','KM',750),('b28','201609','NUI',13),('b28','201609','REP',5),('b28','201610','ETP',8),('b28','201610','KM',434),('b28','201610','NUI',3),('b28','201610','REP',2),('b28','201611','ETP',9),('b28','201611','KM',638),('b28','201611','NUI',7),('b28','201611','REP',16),('b28','201612','ETP',9),('b28','201612','KM',565),('b28','201612','NUI',12),('b28','201612','REP',18),('b28','201701','ETP',16),('b28','201701','KM',608),('b28','201701','NUI',8),('b28','201701','REP',18),('b28','201702','ETP',20),('b28','201702','KM',534),('b28','201702','NUI',7),('b28','201702','REP',2),('b28','201703','ETP',7),('b28','201703','KM',626),('b28','201703','NUI',15),('b28','201703','REP',20),('b28','201704','ETP',17),('b28','201704','KM',663),('b28','201704','NUI',19),('b28','201704','REP',9),('b28','201705','ETP',7),('b28','201705','KM',681),('b28','201705','NUI',10),('b28','201705','REP',15),('b28','201706','ETP',16),('b28','201706','KM',941),('b28','201706','NUI',17),('b28','201706','REP',5),('b28','201707','ETP',2),('b28','201707','KM',302),('b28','201707','NUI',20),('b28','201707','REP',15),('b28','201708','ETP',9),('b28','201708','KM',323),('b28','201708','NUI',16),('b28','201708','REP',7),('b28','201709','ETP',14),('b28','201709','KM',664),('b28','201709','NUI',11),('b28','201709','REP',15),('b28','201710','ETP',7),('b28','201710','KM',773),('b28','201710','NUI',8),('b28','201710','REP',4),('b28','201711','ETP',8),('b28','201711','KM',694),('b28','201711','NUI',8),('b28','201711','REP',2),('b34','201609','ETP',9),('b34','201609','KM',407),('b34','201609','NUI',2),('b34','201609','REP',14),('b34','201610','ETP',14),('b34','201610','KM',333),('b34','201610','NUI',14),('b34','201610','REP',20),('b34','201611','ETP',17),('b34','201611','KM',786),('b34','201611','NUI',16),('b34','201611','REP',7),('b34','201612','ETP',11),('b34','201612','KM',984),('b34','201612','NUI',13),('b34','201612','REP',3),('b34','201701','ETP',13),('b34','201701','KM',327),('b34','201701','NUI',20),('b34','201701','REP',5),('b34','201702','ETP',17),('b34','201702','KM',310),('b34','201702','NUI',9),('b34','201702','REP',10),('b34','201703','ETP',9),('b34','201703','KM',958),('b34','201703','NUI',4),('b34','201703','REP',10),('b34','201704','ETP',9),('b34','201704','KM',755),('b34','201704','NUI',8),('b34','201704','REP',10),('b34','201705','ETP',18),('b34','201705','KM',339),('b34','201705','NUI',13),('b34','201705','REP',16),('b34','201706','ETP',10),('b34','201706','KM',889),('b34','201706','NUI',9),('b34','201706','REP',8),('b34','201707','ETP',13),('b34','201707','KM',350),('b34','201707','NUI',10),('b34','201707','REP',6),('b34','201708','ETP',17),('b34','201708','KM',679),('b34','201708','NUI',14),('b34','201708','REP',14),('b34','201709','ETP',5),('b34','201709','KM',788),('b34','201709','NUI',2),('b34','201709','REP',14),('b34','201710','ETP',13),('b34','201710','KM',400),('b34','201710','NUI',16),('b34','201710','REP',8),('b34','201711','ETP',10),('b34','201711','KM',810),('b34','201711','NUI',3),('b34','201711','REP',7),('b4','201609','ETP',20),('b4','201609','KM',856),('b4','201609','NUI',10),('b4','201609','REP',20),('b4','201610','ETP',7),('b4','201610','KM',997),('b4','201610','NUI',17),('b4','201610','REP',15),('b4','201611','ETP',6),('b4','201611','KM',894),('b4','201611','NUI',10),('b4','201611','REP',4),('b4','201612','ETP',18),('b4','201612','KM',359),('b4','201612','NUI',11),('b4','201612','REP',8),('b4','201701','ETP',14),('b4','201701','KM',554),('b4','201701','NUI',16),('b4','201701','REP',11),('b4','201702','ETP',11),('b4','201702','KM',329),('b4','201702','NUI',13),('b4','201702','REP',9),('b4','201703','ETP',6),('b4','201703','KM',452),('b4','201703','NUI',2),('b4','201703','REP',5),('b4','201704','ETP',10),('b4','201704','KM',954),('b4','201704','NUI',20),('b4','201704','REP',19),('b4','201705','ETP',17),('b4','201705','KM',894),('b4','201705','NUI',17),('b4','201705','REP',2),('b4','201706','ETP',15),('b4','201706','KM',362),('b4','201706','NUI',2),('b4','201706','REP',2),('b4','201707','ETP',12),('b4','201707','KM',652),('b4','201707','NUI',10),('b4','201707','REP',7),('b4','201708','ETP',19),('b4','201708','KM',666),('b4','201708','NUI',4),('b4','201708','REP',12),('b4','201709','ETP',16),('b4','201709','KM',346),('b4','201709','NUI',15),('b4','201709','REP',20),('b4','201710','ETP',8),('b4','201710','KM',382),('b4','201710','NUI',17),('b4','201710','REP',7),('b4','201711','ETP',17),('b4','201711','KM',479),('b4','201711','NUI',19),('b4','201711','REP',15),('b50','201609','ETP',15),('b50','201609','KM',673),('b50','201609','NUI',5),('b50','201609','REP',11),('b50','201610','ETP',8),('b50','201610','KM',927),('b50','201610','NUI',2),('b50','201610','REP',3),('b50','201611','ETP',15),('b50','201611','KM',993),('b50','201611','NUI',9),('b50','201611','REP',12),('b50','201612','ETP',19),('b50','201612','KM',942),('b50','201612','NUI',16),('b50','201612','REP',6),('b50','201701','ETP',14),('b50','201701','KM',367),('b50','201701','NUI',13),('b50','201701','REP',5),('b50','201702','ETP',14),('b50','201702','KM',608),('b50','201702','NUI',14),('b50','201702','REP',20),('b50','201703','ETP',2),('b50','201703','KM',709),('b50','201703','NUI',20),('b50','201703','REP',15),('b50','201704','ETP',14),('b50','201704','KM',405),('b50','201704','NUI',4),('b50','201704','REP',15),('b50','201705','ETP',14),('b50','201705','KM',375),('b50','201705','NUI',19),('b50','201705','REP',17),('b50','201706','ETP',12),('b50','201706','KM',847),('b50','201706','NUI',15),('b50','201706','REP',10),('b50','201707','ETP',3),('b50','201707','KM',760),('b50','201707','NUI',15),('b50','201707','REP',7),('b50','201708','ETP',9),('b50','201708','KM',688),('b50','201708','NUI',2),('b50','201708','REP',7),('b50','201709','ETP',9),('b50','201709','KM',747),('b50','201709','NUI',2),('b50','201709','REP',12),('b50','201710','ETP',14),('b50','201710','KM',520),('b50','201710','NUI',13),('b50','201710','REP',16),('b50','201711','ETP',17),('b50','201711','KM',467),('b50','201711','NUI',6),('b50','201711','REP',20),('b59','201609','ETP',20),('b59','201609','KM',578),('b59','201609','NUI',16),('b59','201609','REP',2),('b59','201610','ETP',7),('b59','201610','KM',748),('b59','201610','NUI',11),('b59','201610','REP',19),('b59','201611','ETP',6),('b59','201611','KM',514),('b59','201611','NUI',2),('b59','201611','REP',9),('b59','201612','ETP',15),('b59','201612','KM',336),('b59','201612','NUI',12),('b59','201612','REP',4),('b59','201701','ETP',6),('b59','201701','KM',911),('b59','201701','NUI',20),('b59','201701','REP',5),('b59','201702','ETP',3),('b59','201702','KM',620),('b59','201702','NUI',14),('b59','201702','REP',11),('b59','201703','ETP',8),('b59','201703','KM',506),('b59','201703','NUI',5),('b59','201703','REP',19),('b59','201704','ETP',16),('b59','201704','KM',948),('b59','201704','NUI',6),('b59','201704','REP',5),('b59','201705','ETP',16),('b59','201705','KM',614),('b59','201705','NUI',8),('b59','201705','REP',15),('b59','201706','ETP',7),('b59','201706','KM',929),('b59','201706','NUI',14),('b59','201706','REP',10),('b59','201707','ETP',7),('b59','201707','KM',413),('b59','201707','NUI',11),('b59','201707','REP',4),('b59','201708','ETP',2),('b59','201708','KM',648),('b59','201708','NUI',12),('b59','201708','REP',4),('b59','201709','ETP',9),('b59','201709','KM',951),('b59','201709','NUI',4),('b59','201709','REP',8),('b59','201710','ETP',16),('b59','201710','KM',326),('b59','201710','NUI',14),('b59','201710','REP',3),('b59','201711','ETP',16),('b59','201711','KM',437),('b59','201711','NUI',4),('b59','201711','REP',9),('c14','201609','ETP',7),('c14','201609','KM',888),('c14','201609','NUI',17),('c14','201609','REP',11),('c14','201610','ETP',3),('c14','201610','KM',768),('c14','201610','NUI',11),('c14','201610','REP',4),('c14','201611','ETP',6),('c14','201611','KM',471),('c14','201611','NUI',14),('c14','201611','REP',19),('c14','201612','ETP',8),('c14','201612','KM',727),('c14','201612','NUI',19),('c14','201612','REP',16),('c14','201701','ETP',7),('c14','201701','KM',325),('c14','201701','NUI',3),('c14','201701','REP',4),('c14','201702','ETP',19),('c14','201702','KM',604),('c14','201702','NUI',16),('c14','201702','REP',12),('c14','201703','ETP',5),('c14','201703','KM',326),('c14','201703','NUI',13),('c14','201703','REP',19),('c14','201704','ETP',11),('c14','201704','KM',337),('c14','201704','NUI',19),('c14','201704','REP',2),('c14','201705','ETP',14),('c14','201705','KM',979),('c14','201705','NUI',9),('c14','201705','REP',17),('c14','201706','ETP',9),('c14','201706','KM',454),('c14','201706','NUI',17),('c14','201706','REP',8),('c14','201707','ETP',9),('c14','201707','KM',320),('c14','201707','NUI',4),('c14','201707','REP',14),('c14','201708','ETP',18),('c14','201708','KM',487),('c14','201708','NUI',11),('c14','201708','REP',20),('c14','201709','ETP',18),('c14','201709','KM',388),('c14','201709','NUI',14),('c14','201709','REP',7),('c14','201710','ETP',18),('c14','201710','KM',501),('c14','201710','NUI',4),('c14','201710','REP',9),('c14','201711','ETP',17),('c14','201711','KM',769),('c14','201711','NUI',19),('c14','201711','REP',18),('c3','201609','ETP',6),('c3','201609','KM',888),('c3','201609','NUI',4),('c3','201609','REP',2),('c3','201610','ETP',17),('c3','201610','KM',430),('c3','201610','NUI',18),('c3','201610','REP',2),('c3','201611','ETP',5),('c3','201611','KM',423),('c3','201611','NUI',15),('c3','201611','REP',9),('c3','201612','ETP',16),('c3','201612','KM',665),('c3','201612','NUI',19),('c3','201612','REP',14),('c3','201701','ETP',10),('c3','201701','KM',301),('c3','201701','NUI',15),('c3','201701','REP',14),('c3','201702','ETP',17),('c3','201702','KM',875),('c3','201702','NUI',15),('c3','201702','REP',15),('c3','201703','ETP',17),('c3','201703','KM',847),('c3','201703','NUI',8),('c3','201703','REP',17),('c3','201704','ETP',13),('c3','201704','KM',735),('c3','201704','NUI',13),('c3','201704','REP',14),('c3','201705','ETP',4),('c3','201705','KM',694),('c3','201705','NUI',10),('c3','201705','REP',17),('c3','201706','ETP',17),('c3','201706','KM',927),('c3','201706','NUI',4),('c3','201706','REP',18),('c3','201707','ETP',9),('c3','201707','KM',560),('c3','201707','NUI',10),('c3','201707','REP',15),('c3','201708','ETP',14),('c3','201708','KM',374),('c3','201708','NUI',8),('c3','201708','REP',16),('c3','201709','ETP',10),('c3','201709','KM',672),('c3','201709','NUI',9),('c3','201709','REP',18),('c3','201710','ETP',4),('c3','201710','KM',333),('c3','201710','NUI',2),('c3','201710','REP',10),('c3','201711','ETP',7),('c3','201711','KM',757),('c3','201711','NUI',5),('c3','201711','REP',12),('c54','201609','ETP',19),('c54','201609','KM',314),('c54','201609','NUI',6),('c54','201609','REP',18),('c54','201610','ETP',6),('c54','201610','KM',805),('c54','201610','NUI',15),('c54','201610','REP',17),('c54','201611','ETP',12),('c54','201611','KM',695),('c54','201611','NUI',19),('c54','201611','REP',9),('c54','201612','ETP',4),('c54','201612','KM',983),('c54','201612','NUI',19),('c54','201612','REP',9),('c54','201701','ETP',14),('c54','201701','KM',313),('c54','201701','NUI',19),('c54','201701','REP',8),('c54','201702','ETP',5),('c54','201702','KM',744),('c54','201702','NUI',16),('c54','201702','REP',9),('c54','201703','ETP',12),('c54','201703','KM',832),('c54','201703','NUI',15),('c54','201703','REP',19),('c54','201704','ETP',16),('c54','201704','KM',917),('c54','201704','NUI',18),('c54','201704','REP',19),('c54','201705','ETP',16),('c54','201705','KM',346),('c54','201705','NUI',7),('c54','201705','REP',9),('c54','201706','ETP',2),('c54','201706','KM',622),('c54','201706','NUI',3),('c54','201706','REP',2),('c54','201707','ETP',13),('c54','201707','KM',484),('c54','201707','NUI',10),('c54','201707','REP',13),('c54','201708','ETP',16),('c54','201708','KM',499),('c54','201708','NUI',18),('c54','201708','REP',5),('c54','201709','ETP',4),('c54','201709','KM',615),('c54','201709','NUI',11),('c54','201709','REP',13),('c54','201710','ETP',19),('c54','201710','KM',732),('c54','201710','NUI',15),('c54','201710','REP',2),('c54','201711','ETP',11),('c54','201711','KM',492),('c54','201711','NUI',3),('c54','201711','REP',14),('d13','201609','ETP',14),('d13','201609','KM',460),('d13','201609','NUI',4),('d13','201609','REP',20),('d13','201610','ETP',11),('d13','201610','KM',855),('d13','201610','NUI',14),('d13','201610','REP',8),('d13','201611','ETP',3),('d13','201611','KM',665),('d13','201611','NUI',10),('d13','201611','REP',8),('d13','201612','ETP',5),('d13','201612','KM',655),('d13','201612','NUI',20),('d13','201612','REP',10),('d13','201701','ETP',10),('d13','201701','KM',467),('d13','201701','NUI',2),('d13','201701','REP',8),('d13','201702','ETP',5),('d13','201702','KM',691),('d13','201702','NUI',10),('d13','201702','REP',16),('d13','201703','ETP',7),('d13','201703','KM',482),('d13','201703','NUI',17),('d13','201703','REP',2),('d13','201704','ETP',3),('d13','201704','KM',812),('d13','201704','NUI',9),('d13','201704','REP',15),('d13','201705','ETP',5),('d13','201705','KM',346),('d13','201705','NUI',8),('d13','201705','REP',10),('d13','201706','ETP',19),('d13','201706','KM',846),('d13','201706','NUI',19),('d13','201706','REP',16),('d13','201707','ETP',7),('d13','201707','KM',405),('d13','201707','NUI',13),('d13','201707','REP',5),('d13','201708','ETP',5),('d13','201708','KM',647),('d13','201708','NUI',7),('d13','201708','REP',3),('d13','201709','ETP',14),('d13','201709','KM',481),('d13','201709','NUI',11),('d13','201709','REP',11),('d13','201710','ETP',11),('d13','201710','KM',866),('d13','201710','NUI',6),('d13','201710','REP',16),('d13','201711','ETP',17),('d13','201711','KM',758),('d13','201711','NUI',5),('d13','201711','REP',6),('d51','201609','ETP',16),('d51','201609','KM',562),('d51','201609','NUI',15),('d51','201609','REP',6),('d51','201610','ETP',13),('d51','201610','KM',403),('d51','201610','NUI',4),('d51','201610','REP',10),('d51','201611','ETP',10),('d51','201611','KM',603),('d51','201611','NUI',18),('d51','201611','REP',7),('d51','201612','ETP',13),('d51','201612','KM',331),('d51','201612','NUI',5),('d51','201612','REP',13),('d51','201701','ETP',6),('d51','201701','KM',808),('d51','201701','NUI',8),('d51','201701','REP',16),('d51','201702','ETP',15),('d51','201702','KM',335),('d51','201702','NUI',5),('d51','201702','REP',8),('d51','201703','ETP',20),('d51','201703','KM',836),('d51','201703','NUI',13),('d51','201703','REP',13),('d51','201704','ETP',16),('d51','201704','KM',679),('d51','201704','NUI',14),('d51','201704','REP',8),('d51','201705','ETP',3),('d51','201705','KM',997),('d51','201705','NUI',15),('d51','201705','REP',9),('d51','201706','ETP',4),('d51','201706','KM',535),('d51','201706','NUI',7),('d51','201706','REP',6),('d51','201707','ETP',14),('d51','201707','KM',816),('d51','201707','NUI',3),('d51','201707','REP',14),('d51','201708','ETP',7),('d51','201708','KM',400),('d51','201708','NUI',7),('d51','201708','REP',8),('d51','201709','ETP',3),('d51','201709','KM',602),('d51','201709','NUI',12),('d51','201709','REP',20),('d51','201710','ETP',17),('d51','201710','KM',513),('d51','201710','NUI',10),('d51','201710','REP',20),('d51','201711','ETP',10),('d51','201711','KM',305),('d51','201711','NUI',10),('d51','201711','REP',15),('e22','201609','ETP',4),('e22','201609','KM',359),('e22','201609','NUI',20),('e22','201609','REP',11),('e22','201610','ETP',13),('e22','201610','KM',839),('e22','201610','NUI',10),('e22','201610','REP',20),('e22','201611','ETP',6),('e22','201611','KM',735),('e22','201611','NUI',7),('e22','201611','REP',9),('e22','201612','ETP',8),('e22','201612','KM',926),('e22','201612','NUI',16),('e22','201612','REP',3),('e22','201701','ETP',19),('e22','201701','KM',303),('e22','201701','NUI',5),('e22','201701','REP',14),('e22','201702','ETP',17),('e22','201702','KM',596),('e22','201702','NUI',4),('e22','201702','REP',18),('e22','201703','ETP',2),('e22','201703','KM',588),('e22','201703','NUI',14),('e22','201703','REP',5),('e22','201704','ETP',9),('e22','201704','KM',477),('e22','201704','NUI',9),('e22','201704','REP',14),('e22','201705','ETP',5),('e22','201705','KM',628),('e22','201705','NUI',6),('e22','201705','REP',19),('e22','201706','ETP',19),('e22','201706','KM',614),('e22','201706','NUI',16),('e22','201706','REP',14),('e22','201707','ETP',6),('e22','201707','KM',898),('e22','201707','NUI',9),('e22','201707','REP',2),('e22','201708','ETP',5),('e22','201708','KM',862),('e22','201708','NUI',10),('e22','201708','REP',14),('e22','201709','ETP',17),('e22','201709','KM',449),('e22','201709','NUI',3),('e22','201709','REP',7),('e22','201710','ETP',14),('e22','201710','KM',366),('e22','201710','NUI',12),('e22','201710','REP',7),('e22','201711','ETP',10),('e22','201711','KM',902),('e22','201711','NUI',14),('e22','201711','REP',5),('e24','201609','ETP',13),('e24','201609','KM',838),('e24','201609','NUI',2),('e24','201609','REP',2),('e24','201610','ETP',13),('e24','201610','KM',691),('e24','201610','NUI',5),('e24','201610','REP',10),('e24','201611','ETP',11),('e24','201611','KM',388),('e24','201611','NUI',18),('e24','201611','REP',8),('e24','201612','ETP',9),('e24','201612','KM',862),('e24','201612','NUI',18),('e24','201612','REP',11),('e24','201701','ETP',20),('e24','201701','KM',338),('e24','201701','NUI',14),('e24','201701','REP',11),('e24','201702','ETP',3),('e24','201702','KM',377),('e24','201702','NUI',11),('e24','201702','REP',5),('e24','201703','ETP',11),('e24','201703','KM',978),('e24','201703','NUI',5),('e24','201703','REP',14),('e24','201704','ETP',20),('e24','201704','KM',423),('e24','201704','NUI',13),('e24','201704','REP',6),('e24','201705','ETP',6),('e24','201705','KM',543),('e24','201705','NUI',6),('e24','201705','REP',6),('e24','201706','ETP',9),('e24','201706','KM',311),('e24','201706','NUI',11),('e24','201706','REP',2),('e24','201707','ETP',7),('e24','201707','KM',928),('e24','201707','NUI',3),('e24','201707','REP',6),('e24','201708','ETP',10),('e24','201708','KM',604),('e24','201708','NUI',6),('e24','201708','REP',19),('e24','201709','ETP',7),('e24','201709','KM',449),('e24','201709','NUI',15),('e24','201709','REP',8),('e24','201710','ETP',18),('e24','201710','KM',607),('e24','201710','NUI',5),('e24','201710','REP',3),('e24','201711','ETP',6),('e24','201711','KM',998),('e24','201711','NUI',14),('e24','201711','REP',17),('e39','201609','ETP',16),('e39','201609','KM',768),('e39','201609','NUI',19),('e39','201609','REP',16),('e39','201610','ETP',2),('e39','201610','KM',975),('e39','201610','NUI',9),('e39','201610','REP',11),('e39','201611','ETP',3),('e39','201611','KM',628),('e39','201611','NUI',2),('e39','201611','REP',14),('e39','201612','ETP',4),('e39','201612','KM',809),('e39','201612','NUI',15),('e39','201612','REP',17),('e39','201701','ETP',9),('e39','201701','KM',583),('e39','201701','NUI',20),('e39','201701','REP',20),('e39','201702','ETP',16),('e39','201702','KM',566),('e39','201702','NUI',12),('e39','201702','REP',18),('e39','201703','ETP',18),('e39','201703','KM',621),('e39','201703','NUI',19),('e39','201703','REP',8),('e39','201704','ETP',6),('e39','201704','KM',783),('e39','201704','NUI',9),('e39','201704','REP',10),('e39','201705','ETP',5),('e39','201705','KM',820),('e39','201705','NUI',5),('e39','201705','REP',19),('e39','201706','ETP',5),('e39','201706','KM',597),('e39','201706','NUI',13),('e39','201706','REP',17),('e39','201707','ETP',8),('e39','201707','KM',440),('e39','201707','NUI',13),('e39','201707','REP',5),('e39','201708','ETP',10),('e39','201708','KM',370),('e39','201708','NUI',14),('e39','201708','REP',13),('e39','201709','ETP',6),('e39','201709','KM',816),('e39','201709','NUI',8),('e39','201709','REP',7),('e39','201710','ETP',7),('e39','201710','KM',810),('e39','201710','NUI',11),('e39','201710','REP',3),('e39','201711','ETP',10),('e39','201711','KM',740),('e39','201711','NUI',14),('e39','201711','REP',18),('e49','201609','ETP',7),('e49','201609','KM',480),('e49','201609','NUI',8),('e49','201609','REP',10),('e49','201610','ETP',16),('e49','201610','KM',430),('e49','201610','NUI',7),('e49','201610','REP',17),('e49','201611','ETP',18),('e49','201611','KM',995),('e49','201611','NUI',20),('e49','201611','REP',8),('e49','201612','ETP',7),('e49','201612','KM',872),('e49','201612','NUI',4),('e49','201612','REP',14),('e49','201701','ETP',18),('e49','201701','KM',648),('e49','201701','NUI',13),('e49','201701','REP',18),('e49','201702','ETP',20),('e49','201702','KM',943),('e49','201702','NUI',3),('e49','201702','REP',9),('e49','201703','ETP',4),('e49','201703','KM',328),('e49','201703','NUI',4),('e49','201703','REP',2),('e49','201704','ETP',17),('e49','201704','KM',613),('e49','201704','NUI',11),('e49','201704','REP',17),('e49','201705','ETP',6),('e49','201705','KM',593),('e49','201705','NUI',18),('e49','201705','REP',3),('e49','201706','ETP',12),('e49','201706','KM',862),('e49','201706','NUI',2),('e49','201706','REP',9),('e49','201707','ETP',12),('e49','201707','KM',802),('e49','201707','NUI',5),('e49','201707','REP',3),('e49','201708','ETP',11),('e49','201708','KM',732),('e49','201708','NUI',15),('e49','201708','REP',3),('e49','201709','ETP',18),('e49','201709','KM',428),('e49','201709','NUI',13),('e49','201709','REP',17),('e49','201710','ETP',3),('e49','201710','KM',650),('e49','201710','NUI',8),('e49','201710','REP',14),('e49','201711','ETP',12),('e49','201711','KM',601),('e49','201711','NUI',9),('e49','201711','REP',8),('e5','201609','ETP',10),('e5','201609','KM',726),('e5','201609','NUI',8),('e5','201609','REP',11),('e5','201610','ETP',17),('e5','201610','KM',884),('e5','201610','NUI',16),('e5','201610','REP',5),('e5','201611','ETP',9),('e5','201611','KM',659),('e5','201611','NUI',19),('e5','201611','REP',9),('e5','201612','ETP',20),('e5','201612','KM',480),('e5','201612','NUI',2),('e5','201612','REP',18),('e5','201701','ETP',19),('e5','201701','KM',313),('e5','201701','NUI',19),('e5','201701','REP',19),('e5','201702','ETP',9),('e5','201702','KM',544),('e5','201702','NUI',12),('e5','201702','REP',16),('e5','201703','ETP',18),('e5','201703','KM',792),('e5','201703','NUI',9),('e5','201703','REP',13),('e5','201704','ETP',6),('e5','201704','KM',572),('e5','201704','NUI',8),('e5','201704','REP',11),('e5','201705','ETP',11),('e5','201705','KM',850),('e5','201705','NUI',19),('e5','201705','REP',19),('e5','201706','ETP',3),('e5','201706','KM',395),('e5','201706','NUI',4),('e5','201706','REP',12),('e5','201707','ETP',14),('e5','201707','KM',569),('e5','201707','NUI',2),('e5','201707','REP',11),('e5','201708','ETP',3),('e5','201708','KM',423),('e5','201708','NUI',14),('e5','201708','REP',19),('e5','201709','ETP',15),('e5','201709','KM',892),('e5','201709','NUI',8),('e5','201709','REP',9),('e5','201710','ETP',3),('e5','201710','KM',895),('e5','201710','NUI',12),('e5','201710','REP',15),('e5','201711','ETP',2),('e5','201711','KM',459),('e5','201711','NUI',7),('e5','201711','REP',4),('e52','201609','ETP',8),('e52','201609','KM',928),('e52','201609','NUI',4),('e52','201609','REP',17),('e52','201610','ETP',13),('e52','201610','KM',869),('e52','201610','NUI',9),('e52','201610','REP',4),('e52','201611','ETP',7),('e52','201611','KM',977),('e52','201611','NUI',18),('e52','201611','REP',6),('e52','201612','ETP',18),('e52','201612','KM',951),('e52','201612','NUI',20),('e52','201612','REP',6),('e52','201701','ETP',4),('e52','201701','KM',348),('e52','201701','NUI',2),('e52','201701','REP',7),('e52','201702','ETP',10),('e52','201702','KM',802),('e52','201702','NUI',17),('e52','201702','REP',13),('e52','201703','ETP',15),('e52','201703','KM',738),('e52','201703','NUI',4),('e52','201703','REP',2),('e52','201704','ETP',8),('e52','201704','KM',611),('e52','201704','NUI',17),('e52','201704','REP',8),('e52','201705','ETP',5),('e52','201705','KM',642),('e52','201705','NUI',11),('e52','201705','REP',4),('e52','201706','ETP',9),('e52','201706','KM',861),('e52','201706','NUI',4),('e52','201706','REP',20),('e52','201707','ETP',7),('e52','201707','KM',829),('e52','201707','NUI',3),('e52','201707','REP',19),('e52','201708','ETP',3),('e52','201708','KM',313),('e52','201708','NUI',7),('e52','201708','REP',12),('e52','201709','ETP',3),('e52','201709','KM',641),('e52','201709','NUI',4),('e52','201709','REP',7),('e52','201710','ETP',13),('e52','201710','KM',565),('e52','201710','NUI',5),('e52','201710','REP',19),('e52','201711','ETP',12),('e52','201711','KM',403),('e52','201711','NUI',9),('e52','201711','REP',12),('f21','201609','ETP',14),('f21','201609','KM',538),('f21','201609','NUI',14),('f21','201609','REP',16),('f21','201610','ETP',3),('f21','201610','KM',876),('f21','201610','NUI',17),('f21','201610','REP',18),('f21','201611','ETP',11),('f21','201611','KM',939),('f21','201611','NUI',8),('f21','201611','REP',15),('f21','201612','ETP',5),('f21','201612','KM',506),('f21','201612','NUI',5),('f21','201612','REP',18),('f21','201701','ETP',9),('f21','201701','KM',601),('f21','201701','NUI',12),('f21','201701','REP',14),('f21','201702','ETP',14),('f21','201702','KM',876),('f21','201702','NUI',4),('f21','201702','REP',4),('f21','201703','ETP',3),('f21','201703','KM',334),('f21','201703','NUI',12),('f21','201703','REP',8),('f21','201704','ETP',10),('f21','201704','KM',898),('f21','201704','NUI',2),('f21','201704','REP',18),('f21','201705','ETP',11),('f21','201705','KM',707),('f21','201705','NUI',18),('f21','201705','REP',17),('f21','201706','ETP',3),('f21','201706','KM',947),('f21','201706','NUI',11),('f21','201706','REP',14),('f21','201707','ETP',8),('f21','201707','KM',798),('f21','201707','NUI',6),('f21','201707','REP',11),('f21','201708','ETP',3),('f21','201708','KM',757),('f21','201708','NUI',10),('f21','201708','REP',17),('f21','201709','ETP',17),('f21','201709','KM',861),('f21','201709','NUI',19),('f21','201709','REP',11),('f21','201710','ETP',2),('f21','201710','KM',473),('f21','201710','NUI',7),('f21','201710','REP',13),('f21','201711','ETP',11),('f21','201711','KM',608),('f21','201711','NUI',10),('f21','201711','REP',18),('f39','201609','ETP',16),('f39','201609','KM',654),('f39','201609','NUI',4),('f39','201609','REP',3),('f39','201610','ETP',13),('f39','201610','KM',777),('f39','201610','NUI',3),('f39','201610','REP',2),('f39','201611','ETP',4),('f39','201611','KM',572),('f39','201611','NUI',19),('f39','201611','REP',17),('f39','201612','ETP',18),('f39','201612','KM',568),('f39','201612','NUI',20),('f39','201612','REP',18),('f39','201701','ETP',18),('f39','201701','KM',316),('f39','201701','NUI',17),('f39','201701','REP',6),('f39','201702','ETP',8),('f39','201702','KM',797),('f39','201702','NUI',12),('f39','201702','REP',9),('f39','201703','ETP',2),('f39','201703','KM',623),('f39','201703','NUI',2),('f39','201703','REP',13),('f39','201704','ETP',7),('f39','201704','KM',871),('f39','201704','NUI',19),('f39','201704','REP',19),('f39','201705','ETP',13),('f39','201705','KM',993),('f39','201705','NUI',3),('f39','201705','REP',13),('f39','201706','ETP',18),('f39','201706','KM',964),('f39','201706','NUI',17),('f39','201706','REP',19),('f39','201707','ETP',8),('f39','201707','KM',342),('f39','201707','NUI',17),('f39','201707','REP',18),('f39','201708','ETP',14),('f39','201708','KM',455),('f39','201708','NUI',13),('f39','201708','REP',19),('f39','201709','ETP',14),('f39','201709','KM',466),('f39','201709','NUI',20),('f39','201709','REP',11),('f39','201710','ETP',13),('f39','201710','KM',732),('f39','201710','NUI',2),('f39','201710','REP',8),('f39','201711','ETP',6),('f39','201711','KM',491),('f39','201711','NUI',17),('f39','201711','REP',18),('f4','201609','ETP',6),('f4','201609','KM',328),('f4','201609','NUI',18),('f4','201609','REP',10),('f4','201610','ETP',9),('f4','201610','KM',994),('f4','201610','NUI',11),('f4','201610','REP',17),('f4','201611','ETP',19),('f4','201611','KM',594),('f4','201611','NUI',10),('f4','201611','REP',7),('f4','201612','ETP',20),('f4','201612','KM',723),('f4','201612','NUI',2),('f4','201612','REP',7),('f4','201701','ETP',8),('f4','201701','KM',913),('f4','201701','NUI',18),('f4','201701','REP',14),('f4','201702','ETP',18),('f4','201702','KM',616),('f4','201702','NUI',3),('f4','201702','REP',3),('f4','201703','ETP',3),('f4','201703','KM',420),('f4','201703','NUI',8),('f4','201703','REP',8),('f4','201704','ETP',16),('f4','201704','KM',829),('f4','201704','NUI',6),('f4','201704','REP',12),('f4','201705','ETP',8),('f4','201705','KM',641),('f4','201705','NUI',19),('f4','201705','REP',14),('f4','201706','ETP',4),('f4','201706','KM',809),('f4','201706','NUI',10),('f4','201706','REP',3),('f4','201707','ETP',8),('f4','201707','KM',337),('f4','201707','NUI',18),('f4','201707','REP',11),('f4','201708','ETP',17),('f4','201708','KM',616),('f4','201708','NUI',13),('f4','201708','REP',2),('f4','201709','ETP',6),('f4','201709','KM',446),('f4','201709','NUI',15),('f4','201709','REP',20),('f4','201710','ETP',10),('f4','201710','KM',742),('f4','201710','NUI',10),('f4','201710','REP',14),('f4','201711','ETP',15),('f4','201711','KM',439),('f4','201711','NUI',20),('f4','201711','REP',18);
181/*!40000 ALTER TABLE `lignefraisforfait` ENABLE KEYS */;
182UNLOCK TABLES;
183
184--
185-- Table structure for table `lignefraishorsforfait`
186--
187
188DROP TABLE IF EXISTS `lignefraishorsforfait`;
189/*!40101 SET @saved_cs_client = @@character_set_client */;
190/*!40101 SET character_set_client = utf8 */;
191CREATE TABLE `lignefraishorsforfait` (
192 `id` int(11) NOT NULL AUTO_INCREMENT,
193 `idvisiteur` char(4) NOT NULL,
194 `mois` char(6) NOT NULL,
195 `libelle` varchar(100) DEFAULT NULL,
196 `date` date DEFAULT NULL,
197 `montant` decimal(10,2) DEFAULT NULL,
198 PRIMARY KEY (`id`),
199 KEY `idvisiteur` (`idvisiteur`,`mois`),
200 CONSTRAINT `lignefraishorsforfait_ibfk_1` FOREIGN KEY (`idvisiteur`, `mois`) REFERENCES `fichefrais` (`idvisiteur`, `mois`)
201) ENGINE=InnoDB AUTO_INCREMENT=1345 DEFAULT CHARSET=latin1;
202/*!40101 SET character_set_client = @saved_cs_client */;
203
204--
205-- Dumping data for table `lignefraishorsforfait`
206--
207
208LOCK TABLES `lignefraishorsforfait` WRITE;
209/*!40000 ALTER TABLE `lignefraishorsforfait` DISABLE KEYS */;
210INSERT INTO `lignefraishorsforfait` VALUES (1,'a131','201609','Location véhicule','2016-09-11',132.00),(2,'a131','201609','Location véhicule','2016-09-14',181.00),(3,'a131','201609','Frais vestimentaire/représentation','2016-09-22',169.00),(4,'a131','201609','Achat de matériel de papèterie','2016-09-15',26.00),(5,'a131','201610','Location équipement vidéo/sonore','2016-10-25',679.00),(6,'a131','201610','Location salle conférence','2016-10-01',328.00),(7,'a131','201611','Voyage SNCF','2016-11-14',78.00),(8,'a131','201611','Repas avec praticien','2016-11-08',32.00),(9,'a131','201612','Location équipement vidéo/sonore','2016-12-10',532.00),(10,'a131','201701','Traiteur, alimentation, boisson','2017-01-07',368.00),(11,'a131','201701','Voyage SNCF','2017-01-24',33.00),(12,'a131','201701','Location véhicule','2017-01-09',193.00),(13,'a131','201702','Achat de matériel de papèterie','2017-02-18',48.00),(14,'a131','201702','Taxi','2017-02-04',38.00),(15,'a131','201702','Repas avec praticien','2017-02-23',42.00),(16,'a131','201702','Rémunération intervenant/spécialiste','2017-02-09',311.00),(17,'a131','201702','Traiteur, alimentation, boisson','2017-02-23',263.00),(18,'a131','201703','Traiteur, alimentation, boisson','2017-03-08',231.00),(19,'a131','201703','Location salle conférence','2017-03-20',121.00),(20,'a131','201703','Frais vestimentaire/représentation','2017-03-22',258.00),(21,'a131','201703','Taxi','2017-03-14',53.00),(22,'a131','201704','Achat de matériel de papèterie','2017-04-14',38.00),(23,'a131','201704','Frais vestimentaire/représentation','2017-04-10',426.00),(24,'a131','201704','Rémunération intervenant/spécialiste','2017-04-20',758.00),(25,'a131','201704','Repas avec praticien','2017-04-09',36.00),(26,'a131','201704','Voyage SNCF','2017-04-15',61.00),(27,'a131','201705','Voyage SNCF','2017-05-12',115.00),(28,'a131','201705','Location équipement vidéo/sonore','2017-05-04',106.00),(29,'a131','201705','Rémunération intervenant/spécialiste','2017-05-23',1159.00),(30,'a131','201706','Rémunération intervenant/spécialiste','2017-06-15',928.00),(31,'a131','201706','Location salle conférence','2017-06-04',310.00),(32,'a131','201707','Achat de matériel de papèterie','2017-07-02',43.00),(33,'a131','201708','Repas avec praticien','2017-08-08',41.00),(34,'a131','201708','Achat de matériel de papèterie','2017-08-20',31.00),(35,'a131','201708','Rémunération intervenant/spécialiste','2017-08-27',927.00),(36,'a131','201708','Traiteur, alimentation, boisson','2017-08-23',335.00),(37,'a131','201709','Taxi','2017-09-21',51.00),(38,'a131','201709','Traiteur, alimentation, boisson','2017-09-18',382.00),(39,'a131','201709','Rémunération intervenant/spécialiste','2017-09-25',1148.00),(40,'a131','201709','Taxi','2017-09-28',52.00),(41,'a131','201709','Voyage SNCF','2017-09-06',128.00),(42,'a131','201709','Achat de matériel de papèterie','2017-09-24',34.00),(43,'a131','201710','Location salle conférence','2017-10-19',293.00),(44,'a131','201710','Achat de matériel de papèterie','2017-10-17',41.00),(45,'a131','201710','Voyage SNCF','2017-10-23',94.00),(46,'a131','201710','Voyage SNCF','2017-10-21',94.00),(47,'a131','201711','Taxi','2017-11-10',49.00),(48,'a131','201711','Location équipement vidéo/sonore','2017-11-20',730.00),(49,'a131','201711','Location équipement vidéo/sonore','2017-11-16',414.00),(50,'a131','201711','Location véhicule','2017-11-09',292.00),(51,'a131','201711','Voyage SNCF','2017-11-23',142.00),(52,'a131','201711','Rémunération intervenant/spécialiste','2017-11-28',830.00),(53,'a131','Janv','Achat de matériel de papèterie','0000-00-00',17.00),(54,'a131','Janv','Taxi','0000-00-00',68.00),(55,'a131','Janv','Achat de matériel de papèterie','0000-00-00',27.00),(56,'a131','Janv','Location équipement vidéo/sonore','0000-00-00',320.00),(57,'a17','201609','Frais vestimentaire/représentation','2016-09-19',424.00),(58,'a17','201609','Voyage SNCF','2016-09-16',130.00),(59,'a17','201610','Location équipement vidéo/sonore','2016-10-17',169.00),(60,'a17','201610','Voyage SNCF','2016-10-01',139.00),(61,'a17','201611','Traiteur, alimentation, boisson','2016-11-02',420.00),(62,'a17','201611','Repas avec praticien','2016-11-13',32.00),(63,'a17','201611','Traiteur, alimentation, boisson','2016-11-25',391.00),(64,'a17','201612','Location véhicule','2016-12-08',203.00),(65,'a17','201701','Repas avec praticien','2017-01-24',49.00),(66,'a17','201701','Rémunération intervenant/spécialiste','2017-01-09',1124.00),(67,'a17','201702','Frais vestimentaire/représentation','2017-02-20',345.00),(68,'a17','201702','Voyage SNCF','2017-02-15',129.00),(69,'a17','201702','Frais vestimentaire/représentation','2017-02-14',180.00),(70,'a17','201702','Taxi','2017-02-14',49.00),(71,'a17','201703','Location salle conférence','2017-03-04',125.00),(72,'a17','201703','Taxi','2017-03-06',20.00),(73,'a17','201703','Frais vestimentaire/représentation','2017-03-20',282.00),(74,'a17','201703','Taxi','2017-03-05',49.00),(75,'a17','201703','Location salle conférence','2017-03-18',599.00),(76,'a17','201703','Location salle conférence','2017-03-04',199.00),(77,'a17','201704','Rémunération intervenant/spécialiste','2017-04-09',970.00),(78,'a17','201704','Voyage SNCF','2017-04-20',50.00),(79,'a17','201704','Frais vestimentaire/représentation','2017-04-04',405.00),(80,'a17','201705','Taxi','2017-05-12',71.00),(81,'a17','201705','Frais vestimentaire/représentation','2017-05-28',366.00),(82,'a17','201705','Location véhicule','2017-05-21',187.00),(83,'a17','201705','Achat de matériel de papèterie','2017-05-03',49.00),(84,'a17','201706','Traiteur, alimentation, boisson','2017-06-15',430.00),(85,'a17','201706','Frais vestimentaire/représentation','2017-06-02',349.00),(86,'a17','201706','Location véhicule','2017-06-08',261.00),(87,'a17','201707','Frais vestimentaire/représentation','2017-07-24',385.00),(88,'a17','201707','Frais vestimentaire/représentation','2017-07-11',390.00),(89,'a17','201707','Voyage SNCF','2017-07-18',54.00),(90,'a17','201707','Repas avec praticien','2017-07-01',48.00),(91,'a17','201707','Location salle conférence','2017-07-20',435.00),(92,'a17','201707','Rémunération intervenant/spécialiste','2017-07-08',293.00),(93,'a17','201708','Location salle conférence','2017-08-08',578.00),(94,'a17','201708','Taxi','2017-08-07',70.00),(95,'a17','201708','Repas avec praticien','2017-08-05',38.00),(96,'a17','201708','Traiteur, alimentation, boisson','2017-08-10',133.00),(97,'a17','201708','Voyage SNCF','2017-08-28',58.00),(98,'a17','201708','Taxi','2017-08-09',47.00),(99,'a17','201709','Repas avec praticien','2017-09-16',44.00),(100,'a17','201709','Location salle conférence','2017-09-05',225.00),(101,'a17','201710','Taxi','2017-10-02',23.00),(102,'a17','201710','Voyage SNCF','2017-10-14',96.00),(103,'a17','201710','Location véhicule','2017-10-14',174.00),(104,'a17','201711','Voyage SNCF','2017-11-27',127.00),(105,'a17','Fev','Achat de matériel de papèterie','0000-00-00',21.00),(106,'a17','Fev','Frais vestimentaire/représentation','0000-00-00',42.00),(107,'a17','Fev','Traiteur, alimentation, boisson','0000-00-00',328.00),(108,'a17','Fev','Taxi','0000-00-00',75.00),(109,'a17','Fev','Traiteur, alimentation, boisson','0000-00-00',162.00),(110,'a55','201609','Location équipement vidéo/sonore','2016-09-26',778.00),(111,'a55','201609','Location véhicule','2016-09-10',433.00),(112,'a55','201610','Rémunération intervenant/spécialiste','2016-10-28',799.00),(113,'a55','201611','Location équipement vidéo/sonore','2016-11-17',629.00),(114,'a55','201611','Rémunération intervenant/spécialiste','2016-11-14',819.00),(115,'a55','201612','Taxi','2016-12-02',74.00),(116,'a55','201612','Traiteur, alimentation, boisson','2016-12-18',101.00),(117,'a55','201612','Repas avec praticien','2016-12-18',31.00),(118,'a55','201612','Location salle conférence','2016-12-16',330.00),(119,'a55','201612','Location véhicule','2016-12-14',200.00),(120,'a55','201701','Location équipement vidéo/sonore','2017-01-24',249.00),(121,'a55','201702','Location véhicule','2017-02-04',145.00),(122,'a55','201702','Location équipement vidéo/sonore','2017-02-24',617.00),(123,'a55','201702','Rémunération intervenant/spécialiste','2017-02-04',761.00),(124,'a55','201702','Location salle conférence','2017-02-27',150.00),(125,'a55','201702','Location véhicule','2017-02-27',248.00),(126,'a55','201703','Frais vestimentaire/représentation','2017-03-05',292.00),(127,'a55','201703','Taxi','2017-03-20',52.00),(128,'a55','201703','Location salle conférence','2017-03-22',493.00),(129,'a55','201703','Traiteur, alimentation, boisson','2017-03-25',106.00),(130,'a55','201704','Location équipement vidéo/sonore','2017-04-05',387.00),(131,'a55','201704','Achat de matériel de papèterie','2017-04-08',27.00),(132,'a55','201704','Taxi','2017-04-21',62.00),(133,'a55','201704','Repas avec praticien','2017-04-12',37.00),(134,'a55','201704','Repas avec praticien','2017-04-10',48.00),(135,'a55','201704','Traiteur, alimentation, boisson','2017-04-17',349.00),(136,'a55','201705','Repas avec praticien','2017-05-02',38.00),(137,'a55','201705','Traiteur, alimentation, boisson','2017-05-28',415.00),(138,'a55','201705','Taxi','2017-05-04',39.00),(139,'a55','201705','Location salle conférence','2017-05-06',445.00),(140,'a55','201706','Voyage SNCF','2017-06-13',54.00),(141,'a55','201706','Taxi','2017-06-20',65.00),(142,'a55','201706','Traiteur, alimentation, boisson','2017-06-05',255.00),(143,'a55','201706','Location équipement vidéo/sonore','2017-06-02',139.00),(144,'a55','201706','Voyage SNCF','2017-06-10',85.00),(145,'a55','201707','Location véhicule','2017-07-20',318.00),(146,'a55','201708','Location équipement vidéo/sonore','2017-08-05',834.00),(147,'a55','201708','Repas avec praticien','2017-08-10',35.00),(148,'a55','201709','Location salle conférence','2017-09-09',434.00),(149,'a55','201709','Location véhicule','2017-09-06',48.00),(150,'a55','201709','Location équipement vidéo/sonore','2017-09-16',504.00),(151,'a55','201709','Traiteur, alimentation, boisson','2017-09-21',326.00),(152,'a55','201710','Achat de matériel de papèterie','2017-10-03',14.00),(153,'a55','201710','Location salle conférence','2017-10-01',144.00),(154,'a55','201710','Rémunération intervenant/spécialiste','2017-10-11',1179.00),(155,'a55','201711','Traiteur, alimentation, boisson','2017-11-01',379.00),(156,'a55','201711','Location véhicule','2017-11-01',115.00),(157,'a55','Mars','Location véhicule','0000-00-00',444.00),(158,'a55','Mars','Voyage SNCF','0000-00-00',124.00),(159,'a55','Mars','Achat de matériel de papèterie','0000-00-00',21.00),(160,'a55','Mars','Achat de matériel de papèterie','0000-00-00',40.00),(161,'a93','201610','Traiteur, alimentation, boisson','2016-10-10',60.00),(162,'a93','201611','Location salle conférence','2016-11-11',245.00),(163,'a93','201611','Rémunération intervenant/spécialiste','2016-11-02',823.00),(164,'a93','201612','Taxi','2016-12-25',46.00),(165,'a93','201612','Location équipement vidéo/sonore','2016-12-27',376.00),(166,'a93','201612','Location salle conférence','2016-12-01',482.00),(167,'a93','201701','Achat de matériel de papèterie','2017-01-03',17.00),(168,'a93','201701','Taxi','2017-01-23',47.00),(169,'a93','201701','Frais vestimentaire/représentation','2017-01-27',316.00),(170,'a93','201701','Repas avec praticien','2017-01-16',32.00),(171,'a93','201701','Repas avec praticien','2017-01-21',31.00),(172,'a93','201702','Achat de matériel de papèterie','2017-02-05',28.00),(173,'a93','201702','Frais vestimentaire/représentation','2017-02-15',311.00),(174,'a93','201702','Frais vestimentaire/représentation','2017-02-07',245.00),(175,'a93','201702','Achat de matériel de papèterie','2017-02-23',35.00),(176,'a93','201702','Location véhicule','2017-02-07',381.00),(177,'a93','201702','Frais vestimentaire/représentation','2017-02-23',263.00),(178,'a93','201704','Achat de matériel de papèterie','2017-04-01',24.00),(179,'a93','201704','Traiteur, alimentation, boisson','2017-04-11',238.00),(180,'a93','201704','Traiteur, alimentation, boisson','2017-04-23',430.00),(181,'a93','201704','Location salle conférence','2017-04-10',555.00),(182,'a93','201704','Traiteur, alimentation, boisson','2017-04-02',223.00),(183,'a93','201705','Location véhicule','2017-05-08',125.00),(184,'a93','201705','Achat de matériel de papèterie','2017-05-23',37.00),(185,'a93','201705','Traiteur, alimentation, boisson','2017-05-23',57.00),(186,'a93','201706','Location équipement vidéo/sonore','2017-06-03',174.00),(187,'a93','201706','Rémunération intervenant/spécialiste','2017-06-24',558.00),(188,'a93','201706','Repas avec praticien','2017-06-03',37.00),(189,'a93','201706','Repas avec praticien','2017-06-16',41.00),(190,'a93','201706','Traiteur, alimentation, boisson','2017-06-28',66.00),(191,'a93','201707','Achat de matériel de papèterie','2017-07-11',21.00),(192,'a93','201707','Location salle conférence','2017-07-18',623.00),(193,'a93','201707','Rémunération intervenant/spécialiste','2017-07-15',986.00),(194,'a93','201708','Taxi','2017-08-27',21.00),(195,'a93','201708','Achat de matériel de papèterie','2017-08-21',22.00),(196,'a93','201709','Location salle conférence','2017-09-18',421.00),(197,'a93','201709','Frais vestimentaire/représentation','2017-09-03',85.00),(198,'a93','201709','Taxi','2017-09-19',39.00),(199,'a93','201709','Location salle conférence','2017-09-17',382.00),(200,'a93','201709','Taxi','2017-09-26',74.00),(201,'a93','201710','Rémunération intervenant/spécialiste','2017-10-23',604.00),(202,'a93','201710','Repas avec praticien','2017-10-04',50.00),(203,'a93','201710','Location véhicule','2017-10-28',55.00),(204,'a93','201711','Repas avec praticien','2017-11-03',31.00),(205,'a93','201711','Achat de matériel de papèterie','2017-11-25',25.00),(206,'a93','201711','Location équipement vidéo/sonore','2017-11-12',758.00),(207,'a93','201711','Taxi','2017-11-21',20.00),(208,'a93','Avril','Traiteur, alimentation, boisson','0000-00-00',347.00),(209,'a93','Avril','Rémunération intervenant/spécialiste','0000-00-00',316.00),(210,'a93','Avril','Location véhicule','0000-00-00',70.00),(211,'b13','201609','Rémunération intervenant/spécialiste','2016-09-03',507.00),(212,'b13','201609','Repas avec praticien','2016-09-13',36.00),(213,'b13','201609','Location véhicule','2016-09-21',171.00),(214,'b13','201610','Location véhicule','2016-10-21',223.00),(215,'b13','201611','Location équipement vidéo/sonore','2016-11-25',466.00),(216,'b13','201611','Location équipement vidéo/sonore','2016-11-15',621.00),(217,'b13','201611','Location salle conférence','2016-11-26',564.00),(218,'b13','201612','Repas avec praticien','2016-12-01',45.00),(219,'b13','201612','Frais vestimentaire/représentation','2016-12-10',179.00),(220,'b13','201612','Location véhicule','2016-12-11',229.00),(221,'b13','201612','Voyage SNCF','2016-12-05',119.00),(222,'b13','201701','Frais vestimentaire/représentation','2017-01-15',86.00),(223,'b13','201701','Frais vestimentaire/représentation','2017-01-01',112.00),(224,'b13','201701','Repas avec praticien','2017-01-07',45.00),(225,'b13','201701','Location véhicule','2017-01-22',414.00),(226,'b13','201701','Repas avec praticien','2017-01-17',33.00),(227,'b13','201702','Location équipement vidéo/sonore','2017-02-19',426.00),(228,'b13','201702','Location véhicule','2017-02-15',391.00),(229,'b13','201702','Repas avec praticien','2017-02-20',34.00),(230,'b13','201702','Location équipement vidéo/sonore','2017-02-10',418.00),(231,'b13','201703','Location salle conférence','2017-03-11',247.00),(232,'b13','201703','Location véhicule','2017-03-18',246.00),(233,'b13','201703','Traiteur, alimentation, boisson','2017-03-21',309.00),(234,'b13','201703','Location véhicule','2017-03-07',284.00),(235,'b13','201703','Location véhicule','2017-03-04',131.00),(236,'b13','201703','Voyage SNCF','2017-03-11',114.00),(237,'b13','201704','Voyage SNCF','2017-04-10',97.00),(238,'b13','201704','Location salle conférence','2017-04-07',487.00),(239,'b13','201704','Traiteur, alimentation, boisson','2017-04-11',59.00),(240,'b13','201704','Rémunération intervenant/spécialiste','2017-04-10',719.00),(241,'b13','201704','Rémunération intervenant/spécialiste','2017-04-16',664.00),(242,'b13','201704','Location salle conférence','2017-04-14',242.00),(243,'b13','201705','Location véhicule','2017-05-11',106.00),(244,'b13','201706','Traiteur, alimentation, boisson','2017-06-24',136.00),(245,'b13','201706','Rémunération intervenant/spécialiste','2017-06-22',336.00),(246,'b13','201706','Repas avec praticien','2017-06-08',44.00),(247,'b13','201707','Frais vestimentaire/représentation','2017-07-25',166.00),(248,'b13','201707','Achat de matériel de papèterie','2017-07-10',36.00),(249,'b13','201707','Voyage SNCF','2017-07-07',149.00),(250,'b13','201708','Taxi','2017-08-27',52.00),(251,'b13','201708','Location équipement vidéo/sonore','2017-08-02',415.00),(252,'b13','201708','Taxi','2017-08-09',23.00),(253,'b13','201709','Rémunération intervenant/spécialiste','2017-09-03',389.00),(254,'b13','201709','Location équipement vidéo/sonore','2017-09-20',305.00),(255,'b13','201709','Rémunération intervenant/spécialiste','2017-09-14',840.00),(256,'b13','201709','Achat de matériel de papèterie','2017-09-21',27.00),(257,'b13','201710','Location salle conférence','2017-10-12',531.00),(258,'b13','201710','Traiteur, alimentation, boisson','2017-10-13',327.00),(259,'b13','201711','Voyage SNCF','2017-11-01',37.00),(260,'b13','201711','Repas avec praticien','2017-11-18',46.00),(261,'b13','201711','Location véhicule','2017-11-21',172.00),(262,'b13','201711','Frais vestimentaire/représentation','2017-11-03',276.00),(263,'b13','201711','Achat de matériel de papèterie','2017-11-27',21.00),(264,'b13','Mai','Location véhicule','0000-00-00',154.00),(265,'b16','201609','Voyage SNCF','2016-09-07',77.00),(266,'b16','201609','Taxi','2016-09-25',52.00),(267,'b16','201610','Taxi','2016-10-14',66.00),(268,'b16','201610','Achat de matériel de papèterie','2016-10-25',26.00),(269,'b16','201611','Location équipement vidéo/sonore','2016-11-03',536.00),(270,'b16','201611','Frais vestimentaire/représentation','2016-11-22',77.00),(271,'b16','201611','Rémunération intervenant/spécialiste','2016-11-03',943.00),(272,'b16','201612','Location équipement vidéo/sonore','2016-12-20',513.00),(273,'b16','201612','Location véhicule','2016-12-03',40.00),(274,'b16','201612','Location véhicule','2016-12-24',204.00),(275,'b16','201612','Location salle conférence','2016-12-01',346.00),(276,'b16','201701','Voyage SNCF','2017-01-09',94.00),(277,'b16','201701','Location salle conférence','2017-01-08',465.00),(278,'b16','201701','Repas avec praticien','2017-01-18',38.00),(279,'b16','201701','Traiteur, alimentation, boisson','2017-01-03',394.00),(280,'b16','201701','Location véhicule','2017-01-01',216.00),(281,'b16','201702','Voyage SNCF','2017-02-23',150.00),(282,'b16','201702','Rémunération intervenant/spécialiste','2017-02-23',721.00),(283,'b16','201702','Location équipement vidéo/sonore','2017-02-08',791.00),(284,'b16','201702','Location salle conférence','2017-02-13',186.00),(285,'b16','201703','Location équipement vidéo/sonore','2017-03-18',439.00),(286,'b16','201703','Location équipement vidéo/sonore','2017-03-17',767.00),(287,'b16','201703','Location véhicule','2017-03-28',205.00),(288,'b16','201703','Repas avec praticien','2017-03-09',30.00),(289,'b16','201704','Rémunération intervenant/spécialiste','2017-04-20',443.00),(290,'b16','201704','Voyage SNCF','2017-04-03',107.00),(291,'b16','201704','Achat de matériel de papèterie','2017-04-08',25.00),(292,'b16','201705','Traiteur, alimentation, boisson','2017-05-13',188.00),(293,'b16','201705','Rémunération intervenant/spécialiste','2017-05-18',1142.00),(294,'b16','201706','Rémunération intervenant/spécialiste','2017-06-06',522.00),(295,'b16','201707','Location véhicule','2017-07-05',153.00),(296,'b16','201707','Location véhicule','2017-07-16',419.00),(297,'b16','201707','Repas avec praticien','2017-07-25',33.00),(298,'b16','201707','Location salle conférence','2017-07-11',330.00),(299,'b16','201708','Frais vestimentaire/représentation','2017-08-19',197.00),(300,'b16','201709','Voyage SNCF','2017-09-25',45.00),(301,'b16','201709','Location salle conférence','2017-09-10',593.00),(302,'b16','201709','Traiteur, alimentation, boisson','2017-09-03',318.00),(303,'b16','201709','Taxi','2017-09-12',39.00),(304,'b16','201710','Location salle conférence','2017-10-27',234.00),(305,'b16','201710','Voyage SNCF','2017-10-07',69.00),(306,'b16','201710','Repas avec praticien','2017-10-11',33.00),(307,'b16','201710','Frais vestimentaire/représentation','2017-10-27',34.00),(308,'b16','201710','Voyage SNCF','2017-10-18',93.00),(309,'b16','201711','Repas avec praticien','2017-11-19',39.00),(310,'b19','201609','Repas avec praticien','2016-09-23',49.00),(311,'b19','201609','Repas avec praticien','2016-09-09',44.00),(312,'b19','201609','Location salle conférence','2016-09-14',545.00),(313,'b19','201611','Frais vestimentaire/représentation','2016-11-06',35.00),(314,'b19','201611','Achat de matériel de papèterie','2016-11-11',35.00),(315,'b19','201611','Location salle conférence','2016-11-07',217.00),(316,'b19','201611','Traiteur, alimentation, boisson','2016-11-10',334.00),(317,'b19','201612','Voyage SNCF','2016-12-03',59.00),(318,'b19','201612','Voyage SNCF','2016-12-28',71.00),(319,'b19','201612','Traiteur, alimentation, boisson','2016-12-01',96.00),(320,'b19','201612','Taxi','2016-12-26',47.00),(321,'b19','201612','Location salle conférence','2016-12-15',506.00),(322,'b19','201612','Location salle conférence','2016-12-04',366.00),(323,'b19','201701','Frais vestimentaire/représentation','2017-01-05',47.00),(324,'b19','201701','Traiteur, alimentation, boisson','2017-01-06',267.00),(325,'b19','201701','Voyage SNCF','2017-01-08',54.00),(326,'b19','201701','Repas avec praticien','2017-01-05',42.00),(327,'b19','201701','Rémunération intervenant/spécialiste','2017-01-19',420.00),(328,'b19','201702','Repas avec praticien','2017-02-10',41.00),(329,'b19','201702','Location équipement vidéo/sonore','2017-02-14',699.00),(330,'b19','201702','Taxi','2017-02-22',50.00),(331,'b19','201702','Traiteur, alimentation, boisson','2017-02-14',336.00),(332,'b19','201703','Taxi','2017-03-16',29.00),(333,'b19','201703','Rémunération intervenant/spécialiste','2017-03-11',451.00),(334,'b19','201703','Location équipement vidéo/sonore','2017-03-15',577.00),(335,'b19','201704','Traiteur, alimentation, boisson','2017-04-12',245.00),(336,'b19','201704','Location équipement vidéo/sonore','2017-04-26',805.00),(337,'b19','201704','Rémunération intervenant/spécialiste','2017-04-26',1157.00),(338,'b19','201704','Rémunération intervenant/spécialiste','2017-04-24',1034.00),(339,'b19','201705','Voyage SNCF','2017-05-06',140.00),(340,'b19','201706','Taxi','2017-06-22',75.00),(341,'b19','201707','Repas avec praticien','2017-07-14',33.00),(342,'b19','201707','Rémunération intervenant/spécialiste','2017-07-23',464.00),(343,'b19','201707','Traiteur, alimentation, boisson','2017-07-24',322.00),(344,'b19','201707','Achat de matériel de papèterie','2017-07-16',37.00),(345,'b19','201707','Location salle conférence','2017-07-10',291.00),(346,'b19','201707','Rémunération intervenant/spécialiste','2017-07-08',867.00),(347,'b19','201708','Frais vestimentaire/représentation','2017-08-03',322.00),(348,'b19','201708','Traiteur, alimentation, boisson','2017-08-02',332.00),(349,'b19','201708','Repas avec praticien','2017-08-28',49.00),(350,'b19','201709','Location équipement vidéo/sonore','2017-09-14',593.00),(351,'b19','201709','Traiteur, alimentation, boisson','2017-09-01',293.00),(352,'b19','201710','Voyage SNCF','2017-10-03',112.00),(353,'b19','201711','Traiteur, alimentation, boisson','2017-11-26',106.00),(354,'b19','201711','Traiteur, alimentation, boisson','2017-11-10',216.00),(355,'b19','201711','Location équipement vidéo/sonore','2017-11-01',600.00),(356,'b25','201609','Location équipement vidéo/sonore','2016-09-09',607.00),(357,'b25','201609','Location véhicule','2016-09-21',304.00),(358,'b25','201609','Location véhicule','2016-09-23',42.00),(359,'b25','201609','Traiteur, alimentation, boisson','2016-09-06',341.00),(360,'b25','201609','Location salle conférence','2016-09-17',233.00),(361,'b25','201609','Location équipement vidéo/sonore','2016-09-09',604.00),(362,'b25','201610','Location équipement vidéo/sonore','2016-10-26',198.00),(363,'b25','201610','Achat de matériel de papèterie','2016-10-27',37.00),(364,'b25','201610','Voyage SNCF','2016-10-14',33.00),(365,'b25','201610','Location salle conférence','2016-10-07',362.00),(366,'b25','201610','Voyage SNCF','2016-10-27',51.00),(367,'b25','201611','Location équipement vidéo/sonore','2016-11-24',382.00),(368,'b25','201611','Achat de matériel de papèterie','2016-11-10',41.00),(369,'b25','201611','Location équipement vidéo/sonore','2016-11-26',335.00),(370,'b25','201611','Location véhicule','2016-11-10',69.00),(371,'b25','201611','Achat de matériel de papèterie','2016-11-12',31.00),(372,'b25','201612','Location salle conférence','2016-12-19',365.00),(373,'b25','201612','Repas avec praticien','2016-12-25',44.00),(374,'b25','201612','Location salle conférence','2016-12-05',263.00),(375,'b25','201612','Voyage SNCF','2016-12-22',125.00),(376,'b25','201612','Repas avec praticien','2016-12-11',31.00),(377,'b25','201701','Frais vestimentaire/représentation','2017-01-01',27.00),(378,'b25','201701','Taxi','2017-01-15',46.00),(379,'b25','201701','Location équipement vidéo/sonore','2017-01-03',685.00),(380,'b25','201701','Achat de matériel de papèterie','2017-01-21',18.00),(381,'b25','201702','Voyage SNCF','2017-02-03',59.00),(382,'b25','201702','Achat de matériel de papèterie','2017-02-08',22.00),(383,'b25','201702','Traiteur, alimentation, boisson','2017-02-16',326.00),(384,'b25','201703','Location équipement vidéo/sonore','2017-03-08',311.00),(385,'b25','201703','Achat de matériel de papèterie','2017-03-07',46.00),(386,'b25','201703','Repas avec praticien','2017-03-21',34.00),(387,'b25','201704','Traiteur, alimentation, boisson','2017-04-27',387.00),(388,'b25','201704','Location salle conférence','2017-04-04',372.00),(389,'b25','201704','Traiteur, alimentation, boisson','2017-04-25',420.00),(390,'b25','201704','Repas avec praticien','2017-04-03',43.00),(391,'b25','201704','Traiteur, alimentation, boisson','2017-04-26',165.00),(392,'b25','201705','Rémunération intervenant/spécialiste','2017-05-19',1082.00),(393,'b25','201706','Taxi','2017-06-28',59.00),(394,'b25','201706','Frais vestimentaire/représentation','2017-06-11',181.00),(395,'b25','201707','Voyage SNCF','2017-07-03',46.00),(396,'b25','201708','Frais vestimentaire/représentation','2017-08-01',292.00),(397,'b25','201708','Taxi','2017-08-17',37.00),(398,'b25','201708','Traiteur, alimentation, boisson','2017-08-18',350.00),(399,'b25','201708','Rémunération intervenant/spécialiste','2017-08-13',336.00),(400,'b25','201709','Location équipement vidéo/sonore','2017-09-16',700.00),(401,'b25','201709','Taxi','2017-09-25',76.00),(402,'b25','201709','Taxi','2017-09-08',22.00),(403,'b25','201710','Repas avec praticien','2017-10-26',39.00),(404,'b25','201710','Traiteur, alimentation, boisson','2017-10-17',388.00),(405,'b25','201711','Rémunération intervenant/spécialiste','2017-11-02',647.00),(406,'b25','201711','Location véhicule','2017-11-17',262.00),(407,'b25','201711','Repas avec praticien','2017-11-27',42.00),(408,'b28','201609','Traiteur, alimentation, boisson','2016-09-04',208.00),(409,'b28','201610','Rémunération intervenant/spécialiste','2016-10-08',829.00),(410,'b28','201610','Location salle conférence','2016-10-22',491.00),(411,'b28','201610','Traiteur, alimentation, boisson','2016-10-22',398.00),(412,'b28','201611','Rémunération intervenant/spécialiste','2016-11-02',1058.00),(413,'b28','201611','Location équipement vidéo/sonore','2016-11-25',578.00),(414,'b28','201612','Frais vestimentaire/représentation','2016-12-20',86.00),(415,'b28','201612','Taxi','2016-12-09',67.00),(416,'b28','201612','Location salle conférence','2016-12-13',247.00),(417,'b28','201612','Achat de matériel de papèterie','2016-12-15',25.00),(418,'b28','201612','Rémunération intervenant/spécialiste','2016-12-01',1195.00),(419,'b28','201701','Taxi','2017-01-13',26.00),(420,'b28','201701','Taxi','2017-01-04',62.00),(421,'b28','201701','Location véhicule','2017-01-23',369.00),(422,'b28','201702','Achat de matériel de papèterie','2017-02-07',29.00),(423,'b28','201702','Voyage SNCF','2017-02-26',68.00),(424,'b28','201702','Voyage SNCF','2017-02-23',30.00),(425,'b28','201702','Repas avec praticien','2017-02-09',50.00),(426,'b28','201703','Frais vestimentaire/représentation','2017-03-23',272.00),(427,'b28','201703','Location équipement vidéo/sonore','2017-03-25',614.00),(428,'b28','201703','Location équipement vidéo/sonore','2017-03-23',704.00),(429,'b28','201704','Repas avec praticien','2017-04-02',35.00),(430,'b28','201704','Taxi','2017-04-24',51.00),(431,'b28','201705','Rémunération intervenant/spécialiste','2017-05-21',1029.00),(432,'b28','201705','Location équipement vidéo/sonore','2017-05-13',847.00),(433,'b28','201706','Achat de matériel de papèterie','2017-06-13',18.00),(434,'b28','201706','Taxi','2017-06-18',74.00),(435,'b28','201706','Location salle conférence','2017-06-08',397.00),(436,'b28','201707','Location salle conférence','2017-07-11',361.00),(437,'b28','201707','Voyage SNCF','2017-07-02',74.00),(438,'b28','201707','Location équipement vidéo/sonore','2017-07-27',110.00),(439,'b28','201707','Taxi','2017-07-18',71.00),(440,'b28','201707','Traiteur, alimentation, boisson','2017-07-11',92.00),(441,'b28','201708','Frais vestimentaire/représentation','2017-08-17',234.00),(442,'b28','201708','Rémunération intervenant/spécialiste','2017-08-24',682.00),(443,'b28','201709','Taxi','2017-09-06',46.00),(444,'b28','201710','Location salle conférence','2017-10-28',526.00),(445,'b28','201711','Voyage SNCF','2017-11-19',77.00),(446,'b28','201711','Taxi','2017-11-11',68.00),(447,'b28','201711','Location équipement vidéo/sonore','2017-11-11',795.00),(448,'b28','201711','Frais vestimentaire/représentation','2017-11-26',281.00),(449,'b34','201609','Achat de matériel de papèterie','2016-09-12',31.00),(450,'b34','201609','Voyage SNCF','2016-09-01',72.00),(451,'b34','201610','Taxi','2016-10-26',28.00),(452,'b34','201610','Repas avec praticien','2016-10-28',36.00),(453,'b34','201610','Traiteur, alimentation, boisson','2016-10-17',177.00),(454,'b34','201610','Taxi','2016-10-01',44.00),(455,'b34','201610','Voyage SNCF','2016-10-07',93.00),(456,'b34','201610','Frais vestimentaire/représentation','2016-10-01',41.00),(457,'b34','201611','Location salle conférence','2016-11-14',133.00),(458,'b34','201611','Location équipement vidéo/sonore','2016-11-28',221.00),(459,'b34','201611','Frais vestimentaire/représentation','2016-11-07',153.00),(460,'b34','201611','Rémunération intervenant/spécialiste','2016-11-06',317.00),(461,'b34','201611','Achat de matériel de papèterie','2016-11-17',13.00),(462,'b34','201611','Location équipement vidéo/sonore','2016-11-05',535.00),(463,'b34','201612','Rémunération intervenant/spécialiste','2016-12-10',658.00),(464,'b34','201701','Location véhicule','2017-01-07',259.00),(465,'b34','201701','Frais vestimentaire/représentation','2017-01-17',170.00),(466,'b34','201701','Taxi','2017-01-08',38.00),(467,'b34','201701','Repas avec praticien','2017-01-19',35.00),(468,'b34','201702','Location salle conférence','2017-02-09',149.00),(469,'b34','201702','Taxi','2017-02-24',75.00),(470,'b34','201702','Location salle conférence','2017-02-10',391.00),(471,'b34','201703','Traiteur, alimentation, boisson','2017-03-19',262.00),(472,'b34','201703','Achat de matériel de papèterie','2017-03-03',23.00),(473,'b34','201703','Frais vestimentaire/représentation','2017-03-08',286.00),(474,'b34','201704','Achat de matériel de papèterie','2017-04-15',20.00),(475,'b34','201704','Location véhicule','2017-04-16',290.00),(476,'b34','201704','Location véhicule','2017-04-18',160.00),(477,'b34','201704','Rémunération intervenant/spécialiste','2017-04-24',322.00),(478,'b34','201704','Repas avec praticien','2017-04-01',35.00),(479,'b34','201705','Voyage SNCF','2017-05-08',67.00),(480,'b34','201705','Traiteur, alimentation, boisson','2017-05-04',435.00),(481,'b34','201706','Location véhicule','2017-06-18',108.00),(482,'b34','201706','Location salle conférence','2017-06-27',635.00),(483,'b34','201706','Achat de matériel de papèterie','2017-06-25',43.00),(484,'b34','201706','Location équipement vidéo/sonore','2017-06-07',114.00),(485,'b34','201706','Repas avec praticien','2017-06-28',41.00),(486,'b34','201706','Location équipement vidéo/sonore','2017-06-25',144.00),(487,'b34','201707','Location véhicule','2017-07-10',139.00),(488,'b34','201707','Rémunération intervenant/spécialiste','2017-07-17',265.00),(489,'b34','201708','Frais vestimentaire/représentation','2017-08-06',89.00),(490,'b34','201708','Rémunération intervenant/spécialiste','2017-08-03',499.00),(491,'b34','201708','Location équipement vidéo/sonore','2017-08-06',619.00),(492,'b34','201708','Repas avec praticien','2017-08-02',44.00),(493,'b34','201708','Location véhicule','2017-08-23',151.00),(494,'b34','201709','Frais vestimentaire/représentation','2017-09-02',49.00),(495,'b34','201709','Frais vestimentaire/représentation','2017-09-04',59.00),(496,'b34','201709','Repas avec praticien','2017-09-10',38.00),(497,'b34','201710','Location équipement vidéo/sonore','2017-10-08',210.00),(498,'b34','201711','Repas avec praticien','2017-11-16',41.00),(499,'b34','201711','Voyage SNCF','2017-11-17',132.00),(500,'b34','201711','Achat de matériel de papèterie','2017-11-27',17.00),(501,'b34','201711','Frais vestimentaire/représentation','2017-11-10',134.00),(502,'b34','201711','Achat de matériel de papèterie','2017-11-16',48.00),(503,'b4','201609','Location équipement vidéo/sonore','2016-09-16',746.00),(504,'b4','201610','Location véhicule','2016-10-14',433.00),(505,'b4','201610','Voyage SNCF','2016-10-19',70.00),(506,'b4','201610','Location équipement vidéo/sonore','2016-10-27',599.00),(507,'b4','201610','Achat de matériel de papèterie','2016-10-23',31.00),(508,'b4','201610','Taxi','2016-10-16',57.00),(509,'b4','201610','Location salle conférence','2016-10-25',422.00),(510,'b4','201611','Taxi','2016-11-23',48.00),(511,'b4','201612','Location véhicule','2016-12-07',192.00),(512,'b4','201612','Traiteur, alimentation, boisson','2016-12-17',25.00),(513,'b4','201701','Frais vestimentaire/représentation','2017-01-18',173.00),(514,'b4','201701','Repas avec praticien','2017-01-18',31.00),(515,'b4','201701','Location équipement vidéo/sonore','2017-01-25',534.00),(516,'b4','201702','Voyage SNCF','2017-02-05',82.00),(517,'b4','201702','Achat de matériel de papèterie','2017-02-15',34.00),(518,'b4','201702','Achat de matériel de papèterie','2017-02-21',15.00),(519,'b4','201702','Location salle conférence','2017-02-03',559.00),(520,'b4','201702','Repas avec praticien','2017-02-05',43.00),(521,'b4','201702','Traiteur, alimentation, boisson','2017-02-28',131.00),(522,'b4','201703','Traiteur, alimentation, boisson','2017-03-19',84.00),(523,'b4','201703','Rémunération intervenant/spécialiste','2017-03-21',748.00),(524,'b4','201703','Repas avec praticien','2017-03-01',48.00),(525,'b4','201704','Location véhicule','2017-04-28',409.00),(526,'b4','201704','Location véhicule','2017-04-27',236.00),(527,'b4','201704','Location véhicule','2017-04-21',65.00),(528,'b4','201705','Location véhicule','2017-05-11',227.00),(529,'b4','201705','Frais vestimentaire/représentation','2017-05-14',83.00),(530,'b4','201706','Frais vestimentaire/représentation','2017-06-02',253.00),(531,'b4','201706','Location véhicule','2017-06-25',179.00),(532,'b4','201707','Location équipement vidéo/sonore','2017-07-01',834.00),(533,'b4','201707','Rémunération intervenant/spécialiste','2017-07-06',506.00),(534,'b4','201707','Location salle conférence','2017-07-24',430.00),(535,'b4','201708','Repas avec praticien','2017-08-21',39.00),(536,'b4','201708','Taxi','2017-08-21',58.00),(537,'b4','201708','Location véhicule','2017-08-07',121.00),(538,'b4','201708','Location salle conférence','2017-08-17',574.00),(539,'b4','201708','Traiteur, alimentation, boisson','2017-08-27',229.00),(540,'b4','201709','Location équipement vidéo/sonore','2017-09-14',594.00),(541,'b4','201709','Repas avec praticien','2017-09-21',50.00),(542,'b4','201709','Achat de matériel de papèterie','2017-09-20',29.00),(543,'b4','201709','Rémunération intervenant/spécialiste','2017-09-01',968.00),(544,'b4','201709','Rémunération intervenant/spécialiste','2017-09-03',988.00),(545,'b4','201709','Rémunération intervenant/spécialiste','2017-09-09',1154.00),(546,'b4','201710','Achat de matériel de papèterie','2017-10-23',43.00),(547,'b4','201710','Repas avec praticien','2017-10-15',34.00),(548,'b4','201710','Rémunération intervenant/spécialiste','2017-10-27',901.00),(549,'b4','201710','Traiteur, alimentation, boisson','2017-10-07',346.00),(550,'b4','201710','Traiteur, alimentation, boisson','2017-10-15',45.00),(551,'b4','201711','Voyage SNCF','2017-11-04',110.00),(552,'b4','201711','Taxi','2017-11-14',39.00),(553,'b4','201711','Achat de matériel de papèterie','2017-11-19',34.00),(554,'b4','201711','Location salle conférence','2017-11-26',161.00),(555,'b4','201711','Location équipement vidéo/sonore','2017-11-05',701.00),(556,'b50','201609','Location véhicule','2016-09-03',331.00),(557,'b50','201609','Voyage SNCF','2016-09-27',100.00),(558,'b50','201609','Taxi','2016-09-28',35.00),(559,'b50','201609','Achat de matériel de papèterie','2016-09-17',13.00),(560,'b50','201609','Repas avec praticien','2016-09-04',37.00),(561,'b50','201610','Taxi','2016-10-17',68.00),(562,'b50','201610','Repas avec praticien','2016-10-22',42.00),(563,'b50','201610','Location véhicule','2016-10-15',222.00),(564,'b50','201610','Rémunération intervenant/spécialiste','2016-10-19',404.00),(565,'b50','201611','Rémunération intervenant/spécialiste','2016-11-11',944.00),(566,'b50','201611','Taxi','2016-11-12',58.00),(567,'b50','201611','Rémunération intervenant/spécialiste','2016-11-15',1000.00),(568,'b50','201612','Traiteur, alimentation, boisson','2016-12-12',65.00),(569,'b50','201612','Rémunération intervenant/spécialiste','2016-12-23',979.00),(570,'b50','201612','Traiteur, alimentation, boisson','2016-12-03',52.00),(571,'b50','201612','Location véhicule','2016-12-08',100.00),(572,'b50','201612','Achat de matériel de papèterie','2016-12-03',17.00),(573,'b50','201612','Location véhicule','2016-12-22',155.00),(574,'b50','201701','Repas avec praticien','2017-01-04',44.00),(575,'b50','201701','Frais vestimentaire/représentation','2017-01-26',129.00),(576,'b50','201701','Traiteur, alimentation, boisson','2017-01-28',157.00),(577,'b50','201701','Traiteur, alimentation, boisson','2017-01-26',373.00),(578,'b50','201701','Location équipement vidéo/sonore','2017-01-28',534.00),(579,'b50','201701','Repas avec praticien','2017-01-06',38.00),(580,'b50','201702','Traiteur, alimentation, boisson','2017-02-25',27.00),(581,'b50','201702','Traiteur, alimentation, boisson','2017-02-21',53.00),(582,'b50','201702','Taxi','2017-02-12',44.00),(583,'b50','201702','Traiteur, alimentation, boisson','2017-02-13',77.00),(584,'b50','201702','Location véhicule','2017-02-11',289.00),(585,'b50','201703','Traiteur, alimentation, boisson','2017-03-16',402.00),(586,'b50','201703','Taxi','2017-03-06',49.00),(587,'b50','201703','Frais vestimentaire/représentation','2017-03-26',111.00),(588,'b50','201703','Frais vestimentaire/représentation','2017-03-11',191.00),(589,'b50','201703','Voyage SNCF','2017-03-21',42.00),(590,'b50','201704','Repas avec praticien','2017-04-22',35.00),(591,'b50','201704','Repas avec praticien','2017-04-18',43.00),(592,'b50','201705','Taxi','2017-05-11',39.00),(593,'b50','201705','Taxi','2017-05-19',30.00),(594,'b50','201705','Achat de matériel de papèterie','2017-05-25',25.00),(595,'b50','201705','Repas avec praticien','2017-05-21',38.00),(596,'b50','201706','Location véhicule','2017-06-10',34.00),(597,'b50','201706','Taxi','2017-06-27',76.00),(598,'b50','201706','Voyage SNCF','2017-06-16',106.00),(599,'b50','201706','Taxi','2017-06-23',73.00),(600,'b50','201707','Taxi','2017-07-12',71.00),(601,'b50','201707','Taxi','2017-07-16',43.00),(602,'b50','201707','Location équipement vidéo/sonore','2017-07-19',696.00),(603,'b50','201707','Traiteur, alimentation, boisson','2017-07-13',339.00),(604,'b50','201708','Location véhicule','2017-08-03',362.00),(605,'b50','201708','Taxi','2017-08-09',52.00),(606,'b50','201708','Location véhicule','2017-08-02',440.00),(607,'b50','201709','Repas avec praticien','2017-09-05',48.00),(608,'b50','201709','Voyage SNCF','2017-09-01',133.00),(609,'b50','201710','Voyage SNCF','2017-10-04',83.00),(610,'b50','201710','Repas avec praticien','2017-10-14',37.00),(611,'b50','201710','Rémunération intervenant/spécialiste','2017-10-18',494.00),(612,'b50','201710','Location salle conférence','2017-10-05',185.00),(613,'b50','201710','Taxi','2017-10-03',25.00),(614,'b50','201711','Taxi','2017-11-06',52.00),(615,'b50','201711','Rémunération intervenant/spécialiste','2017-11-03',782.00),(616,'b59','201609','Achat de matériel de papèterie','2016-09-27',27.00),(617,'b59','201609','Traiteur, alimentation, boisson','2016-09-05',330.00),(618,'b59','201610','Achat de matériel de papèterie','2016-10-22',22.00),(619,'b59','201610','Rémunération intervenant/spécialiste','2016-10-11',385.00),(620,'b59','201610','Location véhicule','2016-10-13',73.00),(621,'b59','201610','Rémunération intervenant/spécialiste','2016-10-15',1093.00),(622,'b59','201610','Rémunération intervenant/spécialiste','2016-10-07',1020.00),(623,'b59','201611','Location équipement vidéo/sonore','2016-11-20',169.00),(624,'b59','201611','Frais vestimentaire/représentation','2016-11-24',409.00),(625,'b59','201611','Rémunération intervenant/spécialiste','2016-11-14',661.00),(626,'b59','201612','Location véhicule','2016-12-20',365.00),(627,'b59','201612','Achat de matériel de papèterie','2016-12-12',36.00),(628,'b59','201701','Traiteur, alimentation, boisson','2017-01-24',33.00),(629,'b59','201701','Repas avec praticien','2017-01-06',31.00),(630,'b59','201701','Rémunération intervenant/spécialiste','2017-01-07',952.00),(631,'b59','201702','Location salle conférence','2017-02-11',429.00),(632,'b59','201702','Traiteur, alimentation, boisson','2017-02-24',303.00),(633,'b59','201702','Voyage SNCF','2017-02-18',143.00),(634,'b59','201703','Location équipement vidéo/sonore','2017-03-07',598.00),(635,'b59','201703','Repas avec praticien','2017-03-19',30.00),(636,'b59','201703','Frais vestimentaire/représentation','2017-03-12',132.00),(637,'b59','201704','Location équipement vidéo/sonore','2017-04-02',718.00),(638,'b59','201705','Traiteur, alimentation, boisson','2017-05-14',274.00),(639,'b59','201705','Location salle conférence','2017-05-20',306.00),(640,'b59','201705','Taxi','2017-05-07',40.00),(641,'b59','201705','Location véhicule','2017-05-27',35.00),(642,'b59','201706','Location salle conférence','2017-06-11',228.00),(643,'b59','201707','Traiteur, alimentation, boisson','2017-07-08',94.00),(644,'b59','201707','Taxi','2017-07-11',58.00),(645,'b59','201707','Location véhicule','2017-07-21',411.00),(646,'b59','201708','Repas avec praticien','2017-08-22',32.00),(647,'b59','201708','Traiteur, alimentation, boisson','2017-08-20',336.00),(648,'b59','201709','Location salle conférence','2017-09-09',359.00),(649,'b59','201709','Frais vestimentaire/représentation','2017-09-13',56.00),(650,'b59','201709','Repas avec praticien','2017-09-23',37.00),(651,'b59','201710','Voyage SNCF','2017-10-19',56.00),(652,'b59','201710','Location équipement vidéo/sonore','2017-10-08',713.00),(653,'b59','201711','Frais vestimentaire/représentation','2017-11-17',398.00),(654,'b59','201711','Repas avec praticien','2017-11-09',42.00),(655,'b59','201711','Repas avec praticien','2017-11-09',45.00),(656,'b59','201711','Location salle conférence','2017-11-04',593.00),(657,'b59','201711','Voyage SNCF','2017-11-17',131.00),(658,'c14','201609','Achat de matériel de papèterie','2016-09-12',21.00),(659,'c14','201609','Achat de matériel de papèterie','2016-09-07',43.00),(660,'c14','201609','Repas avec praticien','2016-09-08',45.00),(661,'c14','201609','Voyage SNCF','2016-09-22',57.00),(662,'c14','201610','Location salle conférence','2016-10-15',345.00),(663,'c14','201610','Repas avec praticien','2016-10-27',38.00),(664,'c14','201610','Rémunération intervenant/spécialiste','2016-10-06',555.00),(665,'c14','201610','Traiteur, alimentation, boisson','2016-10-21',234.00),(666,'c14','201610','Location équipement vidéo/sonore','2016-10-14',438.00),(667,'c14','201611','Voyage SNCF','2016-11-25',120.00),(668,'c14','201611','Frais vestimentaire/représentation','2016-11-20',416.00),(669,'c14','201611','Achat de matériel de papèterie','2016-11-18',40.00),(670,'c14','201612','Location équipement vidéo/sonore','2016-12-17',774.00),(671,'c14','201612','Location véhicule','2016-12-11',275.00),(672,'c14','201612','Traiteur, alimentation, boisson','2016-12-26',99.00),(673,'c14','201701','Repas avec praticien','2017-01-08',34.00),(674,'c14','201701','Location salle conférence','2017-01-07',198.00),(675,'c14','201702','Voyage SNCF','2017-02-21',149.00),(676,'c14','201702','Frais vestimentaire/représentation','2017-02-10',195.00),(677,'c14','201702','Location véhicule','2017-02-23',44.00),(678,'c14','201702','Location véhicule','2017-02-13',431.00),(679,'c14','201703','Frais vestimentaire/représentation','2017-03-07',378.00),(680,'c14','201703','Voyage SNCF','2017-03-10',44.00),(681,'c14','201704','Taxi','2017-04-12',59.00),(682,'c14','201705','Rémunération intervenant/spécialiste','2017-05-04',395.00),(683,'c14','201705','Location salle conférence','2017-05-10',562.00),(684,'c14','201705','Voyage SNCF','2017-05-27',57.00),(685,'c14','201706','Location salle conférence','2017-06-04',146.00),(686,'c14','201707','Location salle conférence','2017-07-24',290.00),(687,'c14','201708','Frais vestimentaire/représentation','2017-08-12',399.00),(688,'c14','201708','Taxi','2017-08-25',66.00),(689,'c14','201708','Taxi','2017-08-03',28.00),(690,'c14','201708','Frais vestimentaire/représentation','2017-08-15',450.00),(691,'c14','201708','Achat de matériel de papèterie','2017-08-21',31.00),(692,'c14','201709','Location salle conférence','2017-09-11',396.00),(693,'c14','201709','Achat de matériel de papèterie','2017-09-20',33.00),(694,'c14','201709','Repas avec praticien','2017-09-11',39.00),(695,'c14','201709','Location véhicule','2017-09-03',96.00),(696,'c14','201709','Voyage SNCF','2017-09-18',39.00),(697,'c14','201709','Achat de matériel de papèterie','2017-09-15',38.00),(698,'c14','201710','Location salle conférence','2017-10-19',150.00),(699,'c14','201711','Location véhicule','2017-11-13',450.00),(700,'c14','201711','Frais vestimentaire/représentation','2017-11-19',359.00),(701,'c14','201711','Rémunération intervenant/spécialiste','2017-11-22',1036.00),(702,'c14','201711','Location équipement vidéo/sonore','2017-11-05',527.00),(703,'c3','201609','Frais vestimentaire/représentation','2016-09-19',251.00),(704,'c3','201609','Location salle conférence','2016-09-28',246.00),(705,'c3','201609','Voyage SNCF','2016-09-17',70.00),(706,'c3','201610','Repas avec praticien','2016-10-17',34.00),(707,'c3','201610','Location équipement vidéo/sonore','2016-10-11',391.00),(708,'c3','201610','Frais vestimentaire/représentation','2016-10-04',310.00),(709,'c3','201610','Location véhicule','2016-10-08',108.00),(710,'c3','201611','Repas avec praticien','2016-11-17',32.00),(711,'c3','201611','Frais vestimentaire/représentation','2016-11-25',185.00),(712,'c3','201611','Location véhicule','2016-11-20',45.00),(713,'c3','201612','Traiteur, alimentation, boisson','2016-12-07',75.00),(714,'c3','201612','Location salle conférence','2016-12-25',626.00),(715,'c3','201612','Achat de matériel de papèterie','2016-12-12',28.00),(716,'c3','201612','Location salle conférence','2016-12-01',491.00),(717,'c3','201612','Frais vestimentaire/représentation','2016-12-19',389.00),(718,'c3','201612','Rémunération intervenant/spécialiste','2016-12-11',1017.00),(719,'c3','201701','Location véhicule','2017-01-18',246.00),(720,'c3','201701','Location véhicule','2017-01-13',192.00),(721,'c3','201701','Repas avec praticien','2017-01-17',48.00),(722,'c3','201701','Rémunération intervenant/spécialiste','2017-01-22',954.00),(723,'c3','201701','Location véhicule','2017-01-25',351.00),(724,'c3','201702','Voyage SNCF','2017-02-09',60.00),(725,'c3','201702','Repas avec praticien','2017-02-06',40.00),(726,'c3','201703','Location salle conférence','2017-03-12',525.00),(727,'c3','201703','Achat de matériel de papèterie','2017-03-11',30.00),(728,'c3','201703','Traiteur, alimentation, boisson','2017-03-15',450.00),(729,'c3','201704','Location salle conférence','2017-04-15',279.00),(730,'c3','201704','Frais vestimentaire/représentation','2017-04-21',414.00),(731,'c3','201705','Location véhicule','2017-05-20',345.00),(732,'c3','201705','Achat de matériel de papèterie','2017-05-15',23.00),(733,'c3','201705','Rémunération intervenant/spécialiste','2017-05-09',697.00),(734,'c3','201706','Repas avec praticien','2017-06-07',38.00),(735,'c3','201706','Location salle conférence','2017-06-09',478.00),(736,'c3','201706','Achat de matériel de papèterie','2017-06-01',15.00),(737,'c3','201706','Achat de matériel de papèterie','2017-06-12',33.00),(738,'c3','201706','Achat de matériel de papèterie','2017-06-13',36.00),(739,'c3','201707','Taxi','2017-07-12',48.00),(740,'c3','201707','Location véhicule','2017-07-15',194.00),(741,'c3','201707','Frais vestimentaire/représentation','2017-07-05',386.00),(742,'c3','201708','Rémunération intervenant/spécialiste','2017-08-04',295.00),(743,'c3','201708','Taxi','2017-08-13',76.00),(744,'c3','201708','Voyage SNCF','2017-08-05',64.00),(745,'c3','201708','Repas avec praticien','2017-08-22',39.00),(746,'c3','201708','Frais vestimentaire/représentation','2017-08-18',194.00),(747,'c3','201708','Achat de matériel de papèterie','2017-08-25',44.00),(748,'c3','201709','Traiteur, alimentation, boisson','2017-09-04',62.00),(749,'c3','201709','Repas avec praticien','2017-09-09',36.00),(750,'c3','201710','Rémunération intervenant/spécialiste','2017-10-27',899.00),(751,'c3','201710','Voyage SNCF','2017-10-27',104.00),(752,'c3','201711','Repas avec praticien','2017-11-10',50.00),(753,'c3','201711','Achat de matériel de papèterie','2017-11-24',40.00),(754,'c3','201711','Rémunération intervenant/spécialiste','2017-11-13',931.00),(755,'c3','201711','Location salle conférence','2017-11-26',160.00),(756,'c3','201711','Voyage SNCF','2017-11-21',113.00),(757,'c3','201711','Location véhicule','2017-11-03',264.00),(758,'c54','201609','Rémunération intervenant/spécialiste','2016-09-06',576.00),(759,'c54','201610','Taxi','2016-10-22',31.00),(760,'c54','201610','Location véhicule','2016-10-15',87.00),(761,'c54','201610','Location véhicule','2016-10-10',199.00),(762,'c54','201610','Repas avec praticien','2016-10-22',46.00),(763,'c54','201611','Frais vestimentaire/représentation','2016-11-11',388.00),(764,'c54','201612','Location salle conférence','2016-12-09',412.00),(765,'c54','201612','Frais vestimentaire/représentation','2016-12-01',425.00),(766,'c54','201612','Achat de matériel de papèterie','2016-12-19',16.00),(767,'c54','201701','Voyage SNCF','2017-01-18',85.00),(768,'c54','201701','Frais vestimentaire/représentation','2017-01-06',305.00),(769,'c54','201701','Location équipement vidéo/sonore','2017-01-02',118.00),(770,'c54','201701','Achat de matériel de papèterie','2017-01-23',13.00),(771,'c54','201701','Rémunération intervenant/spécialiste','2017-01-08',383.00),(772,'c54','201702','Location salle conférence','2017-02-02',477.00),(773,'c54','201703','Traiteur, alimentation, boisson','2017-03-07',366.00),(774,'c54','201703','Achat de matériel de papèterie','2017-03-23',39.00),(775,'c54','201704','Location salle conférence','2017-04-07',141.00),(776,'c54','201704','Rémunération intervenant/spécialiste','2017-04-23',278.00),(777,'c54','201704','Taxi','2017-04-10',43.00),(778,'c54','201704','Location équipement vidéo/sonore','2017-04-12',167.00),(779,'c54','201704','Location équipement vidéo/sonore','2017-04-05',623.00),(780,'c54','201704','Frais vestimentaire/représentation','2017-04-09',71.00),(781,'c54','201705','Repas avec praticien','2017-05-11',44.00),(782,'c54','201705','Location véhicule','2017-05-13',261.00),(783,'c54','201705','Traiteur, alimentation, boisson','2017-05-02',405.00),(784,'c54','201705','Location salle conférence','2017-05-23',287.00),(785,'c54','201705','Achat de matériel de papèterie','2017-05-04',11.00),(786,'c54','201705','Rémunération intervenant/spécialiste','2017-05-26',1100.00),(787,'c54','201706','Location salle conférence','2017-06-20',385.00),(788,'c54','201706','Taxi','2017-06-15',66.00),(789,'c54','201706','Location équipement vidéo/sonore','2017-06-02',459.00),(790,'c54','201707','Frais vestimentaire/représentation','2017-07-13',257.00),(791,'c54','201707','Rémunération intervenant/spécialiste','2017-07-26',709.00),(792,'c54','201708','Frais vestimentaire/représentation','2017-08-11',353.00),(793,'c54','201708','Voyage SNCF','2017-08-13',35.00),(794,'c54','201708','Repas avec praticien','2017-08-11',37.00),(795,'c54','201709','Traiteur, alimentation, boisson','2017-09-13',243.00),(796,'c54','201709','Repas avec praticien','2017-09-02',45.00),(797,'c54','201710','Location équipement vidéo/sonore','2017-10-04',268.00),(798,'c54','201710','Traiteur, alimentation, boisson','2017-10-02',214.00),(799,'c54','201710','Repas avec praticien','2017-10-09',40.00),(800,'c54','201711','Voyage SNCF','2017-11-15',144.00),(801,'c54','201711','Location salle conférence','2017-11-14',265.00),(802,'c54','201711','Repas avec praticien','2017-11-27',45.00),(803,'c54','201711','Taxi','2017-11-14',39.00),(804,'d13','201610','Achat de matériel de papèterie','2016-10-18',47.00),(805,'d13','201610','Voyage SNCF','2016-10-23',116.00),(806,'d13','201610','Location salle conférence','2016-10-13',299.00),(807,'d13','201610','Traiteur, alimentation, boisson','2016-10-12',448.00),(808,'d13','201611','Frais vestimentaire/représentation','2016-11-27',87.00),(809,'d13','201611','Frais vestimentaire/représentation','2016-11-10',70.00),(810,'d13','201612','Taxi','2016-12-04',64.00),(811,'d13','201612','Achat de matériel de papèterie','2016-12-22',50.00),(812,'d13','201612','Location véhicule','2016-12-19',150.00),(813,'d13','201612','Location véhicule','2016-12-03',385.00),(814,'d13','201701','Rémunération intervenant/spécialiste','2017-01-27',956.00),(815,'d13','201701','Repas avec praticien','2017-01-05',44.00),(816,'d13','201701','Rémunération intervenant/spécialiste','2017-01-07',1085.00),(817,'d13','201701','Location véhicule','2017-01-01',426.00),(818,'d13','201702','Location véhicule','2017-02-13',328.00),(819,'d13','201703','Location véhicule','2017-03-17',164.00),(820,'d13','201703','Location salle conférence','2017-03-10',511.00),(821,'d13','201703','Taxi','2017-03-11',65.00),(822,'d13','201703','Repas avec praticien','2017-03-12',36.00),(823,'d13','201703','Repas avec praticien','2017-03-08',38.00),(824,'d13','201703','Achat de matériel de papèterie','2017-03-16',42.00),(825,'d13','201704','Repas avec praticien','2017-04-20',43.00),(826,'d13','201704','Voyage SNCF','2017-04-18',43.00),(827,'d13','201704','Achat de matériel de papèterie','2017-04-07',50.00),(828,'d13','201704','Traiteur, alimentation, boisson','2017-04-05',450.00),(829,'d13','201705','Location salle conférence','2017-05-03',647.00),(830,'d13','201705','Location salle conférence','2017-05-22',610.00),(831,'d13','201705','Traiteur, alimentation, boisson','2017-05-09',144.00),(832,'d13','201705','Location véhicule','2017-05-27',35.00),(833,'d13','201706','Traiteur, alimentation, boisson','2017-06-07',177.00),(834,'d13','201706','Location équipement vidéo/sonore','2017-06-25',483.00),(835,'d13','201706','Voyage SNCF','2017-06-04',108.00),(836,'d13','201707','Location véhicule','2017-07-25',191.00),(837,'d13','201707','Location salle conférence','2017-07-14',145.00),(838,'d13','201707','Taxi','2017-07-09',41.00),(839,'d13','201707','Voyage SNCF','2017-07-19',56.00),(840,'d13','201708','Rémunération intervenant/spécialiste','2017-08-14',1023.00),(841,'d13','201708','Taxi','2017-08-13',64.00),(842,'d13','201708','Taxi','2017-08-19',31.00),(843,'d13','201709','Location salle conférence','2017-09-28',499.00),(844,'d13','201709','Voyage SNCF','2017-09-06',33.00),(845,'d13','201709','Location salle conférence','2017-09-22',450.00),(846,'d13','201710','Achat de matériel de papèterie','2017-10-16',50.00),(847,'d13','201710','Frais vestimentaire/représentation','2017-10-06',138.00),(848,'d13','201710','Taxi','2017-10-21',54.00),(849,'d13','201711','Location véhicule','2017-11-13',445.00),(850,'d13','201711','Traiteur, alimentation, boisson','2017-11-03',440.00),(851,'d51','201609','Location équipement vidéo/sonore','2016-09-24',690.00),(852,'d51','201609','Taxi','2016-09-09',48.00),(853,'d51','201609','Location équipement vidéo/sonore','2016-09-18',792.00),(854,'d51','201609','Repas avec praticien','2016-09-04',45.00),(855,'d51','201609','Location équipement vidéo/sonore','2016-09-27',603.00),(856,'d51','201609','Repas avec praticien','2016-09-03',31.00),(857,'d51','201610','Repas avec praticien','2016-10-02',45.00),(858,'d51','201610','Frais vestimentaire/représentation','2016-10-12',39.00),(859,'d51','201610','Traiteur, alimentation, boisson','2016-10-16',431.00),(860,'d51','201610','Location véhicule','2016-10-01',144.00),(861,'d51','201611','Location véhicule','2016-11-25',183.00),(862,'d51','201611','Voyage SNCF','2016-11-18',136.00),(863,'d51','201611','Achat de matériel de papèterie','2016-11-22',11.00),(864,'d51','201611','Repas avec praticien','2016-11-13',48.00),(865,'d51','201612','Location véhicule','2016-12-24',327.00),(866,'d51','201612','Frais vestimentaire/représentation','2016-12-07',279.00),(867,'d51','201701','Location véhicule','2017-01-25',172.00),(868,'d51','201701','Traiteur, alimentation, boisson','2017-01-02',228.00),(869,'d51','201701','Location salle conférence','2017-01-09',584.00),(870,'d51','201701','Location équipement vidéo/sonore','2017-01-02',830.00),(871,'d51','201702','Location équipement vidéo/sonore','2017-02-15',363.00),(872,'d51','201702','Voyage SNCF','2017-02-07',73.00),(873,'d51','201702','Location véhicule','2017-02-19',252.00),(874,'d51','201702','Achat de matériel de papèterie','2017-02-25',12.00),(875,'d51','201702','Voyage SNCF','2017-02-27',78.00),(876,'d51','201703','Taxi','2017-03-15',28.00),(877,'d51','201703','Location équipement vidéo/sonore','2017-03-15',467.00),(878,'d51','201703','Location salle conférence','2017-03-08',392.00),(879,'d51','201704','Achat de matériel de papèterie','2017-04-20',21.00),(880,'d51','201704','Rémunération intervenant/spécialiste','2017-04-13',944.00),(881,'d51','201705','Location salle conférence','2017-05-12',296.00),(882,'d51','201706','Achat de matériel de papèterie','2017-06-14',41.00),(883,'d51','201706','Location salle conférence','2017-06-24',240.00),(884,'d51','201706','Traiteur, alimentation, boisson','2017-06-19',329.00),(885,'d51','201706','Location équipement vidéo/sonore','2017-06-21',722.00),(886,'d51','201707','Taxi','2017-07-21',25.00),(887,'d51','201707','Rémunération intervenant/spécialiste','2017-07-16',656.00),(888,'d51','201707','Voyage SNCF','2017-07-03',89.00),(889,'d51','201708','Voyage SNCF','2017-08-25',63.00),(890,'d51','201708','Rémunération intervenant/spécialiste','2017-08-26',412.00),(891,'d51','201708','Location véhicule','2017-08-09',137.00),(892,'d51','201709','Rémunération intervenant/spécialiste','2017-09-23',568.00),(893,'d51','201709','Location salle conférence','2017-09-05',399.00),(894,'d51','201709','Repas avec praticien','2017-09-11',47.00),(895,'d51','201709','Traiteur, alimentation, boisson','2017-09-20',128.00),(896,'d51','201709','Frais vestimentaire/représentation','2017-09-14',313.00),(897,'d51','201709','Frais vestimentaire/représentation','2017-09-14',406.00),(898,'d51','201710','Location véhicule','2017-10-14',216.00),(899,'d51','201710','Voyage SNCF','2017-10-18',112.00),(900,'d51','201710','Achat de matériel de papèterie','2017-10-17',41.00),(901,'d51','201710','Taxi','2017-10-03',72.00),(902,'d51','201710','Frais vestimentaire/représentation','2017-10-25',169.00),(903,'d51','201711','Rémunération intervenant/spécialiste','2017-11-16',878.00),(904,'d51','201711','Traiteur, alimentation, boisson','2017-11-04',113.00),(905,'d51','201711','Achat de matériel de papèterie','2017-11-02',35.00),(906,'d51','201711','Rémunération intervenant/spécialiste','2017-11-04',894.00),(907,'e22','201609','Taxi','2016-09-06',65.00),(908,'e22','201609','Repas avec praticien','2016-09-27',34.00),(909,'e22','201609','Traiteur, alimentation, boisson','2016-09-23',428.00),(910,'e22','201610','Location véhicule','2016-10-05',345.00),(911,'e22','201610','Voyage SNCF','2016-10-06',107.00),(912,'e22','201610','Location équipement vidéo/sonore','2016-10-20',830.00),(913,'e22','201610','Achat de matériel de papèterie','2016-10-17',46.00),(914,'e22','201610','Traiteur, alimentation, boisson','2016-10-20',162.00),(915,'e22','201611','Location véhicule','2016-11-05',314.00),(916,'e22','201611','Location équipement vidéo/sonore','2016-11-25',554.00),(917,'e22','201611','Achat de matériel de papèterie','2016-11-08',24.00),(918,'e22','201611','Location équipement vidéo/sonore','2016-11-14',671.00),(919,'e22','201611','Location équipement vidéo/sonore','2016-11-04',296.00),(920,'e22','201611','Location équipement vidéo/sonore','2016-11-27',720.00),(921,'e22','201612','Frais vestimentaire/représentation','2016-12-02',143.00),(922,'e22','201612','Location équipement vidéo/sonore','2016-12-18',323.00),(923,'e22','201701','Traiteur, alimentation, boisson','2017-01-28',198.00),(924,'e22','201702','Frais vestimentaire/représentation','2017-02-21',201.00),(925,'e22','201702','Rémunération intervenant/spécialiste','2017-02-03',411.00),(926,'e22','201702','Taxi','2017-02-25',76.00),(927,'e22','201702','Rémunération intervenant/spécialiste','2017-02-08',892.00),(928,'e22','201702','Location salle conférence','2017-02-01',649.00),(929,'e22','201703','Voyage SNCF','2017-03-05',56.00),(930,'e22','201703','Location équipement vidéo/sonore','2017-03-09',321.00),(931,'e22','201703','Repas avec praticien','2017-03-04',41.00),(932,'e22','201703','Frais vestimentaire/représentation','2017-03-16',230.00),(933,'e22','201703','Taxi','2017-03-23',71.00),(934,'e22','201703','Frais vestimentaire/représentation','2017-03-13',274.00),(935,'e22','201704','Voyage SNCF','2017-04-13',50.00),(936,'e22','201704','Voyage SNCF','2017-04-11',140.00),(937,'e22','201704','Repas avec praticien','2017-04-19',50.00),(938,'e22','201705','Achat de matériel de papèterie','2017-05-14',47.00),(939,'e22','201705','Achat de matériel de papèterie','2017-05-07',23.00),(940,'e22','201705','Taxi','2017-05-02',48.00),(941,'e22','201705','Repas avec praticien','2017-05-22',31.00),(942,'e22','201706','Rémunération intervenant/spécialiste','2017-06-25',628.00),(943,'e22','201706','Rémunération intervenant/spécialiste','2017-06-09',911.00),(944,'e22','201706','Frais vestimentaire/représentation','2017-06-19',349.00),(945,'e22','201706','Voyage SNCF','2017-06-21',129.00),(946,'e22','201706','Frais vestimentaire/représentation','2017-06-19',153.00),(947,'e22','201707','Voyage SNCF','2017-07-19',54.00),(948,'e22','201707','Location salle conférence','2017-07-07',475.00),(949,'e22','201707','Location équipement vidéo/sonore','2017-07-11',391.00),(950,'e22','201707','Voyage SNCF','2017-07-15',75.00),(951,'e22','201708','Location véhicule','2017-08-23',388.00),(952,'e22','201708','Taxi','2017-08-13',42.00),(953,'e22','201709','Voyage SNCF','2017-09-04',80.00),(954,'e22','201710','Traiteur, alimentation, boisson','2017-10-11',51.00),(955,'e22','201710','Voyage SNCF','2017-10-07',48.00),(956,'e22','201710','Rémunération intervenant/spécialiste','2017-10-10',559.00),(957,'e22','201710','Frais vestimentaire/représentation','2017-10-09',332.00),(958,'e22','201711','Traiteur, alimentation, boisson','2017-11-24',131.00),(959,'e22','201711','Taxi','2017-11-18',63.00),(960,'e24','201609','Taxi','2016-09-13',23.00),(961,'e24','201609','Taxi','2016-09-09',66.00),(962,'e24','201609','Location équipement vidéo/sonore','2016-09-14',123.00),(963,'e24','201609','Location véhicule','2016-09-23',185.00),(964,'e24','201610','Traiteur, alimentation, boisson','2016-10-24',367.00),(965,'e24','201610','Location équipement vidéo/sonore','2016-10-02',619.00),(966,'e24','201610','Achat de matériel de papèterie','2016-10-27',33.00),(967,'e24','201610','Achat de matériel de papèterie','2016-10-09',17.00),(968,'e24','201611','Achat de matériel de papèterie','2016-11-15',15.00),(969,'e24','201611','Taxi','2016-11-10',77.00),(970,'e24','201612','Repas avec praticien','2016-12-12',47.00),(971,'e24','201612','Location véhicule','2016-12-19',134.00),(972,'e24','201701','Location salle conférence','2017-01-08',402.00),(973,'e24','201701','Achat de matériel de papèterie','2017-01-16',39.00),(974,'e24','201701','Traiteur, alimentation, boisson','2017-01-10',363.00),(975,'e24','201702','Taxi','2017-02-17',54.00),(976,'e24','201702','Repas avec praticien','2017-02-02',47.00),(977,'e24','201702','Location véhicule','2017-02-28',184.00),(978,'e24','201702','Location véhicule','2017-02-12',291.00),(979,'e24','201702','Voyage SNCF','2017-02-27',30.00),(980,'e24','201703','Location salle conférence','2017-03-14',485.00),(981,'e24','201703','Rémunération intervenant/spécialiste','2017-03-06',314.00),(982,'e24','201703','Location salle conférence','2017-03-06',210.00),(983,'e24','201703','Taxi','2017-03-05',47.00),(984,'e24','201703','Traiteur, alimentation, boisson','2017-03-15',106.00),(985,'e24','201703','Frais vestimentaire/représentation','2017-03-15',303.00),(986,'e24','201704','Rémunération intervenant/spécialiste','2017-04-01',1186.00),(987,'e24','201704','Frais vestimentaire/représentation','2017-04-15',299.00),(988,'e24','201705','Frais vestimentaire/représentation','2017-05-12',115.00),(989,'e24','201706','Achat de matériel de papèterie','2017-06-21',21.00),(990,'e24','201706','Taxi','2017-06-12',32.00),(991,'e24','201706','Rémunération intervenant/spécialiste','2017-06-18',724.00),(992,'e24','201706','Location équipement vidéo/sonore','2017-06-26',228.00),(993,'e24','201707','Frais vestimentaire/représentation','2017-07-24',202.00),(994,'e24','201708','Traiteur, alimentation, boisson','2017-08-18',45.00),(995,'e24','201708','Frais vestimentaire/représentation','2017-08-26',123.00),(996,'e24','201708','Achat de matériel de papèterie','2017-08-04',40.00),(997,'e24','201708','Achat de matériel de papèterie','2017-08-15',40.00),(998,'e24','201708','Location équipement vidéo/sonore','2017-08-09',328.00),(999,'e24','201708','Achat de matériel de papèterie','2017-08-13',35.00),(1000,'e24','201709','Location équipement vidéo/sonore','2017-09-11',773.00),(1001,'e24','201709','Repas avec praticien','2017-09-22',33.00),(1002,'e24','201710','Taxi','2017-10-26',74.00),(1003,'e24','201710','Location véhicule','2017-10-12',157.00),(1004,'e24','201711','Frais vestimentaire/représentation','2017-11-23',141.00),(1005,'e24','201711','Location véhicule','2017-11-18',370.00),(1006,'e24','201711','Rémunération intervenant/spécialiste','2017-11-03',1041.00),(1007,'e24','201711','Repas avec praticien','2017-11-09',37.00),(1008,'e24','201711','Repas avec praticien','2017-11-08',37.00),(1009,'e39','201609','Achat de matériel de papèterie','2016-09-03',47.00),(1010,'e39','201609','Frais vestimentaire/représentation','2016-09-21',324.00),(1011,'e39','201609','Achat de matériel de papèterie','2016-09-08',34.00),(1012,'e39','201609','Location salle conférence','2016-09-22',464.00),(1013,'e39','201610','Achat de matériel de papèterie','2016-10-15',40.00),(1014,'e39','201611','Traiteur, alimentation, boisson','2016-11-18',383.00),(1015,'e39','201611','Location salle conférence','2016-11-19',319.00),(1016,'e39','201611','Location salle conférence','2016-11-24',228.00),(1017,'e39','201612','Achat de matériel de papèterie','2016-12-16',37.00),(1018,'e39','201612','Frais vestimentaire/représentation','2016-12-21',259.00),(1019,'e39','201612','Voyage SNCF','2016-12-19',61.00),(1020,'e39','201612','Voyage SNCF','2016-12-11',107.00),(1021,'e39','201701','Location salle conférence','2017-01-27',530.00),(1022,'e39','201701','Frais vestimentaire/représentation','2017-01-02',95.00),(1023,'e39','201701','Location véhicule','2017-01-10',30.00),(1024,'e39','201701','Repas avec praticien','2017-01-08',41.00),(1025,'e39','201702','Traiteur, alimentation, boisson','2017-02-22',265.00),(1026,'e39','201702','Achat de matériel de papèterie','2017-02-09',29.00),(1027,'e39','201702','Repas avec praticien','2017-02-22',44.00),(1028,'e39','201702','Location équipement vidéo/sonore','2017-02-02',253.00),(1029,'e39','201702','Location équipement vidéo/sonore','2017-02-10',109.00),(1030,'e39','201703','Location équipement vidéo/sonore','2017-03-22',741.00),(1031,'e39','201703','Location véhicule','2017-03-18',446.00),(1032,'e39','201703','Achat de matériel de papèterie','2017-03-04',19.00),(1033,'e39','201703','Voyage SNCF','2017-03-10',138.00),(1034,'e39','201704','Location véhicule','2017-04-20',104.00),(1035,'e39','201704','Voyage SNCF','2017-04-25',131.00),(1036,'e39','201704','Location équipement vidéo/sonore','2017-04-23',562.00),(1037,'e39','201705','Location véhicule','2017-05-26',61.00),(1038,'e39','201705','Traiteur, alimentation, boisson','2017-05-14',367.00),(1039,'e39','201705','Rémunération intervenant/spécialiste','2017-05-22',824.00),(1040,'e39','201706','Voyage SNCF','2017-06-21',101.00),(1041,'e39','201706','Location salle conférence','2017-06-15',125.00),(1042,'e39','201707','Achat de matériel de papèterie','2017-07-12',24.00),(1043,'e39','201707','Taxi','2017-07-28',64.00),(1044,'e39','201707','Achat de matériel de papèterie','2017-07-27',41.00),(1045,'e39','201708','Frais vestimentaire/représentation','2017-08-02',173.00),(1046,'e39','201708','Taxi','2017-08-26',42.00),(1047,'e39','201708','Location salle conférence','2017-08-03',517.00),(1048,'e39','201708','Location véhicule','2017-08-15',165.00),(1049,'e39','201708','Location salle conférence','2017-08-20',640.00),(1050,'e39','201708','Achat de matériel de papèterie','2017-08-28',14.00),(1051,'e39','201709','Taxi','2017-09-04',42.00),(1052,'e39','201709','Location salle conférence','2017-09-12',348.00),(1053,'e39','201710','Location équipement vidéo/sonore','2017-10-28',474.00),(1054,'e39','201710','Location équipement vidéo/sonore','2017-10-04',481.00),(1055,'e39','201710','Achat de matériel de papèterie','2017-10-27',34.00),(1056,'e39','201711','Location salle conférence','2017-11-17',160.00),(1057,'e39','201711','Rémunération intervenant/spécialiste','2017-11-03',983.00),(1058,'e39','201711','Achat de matériel de papèterie','2017-11-24',43.00),(1059,'e39','201711','Traiteur, alimentation, boisson','2017-11-20',292.00),(1060,'e39','201711','Traiteur, alimentation, boisson','2017-11-19',412.00),(1061,'e49','201609','Taxi','2016-09-27',72.00),(1062,'e49','201610','Traiteur, alimentation, boisson','2016-10-11',287.00),(1063,'e49','201610','Voyage SNCF','2016-10-14',58.00),(1064,'e49','201610','Location véhicule','2016-10-20',37.00),(1065,'e49','201610','Location salle conférence','2016-10-11',469.00),(1066,'e49','201611','Location véhicule','2016-11-04',371.00),(1067,'e49','201611','Frais vestimentaire/représentation','2016-11-01',429.00),(1068,'e49','201611','Location équipement vidéo/sonore','2016-11-15',161.00),(1069,'e49','201611','Frais vestimentaire/représentation','2016-11-08',211.00),(1070,'e49','201612','Location véhicule','2016-12-21',283.00),(1071,'e49','201612','Frais vestimentaire/représentation','2016-12-17',156.00),(1072,'e49','201612','Taxi','2016-12-13',49.00),(1073,'e49','201612','Frais vestimentaire/représentation','2016-12-28',176.00),(1074,'e49','201612','Rémunération intervenant/spécialiste','2016-12-04',300.00),(1075,'e49','201612','Rémunération intervenant/spécialiste','2016-12-06',1200.00),(1076,'e49','201701','Voyage SNCF','2017-01-06',92.00),(1077,'e49','201701','Taxi','2017-01-13',72.00),(1078,'e49','201701','Voyage SNCF','2017-01-28',36.00),(1079,'e49','201701','Voyage SNCF','2017-01-20',51.00),(1080,'e49','201701','Traiteur, alimentation, boisson','2017-01-19',116.00),(1081,'e49','201702','Location salle conférence','2017-02-20',442.00),(1082,'e49','201702','Repas avec praticien','2017-02-24',34.00),(1083,'e49','201702','Voyage SNCF','2017-02-21',119.00),(1084,'e49','201703','Traiteur, alimentation, boisson','2017-03-26',449.00),(1085,'e49','201704','Frais vestimentaire/représentation','2017-04-14',253.00),(1086,'e49','201704','Location équipement vidéo/sonore','2017-04-27',143.00),(1087,'e49','201704','Location véhicule','2017-04-16',318.00),(1088,'e49','201704','Repas avec praticien','2017-04-05',36.00),(1089,'e49','201704','Location véhicule','2017-04-01',359.00),(1090,'e49','201705','Location salle conférence','2017-05-09',298.00),(1091,'e49','201705','Voyage SNCF','2017-05-27',92.00),(1092,'e49','201705','Location véhicule','2017-05-25',429.00),(1093,'e49','201706','Traiteur, alimentation, boisson','2017-06-19',170.00),(1094,'e49','201706','Location véhicule','2017-06-16',231.00),(1095,'e49','201706','Location salle conférence','2017-06-14',174.00),(1096,'e49','201707','Achat de matériel de papèterie','2017-07-20',31.00),(1097,'e49','201707','Location salle conférence','2017-07-05',259.00),(1098,'e49','201707','Rémunération intervenant/spécialiste','2017-07-22',1080.00),(1099,'e49','201708','Achat de matériel de papèterie','2017-08-28',37.00),(1100,'e49','201708','Repas avec praticien','2017-08-12',39.00),(1101,'e49','201708','Frais vestimentaire/représentation','2017-08-10',52.00),(1102,'e49','201708','Voyage SNCF','2017-08-07',34.00),(1103,'e49','201708','Rémunération intervenant/spécialiste','2017-08-09',837.00),(1104,'e49','201708','Traiteur, alimentation, boisson','2017-08-17',241.00),(1105,'e49','201709','Location équipement vidéo/sonore','2017-09-11',820.00),(1106,'e49','201709','Voyage SNCF','2017-09-17',51.00),(1107,'e49','201710','Rémunération intervenant/spécialiste','2017-10-22',708.00),(1108,'e49','201711','Voyage SNCF','2017-11-15',145.00),(1109,'e49','201711','Traiteur, alimentation, boisson','2017-11-21',354.00),(1110,'e49','201711','Taxi','2017-11-17',59.00),(1111,'e49','201711','Frais vestimentaire/représentation','2017-11-07',90.00),(1112,'e5','201610','Location véhicule','2016-10-07',358.00),(1113,'e5','201610','Voyage SNCF','2016-10-21',91.00),(1114,'e5','201610','Traiteur, alimentation, boisson','2016-10-02',73.00),(1115,'e5','201611','Traiteur, alimentation, boisson','2016-11-19',270.00),(1116,'e5','201611','Voyage SNCF','2016-11-20',79.00),(1117,'e5','201612','Frais vestimentaire/représentation','2016-12-07',255.00),(1118,'e5','201612','Traiteur, alimentation, boisson','2016-12-09',46.00),(1119,'e5','201612','Taxi','2016-12-18',63.00),(1120,'e5','201701','Achat de matériel de papèterie','2017-01-03',22.00),(1121,'e5','201701','Location équipement vidéo/sonore','2017-01-01',654.00),(1122,'e5','201701','Location salle conférence','2017-01-07',598.00),(1123,'e5','201702','Location équipement vidéo/sonore','2017-02-24',623.00),(1124,'e5','201702','Location équipement vidéo/sonore','2017-02-08',221.00),(1125,'e5','201703','Taxi','2017-03-19',23.00),(1126,'e5','201703','Traiteur, alimentation, boisson','2017-03-05',381.00),(1127,'e5','201703','Traiteur, alimentation, boisson','2017-03-10',158.00),(1128,'e5','201704','Achat de matériel de papèterie','2017-04-06',23.00),(1129,'e5','201704','Location équipement vidéo/sonore','2017-04-14',797.00),(1130,'e5','201704','Taxi','2017-04-09',52.00),(1131,'e5','201704','Taxi','2017-04-11',65.00),(1132,'e5','201704','Voyage SNCF','2017-04-05',146.00),(1133,'e5','201705','Voyage SNCF','2017-05-17',137.00),(1134,'e5','201705','Location salle conférence','2017-05-14',641.00),(1135,'e5','201705','Traiteur, alimentation, boisson','2017-05-09',178.00),(1136,'e5','201706','Voyage SNCF','2017-06-13',44.00),(1137,'e5','201707','Location véhicule','2017-07-13',260.00),(1138,'e5','201707','Traiteur, alimentation, boisson','2017-07-02',171.00),(1139,'e5','201708','Rémunération intervenant/spécialiste','2017-08-14',1139.00),(1140,'e5','201708','Traiteur, alimentation, boisson','2017-08-13',93.00),(1141,'e5','201708','Rémunération intervenant/spécialiste','2017-08-24',467.00),(1142,'e5','201708','Voyage SNCF','2017-08-15',70.00),(1143,'e5','201709','Location véhicule','2017-09-12',180.00),(1144,'e5','201709','Location équipement vidéo/sonore','2017-09-11',520.00),(1145,'e5','201709','Repas avec praticien','2017-09-05',40.00),(1146,'e5','201709','Location véhicule','2017-09-24',176.00),(1147,'e5','201709','Frais vestimentaire/représentation','2017-09-06',201.00),(1148,'e5','201710','Traiteur, alimentation, boisson','2017-10-26',27.00),(1149,'e5','201710','Achat de matériel de papèterie','2017-10-26',33.00),(1150,'e5','201711','Taxi','2017-11-08',22.00),(1151,'e5','201711','Achat de matériel de papèterie','2017-11-02',27.00),(1152,'e5','201711','Repas avec praticien','2017-11-02',48.00),(1153,'e52','201609','Location salle conférence','2016-09-18',523.00),(1154,'e52','201609','Achat de matériel de papèterie','2016-09-01',15.00),(1155,'e52','201609','Repas avec praticien','2016-09-05',36.00),(1156,'e52','201609','Traiteur, alimentation, boisson','2016-09-27',77.00),(1157,'e52','201610','Location véhicule','2016-10-20',149.00),(1158,'e52','201610','Frais vestimentaire/représentation','2016-10-27',263.00),(1159,'e52','201610','Achat de matériel de papèterie','2016-10-27',33.00),(1160,'e52','201610','Repas avec praticien','2016-10-06',49.00),(1161,'e52','201610','Location salle conférence','2016-10-13',364.00),(1162,'e52','201611','Rémunération intervenant/spécialiste','2016-11-22',675.00),(1163,'e52','201611','Location véhicule','2016-11-18',156.00),(1164,'e52','201611','Repas avec praticien','2016-11-07',43.00),(1165,'e52','201611','Location salle conférence','2016-11-07',409.00),(1166,'e52','201611','Rémunération intervenant/spécialiste','2016-11-05',1111.00),(1167,'e52','201612','Taxi','2016-12-04',53.00),(1168,'e52','201701','Location véhicule','2017-01-09',182.00),(1169,'e52','201701','Location salle conférence','2017-01-12',411.00),(1170,'e52','201702','Traiteur, alimentation, boisson','2017-02-27',398.00),(1171,'e52','201702','Frais vestimentaire/représentation','2017-02-08',409.00),(1172,'e52','201703','Taxi','2017-03-24',79.00),(1173,'e52','201703','Traiteur, alimentation, boisson','2017-03-23',173.00),(1174,'e52','201703','Repas avec praticien','2017-03-22',47.00),(1175,'e52','201703','Repas avec praticien','2017-03-10',36.00),(1176,'e52','201704','Location salle conférence','2017-04-08',468.00),(1177,'e52','201704','Location équipement vidéo/sonore','2017-04-01',306.00),(1178,'e52','201704','Frais vestimentaire/représentation','2017-04-05',319.00),(1179,'e52','201705','Location salle conférence','2017-05-10',622.00),(1180,'e52','201706','Taxi','2017-06-28',55.00),(1181,'e52','201706','Location équipement vidéo/sonore','2017-06-03',592.00),(1182,'e52','201707','Location équipement vidéo/sonore','2017-07-14',491.00),(1183,'e52','201707','Location véhicule','2017-07-23',135.00),(1184,'e52','201707','Voyage SNCF','2017-07-02',56.00),(1185,'e52','201707','Location salle conférence','2017-07-08',149.00),(1186,'e52','201707','Voyage SNCF','2017-07-15',33.00),(1187,'e52','201708','Location véhicule','2017-08-02',101.00),(1188,'e52','201708','Rémunération intervenant/spécialiste','2017-08-23',913.00),(1189,'e52','201708','Achat de matériel de papèterie','2017-08-12',28.00),(1190,'e52','201708','Location salle conférence','2017-08-26',145.00),(1191,'e52','201709','Frais vestimentaire/représentation','2017-09-09',370.00),(1192,'e52','201709','Voyage SNCF','2017-09-07',70.00),(1193,'e52','201710','Achat de matériel de papèterie','2017-10-07',16.00),(1194,'e52','201710','Repas avec praticien','2017-10-09',49.00),(1195,'e52','201710','Rémunération intervenant/spécialiste','2017-10-10',592.00),(1196,'e52','201710','Location salle conférence','2017-10-22',520.00),(1197,'e52','201711','Taxi','2017-11-11',39.00),(1198,'e52','201711','Taxi','2017-11-09',77.00),(1199,'e52','201711','Achat de matériel de papèterie','2017-11-02',25.00),(1200,'e52','201711','Location équipement vidéo/sonore','2017-11-13',309.00),(1201,'f21','201609','Achat de matériel de papèterie','2016-09-14',20.00),(1202,'f21','201609','Traiteur, alimentation, boisson','2016-09-05',27.00),(1203,'f21','201609','Location équipement vidéo/sonore','2016-09-27',547.00),(1204,'f21','201609','Location salle conférence','2016-09-01',536.00),(1205,'f21','201609','Taxi','2016-09-13',67.00),(1206,'f21','201609','Location salle conférence','2016-09-03',473.00),(1207,'f21','201610','Repas avec praticien','2016-10-22',38.00),(1208,'f21','201610','Location équipement vidéo/sonore','2016-10-16',716.00),(1209,'f21','201610','Location équipement vidéo/sonore','2016-10-02',620.00),(1210,'f21','201610','Repas avec praticien','2016-10-14',30.00),(1211,'f21','201610','Repas avec praticien','2016-10-01',32.00),(1212,'f21','201610','Achat de matériel de papèterie','2016-10-23',47.00),(1213,'f21','201611','Location véhicule','2016-11-02',379.00),(1214,'f21','201611','Traiteur, alimentation, boisson','2016-11-23',271.00),(1215,'f21','201611','Location véhicule','2016-11-09',389.00),(1216,'f21','201612','Frais vestimentaire/représentation','2016-12-25',48.00),(1217,'f21','201612','Traiteur, alimentation, boisson','2016-12-09',285.00),(1218,'f21','201612','Location équipement vidéo/sonore','2016-12-01',636.00),(1219,'f21','201612','Voyage SNCF','2016-12-14',93.00),(1220,'f21','201612','Location véhicule','2016-12-21',39.00),(1221,'f21','201701','Traiteur, alimentation, boisson','2017-01-08',154.00),(1222,'f21','201701','Taxi','2017-01-22',76.00),(1223,'f21','201702','Frais vestimentaire/représentation','2017-02-25',208.00),(1224,'f21','201702','Rémunération intervenant/spécialiste','2017-02-02',538.00),(1225,'f21','201703','Location véhicule','2017-03-28',106.00),(1226,'f21','201703','Traiteur, alimentation, boisson','2017-03-15',28.00),(1227,'f21','201703','Location véhicule','2017-03-09',312.00),(1228,'f21','201704','Location équipement vidéo/sonore','2017-04-14',760.00),(1229,'f21','201704','Rémunération intervenant/spécialiste','2017-04-06',383.00),(1230,'f21','201704','Frais vestimentaire/représentation','2017-04-14',431.00),(1231,'f21','201705','Taxi','2017-05-12',61.00),(1232,'f21','201705','Achat de matériel de papèterie','2017-05-11',14.00),(1233,'f21','201705','Taxi','2017-05-24',29.00),(1234,'f21','201705','Frais vestimentaire/représentation','2017-05-27',310.00),(1235,'f21','201705','Location salle conférence','2017-05-16',559.00),(1236,'f21','201705','Location équipement vidéo/sonore','2017-05-06',341.00),(1237,'f21','201706','Traiteur, alimentation, boisson','2017-06-18',444.00),(1238,'f21','201706','Repas avec praticien','2017-06-22',32.00),(1239,'f21','201707','Achat de matériel de papèterie','2017-07-10',17.00),(1240,'f21','201707','Location salle conférence','2017-07-14',467.00),(1241,'f21','201707','Voyage SNCF','2017-07-26',90.00),(1242,'f21','201708','Voyage SNCF','2017-08-03',30.00),(1243,'f21','201708','Repas avec praticien','2017-08-22',32.00),(1244,'f21','201708','Traiteur, alimentation, boisson','2017-08-02',253.00),(1245,'f21','201708','Achat de matériel de papèterie','2017-08-21',28.00),(1246,'f21','201708','Traiteur, alimentation, boisson','2017-08-27',358.00),(1247,'f21','201709','Location véhicule','2017-09-13',235.00),(1248,'f21','201709','Traiteur, alimentation, boisson','2017-09-19',33.00),(1249,'f21','201710','Location équipement vidéo/sonore','2017-10-15',665.00),(1250,'f21','201710','Location véhicule','2017-10-11',150.00),(1251,'f21','201710','Location salle conférence','2017-10-09',580.00),(1252,'f21','201711','Voyage SNCF','2017-11-05',121.00),(1253,'f21','201711','Traiteur, alimentation, boisson','2017-11-06',409.00),(1254,'f21','201711','Location équipement vidéo/sonore','2017-11-11',201.00),(1255,'f21','201711','Location véhicule','2017-11-21',51.00),(1256,'f21','201711','Taxi','2017-11-24',51.00),(1257,'f39','201609','Repas avec praticien','2016-09-24',43.00),(1258,'f39','201609','Voyage SNCF','2016-09-28',147.00),(1259,'f39','201609','Location salle conférence','2016-09-03',190.00),(1260,'f39','201610','Achat de matériel de papèterie','2016-10-04',12.00),(1261,'f39','201610','Frais vestimentaire/représentation','2016-10-15',87.00),(1262,'f39','201610','Achat de matériel de papèterie','2016-10-01',31.00),(1263,'f39','201610','Taxi','2016-10-12',70.00),(1264,'f39','201611','Rémunération intervenant/spécialiste','2016-11-23',328.00),(1265,'f39','201611','Traiteur, alimentation, boisson','2016-11-04',27.00),(1266,'f39','201611','Repas avec praticien','2016-11-17',36.00),(1267,'f39','201611','Location véhicule','2016-11-22',236.00),(1268,'f39','201611','Achat de matériel de papèterie','2016-11-03',28.00),(1269,'f39','201612','Location équipement vidéo/sonore','2016-12-26',334.00),(1270,'f39','201612','Location équipement vidéo/sonore','2016-12-23',835.00),(1271,'f39','201612','Location salle conférence','2016-12-22',441.00),(1272,'f39','201612','Voyage SNCF','2016-12-22',136.00),(1273,'f39','201612','Location véhicule','2016-12-04',354.00),(1274,'f39','201701','Location véhicule','2017-01-25',205.00),(1275,'f39','201702','Repas avec praticien','2017-02-11',38.00),(1276,'f39','201702','Location véhicule','2017-02-04',131.00),(1277,'f39','201702','Rémunération intervenant/spécialiste','2017-02-06',673.00),(1278,'f39','201702','Location salle conférence','2017-02-18',622.00),(1279,'f39','201702','Repas avec praticien','2017-02-01',50.00),(1280,'f39','201702','Location équipement vidéo/sonore','2017-02-21',332.00),(1281,'f39','201703','Location véhicule','2017-03-27',213.00),(1282,'f39','201703','Rémunération intervenant/spécialiste','2017-03-03',793.00),(1283,'f39','201703','Location salle conférence','2017-03-03',644.00),(1284,'f39','201703','Achat de matériel de papèterie','2017-03-23',37.00),(1285,'f39','201703','Location salle conférence','2017-03-24',309.00),(1286,'f39','201704','Rémunération intervenant/spécialiste','2017-04-28',579.00),(1287,'f39','201704','Achat de matériel de papèterie','2017-04-26',20.00),(1288,'f39','201704','Taxi','2017-04-03',63.00),(1289,'f39','201705','Location véhicule','2017-05-21',380.00),(1290,'f39','201706','Location salle conférence','2017-06-20',512.00),(1291,'f39','201707','Repas avec praticien','2017-07-01',39.00),(1292,'f39','201707','Location salle conférence','2017-07-24',269.00),(1293,'f39','201707','Location équipement vidéo/sonore','2017-07-27',537.00),(1294,'f39','201707','Location véhicule','2017-07-23',280.00),(1295,'f39','201707','Location salle conférence','2017-07-16',515.00),(1296,'f39','201708','Location véhicule','2017-08-21',123.00),(1297,'f39','201708','Rémunération intervenant/spécialiste','2017-08-13',976.00),(1298,'f39','201709','Location salle conférence','2017-09-16',359.00),(1299,'f39','201709','Voyage SNCF','2017-09-11',127.00),(1300,'f39','201710','Repas avec praticien','2017-10-04',47.00),(1301,'f39','201711','Traiteur, alimentation, boisson','2017-11-05',355.00),(1302,'f39','201711','Traiteur, alimentation, boisson','2017-11-18',159.00),(1303,'f4','201609','Rémunération intervenant/spécialiste','2016-09-06',419.00),(1304,'f4','201609','Frais vestimentaire/représentation','2016-09-21',141.00),(1305,'f4','201609','Voyage SNCF','2016-09-25',48.00),(1306,'f4','201610','Achat de matériel de papèterie','2016-10-07',35.00),(1307,'f4','201610','Achat de matériel de papèterie','2016-10-23',15.00),(1308,'f4','201610','Voyage SNCF','2016-10-18',120.00),(1309,'f4','201610','Taxi','2016-10-21',29.00),(1310,'f4','201611','Location équipement vidéo/sonore','2016-11-01',668.00),(1311,'f4','201611','Repas avec praticien','2016-11-02',50.00),(1312,'f4','201612','Taxi','2016-12-20',21.00),(1313,'f4','201612','Taxi','2016-12-18',33.00),(1314,'f4','201701','Rémunération intervenant/spécialiste','2017-01-02',266.00),(1315,'f4','201701','Rémunération intervenant/spécialiste','2017-01-10',1019.00),(1316,'f4','201702','Voyage SNCF','2017-02-19',145.00),(1317,'f4','201703','Repas avec praticien','2017-03-13',35.00),(1318,'f4','201703','Frais vestimentaire/représentation','2017-03-04',191.00),(1319,'f4','201703','Taxi','2017-03-27',80.00),(1320,'f4','201703','Location salle conférence','2017-03-21',168.00),(1321,'f4','201704','Location salle conférence','2017-04-10',446.00),(1322,'f4','201705','Repas avec praticien','2017-05-05',48.00),(1323,'f4','201706','Rémunération intervenant/spécialiste','2017-06-21',813.00),(1324,'f4','201706','Achat de matériel de papèterie','2017-06-05',28.00),(1325,'f4','201706','Repas avec praticien','2017-06-18',43.00),(1326,'f4','201706','Voyage SNCF','2017-06-20',118.00),(1327,'f4','201706','Location véhicule','2017-06-14',243.00),(1328,'f4','201707','Rémunération intervenant/spécialiste','2017-07-16',502.00),(1329,'f4','201707','Achat de matériel de papèterie','2017-07-20',41.00),(1330,'f4','201707','Location salle conférence','2017-07-04',458.00),(1331,'f4','201707','Traiteur, alimentation, boisson','2017-07-18',444.00),(1332,'f4','201708','Location équipement vidéo/sonore','2017-08-05',845.00),(1333,'f4','201708','Taxi','2017-08-25',41.00),(1334,'f4','201708','Location salle conférence','2017-08-17',217.00),(1335,'f4','201709','Frais vestimentaire/représentation','2017-09-27',333.00),(1336,'f4','201709','Voyage SNCF','2017-09-24',46.00),(1337,'f4','201710','Location véhicule','2017-10-18',326.00),(1338,'f4','201710','Frais vestimentaire/représentation','2017-10-23',203.00),(1339,'f4','201710','Rémunération intervenant/spécialiste','2017-10-27',1173.00),(1340,'f4','201710','Location salle conférence','2017-10-08',328.00),(1341,'f4','201711','Rémunération intervenant/spécialiste','2017-11-24',344.00),(1342,'f4','201711','Rémunération intervenant/spécialiste','2017-11-08',735.00),(1343,'f4','201711','Traiteur, alimentation, boisson','2017-11-28',201.00),(1344,'f4','201711','Location véhicule','2017-11-09',294.00);
211/*!40000 ALTER TABLE `lignefraishorsforfait` ENABLE KEYS */;
212UNLOCK TABLES;
213
214--
215-- Table structure for table `visiteur`
216--
217
218DROP TABLE IF EXISTS `visiteur`;
219/*!40101 SET @saved_cs_client = @@character_set_client */;
220/*!40101 SET character_set_client = utf8 */;
221CREATE TABLE `visiteur` (
222 `id` char(4) NOT NULL,
223 `nom` char(30) DEFAULT NULL,
224 `prenom` char(30) DEFAULT NULL,
225 `login` char(20) DEFAULT NULL,
226 `mdp` char(128) DEFAULT NULL,
227 `adresse` char(30) DEFAULT NULL,
228 `cp` char(5) DEFAULT NULL,
229 `ville` char(30) DEFAULT NULL,
230 `dateembauche` date DEFAULT NULL,
231 `idvoiture` char(3) NOT NULL,
232 PRIMARY KEY (`id`),
233 KEY `idvoiture` (`idvoiture`),
234 CONSTRAINT `visiteur_ibfk_1` FOREIGN KEY (`idvoiture`) REFERENCES `voiture` (`id`)
235) ENGINE=InnoDB DEFAULT CHARSET=latin1;
236/*!40101 SET character_set_client = @saved_cs_client */;
237
238--
239-- Dumping data for table `visiteur`
240--
241
242LOCK TABLES `visiteur` WRITE;
243/*!40000 ALTER TABLE `visiteur` DISABLE KEYS */;
244INSERT INTO `visiteur` VALUES ('a131','Villechalane','Louis','lvillachane','13dbdf7d3600e727d522707cb533f868367be729cdfc4032e6d06b8e6b19f911f63cf661fe56ad11169092488d210438e816f4f79078c295718df6262b290cd8','8 rue des Charmes','46000','Cahors','2005-12-21','V1D'),('a17','Andre','David','dandre','93c3d3d7ca890c6f3fd3fe5e270e9b0cde3aa69523208976b2e95fa382d7f43a4cf97a2a7bd10e88214065b27159cc0a0f97fedf53d800a5b9e276e28e17b4c2','1 rue Petit','46200','Lalbenque','1998-11-23','V2D'),('a55','Bedos','Christian','cbedos','0ef320534cc5e92a107325f6a3150cf641aaeb0b1e7b17ac3f89f1ef5c5238028b85b5cb3a2bb48e34d035735c2157a81b3eed31c7ef2e61f228c461975d700a','1 rue Peranud','46250','Montcuq','1995-01-12','V1E'),('a93','Tusseau','Louis','ltusseau','d3e4c8eb9180f86ef1627d46a8ec5a975caf70aa6135fb196a1a2aa56ebc246b42075fca83b61357afbc92f163bb0b55da6c2e9d59e19061fe59c6c4166d0f8d','22 rue des Ternes','46123','Gramat','2000-05-01','V2E'),('b13','Bentot','Pascal','pbentot','534a091cdb6432e844ef547bc1d87b5a99d5ab11a2a701e1db9ff80b4473869efb486c4f40caf350617d3c917c744df42e169454b04e1329e52126da71c7a6ed','11 allée des Cerises','46512','Bessines','1992-07-09','V1D'),('b16','Bioret','Luc','lbioret','6ca809e76a3830026782b6b0de6fdc8c4f24990a2cd95c5bbfe189256f7db3650d8dec40a846cfbe157cc9a228d15b5ba1a0b5cbd43850a9f47b1a9e0c0f2a06','1 Avenue gambetta','46000','Cahors','1998-05-11','V2D'),('b19','Bunisset','Francis','fbunisset','1f3eab5ab9fc9945bf8e0e80ca93975f5f5d985257a24455290eaf70182cb8ce9fdd5e686e253d40fc31acbef27b7dc47c40f32456de8549ac642b0bee660ef5','10 rue des Perles','93100','Montreuil','1987-10-21','V1E'),('b25','Bunisset','Denise','dbunisset','68ee1cf8a33c8f052ad57cafa14026b22e6c3d9dc1394782efaea901af7dcae44d8bc8f144ff8339713099c11953e7da087619a5e43d278d84c03b46d589f9c8','23 rue Manin','75019','paris','2010-12-05','V2E'),('b28','Cacheux','Bernard','bcacheux','c27bce94a964281439ea6a17ab46ce6e0670da3877c93df0cd5e14ebe0aef3bce66c3bea7257f3b27d034e398a7089888e3b255f4a49caaccff980879ad4c1fd','114 rue Blanche','75017','Paris','2009-11-12','V1D'),('b34','Cadic','Eric','ecadic','e459545a65f978f12eaff36ad96f475ea9e2d497ab1c29a4fdccc8c889b996bfd20c91c9c7296f4b0532feabae0fd25068fa253fad2fd8e03ab9b5b637a2edef','123 avenue de la République','75011','Paris','2008-09-23','V2D'),('b4','Charoze','Catherine','ccharoze','9fce860fede4fb4441e65ae1957675bea6d00f74533f10fd47e493dddaa2da2ab29ef409538a047459e9997c378b7d2694dda5d5d68791ef074f8f66b337ed9b','100 rue Petit','75019','Paris','2005-11-12','V1E'),('b50','Clepkens','Christophe','cclepkens','b8864461865eaab5b66ee5ad083a8a4620beed4e20cfd7e4ee76bc10677610893fbfe64c63f48af01fb5bb2f6d0690a70efef72879a9a0192310c60e48f09897','12 allée des Anges','93230','Romainville','2003-08-11','V2E'),('b59','Cottin','Vincenne','vcottin','6e5d9d888f31ee2e4c90e89ca1f54420ce2e7b7c4d9a08174f697e415bf69fdea5d9ab59c9652e912867991451fe800f93d66c5ee009ae65b664c385cb8d7bcd','36 rue Des Roches','93100','Monteuil','2001-11-18','V1D'),('c14','Daburon','François','fdaburon','6352987726652d06b4cebc40ced3eead997a1adaffee47dce53c2df01970ed900824ee05f72a6b9e314e053f7cd1e7763ebe962b586641d059ac95a32ff175a7','13 rue de Chanzy','94000','Créteil','2002-02-11','V2D'),('c3','De','Philippe','pde','62d8e965a3cceb4ded0f95b1158ded7b6fa3ec7c654f1ae322c8bea78f7ccd46b524f46c1f61242b3fd12bb7fdc5959a8ed194feec2ac1a2fbb809e74bb45f3a','13 rue Barthes','94000','Créteil','2010-12-14','V1E'),('c54','Debelle','Michel','mdebelle','f73a98ab9a0561e7d898969e93f0f27e77fb34e91821b21227f3aad8e01278efe07d5f32ebd4bc5601277ea8c6b22deb27009b59e11306523eb794ffa2981aa7','181 avenue Barbusse','93210','Rosny','2006-11-23','V2E'),('d13','Debelle','Jeanne','jdebelle','8bba249274c8439780fd90f436ca62100979116e598663c24642d0a371ab71970032c3fa0b9da1573db80f867fd00c7b463b16c64d9819f022b656041aaf7fd6','134 allée des Joncs','44000','Nantes','2000-05-11','V1D'),('d51','Debroise','Michel','mdebroise','dfe7b593ddb72898a0bbf326ef249efbfb1e278a04716d07f1e5baa23732a55313c5169e2c0a760c981d56cb87e65855beeb8d595704f4886612dc86e55edb11','2 Bld Jourdain','44000','Nantes','2001-04-17','V2D'),('e22','Desmarquest','Nathalie','ndesmarquest','c95dd9f05de37f54df7f202a0c0f5a39552eb72661b7da84b9a3e782216ae1d1788188e5ca83dcc1d16b743588812fccc3d69e6a9adfcd7836a6b9c907770cd2','14 Place d Arc','45000','Orléans','2005-11-12','V1E'),('e24','Desnost','Pierre','pdesnost','3d078e614b8ea8c6e22de1fa797a1a44cf697687e45e27d81f24a15a7a782db4965f315b37f066a1a6a405930e2ff8363ba9efa7884f727784144df0b34f958f','16 avenue des Cèdres','23200','Guéret','2001-02-05','V2E'),('e39','Dudouit','Frédéric','fdudouit','707736ce79cbfaab003254677f4fae59c6e83df5ea81851d503b622b6a9ed0fb79d13d6ea3136a8de5325734798b8c216030ddf1c0a2268abf2da3fa6bb752ed','18 rue de l église','23120','GrandBourg','2000-08-01','V1D'),('e49','Duncombe','Claude','cduncombe','4d62f09c266b7c81539a658af42daebeaf3701d9a8922c982d3711e97de2b897a988488726001cb5772d3b5e42b93f03882ef0e8d0a5a18cc200a5559bac369e','19 rue de la tour','23100','La souteraine','1987-10-10','V2D'),('e5','Enault-Pascreau','Céline','cenault','a309a05d7051be5dab6933292007ec6c9012a16682fe30a1c1b03726ba1811cc9b8f63651315d073eff66cfad821bb4d1c56c89597e8058f2238ee7204a3f902','25 place de la gare','23200','Gueret','1995-09-01','V1E'),('e52','Eynde','Valérie','veynde','c58437bafd323a6da6de8780bc9fc088c457231062fca2b1b4333eec07981166f9ea9b3d09f4e5fa6f8d6354efe85b39a07f86fb153721f5807adbadd9958ec2','3 Grand Place','13015','Marseille','1999-11-01','V2E'),('f21','Finck','Jacques','jfinck','9edf00a05e0aeaf318ea0dcc14d631056a88d9c2de3420b6ea439395ddc24057640390c5135a9a31964f0b6c5eb54ee89869df2af8a6bd16392ba7a1edef39a3','10 avenue du Prado','13002','Marseille','2001-11-10','V1D'),('f39','Frémont','Fernande','ffremont','32061e7c2ef0dde665e7b6a70722a1a93225a33ac4928000e0e940198c823859332bc906494065745e5216b387bd0224ae746248d7a5b8a284ced8df85e8f84f','4 route de la mer','13012','Allauh','1998-10-01','V2D'),('f4','Gest','Alain','agest','889fe2177c79378eaa9b57f8a62a6e5afc95b10178598bcb3bbfd39aedaa2d49007ee2165d29486d9e5b8443e1b1c8d884982a630a68e0d4f081b86c8e4b2bcf','30 avenue de la mer','13025','Berre','1985-11-01','V1E');
245/*!40000 ALTER TABLE `visiteur` ENABLE KEYS */;
246UNLOCK TABLES;
247
248--
249-- Table structure for table `voiture`
250--
251
252DROP TABLE IF EXISTS `voiture`;
253/*!40101 SET @saved_cs_client = @@character_set_client */;
254/*!40101 SET character_set_client = utf8 */;
255CREATE TABLE `voiture` (
256 `id` char(3) NOT NULL,
257 `cv` int(11) NOT NULL,
258 `typemoteur` char(30) NOT NULL,
259 `indemnkm` int(11) NOT NULL,
260 PRIMARY KEY (`id`)
261) ENGINE=InnoDB DEFAULT CHARSET=latin1;
262/*!40101 SET character_set_client = @saved_cs_client */;
263
264--
265-- Dumping data for table `voiture`
266--
267
268LOCK TABLES `voiture` WRITE;
269/*!40000 ALTER TABLE `voiture` DISABLE KEYS */;
270INSERT INTO `voiture` VALUES ('V1D',4,'Diesel',1),('V1E',4,'Essence',1),('V2D',5,'Diesel',1),('V2E',5,'Essence',1);
271/*!40000 ALTER TABLE `voiture` ENABLE KEYS */;
272UNLOCK TABLES;
273/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
274
275/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
276/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
277/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
278/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
279/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
280/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
281/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
282
283-- Dump completed on 2017-12-13 8:56:25