--
-- Host: localhost    Database: wefeatitkcdba
-- ------------------------------------------------------


--
-- Table structure for table `account_balances`
--

CREATE TABLE `account_balances` (
  `id` int NOT NULL AUTO_INCREMENT,
  `chart_of_accounts_id` int DEFAULT NULL,
  `accounting_period_id` int DEFAULT NULL,
  `balance` decimal(15,2) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_396906B9196B9FF2` (`chart_of_accounts_id`),
  KEY `IDX_396906B9BF806DC3` (`accounting_period_id`),
  CONSTRAINT `FK_396906B9196B9FF2` FOREIGN KEY (`chart_of_accounts_id`) REFERENCES `chart_of_accounts` (`id`),
  CONSTRAINT `FK_396906B9BF806DC3` FOREIGN KEY (`accounting_period_id`) REFERENCES `accounting_period` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `account_balances`
--


--
-- Table structure for table `accounting_period`
--

CREATE TABLE `accounting_period` (
  `id` int NOT NULL AUTO_INCREMENT,
  `start` date NOT NULL,
  `end` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accounting_period`
--

INSERT INTO `accounting_period` VALUES (1,'2019-07-01','2020-12-31'),(2,'2021-01-01','2021-12-31'),(3,'2022-01-01','2022-12-31'),(4,'2023-01-01','2023-12-31'),(5,'2024-01-01','2024-12-31'),(6,'2025-01-01','2025-12-31'),(7,'2026-01-01','2026-12-31'),(8,'2027-01-01','2027-12-31'),(9,'2028-01-01','2028-12-31'),(10,'2029-01-01','2029-12-31'),(11,'2030-01-01','2030-12-31');

--
-- Table structure for table `bank_statement`
--

CREATE TABLE `bank_statement` (
  `id` int NOT NULL AUTO_INCREMENT,
  `accounting_period_id` int DEFAULT NULL,
  `id_str` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `cdts` date NOT NULL,
  `obverse_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `obverse_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `amount` double NOT NULL,
  `currency` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `communications` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `type` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `journal_entry_id` int DEFAULT NULL,
  `matched_entry_id` int DEFAULT NULL,
  `suggested_template_id` int DEFAULT NULL,
  `matched` tinyint(1) DEFAULT NULL,
  `matching_score` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_B33607EFBF806DC3` (`accounting_period_id`),
  KEY `IDX_B33607EF6A86E4FB` (`journal_entry_id`),
  KEY `IDX_B33607EFC2A10C44` (`matched_entry_id`),
  KEY `IDX_B33607EFCA8B4CCA` (`suggested_template_id`),
  CONSTRAINT `FK_B33607EF6A86E4FB` FOREIGN KEY (`journal_entry_id`) REFERENCES `journal_entries` (`id`),
  CONSTRAINT `FK_B33607EFBF806DC3` FOREIGN KEY (`accounting_period_id`) REFERENCES `accounting_period` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_B33607EFC2A10C44` FOREIGN KEY (`matched_entry_id`) REFERENCES `journal_entries` (`id`),
  CONSTRAINT `FK_B33607EFCA8B4CCA` FOREIGN KEY (`suggested_template_id`) REFERENCES `journal_entry_template` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9053 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bank_statement`
--

INSERT INTO `bank_statement` VALUES (8352,4,'168349680073.55','2023-05-08','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-73.55,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0722019142 R B3494125 //20230504-BEDO1 REFERENCE DU    CREANCIER : I0000050848413-110407220191422023          REF. : 0819658520981 VAL. 08-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8353,4,'16834968002221.71','2023-05-08','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-2221.71,'EUR','04/2023','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8354,4,'168349680040.47','2023-05-08','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-40.47,'EUR','+++188/7884/60889+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8355,4,'1683496800539.01','2023-05-08','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-539.01,'EUR','+++188/7884/50684+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8356,4,'1683237600419.6','2023-05-05','','HERPIGNY-MOTORS  S.A.  COG',NULL,-419.6,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 05/05 17:56 HERPIGNY-MOTORS S.   A. COG                                                 REF. : 0058994961771 VAL. 05-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8357,4,'16832376007.96','2023-05-05','','',NULL,-7.96,'EUR','PARTICIPATION AUX FRAIS DE TENUE DE VOTRE BELFIUS      BUSINESS PACK PLUS                                     REF. : 0816454057965 VAL. 01-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8358,4,'1683237600492.2','2023-05-05','','AL BARAQUE             SAI',NULL,-492.2,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 05/05 01:30 AL BARAQUE SAI       REF. : 0497224241294 VAL. 05-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8359,4,'168315120022','2023-05-04','','PARKING INDUSTRIE 1194 BRU',NULL,-22,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 04/05 16:15 PARKING  INDUSTRIE 1194 BRU                                     REF. : 0050176731681 VAL. 04-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8360,4,'1683151200121.06','2023-05-04','666-0000004-83','',NULL,-121.06,'EUR','VISA RELEVE NUMERO 115                                 REF. : 0807554208612 VAL. 04-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8361,4,'168315120065.87','2023-05-04','BE36 0912 1503 4881','SPW',NULL,-65.87,'EUR','+++012/4538/54349+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8362,4,'168297840048','2023-05-02','','MEGA GRILL GREZ-DOIC',NULL,-48,'EUR','PAIEMENT MAESTRO VIA APPLE PAY 28/04 MEGA GRILL GREZ-  DOIC ARCHENNES BE 48,00 EUR CARTE N 6703 0700 3436    4800 - LEGARDIEN FREDERIC                              REF. : 0801K52044436 VAL. 02-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8363,4,'1682978400336.49','2023-05-02','BE41 2500 0974 1010','ROTARY',NULL,-336.49,'EUR','4138','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8364,4,'16829784002087.91','2023-05-02','BE80 0000 0010 4777','CAISSE D\'ASS SOCIALES UCM',NULL,-2087.91,'EUR','+++500/3483/37682+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8365,4,'1682546400629.2','2023-04-27','BE14 0689 3381 4983','CABINET COMPTABLE LAURENT',NULL,-629.2,'EUR','+++000/0175/25270+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8366,4,'168237360029.83','2023-04-25','BE61 0910 1660 5217','PROXIMUS SA',NULL,-29.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007303098411 REFERENCE DU  CREANCIER : 3009475768                                 REF. : 081964P027076 VAL. 25-04','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8367,4,'168228720015143.15','2023-04-24','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,15143.15,'EUR','WFI0003','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8368,4,'1682287200123.7','2023-04-24','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-123.7,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0721951256 R B3405731 //20230420-BEDO1 REFERENCE DU    CREANCIER : I0000050368055-110407219512562023          REF. : 081964O122530 VAL. 24-04','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8369,4,'16819416005277.24','2023-04-20','BE22 6792 0030 0047','SERVICE T.V.A.-RECETTES',NULL,-5277.24,'EUR','+++072/8750/01371+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8370,4,'168125040057','2023-04-12','BE14 0689 3381 4983','CABINET COMPTABLE BARBARA LAURENT',NULL,-57,'EUR','FRAIS DE PUBLICATION','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8371,4,'16812504002555.06','2023-04-12','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-2555.06,'EUR','03/2023','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8372,4,'16812504002555.06','2023-04-12','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-2555.06,'EUR','02/2023','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8373,4,'16812504001055.06','2023-04-12','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-1055.06,'EUR','01/2023 REGULARISATION','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8374,4,'1681250400539.01','2023-04-12','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-539.01,'EUR','+++187/7946/70631+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8375,4,'1681250400539.01','2023-04-12','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-539.01,'EUR','+++187/7946/80634+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8376,4,'1681250400539.01','2023-04-12','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-539.01,'EUR','+++187/7946/90637+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8377,4,'168125040084.2','2023-04-12','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-84.2,'EUR','+++187/7947/00842+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8378,4,'1681164000159.32','2023-04-11','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-159.32,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0721910753 R B3381593 //20230405-BEDO1 REFERENCE DU    CREANCIER : I0000049897199-110407219107532023          REF. : 081964B587936 VAL. 11-04','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8379,4,'16807320007.96','2023-04-06','','',NULL,-7.96,'EUR','PARTICIPATION AUX FRAIS DE TENUE DE VOTRE BELFIUS      BUSINESS PACK PLUS                                     REF. : 0816445062202 VAL. 01-04','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8380,4,'168047280019954.02','2023-04-03','BE42 6792 0000 0054','SPF FINANCES',NULL,-19954.02,'EUR','+++201/3508/86736+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8381,4,'167995440060.7','2023-03-28','','HUGGY\'S BAR NAMUR      NAM',NULL,-60.7,'EUR','ACHAT BANCONTACT MOBILE CONTACTLESS VIA APPLE PAY AVEC CARTE N6703 0700 3436 4800 - LEGARDIEN FREDERIC LE    28/03 14:15 HUGGY\'S BAR NAMUR NAM                      REF. : 0201725741409 VAL. 28-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8382,4,'167986800048.24','2023-03-27','BE61 0910 1660 5217','PROXIMUS SA',NULL,-48.24,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007302596678 REFERENCE DU  CREANCIER : 9009326608                                 REF. : 081963R098851 VAL. 27-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8383,4,'16796124002087.91','2023-03-24','BE82 0000 0238 3368','CAISSE WALLONNE ASSUR',NULL,2087.91,'EUR','780402167 REMBOURSEMENT SUITE AUX REGUL. CREDIT 2021- DOSSIER SOLDE','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8384,4,'1679439600104.12','2023-03-22','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-104.12,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0721814048 R B3302924 //20230320-BEDO1 REFERENCE DU    CREANCIER : I0000049228366-110407218140482023          REF. : 081963M111725 VAL. 22-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8385,4,'167943960013606.45','2023-03-22','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,13606.45,'EUR','INVOICE WFI0002','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8386,4,'167943960018.61','2023-03-22','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-18.61,'EUR','+++187/5196/90886+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8387,4,'16792668002087.91','2023-03-20','BE80 0000 0010 4777','CAISSE D\'ASS SOCIALES UCM',NULL,-2087.91,'EUR','+++500/3293/25985+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8388,4,'1678834800833.01','2023-03-15','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-833.01,'EUR','+++480/0377/56044+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8389,4,'167831640020.4','2023-03-09','','SNCBNEWAPP             BRU',NULL,-20.4,'EUR','ACHAT PAR INTERNET AVEC CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC LE 09/03 07:51 SNCBNEWAPP BRU       REF. : 0034803220785 VAL. 09-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8390,4,'1678143600103.67','2023-03-07','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-103.67,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0721755981 R B3240895 //20230303-BEDO1 REFERENCE DU    CREANCIER : I0000048726520-110407217559812023          REF. : 0819637178964 VAL. 07-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8391,4,'16780572008.46','2023-03-06','666-0000004-83','',NULL,-8.46,'EUR','VISA RELEVE NUMERO 056                                 REF. : 0807536205817 VAL. 06-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8392,4,'16780572007.96','2023-03-06','','',NULL,-7.96,'EUR','PARTICIPATION AUX FRAIS DE TENUE DE VOTRE BELFIUS      BUSINESS PACK PLUS                                     REF. : 0816433057486 VAL. 01-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8393,4,'167745240030.95','2023-02-27','BE61 0910 1660 5217','PROXIMUS SA',NULL,-30.95,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007302018469007371772561   REFERENCE DU CREANCIER : 4009312850                    REF. : 081962R005042 VAL. 27-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8394,4,'167719320018.61','2023-02-24','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-18.61,'EUR','+++186/7952/90846+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8395,4,'1677020400172.59','2023-02-22','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-172.59,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0721690598 R B3199282 //20230220-BEDO1 REFERENCE DU    CREANCIER : I0000048162782-110407216905982023          REF. : 081962M120988 VAL. 22-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8396,4,'167632920017044.67','2023-02-14','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,17044.67,'EUR','04-WFI001','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8397,4,'167624280051.98','2023-02-13','BE31 4100 0007 1155','BALOISE INSURANCE',NULL,-51.98,'EUR','+++496/9408/49540+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8398,4,'1675724400105.03','2023-02-07','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-105.03,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0721626442 R B3171989 //20230203-BEDO1 REFERENCE DU    CREANCIER : I0000047616467-110407216264422023          REF. : 0819627230102 VAL. 07-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8399,4,'16756380007.96','2023-02-06','','',NULL,-7.96,'EUR','PARTICIPATION AUX FRAIS DE TENUE DE VOTRE BELFIUS      BUSINESS PACK PLUS                                     REF. : 0816423057691 VAL. 01-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8400,4,'167537880020.4','2023-02-03','','SNCBNEWAPP             BRU',NULL,-20.4,'EUR','ACHAT PAR INTERNET AVEC CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC LE 03/02 09:26 SNCBNEWAPP BRU       REF. : 0034803220946 VAL. 03-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8401,4,'167537880095.69','2023-02-03','666-0000004-83','',NULL,-95.69,'EUR','VISA RELEVE NUMERO 025                                 REF. : 0807523203313 VAL. 03-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8402,4,'167520600042.1','2023-02-01','','AG INSURANCE           BRU',NULL,-42.1,'EUR','ACHAT PAR INTERNET AVEC CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC LE 01/02 19:07 AG INSURANCE BRU     REF. 232528955728                                      REF. : 035VLDQ8E0000 VAL. 01-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8403,4,'16752060001500','2023-02-01','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-1500,'EUR','01/2023','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8404,4,'167511960013087.1','2023-01-31','BE22 6792 0030 0047','TVA RECETTES',NULL,-13087.1,'EUR','+++072/8750/01371+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8405,4,'167503320018195.98','2023-01-30','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,18195.98,'EUR','WFI0020','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8406,4,'1675033200371.05','2023-01-30','BE41 2500 0974 1010','ROTARY',NULL,-371.05,'EUR','4079','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8407,4,'167477400029.48','2023-01-27','BE61 0910 1660 5217','PROXIMUS SA',NULL,-29.48,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007301469432 REFERENCE DU  CREANCIER : 3009119901                                 REF. : 081961R016373 VAL. 27-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8408,4,'167468760018.6','2023-01-26','BE57 5523 3881 0035','NMBS - SNCB',NULL,-18.6,'EUR','+++003/3488/93068+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8409,4,'1674428400114.48','2023-01-23','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-114.48,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0721554191 R B3091089 //20230119-BEDO1 REFERENCE DU    CREANCIER : I0000047089063-110407215541912023          REF. : 081961N142313 VAL. 23-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8410,4,'167399640020000','2023-01-18','BE61 6792 0022 9117','RECETTES TVA',NULL,-20000,'EUR','+++072/8750/01371+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8411,4,'16739964002677.17','2023-01-18','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-2677.17,'EUR','+++480/0377/58064+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8412,4,'1673910000833.01','2023-01-17','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-833.01,'EUR','+++480/0377/56044+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8413,4,'167382360018.6','2023-01-16','BE57 5523 3881 0035','NMBS - SNCB',NULL,-18.6,'EUR','+++003/3324/05997+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8414,4,'167356440082','2023-01-13','','MANOLA                 BRU',NULL,-82,'EUR','ACHAT BANCONTACT MOBILE CONTACTLESS VIA APPLE PAY AVEC CARTE N6703 0700 3436 4800 - LEGARDIEN FREDERIC LE    13/01 14:55 MANOLA BRU                                 REF. : 0051405031465 VAL. 13-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8415,4,'167321880098.27','2023-01-09','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-98.27,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0721491049 R B3059537 //20230105-BEDO1 REFERENCE DU    CREANCIER : I0000046618637-110407214910492023          REF. : 0819619290237 VAL. 09-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8416,4,'16732188005','2023-01-09','','',NULL,5,'EUR','MERCI D\'AVOIR CHOISI APPLE PAY!','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8417,4,'167321880049.8','2023-01-09','','BRASSERIE LI GEOISE',NULL,-49.8,'EUR','PAIEMENT MAESTRO VIA APPLE PAY 06/01 BRASSERIE LI      GEOISE LI GE BE 49,80 EUR CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC                                   REF. : 0801K19089763 VAL. 09-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8418,4,'16729596003000','2023-01-06','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-3000,'EUR','11 ET 12/2022','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8419,4,'167295960038.84','2023-01-06','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-38.84,'EUR','+++185/5420/90858+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8420,4,'16728732007.96','2023-01-05','','',NULL,-7.96,'EUR','PARTICIPATION AUX FRAIS DE TENUE DE VOTRE BELFIUS      BUSINESS PACK PLUS                                     REF. : 0816414064244 VAL. 01-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8421,4,'16728732003.63','2023-01-05','','',NULL,-3.63,'EUR','FRAIS PAIEMENTS URGENTS                                REF. : 0816414068571 VAL. 01-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8422,3,'1672268400201.55','2022-12-29','','LE BRASILIA            LIE',NULL,-201.55,'EUR','ACHAT BANCONTACT MOBILE CONTACTLESS VIA APPLE PAY AVEC CARTE N6703 0700 3436 4800 - LEGARDIEN FREDERIC LE    28/12 20:56 LE BRASILIA LIE                            REF. : 0010513442041 VAL. 28-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8423,3,'167218200010.4','2022-12-28','BE57 5523 3881 0035','NMBS - SNCB',NULL,-10.4,'EUR','+++003/2997/31953+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8424,3,'16721820005118.3','2022-12-28','BE84 0689 3590 7759','OPENFLOW',NULL,5118.3,'EUR','FACTURE WFI0019','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8425,3,'167209560028.83','2022-12-27','BE61 0910 1660 5217','PROXIMUS SA',NULL,-28.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007207802049 REFERENCE DU  CREANCIER : 1009168916                                 REF. : 08196CR041452 VAL. 27-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8426,3,'1672095600853.21','2022-12-27','BE82 0000 0238 3368','CAISSE WALLONNE ASSUR',NULL,853.21,'EUR','780402167 - REMBOURSEMENT COTISATIONS SOCIALES - DOSSIER SOLDE','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8427,3,'167209560010.4','2022-12-27','BE57 5523 3881 0035','NMBS - SNCB',NULL,-10.4,'EUR','+++003/2966/69076+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8428,3,'1671663600815.77','2022-12-22','BE31 4100 0007 1155','BALOISE BELGIUM NV',NULL,815.77,'EUR','5L57291 522/00062 211222','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8429,3,'1671663600117.31','2022-12-22','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-117.31,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0721424425 R B2C94162 //20221220-BEDO1 REFERENCE DU    CREANCIER : I0000046044948-110407214244252022          REF. : 08196CM029744 VAL. 22-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8430,3,'1671490800853.21','2022-12-20','BE80 0000 0010 4777','CAISSE D\'ASS SOCIALES UCM',NULL,-853.21,'EUR','+++500/3058/66133+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8431,3,'1671404400347.5','2022-12-19','BE53 3500 3401 1353','CAISSE D\'ASS SOCIALES UCM',NULL,-347.5,'EUR','+++500/3166/76579+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8432,3,'16711452001.7','2022-12-16','BE19 7390 2085 6112','PPRO PAYMENT SERVICES SA',NULL,1.7,'EUR','WWW.AMAZON.COM.BE','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8433,3,'1671145200575.94','2022-12-16','','AG INSURANCE           BRU',NULL,-575.94,'EUR','ACHAT PAR INTERNET AVEC CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC LE 16/12 10:14 AG INSURANCE BRU     REF. 123618119196                                      REF. : 035VLDQ8E0000 VAL. 16-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8434,3,'167105880010.67','2022-12-15','','AMZN MKTP BE           LUX',NULL,-10.67,'EUR','ACHAT PAR INTERNET AVEC CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC LE 15/12 08:25 AMZN MKTP BE LUX     REF. 5HD3RZO WWW. AMAZON. COM. BE                      REF. : 037RIPEEU0000 VAL. 15-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8435,3,'167105880042.01','2022-12-15','','AMAZON DE              LUX',NULL,-42.01,'EUR','ACHAT PAR INTERNET AVEC CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC LE 14/12 20:21 AMAZON DE LUX REF.   5TO0DFJ AMAZON. DE                                     REF. : 037RIPEEU0000 VAL. 14-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8436,3,'1671058800379.98','2022-12-15','','MMS ONLINE BE          ASS',NULL,-379.98,'EUR','ACHAT PAR INTERNET AVEC CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC LE 14/12 20:17 MMS ONLINE BE ASS    REF. 6HF0AL0 MEDIAMARKT. BE                            REF. : 037SOBC  0000 VAL. 14-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8437,3,'167097240014956.81','2022-12-14','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,14956.81,'EUR','WFI0018','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8438,3,'167079960038.84','2022-12-12','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-38.84,'EUR','+++184/6409/70861+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8439,3,'167079960099.5','2022-12-12','','HOTEL ON BOOKING.COM   AMS',NULL,-99.5,'EUR','ACHAT PAR INTERNET AVEC CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC LE 09/12 23:17 HOTEL ON BOOKING.    COM AMS REF. HOTEL AT BOOKING. COM                     REF. : 0320000000000 VAL. 09-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8440,3,'16707996009.3','2022-12-12','','SNCB_NMBS ETTERBEEK TV ETT',NULL,-9.3,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 09/12 22:44          SNCB_NMBS ETTERBEEK TV ETT                             REF. : 0033525262259 VAL. 09-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8441,3,'167036760065.72','2022-12-07','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-65.72,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0721360381 R B2C23829 //20221205-BEDO1 REFERENCE DU    CREANCIER : I0000045489521-110407213603812022          REF. : 08196C7211635 VAL. 07-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8442,3,'16703676007.94','2022-12-07','','TOTAL NB000917 SPY NOO SPY',NULL,-7.94,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 07/12 08:49 TOTAL    NB000917 SPY NOO SPY                                   REF. : 0050917010870 VAL. 07-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8443,3,'1670281200268.9','2022-12-06','BE31 4100 0007 1155','BALOISE INSURANCE',NULL,-268.9,'EUR','+++497/7864/30165+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8444,3,'16702812001904.27','2022-12-06','BE31 4100 0007 1155','BALOISE INSURANCE',NULL,-1904.27,'EUR','+++497/7869/93573+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8445,3,'1670281200195','2022-12-06','BE50 4354 1204 0118','DAS N.V. -  DAS S.A.',NULL,-195,'EUR','+++102/0093/75040+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8446,3,'16702812007.96','2022-12-06','','',NULL,-7.96,'EUR','PARTICIPATION AUX FRAIS DE TENUE DE VOTRE BELFIUS      BUSINESS PACK PLUS                                     REF. : 08164C5057033 VAL. 01-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8447,3,'1670194800147.99','2022-12-05','666-0000004-83','',NULL,-147.99,'EUR','VISA RELEVE NUMERO 329                                 REF. : 08075C5210119 VAL. 05-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8448,3,'167019480019.89','2022-12-05','BE80 0000 0010 4777','CAISSE D\'ASS SOCIALES UCM',NULL,-19.89,'EUR','COTISATIONS SOCIALES WEFEATIT SRL','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8449,3,'1669935600227','2022-12-02','','BRASSERIE FRANCOIS',NULL,-227,'EUR','PAIEMENT MAESTRO 01/12 BRASSERIE FRANCOIS NAMUR BE     227,00 EUR CARTE N 6703 0700 3436 4800 - LEGARDIEN    FREDERIC                                               REF. : 0801MC2041773 VAL. 02-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8450,3,'166967640070','2022-11-29','','KREFEL 033 BOUGE       BOU',NULL,-70,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 29/11 16:58 KREFEL 033 BOUGE BOU REF. : 0038817221647 VAL. 29-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8451,3,'166967640038.5','2022-11-29','','BRASSE TEMPS DIFFUSION PIP',NULL,-38.5,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 29/11 12:57 BRASSE   TEMPS DIFFUSION PIP                                    REF. : 0058132971273 VAL. 29-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8452,3,'166933080015306.5','2022-11-25','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,15306.5,'EUR','WFI0016','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8453,3,'166933080028.33','2022-11-25','BE61 0910 1660 5217','PROXIMUS SA',NULL,-28.33,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007207233121 REFERENCE DU  CREANCIER : 7008792562                                 REF. : 08196BP026833 VAL. 25-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8454,3,'166915800058','2022-11-23','BE68 0960 1766 5034','VILLE DE NAMUR',NULL,-58,'EUR','+++639/2212/05837+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8455,3,'1669071600198.84','2022-11-22','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-198.84,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0721290620 R B2C03029 //20221118-BEDO1 REFERENCE DU    CREANCIER : I0000044884493-110407212906202022          REF. : 08196BM048885 VAL. 22-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8456,3,'166855320050.55','2022-11-16','BE65 0689 3613 4596','FLOW SOLUTIONS',NULL,50.55,'EUR','FACTURE WFI0012','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8457,3,'166838040038.84','2022-11-14','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-38.84,'EUR','+++183/9292/10830+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8458,3,'16683804001500','2022-11-14','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-1500,'EUR','10/2022','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8459,3,'1667948400805.06','2022-11-09','BE84 0689 3590 7759','OPENFLOW',NULL,805.06,'EUR','INVOICE : WFI0014','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8460,3,'16679484005880.6','2022-11-09','BE84 0689 3590 7759','OPENFLOW',NULL,5880.6,'EUR','INVOICE : WFI0013','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8461,3,'1667948400871.2','2022-11-09','BE43 0689 4642 6401','EMISI',NULL,871.2,'EUR','FACTURE WFI0017 DU 04/11/2022','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8462,3,'166794840077','2022-11-09','','NIVAXIS GATE',NULL,-77,'EUR','PAIEMENT MAESTRO 08/11 NIVAXIS GATE BAULERS BE 77,00   EUR CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC  REF. : 0801LB9019683 VAL. 09-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8463,3,'1667775600208.01','2022-11-07','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-208.01,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0721233799 R B2B01227 //20221103-BEDO1 REFERENCE DU    CREANCIER : I0000044367047-110407212337992022          REF. : 08196B7444291 VAL. 07-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8464,3,'166777560046','2022-11-07','','EROL IBRAHIM    P2P MOBILE',NULL,-46,'EUR','PAIEMENT VIA VOTRE APP MOBILE BANKING OU VOTRE         BANCONTACT-APP A EROL IBRAHIM P2P MOBILE LE 07/11 A    13:41 AVEC VOTRE CARTE BANCAIRE 6703 0700 3436 4800    REF. : 6664106214030 VAL. 07-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8465,3,'16677756007.96','2022-11-07','','',NULL,-7.96,'EUR','PARTICIPATION AUX FRAIS DE TENUE DE VOTRE BELFIUS      BUSINESS PACK PLUS                                     REF. : 08164B4057144 VAL. 01-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8466,3,'1667516400301.92','2022-11-04','BE41 2500 0974 1010','ROTARY',NULL,-301.92,'EUR','4022','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8467,3,'1667516400741.12','2022-11-04','BE14 0689 3381 4983','CABINET COMPTABLE LAURENT',NULL,-741.12,'EUR','+++000/0077/13924+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8468,3,'1667430000169.96','2022-11-03','666-0000004-83','',NULL,-169.96,'EUR','VISA RELEVE NUMERO 298                                 REF. : 08075B3202009 VAL. 03-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8469,3,'166682160027.83','2022-10-27','BE61 0910 1660 5217','PROXIMUS SA',NULL,-27.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007206658696 REFERENCE DU  CREANCIER : 4008746206                                 REF. : 08196AR028191 VAL. 27-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8470,3,'1666648800240','2022-10-25','BE10 0882 8487 0504','RT5',NULL,-240,'EUR','CHAMPAGNE 2023-0924','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8471,3,'1666562400220.54','2022-10-24','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-220.54,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0721168149 R B2A54566 //20221020-BEDO1 REFERENCE DU    CREANCIER : I0000043867854-110407211681492022          REF. : 08196AO109288 VAL. 24-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8472,3,'166621680036.7','2022-10-20','','MUSA KASUMI     P2P MOBILE',NULL,-36.7,'EUR','PAIEMENT VIA VOTRE APP MOBILE BANKING OU VOTRE         BANCONTACT-APP A MUSA KASUMI P2P MOBILE LE 20/10 A     14:10 AVEC VOTRE CARTE BANCAIRE 6703 0700 3436 4800    REF. : 6664106218043 VAL. 20-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8473,3,'16661304009566.52','2022-10-19','BE22 6792 0030 0047','SERVICE T.V.A.-RECETTES',NULL,-9566.52,'EUR','+++072/8750/01371+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8474,3,'166569840016322.42','2022-10-14','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,16322.42,'EUR','WFI0010','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8475,3,'166543920032.38','2022-10-11','','LUNCH GARDEN 288 JAMBE JAM',NULL,-32.38,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 11/10 12:30 LUNCH    GARDEN 288 JAMBE JAM                                   REF. : 0019396551252 VAL. 11-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8476,3,'166535280037.47','2022-10-10','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-37.47,'EUR','+++183/1892/70881+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8477,3,'16653528001500','2022-10-10','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-1500,'EUR','09/2022','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8478,3,'1665093600106.09','2022-10-07','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-106.09,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0721102000 R B2A38697 //20221005-BEDO1 REFERENCE DU    CREANCIER : I0000043353729-110407211020002022          REF. : 08196A7543959 VAL. 07-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8479,3,'16650072007.96','2022-10-06','','',NULL,-7.96,'EUR','PARTICIPATION AUX FRAIS DE TENUE DE VOTRE BELFIUS      BUSINESS PACK PLUS                                     REF. : 08164A5063453 VAL. 01-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8480,3,'166483440024.6','2022-10-04','','BRASSE TEMPS DIFFUSION TOU',NULL,-24.6,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 04/10 14:13 BRASSE   TEMPS DIFFUSION TOU                                    REF. : 0056801711419 VAL. 04-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8481,3,'1664834400104.85','2022-10-04','666-0000004-83','',NULL,-104.85,'EUR','VISA RELEVE NUMERO 268                                 REF. : 08075A4204447 VAL. 04-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8482,3,'16647480008.47','2022-10-03','BE06 0689 3535 1122','ESPACE COMMUNAUT ST-LOUP,',NULL,8.47,'EUR','FACTURE 3/10/22','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8483,3,'166448880067.4','2022-09-30','','HUGGY\'S BAR NAMUR      NAM',NULL,-67.4,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 30/09 15:33 HUGGY\'S BAR NAMUR    NAM                                                    REF. : 0201725741503 VAL. 30-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8484,3,'16641432009221.41','2022-09-26','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,9221.41,'EUR','WFI0009','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8485,3,'166414320034.2','2022-09-26','BE61 0910 1660 5217','PROXIMUS SA',NULL,-34.2,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007206101651 REFERENCE DU  CREANCIER : 8008664564                                 REF. : 081969Q075506 VAL. 26-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8486,3,'16638840001016.4','2022-09-23','BE64 0016 0913 8252','VERT DECOR',NULL,-1016.4,'EUR','2022/134','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8487,3,'166379760056','2022-09-22','','ASHOR.B SPRL           BRU',NULL,-56,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 22/09 13:55 ASHOR. B SPRL BRU    REF. : 0047814751398 VAL. 22-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8488,3,'1663797600173.67','2022-09-22','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-173.67,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0721035081 R B2943891 //20220920-BEDO1 REFERENCE DU    CREANCIER : I0000042779294-110407210350812022          REF. : 081969M092414 VAL. 22-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8489,3,'1663624800853.21','2022-09-20','BE80 0000 0010 4777','CAISSE D\'ASS SOCIALES UCM',NULL,-853.21,'EUR','+++500/2838/68654+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8490,3,'1663020000833.01','2022-09-13','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-833.01,'EUR','+++480/0377/56044+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8491,3,'166293360055.2','2022-09-12','','BRASSE TEMPS DIFFUSION TOU',NULL,-55.2,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 12/09 13:59 BRASSE TEMPS         DIFFUSION TOU                                          REF. : 0056801711339 VAL. 12-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8492,3,'166250160035','2022-09-07','','KREFEL 033 BOUGE       BOU',NULL,-35,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 07/09 18:08 KREFEL 033 BOUGE BOU REF. : 0038817231843 VAL. 07-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8493,3,'1662501600215.09','2022-09-07','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-215.09,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0720968803 R B2894468 //20220905-BEDO1 REFERENCE DU    CREANCIER : I0000042244386-110407209688032022          REF. : 0819697250284 VAL. 07-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8494,3,'16624152001500','2022-09-06','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-1500,'EUR','08/2022','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8495,3,'1662415200486.02','2022-09-06','BE36 0912 1503 4881','SPW',NULL,-486.02,'EUR','+++012/2649/52408+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8496,3,'1662415200104.06','2022-09-06','','FOD JUSTITIE           BRU',NULL,-104.06,'EUR','ACHAT PAR INTERNET AVEC CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC LE 06/09 08:21 FOD JUSTITIE BRU     REF. +++214/0127/72137+++                              REF. : 051RMINAL0000 VAL. 06-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8497,3,'166241520037.47','2022-09-06','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-37.47,'EUR','+++182/4283/20837+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8498,3,'16624152007.96','2022-09-06','','',NULL,-7.96,'EUR','PARTICIPATION AUX FRAIS DE TENUE DE VOTRE BELFIUS      BUSINESS PACK PLUS                                     REF. : 0816495048278 VAL. 01-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8499,3,'16623288001365.34','2022-09-05','666-0000004-83','',NULL,-1365.34,'EUR','VISA RELEVE NUMERO 237                                 REF. : 0807595210509 VAL. 05-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8500,3,'16619832002479.9','2022-09-01','BE43 0688 9317 3401','RHCN',NULL,-2479.9,'EUR','SP000463','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8501,3,'166189680048.74','2022-08-31','','LUNCH GARDEN 288 JAMBE JAM',NULL,-48.74,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 31/08 13:21 LUNCH    GARDEN 288 JAMBE JAM                                   REF. : 0019396541369 VAL. 31-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8502,3,'166181040016084.53','2022-08-30','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,16084.53,'EUR','WFI0008','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8503,3,'166137840028.33','2022-08-25','BE61 0910 1660 5217','PROXIMUS SA',NULL,-28.33,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007205530466 REFERENCE DU  CREANCIER : 4008471773                                 REF. : 081968P020815 VAL. 25-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8504,3,'166120560054.16','2022-08-23','','AMAZON MRKTPLC         LUX',NULL,-54.16,'EUR','ACHAT PAR INTERNET AVEC CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC LE 23/08 13:20 AMAZON MRKTPLC LUX   REF. 48LJ6ME AMAZON PAYMENTS EUROPE                    REF. : 037RIPEEU0000 VAL. 23-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8505,3,'166111920013.5','2022-08-22','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-13.5,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0720901204 R B2866038 //20220818-BEDO1 REFERENCE DU    CREANCIER : I0000041688957-110407209012042022          REF. : 081968M223046 VAL. 22-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8506,3,'16611192001500','2022-08-22','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-1500,'EUR','07/2022','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8507,3,'166111920037.47','2022-08-22','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-37.47,'EUR','+++181/8176/20860+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8508,3,'165990960096.86','2022-08-08','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-96.86,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0720831934 R B2827132 //20220804-BEDO1 REFERENCE DU    CREANCIER : I0000041212174-110407208319342022          REF. : 0819688286871 VAL. 08-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8509,3,'165990960084.99','2022-08-08','','LA HUTTE-INTERSP',NULL,-84.99,'EUR','PAIEMENT MAESTRO 06/08 LA HUTTE-INTERSP ARACHES LA FR  FR 84,99 EUR CARTE N 6703 0700 3436 4800 - LEGARDIEN  FREDERIC                                               REF. : 0801K88980076 VAL. 08-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8510,3,'165990960015264.15','2022-08-08','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,15264.15,'EUR','WFI0007.2022','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8511,3,'16595640007.96','2022-08-04','','',NULL,-7.96,'EUR','PARTICIPATION AUX FRAIS DE TENUE DE VOTRE BELFIUS      BUSINESS PACK PLUS                                     REF. : 0816483048104 VAL. 01-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8512,3,'165947760021.63','2022-08-03','666-0000004-83','',NULL,-21.63,'EUR','VISA RELEVE NUMERO 206                                 REF. : 0807583203496 VAL. 03-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8513,3,'165904560059.5','2022-07-29','','BRASSERIE DE LA CONFLU NAM',NULL,-59.5,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 29/07 13:21 BRASSERIE DE LA      CONFLU NAM                                             REF. : 0201361121301 VAL. 29-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8514,3,'165887280043.5','2022-07-27','','ASHOR.B SPRL           BRU',NULL,-43.5,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 27/07 12:50 ASHOR. B SPRL BRU                                               REF. : 0047814751253 VAL. 27-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8515,3,'165878640027.83','2022-07-26','BE61 0910 1660 5217','PROXIMUS SA',NULL,-27.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007204957279 REFERENCE DU  CREANCIER : 0008355359                                 REF. : 081967Q048387 VAL. 26-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8516,3,'165844080037.84','2022-07-22','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-37.84,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0720766271 R C2746172 //20220720-BEDO1 REFERENCE DU    CREANCIER : I0000040636885-110407207662712022          REF. : 081967M140646 VAL. 22-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8517,3,'165844080039.17','2022-07-22','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-39.17,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0720766270 R C2124090 //20220720-BEDO1 REFERENCE DU    CREANCIER : I0000040636884-110407207662702022          REF. : 081967M140645 VAL. 22-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8518,3,'1658440800271.05','2022-07-22','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-271.05,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0720766269 R B2759090 //20220720-BEDO1 REFERENCE DU    CREANCIER : I0000040636883-110407207662692022          REF. : 081967M140644 VAL. 22-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8519,3,'1658268000259.36','2022-07-20','BE41 2500 0974 1010','ROTARY',NULL,-259.36,'EUR','DOC 3968','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8520,3,'16582680004333.61','2022-07-20','BE22 6792 0030 0047','SERVICE T.V.A.-RECETTES',NULL,-4333.61,'EUR','+++072/8750/01371+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8521,3,'165818160083.8','2022-07-19','','PANORAMA               NAM',NULL,-83.8,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 19/07 16:19 PANORAMA NAM                                                    REF. : 0521410491443 VAL. 19-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8522,3,'16572312003000','2022-07-08','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-3000,'EUR','05-06/2022','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8523,3,'165723120036.54','2022-07-08','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-36.54,'EUR','+++180/7516/80887+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8524,3,'1657144800151.24','2022-07-07','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-151.24,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0720692727 R B2692511 //20220705-BEDO1 REFERENCE DU    CREANCIER : I0000040107778-110407206927272022          REF. : 0819677436678 VAL. 07-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8525,3,'1657144800379.4','2022-07-07','','RAD NIVELLES           NIV',NULL,-379.4,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 07/07 11:29 RAD NIVELLES NIV     REF. : 0046314201187 VAL. 07-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8526,3,'1657058400681.26','2022-07-06','','HERPIGNY-MOTORS  S.A.  COG',NULL,-681.26,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 06/07 09:56 HERPIGNY-MOTORS S.   A. COG                                                 REF. : 0058994960919 VAL. 06-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8527,3,'16570584007.96','2022-07-06','','',NULL,-7.96,'EUR','PARTICIPATION AUX FRAIS DE TENUE DE VOTRE BELFIUS      BUSINESS PACK PLUS                                     REF. : 0816475055419 VAL. 01-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8528,3,'16570584003.63','2022-07-06','','',NULL,-3.63,'EUR','FRAIS PAIEMENTS URGENTS                                REF. : 0816475059448 VAL. 01-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8529,3,'1656885600120.99','2022-07-04','666-0000004-83','',NULL,-120.99,'EUR','VISA RELEVE NUMERO 176                                 REF. : 0807574200724 VAL. 04-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8530,3,'1656367200266.2','2022-06-28','BE32 7320 3012 3302','RHCN',NULL,-266.2,'EUR','EV000069','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8531,3,'165628080027.83','2022-06-27','BE61 0910 1660 5217','PROXIMUS SA',NULL,-27.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007204383621 REFERENCE DU  CREANCIER : 1008331974                                 REF. : 081966R039064 VAL. 27-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8532,3,'1655848800170.48','2022-06-22','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-170.48,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0720628586 R B2649269 //20220620-BEDO1 REFERENCE DU    CREANCIER : I0000039514946-110407206285862022          REF. : 081966M031741 VAL. 22-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8533,3,'1655676000853.21','2022-06-20','BE80 0000 0010 4777','CAISSE D\'ASS SOCIALES UCM',NULL,-853.21,'EUR','+++500/2706/05724+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8534,3,'165541680042.48','2022-06-17','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-42.48,'EUR','+++179/9382/80620+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8535,3,'165541680036.54','2022-06-17','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-36.54,'EUR','+++179/9382/90825+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8536,3,'165533040044.99','2022-06-16','','RSM MOTO',NULL,-44.99,'EUR','PAIEMENT MAESTRO 15/06 RSM MOTO EVERE BE 44,99 EUR     CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC      REF. : 0801K6G014036 VAL. 16-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8537,3,'165533040050.3','2022-06-16','','AUTOSECURITE NAMUR-STA NAM',NULL,-50.3,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 16/06 07:49 AUTOSECURITE NAMUR-  STA NAM                                                REF. : 0038172820741 VAL. 16-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8538,3,'165507120015495.26','2022-06-13','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,15495.26,'EUR','WFI0006.2022','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8539,3,'16548120002677.17','2022-06-10','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-2677.17,'EUR','+++480/0377/58064+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8540,3,'165472560082.22','2022-06-09','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-82.22,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0720564310 R B2569694 //20220607-BEDO1 REFERENCE DU    CREANCIER : I0000039096690-110407205643102022          REF. : 0819669290283 VAL. 09-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8541,3,'16545528007.96','2022-06-07','','',NULL,-7.96,'EUR','PARTICIPATION AUX FRAIS DE TENUE DE VOTRE BELFIUS      BUSINESS PACK PLUS                                     REF. : 0816463040532 VAL. 01-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8542,3,'165420720077.69','2022-06-03','666-0000004-83','',NULL,-77.69,'EUR','VISA RELEVE NUMERO 145                                 REF. : 0807563197576 VAL. 03-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8543,3,'165412080028.5','2022-06-02','','CAFE CABERDOUCHE       BRU',NULL,-28.5,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 02/06 15:36 CAFE     CABERDOUCHE BRU                                        REF. : 0208852501502 VAL. 02-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8544,3,'165386160027.83','2022-05-30','BE61 0910 1660 5217','PROXIMUS SA',NULL,-27.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007203802974 REFERENCE DU  CREANCIER : 5008072138                                 REF. : 081965Q026425 VAL. 26-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8545,3,'1653429600131.68','2022-05-25','BE36 0912 1503 4881','SPW',NULL,-131.68,'EUR','+++012/1566/41497+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8546,3,'1653256800237.34','2022-05-23','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-237.34,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0720497831 R B2499637 //20220519-BEDO1 REFERENCE DU    CREANCIER : I0000038484098-110407204978312022          REF. : 081965N221007 VAL. 23-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8547,3,'165325680050.5','2022-05-23','','HEDI-CONCEPT SPORT SPR BRU',NULL,-50.5,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 23/05 13:34 HEDI-CONCEPT SPORT   SPR BRU                                                REF. : 0015858621340 VAL. 23-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8548,3,'1652652000131.26','2022-05-16','','',NULL,-131.26,'EUR','PAIEMENT MAESTRO 12/05-PARIS RICHEMONT FR 131,26 EUR   CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC      REF. : 5160040643381 VAL. 16-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8549,3,'165265200076','2022-05-16','','',NULL,-76,'EUR','PAIEMENT MAESTRO 13/05-PARIS REST DI GIOVANNI\'S FR     76,00 EUR CARTE N 6703 0700 3436 4800 - LEGARDIEN     FREDERIC                                               REF. : 5160040406935 VAL. 16-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8550,3,'1652047200178.68','2022-05-09','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-178.68,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0720438323 R B2481563 //20220505-BEDO1 REFERENCE DU    CREANCIER : I0000037992269-110407204383232022          REF. : 0819659270633 VAL. 09-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8551,3,'16520472001500','2022-05-09','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-1500,'EUR','04/2022','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8552,3,'165204720036.54','2022-05-09','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-36.54,'EUR','+++179/2795/90804+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8553,3,'165204720054','2022-05-09','','',NULL,-54,'EUR','PAIEMENT MAESTRO 06/05-WIERDE DAILY BURGER BE 54,00    EUR CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC  REF. : 5090040175219 VAL. 09-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8554,3,'165178800030443.61','2022-05-06','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,30443.61,'EUR','WFI0004 + 0005','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8555,3,'1651788000437.1','2022-05-06','BE41 2500 0974 1010','ROTARY',NULL,-437.1,'EUR','REF 3911','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8556,3,'165170160048.63','2022-05-05','','AG INSURANCE           BRU',NULL,-48.63,'EUR','ACHAT PAR INTERNET AVEC CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC LE 05/05 12:06 AG INSURANCE BRU     REF. 222908764193                                      REF. : 035VLDQ8E0000 VAL. 05-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8557,3,'165170160043.95','2022-05-05','BE78 7350 2770 3386','MOTO ADVENTURE STORE',NULL,-43.95,'EUR','LEGARDIEN','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8558,3,'16517016007.96','2022-05-05','','',NULL,-7.96,'EUR','PARTICIPATION AUX FRAIS DE TENUE DE VOTRE BELFIUS      BUSINESS PACK PLUS                                     REF. : 0816454040317 VAL. 01-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8559,3,'165092400027.83','2022-04-26','BE61 0910 1660 5217','PROXIMUS SA',NULL,-27.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007203230625 REFERENCE DU  CREANCIER : 3007910968                                 REF. : 081964Q026796 VAL. 26-04','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8560,3,'165057840075.48','2022-04-22','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-75.48,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0720371294 R B2413962 //20220420-BEDO1 REFERENCE DU    CREANCIER : I0000037413193-110407203712942022          REF. : 081964M069451 VAL. 22-04','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8561,3,'165057840045.8','2022-04-22','','CAFES DELAHAUT         NAM',NULL,-45.8,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 21/04 23:36 CAFES    DELAHAUT NAM                                           REF. : 0541278022300 VAL. 21-04','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8562,3,'16503192005505.22','2022-04-19','BE22 6792 0030 0047','SERVICE T.V.A.-RECETTES',NULL,-5505.22,'EUR','+++072/8750/01371+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8563,3,'164980080049.7','2022-04-13','','BRASSE TEMPS DIFFUSION TOU',NULL,-49.7,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 13/04 14:29 BRASSE   TEMPS DIFFUSION TOU                                    REF. : 0056801711405 VAL. 13-04','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8564,3,'164962800035.04','2022-04-11','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-35.04,'EUR','+++178/3070/80827+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8565,3,'16496280001500','2022-04-11','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-1500,'EUR','03/2022','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8566,3,'1649282400218.35','2022-04-07','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-218.35,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0720307182 R B2377349 //20220405-BEDO1 REFERENCE DU    CREANCIER : I0000036921616-110407203071822022          REF. : 0819647183160 VAL. 07-04','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8567,3,'16491960006.19','2022-04-06','','',NULL,-6.19,'EUR','PARTICIPATION AUX FRAIS DE TENUE DE VOTRE BELFIUS      BUSINESS PACK PLUS DONT 1,93 EUR POUR LE SERVICE DE    PAIEMENT CARTE DE CREDIT.                              REF. : 0816445044945 VAL. 01-04','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8568,3,'164841840070.08','2022-03-28','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-70.08,'EUR','+++178/1388/50895+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8569,3,'164816280027.83','2022-03-25','BE61 0910 1660 5217','PROXIMUS SA',NULL,-27.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007202652209 REFERENCE DU  CREANCIER : 3007776190                                 REF. : 081963P022185 VAL. 25-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8570,3,'164807640051.6','2022-03-24','','ASHOR.B SPRL           BRU',NULL,-51.6,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 24/03 14:48 ASHOR. B SPRL BRU                                               REF. : 0047814751461 VAL. 24-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8571,3,'164807640014953.79','2022-03-24','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,14953.79,'EUR','WFI0003','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8572,3,'164807640018.6','2022-03-24','BE57 5523 3881 0035','NMBS - SNCB',NULL,-18.6,'EUR','+++002/7745/39092+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8573,3,'1647903600258.97','2022-03-22','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-258.97,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0720235615 R B2287774 //20220318-BEDO1 REFERENCE DU    CREANCIER : I0000036317473-110407202356152022          REF. : 081963M094796 VAL. 22-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8574,3,'16472988001973.05','2022-03-15','BE80 0000 0010 4777','CAISSE D\'ASS SOCIALES UCM',NULL,-1973.05,'EUR','+++500/2520/07891+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8575,3,'16472124003000','2022-03-14','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-3000,'EUR','01 ET 02/2022','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8576,3,'1647212400833.01','2022-03-14','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-833.01,'EUR','+++480/0377/56044+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8577,3,'164695320026','2022-03-11','','BPOST                  BRU',NULL,-26,'EUR','ACHAT PAR INTERNET AVEC CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC LE 11/03 07:56 BPOST BRU REF. BPOST D4DDDDDC-07C5-4562-8DBB-                               REF. : 0330000404870 VAL. 11-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8578,3,'1646694000159.09','2022-03-08','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-159.09,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0720168975 R B2257832 //20220304-BEDO1 REFERENCE DU    CREANCIER : I0000035767882-110407201689752022          REF. : 0819638049835 VAL. 08-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8579,3,'164660760089.72','2022-03-07','666-0000004-83','',NULL,-89.72,'EUR','VISA RELEVE NUMERO 056                                 REF. : 0827537197848 VAL. 07-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8580,3,'16463484006.19','2022-03-04','','',NULL,-6.19,'EUR','PARTICIPATION AUX FRAIS DE TENUE DE VOTRE BELFIUS      BUSINESS PACK PLUS DONT 1,93 EUR POUR LE SERVICE DE    PAIEMENT CARTE DE CREDIT.                              REF. : 0816433037751 VAL. 01-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8581,3,'164608920078.65','2022-03-01','','HERPIGNY-MOTORS  S.A.  COG',NULL,-78.65,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 01/03 14:50 HERPIGNY-MOTORS S.   A. COG                                                 REF. : 0058994961487 VAL. 01-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8582,3,'16457436006900','2022-02-25','BE90 2500 3176 2232','HERPIGNY MOTORS SA',NULL,-6900,'EUR','SOLDE BMW R1250GSA LEGARDIEN','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8583,3,'164574360027.83','2022-02-25','BE61 0910 1660 5217','PROXIMUS SA',NULL,-27.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007202072054 REFERENCE DU  CREANCIER : 8007733403                                 REF. : 081962P007863 VAL. 25-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8584,3,'164557080038.2','2022-02-23','','BRASSE TEMPS DIFFUSION TOU',NULL,-38.2,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 23/02 13:52 BRASSE   TEMPS DIFFUSION TOU                                    REF. : 0056801711379 VAL. 23-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8585,3,'1645484400195.4','2022-02-22','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-195.4,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0720109232 R B2202592 //20220218-BEDO1 REFERENCE DU    CREANCIER : I0000035249776-110407201092322022          REF. : 081962M048628 VAL. 22-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8586,3,'164548440016728.25','2022-02-22','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,16728.25,'EUR','WFI0001','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8587,3,'16450524001000','2022-02-17','BE90 2500 3176 2232','HERPIGNY MOTORS SA',NULL,-1000,'EUR','ACOMPTE R1250 GSA WEFEATIT','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8588,3,'1644879600833.01','2022-02-15','BE13 2100 0007 6339','AG INSURANCE SA',NULL,833.01,'EUR','69 000012020281 - REMBOURSEMENT TROP-PER U','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8589,3,'1644534000550.55','2022-02-11','BE14 0689 3381 4983','CABINET COMPTABLE BARBARA LAURENT',NULL,-550.55,'EUR','2021/144','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8590,3,'1644361200252.2','2022-02-09','','HERPIGNY-MOTORS  S.A.  COG',NULL,-252.2,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 09/02 15:20 HERPIGNY-MOTORS S.   A. COG                                                 REF. : 0058994961583 VAL. 09-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8591,3,'1644188400108.85','2022-02-07','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-108.85,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0720044865 R B2128110 //20220203-BEDO1 REFERENCE DU    CREANCIER : I0000034689235-110407200448652022          REF. : 0819627405955 VAL. 07-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8592,3,'16439292006.19','2022-02-04','','',NULL,-6.19,'EUR','PARTICIPATION AUX FRAIS DE TENUE DE VOTRE BELFIUS      BUSINESS PACK PLUS DONT 1,93 EUR POUR LE SERVICE DE    PAIEMENT CARTE DE CREDIT.                              REF. : 0816423037682 VAL. 01-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8593,3,'1643842800199.06','2022-02-03','666-0000004-83','',NULL,-199.06,'EUR','VISA RELEVE NUMERO 025                                 REF. : 0827523188733 VAL. 03-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8594,3,'1643756400124.4','2022-02-02','BE41 2500 0974 1010','ROTARY',NULL,-124.4,'EUR','ROTARY SEP-DEC 2021 F.LEGARDIEN','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8595,3,'1643583600126.8','2022-01-31','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-126.8,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0720013643 R B2084984 //20220127-BEDOC REFERENCE DU    CREANCIER : I0000034411881-110407200136432022          REF. : 081961V660297 VAL. 31-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8596,3,'164332440016610.05','2022-01-28','BE42 6792 0000 0054','SPF FINANCES',NULL,-16610.05,'EUR','+++200/8871/66415+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8597,3,'164323800018.4','2022-01-27','BE57 5523 3881 0035','NMBS - SNCB',NULL,-18.4,'EUR','+++002/6939/44018+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8598,3,'164306520027.83','2022-01-25','BE61 0910 1660 5217','PROXIMUS SA',NULL,-27.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007201485451 REFERENCE DU  CREANCIER : 9007455863                                 REF. : 081961P005842 VAL. 25-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8599,3,'164297880015194.7','2022-01-24','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,15194.7,'EUR','WFI0017','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8600,3,'16427196002677.17','2022-01-21','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-2677.17,'EUR','+++480/0377/58064+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8601,3,'1642719600833.01','2022-01-21','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-833.01,'EUR','+++480/0377/56044+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8602,3,'164263320018.4','2022-01-20','BE57 5523 3881 0035','NMBS - SNCB',NULL,-18.4,'EUR','+++002/6863/53968+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8603,3,'164263320010112.89','2022-01-20','BE22 6792 0030 0047','TVA RECETTES',NULL,-10112.89,'EUR','+++072/8750/01371+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8604,3,'1642374000833.01','2022-01-17','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-833.01,'EUR','+++480/0377/56044+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8605,3,'164202840018.4','2022-01-13','BE57 5523 3881 0035','NMBS - SNCB',NULL,-18.4,'EUR','+++002/6790/49767+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8606,3,'164194200049.2','2022-01-12','','LE 830 SPRL            WEP',NULL,-49.2,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 12/01 14:02 LE 830 SPRL WEP      REF. : 0018827431497 VAL. 12-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8607,3,'1641510000129.17','2022-01-07','BE62 2100 4700 7161','TOTALENERGIES MARKETING BELGIUM',NULL,-129.17,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALENERGIES MARKETING BELGIUM COMMUNICATION : I 0719855860 R B2043867 //20220105-BEDO1 REFERENCE DU    CREANCIER : I0000033675910-110407198558602022          REF. : 0819617152308 VAL. 07-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8608,3,'16414236006.19','2022-01-06','','',NULL,-6.19,'EUR','PARTICIPATION AUX FRAIS DE TENUE DE VOTRE BELFIUS      BUSINESS PACK PLUS DONT 1,93 EUR POUR LE SERVICE DE    PAIEMENT CARTE DE CREDIT.                              REF. : 0816415053927 VAL. 01-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8609,3,'164125080033.94','2022-01-04','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-33.94,'EUR','+++176/2363/10881+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8610,3,'16412508001500','2022-01-04','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-1500,'EUR','12/2021','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8611,3,'164125080029.3','2022-01-04','','BRASSE TEMPS DIFFUSION PIP',NULL,-29.3,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 04/01 12:32 BRASSE TEMPS         DIFFUSION PIP                                          REF. : 0059402571204 VAL. 04-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8612,3,'1641164400220','2022-01-03','666-0000004-83','',NULL,-220,'EUR','VISA RELEVE NUMERO 359                                 REF. : 0827513191619 VAL. 03-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8613,3,'1641164400249.9','2022-01-03','','IKEA BELGIUM NV        ZAV',NULL,-249.9,'EUR','ACHAT PAR INTERNET AVEC CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC LE 03/01 14:39 IKEA BELGIUM NV ZAV  REF. : 0505002041459 VAL. 03-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8614,2,'164055960027.83','2021-12-27','BE61 0910 1660 5217','PROXIMUS SA',NULL,-27.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007108078900 REFERENCE DU  CREANCIER : 9007344555                                 REF. : 08196CR036821 VAL. 27-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8615,2,'1640127600122.13','2021-12-22','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-122.13,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0719785575 R      B1C47815 //20211220-BEDO1 REFERENCE DU CREANCIER :     I0000033091350-110407197855752021                      REF. : 08196CM112887 VAL. 22-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8616,2,'164004120014241.7','2021-12-21','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,14241.7,'EUR','WFI0016','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8617,2,'16396956009','2021-12-17','','PARKING ESPLANAD       LIE',NULL,-9,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 17/12 16:50 PARKING ESPLANAD LIE REF. : 0034096421681 VAL. 17-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8618,2,'16396956001973.05','2021-12-17','BE80 0000 0010 4777','CAISSE D\'ASS SOCIALES UCM',NULL,-1973.05,'EUR','+++500/2374/83658+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8619,2,'163960920010','2021-12-16','','TOTAL NB004071 COURRIE COU',NULL,-10,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 16/12 11:16 TOTAL NB004071       COURRIE COU                                            REF. : 0064071511118 VAL. 16-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8620,2,'1639609200187','2021-12-16','BE50 4354 1204 0118','DAS SA',NULL,-187,'EUR','+++102/0093/75040+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8621,2,'1639609200526.22','2021-12-16','','AG INSURANCE           BRU',NULL,-526.22,'EUR','ACHAT PAR INTERNET AVEC CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC LE 16/12 08:51 AG INSURANCE BRU     REF. 113645248904                                      REF. : 035VLDQ8E0000 VAL. 16-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8622,2,'1638918000277.8','2021-12-08','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-277.8,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0719728451 R      B1B70047 //20211206-BEDO1 REFERENCE DU CREANCIER :     I0000032491132-110407197284512021                      REF. : 08196C8134364 VAL. 08-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8623,2,'1638831600168.09','2021-12-07','666-0000004-83','',NULL,-168.09,'EUR','VISA RELEVE NUMERO 329                                 REF. : 08075C7197173 VAL. 07-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8624,2,'1638745200588.1','2021-12-06','','LES TERRASSES DE       NAM',NULL,-588.1,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 03/12 22:46 LES TERRASSES DE NAM REF. : 0521381642186 VAL. 03-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8625,2,'16384860001500','2021-12-03','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-1500,'EUR','11/2021','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8626,2,'163848600033.94','2021-12-03','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-33.94,'EUR','+++175/4503/40897+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8627,2,'1638486000278.02','2021-12-03','','BALOISE DOCCLE         BER',NULL,-278.02,'EUR','ACHAT PAR INTERNET AVEC CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC LE 03/12 17:16 BALOISE DOCCLE BER   REF. : 0047271281768 VAL. 03-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8628,2,'16384860001921.23','2021-12-03','BE31 4100 0007 1155','BALOISE INSURANCE',NULL,-1921.23,'EUR','+++485/7780/36693+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8629,2,'163831320048.8','2021-12-01','','LE 830 SPRL            WEP',NULL,-48.8,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 01/12 13:51 LE 830 SPRL WEP      REF. : 0018827431377 VAL. 01-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8630,2,'1638226800291.1','2021-11-30','BE74 3300 5767 1507','DHL',NULL,-291.1,'EUR','BDV3187746','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8631,2,'1638226800214.17','2021-11-30','','HERPIGNY-MOTORS  S.A.  COG',NULL,-214.17,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 30/11 10:57 HERPIGNY-MOTORS S.   A. COG                                                 REF. : 0058994961059 VAL. 30-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8632,2,'163779480027.83','2021-11-25','BE61 0910 1660 5217','PROXIMUS SA',NULL,-27.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007107495196 REFERENCE DU  CREANCIER : 4007241056                                 REF. : 08196BP011655 VAL. 25-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8633,2,'163762200013954.45','2021-11-23','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,13954.45,'EUR','WFI0015','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8634,2,'1637535600204.87','2021-11-22','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-204.87,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0719668241 R      B1B43500 //20211118-BEDO1 REFERENCE DU CREANCIER :     I0000031921194-110407196682412021                      REF. : 08196BM193701 VAL. 22-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8635,2,'16372764005.5','2021-11-19','','',NULL,-5.5,'EUR','PAIEMENT MAESTRO 18/11-BRUSSEL PARK BRU BE 5,50 EUR    CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC      REF. : 1190040182170 VAL. 19-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8636,2,'16372764008.47','2021-11-19','BE06 0689 3535 1122','ESPACE COMMUNAUT ST-LOUP,',NULL,8.47,'EUR','WFI0013','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8637,2,'1637276400341.86','2021-11-19','','HERPIGNY-MOTORS  S.A.  COG',NULL,-341.86,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 19/11 09:13 HERPIGNY-MOTORS S.   A. COG                                                 REF. : 0058994960979 VAL. 19-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8638,2,'163710360050','2021-11-17','','LES TERRASSES DE       NAM',NULL,-50,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 16/11 22:29 LES      TERRASSES DE NAM                                       REF. : 0521381642161 VAL. 16-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8639,2,'163632600062.09','2021-11-08','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-62.09,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0719611252 R      B1A53441 //20211104-BEDO1 REFERENCE DU CREANCIER :     I0000031477402-110407196112522021                      REF. : 08196B8281691 VAL. 08-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8640,2,'163598040033.94','2021-11-04','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-33.94,'EUR','+++174/8214/70804+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8641,2,'16359804001500','2021-11-04','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-1500,'EUR','10/2021','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8642,2,'1635980400105.84','2021-11-04','','FOD JUSTITIE           BRU',NULL,-105.84,'EUR','ACHAT PAR INTERNET AVEC CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC LE 04/11 11:37 FOD JUSTITIE BRU     REF. +++150/0176/71532+++                              REF. : 051RMINAL0000 VAL. 04-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8643,2,'16358940001521.02','2021-11-03','666-0000004-83','',NULL,-1521.02,'EUR','VISA RELEVE NUMERO 298                                 REF. : 08275B3188972 VAL. 03-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8644,2,'163537200060','2021-10-28','','IL POMMODORO           BRU',NULL,-60,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 28/10 13:01 IL POMMODORO BRU     REF. : 0495772501465 VAL. 28-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8645,2,'1635199200102.09','2021-10-26','','MOTOR-SERVICE  SPRL    HUY',NULL,-102.09,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 26/10 11:45 MOTOR-SERVICE SPRL   HUY                                                    REF. : 0058845311102 VAL. 26-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8646,2,'16351992003.54','2021-10-26','BE90 0682 5096 8632','SECRETARIAT SOCIAL CLASSES',NULL,3.54,'EUR','REMBOURSEMENT SOLDE DE COMPTE                        DOSSIER 503024','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8647,2,'163511280017105.17','2021-10-25','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,17105.17,'EUR','WFI0014','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8648,2,'163511280050.7','2021-10-25','','LE 830 SPRL            WEP',NULL,-50.7,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 25/10 13:37 LE 830 SPRL WEP      REF. : 0018827431399 VAL. 25-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8649,2,'163511280027.83','2021-10-25','BE61 0910 1660 5217','PROXIMUS SA',NULL,-27.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007106912868 REFERENCE DU  CREANCIER : 6007113447                                 REF. : 08196AP040586 VAL. 25-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8650,2,'1634853600236.11','2021-10-22','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-236.11,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0719546442 R      B1A32801 //20211020-BEDO1 REFERENCE DU CREANCIER :     I0000030939203-110407195464422021                      REF. : 08196AM068406 VAL. 22-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8651,2,'16345944007460.55','2021-10-19','BE22 6792 0030 0047','TVA RECETTES',NULL,-7460.55,'EUR','+++072/8750/01371+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8652,2,'1634508000279.01','2021-10-18','','MOTOR-SERVICE  SPRL    HUY',NULL,-279.01,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 16/10 11:00 MOTOR-SERVICE SPRL   HUY                                                    REF. : 0058845311132 VAL. 16-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8653,2,'163364400033.94','2021-10-08','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-33.94,'EUR','+++174/3031/00881+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8654,2,'16336440001500','2021-10-08','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-1500,'EUR','09/2021','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8655,2,'1633557600151.33','2021-10-07','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-151.33,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0719482805 R      B1965231 //20211005-BEDO1 REFERENCE DU CREANCIER :     I0000030439622-110407194828052021                      REF. : 08196A7118716 VAL. 07-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8656,2,'163329840060.18','2021-10-04','666-0000004-83','',NULL,-60.18,'EUR','VISA RELEVE NUMERO 268                                 REF. : 08275A4190304 VAL. 04-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8657,2,'163295280037.9','2021-09-30','','BRASSE TEMPS DIFFUSION PIP',NULL,-37.9,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 30/09 13:53 BRASSE TEMPS         DIFFUSION PIP                                          REF. : 0059402571386 VAL. 30-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8658,2,'16327800002459.93','2021-09-28','BE32 7320 3012 3302','RHCN',NULL,-2459.93,'EUR','SP000398','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8659,2,'1632780000170','2021-09-28','BE32 7320 3012 3302','RHCN',NULL,-170,'EUR','EV000045','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8660,2,'163269360027.83','2021-09-27','BE61 0910 1660 5217','PROXIMUS SA',NULL,-27.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007106316309 REFERENCE DU  CREANCIER : 0006981402                                 REF. : 081969R059334 VAL. 27-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8661,2,'16322616007714.48','2021-09-22','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,7714.48,'EUR','WFI00012','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8662,2,'1632261600161.34','2021-09-22','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-161.34,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0719412294 R      B1912592 //20210920-BEDO1 REFERENCE DU CREANCIER :     I0000029794553-110407194122942021                      REF. : 081969M085039 VAL. 22-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8663,2,'163208880057.36','2021-09-20','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-57.36,'EUR','+++480/0377/56044+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8664,2,'16318296001973.05','2021-09-17','BE80 0000 0010 4777','CAISSE D\'ASS SOCIALES UCM',NULL,-1973.05,'EUR','+++500/2214/76133+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8665,2,'163174320037.5','2021-09-16','','ASHOR.B SPRL           BRU',NULL,-37.5,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 16/09 13:08 ASHOR. B SPRL BRU    REF. : 0047814751313 VAL. 16-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8666,2,'1631656800133.95','2021-09-15','','RAD NIVELLES           NIV',NULL,-133.95,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 15/09 16:48 RAD NIVELLES NIV     REF. : 0049740381652 VAL. 15-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8667,2,'1630965600129.06','2021-09-07','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-129.06,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0719346284 R      B1862578 //20210903-BEDO1 REFERENCE DU CREANCIER :     I0000029306362-110407193462842021                      REF. : 0819697194015 VAL. 07-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8668,2,'1630965600446.03','2021-09-07','BE36 0912 1503 4881','SPW',NULL,-446.03,'EUR','+++012/0068/29445+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8669,2,'163096560033.07','2021-09-07','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-33.07,'EUR','+++173/4675/60867+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8670,2,'16309656001500','2021-09-07','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-1500,'EUR','08/2021','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8671,2,'1630620000209.41','2021-09-03','666-0000004-83','',NULL,-209.41,'EUR','VISA RELEVE NUMERO 237                                 REF. : 0807593189656 VAL. 03-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8672,2,'163044720034.3','2021-09-01','','MAISON GASTON          JAM',NULL,-34.3,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 01/09 12:07 MAISON   GASTON JAM                                             REF. : 0520998151004 VAL. 01-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8673,2,'162992880018465.45','2021-08-26','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,18465.45,'EUR','WFI0010','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8674,2,'162984240027.83','2021-08-25','BE61 0910 1660 5217','PROXIMUS SA',NULL,-27.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007105720934 REFERENCE DU  CREANCIER : 4006830367                                 REF. : 081968P037997 VAL. 25-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8675,2,'1629669600201.82','2021-08-23','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-201.82,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0719289240 R      C1738027 //20210819-BEDO1 REFERENCE DU CREANCIER :     I0000028788876-110407192892402021                      REF. : 081968N221853 VAL. 23-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8676,2,'162966960094.39','2021-08-23','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-94.39,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0719289239 R      B1804560 //20210819-BEDO1 REFERENCE DU CREANCIER :     I0000028788875-110407192892392021                      REF. : 081968N221852 VAL. 23-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8677,2,'162966960054.9','2021-08-23','BE14 0689 3381 4983','CABINET COMPTABLE BARBARA LAURENT',NULL,-54.9,'EUR','FRAIS DE PUBLICATION','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8678,2,'1629669600592.9','2021-08-23','BE14 0689 3381 4983','CABINET COMPTABLE BARBARA LAURENT',NULL,-592.9,'EUR','2021/025','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8679,2,'162966960059.53','2021-08-23','BE36 0912 1503 4881','SPW',NULL,-59.53,'EUR','+++011/9871/94423+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8680,2,'162846000057.29','2021-08-09','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-57.29,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0719218123 R      B1759227 //20210805-BEDO1 REFERENCE DU CREANCIER :     I0000028345088-110407192181232021                      REF. : 0819689223418 VAL. 09-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8681,2,'162820080044.3','2021-08-06','','DINOBURGER.BE          LIE',NULL,-44.3,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 06/08 14:19          DINOBURGER.BE LIE                                      REF. : 0381579111246 VAL. 06-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8682,2,'16282008009.99','2021-08-06','','PARTENAIRES PRODUITS & SPY',NULL,-9.99,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 06/08 11:52          PARTENAIRES PRODUITS & SPY                             REF. : 0018432901123 VAL. 06-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8683,2,'16281144001500','2021-08-05','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-1500,'EUR','07/2021','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8684,2,'162811440033.07','2021-08-05','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-33.07,'EUR','+++172/9470/10872+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8685,2,'16279416006435.99','2021-08-03','BE84 0689 3590 7759','OPENFLOW',NULL,6435.99,'EUR','WFI 0011 DEVELOPPEMENT ET CONCEPTION DU MODELE OPENFLOW 2020','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8686,2,'16279416002413.95','2021-08-03','BE84 0689 3590 7759','OPENFLOW',NULL,2413.95,'EUR','FACTURE WFI 0008 WAAHCOOP','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8687,2,'162794160020.09','2021-08-03','666-0000004-83','',NULL,-20.09,'EUR','VISA RELEVE NUMERO 206                                 REF. : 0807583184528 VAL. 03-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8688,2,'162785520048.4','2021-08-02','','LE 830 SPRL            WEP',NULL,-48.4,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 02/08 13:58 LE 830 SPRL WEP      REF. : 0018827431356 VAL. 02-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8689,2,'162785520018.45','2021-08-02','','THE SEVEN S.A.         NAM',NULL,-18.45,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 31/07 17:37 THE SEVEN S. A. NAM  REF. : 0056328001763 VAL. 31-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8690,2,'162785520020.99','2021-08-02','','BRICO PLAN IT 4217 JAM JAM',NULL,-20.99,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 31/07 17:15 BRICO    PLAN IT 4217 JAM JAM                                   REF. : 0015532011734 VAL. 31-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8691,2,'162742320028.33','2021-07-28','BE61 0910 1660 5217','PROXIMUS SA',NULL,-28.33,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007105132046 REFERENCE DU  CREANCIER : 2006909905                                 REF. : 081967S027054 VAL. 28-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8692,2,'162742320014662.78','2021-07-28','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,14662.78,'EUR','WFI0009','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8693,2,'162690480066.9','2021-07-22','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-66.9,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0719152198 R      C1727554 //20210720-BEDO1 REFERENCE DU CREANCIER :     I0000027744602-110407191521982021                      REF. : 081967M133593 VAL. 22-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8694,2,'1626904800158.32','2021-07-22','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-158.32,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0719152197 R      B1706512 //20210720-BEDO1 REFERENCE DU CREANCIER :     I0000027744601-110407191521972021                      REF. : 081967M133592 VAL. 22-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8695,2,'16266456007503.27','2021-07-19','BE22 6792 0030 0047','TVA RECETTES',NULL,-7503.27,'EUR','+++072/8750/01371+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8696,2,'1625781600198.5','2021-07-09','BE65 0689 3613 4596','FLOW SOLUTIONS',NULL,-198.5,'EUR','21/0017','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8697,2,'16257816001500','2021-07-09','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-1500,'EUR','06/2021','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8698,2,'162578160033.07','2021-07-09','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-33.07,'EUR','+++172/0188/40811+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8699,2,'1625695200111.35','2021-07-08','','RAD NIVELLES           NIV',NULL,-111.35,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 08/07 16:02 RAD NIVELLES NIV     REF. : 0049740381683 VAL. 08-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8700,2,'162569520037.83','2021-07-08','','',NULL,-37.83,'EUR','PARTICIPATION AUX FRAIS DE TENUE DE VOTRE BELFIUS      BUSINESS PACK PLUS DONT 11,58 EUR POUR LE SERVICE DE   PAIEMENT CARTE DE CREDIT.                              REF. : 0816475051691 VAL. 01-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8701,2,'1625608800101.97','2021-07-07','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-101.97,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0719087846 R      B1638660 //20210705-BEDO1 REFERENCE DU CREANCIER :     I0000027169848-110407190878462021                      REF. : 0819677401659 VAL. 07-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8702,2,'162543600091.91','2021-07-05','666-0000004-83','',NULL,-91.91,'EUR','VISA RELEVE NUMERO 176                                 REF. : 0827575185320 VAL. 05-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8703,2,'16249176001296.43','2021-06-29','','GARAGE QUOILIN  S A    MAR',NULL,-1296.43,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 29/06 15:57 GARAGE QUOILIN S A   MAR                                                    REF. : 0074870761539 VAL. 29-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8704,2,'162483120091.5','2021-06-28','','',NULL,-91.5,'EUR','PAIEMENT MAESTRO 24/06-PARIS 10 LA MADONNINA FR 91,50  EUR CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC  REF. : 6280040164368 VAL. 28-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8705,2,'162448560016.9','2021-06-24','','',NULL,-16.9,'EUR','PAIEMENT MAESTRO 23/06-PARIS 10 SNCF FR 16,90 EUR      CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC      REF. : 6240040335856 VAL. 24-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8706,2,'16244856007.5','2021-06-24','','',NULL,-7.5,'EUR','PAIEMENT MAESTRO 23/06-MONTREUIL IZ *HOUMOUS JO FR     7,50 EUR CARTE N 6703 0700 3436 4800 - LEGARDIEN      FREDERIC                                               REF. : 6240040335857 VAL. 24-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8707,2,'162439920027.83','2021-06-23','BE61 0910 1660 5217','PROXIMUS SA',NULL,-27.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007104534108 REFERENCE DU  CREANCIER : 9006498755                                 REF. : 081966N023513 VAL. 23-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8708,2,'162431280066.46','2021-06-22','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-66.46,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0719032146 R      B1585204 //20210618-BEDO1 REFERENCE DU CREANCIER :     I0000026654781-110407190321462021                      REF. : 081966M121076 VAL. 22-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8709,2,'162431280014592.84','2021-06-22','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,14592.84,'EUR','WFI007','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8710,2,'162396720071.3','2021-06-18','','BRASSE TEMPS DIFFUSION TOU',NULL,-71.3,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 18/06 13:57 BRASSE TEMPS         DIFFUSION TOU                                          REF. : 0056801711314 VAL. 18-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8711,2,'16237944002677.17','2021-06-16','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-2677.17,'EUR','+++480/0377/58064+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8712,2,'1623794400833.01','2021-06-16','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-833.01,'EUR','+++480/0377/56044+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8713,2,'1623708000137.88','2021-06-15','BE80 0000 0010 4777','CAISSE D\'ASS SOCIALES UCM',NULL,-137.88,'EUR','+++500/1999/46577+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8714,2,'16237080001973.05','2021-06-15','BE80 0000 0010 4777','CAISSE D\'ASS SOCIALES UCM',NULL,-1973.05,'EUR','+++500/2078/98052+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8715,2,'1623016800104.49','2021-06-07','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-104.49,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0718963810 R      B1528439 //20210603-BEDO1 REFERENCE DU CREANCIER :     I0000026143913-110407189638102021                      REF. : 0819667294122 VAL. 07-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8716,2,'1622671200150','2021-06-03','666-0000004-83','',NULL,-150,'EUR','VISA RELEVE NUMERO 145                                 REF. : 0807563172535 VAL. 03-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8717,2,'162258480033.07','2021-06-02','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-33.07,'EUR','+++171/2679/30869+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8718,2,'16225848001500','2021-06-02','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-1500,'EUR','05/2021','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8719,2,'1622584800100','2021-06-02','BE33 9733 6113 2246','FELICIEN DOUILLET',NULL,100,'EUR','REMBOURSEMENT SPONSORING IATA NAMUR','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8720,2,'162241200057.36','2021-05-31','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-57.36,'EUR','+++480/0377/56044+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8721,2,'1622412000164.66','2021-05-31','BE18 1440 5211 6665','BERNARD PUISSANT SC',NULL,-164.66,'EUR','03/0000996051185 01/01/202097509','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8722,2,'1622412000775.65','2021-05-31','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-775.65,'EUR','+++480/0377/56044+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8723,2,'162198000028.33','2021-05-26','BE61 0910 1660 5217','PROXIMUS SA',NULL,-28.33,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007103932904 REFERENCE DU  CREANCIER : 6006438281                                 REF. : 081965Q007459 VAL. 26-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8724,2,'1621893600106.36','2021-05-25','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-106.36,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0718930762 R      B1487765 //20210521-BEDO1 REFERENCE DU CREANCIER :     I0000025763197-110407189307622021                      REF. : 081965P068011 VAL. 25-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8725,2,'162077040013857.77','2021-05-12','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,13857.77,'EUR','WFI0006','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8726,2,'162059760033.07','2021-05-10','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-33.07,'EUR','+++170/7802/90853+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8727,2,'16205976001500','2021-05-10','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-1500,'EUR','04/2021','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8728,2,'1620338400146.54','2021-05-07','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-146.54,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0718851554 R      B1432501 //20210505-BEDO1 REFERENCE DU CREANCIER :     I0000025163938-110407188515542021                      REF. : 0819657211219 VAL. 07-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8729,2,'1620252000211.75','2021-05-06','BE14 0689 3381 4983','CABINET COMPTABLE BARBARA LAURENT',NULL,-211.75,'EUR','2020/171','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8730,2,'1620079200339.63','2021-05-04','666-0000004-83','',NULL,-339.63,'EUR','VISA RELEVE NUMERO 115                                 REF. : 0827554168311 VAL. 04-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8731,2,'161938800028.33','2021-04-26','BE61 0910 1660 5217','PROXIMUS SA',NULL,-28.33,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007103334492 REFERENCE DU  CREANCIER : 4006284423                                 REF. : 081964Q063724 VAL. 26-04','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8732,2,'1619388000833.01','2021-04-26','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-833.01,'EUR','+++480/0377/56044+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8733,2,'161912880013777.67','2021-04-23','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,13777.67,'EUR','WFI0031','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8734,2,'161904240046.65','2021-04-22','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-46.65,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0718787842 R      B1392219 //20210420-BEDO1 REFERENCE DU CREANCIER :     I0000024619931-110407187878422021                      REF. : 081964M103158 VAL. 22-04','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8735,2,'16187832008358.74','2021-04-19','BE22 6792 0030 0047','TVA RECETTES',NULL,-8358.74,'EUR','+++072/8750/01371+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8736,2,'16184376001009.19','2021-04-15','','PNEUS MOSAN SA  BOUGE',NULL,-1009.19,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 15/04 15:55 PNEUS MOSAN SA BOUGE REF. : 0050288921500 VAL. 15-04','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8737,2,'1617832800163.33','2021-04-08','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-163.33,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0718724876 R      B1346835 //20210406-BEDO1 REFERENCE DU CREANCIER :     I0000024135299-110407187248762021                      REF. : 0819648389436 VAL. 08-04','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8738,2,'161766000032.36','2021-04-06','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-32.36,'EUR','+++170/0041/50811+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8739,2,'16176600001500','2021-04-06','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-1500,'EUR','03/2021','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8740,2,'16176600001223.1','2021-04-06','666-0000004-83','',NULL,-1223.1,'EUR','VISA RELEVE NUMERO 084                                 REF. : 0827546169833 VAL. 06-04','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8741,2,'161662680027.83','2021-03-25','BE61 0910 1660 5217','PROXIMUS SA',NULL,-27.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007102731872 REFERENCE DU  CREANCIER : 3006145137                                 REF. : 081963P014186 VAL. 25-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8742,2,'1616540400100','2021-03-24','BE33 9733 6113 2246','IATA NAMUR',NULL,-100,'EUR','SPONSORING IATA NAMUR','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8743,2,'1616367600122.11','2021-03-22','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-122.11,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0718668864 R      B1284670 //20210318-BEDO1 REFERENCE DU CREANCIER :     I0000023554242-110407186688642021                      REF. : 081963M153905 VAL. 22-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8744,2,'16161084001973.05','2021-03-19','BE80 0000 0010 4777','CAISSE D\'ASS SOCIALES UCM',NULL,-1973.05,'EUR','+++500/1877/64892+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8745,2,'161550360015023','2021-03-12','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,15023,'EUR','WFI0029+RESTANT DE WFI0027','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8746,2,'161533080095.59','2021-03-10','BE84 0689 3590 7759','OPENFLOW',NULL,95.59,'EUR','FACTURE WFI0030','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8747,2,'1615330800140','2021-03-10','BE84 0689 3590 7759','OPENFLOW',NULL,140,'EUR','FACTURE WFI0024','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8748,2,'161515800047.6','2021-03-08','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-47.6,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0718617336 R      B1224561 //20210304-BEDO1 REFERENCE DU CREANCIER :     I0000023114355-110407186173362021                      REF. : 0819638179022 VAL. 08-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8749,2,'1615158000189.48','2021-03-08','666-0000004-83','',NULL,-189.48,'EUR','VISA RELEVE NUMERO 056                                 REF. : 0807538172320 VAL. 08-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8750,2,'161481240032.36','2021-03-04','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-32.36,'EUR','+++169/4618/20878+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8751,2,'161481240032.36','2021-03-04','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-32.36,'EUR','+++169/3955/00867+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8752,2,'16148124003000','2021-03-04','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-3000,'EUR','01-02/2021','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8753,2,'16142940003660','2021-02-26','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-3660,'EUR','12/2020 BIS','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8754,2,'161429400017.47','2021-02-26','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-17.47,'EUR','+++169/2300/30890+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8755,2,'1614294000296.45','2021-02-26','BE14 0689 3381 4983','CABINET COMPTABLE BARBARA LAURENT',NULL,-296.45,'EUR','FACTURE 2020/118','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8756,2,'161420760028.33','2021-02-25','BE61 0910 1660 5217','PROXIMUS SA',NULL,-28.33,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007102127056 REFERENCE DU  CREANCIER : 5006023347                                 REF. : 081962P016302 VAL. 25-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8757,2,'161394840099.68','2021-02-22','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-99.68,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0718555459 R      B1185720 //20210218-BEDO1 REFERENCE DU CREANCIER :     I0000022518315-110407185554592021                      REF. : 081962M108587 VAL. 22-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8758,2,'161351640035218.62','2021-02-17','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,35218.62,'EUR','WFI0027+0028','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8759,2,'16130844001798.95','2021-02-12','','SWITCH ERPENT   ERPENT',NULL,-1798.95,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 12/02 16:38 SWITCH ERPENT ERPENT REF. :   05611451607 VAL. 12-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8760,2,'161273880074.45','2021-02-08','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-74.45,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0718497429 R      B1100064 //20210204-BEDO1 REFERENCE DU CREANCIER :     I0000022045938-110407184974292021                      REF. : 0819628410693 VAL. 08-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8761,2,'161170200027.83','2021-01-27','BE61 0910 1660 5217','PROXIMUS SA',NULL,-27.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007101520378 REFERENCE DU  CREANCIER : 1006010833                                 REF. : 081961R007482 VAL. 27-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8762,2,'16116156002677.17','2021-01-26','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-2677.17,'EUR','+++480/0377/58064+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8763,2,'16109244006860.76','2021-01-18','BE22 6792 0030 0047','TVA RECETTES',NULL,-6860.76,'EUR','+++072/8750/01371+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8764,2,'1610665200775.65','2021-01-15','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-775.65,'EUR','+++480/0377/56044+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8765,2,'161031960037.83','2021-01-11','','',NULL,-37.83,'EUR','PARTICIPATION AUX FRAIS DE TENUE DE VOTRE BELFIUS      BUSINESS PACK PLUS DONT 11,58 EUR POUR LE SERVICE DE   PAIEMENT CARTE DE CREDIT.                              REF. : 0816416048621 VAL. 01-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8766,2,'1610060400125.69','2021-01-08','BE31 4100 0007 1155','BALOISE BELGIUM NV',NULL,125.69,'EUR','5L57291 F21/00402 060121','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8767,2,'1609974000144.44','2021-01-07','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-144.44,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0718384696 R      B1030169 //20210105-BEDO1 REFERENCE DU CREANCIER :     I0000021019262-110407183846962021                      REF. : 0819617171717 VAL. 07-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8768,2,'160988760032.36','2021-01-06','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-32.36,'EUR','+++168/2198/90876+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8769,2,'1609887600793.99','2021-01-06','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-793.99,'EUR','+++168/2198/80671+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8770,2,'16098876002094.21','2021-01-06','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-2094.21,'EUR','12/2020','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8771,2,'1609801200168.46','2021-01-05','BE50 7310 2896 8518','MONIZZE SA',NULL,-168.46,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/23634+++        REFERENCE DU CREANCIER : 008637523634                  REF. : 0819615374413 VAL. 05-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8772,2,'1609714800462.31','2021-01-04','666-0000004-83','',NULL,-462.31,'EUR','VISA RELEVE NUMERO 360                                 REF. : 0827514177367 VAL. 04-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8773,1,'1609369200187','2020-12-31','BE50 4354 1204 0118','DAS SA',NULL,-187,'EUR','+++102/0093/75040+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8774,1,'16093692001986.79','2020-12-31','BE31 4100 0007 1155','BALOISE INSURANCE',NULL,-1986.79,'EUR','+++473/6105/35943+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8775,1,'1609369200268.63','2020-12-31','BE31 4100 0007 1155','BALOISE INSURANCE',NULL,-268.63,'EUR','+++473/7981/12422+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8776,1,'1609282800324.76','2020-12-30','BE50 7310 2896 8518','MONIZZE SA',NULL,-324.76,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/59101+++        REFERENCE DU CREANCIER : 008637559101                  REF. : 08196CU312149 VAL. 30-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8777,1,'16092828006.05','2020-12-30','BE50 7310 2896 8518','MONIZZE SA',NULL,-6.05,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/48084+++        REFERENCE DU CREANCIER : 008637548084                  REF. : 08196CU312148 VAL. 30-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8778,1,'160919640018.15','2020-12-29','BE50 7310 2896 8518','MONIZZE SA',NULL,-18.15,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/68090+++        REFERENCE DU CREANCIER : 008637568090                  REF. : 08196CT138315 VAL. 29-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8779,1,'160911000041.34','2020-12-28','BE61 0910 1660 5217','PROXIMUS SA',NULL,-41.34,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : +++007/0083/97924+++       REFERENCE DU CREANCIER : 8005848107                    REF. : 08196CS061998 VAL. 28-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8780,1,'1608591600320.57','2020-12-22','BE50 7310 2896 8518','MONIZZE SA',NULL,-320.57,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/83147+++        REFERENCE DU CREANCIER : 008637583147                  REF. : 08196CM141032 VAL. 22-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8781,1,'1608591600150.12','2020-12-22','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-150.12,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0718327833 R      B0C10049 //20201218-BEDO1 REFERENCE DU CREANCIER :     I0000020471273-110407183278332020                      REF. : 08196CM068691 VAL. 22-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8782,1,'1608591600626.74','2020-12-22','','HERPIGNY-MOTORS COGNELEE',NULL,-626.74,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 22/12 11:19 HERPIGNY-MOTORS      COGNELEE                                               REF. :   08994961168 VAL. 22-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8783,1,'1608591600213.82','2020-12-22','BE47 2100 0415 4480','EUROP ASSISTANCE BELGIUM',NULL,213.82,'EUR','07405607 / EABTB - 2020DOSSIER: 07405607','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8784,1,'160850520013784.32','2020-12-21','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,13784.32,'EUR','WFI0025','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8785,1,'160850520037.27','2020-12-21','BE50 7320 1179 1918','BMW QUOILIN',NULL,-37.27,'EUR','+++222/0120/11422+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8786,1,'1608073200526.22','2020-12-16','','AG INSURANCE    BRUSSELS',NULL,-526.22,'EUR','ACHAT PAR INTERNET AVEC CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC LE 16/12 08:22 AG INSURANCE         BRUSSELS REF. 103619514618                             REF. :   0VLDQ8E0000 VAL. 16-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8787,1,'1607986800262.1','2020-12-15','BE50 7310 2896 8518','MONIZZE SA',NULL,-262.1,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/46569+++        REFERENCE DU CREANCIER : 008637546569                  REF. : 08196CF233114 VAL. 15-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8788,1,'160798680080','2020-12-15','BE50 7310 2896 8518','MONIZZE SA',NULL,-80,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/46670+++        REFERENCE DU CREANCIER : 008637546670                  REF. : 08196CF233113 VAL. 15-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8789,1,'1607986800793.99','2020-12-15','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-793.99,'EUR','+++167/4875/60680+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8790,1,'160798680032.36','2020-12-15','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-32.36,'EUR','+++167/4875/70885+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8791,1,'16079868001973.05','2020-12-15','BE80 0000 0010 4777','CAISSE D\'ASS SOCIALES UCM',NULL,-1973.05,'EUR','+++500/1745/93407+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8792,1,'160729560048.01','2020-12-07','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-48.01,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0718270079 R      B0B42571 //20201203-BEDO1 REFERENCE DU CREANCIER :     I0000019908872-110407182700792020                      REF. : 08196C7416466 VAL. 07-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8793,1,'1607036400106.12','2020-12-04','666-0000004-83','',NULL,-106.12,'EUR','VISA RELEVE NUMERO 330                                 REF. : 08275C4165439 VAL. 04-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8794,1,'1607036400404.79','2020-12-04','BE40 3500 1644 5663','QUOILIN BMW',NULL,-404.79,'EUR','COMMANDE CLE LEGARDIEN (WEFEATIT)','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8795,1,'16070364002094.21','2020-12-04','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-2094.21,'EUR','11/2020','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8796,1,'1606950000258.72','2020-12-03','BE24 0017 5790 5738','ANNOYE FRANCK',NULL,-258.72,'EUR','+++202/0124/42092+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8797,1,'160677720028.31','2020-12-01','BE65 0689 3613 4596','FLOW SOLUTIONS',NULL,28.31,'EUR','WFI0026','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8798,1,'160625880028.33','2020-11-25','BE61 0910 1660 5217','PROXIMUS SA',NULL,-28.33,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007007786110 REFERENCE DU  CREANCIER : 0005570459                                 REF. : 08196BP009692 VAL. 25-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8799,1,'160617240037.15','2020-11-24','','PRINTDEAL.BE    ANTWERP',NULL,-37.15,'EUR','ACHAT PAR INTERNET AVEC CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC LE 24/11 14:47 PRINTDEAL. BE        ANTWERP REF. --LPORDER-10475264                        REF. :   00000000000 VAL. 24-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8800,1,'160617240042.42','2020-11-24','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-42.42,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0718221675 R      B0B17304 //20201119-BEDO1 REFERENCE DU CREANCIER :     I0000019389100-110407182216752020                      REF. : 08196BO029694 VAL. 24-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8801,1,'160548120017256.42','2020-11-16','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,17256.42,'EUR','WFI0023','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8802,1,'1604876400141.45','2020-11-09','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-141.45,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0718160049 R      B0A73589 //20201105-BEDOP REFERENCE DU CREANCIER :     I0000018862725-110407181600492020                      REF. : 08196B9394202 VAL. 09-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8803,1,'1604876400793.99','2020-11-09','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-793.99,'EUR','+++166/9224/40603+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8804,1,'160487640032.36','2020-11-09','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-32.36,'EUR','+++166/9224/50808+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8805,1,'16048764002094.21','2020-11-09','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-2094.21,'EUR','10/2020','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8806,1,'160453080065','2020-11-05','BE34 6792 0036 2590','AMENDE ROUTIERES',NULL,-65,'EUR','+++014/0098/13464+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8807,1,'1604358000168.46','2020-11-03','BE50 7310 2896 8518','MONIZZE SA',NULL,-168.46,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/41721+++        REFERENCE DU CREANCIER : 008637541721                  REF. : 08196B3227994 VAL. 03-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8808,1,'1604358000321.24','2020-11-03','666-0000004-83','',NULL,-321.24,'EUR','VISA RELEVE NUMERO 299                                 REF. : 08275B3166142 VAL. 03-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8809,1,'1604271600465.85','2020-11-02','BE14 0689 3381 4983','CABINET COMPTABLE BARBARA LAURENT',NULL,-465.85,'EUR','2020/055','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8810,1,'1603666800118.92','2020-10-26','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-118.92,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0718125949 R      B0A07209 //20201022-BEDOP REFERENCE DU CREANCIER :     I0000018286637-110407181259492020                      REF. : 08196AQ175094 VAL. 26-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8811,1,'160366680028.83','2020-10-26','BE61 0910 1660 5217','PROXIMUS SA',NULL,-28.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007007170395 REFERENCE DU  CREANCIER : 1005581486                                 REF. : 08196AQ020683 VAL. 26-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8812,1,'160314480019.36','2020-10-20','BE65 0689 3613 4596','FLOW SOLUTIONS',NULL,19.36,'EUR','# WFI0008','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8813,1,'16031448002459.93','2020-10-20','BE32 7320 3012 3302','RHCN',NULL,-2459.93,'EUR','SP000356','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8814,1,'16030584006874.85','2020-10-19','BE22 6792 0030 0047','TVA RECETTES',NULL,-6874.85,'EUR','+++072/8750/01371+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8815,1,'160245360025372.49','2020-10-12','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,25372.49,'EUR','WFI0020+0021','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8816,1,'160219440047','2020-10-09','','BRASSE TEMPS DIFPIPAIX',NULL,-47,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 09/10 13:32 BRASSE TEMPS         DIFPIPAIX                                              REF. :   08132261300 VAL. 09-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8817,1,'1602194400793.99','2020-10-09','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-793.99,'EUR','+++166/2916/50613+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8818,1,'160219440032.36','2020-10-09','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-32.36,'EUR','+++166/2916/60818+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8819,1,'16021944002094.21','2020-10-09','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-2094.21,'EUR','09/2020','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8820,1,'1602108000740','2020-10-08','BE62 0688 9235 4961','DYNAMIC EVENTS SRL',NULL,740,'EUR','RBT VOYAGE BIHR','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8821,1,'160202160098.6','2020-10-07','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-98.6,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0718039961 R      B0931261 //20201005-BEDO1 REFERENCE DU CREANCIER :     I0000017646284-110407180399612020                      REF. : 08196A7233032 VAL. 07-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8822,1,'160184880065','2020-10-05','','FOD JUSTITIE    BRUSSEL',NULL,-65,'EUR','ACHAT PAR INTERNET AVEC CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC LE 05/10 18:25 FOD JUSTITIE BRUSSEL REF. :   0RMINAL0000 VAL. 05-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8823,1,'1601848800548.41','2020-10-05','666-0000004-83','',NULL,-548.41,'EUR','VISA RELEVE NUMERO 269                                 REF. : 08275A5176259 VAL. 05-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8824,1,'1601589600168.46','2020-10-02','BE50 7310 2896 8518','MONIZZE SA',NULL,-168.46,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/80521+++        REFERENCE DU CREANCIER : 008637580521                  REF. : 08196A2192527 VAL. 02-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8825,1,'160124400027.83','2020-09-28','BE61 0910 1660 5217','PROXIMUS SA',NULL,-27.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007006546730 REFERENCE DU  CREANCIER : 0005307375                                 REF. : 081969S030388 VAL. 28-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8826,1,'1600984800202.94','2020-09-25','666-0000004-83','BELFIUS',NULL,202.94,'EUR','MASTERCARD - 28157532-01/25362815753214517160','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8827,1,'1600984800439.56','2020-09-25','BE36 0912 1503 4881','SPW',NULL,-439.56,'EUR','+++011/7427/08549+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8828,1,'1600725600154.69','2020-09-22','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-154.69,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0717980406 R      B0895562 //20200918-BEDO1 REFERENCE DU CREANCIER :     I0000017045749-110407179804062020                      REF. : 081969M123628 VAL. 22-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8829,1,'1600120800775.65','2020-09-15','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-775.65,'EUR','+++480/0377/56044+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8830,1,'16001208001973.05','2020-09-15','BE80 0000 0010 4777','CAISSE D\'ASS SOCIALES UCM',NULL,-1973.05,'EUR','+++500/1621/84477+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8831,1,'1600034400793.99','2020-09-14','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-793.99,'EUR','+++165/6240/80647+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8832,1,'159977520032.36','2020-09-11','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-32.36,'EUR','+++165/6240/90852+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8833,1,'1599429600146.69','2020-09-07','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-146.69,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0717917247 R      B0871749 //20200903-BEDOP REFERENCE DU CREANCIER :     I0000016596013-110407179172472020                      REF. : 0819697577519 VAL. 07-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8834,1,'159908400082.2','2020-09-03','','LA BRASSERIE    NAMUR',NULL,-82.2,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 03/09 15:06 LA BRASSERIE NAMUR   REF. :   00283631333 VAL. 03-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8835,1,'1599084000481.28','2020-09-03','666-0000004-83','',NULL,-481.28,'EUR','VISA RELEVE NUMERO 238                                 REF. : 0827593168638 VAL. 03-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8836,1,'1598997600168.46','2020-09-02','BE50 7310 2896 8518','MONIZZE SA',NULL,-168.46,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/25048+++        REFERENCE DU CREANCIER : 008637525048                  REF. : 0819692208825 VAL. 02-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8837,1,'159899760027.83','2020-09-02','BE61 0910 1660 5217','PROXIMUS SA',NULL,-27.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007005919872 REFERENCE DU  CREANCIER : 8005295342                                 REF. : 0819692017171 VAL. 02-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8838,1,'15989112002094.21','2020-09-01','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-2094.21,'EUR','08/2020','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8839,1,'159856560038','2020-08-28','','LISMAN & GOURDAINAMUR',NULL,-38,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 28/08 13:40 LISMAN &             GOURDAINAMUR                                           REF. :   04899731392 VAL. 28-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8840,1,'159839280013545.95','2020-08-26','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,13545.95,'EUR','INVOICE WFI0019','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8841,1,'1598220000740','2020-08-24','BE62 0688 9235 4961','SYNAMIC EVENTS',NULL,-740,'EUR','ACOMPTE FREDERIC LEGARDIEN','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8842,1,'159822000018.86','2020-08-24','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-18.86,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0717864934 R      B0809294 //20200820-BEDO1 REFERENCE DU CREANCIER :     I0000016017130-110407178649342020                      REF. : 081968O167415 VAL. 24-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8843,1,'159770160040','2020-08-18','BE73 0635 5363 9760','IBRAHIM EROL',NULL,-40,'EUR','','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8844,1,'159709680028.24','2020-08-11','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-28.24,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0717826822 R      B0731635 //20200807-BEDO1 REFERENCE DU CREANCIER :     I0000015659703-110407178268222020                      REF. : 081968B056206 VAL. 11-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8845,1,'1596492000168.46','2020-08-04','BE50 7310 2896 8518','MONIZZE SA',NULL,-168.46,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/52633+++        REFERENCE DU CREANCIER : 008637552633                  REF. : 0819684214852 VAL. 04-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8846,1,'1596405600256.05','2020-08-03','666-0000004-83','',NULL,-256.05,'EUR','VISA RELEVE NUMERO 207                                 REF. : 0827583167636 VAL. 03-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8847,1,'159640560032.36','2020-08-03','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-32.36,'EUR','+++165/1200/80872+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8848,1,'1596405600793.99','2020-08-03','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-793.99,'EUR','+++165/1200/70667+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8849,1,'15964056002094.21','2020-08-03','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-2094.21,'EUR','07/2020','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8850,1,'159606000027.83','2020-07-30','BE61 0910 1660 5217','PROXIMUS SA',NULL,-27.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007005298550 REFERENCE DU  CREANCIER : 4005096305                                 REF. : 081967U016084 VAL. 30-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8851,1,'159588720040.1','2020-07-28','','BRASSE TEMPS DIFPIPAIX',NULL,-40.1,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 28/07 13:24 BRASSE TEMPS         DIFPIPAIX                                              REF. :   08132971332 VAL. 28-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8852,1,'159580080010.35','2020-07-27','','ELECTROPLUS CUYPPERWEZ',NULL,-10.35,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 25/07 11:09 ELECTROPLUS          CUYPPERWEZ                                             REF. :   07467821171 VAL. 25-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8853,1,'159536880035.56','2020-07-22','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-35.56,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0717725997 R      C0729640 //20200720-BEDO1 REFERENCE DU CREANCIER :     I0000014905635-110407177259972020                      REF. : 081967M156325 VAL. 22-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8854,1,'159536880019.77','2020-07-22','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-19.77,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0717725996 R      C0507943 //20200720-BEDO1 REFERENCE DU CREANCIER :     I0000014905634-110407177259962020                      REF. : 081967M156324 VAL. 22-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8855,1,'1595368800117.22','2020-07-22','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-117.22,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0717725995 R      B0667269 //20200720-BEDO1 REFERENCE DU CREANCIER :     I0000014905633-110407177259952020                      REF. : 081967M156323 VAL. 22-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8856,1,'15953688007016.66','2020-07-22','BE22 6792 0030 0047','TVA RECETTES',NULL,-7016.66,'EUR','+++072/8750/01371+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8857,1,'159519600072.63','2020-07-20','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-72.63,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0717656668 R      B0597710 //20200710-BEDOC REFERENCE DU CREANCIER :     I0000014713085-110407176566682020                      REF. : 081967K284957 VAL. 20-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8858,1,'159476400031.4','2020-07-15','','',NULL,-31.4,'EUR','PAIEMENT MAESTRO 14/07-JAMBES CAT\"S CORNER BE 31,40    EUR CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC  REF. : 7150040077614 VAL. 15-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8859,1,'159476400032.36','2020-07-15','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-32.36,'EUR','+++164/3057/50819+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8860,1,'1594764000793.99','2020-07-15','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-793.99,'EUR','+++164/3057/40614+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8861,1,'159433200014296.76','2020-07-10','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,14296.76,'EUR','WFI0018','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8862,1,'15942456003228.2','2020-07-09','BE82 0000 0238 3368','CAISSE WALLONNE ASSUR',NULL,3228.2,'EUR','/C/780402167 INDEMNITES DROIT PASSERELLE','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8863,1,'1593986400782.51','2020-07-06','666-0000004-83','',NULL,-782.51,'EUR','VISA RELEVE NUMERO 177                                 REF. : 0827576163187 VAL. 06-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8864,1,'15937272002094.21','2020-07-03','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-2094.21,'EUR','06/2020','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8865,1,'1593640800168.46','2020-07-02','BE50 7310 2896 8518','MONIZZE SA',NULL,-168.46,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/71932+++        REFERENCE DU CREANCIER : 008637571932                  REF. : 0819672189316 VAL. 02-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8866,1,'159312240027.83','2020-06-26','BE61 0910 1660 5217','PROXIMUS SA',NULL,-27.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007004671428 REFERENCE DU  CREANCIER : 9004833964                                 REF. : 081966Q004085 VAL. 26-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8867,1,'159303600040.2','2020-06-25','','BRASSE TEMPS DIFTOURNAI',NULL,-40.2,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 25/06 13:01 BRASSE TEMPS         DIFTOURNAI                                             REF. :   06801711386 VAL. 25-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8868,1,'159294960014510.32','2020-06-24','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,14510.32,'EUR','INVOICE WFI0017','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8869,1,'159286320011.8','2020-06-23','','DELI-FRITES WIERNAMUR',NULL,-11.8,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 23/06 12:40 DELI-    FRITES WIERNAMUR                                       REF. :   08988131278 VAL. 23-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8870,1,'15923448001973.05','2020-06-17','BE80 0000 0010 4777','CAISSE D\'ASS SOCIALES UCM',NULL,-1973.05,'EUR','+++500/1473/49440+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8871,1,'159217200021.28','2020-06-15','','TOTAL NB000917 SSPY',NULL,-21.28,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 15/06 08:51 TOTAL NB000917 SSPY  REF. :   00917520851 VAL. 15-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8872,1,'1592172000802.99','2020-06-15','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-802.99,'EUR','+++163/7268/60677+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8873,1,'159191280019.09','2020-06-12','','TOTAL NB005504 SSPY',NULL,-19.09,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 12/06 17:18 TOTAL NB005504 SSPY  REF. :   05504521717 VAL. 12-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8874,1,'15919128002677.17','2020-06-12','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-2677.17,'EUR','+++480/0377/58064+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8875,1,'1591912800485.37','2020-06-12','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-485.37,'EUR','+++480/0377/56044+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8876,1,'15917400006.1','2020-06-10','','DELI-FRITES WIERNAMUR',NULL,-6.1,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 10/06 12:36 DELI-    FRITES WIERNAMUR                                       REF. :   08988131255 VAL. 10-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8877,1,'159165360021.53','2020-06-09','','TOTAL NB005504 SSPY',NULL,-21.53,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 09/06 15:54 TOTAL NB005504 SSPY  REF. :   05504521517 VAL. 09-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8878,1,'159165360036.8','2020-06-09','','BRASSE TEMPS DIFPIPAIX',NULL,-36.8,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 09/06 13:17 BRASSE   TEMPS DIFPIPAIX                                        REF. :   09402571380 VAL. 09-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8879,1,'159165360049','2020-06-09','','',NULL,-49,'EUR','PAIEMENT MAESTRO 08/06-WIERDE DAILY BURGER BE 49,00    EUR CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC  REF. : 6090040249162 VAL. 09-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8880,1,'159156720073.62','2020-06-08','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-73.62,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0717461239 R      B0482185 //20200604-BEDO1 REFERENCE DU CREANCIER :     I0000013353764-110407174612392020                      REF. : 0819668455749 VAL. 08-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8881,1,'159156720022.39','2020-06-08','','TOTAL NB004071 CCOURRIERE',NULL,-22.39,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 06/06 15:26 TOTAL NB004071       CCOURRIERE                                             REF. :   04071511538 VAL. 06-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8882,1,'159130800053.29','2020-06-05','BE50 4354 1204 0118','DAS SA',NULL,-53.29,'EUR','+++102/0093/75040+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8883,1,'1591308000154.46','2020-06-05','BE31 4100 0007 1155','BALOISE INSURANCE',NULL,-154.46,'EUR','+++466/8175/73706+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8884,1,'1591135200168.46','2020-06-03','BE50 7310 2896 8518','MONIZZE SA',NULL,-168.46,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/99416+++        REFERENCE DU CREANCIER : 008637599416                  REF. : 0819663241153 VAL. 03-06','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8885,1,'159104880032.36','2020-06-02','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-32.36,'EUR','+++163/7268/70882+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8886,1,'15910488002087.21','2020-06-02','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-2087.21,'EUR','05/2020','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8887,1,'15910488005008.93','2020-06-02','BE22 6792 0030 0047','TVA RECETTES',NULL,-5008.93,'EUR','+++072/8750/01371+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8888,1,'159070320027.83','2020-05-29','BE61 0910 1660 5217','PROXIMUS SA',NULL,-27.83,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS SA COMMUNICATION : 007004060877 REFERENCE DU  CREANCIER : 4004795538                                 REF. : 081965T016430 VAL. 29-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8889,1,'159035760013.03','2020-05-25','','',NULL,-13.03,'EUR','PAIEMENT MAESTRO 19/05-NIVELLES ESSO EXP NIVELLES BE   13,03 EUR CARTE N 6703 0700 3436 4800 - LEGARDIEN     FREDERIC                                               REF. : 5250040217225 VAL. 25-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8890,1,'158992560013068.24','2020-05-20','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,13068.24,'EUR','INVOLCE WFI00016 + SOLDE DE 0.24 E UROS WFI0015','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8891,1,'158983920016000','2020-05-19','BE90 2500 3176 2232','HERPIGNY MOTORS SA',NULL,-16000,'EUR','BMW R1200GS LEGARDIEN FREDERIC WEFEATIT SRL','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8892,1,'1589839200900','2020-05-19','','HERPIGNY-MOTORS COGNELEE',NULL,-900,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 19/05 16:22 HERPIGNY-MOTORS      COGNELEE                                               REF. :   08994961645 VAL. 19-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8893,1,'1589493600127.48','2020-05-15','BE18 1440 5211 6665','BERNARD PUISSANT SC',NULL,-127.48,'EUR','03/000099605185 01/07/201997509','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8894,1,'1589320800793.99','2020-05-13','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-793.99,'EUR','+++163/2511/00636+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8895,1,'158932080032.36','2020-05-13','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-32.36,'EUR','+++163/2511/10841+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8896,1,'15888888002094.21','2020-05-08','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-2094.21,'EUR','04/2020','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8897,1,'15888024003.03','2020-05-07','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-3.03,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0717366838 R      B0392146 //20200505-BEDO1 REFERENCE DU CREANCIER :     I0000012450129-110407173668382020                      REF. : 0819657350096 VAL. 07-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8898,1,'1588629600168.46','2020-05-05','BE50 7310 2896 8518','MONIZZE SA',NULL,-168.46,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/88807+++        REFERENCE DU CREANCIER : 008637588807                  REF. : 0819655571890 VAL. 05-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8899,1,'158854320062.47','2020-05-04','666-0000004-83','',NULL,-62.47,'EUR','VISA RELEVE NUMERO 116                                 REF. : 0827554140844 VAL. 04-05','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8900,1,'158742000031.08','2020-04-21','BE61 0910 1660 5217','PROXIMUS S A',NULL,-31.08,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS S A COMMUNICATION : 007003419190 REFERENCE DU CREANCIER : 6004609589                                 REF. : 081964L018983 VAL. 21-04','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8901,1,'158681520014952.58','2020-04-14','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,14952.58,'EUR','FACTURE WFI0015','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8902,1,'158621040068.85','2020-04-07','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-68.85,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0717277088 R      B0328527 //20200403-BEDO1 REFERENCE DU CREANCIER :     I0000011628379-110407172770882020                      REF. : 0819647380336 VAL. 07-04','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8903,1,'158586480015','2020-04-03','666-0000004-83','',NULL,-15,'EUR','MASTERCARD RELEVE NUMERO 085                           REF. : 0827543115475 VAL. 03-04','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8904,1,'1585778400168.46','2020-04-02','BE50 7310 2896 8518','MONIZZE SA',NULL,-168.46,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/69912+++        REFERENCE DU CREANCIER : 008637569912                  REF. : 0819642145074 VAL. 02-04','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8905,1,'158569200032.36','2020-04-01','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-32.36,'EUR','+++162/5397/20824+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8906,1,'1585692000800.99','2020-04-01','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-800.99,'EUR','+++162/5397/10619+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8907,1,'15856920002087.21','2020-04-01','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-2087.21,'EUR','03/2020','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8908,1,'1585692000775.65','2020-04-01','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-775.65,'EUR','+++480/0377/56044+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8909,1,'1585692000485.37','2020-04-01','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-485.37,'EUR','+++480/0377/56044+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8910,1,'158551920095.59','2020-03-30','BE84 0689 3590 7759','OPENFLOW',NULL,95.59,'EUR','WFI0014','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8911,1,'158526360029.33','2020-03-27','BE61 0910 1660 5217','PROXIMUS S A',NULL,-29.33,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS S A COMMUNICATION : 007002804651 REFERENCE DU CREANCIER : 3004509844                                 REF. : 081963R015050 VAL. 27-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8912,1,'1585177200746.23','2020-03-26','BE82 0000 0238 3368','CAISSE WALLONNE ASSUR',NULL,746.23,'EUR','780402167 - 2020/1 DEJA PAYEE LE 21/02','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8913,1,'1585177200290.28','2020-03-26','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-290.28,'EUR','+++480/0377/56044+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8914,1,'158491800085.05','2020-03-23','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-85.05,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0717218365 R      B0265948 //20200319-BEDO1 REFERENCE DU CREANCIER :     I0000011089661-110407172183652020                      REF. : 081963N163592 VAL. 23-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8915,1,'15849180002049.88','2020-03-23','BE82 0000 0238 3368','CAISSE WALLONNE ASSUR',NULL,2049.88,'EUR','780402167 DOUBLE PAIEMENT S/COTI 2019/4 PAYEE LE 21/02/2020','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8916,1,'1584658800746.23','2020-03-20','BE80 0000 0010 4777','CAISSE D\'ASS SOCIALES UCM',NULL,-746.23,'EUR','+++500/1306/44121+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8917,1,'158431320060','2020-03-16','','',NULL,-60,'EUR','PAIEMENT MAESTRO 13/03-WIERDE DAILY BURGER BE 60,00    EUR CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC  REF. : 3160040550225 VAL. 16-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8918,1,'15843132002049.88','2020-03-16','BE80 0000 0010 4777','CAISSE D\'ASS SOCIALES UCM',NULL,-2049.88,'EUR','+++500/1145/88496+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8919,1,'158405400099','2020-03-13','','MUST DE LIPAJOU BOUGE',NULL,-99,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 13/03 09:41 MUST DE LIPAJOU      BOUGE                                                  REF. :   05322990011 VAL. 13-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8920,1,'158396760029228.76','2020-03-12','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,29228.76,'EUR','WFI0010+WFI0013','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8921,1,'158388120032.36','2020-03-11','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-32.36,'EUR','+++000/5030/24115+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8922,1,'1583881200802.53','2020-03-11','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-802.53,'EUR','+++000/5030/24115+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8923,1,'158370840091.46','2020-03-09','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-91.46,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0717162178 R      B0209942 //20200305-BEDO1 REFERENCE DU CREANCIER :     I0000010600027-110407171621782020                      REF. : 0819639364096 VAL. 09-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8924,1,'158370840033.8','2020-03-09','','BRASSE TEMPS DIFPIPAIX',NULL,-33.8,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 09/03 13:03 BRASSE TEMPS         DIFPIPAIX                                              REF. :   09402571376 VAL. 09-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8925,1,'1583362800123.83','2020-03-05','666-0000004-83','',NULL,-123.83,'EUR','MASTERCARD RELEVE NUMERO 056                           REF. : 0827535122835 VAL. 05-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8926,1,'158336280032.36','2020-03-05','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-32.36,'EUR','+++161/9555/90864+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8927,1,'1583362800793.99','2020-03-05','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-793.99,'EUR','+++161/9555/80659+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8928,1,'15833628002094.21','2020-03-05','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-2094.21,'EUR','02/2020','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8929,1,'158327640038','2020-03-04','','CHEZ ALFIO  SPRLNIVELLES',NULL,-38,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 04/03 13:24 CHEZ ALFIO           SPRLNIVELLES                                           REF. :   00197241368 VAL. 04-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8930,1,'1583190000168.46','2020-03-03','BE50 7310 2896 8518','MONIZZE SA',NULL,-168.46,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/57077+++        REFERENCE DU CREANCIER : 008637557077                  REF. : 0819633223709 VAL. 03-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8931,1,'158310360029.23','2020-03-02','BE61 0910 1660 5217','PROXIMUS S A',NULL,-29.23,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS S A COMMUNICATION : 007002177155 REFERENCE DU CREANCIER : 4004384357                                 REF. : 0819632034488 VAL. 02-03','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8932,1,'1583103600124.63','2020-03-02','BE84 0689 3590 7759','OPENFLOW',NULL,124.63,'EUR','FACTURE WFI0011','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8933,1,'158310360087.12','2020-03-02','BE84 0689 3590 7759','OPENFLOW',NULL,87.12,'EUR','FACTURE WFI0012','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8934,1,'158267160084.48','2020-02-26','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-84.48,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0717117921 R      B0205942 //20200224-BEDO1 REFERENCE DU CREANCIER :     I0000010157655-110407171179212020                      REF. : 081962Q123820 VAL. 26-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8935,1,'158223960032.59','2020-02-21','','LUNCH GARDEN 288JAMBES',NULL,-32.59,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 21/02 12:18 LUNCH GARDEN         288JAMBES                                              REF. :   09396541285 VAL. 21-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8936,1,'15821532002711.47','2020-02-20','BE80 0000 0010 4777','CAISSE D\'ASS SOCIALES UCM',NULL,-2711.47,'EUR','+++500/1373/83597+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8937,1,'15821532001311.46','2020-02-20','BE80 0000 0010 4777','CAISSE D\'ASS SOCIALES UCM',NULL,-1311.46,'EUR','780402167 - COMPLEMENT 4T2019','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8938,1,'158154840041.12','2020-02-13','BE52 0639 8979 5109','WENIN OLIVIER',NULL,-41.12,'EUR','REMBOURSEMENT TICKET  37029','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8939,1,'15814620002087.21','2020-02-12','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-2087.21,'EUR','01/2020','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8940,1,'1581462000200','2020-02-12','001-2235316-27','BANKSYS',NULL,200,'EUR','ARGENT RECU VIA VOTRE APP MOBILE BANKING OU VOTRE      BANCONTACT-APP LE 11/02 SUR VOTRE CARTE BANCAIRE.      REF. : 082552C172200 VAL. 12-02','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8941,1,'1581375600200','2020-02-11','','THIERRY         P2P MOBILE',NULL,-200,'EUR','PAIEMENT VIA VOTRE APP MOBILE BANKING OU VOTRE         BANCONTACT-APP A THIERRY P2P MOBILE LE 11/02 A 15:26   AVEC VOTRE CARTE BANCAIRE 6703 0700 3436 4800          REF. : 6664036926858 VAL. 11-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8942,1,'1581289200127.05','2020-02-10','BE14 0689 3381 4983','CABINET COMPTABLE BARBARA LAURENT',NULL,-127.05,'EUR','2020/023','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8943,1,'1581030000175.61','2020-02-07','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-175.61,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0717028392 R      B0124258 //20200205-BEDO1 REFERENCE DU CREANCIER :     I0000009555353-110407170283922020                      REF. : 0819627363300 VAL. 07-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8944,1,'1580770800168.46','2020-02-04','BE50 7310 2896 8518','MONIZZE SA',NULL,-168.46,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/64050+++        REFERENCE DU CREANCIER : 008637564050                  REF. : 0819624269890 VAL. 04-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8945,1,'1580684400130.62','2020-02-03','666-0000004-83','',NULL,-130.62,'EUR','MASTERCARD RELEVE NUMERO 025                           REF. : 0827523121158 VAL. 03-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8946,1,'158068440055.5','2020-02-03','','',NULL,-55.5,'EUR','PAIEMENT MAESTRO 31/01-JAMBES CAT\"S CORNER BE 55,50    EUR CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC  REF. : 2030040672956 VAL. 03-02','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8947,1,'158025240014577.48','2020-01-29','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,14577.48,'EUR','INVOICE WFI0009','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8948,1,'158007960028.33','2020-01-27','BE61 0910 1660 5217','PROXIMUS S A',NULL,-28.33,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS S A COMMUNICATION : 007001540174 REFERENCE DU CREANCIER : 3004224462                                 REF. : 081961R018834 VAL. 27-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8949,1,'1579647600174.53','2020-01-22','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-174.53,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0716966803 R      B0095494 //20200120-BEDO1 REFERENCE DU CREANCIER :     I0000008935543-110407169668032020                      REF. : 081961M090047 VAL. 22-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8950,1,'157956120046.9','2020-01-21','','LE 830 SPRL     WEPION',NULL,-46.9,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 21/01 13:58 LE 830 SPRL WEPION   REF. :   08827431383 VAL. 21-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8951,1,'15792156007418.98','2020-01-17','BE22 6792 0030 0047','TVA RECETTES',NULL,-7418.98,'EUR','+++072/8750/01371+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8952,1,'15791292002677.17','2020-01-16','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-2677.17,'EUR','+++480/0377/58064+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8953,1,'1578956400290.28','2020-01-14','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-290.28,'EUR','+++480/0377/56044+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8954,1,'157887000038.3','2020-01-13','','BRASSE TEMPS DIFPIPAIX',NULL,-38.3,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 13/01 13:41 BRASSE TEMPS         DIFPIPAIX                                              REF. :   08132261346 VAL. 13-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8955,1,'15785244003','2020-01-09','','',NULL,-3,'EUR','FRAIS PAIEMENTS URGENTS                                REF. : 0816416054293 VAL. 01-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8956,1,'15785244006.05','2020-01-09','','',NULL,-6.05,'EUR','FRAIS CHEQUES                                          REF. : 0816416027211 VAL. 01-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8957,1,'1578351600175.97','2020-01-07','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-175.97,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0716901663 R      B0019034 //20200103-BEDO1 REFERENCE DU CREANCIER :     I0000008403639-110407169016632020                      REF. : 0819617317501 VAL. 07-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8958,1,'1578265200403.8','2020-01-06','','TERRASSES DE L\'EARBRE (NAM',NULL,-403.8,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 04/01 23:36 TERRASSES DE         L\'EARBRE (NAM                                          REF. :   01331122373 VAL. 04-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8959,1,'157826520032.36','2020-01-06','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-32.36,'EUR','+++160/6964/20831+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8960,1,'1578265200802.5','2020-01-06','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-802.5,'EUR','+++160/6964/10626+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8961,1,'15782652002045.7','2020-01-06','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-2045.7,'EUR','12/2019','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8962,1,'1578006000168.46','2020-01-03','BE50 7310 2896 8518','MONIZZE SA',NULL,-168.46,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/25149+++        REFERENCE DU CREANCIER : 008637525149                  REF. : 0819613229766 VAL. 03-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8963,1,'1578006000193.75','2020-01-03','666-0000004-83','',NULL,-193.75,'EUR','MASTERCARD RELEVE NUMERO 359                           REF. : 0827513121763 VAL. 03-01','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8964,1,'15777468001940.54','2019-12-31','BE31 4100 0007 1155','BALOISE INSURANCE',NULL,-1940.54,'EUR','+++461/6317/68291+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8965,1,'157766040030.9','2019-12-30','BE61 0910 1660 5217','PROXIMUS S A',NULL,-30.9,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS S A COMMUNICATION : 006908542418 REFERENCE DU CREANCIER : 7004013965                                 REF. : 08196CU050604 VAL. 30-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8966,1,'157705560086.79','2019-12-23','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-86.79,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0716842897 R      B9B70396 //20191219-BEDO1 REFERENCE DU CREANCIER :     I0000007924603-110407168428972019                      REF. : 08196CN212507 VAL. 23-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8967,1,'157705560093','2019-12-23','BE50 4354 1204 0118','DAS SA',NULL,-93,'EUR','+++102/0093/75040+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8968,1,'1577055600273.12','2019-12-23','BE10 5502 7681 0004','AG INSURANCE',NULL,-273.12,'EUR','+++192/4484/50341+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8969,1,'157679640013660.9','2019-12-20','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,13660.9,'EUR','WFI0007','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8970,1,'15767964002049.88','2019-12-20','BE80 0000 0010 4777','CAISSE D\'ASS SOCIALES UCM',NULL,-2049.88,'EUR','+++500/1011/08025+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8971,1,'1576450800270.57','2019-12-16','BE50 7310 2896 8518','MONIZZE SA',NULL,-270.57,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/80824+++        REFERENCE DU CREANCIER : 008637580824                  REF. : 08196CG311030 VAL. 16-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8972,1,'1576450800140.57','2019-12-16','BE50 7310 2896 8518','MONIZZE SA',NULL,-140.57,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/80723+++        REFERENCE DU CREANCIER : 008637580723                  REF. : 08196CG311025 VAL. 16-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8973,1,'1576450800104.46','2019-12-16','BE50 7310 2896 8518','MONIZZE SA',NULL,-104.46,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/80521+++        REFERENCE DU CREANCIER : 008637580521                  REF. : 08196CG310323 VAL. 16-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8974,1,'157645080030.7','2019-12-16','','BRASSE TEMPS DIFPIPAIX',NULL,-30.7,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 16/12 13:06 BRASSE TEMPS         DIFPIPAIX                                              REF. :   09402571322 VAL. 16-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8975,1,'157619160028.08','2019-12-13','','LUNCH GARDEN 200   NIVELLE',NULL,-28.08,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 13/12 13:00 LUNCH GARDEN 200     NIVELLE                                                REF. :   09395791360 VAL. 13-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8976,1,'157619160032.36','2019-12-13','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-32.36,'EUR','+++159/9744/20832+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8977,1,'1576191600802.5','2019-12-13','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-802.5,'EUR','','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8978,1,'1576018800168.46','2019-12-11','BE50 7310 2896 8518','MONIZZE SA',NULL,-168.46,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/52532+++        REFERENCE DU CREANCIER : 008637552532                  REF. : 08196CB164383 VAL. 11-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8979,1,'1576018800648.46','2019-12-11','BE50 7310 2896 8518','MONIZZE SA',NULL,-648.46,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/53037+++        REFERENCE DU CREANCIER : 008637553037                  REF. : 08196CB164382 VAL. 11-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8980,1,'1576018800185.66','2019-12-11','BE62 2100 4700 7161','TOTAL BELGIUM',NULL,-185.66,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTAL BELGIUM COMMUNICATION : I 0716813200 R      B9B34478 //20191206-BEDO1 REFERENCE DU CREANCIER :     I0000007551830-110407168132002019                      REF. : 08196CB048722 VAL. 11-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8981,1,'157584600011960.85','2019-12-09','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,11960.85,'EUR','WFI0005','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8982,1,'1575414000124.2','2019-12-04','666-0000004-83','',NULL,-124.2,'EUR','MASTERCARD RELEVE NUMERO 329                           REF. : 08275C4119124 VAL. 04-12','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8983,1,'15753276002045.7','2019-12-03','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-2045.7,'EUR','11/2019','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8984,1,'157524120037.5','2019-12-02','','DALUCI SA       BRUXELLES',NULL,-37.5,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 29/11 20:17 DALUCI SA BRUXELLES  REF. :   08042942034 VAL. 29-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8985,1,'157498200039.72','2019-11-29','BE61 0910 1660 5217','PROXIMUS S A',NULL,-39.72,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS S A COMMUNICATION : 006907850711 REFERENCE DU CREANCIER : 7003872459                                 REF. : 08196BT034431 VAL. 29-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8986,1,'157489560032.06','2019-11-28','','LUNCH GARDEN 633BIERGES',NULL,-32.06,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 28/11 12:40 LUNCH GARDEN         633BIERGES                                             REF. :   08878041275 VAL. 28-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8987,1,'1574722800100','2019-11-26','BE28 0689 3562 2520','NEWB SCE',NULL,-100,'EUR','+++100/0032/17909+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8988,1,'157437720079','2019-11-22','BE62 2100 4700 7161','TOTALFINA BELGIUM',NULL,-79,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALFINA BELGIUM COMMUNICATION : I 0716722870 R  B9A64549 //20191120-BEDO1 REFERENCE DU CREANCIER :     150483004-110407167228702019                           REF. : 08196BM022826 VAL. 22-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8989,1,'157437720034.6','2019-11-22','','BRASSE TEMPS DIFPIPAIX',NULL,-34.6,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 22/11 13:09 BRASSE TEMPS         DIFPIPAIX                                              REF. :   09402571391 VAL. 22-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8990,1,'1574377200290.28','2019-11-22','BE13 2100 0007 6339','AG INSURANCE SA',NULL,290.28,'EUR','69/12020281  REMBOURSEMENT','IN',NULL,NULL,NULL,NULL,NULL,NULL),(8991,1,'15740316001829.13','2019-11-18','BE22 6792 0030 0047','TVA RECETTES',NULL,-1829.13,'EUR','+++072/8750/01371+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8992,1,'1574031600381.15','2019-11-18','BE14 0689 3381 4983','CABINET COMPTABLE BARBARA LAURENT',NULL,-381.15,'EUR','2019/160','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8993,1,'1573167600290','2019-11-08','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-290,'EUR','+++480/0377/56044+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8994,1,'1573081200173.06','2019-11-07','BE62 2100 4700 7161','TOTALFINA BELGIUM',NULL,-173.06,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALFINA BELGIUM COMMUNICATION : I 0716650495 R  B9A61228 //20191105-BEDO1 REFERENCE DU CREANCIER :     150311890-110407166504952019                           REF. : 08196B7236100 VAL. 07-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8995,1,'1572908400216.86','2019-11-05','BE50 7310 2896 8518','MONIZZE SA',NULL,-216.86,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/18580+++        REFERENCE DU CREANCIER : 008637518580                  REF. : 08196B5466428 VAL. 05-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8996,1,'157290840051.87','2019-11-05','666-0000004-83','',NULL,-51.87,'EUR','MASTERCARD RELEVE NUMERO 298                           REF. : 08275B5123513 VAL. 05-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8997,1,'157282200034.9','2019-11-04','','TAVERNE 44 SPRL MONS',NULL,-34.9,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 04/11 13:29 TAVERNE 44 SPRL MONS REF. :   07303731373 VAL. 04-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8998,1,'1572822000802.5','2019-11-04','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-802.5,'EUR','+++159/3297/00632+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(8999,1,'157282200032.36','2019-11-04','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-32.36,'EUR','+++159/3297/10837+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9000,1,'15728220002045.7','2019-11-04','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-2045.7,'EUR','10/2019','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9001,1,'157282200011.98','2019-11-04','BE39 7310 2435 1419','MONIZZE SA',NULL,-11.98,'EUR','VOTRE DOMICILIATION EUROPEENNE B2B EMVF6983315944 POUR MONIZZE SA COMMUNICATION : +++008/6375/24543+++        REFERENCE DU CREANCIER : 008637524543                  REF. : 08196B1161653 VAL. 01-11','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9002,1,'157247640041.22','2019-10-31','BE61 0910 1660 5217','PROXIMUS S A',NULL,-41.22,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS S A COMMUNICATION : 006907196909 REFERENCE DU CREANCIER : 7003736666                                 REF. : 08196AV018732 VAL. 31-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9003,1,'157230360014777.13','2019-10-29','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,14777.13,'EUR','WFI0004','IN',NULL,NULL,NULL,NULL,NULL,NULL),(9004,1,'157230360029.99','2019-10-29','','MEDIA MARKT GOSSGOSSELIES',NULL,-29.99,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 29/10 16:52 MEDIA MARKT          GOSSGOSSELIES                                          REF. :   09223951625 VAL. 29-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9005,1,'157178160052.03','2019-10-23','BE72 7512 0369 7616','ESCHOLLE DES PAUVRES',NULL,52.03,'EUR','+++000/0002/36537+++','IN',NULL,NULL,NULL,NULL,NULL,NULL),(9006,1,'157160880032.7','2019-10-21','','TAVERNE 44 SPRL MONS',NULL,-32.7,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 21/10 13:27 TAVERNE 44 SPRL MONS REF. :   07303731381 VAL. 21-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9007,1,'15716088001829.13','2019-10-21','BE22 6792 0030 0047','TVA RECETTES',NULL,-1829.13,'EUR','+++072/8750/01371+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9008,1,'157117680097.07','2019-10-16','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-97.07,'EUR','+++158/9589/30862+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9009,1,'1571176800802.5','2019-10-16','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-802.5,'EUR','+++158/9589/20657+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9010,1,'1571176800802.5','2019-10-16','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-802.5,'EUR','+++158/9589/10654+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9011,1,'15711768002045.7','2019-10-16','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-2045.7,'EUR','08/2019','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9012,1,'15711768002045.7','2019-10-16','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-2045.7,'EUR','09/2019','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9013,1,'15711768002045.7','2019-10-16','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-2045.7,'EUR','07/2019','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9014,1,'1571176800802.5','2019-10-16','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-802.5,'EUR','+++158/9589/00651+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9015,1,'1570399200175.93','2019-10-07','BE62 2100 4700 7161','TOTALFINA BELGIUM',NULL,-175.93,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALFINA BELGIUM COMMUNICATION : I 0716525384 R  B9909923 //20191003-BEDO1 REFERENCE DU CREANCIER :     149954313-110407165253842019                           REF. : 08196A7712869 VAL. 07-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9016,1,'1570140000304.91','2019-10-04','666-0000004-83','',NULL,-304.91,'EUR','MASTERCARD RELEVE NUMERO 268                           REF. : 08275A4117701 VAL. 04-10','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9017,1,'156979440039.06','2019-09-30','BE61 0910 1660 5217','PROXIMUS S A',NULL,-39.06,'EUR','VOTRE DOMICILIATION EUROPEENNE B010882887 POUR         PROXIMUS S A COMMUNICATION : 006906545849 REFERENCE DU CREANCIER : 6003670192                                 REF. : 081969U011376 VAL. 30-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9018,1,'156979440096.8','2019-09-30','BE90 0682 5096 8632','UCM',NULL,-96.8,'EUR','+++158/5925/70855+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9019,1,'156979440043.32','2019-09-30','BE90 0682 5096 8632','SECRETARIAT SOCIAL UCM',NULL,-43.32,'EUR','+++158/5868/00870+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9020,1,'156953520053','2019-09-27','','LE 830 SPRL     NAMUR',NULL,-53,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 27/09 14:37 LE 830 SPRL NAMUR    REF. :   07649631490 VAL. 27-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9021,1,'156927600037','2019-09-24','','TAVERNE 44 SPRL MONS',NULL,-37,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 24/09 13:27 TAVERNE 44 SPRL MONS REF. :   07303731328 VAL. 24-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9022,1,'156918960074.54','2019-09-23','BE62 2100 4700 7161','TOTALFINA BELGIUM',NULL,-74.54,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALFINA BELGIUM COMMUNICATION : I 0716471149 R  B9857681 //20190919-BEDO1 REFERENCE DU CREANCIER :     149809602-110407164711492019                           REF. : 081969N178464 VAL. 23-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9023,1,'1568930400309','2019-09-20','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,-309,'EUR','REMBOURSEMENT RESTAURANT','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9024,1,'15682392002169.53','2019-09-12','BE32 7320 3012 3302','RHCN',NULL,-2169.53,'EUR','SP000317','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9025,1,'15682392001217.75','2019-09-12','BE36 0912 1503 4881','SPW',NULL,-1217.75,'EUR','+++011/4649/77442+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9026,1,'1568239200290.28','2019-09-12','BE93 1421 2102 1467','AG INSURANCE SA',NULL,-290.28,'EUR','','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9027,1,'156823920024384.53','2019-09-12','BE61 3630 8285 5117','INTERGRAPH BELGIUM SA',NULL,24384.53,'EUR','WFI006 + WFI007','IN',NULL,NULL,NULL,NULL,NULL,NULL),(9028,1,'1567980000183.81','2019-09-09','BE62 2100 4700 7161','TOTALFINA BELGIUM',NULL,-183.81,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALFINA BELGIUM COMMUNICATION : I 0716401112 R  B9840791 //20190905-BEDO1 REFERENCE DU CREANCIER :     149599827-110407164011122019                           REF. : 0819699330852 VAL. 09-09','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9029,1,'156677040031','2019-08-26','','',NULL,-31,'EUR','PAIEMENT MAESTRO 23/08-WIERDE MAKI\'M SUSHI BAR BE      31,00 EUR CARTE N 6703 0700 3436 4800 - LEGARDIEN     FREDERIC                                               REF. : 8260040139972 VAL. 26-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9030,1,'156625200038.72','2019-08-20','BE61 0910 1660 5217','PROXIMUS',NULL,-38.72,'EUR','+++690/5897/04688+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9031,1,'156512880081.93','2019-08-07','BE62 2100 4700 7161','TOTALFINA BELGIUM',NULL,-81.93,'EUR','VOTRE DOMICILIATION EUROPEENNE BE1104CORCFR00004061    POUR TOTALFINA BELGIUM COMMUNICATION : I 0716275491 R  B9746830 //20190805-BEDO1 REFERENCE DU CREANCIER :     149128902-110407162754912019                           REF. : 0819687266046 VAL. 07-08','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9032,1,'156469680052.71','2019-08-02','BE31 4100 0007 1155','BALOISE BELGIUM NV',NULL,52.71,'EUR','519/50010 310719 V/REF 5L57291 B','IN',NULL,NULL,NULL,NULL,NULL,NULL),(9033,1,'1564524000365.42','2019-07-31','BE06 0634 2358 8022','LEGARDIEN PIERRE',NULL,365.42,'EUR','+++000/0006/04026+++','IN',NULL,NULL,NULL,NULL,NULL,NULL),(9034,1,'156400560034.97','2019-07-25','BE61 0910 1660 5217','PROXIMUS',NULL,-34.97,'EUR','+++690/5247/41566+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9035,1,'156374640020','2019-07-22','','',NULL,-20,'EUR','PAIEMENT MAESTRO 19/07-JAMBES CAT\"S CORNER BE 20,00    EUR CARTE N 6703 0700 3436 4800 - LEGARDIEN FREDERIC  REF. : 7220040366662 VAL. 22-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9036,1,'156348720099','2019-07-19','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,99,'EUR','FACTURE 18336645659 MS OFFICE','IN',NULL,NULL,NULL,NULL,NULL,NULL),(9037,1,'1563487200363.99','2019-07-19','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,363.99,'EUR','AVANCE FACTURE 60369369 MEDIA MARKT','IN',NULL,NULL,NULL,NULL,NULL,NULL),(9038,1,'1563487200700','2019-07-19','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,700,'EUR','AVANCE SHIFTECH','IN',NULL,NULL,NULL,NULL,NULL,NULL),(9039,1,'1563400800363.99','2019-07-18','','MEDIA MARKT GOSSGOSSELIES',NULL,-363.99,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 18/07 16:51 MEDIA MARKT          GOSSGOSSELIES                                          REF. :   09223991654 VAL. 18-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9040,1,'1563400800700','2019-07-18','','',NULL,-700,'EUR','PAIEMENT MAESTRO 17/07-PERWEZ SHIFTECH ENGINEERING BE  700,00 EUR CARTE N 6703 0700 3436 4800 - LEGARDIEN    FREDERIC                                               REF. : 7180040305346 VAL. 18-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9041,1,'15633144002.2','2019-07-17','','PARKING BEFFROI NAMUR',NULL,-2.2,'EUR','ACHAT BANCONTACT CONTACTLESS AVEC CARTE N 6703 0700   3436 4800 - LEGARDIEN FREDERIC LE 17/07 17:12 PARKING  BEFFROI NAMUR                                          REF. :   04015201720 VAL. 17-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9042,1,'156314160030','2019-07-15','','TOTAL NB000823 BBOUGE',NULL,-30,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 13/07 11:39 TOTAL NB000823       BBOUGE                                                 REF. :   00823011152 VAL. 13-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9043,1,'156288240081.12','2019-07-12','','TOTAL NB000823 BBOUGE',NULL,-81.12,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 11/07 17:43 TOTAL NB000823       BBOUGE                                                 REF. :   00823511741 VAL. 11-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9044,1,'156270960035990','2019-07-10','','',NULL,-35990,'EUR','REDACTION DU CHEQUE BANCAIRE N 449704                 REF. : 05014697A4010 VAL. 10-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9045,1,'1562709600136.56','2019-07-10','BE18 1440 5211 6665','BERNARD PUISSANT SC',NULL,-136.56,'EUR','03/000099605185 01/07/2019 97509','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9046,1,'156253680029.38','2019-07-08','','TOTAL NB000823 BBOUGE',NULL,-29.38,'EUR','ACHAT BANCONTACT AVEC CARTE N 6703 0700 3436 4800 -   LEGARDIEN FREDERIC LE 05/07 18:35 TOTAL NB000823       BBOUGE                                                 REF. :   00823521870 VAL. 05-07','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9047,1,'156219120049.11','2019-07-04','BE50 4354 1204 0118','DAS SA',NULL,-49.11,'EUR','+++102/0093/75040+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9048,1,'1562191200986.45','2019-07-04','BE31 4100 0007 1155','BALOISE INSURANCE',NULL,-986.45,'EUR','+++454/9755/92424+++','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9049,1,'1562191200986.45','2019-07-04','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,986.45,'EUR','ASSURANCE VOITURE','IN',NULL,NULL,NULL,NULL,NULL,NULL),(9050,NULL,'1561672800514.88','2019-06-28','BE47 0631 8171 4680','SPRL FRA DA RIC DUCHATEAU',NULL,-514.88,'EUR','FACTURE 19/0122','OUT',NULL,NULL,NULL,NULL,NULL,NULL),(9051,NULL,'156158640035990','2019-06-27','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,35990,'EUR','ACHAT VOITURE','IN',NULL,NULL,NULL,NULL,NULL,NULL),(9052,NULL,'15603768002000','2019-06-13','BE58 0638 7508 0279','LEGARDIEN FREDERIC',NULL,2000,'EUR','CONSTITUTION SRL','IN',NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `bank_statement_entry_line`
--

CREATE TABLE `bank_statement_entry_line` (
  `bank_statement_id` int NOT NULL,
  `journal_entry_line_id` int NOT NULL,
  PRIMARY KEY (`bank_statement_id`,`journal_entry_line_id`),
  KEY `IDX_453E189944045140` (`bank_statement_id`),
  KEY `IDX_453E1899872D4A67` (`journal_entry_line_id`),
  CONSTRAINT `FK_453E189944045140` FOREIGN KEY (`bank_statement_id`) REFERENCES `bank_statement` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_453E1899872D4A67` FOREIGN KEY (`journal_entry_line_id`) REFERENCES `journal_entry_lines` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bank_statement_entry_line`
--


--
-- Table structure for table `chart_of_accounts`
--

CREATE TABLE `chart_of_accounts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_account_id` int DEFAULT NULL,
  `account_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `account_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_system_account` tinyint(1) NOT NULL,
  `balance` decimal(15,2) DEFAULT NULL,
  `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
  `updated_at` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_7A700CD8DC28DBEA` (`parent_account_id`),
  CONSTRAINT `FK_7A700CD8DC28DBEA` FOREIGN KEY (`parent_account_id`) REFERENCES `chart_of_accounts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `chart_of_accounts`
--

INSERT INTO `chart_of_accounts` VALUES (1,NULL,'1','Capitaux propres et dettes à long terme',1,'Equity',1,0.00,'2025-06-04 13:43:47',NULL,'Equity'),(2,NULL,'2','Immobilisations',1,'Asset',1,0.00,'2025-06-04 13:43:47',NULL,'Asset'),(3,NULL,'3','Stocks et commandes en cours',1,'Asset',1,0.00,'2025-06-04 13:43:47',NULL,'Asset'),(4,NULL,'4','Comptes de tiers',1,'Mixed',1,0.00,'2025-06-04 13:43:47',NULL,'Mixed'),(5,NULL,'5','Comptes financiers',1,'Asset',1,0.00,'2025-06-04 13:43:47',NULL,'Asset'),(6,NULL,'6','Charges',1,'Expense',1,0.00,'2025-06-04 13:43:47',NULL,'Expense'),(7,NULL,'7','Produits',1,'Revenue',1,0.00,'2025-06-04 13:43:47',NULL,'Revenue'),(8,1,'100000','Capital souscrit',1,'Equity',0,0.00,'2025-06-04 13:43:47',NULL,'Equity'),(9,1,'101000','Primes d’émission',1,'Equity',0,0.00,'2025-06-04 13:43:47',NULL,'Equity'),(10,1,'133000','Réserves immunisées',1,'Equity',0,0.00,'2025-06-04 13:43:47',NULL,'Equity'),(11,1,'133100','Réserve légale',1,'Equity',0,0.00,'2025-06-04 13:43:47',NULL,'Equity'),(12,1,'140000','Résultat reporté',1,'Equity',0,0.00,'2025-06-04 13:43:47',NULL,'Equity'),(13,1,'160000','Emprunts à plus d’un an',1,'Liability',0,0.00,'2025-06-04 13:43:47',NULL,'Liability'),(14,1,'170000','Dettes de plus d’un an échéant dans l’année',1,'Liability',0,0.00,'2025-06-04 13:43:47',NULL,'Liability'),(15,2,'200000','Frais d’établissement',1,'Asset',0,0.00,'2025-06-04 13:43:47',NULL,'Asset'),(16,2,'210000','Immobilisations incorporelles',1,'Asset',0,0.00,'2025-06-04 13:43:47',NULL,'Asset'),(17,2,'220000','Immobilisations corporelles',1,'Asset',0,0.00,'2025-06-04 13:43:47',NULL,'Asset'),(18,2,'240000','Immobilisations financières',1,'Asset',0,0.00,'2025-06-04 13:43:47',NULL,'Asset'),(19,2,'280000','Amortissements actés',1,'Contra Asset',0,0.00,'2025-06-04 13:43:47',NULL,'Contra Asset'),(20,2,'290000','Réductions de valeur',1,'Contra Asset',0,0.00,'2025-06-04 13:43:47',NULL,'Contra Asset'),(21,4,'400000','Clients',1,'Asset',0,0.00,'2025-06-04 13:43:47',NULL,'Asset'),(22,4,'440000','Fournisseurs',1,'Liability',0,0.00,'2025-06-04 13:43:47',NULL,'Liability'),(23,4,'450000','Impôts sur le résultat estimés',1,'Liability',0,0.00,'2025-06-04 13:43:47',NULL,'Liability'),(24,4,'451000','TVA à payer',1,'Liability',0,0.00,'2025-06-04 13:43:47',NULL,'Liability'),(25,4,'451100','TVA due sur achats CEE',1,'Liability',0,0.00,'2025-06-04 13:43:47',NULL,'Liability'),(26,4,'451200','Compte courant administration TVA',1,'Liability',0,0.00,'2025-06-04 13:43:47',NULL,'Liability'),(27,4,'452000','Impôts sur le résultat à payer',1,'Liability',0,0.00,'2025-06-04 13:43:47',NULL,'Liability'),(28,4,'453000','Précomptes retenus',1,'Liability',0,0.00,'2025-06-04 13:43:47',NULL,'Liability'),(29,4,'411000','TVA déductible',1,'Asset',0,0.00,'2025-06-04 13:43:47',NULL,'Asset'),(30,5,'530000','Banque',1,'Asset',0,0.00,'2025-06-04 13:43:47',NULL,'Asset'),(31,5,'570000','Caisse',1,'Asset',0,0.00,'2025-06-04 13:43:47',NULL,'Asset'),(32,6,'600000','Achats',1,'Expense',0,0.00,'2025-06-04 13:43:47',NULL,'Expense'),(33,6,'604000','Achats de services',1,'Expense',0,0.00,'2025-06-04 13:43:47',NULL,'Expense'),(34,6,'611000','Salaires et traitements',1,'Expense',0,0.00,'2025-06-04 13:43:47',NULL,'Expense'),(35,7,'700000','Ventes',1,'Revenue',0,0.00,'2025-06-04 13:43:47',NULL,'Revenue'),(36,7,'740000','Subsides d’exploitation',1,'Revenue',0,0.00,'2025-06-04 13:43:47',NULL,'Revenue'),(37,7,'750000','Produits financiers',1,'Revenue',0,0.00,'2025-06-04 13:43:47',NULL,'Revenue'),(53,NULL,'550000','Banque',1,'Asset',0,0.00,'2025-06-04 14:24:35',NULL,'Asset'),(54,NULL,'570000','Caisse',1,'Asset',0,0.00,'2025-06-04 14:24:35',NULL,'Asset'),(55,NULL,'640000','Autres charges d’exploitation',1,'Expense',0,0.00,'2025-06-04 14:24:35',NULL,'Expense'),(56,NULL,'613000','Loyers et charges locatives',1,'Expense',0,0.00,'2025-06-04 14:24:35',NULL,'Expense'),(57,NULL,'616000','Primes d’assurances',1,'Expense',0,0.00,'2025-06-04 14:24:35',NULL,'Expense'),(58,NULL,'620000','Services prestés par des tiers',1,'Expense',0,0.00,'2025-06-04 14:24:35',NULL,'Expense'),(59,NULL,'740000','Subsides reçus',1,'Revenue',0,0.00,'2025-06-04 14:24:35',NULL,'Revenue'),(60,NULL,'743000','Réductions de charges fiscales',1,'Revenue',0,0.00,'2025-06-04 14:24:35',NULL,'Revenue'),(61,NULL,'450000','TVA à payer',1,'Liability',0,0.00,'2025-06-04 14:24:35',NULL,'Liability'),(62,NULL,'451000','TVA due sur achats CEE',1,'Liability',0,0.00,'2025-06-04 14:24:35',NULL,'Liability'),(63,NULL,'451100','TVA nationale due',1,'Liability',0,0.00,'2025-06-04 14:24:35',NULL,'Liability'),(64,NULL,'451200','TVA intracommunautaire due',1,'Liability',0,0.00,'2025-06-04 14:24:35',NULL,'Liability'),(65,NULL,'452000','Compte courant Administration TVA',1,'Liability',0,0.00,'2025-06-04 14:24:35',NULL,'Liability'),(66,NULL,'453000','Précomptes retenus',1,'Liability',0,0.00,'2025-06-04 14:24:35',NULL,'Liability'),(67,NULL,'499000','Résultat de l’exercice',1,'Equity',0,0.00,'2025-06-04 14:24:35',NULL,'Equity');

--
-- Table structure for table `doctrine_migration_versions`
--

CREATE TABLE `doctrine_migration_versions` (
  `version` varchar(191) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `executed_at` datetime DEFAULT NULL,
  `execution_time` int DEFAULT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `doctrine_migration_versions`
--

INSERT INTO `doctrine_migration_versions` VALUES ('DoctrineMigrations\\Version20250625133355','2025-06-25 15:33:59',93),('DoctrineMigrations\\Version20260724084345','2026-07-24 10:44:00',67),('DoctrineMigrations\\Version20260724092621','2026-07-24 11:26:26',85),('DoctrineMigrations\\Version20260724094608','2026-07-24 11:46:29',113),('DoctrineMigrations\\Version20260724123158','2026-07-24 14:32:15',73),('DoctrineMigrations\\Version20260724142042','2026-07-24 16:20:52',100),('DoctrineMigrations\\Version20260724150038','2026-07-24 17:00:44',68),('DoctrineMigrations\\Version20260727125426','2026-07-27 14:54:34',67),('DoctrineMigrations\\Version20260727131742','2026-07-27 15:17:48',66);

--
-- Table structure for table `estimate`
--

CREATE TABLE `estimate` (
  `id` int NOT NULL AUTO_INCREMENT,
  `client_id` int DEFAULT NULL,
  `company_id` int DEFAULT NULL,
  `accounting_period_id` int DEFAULT NULL,
  `estimate_reference` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sent` datetime DEFAULT NULL,
  `accepted` datetime DEFAULT NULL,
  `processed` tinyint(1) NOT NULL,
  `total` decimal(8,2) DEFAULT NULL,
  `cdts` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT NULL,
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_D2EA460719EB6921` (`client_id`),
  KEY `IDX_D2EA4607979B1AD6` (`company_id`),
  KEY `IDX_D2EA4607BF806DC3` (`accounting_period_id`),
  CONSTRAINT `FK_D2EA460719EB6921` FOREIGN KEY (`client_id`) REFERENCES `company` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_D2EA4607979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_D2EA4607BF806DC3` FOREIGN KEY (`accounting_period_id`) REFERENCES `accounting_period` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `estimate`
--


--
-- Table structure for table `fiscal_deadline`
--

CREATE TABLE `fiscal_deadline` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `due_date` date NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `active` tinyint(1) NOT NULL,
  `created_at` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)',
  `updated_at` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)',
  `accounting_period_id` int NOT NULL,
  `complete` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_E861C417BF806DC3` (`accounting_period_id`),
  CONSTRAINT `FK_E861C417BF806DC3` FOREIGN KEY (`accounting_period_id`) REFERENCES `accounting_period` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `fiscal_deadline`
--

INSERT INTO `fiscal_deadline` VALUES (27,'Déclaration TVA - Mars 2025','TVA','2025-04-20','Déclaration mensuelle de la TVA pour mars 2025 à soumettre avant le 20 avril.',1,'2025-04-01 14:52:48','2025-04-01 14:52:48',5,NULL),(28,'Déclaration TVA - T1 2025','TVA','2025-07-20','Déclaration trimestrielle de la TVA pour Q1 2025 à remettre avant le 20 juillet.',1,'2025-04-01 14:52:48','2025-04-01 14:52:48',5,NULL),(29,'Listing clients assujettis TVA 2024','TVA','2025-03-31','Listing annuel des clients assujettis à la TVA à transmettre au SPF Finances.',1,'2025-04-01 14:52:48','2025-04-01 14:52:48',5,NULL),(30,'Versement anticipé 1 - Estimation initiale - PAYE ✅','ISOC','2025-04-10','Premier et unique versement anticipé de l\'année. Le résultat 2025 est estimé positif. \r\n<b>35000€</b> Versés soit 5000€ en plus que l\'année passée',1,'2025-04-01 14:52:00','2025-04-01 14:52:00',5,NULL),(31,'Versement anticipé 2 - complément possible','ISOC','2025-07-10','Deuxième moment pour ajuster les acomptes en fonction du résultat semestriel.',1,'2025-04-01 14:52:48','2025-04-01 14:52:48',5,NULL),(32,'Versement anticipé 3 - ajustement Q3','ISOC','2025-10-10','Troisième acompte sur base des résultats au 30 septembre.',1,'2025-04-01 14:52:48','2025-04-01 14:52:48',5,NULL),(33,'Versement anticipé 4 - ajustement final','ISOC','2025-12-20','Dernière opportunité de paiement anticipé pour l’exercice 2025.',1,'2025-04-01 14:52:48','2025-04-01 14:52:48',5,NULL),(34,'Déclaration IPP 2024','IPP','2025-06-30','Déclaration de l’impôt des personnes physiques via Tax-on-Web pour l’année 2024.',1,'2025-04-01 14:52:48','2025-04-01 14:52:48',5,NULL),(35,'Déclaration précompte mobilier','Précompte','2025-05-15','Déclaration des revenus mobiliers perçus à soumettre pour le 15 mai.',1,'2025-04-01 14:52:48','2025-04-01 14:52:48',5,NULL),(36,'Cotisations sociales Q2 2025','Social','2025-07-15','Paiement des cotisations sociales d’indépendant pour le 2e trimestre 2025.',1,'2025-04-01 14:52:48','2025-04-01 14:52:48',5,NULL),(37,'Clôture de l’exercice comptable 2024','Comptabilité','2025-03-15','Clôture des comptes annuels 2024 et transmission au comptable.',1,'2025-04-01 14:52:48','2025-04-01 14:52:48',5,NULL);

--
-- Table structure for table `invoice`
--

CREATE TABLE `invoice` (
  `id` int NOT NULL AUTO_INCREMENT,
  `client_id` int DEFAULT NULL,
  `invoice_reference` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sent` datetime DEFAULT NULL,
  `paied` datetime DEFAULT NULL,
  `processed` tinyint(1) NOT NULL,
  `total` decimal(8,2) DEFAULT NULL,
  `accounting_period_id` int DEFAULT NULL,
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `udts` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_9065174419EB6921` (`client_id`),
  KEY `IDX_90651744BF806DC3` (`accounting_period_id`),
  CONSTRAINT `FK_9065174419EB6921` FOREIGN KEY (`client_id`) REFERENCES `company` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_90651744BF806DC3` FOREIGN KEY (`accounting_period_id`) REFERENCES `accounting_period` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `invoice`
--

INSERT INTO `invoice` VALUES (5,4,'WFI0001','2019-07-19 15:55:02','2020-10-15 22:16:50',1,365.42,1,NULL,NULL),(6,1,'WFI0002','2019-07-31 15:55:52','2020-08-03 09:21:20',1,17687.18,1,NULL,NULL),(7,1,'WFI0003','2019-09-02 10:03:10','2020-08-03 09:21:23',1,6697.35,1,NULL,NULL),(8,1,'WFI0004','2019-10-07 09:36:27','2020-08-03 09:21:25',1,14777.13,1,NULL,NULL),(9,1,'WFI0005','2019-10-31 12:06:18','2020-08-03 09:21:27',1,11960.85,1,NULL,NULL),(11,5,'WFI0006','2019-10-23 09:11:19','2020-10-15 22:16:34',1,52.03,1,NULL,NULL),(12,1,'WFI0007','2019-11-30 08:28:06','2020-08-03 11:17:27',1,13660.90,1,NULL,NULL),(13,6,'WFI0008','2020-03-02 18:14:56','2020-10-15 22:17:24',1,19.36,1,NULL,NULL),(14,1,'WFI0009','2019-12-31 09:13:01','2020-08-03 11:25:49',1,14577.48,1,NULL,NULL),(15,1,'WFI0010','2020-01-31 09:30:39','2020-08-03 09:21:34',1,16541.91,1,NULL,NULL),(16,7,'WFI0011','2020-01-13 11:18:16','2020-10-15 22:17:07',1,124.63,1,NULL,NULL),(17,7,'WFI0012','2020-02-06 13:36:39','2020-10-15 22:17:04',1,88.33,1,NULL,NULL),(18,1,'WFI0013','2020-03-05 07:57:54','2020-08-03 09:21:36',1,12686.85,1,NULL,NULL),(19,7,'WFI0014','2020-03-02 18:04:07','2020-10-15 22:17:00',1,95.59,1,NULL,NULL),(21,1,'WFI0015','2020-04-02 08:25:03','2020-08-03 09:21:38',1,14952.58,1,NULL,NULL),(22,1,'WFI0016','2020-05-04 11:06:03','2020-08-03 09:21:40',1,13068.00,1,NULL,NULL),(23,1,'WFI0017','2020-06-01 13:30:21','2020-08-03 09:21:43',1,14510.32,1,NULL,NULL),(24,1,'WFI0018','2020-07-06 10:11:37','2020-08-03 09:21:45',1,14296.76,1,NULL,NULL),(25,1,'WFI0019','2020-08-01 11:14:56','2020-08-31 13:49:27',1,13545.95,1,NULL,NULL),(26,1,'WFI0020','2020-08-31 14:07:32','2020-10-15 22:19:12',1,12373.46,1,NULL,NULL),(27,1,'WFI0021','2020-10-03 09:56:59','2020-10-15 22:19:16',1,12999.03,1,NULL,NULL),(28,5,'WFI0022','2020-10-12 12:25:27','2021-10-04 15:50:38',1,52.03,1,NULL,NULL),(29,1,'WFI0023','2020-11-02 14:59:00','2020-11-17 09:02:18',1,17256.42,1,NULL,NULL),(30,7,'WFI0024','2021-03-09 19:46:22','2021-07-22 14:48:40',1,140.00,1,NULL,NULL),(31,1,'WFI0025','2020-12-01 10:18:41','2020-12-27 19:35:05',1,13784.32,1,NULL,NULL),(32,6,'WFI0026','2020-12-01 10:30:56','2022-10-03 11:40:35',1,28.31,1,NULL,NULL),(33,1,'WFI0001','2021-01-20 11:24:28','2021-02-24 23:09:19',1,22216.33,2,NULL,NULL),(34,1,'WFI0002','2021-02-24 23:09:06','2021-02-24 23:09:24',1,13002.90,2,NULL,NULL),(35,1,'WFI0003','2021-03-01 11:37:20','2021-03-12 18:41:39',1,15022.39,2,NULL,NULL),(36,7,'WFI0004','2021-03-09 19:56:14','2021-07-22 14:48:05',1,95.59,2,NULL,NULL),(37,1,'WFI0005','2021-04-22 10:31:41','2021-05-04 08:26:43',1,13777.67,2,NULL,NULL),(38,1,'WFI0006','2021-05-04 08:26:36','2021-07-01 17:38:46',1,13857.77,2,NULL,NULL),(39,1,'WFI0007','2021-06-02 10:42:46','2021-07-01 17:38:49',1,14592.84,2,NULL,NULL),(40,7,'WFI0008','2021-06-02 10:59:50','2021-08-05 10:29:30',1,2413.95,2,NULL,NULL),(41,1,'WFI0009','2021-07-01 17:38:37','2021-08-02 11:46:28',1,14662.78,2,NULL,NULL),(42,1,'WFI0010','2021-08-02 11:45:25','2021-09-01 10:46:43',1,18465.45,2,NULL,NULL),(43,7,'WFI0011','2021-08-03 10:12:03','2021-08-05 10:29:33',1,6435.99,2,NULL,NULL),(44,1,'WFI0012','2021-09-10 09:59:57','2021-10-04 15:32:16',1,7714.48,2,NULL,NULL),(45,5,'WFI0013','2021-10-04 15:50:47','2021-11-17 09:53:02',1,8.47,2,NULL,NULL),(46,1,'WFI0014','2021-10-04 15:32:09','2021-10-19 13:12:14',1,17105.17,2,NULL,NULL),(47,1,'WFI0015','2021-11-03 11:50:24','2022-01-03 09:32:05',1,13954.45,2,NULL,NULL),(48,1,'WFI0016','2022-01-03 09:32:14','2022-01-03 09:32:10',1,14241.70,2,NULL,NULL),(49,1,'WFI0017','2022-01-08 18:44:50','2022-02-02 11:31:21',1,15194.70,3,NULL,NULL),(50,1,'WFI0001','2022-02-02 11:31:15','2022-03-02 10:35:55',1,16728.25,3,NULL,NULL),(51,9,'WFI0002',NULL,'2024-01-24 17:54:26',1,10999.99,3,NULL,NULL),(52,1,'WFI0003','2022-03-02 10:35:50','2022-04-01 10:08:01',1,14953.79,3,NULL,NULL),(53,1,'WFI0004','2022-04-01 10:07:50','2022-06-01 10:28:28',1,19819.80,3,NULL,NULL),(54,1,'WFI0005','2022-05-06 10:25:21','2022-06-01 10:28:31',1,10623.80,3,NULL,NULL),(55,1,'WFI0006','2022-06-01 10:28:24','2022-07-01 14:14:51',1,15495.26,3,NULL,NULL),(56,1,'WFI0007','2022-07-01 14:14:44','2022-08-31 11:00:52',1,15264.15,3,NULL,NULL),(57,1,'WFI0008','2022-08-02 13:10:07','2022-08-31 11:00:56',1,16084.53,3,NULL,NULL),(58,1,'WFI0009','2022-09-02 10:23:29','2022-09-27 11:01:37',1,9221.41,3,NULL,NULL),(59,1,'WFI0010','2022-10-03 10:49:51','2022-11-03 12:52:24',1,16322.42,3,NULL,NULL),(60,5,'WFI0011','2022-10-03 11:22:24','2024-01-24 17:52:23',1,8.46,3,NULL,NULL),(61,6,'WFI0012','2022-10-03 17:04:12','2023-11-02 09:03:42',1,50.55,3,NULL,NULL),(62,7,'WFI0013','2022-10-26 22:06:10','2022-12-21 10:18:18',1,5880.60,3,NULL,NULL),(63,7,'WFI0014','2022-10-28 21:41:45','2022-12-21 10:18:21',1,805.06,3,NULL,NULL),(64,7,'WFI0015','2022-10-28 21:48:36','2022-12-21 10:18:24',1,140.00,3,NULL,NULL),(65,1,'WFI0016','2022-11-03 12:51:43','2022-12-01 10:20:05',1,15306.50,3,NULL,NULL),(66,10,'WFI0017','2022-11-04 18:15:28','2024-01-24 17:51:26',1,871.20,3,NULL,NULL),(67,1,'WFI0018','2022-12-01 10:19:58','2023-10-02 10:07:46',1,14956.81,3,NULL,NULL),(68,7,'WFI0019','2022-12-27 01:09:03','2024-01-24 17:53:11',1,5118.30,3,NULL,NULL),(69,1,'WFI0020','2023-01-02 11:03:30','2023-12-01 09:30:39',1,18195.98,4,NULL,NULL),(70,1,'04_WFI0001','2023-02-01 15:43:12','2023-04-03 10:41:14',1,17044.67,4,NULL,NULL),(71,1,'04_WFI0002','2023-03-06 11:38:27','2023-04-03 10:40:57',1,13606.45,4,NULL,NULL),(72,1,'04_WFI0003','2023-04-03 10:38:22','2023-05-06 11:52:46',1,15143.15,4,NULL,NULL),(73,1,'04_WFI0004','2023-05-06 11:50:08','2023-06-09 10:30:25',1,15353.09,4,NULL,NULL),(74,1,'04_WFI0005','2023-06-09 10:24:48','2023-07-04 11:43:07',1,18329.69,4,NULL,NULL),(75,1,'04_WFI0006','2023-07-04 11:42:46','2023-09-01 17:02:39',1,17091.25,4,NULL,NULL),(76,1,'04_WFI0007','2023-08-01 10:20:33','2023-09-01 17:02:50',1,17885.01,4,NULL,NULL),(77,1,'04_WFI0008','2023-09-01 17:02:06','2023-10-02 10:07:22',1,7908.56,4,NULL,NULL),(78,1,'04_WFI0009','2023-10-02 10:06:54','2023-12-01 09:30:22',1,17971.53,4,NULL,NULL),(79,1,'04_WFI0010','2023-10-31 15:17:28','2023-12-01 09:30:52',1,13977.32,4,NULL,NULL),(80,6,'04_WFI0011','2023-11-02 09:34:47','2024-01-24 17:50:58',1,31.54,4,NULL,NULL),(81,7,'04_WFI0012','2023-11-02 09:35:00','2024-01-24 17:53:26',1,104.14,4,NULL,NULL),(82,5,'04_WFI0013','2023-11-02 09:34:33','2024-01-24 17:52:32',1,8.46,4,NULL,NULL),(83,1,'04_WFI0014','2023-12-01 09:28:31','2024-01-21 18:21:55',1,18121.57,4,NULL,NULL),(84,1,'04_WFI0015','2023-12-31 12:07:25','2024-01-21 18:21:38',1,15088.10,4,NULL,NULL),(85,1,'05_WFI0002','2024-02-02 18:21:18','2024-07-04 18:21:22',1,17458.49,5,NULL,NULL),(86,1,'05_WFI0003','2024-03-01 08:50:30','2024-07-04 18:21:13',1,16592.73,5,NULL,NULL),(87,1,'05_WFI0004','2024-04-02 09:47:31','2024-07-04 18:21:00',1,13289.43,5,NULL,NULL),(88,1,'05_WFI0005','2024-05-03 13:36:19','2024-07-04 18:20:31',1,16124.46,5,NULL,NULL),(89,1,'05_WFI0006','2024-06-03 17:45:32','2025-06-04 03:44:33',1,19164.59,5,NULL,NULL),(90,1,'05_WFI0007','2024-07-04 18:19:52','2025-06-04 03:45:23',1,15526.72,5,NULL,NULL),(91,1,'05_WFI0008','2024-09-01 18:26:16','2025-06-04 03:46:09',1,22252.51,5,NULL,NULL),(92,1,'05_WFI0009','2024-09-03 09:56:04','2025-06-04 03:46:49',1,8160.85,5,NULL,NULL),(93,1,'05_WFI0010','2024-10-04 18:41:58','2025-06-04 03:47:14',1,17021.68,5,NULL,NULL),(94,1,'05_WFI0011','2024-10-31 23:06:45','2025-06-04 03:47:41',1,18379.42,5,NULL,NULL),(95,1,'05_WFI0012','2024-12-02 09:37:23','2025-06-04 03:48:11',1,15616.50,5,NULL,NULL),(96,1,'05_WFI0013','2024-12-31 16:36:03','2024-12-31 16:44:07',1,18317.46,5,NULL,NULL),(97,1,'06_WFI0001','2025-02-04 10:00:22','2025-06-04 03:48:36',1,18741.81,6,NULL,NULL),(98,1,'06_WFI0002','2025-03-31 19:42:20','2025-06-04 03:48:53',1,17963.78,6,NULL,NULL),(100,1,'06_WFI0003','2025-05-02 19:04:56','2025-03-31 19:38:47',1,13027.34,6,NULL,NULL),(102,1,'06_WFI0004','2025-05-02 19:12:29','2025-06-04 11:55:42',1,17866.86,6,NULL,NULL),(105,1,'06_WFI0005','2025-06-02 13:40:52','2025-06-04 11:55:50',1,15860.80,6,NULL,NULL),(106,1,'06_WFI0006',NULL,NULL,0,NULL,6,NULL,NULL);

--
-- Table structure for table `journal_entries`
--

CREATE TABLE `journal_entries` (
  `id` int NOT NULL AUTO_INCREMENT,
  `journal_id` int NOT NULL,
  `accounting_period_id` int DEFAULT NULL,
  `template_id` int DEFAULT NULL,
  `reference` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `entry_date` datetime NOT NULL,
  `is_posted` tinyint(1) NOT NULL DEFAULT '0',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_amount` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_FD43FD20478E8802` (`journal_id`),
  KEY `IDX_FD43FD20BF806DC3` (`accounting_period_id`),
  KEY `IDX_FD43FD205DA0FB8` (`template_id`),
  CONSTRAINT `FK_FD43FD20478E8802` FOREIGN KEY (`journal_id`) REFERENCES `journals` (`id`),
  CONSTRAINT `FK_FD43FD205DA0FB8` FOREIGN KEY (`template_id`) REFERENCES `journal_entry_template` (`id`),
  CONSTRAINT `FK_FD43FD20BF806DC3` FOREIGN KEY (`accounting_period_id`) REFERENCES `accounting_period` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `journal_entries`
--


--
-- Table structure for table `journal_entry_lines`
--

CREATE TABLE `journal_entry_lines` (
  `id` int NOT NULL AUTO_INCREMENT,
  `journal_entry_id` int NOT NULL,
  `account_id` int NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `debit` decimal(15,2) DEFAULT NULL,
  `credit` decimal(15,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_D15C5B576A86E4FB` (`journal_entry_id`),
  KEY `IDX_D15C5B579B6B5FBA` (`account_id`),
  CONSTRAINT `FK_D15C5B576A86E4FB` FOREIGN KEY (`journal_entry_id`) REFERENCES `journal_entries` (`id`),
  CONSTRAINT `FK_D15C5B579B6B5FBA` FOREIGN KEY (`account_id`) REFERENCES `chart_of_accounts` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `journal_entry_lines`
--


--
-- Table structure for table `journal_entry_template`
--

CREATE TABLE `journal_entry_template` (
  `id` int NOT NULL AUTO_INCREMENT,
  `journal_id` int DEFAULT NULL,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `entry_lines` json DEFAULT NULL,
  `tips` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `IDX_DCAE9DFB478E8802` (`journal_id`),
  CONSTRAINT `FK_DCAE9DFB478E8802` FOREIGN KEY (`journal_id`) REFERENCES `journals` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `journal_entry_template`
--

INSERT INTO `journal_entry_template` VALUES (1,5,'TMC Moto','{\"lines\": [{\"debit\": 500, \"credit\": 0, \"account\": 23, \"description\": \"Taxe mise en circulation\"}, {\"debit\": 0, \"credit\": 250, \"account\": 32, \"description\": \"TVA sur TMC\"}, {\"debit\": 0, \"credit\": 250, \"account\": 30, \"description\": \"Paiement TMC\"}]}','Utiliser ce modèle pour la taxe de mise en circulation d’un véhicule acheté au nom de la société. Vérifie si déductibilité partielle (véhicule mixte).'),(2,4,'Facture Client Service','{\"lines\": [{\"debit\": 500, \"credit\": 0, \"account\": 21, \"description\": \"Produit vendu\"}, {\"debit\": 0, \"credit\": 250, \"account\": 24, \"description\": \"TVA sur vente\"}, {\"debit\": 0, \"credit\": 250, \"account\": 35, \"description\": \"Client à recevoir\"}]}','Utiliser ce modèle lors de la facturation d’un service avec TVA à un client.'),(3,5,'EIP','{\"lines\": [{\"debit\": 500, \"credit\": 0, \"account\": 57, \"description\": \"Prime EIP\"}, {\"debit\": 0, \"credit\": 250, \"account\": 24, \"description\": \"TVA due sur EIP\"}, {\"debit\": 0, \"credit\": 250, \"account\": 30, \"description\": \"Paiement EIP\"}]}','Utiliser ce modèle pour comptabiliser la prime EIP. Comptabilise la prime (616), la TVA due (451) et le paiement (530).'),(4,5,'PLCI','{\"lines\": [{\"debit\": 500, \"credit\": 0, \"account\": 57, \"description\": \"Prime PLCI\"}, {\"debit\": 0, \"credit\": 500, \"account\": 30, \"description\": \"Paiement PLCI\"}]}','Utiliser ce modèle pour la PLCI. Pas de TVA sur la PLCI, prime à comptabiliser en charge et paiement.'),(5,5,'Restaurant','{\"lines\": [{\"debit\": 500, \"credit\": 0, \"account\": 56, \"description\": \"Frais de restaurant\"}, {\"debit\": 0, \"credit\": 250, \"account\": 24, \"description\": \"TVA sur restaurant\"}, {\"debit\": 0, \"credit\": 250, \"account\": 30, \"description\": \"Paiement restaurant\"}]}','Utiliser ce modèle pour les frais de restaurant. Vérifier la déductibilité fiscale (souvent limitée).'),(6,5,'Entretien Moto','{\"lines\": [{\"debit\": 500, \"credit\": 0, \"account\": 33, \"description\": \"Frais entretien moto\"}, {\"debit\": 0, \"credit\": 250, \"account\": 24, \"description\": \"TVA sur entretien moto\"}, {\"debit\": 0, \"credit\": 250, \"account\": 30, \"description\": \"Paiement entretien moto\"}]}','Utiliser ce modèle pour les frais d’entretien moto. Vérifier le degré de déductibilité si usage mixte.'),(7,5,'Entretien Voiture','{\"lines\": [{\"debit\": 500, \"credit\": 0, \"account\": 33, \"description\": \"Frais entretien voiture\"}, {\"debit\": 0, \"credit\": 250, \"account\": 24, \"description\": \"TVA sur entretien voiture\"}, {\"debit\": 0, \"credit\": 250, \"account\": 30, \"description\": \"Paiement entretien voiture\"}]}','Utiliser ce modèle pour les frais d’entretien voiture. Vérifier la déductibilité partielle si usage mixte.'),(8,5,'Assurance','{\"lines\": [{\"debit\": 500, \"credit\": 0, \"account\": 57, \"description\": \"Prime assurance\"}, {\"debit\": 0, \"credit\": 250, \"account\": 24, \"description\": \"TVA sur assurance\"}, {\"debit\": 0, \"credit\": 250, \"account\": 30, \"description\": \"Paiement assurance\"}]}','Utiliser ce modèle pour les primes d’assurances (véhicule, RC, incendie…). TVA récupérable selon type d’assurance.'),(9,5,'Loyer','{\"lines\": [{\"debit\": 500, \"credit\": 0, \"account\": 56, \"description\": \"Loyer charges comprises\"}, {\"debit\": 0, \"credit\": 250, \"account\": 24, \"description\": \"TVA sur loyer\"}, {\"debit\": 0, \"credit\": 250, \"account\": 30, \"description\": \"Paiement loyer\"}]}','Utiliser ce modèle pour le paiement du loyer avec TVA (si applicable).');

--
-- Table structure for table `journals`
--

CREATE TABLE `journals` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `journals`
--

INSERT INTO `journals` VALUES (4,'VE','Journal des Ventes','Revenue'),(5,'AC','Journal des Achats','Expense'),(6,'BQ','Journal de Banque','Bank'),(7,'OD','Opérations Diverses','General'),(8,'CA','Journal de Caisse','Cash'),(9,'AM','Journal des Amortissements','Depreciation'),(10,'TVA','Journal TVA','Tax'),(11,'PAIE','Journal de Paie','Payroll'),(12,'INV','Journal d\'(Inventaire','Inventory');

--
-- Table structure for table `onsite_activity`
--

CREATE TABLE `onsite_activity` (
  `id` int NOT NULL AUTO_INCREMENT,
  `task_id` int DEFAULT NULL,
  `activity_date` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
  `duration_minutes` int NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `ticket_reference` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
  `updated_at` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)',
  `site_id` int DEFAULT NULL,
  `time_sheet_entry_id` int DEFAULT NULL,
  `is_generated` tinyint(1) NOT NULL,
  `is_locked` tinyint(1) NOT NULL,
  `generation_batch` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source_date` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)',
  `user_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_296EAF328DB60186` (`task_id`),
  KEY `IDX_296EAF32F6BD1646` (`site_id`),
  KEY `IDX_296EAF3272E5B585` (`time_sheet_entry_id`),
  KEY `IDX_296EAF32A76ED395` (`user_id`),
  CONSTRAINT `FK_296EAF3272E5B585` FOREIGN KEY (`time_sheet_entry_id`) REFERENCES `time_sheet` (`id`),
  CONSTRAINT `FK_296EAF328DB60186` FOREIGN KEY (`task_id`) REFERENCES `onsite_task` (`id`),
  CONSTRAINT `FK_296EAF32A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_296EAF32F6BD1646` FOREIGN KEY (`site_id`) REFERENCES `site` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `onsite_activity`
--

INSERT INTO `onsite_activity` VALUES (32,143,'2026-08-19 00:00:00',71,'Review application logs to identify errors, warnings and abnormal behaviour.',NULL,'completed','2026-08-01 08:59:21',NULL,4,NULL,1,0,'db8cc97c-a27d-4e2a-9dc6-16c57470e3d2',NULL,1),(33,153,'2026-08-19 00:00:00',73,'Confirm installed application, module and patch versions.',NULL,'completed','2026-08-01 08:59:21',NULL,4,NULL,1,0,'db8cc97c-a27d-4e2a-9dc6-16c57470e3d2',NULL,1),(34,162,'2026-08-19 00:00:00',50,'Correct authorized and documented application configuration issues.',NULL,'completed','2026-08-01 08:59:21',NULL,4,NULL,1,0,'db8cc97c-a27d-4e2a-9dc6-16c57470e3d2',NULL,1),(35,165,'2026-08-19 00:00:00',70,'Recover blocked queues without causing duplicate processing.',NULL,'completed','2026-08-01 08:59:21',NULL,4,NULL,1,0,'db8cc97c-a27d-4e2a-9dc6-16c57470e3d2',NULL,1),(36,179,'2026-08-19 00:00:00',72,'Update procedures, troubleshooting guides and environment documentation.',NULL,'completed','2026-08-01 08:59:21',NULL,4,NULL,1,0,'db8cc97c-a27d-4e2a-9dc6-16c57470e3d2',NULL,1),(37,195,'2026-08-19 00:00:00',48,'Present incidents, application health, risks and improvement opportunities.',NULL,'completed','2026-08-01 08:59:21',NULL,4,NULL,1,0,'db8cc97c-a27d-4e2a-9dc6-16c57470e3d2',NULL,1),(38,182,'2026-08-19 00:00:00',48,'Provide a clear technical point of contact for the client.',NULL,'completed','2026-08-01 08:59:21',NULL,4,NULL,1,0,'db8cc97c-a27d-4e2a-9dc6-16c57470e3d2',NULL,1),(39,198,'2026-08-19 00:00:00',48,'Identify workflows whose interruption would have a major operational impact.',NULL,'completed','2026-08-01 08:59:21',NULL,4,NULL,1,0,'db8cc97c-a27d-4e2a-9dc6-16c57470e3d2',NULL,1);

--
-- Table structure for table `onsite_task`
--

CREATE TABLE `onsite_task` (
  `id` int NOT NULL AUTO_INCREMENT,
  `category_id` int DEFAULT NULL,
  `code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `frequency` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `priority` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `display_order` int NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_E86895A312469DE2` (`category_id`),
  CONSTRAINT `FK_E86895A312469DE2` FOREIGN KEY (`category_id`) REFERENCES `onsite_task_category` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=211 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `onsite_task`
--

INSERT INTO `onsite_task` VALUES (141,11,'PREV_APP_HEALTH','Monitor application health','Check the availability and operational status of the main application and its components.','Daily','High',10,1),(142,11,'PREV_SERVICE_STATUS','Check application services','Verify that all required application services are running correctly.','Daily','High',20,1),(143,11,'PREV_LOG_REVIEW','Review application logs','Review application logs to identify errors, warnings and abnormal behaviour.','Daily','High',30,1),(144,11,'PREV_RECURRING_ERRORS','Detect recurring errors','Identify repeated errors that could indicate an upcoming incident.','Daily','High',40,1),(145,11,'PREV_QUEUE_MONITORING','Monitor processing queues','Check processing queues for delayed, failed or blocked items.','Daily','High',50,1),(146,11,'PREV_JOB_MONITORING','Check scheduled jobs','Verify that scheduled jobs and batch processes completed successfully.','Daily','High',60,1),(147,11,'PREV_RESPONSE_TIME','Monitor application response times','Identify performance degradation before it affects users.','Daily','High',70,1),(148,11,'PREV_DATABASE_CONNECTIVITY','Verify database connectivity','Confirm that the application can access all required databases.','Daily','High',80,1),(149,11,'PREV_DATABASE_CAPACITY','Monitor database capacity','Check database size, transaction logs and available storage.','Daily','High',90,1),(150,11,'PREV_API_MONITORING','Monitor API integrations','Verify that inbound and outbound API calls are processed correctly.','Daily','High',100,1),(151,11,'PREV_EXTERNAL_SYSTEMS','Check external system integrations','Verify connectivity and data exchange with third-party systems.','Daily','High',110,1),(152,11,'PREV_CERTIFICATES','Check application certificates','Verify certificate validity and upcoming expiration dates.','Weekly','High',120,1),(153,11,'PREV_VERSION_CHECK','Verify installed software versions','Confirm installed application, module and patch versions.','Weekly','Medium',130,1),(154,12,'INC_REVIEW_TICKETS','Review incoming incidents','Review new incidents and determine their impact and priority.','On demand','High',10,1),(155,12,'INC_COLLECT_INFORMATION','Collect incident information','Collect timestamps, screenshots, error messages, affected users and reproduction steps.','Per incident','High',20,1),(156,12,'INC_ASSESS_IMPACT','Assess incident impact','Determine the users, services, sites and workflows affected by the incident.','Per incident','Critical',30,1),(157,12,'INC_CLASSIFY_CAUSE','Classify the incident','Determine whether the issue relates to software, infrastructure, data, configuration or usage.','Per incident','High',40,1),(158,12,'INC_REPRODUCE','Reproduce reported issues','Attempt to reproduce the reported problem in a controlled environment.','Per incident','High',50,1),(159,12,'INC_ANALYZE_LOGS','Analyze incident logs','Analyze application, operating system, database and integration logs.','Per incident','High',60,1),(160,12,'INC_CHECK_CHANGES','Check recent technical changes','Identify deployments or configuration changes that preceded the incident.','Per incident','High',70,1),(161,12,'INC_FUNCTIONAL_SUPPORT','Provide functional user support','Guide users through the expected application workflow.','On demand','Medium',80,1),(162,12,'INC_CONFIGURATION_FIX','Correct application configuration','Correct authorized and documented application configuration issues.','Per incident','High',90,1),(163,12,'INC_RESTART_SERVICE','Restart application services','Restart affected services according to the approved operational procedure.','Per incident','High',100,1),(164,12,'INC_RESTART_JOB','Restart failed jobs','Restart or reprocess failed scheduled jobs and background tasks.','Per incident','High',110,1),(165,12,'INC_CLEAR_QUEUE','Recover blocked processing queues','Recover blocked queues without causing duplicate processing.','Per incident','High',120,1),(166,12,'INC_CORRECT_DATA','Correct inconsistent application data','Apply an approved and traceable data correction.','Per incident','Critical',130,1),(167,12,'INC_IMPLEMENT_WORKAROUND','Implement a temporary workaround','Apply a safe temporary solution to maintain client operations.','Per incident','Critical',140,1),(168,12,'INC_VALIDATE_RECOVERY','Validate service recovery','Confirm technically and functionally that the service has returned to normal.','Per incident','Critical',150,1),(169,12,'INC_MAJOR_COORDINATION','Coordinate major incident resolution','Coordinate the client, vendor teams and third parties during a major incident.','Per incident','Critical',160,1),(170,12,'INC_ESCALATE_L3','Escalate complex incidents','Escalate unresolved incidents with complete technical information.','Per incident','High',170,1),(171,12,'INC_DOCUMENT_RESOLUTION','Document incident resolution','Document symptoms, analysis, cause, workaround and final resolution.','Per incident','High',180,1),(172,12,'INC_ROOT_CAUSE','Perform root cause analysis','Identify the causes of significant or recurring incidents.','Per incident','High',190,1),(173,13,'IMP_IDENTIFY_RECURRING','Identify recurring incidents','Analyze incident history to identify repeated problems and failure patterns.','Weekly','High',10,1),(174,13,'IMP_PROPOSE_FIX','Propose permanent corrective actions','Define permanent solutions for recurring incidents.','On demand','High',20,1),(175,13,'IMP_PERFORMANCE','Identify performance bottlenecks','Analyze application, database and integration performance.','Weekly','Medium',30,1),(176,13,'IMP_AUTOMATION','Automate repetitive tasks','Create scripts and tools for recurring monitoring or maintenance operations.','On demand','Medium',40,1),(177,13,'IMP_DIAGNOSTIC_TOOLS','Develop diagnostic tools','Create scripts, queries and dashboards that accelerate troubleshooting.','On demand','Medium',50,1),(178,13,'IMP_MONITORING','Improve monitoring coverage','Add or improve monitoring checks, alerts and thresholds.','Monthly','High',60,1),(179,13,'IMP_DOCUMENTATION','Maintain technical documentation','Update procedures, troubleshooting guides and environment documentation.','Weekly','Medium',70,1),(180,13,'IMP_KNOWLEDGE_BASE','Maintain the support knowledge base','Document known issues, common solutions and workarounds.','Weekly','Medium',80,1),(181,13,'IMP_PRODUCT_FEEDBACK','Provide product improvement feedback','Submit feedback based on real client usage and operational needs.','On demand','Medium',90,1),(182,14,'CVI_SINGLE_CONTACT','Act as the onsite technical contact','Provide a clear technical point of contact for the client.','Daily','High',10,1),(183,14,'CVI_TRANSLATE_NEEDS','Translate client needs into technical requirements','Convert operational requests into clear technical requirements for vendor teams.','On demand','High',20,1),(184,14,'CVI_EXPLAIN_TECHNICAL','Explain technical issues to the client','Explain technical findings in clear language adapted to client stakeholders.','On demand','High',30,1),(185,14,'CVI_REPORT_BUG','Report confirmed software defects','Create complete and reproducible defect reports.','Per incident','High',40,1),(186,14,'CVI_PROVIDE_LOGS','Provide diagnostic evidence','Provide logs, traces, screenshots and environmental details to vendor teams.','Per incident','High',50,1),(187,14,'CVI_ESCALATION_PACKAGE','Prepare complete escalation packages','Provide impact, chronology, diagnostics and attempted actions when escalating.','Per incident','High',60,1),(188,14,'CVI_FOLLOW_ESCALATION','Follow up on vendor escalations','Track escalated issues and maintain visibility over their progress.','Daily','High',70,1),(189,14,'CVI_COORDINATE_TEAMS','Coordinate client and vendor teams','Coordinate client IT, users, vendor support, engineering and product teams.','On demand','High',80,1),(190,14,'CVI_VALIDATE_FIX','Validate software fixes onsite','Test corrections in the client environment and check for regressions.','Per release','High',90,1),(191,14,'CVI_PREPARE_RELEASE','Prepare application releases','Review prerequisites, dependencies, backups and rollback procedures.','Per release','High',100,1),(192,14,'CVI_COORDINATE_DEPLOYMENT','Coordinate patch and release deployment','Coordinate deployments with the client and internal vendor teams.','Per release','High',110,1),(193,14,'CVI_POST_DEPLOYMENT','Perform post-deployment validation','Validate availability, integrations and critical workflows after deployment.','Per release','Critical',120,1),(194,14,'CVI_REPRESENT_VENDOR','Represent the software vendor onsite','Act as a professional and technically reliable vendor representative.','Daily','High',130,1),(195,14,'CVI_SERVICE_REVIEW','Participate in service review meetings','Present incidents, application health, risks and improvement opportunities.','Monthly','Medium',140,1),(196,14,'CVI_ACTION_TRACKING','Track client and vendor actions','Track actions, owners, deadlines and outstanding technical topics.','Weekly','High',150,1),(197,15,'CK_UNDERSTAND_USAGE','Understand how the client uses the software','Understand the real-world use of the application and its workflows.','Daily','High',10,1),(198,15,'CK_CRITICAL_WORKFLOWS','Identify critical business workflows','Identify workflows whose interruption would have a major operational impact.','Monthly','High',20,1),(199,15,'CK_KEY_USERS','Identify key users and stakeholders','Maintain knowledge of key users, business owners and technical contacts.','On demand','High',30,1),(200,15,'CK_INFRASTRUCTURE','Understand the client infrastructure','Understand the servers, databases, networks and storage supporting the application.','Monthly','High',40,1),(201,15,'CK_ARCHITECTURE_MAP','Maintain an application architecture map','Document components, dependencies, data flows and integrations.','Monthly','High',50,1),(202,15,'CK_INTEGRATIONS','Map application integrations','Identify inbound and outbound integrations and their owners.','Monthly','High',60,1),(203,15,'CK_PEAK_PERIODS','Identify peak activity periods','Understand when application usage and transaction volumes are highest.','Monthly','High',70,1),(204,15,'CK_CRITICAL_WINDOWS','Identify critical operational windows','Identify periods when maintenance or interruption would be especially disruptive.','Monthly','High',80,1),(205,15,'CK_OPERATIONAL_RISKS','Identify client-specific operational risks','Identify fragile processes, dependencies and single points of failure.','Monthly','High',90,1),(206,15,'CK_CHANGE_PROCESS','Understand the client change process','Understand the required approval, testing and deployment process.','On demand','High',100,1),(207,15,'CK_INCIDENT_PROCESS','Understand the client incident process','Know escalation paths, severity definitions and communication channels.','On demand','High',110,1),(208,15,'CK_ENV_CHANGES','Track client environment changes','Track infrastructure, network, database and security changes.','Weekly','High',120,1),(209,15,'CK_COLLECT_FEEDBACK','Collect user feedback','Collect feedback about usage, difficulties and recurring operational problems.','Weekly','Medium',130,1),(210,15,'CK_ANTICIPATE_IMPACT','Assess the client impact of technical changes','Anticipate the impact of patches, releases and configuration changes.','Per release','Critical',140,1);

--
-- Table structure for table `onsite_task_category`
--

CREATE TABLE `onsite_task_category` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `display_order` int NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `onsite_task_category`
--

INSERT INTO `onsite_task_category` VALUES (11,'PREVENTION','Prevention','Application monitoring, preventive maintenance, dependency verification and proactive issue detection.',10,1),(12,'INCIDENT_RESPONSE','Incident Response','User support, technical investigation, incident resolution and major incident coordination.',20,1),(13,'IMPROVEMENT','Continuous Improvement','Optimization, automation, documentation, stability and security improvements.',30,1),(14,'CLIENT_VENDOR_INTERFACE','Client–Vendor Interface','Coordination and communication between the client and the software vendor.',40,1),(15,'CLIENT_KNOWLEDGE','Client Environment Knowledge','Understanding the client infrastructure, workflows, integrations and operational constraints.',50,1);

--
-- Table structure for table `onsite_task_ratio`
--

CREATE TABLE `onsite_task_ratio` (
  `id` int NOT NULL AUTO_INCREMENT,
  `site_id` int DEFAULT NULL,
  `category_id` int DEFAULT NULL,
  `ratio` decimal(5,2) NOT NULL,
  `minimum_minutes` int DEFAULT NULL,
  `maximum_minutes` int DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL,
  `display_order` int NOT NULL,
  `number_of_tasks` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_A955C137F6BD1646` (`site_id`),
  KEY `IDX_A955C13712469DE2` (`category_id`),
  CONSTRAINT `FK_A955C13712469DE2` FOREIGN KEY (`category_id`) REFERENCES `onsite_task_category` (`id`),
  CONSTRAINT `FK_A955C137F6BD1646` FOREIGN KEY (`site_id`) REFERENCES `site` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `onsite_task_ratio`
--

INSERT INTO `onsite_task_ratio` VALUES (6,NULL,11,30.00,NULL,NULL,1,10,2),(7,NULL,12,25.00,NULL,NULL,1,20,2),(8,NULL,13,15.00,NULL,NULL,1,30,1),(9,NULL,14,20.00,NULL,NULL,1,40,2),(10,NULL,15,10.00,NULL,NULL,1,50,1);

--
-- Table structure for table `project`
--

CREATE TABLE `project` (
  `id` int NOT NULL AUTO_INCREMENT,
  `company_id` int DEFAULT NULL,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` decimal(7,2) NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stared` tinyint(1) NOT NULL,
  `default_hours_day` int DEFAULT NULL,
  `mileage_rate` decimal(2,2) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL,
  `display_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `site_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_2FB3D0EE979B1AD6` (`company_id`),
  KEY `IDX_2FB3D0EEF6BD1646` (`site_id`),
  CONSTRAINT `FK_2FB3D0EE979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_2FB3D0EEF6BD1646` FOREIGN KEY (`site_id`) REFERENCES `site` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=159 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project`
--

INSERT INTO `project` VALUES (144,1,'Administration',93.63,'Administrative',0,8,0.40,0,'bg-success',NULL),(145,1,'First Line availability allowance',846.00,'First Line availability allowance (from Fri to Fri)',0,1,0.40,0,'bg-success',NULL),(146,1,'First Line Intervention',139.00,'Astrid First Line Intervention',0,1,0.40,0,'bg-success',NULL),(147,1,'First Line Intervention - Hours',94.00,'First Line Intervention - Hours outside business hours',0,1,0.40,0,'bg-success',NULL),(148,1,'ON CALL',93.63,'BE_PASTRJ24001STM_ASTRID OnCall SOW 1_2_3_4',0,8,0.40,0,'bg-success',NULL),(149,1,'PM - NAM - HAI - BXL',93.63,'BE_PPROXI1905SVE01_ASTRID SLA - Preventive Maintenance',0,4,0.40,0,'bg-success',NULL),(150,1,'Project hours',93.63,'Project hours',0,1,0.40,0,'bg-success',NULL),(151,1,'Server upgrade ITEL',93.63,'BE_PPROXN2402SVE_ITEL server upgrade W2019',0,8,0.40,0,'bg-success',NULL),(152,1,'UA - HAI',93.63,'BE_PPROXI1905SVE02_ASTRID SLA - User Assistance',1,8,0.40,0,'bg-success',4),(153,1,'UA - BXL',93.63,'BE_PPROXI1905SVE02_ASTRID SLA - User Assistance',0,8,0.40,0,'bg-success',5),(154,1,'UA - LIE',93.63,'BE_PPROXI1905SVE02_ASTRID SLA - User Assistance',1,8,0.40,0,'bg-success',3),(155,1,'UA - LUX',93.63,'BE_PPROXI1905SVE02_ASTRID SLA - User Assistance',0,8,0.40,0,'bg-success',2),(156,1,'UA - NAM',93.63,'BE_PPROXI1905SVE02_ASTRID SLA - User Assistance',0,8,0.40,0,'bg-success',1),(157,11,'UA - GDL',93.63,'LUX_PPOGDL2601SVE_GDL SLA - User Assistance',1,8,0.40,0,'bg-success',6),(158,11,'COSTS - GDL',1.00,'Miscellaneous Costs',1,1,0.40,0,'bg-success',6);

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `default_company_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `default_company_id` int DEFAULT NULL,
  `last_ts_company_id` int DEFAULT NULL,
  `accounting_period_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_E545A0C5BF806DC3` (`accounting_period_id`),
  KEY `IDX_E545A0C5DFB84EB5` (`default_company_id`),
  CONSTRAINT `FK_E545A0C5BF806DC3` FOREIGN KEY (`accounting_period_id`) REFERENCES `accounting_period` (`id`),
  CONSTRAINT `FK_E545A0C5DFB84EB5` FOREIGN KEY (`default_company_id`) REFERENCES `company` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (1,'',3,1,6);

--
-- Table structure for table `site`
--

CREATE TABLE `site` (
  `id` int NOT NULL AUTO_INCREMENT,
  `company_id` int DEFAULT NULL,
  `code` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL,
  `note` longtext COLLATE utf8mb4_unicode_ci,
  `mileage` int NOT NULL,
  `time_zone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_694309E4979B1AD6` (`company_id`),
  CONSTRAINT `FK_694309E4979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `site`
--

INSERT INTO `site` VALUES (1,1,'CIC_NAM','NAM','BE','Namur',NULL,1,NULL,20,NULL),(2,1,'CIC_LUX','LUX','BE','Arlon',NULL,1,NULL,300,NULL),(3,1,'CIC_LIE','LIE','BE','Liège',NULL,1,NULL,126,NULL),(4,1,'CIC_HAI','HAI','BE','Mons',NULL,1,NULL,160,NULL),(5,1,'CIC_BXL','BXL','BE','Bruxelles',NULL,1,NULL,130,NULL),(6,1,'CIC_GDL','GDL','LU','Luxembourg',NULL,1,NULL,390,NULL);

--
-- Table structure for table `tax_calendar_entry`
--

CREATE TABLE `tax_calendar_entry` (
  `id` int NOT NULL AUTO_INCREMENT,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `start` date NOT NULL,
  `end` date DEFAULT NULL,
  `single_day` tinyint(1) NOT NULL,
  `category` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `accounting_period_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_B132FC6EBF806DC3` (`accounting_period_id`),
  CONSTRAINT `FK_B132FC6EBF806DC3` FOREIGN KEY (`accounting_period_id`) REFERENCES `accounting_period` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tax_calendar_entry`
--

INSERT INTO `tax_calendar_entry` VALUES (1,'Précompte professionnel','2020-01-15',NULL,1,'Precompte',1),(2,'TVA 4ème trimestre','2019-10-20','2020-01-20',0,'TVA',1),(3,'Listing annuel des clients assujettis à la tva','2020-03-31',NULL,1,'INFO',1),(4,'Précompte professionnel','2020-04-15',NULL,1,'Precompte',1),(5,'Précompte professionnel','2020-07-15',NULL,1,'Precompte',1),(6,'Précompte professionnel','2020-10-15',NULL,1,'Precompte',1),(7,'TVA 1er trimestre','2019-01-21','2020-04-20',0,'TVA',1),(8,'TVA 2eme trimestre','2020-04-21','2020-07-20',0,'TVA',1),(9,'TVA 3eme trimestre','2020-07-21','2020-10-20',0,'TVA',1),(10,'Déclaration à l\'impôt des personnes physiques et des sociétés','2020-06-30',NULL,1,'INFO',1),(11,'Acompte sur le précompte professionnel du 4e trimestre','2020-12-15',NULL,1,'INFO',1),(12,'Paiement d\'un acompte à la tva','2020-12-24',NULL,1,'INFO',1);

--
-- Table structure for table `time_sheet`
--

CREATE TABLE `time_sheet` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `invoice_id` int DEFAULT NULL,
  `performance` decimal(6,2) NOT NULL,
  `mileage` int DEFAULT NULL,
  `rem_client` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `rem_internal` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `cdts` datetime DEFAULT NULL,
  `processed` tinyint(1) NOT NULL,
  `deleted` tinyint(1) NOT NULL,
  `estimate_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_C24E709E166D1F9C` (`project_id`),
  KEY `IDX_C24E709E2989F1FD` (`invoice_id`),
  KEY `IDX_C24E709E85F23082` (`estimate_id`),
  CONSTRAINT `FK_C24E709E166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_C24E709E2989F1FD` FOREIGN KEY (`invoice_id`) REFERENCES `invoice` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_C24E709E85F23082` FOREIGN KEY (`estimate_id`) REFERENCES `estimate` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=2097 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `time_sheet`
--

INSERT INTO `time_sheet` VALUES (2093,152,NULL,8.00,160,NULL,NULL,'2026-07-29 11:00:00',0,0,NULL),(2094,153,NULL,8.00,130,NULL,NULL,'2026-08-05 11:00:00',0,0,NULL),(2095,152,NULL,8.00,160,NULL,NULL,'2026-08-12 11:00:00',0,0,NULL),(2096,152,NULL,8.00,160,NULL,NULL,'2026-08-19 11:00:00',0,0,NULL);

--
-- Dumping routines for database 'wefeatitkcdba'
--


