-- 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) NOT NULL,
  `has_card` tinyint(1) NOT NULL DEFAULT 0,
  `card_brand_id` char(2) DEFAULT NULL,
  `reference` varchar(255) 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=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `document_payments` VALUES
(1,1,'2026-03-02','01',0,NULL,NULL,NULL,2.00,8.00),
(2,2,'2026-03-06','01',0,NULL,NULL,NULL,NULL,2.00),
(3,3,'2026-03-06','01',0,NULL,NULL,NULL,2.00,13.00),
(4,4,'2026-03-07','01',0,NULL,NULL,NULL,4.00,36.00),
(5,5,'2026-03-07','01',0,NULL,NULL,NULL,3.00,7.00),
(6,6,'2026-03-07','01',0,NULL,NULL,NULL,NULL,4.00),
(7,7,'2026-03-07','01',0,NULL,NULL,NULL,NULL,10.00),
(8,8,'2026-03-07','01',0,NULL,NULL,NULL,2.00,8.00),
(9,9,'2026-03-07','01',0,NULL,NULL,NULL,NULL,2.00),
(10,10,'2026-03-07','01',0,NULL,NULL,NULL,NULL,2.00),
(11,11,'2026-03-07','01',0,NULL,NULL,NULL,NULL,4.00),
(12,12,'2026-03-07','01',0,NULL,NULL,NULL,6.00,4.00),
(13,13,'2026-03-07','01',0,NULL,NULL,NULL,NULL,12.00),
(14,14,'2026-03-08','01',0,NULL,NULL,NULL,2.00,18.00),
(15,15,'2026-03-08','01',0,NULL,NULL,NULL,8.00,12.00),
(16,16,'2026-03-08','01',0,NULL,NULL,NULL,0.50,5.50),
(17,17,'2026-03-09','01',0,NULL,NULL,NULL,1.00,14.00),
(18,18,'2026-03-10','01',0,NULL,NULL,NULL,NULL,2.00),
(19,19,'2026-03-10','01',0,NULL,NULL,NULL,2.00,8.00),
(20,20,'2026-03-10','01',0,NULL,NULL,NULL,NULL,10.00),
(21,21,'2026-03-10','01',0,NULL,NULL,NULL,NULL,4.00),
(22,22,'2026-03-10','01',0,NULL,NULL,NULL,NULL,4.00),
(23,23,'2026-03-11','01',0,NULL,NULL,NULL,NULL,37.50),
(24,24,'2026-03-11','01',0,NULL,NULL,NULL,NULL,61.00),
(25,25,'2026-03-11','01',0,NULL,NULL,NULL,30.50,19.50),
(26,26,'2026-03-14','01',0,NULL,NULL,NULL,6.00,24.00),
(27,27,'2026-03-21','01',0,NULL,NULL,NULL,46.90,53.10),
(28,28,'2026-04-13','01',0,NULL,NULL,NULL,NULL,32.00),
(29,29,'2026-04-13','01',0,NULL,NULL,NULL,NULL,80.00),
(30,30,'2026-04-13','01',0,NULL,NULL,NULL,NULL,37.50),
(31,31,'2026-04-13','01',0,NULL,NULL,NULL,NULL,18.00),
(32,32,'2026-04-13','01',0,NULL,NULL,NULL,NULL,15.00),
(33,33,'2026-04-13','01',0,NULL,NULL,NULL,NULL,30.00),
(34,34,'2026-04-13','01',0,NULL,NULL,NULL,NULL,280.00),
(35,35,'2026-04-13','01',0,NULL,NULL,NULL,NULL,400.00),
(36,36,'2026-04-13','01',0,NULL,NULL,NULL,NULL,75.00),
(37,37,'2026-04-13','01',0,NULL,NULL,NULL,NULL,125.00),
(38,38,'2026-04-13','01',0,NULL,NULL,NULL,NULL,40.00),
(39,39,'2026-04-13','01',0,NULL,NULL,NULL,NULL,7.50),
(40,40,'2026-04-13','01',0,NULL,NULL,NULL,NULL,152.00),
(41,41,'2026-04-13','01',0,NULL,NULL,NULL,NULL,52.50),
(42,42,'2026-04-15','01',0,NULL,NULL,NULL,NULL,25.00),
(43,43,'2026-04-16','01',0,NULL,NULL,NULL,NULL,60.00),
(44,44,'2026-04-21','01',0,NULL,NULL,NULL,NULL,65.00),
(45,45,'2026-04-21','01',0,NULL,NULL,NULL,NULL,8.00),
(46,46,'2026-04-25','01',0,NULL,NULL,NULL,NULL,3.50),
(47,47,'2026-04-30','01',0,NULL,NULL,NULL,NULL,28.00),
(48,48,'2026-06-10','01',0,NULL,NULL,NULL,NULL,28.00),
(49,49,'2026-06-12','01',0,NULL,NULL,NULL,NULL,48.00),
(50,50,'2026-06-12','01',0,NULL,NULL,NULL,NULL,25.00),
(51,51,'2026-06-12','01',0,NULL,NULL,NULL,NULL,25.00),
(52,52,'2026-06-18','01',0,NULL,NULL,NULL,NULL,20.00),
(53,53,'2026-06-21','01',0,NULL,NULL,NULL,NULL,45.00),
(54,54,'2026-06-22','01',0,NULL,NULL,NULL,NULL,67.50),
(55,55,'2026-06-25','01',0,NULL,NULL,NULL,NULL,3.00),
(56,56,'2026-06-30','01',0,NULL,NULL,NULL,NULL,48.50),
(57,57,'2026-06-30','01',0,NULL,NULL,NULL,NULL,34.00),
(58,58,'2026-06-30','01',0,NULL,NULL,NULL,NULL,51.00),
(59,59,'2026-06-30','01',0,NULL,NULL,NULL,NULL,20.00),
(60,60,'2026-06-30','01',0,NULL,NULL,NULL,NULL,77.00),
(61,61,'2026-06-30','01',0,NULL,NULL,NULL,NULL,65.00),
(62,62,'2026-06-30','01',0,NULL,NULL,NULL,NULL,75.50),
(63,63,'2026-06-30','01',0,NULL,NULL,NULL,NULL,59.00),
(64,64,'2026-06-30','01',0,NULL,NULL,NULL,NULL,37.50);
COMMIT;

--
-- 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) NOT NULL,
  `passenger_manifest` varchar(255) NOT NULL,
  `identity_document_type_id` varchar(255) NOT NULL,
  `number_identity_document` varchar(255) NOT NULL,
  `passenger_fullname` varchar(255) NOT NULL,
  `origin_district_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `origin_address` varchar(255) DEFAULT NULL,
  `destinatation_district_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `destinatation_address` varchar(255) 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`
--

COMMIT;

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

CREATE TABLE `documentary_actions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` varchar(250) 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`
--

COMMIT;

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

CREATE TABLE `documentary_documents` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` varchar(250) 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`
--

COMMIT;

--
-- 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') NOT NULL DEFAULT 'POR DERIVAR',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `office_name` longtext DEFAULT NULL COMMENT 'Nombre de la etapa',
  `process_name` longtext 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`
--

COMMIT;

--
-- 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 DEFAULT NULL,
  `year` int(10) unsigned NOT NULL,
  `invoice` longtext NOT NULL,
  `date_register` varchar(10) NOT NULL,
  `time_register` varchar(8) NOT NULL,
  `person_id` int(10) unsigned NOT NULL,
  `sender` longtext DEFAULT NULL,
  `subject` longtext DEFAULT NULL,
  `attached_file` longtext DEFAULT NULL,
  `observation` text DEFAULT NULL,
  `status` enum('RECIBIDO','DERIVADO','FINALIZADO','ARCHIVADO') 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 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`
--

COMMIT;

--
-- 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 DEFAULT NULL COMMENT 'observacion',
  `attached_file` longtext 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`
--

COMMIT;

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

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

COMMIT;

--
-- 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 DEFAULT NULL COMMENT 'Especifica la guia',
  `origin` longtext 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 DEFAULT NULL,
  `description` longtext 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`
--

COMMIT;

--
-- 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) NOT NULL,
  `color` varchar(255) 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);
COMMIT;

--
-- 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 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`
--

COMMIT;

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

CREATE TABLE `documentary_offices` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` varchar(250) 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) 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,'2025-12-27 23:47:10','2025-12-27 23:47:10',0,0,NULL),
(2,'Procesos','',1,'2025-12-27 23:47:10','2025-12-27 23:47:10',0,0,NULL),
(3,'Seguimiento','',1,'2025-12-27 23:47:10','2025-12-27 23:47:10',0,0,NULL),
(4,'Validacion','',1,'2025-12-27 23:47:10','2025-12-27 23:47:10',0,0,NULL);
COMMIT;

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

CREATE TABLE `documentary_processes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` text 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 DEFAULT NULL COMMENT 'etapas que contiene',
  `documentary_offices_order` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

COMMIT;

--
-- 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 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`
--

COMMIT;

--
-- 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`
--

COMMIT;

--
-- 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`
--

COMMIT;

--
-- 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) NOT NULL,
  `establishment_id` int(10) unsigned NOT NULL,
  `establishment` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `soap_type_id` char(2) NOT NULL,
  `state_type_id` char(2) NOT NULL,
  `ubl_version` varchar(255) 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) NOT NULL,
  `document_type_id` varchar(255) NOT NULL,
  `series` char(4) 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,
  `currency_type_id` varchar(255) NOT NULL,
  `payment_condition_id` varchar(255) DEFAULT NULL,
  `payment_method_type_id` char(2) DEFAULT NULL,
  `purchase_order` varchar(255) DEFAULT NULL,
  `plate_number` varchar(255) 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',
  `automatic_date_of_issue` date DEFAULT NULL,
  `type_period` varchar(255) 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,
  `coupon_id` int(10) unsigned DEFAULT NULL,
  `coupon_code` varchar(50) DEFAULT NULL,
  `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) 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,
  `discounts` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `prepayments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `guides` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `related` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `perception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `detraction` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `retention` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `legends` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `additional_information` text DEFAULT NULL,
  `additional_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `filename` varchar(255) DEFAULT NULL,
  `unique_filename` varchar(255) DEFAULT NULL,
  `hash` varchar(255) DEFAULT NULL,
  `reference_data` varchar(500) 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,
  `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,
  `success_sunat_shipping_status` tinyint(1) NOT NULL DEFAULT 0,
  `sunat_shipping_status` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `query_status` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `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,
  `regularize_shipping` tinyint(1) NOT NULL DEFAULT 0,
  `response_regularize_shipping` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `send_to_pse` tinyint(1) NOT NULL DEFAULT 0,
  `response_signature_pse` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `send_to_nubefact` tinyint(1) DEFAULT 0,
  `response_signature_nubefact` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `send_anulate_nubefact` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `response_send_cdr_pse` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `sale_notes_relateds` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'registros asociados cuando se genera cpe desde multiples notas de venta',
  `terms_condition` text DEFAULT NULL,
  `prescription_doctor_id` int(10) unsigned DEFAULT NULL,
  `folio` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `total_points` double(8,2) NOT NULL DEFAULT 0.00,
  `is_editable` tinyint(1) NOT NULL DEFAULT 0,
  `grade` text DEFAULT NULL COMMENT 'Grado designado - utilizado en matricula',
  `section` text 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=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `documents` VALUES
(1,2,'5318769e-c4b7-4bb7-ac60-f59269379935',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',131,'2026-03-02','12:53:34',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.361,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,8.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,8.00,8.00,8.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Ocho  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-131','20611371072-03-BA01-131','558ZI3kzbs8UrmiRbzME6hlduhY=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-131, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-02 12:54:12','2026-03-02 12:54:14',0.00,1,NULL,NULL),
(2,2,'3d050ff6-8ee2-4fb3-8a8e-9ca3207b67fa',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',132,'2026-03-06','08:08:10',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.432,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,2.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,2.00,2.00,2.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Dos  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-132','20611371072-03-BA01-132','n2Lzj9ISOX8Tln8QbZ7hKMQQ5Rg=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-132, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-06 08:08:20','2026-03-06 08:08:29',0.00,1,NULL,NULL),
(3,2,'9de3b1e9-0ee1-45ed-b99f-ea47d3630eea',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',133,'2026-03-06','14:40:08',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,1.000,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,13.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,13.00,13.00,13.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Trece  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-133','20611371072-03-BA01-133','rlDw8tjRppwWP/xrjtNJ+N2HuCY=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-133, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-06 14:40:53','2026-03-06 14:40:54',0.00,1,NULL,NULL),
(4,2,'8df4edfe-067e-42a5-bb6c-5bdae4fe47cd',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',134,'2026-03-07','08:23:00',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.479,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,36.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,36.00,36.00,36.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Treinta y seis  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-134','20611371072-03-BA01-134','QDG4xyF8mChKNwi8N2dtDZJQ10E=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-134, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-07 09:20:06','2026-03-07 09:20:10',0.00,1,NULL,NULL),
(5,2,'1069ecea-ecb7-43a7-8d02-85a1a35186bf',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',135,'2026-03-07','09:20:28',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.479,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,7.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,7.00,7.00,7.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Siete  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-135','20611371072-03-BA01-135','2k1+20qJDmPygC9xqHqb0xb6Hr4=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-135, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-07 09:20:34','2026-03-07 09:20:35',0.00,1,NULL,NULL),
(6,2,'8d2d52d9-1eaf-4585-8d5b-68994ae2f752',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',136,'2026-03-07','09:20:53',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.479,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,4.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,4.00,4.00,4.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Cuatro  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-136','20611371072-03-BA01-136','kdOXKDfPf/IZNJDxGUQYkSAFiXE=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-136, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-07 10:36:11','2026-03-07 10:36:17',0.00,1,NULL,NULL),
(7,2,'3b8aa94c-65c5-42bf-b692-a497a1583782',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',137,'2026-03-07','10:36:35',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.479,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,10.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,10.00,10.00,10.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Diez  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-137','20611371072-03-BA01-137','Hg3USGChY6KRlCf8ePt1GREK0oc=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-137, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-07 10:43:49','2026-03-07 10:43:58',0.00,1,NULL,NULL),
(8,2,'a2250932-e366-47c2-9ff0-b476a4a8eb68',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',138,'2026-03-07','10:44:15',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.479,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,8.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,8.00,8.00,8.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Ocho  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-138','20611371072-03-BA01-138','xDBzxDVk7V+jmpZXapCiX+nJX8I=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-138, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-07 12:14:45','2026-03-07 12:14:47',0.00,1,NULL,NULL),
(9,2,'bd4cd7e8-ba3c-4bcf-b22c-f61448c1ef05',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',139,'2026-03-07','20:43:42',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.479,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,2.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,2.00,2.00,2.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Dos  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-139','20611371072-03-BA01-139','WllU2I73eui1GPJHx5eLWtWrKsY=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-139, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-07 20:48:33','2026-03-07 20:48:40',0.00,1,NULL,NULL),
(10,2,'56192ab2-5d64-4783-a7cc-f4bd9fca77de',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',140,'2026-03-07','20:48:56',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.479,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,2.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,2.00,2.00,2.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Dos  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-140','20611371072-03-BA01-140','KnOVPK8IwKNh32yHfVrysE+DweU=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-140, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-07 21:25:52','2026-03-07 21:25:59',0.00,1,NULL,NULL),
(11,2,'5751024f-cbd1-4385-9b63-8114b99532c0',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',141,'2026-03-07','21:26:16',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.479,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,4.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,4.00,4.00,4.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Cuatro  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-141','20611371072-03-BA01-141','aevayIoGjUyaEWzXBIuDokQQinY=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-141, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-07 22:25:17','2026-03-07 22:25:19',0.00,1,NULL,NULL),
(12,2,'72bde6c7-e38d-47c8-aa66-16a5e5c69d73',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',142,'2026-03-07','22:25:35',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.479,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,4.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,4.00,4.00,4.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Cuatro  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-142','20611371072-03-BA01-142','RK3pEXaJkAQty768W/lhTybiQKM=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-142, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-07 22:28:56','2026-03-07 22:28:58',0.00,1,NULL,NULL),
(13,2,'d9f3005d-099f-4c12-875e-6eef5282655c',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',143,'2026-03-07','22:29:14',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.479,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,12.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,12.00,12.00,12.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Doce  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-143','20611371072-03-BA01-143','ycFH39N8GVWYmu3fMc6cX5Ia6WA=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-143, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-07 22:55:12','2026-03-07 22:55:14',0.00,1,NULL,NULL),
(14,2,'00aceb3a-fd5f-4f5d-9a5a-1d5ca141bfbf',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',144,'2026-03-08','13:56:50',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.479,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,18.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,18.00,18.00,18.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Dieciocho  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-144','20611371072-03-BA01-144','sYcUDfr4UWBEEM8al6QG1PqULOg=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-144, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-08 14:18:06','2026-03-08 14:18:22',0.00,1,NULL,NULL),
(15,2,'67a445d3-a0e2-4734-b702-6f3e7d0e9cc7',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',145,'2026-03-08','18:21:40',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.479,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,12.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,12.00,12.00,12.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Doce  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-145','20611371072-03-BA01-145','Kak2hxb1m0vecbXxJ8vO8zG/gCU=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-145, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-08 18:23:10','2026-03-08 18:23:14',0.00,1,NULL,NULL),
(16,2,'2b3eb2db-f65d-4a16-bcc9-e91ca5065845',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',146,'2026-03-08','18:23:31',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.479,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,5.50,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,5.50,5.50,5.50,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Cinco  con 50\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-146','20611371072-03-BA01-146','AyuvzaN5RTVm1hortinu8IRFU3U=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-146, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-08 18:35:46','2026-03-08 18:35:47',0.00,1,NULL,NULL),
(17,2,'5b48a99f-089a-4bf0-97a3-d2a28926e788',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',147,'2026-03-09','18:23:34',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,1.000,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,14.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,14.00,14.00,14.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Catorce  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-147','20611371072-03-BA01-147','vY33Hg3MRiQKKRsYej0QdBSkmA0=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-147, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-09 19:01:22','2026-03-09 19:01:24',0.00,1,NULL,NULL),
(18,2,'b7e42185-1e1f-444d-91e8-55a2b1c3bb84',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',148,'2026-03-10','15:06:38',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,1.000,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,2.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,2.00,2.00,2.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Dos  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-148','20611371072-03-BA01-148','sUD1FYB3n7LNK9dmytcccesX/E4=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-148, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-10 15:07:14','2026-03-10 15:07:15',0.00,1,NULL,NULL),
(19,2,'776f95f7-02f1-4fd1-9dc6-134862eeaf66',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',149,'2026-03-10','20:24:02',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.493,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,8.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,8.00,8.00,8.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Ocho  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-149','20611371072-03-BA01-149','Pb+/aklj4D6d+WF0MgLZTtzan08=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-149, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-10 20:24:57','2026-03-10 20:24:59',0.00,1,NULL,NULL),
(20,2,'81c1af23-8f32-40de-b7b8-63a99025a015',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',150,'2026-03-10','20:25:17',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.493,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,10.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,10.00,10.00,10.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Diez  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-150','20611371072-03-BA01-150','fmsnGPkcOmSN5Xgs06XrD94OK9Y=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-150, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-10 21:11:19','2026-03-10 21:11:21',0.00,1,NULL,NULL),
(21,2,'f8cee149-2243-4024-a2c0-26e2fd0f06dc',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',151,'2026-03-10','21:11:39',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.493,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,4.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,4.00,4.00,4.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Cuatro  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-151','20611371072-03-BA01-151','C9K7G1g9ABTPmFrZktPghPPZp6E=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-151, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-10 22:12:42','2026-03-10 22:12:44',0.00,1,NULL,NULL),
(22,2,'1a2ea638-3130-4c83-bf7b-7137c51d6913',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',152,'2026-03-10','22:13:02',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.493,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,4.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,4.00,4.00,4.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Cuatro  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-152','20611371072-03-BA01-152','wVXUI6n5TzxOs3a2m6kPciMo0mU=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-152, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-10 22:24:47','2026-03-10 22:24:49',0.00,1,NULL,NULL),
(23,2,'ff848347-0ae4-458e-b12d-ba685cd1dcae',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',153,'2026-03-11','14:36:27',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.451,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,37.50,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,37.50,37.50,37.50,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Treinta y siete  con 50\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-153','20611371072-03-BA01-153','3c2ELQPNM0Kqida0x7wxRHhZ2BA=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-153, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-11 14:38:11','2026-03-11 14:38:13',0.00,1,NULL,NULL),
(24,2,'bbd0038b-f77c-4c24-ac12-1f8a3571460f',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',154,'2026-03-11','14:38:31',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.451,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,61.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,61.00,61.00,61.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Sesenta y un  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-154','20611371072-03-BA01-154','cfZPouZhl0Qb+aaaLerNsdW16IM=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-154, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-11 14:39:21','2026-03-11 14:39:23',0.00,1,NULL,NULL),
(25,2,'fb0eda85-9bb7-46a4-86d2-7e68a762433b',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',155,'2026-03-11','22:20:43',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.451,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,19.50,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,19.50,19.50,19.50,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Diecinueve  con 50\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-155','20611371072-03-BA01-155','cUQCt7KXwPaoThB2mLaAROoj7X0=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-155, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-11 22:22:56','2026-03-11 22:22:58',0.00,1,NULL,NULL),
(26,2,'fd13a854-a766-4071-a083-04e35cc63898',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',156,'2026-03-14','08:49:29',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,1.000,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,24.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,24.00,24.00,24.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Veinticuatro  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-156','20611371072-03-BA01-156','12ni5xE6xOWiIpXgvhTFf9MoivQ=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-156, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-14 08:49:59','2026-03-14 08:50:01',0.00,1,NULL,NULL),
(27,2,'173ae241-7f70-4663-add0-ae7b7caf1e4f',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',157,'2026-03-21','21:24:50',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.453,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,45.00,0.00,0.00,8.10,0.00,0.00,0.00,0.00,0.00,0.00,8.10,45.00,53.10,53.10,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Cincuenta y tres  con 10\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-157','20611371072-03-BA01-157','QvgluVe0xeVZkKseO2e7h9D4umc=',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-157, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-03-21 21:27:53','2026-03-21 21:27:55',0.00,1,NULL,NULL),
(28,2,'956af3c5-d636-4ba9-8516-791aad4d72cc',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',158,'2026-04-13','22:13:51',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.385,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,32.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,32.00,32.00,32.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Treinta y dos  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-158','20611371072-03-BA01-158',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-158, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-04-13 22:14:05','2026-04-13 22:14:06',0.00,1,NULL,NULL),
(29,2,'06ee2e12-06fd-4f8d-8c0e-690cf267f769',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',159,'2026-04-13','22:14:35',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.385,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,80.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,80.00,80.00,80.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Ochenta  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-159','20611371072-03-BA01-159',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-159, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-04-13 22:14:52','2026-04-13 22:14:54',0.00,1,NULL,NULL),
(30,2,'db689877-f8f8-4484-a00c-89249aedb1ce',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',160,'2026-04-13','22:15:23',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.385,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,37.50,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,37.50,37.50,37.50,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Treinta y siete  con 50\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-160','20611371072-03-BA01-160',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-160, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-04-13 22:15:40','2026-04-13 22:15:42',0.00,1,NULL,NULL),
(31,2,'e75c303f-fcd0-4246-ba5d-20f5c5866360',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',161,'2026-04-13','22:16:11',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.385,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,18.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,18.00,18.00,18.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Dieciocho  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-161','20611371072-03-BA01-161',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-161, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-04-13 22:16:38','2026-04-13 22:16:40',0.00,1,NULL,NULL),
(32,2,'88bff565-0913-4b3e-8293-175f426982f7',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',162,'2026-04-13','22:17:09',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.385,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,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,'20611371072-03-BA01-162','20611371072-03-BA01-162',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-162, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-04-13 22:17:23','2026-04-13 22:17:28',0.00,1,NULL,NULL),
(33,2,'a84ef9e6-6b18-474d-8912-9e8b97a98bdb',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',163,'2026-04-13','22:17:57',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.385,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,30.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,30.00,30.00,30.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Treinta  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-163','20611371072-03-BA01-163',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-163, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-04-13 22:17:43','2026-04-13 22:17:45',0.00,1,NULL,NULL),
(34,2,'b8da5c73-f757-48d9-9fcc-ecfdac695951',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',164,'2026-04-13','22:18:14',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.385,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,280.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,280.00,280.00,280.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Doscientos ochenta  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-164','20611371072-03-BA01-164',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-164, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-04-13 22:18:55','2026-04-13 22:19:01',0.00,1,NULL,NULL),
(35,2,'61b67804-2830-40be-9a0f-249966b41fcc',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',165,'2026-04-13','22:19:30',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.385,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,400.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,400.00,400.00,400.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Cuatrocientos  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-165','20611371072-03-BA01-165',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-165, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-04-13 22:20:01','2026-04-13 22:20:04',0.00,1,NULL,NULL),
(36,2,'4a7c9b6f-1148-45f2-92f6-fdd7b3ac52d8',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',166,'2026-04-13','22:20:34',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.385,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,75.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,75.00,75.00,75.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Setenta y cinco  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-166','20611371072-03-BA01-166',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-166, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-04-13 22:20:27','2026-04-13 22:20:35',0.00,1,NULL,NULL),
(37,2,'7ce3b9ea-a2ac-4fc3-a68a-ac0fbf7250aa',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',167,'2026-04-13','22:21:04',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.385,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,125.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,125.00,125.00,125.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Ciento veinticinco  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-167','20611371072-03-BA01-167',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-167, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-04-13 22:21:21','2026-04-13 22:21:22',0.00,1,NULL,NULL),
(38,2,'aeb00ccd-37f6-45b8-af79-cce7c1da0858',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',168,'2026-04-13','22:21:51',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.385,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,40.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,40.00,40.00,40.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Cuarenta  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-168','20611371072-03-BA01-168',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-168, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-04-13 22:23:32','2026-04-13 22:23:40',0.00,1,NULL,NULL),
(39,2,'78040615-d66d-4a4a-aa6e-9ca3d411d19b',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',169,'2026-04-13','22:26:22',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.385,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,7.50,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,7.50,7.50,7.50,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Siete  con 50\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-169','20611371072-03-BA01-169',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-169, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-04-13 22:26:55','2026-04-13 22:26:57',0.00,1,NULL,NULL),
(40,2,'3e688b30-498e-4a85-bf3b-2131bc890006',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',170,'2026-04-13','22:27:26',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.385,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,152.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,152.00,152.00,152.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Ciento cincuenta y dos  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-170','20611371072-03-BA01-170',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-170, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-04-13 22:28:16','2026-04-13 22:28:19',0.00,1,NULL,NULL),
(41,2,'b44988f1-d846-44c9-9692-1fe89611a84b',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',171,'2026-04-13','22:28:49',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.385,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,52.50,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,52.50,52.50,52.50,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Cincuenta y dos  con 50\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-171','20611371072-03-BA01-171',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-171, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-04-13 22:29:25','2026-04-13 22:29:27',0.00,1,NULL,NULL),
(42,2,'6b19d734-900c-452b-a6a9-fb6a6bddb2ba',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',172,'2026-04-15','09:51:39',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.385,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,25.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,25.00,25.00,25.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Veinticinco  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-172','20611371072-03-BA01-172',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-172, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-04-15 09:55:57','2026-04-15 09:55:59',0.00,1,NULL,NULL),
(43,2,'8688ec24-f196-4159-a905-729c35827cdf',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',173,'2026-04-16','09:12:14',3,'{\"identity_document_type_id\":\"1\",\"identity_document_type\":{\"id\":\"1\",\"description\":\"DNI\"},\"number\":\"40924995\",\"name\":\"CASTRO MUJICA, LUIS RICARDO\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.390,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,60.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,60.00,60.00,60.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Sesenta  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-173','20611371072-03-BA01-173',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-173, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-04-16 09:43:39','2026-04-16 09:43:42',0.00,1,NULL,NULL),
(44,2,'71aaace8-eee6-4796-acb9-0d4a93cd1ebc',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',174,'2026-04-21','17:17:32',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.444,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,65.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,65.00,65.00,65.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Sesenta y cinco  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-174','20611371072-03-BA01-174',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-174, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-04-21 17:19:26','2026-04-21 17:19:34',0.00,1,NULL,NULL),
(45,2,'bb2bb8e6-74b9-4b70-9453-c3f7bfbda5ae',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',175,'2026-04-21','17:20:06',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.444,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,8.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,8.00,8.00,8.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Ocho  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-175','20611371072-03-BA01-175',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-175, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-04-21 17:21:26','2026-04-21 17:21:28',0.00,1,NULL,NULL),
(46,2,'3029e7aa-7f11-49cd-bee6-a96a920dd4fb',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',176,'2026-04-25','11:25:58',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.478,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,3.50,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,3.50,3.50,3.50,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Tres  con 50\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-176','20611371072-03-BA01-176',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-176, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-04-25 11:26:15','2026-04-25 11:26:17',0.00,1,NULL,NULL),
(47,2,'5ba71b14-9ee1-4c05-9895-546ca1139f06',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',177,'2026-04-30','08:36:38',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.529,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,28.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,28.00,28.00,28.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Veintiocho  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-177','20611371072-03-BA01-177',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-177, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-04-30 08:36:29','2026-04-30 08:36:31',0.00,1,NULL,NULL),
(48,2,'d8b575d4-3a65-4573-aeed-e3ab692a83ec',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',178,'2026-06-10','16:41:14',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.375,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,28.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,28.00,28.00,28.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Veintiocho  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-178','20611371072-03-BA01-178',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-178, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-06-10 16:41:37','2026-06-10 16:41:39',0.00,1,NULL,NULL),
(49,2,'6abf1a52-84f3-47c9-b8c7-8e4696b71e2e',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',179,'2026-06-12','13:39:55',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.394,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,48.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,48.00,48.00,48.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Cuarenta y ocho  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-179','20611371072-03-BA01-179',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-179, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-06-12 13:39:24','2026-06-12 13:39:25',0.00,1,NULL,NULL),
(50,2,'580f1701-ed62-42d0-b953-aca744256bf1',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',180,'2026-06-12','13:40:17',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.394,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,25.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,25.00,25.00,25.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Veinticinco  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-180','20611371072-03-BA01-180',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-180, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-06-12 13:39:37','2026-06-12 13:39:39',0.00,1,NULL,NULL),
(51,2,'2c317a2d-bf70-45ba-9cc3-b976bb3f78ba',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',181,'2026-06-12','13:40:30',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.394,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,25.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,25.00,25.00,25.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Veinticinco  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-181','20611371072-03-BA01-181',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-181, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-06-12 13:40:06','2026-06-12 13:40:07',0.00,1,NULL,NULL),
(52,2,'ec888db1-3726-4a90-b3d7-bbcc11f06208',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',182,'2026-06-18','15:03:05',4,'{\"identity_document_type_id\":\"1\",\"identity_document_type\":{\"id\":\"1\",\"description\":\"DNI\"},\"number\":\"74355658\",\"name\":\"ESPIRILLA SARGENTO, JENIFFER LUZ\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.384,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,20.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,20.00,20.00,20.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Veinte  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-182','20611371072-03-BA01-182',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-182, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-06-18 15:04:01','2026-06-18 15:04:02',0.00,1,NULL,NULL),
(53,2,'96d4422d-697f-4f2b-9f15-f9568e3d76ac',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',183,'2026-06-21','14:01:53',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.386,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,45.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,45.00,45.00,45.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Cuarenta y cinco  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-183','20611371072-03-BA01-183',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-183, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-06-21 14:11:27','2026-06-21 14:11:28',0.00,1,NULL,NULL),
(54,2,'0347017c-d17f-4b96-a12d-d18914b2a292',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',184,'2026-06-22','14:43:57',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.386,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,67.50,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,67.50,67.50,67.50,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Sesenta y siete  con 50\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-184','20611371072-03-BA01-184',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-184, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-06-22 14:45:37','2026-06-22 14:45:40',0.00,1,NULL,NULL),
(55,2,'0e6eae8c-3d1e-4f0e-8aad-5744c9536e10',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',185,'2026-06-25','08:51:07',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.425,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,3.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,3.00,3.00,3.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Tres  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-185','20611371072-03-BA01-185',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-185, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-06-25 08:50:28','2026-06-25 08:50:29',0.00,1,NULL,NULL),
(56,2,'0a073abe-8565-4588-99c8-2b411c2c7fb7',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',186,'2026-06-30','10:55:21',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.415,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,48.50,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,48.50,48.50,48.50,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Cuarenta y ocho  con 50\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-186','20611371072-03-BA01-186',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-186, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-06-30 10:54:51','2026-06-30 10:54:53',0.00,1,NULL,NULL),
(57,2,'25ef2e6d-a232-4cc1-98fa-56501ece2111',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',187,'2026-06-30','10:55:53',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.415,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,34.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,34.00,34.00,34.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Treinta y cuatro  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-187','20611371072-03-BA01-187',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-187, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-06-30 10:55:53','2026-06-30 10:55:55',0.00,1,NULL,NULL),
(58,2,'2b9b439b-72ff-43ca-a068-be340df14a88',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',188,'2026-06-30','10:56:55',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.415,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,51.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,51.00,51.00,51.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Cincuenta y un  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-188','20611371072-03-BA01-188',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-188, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-06-30 10:59:24','2026-06-30 10:59:34',0.00,1,NULL,NULL),
(59,2,'d6b37745-0d4b-496b-92fa-477a4bc2a1f3',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',189,'2026-06-30','11:00:34',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.415,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,20.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,20.00,20.00,20.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Veinte  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-189','20611371072-03-BA01-189',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-189, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-06-30 11:00:04','2026-06-30 11:00:08',0.00,1,NULL,NULL),
(60,2,'0cb85011-2656-436b-af92-433569f85cc8',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',190,'2026-06-30','11:01:08',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.415,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,77.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,77.00,77.00,77.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Setenta y siete  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-190','20611371072-03-BA01-190',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-190, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-06-30 11:00:42','2026-06-30 11:00:53',0.00,1,NULL,NULL),
(61,2,'bc117352-6234-44f3-ae9c-41af1bd0c6cd',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',191,'2026-06-30','11:01:53',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.415,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,65.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,65.00,65.00,65.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Sesenta y cinco  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-191','20611371072-03-BA01-191',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-191, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-06-30 11:01:53','2026-06-30 11:01:54',0.00,1,NULL,NULL),
(62,2,'8902d0ca-e718-4a3d-b3d5-8db2ab7b18ad',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',192,'2026-06-30','11:02:55',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.415,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,75.50,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,75.50,75.50,75.50,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Setenta y cinco  con 50\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-192','20611371072-03-BA01-192',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-192, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-06-30 11:02:44','2026-06-30 11:02:46',0.00,1,NULL,NULL),
(63,2,'be2f8ad4-b72c-4435-857c-2224bb9b8008',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',193,'2026-06-30','11:03:46',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.415,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,59.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,59.00,59.00,59.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Cincuenta y nueve  con 00\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-193','20611371072-03-BA01-193',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-193, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-06-30 11:03:13','2026-06-30 11:03:14',0.00,1,NULL,NULL),
(64,2,'a159f136-9c0e-4a27-b368-29d33487c7af',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"17\",\"department\":{\"id\":\"17\",\"description\":\"MADRE DE DIOS\"},\"province_id\":\"1701\",\"province\":{\"id\":\"1701\",\"description\":\"Tambopata\"},\"district_id\":\"170101\",\"district\":{\"id\":\"170101\",\"description\":\"Tambopata\"},\"urbanization\":null,\"address\":\"AV. CIRCUNVALACI\\u00d3N\",\"email\":\"admin@gmail.com\",\"telephone\":\"+51 928 355 472\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','05','2.1',1,0,'02','03','BA01',194,'2026-06-30','11:04:14',1,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"99999999\",\"name\":\"Clientes - Varios\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":null,\"department\":{\"id\":null,\"description\":null},\"province_id\":null,\"province\":{\"id\":null,\"description\":null},\"district_id\":null,\"district\":{\"id\":null,\"description\":null},\"address\":null,\"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,2,3.415,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,NULL,NULL,0.00,0.00,0.00,0.00,37.50,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,37.50,37.50,37.50,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Treinta y siete  con 50\\/100 \"}]',NULL,NULL,'20611371072-03-BA01-194','20611371072-03-BA01-194',NULL,NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,'{\"sent\":true,\"code\":\"0\",\"description\":\"La Boleta numero BA01-194, ha sido aceptada\",\"notes\":[]}',0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,'2026-06-30 11:07:14','2026-06-30 11:07:23',0.00,1,NULL,NULL);
COMMIT;

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

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

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

INSERT INTO `download_tray` VALUES
(4,2,'ACCOUNT','xlsx','download_tray_xlsx','Reporte_Formato_Ventas_20260701140130','Reporte Contabilidad','FINISHED','2026-07-01 14:01:27','2026-07-01 14:01:30',NULL,'2026-07-01 14:01:27','2026-07-01 14:01:30');
COMMIT;

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

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

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

COMMIT;

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

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

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

COMMIT;

--
-- Table structure for table `enter_permissions`
--

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

--
-- Dumping data for table `enter_permissions`
--

INSERT INTO `enter_permissions` VALUES
(1,'POS.CajaChica.Reportes','2025-12-27 23:47:14','2025-12-27 23:47:14'),
(2,'POS.PuntoVenta.StockMinimo','2025-12-27 23:47:14','2025-12-27 23:47:14'),
(3,'POS.PuntoVenta.Ubicacion','2025-12-27 23:47:14','2025-12-27 23:47:14'),
(4,'POS.PuntoVenta.AplicarDescuento','2025-12-27 23:47:15','2025-12-27 23:47:15'),
(5,'POS.PuntoVenta.PrincipioActivo','2026-04-15 09:51:49','2026-04-15 09:51:49');
COMMIT;

--
-- Table structure for table `enter_permissions_users`
--

CREATE TABLE `enter_permissions_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `permission_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `enter_permissions_users`
--

INSERT INTO `enter_permissions_users` VALUES
(1,1,1,'2025-12-27 23:47:18','2025-12-27 23:47:18'),
(2,1,2,'2025-12-27 23:47:18','2025-12-27 23:47:18'),
(3,1,3,'2025-12-27 23:47:18','2025-12-27 23:47:18'),
(4,1,4,'2025-12-27 23:47:18','2025-12-27 23:47:18'),
(5,2,1,NULL,NULL),
(7,2,3,NULL,NULL),
(8,2,4,NULL,NULL),
(9,2,5,NULL,NULL);
COMMIT;

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

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

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

INSERT INTO `establishments` VALUES
(1,'Oficina Principal','PE','17','1701','170101','AV. CIRCUNVALACIÓN','admin@gmail.com','+51 928 355 472','0000',NULL,NULL,NULL,1,NULL,'default',0,'default',NULL,NULL,NULL,'2025-12-27 23:56:03','2','2',0);
COMMIT;

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

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

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

INSERT INTO `exchange_rates` VALUES
('2025-12-30',3.372,3.361,3.361,3.372,'2025-12-29','2025-12-30 20:24:41','2025-12-30 20:24:41'),
('2025-12-31',3.369,3.360,3.360,3.369,'2025-12-30','2025-12-31 16:22:31','2025-12-31 16:22:31'),
('2026-01-02',3.368,3.358,3.358,3.368,'2025-12-31','2026-01-02 18:51:30','2026-01-02 18:51:30'),
('2026-01-03',3.368,3.358,3.358,3.368,'2025-12-31','2026-01-03 08:43:40','2026-01-03 08:43:40'),
('2026-01-04',3.368,3.358,3.358,3.368,'2025-12-31','2026-01-04 11:02:54','2026-01-04 11:02:54'),
('2026-01-05',3.368,3.358,3.358,3.368,'2025-12-31','2026-01-05 16:37:05','2026-01-05 16:37:05'),
('2026-01-07',3.366,3.357,3.357,3.366,'2026-01-06','2026-01-07 20:26:11','2026-01-07 20:26:11'),
('2026-01-12',3.365,3.358,3.358,3.365,'2026-01-09','2026-01-12 21:13:46','2026-01-12 21:13:46'),
('2026-01-13',3.368,3.355,3.355,3.368,'2026-01-12','2026-01-13 22:55:42','2026-01-13 22:55:42'),
('2026-01-18',3.363,3.354,3.354,3.363,'2026-01-16','2026-01-18 17:00:31','2026-01-18 17:00:31'),
('2026-01-20',3.366,3.353,3.353,3.366,'2026-01-19','2026-01-20 22:19:42','2026-01-20 22:19:42'),
('2026-01-23',3.360,3.352,3.352,3.360,'2026-01-22','2026-01-23 17:40:24','2026-01-23 17:40:24'),
('2026-01-28',3.352,3.345,3.345,3.352,'2026-01-27','2026-01-28 20:43:31','2026-01-28 20:43:31'),
('2026-02-01',3.355,3.350,3.350,3.355,'2026-01-29','2026-02-01 10:49:07','2026-02-01 10:49:07'),
('2026-02-08',3.363,3.355,3.355,3.363,'2026-02-06','2026-02-08 09:19:17','2026-02-08 09:19:17'),
('2026-02-14',3.358,3.348,3.348,3.358,'2026-02-13','2026-02-14 22:32:05','2026-02-14 22:32:05'),
('2026-02-20',3.366,3.360,3.360,3.366,'2026-02-19','2026-02-20 11:08:24','2026-02-20 11:08:24'),
('2026-02-27',3.360,3.353,3.353,3.360,'2026-02-26','2026-02-27 20:57:04','2026-02-27 20:57:04'),
('2026-03-01',3.361,3.350,3.350,3.361,'2026-02-27','2026-03-01 17:36:28','2026-03-01 17:36:28'),
('2026-03-02',3.361,3.350,3.350,3.361,'2026-02-27','2026-03-02 12:53:19','2026-03-02 12:53:19'),
('2026-03-04',3.408,3.403,3.403,3.408,'2026-03-03','2026-03-04 07:29:00','2026-03-04 07:29:00'),
('2026-03-05',3.414,3.405,3.405,3.414,'2026-03-04','2026-03-05 10:27:43','2026-03-05 10:27:43'),
('2026-03-06',3.432,3.424,3.424,3.432,'2026-03-05','2026-03-06 08:07:53','2026-03-06 08:07:53'),
('2026-03-07',3.479,3.467,3.467,3.479,'2026-03-06','2026-03-07 08:22:42','2026-03-07 08:22:42'),
('2026-03-08',3.479,3.467,3.467,3.479,'2026-03-06','2026-03-08 09:30:00','2026-03-08 09:30:00'),
('2026-03-09',3.479,3.467,3.467,3.479,'2026-03-06','2026-03-09 10:20:07','2026-03-09 10:20:07'),
('2026-03-10',3.493,3.482,3.482,3.493,'2026-03-09','2026-03-10 15:04:23','2026-03-10 15:04:23'),
('2026-03-11',3.451,3.434,3.434,3.451,'2026-03-10','2026-03-11 08:26:42','2026-03-11 08:26:42'),
('2026-03-12',3.427,3.419,3.419,3.427,'2026-03-11','2026-03-12 07:58:27','2026-03-12 07:58:27'),
('2026-03-14',3.453,3.446,3.446,3.453,'2026-03-13','2026-03-14 08:50:03','2026-03-14 08:50:03'),
('2026-03-15',3.453,3.446,3.446,3.453,'2026-03-13','2026-03-15 07:10:21','2026-03-15 07:10:21'),
('2026-03-18',3.417,3.408,3.408,3.417,'2026-03-17','2026-03-18 22:55:39','2026-03-18 22:55:39'),
('2026-03-20',3.454,3.447,3.447,3.454,'2026-03-19','2026-03-20 16:33:21','2026-03-20 16:33:21'),
('2026-03-21',3.477,3.469,3.469,3.477,'2026-03-20','2026-03-21 07:32:43','2026-03-21 07:32:43'),
('2026-04-13',3.385,3.379,3.379,3.385,'2026-04-10','2026-04-13 18:08:45','2026-04-13 18:08:45'),
('2026-04-15',3.390,3.380,3.380,3.390,'2026-04-14','2026-04-15 09:49:13','2026-04-15 09:49:13'),
('2026-04-16',3.436,3.425,3.425,3.436,'2026-04-15','2026-04-16 09:11:20','2026-04-16 09:11:20'),
('2026-04-18',3.442,3.435,3.435,3.442,'2026-04-17','2026-04-18 08:06:08','2026-04-18 08:06:08'),
('2026-04-21',3.444,3.430,3.430,3.444,'2026-04-20','2026-04-21 17:17:00','2026-04-21 17:17:00'),
('2026-04-25',3.478,3.467,3.467,3.478,'2026-04-24','2026-04-25 11:25:25','2026-04-25 11:25:25'),
('2026-04-30',3.529,3.523,3.523,3.529,'2026-04-29','2026-04-30 08:36:03','2026-04-30 08:36:03'),
('2026-06-10',3.375,3.372,3.372,3.375,'2026-06-09','2026-06-10 16:40:26','2026-06-10 16:40:26'),
('2026-06-12',3.394,3.390,3.390,3.394,'2026-06-11','2026-06-12 13:35:45','2026-06-12 13:35:45'),
('2026-06-18',3.384,3.378,3.378,3.384,'2026-06-17','2026-06-18 14:56:27','2026-06-18 14:56:27'),
('2026-06-21',3.386,3.377,3.377,3.386,'2026-06-19','2026-06-21 14:00:57','2026-06-21 14:00:57'),
('2026-06-22',3.386,3.377,3.377,3.386,'2026-06-19','2026-06-22 14:42:55','2026-06-22 14:42:55'),
('2026-06-25',3.425,3.419,3.419,3.425,'2026-06-24','2026-06-25 08:50:12','2026-06-25 08:50:12'),
('2026-06-30',3.415,3.406,3.406,3.415,'2026-06-29','2026-06-30 10:54:22','2026-06-30 10:54:22'),
('2026-07-01',3.415,3.403,3.403,3.415,'2026-06-30','2026-07-01 14:04:02','2026-07-01 14:04:02');
COMMIT;

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

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

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

COMMIT;

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

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

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

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

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

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

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

COMMIT;

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

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

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

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

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

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

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

INSERT INTO `expense_types` VALUES
(1,'PLANILLA','2025-12-27 23:47:00','2025-12-27 23:47:00'),
(2,'RECIBO POR HONORARIO','2025-12-27 23:47:00','2025-12-27 23:47:00'),
(3,'SERVICIO PÚBLICO','2025-12-27 23:47:00','2025-12-27 23:47:00'),
(4,'OTROS','2025-12-27 23:47:00','2025-12-27 23:47:00');
COMMIT;

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

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

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

COMMIT;

--
-- Table structure for table `expiration_date_settings`
--

CREATE TABLE `expiration_date_settings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  `days` smallint(6) NOT NULL,
  `color` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `expiration_date_settings`
--

INSERT INTO `expiration_date_settings` VALUES
(1,'EMPTY',5,'#ED000C',NULL,NULL),
(2,'ALMOST EMPTY',10,'#FFC000',NULL,NULL),
(3,'ENOUGH',15,'#05752F',NULL,NULL);
COMMIT;

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

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

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

COMMIT;

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

CREATE TABLE `fixed_asset_purchase_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fixed_asset_purchase_id` int(10) unsigned NOT NULL,
  `fixed_asset_item_id` int(10) unsigned NOT NULL,
  `item` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `quantity` decimal(12,4) NOT NULL,
  `unit_value` decimal(16,6) NOT NULL,
  `affectation_igv_type_id` varchar(255) 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) 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) 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,
  `discounts` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `charges` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fixed_asset_purchase_items_fixed_asset_purchase_id_foreign` (`fixed_asset_purchase_id`),
  KEY `fixed_asset_purchase_items_fixed_asset_item_id_foreign` (`fixed_asset_item_id`),
  KEY `fixed_asset_purchase_items_affectation_igv_type_id_foreign` (`affectation_igv_type_id`),
  KEY `fixed_asset_purchase_items_system_isc_type_id_foreign` (`system_isc_type_id`),
  KEY `fixed_asset_purchase_items_price_type_id_foreign` (`price_type_id`),
  CONSTRAINT `fixed_asset_purchase_items_affectation_igv_type_id_foreign` FOREIGN KEY (`affectation_igv_type_id`) REFERENCES `cat_affectation_igv_types` (`id`),
  CONSTRAINT `fixed_asset_purchase_items_fixed_asset_item_id_foreign` FOREIGN KEY (`fixed_asset_item_id`) REFERENCES `fixed_asset_items` (`id`),
  CONSTRAINT `fixed_asset_purchase_items_fixed_asset_purchase_id_foreign` FOREIGN KEY (`fixed_asset_purchase_id`) REFERENCES `fixed_asset_purchases` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fixed_asset_purchase_items_price_type_id_foreign` FOREIGN KEY (`price_type_id`) REFERENCES `cat_price_types` (`id`),
  CONSTRAINT `fixed_asset_purchase_items_system_isc_type_id_foreign` FOREIGN KEY (`system_isc_type_id`) REFERENCES `cat_system_isc_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

COMMIT;

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

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

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

COMMIT;

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

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

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

INSERT INTO `format_templates` VALUES
(1,'enter','2025-12-27 23:47:10','2025-12-27 23:47:10',NULL,0);
COMMIT;

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

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

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

COMMIT;

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

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

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

COMMIT;

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

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

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

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

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

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

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

INSERT INTO `global_payments` VALUES
(1,'02',1,'App\\Models\\Tenant\\Cash',1,'Modules\\Pos\\Models\\CashTransaction',2,'2025-12-28 00:26:33','2025-12-28 00:26:33'),
(2,'02',2,'App\\Models\\Tenant\\Cash',2,'Modules\\Pos\\Models\\CashTransaction',2,'2025-12-30 20:24:37','2025-12-30 20:24:37'),
(3,'02',2,'App\\Models\\Tenant\\Cash',1,'App\\Models\\Tenant\\SaleNotePayment',2,'2025-12-30 20:32:18','2025-12-30 20:32:18'),
(4,'02',3,'App\\Models\\Tenant\\Cash',3,'Modules\\Pos\\Models\\CashTransaction',2,'2025-12-31 16:22:28','2025-12-31 16:22:28'),
(5,'02',3,'App\\Models\\Tenant\\Cash',2,'App\\Models\\Tenant\\SaleNotePayment',2,'2025-12-31 16:24:09','2025-12-31 16:24:09'),
(7,'02',5,'App\\Models\\Tenant\\Cash',5,'Modules\\Pos\\Models\\CashTransaction',2,'2026-01-02 19:12:34','2026-01-02 19:12:34'),
(8,'02',6,'App\\Models\\Tenant\\Cash',6,'Modules\\Pos\\Models\\CashTransaction',2,'2026-01-12 21:13:32','2026-01-12 21:13:32'),
(9,'02',7,'App\\Models\\Tenant\\Cash',7,'Modules\\Pos\\Models\\CashTransaction',2,'2026-01-13 17:39:25','2026-01-13 17:39:25'),
(10,'02',8,'App\\Models\\Tenant\\Cash',8,'Modules\\Pos\\Models\\CashTransaction',2,'2026-01-18 17:00:26','2026-01-18 17:00:26'),
(11,'02',8,'App\\Models\\Tenant\\Cash',3,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-01-18 17:02:56','2026-01-18 17:02:56'),
(12,'02',9,'App\\Models\\Tenant\\Cash',9,'Modules\\Pos\\Models\\CashTransaction',2,'2026-01-20 22:19:34','2026-01-20 22:19:34'),
(13,'02',9,'App\\Models\\Tenant\\Cash',4,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-01-20 22:23:35','2026-01-20 22:23:35'),
(14,'02',10,'App\\Models\\Tenant\\Cash',10,'Modules\\Pos\\Models\\CashTransaction',2,'2026-01-23 17:40:21','2026-01-23 17:40:21'),
(15,'02',10,'App\\Models\\Tenant\\Cash',5,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-01-23 17:40:37','2026-01-23 17:40:37'),
(16,'02',11,'App\\Models\\Tenant\\Cash',11,'Modules\\Pos\\Models\\CashTransaction',2,'2026-01-28 20:43:22','2026-01-28 20:43:22'),
(17,'02',12,'App\\Models\\Tenant\\Cash',12,'Modules\\Pos\\Models\\CashTransaction',2,'2026-02-01 10:48:58','2026-02-01 10:48:58'),
(18,'02',12,'App\\Models\\Tenant\\Cash',6,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-02-01 10:53:48','2026-02-01 10:53:48'),
(19,'02',12,'App\\Models\\Tenant\\Cash',7,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-02-01 10:54:42','2026-02-01 10:54:42'),
(20,'02',12,'App\\Models\\Tenant\\Cash',8,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-02-01 11:09:10','2026-02-01 11:09:10'),
(21,'02',12,'App\\Models\\Tenant\\Cash',9,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-02-01 11:10:56','2026-02-01 11:10:56'),
(22,'02',13,'App\\Models\\Tenant\\Cash',13,'Modules\\Pos\\Models\\CashTransaction',2,'2026-02-14 22:32:00','2026-02-14 22:32:00'),
(23,'02',13,'App\\Models\\Tenant\\Cash',10,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-02-14 22:33:10','2026-02-14 22:33:10'),
(24,'02',13,'App\\Models\\Tenant\\Cash',11,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-02-14 22:34:30','2026-02-14 22:34:30'),
(25,'02',14,'App\\Models\\Tenant\\Cash',14,'Modules\\Pos\\Models\\CashTransaction',2,'2026-02-20 11:08:19','2026-02-20 11:08:19'),
(26,'02',15,'App\\Models\\Tenant\\Cash',15,'Modules\\Pos\\Models\\CashTransaction',2,'2026-03-01 17:36:20','2026-03-01 17:36:20'),
(27,'02',16,'App\\Models\\Tenant\\Cash',16,'Modules\\Pos\\Models\\CashTransaction',2,'2026-03-02 12:53:15','2026-03-02 12:53:15'),
(28,'02',16,'App\\Models\\Tenant\\Cash',1,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-02 12:54:12','2026-03-02 12:54:12'),
(29,'02',17,'App\\Models\\Tenant\\Cash',17,'Modules\\Pos\\Models\\CashTransaction',2,'2026-03-04 07:28:32','2026-03-04 07:28:32'),
(30,'02',18,'App\\Models\\Tenant\\Cash',18,'Modules\\Pos\\Models\\CashTransaction',2,'2026-03-05 10:27:24','2026-03-05 10:27:24'),
(31,'02',18,'App\\Models\\Tenant\\Cash',12,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-03-05 15:16:03','2026-03-05 15:16:03'),
(32,'02',18,'App\\Models\\Tenant\\Cash',13,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-03-05 18:41:01','2026-03-05 18:41:01'),
(33,'02',19,'App\\Models\\Tenant\\Cash',19,'Modules\\Pos\\Models\\CashTransaction',2,'2026-03-06 08:07:48','2026-03-06 08:07:48'),
(34,'02',19,'App\\Models\\Tenant\\Cash',2,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-06 08:08:20','2026-03-06 08:08:20'),
(35,'02',19,'App\\Models\\Tenant\\Cash',3,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-06 14:40:53','2026-03-06 14:40:53'),
(36,'02',19,'App\\Models\\Tenant\\Cash',14,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-03-06 19:05:56','2026-03-06 19:05:56'),
(37,'02',19,'App\\Models\\Tenant\\Cash',15,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-03-06 19:07:00','2026-03-06 19:07:00'),
(38,'02',19,'App\\Models\\Tenant\\Cash',16,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-03-06 19:08:15','2026-03-06 19:08:15'),
(39,'02',19,'App\\Models\\Tenant\\Cash',17,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-03-06 19:15:02','2026-03-06 19:15:02'),
(40,'02',19,'App\\Models\\Tenant\\Cash',18,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-03-06 19:53:31','2026-03-06 19:53:31'),
(41,'02',19,'App\\Models\\Tenant\\Cash',19,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-03-06 20:06:40','2026-03-06 20:06:40'),
(42,'02',19,'App\\Models\\Tenant\\Cash',20,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-03-06 22:20:38','2026-03-06 22:20:38'),
(43,'02',19,'App\\Models\\Tenant\\Cash',21,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-03-06 22:41:32','2026-03-06 22:41:32'),
(44,'02',19,'App\\Models\\Tenant\\Cash',22,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-03-06 22:56:48','2026-03-06 22:56:48'),
(45,'02',20,'App\\Models\\Tenant\\Cash',20,'Modules\\Pos\\Models\\CashTransaction',2,'2026-03-07 08:22:37','2026-03-07 08:22:37'),
(46,'02',20,'App\\Models\\Tenant\\Cash',4,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-07 09:20:06','2026-03-07 09:20:06'),
(47,'02',20,'App\\Models\\Tenant\\Cash',5,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-07 09:20:34','2026-03-07 09:20:34'),
(48,'02',20,'App\\Models\\Tenant\\Cash',6,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-07 10:36:11','2026-03-07 10:36:11'),
(49,'02',20,'App\\Models\\Tenant\\Cash',7,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-07 10:43:49','2026-03-07 10:43:49'),
(50,'02',20,'App\\Models\\Tenant\\Cash',8,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-07 12:14:45','2026-03-07 12:14:45'),
(51,'02',20,'App\\Models\\Tenant\\Cash',23,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-03-07 15:30:49','2026-03-07 15:30:49'),
(52,'02',20,'App\\Models\\Tenant\\Cash',24,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-03-07 18:22:43','2026-03-07 18:22:43'),
(53,'02',20,'App\\Models\\Tenant\\Cash',25,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-03-07 18:53:24','2026-03-07 18:53:24'),
(54,'02',20,'App\\Models\\Tenant\\Cash',26,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-03-07 19:20:35','2026-03-07 19:20:35'),
(55,'02',20,'App\\Models\\Tenant\\Cash',27,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-03-07 20:43:25','2026-03-07 20:43:25'),
(56,'02',20,'App\\Models\\Tenant\\Cash',9,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-07 20:48:33','2026-03-07 20:48:33'),
(57,'02',20,'App\\Models\\Tenant\\Cash',10,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-07 21:25:52','2026-03-07 21:25:52'),
(58,'02',20,'App\\Models\\Tenant\\Cash',11,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-07 22:25:17','2026-03-07 22:25:17'),
(59,'02',20,'App\\Models\\Tenant\\Cash',12,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-07 22:28:56','2026-03-07 22:28:56'),
(60,'02',20,'App\\Models\\Tenant\\Cash',13,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-07 22:55:13','2026-03-07 22:55:13'),
(61,'02',21,'App\\Models\\Tenant\\Cash',21,'Modules\\Pos\\Models\\CashTransaction',2,'2026-03-08 09:29:56','2026-03-08 09:29:56'),
(62,'02',21,'App\\Models\\Tenant\\Cash',28,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-03-08 09:30:27','2026-03-08 09:30:27'),
(63,'02',21,'App\\Models\\Tenant\\Cash',29,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-03-08 10:24:35','2026-03-08 10:24:35'),
(64,'02',21,'App\\Models\\Tenant\\Cash',30,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-03-08 13:56:32','2026-03-08 13:56:32'),
(65,'02',21,'App\\Models\\Tenant\\Cash',14,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-08 14:18:06','2026-03-08 14:18:06'),
(66,'02',21,'App\\Models\\Tenant\\Cash',15,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-08 18:23:10','2026-03-08 18:23:10'),
(67,'02',21,'App\\Models\\Tenant\\Cash',16,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-08 18:35:46','2026-03-08 18:35:46'),
(68,'02',22,'App\\Models\\Tenant\\Cash',22,'Modules\\Pos\\Models\\CashTransaction',2,'2026-03-09 10:20:02','2026-03-09 10:20:02'),
(69,'02',22,'App\\Models\\Tenant\\Cash',17,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-09 19:01:22','2026-03-09 19:01:22'),
(70,'02',23,'App\\Models\\Tenant\\Cash',23,'Modules\\Pos\\Models\\CashTransaction',2,'2026-03-10 15:04:17','2026-03-10 15:04:17'),
(71,'02',23,'App\\Models\\Tenant\\Cash',31,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-03-10 15:06:05','2026-03-10 15:06:05'),
(72,'02',23,'App\\Models\\Tenant\\Cash',18,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-10 15:07:14','2026-03-10 15:07:14'),
(73,'02',23,'App\\Models\\Tenant\\Cash',32,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-03-10 18:55:38','2026-03-10 18:55:38'),
(74,'02',23,'App\\Models\\Tenant\\Cash',19,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-10 20:24:57','2026-03-10 20:24:57'),
(75,'02',23,'App\\Models\\Tenant\\Cash',20,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-10 21:11:19','2026-03-10 21:11:19'),
(76,'02',23,'App\\Models\\Tenant\\Cash',21,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-10 22:12:42','2026-03-10 22:12:42'),
(77,'02',23,'App\\Models\\Tenant\\Cash',22,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-10 22:24:47','2026-03-10 22:24:47'),
(78,'02',24,'App\\Models\\Tenant\\Cash',24,'Modules\\Pos\\Models\\CashTransaction',2,'2026-03-11 08:26:28','2026-03-11 08:26:28'),
(79,'02',24,'App\\Models\\Tenant\\Cash',23,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-11 14:38:11','2026-03-11 14:38:11'),
(80,'02',24,'App\\Models\\Tenant\\Cash',24,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-11 14:39:21','2026-03-11 14:39:21'),
(81,'02',24,'App\\Models\\Tenant\\Cash',25,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-11 22:22:56','2026-03-11 22:22:56'),
(82,'02',25,'App\\Models\\Tenant\\Cash',25,'Modules\\Pos\\Models\\CashTransaction',2,'2026-03-12 07:58:23','2026-03-12 07:58:23'),
(83,'02',26,'App\\Models\\Tenant\\Cash',26,'Modules\\Pos\\Models\\CashTransaction',2,'2026-03-14 08:49:04','2026-03-14 08:49:04'),
(84,'02',26,'App\\Models\\Tenant\\Cash',26,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-14 08:49:59','2026-03-14 08:49:59'),
(85,'02',27,'App\\Models\\Tenant\\Cash',27,'Modules\\Pos\\Models\\CashTransaction',2,'2026-03-18 15:48:44','2026-03-18 15:48:44'),
(86,'02',28,'App\\Models\\Tenant\\Cash',28,'Modules\\Pos\\Models\\CashTransaction',2,'2026-03-20 15:26:43','2026-03-20 15:26:43'),
(87,'02',29,'App\\Models\\Tenant\\Cash',29,'Modules\\Pos\\Models\\CashTransaction',2,'2026-03-21 07:33:09','2026-03-21 07:33:09'),
(88,'02',29,'App\\Models\\Tenant\\Cash',27,'App\\Models\\Tenant\\DocumentPayment',2,'2026-03-21 21:27:53','2026-03-21 21:27:53'),
(89,'02',30,'App\\Models\\Tenant\\Cash',30,'Modules\\Pos\\Models\\CashTransaction',2,'2026-04-13 18:08:39','2026-04-13 18:08:39'),
(90,'02',30,'App\\Models\\Tenant\\Cash',33,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-04-13 22:12:11','2026-04-13 22:12:11'),
(91,'02',30,'App\\Models\\Tenant\\Cash',34,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-04-13 22:12:49','2026-04-13 22:12:49'),
(92,'02',30,'App\\Models\\Tenant\\Cash',35,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-04-13 22:13:21','2026-04-13 22:13:21'),
(93,'02',30,'App\\Models\\Tenant\\Cash',28,'App\\Models\\Tenant\\DocumentPayment',2,'2026-04-13 22:14:05','2026-04-13 22:14:05'),
(94,'02',30,'App\\Models\\Tenant\\Cash',29,'App\\Models\\Tenant\\DocumentPayment',2,'2026-04-13 22:14:52','2026-04-13 22:14:52'),
(95,'02',30,'App\\Models\\Tenant\\Cash',30,'App\\Models\\Tenant\\DocumentPayment',2,'2026-04-13 22:15:40','2026-04-13 22:15:40'),
(96,'02',30,'App\\Models\\Tenant\\Cash',31,'App\\Models\\Tenant\\DocumentPayment',2,'2026-04-13 22:16:38','2026-04-13 22:16:38'),
(97,'02',30,'App\\Models\\Tenant\\Cash',32,'App\\Models\\Tenant\\DocumentPayment',2,'2026-04-13 22:17:23','2026-04-13 22:17:23'),
(98,'02',30,'App\\Models\\Tenant\\Cash',33,'App\\Models\\Tenant\\DocumentPayment',2,'2026-04-13 22:17:43','2026-04-13 22:17:43'),
(99,'02',30,'App\\Models\\Tenant\\Cash',34,'App\\Models\\Tenant\\DocumentPayment',2,'2026-04-13 22:18:55','2026-04-13 22:18:55'),
(100,'02',30,'App\\Models\\Tenant\\Cash',35,'App\\Models\\Tenant\\DocumentPayment',2,'2026-04-13 22:20:01','2026-04-13 22:20:01'),
(101,'02',30,'App\\Models\\Tenant\\Cash',36,'App\\Models\\Tenant\\DocumentPayment',2,'2026-04-13 22:20:27','2026-04-13 22:20:27'),
(102,'02',30,'App\\Models\\Tenant\\Cash',37,'App\\Models\\Tenant\\DocumentPayment',2,'2026-04-13 22:21:21','2026-04-13 22:21:21'),
(103,'02',30,'App\\Models\\Tenant\\Cash',38,'App\\Models\\Tenant\\DocumentPayment',2,'2026-04-13 22:23:32','2026-04-13 22:23:32'),
(104,'02',30,'App\\Models\\Tenant\\Cash',39,'App\\Models\\Tenant\\DocumentPayment',2,'2026-04-13 22:26:55','2026-04-13 22:26:55'),
(105,'02',30,'App\\Models\\Tenant\\Cash',40,'App\\Models\\Tenant\\DocumentPayment',2,'2026-04-13 22:28:16','2026-04-13 22:28:16'),
(106,'02',30,'App\\Models\\Tenant\\Cash',41,'App\\Models\\Tenant\\DocumentPayment',2,'2026-04-13 22:29:25','2026-04-13 22:29:25'),
(107,'02',31,'App\\Models\\Tenant\\Cash',31,'Modules\\Pos\\Models\\CashTransaction',2,'2026-04-14 07:55:23','2026-04-14 07:55:23'),
(108,'02',31,'App\\Models\\Tenant\\Cash',42,'App\\Models\\Tenant\\DocumentPayment',2,'2026-04-15 09:55:57','2026-04-15 09:55:57'),
(109,'02',32,'App\\Models\\Tenant\\Cash',32,'Modules\\Pos\\Models\\CashTransaction',2,'2026-04-16 09:11:05','2026-04-16 09:11:05'),
(110,'02',32,'App\\Models\\Tenant\\Cash',43,'App\\Models\\Tenant\\DocumentPayment',2,'2026-04-16 09:43:39','2026-04-16 09:43:39'),
(111,'02',33,'App\\Models\\Tenant\\Cash',33,'Modules\\Pos\\Models\\CashTransaction',2,'2026-04-18 08:05:56','2026-04-18 08:05:56'),
(112,'02',34,'App\\Models\\Tenant\\Cash',34,'Modules\\Pos\\Models\\CashTransaction',2,'2026-04-21 17:16:55','2026-04-21 17:16:55'),
(113,'02',34,'App\\Models\\Tenant\\Cash',44,'App\\Models\\Tenant\\DocumentPayment',2,'2026-04-21 17:19:26','2026-04-21 17:19:26'),
(114,'02',34,'App\\Models\\Tenant\\Cash',45,'App\\Models\\Tenant\\DocumentPayment',2,'2026-04-21 17:21:26','2026-04-21 17:21:26'),
(115,'02',35,'App\\Models\\Tenant\\Cash',35,'Modules\\Pos\\Models\\CashTransaction',2,'2026-04-25 11:24:45','2026-04-25 11:24:45'),
(116,'02',35,'App\\Models\\Tenant\\Cash',46,'App\\Models\\Tenant\\DocumentPayment',2,'2026-04-25 11:26:15','2026-04-25 11:26:15'),
(117,'02',36,'App\\Models\\Tenant\\Cash',36,'Modules\\Pos\\Models\\CashTransaction',2,'2026-04-30 08:35:55','2026-04-30 08:35:55'),
(118,'02',36,'App\\Models\\Tenant\\Cash',47,'App\\Models\\Tenant\\DocumentPayment',2,'2026-04-30 08:36:29','2026-04-30 08:36:29'),
(119,'02',37,'App\\Models\\Tenant\\Cash',37,'Modules\\Pos\\Models\\CashTransaction',2,'2026-06-08 07:49:37','2026-06-08 07:49:37'),
(120,'02',37,'App\\Models\\Tenant\\Cash',48,'App\\Models\\Tenant\\DocumentPayment',2,'2026-06-10 16:41:37','2026-06-10 16:41:37'),
(121,'02',38,'App\\Models\\Tenant\\Cash',38,'Modules\\Pos\\Models\\CashTransaction',2,'2026-06-12 13:35:35','2026-06-12 13:35:35'),
(122,'02',38,'App\\Models\\Tenant\\Cash',36,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-06-12 13:39:03','2026-06-12 13:39:03'),
(123,'02',38,'App\\Models\\Tenant\\Cash',49,'App\\Models\\Tenant\\DocumentPayment',2,'2026-06-12 13:39:24','2026-06-12 13:39:24'),
(124,'02',38,'App\\Models\\Tenant\\Cash',50,'App\\Models\\Tenant\\DocumentPayment',2,'2026-06-12 13:39:37','2026-06-12 13:39:37'),
(125,'02',38,'App\\Models\\Tenant\\Cash',51,'App\\Models\\Tenant\\DocumentPayment',2,'2026-06-12 13:40:06','2026-06-12 13:40:06'),
(126,'02',38,'App\\Models\\Tenant\\Cash',37,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-06-12 13:40:53','2026-06-12 13:40:53'),
(127,'02',38,'App\\Models\\Tenant\\Cash',38,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-06-12 13:41:17','2026-06-12 13:41:17'),
(128,'02',38,'App\\Models\\Tenant\\Cash',39,'App\\Models\\Tenant\\SaleNotePayment',2,'2026-06-18 14:59:11','2026-06-18 14:59:11'),
(129,'02',38,'App\\Models\\Tenant\\Cash',52,'App\\Models\\Tenant\\DocumentPayment',2,'2026-06-18 15:04:01','2026-06-18 15:04:01'),
(130,'02',38,'App\\Models\\Tenant\\Cash',53,'App\\Models\\Tenant\\DocumentPayment',2,'2026-06-21 14:11:27','2026-06-21 14:11:27'),
(131,'02',38,'App\\Models\\Tenant\\Cash',54,'App\\Models\\Tenant\\DocumentPayment',2,'2026-06-22 14:45:37','2026-06-22 14:45:37'),
(132,'02',38,'App\\Models\\Tenant\\Cash',55,'App\\Models\\Tenant\\DocumentPayment',2,'2026-06-25 08:50:28','2026-06-25 08:50:28'),
(133,'02',38,'App\\Models\\Tenant\\Cash',56,'App\\Models\\Tenant\\DocumentPayment',2,'2026-06-30 10:54:51','2026-06-30 10:54:51'),
(134,'02',38,'App\\Models\\Tenant\\Cash',57,'App\\Models\\Tenant\\DocumentPayment',2,'2026-06-30 10:55:53','2026-06-30 10:55:53'),
(135,'02',38,'App\\Models\\Tenant\\Cash',58,'App\\Models\\Tenant\\DocumentPayment',2,'2026-06-30 10:59:24','2026-06-30 10:59:24'),
(136,'02',38,'App\\Models\\Tenant\\Cash',59,'App\\Models\\Tenant\\DocumentPayment',2,'2026-06-30 11:00:04','2026-06-30 11:00:04'),
(137,'02',38,'App\\Models\\Tenant\\Cash',60,'App\\Models\\Tenant\\DocumentPayment',2,'2026-06-30 11:00:42','2026-06-30 11:00:42'),
(138,'02',38,'App\\Models\\Tenant\\Cash',61,'App\\Models\\Tenant\\DocumentPayment',2,'2026-06-30 11:01:53','2026-06-30 11:01:53'),
(139,'02',38,'App\\Models\\Tenant\\Cash',62,'App\\Models\\Tenant\\DocumentPayment',2,'2026-06-30 11:02:44','2026-06-30 11:02:44'),
(140,'02',38,'App\\Models\\Tenant\\Cash',63,'App\\Models\\Tenant\\DocumentPayment',2,'2026-06-30 11:03:13','2026-06-30 11:03:13'),
(141,'02',38,'App\\Models\\Tenant\\Cash',64,'App\\Models\\Tenant\\DocumentPayment',2,'2026-06-30 11:07:14','2026-06-30 11:07:14');
COMMIT;

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

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

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

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

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

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

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

COMMIT;

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

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

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

INSERT INTO `guide_items` VALUES
(1,1,617,'SALBUTAMOL AER 100 mcg/ DOSIS (LABOT)',6.00000000,0.00000000,0.00),
(2,2,424,'Ambroxol 30MG/5ML JBE x 120 ml (PORTUGAL)',6.00000000,0.00000000,0.00),
(3,3,47,'AMOXI + AC CLAVU SUSP ORAL 250 mg + 62.5 mg/5 ml x 60 ml (PORTUGAL)',8.00000000,0.00000000,0.00),
(4,4,325,'Clorfenamina Maleato 2mg / 5mL x 60 ml (PORTUGAL)',6.00000000,0.00000000,0.00),
(5,5,425,'Dextrometorfano 15mg / 5mL x 120 ml (PORTUGAL)',7.00000000,0.00000000,0.00),
(6,6,607,'DICLOXACILINA SUSP ORAL 250 mg/5 ml x 60 ml',5.00000000,0.00000000,0.00),
(7,7,182,'SULFAMET.+TRIMET SUSP ORAL 200 mg+40 ml /5 ml (PORTUGAL)',8.00000000,0.00000000,0.00),
(8,8,620,'KIDS - IBUPROFENO SUSP ORAL 100 mg/5 ml x 120 ml (GENFAR)',6.00000000,0.00000000,0.00),
(9,9,170,'PANADOL - PARACETAMOL  Niños 2 a 11 JRBE X 60 ml',9.00000000,0.00000000,0.00),
(10,10,646,'DOLORAL- IBUPROFENO SUSP 100 mg/5 ml x 60 ml (HERSIL)',9.00000000,0.00000000,0.00),
(11,11,655,'DOLORAL FORTE-IBUPROFENO 200 mg/5 ml X 60 ml (INDUFAR)',6.00000000,0.00000000,0.00),
(12,12,285,'REPRIMAN- METAMIZOL 500 mg/ml X 10 ml GOTAS (QUILAB)',5.00000000,0.00000000,0.00),
(13,13,398,'PALTOMIEL INFANTIL x 125 ml',8.00000000,0.00000000,0.00),
(14,14,609,'GRIFANTIL NF SUSP ORAL x 60',3.00000000,0.00000000,0.00),
(15,15,650,'VICK 44 JARABE x120 ml',7.00000000,0.00000000,0.00),
(16,16,450,'RHINO -BB Cloruro de Sodio 0,9',5.00000000,0.00000000,0.00),
(17,17,317,'TUSILEXIL NF JARABE x 120 ml (ROWE)',9.00000000,0.00000000,0.00),
(18,18,624,'BRONQUIO FLEMITOSS REGULAR STRENGTH x 120 ml (CIFARMA)',8.00000000,0.00000000,0.00),
(19,19,628,'BIOBRONCOL-CEFALEXINA+AMBROXSUSP ORAL x 75 ml (IQFARMA)',9.00000000,0.00000000,0.00),
(20,20,225,'BACTRIM  SULFA + TRIMETO 200 mg + 40 mg/ 5 ml JBE X 100mL (SIEDFRIED)',9.00000000,0.00000000,0.00),
(21,21,59,'Bactrim Forte SUSP ORAL 400mg+80mg / 5 ml x 100 ml (SIEGFRIED)',7.00000000,0.00000000,0.00),
(22,22,637,'COLUFASE-NITAZOXANIDA 100 mg/ 5 ml x 30 ml (MEGALABS)',7.00000000,0.00000000,0.00),
(23,23,777,'NISTAMUG - NISTATINA 100 000 UI/ ml x 12 ml (ROXFARMA)',1.00000000,0.00000000,0.00),
(24,24,301,'ACI TIP MAGAL + SIMETI 400 + 30 mg/ 5 ml x 200 ml (MEGALABS)',9.00000000,0.00000000,0.00),
(25,25,552,'BISMUTOL TAB MASTICABLES (TEVA)',19.00000000,0.00000000,0.00),
(26,26,1,'3 GEL SUSP.ORAL',54.00000000,0.00000000,0.00),
(27,27,74,'REFLUPRAZOL Esomeprazol 40 mg TAB (QM PHARMA)',43.00000000,0.00000000,0.00),
(28,28,509,'BUSCAPINA Compositum N COMPR (OPELLA)',105.00000000,0.00000000,0.00),
(29,29,56,'PLIDAN COMPUESTO  COMPRI (Megalabs)',43.00000000,0.00000000,0.00),
(30,30,254,'CORTAFAN NF Nifuroxazida  CAP 200 mg (MARKOS)',19.00000000,0.00000000,0.00),
(31,31,686,'GRAVOL -DIMENHIDRINATO 50 mg TAB (MEDIFARMA)',26.00000000,0.00000000,0.00),
(32,32,570,'GRAVAMIN - DIMENHIDRINATO 50 mg (MEDIFARMA)',189.00000000,0.00000000,0.00),
(33,33,354,'NIKZON TAB MASTICA (GENOMMA LAB)',98.00000000,0.00000000,0.00),
(34,34,712,'COLUFASE Nitazoxanida',8.00000000,0.00000000,0.00),
(35,35,636,'GARDIL-NITAZOXANIDA 500 mg (LABOFAR)',7.00000000,0.00000000,0.00),
(36,36,114,'ANAFLEX MUJER - IBUPROFENO 200 mg (BAGO)',154.00000000,0.00000000,0.00),
(37,37,223,'DEXAMECOR - DEXAMETASONA 4 mg (LYAFARM)',7.00000000,0.00000000,0.00),
(38,38,360,'DOLOPARAMIDOL NF - PARACETA + IBU 500 + 150 mg COMP (MARKOS)',327.00000000,0.00000000,0.00),
(39,39,137,'ASPIRINA 100mg TAB  (BAYER)',34.00000000,0.00000000,0.00),
(40,40,546,'NEURODIOXAFLEX (BAGO)',63.00000000,0.00000000,0.00),
(41,41,21,'DOLOCORDRALAN EXTRA FORTE (ANSOLAT)',4.00000000,0.00000000,0.00),
(42,42,63,'Dolo Neuribion NF CAPSULA (CIFARMA)',132.00000000,0.00000000,0.00),
(43,43,205,'MIODEL RELAX NF PARACE + ORFENA 450 + 35 mg (DELFARMA)',10.00000000,0.00000000,0.00);
COMMIT;

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

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

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

INSERT INTO `guides` VALUES
(1,'2179499f-f0d7-4bcd-b802-10094afbef7c',2,1,'02','U3','NSA1',1,'2026-02-20','11:26:52','10',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-1','2026-02-20 11:26:52','2026-02-20 11:26:52'),
(2,'268238e5-f36c-4444-95c6-41f09698ee21',2,1,'02','U3','NSA1',2,'2026-03-04','07:39:53','23',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-2','2026-03-04 07:39:53','2026-03-04 07:39:53'),
(3,'fb0e2653-1da0-4697-adb7-9c2f79ee8b68',2,1,'02','U3','NSA1',3,'2026-03-04','07:47:07','12',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-3','2026-03-04 07:47:07','2026-03-04 07:47:07'),
(4,'5a34dbd8-84e3-4098-a68c-2b39777ae221',2,1,'02','U3','NSA1',4,'2026-03-04','07:51:53','12',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-4','2026-03-04 07:51:53','2026-03-04 07:51:53'),
(5,'2fa2611f-1be9-437f-afe0-250da8b8bb54',2,1,'02','U3','NSA1',5,'2026-03-04','07:54:27','12',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-5','2026-03-04 07:54:27','2026-03-04 07:54:27'),
(6,'0ce613cc-ad05-415f-8a41-e0ad32e1080a',2,1,'02','U3','NSA1',6,'2026-03-04','07:55:41','12',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-6','2026-03-04 07:55:41','2026-03-04 07:55:41'),
(7,'92519899-ac93-40cd-81cf-4f0d9f640585',2,1,'02','U3','NSA1',7,'2026-03-04','09:59:32','12',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-7','2026-03-04 09:59:32','2026-03-04 09:59:32'),
(8,'0df7a15f-2809-4e66-939d-aba76020f828',2,1,'02','U3','NSA1',8,'2026-03-04','11:00:04','12',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-8','2026-03-04 11:00:04','2026-03-04 11:00:04'),
(9,'66c49bdf-90e7-4469-8b19-ddece18996ef',2,1,'02','U3','NSA1',9,'2026-03-04','11:05:30','12',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-9','2026-03-04 11:05:30','2026-03-04 11:05:30'),
(10,'dd827d99-1532-4834-8f17-3c031ce8a898',2,1,'02','U3','NSA1',10,'2026-03-04','11:08:19','12',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-10','2026-03-04 11:08:19','2026-03-04 11:08:19'),
(11,'01b3a877-b26c-4351-8b2a-eccd4031edae',2,1,'02','U3','NSA1',11,'2026-03-04','11:11:43','28',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-11','2026-03-04 11:11:43','2026-03-04 11:11:43'),
(12,'6c460f02-a45a-4f15-9485-87525354e70f',2,1,'02','U3','NSA1',12,'2026-03-04','11:13:52','28',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-12','2026-03-04 11:13:52','2026-03-04 11:13:52'),
(13,'0d14c973-6b28-4dc3-8116-3d94b4f3f1e4',2,1,'02','U3','NSA1',13,'2026-03-04','11:17:03','28',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-13','2026-03-04 11:17:03','2026-03-04 11:17:03'),
(14,'96c4cd1c-3f65-4647-9860-9444364d595c',2,1,'02','U3','NSA1',14,'2026-03-04','11:32:15','28',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-14','2026-03-04 11:32:15','2026-03-04 11:32:15'),
(15,'40b5b5b4-c164-4283-96df-b1e852416adf',2,1,'02','U3','NSA1',15,'2026-03-04','11:39:12','28',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-15','2026-03-04 11:39:12','2026-03-04 11:39:12'),
(16,'c2e7c5b0-c2b7-4c64-a6ad-01815e0e8218',2,1,'02','U3','NSA1',16,'2026-03-04','11:40:25','28',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-16','2026-03-04 11:40:25','2026-03-04 11:40:25'),
(17,'88e88a32-808c-471c-bf30-5c28506f6e0b',2,1,'02','U3','NSA1',17,'2026-03-04','11:51:36','28',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-17','2026-03-04 11:51:36','2026-03-04 11:51:36'),
(18,'2f93bc41-b814-4f9d-bc4f-333a90fcb725',2,1,'02','U3','NSA1',18,'2026-03-05','10:31:09','28',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-18','2026-03-05 10:31:09','2026-03-05 10:31:09'),
(19,'051d9869-2e88-4a1d-8e2d-7f420aaf6627',2,1,'02','U3','NSA1',19,'2026-03-05','10:46:39','28',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-19','2026-03-05 10:46:39','2026-03-05 10:46:39'),
(20,'67d76b5c-d180-4994-b15f-cc4db7a24024',2,1,'02','U3','NSA1',20,'2026-03-05','11:00:47','28',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-20','2026-03-05 11:00:47','2026-03-05 11:00:47'),
(21,'9d684048-ce26-4200-b562-23927dbf6593',2,1,'02','U3','NSA1',21,'2026-03-05','11:16:18','28',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-21','2026-03-05 11:16:18','2026-03-05 11:16:18'),
(22,'c7e25432-ef5f-4951-a64e-3557199e8131',2,1,'02','U3','NSA1',22,'2026-03-05','11:19:02','28',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-22','2026-03-05 11:19:02','2026-03-05 11:19:02'),
(23,'21711677-3959-42b7-adf8-5807aececf13',2,1,'02','U2','NIA1',1,'2026-03-05','11:46:49','22',NULL,NULL,'AJUSTE DE INVETARIO','20611371072-U2-NIA1-1','2026-03-05 11:46:49','2026-03-05 11:46:49'),
(24,'ceff9892-b82c-413e-949c-488c56afa935',2,1,'02','U3','NSA1',23,'2026-03-05','11:52:12','28',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-23','2026-03-05 11:52:12','2026-03-05 11:52:12'),
(25,'1780b0db-b767-4441-bcb0-26fd30545c0c',2,1,'02','U2','NIA1',2,'2026-03-05','11:59:34','99',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U2-NIA1-2','2026-03-05 11:59:34','2026-03-05 11:59:34'),
(26,'51a8e44b-2fdc-4f65-bb9a-3dc78195cb04',2,1,'02','U2','NIA1',3,'2026-03-05','13:12:57','99',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U2-NIA1-3','2026-03-05 13:12:57','2026-03-05 13:12:57'),
(27,'d41e12ec-44e7-486f-bdf3-37956b2d5e82',2,1,'02','U2','NIA1',4,'2026-03-05','13:15:13','99',NULL,NULL,'AJUSTE DE INVNTRIO','20611371072-U2-NIA1-4','2026-03-05 13:15:13','2026-03-05 13:15:13'),
(28,'3642caa1-ca02-4253-8fb5-6b356518e7d4',2,1,'02','U2','NIA1',5,'2026-03-05','13:18:31','99',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U2-NIA1-5','2026-03-05 13:18:31','2026-03-05 13:18:31'),
(29,'a844ba7b-179a-4547-9721-fb2b228fea61',2,1,'02','U2','NIA1',6,'2026-03-05','13:20:28','99',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U2-NIA1-6','2026-03-05 13:20:28','2026-03-05 13:20:28'),
(30,'3e767a1b-efa2-45ac-8090-3439b35ba883',2,1,'02','U2','NIA1',7,'2026-03-05','13:22:13','99',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U2-NIA1-7','2026-03-05 13:22:13','2026-03-05 13:22:13'),
(31,'9eb4a911-2d93-45d1-b22b-78371985e039',2,1,'02','U2','NIA1',8,'2026-03-05','13:25:22','99',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U2-NIA1-8','2026-03-05 13:25:22','2026-03-05 13:25:22'),
(32,'0653a070-248b-4b1e-8737-00d85f01da46',2,1,'02','U2','NIA1',9,'2026-03-05','13:27:15','99',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U2-NIA1-9','2026-03-05 13:27:15','2026-03-05 13:27:15'),
(33,'415c546f-a6ee-435e-ab07-84c3a00e0c0f',2,1,'02','U2','NIA1',10,'2026-03-05','13:30:07','99',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U2-NIA1-10','2026-03-05 13:30:07','2026-03-05 13:30:07'),
(34,'7aef7e5c-8978-408a-b579-9689f814a2f4',2,1,'02','U3','NSA1',24,'2026-03-05','14:14:55','28',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-24','2026-03-05 14:14:55','2026-03-05 14:14:55'),
(35,'bda91bbd-67e4-4fcf-bd16-9d6cf6477aad',2,1,'02','U3','NSA1',25,'2026-03-05','14:16:01','28',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-25','2026-03-05 14:16:01','2026-03-05 14:16:01'),
(36,'adfdea3c-de71-4841-9619-3900174e1e5c',2,1,'02','U2','NIA1',11,'2026-03-05','14:25:03','99',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U2-NIA1-11','2026-03-05 14:25:03','2026-03-05 14:25:03'),
(37,'86fc30c6-d7a1-4360-8f6c-4234cee9a4d1',2,1,'02','U2','NIA1',12,'2026-03-05','14:27:09','99',NULL,NULL,'AJUSTE DEINVENTARIO','20611371072-U2-NIA1-12','2026-03-05 14:27:09','2026-03-05 14:27:09'),
(38,'4e14e84c-38be-4c80-9f63-b6507b8c30ef',2,1,'02','U2','NIA1',13,'2026-03-05','14:32:07','99',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U2-NIA1-13','2026-03-05 14:32:07','2026-03-05 14:32:07'),
(39,'bcdb93a9-38e8-44dd-975b-fd7c8b0cd974',2,1,'02','U2','NIA1',14,'2026-03-05','14:36:47','99',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U2-NIA1-14','2026-03-05 14:36:47','2026-03-05 14:36:47'),
(40,'e0fd5d3f-d95f-4c67-9136-25f726b094fa',2,1,'02','U2','NIA1',15,'2026-03-05','14:53:27','99',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U2-NIA1-15','2026-03-05 14:53:27','2026-03-05 14:53:27'),
(41,'a4c6132e-cddb-417b-a054-db0a31c40c99',2,1,'02','U3','NSA1',26,'2026-03-05','14:54:50','28',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U3-NSA1-26','2026-03-05 14:54:50','2026-03-05 14:54:50'),
(42,'2505c496-8276-4904-99c6-89bf58f34981',2,1,'02','U2','NIA1',16,'2026-03-05','14:57:17','99',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U2-NIA1-16','2026-03-05 14:57:17','2026-03-05 14:57:17'),
(43,'16437e47-3339-4a8d-a620-5dff99575d6a',2,1,'02','U2','NIA1',17,'2026-03-05','14:59:01','99',NULL,NULL,'AJUSTE DE INVENTARIO','20611371072-U2-NIA1-17','2026-03-05 14:59:01','2026-03-05 14:59:01');
COMMIT;

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

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

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

COMMIT;

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

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

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

COMMIT;

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

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

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

COMMIT;

--
-- Table structure for table `hotel_rent_item_payments`
--

CREATE TABLE `hotel_rent_item_payments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `hotel_rent_item_id` int(10) unsigned NOT NULL,
  `date_of_payment` date NOT NULL,
  `payment_method_type_id` char(2) NOT NULL,
  `reference` varchar(255) DEFAULT NULL,
  `change` decimal(12,2) DEFAULT NULL,
  `payment` decimal(12,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `hotel_rent_item_payments_hotel_rent_item_id_foreign` (`hotel_rent_item_id`),
  KEY `hotel_rent_item_payments_payment_method_type_id_foreign` (`payment_method_type_id`),
  KEY `hotel_rent_item_payments_date_of_payment_index` (`date_of_payment`),
  CONSTRAINT `hotel_rent_item_payments_hotel_rent_item_id_foreign` FOREIGN KEY (`hotel_rent_item_id`) REFERENCES `hotel_rent_items` (`id`) ON DELETE CASCADE,
  CONSTRAINT `hotel_rent_item_payments_payment_method_type_id_foreign` FOREIGN KEY (`payment_method_type_id`) REFERENCES `payment_method_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotel_rent_item_payments`
--

COMMIT;

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

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

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

COMMIT;

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

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

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

COMMIT;

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

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

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

COMMIT;

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

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

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

COMMIT;

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

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

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

COMMIT;

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

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

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

COMMIT;

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

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

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

COMMIT;

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

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

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

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

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

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

--
