ALTER TABLE `cash_flows` ADD `source_key` text;
--> statement-breakpoint
ALTER TABLE `cash_flows` ADD `party_code` text;
--> statement-breakpoint
ALTER TABLE `cash_flows` ADD `invoice_date` text;
--> statement-breakpoint
ALTER TABLE `cash_flows` ADD `legal_due_date` text;
--> statement-breakpoint
ALTER TABLE `cash_flows` ADD `original_amount` real;
--> statement-breakpoint
ALTER TABLE `cash_flows` ADD `remaining_amount` real;
--> statement-breakpoint
ALTER TABLE `cash_flows` ADD `source_file` text;
--> statement-breakpoint
ALTER TABLE `cash_flows` ADD `source_row` integer;
--> statement-breakpoint
ALTER TABLE `cash_flows` ADD `imported_at` text;
--> statement-breakpoint
ALTER TABLE `cash_flows` ADD `active` integer DEFAULT true NOT NULL;
--> statement-breakpoint
CREATE UNIQUE INDEX `cash_flows_source_key_unique` ON `cash_flows` (`source_key`);
--> statement-breakpoint
CREATE INDEX `idx_cash_flows_active_planned_date` ON `cash_flows` (`active`,`planned_date`);
--> statement-breakpoint
CREATE TABLE `import_batches` (`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL, `kind` text NOT NULL, `file_name` text NOT NULL, `source_rows` integer NOT NULL, `open_rows` integer NOT NULL, `total_remaining` real NOT NULL, `imported_at` text NOT NULL);
--> statement-breakpoint
CREATE INDEX `idx_import_batches_kind_date` ON `import_batches` (`kind`,`imported_at`);
--> statement-breakpoint
UPDATE `cash_flows` SET `active` = false;
--> statement-breakpoint
INSERT INTO `cash_flows` (`kind`,`party`,`reference`,`amount`,`due_date`,`planned_date`,`status`,`manual_override`,`source_key`,`party_code`,`invoice_date`,`legal_due_date`,`original_amount`,`remaining_amount`,`source_file`,`source_row`,`imported_at`,`active`) VALUES
('client','THALVIN','2600375-5',23108.89,'2026-08-20','2026-08-20','planifié',0,'client:2600375-5','34210025','2026-08-10','2026-10-09',23108.89,23108.89,'ETAT CLIENT.xlsx',2,'2026-08-16T16:00:00.000Z',1),
('client','THALVIN','2600374-5',70972.73,'2026-08-20','2026-08-20','planifié',0,'client:2600374-5','34210025','2026-08-10','2026-10-09',70972.73,70972.73,'ETAT CLIENT.xlsx',3,'2026-08-16T16:00:00.000Z',1),
('client','THALVIN','2600376-5',-2822.45,'2026-08-20','2026-08-20','planifié',0,'client:2600376-5','34210025','2026-08-10','2026-10-09',-2822.45,-2822.45,'ETAT CLIENT.xlsx',4,'2026-08-16T16:00:00.000Z',1),
('client','Tiers à créer','2600372-4',9790.0,'2026-09-06','2026-09-06','planifié',0,'client:2600372-4','34210287','2026-08-07','2026-10-06',9790.0,9790.0,'ETAT CLIENT.xlsx',5,'2026-08-16T16:00:00.000Z',1),
('client','IDNAFOOD  EX   LES CONSERVERIES DU','2600373-4',10340.0,'2026-09-06','2026-09-06','planifié',0,'client:2600373-4','34210237','2026-08-07','2026-10-06',10340.0,10340.0,'ETAT CLIENT.xlsx',6,'2026-08-16T16:00:00.000Z',1),
('client','EBERTEC','2600364-2',117670.2,'2026-08-14','2026-08-14','en retard',0,'client:2600364-2','34210012','2026-08-04','2026-10-05',117670.2,117670.2,'ETAT CLIENT.xlsx',7,'2026-08-16T16:00:00.000Z',1),
('client','EBERTEC','2600365-2',31456.8,'2026-08-14','2026-08-14','en retard',0,'client:2600365-2','34210012','2026-08-04','2026-10-05',31456.8,31456.8,'ETAT CLIENT.xlsx',8,'2026-08-16T16:00:00.000Z',1),
('client','EBERTEC','2600366-2',-17169.27,'2026-08-14','2026-08-14','en retard',0,'client:2600366-2','34210012','2026-08-04','2026-10-05',-17169.27,-17169.27,'ETAT CLIENT.xlsx',9,'2026-08-16T16:00:00.000Z',1),
('client','EBERTEC','2600361-2',219103.96,'2026-08-14','2026-08-14','en retard',0,'client:2600361-2','34210012','2026-08-04','2026-10-05',219103.96,219103.96,'ETAT CLIENT.xlsx',10,'2026-08-16T16:00:00.000Z',1),
('client','EBERTEC','2600362-2',100038.4,'2026-08-14','2026-08-14','en retard',0,'client:2600362-2','34210012','2026-08-04','2026-10-05',100038.4,100038.4,'ETAT CLIENT.xlsx',11,'2026-08-16T16:00:00.000Z',1),
('client','EBERTEC','2600363-2',104039.94,'2026-08-14','2026-08-14','en retard',0,'client:2600363-2','34210012','2026-08-04','2026-10-05',104039.94,104039.94,'ETAT CLIENT.xlsx',12,'2026-08-16T16:00:00.000Z',1),
('client','ROSLANE WINE & SPIRIT','2600370-3',6298.49,'2026-08-14','2026-08-14','en retard',0,'client:2600370-3','34210052','2026-08-04','2026-10-05',6298.49,6298.49,'ETAT CLIENT.xlsx',13,'2026-08-16T16:00:00.000Z',1),
('client','MARJANE','2600368-2',2914.02,'2026-09-03','2026-09-03','planifié',0,'client:2600368-2','34210284','2026-08-04','2026-10-05',2914.02,2914.02,'ETAT CLIENT.xlsx',14,'2026-08-16T16:00:00.000Z',1),
('client','MARJANE','2600367-2',29140.19,'2026-09-03','2026-09-03','planifié',0,'client:2600367-2','34210284','2026-08-04','2026-10-05',29140.19,29140.19,'ETAT CLIENT.xlsx',15,'2026-08-16T16:00:00.000Z',1),
('client','ROSLANE WINE & SPIRIT','2600359-1',131929.47,'2026-08-13','2026-08-13','en retard',0,'client:2600359-1','34210052','2026-08-03','2026-10-02',131929.47,131929.47,'ETAT CLIENT.xlsx',16,'2026-08-16T16:00:00.000Z',1),
('client','ROSLANE WINE & SPIRIT','2600360-11',134292.0,'2026-08-10','2026-08-10','en retard',0,'client:2600360-11','34210052','2026-07-31','2026-09-29',134292.0,134292.0,'ETAT CLIENT.xlsx',17,'2026-08-16T16:00:00.000Z',1),
('client','ROSLANE WINE & SPIRIT','2600369-12',89001.0,'2026-08-10','2026-08-10','en retard',0,'client:2600369-12','34210052','2026-07-31','2026-09-29',89001.0,89001.0,'ETAT CLIENT.xlsx',18,'2026-08-16T16:00:00.000Z',1),
('client','ROSLANE WINE & SPIRIT','2600371-13',-10845.64,'2026-08-10','2026-08-10','en retard',0,'client:2600371-13','34210052','2026-07-31','2026-09-29',-10845.64,-10845.64,'ETAT CLIENT.xlsx',19,'2026-08-16T16:00:00.000Z',1),
('client','THALVIN','2600355-9',30143.96,'2026-07-31','2026-07-31','en retard',0,'client:2600355-9','34210025','2026-07-21','2026-09-21',30143.96,30143.96,'ETAT CLIENT.xlsx',21,'2026-08-16T16:00:00.000Z',1),
('client','THALVIN','2600354-9',78309.3,'2026-07-31','2026-07-31','en retard',0,'client:2600354-9','34210025','2026-07-21','2026-09-21',78309.3,78309.3,'ETAT CLIENT.xlsx',22,'2026-08-16T16:00:00.000Z',1),
('client','THALVIN','2600357-9',-3253.6,'2026-07-31','2026-07-31','en retard',0,'client:2600357-9','34210025','2026-07-21','2026-09-21',-3253.6,-3253.6,'ETAT CLIENT.xlsx',23,'2026-08-16T16:00:00.000Z',1),
('client','TEGIC TRANSPORT','2600356-10',-7150.0,'2026-08-19','2026-08-19','planifié',0,'client:2600356-10','34210279','2026-07-20','2026-09-18',-7150.0,-7150.0,'ETAT CLIENT.xlsx',27,'2026-08-16T16:00:00.000Z',1),
('client','EBERTEC','2600348-7',-2120.9,'2026-07-27','2026-07-27','en retard',0,'client:2600348-7','34210012','2026-07-17','2026-09-15',-2120.9,-2120.9,'ETAT CLIENT.xlsx',30,'2026-08-16T16:00:00.000Z',1),
('client','ROSLANE WINE & SPIRIT','2600345-6',144153.22,'2026-07-25','2026-07-25','en retard',0,'client:2600345-6','34210052','2026-07-15','2026-09-14',144153.22,144153.22,'ETAT CLIENT.xlsx',31,'2026-08-16T16:00:00.000Z',1),
('client','ROSLANE WINE & SPIRIT','2600346-6',-4324.6,'2026-07-25','2026-07-25','en retard',0,'client:2600346-6','34210052','2026-07-15','2026-09-14',-4324.6,-4324.6,'ETAT CLIENT.xlsx',32,'2026-08-16T16:00:00.000Z',1),
('client','DALIA CORP','2600341-3',20594.2,'2026-09-06','2026-09-06','planifié',0,'client:2600341-3','34210280','2026-07-06','2026-09-04',20594.2,20594.2,'ETAT CLIENT.xlsx',33,'2026-08-16T16:00:00.000Z',1),
('client','DALIA FOODS','2600340-3',2090.0,'2026-09-06','2026-09-06','planifié',0,'client:2600340-3','34210282','2026-07-06','2026-09-04',2090.0,2090.0,'ETAT CLIENT.xlsx',34,'2026-08-16T16:00:00.000Z',1),
('client','DALIA FOODS','2600339-3',24853.4,'2026-09-06','2026-09-06','planifié',0,'client:2600339-3','34210282','2026-07-06','2026-09-04',24853.4,24853.4,'ETAT CLIENT.xlsx',35,'2026-08-16T16:00:00.000Z',1),
('client','LOGANDIS','2600343-4',1037.25,'2026-09-06','2026-09-06','planifié',0,'client:2600343-4','34210283','2026-07-06','2026-09-04',1037.25,1037.25,'ETAT CLIENT.xlsx',36,'2026-08-16T16:00:00.000Z',1),
('client','DALIA CORP','2600342-3',1045.0,'2026-09-06','2026-09-06','planifié',0,'client:2600342-3','34210280','2026-07-06','2026-09-04',1045.0,1045.0,'ETAT CLIENT.xlsx',37,'2026-08-16T16:00:00.000Z',1),
('client','MARJANE','2600337-2',25060.2,'2026-08-02','2026-08-02','en retard',0,'client:2600337-2','34210284','2026-07-03','2026-09-01',25060.2,25060.2,'ETAT CLIENT.xlsx',38,'2026-08-16T16:00:00.000Z',1),
('client','IDNAFOOD  EX   LES CONSERVERIES DU','2600336-2',13750.0,'2026-08-02','2026-08-02','en retard',0,'client:2600336-2','34210237','2026-07-03','2026-09-01',13750.0,13750.0,'ETAT CLIENT.xlsx',39,'2026-08-16T16:00:00.000Z',1),
('client','MARJANE','2600344-5',2506.02,'2026-08-02','2026-08-02','en retard',0,'client:2600344-5','34210284','2026-07-03','2026-09-01',2506.02,2506.02,'ETAT CLIENT.xlsx',40,'2026-08-16T16:00:00.000Z',1),
('client','MARJANE','2600338-2',1890.9,'2026-08-02','2026-08-02','en retard',0,'client:2600338-2','34210284','2026-07-03','2026-09-01',1890.9,1890.9,'ETAT CLIENT.xlsx',41,'2026-08-16T16:00:00.000Z',1),
('client','THALVIN','2600334-1',2888.61,'2026-07-12','2026-07-12','en retard',0,'client:2600334-1','34210025','2026-07-02','2026-08-31',2888.61,2888.61,'ETAT CLIENT.xlsx',51,'2026-08-16T16:00:00.000Z',1),
('client','DALIA FOODS','2600318-8',10450.0,'2026-08-25','2026-08-25','planifié',0,'client:2600318-8','34210282','2026-06-25','2026-08-24',10450.0,10450.0,'ETAT CLIENT.xlsx',57,'2026-08-16T16:00:00.000Z',1),
('client','DALIA CORP','2600319-8',2970.0,'2026-08-25','2026-08-25','planifié',0,'client:2600319-8','34210280','2026-06-25','2026-08-24',2970.0,2970.0,'ETAT CLIENT.xlsx',58,'2026-08-16T16:00:00.000Z',1),
('client','DALIA CORP','2600316-8',18264.95,'2026-08-25','2026-08-25','planifié',0,'client:2600316-8','34210280','2026-06-25','2026-08-24',18264.95,18264.95,'ETAT CLIENT.xlsx',59,'2026-08-16T16:00:00.000Z',1),
('client','DALIA FOODS','2600317-8',53153.1,'2026-08-25','2026-08-25','planifié',0,'client:2600317-8','34210282','2026-06-25','2026-08-24',53153.1,53153.1,'ETAT CLIENT.xlsx',60,'2026-08-16T16:00:00.000Z',1),
('client','DALIA FOODS','2600289-3',-78545.79,'2026-08-04','2026-08-04','en retard',0,'client:2600289-3','34210282','2026-06-04','2026-08-03',-78545.79,-78545.79,'ETAT CLIENT.xlsx',74,'2026-08-16T16:00:00.000Z',1),
('client','DALIA FOODS','2600279-1',4180.0,'2026-08-01','2026-08-01','en retard',0,'client:2600279-1','34210282','2026-06-01','2026-07-31',4180.0,4180.0,'ETAT CLIENT.xlsx',94,'2026-08-16T16:00:00.000Z',1),
('client','DALIA FOODS','2600281-1',4180.0,'2026-08-01','2026-08-01','en retard',0,'client:2600281-1','34210282','2026-06-01','2026-07-31',4180.0,4180.0,'ETAT CLIENT.xlsx',101,'2026-08-16T16:00:00.000Z',1),
('client','DALIA FOODS','2600280-1',4180.0,'2026-08-01','2026-08-01','en retard',0,'client:2600280-1','34210282','2026-06-01','2026-07-31',4180.0,4180.0,'ETAT CLIENT.xlsx',103,'2026-08-16T16:00:00.000Z',1),
('client','DALIA FOODS','2600267-14',22174.66,'2026-07-31','2026-07-31','en retard',0,'client:2600267-14','34210282','2026-05-31','2026-07-30',22174.66,22174.66,'ETAT CLIENT.xlsx',109,'2026-08-16T16:00:00.000Z',1),
('client','DALIA FOODS','2600260-11',56371.13,'2026-07-22','2026-07-22','en retard',0,'client:2600260-11','34210282','2026-05-22','2026-07-21',56371.13,56371.13,'ETAT CLIENT.xlsx',123,'2026-08-16T16:00:00.000Z',1),
('client','COMODEX','2600265-13',3291.2,'2026-06-21','2026-06-21','en retard',0,'client:2600265-13','34210285','2026-05-22','2026-07-21',3291.2,3291.2,'ETAT CLIENT.xlsx',131,'2026-08-16T16:00:00.000Z',1),
('client','DALIA FOODS','2600304-17',67439.41,'2026-07-22','2026-07-22','en retard',0,'client:2600304-17','34210282','2026-05-22','2026-07-21',67439.41,67439.41,'ETAT CLIENT.xlsx',132,'2026-08-16T16:00:00.000Z',1),
('client','ROSLANE WINE & SPIRIT','2600214-5',2945.44,'2026-05-25','2026-05-25','en retard',0,'client:2600214-5','34210052','2026-05-15','2026-07-14',2945.44,2945.44,'ETAT CLIENT.xlsx',166,'2026-08-16T16:00:00.000Z',1),
('client','DALIA FOODS','2600129-7',900.0,'2026-06-14','2026-06-14','en retard',0,'client:2600129-7','34210282','2026-04-14','2026-06-15',2280.0,900.0,'ETAT CLIENT.xlsx',232,'2026-08-16T16:00:00.000Z',1),
('client','EBERTEC','2600139-8',1960.75,'2026-04-23','2026-04-23','en retard',0,'client:2600139-8','34210012','2026-04-13','2026-06-12',1960.75,1960.75,'ETAT CLIENT.xlsx',244,'2026-08-16T16:00:00.000Z',1),
('client','EBERTEC','2600138-8',1236.8,'2026-04-23','2026-04-23','en retard',0,'client:2600138-8','34210012','2026-04-13','2026-06-12',1236.8,1236.8,'ETAT CLIENT.xlsx',245,'2026-08-16T16:00:00.000Z',1),
('client','ROSLANE WINE & SPIRIT','2600127-6',-336.53,'2026-04-12','2026-04-12','en retard',0,'client:2600127-6','34210052','2026-04-02','2026-06-01',-336.53,-336.53,'ETAT CLIENT.xlsx',277,'2026-08-16T16:00:00.000Z',1),
('client','ROSLANE WINE & SPIRIT','2600103-1',11217.6,'2026-07-02','2026-07-02','en retard',0,'client:2600103-1','34210052','2026-04-02','2026-06-01',11217.6,11217.6,'ETAT CLIENT.xlsx',283,'2026-08-16T16:00:00.000Z',1),
('client','EBERTEC','2600024-7',13484.4,'2026-04-07','2026-04-07','en retard',0,'client:2600024-7','34210012','2026-01-07','2026-03-09',13484.4,13484.4,'ETAT CLIENT.xlsx',379,'2026-08-16T16:00:00.000Z',1),
('client','EBERTEC','2500535-231',1262.46,'2026-03-31','2026-03-31','en retard',0,'client:2500535-231','34210012','2025-12-31','2026-03-02',1262.46,1262.46,'ETAT CLIENT.xlsx',384,'2026-08-16T16:00:00.000Z',1),
('client','EBERTEC','2500534-231',1262.46,'2026-03-31','2026-03-31','en retard',0,'client:2500534-231','34210012','2025-12-31','2026-03-02',1262.46,1262.46,'ETAT CLIENT.xlsx',385,'2026-08-16T16:00:00.000Z',1),
('client','EBERTEC','2500532-231',1262.46,'2026-03-31','2026-03-31','en retard',0,'client:2500532-231','34210012','2025-12-31','2026-03-02',1262.46,1262.46,'ETAT CLIENT.xlsx',404,'2026-08-16T16:00:00.000Z',1),
('client','EBERTEC','2500533-231',1262.46,'2026-03-31','2026-03-31','en retard',0,'client:2500533-231','34210012','2025-12-31','2026-03-02',1262.46,1262.46,'ETAT CLIENT.xlsx',405,'2026-08-16T16:00:00.000Z',1),
('client','EBERTEC','2500531-231',1262.46,'2026-03-31','2026-03-31','en retard',0,'client:2500531-231','34210012','2025-12-31','2026-03-02',1262.46,1262.46,'ETAT CLIENT.xlsx',406,'2026-08-16T16:00:00.000Z',1),
('client','THALVIN','2500468-209',3897.42,'2026-03-17','2026-03-17','en retard',0,'client:2500468-209','34210025','2025-12-17','2026-02-16',3897.42,3897.42,'ETAT CLIENT.xlsx',456,'2026-08-16T16:00:00.000Z',1),
('client','TRANSINTERNATIONL SAIS','2500184',20000.0,'2025-07-24','2025-07-24','en retard',0,'client:2500184','34210259','2025-06-24','2025-08-25',20000.0,20000.0,'ETAT CLIENT.xlsx',748,'2026-08-16T16:00:00.000Z',1),
('client','STE KHADIRI & MAJDI TRANSPORT','2500187',19000.0,'2025-07-24','2025-07-24','en retard',0,'client:2500187','34210257','2025-06-24','2025-08-25',19000.0,19000.0,'ETAT CLIENT.xlsx',750,'2026-08-16T16:00:00.000Z',1),
('fournisseur','SONACOMA','16-217',945000.0,'2025-05-19','2025-05-19','en retard',0,'fournisseur:16-217','44113112','2025-03-19','2025-05-19',945000.0,945000.0,'ETAT FOURNISSEUR.xlsx',8,'2026-08-16T16:00:00.000Z',1),
('fournisseur','SONACOMA','16-224',-945000.0,'2025-05-19','2025-05-19','en retard',0,'fournisseur:16-224','44113112','2025-03-19','2025-05-19',-945000.0,-945000.0,'ETAT FOURNISSEUR.xlsx',9,'2026-08-16T16:00:00.000Z',1),
('fournisseur','SONACOMA','5-181',470000.0,'2025-08-22','2025-08-22','en retard',0,'fournisseur:5-181','44113112','2025-06-21','2025-08-22',470000.0,470000.0,'ETAT FOURNISSEUR.xlsx',76,'2026-08-16T16:00:00.000Z',1),
('fournisseur','SONACOMA','5-240',-470000.0,'2025-08-22','2025-08-22','en retard',0,'fournisseur:5-240','44113112','2025-06-21','2025-08-22',-470000.0,-470000.0,'ETAT FOURNISSEUR.xlsx',77,'2026-08-16T16:00:00.000Z',1),
('fournisseur','REALIDAD TRANSPORTES','123-235',5530.0,'2026-01-23','2026-01-23','en retard',0,'fournisseur:123-235','44110118','2025-11-24','2026-01-23',5530.0,5530.0,'ETAT FOURNISSEUR.xlsx',106,'2026-08-16T16:00:00.000Z',1),
('fournisseur','REALIDAD TRANSPORTES','122-234',5750.0,'2026-01-23','2026-01-23','en retard',0,'fournisseur:122-234','44110118','2025-11-24','2026-01-23',5750.0,5750.0,'ETAT FOURNISSEUR.xlsx',107,'2026-08-16T16:00:00.000Z',1),
('fournisseur','LOTREX','137-241',1008.0,'2026-02-18','2026-02-18','en retard',0,'fournisseur:137-241','44113132','2025-12-20','2026-02-18',675750.0,1008.0,'ETAT FOURNISSEUR.xlsx',116,'2026-08-16T16:00:00.000Z',1),
('fournisseur','SAKI TRAILER 29','19-220',424000.0,'2026-02-20','2026-02-20','en retard',0,'fournisseur:19-220','44113091','2025-12-22','2026-02-20',636000.0,424000.0,'ETAT FOURNISSEUR.xlsx',117,'2026-08-16T16:00:00.000Z',1),
('fournisseur','ATLANTASANAD ASSURANCE','133-5',500.0,'2026-03-09','2026-03-09','en retard',0,'fournisseur:133-5','44113146','2026-01-08','2026-03-09',500.0,500.0,'ETAT FOURNISSEUR.xlsx',126,'2026-08-16T16:00:00.000Z',1),
('fournisseur','MJ LORRIES','140-6',300000.0,'2026-04-01','2026-04-01','en retard',0,'fournisseur:140-6','44110392','2026-01-31','2026-04-01',450000.0,300000.0,'ETAT FOURNISSEUR.xlsx',130,'2026-08-16T16:00:00.000Z',1),
('fournisseur','ATLANTASANAD ASSURANCE','132-4',9658.7,'2026-04-20','2026-04-20','en retard',0,'fournisseur:132-4','44113146','2026-02-18','2026-04-20',9658.7,9658.7,'ETAT FOURNISSEUR.xlsx',137,'2026-08-16T16:00:00.000Z',1),
('fournisseur','CARRIERE WEB','143-2',4320.0,'2026-05-04','2026-05-04','en retard',0,'fournisseur:143-2','44110214','2026-03-04','2026-05-04',4320.0,4320.0,'ETAT FOURNISSEUR.xlsx',142,'2026-08-16T16:00:00.000Z',1),
('fournisseur','SLAOUI LOCAR','163-5',5500.0,'2026-06-01','2026-06-01','en retard',0,'fournisseur:163-5','44110391','2026-03-31','2026-06-01',5500.0,5500.0,'ETAT FOURNISSEUR.xlsx',148,'2026-08-16T16:00:00.000Z',1),
('fournisseur','CARRIERE WEB','144-1',4464.0,'2026-06-03','2026-06-03','en retard',0,'fournisseur:144-1','44110214','2026-04-04','2026-06-03',4464.0,4464.0,'ETAT FOURNISSEUR.xlsx',149,'2026-08-16T16:00:00.000Z',1),
('fournisseur','CARRIERE WEB','145-2',1800.0,'2026-06-03','2026-06-03','en retard',0,'fournisseur:145-2','44110214','2026-04-04','2026-06-03',1800.0,1800.0,'ETAT FOURNISSEUR.xlsx',150,'2026-08-16T16:00:00.000Z',1),
('fournisseur','SOFARDIN SARL','154-1',69165.0,'2026-07-31','2026-07-31','en retard',0,'fournisseur:154-1','44113026','2026-06-01','2026-07-31',69165.0,69165.0,'ETAT FOURNISSEUR.xlsx',162,'2026-08-16T16:00:00.000Z',1),
('fournisseur','JET STATION SERVICES','160-2',199007.06,'2026-08-31','2026-08-31','planifié',0,'fournisseur:160-2','44110309','2026-06-30','2026-08-31',362003.8,199007.06,'ETAT FOURNISSEUR.xlsx',166,'2026-08-16T16:00:00.000Z',1),
('fournisseur','COMPLEXE TOURISTIQUE EL MOUNTAZAH','161-3',33304.0,'2026-08-31','2026-08-31','planifié',0,'fournisseur:161-3','44110134','2026-06-30','2026-08-31',40070.0,33304.0,'ETAT FOURNISSEUR.xlsx',167,'2026-08-16T16:00:00.000Z',1),
('fournisseur','SLAOUI LOCAR','166-5',5500.0,'2026-08-31','2026-08-31','planifié',0,'fournisseur:166-5','44110391','2026-06-30','2026-08-31',5500.0,5500.0,'ETAT FOURNISSEUR.xlsx',168,'2026-08-16T16:00:00.000Z',1),
('fournisseur','MECO TRUCK','172-2',32792.0,'2026-09-25','2026-09-25','planifié',0,'fournisseur:172-2','44110403','2026-07-27','2026-09-25',32792.0,32792.0,'ETAT FOURNISSEUR.xlsx',169,'2026-08-16T16:00:00.000Z',1),
('fournisseur','JET STATION SERVICES','174-3',206988.66,'2026-09-29','2026-09-29','planifié',0,'fournisseur:174-3','44110309','2026-07-31','2026-09-29',206988.66,206988.66,'ETAT FOURNISSEUR.xlsx',170,'2026-08-16T16:00:00.000Z',1),
('fournisseur','SLAOUI LOCAR','167-1',5500.0,'2026-09-29','2026-09-29','planifié',0,'fournisseur:167-1','44110391','2026-07-31','2026-09-29',5500.0,5500.0,'ETAT FOURNISSEUR.xlsx',171,'2026-08-16T16:00:00.000Z',1),
('fournisseur','CREDITRACE','173-3',36000.0,'2026-10-05','2026-10-05','planifié',0,'fournisseur:173-3','44110404','2026-08-04','2026-10-05',36000.0,36000.0,'ETAT FOURNISSEUR.xlsx',172,'2026-08-16T16:00:00.000Z',1),
('fournisseur','ASSISTANCE AL IHSSANE','170-1',7800.0,'2026-10-09','2026-10-09','planifié',0,'fournisseur:170-1','44110402','2026-08-10','2026-10-09',7800.0,7800.0,'ETAT FOURNISSEUR.xlsx',173,'2026-08-16T16:00:00.000Z',1),
('fournisseur','ASSISTANCE AL IHSSANE','171-2',2160.0,'2026-10-09','2026-10-09','planifié',0,'fournisseur:171-2','44110402','2026-08-10','2026-10-09',2160.0,2160.0,'ETAT FOURNISSEUR.xlsx',174,'2026-08-16T16:00:00.000Z',1);
--> statement-breakpoint
INSERT INTO `import_batches` (`kind`,`file_name`,`source_rows`,`open_rows`,`total_remaining`,`imported_at`) VALUES ('client','ETAT CLIENT.xlsx',940,62,1629458.53,'2026-08-16T16:00:00.000Z');
--> statement-breakpoint
INSERT INTO `import_batches` (`kind`,`file_name`,`source_rows`,`open_rows`,`total_remaining`,`imported_at`) VALUES ('fournisseur','ETAT FOURNISSEUR.xlsx',173,25,1360747.42,'2026-08-16T16:00:00.000Z');
--> statement-breakpoint
PRAGMA optimize;