(26,2,'2066709a-75af-4bfd-b750-2abf708e8774',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"06\",\"department\":{\"id\":\"06\",\"description\":\"CAJAMARCA\"},\"province_id\":\"0608\",\"province\":{\"id\":\"0608\",\"description\":\"Ja\\u00e9n\"},\"district_id\":\"060801\",\"district\":{\"id\":\"060801\",\"description\":\"Ja\\u00e9n\"},\"urbanization\":null,\"address\":\"PRO. HUAYNA CAPAC NRO\",\"email\":\"deluxe.luisfs20@gmail.com\",\"telephone\":\"+51 931 192 695\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":\"CONSTRUCCI\\u00d3N CIVIL, ELECTRICIDAD, GASTITER\\u00cdA, DRYWALL Y CIELOS RASOS.\",\"logo\":null}','02','05','2.1',0,0,'01','01','FF01',26,'2023-02-24','09:40:42',4,'{\"identity_document_type_id\":\"6\",\"identity_document_type\":{\"id\":\"6\",\"description\":\"RUC\"},\"number\":\"20391308668\",\"name\":\"HACIENDA EL POTRERO SAC\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"06\",\"department\":{\"id\":\"06\",\"description\":\"CAJAMARCA\"},\"province_id\":\"0608\",\"province\":{\"id\":\"0608\",\"description\":\"Ja\\u00e9n\"},\"district_id\":\"060801\",\"district\":{\"id\":\"060801\",\"description\":\"Ja\\u00e9n\"},\"address\":\"AV. MESONES MURO NRO. 1835 P.J. NUEVO HORIZONTE\",\"email\":null,\"telephone\":null,\"perception_agent\":false,\"address_id\":null,\"internal_code\":null,\"address_type_id\":null,\"address_type\":{\"id\":null,\"description\":null}}','PEN','01','10',NULL,NULL,38,NULL,0,NULL,NULL,NULL,2,3.805,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,650.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,650.00,650.00,650.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Seiscientos cincuenta  con 00\\/100 \"}]',NULL,NULL,'10481348531-01-FF01-26','10481348531-01-FF01-26','hX4rdaUAu+jL4coHmDys3QzRHGQ=','[encoded data, 90460 characters]',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,0,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Factura numero FF01-26, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,NULL,NULL,'',NULL,'2023-02-24 13:52:31','2023-02-24 13:52:33',1,NULL,NULL),(27,2,'ca427673-110c-43c1-9a3f-a52918443268',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"06\",\"department\":{\"id\":\"06\",\"description\":\"CAJAMARCA\"},\"province_id\":\"0608\",\"province\":{\"id\":\"0608\",\"description\":\"Ja\\u00e9n\"},\"district_id\":\"060801\",\"district\":{\"id\":\"060801\",\"description\":\"Ja\\u00e9n\"},\"urbanization\":null,\"address\":\"PRO. HUAYNA CAPAC NRO\",\"email\":\"deluxe.luisfs20@gmail.com\",\"telephone\":\"+51 931 192 695\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":\"CONSTRUCCI\\u00d3N CIVIL, ELECTRICIDAD, GASTITER\\u00cdA, DRYWALL Y CIELOS RASOS.\",\"logo\":null}','02','13','2.1',0,0,'01','01','FF01',27,'2023-03-01','13:24:47',9,'{\"identity_document_type_id\":\"6\",\"identity_document_type\":{\"id\":\"6\",\"description\":\"RUC\"},\"number\":\"20531349475\",\"name\":\"CREDIVARGAS S.A.C.\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"22\",\"department\":{\"id\":\"22\",\"description\":\"SAN MARTIN\"},\"province_id\":\"2209\",\"province\":{\"id\":\"2209\",\"description\":\"San Mart\\u00edn\"},\"district_id\":\"220901\",\"district\":{\"id\":\"220901\",\"description\":\"Tarapoto\"},\"address\":\"JR. JIMENEZ PIMENTEL NRO. 901\",\"email\":null,\"telephone\":null,\"perception_agent\":false,\"address_id\":null,\"internal_code\":null,\"address_type_id\":null,\"address_type\":{\"id\":null,\"description\":null}}','PEN','01','10',NULL,NULL,40,NULL,0,NULL,NULL,NULL,2,3.810,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,13425.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,13425.00,13425.00,13425.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Trece mil cuatrocientos veinticinco  con 00\\/100 \"}]',NULL,NULL,'10481348531-01-FF01-27','10481348531-01-FF01-27','NUjd1c1kfIZhHnQGhejokKwp1Ng=','[encoded data, 90460 characters]',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,0,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Factura numero FF01-27, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,NULL,NULL,'',NULL,'2023-03-01 13:33:58','2023-03-01 13:39:10',1,NULL,NULL);

--
-- Table structure for table `download_tray`
--

CREATE TABLE `download_tray` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned DEFAULT NULL,
  `module` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `format` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'IN_PROCESS',
  `date_init` datetime DEFAULT NULL,
  `date_end` datetime DEFAULT NULL,
  `payload_request` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `download_tray_user_id_foreign` (`user_id`),
  CONSTRAINT `download_tray_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `download_tray`
--


--
-- Table structure for table `drivers`
--

CREATE TABLE `drivers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `identity_document_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `license` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `telephone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `drivers_identity_document_type_id_foreign` (`identity_document_type_id`),
  KEY `drivers_number_index` (`number`),
  KEY `drivers_name_index` (`name`),
  CONSTRAINT `drivers_identity_document_type_id_foreign` FOREIGN KEY (`identity_document_type_id`) REFERENCES `cat_identity_document_types` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `drivers`
--

INSERT INTO `drivers` VALUES (1,'1','45230150','FERNANDEZ ESTELA, ELVIN MIGUEL','445230150','966285705',0,1,'2023-01-25 21:15:17','2023-01-25 21:15:17');

--
-- Table structure for table `email_send_log`
--

CREATE TABLE `email_send_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `relation_id` int(10) unsigned DEFAULT 0 COMMENT 'Id de modelo',
  `type` int(10) unsigned DEFAULT 0 COMMENT 'Tipo de relacion',
  `relation_model` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Modelo a relacion',
  `file_line` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Archivo qu elo llama',
  `sendit` tinyint(3) unsigned DEFAULT 1 COMMENT 'Booleano para envio de correo',
  `email` text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Correo de destino',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_send_log`
--


--
-- Table structure for table `establishments`
--

CREATE TABLE `establishments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `department_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `province_id` char(4) COLLATE utf8mb4_unicode_ci NOT NULL,
  `district_id` char(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `telephone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `aditional_information` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `web_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trade_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_id` int(10) unsigned DEFAULT NULL,
  `logo` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `template_pdf` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default',
  `has_igv_31556` tinyint(1) NOT NULL DEFAULT 0,
  `template_ticket_pdf` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `establishments_country_id_foreign` (`country_id`),
  KEY `establishments_department_id_foreign` (`department_id`),
  KEY `establishments_province_id_foreign` (`province_id`),
  KEY `establishments_district_id_foreign` (`district_id`),
  CONSTRAINT `establishments_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`),
  CONSTRAINT `establishments_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  CONSTRAINT `establishments_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`),
  CONSTRAINT `establishments_province_id_foreign` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `establishments`
--

INSERT INTO `establishments` VALUES (1,'Oficina Principal','PE','06','0608','060801','PRO. HUAYNA CAPAC NRO','deluxe.luisfs20@gmail.com','+51 931 192 695','0000','CONSTRUCCIÓN CIVIL, ELECTRICIDAD, GASTITERÍA, DRYWALL Y CIELOS RASOS.',NULL,NULL,NULL,NULL,'default',0,'default',NULL,'2022-06-30 18:42:38');

--
-- Table structure for table `exchange_rates`
--

CREATE TABLE `exchange_rates` (
  `date` date NOT NULL,
  `sale_original` decimal(13,3) NOT NULL,
  `purchase_original` decimal(13,3) NOT NULL,
  `purchase` decimal(13,3) NOT NULL,
  `sale` decimal(13,3) NOT NULL,
  `date_original` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `exchange_rates`
--

INSERT INTO `exchange_rates` VALUES ('2022-06-29',3.791,3.783,3.783,3.791,'2022-06-28','2022-06-29 21:37:35','2022-06-29 21:37:35'),('2022-06-30',3.788,3.770,3.770,3.788,'2022-06-29','2022-06-30 10:27:46','2022-06-30 10:27:46'),('2022-07-02',3.830,3.820,3.820,3.830,'2022-07-01','2022-07-02 08:58:32','2022-07-02 08:58:32'),('2022-07-10',3.888,3.881,3.881,3.888,'2022-07-08','2022-07-10 12:03:06','2022-07-10 12:03:06'),('2022-07-11',3.905,3.897,3.897,3.905,'2022-07-09','2022-07-11 14:17:14','2022-07-11 14:17:14'),('2022-07-13',3.972,3.965,3.965,3.972,'2022-07-13','2022-07-13 19:46:09','2022-07-13 19:46:09'),('2022-07-14',3.968,3.959,3.959,3.968,'2022-07-14','2022-07-14 11:23:17','2022-07-14 11:23:17'),('2022-07-19',3.892,3.884,3.884,3.892,'2022-07-19','2022-07-19 09:51:19','2022-07-19 09:51:19'),('2022-07-20',3.892,3.884,3.884,3.892,'2022-07-19','2022-07-20 10:16:58','2022-07-20 10:16:58'),('2022-07-22',3.892,3.884,3.884,3.892,'2022-07-19','2022-07-22 09:59:59','2022-07-22 09:59:59'),('2022-08-01',3.925,3.916,3.916,3.925,'2022-08-01','2022-08-01 12:14:48','2022-08-01 12:14:48'),('2022-08-03',3.919,3.914,3.914,3.919,'2022-08-03','2022-08-03 10:54:27','2022-08-03 10:54:27'),('2022-08-04',3.920,3.914,3.914,3.920,'2022-08-04','2022-08-04 14:06:25','2022-08-04 14:06:25'),('2022-08-08',3.905,3.896,3.896,3.905,'2022-08-08','2022-08-08 16:38:17','2022-08-08 16:38:17'),('2022-08-09',3.916,3.911,3.911,3.916,'2022-08-09','2022-08-09 11:30:19','2022-08-09 11:30:19'),('2022-08-25',3.867,3.861,3.861,3.867,'2022-08-25','2022-08-25 14:00:00','2022-08-25 14:00:00'),('2022-08-30',3.838,3.829,3.829,3.838,'2022-08-30','2022-08-30 11:22:04','2022-08-30 11:22:04'),('2022-09-01',3.847,3.839,3.839,3.847,'2022-09-01','2022-09-01 18:03:16','2022-09-01 18:03:16'),('2022-09-08',3.896,3.891,3.891,3.896,'2022-09-08','2022-09-08 18:23:13','2022-09-08 18:23:13'),('2022-09-16',3.892,3.883,3.883,3.892,'2022-09-16','2022-09-16 13:23:36','2022-09-16 13:23:36'),('2022-09-17',3.883,3.875,3.875,3.883,'2022-09-17','2022-09-17 17:16:54','2022-09-17 17:16:54'),('2022-09-19',3.883,3.875,3.875,3.883,'2022-09-19','2022-09-19 12:21:43','2022-09-19 12:21:43'),('2022-09-21',3.883,3.877,3.877,3.883,'2022-09-21','2022-09-21 12:12:59','2022-09-21 12:12:59'),('2022-09-27',3.938,3.928,3.928,3.938,'2022-09-27','2022-09-27 15:12:23','2022-09-27 15:12:23'),('2022-10-13',3.984,3.981,3.981,3.984,'2022-10-13','2022-10-13 09:49:00','2022-10-13 09:49:00'),('2022-10-26',4.002,3.992,3.992,4.002,'2022-10-26','2022-10-26 12:41:40','2022-10-26 12:41:40'),('2022-10-29',3.978,3.970,3.970,3.978,'2022-10-29','2022-10-29 12:27:30','2022-10-29 12:27:30'),('2022-11-07',3.962,3.953,3.953,3.962,'2022-11-07','2022-11-07 20:07:53','2022-11-07 20:07:53'),('2022-11-08',3.957,3.949,3.949,3.957,'2022-11-08','2022-11-08 17:22:25','2022-11-08 17:22:25'),('2022-11-17',3.842,3.837,3.837,3.842,'2022-11-17','2022-11-17 09:42:54','2022-11-17 09:42:54'),('2022-11-21',3.841,3.827,3.827,3.841,'2022-11-20','2022-11-21 08:55:27','2022-11-21 08:55:27'),('2022-11-30',3.847,3.840,3.840,3.847,'2022-11-30','2022-11-30 21:15:43','2022-11-30 21:15:43'),('2022-12-16',3.849,3.841,3.841,3.849,'2022-12-16','2022-12-16 10:43:56','2022-12-16 10:43:56'),('2023-01-25',3.885,3.880,3.880,3.885,'2023-01-25','2023-01-25 09:30:24','2023-01-25 09:30:24'),('2023-01-26',3.900,3.892,3.892,3.900,'2023-01-26','2023-01-26 20:28:24','2023-01-26 20:28:24'),('2023-02-13',3.858,3.853,3.853,3.858,'2023-02-11','2023-02-13 17:32:22','2023-02-13 17:32:22'),('2023-02-17',3.868,3.862,3.862,3.868,'2023-02-17','2023-02-17 11:05:05','2023-02-17 11:05:05'),('2023-02-21',3.850,3.840,3.840,3.850,'2023-02-21','2023-02-21 09:37:50','2023-02-21 09:37:50'),('2023-02-24',3.805,3.800,3.800,3.805,'2023-02-24','2023-02-24 13:50:17','2023-02-24 13:50:17'),('2023-03-01',3.810,3.803,3.803,3.810,'2023-03-01','2023-03-01 13:02:23','2023-03-01 13:02:23');

--
-- Table structure for table `expense_items`
--

CREATE TABLE `expense_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `expense_id` int(10) unsigned NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total` decimal(12,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `expense_items_expense_id_foreign` (`expense_id`),
  CONSTRAINT `expense_items_expense_id_foreign` FOREIGN KEY (`expense_id`) REFERENCES `expenses` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `expense_items`
--


--
-- Table structure for table `expense_method_types`
--

CREATE TABLE `expense_method_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `has_card` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `expense_method_types`
--

INSERT INTO `expense_method_types` VALUES (1,'CAJA GENERAL',0),(2,'Tarjeta de crédito',1),(3,'Tarjeta de débito',1);

--
-- Table structure for table `expense_payments`
--

CREATE TABLE `expense_payments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `expense_id` int(10) unsigned NOT NULL,
  `date_of_payment` date NOT NULL,
  `expense_method_type_id` int(10) unsigned NOT NULL,
  `has_card` tinyint(1) NOT NULL DEFAULT 0,
  `card_brand_id` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment` decimal(12,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `expense_payments_expense_id_foreign` (`expense_id`),
  KEY `expense_payments_card_brand_id_foreign` (`card_brand_id`),
  KEY `expense_payments_expense_method_type_id_foreign` (`expense_method_type_id`),
  KEY `expense_payments_date_of_payment_index` (`date_of_payment`),
  CONSTRAINT `expense_payments_card_brand_id_foreign` FOREIGN KEY (`card_brand_id`) REFERENCES `card_brands` (`id`),
  CONSTRAINT `expense_payments_expense_id_foreign` FOREIGN KEY (`expense_id`) REFERENCES `expenses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `expense_payments_expense_method_type_id_foreign` FOREIGN KEY (`expense_method_type_id`) REFERENCES `expense_method_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `expense_payments`
--


--
-- Table structure for table `expense_reasons`
--

CREATE TABLE `expense_reasons` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `expense_reasons`
--

INSERT INTO `expense_reasons` VALUES (1,'Varios'),(2,'Representación de la organización'),(3,'Trabajo de campo');

--
-- Table structure for table `expense_types`
--

CREATE TABLE `expense_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `expense_types`
--

INSERT INTO `expense_types` VALUES (1,'PLANILLA','2022-06-28 23:11:31','2022-06-28 23:11:31'),(2,'RECIBO POR HONORARIO','2022-06-28 23:11:31','2022-06-28 23:11:31'),(3,'SERVICIO PÚBLICO','2022-06-28 23:11:31','2022-06-28 23:11:31'),(4,'OTROS','2022-06-28 23:11:31','2022-06-28 23:11:31');

--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `soap_type_id` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expense_type_id` int(10) unsigned NOT NULL,
  `establishment_id` int(10) unsigned NOT NULL,
  `supplier_id` int(10) unsigned NOT NULL,
  `expense_reason_id` int(10) unsigned NOT NULL DEFAULT 1,
  `currency_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `external_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state_type_id` char(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_of_issue` date NOT NULL,
  `time_of_issue` time NOT NULL,
  `supplier` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`supplier`)),
  `exchange_rate_sale` decimal(13,3) NOT NULL,
  `total` decimal(12,2) NOT NULL,
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `expenses_filename_unique` (`filename`),
  KEY `expenses_user_id_foreign` (`user_id`),
  KEY `expenses_establishment_id_foreign` (`establishment_id`),
  KEY `expenses_supplier_id_foreign` (`supplier_id`),
  KEY `expenses_expense_type_id_foreign` (`expense_type_id`),
  KEY `expenses_currency_type_id_foreign` (`currency_type_id`),
  KEY `expenses_expense_reason_id_foreign` (`expense_reason_id`),
  KEY `expenses_soap_type_id_foreign` (`soap_type_id`),
  KEY `expenses_state_type_id_foreign` (`state_type_id`),
  CONSTRAINT `expenses_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`),
  CONSTRAINT `expenses_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`),
  CONSTRAINT `expenses_expense_reason_id_foreign` FOREIGN KEY (`expense_reason_id`) REFERENCES `expense_reasons` (`id`),
  CONSTRAINT `expenses_expense_type_id_foreign` FOREIGN KEY (`expense_type_id`) REFERENCES `expense_types` (`id`),
  CONSTRAINT `expenses_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `expenses_state_type_id_foreign` FOREIGN KEY (`state_type_id`) REFERENCES `state_types` (`id`),
  CONSTRAINT `expenses_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `expenses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `expenses`
--


--
-- Table structure for table `fixed_asset_items`
--

CREATE TABLE `fixed_asset_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_type_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `internal_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unit_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `purchase_unit_price` decimal(16,6) NOT NULL,
  `purchase_affectation_igv_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fixed_asset_items_item_type_id_foreign` (`item_type_id`),
  KEY `fixed_asset_items_unit_type_id_foreign` (`unit_type_id`),
  KEY `fixed_asset_items_currency_type_id_foreign` (`currency_type_id`),
  KEY `fixed_asset_items_purchase_affectation_igv_type_id_foreign` (`purchase_affectation_igv_type_id`),
  CONSTRAINT `fixed_asset_items_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`),
  CONSTRAINT `fixed_asset_items_item_type_id_foreign` FOREIGN KEY (`item_type_id`) REFERENCES `item_types` (`id`),
  CONSTRAINT `fixed_asset_items_purchase_affectation_igv_type_id_foreign` FOREIGN KEY (`purchase_affectation_igv_type_id`) REFERENCES `cat_affectation_igv_types` (`id`),
  CONSTRAINT `fixed_asset_items_unit_type_id_foreign` FOREIGN KEY (`unit_type_id`) REFERENCES `cat_unit_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `fixed_asset_items`
--


--
-- Table structure for table `fixed_asset_purchase_items`
--

CREATE TABLE `fixed_asset_purchase_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fixed_asset_purchase_id` int(10) unsigned NOT NULL,
  `fixed_asset_item_id` int(10) unsigned NOT NULL,
  `item` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`item`)),
  `quantity` decimal(12,4) NOT NULL,
  `unit_value` decimal(16,6) NOT NULL,
  `affectation_igv_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_base_igv` decimal(12,2) NOT NULL,
  `percentage_igv` decimal(12,2) NOT NULL,
  `total_igv` decimal(12,2) NOT NULL,
  `system_isc_type_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_base_isc` decimal(12,2) NOT NULL DEFAULT 0.00,
  `percentage_isc` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_isc` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_base_other_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `percentage_other_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_other_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_taxes` decimal(12,2) NOT NULL,
  `price_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `unit_price` decimal(16,6) NOT NULL,
  `total_value` decimal(12,2) NOT NULL,
  `total_charge` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_discount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total` decimal(12,2) NOT NULL,
  `attributes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`attributes`)),
  `discounts` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`discounts`)),
  `charges` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`charges`)),
  PRIMARY KEY (`id`),
  KEY `fixed_asset_purchase_items_fixed_asset_purchase_id_foreign` (`fixed_asset_purchase_id`),
  KEY `fixed_asset_purchase_items_fixed_asset_item_id_foreign` (`fixed_asset_item_id`),
  KEY `fixed_asset_purchase_items_affectation_igv_type_id_foreign` (`affectation_igv_type_id`),
  KEY `fixed_asset_purchase_items_system_isc_type_id_foreign` (`system_isc_type_id`),
  KEY `fixed_asset_purchase_items_price_type_id_foreign` (`price_type_id`),
  CONSTRAINT `fixed_asset_purchase_items_affectation_igv_type_id_foreign` FOREIGN KEY (`affectation_igv_type_id`) REFERENCES `cat_affectation_igv_types` (`id`),
  CONSTRAINT `fixed_asset_purchase_items_fixed_asset_item_id_foreign` FOREIGN KEY (`fixed_asset_item_id`) REFERENCES `fixed_asset_items` (`id`),
  CONSTRAINT `fixed_asset_purchase_items_fixed_asset_purchase_id_foreign` FOREIGN KEY (`fixed_asset_purchase_id`) REFERENCES `fixed_asset_purchases` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fixed_asset_purchase_items_price_type_id_foreign` FOREIGN KEY (`price_type_id`) REFERENCES `cat_price_types` (`id`),
  CONSTRAINT `fixed_asset_purchase_items_system_isc_type_id_foreign` FOREIGN KEY (`system_isc_type_id`) REFERENCES `cat_system_isc_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `fixed_asset_purchase_items`
--


--
-- Table structure for table `fixed_asset_purchases`
--

CREATE TABLE `fixed_asset_purchases` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `external_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `establishment_id` int(10) unsigned NOT NULL,
  `soap_type_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state_type_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `group_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `document_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `series` char(4) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` int(11) NOT NULL,
  `date_of_issue` date NOT NULL,
  `date_of_due` date DEFAULT NULL,
  `time_of_issue` time NOT NULL,
  `supplier_id` int(10) unsigned NOT NULL,
  `supplier` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`supplier`)),
  `currency_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `exchange_rate_sale` decimal(13,3) NOT NULL,
  `total_prepayment` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_charge` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_discount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_exportation` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_free` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_taxed` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_unaffected` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_exonerated` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_igv` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_base_isc` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_isc` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_base_other_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_other_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_value` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total` decimal(12,2) NOT NULL,
  `customer_id` int(10) unsigned DEFAULT NULL,
  `perception_date` date DEFAULT NULL,
  `perception_number` int(11) DEFAULT NULL,
  `total_perception` decimal(12,2) DEFAULT NULL,
  `charges` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`charges`)),
  `discounts` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`discounts`)),
  `prepayments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`prepayments`)),
  `guides` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`guides`)),
  `related` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`related`)),
  `perception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`perception`)),
  `detraction` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`detraction`)),
  `legends` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`legends`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fixed_asset_purchases_user_id_foreign` (`user_id`),
  KEY `fixed_asset_purchases_establishment_id_foreign` (`establishment_id`),
  KEY `fixed_asset_purchases_supplier_id_foreign` (`supplier_id`),
  KEY `fixed_asset_purchases_customer_id_foreign` (`customer_id`),
  KEY `fixed_asset_purchases_soap_type_id_foreign` (`soap_type_id`),
  KEY `fixed_asset_purchases_state_type_id_foreign` (`state_type_id`),
  KEY `fixed_asset_purchases_group_id_foreign` (`group_id`),
  KEY `fixed_asset_purchases_document_type_id_foreign` (`document_type_id`),
  KEY `fixed_asset_purchases_currency_type_id_foreign` (`currency_type_id`),
  CONSTRAINT `fixed_asset_purchases_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`),
  CONSTRAINT `fixed_asset_purchases_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `fixed_asset_purchases_document_type_id_foreign` FOREIGN KEY (`document_type_id`) REFERENCES `cat_document_types` (`id`),
  CONSTRAINT `fixed_asset_purchases_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`),
  CONSTRAINT `fixed_asset_purchases_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`),
  CONSTRAINT `fixed_asset_purchases_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `fixed_asset_purchases_state_type_id_foreign` FOREIGN KEY (`state_type_id`) REFERENCES `state_types` (`id`),
  CONSTRAINT `fixed_asset_purchases_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `fixed_asset_purchases_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `fixed_asset_purchases`
--


--
-- Table structure for table `format_templates`
--

CREATE TABLE `format_templates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `formats` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `urls` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`urls`)),
  `is_custom_ticket` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `format_templates`
--

INSERT INTO `format_templates` VALUES (1,'con_valor_unitario',NULL,0),(2,'default',NULL,0),(3,'default2',NULL,0),(4,'font_sm',NULL,0),(5,'font_sw2',NULL,0),(6,'legend_amazonia',NULL,0),(7,'model1',NULL,0),(8,'model2',NULL,0),(9,'model3',NULL,0),(10,'model4',NULL,0),(11,'modelw80',NULL,0),(12,'santiago',NULL,0),(13,'top_placa',NULL,0),(14,'unit_types_desc',NULL,0);

--
-- Table structure for table `full_suscription_server_data`
--

CREATE TABLE `full_suscription_server_data` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `person_id` int(10) unsigned DEFAULT 0,
  `host` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `full_suscription_server_data`
--


--
-- Table structure for table `full_suscription_user_data`
--

CREATE TABLE `full_suscription_user_data` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `person_id` int(10) unsigned DEFAULT 0,
  `discord_user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slack_channel` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discord_channel` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gitlab_user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `full_suscription_user_data`
--


--
-- Table structure for table `general_payment_conditions`
--

CREATE TABLE `general_payment_conditions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `general_payment_conditions`
--

INSERT INTO `general_payment_conditions` VALUES ('01','Contado'),('02','Crédito'),('03','Crédito con cuotas');

--
-- Table structure for table `global_payments`
--

CREATE TABLE `global_payments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `soap_type_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `destination_id` int(11) DEFAULT NULL,
  `destination_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_id` int(11) NOT NULL,
  `payment_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `destination_index` (`destination_id`,`destination_type`),
  KEY `payment_index` (`payment_id`,`payment_type`),
  KEY `global_payments_soap_type_id_foreign` (`soap_type_id`),
  KEY `global_payments_user_id_foreign` (`user_id`),
  CONSTRAINT `global_payments_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `global_payments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `global_payments`
--

INSERT INTO `global_payments` VALUES (1,'02',1,'App\\Models\\Tenant\\Cash',1,'Modules\\Pos\\Models\\CashTransaction',2,'2022-06-29 21:27:50','2022-06-29 21:27:50'),(2,'02',2,'App\\Models\\Tenant\\Cash',2,'Modules\\Pos\\Models\\CashTransaction',1,'2022-06-29 21:44:49','2022-06-29 21:44:49'),(3,'02',1,'App\\Models\\Tenant\\Cash',1,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-29 22:00:27','2022-06-29 22:00:27'),(4,'02',1,'App\\Models\\Tenant\\Cash',1,'Modules\\Sale\\Models\\QuotationPayment',2,'2022-06-30 17:55:48','2022-06-30 17:55:48'),(5,'02',1,'App\\Models\\Tenant\\Cash',2,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-02 09:03:27','2022-07-02 09:03:27'),(6,'02',1,'App\\Models\\Tenant\\Cash',3,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-14 12:59:38','2022-07-14 12:59:38'),(7,'02',1,'App\\Models\\Tenant\\Cash',4,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-19 10:05:02','2022-07-19 10:05:02'),(8,'02',1,'App\\Models\\Tenant\\Cash',5,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-19 10:09:39','2022-07-19 10:09:39'),(9,'02',1,'App\\Models\\Tenant\\Cash',6,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-09 11:34:15','2022-08-09 11:34:15'),(10,'02',1,'App\\Models\\Tenant\\Cash',7,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-25 14:05:39','2022-08-25 14:05:39'),(11,'02',1,'App\\Models\\Tenant\\Cash',8,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-25 14:19:37','2022-08-25 14:19:37'),(12,'02',1,'App\\Models\\Tenant\\Cash',9,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-21 12:19:02','2022-09-21 12:19:02'),(13,'02',1,'App\\Models\\Tenant\\Cash',10,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-21 12:32:35','2022-09-21 12:32:35'),(15,'02',1,'App\\Models\\Tenant\\Cash',3,'Modules\\Sale\\Models\\QuotationPayment',2,'2022-09-27 15:21:43','2022-09-27 15:21:43'),(16,'02',1,'App\\Models\\Tenant\\Cash',11,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-26 12:42:30','2022-10-26 12:42:30'),(17,'02',1,'App\\Models\\Tenant\\Cash',12,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-29 12:35:38','2022-10-29 12:35:38'),(18,'02',1,'App\\Models\\Tenant\\Cash',13,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-29 12:41:37','2022-10-29 12:41:37'),(19,'02',1,'App\\Models\\Tenant\\Cash',14,'App\\Models\\Tenant\\DocumentPayment',2,'2022-11-07 20:11:10','2022-11-07 20:11:10'),(20,'02',1,'App\\Models\\Tenant\\Cash',15,'App\\Models\\Tenant\\DocumentPayment',2,'2022-11-21 09:03:08','2022-11-21 09:03:08'),(22,'02',1,'App\\Models\\Tenant\\Cash',5,'Modules\\Sale\\Models\\QuotationPayment',2,'2023-01-25 09:42:29','2023-01-25 09:42:29'),(23,'02',1,'App\\Models\\Tenant\\Cash',6,'Modules\\Sale\\Models\\QuotationPayment',2,'2023-01-25 16:40:04','2023-01-25 16:40:04'),(24,'02',1,'App\\Models\\Tenant\\Cash',16,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-13 17:33:27','2023-02-13 17:33:27'),(25,'02',1,'App\\Models\\Tenant\\Cash',17,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-17 11:06:37','2023-02-17 11:06:37'),(26,'02',1,'App\\Models\\Tenant\\Cash',18,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-21 09:39:22','2023-02-21 09:39:22'),(28,'02',1,'App\\Models\\Tenant\\Cash',8,'Modules\\Sale\\Models\\QuotationPayment',2,'2023-03-01 13:27:51','2023-03-01 13:27:51');

--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `groups_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` VALUES ('01','Facturas'),('02','Boletas');

--
-- Table structure for table `guide_files`
--

CREATE TABLE `guide_files` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `filename` text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Nombre de archivo',
  `purchase_id` int(10) unsigned DEFAULT 0 COMMENT 'Relacion con purchases',
  `document_id` int(10) unsigned DEFAULT 0 COMMENT 'Relacion con documents',
  `order_note_id` int(10) unsigned DEFAULT 0 COMMENT 'Relacion con order_notes',
  `quotation_id` int(10) unsigned DEFAULT 0 COMMENT 'Relacion con quotations',
  `sale_note_id` int(10) unsigned DEFAULT 0 COMMENT 'Relacion con sale_notes',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `guide_files`
--


--
-- Table structure for table `guide_items`
--

CREATE TABLE `guide_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `guide_id` int(10) unsigned NOT NULL,
  `item_id` int(10) unsigned NOT NULL,
  `item_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` decimal(20,8) NOT NULL,
  `unit_cost` decimal(20,8) NOT NULL,
  `total` decimal(12,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `guide_items_guide_id_foreign` (`guide_id`),
  KEY `guide_items_item_id_foreign` (`item_id`),
  CONSTRAINT `guide_items_guide_id_foreign` FOREIGN KEY (`guide_id`) REFERENCES `guides` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `guide_items`
--


--
-- Table structure for table `guides`
--

CREATE TABLE `guides` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `external_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `warehouse_id` int(10) unsigned NOT NULL,
  `soap_type_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `document_type_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `series` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` int(11) NOT NULL,
  `date_of_issue` date NOT NULL,
  `time_of_issue` time NOT NULL,
  `inventory_transaction_id` char(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guideable_id` int(10) unsigned DEFAULT NULL,
  `guideable_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `observations` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `guides_series_number_unique` (`soap_type_id`,`document_type_id`,`series`,`number`),
  KEY `guides_user_id_foreign` (`user_id`),
  KEY `guides_warehouse_id_foreign` (`warehouse_id`),
  KEY `guides_document_type_id_foreign` (`document_type_id`),
  KEY `guides_inventory_transaction_id_foreign` (`inventory_transaction_id`),
  CONSTRAINT `guides_document_type_id_foreign` FOREIGN KEY (`document_type_id`) REFERENCES `cat_document_types` (`id`),
  CONSTRAINT `guides_inventory_transaction_id_foreign` FOREIGN KEY (`inventory_transaction_id`) REFERENCES `inventory_transactions` (`id`),
  CONSTRAINT `guides_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `guides_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `guides_warehouse_id_foreign` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `guides`
--


--
-- Table structure for table `hotel_categories`
--

CREATE TABLE `hotel_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotel_categories`
--


--
-- Table structure for table `hotel_floors`
--

CREATE TABLE `hotel_floors` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotel_floors`
--


--
-- Table structure for table `hotel_rates`
--

CREATE TABLE `hotel_rates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotel_rates`
--


--
-- Table structure for table `hotel_rent_items`
--

CREATE TABLE `hotel_rent_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hotel_rent_id` int(10) unsigned NOT NULL,
  `item_id` int(10) unsigned NOT NULL,
  `item` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `hotel_rent_items_hotel_rent_id_foreign` (`hotel_rent_id`),
  KEY `hotel_rent_items_item_id_foreign` (`item_id`),
  CONSTRAINT `hotel_rent_items_hotel_rent_id_foreign` FOREIGN KEY (`hotel_rent_id`) REFERENCES `hotel_rents` (`id`) ON DELETE CASCADE,
  CONSTRAINT `hotel_rent_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotel_rent_items`
--


--
-- Table structure for table `hotel_rents`
--

CREATE TABLE `hotel_rents` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int(10) unsigned NOT NULL,
  `customer` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `towels` int(11) NOT NULL DEFAULT 1,
  `hotel_room_id` int(10) unsigned NOT NULL,
  `hotel_rate_id` int(10) unsigned DEFAULT NULL,
  `duration` int(11) NOT NULL DEFAULT 1,
  `quantity_persons` int(11) NOT NULL DEFAULT 1,
  `input_date` date DEFAULT NULL,
  `input_time` varchar(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_status` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `output_date` date NOT NULL,
  `output_time` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL,
  `arrears` int(11) NOT NULL DEFAULT 0,
  `status` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'INICIADO',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `hotel_rents_hotel_rate_id_foreign` (`hotel_rate_id`),
  CONSTRAINT `hotel_rents_hotel_rate_id_foreign` FOREIGN KEY (`hotel_rate_id`) REFERENCES `hotel_rates` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotel_rents`
--


--
-- Table structure for table `hotel_room_rates`
--

CREATE TABLE `hotel_room_rates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `hotel_room_id` int(10) unsigned NOT NULL,
  `hotel_rate_id` int(10) unsigned NOT NULL,
  `price` double NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `hotel_room_rates_hotel_room_id_foreign` (`hotel_room_id`),
  KEY `hotel_room_rates_hotel_rate_id_foreign` (`hotel_rate_id`),
  CONSTRAINT `hotel_room_rates_hotel_rate_id_foreign` FOREIGN KEY (`hotel_rate_id`) REFERENCES `hotel_rates` (`id`) ON DELETE CASCADE,
  CONSTRAINT `hotel_room_rates_hotel_room_id_foreign` FOREIGN KEY (`hotel_room_id`) REFERENCES `hotel_rooms` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotel_room_rates`
--


--
-- Table structure for table `hotel_rooms`
--

CREATE TABLE `hotel_rooms` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `item_id` int(10) unsigned DEFAULT NULL,
  `hotel_category_id` int(10) unsigned NOT NULL,
  `hotel_floor_id` int(10) unsigned NOT NULL,
  `name` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'DISPONIBLE',
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `hotel_rooms_hotel_category_id_foreign` (`hotel_category_id`),
  KEY `hotel_rooms_hotel_floor_id_foreign` (`hotel_floor_id`),
  KEY `hotel_rooms_item_id_foreign` (`item_id`),
  CONSTRAINT `hotel_rooms_hotel_category_id_foreign` FOREIGN KEY (`hotel_category_id`) REFERENCES `hotel_categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `hotel_rooms_hotel_floor_id_foreign` FOREIGN KEY (`hotel_floor_id`) REFERENCES `hotel_floors` (`id`) ON DELETE CASCADE,
  CONSTRAINT `hotel_rooms_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotel_rooms`
--


--
-- Table structure for table `income`
--

CREATE TABLE `income` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `income_type_id` int(10) unsigned NOT NULL,
  `income_reason_id` int(10) unsigned NOT NULL,
  `soap_type_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state_type_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `establishment_id` int(10) unsigned NOT NULL,
  `customer` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `external_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` int(11) NOT NULL,
  `date_of_issue` date NOT NULL,
  `time_of_issue` time NOT NULL,
  `exchange_rate_sale` decimal(13,3) NOT NULL,
  `total` decimal(12,2) NOT NULL,
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `income_filename_unique` (`filename`),
  KEY `income_user_id_foreign` (`user_id`),
  KEY `income_establishment_id_foreign` (`establishment_id`),
  KEY `income_income_type_id_foreign` (`income_type_id`),
  KEY `income_income_reason_id_foreign` (`income_reason_id`),
  KEY `income_state_type_id_foreign` (`state_type_id`),
  KEY `income_soap_type_id_foreign` (`soap_type_id`),
  KEY `income_currency_type_id_foreign` (`currency_type_id`),
  KEY `income_number_index` (`number`),
  KEY `income_date_of_issue_index` (`date_of_issue`),
  KEY `income_external_id_index` (`external_id`),
  CONSTRAINT `income_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`),
  CONSTRAINT `income_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`),
  CONSTRAINT `income_income_reason_id_foreign` FOREIGN KEY (`income_reason_id`) REFERENCES `income_reasons` (`id`),
  CONSTRAINT `income_income_type_id_foreign` FOREIGN KEY (`income_type_id`) REFERENCES `income_types` (`id`),
  CONSTRAINT `income_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `income_state_type_id_foreign` FOREIGN KEY (`state_type_id`) REFERENCES `state_types` (`id`),
  CONSTRAINT `income_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `income`
--


--
-- Table structure for table `income_items`
--

CREATE TABLE `income_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `income_id` int(10) unsigned NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total` decimal(12,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `income_items_income_id_foreign` (`income_id`),
  CONSTRAINT `income_items_income_id_foreign` FOREIGN KEY (`income_id`) REFERENCES `income` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `income_items`
--


--
-- Table structure for table `income_payments`
--

CREATE TABLE `income_payments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `income_id` int(10) unsigned NOT NULL,
  `date_of_payment` date NOT NULL,
  `payment_method_type_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `has_card` tinyint(1) NOT NULL DEFAULT 0,
  `card_brand_id` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `change` decimal(12,2) DEFAULT NULL,
  `payment` decimal(12,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `income_payments_income_id_foreign` (`income_id`),
  KEY `income_payments_card_brand_id_foreign` (`card_brand_id`),
  KEY `income_payments_payment_method_type_id_foreign` (`payment_method_type_id`),
  CONSTRAINT `income_payments_card_brand_id_foreign` FOREIGN KEY (`card_brand_id`) REFERENCES `card_brands` (`id`),
  CONSTRAINT `income_payments_income_id_foreign` FOREIGN KEY (`income_id`) REFERENCES `income` (`id`) ON DELETE CASCADE,
  CONSTRAINT `income_payments_payment_method_type_id_foreign` FOREIGN KEY (`payment_method_type_id`) REFERENCES `payment_method_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `income_payments`
--


--
-- Table structure for table `income_reasons`
--

CREATE TABLE `income_reasons` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `income_reasons`
--

INSERT INTO `income_reasons` VALUES (1,'Varios');

--
-- Table structure for table `income_types`
--

CREATE TABLE `income_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `income_types`
--

INSERT INTO `income_types` VALUES (1,'INGRESOS FINANCIEROS','2022-06-28 23:11:36','2022-06-28 23:11:36'),(2,'PRESTAMOS','2022-06-28 23:11:36','2022-06-28 23:11:36'),(3,'OTROS','2022-06-28 23:11:36','2022-06-28 23:11:36');

--
-- Table structure for table `inventories`
--

CREATE TABLE `inventories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('1','2','3') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `detail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_id` int(10) unsigned NOT NULL,
  `warehouse_id` int(10) unsigned NOT NULL,
  `warehouse_destination_id` int(10) unsigned DEFAULT NULL,
  `inventory_transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` decimal(12,4) NOT NULL,
  `lot_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inventories_transfer_id` int(10) unsigned DEFAULT NULL,
  `comments` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_of_issue` date DEFAULT NULL,
  `guide_id` int(10) unsigned DEFAULT NULL,
  `system_stock` decimal(12,4) DEFAULT NULL,
  `real_stock` decimal(12,4) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `inventories_item_id_foreign` (`item_id`),
  KEY `inventories_warehouse_id_foreign` (`warehouse_id`),
  KEY `inventories_inventory_transaction_id_foreign` (`inventory_transaction_id`),
  KEY `inventories_inventories_transfer_id_foreign` (`inventories_transfer_id`),
  CONSTRAINT `inventories_inventories_transfer_id_foreign` FOREIGN KEY (`inventories_transfer_id`) REFERENCES `inventories_transfer` (`id`),
  CONSTRAINT `inventories_inventory_transaction_id_foreign` FOREIGN KEY (`inventory_transaction_id`) REFERENCES `inventory_transactions` (`id`),
  CONSTRAINT `inventories_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE,
  CONSTRAINT `inventories_warehouse_id_foreign` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=265 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inventories`
--

INSERT INTO `inventories` VALUES (1,'1','Stock inicial',NULL,3,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-06-30 15:41:23','2022-06-30 15:41:23'),(2,'1','Stock inicial',NULL,5,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-06-30 15:45:24','2022-06-30 15:45:24'),(3,'1','Stock inicial',NULL,7,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-02 09:02:03','2022-07-02 09:02:03'),(4,'1','Stock inicial',NULL,8,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 15:43:30','2022-07-10 15:43:30'),(5,'1','Stock inicial',NULL,9,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 15:50:30','2022-07-10 15:50:30'),(6,'1','Stock inicial',NULL,10,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 15:51:10','2022-07-10 15:51:10'),(7,'1','Stock inicial',NULL,11,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 15:52:34','2022-07-10 15:52:34'),(8,'1','Stock inicial',NULL,12,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 15:54:04','2022-07-10 15:54:04'),(9,'1','Stock inicial',NULL,13,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 15:55:05','2022-07-10 15:55:05'),(10,'1','Stock inicial',NULL,14,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 15:56:12','2022-07-10 15:56:12'),(11,'1','Stock inicial',NULL,15,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 15:58:55','2022-07-10 15:58:55'),(12,'1','Stock inicial',NULL,16,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 15:59:22','2022-07-10 15:59:22'),(13,'1','Stock inicial',NULL,17,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 15:59:55','2022-07-10 15:59:55'),(14,'1','Stock inicial',NULL,18,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 16:00:36','2022-07-10 16:00:36'),(15,'1','Stock inicial',NULL,19,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 16:01:40','2022-07-10 16:01:40'),(16,'1','Stock inicial',NULL,20,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 16:02:39','2022-07-10 16:02:39'),(17,'1','Stock inicial',NULL,21,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 16:03:33','2022-07-10 16:03:33'),(18,'1','Stock inicial',NULL,22,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 16:04:13','2022-07-10 16:04:13'),(19,'1','Stock inicial',NULL,23,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 16:05:24','2022-07-10 16:05:24'),(20,'1','Stock inicial',NULL,24,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 16:06:15','2022-07-10 16:06:15'),(21,'1','Stock inicial',NULL,25,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 16:07:45','2022-07-10 16:07:45'),(22,'1','Stock inicial',NULL,26,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 16:08:37','2022-07-10 16:08:37'),(23,'1','Stock inicial',NULL,27,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 16:39:39','2022-07-10 16:39:39'),(24,'1','Stock inicial',NULL,28,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 16:43:00','2022-07-10 16:43:00'),(25,'1','Stock inicial',NULL,29,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 16:44:54','2022-07-10 16:44:54'),(26,'1','Stock inicial',NULL,31,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 16:52:07','2022-07-10 16:52:07'),(27,'1','Stock inicial',NULL,32,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 16:53:29','2022-07-10 16:53:29'),(28,'1','Stock inicial',NULL,33,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 16:55:52','2022-07-10 16:55:52'),(29,'1','Stock inicial',NULL,34,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 16:57:41','2022-07-10 16:57:41'),(30,'1','Stock inicial',NULL,35,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 17:07:10','2022-07-10 17:07:10'),(31,'1','Stock inicial',NULL,36,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 23:02:02','2022-07-10 23:02:02'),(32,'1','Stock inicial',NULL,37,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 23:02:59','2022-07-10 23:02:59'),(33,'1','Stock inicial',NULL,38,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 23:04:57','2022-07-10 23:04:57'),(34,'1','Stock inicial',NULL,39,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 23:06:00','2022-07-10 23:06:00'),(35,'1','Stock inicial',NULL,40,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 23:06:41','2022-07-10 23:06:41'),(36,'1','Stock inicial',NULL,41,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 23:07:11','2022-07-10 23:07:11'),(37,'1','Stock inicial',NULL,42,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 23:08:36','2022-07-10 23:08:36'),(38,'1','Stock inicial',NULL,43,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 23:09:13','2022-07-10 23:09:13'),(39,'1','Stock inicial',NULL,44,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 23:10:08','2022-07-10 23:10:08'),(40,'1','Stock inicial',NULL,45,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 23:15:05','2022-07-10 23:15:05'),(41,'1','Stock inicial',NULL,46,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 23:16:21','2022-07-10 23:16:21'),(42,'1','Stock inicial',NULL,47,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 23:17:08','2022-07-10 23:17:08'),(43,'1','Stock inicial',NULL,48,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 23:18:00','2022-07-10 23:18:00'),(44,'1','Stock inicial',NULL,49,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 23:18:43','2022-07-10 23:18:43'),(45,'1','Stock inicial',NULL,50,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 23:19:17','2022-07-10 23:19:17'),(46,'1','Stock inicial',NULL,51,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-10 23:28:05','2022-07-10 23:28:05'),(47,'1','Stock inicial',NULL,52,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-13 19:47:30','2022-07-13 19:47:30'),(48,'1','Stock inicial',NULL,53,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-13 19:48:48','2022-07-13 19:48:48'),(49,'1','Stock inicial',NULL,54,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-13 19:49:49','2022-07-13 19:49:49'),(50,'1','Stock inicial',NULL,55,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-13 19:50:41','2022-07-13 19:50:41'),(51,'1','Stock inicial',NULL,56,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-13 19:51:51','2022-07-13 19:51:51'),(52,'1','Stock inicial',NULL,57,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-13 19:52:32','2022-07-13 19:52:32'),(53,'1','Stock inicial',NULL,58,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:28:56','2022-07-14 11:28:56'),(54,'1','Stock inicial',NULL,59,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:30:02','2022-07-14 11:30:02'),(55,'1','Stock inicial',NULL,60,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:31:12','2022-07-14 11:31:12'),(56,'1','Stock inicial',NULL,61,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:32:34','2022-07-14 11:32:34'),(57,'1','Stock inicial',NULL,62,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:33:48','2022-07-14 11:33:48'),(58,'1','Stock inicial',NULL,63,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:34:29','2022-07-14 11:34:29'),(59,'1','Stock inicial',NULL,64,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:35:27','2022-07-14 11:35:27'),(60,'1','Stock inicial',NULL,65,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:36:58','2022-07-14 11:36:58'),(61,'1','Stock inicial',NULL,66,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:38:22','2022-07-14 11:38:22'),(62,'1','Stock inicial',NULL,67,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:40:13','2022-07-14 11:40:13'),(63,'1','Stock inicial',NULL,68,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:41:16','2022-07-14 11:41:16'),(64,'1','Stock inicial',NULL,69,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:42:27','2022-07-14 11:42:27'),(65,'1','Stock inicial',NULL,70,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:43:35','2022-07-14 11:43:35'),(66,'1','Stock inicial',NULL,71,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:45:54','2022-07-14 11:45:54'),(67,'1','Stock inicial',NULL,72,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:47:02','2022-07-14 11:47:02'),(68,'1','Stock inicial',NULL,73,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:48:01','2022-07-14 11:48:01'),(69,'1','Stock inicial',NULL,74,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:48:37','2022-07-14 11:48:37'),(70,'1','Stock inicial',NULL,75,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:49:40','2022-07-14 11:49:40'),(71,'1','Stock inicial',NULL,76,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:50:18','2022-07-14 11:50:18'),(72,'1','Stock inicial',NULL,77,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:51:17','2022-07-14 11:51:17'),(73,'1','Stock inicial',NULL,78,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:52:00','2022-07-14 11:52:00'),(74,'1','Stock inicial',NULL,79,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:52:38','2022-07-14 11:52:38'),(75,'1','Stock inicial',NULL,80,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:53:27','2022-07-14 11:53:27'),(76,'1','Stock inicial',NULL,81,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:54:07','2022-07-14 11:54:07'),(77,'1','Stock inicial',NULL,82,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:54:59','2022-07-14 11:54:59'),(78,'1','Stock inicial',NULL,83,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:55:40','2022-07-14 11:55:40'),(79,'1','Stock inicial',NULL,84,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:56:13','2022-07-14 11:56:13'),(80,'1','Stock inicial',NULL,85,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 11:56:33','2022-07-14 11:56:33'),(81,'1','Stock inicial',NULL,86,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 12:02:14','2022-07-14 12:02:14'),(82,'1','Stock inicial',NULL,87,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 12:21:26','2022-07-14 12:21:26'),(83,'1','Stock inicial',NULL,88,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 12:22:00','2022-07-14 12:22:00'),(84,'1','Stock inicial',NULL,89,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 12:22:44','2022-07-14 12:22:44'),(85,'1','Stock inicial',NULL,90,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 12:23:08','2022-07-14 12:23:08'),(86,'1','Stock inicial',NULL,91,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 12:24:03','2022-07-14 12:24:03'),(87,'1','Stock inicial',NULL,92,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 12:38:04','2022-07-14 12:38:04'),(88,'1','Stock inicial',NULL,93,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 12:58:24','2022-07-14 12:58:24'),(89,'1','Stock inicial',NULL,94,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-14 12:59:18','2022-07-14 12:59:18'),(90,'1','Stock inicial',NULL,95,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-19 09:53:04','2022-07-19 09:53:04'),(91,'1','Stock inicial',NULL,96,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-19 09:53:36','2022-07-19 09:53:36'),(92,'1','Stock inicial',NULL,97,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-19 09:54:03','2022-07-19 09:54:03'),(93,'1','Stock inicial',NULL,98,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-19 09:54:49','2022-07-19 09:54:49'),(94,'1','Stock inicial',NULL,99,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-19 09:55:21','2022-07-19 09:55:21'),(95,'1','Stock inicial',NULL,100,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-19 09:55:56','2022-07-19 09:55:56'),(96,'1','Stock inicial',NULL,101,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-19 09:56:35','2022-07-19 09:56:35'),(97,'1','Stock inicial',NULL,102,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-19 09:57:15','2022-07-19 09:57:15'),(98,'1','Stock inicial',NULL,103,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-19 09:57:59','2022-07-19 09:57:59'),(99,'1','Stock inicial',NULL,104,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-19 09:58:40','2022-07-19 09:58:40'),(100,'1','Stock inicial',NULL,105,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-19 09:59:27','2022-07-19 09:59:27'),(101,'1','Stock inicial',NULL,106,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-19 10:00:30','2022-07-19 10:00:30'),(102,'1','Stock inicial',NULL,107,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-19 10:00:59','2022-07-19 10:00:59'),(103,'1','Stock inicial',NULL,108,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-19 10:01:42','2022-07-19 10:01:42'),(104,'1','Stock inicial',NULL,109,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-19 10:02:00','2022-07-19 10:02:00'),(105,'1','Stock inicial',NULL,110,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-19 10:02:27','2022-07-19 10:02:27'),(106,'1','Stock inicial',NULL,111,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-19 10:03:09','2022-07-19 10:03:09'),(107,'1','Stock inicial',NULL,112,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-19 10:03:36','2022-07-19 10:03:36'),(108,'1','Stock inicial',NULL,113,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-19 10:04:03','2022-07-19 10:04:03'),(109,'1','Stock inicial',NULL,114,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-19 10:04:36','2022-07-19 10:04:36'),(110,'1','Stock inicial',NULL,115,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-19 10:08:32','2022-07-19 10:08:32'),(111,'1','Stock inicial',NULL,116,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-20 10:18:14','2022-07-20 10:18:14'),(112,'1','Stock inicial',NULL,117,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-20 10:19:04','2022-07-20 10:19:04'),(113,'1','Stock inicial',NULL,118,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-20 10:20:13','2022-07-20 10:20:13'),(114,'1','Stock inicial',NULL,119,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-22 10:03:10','2022-07-22 10:03:10'),(115,'1','Stock inicial',NULL,120,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-22 10:04:41','2022-07-22 10:04:41'),(116,'1','Stock inicial',NULL,121,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-22 10:06:15','2022-07-22 10:06:15'),(117,'1','Stock inicial',NULL,122,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-01 12:19:58','2022-08-01 12:19:58'),(118,'1','Stock inicial',NULL,123,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-01 12:21:31','2022-08-01 12:21:31'),(119,'1','Stock inicial',NULL,124,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-01 12:22:18','2022-08-01 12:22:18'),(120,'1','Stock inicial',NULL,125,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-01 12:22:51','2022-08-01 12:22:51'),(121,'1','Stock inicial',NULL,126,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-01 12:23:20','2022-08-01 12:23:20'),(122,'1','Stock inicial',NULL,127,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-01 12:24:14','2022-08-01 12:24:14'),(123,'1','Stock inicial',NULL,128,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-01 12:25:09','2022-08-01 12:25:09'),(124,'1','Stock inicial',NULL,129,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-01 12:25:57','2022-08-01 12:25:57'),(125,'1','Stock inicial',NULL,130,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-01 12:27:49','2022-08-01 12:27:49'),(126,'1','Stock inicial',NULL,131,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-01 12:28:19','2022-08-01 12:28:19'),(127,'1','Stock inicial',NULL,132,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-03 11:27:59','2022-08-03 11:27:59'),(128,'1','Stock inicial',NULL,133,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-03 11:30:14','2022-08-03 11:30:14'),(129,'1','Stock inicial',NULL,134,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-03 11:30:51','2022-08-03 11:30:51'),(130,'1','Stock inicial',NULL,135,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-03 11:34:29','2022-08-03 11:34:29'),(131,'1','Stock inicial',NULL,136,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-03 11:35:21','2022-08-03 11:35:21'),(132,'1','Stock inicial',NULL,137,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-03 11:36:27','2022-08-03 11:36:27'),(133,'1','Stock inicial',NULL,138,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-03 11:37:00','2022-08-03 11:37:00'),(134,'1','Stock inicial',NULL,139,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-03 11:40:52','2022-08-03 11:40:52'),(135,'1','Stock inicial',NULL,140,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-04 14:10:39','2022-08-04 14:10:39'),(136,'1','Stock inicial',NULL,141,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-08 16:39:34','2022-08-08 16:39:34'),(137,'1','Stock inicial',NULL,142,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-08 16:40:29','2022-08-08 16:40:29'),(138,'1','Stock inicial',NULL,143,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-09 11:33:48','2022-08-09 11:33:48'),(139,'1','Stock inicial',NULL,144,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-09 14:53:29','2022-08-09 14:53:29'),(140,'1','Stock inicial',NULL,145,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-09 14:56:59','2022-08-09 14:56:59'),(141,'1','Stock inicial',NULL,146,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-25 14:03:51','2022-08-25 14:03:51'),(142,'1','Stock inicial',NULL,147,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-25 14:04:50','2022-08-25 14:04:50'),(143,'1','Stock inicial',NULL,148,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-25 14:05:15','2022-08-25 14:05:15'),(144,'1','Stock inicial',NULL,149,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-25 14:09:57','2022-08-25 14:09:57'),(145,'1','Stock inicial',NULL,150,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-25 14:10:33','2022-08-25 14:10:33'),(146,'1','Stock inicial',NULL,151,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-25 14:11:06','2022-08-25 14:11:06'),(147,'1','Stock inicial',NULL,152,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-25 14:11:43','2022-08-25 14:11:43'),(148,'1','Stock inicial',NULL,153,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-25 14:12:26','2022-08-25 14:12:26'),(149,'1','Stock inicial',NULL,154,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-25 14:12:51','2022-08-25 14:12:51'),(150,'1','Stock inicial',NULL,155,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-25 14:13:54','2022-08-25 14:13:54'),(151,'1','Stock inicial',NULL,156,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-25 14:14:38','2022-08-25 14:14:38'),(152,'1','Stock inicial',NULL,157,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-25 14:15:33','2022-08-25 14:15:33'),(153,'1','Stock inicial',NULL,158,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-25 14:16:20','2022-08-25 14:16:20'),(154,'1','Stock inicial',NULL,159,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-25 14:17:06','2022-08-25 14:17:06'),(155,'1','Stock inicial',NULL,160,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-25 14:17:40','2022-08-25 14:17:40'),(156,'1','Stock inicial',NULL,161,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-25 14:18:33','2022-08-25 14:18:33'),(157,'1','Stock inicial',NULL,162,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-25 14:19:23','2022-08-25 14:19:23'),(158,'1','Stock inicial',NULL,163,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:25:12','2022-08-30 11:25:12'),(159,'1','Stock inicial',NULL,164,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:26:12','2022-08-30 11:26:12'),(160,'1','Stock inicial',NULL,165,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:28:45','2022-08-30 11:28:45'),(161,'1','Stock inicial',NULL,166,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:29:26','2022-08-30 11:29:26'),(162,'1','Stock inicial',NULL,167,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:30:14','2022-08-30 11:30:14'),(163,'1','Stock inicial',NULL,168,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:30:54','2022-08-30 11:30:54'),(164,'1','Stock inicial',NULL,169,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:31:19','2022-08-30 11:31:19'),(165,'1','Stock inicial',NULL,170,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:31:48','2022-08-30 11:31:48'),(166,'1','Stock inicial',NULL,171,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:32:17','2022-08-30 11:32:17'),(167,'1','Stock inicial',NULL,172,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:33:46','2022-08-30 11:33:46'),(168,'1','Stock inicial',NULL,173,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:34:24','2022-08-30 11:34:24'),(169,'1','Stock inicial',NULL,174,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:34:52','2022-08-30 11:34:52'),(170,'1','Stock inicial',NULL,175,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:35:54','2022-08-30 11:35:54'),(171,'1','Stock inicial',NULL,176,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:36:59','2022-08-30 11:36:59'),(172,'1','Stock inicial',NULL,177,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:37:40','2022-08-30 11:37:40'),(173,'1','Stock inicial',NULL,178,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:38:35','2022-08-30 11:38:35'),(174,'1','Stock inicial',NULL,179,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:39:21','2022-08-30 11:39:21'),(175,'1','Stock inicial',NULL,180,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:40:05','2022-08-30 11:40:05'),(176,'1','Stock inicial',NULL,181,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:40:50','2022-08-30 11:40:50'),(177,'1','Stock inicial',NULL,182,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:41:42','2022-08-30 11:41:42'),(178,'1','Stock inicial',NULL,183,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:42:19','2022-08-30 11:42:19'),(179,'1','Stock inicial',NULL,184,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:43:55','2022-08-30 11:43:55'),(180,'1','Stock inicial',NULL,185,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:44:34','2022-08-30 11:44:34'),(181,'1','Stock inicial',NULL,186,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:45:47','2022-08-30 11:45:47'),(182,'1','Stock inicial',NULL,187,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:46:34','2022-08-30 11:46:34'),(183,'1','Stock inicial',NULL,188,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:47:20','2022-08-30 11:47:20'),(184,'1','Stock inicial',NULL,189,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:48:06','2022-08-30 11:48:06'),(185,'1','Stock inicial',NULL,190,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:48:35','2022-08-30 11:48:35'),(186,'1','Stock inicial',NULL,191,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:48:53','2022-08-30 11:48:53'),(187,'1','Stock inicial',NULL,192,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:56:53','2022-08-30 11:56:53'),(188,'1','Stock inicial',NULL,193,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:57:32','2022-08-30 11:57:32'),(189,'1','Stock inicial',NULL,194,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 11:59:09','2022-08-30 11:59:09'),(190,'1','Stock inicial',NULL,195,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 12:00:28','2022-08-30 12:00:28'),(191,'1','Stock inicial',NULL,196,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 12:07:42','2022-08-30 12:07:42'),(192,'1','Stock inicial',NULL,197,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 12:08:53','2022-08-30 12:08:53'),(193,'1','Stock inicial',NULL,198,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 12:10:34','2022-08-30 12:10:34'),(194,'1','Stock inicial',NULL,199,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 12:11:01','2022-08-30 12:11:01'),(195,'1','Stock inicial',NULL,200,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 12:12:39','2022-08-30 12:12:39'),(196,'1','Stock inicial',NULL,201,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 12:22:05','2022-08-30 12:22:05'),(197,'1','Stock inicial',NULL,202,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 12:28:46','2022-08-30 12:28:46'),(198,'1','Stock inicial',NULL,203,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-30 12:29:39','2022-08-30 12:29:39'),(199,'1','Stock inicial',NULL,204,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-09-01 18:07:00','2022-09-01 18:07:00'),(200,'1','Stock inicial',NULL,205,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-09-01 18:09:24','2022-09-01 18:09:24'),(201,'1','Stock inicial',NULL,206,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-09-01 18:10:15','2022-09-01 18:10:15'),(202,'1','Stock inicial',NULL,207,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-09-01 18:11:29','2022-09-01 18:11:29'),(203,'1','Stock inicial',NULL,208,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-09-01 18:12:56','2022-09-01 18:12:56'),(204,'1','Stock inicial',NULL,209,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-09-08 18:25:41','2022-09-08 18:25:41'),(205,'1','Stock inicial',NULL,210,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-09-08 18:26:29','2022-09-08 18:26:29'),(206,'1','Stock inicial',NULL,211,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-09-08 18:27:41','2022-09-08 18:27:41'),(207,'1','Stock inicial',NULL,212,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-09-08 18:28:12','2022-09-08 18:28:12'),(208,'1','Stock inicial',NULL,213,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-09-08 18:36:13','2022-09-08 18:36:13'),(209,'1','Stock inicial',NULL,214,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-09-16 13:25:28','2022-09-16 13:25:28'),(210,'1','Stock inicial',NULL,215,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-09-21 12:18:43','2022-09-21 12:18:43'),(211,'1','Stock inicial',NULL,216,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-09-21 12:29:45','2022-09-21 12:29:45'),(212,'1','Stock inicial',NULL,217,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-09-21 12:36:00','2022-09-21 12:36:00'),(213,'1','Stock inicial',NULL,218,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-09-21 19:27:29','2022-09-21 19:27:29'),(214,'1','Stock inicial',NULL,219,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-09-27 15:13:39','2022-09-27 15:13:39'),(215,'1','Stock inicial',NULL,220,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-09-27 15:16:02','2022-09-27 15:16:02'),(216,'1','Stock inicial',NULL,221,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-09-27 15:16:37','2022-09-27 15:16:37'),(217,'1','Stock inicial',NULL,222,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-13 09:51:33','2022-10-13 09:51:33'),(218,'1','Stock inicial',NULL,223,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-13 09:53:11','2022-10-13 09:53:11'),(219,'1','Stock inicial',NULL,224,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-13 10:00:27','2022-10-13 10:00:27'),(220,'1','Stock inicial',NULL,225,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-13 10:01:34','2022-10-13 10:01:34'),(221,'1','Stock inicial',NULL,226,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-26 12:42:20','2022-10-26 12:42:20'),(222,'1','Stock inicial',NULL,227,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-26 15:27:24','2022-10-26 15:27:24'),(223,'1','Stock inicial',NULL,228,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-26 15:29:23','2022-10-26 15:29:23'),(224,'1','Stock inicial',NULL,229,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-26 15:30:46','2022-10-26 15:30:46'),(225,'1','Stock inicial',NULL,232,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-26 15:35:30','2022-10-26 15:35:30'),(226,'1','Stock inicial',NULL,233,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-26 15:36:18','2022-10-26 15:36:18'),(227,'1','Stock inicial',NULL,234,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-29 12:32:19','2022-10-29 12:32:19'),(228,'1','Stock inicial',NULL,235,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-29 12:35:23','2022-10-29 12:35:23'),(229,'1','Stock inicial',NULL,236,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-29 12:37:40','2022-10-29 12:37:40'),(230,'1','Stock inicial',NULL,237,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-29 12:38:12','2022-10-29 12:38:12'),(231,'1','Stock inicial',NULL,240,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-11-08 17:26:00','2022-11-08 17:26:00'),(232,'1','Stock inicial',NULL,241,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-11-17 09:44:36','2022-11-17 09:44:36'),(233,'1','Stock inicial',NULL,242,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-11-17 09:45:29','2022-11-17 09:45:29'),(234,'1','Stock inicial',NULL,243,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-11-17 09:46:16','2022-11-17 09:46:16'),(235,'1','Stock inicial',NULL,244,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-11-21 09:02:58','2022-11-21 09:02:58'),(236,'1','Stock inicial',NULL,245,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-11-30 21:17:45','2022-11-30 21:17:45'),(237,'1','Stock inicial',NULL,246,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-11-30 21:19:12','2022-11-30 21:19:12'),(238,'1','Stock inicial',NULL,247,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-11-30 21:19:58','2022-11-30 21:19:58'),(239,'1','Stock inicial',NULL,248,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-11-30 21:26:17','2022-11-30 21:26:17'),(240,'1','Stock inicial',NULL,249,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-12-16 10:45:53','2022-12-16 10:45:53'),(241,'1','Stock inicial',NULL,250,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-12-16 10:46:42','2022-12-16 10:46:42'),(242,'1','Stock inicial',NULL,251,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-01-24 19:43:20','2023-01-24 19:43:20'),(243,'1','Stock inicial',NULL,252,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-01-25 09:00:58','2023-01-25 09:00:58'),(244,'1','Stock inicial',NULL,253,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-01-25 09:31:35','2023-01-25 09:31:35'),(245,'1','Stock inicial',NULL,254,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-01-25 09:33:51','2023-01-25 09:33:51'),(246,'1','Stock inicial',NULL,255,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-01-25 09:38:32','2023-01-25 09:38:32'),(247,'1','Stock inicial',NULL,256,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-01-25 09:42:14','2023-01-25 09:42:14'),(248,'1','Stock inicial',NULL,258,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-01-25 21:20:25','2023-01-25 21:20:25'),(249,'1','Stock inicial',NULL,259,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-01-25 21:20:58','2023-01-25 21:20:58'),(250,'1','Stock inicial',NULL,260,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-01-25 21:21:56','2023-01-25 21:21:56'),(251,'1','Stock inicial',NULL,261,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-01-25 21:22:38','2023-01-25 21:22:38'),(252,'1','Stock inicial',NULL,262,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-01-25 21:23:16','2023-01-25 21:23:16'),(253,'1','Stock inicial',NULL,263,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-02-13 17:33:05','2023-02-13 17:33:05'),(254,'1','Stock inicial',NULL,264,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-02-17 11:06:28','2023-02-17 11:06:28'),(255,'1','Stock inicial',NULL,265,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-02-21 09:38:49','2023-02-21 09:38:49'),(256,'1','Stock inicial',NULL,266,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-03-01 13:06:09','2023-03-01 13:06:09'),(257,'1','Stock inicial',NULL,267,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-03-01 13:07:19','2023-03-01 13:07:19'),(258,'1','Stock inicial',NULL,268,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-03-01 13:08:35','2023-03-01 13:08:35'),(259,'1','Stock inicial',NULL,269,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-03-01 13:10:07','2023-03-01 13:10:07'),(260,'1','Stock inicial',NULL,270,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-03-01 13:11:14','2023-03-01 13:11:14'),(261,'1','Stock inicial',NULL,271,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-03-01 13:12:01','2023-03-01 13:12:01'),(262,'1','Stock inicial',NULL,272,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-03-01 13:13:00','2023-03-01 13:13:00'),(263,'1','Stock inicial',NULL,273,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-03-01 13:14:40','2023-03-01 13:14:40'),(264,'1','Stock inicial',NULL,274,1,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-03-01 13:15:24','2023-03-01 13:15:24');

--
