(683,2,'0a0f9612-978f-4971-b463-ee9a4fdf3db5',1,'{\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"01\",\"department\":{\"id\":\"01\",\"description\":\"AMAZONAS\"},\"province_id\":\"0102\",\"province\":{\"id\":\"0102\",\"description\":\"Bagua\"},\"district_id\":\"010201\",\"district\":{\"id\":\"010201\",\"description\":\"Bagua\"},\"urbanization\":null,\"address\":\"Jr. Amazonas N\\u00b0520\",\"email\":\"brazil@gmail.com\",\"telephone\":\"948000166\",\"code\":\"0000\",\"trade_address\":null,\"web_address\":null,\"aditional_information\":null,\"logo\":null}','02','01','2.1',0,0,'02','03','B001',297,'2023-03-01','20:55:25',429,'{\"identity_document_type_id\":\"0\",\"identity_document_type\":{\"id\":\"0\",\"description\":\"Doc.trib.no.dom.sin.ruc\"},\"number\":\"9945646456\",\"name\":\"Clientes56456464\",\"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.810,0,NULL,NULL,NULL,NULL,0,0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,203.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,203.00,203.00,203.00,0,0,NULL,0,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"code\":1000,\"value\":\"Doscientos tres  con 00\\/100 \"}]',NULL,NULL,'10444565972-03-B001-297','10444565972-03-B001-297','sU6Bg0+YcHbgE0gjNxriprr3jcs=','[encoded data, 90460 characters]',NULL,NULL,0,0,0,NULL,0,0,NULL,0,NULL,NULL,0,1,NULL,0,NULL,0,NULL,NULL,NULL,'',NULL,'2023-03-01 20:56:44','2023-03-01 20:56:45',1,NULL,NULL);

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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `establishments` VALUES (1,'Zapateria Brazil - Bagua','PE','01','0102','010201','Jr. Amazonas N°520','brazil@gmail.com','948000166','0000',NULL,NULL,NULL,NULL,NULL,'default',0,'default',NULL,'2022-03-17 17:08:08'),(2,'Zapateria Brazil - San Ignacio','PE','06','0609','060901','Jr. Junin N°126','Brazil@gmail.com','918858741','0001',NULL,NULL,NULL,NULL,NULL,'default',0,'default','2022-03-17 17:07:55','2022-04-05 12:31:45');

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

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

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

INSERT INTO `exchange_rates` VALUES ('2022-03-17',3.729,3.723,3.723,3.729,'2022-03-17','2022-03-17 17:02:17','2022-03-17 17:02:17'),('2022-03-21',3.776,3.761,3.761,3.776,'2022-03-21','2022-03-21 14:34:32','2022-03-21 14:34:32'),('2022-04-03',3.701,3.695,3.695,3.701,'2022-04-01','2022-04-03 10:27:14','2022-04-03 10:27:14'),('2022-04-05',3.663,3.641,3.641,3.663,'2022-04-02','2022-04-05 01:30:46','2022-04-05 01:30:46'),('2022-04-06',3.690,3.686,3.686,3.690,'2022-04-06','2022-04-06 11:44:41','2022-04-06 11:44:41'),('2022-04-07',3.720,3.710,3.710,3.720,'2022-04-07','2022-04-07 18:37:06','2022-04-07 18:37:06'),('2022-04-08',3.714,3.707,3.707,3.714,'2022-04-08','2022-04-08 20:25:32','2022-04-08 20:25:32'),('2022-04-09',3.714,3.707,3.707,3.714,'2022-04-08','2022-04-09 13:27:18','2022-04-09 13:27:18'),('2022-04-10',3.714,3.707,3.707,3.714,'2022-04-08','2022-04-10 12:11:48','2022-04-10 12:11:48'),('2022-04-11',3.715,3.709,3.709,3.715,'2022-04-09','2022-04-11 18:52:21','2022-04-11 18:52:21'),('2022-04-12',3.721,3.709,3.709,3.721,'2022-04-12','2022-04-12 12:06:27','2022-04-12 12:06:27'),('2022-04-16',3.736,3.728,3.728,3.736,'2022-04-16','2022-04-16 18:39:59','2022-04-16 18:39:59'),('2022-04-17',3.736,3.728,3.728,3.736,'2022-04-17','2022-04-17 13:36:27','2022-04-17 13:36:27'),('2022-04-18',3.736,3.728,3.728,3.736,'2022-04-18','2022-04-18 19:16:30','2022-04-18 19:16:30'),('2022-04-19',3.742,3.730,3.730,3.742,'2022-04-19','2022-04-19 13:56:19','2022-04-19 13:56:19'),('2022-04-20',3.736,3.725,3.725,3.736,'2022-04-20','2022-04-20 12:30:09','2022-04-20 12:30:09'),('2022-04-22',3.734,3.723,3.723,3.734,'2022-04-22','2022-04-22 18:54:56','2022-04-22 18:54:56'),('2022-04-23',3.766,3.758,3.758,3.766,'2022-04-23','2022-04-23 10:25:21','2022-04-23 10:25:21'),('2022-04-24',3.766,3.758,3.758,3.766,'2022-04-24','2022-04-24 14:02:22','2022-04-24 14:02:22'),('2022-04-25',3.766,3.758,3.758,3.766,'2022-04-24','2022-04-25 14:29:17','2022-04-25 14:29:17'),('2022-04-26',3.766,3.758,3.758,3.766,'2022-04-25','2022-04-26 18:47:36','2022-04-26 18:47:36'),('2022-04-27',3.818,3.811,3.811,3.818,'2022-04-27','2022-04-27 17:08:57','2022-04-27 17:08:57'),('2022-04-28',3.830,3.824,3.824,3.830,'2022-04-28','2022-04-28 20:39:33','2022-04-28 20:39:33'),('2022-04-29',3.852,3.846,3.846,3.852,'2022-04-29','2022-04-29 14:43:44','2022-04-29 14:43:44'),('2022-04-30',3.838,3.830,3.830,3.838,'2022-04-30','2022-04-30 11:01:00','2022-04-30 11:01:00'),('2022-05-01',3.838,3.830,3.830,3.838,'2022-04-30','2022-05-01 13:52:27','2022-05-01 13:52:27'),('2022-05-02',3.838,3.830,3.830,3.838,'2022-05-02','2022-05-02 13:37:25','2022-05-02 13:37:25'),('2022-05-03',3.848,3.838,3.838,3.848,'2022-05-03','2022-05-03 14:45:26','2022-05-03 14:45:26'),('2022-05-04',3.826,3.824,3.824,3.826,'2022-05-04','2022-05-04 15:37:23','2022-05-04 15:37:23'),('2022-05-05',3.805,3.797,3.797,3.805,'2022-05-05','2022-05-05 17:55:06','2022-05-05 17:55:06'),('2022-05-06',3.790,3.786,3.786,3.790,'2022-05-06','2022-05-06 13:13:43','2022-05-06 13:13:43'),('2022-05-07',3.811,3.803,3.803,3.811,'2022-05-07','2022-05-07 09:51:20','2022-05-07 09:51:20'),('2022-05-08',3.811,3.803,3.803,3.811,'2022-05-08','2022-05-08 10:28:14','2022-05-08 10:28:14'),('2022-05-09',3.811,3.803,3.803,3.811,'2022-05-09','2022-05-09 17:06:21','2022-05-09 17:06:21'),('2022-05-10',3.814,3.814,3.814,3.814,'2022-05-10','2022-05-10 10:44:43','2022-05-10 10:44:43'),('2022-05-11',3.816,3.810,3.810,3.816,'2022-05-11','2022-05-11 15:10:38','2022-05-11 15:10:38'),('2022-05-12',3.788,3.780,3.780,3.788,'2022-05-12','2022-05-12 17:41:38','2022-05-12 17:41:38'),('2022-05-13',3.801,3.795,3.795,3.801,'2022-05-13','2022-05-13 14:42:59','2022-05-13 14:42:59'),('2022-05-14',3.786,3.772,3.772,3.786,'2022-05-14','2022-05-14 11:42:12','2022-05-14 11:42:12'),('2022-05-15',3.786,3.772,3.772,3.786,'2022-05-15','2022-05-15 14:41:11','2022-05-15 14:41:11'),('2022-05-16',3.786,3.772,3.772,3.786,'2022-05-16','2022-05-16 16:46:51','2022-05-16 16:46:51'),('2022-05-17',3.787,3.777,3.777,3.787,'2022-05-17','2022-05-17 19:21:34','2022-05-17 19:21:34'),('2022-05-18',3.762,3.755,3.755,3.762,'2022-05-18','2022-05-18 15:37:46','2022-05-18 15:37:46'),('2022-05-19',3.772,3.766,3.766,3.772,'2022-05-19','2022-05-19 13:13:58','2022-05-19 13:13:58'),('2022-05-20',3.754,3.745,3.745,3.754,'2022-05-20','2022-05-20 16:32:45','2022-05-20 16:32:45'),('2022-05-21',3.738,3.728,3.728,3.738,'2022-05-21','2022-05-21 12:39:20','2022-05-21 12:39:20'),('2022-05-22',3.738,3.728,3.728,3.738,'2022-05-22','2022-05-22 13:13:10','2022-05-22 13:13:10'),('2022-05-23',3.738,3.728,3.728,3.738,'2022-05-23','2022-05-23 18:53:39','2022-05-23 18:53:39'),('2022-05-24',3.720,3.711,3.711,3.720,'2022-05-24','2022-05-24 10:09:45','2022-05-24 10:09:45'),('2022-05-25',3.719,3.713,3.713,3.719,'2022-05-25','2022-05-25 17:46:00','2022-05-25 17:46:00'),('2022-05-27',3.663,3.657,3.657,3.663,'2022-05-27','2022-05-27 21:15:06','2022-05-27 21:15:06'),('2022-05-28',3.669,3.663,3.663,3.669,'2022-05-28','2022-05-28 11:16:17','2022-05-28 11:16:17'),('2022-05-29',3.669,3.663,3.663,3.669,'2022-05-29','2022-05-29 14:15:23','2022-05-29 14:15:23'),('2022-05-30',3.669,3.663,3.663,3.669,'2022-05-30','2022-05-30 11:34:59','2022-05-30 11:34:59'),('2022-05-31',3.683,3.665,3.665,3.683,'2022-05-31','2022-05-31 16:16:08','2022-05-31 16:16:08'),('2022-06-01',3.707,3.695,3.695,3.707,'2022-06-01','2022-06-01 09:23:22','2022-06-01 09:23:22'),('2022-06-02',3.726,3.718,3.718,3.726,'2022-06-02','2022-06-02 19:16:57','2022-06-02 19:16:57'),('2022-06-03',3.714,3.707,3.707,3.714,'2022-06-03','2022-06-03 16:56:51','2022-06-03 16:56:51'),('2022-06-04',3.712,3.702,3.702,3.712,'2022-06-04','2022-06-04 11:33:47','2022-06-04 11:33:47'),('2022-06-06',3.712,3.702,3.702,3.712,'2022-06-06','2022-06-06 12:58:30','2022-06-06 12:58:30'),('2022-06-07',3.731,3.724,3.724,3.731,'2022-06-07','2022-06-07 11:49:40','2022-06-07 11:49:40'),('2022-06-08',3.755,3.747,3.747,3.755,'2022-06-08','2022-06-08 15:52:27','2022-06-08 15:52:27'),('2022-06-09',3.758,3.751,3.751,3.758,'2022-06-09','2022-06-09 12:17:57','2022-06-09 12:17:57'),('2022-06-10',3.756,3.749,3.749,3.756,'2022-06-10','2022-06-10 11:28:58','2022-06-10 11:28:58'),('2022-06-11',3.778,3.765,3.765,3.778,'2022-06-11','2022-06-11 15:53:24','2022-06-11 15:53:24'),('2022-06-12',3.778,3.765,3.765,3.778,'2022-06-12','2022-06-12 12:19:15','2022-06-12 12:19:15'),('2022-06-13',3.778,3.765,3.765,3.778,'2022-06-13','2022-06-13 11:48:01','2022-06-13 11:48:01'),('2022-06-14',3.783,3.779,3.779,3.783,'2022-06-14','2022-06-14 13:29:25','2022-06-14 13:29:25'),('2022-06-15',3.783,3.779,3.779,3.783,'2022-06-14','2022-06-15 02:36:36','2022-06-15 02:36:36'),('2022-06-16',3.731,3.719,3.719,3.731,'2022-06-16','2022-06-16 14:31:07','2022-06-16 14:31:07'),('2022-06-17',3.727,3.718,3.718,3.727,'2022-06-17','2022-06-17 16:34:45','2022-06-17 16:34:45'),('2022-06-18',3.728,3.715,3.715,3.728,'2022-06-18','2022-06-18 10:02:50','2022-06-18 10:02:50'),('2022-06-19',3.728,3.715,3.715,3.728,'2022-06-19','2022-06-19 13:50:41','2022-06-19 13:50:41'),('2022-06-20',3.728,3.715,3.715,3.728,'2022-06-20','2022-06-20 19:35:36','2022-06-20 19:35:36'),('2022-06-21',3.729,3.714,3.714,3.729,'2022-06-21','2022-06-21 12:14:01','2022-06-21 12:14:01'),('2022-06-22',3.724,3.717,3.717,3.724,'2022-06-22','2022-06-22 12:03:27','2022-06-22 12:03:27'),('2022-06-23',3.731,3.724,3.724,3.731,'2022-06-23','2022-06-23 15:10:37','2022-06-23 15:10:37'),('2022-06-24',3.753,3.747,3.747,3.753,'2022-06-24','2022-06-24 14:46:58','2022-06-24 14:46:58'),('2022-06-25',3.753,3.747,3.747,3.753,'2022-06-24','2022-06-25 11:07:25','2022-06-25 11:07:25'),('2022-06-26',3.753,3.747,3.747,3.753,'2022-06-24','2022-06-26 10:12:46','2022-06-26 10:12:46'),('2022-06-27',3.782,3.774,3.774,3.782,'2022-06-25','2022-06-27 15:37:03','2022-06-27 15:37:03'),('2022-06-28',3.791,3.783,3.783,3.791,'2022-06-28','2022-06-28 16:21:41','2022-06-28 16:21:41'),('2022-06-29',3.791,3.783,3.783,3.791,'2022-06-28','2022-06-29 14:54:53','2022-06-29 14:54:53'),('2022-06-30',3.788,3.770,3.770,3.788,'2022-06-29','2022-06-30 17:06:13','2022-06-30 17:06:13'),('2022-07-01',3.830,3.820,3.820,3.830,'2022-07-01','2022-07-01 14:15:13','2022-07-01 14:15:13'),('2022-07-02',3.830,3.820,3.820,3.830,'2022-07-01','2022-07-02 11:21:05','2022-07-02 11:21:05'),('2022-07-03',3.830,3.820,3.820,3.830,'2022-07-01','2022-07-03 13:08:37','2022-07-03 13:08:37'),('2022-07-04',3.854,3.843,3.843,3.854,'2022-07-02','2022-07-04 10:05:23','2022-07-04 10:05:23'),('2022-07-05',3.854,3.843,3.843,3.854,'2022-07-02','2022-07-05 08:43:04','2022-07-05 08:43:04'),('2022-07-06',3.862,3.856,3.856,3.862,'2022-07-06','2022-07-06 10:36:21','2022-07-06 10:36:21'),('2022-07-07',3.888,3.878,3.878,3.888,'2022-07-07','2022-07-07 09:19:31','2022-07-07 09:19:31'),('2022-07-08',3.888,3.881,3.881,3.888,'2022-07-08','2022-07-08 14:32:22','2022-07-08 14:32:22'),('2022-07-09',3.888,3.881,3.881,3.888,'2022-07-08','2022-07-09 16:35:05','2022-07-09 16:35:05'),('2022-07-10',3.888,3.881,3.881,3.888,'2022-07-08','2022-07-10 09:36:32','2022-07-10 09:36:32'),('2022-07-11',3.905,3.897,3.897,3.905,'2022-07-09','2022-07-11 15:43:49','2022-07-11 15:43:49'),('2022-07-13',3.972,3.965,3.965,3.972,'2022-07-13','2022-07-13 20:06:35','2022-07-13 20:06:35'),('2022-07-14',3.968,3.959,3.959,3.968,'2022-07-14','2022-07-14 16:10:48','2022-07-14 16:10:48'),('2022-07-15',3.958,3.951,3.951,3.958,'2022-07-15','2022-07-15 12:31:52','2022-07-15 12:31:52'),('2022-07-16',3.958,3.951,3.951,3.958,'2022-07-15','2022-07-16 11:13:09','2022-07-16 11:13:09'),('2022-07-17',3.958,3.951,3.951,3.958,'2022-07-15','2022-07-17 10:46:23','2022-07-17 10:46:23'),('2022-07-18',3.906,3.884,3.884,3.906,'2022-07-16','2022-07-18 11:11:33','2022-07-18 11:11:33'),('2022-07-19',3.892,3.884,3.884,3.892,'2022-07-19','2022-07-19 19:47:41','2022-07-19 19:47:41'),('2022-07-20',3.892,3.884,3.884,3.892,'2022-07-19','2022-07-20 17:43:44','2022-07-20 17:43:44'),('2022-07-21',3.892,3.884,3.884,3.892,'2022-07-19','2022-07-21 19:32:44','2022-07-21 19:32:44'),('2022-07-22',3.892,3.884,3.884,3.892,'2022-07-19','2022-07-22 14:16:53','2022-07-22 14:16:53'),('2022-07-26',3.919,3.910,3.910,3.919,'2022-07-26','2022-07-26 12:28:26','2022-07-26 12:28:26'),('2022-07-27',3.921,3.911,3.911,3.921,'2022-07-27','2022-07-27 11:39:11','2022-07-27 11:39:11'),('2022-07-28',3.925,3.916,3.916,3.925,'2022-07-28','2022-07-28 14:20:07','2022-07-28 14:20:07'),('2022-07-29',3.925,3.916,3.916,3.925,'2022-07-29','2022-07-29 19:49:31','2022-07-29 19:49:31'),('2022-07-30',3.925,3.916,3.916,3.925,'2022-07-30','2022-07-30 19:54:18','2022-07-30 19:54:18'),('2022-07-31',3.925,3.916,3.916,3.925,'2022-07-31','2022-07-31 10:08:24','2022-07-31 10:08:24'),('2022-08-01',3.925,3.916,3.916,3.925,'2022-08-01','2022-08-01 18:52:37','2022-08-01 18:52:37'),('2022-08-02',3.897,3.885,3.885,3.897,'2022-08-02','2022-08-02 12:45:40','2022-08-02 12:45:40'),('2022-08-03',3.919,3.914,3.914,3.919,'2022-08-03','2022-08-03 13:30:24','2022-08-03 13:30:24'),('2022-08-04',3.920,3.914,3.914,3.920,'2022-08-04','2022-08-04 09:25:35','2022-08-04 09:25:35'),('2022-08-05',3.897,3.885,3.885,3.897,'2022-08-05','2022-08-05 11:15:20','2022-08-05 11:15:20'),('2022-08-06',3.905,3.896,3.896,3.905,'2022-08-06','2022-08-06 14:07:35','2022-08-06 14:07:35'),('2022-08-07',3.905,3.896,3.896,3.905,'2022-08-07','2022-08-07 09:53:52','2022-08-07 09:53:52'),('2022-08-08',3.905,3.896,3.896,3.905,'2022-08-08','2022-08-08 20:13:20','2022-08-08 20:13:20'),('2022-08-09',3.916,3.911,3.911,3.916,'2022-08-09','2022-08-09 11:15:41','2022-08-09 11:15:41'),('2022-08-10',3.932,3.927,3.927,3.932,'2022-08-10','2022-08-10 19:35:55','2022-08-10 19:35:55'),('2022-08-11',3.899,3.893,3.893,3.899,'2022-08-11','2022-08-11 20:01:08','2022-08-11 20:01:08'),('2022-08-12',3.888,3.882,3.882,3.888,'2022-08-12','2022-08-12 20:39:06','2022-08-12 20:39:06'),('2022-08-13',3.865,3.859,3.859,3.865,'2022-08-13','2022-08-13 17:48:51','2022-08-13 17:48:51'),('2022-08-14',3.865,3.859,3.859,3.865,'2022-08-14','2022-08-14 11:25:47','2022-08-14 11:25:47'),('2022-08-15',3.865,3.859,3.859,3.865,'2022-08-15','2022-08-15 19:09:02','2022-08-15 19:09:02'),('2022-08-16',3.856,3.849,3.849,3.856,'2022-08-16','2022-08-16 11:24:42','2022-08-16 11:24:42'),('2022-08-17',3.860,3.858,3.858,3.860,'2022-08-17','2022-08-17 18:08:09','2022-08-17 18:08:09'),('2022-08-18',3.847,3.838,3.838,3.847,'2022-08-18','2022-08-18 19:56:47','2022-08-18 19:56:47'),('2022-08-19',3.847,3.838,3.838,3.847,'2022-08-19','2022-08-19 20:49:32','2022-08-19 20:49:32'),('2022-08-20',3.857,3.850,3.850,3.857,'2022-08-20','2022-08-20 16:35:31','2022-08-20 16:35:31'),('2022-08-21',3.857,3.850,3.850,3.857,'2022-08-21','2022-08-21 14:03:21','2022-08-21 14:03:21'),('2022-08-22',3.857,3.850,3.850,3.857,'2022-08-22','2022-08-22 20:09:04','2022-08-22 20:09:04'),('2022-08-25',3.867,3.861,3.861,3.867,'2022-08-25','2022-08-25 22:17:03','2022-08-25 22:17:03'),('2022-08-26',3.861,3.849,3.849,3.861,'2022-08-26','2022-08-26 17:57:50','2022-08-26 17:57:50'),('2022-08-27',3.847,3.836,3.836,3.847,'2022-08-27','2022-08-27 10:22:31','2022-08-27 10:22:31'),('2022-08-28',3.847,3.836,3.836,3.847,'2022-08-28','2022-08-28 12:05:12','2022-08-28 12:05:12'),('2022-08-29',3.847,3.836,3.836,3.847,'2022-08-29','2022-08-29 16:56:31','2022-08-29 16:56:31'),('2022-08-30',3.838,3.829,3.829,3.838,'2022-08-30','2022-08-30 12:38:20','2022-08-30 12:38:20'),('2022-08-31',3.838,3.829,3.829,3.838,'2022-08-31','2022-08-31 18:47:44','2022-08-31 18:47:44'),('2022-09-01',3.847,3.839,3.839,3.847,'2022-09-01','2022-09-01 19:32:27','2022-09-01 19:32:27'),('2022-09-02',3.865,3.859,3.859,3.865,'2022-09-02','2022-09-02 19:50:20','2022-09-02 19:50:20'),('2022-09-03',3.876,3.866,3.866,3.876,'2022-09-03','2022-09-03 13:15:23','2022-09-03 13:15:23'),('2022-09-04',3.876,3.866,3.866,3.876,'2022-09-04','2022-09-04 12:24:37','2022-09-04 12:24:37'),('2022-09-05',3.876,3.866,3.866,3.876,'2022-09-05','2022-09-05 21:04:56','2022-09-05 21:04:56'),('2022-09-06',3.885,3.873,3.873,3.885,'2022-09-06','2022-09-06 21:35:37','2022-09-06 21:35:37'),('2022-09-07',3.897,3.892,3.892,3.897,'2022-09-07','2022-09-07 20:09:05','2022-09-07 20:09:05'),('2022-09-08',3.896,3.891,3.891,3.896,'2022-09-08','2022-09-08 20:01:38','2022-09-08 20:01:38'),('2022-09-09',3.881,3.872,3.872,3.881,'2022-09-09','2022-09-09 11:14:14','2022-09-09 11:14:14'),('2022-09-10',3.883,3.876,3.876,3.883,'2022-09-10','2022-09-10 17:27:07','2022-09-10 17:27:07'),('2022-09-11',3.883,3.876,3.876,3.883,'2022-09-11','2022-09-11 12:29:11','2022-09-11 12:29:11'),('2022-09-12',3.883,3.876,3.876,3.883,'2022-09-12','2022-09-12 19:32:37','2022-09-12 19:32:37'),('2022-09-13',3.859,3.852,3.852,3.859,'2022-09-13','2022-09-13 20:43:13','2022-09-13 20:43:13'),('2022-09-14',3.862,3.858,3.858,3.862,'2022-09-14','2022-09-14 19:51:59','2022-09-14 19:51:59'),('2022-09-15',3.875,3.870,3.870,3.875,'2022-09-15','2022-09-15 19:29:33','2022-09-15 19:29:33'),('2022-09-16',3.892,3.883,3.883,3.892,'2022-09-16','2022-09-16 19:19:54','2022-09-16 19:19:54'),('2022-09-17',3.883,3.875,3.875,3.883,'2022-09-17','2022-09-17 20:14:22','2022-09-17 20:14:22'),('2022-09-18',3.883,3.875,3.875,3.883,'2022-09-18','2022-09-18 14:48:52','2022-09-18 14:48:52'),('2022-09-19',3.883,3.875,3.875,3.883,'2022-09-19','2022-09-19 10:50:58','2022-09-19 10:50:58'),('2022-09-20',3.871,3.862,3.862,3.871,'2022-09-20','2022-09-20 10:38:14','2022-09-20 10:38:14'),('2022-09-21',3.883,3.877,3.877,3.883,'2022-09-21','2022-09-21 16:01:55','2022-09-21 16:01:55'),('2022-09-22',3.903,3.894,3.894,3.903,'2022-09-22','2022-09-22 21:14:28','2022-09-22 21:14:28'),('2022-09-23',3.913,3.903,3.903,3.913,'2022-09-23','2022-09-23 11:00:21','2022-09-23 11:00:21'),('2022-09-24',3.911,3.906,3.906,3.911,'2022-09-24','2022-09-24 15:47:43','2022-09-24 15:47:43'),('2022-09-25',3.911,3.906,3.906,3.911,'2022-09-25','2022-09-25 13:26:38','2022-09-25 13:26:38'),('2022-09-26',3.911,3.906,3.906,3.911,'2022-09-26','2022-09-26 15:12:56','2022-09-26 15:12:56'),('2022-09-28',3.949,3.943,3.943,3.949,'2022-09-28','2022-09-28 20:51:55','2022-09-28 20:51:55'),('2022-09-29',3.952,3.947,3.947,3.952,'2022-09-29','2022-09-29 20:08:27','2022-09-29 20:08:27'),('2022-09-30',3.971,3.965,3.965,3.971,'2022-09-30','2022-09-30 18:49:03','2022-09-30 18:49:03'),('2022-10-01',3.984,3.978,3.978,3.984,'2022-10-01','2022-10-01 19:40:42','2022-10-01 19:40:42'),('2022-10-02',3.984,3.978,3.978,3.984,'2022-10-02','2022-10-02 10:47:05','2022-10-02 10:47:05'),('2022-10-03',3.984,3.978,3.978,3.984,'2022-10-03','2022-10-03 17:46:43','2022-10-03 17:46:43'),('2022-10-04',3.969,3.963,3.963,3.969,'2022-10-04','2022-10-04 18:18:07','2022-10-04 18:18:07'),('2022-10-05',3.955,3.948,3.948,3.955,'2022-10-05','2022-10-05 14:45:54','2022-10-05 14:45:54'),('2022-10-06',3.966,3.960,3.960,3.966,'2022-10-06','2022-10-06 18:32:44','2022-10-06 18:32:44'),('2022-10-07',3.983,3.977,3.977,3.983,'2022-10-07','2022-10-07 10:01:37','2022-10-07 10:01:37'),('2022-10-08',3.980,3.972,3.972,3.980,'2022-10-08','2022-10-08 19:16:16','2022-10-08 19:16:16'),('2022-10-11',3.967,3.959,3.959,3.967,'2022-10-11','2022-10-11 19:51:33','2022-10-11 19:51:33'),('2022-10-12',3.972,3.968,3.968,3.972,'2022-10-12','2022-10-12 20:15:49','2022-10-12 20:15:49'),('2022-10-13',3.984,3.981,3.981,3.984,'2022-10-13','2022-10-13 11:38:00','2022-10-13 11:38:00'),('2022-10-14',3.984,3.981,3.981,3.984,'2022-10-13','2022-10-14 19:29:26','2022-10-14 19:29:26'),('2022-10-15',3.984,3.981,3.981,3.984,'2022-10-13','2022-10-15 11:29:27','2022-10-15 11:29:27'),('2022-10-16',3.984,3.981,3.981,3.984,'2022-10-13','2022-10-16 10:17:26','2022-10-16 10:17:26'),('2022-10-20',3.985,3.981,3.981,3.985,'2022-10-20','2022-10-20 20:40:44','2022-10-20 20:40:44'),('2022-10-21',3.978,3.973,3.973,3.978,'2022-10-21','2022-10-21 19:42:35','2022-10-21 19:42:35'),('2022-10-22',3.984,3.979,3.979,3.984,'2022-10-22','2022-10-22 17:02:48','2022-10-22 17:02:48'),('2022-10-23',3.984,3.979,3.979,3.984,'2022-10-23','2022-10-23 12:36:30','2022-10-23 12:36:30'),('2022-10-24',3.984,3.979,3.979,3.984,'2022-10-24','2022-10-24 13:08:31','2022-10-24 13:08:31'),('2022-10-26',4.002,3.992,3.992,4.002,'2022-10-26','2022-10-26 18:59:46','2022-10-26 18:59:46'),('2022-10-27',3.996,3.988,3.988,3.996,'2022-10-27','2022-10-27 10:14:46','2022-10-27 10:14:46'),('2022-10-28',3.987,3.976,3.976,3.987,'2022-10-28','2022-10-28 12:09:53','2022-10-28 12:09:53'),('2022-10-29',3.978,3.970,3.970,3.978,'2022-10-29','2022-10-29 11:41:09','2022-10-29 11:41:09'),('2022-10-30',3.978,3.970,3.970,3.978,'2022-10-30','2022-10-30 12:56:39','2022-10-30 12:56:39'),('2022-10-31',3.978,3.970,3.970,3.978,'2022-10-31','2022-10-31 20:39:06','2022-10-31 20:39:06'),('2022-11-02',3.993,3.984,3.984,3.993,'2022-11-02','2022-11-02 19:41:14','2022-11-02 19:41:14'),('2022-11-04',3.973,3.965,3.965,3.973,'2022-11-04','2022-11-04 21:05:36','2022-11-04 21:05:36'),('2022-11-05',3.962,3.953,3.953,3.962,'2022-11-05','2022-11-05 12:26:23','2022-11-05 12:26:23'),('2022-11-06',3.962,3.953,3.953,3.962,'2022-11-06','2022-11-06 13:44:50','2022-11-06 13:44:50'),('2022-11-07',3.962,3.953,3.953,3.962,'2022-11-07','2022-11-07 20:01:37','2022-11-07 20:01:37'),('2022-11-08',3.957,3.949,3.949,3.957,'2022-11-08','2022-11-08 19:46:42','2022-11-08 19:46:42'),('2022-11-09',3.936,3.924,3.924,3.936,'2022-11-09','2022-11-09 20:28:49','2022-11-09 20:28:49'),('2022-11-10',3.918,3.911,3.911,3.918,'2022-11-10','2022-11-10 18:43:16','2022-11-10 18:43:16'),('2022-11-11',3.870,3.866,3.866,3.870,'2022-11-11','2022-11-11 16:48:47','2022-11-11 16:48:47'),('2022-11-12',3.860,3.854,3.854,3.860,'2022-11-12','2022-11-12 20:14:53','2022-11-12 20:14:53'),('2022-11-13',3.860,3.854,3.854,3.860,'2022-11-13','2022-11-13 11:09:40','2022-11-13 11:09:40'),('2022-11-14',3.860,3.854,3.854,3.860,'2022-11-14','2022-11-14 18:53:03','2022-11-14 18:53:03'),('2022-11-15',3.860,3.856,3.856,3.860,'2022-11-15','2022-11-15 20:20:57','2022-11-15 20:20:57'),('2022-11-16',3.838,3.833,3.833,3.838,'2022-11-16','2022-11-16 19:36:40','2022-11-16 19:36:40'),('2022-11-17',3.842,3.837,3.837,3.842,'2022-11-17','2022-11-17 14:12:15','2022-11-17 14:12:15'),('2022-11-18',3.845,3.840,3.840,3.845,'2022-11-18','2022-11-18 16:02:09','2022-11-18 16:02:09'),('2022-11-19',3.841,3.827,3.827,3.841,'2022-11-19','2022-11-19 20:20:40','2022-11-19 20:20:40'),('2022-11-20',3.841,3.827,3.827,3.841,'2022-11-20','2022-11-20 13:01:27','2022-11-20 13:01:27'),('2022-11-21',3.841,3.827,3.827,3.841,'2022-11-21','2022-11-21 19:53:24','2022-11-21 19:53:24'),('2022-11-22',3.838,3.831,3.831,3.838,'2022-11-22','2022-11-22 19:51:21','2022-11-22 19:51:21'),('2022-11-23',3.846,3.842,3.842,3.846,'2022-11-23','2022-11-23 21:28:27','2022-11-23 21:28:27'),('2022-11-24',3.852,3.848,3.848,3.852,'2022-11-24','2022-11-24 20:23:32','2022-11-24 20:23:32'),('2022-11-25',3.850,3.839,3.839,3.850,'2022-11-25','2022-11-25 20:53:57','2022-11-25 20:53:57'),('2022-11-26',3.873,3.865,3.865,3.873,'2022-11-26','2022-11-26 20:14:49','2022-11-26 20:14:49'),('2022-11-27',3.873,3.865,3.865,3.873,'2022-11-27','2022-11-27 22:27:18','2022-11-27 22:27:18'),('2022-11-28',3.873,3.865,3.865,3.873,'2022-11-28','2022-11-28 18:04:20','2022-11-28 18:04:20'),('2022-11-29',3.861,3.851,3.851,3.861,'2022-11-29','2022-11-29 12:15:11','2022-11-29 12:15:11'),('2022-12-01',3.854,3.849,3.849,3.854,'2022-12-01','2022-12-01 20:48:53','2022-12-01 20:48:53'),('2022-12-02',3.836,3.827,3.827,3.836,'2022-12-02','2022-12-02 20:27:46','2022-12-02 20:27:46'),('2022-12-03',3.835,3.826,3.826,3.835,'2022-12-03','2022-12-03 20:26:04','2022-12-03 20:26:04'),('2022-12-04',3.835,3.826,3.826,3.835,'2022-12-04','2022-12-04 20:39:08','2022-12-04 20:39:08'),('2022-12-05',3.835,3.826,3.826,3.835,'2022-12-05','2022-12-05 20:24:04','2022-12-05 20:24:04'),('2022-12-06',3.848,3.844,3.844,3.848,'2022-12-06','2022-12-06 12:34:13','2022-12-06 12:34:13'),('2022-12-07',3.851,3.843,3.843,3.851,'2022-12-07','2022-12-07 12:18:11','2022-12-07 12:18:11'),('2022-12-08',3.851,3.830,3.830,3.851,'2022-12-08','2022-12-08 18:31:55','2022-12-08 18:31:55'),('2022-12-09',3.851,3.830,3.830,3.851,'2022-12-09','2022-12-09 18:31:31','2022-12-09 18:31:31'),('2022-12-10',3.851,3.830,3.830,3.851,'2022-12-10','2022-12-10 19:49:06','2022-12-10 19:49:06'),('2022-12-11',3.851,3.830,3.830,3.851,'2022-12-11','2022-12-11 12:13:30','2022-12-11 12:13:30'),('2022-12-12',3.851,3.830,3.830,3.851,'2022-12-12','2022-12-12 10:06:51','2022-12-12 10:06:51'),('2022-12-13',3.840,3.828,3.828,3.840,'2022-12-13','2022-12-13 17:15:31','2022-12-13 17:15:31'),('2022-12-14',3.835,3.826,3.826,3.835,'2022-12-14','2022-12-14 11:21:35','2022-12-14 11:21:35'),('2022-12-15',3.841,3.831,3.831,3.841,'2022-12-15','2022-12-15 12:53:28','2022-12-15 12:53:28'),('2022-12-16',3.849,3.841,3.841,3.849,'2022-12-16','2022-12-16 19:57:28','2022-12-16 19:57:28'),('2022-12-17',3.853,3.842,3.842,3.853,'2022-12-17','2022-12-17 19:53:42','2022-12-17 19:53:42'),('2022-12-19',3.853,3.842,3.842,3.853,'2022-12-17','2022-12-19 20:14:20','2022-12-19 20:14:20'),('2022-12-21',3.839,3.826,3.826,3.839,'2022-12-21','2022-12-21 20:41:00','2022-12-21 20:41:00'),('2022-12-22',3.825,3.815,3.815,3.825,'2022-12-22','2022-12-22 20:55:16','2022-12-22 20:55:16'),('2022-12-23',3.819,3.807,3.807,3.819,'2022-12-23','2022-12-23 20:40:31','2022-12-23 20:40:31'),('2022-12-24',3.827,3.809,3.809,3.827,'2022-12-24','2022-12-24 22:00:57','2022-12-24 22:00:57'),('2022-12-28',3.822,3.815,3.815,3.822,'2022-12-28','2022-12-28 20:20:22','2022-12-28 20:20:22'),('2022-12-29',3.817,3.807,3.807,3.817,'2022-12-29','2022-12-29 21:08:33','2022-12-29 21:08:33'),('2022-12-30',3.818,3.809,3.809,3.818,'2022-12-30','2022-12-30 20:24:35','2022-12-30 20:24:35'),('2022-12-31',3.820,3.808,3.808,3.820,'2022-12-31','2022-12-31 17:06:49','2022-12-31 17:06:49'),('2023-01-02',3.820,3.808,3.808,3.820,'2022-12-31','2023-01-02 20:22:49','2023-01-02 20:22:49'),('2023-01-04',3.823,3.812,3.812,3.823,'2023-01-04','2023-01-04 20:33:53','2023-01-04 20:33:53'),('2023-01-05',3.827,3.822,3.822,3.827,'2023-01-05','2023-01-05 20:16:21','2023-01-05 20:16:21'),('2023-01-06',3.830,3.824,3.824,3.830,'2023-01-06','2023-01-06 10:05:28','2023-01-06 10:05:28'),('2023-01-07',3.806,3.800,3.800,3.806,'2023-01-07','2023-01-07 18:57:00','2023-01-07 18:57:00'),('2023-01-11',3.806,3.802,3.802,3.806,'2023-01-11','2023-01-11 19:34:05','2023-01-11 19:34:05'),('2023-01-12',3.783,3.782,3.782,3.783,'2023-01-12','2023-01-12 19:30:14','2023-01-12 19:30:14'),('2023-01-13',3.784,3.779,3.779,3.784,'2023-01-13','2023-01-13 20:06:59','2023-01-13 20:06:59'),('2023-01-14',3.806,3.802,3.802,3.806,'2023-01-14','2023-01-14 20:04:45','2023-01-14 20:04:45'),('2023-01-17',3.822,3.815,3.815,3.822,'2023-01-17','2023-01-17 21:35:36','2023-01-17 21:35:36'),('2023-01-18',3.842,3.837,3.837,3.842,'2023-01-18','2023-01-18 21:38:12','2023-01-18 21:38:12'),('2023-01-19',3.836,3.829,3.829,3.836,'2023-01-19','2023-01-19 11:41:35','2023-01-19 11:41:35'),('2023-01-20',3.861,3.857,3.857,3.861,'2023-01-20','2023-01-20 19:35:56','2023-01-20 19:35:56'),('2023-01-21',3.859,3.852,3.852,3.859,'2023-01-21','2023-01-21 17:41:12','2023-01-21 17:41:12'),('2023-01-23',3.859,3.852,3.852,3.859,'2023-01-21','2023-01-23 13:14:54','2023-01-23 13:14:54'),('2023-01-24',3.873,3.866,3.866,3.873,'2023-01-24','2023-01-24 11:25:54','2023-01-24 11:25:54'),('2023-01-25',3.885,3.880,3.880,3.885,'2023-01-25','2023-01-25 08:26:53','2023-01-25 08:26:53'),('2023-01-26',3.900,3.892,3.892,3.900,'2023-01-26','2023-01-26 19:54:03','2023-01-26 19:54:03'),('2023-01-28',3.829,3.824,3.824,3.829,'2023-01-28','2023-01-28 20:25:57','2023-01-28 20:25:57'),('2023-01-30',3.829,3.824,3.824,3.829,'2023-01-28','2023-01-30 14:36:55','2023-01-30 14:36:55'),('2023-01-31',3.859,3.853,3.853,3.859,'2023-01-31','2023-01-31 19:31:22','2023-01-31 19:31:22'),('2023-02-01',3.851,3.844,3.844,3.851,'2023-02-01','2023-02-01 19:42:19','2023-02-01 19:42:19'),('2023-02-02',3.848,3.843,3.843,3.848,'2023-02-02','2023-02-02 11:12:23','2023-02-02 11:12:23'),('2023-02-03',3.835,3.830,3.830,3.835,'2023-02-03','2023-02-03 19:41:22','2023-02-03 19:41:22'),('2023-02-04',3.847,3.843,3.843,3.847,'2023-02-04','2023-02-04 13:34:54','2023-02-04 13:34:54'),('2023-02-06',3.847,3.843,3.843,3.847,'2023-02-04','2023-02-06 19:49:40','2023-02-06 19:49:40'),('2023-02-07',3.855,3.849,3.849,3.855,'2023-02-07','2023-02-07 18:30:24','2023-02-07 18:30:24'),('2023-02-08',3.848,3.843,3.843,3.848,'2023-02-08','2023-02-08 21:04:14','2023-02-08 21:04:14'),('2023-02-09',3.856,3.852,3.852,3.856,'2023-02-09','2023-02-09 20:00:25','2023-02-09 20:00:25'),('2023-02-10',3.869,3.863,3.863,3.869,'2023-02-10','2023-02-10 12:01:37','2023-02-10 12:01:37'),('2023-02-11',3.858,3.853,3.853,3.858,'2023-02-11','2023-02-11 20:31:50','2023-02-11 20:31:50'),('2023-02-12',3.858,3.853,3.853,3.858,'2023-02-11','2023-02-12 13:08:40','2023-02-12 13:08:40'),('2023-02-13',3.858,3.853,3.853,3.858,'2023-02-11','2023-02-13 10:08:27','2023-02-13 10:08:27'),('2023-02-14',3.854,3.849,3.849,3.854,'2023-02-14','2023-02-14 20:24:03','2023-02-14 20:24:03'),('2023-02-15',3.861,3.858,3.858,3.861,'2023-02-15','2023-02-15 10:20:55','2023-02-15 10:20:55'),('2023-02-16',3.865,3.858,3.858,3.865,'2023-02-16','2023-02-16 19:59:29','2023-02-16 19:59:29'),('2023-02-17',3.868,3.862,3.862,3.868,'2023-02-17','2023-02-17 14:23:09','2023-02-17 14:23:09'),('2023-02-18',3.849,3.839,3.839,3.849,'2023-02-18','2023-02-18 11:01:52','2023-02-18 11:01:52'),('2023-02-20',3.849,3.839,3.839,3.849,'2023-02-18','2023-02-20 21:04:42','2023-02-20 21:04:42'),('2023-02-21',3.850,3.840,3.840,3.850,'2023-02-21','2023-02-21 11:19:01','2023-02-21 11:19:01'),('2023-02-22',3.836,3.831,3.831,3.836,'2023-02-22','2023-02-22 19:17:57','2023-02-22 19:17:57'),('2023-02-23',3.827,3.821,3.821,3.827,'2023-02-23','2023-02-23 19:31:53','2023-02-23 19:31:53'),('2023-02-24',3.805,3.800,3.800,3.805,'2023-02-24','2023-02-24 19:29:10','2023-02-24 19:29:10'),('2023-02-25',3.820,3.810,3.810,3.820,'2023-02-25','2023-02-25 16:12:44','2023-02-25 16:12:44'),('2023-02-27',3.820,3.810,3.810,3.820,'2023-02-25','2023-02-27 20:25:21','2023-02-27 20:25:21'),('2023-02-28',3.816,3.811,3.811,3.816,'2023-02-28','2023-02-28 14:48:00','2023-02-28 14:48:00'),('2023-03-01',3.810,3.803,3.803,3.810,'2023-03-01','2023-03-01 19:57:18','2023-03-01 19:57:18');

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

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

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


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

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

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

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

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

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

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


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

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

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

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

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

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

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

INSERT INTO `expense_types` VALUES (1,'PLANILLA','2022-03-17 16:55:57','2022-03-17 16:55:57'),(2,'RECIBO POR HONORARIO','2022-03-17 16:55:57','2022-03-17 16:55:57'),(3,'SERVICIO PÚBLICO','2022-03-17 16:55:57','2022-03-17 16:55:57'),(4,'OTROS','2022-03-17 16:55:57','2022-03-17 16:55:57');

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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

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

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

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

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

INSERT INTO `global_payments` VALUES (12,'02',4,'App\\Models\\Tenant\\Cash',4,'Modules\\Pos\\Models\\CashTransaction',2,'2022-04-05 12:18:00','2022-04-05 12:18:00'),(13,'02',5,'App\\Models\\Tenant\\Cash',5,'Modules\\Pos\\Models\\CashTransaction',3,'2022-04-05 12:29:03','2022-04-05 12:29:03'),(14,'02',5,'App\\Models\\Tenant\\Cash',7,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-05 12:36:10','2022-04-05 12:36:10'),(15,'02',5,'App\\Models\\Tenant\\Cash',8,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-05 12:45:41','2022-04-05 12:45:41'),(16,'02',5,'App\\Models\\Tenant\\Cash',9,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-05 13:05:50','2022-04-05 13:05:50'),(17,'02',5,'App\\Models\\Tenant\\Cash',10,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-05 13:11:07','2022-04-05 13:11:07'),(18,'02',5,'App\\Models\\Tenant\\Cash',11,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-06 17:49:53','2022-04-06 17:49:53'),(19,'02',5,'App\\Models\\Tenant\\Cash',12,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-06 17:52:39','2022-04-06 17:52:39'),(20,'02',5,'App\\Models\\Tenant\\Cash',13,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-06 18:11:44','2022-04-06 18:11:44'),(21,'02',4,'App\\Models\\Tenant\\Cash',14,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-06 18:54:14','2022-04-06 18:54:14'),(22,'02',5,'App\\Models\\Tenant\\Cash',15,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-07 18:41:10','2022-04-07 18:41:10'),(23,'02',5,'App\\Models\\Tenant\\Cash',16,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-07 18:42:40','2022-04-07 18:42:40'),(24,'02',5,'App\\Models\\Tenant\\Cash',17,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-07 18:47:26','2022-04-07 18:47:26'),(25,'02',4,'App\\Models\\Tenant\\Cash',18,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-07 20:23:10','2022-04-07 20:23:10'),(26,'02',5,'App\\Models\\Tenant\\Cash',19,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-08 20:26:28','2022-04-08 20:26:28'),(27,'02',5,'App\\Models\\Tenant\\Cash',20,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-08 20:29:20','2022-04-08 20:29:20'),(28,'02',4,'App\\Models\\Tenant\\Cash',21,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-08 20:48:41','2022-04-08 20:48:41'),(29,'02',4,'App\\Models\\Tenant\\Cash',22,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-09 14:46:04','2022-04-09 14:46:04'),(30,'02',4,'App\\Models\\Tenant\\Cash',23,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-09 14:48:20','2022-04-09 14:48:20'),(31,'02',5,'App\\Models\\Tenant\\Cash',24,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-09 17:34:48','2022-04-09 17:34:48'),(32,'02',5,'App\\Models\\Tenant\\Cash',25,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-09 17:37:33','2022-04-09 17:37:33'),(33,'02',5,'App\\Models\\Tenant\\Cash',26,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-09 17:39:40','2022-04-09 17:39:40'),(34,'02',5,'App\\Models\\Tenant\\Cash',27,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-10 12:13:13','2022-04-10 12:13:13'),(35,'02',5,'App\\Models\\Tenant\\Cash',28,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-10 12:14:32','2022-04-10 12:14:32'),(36,'02',5,'App\\Models\\Tenant\\Cash',29,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-10 14:46:21','2022-04-10 14:46:21'),(37,'02',5,'App\\Models\\Tenant\\Cash',30,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-11 18:53:12','2022-04-11 18:53:12'),(38,'02',5,'App\\Models\\Tenant\\Cash',31,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-11 18:53:56','2022-04-11 18:53:56'),(39,'02',4,'App\\Models\\Tenant\\Cash',32,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-11 20:56:28','2022-04-11 20:56:28'),(40,'02',4,'App\\Models\\Tenant\\Cash',33,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-11 20:58:38','2022-04-11 20:58:38'),(41,'02',5,'App\\Models\\Tenant\\Cash',34,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-12 12:06:37','2022-04-12 12:06:37'),(42,'02',5,'App\\Models\\Tenant\\Cash',35,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-12 12:07:12','2022-04-12 12:07:12'),(43,'02',5,'App\\Models\\Tenant\\Cash',36,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-12 12:07:48','2022-04-12 12:07:48'),(44,'02',5,'App\\Models\\Tenant\\Cash',37,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-12 12:08:16','2022-04-12 12:08:16'),(45,'02',4,'App\\Models\\Tenant\\Cash',38,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-12 16:58:05','2022-04-12 16:58:05'),(46,'02',4,'App\\Models\\Tenant\\Cash',39,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-12 17:03:04','2022-04-12 17:03:04'),(47,'02',4,'App\\Models\\Tenant\\Cash',40,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-12 17:05:20','2022-04-12 17:05:20'),(48,'02',4,'App\\Models\\Tenant\\Cash',41,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-16 18:41:32','2022-04-16 18:41:32'),(49,'02',4,'App\\Models\\Tenant\\Cash',42,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-16 18:42:15','2022-04-16 18:42:15'),(50,'02',5,'App\\Models\\Tenant\\Cash',43,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-16 19:19:59','2022-04-16 19:19:59'),(51,'02',5,'App\\Models\\Tenant\\Cash',44,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-16 19:20:50','2022-04-16 19:20:50'),(52,'02',5,'App\\Models\\Tenant\\Cash',45,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-17 13:38:39','2022-04-17 13:38:39'),(53,'02',5,'App\\Models\\Tenant\\Cash',46,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-17 13:39:23','2022-04-17 13:39:23'),(54,'02',4,'App\\Models\\Tenant\\Cash',47,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-17 13:40:06','2022-04-17 13:40:06'),(55,'02',4,'App\\Models\\Tenant\\Cash',48,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-17 13:41:34','2022-04-17 13:41:34'),(56,'02',4,'App\\Models\\Tenant\\Cash',49,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-17 13:43:17','2022-04-17 13:43:17'),(57,'02',4,'App\\Models\\Tenant\\Cash',50,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-18 19:17:17','2022-04-18 19:17:17'),(58,'02',5,'App\\Models\\Tenant\\Cash',51,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-18 19:29:49','2022-04-18 19:29:49'),(59,'02',5,'App\\Models\\Tenant\\Cash',52,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-18 19:40:47','2022-04-18 19:40:47'),(60,'02',5,'App\\Models\\Tenant\\Cash',53,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-19 13:59:15','2022-04-19 13:59:15'),(61,'02',5,'App\\Models\\Tenant\\Cash',54,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-19 14:01:08','2022-04-19 14:01:08'),(62,'02',5,'App\\Models\\Tenant\\Cash',55,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-19 14:07:05','2022-04-19 14:07:05'),(63,'02',4,'App\\Models\\Tenant\\Cash',56,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-19 20:22:52','2022-04-19 20:22:52'),(64,'02',4,'App\\Models\\Tenant\\Cash',57,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-19 20:25:51','2022-04-19 20:25:51'),(65,'02',5,'App\\Models\\Tenant\\Cash',58,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-20 12:35:43','2022-04-20 12:35:43'),(66,'02',5,'App\\Models\\Tenant\\Cash',59,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-20 12:37:35','2022-04-20 12:37:35'),(67,'02',4,'App\\Models\\Tenant\\Cash',60,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-20 19:42:47','2022-04-20 19:42:47'),(68,'02',4,'App\\Models\\Tenant\\Cash',61,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-20 19:48:37','2022-04-20 19:48:37'),(69,'02',5,'App\\Models\\Tenant\\Cash',62,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-22 18:55:17','2022-04-22 18:55:17'),(70,'02',5,'App\\Models\\Tenant\\Cash',63,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-22 18:55:52','2022-04-22 18:55:52'),(71,'02',4,'App\\Models\\Tenant\\Cash',64,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-22 21:03:20','2022-04-22 21:03:20'),(72,'02',4,'App\\Models\\Tenant\\Cash',65,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-22 21:05:13','2022-04-22 21:05:13'),(73,'02',4,'App\\Models\\Tenant\\Cash',66,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-23 10:26:36','2022-04-23 10:26:36'),(74,'02',5,'App\\Models\\Tenant\\Cash',67,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-23 18:53:43','2022-04-23 18:53:43'),(75,'02',5,'App\\Models\\Tenant\\Cash',68,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-23 18:55:14','2022-04-23 18:55:14'),(76,'02',4,'App\\Models\\Tenant\\Cash',69,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-23 21:09:34','2022-04-23 21:09:34'),(77,'02',5,'App\\Models\\Tenant\\Cash',70,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-24 14:03:32','2022-04-24 14:03:32'),(78,'02',5,'App\\Models\\Tenant\\Cash',71,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-24 14:08:15','2022-04-24 14:08:15'),(79,'02',5,'App\\Models\\Tenant\\Cash',72,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-24 14:17:41','2022-04-24 14:17:41'),(80,'02',5,'App\\Models\\Tenant\\Cash',73,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-25 14:29:32','2022-04-25 14:29:32'),(81,'02',5,'App\\Models\\Tenant\\Cash',74,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-25 14:29:53','2022-04-25 14:29:53'),(82,'02',4,'App\\Models\\Tenant\\Cash',75,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-25 16:53:39','2022-04-25 16:53:39'),(83,'02',4,'App\\Models\\Tenant\\Cash',76,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-25 18:15:25','2022-04-25 18:15:25'),(84,'02',4,'App\\Models\\Tenant\\Cash',77,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-25 20:32:54','2022-04-25 20:32:54'),(85,'02',4,'App\\Models\\Tenant\\Cash',78,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-26 18:48:24','2022-04-26 18:48:24'),(86,'02',4,'App\\Models\\Tenant\\Cash',79,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-26 18:48:53','2022-04-26 18:48:53'),(87,'02',4,'App\\Models\\Tenant\\Cash',80,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-26 18:49:13','2022-04-26 18:49:13'),(88,'02',4,'App\\Models\\Tenant\\Cash',81,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-27 17:09:52','2022-04-27 17:09:52'),(89,'02',4,'App\\Models\\Tenant\\Cash',82,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-27 17:10:29','2022-04-27 17:10:29'),(90,'02',5,'App\\Models\\Tenant\\Cash',83,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-27 19:09:48','2022-04-27 19:09:48'),(91,'02',5,'App\\Models\\Tenant\\Cash',84,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-28 20:43:03','2022-04-28 20:43:03'),(92,'02',5,'App\\Models\\Tenant\\Cash',85,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-28 20:43:46','2022-04-28 20:43:46'),(93,'02',5,'App\\Models\\Tenant\\Cash',86,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-28 20:44:32','2022-04-28 20:44:32'),(94,'02',5,'App\\Models\\Tenant\\Cash',87,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-29 14:46:56','2022-04-29 14:46:56'),(95,'02',5,'App\\Models\\Tenant\\Cash',88,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-29 14:48:10','2022-04-29 14:48:10'),(96,'02',4,'App\\Models\\Tenant\\Cash',89,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-29 20:55:11','2022-04-29 20:55:11'),(97,'02',4,'App\\Models\\Tenant\\Cash',90,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-29 21:14:44','2022-04-29 21:14:44'),(98,'02',4,'App\\Models\\Tenant\\Cash',91,'App\\Models\\Tenant\\DocumentPayment',2,'2022-04-30 12:44:24','2022-04-30 12:44:24'),(99,'02',5,'App\\Models\\Tenant\\Cash',92,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-30 16:19:06','2022-04-30 16:19:06'),(100,'02',5,'App\\Models\\Tenant\\Cash',93,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-30 16:21:12','2022-04-30 16:21:12'),(101,'02',5,'App\\Models\\Tenant\\Cash',94,'App\\Models\\Tenant\\DocumentPayment',3,'2022-04-30 19:16:22','2022-04-30 19:16:22'),(102,'02',5,'App\\Models\\Tenant\\Cash',95,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-01 13:53:12','2022-05-01 13:53:12'),(103,'02',4,'App\\Models\\Tenant\\Cash',96,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-01 14:05:43','2022-05-01 14:05:43'),(104,'02',4,'App\\Models\\Tenant\\Cash',97,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-01 14:06:06','2022-05-01 14:06:06'),(105,'02',5,'App\\Models\\Tenant\\Cash',98,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-02 13:39:36','2022-05-02 13:39:36'),(106,'02',5,'App\\Models\\Tenant\\Cash',99,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-02 15:58:34','2022-05-02 15:58:34'),(107,'02',4,'App\\Models\\Tenant\\Cash',100,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-02 20:41:01','2022-05-02 20:41:01'),(108,'02',4,'App\\Models\\Tenant\\Cash',101,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-02 20:41:32','2022-05-02 20:41:32'),(109,'02',4,'App\\Models\\Tenant\\Cash',102,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-03 15:35:56','2022-05-03 15:35:56'),(110,'02',5,'App\\Models\\Tenant\\Cash',103,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-03 16:22:41','2022-05-03 16:22:41'),(111,'02',4,'App\\Models\\Tenant\\Cash',104,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-03 18:44:48','2022-05-03 18:44:48'),(112,'02',5,'App\\Models\\Tenant\\Cash',105,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-04 16:02:11','2022-05-04 16:02:11'),(113,'02',4,'App\\Models\\Tenant\\Cash',106,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-04 16:11:56','2022-05-04 16:11:56'),(114,'02',5,'App\\Models\\Tenant\\Cash',107,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-04 16:12:35','2022-05-04 16:12:35'),(115,'02',4,'App\\Models\\Tenant\\Cash',108,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-04 19:46:28','2022-05-04 19:46:28'),(116,'02',4,'App\\Models\\Tenant\\Cash',109,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-05 17:55:57','2022-05-05 17:55:57'),(117,'02',5,'App\\Models\\Tenant\\Cash',110,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-05 18:17:43','2022-05-05 18:17:43'),(118,'02',5,'App\\Models\\Tenant\\Cash',111,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-05 18:20:21','2022-05-05 18:20:21'),(119,'02',5,'App\\Models\\Tenant\\Cash',112,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-05 18:22:29','2022-05-05 18:22:29'),(120,'02',5,'App\\Models\\Tenant\\Cash',113,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-05 18:27:12','2022-05-05 18:27:12'),(121,'02',5,'App\\Models\\Tenant\\Cash',114,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-05 18:29:14','2022-05-05 18:29:14'),(122,'02',5,'App\\Models\\Tenant\\Cash',115,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-06 13:15:18','2022-05-06 13:15:18'),(123,'02',5,'App\\Models\\Tenant\\Cash',116,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-06 18:31:22','2022-05-06 18:31:22'),(124,'02',5,'App\\Models\\Tenant\\Cash',117,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-07 09:51:37','2022-05-07 09:51:37'),(125,'02',5,'App\\Models\\Tenant\\Cash',118,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-07 20:36:18','2022-05-07 20:36:18'),(126,'02',5,'App\\Models\\Tenant\\Cash',119,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-08 10:29:27','2022-05-08 10:29:27'),(127,'02',5,'App\\Models\\Tenant\\Cash',120,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-08 12:03:19','2022-05-08 12:03:19'),(128,'02',4,'App\\Models\\Tenant\\Cash',121,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-08 12:20:28','2022-05-08 12:20:28'),(129,'02',4,'App\\Models\\Tenant\\Cash',122,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-08 12:21:57','2022-05-08 12:21:57'),(130,'02',4,'App\\Models\\Tenant\\Cash',123,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-08 15:27:23','2022-05-08 15:27:23'),(131,'02',4,'App\\Models\\Tenant\\Cash',124,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-09 17:06:42','2022-05-09 17:06:42'),(132,'02',5,'App\\Models\\Tenant\\Cash',125,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-09 17:58:14','2022-05-09 17:58:14'),(133,'02',5,'App\\Models\\Tenant\\Cash',126,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-09 19:18:26','2022-05-09 19:18:26'),(134,'02',4,'App\\Models\\Tenant\\Cash',127,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-09 21:16:11','2022-05-09 21:16:11'),(135,'02',4,'App\\Models\\Tenant\\Cash',128,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-10 10:45:54','2022-05-10 10:45:54'),(136,'02',4,'App\\Models\\Tenant\\Cash',129,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-10 12:10:35','2022-05-10 12:10:35'),(137,'02',5,'App\\Models\\Tenant\\Cash',130,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-10 15:14:44','2022-05-10 15:14:44'),(138,'02',5,'App\\Models\\Tenant\\Cash',131,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-11 15:13:30','2022-05-11 15:13:30'),(139,'02',5,'App\\Models\\Tenant\\Cash',132,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-11 18:54:18','2022-05-11 18:54:18'),(140,'02',5,'App\\Models\\Tenant\\Cash',133,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-11 18:56:49','2022-05-11 18:56:49'),(141,'02',4,'App\\Models\\Tenant\\Cash',134,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-11 19:36:46','2022-05-11 19:36:46'),(142,'02',4,'App\\Models\\Tenant\\Cash',135,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-11 19:37:15','2022-05-11 19:37:15'),(143,'02',5,'App\\Models\\Tenant\\Cash',136,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-12 17:43:16','2022-05-12 17:43:16'),(144,'02',5,'App\\Models\\Tenant\\Cash',137,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-12 17:45:06','2022-05-12 17:45:06'),(145,'02',4,'App\\Models\\Tenant\\Cash',138,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-12 20:55:27','2022-05-12 20:55:27'),(146,'02',4,'App\\Models\\Tenant\\Cash',139,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-12 21:02:09','2022-05-12 21:02:09'),(147,'02',5,'App\\Models\\Tenant\\Cash',140,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-13 14:50:13','2022-05-13 14:50:13'),(148,'02',4,'App\\Models\\Tenant\\Cash',141,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-13 20:53:41','2022-05-13 20:53:41'),(149,'02',4,'App\\Models\\Tenant\\Cash',142,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-13 20:54:16','2022-05-13 20:54:16'),(150,'02',4,'App\\Models\\Tenant\\Cash',143,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-14 11:45:02','2022-05-14 11:45:02'),(151,'02',5,'App\\Models\\Tenant\\Cash',144,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-14 19:59:25','2022-05-14 19:59:25'),(152,'02',5,'App\\Models\\Tenant\\Cash',145,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-15 14:43:18','2022-05-15 14:43:18'),(153,'02',4,'App\\Models\\Tenant\\Cash',146,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-16 17:41:11','2022-05-16 17:41:11'),(154,'02',5,'App\\Models\\Tenant\\Cash',147,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-16 17:57:39','2022-05-16 17:57:39'),(155,'02',5,'App\\Models\\Tenant\\Cash',148,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-16 18:54:51','2022-05-16 18:54:51'),(156,'02',4,'App\\Models\\Tenant\\Cash',149,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-16 19:15:02','2022-05-16 19:15:02'),(157,'02',5,'App\\Models\\Tenant\\Cash',150,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-17 19:21:56','2022-05-17 19:21:56'),(158,'02',4,'App\\Models\\Tenant\\Cash',151,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-17 19:49:16','2022-05-17 19:49:16'),(159,'02',4,'App\\Models\\Tenant\\Cash',152,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-18 15:38:59','2022-05-18 15:38:59'),(160,'02',4,'App\\Models\\Tenant\\Cash',153,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-18 17:06:57','2022-05-18 17:06:57'),(161,'02',4,'App\\Models\\Tenant\\Cash',154,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-18 21:10:18','2022-05-18 21:10:18'),(162,'02',5,'App\\Models\\Tenant\\Cash',155,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-19 13:14:32','2022-05-19 13:14:32'),(163,'02',4,'App\\Models\\Tenant\\Cash',156,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-19 19:03:08','2022-05-19 19:03:08'),(164,'02',4,'App\\Models\\Tenant\\Cash',157,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-19 19:03:57','2022-05-19 19:03:57'),(165,'02',4,'App\\Models\\Tenant\\Cash',158,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-20 16:34:42','2022-05-20 16:34:42'),(166,'02',4,'App\\Models\\Tenant\\Cash',159,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-20 16:43:59','2022-05-20 16:43:59'),(167,'02',5,'App\\Models\\Tenant\\Cash',160,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-20 19:28:10','2022-05-20 19:28:10'),(168,'02',4,'App\\Models\\Tenant\\Cash',161,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-21 12:40:11','2022-05-21 12:40:11'),(169,'02',4,'App\\Models\\Tenant\\Cash',162,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-21 12:56:40','2022-05-21 12:56:40'),(170,'02',5,'App\\Models\\Tenant\\Cash',163,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-21 15:25:23','2022-05-21 15:25:23'),(171,'02',5,'App\\Models\\Tenant\\Cash',164,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-21 19:29:26','2022-05-21 19:29:26'),(172,'02',5,'App\\Models\\Tenant\\Cash',165,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-21 19:29:51','2022-05-21 19:29:51'),(173,'02',5,'App\\Models\\Tenant\\Cash',166,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-22 13:13:48','2022-05-22 13:13:48'),(174,'02',4,'App\\Models\\Tenant\\Cash',167,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-23 19:04:00','2022-05-23 19:04:00'),(175,'02',4,'App\\Models\\Tenant\\Cash',168,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-23 19:07:27','2022-05-23 19:07:27'),(176,'02',5,'App\\Models\\Tenant\\Cash',169,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-23 20:13:24','2022-05-23 20:13:24'),(177,'02',5,'App\\Models\\Tenant\\Cash',170,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-24 10:10:53','2022-05-24 10:10:53'),(178,'02',5,'App\\Models\\Tenant\\Cash',171,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-24 10:16:15','2022-05-24 10:16:15'),(179,'02',4,'App\\Models\\Tenant\\Cash',172,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-25 20:42:09','2022-05-25 20:42:09'),(180,'02',5,'App\\Models\\Tenant\\Cash',173,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-25 20:45:52','2022-05-25 20:45:52'),(181,'02',4,'App\\Models\\Tenant\\Cash',174,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-27 21:16:20','2022-05-27 21:16:20'),(182,'02',5,'App\\Models\\Tenant\\Cash',175,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-27 22:33:41','2022-05-27 22:33:41'),(183,'02',4,'App\\Models\\Tenant\\Cash',176,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-28 12:22:16','2022-05-28 12:22:16'),(184,'02',4,'App\\Models\\Tenant\\Cash',177,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-28 13:53:00','2022-05-28 13:53:00'),(185,'02',5,'App\\Models\\Tenant\\Cash',178,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-28 19:55:11','2022-05-28 19:55:11'),(186,'02',5,'App\\Models\\Tenant\\Cash',179,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-29 14:15:42','2022-05-29 14:15:42'),(187,'02',4,'App\\Models\\Tenant\\Cash',180,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-30 11:36:13','2022-05-30 11:36:13'),(188,'02',5,'App\\Models\\Tenant\\Cash',181,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-30 19:54:06','2022-05-30 19:54:06'),(189,'02',4,'App\\Models\\Tenant\\Cash',182,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-31 16:17:26','2022-05-31 16:17:26'),(190,'02',4,'App\\Models\\Tenant\\Cash',183,'App\\Models\\Tenant\\DocumentPayment',2,'2022-05-31 16:52:24','2022-05-31 16:52:24'),(191,'02',5,'App\\Models\\Tenant\\Cash',184,'App\\Models\\Tenant\\DocumentPayment',3,'2022-05-31 19:09:38','2022-05-31 19:09:38'),(192,'02',4,'App\\Models\\Tenant\\Cash',185,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-01 09:25:45','2022-06-01 09:25:45'),(193,'02',5,'App\\Models\\Tenant\\Cash',186,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-01 19:39:31','2022-06-01 19:39:31'),(194,'02',5,'App\\Models\\Tenant\\Cash',187,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-02 19:17:23','2022-06-02 19:17:23'),(195,'02',5,'App\\Models\\Tenant\\Cash',188,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-03 16:57:42','2022-06-03 16:57:42'),(196,'02',5,'App\\Models\\Tenant\\Cash',189,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-03 19:58:09','2022-06-03 19:58:09'),(197,'02',4,'App\\Models\\Tenant\\Cash',190,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-03 20:50:36','2022-06-03 20:50:36'),(198,'02',5,'App\\Models\\Tenant\\Cash',191,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-04 11:34:44','2022-06-04 11:34:44'),(199,'02',4,'App\\Models\\Tenant\\Cash',192,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-04 12:15:29','2022-06-04 12:15:29'),(200,'02',4,'App\\Models\\Tenant\\Cash',193,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-04 13:19:32','2022-06-04 13:19:32'),(201,'02',5,'App\\Models\\Tenant\\Cash',194,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-04 16:02:06','2022-06-04 16:02:06'),(202,'02',4,'App\\Models\\Tenant\\Cash',195,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-06 12:59:37','2022-06-06 12:59:37'),(203,'02',4,'App\\Models\\Tenant\\Cash',196,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-06 14:45:51','2022-06-06 14:45:51'),(204,'02',4,'App\\Models\\Tenant\\Cash',197,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-06 16:19:29','2022-06-06 16:19:29'),(205,'02',4,'App\\Models\\Tenant\\Cash',198,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-08 16:32:01','2022-06-08 16:32:01'),(206,'02',4,'App\\Models\\Tenant\\Cash',199,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-08 20:39:12','2022-06-08 20:39:12'),(207,'02',4,'App\\Models\\Tenant\\Cash',200,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-09 18:03:04','2022-06-09 18:03:04'),(208,'02',5,'App\\Models\\Tenant\\Cash',201,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-09 19:41:35','2022-06-09 19:41:35'),(209,'02',4,'App\\Models\\Tenant\\Cash',202,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-10 11:29:31','2022-06-10 11:29:31'),(210,'02',4,'App\\Models\\Tenant\\Cash',203,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-10 11:32:42','2022-06-10 11:32:42'),(211,'02',5,'App\\Models\\Tenant\\Cash',204,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-10 19:26:48','2022-06-10 19:26:48'),(212,'02',4,'App\\Models\\Tenant\\Cash',205,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-11 15:56:38','2022-06-11 15:56:38'),(213,'02',4,'App\\Models\\Tenant\\Cash',206,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-11 15:58:52','2022-06-11 15:58:52'),(214,'02',5,'App\\Models\\Tenant\\Cash',207,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-11 20:49:35','2022-06-11 20:49:35'),(215,'02',4,'App\\Models\\Tenant\\Cash',208,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-12 12:19:58','2022-06-12 12:19:58'),(216,'02',4,'App\\Models\\Tenant\\Cash',209,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-13 11:50:37','2022-06-13 11:50:37'),(217,'02',4,'App\\Models\\Tenant\\Cash',210,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-13 12:01:59','2022-06-13 12:01:59'),(219,'02',4,'App\\Models\\Tenant\\Cash',212,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-13 12:39:12','2022-06-13 12:39:12'),(220,'02',5,'App\\Models\\Tenant\\Cash',213,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-13 20:04:38','2022-06-13 20:04:38'),(221,'02',5,'App\\Models\\Tenant\\Cash',214,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-14 13:29:38','2022-06-14 13:29:38'),(222,'02',6,'App\\Models\\Tenant\\Cash',6,'Modules\\Pos\\Models\\CashTransaction',1,'2022-06-15 02:37:08','2022-06-15 02:37:08'),(223,'02',4,'App\\Models\\Tenant\\Cash',215,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-16 16:40:08','2022-06-16 16:40:08'),(224,'02',5,'App\\Models\\Tenant\\Cash',216,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-16 18:58:13','2022-06-16 18:58:13'),(225,'02',5,'App\\Models\\Tenant\\Cash',217,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-16 19:57:08','2022-06-16 19:57:08'),(226,'02',5,'App\\Models\\Tenant\\Cash',218,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-17 16:37:25','2022-06-17 16:37:25'),(227,'02',5,'App\\Models\\Tenant\\Cash',219,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-17 19:23:25','2022-06-17 19:23:25'),(228,'02',4,'App\\Models\\Tenant\\Cash',220,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-18 10:04:01','2022-06-18 10:04:01'),(229,'02',4,'App\\Models\\Tenant\\Cash',221,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-18 10:30:57','2022-06-18 10:30:57'),(230,'02',5,'App\\Models\\Tenant\\Cash',222,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-18 19:42:40','2022-06-18 19:42:40'),(231,'02',5,'App\\Models\\Tenant\\Cash',223,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-19 13:50:50','2022-06-19 13:50:50'),(232,'02',4,'App\\Models\\Tenant\\Cash',224,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-19 14:52:17','2022-06-19 14:52:17'),(233,'02',4,'App\\Models\\Tenant\\Cash',225,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-19 15:52:59','2022-06-19 15:52:59'),(234,'02',4,'App\\Models\\Tenant\\Cash',226,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-19 16:38:37','2022-06-19 16:38:37'),(235,'02',5,'App\\Models\\Tenant\\Cash',227,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-20 19:46:10','2022-06-20 19:46:10'),(236,'02',5,'App\\Models\\Tenant\\Cash',228,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-20 19:48:23','2022-06-20 19:48:23'),(237,'02',5,'App\\Models\\Tenant\\Cash',229,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-20 19:51:32','2022-06-20 19:51:32'),(238,'02',5,'App\\Models\\Tenant\\Cash',230,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-21 12:14:49','2022-06-21 12:14:49'),(239,'02',5,'App\\Models\\Tenant\\Cash',231,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-21 12:18:03','2022-06-21 12:18:03'),(240,'02',5,'App\\Models\\Tenant\\Cash',232,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-21 12:19:09','2022-06-21 12:19:09'),(241,'02',4,'App\\Models\\Tenant\\Cash',233,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-21 17:49:50','2022-06-21 17:49:50'),(242,'02',4,'App\\Models\\Tenant\\Cash',234,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-21 18:39:19','2022-06-21 18:39:19'),(243,'02',4,'App\\Models\\Tenant\\Cash',235,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-22 12:04:48','2022-06-22 12:04:48'),(244,'02',5,'App\\Models\\Tenant\\Cash',236,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-22 16:00:39','2022-06-22 16:00:39'),(245,'02',5,'App\\Models\\Tenant\\Cash',237,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-23 15:12:20','2022-06-23 15:12:20'),(246,'02',4,'App\\Models\\Tenant\\Cash',238,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-23 21:01:14','2022-06-23 21:01:14'),(247,'02',4,'App\\Models\\Tenant\\Cash',239,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-24 14:50:22','2022-06-24 14:50:22'),(248,'02',4,'App\\Models\\Tenant\\Cash',240,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-24 14:52:53','2022-06-24 14:52:53'),(249,'02',5,'App\\Models\\Tenant\\Cash',241,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-24 20:19:25','2022-06-24 20:19:25'),(250,'02',4,'App\\Models\\Tenant\\Cash',242,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-24 20:54:11','2022-06-24 20:54:11'),(251,'02',5,'App\\Models\\Tenant\\Cash',243,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-25 11:08:20','2022-06-25 11:08:20'),(252,'02',5,'App\\Models\\Tenant\\Cash',244,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-25 11:41:27','2022-06-25 11:41:27'),(253,'02',4,'App\\Models\\Tenant\\Cash',245,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-25 17:08:15','2022-06-25 17:08:15'),(254,'02',5,'App\\Models\\Tenant\\Cash',246,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-25 19:41:17','2022-06-25 19:41:17'),(255,'02',4,'App\\Models\\Tenant\\Cash',247,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-26 10:14:13','2022-06-26 10:14:13'),(256,'02',5,'App\\Models\\Tenant\\Cash',248,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-26 10:28:48','2022-06-26 10:28:48'),(257,'02',4,'App\\Models\\Tenant\\Cash',249,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-26 10:36:56','2022-06-26 10:36:56'),(258,'02',5,'App\\Models\\Tenant\\Cash',250,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-26 14:01:37','2022-06-26 14:01:37'),(259,'02',4,'App\\Models\\Tenant\\Cash',251,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-27 15:41:51','2022-06-27 15:41:51'),(260,'02',5,'App\\Models\\Tenant\\Cash',252,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-27 19:29:08','2022-06-27 19:29:08'),(261,'02',5,'App\\Models\\Tenant\\Cash',253,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-28 16:27:08','2022-06-28 16:27:08'),(262,'02',4,'App\\Models\\Tenant\\Cash',254,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-29 14:57:16','2022-06-29 14:57:16'),(263,'02',5,'App\\Models\\Tenant\\Cash',255,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-29 20:04:36','2022-06-29 20:04:36'),(264,'02',4,'App\\Models\\Tenant\\Cash',256,'App\\Models\\Tenant\\DocumentPayment',2,'2022-06-29 21:27:08','2022-06-29 21:27:08'),(265,'02',5,'App\\Models\\Tenant\\Cash',257,'App\\Models\\Tenant\\DocumentPayment',3,'2022-06-30 17:06:27','2022-06-30 17:06:27'),(266,'02',5,'App\\Models\\Tenant\\Cash',258,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-01 14:59:49','2022-07-01 14:59:49'),(267,'02',4,'App\\Models\\Tenant\\Cash',259,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-01 19:46:42','2022-07-01 19:46:42'),(268,'02',5,'App\\Models\\Tenant\\Cash',260,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-01 19:52:45','2022-07-01 19:52:45'),(269,'02',4,'App\\Models\\Tenant\\Cash',261,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-01 20:21:14','2022-07-01 20:21:14'),(270,'02',5,'App\\Models\\Tenant\\Cash',262,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-02 11:21:42','2022-07-02 11:21:42'),(271,'02',5,'App\\Models\\Tenant\\Cash',263,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-02 11:57:10','2022-07-02 11:57:10'),(272,'02',5,'App\\Models\\Tenant\\Cash',264,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-02 16:22:11','2022-07-02 16:22:11'),(273,'02',5,'App\\Models\\Tenant\\Cash',265,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-02 20:00:57','2022-07-02 20:00:57'),(274,'02',4,'App\\Models\\Tenant\\Cash',266,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-02 20:42:19','2022-07-02 20:42:19'),(275,'02',5,'App\\Models\\Tenant\\Cash',267,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-03 13:08:46','2022-07-03 13:08:46'),(276,'02',5,'App\\Models\\Tenant\\Cash',268,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-04 19:43:18','2022-07-04 19:43:18'),(277,'02',5,'App\\Models\\Tenant\\Cash',269,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-04 19:44:34','2022-07-04 19:44:34'),(278,'02',5,'App\\Models\\Tenant\\Cash',270,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-05 14:55:31','2022-07-05 14:55:31'),(279,'02',5,'App\\Models\\Tenant\\Cash',271,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-05 19:28:33','2022-07-05 19:28:33'),(280,'02',5,'App\\Models\\Tenant\\Cash',272,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-06 10:38:20','2022-07-06 10:38:20'),(281,'02',4,'App\\Models\\Tenant\\Cash',273,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-06 17:17:39','2022-07-06 17:17:39'),(282,'02',4,'App\\Models\\Tenant\\Cash',274,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-06 19:14:57','2022-07-06 19:14:57'),(283,'02',5,'App\\Models\\Tenant\\Cash',275,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-06 19:43:07','2022-07-06 19:43:07'),(284,'02',4,'App\\Models\\Tenant\\Cash',276,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-07 10:14:56','2022-07-07 10:14:56'),(285,'02',5,'App\\Models\\Tenant\\Cash',277,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-07 15:28:34','2022-07-07 15:28:34'),(286,'02',5,'App\\Models\\Tenant\\Cash',278,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-07 19:36:56','2022-07-07 19:36:56'),(287,'02',4,'App\\Models\\Tenant\\Cash',279,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-08 14:35:08','2022-07-08 14:35:08'),(288,'02',5,'App\\Models\\Tenant\\Cash',280,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-08 20:28:46','2022-07-08 20:28:46'),(289,'02',4,'App\\Models\\Tenant\\Cash',281,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-09 16:35:39','2022-07-09 16:35:39'),(290,'02',5,'App\\Models\\Tenant\\Cash',282,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-09 19:59:14','2022-07-09 19:59:14'),(291,'02',4,'App\\Models\\Tenant\\Cash',283,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-10 09:37:03','2022-07-10 09:37:03'),(292,'02',4,'App\\Models\\Tenant\\Cash',284,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-10 10:38:47','2022-07-10 10:38:47'),(293,'02',5,'App\\Models\\Tenant\\Cash',285,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-10 14:14:45','2022-07-10 14:14:45'),(294,'02',5,'App\\Models\\Tenant\\Cash',286,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-11 15:44:00','2022-07-11 15:44:00'),(295,'02',5,'App\\Models\\Tenant\\Cash',287,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-13 20:10:52','2022-07-13 20:10:52'),(296,'02',4,'App\\Models\\Tenant\\Cash',288,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-14 16:11:47','2022-07-14 16:11:47'),(297,'02',5,'App\\Models\\Tenant\\Cash',289,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-14 19:46:48','2022-07-14 19:46:48'),(298,'02',5,'App\\Models\\Tenant\\Cash',290,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-15 12:33:19','2022-07-15 12:33:19'),(299,'02',5,'App\\Models\\Tenant\\Cash',291,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-15 19:25:23','2022-07-15 19:25:23'),(300,'02',4,'App\\Models\\Tenant\\Cash',292,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-15 21:50:19','2022-07-15 21:50:19'),(301,'02',4,'App\\Models\\Tenant\\Cash',293,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-16 14:31:35','2022-07-16 14:31:35'),(302,'02',5,'App\\Models\\Tenant\\Cash',294,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-16 16:25:14','2022-07-16 16:25:14'),(303,'02',5,'App\\Models\\Tenant\\Cash',295,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-16 19:15:50','2022-07-16 19:15:50'),(304,'02',4,'App\\Models\\Tenant\\Cash',296,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-17 10:48:23','2022-07-17 10:48:23'),(305,'02',5,'App\\Models\\Tenant\\Cash',297,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-17 14:09:46','2022-07-17 14:09:46'),(306,'02',5,'App\\Models\\Tenant\\Cash',298,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-18 11:12:26','2022-07-18 11:12:26'),(307,'02',4,'App\\Models\\Tenant\\Cash',299,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-18 20:22:52','2022-07-18 20:22:52'),(308,'02',5,'App\\Models\\Tenant\\Cash',300,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-19 19:48:05','2022-07-19 19:48:05'),(309,'02',5,'App\\Models\\Tenant\\Cash',301,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-20 17:46:01','2022-07-20 17:46:01'),(310,'02',5,'App\\Models\\Tenant\\Cash',302,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-20 19:54:10','2022-07-20 19:54:10'),(311,'02',5,'App\\Models\\Tenant\\Cash',303,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-21 19:33:05','2022-07-21 19:33:05'),(312,'02',4,'App\\Models\\Tenant\\Cash',304,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-22 14:17:28','2022-07-22 14:17:28'),(313,'02',4,'App\\Models\\Tenant\\Cash',305,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-22 19:49:54','2022-07-22 19:49:54'),(314,'02',5,'App\\Models\\Tenant\\Cash',306,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-23 10:12:29','2022-07-23 10:12:29'),(315,'02',5,'App\\Models\\Tenant\\Cash',307,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-23 10:15:57','2022-07-23 10:15:57'),(316,'02',5,'App\\Models\\Tenant\\Cash',308,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-23 10:21:22','2022-07-23 10:21:22'),(317,'02',4,'App\\Models\\Tenant\\Cash',309,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-23 20:43:55','2022-07-23 20:43:55'),(318,'02',4,'App\\Models\\Tenant\\Cash',310,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-24 12:57:05','2022-07-24 12:57:05'),(319,'02',5,'App\\Models\\Tenant\\Cash',311,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-24 14:49:55','2022-07-24 14:49:55'),(320,'02',4,'App\\Models\\Tenant\\Cash',312,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-25 10:32:45','2022-07-25 10:32:45'),(321,'02',5,'App\\Models\\Tenant\\Cash',313,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-25 20:00:57','2022-07-25 20:00:57'),(322,'02',5,'App\\Models\\Tenant\\Cash',314,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-26 12:28:33','2022-07-26 12:28:33'),(323,'02',5,'App\\Models\\Tenant\\Cash',315,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-26 20:20:41','2022-07-26 20:20:41'),(324,'02',5,'App\\Models\\Tenant\\Cash',316,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-27 11:40:22','2022-07-27 11:40:22'),(325,'02',5,'App\\Models\\Tenant\\Cash',317,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-27 20:52:24','2022-07-27 20:52:24'),(326,'02',5,'App\\Models\\Tenant\\Cash',318,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-28 14:20:19','2022-07-28 14:20:19'),(327,'02',4,'App\\Models\\Tenant\\Cash',319,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-28 15:15:18','2022-07-28 15:15:18'),(328,'02',5,'App\\Models\\Tenant\\Cash',320,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-29 19:49:58','2022-07-29 19:49:58'),(329,'02',5,'App\\Models\\Tenant\\Cash',321,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-29 19:50:57','2022-07-29 19:50:57'),(330,'02',5,'App\\Models\\Tenant\\Cash',322,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-29 19:51:19','2022-07-29 19:51:19'),(331,'02',5,'App\\Models\\Tenant\\Cash',323,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-29 19:53:28','2022-07-29 19:53:28'),(332,'02',4,'App\\Models\\Tenant\\Cash',324,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-30 19:55:15','2022-07-30 19:55:15'),(333,'02',5,'App\\Models\\Tenant\\Cash',325,'App\\Models\\Tenant\\DocumentPayment',3,'2022-07-30 20:56:10','2022-07-30 20:56:10'),(334,'02',4,'App\\Models\\Tenant\\Cash',326,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-31 11:35:05','2022-07-31 11:35:05'),(335,'02',4,'App\\Models\\Tenant\\Cash',327,'App\\Models\\Tenant\\DocumentPayment',2,'2022-07-31 11:53:04','2022-07-31 11:53:04'),(336,'02',4,'App\\Models\\Tenant\\Cash',328,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-01 18:53:08','2022-08-01 18:53:08'),(337,'02',5,'App\\Models\\Tenant\\Cash',329,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-01 21:02:31','2022-08-01 21:02:31'),(338,'02',5,'App\\Models\\Tenant\\Cash',330,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-02 12:46:17','2022-08-02 12:46:17'),(339,'02',4,'App\\Models\\Tenant\\Cash',331,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-02 13:51:03','2022-08-02 13:51:03'),(340,'02',4,'App\\Models\\Tenant\\Cash',332,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-03 13:31:16','2022-08-03 13:31:16'),(341,'02',5,'App\\Models\\Tenant\\Cash',333,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-03 20:06:25','2022-08-03 20:06:25'),(342,'02',4,'App\\Models\\Tenant\\Cash',334,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-04 09:30:31','2022-08-04 09:30:31'),(343,'02',4,'App\\Models\\Tenant\\Cash',335,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-04 17:20:16','2022-08-04 17:20:16'),(344,'02',5,'App\\Models\\Tenant\\Cash',336,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-04 19:51:33','2022-08-04 19:51:33'),(345,'02',4,'App\\Models\\Tenant\\Cash',337,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-05 11:16:00','2022-08-05 11:16:00'),(346,'02',4,'App\\Models\\Tenant\\Cash',338,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-05 12:13:10','2022-08-05 12:13:10'),(347,'02',4,'App\\Models\\Tenant\\Cash',339,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-05 15:12:31','2022-08-05 15:12:31'),(348,'02',4,'App\\Models\\Tenant\\Cash',340,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-05 16:26:22','2022-08-05 16:26:22'),(349,'02',5,'App\\Models\\Tenant\\Cash',341,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-05 21:43:03','2022-08-05 21:43:03'),(350,'02',5,'App\\Models\\Tenant\\Cash',342,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-06 14:08:23','2022-08-06 14:08:23'),(351,'02',4,'App\\Models\\Tenant\\Cash',343,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-06 16:46:46','2022-08-06 16:46:46'),(352,'02',5,'App\\Models\\Tenant\\Cash',344,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-06 20:53:26','2022-08-06 20:53:26'),(353,'02',4,'App\\Models\\Tenant\\Cash',345,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-07 11:09:40','2022-08-07 11:09:40'),(354,'02',5,'App\\Models\\Tenant\\Cash',346,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-07 14:33:02','2022-08-07 14:33:02'),(355,'02',5,'App\\Models\\Tenant\\Cash',347,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-08 20:13:35','2022-08-08 20:13:35'),(356,'02',5,'App\\Models\\Tenant\\Cash',348,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-09 11:16:51','2022-08-09 11:16:51'),(357,'02',5,'App\\Models\\Tenant\\Cash',349,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-09 20:08:36','2022-08-09 20:08:36'),(358,'02',4,'App\\Models\\Tenant\\Cash',350,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-09 21:12:51','2022-08-09 21:12:51'),(359,'02',5,'App\\Models\\Tenant\\Cash',351,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-10 19:36:25','2022-08-10 19:36:25'),(360,'02',5,'App\\Models\\Tenant\\Cash',352,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-11 20:01:30','2022-08-11 20:01:30'),(361,'02',4,'App\\Models\\Tenant\\Cash',353,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-11 20:45:11','2022-08-11 20:45:11'),(362,'02',5,'App\\Models\\Tenant\\Cash',354,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-12 20:39:36','2022-08-12 20:39:36'),(363,'02',5,'App\\Models\\Tenant\\Cash',355,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-12 20:40:10','2022-08-12 20:40:10'),(364,'02',5,'App\\Models\\Tenant\\Cash',356,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-13 17:50:00','2022-08-13 17:50:00'),(365,'02',5,'App\\Models\\Tenant\\Cash',357,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-13 20:14:28','2022-08-13 20:14:28'),(366,'02',4,'App\\Models\\Tenant\\Cash',358,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-13 20:16:32','2022-08-13 20:16:32'),(367,'02',4,'App\\Models\\Tenant\\Cash',359,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-14 11:32:47','2022-08-14 11:32:47'),(368,'02',4,'App\\Models\\Tenant\\Cash',360,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-14 11:59:14','2022-08-14 11:59:14'),(369,'02',4,'App\\Models\\Tenant\\Cash',361,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-14 12:38:27','2022-08-14 12:38:27'),(370,'02',5,'App\\Models\\Tenant\\Cash',362,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-14 13:21:30','2022-08-14 13:21:30'),(371,'02',4,'App\\Models\\Tenant\\Cash',363,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-15 19:11:56','2022-08-15 19:11:56'),(372,'02',4,'App\\Models\\Tenant\\Cash',364,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-16 17:52:10','2022-08-16 17:52:10'),(373,'02',5,'App\\Models\\Tenant\\Cash',365,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-16 22:09:11','2022-08-16 22:09:11'),(374,'02',4,'App\\Models\\Tenant\\Cash',366,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-17 18:10:44','2022-08-17 18:10:44'),(375,'02',4,'App\\Models\\Tenant\\Cash',367,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-18 20:06:19','2022-08-18 20:06:19'),(376,'02',5,'App\\Models\\Tenant\\Cash',368,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-18 20:15:30','2022-08-18 20:15:30'),(377,'02',5,'App\\Models\\Tenant\\Cash',369,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-19 20:50:25','2022-08-19 20:50:25'),(378,'02',4,'App\\Models\\Tenant\\Cash',370,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-19 21:00:48','2022-08-19 21:00:48'),(379,'02',4,'App\\Models\\Tenant\\Cash',371,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-20 16:37:16','2022-08-20 16:37:16'),(380,'02',4,'App\\Models\\Tenant\\Cash',372,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-20 17:27:09','2022-08-20 17:27:09'),(381,'02',5,'App\\Models\\Tenant\\Cash',373,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-20 19:51:05','2022-08-20 19:51:05'),(382,'02',4,'App\\Models\\Tenant\\Cash',374,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-21 14:04:18','2022-08-21 14:04:18'),(383,'02',5,'App\\Models\\Tenant\\Cash',375,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-21 14:36:07','2022-08-21 14:36:07'),(384,'02',4,'App\\Models\\Tenant\\Cash',376,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-22 20:15:59','2022-08-22 20:15:59'),(385,'02',5,'App\\Models\\Tenant\\Cash',377,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-22 20:18:27','2022-08-22 20:18:27'),(386,'02',5,'App\\Models\\Tenant\\Cash',378,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-25 22:17:44','2022-08-25 22:17:44'),(387,'02',4,'App\\Models\\Tenant\\Cash',379,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-25 22:18:49','2022-08-25 22:18:49'),(388,'02',4,'App\\Models\\Tenant\\Cash',380,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-26 18:00:51','2022-08-26 18:00:51'),(389,'02',5,'App\\Models\\Tenant\\Cash',381,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-26 18:35:31','2022-08-26 18:35:31'),(390,'02',4,'App\\Models\\Tenant\\Cash',382,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-26 20:41:46','2022-08-26 20:41:46'),(391,'02',4,'App\\Models\\Tenant\\Cash',383,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-27 10:23:54','2022-08-27 10:23:54'),(392,'02',4,'App\\Models\\Tenant\\Cash',384,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-27 21:30:06','2022-08-27 21:30:06'),(393,'02',5,'App\\Models\\Tenant\\Cash',385,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-27 21:30:59','2022-08-27 21:30:59'),(394,'02',5,'App\\Models\\Tenant\\Cash',386,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-28 12:06:24','2022-08-28 12:06:24'),(395,'02',4,'App\\Models\\Tenant\\Cash',387,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-28 12:09:02','2022-08-28 12:09:02'),(396,'02',4,'App\\Models\\Tenant\\Cash',388,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-29 16:58:58','2022-08-29 16:58:58'),(397,'02',5,'App\\Models\\Tenant\\Cash',389,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-29 20:57:07','2022-08-29 20:57:07'),(398,'02',5,'App\\Models\\Tenant\\Cash',390,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-30 12:39:08','2022-08-30 12:39:08'),(399,'02',4,'App\\Models\\Tenant\\Cash',391,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-31 18:48:37','2022-08-31 18:48:37'),(400,'02',5,'App\\Models\\Tenant\\Cash',392,'App\\Models\\Tenant\\DocumentPayment',3,'2022-08-31 19:14:03','2022-08-31 19:14:03'),(401,'02',4,'App\\Models\\Tenant\\Cash',393,'App\\Models\\Tenant\\DocumentPayment',2,'2022-08-31 20:12:13','2022-08-31 20:12:13'),(402,'02',4,'App\\Models\\Tenant\\Cash',394,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-01 19:34:25','2022-09-01 19:34:25'),(403,'02',5,'App\\Models\\Tenant\\Cash',395,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-01 20:21:53','2022-09-01 20:21:53'),(404,'02',5,'App\\Models\\Tenant\\Cash',396,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-02 19:50:38','2022-09-02 19:50:38'),(405,'02',5,'App\\Models\\Tenant\\Cash',397,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-03 13:17:25','2022-09-03 13:17:25'),(406,'02',4,'App\\Models\\Tenant\\Cash',398,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-03 16:32:15','2022-09-03 16:32:15'),(407,'02',5,'App\\Models\\Tenant\\Cash',399,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-03 19:00:06','2022-09-03 19:00:06'),(408,'02',5,'App\\Models\\Tenant\\Cash',400,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-04 12:25:01','2022-09-04 12:25:01'),(409,'02',4,'App\\Models\\Tenant\\Cash',401,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-05 21:06:27','2022-09-05 21:06:27'),(410,'02',5,'App\\Models\\Tenant\\Cash',402,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-06 21:35:55','2022-09-06 21:35:55'),(412,'02',5,'App\\Models\\Tenant\\Cash',404,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-07 20:22:58','2022-09-07 20:22:58'),(413,'02',5,'App\\Models\\Tenant\\Cash',405,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-08 20:01:53','2022-09-08 20:01:53'),(414,'02',4,'App\\Models\\Tenant\\Cash',406,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-08 20:40:20','2022-09-08 20:40:20'),(415,'02',5,'App\\Models\\Tenant\\Cash',407,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-09 11:18:20','2022-09-09 11:18:20'),(416,'02',4,'App\\Models\\Tenant\\Cash',408,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-09 18:33:56','2022-09-09 18:33:56'),(417,'02',5,'App\\Models\\Tenant\\Cash',409,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-09 19:50:52','2022-09-09 19:50:52'),(418,'02',4,'App\\Models\\Tenant\\Cash',410,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-10 17:54:55','2022-09-10 17:54:55'),(419,'02',5,'App\\Models\\Tenant\\Cash',411,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-10 19:29:30','2022-09-10 19:29:30'),(420,'02',5,'App\\Models\\Tenant\\Cash',412,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-11 12:29:25','2022-09-11 12:29:25'),(421,'02',4,'App\\Models\\Tenant\\Cash',413,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-12 19:33:37','2022-09-12 19:33:37'),(422,'02',5,'App\\Models\\Tenant\\Cash',414,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-12 21:54:28','2022-09-12 21:54:28'),(423,'02',5,'App\\Models\\Tenant\\Cash',415,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-13 20:43:44','2022-09-13 20:43:44'),(424,'02',4,'App\\Models\\Tenant\\Cash',416,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-13 21:01:19','2022-09-13 21:01:19'),(425,'02',5,'App\\Models\\Tenant\\Cash',417,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-14 19:52:13','2022-09-14 19:52:13'),(426,'02',4,'App\\Models\\Tenant\\Cash',418,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-14 21:19:38','2022-09-14 21:19:38'),(427,'02',4,'App\\Models\\Tenant\\Cash',419,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-15 19:30:20','2022-09-15 19:30:20'),(428,'02',5,'App\\Models\\Tenant\\Cash',420,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-15 20:22:48','2022-09-15 20:22:48'),(429,'02',5,'App\\Models\\Tenant\\Cash',421,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-16 19:20:09','2022-09-16 19:20:09'),(430,'02',5,'App\\Models\\Tenant\\Cash',422,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-17 20:14:39','2022-09-17 20:14:39'),(431,'02',4,'App\\Models\\Tenant\\Cash',423,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-17 20:20:13','2022-09-17 20:20:13'),(432,'02',4,'App\\Models\\Tenant\\Cash',424,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-17 21:07:07','2022-09-17 21:07:07'),(433,'02',5,'App\\Models\\Tenant\\Cash',425,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-18 14:49:08','2022-09-18 14:49:08'),(434,'02',5,'App\\Models\\Tenant\\Cash',426,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-19 10:53:06','2022-09-19 10:53:06'),(435,'02',5,'App\\Models\\Tenant\\Cash',427,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-19 10:53:30','2022-09-19 10:53:30'),(436,'02',4,'App\\Models\\Tenant\\Cash',428,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-19 11:38:16','2022-09-19 11:38:16'),(437,'02',4,'App\\Models\\Tenant\\Cash',429,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-19 21:10:42','2022-09-19 21:10:42'),(438,'02',4,'App\\Models\\Tenant\\Cash',430,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-19 21:22:13','2022-09-19 21:22:13'),(439,'02',4,'App\\Models\\Tenant\\Cash',431,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-19 21:35:52','2022-09-19 21:35:52'),(440,'02',4,'App\\Models\\Tenant\\Cash',432,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-20 10:40:43','2022-09-20 10:40:43'),(441,'02',4,'App\\Models\\Tenant\\Cash',433,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-20 18:26:22','2022-09-20 18:26:22'),(442,'02',5,'App\\Models\\Tenant\\Cash',434,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-21 16:03:37','2022-09-21 16:03:37'),(443,'02',4,'App\\Models\\Tenant\\Cash',435,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-21 17:11:02','2022-09-21 17:11:02'),(444,'02',4,'App\\Models\\Tenant\\Cash',436,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-21 17:19:15','2022-09-21 17:19:15'),(445,'02',4,'App\\Models\\Tenant\\Cash',437,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-21 17:22:10','2022-09-21 17:22:10'),(446,'02',5,'App\\Models\\Tenant\\Cash',438,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-21 19:29:35','2022-09-21 19:29:35'),(447,'02',4,'App\\Models\\Tenant\\Cash',439,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-22 21:15:06','2022-09-22 21:15:06'),(448,'02',5,'App\\Models\\Tenant\\Cash',440,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-22 21:46:30','2022-09-22 21:46:30'),(449,'02',5,'App\\Models\\Tenant\\Cash',441,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-23 11:03:00','2022-09-23 11:03:00'),(450,'02',5,'App\\Models\\Tenant\\Cash',442,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-23 20:18:34','2022-09-23 20:18:34'),(451,'02',4,'App\\Models\\Tenant\\Cash',443,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-24 15:52:30','2022-09-24 15:52:30'),(452,'02',4,'App\\Models\\Tenant\\Cash',444,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-24 18:40:07','2022-09-24 18:40:07'),(453,'02',5,'App\\Models\\Tenant\\Cash',445,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-24 19:23:04','2022-09-24 19:23:04'),(454,'02',5,'App\\Models\\Tenant\\Cash',446,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-24 19:39:16','2022-09-24 19:39:16'),(455,'02',4,'App\\Models\\Tenant\\Cash',447,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-25 13:27:55','2022-09-25 13:27:55'),(456,'02',5,'App\\Models\\Tenant\\Cash',448,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-25 14:53:14','2022-09-25 14:53:14'),(457,'02',5,'App\\Models\\Tenant\\Cash',449,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-26 15:15:11','2022-09-26 15:15:11'),(458,'02',5,'App\\Models\\Tenant\\Cash',450,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-26 16:08:58','2022-09-26 16:08:58'),(459,'02',4,'App\\Models\\Tenant\\Cash',451,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-28 20:53:01','2022-09-28 20:53:01'),(460,'02',5,'App\\Models\\Tenant\\Cash',452,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-29 20:08:55','2022-09-29 20:08:55'),(461,'02',4,'App\\Models\\Tenant\\Cash',453,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-29 20:09:44','2022-09-29 20:09:44'),(462,'02',4,'App\\Models\\Tenant\\Cash',454,'App\\Models\\Tenant\\DocumentPayment',2,'2022-09-30 18:50:25','2022-09-30 18:50:25'),(463,'02',5,'App\\Models\\Tenant\\Cash',455,'App\\Models\\Tenant\\DocumentPayment',3,'2022-09-30 19:45:28','2022-09-30 19:45:28'),(464,'02',5,'App\\Models\\Tenant\\Cash',456,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-01 19:41:00','2022-10-01 19:41:00'),(465,'02',4,'App\\Models\\Tenant\\Cash',457,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-01 21:08:16','2022-10-01 21:08:16'),(466,'02',4,'App\\Models\\Tenant\\Cash',458,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-02 10:48:53','2022-10-02 10:48:53'),(467,'02',4,'App\\Models\\Tenant\\Cash',459,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-03 17:47:19','2022-10-03 17:47:19'),(468,'02',5,'App\\Models\\Tenant\\Cash',460,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-03 20:11:06','2022-10-03 20:11:06'),(469,'02',5,'App\\Models\\Tenant\\Cash',461,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-04 18:18:21','2022-10-04 18:18:21'),(470,'02',5,'App\\Models\\Tenant\\Cash',462,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-05 14:47:55','2022-10-05 14:47:55'),(471,'02',5,'App\\Models\\Tenant\\Cash',463,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-05 19:32:50','2022-10-05 19:32:50'),(472,'02',5,'App\\Models\\Tenant\\Cash',464,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-06 18:33:49','2022-10-06 18:33:49'),(473,'02',5,'App\\Models\\Tenant\\Cash',465,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-06 19:04:54','2022-10-06 19:04:54'),(474,'02',5,'App\\Models\\Tenant\\Cash',466,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-07 10:02:51','2022-10-07 10:02:51'),(475,'02',5,'App\\Models\\Tenant\\Cash',467,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-07 14:29:47','2022-10-07 14:29:47'),(476,'02',4,'App\\Models\\Tenant\\Cash',468,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-07 16:03:09','2022-10-07 16:03:09'),(477,'02',4,'App\\Models\\Tenant\\Cash',469,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-07 16:07:08','2022-10-07 16:07:08'),(478,'02',4,'App\\Models\\Tenant\\Cash',470,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-08 19:19:33','2022-10-08 19:19:33'),(479,'02',4,'App\\Models\\Tenant\\Cash',471,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-08 19:20:27','2022-10-08 19:20:27'),(480,'02',5,'App\\Models\\Tenant\\Cash',472,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-08 21:22:02','2022-10-08 21:22:02'),(481,'02',5,'App\\Models\\Tenant\\Cash',473,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-11 19:52:58','2022-10-11 19:52:58'),(482,'02',4,'App\\Models\\Tenant\\Cash',474,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-11 19:54:42','2022-10-11 19:54:42'),(483,'02',4,'App\\Models\\Tenant\\Cash',475,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-12 20:17:30','2022-10-12 20:17:30'),(484,'02',5,'App\\Models\\Tenant\\Cash',476,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-12 20:20:52','2022-10-12 20:20:52'),(485,'02',5,'App\\Models\\Tenant\\Cash',477,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-12 21:28:43','2022-10-12 21:28:43'),(486,'02',4,'App\\Models\\Tenant\\Cash',478,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-13 13:18:21','2022-10-13 13:18:21'),(487,'02',5,'App\\Models\\Tenant\\Cash',479,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-13 19:47:52','2022-10-13 19:47:52'),(488,'02',5,'App\\Models\\Tenant\\Cash',480,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-14 19:29:45','2022-10-14 19:29:45'),(489,'02',4,'App\\Models\\Tenant\\Cash',481,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-14 21:03:33','2022-10-14 21:03:33'),(490,'02',5,'App\\Models\\Tenant\\Cash',482,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-15 11:30:35','2022-10-15 11:30:35'),(491,'02',5,'App\\Models\\Tenant\\Cash',483,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-15 12:31:20','2022-10-15 12:31:20'),(492,'02',5,'App\\Models\\Tenant\\Cash',484,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-15 20:39:12','2022-10-15 20:39:12'),(493,'02',5,'App\\Models\\Tenant\\Cash',485,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-16 10:19:20','2022-10-16 10:19:20'),(494,'02',5,'App\\Models\\Tenant\\Cash',486,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-16 12:18:48','2022-10-16 12:18:48'),(495,'02',5,'App\\Models\\Tenant\\Cash',487,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-16 12:45:31','2022-10-16 12:45:31'),(496,'02',5,'App\\Models\\Tenant\\Cash',488,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-17 08:44:15','2022-10-17 08:44:15'),(497,'02',5,'App\\Models\\Tenant\\Cash',489,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-17 16:03:08','2022-10-17 16:03:08'),(498,'02',5,'App\\Models\\Tenant\\Cash',490,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-19 19:39:41','2022-10-19 19:39:41'),(499,'02',5,'App\\Models\\Tenant\\Cash',491,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-20 20:41:17','2022-10-20 20:41:17'),(500,'02',5,'App\\Models\\Tenant\\Cash',492,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-21 19:42:47','2022-10-21 19:42:47'),(502,'02',4,'App\\Models\\Tenant\\Cash',494,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-22 17:39:15','2022-10-22 17:39:15'),(503,'02',5,'App\\Models\\Tenant\\Cash',495,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-22 19:27:10','2022-10-22 19:27:10'),(504,'02',4,'App\\Models\\Tenant\\Cash',3,'App\\Models\\Tenant\\SaleNotePayment',2,'2022-10-22 21:08:29','2022-10-22 21:08:29'),(505,'02',5,'App\\Models\\Tenant\\Cash',496,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-23 12:37:40','2022-10-23 12:37:40'),(506,'02',5,'App\\Models\\Tenant\\Cash',497,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-23 14:50:26','2022-10-23 14:50:26'),(507,'02',5,'App\\Models\\Tenant\\Cash',498,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-24 13:08:47','2022-10-24 13:08:47'),(508,'02',4,'App\\Models\\Tenant\\Cash',499,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-24 14:29:11','2022-10-24 14:29:11'),(509,'02',4,'App\\Models\\Tenant\\Cash',500,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-26 19:01:44','2022-10-26 19:01:44'),(510,'02',5,'App\\Models\\Tenant\\Cash',501,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-26 19:04:51','2022-10-26 19:04:51'),(511,'02',4,'App\\Models\\Tenant\\Cash',502,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-27 10:16:24','2022-10-27 10:16:24'),(512,'02',4,'App\\Models\\Tenant\\Cash',503,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-27 12:35:19','2022-10-27 12:35:19'),(513,'02',5,'App\\Models\\Tenant\\Cash',504,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-27 19:53:28','2022-10-27 19:53:28'),(514,'02',4,'App\\Models\\Tenant\\Cash',505,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-27 21:21:54','2022-10-27 21:21:54'),(515,'02',5,'App\\Models\\Tenant\\Cash',506,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-28 12:11:23','2022-10-28 12:11:23'),(516,'02',5,'App\\Models\\Tenant\\Cash',507,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-28 18:05:54','2022-10-28 18:05:54'),(517,'02',5,'App\\Models\\Tenant\\Cash',508,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-28 19:44:04','2022-10-28 19:44:04'),(518,'02',5,'App\\Models\\Tenant\\Cash',509,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-29 11:42:44','2022-10-29 11:42:44'),(519,'02',5,'App\\Models\\Tenant\\Cash',510,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-29 12:31:36','2022-10-29 12:31:36'),(520,'02',4,'App\\Models\\Tenant\\Cash',511,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-29 19:43:00','2022-10-29 19:43:00'),(521,'02',4,'App\\Models\\Tenant\\Cash',512,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-30 12:58:43','2022-10-30 12:58:43'),(522,'02',4,'App\\Models\\Tenant\\Cash',513,'App\\Models\\Tenant\\DocumentPayment',2,'2022-10-31 20:39:33','2022-10-31 20:39:33'),(523,'02',5,'App\\Models\\Tenant\\Cash',514,'App\\Models\\Tenant\\DocumentPayment',3,'2022-10-31 20:41:19','2022-10-31 20:41:19'),(524,'02',4,'App\\Models\\Tenant\\Cash',515,'App\\Models\\Tenant\\DocumentPayment',2,'2022-11-02 19:42:18','2022-11-02 19:42:18'),(525,'02',4,'App\\Models\\Tenant\\Cash',516,'App\\Models\\Tenant\\DocumentPayment',2,'2022-11-04 21:06:31','2022-11-04 21:06:31'),(526,'02',5,'App\\Models\\Tenant\\Cash',517,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-04 21:09:35','2022-11-04 21:09:35'),(527,'02',4,'App\\Models\\Tenant\\Cash',518,'App\\Models\\Tenant\\DocumentPayment',2,'2022-11-05 12:27:07','2022-11-05 12:27:07'),(528,'02',4,'App\\Models\\Tenant\\Cash',519,'App\\Models\\Tenant\\DocumentPayment',2,'2022-11-05 20:45:12','2022-11-05 20:45:12'),(529,'02',5,'App\\Models\\Tenant\\Cash',520,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-06 13:45:05','2022-11-06 13:45:05'),(530,'02',5,'App\\Models\\Tenant\\Cash',521,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-07 20:01:49','2022-11-07 20:01:49'),(531,'02',4,'App\\Models\\Tenant\\Cash',522,'App\\Models\\Tenant\\DocumentPayment',2,'2022-11-07 21:12:11','2022-11-07 21:12:11'),(532,'02',5,'App\\Models\\Tenant\\Cash',523,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-08 19:46:51','2022-11-08 19:46:51'),(539,'02',4,'App\\Models\\Tenant\\Cash',530,'App\\Models\\Tenant\\DocumentPayment',2,'2022-11-10 18:44:51','2022-11-10 18:44:51'),(540,'02',5,'App\\Models\\Tenant\\Cash',531,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-10 20:02:05','2022-11-10 20:02:05'),(541,'02',5,'App\\Models\\Tenant\\Cash',532,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-11 16:50:28','2022-11-11 16:50:28'),(542,'02',5,'App\\Models\\Tenant\\Cash',533,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-11 19:48:45','2022-11-11 19:48:45'),(543,'02',4,'App\\Models\\Tenant\\Cash',534,'App\\Models\\Tenant\\DocumentPayment',2,'2022-11-11 20:06:44','2022-11-11 20:06:44'),(544,'02',5,'App\\Models\\Tenant\\Cash',535,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-12 20:15:11','2022-11-12 20:15:11'),(545,'02',5,'App\\Models\\Tenant\\Cash',536,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-13 11:22:03','2022-11-13 11:22:03'),(546,'02',4,'App\\Models\\Tenant\\Cash',537,'App\\Models\\Tenant\\DocumentPayment',2,'2022-11-13 13:09:19','2022-11-13 13:09:19'),(547,'02',5,'App\\Models\\Tenant\\Cash',538,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-14 18:53:19','2022-11-14 18:53:19'),(548,'02',4,'App\\Models\\Tenant\\Cash',539,'App\\Models\\Tenant\\DocumentPayment',2,'2022-11-14 21:42:04','2022-11-14 21:42:04'),(549,'02',5,'App\\Models\\Tenant\\Cash',540,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-15 20:21:28','2022-11-15 20:21:28'),(550,'02',5,'App\\Models\\Tenant\\Cash',541,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-16 19:36:58','2022-11-16 19:36:58'),(551,'02',5,'App\\Models\\Tenant\\Cash',542,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-17 14:12:27','2022-11-17 14:12:27'),(552,'02',4,'App\\Models\\Tenant\\Cash',543,'App\\Models\\Tenant\\DocumentPayment',2,'2022-11-17 19:24:03','2022-11-17 19:24:03'),(553,'02',5,'App\\Models\\Tenant\\Cash',544,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-18 16:04:32','2022-11-18 16:04:32'),(554,'02',5,'App\\Models\\Tenant\\Cash',545,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-18 19:29:19','2022-11-18 19:29:19'),(555,'02',4,'App\\Models\\Tenant\\Cash',546,'App\\Models\\Tenant\\DocumentPayment',2,'2022-11-18 20:15:40','2022-11-18 20:15:40'),(556,'02',5,'App\\Models\\Tenant\\Cash',547,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-19 20:21:28','2022-11-19 20:21:28'),(557,'02',5,'App\\Models\\Tenant\\Cash',548,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-20 13:01:40','2022-11-20 13:01:40'),(558,'02',5,'App\\Models\\Tenant\\Cash',549,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-21 19:53:38','2022-11-21 19:53:38'),(559,'02',4,'App\\Models\\Tenant\\Cash',550,'App\\Models\\Tenant\\DocumentPayment',2,'2022-11-21 21:01:43','2022-11-21 21:01:43'),(560,'02',5,'App\\Models\\Tenant\\Cash',551,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-22 19:51:32','2022-11-22 19:51:32'),(561,'02',4,'App\\Models\\Tenant\\Cash',552,'App\\Models\\Tenant\\DocumentPayment',2,'2022-11-22 21:08:07','2022-11-22 21:08:07'),(562,'02',4,'App\\Models\\Tenant\\Cash',553,'App\\Models\\Tenant\\DocumentPayment',2,'2022-11-23 21:30:03','2022-11-23 21:30:03'),(563,'02',5,'App\\Models\\Tenant\\Cash',554,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-24 20:23:42','2022-11-24 20:23:42'),(564,'02',4,'App\\Models\\Tenant\\Cash',555,'App\\Models\\Tenant\\DocumentPayment',2,'2022-11-25 20:55:25','2022-11-25 20:55:25'),(565,'02',4,'App\\Models\\Tenant\\Cash',556,'App\\Models\\Tenant\\DocumentPayment',2,'2022-11-26 20:15:56','2022-11-26 20:15:56'),(566,'02',4,'App\\Models\\Tenant\\Cash',557,'App\\Models\\Tenant\\DocumentPayment',2,'2022-11-27 22:27:52','2022-11-27 22:27:52'),(567,'02',5,'App\\Models\\Tenant\\Cash',558,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-27 22:29:12','2022-11-27 22:29:12'),(568,'02',5,'App\\Models\\Tenant\\Cash',559,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-28 18:04:47','2022-11-28 18:04:47'),(569,'02',4,'App\\Models\\Tenant\\Cash',560,'App\\Models\\Tenant\\DocumentPayment',2,'2022-11-28 18:07:03','2022-11-28 18:07:03'),(570,'02',4,'App\\Models\\Tenant\\Cash',561,'App\\Models\\Tenant\\DocumentPayment',2,'2022-11-29 12:15:51','2022-11-29 12:15:51'),(571,'02',5,'App\\Models\\Tenant\\Cash',562,'App\\Models\\Tenant\\DocumentPayment',3,'2022-11-29 20:07:25','2022-11-29 20:07:25'),(572,'02',4,'App\\Models\\Tenant\\Cash',563,'App\\Models\\Tenant\\DocumentPayment',2,'2022-12-01 20:49:42','2022-12-01 20:49:42'),(573,'02',5,'App\\Models\\Tenant\\Cash',564,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-02 20:27:57','2022-12-02 20:27:57'),(574,'02',5,'App\\Models\\Tenant\\Cash',565,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-03 20:26:15','2022-12-03 20:26:15'),(575,'02',5,'App\\Models\\Tenant\\Cash',566,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-04 20:39:20','2022-12-04 20:39:20'),(576,'02',5,'App\\Models\\Tenant\\Cash',567,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-05 20:24:16','2022-12-05 20:24:16'),(577,'02',4,'App\\Models\\Tenant\\Cash',568,'App\\Models\\Tenant\\DocumentPayment',2,'2022-12-05 21:20:51','2022-12-05 21:20:51'),(578,'02',5,'App\\Models\\Tenant\\Cash',569,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-06 12:34:23','2022-12-06 12:34:23'),(579,'02',4,'App\\Models\\Tenant\\Cash',570,'App\\Models\\Tenant\\DocumentPayment',2,'2022-12-06 21:35:56','2022-12-06 21:35:56'),(580,'02',5,'App\\Models\\Tenant\\Cash',571,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-07 12:19:18','2022-12-07 12:19:18'),(581,'02',5,'App\\Models\\Tenant\\Cash',572,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-07 19:36:53','2022-12-07 19:36:53'),(582,'02',4,'App\\Models\\Tenant\\Cash',573,'App\\Models\\Tenant\\DocumentPayment',2,'2022-12-07 19:41:24','2022-12-07 19:41:24'),(583,'02',4,'App\\Models\\Tenant\\Cash',574,'App\\Models\\Tenant\\DocumentPayment',2,'2022-12-07 19:44:27','2022-12-07 19:44:27'),(584,'02',4,'App\\Models\\Tenant\\Cash',575,'App\\Models\\Tenant\\DocumentPayment',2,'2022-12-08 18:35:22','2022-12-08 18:35:22'),(585,'02',4,'App\\Models\\Tenant\\Cash',576,'App\\Models\\Tenant\\DocumentPayment',2,'2022-12-08 18:40:35','2022-12-08 18:40:35'),(586,'02',5,'App\\Models\\Tenant\\Cash',577,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-08 20:07:11','2022-12-08 20:07:11'),(587,'02',4,'App\\Models\\Tenant\\Cash',578,'App\\Models\\Tenant\\DocumentPayment',2,'2022-12-09 18:32:47','2022-12-09 18:32:47'),(588,'02',5,'App\\Models\\Tenant\\Cash',579,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-09 19:24:54','2022-12-09 19:24:54'),(589,'02',5,'App\\Models\\Tenant\\Cash',580,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-10 19:49:17','2022-12-10 19:49:17'),(590,'02',4,'App\\Models\\Tenant\\Cash',581,'App\\Models\\Tenant\\DocumentPayment',2,'2022-12-10 20:40:07','2022-12-10 20:40:07'),(591,'02',5,'App\\Models\\Tenant\\Cash',582,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-11 12:14:57','2022-12-11 12:14:57'),(592,'02',5,'App\\Models\\Tenant\\Cash',583,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-11 12:16:06','2022-12-11 12:16:06'),(593,'02',5,'App\\Models\\Tenant\\Cash',584,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-12 10:08:57','2022-12-12 10:08:57'),(594,'02',4,'App\\Models\\Tenant\\Cash',585,'App\\Models\\Tenant\\DocumentPayment',2,'2022-12-12 20:34:15','2022-12-12 20:34:15'),(595,'02',5,'App\\Models\\Tenant\\Cash',586,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-12 22:47:05','2022-12-12 22:47:05'),(596,'02',4,'App\\Models\\Tenant\\Cash',587,'App\\Models\\Tenant\\DocumentPayment',2,'2022-12-13 17:16:48','2022-12-13 17:16:48'),(597,'02',5,'App\\Models\\Tenant\\Cash',588,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-13 19:51:32','2022-12-13 19:51:32'),(598,'02',5,'App\\Models\\Tenant\\Cash',589,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-14 11:23:22','2022-12-14 11:23:22'),(599,'02',5,'App\\Models\\Tenant\\Cash',590,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-14 20:34:24','2022-12-14 20:34:24'),(600,'02',4,'App\\Models\\Tenant\\Cash',591,'App\\Models\\Tenant\\DocumentPayment',2,'2022-12-14 21:05:09','2022-12-14 21:05:09'),(601,'02',4,'App\\Models\\Tenant\\Cash',592,'App\\Models\\Tenant\\DocumentPayment',2,'2022-12-15 12:53:51','2022-12-15 12:53:51'),(602,'02',5,'App\\Models\\Tenant\\Cash',593,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-15 20:18:26','2022-12-15 20:18:26'),(603,'02',5,'App\\Models\\Tenant\\Cash',594,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-16 19:57:44','2022-12-16 19:57:44'),(604,'02',5,'App\\Models\\Tenant\\Cash',595,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-17 19:53:54','2022-12-17 19:53:54'),(605,'02',5,'App\\Models\\Tenant\\Cash',596,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-19 20:14:33','2022-12-19 20:14:33'),(606,'02',4,'App\\Models\\Tenant\\Cash',597,'App\\Models\\Tenant\\DocumentPayment',2,'2022-12-19 21:19:41','2022-12-19 21:19:41'),(607,'02',5,'App\\Models\\Tenant\\Cash',598,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-21 20:41:41','2022-12-21 20:41:41'),(608,'02',4,'App\\Models\\Tenant\\Cash',599,'App\\Models\\Tenant\\DocumentPayment',2,'2022-12-21 21:08:09','2022-12-21 21:08:09'),(609,'02',5,'App\\Models\\Tenant\\Cash',600,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-22 20:55:25','2022-12-22 20:55:25'),(610,'02',4,'App\\Models\\Tenant\\Cash',601,'App\\Models\\Tenant\\DocumentPayment',2,'2022-12-22 21:19:25','2022-12-22 21:19:25'),(611,'02',5,'App\\Models\\Tenant\\Cash',602,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-23 20:40:41','2022-12-23 20:40:41'),(612,'02',5,'App\\Models\\Tenant\\Cash',603,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-24 22:01:32','2022-12-24 22:01:32'),(613,'02',4,'App\\Models\\Tenant\\Cash',604,'App\\Models\\Tenant\\DocumentPayment',2,'2022-12-28 20:21:01','2022-12-28 20:21:01'),(614,'02',4,'App\\Models\\Tenant\\Cash',605,'App\\Models\\Tenant\\DocumentPayment',2,'2022-12-29 21:09:07','2022-12-29 21:09:07'),(615,'02',5,'App\\Models\\Tenant\\Cash',606,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-29 21:43:41','2022-12-29 21:43:41'),(616,'02',5,'App\\Models\\Tenant\\Cash',607,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-30 20:24:47','2022-12-30 20:24:47'),(621,'02',4,'App\\Models\\Tenant\\Cash',612,'App\\Models\\Tenant\\DocumentPayment',2,'2022-12-31 19:37:36','2022-12-31 19:37:36'),(622,'02',5,'App\\Models\\Tenant\\Cash',613,'App\\Models\\Tenant\\DocumentPayment',3,'2022-12-31 21:25:17','2022-12-31 21:25:17'),(623,'02',5,'App\\Models\\Tenant\\Cash',614,'App\\Models\\Tenant\\DocumentPayment',3,'2023-01-02 20:23:06','2023-01-02 20:23:06'),(624,'02',5,'App\\Models\\Tenant\\Cash',615,'App\\Models\\Tenant\\DocumentPayment',3,'2023-01-04 20:34:05','2023-01-04 20:34:05'),(625,'02',4,'App\\Models\\Tenant\\Cash',616,'App\\Models\\Tenant\\DocumentPayment',2,'2023-01-04 21:44:25','2023-01-04 21:44:25'),(626,'02',5,'App\\Models\\Tenant\\Cash',617,'App\\Models\\Tenant\\DocumentPayment',3,'2023-01-05 20:16:33','2023-01-05 20:16:33'),(627,'02',4,'App\\Models\\Tenant\\Cash',618,'App\\Models\\Tenant\\DocumentPayment',2,'2023-01-05 21:25:20','2023-01-05 21:25:20'),(628,'02',5,'App\\Models\\Tenant\\Cash',619,'App\\Models\\Tenant\\DocumentPayment',3,'2023-01-07 18:57:12','2023-01-07 18:57:12'),(629,'02',5,'App\\Models\\Tenant\\Cash',620,'App\\Models\\Tenant\\DocumentPayment',3,'2023-01-08 14:27:27','2023-01-08 14:27:27'),(630,'02',5,'App\\Models\\Tenant\\Cash',621,'App\\Models\\Tenant\\DocumentPayment',3,'2023-01-11 19:34:19','2023-01-11 19:34:19'),(631,'02',5,'App\\Models\\Tenant\\Cash',622,'App\\Models\\Tenant\\DocumentPayment',3,'2023-01-12 19:30:38','2023-01-12 19:30:38'),(632,'02',5,'App\\Models\\Tenant\\Cash',623,'App\\Models\\Tenant\\DocumentPayment',3,'2023-01-13 20:07:22','2023-01-13 20:07:22'),(633,'02',5,'App\\Models\\Tenant\\Cash',624,'App\\Models\\Tenant\\DocumentPayment',3,'2023-01-14 20:05:05','2023-01-14 20:05:05'),(634,'02',4,'App\\Models\\Tenant\\Cash',625,'App\\Models\\Tenant\\DocumentPayment',2,'2023-01-17 21:36:28','2023-01-17 21:36:28'),(635,'02',4,'App\\Models\\Tenant\\Cash',626,'App\\Models\\Tenant\\DocumentPayment',2,'2023-01-18 21:40:40','2023-01-18 21:40:40'),(636,'02',4,'App\\Models\\Tenant\\Cash',627,'App\\Models\\Tenant\\DocumentPayment',2,'2023-01-19 11:43:02','2023-01-19 11:43:02'),(637,'02',4,'App\\Models\\Tenant\\Cash',628,'App\\Models\\Tenant\\DocumentPayment',2,'2023-01-20 19:36:30','2023-01-20 19:36:30'),(638,'02',5,'App\\Models\\Tenant\\Cash',629,'App\\Models\\Tenant\\DocumentPayment',3,'2023-01-21 17:44:24','2023-01-21 17:44:24'),(639,'02',5,'App\\Models\\Tenant\\Cash',630,'App\\Models\\Tenant\\DocumentPayment',3,'2023-01-21 17:45:17','2023-01-21 17:45:17'),(640,'02',4,'App\\Models\\Tenant\\Cash',631,'App\\Models\\Tenant\\DocumentPayment',2,'2023-01-21 21:20:23','2023-01-21 21:20:23'),(641,'02',4,'App\\Models\\Tenant\\Cash',632,'App\\Models\\Tenant\\DocumentPayment',2,'2023-01-23 13:18:17','2023-01-23 13:18:17'),(642,'02',4,'App\\Models\\Tenant\\Cash',633,'App\\Models\\Tenant\\DocumentPayment',2,'2023-01-23 19:49:18','2023-01-23 19:49:18'),(643,'02',5,'App\\Models\\Tenant\\Cash',634,'App\\Models\\Tenant\\DocumentPayment',3,'2023-01-23 20:01:04','2023-01-23 20:01:04'),(644,'02',5,'App\\Models\\Tenant\\Cash',635,'App\\Models\\Tenant\\DocumentPayment',3,'2023-01-24 11:31:45','2023-01-24 11:31:45'),(645,'02',5,'App\\Models\\Tenant\\Cash',636,'App\\Models\\Tenant\\DocumentPayment',3,'2023-01-24 11:32:33','2023-01-24 11:32:33'),(646,'02',5,'App\\Models\\Tenant\\Cash',637,'App\\Models\\Tenant\\DocumentPayment',3,'2023-01-24 12:47:17','2023-01-24 12:47:17'),(647,'02',5,'App\\Models\\Tenant\\Cash',638,'App\\Models\\Tenant\\DocumentPayment',3,'2023-01-25 08:27:56','2023-01-25 08:27:56'),(648,'02',5,'App\\Models\\Tenant\\Cash',639,'App\\Models\\Tenant\\DocumentPayment',3,'2023-01-25 20:08:09','2023-01-25 20:08:09'),(649,'02',4,'App\\Models\\Tenant\\Cash',640,'App\\Models\\Tenant\\DocumentPayment',2,'2023-01-25 20:09:25','2023-01-25 20:09:25'),(650,'02',5,'App\\Models\\Tenant\\Cash',641,'App\\Models\\Tenant\\DocumentPayment',3,'2023-01-26 19:54:35','2023-01-26 19:54:35'),(651,'02',4,'App\\Models\\Tenant\\Cash',642,'App\\Models\\Tenant\\DocumentPayment',2,'2023-01-26 20:56:56','2023-01-26 20:56:56'),(652,'02',4,'App\\Models\\Tenant\\Cash',643,'App\\Models\\Tenant\\DocumentPayment',2,'2023-01-28 20:26:37','2023-01-28 20:26:37'),(653,'02',5,'App\\Models\\Tenant\\Cash',644,'App\\Models\\Tenant\\DocumentPayment',3,'2023-01-28 20:48:29','2023-01-28 20:48:29'),(654,'02',4,'App\\Models\\Tenant\\Cash',645,'App\\Models\\Tenant\\DocumentPayment',2,'2023-01-30 14:38:12','2023-01-30 14:38:12'),(655,'02',5,'App\\Models\\Tenant\\Cash',646,'App\\Models\\Tenant\\DocumentPayment',3,'2023-01-31 19:31:33','2023-01-31 19:31:33'),(656,'02',5,'App\\Models\\Tenant\\Cash',647,'App\\Models\\Tenant\\DocumentPayment',3,'2023-02-01 19:42:46','2023-02-01 19:42:46'),(657,'02',4,'App\\Models\\Tenant\\Cash',648,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-01 20:45:12','2023-02-01 20:45:12'),(658,'02',4,'App\\Models\\Tenant\\Cash',649,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-02 11:15:17','2023-02-02 11:15:17'),(659,'02',4,'App\\Models\\Tenant\\Cash',650,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-02 18:52:52','2023-02-02 18:52:52'),(660,'02',5,'App\\Models\\Tenant\\Cash',651,'App\\Models\\Tenant\\DocumentPayment',3,'2023-02-02 20:04:26','2023-02-02 20:04:26'),(661,'02',4,'App\\Models\\Tenant\\Cash',652,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-03 19:47:31','2023-02-03 19:47:31'),(662,'02',5,'App\\Models\\Tenant\\Cash',653,'App\\Models\\Tenant\\DocumentPayment',3,'2023-02-04 13:35:06','2023-02-04 13:35:06'),(663,'02',5,'App\\Models\\Tenant\\Cash',654,'App\\Models\\Tenant\\DocumentPayment',3,'2023-02-06 19:50:08','2023-02-06 19:50:08'),(664,'02',5,'App\\Models\\Tenant\\Cash',655,'App\\Models\\Tenant\\DocumentPayment',3,'2023-02-07 18:35:12','2023-02-07 18:35:12'),(665,'02',5,'App\\Models\\Tenant\\Cash',656,'App\\Models\\Tenant\\DocumentPayment',3,'2023-02-07 18:45:04','2023-02-07 18:45:04'),(666,'02',4,'App\\Models\\Tenant\\Cash',657,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-08 21:12:18','2023-02-08 21:12:18'),(667,'02',5,'App\\Models\\Tenant\\Cash',658,'App\\Models\\Tenant\\DocumentPayment',3,'2023-02-09 20:00:46','2023-02-09 20:00:46'),(668,'02',4,'App\\Models\\Tenant\\Cash',4,'App\\Models\\Tenant\\SaleNotePayment',2,'2023-02-10 12:03:38','2023-02-10 12:03:38'),(669,'02',4,'App\\Models\\Tenant\\Cash',659,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-10 19:23:45','2023-02-10 19:23:45'),(670,'02',5,'App\\Models\\Tenant\\Cash',660,'App\\Models\\Tenant\\DocumentPayment',3,'2023-02-10 20:09:03','2023-02-10 20:09:03'),(671,'02',4,'App\\Models\\Tenant\\Cash',661,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-11 20:32:36','2023-02-11 20:32:36'),(672,'02',4,'App\\Models\\Tenant\\Cash',662,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-12 13:10:52','2023-02-12 13:10:52'),(673,'02',4,'App\\Models\\Tenant\\Cash',663,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-13 10:12:55','2023-02-13 10:12:55'),(674,'02',5,'App\\Models\\Tenant\\Cash',664,'App\\Models\\Tenant\\DocumentPayment',3,'2023-02-13 19:52:03','2023-02-13 19:52:03'),(675,'02',5,'App\\Models\\Tenant\\Cash',665,'App\\Models\\Tenant\\DocumentPayment',3,'2023-02-14 20:24:36','2023-02-14 20:24:36'),(676,'02',4,'App\\Models\\Tenant\\Cash',666,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-14 21:09:17','2023-02-14 21:09:17'),(677,'02',4,'App\\Models\\Tenant\\Cash',667,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-15 10:23:34','2023-02-15 10:23:34'),(678,'02',4,'App\\Models\\Tenant\\Cash',668,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-15 10:24:42','2023-02-15 10:24:42'),(679,'02',4,'App\\Models\\Tenant\\Cash',669,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-15 10:26:08','2023-02-15 10:26:08'),(680,'02',4,'App\\Models\\Tenant\\Cash',670,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-15 17:41:35','2023-02-15 17:41:35'),(681,'02',5,'App\\Models\\Tenant\\Cash',671,'App\\Models\\Tenant\\DocumentPayment',3,'2023-02-15 19:22:44','2023-02-15 19:22:44'),(682,'02',5,'App\\Models\\Tenant\\Cash',672,'App\\Models\\Tenant\\DocumentPayment',3,'2023-02-16 19:59:48','2023-02-16 19:59:48'),(683,'02',5,'App\\Models\\Tenant\\Cash',673,'App\\Models\\Tenant\\DocumentPayment',3,'2023-02-17 14:23:33','2023-02-17 14:23:33'),(684,'02',4,'App\\Models\\Tenant\\Cash',674,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-17 20:47:33','2023-02-17 20:47:33'),(685,'02',5,'App\\Models\\Tenant\\Cash',675,'App\\Models\\Tenant\\DocumentPayment',3,'2023-02-18 11:06:44','2023-02-18 11:06:44'),(686,'02',5,'App\\Models\\Tenant\\Cash',676,'App\\Models\\Tenant\\DocumentPayment',3,'2023-02-18 12:56:32','2023-02-18 12:56:32'),(687,'02',4,'App\\Models\\Tenant\\Cash',677,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-18 21:00:10','2023-02-18 21:00:10'),(688,'02',4,'App\\Models\\Tenant\\Cash',678,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-20 21:06:00','2023-02-20 21:06:00'),(689,'02',4,'App\\Models\\Tenant\\Cash',679,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-21 11:23:56','2023-02-21 11:23:56'),(690,'02',4,'App\\Models\\Tenant\\Cash',680,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-22 19:20:37','2023-02-22 19:20:37'),(691,'02',5,'App\\Models\\Tenant\\Cash',681,'App\\Models\\Tenant\\DocumentPayment',3,'2023-02-22 20:04:41','2023-02-22 20:04:41'),(692,'02',5,'App\\Models\\Tenant\\Cash',682,'App\\Models\\Tenant\\DocumentPayment',3,'2023-02-23 19:32:11','2023-02-23 19:32:11'),(693,'02',4,'App\\Models\\Tenant\\Cash',683,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-23 19:47:02','2023-02-23 19:47:02'),(694,'02',5,'App\\Models\\Tenant\\Cash',684,'App\\Models\\Tenant\\DocumentPayment',3,'2023-02-24 19:30:34','2023-02-24 19:30:34'),(695,'02',5,'App\\Models\\Tenant\\Cash',685,'App\\Models\\Tenant\\DocumentPayment',3,'2023-02-25 16:12:56','2023-02-25 16:12:56'),(696,'02',4,'App\\Models\\Tenant\\Cash',686,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-25 21:06:42','2023-02-25 21:06:42'),(697,'02',4,'App\\Models\\Tenant\\Cash',687,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-27 20:29:05','2023-02-27 20:29:05'),(698,'02',4,'App\\Models\\Tenant\\Cash',688,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-28 14:48:50','2023-02-28 14:48:50'),(699,'02',4,'App\\Models\\Tenant\\Cash',689,'App\\Models\\Tenant\\DocumentPayment',2,'2023-02-28 20:34:08','2023-02-28 20:34:08'),(700,'02',5,'App\\Models\\Tenant\\Cash',690,'App\\Models\\Tenant\\DocumentPayment',3,'2023-03-01 19:57:37','2023-03-01 19:57:37'),(701,'02',4,'App\\Models\\Tenant\\Cash',691,'App\\Models\\Tenant\\DocumentPayment',2,'2023-03-01 20:56:44','2023-03-01 20:56:44');

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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

--
