CREATE TABLE `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`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `modules`
--

INSERT INTO `modules` VALUES (1,'documents','Ventas',2,NULL,NULL),(2,'purchases','Compras',7,NULL,NULL),(3,'advanced','Documentos Avanzados',8,NULL,NULL),(4,'reports','Reportes',9,NULL,NULL),(5,'configuration','Configuration',12,NULL,NULL),(6,'pos','Punto de venta (POS)',3,NULL,NULL),(7,'dashboard','Dashboard',1,NULL,NULL),(8,'inventory','Inventario',7,NULL,NULL),(9,'accounting','Contabilidad',10,NULL,NULL),(10,'ecommerce','Ecommerce',4,NULL,NULL),(11,'cuenta','Cuenta',13,NULL,NULL),(12,'finance','Finanzas',11,NULL,NULL),(14,'establishments','Usuarios/Locales & Series',7,NULL,NULL),(15,'hotels','Hoteles',14,NULL,NULL),(16,'documentary-procedure','Trámite documentario',15,NULL,NULL),(17,'items','Productos/Servicios',5,NULL,NULL),(18,'persons','Clientes',6,NULL,NULL),(19,'digemid','Farmacia',15,'2022-03-17 16:56:04','2022-03-17 16:56:04'),(20,'apps','Apps',13,NULL,NULL),(21,'suscription_app','Suscriptiones',16,NULL,NULL),(22,'production_app','Producción',17,NULL,NULL),(23,'restaurant_app','Restaurante',18,NULL,NULL),(24,'full_suscription_app','Suscripción Servicios SAAS',17,NULL,NULL),(25,'generate_link_app','Generador de link de pago',19,NULL,NULL),(26,'app_2_generator','Generador APP 2.0',20,NULL,NULL);

--
-- Table structure for table `notes`
--

CREATE TABLE `notes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `document_id` int(10) unsigned NOT NULL,
  `note_type` enum('credit','debit') COLLATE utf8mb4_unicode_ci NOT NULL,
  `note_credit_type_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note_debit_type_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note_description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `affected_document_id` int(10) unsigned DEFAULT NULL,
  `data_affected_document` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`data_affected_document`)),
  PRIMARY KEY (`id`),
  KEY `notes_document_id_foreign` (`document_id`),
  KEY `notes_note_credit_type_id_foreign` (`note_credit_type_id`),
  KEY `notes_note_debit_type_id_foreign` (`note_debit_type_id`),
  KEY `notes_affected_document_id_foreign` (`affected_document_id`),
  CONSTRAINT `notes_affected_document_id_foreign` FOREIGN KEY (`affected_document_id`) REFERENCES `documents` (`id`),
  CONSTRAINT `notes_document_id_foreign` FOREIGN KEY (`document_id`) REFERENCES `documents` (`id`) ON DELETE CASCADE,
  CONSTRAINT `notes_note_credit_type_id_foreign` FOREIGN KEY (`note_credit_type_id`) REFERENCES `cat_note_credit_types` (`id`),
  CONSTRAINT `notes_note_debit_type_id_foreign` FOREIGN KEY (`note_debit_type_id`) REFERENCES `cat_note_debit_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notes`
--


--
-- Table structure for table `offline_configurations`
--

CREATE TABLE `offline_configurations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `is_client` tinyint(1) NOT NULL DEFAULT 0,
  `token_server` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url_server` 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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `offline_configurations`
--

INSERT INTO `offline_configurations` VALUES (1,0,NULL,NULL,NULL,NULL);

--
-- Table structure for table `order_form_items`
--

CREATE TABLE `order_form_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_form_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 `order_form_items_order_form_id_foreign` (`order_form_id`),
  KEY `order_form_items_item_id_foreign` (`item_id`),
  CONSTRAINT `order_form_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`),
  CONSTRAINT `order_form_items_order_form_id_foreign` FOREIGN KEY (`order_form_id`) REFERENCES `order_forms` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_form_items`
--


--
-- Table structure for table `order_forms`
--

CREATE TABLE `order_forms` (
  `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,
  `prefix` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_of_issue` date NOT NULL,
  `time_of_issue` time NOT NULL,
  `customer_id` int(10) unsigned NOT NULL,
  `customer` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`customer`)),
  `observations` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `transport_mode_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transfer_reason_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transfer_reason_description` varchar(255) COLLATE utf8mb4_unicode_ci NOT 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) NOT NULL,
  `container_number` int(11) DEFAULT NULL,
  `origin` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`origin`)),
  `delivery` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`delivery`)),
  `dispatcher_id` int(10) unsigned NOT NULL,
  `driver_id` int(10) unsigned NOT NULL,
  `license_plates` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`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,
  `qr` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_forms_dispatcher_id_foreign` (`dispatcher_id`),
  KEY `order_forms_driver_id_foreign` (`driver_id`),
  KEY `order_forms_user_id_foreign` (`user_id`),
  KEY `order_forms_establishment_id_foreign` (`establishment_id`),
  KEY `order_forms_soap_type_id_foreign` (`soap_type_id`),
  KEY `order_forms_state_type_id_foreign` (`state_type_id`),
  KEY `order_forms_customer_id_foreign` (`customer_id`),
  KEY `order_forms_unit_type_id_foreign` (`unit_type_id`),
  KEY `order_forms_transport_mode_type_id_foreign` (`transport_mode_type_id`),
  KEY `order_forms_transfer_reason_type_id_foreign` (`transfer_reason_type_id`),
  KEY `order_forms_date_of_issue_index` (`date_of_issue`),
  CONSTRAINT `order_forms_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `order_forms_dispatcher_id_foreign` FOREIGN KEY (`dispatcher_id`) REFERENCES `dispatchers` (`id`),
  CONSTRAINT `order_forms_driver_id_foreign` FOREIGN KEY (`driver_id`) REFERENCES `drivers` (`id`),
  CONSTRAINT `order_forms_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`),
  CONSTRAINT `order_forms_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `order_forms_state_type_id_foreign` FOREIGN KEY (`state_type_id`) REFERENCES `state_types` (`id`),
  CONSTRAINT `order_forms_transfer_reason_type_id_foreign` FOREIGN KEY (`transfer_reason_type_id`) REFERENCES `cat_transfer_reason_types` (`id`),
  CONSTRAINT `order_forms_transport_mode_type_id_foreign` FOREIGN KEY (`transport_mode_type_id`) REFERENCES `cat_transport_mode_types` (`id`),
  CONSTRAINT `order_forms_unit_type_id_foreign` FOREIGN KEY (`unit_type_id`) REFERENCES `cat_unit_types` (`id`),
  CONSTRAINT `order_forms_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_forms`
--


--
-- Table structure for table `order_note_items`
--

CREATE TABLE `order_note_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_note_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_plastic_bag_taxes` decimal(6,2) DEFAULT 0.00 COMMENT 'Impuesto bolsa plastica',
  `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`)),
  `additional_information` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Informacion adcional',
  `warehouse_id` int(10) unsigned DEFAULT NULL,
  `name_product_pdf` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Nombre del producto para el pdf',
  PRIMARY KEY (`id`),
  KEY `order_note_items_order_note_id_foreign` (`order_note_id`),
  KEY `order_note_items_item_id_foreign` (`item_id`),
  KEY `order_note_items_affectation_igv_type_id_foreign` (`affectation_igv_type_id`),
  KEY `order_note_items_system_isc_type_id_foreign` (`system_isc_type_id`),
  KEY `order_note_items_price_type_id_foreign` (`price_type_id`),
  KEY `order_note_items_warehouse_id_foreign` (`warehouse_id`),
  CONSTRAINT `order_note_items_affectation_igv_type_id_foreign` FOREIGN KEY (`affectation_igv_type_id`) REFERENCES `cat_affectation_igv_types` (`id`),
  CONSTRAINT `order_note_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`),
  CONSTRAINT `order_note_items_order_note_id_foreign` FOREIGN KEY (`order_note_id`) REFERENCES `order_notes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_note_items_price_type_id_foreign` FOREIGN KEY (`price_type_id`) REFERENCES `cat_price_types` (`id`),
  CONSTRAINT `order_note_items_system_isc_type_id_foreign` FOREIGN KEY (`system_isc_type_id`) REFERENCES `cat_system_isc_types` (`id`),
  CONSTRAINT `order_note_items_warehouse_id_foreign` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_note_items`
--


--
-- Table structure for table `order_notes`
--

CREATE TABLE `order_notes` (
  `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,
  `prefix` char(3) 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,
  `currency_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_method_type_id` char(2) COLLATE utf8mb4_unicode_ci DEFAULT 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_igv_free` 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`)),
  `additional_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`additional_data`)),
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `observation` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `quotation_id` int(10) unsigned DEFAULT 0 COMMENT 'Relacion con cotizaciones',
  PRIMARY KEY (`id`),
  KEY `order_notes_user_id_foreign` (`user_id`),
  KEY `order_notes_establishment_id_foreign` (`establishment_id`),
  KEY `order_notes_customer_id_foreign` (`customer_id`),
  KEY `order_notes_soap_type_id_foreign` (`soap_type_id`),
  KEY `order_notes_state_type_id_foreign` (`state_type_id`),
  KEY `order_notes_currency_type_id_foreign` (`currency_type_id`),
  KEY `order_notes_payment_method_type_id_foreign` (`payment_method_type_id`),
  CONSTRAINT `order_notes_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`),
  CONSTRAINT `order_notes_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `order_notes_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`),
  CONSTRAINT `order_notes_payment_method_type_id_foreign` FOREIGN KEY (`payment_method_type_id`) REFERENCES `payment_method_types` (`id`),
  CONSTRAINT `order_notes_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `order_notes_state_type_id_foreign` FOREIGN KEY (`state_type_id`) REFERENCES `state_types` (`id`),
  CONSTRAINT `order_notes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_notes`
--


--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `external_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`customer`)),
  `shipping_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `items` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`items`)),
  `total` decimal(12,2) NOT NULL,
  `reference_payment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `document_external_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_document` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_order_id` tinyint(3) unsigned DEFAULT NULL,
  `purchase` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`purchase`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `apply_restaurant` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `orders_status_order_id_foreign` (`status_order_id`),
  CONSTRAINT `orders_status_order_id_foreign` FOREIGN KEY (`status_order_id`) REFERENCES `status_orders` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders`
--


--
-- Table structure for table `origin_addresses`
--

CREATE TABLE `origin_addresses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `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_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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `origin_addresses`
--


--
-- Table structure for table `packaging`
--

CREATE TABLE `packaging` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `item_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `soap_type_id` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_extra_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`item_extra_data`)),
  `establishment_id` int(10) unsigned DEFAULT NULL,
  `quantity` decimal(8,2) DEFAULT 0.00,
  `number_packages` decimal(8,2) DEFAULT 0.00,
  `item` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`item`)),
  `observation` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lot_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_start` date DEFAULT NULL,
  `time_start` time DEFAULT NULL,
  `date_end` date DEFAULT NULL,
  `time_end` time DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `packaging_collaborator` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `packaging_soap_type_id_foreign` (`soap_type_id`),
  CONSTRAINT `packaging_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `packaging`
--


--
-- Table structure for table `padrones`
--

CREATE TABLE `padrones` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ruc` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombre_razon_social` varchar(155) COLLATE utf8mb4_unicode_ci NOT NULL,
  `estado_contribuyente` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `condicion_domicilio` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ubigeo` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tipo_via` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombre_via` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `codigo_zona` varchar(155) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tipo_zona` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `numero` varchar(155) COLLATE utf8mb4_unicode_ci NOT NULL,
  `interior` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lote` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `departamento` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `manzana` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kilometro` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `padrones_ruc_index` (`ruc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `padrones`
--


--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--


--
-- Table structure for table `payment_conditions`
--

CREATE TABLE `payment_conditions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `days` int(11) NOT NULL DEFAULT 0,
  `is_locked` tinyint(1) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  KEY `payment_conditions_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_conditions`
--

INSERT INTO `payment_conditions` VALUES ('01','Contado',0,1,1),('02','Crédito',0,1,1);

--
-- Table structure for table `payment_configurations`
--

CREATE TABLE `payment_configurations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `enabled_yape` tinyint(1) NOT NULL,
  `qrcode_yape` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_yape` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telephone_yape` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enabled_mp` tinyint(1) NOT NULL DEFAULT 0,
  `access_token_mp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `public_key_mp` 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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_configurations`
--

INSERT INTO `payment_configurations` VALUES (1,0,NULL,NULL,NULL,0,NULL,NULL,'2022-07-03 22:01:52','2022-07-03 22:01:52');

--
-- Table structure for table `payment_files`
--

CREATE TABLE `payment_files` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_id` int(11) NOT NULL,
  `payment_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `payment_index` (`payment_id`,`payment_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_files`
--


--
-- Table structure for table `payment_link_types`
--

CREATE TABLE `payment_link_types` (
  `id` char(2) 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 `payment_link_types`
--

INSERT INTO `payment_link_types` VALUES ('01','Yape'),('02','Mercado Pago');

--
-- Table structure for table `payment_links`
--

CREATE TABLE `payment_links` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `soap_type_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `payment_link_type_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_id` int(11) DEFAULT NULL,
  `payment_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total` decimal(12,2) NOT NULL,
  `uploaded_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `query_transaction` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `payment_links_uuid_unique` (`uuid`),
  KEY `payment_index` (`payment_id`,`payment_type`),
  KEY `payment_links_user_id_foreign` (`user_id`),
  KEY `payment_links_soap_type_id_foreign` (`soap_type_id`),
  KEY `payment_links_payment_link_type_id_foreign` (`payment_link_type_id`),
  CONSTRAINT `payment_links_payment_link_type_id_foreign` FOREIGN KEY (`payment_link_type_id`) REFERENCES `payment_link_types` (`id`),
  CONSTRAINT `payment_links_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `payment_links_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_links`
--


--
-- Table structure for table `payment_method_types`
--

CREATE TABLE `payment_method_types` (
  `id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `has_card` tinyint(1) NOT NULL DEFAULT 0,
  `charge` decimal(12,2) DEFAULT NULL,
  `number_days` int(11) DEFAULT NULL,
  `is_credit` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Define si es tipo credito',
  `is_cash` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Define si es es efectivo',
  KEY `payment_method_types_id_index` (`id`),
  KEY `payment_method_types_is_credit_index` (`is_credit`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_method_types`
--

INSERT INTO `payment_method_types` VALUES ('01','Efectivo',0,NULL,NULL,0,1),('02','Tarjeta de crédito',1,NULL,NULL,0,0),('03','Tarjeta de débito',1,NULL,NULL,0,0),('04','Transferencia',0,NULL,NULL,0,0),('05','Factura a 30 días',0,NULL,30,1,0),('06','Tarjeta crédito visa',1,3.68,NULL,0,0),('07','Contado contraentrega',0,NULL,NULL,0,0),('08','A 30 días',0,NULL,30,1,0),('09','Crédito',1,NULL,NULL,1,0),('10','Contado',0,NULL,NULL,0,1);

--
-- Table structure for table `perception_documents`
--

CREATE TABLE `perception_documents` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `perception_id` int(10) unsigned NOT NULL,
  `document_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_of_issue` date NOT NULL,
  `date_of_perception` date NOT NULL,
  `currency_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_document` decimal(10,2) NOT NULL,
  `total_perception` decimal(10,2) NOT NULL,
  `payments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`payments`)),
  `series` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `exchange_rate` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`exchange_rate`)),
  `total_to_pay` decimal(10,2) NOT NULL,
  `total_payment` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `perception_details_perception_id_foreign` (`perception_id`),
  KEY `perception_documents_document_type_id_foreign` (`document_type_id`),
  KEY `perception_documents_currency_type_id_foreign` (`currency_type_id`),
  CONSTRAINT `perception_details_perception_id_foreign` FOREIGN KEY (`perception_id`) REFERENCES `perceptions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `perception_documents_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`),
  CONSTRAINT `perception_documents_document_type_id_foreign` FOREIGN KEY (`document_type_id`) REFERENCES `cat_document_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `perception_documents`
--


--
-- Table structure for table `perceptions`
--

CREATE TABLE `perceptions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `establishment_id` int(10) unsigned NOT NULL,
  `establishment` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`establishment`)),
  `external_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `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,
  `series` char(4) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` int(11) NOT NULL,
  `date_of_issue` date NOT NULL,
  `customer_id` int(10) unsigned NOT NULL,
  `customer` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`customer`)),
  `currency_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `perception_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `observations` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_perception` decimal(10,2) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `optional` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`optional`)),
  `legends` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`legends`)),
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `time_of_issue` time NOT NULL,
  `hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `has_xml` tinyint(1) NOT NULL DEFAULT 0,
  `has_pdf` tinyint(1) NOT NULL DEFAULT 0,
  `has_cdr` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `perceptions_user_id_foreign` (`user_id`),
  KEY `perceptions_establishment_id_foreign` (`establishment_id`),
  KEY `perceptions_soap_type_id_foreign` (`soap_type_id`),
  KEY `perceptions_state_type_id_foreign` (`state_type_id`),
  KEY `perceptions_document_type_id_foreign` (`document_type_id`),
  KEY `perceptions_currency_type_id_foreign` (`currency_type_id`),
  KEY `perceptions_perception_type_id_foreign` (`perception_type_id`),
  KEY `perceptions_customer_id_foreign` (`customer_id`),
  KEY `perceptions_number_index` (`number`),
  KEY `perceptions_series_index` (`series`),
  CONSTRAINT `perceptions_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`),
  CONSTRAINT `perceptions_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `perceptions_document_type_id_foreign` FOREIGN KEY (`document_type_id`) REFERENCES `cat_document_types` (`id`),
  CONSTRAINT `perceptions_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`),
  CONSTRAINT `perceptions_perception_type_id_foreign` FOREIGN KEY (`perception_type_id`) REFERENCES `cat_perception_types` (`id`),
  CONSTRAINT `perceptions_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `perceptions_state_type_id_foreign` FOREIGN KEY (`state_type_id`) REFERENCES `state_types` (`id`),
  CONSTRAINT `perceptions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `perceptions`
--


--
-- Table structure for table `person_address`
--

CREATE TABLE `person_address` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `person_id` int(10) unsigned NOT NULL,
  `department_id` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `province_id` char(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `district_id` char(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `person_address_person_id_foreign` (`person_id`),
  KEY `person_address_department_id_foreign` (`department_id`),
  KEY `person_address_province_id_foreign` (`province_id`),
  KEY `person_address_district_id_foreign` (`district_id`),
  CONSTRAINT `person_address_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  CONSTRAINT `person_address_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`),
  CONSTRAINT `person_address_person_id_foreign` FOREIGN KEY (`person_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `person_address_province_id_foreign` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `person_address`
--


--
-- Table structure for table `person_addresses`
--

CREATE TABLE `person_addresses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `person_id` int(10) unsigned NOT NULL,
  `country_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `department_id` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `province_id` char(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `district_id` char(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `person_addresses_person_id_foreign` (`person_id`),
  KEY `person_addresses_country_id_foreign` (`country_id`),
  KEY `person_addresses_department_id_foreign` (`department_id`),
  KEY `person_addresses_province_id_foreign` (`province_id`),
  KEY `person_addresses_district_id_foreign` (`district_id`),
  CONSTRAINT `person_addresses_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`),
  CONSTRAINT `person_addresses_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  CONSTRAINT `person_addresses_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`),
  CONSTRAINT `person_addresses_person_id_foreign` FOREIGN KEY (`person_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `person_addresses_province_id_foreign` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `person_addresses`
--

INSERT INTO `person_addresses` VALUES (1,158,'PE',NULL,NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `person_types`
--

CREATE TABLE `person_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `description` text 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=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `person_types`
--

INSERT INTO `person_types` VALUES (1,'Interno','2022-03-17 16:55:58','2022-03-17 16:55:58'),(2,'Distribuidor','2022-03-17 16:55:58','2022-03-17 16:55:58');

--
-- Table structure for table `persons`
--

CREATE TABLE `persons` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('customers','suppliers') COLLATE utf8mb4_unicode_ci NOT NULL,
  `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,
  `internal_code` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `barcode` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nationality_id` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `department_id` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `province_id` char(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `district_id` char(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_type_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `condition` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` 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,
  `accumulated_points` decimal(12,2) NOT NULL DEFAULT 0.00 COMMENT 'sistema por puntos',
  `perception_agent` tinyint(1) NOT NULL DEFAULT 0,
  `person_type_id` int(10) unsigned DEFAULT NULL,
  `contact` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`contact`)),
  `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `percentage_perception` decimal(12,2) DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `website` text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Sitio Web',
  `zone` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Zona',
  `observation` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Observaciones',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `credit_days` int(10) unsigned DEFAULT 0 COMMENT 'establece los dias de credito',
  `optional_email` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Conjunto de correos de envio',
  `parent_id` int(10) unsigned DEFAULT 0 COMMENT 'Se relaciona con si mismo, numero mayor a 0 es el id del padre.',
  `zone_id` int(10) unsigned DEFAULT NULL,
  `seller_id` int(10) unsigned DEFAULT NULL,
  `has_discount` tinyint(1) NOT NULL DEFAULT 0,
  `discount_type` char(2) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '01',
  `discount_amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  PRIMARY KEY (`id`),
  KEY `persons_identity_document_type_id_foreign` (`identity_document_type_id`),
  KEY `persons_country_id_foreign` (`country_id`),
  KEY `persons_department_id_foreign` (`department_id`),
  KEY `persons_province_id_foreign` (`province_id`),
  KEY `persons_district_id_foreign` (`district_id`),
  KEY `persons_name_index` (`name`),
  KEY `persons_number_index` (`number`),
  KEY `persons_type_index` (`type`),
  KEY `persons_person_type_id_foreign` (`person_type_id`),
  KEY `persons_enabled_index` (`enabled`),
  KEY `persons_address_type_id_foreign` (`address_type_id`),
  KEY `persons_seller_id_index` (`seller_id`),
  KEY `persons_nationality_id_foreign` (`nationality_id`),
  CONSTRAINT `persons_address_type_id_foreign` FOREIGN KEY (`address_type_id`) REFERENCES `cat_address_types` (`id`),
  CONSTRAINT `persons_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`),
  CONSTRAINT `persons_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  CONSTRAINT `persons_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`),
  CONSTRAINT `persons_identity_document_type_id_foreign` FOREIGN KEY (`identity_document_type_id`) REFERENCES `cat_identity_document_types` (`id`),
  CONSTRAINT `persons_nationality_id_foreign` FOREIGN KEY (`nationality_id`) REFERENCES `countries` (`id`),
  CONSTRAINT `persons_person_type_id_foreign` FOREIGN KEY (`person_type_id`) REFERENCES `person_types` (`id`),
  CONSTRAINT `persons_province_id_foreign` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=430 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `persons`
--

INSERT INTO `persons` VALUES (1,'customers','1','75478910','VEGA SALAZAR, JEAN CLAUDE',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-03-21 14:35:49','2022-03-21 14:35:49',1,0,NULL,0,NULL,NULL,0,'01',0.00),(2,'customers','1','70890220','REQUEJO QUIROZ, DIANA ROSMERY',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-03-21 14:40:34','2022-03-21 14:40:34',1,0,NULL,0,NULL,NULL,0,'01',0.00),(3,'customers','1','33588503','QUIROZ PEREZ, ROXANI MARGOTH',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-03-21 14:55:59','2022-03-21 14:55:59',1,0,NULL,0,NULL,NULL,0,'01',0.00),(4,'customers','1','71209592','REQUEJO QUIROZ, LUIS HERNAN',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-05 12:33:55','2022-04-05 12:33:55',1,0,NULL,0,NULL,NULL,0,'01',0.00),(5,'customers','1','33590637','REQUEJO VASQUEZ, HERNAN',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-05 12:44:26','2022-04-05 12:44:26',1,0,NULL,0,NULL,NULL,0,'01',0.00),(6,'customers','1','75210299','JACINTO LIZANA, KELY ROXANA',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-05 12:55:28','2022-04-05 12:55:28',1,0,NULL,0,NULL,NULL,0,'01',0.00),(7,'customers','1','77487343','LEO VENTURA, VICTOR ORLANDO',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-06 17:44:09','2022-04-06 17:44:09',1,0,NULL,0,NULL,NULL,0,'01',0.00),(8,'customers','1','72958497','CHUMACERO TAMAY, EBERTH ALEJANDRO',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-06 17:56:43','2022-04-06 17:56:43',1,0,NULL,0,NULL,NULL,0,'01',0.00),(9,'customers','1','27840433','SOTO VALENCIA, FRANCISCA ALTAGRACIA',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-06 18:04:24','2022-04-06 18:04:24',1,0,NULL,0,NULL,NULL,0,'01',0.00),(10,'customers','0','99999999','Clientes - Varios',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-06 18:53:15','2022-04-06 18:53:15',1,0,NULL,0,NULL,NULL,0,'01',0.00),(11,'customers','0','11111','cliente',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-07 18:38:14','2022-04-07 18:38:14',1,0,NULL,0,NULL,NULL,0,'01',0.00),(12,'customers','0','888888','Clientes - Varios1',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-07 18:42:25','2022-04-07 18:42:25',1,0,NULL,0,NULL,NULL,0,'01',0.00),(13,'customers','0','777777','Clientes - Varios2',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-07 18:43:40','2022-04-07 18:43:40',1,0,NULL,0,NULL,NULL,0,'01',0.00),(14,'customers','0','9999999','Clientes',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-07 20:22:38','2022-04-07 20:22:38',1,0,NULL,0,NULL,NULL,0,'01',0.00),(15,'customers','0','11111111','Cliente4',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-08 20:26:10','2022-04-08 20:26:10',1,0,NULL,0,NULL,NULL,0,'01',0.00),(16,'customers','0','222222222','Cliente5',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-08 20:28:52','2022-04-08 20:28:52',1,0,NULL,0,NULL,NULL,0,'01',0.00),(17,'customers','0','01','CLIENTE 01',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-08 20:48:23','2022-04-08 20:48:23',1,0,NULL,0,NULL,NULL,0,'01',0.00),(18,'customers','0','02','Cliente 02',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-09 14:44:38','2022-04-09 14:44:38',1,0,NULL,0,NULL,NULL,0,'01',0.00),(19,'customers','0','002','Clientes02',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-09 14:45:54','2022-04-09 14:45:54',1,0,NULL,0,NULL,NULL,0,'01',0.00),(20,'customers','0','003','Cliente03',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-09 14:48:12','2022-04-09 14:48:12',1,0,NULL,0,NULL,NULL,0,'01',0.00),(21,'customers','0','999999999','Cliente6',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-09 17:35:30','2022-04-09 17:35:30',1,0,NULL,0,NULL,NULL,0,'01',0.00),(22,'customers','0','99999998','Cliente7',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-09 17:36:10','2022-04-09 17:36:10',1,0,NULL,0,NULL,NULL,0,'01',0.00),(23,'customers','0','4444444','Clienta',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-09 17:38:37','2022-04-09 17:38:37',1,0,NULL,0,NULL,NULL,0,'01',0.00),(24,'customers','1','47209867','GONZALES QUINDE, MARBIS',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-10 12:12:10','2022-04-10 12:12:10',1,0,NULL,0,NULL,NULL,0,'01',0.00),(25,'customers','0','004','Cliente04',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-11 20:56:20','2022-04-11 20:56:20',1,0,NULL,0,NULL,NULL,0,'01',0.00),(26,'customers','0','05','Cliente05',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-11 20:58:31','2022-04-11 20:58:31',1,0,NULL,0,NULL,NULL,0,'01',0.00),(27,'customers','0','007','Cliente07',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-12 16:57:48','2022-04-12 16:57:48',1,0,NULL,0,NULL,NULL,0,'01',0.00),(28,'customers','0','008','CLIENTE 08',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-12 17:05:07','2022-04-12 17:05:07',1,0,NULL,0,NULL,NULL,0,'01',0.00),(29,'customers','0','005','Cliente 0004',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-16 18:41:18','2022-04-16 18:41:18',1,0,NULL,0,NULL,NULL,0,'01',0.00),(30,'customers','0','006','Cliente006',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-16 18:42:03','2022-04-16 18:42:03',1,0,NULL,0,NULL,NULL,0,'01',0.00),(31,'customers','0','5555555555','Cliente10',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-16 19:19:40','2022-04-16 19:19:40',1,0,NULL,0,NULL,NULL,0,'01',0.00),(32,'customers','0','3333333333333','Cliente11',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-16 19:20:38','2022-04-16 19:20:38',1,0,NULL,0,NULL,NULL,0,'01',0.00),(33,'customers','0','99999','Cliente13',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-17 13:36:42','2022-04-17 13:36:42',1,0,NULL,0,NULL,NULL,0,'01',0.00),(34,'customers','0','12121','Cliente14',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-17 13:38:21','2022-04-17 13:38:21',1,0,NULL,0,NULL,NULL,0,'01',0.00),(35,'customers','0','99','Cliente15',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-17 13:39:11','2022-04-17 13:39:11',1,0,NULL,0,NULL,NULL,0,'01',0.00),(36,'customers','0','0007','Cliente007',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-17 13:40:01','2022-04-17 13:40:01',1,0,NULL,0,NULL,NULL,0,'01',0.00),(37,'customers','0','0008','Cliente008',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-17 13:41:11','2022-04-17 13:41:11',1,0,NULL,0,NULL,NULL,0,'01',0.00),(38,'customers','0','00008','Clientes0091',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-17 13:43:06','2022-04-17 13:43:06',1,0,NULL,0,NULL,NULL,0,'01',0.00),(39,'customers','0','009','Clientes009',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-18 19:17:08','2022-04-18 19:17:08',1,0,NULL,0,NULL,NULL,0,'01',0.00),(40,'customers','0','001','Clientes001',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-18 19:29:30','2022-04-18 19:29:30',1,0,NULL,0,NULL,NULL,0,'01',0.00),(41,'customers','0','0002','Clientes002',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-18 19:34:16','2022-04-18 19:34:16',1,0,NULL,0,NULL,NULL,0,'01',0.00),(42,'customers','0','0003','Clientes003',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-18 19:39:32','2022-04-18 19:39:32',1,0,NULL,0,NULL,NULL,0,'01',0.00),(43,'customers','0','666666666','Cliente17',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-19 13:58:15','2022-04-19 13:58:15',1,0,NULL,0,NULL,NULL,0,'01',0.00),(44,'customers','0','12121212','Cliente18',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-19 14:04:25','2022-04-19 14:04:25',1,0,NULL,0,NULL,NULL,0,'01',0.00),(45,'customers','0','00031','Cliente0031',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-19 20:22:44','2022-04-19 20:22:44',1,0,NULL,0,NULL,NULL,0,'01',0.00),(46,'customers','0','00081','Cliente0009',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-19 20:25:42','2022-04-19 20:25:42',1,0,NULL,0,NULL,NULL,0,'01',0.00),(47,'customers','0','747474','Cliente21',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-20 12:33:04','2022-04-20 12:33:04',1,0,NULL,0,NULL,NULL,0,'01',0.00),(48,'customers','0','00009','Clientes00031',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-20 19:42:17','2022-04-20 19:42:17',1,0,NULL,0,NULL,NULL,0,'01',0.00),(49,'customers','0','00000035','CLIENTES 0008',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-20 19:48:21','2022-04-20 19:48:21',1,0,NULL,0,NULL,NULL,0,'01',0.00),(50,'customers','0','000031','Clientes000031',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-22 21:03:06','2022-04-22 21:03:06',1,0,NULL,0,NULL,NULL,0,'01',0.00),(51,'customers','0','00012','Cliente 0012',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-22 21:05:08','2022-04-22 21:05:08',1,0,NULL,0,NULL,NULL,0,'01',0.00),(52,'customers','0','00000000','Clientes Varios',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-23 10:26:29','2023-02-21 08:18:59',1,0,NULL,0,NULL,NULL,0,'01',0.00),(53,'customers','0','88585','Clientes 636',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-23 21:09:30','2022-04-23 21:09:30',1,0,NULL,0,NULL,NULL,0,'01',0.00),(54,'customers','1','48897470','CABRERA QUIROZ, CINTHIA NIKOLY',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-25 18:15:15','2022-04-25 18:15:15',1,0,NULL,0,NULL,NULL,0,'01',0.00),(55,'customers','1','48991408','ARSUBIALDE RAMIREZ, JULISSA',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-25 20:32:41','2022-04-25 20:32:41',1,0,NULL,0,NULL,NULL,0,'01',0.00),(56,'customers','0','00087','Cliente022',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-26 18:48:18','2022-04-26 18:48:18',1,0,NULL,0,NULL,NULL,0,'01',0.00),(57,'customers','0','225','Cliente5245',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-26 18:48:48','2022-04-26 18:48:48',1,0,NULL,0,NULL,NULL,0,'01',0.00),(58,'customers','0','42542','Cliente52',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-26 18:49:09','2022-04-26 18:49:09',1,0,NULL,0,NULL,NULL,0,'01',0.00),(59,'customers','0','00065','Clientes653',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-27 17:09:39','2022-04-27 17:09:39',1,0,NULL,0,NULL,NULL,0,'01',0.00),(60,'customers','0','25353','Clientes6535',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-27 17:10:19','2022-04-27 17:10:19',1,0,NULL,0,NULL,NULL,0,'01',0.00),(61,'customers','0','010203','Cliente 010203',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-27 19:09:39','2022-04-27 19:09:39',1,0,NULL,0,NULL,NULL,0,'01',0.00),(62,'customers','1','27839383','SAAVEDRA TACURE, ARMENGOL',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-29 14:44:30','2022-04-29 14:44:30',1,0,NULL,0,NULL,NULL,0,'01',0.00),(63,'customers','0','5535','Clientes1252325',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-29 20:54:54','2022-04-29 20:54:54',1,0,NULL,0,NULL,NULL,0,'01',0.00),(64,'customers','0','99868','Clientes9998568',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-29 21:14:38','2022-04-29 21:14:38',1,0,NULL,0,NULL,NULL,0,'01',0.00),(65,'customers','1','74556318','WAJACH YUU, GLIMER',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-30 12:44:03','2022-04-30 12:44:03',1,0,NULL,0,NULL,NULL,0,'01',0.00),(66,'customers','1','43261599','FLORES CUMBAY, ARAMINDA',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-04-30 16:18:31','2022-04-30 16:18:31',1,0,NULL,0,NULL,NULL,0,'01',0.00),(67,'customers','0','5425','Cliente5253',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-01 14:05:38','2022-05-01 14:05:38',1,0,NULL,0,NULL,NULL,0,'01',0.00),(68,'customers','0','95242','Cliente5254',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-01 14:06:03','2022-05-01 14:06:03',1,0,NULL,0,NULL,NULL,0,'01',0.00),(69,'customers','0','5456','Cliente5468756',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-02 20:40:47','2022-05-02 20:40:47',1,0,NULL,0,NULL,NULL,0,'01',0.00),(70,'customers','0','6387966','Clientes 54657',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-02 20:41:26','2022-05-02 20:41:26',1,0,NULL,0,NULL,NULL,0,'01',0.00),(71,'customers','1','41616604','HUANGAL SUAREZ, GILMER',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-03 15:35:34','2022-05-03 15:35:34',1,0,NULL,0,NULL,NULL,0,'01',0.00),(72,'customers','0','336688999','44221166',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-03 16:21:41','2022-05-03 16:21:41',1,0,NULL,0,NULL,NULL,0,'01',0.00),(73,'customers','0','5635436543','Cliente4633',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-03 18:44:30','2022-05-03 18:44:30',1,0,NULL,0,NULL,NULL,0,'01',0.00),(74,'customers','0','56789444','4564321657',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-04 16:01:35','2022-05-04 16:01:35',1,0,NULL,0,NULL,NULL,0,'01',0.00),(75,'customers','0','55451452152','456415454',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-04 16:01:44','2022-05-04 16:01:44',1,0,NULL,0,NULL,NULL,0,'01',0.00),(76,'customers','0','45623456','435687598',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-04 16:12:10','2022-05-04 16:12:10',1,0,NULL,0,NULL,NULL,0,'01',0.00),(77,'customers','0','356356','Clientes365',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-04 19:46:20','2022-05-04 19:46:20',1,0,NULL,0,NULL,NULL,0,'01',0.00),(78,'customers','0','99999999587','Cliente5636',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-05 17:55:35','2022-05-05 17:55:35',1,0,NULL,0,NULL,NULL,0,'01',0.00),(79,'customers','0','976468432','36547888',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-05 18:17:15','2022-05-05 18:17:15',1,0,NULL,0,NULL,NULL,0,'01',0.00),(80,'customers','0','654723456','4536789456',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-05 18:20:04','2022-05-05 18:20:04',1,0,NULL,0,NULL,NULL,0,'01',0.00),(81,'customers','0','9865346567','6578943356',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-05 18:22:06','2022-05-05 18:22:06',1,0,NULL,0,NULL,NULL,0,'01',0.00),(82,'customers','0','123256708876','7684965322',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-05 18:24:37','2022-05-05 18:24:37',1,0,NULL,0,NULL,NULL,0,'01',0.00),(83,'customers','0','6785322567','56784321567',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-05 18:26:23','2022-05-05 18:26:23',1,0,NULL,0,NULL,NULL,0,'01',0.00),(84,'customers','0','9567845687','678345687956',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-05 18:28:50','2022-05-05 18:28:50',1,0,NULL,0,NULL,NULL,0,'01',0.00),(85,'customers','0','564789543','564389765',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-06 13:15:05','2022-05-06 13:15:05',1,0,NULL,0,NULL,NULL,0,'01',0.00),(86,'customers','1','70088971','CORDOVA RAMIREZ, ROXANA ELIZABETH',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-06 18:30:19','2022-05-06 18:30:19',1,0,NULL,0,NULL,NULL,0,'01',0.00),(87,'customers','0','6578995443','564378654',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-07 20:33:56','2022-05-07 20:33:56',1,0,NULL,0,NULL,NULL,0,'01',0.00),(88,'customers','1','47091426','MOLERO VELA, EDITH',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-08 10:29:00','2022-05-08 10:29:00',1,0,NULL,0,NULL,NULL,0,'01',0.00),(89,'customers','1','70128718','CUNIA MERINO, GIANMARCO',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-08 12:03:17','2022-05-08 12:03:17',1,0,NULL,0,NULL,NULL,0,'01',0.00),(90,'customers','0','999539','Clientes 959',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-08 12:20:23','2022-05-08 12:20:23',1,0,NULL,0,NULL,NULL,0,'01',0.00),(91,'customers','0','99969369','Clientes - 936205',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-08 12:21:52','2022-05-08 12:21:52',1,0,NULL,0,NULL,NULL,0,'01',0.00),(92,'customers','1','41137443','RIVERA OLIVERA, ARTEMIO',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-08 15:24:37','2022-05-08 15:24:37',1,0,NULL,0,NULL,NULL,0,'01',0.00),(93,'customers','0','942543254','Clientes 254254',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-09 17:06:38','2022-05-09 17:06:38',1,0,NULL,0,NULL,NULL,0,'01',0.00),(94,'customers','1','71897272','HERRERA ALBERCA, ALEJANDRA',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-09 17:55:39','2022-05-09 17:55:39',1,0,NULL,0,NULL,NULL,0,'01',0.00),(95,'customers','0','9999920029','Clientes 240',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-09 21:15:58','2022-05-09 21:15:58',1,0,NULL,0,NULL,NULL,0,'01',0.00),(96,'customers','1','70477999','ABAD MENDOZA, WINDER EMERSON',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-10 10:44:59','2022-05-10 10:44:59',1,0,NULL,0,NULL,NULL,0,'01',0.00),(97,'customers','1','80206520','VASQUEZ LLANOS, ROSEL',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-10 12:10:25','2022-05-10 12:10:25',1,0,NULL,0,NULL,NULL,0,'01',0.00),(98,'customers','1','43626347','MAJUAN PAICO, MARIA NELLY',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-10 15:14:36','2022-05-10 15:14:36',1,0,NULL,0,NULL,NULL,0,'01',0.00),(99,'customers','1','89654323','jose castillo',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,1,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-11 15:12:51','2022-07-04 19:27:03',1,0,NULL,0,NULL,NULL,0,'01',0.00),(100,'customers','0','768956777','678598764',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-11 18:53:14','2022-05-11 18:53:14',1,0,NULL,0,NULL,NULL,0,'01',0.00),(101,'customers','0','6548790543','6658975422',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-11 18:56:04','2022-05-11 18:56:04',1,0,NULL,0,NULL,NULL,0,'01',0.00),(102,'customers','0','952542','Clientes52752',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-11 19:36:38','2022-05-11 19:36:38',1,0,NULL,0,NULL,NULL,0,'01',0.00),(103,'customers','0','99999532532','Clientes57332',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-11 19:37:08','2022-05-11 19:37:08',1,0,NULL,0,NULL,NULL,0,'01',0.00),(104,'customers','0','769045368','5648763425',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-12 17:42:59','2022-05-12 17:42:59',1,0,NULL,0,NULL,NULL,0,'01',0.00),(105,'customers','0','9870986578','6758987606',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-12 17:44:55','2022-05-12 17:44:55',1,0,NULL,0,NULL,NULL,0,'01',0.00),(106,'customers','0','999635383','Clientes63853',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-12 20:55:09','2022-05-12 20:55:09',1,0,NULL,0,NULL,NULL,0,'01',0.00),(107,'customers','0','99995252532','Clientes325432',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-12 21:02:03','2022-05-12 21:02:03',1,0,NULL,0,NULL,NULL,0,'01',0.00),(108,'customers','0','12132425','Cliente2020',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-13 14:50:03','2022-05-13 14:50:03',1,0,NULL,0,NULL,NULL,0,'01',0.00),(109,'customers','0','9999943653','Clientes63363',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-13 20:53:35','2022-05-13 20:53:35',1,0,NULL,0,NULL,NULL,0,'01',0.00),(110,'customers','0','53433','Clientes 43453',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-13 20:54:07','2022-05-13 20:54:07',1,0,NULL,0,NULL,NULL,0,'01',0.00),(111,'customers','1','33574452','PEREZ CRUZADO, HOLMER',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-14 11:44:34','2022-05-14 11:44:34',1,0,NULL,0,NULL,NULL,0,'01',0.00),(112,'customers','1','27858873','LALANGUI ALVA, SONIA KARINA',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-15 14:42:17','2022-05-15 14:42:17',1,0,NULL,0,NULL,NULL,0,'01',0.00),(113,'customers','1','60679767','CUJA PACUNTA, JOHN NIEL',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-16 17:41:03','2022-05-16 17:41:03',1,0,NULL,0,NULL,NULL,0,'01',0.00),(114,'customers','1','75478441','PINTADO RAMIREZ, BRAYAN SMITH',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-16 17:57:21','2022-05-16 17:57:21',1,0,NULL,0,NULL,NULL,0,'01',0.00),(115,'customers','1','77482023','PADILLA TSEJEM, FELIPE UGKUM',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-16 19:14:54','2022-05-16 19:14:54',1,0,NULL,0,NULL,NULL,0,'01',0.00),(116,'customers','1','60906767','TORRES PAICO, OSCAR JHAMPIER',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-17 19:48:54','2022-05-17 19:48:54',1,0,NULL,0,NULL,NULL,0,'01',0.00),(117,'customers','1','77689202','LOJA ALVARADO, JOSE ARMANDO',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-18 15:38:48','2022-05-18 15:38:48',1,0,NULL,0,NULL,NULL,0,'01',0.00),(118,'customers','1','43903792','LEYVA MERA, LENIN',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-18 17:06:49','2022-05-18 17:06:49',1,0,NULL,0,NULL,NULL,0,'01',0.00),(119,'customers','1','42666799','GAMONAL FLORES, HENRRY WALTER',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-18 21:10:02','2022-05-18 21:10:02',1,0,NULL,0,NULL,NULL,0,'01',0.00),(120,'customers','0','999525252','Clientes254252',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-19 19:03:01','2022-05-19 19:03:01',1,0,NULL,0,NULL,NULL,0,'01',0.00),(121,'customers','0','999992425','Clientes 4532',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-19 19:03:51','2022-05-19 19:03:51',1,0,NULL,0,NULL,NULL,0,'01',0.00),(122,'customers','1','40186564','VILLEGAS MENDOZA, JUANA',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-20 16:33:34','2022-05-20 16:33:34',1,0,NULL,0,NULL,NULL,0,'01',0.00),(123,'customers','1','45418419','CERNA QUIROZ, ONAN CARLOS',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-20 16:43:54','2022-05-20 16:43:54',1,0,NULL,0,NULL,NULL,0,'01',0.00),(124,'customers','1','33588788','RODRIGUEZ PATIÑO, LUIS FELIPE',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-21 12:39:54','2022-05-21 12:39:54',1,0,NULL,0,NULL,NULL,0,'01',0.00),(125,'customers','1','44190033','CHINCHAY CUMBIA, NEPTALI',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-21 12:56:28','2022-05-21 12:56:28',1,0,NULL,0,NULL,NULL,0,'01',0.00),(126,'customers','1','75611125','DOMINGUEZ HUAMAN, ESWIN ELINDER',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-21 15:25:21','2022-05-21 15:25:21',1,0,NULL,0,NULL,NULL,0,'01',0.00),(127,'customers','1','74978895','TOCTO LOZANO, RODRIGO',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-23 19:03:11','2022-05-23 19:03:11',1,0,NULL,0,NULL,NULL,0,'01',0.00),(128,'customers','1','74430838','PORTAL TERRONES, LUIS FERNANDO',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-23 19:07:11','2022-05-23 19:07:11',1,0,NULL,0,NULL,NULL,0,'01',0.00),(129,'customers','1','33562728','TERRONES AVELLANEDA, DINA CARMEN',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-23 20:13:13','2022-05-23 20:13:13',1,0,NULL,0,NULL,NULL,0,'01',0.00),(130,'customers','1','33566852','PAREDES ANDRADE, NELIDA',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-24 10:10:37','2022-05-24 10:10:37',1,0,NULL,0,NULL,NULL,0,'01',0.00),(131,'customers','1','46012418','CUEVA ROJAS, JOSE WILDOR',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-24 10:15:46','2022-05-24 10:15:46',1,0,NULL,0,NULL,NULL,0,'01',0.00),(132,'customers','1','76680875','REQUEJO PAZ, ALEX RAÚL',NULL,NULL,NULL,'PE',NULL,'14','1401','140106',NULL,'PUEBLO JOVEN SEÑOR DE LA MISERICORDIA MZ. F LT. 10',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-25 20:41:40','2022-05-25 20:41:40',1,0,NULL,0,NULL,NULL,0,'01',0.00),(133,'customers','1','41616648','BRIONES TERRONES, ARACELHY',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-25 20:45:18','2022-05-25 20:45:18',1,0,NULL,0,NULL,NULL,0,'01',0.00),(134,'customers','1','75843096','MALCA ILATOMA, YOLANDA SHAQUIRA',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'AREQUIPA 181',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-27 21:16:13','2022-05-27 21:16:13',1,0,NULL,0,NULL,NULL,0,'01',0.00),(135,'customers','1','41716898','ROJAS FLORES, NEYDA MARISA',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'JR. ATAHUALPA 167',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-28 12:21:36','2022-05-28 12:21:36',1,0,NULL,0,NULL,NULL,0,'01',0.00),(136,'customers','1','48131282','LIMA BUSTAMANTE, JOSE EDIN',NULL,NULL,NULL,'PE',NULL,'15','1501','150110',NULL,'JR. HUSARES DE JUNIN 699',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-28 13:52:45','2022-05-28 13:52:45',1,0,NULL,0,NULL,NULL,0,'01',0.00),(137,'customers','1','33663709','GONZALES GAONA, JOSE LEODAN',NULL,NULL,NULL,'PE',NULL,'14','1401','140101',NULL,'CALLE 24 DE JULIO 115',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-30 11:35:48','2022-05-30 11:35:48',1,0,NULL,0,NULL,NULL,0,'01',0.00),(138,'customers','1','42488204','MESTANZA CABALLERO, LUIS AGUINALDO',NULL,NULL,NULL,'PE',NULL,'01','0107','010704',NULL,'CASERIO LA PAPAYA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-31 16:17:18','2022-05-31 16:17:18',1,0,NULL,0,NULL,NULL,0,'01',0.00),(139,'customers','1','27750274','HUATANGARE FERNANDEZ, LORENZO',NULL,NULL,NULL,'PE',NULL,'06','0608','060812',NULL,'CASERIO MOLINO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-05-31 16:51:36','2022-05-31 16:51:36',1,0,NULL,0,NULL,NULL,0,'01',0.00),(140,'customers','6','20109565017','CONSTRUCCION Y ADMINISTRACION S.A.',NULL,NULL,NULL,'PE',NULL,'15','1501','150140',NULL,'AV. JAVIER PRADO ESTE NRO. 4109 URB. SANTA CONSTANZA','HABIDO','ACTIVO',NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-01 09:24:13','2022-06-01 09:24:13',1,0,NULL,0,NULL,NULL,0,'01',0.00),(141,'customers','1','72756341','FLORES PAQUIRACHIN, JENIFER KAREN',NULL,NULL,NULL,'PE',NULL,'06','0609','060906',NULL,'SECTOR VISTA FLORIDA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-03 16:57:28','2022-06-03 16:57:28',1,0,NULL,0,NULL,NULL,0,'01',0.00),(142,'customers','1','48144453','TEETS CHAVEZ, ELMER JHONNY',NULL,NULL,NULL,'PE',NULL,'01','0102','010205',NULL,'COMUNIDAD NATIVA WAWAS',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-03 20:50:28','2022-06-03 20:50:28',1,0,NULL,0,NULL,NULL,0,'01',0.00),(143,'customers','1','61602820','OJEDA ROMAN, LUZ SOCORRO',NULL,NULL,NULL,'PE',NULL,'06','0609','060901',NULL,'CASERIO NUEVO PORVENIR',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-04 11:34:39','2022-06-04 11:34:39',1,0,NULL,0,NULL,NULL,0,'01',0.00),(144,'customers','1','46094332','KAJEKUI MASHIGKASH, BETO',NULL,NULL,NULL,'PE',NULL,'01','0102','010205',NULL,'COMUNID.NATIVA NAZARETH',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-04 12:15:21','2022-06-04 12:15:21',1,0,NULL,0,NULL,NULL,0,'01',0.00),(145,'customers','1','02805780','UCEDA OLIVA, WILFREDO',NULL,NULL,NULL,'PE',NULL,'06','0601','060101',NULL,'JR. HORACIO URTEAGA 157B INT. PISO 3 BARRIO SAN PEDRO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-04 13:19:11','2022-06-04 13:19:11',1,0,NULL,0,NULL,NULL,0,'01',0.00),(146,'customers','1','75865108','VALLES PEREZ, EDWIN ORLANDO',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'CP DE TOMAQUE CASERIO EL HORNO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-06 12:59:19','2022-06-06 12:59:19',1,0,NULL,0,NULL,NULL,0,'01',0.00),(147,'customers','1','33578822','MEGO ROJAS, SANTOS CHARLES',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'JR.AYACUCHO 846',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-06 14:44:40','2022-06-06 14:44:40',1,0,NULL,0,NULL,NULL,0,'01',0.00),(148,'customers','1','76574944','QUINDE GOMEZ, DELIS',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'PSJ. TUPAC AMARU 392',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-06 16:19:18','2022-06-06 16:19:18',1,0,NULL,0,NULL,NULL,0,'01',0.00),(149,'customers','1','41779361','HUAMAN QUISTAN, ROVINSON',NULL,NULL,NULL,'PE',NULL,'01','0101','010108',NULL,'JR.CAMPORREDONDO S/N',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-08 16:31:50','2022-06-08 16:31:50',1,0,NULL,0,NULL,NULL,0,'01',0.00),(150,'customers','1','45167669','TORRES RIVAS DE SUAREZ, SUSETHY ESTHER',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'JR. COMERCIO 372',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-08 20:39:02','2022-06-08 20:39:02',1,0,NULL,0,NULL,NULL,0,'01',0.00),(151,'customers','1','61313733','INFANTAS CALDERON, LEANDRO DANIEL',NULL,NULL,NULL,'PE',NULL,'01','0102','010206',NULL,'AV. INDEPENDENCIA 437',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-09 18:02:53','2022-06-09 18:02:53',1,0,NULL,0,NULL,NULL,0,'01',0.00),(152,'customers','1','73439311','SEGURA LLAMO, DARWIN ALEXIS',NULL,NULL,NULL,'PE',NULL,'01','0102','010206',NULL,'CP CHONZA ALTA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-10 11:29:19','2022-06-10 11:29:19',1,0,NULL,0,NULL,NULL,0,'01',0.00),(153,'customers','1','44642841','TANTALEAN QUISPE, JOSE RONALD',NULL,NULL,NULL,'PE',NULL,'01','0102','010206',NULL,'CPM. EL TRIUNFO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-10 11:32:32','2022-06-10 11:32:32',1,0,NULL,0,NULL,NULL,0,'01',0.00),(154,'customers','1','48905160','ROBALINO MELENDEZ, GILBERTO ALEN',NULL,NULL,NULL,'PE',NULL,'16','1607','160704',NULL,'CPM. PUERTA AMERICA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-11 15:56:21','2022-06-11 15:56:21',1,0,NULL,0,NULL,NULL,0,'01',0.00),(155,'customers','1','48421597','REYNA MUCUSHUA, CARLOS ADRIAN',NULL,NULL,NULL,'PE',NULL,'16','1607','160704',NULL,'CASERIO PUERTO AMERICA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-11 15:57:36','2022-06-11 15:57:36',1,0,NULL,0,NULL,NULL,0,'01',0.00),(156,'customers','1','75806149','SANCHEZ DELGADO, DANNER OMAR',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'JR. ICA 474',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-12 12:19:53','2022-06-12 12:19:53',1,0,NULL,0,NULL,NULL,0,'01',0.00),(157,'customers','1','62423275','MONTEZA CASTILLO, SAHID ANDERSON',NULL,'861',NULL,'PE',NULL,'01','0102','010201',NULL,'JR. ARGENTINA 158',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-13 11:50:30','2022-06-13 11:50:30',1,0,NULL,0,NULL,NULL,0,'01',0.00),(158,'customers','1','43000584','MONTEZA GUEVARA, RAUL DARIO','cod: 002',NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'PSJ. JAVIER HERAUD 100',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-13 12:01:49','2022-06-13 12:01:49',1,0,NULL,0,NULL,NULL,0,'01',0.00),(159,'customers','1','72076371','AREVALO CARRASCO, ROSBIN',NULL,NULL,NULL,'PE',NULL,'01','0107','010704',NULL,'CENTRO POBLADO JOROBAMBA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-16 16:39:37','2022-06-16 16:39:37',1,0,NULL,0,NULL,NULL,0,'01',0.00),(160,'customers','1','71071673','SANTA CRUZ LLOCLLA, NOLBERTO JOSE',NULL,NULL,NULL,'PE',NULL,'06','0609','060901',NULL,'CASERIO BAJO IHUAMACA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-16 19:55:34','2022-06-16 19:55:34',1,0,NULL,0,NULL,NULL,0,'01',0.00),(161,'customers','1','33569140','URIOL NINATANTA, NEIDA MARDELI',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'CALLE FELIZMER URIOL 292',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-18 10:03:55','2022-06-18 10:03:55',1,0,NULL,0,NULL,NULL,0,'01',0.00),(162,'customers','1','75878768','VASQUEZ DELGADO, NILSON',NULL,NULL,NULL,'PE',NULL,'01','0102','010202',NULL,'CPM. EL PORVENIR',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-18 10:30:06','2022-06-18 10:30:06',1,0,NULL,0,NULL,NULL,0,'01',0.00),(163,'customers','1','45222819','OLANO GUERRERO, JOSE WILDER',NULL,NULL,NULL,'PE',NULL,'01','0107','010704',NULL,'CASERIO CRUCE CAYALTI',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-19 14:52:11','2022-06-19 14:52:11',1,0,NULL,0,NULL,NULL,0,'01',0.00),(164,'customers','1','72076323','LOZANO CONTRERAS, EFRAIN',NULL,NULL,NULL,'PE',NULL,'01','0107','010704',NULL,'CAS. CRUCE CAYLTI',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-19 15:52:55','2022-06-19 15:52:55',1,0,NULL,0,NULL,NULL,0,'01',0.00),(165,'customers','1','73698631','CASTAÑEDA MONTENEGRO, RUTH FAUSTINA',NULL,NULL,NULL,'PE',NULL,'01','0102','010204',NULL,'CP. TOLOPAMPA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-19 16:38:20','2022-06-19 16:38:20',1,0,NULL,0,NULL,NULL,0,'01',0.00),(166,'customers','1','41472677','ROJAS SANTA CRUZ, MAGALI',NULL,NULL,NULL,'PE',NULL,'01','0102','010204',NULL,'CASERIO PUERTO BOLIVAR',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-21 17:48:53','2022-06-21 17:48:53',1,0,NULL,0,NULL,NULL,0,'01',0.00),(167,'customers','1','40837879','MONTENEGRO PERALES, ROSA HAYDEE',NULL,NULL,NULL,'PE',NULL,'01','0102','010205',NULL,'AV. PRINCIPAL S/N-CPM. CHIRIACO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-21 18:38:52','2022-06-21 18:38:52',1,0,NULL,0,NULL,NULL,0,'01',0.00),(168,'customers','1','48678039','INTAKEA AMPUSH, LEANORA MAVILA LEADY',NULL,NULL,NULL,'PE',NULL,'01','0104','010401',NULL,'C.POBLADO KIGKIS',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-22 12:04:11','2022-06-22 12:04:11',1,0,NULL,0,NULL,NULL,0,'01',0.00),(169,'customers','1','47925391','CRUZ ALTAMIRANO, ARACELY',NULL,NULL,NULL,'PE',NULL,'06','0609','060902',NULL,'CAS. INDOAMERICA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-22 15:59:11','2022-06-22 15:59:11',1,0,NULL,0,NULL,NULL,0,'01',0.00),(170,'customers','1','75801854','VELASCO NEYRA, MAGDA YUSUNI',NULL,NULL,NULL,'PE',NULL,'06','0609','060901',NULL,'CAS. ALFONSO UGARTE',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-23 15:11:06','2022-06-23 15:11:06',1,0,NULL,0,NULL,NULL,0,'01',0.00),(171,'customers','1','72210244','OBLITAS VILLANUEVA, SANTOS HERNAN',NULL,NULL,NULL,'PE',NULL,'14','1401','140101',NULL,'CALLE CAJAMARCA 445 PP.JJ JOSE OLAYA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-23 21:00:47','2022-06-23 21:00:47',1,0,NULL,0,NULL,NULL,0,'01',0.00),(172,'customers','0','0021','Clientes NEPTALI',NULL,NULL,NULL,'PE',NULL,'01','0102','010205',NULL,'CASERIO NUEVO HUANCABAMBA',NULL,NULL,NULL,NULL,0.00,0,2,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-24 14:50:00','2022-06-24 14:50:00',1,0,NULL,0,NULL,NULL,0,'01',0.00),(173,'customers','1','46374997','CHINCHAY CUMBIA, ABSALON',NULL,NULL,NULL,'PE',NULL,'22','2203','220301',NULL,'JR. TACNA 639',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-24 14:51:45','2022-06-24 14:51:45',1,0,NULL,0,NULL,NULL,0,'01',0.00),(174,'customers','1','33826079','HORNA VASQUEZ, TOMAS',NULL,NULL,NULL,'PE',NULL,'01','0107','010701',NULL,'JR. PUMACAHUA 223',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-24 20:54:05','2022-06-24 20:54:05',1,0,NULL,0,NULL,NULL,0,'01',0.00),(175,'customers','1','41273812','ROJAS GARCIA, VIKY',NULL,NULL,NULL,'PE',NULL,'06','0609','060903',NULL,'SECTOR LA FILA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-25 11:08:15','2022-06-25 11:08:15',1,0,NULL,0,NULL,NULL,0,'01',0.00),(176,'customers','1','46005446','LLACSAHUANGA ACHA, ELCY',NULL,NULL,NULL,'PE',NULL,'06','0609','060901',NULL,'PJ. C-1 URB. SAN MARTIN',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-25 11:40:26','2022-06-25 11:40:26',1,0,NULL,0,NULL,NULL,0,'01',0.00),(177,'customers','1','76182316','BERRIOS LA TORRE, IAN BRAYAN',NULL,NULL,NULL,'PE',NULL,'15','1501','150132',NULL,'AV. LOS JARDINES 517 URB. INCA MANCO CAPAC',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-25 17:08:02','2022-06-25 17:08:02',1,0,NULL,0,NULL,NULL,0,'01',0.00),(178,'customers','1','26957984','ARMAS PAREDES, TOMAS WILLAN',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'JR. MOQUEGUA 1000',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-26 10:13:55','2022-06-26 10:13:55',1,0,NULL,0,NULL,NULL,0,'01',0.00),(179,'customers','1','45043562','FLORES JARAMILLO, VICTORIA ROSA',NULL,NULL,NULL,'PE',NULL,'06','0609','060901',NULL,'CA. ATAHUALPA 501',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-26 10:28:43','2022-06-26 10:28:43',1,0,NULL,0,NULL,NULL,0,'01',0.00),(180,'customers','1','72003407','GALLO ALVAREZ, MARIA BELEN MILAGRITOS',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'JR. VALCARCEL C-02',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-26 10:36:48','2022-06-26 10:36:48',1,0,NULL,0,NULL,NULL,0,'01',0.00),(181,'customers','1','72718777','CHUQUILLANQUI SOTO, VICTOR MANUEL',NULL,NULL,NULL,'PE',NULL,'20','2001','200104',NULL,'CALLE LOS ROSALES MZ N LT 6 URB EL BOSQUE',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-27 15:37:37','2022-06-27 15:37:37',1,0,NULL,0,NULL,NULL,0,'01',0.00),(182,'customers','1','46058893','BURGOS NUÑEZ, NILDA ROSA',NULL,NULL,NULL,'PE',NULL,'15','1501','150121',NULL,'CALLE SANTA ISABEL 665 URB COLMENARES',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-29 14:55:50','2022-06-29 14:55:50',1,0,NULL,0,NULL,NULL,0,'01',0.00),(183,'customers','1','74381280','PEÑA DIAZ, SEGUNDO JACINTO',NULL,NULL,NULL,'PE',NULL,'01','0102','010205',NULL,'CALLE LAS DELICIAS S/N C.POBLADO CHIRIACO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-06-29 21:27:01','2022-06-29 21:27:01',1,0,NULL,0,NULL,NULL,0,'01',0.00),(184,'customers','1','03130597','DOMINGUEZ PEÑA, OVIDIO',NULL,NULL,NULL,'PE',NULL,'06','0609','060901',NULL,'CAS. BELLAVISTA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-01 14:59:29','2022-07-01 14:59:29',1,0,NULL,0,NULL,NULL,0,'01',0.00),(185,'customers','1','75741801','TSAMAJAIN APIKAI, LUIS NEVER',NULL,NULL,NULL,'PE',NULL,'01','0102','010205',NULL,'COMUNID.NATIVA SHUSHUG',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-01 19:46:34','2022-07-01 19:46:34',1,0,NULL,0,NULL,NULL,0,'01',0.00),(186,'customers','1','42542574','LESCANO VALLEJOS, MARIA ELVIA',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'JR. ICA C-4 INT. 0011 CENT BAGUA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-01 20:21:04','2022-07-01 20:21:04',1,0,NULL,0,NULL,NULL,0,'01',0.00),(187,'customers','1','42140758','ORDOÑEZ ROMAN, JORGE JOSE',NULL,NULL,NULL,'PE',NULL,'06','0609','060901',NULL,'CASERIO MIRAFLORES',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-02 11:21:35','2022-07-02 11:21:35',1,0,NULL,0,NULL,NULL,0,'01',0.00),(188,'customers','1','47357056','JULCA VASQUEZ, ALFONSO',NULL,NULL,NULL,'PE',NULL,'06','0606','060614',NULL,'C.POBLADO SAN ANTONIO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-02 11:57:00','2022-07-02 11:57:00',1,0,NULL,0,NULL,NULL,0,'01',0.00),(189,'customers','1','71201511','GONZALES CHUQUIHUANGA, KELIDA',NULL,NULL,NULL,'PE',NULL,'06','0609','060906',NULL,'C.P. CALABOZO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-02 16:22:07','2022-07-02 16:22:07',1,0,NULL,0,NULL,NULL,0,'01',0.00),(190,'customers','1','70889096','GUERRERO RODRIGUEZ, ANDY HELBERT',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'PSJ. LOS OLIVOS 100',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-02 20:42:13','2022-07-02 20:42:13',1,0,NULL,0,NULL,NULL,0,'01',0.00),(191,'customers','1','76380110','MELENDREZ NEIRA, IRISBELLA MARISOL',NULL,NULL,NULL,'PE',NULL,'06','0609','060901',NULL,'AV. MARIANO MELGAR S/N',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-05 14:55:22','2022-07-05 14:55:22',1,0,NULL,0,NULL,NULL,0,'01',0.00),(192,'customers','1','47624077','MURAYARI YUYARIMA, GLENDY MARGARITA',NULL,NULL,NULL,'PE',NULL,'15','1501','150135',NULL,'JR. LAS AMERICAS 1031 MZ. K2 LT. 20 PISO 2 URB. EL ROSARIO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-06 10:37:50','2022-07-06 10:37:50',1,0,NULL,0,NULL,NULL,0,'01',0.00),(193,'customers','1','45907788','DELGADO PIZARRO, YMELDA',NULL,NULL,NULL,'PE',NULL,'01','0102','010204',NULL,'CA CAJAMARCA 0777',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-06 17:17:34','2022-07-06 17:17:34',1,0,NULL,0,NULL,NULL,0,'01',0.00),(194,'customers','1','73244532','FLORES YNFANTE, BRAYAN ANTONY',NULL,NULL,NULL,'PE',NULL,'06','0609','060903',NULL,'CASERIO CRUCE MOLINO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-06 19:14:52','2022-07-06 19:14:52',1,0,NULL,0,NULL,NULL,0,'01',0.00),(195,'customers','6','20522623998','EPE',NULL,NULL,NULL,'PE',NULL,'15','1501','150113',NULL,'AV. GREGORIO ESCOBEDO NRO. 426 RES. SAN FELIPE DPTO. 1701','HABIDO','ACTIVO',NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-07 10:14:45','2022-07-07 10:14:45',1,0,NULL,0,NULL,NULL,0,'01',0.00),(196,'customers','1','70926968','FLORES SALVADOR, ALEX MAYCOL',NULL,NULL,NULL,'PE',NULL,'25','2501','250101',NULL,'JR. IQUITOS 593',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-07 15:28:01','2022-07-07 15:28:01',1,0,NULL,0,NULL,NULL,0,'01',0.00),(197,'customers','1','41548115','DELGADO GUEVARA, AUDIAS',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'CA TOMAQUE S/N SEC. BRUJO PATA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-08 14:34:54','2022-07-08 14:34:54',1,0,NULL,0,NULL,NULL,0,'01',0.00),(198,'customers','1','42606688','CORONADO FERNANDEZ, JUAN CARLOS',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'AV.CIRCUNVALACION 1652',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-09 16:35:34','2022-07-09 16:35:34',1,0,NULL,0,NULL,NULL,0,'01',0.00),(199,'customers','1','17619748','SANTISTEVAN RUBIO, MARCO ANTONIO',NULL,NULL,NULL,'PE',NULL,'01','0102','010206',NULL,'CPM.SAN ISIDRO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-10 09:36:53','2022-07-10 09:36:53',1,0,NULL,0,NULL,NULL,0,'01',0.00),(200,'customers','1','47117300','SOTO SERRANO, ALEX',NULL,NULL,NULL,'PE',NULL,'10','1006','100602',NULL,'CENTRO POBLADO PUMAHUASI',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-10 10:38:41','2022-07-10 10:38:41',1,0,NULL,0,NULL,NULL,0,'01',0.00),(201,'customers','1','48022601','VILLANUEVA SARMIENTO, DEYBER',NULL,NULL,NULL,'PE',NULL,'06','0608','060812',NULL,'CASERIO LA YUNGA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-14 16:11:38','2022-07-14 16:11:38',1,0,NULL,0,NULL,NULL,0,'01',0.00),(202,'customers','1','72967308','VELASQUEZ MEZA, EUDI JERLI',NULL,NULL,NULL,'PE',NULL,'06','0609','060906',NULL,'CASERIO LA CHORRERA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-15 12:33:13','2022-07-15 12:33:13',1,0,NULL,0,NULL,NULL,0,'01',0.00),(203,'customers','0','52533','Clientes 41227',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-15 21:50:15','2022-07-15 21:50:15',1,0,NULL,0,NULL,NULL,0,'01',0.00),(204,'customers','1','75801390','REQUEJO PEREZ, ROMEL ALAIN',NULL,NULL,NULL,'PE',NULL,'01','0107','010704',NULL,'CP SAN PEDRO DE LA PAPAYA CASERIO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-16 14:31:29','2022-07-16 14:31:29',1,0,NULL,0,NULL,NULL,0,'01',0.00),(205,'customers','1','47127721','HUAMAN DELGADO, ALCIDES',NULL,NULL,NULL,'PE',NULL,'06','0609','060906',NULL,'CAS LOS ALPES',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-16 16:25:09','2022-07-16 16:25:09',1,0,NULL,0,NULL,NULL,0,'01',0.00),(206,'customers','1','44389815','TORRES NUNAYALLI, ROBIN SANTOS',NULL,NULL,NULL,'PE',NULL,'01','0102','010206',NULL,'JR.PIURA 296 BAGUA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-17 10:48:18','2022-07-17 10:48:18',1,0,NULL,0,NULL,NULL,0,'01',0.00),(207,'customers','1','42905515','CHANTA PUSMA, ELMER',NULL,NULL,NULL,'PE',NULL,'15','1501','150134',NULL,'YEN ESCOBEDO 532 LA VIÑA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-18 11:12:21','2022-07-18 11:12:21',1,0,NULL,0,NULL,NULL,0,'01',0.00),(208,'customers','1','73069962','VITON SAAVEDRA, JUNIOR JOHANNS',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'JR.SARGENTO LORES C-11',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-18 20:22:33','2022-07-18 20:22:33',1,0,NULL,0,NULL,NULL,0,'01',0.00),(209,'customers','1','70457823','RAMIREZ ROMERO, JUNIOR ANTONY',NULL,NULL,NULL,'PE',NULL,'22','2209','220901',NULL,'JR.URUGUAY 120 TRAS DE FONAVI',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-22 14:17:22','2022-07-22 14:17:22',1,0,NULL,0,NULL,NULL,0,'01',0.00),(210,'customers','1','44541774','SHIKIU UKUNCHAM, ADELINA',NULL,NULL,NULL,'PE',NULL,'15','1501','150117',NULL,'MZ.22 LT.34 ASENT. H. LAURA CALLER IBERICO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-22 19:49:49','2022-07-22 19:49:49',1,0,NULL,0,NULL,NULL,0,'01',0.00),(211,'customers','1','45680020','GARCIA GARCIA, AMIN',NULL,NULL,NULL,'PE',NULL,'06','0609','060905',NULL,'CASERIO PAMPA VERDE',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-23 10:11:53','2022-07-23 10:11:53',1,0,NULL,0,NULL,NULL,0,'01',0.00),(212,'customers','6','10206406840','CAMACHO DELGADO FREDDY MANUEL',NULL,NULL,NULL,'PE',NULL,'15','1501','150117',NULL,'JR. PARIAHUANCA NRO. 608 URB. EL PARQUE DEL NARANJ','HABIDO','ACTIVO',NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-23 20:43:49','2022-07-23 20:43:49',1,0,NULL,0,NULL,NULL,0,'01',0.00),(213,'customers','1','70587181','LIBAQUE BERNAL, DONICIO',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'CASERIO GUADALUPE',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-24 12:57:00','2022-07-24 12:57:00',1,0,NULL,0,NULL,NULL,0,'01',0.00),(214,'customers','1','80536276','ROJAS VERA, DARIO',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'AV.MARIANO MELGAR 763',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-25 10:32:07','2022-07-25 10:32:07',1,0,NULL,0,NULL,NULL,0,'01',0.00),(215,'customers','1','75718695','ADRIANZEN TINEO, YOICCI ALEXANDRA',NULL,NULL,NULL,'PE',NULL,'06','0609','060901',NULL,'CALLE JOSE A.QUIÑONES O LT.3 INT.MZ-4 SEC SANTIAGO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-27 11:40:17','2022-07-27 11:40:17',1,0,NULL,0,NULL,NULL,0,'01',0.00),(216,'customers','1','45830214','DIAZ RIOS, BIANCA VIVIANA',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'JR. LAMBAYEQUE 633',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-28 15:15:13','2022-07-28 15:15:13',1,0,NULL,0,NULL,NULL,0,'01',0.00),(217,'customers','1','02823867','CARRASCO TEJADA, JAIME LUIS',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'JR. AYACUCHO 872',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-30 19:54:51','2022-07-30 19:54:51',1,0,NULL,0,NULL,NULL,0,'01',0.00),(218,'customers','1','41310303','DIAZ JULON, WILIAN NIXON',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'AV.CIRCUNVALACION 1700',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-31 11:34:55','2022-07-31 11:34:55',1,0,NULL,0,NULL,NULL,0,'01',0.00),(219,'customers','1','74949120','GRANADOS VASQUEZ, VICTOR ALFREDO',NULL,NULL,NULL,'PE',NULL,'01','0102','010204',NULL,'CASERIO BUENOS AIRES',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-07-31 11:52:05','2022-07-31 11:52:05',1,0,NULL,0,NULL,NULL,0,'01',0.00),(220,'customers','1','33590148','NUÑEZ SALAZAR, DILMER',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'JR.MESONES MURO 345',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-01 18:53:03','2022-08-01 18:53:03',1,0,NULL,0,NULL,NULL,0,'01',0.00),(221,'customers','1','27732351','FERNANDEZ RAFAEL, ANIBAL',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'JR. CAJAMARCA 800',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-02 13:47:12','2022-08-02 13:47:12',1,0,NULL,0,NULL,NULL,0,'01',0.00),(222,'customers','1','73521374','VASQUEZ NEIRA, JOSE LUIS ENRIQUE',NULL,NULL,NULL,'PE',NULL,'01','0102','010206',NULL,'JR. LIMA 238-CPM.ARRAYAN',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-03 13:31:01','2022-08-03 13:31:01',1,0,NULL,0,NULL,NULL,0,'01',0.00),(223,'customers','6','10335734012','CASTILLO DELGADO BENILDE',NULL,NULL,NULL,'PE',NULL,'06','0608','060801',NULL,'CAL. JUNIN NRO. 423 MORRO SOLAR','HABIDO','ACTIVO',NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-04 09:30:26','2022-08-04 09:30:26',1,0,NULL,0,NULL,NULL,0,'01',0.00),(224,'customers','1','43319701','IMPI RUIZ, JANNY',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'JR. 1RO SETIEMBRE C-02 SEC. 18 DE ENERO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-04 17:20:11','2022-08-04 17:20:11',1,0,NULL,0,NULL,NULL,0,'01',0.00),(225,'customers','1','47191141','MENDOZA FERNANDEZ, JOSELITO',NULL,NULL,NULL,'PE',NULL,'01','0102','010206',NULL,'JR. A 303 CP. ARRAYAN',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-05 11:15:50','2022-08-05 11:15:50',1,0,NULL,0,NULL,NULL,0,'01',0.00),(226,'customers','1','72083302','CORREA CHINCHAY, JORGE ELIAS',NULL,NULL,NULL,'PE',NULL,'01','0102','010206',NULL,'CA. SANTIAGO DE LOMAS 00212',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-05 12:13:04','2022-08-05 12:13:04',1,0,NULL,0,NULL,NULL,0,'01',0.00),(227,'customers','1','77065679','LINARES ALTAMIRANO, JUAN GABRIEL',NULL,NULL,NULL,'PE',NULL,'01','0107','010702',NULL,'CP. EL RON',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-05 15:12:26','2022-08-05 15:12:26',1,0,NULL,0,NULL,NULL,0,'01',0.00),(228,'customers','1','46591943','UGKUCH PETSA, BALTAZAR TSAMAJAIN',NULL,NULL,NULL,'PE',NULL,'01','0104','010403',NULL,'C.P. YUTUPIS',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-05 16:26:14','2022-08-05 16:26:14',1,0,NULL,0,NULL,NULL,0,'01',0.00),(229,'customers','0','99955557','Clientes 785',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-05 21:42:58','2022-08-05 21:42:58',1,0,NULL,0,NULL,NULL,0,'01',0.00),(230,'customers','1','71066132','TOCTO QUINTANA, ALEX FERNANDO',NULL,NULL,NULL,'PE',NULL,'06','0609','060901',NULL,'CAS MARIZAGUA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-06 14:08:17','2022-08-06 14:08:17',1,0,NULL,0,NULL,NULL,0,'01',0.00),(231,'customers','1','43761347','MANCHAY PADILLA, REYNALDO',NULL,NULL,NULL,'PE',NULL,'01','0102','010202',NULL,'JR. AMAZONAS 00S/N CENT ARAMANGO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-06 16:46:35','2022-08-06 16:46:35',1,0,NULL,0,NULL,NULL,0,'01',0.00),(232,'customers','1','77145572','SUKUT TSAMAJAIN, ELSA',NULL,NULL,NULL,'PE',NULL,'01','0102','010205',NULL,'COMUNID.NATIVA MEENTE - SHUSHUG',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-07 11:09:16','2022-08-07 11:09:16',1,0,NULL,0,NULL,NULL,0,'01',0.00),(233,'customers','1','45049187','DIAZ TORRES, WINKERMAN',NULL,NULL,NULL,'PE',NULL,'15','1501','150110',NULL,'COOP. PRIMAVERA MZ. A1 LT. 40',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-09 11:16:45','2022-08-09 11:16:45',1,0,NULL,0,NULL,NULL,0,'01',0.00),(234,'customers','0','999999222','Clientes - 4242',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-09 21:12:43','2022-08-09 21:12:43',1,0,NULL,0,NULL,NULL,0,'01',0.00),(235,'customers','1','46448187','LLAUCE GONZALES, ANA LIDIA',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'JR.PIURA C-04',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-11 20:45:07','2022-08-11 20:45:07',1,0,NULL,0,NULL,NULL,0,'01',0.00),(236,'customers','1','27823144','OCUPA OJEDA, CLARA NELIDA',NULL,NULL,NULL,'PE',NULL,'06','0609','060901',NULL,'CAS. CHILILIQUE',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-13 17:49:41','2022-08-13 17:49:41',1,0,NULL,0,NULL,NULL,0,'01',0.00),(237,'customers','0','9995787587','Clientes75875',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-13 20:16:27','2022-08-13 20:16:27',1,0,NULL,0,NULL,NULL,0,'01',0.00),(238,'customers','1','43208151','VASQUEZ CARRASCAL, SEGUNDO OSCAR',NULL,NULL,NULL,'PE',NULL,'01','0102','010203',NULL,'SECTOR MIRAFLORES',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-14 11:32:42','2022-08-14 11:32:42',1,0,NULL,0,NULL,NULL,0,'01',0.00),(239,'customers','1','43000564','CABRERA BARDALES, ELIAS',NULL,NULL,NULL,'PE',NULL,'01','0102','010206',NULL,'JR. CHACHAPOYAS 00 S/N',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-14 11:59:08','2022-08-14 11:59:08',1,0,NULL,0,NULL,NULL,0,'01',0.00),(240,'customers','0','9999233','Clientes53543',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-14 12:38:23','2022-08-14 12:38:23',1,0,NULL,0,NULL,NULL,0,'01',0.00),(241,'customers','1','45418374','DOMINGUEZ JARA, MANUEL ENRIQUE',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'C.POBLADO TOMAQUE',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-15 19:09:33','2022-08-15 19:09:33',1,0,NULL,0,NULL,NULL,0,'01',0.00),(242,'customers','1','43146141','MEGO VALQUI, NELSON',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'HUASCARAN 635',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-16 17:51:55','2022-08-16 17:51:55',1,0,NULL,0,NULL,NULL,0,'01',0.00),(243,'customers','0','992252','Clientes 525',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-17 18:09:36','2022-08-17 18:09:36',1,0,NULL,0,NULL,NULL,0,'01',0.00),(244,'customers','0','999252','Clientes - 252542',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-18 20:06:09','2022-08-18 20:06:09',1,0,NULL,0,NULL,NULL,0,'01',0.00),(245,'customers','0','9995535','Clientes - 53535',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-18 20:13:56','2022-08-18 20:13:56',1,0,NULL,0,NULL,NULL,0,'01',0.00),(246,'customers','0','999433','Clientes 556',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-19 21:00:25','2022-08-19 21:00:25',1,0,NULL,0,NULL,NULL,0,'01',0.00),(247,'customers','1','47752662','AKINTUI WASHIKAT, ELENGAY ELEDINO',NULL,NULL,NULL,'PE',NULL,'01','0102','010205',NULL,'COMUNIDAD NATIVA COCHA VERDE',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-20 16:37:12','2022-08-20 16:37:12',1,0,NULL,0,NULL,NULL,0,'01',0.00),(248,'customers','1','40771446','LEON QUISPE, LUCY',NULL,NULL,NULL,'PE',NULL,'01','0102','010206',NULL,'JR.LIMA 229',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-20 17:27:04','2022-08-20 17:27:04',1,0,NULL,0,NULL,NULL,0,'01',0.00),(249,'customers','0','999954363','Clientes - 636',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-21 14:04:12','2022-08-21 14:04:12',1,0,NULL,0,NULL,NULL,0,'01',0.00),(250,'customers','0','56353','Clientes 5785',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-22 20:15:28','2022-08-22 20:15:28',1,0,NULL,0,NULL,NULL,0,'01',0.00),(251,'customers','0','5436543','Clientes 4252',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-22 20:17:40','2022-08-22 20:17:40',1,0,NULL,0,NULL,NULL,0,'01',0.00),(252,'customers','0','9999565','Clientes - 36533',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-25 22:17:32','2022-08-25 22:17:32',1,0,NULL,0,NULL,NULL,0,'01',0.00),(253,'customers','0','993653','Clientes - 566+5',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-25 22:18:43','2022-08-25 22:18:43',1,0,NULL,0,NULL,NULL,0,'01',0.00),(254,'customers','1','40760817','NUÑEZ ABANTO, YENI GRISELDA',NULL,NULL,NULL,'PE',NULL,'01','0102','010204',NULL,'AV. TUPAC AMARU 776 CIUDAD DISTRITO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-26 18:00:46','2022-08-26 18:00:46',1,0,NULL,0,NULL,NULL,0,'01',0.00),(255,'customers','0','999425','Client542535',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-26 18:35:19','2022-08-26 18:35:19',1,0,NULL,0,NULL,NULL,0,'01',0.00),(256,'customers','1','71099094','SAUCEDO RUIZ, BRAIN CHARLIE',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'JR. MESONES MURO 307',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-26 20:41:42','2022-08-26 20:41:42',1,0,NULL,0,NULL,NULL,0,'01',0.00),(257,'customers','1','44157935','DE LOS SANTOS ORDOÑEZ, ELIANA YUDITH',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'JR.MADRE DE DIOS C.01 BAGUA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-27 10:23:49','2022-08-27 10:23:49',1,0,NULL,0,NULL,NULL,0,'01',0.00),(258,'customers','0','99455','Clientes - 5656',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-27 21:29:58','2022-08-27 21:29:58',1,0,NULL,0,NULL,NULL,0,'01',0.00),(259,'customers','0','9956353','Clientes 565',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-27 21:30:51','2022-08-27 21:30:51',1,0,NULL,0,NULL,NULL,0,'01',0.00),(260,'customers','0','70890635','Clientes -7545',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-28 12:05:59','2022-08-28 12:05:59',1,0,NULL,0,NULL,NULL,0,'01',0.00),(261,'customers','0','9994542','Clientes - 556',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-28 12:08:34','2022-08-28 12:08:34',1,0,NULL,0,NULL,NULL,0,'01',0.00),(262,'customers','1','73873968','HERRERA CASTAÑEDA, ELIAS',NULL,NULL,NULL,'PE',NULL,'01','0107','010705',NULL,'CASERIO EL ASERRADERO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-29 16:58:51','2022-08-29 16:58:51',1,0,NULL,0,NULL,NULL,0,'01',0.00),(263,'customers','1','46942245','ZULUETA TOLENTINO, ADARLIT',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'JR.CERRO DE PASCO C-03',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-31 18:48:30','2022-08-31 18:48:30',1,0,NULL,0,NULL,NULL,0,'01',0.00),(264,'customers','0','95252','Clientes 52543',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-08-31 20:11:58','2022-08-31 20:11:58',1,0,NULL,0,NULL,NULL,0,'01',0.00),(265,'customers','0','999923','Clientes - 3',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-01 19:33:30','2022-09-01 19:33:30',1,0,NULL,0,NULL,NULL,0,'01',0.00),(266,'customers','0','99995633','Clientes - 56665456',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-01 19:33:47','2022-09-01 19:33:47',1,0,NULL,0,NULL,NULL,0,'01',0.00),(267,'customers','1','44856240','TOCTO RUEDA, JHON DEYER',NULL,NULL,NULL,'PE',NULL,'15','1501','150143',NULL,'AV. EL SOL 912 P.J CERCADO MZ. J9 LT. 5B',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-03 13:17:02','2022-09-03 13:17:02',1,0,NULL,0,NULL,NULL,0,'01',0.00),(268,'customers','1','42669166','TARRILLO ROJAS, ERIBERTO',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'AV. 28 DE JULIO 905',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-03 16:32:01','2022-09-03 16:32:01',1,0,NULL,0,NULL,NULL,0,'01',0.00),(269,'customers','0','995654','Clientes - 6566',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-05 21:06:10','2022-09-05 21:06:10',1,0,NULL,0,NULL,NULL,0,'01',0.00),(270,'customers','1','27420348','REQUEJO VASQUEZ, MARLENI',NULL,NULL,NULL,'PE',NULL,'06','0604','060401',NULL,'AV. INCA GARCILAZO DE LA VEGA 652',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-07 20:12:32','2022-09-07 20:12:32',1,0,NULL,0,NULL,NULL,0,'01',0.00),(271,'customers','1','74914378','CELIZ HUAMAN, ELZER',NULL,NULL,NULL,'PE',NULL,'01','0105','010508',NULL,'ANEXO SAN PABLO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-08 20:40:12','2022-09-08 20:40:12',1,0,NULL,0,NULL,NULL,0,'01',0.00),(272,'customers','1','43339230','GARCIA VASQUEZ, SAMUEL',NULL,NULL,NULL,'PE',NULL,'06','0609','060906',NULL,'CASERIO VILLA RICA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-09 11:18:12','2022-09-09 11:18:12',1,0,NULL,0,NULL,NULL,0,'01',0.00),(273,'customers','1','33588920','BALLE CARRASCO, SIMON',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'SECTOR EL HORNO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-09 18:33:50','2022-09-09 18:33:50',1,0,NULL,0,NULL,NULL,0,'01',0.00),(274,'customers','0','98966','Clientes - 561414',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-10 17:54:48','2022-09-10 17:54:48',1,0,NULL,0,NULL,NULL,0,'01',0.00),(275,'customers','0','532532','Clientes -545',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-12 19:33:23','2022-09-12 19:33:23',1,0,NULL,0,NULL,NULL,0,'01',0.00),(276,'customers','0','9999564','Clientes 5456',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-13 21:01:05','2022-09-13 21:01:05',1,0,NULL,0,NULL,NULL,0,'01',0.00),(277,'customers','1','33591952','GUERRERO NAUCA, PORFIRIO',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'GAMONAL 100 - LOS OLIVOS BAGUA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-14 21:13:41','2022-09-14 21:13:41',1,0,NULL,0,NULL,NULL,0,'01',0.00),(278,'customers','0','9994546','Clientes - 56356',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-15 19:30:09','2022-09-15 19:30:09',1,0,NULL,0,NULL,NULL,0,'01',0.00),(279,'customers','6','10744675478','SANTOS SANTOS SOLIS HEYNER',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,'HABIDO','ACTIVO',NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-17 20:20:08','2022-09-17 20:20:08',1,0,NULL,0,NULL,NULL,0,'01',0.00),(280,'customers','0','9991324','Clientes - 43534',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-17 21:06:54','2022-09-17 21:06:54',1,0,NULL,0,NULL,NULL,0,'01',0.00),(281,'customers','1','75557185','GARCIA OJEDA, MARIO ALEX',NULL,NULL,NULL,'PE',NULL,'06','0609','060901',NULL,'CAS FRANCISCO BOLOGNESI',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-19 10:52:59','2022-09-19 10:52:59',1,0,NULL,0,NULL,NULL,0,'01',0.00),(282,'customers','1','44607990','ARQUIMEDES CARMONA, SUSAN LYNN SYBILA',NULL,NULL,NULL,'PE',NULL,'15','1501','150108',NULL,'CALLE LAS ANTARAS 255 INT. D URB SAN JUAN BAUTISTA DE VILLA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-19 11:38:10','2022-09-19 11:38:10',1,0,NULL,0,NULL,NULL,0,'01',0.00),(283,'customers','0','567366','Clientes - 4567336',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-19 21:10:28','2022-09-19 21:10:28',1,0,NULL,0,NULL,NULL,0,'01',0.00),(284,'customers','0','16206','MUNICIPIO ESCOLAR DE LA I.E. N 16206',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-19 21:19:14','2022-09-19 21:19:14',1,0,NULL,0,NULL,NULL,0,'01',0.00),(285,'customers','1','40762024','ANTINORI REQUEJO, LILI MIRIAM',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'JR.29 DE AGOSTO 330',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-19 21:21:30','2022-09-19 21:21:30',1,0,NULL,0,NULL,NULL,0,'01',0.00),(286,'customers','1','33566785','RODRIGO TAMAYA, MARIA ISABEL',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'HEROES DEL CENEPA C-1',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-20 10:40:36','2022-09-20 10:40:36',1,0,NULL,0,NULL,NULL,0,'01',0.00),(287,'customers','0','5885','Clientes - 7676',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-20 18:26:16','2022-09-20 18:26:16',1,0,NULL,0,NULL,NULL,0,'01',0.00),(288,'customers','1','44515175','NAIRA PEÑA, JORGE LUIS',NULL,NULL,NULL,'PE',NULL,'06','0609','060901',NULL,'CASERIO SAN ANTONIO DE LA BALSA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-21 16:03:28','2022-09-21 16:03:28',1,0,NULL,0,NULL,NULL,0,'01',0.00),(289,'customers','1','48001382','VILCHEZ CELIS, EDIL',NULL,NULL,NULL,'PE',NULL,'06','0608','060801',NULL,'CALLE IQUITOS 1664 SEC. PUEBLO NUEVO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-21 17:10:56','2022-09-21 17:10:56',1,0,NULL,0,NULL,NULL,0,'01',0.00),(290,'customers','0','995363','Clientes -56466',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-21 17:22:04','2022-09-21 17:22:04',1,0,NULL,0,NULL,NULL,0,'01',0.00),(291,'customers','0','9999456','Clientes - 646',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-22 21:14:58','2022-09-22 21:14:58',1,0,NULL,0,NULL,NULL,0,'01',0.00),(292,'customers','1','46508535','CAMACHO CHINCHAY, LUZMERI',NULL,NULL,NULL,'PE',NULL,'06','0609','060906',NULL,'CAS.PEDREGAL',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-23 11:02:53','2022-09-23 11:02:53',1,0,NULL,0,NULL,NULL,0,'01',0.00),(293,'customers','1','74472350','SANTA CRUZ ROJAS, EDILBRANDO',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'JR. ICA 300',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-24 15:52:26','2022-09-24 15:52:26',1,0,NULL,0,NULL,NULL,0,'01',0.00),(294,'customers','1','09803945','KININ INCHIPISH, EDILBERTO',NULL,NULL,NULL,'PE',NULL,'01','0102','010205',NULL,'CALLE TIWIENTSA S/N C.POBLADO CHIRIACO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-24 18:39:54','2022-09-24 18:39:54',1,0,NULL,0,NULL,NULL,0,'01',0.00),(295,'customers','1','61946399','GARCIA DIAZ, FRANKLIN OMAR',NULL,NULL,NULL,'PE',NULL,'06','0609','060906',NULL,'CAS VILLARICA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-24 19:22:49','2022-09-24 19:22:49',1,0,NULL,0,NULL,NULL,0,'01',0.00),(296,'customers','0','999945253','Clien525432',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-25 13:27:50','2022-09-25 13:27:50',1,0,NULL,0,NULL,NULL,0,'01',0.00),(297,'customers','1','25853086','HUAMAN PEÑA, HAYDEE',NULL,NULL,NULL,'PE',NULL,'06','0609','060901',NULL,'JR. MARIANO MELGAR 110',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-26 15:15:03','2022-09-26 15:15:03',1,0,NULL,0,NULL,NULL,0,'01',0.00),(298,'customers','0','546546','Clientes 6546',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-28 20:52:31','2022-09-28 20:52:31',1,0,NULL,0,NULL,NULL,0,'01',0.00),(299,'customers','0','5365454','Clientes - 565',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-29 20:09:35','2022-09-29 20:09:35',1,0,NULL,0,NULL,NULL,0,'01',0.00),(300,'customers','1','77495694','TIMIAS BIKAYU, JHACK',NULL,NULL,NULL,'PE',NULL,'15','1501','150115',NULL,'SECTOR 4 LT. 22',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-09-30 18:50:20','2022-09-30 18:50:20',1,0,NULL,0,NULL,NULL,0,'01',0.00),(301,'customers','6','20602056750','CENTRO MEDICO ESPECIALIZADO Y SALUD OCUPACIONAL SR. DE LOS MILAGROS EPS EIRL',NULL,NULL,NULL,'PE',NULL,'16','1602','160201',NULL,'PROGRESO NRO. 322','HABIDO','ACTIVO',NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-01 21:07:44','2022-10-01 21:07:44',1,0,NULL,0,NULL,NULL,0,'01',0.00),(302,'customers','1','41432065','DAVILA GRANADOS, JOSE WETHLER',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'JR. TACNA 750',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-02 10:48:49','2022-10-02 10:48:49',1,0,NULL,0,NULL,NULL,0,'01',0.00),(303,'customers','1','77432278','PUJUPAT PAATI, FRANCO BRAULIO',NULL,NULL,NULL,'PE',NULL,'01','0102','010205',NULL,'COMUNID.NATIVA KUSU KUNCHIN',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-03 17:47:14','2022-10-03 17:47:14',1,0,NULL,0,NULL,NULL,0,'01',0.00),(304,'customers','1','43554064','GARCIA OJEDA, AMPARITO MELINA',NULL,NULL,NULL,'PE',NULL,'06','0609','060901',NULL,'CASERIO FRANCISCO BOLOGNESI',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-05 14:47:37','2022-10-05 14:47:37',1,0,NULL,0,NULL,NULL,0,'01',0.00),(305,'customers','1','46442725','PEÑA QUINDE, ISMAEL',NULL,NULL,NULL,'PE',NULL,'15','1501','150134',NULL,'AV. DE LA ROSA TORO 618',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-06 18:33:43','2022-10-06 18:33:43',1,0,NULL,0,NULL,NULL,0,'01',0.00),(306,'customers','1','27834514','TOCTO ABAD, FAUSTINA',NULL,NULL,NULL,'PE',NULL,'06','0609','060901',NULL,'CASERIO BARRIO NUEVO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-07 10:02:44','2022-10-07 10:02:44',1,0,NULL,0,NULL,NULL,0,'01',0.00),(307,'customers','0','422','Clientes 5466',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-07 16:03:04','2022-10-07 16:03:04',1,0,NULL,0,NULL,NULL,0,'01',0.00),(308,'customers','0','999995','Clientes - V542',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-07 16:07:04','2022-10-07 16:07:04',1,0,NULL,0,NULL,NULL,0,'01',0.00),(309,'customers','0','99995536','Clientes - 633',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-08 19:16:57','2022-10-08 19:16:57',1,0,NULL,0,NULL,NULL,0,'01',0.00),(310,'customers','0','999945646','Clientes - 896876',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-08 19:20:21','2022-10-08 19:20:21',1,0,NULL,0,NULL,NULL,0,'01',0.00),(311,'customers','0','354353','Clientes - 6363',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-08 21:21:39','2022-10-08 21:21:39',1,0,NULL,0,NULL,NULL,0,'01',0.00),(312,'customers','1','40560617','QUIROZ PEREZ, ENMA MARIELA',NULL,NULL,NULL,'PE',NULL,'01','0102','010201',NULL,'CIRCUNVALACION 235',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-11 19:52:50','2022-10-11 19:52:50',1,0,NULL,0,NULL,NULL,0,'01',0.00),(313,'customers','0','5343','Clientes - 5633',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-11 19:54:34','2022-10-11 19:54:34',1,0,NULL,0,NULL,NULL,0,'01',0.00),(314,'customers','0','666654','Clientes - 6898',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-12 20:17:19','2022-10-12 20:17:19',1,0,NULL,0,NULL,NULL,0,'01',0.00),(315,'customers','0','99999456','Clientes - 566',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-12 20:20:47','2022-10-12 20:20:47',1,0,NULL,0,NULL,NULL,0,'01',0.00),(316,'customers','1','27745236','CORDOVA MARTINEZ, DANILO ISABEL',NULL,NULL,NULL,'PE',NULL,'06','0608','060801',NULL,'CALLE HUAMANTANGA 2021',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-13 13:18:07','2022-10-13 13:18:07',1,0,NULL,0,NULL,NULL,0,'01',0.00),(317,'customers','0','6','VENTAS DEL DÍA',NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-14 21:03:22','2022-10-14 21:03:22',1,0,NULL,0,NULL,NULL,0,'01',0.00),(318,'customers','1','48582812','ZURITA HERRERA, MARIA LISAURA',NULL,NULL,NULL,'PE','PE','06','0609','060901',NULL,'CAS. UNION LAS MERCEDES',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-15 11:30:29','2022-10-15 11:30:29',1,0,NULL,0,NULL,NULL,0,'01',0.00),(319,'customers','1','75582368','CORDOVA MEGO, JHORLY ANTHONY',NULL,NULL,NULL,'PE','PE','06','0609','060901',NULL,'CAS NUEVO ORIENTE',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-15 12:31:13','2022-10-15 12:31:13',1,0,NULL,0,NULL,NULL,0,'01',0.00),(320,'customers','1','48919971','REYES RIVERA, MARLENY',NULL,NULL,NULL,'PE','PE','06','0609','060906',NULL,'CAS. FAIQUE',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-16 10:18:08','2022-10-16 10:18:08',1,0,NULL,0,NULL,NULL,0,'01',0.00),(321,'customers','1','71053400','YANAYACO CUNYA, GLADYS',NULL,NULL,NULL,'PE','PE','06','0609','060906',NULL,'CASERIO EL FAIQUE',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-16 12:18:42','2022-10-16 12:18:42',1,0,NULL,0,NULL,NULL,0,'01',0.00),(322,'customers','1','44163723','RUIZ GARCIA, MANUEL',NULL,NULL,NULL,'PE','PE','06','0609','060901',NULL,'CAS UNION LAS MERCEDES',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-17 08:42:44','2022-10-17 08:42:44',1,0,NULL,0,NULL,NULL,0,'01',0.00),(323,'customers','1','33568336','MERINO BANCES, FERNANDO EDGAR',NULL,NULL,NULL,'PE','PE','01','0102','010201',NULL,'LAS JUNTAS C-3',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-22 17:03:48','2022-10-22 17:03:48',1,0,NULL,0,NULL,NULL,0,'01',0.00),(324,'customers','0','51456456456','Clientes154545454',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-22 17:26:19','2022-10-22 17:26:19',1,0,NULL,0,NULL,NULL,0,'01',0.00),(325,'customers','0','1224','Clientes1224',NULL,NULL,NULL,'PE','PE','01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,1,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-22 17:35:40','2022-10-22 17:35:40',1,0,NULL,0,NULL,NULL,0,'01',0.00),(326,'customers','0','15614','Clientes - 162561',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-22 21:06:56','2022-10-22 21:06:56',1,0,NULL,0,NULL,NULL,0,'01',0.00),(327,'customers','1','43080942','SANCHEZ BERNAL, GIULIANA LISSET',NULL,NULL,NULL,'PE','PE','14','1401','140117',NULL,'CALLE MANUEL ANTONIO MESONES MURO 0061 C.POBLADO POSOPE ALTO MZ. 58 LT. 0006',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-23 12:37:35','2022-10-23 12:37:35',1,0,NULL,0,NULL,NULL,0,'01',0.00),(328,'customers','1','41518429','CAJUSOL ZEÑA, MARIA NATIVIDAD',NULL,NULL,NULL,'PE','PE','01','0102','010206',NULL,'JR. PROGRESO 00S/N',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-24 14:29:02','2022-10-24 14:29:02',1,0,NULL,0,NULL,NULL,0,'01',0.00),(329,'customers','0','99999879','Clientes6655',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-26 19:01:38','2022-10-26 19:01:38',1,0,NULL,0,NULL,NULL,0,'01',0.00),(330,'customers','1','33583396','CUBAS DE GOMEZ, MARIA AMALIA',NULL,NULL,NULL,'PE','PE','01','0102','010206',NULL,'CPM.LA PECA Z1 AV.CHACHAPOYAS 318',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-27 10:15:52','2022-10-27 10:15:52',1,0,NULL,0,NULL,NULL,0,'01',0.00),(331,'customers','1','26600306','SILVA DIAZ, FREDY JAIME',NULL,NULL,NULL,'PE','PE','06','0601','060101',NULL,'CALLE EL CAPULI A-8 URB. SAN ROQUE',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-27 12:35:05','2022-10-27 12:35:05',1,0,NULL,0,NULL,NULL,0,'01',0.00),(332,'customers','1','77870313','PERLECHE IZQUIERDO, JIMMY ALIM',NULL,NULL,NULL,'PE','PE','01','0102','010201',NULL,'AV. MARIANO MELGAR 300',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-27 21:21:24','2022-10-27 21:21:24',1,0,NULL,0,NULL,NULL,0,'01',0.00),(333,'customers','1','71895023','GUERRERO PEÑA, RENZO VLADIMIR',NULL,NULL,NULL,'PE','PE','06','0609','060905',NULL,'CASERIO LA UNION',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-28 18:05:49','2022-10-28 18:05:49',1,0,NULL,0,NULL,NULL,0,'01',0.00),(334,'customers','1','42853317','CUBAS GARCIA, MARLENY DEL PILAR',NULL,NULL,NULL,'PE','PE','06','0609','060901',NULL,'CAS. CAMPANA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-29 11:42:35','2022-10-29 11:42:35',1,0,NULL,0,NULL,NULL,0,'01',0.00),(335,'customers','1','42740777','LIVIA PEÑA, LUCINDA',NULL,NULL,NULL,'PE','PE','15','1501','150137',NULL,'MZ K LT 12 URB. LOS PRODUCTORES',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-29 12:31:28','2022-10-29 12:31:28',1,0,NULL,0,NULL,NULL,0,'01',0.00),(336,'customers','0','999965654','Clientes 566',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-29 19:42:50','2022-10-29 19:42:50',1,0,NULL,0,NULL,NULL,0,'01',0.00),(337,'customers','1','72646079','ROJAS COLLANTES, LOLA',NULL,'54656',NULL,'PE','PE','01','0102','010201',NULL,'JR.ICA 300',NULL,NULL,NULL,NULL,0.00,0,1,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-30 12:58:32','2022-10-30 12:58:32',1,0,NULL,0,NULL,NULL,0,'01',0.00),(338,'customers','0','999235454','Clientes - 54656',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-31 20:39:25','2022-10-31 20:39:25',1,0,NULL,0,NULL,NULL,0,'01',0.00),(339,'customers','0','99999536','Clientes - 5636',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-10-31 20:41:12','2022-10-31 20:41:12',1,0,NULL,0,NULL,NULL,0,'01',0.00),(340,'customers','0','99995666','Clientes 6989',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-02 19:42:06','2022-11-02 19:42:06',1,0,NULL,0,NULL,NULL,0,'01',0.00),(341,'customers','0','5466','Clientes 6346',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-04 21:06:23','2022-11-04 21:06:23',1,0,NULL,0,NULL,NULL,0,'01',0.00),(342,'customers','0','99995663','Clientes - 676',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-04 21:09:24','2022-11-04 21:09:24',1,0,NULL,0,NULL,NULL,0,'01',0.00),(343,'customers','1','77354901','DEKENTAI CHUIN, ELZER',NULL,NULL,NULL,'PE','PE','01','0102','010205',NULL,'C.N.NUMPATKAIM',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-05 12:26:59','2022-11-05 12:26:59',1,0,NULL,0,NULL,NULL,0,'01',0.00),(344,'customers','0','9998999','Clientes - 899',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-05 20:45:03','2022-11-05 20:45:03',1,0,NULL,0,NULL,NULL,0,'01',0.00),(345,'customers','0','999956','Clientes - 66',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-07 21:12:01','2022-11-07 21:12:01',1,0,NULL,0,NULL,NULL,0,'01',0.00),(346,'customers','0','995656876','Clientes -876876',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-10 18:44:45','2022-11-10 18:44:45',1,0,NULL,0,NULL,NULL,0,'01',0.00),(347,'customers','1','73209205','MEDINA FERNANDEZ, MARIA ARACELI',NULL,NULL,NULL,'PE','PE','06','0609','060903',NULL,'C.POBLADO HUARANDOZA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-11 16:50:22','2022-11-11 16:50:22',1,0,NULL,0,NULL,NULL,0,'01',0.00),(348,'customers','0','5635466','Clientes 5614',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-11 20:06:33','2022-11-11 20:06:33',1,0,NULL,0,NULL,NULL,0,'01',0.00),(349,'customers','0','999956255','Clientes 652',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-13 13:09:15','2022-11-13 13:09:15',1,0,NULL,0,NULL,NULL,0,'01',0.00),(350,'customers','0','999999356656','Clientes 32131',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-14 21:41:58','2022-11-14 21:41:58',1,0,NULL,0,NULL,NULL,0,'01',0.00),(351,'customers','1','79349458','BUSTAMANTE VENTURA, FERNANDO SAMUEL',NULL,NULL,NULL,'PE','PE','01','0102','010201',NULL,'JR. LAMBAYEQUE 620',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-17 19:23:56','2022-11-17 19:23:56',1,0,NULL,0,NULL,NULL,0,'01',0.00),(352,'customers','1','75841114','TOCTO LIZANA, MARILEYSI',NULL,NULL,NULL,'PE','PE','06','0609','060901',NULL,'CAS. CHAMANAL',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-18 16:04:28','2022-11-18 16:04:28',1,0,NULL,0,NULL,NULL,0,'01',0.00),(353,'customers','0','9995456','Clientes 4866',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-18 20:15:30','2022-11-18 20:15:30',1,0,NULL,0,NULL,NULL,0,'01',0.00),(354,'customers','0','999999565','Clientes 54636',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-21 21:01:28','2022-11-21 21:01:28',1,0,NULL,0,NULL,NULL,0,'01',0.00),(355,'customers','0','99912546','Clientes 64656',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-22 21:08:03','2022-11-22 21:08:03',1,0,NULL,0,NULL,NULL,0,'01',0.00),(356,'customers','0','99953646','Clientes - 56546',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-23 21:29:32','2022-11-23 21:29:32',1,0,NULL,0,NULL,NULL,0,'01',0.00),(357,'customers','0','99995656','Clientes5645',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-25 20:55:18','2022-11-25 20:55:18',1,0,NULL,0,NULL,NULL,0,'01',0.00),(358,'customers','0','9999546456','Clientes5646',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-26 20:15:45','2022-11-26 20:15:45',1,0,NULL,0,NULL,NULL,0,'01',0.00),(359,'customers','0','99995654','Clientes - 45646',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-27 22:27:46','2022-11-27 22:27:46',1,0,NULL,0,NULL,NULL,0,'01',0.00),(360,'customers','0','9999564546','Clientes 56654654',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-27 22:29:07','2022-11-27 22:29:07',1,0,NULL,0,NULL,NULL,0,'01',0.00),(361,'customers','0','99995676','Clientes 56656',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-28 18:04:40','2022-11-28 18:04:40',1,0,NULL,0,NULL,NULL,0,'01',0.00),(362,'customers','0','9999255','Clientes 5353',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-28 18:06:54','2022-11-28 18:06:54',1,0,NULL,0,NULL,NULL,0,'01',0.00),(363,'customers','0','99546','Clientes646',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-11-29 12:15:47','2022-11-29 12:15:47',1,0,NULL,0,NULL,NULL,0,'01',0.00),(364,'customers','0','999023262','Clientes 898989',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-12-01 20:49:37','2022-12-01 20:49:37',1,0,NULL,0,NULL,NULL,0,'01',0.00),(365,'customers','0','999956456','Clientes 546454',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-12-05 21:20:45','2022-12-05 21:20:45',1,0,NULL,0,NULL,NULL,0,'01',0.00),(366,'customers','1','70769800','RETETE CRUZ, IRENE FATIMA',NULL,NULL,NULL,'PE','PE','15','1501','150108',NULL,'PSJ. ELENA FRAY DE PASTOR 64 VILLA MILITAR OESTE',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-12-07 12:19:12','2022-12-07 12:19:12',1,0,NULL,0,NULL,NULL,0,'01',0.00),(367,'customers','1','75314090','BARRANZUELA DELGADO, JEANPEARE',NULL,NULL,NULL,'PE','PE','01','0102','010201',NULL,'JR. AYACUCHO 1236',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-12-07 19:39:51','2022-12-07 19:39:51',1,0,NULL,0,NULL,NULL,0,'01',0.00),(368,'customers','0','6767686','Clientes - 686788',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-12-07 19:44:12','2022-12-07 19:44:12',1,0,NULL,0,NULL,NULL,0,'01',0.00),(369,'customers','0','99786868','Clientes - 8586',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-12-08 18:34:24','2022-12-08 18:34:24',1,0,NULL,0,NULL,NULL,0,'01',0.00),(370,'customers','0','99999525','Clientes 54656',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-12-08 18:40:31','2022-12-08 18:40:31',1,0,NULL,0,NULL,NULL,0,'01',0.00),(371,'customers','1','44026924','ANJIS SUAMUT, JUAN JOSE',NULL,NULL,NULL,'PE','PE','01','0104','010401',NULL,'COMUNIDAD NATIVA DE NAPURUKA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-12-09 18:32:43','2022-12-09 18:32:43',1,0,NULL,0,NULL,NULL,0,'01',0.00),(372,'customers','0','9999954454','Clientes 546689689',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-12-10 20:40:00','2022-12-10 20:40:00',1,0,NULL,0,NULL,NULL,0,'01',0.00),(373,'customers','1','47425315','CRUZ GARCIA, OSWALDO',NULL,NULL,NULL,'PE','PE','06','0609','060901',NULL,'CASERIO UNION LAS MERCEDES',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-12-11 12:14:37','2022-12-11 12:14:37',1,0,NULL,0,NULL,NULL,0,'01',0.00),(374,'customers','1','41521950','MULATILLO GIRON, MIGUEL SERBULO',NULL,NULL,NULL,'PE','PE','06','0609','060901',NULL,'CASERIO SEÑOR CAUTIVO',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-12-12 10:08:43','2022-12-12 10:08:43',1,0,NULL,0,NULL,NULL,0,'01',0.00),(375,'customers','0','999546569','Clientes 5654656',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-12-12 20:34:11','2022-12-12 20:34:11',1,0,NULL,0,NULL,NULL,0,'01',0.00),(376,'customers','0','9999868','Clientes 965668',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-12-13 17:16:41','2022-12-13 17:16:41',1,0,NULL,0,NULL,NULL,0,'01',0.00),(377,'customers','1','72961258','CORDOVA RAMIREZ, YANELI',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-12-14 11:23:17','2022-12-14 11:23:17',1,0,NULL,0,NULL,NULL,0,'01',0.00),(378,'customers','0','35433','Clientes 54354343',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-12-14 21:05:04','2022-12-14 21:05:04',1,0,NULL,0,NULL,NULL,0,'01',0.00),(379,'customers','0','5466545','Clientes543654363',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-12-15 12:53:45','2022-12-15 12:53:45',1,0,NULL,0,NULL,NULL,0,'01',0.00),(380,'customers','0','999955463','Clientes 5566',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-12-19 21:19:35','2022-12-19 21:19:35',1,0,NULL,0,NULL,NULL,0,'01',0.00),(381,'customers','0','9999566464','Clientes 64646',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-12-21 21:08:02','2022-12-21 21:08:02',1,0,NULL,0,NULL,NULL,0,'01',0.00),(382,'customers','0','999995466','Clientes 66666',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-12-22 21:19:12','2022-12-22 21:19:12',1,0,NULL,0,NULL,NULL,0,'01',0.00),(383,'customers','0','898499','Clientes54685464',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-12-28 20:20:57','2022-12-28 20:20:57',1,0,NULL,0,NULL,NULL,0,'01',0.00),(384,'customers','0','9999896','Clientes9789',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2022-12-29 21:08:59','2022-12-29 21:08:59',1,0,NULL,0,NULL,NULL,0,'01',0.00),(385,'customers','0','999543254354','Clientes - 67676',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-01-04 21:44:20','2023-01-04 21:44:20',1,0,NULL,0,NULL,NULL,0,'01',0.00),(386,'customers','0','99954656','Clientes 5666',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-01-05 21:25:14','2023-01-05 21:25:14',1,0,NULL,0,NULL,NULL,0,'01',0.00),(387,'customers','0','93535353535357','Clientes 786868',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-01-17 21:36:16','2023-01-17 21:36:16',1,0,NULL,0,NULL,NULL,0,'01',0.00),(388,'customers','0','9999564545','Clientes5656',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-01-18 21:40:35','2023-01-18 21:40:35',1,0,NULL,0,NULL,NULL,0,'01',0.00),(389,'customers','1','72926347','CORREA CORDOVA, HAROLD MARTIN',NULL,NULL,NULL,'PE','PE','01','0102','010201',NULL,'PSJ. LOS OLIVOS 174',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-01-19 11:42:56','2023-01-19 11:42:56',1,0,NULL,0,NULL,NULL,0,'01',0.00),(390,'customers','0','999565469','Clientes 643',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-01-20 19:36:24','2023-01-20 19:36:24',1,0,NULL,0,NULL,NULL,0,'01',0.00),(391,'customers','0','99921456','Clientes 46445656',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-01-21 17:42:52','2023-01-21 17:42:52',1,0,NULL,0,NULL,NULL,0,'01',0.00),(392,'customers','0','99956','Clientes54666',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-01-21 17:44:19','2023-01-21 17:44:19',1,0,NULL,0,NULL,NULL,0,'01',0.00),(393,'customers','0','45646','Clientes 3654674',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-01-21 17:45:09','2023-01-21 17:45:09',1,0,NULL,0,NULL,NULL,0,'01',0.00),(394,'customers','0','99995546545','Clientes 588656',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-01-21 21:20:16','2023-01-21 21:20:16',1,0,NULL,0,NULL,NULL,0,'01',0.00),(395,'customers','1','42467566','CORONEL LOZANO, CLARIBEL DEL ROCIO',NULL,NULL,NULL,'PE','PE','01','0107','010704',NULL,'CP JOROBAMBA',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-01-23 13:18:12','2023-01-23 13:18:12',1,0,NULL,0,NULL,NULL,0,'01',0.00),(396,'customers','0','9994566','Clientes 453656',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-01-23 19:49:09','2023-01-23 19:49:09',1,0,NULL,0,NULL,NULL,0,'01',0.00),(397,'customers','0','62728906','ROGER ERICK,GARCIA OGEDA',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-01-24 12:46:34','2023-01-24 12:46:34',1,0,NULL,0,NULL,NULL,0,'01',0.00),(398,'customers','6','20602869459','SERVICIOS EMPRESARIALES VOLTIOS S.A.C.',NULL,NULL,NULL,'PE','PE','06','0604','060401',NULL,'CAL. NUEVA SANTA ROSA NRO. 194','HABIDO','ACTIVO',NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-01-25 08:27:24','2023-01-25 08:27:24',1,0,NULL,0,NULL,NULL,0,'01',0.00),(399,'customers','0','99945343','Clientes 566666645',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-01-25 20:09:20','2023-01-25 20:09:20',1,0,NULL,0,NULL,NULL,0,'01',0.00),(400,'customers','0','93332121','Clientes 321233',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-01-26 20:56:51','2023-01-26 20:56:51',1,0,NULL,0,NULL,NULL,0,'01',0.00),(401,'customers','0','99995645646','Clientes54646464',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-01-28 20:26:33','2023-01-28 20:26:33',1,0,NULL,0,NULL,NULL,0,'01',0.00),(402,'customers','0','99353655','Clientes3653',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-01-30 14:38:06','2023-01-30 14:38:06',1,0,NULL,0,NULL,NULL,0,'01',0.00),(403,'customers','0','9999566666','Clientes 666666',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-01 20:45:06','2023-02-01 20:45:06',1,0,NULL,0,NULL,NULL,0,'01',0.00),(404,'customers','6','10726718283','QUIROZ AMPUERO RODNEY DANIEL',NULL,NULL,NULL,'PE','PE','01','0102','010206',NULL,'JR. CUZCO NRO. 186','HABIDO','ACTIVO',NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-02 11:13:27','2023-02-02 11:13:27',1,0,NULL,0,NULL,NULL,0,'01',0.00),(405,'customers','0','9935454545','Clientes 5454566654',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-02 18:52:29','2023-02-02 18:52:29',1,0,NULL,0,NULL,NULL,0,'01',0.00),(406,'customers','0','9999935435433','Clientes 54354356',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-03 19:46:10','2023-02-03 19:46:10',1,0,NULL,0,NULL,NULL,0,'01',0.00),(407,'customers','0','99925454656','Clientes 54645454',NULL,NULL,NULL,'PE','PE','01','0102','010201',NULL,'JR. AMAZONAS 506',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-03 19:47:12','2023-02-03 19:47:12',1,0,NULL,0,NULL,NULL,0,'01',0.00),(408,'customers','0','878877','LEODAN,ALBERCA NEIRA',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-07 18:35:00','2023-02-07 18:35:00',1,0,NULL,0,NULL,NULL,0,'01',0.00),(409,'customers','0','999565','Clientes 565656',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-10 12:03:27','2023-02-10 12:03:27',1,0,NULL,0,NULL,NULL,0,'01',0.00),(410,'customers','0','99942542553','Clientes 56*',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-10 19:23:35','2023-02-10 19:23:35',1,0,NULL,0,NULL,NULL,0,'01',0.00),(411,'customers','0','999996666','Clientes664654456',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-11 20:32:31','2023-02-11 20:32:31',1,0,NULL,0,NULL,NULL,0,'01',0.00),(412,'customers','1','46564348','PEJERREY ROJAS, CYNTHYA ISABEL',NULL,NULL,NULL,'PE','PE','14','1401','140107',NULL,'CALLE CALLAO 551 CERCADO MOCUPE',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-12 13:10:38','2023-02-12 13:10:38',1,0,NULL,0,NULL,NULL,0,'01',0.00),(413,'customers','0','0000925','Clientes - 925',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-13 10:12:02','2023-02-13 10:12:02',1,0,NULL,0,NULL,NULL,0,'01',0.00),(414,'customers','0','9999545645','Clientes 5465465464',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-14 21:09:12','2023-02-14 21:09:12',1,0,NULL,0,NULL,NULL,0,'01',0.00),(415,'customers','1','76288589','JIMENEZ GUERRERO, EDWIN ELIAS',NULL,NULL,NULL,'PE','PE','01','0102','010202',NULL,'CASERIO BUENOS AIRES',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-15 10:23:15','2023-02-15 10:23:15',1,0,NULL,0,NULL,NULL,0,'01',0.00),(416,'customers','0','9993563','Clientes6566',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-15 10:26:03','2023-02-15 10:26:03',1,0,NULL,0,NULL,NULL,0,'01',0.00),(417,'customers','0','99943543','Clientes 434334',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-15 17:40:49','2023-02-15 17:40:49',1,0,NULL,0,NULL,NULL,0,'01',0.00),(418,'customers','0','996363','Clientes 65566654',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-17 20:47:22','2023-02-17 20:47:22',1,0,NULL,0,NULL,NULL,0,'01',0.00),(419,'customers','1','61804746','TORRES DE LA CRUZ, HANNY MARILUZ',NULL,NULL,NULL,'PE','PE','14','1402','140201',NULL,'CL. HECTOR AURICH SOTO 537',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-18 11:03:55','2023-02-18 11:03:55',1,0,NULL,0,NULL,NULL,0,'01',0.00),(420,'customers','0','99999122243','Clientes 34356433',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-18 21:00:04','2023-02-18 21:00:04',1,0,NULL,0,NULL,NULL,0,'01',0.00),(421,'customers','0','99954456','Clientes 644644',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-20 21:05:55','2023-02-20 21:05:55',1,0,NULL,0,NULL,NULL,0,'01',0.00),(422,'customers','1','46637467','HUAMAN MACHUCA, MARIA YSABEL',NULL,NULL,NULL,'PE','PE','01','0102','010201',NULL,'CALLE A S/N SECTOR TOMAQUE',NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-21 11:23:38','2023-02-21 11:23:38',1,0,NULL,0,NULL,NULL,0,'01',0.00),(423,'customers','0','999999956569','Clientes 565566',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-22 19:20:31','2023-02-22 19:20:31',1,0,NULL,0,NULL,NULL,0,'01',0.00),(424,'customers','0','9995535433','Clientes 4',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-23 19:46:55','2023-02-23 19:46:55',1,0,NULL,0,NULL,NULL,0,'01',0.00),(425,'customers','0','99994525435','Clientes 56354343',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-25 21:06:36','2023-02-25 21:06:36',1,0,NULL,0,NULL,NULL,0,'01',0.00),(426,'customers','0','999963564','Clientes 6566565',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-27 20:27:03','2023-02-27 20:27:03',1,0,NULL,0,NULL,NULL,0,'01',0.00),(427,'customers','0','999645','Clientes6456546',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-28 14:48:22','2023-02-28 14:48:22',1,0,NULL,0,NULL,NULL,0,'01',0.00),(428,'customers','0','9963536','Clientes 56566525',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-02-28 20:34:04','2023-02-28 20:34:04',1,0,NULL,0,NULL,NULL,0,'01',0.00),(429,'customers','0','9945646456','Clientes56456464',NULL,NULL,NULL,'PE','PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2023-03-01 20:56:25','2023-03-01 20:56:25',1,0,NULL,0,NULL,NULL,0,'01',0.00);

--
-- Table structure for table `preprinted_format_templates`
--

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

--
-- Dumping data for table `preprinted_format_templates`
--


--
-- Table structure for table `production`
--

CREATE TABLE `production` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned DEFAULT 0,
  `soap_type_id` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_id` int(10) unsigned DEFAULT 0,
  `inventory_id_reference` int(10) unsigned DEFAULT NULL,
  `quantity` decimal(12,4) DEFAULT 0.0000 COMMENT 'Peso dle insumo ',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `machine_id` int(10) unsigned NOT NULL DEFAULT 0,
  `production_order` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_start` date DEFAULT NULL,
  `time_start` time DEFAULT NULL,
  `date_end` date DEFAULT NULL,
  `time_end` time DEFAULT NULL,
  `lot_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_extra_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`item_extra_data`)),
  `mix_date_start` date DEFAULT NULL,
  `mix_time_start` time DEFAULT NULL,
  `mix_date_end` date DEFAULT NULL,
  `mix_time_end` time DEFAULT NULL,
  `informative` tinyint(3) unsigned DEFAULT 0,
  `agreed` decimal(8,2) DEFAULT 0.00,
  `imperfect` decimal(8,2) DEFAULT 0.00,
  `proccess_type` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `production_collaborator` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mix_collaborator` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `production_soap_type_id_foreign` (`soap_type_id`),
  CONSTRAINT `production_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `production`
--


--
-- Table structure for table `promotions`
--

CREATE TABLE `promotions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `item_id` int(10) unsigned NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `apply_restaurant` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `promotions_item_id_foreign` (`item_id`),
  CONSTRAINT `promotions_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `promotions`
--


--
-- Table structure for table `provinces`
--

CREATE TABLE `provinces` (
  `id` char(4) COLLATE utf8mb4_unicode_ci NOT NULL,
  `department_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 `provinces_department_id_foreign` (`department_id`),
  KEY `provinces_id_index` (`id`),
  CONSTRAINT `provinces_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `provinces`
--

INSERT INTO `provinces` VALUES ('0101','01','Chachapoyas',1),('0102','01','Bagua',1),('0103','01','Bongará',1),('0104','01','Condorcanqui',1),('0105','01','Luya',1),('0106','01','Rodríguez de Mendoza',1),('0107','01','Utcubamba',1),('0201','02','Huaraz',1),('0202','02','Aija',1),('0203','02','Antonio Raymondi',1),('0204','02','Asunción',1),('0205','02','Bolognesi',1),('0206','02','Carhuaz',1),('0207','02','Carlos Fermín Fitzcarrald',1),('0208','02','Casma',1),('0209','02','Corongo',1),('0210','02','Huari',1),('0211','02','Huarmey',1),('0212','02','Huaylas',1),('0213','02','Mariscal Luzuriaga',1),('0214','02','Ocros',1),('0215','02','Pallasca',1),('0216','02','Pomabamba',1),('0217','02','Recuay',1),('0218','02','Santa',1),('0219','02','Sihuas',1),('0220','02','Yungay',1),('0301','03','Abancay',1),('0302','03','Andahuaylas',1),('0303','03','Antabamba',1),('0304','03','Aymaraes',1),('0305','03','Cotabambas',1),('0306','03','Chincheros',1),('0307','03','Grau',1),('0401','04','Arequipa',1),('0402','04','Camaná',1),('0403','04','Caravelí',1),('0404','04','Castilla',1),('0405','04','Caylloma',1),('0406','04','Condesuyos',1),('0407','04','Islay',1),('0408','04','La Uniòn',1),('0501','05','Huamanga',1),('0502','05','Cangallo',1),('0503','05','Huanca Sancos',1),('0504','05','Huanta',1),('0505','05','La Mar',1),('0506','05','Lucanas',1),('0507','05','Parinacochas',1),('0508','05','Pàucar del Sara Sara',1),('0509','05','Sucre',1),('0510','05','Víctor Fajardo',1),('0511','05','Vilcas Huamán',1),('0601','06','Cajamarca',1),('0602','06','Cajabamba',1),('0603','06','Celendín',1),('0604','06','Chota',1),('0605','06','Contumazá',1),('0606','06','Cutervo',1),('0607','06','Hualgayoc',1),('0608','06','Jaén',1),('0609','06','San Ignacio',1),('0610','06','San Marcos',1),('0611','06','San Miguel',1),('0612','06','San Pablo',1),('0613','06','Santa Cruz',1),('0701','07','Prov. Const. del Callao',1),('0801','08','Cusco',1),('0802','08','Acomayo',1),('0803','08','Anta',1),('0804','08','Calca',1),('0805','08','Canas',1),('0806','08','Canchis',1),('0807','08','Chumbivilcas',1),('0808','08','Espinar',1),('0809','08','La Convención',1),('0810','08','Paruro',1),('0811','08','Paucartambo',1),('0812','08','Quispicanchi',1),('0813','08','Urubamba',1),('0901','09','Huancavelica',1),('0902','09','Acobamba',1),('0903','09','Angaraes',1),('0904','09','Castrovirreyna',1),('0905','09','Churcampa',1),('0906','09','Huaytará',1),('0907','09','Tayacaja',1),('1001','10','Huánuco',1),('1002','10','Ambo',1),('1003','10','Dos de Mayo',1),('1004','10','Huacaybamba',1),('1005','10','Huamalíes',1),('1006','10','Leoncio Prado',1),('1007','10','Marañón',1),('1008','10','Pachitea',1),('1009','10','Puerto Inca',1),('1010','10','Lauricocha',1),('1011','10','Yarowilca',1),('1101','11','Ica',1),('1102','11','Chincha',1),('1103','11','Nasca',1),('1104','11','Palpa',1),('1105','11','Pisco',1),('1201','12','Huancayo',1),('1202','12','Concepción',1),('1203','12','Chanchamayo',1),('1204','12','Jauja',1),('1205','12','Junín',1),('1206','12','Satipo',1),('1207','12','Tarma',1),('1208','12','Yauli',1),('1209','12','Chupaca',1),('1301','13','Trujillo',1),('1302','13','Ascope',1),('1303','13','Bolívar',1),('1304','13','Chepén',1),('1305','13','Julcán',1),('1306','13','Otuzco',1),('1307','13','Pacasmayo',1),('1308','13','Pataz',1),('1309','13','Sánchez Carrión',1),('1310','13','Santiago de Chuco',1),('1311','13','Gran Chimú',1),('1312','13','Virú',1),('1401','14','Chiclayo',1),('1402','14','Ferreñafe',1),('1403','14','Lambayeque',1),('1501','15','Lima',1),('1502','15','Barranca',1),('1503','15','Cajatambo',1),('1504','15','Canta',1),('1505','15','Cañete',1),('1506','15','Huaral',1),('1507','15','Huarochirí',1),('1508','15','Huaura',1),('1509','15','Oyón',1),('1510','15','Yauyos',1),('1601','16','Maynas',1),('1602','16','Alto Amazonas',1),('1603','16','Loreto',1),('1604','16','Mariscal Ramón Castilla',1),('1605','16','Requena',1),('1606','16','Ucayali',1),('1607','16','Datem del Marañón',1),('1608','16','Putumayo',1),('1701','17','Tambopata',1),('1702','17','Manu',1),('1703','17','Tahuamanu',1),('1801','18','Mariscal Nieto',1),('1802','18','General Sánchez Cerro',1),('1803','18','Ilo',1),('1901','19','Pasco',1),('1902','19','Daniel Alcides Carrión',1),('1903','19','Oxapampa',1),('2001','20','Piura',1),('2002','20','Ayabaca',1),('2003','20','Huancabamba',1),('2004','20','Morropón',1),('2005','20','Paita',1),('2006','20','Sullana',1),('2007','20','Talara',1),('2008','20','Sechura',1),('2101','21','Puno',1),('2102','21','Azángaro',1),('2103','21','Carabaya',1),('2104','21','Chucuito',1),('2105','21','El Collao',1),('2106','21','Huancané',1),('2107','21','Lampa',1),('2108','21','Melgar',1),('2109','21','Moho',1),('2110','21','San Antonio de Putina',1),('2111','21','San Román',1),('2112','21','Sandia',1),('2113','21','Yunguyo',1),('2201','22','Moyobamba',1),('2202','22','Bellavista',1),('2203','22','El Dorado',1),('2204','22','Huallaga',1),('2205','22','Lamas',1),('2206','22','Mariscal Cáceres',1),('2207','22','Picota',1),('2208','22','Rioja',1),('2209','22','San Martín',1),('2210','22','Tocache',1),('2301','23','Tacna',1),('2302','23','Candarave',1),('2303','23','Jorge Basadre',1),('2304','23','Tarata',1),('2401','24','Tumbes',1),('2402','24','Contralmirante Villar',1),('2403','24','Zarumilla',1),('2501','25','Coronel Portillo',1),('2502','25','Atalaya',1),('2503','25','Padre Abad',1),('2504','25','Purús',1);

--
-- Table structure for table `purchase_fee`
--

CREATE TABLE `purchase_fee` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_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,
  PRIMARY KEY (`id`),
  KEY `purchase_fee_purchase_id_foreign` (`purchase_id`),
  KEY `purchase_fee_currency_type_id_foreign` (`currency_type_id`),
  KEY `purchase_fee_payment_method_type_id_foreign` (`payment_method_type_id`),
  CONSTRAINT `purchase_fee_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`),
  CONSTRAINT `purchase_fee_payment_method_type_id_foreign` FOREIGN KEY (`payment_method_type_id`) REFERENCES `payment_method_types` (`id`),
  CONSTRAINT `purchase_fee_purchase_id_foreign` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchase_fee`
--


--
-- Table structure for table `purchase_items`
--

CREATE TABLE `purchase_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_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`)),
  `item_lot_group_id` int(10) unsigned DEFAULT NULL,
  `lot_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` decimal(12,4) NOT NULL,
  `unit_value` decimal(16,6) NOT NULL,
  `date_of_due` date DEFAULT 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`)),
  `warehouse_id` int(10) unsigned DEFAULT NULL,
  `name_product_pdf` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `purchase_items_purchase_id_foreign` (`purchase_id`),
  KEY `purchase_items_item_id_foreign` (`item_id`),
  KEY `purchase_items_affectation_igv_type_id_foreign` (`affectation_igv_type_id`),
  KEY `purchase_items_system_isc_type_id_foreign` (`system_isc_type_id`),
  KEY `purchase_items_price_type_id_foreign` (`price_type_id`),
  KEY `purchase_items_warehouse_id_foreign` (`warehouse_id`),
  KEY `purchase_items_item_lot_group_id_index` (`item_lot_group_id`),
  CONSTRAINT `purchase_items_affectation_igv_type_id_foreign` FOREIGN KEY (`affectation_igv_type_id`) REFERENCES `cat_affectation_igv_types` (`id`),
  CONSTRAINT `purchase_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`),
  CONSTRAINT `purchase_items_price_type_id_foreign` FOREIGN KEY (`price_type_id`) REFERENCES `cat_price_types` (`id`),
  CONSTRAINT `purchase_items_purchase_id_foreign` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE CASCADE,
  CONSTRAINT `purchase_items_system_isc_type_id_foreign` FOREIGN KEY (`system_isc_type_id`) REFERENCES `cat_system_isc_types` (`id`),
  CONSTRAINT `purchase_items_warehouse_id_foreign` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchase_items`
--


--
-- Table structure for table `purchase_order_items`
--

CREATE TABLE `purchase_order_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_order_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` int(11) NOT NULL,
  `unit_value` decimal(16,6) NOT NULL,
  `affectation_igv_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_base_igv` decimal(12,2) NOT NULL,
  `percentage_igv` decimal(12,2) NOT NULL,
  `total_igv` decimal(12,2) NOT NULL,
  `system_isc_type_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_base_isc` decimal(12,2) NOT NULL DEFAULT 0.00,
  `percentage_isc` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_isc` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_base_other_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `percentage_other_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_other_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_taxes` decimal(12,2) NOT NULL,
  `price_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `unit_price` decimal(16,6) NOT NULL,
  `total_value` decimal(12,2) NOT NULL,
  `total_charge` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_discount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total` decimal(12,2) NOT NULL,
  `attributes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`attributes`)),
  `discounts` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`discounts`)),
  `charges` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`charges`)),
  PRIMARY KEY (`id`),
  KEY `purchase_order_items_purchase_order_id_foreign` (`purchase_order_id`),
  KEY `purchase_order_items_item_id_foreign` (`item_id`),
  KEY `purchase_order_items_affectation_igv_type_id_foreign` (`affectation_igv_type_id`),
  KEY `purchase_order_items_system_isc_type_id_foreign` (`system_isc_type_id`),
  KEY `purchase_order_items_price_type_id_foreign` (`price_type_id`),
  CONSTRAINT `purchase_order_items_affectation_igv_type_id_foreign` FOREIGN KEY (`affectation_igv_type_id`) REFERENCES `cat_affectation_igv_types` (`id`),
  CONSTRAINT `purchase_order_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`),
  CONSTRAINT `purchase_order_items_price_type_id_foreign` FOREIGN KEY (`price_type_id`) REFERENCES `cat_price_types` (`id`),
  CONSTRAINT `purchase_order_items_purchase_order_id_foreign` FOREIGN KEY (`purchase_order_id`) REFERENCES `purchase_orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `purchase_order_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 `purchase_order_items`
--


--
-- Table structure for table `purchase_orders`
--

CREATE TABLE `purchase_orders` (
  `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` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'OC',
  `date_of_issue` date NOT NULL,
  `date_of_due` date DEFAULT NULL,
  `time_of_issue` time NOT NULL,
  `supplier_id` int(10) unsigned NOT NULL,
  `supplier` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`supplier`)),
  `currency_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `exchange_rate_sale` decimal(13,3) NOT NULL,
  `total_prepayment` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_charge` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_discount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_exportation` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_free` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_taxed` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_unaffected` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_exonerated` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_igv` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_base_isc` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_isc` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_base_other_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_other_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_value` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total` decimal(12,2) NOT NULL,
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `upload_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `purchase_quotation_id` int(10) unsigned DEFAULT NULL,
  `sale_opportunity_id` int(10) unsigned DEFAULT NULL,
  `payment_method_type_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `purchase_orders_purchase_quotation_id_foreign` (`purchase_quotation_id`),
  KEY `purchase_orders_user_id_foreign` (`user_id`),
  KEY `purchase_orders_establishment_id_foreign` (`establishment_id`),
  KEY `purchase_orders_supplier_id_foreign` (`supplier_id`),
  KEY `purchase_orders_soap_type_id_foreign` (`soap_type_id`),
  KEY `purchase_orders_state_type_id_foreign` (`state_type_id`),
  KEY `purchase_orders_currency_type_id_foreign` (`currency_type_id`),
  KEY `purchase_orders_payment_method_type_id_foreign` (`payment_method_type_id`),
  KEY `purchase_orders_sale_opportunity_id_foreign` (`sale_opportunity_id`),
  CONSTRAINT `purchase_orders_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`),
  CONSTRAINT `purchase_orders_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`),
  CONSTRAINT `purchase_orders_payment_method_type_id_foreign` FOREIGN KEY (`payment_method_type_id`) REFERENCES `payment_method_types` (`id`),
  CONSTRAINT `purchase_orders_purchase_quotation_id_foreign` FOREIGN KEY (`purchase_quotation_id`) REFERENCES `purchase_quotations` (`id`),
  CONSTRAINT `purchase_orders_sale_opportunity_id_foreign` FOREIGN KEY (`sale_opportunity_id`) REFERENCES `sale_opportunities` (`id`),
  CONSTRAINT `purchase_orders_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `purchase_orders_state_type_id_foreign` FOREIGN KEY (`state_type_id`) REFERENCES `state_types` (`id`),
  CONSTRAINT `purchase_orders_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `purchase_orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchase_orders`
--


--
-- Table structure for table `purchase_payments`
--

CREATE TABLE `purchase_payments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_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`),
  KEY `purchase_payments_purchase_id_foreign` (`purchase_id`),
  KEY `purchase_payments_card_brand_id_foreign` (`card_brand_id`),
  KEY `purchase_payments_payment_method_type_id_foreign` (`payment_method_type_id`),
  KEY `purchase_payments_date_of_payment_index` (`date_of_payment`),
  CONSTRAINT `purchase_payments_card_brand_id_foreign` FOREIGN KEY (`card_brand_id`) REFERENCES `card_brands` (`id`),
  CONSTRAINT `purchase_payments_payment_method_type_id_foreign` FOREIGN KEY (`payment_method_type_id`) REFERENCES `payment_method_types` (`id`),
  CONSTRAINT `purchase_payments_purchase_id_foreign` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchase_payments`
--


--
-- Table structure for table `purchase_quotation_items`
--

CREATE TABLE `purchase_quotation_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_quotation_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 `purchase_quotation_items_purchase_quotation_id_foreign` (`purchase_quotation_id`),
  KEY `purchase_quotation_items_item_id_foreign` (`item_id`),
  CONSTRAINT `purchase_quotation_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`),
  CONSTRAINT `purchase_quotation_items_purchase_quotation_id_foreign` FOREIGN KEY (`purchase_quotation_id`) REFERENCES `purchase_quotations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchase_quotation_items`
--


--
-- Table structure for table `purchase_quotations`
--

CREATE TABLE `purchase_quotations` (
  `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,
  `prefix` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_of_issue` date NOT NULL,
  `time_of_issue` time NOT NULL,
  `suppliers` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`suppliers`)),
  `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 `purchase_quotations_user_id_foreign` (`user_id`),
  KEY `purchase_quotations_establishment_id_foreign` (`establishment_id`),
  KEY `purchase_quotations_soap_type_id_foreign` (`soap_type_id`),
  KEY `purchase_quotations_state_type_id_foreign` (`state_type_id`),
  CONSTRAINT `purchase_quotations_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`),
  CONSTRAINT `purchase_quotations_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `purchase_quotations_state_type_id_foreign` FOREIGN KEY (`state_type_id`) REFERENCES `state_types` (`id`),
  CONSTRAINT `purchase_quotations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchase_quotations`
--


--
-- Table structure for table `purchase_settlement_items`
--

CREATE TABLE `purchase_settlement_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_settlement_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,2) NOT NULL,
  `unit_value` decimal(12,2) 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,
  `total_taxes` decimal(12,2) NOT NULL,
  `price_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `unit_price` decimal(12,2) NOT NULL,
  `total_value` decimal(12,2) NOT NULL,
  `total` decimal(12,2) NOT NULL,
  `income_tax_affectation_igv_type_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `income_retention_percentage` decimal(12,2) NOT NULL DEFAULT 0.00,
  `income_retention_amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  PRIMARY KEY (`id`),
  KEY `purchase_settlement_items_purchase_settlement_id_foreign` (`purchase_settlement_id`),
  KEY `purchase_settlement_items_item_id_foreign` (`item_id`),
  KEY `p_s_i_income_tax_affectation_igv_type_id_fk` (`income_tax_affectation_igv_type_id`),
  KEY `purchase_settlement_items_affectation_igv_type_id_foreign` (`affectation_igv_type_id`),
  KEY `purchase_settlement_items_price_type_id_foreign` (`price_type_id`),
  CONSTRAINT `p_s_i_income_tax_affectation_igv_type_id_fk` FOREIGN KEY (`income_tax_affectation_igv_type_id`) REFERENCES `cat_affectation_igv_types` (`id`),
  CONSTRAINT `purchase_settlement_items_affectation_igv_type_id_foreign` FOREIGN KEY (`affectation_igv_type_id`) REFERENCES `cat_affectation_igv_types` (`id`),
  CONSTRAINT `purchase_settlement_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`),
  CONSTRAINT `purchase_settlement_items_price_type_id_foreign` FOREIGN KEY (`price_type_id`) REFERENCES `cat_price_types` (`id`),
  CONSTRAINT `purchase_settlement_items_purchase_settlement_id_foreign` FOREIGN KEY (`purchase_settlement_id`) REFERENCES `purchase_settlements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchase_settlement_items`
--


--
-- Table structure for table `purchase_settlement_payments`
--

CREATE TABLE `purchase_settlement_payments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_settlement_id` int(10) unsigned NOT NULL,
  `date_of_payment` date NOT NULL,
  `payment_method_type_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `change` decimal(12,2) NOT NULL DEFAULT 0.00,
  `payment` decimal(12,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `purchase_settlement_payments_purchase_settlement_id_foreign` (`purchase_settlement_id`),
  KEY `purchase_settlement_payments_payment_method_type_id_foreign` (`payment_method_type_id`),
  CONSTRAINT `purchase_settlement_payments_payment_method_type_id_foreign` FOREIGN KEY (`payment_method_type_id`) REFERENCES `payment_method_types` (`id`),
  CONSTRAINT `purchase_settlement_payments_purchase_settlement_id_foreign` FOREIGN KEY (`purchase_settlement_id`) REFERENCES `purchase_settlements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchase_settlement_payments`
--


--
-- Table structure for table `purchase_settlements`
--

CREATE TABLE `purchase_settlements` (
  `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,
  `operation_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `document_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `series` char(4) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` int(11) NOT NULL,
  `date_of_issue` date NOT NULL,
  `time_of_issue` time NOT NULL,
  `supplier_id` int(10) unsigned NOT NULL,
  `supplier` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`supplier`)),
  `operation_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`operation_data`)),
  `currency_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_method_type_id` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exchange_rate_sale` decimal(12,2) NOT NULL,
  `total_prepayment` 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_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_value` decimal(12,2) NOT NULL DEFAULT 0.00,
  `subtotal` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total` decimal(12,2) NOT NULL,
  `legends` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`legends`)),
  `prepayments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`prepayments`)),
  `related` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`related`)),
  `observations` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `has_xml` tinyint(1) NOT NULL DEFAULT 0,
  `has_pdf` tinyint(1) NOT NULL DEFAULT 0,
  `has_cdr` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `purchase_settlements_filename_unique` (`filename`),
  KEY `purchase_settlements_user_id_foreign` (`user_id`),
  KEY `purchase_settlements_establishment_id_foreign` (`establishment_id`),
  KEY `purchase_settlements_supplier_id_foreign` (`supplier_id`),
  KEY `purchase_settlements_soap_type_id_foreign` (`soap_type_id`),
  KEY `purchase_settlements_state_type_id_foreign` (`state_type_id`),
  KEY `purchase_settlements_document_type_id_foreign` (`document_type_id`),
  KEY `purchase_settlements_currency_type_id_foreign` (`currency_type_id`),
  KEY `purchase_settlements_operation_type_id_foreign` (`operation_type_id`),
  KEY `purchase_settlements_series_index` (`series`),
  KEY `purchase_settlements_number_index` (`number`),
  KEY `purchase_settlements_date_of_issue_index` (`date_of_issue`),
  KEY `purchase_settlements_payment_method_type_id_foreign` (`payment_method_type_id`),
  CONSTRAINT `purchase_settlements_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`),
  CONSTRAINT `purchase_settlements_document_type_id_foreign` FOREIGN KEY (`document_type_id`) REFERENCES `cat_document_types` (`id`),
  CONSTRAINT `purchase_settlements_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`),
  CONSTRAINT `purchase_settlements_operation_type_id_foreign` FOREIGN KEY (`operation_type_id`) REFERENCES `cat_operation_types` (`id`),
  CONSTRAINT `purchase_settlements_payment_method_type_id_foreign` FOREIGN KEY (`payment_method_type_id`) REFERENCES `payment_method_types` (`id`),
  CONSTRAINT `purchase_settlements_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `purchase_settlements_state_type_id_foreign` FOREIGN KEY (`state_type_id`) REFERENCES `state_types` (`id`),
  CONSTRAINT `purchase_settlements_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `purchase_settlements_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchase_settlements`
--


--
-- Table structure for table `purchases`
--

CREATE TABLE `purchases` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `external_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `establishment_id` int(10) unsigned NOT NULL,
  `soap_type_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state_type_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `group_id` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `document_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `series` char(4) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` int(11) NOT NULL,
  `date_of_issue` date NOT NULL,
  `date_of_due` date DEFAULT NULL,
  `time_of_issue` time NOT NULL,
  `supplier_id` int(10) unsigned NOT NULL,
  `supplier` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`supplier`)),
  `purchase_order_id` int(10) unsigned DEFAULT NULL,
  `currency_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_condition_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `observation` text COLLATE utf8mb4_unicode_ci DEFAULT 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,
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_canceled` tinyint(1) NOT NULL DEFAULT 0,
  `customer_id` int(10) unsigned DEFAULT NULL,
  `perception_date` date DEFAULT NULL,
  `perception_number` int(11) DEFAULT NULL,
  `total_perception` decimal(12,2) DEFAULT NULL,
  `charges` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`charges`)),
  `discounts` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`discounts`)),
  `prepayments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`prepayments`)),
  `guides` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`guides`)),
  `related` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`related`)),
  `perception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`perception`)),
  `detraction` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`detraction`)),
  `legends` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`legends`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `purchases_user_id_foreign` (`user_id`),
  KEY `purchases_establishment_id_foreign` (`establishment_id`),
  KEY `purchases_supplier_id_foreign` (`supplier_id`),
  KEY `purchases_soap_type_id_foreign` (`soap_type_id`),
  KEY `purchases_state_type_id_foreign` (`state_type_id`),
  KEY `purchases_group_id_foreign` (`group_id`),
  KEY `purchases_document_type_id_foreign` (`document_type_id`),
  KEY `purchases_currency_type_id_foreign` (`currency_type_id`),
  KEY `purchases_purchase_order_id_foreign` (`purchase_order_id`),
  KEY `purchases_customer_id_foreign` (`customer_id`),
  KEY `purchases_payment_condition_id_foreign` (`payment_condition_id`),
  CONSTRAINT `purchases_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`),
  CONSTRAINT `purchases_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `purchases_document_type_id_foreign` FOREIGN KEY (`document_type_id`) REFERENCES `cat_document_types` (`id`),
  CONSTRAINT `purchases_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`),
  CONSTRAINT `purchases_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`),
  CONSTRAINT `purchases_payment_condition_id_foreign` FOREIGN KEY (`payment_condition_id`) REFERENCES `general_payment_conditions` (`id`),
  CONSTRAINT `purchases_purchase_order_id_foreign` FOREIGN KEY (`purchase_order_id`) REFERENCES `purchase_orders` (`id`),
  CONSTRAINT `purchases_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `purchases_state_type_id_foreign` FOREIGN KEY (`state_type_id`) REFERENCES `state_types` (`id`),
  CONSTRAINT `purchases_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `purchases_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchases`
--


--
-- Table structure for table `quotation_items`
--

CREATE TABLE `quotation_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `quotation_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`)),
  `additional_information` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Informacion adicional',
  `warehouse_id` int(10) unsigned DEFAULT 0 COMMENT 'Id de warehouse',
  `name_product_pdf` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Nombre de producto en el pdf',
  PRIMARY KEY (`id`),
  KEY `quotation_items_quotation_id_foreign` (`quotation_id`),
  KEY `quotation_items_item_id_foreign` (`item_id`),
  KEY `quotation_items_affectation_igv_type_id_foreign` (`affectation_igv_type_id`),
  KEY `quotation_items_system_isc_type_id_foreign` (`system_isc_type_id`),
  KEY `quotation_items_price_type_id_foreign` (`price_type_id`),
  CONSTRAINT `quotation_items_affectation_igv_type_id_foreign` FOREIGN KEY (`affectation_igv_type_id`) REFERENCES `cat_affectation_igv_types` (`id`),
  CONSTRAINT `quotation_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`),
  CONSTRAINT `quotation_items_price_type_id_foreign` FOREIGN KEY (`price_type_id`) REFERENCES `cat_price_types` (`id`),
  CONSTRAINT `quotation_items_quotation_id_foreign` FOREIGN KEY (`quotation_id`) REFERENCES `quotations` (`id`) ON DELETE CASCADE,
  CONSTRAINT `quotation_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 `quotation_items`
--


--
-- Table structure for table `quotation_payments`
--

CREATE TABLE `quotation_payments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `quotation_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 `quotation_payments_quotation_id_foreign` (`quotation_id`),
  KEY `quotation_payments_card_brand_id_foreign` (`card_brand_id`),
  KEY `quotation_payments_payment_method_type_id_foreign` (`payment_method_type_id`),
  CONSTRAINT `quotation_payments_card_brand_id_foreign` FOREIGN KEY (`card_brand_id`) REFERENCES `card_brands` (`id`),
  CONSTRAINT `quotation_payments_payment_method_type_id_foreign` FOREIGN KEY (`payment_method_type_id`) REFERENCES `payment_method_types` (`id`),
  CONSTRAINT `quotation_payments_quotation_id_foreign` FOREIGN KEY (`quotation_id`) REFERENCES `quotations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `quotation_payments`
--


--
-- Table structure for table `quotations`
--

CREATE TABLE `quotations` (
  `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` char(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_of_issue` date NOT NULL,
  `time_of_issue` time NOT NULL,
  `date_of_due` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delivery_date` varchar(255) COLLATE utf8mb4_unicode_ci 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,
  `currency_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_method_type_id` char(2) COLLATE utf8mb4_unicode_ci DEFAULT 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_igv_free` 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,
  `subtotal` 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,
  `referential_information` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `changed` tinyint(1) NOT NULL DEFAULT 0,
  `sale_opportunity_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `description` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `quotations_user_id_foreign` (`user_id`),
  KEY `quotations_establishment_id_foreign` (`establishment_id`),
  KEY `quotations_customer_id_foreign` (`customer_id`),
  KEY `quotations_soap_type_id_foreign` (`soap_type_id`),
  KEY `quotations_state_type_id_foreign` (`state_type_id`),
  KEY `quotations_currency_type_id_foreign` (`currency_type_id`),
  KEY `quotations_payment_method_type_id_foreign` (`payment_method_type_id`),
  KEY `quotations_sale_opportunity_id_foreign` (`sale_opportunity_id`),
  CONSTRAINT `quotations_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`),
  CONSTRAINT `quotations_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `quotations_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`),
  CONSTRAINT `quotations_payment_method_type_id_foreign` FOREIGN KEY (`payment_method_type_id`) REFERENCES `payment_method_types` (`id`),
  CONSTRAINT `quotations_sale_opportunity_id_foreign` FOREIGN KEY (`sale_opportunity_id`) REFERENCES `sale_opportunities` (`id`),
  CONSTRAINT `quotations_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `quotations_state_type_id_foreign` FOREIGN KEY (`state_type_id`) REFERENCES `state_types` (`id`),
  CONSTRAINT `quotations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `quotations`
--


--
-- Table structure for table `rel_user_to_documentary_offices`
--

CREATE TABLE `rel_user_to_documentary_offices` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `active` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'usuario asociado',
  `documentary_office_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'etapa asociada',
  `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 `rel_user_to_documentary_offices`
--


--
-- Table structure for table `report_configurations`
--

CREATE TABLE `report_configurations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `route_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `route_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `convert_pen` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `report_configurations_route_name_unique` (`route_name`),
  UNIQUE KEY `report_configurations_route_path_unique` (`route_path`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `report_configurations`
--

INSERT INTO `report_configurations` VALUES (1,'tenant.reports.general_items.index','reports/general-items','Ventas - Reporte general de productos',0,'2022-05-06 09:50:06','2022-05-06 09:50:06'),(2,'tenant.reports.purchases.general_items.index','reports/purchases/general_items','Compras - Reporte general de productos',0,'2022-05-06 09:50:06','2022-05-06 09:50:06'),(3,'tenant.reports.purchases.index','reports/purchases','Compras - Compras totales',0,'2022-05-06 09:50:06','2022-05-06 09:50:06');

--
-- Table structure for table `restaurant_configurations`
--

CREATE TABLE `restaurant_configurations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `menu_pos` tinyint(1) NOT NULL,
  `menu_order` tinyint(1) NOT NULL,
  `menu_tables` tinyint(1) NOT NULL,
  `first_menu` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tables_quantity` int(11) NOT NULL DEFAULT 15,
  `menu_bar` tinyint(1) NOT NULL DEFAULT 1,
  `menu_kitchen` tinyint(1) NOT NULL DEFAULT 1,
  `items_maintenance` tinyint(1) NOT NULL DEFAULT 0,
  `enabled_environment_1` tinyint(1) NOT NULL DEFAULT 1,
  `enabled_environment_2` tinyint(1) NOT NULL DEFAULT 0,
  `tables_quantity_environment_2` int(11) NOT NULL DEFAULT 5,
  `enabled_environment_3` tinyint(1) NOT NULL DEFAULT 0,
  `tables_quantity_environment_3` int(11) NOT NULL DEFAULT 5,
  `enabled_environment_4` tinyint(1) NOT NULL DEFAULT 0,
  `tables_quantity_environment_4` int(11) NOT NULL DEFAULT 5,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `restaurant_configurations`
--

INSERT INTO `restaurant_configurations` VALUES (1,1,1,1,'POS',15,1,1,0,1,0,5,0,5,0,5);

--
-- Table structure for table `restaurant_notes`
--

CREATE TABLE `restaurant_notes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `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 `restaurant_notes`
--


--
-- Table structure for table `restaurant_roles`
--

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

--
-- Dumping data for table `restaurant_roles`
--

INSERT INTO `restaurant_roles` VALUES (1,'MOZO','Mozo','Usuario que genera pedidos en mesas',NULL,NULL),(2,'CAJA','Caja','Usuario que genera pago de pedidos',NULL,NULL),(3,'ADM','Administrador','Usuario con permisos totales',NULL,NULL),(6,'KITBAR','Cocina/Bar','Usuario con acceso a cocina y bar',NULL,NULL);

--
-- Table structure for table `restaurant_table_envs`
--

CREATE TABLE `restaurant_table_envs` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `tables_quantity` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `restaurant_table_envs`
--

INSERT INTO `restaurant_table_envs` VALUES (1,'Ambiente 1',1,25),(2,'Ambiente 2',1,25),(3,'Ambiente 3',1,25),(4,'Ambiente 4',1,25);

--
-- Table structure for table `restaurant_tables`
--

CREATE TABLE `restaurant_tables` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `products` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`products`)),
  `total` decimal(12,2) NOT NULL,
  `personas` int(11) NOT NULL,
  `cliente` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comentarios` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shape` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `environment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `waiter` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `restaurant_tables`
--


--
-- Table structure for table `retention_documents`
--

CREATE TABLE `retention_documents` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `retention_id` int(10) unsigned NOT NULL,
  `document_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `series` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_of_issue` date NOT NULL,
  `currency_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_document` decimal(10,2) NOT NULL,
  `payments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`payments`)),
  `exchange_rate` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`exchange_rate`)),
  `date_of_retention` date NOT NULL,
  `total_retention` decimal(10,2) NOT NULL,
  `total_to_pay` decimal(10,2) NOT NULL,
  `total_payment` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `retention_documents_retention_id_foreign` (`retention_id`),
  KEY `retention_documents_document_type_id_foreign` (`document_type_id`),
  KEY `retention_documents_currency_type_id_foreign` (`currency_type_id`),
  CONSTRAINT `retention_documents_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`),
  CONSTRAINT `retention_documents_document_type_id_foreign` FOREIGN KEY (`document_type_id`) REFERENCES `cat_document_types` (`id`),
  CONSTRAINT `retention_documents_retention_id_foreign` FOREIGN KEY (`retention_id`) REFERENCES `retentions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `retention_documents`
--


--
-- Table structure for table `retentions`
--

CREATE TABLE `retentions` (
  `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,
  `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,
  `supplier_id` int(10) unsigned NOT NULL,
  `supplier` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`supplier`)),
  `retention_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `observations` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_retention` decimal(10,2) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `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`)),
  `has_xml` tinyint(1) NOT NULL DEFAULT 0,
  `has_pdf` tinyint(1) NOT NULL DEFAULT 0,
  `has_cdr` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `retentions_user_id_foreign` (`user_id`),
  KEY `retentions_establishment_id_foreign` (`establishment_id`),
  KEY `retentions_soap_type_id_foreign` (`soap_type_id`),
  KEY `retentions_state_type_id_foreign` (`state_type_id`),
  KEY `retentions_document_type_id_foreign` (`document_type_id`),
  KEY `retentions_supplier_id_foreign` (`supplier_id`),
  KEY `retentions_retention_type_id_foreign` (`retention_type_id`),
  KEY `retentions_currency_type_id_foreign` (`currency_type_id`),
  CONSTRAINT `retentions_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`),
  CONSTRAINT `retentions_document_type_id_foreign` FOREIGN KEY (`document_type_id`) REFERENCES `cat_document_types` (`id`),
  CONSTRAINT `retentions_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`),
  CONSTRAINT `retentions_retention_type_id_foreign` FOREIGN KEY (`retention_type_id`) REFERENCES `cat_retention_types` (`id`),
  CONSTRAINT `retentions_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `retentions_state_type_id_foreign` FOREIGN KEY (`state_type_id`) REFERENCES `state_types` (`id`),
  CONSTRAINT `retentions_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `retentions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `retentions`
--


--
-- Table structure for table `sale_note_items`
--

CREATE TABLE `sale_note_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sale_note_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_plastic_bag_taxes` decimal(6,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`)),
  `additional_information` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inventory_kardex_id` int(10) unsigned DEFAULT NULL,
  `warehouse_id` int(10) unsigned DEFAULT NULL,
  `name_product_pdf` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sale_note_items_sale_note_id_foreign` (`sale_note_id`),
  KEY `sale_note_items_item_id_foreign` (`item_id`),
  KEY `sale_note_items_affectation_igv_type_id_foreign` (`affectation_igv_type_id`),
  KEY `sale_note_items_system_isc_type_id_foreign` (`system_isc_type_id`),
  KEY `sale_note_items_price_type_id_foreign` (`price_type_id`),
  KEY `sale_note_items_inventory_kardex_id_foreign` (`inventory_kardex_id`),
  KEY `sale_note_items_warehouse_id_foreign` (`warehouse_id`),
  CONSTRAINT `sale_note_items_affectation_igv_type_id_foreign` FOREIGN KEY (`affectation_igv_type_id`) REFERENCES `cat_affectation_igv_types` (`id`),
  CONSTRAINT `sale_note_items_inventory_kardex_id_foreign` FOREIGN KEY (`inventory_kardex_id`) REFERENCES `inventory_kardex` (`id`),
  CONSTRAINT `sale_note_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`),
  CONSTRAINT `sale_note_items_price_type_id_foreign` FOREIGN KEY (`price_type_id`) REFERENCES `cat_price_types` (`id`),
  CONSTRAINT `sale_note_items_sale_note_id_foreign` FOREIGN KEY (`sale_note_id`) REFERENCES `sale_notes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `sale_note_items_system_isc_type_id_foreign` FOREIGN KEY (`system_isc_type_id`) REFERENCES `cat_system_isc_types` (`id`),
  CONSTRAINT `sale_note_items_warehouse_id_foreign` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sale_note_items`
--

INSERT INTO `sale_note_items` VALUES (3,3,195,'{\"stock\":\"0.0000\",\"id\":195,\"item_id\":195,\"full_description\":\"ZAPATILLA REAMAZ\",\"name\":null,\"second_name\":null,\"description\":\"ZAPATILLA REAMAZ\",\"currency_type_id\":\"PEN\",\"internal_id\":null,\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":\"60.00\",\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"20\",\"purchase_affectation_igv_type_id\":\"10\",\"calculate_quantity\":false,\"has_igv\":true,\"is_set\":false,\"active\":1,\"edit_unit_price\":false,\"aux_quantity\":1,\"edit_sale_unit_price\":\"60.00\",\"aux_sale_unit_price\":\"60.00\",\"image_url\":\"https:\\/\\/zapateria-brazil.softlte.net.pe\\/logo\\/imagen-no-disponible.jpg\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\"}],\"category_id\":0,\"sets\":[],\"unit_type\":[],\"category\":null,\"brand\":null,\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"original_affectation_igv_type_id\":\"20\",\"unit_price\":\"60.00\",\"IdLoteSelected\":null}',1.0000,60.000000,'20',60.00,18.00,0.00,NULL,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'01',60.000000,60.00,0.00,0.00,60.00,'[]','[]','[]',NULL,1197,NULL,NULL),(4,4,226,'{\"id\":226,\"item_id\":226,\"full_description\":\"BOLSA DE REGALO\",\"description\":\"BOLSA DE REGALO\",\"currency_type_id\":\"PEN\",\"internal_id\":null,\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":\"5.00\",\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"aux_unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"20\",\"purchase_affectation_igv_type_id\":\"10\",\"calculate_quantity\":false,\"has_igv\":true,\"is_set\":false,\"edit_unit_price\":false,\"aux_quantity\":1,\"edit_sale_unit_price\":\"5.00\",\"aux_sale_unit_price\":\"5.00\",\"image_url\":\"https:\\/\\/zapateria-brazil.softlte.net.pe\\/logo\\/imagen-no-disponible.jpg\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\"}],\"category_id\":0,\"sets\":[],\"unit_type\":[],\"category\":null,\"brand\":null,\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"original_affectation_igv_type_id\":\"20\",\"unit_price\":\"5.00\",\"IdLoteSelected\":null}',1.0000,5.000000,'20',5.00,18.00,0.00,NULL,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'01',5.000000,5.00,0.00,0.00,5.00,'[]','[]','[]',NULL,1764,NULL,NULL),(5,4,225,'{\"stock\":\"0.0000\",\"id\":225,\"item_id\":225,\"full_description\":\"CARTERA BEIGE\",\"name\":null,\"second_name\":null,\"description\":\"CARTERA BEIGE\",\"currency_type_id\":\"PEN\",\"internal_id\":null,\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":\"65.00\",\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"aux_unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"20\",\"purchase_affectation_igv_type_id\":\"10\",\"calculate_quantity\":false,\"has_igv\":true,\"is_set\":false,\"active\":1,\"edit_unit_price\":false,\"aux_quantity\":1,\"edit_sale_unit_price\":\"65.00\",\"aux_sale_unit_price\":\"65.00\",\"image_url\":\"https:\\/\\/zapateria-brazil.softlte.net.pe\\/logo\\/imagen-no-disponible.jpg\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\"}],\"category_id\":0,\"sets\":[],\"unit_type\":[],\"category\":null,\"brand\":null,\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"original_affectation_igv_type_id\":\"20\",\"unit_price\":\"65.00\",\"IdLoteSelected\":null}',1.0000,65.000000,'20',65.00,18.00,0.00,NULL,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'01',65.000000,65.00,0.00,0.00,65.00,'[]','[]','[]',NULL,1765,NULL,NULL);

--
-- Table structure for table `sale_note_migration`
--

CREATE TABLE `sale_note_migration` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sale_notes_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `success` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remote_id` int(10) unsigned NOT NULL DEFAULT 0,
  `number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data` longtext 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 `sale_note_migration`
--


--
-- Table structure for table `sale_note_payments`
--

CREATE TABLE `sale_note_payments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sale_note_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 `sale_note_payments_sale_note_id_foreign` (`sale_note_id`),
  KEY `sale_note_payments_card_brand_id_foreign` (`card_brand_id`),
  KEY `sale_note_payments_payment_method_type_id_foreign` (`payment_method_type_id`),
  KEY `sale_note_payments_date_of_payment_index` (`date_of_payment`),
  CONSTRAINT `sale_note_payments_card_brand_id_foreign` FOREIGN KEY (`card_brand_id`) REFERENCES `card_brands` (`id`),
  CONSTRAINT `sale_note_payments_payment_method_type_id_foreign` FOREIGN KEY (`payment_method_type_id`) REFERENCES `payment_method_types` (`id`),
  CONSTRAINT `sale_note_payments_sale_note_id_foreign` FOREIGN KEY (`sale_note_id`) REFERENCES `sale_notes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sale_note_payments`
--

INSERT INTO `sale_note_payments` VALUES (3,3,'2022-10-22','01',0,NULL,NULL,NULL,60.00),(4,4,'2023-02-10','01',0,NULL,NULL,NULL,70.00);

--
-- Table structure for table `sale_notes`
--

CREATE TABLE `sale_notes` (
  `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,
  `prefix` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `series` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number` int(11) DEFAULT NULL,
  `date_of_issue` date NOT NULL,
  `time_of_issue` time NOT NULL,
  `customer_id` int(10) unsigned NOT NULL,
  `customer` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`customer`)),
  `currency_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_method_type_id` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exchange_rate_sale` decimal(13,3) NOT NULL,
  `point_system` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'indica si se uso en sistema por puntos',
  `point_system_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'datos de sistema por puntos' CHECK (json_valid(`point_system_data`)),
  `created_from_pos` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'indica si se registro desde pos',
  `apply_concurrency` tinyint(1) NOT NULL DEFAULT 0,
  `enabled_concurrency` tinyint(1) NOT NULL DEFAULT 0,
  `automatic_date_of_issue` date DEFAULT NULL,
  `quantity_period` int(11) DEFAULT NULL,
  `type_period` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 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_igv_free` 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_plastic_bag_taxes` decimal(6,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,
  `subtotal` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total` decimal(12,2) NOT NULL,
  `dispatch_ticket_pdf` tinyint(1) NOT NULL DEFAULT 0,
  `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`)),
  `additional_information` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unique_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quotation_id` int(10) unsigned DEFAULT NULL,
  `order_note_id` int(10) unsigned DEFAULT NULL,
  `technical_service_id` int(10) unsigned DEFAULT NULL,
  `order_id` int(10) unsigned DEFAULT NULL,
  `total_canceled` tinyint(1) NOT NULL DEFAULT 0,
  `changed` tinyint(1) NOT NULL DEFAULT 0,
  `paid` tinyint(1) NOT NULL DEFAULT 0,
  `license_plate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plate_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_data` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agent_id` int(10) unsigned DEFAULT NULL,
  `observation` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `purchase_order` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document_id` int(10) unsigned DEFAULT NULL,
  `user_rel_suscription_plan_id` int(10) unsigned DEFAULT 0 COMMENT 'Relacion con suscripciones',
  `due_date` date DEFAULT NULL COMMENT 'Fecha de vencimiento',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `seller_id` int(10) unsigned DEFAULT 0,
  `grade` text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Grado designado - utilizado en matricula',
  `section` text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Seccion designado - utilizado en matricula',
  `terms_condition` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sale_notes_unique_filename_unique` (`unique_filename`),
  KEY `sale_notes_user_id_foreign` (`user_id`),
  KEY `sale_notes_establishment_id_foreign` (`establishment_id`),
  KEY `sale_notes_customer_id_foreign` (`customer_id`),
  KEY `sale_notes_soap_type_id_foreign` (`soap_type_id`),
  KEY `sale_notes_state_type_id_foreign` (`state_type_id`),
  KEY `sale_notes_currency_type_id_foreign` (`currency_type_id`),
  KEY `sale_notes_quotation_id_foreign` (`quotation_id`),
  KEY `sale_notes_apply_concurrency_index` (`apply_concurrency`),
  KEY `sale_notes_type_period_index` (`type_period`),
  KEY `sale_notes_quantity_period_index` (`quantity_period`),
  KEY `sale_notes_automatic_date_of_issue_index` (`automatic_date_of_issue`),
  KEY `sale_notes_enabled_concurrency_index` (`enabled_concurrency`),
  KEY `sale_notes_order_note_id_foreign` (`order_note_id`),
  KEY `sale_notes_payment_method_type_id_foreign` (`payment_method_type_id`),
  KEY `sale_notes_order_id_foreign` (`order_id`),
  KEY `sale_notes_technical_service_id_foreign` (`technical_service_id`),
  KEY `sale_notes_agent_id_foreign` (`agent_id`),
  KEY `sale_notes_changed_index` (`changed`),
  CONSTRAINT `sale_notes_agent_id_foreign` FOREIGN KEY (`agent_id`) REFERENCES `agents` (`id`),
  CONSTRAINT `sale_notes_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`),
  CONSTRAINT `sale_notes_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `sale_notes_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`),
  CONSTRAINT `sale_notes_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`),
  CONSTRAINT `sale_notes_order_note_id_foreign` FOREIGN KEY (`order_note_id`) REFERENCES `order_notes` (`id`),
  CONSTRAINT `sale_notes_payment_method_type_id_foreign` FOREIGN KEY (`payment_method_type_id`) REFERENCES `payment_method_types` (`id`),
  CONSTRAINT `sale_notes_quotation_id_foreign` FOREIGN KEY (`quotation_id`) REFERENCES `quotations` (`id`),
  CONSTRAINT `sale_notes_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `sale_notes_state_type_id_foreign` FOREIGN KEY (`state_type_id`) REFERENCES `state_types` (`id`),
  CONSTRAINT `sale_notes_technical_service_id_foreign` FOREIGN KEY (`technical_service_id`) REFERENCES `technical_services` (`id`),
  CONSTRAINT `sale_notes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sale_notes`
--

