CREATE TABLE `qb_transactions` (
	`uuid` INT NOT NULL,
	`item_type` INT NOT NULL,
	`item_date` INT NOT NULL,
	`item_ref_number` INT NOT NULL,
	`item_amount` INT NOT NULL,
	`item_currency` INT NOT NULL,
	`item_exchange_rate` INT NOT NULL,
	`item_home_amount` INT NOT NULL,
	`business_entity_id` INT NOT NULL,
	`qb_customer_id` INT NOT NULL
);

-- Dumping structure for table cpdb.qbdata_credit_notes
CREATE TABLE IF NOT EXISTS `qbdata_credit_notes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sync_uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `business_entity_id` int NOT NULL,
  `qb_credit_note_id` bigint NOT NULL,
  `qb_customer_id` bigint NOT NULL,
  `invoice_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `credit_note_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `credit_note_date` date NOT NULL,
  `total_amount` decimal(19,4) NOT NULL,
  `balance` decimal(19,4) DEFAULT '0.0000',
  `currency` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exchange_rate` decimal(19,4) DEFAULT NULL,
  `homecurr_total_amount` decimal(19,4) DEFAULT '0.0000',
  `homecurr_balance` decimal(19,4) DEFAULT '0.0000',
  `memo` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `enc_data_obj` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `download_folder` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `download_filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `downloaded_at` timestamp NULL DEFAULT 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `qbdata_credit_notes_business_entity_id_IDX` (`business_entity_id`) USING BTREE,
  KEY `qbdata_credit_notes_qb_credit_note_id_IDX` (`qb_credit_note_id`) USING BTREE,
  KEY `qbdata_credit_notes_status_IDX` (`status`) USING BTREE,
  CONSTRAINT `qbdata_credit_notes_company__business_entity_FK` FOREIGN KEY (`business_entity_id`) REFERENCES `spserp_dev`.`company__business_entity` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2056 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='from qbdata sync';

-- Dumping data for table cpdb.qbdata_credit_notes: ~923 rows (approximately)
INSERT INTO `qbdata_credit_notes` (`id`, `uuid`, `sync_uuid`, `business_entity_id`, `qb_credit_note_id`, `qb_customer_id`, `invoice_number`, `credit_note_number`, `credit_note_date`, `total_amount`, `balance`, `currency`, `exchange_rate`, `homecurr_total_amount`, `homecurr_balance`, `memo`, `enc_data_obj`, `download_folder`, `download_filename`, `downloaded_at`, `status`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`) VALUES
	(1, 'e2da91f2-0c8b-47fa-abb7-df7ec4a12f27', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 7545, 105, NULL, 'CN 2024/006', '2024-03-26', 729.6000, 0.0000, 'MYR', 1.0000, 729.6000, 0.0000, '3260', '[encoded data, 7388 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(2, 'aecd0086-0871-4505-b161-f229aa017e6a', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 7543, 105, NULL, 'CN 2024/005', '2024-03-26', 517.6000, 0.0000, 'MYR', 1.0000, 517.6000, 0.0000, '3030', '[encoded data, 7388 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(3, 'b27b0ce9-4772-4fd0-946f-ada57820a1af', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 7541, 105, NULL, 'CN 2024/004', '2024-03-26', 517.6000, 0.0000, 'MYR', 1.0000, 517.6000, 0.0000, '3029', '[encoded data, 7388 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(4, '0ee4dc1b-5833-4edf-a2ba-8352c23478e6', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 7539, 105, NULL, 'CN 2024/003', '2024-03-26', 496.4000, 0.0000, 'MYR', 1.0000, 496.4000, 0.0000, '3012', '[encoded data, 7380 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(5, '33f8036a-0820-407a-904a-27c024982820', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 7289, 224, NULL, 'CN 2024/002', '2024-01-29', 3180.0000, 0.0000, 'MYR', 1.0000, 3180.0000, 0.0000, NULL, '[encoded data, 7512 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(6, 'cb7ea883-7b80-45ba-872d-c70f37565bfe', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 7244, 395, NULL, 'CN 2024/001', '2024-01-11', 1500.0000, 0.0000, 'MYR', 1.0000, 1500.0000, 0.0000, '3087', '[encoded data, 7448 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(7, '26a40d16-2d61-48aa-b36a-645723c40a33', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 7202, 308, NULL, 'CN 2023/023', '2023-12-29', 365.7000, 0.0000, 'MYR', 1.0000, 365.7000, 0.0000, '3217', '[encoded data, 7616 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(8, 'c692d531-d305-4909-bf62-8e68abd4acca', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 7133, 406, NULL, 'CN 2023/022', '2023-12-18', 2120.0000, 0.0000, 'MYR', 1.0000, 2120.0000, 0.0000, '3169', '[encoded data, 7476 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(9, 'b185feb8-0f11-4f29-b60e-c23b5f026f9e', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 6981, 399, NULL, 'CN 2023/021', '2023-11-08', 90.1000, 0.0000, 'MYR', 1.0000, 90.1000, 0.0000, NULL, '[encoded data, 7488 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(10, '009469d2-0fbf-4352-bfd1-e70a6e5cd13b', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 6950, 374, NULL, 'CN 2023/015', '2023-10-31', 15900.0000, 0.0000, 'MYR', 1.0000, 15900.0000, 0.0000, NULL, '[encoded data, 7604 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(11, 'b2c7ee30-4608-45a2-830b-1f8e14dbf405', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 6921, 112, NULL, 'CN 2023/014', '2023-10-26', 1060.0000, 0.0000, 'MYR', 1.0000, 1060.0000, 0.0000, NULL, '[encoded data, 7404 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(12, '7d766480-72dd-40d0-b7ba-930f45293ab5', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 6912, 109, NULL, 'CN 2023/013', '2023-10-25', 318.0000, 0.0000, 'MYR', 1.0000, 318.0000, 0.0000, NULL, '[encoded data, 7388 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(13, 'dd145407-7d17-4c43-94c6-f041544921e9', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 6776, 425, NULL, 'CN 2023/012', '2023-09-21', 3879.6000, 0.0000, 'MYR', 1.0000, 3879.6000, 0.0000, NULL, '[encoded data, 7584 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(14, '038db134-e5c9-4d4f-a548-3ba441b78df2', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 6587, 92, NULL, 'CN 2023/011', '2023-08-01', 424.0000, 0.0000, 'MYR', 1.0000, 424.0000, 0.0000, NULL, '[encoded data, 7500 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(15, 'f1b9ae02-20e7-472d-84dc-f2467561b127', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 6583, 145, NULL, 'CN 2023/010', '2023-08-01', 1060.0000, 0.0000, 'MYR', 1.0000, 1060.0000, 0.0000, NULL, '[encoded data, 7624 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(16, 'a1e2b758-fdbb-44ca-8f28-d490547d163c', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 6555, 103, NULL, 'CN 2023/009', '2023-07-27', 173.0000, 0.0000, 'MYR', 1.0000, 173.0000, 0.0000, '3194', '[encoded data, 7304 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(17, 'f32a2f72-0ed5-4b63-a9c6-c3a43c4e45b6', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 6397, 279, NULL, 'CN 2023/008', '2023-06-13', 1272.0000, 0.0000, 'MYR', 1.0000, 1272.0000, 0.0000, NULL, '[encoded data, 7476 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(18, '8eace399-36ff-40d5-8c65-3a94dc1e96b4', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 6355, 145, NULL, 'CN 2023/007', '2023-06-01', 3180.0000, 0.0000, 'MYR', 1.0000, 3180.0000, 0.0000, '3140', '[encoded data, 7548 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(19, '2b9979bc-41a4-45c8-9a8c-2776b036a5e8', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 6352, 224, NULL, 'CN 2023/006', '2023-06-01', 848.0000, 0.0000, 'MYR', 1.0000, 848.0000, 0.0000, NULL, '[encoded data, 11792 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(20, '5ba460e7-9776-47b0-ac5a-64c4d4bbac18', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 6349, 46, NULL, 'CN 2023/005', '2023-06-01', 318.0000, 0.0000, 'MYR', 1.0000, 318.0000, 0.0000, '3157', '[encoded data, 7484 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(21, '8b8f455f-3b49-4041-b74b-85e92c33e079', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 6217, 150, NULL, 'CN 2023/004', '2023-05-02', 106.0000, 0.0000, 'MYR', 1.0000, 106.0000, 0.0000, '3133', '[encoded data, 7444 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(22, '0c81553f-5731-4e40-b7c7-6867546001d4', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 6181, 119, NULL, 'CN 2023/003', '2023-04-18', 361.0000, 0.0000, 'MYR', 1.0000, 361.0000, 0.0000, '3124', '[encoded data, 7440 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(23, '1b0b86ee-6589-43e3-8ff9-01c174062747', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 6108, 36, NULL, 'CN 2023/002', '2023-04-04', 200.0000, 0.0000, 'MYR', 1.0000, 200.0000, 0.0000, '3111', '[encoded data, 7404 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(24, '4f7139a4-6086-4ebe-b573-b275242507f1', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 5970, 141, NULL, 'CN 2023/001', '2023-03-13', 185.5000, 0.0000, 'MYR', 1.0000, 185.5000, 0.0000, '3101', '[encoded data, 7520 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(25, 'dedbc91f-3f35-45db-896f-bca064fc1cb1', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 5356, 164, NULL, 'CN 2022/018', '2022-09-22', 1409.0000, 0.0000, 'MYR', 1.0000, 1409.0000, 0.0000, '2951', '[encoded data, 7476 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(26, '39e70e27-549e-497e-b021-8840a396c031', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 5522, 291, NULL, 'CN 2022/020', '2022-11-02', 212.0000, 0.0000, 'MYR', 1.0000, 212.0000, 0.0000, '3031', '[encoded data, 7504 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(27, '38f05635-4b77-4767-8c48-643b3e1a98d2', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 5516, 49, NULL, 'CN 2022/019', '2022-11-02', 323.3000, 0.0000, 'MYR', 1.0000, 323.3000, 0.0000, NULL, '[encoded data, 7412 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(28, '89e7d38d-1a68-421f-afec-1453aedcf585', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 4051, 104, NULL, 'CN 2022/007', '2022-05-13', 0.0000, 0.0000, 'MYR', 1.0000, 0.0000, 0.0000, '2819', '[encoded data, 6424 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(29, 'f89d5956-f68d-4148-be37-3774759321f7', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 5225, 92, NULL, 'CN 2022/017', '2022-08-23', 318.0000, 0.0000, 'MYR', 1.0000, 318.0000, 0.0000, NULL, '[encoded data, 7448 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(30, '58e0c9dd-4689-4b36-9b78-2ec2e31c2de3', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 5219, 74, NULL, 'CN 2022/015', '2022-08-22', 100.0000, 0.0000, 'MYR', 1.0000, 100.0000, 0.0000, NULL, '[encoded data, 7472 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(31, 'b71c0940-e781-42fb-a06a-e0d0e800447b', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 5222, 73, NULL, 'CN 2022/016', '2022-08-22', 100.0000, 0.0000, 'MYR', 1.0000, 100.0000, 0.0000, NULL, '[encoded data, 7384 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(32, '04c76ebb-a236-46b9-9b08-8f17dfed2d69', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 4620, 182, NULL, 'CN 2022/014', '2022-08-11', 159.0000, 0.0000, 'MYR', 1.0000, 159.0000, 0.0000, NULL, '[encoded data, 7380 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(33, '320b78cb-cd1a-4b93-a03d-14ee0da55d1f', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 4608, 72, NULL, 'CN 2022/013', '2022-08-11', 81.0000, 0.0000, 'MYR', 1.0000, 81.0000, 0.0000, NULL, '[encoded data, 7444 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(34, 'c66d8172-3d8c-401f-b19f-64fb22cc6a16', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 4069, 155, NULL, 'CN 2022/009', '2022-05-19', 773.8000, 0.0000, 'MYR', 1.0000, 773.8000, 0.0000, 'INV2905', '[encoded data, 7436 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(35, 'cb94bc58-9ffa-4361-be27-c120985db7fd', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 4423, 240, NULL, 'CN 2022/012', '2022-06-29', 3384.0000, 0.0000, 'MYR', 1.0000, 3384.0000, 0.0000, NULL, '[encoded data, 7488 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(36, '3c9e4464-8938-4c28-9c7e-7e9013ba3b2d', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 4227, 119, NULL, 'CN 2022/011', '2022-06-21', 254.0000, 0.0000, 'MYR', 1.0000, 254.0000, 0.0000, NULL, '[encoded data, 7440 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(37, 'f97a2415-5b35-42ad-8068-707cbef0411d', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 4100, 57, NULL, 'CN 2022/010', '2022-05-25', 1908.0000, 0.0000, 'MYR', 1.0000, 1908.0000, 0.0000, '2555', '[encoded data, 7012 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(38, '82fa6724-3206-4046-9375-a31b71429dc7', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 4062, 316, NULL, 'CN 2022/008', '2022-05-18', 780.0000, 0.0000, 'MYR', 1.0000, 780.0000, 0.0000, 'INV2910', '[encoded data, 5656 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(39, '48b05f1b-5b74-4f10-b13d-ed03146b8358', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 3991, 288, NULL, 'CN 2022/006', '2022-04-26', 2597.0000, 0.0000, 'MYR', 1.0000, 2597.0000, 0.0000, 'INV2875', '[encoded data, 7580 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(40, 'f900fce2-b087-4c22-bb6c-f7de71df392c', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 3824, 117, NULL, 'CN 2022/005', '2022-03-25', 3180.0000, 0.0000, 'MYR', 1.0000, 3180.0000, 0.0000, 'INV2436', '[encoded data, 7492 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(41, '46e3ab5f-3cd6-4d8d-9780-a4ba723ffa73', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 3720, 297, NULL, 'CN 2022/004', '2022-03-07', 250.0000, 0.0000, 'MYR', 1.0000, 250.0000, 0.0000, 'INV 2860', '[encoded data, 7268 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(42, 'af65dc3e-a966-484b-b2fc-82df3b89fc18', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 3675, 224, NULL, 'CN 2022/003', '2022-02-24', 159.0000, 0.0000, 'MYR', 1.0000, 159.0000, 0.0000, 'INV 2804', '[encoded data, 7152 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(43, 'a644ac89-c5af-4408-b0de-ca62469210c2', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 3593, 113, NULL, 'BD00001', '2022-02-06', 4056.0000, 0.0000, 'MYR', 1.0000, 4056.0000, 0.0000, 'INV 2192, 2339 & 2044', '[encoded data, 10816 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(44, '280aa348-14fb-4ece-82d8-6b78efb37dce', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 3581, 103, NULL, 'CN 2022/002', '2022-02-03', 293.0000, 0.0000, 'MYR', 1.0000, 293.0000, 0.0000, 'INV2785', '[encoded data, 7452 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(45, '7672ee04-a97d-48f3-aad0-72dd54568dc3', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 3516, 184, NULL, 'CN 2022/001', '2022-01-19', 300.0000, 0.0000, 'MYR', 1.0000, 300.0000, 0.0000, 'INV 2769', '[encoded data, 6436 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(46, '155df7ff-8b1c-4c8c-b28b-e223364232da', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 3435, 291, NULL, 'CN 2021/022', '2021-12-28', 212.0000, 0.0000, 'MYR', 1.0000, 212.0000, 0.0000, 'INV 2809 -Discount on professional fee', '[encoded data, 7728 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(47, 'f7bf2b75-0ee0-4867-bf2c-b403df176b9f', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 3370, 195, NULL, 'CN 2021/021', '2021-12-06', 193.0000, 0.0000, 'MYR', 1.0000, 193.0000, 0.0000, 'INV 2793', '[encoded data, 7564 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(48, '7b21952f-affa-48f2-95d2-b91d602bcbe0', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 3331, 119, NULL, 'CN 2021/020', '2021-11-25', 307.0000, 0.0000, 'MYR', 1.0000, 307.0000, 0.0000, NULL, '[encoded data, 6428 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(49, '37882500-57b6-4cbd-a088-c56fc3bc7e08', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 3302, 224, NULL, 'CN 2021/019', '2021-11-19', 2120.0000, 0.0000, 'MYR', 1.0000, 2120.0000, 0.0000, 'INV 2788', '[encoded data, 7652 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(50, '8c115be0-a659-4f1f-844d-771082150dfd', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 3247, 112, NULL, 'CN 2021/018', '2021-11-03', 360.0000, 0.0000, 'MYR', 1.0000, 360.0000, 0.0000, NULL, '[encoded data, 6336 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(51, '602599ee-5f7f-46d1-a81a-1c35a8e60afd', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 3068, 46, NULL, 'CN 2021/017', '2021-09-14', 890.4000, 0.0000, 'MYR', 1.0000, 890.4000, 0.0000, '2700', '[encoded data, 7596 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(52, '75737cec-2422-448a-8766-109e64cc69a1', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 3047, 52, NULL, 'CN 2021/016', '2021-09-08', 503.5000, 0.0000, 'MYR', 1.0000, 503.5000, 0.0000, NULL, '[encoded data, 7568 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(53, '07778cc3-c3e1-45ee-9507-1656769dc68a', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 3011, 255, NULL, 'CN 2021/015', '2021-08-27', 318.0000, 0.0000, 'MYR', 1.0000, 318.0000, 0.0000, NULL, '[encoded data, 7260 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(54, 'abd1c59f-2725-46c6-b0ff-e581e7ceddae', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 3003, 252, NULL, 'CN 2021/014', '2021-08-26', 333.0000, 0.0000, 'MYR', 1.0000, 333.0000, 0.0000, NULL, '[encoded data, 7116 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(55, '48dfd34b-fe6c-4b5f-9cdd-80917996b21c', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 2980, 92, NULL, 'CN 2021/013', '2021-08-25', 223.0000, 0.0000, 'MYR', 1.0000, 223.0000, 0.0000, NULL, '[encoded data, 7084 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(56, '6c8493dd-94ca-4328-96cb-e601f8349e43', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 2958, 97, NULL, 'CN 2021/012', '2021-08-24', 1908.0000, 0.0000, 'MYR', 1.0000, 1908.0000, 0.0000, NULL, '[encoded data, 7112 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(57, '5fa744c4-f0d4-42e4-8ae8-b4958c2eafc0', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 2872, 66, NULL, 'CN 2021/011', '2021-07-30', 17.0000, 0.0000, 'MYR', 1.0000, 17.0000, 0.0000, 'CN as agreed between Kak Ann & Kak Ju on 30 july 2021', '[encoded data, 6112 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(58, '111104af-3167-4b7f-b3f0-6899a7b12190', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 2789, 198, NULL, 'CN 2021/009', '2021-06-30', 1908.0000, 0.0000, 'MYR', 1.0000, 1908.0000, 0.0000, 'INV 2596 -\nDECISION BY IDC COLLECTION MEETING ON 07.07.2021', '[encoded data, 7356 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
	(59, 'cfe4bbde-b7bb-4808-9709-39933f1291e4', 'ec07a63a-6710-4310-bc28-5ca09bbdeb22', 7, 2841, 54, NULL, 'CN 2021/010', '2021-07-23', 360.4000, 0.0000, 'MYR', 1.0000, 360.4000, 0.0000, '2598', '[encoded data, 7144 characters]', NULL, NULL, NULL, 1, '2024-04-01 04:05:24', '2024-04-01 04:05:24', NULL, NULL, NULL, NULL),
