-- 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 `cpt_tbl_comptable`
--

DROP TABLE IF EXISTS `cpt_tbl_comptable`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cpt_tbl_comptable` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fk_transaction_id` int NOT NULL,
  `fk_num_compte` varchar(8) NOT NULL,
  `debit` decimal(13,2) DEFAULT '0.00',
  `credit` decimal(13,2) DEFAULT '0.00',
  `devise` varchar(3) NOT NULL,
  `fk_idworkday` int NOT NULL,
  `id_app` int DEFAULT '0' COMMENT 'cfr id Société',
  PRIMARY KEY (`id`),
  KEY `cpt_fk_num_compte` (`fk_num_compte`),
  KEY `cpt_fk_transaction_id` (`fk_transaction_id`),
  KEY `cpt_fk_idworkday` (`fk_idworkday`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cpt_tbl_comptable`
--

LOCK TABLES `cpt_tbl_comptable` WRITE;
/*!40000 ALTER TABLE `cpt_tbl_comptable` DISABLE KEYS */;
INSERT INTO `cpt_tbl_comptable` VALUES (1,1,'605700',610.00,0.00,'USD',1,2),(2,1,'401101',0.00,610.00,'USD',1,2),(3,2,'605700',90.00,0.00,'USD',1,2),(4,2,'401101',0.00,90.00,'USD',1,2),(5,3,'605700',265.00,0.00,'USD',1,2),(6,3,'401101',0.00,265.00,'USD',1,2),(7,4,'605700',210.00,0.00,'USD',1,2),(8,4,'401101',0.00,210.00,'USD',1,2),(9,5,'605700',425.00,0.00,'USD',1,2),(10,5,'401101',0.00,425.00,'USD',1,2),(11,6,'605700',685.00,0.00,'USD',1,2),(12,6,'401101',0.00,685.00,'USD',1,2),(13,7,'605700',965.00,0.00,'USD',1,2),(14,7,'401101',0.00,965.00,'USD',1,2),(15,8,'605700',550.00,0.00,'USD',1,2),(16,8,'401101',0.00,550.00,'USD',1,2),(17,9,'605700',750.00,0.00,'USD',1,2),(18,9,'401101',0.00,750.00,'USD',1,2),(19,10,'605700',550.00,0.00,'USD',1,2),(20,10,'401101',0.00,550.00,'USD',1,2),(23,12,'521100',0.00,600.00,'USD',1,2),(24,12,'401101',600.00,0.00,'USD',1,2),(25,13,'571200',0.00,10.00,'USD',1,2),(26,13,'401101',10.00,0.00,'USD',1,2),(27,14,'431810',150.00,0.00,'USD',1,2),(28,14,'431820',0.00,150.00,'USD',1,2),(29,15,'101000',10.00,0.00,'USD',1,2),(30,15,'106100',0.00,10.00,'USD',1,2),(31,16,'702100',0.00,73860.55,'USD',17,5),(32,16,'443000',0.00,11817.63,'USD',17,5),(33,16,'411101',85678.18,0.00,'USD',17,5),(34,17,'571100',85678.18,0.00,'USD',20,5),(35,17,'411101',0.00,85678.18,'USD',20,5),(47,19,'129000',25770.24,0.00,'USD',14,5),(48,19,'130900',0.00,25770.24,'USD',14,5),(49,20,'604300',205.68,0.00,'USD',17,5),(50,20,'604200',3058.66,0.00,'USD',17,5),(51,20,'604400',17973.83,0.00,'USD',17,5),(52,20,'605100',24.61,0.00,'USD',17,5),(53,20,'605200',1564.16,0.00,'USD',17,5),(54,20,'605500',41.73,0.00,'USD',17,5),(55,20,'605600',89.89,0.00,'USD',17,5),(56,20,'614000',1646.26,0.00,'USD',17,5),(57,20,'618300',194.66,0.00,'USD',17,5),(58,20,'622200',12000.00,0.00,'USD',17,5),(59,20,'622300',204.97,0.00,'USD',17,5),(60,20,'622201',6000.00,0.00,'USD',17,5),(61,20,'624200',4960.40,0.00,'USD',17,5),(62,20,'628300',1.77,0.00,'USD',17,5),(63,20,'628800',179.39,0.00,'USD',17,5),(64,20,'626600',995.45,0.00,'USD',17,5),(65,20,'631700',1.74,0.00,'USD',17,5),(66,20,'636400',109.58,0.00,'USD',17,5),(67,20,'632800',596.06,0.00,'USD',17,5),(68,20,'632400',1300.00,0.00,'USD',17,5),(69,20,'401101',0.00,51148.84,'USD',17,5),(70,21,'661200',606.64,0.00,'USD',17,5),(71,21,'661700',688.79,0.00,'USD',17,5),(72,21,'663800',11.54,0.00,'USD',17,5),(74,21,'401101',0.00,1306.97,'USD',17,5),(75,22,'571100',0.00,52362.14,'USD',20,5),(76,22,'401101',52362.14,0.00,'USD',20,5),(77,23,'443000',11817.63,0.00,'USD',18,5),(78,23,'702100',0.00,11817.63,'USD',18,5),(79,24,'628100',150.00,0.00,'USD',21,6),(80,24,'401101',0.00,150.00,'USD',21,6),(81,25,'895000',13.64,0.00,'USD',18,5),(82,25,'441000',0.00,13.64,'USD',18,5),(83,26,'571100',0.00,13.64,'USD',20,5),(84,26,'441000',13.64,0.00,'USD',20,5),(85,27,'661100',26294.10,0.00,'USD',18,5),(86,27,'422000',0.00,26294.10,'USD',18,5),(87,28,'571100',0.00,26294.10,'USD',20,5),(88,28,'422000',26294.10,0.00,'USD',20,5),(89,29,'641140',475.55,0.00,'USD',18,5),(90,29,'442220',0.00,475.55,'USD',18,5),(91,30,'571100',0.00,475.55,'USD',20,5),(92,30,'442220',475.55,0.00,'USD',20,5),(93,31,'641800',320.43,0.00,'USD',18,5),(94,31,'442800',0.00,320.43,'USD',18,5),(95,32,'571100',0.00,320.43,'USD',20,5),(96,32,'442800',320.43,0.00,'USD',20,5),(97,33,'647300',76.55,0.00,'USD',17,5),(98,33,'647400',16.82,0.00,'USD',17,5),(99,33,'442800',0.00,93.37,'USD',17,5),(100,34,'571100',0.00,93.37,'USD',20,5),(101,34,'442800',93.37,0.00,'USD',20,5),(102,35,'647200',308.33,0.00,'USD',19,5),(103,35,'442800',0.00,308.33,'USD',19,5),(104,36,'571100',0.00,308.33,'USD',20,5),(105,36,'442800',308.33,0.00,'USD',20,5),(106,37,'571100',0.00,38.50,'USD',20,5),(107,37,'421000',38.50,0.00,'USD',20,5),(108,38,'661100',399.19,0.00,'USD',18,5),(109,38,'666100',488.63,0.00,'USD',18,5),(110,38,'447210',0.00,887.82,'USD',18,5),(111,39,'571100',0.00,710.11,'USD',20,5),(112,39,'447210',710.11,0.00,'USD',20,5),(113,40,'442220',1200.00,0.00,'USD',23,6),(114,40,'401101',0.00,1200.00,'USD',23,6),(115,41,'111000',150.00,0.00,'USD',23,6),(116,41,'401101',0.00,150.00,'USD',23,6);
/*!40000 ALTER TABLE `cpt_tbl_comptable` 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:23
