--
-- Host: localhost    Database: tenancy_olti
-- ------------------------------------------------------


--
-- Table structure for table `account_payments`
--

CREATE TABLE `account_payments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date_of_payment` date NOT NULL,
  `date_of_payment_real` date DEFAULT NULL,
  `reference_id` int(10) unsigned DEFAULT NULL,
  `payment_method_type_id` int(10) unsigned DEFAULT NULL,
  `has_card` tinyint(1) NOT NULL DEFAULT 0,
  `card_brand_id` int(10) unsigned DEFAULT NULL,
  `reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment` decimal(12,2) NOT NULL,
  `state` tinyint(1) NOT NULL DEFAULT 0,
  `reference_payment` 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 `account_payments`
--


--
-- Table structure for table `accounting_ledger`
--

CREATE TABLE `accounting_ledger` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `month` smallint(5) unsigned DEFAULT 0 COMMENT 'Numero de mes',
  `year` mediumint(8) unsigned DEFAULT 0 COMMENT 'Numero de mes',
  `date_of_report` date DEFAULT NULL,
  `code_account` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Codigo de plan de cuenta',
  `name` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Nombre de cuenta',
  `last_month_total` double(12,2) NOT NULL DEFAULT 0.00 COMMENT 'Debe ser el valor del total del mes pasado',
  `credits` double(12,2) NOT NULL DEFAULT 0.00 COMMENT 'Créditos en el mes',
  `debs` double(12,2) NOT NULL DEFAULT 0.00 COMMENT 'Debitos en el mes',
  `final_total` double(12,2) NOT NULL DEFAULT 0.00 COMMENT 'Saldo Final de mes',
  `serialize_data` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'datos serialziados en bruto.',
  `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 `accounting_ledger`
--


--
-- Table structure for table `accounting_ledger_task`
--

CREATE TABLE `accounting_ledger_task` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `month` smallint(5) unsigned DEFAULT 0 COMMENT 'Numero de mes',
  `year` mediumint(8) unsigned DEFAULT 0 COMMENT 'Numero de mes',
  `last_rum` datetime 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 `accounting_ledger_task`
--


--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accounts`
--


--
-- Table structure for table `agents`
--

CREATE TABLE `agents` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `internal_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telephone` 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 `agents_internal_id_unique` (`internal_id`),
  KEY `agents_name_index` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `agents`
--


--
-- Table structure for table `app_configurations`
--

CREATE TABLE `app_configurations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `show_image_item` tinyint(1) NOT NULL DEFAULT 1,
  `print_format_pdf` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ticket',
  `card_color` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'multicolored',
  `theme_color` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'blue',
  `header_waves` tinyint(1) NOT NULL DEFAULT 0,
  `direct_send_documents_whatsapp` tinyint(1) NOT NULL DEFAULT 0,
  `direct_print` tinyint(1) NOT NULL DEFAULT 0,
  `app_mode` 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`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `app_configurations`
--

INSERT INTO `app_configurations` VALUES (1,1,'ticket','multicolored','blue',0,0,0,'default','2022-11-28 20:43:26','2022-11-28 20:43:26');

--
-- Table structure for table `app_module_user`
--

CREATE TABLE `app_module_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `app_module_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `app_module_user`
--

INSERT INTO `app_module_user` VALUES (1,1,1),(2,2,1),(3,3,1),(4,4,1),(5,5,1),(6,6,1),(7,7,1),(8,8,1),(9,9,1),(10,10,1),(11,11,1),(12,12,1),(13,13,1),(14,1,2),(15,2,2),(16,3,2),(17,4,2),(18,5,2),(19,6,2),(20,7,2),(21,8,2),(22,9,2),(23,10,2),(24,11,2),(25,12,2),(26,13,2);

--
-- Table structure for table `app_modules`
--

CREATE TABLE `app_modules` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_menu` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `app_modules_value_unique` (`value`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `app_modules`
--

INSERT INTO `app_modules` VALUES (1,'invoice','Factura electrónica',1,NULL,NULL),(2,'invoice-ticket','Boleta electrónica',2,NULL,NULL),(3,'sale-note','Nota de venta',3,NULL,NULL),(4,'order-note','Pedido',4,NULL,NULL),(5,'purchase','Compra',5,NULL,NULL),(6,'documents','Lista de comprobantes',6,NULL,NULL),(7,'report-sales','Reportes',7,NULL,NULL),(8,'validate-document','Validar cpe',8,NULL,NULL),(9,'customers','Clientes',9,NULL,NULL),(10,'items','Productos',10,NULL,NULL),(11,'cash','Caja',11,NULL,NULL),(12,'configuration','Configuración',12,NULL,NULL),(13,'quotation','Cotización',13,NULL,NULL);

--
-- Table structure for table `authorized_discount_users`
--

CREATE TABLE `authorized_discount_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `seller_id` int(10) unsigned DEFAULT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `token` varchar(255) 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`),
  UNIQUE KEY `authorized_discount_users_token_unique` (`token`),
  KEY `authorized_discount_users_user_id_foreign` (`user_id`),
  KEY `authorized_discount_users_seller_id_foreign` (`seller_id`),
  KEY `authorized_discount_users_date_index` (`date`),
  KEY `authorized_discount_users_active_index` (`active`),
  CONSTRAINT `authorized_discount_users_seller_id_foreign` FOREIGN KEY (`seller_id`) REFERENCES `users` (`id`),
  CONSTRAINT `authorized_discount_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `authorized_discount_users`
--


--
-- Table structure for table `bank_accounts`
--

CREATE TABLE `bank_accounts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bank_id` int(10) unsigned NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cci` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `initial_balance` decimal(12,2) NOT NULL DEFAULT 0.00,
  `show_in_documents` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `bank_accounts_bank_id_foreign` (`bank_id`),
  KEY `bank_accounts_currency_type_id_foreign` (`currency_type_id`),
  CONSTRAINT `bank_accounts_bank_id_foreign` FOREIGN KEY (`bank_id`) REFERENCES `banks` (`id`),
  CONSTRAINT `bank_accounts_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bank_accounts`
--


--
-- Table structure for table `bank_loan_fee`
--

CREATE TABLE `bank_loan_fee` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bank_loan_id` int(10) unsigned NOT NULL,
  `date` date NOT NULL,
  `currency_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `payment_method_type_id` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Relacion con el metodo de pago, Nulo es pago a cuotas',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bank_loan_fee`
--


--
-- Table structure for table `bank_loan_items`
--

CREATE TABLE `bank_loan_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bank_loan_id` int(10) unsigned NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `total` decimal(12,2) DEFAULT 0.00,
  `total_interest` decimal(12,2) DEFAULT 0.00,
  `total_ingress` decimal(12,2) DEFAULT 0.00,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bank_loan_items`
--


--
-- Table structure for table `bank_loan_payments`
--

CREATE TABLE `bank_loan_payments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bank_loan_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,
  `payment` decimal(12,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bank_loan_payments`
--


--
-- Table structure for table `bank_loan_reasons`
--

CREATE TABLE `bank_loan_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 `bank_loan_reasons`
--

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

--
-- Table structure for table `bank_loan_types`
--

CREATE TABLE `bank_loan_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=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bank_loan_types`
--

INSERT INTO `bank_loan_types` VALUES (1,'Prestamo','2022-11-28 20:43:24','2022-11-28 20:43:24');

--
-- Table structure for table `bank_loans`
--

CREATE TABLE `bank_loans` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `bank_loan_type_id` int(10) unsigned NOT NULL,
  `establishment_id` int(10) unsigned NOT NULL,
  `bank_id` int(10) unsigned NOT NULL,
  `bank_account_id` int(10) unsigned 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,
  `bank` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`bank`)),
  `exchange_rate_sale` decimal(12,2) DEFAULT 0.00,
  `total` decimal(12,2) DEFAULT 0.00,
  `total_interest` decimal(12,2) DEFAULT 0.00,
  `total_ingress` decimal(12,2) DEFAULT 0.00,
  `soap_type_id` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state_type_id` char(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 `bank_loans`
--


--
-- Table structure for table `banks`
--

CREATE TABLE `banks` (
  `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,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `banks`
--

INSERT INTO `banks` VALUES (1,'BANCO SCOTIABANK',NULL,NULL,1),(2,'BANCO DE CREDITO DEL PERU',NULL,NULL,1),(3,'BANCO DE COMERCIO',NULL,NULL,1),(4,'BANCO PICHINCHA',NULL,NULL,1),(5,'BBVA CONTINENTAL',NULL,NULL,1),(6,'INTERBANK',NULL,NULL,1);

--
-- Table structure for table `billing_cycles`
--

CREATE TABLE `billing_cycles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date_time_start` datetime NOT NULL,
  `renew` tinyint(1) NOT NULL DEFAULT 0,
  `quantity_documents` int(11) NOT 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 `billing_cycles`
--


--
-- Table structure for table `brands`
--

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

--
-- Dumping data for table `brands`
--


--
-- Table structure for table `business_turns`
--

CREATE TABLE `business_turns` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 0,
  `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 `business_turns`
--

INSERT INTO `business_turns` VALUES (1,'hotel','Hoteles',0,'2022-11-28 20:43:15','2022-11-28 20:43:15'),(2,'transport','Empresa de transporte de pasajeros',0,'2022-11-28 20:43:15','2022-11-28 20:43:15'),(3,'restaurant','Restaurantes',0,'2022-11-28 20:43:15','2022-11-28 20:43:15'),(4,'tap','Grifos',0,'2022-11-28 20:43:15','2022-11-28 20:43:15');

--
-- Table structure for table `card_brands`
--

CREATE TABLE `card_brands` (
  `id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  KEY `card_brands_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `card_brands`
--

INSERT INTO `card_brands` VALUES ('01','Visa',1),('02','Mastercard',1);

--
-- Table structure for table `cash`
--

CREATE TABLE `cash` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `date_opening` date NOT NULL,
  `time_opening` time NOT NULL,
  `date_closed` date DEFAULT NULL,
  `time_closed` time DEFAULT NULL,
  `beginning_balance` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `final_balance` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `income` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `state` tinyint(1) NOT NULL DEFAULT 0,
  `reference_number` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `apply_restaurant` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `cash_user_id_foreign` (`user_id`),
  KEY `cash_date_opening_index` (`date_opening`),
  KEY `cash_income_index` (`income`),
  KEY `cash_state_index` (`state`),
  KEY `cash_reference_number_index` (`reference_number`),
  CONSTRAINT `cash_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cash`
--

INSERT INTO `cash` VALUES (1,2,'2022-11-29','15:38:51','2022-11-29','16:01:32',0.0000,3.5000,3.5000,0,NULL,'2022-11-29 15:38:51','2022-11-29 16:01:32',0),(2,2,'2022-11-29','16:01:56','2022-11-30','09:43:42',30.0000,286.1000,256.1000,0,NULL,'2022-11-29 16:01:56','2022-11-30 09:43:42',0),(3,1,'2022-11-29','17:07:08','2022-11-30','09:43:46',0.0000,508.0000,508.0000,0,NULL,'2022-11-29 17:07:08','2022-11-30 09:43:46',0),(4,2,'2022-11-30','09:44:08','2022-11-30','20:15:06',50.0000,855.4000,805.4000,0,'2022-11-22','2022-11-30 09:44:08','2022-11-30 20:15:06',0),(5,2,'2022-12-01','08:36:40','2022-12-02','08:57:46',50.0000,905.1000,855.1000,0,'01-12-22','2022-12-01 08:36:40','2022-12-02 08:57:46',0),(6,2,'2022-12-02','08:59:31','2022-12-04','09:20:51',50.0000,393.2500,343.2500,0,'02-12-22','2022-12-02 08:59:31','2022-12-04 09:20:51',0),(7,2,'2022-12-04','09:21:47','2022-12-06','09:02:41',140.0000,2143.0000,2003.0000,0,'04-12-22','2022-12-04 09:21:47','2022-12-06 09:02:41',0),(8,2,'2022-12-06','09:03:21','2022-12-07','10:01:20',163.5000,495.9000,332.4000,0,'06-12-22','2022-12-06 09:03:21','2022-12-07 10:01:20',0),(9,2,'2022-12-07','10:01:55','2022-12-08','09:09:39',50.0000,371.8500,321.8500,0,'07-12-22','2022-12-07 10:01:55','2022-12-08 09:09:39',0),(10,2,'2022-12-08','09:10:06','2022-12-09','09:06:38',50.0000,407.0500,357.0500,0,'08-12-22','2022-12-08 09:10:06','2022-12-09 09:06:38',0),(11,2,'2022-12-09','09:07:09','2022-12-11','08:18:50',139.0000,953.3000,814.3000,0,'09-12-22','2022-12-09 09:07:09','2022-12-11 08:18:50',0),(12,2,'2022-12-11','08:21:30','2022-12-12','08:37:50',50.0000,370.9000,320.9000,0,'11-12-22','2022-12-11 08:21:30','2022-12-12 08:37:50',0),(13,2,'2022-12-12','08:39:04','2022-12-14','08:27:50',60.5000,914.6000,854.1000,0,'12-12-22','2022-12-12 08:39:04','2022-12-14 08:27:50',0),(14,2,'2022-12-14','08:28:20','2022-12-18','09:10:39',38.0000,1167.6000,1129.6000,0,'14-12-22','2022-12-14 08:28:20','2022-12-18 09:10:40',0),(15,2,'2022-12-18','09:11:10','2022-12-20','20:20:56',81.5000,2573.2500,2491.7500,0,'18-12-22','2022-12-18 09:11:10','2022-12-20 20:20:56',0),(16,2,'2022-12-20','20:21:17','2023-01-05','20:32:36',100.0000,42566.0900,42466.0900,0,'20-12-22','2022-12-20 20:21:17','2023-01-05 20:32:39',0),(17,2,'2023-01-06','08:44:01','2023-01-08','08:16:56',56.5000,121.0000,64.5000,0,NULL,'2023-01-06 08:44:01','2023-01-08 08:16:57',0),(18,2,'2023-01-08','08:17:49','2023-01-11','21:41:03',50.0000,573.4000,523.4000,0,'8-01-23','2023-01-08 08:17:49','2023-01-11 21:41:03',0),(19,2,'2023-01-12','08:42:53','2023-01-15','09:33:14',17.0000,687.9000,670.9000,0,'12-01-23','2023-01-12 08:42:53','2023-01-15 09:33:14',0),(20,2,'2023-01-15','09:33:38','2023-01-18','10:54:40',20.0000,309.9000,289.9000,0,'15-01-23','2023-01-15 09:33:38','2023-01-18 10:54:41',0),(21,2,'2023-01-18','10:55:26','2023-01-19','08:38:15',10.0000,25.0000,15.0000,0,'soles','2023-01-18 10:55:26','2023-01-19 08:38:15',0),(22,2,'2023-01-19','08:39:38','2023-01-20','08:39:58',310.0000,716.5000,406.5000,0,'efectivo','2023-01-19 08:39:38','2023-01-20 08:39:58',0),(23,2,'2023-01-20','08:40:18','2023-01-20','21:29:30',0.0000,322.1000,322.1000,0,NULL,'2023-01-20 08:40:18','2023-01-20 21:29:30',0),(24,2,'2023-01-22','13:05:46','2023-01-23','13:00:13',10.0000,88.2000,78.2000,0,NULL,'2023-01-22 13:05:46','2023-01-23 13:00:13',0),(25,2,'2023-01-23','13:00:29','2023-01-27','09:00:40',10.0000,481.9000,471.9000,0,NULL,'2023-01-23 13:00:29','2023-01-27 09:00:40',0),(26,2,'2023-01-27','09:00:53','2023-01-30','08:55:50',90.5000,384.2000,293.7000,0,NULL,'2023-01-27 09:00:53','2023-01-30 08:55:50',0),(27,2,'2023-01-30','08:56:16','2023-01-31','08:14:09',85.0000,157.4000,72.4000,0,'30-01-23','2023-01-30 08:56:16','2023-01-31 08:14:09',0),(28,2,'2023-01-31','08:15:52','2023-02-03','09:16:41',30.0000,645.6000,615.6000,0,'31-01-23','2023-01-31 08:15:52','2023-02-03 09:16:41',0),(29,2,'2023-02-03','09:17:30','2023-02-19','13:24:07',39.0000,1976.9900,1937.9900,0,'03-02-23','2023-02-03 09:17:30','2023-02-19 13:24:08',0),(30,2,'2023-02-19','13:24:41','2023-02-20','12:50:44',0.1000,448.1500,448.0500,0,'retiro alm','2023-02-19 13:24:41','2023-02-20 12:50:45',0),(31,2,'2023-02-20','21:42:31','2023-02-21','08:50:23',0.5000,175.0000,174.5000,0,NULL,'2023-02-20 21:42:31','2023-02-21 08:50:23',0),(32,2,'2023-02-21','08:54:32','2023-02-22','08:33:58',0.1000,322.0000,321.9000,0,NULL,'2023-02-21 08:54:32','2023-02-22 08:33:58',0),(33,2,'2023-02-22','08:58:59','2023-02-22','14:26:32',0.5000,49.6000,49.1000,0,NULL,'2023-02-22 08:58:59','2023-02-22 14:26:32',0),(34,2,'2023-02-22','14:26:53','2023-02-26','11:15:03',0.5000,2798.6700,2798.1700,0,NULL,'2023-02-22 14:26:53','2023-02-26 11:15:03',0),(35,2,'2023-02-26','11:15:20','2023-02-27','08:29:55',10.0000,331.3500,321.3500,0,NULL,'2023-02-26 11:15:20','2023-02-27 08:29:56',0),(36,2,'2023-02-27','08:30:38',NULL,NULL,0.5000,0.0000,0.0000,1,NULL,'2023-02-27 08:30:38','2023-02-27 08:30:38',0);

--
-- Table structure for table `cash_document_credits`
--

CREATE TABLE `cash_document_credits` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cash_id` int(10) unsigned NOT NULL,
  `cash_id_processed` int(10) unsigned DEFAULT NULL,
  `document_id` int(10) unsigned DEFAULT NULL,
  `sale_note_id` int(10) unsigned DEFAULT NULL,
  `status` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cash_document_credits_document_id_foreign` (`document_id`),
  KEY `cash_document_credits_sale_note_id_foreign` (`sale_note_id`),
  KEY `cash_document_credits_cash_id_foreign` (`cash_id`),
  CONSTRAINT `cash_document_credits_cash_id_foreign` FOREIGN KEY (`cash_id`) REFERENCES `cash` (`id`),
  CONSTRAINT `cash_document_credits_document_id_foreign` FOREIGN KEY (`document_id`) REFERENCES `documents` (`id`),
  CONSTRAINT `cash_document_credits_sale_note_id_foreign` FOREIGN KEY (`sale_note_id`) REFERENCES `sale_notes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cash_document_credits`
--


--
-- Table structure for table `cash_documents`
--

CREATE TABLE `cash_documents` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cash_id` int(10) unsigned NOT NULL,
  `document_id` int(10) unsigned DEFAULT NULL,
  `sale_note_id` int(10) unsigned DEFAULT NULL,
  `technical_service_id` int(10) unsigned DEFAULT NULL,
  `expense_payment_id` int(10) unsigned DEFAULT NULL,
  `purchase_id` int(10) unsigned DEFAULT NULL,
  `bank_loan_payment_id` int(10) unsigned DEFAULT NULL,
  `quotation_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cash_documents_cash_id_foreign` (`cash_id`),
  KEY `cash_documents_document_id_foreign` (`document_id`),
  KEY `cash_documents_sale_note_id_foreign` (`sale_note_id`),
  KEY `cash_documents_expense_payment_id_foreign` (`expense_payment_id`),
  KEY `cash_documents_technical_service_id_foreign` (`technical_service_id`),
  KEY `cash_documents_purchase_id_foreign` (`purchase_id`),
  KEY `cash_documents_quotation_id_foreign` (`quotation_id`),
  CONSTRAINT `cash_documents_cash_id_foreign` FOREIGN KEY (`cash_id`) REFERENCES `cash` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cash_documents_document_id_foreign` FOREIGN KEY (`document_id`) REFERENCES `documents` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cash_documents_expense_payment_id_foreign` FOREIGN KEY (`expense_payment_id`) REFERENCES `expense_payments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cash_documents_purchase_id_foreign` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cash_documents_quotation_id_foreign` FOREIGN KEY (`quotation_id`) REFERENCES `quotations` (`id`),
  CONSTRAINT `cash_documents_sale_note_id_foreign` FOREIGN KEY (`sale_note_id`) REFERENCES `sale_notes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cash_documents_technical_service_id_foreign` FOREIGN KEY (`technical_service_id`) REFERENCES `technical_services` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=501 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cash_documents`
--

INSERT INTO `cash_documents` VALUES (1,1,1,NULL,NULL,NULL,NULL,NULL,NULL),(2,2,2,NULL,NULL,NULL,NULL,NULL,NULL),(4,3,4,NULL,NULL,NULL,NULL,NULL,NULL),(6,3,5,NULL,NULL,NULL,NULL,NULL,NULL),(7,2,6,NULL,NULL,NULL,NULL,NULL,NULL),(8,2,7,NULL,NULL,NULL,NULL,NULL,NULL),(9,2,8,NULL,NULL,NULL,NULL,NULL,NULL),(10,2,9,NULL,NULL,NULL,NULL,NULL,NULL),(11,4,10,NULL,NULL,NULL,NULL,NULL,NULL),(12,4,11,NULL,NULL,NULL,NULL,NULL,NULL),(13,4,NULL,NULL,NULL,NULL,NULL,NULL,1),(14,4,NULL,NULL,NULL,NULL,NULL,NULL,2),(15,4,NULL,NULL,NULL,NULL,NULL,NULL,3),(16,4,NULL,NULL,NULL,NULL,NULL,NULL,4),(17,4,NULL,NULL,NULL,NULL,NULL,NULL,5),(18,4,NULL,NULL,NULL,NULL,NULL,NULL,6),(19,4,NULL,NULL,NULL,NULL,NULL,NULL,7),(20,4,12,NULL,NULL,NULL,NULL,NULL,NULL),(21,4,13,NULL,NULL,NULL,NULL,NULL,NULL),(22,5,14,NULL,NULL,NULL,NULL,NULL,NULL),(23,5,15,NULL,NULL,NULL,NULL,NULL,NULL),(24,5,16,NULL,NULL,NULL,NULL,NULL,NULL),(25,5,NULL,NULL,NULL,NULL,NULL,NULL,8),(26,5,17,NULL,NULL,NULL,NULL,NULL,NULL),(27,5,18,NULL,NULL,NULL,NULL,NULL,NULL),(28,5,19,NULL,NULL,NULL,NULL,NULL,NULL),(29,6,20,NULL,NULL,NULL,NULL,NULL,NULL),(30,6,21,NULL,NULL,NULL,NULL,NULL,NULL),(31,6,NULL,NULL,NULL,NULL,NULL,NULL,9),(32,6,22,NULL,NULL,NULL,NULL,NULL,NULL),(33,6,23,NULL,NULL,NULL,NULL,NULL,NULL),(34,6,24,NULL,NULL,NULL,NULL,NULL,NULL),(35,6,25,NULL,NULL,NULL,NULL,NULL,NULL),(36,6,26,NULL,NULL,NULL,NULL,NULL,NULL),(37,6,27,NULL,NULL,NULL,NULL,NULL,NULL),(38,7,28,NULL,NULL,NULL,NULL,NULL,NULL),(39,7,29,NULL,NULL,NULL,NULL,NULL,NULL),(40,7,30,NULL,NULL,NULL,NULL,NULL,NULL),(41,7,31,NULL,NULL,NULL,NULL,NULL,NULL),(42,7,NULL,NULL,NULL,NULL,NULL,NULL,10),(43,7,NULL,NULL,NULL,NULL,NULL,NULL,11),(44,7,32,NULL,NULL,NULL,NULL,NULL,NULL),(45,7,33,NULL,NULL,NULL,NULL,NULL,NULL),(46,7,34,NULL,NULL,NULL,NULL,NULL,NULL),(47,7,35,NULL,NULL,NULL,NULL,NULL,NULL),(48,7,36,NULL,NULL,NULL,NULL,NULL,NULL),(49,7,37,NULL,NULL,NULL,NULL,NULL,NULL),(50,7,38,NULL,NULL,NULL,NULL,NULL,NULL),(51,7,39,NULL,NULL,NULL,NULL,NULL,NULL),(52,7,40,NULL,NULL,NULL,NULL,NULL,NULL),(53,7,41,NULL,NULL,NULL,NULL,NULL,NULL),(54,7,42,NULL,NULL,NULL,NULL,NULL,NULL),(55,8,43,NULL,NULL,NULL,NULL,NULL,NULL),(56,8,44,NULL,NULL,NULL,NULL,NULL,NULL),(57,8,45,NULL,NULL,NULL,NULL,NULL,NULL),(58,8,46,NULL,NULL,NULL,NULL,NULL,NULL),(59,8,47,NULL,NULL,NULL,NULL,NULL,NULL),(60,9,48,NULL,NULL,NULL,NULL,NULL,NULL),(61,9,49,NULL,NULL,NULL,NULL,NULL,NULL),(62,9,50,NULL,NULL,NULL,NULL,NULL,NULL),(63,9,51,NULL,NULL,NULL,NULL,NULL,NULL),(64,9,52,NULL,NULL,NULL,NULL,NULL,NULL),(65,9,53,NULL,NULL,NULL,NULL,NULL,NULL),(66,9,54,NULL,NULL,NULL,NULL,NULL,NULL),(67,9,55,NULL,NULL,NULL,NULL,NULL,NULL),(68,10,56,NULL,NULL,NULL,NULL,NULL,NULL),(69,10,57,NULL,NULL,NULL,NULL,NULL,NULL),(70,10,58,NULL,NULL,NULL,NULL,NULL,NULL),(71,10,59,NULL,NULL,NULL,NULL,NULL,NULL),(72,10,60,NULL,NULL,NULL,NULL,NULL,NULL),(73,10,61,NULL,NULL,NULL,NULL,NULL,NULL),(74,10,62,NULL,NULL,NULL,NULL,NULL,NULL),(75,10,63,NULL,NULL,NULL,NULL,NULL,NULL),(76,10,NULL,NULL,NULL,NULL,NULL,NULL,12),(77,10,NULL,NULL,NULL,NULL,NULL,NULL,13),(78,10,64,NULL,NULL,NULL,NULL,NULL,NULL),(79,10,65,NULL,NULL,NULL,NULL,NULL,NULL),(80,10,66,NULL,NULL,NULL,NULL,NULL,NULL),(81,11,67,NULL,NULL,NULL,NULL,NULL,NULL),(82,11,68,NULL,NULL,NULL,NULL,NULL,NULL),(83,11,69,NULL,NULL,NULL,NULL,NULL,NULL),(84,11,70,NULL,NULL,NULL,NULL,NULL,NULL),(85,11,71,NULL,NULL,NULL,NULL,NULL,NULL),(86,11,72,NULL,NULL,NULL,NULL,NULL,NULL),(87,11,73,NULL,NULL,NULL,NULL,NULL,NULL),(88,11,74,NULL,NULL,NULL,NULL,NULL,NULL),(89,11,75,NULL,NULL,NULL,NULL,NULL,NULL),(90,11,76,NULL,NULL,NULL,NULL,NULL,NULL),(91,12,77,NULL,NULL,NULL,NULL,NULL,NULL),(92,12,78,NULL,NULL,NULL,NULL,NULL,NULL),(93,12,79,NULL,NULL,NULL,NULL,NULL,NULL),(94,12,80,NULL,NULL,NULL,NULL,NULL,NULL),(95,12,NULL,NULL,NULL,NULL,NULL,NULL,14),(96,12,NULL,NULL,NULL,NULL,NULL,NULL,15),(97,12,NULL,NULL,NULL,NULL,NULL,NULL,16),(98,12,81,NULL,NULL,NULL,NULL,NULL,NULL),(99,12,82,NULL,NULL,NULL,NULL,NULL,NULL),(100,13,83,NULL,NULL,NULL,NULL,NULL,NULL),(101,13,84,NULL,NULL,NULL,NULL,NULL,NULL),(102,13,85,NULL,NULL,NULL,NULL,NULL,NULL),(103,13,NULL,NULL,NULL,NULL,1,NULL,NULL),(104,13,86,NULL,NULL,NULL,NULL,NULL,NULL),(105,13,87,NULL,NULL,NULL,NULL,NULL,NULL),(106,13,88,NULL,NULL,NULL,NULL,NULL,NULL),(107,13,89,NULL,NULL,NULL,NULL,NULL,NULL),(108,13,90,NULL,NULL,NULL,NULL,NULL,NULL),(109,13,91,NULL,NULL,NULL,NULL,NULL,NULL),(110,13,92,NULL,NULL,NULL,NULL,NULL,NULL),(111,13,93,NULL,NULL,NULL,NULL,NULL,NULL),(112,13,94,NULL,NULL,NULL,NULL,NULL,NULL),(113,13,95,NULL,NULL,NULL,NULL,NULL,NULL),(114,13,96,NULL,NULL,NULL,NULL,NULL,NULL),(115,13,97,NULL,NULL,NULL,NULL,NULL,NULL),(116,13,98,NULL,NULL,NULL,NULL,NULL,NULL),(117,13,99,NULL,NULL,NULL,NULL,NULL,NULL),(118,14,100,NULL,NULL,NULL,NULL,NULL,NULL),(119,14,101,NULL,NULL,NULL,NULL,NULL,NULL),(120,14,102,NULL,NULL,NULL,NULL,NULL,NULL),(121,14,103,NULL,NULL,NULL,NULL,NULL,NULL),(122,14,104,NULL,NULL,NULL,NULL,NULL,NULL),(123,14,105,NULL,NULL,NULL,NULL,NULL,NULL),(124,14,106,NULL,NULL,NULL,NULL,NULL,NULL),(125,14,107,NULL,NULL,NULL,NULL,NULL,NULL),(126,14,108,NULL,NULL,NULL,NULL,NULL,NULL),(127,14,109,NULL,NULL,NULL,NULL,NULL,NULL),(128,14,110,NULL,NULL,NULL,NULL,NULL,NULL),(129,14,111,NULL,NULL,NULL,NULL,NULL,NULL),(130,14,112,NULL,NULL,NULL,NULL,NULL,NULL),(131,14,113,NULL,NULL,NULL,NULL,NULL,NULL),(132,14,114,NULL,NULL,NULL,NULL,NULL,NULL),(133,14,NULL,NULL,NULL,NULL,NULL,NULL,17),(134,14,NULL,NULL,NULL,NULL,NULL,NULL,18),(135,14,115,NULL,NULL,NULL,NULL,NULL,NULL),(136,14,116,NULL,NULL,NULL,NULL,NULL,NULL),(137,14,117,NULL,NULL,NULL,NULL,NULL,NULL),(138,14,118,NULL,NULL,NULL,NULL,NULL,NULL),(139,14,119,NULL,NULL,NULL,NULL,NULL,NULL),(140,14,120,NULL,NULL,NULL,NULL,NULL,NULL),(141,14,121,NULL,NULL,NULL,NULL,NULL,NULL),(142,14,122,NULL,NULL,NULL,NULL,NULL,NULL),(143,14,123,NULL,NULL,NULL,NULL,NULL,NULL),(144,14,124,NULL,NULL,NULL,NULL,NULL,NULL),(145,15,125,NULL,NULL,NULL,NULL,NULL,NULL),(146,15,126,NULL,NULL,NULL,NULL,NULL,NULL),(147,15,127,NULL,NULL,NULL,NULL,NULL,NULL),(148,15,NULL,NULL,NULL,NULL,NULL,NULL,19),(149,15,NULL,NULL,NULL,NULL,NULL,NULL,20),(150,15,128,NULL,NULL,NULL,NULL,NULL,NULL),(151,15,129,NULL,NULL,NULL,NULL,NULL,NULL),(152,15,130,NULL,NULL,NULL,NULL,NULL,NULL),(153,15,131,NULL,NULL,NULL,NULL,NULL,NULL),(154,15,132,NULL,NULL,NULL,NULL,NULL,NULL),(155,15,NULL,NULL,NULL,NULL,NULL,NULL,21),(156,15,133,NULL,NULL,NULL,NULL,NULL,NULL),(157,15,134,NULL,NULL,NULL,NULL,NULL,NULL),(158,15,NULL,NULL,NULL,NULL,NULL,NULL,22),(159,15,135,NULL,NULL,NULL,NULL,NULL,NULL),(160,15,NULL,NULL,NULL,NULL,NULL,NULL,23),(161,15,NULL,NULL,NULL,NULL,NULL,NULL,24),(162,15,136,NULL,NULL,NULL,NULL,NULL,NULL),(163,15,NULL,1,NULL,NULL,NULL,NULL,NULL),(164,15,137,NULL,NULL,NULL,NULL,NULL,NULL),(165,15,138,NULL,NULL,NULL,NULL,NULL,NULL),(166,15,NULL,NULL,NULL,NULL,NULL,NULL,25),(167,15,139,NULL,NULL,NULL,NULL,NULL,NULL),(168,15,140,NULL,NULL,NULL,NULL,NULL,NULL),(169,15,141,NULL,NULL,NULL,NULL,NULL,NULL),(170,15,142,NULL,NULL,NULL,NULL,NULL,NULL),(171,15,145,NULL,NULL,NULL,NULL,NULL,NULL),(172,16,149,NULL,NULL,NULL,NULL,NULL,NULL),(173,16,150,NULL,NULL,NULL,NULL,NULL,NULL),(174,16,151,NULL,NULL,NULL,NULL,NULL,NULL),(175,16,152,NULL,NULL,NULL,NULL,NULL,NULL),(176,16,153,NULL,NULL,NULL,NULL,NULL,NULL),(177,16,154,NULL,NULL,NULL,NULL,NULL,NULL),(178,16,155,NULL,NULL,NULL,NULL,NULL,NULL),(179,16,156,NULL,NULL,NULL,NULL,NULL,NULL),(180,16,157,NULL,NULL,NULL,NULL,NULL,NULL),(181,16,158,NULL,NULL,NULL,NULL,NULL,NULL),(182,16,159,NULL,NULL,NULL,NULL,NULL,NULL),(183,16,160,NULL,NULL,NULL,NULL,NULL,NULL),(184,16,161,NULL,NULL,NULL,NULL,NULL,NULL),(185,16,162,NULL,NULL,NULL,NULL,NULL,NULL),(186,16,163,NULL,NULL,NULL,NULL,NULL,NULL),(187,16,164,NULL,NULL,NULL,NULL,NULL,NULL),(188,16,165,NULL,NULL,NULL,NULL,NULL,NULL),(189,16,166,NULL,NULL,NULL,NULL,NULL,NULL),(190,16,167,NULL,NULL,NULL,NULL,NULL,NULL),(191,16,168,NULL,NULL,NULL,NULL,NULL,NULL),(192,16,169,NULL,NULL,NULL,NULL,NULL,NULL),(193,16,170,NULL,NULL,NULL,NULL,NULL,NULL),(194,16,171,NULL,NULL,NULL,NULL,NULL,NULL),(195,16,172,NULL,NULL,NULL,NULL,NULL,NULL),(196,16,173,NULL,NULL,NULL,NULL,NULL,NULL),(197,16,174,NULL,NULL,NULL,NULL,NULL,NULL),(198,16,175,NULL,NULL,NULL,NULL,NULL,NULL),(199,16,NULL,NULL,NULL,NULL,NULL,NULL,26),(200,16,NULL,NULL,NULL,NULL,NULL,NULL,27),(201,16,176,NULL,NULL,NULL,NULL,NULL,NULL),(202,16,177,NULL,NULL,NULL,NULL,NULL,NULL),(203,16,178,NULL,NULL,NULL,NULL,NULL,NULL),(204,16,179,NULL,NULL,NULL,NULL,NULL,NULL),(205,16,180,NULL,NULL,NULL,NULL,NULL,NULL),(206,16,181,NULL,NULL,NULL,NULL,NULL,NULL),(207,16,182,NULL,NULL,NULL,NULL,NULL,NULL),(208,16,183,NULL,NULL,NULL,NULL,NULL,NULL),(209,16,184,NULL,NULL,NULL,NULL,NULL,NULL),(210,16,185,NULL,NULL,NULL,NULL,NULL,NULL),(211,16,NULL,NULL,NULL,NULL,NULL,NULL,28),(212,16,NULL,NULL,NULL,NULL,NULL,NULL,29),(213,16,186,NULL,NULL,NULL,NULL,NULL,NULL),(214,16,187,NULL,NULL,NULL,NULL,NULL,NULL),(215,16,188,NULL,NULL,NULL,NULL,NULL,NULL),(216,16,189,NULL,NULL,NULL,NULL,NULL,NULL),(217,16,190,NULL,NULL,NULL,NULL,NULL,NULL),(218,16,191,NULL,NULL,NULL,NULL,NULL,NULL),(219,16,192,NULL,NULL,NULL,NULL,NULL,NULL),(220,16,193,NULL,NULL,NULL,NULL,NULL,NULL),(221,16,194,NULL,NULL,NULL,NULL,NULL,NULL),(222,16,195,NULL,NULL,NULL,NULL,NULL,NULL),(223,16,196,NULL,NULL,NULL,NULL,NULL,NULL),(224,16,197,NULL,NULL,NULL,NULL,NULL,NULL),(225,16,198,NULL,NULL,NULL,NULL,NULL,NULL),(226,16,199,NULL,NULL,NULL,NULL,NULL,NULL),(227,16,200,NULL,NULL,NULL,NULL,NULL,NULL),(228,16,NULL,NULL,NULL,NULL,NULL,NULL,30),(229,16,201,NULL,NULL,NULL,NULL,NULL,NULL),(230,16,202,NULL,NULL,NULL,NULL,NULL,NULL),(231,16,203,NULL,NULL,NULL,NULL,NULL,NULL),(232,16,207,NULL,NULL,NULL,NULL,NULL,NULL),(233,16,208,NULL,NULL,NULL,NULL,NULL,NULL),(234,16,NULL,NULL,NULL,NULL,NULL,NULL,31),(235,16,209,NULL,NULL,NULL,NULL,NULL,NULL),(236,16,210,NULL,NULL,NULL,NULL,NULL,NULL),(237,16,211,NULL,NULL,NULL,NULL,NULL,NULL),(238,16,212,NULL,NULL,NULL,NULL,NULL,NULL),(239,16,213,NULL,NULL,NULL,NULL,NULL,NULL),(240,16,NULL,NULL,NULL,NULL,3,NULL,NULL),(241,16,214,NULL,NULL,NULL,NULL,NULL,NULL),(242,16,215,NULL,NULL,NULL,NULL,NULL,NULL),(243,16,216,NULL,NULL,NULL,NULL,NULL,NULL),(244,16,217,NULL,NULL,NULL,NULL,NULL,NULL),(245,16,218,NULL,NULL,NULL,NULL,NULL,NULL),(246,16,219,NULL,NULL,NULL,NULL,NULL,NULL),(247,16,NULL,NULL,NULL,NULL,NULL,NULL,33),(248,16,220,NULL,NULL,NULL,NULL,NULL,NULL),(249,16,221,NULL,NULL,NULL,NULL,NULL,NULL),(250,16,222,NULL,NULL,NULL,NULL,NULL,NULL),(251,16,223,NULL,NULL,NULL,NULL,NULL,NULL),(252,16,224,NULL,NULL,NULL,NULL,NULL,NULL),(253,16,225,NULL,NULL,NULL,NULL,NULL,NULL),(254,16,NULL,NULL,NULL,NULL,NULL,NULL,34),(255,16,NULL,NULL,NULL,NULL,NULL,NULL,35),(256,16,226,NULL,NULL,NULL,NULL,NULL,NULL),(257,16,227,NULL,NULL,NULL,NULL,NULL,NULL),(258,16,228,NULL,NULL,NULL,NULL,NULL,NULL),(259,16,229,NULL,NULL,NULL,NULL,NULL,NULL),(260,16,230,NULL,NULL,NULL,NULL,NULL,NULL),(261,16,NULL,NULL,NULL,NULL,4,NULL,NULL),(262,16,NULL,NULL,NULL,NULL,5,NULL,NULL),(263,16,231,NULL,NULL,NULL,NULL,NULL,NULL),(264,16,232,NULL,NULL,NULL,NULL,NULL,NULL),(265,16,NULL,NULL,NULL,NULL,6,NULL,NULL),(266,16,NULL,NULL,NULL,NULL,7,NULL,NULL),(267,16,NULL,NULL,NULL,NULL,8,NULL,NULL),(268,16,233,NULL,NULL,NULL,NULL,NULL,NULL),(269,16,234,NULL,NULL,NULL,NULL,NULL,NULL),(270,16,NULL,NULL,NULL,NULL,9,NULL,NULL),(271,16,235,NULL,NULL,NULL,NULL,NULL,NULL),(272,16,NULL,NULL,NULL,NULL,10,NULL,NULL),(273,16,NULL,NULL,NULL,NULL,11,NULL,NULL),(274,16,236,NULL,NULL,NULL,NULL,NULL,NULL),(275,16,NULL,NULL,NULL,NULL,NULL,NULL,36),(276,16,237,NULL,NULL,NULL,NULL,NULL,NULL),(277,16,238,NULL,NULL,NULL,NULL,NULL,NULL),(278,16,239,NULL,NULL,NULL,NULL,NULL,NULL),(279,16,240,NULL,NULL,NULL,NULL,NULL,NULL),(280,16,241,NULL,NULL,NULL,NULL,NULL,NULL),(281,16,242,NULL,NULL,NULL,NULL,NULL,NULL),(282,16,243,NULL,NULL,NULL,NULL,NULL,NULL),(283,16,244,NULL,NULL,NULL,NULL,NULL,NULL),(284,16,245,NULL,NULL,NULL,NULL,NULL,NULL),(285,16,246,NULL,NULL,NULL,NULL,NULL,NULL),(286,16,NULL,NULL,NULL,NULL,NULL,NULL,37),(287,16,247,NULL,NULL,NULL,NULL,NULL,NULL),(288,16,248,NULL,NULL,NULL,NULL,NULL,NULL),(289,16,249,NULL,NULL,NULL,NULL,NULL,NULL),(290,16,250,NULL,NULL,NULL,NULL,NULL,NULL),(291,16,251,NULL,NULL,NULL,NULL,NULL,NULL),(292,16,252,NULL,NULL,NULL,NULL,NULL,NULL),(293,16,253,NULL,NULL,NULL,NULL,NULL,NULL),(294,16,254,NULL,NULL,NULL,NULL,NULL,NULL),(295,16,255,NULL,NULL,NULL,NULL,NULL,NULL),(296,16,256,NULL,NULL,NULL,NULL,NULL,NULL),(297,16,257,NULL,NULL,NULL,NULL,NULL,NULL),(298,16,258,NULL,NULL,NULL,NULL,NULL,NULL),(299,17,259,NULL,NULL,NULL,NULL,NULL,NULL),(300,17,NULL,NULL,NULL,NULL,12,NULL,NULL),(301,17,NULL,NULL,NULL,NULL,13,NULL,NULL),(302,17,NULL,NULL,NULL,NULL,14,NULL,NULL),(303,17,NULL,NULL,NULL,NULL,15,NULL,NULL),(304,17,NULL,NULL,NULL,NULL,16,NULL,NULL),(305,17,260,NULL,NULL,NULL,NULL,NULL,NULL),(306,18,261,NULL,NULL,NULL,NULL,NULL,NULL),(307,18,262,NULL,NULL,NULL,NULL,NULL,NULL),(308,18,263,NULL,NULL,NULL,NULL,NULL,NULL),(309,18,264,NULL,NULL,NULL,NULL,NULL,NULL),(310,18,265,NULL,NULL,NULL,NULL,NULL,NULL),(311,18,266,NULL,NULL,NULL,NULL,NULL,NULL),(312,18,267,NULL,NULL,NULL,NULL,NULL,NULL),(313,18,268,NULL,NULL,NULL,NULL,NULL,NULL),(314,18,269,NULL,NULL,NULL,NULL,NULL,NULL),(315,18,270,NULL,NULL,NULL,NULL,NULL,NULL),(316,18,271,NULL,NULL,NULL,NULL,NULL,NULL),(317,18,272,NULL,NULL,NULL,NULL,NULL,NULL),(318,18,NULL,NULL,NULL,NULL,NULL,NULL,38),(319,18,NULL,NULL,NULL,NULL,NULL,NULL,39),(320,18,NULL,NULL,NULL,NULL,17,NULL,NULL),(321,18,NULL,NULL,NULL,NULL,NULL,NULL,40),(322,18,NULL,NULL,NULL,NULL,NULL,NULL,41),(323,18,273,NULL,NULL,NULL,NULL,NULL,NULL),(324,18,274,NULL,NULL,NULL,NULL,NULL,NULL),(325,19,NULL,NULL,NULL,NULL,NULL,NULL,42),(326,19,NULL,NULL,NULL,NULL,NULL,NULL,43),(327,19,NULL,NULL,NULL,NULL,NULL,NULL,44),(328,19,NULL,NULL,NULL,NULL,NULL,NULL,45),(329,19,275,NULL,NULL,NULL,NULL,NULL,NULL),(330,19,276,NULL,NULL,NULL,NULL,NULL,NULL),(331,19,277,NULL,NULL,NULL,NULL,NULL,NULL),(332,19,278,NULL,NULL,NULL,NULL,NULL,NULL),(333,19,279,NULL,NULL,NULL,NULL,NULL,NULL),(334,19,NULL,NULL,NULL,NULL,NULL,NULL,46),(335,19,280,NULL,NULL,NULL,NULL,NULL,NULL),(336,19,NULL,NULL,NULL,NULL,NULL,NULL,47),(337,19,281,NULL,NULL,NULL,NULL,NULL,NULL),(338,19,282,NULL,NULL,NULL,NULL,NULL,NULL),(339,19,283,NULL,NULL,NULL,NULL,NULL,NULL),(340,20,284,NULL,NULL,NULL,NULL,NULL,NULL),(341,20,285,NULL,NULL,NULL,NULL,NULL,NULL),(342,20,286,NULL,NULL,NULL,NULL,NULL,NULL),(343,20,287,NULL,NULL,NULL,NULL,NULL,NULL),(344,20,288,NULL,NULL,NULL,NULL,NULL,NULL),(345,20,289,NULL,NULL,NULL,NULL,NULL,NULL),(346,20,290,NULL,NULL,NULL,NULL,NULL,NULL),(347,20,291,NULL,NULL,NULL,NULL,NULL,NULL),(348,20,292,NULL,NULL,NULL,NULL,NULL,NULL),(349,20,293,NULL,NULL,NULL,NULL,NULL,NULL),(350,20,294,NULL,NULL,NULL,NULL,NULL,NULL),(351,21,295,NULL,NULL,NULL,NULL,NULL,NULL),(352,22,296,NULL,NULL,NULL,NULL,NULL,NULL),(353,22,NULL,NULL,NULL,NULL,NULL,NULL,48),(354,22,297,NULL,NULL,NULL,NULL,NULL,NULL),(355,22,298,NULL,NULL,NULL,NULL,NULL,NULL),(356,23,NULL,NULL,NULL,NULL,18,NULL,NULL),(357,23,NULL,NULL,NULL,NULL,19,NULL,NULL),(358,23,NULL,NULL,NULL,NULL,NULL,NULL,49),(359,23,299,NULL,NULL,NULL,NULL,NULL,NULL),(360,23,300,NULL,NULL,NULL,NULL,NULL,NULL),(361,23,301,NULL,NULL,NULL,NULL,NULL,NULL),(362,24,302,NULL,NULL,NULL,NULL,NULL,NULL),(363,24,303,NULL,NULL,NULL,NULL,NULL,NULL),(364,24,NULL,NULL,NULL,NULL,NULL,NULL,50),(365,24,NULL,NULL,NULL,NULL,NULL,NULL,51),(366,25,304,NULL,NULL,NULL,NULL,NULL,NULL),(367,25,305,NULL,NULL,NULL,NULL,NULL,NULL),(368,25,306,NULL,NULL,NULL,NULL,NULL,NULL),(369,25,307,NULL,NULL,NULL,NULL,NULL,NULL),(370,25,308,NULL,NULL,NULL,NULL,NULL,NULL),(371,25,NULL,NULL,NULL,NULL,20,NULL,NULL),(372,25,NULL,NULL,NULL,NULL,21,NULL,NULL),(373,25,NULL,NULL,NULL,NULL,22,NULL,NULL),(374,25,309,NULL,NULL,NULL,NULL,NULL,NULL),(375,25,310,NULL,NULL,NULL,NULL,NULL,NULL),(376,25,NULL,NULL,NULL,NULL,NULL,NULL,53),(377,25,NULL,NULL,NULL,NULL,NULL,NULL,55),(378,25,311,NULL,NULL,NULL,NULL,NULL,NULL),(379,25,NULL,NULL,NULL,NULL,23,NULL,NULL),(380,25,NULL,NULL,NULL,NULL,24,NULL,NULL),(381,25,NULL,NULL,NULL,NULL,25,NULL,NULL),(382,25,312,NULL,NULL,NULL,NULL,NULL,NULL),(383,25,313,NULL,NULL,NULL,NULL,NULL,NULL),(384,25,314,NULL,NULL,NULL,NULL,NULL,NULL),(385,25,NULL,NULL,NULL,NULL,26,NULL,NULL),(386,25,NULL,NULL,NULL,NULL,NULL,NULL,56),(388,26,NULL,NULL,NULL,NULL,28,NULL,NULL),(389,26,315,NULL,NULL,NULL,NULL,NULL,NULL),(390,26,316,NULL,NULL,NULL,NULL,NULL,NULL),(391,26,317,NULL,NULL,NULL,NULL,NULL,NULL),(392,26,318,NULL,NULL,NULL,NULL,NULL,NULL),(393,26,319,NULL,NULL,NULL,NULL,NULL,NULL),(394,26,320,NULL,NULL,NULL,NULL,NULL,NULL),(395,27,321,NULL,NULL,NULL,NULL,NULL,NULL),(396,27,322,NULL,NULL,NULL,NULL,NULL,NULL),(397,27,323,NULL,NULL,NULL,NULL,NULL,NULL),(398,28,324,NULL,NULL,NULL,NULL,NULL,NULL),(399,28,325,NULL,NULL,NULL,NULL,NULL,NULL),(400,28,326,NULL,NULL,NULL,NULL,NULL,NULL),(401,28,327,NULL,NULL,NULL,NULL,NULL,NULL),(402,28,329,NULL,NULL,NULL,NULL,NULL,NULL),(403,28,NULL,NULL,NULL,NULL,NULL,NULL,57),(404,28,NULL,NULL,NULL,NULL,29,NULL,NULL),(405,28,NULL,NULL,NULL,NULL,30,NULL,NULL),(406,28,NULL,NULL,NULL,NULL,31,NULL,NULL),(407,28,NULL,NULL,NULL,NULL,32,NULL,NULL),(408,28,330,NULL,NULL,NULL,NULL,NULL,NULL),(409,28,331,NULL,NULL,NULL,NULL,NULL,NULL),(410,28,332,NULL,NULL,NULL,NULL,NULL,NULL),(411,29,333,NULL,NULL,NULL,NULL,NULL,NULL),(412,29,334,NULL,NULL,NULL,NULL,NULL,NULL),(413,29,NULL,NULL,NULL,NULL,33,NULL,NULL),(414,29,NULL,NULL,NULL,NULL,34,NULL,NULL),(415,29,NULL,NULL,NULL,NULL,35,NULL,NULL),(416,29,335,NULL,NULL,NULL,NULL,NULL,NULL),(417,29,336,NULL,NULL,NULL,NULL,NULL,NULL),(418,29,337,NULL,NULL,NULL,NULL,NULL,NULL),(419,29,338,NULL,NULL,NULL,NULL,NULL,NULL),(420,29,NULL,NULL,NULL,NULL,NULL,NULL,58),(421,29,NULL,NULL,NULL,NULL,36,NULL,NULL),(422,29,339,NULL,NULL,NULL,NULL,NULL,NULL),(423,29,340,NULL,NULL,NULL,NULL,NULL,NULL),(424,29,341,NULL,NULL,NULL,NULL,NULL,NULL),(425,29,342,NULL,NULL,NULL,NULL,NULL,NULL),(426,29,343,NULL,NULL,NULL,NULL,NULL,NULL),(427,29,NULL,NULL,NULL,NULL,37,NULL,NULL),(428,29,NULL,NULL,NULL,NULL,38,NULL,NULL),(429,29,NULL,NULL,NULL,NULL,39,NULL,NULL),(430,29,NULL,NULL,NULL,NULL,40,NULL,NULL),(431,29,NULL,NULL,NULL,NULL,41,NULL,NULL),(432,29,NULL,NULL,NULL,NULL,42,NULL,NULL),(433,29,344,NULL,NULL,NULL,NULL,NULL,NULL),(434,29,NULL,NULL,NULL,NULL,43,NULL,NULL),(435,29,345,NULL,NULL,NULL,NULL,NULL,NULL),(436,29,NULL,NULL,NULL,NULL,44,NULL,NULL),(437,29,NULL,NULL,NULL,NULL,45,NULL,NULL),(438,29,346,NULL,NULL,NULL,NULL,NULL,NULL),(439,29,NULL,NULL,NULL,NULL,46,NULL,NULL),(440,29,NULL,NULL,NULL,NULL,47,NULL,NULL),(441,29,347,NULL,NULL,NULL,NULL,NULL,NULL),(442,29,348,NULL,NULL,NULL,NULL,NULL,NULL),(443,29,349,NULL,NULL,NULL,NULL,NULL,NULL),(444,29,NULL,NULL,NULL,NULL,NULL,NULL,59),(445,29,350,NULL,NULL,NULL,NULL,NULL,NULL),(446,29,351,NULL,NULL,NULL,NULL,NULL,NULL),(447,29,NULL,NULL,NULL,NULL,NULL,NULL,61),(448,29,352,NULL,NULL,NULL,NULL,NULL,NULL),(449,29,NULL,NULL,NULL,NULL,NULL,NULL,62),(450,29,353,NULL,NULL,NULL,NULL,NULL,NULL),(451,29,NULL,NULL,NULL,NULL,48,NULL,NULL),(452,29,354,NULL,NULL,NULL,NULL,NULL,NULL),(453,29,355,NULL,NULL,NULL,NULL,NULL,NULL),(454,29,356,NULL,NULL,NULL,NULL,NULL,NULL),(455,29,357,NULL,NULL,NULL,NULL,NULL,NULL),(456,30,358,NULL,NULL,NULL,NULL,NULL,NULL),(457,30,NULL,NULL,NULL,NULL,49,NULL,NULL),(458,30,359,NULL,NULL,NULL,NULL,NULL,NULL),(459,30,360,NULL,NULL,NULL,NULL,NULL,NULL),(460,30,361,NULL,NULL,NULL,NULL,NULL,NULL),(461,30,362,NULL,NULL,NULL,NULL,NULL,NULL),(462,30,363,NULL,NULL,NULL,NULL,NULL,NULL),(463,30,364,NULL,NULL,NULL,NULL,NULL,NULL),(464,30,365,NULL,NULL,NULL,NULL,NULL,NULL),(465,31,368,NULL,NULL,NULL,NULL,NULL,NULL),(466,32,369,NULL,NULL,NULL,NULL,NULL,NULL),(467,32,370,NULL,NULL,NULL,NULL,NULL,NULL),(468,32,371,NULL,NULL,NULL,NULL,NULL,NULL),(469,33,372,NULL,NULL,NULL,NULL,NULL,NULL),(470,33,373,NULL,NULL,NULL,NULL,NULL,NULL),(471,34,374,NULL,NULL,NULL,NULL,NULL,NULL),(472,34,375,NULL,NULL,NULL,NULL,NULL,NULL),(473,34,376,NULL,NULL,NULL,NULL,NULL,NULL),(474,34,377,NULL,NULL,NULL,NULL,NULL,NULL),(475,34,378,NULL,NULL,NULL,NULL,NULL,NULL),(476,34,379,NULL,NULL,NULL,NULL,NULL,NULL),(477,34,380,NULL,NULL,NULL,NULL,NULL,NULL),(478,34,381,NULL,NULL,NULL,NULL,NULL,NULL),(479,34,382,NULL,NULL,NULL,NULL,NULL,NULL),(480,34,NULL,NULL,NULL,NULL,53,NULL,NULL),(481,34,383,NULL,NULL,NULL,NULL,NULL,NULL),(482,34,384,NULL,NULL,NULL,NULL,NULL,NULL),(483,35,385,NULL,NULL,NULL,NULL,NULL,NULL),(484,35,386,NULL,NULL,NULL,NULL,NULL,NULL),(485,35,387,NULL,NULL,NULL,NULL,NULL,NULL),(486,35,NULL,NULL,NULL,NULL,NULL,NULL,64),(487,35,NULL,NULL,NULL,NULL,NULL,NULL,65),(488,35,NULL,NULL,NULL,NULL,54,NULL,NULL),(489,35,388,NULL,NULL,NULL,NULL,NULL,NULL),(490,36,389,NULL,NULL,NULL,NULL,NULL,NULL),(491,36,390,NULL,NULL,NULL,NULL,NULL,NULL),(492,36,391,NULL,NULL,NULL,NULL,NULL,NULL),(493,36,392,NULL,NULL,NULL,NULL,NULL,NULL),(494,36,393,NULL,NULL,NULL,NULL,NULL,NULL),(495,36,394,NULL,NULL,NULL,NULL,NULL,NULL),(496,36,395,NULL,NULL,NULL,NULL,NULL,NULL),(497,36,396,NULL,NULL,NULL,NULL,NULL,NULL),(498,36,397,NULL,NULL,NULL,NULL,NULL,NULL),(499,36,398,NULL,NULL,NULL,NULL,NULL,NULL),(500,36,399,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `cash_transactions`
--

CREATE TABLE `cash_transactions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cash_id` int(10) unsigned NOT NULL,
  `payment_method_type_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment` decimal(14,4) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `cash_transactions_cash_id_foreign` (`cash_id`),
  KEY `cash_transactions_payment_method_type_id_foreign` (`payment_method_type_id`),
  CONSTRAINT `cash_transactions_cash_id_foreign` FOREIGN KEY (`cash_id`) REFERENCES `cash` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cash_transactions_payment_method_type_id_foreign` FOREIGN KEY (`payment_method_type_id`) REFERENCES `payment_method_types` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cash_transactions`
--

INSERT INTO `cash_transactions` VALUES (1,1,'01','2022-11-29','Saldo inicial',0.0000),(2,2,'01','2022-11-29','Saldo inicial',30.0000),(3,3,'01','2022-11-29','Saldo inicial',0.0000),(4,4,'01','2022-11-30','Saldo inicial',50.0000),(5,5,'01','2022-12-01','Saldo inicial',50.0000),(7,6,'01','2022-12-04','Saldo inicial',50.0000),(8,7,'01','2022-12-04','Saldo inicial',140.0000),(9,8,'01','2022-12-06','Saldo inicial',163.5000),(10,9,'01','2022-12-07','Saldo inicial',50.0000),(11,10,'01','2022-12-08','Saldo inicial',50.0000),(12,11,'01','2022-12-09','Saldo inicial',139.0000),(13,12,'01','2022-12-11','Saldo inicial',50.0000),(14,13,'01','2022-12-12','Saldo inicial',60.5000),(15,14,'01','2022-12-14','Saldo inicial',38.0000),(16,15,'01','2022-12-18','Saldo inicial',81.5000),(17,16,'01','2022-12-20','Saldo inicial',100.0000),(18,17,'01','2023-01-06','Saldo inicial',56.5000),(19,18,'01','2023-01-08','Saldo inicial',50.0000),(20,19,'01','2023-01-12','Saldo inicial',17.0000),(21,20,'01','2023-01-15','Saldo inicial',20.0000),(22,21,'01','2023-01-18','Saldo inicial',10.0000),(25,22,'01','2023-01-19','Saldo inicial',310.0000),(26,23,'01','2023-01-20','Saldo inicial',0.0000),(27,24,'01','2023-01-22','Saldo inicial',10.0000),(28,25,'01','2023-01-23','Saldo inicial',10.0000),(29,26,'01','2023-01-27','Saldo inicial',90.5000),(30,27,'01','2023-01-30','Saldo inicial',85.0000),(31,28,'01','2023-01-31','Saldo inicial',30.0000),(32,29,'01','2023-02-03','Saldo inicial',39.0000),(34,30,'01','2023-02-19','Saldo inicial',0.1000),(35,31,'01','2023-02-20','Saldo inicial',0.5000),(36,32,'01','2023-02-21','Saldo inicial',0.1000),(37,33,'01','2023-02-22','Saldo inicial',0.5000),(38,34,'01','2023-02-22','Saldo inicial',0.5000),(39,35,'01','2023-02-26','Saldo inicial',10.0000),(40,36,'01','2023-02-27','Saldo inicial',0.5000);

--
-- Table structure for table `cat_accounting_ledger_code_account`
--

CREATE TABLE `cat_accounting_ledger_code_account` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code_account` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Codigo de plan de cuenta',
  `name` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Nombre de cuenta',
  `disabled` tinyint(3) unsigned DEFAULT 0 COMMENT 'Permite realizar modificaciones',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_accounting_ledger_code_account`
--

INSERT INTO `cat_accounting_ledger_code_account` VALUES (1,'1','Activos',1,NULL,NULL),(2,'1.1','Activos corrientes',1,NULL,NULL),(3,'1.1.1','Efectivo y equivalentes de efectivo',1,NULL,NULL),(4,'1.1.1.1','Caja',1,NULL,NULL),(5,'1.1.1.2','Bancos',1,NULL,NULL),(6,'1.1.2','Deudores comerciales y otras cuentas por cobrar',1,NULL,NULL),(7,'1.1.2.0','Activos por impuestos corrientes',1,NULL,NULL),(8,'1.1.2.1','Otras cuentas por cobrar',1,NULL,NULL),(9,'1.1.3','Inventarios',1,NULL,NULL),(10,'1.1.4','Inversiones a corto plazo',1,NULL,NULL),(11,'1.1.5','Otros activos corrientes',1,NULL,NULL),(12,'1.2','Activos no corrientes',1,NULL,NULL),(13,'1.2.1','Propiedad, planta y equipo (Activos fijos)',1,NULL,NULL),(14,'1.2.2','Otros Activos no corrientes',1,NULL,NULL),(15,'2','Pasivos',1,NULL,NULL),(16,'2.1','Pasivos corrientes',1,NULL,NULL),(17,'2.1.1','Cuentas por pagar',1,NULL,NULL),(18,'2.1.1.1','Otras cuentas por pagar',1,NULL,NULL),(19,'2.1.2','Provisiones',1,NULL,NULL),(20,'2.1.3','Obligaciones laborales y de seguridad social',1,NULL,NULL),(21,'2.1.4','Pasivos por impuestos corrientes',1,NULL,NULL),(22,'2.1.4.1','Impuestos por pagar',1,NULL,NULL),(23,'2.1.4.2','Retenciones por pagar',1,NULL,NULL),(24,'2.1.5','Cuentas por pagar con costo financiero',1,NULL,NULL),(25,'2.1.6','Obligaciones financieras',1,NULL,NULL),(26,'2.1.6.1','Tarjetas de crédito',1,NULL,NULL),(27,'2.1.7','Otros pasivos corrientes',1,NULL,NULL),(28,'2.2','Pasivos no corrientes',1,NULL,NULL),(29,'2.2.1','Préstamos a largo plazo',1,NULL,NULL),(30,'2.2.2','Otros pasivos no corrientes',1,NULL,NULL),(31,'3','Patrimonio',1,NULL,NULL),(32,'3.1','Capital social',1,NULL,NULL),(33,'3.2','Ganancias acumuladas',1,NULL,NULL),(34,'3.3','Ajustes por saldos iniciales',1,NULL,NULL),(35,'3.3.1','Ajustes iniciales en bancos',1,NULL,NULL),(36,'3.3.2','Ajustes iniciales en inventario',1,NULL,NULL),(37,'4','Ingresos',1,NULL,NULL),(38,'4.1','Ingresos de actividades ordinarias',1,NULL,NULL),(39,'4.2','Otros Ingresos',1,NULL,NULL),(40,'4.2.1','Otros ingresos diversos',1,NULL,NULL);

--
-- Table structure for table `cat_address_types`
--

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

--
-- Dumping data for table `cat_address_types`
--

INSERT INTO `cat_address_types` VALUES ('01','Punto de venta'),('02','Producción'),('03','Extracción'),('04','Explotación'),('05','Otros');

--
-- Table structure for table `cat_affectation_igv_types`
--

CREATE TABLE `cat_affectation_igv_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `exportation` tinyint(1) DEFAULT NULL,
  `free` tinyint(1) DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `cat_affectation_igv_types_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_affectation_igv_types`
--

INSERT INTO `cat_affectation_igv_types` VALUES ('10',1,0,0,'Gravado - Operación Onerosa'),('11',1,0,1,'Gravado – Retiro por premio'),('12',1,0,1,'Gravado – Retiro por donación'),('13',1,0,1,'Gravado – Retiro'),('14',1,0,1,'Gravado – Retiro por publicidad'),('15',1,0,1,'Gravado – Bonificaciones'),('16',1,0,1,'Gravado – Retiro por entrega a trabajadores'),('17',0,0,1,'Gravado – IVAP'),('20',1,0,0,'Exonerado - Operación Onerosa'),('21',1,0,1,'Exonerado – Transferencia Gratuita'),('30',1,0,0,'Inafecto - Operación Onerosa'),('31',1,0,1,'Inafecto – Retiro por Bonificación'),('32',1,0,1,'Inafecto – Retiro'),('33',1,0,1,'Inafecto – Retiro por Muestras Médicas'),('34',1,0,1,'Inafecto - Retiro por Convenio Colectivo'),('35',1,0,1,'Inafecto – Retiro por premio'),('36',1,0,1,'Inafecto - Retiro por publicidad'),('37',1,0,1,'Inafecto - Transferencia gratuita'),('40',1,1,0,'Exportación de bienes o servicios');

--
-- Table structure for table `cat_attribute_types`
--

CREATE TABLE `cat_attribute_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `cat_attribute_types_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_attribute_types`
--

INSERT INTO `cat_attribute_types` VALUES ('3001',1,'Detracciones: Recursos Hidrobiológicos-Matrícula de la embarcación'),('3002',1,'Detracciones: Recursos Hidrobiológicos-Nombre de la embarcación'),('3003',1,'Detracciones: Recursos Hidrobiológicos-Tipo de especie vendida'),('3004',1,'Detracciones: Recursos Hidrobiológicos-Lugar de descarga'),('3005',1,'Detracciones: Recursos Hidrobiológicos-Fecha de descarga'),('3006',1,'Detracciones: Recursos Hidrobiológicos-Cantidad de especie vendida'),('3050',1,'Transportre Terreste - Número de asiento'),('3051',1,'Transporte Terrestre - Información de manifiesto de pasajeros'),('3052',1,'Transporte Terrestre - Número de documento de identidad del pasajero'),('3053',1,'Transporte Terrestre - Tipo de documento de identidad del pasajero'),('3054',1,'Transporte Terrestre - Nombres y apellidos del pasajero'),('3055',1,'Transporte Terrestre - Ciudad o lugar de destino - Ubigeo'),('3056',1,'Transporte Terrestre - Ciudad o lugar de destino - Dirección detallada'),('3057',1,'Transporte Terrestre - Ciudad o lugar de origen - Ubigeo'),('3058',1,'Transporte Terrestre - Ciudad o lugar de origen - Dirección detallada'),('3059',1,'Transporte Terrestre - Fecha de inicio programado'),('3060',1,'Transporte Terrestre - Hora de inicio programado'),('4000',1,'Beneficio Hospedajes-Paquete turístico: Código de país de emisión del pasaporte'),('4001',1,'Beneficio Hospedajes: Código de país de residencia del sujeto no domiciliado'),('4002',1,'Beneficio Hospedajes: Fecha de ingreso al país'),('4003',1,'Beneficio Hospedajes: Fecha de Ingreso al Establecimiento'),('4004',1,'Beneficio Hospedajes: Fecha de Salida del Establecimiento'),('4005',1,'Beneficio Hospedajes: Número de Días de Permanencia'),('4006',1,'Beneficio Hospedajes: Fecha de Consumo'),('4007',1,'Beneficio Hospedajes-Paquete turístico: Nombres y apellidos del huesped'),('4008',1,'Beneficio Hospedajes-Paquete turístico: Tipo de documento de identidad del huesped'),('4009',1,'Beneficio Hospedajes-Paquete turístico: Número de documento de identidad del huesped'),('4030',1,'Carta Porte Aéreo:  Lugar de origen - Código de ubigeo'),('4031',1,'Carta Porte Aéreo:  Lugar de origen - Dirección detallada'),('4032',1,'Carta Porte Aéreo:  Lugar de destino - Código de ubigeo'),('4033',1,'Carta Porte Aéreo:  Lugar de destino - Dirección detallada'),('4040',1,'BVME transporte ferroviario: Pasajero - Apellidos y Nombres'),('4041',1,'BVME transporte ferroviario: Pasajero - Tipo de documento de identidad'),('4042',1,'BVME transporte ferroviario: Servicio transporte: Ciudad o lugar de origen - Código de ubigeo'),('4043',1,'BVME transporte ferroviario: Servicio transporte: Ciudad o lugar de origen - Dirección detallada'),('4044',1,'BVME transporte ferroviario: Servicio transporte: Ciudad o lugar de destino - Código de ubigeo'),('4045',1,'BVME transporte ferroviario: Servicio transporte: Ciudad o lugar de destino - Dirección detallada'),('4046',1,'BVME transporte ferroviario: Servicio transporte:Número de asiento'),('4047',1,'BVME transporte ferroviario: Servicio transporte: Hora programada de inicio de viaje'),('4048',1,'BVME transporte ferroviario: Servicio transporte: Fecha programada de inicio de viaje'),('4049',1,'BVME transporte ferroviario: Pasajero - Número de documento de identidad'),('4060',1,'Regalía Petrolera: Decreto Supremo de aprobación del contrato'),('4061',1,'Regalía Petrolera: Area de contrato (Lote)'),('4062',1,'Regalía Petrolera: Periodo de pago - Fecha de inicio'),('4063',1,'Regalía Petrolera: Periodo de pago - Fecha de fin'),('4064',1,'Regalía Petrolera: Fecha de Pago'),('5000',1,'Proveedores Estado: Número de Expediente'),('5001',1,'Proveedores Estado: Código de Unidad Ejecutora'),('5002',1,'Proveedores Estado: N° de Proceso de Selección'),('5003',1,'Proveedores Estado: N° de Contrato'),('5010',1,'Numero de Placa'),('5011',1,'Categoria'),('5012',1,'Marca'),('5013',1,'Modelo'),('5014',1,'Color'),('5015',1,'Motor'),('5016',1,'Combustible'),('5017',1,'Form. Rodante'),('5018',1,'VIN'),('5019',1,'Serie/Chasis'),('5020',1,'Año fabricacion'),('5021',1,'Año modelo'),('5022',1,'Version'),('5023',1,'Ejes'),('5024',1,'Asientos'),('5025',1,'Pasajeros'),('5026',1,'Ruedas'),('5027',1,'Carroceria'),('5028',1,'Potencia'),('5029',1,'Cilindros'),('5030',1,'Ciliindrada'),('5031',1,'Peso Bruto'),('5032',1,'Peso Neto'),('5033',1,'Carga Util'),('5034',1,'Longitud'),('5035',1,'Altura'),('5036',1,'Ancho'),('6000',1,'Comercialización de Oro:  Código Unico Concesión Minera'),('6001',1,'Comercialización de Oro:  N° declaración compromiso'),('6002',1,'Comercialización de Oro:  N° Reg. Especial .Comerci. Oro'),('6003',1,'Comercialización de Oro:  N° Resolución que autoriza Planta de Beneficio'),('6004',1,'Comercialización de Oro: Ley Mineral (% concent. oro)'),('7000',1,'Gastos Art. 37 Renta:  Número de Placa'),('7001',1,'Créditos Hipotecarios: Tipo de préstamo'),('7002',1,'Créditos Hipotecarios: Indicador de Primera Vivienda'),('7003',1,'Créditos Hipotecarios: Partida Registral'),('7004',1,'Créditos Hipotecarios: Número de contrato'),('7005',1,'Créditos Hipotecarios: Fecha de otorgamiento del crédito'),('7006',1,'Créditos Hipotecarios: Dirección del predio - Código de ubigeo'),('7007',1,'Créditos Hipotecarios: Dirección del predio - Dirección completa'),('7008',1,'Créditos Hipotecarios: Dirección del predio - Urbanización'),('7009',1,'Créditos Hipotecarios: Dirección del predio - Provincia'),('7010',1,'Créditos Hipotecarios: Dirección del predio - Distrito'),('7011',1,'Créditos Hipotecarios: Dirección del predio - Departamento'),('7020',1,'Partida Arancelaria');

--
-- Table structure for table `cat_charge_discount_types`
--

CREATE TABLE `cat_charge_discount_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `base` tinyint(1) NOT NULL,
  `level` enum('item','global') COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('discount','charge') COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `cat_charge_discount_types_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_charge_discount_types`
--

INSERT INTO `cat_charge_discount_types` VALUES ('00',1,1,'item','discount','Descuentos que afectan la base imponible del IGV/IVAP'),('01',1,0,'item','discount','Descuentos que no afectan la base imponible del IGV/IVAP'),('02',1,1,'global','discount','Descuentos globales que afectan la base imponible del IGV/IVAP'),('03',1,0,'global','discount','Descuentos globales que no afectan la base imponible del IGV/IVAP'),('04',0,1,'global','discount','Descuentos globales por anticipos gravados que afectan la base imponible del IGV/IVAP'),('05',0,0,'global','discount','Descuentos globales por anticipos exonerados'),('06',0,0,'global','discount','Descuentos globales por anticipos inafectos'),('45',0,1,'global','charge','FISE'),('46',1,0,'global','charge','Recargo al consumo y/o propinas'),('47',1,1,'item','charge','Cargos que afectan la base imponible del IGV/IVAP'),('48',1,0,'item','charge','Cargos que no afectan la base imponible del IGV/IVAP'),('49',1,1,'global','charge','Cargos globales que afectan la base imponible del IGV/IVAP'),('50',1,0,'global','charge','Cargos globales que no afectan la base imponible del IGV/IVAP'),('51',0,1,'global','charge','Percepción venta interna'),('52',0,1,'global','charge','Percepción a la adquisición de combustible'),('53',0,1,'global','charge','Percepción realizada al agente de percepción con tasa especial'),('62',1,0,'global','discount','Retención del IGV');

--
-- Table structure for table `cat_colors_items`
--

CREATE TABLE `cat_colors_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Nombre del color',
  `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 `cat_colors_items`
--


--
-- Table structure for table `cat_currency_types`
--

CREATE TABLE `cat_currency_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `symbol` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `cat_currency_types_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_currency_types`
--

INSERT INTO `cat_currency_types` VALUES ('PEN',1,'S/','Soles'),('USD',1,'$','Dólares Americanos');

--
-- Table structure for table `cat_detraction_types`
--

CREATE TABLE `cat_detraction_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `percentage` decimal(6,2) NOT NULL,
  `operation_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `cat_detraction_types_operation_type_id_foreign` (`operation_type_id`),
  KEY `cat_detraction_types_id_index` (`id`),
  CONSTRAINT `cat_detraction_types_operation_type_id_foreign` FOREIGN KEY (`operation_type_id`) REFERENCES `cat_operation_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_detraction_types`
--

INSERT INTO `cat_detraction_types` VALUES ('001',1,'Azúcar y melaza de caña',10.00,'1001'),('003',1,'Alcohol etílico',10.00,'1001'),('005',1,'Maíz amarillo duro',4.00,'1001'),('008',1,'Madera',4.00,'1001'),('016',1,'Aceite de pescado',10.00,'1001'),('019',1,'Arrendamiento de bienes',10.00,'1001'),('020',1,'Mantenimiento y reparación de bienes muebles',12.00,'1001'),('022',1,'Otros servicios empresariales',12.00,'1001'),('023',1,'Leche',4.00,'1001'),('025',1,'Fabricación de bienes por encargo',10.00,'1001'),('027',1,'Servicio de transporte de carga',4.00,'1004');

--
-- Table structure for table `cat_digemid`
--

CREATE TABLE `cat_digemid` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `item_id` int(10) unsigned NOT NULL COMMENT 'Id de la tabla de item',
  `cod_digemid` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Codigo digmid',
  `nom_prod` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Nombre segun digemid',
  `concent` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Dosificacion segun digemid',
  `nom_form_farm` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nom_form_farm_simplif` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `presentac` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fracciones` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fec_vcto_reg_sanitario` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `num_reg_san` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nom_titular` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `prices` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `max_prices` int(10) unsigned DEFAULT 0,
  `active` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `last_update` timestamp NULL 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 `cat_digemid`
--


--
-- Table structure for table `cat_document_types`
--

CREATE TABLE `cat_document_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `short` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `cat_document_types_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_document_types`
--

INSERT INTO `cat_document_types` VALUES ('01',1,'FT','FACTURA ELECTRÓNICA'),('03',1,'BV','BOLETA DE VENTA ELECTRÓNICA'),('07',1,'NC','NOTA DE CRÉDITO'),('08',1,'ND','NOTA DE DÉBITO'),('09',1,NULL,'GUIA DE REMISIÓN REMITENTE'),('20',1,NULL,'COMPROBANTE DE RETENCIÓN ELECTRÓNICA'),('31',1,NULL,'Guía de remisión transportista'),('40',1,NULL,'COMPROBANTE DE PERCEPCIÓN ELECTRÓNICA'),('71',0,NULL,'Guia de remisión remitente complementaria'),('72',0,NULL,'Guia de remisión transportista complementaria'),('GU75',1,NULL,'GUÍA'),('NE76',1,NULL,'NOTA DE ENTRADA'),('80',1,NULL,'NOTA DE VENTA'),('02',1,NULL,'RECIBO POR HONORARIOS'),('14',1,NULL,'SERVICIOS PÚBLICOS'),('04',1,NULL,'LIQUIDACIÓN DE COMPRA'),('U2',1,NULL,'Guía de Ingreso Almacén'),('U3',1,NULL,'Guía de Salida Almacén'),('U4',1,NULL,'Guía de Transferencia Almacén');

--
-- Table structure for table `cat_identity_document_types`
--

CREATE TABLE `cat_identity_document_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `cat_identity_document_types_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_identity_document_types`
--

INSERT INTO `cat_identity_document_types` VALUES ('0',1,'Doc.trib.no.dom.sin.ruc'),('1',1,'DNI'),('4',1,'CE'),('6',1,'RUC'),('7',1,'Pasaporte'),('A',0,'Ced. Diplomática de identidad'),('B',0,'Documento identidad país residencia-no.d'),('C',0,'Tax Identification Number - TIN – Doc Trib PP.NN'),('D',0,'Identification Number - IN – Doc Trib PP. JJ'),('E',0,'TAM- Tarjeta Andina de Migración');

--
-- Table structure for table `cat_item_mold_cavities`
--

CREATE TABLE `cat_item_mold_cavities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Nombre de cavidades del molde',
  `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 `cat_item_mold_cavities`
--


--
-- Table structure for table `cat_item_mold_properties`
--

CREATE TABLE `cat_item_mold_properties` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Nombre de propiedades por molde',
  `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 `cat_item_mold_properties`
--


--
-- Table structure for table `cat_item_package_measurements`
--

CREATE TABLE `cat_item_package_measurements` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Nombre de medidas del paquete',
  `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 `cat_item_package_measurements`
--


--
-- Table structure for table `cat_item_product_family`
--

CREATE TABLE `cat_item_product_family` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Nombre de familia d eproductos',
  `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 `cat_item_product_family`
--


--
-- Table structure for table `cat_item_size`
--

CREATE TABLE `cat_item_size` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Nombre de unidad de medida',
  `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 `cat_item_size`
--


--
-- Table structure for table `cat_item_status`
--

CREATE TABLE `cat_item_status` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Nombre del status',
  `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 `cat_item_status`
--


--
-- Table structure for table `cat_item_unit_business`
--

CREATE TABLE `cat_item_unit_business` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Nombre de unidad de negocio',
  `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 `cat_item_unit_business`
--


--
-- Table structure for table `cat_item_units_per_package`
--

CREATE TABLE `cat_item_units_per_package` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Nombre de unidades por paquete',
  `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 `cat_item_units_per_package`
--


--
-- Table structure for table `cat_legend_types`
--

CREATE TABLE `cat_legend_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `cat_legend_types_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_legend_types`
--

INSERT INTO `cat_legend_types` VALUES ('1000',1,'Monto en Letras'),('1002',1,'TRANSFERENCIA GRATUITA DE UN BIEN Y/O SERVICIO PRESTADO GRATUITAMENTE'),('2000',1,'COMPROBANTE DE PERCEPCIÓN'),('2001',1,'BIENES TRANSFERIDOS EN LA AMAZONÍA REGIÓN SELVA PARA SER CONSUMIDOS EN LA MISMA'),('2002',1,'SERVICIOS PRESTADOS EN LA AMAZONÍA  REGIÓN SELVA PARA SER CONSUMIDOS EN LA MISMA'),('2003',1,'CONTRATOS DE CONSTRUCCIÓN EJECUTADOS  EN LA AMAZONÍA REGIÓN SELVA'),('2004',1,'Agencia de Viaje - Paquete turístico'),('2005',1,'Venta realizada por emisor itinerante'),('2006',1,'Operación sujeta a detracción'),('2007',1,'Operación sujeta al IVAP'),('2008',1,'VENTA EXONERADA DEL IGV-ISC-IPM. PROHIBIDA LA VENTA FUERA DE LA ZONA COMERCIAL DE TACNA'),('2009',1,'PRIMERA VENTA DE MERCANCÍA IDENTIFICABLE ENTRE USUARIOS DE LA ZONA COMERCIAL'),('2010',1,'Restitucion Simplificado de Derechos Arancelarios');

--
-- Table structure for table `cat_note_credit_types`
--

CREATE TABLE `cat_note_credit_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `cat_note_credit_types_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_note_credit_types`
--

INSERT INTO `cat_note_credit_types` VALUES ('01',1,'Anulación de la operación'),('02',1,'Anulación por error en el RUC'),('03',1,'Corrección por error en la descripción'),('04',1,'Descuento global'),('05',1,'Descuento por ítem'),('06',1,'Devolución total'),('07',1,'Devolución por ítem'),('08',1,'Bonificación'),('09',1,'Disminución en el valor'),('10',1,'Otros Conceptos'),('11',1,'Ajustes de operaciones de exportación'),('12',1,'Ajustes afectos al IVAP'),('13',1,'Ajustes – montos y/o fechas de pago');

--
-- Table structure for table `cat_note_debit_types`
--

CREATE TABLE `cat_note_debit_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `cat_note_debit_types_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_note_debit_types`
--

INSERT INTO `cat_note_debit_types` VALUES ('01',1,'Intereses por mora'),('02',1,'Aumento en el valor'),('03',1,'Penalidades/ otros conceptos'),('10',1,'Ajustes de operaciones de exportación'),('11',1,'Ajustes afectos al IVAP');

--
-- Table structure for table `cat_operation_types`
--

CREATE TABLE `cat_operation_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `exportation` tinyint(1) NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `cat_operation_types_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_operation_types`
--

INSERT INTO `cat_operation_types` VALUES ('0101',1,0,'Venta interna'),('0112',0,0,'Venta Interna - Sustenta Gastos Deducibles Persona Natural'),('0113',0,0,'Venta Interna - NRUS'),('0200',1,1,'Exportación de Bienes'),('0201',0,1,'Exportación de Servicios – Prestación servicios realizados íntegramente en el país'),('0202',0,1,'Exportación de Servicios – Prestación de servicios de hospedaje No Domiciliado'),('0203',0,1,'Exportación de Servicios – Transporte de navieras'),('0204',0,1,'Exportación de Servicios – Servicios a naves y aeronaves de bandera extranjera'),('0205',0,1,'Exportación de Servicios - Servicios que conformen un Paquete Turístico'),('0206',0,1,'Exportación de Servicios – Servicios complementarios al transporte de carga'),('0207',0,1,'Exportación de Servicios – Suministro de energía eléctrica a favor de sujetos domiciliados en ZED'),('0208',0,1,'Exportación de Servicios – Prestación servicios realizados parcialmente en el extranjero'),('0301',0,0,'Operaciones con Carta de porte aéreo (emitidas en el ámbito nacional)'),('0302',0,0,'Operaciones de Transporte ferroviario de pasajeros'),('0303',0,0,'Operaciones de Pago de regalía petrolera'),('0401',1,0,'Ventas no domiciliados que no califican como exportación'),('1001',1,0,'Operación Sujeta a Detracción'),('1002',0,0,'Operación Sujeta a Detracción- Recursos Hidrobiológicos'),('1003',0,0,'Operación Sujeta a Detracción- Servicios de Transporte Pasajeros'),('1004',1,0,'Operación Sujeta a Detracción- Servicios de Transporte Carga'),('2001',0,0,'Operación Sujeta a Percepción'),('0501',1,0,'Compra interna');

--
-- Table structure for table `cat_other_tax_concept_types`
--

CREATE TABLE `cat_other_tax_concept_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `cat_other_tax_concept_types_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_other_tax_concept_types`
--

INSERT INTO `cat_other_tax_concept_types` VALUES ('1000',1,'Total valor de venta - operaciones exportadas'),('1001',1,'Total valor de venta - operaciones gravadas'),('1002',1,'Total valor de venta - operaciones inafectas'),('1003',1,'Total valor de venta - operaciones exoneradas'),('1004',1,'Total valor de venta – Operaciones gratuitas'),('1005',1,'Sub total de venta'),('2001',1,'Percepciones'),('2002',1,'Retenciones'),('2003',1,'Detracciones'),('2004',1,'Bonificaciones'),('2005',1,'Total descuentos'),('3001',1,'FISE (Ley 29852) Fondo Inclusión Social Energético');

--
-- Table structure for table `cat_payment_method_types`
--

CREATE TABLE `cat_payment_method_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `cat_payment_method_types_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_payment_method_types`
--

INSERT INTO `cat_payment_method_types` VALUES ('001',1,'Depósito en cuenta'),('002',1,'Giro'),('003',1,'Transferencia de fondos'),('004',1,'Orden de pago'),('005',1,'Tarjeta de débito'),('006',1,'Tarjeta de crédito emitida en el país por una empresa del sistema financiero'),('007',1,'Cheques con la cláusula de \"NO NEGOCIABLE\", \"INTRANSFERIBLES\", \"NO A LA ORDEN\" u otra equivalente, a que se refiere el inciso g) del artículo 5° de la ley'),('008',1,'Efectivo, por operaciones en las que no existe obligación de utilizar medio de pago'),('009',1,'Efectivo, en los demás casos'),('010',1,'Medios de pago usados en comercio exterior'),('011',1,'Documentos emitidos por las EDPYMES y las cooperativas de ahorro y crédito no autorizadas a captar depósitos del público'),('012',1,'Tarjeta de crédito emitida en el país o en el exterior por una empresa no perteneciente al sistema financiero, cuyo objeto principal sea la emisión y administración de tarjetas de crédito'),('013',1,'Tarjetas de crédito emitidas en el exterior por empresas bancarias o financieras no domiciliadas'),('101',1,'Transferencias – Comercio exterior'),('102',1,'Cheques bancarios - Comercio exterior'),('103',1,'Orden de pago simple - Comercio exterior'),('104',1,'Orden de pago documentario - Comercio exterior'),('105',1,'Remesa simple - Comercio exterior'),('106',1,'Remesa documentaria - Comercio exterior'),('107',1,'Carta de crédito simple - Comercio exterior'),('108',1,'Carta de crédito documentario - Comercio exterior'),('999',1,'Otros medios de pago');

--
-- Table structure for table `cat_perception_types`
--

CREATE TABLE `cat_perception_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `percentage` decimal(10,2) NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `cat_perception_types_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_perception_types`
--

INSERT INTO `cat_perception_types` VALUES ('01',1,2.00,'Percepción Venta Interna'),('02',1,1.00,'Percepción a la adquisición de combustible'),('03',1,0.50,'Percepción realizada al agente de percepción con tasa especial');

--
-- Table structure for table `cat_periods`
--

CREATE TABLE `cat_periods` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `period` char(1) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Define si es dia, mes o año - D/M/Y',
  `name` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Nombre del periodo',
  `active` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Si esta activo',
  `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 `cat_periods`
--

INSERT INTO `cat_periods` VALUES (1,'M','Mensual',1,NULL,NULL),(2,'Y','Anual',1,NULL,NULL);

--
-- Table structure for table `cat_price_types`
--

CREATE TABLE `cat_price_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `cat_price_types_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_price_types`
--

INSERT INTO `cat_price_types` VALUES ('01',1,'Precio unitario (incluye el IGV)'),('02',1,'Valor referencial unitario en operaciones no onerosas');

--
-- Table structure for table `cat_related_documents_types`
--

CREATE TABLE `cat_related_documents_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `cat_related_documents_types_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_related_documents_types`
--

INSERT INTO `cat_related_documents_types` VALUES ('01',1,'Numeración DAM'),('02',1,'Número de orden de entrega'),('03',1,'Número SCOP'),('04',1,'Número de manifiesto de carga'),('05',1,'Número de constancia de detracción'),('06',1,'Otros');

--
-- Table structure for table `cat_related_tax_document_types`
--

CREATE TABLE `cat_related_tax_document_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `cat_related_tax_document_types_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_related_tax_document_types`
--

INSERT INTO `cat_related_tax_document_types` VALUES ('01',1,'Factura – emitida para corregir error en el RUC'),('02',1,'Factura – emitida por anticipos'),('03',1,'Boleta de Venta – emitida por anticipos'),('04',1,'Ticket de Salida - ENAPU'),('05',1,'Código SCOP'),('99',1,'Otros');

--
-- Table structure for table `cat_retention_types`
--

CREATE TABLE `cat_retention_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `percentage` decimal(10,2) NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `cat_retention_types_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_retention_types`
--

INSERT INTO `cat_retention_types` VALUES ('01',1,3.00,'Tasa 3%'),('02',1,6.00,'Tasa 6%');

--
-- Table structure for table `cat_summary_status_types`
--

CREATE TABLE `cat_summary_status_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `cat_summary_status_types_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_summary_status_types`
--

INSERT INTO `cat_summary_status_types` VALUES ('1',1,'Adicionar'),('2',1,'Modificar'),('3',1,'Anulado');

--
-- Table structure for table `cat_system_isc_types`
--

CREATE TABLE `cat_system_isc_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `cat_system_isc_types_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_system_isc_types`
--

INSERT INTO `cat_system_isc_types` VALUES ('01',1,'Sistema al valor'),('02',1,'Aplicación del Monto Fijo'),('03',1,'Sistema de Precios de Venta al Público');

--
-- Table structure for table `cat_transfer_reason_types`
--

CREATE TABLE `cat_transfer_reason_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `discount_stock` tinyint(1) DEFAULT 0,
  KEY `cat_transfer_reason_types_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_transfer_reason_types`
--

INSERT INTO `cat_transfer_reason_types` VALUES ('01',1,'Venta',0),('02',1,'Compra',0),('04',1,'Traslado entre establecimientos de la misma empresa',0),('08',1,'Importación',0),('09',1,'Exportación',0),('13',1,'Otros no comprendido en ningún código del presente catálogo',0),('14',1,'Venta sujeta a confirmación del comprador',0),('18',1,'Traslado emisor itinerante de comprobantes de pago Aquí no se está considerando el traslado a zona primaria.',0),('19',0,'Traslado a zona primaria',0),('03',1,'Venta con entrega a terceros',0),('05',1,'Consignación',0),('06',1,'Devolución',0),('07',1,'Recojo de bienes transformados',0),('17',1,'Traslado de bienes para transformación',0);

--
-- Table structure for table `cat_transport_mode_types`
--

CREATE TABLE `cat_transport_mode_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `cat_transport_mode_types_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_transport_mode_types`
--

INSERT INTO `cat_transport_mode_types` VALUES ('01',1,'Transporte público'),('02',1,'Transporte privado');

--
-- Table structure for table `cat_unit_types`
--

CREATE TABLE `cat_unit_types` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `symbol` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `cat_unit_types_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cat_unit_types`
--

INSERT INTO `cat_unit_types` VALUES ('ZZ',1,NULL,'Servicio'),('BX',1,NULL,'Caja'),('GLL',1,NULL,'Galones'),('GRM',1,NULL,'Gramos'),('KGM',1,NULL,'Kilos'),('LTR',1,NULL,'Litros'),('MTR',1,NULL,'Metros'),('FOT',1,NULL,'Pies'),('INH',1,NULL,'Pulgadas'),('NIU',1,NULL,'Unidades'),('YRD',1,NULL,'Yardas'),('HUR',1,NULL,'Hora'),('TM',0,NULL,'Toneladas'),('TNE',1,NULL,'Toneladas');

--
-- Table structure for table `categories`
--

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

--
-- Dumping data for table `categories`
--


--
-- Table structure for table `charge_padrones`
--

CREATE TABLE `charge_padrones` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` tinyint(1) NOT NULL DEFAULT 0,
  `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 `charge_padrones`
--


--
-- Table structure for table `client_error_types`
--

CREATE TABLE `client_error_types` (
  `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 `client_error_types`
--

INSERT INTO `client_error_types` VALUES ('data_entry','Errores de ingreso de datos'),('token_creation','Errores en la creación del token de tarjeta');

--
-- Table structure for table `client_errors`
--

CREATE TABLE `client_errors` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_error_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `original_message` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_message` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `client_errors_client_error_type_id_foreign` (`client_error_type_id`),
  KEY `client_errors_code_index` (`code`),
  CONSTRAINT `client_errors_client_error_type_id_foreign` FOREIGN KEY (`client_error_type_id`) REFERENCES `client_error_types` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `client_errors`
--

INSERT INTO `client_errors` VALUES (1,'205','data_entry','parameter cardNumber can not be null/empty','Ingresa el número de tu tarjeta.'),(2,'208','data_entry','parameter cardExpirationMonth can not be null/empty','Elige un mes.'),(3,'209','data_entry','parameter cardExpirationYear can not be null/empty','Elige un año.'),(4,'212','data_entry','parameter docType can not be null/empty','Ingresa tu tipo de documento.'),(5,'213','data_entry','The parameter cardholder.document.subtype can not be null or empty','Ingresa tu documento.'),(6,'214','data_entry','parameter docNumber can not be null/empty','Ingresa tu documento.'),(7,'220','data_entry','parameter cardIssuerId can not be null/empty','Ingresa tu banco.'),(8,'221','data_entry','parameter cardholderName can not be null/empty','Ingresa el nombre y apellido.'),(9,'224','data_entry','parameter securityCode can not be null/empty','Ingresa el código de seguridad.'),(10,'E301','data_entry','invalid parameter cardNumber','Ingresa un número de tarjeta válido.'),(11,'E302','data_entry','invalid parameter securityCode','Revisa el código de seguridad.'),(12,'316','data_entry','invalid parameter cardholderName','Ingresa un nombre válido.'),(13,'322','data_entry','	invalid parameter docType','El tipo de documento es inválido.'),(14,'323','data_entry','invalid parameter cardholder.document.subtype','Revisa tu documento.'),(15,'324','data_entry','invalid parameter docNumber','El documento es inválido.'),(16,'325','data_entry','invalid parameter cardExpirationMonth','El mes es inválido'),(17,'326','data_entry','invalid parameter cardExpirationYear','El año es inválido'),(18,'default','data_entry','Otro código de error','Revisa los datos.'),(19,'106','token_creation','Cannot operate between users from different countries','No puedes realizar pagos a otros países.'),(20,'109','token_creation','Invalid number of shares for this payment_method_id','El medio de pago no procesa pagos en installments cuotas. Elige otra tarjeta u otro medio de pago.'),(21,'126','token_creation','The action requested is not valid for the current payment state','No pudimos procesar tu pago.'),(22,'129','token_creation','Cannot pay this amount with this paymentMethod','El medio de pago no procesa pagos del monto seleccionado. Elige otra tarjeta u otro medio de pago.'),(23,'145','token_creation','Invalid users involved','Una de las partes con la que intentas hacer el pago es de prueba y la otra es usuario real.'),(24,'150','token_creation','The payer_id cannot do payments currently','No puedes realizar pagos.'),(25,'151','token_creation','The payer_id cannot do payments with this payment_method_id','No puedes realizar pagos.'),(26,'160','token_creation','Collector not allowed to operate','No pudimos procesar tu pago.'),(27,'204','token_creation','Unavailable payment_method','El medio de pago no está disponible en este momento. Elige otra tarjeta u otro medio de pago.'),(28,'801','token_creation','Already posted the same request in the last minute','Realizaste un pago similar hace instantes. Intenta de nuevo en unos minutos.'),(29,'default','token_creation','Otro código de error','No pudimos procesar tu pago.');

--
-- Table structure for table `columns_to_reports`
--

CREATE TABLE `columns_to_reports` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `report` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `columns` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`columns`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `columns_to_reports_user_id_foreign` (`user_id`),
  CONSTRAINT `columns_to_reports_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `columns_to_reports`
--

INSERT INTO `columns_to_reports` VALUES (1,2,'document_index','{\"notes\":{\"title\":\"Notas C\\/D\",\"visible\":false},\"dispatch\":{\"title\":\"Gu\\u00eda de Remisi\\u00f3n\",\"visible\":false},\"plate_numbers\":{\"title\":\"Placa\",\"visible\":false},\"user_name\":{\"title\":\"Usuario\",\"visible\":false},\"exchange_rate_sale\":{\"title\":\"Tipo de cambio\",\"visible\":false},\"total_exportation\":{\"title\":\"T.Exportaci\\u00f3n\",\"visible\":false},\"total_free\":{\"title\":\"T.Gratuito\",\"visible\":false},\"total_unaffected\":{\"title\":\"T.Inafecto\",\"visible\":false},\"total_exonerated\":{\"title\":\"T.Exonerado\",\"visible\":true},\"date_of_due\":{\"title\":\"F. Vencimiento\",\"visible\":false},\"guides\":{\"title\":\"Guias\",\"visible\":false},\"sales_note\":{\"title\":\"Nota de ventas\",\"visible\":false},\"order_note\":{\"title\":\"Pedidos\",\"visible\":false},\"send_it\":{\"title\":\"Correo enviado al destinatario\",\"visible\":false},\"total\":{\"title\":\"Total\",\"visible\":false},\"currency_type_id\":{\"title\":\"Moneda\",\"visible\":false},\"purchase_order\":{\"title\":\"Orden de Compra\",\"visible\":false},\"soap_type\":{\"title\":\"Soap\",\"visible\":false},\"balance\":{\"title\":\"Saldo\",\"visible\":false},\"total_charge\":{\"title\":\"T.Cargos\",\"visible\":false},\"date_payment\":{\"title\":\"Fecha de pago\",\"visible\":false}}','2022-11-29 16:27:09','2022-11-29 16:27:45'),(2,1,'document_index','{\"notes\":{\"title\":\"Notas C\\/D\",\"visible\":false},\"dispatch\":{\"title\":\"Gu\\u00eda de Remisi\\u00f3n\",\"visible\":false},\"plate_numbers\":{\"title\":\"Placa\",\"visible\":false},\"user_name\":{\"title\":\"Usuario\",\"visible\":false},\"exchange_rate_sale\":{\"title\":\"Tipo de cambio\",\"visible\":false},\"total_exportation\":{\"title\":\"T.Exportaci\\u00f3n\",\"visible\":false},\"total_free\":{\"title\":\"T.Gratuito\",\"visible\":false},\"total_unaffected\":{\"title\":\"T.Inafecto\",\"visible\":false},\"total_exonerated\":{\"title\":\"T.Exonerado\",\"visible\":true},\"date_of_due\":{\"title\":\"F. Vencimiento\",\"visible\":false},\"guides\":{\"title\":\"Guias\",\"visible\":false},\"sales_note\":{\"title\":\"Nota de ventas\",\"visible\":false},\"order_note\":{\"title\":\"Pedidos\",\"visible\":false},\"send_it\":{\"title\":\"Correo enviado al destinatario\",\"visible\":false},\"total\":{\"title\":\"Total\",\"visible\":false},\"currency_type_id\":{\"title\":\"Moneda\",\"visible\":false},\"purchase_order\":{\"title\":\"Orden de Compra\",\"visible\":false},\"soap_type\":{\"title\":\"Soap\",\"visible\":true},\"balance\":{\"title\":\"Saldo\",\"visible\":false},\"total_charge\":{\"title\":\"T.Cargos\",\"visible\":false},\"date_payment\":{\"title\":\"Fecha de pago\",\"visible\":false}}','2022-11-29 16:33:11','2022-11-29 16:48:22'),(3,2,'client_index','{\"observation\":{\"title\":\"Observacion\",\"visible\":false},\"zone\":{\"title\":\"Zona\",\"visible\":false},\"website\":{\"title\":\"Sitio Web\",\"visible\":false},\"person_type\":{\"title\":\"Tipo de cliente\",\"visible\":false},\"credit_days\":{\"title\":\"D\\u00edas de cr\\u00e9dito\",\"visible\":false},\"seller\":{\"title\":\"Vendedor asignado\",\"visible\":false},\"email\":{\"title\":\"Correo electr\\u00f3nico\",\"visible\":false},\"telephone\":{\"title\":\"Tel\\u00e9fono\",\"visible\":false},\"department\":{\"title\":\"Departamento\",\"visible\":false},\"province\":{\"title\":\"Provincia\",\"visible\":false},\"district\":{\"title\":\"Distrito\",\"visible\":false}}','2022-11-30 08:51:14','2022-11-30 08:51:14'),(4,2,'sale_notes_index','{\"due_date\":{\"title\":\"Fecha de Vencimiento\",\"visible\":false},\"exchange_rate_sale\":{\"title\":\"Tipo de cambio\",\"visible\":false},\"total_free\":{\"title\":\"T.Gratuito\",\"visible\":false},\"total_exportation\":{\"title\":\"T.Exportaci\\u00f3n\",\"visible\":false},\"total_unaffected\":{\"title\":\"T.Inafecto\",\"visible\":false},\"total_exonerated\":{\"title\":\"T.Exonerado\",\"visible\":false},\"total_taxed\":{\"title\":\"T.Gravado\",\"visible\":false},\"total_igv\":{\"title\":\"T.IGV\",\"visible\":false},\"paid\":{\"title\":\"Estado de Pago\",\"visible\":false},\"type_period\":{\"title\":\"Tipo Periodo\",\"visible\":true},\"quantity_period\":{\"title\":\"Cantidad Periodo\",\"visible\":true},\"license_plate\":{\"title\":\"Placa\",\"visible\":true},\"total_paid\":{\"title\":\"Pagado\",\"visible\":false},\"total_pending_paid\":{\"title\":\"Por pagar\",\"visible\":false},\"seller_name\":{\"title\":\"Vendedor\",\"visible\":false},\"recurrence\":{\"title\":\"Recurrencia\",\"visible\":false},\"region\":{\"title\":\"Region\",\"visible\":false},\"date_payment\":{\"title\":\"Fecha de pago\",\"visible\":false}}','2022-11-30 09:44:54','2022-12-14 15:28:29'),(5,2,'documents_report_index','{\"guides\":{\"title\":\"Guias\",\"visible\":false},\"options\":{\"title\":\"Opciones\",\"visible\":false},\"web_platforms\":{\"title\":\"Plataformas web\",\"visible\":false},\"total_isc\":{\"title\":\"Total ISC\",\"visible\":true},\"total_charge\":{\"title\":\"Total Cargos\",\"visible\":false},\"district\":{\"title\":\"Distrito\",\"visible\":false},\"department\":{\"title\":\"Departamento\",\"visible\":false},\"province\":{\"title\":\"Provincia\",\"visible\":false},\"client_direction\":{\"title\":\"Direccion del cliente\",\"visible\":false},\"ruc\":{\"title\":\"Ruc\",\"visible\":false},\"note_sale\":{\"title\":\"Nota de venta\",\"visible\":false},\"date_note\":{\"title\":\"Fecha de N.Venta\",\"visible\":false},\"payment_form\":{\"title\":\"Forma de pago\",\"visible\":false},\"payment_method\":{\"title\":\"Metodo de pago\",\"visible\":false},\"purchase_order\":{\"title\":\"Orden de compra\",\"visible\":true},\"total_exonerated\":{\"title\":\"Total Exonerado\",\"visible\":true},\"total_unaffected\":{\"title\":\"Total Inafecto\",\"visible\":true},\"total_free\":{\"title\":\"Total Gratuito\",\"visible\":true},\"total_taxed\":{\"title\":\"Total Gravado\",\"visible\":true},\"total_igv\":{\"title\":\"Total IGV\",\"visible\":true},\"total\":{\"title\":\"Total\",\"visible\":true},\"user_seller\":{\"title\":\"Usuario\\/Vendedor\",\"visible\":true},\"doc_affect\":{\"title\":\"Doc. Afectado\",\"visible\":true},\"quote\":{\"title\":\"Cotizacion\",\"visible\":true},\"case\":{\"title\":\"Caso\",\"visible\":true},\"items\":{\"title\":\"Productos\",\"visible\":true},\"currency_type_id\":{\"title\":\"Moneda\",\"visible\":true}}','2023-01-02 18:51:28','2023-01-02 18:51:28');

--
-- Table structure for table `companies`
--

CREATE TABLE `companies` (
  `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,
  `trade_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `soap_send_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '01',
  `soap_type_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `soap_username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `soap_password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `soap_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `certificate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `certificate_due` date DEFAULT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `detraction_account` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `app_logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo_store` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `favicon` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `img_firm` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `operation_amazonia` tinyint(1) NOT NULL DEFAULT 0,
  `integrated_query_client_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integrated_query_client_secret` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url_login_pse` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_pse` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password_pse` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_id_pse` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '8',
  `send_document_to_pse` tinyint(1) NOT NULL DEFAULT 0,
  `url_send_cdr_pse` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url_signature_pse` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ws_api_phone_number_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ws_api_token` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `soap_sunat_username` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `soap_sunat_password` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `api_sunat_id` varchar(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `api_sunat_secret` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `cod_digemid` text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Codigo de establecimiento DIGEMID',
  PRIMARY KEY (`id`),
  KEY `companies_identity_document_type_id_foreign` (`identity_document_type_id`),
  KEY `companies_soap_type_id_foreign` (`soap_type_id`),
  CONSTRAINT `companies_identity_document_type_id_foreign` FOREIGN KEY (`identity_document_type_id`) REFERENCES `cat_identity_document_types` (`id`),
  CONSTRAINT `companies_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `companies`
--

INSERT INTO `companies` VALUES (1,'6','20392262432','NEGOCIOS OLTI EMP.IND.DE RESP.LTADA','NEGOCIOS OLTI EMP.IND.DE RESP.LTADA','01','02','20392262432OLTI1234','75478910Jc21',NULL,'certificate_20392262432.pem',NULL,'logo_20392262432.jpg',NULL,'app_logo_20392262432.png',NULL,'storage/uploads/favicons/1669691244.png',NULL,0,'7902961a-468d-4ce1-aa3c-2282b0c65b1a','ux8sEriVpzd6rkc6mmLcow==',NULL,NULL,NULL,'8',0,NULL,NULL,NULL,NULL,'20392262432OLTI1234','75478910Jc21','778fe9ad-52ce-46f0-9bd8-941fe7c50325','r4J/0CPN9K2v9M4xh3xrqA==',NULL,'2022-12-18 13:40:15',NULL);

--
-- Table structure for table `company_accounts`
--

CREATE TABLE `company_accounts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `subtotal_pen` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_pen` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `igv_pen` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subtotal_usd` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_usd` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `igv_usd` 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 `company_accounts`
--

INSERT INTO `company_accounts` VALUES (1,'70111','12121','40111','70111','12122','40111');

--
-- Table structure for table `configuration_ecommerce`
--

CREATE TABLE `configuration_ecommerce` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `information_contact_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `information_contact_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `information_contact_phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `information_contact_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_whatsapp` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `script_paypal` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link_youtube` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link_twitter` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link_facebook` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tag_support` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tag_dollar` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tag_shipping` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `token_public_culqui` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `token_private_culqui` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `configuration_ecommerce`
--

INSERT INTO `configuration_ecommerce` VALUES (1,'Admin','admin@mail.com','01 505-5555',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `configuration_mi_tienda_pe`
--

CREATE TABLE `configuration_mi_tienda_pe` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `establishment_id` int(10) unsigned DEFAULT 1,
  `series_order_note_id` int(10) unsigned DEFAULT 0,
  `series_document_ft_id` int(10) unsigned DEFAULT 0,
  `series_document_bt_id` int(10) unsigned DEFAULT 0,
  `user_id` int(10) unsigned DEFAULT 0,
  `payment_destination_id` int(10) unsigned DEFAULT 0,
  `currency_type_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `autogenerate` tinyint(3) unsigned DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `configuration_mi_tienda_pe`
--


--
-- Table structure for table `configurations`
--

CREATE TABLE `configurations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `send_auto` tinyint(1) NOT NULL,
  `formats` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default',
  `cron` tinyint(1) NOT NULL DEFAULT 1,
  `stock` tinyint(1) NOT NULL DEFAULT 1,
  `sunat_alternate_server` tinyint(1) NOT NULL DEFAULT 0,
  `limit_documents` bigint(20) NOT NULL DEFAULT 0,
  `limit_users` bigint(20) NOT NULL DEFAULT 10,
  `locked_emission` tinyint(1) NOT NULL DEFAULT 0,
  `restrict_sales_limit` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'habilitar restricción de límite de ventas mensual',
  `locked_create_establishments` tinyint(1) NOT NULL DEFAULT 0,
  `permission_to_edit_cpe` tinyint(1) NOT NULL DEFAULT 0,
  `customer_filter_by_seller` tinyint(1) NOT NULL DEFAULT 0,
  `detraction_amount_rounded_int` tinyint(1) NOT NULL DEFAULT 0,
  `set_address_by_establishment` tinyint(1) NOT NULL DEFAULT 0,
  `plan` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`plan`)),
  `enable_whatsapp` tinyint(1) NOT NULL DEFAULT 1,
  `phone_whatsapp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `apk_url` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `visual` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`visual`)),
  `decimal_quantity` tinyint(4) NOT NULL DEFAULT 2,
  `locked_users` tinyint(1) NOT NULL DEFAULT 0,
  `date_time_start` datetime DEFAULT NULL,
  `quantity_documents` int(11) NOT NULL,
  `quantity_sales_notes` int(11) NOT NULL,
  `locked_tenant` tinyint(1) NOT NULL DEFAULT 0,
  `compact_sidebar` tinyint(1) NOT NULL DEFAULT 0,
  `amount_plastic_bag_taxes` decimal(6,2) NOT NULL DEFAULT 0.10,
  `config_system_env` tinyint(1) NOT NULL DEFAULT 1,
  `colums_grid_item` tinyint(4) DEFAULT 4,
  `options_pos` tinyint(1) NOT NULL DEFAULT 1,
  `edit_name_product` tinyint(1) NOT NULL DEFAULT 1,
  `restrict_receipt_date` tinyint(1) NOT NULL DEFAULT 1,
  `shipping_time_days` int(11) NOT NULL DEFAULT 4,
  `affectation_igv_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '10',
  `global_discount_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '03',
  `include_igv` tinyint(1) DEFAULT NULL,
  `percentage_allowance_charge` decimal(12,2) DEFAULT 0.00,
  `igv_retention_percentage` decimal(8,5) NOT NULL DEFAULT 3.00000,
  `active_allowance_charge` tinyint(1) DEFAULT 0,
  `active_warehouse_prices` tinyint(1) DEFAULT 0,
  `product_only_location` tinyint(1) DEFAULT NULL,
  `terms_condition` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `terms_condition_sale` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cotizaction_finance` tinyint(1) NOT NULL DEFAULT 1,
  `quotation_allow_seller_generate_sale` tinyint(1) NOT NULL DEFAULT 0,
  `allow_edit_unit_price_to_seller` tinyint(1) NOT NULL DEFAULT 0,
  `legend_footer` tinyint(1) NOT NULL DEFAULT 0,
  `header_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `destination_sale` tinyint(1) NOT NULL DEFAULT 1,
  `default_document_type_03` tinyint(1) NOT NULL DEFAULT 1,
  `default_document_type_80` tinyint(1) NOT NULL DEFAULT 0,
  `search_item_by_barcode` tinyint(1) NOT NULL DEFAULT 0,
  `login` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `navbar` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'fixed',
  `finances` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `smtp_encryption` text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Tipo de cifrado de correo',
  `smtp_password` text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'contraseña de usuario para el envio de correo',
  `smtp_user` text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Nombre de usuario para el envio de correo',
  `smtp_port` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Puerto de correo del cliente',
  `smtp_host` text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Host de correo del cliente',
  `ticket_58` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `url_apiruc` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `token_apiruc` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seller_can_create_product` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Define si los vendedores pueden crear productos',
  `seller_can_view_balance` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Define si los vendedores pueden ver el balance en finanzas',
  `seller_can_generate_sale_opportunities` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Define si los vendedores pueden crear productos',
  `update_document_on_dispaches` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Si esta activo, al momento de crear una guia, se actualiza el pdf de documentos.',
  `is_pharmacy` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Establece si se activa el modulo de farmacia',
  `auto_send_dispatchs_to_sunat` tinyint(4) DEFAULT 1 COMMENT 'define si se mandan las guias automaticamente a sunat',
  `send_data_to_other_server` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Habilita la posibilidad de enviar datos a otro servidor',
  `search_item_by_series` tinyint(1) NOT NULL DEFAULT 0,
  `mi_tienda_pe` tinyint(1) NOT NULL DEFAULT 0,
  `group_items_generate_document` tinyint(1) NOT NULL DEFAULT 1,
  `change_free_affectation_igv` tinyint(1) NOT NULL DEFAULT 0,
  `currency_type_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'PEN' COMMENT 'Id de cat_currency_types_id',
  `select_available_price_list` tinyint(1) NOT NULL DEFAULT 0,
  `show_extra_info_to_item` tinyint(3) unsigned DEFAULT 0 COMMENT 'Habilita datos extra para item',
  `enabled_global_igv_to_purchase` tinyint(3) unsigned DEFAULT 0 COMMENT 'Habilita el igv global en la compra. Sobreescribe has_igv del item',
  `show_pdf_name` tinyint(3) unsigned DEFAULT 0 COMMENT 'Muestra el nombre de pdf en vez del producto',
  `dispatches_address_text` tinyint(3) unsigned DEFAULT 0 COMMENT 'En guias, habilita colocar la direccion de destino como texto',
  `show_items_only_user_stablishment` int(10) unsigned DEFAULT 1 COMMENT 'permite mostrar stock del alamcen de usuario',
  `name_product_pdf_to_xml` tinyint(1) NOT NULL DEFAULT 0,
  `item_name_pdf_description` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Si esta activado, el nombre de pdf será por defecto la descripcion del item',
  `auto_print` tinyint(1) NOT NULL DEFAULT 0,
  `show_service_on_pos` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Permite listar al inicio, los servicios en pos',
  `pos_cost_price` tinyint(1) NOT NULL DEFAULT 1,
  `pos_history` tinyint(1) NOT NULL DEFAULT 1,
  `show_totals_on_cpe_list` tinyint(1) NOT NULL DEFAULT 0,
  `show_terms_condition_pos` tinyint(1) NOT NULL DEFAULT 0,
  `show_ticket_80` tinyint(1) NOT NULL DEFAULT 1,
  `show_ticket_58` tinyint(1) NOT NULL DEFAULT 0,
  `show_ticket_50` tinyint(1) NOT NULL DEFAULT 0,
  `show_complete_name_pos` tinyint(1) NOT NULL DEFAULT 0,
  `show_last_price_sale` tinyint(1) NOT NULL DEFAULT 0,
  `show_logo_by_establishment` tinyint(1) NOT NULL DEFAULT 0,
  `print_new_line_to_observation` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Añade la posiblidad de colocar salto de linea en observación de pdf',
  `new_validator_pagination` mediumint(8) unsigned DEFAULT 0,
  `validate_purchase_sale_unit_price` tinyint(1) NOT NULL DEFAULT 0,
  `checked_global_igv_to_purchase` tinyint(1) NOT NULL DEFAULT 0,
  `checked_update_purchase_price` tinyint(1) NOT NULL DEFAULT 0,
  `set_global_purchase_currency_items` tinyint(1) NOT NULL DEFAULT 0,
  `set_unit_price_dispatch_related_record` tinyint(1) NOT NULL DEFAULT 0,
  `restrict_voided_send` tinyint(1) NOT NULL DEFAULT 1,
  `shipping_time_days_voided` int(11) NOT NULL DEFAULT 7,
  `enabled_tips_pos` tinyint(1) NOT NULL DEFAULT 0,
  `top_menu_a_id` int(10) unsigned DEFAULT NULL,
  `top_menu_b_id` int(10) unsigned DEFAULT NULL,
  `top_menu_c_id` int(10) unsigned DEFAULT NULL,
  `top_menu_d_id` int(10) unsigned DEFAULT NULL,
  `skin_id` int(10) unsigned NOT NULL DEFAULT 1,
  `legend_forest_to_xml` tinyint(1) NOT NULL DEFAULT 0,
  `change_currency_item` tinyint(1) NOT NULL DEFAULT 0,
  `enabled_advanced_records_search` tinyint(1) NOT NULL DEFAULT 0,
  `change_decimal_quantity_unit_price_pdf` tinyint(1) NOT NULL DEFAULT 0,
  `decimal_quantity_unit_price_pdf` int(11) NOT NULL DEFAULT 2,
  `separate_cash_transactions` tinyint(1) NOT NULL DEFAULT 0,
  `order_cash_income` tinyint(1) NOT NULL DEFAULT 0,
  `generate_order_note_from_quotation` tinyint(1) NOT NULL DEFAULT 0,
  `list_items_by_warehouse` tinyint(1) NOT NULL DEFAULT 0,
  `hide_pdf_view_documents` tinyint(1) NOT NULL DEFAULT 0,
  `ticket_single_shipment` tinyint(1) NOT NULL DEFAULT 0,
  `affect_all_documents` tinyint(1) NOT NULL DEFAULT 0,
  `dashboard_sales` tinyint(1) NOT NULL DEFAULT 1,
  `dashboard_general` tinyint(1) NOT NULL DEFAULT 1,
  `dashboard_clients` tinyint(1) NOT NULL DEFAULT 1,
  `dashboard_products` tinyint(1) NOT NULL DEFAULT 0,
  `restrict_series_selection_seller` tinyint(1) NOT NULL DEFAULT 0,
  `regex_password_user` tinyint(1) NOT NULL DEFAULT 0,
  `enabled_remember_change_password` tinyint(1) NOT NULL DEFAULT 0,
  `quantity_month_remember_change_password` int(11) NOT NULL DEFAULT 1,
  `enabled_point_system` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'sistema por puntos',
  `point_system_sale_amount` decimal(12,2) NOT NULL DEFAULT 1.00 COMMENT 'sistema por puntos',
  `quantity_of_points` decimal(12,2) NOT NULL DEFAULT 1.00 COMMENT 'sistema por puntos',
  `round_points_of_sale` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'sistema por puntos',
  `enable_categories_products_view` tinyint(1) NOT NULL DEFAULT 0,
  `restrict_seller_discount` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'limitar descuento a los vendedores',
  `sellers_discount_limit` decimal(12,2) NOT NULL DEFAULT 0.00 COMMENT 'limitar descuento a los vendedores',
  `enabled_sales_agents` tinyint(1) NOT NULL DEFAULT 0,
  `change_affectation_exonerated_igv` tinyint(1) NOT NULL DEFAULT 0,
  `search_factory_code_items` tinyint(1) NOT NULL DEFAULT 0,
  `show_load_voucher` tinyint(1) NOT NULL DEFAULT 0,
  `enable_discount_by_customer` tinyint(1) NOT NULL DEFAULT 0,
  `register_series_invoice_xml` tinyint(1) NOT NULL DEFAULT 0,
  `enabled_dispatch_ticket_pdf` tinyint(1) NOT NULL DEFAULT 0,
  `show_price_barcode_ticket` tinyint(1) DEFAULT NULL,
  `price_selected_add_product` tinyint(1) NOT NULL DEFAULT 0,
  `pdf_footer_images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`pdf_footer_images`)),
  `restrict_sale_items_cpe` tinyint(1) NOT NULL DEFAULT 0,
  `show_convert_cpe_pos` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `configurations`
--

INSERT INTO `configurations` VALUES (1,1,'default',1,1,0,0,0,0,0,0,1,0,0,1,'{\"id\":1,\"name\":\"Ilimitado\",\"pricing\":99,\"limit_users\":0,\"limit_documents\":0,\"plan_documents\":{\"0\":1,\"1\":2,\"2\":3,\"3\":4},\"locked\":1,\"created_at\":\"2022-01-21 12:26:34\",\"updated_at\":\"2022-01-21 12:26:34\"}',0,'0',NULL,'{\"bg\":\"white\",\"header\":\"light\",\"sidebars\":\"light\",\"navbar\":\"fixed\",\"sidebar_theme\":\"green\"}',2,0,'2022-11-28 20:43:27',391,0,0,1,0.10,1,4,1,1,1,4,'16','03',0,0.00,3.00000,0,0,0,NULL,NULL,1,0,1,0,NULL,1,1,0,0,'{\"type\":\"image\",\"image\":\"https:\\/\\/olti.softlte.net.pe\\/images\\/fondo-5.svg\",\"position_form\":\"right\",\"show_logo_in_form\":true,\"position_logo\":\"top-left\",\"show_socials\":false,\"facebook\":null,\"twitter\":null,\"instagram\":null,\"linkedin\":null}','fixed','{\"apply_arrears\":false,\"arrears_amount\":0}','',NULL,'',0,NULL,0,NULL,'2023-03-01 18:40:45',NULL,NULL,1,1,1,0,0,1,0,0,0,1,0,'PEN',0,0,0,0,0,0,0,0,0,0,1,1,0,0,1,0,0,0,0,0,0,20,0,0,0,0,0,1,7,0,1,15,76,NULL,2,0,0,1,0,2,0,0,0,0,0,0,0,1,1,1,0,0,0,0,1,0,1.00,1.00,0,0,0,0.00,0,0,0,0,0,0,0,NULL,0,NULL,0,0);

--
-- Table structure for table `contract_items`
--

CREATE TABLE `contract_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `contract_id` int(10) unsigned NOT NULL,
  `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`)),
  `name_product_pdf` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `contract_items_contract_id_foreign` (`contract_id`),
  KEY `contract_items_item_id_foreign` (`item_id`),
  KEY `contract_items_affectation_igv_type_id_foreign` (`affectation_igv_type_id`),
  KEY `contract_items_system_isc_type_id_foreign` (`system_isc_type_id`),
  KEY `contract_items_price_type_id_foreign` (`price_type_id`),
  CONSTRAINT `contract_items_affectation_igv_type_id_foreign` FOREIGN KEY (`affectation_igv_type_id`) REFERENCES `cat_affectation_igv_types` (`id`),
  CONSTRAINT `contract_items_contract_id_foreign` FOREIGN KEY (`contract_id`) REFERENCES `contracts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `contract_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`),
  CONSTRAINT `contract_items_price_type_id_foreign` FOREIGN KEY (`price_type_id`) REFERENCES `cat_price_types` (`id`),
  CONSTRAINT `contract_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 `contract_items`
--


--
-- Table structure for table `contract_payments`
--

CREATE TABLE `contract_payments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `contract_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 `contract_payments_contract_id_foreign` (`contract_id`),
  KEY `contract_payments_card_brand_id_foreign` (`card_brand_id`),
  KEY `contract_payments_payment_method_type_id_foreign` (`payment_method_type_id`),
  CONSTRAINT `contract_payments_card_brand_id_foreign` FOREIGN KEY (`card_brand_id`) REFERENCES `card_brands` (`id`),
  CONSTRAINT `contract_payments_contract_id_foreign` FOREIGN KEY (`contract_id`) REFERENCES `contracts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `contract_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 `contract_payments`
--


--
-- Table structure for table `contract_state_types`
--

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

--
-- Dumping data for table `contract_state_types`
--

INSERT INTO `contract_state_types` VALUES ('01','Registrado'),('05','Entregado'),('09','Rechazado');

--
-- Table structure for table `contracts`
--

CREATE TABLE `contracts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `seller_id` int(10) unsigned DEFAULT NULL,
  `external_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `establishment_id` int(10) unsigned NOT NULL,
  `establishment` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`establishment`)),
  `soap_type_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state_type_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `prefix` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_of_issue` date NOT NULL,
  `time_of_issue` time NOT NULL,
  `date_of_due` date DEFAULT NULL,
  `delivery_date` date DEFAULT NULL,
  `customer_id` int(10) unsigned NOT NULL,
  `customer` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`customer`)),
  `shipping_address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_method_type_id` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `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,
  `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`)),
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `terms_condition` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `changed` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `quotation_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `contracts_user_id_foreign` (`user_id`),
  KEY `contracts_establishment_id_foreign` (`establishment_id`),
  KEY `contracts_customer_id_foreign` (`customer_id`),
  KEY `contracts_soap_type_id_foreign` (`soap_type_id`),
  KEY `contracts_currency_type_id_foreign` (`currency_type_id`),
  KEY `contracts_payment_method_type_id_foreign` (`payment_method_type_id`),
  KEY `contracts_quotation_id_foreign` (`quotation_id`),
  KEY `contracts_state_type_id_foreign` (`state_type_id`),
  CONSTRAINT `contracts_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`),
  CONSTRAINT `contracts_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `contracts_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`),
  CONSTRAINT `contracts_payment_method_type_id_foreign` FOREIGN KEY (`payment_method_type_id`) REFERENCES `payment_method_types` (`id`),
  CONSTRAINT `contracts_quotation_id_foreign` FOREIGN KEY (`quotation_id`) REFERENCES `quotations` (`id`),
  CONSTRAINT `contracts_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `contracts_state_type_id_foreign` FOREIGN KEY (`state_type_id`) REFERENCES `contract_state_types` (`id`),
  CONSTRAINT `contracts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contracts`
--


--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  KEY `countries_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES ('AX','AALAND ISLANDS',1),('AF','AFGHANISTAN',1),('AL','ALBANIA',1),('DZ','ALGERIA',1),('AS','AMERICAN SAMOA',1),('AD','ANDORRA',1),('AO','ANGOLA',1),('AI','ANGUILLA',1),('AQ','ANTARCTICA',1),('AG','ANTIGUA AND BARBUDA',1),('AR','ARGENTINA',1),('AM','ARMENIA',1),('AW','ARUBA',1),('AU','AUSTRALIA',1),('AT','AUSTRIA',1),('AZ','AZERBAIJAN',1),('BS','BAHAMAS',1),('BH','BAHRAIN',1),('BD','BANGLADESH',1),('BB','BARBADOS',1),('BY','BELARUS',1),('BE','BELGIUM',1),('BZ','BELIZE',1),('BJ','BENIN',1),('BM','BERMUDA',1),('BT','BHUTAN',1),('BO','BOLIVIA',1),('BA','BOSNIA AND HERZEGOWINA',1),('BW','BOTSWANA',1),('BV','BOUVET ISLAND',1),('BR','BRAZIL',1),('IO','BRITISH INDIAN OCEAN TERRITORY',1),('BN','BRUNEI DARUSSALAM',1),('BG','BULGARIA',1),('BF','BURKINA FASO',1),('BI','BURUNDI',1),('KH','CAMBODIA',1),('CM','CAMEROON',1),('CA','CANADA',1),('CV','CAPE VERDE',1),('KY','CAYMAN ISLANDS',1),('CF','CENTRAL AFRICAN REPUBLIC',1),('TD','CHAD',1),('CL','CHILE',1),('CN','CHINA',1),('CX','CHRISTMAS ISLAND',1),('CC','COCOS (KEELING) ISLANDS',1),('CO','COLOMBIA',1),('KM','COMOROS',1),('CD','CONGO, Democratic Republic of (was Zaire)',1),('CG','CONGO, Republic of',1),('CK','COOK ISLANDS',1),('CR','COSTA RICA',1),('CI','COTE D`IVOIRE',1),('HR','CROATIA (local name: Hrvatska)',1),('CU','CUBA',1),('CY','CYPRUS',1),('CZ','CZECH REPUBLIC',1),('DK','DENMARK',1),('DJ','DJIBOUTI',1),('DM','DOMINICA',1),('DO','DOMINICAN REPUBLIC',1),('EC','ECUADOR',1),('EG','EGYPT',1),('SV','EL SALVADOR',1),('GQ','EQUATORIAL GUINEA',1),('ER','ERITREA',1),('EE','ESTONIA',1),('ET','ETHIOPIA',1),('FK','FALKLAND ISLANDS (MALVINAS)',1),('FO','FAROE ISLANDS',1),('FJ','FIJI',1),('FI','FINLAND',1),('FR','FRANCE',1),('GF','FRENCH GUIANA',1),('PF','FRENCH POLYNESIA',1),('TF','FRENCH SOUTHERN TERRITORIES',1),('GA','GABON',1),('GM','GAMBIA',1),('GE','GEORGIA',1),('DE','GERMANY',1),('GH','GHANA',1),('GI','GIBRALTAR',1),('GR','GREECE',1),('GL','GREENLAND',1),('GD','GRENADA',1),('GP','GUADELOUPE',1),('GU','GUAM',1),('GT','GUATEMALA',1),('GN','GUINEA',1),('GW','GUINEA-BISSAU',1),('GY','GUYANA',1),('HT','HAITI',1),('HM','HEARD AND MC DONALD ISLANDS',1),('HN','HONDURAS',1),('HK','HONG KONG',1),('HU','HUNGARY',1),('IS','ICELAND',1),('IN','INDIA',1),('ID','INDONESIA',1),('IR','IRAN (ISLAMIC REPUBLIC OF)',1),('IQ','IRAQ',1),('IE','IRELAND',1),('IL','ISRAEL',1),('IT','ITALY',1),('JM','JAMAICA',1),('JP','JAPAN',1),('JO','JORDAN',1),('KZ','KAZAKHSTAN',1),('KE','KENYA',1),('KI','KIRIBATI',1),('KP','KOREA, DEMOCRATIC PEOPLE`S REPUBLIC OF',1),('KR','KOREA, REPUBLIC OF',1),('KW','KUWAIT',1),('KG','KYRGYZSTAN',1),('LA','LAO PEOPLE`S DEMOCRATIC REPUBLIC',1),('LV','LATVIA',1),('LB','LEBANON',1),('LS','LESOTHO',1),('LR','LIBERIA',1),('LY','LIBYAN ARAB JAMAHIRIYA',1),('LI','LIECHTENSTEIN',1),('LT','LITHUANIA',1),('LU','LUXEMBOURG',1),('MO','MACAU',1),('MK','MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF',1),('MG','MADAGASCAR',1),('MW','MALAWI',1),('MY','MALAYSIA',1),('MV','MALDIVES',1),('ML','MALI',1),('MT','MALTA',1),('MH','MARSHALL ISLANDS',1),('MQ','MARTINIQUE',1),('MR','MAURITANIA',1),('MU','MAURITIUS',1),('YT','MAYOTTE',1),('MX','MEXICO',1),('FM','MICRONESIA, FEDERATED STATES OF',1),('MD','MOLDOVA, REPUBLIC OF',1),('MC','MONACO',1),('MN','MONGOLIA',1),('MS','MONTSERRAT',1),('MA','MOROCCO',1),('MZ','MOZAMBIQUE',1),('MM','MYANMAR',1),('NA','NAMIBIA',1),('NR','NAURU',1),('NP','NEPAL',1),('NL','NETHERLANDS',1),('AN','NETHERLANDS ANTILLES',1),('NC','NEW CALEDONIA',1),('NZ','NEW ZEALAND',1),('NI','NICARAGUA',1),('NE','NIGER',1),('NG','NIGERIA',1),('NU','NIUE',1),('NF','NORFOLK ISLAND',1),('MP','NORTHERN MARIANA ISLANDS',1),('NO','NORWAY',1),('OM','OMAN',1),('PK','PAKISTAN',1),('PW','PALAU',1),('PS','PALESTINIAN TERRITORY, Occupied',1),('PA','PANAMA',1),('PG','PAPUA NEW GUINEA',1),('PY','PARAGUAY',1),('PE','PERU',1),('PH','PHILIPPINES',1),('PN','PITCAIRN',1),('PL','POLAND',1),('PT','PORTUGAL',1),('PR','PUERTO RICO',1),('QA','QATAR',1),('RE','REUNION',1),('RO','ROMANIA',1),('RU','RUSSIAN FEDERATION',1),('RW','RWANDA',1),('SH','SAINT HELENA',1),('KN','SAINT KITTS AND NEVIS',1),('LC','SAINT LUCIA',1),('PM','SAINT PIERRE AND MIQUELON',1),('VC','SAINT VINCENT AND THE GRENADINES',1),('WS','SAMOA',1),('SM','SAN MARINO',1),('ST','SAO TOME AND PRINCIPE',1),('SA','SAUDI ARABIA',1),('SN','SENEGAL',1),('CS','SERBIA AND MONTENEGRO',1),('SC','SEYCHELLES',1),('SL','SIERRA LEONE',1),('SG','SINGAPORE',1),('SK','SLOVAKIA',1),('SI','SLOVENIA',1),('SB','SOLOMON ISLANDS',1),('SO','SOMALIA',1),('ZA','SOUTH AFRICA',1),('GS','SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS',1),('ES','SPAIN',1),('LK','SRI LANKA',1),('SD','SUDAN',1),('SR','SURINAME',1),('SJ','SVALBARD AND JAN MAYEN ISLANDS',1),('SZ','SWAZILAND',1),('SE','SWEDEN',1),('CH','SWITZERLAND',1),('SY','SYRIAN ARAB REPUBLIC',1),('TW','TAIWAN',1),('TJ','TAJIKISTAN',1),('TZ','TANZANIA, UNITED REPUBLIC OF',1),('TH','THAILAND',1),('TL','TIMOR-LESTE',1),('TG','TOGO',1),('TK','TOKELAU',1),('TO','TONGA',1),('TT','TRINIDAD AND TOBAGO',1),('TN','TUNISIA',1),('TR','TURKEY',1),('TM','TURKMENISTAN',1),('TC','TURKS AND CAICOS ISLANDS',1),('TV','TUVALU',1),('UG','UGANDA',1),('UA','UKRAINE',1),('AE','UNITED ARAB EMIRATES',1),('GB','UNITED KINGDOM',1),('US','UNITED STATES',1),('UM','UNITED STATES MINOR OUTLYING ISLANDS',1),('UY','URUGUAY',1),('UZ','UZBEKISTAN',1),('VU','VANUATU',1),('VA','VATICAN CITY STATE (HOLY SEE)',1),('VE','VENEZUELA',1),('VN','VIET NAM',1),('VG','VIRGIN ISLANDS (BRITISH)',1),('VI','VIRGIN ISLANDS (U.S.)',1),('WF','WALLIS AND FUTUNA ISLANDS',1),('EH','WESTERN SAHARA',1),('YE','YEMEN',1),('ZM','ZAMBIA',1),('ZW','ZIMBABWE',1);

--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  KEY `departments_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `departments`
--

INSERT INTO `departments` VALUES ('01','AMAZONAS',1),('02','ÁNCASH',1),('03','APURIMAC',1),('04','AREQUIPA',1),('05','AYACUCHO',1),('06','CAJAMARCA',1),('07','CALLAO',1),('08','CUSCO',1),('09','HUANCAVELICA',1),('10','HUÁNUCO',1),('11','ICA',1),('12','JUNÍN',1),('13','LA LIBERTAD',1),('14','LAMBAYEQUE',1),('15','LIMA',1),('16','LORETO',1),('17','MADRE DE DIOS',1),('18','MOQUEGUA',1),('19','PASCO',1),('20','PIURA',1),('21','PUNO',1),('22','SAN MARTIN',1),('23','TACNA',1),('24','TUMBES',1),('25','UCAYALI',1);

--
-- Table structure for table `devolution_items`
--

CREATE TABLE `devolution_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `devolution_id` int(10) unsigned NOT NULL,
  `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,
  PRIMARY KEY (`id`),
  KEY `devolution_items_devolution_id_foreign` (`devolution_id`),
  KEY `devolution_items_item_id_foreign` (`item_id`),
  CONSTRAINT `devolution_items_devolution_id_foreign` FOREIGN KEY (`devolution_id`) REFERENCES `devolutions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `devolution_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `devolution_items`
--


--
-- Table structure for table `devolution_reasons`
--

CREATE TABLE `devolution_reasons` (
  `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 `devolution_reasons`
--

INSERT INTO `devolution_reasons` VALUES (1,'Productos vencidos',NULL,NULL),(2,'Productos dañados',NULL,NULL),(3,'Productos con errores de Fábrica',NULL,NULL);

--
-- Table structure for table `devolutions`
--

CREATE TABLE `devolutions` (
  `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,
  `prefix` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_of_issue` date NOT NULL,
  `time_of_issue` time NOT NULL,
  `devolution_reason_id` int(10) unsigned NOT NULL,
  `observation` varchar(500) COLLATE utf8mb4_unicode_ci 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`),
  KEY `devolutions_user_id_foreign` (`user_id`),
  KEY `devolutions_establishment_id_foreign` (`establishment_id`),
  KEY `devolutions_devolution_reason_id_foreign` (`devolution_reason_id`),
  KEY `devolutions_soap_type_id_foreign` (`soap_type_id`),
  KEY `devolutions_state_type_id_foreign` (`state_type_id`),
  CONSTRAINT `devolutions_devolution_reason_id_foreign` FOREIGN KEY (`devolution_reason_id`) REFERENCES `devolution_reasons` (`id`),
  CONSTRAINT `devolutions_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`),
  CONSTRAINT `devolutions_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `devolutions_state_type_id_foreign` FOREIGN KEY (`state_type_id`) REFERENCES `state_types` (`id`),
  CONSTRAINT `devolutions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `devolutions`
--


--
-- Table structure for table `dispatch_addresses`
--

CREATE TABLE `dispatch_addresses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `person_id` int(10) unsigned NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `location_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`location_id`)),
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `dispatch_address_unique` (`person_id`,`address`),
  CONSTRAINT `dispatch_addresses_person_id_foreign` FOREIGN KEY (`person_id`) REFERENCES `persons` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dispatch_addresses`
--


--
-- Table structure for table `dispatch_items`
--

CREATE TABLE `dispatch_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dispatch_id` int(10) unsigned NOT NULL,
  `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,
  `name_product_pdf` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `additional_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`additional_data`)),
  PRIMARY KEY (`id`),
  KEY `dispatch_items_dispatch_id_foreign` (`dispatch_id`),
  KEY `dispatch_items_item_id_foreign` (`item_id`),
  CONSTRAINT `dispatch_items_dispatch_id_foreign` FOREIGN KEY (`dispatch_id`) REFERENCES `dispatches` (`id`) ON DELETE CASCADE,
  CONSTRAINT `dispatch_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=335 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dispatch_items`
--

INSERT INTO `dispatch_items` VALUES (1,1,2698,'{\"description\":\"PUL JUGO X 250ML\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI2698\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',50.0000,NULL,NULL),(2,1,203,'{\"description\":\"GALLETA CLUB SOCIAL 26G\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI203\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',70.0000,NULL,NULL),(3,1,204,'{\"description\":\"GALLETA OREO ORIGINAL x 1 UND\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI204\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',90.0000,NULL,NULL),(4,1,825,'{\"description\":\"SPORADE  X 500 ML\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI825\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',50.0000,NULL,NULL),(5,1,1116,'{\"description\":\"AGUA SAN CARLOS x 625 ML\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1116\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',150.0000,NULL,NULL),(6,2,1116,'{\"description\":\"AGUA SAN CARLOS x 625 ML\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1116\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',525.0000,NULL,NULL),(7,3,1116,'{\"description\":\"AGUA SAN CARLOS x 625 ML\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1116\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',17.0000,NULL,NULL),(8,4,2807,'{\"description\":\"VASO DESCARTABLE TRANSPARENTE X 100U 9 OZ\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI2807\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(9,4,2698,'{\"description\":\"PUL JUGO X 250ML\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI2698\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',40.0000,NULL,NULL),(10,4,636,'{\"description\":\"GALLETA SODA  DIA X 26G\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI636\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',40.0000,NULL,NULL),(11,4,1735,'{\"description\":\"AGUA DE MESA  X  20 LIT  MONTA\\u00d1A AZUL\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1735\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(12,5,2807,'{\"description\":\"VASO DESCARTABLE TRANSPARENTE X 100U 9 OZ\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI2807\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(13,5,2698,'{\"description\":\"PUL JUGO X 250ML\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI2698\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',40.0000,NULL,NULL),(14,5,636,'{\"description\":\"GALLETA SODA  DIA X 26G\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI636\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',40.0000,NULL,NULL),(15,5,1735,'{\"description\":\"AGUA DE MESA  X  20 LIT  MONTA\\u00d1A AZUL\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1735\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(16,6,1387,'{\"description\":\"LEJIA CLOROX x 4000 ML\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1387\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',10.0000,NULL,NULL),(17,6,698,'{\"description\":\"JABON MARSELLA x 210 GR\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI698\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',50.0000,NULL,NULL),(18,6,88,'{\"description\":\"DETERGENTE ARIEL x 800 GR\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI088\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',30.0000,NULL,NULL),(19,7,2698,'{\"description\":\"PUL JUGO X 250ML\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI2698\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',40.0000,NULL,NULL),(20,7,203,'{\"description\":\"GALLETA CLUB SOCIAL 26G\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI203\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',40.0000,NULL,NULL),(21,8,825,'{\"description\":\"SPORADE  X 500 ML\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI825\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',54.0000,NULL,NULL),(22,9,3899,'{\"description\":\"PERFUMADOR AMBIENTAL LAVANDA X 1 LIT ORIENTAL\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3899\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',5.0000,NULL,NULL),(23,9,1990,'{\"description\":\"PISTOLA ESPARCIBLE CON BOCA DE METAL\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1990\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',5.0000,NULL,NULL),(54,25,825,'{\"description\":\"SPORADE  X 500 ML\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI825\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',54.0000,NULL,NULL),(55,25,672,'{\"description\":\"GALLETA RELLENITA  COCO X 36G\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI672\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',100.0000,NULL,NULL),(58,27,825,'{\"description\":\"SPORADE  X 500 ML\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI825\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(59,27,452,'{\"description\":\"DETERG CARICIA X 100G\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI452\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(60,27,809,'{\"description\":\"P.H PARACAS  DOBLE HOJA NEGRO X 4 X40MT\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI809\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(61,28,1995,'{\"description\":\"AGUA CASSINELLI X 7 LT\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1995\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(62,29,1995,'{\"description\":\"AGUA CASSINELLI X 7 LT\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1995\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(63,30,1995,'{\"description\":\"AGUA CASSINELLI X 7 LT\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1995\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(64,31,1995,'{\"description\":\"AGUA CASSINELLI X 7 LT\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1995\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(65,32,1995,'{\"description\":\"AGUA CASSINELLI X 7 LT\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1995\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(66,33,3658,'{\"description\":\"12 SEMILLAS\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3658\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(67,34,1995,'{\"description\":\"AGUA CASSINELLI X 7 LT\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1995\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(68,35,1995,'{\"description\":\"AGUA CASSINELLI X 7 LT\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1995\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(69,36,3658,'{\"description\":\"12 SEMILLAS\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3658\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(70,37,1995,'{\"description\":\"AGUA CASSINELLI X 7 LT\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1995\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(71,38,1995,'{\"description\":\"AGUA CASSINELLI X 7 LT\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1995\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(72,39,3338,'{\"description\":\"YUCA X 1 K\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3338\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',20.0000,NULL,NULL),(73,39,3719,'{\"description\":\"PAPA CANCHAN BLANCA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3719\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',36.0000,NULL,NULL),(74,39,3779,'{\"description\":\"NABO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3779\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',7.1400,NULL,NULL),(75,39,3332,'{\"description\":\"CAMOTE X 1K\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3332\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',7.0000,NULL,NULL),(76,39,3777,'{\"description\":\"AJO ENTERO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3777\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',5.5000,NULL,NULL),(77,39,3776,'{\"description\":\"CEBOLLA MORADA x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3776\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',5.0000,NULL,NULL),(78,39,3772,'{\"description\":\"CEBOLLA CHINA x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3772\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',0.5000,NULL,NULL),(79,39,3773,'{\"description\":\"COLIFLOR x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3773\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',3.5000,NULL,NULL),(80,39,3771,'{\"description\":\"LECHUGA x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3771\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',0.8200,NULL,NULL),(81,39,3769,'{\"description\":\"ESPINACA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3769\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.7500,NULL,NULL),(82,39,3335,'{\"description\":\"BROCOLI X 1 K\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3335\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',4.0000,NULL,NULL),(83,39,2156,'{\"description\":\"DONOFRIO PANETON CAJA 6X900G\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI2156\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',3.0000,NULL,NULL),(84,39,3767,'{\"description\":\"PAN FRANCES\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3767\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',75.0000,NULL,NULL),(85,39,3766,'{\"description\":\"PAN DE MOLDE FUENTE\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3766\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',18.0000,NULL,NULL),(86,39,1023,'{\"description\":\"YOGURT GLORIA FRESA  x 1 LITRO\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1023\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(87,39,3765,'{\"description\":\"MANTEQUILLA A GRANEL x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3765\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',5.5000,NULL,NULL),(88,39,3764,'{\"description\":\"ACEITUNA NEGRA A GRANEL x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3764\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',5.5000,NULL,NULL),(89,39,3763,'{\"description\":\"PALTA FUERTE\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3763\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',10.0000,NULL,NULL),(90,39,3762,'{\"description\":\"NARANJA VALENCIA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3762\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',17.0000,NULL,NULL),(91,39,1685,'{\"description\":\"MANZANA VERDE X 1K\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1685\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',20.0000,NULL,NULL),(92,39,3760,'{\"description\":\"PAPAYA CATEGORIA EXTRA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3760\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',11.5000,NULL,NULL),(93,39,3759,'{\"description\":\"MANZANA WINTER\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3759\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',120.0000,NULL,NULL),(94,39,3758,'{\"description\":\"PLATANO MADURO\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3758\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',43.0000,NULL,NULL),(95,39,3757,'{\"description\":\"PLATANO DE SEDA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3757\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.0000,NULL,NULL),(96,39,3756,'{\"description\":\"PLATANO VERDE\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3756\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',25.0000,NULL,NULL),(97,39,1773,'{\"description\":\"LIMON FRUTO\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1773\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',9.4400,NULL,NULL),(98,39,3782,'{\"description\":\"COCONA x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3782\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.0000,NULL,NULL),(99,39,3754,'{\"description\":\"MARACUYA x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3754\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',4.0000,NULL,NULL),(100,39,2023,'{\"description\":\"HUEVOS\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI2023\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',13.4300,NULL,NULL),(101,39,3753,'{\"description\":\"JAMONADA x 800GR x EMP x 24\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3753\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',5.0000,NULL,NULL),(102,39,2945,'{\"description\":\"HOT DOG C\\/POLLO RAZZETO\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI2945\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',9.0000,NULL,NULL),(103,39,4093,'{\"description\":\"CARNE DE SAJINO SECA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"KGM\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',9.0000,NULL,NULL),(104,39,3752,'{\"description\":\"PESCADO JUREL AL PESO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3752\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',23.8000,NULL,NULL),(105,39,3751,'{\"description\":\"PESCADO BONITO AL PESO x 1 KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3751\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',32.3000,NULL,NULL),(106,39,3750,'{\"description\":\"CARNE DE RES LOMO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3750\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',26.0000,NULL,NULL),(107,39,3749,'{\"description\":\"CARNE DE RES CON HUESO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3749\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',20.0000,NULL,NULL),(108,39,3337,'{\"description\":\"POLLO X 1K\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3337\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',30.1800,NULL,NULL),(109,39,3748,'{\"description\":\"HIGADO DE POLLO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3748\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',11.7000,NULL,NULL),(110,39,3747,'{\"description\":\"CARNE DE GUISO DE PECHUGA DE PAVITA x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3747\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',15.0000,NULL,NULL),(111,39,3789,'{\"description\":\"HARINA DE 7  SEMILLAS X 1 KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3789\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(112,39,3745,'{\"description\":\"MARLO DE MAIZ MORADO x 1 KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3745\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',3.0000,NULL,NULL),(113,40,3338,'{\"description\":\"YUCA X 1 K\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3338\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',20.0000,NULL,NULL),(114,40,3719,'{\"description\":\"PAPA CANCHAN BLANCA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3719\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',36.0000,NULL,NULL),(115,40,3779,'{\"description\":\"NABO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3779\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',7.1400,NULL,NULL),(116,40,3332,'{\"description\":\"CAMOTE X 1K\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3332\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',7.0000,NULL,NULL),(117,40,3777,'{\"description\":\"AJO ENTERO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3777\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',5.5000,NULL,NULL),(118,40,3776,'{\"description\":\"CEBOLLA MORADA x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3776\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',5.0000,NULL,NULL),(119,40,3772,'{\"description\":\"CEBOLLA CHINA x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3772\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',0.5000,NULL,NULL),(120,40,3773,'{\"description\":\"COLIFLOR x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3773\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',3.5000,NULL,NULL),(121,40,3771,'{\"description\":\"LECHUGA x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3771\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',0.8200,NULL,NULL),(122,40,3769,'{\"description\":\"ESPINACA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3769\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.7500,NULL,NULL),(123,40,3335,'{\"description\":\"BROCOLI X 1 K\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3335\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',4.0000,NULL,NULL),(124,40,2156,'{\"description\":\"DONOFRIO PANETON CAJA 6X900G\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI2156\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',3.0000,NULL,NULL),(125,40,3767,'{\"description\":\"PAN FRANCES\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3767\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',75.0000,NULL,NULL),(126,40,3766,'{\"description\":\"PAN DE MOLDE FUENTE\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3766\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',18.0000,NULL,NULL),(127,40,1023,'{\"description\":\"YOGURT GLORIA FRESA  x 1 LITRO\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1023\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(128,40,3765,'{\"description\":\"MANTEQUILLA A GRANEL x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3765\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',5.5000,NULL,NULL),(129,40,3764,'{\"description\":\"ACEITUNA NEGRA A GRANEL x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3764\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',5.5000,NULL,NULL),(130,40,3763,'{\"description\":\"PALTA FUERTE\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3763\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',10.0000,NULL,NULL),(131,40,3762,'{\"description\":\"NARANJA VALENCIA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3762\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',17.0000,NULL,NULL),(132,40,1685,'{\"description\":\"MANZANA VERDE X 1K\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1685\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',20.0000,NULL,NULL),(133,40,3760,'{\"description\":\"PAPAYA CATEGORIA EXTRA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3760\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',11.5000,NULL,NULL),(134,40,3759,'{\"description\":\"MANZANA WINTER\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3759\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',120.0000,NULL,NULL),(135,40,3758,'{\"description\":\"PLATANO MADURO\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3758\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',43.0000,NULL,NULL),(136,40,3757,'{\"description\":\"PLATANO DE SEDA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3757\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.0000,NULL,NULL),(137,40,3756,'{\"description\":\"PLATANO VERDE\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3756\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',25.0000,NULL,NULL),(138,40,1773,'{\"description\":\"LIMON FRUTO\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1773\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',9.4400,NULL,NULL),(139,40,3782,'{\"description\":\"COCONA x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3782\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.0000,NULL,NULL),(140,40,3754,'{\"description\":\"MARACUYA x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3754\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',4.0000,NULL,NULL),(141,40,2023,'{\"description\":\"HUEVOS\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI2023\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',13.4300,NULL,NULL),(142,40,3753,'{\"description\":\"JAMONADA x 800GR x EMP x 24\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3753\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',5.0000,NULL,NULL),(143,40,2945,'{\"description\":\"HOT DOG C\\/POLLO RAZZETO\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI2945\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',9.0000,NULL,NULL),(144,40,4093,'{\"description\":\"CARNE DE SAJINO SECA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"KGM\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',9.0000,NULL,NULL),(145,40,3752,'{\"description\":\"PESCADO JUREL AL PESO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3752\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',23.8000,NULL,NULL),(146,40,3751,'{\"description\":\"PESCADO BONITO AL PESO x 1 KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3751\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',32.3000,NULL,NULL),(147,40,3750,'{\"description\":\"CARNE DE RES LOMO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3750\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',26.0000,NULL,NULL),(148,40,3749,'{\"description\":\"CARNE DE RES CON HUESO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3749\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',20.0000,NULL,NULL),(149,40,3337,'{\"description\":\"POLLO X 1K\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3337\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',30.1800,NULL,NULL),(150,40,3748,'{\"description\":\"HIGADO DE POLLO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3748\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',11.7000,NULL,NULL),(151,40,3747,'{\"description\":\"CARNE DE GUISO DE PECHUGA DE PAVITA x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3747\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',15.0000,NULL,NULL),(152,40,3789,'{\"description\":\"HARINA DE 7  SEMILLAS X 1 KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3789\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(153,40,3745,'{\"description\":\"MARLO DE MAIZ MORADO x 1 KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3745\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',3.0000,NULL,NULL),(154,41,4105,'{\"description\":\"TE, CANEL Y CLAVO FILTRANTE X 100U\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(155,41,3787,'{\"description\":\"MANZANILLA FILTRANTE MCCOLINS X 100U\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3787\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(156,41,4103,'{\"description\":\"ANIS FILTRANTE X 100U\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(157,41,3744,'{\"description\":\"PALLAR x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3744\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',11.0000,NULL,NULL),(158,41,4102,'{\"description\":\"LENTEJA X 1K\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',12.0000,NULL,NULL),(159,41,3743,'{\"description\":\"HABA ENTERA SECA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3743\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',14.0000,NULL,NULL),(160,41,3742,'{\"description\":\"ARVERJA VERDE SECA ENTERA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3742\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',11.0000,NULL,NULL),(161,41,2635,'{\"description\":\"SILLAO TITO X 150ML\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI2635\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.0000,NULL,NULL),(162,41,1421,'{\"description\":\"GELATINA KOKY x 180 GR\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1421\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',7.0000,NULL,NULL),(163,41,4099,'{\"description\":\"LECHE EVAPORADA ENTERA X 400G X 24\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.0000,NULL,NULL),(164,41,4098,'{\"description\":\"VINAGRE BLANCO X 5 LT\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(165,41,1967,'{\"description\":\"SIBARITA BGRDE\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1967\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(166,41,4096,'{\"description\":\"ATUN EN FILETE EN ACEITE VEGETAL X 180G X 48U\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(167,41,1735,'{\"description\":\"AGUA DE MESA  X  20 LIT  MONTA\\u00d1A AZUL\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1735\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',7.0000,NULL,NULL),(168,41,4095,'{\"description\":\"CHOCOLATE CUZCO X 90 G\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',6.0000,NULL,NULL),(169,41,4094,'{\"description\":\"HARINA DE PLATANO X 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',4.0000,NULL,NULL),(170,41,2410,'{\"description\":\"CAFE DESCAFEINADO X 180G\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI2410\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.0000,NULL,NULL),(171,41,1873,'{\"description\":\"ARROZ NIR X 1 KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1873\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',29.1250,NULL,NULL),(172,41,3706,'{\"description\":\"CEBADA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3706\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',16.0000,NULL,NULL),(173,41,2982,'{\"description\":\"QUAKER AVENA CON QUINUA X 360G\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI2982\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',4.0000,NULL,NULL),(174,41,639,'{\"description\":\"FIDEO NICOLINI CABELLO DE ANGEL x 250 GR\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI639\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',23.0000,NULL,NULL),(175,41,723,'{\"description\":\"FIDEO NICOLINI X 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI723\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',6.0000,NULL,NULL),(176,41,3701,'{\"description\":\"ACEITE FRIOL x 5L\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3701\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.0000,NULL,NULL),(177,42,3781,'{\"description\":\"CULANTRO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3781\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',3.0000,NULL,NULL),(178,42,3338,'{\"description\":\"YUCA X 1 K\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3338\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',26.0000,NULL,NULL),(179,42,3719,'{\"description\":\"PAPA CANCHAN BLANCA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3719\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',53.0000,NULL,NULL),(180,42,3780,'{\"description\":\"ZANAHORIA x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3780\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',5.0000,NULL,NULL),(181,42,3779,'{\"description\":\"NABO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3779\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(182,42,3332,'{\"description\":\"CAMOTE X 1K\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3332\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',19.0000,NULL,NULL),(183,42,3778,'{\"description\":\"ZAPALLO MACRE x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3778\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',6.5000,NULL,NULL),(184,42,3777,'{\"description\":\"AJO ENTERO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3777\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',3.5000,NULL,NULL),(185,42,3776,'{\"description\":\"CEBOLLA MORADA x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3776\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',26.0000,NULL,NULL),(186,42,3775,'{\"description\":\"PIMIENTO CRIOLLO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3775\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(187,42,3774,'{\"description\":\"PEPINILLO x 1 KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3774\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',9.0000,NULL,NULL),(188,42,3773,'{\"description\":\"COLIFLOR x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3773\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.5000,NULL,NULL),(189,42,3772,'{\"description\":\"CEBOLLA CHINA x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3772\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.2500,NULL,NULL),(190,42,3771,'{\"description\":\"LECHUGA x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3771\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',6.6800,NULL,NULL),(191,42,3770,'{\"description\":\"CAIGUA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3770\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',5.8700,NULL,NULL),(192,42,3769,'{\"description\":\"ESPINACA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3769\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.7500,NULL,NULL),(193,42,3334,'{\"description\":\"TOMATE X 1K\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3334\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',20.5000,NULL,NULL),(194,42,3335,'{\"description\":\"BROCOLI X 1 K\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3335\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',4.7500,NULL,NULL),(195,42,3767,'{\"description\":\"PAN FRANCES\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3767\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',200.0000,NULL,NULL),(196,42,3766,'{\"description\":\"PAN DE MOLDE FUENTE\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3766\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',12.0000,NULL,NULL),(197,42,1023,'{\"description\":\"YOGURT GLORIA FRESA  x 1 LITRO\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1023\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',6.0000,NULL,NULL),(198,42,3765,'{\"description\":\"MANTEQUILLA A GRANEL x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3765\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.5000,NULL,NULL),(199,42,3764,'{\"description\":\"ACEITUNA NEGRA A GRANEL x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3764\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.0000,NULL,NULL),(200,42,3763,'{\"description\":\"PALTA FUERTE\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3763\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',8.0200,NULL,NULL),(201,42,3762,'{\"description\":\"NARANJA VALENCIA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3762\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',4.7400,NULL,NULL),(202,42,3761,'{\"description\":\"MANDARINA SATSUMA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3761\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',26.0000,NULL,NULL),(203,42,3760,'{\"description\":\"PAPAYA CATEGORIA EXTRA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3760\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',11.5700,NULL,NULL),(204,42,3759,'{\"description\":\"MANZANA WINTER\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3759\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',20.0000,NULL,NULL),(205,42,3758,'{\"description\":\"PLATANO MADURO\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3758\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',58.0000,NULL,NULL),(206,42,3757,'{\"description\":\"PLATANO DE SEDA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3757\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',4.0000,NULL,NULL),(207,42,3756,'{\"description\":\"PLATANO VERDE\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3756\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',42.0000,NULL,NULL),(208,42,1773,'{\"description\":\"LIMON FRUTO\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1773\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',11.8900,NULL,NULL),(209,42,3782,'{\"description\":\"COCONA x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3782\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',3.5000,NULL,NULL),(210,42,3754,'{\"description\":\"MARACUYA x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3754\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',7.0000,NULL,NULL),(211,42,2023,'{\"description\":\"HUEVOS\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI2023\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',28.2700,NULL,NULL),(212,42,3753,'{\"description\":\"JAMONADA x 800GR x EMP x 24\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3753\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',9.0000,NULL,NULL),(213,42,2945,'{\"description\":\"HOT DOG C\\/POLLO RAZZETO\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI2945\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',0.5000,NULL,NULL),(214,42,4093,'{\"description\":\"CARNE DE SAJINO SECA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"KGM\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',21.0000,NULL,NULL),(215,42,3752,'{\"description\":\"PESCADO JUREL AL PESO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3752\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',13.5000,NULL,NULL),(216,42,3751,'{\"description\":\"PESCADO BONITO AL PESO x 1 KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3751\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',19.0200,NULL,NULL),(217,42,3750,'{\"description\":\"CARNE DE RES LOMO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3750\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',14.0000,NULL,NULL),(218,42,3749,'{\"description\":\"CARNE DE RES CON HUESO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3749\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',12.0000,NULL,NULL),(219,42,3337,'{\"description\":\"POLLO X 1K\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3337\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',29.5300,NULL,NULL),(220,42,3748,'{\"description\":\"HIGADO DE POLLO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3748\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',3.0000,NULL,NULL),(221,42,3747,'{\"description\":\"CARNE DE GUISO DE PECHUGA DE PAVITA x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3747\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',14.2400,NULL,NULL),(222,42,3745,'{\"description\":\"MARLO DE MAIZ MORADO x 1 KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3745\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',12.0000,NULL,NULL),(223,43,4105,'{\"description\":\"TE, CANEL Y CLAVO FILTRANTE X 100U\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(224,43,4104,'{\"description\":\"MANZANILLA FILTRANTE X 00U\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(225,43,3785,'{\"description\":\"HIERBA LUISA FILTRANTE X 100U\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3785\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.0000,NULL,NULL),(226,43,3744,'{\"description\":\"PALLAR x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3744\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',14.0000,NULL,NULL),(227,43,4102,'{\"description\":\"LENTEJA X 1K\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',4.0000,NULL,NULL),(228,43,3743,'{\"description\":\"HABA ENTERA SECA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3743\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(229,43,3742,'{\"description\":\"ARVERJA VERDE SECA ENTERA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3742\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',5.0000,NULL,NULL),(230,43,1794,'{\"description\":\"GELATINA X 150G\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1794\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',9.0000,NULL,NULL),(231,43,4100,'{\"description\":\"GALLETA SODA X 240G\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',4.0000,NULL,NULL),(232,43,4099,'{\"description\":\"LECHE EVAPORADA ENTERA X 400G X 24\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',5.0000,NULL,NULL),(233,43,4098,'{\"description\":\"VINAGRE BLANCO X 5 LT\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.0000,NULL,NULL),(234,43,1967,'{\"description\":\"SIBARITA BGRDE\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1967\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',9.0000,NULL,NULL),(235,43,1357,'{\"description\":\"SAL MARINA x 1 KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1357\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',5.0000,NULL,NULL),(236,43,4106,'{\"description\":\"COMINO MOLIDO X 50G APROX\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',0.5000,NULL,NULL),(237,43,4097,'{\"description\":\"GLUTAMATO MONOSODICO X 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(238,43,4096,'{\"description\":\"ATUN EN FILETE EN ACEITE VEGETAL X 180G X 48U\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(239,43,1735,'{\"description\":\"AGUA DE MESA  X  20 LIT  MONTA\\u00d1A AZUL\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1735\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',8.0000,NULL,NULL),(240,43,4095,'{\"description\":\"CHOCOLATE CUZCO X 90 G\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(241,43,1880,'{\"description\":\"AZUCAR RUBIA X 1 KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1880\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',28.5000,NULL,NULL),(242,43,4094,'{\"description\":\"HARINA DE PLATANO X 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.5000,NULL,NULL),(243,43,2282,'{\"description\":\"CAFE INST, GURMET X 190G\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI2282\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',7.0000,NULL,NULL),(244,43,1873,'{\"description\":\"ARROZ NIR X 1 KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1873\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',41.0000,NULL,NULL),(245,43,3706,'{\"description\":\"CEBADA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3706\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.5000,NULL,NULL),(246,43,639,'{\"description\":\"FIDEO NICOLINI CABELLO DE ANGEL x 250 GR\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI639\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(247,43,723,'{\"description\":\"FIDEO NICOLINI X 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI723\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',7.5000,NULL,NULL),(248,43,3701,'{\"description\":\"ACEITE FRIOL x 5L\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3701\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',5.0000,NULL,NULL),(249,44,4095,'{\"description\":\"CHOCOLATE CUZCO X 90 G\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(250,44,639,'{\"description\":\"FIDEO NICOLINI CABELLO DE ANGEL x 250 GR\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI639\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',40.0000,NULL,NULL),(251,44,723,'{\"description\":\"FIDEO NICOLINI X 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI723\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',31.5000,NULL,NULL),(252,44,3787,'{\"description\":\"MANZANILLA FILTRANTE MCCOLINS X 100U\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3787\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(253,44,4103,'{\"description\":\"ANIS FILTRANTE X 100U\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(254,44,3744,'{\"description\":\"PALLAR x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3744\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',22.0000,NULL,NULL),(255,44,4102,'{\"description\":\"LENTEJA X 1K\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',7.0000,NULL,NULL),(256,44,3743,'{\"description\":\"HABA ENTERA SECA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3743\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',8.0000,NULL,NULL),(257,44,3742,'{\"description\":\"ARVERJA VERDE SECA ENTERA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3742\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',9.0000,NULL,NULL),(258,44,1350,'{\"description\":\"AJINO SILLAO  X 500ML\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1350\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',7.0000,NULL,NULL),(259,44,1421,'{\"description\":\"GELATINA KOKY x 180 GR\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1421\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(260,44,3832,'{\"description\":\"CAJA GALLETA VAINILLA DIA X 40U X 26G APROX\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3832\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',4.0000,NULL,NULL),(261,44,4100,'{\"description\":\"GALLETA SODA X 240G\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',8.0000,NULL,NULL),(262,44,4098,'{\"description\":\"VINAGRE BLANCO X 5 LT\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(263,44,3707,'{\"description\":\"PIMIENTA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3707\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(264,44,4106,'{\"description\":\"COMINO MOLIDO X 50G APROX\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(265,44,4097,'{\"description\":\"GLUTAMATO MONOSODICO X 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.0000,NULL,NULL),(266,44,2245,'{\"description\":\"JUGOS DURAZNO PUL X 1LT\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI2245\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',5.0000,NULL,NULL),(267,44,4094,'{\"description\":\"HARINA DE PLATANO X 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.5000,NULL,NULL),(268,44,2410,'{\"description\":\"CAFE DESCAFEINADO X 180G\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI2410\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(269,44,1873,'{\"description\":\"ARROZ NIR X 1 KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1873\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',229.8800,NULL,NULL),(270,44,3706,'{\"description\":\"CEBADA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3706\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',59.0000,NULL,NULL),(271,44,2982,'{\"description\":\"QUAKER AVENA CON QUINUA X 360G\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI2982\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',5.0000,NULL,NULL),(272,45,3719,'{\"description\":\"PAPA CANCHAN BLANCA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3719\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',53.0000,NULL,NULL),(273,45,3779,'{\"description\":\"NABO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3779\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',0.8600,NULL,NULL),(274,45,3332,'{\"description\":\"CAMOTE X 1K\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3332\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',58.0000,NULL,NULL),(275,45,3777,'{\"description\":\"AJO ENTERO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3777\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.0000,NULL,NULL),(276,45,3773,'{\"description\":\"COLIFLOR x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3773\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.5000,NULL,NULL),(277,45,3770,'{\"description\":\"CAIGUA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3770\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',0.1300,NULL,NULL),(278,45,3769,'{\"description\":\"ESPINACA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3769\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.2500,NULL,NULL),(279,45,3767,'{\"description\":\"PAN FRANCES\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3767\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2195.0000,NULL,NULL),(280,45,3766,'{\"description\":\"PAN DE MOLDE FUENTE\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3766\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',56.0000,NULL,NULL),(281,45,1074,'{\"description\":\"YOGURT FRESA X 1 LT\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1074\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',12.0000,NULL,NULL),(282,45,3765,'{\"description\":\"MANTEQUILLA A GRANEL x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3765\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',9.5000,NULL,NULL),(283,45,3764,'{\"description\":\"ACEITUNA NEGRA A GRANEL x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3764\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',15.0000,NULL,NULL),(284,45,3763,'{\"description\":\"PALTA FUERTE\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3763\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',31.1800,NULL,NULL),(285,45,3762,'{\"description\":\"NARANJA VALENCIA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3762\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',76.2700,NULL,NULL),(286,45,3761,'{\"description\":\"MANDARINA SATSUMA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3761\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',45.0000,NULL,NULL),(287,45,3760,'{\"description\":\"PAPAYA CATEGORIA EXTRA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3760\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',66.9200,NULL,NULL),(288,45,3759,'{\"description\":\"MANZANA WINTER\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3759\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',32.0000,NULL,NULL),(289,45,3758,'{\"description\":\"PLATANO MADURO\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3758\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',247.0000,NULL,NULL),(290,45,3757,'{\"description\":\"PLATANO DE SEDA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3757\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',301.0000,NULL,NULL),(291,45,3756,'{\"description\":\"PLATANO VERDE\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3756\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',202.0000,NULL,NULL),(292,45,3716,'{\"description\":\"LIMON DULCE\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3716\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',43.6700,NULL,NULL),(293,45,3782,'{\"description\":\"COCONA x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3782\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',6.5000,NULL,NULL),(294,45,3754,'{\"description\":\"MARACUYA x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3754\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',10.0000,NULL,NULL),(295,45,3458,'{\"description\":\"HOT DOG RAZZETO\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3458\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',4.0000,NULL,NULL),(296,45,3752,'{\"description\":\"PESCADO JUREL AL PESO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3752\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',41.2000,NULL,NULL),(297,45,3751,'{\"description\":\"PESCADO BONITO AL PESO x 1 KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3751\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',23.9300,NULL,NULL),(298,45,3750,'{\"description\":\"CARNE DE RES LOMO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3750\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',4.5000,NULL,NULL),(299,45,3749,'{\"description\":\"CARNE DE RES CON HUESO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3749\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',24.0000,NULL,NULL),(300,45,3748,'{\"description\":\"HIGADO DE POLLO x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3748\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',40.3000,NULL,NULL),(301,45,3747,'{\"description\":\"CARNE DE GUISO DE PECHUGA DE PAVITA x 1KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3747\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',0.7600,NULL,NULL),(302,45,3746,'{\"description\":\"HARINA DE SIETE SEMILLAS x 1 KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3746\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.5000,NULL,NULL),(303,45,3338,'{\"description\":\"YUCA X 1 K\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3338\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',138.0000,NULL,NULL),(304,45,3337,'{\"description\":\"POLLO X 1K\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3337\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.2900,NULL,NULL),(305,45,4093,'{\"description\":\"CARNE DE SAJINO SECA\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"KGM\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.7549,NULL,NULL),(306,46,1128,'{\"description\":\"TAPER TOPLINE  CON SALIDA DE VAPOR N\\u00b01 X 1\\/2KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1128\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',7.0000,NULL,NULL),(307,47,1128,'{\"description\":\"TAPER TOPLINE  CON SALIDA DE VAPOR N\\u00b01 X 1\\/2KG\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1128\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',7.0000,NULL,NULL),(308,48,4108,'{\"description\":\"ENVASE DE PLASTICO CPN  TAPA TIPO TAPER 930 ML APROX\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',7.0000,NULL,NULL),(309,49,825,'{\"description\":\"SPORADE  X 500 ML\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI825\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',54.0000,NULL,NULL),(310,50,3293,'{\"description\":\"DETERGENTE ARIEL PRO CUIDADO x 780 GR\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3293\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',16.0000,NULL,NULL),(311,50,4109,'{\"description\":\"ARIEL DOBLE PODER LIQUIDO x 1.8L\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(312,51,4109,'{\"description\":\"ARIEL DOBLE PODER LIQUIDO x 1.8L\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1.0000,NULL,NULL),(313,52,1896,'{\"description\":\"AGUA MINERAL SAN CARLOS X 625ML APROX\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1896\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',810.0000,NULL,NULL),(314,52,825,'{\"description\":\"SPORADE  X 500 ML\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI825\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',400.0000,NULL,NULL),(315,52,510,'{\"description\":\"GALLETA SODA GN X 26G\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI510\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',200.0000,NULL,NULL),(316,52,1064,'{\"description\":\"JUGO GLORIA X 1 LT\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1064\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',51.0000,NULL,NULL),(317,53,1896,'{\"description\":\"AGUA MINERAL SAN CARLOS X 625ML APROX\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1896\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',10.0000,NULL,NULL),(318,54,1977,'{\"description\":\"FOCO DIFESA  3W\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1977\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',10.0000,NULL,NULL),(319,54,3373,'{\"description\":\"FOCO ESPIRAL PHELIX X 18\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI3373\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',6.0000,NULL,NULL),(320,55,4121,'{\"description\":\"LUMINARIA CON FOCO AHORRADOR 15W\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',10.0000,NULL,NULL),(321,55,4122,'{\"description\":\"SOCKET PARA FOCO 25 A 12V\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":null,\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',6.0000,NULL,NULL),(322,56,1116,'{\"description\":\"AGUA SAN CARLOS x 625 ML\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1116\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',10.0000,NULL,NULL),(323,57,1219,'{\"description\":\"AGUA DE MESA CON GAS x 625 ML  - SAN CARLOS\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1219\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',50.0000,NULL,NULL),(324,57,825,'{\"description\":\"SPORADE  X 500 ML\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI825\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',50.0000,NULL,NULL),(325,57,1770,'{\"description\":\"GALLETA RELLENITA  x 36 GR\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1770\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',50.0000,NULL,NULL),(326,58,1896,'{\"description\":\"AGUA MINERAL SAN CARLOS X 625ML APROX\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1896\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',50.0000,NULL,NULL),(327,58,825,'{\"description\":\"SPORADE  X 500 ML\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI825\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',50.0000,NULL,NULL),(328,58,1770,'{\"description\":\"GALLETA RELLENITA  x 36 GR\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1770\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',50.0000,NULL,NULL),(329,59,1735,'{\"description\":\"AGUA DE MESA  X  20 LIT  MONTA\\u00d1A AZUL\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1735\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.0000,NULL,NULL),(330,60,1219,'{\"description\":\"AGUA DE MESA CON GAS x 625 ML  - SAN CARLOS\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1219\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',1600.0000,NULL,NULL),(331,61,1735,'{\"description\":\"AGUA DE MESA  X  20 LIT  MONTA\\u00d1A AZUL\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1735\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',2.0000,NULL,NULL),(332,62,2340,'{\"description\":\"SPORADE X 12U X 500ML\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI2340\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',6.0000,NULL,NULL),(333,62,1735,'{\"description\":\"AGUA DE MESA  X  20 LIT  MONTA\\u00d1A AZUL\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1735\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',5.0000,NULL,NULL),(334,63,1735,'{\"description\":\"AGUA DE MESA  X  20 LIT  MONTA\\u00d1A AZUL\",\"model\":null,\"item_type_id\":\"01\",\"internal_id\":\"BI1735\",\"item_code\":null,\"item_code_gs1\":null,\"unit_type_id\":\"NIU\",\"IdLoteSelected\":null,\"lot_group\":null,\"date_of_due\":null}',5.0000,NULL,NULL);

--
-- Table structure for table `dispatch_sale_notes`
--

CREATE TABLE `dispatch_sale_notes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sale_note_id` int(10) unsigned NOT NULL,
  `date_dispatch` date DEFAULT NULL,
  `time_dispatch` time DEFAULT NULL,
  `person_pick` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `person_dispatch` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dispatch_sale_notes_sale_note_id_foreign` (`sale_note_id`),
  CONSTRAINT `dispatch_sale_notes_sale_note_id_foreign` FOREIGN KEY (`sale_note_id`) REFERENCES `sale_notes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dispatch_sale_notes`
--


--
-- Table structure for table `dispatchers`
--

CREATE TABLE `dispatchers` (
  `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,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number_mtc` varchar(12) 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 `dispatchers_identity_document_type_id_foreign` (`identity_document_type_id`),
  KEY `dispatchers_number_index` (`number`),
  KEY `dispatchers_name_index` (`name`),
  CONSTRAINT `dispatchers_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 `dispatchers`
--

INSERT INTO `dispatchers` VALUES (1,'6','20392262432','NEGOCIOS OLTI EMP.IND.DE RESP.LTADA','AV. MARIANO MELGAR NRO. 519','0',0,1,'2022-12-18 16:54:12','2022-12-18 16:54:12');

--
-- Table structure for table `dispatches`
--

CREATE TABLE `dispatches` (
  `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,
  `establishment` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`establishment`)),
  `soap_type_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state_type_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ubl_version` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `document_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_sale_note_id` int(10) unsigned DEFAULT NULL,
  `reference_document_id` int(10) unsigned DEFAULT NULL,
  `reference_quotation_id` int(10) unsigned DEFAULT NULL,
  `reference_order_form_id` int(10) unsigned DEFAULT NULL,
  `reference_order_note_id` int(10) unsigned DEFAULT NULL,
  `series` char(4) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` int(11) NOT NULL,
  `date_of_issue` date NOT NULL,
  `time_of_issue` time NOT NULL,
  `customer_id` int(10) unsigned DEFAULT NULL,
  `customer` longtext CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '(DC2Type:json)',
  `observations` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transport_mode_type_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transfer_reason_type_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transfer_reason_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_of_shipping` date NOT NULL,
  `transshipment_indicator` tinyint(1) NOT NULL,
  `port_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unit_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_weight` decimal(10,2) NOT NULL,
  `packages_number` int(11) DEFAULT NULL,
  `container_number` int(11) DEFAULT NULL,
  `related` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Numero de DAM' CHECK (json_valid(`related`)),
  `origin` longtext CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '(DC2Type:json)',
  `delivery` longtext CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '(DC2Type:json)',
  `dispatcher_id` int(10) unsigned DEFAULT NULL,
  `dispatcher` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`dispatcher`)),
  `driver_id` int(10) unsigned DEFAULT NULL,
  `driver` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`driver`)),
  `order_form_external` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_plate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sender_id` int(10) unsigned DEFAULT NULL,
  `sender_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`sender_data`)),
  `sender_address_id` int(10) unsigned DEFAULT NULL,
  `sender_address_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`sender_address_data`)),
  `receiver_id` int(10) unsigned DEFAULT NULL,
  `receiver_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`receiver_data`)),
  `receiver_address_id` int(10) unsigned DEFAULT NULL,
  `receiver_address_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`receiver_address_data`)),
  `transport_id` int(10) unsigned DEFAULT NULL,
  `transport_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`transport_data`)),
  `secondary_license_plates` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`secondary_license_plates`)),
  `legends` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`legends`)),
  `optional` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`optional`)),
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `soap_shipping_response` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`soap_shipping_response`)),
  `send_to_pse` tinyint(1) NOT NULL DEFAULT 0,
  `response_signature_pse` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`response_signature_pse`)),
  `response_send_cdr_pse` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`response_send_cdr_pse`)),
  `has_xml` tinyint(1) NOT NULL DEFAULT 0,
  `has_pdf` tinyint(1) NOT NULL DEFAULT 0,
  `has_cdr` tinyint(1) NOT NULL DEFAULT 0,
  `document_id` int(10) unsigned DEFAULT NULL,
  `ticket` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reception_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qr_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `data_affected_document` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `terms_condition` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `additional_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`additional_data`)),
  `origin_address_id` int(10) unsigned DEFAULT NULL,
  `delivery_address_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dispatches_user_id_foreign` (`user_id`),
  KEY `dispatches_establishment_id_foreign` (`establishment_id`),
  KEY `dispatches_soap_type_id_foreign` (`soap_type_id`),
  KEY `dispatches_state_type_id_foreign` (`state_type_id`),
  KEY `dispatches_document_type_id_foreign` (`document_type_id`),
  KEY `dispatches_customer_id_foreign` (`customer_id`),
  KEY `dispatches_unit_type_id_foreign` (`unit_type_id`),
  KEY `dispatches_transport_mode_type_id_foreign` (`transport_mode_type_id`),
  KEY `dispatches_transfer_reason_type_id_foreign` (`transfer_reason_type_id`),
  KEY `dispatches_document_id_foreign` (`document_id`),
  KEY `dispatches_dispatcher_id_foreign` (`dispatcher_id`),
  KEY `dispatches_driver_id_foreign` (`driver_id`),
  KEY `dispatches_transport_id_foreign` (`transport_id`),
  KEY `dispatches_sender_id_foreign` (`sender_id`),
  KEY `dispatches_sender_address_id_foreign` (`sender_address_id`),
  KEY `dispatches_receiver_id_foreign` (`receiver_id`),
  KEY `dispatches_receiver_address_id_foreign` (`receiver_address_id`),
  CONSTRAINT `dispatches_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `dispatches_dispatcher_id_foreign` FOREIGN KEY (`dispatcher_id`) REFERENCES `dispatchers` (`id`),
  CONSTRAINT `dispatches_document_id_foreign` FOREIGN KEY (`document_id`) REFERENCES `documents` (`id`) ON DELETE CASCADE,
  CONSTRAINT `dispatches_document_type_id_foreign` FOREIGN KEY (`document_type_id`) REFERENCES `cat_document_types` (`id`),
  CONSTRAINT `dispatches_driver_id_foreign` FOREIGN KEY (`driver_id`) REFERENCES `drivers` (`id`),
  CONSTRAINT `dispatches_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`),
  CONSTRAINT `dispatches_receiver_address_id_foreign` FOREIGN KEY (`receiver_address_id`) REFERENCES `dispatch_addresses` (`id`),
  CONSTRAINT `dispatches_receiver_id_foreign` FOREIGN KEY (`receiver_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `dispatches_sender_address_id_foreign` FOREIGN KEY (`sender_address_id`) REFERENCES `dispatch_addresses` (`id`),
  CONSTRAINT `dispatches_sender_id_foreign` FOREIGN KEY (`sender_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `dispatches_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `dispatches_state_type_id_foreign` FOREIGN KEY (`state_type_id`) REFERENCES `state_types` (`id`),
  CONSTRAINT `dispatches_transfer_reason_type_id_foreign` FOREIGN KEY (`transfer_reason_type_id`) REFERENCES `cat_transfer_reason_types` (`id`),
  CONSTRAINT `dispatches_transport_id_foreign` FOREIGN KEY (`transport_id`) REFERENCES `transports` (`id`),
  CONSTRAINT `dispatches_transport_mode_type_id_foreign` FOREIGN KEY (`transport_mode_type_id`) REFERENCES `cat_transport_mode_types` (`id`),
  CONSTRAINT `dispatches_unit_type_id_foreign` FOREIGN KEY (`unit_type_id`) REFERENCES `cat_unit_types` (`id`),
  CONSTRAINT `dispatches_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
