--
-- Host: localhost    Database: laravel
-- ------------------------------------------------------


--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code_client` int(11) DEFAULT NULL,
  `nom` varchar(255) NOT NULL,
  `raison_sociale` varchar(255) DEFAULT NULL,
  `adresse` varchar(255) DEFAULT NULL,
  `cp` varchar(255) DEFAULT NULL,
  `ville` varchar(255) DEFAULT NULL,
  `siret` varchar(255) DEFAULT NULL,
  `telephone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` VALUES
(1,NULL,'ECOBIO',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2024-01-02 08:47:35','2024-01-02 08:47:35'),
(2,NULL,'PLANETE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2024-01-02 08:47:35','2024-01-02 08:47:35');

--
-- Table structure for table `colis`
--

CREATE TABLE `colis` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('taille_fixe','surface_fixe') NOT NULL DEFAULT 'taille_fixe',
  `nb_lames` int(11) NOT NULL DEFAULT 10,
  `longueur` int(11) NOT NULL,
  `surface` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `colis`
--

INSERT INTO `colis` VALUES
(1,'taille_fixe',10,300,0,'2024-01-02 08:47:35','2024-01-02 08:47:35'),
(2,'taille_fixe',10,350,0,'2024-01-02 08:47:35','2024-01-02 08:47:35'),
(3,'taille_fixe',10,400,0,'2024-01-02 08:47:35','2024-01-02 08:47:35'),
(4,'taille_fixe',10,450,0,'2024-01-02 08:47:35','2024-01-02 08:47:35'),
(5,'taille_fixe',10,500,0,'2024-01-02 08:47:35','2024-01-02 08:47:35'),
(6,'taille_fixe',10,550,0,'2024-01-02 08:47:35','2024-01-02 08:47:35'),
(7,'taille_fixe',10,600,0,'2024-01-02 08:47:35','2024-01-02 08:47:35'),
(8,'taille_fixe',10,650,0,'2024-01-02 08:47:35','2024-01-02 08:47:35'),
(9,'taille_fixe',10,700,0,'2024-01-02 08:47:35','2024-01-02 08:47:35'),
(10,'taille_fixe',10,750,0,'2024-01-02 08:47:35','2024-01-02 08:47:35'),
(11,'taille_fixe',10,800,0,'2024-01-02 08:47:35','2024-01-02 08:47:35'),
(12,'taille_fixe',10,850,0,'2024-01-02 08:47:35','2024-01-02 08:47:35'),
(13,'taille_fixe',10,900,0,'2024-01-02 08:47:35','2024-01-02 08:47:35'),
(14,'taille_fixe',10,950,0,'2024-01-02 08:47:35','2024-01-02 08:47:35'),
(15,'taille_fixe',10,1000,0,'2024-01-02 08:47:35','2024-01-02 08:47:35');

--
-- Table structure for table `commandes`
--

CREATE TABLE `commandes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `date_commande` date NOT NULL DEFAULT current_timestamp(),
  `client_id` bigint(20) unsigned NOT NULL,
  `produit_id` bigint(20) unsigned NOT NULL,
  `quantite` int(11) NOT NULL,
  `unite` varchar(255) NOT NULL,
  `date_annonce` date DEFAULT NULL,
  `observations` text DEFAULT NULL,
  `statut` enum('encours','expedie','cloturee','annule') NOT NULL DEFAULT 'encours',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `commandes_client_id_foreign` (`client_id`),
  KEY `commandes_produit_id_foreign` (`produit_id`),
  CONSTRAINT `commandes_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`),
  CONSTRAINT `commandes_produit_id_foreign` FOREIGN KEY (`produit_id`) REFERENCES `produits` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `commandes`
--


--
-- Table structure for table `essences`
--

CREATE TABLE `essences` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `titre` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `essences`
--

INSERT INTO `essences` VALUES
(1,'Châtaignier','2024-01-02 08:47:35','2024-01-02 08:47:35'),
(2,'Chêne','2024-01-02 08:47:35','2024-01-02 08:47:35'),
(3,'Peuplier','2024-01-02 08:47:35','2024-01-02 08:47:35'),
(4,'Douglas','2024-01-02 08:47:35','2024-01-02 08:47:35'),
(5,'Pin','2024-01-02 08:47:35','2024-01-02 08:47:35'),
(6,'Robinier','2024-01-02 08:47:35','2024-01-02 08:47:35'),
(7,'Pin Maritime','2024-01-02 08:47:35','2024-01-02 08:47:35'),
(8,'Acacia','2024-02-28 09:39:10','2024-02-28 09:39:10'),
(9,'Merisier','2024-02-28 12:36:17','2024-02-28 12:36:17'),
(10,'Frêne','2024-03-08 13:47:09','2024-03-08 13:47:09'),
(11,'Hêtre','2024-03-08 13:59:35','2024-03-08 13:59:35');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `inventaires`
--

CREATE TABLE `inventaires` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `produit_id` bigint(20) unsigned NOT NULL,
  `quantite` int(11) NOT NULL,
  `unite` varchar(255) NOT NULL,
  `date` date NOT NULL DEFAULT '2023-12-31',
  `localisation` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `inventaires_produit_id_foreign` (`produit_id`),
  CONSTRAINT `inventaires_produit_id_foreign` FOREIGN KEY (`produit_id`) REFERENCES `produits` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=299 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inventaires`
--

INSERT INTO `inventaires` VALUES
(5,83,5,'Pièce','2023-12-31','Bureau Nathalie','2024-01-02 10:51:25','2024-01-02 10:51:25'),
(6,82,11,'Pièce','2023-12-31','Bureau Nathalie','2024-01-02 10:56:18','2024-01-02 10:56:18'),
(7,196,9,'Pièce','2023-12-31','Bureau Nathalie','2024-01-02 14:27:15','2024-01-02 20:48:07'),
(8,197,1,'Pièce','2023-12-31','Bureau Nathalie','2024-01-02 14:30:00','2024-01-02 14:30:00'),
(9,198,3,'Pièce','2023-12-31','Bureau Nathalie','2024-01-02 14:31:51','2024-01-02 14:31:51'),
(11,199,3,'Pièce','2023-12-31','Bureau Nathalie','2024-01-02 14:43:15','2024-01-02 14:43:15'),
(12,200,50,'Pièce','2023-12-31',NULL,'2024-01-02 15:33:52','2024-01-02 20:49:28'),
(13,201,20,'Pièce','2023-12-31',NULL,'2024-01-02 15:34:15','2024-01-02 15:34:15'),
(14,202,2,'Pièce','2023-12-31','Bureau Nathalie','2024-01-02 15:40:35','2024-01-02 15:40:35'),
(15,203,1,'Pièce','2023-12-31','Bureau Nathalie','2024-01-02 15:52:21','2024-01-02 15:52:21'),
(16,204,6,'Pièce','2023-12-31','Bureau Nathalie','2024-01-02 15:55:16','2024-01-02 15:55:16'),
(17,205,4,'Pièce','2023-12-31','Bureau Nathalie','2024-01-02 16:14:54','2024-01-02 16:14:54'),
(18,206,5,'Pièce','2023-12-31','Bureau Nathalie','2024-01-02 16:17:30','2024-01-02 16:17:30'),
(19,207,1,'Pièce','2023-12-31',NULL,'2024-01-04 10:24:56','2024-01-04 10:24:56'),
(20,208,2,'Pièce','2023-12-31',NULL,'2024-01-04 10:26:47','2024-01-04 10:26:47'),
(21,209,2,'Pièce','2023-12-31',NULL,'2024-01-04 10:29:37','2024-01-04 10:29:37'),
(22,210,1,'Pièce','2023-12-31',NULL,'2024-01-04 10:31:11','2024-01-04 10:31:11'),
(23,211,4,'Pièce','2023-12-31',NULL,'2024-01-04 10:37:48','2024-01-04 10:37:48'),
(24,212,4,'Pièce','2023-12-31',NULL,'2024-01-04 10:39:04','2024-01-04 10:39:04'),
(25,213,7,'Pièce','2023-12-31',NULL,'2024-01-04 10:40:17','2024-01-04 10:40:17'),
(26,214,1,'Pièce','2023-12-31',NULL,'2024-01-04 10:43:56','2024-01-04 10:43:56'),
(27,215,1,'Pièce','2023-12-31',NULL,'2024-01-04 10:47:42','2024-01-04 10:47:42'),
(28,216,2,'Pièce','2023-12-31',NULL,'2024-01-04 13:22:42','2024-01-04 13:22:42'),
(29,217,2,'Pièce','2023-12-31',NULL,'2024-01-04 13:25:07','2024-01-04 13:25:07'),
(30,218,2,'Pièce','2023-12-31',NULL,'2024-01-04 13:27:49','2024-01-04 13:27:49'),
(31,219,2,'Pièce','2023-12-31',NULL,'2024-01-04 14:41:19','2024-01-04 14:41:19'),
(32,220,2,'Pièce','2023-12-31',NULL,'2024-01-04 14:45:39','2024-01-04 14:45:39'),
(33,221,2,'Pièce','2023-12-31',NULL,'2024-01-04 15:07:30','2024-01-04 15:07:30'),
(34,222,8,'Pièce','2023-12-31',NULL,'2024-01-04 15:09:29','2024-01-04 15:09:29'),
(35,223,3,'Pièce','2023-12-31',NULL,'2024-01-04 15:19:20','2024-01-04 15:19:20'),
(36,224,1,'Pièce','2023-12-31',NULL,'2024-01-04 15:22:11','2024-01-04 15:22:11'),
(37,225,8,'Pièce','2023-12-31',NULL,'2024-01-04 15:37:22','2024-01-04 15:37:22'),
(38,2,113,'Pièce','2023-12-31','Villefranche','2024-01-04 15:39:24','2024-01-04 15:39:24'),
(39,171,13,'Pièce','2023-12-31','Villefranche','2024-01-04 15:41:24','2024-02-14 09:08:59'),
(40,226,7,'Pièce','2023-12-31',NULL,'2024-01-04 15:42:04','2024-01-04 15:42:04'),
(41,228,21,'Pièce','2023-12-31',NULL,'2024-01-04 15:50:17','2024-01-04 15:50:17'),
(42,229,32,'Pièce','2023-12-31',NULL,'2024-01-04 15:53:20','2024-01-04 15:53:20'),
(43,230,1841,'Pièce','2023-12-31',NULL,'2024-01-04 15:56:49','2024-01-04 15:56:49'),
(45,231,268,'Pièce','2023-12-31','Villefranche','2024-01-04 16:14:01','2024-02-26 16:25:40'),
(50,238,11,'Pièce','2023-12-31','Villefranche','2024-01-19 15:29:07','2024-01-19 15:29:07'),
(51,247,10,'ml','2023-12-31',NULL,'2024-02-01 15:43:53','2024-02-01 15:43:53'),
(52,27,55,'ml','2023-12-31','Briolance','2024-02-01 16:00:58','2024-02-01 16:17:34'),
(53,28,90,'ml','2023-12-31','Briolance','2024-02-01 16:03:52','2024-02-28 08:31:08'),
(54,26,178,'ml','2023-12-31','Briolance','2024-02-01 16:04:56','2024-02-26 15:01:25'),
(55,248,15,'ml','2023-12-31',NULL,'2024-02-01 16:12:31','2024-02-01 16:16:03'),
(56,249,1500,'ml','2023-12-31','Briolance','2024-02-01 16:14:14','2024-02-16 09:28:36'),
(57,250,213,'Pièce','2023-12-31','Villefranche','2024-02-02 10:40:33','2024-02-02 10:41:58'),
(58,251,759,'Pièce','2023-12-31','Villefranche','2024-02-02 10:46:37','2024-02-02 10:54:22'),
(59,252,107,'Pièce','2023-12-31','Villefranche','2024-02-02 10:48:30','2024-02-14 14:02:36'),
(60,253,362,'Pièce','2023-12-31','Villefranche','2024-02-02 10:51:24','2024-02-02 10:59:31'),
(61,254,100,'Pièce','2023-12-31','Villefranche','2024-02-02 10:55:49','2024-02-02 10:58:07'),
(62,255,84,'Pièce','2023-12-31',NULL,'2024-02-02 11:01:59','2024-02-02 11:01:59'),
(63,256,270,'ml','2023-12-31','Villefranche','2024-02-02 12:36:10','2024-02-02 12:54:51'),
(64,257,240,'ml','2023-12-31','Villefranche','2024-02-02 12:40:16','2024-02-02 12:42:31'),
(65,258,440,'ml','2023-12-31',NULL,'2024-02-02 12:57:32','2024-02-02 12:57:32'),
(66,259,5,'Pièce','2023-12-31',NULL,'2024-02-14 09:04:24','2024-02-14 09:04:24'),
(67,157,34,'Pièce','2023-12-31','Villefranche','2024-02-14 09:13:55','2024-02-14 09:13:55'),
(68,260,174,'m2','2023-12-31','Villefranche','2024-02-14 09:40:26','2024-02-14 09:57:35'),
(69,261,19,'m2','2023-12-31','Villefranche','2024-02-14 09:44:01','2024-02-14 09:53:38'),
(70,262,31,'m2','2023-12-31',NULL,'2024-02-14 09:45:46','2024-02-14 09:45:46'),
(71,263,10,'m2','2023-12-31',NULL,'2024-02-14 09:47:28','2024-02-14 09:47:28'),
(72,264,19,'m2','2023-12-31',NULL,'2024-02-14 09:49:33','2024-02-14 09:49:33'),
(73,265,60,'m2','2023-12-31',NULL,'2024-02-14 09:56:53','2024-02-14 09:56:53'),
(74,266,13,'m3','2023-12-31',NULL,'2024-02-14 10:09:43','2024-03-01 08:28:57'),
(75,267,6,'Pièce','2023-12-31',NULL,'2024-02-14 10:14:23','2024-02-14 10:14:23'),
(76,128,38,'Pièce','2023-12-31','Villefranche','2024-02-14 10:20:05','2024-02-14 10:20:05'),
(77,268,26,'Pièce','2023-12-31','Villefranche','2024-02-14 10:25:46','2024-02-26 10:22:52'),
(78,269,80,'ml','2023-12-31','Villefranche','2024-02-14 10:43:20','2024-02-14 10:45:35'),
(79,270,20,'ml','2023-12-31','Villefranche','2024-02-14 10:48:15','2024-03-01 13:24:13'),
(80,271,0,'ml','2023-12-31','Villefranche','2024-02-14 10:52:05','2024-02-28 08:46:34'),
(81,272,125,'ml','2023-12-31','Villefranche','2024-02-14 10:57:57','2024-02-26 10:41:06'),
(82,273,0,'ml','2023-12-31','Villefranche','2024-02-14 12:45:03','2024-03-01 13:27:11'),
(83,274,70,'ml','2023-12-31','Villefranche','2024-02-14 12:47:40','2024-03-01 13:27:41'),
(84,275,60,'ml','2023-12-31','Villefranche','2024-02-14 12:52:09','2024-02-28 08:41:50'),
(85,276,20,'ml','2023-12-31','Villefranche','2024-02-14 12:53:56','2024-03-01 13:28:24'),
(86,277,0,'ml','2023-12-31','Villefranche','2024-02-14 12:58:21','2024-03-01 13:27:59'),
(87,278,125,'ml','2023-12-31','Villefranche','2024-02-14 13:04:25','2024-03-01 13:31:12'),
(88,279,150,'Pièce','2023-12-31',NULL,'2024-02-14 13:11:04','2024-02-14 13:11:04'),
(89,280,125,'Pièce','2023-12-31','Villefranche','2024-02-14 13:14:22','2024-02-14 14:05:23'),
(90,281,41,'Pièce','2023-12-31',NULL,'2024-02-14 13:24:40','2024-02-14 13:24:40'),
(91,282,38,'Pièce','2023-12-31',NULL,'2024-02-14 13:56:03','2024-02-14 13:56:03'),
(92,283,65,'Pièce','2023-12-31',NULL,'2024-02-14 13:58:26','2024-02-14 13:58:26'),
(93,284,44,'Pièce','2023-12-31',NULL,'2024-02-14 14:00:34','2024-02-14 14:00:34'),
(94,285,28,'Pièce','2023-12-31',NULL,'2024-02-14 14:08:48','2024-02-14 14:08:48'),
(95,286,137,'Pièce','2023-12-31',NULL,'2024-02-14 14:11:00','2024-02-14 14:11:00'),
(96,287,26,'Pièce','2023-12-31',NULL,'2024-02-14 14:22:57','2024-02-14 14:22:57'),
(97,288,11,'Pièce','2023-12-31','Villefranche','2024-02-14 14:24:40','2024-02-14 14:26:33'),
(98,289,35,'Pièce','2023-12-31',NULL,'2024-02-14 14:29:47','2024-02-14 14:29:47'),
(99,290,10,'Pièce','2023-12-31',NULL,'2024-02-14 14:32:01','2024-02-14 14:32:01'),
(100,87,94,'Pièce','2023-12-31','Villefranche','2024-02-14 14:40:52','2024-02-14 14:40:52'),
(101,291,20,'Pièce','2023-12-31',NULL,'2024-02-14 14:43:32','2024-02-14 14:43:32'),
(102,292,91,'Pièce','2023-12-31',NULL,'2024-02-14 14:50:38','2024-02-14 14:50:38'),
(103,293,252,'Pièce','2023-12-31',NULL,'2024-02-14 14:57:10','2024-02-14 14:57:10'),
(104,294,26,'Pièce','2023-12-31',NULL,'2024-02-14 14:59:34','2024-02-14 14:59:34'),
(105,69,9,'Pièce','2023-12-31','Villefranche','2024-02-14 15:04:06','2024-02-14 15:04:06'),
(106,295,17,'Pièce','2023-12-31',NULL,'2024-02-14 15:05:02','2024-02-14 15:05:02'),
(107,296,22,'Pièce','2023-12-31',NULL,'2024-02-14 15:10:27','2024-02-14 15:10:27'),
(108,297,3,'Pièce','2023-12-31',NULL,'2024-02-14 15:13:24','2024-02-14 15:13:24'),
(109,298,2,'m3','2023-12-31','Briolance','2024-02-14 15:19:25','2024-02-26 13:35:02'),
(110,163,496,'Pièce','2023-12-31','Briolance','2024-02-15 14:26:14','2024-02-15 14:26:14'),
(111,319,5000,'ml','2023-12-31','Briolance','2024-02-15 15:08:40','2024-02-15 15:08:40'),
(112,320,2,'m2','2023-12-31',NULL,'2024-02-15 15:25:21','2024-02-15 15:25:21'),
(113,323,48,'Pièce','2023-12-31','Briolance','2024-02-16 08:54:07','2024-02-16 08:54:07'),
(114,324,24,'Pièce','2023-12-31',NULL,'2024-02-16 08:55:43','2024-02-16 08:55:43'),
(115,325,146,'m2','2023-12-31',NULL,'2024-02-16 09:03:23','2024-02-16 09:03:23'),
(116,330,70,'Pièce','2023-12-31',NULL,'2024-02-16 10:47:59','2024-02-16 10:47:59'),
(117,1,15,'m3','2023-12-31','Briolance','2024-02-16 10:53:37','2024-02-26 15:10:16'),
(118,331,3,'m3','2023-12-31',NULL,'2024-02-16 10:54:34','2024-02-16 10:54:34'),
(119,332,8,'m3','2023-12-31',NULL,'2024-02-16 10:56:43','2024-02-16 10:56:43'),
(120,333,8,'m3','2023-12-31','Briolance','2024-02-16 10:58:16','2024-02-26 15:40:30'),
(121,334,5,'m3','2023-12-31',NULL,'2024-02-16 11:01:39','2024-02-16 11:01:39'),
(122,346,300,'m2','2023-12-31','Villefranche','2024-02-26 08:50:27','2024-02-26 10:41:44'),
(123,347,90,'m2','2023-12-31','Villefranche','2024-02-26 08:51:49','2024-02-26 08:52:36'),
(124,348,231,'m2','2023-12-31','Villefranche','2024-02-26 08:55:51','2024-02-26 10:43:33'),
(125,349,40,'m2','2023-12-31','Villefranche','2024-02-26 08:57:49','2024-02-26 10:43:43'),
(126,350,115,'m2','2023-12-31','Villefranche','2024-02-26 09:01:53','2024-02-26 10:44:10'),
(127,351,20,'m2','2023-12-31','Villefranche','2024-02-26 09:07:56','2024-02-26 10:45:04'),
(128,352,16,'m2','2023-12-31',NULL,'2024-02-26 09:11:04','2024-02-26 09:11:04'),
(129,353,5,'m2','2023-12-31','Villefranche','2024-02-26 09:14:51','2024-02-26 10:45:13'),
(130,354,35,'Pièce','2023-12-31','Villefranche','2024-02-26 09:19:06','2024-02-26 13:09:45'),
(131,355,29,'Pièce','2023-12-31','Villefranche','2024-02-26 09:20:42','2024-02-26 10:45:23'),
(132,356,5,'m2','2023-12-31','Villefranche','2024-02-26 09:23:42','2024-02-26 10:49:43'),
(133,357,20,'m2','2023-12-31',NULL,'2024-02-26 09:26:02','2024-02-26 09:26:02'),
(134,358,1000,'ml','2023-12-31',NULL,'2024-02-26 09:29:48','2024-02-26 09:29:48'),
(135,359,1,'ml','2023-12-31',NULL,'2024-02-26 09:33:35','2024-02-26 09:33:35'),
(136,360,550,'ml','2023-12-31',NULL,'2024-02-26 09:36:09','2024-02-26 09:36:09'),
(137,361,20,'ml','2023-12-31',NULL,'2024-02-26 09:39:35','2024-02-26 09:39:35'),
(138,362,26,'m2','2023-12-31',NULL,'2024-02-26 09:48:21','2024-02-26 09:48:21'),
(139,363,12,'m2','2023-12-31',NULL,'2024-02-26 09:52:47','2024-02-26 09:52:47'),
(140,364,93,'m2','2023-12-31',NULL,'2024-02-26 09:56:48','2024-02-26 09:56:48'),
(141,365,1,'m2','2023-12-31',NULL,'2024-02-26 09:58:21','2024-02-26 09:58:21'),
(142,366,2,'m2','2023-12-31',NULL,'2024-02-26 09:59:42','2024-02-26 09:59:42'),
(143,367,39,'m2','2023-12-31',NULL,'2024-02-26 10:00:50','2024-02-26 10:00:50'),
(145,369,26,'m2','2023-12-31',NULL,'2024-02-26 10:04:21','2024-02-26 10:04:21'),
(146,370,1120,'m2','2023-12-31',NULL,'2024-02-26 10:07:05','2024-02-26 10:07:05'),
(147,371,15,'m2','2023-12-31',NULL,'2024-02-26 10:09:09','2024-02-26 10:09:09'),
(148,372,30,'m2','2023-12-31',NULL,'2024-02-26 10:10:02','2024-02-26 10:10:02'),
(149,373,40,'m2','2023-12-31',NULL,'2024-02-26 10:10:55','2024-02-26 10:10:55'),
(150,374,900,'m2','2023-12-31',NULL,'2024-02-26 10:12:01','2024-02-26 10:12:01'),
(151,375,22,'m2','2023-12-31',NULL,'2024-02-26 10:13:59','2024-02-26 10:13:59'),
(152,376,30,'Pièce','2023-12-31','Villefranche','2024-02-26 10:16:26','2024-03-01 13:36:52'),
(153,377,4,'Pièce','2023-12-31','Villefranche','2024-02-26 10:20:31','2024-02-26 13:20:04'),
(154,378,581,'m3','2023-12-31',NULL,'2024-02-26 12:46:12','2024-02-26 12:46:12'),
(155,244,1,'m3','2023-12-31','Briolance','2024-02-26 13:36:32','2024-02-26 13:36:32'),
(156,299,47,'m3','2023-12-31','Briolance','2024-02-26 13:38:03','2024-02-26 14:41:59'),
(157,300,67,'m3','2023-12-31','Briolance','2024-02-26 13:38:37','2024-02-26 14:39:08'),
(158,301,1,'m3','2023-12-31','Villefranche','2024-02-26 13:39:06','2024-02-26 13:39:06'),
(159,173,228,'m3','2023-12-31','Briolance','2024-02-26 13:40:10','2024-02-26 15:05:45'),
(160,180,177,'m3','2023-12-31','Briolance','2024-02-26 13:41:33','2024-02-26 15:25:09'),
(161,302,1,'m3','2023-12-31','Briolance','2024-02-26 13:41:59','2024-02-26 13:41:59'),
(162,303,1,'m3','2023-12-31','Briolance','2024-02-26 13:42:46','2024-02-26 13:42:46'),
(163,304,1,'m3','2023-12-31','Briolance','2024-02-26 13:43:34','2024-02-26 13:43:34'),
(164,305,1,'m3','2023-12-31','Briolance','2024-02-26 13:44:35','2024-02-26 13:44:35'),
(165,307,1,'m3','2023-12-31','Briolance','2024-02-26 13:46:02','2024-02-26 13:46:02'),
(166,306,1,'m3','2023-12-31','Briolance','2024-02-26 13:46:27','2024-02-26 13:46:27'),
(167,309,1,'m3','2023-12-31','Briolance','2024-02-26 13:50:28','2024-02-26 13:50:28'),
(168,310,1,'m3','2023-12-31','Briolance','2024-02-26 13:52:09','2024-02-26 13:52:09'),
(169,308,1,'m3','2023-12-31','Briolance','2024-02-26 14:00:45','2024-02-26 14:00:45'),
(170,311,16,'m3','2023-12-31','Briolance','2024-02-26 14:02:19','2024-02-26 14:02:19'),
(171,379,11,'m3','2023-12-31',NULL,'2024-02-26 14:04:01','2024-02-26 14:04:01'),
(172,312,2,'m3','2023-12-31','Briolance','2024-02-26 14:06:19','2024-02-26 14:06:19'),
(173,313,9,'m3','2023-12-31','Briolance','2024-02-26 14:06:56','2024-02-26 14:06:56'),
(174,314,3,'m3','2023-12-31','Briolance','2024-02-26 14:12:09','2024-02-26 14:12:09'),
(175,315,1,'m3','2023-12-31','Briolance','2024-02-26 14:12:44','2024-02-26 14:13:14'),
(176,316,10,'m3','2023-12-31','Briolance','2024-02-26 14:13:40','2024-02-26 14:13:40'),
(177,335,1,'m3','2023-12-31','Briolance','2024-02-26 14:17:24','2024-02-26 14:17:24'),
(178,336,1,'m3','2023-12-31','Briolance','2024-02-26 14:17:49','2024-02-26 14:17:49'),
(179,337,7,'m3','2023-12-31','Briolance','2024-02-26 14:18:13','2024-02-26 14:18:13'),
(180,338,115,'Palette','2023-12-31','Briolance','2024-02-26 14:24:44','2024-02-26 14:24:44'),
(181,339,138,'Palette','2023-12-31','Briolance','2024-02-26 14:25:19','2024-02-26 14:25:19'),
(182,340,325,'Palette','2023-12-31','Briolance','2024-02-26 14:25:59','2024-02-26 14:27:06'),
(183,341,229,'Palette','2023-12-31','Briolance','2024-02-26 14:27:48','2024-02-26 14:33:02'),
(184,380,26,'m3','2023-12-31',NULL,'2024-02-26 14:31:16','2024-02-26 14:31:16'),
(185,342,1,'m3','2023-12-31','Briolance','2024-02-26 14:33:43','2024-02-26 14:33:43'),
(186,343,23,'m3','2023-12-31','Briolance','2024-02-26 14:34:15','2024-02-26 14:34:15'),
(187,344,8,'m3','2023-12-31','Briolance','2024-02-26 14:34:50','2024-02-26 14:34:50'),
(188,345,6,'m3','2023-12-31','Briolance','2024-02-26 14:35:27','2024-02-26 14:35:27'),
(189,321,702,'m3','2023-12-31','Briolance','2024-02-26 14:36:20','2024-02-26 14:36:20'),
(190,322,2,'m3','2023-12-31','Briolance','2024-02-26 14:37:18','2024-02-26 14:37:18'),
(191,327,1,'m3','2023-12-31','Briolance','2024-02-26 14:39:41','2024-02-26 14:39:41'),
(192,328,62,'m3','2023-12-31','Briolance','2024-02-26 14:40:58','2024-02-26 14:40:58'),
(193,329,176,'m3','2023-12-31','Briolance','2024-02-26 14:42:33','2024-02-26 14:42:33'),
(194,166,3692,'Pièce','2023-12-31','Briolance','2024-02-26 14:58:14','2024-02-26 14:58:14'),
(195,24,297,'ml','2023-12-31','Briolance','2024-02-26 15:03:21','2024-02-26 15:03:21'),
(196,164,52,'m3','2023-12-31','Briolance','2024-02-26 15:04:14','2024-02-26 15:04:14'),
(197,174,544,'m2','2023-12-31','Briolance','2024-02-26 15:04:44','2024-02-26 15:04:44'),
(198,161,12,'m2','2023-12-31','Briolance','2024-02-26 15:07:02','2024-02-26 15:07:02'),
(199,160,2,'m3','2023-12-31','Briolance','2024-02-26 15:07:30','2024-02-26 15:07:30'),
(200,159,594,'m3','2023-12-31','Briolance','2024-02-26 15:08:37','2024-02-26 15:08:37'),
(201,158,7,'m3','2023-12-31','Briolance','2024-02-26 15:12:00','2024-02-26 15:12:00'),
(202,168,3,'m3','2023-12-31','Briolance','2024-02-26 15:16:27','2024-02-26 15:16:27'),
(203,8,3,'m3','2023-12-31','Briolance','2024-02-26 15:17:09','2024-02-26 15:17:09'),
(204,178,18,'m3','2023-12-31','Briolance','2024-02-26 15:17:30','2024-02-26 15:17:30'),
(205,169,6,'m3','2023-12-31','Briolance','2024-02-26 15:18:00','2024-02-26 15:18:00'),
(206,170,5,'m3','2023-12-31','Briolance','2024-02-26 15:18:34','2024-02-26 15:18:34'),
(207,381,321,'Pièce','2023-12-31',NULL,'2024-02-26 15:20:47','2024-02-26 15:20:47'),
(208,172,88,'m2','2023-12-31','Briolance','2024-02-26 15:21:27','2024-02-26 15:21:27'),
(209,181,72,'m2','2023-12-31','Briolance','2024-02-26 15:25:48','2024-02-26 15:25:48'),
(210,183,429,'m2','2023-12-31','Briolance','2024-02-26 15:26:29','2024-02-26 15:26:29'),
(211,382,2,'m3','2023-12-31',NULL,'2024-02-26 15:29:44','2024-02-26 15:29:44'),
(212,383,15,'m3','2023-12-31',NULL,'2024-02-26 15:36:21','2024-02-26 15:36:21'),
(213,384,55,'ml','2023-12-31',NULL,'2024-02-26 15:48:57','2024-02-26 15:48:57'),
(214,385,63,'Pièce','2023-12-31',NULL,'2024-02-26 16:26:57','2024-02-26 16:26:57'),
(215,386,138,'Pièce','2023-12-31',NULL,'2024-02-26 16:28:57','2024-02-26 16:28:57'),
(216,387,6,'Pièce','2023-12-31',NULL,'2024-02-26 16:30:56','2024-02-26 16:30:56'),
(217,388,17,'m2','2023-12-31','Villefranche','2024-02-28 07:34:17','2024-02-28 08:19:19'),
(218,389,5,'m2','2023-12-31',NULL,'2024-02-28 07:35:46','2024-02-28 07:35:46'),
(219,390,10,'m2','2023-12-31',NULL,'2024-02-28 07:37:35','2024-02-28 07:37:35'),
(220,391,11,'m2','2023-12-31',NULL,'2024-02-28 07:40:27','2024-02-28 07:40:27'),
(221,392,5,'m2','2023-12-31',NULL,'2024-02-28 07:43:44','2024-02-28 07:43:44'),
(222,393,4,'m2','2023-12-31',NULL,'2024-02-28 07:51:37','2024-02-28 07:51:37'),
(223,394,26,'m2','2023-12-31','Villefranche','2024-02-28 08:00:15','2024-02-28 08:01:01'),
(224,395,15,'m2','2023-12-31',NULL,'2024-02-28 08:02:06','2024-02-28 08:02:06'),
(225,396,4,'m2','2023-12-31',NULL,'2024-02-28 08:03:00','2024-02-28 08:03:00'),
(226,397,3,'m2','2023-12-31',NULL,'2024-02-28 08:07:27','2024-02-28 08:07:27'),
(227,398,5,'m2','2023-12-31',NULL,'2024-02-28 08:09:03','2024-02-28 08:09:03'),
(228,399,12,'m2','2023-12-31',NULL,'2024-02-28 08:10:25','2024-02-28 08:10:25'),
(229,400,10,'m2','2023-12-31',NULL,'2024-02-28 08:11:43','2024-02-28 08:11:43'),
(230,401,13,'m2','2023-12-31',NULL,'2024-02-28 08:12:51','2024-02-28 08:12:51'),
(231,402,50,'m2','2023-12-31',NULL,'2024-02-28 08:13:40','2024-02-28 08:13:40'),
(232,403,19,'m2','2023-12-31',NULL,'2024-02-28 08:16:18','2024-02-28 08:16:18'),
(233,404,21,'m2','2023-12-31',NULL,'2024-02-28 08:17:17','2024-02-28 08:17:17'),
(235,93,6,'m2','2023-12-31','Villefranche','2024-02-28 08:24:53','2024-02-28 08:24:53'),
(236,9,2,'Palette','2023-12-31','Villefranche','2024-02-28 08:25:47','2024-02-28 08:25:47'),
(237,406,63,'Pièce','2023-12-31',NULL,'2024-02-28 09:06:37','2024-02-28 09:06:37'),
(238,407,88,'m2','2023-12-31',NULL,'2024-02-28 09:08:59','2024-02-28 09:08:59'),
(239,408,2,'m2','2023-12-31',NULL,'2024-02-28 09:09:43','2024-02-28 09:09:43'),
(240,409,1,'m2','2023-12-31',NULL,'2024-02-28 09:13:22','2024-02-28 09:13:22'),
(241,410,4,'m2','2023-12-31',NULL,'2024-02-28 09:14:26','2024-02-28 09:14:26'),
(242,411,2,'m2','2023-12-31',NULL,'2024-02-28 09:15:31','2024-02-28 09:15:31'),
(243,412,8,'m2','2023-12-31',NULL,'2024-02-28 09:16:24','2024-02-28 09:16:24'),
(244,23,52,'Pièce','2023-12-31','Briolance','2024-02-28 09:17:00','2024-02-28 09:17:00'),
(245,64,150,'Pièce','2023-12-31','Villefranche','2024-02-28 09:19:15','2024-02-28 09:19:15'),
(246,72,34,'Pièce','2023-12-31','Villefranche','2024-02-28 09:20:41','2024-02-28 09:20:41'),
(247,89,18,'m2','2023-12-31','Villefranche','2024-02-28 09:21:11','2024-02-28 09:21:11'),
(248,90,39,'m2','2023-12-31','Villefranche','2024-02-28 09:22:14','2024-02-28 09:22:14'),
(249,413,104,'m2','2023-12-31',NULL,'2024-02-28 09:26:56','2024-02-28 09:26:56'),
(250,414,10,'m2','2023-12-31',NULL,'2024-02-28 09:28:26','2024-02-28 09:28:26'),
(251,415,19,'m2','2023-12-31',NULL,'2024-02-28 09:31:46','2024-02-28 09:31:46'),
(252,100,348,'Pièce','2023-12-31','Briolance','2024-02-28 09:36:00','2024-02-28 09:36:00'),
(253,416,15,'m2','2023-12-31',NULL,'2024-02-28 09:38:30','2024-02-28 09:38:30'),
(254,109,46,'m2','2023-12-31','Villefranche','2024-02-28 09:39:05','2024-02-28 09:39:05'),
(255,130,779,'Pièce','2023-12-31','Villefranche','2024-02-28 09:40:37','2024-02-28 09:40:37'),
(256,417,168,'Pièce','2023-12-31',NULL,'2024-02-28 09:42:43','2024-02-28 09:42:43'),
(257,418,114,'m2','2023-12-31',NULL,'2024-02-28 09:47:24','2024-02-28 09:47:24'),
(258,419,6,'m2','2023-12-31',NULL,'2024-02-28 09:48:31','2024-02-28 09:48:31'),
(259,420,139,'m2','2023-12-31',NULL,'2024-02-28 09:51:29','2024-02-28 09:51:29'),
(260,421,95,'m2','2023-12-31',NULL,'2024-02-28 09:52:30','2024-02-28 09:52:30'),
(261,422,23,'Pièce','2023-12-31',NULL,'2024-02-28 09:54:03','2024-02-28 09:54:03'),
(262,423,2,'m2','2023-12-31',NULL,'2024-02-28 09:55:34','2024-02-28 09:55:34'),
(263,424,30,'m2','2023-12-31',NULL,'2024-02-28 10:00:19','2024-02-28 10:00:19'),
(264,425,94,'m2','2023-12-31',NULL,'2024-02-28 10:05:06','2024-02-28 10:05:06'),
(265,426,21,'m2','2023-12-31',NULL,'2024-02-28 10:10:59','2024-02-28 10:10:59'),
(266,427,23,'m2','2023-12-31',NULL,'2024-02-28 10:11:44','2024-02-28 10:11:44'),
(267,428,5,'m2','2023-12-31',NULL,'2024-02-28 10:18:44','2024-02-28 10:18:44'),
(268,429,2,'m2','2023-12-31',NULL,'2024-02-28 10:19:47','2024-02-28 10:19:47'),
(269,430,14,'Pièce','2023-12-31',NULL,'2024-02-28 10:21:36','2024-02-28 10:21:36'),
(270,431,29,'Pièce','2023-12-31',NULL,'2024-02-28 10:23:24','2024-02-28 10:23:24'),
(271,432,30,'m2','2023-12-31',NULL,'2024-02-28 10:25:12','2024-02-28 10:25:12'),
(272,32,46,'m2','2023-12-31','Villefranche','2024-02-28 10:28:09','2024-02-28 10:28:09'),
(273,141,53,'m2','2023-12-31','Villefranche','2024-02-28 10:36:30','2024-02-28 10:36:30'),
(274,47,302,'m2','2023-12-31','Villefranche','2024-02-28 10:37:20','2024-02-28 10:37:20'),
(275,53,73,'m2','2023-12-31','Villefranche','2024-02-28 10:42:30','2024-02-28 10:42:30'),
(276,55,59,'m2','2023-12-31','Villefranche','2024-02-28 10:43:02','2024-02-28 10:43:02'),
(277,57,70,'m2','2023-12-31','Villefranche','2024-02-28 10:43:20','2024-02-28 10:43:20'),
(278,13,1437,'ml','2023-12-31','Villefranche','2024-02-28 10:44:14','2024-02-28 10:44:14'),
(279,4,2074,'ml','2023-12-31','Villefranche','2024-02-28 10:45:07','2024-02-28 10:45:07'),
(280,193,20,'m2','2023-12-31','Villefranche','2024-02-28 10:45:30','2024-02-28 10:45:30'),
(281,433,237,'Pile','2023-12-31','Briolance','2024-02-28 10:54:05','2024-03-01 08:24:12'),
(282,434,238,'Pile','2023-12-31','Briolance','2024-02-28 10:55:59','2024-03-01 08:24:27'),
(283,435,64,'m2','2023-12-31',NULL,'2024-02-28 10:57:45','2024-02-28 10:57:45'),
(284,436,21,'Pièce','2023-12-31',NULL,'2024-02-28 11:01:50','2024-02-28 11:01:50'),
(285,437,2,'Palette','2023-12-31',NULL,'2024-02-28 12:35:02','2024-02-28 12:35:02'),
(286,438,0,'m2','2023-12-31',NULL,'2024-02-28 14:58:21','2024-02-28 14:58:21'),
(287,439,90,'m2','2023-12-31',NULL,'2024-02-28 15:49:47','2024-02-28 15:49:47'),
(288,440,300,'m2','2023-12-31',NULL,'2024-02-28 16:19:20','2024-02-28 16:19:20'),
(289,441,3,'Palette','2023-12-31',NULL,'2024-02-28 16:30:56','2024-02-28 16:30:56'),
(290,240,0,'m2','2023-12-31',NULL,'2024-02-28 23:40:58','2024-02-28 23:40:58'),
(291,519,0,'m2','2023-12-31',NULL,'2024-03-07 10:07:15','2024-03-07 10:07:15'),
(292,524,0,'m2','2023-12-31',NULL,'2024-03-07 10:07:57','2024-03-07 10:07:57'),
(293,523,0,'m2','2023-12-31',NULL,'2024-03-07 10:08:09','2024-03-07 10:08:09'),
(294,522,0,'m2','2023-12-31',NULL,'2024-03-07 10:08:20','2024-03-07 10:08:20'),
(295,517,0,'m2','2023-12-31',NULL,'2024-03-07 10:08:36','2024-03-07 10:08:36'),
(296,518,0,'m2','2023-12-31',NULL,'2024-03-07 10:08:56','2024-03-07 10:08:56'),
(297,525,0,'m2','2023-12-31',NULL,'2024-03-07 10:09:07','2024-03-07 10:09:07'),
(298,497,0,'m2','2023-12-31',NULL,'2024-03-07 10:28:20','2024-03-07 10:28:20');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=679 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES
(667,'2014_10_12_000000_create_users_table',1),
(668,'2014_10_12_100000_create_password_reset_tokens_table',1),
(669,'2019_08_19_000000_create_failed_jobs_table',1),
(670,'2019_12_14_000001_create_personal_access_tokens_table',1),
(671,'2023_12_07_220152_create_produits_table',1),
(672,'2023_12_29_211437_create_essences_table',1),
(673,'2023_12_29_215738_create_clients_table',1),
(674,'2023_12_29_215914_create_commandes_table',1),
(675,'2023_12_29_220915_create_inventaires_table',1),
(676,'2023_12_31_161456_create_colis_table',1),
(677,'2023_12_31_164456_create_stocks_table',1),
(678,'2024_01_02_212040_create_tarifs_table',2);

--
-- Table structure for table `produits`
--

CREATE TABLE `produits` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `referenceA` varchar(255) NOT NULL,
  `referenceB` varchar(255) DEFAULT NULL,
  `site` varchar(255) NOT NULL,
  `famille` varchar(255) NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `essence` varchar(255) DEFAULT NULL,
  `qualite` varchar(255) DEFAULT NULL,
  `unite` varchar(255) DEFAULT NULL,
  `epaisseur` int(11) NOT NULL DEFAULT 0,
  `largeur` int(11) NOT NULL DEFAULT 0,
  `longueur` int(11) NOT NULL DEFAULT 0,
  `humidite` int(11) NOT NULL DEFAULT 0,
  `origine` varchar(255) NOT NULL DEFAULT 'Interne',
  `alternatif` varchar(255) DEFAULT NULL,
  `analytiqueA` varchar(255) DEFAULT NULL,
  `analytiqueB` varchar(255) DEFAULT NULL,
  `analytiqueC` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `produits_referencea_unique` (`referenceA`)
) ENGINE=InnoDB AUTO_INCREMENT=574 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `produits`
--

INSERT INTO `produits` VALUES
(1,'BCHATAVIV27/TL/2',NULL,'Briolance','Avivé',NULL,'Châtaignier','Vert','m3',27,0,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-01-02 08:47:35','2024-03-04 15:22:25'),
(2,'TRAV2600',NULL,'Loubejac','Traverse','Non Traité','Chêne','Paysagère',NULL,100,200,2600,12,'Negoce',NULL,NULL,NULL,NULL,'2024-01-02 08:47:35','2024-01-02 08:47:35'),
(3,'ACCPL11RUS',NULL,'Loubejac','Plinthe',NULL,'Châtaignier','Rustique poncée','m2',15,110,0,12,'Production',NULL,'ACC',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 12:49:17'),
(4,'ACCPL7RUS',NULL,'Loubejac','Plinthe',NULL,'Châtaignier','Rustique poncée','m2',15,70,2000,12,'Production',NULL,'ACC',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 12:49:25'),
(5,'GANIVS120/45',NULL,'Briolance','Ganivelle','Sciée','Châtaignier',NULL,'ml',45,120,5000,12,'Production',NULL,NULL,NULL,NULL,'2024-01-02 08:47:35','2024-02-29 07:52:35'),
(6,'GANIV120S78',NULL,'Briolance','Ganivelle','Sciée','Châtaignier',NULL,'ml',78,1200,5000,12,'Production',NULL,NULL,NULL,NULL,'2024-01-02 08:47:35','2024-03-01 10:09:55'),
(8,'BCHATPLO27',NULL,'Loubejac','Plot',NULL,'Châtaignier','cs1 /cs2','m2',27,0,2500,0,'Production',NULL,NULL,NULL,NULL,'2024-01-02 08:47:35','2024-03-01 09:56:18'),
(9,'SCILAMBO',NULL,'Loubejac','Lambourde',NULL,'Châtaignier',NULL,'Pièce',25,60,0,12,'Production',NULL,'ACC',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 09:15:48'),
(10,'SCILAM38',NULL,'Loubejac','Lambourde',NULL,'Châtaignier',NULL,'Pièce',38,55,0,12,'Production',NULL,'ACC',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 11:00:06'),
(11,'LBR14/90AB',NULL,'Loubejac','Lambris',NULL,'Châtaignier','AB Poncé','m2',14,90,0,12,'Production',NULL,'ACC',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 09:37:44'),
(12,'ACCPL7VN',NULL,'Loubejac','Plinthe',NULL,'Châtaignier','Vernis Naturel','ml',14,70,0,12,'Production',NULL,'ACC',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 08:52:52'),
(13,'ACCPL9VN',NULL,'Loubejac','Plinthe',NULL,'Châtaignier','Vernis Naturel','ml',14,95,0,12,'Production',NULL,'ACC',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 09:55:27'),
(14,'ACCPL9RUS',NULL,'Loubejac','Plinthe',NULL,'Châtaignier','Brut Poncée Rustique','ml',15,95,0,12,'Production',NULL,'ACC',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 09:55:14'),
(15,'ACCPL11',NULL,'Loubejac','Plinthe',NULL,'Châtaignier','Brut Poncée','ml',15,110,0,12,'Production',NULL,'ACC',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 09:53:05'),
(16,'ACCPL7',NULL,'Loubejac','Plinthe',NULL,'Châtaignier','Brut Poncée','ml',15,70,0,12,'Production',NULL,'ACC',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 09:51:35'),
(17,'ACCPL9',NULL,'Loubejac','Plinthe',NULL,'Châtaignier','Brut Poncée','ml',15,95,0,12,'Production',NULL,'ACC',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 09:55:01'),
(18,'ACCPLPEUP',NULL,'Loubejac','Plinthe',NULL,'Peuplier',NULL,'ml',15,130,0,12,'Production',NULL,'ACC',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 09:55:42'),
(19,'BBRONDINS',NULL,'Loubejac','Rondin',NULL,'Châtaignier',NULL,'m2',0,0,0,0,'Production',NULL,'BB',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 09:01:49'),
(20,'BBROND2MPAP',NULL,'Loubejac','Rondin',NULL,'Châtaignier',NULL,'m2',0,0,2000,0,'Production',NULL,'BB',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 09:01:13'),
(21,'BSCIURE',NULL,'Loubejac','Sciure',NULL,'--N/A--',NULL,'Kilo',0,0,0,0,'Production',NULL,'BFAG',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 09:22:52'),
(22,'BFAGEXO',NULL,'Loubejac','Croute',NULL,'Châtaignier','Delignure brute','m2',0,0,0,0,'Production',NULL,'BFAG',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 09:15:44'),
(23,'BFAGST',NULL,'Loubejac','Fagot',NULL,'Châtaignier',NULL,'m2',0,0,0,0,'Production',NULL,'BFAG',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 09:16:07'),
(24,'BGANS1/4.5',NULL,'Briolance','Ganivelle','Sciée','Châtaignier',NULL,'ml',45,1000,5000,12,'Production',NULL,'BSCIAGAN',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 09:59:51'),
(25,'BGANS1/7.8',NULL,'Briolance','Ganivelle','Sciée','Châtaignier',NULL,'ml',78,1000,5000,12,'Production',NULL,'BSCIAGAN',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 10:00:01'),
(26,'BGANS120/4.5',NULL,'Briolance','Ganivelle','Sciée','Châtaignier',NULL,'ml',45,1200,5000,12,'Production',NULL,'BSCIAGAN',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 10:00:32'),
(27,'BGAN120/7.8',NULL,'Briolance','Ganivelle','Sciée','Châtaignier',NULL,'ml',78,1200,5000,12,'Production',NULL,'BSCIAGAN',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 07:35:57'),
(28,'BGANS150/4.5',NULL,'Briolance','Ganivelle','Sciée','Châtaignier',NULL,'ml',45,1500,5000,12,'Production',NULL,'BSCIAGAN',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 10:00:56'),
(29,'BGANS150/7.8',NULL,'Briolance','Ganivelle','Sciée','Châtaignier',NULL,'ml',78,1500,5000,12,'Production',NULL,'BSCIAGAN',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 10:01:38'),
(30,'LBR14/90RUS',NULL,'Loubejac','Lambris',NULL,'Châtaignier','Rustique poncé','m2',14,90,0,12,'Production',NULL,'LBR',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 10:32:15'),
(31,'LCONF70',NULL,'Loubejac','Lambris',NULL,'Châtaignier','Confort','m2',10,70,0,12,'Production',NULL,'LBR',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 10:33:01'),
(32,'LAMBPEUP150',NULL,'Loubejac','Lambris',NULL,'Peuplier','Brut ABC','m2',16,150,2000,12,'Production',NULL,'LBR',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 10:14:31'),
(33,'LAMESTERRASSE2',NULL,'Loubejac','Lame terrasse',NULL,'Châtaignier',NULL,'m2',0,0,0,0,'Production',NULL,'PAN',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 09:37:08'),
(34,'PANCDEC',NULL,'Loubejac','Parquet','A clouer','Châtaignier','Déclassé','m2',23,0,0,12,'Production',NULL,'PAN',NULL,NULL,'2024-01-02 08:47:35','2024-03-06 15:16:57'),
(35,'PANC10RUS',NULL,'Loubejac','Parquet','A clouer','Châtaignier','Rustique','m2',23,100,0,12,'Production',NULL,'PAN',NULL,'P4','2024-01-02 08:47:35','2024-03-07 10:31:10'),
(36,'PANC10SEL',NULL,'Loubejac','Parquet','A clouer','Châtaignier','AB','m2',23,100,0,12,'Production',NULL,'PAN',NULL,'P4','2024-01-02 08:47:35','2024-03-07 10:30:24'),
(37,'PANC12RUS',NULL,'Loubejac','Parquet','A clouer','Châtaignier','Rustique','m2',23,120,0,12,'Production',NULL,'PAN',NULL,'P4','2024-01-02 08:47:35','2024-03-07 10:31:21'),
(38,'PANC12SEL',NULL,'Loubejac','Parquet','A clouer','Châtaignier','AB','m2',23,120,0,12,'Production',NULL,'PAN',NULL,'P4','2024-01-02 08:47:35','2024-03-07 10:30:37'),
(39,'PANC14RUS',NULL,'Loubejac','Parquet','A clouer','Châtaignier','Rustique','m2',23,140,0,12,'Production',NULL,'PAN',NULL,'P4','2024-01-02 08:47:35','2024-03-07 10:31:32'),
(40,'PANC14SEL',NULL,'Loubejac','Parquet','A clouer','Châtaignier','AB','m2',23,140,0,12,'Production',NULL,'PAN',NULL,'P4','2024-01-02 08:47:35','2024-03-07 10:30:53'),
(41,'PANCPEUP100AB',NULL,'Loubejac','Parquet',NULL,'Peuplier','AB Lemance','m2',23,100,0,12,'Production',NULL,'PAN',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 10:40:32'),
(42,'PANCPEUP100RUS',NULL,'Loubejac','Parquet',NULL,'Peuplier','Rustique','m2',23,100,0,12,'Production',NULL,'PAN',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 10:40:40'),
(43,'PANCPEUP160AB',NULL,'Loubejac','Parquet','A clouer','Peuplier','AB Lemance','m2',23,160,0,12,'Production',NULL,'PAN',NULL,'P7','2024-01-02 08:47:35','2024-03-07 15:53:12'),
(44,'PANCPEUP160RUS',NULL,'Loubejac','Parquet','A clouer','Peuplier','Rustique Briolance','m2',23,160,0,12,'Production',NULL,'PAN',NULL,'P7','2024-01-02 08:47:35','2024-03-07 15:48:39'),
(45,'PRES100ABDF',NULL,'Loubejac','Parquet','A clouer','Châtaignier','AB - 2 faces','m2',23,100,0,12,'Production',NULL,'PRE',NULL,'P4','2024-01-02 08:47:35','2024-03-07 10:28:41'),
(46,'PRES100ABVERN',NULL,'Loubejac','Parquet','A clouer-GO2','Châtaignier','AB Verni naturel','m2',23,100,0,12,'Production',NULL,'PRE',NULL,NULL,'2024-01-02 08:47:35','2024-03-07 13:14:38'),
(47,'PRES100AB',NULL,'Loubejac','Parquet','A clouer','Châtaignier','AB','m2',23,100,0,12,'Production',NULL,'PRE',NULL,NULL,'2024-01-02 08:47:35','2024-03-07 13:14:50'),
(48,'PRES100RUS',NULL,'Loubejac','Parquet','A clouer','Châtaignier','Rustique - 2 faces','m2',23,100,0,12,'Production',NULL,'PRE',NULL,'P4','2024-01-02 08:47:35','2024-03-07 10:29:10'),
(49,'PRES100DEC',NULL,'Loubejac','Parquet','A clouer','Châtaignier','Déclassé','m2',23,100,0,12,'Production',NULL,'PRE',NULL,NULL,'2024-01-02 08:47:35','2024-03-06 14:34:00'),
(50,'PRES120ABDF',NULL,'Loubejac','Parquet','A clouer','Châtaignier','AB - 2 faces','m2',23,120,0,12,'Production',NULL,'PRE',NULL,'P4','2024-01-02 08:47:35','2024-03-07 10:28:55'),
(51,'PRES120AB',NULL,'Loubejac','Parquet','A clouer','Châtaignier','AB','m2',23,100,0,12,'Production',NULL,'PRE',NULL,NULL,'2024-01-02 08:47:35','2024-03-06 14:35:14'),
(52,'PRES120RUS',NULL,'Loubejac','Parquet','A clouer','Châtaignier','Rustique - 2 faces','m2',23,120,0,12,'Production',NULL,'PRE',NULL,'P4','2024-01-02 08:47:35','2024-03-07 10:29:24'),
(53,'PRES120DEC',NULL,'Loubejac','Parquet','A clouer','Châtaignier','Déclassé','m2',23,120,0,12,'Production',NULL,'PRE',NULL,NULL,'2024-01-02 08:47:35','2024-03-06 14:35:29'),
(54,'PRES100BAST',NULL,'Loubejac','Parquet','A clouer brut','Châtaignier','Bastide Pré-poncé','m2',23,100,0,12,'Production',NULL,'PRE',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 10:48:51'),
(55,'PRES120ECO',NULL,'Loubejac','Parquet','A clouer brut','Châtaignier','Eco pré-poncé','m2',23,120,0,12,'Production',NULL,'PRE',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 10:50:13'),
(56,'PTR70A',NULL,'Loubejac','Parquet','A clouer','Châtaignier','A','m2',23,70,0,12,'Production',NULL,'PTR',NULL,'P4','2024-01-02 08:47:35','2024-03-07 10:24:56'),
(57,'PTR70AB',NULL,'Loubejac','Parquet','A clouer','Châtaignier','AB','m2',23,70,0,12,'Production',NULL,'PTR',NULL,'P4','2024-01-02 08:47:35','2024-03-07 10:25:36'),
(58,'PTR70B',NULL,'Loubejac','Parquet','A clouer','Châtaignier','B','m2',23,70,0,12,'Production',NULL,'PTR',NULL,'P4','2024-01-02 08:47:35','2024-03-07 10:25:14'),
(59,'PTR70C',NULL,'Loubejac','Parquet','A clouer','Châtaignier','C','m2',23,70,0,12,'Production',NULL,'PTR',NULL,'P4','2024-01-02 08:47:35','2024-03-07 10:26:30'),
(60,'PTR70D',NULL,'Loubejac','Parquet','A clouer','Châtaignier','Déclassé','m2',23,70,0,12,'Production',NULL,'PTR',NULL,NULL,'2024-01-02 08:47:35','2024-03-06 14:05:58'),
(61,'PTR60D',NULL,'Loubejac','Parquet','A clouer','Châtaignier','D','m2',23,60,0,12,'Production',NULL,'PTR',NULL,NULL,'2024-01-02 08:47:35','2024-03-06 14:28:46'),
(62,'PTR70ABG',NULL,'Loubejac','Parquet','A clouer','Châtaignier','AB brut','m2',23,70,0,12,'Production',NULL,'PTR',NULL,NULL,'2024-01-02 08:47:35','2024-03-06 14:14:02'),
(63,'RECLAMBRISPIN',NULL,'Loubejac','Article',NULL,'Pin Maritime',NULL,'Pièce',0,0,0,12,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 09:28:02'),
(64,'REVLIEG',NULL,'Loubejac','Bande résiliente liege',NULL,'--N/A--',NULL,'ml',5,60,1000,12,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:56:48'),
(65,'BARDEAUX',NULL,'Loubejac','Bardeau',NULL,'Châtaignier',NULL,'m2',0,0,0,0,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 09:00:24'),
(66,'RECSEUIL',NULL,'Loubejac','Barre seuil',NULL,'Châtaignier',NULL,'m2',14,0,0,0,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:37:33'),
(67,'CHARP',NULL,'Loubejac','Charpente',NULL,'--N/A--',NULL,'m2',0,0,0,0,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 09:25:42'),
(69,'CHEVRONS6X8X3',NULL,'Loubejac','Chevron',NULL,'Pin',NULL,'Pièce',60,80,3000,0,'Production',NULL,NULL,NULL,NULL,'2024-01-02 08:47:35','2024-02-29 09:27:20'),
(70,'REVCOLLE25',NULL,'Loubejac','Colle','18kg à étaler en plein','--N/A--',NULL,'Pièce',0,0,0,0,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:50:36'),
(71,'REVCOLLE7',NULL,'Loubejac','Colle','6 kg à étaler en plein','--N/A--',NULL,'Pièce',0,0,0,0,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:54:53'),
(72,'RECROUTES',NULL,'Loubejac','Croute',NULL,'Châtaignier',NULL,'m2',0,0,2000,0,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:29:23'),
(73,'TRAVDEMI',NULL,'Loubejac','Traverse','Demi','Chêne','Paysagère non traité','m2',50,200,2000,12,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 12:40:36'),
(74,'REVETA',NULL,'Loubejac','Etaphon',NULL,'--N/A--',NULL,'Pièce',0,0,0,0,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:55:25'),
(75,'RECFRI',NULL,'Loubejac','Frise',NULL,'Châtaignier',NULL,'m2',0,0,0,0,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:23:21'),
(76,'GANIV100/4.5',NULL,'Briolance','Ganivelle','Fendue','Châtaignier',NULL,'ml',45,1000,5000,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 10:08:45'),
(77,'GANIV100/7.8',NULL,'Briolance','Ganivelle','Fendue','Châtaignier','Appointée','ml',78,1000,5000,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 10:09:03'),
(78,'GANIV120/4.5',NULL,'Briolance','Ganivelle','Fendue','Châtaignier','Appointée','ml',45,1200,5000,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 10:09:39'),
(79,'GANIV120/7.8',NULL,'Briolance','Ganivelle','Fendue','Châtaignier','Appointée','ml',78,1200,5000,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 10:09:48'),
(80,'GANIV150',NULL,'Briolance','Ganivelle','Sciée','Châtaignier',NULL,'ml',0,150,0,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 09:29:26'),
(81,'GANIV100/4.5REV',NULL,'Briolance','Ganivelle','Sciée','Châtaignier',NULL,'ml',45,1000,5000,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 10:08:53'),
(82,'HUILE1LITRE',NULL,'Loubejac','Huile','Parquet 1L','--N/A--','Incolore','Pièce',0,0,0,0,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-01-02 13:41:12'),
(83,'HUILE5LIT',NULL,'Loubejac','Huile','Parquet 5L','--N/A--','Incolore','Pièce',0,0,0,0,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-01-02 13:41:34'),
(84,'HUILECIRE2L5',NULL,'Loubejac','Cire','Blanchon 2.5L','--N/A--',NULL,'m2',0,0,0,0,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-01-02 13:46:24'),
(85,'HUILCIR1L',NULL,'Loubejac','Cire','Blanchon 1L','--N/A--',NULL,'m2',0,0,0,0,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-01-02 13:45:36'),
(86,'LAMBCHENE',NULL,'Loubejac','Lambourde',NULL,'Chêne',NULL,'Pièce',0,0,0,0,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 09:33:12'),
(87,'LAMBPIN',NULL,'Loubejac','Lambourde',NULL,'Pin',NULL,'Pièce',45,70,3000,0,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 09:35:07'),
(88,'RELAMBCHAT14',NULL,'Loubejac','Lame',NULL,'Châtaignier',NULL,'m2',14,0,0,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:39:26'),
(89,'RECCLAMDOUG',NULL,'Loubejac','Lambris','Brut','Douglas','AB','m2',14,130,0,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 11:00:17'),
(90,'LAMPIN70',NULL,'Loubejac','Lambris',NULL,'Pin Maritime',NULL,'m2',10,70,2000,12,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 09:42:56'),
(91,'RECPINVOLET',NULL,'Loubejac','Lame volet','Sans noeud','Pin Maritime',NULL,'Pièce',0,0,2400,12,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:27:59'),
(92,'RECLAMCHAT',NULL,'Loubejac','Lame terrasse',NULL,'Châtaignier',NULL,'m2',0,0,0,0,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:25:10'),
(93,'LAMESTERRASSE',NULL,'Loubejac','Lame terrasse',NULL,'Châtaignier',NULL,'m2',0,0,0,0,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 09:16:30'),
(94,'RECTERRCHENE',NULL,'Loubejac','Lame terrasse',NULL,'Chêne',NULL,'m2',24,120,0,12,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:37:44'),
(95,'RECTERDOUGLAS',NULL,'Loubejac','Lame terrasse',NULL,'Douglas',NULL,'m2',0,0,0,12,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:31:33'),
(96,'RECLAMPIN',NULL,'Loubejac','Lame terrasse',NULL,'Pin',NULL,'m2',0,0,0,0,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:24:55'),
(97,'RECTERROB',NULL,'Loubejac','Lame terrasse',NULL,'Robinier',NULL,'m2',24,120,0,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:37:55'),
(98,'RELISSES',NULL,'Loubejac','Lisse',NULL,'Châtaignier',NULL,'m2',0,0,0,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:36:00'),
(99,'RECLISSES',NULL,'Loubejac','Lisse',NULL,'Châtaignier',NULL,'m2',27,120,2000,0,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:25:37'),
(100,'REVLITPIN',NULL,'Loubejac','Liteaux','non raboté','Pin',NULL,'Pièce',27,27,2000,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:57:35'),
(101,'REVMAS',NULL,'Loubejac','Mastic',NULL,'--N/A--',NULL,'Pièce',0,0,0,0,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:58:02'),
(102,'RECCHAT14',NULL,'Loubejac','Parquet',NULL,'Châtaignier',NULL,'m2',14,0,0,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 10:54:44'),
(103,'RECCHAT23',NULL,'Loubejac','Parquet',NULL,'Châtaignier',NULL,'m2',23,0,0,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 10:58:14'),
(104,'PTR60B',NULL,'Loubejac','Parquet','A clouer','Châtaignier','B','m2',23,60,0,12,'Production',NULL,'REV',NULL,'P4','2024-01-02 08:47:35','2024-03-07 10:25:27'),
(105,'RECCHAT27',NULL,'Loubejac','Parquet',NULL,'Châtaignier',NULL,'m2',27,0,0,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 10:58:27'),
(106,'RECCCOLLE',NULL,'Loubejac','Parquet',NULL,'Châtaignier','Contrecollé','m2',11,140,0,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 10:52:41'),
(107,'RECCHENE9GO2C',NULL,'Loubejac','Parquet','A coller GO2','Chêne','Campagne','m2',14,90,0,12,'Production',NULL,'REV',NULL,'P7','2024-01-02 08:47:35','2024-03-07 13:38:37'),
(108,'RECCHENE9GO2PRV',NULL,'Loubejac','Parquet','A coller GO2','Chêne','PR Verni','m2',14,90,0,12,'Production',NULL,'REV',NULL,'P7','2024-01-02 08:47:35','2024-03-07 13:41:42'),
(109,'RECCHENE9GO2CV',NULL,'Loubejac','Parquet','A coller GO2','Chêne','Campagne','m2',14,90,0,12,'Production',NULL,'REV',NULL,'P7','2024-01-02 08:47:35','2024-03-07 13:43:34'),
(110,'RECDOUG',NULL,'Loubejac','Parquet',NULL,'Douglas',NULL,'m2',0,0,0,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:23:02'),
(111,'RECCHAT',NULL,'Loubejac','Parquet',NULL,'Châtaignier',NULL,'m2',0,0,0,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:16:56'),
(112,'REPIN',NULL,'Loubejac','Parquet',NULL,'Pin',NULL,'m2',0,0,0,12,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:36:35'),
(113,'RECCPEU',NULL,'Loubejac','Parquet','A clouer','Peuplier','Massif','m2',23,130,0,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 11:00:37'),
(114,'RECPN14',NULL,'Loubejac','Parquet',NULL,'Pin',NULL,'m2',14,110,0,12,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:36:38'),
(115,'RECCPIN10ABC',NULL,'Loubejac','Parquet','A clouer','Pin Maritime','ABC','m2',27,100,0,12,'Negoce',NULL,'REV',NULL,'P8','2024-01-02 08:47:35','2024-03-08 09:41:18'),
(116,'RECPINP140NO',NULL,'Loubejac','Parquet','Noueux','Pin Maritime','Brut','m2',23,140,2000,12,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:34:54'),
(117,'REVPEUP24/120',NULL,'Loubejac','Parquet',NULL,'Peuplier',NULL,'m2',24,120,0,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:47:47'),
(118,'PIQUETS',NULL,'Loubejac','Piquet',NULL,'Châtaignier',NULL,'Pièce',0,0,0,0,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 09:54:34'),
(119,'REPIQUETS',NULL,'Loubejac','Piquet et tuteur',NULL,'--N/A--',NULL,'Pièce',0,0,0,0,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:37:17'),
(120,'REVPLINTHE7',NULL,'Loubejac','Plinthe',NULL,'Châtaignier','Brut Poncée','ml',15,70,0,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:59:22'),
(121,'SCIPLOTS20',NULL,'Loubejac','Plot',NULL,'Châtaignier',NULL,'m3',20,0,0,0,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:49:54'),
(122,'SCIPLOTS27',NULL,'Loubejac','Plot',NULL,'Châtaignier',NULL,'m3',27,0,0,0,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:49:47'),
(123,'SCIPLOTS34',NULL,'Loubejac','Plot',NULL,'Châtaignier',NULL,'m3',34,0,0,0,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:49:35'),
(124,'SCIPLOTS54',NULL,'Loubejac','Plot',NULL,'Châtaignier',NULL,'m3',54,0,0,0,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:51:02'),
(125,'RECPORT',NULL,'Loubejac','Portillon','Scié','Châtaignier',NULL,'Pièce',0,1000,0,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:37:10'),
(126,'RECQUINCAIL',NULL,'Loubejac','Quincaillerie',NULL,'--N/A--',NULL,'Pièce',0,0,0,0,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:28:40'),
(127,'RECSATUR',NULL,'Loubejac','Saturateur','Blanchon','--N/A--',NULL,'Pièce',0,0,0,0,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:29:57'),
(128,'TRAV2000',NULL,'Loubejac','Traverse',NULL,'Chêne','Paysagère non traité','m2',200,100,2000,12,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 12:33:23'),
(129,'RECTRAVERSES',NULL,'Loubejac','Traverse',NULL,'Chêne',NULL,'Pièce',0,0,0,12,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:32:29'),
(130,'RECVOLPIN',NULL,'Loubejac','Volige',NULL,'Pin',NULL,'Pièce',20,200,2400,12,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:34:39'),
(131,'VOLCHAT',NULL,'Loubejac','Volige','Brut','Châtaignier',NULL,'m2',0,0,0,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 12:41:50'),
(132,'VOLCHENE',NULL,'Loubejac','Volige',NULL,'Chêne',NULL,'m2',0,0,0,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 12:42:40'),
(133,'VOLIG DOUGLAS',NULL,'Loubejac','Volige',NULL,'Douglas',NULL,'m2',0,0,2000,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:53:49'),
(134,'RECVOLDOUG',NULL,'Loubejac','Volige',NULL,'Douglas',NULL,'m2',18,200,2500,12,'Negoce',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:33:05'),
(135,'RECVOLPEUP',NULL,'Loubejac','Volige','Mi-bois - rainée en bout','Peuplier','ABC','m2',16,150,0,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:38:08'),
(136,'VOLPEUPMI',NULL,'Loubejac','Volige','Mi-bois','Peuplier',NULL,'m2',0,0,2000,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:55:01'),
(137,'RECVOLPIN2M',NULL,'Loubejac','Volige',NULL,'Pin Maritime','Brut','m2',20,200,2000,12,'Production',NULL,'REV',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:35:14'),
(138,'REV9RUSTGO2',NULL,'Loubejac','Parquet','A coller GO2','Châtaignier','Rustique','m2',14,90,0,12,'Production',NULL,'R14',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:46:53'),
(139,'REV9ABGO2HUIL',NULL,'Loubejac','Parquet','A coller GO2','Châtaignier','AB Huilé','m2',14,90,0,12,'Production',NULL,'R14',NULL,'P5','2024-01-02 08:47:35','2024-03-07 10:36:06'),
(140,'REV15/120GO4CON',NULL,'Loubejac','Parquet','GO2','Châtaignier','AB brut','m2',14,120,0,12,'Production',NULL,'R14',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:42:01'),
(141,'REV15/120GO4CD',NULL,'Loubejac','Parquet','GO2','Châtaignier','ECO','m2',14,120,0,12,'Production',NULL,'R14',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:41:53'),
(142,'REV15/120GO4RUS',NULL,'Loubejac','Parquet','GO2','Châtaignier','Rustique','m2',14,120,0,12,'Production',NULL,'R14',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:42:19'),
(143,'REV7CONF',NULL,'Loubejac','Parquet','A coller brut','Châtaignier','AB','m2',15,70,0,12,'Production',NULL,'R14',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:49:03'),
(144,'REV7RUS',NULL,'Loubejac','Parquet','A coller','Châtaignier','Rustique brut','m2',15,70,0,12,'Production',NULL,'R14',NULL,'P5','2024-01-02 08:47:35','2024-03-07 10:34:52'),
(145,'REV7CDPLAT',NULL,'Loubejac','Parquet','A coller','Châtaignier','ECO plat','m2',14,70,0,12,'Production',NULL,'R14',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:44:39'),
(146,'REV15/120GO4FINI',NULL,'Loubejac','Parquet','GO2','Châtaignier',NULL,'m2',14,120,0,12,'Production',NULL,'R14',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:42:09'),
(147,'REV9GO2HUIL',NULL,'Loubejac','Parquet','GO2','Châtaignier','AB Huilé naturel','m2',14,90,0,12,'Production',NULL,'R14',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:51:57'),
(148,'REV9GO2VMAT',NULL,'Loubejac','Parquet','GO2','Châtaignier','AB Verni naturel mat','m2',14,90,0,12,'Production',NULL,'R14',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:53:22'),
(149,'REV9GO2NAT',NULL,'Loubejac','Parquet','GO2','Châtaignier','AB Verni naturel satiné','m2',14,90,0,12,'Production',NULL,'R14',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:52:41'),
(150,'REV9AB',NULL,'Loubejac','Parquet','A coller','Châtaignier','AB','m2',14,90,0,12,'Production',NULL,'R14',NULL,'P5','2024-01-02 08:47:35','2024-03-07 08:12:15'),
(151,'REV15/120GO2VERN',NULL,'Loubejac','Parquet','GO2 a coller','Châtaignier','Vernis','m2',14,120,0,12,'Production',NULL,'R14',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:41:44'),
(152,'REV9RUSPLAT',NULL,'Loubejac','Parquet','A coller plat','Châtaignier','Rustique','m2',14,90,0,12,'Production',NULL,'R14',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:46:11'),
(153,'REV9ROMP',NULL,'Loubejac','Parquet','A coller GO2-BATONS ROMPUS','Châtaignier','AB contrecollé','m2',14,90,450,12,'Production',NULL,'R14',NULL,'P5','2024-01-02 08:47:35','2024-03-07 12:56:55'),
(154,'REV9CDPLAT',NULL,'Loubejac','Parquet','A coller','Châtaignier','ECO','m2',15,90,0,12,'Production',NULL,'R14',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 10:51:13'),
(155,'REV9CDGO2',NULL,'Loubejac','Parquet','A coller GO2','Châtaignier','Eco','m2',14,90,0,12,'Production',NULL,'R14',NULL,NULL,'2024-01-02 08:47:35','2024-01-03 12:57:59'),
(156,'REV9PH',NULL,'Loubejac','Parquet','A coller GO2-POINTS DE HONGRIE','Châtaignier','Brut contrecollé','m2',14,90,60,12,'Production',NULL,'R14',NULL,'P5','2024-01-02 08:47:35','2024-03-07 12:57:17'),
(157,'POT7/7RAB',NULL,'Loubejac','Poteau','Raboté','Châtaignier',NULL,'Pièce',70,70,2000,12,'Negoce',NULL,'SCI',NULL,NULL,'2024-01-02 08:47:35','2024-02-14 08:44:02'),
(158,'BCHATAVI20',NULL,'Briolance','Avivé','Toutes Largeurs','Châtaignier','cf1/cf2','m3',20,0,2500,12,'Production',NULL,'BSCIACHAT',NULL,NULL,'2024-01-02 08:47:35','2024-01-22 16:17:14'),
(159,'BCHATAV27S',NULL,'Briolance','Avivé','Toutes Largeurs','Châtaignier','cf1/cf2','m3',27,0,2500,100,'Production',NULL,'BSCIACHAT',NULL,NULL,'2024-01-02 08:47:35','2024-01-22 16:08:31'),
(160,'BCHATAVIV34',NULL,'Briolance','Avivé','Toutes Largeurs','Châtaignier','cf1/cf2','m3',34,0,2500,12,'Production',NULL,'BSCIACHAT',NULL,NULL,'2024-01-02 08:47:35','2024-03-04 15:23:03'),
(161,'BAVCHARPENTE',NULL,'Briolance','Avivé','Toutes Largeurs','Châtaignier','Charpente','m2',27,0,2000,12,'Production',NULL,'BSCIACHAT',NULL,NULL,'2024-01-02 08:47:35','2024-01-22 15:03:17'),
(162,'BCROUTE2.0',NULL,'Loubejac','Croute',NULL,'Châtaignier','Déclassé','m2',0,0,2000,0,'Production',NULL,'BSCIACHAT',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 09:13:47'),
(163,'BCROUTE2.5',NULL,'Loubejac','Croute',NULL,'Châtaignier','Délignée','m2',0,0,2500,0,'Production',NULL,'BSCIACHAT',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 09:14:52'),
(164,'BCHATFRISE',NULL,'Loubejac','Frise',NULL,'Châtaignier','LF','m2',0,0,0,50,'Production',NULL,'BSCIACHAT',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 12:53:37'),
(165,'BCHATLIS',NULL,'Loubejac','Lisse',NULL,'Châtaignier','Brut non raboté','m2',27,120,2000,0,'Production',NULL,'BSCIACHAT',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 09:05:54'),
(166,'MARQUANT',NULL,'Loubejac','Marquant',NULL,'Châtaignier',NULL,'m2',0,0,0,0,'Production',NULL,'BSCIACHAT',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 09:41:56'),
(168,'BCHATPLO45',NULL,'Loubejac','Plot',NULL,'Châtaignier','cs1 /cs2','m2',45,0,2500,0,'Production',NULL,'BSCIACHAT',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 09:57:03'),
(169,'BCHATPLO54',NULL,'Loubejac','Plot',NULL,'Châtaignier','cs1/cs2','m2',54,0,2500,0,'Production',NULL,'BSCIACHAT',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 09:57:45'),
(170,'BCHATPLO65',NULL,'Loubejac','Plot',NULL,'Châtaignier','cs1/cs2','m2',65,0,2500,0,'Production',NULL,'BSCIACHAT',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 09:57:53'),
(171,'POT9/9',NULL,'Loubejac','Poteau',NULL,'Châtaignier',NULL,'Pièce',90,90,2000,0,'Production',NULL,'BSCIACHAT',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 09:57:41'),
(172,'BCHATVOL20',NULL,'Briolance','Volige',NULL,'Châtaignier','cs1/cs2','m2',20,0,0,12,'Production',NULL,'BSCIACHAT',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 14:55:41'),
(173,'BPEUP27/180/2',NULL,'Briolance','Avivé',NULL,'Peuplier',NULL,'m3',27,180,2000,12,'Production',NULL,'BSCIAPEUP',NULL,NULL,'2024-01-02 08:47:35','2024-02-14 15:27:25'),
(174,'BPEUP27/250R',NULL,'Briolance','Avivé',NULL,'Peuplier','Raboté','m3',27,250,2000,12,'Production',NULL,'BSCIAPEUP',NULL,NULL,'2024-01-02 08:47:35','2024-01-22 16:09:44'),
(175,'BPEUPLAT30/30',NULL,'Loubejac','Latte',NULL,'Peuplier',NULL,'m2',30,30,2000,100,'Production',NULL,'BSCIAPEUP',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 09:19:54'),
(176,'BPEUPAL50/100',NULL,'Loubejac','Cale',NULL,'Peuplier',NULL,'m2',50,100,2400,100,'Production',NULL,'BSCIAPEUP',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 09:19:17'),
(177,'BPEUREF',NULL,'Loubejac','Refente',NULL,'Peuplier',NULL,'m2',11,80,2000,0,'Production',NULL,'BSCIAPEUP',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 09:21:57'),
(178,'BCHATPLO34',NULL,'Loubejac','Plot',NULL,'Châtaignier','cs1/cs2','m2',34,0,2500,0,'Production',NULL,'BSCIAPEUP',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 09:56:52'),
(179,'BPEUPAL22/100',NULL,'Briolance','Volige',NULL,'Peuplier','palette','m2',22,100,0,100,'Production',NULL,'BSCIAPEUP',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 10:03:30'),
(180,'BPEUP24/120/2',NULL,'Briolance','Volige',NULL,'Peuplier',NULL,'m3',24,120,2000,12,'Production',NULL,'BSCIAPEUP',NULL,NULL,'2024-01-02 08:47:35','2024-02-14 15:32:46'),
(181,'BPEUP24/180',NULL,'Briolance','Volige',NULL,'Peuplier',NULL,'m3',24,180,2000,12,'Production',NULL,'BSCIAPEUP',NULL,NULL,'2024-01-02 08:47:35','2024-01-22 15:28:59'),
(182,'BPEUP24TL',NULL,'Briolance','Volige','Toutes Largeurs','Peuplier',NULL,'m3',24,0,2000,12,'Production',NULL,'BSCIAPEUP',NULL,NULL,'2024-01-02 08:47:35','2024-01-22 15:29:18'),
(183,'VOLPEUBRUTE',NULL,'Loubejac','Volige','Brut','Peuplier','Toute largeur','m2',20,0,2000,12,'Production',NULL,'BSCIAPEUP',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 12:44:50'),
(184,'BPEUP10/150',NULL,'Briolance','Volige',NULL,'Peuplier',NULL,'m2',10,150,2000,12,'Production',NULL,'BSCIAPEUP',NULL,NULL,'2024-01-02 08:47:35','2024-03-04 15:23:32'),
(185,'SPRFAG',NULL,'Loubejac','Fagot',NULL,'Châtaignier',NULL,'m2',0,0,0,0,'Production',NULL,'SPR',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 12:30:24'),
(186,'SPRPLATON10',NULL,'Loubejac','Plaquette','TVA 10%','Châtaignier',NULL,'m2',0,0,0,0,'Production',NULL,'SPR',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 12:31:17'),
(189,'SPRRECEXO',NULL,'Loubejac','Recoupe',NULL,'Châtaignier','EXO','m2',0,0,0,0,'Production',NULL,'SPR',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 12:31:39'),
(190,'SPRSCIURE',NULL,'Loubejac','Sciure',NULL,'--N/A--',NULL,'m2',0,0,0,0,'Production',NULL,'SPR',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 12:32:25'),
(191,'VOLCLIN',NULL,'Loubejac','Bardage','Profil clin','Châtaignier','ABC','m2',0,21,120,0,'Production',NULL,'VOL',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 12:43:19'),
(192,'VOLCHARAB',NULL,'Loubejac','Volige','Rabotée','Châtaignier',NULL,'m2',0,0,0,12,'Production',NULL,'VOL',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 12:42:18'),
(193,'VOLPEU',NULL,'Loubejac','Volige','Rabotée','Peuplier',NULL,'m2',27,160,2000,12,'Production',NULL,'VOL',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:54:28'),
(194,'XPARQPEFC',NULL,'Loubejac','Parquet',NULL,'Châtaignier','PEFC 100%','m2',23,0,0,12,'Production',NULL,'XPE',NULL,NULL,'2024-01-02 08:47:35','2024-03-01 12:55:28'),
(195,'XPLAPEFC',NULL,'Loubejac','Plaquette',NULL,'Châtaignier','PEFC 100%','m2',0,0,0,12,'Production',NULL,'XPE',NULL,NULL,'2024-01-02 08:47:35','2024-02-29 12:47:39'),
(196,'HUILENVBB1L',NULL,'Loubejac','Huile','Environnement 1L','--N/A--','Bois Brut','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-02 11:07:38','2024-01-02 14:25:18'),
(197,'HUILEENVBN5L',NULL,'Loubejac','Huile','Environnement 5L','--N/A--','Bois Naturel','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-02 14:29:11','2024-01-02 15:47:12'),
(198,'HUILEENVBB5L',NULL,'Loubejac','Huile','Environnement 5L','--N/A--','Bois Brut','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-02 14:31:20','2024-01-03 20:07:54'),
(199,'HUILEENVBB0.5L',NULL,'Loubejac','Huile','Environnement 0,5L','--N/A--','Bois Brut','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-02 14:41:58','2024-01-03 20:08:03'),
(200,'MASTER',NULL,'Loubejac','Mastic','Terrasse','--N/A--','1 Kg','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-02 14:46:00','2024-01-02 16:45:07'),
(201,'MASPAR',NULL,'Loubejac','Mastic','Parquet','--N/A--','1 Kg','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-02 15:33:04','2024-01-02 16:45:30'),
(202,'HUILEBARDRC',NULL,'Loubejac','Huile','Bardage 5 L','--N/A--','Red Cedar','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-02 15:39:43','2024-01-02 15:39:43'),
(203,'HUILETERBARBG',NULL,'Loubejac','Huile','Terrasse Bardage 1 L','--N/A--','Bois Grisé','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-02 15:51:44','2024-01-02 15:53:47'),
(204,'HUILETERBARBN',NULL,'Loubejac','Huile','Terrasse Bardage 1L','--N/A--','Bois Naturel','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-02 15:54:45','2024-01-02 20:56:19'),
(205,'PROTECANTIUV',NULL,'Loubejac','Huile','Protecteur anti-UV 5 L','--N/A--',NULL,'Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-02 16:14:30','2024-01-02 16:15:37'),
(206,'ENTRETIEN_VAPO_0,25L',NULL,'Loubejac','Huile','Entretien Vapo 0,25L','--N/A--',NULL,'Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-02 16:17:09','2024-01-03 20:05:33'),
(207,'Protec_Terrasse',NULL,'Loubejac','Huile','Protecteur Terrasse 5 L','--N/A--',NULL,'Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-04 10:24:11','2024-01-04 10:24:11'),
(208,'Conditionneur',NULL,'Loubejac','Huile','Conditionneur Anti UV 5 L','--N/A--',NULL,'Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-04 10:26:13','2024-01-04 10:26:13'),
(209,'Satur_Env_BN',NULL,'Loubejac','Huile','Saturateur Environnement 5 L','--N/A--','Bois Naturel','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-04 10:29:18','2024-01-04 10:29:18'),
(210,'Lasure_TW',NULL,'Loubejac','Huile','Lasure Tech Wood 5 L','--N/A--',NULL,'Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-04 10:30:53','2024-01-04 10:30:53'),
(211,'Huile_Cire_Nat',NULL,'Loubejac','Huile','Cire 1 L','--N/A--','Naturel','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-04 10:37:08','2024-01-04 10:37:08'),
(212,'Huile_Cire_BB',NULL,'Loubejac','Huile','Cire 1 L','--N/A--','Bois Brut','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-04 10:38:37','2024-01-04 10:38:37'),
(213,'Huile_Cire_Blanc',NULL,'Loubejac','Huile','Cire 1 L','--N/A--','Blanc','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-04 10:39:53','2024-01-04 10:39:53'),
(214,'Huile_Cire_CF_2,5',NULL,'Loubejac','Huile','Cire 2,5 L','--N/A--','Chêne Fumé','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-04 10:43:31','2024-01-04 10:43:31'),
(215,'Huile_Cire_BB_2,5',NULL,'Loubejac','Huile','Cire 2,5 L','--N/A--','Bois Brut','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-04 10:47:12','2024-01-04 10:47:12'),
(216,'Huile_Cire_CC_0,25',NULL,'Loubejac','Huile','Cire 0,25 L','--N/A--','Chêne Clair','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-04 13:22:01','2024-01-04 13:22:01'),
(217,'Huile_Cire_CF_0,25',NULL,'Loubejac','Huile','Cire 0,25 L','--N/A--','Chêne Fumé','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-04 13:24:34','2024-01-04 13:24:34'),
(218,'Huile_Cire_BB_0,25',NULL,'Loubejac','Huile','Cire 0,25 L','--N/A--','Bois Brut','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-04 13:27:26','2024-01-04 13:27:26'),
(219,'Huile_Cire_BF_0,25',NULL,'Loubejac','Huile','Cire 0,25 L','--N/A--','Bois Flotté','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-04 14:40:52','2024-01-04 14:40:52'),
(220,'Huile_Cire_BN_0,25',NULL,'Loubejac','Huile','Cire 0,25 L','--N/A--','Bois Naturel','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-04 14:45:18','2024-01-04 14:45:18'),
(221,'Huile_entr_nat',NULL,'Loubejac','Huile','Entretien 1 L','--N/A--','Naturel','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-04 15:04:58','2024-01-04 15:05:32'),
(222,'Sat_Env_0,75',NULL,'Loubejac','Huile','Saturateur Environnement 0,75 L','--N/A--','Naturel','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-04 15:08:53','2024-01-04 15:08:53'),
(223,'TRAIT_DECOUP_TERR_1 L',NULL,'Loubejac','Huile','Traitement de Découpe Terrasse 1 L','--N/A--',NULL,'Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-04 15:19:01','2024-01-04 15:19:01'),
(224,'Savon',NULL,'Loubejac','Savon','Savon 1 L','--N/A--',NULL,'Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-04 15:21:52','2024-01-04 15:21:52'),
(225,'Fonddur_1L',NULL,'Loubejac','Huile','Fond Dur 1 L','--N/A--','Préplast','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-04 15:37:03','2024-01-04 15:37:03'),
(226,'Colle_6Kg',NULL,'Loubejac','Colle','6 Kg','--N/A--',NULL,'Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-04 15:41:10','2024-01-04 15:49:30'),
(228,'Colle_18Kg',NULL,'Loubejac','Colle','18 Kg','--N/A--',NULL,'Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-04 15:49:07','2024-01-04 15:49:07'),
(229,'Sup_pot_7x7',NULL,'Loubejac','Support Poteaux','7 X 7','--N/A--','Noir','Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-01-04 15:53:00','2024-01-04 15:53:00'),
(230,'LAMB_CHAT_26X55',NULL,'Loubejac','Lambourde',NULL,'Châtaignier',NULL,'Pièce',26,55,1000,0,'Production',NULL,NULL,NULL,NULL,'2024-01-04 15:55:51','2024-03-01 09:46:20'),
(231,'POT10/10',NULL,'Loubejac','Poteau',NULL,'Châtaignier',NULL,'Pièce',100,100,2000,0,'Production',NULL,'BSCIACHAT',NULL,NULL,'2024-01-04 16:08:03','2024-02-14 08:43:34'),
(238,'POT12/12',NULL,'Loubejac','Poteau',NULL,'Châtaignier',NULL,'m2',120,120,2500,0,'Production',NULL,'BSCIACHAT',NULL,NULL,'2024-01-19 15:05:48','2024-02-14 08:43:27'),
(239,'BCHAFRI160x27x2V',NULL,'Briolance','Frise',NULL,'Châtaignier',NULL,'m2',27,160,2000,100,'Intermédiaire',NULL,NULL,NULL,NULL,'2024-01-22 15:36:19','2024-01-22 16:02:25'),
(240,'BCHAFRI120x27x2V',NULL,'Briolance','Frise',NULL,'Châtaignier',NULL,'m2',27,120,2000,100,'Intermédiaire',NULL,NULL,NULL,NULL,'2024-01-22 15:37:23','2024-01-22 16:02:11'),
(241,'BCHAFRI140x27x2V',NULL,'Briolance','Frise',NULL,'Châtaignier',NULL,'m2',27,140,2000,100,'Intermédiaire',NULL,NULL,NULL,NULL,'2024-01-22 15:38:05','2024-01-22 16:02:18'),
(242,'BLAMGANS22x2V',NULL,'Briolance','Lame Ganivelle',NULL,'Châtaignier',NULL,'m2',22,0,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-01-22 15:40:20','2024-02-29 07:44:47'),
(243,'BPEUP24/180/2.5',NULL,'Briolance','Volige',NULL,'Peuplier',NULL,'m3',24,180,2500,12,'Production',NULL,NULL,NULL,NULL,'2024-01-22 15:58:59','2024-01-22 15:58:59'),
(244,'BPEUP24/120/2.5',NULL,'Briolance','Volige',NULL,'Peuplier',NULL,'m3',24,120,2500,12,'Production',NULL,NULL,NULL,NULL,'2024-01-22 16:01:55','2024-03-04 15:25:44'),
(245,'BPEUP27/180/2.5',NULL,'Briolance','Avivé',NULL,'Peuplier',NULL,'m3',27,180,2500,12,'Production',NULL,NULL,NULL,NULL,'2024-01-22 16:06:23','2024-01-22 16:06:23'),
(246,'BCHATAVI20/2.5',NULL,'Briolance','Avivé','Toutes Largeurs','Châtaignier','cf1/cf2','m3',20,0,2500,12,'Production',NULL,NULL,NULL,NULL,'2024-01-22 16:16:52','2024-01-22 16:16:52'),
(247,'BGANS',NULL,'Briolance','Ganivelle','Sciée','Châtaignier',NULL,'ml',45,800,5000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-01 15:43:53','2024-02-01 15:43:53'),
(248,'BGANS080/75',NULL,'Briolance','Ganivelle','Sciée','Châtaignier',NULL,'ml',75,800,5000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-01 16:12:31','2024-02-01 16:12:31'),
(249,'BGANS050/45',NULL,'Briolance','Ganivelle','Sciée','Châtaignier',NULL,'ml',45,500,5000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-01 16:14:14','2024-02-01 16:14:14'),
(250,'PIQUETS28/35.2',NULL,'Loubejac','Piquet','Scié','Châtaignier',NULL,'Pièce',280,350,2000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-02 10:40:33','2024-02-02 10:40:33'),
(251,'PIQUET26/32.1.80',NULL,'Loubejac','Piquet',NULL,'Châtaignier',NULL,'Pièce',260,320,1800,0,'Production',NULL,NULL,NULL,NULL,'2024-02-02 10:46:37','2024-02-14 13:51:13'),
(252,'PIQUET8/10.1.80',NULL,'Loubejac','Piquet',NULL,'Châtaignier',NULL,'Pièce',80,100,1800,0,'Production',NULL,NULL,NULL,NULL,'2024-02-02 10:48:30','2024-02-14 13:51:37'),
(253,'PIQUET6/8.1.60',NULL,'Loubejac','Piquet',NULL,'Châtaignier',NULL,'Pièce',60,80,1600,0,'Production',NULL,NULL,NULL,NULL,'2024-02-02 10:51:24','2024-03-01 10:44:37'),
(254,'PIQUET26/32.1.60',NULL,'Loubejac','Piquet',NULL,'Châtaignier',NULL,'Pièce',260,320,1600,0,'Production',NULL,NULL,NULL,NULL,'2024-02-02 10:55:49','2024-02-14 13:50:40'),
(255,'PIQUET28/35.2.50',NULL,'Loubejac','Piquet',NULL,'Châtaignier',NULL,'Pièce',280,350,2500,0,'Production',NULL,NULL,NULL,NULL,'2024-02-02 11:01:59','2024-02-14 13:54:02'),
(256,'GAN1/7.8',NULL,'Loubejac','Ganivelle','Fendue','Châtaignier',NULL,'ml',78,1000,10000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-02 12:36:10','2024-03-01 10:07:55'),
(257,'GAN1/4.5',NULL,'Loubejac','Ganivelle','Fendue','Châtaignier',NULL,'ml',45,1000,10000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-02 12:40:16','2024-03-01 13:39:20'),
(258,'GAN1.20/4.5',NULL,'Loubejac','Ganivelle','Fendue','Châtaignier',NULL,'ml',45,1200,10000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-02 12:57:32','2024-03-01 13:38:46'),
(259,'POT9/9RAB',NULL,'Loubejac','Poteau',NULL,'Châtaignier','Raboté','Pièce',90,90,2000,0,'Negoce',NULL,NULL,NULL,NULL,'2024-02-14 09:04:24','2024-02-29 07:33:56'),
(260,'CHATAVIV20',NULL,'Loubejac','Avivé',NULL,'Châtaignier',NULL,'m2',20,110,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-14 09:40:26','2024-02-29 14:16:49'),
(261,'CHATAVIV34/250',NULL,'Loubejac','Avivé',NULL,'Châtaignier',NULL,'m2',0,34,2500,0,'Production',NULL,NULL,NULL,NULL,'2024-02-14 09:44:01','2024-02-14 09:53:26'),
(262,'CHATAVIV20/250',NULL,'Loubejac','Avivé',NULL,'Châtaignier',NULL,'m2',20,110,2500,0,'Production',NULL,NULL,NULL,NULL,'2024-02-14 09:45:46','2024-02-29 14:16:42'),
(263,'CHATAVIV27/240',NULL,'Loubejac','Avivé',NULL,'Châtaignier',NULL,'m2',27,0,2400,0,'Production',NULL,NULL,NULL,NULL,'2024-02-14 09:47:28','2024-03-01 10:04:41'),
(264,'CHATAVIV27/250',NULL,'Loubejac','Avivé',NULL,'Châtaignier',NULL,'m2',27,0,2500,0,'Production',NULL,NULL,NULL,NULL,'2024-02-14 09:49:33','2024-03-01 10:04:53'),
(265,'CHATAVIV27/200',NULL,'Loubejac','Avivé',NULL,'Châtaignier',NULL,'m2',27,0,2000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-14 09:56:53','2024-03-01 10:04:32'),
(266,'CHATFRI27XTLX2',NULL,'Loubejac','Frise',NULL,'Châtaignier',NULL,'m2',27,0,2000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-14 10:09:43','2024-02-14 10:09:43'),
(267,'POT8X8',NULL,'Loubejac','Poteau',NULL,'Châtaignier','Déclassé','Pièce',80,80,2000,0,'Negoce',NULL,NULL,NULL,NULL,'2024-02-14 10:14:23','2024-03-01 10:46:52'),
(268,'TRAV2000GRISE',NULL,'Loubejac','Traverse',NULL,'Châtaignier','Grise','Pièce',200,100,2000,0,'Destockage',NULL,NULL,NULL,NULL,'2024-02-14 10:25:46','2024-03-01 13:22:34'),
(269,'GAN120/7.8NOIR',NULL,'Loubejac','Ganivelle','Fendue','Châtaignier','Noir','ml',78,1200,10000,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-14 10:43:20','2024-03-01 10:08:19'),
(270,'GAN100/4.5NOIR',NULL,'Loubejac','Ganivelle','Fendue','Châtaignier','Noir','ml',45,1000,10000,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-14 10:48:15','2024-03-01 10:08:09'),
(271,'GAN150/4.5NOIR',NULL,'Loubejac','Ganivelle','Fendue','Châtaignier','Noir','ml',45,1500,5000,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-14 10:52:05','2024-03-01 10:08:33'),
(272,'GANS100/4.5NOIR',NULL,'Loubejac','Ganivelle','Sciée','Châtaignier','Noir','ml',45,100,5000,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-14 10:57:57','2024-02-29 09:28:13'),
(273,'GANS100/7.8NOIR',NULL,'Loubejac','Ganivelle','Sciée','Châtaignier','Noir','ml',78,100,5000,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-14 12:45:03','2024-02-29 09:28:22'),
(274,'GANS120/7.8NOIR',NULL,'Loubejac','Ganivelle','Sciée','Châtaignier','Noir','ml',78,120,5000,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-14 12:47:40','2024-02-29 09:28:57'),
(275,'GANS120/4.5NOIR',NULL,'Loubejac','Ganivelle','Sciée','Châtaignier','Noir','ml',45,120,5000,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-14 12:52:09','2024-02-29 09:28:31'),
(276,'GANS150/4.5NOIR',NULL,'Loubejac','Ganivelle','Sciée','Châtaignier','Noir','ml',45,150,5000,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-14 12:53:56','2024-02-29 09:58:48'),
(277,'GANS120/4.5NOIRBF',NULL,'Loubejac','Ganivelle','Sciée','Châtaignier','Noir Bois Frais','ml',45,120,5000,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-14 12:58:21','2024-02-29 09:28:40'),
(278,'GANS180/4.5NOIR',NULL,'Loubejac','Ganivelle','Sciée','Châtaignier','Noir','ml',45,180,5000,0,'Destockage',NULL,NULL,NULL,NULL,'2024-02-14 13:04:25','2024-02-26 10:25:51'),
(279,'CHATVOL20/2.50S',NULL,'Loubejac','Volige',NULL,'Douglas','Douglas','Pièce',20,200,2500,0,'Production',NULL,NULL,NULL,NULL,'2024-02-14 13:11:04','2024-02-14 13:26:25'),
(280,'PIQUETL1/2R.2',NULL,'Loubejac','Piquet','Lisse','Châtaignier','1/2 rond','Pièce',0,0,2000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-14 13:14:22','2024-02-14 13:14:22'),
(281,'ACACIAPIQUET1.80',NULL,'Loubejac','Piquet',NULL,'Acacia',NULL,'Pièce',0,0,1800,0,'Negoce',NULL,NULL,NULL,NULL,'2024-02-14 13:24:40','2024-03-01 09:53:36'),
(282,'PIQUETL2ÉCO',NULL,'Loubejac','Piquet','Lisse','Châtaignier','Éco','Pièce',0,0,2000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-14 13:56:03','2024-02-14 14:03:28'),
(283,'PIQUETPIN',NULL,'Loubejac','Piquet',NULL,'Pin',NULL,'Pièce',0,0,0,0,'Production',NULL,NULL,NULL,NULL,'2024-02-14 13:58:26','2024-02-14 13:58:26'),
(284,'PIQUET26/32.2.00',NULL,'Loubejac','Piquet',NULL,'Châtaignier',NULL,'Pièce',260,320,2000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-14 14:00:34','2024-02-14 14:00:34'),
(285,'CROUTE2.5',NULL,'Loubejac','Croute','Déligner','Châtaignier',NULL,'Pièce',0,0,2500,0,'Production',NULL,NULL,NULL,NULL,'2024-02-14 14:08:48','2024-02-14 14:08:48'),
(286,'CROUTE2.0',NULL,'Loubejac','Croute',NULL,'Châtaignier',NULL,'Pièce',0,0,2000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-14 14:11:00','2024-02-14 14:11:00'),
(287,'CHEVROND6X8X3',NULL,'Loubejac','Chevron',NULL,'Douglas',NULL,'Pièce',60,80,3000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-14 14:22:57','2024-02-14 14:22:57'),
(288,'CHEVROND6X8X4',NULL,'Loubejac','Chevron',NULL,'Douglas',NULL,'Pièce',60,80,4000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-14 14:24:40','2024-02-14 14:24:40'),
(289,'PLANCHEPIN',NULL,'Loubejac','Planche',NULL,'Pin',NULL,'Pièce',27,160,3000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-14 14:29:47','2024-02-14 14:29:47'),
(290,'PLANCHESAPIN',NULL,'Loubejac','Planche',NULL,'--N/A--',NULL,'Pièce',40,200,4000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-14 14:32:01','2024-02-14 14:32:01'),
(291,'LAMB',NULL,'Loubejac','Lambourde',NULL,'Châtaignier',NULL,'Pièce',45,70,3000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-14 14:43:32','2024-02-29 09:32:40'),
(292,'LAMETERRAPIN',NULL,'Loubejac','Lame terrasse',NULL,'Pin',NULL,'Pièce',23,145,2000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-14 14:50:38','2024-02-14 14:50:38'),
(293,'LAMETERRADO',NULL,'Loubejac','Lame terrasse',NULL,'Douglas',NULL,'Pièce',27,142,4000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-14 14:57:10','2024-02-14 14:57:10'),
(294,'LAMESTERRPINS',NULL,'Loubejac','Lame terrasse',NULL,'Pin',NULL,'Pièce',27,145,4000,0,'Negoce',NULL,NULL,NULL,NULL,'2024-02-14 14:59:34','2024-03-01 10:24:40'),
(295,'CHEVRONS6X8X5',NULL,'Loubejac','Chevron',NULL,'Pin',NULL,'Pièce',60,80,5000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-14 15:05:02','2024-02-14 15:05:02'),
(296,'BORDPIN',NULL,'Loubejac','Bordurette',NULL,'Pin',NULL,'Pièce',0,0,0,0,'Destockage',NULL,NULL,NULL,NULL,'2024-02-14 15:10:27','2024-02-28 15:38:14'),
(297,'POTEAUDOUG',NULL,'Loubejac','Poteau',NULL,'Douglas',NULL,'Pièce',20,20,3000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-14 15:13:24','2024-02-14 15:13:24'),
(298,'BPEUP27/160/2.5',NULL,'Loubejac','Avivé',NULL,'Peuplier',NULL,'m3',27,160,2500,12,'Production',NULL,NULL,NULL,NULL,'2024-02-14 15:19:25','2024-02-29 14:19:30'),
(299,'BPEUP27/130/2.5',NULL,'Loubejac','Avivé',NULL,'Peuplier',NULL,'m3',27,130,2500,12,'Production',NULL,NULL,NULL,NULL,'2024-02-14 15:25:12','2024-02-29 14:19:13'),
(300,'BPEUP27/130/2',NULL,'Loubejac','Avivé',NULL,'Peuplier',NULL,'m3',27,130,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-14 15:29:34','2024-02-29 14:19:05'),
(301,'BPEUP22/95/2',NULL,'Loubejac','Avivé',NULL,'Peuplier',NULL,'m3',22,95,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-14 15:31:22','2024-02-29 14:18:32'),
(302,'BPEUP27/160/2',NULL,'Loubejac','Avivé',NULL,'Peuplier',NULL,'m3',27,160,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-14 15:34:26','2024-02-29 14:19:23'),
(303,'BPEUP27TL',NULL,'Loubejac','Avivé',NULL,'Peuplier','Toute largeur','m3',27,0,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-14 15:51:17','2024-02-29 14:17:10'),
(304,'BPEUP27x95x2',NULL,'Loubejac','Avivé',NULL,'Peuplier',NULL,'m3',27,0,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-14 15:53:08','2024-02-29 14:17:21'),
(305,'BPEUP24X100X2',NULL,'Loubejac','Avivé',NULL,'Peuplier',NULL,'m3',24,100,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-14 15:54:39','2024-02-29 14:18:49'),
(306,'ACCPL22x95',NULL,'Loubejac','Plinthe',NULL,'Châtaignier',NULL,'ml',22,95,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-14 16:04:24','2024-02-29 07:55:51'),
(307,'ACCPL22x110',NULL,'Loubejac','Plinthe',NULL,'Châtaignier',NULL,'ml',22,110,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-14 16:06:04','2024-02-29 07:55:45'),
(308,'BPEUP22/110/2VIEUX',NULL,'Loubejac','Avivé',NULL,'Peuplier',NULL,'m2',22,110,2000,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-14 16:08:17','2024-02-29 14:18:23'),
(309,'BCHATAV22/90/2',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m3',22,90,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-14 16:11:42','2024-02-29 14:45:55'),
(310,'BCHATAV22/140/2',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m3',20,140,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-14 16:14:23','2024-03-12 15:06:26'),
(311,'BPEUP22/95/2DECL',NULL,'Loubejac','Avivé',NULL,'Peuplier',NULL,'m3',22,95,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-14 16:25:20','2024-02-29 14:18:40'),
(312,'BCHATAV34/140/2',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m3',34,140,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-15 14:23:52','2024-02-29 14:46:16'),
(313,'BPEUPDEC24/180/2',NULL,'Loubejac','Avivé',NULL,'Peuplier','Déclassé','m3',24,180,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-15 14:25:01','2024-02-29 14:17:47'),
(314,'BCHATAVDEC27/130/2',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m3',27,130,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-15 14:28:25','2024-02-29 14:46:28'),
(315,'BCHATAVIV27/160/2D',NULL,'Loubejac','Avivé',NULL,'Châtaignier',NULL,'m3',27,160,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-15 14:32:44','2024-02-29 12:51:49'),
(316,'BCHATPLO27TL2',NULL,'Loubejac','Plot',NULL,'Châtaignier','Toutes largeurs','m3',27,0,2000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-15 14:56:03','2024-02-15 14:56:03'),
(317,'BTAS1.30/1.25/2',NULL,'Loubejac','Tasseau',NULL,'Châtaignier',NULL,'Pièce',130,120,1000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-15 14:58:25','2024-02-15 14:58:25'),
(318,'BECHAL1.5/1.20/1',NULL,'Loubejac','Échalas',NULL,'Châtaignier',NULL,'m3',150,120,1000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-15 15:01:11','2024-02-15 15:01:11'),
(319,'BGANS150/23',NULL,'Briolance','Ganivelle','Sciée','Châtaignier',NULL,'ml',23,1500,5000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-15 15:07:26','2024-03-01 10:00:46'),
(320,'BGANS080/23',NULL,'Briolance','Ganivelle','Sciée','Châtaignier',NULL,'ml',23,1500,5000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-15 15:10:28','2024-03-01 09:59:40'),
(321,'BCHATPLO27D',NULL,'Briolance','Plot',NULL,'Châtaignier','à déligner','m3',27,0,2500,0,'Production',NULL,NULL,NULL,NULL,'2024-02-15 15:50:55','2024-02-15 15:50:55'),
(322,'BCHATPLO20',NULL,'Briolance','Plot',NULL,'Châtaignier',NULL,'m3',20,0,2000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-15 15:53:26','2024-02-15 15:53:26'),
(323,'POT125/125',NULL,'Briolance','Poteau',NULL,'Châtaignier',NULL,'Pièce',125,125,2500,0,'Production',NULL,NULL,NULL,NULL,'2024-02-16 08:53:36','2024-02-16 08:53:36'),
(324,'POT13/13',NULL,'Briolance','Poteau',NULL,'Châtaignier',NULL,'Pièce',130,130,2500,0,'Production',NULL,NULL,NULL,NULL,'2024-02-16 08:55:43','2024-03-01 10:46:30'),
(325,'BPEUP24/110/250',NULL,'Briolance','Volige',NULL,'Peuplier',NULL,'m2',24,110,2500,12,'Production',NULL,NULL,NULL,NULL,'2024-02-16 09:03:23','2024-03-04 15:24:57'),
(326,'BPEUP24/120/150',NULL,'Briolance','Volige',NULL,'Peuplier',NULL,'m2',24,120,1500,12,'Production',NULL,NULL,NULL,NULL,'2024-02-16 09:17:14','2024-03-04 15:25:11'),
(327,'BPEUP27/TL/2',NULL,'Briolance','Avivé',NULL,'Peuplier',NULL,'m3',27,0,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-16 09:21:58','2024-02-29 14:17:01'),
(328,'BPEUP27/120/2',NULL,'Briolance','Avivé',NULL,'Peuplier',NULL,'m2',27,120,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-16 09:24:06','2024-02-29 14:18:57'),
(329,'BPEUPDEC27/180/2',NULL,'Briolance','Avivé',NULL,'Peuplier','Déclassé','m2',27,180,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-16 09:26:34','2024-02-29 14:17:55'),
(330,'BCHATAV27X180X2',NULL,'Briolance','Avivé',NULL,'Châtaignier','Déclassé','Pièce',27,180,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-16 10:47:59','2024-02-29 12:52:00'),
(331,'BCHATAVIV27/TL/2.5',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m3',27,0,2500,12,'Production',NULL,NULL,NULL,NULL,'2024-02-16 10:54:34','2024-02-29 12:53:27'),
(332,'BCHATFRISES140',NULL,'Briolance','Frise',NULL,'Châtaignier','Sèche','m3',140,0,0,0,'Production',NULL,NULL,NULL,NULL,'2024-02-16 10:56:43','2024-02-16 10:56:43'),
(333,'BCHATFRISESP',NULL,'Briolance','Frise',NULL,'Châtaignier','Plinthe','m3',0,0,0,0,'Production',NULL,NULL,NULL,NULL,'2024-02-16 10:58:16','2024-02-16 10:58:16'),
(334,'LAMBCHAT34X2.50',NULL,'Briolance','Lambourde',NULL,'Châtaignier',NULL,'m3',34,0,2500,0,'Production',NULL,NULL,NULL,NULL,'2024-02-16 11:01:39','2024-02-16 11:01:59'),
(335,'BCHATFRISE140V',NULL,'Briolance','Frise',NULL,'Châtaignier','Vert','m3',0,140,0,0,'Production',NULL,NULL,NULL,NULL,'2024-02-16 12:59:13','2024-03-01 08:20:27'),
(336,'BCHATFRISE120V',NULL,'Briolance','Frise',NULL,'Châtaignier','Vert','m3',0,120,0,0,'Production',NULL,NULL,NULL,NULL,'2024-02-16 13:03:00','2024-03-01 08:20:14'),
(337,'BCHATPLO17DEC',NULL,'Briolance','Plot','à déligner','Châtaignier','à déclassé','m3',27,0,0,0,'Production',NULL,NULL,NULL,NULL,'2024-02-16 13:05:36','2024-02-16 13:05:36'),
(338,'BCHATFRISE160',NULL,'Briolance','Frise',NULL,'Châtaignier',NULL,'m3',0,160,0,0,'Production',NULL,NULL,NULL,NULL,'2024-02-16 13:07:22','2024-03-01 08:20:37'),
(339,'BCHATFRISE120',NULL,'Briolance','Frise',NULL,'Châtaignier',NULL,'m3',0,120,0,50,'Production',NULL,NULL,NULL,NULL,'2024-02-16 13:08:06','2024-03-01 08:20:04'),
(340,'BCHATFRISE140',NULL,'Briolance','Frise',NULL,'Châtaignier',NULL,'m3',0,140,0,0,'Production',NULL,NULL,NULL,NULL,'2024-02-16 13:08:56','2024-03-01 08:19:51'),
(341,'BCHATFRISE90',NULL,'Briolance','Frise',NULL,'Châtaignier',NULL,'m3',0,90,0,0,'Production',NULL,NULL,NULL,NULL,'2024-02-16 13:09:33','2024-03-01 08:20:46'),
(342,'BCHATAVIV',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m3',45,130,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-16 13:15:39','2024-02-29 12:51:04'),
(343,'BCHATFRISEDEL',NULL,'Briolance','Frise',NULL,'Châtaignier','à déligner','m3',22,120,2000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-16 13:16:39','2024-02-16 13:16:39'),
(344,'BCHATAVIV22/100/2.5D',NULL,'Briolance','Avivé',NULL,'Peuplier','Déclassé','m3',22,100,2500,12,'Production',NULL,NULL,NULL,NULL,'2024-02-16 13:17:23','2024-02-29 12:51:14'),
(345,'BPEUPAVIV50/100/2.40D',NULL,'Briolance','Avivé',NULL,'Châtaignier','Déclassé','m3',50,100,2400,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-16 13:18:33','2024-02-29 14:17:39'),
(346,'LAMBPEUP160S',NULL,'Loubejac','Lambris',NULL,'Peuplier','Sauvage','m2',0,160,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-26 08:50:27','2024-03-01 10:15:29'),
(347,'LAMBPEUP100ABC',NULL,'Loubejac','Lambris',NULL,'Peuplier','ABC','m2',0,0,1000,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-26 08:51:49','2024-03-01 10:16:54'),
(348,'PANCPEUP23/160D',NULL,'Loubejac','Parquet',NULL,'Peuplier','D','m2',23,160,0,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-26 08:55:51','2024-02-29 09:50:41'),
(349,'PANCPEUP23/100AB',NULL,'Loubejac','Parquet',NULL,'Peuplier','AB','m2',23,100,0,12,'Production',NULL,NULL,NULL,NULL,'2024-02-26 08:57:49','2024-02-29 09:50:32'),
(350,'PEUP14/110AB',NULL,'Loubejac','Volige',NULL,'Peuplier','AB','m2',14,110,0,12,'Production',NULL,NULL,NULL,NULL,'2024-02-26 09:01:53','2024-02-29 09:50:49'),
(351,'BARDEAUX50',NULL,'Loubejac','Bardeaux','Scié','Châtaignier','Mélèze','m2',0,0,500,0,'Production',NULL,NULL,NULL,NULL,'2024-02-26 09:07:56','2024-03-01 09:20:30'),
(352,'CHATVOL23/140D',NULL,'Loubejac','Volige','Mi-bois','Châtaignier','D','m2',23,140,0,0,'Production',NULL,NULL,NULL,NULL,'2024-02-26 09:11:04','2024-03-01 10:05:20'),
(353,'PANC12DEC',NULL,'Loubejac','Parquet','A clouer','Châtaignier','Déclassé','m2',23,120,0,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-26 09:14:51','2024-03-06 14:07:43'),
(354,'LAMCHAT24/70',NULL,'Loubejac','Lambourde',NULL,'Châtaignier','Contrecollé','Pièce',24,70,2100,0,'Destockage',NULL,NULL,NULL,NULL,'2024-02-26 09:19:06','2024-03-01 10:19:04'),
(355,'LAMBROB60/40',NULL,'Loubejac','Lambourde',NULL,'Robinier','Aboutée','Pièce',60,40,2000,0,'Destockage',NULL,NULL,NULL,NULL,'2024-02-26 09:20:42','2024-02-26 09:20:42'),
(356,'VOLCHATMB',NULL,'Loubejac','Volige','Mi-bois','Châtaignier',NULL,'m2',23,120,2000,0,'Destockage',NULL,NULL,NULL,NULL,'2024-02-26 09:23:42','2024-02-26 09:23:42'),
(357,'PEUP16/TL/2',NULL,'Loubejac','Volige','Mi-bois','Peuplier','Vieux lot','m2',16,0,2000,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-26 09:26:02','2024-02-29 09:51:02'),
(358,'ACCPL7ABC',NULL,'Loubejac','Plinthe',NULL,'Châtaignier','ABC','ml',15,70,1000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-26 09:29:48','2024-02-29 08:53:03'),
(359,'ACCPLPEUPAB',NULL,'Loubejac','Plinthe',NULL,'Peuplier','AB','ml',15,130,0,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-26 09:33:35','2024-02-29 12:52:38'),
(360,'ACCPL7RUSD',NULL,'Loubejac','Plinthe','Vieille','Châtaignier','Rustique','ml',15,70,0,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-26 09:36:09','2024-02-29 07:57:12'),
(361,'BARPEUP12',NULL,'Loubejac','Bardage',NULL,'Peuplier','Raboté','ml',20,120,1500,0,'Destockage',NULL,NULL,NULL,NULL,'2024-02-26 09:39:35','2024-02-26 09:39:35'),
(362,'REV14GO2B',NULL,'Loubejac','Revêtement','GO2-Brut','Châtaignier','AB','m2',11,140,0,12,'Production',NULL,NULL,NULL,'P5','2024-02-26 09:48:21','2024-03-07 10:37:03'),
(363,'LBR11/70AB',NULL,'Loubejac','Lambris',NULL,'Châtaignier','AB','m2',10,70,0,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-26 09:52:47','2024-03-01 09:39:16'),
(364,'LAMESTERRASSES24/120R',NULL,'Loubejac','Lame terrasse','Rainuré','Châtaignier','Rustique','m2',24,130,1200,0,'Destockage',NULL,NULL,NULL,NULL,'2024-02-26 09:56:48','2024-03-01 10:22:53'),
(365,'LAMESTERRASSES24/120L',NULL,'Loubejac','Lame terrasse','Lisse','Châtaignier',NULL,'m2',24,130,1200,0,'Negoce',NULL,NULL,NULL,NULL,'2024-02-26 09:58:21','2024-03-01 10:24:27'),
(366,'LAMESTERRASSES24/140L',NULL,'Loubejac','Lame terrasse','Lisse','Châtaignier',NULL,'m2',24,130,1400,0,'Destockage',NULL,NULL,NULL,NULL,'2024-02-26 09:59:42','2024-03-01 10:23:25'),
(367,'LAMESTERRASSE24/140R',NULL,'Loubejac','Lame terrasse','Rainuré','Châtaignier','Rustique','m2',24,130,1400,0,'Destockage',NULL,NULL,NULL,NULL,'2024-02-26 10:00:50','2024-03-01 10:22:24'),
(368,'BORDPIND',NULL,'Loubejac','Bordurette',NULL,'Pin',NULL,'Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-02-26 10:02:09','2024-02-28 12:52:22'),
(369,'LAMESTERRPINSD',NULL,'Loubejac','Lame terrasse',NULL,'Pin','Noueux','m2',23,145,2000,0,'Destockage',NULL,NULL,NULL,NULL,'2024-02-26 10:04:21','2024-02-26 10:04:21'),
(370,'PANC12C',NULL,'Loubejac','Parquet','A clouer','Châtaignier','C','m2',23,120,0,12,'Production',NULL,NULL,NULL,'P4','2024-02-26 10:07:05','2024-03-07 10:27:04'),
(371,'REV7AB',NULL,'Loubejac','Parquet','A coller','Châtaignier','AB','m2',14,70,0,12,'Production',NULL,NULL,NULL,'P5','2024-02-26 10:09:09','2024-03-07 10:34:12'),
(372,'REV7D',NULL,'Loubejac','Parquet','A coller','Châtaignier','Déclassé','m2',14,70,0,0,'Destockage',NULL,NULL,NULL,NULL,'2024-02-26 10:10:02','2024-03-06 16:22:32'),
(373,'REVRGO2',NULL,'Loubejac','Revêtement','Rust GO2','Châtaignier',NULL,'m2',14,70,0,0,'Destockage',NULL,NULL,NULL,NULL,'2024-02-26 10:10:55','2024-03-01 12:47:28'),
(374,'REV9ABGO2D',NULL,'Loubejac','Parquet','GO2','Châtaignier','AB','m2',14,90,0,12,'Production',NULL,NULL,NULL,NULL,'2024-02-26 10:12:01','2024-03-06 16:16:26'),
(375,'REV12AB',NULL,'Loubejac','Revêtement','A coller GO2','Châtaignier','AB','m2',14,120,0,12,'Production',NULL,NULL,NULL,'P5','2024-02-26 10:13:59','2024-03-07 10:34:37'),
(376,'PIQUET10/12.1.90',NULL,'Loubejac','Piquet',NULL,'Châtaignier',NULL,'Pièce',100,120,1900,0,'Destockage',NULL,NULL,NULL,NULL,'2024-02-26 10:16:26','2024-03-01 13:37:20'),
(377,'RONDINSNAP',NULL,'Loubejac','Rondins','non appointé','Châtaignier',NULL,'Pièce',0,0,2500,0,'Destockage',NULL,NULL,NULL,NULL,'2024-02-26 10:20:31','2024-03-01 14:57:56'),
(378,'PEUPAVIV22/110/2',NULL,'Loubejac','Avivé',NULL,'Peuplier',NULL,'m3',22,110,2000,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-26 12:46:12','2024-02-29 09:51:22'),
(379,'BPEUP50/100/2DECL',NULL,'Briolance','Avivé',NULL,'Peuplier','Déclassé','m3',50,100,2000,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-26 14:04:01','2024-02-29 14:17:30'),
(380,'BCHATFRISESP110',NULL,'Briolance','Frise',NULL,'Châtaignier','Plinthe','m3',20,110,2000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-26 14:31:16','2024-02-26 14:31:16'),
(381,'POTEAU8.5/8.5',NULL,'Briolance','Poteau',NULL,'Châtaignier',NULL,'Pièce',85,85,2000,0,'Negoce',NULL,NULL,NULL,NULL,'2024-02-26 15:20:47','2024-02-26 15:20:47'),
(382,'BCHATFRISETERR',NULL,'Loubejac','Frise',NULL,'Châtaignier','Terrasse','m3',0,0,140,0,'Production',NULL,NULL,NULL,NULL,'2024-02-26 15:29:44','2024-02-26 15:29:44'),
(383,'BCHATPLO45/2',NULL,'Briolance','Plot',NULL,'Châtaignier','à déligner','m3',45,0,2000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-26 15:36:21','2024-03-01 09:57:18'),
(384,'BGANS120/2.3',NULL,'Briolance','Ganivelle','Sciée','Châtaignier',NULL,'ml',23,1200,5000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-26 15:48:57','2024-03-01 10:00:13'),
(385,'POT10/10/2.5',NULL,'Loubejac','Poteau',NULL,'Châtaignier',NULL,'Pièce',100,100,2500,0,'Negoce',NULL,NULL,NULL,NULL,'2024-02-26 16:26:57','2024-03-01 10:46:11'),
(386,'LAMBCHAT60X45X2',NULL,'Briolance','Lambourde',NULL,'Châtaignier',NULL,'Pièce',60,45,2000,0,'Negoce',NULL,NULL,NULL,NULL,'2024-02-26 16:28:57','2024-02-26 16:28:57'),
(387,'TRAV3000',NULL,'Briolance','Traverse',NULL,'Châtaignier','Pour bordure','Pièce',0,0,3000,0,'Production',NULL,NULL,NULL,NULL,'2024-02-26 16:30:56','2024-02-26 16:30:56'),
(388,'PANC10H',NULL,'Loubejac','Parquet','A clouer','Châtaignier','Huilé','m2',23,100,0,12,'Production',NULL,NULL,NULL,'P4','2024-02-28 07:34:17','2024-03-07 10:27:35'),
(389,'REV12N',NULL,'Loubejac','Parquet','A coller','Châtaignier','Naturel','m2',14,120,0,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-28 07:35:46','2024-03-07 07:36:55'),
(390,'REV9BN',NULL,'Loubejac','Revêtement',NULL,'Châtaignier','Brossé Naturel','m2',14,90,0,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-28 07:37:35','2024-03-01 12:45:00'),
(391,'LBR14/9NC',NULL,'Loubejac','Lambris',NULL,'Châtaignier','Naturel Court','m2',14,90,0,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-28 07:40:27','2024-03-01 10:32:24'),
(392,'REV9VNM',NULL,'Loubejac','Revêtement',NULL,'Châtaignier','Vernis Naturel Mat','m2',14,90,0,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-28 07:43:44','2024-03-01 12:47:09'),
(393,'PANC10ABH',NULL,'Loubejac','Parquet','A clouer','Châtaignier','AB Huilé','m2',0,100,0,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-28 07:51:37','2024-03-06 14:06:57'),
(394,'REV9V',NULL,'Loubejac','Revêtement',NULL,'Châtaignier','Vernis','m2',14,90,0,0,'Destockage',NULL,NULL,NULL,NULL,'2024-02-28 08:00:15','2024-02-28 08:00:15'),
(395,'REV180GO2',NULL,'Loubejac','Parquet','GO2 a coller','Châtaignier',NULL,'m2',11,140,180,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-28 08:02:06','2024-03-06 16:22:21'),
(396,'REV100',NULL,'Loubejac','Parquet','A coller','Châtaignier',NULL,'m2',0,0,100,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-28 08:03:00','2024-03-07 07:37:04'),
(397,'LBR14/9VN',NULL,'Loubejac','Lambris',NULL,'Châtaignier','Vernis Naturel','m2',14,90,0,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-28 08:07:27','2024-03-01 10:32:50'),
(398,'LBR14/9NM',NULL,'Loubejac','Lambris',NULL,'Châtaignier','Naturel Mat','m2',14,90,0,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-28 08:09:03','2024-03-01 10:32:40'),
(399,'LBR14/12RN',NULL,'Loubejac','Lambris',NULL,'Châtaignier','Rustique Naturel','m2',14,120,0,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-28 08:10:25','2024-03-01 09:37:03'),
(400,'LBR14/12N',NULL,'Loubejac','Lambris',NULL,'Châtaignier','Naturel','m2',14,120,0,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-28 08:11:43','2024-03-01 09:36:35'),
(401,'LBR14/90ABP',NULL,'Loubejac','Lambris',NULL,'Châtaignier','AB Poncé','m2',14,90,0,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-28 08:12:51','2024-03-01 09:38:08'),
(402,'LBR10/16',NULL,'Loubejac','Lambris',NULL,'Châtaignier',NULL,'m2',16,100,2000,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-28 08:13:40','2024-03-01 10:28:06'),
(403,'PANC10AB',NULL,'Loubejac','Parquet','A clouer','Châtaignier','AB','m2',23,100,0,12,'Production',NULL,NULL,NULL,'P4','2024-02-28 08:16:18','2024-03-07 10:25:58'),
(404,'PANC10BAS',NULL,'Loubejac','Parquet','A clouer','Châtaignier','Bastide','m2',0,100,0,12,'Destockage',NULL,NULL,NULL,NULL,'2024-02-28 08:17:17','2024-03-06 14:07:07'),
(405,'PANCPEUP',NULL,'Loubejac','Parquet',NULL,'Peuplier',NULL,'Palette',0,0,0,12,'Production',NULL,NULL,NULL,NULL,'2024-02-28 08:22:00','2024-03-01 09:15:22'),
(406,'POT10.5/10.5',NULL,'Loubejac','Poteau',NULL,'Châtaignier',NULL,'Pièce',105,105,2500,0,'Negoce',NULL,NULL,NULL,NULL,'2024-02-28 09:06:37','2024-03-01 10:45:49'),
(407,'BPEUP20/11',NULL,'Briolance','Avivé',NULL,'Peuplier',NULL,'m2',20,110,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-28 09:08:59','2024-02-29 14:18:11'),
(408,'PEUPREBUS',NULL,'Loubejac','Rebus',NULL,'Peuplier',NULL,'m2',0,0,0,0,'Production',NULL,NULL,NULL,NULL,'2024-02-28 09:09:43','2024-02-28 09:09:43'),
(409,'BCHATAVIV27/90/2',NULL,'Loubejac','Avivé',NULL,'Châtaignier',NULL,'m2',27,90,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-28 09:13:22','2024-02-29 12:53:19'),
(410,'BCHATAVIV27/160/2',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m2',27,160,2,12,'Production',NULL,NULL,NULL,NULL,'2024-02-28 09:14:26','2024-02-29 12:51:41'),
(411,'BCHATAVIV27/120/2',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m2',27,120,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-28 09:15:31','2024-02-29 12:51:22'),
(412,'BCHATAVIV27/140/2',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m2',27,140,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-28 09:16:24','2024-02-29 12:51:31'),
(413,'LAMPIN10',NULL,'Loubejac','Lambris',NULL,'Pin Maritime',NULL,'m2',10,0,2000,12,'Negoce',NULL,NULL,NULL,NULL,'2024-02-28 09:26:56','2024-03-01 09:43:24'),
(414,'BILLECHENE',NULL,'Briolance','Bille',NULL,'Chêne',NULL,'m3',0,0,0,50,'Destockage',NULL,NULL,NULL,NULL,'2024-02-28 09:28:26','2024-03-01 14:02:59'),
(415,'BILLEACC',NULL,'Briolance','Bille',NULL,'Acacia',NULL,'m3',0,0,0,50,'Destockage',NULL,NULL,NULL,NULL,'2024-02-28 09:31:46','2024-03-01 14:03:15'),
(416,'RECCCOLLE15',NULL,'Loubejac','Parquet',NULL,'Châtaignier','Contrecollé','m2',15,140,0,12,'Production',NULL,NULL,NULL,NULL,'2024-02-28 09:38:30','2024-03-01 10:53:47'),
(417,'RECVOLPIN27',NULL,'Loubejac','Volige',NULL,'Pin',NULL,'Pièce',27,200,200,0,'Negoce',NULL,NULL,NULL,NULL,'2024-02-28 09:42:43','2024-02-28 09:42:43'),
(418,'RECCPIN10SN',NULL,'Loubejac','Parquet','A clouer','Pin Maritime','Sans Noeud','m2',23,100,2000,12,'Negoce',NULL,NULL,NULL,'P8','2024-02-28 09:47:24','2024-03-07 16:23:20'),
(419,'RECCPIN10PN',NULL,'Loubejac','Parquet','A clouer','Pin Maritime','Petits Noeuds','m2',23,100,200,12,'Negoce',NULL,NULL,NULL,'P8','2024-02-28 09:48:31','2024-03-07 16:27:02'),
(420,'RECCPIN10NO',NULL,'Loubejac','Parquet','A clouer','Pin Maritime','Noueux','m2',23,100,2000,12,'Negoce',NULL,NULL,NULL,'P8','2024-02-28 09:51:29','2024-03-07 16:23:02'),
(421,'RECCPIN14PN',NULL,'Loubejac','Parquet','A clouer','Pin Maritime','Petits Noeuds','m2',23,140,2000,12,'Negoce',NULL,NULL,NULL,'P8','2024-02-28 09:52:30','2024-03-08 09:31:12'),
(422,'BCHATVOL23',NULL,'Briolance','Volige',NULL,'Châtaignier',NULL,'Pièce',23,0,120,0,'Production',NULL,NULL,NULL,NULL,'2024-02-28 09:54:03','2024-03-01 09:58:08'),
(423,'RECCPIN14SN',NULL,'Loubejac','Parquet','A clouer','Pin Maritime','Sans Noeud','m2',23,140,2000,12,'Negoce',NULL,NULL,NULL,'P8','2024-02-28 09:55:34','2024-03-08 09:31:22'),
(424,'PEUPFRISES27/150/150',NULL,'Loubejac','Frise',NULL,'Peuplier',NULL,'m2',27,150,1500,0,'Negoce',NULL,NULL,NULL,NULL,'2024-02-28 10:00:19','2024-03-01 10:41:20'),
(425,'RECCPINCHAMP',NULL,'Loubejac','Parquet',NULL,'Pin','Champêtre','m2',0,0,0,12,'Negoce',NULL,NULL,NULL,NULL,'2024-02-28 10:05:06','2024-02-29 10:22:44'),
(426,'RECCPIN14NO',NULL,'Loubejac','Parquet','A clouer','Pin Maritime','Noueux','m2',23,140,2000,12,'Negoce',NULL,NULL,NULL,'P8','2024-02-28 10:10:59','2024-03-08 09:31:03'),
(427,'RECCPIN15V',NULL,'Loubejac','Parquet','A clouer GO4','Pin Maritime','Noueux- Pré Huilé','m2',20,150,0,12,'Negoce',NULL,NULL,NULL,'P8','2024-02-28 10:11:44','2024-03-08 09:35:30'),
(428,'PEUPFRISES27/120/200',NULL,'Loubejac','Frise',NULL,'Peuplier',NULL,'m2',27,120,2000,0,'Negoce',NULL,NULL,NULL,NULL,'2024-02-28 10:18:44','2024-02-28 10:18:44'),
(429,'PEUPFRISES24/120/150',NULL,'Loubejac','Frise',NULL,'Peuplier',NULL,'m2',24,120,1500,0,'Negoce',NULL,NULL,NULL,NULL,'2024-02-28 10:19:47','2024-03-01 10:41:27'),
(430,'PLPIN',NULL,'Loubejac','Plinthe',NULL,'Pin',NULL,'Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-02-28 10:21:36','2024-02-28 10:21:36'),
(431,'LAMBROB',NULL,'Loubejac','Lambourde',NULL,'Robinier',NULL,'Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,NULL,'2024-02-28 10:23:24','2024-02-28 10:23:24'),
(432,'RECCOLLEB',NULL,'Loubejac','Parquet','A coller','Châtaignier','Brut','m2',0,0,0,12,'Production',NULL,NULL,NULL,NULL,'2024-02-28 10:25:12','2024-03-06 16:16:54'),
(433,'CHATFRI85',NULL,'Loubejac','Frise',NULL,'Châtaignier',NULL,'Pile',0,0,85,0,'Production',NULL,NULL,NULL,NULL,'2024-02-28 10:54:05','2024-02-28 10:54:05'),
(434,'CHATFRI135',NULL,'Loubejac','Frise',NULL,'Châtaignier',NULL,'Pile',0,0,135,0,'Production',NULL,NULL,NULL,NULL,'2024-02-28 10:55:59','2024-02-28 10:55:59'),
(435,'CHATFRI105',NULL,'Loubejac','Frise',NULL,'Châtaignier',NULL,'m2',0,0,105,0,'Production',NULL,NULL,NULL,NULL,'2024-02-28 10:57:45','2024-02-28 10:57:45'),
(436,'PLATCHENE2.50',NULL,'Briolance','Plateau',NULL,'Chêne',NULL,'Pièce',0,60,2500,0,'Destockage',NULL,NULL,NULL,NULL,'2024-02-28 11:01:50','2024-02-28 16:20:04'),
(437,'MERPLO27/2.50',NULL,'Briolance','Plot',NULL,'Châtaignier',NULL,'Palette',27,0,2500,0,'Production',NULL,NULL,NULL,NULL,'2024-02-28 12:35:02','2024-03-01 10:33:24'),
(438,'BCHATAV27/TL/2.5',NULL,'Briolance','Avivé',NULL,'Châtaignier','Déclassé','m2',27,0,2500,12,'Production',NULL,NULL,NULL,NULL,'2024-02-28 14:58:21','2024-02-29 14:46:03'),
(439,'PEUP17/110',NULL,'Loubejac','Volige',NULL,'Peuplier','ABC','m2',17,110,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-28 15:49:47','2024-03-01 09:18:55'),
(440,'BILLEPEUP',NULL,'Briolance','Bille',NULL,'Peuplier',NULL,'m3',0,0,0,50,'Destockage',NULL,NULL,NULL,NULL,'2024-02-28 16:19:20','2024-03-01 14:03:29'),
(441,'PLATMER',NULL,'Briolance','Plateau',NULL,'Merisier',NULL,'Palette',0,27,2500,0,'Destockage',NULL,NULL,NULL,NULL,'2024-02-28 16:30:56','2024-02-28 16:30:56'),
(442,'BCHATAV27/90/2',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m2',27,90,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-29 14:47:47','2024-02-29 14:47:47'),
(443,'BCHATVOL20/110/2',NULL,'Briolance','Volige',NULL,'Châtaignier',NULL,'m2',20,110,2000,12,'Production',NULL,NULL,NULL,NULL,'2024-02-29 14:58:04','2024-02-29 14:58:04'),
(444,'BCHATVOL20/110/2.5',NULL,'Briolance','Volige',NULL,'Châtaignier',NULL,'m2',20,110,2500,12,'Production',NULL,NULL,NULL,NULL,'2024-02-29 14:58:56','2024-02-29 14:58:56'),
(445,'BCHATAV27/90/2.5',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m2',27,90,2500,12,'Production',NULL,NULL,NULL,NULL,'2024-02-29 15:24:27','2024-02-29 15:24:27'),
(446,'BCHATPLO45/2.5',NULL,'Briolance','Plot',NULL,'Châtaignier',NULL,'m2',45,0,2500,0,'Production',NULL,NULL,NULL,NULL,'2024-02-29 15:41:23','2024-03-01 09:57:34'),
(447,'BCHATAV27/160/2.5',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m2',27,160,2500,12,'Production',NULL,NULL,NULL,NULL,'2024-02-29 15:52:12','2024-02-29 15:52:12'),
(448,'BCHATAVIV27/140/2.5',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m2',27,140,2500,12,'Production',NULL,NULL,NULL,NULL,'2024-02-29 15:54:51','2024-02-29 15:54:51'),
(449,'BCHATAVIV27/120/2.5',NULL,'Loubejac','Avivé',NULL,'Châtaignier',NULL,'m2',27,120,2500,12,'Production',NULL,NULL,NULL,NULL,'2024-02-29 16:13:44','2024-03-05 10:59:23'),
(450,'BCHATAV22/140/2V',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m3',20,140,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:15:35','2024-03-12 15:06:39'),
(451,'BCHATAV22/90/2 V',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m3',22,90,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:15:56','2024-03-04 15:15:56'),
(452,'BCHATAV27/160/2.5 V',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m2',27,160,2500,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:16:15','2024-03-04 15:16:15'),
(453,'BCHATAV27/90/2 V',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m2',27,90,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:16:56','2024-03-04 15:16:56'),
(454,'BCHATAV27/90/2.5 V',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m2',27,90,2500,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:18:06','2024-03-04 15:18:06'),
(455,'BCHATAV27/TL/2.5 V',NULL,'Briolance','Avivé',NULL,'Châtaignier','Déclassé','m2',27,0,2500,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:18:25','2024-03-04 15:18:25'),
(456,'BCHATAV27S V',NULL,'Briolance','Avivé','Toutes Largeurs','Châtaignier','cf1/cf2','m3',27,0,2500,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:18:37','2024-03-04 15:18:37'),
(457,'BCHATAV34/140/2 V',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m3',34,140,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:19:09','2024-03-04 15:19:09'),
(458,'BCHATAVDEC27/130/2 V',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m3',27,130,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:19:21','2024-03-04 15:19:21'),
(459,'BCHATAVI20 V',NULL,'Briolance','Avivé','Toutes Largeurs','Châtaignier','cf1/cf2','m3',20,0,2500,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:19:35','2024-03-04 15:19:35'),
(460,'BCHATAVI20/2.5 V',NULL,'Briolance','Avivé','Toutes Largeurs','Châtaignier','cf1/cf2','m3',20,0,2500,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:19:54','2024-03-04 15:19:54'),
(461,'BCHATAVIV V',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m3',45,130,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:20:10','2024-03-04 15:20:10'),
(462,'BCHATAVIV27/120/2 V',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m2',27,120,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:20:26','2024-03-04 15:20:26'),
(463,'BCHATAVIV27/120/2.5 V',NULL,'Loubejac','Avivé',NULL,'Châtaignier',NULL,'m2',27,120,2500,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:20:37','2024-03-04 15:20:37'),
(464,'BCHATAVIV27/140/2 V',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m2',27,140,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:21:09','2024-03-04 15:21:09'),
(465,'BCHATAVIV27/140/2.5 V',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m2',27,140,2500,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:21:20','2024-03-04 15:21:20'),
(466,'BCHATAVIV27/160/2 V',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m2',27,160,2,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:21:35','2024-03-04 15:21:35'),
(467,'BCHATAVIV27/90/2 V',NULL,'Loubejac','Avivé',NULL,'Châtaignier',NULL,'m2',27,90,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:21:49','2024-03-04 15:21:49'),
(468,'BCHATAVIV27/TL/2 V',NULL,'Briolance','Avivé',NULL,'Châtaignier','Vert','m3',27,0,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:22:00','2024-03-04 15:22:00'),
(469,'BCHATAVIV27/TL/2.5 V',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m3',27,0,2500,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:22:41','2024-03-04 15:22:41'),
(470,'BCHATAVIV34 V',NULL,'Briolance','Avivé','Toutes Largeurs','Châtaignier','cf1/cf2','m3',34,0,2500,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:22:51','2024-03-04 15:22:51'),
(471,'BPEUP10/150 V',NULL,'Briolance','Volige',NULL,'Peuplier',NULL,'m2',10,150,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:23:43','2024-03-04 15:23:43'),
(472,'BPEUP20/11 V',NULL,'Briolance','Avivé',NULL,'Peuplier',NULL,'m2',20,110,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:23:56','2024-03-04 15:23:56'),
(473,'BPEUP22/95/2 V',NULL,'Loubejac','Avivé',NULL,'Peuplier',NULL,'m3',22,95,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:24:29','2024-03-04 15:24:29'),
(474,'BPEUP24/110/250 V',NULL,'Briolance','Volige',NULL,'Peuplier',NULL,'m2',24,110,2500,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:24:45','2024-03-04 15:24:45'),
(475,'BPEUP24/120/150 V',NULL,'Briolance','Volige',NULL,'Peuplier',NULL,'m2',24,120,1500,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:25:20','2024-03-04 15:25:20'),
(476,'BPEUP24/120/2 V',NULL,'Briolance','Volige',NULL,'Peuplier',NULL,'m3',24,120,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:25:31','2024-03-04 15:25:31'),
(477,'BPEUP24/120/2.5 V',NULL,'Briolance','Volige',NULL,'Peuplier',NULL,'m3',24,120,2500,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:25:56','2024-03-04 15:25:56'),
(478,'BPEUP24/180 V',NULL,'Briolance','Volige',NULL,'Peuplier',NULL,'m3',24,180,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:26:17','2024-03-04 15:26:17'),
(479,'BPEUP24/180/2.5 V',NULL,'Briolance','Volige',NULL,'Peuplier',NULL,'m3',24,180,2500,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:26:35','2024-03-04 15:26:35'),
(480,'BPEUP24TL V',NULL,'Briolance','Volige','Toutes Largeurs','Peuplier',NULL,'m3',24,0,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:26:52','2024-03-04 15:26:52'),
(481,'BPEUP24X100X2 V',NULL,'Loubejac','Avivé',NULL,'Peuplier',NULL,'m3',24,100,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:27:08','2024-03-04 15:27:08'),
(482,'BPEUP27/120/2 V',NULL,'Briolance','Avivé',NULL,'Peuplier',NULL,'m2',27,120,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:27:20','2024-03-04 15:27:20'),
(483,'BPEUP27/130/2 V',NULL,'Loubejac','Avivé',NULL,'Peuplier',NULL,'m3',27,130,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:27:31','2024-03-04 15:27:31'),
(484,'BPEUP27/130/2.5 V',NULL,'Loubejac','Avivé',NULL,'Peuplier',NULL,'m3',27,130,2500,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:27:46','2024-03-04 15:27:46'),
(485,'BPEUP27/160/2 V',NULL,'Loubejac','Avivé',NULL,'Peuplier',NULL,'m3',27,160,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:28:06','2024-03-04 15:28:06'),
(486,'BPEUP27/160/2.5 V',NULL,'Loubejac','Avivé',NULL,'Peuplier',NULL,'m3',27,160,2500,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:28:18','2024-03-04 15:28:18'),
(487,'BPEUP27/180/2 V',NULL,'Briolance','Avivé',NULL,'Peuplier',NULL,'m3',27,180,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:28:31','2024-03-04 15:28:31'),
(488,'BPEUP27/180/2.5 V',NULL,'Briolance','Avivé',NULL,'Peuplier',NULL,'m3',27,180,2500,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:37:25','2024-03-04 15:37:25'),
(489,'BPEUP27/TL/2 V',NULL,'Briolance','Avivé',NULL,'Peuplier',NULL,'m3',27,0,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:37:46','2024-03-04 15:37:46'),
(490,'BPEUP27TL V',NULL,'Loubejac','Avivé',NULL,'Peuplier','Toute largeur','m3',27,0,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:37:59','2024-03-04 15:37:59'),
(491,'BPEUP27x95x2 V',NULL,'Loubejac','Avivé',NULL,'Peuplier',NULL,'m3',27,0,2000,100,'Production',NULL,NULL,NULL,NULL,'2024-03-04 15:38:13','2024-03-04 15:38:13'),
(492,'BCHATAVIV27/90/2.50',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m2',27,90,2500,12,'Production',NULL,NULL,NULL,NULL,'2024-03-05 10:58:21','2024-03-05 10:58:21'),
(493,'BCHATAVIV27/90/2.50 V',NULL,'Briolance','Avivé',NULL,'Châtaignier',NULL,'m2',27,90,2500,100,'Production',NULL,NULL,NULL,NULL,'2024-03-05 10:58:43','2024-03-05 10:58:43'),
(494,'PANC10C',NULL,'Loubejac','Parquet','a clouer','Châtaignier','C','m2',23,100,0,12,'Production',NULL,NULL,NULL,'P4','2024-03-06 14:01:59','2024-03-07 10:26:52'),
(495,'PTR70ROMP',NULL,'Loubejac','Parquet','Bâtons rompus','Châtaignier','AB Brut','m2',23,70,450,12,'Negoce',NULL,NULL,NULL,'P4','2024-03-06 14:22:43','2024-03-07 10:27:54'),
(496,'PANC10ROMP',NULL,'Loubejac','Parquet','Bâtons rompus','Châtaignier','AB Brut','m2',23,100,450,12,'Negoce',NULL,NULL,NULL,'P4','2024-03-06 14:24:09','2024-03-07 10:28:09'),
(497,'PANC10PH',NULL,'Loubejac','Parquet','Point de Hongrie','Châtaignier','AB Brut','m2',23,100,600,12,'Negoce',NULL,NULL,NULL,'P4','2024-03-06 14:25:25','2024-03-07 10:28:24'),
(498,'PANC17/22',NULL,'Loubejac','Parquet','A clouer','Châtaignier','AB','m2',22,170,0,12,'Production',NULL,NULL,NULL,'P4','2024-03-06 15:06:05','2024-03-07 10:31:48'),
(499,'PRES100RUSGL',NULL,'Loubejac','Parquet','A clouer','Châtaignier','Rustique - 2 faces-Grandes longueurs','m2',23,100,0,12,'Production',NULL,NULL,NULL,'P4','2024-03-06 15:10:13','2024-03-07 10:32:18'),
(500,'PRES120RUSGL',NULL,'Loubejac','Parquet','A clouer','Châtaignier','Rustique - 2 faces-Grandes longueurs','m2',23,120,0,12,'Production',NULL,NULL,NULL,'P4','2024-03-06 15:11:48','2024-03-07 10:32:35'),
(501,'PRES140RUSGL',NULL,'Loubejac','Parquet','A clouer','Châtaignier','Rustique - 2 faces-Grandes longueurs','m2',23,140,0,12,'Production',NULL,NULL,NULL,'P4','2024-03-06 15:18:25','2024-03-07 10:32:49'),
(502,'PANC12AB',NULL,'Loubejac','Parquet','A clouer','Châtaignier','AB','m2',23,120,0,12,'Production',NULL,NULL,NULL,'P4','2024-03-06 15:28:21','2024-03-07 10:26:14'),
(503,'PANC12H',NULL,'Loubejac','Parquet','A clouer','Châtaignier','AB Huilé','m2',23,120,0,12,'Production',NULL,NULL,NULL,'P4','2024-03-06 15:30:08','2024-03-07 10:27:14'),
(504,'PANC17/20',NULL,'Loubejac','Parquet','a clouer','Châtaignier','Pré-huilé- ABC','m2',20,170,0,12,'Production',NULL,NULL,NULL,'P4','2024-03-06 15:35:19','2024-03-07 10:33:04'),
(505,'PANC15AB',NULL,'Loubejac','Parquet','A clouer','Châtaignier','AB','m2',27,150,0,12,'Production',NULL,NULL,NULL,'P4','2024-03-06 15:55:23','2024-03-07 10:33:19'),
(506,'PANC15RUS',NULL,'Loubejac','Parquet','A clouer','Châtaignier','Rustique','m2',27,150,0,12,'Production',NULL,NULL,NULL,'P4','2024-03-06 15:56:08','2024-03-07 10:33:31'),
(507,'PRES150AB',NULL,'Loubejac','Parquet','A clouer','Châtaignier','AB -2 faces','m2',27,150,0,12,'Production',NULL,NULL,NULL,'P4','2024-03-06 15:58:16','2024-03-07 10:33:43'),
(508,'PRES150RUS',NULL,'Loubejac','Parquet','A clouer','Châtaignier','Rustique -2 faces','m2',27,150,0,12,'Production',NULL,NULL,NULL,'P4','2024-03-06 15:59:01','2024-03-07 10:33:54'),
(509,'REV9RUS',NULL,'Loubejac','Parquet','A coller','Châtaignier','Rustique','m2',15,90,0,12,'Production',NULL,NULL,NULL,'P5','2024-03-06 16:20:04','2024-03-07 10:35:04'),
(510,'REV9ECOP',NULL,'Loubejac','Parquet','A coller','Châtaignier','Eco poncé','m2',15,90,0,12,'Production',NULL,NULL,NULL,'P5','2024-03-06 16:21:23','2024-03-07 10:35:40'),
(511,'REV7ECOP',NULL,'Loubejac','Parquet','A coller','Châtaignier','Eco poncé','m2',14,70,0,12,'Production',NULL,NULL,NULL,'P5','2024-03-06 16:23:50','2024-03-07 10:35:28'),
(512,'REV12RUS',NULL,'Loubejac','Revêtement','A coller GO2','Châtaignier','Rustique','m2',14,120,0,12,'Production',NULL,NULL,NULL,'P5','2024-03-07 07:36:31','2024-03-07 10:35:14'),
(513,'REV12ECOP',NULL,'Loubejac','Revêtement','A coller GO2','Châtaignier','ECO -Poncé','m2',14,120,0,12,'Production',NULL,NULL,NULL,'P5','2024-03-07 07:37:53','2024-03-07 10:35:49'),
(514,'REV12ABGO2HUIL',NULL,'Loubejac','Revêtement','A coller GO2','Châtaignier','AB Huilé','m2',14,120,0,12,'Production',NULL,NULL,NULL,'P5','2024-03-07 07:41:09','2024-03-07 10:36:21'),
(515,'REV14ABVS',NULL,'Loubejac','Revêtement','A coller verni naturel satiné','Châtaignier','AB','m2',11,140,0,12,'Production',NULL,NULL,NULL,'P5','2024-03-07 09:21:03','2024-03-07 10:37:29'),
(516,'PCHENE9PR',NULL,'Loubejac','Parquet','A clouer','Chêne','PR Bords droits','m2',23,90,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 09:52:33','2024-03-07 10:06:41'),
(517,'PCHENE9RU',NULL,'Loubejac','Parquet','A clouer','Chêne','RU Bords droits','m2',23,90,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 09:53:48','2024-03-07 10:08:39'),
(518,'PCHENE9GO2C',NULL,'Loubejac','Parquet','A clouer GO2','Chêne','Campagne','m2',23,90,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 09:56:19','2024-03-07 10:09:00'),
(519,'PCHENE14PR',NULL,'Loubejac','Parquet','A clouer','Chêne','PR Bords droits','m2',23,140,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 09:57:06','2024-03-07 10:07:22'),
(520,'PCHENE16PR',NULL,'Loubejac','Parquet','A clouer','Chêne','PR Bords droits','m2',23,160,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 09:57:23','2024-03-07 10:07:36'),
(521,'PCHENE18PR',NULL,'Loubejac','Parquet','A clouer','Chêne','PR Bords droits','m2',23,180,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 09:57:40','2024-03-07 10:07:46'),
(522,'PCHENE14RU',NULL,'Loubejac','Parquet','A clouer','Chêne','RU Bords droits','m2',23,140,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 09:58:13','2024-03-07 10:08:23'),
(523,'PCHENE16RU',NULL,'Loubejac','Parquet','A clouer','Chêne','RU Bords droits','m2',23,160,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 10:00:29','2024-03-07 10:08:12'),
(524,'PCHENE18RU',NULL,'Loubejac','Parquet','A clouer','Chêne','RU Bords droits','m2',23,180,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 10:00:56','2024-03-07 10:08:01'),
(525,'PCHENE14GO2C',NULL,'Loubejac','Parquet','A clouer GO2','Chêne','Campagne','m2',23,140,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 10:01:29','2024-03-07 10:09:11'),
(526,'PCHENE16GO2C',NULL,'Loubejac','Parquet','A clouer GO2','Chêne','Campagne','m2',23,160,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 10:02:30','2024-03-07 10:09:21'),
(527,'PCHENE18GO2C',NULL,'Loubejac','Parquet','A clouer GO2','Chêne','Campagne','m2',23,180,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 10:02:52','2024-03-07 10:09:30'),
(528,'PCHENE9PRGO2',NULL,'Loubejac','Parquet','A clouer GO2','Chêne','PR Verni mat ou sat','m2',23,90,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 10:42:52','2024-03-07 10:43:02'),
(529,'PCHENE14PRGO2',NULL,'Loubejac','Parquet','A clouer GO2','Chêne','PR Verni mat ou sat','m2',23,140,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 10:43:31','2024-03-07 10:43:47'),
(530,'PCHENE18PRGO2',NULL,'Loubejac','Parquet','A clouer GO2','Chêne','PR Verni mat ou sat','m2',23,180,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 10:44:12','2024-03-07 10:44:22'),
(531,'PCHENE18CGO2',NULL,'Loubejac','Parquet','A clouer GO2','Chêne','Campagne Verni mat ou sat','m2',23,180,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 10:45:15','2024-03-07 10:45:26'),
(532,'PCHENE14CGO2',NULL,'Loubejac','Parquet','A clouer GO2','Chêne','Campagne Verni mat ou sat','m2',23,140,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 10:46:18','2024-03-07 10:46:30'),
(533,'PCHENE9CGO2',NULL,'Loubejac','Parquet','A clouer GO2','Chêne','Campagne Verni mat ou sat','m2',23,90,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 10:46:45','2024-03-07 10:47:00'),
(534,'PCHENE9ABBD',NULL,'Loubejac','Parquet','A clouer-Bords droits','Chêne','AB','m2',22,90,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 10:58:11','2024-03-07 10:58:26'),
(535,'PCHENE9AB2F',NULL,'Loubejac','Parquet','A clouer-Bords droits','Chêne','AB -2 faces','m2',22,90,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 10:59:26','2024-03-07 11:00:41'),
(536,'PCHENE10/140CC',NULL,'Loubejac','Parquet','A clouer','Chêne','Brossé verni - contrecollé','m2',10,140,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 13:00:04','2024-03-07 13:00:23'),
(537,'PCHENE15/160CC',NULL,'Loubejac','Parquet','A clouer','Chêne','Brossé verni - contrecollé','m2',15,160,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 13:01:54','2024-03-07 13:02:17'),
(538,'PCHENE20/200CC',NULL,'Loubejac','Parquet','A clouer','Chêne','Brossé verni - contrecollé','m2',20,200,0,12,'Production',NULL,NULL,NULL,'P6','2024-03-07 13:02:58','2024-03-07 13:03:08'),
(539,'RECCHENE9PR',NULL,'Loubejac','Parquet','A coller-bords droits','Chêne','PR','m2',14,90,0,12,'Production',NULL,NULL,NULL,'P7','2024-03-07 13:27:44','2024-03-07 13:33:09'),
(540,'RECCHENE9RU',NULL,'Loubejac','Parquet','A coller- bords droits','Chêne','RU','m2',14,90,0,12,'Production',NULL,NULL,NULL,'P7','2024-03-07 13:32:22','2024-03-07 13:32:33'),
(541,'RECCHENE11PR',NULL,'Loubejac','Parquet','A coller-bords droits','Chêne','PR','m2',14,110,0,12,'Production',NULL,NULL,NULL,'P7','2024-03-07 13:33:40','2024-03-07 13:33:53'),
(542,'RECCHENE13PR',NULL,'Loubejac','Parquet','A coller-bords droits','Chêne','PR','m2',14,130,0,12,'Production',NULL,NULL,NULL,'P7','2024-03-07 13:34:23','2024-03-07 13:34:36'),
(543,'RECCHENE11RU',NULL,'Loubejac','Parquet','A coller- bords droits','Chêne','RU','m2',14,110,0,12,'Production',NULL,NULL,NULL,NULL,'2024-03-07 13:36:17','2024-03-07 13:36:17'),
(544,'RECCHENE13RU',NULL,'Loubejac','Parquet','A coller- bords droits','Chêne','RU','m2',14,130,0,12,'Production',NULL,NULL,NULL,'P7','2024-03-07 13:36:51','2024-03-07 13:36:59'),
(545,'RECCHENE11GO2C',NULL,'Loubejac','Parquet','A coller GO2','Chêne','Campagne','m2',14,110,0,12,'Production',NULL,NULL,NULL,'P7','2024-03-07 13:39:29','2024-03-07 13:39:43'),
(546,'RECCHENE13GO2C',NULL,'Loubejac','Parquet','A coller GO2','Chêne','Campagne','m2',14,130,0,12,'Production',NULL,NULL,NULL,'P7','2024-03-07 13:40:22','2024-03-07 13:40:31'),
(548,'RECCHENE13GO2PRV',NULL,'Loubejac','Parquet','A coller GO2','Chêne','PR Verni','m2',14,130,0,12,'Production',NULL,NULL,NULL,'P7','2024-03-07 13:42:35','2024-03-07 13:42:43'),
(550,'RECCHENE13GO2CV',NULL,'Loubejac','Parquet','A coller GO2','Chêne','Campagne','m2',14,130,0,12,'Production',NULL,NULL,NULL,'P7','2024-03-07 13:44:40','2024-03-07 13:44:51'),
(551,'RECCHENE9GO4AB',NULL,'Loubejac','Parquet','A coller-GO4','Chêne','AB','m2',14,90,0,12,'Production',NULL,NULL,NULL,'P7','2024-03-07 15:18:55','2024-03-07 15:20:04'),
(552,'RECCHENE11GO4ABC',NULL,'Loubejac','Parquet','A coller-GO4','Chêne','AB','m2',14,110,0,12,'Production',NULL,NULL,NULL,'P7','2024-03-07 15:20:39','2024-03-07 15:32:53'),
(553,'RECCHENE13GO4ABC',NULL,'Loubejac','Parquet','A coller-GO4','Chêne','AB','m2',14,130,0,12,'Production',NULL,NULL,NULL,'P7','2024-03-07 15:21:04','2024-03-07 15:33:27'),
(554,'RECCHENE9GO4ABH',NULL,'Loubejac','Parquet','A coller-GO4','Chêne','AB Huilé','m2',14,90,0,12,'Production',NULL,NULL,NULL,'P7','2024-03-07 15:22:28','2024-03-07 15:22:41'),
(555,'RECCHENE11GO4ABCH',NULL,'Loubejac','Parquet','A coller-GO4','Chêne','AB Huilé','m2',14,110,0,12,'Production',NULL,NULL,NULL,'P7','2024-03-07 15:23:36','2024-03-07 15:23:55'),
(556,'RECCHENE13GO4ABCH',NULL,'Loubejac','Parquet','A coller-GO4','Chêne','AB Huilé','m2',14,130,0,12,'Production',NULL,NULL,NULL,'P7','2024-03-07 15:24:26','2024-03-07 15:24:47'),
(557,'PANCPEUP160ABL',NULL,'Loubejac','Parquet','A clouer','Peuplier','AB Lemance -2 faces','m2',23,160,0,12,'Production',NULL,NULL,NULL,'P7','2024-03-07 15:51:48','2024-03-07 15:52:01'),
(559,'RECCPIN14SN2F',NULL,'Loubejac','Parquet','A clouer','Pin Maritime','Sans noeud Mezzanine, 2faces','m2',23,140,2000,12,'Negoce',NULL,NULL,NULL,'P8','2024-03-07 16:28:24','2024-03-08 09:32:02'),
(560,'RECCPIN17V',NULL,'Loubejac','Parquet','A clouer GO4','Pin Maritime','Noueux- Pré Huilé','m2',20,170,0,12,'Negoce',NULL,NULL,NULL,'P8','2024-03-08 09:36:11','2024-03-08 09:37:20'),
(561,'REVPIN11GO4',NULL,'Loubejac','Parquet','A coller GO4','Pin Maritime','ABC','m2',14,110,0,12,'Negoce',NULL,NULL,NULL,'P8','2024-03-08 09:50:14','2024-03-08 09:52:28'),
(562,'REVPIN11GO4H',NULL,'Loubejac','Parquet','A coller GO4','Pin Maritime','ABC Pré huilé','m2',14,110,0,12,'Negoce',NULL,NULL,NULL,'P8','2024-03-08 09:52:15','2024-03-08 09:52:36'),
(563,'RECCROB14PR',NULL,'Loubejac','Parquet','A clouer','Robinier','PR','m2',14,90,0,12,'Negoce',NULL,NULL,NULL,'P8','2024-03-08 13:35:12','2024-03-08 13:35:35'),
(564,'RECCROB23PR',NULL,'Loubejac','Parquet','A clouer','Robinier','PR','m2',23,90,0,12,'Negoce',NULL,NULL,NULL,'P8','2024-03-08 13:36:40','2024-03-08 13:36:53'),
(565,'RECCDOUG16AB',NULL,'Loubejac','Parquet','A clouer','Douglas','AB','m2',23,160,0,12,'Negoce',NULL,NULL,NULL,'P8','2024-03-08 13:37:54','2024-03-08 13:38:17'),
(566,'RECCMER11AB',NULL,'Loubejac','Parquet','AB','Merisier','AB','m2',22,110,0,12,'Negoce',NULL,NULL,NULL,'P8','2024-03-08 13:39:41','2024-03-08 13:39:58'),
(567,'REVACACIA',NULL,'Loubejac','Parquet','A coller','Acacia','Huilé','m2',9,68,0,12,'Negoce',NULL,NULL,NULL,'P8','2024-03-08 13:41:55','2024-03-08 13:42:10'),
(568,'KTPOSE',NULL,'Loubejac','Kit de Pose','pour 5m2 de parquet','--N/A--',NULL,'Pièce',0,0,0,0,'Negoce',NULL,NULL,NULL,'P8','2024-03-08 13:44:13','2024-03-08 13:44:29'),
(569,'PLACACIA',NULL,'Loubejac','Plinthe','A coller','Acacia','Brute','ml',10,70,0,12,'Negoce',NULL,NULL,NULL,'P8','2024-03-08 13:50:13','2024-03-08 13:51:29'),
(570,'RECCFRENEPRGO2',NULL,'Loubejac','Parquet','A clouer GO2','Frêne','PR','m2',23,120,0,12,'Negoce',NULL,NULL,NULL,'P8','2024-03-08 13:53:49','2024-03-08 13:55:51'),
(571,'RECCFRENEOLGO2',NULL,'Loubejac','Parquet','A coller GO2','Frêne','PR','m2',23,120,0,12,'Negoce',NULL,NULL,NULL,'P8','2024-03-08 13:57:37','2024-03-08 13:57:50'),
(572,'RECCHETRE11AB',NULL,'Loubejac','Parquet','A clouer','Hêtre','AB','m2',22,110,0,12,'Negoce',NULL,NULL,NULL,'P8','2024-03-08 14:20:01','2024-03-08 14:20:15'),
(573,'RECCHETRE13AB',NULL,'Loubejac','Parquet','A clouer','Hêtre','AB','m2',22,130,0,12,'Negoce',NULL,NULL,NULL,'P8','2024-03-08 14:21:01','2024-03-08 14:21:12');

--
-- Table structure for table `stocks`
--

CREATE TABLE `stocks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `date_mouvement` date NOT NULL DEFAULT current_timestamp(),
  `produit_id` bigint(20) unsigned NOT NULL,
  `colis_id` bigint(20) unsigned DEFAULT NULL,
  `nombre_colis` int(11) DEFAULT NULL,
  `unite` varchar(255) NOT NULL,
  `quantite` decimal(8,3) NOT NULL,
  `motif` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=134 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stocks`
--

INSERT INTO `stocks` VALUES
(5,'2024-01-02',130,NULL,NULL,'Pièce',-18.000,'Vente PASSERI','2024-01-03 10:40:27','2024-01-03 10:40:27'),
(7,'2024-01-03',100,NULL,NULL,'Pièce',-20.000,'Vente GRASSINEAU','2024-01-03 10:43:27','2024-01-03 10:43:27'),
(8,'2024-01-03',9,NULL,NULL,'ml',-36.000,'Vente GRASSINEAU','2024-01-03 11:03:28','2024-01-03 11:03:28'),
(9,'2024-01-03',155,NULL,NULL,'m2',59.090,'Entrée Usine','2024-01-03 11:11:28','2024-01-03 11:11:28'),
(11,'2024-01-03',39,NULL,NULL,'m2',-0.770,'Vente GRASSINEAU','2024-01-03 12:53:16','2024-01-03 12:53:16'),
(16,'2024-01-08',173,NULL,NULL,'Palette',1.000,'Production du 08/01/2024','2024-01-22 15:06:20','2024-01-22 15:06:20'),
(17,'2024-01-08',181,NULL,NULL,'Palette',1.000,'Production du 08/01/2024','2024-01-22 15:12:19','2024-01-22 15:12:19'),
(20,'2024-01-08',239,NULL,NULL,'Palette',1.000,'Production du 08/01/2024','2024-01-22 15:41:40','2024-01-22 15:41:40'),
(21,'2024-01-08',240,NULL,NULL,'Palette',1.000,'Production du 08/01/2024','2024-01-22 15:42:11','2024-01-22 15:42:11'),
(22,'2024-01-08',241,NULL,NULL,'Palette',1.000,'Production du 08/01/2024','2024-01-22 15:42:37','2024-01-22 15:42:37'),
(23,'2024-01-08',242,NULL,NULL,'Palette',1.000,'Production du 08/01/2024','2024-01-22 15:43:24','2024-01-22 15:43:24'),
(28,'2024-01-03',180,NULL,NULL,'Palette',3.000,'Production du 03/01/2024','2024-01-22 16:32:49','2024-01-22 16:32:49'),
(29,'2024-01-03',173,NULL,NULL,'Palette',2.000,'Production du 03/01/2024','2024-01-22 16:33:39','2024-01-22 16:33:39'),
(30,'2024-01-03',181,NULL,NULL,'Palette',2.000,'Production du 03/01/2024','2024-01-22 16:34:28','2024-01-22 16:34:28'),
(32,'2024-01-17',239,NULL,NULL,'Palette',1.000,'Production du 17/01/2024','2024-01-23 20:25:20','2024-01-23 20:25:20'),
(34,'2024-01-17',1,NULL,NULL,'Palette',1.000,'Production du 17/01/2024','2024-01-23 20:31:11','2024-01-23 20:31:11'),
(45,'2024-01-02',411,NULL,NULL,'Palette',3.000,'Production du 2024-01-02','2024-02-29 14:04:14','2024-02-29 14:04:14'),
(46,'2024-01-02',412,NULL,NULL,'Palette',1.000,'Production du 2024-01-02','2024-02-29 14:05:48','2024-02-29 14:05:48'),
(47,'2024-01-02',328,NULL,NULL,'Palette',1.000,'Production du 2024-01-02','2024-02-29 14:07:19','2024-02-29 14:07:19'),
(48,'2024-01-02',442,NULL,NULL,'Palette',1.000,'Production du 2024-01-02','2024-02-29 14:49:43','2024-02-29 14:49:43'),
(49,'2024-01-02',180,NULL,NULL,'Palette',1.000,'Production du 2024-01-02','2024-02-29 14:53:07','2024-02-29 14:53:07'),
(50,'2024-01-08',407,NULL,NULL,'Palette',-4.000,'Vente Client ','2024-02-29 15:09:16','2024-02-29 15:09:16'),
(51,'2024-01-02',444,NULL,NULL,'Palette',-3.000,'Vente Client ','2024-02-29 15:18:10','2024-02-29 15:18:10'),
(52,'2024-01-02',443,NULL,NULL,'Palette',-4.000,'Vente Client ','2024-02-29 15:18:54','2024-02-29 15:18:54'),
(53,'2024-01-02',442,NULL,NULL,'Palette',-5.000,'Vente Client ','2024-02-29 15:19:45','2024-02-29 15:19:45'),
(54,'2024-01-02',443,NULL,NULL,'Palette',-14.000,'Vente Client ','2024-02-29 15:20:19','2024-02-29 15:20:19'),
(55,'2024-01-02',1,NULL,NULL,'Palette',-2.000,'Vente Client ','2024-02-29 15:20:35','2024-02-29 15:20:35'),
(56,'2024-01-03',442,NULL,NULL,'Palette',-5.000,'Vente Client ','2024-02-29 15:22:40','2024-02-29 15:22:40'),
(57,'2024-01-03',445,NULL,NULL,'Palette',-3.000,'Vente Client ','2024-02-29 15:25:10','2024-02-29 15:25:10'),
(59,'2024-01-16',242,NULL,NULL,'Palette',1.000,'Production du 2024-01-16','2024-02-29 15:36:17','2024-02-29 15:36:17'),
(60,'2024-01-16',411,NULL,NULL,'Palette',1.000,'Production du 2024-01-16','2024-02-29 15:37:48','2024-02-29 15:37:48'),
(61,'2024-01-17',310,NULL,NULL,'Palette',1.000,'Production du 2024-01-17','2024-02-29 15:39:14','2024-02-29 15:39:14'),
(62,'2024-01-17',446,NULL,NULL,'Palette',2.000,'Production du 2024-01-17','2024-02-29 15:48:14','2024-02-29 15:48:14'),
(63,'2024-01-17',447,NULL,NULL,'Palette',1.000,'Production du 2024-01-17','2024-02-29 15:53:09','2024-02-29 15:53:09'),
(64,'2024-01-17',448,NULL,NULL,'Palette',2.000,'Production du 2024-01-17','2024-02-29 15:55:39','2024-02-29 15:55:39'),
(65,'2024-01-17',445,NULL,NULL,'Palette',1.000,'Production du 2024-01-17','2024-02-29 15:56:22','2024-02-29 15:56:22'),
(69,'2024-01-22',77,NULL,NULL,'Rouleau',9.000,'Production du 2024-01-22','2024-03-05 09:55:46','2024-03-05 09:55:46'),
(71,'2024-03-04',468,NULL,NULL,'Palette',1.000,'Production du 2024-03-04','2024-03-05 10:10:24','2024-03-05 10:10:24'),
(78,'2024-03-08',470,NULL,NULL,'Palette',1.000,'Production du 2024-03-08','2024-03-08 16:48:06','2024-03-08 16:48:06'),
(79,'2024-03-08',159,NULL,NULL,'Palette',1.000,'Production du 2024-03-08','2024-03-08 16:49:08','2024-03-08 16:49:08'),
(81,'2024-03-07',454,NULL,NULL,'Palette',1.000,'Production du 2024-03-07','2024-03-08 17:00:47','2024-03-08 17:00:47'),
(82,'2024-03-07',470,NULL,NULL,'Palette',1.000,'Production du 2024-03-07','2024-03-08 17:09:32','2024-03-08 17:09:32'),
(83,'2024-03-07',465,NULL,NULL,'Palette',1.000,'Production du 2024-03-07','2024-03-08 17:10:53','2024-03-08 17:10:53'),
(86,'2024-03-06',239,NULL,NULL,'Palette',3.000,'Production du 2024-03-06','2024-03-08 17:35:02','2024-03-08 17:35:02'),
(87,'2024-03-06',241,NULL,NULL,'Palette',2.000,'Production du 2024-03-06','2024-03-08 17:36:31','2024-03-08 17:36:31'),
(88,'2024-03-06',240,NULL,NULL,'Palette',2.000,'Production du 2024-03-06','2024-03-08 17:37:46','2024-03-08 17:37:46'),
(89,'2024-03-06',468,NULL,NULL,'Palette',1.000,'Production du 2024-03-06','2024-03-08 17:40:46','2024-03-08 17:40:46'),
(90,'2024-03-05',160,NULL,NULL,'Palette',1.000,'Transfert Castagné','2024-03-08 17:48:08','2024-03-08 17:48:08'),
(91,'2024-03-05',240,NULL,NULL,'Palette',1.000,'Production du 2024-03-05','2024-03-08 17:52:32','2024-03-08 17:52:32'),
(92,'2024-03-05',241,NULL,NULL,'Palette',1.000,'Production du 2024-03-05','2024-03-08 17:53:06','2024-03-08 17:53:06'),
(93,'2024-03-04',239,NULL,NULL,'Palette',2.000,'Production du 2024-03-04','2024-03-08 17:57:49','2024-03-08 17:57:49'),
(94,'2024-03-04',240,NULL,NULL,'Palette',2.000,'Production du 2024-03-04','2024-03-08 17:59:36','2024-03-08 17:59:36'),
(95,'2024-03-04',241,NULL,NULL,'Palette',2.000,'Production du 2024-03-04','2024-03-08 18:00:24','2024-03-08 18:00:24'),
(96,'2024-03-01',239,NULL,NULL,'Palette',2.000,'Production du 2024-03-01','2024-03-08 18:00:58','2024-03-08 18:00:58'),
(97,'2024-03-01',241,NULL,NULL,'Palette',1.000,'Production du 2024-03-01','2024-03-08 18:01:42','2024-03-08 18:01:42'),
(98,'2024-03-01',240,NULL,NULL,'Palette',1.000,'Production du 2024-03-01','2024-03-08 18:03:41','2024-03-08 18:03:41'),
(99,'2024-02-29',239,NULL,NULL,'Palette',1.000,'Production du 2024-02-29','2024-03-08 18:08:45','2024-03-08 18:08:45'),
(100,'2024-02-29',241,NULL,NULL,'Palette',2.000,'Production du 2024-02-29','2024-03-08 18:09:10','2024-03-08 18:09:10'),
(101,'2024-02-29',240,NULL,NULL,'Palette',2.000,'Production du 2024-02-29','2024-03-08 18:09:32','2024-03-08 18:09:32'),
(102,'2024-02-28',239,NULL,NULL,'Palette',2.000,'Production du 2024-02-28','2024-03-08 18:15:53','2024-03-08 18:15:53'),
(103,'2024-02-28',240,NULL,NULL,'Palette',1.000,'Production du 2024-02-28','2024-03-08 18:16:10','2024-03-08 18:16:10'),
(104,'2024-02-22',386,NULL,NULL,'Palette',1.000,'Production du 2024-02-22','2024-03-08 18:19:34','2024-03-08 18:19:34'),
(105,'2024-02-22',468,NULL,NULL,'Palette',2.000,'Production du 2024-02-22','2024-03-08 18:21:10','2024-03-08 18:21:10'),
(106,'2024-02-22',241,NULL,NULL,'Palette',2.000,'Production du 2024-02-22','2024-03-08 18:21:42','2024-03-08 18:21:42'),
(107,'2024-02-22',239,NULL,NULL,'Palette',1.000,'Production du 2024-02-22','2024-03-08 18:22:05','2024-03-08 18:22:05'),
(108,'2024-02-22',240,NULL,NULL,'Palette',2.000,'Production du 2024-02-22','2024-03-08 18:22:29','2024-03-08 18:22:29'),
(109,'2024-02-23',239,NULL,NULL,'Palette',1.000,'Production du 2024-02-23','2024-03-08 18:26:43','2024-03-08 18:26:43'),
(110,'2024-02-23',240,NULL,NULL,'Palette',1.000,'Production du 2024-02-23','2024-03-08 18:27:00','2024-03-08 18:27:00'),
(111,'2024-02-23',241,NULL,NULL,'Palette',1.000,'Production du 2024-02-23','2024-03-08 18:27:16','2024-03-08 18:27:16'),
(112,'2024-02-21',1,NULL,NULL,'Palette',2.000,'Production du 2024-02-21','2024-03-08 18:28:50','2024-03-08 18:28:50'),
(113,'2024-02-21',239,NULL,NULL,'Palette',2.000,'Production du 2024-02-21','2024-03-08 18:29:06','2024-03-08 18:29:06'),
(114,'2024-02-21',240,NULL,NULL,'Palette',2.000,'Production du 2024-02-21','2024-03-08 18:29:31','2024-03-08 18:29:31'),
(115,'2024-02-21',241,NULL,NULL,'Palette',1.000,'Production du 2024-02-21','2024-03-08 18:29:53','2024-03-08 18:29:53'),
(116,'2024-02-20',239,NULL,NULL,'Palette',8.000,'Transfert Castagné','2024-03-08 18:31:48','2024-03-08 18:31:48'),
(117,'2024-02-20',1,NULL,NULL,'Palette',1.000,'Production du 2024-02-20','2024-03-08 18:32:25','2024-03-08 18:32:25'),
(118,'2024-02-20',240,NULL,NULL,'Palette',2.000,'Production du 2024-02-20','2024-03-08 18:33:08','2024-03-08 18:33:08'),
(119,'2024-02-20',241,NULL,NULL,'Palette',1.000,'Production du 2024-02-20','2024-03-08 18:33:41','2024-03-08 18:33:41'),
(120,'2024-02-19',321,NULL,NULL,'Palette',1.000,'Autres','2024-03-09 08:49:30','2024-03-09 08:49:30'),
(121,'2024-02-19',159,NULL,NULL,'Palette',1.000,'Autres','2024-03-09 08:50:05','2024-03-09 08:50:05'),
(122,'2024-02-19',464,NULL,NULL,'Palette',3.000,'Autres','2024-03-09 08:59:50','2024-03-09 08:59:50'),
(124,'2024-02-19',464,NULL,NULL,'Palette',3.000,'Autres','2024-03-09 09:01:54','2024-03-09 09:01:54'),
(125,'2024-02-19',239,NULL,NULL,'Palette',1.000,'Autres','2024-03-09 09:05:12','2024-03-09 09:05:12'),
(126,'2024-02-19',468,NULL,NULL,'Palette',1.000,'Production du 2024-02-19','2024-03-09 09:10:53','2024-03-09 09:10:53'),
(127,'2024-02-19',239,NULL,NULL,'Palette',1.000,'Production du 2024-02-19','2024-03-09 09:11:15','2024-03-09 09:11:15'),
(128,'2024-02-19',240,NULL,NULL,'Palette',2.000,'Production du 2024-02-19','2024-03-09 09:11:41','2024-03-09 09:11:41'),
(129,'2024-02-19',241,NULL,NULL,'Palette',2.000,'Production du 2024-02-19','2024-03-09 09:11:59','2024-03-09 09:11:59'),
(130,'2024-01-10',440,NULL,NULL,'m3',40.000,'Autres','2024-03-09 16:18:58','2024-03-09 16:18:58'),
(131,'2024-01-11',241,NULL,NULL,'Palette',1.000,'Production du 2024-01-11','2024-03-09 16:23:12','2024-03-09 16:23:12'),
(132,'2024-01-15',468,NULL,NULL,'Palette',1.000,'Production du 2024-01-15','2024-03-09 16:33:04','2024-03-09 16:33:04'),
(133,'2024-01-15',446,NULL,NULL,'Palette',1.000,'Production du 2024-01-15','2024-03-09 16:33:50','2024-03-09 16:33:50');

--
-- Table structure for table `tarifs`
--

CREATE TABLE `tarifs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `date_debut` date NOT NULL DEFAULT current_timestamp(),
  `date_fin` date NOT NULL DEFAULT current_timestamp(),
  `produit_id` bigint(20) unsigned NOT NULL,
  `prix_revient` decimal(8,3) NOT NULL,
  `prix_negociant` decimal(8,3) NOT NULL DEFAULT 0.000,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=155 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tarifs`
--

INSERT INTO `tarifs` VALUES
(12,'2023-12-31','2024-06-30',104,40.600,28.420,'2024-03-06 13:39:20','2024-03-08 12:42:37'),
(13,'2023-12-31','2024-06-30',56,23.280,33.250,'2024-03-06 13:41:10','2024-03-08 09:56:21'),
(14,'2023-12-31','2024-06-30',58,19.460,27.800,'2024-03-06 13:44:05','2024-03-08 09:56:55'),
(16,'2023-12-31','2024-06-30',59,15.190,21.700,'2024-03-06 13:47:19','2024-03-08 10:00:26'),
(17,'2023-12-31','2024-06-30',57,21.630,30.900,'2024-03-06 13:47:41','2024-03-08 09:58:10'),
(19,'2023-12-31','2024-06-30',494,20.400,29.150,'2024-03-06 14:03:52','2024-03-08 10:00:55'),
(20,'2023-12-31','2024-06-30',388,41.230,58.900,'2024-03-06 14:10:56','2024-03-08 10:02:37'),
(21,'2023-12-31','2024-06-30',495,36.400,52.000,'2024-03-06 14:26:40','2024-03-08 10:05:12'),
(22,'2023-12-31','2024-06-30',496,55.410,79.150,'2024-03-06 14:27:35','2024-03-08 10:06:35'),
(23,'2023-12-31','2024-06-30',497,63.770,91.100,'2024-03-06 14:27:58','2024-03-08 10:09:42'),
(25,'2023-12-31','2024-06-30',50,31.920,45.600,'2024-03-06 14:38:18','2024-03-08 10:14:53'),
(26,'2023-12-31','2024-06-30',48,25.310,36.150,'2024-03-06 14:39:34','2024-03-08 10:15:44'),
(27,'2023-12-31','2024-06-30',52,27.440,39.200,'2024-03-06 14:40:26','2024-03-08 10:16:01'),
(29,'2023-12-31','2024-06-30',403,25.830,36.900,'2024-03-06 14:53:34','2024-03-08 09:58:40'),
(35,'2023-12-31','2024-06-30',499,28.280,40.400,'2024-03-06 15:19:58','2024-03-08 12:48:07'),
(36,'2023-12-31','2024-06-30',500,30.980,44.250,'2024-03-06 15:20:52','2024-03-08 12:49:30'),
(37,'2023-12-31','2024-06-30',501,36.020,51.450,'2024-03-06 15:21:46','2024-03-08 12:49:51'),
(38,'2023-12-31','2024-06-30',502,27.650,39.500,'2024-03-06 15:31:34','2024-03-08 09:59:50'),
(39,'2023-12-31','2024-06-30',370,22.540,32.200,'2024-03-06 15:32:20','2024-03-08 10:01:59'),
(40,'2023-12-31','2024-06-30',503,45.150,64.500,'2024-03-06 15:33:01','2024-03-08 10:03:29'),
(44,'2023-12-31','2024-06-30',507,53.270,76.100,'2024-03-06 16:02:09','2024-03-08 12:51:59'),
(45,'2023-12-31','2024-06-30',508,53.270,76.100,'2024-03-06 16:02:38','2024-03-08 12:52:12'),
(64,'2023-12-31','2024-06-30',156,48.900,69.850,'2024-03-07 09:11:12','2024-03-07 09:11:12'),
(65,'2023-12-31','2024-06-30',516,58.100,83.000,'2024-03-07 10:04:32','2024-03-07 10:04:32'),
(66,'2023-12-31','2024-06-30',519,76.440,109.200,'2024-03-07 10:10:33','2024-03-07 10:10:33'),
(67,'2023-12-31','2024-06-30',520,86.800,124.000,'2024-03-07 10:11:32','2024-03-07 10:11:32'),
(68,'2023-12-31','2024-06-30',521,92.400,132.000,'2024-03-07 10:15:31','2024-03-07 10:15:31'),
(69,'2023-12-31','2024-06-30',517,47.040,67.200,'2024-03-07 10:16:28','2024-03-07 10:16:28'),
(70,'2023-12-31','2024-06-30',522,60.520,86.450,'2024-03-07 10:17:54','2024-03-07 10:17:54'),
(71,'2023-12-31','2024-06-30',523,65.800,94.000,'2024-03-07 10:18:41','2024-03-07 10:18:41'),
(72,'2023-12-31','2024-06-30',524,71.050,101.500,'2024-03-07 10:20:26','2024-03-07 10:20:26'),
(73,'2023-12-31','2024-06-30',518,38.500,55.000,'2024-03-07 10:21:13','2024-03-07 10:21:13'),
(74,'2023-12-31','2024-06-30',525,45.150,64.500,'2024-03-07 10:22:01','2024-03-07 10:22:01'),
(75,'2023-12-31','2024-06-30',526,48.510,69.300,'2024-03-07 10:22:50','2024-03-07 10:22:50'),
(76,'2023-12-31','2024-06-30',527,49.840,71.200,'2024-03-07 10:23:42','2024-03-07 10:23:42'),
(77,'2023-12-31','2024-06-30',528,68.430,97.750,'2024-03-07 10:48:11','2024-03-07 10:48:11'),
(78,'2023-12-31','2024-06-30',529,87.610,125.150,'2024-03-07 10:49:11','2024-03-07 10:49:11'),
(79,'2023-12-31','2024-06-30',530,103.530,147.900,'2024-03-07 10:50:29','2024-03-07 10:50:29'),
(80,'2023-12-31','2024-06-30',533,49.700,71.000,'2024-03-07 10:51:16','2024-03-07 10:51:16'),
(81,'2023-12-31','2024-06-30',532,56.350,80.500,'2024-03-07 10:53:34','2024-03-07 10:53:34'),
(82,'2023-12-31','2024-06-30',531,61.040,87.200,'2024-03-07 10:54:22','2024-03-07 10:54:22'),
(83,'2023-12-31','2024-06-30',534,36.400,52.000,'2024-03-07 11:01:39','2024-03-07 11:01:39'),
(84,'2023-12-31','2024-06-30',535,47.600,68.000,'2024-03-07 11:02:26','2024-03-07 11:02:26'),
(85,'2023-12-31','2024-06-30',539,53.900,77.000,'2024-03-07 13:45:59','2024-03-07 13:45:59'),
(86,'2023-12-31','2024-06-30',541,60.900,87.000,'2024-03-07 13:47:12','2024-03-07 13:47:12'),
(87,'2023-12-31','2024-06-30',542,64.050,91.500,'2024-03-07 13:48:03','2024-03-07 13:48:03'),
(88,'2023-12-31','2024-06-30',540,43.400,62.000,'2024-03-07 13:48:58','2024-03-07 13:48:58'),
(89,'2023-12-31','2024-06-30',543,45.570,65.100,'2024-03-07 13:49:52','2024-03-07 13:49:52'),
(90,'2023-12-31','2024-06-30',544,48.650,69.500,'2024-03-07 13:50:42','2024-03-07 13:50:42'),
(91,'2023-12-31','2024-06-30',107,36.610,52.300,'2024-03-07 13:53:31','2024-03-07 13:53:31'),
(92,'2023-12-31','2024-06-30',545,38.850,55.500,'2024-03-07 14:03:53','2024-03-07 14:03:53'),
(93,'2023-12-31','2024-06-30',546,40.110,57.300,'2024-03-07 14:05:24','2024-03-07 14:05:24'),
(94,'2023-12-31','2024-06-30',108,65.450,93.500,'2024-03-07 14:06:59','2024-03-07 14:06:59'),
(95,'2023-12-31','2024-06-30',109,48.300,69.000,'2024-03-07 14:09:48','2024-03-07 14:09:48'),
(96,'2023-12-31','2024-06-30',548,73.850,105.500,'2024-03-07 14:10:42','2024-03-07 14:10:42'),
(97,'2023-12-31','2024-06-30',550,51.310,73.300,'2024-03-07 14:11:30','2024-03-07 14:11:30'),
(98,'2023-12-31','2024-06-30',551,37.840,54.050,'2024-03-07 15:25:40','2024-03-07 15:25:40'),
(99,'2023-12-31','2024-06-30',552,40.950,58.500,'2024-03-07 15:34:30','2024-03-07 15:34:30'),
(100,'2023-12-31','2024-06-30',553,46.410,66.300,'2024-03-07 15:35:37','2024-03-07 15:35:37'),
(101,'2023-12-31','2024-06-30',554,41.340,59.050,'2024-03-07 15:36:26','2024-03-07 15:36:26'),
(103,'2023-12-31','2024-06-30',555,44.590,63.700,'2024-03-07 15:38:23','2024-03-07 15:38:23'),
(104,'2023-12-31','2024-06-30',556,50.260,71.800,'2024-03-07 15:39:27','2024-03-07 15:39:27'),
(105,'2023-12-31','2024-06-30',43,16.450,23.500,'2024-03-07 15:54:16','2024-03-07 15:54:16'),
(106,'2023-12-31','2024-06-30',44,19.500,13.650,'2024-03-07 15:56:02','2024-03-07 15:56:02'),
(107,'2023-12-31','2024-06-30',557,20.200,28.850,'2024-03-07 15:57:29','2024-03-07 15:57:29'),
(108,'2023-12-31','2024-06-30',418,23.380,33.400,'2024-03-08 09:24:29','2024-03-08 09:24:29'),
(109,'2023-12-31','2024-06-30',423,29.260,41.800,'2024-03-08 09:25:00','2024-03-08 09:25:00'),
(110,'2023-12-31','2024-06-30',419,19.220,27.450,'2024-03-08 09:25:25','2024-03-08 09:25:25'),
(111,'2023-12-31','2024-06-30',421,20.690,29.550,'2024-03-08 09:25:54','2024-03-08 09:25:54'),
(112,'2023-12-31','2024-06-30',420,15.510,22.150,'2024-03-08 09:26:26','2024-03-08 09:26:26'),
(113,'2023-12-31','2024-06-30',426,16.100,23.000,'2024-03-08 09:26:48','2024-03-08 09:26:48'),
(115,'2023-12-31','2024-06-30',559,30.520,43.600,'2024-03-08 09:28:38','2024-03-08 09:28:38'),
(116,'2023-12-31','2024-06-30',427,22.330,31.900,'2024-03-08 09:36:59','2024-03-08 09:36:59'),
(117,'2023-12-31','2024-06-30',560,23.100,33.000,'2024-03-08 09:38:35','2024-03-08 09:38:35'),
(118,'2023-12-31','2024-06-30',115,25.900,37.000,'2024-03-08 09:41:41','2024-03-08 09:41:41'),
(119,'2023-12-31','2024-06-30',561,17.470,24.950,'2024-03-08 09:53:45','2024-03-08 09:53:45'),
(120,'2023-12-31','2024-06-30',562,20.300,29.000,'2024-03-08 09:54:12','2024-03-08 09:54:12'),
(121,'2023-12-31','2024-06-30',45,30.270,43.250,'2024-03-08 10:17:16','2024-03-08 10:17:16'),
(122,'2023-12-31','2024-06-30',36,30.420,43.450,'2024-03-08 10:18:18','2024-03-08 10:18:18'),
(123,'2023-12-31','2024-06-30',38,34.020,48.600,'2024-03-08 10:18:45','2024-03-08 10:18:45'),
(124,'2023-12-31','2024-06-30',40,35.880,51.250,'2024-03-08 10:19:07','2024-03-08 10:19:07'),
(125,'2023-12-31','2024-06-30',35,23.380,33.400,'2024-03-08 10:20:02','2024-03-08 10:20:02'),
(126,'2023-12-31','2024-06-30',37,26.080,37.250,'2024-03-08 10:35:39','2024-03-08 10:35:39'),
(127,'2023-12-31','2024-06-30',39,31.120,44.450,'2024-03-08 10:37:40','2024-03-08 10:37:40'),
(128,'2023-12-31','2024-06-30',498,44.100,63.000,'2024-03-08 10:38:52','2024-03-08 10:38:52'),
(131,'2023-12-31','2024-06-30',501,36.020,51.450,'2024-03-08 10:40:14','2024-03-08 10:40:14'),
(132,'2023-12-31','2024-06-30',504,48.230,68.900,'2024-03-08 10:40:43','2024-03-08 10:40:43'),
(133,'2023-12-31','2024-06-30',505,48.970,69.950,'2024-03-08 10:41:31','2024-03-08 10:41:31'),
(134,'2023-12-31','2024-06-30',506,48.970,69.950,'2024-03-08 10:41:59','2024-03-08 10:41:59'),
(137,'2023-12-31','2024-06-30',371,15.470,22.100,'2024-03-08 10:46:00','2024-03-08 10:46:00'),
(138,'2023-12-31','2024-06-30',150,22.960,32.800,'2024-03-08 10:46:29','2024-03-08 10:46:29'),
(139,'2023-12-31','2024-06-30',375,25.380,36.250,'2024-03-08 10:46:53','2024-03-08 10:46:53'),
(140,'2023-12-31','2024-06-30',144,13.580,19.400,'2024-03-08 10:47:22','2024-03-08 10:47:22'),
(141,'2023-12-31','2024-06-30',509,18.660,26.650,'2024-03-08 10:47:53','2024-03-08 10:47:53'),
(142,'2023-12-31','2024-06-30',512,19.740,28.200,'2024-03-08 10:48:14','2024-03-08 10:48:14'),
(143,'2023-12-31','2024-06-30',511,9.240,13.200,'2024-03-08 10:48:35','2024-03-08 10:48:35'),
(144,'2023-12-31','2024-06-30',510,11.340,16.200,'2024-03-08 10:48:52','2024-03-08 10:48:52'),
(145,'2023-12-31','2024-06-30',513,12.880,18.400,'2024-03-08 10:49:16','2024-03-08 10:49:16'),
(146,'2023-12-31','2024-06-30',139,32.270,46.100,'2024-03-08 10:49:45','2024-03-08 10:49:45'),
(147,'2023-12-31','2024-06-30',514,37.210,53.150,'2024-03-08 10:50:07','2024-03-08 10:50:07'),
(148,'2023-12-31','2024-06-30',153,41.830,59.750,'2024-03-08 10:50:33','2024-03-08 10:50:33'),
(149,'2023-12-31','2024-06-30',570,51.730,73.900,'2024-03-08 14:09:36','2024-03-08 14:09:36'),
(150,'2023-12-31','2024-06-30',571,46.200,66.000,'2024-03-08 14:10:08','2024-03-08 14:10:08'),
(151,'2023-12-31','2024-06-30',565,20.720,29.600,'2024-03-08 14:11:00','2024-03-08 14:11:00'),
(152,'2023-12-31','2024-06-30',566,45.850,65.500,'2024-03-08 14:12:01','2024-03-08 14:12:01'),
(153,'2023-12-31','2024-06-30',572,30.100,43.000,'2024-03-08 14:21:53','2024-03-08 14:21:53'),
(154,'2023-12-31','2024-06-30',573,35.630,50.900,'2024-03-08 14:22:16','2024-03-08 14:22:16');


