-- Table structure for table `document_payments`
--

CREATE TABLE `document_payments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `document_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_received` tinyint(1) DEFAULT NULL,
  `change` decimal(12,2) DEFAULT NULL,
  `payment` decimal(12,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `document_payments_document_id_foreign` (`document_id`),
  KEY `document_payments_card_brand_id_foreign` (`card_brand_id`),
  KEY `document_payments_payment_method_type_id_foreign` (`payment_method_type_id`),
  KEY `document_payments_date_of_payment_index` (`date_of_payment`),
  CONSTRAINT `document_payments_card_brand_id_foreign` FOREIGN KEY (`card_brand_id`) REFERENCES `card_brands` (`id`),
  CONSTRAINT `document_payments_document_id_foreign` FOREIGN KEY (`document_id`) REFERENCES `documents` (`id`) ON DELETE CASCADE,
  CONSTRAINT `document_payments_payment_method_type_id_foreign` FOREIGN KEY (`payment_method_type_id`) REFERENCES `payment_method_types` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `document_payments`
--

INSERT INTO `document_payments` VALUES (7,7,'2022-06-01','01',0,NULL,NULL,NULL,0.00,38.00),(8,8,'2022-06-01','01',0,NULL,NULL,NULL,0.00,38.00),(9,9,'2022-06-01','01',0,NULL,NULL,NULL,0.00,38.00),(10,10,'2022-06-08','01',0,NULL,NULL,NULL,0.00,22.00),(11,11,'2022-06-10','01',0,NULL,NULL,NULL,NULL,15.00),(12,12,'2022-06-10','01',0,NULL,NULL,NULL,NULL,15.00),(13,13,'2022-06-10','01',0,NULL,NULL,NULL,NULL,15.00),(14,14,'2022-06-10','01',0,NULL,NULL,NULL,NULL,15.00),(15,15,'2022-06-11','01',0,NULL,NULL,NULL,NULL,15.00),(16,16,'2022-06-11','01',0,NULL,NULL,NULL,NULL,15.00),(18,18,'2022-06-11','01',0,NULL,NULL,NULL,NULL,15.00),(19,19,'2022-06-29','01',0,NULL,NULL,NULL,0.00,18.00),(20,20,'2022-06-29','01',0,NULL,NULL,NULL,0.00,18.00),(21,21,'2022-06-30','01',0,NULL,NULL,NULL,0.00,45.00),(22,22,'2022-06-30','01',0,NULL,NULL,NULL,0.00,45.00),(23,23,'2022-07-03','01',0,NULL,NULL,NULL,NULL,13.00),(24,24,'2022-07-08','01',0,NULL,NULL,NULL,0.00,85.50),(25,25,'2022-07-10','01',0,NULL,NULL,NULL,0.00,60.00),(26,26,'2022-07-12','01',0,NULL,NULL,NULL,NULL,47.00),(27,27,'2022-07-18','01',0,NULL,NULL,NULL,0.00,8.00),(28,28,'2022-07-18','01',0,NULL,NULL,NULL,0.00,53.00),(29,29,'2022-07-21','01',0,NULL,NULL,NULL,0.00,25.00),(30,30,'2022-07-25','01',0,NULL,NULL,NULL,0.00,35.00),(31,31,'2022-07-28','01',0,NULL,NULL,NULL,0.00,71.00),(32,32,'2022-07-28','01',0,NULL,NULL,NULL,0.00,44.00),(33,33,'2022-07-29','01',0,NULL,NULL,NULL,0.00,42.00),(34,34,'2022-07-31','01',0,NULL,NULL,NULL,0.00,49.00),(35,35,'2022-08-02','01',0,NULL,NULL,NULL,0.00,57.00),(36,36,'2022-08-02','01',0,NULL,NULL,NULL,0.00,80.00),(37,37,'2022-08-03','01',0,NULL,NULL,NULL,0.00,20.00),(38,38,'2022-08-03','01',0,NULL,NULL,NULL,0.00,19.00),(39,39,'2022-08-04','01',0,NULL,NULL,NULL,0.00,95.00),(40,40,'2022-08-07','01',0,NULL,NULL,NULL,0.00,16.00),(41,41,'2022-08-07','01',0,NULL,NULL,NULL,0.00,33.00),(42,42,'2022-08-09','01',0,NULL,NULL,NULL,0.00,36.00),(43,43,'2022-08-09','01',0,NULL,NULL,NULL,0.00,15.00),(44,44,'2022-08-11','01',0,NULL,NULL,NULL,0.00,39.00),(45,45,'2022-08-12','01',0,NULL,NULL,NULL,0.00,113.00),(46,46,'2022-08-15','01',0,NULL,NULL,NULL,0.00,47.00),(47,47,'2022-08-16','01',0,NULL,NULL,NULL,0.00,37.00),(48,48,'2022-08-25','01',0,NULL,NULL,NULL,0.00,77.00),(49,49,'2022-08-27','01',0,NULL,NULL,NULL,0.00,50.00),(50,50,'2022-08-27','01',0,NULL,NULL,NULL,0.00,36.00),(51,51,'2022-08-31','01',0,NULL,NULL,NULL,0.00,50.00),(52,52,'2022-09-01','01',0,NULL,NULL,NULL,0.00,28.00),(53,53,'2022-09-01','01',0,NULL,NULL,NULL,0.00,73.00),(54,54,'2022-09-01','01',0,NULL,NULL,NULL,0.00,20.00),(55,55,'2022-09-03','01',0,NULL,NULL,NULL,0.00,30.00),(56,56,'2022-09-03','01',0,NULL,NULL,NULL,0.00,20.00),(57,57,'2022-09-03','01',0,NULL,NULL,NULL,0.00,30.00),(58,58,'2022-09-03','01',0,NULL,NULL,NULL,0.00,30.00),(59,59,'2022-09-02','01',0,NULL,NULL,NULL,0.00,30.00),(60,60,'2022-09-02','01',0,NULL,NULL,NULL,0.00,30.00),(61,61,'2022-09-03','01',0,NULL,NULL,NULL,0.00,30.00),(62,62,'2022-09-12','01',0,NULL,NULL,NULL,0.00,18.00),(63,63,'2022-09-18','01',0,NULL,NULL,NULL,0.00,100.00),(64,64,'2022-09-26','01',0,NULL,NULL,NULL,0.00,36.00),(65,65,'2022-09-27','01',0,NULL,NULL,NULL,0.00,21.00),(66,66,'2022-09-27','01',0,NULL,NULL,NULL,0.00,21.00),(67,67,'2022-09-28','01',0,NULL,NULL,NULL,0.00,39.00),(68,68,'2022-09-28','01',0,NULL,NULL,NULL,0.00,39.00),(69,69,'2022-10-14','01',0,NULL,NULL,NULL,0.00,38.00),(70,70,'2022-10-14','01',0,NULL,NULL,NULL,0.00,38.00),(71,71,'2022-10-28','01',0,NULL,NULL,NULL,NULL,100.00),(72,79,'2022-11-11','01',0,NULL,NULL,NULL,NULL,40.00),(73,80,'2022-11-11','01',0,NULL,NULL,NULL,NULL,40.00),(74,81,'2022-11-15','01',0,NULL,NULL,NULL,NULL,55.00),(75,82,'2022-11-16','01',0,NULL,NULL,NULL,NULL,25.00),(76,83,'2022-11-16','01',0,NULL,NULL,NULL,NULL,25.00),(77,84,'2022-11-20','01',0,NULL,NULL,1,NULL,40.00),(78,85,'2022-11-21','01',0,NULL,NULL,1,NULL,35.00),(79,86,'2022-11-21','01',0,NULL,NULL,1,NULL,35.00),(80,87,'2022-11-21','01',0,NULL,NULL,1,NULL,35.00),(81,88,'2022-11-27','01',0,NULL,NULL,1,NULL,35.00),(82,89,'2022-11-27','01',0,NULL,NULL,1,NULL,35.00),(83,90,'2022-12-21','01',0,NULL,NULL,1,NULL,54.00),(84,91,'2022-12-25','01',0,NULL,NULL,1,NULL,50.00),(85,92,'2022-12-29','01',0,NULL,NULL,1,NULL,70.00),(86,93,'2022-12-31','01',0,NULL,NULL,1,NULL,350.00),(87,94,'2022-12-31','01',0,NULL,NULL,1,NULL,570.00),(88,95,'2022-12-31','01',0,NULL,NULL,1,NULL,700.00),(89,96,'2022-12-31','01',0,NULL,NULL,1,NULL,580.00),(90,97,'2022-12-31','01',0,NULL,NULL,1,NULL,556.00),(91,98,'2022-12-31','01',0,NULL,NULL,1,NULL,540.00),(92,99,'2023-01-01','01',0,NULL,NULL,1,NULL,950.00),(93,100,'2022-07-18','01',0,NULL,NULL,NULL,NULL,13.00),(94,101,'2023-02-03','01',0,NULL,NULL,1,NULL,35.00),(95,102,'2023-02-24','01',0,NULL,NULL,1,NULL,63.00),(96,103,'2023-02-26','01',0,NULL,NULL,1,NULL,24.00);

--
-- Table structure for table `document_transports`
--

CREATE TABLE `document_transports` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `document_id` int(10) unsigned NOT NULL,
  `seat_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `passenger_manifest` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `identity_document_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number_identity_document` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `passenger_fullname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `origin_district_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`origin_district_id`)),
  `origin_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `destinatation_district_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`destinatation_district_id`)),
  `destinatation_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `document_transports_document_id_foreign` (`document_id`),
  KEY `document_transports_identity_document_type_id_foreign` (`identity_document_type_id`),
  CONSTRAINT `document_transports_document_id_foreign` FOREIGN KEY (`document_id`) REFERENCES `documents` (`id`) ON DELETE CASCADE,
  CONSTRAINT `document_transports_identity_document_type_id_foreign` FOREIGN KEY (`identity_document_type_id`) REFERENCES `cat_identity_document_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `document_transports`
--


--
-- Table structure for table `documentary_actions`
--

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

--
-- Dumping data for table `documentary_actions`
--


--
-- Table structure for table `documentary_documents`
--

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

--
-- Dumping data for table `documentary_documents`
--


--
-- Table structure for table `documentary_file_offices`
--

CREATE TABLE `documentary_file_offices` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `documentary_file_id` int(10) unsigned NOT NULL,
  `documentary_office_id` int(10) unsigned NOT NULL,
  `documentary_action_id` int(10) unsigned NOT NULL DEFAULT 0,
  `status` enum('POR DERIVAR','POR RECIBIR','EN PROCESO','FINALIZADO','ARCHIVADO') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'POR DERIVAR',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `office_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Nombre de la etapa',
  `process_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Nombre del tramite',
  `documentary_process_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Tramite relacionado',
  `complete` int(11) NOT NULL DEFAULT 0 COMMENT 'Define si la etapa esta completa',
  `start_date` datetime DEFAULT NULL COMMENT 'Fecha de inicio',
  `end_date` datetime DEFAULT NULL COMMENT 'Fecha de finalizacion',
  `days` int(10) unsigned DEFAULT 0 COMMENT 'dias para el tramite',
  `observation` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `documentary_file_offices_documentary_file_id_foreign` (`documentary_file_id`),
  KEY `documentary_file_offices_documentary_office_id_foreign` (`documentary_office_id`),
  KEY `documentary_file_offices_documentary_action_id_foreign` (`documentary_action_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `documentary_file_offices`
--


--
-- Table structure for table `documentary_files`
--

CREATE TABLE `documentary_files` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned DEFAULT NULL,
  `documentary_document_id` int(10) unsigned DEFAULT 0,
  `documentary_process_id` int(10) unsigned NOT NULL,
  `number` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` int(10) unsigned NOT NULL,
  `invoice` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_register` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `time_register` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL,
  `person_id` int(10) unsigned NOT NULL,
  `sender` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attached_file` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `observation` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('RECIBIDO','DERIVADO','FINALIZADO','ARCHIVADO') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RECIBIDO',
  `documentary_office_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Define el ultimo proceso',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `requirements` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_archive` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'define si el tramite es simplificado',
  `is_simplify` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'define si el tramite es simplificado',
  `documentary_guides_number_status_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Cuando es simplificado, se usará este status',
  `is_completed` tinyint(1) NOT NULL DEFAULT 0,
  `establishment_id` int(10) unsigned NOT NULL DEFAULT 0,
  `date_end` datetime DEFAULT NULL COMMENT 'Fecha de finalización',
  PRIMARY KEY (`id`),
  KEY `documentary_files_documentary_document_id_foreign` (`documentary_document_id`),
  KEY `documentary_files_documentary_process_id_foreign` (`documentary_process_id`),
  KEY `documentary_files_person_id_foreign` (`person_id`),
  KEY `documentary_files_user_id_foreign` (`user_id`),
  CONSTRAINT `documentary_files_documentary_process_id_foreign` FOREIGN KEY (`documentary_process_id`) REFERENCES `documentary_processes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `documentary_files_person_id_foreign` FOREIGN KEY (`person_id`) REFERENCES `persons` (`id`) ON DELETE CASCADE,
  CONSTRAINT `documentary_files_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `documentary_files`
--


--
-- Table structure for table `documentary_files_archives`
--

CREATE TABLE `documentary_files_archives` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'usuario asociado',
  `documentary_file_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Solicitud asociada',
  `documentary_office_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'etapa asociada',
  `observation` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'observacion',
  `attached_file` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'etapa asociada',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `documentary_guides_number_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `documentary_files_archives`
--


--
-- Table structure for table `documentary_files_requirements`
--

CREATE TABLE `documentary_files_requirements` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Nombre a mostrar',
  `file` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Define si tiene archivo',
  `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 `documentary_files_requirements`
--


--
-- Table structure for table `documentary_guides_number`
--

CREATE TABLE `documentary_guides_number` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `doc_file_id` int(10) unsigned DEFAULT 0 COMMENT 'Expediente relacionado',
  `doc_office_id` int(10) unsigned DEFAULT 0 COMMENT 'Etapa observada',
  `guide` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Especifica la guia',
  `origin` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Especifica la instucion',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `date_of_due` datetime DEFAULT NULL,
  `observation` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_take` datetime DEFAULT NULL COMMENT 'Fecha estimada de finalización',
  `date_end` datetime DEFAULT NULL COMMENT 'Fecha de finalización',
  `documentary_guides_number_status_id` int(10) unsigned DEFAULT 0 COMMENT 'relacionado con documentary_guides_number_status',
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Responsable',
  `total_day` int(10) unsigned DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `documentary_guides_number`
--


--
-- Table structure for table `documentary_guides_number_status`
--

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

--
-- Dumping data for table `documentary_guides_number_status`
--

INSERT INTO `documentary_guides_number_status` VALUES (1,'En Calificación',NULL),(2,'Concluidos',NULL),(3,'Observados',NULL),(4,'Archivados',NULL);

--
-- Table structure for table `documentary_observation`
--

CREATE TABLE `documentary_observation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `doc_file_id` int(10) unsigned DEFAULT 0 COMMENT 'Expediente relacionado',
  `observation` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Conjunto de etapas.',
  `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 `documentary_observation`
--


--
-- Table structure for table `documentary_offices`
--

CREATE TABLE `documentary_offices` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `days` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `default` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `documentary_offices`
--

INSERT INTO `documentary_offices` VALUES (1,'Caja','',1,'2022-05-19 10:09:22','2022-05-19 10:09:22',0,0,NULL),(2,'Procesos','',1,'2022-05-19 10:09:22','2022-05-19 10:09:22',0,0,NULL),(3,'Seguimiento','',1,'2022-05-19 10:09:22','2022-05-19 10:09:22',0,0,NULL),(4,'Validacion','',1,'2022-05-19 10:09:22','2022-05-19 10:09:22',0,0,NULL);

--
-- Table structure for table `documentary_processes`
--

CREATE TABLE `documentary_processes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` decimal(10,5) NOT NULL DEFAULT 0.00000,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `documentary_offices` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'etapas que contiene',
  `documentary_offices_order` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `documentary_processes`
--


--
-- Table structure for table `documentary_processes_rel_file`
--

CREATE TABLE `documentary_processes_rel_file` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `doc_processes_id` int(10) unsigned DEFAULT 0 COMMENT 'Requerimiento relacionado',
  `doc_file_id` int(10) unsigned DEFAULT 0 COMMENT 'Expediente relacionado',
  `doc_office_id` int(10) unsigned DEFAULT 0 COMMENT 'Etapa actual',
  `stages` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Conjunto de etapas.',
  `complete` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Define si se ha completado',
  `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 `documentary_processes_rel_file`
--


--
-- Table structure for table `documentary_processes_rel_off`
--

CREATE TABLE `documentary_processes_rel_off` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `doc_processes_id` int(10) unsigned DEFAULT 0 COMMENT 'Requerimiento relacionado',
  `doc_offices_id` int(10) unsigned DEFAULT 0 COMMENT 'Proceso relacionado',
  `active` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Status de la relacion',
  `order` int(10) unsigned DEFAULT 1 COMMENT 'Establece el orden del proceso',
  `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 `documentary_processes_rel_off`
--


--
-- Table structure for table `documentary_processes_rel_req`
--

CREATE TABLE `documentary_processes_rel_req` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `doc_processes_id` int(10) unsigned DEFAULT 0 COMMENT 'Requerimiento relacionado',
  `doc_files_requirements_id` int(10) unsigned DEFAULT 0 COMMENT 'Proceso relacionado',
  `active` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Status de la relacion',
  `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 `documentary_processes_rel_req`
--


--
-- Table structure for table `documents`
--

CREATE TABLE `documents` (
  `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,
  `ticket_single_shipment` tinyint(1) NOT NULL DEFAULT 0,
  `force_send_by_summary` tinyint(1) NOT NULL DEFAULT 0,
  `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,
  `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_condition_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_method_type_id` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `purchase_order` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plate_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quotation_id` int(10) unsigned DEFAULT NULL,
  `sale_note_id` int(10) unsigned DEFAULT NULL,
  `user_rel_suscription_plan_id` int(10) unsigned DEFAULT 0 COMMENT 'Relacion con suscripciones',
  `technical_service_id` int(10) unsigned DEFAULT NULL,
  `order_note_id` int(10) unsigned DEFAULT NULL,
  `dispatch_id` int(10) unsigned DEFAULT NULL,
  `seller_id` int(10) unsigned DEFAULT NULL,
  `exchange_rate_sale` decimal(13,3) NOT NULL,
  `point_system` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'indica si el documento 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`)),
  `automatic_date_of_issue` date DEFAULT NULL,
  `type_period` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity_period` int(11) DEFAULT NULL,
  `enabled_concurrency` tinyint(3) unsigned DEFAULT 0,
  `apply_concurrency` tinyint(3) unsigned DEFAULT 0,
  `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,
  `has_prepayment` tinyint(1) NOT NULL DEFAULT 0,
  `affectation_type_prepayment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `was_deducted_prepayment` tinyint(1) NOT NULL DEFAULT 0,
  `pending_amount_prepayment` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_pending_payment` decimal(12,2) NOT NULL DEFAULT 0.00,
  `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`)),
  `retention` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`retention`)),
  `legends` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`legends`)),
  `additional_information` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `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,
  `unique_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qr` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT ' ',
  `reference_data` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agent_id` int(10) unsigned 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,
  `data_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`data_json`)),
  `send_server` tinyint(1) NOT NULL DEFAULT 1,
  `success_shipping_status` tinyint(1) NOT NULL DEFAULT 0,
  `shipping_status` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`shipping_status`)),
  `success_sunat_shipping_status` tinyint(1) NOT NULL DEFAULT 0,
  `sunat_shipping_status` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`sunat_shipping_status`)),
  `query_status` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`query_status`)),
  `success_query_status` tinyint(1) NOT NULL DEFAULT 0,
  `total_canceled` tinyint(1) NOT NULL DEFAULT 0,
  `soap_shipping_response` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`soap_shipping_response`)),
  `regularize_shipping` tinyint(1) NOT NULL DEFAULT 0,
  `response_regularize_shipping` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`response_regularize_shipping`)),
  `send_to_pse` tinyint(1) NOT NULL DEFAULT 0,
  `response_signature_pse` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`response_signature_pse`)),
  `response_send_cdr_pse` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`response_send_cdr_pse`)),
  `sale_notes_relateds` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'registros asociados cuando se genera cpe desde multiples notas de venta' CHECK (json_valid(`sale_notes_relateds`)),
  `terms_condition` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `folio` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_editable` tinyint(1) NOT NULL 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',
  PRIMARY KEY (`id`),
  UNIQUE KEY `documents_unique_filename_unique` (`unique_filename`),
  KEY `documents_user_id_foreign` (`user_id`),
  KEY `documents_establishment_id_foreign` (`establishment_id`),
  KEY `documents_customer_id_foreign` (`customer_id`),
  KEY `documents_soap_type_id_foreign` (`soap_type_id`),
  KEY `documents_state_type_id_foreign` (`state_type_id`),
  KEY `documents_group_id_foreign` (`group_id`),
  KEY `documents_document_type_id_foreign` (`document_type_id`),
  KEY `documents_currency_type_id_foreign` (`currency_type_id`),
  KEY `documents_quotation_id_foreign` (`quotation_id`),
  KEY `documents_external_id_index` (`external_id`),
  KEY `documents_sale_note_id_foreign` (`sale_note_id`),
  KEY `documents_series_index` (`series`),
  KEY `documents_number_index` (`number`),
  KEY `documents_date_of_issue_index` (`date_of_issue`),
  KEY `documents_order_note_id_foreign` (`order_note_id`),
  KEY `documents_payment_method_type_id_foreign` (`payment_method_type_id`),
  KEY `documents_seller_id_foreign` (`seller_id`),
  KEY `documents_payment_condition_id_foreign` (`payment_condition_id`),
  KEY `documents_dispatch_id_foreign` (`dispatch_id`),
  KEY `documents_technical_service_id_foreign` (`technical_service_id`),
  KEY `documents_type_period_index` (`type_period`),
  KEY `documents_regularize_shipping_index` (`regularize_shipping`),
  KEY `documents_ticket_single_shipment_index` (`ticket_single_shipment`),
  KEY `documents_agent_id_foreign` (`agent_id`),
  KEY `documents_force_send_by_summary_index` (`force_send_by_summary`),
  CONSTRAINT `documents_agent_id_foreign` FOREIGN KEY (`agent_id`) REFERENCES `agents` (`id`),
  CONSTRAINT `documents_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`),
  CONSTRAINT `documents_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `documents_dispatch_id_foreign` FOREIGN KEY (`dispatch_id`) REFERENCES `dispatches` (`id`),
  CONSTRAINT `documents_document_type_id_foreign` FOREIGN KEY (`document_type_id`) REFERENCES `cat_document_types` (`id`),
  CONSTRAINT `documents_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`),
  CONSTRAINT `documents_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`),
  CONSTRAINT `documents_order_note_id_foreign` FOREIGN KEY (`order_note_id`) REFERENCES `order_notes` (`id`),
  CONSTRAINT `documents_payment_condition_id_foreign` FOREIGN KEY (`payment_condition_id`) REFERENCES `payment_conditions` (`id`),
  CONSTRAINT `documents_payment_method_type_id_foreign` FOREIGN KEY (`payment_method_type_id`) REFERENCES `payment_method_types` (`id`),
  CONSTRAINT `documents_quotation_id_foreign` FOREIGN KEY (`quotation_id`) REFERENCES `quotations` (`id`),
  CONSTRAINT `documents_sale_note_id_foreign` FOREIGN KEY (`sale_note_id`) REFERENCES `sale_notes` (`id`),
  CONSTRAINT `documents_seller_id_foreign` FOREIGN KEY (`seller_id`) REFERENCES `users` (`id`),
  CONSTRAINT `documents_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `documents_state_type_id_foreign` FOREIGN KEY (`state_type_id`) REFERENCES `state_types` (`id`),
  CONSTRAINT `documents_technical_service_id_foreign` FOREIGN KEY (`technical_service_id`) REFERENCES `technical_services` (`id`),
  CONSTRAINT `documents_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `documents`
--

INSERT INTO `documents` VALUES (7,1,'d3b2217b-de4f-4da3-97e1-427695a6445e',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"01\",\"department\":{\"id\":\"01\",\"description\":\"AMAZONAS\"},\"province_id\":\"0107\",\"province\":{\"id\":\"0107\",\"description\":\"Utcubamba\"},\"district_id\":\"010701\",\"district\":{\"id\":\"010701\",\"description\":\"Bagua Grande\"},\"urbanization\":null,\"address\":\"Jr. Jorge chavez N\\u00b0 340\",\"email\":\"asia@softlte.net.pe\",\"telephone\":\"976 656 837\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','09','2.1',0,0,'01','01','F001',1,'2022-06-01','20:25:30',5,'{\"identity_document_type_id\":\"6\",\"identity_document_type\":{\"id\":\"6\",\"description\":\"RUC\"},\"number\":\"20494079713\",\"name\":\"GREPCO S.A.C.\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"22\",\"department\":{\"id\":\"22\",\"description\":\"SAN MARTIN\"},\"province_id\":\"2205\",\"province\":{\"id\":\"2205\",\"description\":\"Lamas\"},\"district_id\":\"220501\",\"district\":{\"id\":\"220501\",\"description\":\"Lamas\"},\"address\":\"JR. MISS MEGAN NRO. 110\",\"email\":null,\"telephone\":null,\"perception_agent\":false,\"address_id\":null,\"internal_code\":null,\"address_type_id\":null,\"address_type\":{\"id\":null,\"description\":null}}','PEN','01',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,1,1.000,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,38.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,38.00,38.00,38.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Treinta y ocho  con 00\\/100 \"}]',NULL,NULL,'20602518893-01-F001-1','20602518893-01-F001-1','EH7wIiG5lYJr/G3nUAAYmvhUM/8=','[encoded data, 90460 characters]',NULL,NULL,0,0,0,'{\"serie_documento\":\"F001\",\"numero_documento\":\"#\",\"fecha_de_emision\":\"2022-06-01\",\"hora_de_emision\":\"20:25:30\",\"codigo_tipo_operacion\":\"0101\",\"codigo_tipo_documento\":\"01\",\"codigo_tipo_moneda\":\"PEN\",\"fecha_de_vencimiento\":\"2022-06-01\",\"datos_del_cliente_o_receptor\":{\"codigo_tipo_documento_identidad\":\"6\",\"numero_documento\":\"20494079713\",\"apellidos_y_nombres_o_razon_social\":\"GREPCO S.A.C.\",\"codigo_pais\":\"PE\",\"ubigeo\":\"220501\",\"direccion\":\"JR. MISS MEGAN NRO. 110\",\"correo_electronico\":null,\"telefono\":null},\"codigo_condicion_de_pago\":\"01\",\"cpe_app\":true,\"pagos\":[{\"codigo_destino_pago\":\"cash\",\"codigo_metodo_pago\":\"01\",\"cambio\":0,\"monto\":38}],\"cuotas\":[],\"totales\":{\"total_exportacion\":0,\"total_operaciones_gravadas\":0,\"total_operaciones_inafectas\":0,\"total_operaciones_exoneradas\":38,\"total_operaciones_gratuitas\":0,\"total_impuestos_bolsa_plastica\":0,\"total_igv\":0,\"total_impuestos\":0,\"total_valor\":38,\"total_venta\":38},\"items\":[{\"codigo_interno\":\"BI17\",\"descripcion\":\"AEROPUERTO DE CHANCHO\",\"nombre_producto_pdf\":\"AEROPUERTO DE CHANCHO\",\"codigo_producto_sunat\":null,\"unidad_de_medida\":\"NIU\",\"cantidad\":1,\"valor_unitario\":15,\"codigo_tipo_precio\":\"01\",\"precio_unitario\":15,\"codigo_tipo_afectacion_igv\":\"20\",\"total_base_igv\":15,\"porcentaje_igv\":18,\"total_igv\":0,\"total_impuestos_bolsa_plastica\":0,\"total_impuestos\":0,\"total_valor_item\":15,\"total_item\":15,\"actualizar_descripcion\":false},{\"codigo_interno\":\"BI17\",\"descripcion\":\"AEROPUERTO DE CHANCHO\",\"nombre_producto_pdf\":\"AEROPUERTO DE CHANCHO\",\"codigo_producto_sunat\":null,\"unidad_de_medida\":\"NIU\",\"cantidad\":1,\"valor_unitario\":15,\"codigo_tipo_precio\":\"01\",\"precio_unitario\":15,\"codigo_tipo_afectacion_igv\":\"20\",\"total_base_igv\":15,\"porcentaje_igv\":18,\"total_igv\":0,\"total_impuestos_bolsa_plastica\":0,\"total_impuestos\":0,\"total_valor_item\":15,\"total_item\":15,\"actualizar_descripcion\":false},{\"codigo_interno\":\"BI176\",\"descripcion\":\"CHICHA 1 JARRA\",\"nombre_producto_pdf\":\"CHICHA 1 JARRA\",\"codigo_producto_sunat\":null,\"unidad_de_medida\":\"NIU\",\"cantidad\":1,\"valor_unitario\":8,\"codigo_tipo_precio\":\"01\",\"precio_unitario\":8,\"codigo_tipo_afectacion_igv\":\"20\",\"total_base_igv\":8,\"porcentaje_igv\":18,\"total_igv\":0,\"total_impuestos_bolsa_plastica\":0,\"total_impuestos\":0,\"total_valor_item\":8,\"total_item\":8,\"actualizar_descripcion\":false}]}',0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"2108\",\"description\":\"Presentacion fuera de fecha - Presentacion fuera de fecha\\n            Detalle:\\n            xxx.xxx.xxx value=\'ticket: 202209373885232 error: Limite maximo de 3 d\\u00edas, d\\u00edas despues de la emision 10.0\'\",\"notes\":[]}',1,'{\"code\":\"0102\",\"description\":\"Usuario o contrase\\u00f1a incorrectos\"}',0,NULL,NULL,NULL,'',NULL,'2022-06-01 20:32:35','2022-06-11 21:23:39',1,NULL,NULL),(8,1,'16709c4f-2cc6-4a7b-9fc6-9c4f77108574',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"01\",\"department\":{\"id\":\"01\",\"description\":\"AMAZONAS\"},\"province_id\":\"0107\",\"province\":{\"id\":\"0107\",\"description\":\"Utcubamba\"},\"district_id\":\"010701\",\"district\":{\"id\":\"010701\",\"description\":\"Bagua Grande\"},\"urbanization\":null,\"address\":\"Jr. Jorge chavez N\\u00b0 340\",\"email\":\"asia@softlte.net.pe\",\"telephone\":\"976 656 837\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','09','2.1',0,0,'01','01','F001',2,'2022-06-01','20:35:58',5,'{\"identity_document_type_id\":\"6\",\"identity_document_type\":{\"id\":\"6\",\"description\":\"RUC\"},\"number\":\"20494079713\",\"name\":\"GREPCO S.A.C.\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"22\",\"department\":{\"id\":\"22\",\"description\":\"SAN MARTIN\"},\"province_id\":\"2205\",\"province\":{\"id\":\"2205\",\"description\":\"Lamas\"},\"district_id\":\"220501\",\"district\":{\"id\":\"220501\",\"description\":\"Lamas\"},\"address\":\"JR. MISS MEGAN NRO. 110\",\"email\":null,\"telephone\":null,\"perception_agent\":false,\"address_id\":null,\"internal_code\":null,\"address_type_id\":null,\"address_type\":{\"id\":null,\"description\":null}}','PEN','01',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,1,1.000,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,38.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,38.00,38.00,38.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Treinta y ocho  con 00\\/100 \"}]',NULL,NULL,'20602518893-01-F001-2','20602518893-01-F001-2','ZM9RkvZdLlRbSXp72X0AXZMZzak=','[encoded data, 90460 characters]',NULL,NULL,0,0,0,'{\"serie_documento\":\"F001\",\"numero_documento\":\"#\",\"fecha_de_emision\":\"2022-06-01\",\"hora_de_emision\":\"20:35:58\",\"codigo_tipo_operacion\":\"0101\",\"codigo_tipo_documento\":\"01\",\"codigo_tipo_moneda\":\"PEN\",\"fecha_de_vencimiento\":\"2022-06-01\",\"datos_del_cliente_o_receptor\":{\"codigo_tipo_documento_identidad\":\"6\",\"numero_documento\":\"20494079713\",\"apellidos_y_nombres_o_razon_social\":\"GREPCO S.A.C.\",\"codigo_pais\":\"PE\",\"ubigeo\":\"220501\",\"direccion\":\"JR. MISS MEGAN NRO. 110\",\"correo_electronico\":null,\"telefono\":null},\"codigo_condicion_de_pago\":\"01\",\"cpe_app\":true,\"pagos\":[{\"codigo_destino_pago\":\"cash\",\"codigo_metodo_pago\":\"01\",\"cambio\":0,\"monto\":38}],\"cuotas\":[],\"totales\":{\"total_exportacion\":0,\"total_operaciones_gravadas\":0,\"total_operaciones_inafectas\":0,\"total_operaciones_exoneradas\":38,\"total_operaciones_gratuitas\":0,\"total_impuestos_bolsa_plastica\":0,\"total_igv\":0,\"total_impuestos\":0,\"total_valor\":38,\"total_venta\":38},\"items\":[{\"codigo_interno\":\"BI17\",\"descripcion\":\"AEROPUERTO DE CHANCHO\",\"nombre_producto_pdf\":\"AEROPUERTO DE CHANCHO\",\"codigo_producto_sunat\":null,\"unidad_de_medida\":\"NIU\",\"cantidad\":1,\"valor_unitario\":15,\"codigo_tipo_precio\":\"01\",\"precio_unitario\":15,\"codigo_tipo_afectacion_igv\":\"20\",\"total_base_igv\":15,\"porcentaje_igv\":18,\"total_igv\":0,\"total_impuestos_bolsa_plastica\":0,\"total_impuestos\":0,\"total_valor_item\":15,\"total_item\":15,\"actualizar_descripcion\":false},{\"codigo_interno\":\"BI17\",\"descripcion\":\"AEROPUERTO DE CHANCHO\",\"nombre_producto_pdf\":\"AEROPUERTO DE CHANCHO\",\"codigo_producto_sunat\":null,\"unidad_de_medida\":\"NIU\",\"cantidad\":1,\"valor_unitario\":15,\"codigo_tipo_precio\":\"01\",\"precio_unitario\":15,\"codigo_tipo_afectacion_igv\":\"20\",\"total_base_igv\":15,\"porcentaje_igv\":18,\"total_igv\":0,\"total_impuestos_bolsa_plastica\":0,\"total_impuestos\":0,\"total_valor_item\":15,\"total_item\":15,\"actualizar_descripcion\":false},{\"codigo_interno\":\"BI176\",\"descripcion\":\"CHICHA 1 JARRA\",\"nombre_producto_pdf\":\"CHICHA 1 JARRA\",\"codigo_producto_sunat\":null,\"unidad_de_medida\":\"NIU\",\"cantidad\":1,\"valor_unitario\":8,\"codigo_tipo_precio\":\"01\",\"precio_unitario\":8,\"codigo_tipo_afectacion_igv\":\"20\",\"total_base_igv\":8,\"porcentaje_igv\":18,\"total_igv\":0,\"total_impuestos_bolsa_plastica\":0,\"total_impuestos\":0,\"total_valor_item\":8,\"total_item\":8,\"actualizar_descripcion\":false}]}',0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"2108\",\"description\":\"Presentacion fuera de fecha - Presentacion fuera de fecha\\n            Detalle:\\n            xxx.xxx.xxx value=\'ticket: 202209373885891 error: Limite maximo de 3 d\\u00edas, d\\u00edas despues de la emision 10.0\'\",\"notes\":[]}',1,'{\"code\":\"0102\",\"description\":\"Usuario o contrase\\u00f1a incorrectos\"}',0,NULL,NULL,NULL,'',NULL,'2022-06-01 20:37:34','2022-06-11 21:23:48',1,NULL,NULL),(9,1,'2ee97c9f-37f0-4756-8f81-2013ebc748de',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"01\",\"department\":{\"id\":\"01\",\"description\":\"AMAZONAS\"},\"province_id\":\"0107\",\"province\":{\"id\":\"0107\",\"description\":\"Utcubamba\"},\"district_id\":\"010701\",\"district\":{\"id\":\"010701\",\"description\":\"Bagua Grande\"},\"urbanization\":null,\"address\":\"Jr. Jorge chavez N\\u00b0 340\",\"email\":\"asia@softlte.net.pe\",\"telephone\":\"976 656 837\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','09','2.1',0,0,'01','01','F001',3,'2022-06-01','20:38:27',5,'{\"identity_document_type_id\":\"6\",\"identity_document_type\":{\"id\":\"6\",\"description\":\"RUC\"},\"number\":\"20494079713\",\"name\":\"GREPCO S.A.C.\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"22\",\"department\":{\"id\":\"22\",\"description\":\"SAN MARTIN\"},\"province_id\":\"2205\",\"province\":{\"id\":\"2205\",\"description\":\"Lamas\"},\"district_id\":\"220501\",\"district\":{\"id\":\"220501\",\"description\":\"Lamas\"},\"address\":\"JR. MISS MEGAN NRO. 110\",\"email\":null,\"telephone\":null,\"perception_agent\":false,\"address_id\":null,\"internal_code\":null,\"address_type_id\":null,\"address_type\":{\"id\":null,\"description\":null}}','PEN','01',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,1,1.000,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,38.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,38.00,38.00,38.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Treinta y ocho  con 00\\/100 \"}]',NULL,NULL,'20602518893-01-F001-3','20602518893-01-F001-3','NQKC1iGHa/YRr+gt4axDqli5L+A=','[encoded data, 90460 characters]',NULL,NULL,0,0,0,'{\"serie_documento\":\"F001\",\"numero_documento\":\"#\",\"fecha_de_emision\":\"2022-06-01\",\"hora_de_emision\":\"20:38:27\",\"codigo_tipo_operacion\":\"0101\",\"codigo_tipo_documento\":\"01\",\"codigo_tipo_moneda\":\"PEN\",\"fecha_de_vencimiento\":\"2022-06-01\",\"datos_del_cliente_o_receptor\":{\"codigo_tipo_documento_identidad\":\"6\",\"numero_documento\":\"20494079713\",\"apellidos_y_nombres_o_razon_social\":\"GREPCO S.A.C.\",\"codigo_pais\":\"PE\",\"ubigeo\":\"220501\",\"direccion\":\"JR. MISS MEGAN NRO. 110\",\"correo_electronico\":null,\"telefono\":null},\"codigo_condicion_de_pago\":\"01\",\"cpe_app\":true,\"pagos\":[{\"codigo_destino_pago\":\"cash\",\"codigo_metodo_pago\":\"01\",\"cambio\":0,\"monto\":38}],\"cuotas\":[],\"totales\":{\"total_exportacion\":0,\"total_operaciones_gravadas\":0,\"total_operaciones_inafectas\":0,\"total_operaciones_exoneradas\":38,\"total_operaciones_gratuitas\":0,\"total_impuestos_bolsa_plastica\":0,\"total_igv\":0,\"total_impuestos\":0,\"total_valor\":38,\"total_venta\":38},\"items\":[{\"codigo_interno\":\"BI17\",\"descripcion\":\"AEROPUERTO DE CHANCHO\",\"nombre_producto_pdf\":\"AEROPUERTO DE CHANCHO\",\"codigo_producto_sunat\":null,\"unidad_de_medida\":\"NIU\",\"cantidad\":1,\"valor_unitario\":15,\"codigo_tipo_precio\":\"01\",\"precio_unitario\":15,\"codigo_tipo_afectacion_igv\":\"20\",\"total_base_igv\":15,\"porcentaje_igv\":18,\"total_igv\":0,\"total_impuestos_bolsa_plastica\":0,\"total_impuestos\":0,\"total_valor_item\":15,\"total_item\":15,\"actualizar_descripcion\":false},{\"codigo_interno\":\"BI17\",\"descripcion\":\"AEROPUERTO DE CHANCHO\",\"nombre_producto_pdf\":\"AEROPUERTO DE CHANCHO\",\"codigo_producto_sunat\":null,\"unidad_de_medida\":\"NIU\",\"cantidad\":1,\"valor_unitario\":15,\"codigo_tipo_precio\":\"01\",\"precio_unitario\":15,\"codigo_tipo_afectacion_igv\":\"20\",\"total_base_igv\":15,\"porcentaje_igv\":18,\"total_igv\":0,\"total_impuestos_bolsa_plastica\":0,\"total_impuestos\":0,\"total_valor_item\":15,\"total_item\":15,\"actualizar_descripcion\":false},{\"codigo_interno\":\"BI176\",\"descripcion\":\"CHICHA 1 JARRA\",\"nombre_producto_pdf\":\"CHICHA 1 JARRA\",\"codigo_producto_sunat\":null,\"unidad_de_medida\":\"NIU\",\"cantidad\":1,\"valor_unitario\":8,\"codigo_tipo_precio\":\"01\",\"precio_unitario\":8,\"codigo_tipo_afectacion_igv\":\"20\",\"total_base_igv\":8,\"porcentaje_igv\":18,\"total_igv\":0,\"total_impuestos_bolsa_plastica\":0,\"total_impuestos\":0,\"total_valor_item\":8,\"total_item\":8,\"actualizar_descripcion\":false}]}',0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"2108\",\"description\":\"Presentacion fuera de fecha - Presentacion fuera de fecha\\n            Detalle:\\n            xxx.xxx.xxx value=\'ticket: 202209373885122 error: Limite maximo de 3 d\\u00edas, d\\u00edas despues de la emision 10.0\'\",\"notes\":[]}',1,'{\"code\":\"0102\",\"description\":\"Usuario o contrase\\u00f1a incorrectos\"}',0,NULL,NULL,NULL,'',NULL,'2022-06-01 20:44:04','2022-06-11 21:23:37',1,NULL,NULL),(10,1,'6a74992b-b335-48a3-88a3-c03453e97b2f',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"01\",\"department\":{\"id\":\"01\",\"description\":\"AMAZONAS\"},\"province_id\":\"0107\",\"province\":{\"id\":\"0107\",\"description\":\"Utcubamba\"},\"district_id\":\"010701\",\"district\":{\"id\":\"010701\",\"description\":\"Bagua Grande\"},\"urbanization\":null,\"address\":\"Jr. Jorge chavez N\\u00b0 340\",\"email\":\"asia@softlte.net.pe\",\"telephone\":\"976 656 837\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','11','2.1',0,0,'01','01','F001',4,'2022-06-08','22:12:31',6,'{\"identity_document_type_id\":\"6\",\"identity_document_type\":{\"id\":\"6\",\"description\":\"RUC\"},\"number\":\"20103913340\",\"name\":\"ORVISA SOCIEDAD ANONIMA\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"16\",\"department\":{\"id\":\"16\",\"description\":\"LORETO\"},\"province_id\":\"1601\",\"province\":{\"id\":\"1601\",\"description\":\"Maynas\"},\"district_id\":\"160113\",\"district\":{\"id\":\"160113\",\"description\":\"San Juan Bautista\"},\"address\":\"AV. A.QUI\\u00d1ONEZ  KM. 2\",\"email\":null,\"telephone\":null,\"perception_agent\":false,\"address_id\":null,\"internal_code\":null,\"address_type_id\":null,\"address_type\":{\"id\":null,\"description\":null}}','PEN','01',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,1,1.000,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,22.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,22.00,22.00,22.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Veintidos  con 00\\/100 \"}]',NULL,NULL,'20602518893-01-F001-4','20602518893-01-F001-4','PlDl79WVz+M3J6S4p60WDVS1wEI=','[encoded data, 90460 characters]',NULL,NULL,0,0,0,'{\"serie_documento\":\"F001\",\"numero_documento\":\"#\",\"fecha_de_emision\":\"2022-06-08\",\"hora_de_emision\":\"22:12:31\",\"codigo_tipo_operacion\":\"0101\",\"codigo_tipo_documento\":\"01\",\"codigo_tipo_moneda\":\"PEN\",\"fecha_de_vencimiento\":\"2022-06-08\",\"datos_del_cliente_o_receptor\":{\"codigo_tipo_documento_identidad\":\"6\",\"numero_documento\":\"20103913340\",\"apellidos_y_nombres_o_razon_social\":\"ORVISA SOCIEDAD ANONIMA\",\"codigo_pais\":\"PE\",\"ubigeo\":\"160113\",\"direccion\":\"AV. A.QUI\\u00d1ONEZ  KM. 2\",\"correo_electronico\":null,\"telefono\":null},\"codigo_condicion_de_pago\":\"01\",\"cpe_app\":true,\"pagos\":[{\"codigo_destino_pago\":\"cash\",\"codigo_metodo_pago\":\"01\",\"cambio\":0,\"monto\":22}],\"cuotas\":[],\"totales\":{\"total_exportacion\":0,\"total_operaciones_gravadas\":0,\"total_operaciones_inafectas\":0,\"total_operaciones_exoneradas\":22,\"total_operaciones_gratuitas\":0,\"total_impuestos_bolsa_plastica\":0,\"total_igv\":0,\"total_impuestos\":0,\"total_valor\":22,\"total_venta\":22},\"items\":[{\"codigo_interno\":\"BI32\",\"descripcion\":\"TALLARIN TAYPA ESPECIAL\",\"nombre_producto_pdf\":\"TALLARIN TAYPA ESPECIAL\",\"codigo_producto_sunat\":null,\"unidad_de_medida\":\"NIU\",\"cantidad\":1,\"valor_unitario\":22,\"codigo_tipo_precio\":\"01\",\"precio_unitario\":22,\"codigo_tipo_afectacion_igv\":\"20\",\"total_base_igv\":22,\"porcentaje_igv\":18,\"total_igv\":0,\"total_impuestos_bolsa_plastica\":0,\"total_impuestos\":0,\"total_valor_item\":22,\"total_item\":22,\"actualizar_descripcion\":false}]}',0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Factura numero F001-4, ha sido aceptada\",\"notes\":[]}',1,'{\"code\":\"0102\",\"description\":\"Usuario o contrase\\u00f1a incorrectos\"}',0,NULL,NULL,NULL,'',NULL,'2022-06-08 22:18:49','2022-06-11 21:25:44',1,NULL,NULL),(11,1,'1a79482a-c493-4b26-9ffb-2a6af4f316bd',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"01\",\"department\":{\"id\":\"01\",\"description\":\"AMAZONAS\"},\"province_id\":\"0107\",\"province\":{\"id\":\"0107\",\"description\":\"Utcubamba\"},\"district_id\":\"010701\",\"district\":{\"id\":\"010701\",\"description\":\"Bagua Grande\"},\"urbanization\":null,\"address\":\"Jr. Jorge chavez N\\u00b0 340\",\"email\":\"asia@softlte.net.pe\",\"telephone\":\"976 656 837\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','11','2.1',0,0,'01','01','F001',5,'2022-06-10','23:10:33',7,'{\"identity_document_type_id\":\"6\",\"identity_document_type\":{\"id\":\"6\",\"description\":\"RUC\"},\"number\":\"20262786511\",\"name\":\"DROKASA PERU S.A.\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"15\",\"department\":{\"id\":\"15\",\"description\":\"LIMA\"},\"province_id\":\"1501\",\"province\":{\"id\":\"1501\",\"description\":\"Lima\"},\"district_id\":\"150120\",\"district\":{\"id\":\"150120\",\"description\":\"Magdalena del Mar\"},\"address\":\"JR. MARISCAL LA MAR NRO. 991\",\"email\":null,\"telephone\":null,\"perception_agent\":false,\"address_id\":null,\"internal_code\":null,\"address_type_id\":null,\"address_type\":{\"id\":null,\"description\":null}}','PEN','01',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,1,1.000,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,15.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,15.00,15.00,15.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Quince  con 00\\/100 \"}]',NULL,NULL,'20602518893-01-F001-5','20602518893-01-F001-5','3y4uQ8MY3IZrGBLlb8Zp+zpu9e4=','[encoded data, 90460 characters]',NULL,NULL,0,0,0,'{\"serie_documento\":\"F001\",\"numero_documento\":\"#\",\"fecha_de_emision\":\"2022-06-10\",\"hora_de_emision\":\"23:10:33\",\"codigo_tipo_operacion\":\"0101\",\"codigo_tipo_documento\":\"01\",\"codigo_tipo_moneda\":\"PEN\",\"fecha_de_vencimiento\":\"2022-06-10\",\"datos_del_cliente_o_receptor\":{\"codigo_tipo_documento_identidad\":\"6\",\"numero_documento\":\"20262786511\",\"apellidos_y_nombres_o_razon_social\":\"DROKASA PERU S.A.\",\"codigo_pais\":\"PE\",\"ubigeo\":\"150120\",\"direccion\":\"JR. MARISCAL LA MAR NRO. 991\",\"correo_electronico\":null,\"telefono\":null},\"codigo_condicion_de_pago\":\"01\",\"cpe_app\":true,\"pagos\":[{\"codigo_destino_pago\":\"cash\",\"codigo_metodo_pago\":\"01\",\"cambio\":0,\"monto\":15}],\"cuotas\":[],\"totales\":{\"total_exportacion\":0,\"total_operaciones_gravadas\":0,\"total_operaciones_inafectas\":0,\"total_operaciones_exoneradas\":15,\"total_operaciones_gratuitas\":0,\"total_impuestos_bolsa_plastica\":0,\"total_igv\":0,\"total_impuestos\":0,\"total_valor\":15,\"total_venta\":15},\"items\":[{\"codigo_interno\":\"BI233\",\"descripcion\":\"32 POLLO ENROLLADO + CHAUFA\",\"nombre_producto_pdf\":\"32 POLLO ENROLLADO + CHAUFA\",\"codigo_producto_sunat\":null,\"unidad_de_medida\":\"NIU\",\"cantidad\":1,\"valor_unitario\":15,\"codigo_tipo_precio\":\"01\",\"precio_unitario\":15,\"codigo_tipo_afectacion_igv\":\"20\",\"total_base_igv\":15,\"porcentaje_igv\":18,\"total_igv\":0,\"total_impuestos_bolsa_plastica\":0,\"total_impuestos\":0,\"total_valor_item\":15,\"total_item\":15,\"actualizar_descripcion\":false}]}',0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Factura numero F001-5, ha sido aceptada\",\"notes\":[]}',1,'{\"code\":\"0102\",\"description\":\"Usuario o contrase\\u00f1a incorrectos\"}',0,NULL,NULL,NULL,'',NULL,'2022-06-10 23:12:38','2022-06-11 21:25:58',1,NULL,NULL),