-- Table structure for table `notification_ab_tests`
--

CREATE TABLE `notification_ab_tests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL COMMENT 'Nom du test A/B',
  `description` text DEFAULT NULL COMMENT 'Description du test',
  `notification_type` varchar(255) NOT NULL COMMENT 'Type de notification testé',
  `status` enum('draft','active','paused','completed') NOT NULL DEFAULT 'draft',
  `traffic_split` int(11) NOT NULL DEFAULT 50 COMMENT 'Pourcentage de trafic pour variant B (0-100)',
  `sample_size` int(11) DEFAULT NULL COMMENT 'Taille d''échantillon minimum',
  `confidence_level` decimal(5,2) NOT NULL DEFAULT 95.00 COMMENT 'Niveau de confiance statistique',
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `completed_at` datetime DEFAULT NULL,
  `primary_metric` varchar(255) NOT NULL DEFAULT 'click_through_rate' COMMENT 'Métrique principale',
  `secondary_metrics` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Métriques secondaires' CHECK (json_valid(`secondary_metrics`)),
  `auto_stop_enabled` tinyint(1) NOT NULL DEFAULT 1,
  `min_improvement` decimal(5,2) NOT NULL DEFAULT 5.00 COMMENT 'Amélioration minimale requise (%)',
  `min_conversions` int(11) NOT NULL DEFAULT 100 COMMENT 'Conversions minimales requises',
  `created_by` bigint(20) unsigned NOT NULL,
  `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`metadata`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notification_ab_tests_status_notification_type_index` (`status`,`notification_type`),
  KEY `notification_ab_tests_start_date_end_date_index` (`start_date`,`end_date`),
  KEY `notification_ab_tests_created_by_foreign` (`created_by`),
  CONSTRAINT `notification_ab_tests_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notification_ab_tests`
--


--
-- Table structure for table `notification_ab_variants`
--

CREATE TABLE `notification_ab_variants` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ab_test_id` bigint(20) unsigned NOT NULL,
  `variant_key` varchar(10) NOT NULL COMMENT 'A, B, C, etc.',
  `name` varchar(255) NOT NULL COMMENT 'Nom de la variante',
  `description` text DEFAULT NULL,
  `title` varchar(255) NOT NULL COMMENT 'Titre de la notification',
  `body` text NOT NULL COMMENT 'Corps de la notification',
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Données supplémentaires' CHECK (json_valid(`data`)),
  `icon` varchar(255) DEFAULT NULL,
  `badge` varchar(255) DEFAULT NULL,
  `actions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Actions de la notification' CHECK (json_valid(`actions`)),
  `priority` varchar(20) NOT NULL DEFAULT 'medium',
  `scheduling` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Paramètres de planification' CHECK (json_valid(`scheduling`)),
  `targeting` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Critères de ciblage' CHECK (json_valid(`targeting`)),
  `sent_count` int(11) NOT NULL DEFAULT 0,
  `delivered_count` int(11) NOT NULL DEFAULT 0,
  `clicked_count` int(11) NOT NULL DEFAULT 0,
  `dismissed_count` int(11) NOT NULL DEFAULT 0,
  `conversion_count` int(11) NOT NULL DEFAULT 0,
  `delivery_rate` decimal(5,2) NOT NULL DEFAULT 0.00,
  `click_through_rate` decimal(5,2) NOT NULL DEFAULT 0.00,
  `conversion_rate` decimal(5,2) NOT NULL DEFAULT 0.00,
  `dismiss_rate` decimal(5,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `notification_ab_variants_ab_test_id_variant_key_unique` (`ab_test_id`,`variant_key`),
  KEY `notification_ab_variants_ab_test_id_click_through_rate_index` (`ab_test_id`,`click_through_rate`),
  CONSTRAINT `notification_ab_variants_ab_test_id_foreign` FOREIGN KEY (`ab_test_id`) REFERENCES `notification_ab_tests` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notification_ab_variants`
--


--
-- Table structure for table `notification_templates`
--

CREATE TABLE `notification_templates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL COMMENT 'Type de notification (ex: mouvement_created, financial_request_updated)',
  `title_template` varchar(255) NOT NULL COMMENT 'Titre du template avec variables {module}, {title}, etc.',
  `body_template` text NOT NULL COMMENT 'Corps du message avec variables',
  `icon` varchar(255) DEFAULT NULL COMMENT 'Chemin vers icone notification',
  `action_url` varchar(255) DEFAULT NULL,
  `default_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`default_data`)),
  `is_active` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Template actif ou non',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `notification_templates_type_unique` (`type`),
  KEY `notification_templates_type_index` (`type`),
  KEY `notification_templates_is_active_index` (`is_active`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notification_templates`
--

INSERT INTO `notification_templates` VALUES
(1,'financial_requests_updated','? {module} modifié','Le {module} \"{title}\" (réf: {reference}) a été mis à jour','/assets/icons/update-notification.png','/admin/{module}/{id}','{\"action\": \"updated\", \"module\": \"financial_requests\", \"category\": \"business\", \"priority\": \"low\"}',1,'2025-12-18 19:54:38','2025-12-18 19:54:38');

--
-- Table structure for table `old_presale`
--

CREATE TABLE `old_presale` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(150) DEFAULT NULL,
  `name` varchar(150) DEFAULT NULL,
  `status` enum('A émettre','En cours','Emis') DEFAULT 'A émettre',
  `officeid_bk` varchar(255) DEFAULT NULL,
  `officeid_tk` varchar(255) DEFAULT NULL,
  `signinbooking` varchar(255) DEFAULT NULL,
  `signinticketing` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `paxtype` varchar(255) DEFAULT NULL,
  `traveldates` varchar(255) DEFAULT NULL,
  `booking_classes` varchar(255) DEFAULT NULL,
  `service_classes` varchar(255) DEFAULT NULL,
  `carrier` varchar(255) DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `action` varchar(255) DEFAULT NULL,
  `issue_type` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `tour_code` varchar(255) DEFAULT NULL,
  `fop` varchar(255) DEFAULT NULL,
  `actual_fop` varchar(255) DEFAULT NULL,
  `statistical_code` varchar(255) DEFAULT NULL,
  `subagents_country` varchar(255) DEFAULT NULL,
  `booking_terminal_id` varchar(255) DEFAULT NULL,
  `ticketing_terminal_id` varchar(255) DEFAULT NULL,
  `fare_currency` varchar(255) DEFAULT NULL,
  `fare_equiv_currency` varchar(255) DEFAULT NULL,
  `taxes_currency` varchar(255) DEFAULT NULL,
  `total_currency` varchar(255) DEFAULT NULL,
  `national_currency` varchar(255) DEFAULT NULL,
  `credit_currency` varchar(255) DEFAULT NULL,
  `passenger` varchar(255) DEFAULT NULL,
  `lastname` varchar(255) DEFAULT NULL,
  `firstname` varchar(255) DEFAULT NULL,
  `contacts` varchar(255) DEFAULT NULL,
  `fare_basis` varchar(255) DEFAULT NULL,
  `route` varchar(255) DEFAULT NULL,
  `flight_numbers` varchar(255) DEFAULT NULL,
  `mileage` varchar(255) DEFAULT NULL,
  `taxes_details` varchar(255) DEFAULT NULL,
  `ssr_docs` text DEFAULT NULL,
  `pnr_creation_date` date DEFAULT NULL,
  `depdate` date DEFAULT NULL,
  `arrdate` date DEFAULT NULL,
  `date` date DEFAULT NULL,
  `numberofsegments` int(11) DEFAULT NULL,
  `baggage` int(11) DEFAULT NULL,
  `airline_code` int(11) DEFAULT NULL,
  `fare` float DEFAULT NULL,
  `net_fare` float DEFAULT NULL,
  `fare_equiv` float DEFAULT NULL,
  `commission` float DEFAULT NULL,
  `commission_equiv` float DEFAULT NULL,
  `taxes` float DEFAULT NULL,
  `hf` float DEFAULT NULL,
  `service_fee` float DEFAULT NULL,
  `service_fee_vat` float DEFAULT NULL,
  `total` float DEFAULT NULL,
  `national_total` float DEFAULT NULL,
  `misc_fees` float DEFAULT NULL,
  `grand_total` float DEFAULT NULL,
  `currency_rate` float DEFAULT NULL,
  `net_remit` float DEFAULT NULL,
  `net_remit_grand_total` float DEFAULT NULL,
  `document_credit_total` float DEFAULT NULL,
  `sf_credit_total` float DEFAULT NULL,
  `credit_currency_rate` float DEFAULT NULL,
  `no` varchar(255) DEFAULT NULL,
  `subagent` varchar(255) DEFAULT NULL,
  `record_locator` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `source` varchar(255) DEFAULT NULL,
  `refund_fee` float DEFAULT NULL,
  `pnrs` varchar(255) DEFAULT NULL,
  `pnr_id` bigint(20) DEFAULT NULL,
  `etatsdevente_id` bigint(20) unsigned DEFAULT NULL,
  `external_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `modified_at` datetime DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `is_deleted` tinyint(4) DEFAULT 0,
  `created_by` bigint(20) unsigned DEFAULT 1,
  `account_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_old_presale_uuid` (`uuid`),
  UNIQUE KEY `uk_old_presale_name` (`name`),
  KEY `bmps_users_modified_by_FK` (`updated_by`) USING BTREE,
  KEY `presale_etatsdeventes_fk` (`etatsdevente_id`),
  KEY `old_presale_created_by_foreign` (`created_by`),
  KEY `old_presale_account_id_foreign` (`account_id`),
  KEY `old_presale_pnr_id_foreign` (`pnr_id`),
  CONSTRAINT `old_presale_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `old_presale_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `old_presale_pnr_id_foreign` FOREIGN KEY (`pnr_id`) REFERENCES `pnr` (`id`) ON DELETE SET NULL,
  CONSTRAINT `old_presale_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `presale_etatsdeventes_fk` FOREIGN KEY (`etatsdevente_id`) REFERENCES `etatsdeventes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `old_presale`
--


--
-- Table structure for table `pnr`
--

CREATE TABLE `pnr` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `uuid` varchar(100) NOT NULL,
  `date` date DEFAULT NULL,
  `action` varchar(45) DEFAULT NULL,
  `status` enum('En attente','A émettre','En cours','Emission partielle','Emis') NOT NULL DEFAULT 'A émettre',
  `passenger` int(11) DEFAULT 0,
  `unticketed` int(11) DEFAULT 0,
  `ticketed` int(11) DEFAULT 0,
  `emd` int(11) DEFAULT 0,
  `segment` int(11) DEFAULT 0,
  `account_id` bigint(20) unsigned DEFAULT NULL,
  `is_deleted` tinyint(4) DEFAULT 0,
  `created_by` bigint(20) unsigned DEFAULT 1,
  `updated_by` bigint(20) unsigned DEFAULT 1,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `air_raw_content` longtext DEFAULT NULL COMMENT 'Contenu brut du fichier AIR',
  `air_json` longtext DEFAULT NULL COMMENT 'AIR converti en JSON',
  `estair_json` longtext DEFAULT NULL COMMENT 'JSON final format ESTAIR',
  PRIMARY KEY (`id`),
  UNIQUE KEY `pnr_unique` (`name`),
  UNIQUE KEY `pnr_unique_1` (`uuid`),
  KEY `pnr_accounts_FK` (`account_id`),
  KEY `pnr_created_by_foreign` (`created_by`),
  KEY `pnr_updated_by_foreign` (`updated_by`),
  CONSTRAINT `pnr_accounts_FK` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`),
  CONSTRAINT `pnr_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `pnr_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=326 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pnr`
--

INSERT INTO `pnr` VALUES
(1,'X7ZVKH','d426926b-042f-45b6-92eb-faf3960d434e',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(2,'ZOKW9L','67597f6e-67ec-41f8-9f29-4839ac87868c',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(3,'ZOCV4I','aa387819-8430-42cd-9901-de9ccdb7d129',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(4,'Y6283C','1a69670c-9a74-438c-b5a3-b0356aa7c167',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(5,'YB2YWT','a8f64414-d3a4-406f-8667-813d73f427ff',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(6,'X4LBW7','fea341e2-ee3c-442f-92bd-52ef49c5a5cd',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(7,'X2KBV5','9037c6b1-2575-4fb8-8c5b-fb3bfb9dfb16',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(8,'XQOBLO','d0da8ecd-c435-4058-a833-a68452d7ddb6',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(9,'Y9AE9W','c9d986f1-40cb-4d15-955a-099bf16f3643',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(10,'Y7NGE4','a86791da-a30c-4991-a742-f9424f84c0f1',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(11,'Y4LS7J','0f315399-b32e-4d29-895d-a14c130d8838',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(12,'Y5X6IA','7dd95723-32eb-4c2e-9367-3179771ba5c9',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(13,'XTLR34','7cb72235-fce5-4f5f-b5df-fa0027b77fa0',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(14,'YPT76J','f2b58929-6c38-4f11-86e6-2d72de4025c3',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(15,'Y9DTTX','71f6673f-afa3-44d0-9aea-ff1cc352eb67',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(16,'YQW96R','c044d428-5ab6-4c25-bda0-89813239ab1e',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(17,'YQA5PI','b87aaad4-c392-419c-8462-26e477956994',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(18,'YQBDO4','336c6a9a-17ca-4b10-9997-582c5f67faf7',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(19,'YPKFN6','b9184785-f3fd-4588-9bc5-c85560694eaf',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(20,'YLO2LH','295c3686-c356-45cc-b2ff-989e76d588a2',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(21,'X7YYBH','ed4d9bc5-8a1e-48ed-bcaa-aa5e96228072',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(22,'YLTKAU','c2bd488f-5ae0-4b49-950f-80ed4a455714',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(23,'Y55R6Z','c9fb7ad8-208a-4300-9266-fbb821acdc3e',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(24,'ZSEQYR','2c484a0f-b5d0-4756-a563-097fed6b8968',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(25,'NI3ACZ','f8e5f2b6-6eef-44bb-938c-3d3911a03c1f',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(26,'VEP26H','d42cc325-a84b-4b4b-892d-3670a31e740d',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(27,'TSRL5J','bd241979-cbd0-4e19-b246-957920872215',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(28,'Y5RO6N','a61ebb07-857b-444f-b2f4-dfb470fd6060',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(29,'YSHFWY','0cfbb2be-6c2f-4cf3-a504-d671d1740aa8',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(30,'Z8O5KS','c2f61911-6867-4466-b298-b7dc83c1d629',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(31,'Z2E8SC','aa69ab5c-83fd-481e-9a26-b6cf36be9d66',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:23','2026-03-26 17:21:23',NULL,NULL,NULL),
(32,'YUQZTO','7c3f84ce-9886-4c32-a590-ecb3d9bac073',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(33,'Z49Y5Y','e4e0e62f-6385-4578-852d-9e2107ab673c',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(34,'XAPFX4','708b5996-d0ae-4214-991f-9e3f9305f217',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(35,'ZMVHTF','9ea0bab2-30d2-492e-a12d-9726d90a34a1',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(36,'XUET6C','d5a9a194-b5c2-4c6a-ad6b-5d80790d966f',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(37,'YL5PXN','a2cff376-4054-4f4b-90e0-6a6db03ae522',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(38,'Z2DNRU','d04b745b-b323-46fe-9c2c-046c75f9684e',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(39,'YPI7TZ','a50da715-1aba-446b-a082-4cfacacb948b',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(40,'YPWHZU','0a915fa7-5589-46b6-afde-98a13222b256',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(41,'ZMT8DC','d45e30f1-754b-4090-b9ff-62447c245588',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(42,'ZAB9R3','227a6932-176e-4329-87bd-141625d44a4c',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(43,'ZARF6G','226c338b-b5c2-4724-8e8b-f1bfbacc5843',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(44,'Z6SJGO','88af3816-6a82-42dd-b719-d78a8cb9678a',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(45,'ZB4N5G','59f9c8b4-64bb-49d4-8254-a86517116dc2',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(46,'Z54FXP','819c4dd0-c6e4-422a-943a-5a4bf4fa1e40',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(47,'Z4SWEL','eb0f036f-c3f3-4f89-9ba9-4e19c3a28812',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(48,'X5MR82','660bccd6-0979-4cb6-8089-e889dcedef6c',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(49,'ZWHEWU','a1c65a94-776a-4618-8bf7-b72f8a8e179a',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(50,'X6WBIX','64b53fbb-edca-4078-b230-18634a1a64c3',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(51,'XBS52E','b09d269e-7855-47a7-b922-5c57e7b9cde7',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(52,'XBMOKC','80b9276e-8c50-40fc-8583-4b4a83af335a',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(53,'X9XXGM','d838a85c-dffd-45b4-991d-0767a6b1df79',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(54,'X6EE8S','544e9ece-89af-4449-830f-978794cc5f03',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:24','2026-03-26 17:21:24',NULL,NULL,NULL),
(55,'XAYSRX','f5bb28fe-ac3b-45b6-8507-17e134d81a09',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(56,'YLGOKQ','d52d6867-ed74-4db2-abc4-9afe840d3b8d',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(57,'XAAM5T','114a5089-624c-4510-a501-f9838991ce67',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(58,'X9Z9A3','3fa86f0c-5f7f-48fe-b724-0383521dabaa',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(59,'ZORQGV','b54de52a-7f9e-48f3-86bb-c20ec3d6848e',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(60,'X8WPBB','1affc922-3475-4355-9b26-93de90af149d',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(61,'ZNGP2R','1657da80-4fa6-436d-bd4d-c298dbfdcbbf',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(62,'X89JQV','d8f5ae77-5d7f-41ab-a902-974fc09e3bf9',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(63,'X6QNP7','67e0cca3-2c5a-4b44-97a3-da5426356088',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(64,'ZNDJ5C','4154b939-6178-44a3-84aa-419b196d9f21',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(65,'ZQQUCB','dcc73496-3704-4c94-b2fc-d02fe0abc1e4',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(66,'Z6CFQ5','eba166d3-9755-4c5e-931e-caa4067a26f9',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(67,'YM9S2J','fe5d0edc-f7cf-44d9-849e-c5ab002eb350',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(68,'X7ICXN','41320366-8d13-4642-8d32-e20d682aba32',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(69,'X6GMMG','659fa5cb-f0ab-44b2-ab52-b32d5b297ee4',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(70,'ZPKM2W','fb571dc5-dbc7-4ed9-a5e0-5b7285efb47e',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(71,'Z5KOII','c472f949-f625-4795-a134-742b2886ecef',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(72,'ZR5C75','2ec65063-100c-4871-9ae4-b16da49c8de0',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(73,'ZQDHOE','de50d147-8717-4809-a5cd-90ef9e8b45b9',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(74,'YMMDCH','b9620edf-59f3-4e77-a14d-8a0f0b3684e8',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(75,'ZWJC5F','aa000270-437a-40c2-8092-46dc3c79fa47',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(76,'Z2ZKVZ','58eb8b8b-35d5-4bf9-acb5-7516b0a6b54b',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(77,'YKTU34','36f548ed-e594-443f-b32f-e0a632de6a92',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(78,'XQCY7W','04e348b9-bf7a-4b8b-80c3-b5bb41897ad1',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(79,'XQJBQB','d4a47868-bed9-4a04-81b6-eabc9cf76a94',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:25','2026-03-26 17:21:25',NULL,NULL,NULL),
(80,'XPX6RO','c317f314-4a9e-4f24-9ddc-02e111e267f5',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(81,'XAI4C8','4f8170ca-09d3-4b8a-b3ab-e8a634603605',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(82,'XATFCV','0e2a691f-4fb1-4d17-b2c5-9940d7c71203',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(83,'XOEFC5','9c555079-e6af-45e3-831e-8897ac5a3437',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(84,'Y37852','1f10663f-5796-48bd-b9bd-9a95fbd89c20',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(85,'XJZZC5','9e8deaa4-4960-4762-a8af-f3d132d9426e',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(86,'Z6UZ4O','b32b4432-50b3-470b-98a2-da4d2d0f1a7e',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(87,'YAXN3H','924a0e07-1171-4d1c-8c4c-ef7843d83b1e',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(88,'ZA3JWI','75e5bfcc-f5e6-4a15-a698-5c56bea6516f',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(89,'XC5847','c46d92ca-7c50-4f8c-b1b5-2cb7d278ee87',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(90,'YDKTUR','1c380de0-5a92-4c36-af58-844b0c47b27c',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(91,'YCUG26','417027fa-fc32-466e-b72f-3edd9c5eeb3e',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(92,'XE3J4G','f316f44d-ab0e-426b-ab05-97545cc76c7b',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(93,'Z8EPGA','f94549ab-3db7-409e-8f82-996aecc5def5',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(94,'XTTOQY','fe29830b-6432-4844-88b9-173f39b34ed8',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(95,'XPQ7UW','4790f456-9ed5-4f0c-8708-6341ad6a5401',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(96,'Y5F7AG','885558c0-a3c5-447b-bc0b-58fafeeaf7f3',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(97,'Z9XEUB','b58bb544-7dcf-4287-b76e-e4e02f98a310',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(98,'ZEVDB2','1130242d-1355-4141-9932-2e577cb7233a',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(99,'X9QZEU','880cc1d0-d1bb-4fd5-a17e-5810095cef64',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(100,'X8BUKA','2e28a9c1-fe2f-4853-a04a-28f6fd13b6f5',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(101,'YSMXHH','1b0760f6-0e13-4be5-9d0f-e42b949f8d6a',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(102,'X9W8MI','ba761c5c-4534-4fb1-b651-41a775af0b60',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(103,'YW3ID7','8225d374-80d9-4e0e-bb20-2ce02d32fb6d',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(104,'ZDNB8K','0878f3c1-c359-4a1c-a8e4-553fc9d41436',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(105,'ZC3N8G','e1034f2c-a302-42a0-8431-0c34e200d988',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(106,'Z8X8XP','2148ff10-b9ae-478c-8060-18840d5dab6c',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(107,'YQLMVQ','3fcae8b0-2beb-47ee-aafa-d02ab267fe16',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(108,'XCFAK8','3f171dc2-83f5-4a11-be67-2f0123e2a0f3',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(109,'YQIHC3','add7431b-0cfb-41e0-ab92-71170d829721',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(110,'Z2S7HN','dd53714d-f802-4f05-b896-84b0a0781171',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:26','2026-03-26 17:21:26',NULL,NULL,NULL),
(111,'X5CUH5','aca7fb1b-0a86-43ac-ac51-e167c1a80e51',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(112,'Z6MX4I','85ed67c5-2329-475f-859f-9a7a9a909914',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(113,'Z4IFVJ','89c48636-98e1-4522-9639-61ac6b5c7aa4',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(114,'YOKD72','c85c0015-144a-48f1-af85-70f203b0c46a',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(115,'YQYBYF','4dfe4dc9-e3dc-4066-9ace-8c1345ad6c0a',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(116,'ZVPA39','57ac4058-2371-4ade-8395-98a4a7e72e04',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(117,'Z7R2WC','f292b9e7-f95c-410f-ad9a-2ff498ba94a0',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(118,'ZU85MW','88022dce-1f61-4eb1-a904-5dee57f006b4',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(119,'Z697JH','fdad6b33-9c50-4980-9bc6-d673a1ed4d5d',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(120,'ZQMY27','7ef68e33-0394-47e1-9710-01ce3c7e0cf8',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(121,'YP7HFF','9fd7db33-db24-4c65-b32d-f958965f1607',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(122,'ZPXX7H','f418b6b4-e5cb-44a8-a241-b98bb9fcb96a',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(123,'Z5HB9F','ca589c17-7c9e-436c-baf5-331f33010981',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(124,'Z9ILVS','cebb0b52-8048-4463-8f29-51a8b94fcb38',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(125,'ZAKQ6J','fbbc9733-680f-4ee8-95df-0fcb2373eff1',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(126,'Z6C4EC','9f3a1805-d29c-47a9-ba37-b1858bf47fc2',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(127,'X5ZB3R','5657d2f4-e249-4b21-a009-28d11cf6dc40',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(128,'XF7RQX','9c67f738-582a-4170-8936-d4204f90d5c8',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(129,'ZVH3ZL','26a7b0e4-72f0-4fda-9ebf-d03690f29522',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(130,'X85GCZ','ba81ebad-a404-41d1-91f2-716b105c38db',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(131,'ZCEYSO','27c6c3cd-0379-46b4-92b9-e79b7d6c1f18',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(132,'X7WXH5','c05b68d5-78a7-429f-9fbb-e7cc09490f98',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(133,'ZNUFNL','4e164e29-99c6-4efb-aee3-77a54d14078f',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(134,'X8V8LI','2b510296-af3e-453b-9926-898160bb52a9',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(135,'X8TO4P','bf254be1-261a-436d-b82b-b34ba074bcf1',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:27','2026-03-26 17:21:27',NULL,NULL,NULL),
(136,'ZDKVAC','d32df7e3-5292-40cc-ba46-00c94287509f',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:28','2026-03-26 17:21:28',NULL,NULL,NULL),
(137,'ZT3RZ3','f711e822-46c7-4140-b438-dc7ef24ca840',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:28','2026-03-26 17:21:28',NULL,NULL,NULL),
(138,'XAWGBY','0464c876-f108-4cae-bd8a-8e5e2cedc11b',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:28','2026-03-26 17:21:28',NULL,NULL,NULL),
(139,'ZD2IGP','515cf08c-4923-4c4e-8d7c-36d1056d6cda',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:28','2026-03-26 17:21:28',NULL,NULL,NULL),
(140,'ZD3OON','c75790eb-8fea-4f4a-ab2c-f9e752c7f7ca',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:28','2026-03-26 17:21:28',NULL,NULL,NULL),
(141,'YPORQS','bb5707b7-36d4-4f6a-aadb-c4a3a4f0f585',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:28','2026-03-26 17:21:28',NULL,NULL,NULL),
(142,'ZRAT3Y','c0365c56-ae15-430e-b966-f04c84fb6042',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:28','2026-03-26 17:21:28',NULL,NULL,NULL),
(143,'X8PGYA','99ff02c0-44e8-44c7-a0e3-77b4422a8be9',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:28','2026-03-26 17:21:28',NULL,NULL,NULL),
(144,'X796WQ','c423ed9e-50b3-422f-8d11-37638e8834b2',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:28','2026-03-26 17:21:28',NULL,NULL,NULL),
(145,'XTP4AT','effe94fa-e450-43d3-a6ce-00a2dbc47a08',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:28','2026-03-26 17:21:28',NULL,NULL,NULL),
(146,'X9HG7C','079ec5b6-76e6-4cec-be2e-ed52b368d4a4',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:28','2026-03-26 17:21:28',NULL,NULL,NULL),
(147,'XGNOYW','0b62966f-f47a-4614-aebe-f093ce840b41',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:28','2026-03-26 17:21:28',NULL,NULL,NULL),
(148,'XGQBSP','69ffeb70-d065-45d3-b817-fa670b571890',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:28','2026-03-26 17:21:28',NULL,NULL,NULL),
(149,'XGVO5Q','3511fe15-219d-4778-9d1c-af907d98b0fd',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:28','2026-03-26 17:21:28',NULL,NULL,NULL),
(150,'XOCV8Y','fdb369a2-0ae2-484e-8cb0-8b4783469b94',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:28','2026-03-26 17:21:28',NULL,NULL,NULL),
(151,'ZRXUSB','0458d46b-e5bb-42d5-bf85-5ede03f8b5e2',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:28','2026-03-26 17:21:28',NULL,NULL,NULL),
(152,'XPTZ6N','236db5e4-e0d4-41bc-9bfe-d325d28e5520',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:28','2026-03-26 17:21:28',NULL,NULL,NULL),
(153,'XG2TA2','311dcd49-f3e1-41b7-8340-227f2d1aeabf',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:28','2026-03-26 17:21:28',NULL,NULL,NULL),
(154,'XBTGYD','dbaa5445-dc0f-43bc-8a4a-5963f32ef363',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:28','2026-03-26 17:21:28',NULL,NULL,NULL),
(155,'7C6U7A','512ae7ec-391c-416d-b206-5cf1384c12ab',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:28','2026-03-26 17:21:28',NULL,NULL,NULL),
(156,'YC95HG','187d7b9d-f659-43f7-8380-2e2d6ec7e38d',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:28','2026-03-26 17:21:28',NULL,NULL,NULL),
(157,'XNQQ9Y','eb8f0f7c-7b3d-48be-87ca-7ba876a58b1a',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:28','2026-03-26 17:21:28',NULL,NULL,NULL),
(158,'X674AC','7138a0d7-e9b7-4dd6-b716-5c189b669ed2',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(159,'ZAQK7S','201dcd6a-b094-4046-b701-6c578eabe560',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(160,'Y8TV4Z','54a84bce-4a3e-42df-826c-fd6b984c2a35',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(161,'Y9FZ9Q','56f06e3e-ffdb-4878-b41e-8e9549bdaf13',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(162,'XRUN2E','6d6d0bdc-9ecd-47c5-95b5-547d74489844',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(163,'XVLILS','953d2928-3930-44df-8103-d0ff358bf529',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(164,'YATH6X','bbb5ad59-b3e4-41ce-b491-fbe41e7f66e3',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(165,'XPGYB9','4fea16c0-457e-40a3-8fd9-6eabfe44b4c8',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(166,'XPKQ2T','85d9459e-db56-444d-9509-f739ff9dbfaa',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(167,'XRFYKF','8b9fc0c7-cc8c-43fe-bc7f-a30aab531985',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(168,'Y94S87','c244956a-6987-4781-a3b3-ea0c071ffe44',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(169,'ZEB9NC','f91c03a7-32c9-42bd-ab08-24a393f723bd',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(170,'XWFICO','d305f64b-2855-4066-bb64-2591fb96f8e8',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(171,'XKRKAY','f8208334-f022-45c8-86f9-53dc6fc4fb04',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(172,'XKRF7H','ff1929ef-c596-471a-bd11-2de24be96c2d',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(173,'ZUO4LN','5038a5aa-4182-47c4-9c62-c4fa9aa4c15a',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(174,'XS9JFD','f09052a2-c291-4255-8cb2-64ded2782461',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(175,'YVPPUC','07fea362-46b6-455a-b637-ebfbd26bd351',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(176,'XUSYHS','b554499e-ac51-4d6c-a8c1-795a356c47be',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(177,'YQ6SNG','9e0dc843-815b-4160-907b-487d37044f80',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(178,'YDZGTB','f0f8b44c-02e7-4f10-a895-7bb43ccebe5f',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(179,'X9AOK7','1e6c6da7-d337-4c1c-8432-26156b52052d',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(180,'YBMSPK','fdf65017-eb8a-4db4-b6d7-8a2ea4b8258a',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(181,'ZB5DVD','91de1b55-7fda-45f7-9afc-b4eef68c899f',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(182,'YQWV39','9f72fa02-eaad-47d4-b7f4-e79035c9269c',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(183,'YORG3G','34e73010-baa0-479d-bdb0-8840aad13dde',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(184,'Z6Q3KC','45f0d505-8a14-4403-812e-226d0ff7570c',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(185,'YAN8J2','b51912b4-3b0c-4cce-afac-78e14f7f0f4c',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(186,'XOA4EW','21f0bbdb-c7a2-4ba6-9bf6-b64031b81124',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:29','2026-03-26 17:21:29',NULL,NULL,NULL),
(187,'XOYZUS','8e9e1f2e-770d-4fd4-b234-452b88eb07b9',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:30','2026-03-26 17:21:30',NULL,NULL,NULL),
(188,'Z9IEOJ','766b9a13-8488-43c7-b3f3-1e66fb210747',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:30','2026-03-26 17:21:30',NULL,NULL,NULL),
(189,'XOXXL4','bea36e18-1151-4941-b12e-ad0893af0a18',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:30','2026-03-26 17:21:30',NULL,NULL,NULL),
(190,'Z74S5O','e357a378-0dfe-442a-b5fa-6e3c3e71dc7a',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:30','2026-03-26 17:21:30',NULL,NULL,NULL),
(191,'XBQAFK','0928c1c9-6e96-4db4-9a7a-31212a6f09b2',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:30','2026-03-26 17:21:30',NULL,NULL,NULL),
(192,'Z6T3MO','aa0a5ca6-a130-41b2-8bcc-8afbba0f66a5',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:30','2026-03-26 17:21:30',NULL,NULL,NULL),
(193,'Z3NR2B','80033a05-1398-4ad4-a9af-9bcbf4455f35',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:30','2026-03-26 17:21:30',NULL,NULL,NULL),
(194,'YH4AEN','9ab1a42f-3923-41b3-84ef-1c0906968dbf',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:30','2026-03-26 17:21:30',NULL,NULL,NULL),
(195,'YSJALB','18ba81d7-a414-4b0b-9ce9-ac5e17a75fd4',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:30','2026-03-26 17:21:30',NULL,NULL,NULL),
(196,'Z9BZI4','485f78c2-8487-42a6-a5a5-ee1131cb4137',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:30','2026-03-26 17:21:30',NULL,NULL,NULL),
(197,'TZCX4F','091d93df-b160-4c8c-9101-5d9f7dda7236',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:30','2026-03-26 17:21:30',NULL,NULL,NULL),
(198,'ZBO9WL','b7c98b6a-ed1f-4dbc-b7ce-2f00b799d595',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:30','2026-03-26 17:21:30',NULL,NULL,NULL),
(199,'ZKWRZ3','057275e8-fef5-445c-992c-65e118726251',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:30','2026-03-26 17:21:30',NULL,NULL,NULL),
(200,'ZIN8OM','0ab3b84b-88d8-476b-8210-494ee1a6309b',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:30','2026-03-26 17:21:30',NULL,NULL,NULL),
(201,'ZXWR87','ea6f1dbf-76f5-4a59-9262-eb2918d66a16',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:30','2026-03-26 17:21:30',NULL,NULL,NULL),
(202,'ZK936Q','4ee00b29-f2e9-457b-90b1-9b5e165f72b9',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:30','2026-03-26 17:21:30',NULL,NULL,NULL),
(203,'Z753QS','be3ed1c3-1aa6-4f34-9d24-3207ad7eab2a',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:30','2026-03-26 17:21:30',NULL,NULL,NULL),
(204,'ZPXFMU','fcd0788e-d9c8-4b9f-8a0c-5dbbc5e16189',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:30','2026-03-26 17:21:30',NULL,NULL,NULL),
(205,'Z7AQN2','f18e990d-0fb0-4baf-9059-64f8ef02644c',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:30','2026-03-26 17:21:30',NULL,NULL,NULL),
(206,'ZNJRUD','31058aee-c31a-47ca-b644-1d6d2140fdc1',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:30','2026-03-26 17:21:30',NULL,NULL,NULL),
(207,'XQ4XHA','3c4323e2-04a8-41ab-ba1c-d244a52b2b6d',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(208,'ZPTA6P','ea1531e9-2080-430a-82b0-e2c4f6e12d04',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(209,'X6LSGA','9a5c9446-0727-41a5-ad10-6db3e7c96682',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(210,'ZXDSXG','a99dd6a1-eff8-459f-a29f-e9f5c98cee84',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(211,'XWVJZP','e5ada261-3a89-4728-8a20-aaee00648a80',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(212,'ZH3TEG','603e545f-1f8c-4cd4-affa-a4791e6423a6',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(213,'YRHESD','ac22bb0e-9e73-43f5-aad1-d89db3efeaa4',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(214,'ZODD3T','1e16d3dc-8f3a-4b5a-be7e-3c75a027388a',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(215,'XU6INT','6f940175-ced8-4972-a30d-ad418d9e4381',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(216,'XT72Y9','c100a5a6-57bd-4720-ab28-8a37270abaa8',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(217,'ZTZ2SS','226e19c6-f57e-4cea-a915-b2a6d6f1431b',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(218,'ZGPL9J','1c70cad7-7d5d-41ca-89a6-0a2251169fa5',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(219,'XPIZ9S','44c28f2c-5b1a-454b-a0ae-a1bbb0b817a4',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(220,'XQUTHP','b656a57d-254d-4261-8933-74e89a03e4f5',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(221,'ZZYYW7','7b9df486-3d39-4a45-a9a5-ca6392d4b43c',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(222,'X5PFXX','16a7c0c3-dedb-42cd-a0d5-e0d38d6db42d',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(223,'X74VPV','47ef086d-72df-4d8a-8c6a-ba8d7d8586c1',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(224,'XGRY8H','b8f4eeb7-3fa4-4166-b662-249d667085f2',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(225,'XG9OCD','88323704-e3c0-4a61-a339-042665f0f5e6',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(226,'ZRP8LT','aa890595-8a29-4c49-91bb-4f1345b8a1d2',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(227,'ZYD8BG','09fe2ade-b98c-4af4-adc5-fc7962e7c3b6',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(228,'YFOY4S','4589bb67-97d4-4f95-8e1a-431e2b8b76ce',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(229,'YFQ8Q5','3633d537-5a63-470e-aa82-72a2b1da2dc4',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(230,'YHER4M','486853dd-52f5-4c39-8ac3-0ca925ebfd0f',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(231,'YDMN58','8dc745f3-afb0-48a6-af45-98de3c3d2296',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(232,'XPFUI8','ed2c2197-dd47-4b16-a2d7-e4149e0fc5fe',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:31','2026-03-26 17:21:31',NULL,NULL,NULL),
(233,'YFLXMK','c23d546a-714e-422d-953b-afe70d5a4b2c',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(234,'YFKJU7','79c2aa6b-97d3-4ef8-8e44-f40dc7b320ac',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(235,'ZFDKVF','1c626666-cdaa-44be-b6de-0e4ab4959e25',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(236,'Y9SIBR','334f3dc1-e422-439c-be4a-a284ebe04e74',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(237,'Y9DOMA','e58396e3-0bb0-4590-ad6b-4c7b1e8c4cff',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(238,'YCJ4NN','1350c003-1799-49c0-a3a6-03de5ae3a535',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(239,'XS7DDM','e2059e01-cf30-4917-98a8-cc7f47b6e078',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(240,'Y8ERGY','e74dfd34-9806-4eac-aea4-d911e9c7471e',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(241,'YC5US6','83ff929f-676c-4f98-9e0d-6b36e5c9998d',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(242,'XS9PZ4','3bfc2aa0-6910-4159-8188-86b90fb18b4d',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(243,'XELFWL','c2e4bcd6-7dc8-4ccc-8f7a-08cdcff7aec7',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(244,'XZOKPY','1e01752d-359d-48fc-b019-ec1e2acd3510',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(245,'Y6QPFW','6d36426a-5dc5-4587-9157-0dc7a16b50d7',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(246,'Y6OTI9','255322c9-783b-4158-83c4-062a5014358b',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(247,'XVUB9L','b24708bf-d837-48f3-8f39-01c3c428e50d',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(248,'YSDZL7','2f3752ce-64f6-4538-b9bc-79e495950270',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(249,'YMZTEG','dec2258e-45a5-4587-9163-b24d11a5409d',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(250,'ZCMB7R','1919760c-7fb6-48f4-b1ad-d4b0db90a941',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(251,'YQ48IV','9cfc9a47-96dd-44f0-8560-92a3a177297f',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(252,'YQ4BEJ','796f403e-f67d-4fb1-9433-97490c2880ec',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(253,'YSI9GN','5cb21219-f811-47d7-a03e-8d5227a86219',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(254,'ZRQ2OF','5ec16453-8664-4fda-b03e-6bb8d025f7a6',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(255,'ZRPUIV','46db53e6-9159-4a3d-b348-e39b8b16929b',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:32','2026-03-26 17:21:32',NULL,NULL,NULL),
(256,'ZAMNV9','1af63fce-0752-43ab-aa4c-54a49a55c996',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(257,'ZDWLW7','f75571a0-88c1-4a3b-acd7-deba163dc164',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(258,'ZMCWJP','99f2366f-da17-4c21-8400-c1db76c8c4e6',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(259,'X6DWFB','77272ea3-572f-48ea-a845-8f1b1cdeac47',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(260,'ZYC4NH','0c8b7d90-f4e5-45d2-bad9-e05d35f2f72a',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(261,'XAGZVB','a909db96-d330-45e0-be1f-80a3679a8812',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(262,'YPSF7U','ddcaa4eb-16e2-43e5-bb01-679d1154c3a4',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(263,'X9KHJA','848c69f2-e4a4-41af-98d9-a6246600f305',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(264,'X9BIWX','65233842-ddf7-4c05-98d4-245fe9f12bad',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(265,'X9JVYE','1915d6d0-e496-42aa-9ca4-5521b2c17a7b',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(266,'X9G6AU','59127df1-bdaf-457a-8d4b-3c8c1294f6ad',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(267,'YRCGJG','dfe69098-dabf-40a4-bc37-532e8a51689a',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(268,'XR6TG7','47ed0105-3c4e-440a-aba8-9b34984bb1c4',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(269,'ZXEIVP','d344f054-1dc9-4b45-8c9b-fc124f0708db',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(270,'Z7RP3W','3f269b96-eeaf-454a-9106-4f1f11a487a2',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(271,'XDRZ2P','df855b72-4b27-4a41-88d1-e6ea25bd372a',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(272,'ZSJ28P','d42e728b-3b48-4eb4-a9f5-11345911cad3',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(273,'ZQ85NZ','e5277fa1-c184-4a30-8de5-1066d9a2227d',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(274,'XZJYFJ','3b171079-b66d-4d0a-b560-b70a8ea09684',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(275,'ZURD5Q','566ec5f3-e070-4ac7-a498-1ad2a2a03b98',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(276,'ZULRM7','625a443b-e585-4a45-a06d-ba25bb67d27f',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(277,'XSYFI7','be44e631-1786-4233-9d78-1c8bae3fa6ea',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(278,'XW6X73','dbf47cd7-b241-487b-a991-902105564ab4',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(279,'XRYFO6','ab350566-426f-415f-bc3b-7b19acd43188',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(280,'XRN74R','ed99d48e-4398-4cb8-9f6c-9582e2147b08',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(281,'XTLP3A','b6ecc1a2-aee0-40c4-a7c2-af5ee40793d5',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(282,'XAXPLK','2c75e28e-5b6a-4489-81e8-2321b07f88e7',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(283,'X9A5RP','6d56bdf9-df42-4c83-8d97-89c8a600b4a8',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(284,'XDF97F','90d6e39b-9635-4770-a1d4-264a2e331b56',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(285,'XL43QZ','85625bfa-ba41-4b2f-a6b6-f8e6820cc817',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:33','2026-03-26 17:21:33',NULL,NULL,NULL),
(286,'XJFWZB','8832c592-4e14-49c0-a30f-e397f44dbdaa',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(287,'XZEI97','e2f279a0-a21e-4229-afc5-52c41d9be8b4',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(288,'YBMLJ7','aafebe4e-593a-4dd0-8abb-8ced63eb7639',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(289,'XZGSY5','4b2bb8a5-b909-47ce-bd97-b3a3814341cc',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(290,'YGLDIK','0b9c0413-5f56-4949-9c92-f21c7cf0e2c2',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(291,'ZLCP3Y','36f13f22-3dec-4d3f-8c97-d085851d098b',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(292,'YAVGPQ','bcb60c4d-8c1e-4353-80f4-341e8550143c',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(293,'XR8GRY','fef655f3-b4f1-4609-8be3-25a627e1acd3',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(294,'XZHZNF','cff28870-e5f7-482e-a1c4-2b2c90b62333',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(295,'Y764EL','5bbe3728-7226-4d86-a174-052c8fb390d2',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(296,'XH6C22','0d5d35d1-5db6-4c3a-950d-943f5735e97a',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(297,'YSCNKX','8320fff7-79f7-4dae-9794-26f6a798da0b',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(298,'X75KRG','8f6000ea-7277-4529-80e9-9e6c26b1e234',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(299,'ZDJMVY','d3ecf0c1-80f4-4db4-904c-2d8a08df09c5',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(300,'XV253N','99545296-24b9-47e7-b7a2-8ee14ed93f4e',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(301,'YS642C','3feb52f5-0709-4899-8c8a-75d6fe59517f',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(302,'YW8Y8K','b59f5f33-8106-46c3-84c0-625f2678b979',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(303,'YVWUTA','2b2d1a49-075f-49af-8253-b54c57ec269e',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(304,'Y9JXVF','d4bd8b9a-5958-44be-90d2-056571a5807a',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(305,'Z89EEL','b0ee1741-68f5-4dd3-b7c4-c47bdc774c7a',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(306,'XSQ978','c9b76503-b178-497b-b6b0-43b042a9d6d4',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(307,'X9FCYU','660a5e40-5ede-4a03-b0e0-985b5618614e',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(308,'XG6937','a1c26a4c-e1ad-4e9e-a975-8d4030e77c24',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(309,'YRPKVJ','6120cb82-a2d9-45dd-a750-e478f9b23813',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(310,'YOYMYW','ba91f65f-9222-4328-b9a3-36e80fc6ca0a',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(311,'XEG6BO','20740f04-74a5-4737-bf8a-eff53c6cafd4',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(312,'XIM9XW','6fba140a-3b16-473a-81f6-76f110fa5d36',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:34','2026-03-26 17:21:34',NULL,NULL,NULL),
(313,'ZXAUXH','131edc47-8998-4d82-b1ad-2bdd5b594e32',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:35','2026-03-26 17:21:35',NULL,NULL,NULL),
(314,'ZXALVJ','3cd73c54-2b37-45a8-a134-ff0c729a8e57',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:35','2026-03-26 17:21:35',NULL,NULL,NULL),
(315,'ZZ2BDQ','c6bbd8f4-20ce-43e8-b337-fe03580ee8ba',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:35','2026-03-26 17:21:35',NULL,NULL,NULL),
(316,'XSSLGX','3a96b3c2-fd36-443b-af19-918872e9aff2',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:35','2026-03-26 17:21:35',NULL,NULL,NULL),
(317,'XTWTS9','97324199-5df5-4bc6-a96e-44beb965780f',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:35','2026-03-26 17:21:35',NULL,NULL,NULL),
(318,'ZRFISH','619cce89-50d8-49a1-b395-b443857778e0',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:35','2026-03-26 17:21:35',NULL,NULL,NULL),
(319,'XTEIRV','62f631ce-cd6d-40dc-ab81-fef854d26a18',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:35','2026-03-26 17:21:35',NULL,NULL,NULL),
(320,'XS4OPN','7adb794e-d83c-480a-9e57-0ee35b2f9b54',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:35','2026-03-26 17:21:35',NULL,NULL,NULL),
(321,'XRH7FJ','ad111d0b-827d-47cb-884f-8c2549a6c852',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:35','2026-03-26 17:21:35',NULL,NULL,NULL),
(322,'XRVBAI','eaa4792a-7733-496e-a504-7b8ad94a80ba',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:35','2026-03-26 17:21:35',NULL,NULL,NULL),
(323,'YGBOSQ','e8bf0073-7460-4eac-868b-0f3f452d39b4',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:35','2026-03-26 17:21:35',NULL,NULL,NULL),
(324,'XAWFPW','b548b230-d666-4796-8850-ac453a97a243',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:35','2026-03-26 17:21:35',NULL,NULL,NULL),
(325,'XDYUEF','10b73fb3-590f-40b8-b835-087b02881917',NULL,NULL,'Emis',0,0,0,0,0,NULL,0,1,1,'2026-03-26 17:21:35','2026-03-26 17:21:35',NULL,NULL,NULL);

--
-- Table structure for table `presale`
--

CREATE TABLE `presale` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(150) DEFAULT NULL,
  `name` varchar(150) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `account_id` bigint(20) unsigned DEFAULT NULL,
  `pnr_id` bigint(20) DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `status` enum('A émettre') DEFAULT NULL,
  `departure_date` date DEFAULT NULL,
  `type` enum('ticket','emd','adm','acm') DEFAULT NULL,
  `tax` float DEFAULT NULL,
  `excluding_tax` float DEFAULT NULL,
  `ttc` float DEFAULT NULL,
  `commission` float DEFAULT NULL,
  `commission_amount` float DEFAULT NULL,
  `subtotal` float DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `margin` float DEFAULT NULL,
  `penality` float DEFAULT NULL,
  `payment_form` varchar(255) DEFAULT NULL,
  `fare_basis` varchar(255) DEFAULT NULL,
  `routing` varchar(255) DEFAULT NULL,
  `class` varchar(255) DEFAULT NULL,
  `agent` varchar(255) DEFAULT NULL,
  `document_number` varchar(255) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `source` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `passenger_id` bigint(20) unsigned DEFAULT NULL,
  `provider_id` bigint(20) unsigned DEFAULT NULL,
  `service_id` bigint(20) unsigned DEFAULT NULL,
  `company_id` bigint(20) unsigned DEFAULT NULL,
  `external_id` int(11) DEFAULT NULL,
  `agency_fees` float DEFAULT NULL,
  `provider_fees` float DEFAULT NULL,
  `is_deleted` tinyint(4) DEFAULT 0,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `modified_at` datetime DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_presale_uuid` (`uuid`),
  UNIQUE KEY `uk_presale_name` (`name`),
  KEY `presale_users_créé_par_FK` (`created_by`),
  KEY `presale_users_modified_by_FK` (`updated_by`),
  KEY `presale_services_services_FK` (`service_id`),
  KEY `presale_accounts_comptes_FK` (`account_id`),
  KEY `presale_compagnies_compagnies_FK` (`company_id`),
  KEY `presale_beneficiaires_beneficiaires_FK` (`passenger_id`),
  KEY `presale_vendors_fournisseurs_FK` (`provider_id`),
  KEY `presale_pnr_FK` (`pnr_id`),
  CONSTRAINT `presale_accounts_comptes_FK` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`),
  CONSTRAINT `presale_beneficiaires_beneficiaires_FK` FOREIGN KEY (`passenger_id`) REFERENCES `beneficiaires` (`id`),
  CONSTRAINT `presale_companies_FK` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `presale_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `presale_pnr_FK` FOREIGN KEY (`pnr_id`) REFERENCES `pnr` (`id`),
  CONSTRAINT `presale_services_services_FK` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`),
  CONSTRAINT `presale_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `presale_vendors_fournisseurs_FK` FOREIGN KEY (`provider_id`) REFERENCES `vendors` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `presale`
--


--
-- Table structure for table `remboursement`
--

CREATE TABLE `remboursement` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(150) DEFAULT NULL,
  `name` varchar(150) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `type_refund` enum('Via GDS','Via BSPLINK') DEFAULT NULL,
  `status` enum('En attente du client','Remboursé en direct','En attente de la compagnie','Remboursé via bsplink','Annulé') DEFAULT NULL,
  `freetax_amount` float DEFAULT NULL,
  `penalty` float DEFAULT NULL,
  `return_commission` float DEFAULT NULL,
  `return_tax` float DEFAULT NULL,
  `refund_amount` float DEFAULT NULL,
  `agency_fees` float DEFAULT NULL,
  `reference` bigint(20) unsigned DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `créé_par` bigint(20) unsigned DEFAULT NULL,
  `source` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `external_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `modified_at` datetime DEFAULT NULL,
  `is_deleted` tinyint(4) DEFAULT 0,
  `created_by` bigint(20) unsigned DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_remboursement_uuid` (`uuid`),
  UNIQUE KEY `uk_remboursement_name` (`name`),
  KEY `remboursement_users_créé_par_FK` (`créé_par`),
  KEY `remboursement_users_modified_by_FK` (`updated_by`),
  KEY `remboursement_etatsdeventes_référence_FK` (`reference`),
  KEY `remboursement_date_index` (`date`),
  KEY `remboursement_created_by_foreign` (`created_by`),
  CONSTRAINT `remboursement_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `remboursement_etatsdeventes_référence_FK` FOREIGN KEY (`reference`) REFERENCES `etatsdeventes` (`id`),
  CONSTRAINT `remboursement_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `remboursement_users_créé_par_FK` FOREIGN KEY (`créé_par`) REFERENCES `users_old` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `remboursement`
--


--
-- Table structure for table `rhcs`
--

CREATE TABLE `rhcs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT 'Format: yyyymmddhhii',
  `date` datetime DEFAULT NULL,
  `uuid` char(36) DEFAULT NULL,
  `rhc_amount` decimal(15,2) NOT NULL COMMENT 'Montant de votre RHC',
  `current_consumption` decimal(15,2) NOT NULL COMMENT 'Consommation actuelle',
  `amount_at_risk` decimal(15,2) NOT NULL COMMENT 'Montant à risques',
  `current_financial_security` decimal(15,2) NOT NULL COMMENT 'Sécurité Financière actuelle',
  `total_days_reporting_period` int(11) DEFAULT NULL COMMENT 'Total Days in Reporting Period',
  `days_in_accounting_period` int(11) DEFAULT NULL COMMENT 'Jours compris dans la période comptable',
  `multiplication_factor` decimal(5,2) DEFAULT NULL COMMENT 'Facteur de multiplication',
  `settlement_frequency` varchar(50) DEFAULT NULL COMMENT 'Fréquence de règlement (Bimensuel/Fortnightly)',
  `currency` varchar(3) NOT NULL DEFAULT 'XOF' COMMENT 'Devise (toujours XOF pour IATA Sénégal)',
  `raw_content` text DEFAULT NULL COMMENT 'Contenu brut récupéré du portail IATA',
  `collection_date` timestamp NOT NULL COMMENT 'Date/heure de collecte depuis IATA',
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `created_by` bigint(20) unsigned DEFAULT 1,
  `updated_by` bigint(20) unsigned DEFAULT 1,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_rhcs_uuid` (`uuid`),
  UNIQUE KEY `uk_rhcs_name` (`name`),
  KEY `rhcs_collection_date_index` (`collection_date`),
  KEY `rhcs_created_at_index` (`created_at`),
  KEY `rhcs_uuid_index` (`uuid`),
  KEY `rhcs_is_deleted_index` (`is_deleted`),
  KEY `rhcs_date_index` (`date`),
  KEY `rhcs_created_by_foreign` (`created_by`),
  KEY `rhcs_updated_by_foreign` (`updated_by`),
  CONSTRAINT `rhcs_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `rhcs_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rhcs`
--

INSERT INTO `rhcs` VALUES
(1,'202510141123','2025-10-14 12:41:04','4fc414c3-1e5f-4792-8558-b747c57279c3',65000000.00,56915708.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 56,915,708\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,491.85)\n20241002F - XOF 90,048,808 (USD 159,458.63)\n20250301F - XOF 86,636,776 (USD 153,416.59)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-14 10:41:04',0,1,1,'2025-10-14 13:23:00','2025-12-16 18:55:20'),
(2,'202510141143','2025-10-14 13:42:43','3f99b046-2471-4db2-866b-062ddeac5196',65000000.00,56915708.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 56,915,708\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,491.85)\n20241002F - XOF 90,048,808 (USD 159,458.63)\n20250301F - XOF 86,636,776 (USD 153,416.59)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-14 11:42:43',0,1,1,'2025-10-14 13:43:04','2025-12-16 18:55:20'),
(3,'202510141144','2025-10-14 13:44:16','05d04f1d-1460-43e3-8cc0-1539d1a6cc6d',65000000.00,56915708.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 56,915,708\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,491.85)\n20241002F - XOF 90,048,808 (USD 159,458.63)\n20250301F - XOF 86,636,776 (USD 153,416.59)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-14 11:44:16',0,1,1,'2025-10-14 13:44:31','2025-12-16 18:55:20'),
(4,'202510141154','2025-10-14 13:54:25','77657a9f-ba5c-41e7-bbfa-a1a5d4dda2a0',65000000.00,56915708.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 56,915,708\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,491.85)\n20241002F - XOF 90,048,808 (USD 159,458.63)\n20250301F - XOF 86,636,776 (USD 153,416.59)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-14 11:54:25',0,1,1,'2025-10-14 13:54:41','2025-12-16 18:55:20'),
(5,'202510141301','2025-10-14 15:00:58','d20e5283-534f-4ba0-908c-cefb2f992d4c',65000000.00,58933508.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 58,933,508\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,491.85)\n20241002F - XOF 90,048,808 (USD 159,458.63)\n20250301F - XOF 86,636,776 (USD 153,416.59)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-14 13:00:58',0,1,1,'2025-10-14 15:01:14','2025-12-16 18:55:20'),
(6,'202510141401','2025-10-14 16:00:46','96a0bca4-5a32-42f8-b640-8d785a7b8953',65000000.00,58933508.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 58,933,508\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,491.85)\n20241002F - XOF 90,048,808 (USD 159,458.63)\n20250301F - XOF 86,636,776 (USD 153,416.59)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-14 14:00:46',0,1,1,'2025-10-14 16:01:02','2025-12-16 18:55:20'),
(7,'202510141501','2025-10-14 17:01:12','036ccc3b-51f0-4d44-9d19-2417d9c46444',65000000.00,58933508.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 58,933,508\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,491.85)\n20241002F - XOF 90,048,808 (USD 159,458.63)\n20250301F - XOF 86,636,776 (USD 153,416.59)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-14 15:01:12',0,1,1,'2025-10-14 17:01:28','2025-12-16 18:55:20'),
(8,'202510141601','2025-10-14 18:00:54','28125b53-1570-448c-82cb-666165d92a8b',65000000.00,58933508.00,173694186.67,65000000.00,30,30,1.50,'Bimensuel','XOF','Montant de votre RHC XOF 65,000,000\nConsommation actuelle XOF 58,933,508\nMontant à risques XOF 173,694,186.67\nTotal Days in Reporting Period 30\nJours compris dans la période comptable 15\nFacteur de multiplication 1.5\nPériodes de rapports les plus élevées\n20241202F - XOF 83 855 696 (USD 148 491,85)\n20241002F - XOF 90 048 808 (USD 159 458,63)\n20250301F - XOF 86 636 776 (USD 153 416,59)\nSécurité Financière actuelle XOF 65,000,000\nFréquence de règlement Bimensuel','2025-10-14 16:00:54',0,1,1,'2025-10-14 18:01:10','2025-12-16 18:55:20'),
(9,'202510141801','2025-10-14 20:00:59','4ce5e21c-3270-40af-a708-eea678336326',65000000.00,58933508.00,173694186.67,65000000.00,30,30,1.50,'Bimensuel','XOF','Montant de votre RHC XOF 65,000,000\nConsommation actuelle XOF 58,933,508\nMontant à risques XOF 173,694,186.67\nTotal Days in Reporting Period 30\nJours compris dans la période comptable 15\nFacteur de multiplication 1.5\nPériodes de rapports les plus élevées\n20241202F - XOF 83 855 696 (USD 148 491,85)\n20241002F - XOF 90 048 808 (USD 159 458,63)\n20250301F - XOF 86 636 776 (USD 153 416,59)\nSécurité Financière actuelle XOF 65,000,000\nFréquence de règlement Bimensuel','2025-10-14 18:00:59',0,1,1,'2025-10-14 20:01:15','2025-12-16 18:55:20'),
(10,'202510150901','2025-10-15 11:00:51','62d741cc-392e-4828-82af-1df2d9c44cca',65000000.00,60367677.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 60,367,677\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,491.85)\n20241002F - XOF 90,048,808 (USD 159,458.63)\n20250301F - XOF 86,636,776 (USD 153,416.59)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-15 09:00:51',0,1,1,'2025-10-15 11:01:18','2025-12-16 18:55:20'),
(11,'202510151001','2025-10-15 12:00:55','3d00215c-45e5-4399-8f7f-978a691bce8c',65000000.00,60367677.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 60,367,677\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,491.85)\n20241002F - XOF 90,048,808 (USD 159,458.63)\n20250301F - XOF 86,636,776 (USD 153,416.59)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-15 10:00:55',0,1,1,'2025-10-15 12:01:13','2025-12-16 18:55:20'),
(12,'202510151101','2025-10-15 13:00:51','6370ab55-6436-4bc9-9224-2666737626ea',65000000.00,60926777.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 60,926,777\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,491.85)\n20241002F - XOF 90,048,808 (USD 159,458.63)\n20250301F - XOF 86,636,776 (USD 153,416.59)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-15 11:00:51',0,1,1,'2025-10-15 13:01:10','2025-12-16 18:55:20'),
(13,'202510151201','2025-10-15 14:00:53','f4550c35-d53c-4062-8cda-76932b6afd0f',65000000.00,60926777.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 60,926,777\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,491.85)\n20241002F - XOF 90,048,808 (USD 159,458.63)\n20250301F - XOF 86,636,776 (USD 153,416.59)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-15 12:00:53',0,1,1,'2025-10-15 14:01:10','2025-12-16 18:55:20'),
(14,'202510151301','2025-10-15 15:00:46','d3f5fff6-4ebb-41d4-9695-3229a6565dfe',65000000.00,60926777.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 60,926,777\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,491.85)\n20241002F - XOF 90,048,808 (USD 159,458.63)\n20250301F - XOF 86,636,776 (USD 153,416.59)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-15 13:00:46',0,1,1,'2025-10-15 15:01:02','2025-12-16 18:55:20'),
(15,'202510151401','2025-10-15 16:01:01','3c570918-9077-46da-8739-b3391edfd3de',65000000.00,60926777.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 60,926,777\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,491.85)\n20241002F - XOF 90,048,808 (USD 159,458.63)\n20250301F - XOF 86,636,776 (USD 153,416.59)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-15 14:01:01',0,1,1,'2025-10-15 16:01:17','2025-12-16 18:55:20'),
(16,'202510151501','2025-10-15 17:00:47','5176d520-302d-42af-bbd6-d14053af2d28',65000000.00,60926777.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 60,926,777\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,491.85)\n20241002F - XOF 90,048,808 (USD 159,458.63)\n20250301F - XOF 86,636,776 (USD 153,416.59)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-15 15:00:47',0,1,1,'2025-10-15 17:01:12','2025-12-16 18:55:20'),
(17,'202510151601','2025-10-15 18:00:48','48c94132-b0d0-4960-9f72-3a0f392eafba',65000000.00,65493477.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 65,493,477\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,491.85)\n20241002F - XOF 90,048,808 (USD 159,458.63)\n20250301F - XOF 86,636,776 (USD 153,416.59)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-15 16:00:48',0,1,1,'2025-10-15 18:01:04','2025-12-16 18:55:20'),
(18,'202510151701','2025-10-15 19:00:46','f5781c18-2eba-482f-afaf-431ea07aaa66',65000000.00,65493477.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 65,493,477\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,491.85)\n20241002F - XOF 90,048,808 (USD 159,458.63)\n20250301F - XOF 86,636,776 (USD 153,416.59)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-15 17:00:46',0,1,1,'2025-10-15 19:01:03','2025-12-16 18:55:20'),
(19,'202510151801','2025-10-15 20:00:46','d6fc0cd4-deb7-4847-abc3-365c9e4be673',65000000.00,65493477.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 65,493,477\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,491.85)\n20241002F - XOF 90,048,808 (USD 159,458.63)\n20250301F - XOF 86,636,776 (USD 153,416.59)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-15 18:00:46',0,1,1,'2025-10-15 20:01:02','2025-12-16 18:55:20'),
(20,'202510151900','2025-10-15 21:00:43','7133ea06-f3a1-4d4f-a05e-5fbe8aa9f905',65000000.00,65493477.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 65,493,477\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,491.85)\n20241002F - XOF 90,048,808 (USD 159,458.63)\n20250301F - XOF 86,636,776 (USD 153,416.59)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-15 19:00:43',0,1,1,'2025-10-15 21:00:59','2025-12-16 18:55:20'),
(21,'202510152001','2025-10-15 22:00:45','20004ac0-6b99-428d-a761-3afa16654066',65000000.00,65493477.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 65,493,477\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,491.85)\n20241002F - XOF 90,048,808 (USD 159,458.63)\n20250301F - XOF 86,636,776 (USD 153,416.59)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-15 20:00:45',0,1,1,'2025-10-15 22:01:01','2025-12-16 18:55:20'),
(22,'202510152101','2025-10-15 23:00:49','772bfcf0-3afe-4f0f-b25c-3aa78a4bfc1e',65000000.00,65493477.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 65,493,477\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,491.85)\n20241002F - XOF 90,048,808 (USD 159,458.63)\n20250301F - XOF 86,636,776 (USD 153,416.59)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-15 21:00:49',0,1,1,'2025-10-15 23:01:05','2025-12-16 18:55:20'),
(23,'202510160801','2025-10-16 10:00:47','887be420-382a-4dd6-b794-b258f324102d',65000000.00,42970677.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 42,970,677\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,047.04)\n20241002F - XOF 90,048,808 (USD 158,980.96)\n20250301F - XOF 86,636,776 (USD 152,957.03)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-16 08:00:47',0,1,1,'2025-10-16 10:01:11','2025-12-16 18:55:20'),
(24,'202510160901','2025-10-16 11:00:57','8cce5fbc-50d4-46f6-9bd6-78ee4ca16057',65000000.00,42970677.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 42,970,677\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,047.04)\n20241002F - XOF 90,048,808 (USD 158,980.96)\n20250301F - XOF 86,636,776 (USD 152,957.03)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-16 09:00:57',0,1,1,'2025-10-16 11:01:13','2025-12-16 18:55:20'),
(25,'202510161136','2025-10-16 13:00:45','55627253-3e38-4349-b894-4ee5404c071e',65000000.00,42970677.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 42,970,677\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,047.04)\n20241002F - XOF 90,048,808 (USD 158,980.96)\n20250301F - XOF 86,636,776 (USD 152,957.03)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-16 11:00:45',0,1,1,'2025-10-16 13:36:45','2025-12-16 18:55:20'),
(26,'RHC_20251016_65000000','2025-10-16 13:00:45','89a6bbe6-1a1c-45a2-b962-b409869513ad',65000000.00,42970677.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 42,970,677\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,047.04)\n20241002F - XOF 90,048,808 (USD 158,980.96)\n20250301F - XOF 86,636,776 (USD 152,957.03)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-16 11:00:45',0,1,1,'2025-10-16 15:15:12','2025-12-16 18:55:20'),
(27,'RHC_20251016_65000000_27','2025-10-16 14:00:47','56a08648-9a44-40b2-88dd-d2266c799852',65000000.00,42970677.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 42,970,677\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,047.04)\n20241002F - XOF 90,048,808 (USD 158,980.96)\n20250301F - XOF 86,636,776 (USD 152,957.03)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-16 12:00:47',0,1,1,'2025-10-16 15:15:12','2025-12-16 18:55:20'),
(28,'202510161317','2025-10-16 15:00:53','ec1a1bfe-49b1-470f-a339-b5cfd17885a2',65000000.00,42970677.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 42,970,677\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,047.04)\n20241002F - XOF 90,048,808 (USD 158,980.96)\n20250301F - XOF 86,636,776 (USD 152,957.03)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-16 13:00:53',0,1,1,'2025-10-16 15:17:20','2025-12-16 18:55:20'),
(29,'202510161401','2025-10-16 16:00:46','9c907e34-e64d-4316-ac3b-ef99f4d182a3',65000000.00,42970677.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 42,970,677\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,047.04)\n20241002F - XOF 90,048,808 (USD 158,980.96)\n20250301F - XOF 86,636,776 (USD 152,957.03)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-16 14:00:46',0,1,1,'2025-10-16 16:01:02','2025-12-16 18:55:20'),
(30,'202510161501','2025-10-16 17:00:48','985506a4-14ca-4b4f-b100-05b73e977dcd',65000000.00,42970677.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 42,970,677\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,047.04)\n20241002F - XOF 90,048,808 (USD 158,980.96)\n20250301F - XOF 86,636,776 (USD 152,957.03)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-16 15:00:48',0,1,1,'2025-10-16 17:01:04','2025-12-16 18:55:20'),
(31,'202510161901','2025-10-16 21:00:46','1d063594-79a6-4e69-a613-7d3fa3555a05',65000000.00,42970677.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 42,970,677\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,047.04)\n20241002F - XOF 90,048,808 (USD 158,980.96)\n20250301F - XOF 86,636,776 (USD 152,957.03)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-16 19:00:46',0,1,1,'2025-10-16 21:01:05','2025-12-16 18:55:20'),
(32,'202510171201','2025-10-17 14:00:57','70cae410-f105-4d95-adf3-071ac3bf5c83',65000000.00,49335532.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 49,335,532\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,663.80)\n20241002F - XOF 90,048,808 (USD 159,643.28)\n20250301F - XOF 86,636,776 (USD 153,594.25)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-17 12:00:57',0,1,1,'2025-10-17 14:01:21','2025-12-16 18:55:20'),
(33,'202510171301','2025-10-17 15:00:47','4e208ed8-57d7-425b-9a28-010744fdc061',65000000.00,49335532.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 49,335,532\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,663.80)\n20241002F - XOF 90,048,808 (USD 159,643.28)\n20250301F - XOF 86,636,776 (USD 153,594.25)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-17 13:00:47',0,1,1,'2025-10-17 15:01:04','2025-12-16 18:55:20'),
(34,'202510171401','2025-10-17 16:00:46','c81b2775-9257-48f3-af51-42264476d23d',65000000.00,49335532.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 49,335,532\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,663.80)\n20241002F - XOF 90,048,808 (USD 159,643.28)\n20250301F - XOF 86,636,776 (USD 153,594.25)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-17 14:00:46',0,1,1,'2025-10-17 16:01:04','2025-12-16 18:55:20'),
(35,'202510171501','2025-10-17 17:00:47','3fcba1ff-5d7e-489c-b750-7aa92b7922c9',65000000.00,49335532.00,173694186.67,65000000.00,30,30,1.50,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 49,335,532\nAmount at Risk XOF 173,694,186.67\nTotal Days in Reporting Period 30\nDays in Reporting Period 15\nMultiplication factor 1.5\nHighest Reporting Periods\n20241202F - XOF 83,855,696 (USD 148,663.80)\n20241002F - XOF 90,048,808 (USD 159,643.28)\n20250301F - XOF 86,636,776 (USD 153,594.25)\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-17 15:00:47',0,1,1,'2025-10-17 17:01:05','2025-12-16 18:55:20'),
(36,'202510311805','2025-10-31 19:00:41','1c5c8d1d-dd4d-4c7e-a1c4-62057ac7d23c',65000000.00,53677601.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 53,677,601\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-31 18:00:41',0,1,1,'2025-10-31 19:05:25','2025-12-16 18:55:20'),
(37,'202511121749','2025-11-12 18:49:10','a9a7ab84-78e7-4535-9a5a-04b6690aca97',65000000.00,57272980.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 57,272,980\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-11-12 17:49:10',0,1,1,'2025-11-12 18:49:40','2025-12-16 18:55:20'),
(38,'202511121808','2025-11-12 19:07:51','52358a85-1766-4b94-a40d-352e78e4f3ea',65000000.00,57272980.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 57,272,980\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-11-12 18:07:51',0,1,1,'2025-11-12 19:08:11','2025-12-16 18:55:20'),
(39,'202511121837','2025-11-12 19:37:27','9a1c788c-fbf1-45b2-8107-3d3d7910b7d8',65000000.00,57272980.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 57,272,980\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-11-12 18:37:27',0,1,1,'2025-11-12 19:37:47','2025-12-16 18:55:20'),
(40,'202511121919','2025-11-12 20:19:18','1fc10b9a-4828-4434-9cee-f84cd84360f0',65000000.00,57272980.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 57,272,980\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-11-12 19:19:18',0,1,1,'2025-11-12 20:19:38','2025-12-16 18:55:20'),
(41,'202511121926','2025-11-12 20:26:40','f30a2526-8d1b-4635-b115-b82b5ba68211',65000000.00,57272980.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 57,272,980\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-11-12 19:26:40',0,1,1,'2025-11-12 20:26:59','2025-12-16 18:55:20'),
(42,'202511131359','2025-11-13 14:58:48','ed78e58c-2020-4800-9765-ec6c37f20351',65000000.00,56149380.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 56,149,380\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-11-13 13:58:48',0,1,1,'2025-11-13 14:59:19','2025-12-16 18:55:20'),
(43,'202511131445','2025-11-13 15:44:56','30d2e8d5-0ae6-4d4f-9e49-a8feca767fbf',65000000.00,56149380.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 56,149,380\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-11-13 14:44:56',0,1,1,'2025-11-13 15:45:12','2025-12-16 18:55:20'),
(44,'RHC_20251030_65000000','2025-10-30 10:20:42','3b8e97f1-8fa2-45fa-9604-1e481968b15f',65000000.00,46267683.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 46,267,683\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-30 09:20:42',0,1,1,'2025-11-13 20:52:08','2025-12-16 18:55:20'),
(45,'RHC_20251030_65000000_45','2025-10-30 10:32:30','5feef180-c028-4027-8c79-88f9e866bdb8',65000000.00,46267683.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 46,267,683\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-30 09:32:30',0,1,1,'2025-11-13 20:52:09','2025-12-16 18:55:20'),
(46,'RHC_20251031_65000000','2025-10-31 13:08:39','f6030b0f-ad0d-49b5-be15-1b83153c3c15',65000000.00,53677601.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 53,677,601\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-10-31 12:08:39',0,1,1,'2025-11-13 20:52:11','2025-12-16 18:55:20'),
(47,'202511212041','2025-11-21 21:41:22','84047203-6c0d-4b11-978d-3e95d3e9da4f',65000000.00,52624763.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 52,624,763\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-11-21 20:41:22',0,1,1,'2025-11-21 21:41:40','2025-12-16 18:55:20'),
(48,'202511212042','2025-11-21 21:42:35','15717ac4-02c7-4a00-80f9-92921d5ec686',65000000.00,52624763.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 52,624,763\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-11-21 20:42:35',0,1,1,'2025-11-21 21:42:51','2025-12-16 18:55:20'),
(49,'202512161631','2025-12-16 17:31:15','8a0f8012-f9cd-484f-b6af-72a1c3fc5a67',65000000.00,67721331.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 67,721,331\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-12-16 16:31:15',0,1,1,'2025-12-16 17:31:31','2025-12-16 18:55:20'),
(50,'202512161717','2025-12-16 18:17:19','86d775af-d53b-4668-a98a-2020a68e7a4f',65000000.00,67721331.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 67,721,331\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-12-16 17:17:19',0,1,1,'2025-12-16 18:17:36','2025-12-16 18:55:20'),
(51,'202512161737','2025-12-16 18:37:13','e4d83b41-f07f-4ff0-a67e-fca413b8570b',65000000.00,67721331.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 67,721,331\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-12-16 17:37:13',0,1,1,'2025-12-16 18:37:32','2025-12-16 18:55:20'),
(52,'202512161741','2025-12-16 18:41:44','9579dc36-f6cb-4d48-a85f-07b22986a856',65000000.00,67721331.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 67,721,331\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2025-12-16 17:41:44',0,1,1,'2025-12-16 18:42:01','2025-12-16 18:42:01'),
(53,'202601131115','2026-01-13 13:14:58','47efc60d-f72b-42f9-8ae7-cae9155c820f',65000000.00,83521553.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 83,521,553\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2026-01-13 12:14:58',0,1,1,'2026-01-13 12:15:15','2026-01-13 12:15:15'),
(54,'202601131516','2026-01-13 17:15:43','5e83657b-1215-47cb-9d75-c8b5fde09a6b',65000000.00,83300971.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 83,300,971\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2026-01-13 16:15:43',0,1,1,'2026-01-13 16:16:02','2026-01-13 16:16:02'),
(55,'202601131554','2026-01-13 17:54:13','a4af57ce-400e-4595-a49d-2bd0cda4c84c',65000000.00,83300971.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 83,300,971\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2026-01-13 16:54:13',0,1,1,'2026-01-13 16:54:30','2026-01-13 16:54:30'),
(56,'202601131816','2026-01-13 20:15:43','f10475ca-d017-4fef-a208-258c3b4dcdf3',65000000.00,83300971.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 83,300,971\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2026-01-13 19:15:43',0,1,1,'2026-01-13 19:16:01','2026-01-13 19:16:01'),
(57,'202601132316','2026-01-14 01:15:45','b2d1c1bd-627f-4f67-ba10-068335a5c597',65000000.00,83300971.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 83,300,971\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2026-01-14 00:15:45',0,1,1,'2026-01-14 00:16:02','2026-01-14 00:16:02'),
(58,'202601140016','2026-01-14 02:15:47','f859783f-f47b-48b5-bf7c-82c15eb477ad',65000000.00,83300971.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 83,300,971\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2026-01-14 01:15:47',0,1,1,'2026-01-14 01:16:04','2026-01-14 01:16:04'),
(59,'202601140116','2026-01-14 03:15:43','8b48e4ff-da0c-4410-8283-bcbe2c09de77',65000000.00,83300971.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 83,300,971\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2026-01-14 02:15:43',0,1,1,'2026-01-14 02:16:01','2026-01-14 02:16:01'),
(60,'202601151344','2026-01-15 14:44:42','33b2cbe0-6b33-4ca3-82cd-e6a374852cd5',65000000.00,83129812.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 83,129,812\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2026-01-15 13:44:42',0,1,1,'2026-01-15 13:44:58','2026-01-15 13:44:58'),
(61,'202601151610','2026-01-15 17:09:50','d42c9cac-0fb8-4408-9e34-144bae59e43f',65000000.00,83129812.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 83,129,812\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2026-01-15 16:09:50',0,1,1,'2026-01-15 16:10:08','2026-01-15 16:10:08'),
(62,'202601160912','2026-01-16 10:12:22','85438afe-eee6-4591-b2e1-607f57b6cca0',65000000.00,83129812.00,0.00,65000000.00,NULL,NULL,NULL,'Fortnightly','XOF','RHC Amount XOF 65,000,000\nCurrent usage XOF 83,129,812\nCurrent Financial Security XOF 65,000,000\nRemittance frequency Fortnightly','2026-01-16 09:12:22',0,1,1,'2026-01-16 09:12:54','2026-01-16 09:12:54');

--
-- Table structure for table `segments`
--

CREATE TABLE `segments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) NOT NULL COMMENT 'UUID unique du segment',
  `pnr_id` bigint(20) DEFAULT NULL,
  `name` varchar(150) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `pnr_uuid` char(36) NOT NULL COMMENT 'UUID du PNR parent',
  `segment_number` varchar(10) DEFAULT NULL COMMENT 'Numéro du segment (ex: 001, 002)',
  `sequence` varchar(10) DEFAULT NULL COMMENT 'Séquence du segment (ex: 034X)',
  `type` enum('TICKETED','UNTICKETED','EMD','REFUND') NOT NULL COMMENT 'Type de segment',
  `status` varchar(20) DEFAULT NULL COMMENT 'Statut: OK, CONFIRMED, HK, CANCELLED, etc.',
  `departure_code` varchar(3) DEFAULT NULL COMMENT 'Code IATA aéroport départ (ex: DXB)',
  `departure_name` varchar(100) DEFAULT NULL COMMENT 'Nom aéroport départ',
  `departure_date` date DEFAULT NULL COMMENT 'Date de départ',
  `departure_time` time DEFAULT NULL COMMENT 'Heure de départ',
  `arrival_code` varchar(3) DEFAULT NULL COMMENT 'Code IATA aéroport arrivée (ex: DOH)',
  `arrival_name` varchar(100) DEFAULT NULL COMMENT 'Nom aéroport arrivée',
  `arrival_date` date DEFAULT NULL COMMENT 'Date d''arrivée',
  `arrival_time` time DEFAULT NULL COMMENT 'Heure d''arrivée',
  `carrier` varchar(2) DEFAULT NULL COMMENT 'Code IATA compagnie (ex: QR)',
  `carrier_name` varchar(100) DEFAULT NULL COMMENT 'Nom compagnie aérienne',
  `flight_number` varchar(10) DEFAULT NULL COMMENT 'Numéro de vol (ex: 1003)',
  `booking_class` varchar(2) DEFAULT NULL COMMENT 'Classe de réservation (Y, H, M, etc.)',
  `service_class` varchar(20) DEFAULT NULL COMMENT 'Classe de service (Economy, Business, etc.)',
  `aircraft_type` varchar(10) DEFAULT NULL COMMENT 'Type d''appareil (77W, 788, etc.)',
  `fare_basis` varchar(50) DEFAULT NULL COMMENT 'Base tarifaire',
  `baggage_allowance` varchar(20) DEFAULT NULL COMMENT 'Franchise bagages (ex: 2PC, 23K)',
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL,
  `modified_by` int(11) NOT NULL DEFAULT 1 COMMENT 'ID utilisateur modification',
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Soft delete',
  `created_by` bigint(20) unsigned DEFAULT 1,
  `updated_by` bigint(20) unsigned DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `segments_uuid_unique` (`uuid`),
  UNIQUE KEY `uk_segments_uuid` (`uuid`),
  UNIQUE KEY `segments_name_unique` (`name`),
  KEY `idx_pnr_uuid` (`pnr_uuid`),
  KEY `idx_segment_number` (`segment_number`),
  KEY `idx_type` (`type`),
  KEY `idx_status` (`status`),
  KEY `idx_departure_code` (`departure_code`),
  KEY `idx_arrival_code` (`arrival_code`),
  KEY `idx_carrier` (`carrier`),
  KEY `idx_departure_date` (`departure_date`),
  KEY `idx_pnr_departure` (`pnr_uuid`,`departure_date`),
  KEY `idx_carrier_date` (`carrier`,`departure_date`),
  KEY `fk_segments_pnr_id` (`pnr_id`),
  KEY `segments_date_index` (`date`),
  KEY `segments_created_by_foreign` (`created_by`),
  KEY `segments_updated_by_foreign` (`updated_by`),
  CONSTRAINT `fk_segments_pnr_id` FOREIGN KEY (`pnr_id`) REFERENCES `pnr` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `segments_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `segments_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `segments`
--


--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(150) DEFAULT NULL,
  `name` varchar(150) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `service` varchar(255) NOT NULL,
  `category` enum('Billetterie','Tourisme','Divers') DEFAULT NULL,
  `price` float DEFAULT NULL,
  `taxes` varchar(255) DEFAULT NULL,
  `commission` float DEFAULT NULL,
  `buy_price` float DEFAULT NULL,
  `sale_unit` enum('Hours','Days','Incidents') DEFAULT NULL,
  `number_unit` float DEFAULT NULL,
  `active` tinyint(1) DEFAULT NULL,
  `site_web` varchar(255) DEFAULT NULL,
  `sales_start_date` date DEFAULT NULL,
  `sales_end_date` date DEFAULT NULL,
  `description` text DEFAULT NULL,
  `source` varchar(255) DEFAULT NULL,
  `external_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `is_deleted` tinyint(4) DEFAULT 0,
  `created_by` bigint(20) unsigned DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_services_uuid` (`uuid`),
  UNIQUE KEY `uk_services_name` (`name`),
  KEY `services_users_dernière_modification_par_FK` (`updated_by`),
  KEY `services_date_index` (`date`),
  KEY `services_created_by_foreign` (`created_by`),
  CONSTRAINT `services_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `services_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=404379 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` VALUES
(1,'65ad8d7c-450c-437a-940b-33269bc82afb','Ticket','2022-07-08 17:56:07','Ticket','Billetterie',0,NULL,0,0,NULL,0,1,NULL,NULL,NULL,NULL,'CRM',5159,'2022-07-08 17:56:07','2026-01-24 17:22:20',NULL,0,1),
(2,'6fbbdf42-0c46-408b-8a27-860503b62bb8','Tickets_ABJ','2022-06-02 16:10:09','Tickets_ABJ','Billetterie',0,NULL,0,0,NULL,1,1,NULL,NULL,NULL,NULL,'CRM',15,'2022-06-02 16:10:09','2026-01-24 17:05:21',1,0,1),
(3,'9bf7fe6d-324e-4170-8563-4256100ba813','Emd','2022-07-08 17:56:15','Emd','Billetterie',0,NULL,0,0,NULL,0,1,NULL,NULL,NULL,NULL,'CRM',5160,'2022-07-08 17:56:15','2026-01-24 17:22:20',NULL,0,1),
(4,'100cbfad-5793-47c6-abff-451d00f322d6','Visite guidée','2023-10-02 16:02:15','Visite guidée','Tourisme',100000,NULL,0,0,'Hours',0,1,NULL,NULL,NULL,NULL,'CRM',123225,'2023-10-02 16:02:15','2026-01-24 17:22:20',NULL,0,1),
(5,'e7d47d24-6bb9-42bf-9f93-bfd178829b0b','Location','2024-10-20 11:17:37','Location','Tourisme',0,NULL,0,0,'Days',0,1,NULL,NULL,NULL,NULL,'CRM',404378,'2024-10-20 11:17:37','2026-01-24 17:22:20',NULL,0,1);

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`),
  CONSTRAINT `sessions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--


--
-- Table structure for table `soldes`
--

CREATE TABLE `soldes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(150) DEFAULT NULL,
  `name` varchar(150) DEFAULT NULL,
  `date` date NOT NULL,
  `account_id` bigint(20) unsigned DEFAULT NULL,
  `balance` float DEFAULT NULL,
  `outstanding` float DEFAULT NULL,
  `exposition` float DEFAULT NULL,
  `balance_d-1` float DEFAULT NULL,
  `balance_m-1` float DEFAULT NULL,
  `balance_m-2` float DEFAULT NULL,
  `limit` float DEFAULT NULL,
  `daily_credit` float DEFAULT NULL,
  `balance_bmp` float DEFAULT NULL,
  `gap` float DEFAULT NULL,
  `external_id` int(11) DEFAULT NULL,
  `source` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `modified_at` datetime DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `is_deleted` tinyint(4) DEFAULT 0,
  `created_by` bigint(20) unsigned DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_soldes_uuid` (`uuid`),
  UNIQUE KEY `uk_soldes_name` (`name`),
  KEY `soldes_users_modified_by_FK` (`updated_by`),
  KEY `soldes_accounts_comptes_FK` (`account_id`),
  KEY `soldes_created_by_foreign` (`created_by`),
  CONSTRAINT `soldes_accounts_comptes_FK` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`),
  CONSTRAINT `soldes_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `soldes_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `soldes`
--


--
-- Table structure for table `soldesbmp`
--

CREATE TABLE `soldesbmp` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(150) DEFAULT NULL,
  `name` varchar(150) DEFAULT NULL,
  `subagent` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `bmp_amount` float DEFAULT NULL,
  `estair_amount` float DEFAULT NULL,
  `payments` float DEFAULT NULL,
  `outstanding` float DEFAULT NULL,
  `limit` varchar(255) DEFAULT NULL,
  `balance_date` date DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `currency` enum('XOF','USD','EUR') DEFAULT NULL,
  `document_id` bigint(20) unsigned DEFAULT NULL,
  `consolidator` enum('CTCI','OVI') DEFAULT NULL,
  `account_id` bigint(20) unsigned DEFAULT NULL,
  `solde_id` bigint(20) unsigned DEFAULT NULL,
  `description` text DEFAULT NULL,
  `source` varchar(255) DEFAULT NULL,
  `external_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `modified_at` datetime DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `is_deleted` tinyint(4) DEFAULT 0,
  `created_by` bigint(20) unsigned DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_soldesbmp_uuid` (`uuid`),
  UNIQUE KEY `uk_soldesbmp_name` (`name`),
  KEY `soldesbmp_users_modified_by_FK` (`updated_by`),
  KEY `soldesbmp_accounts_comptes_FK` (`account_id`),
  KEY `soldesbmp_documents_documents_FK` (`document_id`),
  KEY `soldesbmp_solde_id_index` (`solde_id`),
  KEY `soldesbmp_created_by_foreign` (`created_by`),
  CONSTRAINT `soldesbmp_accounts_comptes_FK` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`),
  CONSTRAINT `soldesbmp_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `soldesbmp_documents_documents_FK` FOREIGN KEY (`document_id`) REFERENCES `documents` (`id`),
  CONSTRAINT `soldesbmp_solde_id_foreign` FOREIGN KEY (`solde_id`) REFERENCES `soldes` (`id`) ON DELETE SET NULL,
  CONSTRAINT `soldesbmp_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `soldesbmp`
--


--
-- Table structure for table `subscription_invoices`
--

CREATE TABLE `subscription_invoices` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) NOT NULL,
  `subscription_id` bigint(20) unsigned NOT NULL,
  `account_id` bigint(20) unsigned NOT NULL,
  `invoice_number` varchar(50) NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'draft',
  `amount_ht` decimal(10,2) NOT NULL,
  `tax_rate` decimal(5,2) NOT NULL DEFAULT 18.00,
  `tax_amount` decimal(10,2) NOT NULL,
  `amount_ttc` decimal(10,2) NOT NULL,
  `currency` varchar(3) NOT NULL DEFAULT 'XOF',
  `period_start` datetime NOT NULL,
  `period_end` datetime NOT NULL,
  `issued_at` datetime DEFAULT NULL,
  `due_at` datetime DEFAULT NULL,
  `paid_at` datetime DEFAULT NULL,
  `payment_method` varchar(50) DEFAULT NULL,
  `payment_reference` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscription_invoices_uuid_unique` (`uuid`),
  UNIQUE KEY `subscription_invoices_invoice_number_unique` (`invoice_number`),
  KEY `subscription_invoices_subscription_id_foreign` (`subscription_id`),
  KEY `subscription_invoices_account_id_status_index` (`account_id`,`status`),
  KEY `subscription_invoices_status_index` (`status`),
  CONSTRAINT `subscription_invoices_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `subscription_invoices_subscription_id_foreign` FOREIGN KEY (`subscription_id`) REFERENCES `subscriptions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscription_invoices`
--


--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) NOT NULL,
  `account_id` bigint(20) unsigned NOT NULL,
  `plan` varchar(20) NOT NULL DEFAULT 'basic',
  `status` varchar(20) NOT NULL DEFAULT 'trial',
  `billing_cycle` varchar(10) NOT NULL DEFAULT 'monthly',
  `monthly_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `annual_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `max_users` int(11) NOT NULL DEFAULT 3,
  `features` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`features`)),
  `trial_starts_at` datetime DEFAULT NULL,
  `trial_ends_at` datetime DEFAULT NULL,
  `started_at` datetime DEFAULT NULL,
  `current_period_start` datetime DEFAULT NULL,
  `current_period_end` datetime DEFAULT NULL,
  `cancelled_at` datetime DEFAULT NULL,
  `suspended_at` datetime DEFAULT NULL,
  `cancellation_reason` varchar(255) DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscriptions_uuid_unique` (`uuid`),
  KEY `subscriptions_account_id_status_index` (`account_id`,`status`),
  KEY `subscriptions_status_index` (`status`),
  CONSTRAINT `subscriptions_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscriptions`
--


--
-- Table structure for table `transaction`
--

CREATE TABLE `transaction` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(150) DEFAULT NULL,
  `name` varchar(150) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `assigné_à` varchar(255) NOT NULL,
  `modified_at` datetime DEFAULT NULL,
  `transaction_no` varchar(255) DEFAULT NULL,
  `créé_par` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `tags` varchar(255) DEFAULT NULL,
  `starred` tinyint(1) DEFAULT NULL,
  `source` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `date_de_reception` date NOT NULL,
  `heure_de_reception` varchar(255) DEFAULT NULL,
  `reference` varchar(255) NOT NULL,
  `sens` enum('Debit','Credit') NOT NULL,
  `compte` bigint(20) unsigned NOT NULL,
  `compte_bancaire` bigint(20) unsigned DEFAULT NULL,
  `approvisionnement` bigint(20) unsigned DEFAULT NULL,
  `frais_operation` enum('Oui','Non') DEFAULT NULL,
  `montant` float DEFAULT NULL,
  `statut` enum('A traiter','Termine','A charger') DEFAULT NULL,
  `banques` bigint(20) unsigned DEFAULT NULL,
  `transactionid` int(11) DEFAULT NULL,
  `is_deleted` tinyint(4) DEFAULT 0,
  `created_by` bigint(20) unsigned DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_transaction_uuid` (`uuid`),
  UNIQUE KEY `uk_transaction_name` (`name`),
  KEY `transaction_users_créé_par_FK` (`créé_par`),
  KEY `transaction_users_modified_by_FK` (`updated_by`),
  KEY `transaction_accounts_compte_FK` (`compte`),
  KEY `transaction_comptesbancaires_compte_bancaire_FK` (`compte_bancaire`),
  KEY `transaction_approvisionnements_approvisionnement_FK` (`approvisionnement`),
  KEY `transaction_banques_banques_FK` (`banques`),
  KEY `transaction_date_index` (`date`),
  KEY `transaction_created_by_foreign` (`created_by`),
  CONSTRAINT `transaction_accounts_compte_FK` FOREIGN KEY (`compte`) REFERENCES `accounts` (`id`),
  CONSTRAINT `transaction_approvisionnements_approvisionnement_FK` FOREIGN KEY (`approvisionnement`) REFERENCES `approvisionnements` (`id`),
  CONSTRAINT `transaction_banques_banques_FK` FOREIGN KEY (`banques`) REFERENCES `banques` (`id`),
  CONSTRAINT `transaction_comptesbancaires_compte_bancaire_FK` FOREIGN KEY (`compte_bancaire`) REFERENCES `comptesbancaires` (`id`),
  CONSTRAINT `transaction_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `transaction_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `transaction_users_créé_par_FK` FOREIGN KEY (`créé_par`) REFERENCES `users_old` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transaction`
--


--
-- Table structure for table `vendors`
--

CREATE TABLE `vendors` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(150) DEFAULT NULL,
  `name` varchar(150) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `site_web` varchar(255) DEFAULT NULL,
  `category` varchar(255) DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `street` text DEFAULT NULL,
  `postal_box` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `source` varchar(255) DEFAULT NULL,
  `pays` bigint(20) unsigned DEFAULT NULL,
  `externa_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `is_deleted` tinyint(4) DEFAULT 0,
  `created_by` bigint(20) unsigned DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_vendors_uuid` (`uuid`),
  UNIQUE KEY `uk_vendors_name` (`name`),
  KEY `vendors_users_dernière_modification_par_FK` (`updated_by`),
  KEY `vendors_listepays_pays_FK` (`pays`),
  KEY `vendors_date_index` (`date`),
  KEY `vendors_created_by_foreign` (`created_by`),
  CONSTRAINT `vendors_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `vendors_listepays_pays_FK` FOREIGN KEY (`pays`) REFERENCES `listepays` (`id`),
  CONSTRAINT `vendors_users_dernière_modification_par_FK` FOREIGN KEY (`updated_by`) REFERENCES `users_old` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=413019 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vendors`
--

INSERT INTO `vendors` VALUES
(1,'a3580de0-4a13-4084-b676-8b1b9a903d2d','ABJ26222P','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,8,NULL,NULL,NULL,NULL,'CRM',NULL,2,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(25743,'473978c2-cb27-480e-8fd7-bdce2a65b605','ABJ26222Y','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,8,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,25743,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(101071,'6fc0f9ed-99e4-4853-8d13-16c99ccb8dd7','TOP TRAVEL TRIP','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,101071,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(101083,'64a3693f-d2d9-44ed-8017-9c97f72c4d2e','SN BRUSSELS','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,101083,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(102085,'c43ba151-11db-4bfb-87ce-9f1e6d10a09b','OVI','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,102085,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(102089,'6bd7c384-3e1c-4c23-80bf-b0dfdc40200c','TRAVEL BLUE','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,102089,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(102105,'9a352317-bbe5-41c7-966b-7eed3e40d6ad','OMED VOYAGES','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,102105,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(102114,'3589157e-9782-4ba3-96e1-6e581b7edd48','QUEEN VOYAGES','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,102114,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(102124,'147e5a12-fa7c-4155-8553-602c606ac7fa','CETERIS TOURS','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,102124,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(102145,'c4cfb829-fac2-4206-be39-ebfc462975a2','HF','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,102145,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(102159,'c5038189-bd80-499e-a399-e8db69ce4ae4','MEA','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,102159,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(102256,'a70a11d9-9993-450b-8ef2-d89b307ff41f','Hermes Voyages','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,102256,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(102265,'83f95e6e-60a2-4092-9a15-2d2d29920767','TU','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,102265,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(102323,'2880e125-41de-4ed7-a3fe-35feeb435723','L6','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,102323,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(102330,'df41e36b-8c13-4ce2-ac52-9a7cc0fe470d','EMIRATES','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,102330,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(102348,'ba4e20db-3d5f-4dc0-bd3a-5d06296877db','KQ','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,102348,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(102395,'0b784ad7-9d07-44a2-86a6-c5b3a8ec6d52','ARROW TRAVEL','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,102395,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(102479,'812e57df-145b-4adc-9ff4-7fa639df0a2c','CORSAIR','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,102479,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(102500,'93d5706b-e85b-41c7-b0ce-9f535d1da872','HC','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,102500,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(102530,'c804c18a-9740-4ed2-a46d-82aa1bbb251f','AF','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,102530,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(102554,'4f2958e7-bdd1-41da-8f68-8a145f1d23c3','AT','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,102554,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(102564,'e7ef9657-7bb6-41f7-9cfd-d8e587758e2b','KP','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,102564,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(103423,'02a6488d-fe3f-476d-8d5b-0850487574a9','Balaji voyages','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,103423,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(104420,'a480326f-1ce7-4172-9257-1381ded88926','SN','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,104420,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(116744,'c3aa0f4e-a542-4ef7-ac94-8ece97895bf0','Orange CI','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,116744,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(116746,'daa60042-273f-4681-80ec-7bf57affef04','Divers','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,116746,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(116749,'b66b359e-1580-4749-b747-8b30149729bb','Oenophile','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,116749,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(116752,'3e47593c-f6dd-4154-99f6-92c243f9f1c8','Thomas','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,116752,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(116758,'4b9f9ae9-efc5-421a-9c0f-4ac6a6260c3f','Wave','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,116758,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(118169,'5a0c95b9-1f97-4548-81ce-8dc92a7d1ac0','ABJ262331','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,118169,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(119551,'87402b07-2f5e-4c2d-9427-b9e8d8988990','VTE EXPERT','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'CRM',NULL,119551,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(121660,'78133197-2c47-4b87-8931-01e9bd37f128','Interimmobilier','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'CRM',NULL,121660,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(123275,'27ad8f0f-1a40-4ab9-b2f5-e5ace5c0ebeb','Iata','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'CRM',NULL,123275,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(136195,'968e722c-0f02-4a7a-b621-0d8273e20f35','CIE','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'CRM',NULL,136195,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(136552,'ea7cd36f-853e-437a-aa0f-4f07a29adfff','SODECI','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'CRM',NULL,136552,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(136647,'48a6b477-41b5-4a16-88b9-523ef485ac89','Ecobank','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'CRM',NULL,136647,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(138077,'12f1d46b-fe47-4629-be7f-ffdfab7fda26','Agicap','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'CRM',NULL,138077,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(148283,'26bf3df7-97ca-435a-8840-edd7f8775eba','OVH','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'CRM',NULL,148283,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(148285,'ca6dfdbe-fcbe-44f9-b8c7-fee81594dfea','LegalStart','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'CRM',NULL,148285,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(148287,'405c1b61-437f-439f-99d1-b19773dfc5a4','Kandbaz','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'CRM',NULL,148287,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(148289,'f93c5afc-62a4-4dc4-88c7-47fecc056832','Qonto','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'CRM',NULL,148289,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(148291,'aa6b04cf-d085-427f-8fe1-4134d181d82d','Lumens','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'CRM',NULL,148291,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(148293,'65ceb5c3-6f16-487c-b4ec-0fba3f5bbcac','Nespresso','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'CRM',NULL,148293,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(148297,'864835a8-50ca-49b7-a0b8-1ee68753cbde','Librairie de France','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'CRM',NULL,148297,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(148303,'990130d6-a67d-4733-ba3c-c8dd5d2c5935','ASUS','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'CRM',NULL,148303,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(148305,'113b9ac1-9fd6-4255-a008-2c3194a07cd0','CCM','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'CRM',NULL,148305,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(161827,'fc2d9770-f530-414c-a00c-4f5100178ad6','VENDORS_161827','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'CRM',NULL,161827,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(163603,'c20781e2-65a4-4425-9ae2-6dafa365265c','VENDORS_163603','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'CRM',NULL,163603,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(163604,'0f2414c1-fb04-4afd-a73b-da76b17af0a9','Heetch','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'CRM',NULL,163604,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(163605,'f5a4b2d8-2d54-400f-b149-ee4057770475','Taxi compteur','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'CRM',NULL,163605,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(191786,'a810110f-1dd8-4831-8bde-78c3d2673933','TURKISH','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,191786,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(230866,'d141b139-a4de-49a0-9fcb-614da308ddca','ABJ26222P-AF','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'CRM',NULL,230866,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(253978,'8ddb1171-8e55-4792-8cf6-fb8eca5f48a4','T3','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,253978,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(300817,'e0412a25-1697-4a21-b569-a45c8400b734','ABJ26222P_REFUND','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,300817,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(301030,'11176951-1d8a-4cc5-8faa-0a226723f343','ABJ26222P_BSP','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,301030,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(301034,'b02fffb4-97d2-4d62-a62e-a0e7034d125a','ABJ26222P_EK','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,301034,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(301335,'1c1b2c95-508d-4d14-a240-d1d5930352d6','ABJ26222P_AF','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,301335,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(315470,'c9edb152-b7d8-42d7-8300-fc5accd5e09b','ALIOS-FINANCE','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'CRM',NULL,315470,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(374695,'eab4f535-b1e1-4b6f-bfbb-56e88d12aa20','ABJ26222P_REF','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,374695,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1),
(413018,'b0d1c604-24eb-466d-9fee-b1d23a4e8043','EK','2025-07-04 06:23:57',NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,'WEBSERVICE',NULL,413018,'2025-07-04 04:23:57','2026-01-24 17:05:22',0,1);


