-- MySQL dump 10.13  Distrib 8.0.41, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: db_access_02709
-- ------------------------------------------------------
-- Server version	8.0.40

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `immobilisation_test`
--

DROP TABLE IF EXISTS `immobilisation_test`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `immobilisation_test` (
  `idimmo` int NOT NULL,
  `compte` varchar(100) NOT NULL,
  `libelle` varchar(100) DEFAULT NULL,
  `composantde` varchar(100) DEFAULT NULL,
  `dateacq` date DEFAULT NULL,
  `montant` decimal(12,2) DEFAULT NULL,
  `montant_cdf` decimal(12,2) DEFAULT NULL,
  `devise` varchar(100) DEFAULT NULL,
  `periode` int DEFAULT NULL,
  PRIMARY KEY (`idimmo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='table TEST ';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `immobilisation_test`
--

LOCK TABLES `immobilisation_test` WRITE;
/*!40000 ALTER TABLE `immobilisation_test` DISABLE KEYS */;
INSERT INTO `immobilisation_test` VALUES (1,'223200','TERRAIN ILMMEUMBLE BUO','0','2014-05-19',900000.00,900000.00,'usd',0),(3,'231312','BATIMENT COMPOSANT ASCENSEUR','0','2014-05-19',26000.00,26000.00,'usd',6),(4,'244100','MATERIEL DE BUREAU','0','2012-11-28',522.00,522.00,'usd',1),(5,'244100','MATERIEL DE BUREAU','0','2015-10-07',6472.34,6472.34,'usd',3),(6,'244100','MATERIEL DE BUREAU','0','2015-10-31',1594.00,1594.00,'usd',3),(7,'244100','MATERIEL DE BUREAU','0','2015-11-30',3151.06,3151.06,'usd',3),(8,'244100','MATERIEL DE BUREAU','0','2015-12-31',3156.82,3156.82,'usd',3),(9,'244100','MATERIEL DE BUREAU','0','2016-02-25',1060.34,1060.34,'usd',3),(10,'244100','MATERIEL DE BUREAU','0','2018-01-12',235.00,380700.00,'usd',3),(11,'244200','MATERIEL INFORMATIQUE','0','2012-05-03',1955.12,1955.12,'usd',3),(12,'244200','MATERIEL INFORMATIQUE','0','2012-06-28',1380.00,1380.00,'usd',3),(13,'244200','MATERIEL INFORMATIQUE','0','2014-02-06',950.00,950.00,'usd',2),(14,'244200','MATERIEL INFORMATIQUE','0','2014-02-07',431.05,431.05,'usd',2),(15,'244200','MATERIEL INFORMATIQUE','0','2014-08-08',673.26,673.26,'usd',2),(16,'244200','MATERIEL INFORMATIQUE','0','2014-10-23',598.45,598.45,'usd',2),(17,'244200','MATERIEL INFOMATIQUE','0','2016-02-19',11.97,11.97,'usd',2),(18,'244200','MATERIEL INFORMATIQUE','0','2016-02-22',154.77,154.77,'usd',2),(19,'244200','MATERIEL INFORMATIQUE','0','2016-10-07',6650.00,6650.00,'usd',3),(20,'244200','MATERIEL INFORMATIQUE','0','2017-02-22',9000.00,9000.00,'usd',3),(21,'244200','MARERIEL INFORMATIQUE','0','2018-03-02',1520.00,2462400.00,'usd',3),(23,'235110','AMENAGEMENT DE BUREAU','0','2015-05-08',27.09,27.09,'usd',3),(24,'235110','AMENAGHEMENT DE BUREAU','0','2015-05-22',814.16,814.16,'usd',3),(25,'235110','AMENAGEMENT DE BUREAU','0','2015-05-22',109.16,109.16,'usd',3),(26,'235110','AMENAGEMENT DE BUREAU','0','2015-05-26',608.40,608.40,'usd',3),(27,'235110','AMENAGEMENT DE BUREAU','0','2015-05-26',17526.00,17526.00,'usd',3),(28,'235110','AMENAGEMENT DE BUREAU','0','2015-05-26',38.00,38.00,'usd',3),(29,'235110','AMENAGEMENT DE BUREAU','0','2015-06-01',12671.00,12671.00,'usd',3),(30,'235110','AMENAGEMENT DE BUEAU','0','2015-06-01',2189.68,2189.68,'usd',3),(31,'235110','AMENAGEMENT DE BUEAU','0','2015-06-02',1618.50,1618.50,'usd',3),(32,'235110','AMENAGEMENT DE BUREAU','0','2015-06-04',880.00,880.00,'usd',3),(33,'235110','AMENAGEMENT DE BUREAU','0','2015-06-04',3030.00,3030.00,'usd',3),(34,'235110','AMENAGEMENT DE BUREAU','0','2015-06-08',35.00,35.00,'usd',3),(35,'235110','AMENAGEMENT DE BUREAU','0','2015-06-10',1298.64,1298.64,'usd',3),(36,'235110','AMENAGEMENT DE BUREAU','0','2015-06-10',100.00,100.00,'usd',3),(37,'235110','AMENAGEMENT DE BUREAU','0','2015-06-12',575.00,575.00,'usd',5),(38,'235110','AMENAGEMENT DE BUREAU','0','2015-06-12',7000.00,7000.00,'usd',5),(39,'235110','AMENAGEMENT DE BUREAU','0','2015-06-12',4000.00,4000.00,'usd',5),(40,'235110','AMENAGEMENT DE BUREAU','0','2015-06-30',1000.00,1000.00,'usd',3),(41,'235110','AMENAGEMENT DE BUREAU','0','2015-07-02',130.65,130.65,'usd',3),(42,'235110','AMENAGEMENT DE BUREAU','0','2015-07-02',1100.00,1100.00,'usd',3),(43,'235110','AMENAGEMENT DE BUREAU','0','2015-07-07',3500.00,3500.00,'usd',3),(44,'235110','AMENAGEMENT DE BUREAU','0','2015-07-09',4.84,4.84,'usd',1),(45,'235110','AMENAGEMENT DE BUREAU','0','2015-07-11',10.87,10.87,'usd',1),(46,'235110','AMENAGEMEN DE BUREAU','0','2015-07-20',1528.00,1528.00,'usd',3),(47,'235110','AMENAGEMENT DE BUREAU','0','2015-07-21',89.78,89.78,'usd',1),(48,'235110','AMENAGEMENT DE BUREAU','0','2015-07-22',500.00,500.00,'usd',3),(49,'235110','AMENAGEMENT DE BUREAU','0','2015-07-22',31640.00,31640.00,'usd',3),(50,'235110','AMENAGEMENT DE BUREAU','0','2015-07-23',39.79,39.79,'usd',1),(51,'235110','AMENAGEMENT DE BUREAU','0','2015-07-23',175.00,175.00,'usd',3),(52,'235110','AMENAGEMENT DE BUREAU','0','2015-07-27',5.00,5.00,'usd',1),(53,'235110','AMENAGEMENT DE BUREAU','0','2015-07-27',76.09,76.09,'usd',1),(54,'235110','AMENAGEMENT DE BUREAU','0','2015-07-27',1912.50,1912.50,'usd',3),(55,'235110','AMENAGEMENT DE BUREAU','0','2015-07-27',500.40,500.40,'usd',3),(56,'235110','AMENAGEMENT DE BUREAU','0','2015-07-29',240.00,240.00,'usd',3),(57,'235110','AMENAGEMENT DE BUREAU','0','2015-07-31',660.03,660.03,'usd',3),(58,'235110','AMENAGEMENT DE BUREAU','0','2015-08-10',100.00,100.00,'usd',1),(59,'235110','AMENAGEMENT DE BUREAU','0','2015-08-11',264.00,264.00,'usd',3),(60,'235110','AMENAGEMENT DE BUREAU','0','2015-08-31',629.31,629.31,'usd',3),(61,'235110','AMENAGEMENT DE BUREAU','0','2015-08-31',400.00,400.00,'usd',3),(62,'235110','AMENAGEMENT DE BUREAU','0','2015-08-31',812.39,812.39,'usd',3),(63,'235110','AMENAGEMENT DE BUREAU','0','2015-09-16',1850.00,1850.00,'usd',3),(64,'235110','AMENAGEMENT DE BUREAU','0','2015-09-30',3984.19,3984.19,'usd',3),(65,'235110','AMENAGEMENT DE BUREAU','0','2015-11-06',9000.00,9000.00,'usd',3),(66,'235110','AMENAGEMENT DE BUREAU','0','2015-12-31',120.00,120.00,'usd',3),(67,'235110','AMENAGEMENT DE BUREAU','0','2017-03-21',60.65,60.65,'usd',3),(68,'235110','AMENAGEMENT DE BUREAU','0','2017-03-22',17810.00,17810.00,'usd',3),(69,'235110','AMENAGEMENT DE BUREAU','0','2017-04-04',16127.00,16127.00,'usd',3),(70,'235110','AMENAGEMENT DE BUREAU','0','2017-04-05',318.00,318.00,'usd',3),(71,'235110','AMENAGEMENT DE BUREAU','0','2017-05-05',1330.00,1330.00,'usd',3),(72,'235110','AMENAGEMENT DE BUREAU','0','2017-05-31',950.00,950.00,'usd',3),(73,'235110','AMENAGEMENT DE BUREAU','0','2017-07-06',721.98,721.98,'usd',3),(74,'235110','AMENAGEMENT DE BUREAU','0','2017-07-07',860.00,860.00,'usd',3),(75,'235110','AMENAGEMENT DE BUREAU','0','2017-11-08',1700.00,1700.00,'usd',3),(76,'235110','AMENAGEMENT DE BUREAU','0','2017-11-24',712.00,712.00,'usd',3),(77,'235110','AMENAGEMENT DE BUREAU','0','2018-03-07',1390.00,2262920.00,'usd',3),(78,'235110','AMENAGEMENT BUREAU / CFR DEVIS','0','2018-07-01',12000.00,0.00,'usd',3),(79,'244200','VF-57022411','0','2018-07-31',748.20,0.00,'usd',3),(82,'235110','AMENAGEMENT BUREAU','0','2018-08-01',5000.00,8200000.00,'usd',3),(83,'235110','AMENAGEMENT BUREAU','0','2018-08-01',2155.00,3534200.00,'usd',3),(84,'231311','BATIMENT STRUCTURE','0','2014-05-19',1063422.00,1063422.00,'usd',41),(85,'244200','VF-57029075 - USCT','0','2018-12-13',215.52,0.00,'usd',3),(87,'248800','VF-98 - MORGAN CONSTRUCTION - ','0','2018-12-19',568.45,0.00,'usd',3),(88,'244200','achat climatiseur 18000btu','0','2019-02-15',490.00,0.00,'usd',3),(89,'244200','ACHAT ORDINATEUR ET ONDULEUR I','0','2019-02-15',1050.00,0.00,'usd',3),(90,'235110','RETOUCHES AU LAVABLE DANS LE B','0','2019-04-04',136.00,0.00,'usd',3),(92,'213100','LOGICIEL BIGMANADJA','0','2019-01-02',37779.20,62713472.00,'usd',4),(93,'244200','VF-67007156 - ACHAT LAPTOP ET ','0','2019-02-27',8075.00,0.00,'usd',3),(1091,'244200','ACHAT ORDINATEUR  BUO / VF-570','0','2019-12-02',1700.00,0.00,'usd',3),(2092,'244200','ACHAT HP PROBOOK ','0','2019-12-23',2650.00,0.00,'usd',3),(2094,'235110','ACHAT SPLIT / VF-097','0','2019-11-09',600.00,0.00,'usd',3),(2096,'244200','ACHAT IMPRIMANTE PHOTOCOPIEUSE','0','2019-11-19',10950.00,18396000.00,'usd',4),(2097,'235110','ACHAT GROUPE ELECTROGENE 6 KVA','0','2019-11-21',1570.00,0.00,'usd',3),(2098,'244100','ACHAT MACHINE A LAVER 7KG/ VF-','0','2019-11-20',700.00,0.00,'usd',3),(2100,'245100','ACHJAT VEHICULE / FORTUNER - M','0','2019-11-06',17000.00,0.00,'usd',5),(2101,'244400','ACHAT CHAISE EN METAL POUR VIS','0','2019-12-18',350.00,0.00,'usd',3),(2102,'244200','FACTURE ACHAT ORDINATEUR DELL ','0','2020-02-13',1250.00,0.00,'usd',3),(2103,'244200','FACTURE ACHAT HP SCREEN LED / ','0','2020-05-28',275.00,0.00,'usd',3),(2104,'244100','ACHAT I PHONE 8 / USCT VF-5703','0','2020-05-05',650.00,1137500.00,'usd',3),(2105,'235110','TRAVAUX D\'AMENAGEMENT IMMEUBLE','0','2020-05-01',24617.00,43079750.00,'usd',3),(2106,'235110','TRAVAUX D\'AMENAGEMENT BUREAUX ','0','2020-05-01',27000.00,47250000.00,'usd',3),(2107,'244100','ACHAT FONTAINE ','0','2020-06-04',200.00,380000.00,'usd',3),(2108,'244200','ACHAT ORDINATEURS LENOVO / COM','0','2020-06-18',1370.00,2603000.00,'usd',3),(2109,'244200','ACHAT ORDINATEUR LENOVO / RH','0','2020-06-26',695.00,1320500.00,'usd',3),(2110,'244100','ACHAT IPHONE','0','2020-06-26',1500.00,2850000.00,'usd',3),(2116,'235110','ACHAT PARQUET DEUXIEME NIVEAU ','0','2020-08-06',9000.00,17100000.00,'usd',3),(3115,'244100','ACHAT MATERIEL DE BUREAU / SMA','0','2020-07-21',1500.00,2850000.00,'usd',3),(3116,'244400','MOBILIER DE BUREAU / CHAISE AV','0','2020-08-20',680.00,1292000.00,'usd',3),(3117,'244400','MOBILIER DE BUREAU / CHAISE DE','0','2020-08-20',210.00,399000.00,'usd',3),(3118,'244200','MATERIEL INFORMATIQUE / KIT VI','0','2020-07-21',1815.00,3448500.00,'usd',3),(3119,'235110','TRAVAUX TOITURE ','0','2020-10-19',12000.00,24000000.00,'usd',3),(3120,'244200','ACHAT ORDINATEUR / VF-57042931','0','2020-10-20',900.00,1800000.00,'usd',3),(3121,'244200','ACHAT ORDINAIRE LENOVO / VF-57','0','2020-10-23',900.00,1800000.00,'usd',3),(4119,'244200','ACHAT ORDINATEUR LENOVO / VF-5','0','2020-12-23',900.00,1800000.00,'usd',3),(4120,'244200','ACHAT ORDINATEUR DELL INSPIRON','0','2020-11-20',2180.00,4360000.00,'usd',3),(4121,'244200','ACHAT ORDINATEUR LENOVO / VF -','0','2020-11-20',2180.00,4360000.00,'usd',3),(4122,'244400','ACHAT MOBILIERS TABLES ET CHAI','0','2020-12-29',6786.00,13572000.00,'usd',3),(4123,'245100','ACHAT VOITURE DEFENDER / REF :','0','2014-05-01',21239.00,21239.00,'Usd',3),(4124,'235110','AMENAGEMENT BUTREAU','0','2019-12-31',8100.00,16200000.00,'Usd',3),(4125,'244400','MOBILIER DE BUREAU ','0','2012-03-31',13333.33,13333.33,'Usd',3),(4126,'244400','MOBILIER DE BUREAU','0','2012-07-09',1821.56,1821.56,'Usd',3),(4127,'244400','MOBILIER DE BUREAU','0','2012-07-09',300.00,300.00,'Usd',3),(4128,'244400','MOBILIER DE BUREAU ','0','2012-08-23',1669.63,1669.63,'Usd',3),(4129,'244400','MOBILIER DE BUREAU ','0','2012-09-28',4572.00,4572.00,'Usd',3),(4130,'244400','MOBILIER DE BUREAU','0','2012-11-08',2327.59,2327.59,'Usd',3),(4131,'244400','MOBILIER DE BUREAU ','0','2013-06-19',1155.17,1155.17,'Usd',3),(4132,'244200','MATERIEL INFORMATIQUE / VF-570','0','2021-01-10',265.00,530000.00,'Usd',3),(4133,'244200','MATERIEL INFORMATIQUE / ORDINA','0','2021-01-26',150.00,300000.00,'Usd',3),(4134,'244200','MATERIEL INFORMATIQUE / ORDINA','0','2021-01-26',1340.00,2680000.00,'Usd',3),(4135,'244200','MATERIEL INFORMATIQUE / ORDINA','0','2021-02-02',670.00,1340000.00,'Usd',3),(4136,'244400','MOBILIER DE BUREAU / CHAISE DE','0','2021-02-02',297.00,594000.00,'Usd',3),(4137,'244200','MATERIEL INFORMTIQUE / ORDINAT','0','2021-02-03',900.00,1800000.00,'Usd',3),(4138,'244200','MATERIEL INFORMATIQUE / ORDINA','0','2021-02-25',900.00,1800000.00,'Usd',3),(4139,'244200','MATERIEL INFORMATIQUE / ORDINA','0','2021-02-25',1340.00,2680000.00,'Usd',3),(4140,'244200','MATERIEL INFORMATIQUE / IMPRIM','0','2021-02-25',790.00,1580000.00,'Usd',3),(4141,'244400','MOBILIER DE BUREAU / TABLE DE ','0','2021-04-29',550.00,1300000.00,'Usd',3),(4142,'244400','MOBILIER DE BUREAU / CHAISE / ','0','2021-04-30',493.20,986400.00,'Usd',3),(4143,'244400','MOBILIER DE BUREAU / PUPITRE /','0','2021-04-30',281.80,563600.00,'Usd',3),(4144,'244100','MATERIEL DE BUREAU / TELEPHONE','0','2021-05-05',1705.00,3410000.00,'Usd',3),(4145,'244400','MOBILIER DE BUREAU / CHAISE ME','0','2021-05-05',400.00,800000.00,'Usd',3),(4146,'244200','MATERIEL INFORMATIQUE / ORDINA','0','2021-05-11',665.00,1330000.00,'Usd',3),(4147,'244100','MATERIEL DE BUREAU / SPLITS 90','0','2021-05-13',775.00,1550000.00,'Usd',3),(4148,'244200','MATERIEL INFORMATIQUE / ORDINA','0','2021-05-31',1300.00,2600000.00,'Usd',3),(4149,'244200','MATERIEL INFORMATIQUE / MOBILE','0','2021-05-31',570.00,1140000.00,'Usd',3),(4150,'244400','MOBILIER DE BUREAU / CHAISE CU','0','2021-05-31',370.00,740000.00,'Usd',3),(4151,'244100','MATERIEL DE BUREAU / TELEPHONE','0','2021-06-01',255.00,510000.00,'Usd',3),(4152,'244100','MATERIEL DE BUREAU / TV  PHILI','0','2021-06-03',990.00,1980000.00,'Usd',3),(4153,'244100','MATERIEL DE BUREAU / PACKAGE C','0','2021-06-03',2390.00,4780000.00,'Usd',3),(4154,'244100','MATERIEL DE BUREAU / MATERIAUX','0','2021-06-03',3700.00,7400000.00,'Usd',3),(4155,'244200','MATERIEL INFORMATIQUE / ORDINA','0','2021-06-24',1890.00,3780000.00,'Usd',3),(4156,'244400','MOPBILIER DE BUREAU / ACHAT CH','0','2021-07-26',1402.50,2805000.00,'Usd',3),(4157,'244400','MOBILIER DE BUREAU / ACHAT CHA','0','2021-07-26',4207.50,8415000.00,'Usd',3),(4158,'244400','MOBILIER DE BUREAU / ACHAT CHA','0','2021-07-26',3060.00,6120000.00,'Usd',3),(4159,'244200','MATERIEL INFORMATIQUE / ORDINA','0','2021-07-26',190.00,380000.00,'Usd',3),(4160,'244200','ACHAT ORDINATEURS LEVONO V15','0','2021-08-21',1300.00,2600000.00,'Usd',3),(4161,'244400','ANNULATION ACQUISITION / RETOU','0','2021-05-19',-405.00,-810000.00,'Usd',3),(4162,'244400','ACHAT MOBILIER DE BUREAU / ACH','0','2021-03-24',663.00,1326000.00,'Usd',3),(4163,'244200','ACHAT MATERIEL INFORMATIQUE / MACHINE DELL','0','2021-04-02',2540.00,5080000.00,'Usd',3),(4164,'244200','ACHAT MATERIEL INFORMATIQUE / MACHINE HP','0','2021-04-02',1270.00,2540000.00,'Usd',3),(4165,'244200','ANNULATION ACQUISITION / ORDIN','0','2021-07-26',-190.00,-380000.00,'Usd',0),(4166,'244200','ACHAT IMPRIMANRE TOSHIBA E-STU','0','2021-11-02',830.00,1660000.00,'Usd',3),(4167,'244100','ACHAT MATERIEL DE BUREAU / ACH','0','2021-11-24',600.00,1200000.00,'Usd',3),(4168,'244200','ACHAT ORDINATEUR / IT- JONATHA','0','2021-12-24',1000.00,2030000.00,'Usd',3),(4169,'244200','SORTIE IMMOBILISATION / PERTE ','0','2021-11-01',-1250.00,-2500000.00,'Usd',3),(4170,'244200','IMPRIMANTE EVOLIS PRIMACY 2','0','2022-05-24',1650.00,3366000.00,'Usd',3),(4171,'244200','ORDINATEUR LENOVO V15','0','2022-05-25',2750.00,5610000.00,'Usd',3),(4172,'244200','EVOLIS PRIMACY/SACO-664','0','2022-05-23',1645.00,3355800.00,'Usd',3),(4173,'244200','IMPRIMANTE EVOLIS/SACO-664','0','2022-05-23',1645.00,3355800.00,'Usd',3),(5170,'244200','LECTEUR D\'EMPRUNTS/0421','0','2022-07-16',420.00,856800.00,'Usd',3),(6170,'244200','LECTEUR D\'EMPRUNTS/01940','0','2022-07-26',280.00,571200.00,'Usd',3),(7170,'244200','ORDINATEUR LENOVO THINKBOOK 15','0','2022-08-05',1000.00,2040000.00,'Usd',3),(7171,'244200','ORDINATEUR SPECTRE','0','2022-09-09',2150.00,4386000.00,'Usd',3),(7174,'244100','CLIMATISEUR','0','2022-10-18',750.00,1530000.00,'Usd',3),(7175,'244100','REFRIGERATEUR','0','2022-11-07',240.00,489600.00,'Usd',3),(7176,'244200','BATTERIE ONDULEUR','0','2022-10-11',470.00,958800.00,'Usd',3),(7177,'244400','MATERIEL DE BUREAU','0','2022-12-06',2260.00,4610400.00,'Usd',3),(7179,'248800','IMMOBILISATION/DEVIS PORTE','0','2022-07-29',500.00,1020000.00,'Usd',3),(7180,'248800','IMMOBILISATION MATERIEL/SALE D','0','2022-08-30',240.00,489600.00,'Usd',3),(8176,'244100','MATERIEL DE BUREAU','0','2022-12-21',268.00,556100.00,'Usd',3),(8178,'235110','AMENAGEMENT BUREAU','0','2022-12-21',1300.00,2697500.00,'Usd',3),(8179,'244100','IMMOBILISATION POSE SPLIT','0','2022-12-21',265.00,549875.00,'Usd',3),(8180,'244100','IMMOBILISATION POSE SPLIT','0','2022-12-22',200.00,415000.00,'Usd',3),(8182,'248800','IMMOBILISATION CITERNE','0','2022-12-02',950.00,1971250.00,'Usd',3),(8183,'244200','FACTURE ACHAT DELL VOSTRO 3670','0','2023-01-07',600.00,1245000.00,'Usd',3),(8184,'235110','AMENAGEMENT DE BUREAU','0','2022-01-02',52040.00,105641200.00,'Usd',3),(8185,'235110','AMANAGEMENT DE BUREAU','0','2022-07-25',9975.00,20349000.00,'Usd',3),(8186,'248800','IMMOBILISATION BATTERY','0','2022-08-17',445.00,907800.00,'Usd',3),(9187,'244200','MATERIEL INFORMATIQUE/MONITEUR','0','2023-05-30',230.00,526700.00,'Usd',3),(10187,'244200','MATERIEL INFORMATIQUE/BATTERIE','0','2023-02-24',60.00,137400.00,'Usd',3),(10188,'244100','MATERIEL DE BUREAU','0','2023-03-17',285.00,652650.00,'Usd',3),(11187,'244100','IMMOBILISATION ANDROID LED TV','0','2023-02-24',3150.00,7213500.00,'Usd',3),(11188,'244200','IMMOBILISATION BATTERY','0','2023-08-10',70.00,171500.00,'Usd',3),(12187,'244100','IMMOBILISATION LED SLIM TV','0','2023-03-17',330.60,757074.00,'Usd',3),(12188,'244100','IMMOBILISATION CONGELATEUR 600','0','2023-04-28',1890.00,4328100.00,'Usd',3),(13187,'244200','IMMOBILISATION MATERIEL INFORM','0','2023-03-18',18260.00,41815400.00,'Usd',3),(13188,'244100','IMMOBILISATION MIDEA SPLIT 240','0','2024-01-12',690.00,1814700.00,'Usd',3);
/*!40000 ALTER TABLE `immobilisation_test` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-05-06 22:45:27
