
--
-- Table structure for table `qbdata_invoices`
--

CREATE TABLE `qbdata_invoices` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `sync_uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `business_entity_id` bigint(20) NOT NULL,
  `qb_invoice_id` bigint(20) NOT NULL,
  `qb_customer_id` bigint(20) NOT NULL,
  `invoice_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `invoice_date` date NOT NULL,
  `invoice_due_date` date DEFAULT NULL,
  `total_amount` decimal(19,4) NOT NULL,
  `outstanding_amount` decimal(19,4) NOT NULL,
  `currency` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `enc_data_obj` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0/1 - inactive/active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=202028 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='from qbdata sync';

--
-- Dumping data for table `qbdata_invoices`
--

INSERT INTO `qbdata_invoices` VALUES (167029,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,130,24,'1037','2022-08-20','2022-09-19',362.0700,362.0700,'USD','[encoded data, 10724 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167030,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,129,8,'1036','2022-08-20','2022-09-19',477.5000,477.5000,'USD','[encoded data, 12008 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167031,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,96,8,'1031','2022-06-05','2022-07-05',387.0000,0.0000,'USD','[encoded data, 9088 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167032,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,12,3,'1004','2022-08-08','2022-09-07',2369.5200,0.0000,'USD','[encoded data, 11468 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167033,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,119,17,'1035','2022-08-20','2022-09-19',314.2800,314.2800,'USD','[encoded data, 8976 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167034,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,63,25,'1017','2022-08-04','2022-09-03',80.0000,0.0000,'USD','[encoded data, 6604 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167035,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,106,21,'1034','2022-08-19','2022-09-18',78.6000,78.6000,'USD','[encoded data, 9312 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167036,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,103,10,'1033','2022-08-19','2022-09-18',629.1000,629.1000,'USD','[encoded data, 10628 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167037,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,67,1,'1021','2022-07-29','2022-08-28',459.0000,239.0000,'USD','[encoded data, 9052 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167038,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,99,26,'1032','2022-08-17','2022-09-16',414.7200,414.7200,'USD','[encoded data, 8980 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167039,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,42,26,'1013','2022-08-08','2022-09-07',81.0000,0.0000,'USD','[encoded data, 6392 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167040,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,95,8,'1030','2022-05-05','2022-06-04',226.7500,0.0000,'USD','[encoded data, 10452 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167041,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,93,5,'1029','2022-07-03','2022-08-02',460.4000,0.0000,'USD','[encoded data, 11564 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167042,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,68,12,'1022','2022-07-29','2022-08-28',81.0000,81.0000,'USD','[encoded data, 7648 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167043,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,9,1,'1001','2022-08-17','2022-09-16',108.0000,0.0000,'USD','[encoded data, 7724 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167044,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,13,9,'1005','2022-08-11','2022-09-10',54.0000,4.0000,'USD','[encoded data, 7708 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167045,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,14,9,'1006','2022-07-12','2022-08-11',86.4000,0.0000,'USD','[encoded data, 7704 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167046,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,92,9,'1028','2022-07-03','2022-08-02',81.0000,81.0000,'USD','[encoded data, 7648 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167047,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,10,2,'1002','2022-05-05','2022-06-04',175.0000,0.0000,'USD','[encoded data, 7588 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167048,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,75,2,'1027','2022-07-03','2022-08-02',85.0000,85.0000,'USD','[encoded data, 7532 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167049,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,71,1,'1025','2022-07-03','2022-08-02',205.0000,0.0000,'USD','[encoded data, 9408 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167050,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,70,20,'1024','2022-06-12','2022-07-12',156.0000,156.0000,'USD','[encoded data, 9356 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167051,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,69,20,'1023','2022-08-18','2022-09-17',70.0000,70.0000,'USD','[encoded data, 6672 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167052,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,65,25,'1019','2022-08-18','2022-09-17',80.0000,80.0000,'USD','[encoded data, 6548 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167053,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,64,25,'1018','2022-08-11','2022-09-10',80.0000,80.0000,'USD','[encoded data, 6548 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167054,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,60,16,'1016','2022-07-02','2022-08-01',75.0000,75.0000,'USD','[encoded data, 6264 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167055,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,49,18,'1015','2022-08-18','2022-09-17',954.7500,954.7500,'USD','[encoded data, 12100 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167056,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,27,26,'1009','2022-08-17','2022-09-16',103.5500,0.0000,'USD','[encoded data, 6796 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167057,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,39,23,'1012','2022-08-06','2022-09-05',274.5000,274.5000,'USD','[encoded data, 9096 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167058,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,34,29,'1010','2022-08-18','2022-09-17',375.0000,375.0000,'USD','[encoded data, 6620 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167059,'fb37706f-593b-4253-bb80-1cd93e36d9be',13,16,13,'1007','2022-07-26','2022-08-25',750.0000,450.0000,'USD','[encoded data, 6576 characters]',1,'2023-07-23 16:00:06','2023-07-23 16:00:06',NULL,NULL,NULL,NULL),(167060,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,130,24,'1037','2023-04-07','2023-05-07',362.0700,362.0700,'USD','[encoded data, 10660 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167061,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,129,8,'1036','2023-04-07','2023-05-07',477.5000,477.5000,'USD','[encoded data, 12008 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167062,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,96,8,'1031','2023-01-21','2023-02-20',387.0000,0.0000,'USD','[encoded data, 9088 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167063,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,12,3,'1004','2023-03-26','2023-04-25',2369.5200,0.0000,'USD','[encoded data, 11468 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167064,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,119,17,'1035','2023-04-07','2023-05-07',314.2800,314.2800,'USD','[encoded data, 8976 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167065,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,63,25,'1017','2023-03-22','2023-04-21',80.0000,0.0000,'USD','[encoded data, 6604 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167066,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,106,21,'1034','2023-04-06','2023-05-06',78.6000,78.6000,'USD','[encoded data, 9312 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167067,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,103,10,'1033','2023-04-06','2023-05-06',629.1000,629.1000,'USD','[encoded data, 10628 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167068,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,67,1,'1021','2023-03-16','2023-04-15',459.0000,239.0000,'USD','[encoded data, 9040 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167069,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,99,26,'1032','2023-04-04','2023-05-04',414.7200,414.7200,'USD','[encoded data, 8980 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167070,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,42,26,'1013','2023-03-26','2023-04-25',81.0000,0.0000,'USD','[encoded data, 6392 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167071,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,95,8,'1030','2022-12-21','2023-01-20',226.7500,0.0000,'USD','[encoded data, 10452 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167072,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,93,5,'1029','2023-02-18','2023-03-20',460.4000,0.0000,'USD','[encoded data, 11564 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167073,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,68,12,'1022','2023-03-16','2023-04-15',81.0000,81.0000,'USD','[encoded data, 7648 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167074,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,9,1,'1001','2023-04-04','2023-05-04',108.0000,0.0000,'USD','[encoded data, 7712 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167075,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,13,9,'1005','2023-03-29','2023-04-28',54.0000,4.0000,'USD','[encoded data, 7708 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167076,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,14,9,'1006','2023-02-27','2023-03-29',86.4000,0.0000,'USD','[encoded data, 7704 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167077,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,92,9,'1028','2023-02-18','2023-03-20',81.0000,81.0000,'USD','[encoded data, 7648 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167078,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,10,2,'1002','2022-12-21','2023-01-20',175.0000,0.0000,'USD','[encoded data, 7588 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167079,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,75,2,'1027','2023-02-18','2023-03-20',85.0000,85.0000,'USD','[encoded data, 7532 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167080,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,71,1,'1025','2023-02-18','2023-03-20',205.0000,0.0000,'USD','[encoded data, 9396 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167081,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,70,20,'1024','2023-01-28','2023-02-27',156.0000,156.0000,'USD','[encoded data, 9356 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167082,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,69,20,'1023','2023-04-05','2023-05-05',70.0000,70.0000,'USD','[encoded data, 6672 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167083,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,65,25,'1019','2023-04-05','2023-05-05',80.0000,80.0000,'USD','[encoded data, 6548 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167084,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,64,25,'1018','2023-03-29','2023-04-28',80.0000,80.0000,'USD','[encoded data, 6548 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167085,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,60,16,'1016','2023-02-17','2023-03-19',75.0000,75.0000,'USD','[encoded data, 6264 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167086,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,49,18,'1015','2023-04-05','2023-05-05',954.7500,954.7500,'USD','[encoded data, 12100 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),(167087,'fb37706f-593b-4253-bb80-1cd93e36d9be',7,27,26,'1009','2023-04-04','2023-05-04',103.5500,0.0000,'USD','[encoded data, 6796 characters]',1,'2023-07-23 16:00:09','2023-07-23 16:00:09',NULL,NULL,NULL,NULL),