(3142,'PTA','contactNumber','info','09297431784',1,'USR-00690','USR-00690',NULL,'2024-05-28 21:45:45','2024-05-28 21:48:26'),(3143,'PTA','email','info','maxiwealthpawnshop@gmail.com',1,'USR-00690','USR-00690',NULL,'2024-05-28 21:45:45','2024-05-28 21:48:26'),(3144,'PTA','includedOnSL','info','1',1,'USR-00690','USR-00690',NULL,'2024-05-28 21:45:45','2024-05-28 21:48:27'),(3145,'PTA','regionCode','address','13',1,'USR-00690','USR-00690',NULL,'2024-05-28 21:45:46','2024-05-28 21:48:28'),(3146,'PTA','provinceCode','address','1339',1,'USR-00690','USR-00690',NULL,'2024-05-28 21:45:46','2024-05-28 21:48:28'),(3147,'PTA','cityCode','address','133913',1,'USR-00690','USR-00690',NULL,'2024-05-28 21:45:46','2024-05-28 21:48:29'),(3148,'PTA','barangayCode','address','133913002',1,'USR-00690','USR-00690',NULL,'2024-05-28 21:45:46','2024-05-28 21:48:29'),(3149,'PTA','address','address','Unit B-103 G/F Velco Center R.S Oca & A.C Delgado St.,',1,'USR-00690','USR-00690',NULL,'2024-05-28 21:45:47','2024-05-28 21:48:30'),(3150,'PTA','zipCode','address','1018',1,'USR-00690','USR-00690',NULL,'2024-05-28 21:45:47','2024-05-28 21:48:31'),(3151,'TNY','personInCharge','info','ARLENE CABUG-OS',1,'USR-00690',NULL,NULL,'2024-05-28 21:48:03','2024-05-28 21:48:03'),(3152,'TNY','contactNumber','info','09297431784',1,'USR-00690',NULL,NULL,'2024-05-28 21:48:04','2024-05-28 21:48:04'),(3153,'TNY','email','info','maxiwealthpawnshop@gmail.com',1,'USR-00690',NULL,NULL,'2024-05-28 21:48:04','2024-05-28 21:48:04'),(3154,'TNY','includedOnSL','info','1',1,'USR-00690',NULL,NULL,'2024-05-28 21:48:04','2024-05-28 21:48:04'),(3155,'TNY','regionCode','address','04',1,'USR-00690',NULL,NULL,'2024-05-28 21:48:05','2024-05-28 21:48:05'),(3156,'TNY','provinceCode','address','0458',1,'USR-00690',NULL,NULL,'2024-05-28 21:48:05','2024-05-28 21:48:05'),(3157,'TNY','cityCode','address','045812',1,'USR-00690',NULL,NULL,'2024-05-28 21:48:05','2024-05-28 21:48:05'),(3158,'TNY','barangayCode','address','045812011',1,'USR-00690',NULL,NULL,'2024-05-28 21:48:06','2024-05-28 21:48:06'),(3159,'TNY','address','address','Comm\'l Stall 90-B New Tanay Public Market Cuyambay St.,',1,'USR-00690',NULL,NULL,'2024-05-28 21:48:06','2024-05-28 21:48:06'),(3160,'TNY','zipCode','address','1980',1,'USR-00690',NULL,NULL,'2024-05-28 21:48:06','2024-05-28 21:48:06'),(3161,'RTO','personInCharge','info','ARLENE CABUG-OS',1,'USR-00690',NULL,NULL,'2024-05-28 21:50:25','2024-05-28 21:50:25'),(3162,'RTO','contactNumber','info','09297431784',1,'USR-00690',NULL,NULL,'2024-05-28 21:50:25','2024-05-28 21:50:25'),(3163,'RTO','email','info','maxiwealthpawnshop@gmail.com',1,'USR-00690',NULL,NULL,'2024-05-28 21:50:25','2024-05-28 21:50:25'),(3164,'RTO','includedOnSL','info','1',1,'USR-00690',NULL,NULL,'2024-05-28 21:50:26','2024-05-28 21:50:26'),(3165,'RTO','regionCode','address','13',1,'USR-00690',NULL,NULL,'2024-05-28 21:50:26','2024-05-28 21:50:26'),(3166,'RTO','provinceCode','address','1374',1,'USR-00690',NULL,NULL,'2024-05-28 21:50:27','2024-05-28 21:50:27'),(3167,'RTO','cityCode','address','137404',1,'USR-00690',NULL,NULL,'2024-05-28 21:50:27','2024-05-28 21:50:27'),(3168,'RTO','barangayCode','address','137404056',1,'USR-00690',NULL,NULL,'2024-05-28 21:50:27','2024-05-28 21:50:27'),(3169,'RTO','address','address','Unit 449 #437 N.S Amoranto St.,',1,'USR-00690',NULL,NULL,'2024-05-28 21:50:28','2024-05-28 21:50:28'),(3170,'RTO','zipCode','address','1114',1,'USR-00690',NULL,NULL,'2024-05-28 21:50:28','2024-05-28 21:50:28'),(3171,'SDE','personInCharge','info','ARLENE CABUG-OS',1,'USR-00690',NULL,NULL,'2024-05-28 21:55:30','2024-05-28 21:55:30'),(3172,'SDE','contactNumber','info','09297431784',1,'USR-00690',NULL,NULL,'2024-05-28 21:55:30','2024-05-28 21:55:30'),(3173,'SDE','email','info','maxiwealthpawnshop@gmail.com',1,'USR-00690',NULL,NULL,'2024-05-28 21:55:30','2024-05-28 21:55:30'),(3174,'SDE','includedOnSL','info','1',1,'USR-00690',NULL,NULL,'2024-05-28 21:55:31','2024-05-28 21:55:31'),(3175,'SDE','regionCode','address','13',1,'USR-00690',NULL,NULL,'2024-05-28 21:55:31','2024-05-28 21:55:31'),(3176,'SDE','provinceCode','address','1376',1,'USR-00690',NULL,NULL,'2024-05-28 21:55:32','2024-05-28 21:55:32'),(3177,'SDE','cityCode','address','137604',1,'USR-00690',NULL,NULL,'2024-05-28 21:55:32','2024-05-28 21:55:32'),(3178,'SDE','barangayCode','address','137604006',1,'USR-00690',NULL,NULL,'2024-05-28 21:55:32','2024-05-28 21:55:32'),(3179,'SDE','address','address','Unit C G/F Airport Global Plaza',1,'USR-00690',NULL,NULL,'2024-05-28 21:55:32','2024-05-28 21:55:32'),(3180,'SDE','zipCode','address','1232',1,'USR-00690',NULL,NULL,'2024-05-28 21:55:33','2024-05-28 21:55:33'),(3181,'MSPI','personInCharge','info','ARLENE CABUG-OS',1,'USR-00690',NULL,NULL,'2024-05-28 21:57:16','2024-05-28 21:57:16'),(3182,'MSPI','contactNumber','info','09297431784',1,'USR-00690',NULL,NULL,'2024-05-28 21:57:16','2024-05-28 21:57:16'),(3183,'CYL','personInCharge','info','ARLENE CABUG-OS',1,'USR-00690',NULL,NULL,'2024-05-28 22:09:40','2024-05-28 22:09:40'),(3184,'CYL','contactNumber','info','09297431784',1,'USR-00690',NULL,NULL,'2024-05-28 22:09:41','2024-05-28 22:09:41'),(3185,'CYL','email','info','metrogoldstarpawnshop@gmail.com',1,'USR-00690',NULL,NULL,'2024-05-28 22:09:41','2024-05-28 22:09:41'),(3186,'CYL','includedOnSL','info','1',1,'USR-00690',NULL,NULL,'2024-05-28 22:09:42','2024-05-28 22:09:42'),(3187,'CYL','regionCode','address','13',1,'USR-00690',NULL,NULL,'2024-05-28 22:09:43','2024-05-28 22:09:43'),(3188,'CYL','provinceCode','address','1374',1,'USR-00690',NULL,NULL,'2024-05-28 22:09:43','2024-05-28 22:09:43'),(3189,'CYL','cityCode','address','137404',1,'USR-00690',NULL,NULL,'2024-05-28 22:09:43','2024-05-28 22:09:43'),(3190,'CYL','barangayCode','address','137404020',1,'USR-00690',NULL,NULL,'2024-05-28 22:09:44','2024-05-28 22:09:44'),(3191,'CYL','address','address','132 Kalayaan Ave',1,'USR-00690',NULL,NULL,'2024-05-28 22:09:44','2024-05-28 22:09:44'),(3192,'CYL','zipCode','address','1103',1,'USR-00690',NULL,NULL,'2024-05-28 22:09:44','2024-05-28 22:09:44'),(3193,'SRA','personInCharge','info','ARLENE CABUG-OS',1,'USR-00690',NULL,NULL,'2024-05-28 22:13:24','2024-05-28 22:13:24'),(3194,'SRA','contactNumber','info','09297431784',1,'USR-00690',NULL,NULL,'2024-05-28 22:13:25','2024-05-28 22:13:25'),(3195,'SRA','email','info','metrogoldstarpawnshop@gmail.com',1,'USR-00690',NULL,NULL,'2024-05-28 22:13:25','2024-05-28 22:13:25'),(3196,'SRA','includedOnSL','info','1',1,'USR-00690',NULL,NULL,'2024-05-28 22:13:25','2024-05-28 22:13:25'),(3197,'SRA','regionCode','address','03',1,'USR-00690',NULL,NULL,'2024-05-28 22:13:26','2024-05-28 22:13:26'),(3198,'SRA','provinceCode','address','0314',1,'USR-00690',NULL,NULL,'2024-05-28 22:13:26','2024-05-28 22:13:26'),(3199,'SRA','cityCode','address','031408',1,'USR-00690',NULL,NULL,'2024-05-28 22:13:26','2024-05-28 22:13:26'),(3200,'SRA','barangayCode','address','031408010',1,'USR-00690',NULL,NULL,'2024-05-28 22:13:26','2024-05-28 22:13:26'),(3201,'SRA','address','address','Stall B-2 AGL Mall',1,'USR-00690',NULL,NULL,'2024-05-28 22:13:27','2024-05-28 22:13:27'),(3202,'SRA','zipCode','address','3015',1,'USR-00690',NULL,NULL,'2024-05-28 22:13:27','2024-05-28 22:13:27'),(3203,'MNDN','personInCharge','info','JAMAICA PEJE',1,'USR-01007',NULL,NULL,'2024-05-28 22:17:59','2024-05-28 22:17:59'),(3204,'MNDN','contactNumber','info','09754475250',1,'USR-01007',NULL,NULL,'2024-05-28 22:17:59','2024-05-28 22:17:59'),(3205,'MNDN','email','info','allexitejewelrypawnshop@gmail.com',1,'USR-01007',NULL,NULL,'2024-05-28 22:18:00','2024-05-28 22:18:00'),(3206,'MNDN','includedOnSL','info','1',1,'USR-01007',NULL,NULL,'2024-05-28 22:18:00','2024-05-28 22:18:00'),(3207,'MNDN','regionCode','address','13',1,'USR-01007',NULL,NULL,'2024-05-28 22:18:00','2024-05-28 22:18:00'),(3208,'MNDN','provinceCode','address','1374',1,'USR-01007',NULL,NULL,'2024-05-28 22:18:00','2024-05-28 22:18:00'),(3209,'MNDN','cityCode','address','137402',1,'USR-01007',NULL,NULL,'2024-05-28 22:18:01','2024-05-28 22:18:01'),(3210,'MNDN','barangayCode','address','137402008',1,'USR-01007',NULL,NULL,'2024-05-28 22:18:01','2024-05-28 22:18:01'),(3211,'MNDN','address','address','115-A MUNDING AVE.',1,'USR-01007',NULL,NULL,'2024-05-28 22:18:01','2024-05-28 22:18:01'),(3212,'MNDN','zipCode','address','1801',1,'USR-01007',NULL,NULL,'2024-05-28 22:18:02','2024-05-28 22:18:02'),(3213,'DME','personInCharge','info','ARLENE CABUG-OS',1,'USR-00690','admin',NULL,'2024-05-28 22:31:40','2024-05-28 23:50:50'),(3214,'DME','contactNumber','info','09297431784',1,'USR-00690','admin',NULL,'2024-05-28 22:31:41','2024-05-28 23:50:51'),(3215,'DME','email','info','metrogoldstarpawnshop@gmail.com',1,'USR-00690','admin',NULL,'2024-05-28 22:31:41','2024-05-28 23:50:51'),(3216,'DME','includedOnSL','info','1',1,'USR-00690','admin',NULL,'2024-05-28 22:31:41','2024-05-28 23:50:52'),(3217,'DME','regionCode','address','03',1,'USR-00690','admin',NULL,'2024-05-28 22:31:42','2024-05-28 23:50:53'),(3218,'DME','provinceCode','address','0314',1,'USR-00690','admin',NULL,'2024-05-28 22:31:42','2024-05-28 23:50:54'),(3219,'DME','cityCode','address','031420',1,'USR-00690','admin',NULL,'2024-05-28 22:31:43','2024-05-28 23:50:55'),(3220,'DME','barangayCode','address','031420016',1,'USR-00690','admin',NULL,'2024-05-28 22:31:43','2024-05-28 23:50:55'),(3221,'DME','address','address','B1 L13 Area F Purok 7 Maharlika',1,'USR-00690','admin',NULL,'2024-05-28 22:31:43','2024-05-28 23:50:56'),(3222,'DME','zipCode','address','3023',1,'USR-00690','admin',NULL,'2024-05-28 22:31:44','2024-05-28 23:50:57'),(3223,'ICO','personInCharge','info','ARLENE CABUG-OS',1,'USR-00690',NULL,NULL,'2024-05-28 22:35:23','2024-05-28 22:35:23'),(3224,'ICO','contactNumber','info','09297431784',1,'USR-00690',NULL,NULL,'2024-05-28 22:35:23','2024-05-28 22:35:23'),(3225,'ICO','email','info','metrogoldstarpawnshop@gmail.com',1,'USR-00690',NULL,NULL,'2024-05-28 22:35:24','2024-05-28 22:35:24'),(3226,'ICO','includedOnSL','info','1',1,'USR-00690',NULL,NULL,'2024-05-28 22:35:25','2024-05-28 22:35:25'),(3227,'ICO','regionCode','address','02',1,'USR-00690',NULL,NULL,'2024-05-28 22:35:25','2024-05-28 22:35:25'),(3228,'ICO','provinceCode','address','0231',1,'USR-00690',NULL,NULL,'2024-05-28 22:35:25','2024-05-28 22:35:25'),(3229,'ICO','cityCode','address','023114',1,'USR-00690',NULL,NULL,'2024-05-28 22:35:25','2024-05-28 22:35:25'),(3230,'ICO','barangayCode','address','023114100',1,'USR-00690',NULL,NULL,'2024-05-28 22:35:26','2024-05-28 22:35:26'),(3231,'ICO','address','address','BB Talosig Bldg. Rizal St',1,'USR-00690',NULL,NULL,'2024-05-28 22:35:26','2024-05-28 22:35:26'),(3232,'ICO','zipCode','address','3300',1,'USR-00690',NULL,NULL,'2024-05-28 22:35:26','2024-05-28 22:35:26'),(3233,'SNJN','personInCharge','info','JAMAICA PEJE',1,'USR-01007','USR-01007',NULL,'2024-05-28 22:36:16','2024-05-28 22:38:19'),(3234,'SNJN','contactNumber','info','09754475250',1,'USR-01007','USR-01007',NULL,'2024-05-28 22:36:17','2024-05-28 22:38:19'),(3235,'SNJN','email','info','allexitejewelrypawnshop@gmail.com',1,'USR-01007','USR-01007',NULL,'2024-05-28 22:36:18','2024-05-28 22:38:19'),(3236,'SNJN','includedOnSL','info','1',1,'USR-01007','USR-01007',NULL,'2024-05-28 22:36:18','2024-05-28 22:38:20'),(3237,'SNJN','regionCode','address','01',1,'USR-01007','USR-01007',NULL,'2024-05-28 22:36:18','2024-05-28 22:38:20'),(3238,'SNJN','provinceCode','address','0129',1,'USR-01007','USR-01007',NULL,'2024-05-28 22:36:18','2024-05-28 22:38:21'),(3239,'SNJN','cityCode','address','012920',1,'USR-01007','USR-01007',NULL,'2024-05-28 22:36:19','2024-05-28 22:38:21'),(3240,'SNJN','barangayCode','address','012920003',1,'USR-01007','USR-01007',NULL,'2024-05-28 22:36:19','2024-05-28 22:38:21'),(3241,'SNJN','address','address','BANNUAR POB SAN JUAN LAPOG',1,'USR-01007','USR-01007',NULL,'2024-05-28 22:36:19','2024-05-28 22:38:22'),(3242,'SNJN','zipCode','address','2731',1,'USR-01007','USR-01007',NULL,'2024-05-28 22:36:20','2024-05-28 22:38:22'),(3243,'DHAN','personInCharge','info','ARLENE CABUG-OS',1,'USR-00690',NULL,NULL,'2024-05-28 22:47:11','2024-05-28 22:47:11'),(3244,'DHAN','contactNumber','info','09297431784',1,'USR-00690',NULL,NULL,'2024-05-28 22:47:12','2024-05-28 22:47:12'),(3245,'DHAN','email','info','metrogoldstarpawnshop@gmail.com',1,'USR-00690',NULL,NULL,'2024-05-28 22:47:12','2024-05-28 22:47:12'),(3246,'DHAN','includedOnSL','info','1',1,'USR-00690',NULL,NULL,'2024-05-28 22:47:13','2024-05-28 22:47:13'),(3247,'DHAN','regionCode','address','09',1,'USR-00690',NULL,NULL,'2024-05-28 22:47:13','2024-05-28 22:47:13'),(3248,'DHAN','provinceCode','address','0983',1,'USR-00690',NULL,NULL,'2024-05-28 22:47:14','2024-05-28 22:47:14'),(3249,'DHAN','cityCode','address','098303',1,'USR-00690',NULL,NULL,'2024-05-28 22:47:14','2024-05-28 22:47:14'),(3250,'DHAN','barangayCode','address','098303004',1,'USR-00690',NULL,NULL,'2024-05-28 22:47:14','2024-05-28 22:47:14'),(3251,'DHAN','address','address','Pob Diplahan',1,'USR-00690',NULL,NULL,'2024-05-28 22:47:15','2024-05-28 22:47:15'),(3252,'DHAN','zipCode','address','7039',1,'USR-00690',NULL,NULL,'2024-05-28 22:47:15','2024-05-28 22:47:15'),(3253,'CNYNY','personInCharge','info','ARLENE CABUG-OS',1,'USR-00690',NULL,NULL,'2024-05-28 22:50:21','2024-05-28 22:50:21'),(3254,'CNYNY','contactNumber','info','09297431784',1,'USR-00690',NULL,NULL,'2024-05-28 22:50:21','2024-05-28 22:50:21'),(3255,'CNYNY','email','info','metrogoldstarpawnshop@gmail.com',1,'USR-00690',NULL,NULL,'2024-05-28 22:50:22','2024-05-28 22:50:22'),(3256,'CNYNY','includedOnSL','info','1',1,'USR-00690',NULL,NULL,'2024-05-28 22:50:23','2024-05-28 22:50:23'),(3257,'CNYNY','regionCode','address','13',1,'USR-00690',NULL,NULL,'2024-05-28 22:50:23','2024-05-28 22:50:23'),(3258,'CNYNY','provinceCode','address','1376',1,'USR-00690',NULL,NULL,'2024-05-28 22:50:24','2024-05-28 22:50:24'),(3259,'CNYNY','cityCode','address','137604',1,'USR-00690',NULL,NULL,'2024-05-28 22:50:24','2024-05-28 22:50:24'),(3260,'CNYNY','barangayCode','address','137604004',1,'USR-00690',NULL,NULL,'2024-05-28 22:50:24','2024-05-28 22:50:24'),(3261,'CNYNY','address','address','Unit A 49 Canaynay Ave',1,'USR-00690',NULL,NULL,'2024-05-28 22:50:24','2024-05-28 22:50:24'),(3262,'CNYNY','zipCode','address','1700',1,'USR-00690',NULL,NULL,'2024-05-28 22:50:25','2024-05-28 22:50:25'),(3263,'DVSR','personInCharge','info','JAMAICA PEJE',1,'USR-01007',NULL,NULL,'2024-05-28 23:24:20','2024-05-28 23:24:20'),(3264,'DVSR','contactNumber','info','09754475250',1,'USR-01007',NULL,NULL,'2024-05-28 23:24:20','2024-05-28 23:24:20'),(3265,'DVSR','email','info','allexitejewelrypawnshop@gmail.com',1,'USR-01007',NULL,NULL,'2024-05-28 23:24:21','2024-05-28 23:24:21'),(3266,'DVSR','includedOnSL','info','1',1,'USR-01007',NULL,NULL,'2024-05-28 23:24:21','2024-05-28 23:24:21'),(3267,'DVSR','regionCode','address','13',1,'USR-01007',NULL,NULL,'2024-05-28 23:24:21','2024-05-28 23:24:21'),(3268,'DVSR','provinceCode','address','1339',1,'USR-01007',NULL,NULL,'2024-05-28 23:24:22','2024-05-28 23:24:22'),(3269,'DVSR','cityCode','address','133904',1,'USR-01007',NULL,NULL,'2024-05-28 23:24:22','2024-05-28 23:24:22'),(3270,'DVSR','barangayCode','address','133904001',1,'USR-01007',NULL,NULL,'2024-05-28 23:24:22','2024-05-28 23:24:22'),(3271,'DVSR','address','address','824 YLAYA ST. ZONE 25',1,'USR-01007',NULL,NULL,'2024-05-28 23:24:23','2024-05-28 23:24:23'),(3272,'DVSR','zipCode','address','1010',1,'USR-01007',NULL,NULL,'2024-05-28 23:24:23','2024-05-28 23:24:23'),(3273,'PGN','personInCharge','info','ARLENE CABUG-OS',1,'USR-00690',NULL,NULL,'2024-05-28 23:59:15','2024-05-28 23:59:15'),(3274,'PGN','contactNumber','info','09297431784',1,'USR-00690',NULL,NULL,'2024-05-28 23:59:16','2024-05-28 23:59:16'),(3275,'PGN','email','info','metrogoldstarpawnshop@gmail.com',1,'USR-00690',NULL,NULL,'2024-05-28 23:59:16','2024-05-28 23:59:16'),(3276,'PGN','includedOnSL','info','1',1,'USR-00690',NULL,NULL,'2024-05-28 23:59:16','2024-05-28 23:59:16'),(3277,'PGN','regionCode','address','09',1,'USR-00690',NULL,NULL,'2024-05-28 23:59:17','2024-05-28 23:59:17'),(3278,'PGN','provinceCode','address','0973',1,'USR-00690',NULL,NULL,'2024-05-28 23:59:18','2024-05-28 23:59:18'),(3279,'PGN','cityCode','address','097322',1,'USR-00690',NULL,NULL,'2024-05-28 23:59:18','2024-05-28 23:59:18'),(3280,'PGN','barangayCode','address','097322043',1,'USR-00690',NULL,NULL,'2024-05-28 23:59:18','2024-05-28 23:59:18'),(3281,'PGN','address','address','Warlito Pulmones St.,',1,'USR-00690',NULL,NULL,'2024-05-28 23:59:18','2024-05-28 23:59:18'),(3282,'PGN','zipCode','address','7016',1,'USR-00690',NULL,NULL,'2024-05-28 23:59:19','2024-05-28 23:59:19'),(3283,'DMO','personInCharge','info','ARLENE CABUG-OS',1,'USR-00690',NULL,NULL,'2024-05-29 00:03:46','2024-05-29 00:03:46'),(3284,'DMO','contactNumber','info','09297431784',1,'USR-00690',NULL,NULL,'2024-05-29 00:03:46','2024-05-29 00:03:46'),(3285,'DMO','email','info','metrogoldstarpawnshop@gmail.com',1,'USR-00690',NULL,NULL,'2024-05-29 00:03:46','2024-05-29 00:03:46'),(3286,'DMO','includedOnSL','info','1',1,'USR-00690',NULL,NULL,'2024-05-29 00:03:47','2024-05-29 00:03:47'),(3287,'DMO','regionCode','address','09',1,'USR-00690',NULL,NULL,'2024-05-29 00:03:47','2024-05-29 00:03:47'),(3288,'DMO','provinceCode','address','0973',1,'USR-00690',NULL,NULL,'2024-05-29 00:03:47','2024-05-29 00:03:47'),(3289,'DMO','cityCode','address','097307',1,'USR-00690',NULL,NULL,'2024-05-29 00:03:48','2024-05-29 00:03:48'),(3290,'DMO','barangayCode','address','097307041',1,'USR-00690',NULL,NULL,'2024-05-29 00:03:48','2024-05-29 00:03:48'),(3291,'DMO','address','address','Paglaum',1,'USR-00690',NULL,NULL,'2024-05-29 00:03:48','2024-05-29 00:03:48'),(3292,'DMO','zipCode','address','7015',1,'USR-00690',NULL,NULL,'2024-05-29 00:03:48','2024-05-29 00:03:48'),(3293,'BBG','personInCharge','info','ARLENE CABUG-OS',1,'USR-00690',NULL,NULL,'2024-05-29 00:06:43','2024-05-29 00:06:43'),(3294,'BBG','contactNumber','info','09297431784',1,'USR-00690',NULL,NULL,'2024-05-29 00:06:43','2024-05-29 00:06:43'),(3295,'BBG','email','info','metrogoldstarpawnshop@gmail.com',1,'USR-00690',NULL,NULL,'2024-05-29 00:06:44','2024-05-29 00:06:44'),(3296,'BBG','includedOnSL','info','1',1,'USR-00690',NULL,NULL,'2024-05-29 00:06:44','2024-05-29 00:06:44'),(3297,'BBG','regionCode','address','02',1,'USR-00690',NULL,NULL,'2024-05-29 00:06:45','2024-05-29 00:06:45'),(3298,'BBG','provinceCode','address','0250',1,'USR-00690',NULL,NULL,'2024-05-29 00:06:45','2024-05-29 00:06:45'),(3299,'BBG','cityCode','address','025004',1,'USR-00690',NULL,NULL,'2024-05-29 00:06:45','2024-05-29 00:06:45'),(3300,'BBG','barangayCode','address','025004010',1,'USR-00690',NULL,NULL,'2024-05-29 00:06:46','2024-05-29 00:06:46'),(3301,'BBG','address','address','Allas Bldg',1,'USR-00690',NULL,NULL,'2024-05-29 00:06:46','2024-05-29 00:06:46'),(3302,'BBG','zipCode','address','3702',1,'USR-00690',NULL,NULL,'2024-05-29 00:06:46','2024-05-29 00:06:46'),(3303,'HBA','personInCharge','info','ARLENE CABUG-OS',1,'USR-00690',NULL,NULL,'2024-05-29 00:09:59','2024-05-29 00:09:59'),(3304,'HBA','contactNumber','info','09297431784',1,'USR-00690',NULL,NULL,'2024-05-29 00:09:59','2024-05-29 00:09:59'),(3305,'HBA','email','info','metrostarpawnshop@gmail.com',1,'USR-00690',NULL,NULL,'2024-05-29 00:10:00','2024-05-29 00:10:00'),(3306,'HBA','includedOnSL','info','1',1,'USR-00690',NULL,NULL,'2024-05-29 00:10:00','2024-05-29 00:10:00'),(3307,'HBA','regionCode','address','13',1,'USR-00690',NULL,NULL,'2024-05-29 00:10:00','2024-05-29 00:10:00'),(3308,'HBA','provinceCode','address','1339',1,'USR-00690',NULL,NULL,'2024-05-29 00:10:01','2024-05-29 00:10:01'),(3309,'HBA','cityCode','address','133901',1,'USR-00690',NULL,NULL,'2024-05-29 00:10:01','2024-05-29 00:10:01'),(3310,'HBA','barangayCode','address','133901112',1,'USR-00690',NULL,NULL,'2024-05-29 00:10:01','2024-05-29 00:10:01'),(3311,'HBA','address','address','14-D-1 Lot 1-E Herbosa Ext',1,'USR-00690',NULL,NULL,'2024-05-29 00:10:02','2024-05-29 00:10:02'),(3312,'HBA','zipCode','address','1012',1,'USR-00690',NULL,NULL,'2024-05-29 00:10:02','2024-05-29 00:10:02'),(3313,'PHLO','personInCharge','info','ARLENE CABUG-OS',1,'USR-00690',NULL,NULL,'2024-05-29 00:13:58','2024-05-29 00:13:58'),(3314,'PHLO','contactNumber','info','09297431784',1,'USR-00690',NULL,NULL,'2024-05-29 00:13:58','2024-05-29 00:13:58'),(3315,'PHLO','email','info','metrogoldstarpawnshop@gmail.com',1,'USR-00690',NULL,NULL,'2024-05-29 00:13:59','2024-05-29 00:13:59'),(3316,'PHLO','includedOnSL','info','1',1,'USR-00690',NULL,NULL,'2024-05-29 00:14:00','2024-05-29 00:14:00'),(3317,'PHLO','regionCode','address','13',1,'USR-00690',NULL,NULL,'2024-05-29 00:14:00','2024-05-29 00:14:00'),(3318,'PHLO','provinceCode','address','1375',1,'USR-00690',NULL,NULL,'2024-05-29 00:14:01','2024-05-29 00:14:01'),(3319,'PHLO','cityCode','address','137502',1,'USR-00690',NULL,NULL,'2024-05-29 00:14:01','2024-05-29 00:14:01'),(3320,'PHLO','barangayCode','address','137502017',1,'USR-00690',NULL,NULL,'2024-05-29 00:14:01','2024-05-29 00:14:01'),(3321,'PHLO','address','address','210 MH. Del Pilar Cor., Rodriguez',1,'USR-00690',NULL,NULL,'2024-05-29 00:14:01','2024-05-29 00:14:01'),(3322,'PHLO','zipCode','address','1478',1,'USR-00690',NULL,NULL,'2024-05-29 00:14:02','2024-05-29 00:14:02'),(3323,'CLUI','personInCharge','info','ARLENE CABUG-OS',1,'USR-00690',NULL,NULL,'2024-05-29 00:17:34','2024-05-29 00:17:34'),(3324,'CLUI','contactNumber','info','09297431784',1,'USR-00690',NULL,NULL,'2024-05-29 00:17:34','2024-05-29 00:17:34'),(3325,'CLUI','email','info','metrogoldstarpawnshop@gmail.com',1,'USR-00690',NULL,NULL,'2024-05-29 00:17:34','2024-05-29 00:17:34'),(3326,'CLUI','includedOnSL','info','1',1,'USR-00690',NULL,NULL,'2024-05-29 00:17:35','2024-05-29 00:17:35'),(3327,'CLUI','regionCode','address','02',1,'USR-00690',NULL,NULL,'2024-05-29 00:17:35','2024-05-29 00:17:35'),(3328,'CLUI','provinceCode','address','0231',1,'USR-00690',NULL,NULL,'2024-05-29 00:17:36','2024-05-29 00:17:36'),(3329,'CLUI','cityCode','address','023114',1,'USR-00690',NULL,NULL,'2024-05-29 00:17:36','2024-05-29 00:17:36'),(3330,'CLUI','barangayCode','address','023114034',1,'USR-00690',NULL,NULL,'2024-05-29 00:17:37','2024-05-29 00:17:37'),(3331,'CLUI','address','address','Calamagui',1,'USR-00690',NULL,NULL,'2024-05-29 00:17:37','2024-05-29 00:17:37'),(3332,'CLUI','zipCode','address','3300',1,'USR-00690',NULL,NULL,'2024-05-29 00:17:37','2024-05-29 00:17:37'),(3333,'SRE','personInCharge','info','ARLENE CABUG-OS',1,'USR-00690',NULL,NULL,'2024-05-29 16:27:47','2024-05-29 16:27:47'),(3334,'SRE','contactNumber','info','09297431784',1,'USR-00690',NULL,NULL,'2024-05-29 16:27:48','2024-05-29 16:27:48'),(3335,'SRE','email','info','metrogoldstarpawnshop@gmail.com',1,'USR-00690',NULL,NULL,'2024-05-29 16:27:49','2024-05-29 16:27:49'),(3336,'SRE','includedOnSL','info','1',1,'USR-00690',NULL,NULL,'2024-05-29 16:27:49','2024-05-29 16:27:49'),(3337,'SRE','regionCode','address','03',1,'USR-00690',NULL,NULL,'2024-05-29 16:27:49','2024-05-29 16:27:49'),(3338,'SRE','provinceCode','address','0349',1,'USR-00690',NULL,NULL,'2024-05-29 16:27:49','2024-05-29 16:27:49'),(3339,'SRE','cityCode','address','034926',1,'USR-00690',NULL,NULL,'2024-05-29 16:27:50','2024-05-29 16:27:50'),(3340,'SRE','barangayCode','address','034926019',1,'USR-00690',NULL,NULL,'2024-05-29 16:27:50','2024-05-29 16:27:50'),(3341,'SRE','address','address','G. Francisco Bldg. San Roque',1,'USR-00690',NULL,NULL,'2024-05-29 16:27:50','2024-05-29 16:27:50'),(3342,'SRE','zipCode','address','3121',1,'USR-00690',NULL,NULL,'2024-05-29 16:27:51','2024-05-29 16:27:51'),(3343,'CGO','personInCharge','info','ARLENE CABUG-OS',1,'USR-00690',NULL,NULL,'2024-05-29 16:29:42','2024-05-29 16:29:42'),(3344,'CGO','contactNumber','info','09297431784',1,'USR-00690',NULL,NULL,'2024-05-29 16:29:43','2024-05-29 16:29:43'),(3345,'CGO','email','info','metrogoldstarpawnshop@gmail.com',1,'USR-00690',NULL,NULL,'2024-05-29 16:29:43','2024-05-29 16:29:43'),(3346,'CGO','includedOnSL','info','1',1,'USR-00690',NULL,NULL,'2024-05-29 16:29:44','2024-05-29 16:29:44'),(3347,'CGO','regionCode','address','04',1,'USR-00690',NULL,NULL,'2024-05-29 16:29:44','2024-05-29 16:29:44'),(3348,'CGO','provinceCode','address','0458',1,'USR-00690',NULL,NULL,'2024-05-29 16:29:44','2024-05-29 16:29:44'),(3349,'CGO','cityCode','address','045802',1,'USR-00690',NULL,NULL,'2024-05-29 16:29:44','2024-05-29 16:29:44'),(3350,'CGO','barangayCode','address','045802011',1,'USR-00690',NULL,NULL,'2024-05-29 16:29:45','2024-05-29 16:29:45'),(3351,'CGO','address','address','1-A Blk 1 Lot 12 Phase V Manalite',1,'USR-00690',NULL,NULL,'2024-05-29 16:29:45','2024-05-29 16:29:45'),(3352,'CGO','zipCode','address','1870',1,'USR-00690',NULL,NULL,'2024-05-29 16:29:45','2024-05-29 16:29:45'),(3353,'TGM','personInCharge','info','ARLENE CABUG-OS',1,'USR-00690',NULL,NULL,'2024-05-29 16:32:13','2024-05-29 16:32:13'),(3354,'TGM','contactNumber','info','09297431784',1,'USR-00690',NULL,NULL,'2024-05-29 16:32:14','2024-05-29 16:32:14'),(3355,'TGM','email','info','metrogoldstarpawnshop@gmail.com',1,'USR-00690',NULL,NULL,'2024-05-29 16:32:14','2024-05-29 16:32:14'),(3356,'TGM','includedOnSL','info','1',1,'USR-00690',NULL,NULL,'2024-05-29 16:32:14','2024-05-29 16:32:14'),(3357,'TGM','regionCode','address','11',1,'USR-00690',NULL,NULL,'2024-05-29 16:32:15','2024-05-29 16:32:15'),(3358,'TGM','provinceCode','address','1123',1,'USR-00690',NULL,NULL,'2024-05-29 16:32:15','2024-05-29 16:32:15'),(3359,'TGM','cityCode','address','112319',1,'USR-00690',NULL,NULL,'2024-05-29 16:32:15','2024-05-29 16:32:15'),(3360,'TGM','barangayCode','address','112319016',1,'USR-00690',NULL,NULL,'2024-05-29 16:32:16','2024-05-29 16:32:16'),(3361,'TGM','address','address','Lapu-lapu Cor Sobrecarey',1,'USR-00690',NULL,NULL,'2024-05-29 16:32:16','2024-05-29 16:32:16'),(3362,'TGM','zipCode','address','8100',1,'USR-00690',NULL,NULL,'2024-05-29 16:32:16','2024-05-29 16:32:16'),(3363,'PLCB','personInCharge','info','JAMAICA PEJE',1,'USR-01007',NULL,NULL,'2024-05-29 16:54:04','2024-05-29 16:54:04'),(3364,'PLCB','contactNumber','info','09754475250',1,'USR-01007',NULL,NULL,'2024-05-29 16:54:05','2024-05-29 16:54:05'),(3365,'PLCB','email','info','allexitejewelrypawnshop@gmail.com',1,'USR-01007',NULL,NULL,'2024-05-29 16:54:05','2024-05-29 16:54:05'),(3366,'PLCB','includedOnSL','info','1',1,'USR-01007',NULL,NULL,'2024-05-29 16:54:05','2024-05-29 16:54:05'),(3367,'PLCB','regionCode','address','04',1,'USR-01007',NULL,NULL,'2024-05-29 16:54:06','2024-05-29 16:54:06'),(3368,'PLCB','provinceCode','address','0410',1,'USR-01007',NULL,NULL,'2024-05-29 16:54:06','2024-05-29 16:54:06'),(3369,'PLCB','cityCode','address','041034',1,'USR-01007',NULL,NULL,'2024-05-29 16:54:06','2024-05-29 16:54:06'),(3370,'PLCB','barangayCode','address','041034007',1,'USR-01007',NULL,NULL,'2024-05-29 16:54:07','2024-05-29 16:54:07'),(3371,'PLCB','address','address','SITIO PALICO',1,'USR-01007',NULL,NULL,'2024-05-29 16:54:07','2024-05-29 16:54:07'),(3372,'PLCB','zipCode','address','4214',1,'USR-01007',NULL,NULL,'2024-05-29 16:54:07','2024-05-29 16:54:07'),(3373,'DSG','personInCharge','info','LEO ALASKA',1,'USR-00762',NULL,NULL,'2024-05-30 21:46:26','2024-05-30 21:46:26'),(3374,'DSG','contactNumber','info','09777891310',1,'USR-00762',NULL,NULL,'2024-05-30 21:46:26','2024-05-30 21:46:26'),(3375,'DSG','email','info','kryptonknightpawn@gmail.com',1,'USR-00762',NULL,NULL,'2024-05-30 21:46:26','2024-05-30 21:46:26'),(3376,'DSG','includedOnSL','info','1',1,'USR-00762',NULL,NULL,'2024-05-30 21:46:27','2024-05-30 21:46:27'),(3377,'DSG','regionCode','address','13',1,'USR-00762',NULL,NULL,'2024-05-30 21:46:28','2024-05-30 21:46:28'),(3378,'DSG','provinceCode','address','1339',1,'USR-00762',NULL,NULL,'2024-05-30 21:46:28','2024-05-30 21:46:28'),(3379,'DSG','cityCode','address','133905',1,'USR-00762',NULL,NULL,'2024-05-30 21:46:28','2024-05-30 21:46:28'),(3380,'DSG','barangayCode','address','133905074',1,'USR-00762',NULL,NULL,'2024-05-30 21:46:28','2024-05-30 21:46:28'),(3381,'DSG','address','address','unit 105 casa aurora Bldg. Dimasalang St.',1,'USR-00762',NULL,NULL,'2024-05-30 21:46:29','2024-05-30 21:46:29'),(3382,'DSG','zipCode','address','1014',1,'USR-00762',NULL,NULL,'2024-05-30 21:46:29','2024-05-30 21:46:29'),(3383,'ABO','personInCharge','info','SHEENA DELOVINO',1,'admin','admin',NULL,'2024-05-30 21:49:17','2024-05-30 23:23:20'),(3384,'ABO','contactNumber','info','09091233314',1,'admin','admin',NULL,'2024-05-30 21:49:18','2024-05-30 23:23:21'),(3385,'ABO','email','info','pcortez_tambunting@yahoo.com',1,'admin','admin',NULL,'2024-05-30 21:49:18','2024-05-30 23:23:21'),(3386,'ABO','includedOnSL','info','1',1,'admin','admin',NULL,'2024-05-30 21:49:19','2024-05-30 23:23:22'),(3387,'ABO','regionCode','address','13',1,'admin','admin',NULL,'2024-05-30 21:49:19','2024-05-30 23:23:23'),(3388,'ABO','provinceCode','address','1339',1,'admin','admin',NULL,'2024-05-30 21:49:19','2024-05-30 23:23:24'),(3389,'ABO','cityCode','address','133911',1,'admin','admin',NULL,'2024-05-30 21:49:19','2024-05-30 23:23:25'),(3390,'ABO','barangayCode','address','133911046',1,'admin','admin',NULL,'2024-05-30 21:49:20','2024-05-30 23:23:25'),(3391,'ABO','address','address','PEDRO GIL AND PAZ STREET PACO MANILA',1,'admin','admin',NULL,'2024-05-30 21:49:20','2024-05-30 23:23:26'),(3392,'ABO','zipCode','address','1007',1,'admin','admin',NULL,'2024-05-30 21:49:20','2024-05-30 23:23:26'),(3393,'DHA','personInCharge','info','SHEENA DELOVINO',1,'admin','admin',NULL,'2024-05-30 21:56:29','2024-05-30 23:23:43'),(3394,'DHA','contactNumber','info','09091233314',1,'admin','admin',NULL,'2024-05-30 21:56:29','2024-05-30 23:23:44'),(3395,'DHA','email','info','pcortez_tambunting@yahoo.com',1,'admin','admin',NULL,'2024-05-30 21:56:30','2024-05-30 23:23:44'),(3396,'DHA','includedOnSL','info','1',1,'admin','admin',NULL,'2024-05-30 21:56:30','2024-05-30 23:23:45'),(3397,'DHA','regionCode','address','13',1,'admin','admin',NULL,'2024-05-30 21:56:30','2024-05-30 23:23:46'),(3398,'DHA','provinceCode','address','1374',1,'admin','admin',NULL,'2024-05-30 21:56:30','2024-05-30 23:23:47'),(3399,'DHA','cityCode','address','137404',1,'admin','admin',NULL,'2024-05-30 21:56:31','2024-05-30 23:23:48'),(3400,'DHA','barangayCode','address','137404041',1,'admin','admin',NULL,'2024-05-30 21:56:31','2024-05-30 23:23:48'),(3401,'DHA','address','address','DAHLIA ST FAIRVIEW PARK',1,'admin','admin',NULL,'2024-05-30 21:56:31','2024-05-30 23:23:49'),(3402,'DHA','zipCode','address','1118',1,'admin','admin',NULL,'2024-05-30 21:56:32','2024-05-30 23:23:50'),(3403,'FRN','personInCharge','info','SHEENA DELOVINO',1,'admin','admin',NULL,'2024-05-30 22:01:07','2024-05-30 23:24:07'),(3404,'FRN','contactNumber','info','09091233314',1,'admin','admin',NULL,'2024-05-30 22:01:07','2024-05-30 23:24:07'),(3405,'FRN','email','info','pcortez_tambunting@yahoo.com',1,'admin','admin',NULL,'2024-05-30 22:01:08','2024-05-30 23:24:08'),(3406,'FRN','includedOnSL','info','1',1,'admin','admin',NULL,'2024-05-30 22:01:08','2024-05-30 23:24:09'),(3407,'FRN','regionCode','address','13',1,'admin','admin',NULL,'2024-05-30 22:01:08','2024-05-30 23:24:10'),(3408,'FRN','provinceCode','address','1376',1,'admin','admin',NULL,'2024-05-30 22:01:09','2024-05-30 23:24:10'),(3409,'FRN','cityCode','address','137605',1,'admin','admin',NULL,'2024-05-30 22:01:09','2024-05-30 23:24:11'),(3410,'FRN','barangayCode','address','137605199',1,'admin','admin',NULL,'2024-05-30 22:01:10','2024-05-30 23:24:12'),(3411,'FRN','address','address','245 FERNANDO REIN ST PASAY CITY',1,'admin','admin',NULL,'2024-05-30 22:01:10','2024-05-30 23:24:12'),(3412,'FRN','zipCode','address','1300',1,'admin','admin',NULL,'2024-05-30 22:01:10','2024-05-30 23:24:13'),(3413,'AIA','personInCharge','info','SHEENA DELOVINO',1,'admin',NULL,NULL,'2024-05-30 22:04:12','2024-05-30 22:04:12'),(3414,'AIA','contactNumber','info','09091233314',1,'admin',NULL,NULL,'2024-05-30 22:04:13','2024-05-30 22:04:13'),(3415,'AIA','email','info','k.goldpawnshopinc@yahoo.com',1,'admin',NULL,NULL,'2024-05-30 22:04:13','2024-05-30 22:04:13'),(3416,'AIA','includedOnSL','info','1',1,'admin',NULL,NULL,'2024-05-30 22:04:13','2024-05-30 22:04:13'),(3417,'AIA','regionCode','address','02',1,'admin',NULL,NULL,'2024-05-30 22:04:14','2024-05-30 22:04:14'),(3418,'AIA','provinceCode','address','0231',1,'admin',NULL,NULL,'2024-05-30 22:04:14','2024-05-30 22:04:14'),(3419,'AIA','cityCode','address','023101',1,'admin',NULL,NULL,'2024-05-30 22:04:15','2024-05-30 22:04:15'),(3420,'AIA','barangayCode','address','023101002',1,'admin',NULL,NULL,'2024-05-30 22:04:15','2024-05-30 22:04:15'),(3421,'AIA','address','address','Antonio',1,'admin',NULL,NULL,'2024-05-30 22:04:15','2024-05-30 22:04:15'),(3422,'AIA','zipCode','address','3306',1,'admin',NULL,NULL,'2024-05-30 22:04:16','2024-05-30 22:04:16'),(3423,'MDO','personInCharge','info','SHEENA DELOVINO',1,'admin','admin',NULL,'2024-05-30 22:06:03','2024-05-30 23:24:26'),(3424,'MDO','contactNumber','info','09091233314',1,'admin','admin',NULL,'2024-05-30 22:06:03','2024-05-30 23:24:26'),(3425,'MDO','email','info','pcortez_tambunting@yahoo.com',1,'admin','admin',NULL,'2024-05-30 22:06:04','2024-05-30 23:24:27'),(3426,'MDO','includedOnSL','info','1',1,'admin','admin',NULL,'2024-05-30 22:06:05','2024-05-30 23:24:28'),(3427,'MDO','regionCode','address','13',1,'admin','admin',NULL,'2024-05-30 22:06:05','2024-05-30 23:24:29'),(3428,'MDO','provinceCode','address','1374',1,'admin','admin',NULL,'2024-05-30 22:06:05','2024-05-30 23:24:29'),(3429,'MDO','cityCode','address','137404',1,'admin','admin',NULL,'2024-05-30 22:06:06','2024-05-30 23:24:30'),(3430,'MDO','barangayCode','address','137404120',1,'admin','admin',NULL,'2024-05-30 22:06:06','2024-05-30 23:24:31'),(3431,'MDO','address','address','DOMINIC BLDG. MINDANAO AVE. BRGY. TANDANG SORA',1,'admin','admin',NULL,'2024-05-30 22:06:06','2024-05-30 23:24:32'),(3432,'MDO','zipCode','address','1116',1,'admin','admin',NULL,'2024-05-30 22:06:07','2024-05-30 23:24:32'),(3433,'JPR','personInCharge','info','SHEENA DELOVINO',1,'admin',NULL,NULL,'2024-05-30 22:07:00','2024-05-30 22:07:00'),(3434,'JPR','contactNumber','info','09091233314',1,'admin',NULL,NULL,'2024-05-30 22:07:01','2024-05-30 22:07:01'),(3435,'JPR','email','info','k.goldpawnshopinc@yahoo.com',1,'admin',NULL,NULL,'2024-05-30 22:07:01','2024-05-30 22:07:01'),(3436,'JPR','includedOnSL','info','1',1,'admin',NULL,NULL,'2024-05-30 22:07:01','2024-05-30 22:07:01'),(3437,'JPR','regionCode','address','13',1,'admin',NULL,NULL,'2024-05-30 22:07:02','2024-05-30 22:07:02'),(3438,'JPR','provinceCode','address','1374',1,'admin',NULL,NULL,'2024-05-30 22:07:02','2024-05-30 22:07:02'),(3439,'JPR','cityCode','address','137402',1,'admin',NULL,NULL,'2024-05-30 22:07:03','2024-05-30 22:07:03'),(3440,'JPR','barangayCode','address','137402010',1,'admin',NULL,NULL,'2024-05-30 22:07:03','2024-05-30 22:07:03'),(3441,'JPR','address','address','390 JP Rizal St.',1,'admin',NULL,NULL,'2024-05-30 22:07:03','2024-05-30 22:07:03'),(3442,'JPR','zipCode','address','1820',1,'admin',NULL,NULL,'2024-05-30 22:07:04','2024-05-30 22:07:04'),(3443,'ACL','personInCharge','info','SHEENA DELOVINO',1,'admin','admin',NULL,'2024-05-30 22:13:28','2024-05-30 22:44:29'),(3444,'ACL','contactNumber','info','09091233314',1,'admin','admin',NULL,'2024-05-30 22:13:28','2024-05-30 22:44:29'),(3445,'ACL','email','info','k.goldpawnshopinc@yahoo.com',1,'admin','admin',NULL,'2024-05-30 22:13:29','2024-05-30 22:44:30'),(3446,'ACL','includedOnSL','info','1',1,'admin','admin',NULL,'2024-05-30 22:13:29','2024-05-30 22:44:30'),(3447,'ACL','regionCode','address','02',1,'admin','admin',NULL,'2024-05-30 22:13:29','2024-05-30 22:44:31'),(3448,'ACL','provinceCode','address','0215',1,'admin','admin',NULL,'2024-05-30 22:13:30','2024-05-30 22:44:32'),(3449,'ACL','cityCode','address','021502',1,'admin','admin',NULL,'2024-05-30 22:13:30','2024-05-30 22:44:32'),(3450,'ACL','barangayCode','address','021502011',1,'admin','admin',NULL,'2024-05-30 22:13:30','2024-05-30 22:44:33'),(3451,'ACL','address','address','ANGELS PLAZA BLDG',1,'admin','admin',NULL,'2024-05-30 22:13:30','2024-05-30 22:44:33'),(3452,'ACL','zipCode','address','3507',1,'admin','admin',NULL,'2024-05-30 22:13:31','2024-05-30 22:44:34'),(3453,'GTN','personInCharge','info','SHEENA DELOVINO',1,'admin','admin',NULL,'2024-05-30 22:22:06','2024-05-30 22:45:04'),(3454,'GTN','contactNumber','info','09091233314',1,'admin','admin',NULL,'2024-05-30 22:22:07','2024-05-30 22:45:05'),(3455,'GTN','email','info','k.goldpawnshopinc@yahoo.com',1,'admin','admin',NULL,'2024-05-30 22:22:07','2024-05-30 22:45:06'),(3456,'GTN','includedOnSL','info','1',1,'admin','admin',NULL,'2024-05-30 22:22:08','2024-05-30 22:45:06'),(3457,'GTN','regionCode','address','02',1,'admin','admin',NULL,'2024-05-30 22:22:08','2024-05-30 22:45:07'),(3458,'GTN','provinceCode','address','0215',1,'admin','admin',NULL,'2024-05-30 22:22:08','2024-05-30 22:45:08'),(3459,'GTN','cityCode','address','021513',1,'admin','admin',NULL,'2024-05-30 22:22:08','2024-05-30 22:45:08'),(3460,'GTN','barangayCode','address','021513020',1,'admin','admin',NULL,'2024-05-30 22:22:09','2024-05-30 22:45:09'),(3461,'GTN','address','address','CAGAYAN NATIONAL HIGHWAY',1,'admin','admin',NULL,'2024-05-30 22:22:09','2024-05-30 22:45:09'),(3462,'GTN','zipCode','address','3508',1,'admin','admin',NULL,'2024-05-30 22:22:09','2024-05-30 22:45:10'),(3463,'GTZ','personInCharge','info','SHEENA DELOVINO',1,'admin','admin',NULL,'2024-05-30 22:25:21','2024-05-30 23:24:46'),(3464,'GTZ','contactNumber','info','09091233314',1,'admin','admin',NULL,'2024-05-30 22:25:21','2024-05-30 23:24:47'),(3465,'GTZ','email','info','pcortez_tambunting@yahoo.com',1,'admin','admin',NULL,'2024-05-30 22:25:22','2024-05-30 23:24:48'),(3466,'GTZ','includedOnSL','info','1',1,'admin','admin',NULL,'2024-05-30 22:25:22','2024-05-30 23:24:49'),(3467,'GTZ','regionCode','address','13',1,'admin','admin',NULL,'2024-05-30 22:25:23','2024-05-30 23:24:49'),(3468,'GTZ','provinceCode','address','1339',1,'admin','admin',NULL,'2024-05-30 22:25:23','2024-05-30 23:24:50'),(3469,'GTZ','cityCode','address','133906',1,'admin','admin',NULL,'2024-05-30 22:25:24','2024-05-30 23:24:51'),(3470,'GTZ','barangayCode','address','133906170',1,'admin','admin',NULL,'2024-05-30 22:25:24','2024-05-30 23:24:52'),(3471,'GTZ','address','address','G TUAZON ST COR SAMAR ST BALIC BALIC ZONE 55 BRGY 564 SAMPALOC MANILA',1,'admin','admin',NULL,'2024-05-30 22:25:25','2024-05-30 23:24:53'),(3472,'GTZ','zipCode','address','1008',1,'admin','admin',NULL,'2024-05-30 22:25:25','2024-05-30 23:24:53'),(3473,'CTA','personInCharge','info','SHEENA DELOVINO',1,'admin','admin',NULL,'2024-05-30 22:33:30','2024-05-30 23:25:43'),(3474,'CTA','contactNumber','info','09091233314',1,'admin','admin',NULL,'2024-05-30 22:33:31','2024-05-30 23:25:44'),(3475,'CTA','email','info','pcortez_tambunting@yahoo.com',1,'admin','admin',NULL,'2024-05-30 22:33:31','2024-05-30 23:25:44'),(3476,'CTA','includedOnSL','info','1',1,'admin','admin',NULL,'2024-05-30 22:33:32','2024-05-30 23:25:45'),(3477,'CTA','regionCode','address','06',1,'admin','admin',NULL,'2024-05-30 22:33:32','2024-05-30 23:25:46'),(3478,'CTA','provinceCode','address','0645',1,'admin','admin',NULL,'2024-05-30 22:33:32','2024-05-30 23:25:46'),(3479,'CTA','cityCode','address','064505',1,'admin','admin',NULL,'2024-05-30 22:33:32','2024-05-30 23:25:47'),(3480,'CTA','barangayCode','address','064505037',1,'admin','admin',NULL,'2024-05-30 22:33:33','2024-05-30 23:25:48'),(3481,'CTA','address','address','BRGY. SUBA CALATRAVA',1,'admin','admin',NULL,'2024-05-30 22:33:33','2024-05-30 23:25:49'),(3482,'CTA','zipCode','address','6126',1,'admin','admin',NULL,'2024-05-30 22:33:33','2024-05-30 23:25:49'),(3483,'SSS','personInCharge','info','SHEENA DELOVINO',1,'admin',NULL,NULL,'2024-05-30 22:36:30','2024-05-30 22:36:30'),(3484,'SSS','contactNumber','info','09091233314',1,'admin',NULL,NULL,'2024-05-30 22:36:30','2024-05-30 22:36:30'),(3485,'SSS','email','info','k.goldpawnshopinc@yahoo.com',1,'admin',NULL,NULL,'2024-05-30 22:36:30','2024-05-30 22:36:30'),(3486,'SSS','includedOnSL','info','1',1,'admin',NULL,NULL,'2024-05-30 22:36:31','2024-05-30 22:36:31'),(3487,'SSS','regionCode','address','13',1,'admin',NULL,NULL,'2024-05-30 22:36:31','2024-05-30 22:36:31'),(3488,'SSS','provinceCode','address','1374',1,'admin',NULL,NULL,'2024-05-30 22:36:31','2024-05-30 22:36:31'),(3489,'SSS','cityCode','address','137402',1,'admin',NULL,NULL,'2024-05-30 22:36:31','2024-05-30 22:36:31'),(3490,'SSS','barangayCode','address','137402003',1,'admin',NULL,NULL,'2024-05-30 22:36:32','2024-05-30 22:36:32'),(3491,'SSS','address','address','# 57 PANORAMA ST',1,'admin',NULL,NULL,'2024-05-30 22:36:32','2024-05-30 22:36:32'),(3492,'SSS','zipCode','address','1820',1,'admin',NULL,NULL,'2024-05-30 22:36:32','2024-05-30 22:36:32'),(3493,'CBN','personInCharge','info','SHEENA DELOVINO',1,'admin','admin',NULL,'2024-05-30 22:38:24','2024-05-30 22:47:06'),(3494,'CBN','contactNumber','info','09091233314',1,'admin','admin',NULL,'2024-05-30 22:38:25','2024-05-30 22:47:07'),(3495,'CBN','email','info','k.goldpawnshopinc@yahoo.com.ph',1,'admin','admin',NULL,'2024-05-30 22:38:26','2024-05-30 22:47:08'),(3496,'CBN','includedOnSL','info','1',1,'admin','admin',NULL,'2024-05-30 22:38:26','2024-05-30 22:47:08'),(3497,'CBN','regionCode','address','02',1,'admin','admin',NULL,'2024-05-30 22:38:26','2024-05-30 22:47:09'),(3498,'CBN','provinceCode','address','0231',1,'admin','admin',NULL,'2024-05-30 22:38:26','2024-05-30 22:47:09'),(3499,'CBN','cityCode','address','023106',1,'admin','admin',NULL,'2024-05-30 22:38:27','2024-05-30 22:47:10'),(3500,'CBN','barangayCode','address','023106002',1,'admin','admin',NULL,'2024-05-30 22:38:27','2024-05-30 22:47:11'),(3501,'CBN','address','address','NATIONAL HIGHWAY',1,'admin','admin',NULL,'2024-05-30 22:38:27','2024-05-30 22:47:11'),(3502,'CBN','zipCode','address','3328',1,'admin','admin',NULL,'2024-05-30 22:38:27','2024-05-30 22:47:12'),(3503,'TMI','personInCharge','info','SHEENA DELOVINO',1,'admin','admin',NULL,'2024-05-30 22:38:32','2024-05-30 23:21:31'),(3504,'TMI','contactNumber','info','09091233314',1,'admin','admin',NULL,'2024-05-30 22:38:33','2024-05-30 23:21:32'),(3505,'TMI','email','info','pcortez_tambunting@yahoo.com',1,'admin','admin',NULL,'2024-05-30 22:38:34','2024-05-30 23:21:33'),(3506,'TMI','includedOnSL','info','1',1,'admin','admin',NULL,'2024-05-30 22:38:34','2024-05-30 23:21:33'),(3507,'TMI','regionCode','address','02',1,'admin','admin',NULL,'2024-05-30 22:38:35','2024-05-30 23:21:34'),(3508,'TMI','provinceCode','address','0231',1,'admin','admin',NULL,'2024-05-30 22:38:35','2024-05-30 23:21:35'),(3509,'TMI','cityCode','address','023137',1,'admin','admin',NULL,'2024-05-30 22:38:36','2024-05-30 23:21:35'),(3510,'TMI','barangayCode','address','023137025',1,'admin','admin',NULL,'2024-05-30 22:38:36','2024-05-30 23:21:36'),(3511,'TMI','address','address','LINGALING TUMAUINI ISABELA',1,'admin','admin',NULL,'2024-05-30 22:38:36','2024-05-30 23:21:37'),(3512,'TMI','zipCode','address','3325',1,'admin','admin',NULL,'2024-05-30 22:38:36','2024-05-30 23:21:37'),(3513,'MRO2','personInCharge','info','SHEENA DELOVINO',1,'admin','admin',NULL,'2024-05-30 22:42:10','2024-05-30 23:25:07'),(3514,'MRO2','contactNumber','info','09091233314',1,'admin','admin',NULL,'2024-05-30 22:42:10','2024-05-30 23:25:07'),(3515,'MRO2','email','info','pcortez_tambunting@yahoo.com',1,'admin','admin',NULL,'2024-05-30 22:42:11','2024-05-30 23:25:08'),(3516,'MRO2','includedOnSL','info','1',1,'admin','admin',NULL,'2024-05-30 22:42:11','2024-05-30 23:25:09'),(3517,'MRO2','regionCode','address','03',1,'admin','admin',NULL,'2024-05-30 22:42:11','2024-05-30 23:25:10'),(3518,'MRO2','provinceCode','address','0314',1,'admin','admin',NULL,'2024-05-30 22:42:11','2024-05-30 23:25:11'),(3519,'MRO2','cityCode','address','031411',1,'admin','admin',NULL,'2024-05-30 22:42:12','2024-05-30 23:25:11'),(3520,'MRO2','barangayCode','address','031411013',1,'admin','admin',NULL,'2024-05-30 22:42:12','2024-05-30 23:25:12'),(3521,'MRO2','address','address','VILLARICA RD. STA. ROSA I MARILAO BULACAN',1,'admin','admin',NULL,'2024-05-30 22:42:13','2024-05-30 23:25:13'),(3522,'MRO2','zipCode','address','3019',1,'admin','admin',NULL,'2024-05-30 22:42:13','2024-05-30 23:25:14'),(3523,'TPZ','personInCharge','info','SHEENA DELOVINO',1,'admin',NULL,NULL,'2024-05-30 22:43:08','2024-05-30 22:43:08'),(3524,'TPZ','contactNumber','info','09091233314',1,'admin',NULL,NULL,'2024-05-30 22:43:09','2024-05-30 22:43:09'),(3525,'TPZ','email','info','k.goldpawnshopinc.@yahoo.com.ph',1,'admin',NULL,NULL,'2024-05-30 22:43:09','2024-05-30 22:43:09'),(3526,'TPZ','includedOnSL','info','1',1,'admin',NULL,NULL,'2024-05-30 22:43:09','2024-05-30 22:43:09'),(3527,'TPZ','regionCode','address','06',1,'admin',NULL,NULL,'2024-05-30 22:43:10','2024-05-30 22:43:10'),(3528,'TPZ','provinceCode','address','0619',1,'admin',NULL,NULL,'2024-05-30 22:43:10','2024-05-30 22:43:10'),(3529,'TPZ','cityCode','address','061917',1,'admin',NULL,NULL,'2024-05-30 22:43:10','2024-05-30 22:43:10'),(3530,'TPZ','barangayCode','address','061917032',1,'admin',NULL,NULL,'2024-05-30 22:43:11','2024-05-30 22:43:11'),(3531,'TPZ','address','address','PUBLIC MARKET',1,'admin',NULL,NULL,'2024-05-30 22:43:11','2024-05-30 22:43:11'),(3532,'TPZ','zipCode','address','5814',1,'admin',NULL,NULL,'2024-05-30 22:43:12','2024-05-30 22:43:12'),(3533,'VMC','personInCharge','info','SHEENA DELOVINO',1,'admin','admin',NULL,'2024-05-30 22:44:46','2024-05-30 23:22:01'),(3534,'VMC','contactNumber','info','09091233314',1,'admin','admin',NULL,'2024-05-30 22:44:47','2024-05-30 23:22:02'),(3535,'VMC','email','info','pcortez_tambunting@yahoo.com',1,'admin','admin',NULL,'2024-05-30 22:44:47','2024-05-30 23:22:03'),(3536,'VMC','includedOnSL','info','1',1,'admin','admin',NULL,'2024-05-30 22:44:48','2024-05-30 23:22:03'),(3537,'VMC','regionCode','address','13',1,'admin','admin',NULL,'2024-05-30 22:44:49','2024-05-30 23:22:04'),(3538,'VMC','provinceCode','address','1375',1,'admin','admin',NULL,'2024-05-30 22:44:49','2024-05-30 23:22:05'),(3539,'VMC','cityCode','address','137501',1,'admin','admin',NULL,'2024-05-30 22:44:50','2024-05-30 23:22:05'),(3540,'VMC','barangayCode','address','137501072',1,'admin','admin',NULL,'2024-05-30 22:44:50','2024-05-30 23:22:06'),(3541,'VMC','address','address','G19 VICTORY CENTRAL MALL BARANGAY 72 CALOOCAN CITY',1,'admin','admin',NULL,'2024-05-30 22:44:51','2024-05-30 23:22:06'),(3542,'VMC','zipCode','address','1400',1,'admin','admin',NULL,'2024-05-30 22:44:51','2024-05-30 23:22:07'),(3543,'PRL','personInCharge','info','SHEENA DELOVINO',1,'admin','admin',NULL,'2024-05-30 22:47:53','2024-05-30 23:26:04'),(3544,'PRL','contactNumber','info','09091233314',1,'admin','admin',NULL,'2024-05-30 22:47:53','2024-05-30 23:26:05'),(3545,'PRL','email','info','pcortez_tambunting@yahoo.com',1,'admin','admin',NULL,'2024-05-30 22:47:53','2024-05-30 23:26:06'),(3546,'PRL','includedOnSL','info','1',1,'admin','admin',NULL,'2024-05-30 22:47:54','2024-05-30 23:26:07'),(3547,'PRL','regionCode','address','13',1,'admin','admin',NULL,'2024-05-30 22:47:54','2024-05-30 23:26:07'),(3548,'PRL','provinceCode','address','1374',1,'admin','admin',NULL,'2024-05-30 22:47:55','2024-05-30 23:26:08'),(3549,'PRL','cityCode','address','137404',1,'admin','admin',NULL,'2024-05-30 22:47:55','2024-05-30 23:26:09'),(3550,'PRL','barangayCode','address','137404022',1,'admin','admin',NULL,'2024-05-30 22:47:55','2024-05-30 23:26:10'),(3551,'PRL','address','address','PEARL DRIVE COMMERCIAL CENTER PEARL STREET COMMONWEALTH QUEZON CITY',1,'admin','admin',NULL,'2024-05-30 22:47:56','2024-05-30 23:26:10'),(3552,'PRL','zipCode','address','1121',1,'admin','admin',NULL,'2024-05-30 22:47:56','2024-05-30 23:26:11'),(3553,'DLG','personInCharge','info','SHEENA DELOVINO',1,'admin','admin',NULL,'2024-05-30 22:49:51','2024-05-30 22:50:21'),(3554,'DLG','contactNumber','info','09091233314',1,'admin','admin',NULL,'2024-05-30 22:49:51','2024-05-30 22:50:21'),(3555,'DLG','email','info','k.goldpawnshopinc@yahoo.com.ph',1,'admin','admin',NULL,'2024-05-30 22:49:52','2024-05-30 22:50:22'),(3556,'DLG','includedOnSL','info','1',1,'admin','admin',NULL,'2024-05-30 22:49:52','2024-05-30 22:50:23'),(3557,'DLG','regionCode','address','06',1,'admin','admin',NULL,'2024-05-30 22:49:52','2024-05-30 22:50:23'),(3558,'DLG','provinceCode','address','0619',1,'admin','admin',NULL,'2024-05-30 22:49:52','2024-05-30 22:50:24'),(3559,'DLG','cityCode','address','061903',1,'admin','admin',NULL,'2024-05-30 22:49:53','2024-05-30 22:50:25'),(3560,'DLG','barangayCode','address','061903021',1,'admin','admin',NULL,'2024-05-30 22:49:53','2024-05-30 22:50:25'),(3561,'DLG','address','address','POBLACION',1,'admin','admin',NULL,'2024-05-30 22:49:53','2024-05-30 22:50:26'),(3562,'DLG','zipCode','address','5813',1,'admin','admin',NULL,'2024-05-30 22:49:54','2024-05-30 22:50:27'),(3563,'ATP1','personInCharge','info','SHEENA DELOVINO',1,'admin','admin',NULL,'2024-05-30 22:52:57','2024-05-30 23:19:46'),(3564,'ATP1','contactNumber','info','09091233314',1,'admin','admin',NULL,'2024-05-30 22:52:58','2024-05-30 23:19:46'),(3565,'ATP1','email','info','p.greenamberjewelry@yahoo.com',1,'admin','admin',NULL,'2024-05-30 22:52:58','2024-05-30 23:19:46'),(3566,'ATP1','includedOnSL','info','1',1,'admin','admin',NULL,'2024-05-30 22:52:59','2024-05-30 23:19:47'),(3567,'ATP1','regionCode','address','04',1,'admin','admin',NULL,'2024-05-30 22:52:59','2024-05-30 23:19:47'),(3568,'ATP1','provinceCode','address','0458',1,'admin','admin',NULL,'2024-05-30 22:52:59','2024-05-30 23:19:48'),(3569,'ATP1','cityCode','address','045802',1,'admin','admin',NULL,'2024-05-30 22:53:00','2024-05-30 23:19:48'),(3570,'ATP1','barangayCode','address','045802009',1,'admin','admin',NULL,'2024-05-30 22:53:00','2024-05-30 23:19:49'),(3571,'ATP1','address','address','P OLIVEROS ST. SAN ROQUE ANTIPOLO RIZAL',1,'admin','admin',NULL,'2024-05-30 22:53:00','2024-05-30 23:19:49'),(3572,'ATP1','zipCode','address','1870',1,'admin','admin',NULL,'2024-05-30 22:53:01','2024-05-30 23:19:49'),(3573,'IPL1','personInCharge','info','SHEENA DELOVINO',1,'admin',NULL,NULL,'2024-05-30 22:53:09','2024-05-30 22:53:09'),(3574,'IPL1','contactNumber','info','09091233314',1,'admin',NULL,NULL,'2024-05-30 22:53:10','2024-05-30 22:53:10'),(3575,'IPL1','email','info','k.goldpawnshopinc@yahoo.com.ph',1,'admin',NULL,NULL,'2024-05-30 22:53:10','2024-05-30 22:53:10'),(3576,'IPL1','includedOnSL','info','1',1,'admin',NULL,NULL,'2024-05-30 22:53:10','2024-05-30 22:53:10'),(3577,'IPL1','regionCode','address','09',1,'admin',NULL,NULL,'2024-05-30 22:53:11','2024-05-30 22:53:11'),(3578,'IPL1','provinceCode','address','0983',1,'admin',NULL,NULL,'2024-05-30 22:53:12','2024-05-30 22:53:12'),(3579,'IPL1','cityCode','address','098305',1,'admin',NULL,NULL,'2024-05-30 22:53:12','2024-05-30 22:53:12'),(3580,'IPL1','barangayCode','address','098305023',1,'admin',NULL,NULL,'2024-05-30 22:53:13','2024-05-30 22:53:13'),(3581,'IPL1','address','address','NATIONAL HIGHWAY',1,'admin',NULL,NULL,'2024-05-30 22:53:13','2024-05-30 22:53:13'),(3582,'IPL1','zipCode','address','7001',1,'admin',NULL,NULL,'2024-05-30 22:53:13','2024-05-30 22:53:13'),(3583,'AUR','personInCharge','info','SHEENA DELOVINO',1,'admin','admin',NULL,'2024-05-30 22:55:22','2024-05-30 23:20:26'),(3584,'AUR','contactNumber','info','09091233314',1,'admin','admin',NULL,'2024-05-30 22:55:22','2024-05-30 23:20:27'),(3585,'AUR','email','info','p.greenamberjewelry@yahoo.com',1,'admin','admin',NULL,'2024-05-30 22:55:23','2024-05-30 23:20:28'),(3586,'AUR','includedOnSL','info','1',1,'admin','admin',NULL,'2024-05-30 22:55:23','2024-05-30 23:20:29'),(3587,'AUR','regionCode','address','02',1,'admin','admin',NULL,'2024-05-30 22:55:24','2024-05-30 23:20:29'),(3588,'AUR','provinceCode','address','0231',1,'admin','admin',NULL,'2024-05-30 22:55:24','2024-05-30 23:20:30'),(3589,'AUR','cityCode','address','023103',1,'admin','admin',NULL,'2024-05-30 22:55:25','2024-05-30 23:20:31'),(3590,'AUR','barangayCode','address','023103027',1,'admin','admin',NULL,'2024-05-30 22:55:25','2024-05-30 23:20:31'),(3591,'AUR','address','address','STA ROSA AURORA ISABELA',1,'admin','admin',NULL,'2024-05-30 22:55:25','2024-05-30 23:20:32'),(3592,'AUR','zipCode','address','3316',1,'admin','admin',NULL,'2024-05-30 22:55:26','2024-05-30 23:20:33'),(3593,'BLG','personInCharge','info','SHEENA DELOVINO',1,'admin',NULL,NULL,'2024-05-30 22:57:42','2024-05-30 22:57:42'),(3594,'BLG','contactNumber','info','09091233314',1,'admin',NULL,NULL,'2024-05-30 22:57:42','2024-05-30 22:57:42'),(3595,'BLG','email','info','k.goldpawnshopinc@yahoo.com.ph',1,'admin',NULL,NULL,'2024-05-30 22:57:43','2024-05-30 22:57:43'),(3596,'BLG','includedOnSL','info','1',1,'admin',NULL,NULL,'2024-05-30 22:57:43','2024-05-30 22:57:43'),(3597,'BLG','regionCode','address','16',1,'admin',NULL,NULL,'2024-05-30 22:57:43','2024-05-30 22:57:43'),(3598,'BLG','provinceCode','address','1668',1,'admin',NULL,NULL,'2024-05-30 22:57:44','2024-05-30 22:57:44'),(3599,'BLG','cityCode','address','166803',1,'admin',NULL,NULL,'2024-05-30 22:57:45','2024-05-30 22:57:45'),(3600,'BLG','barangayCode','address','166803009',1,'admin',NULL,NULL,'2024-05-30 22:57:45','2024-05-30 22:57:45'),(3601,'BLG','address','address','BARREDA-F CLAR ST.',1,'admin',NULL,NULL,'2024-05-30 22:57:45','2024-05-30 22:57:45'),(3602,'BLG','zipCode','address','8311',1,'admin',NULL,NULL,'2024-05-30 22:57:46','2024-05-30 22:57:46'),(3603,'BOC1','personInCharge','info','SHEENA DELOVINO',1,'admin','admin',NULL,'2024-05-30 22:59:16','2024-05-30 23:20:51'),(3604,'BOC1','contactNumber','info','09091233314',1,'admin','admin',NULL,'2024-05-30 22:59:17','2024-05-30 23:20:52'),(3605,'BOC1','email','info','p.greenamberjewelry@yahoo.com',1,'admin','admin',NULL,'2024-05-30 22:59:17','2024-05-30 23:20:53'),(3606,'BOC1','includedOnSL','info','1',1,'admin','admin',NULL,'2024-05-30 22:59:18','2024-05-30 23:20:53'),(3607,'BOC1','regionCode','address','03',1,'admin','admin',NULL,'2024-05-30 22:59:18','2024-05-30 23:20:54'),(3608,'BOC1','provinceCode','address','0314',1,'admin','admin',NULL,'2024-05-30 22:59:18','2024-05-30 23:20:55'),(3609,'BOC1','cityCode','address','031404',1,'admin','admin',NULL,'2024-05-30 22:59:19','2024-05-30 23:20:55'),(3610,'BOC1','barangayCode','address','031404007',1,'admin','admin',NULL,'2024-05-30 22:59:19','2024-05-30 23:20:56'),(3611,'BOC1','address','address','MC ARTHUR HIGHWAY WAKAS BOCAUE BULACAN',1,'admin','admin',NULL,'2024-05-30 22:59:19','2024-05-30 23:20:57'),(3612,'BOC1','zipCode','address','3018',1,'admin','admin',NULL,'2024-05-30 22:59:20','2024-05-30 23:20:58'),(3613,'CLM2','personInCharge','info','SHEENA DELOVINO',1,'admin',NULL,NULL,'2024-05-30 23:36:17','2024-05-30 23:36:17'),(3614,'CLM2','contactNumber','info','09091233314',1,'admin',NULL,NULL,'2024-05-30 23:36:17','2024-05-30 23:36:17'),(3615,'CLM2','email','info','p.greenamberjewelry@yahoo.com',1,'admin',NULL,NULL,'2024-05-30 23:36:18','2024-05-30 23:36:18'),(3616,'CLM2','includedOnSL','info','1',1,'admin',NULL,NULL,'2024-05-30 23:36:18','2024-05-30 23:36:18'),(3617,'CLM2','regionCode','address','12',1,'admin',NULL,NULL,'2024-05-30 23:36:19','2024-05-30 23:36:19'),(3618,'CLM2','provinceCode','address','1263',1,'admin',NULL,NULL,'2024-05-30 23:36:19','2024-05-30 23:36:19'),(3619,'CLM2','cityCode','address','126303',1,'admin',NULL,NULL,'2024-05-30 23:36:19','2024-05-30 23:36:19'),(3620,'CLM2','barangayCode','address','126303036',1,'admin',NULL,NULL,'2024-05-30 23:36:20','2024-05-30 23:36:20'),(3621,'CLM2','address','address','PUROK 4 SAMBAGON ST. BRGY. CALUMPANG GENERAL SANTOS',1,'admin',NULL,NULL,'2024-05-30 23:36:20','2024-05-30 23:36:20'),(3622,'CLM2','zipCode','address','9500',1,'admin',NULL,NULL,'2024-05-30 23:36:20','2024-05-30 23:36:20'),(3623,'LBN','personInCharge','info','SHEENA DELOVINO',1,'admin',NULL,NULL,'2024-05-30 23:39:48','2024-05-30 23:39:48'),(3624,'LBN','contactNumber','info','09091233314',1,'admin',NULL,NULL,'2024-05-30 23:39:48','2024-05-30 23:39:48'),(3625,'LBN','email','info','p.greenamberjewelry@yahoo.com',1,'admin',NULL,NULL,'2024-05-30 23:39:48','2024-05-30 23:39:48'),(3626,'LBN','includedOnSL','info','1',1,'admin',NULL,NULL,'2024-05-30 23:39:49','2024-05-30 23:39:49'),(3627,'LBN','regionCode','address','07',1,'admin',NULL,NULL,'2024-05-30 23:39:49','2024-05-30 23:39:49'),(3628,'LBN','provinceCode','address','0722',1,'admin',NULL,NULL,'2024-05-30 23:39:50','2024-05-30 23:39:50'),(3629,'LBN','cityCode','address','072217',1,'admin',NULL,NULL,'2024-05-30 23:39:50','2024-05-30 23:39:50'),(3630,'LBN','barangayCode','address','072217040',1,'admin',NULL,NULL,'2024-05-30 23:39:50','2024-05-30 23:39:50'),(3631,'LBN','address','address','332 KATIPUNAN ST. LABANGON CEBU CITY',1,'admin',NULL,NULL,'2024-05-30 23:39:50','2024-05-30 23:39:50'),(3632,'LBN','zipCode','address','6000',1,'admin',NULL,NULL,'2024-05-30 23:39:51','2024-05-30 23:39:51'),(3633,'MBY1','personInCharge','info','SHEENA DELOVINO',1,'admin',NULL,NULL,'2024-05-30 23:48:12','2024-05-30 23:48:12'),(3634,'MBY1','contactNumber','info','09091233314',1,'admin',NULL,NULL,'2024-05-30 23:48:12','2024-05-30 23:48:12'),(3635,'MBY1','email','info','p.greenamberjewelry@yahoo.com',1,'admin',NULL,NULL,'2024-05-30 23:48:13','2024-05-30 23:48:13'),(3636,'MBY1','includedOnSL','info','1',1,'admin',NULL,NULL,'2024-05-30 23:48:13','2024-05-30 23:48:13'),(3637,'MBY1','regionCode','address','12',1,'admin',NULL,NULL,'2024-05-30 23:48:14','2024-05-30 23:48:14'),(3638,'MBY1','provinceCode','address','1263',1,'admin',NULL,NULL,'2024-05-30 23:48:14','2024-05-30 23:48:14'),(3639,'MBY1','cityCode','address','126303',1,'admin',NULL,NULL,'2024-05-30 23:48:14','2024-05-30 23:48:14'),(3640,'MBY1','barangayCode','address','126303036',1,'admin',NULL,NULL,'2024-05-30 23:48:14','2024-05-30 23:48:14'),(3641,'MBY1','address','address','PUROK 21 DREAMLAND HIGHWAY MABUHAY GEN. SANTOS CITY',1,'admin',NULL,NULL,'2024-05-30 23:48:15','2024-05-30 23:48:15'),(3642,'MBY1','zipCode','address','9500',1,'admin',NULL,NULL,'2024-05-30 23:48:15','2024-05-30 23:48:15'),(3643,'PSK','personInCharge','info','SHEENA DELOVINO',1,'admin',NULL,NULL,'2024-05-30 23:51:07','2024-05-30 23:51:07'),(3644,'PSK','contactNumber','info','09091233314',1,'admin',NULL,NULL,'2024-05-30 23:51:08','2024-05-30 23:51:08'),(3645,'PSK','email','info','p.greenamberjewelry@yahoo.com',1,'admin',NULL,NULL,'2024-05-30 23:51:08','2024-05-30 23:51:08'),(3646,'PSK','includedOnSL','info','1',1,'admin',NULL,NULL,'2024-05-30 23:51:08','2024-05-30 23:51:08'),(3647,'PSK','regionCode','address','07',1,'admin',NULL,NULL,'2024-05-30 23:51:09','2024-05-30 23:51:09'),(3648,'PSK','provinceCode','address','0722',1,'admin',NULL,NULL,'2024-05-30 23:51:09','2024-05-30 23:51:09'),(3649,'PSK','cityCode','address','072226',1,'admin',NULL,NULL,'2024-05-30 23:51:09','2024-05-30 23:51:09'),(3650,'PSK','barangayCode','address','072226024',1,'admin',NULL,NULL,'2024-05-30 23:51:10','2024-05-30 23:51:10'),(3651,'PSK','address','address','STALL #4 PUSOK MUSTANG LAPU-LAPU CITY',1,'admin',NULL,NULL,'2024-05-30 23:51:10','2024-05-30 23:51:10'),(3652,'PSK','zipCode','address','6015',1,'admin',NULL,NULL,'2024-05-30 23:51:10','2024-05-30 23:51:10'),(3653,'RXS','personInCharge','info','SHEENA DELOVINO',1,'admin',NULL,NULL,'2024-05-30 23:53:32','2024-05-30 23:53:32'),(3654,'RXS','contactNumber','info','09091233314',1,'admin',NULL,NULL,'2024-05-30 23:53:32','2024-05-30 23:53:32'),(3655,'RXS','email','info','p.greenamberjewelry@yahoo.com',1,'admin',NULL,NULL,'2024-05-30 23:53:32','2024-05-30 23:53:32'),(3656,'RXS','includedOnSL','info','1',1,'admin',NULL,NULL,'2024-05-30 23:53:33','2024-05-30 23:53:33'),(3657,'RXS','regionCode','address','02',1,'admin',NULL,NULL,'2024-05-30 23:53:34','2024-05-30 23:53:34'),(3658,'RXS','provinceCode','address','0231',1,'admin',NULL,NULL,'2024-05-30 23:53:34','2024-05-30 23:53:34'),(3659,'RXS','cityCode','address','023126',1,'admin',NULL,NULL,'2024-05-30 23:53:34','2024-05-30 23:53:34'),(3660,'RXS','barangayCode','address','023126011',1,'admin',NULL,NULL,'2024-05-30 23:53:34','2024-05-30 23:53:34'),(3661,'RXS','address','address','RIZAL UNO ROXAS ISABELA',1,'admin',NULL,NULL,'2024-05-30 23:53:35','2024-05-30 23:53:35'),(3662,'RXS','zipCode','address','3320',1,'admin',NULL,NULL,'2024-05-30 23:53:35','2024-05-30 23:53:35'),(3663,'SMT','personInCharge','info','SHEENA DELOVINO',1,'admin',NULL,NULL,'2024-05-30 23:56:05','2024-05-30 23:56:05'),(3664,'SMT','contactNumber','info','09091233314',1,'admin',NULL,NULL,'2024-05-30 23:56:05','2024-05-30 23:56:05'),(3665,'SMT','email','info','p.greenamberjewelry@yahoo.com',1,'admin',NULL,NULL,'2024-05-30 23:56:05','2024-05-30 23:56:05'),(3666,'SMT','includedOnSL','info','1',1,'admin',NULL,NULL,'2024-05-30 23:56:06','2024-05-30 23:56:06'),(3667,'SMT','regionCode','address','02',1,'admin',NULL,NULL,'2024-05-30 23:56:06','2024-05-30 23:56:06'),(3668,'SMT','provinceCode','address','0231',1,'admin',NULL,NULL,'2024-05-30 23:56:07','2024-05-30 23:56:07'),(3669,'SMT','cityCode','address','023132',1,'admin',NULL,NULL,'2024-05-30 23:56:07','2024-05-30 23:56:07'),(3670,'SMT','barangayCode','address','023132019',1,'admin',NULL,NULL,'2024-05-30 23:56:07','2024-05-30 23:56:07'),(3671,'SMT','address','address','STALL 5 DELA CRUZ BLDG. BARANGAY 3 POBLACION SAN MATEO ISABELA',1,'admin',NULL,NULL,'2024-05-30 23:56:08','2024-05-30 23:56:08'),(3672,'SMT','zipCode','address','3318',1,'admin',NULL,NULL,'2024-05-30 23:56:08','2024-05-30 23:56:08'),(3673,'BGO2','personInCharge','info','SHEENA DELOVINO',1,'admin',NULL,NULL,'2024-05-30 23:59:53','2024-05-30 23:59:53'),(3674,'BGO2','contactNumber','info','09091233314',1,'admin',NULL,NULL,'2024-05-30 23:59:54','2024-05-30 23:59:54'),(3675,'BGO2','email','info','p.greenamberjewelry@yahoo.com',1,'admin',NULL,NULL,'2024-05-30 23:59:54','2024-05-30 23:59:54'),(3676,'BGO2','includedOnSL','info','1',1,'admin',NULL,NULL,'2024-05-30 23:59:54','2024-05-30 23:59:54'),(3677,'BGO2','regionCode','address','14',1,'admin',NULL,NULL,'2024-05-30 23:59:55','2024-05-30 23:59:55'),(3678,'BGO2','provinceCode','address','1411',1,'admin',NULL,NULL,'2024-05-30 23:59:55','2024-05-30 23:59:55'),(3679,'BGO2','cityCode','address','141102',1,'admin',NULL,NULL,'2024-05-30 23:59:56','2024-05-30 23:59:56'),(3680,'BGO2','barangayCode','address','141102019',1,'admin',NULL,NULL,'2024-05-30 23:59:56','2024-05-30 23:59:56'),(3681,'BGO2','address','address','TAN BUILDING ROAMN AYSON CAMPO FILIPINO BAGUIO CITY BENGUET',1,'admin',NULL,NULL,'2024-05-30 23:59:56','2024-05-30 23:59:56'),(3682,'BGO2','zipCode','address','2600',1,'admin',NULL,NULL,'2024-05-30 23:59:57','2024-05-30 23:59:57'),(3683,'BJC','personInCharge','info','SHEENA DELOVINO',1,'admin',NULL,NULL,'2024-05-31 00:03:38','2024-05-31 00:03:38'),(3684,'BJC','contactNumber','info','09091233314',1,'admin',NULL,NULL,'2024-05-31 00:03:38','2024-05-31 00:03:38'),(3685,'BJC','email','info','p.greenamberjewelry@yahoo.com',1,'admin',NULL,NULL,'2024-05-31 00:03:38','2024-05-31 00:03:38'),(3686,'BJC','includedOnSL','info','1',1,'admin',NULL,NULL,'2024-05-31 00:03:39','2024-05-31 00:03:39'),(3687,'BJC','regionCode','address','03',1,'admin',NULL,NULL,'2024-05-31 00:03:39','2024-05-31 00:03:39'),(3688,'BJC','provinceCode','address','0371',1,'admin',NULL,NULL,'2024-05-31 00:03:40','2024-05-31 00:03:40'),(3689,'BJC','cityCode','address','037107',1,'admin',NULL,NULL,'2024-05-31 00:03:40','2024-05-31 00:03:40'),(3690,'BJC','barangayCode','address','037107019',1,'admin',NULL,NULL,'2024-05-31 00:03:40','2024-05-31 00:03:40'),(3691,'BJC','address','address','22ND CORNER BRILL WEST BAJAC-BAJAC OLONGAPO CITY ZAMBALES',1,'admin',NULL,NULL,'2024-05-31 00:03:40','2024-05-31 00:03:40'),(3692,'BJC','zipCode','address','2200',1,'admin',NULL,NULL,'2024-05-31 00:03:41','2024-05-31 00:03:41'),(3693,'BAL','personInCharge','info','SHEENA DELOVINO',1,'admin',NULL,NULL,'2024-05-31 00:06:53','2024-05-31 00:06:53'),(3694,'BAL','contactNumber','info','09091233314',1,'admin',NULL,NULL,'2024-05-31 00:06:53','2024-05-31 00:06:53'),(3695,'BAL','email','info','p.greenamberjewelry@yahoo.com',1,'admin',NULL,NULL,'2024-05-31 00:06:54','2024-05-31 00:06:54'),(3696,'BAL','includedOnSL','info','1',1,'admin',NULL,NULL,'2024-05-31 00:06:54','2024-05-31 00:06:54'),(3697,'BAL','regionCode','address','03',1,'admin',NULL,NULL,'2024-05-31 00:06:54','2024-05-31 00:06:54'),(3698,'BAL','provinceCode','address','0308',1,'admin',NULL,NULL,'2024-05-31 00:06:55','2024-05-31 00:06:55'),(3699,'BAL','cityCode','address','030803',1,'admin',NULL,NULL,'2024-05-31 00:06:55','2024-05-31 00:06:55'),(3700,'BAL','barangayCode','address','030803008',1,'admin',NULL,NULL,'2024-05-31 00:06:55','2024-05-31 00:06:55'),(3701,'BAL','address','address','BLG. P ROMAN SUPER HIGH WAY CUPANG PROPER CITY OF BALANGA BATAAN',1,'admin',NULL,NULL,'2024-05-31 00:06:56','2024-05-31 00:06:56'),(3702,'BAL','zipCode','address','2100',1,'admin',NULL,NULL,'2024-05-31 00:06:56','2024-05-31 00:06:56');

--
-- Table structure for table `tbl_operations_relationship`
--

CREATE TABLE `tbl_operations_relationship` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `op_code` varchar(255) NOT NULL,
  `parent_code` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `node` int(11) DEFAULT NULL,
  `desc` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tbl_operations_relationship_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=883 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_operations_relationship`
--

INSERT INTO `tbl_operations_relationship` VALUES (1,'GRMHC','GRMHC','0','group',1,NULL,'2024-05-02 10:49:26','2024-05-02 10:49:26',0,'Global Reliance Management and Holdings Corp.'),(2,'LVS','LVS','0','branch',1,NULL,'2024-05-02 22:54:56','2024-05-02 22:54:56',0,'LEVISTE'),(3,'BYN','BYN','0','branch',1,NULL,'2024-05-05 17:03:59','2024-05-05 17:03:59',0,'BAYAWAN BRANCH'),(4,'GRMHCBYN','BYN','GRMHC','branch',1,'2024-05-14 07:01:39','2024-05-05 17:04:31','2024-05-13 23:01:39',1,'Global Reliance Management and Holdings Corp. - BAYAWAN BRANCH'),(5,'AJPS','AJPS','0','group',1,NULL,'2024-05-05 17:10:48','2024-05-05 17:10:48',0,'ALLEXITE JEWELRY PAWNSHOP INC.'),(6,'RCTO','RCTO','0','branch',1,NULL,'2024-05-05 17:16:14','2024-05-05 17:16:14',0,'RECTO BRANCH'),(7,'AJPSRCTO','RCTO','AJPS','branch',1,NULL,'2024-05-05 17:16:43','2024-05-05 17:27:10',1,'ALLEXITE JEWELRY PAWNSHOP INC. - RECTO BRANCH'),(8,'KAPS','KAPS','0','group',1,NULL,'2024-05-05 17:24:39','2024-05-05 17:24:39',0,'KING-ASIA GROUP PAWNSHOP INC.'),(9,'11A','11A','0','branch',1,NULL,'2024-05-05 17:28:43','2024-05-05 17:28:43',0,'11TH AVE BRANCH'),(10,'KAPS11A','11A','KAPS','branch',1,NULL,'2024-05-05 17:29:37','2024-05-05 17:29:37',1,'KING-ASIA GROUP PAWNSHOP INC. - 11TH AVE BRANCH'),(11,'YEPI','YEPI','0','group',1,NULL,'2024-05-05 17:33:43','2024-05-05 17:33:43',0,'YELLOW ENDURANCE PAWNSHOP INC.'),(12,'STZP','STZP','0','branch',1,NULL,'2024-05-05 17:36:35','2024-05-05 17:36:35',0,'STA.CRUZ BRANCH'),(13,'YEPISTZP','STZP','YEPI','branch',1,NULL,'2024-05-05 17:37:23','2024-05-05 17:37:23',1,'YELLOW ENDURANCE PAWNSHOP INC. - STA.CRUZ BRANCH'),(14,'MLA','MLA','0','branch',1,NULL,'2024-05-05 17:45:28','2024-05-05 17:45:28',0,'MALINTA BRANCH'),(15,'YEPIMLA','MLA','YEPI','branch',1,NULL,'2024-05-05 17:45:53','2024-05-05 17:45:53',1,'YELLOW ENDURANCE PAWNSHOP INC. - MALINTA BRANCH'),(16,'VLA','VLA','0','branch',1,NULL,'2024-05-07 16:20:20','2024-05-07 16:20:20',0,'V.LUNA BRANCH'),(17,'WPL','WPL','0','branch',1,NULL,'2024-05-07 16:29:46','2024-05-07 16:29:46',0,'WALTERMART PLARIDEL'),(18,'WLA','WLA','0','branch',1,NULL,'2024-05-07 16:36:34','2024-05-07 16:36:34',0,'WALLA'),(19,'VLZ','VLZ','0','branch',1,NULL,'2024-05-07 16:43:18','2024-05-07 16:43:18',0,'VELASQUEZ'),(20,'VPC','VPC','0','branch',1,NULL,'2024-05-07 16:58:15','2024-05-07 16:58:15',0,'VISPAC BRANCH'),(21,'TMG','TMG','0','branch',1,NULL,'2024-05-07 17:01:22','2024-05-07 17:01:22',0,'TIMOG BRANCH'),(22,'SPI','SPI','0','group',1,NULL,'2024-05-07 21:12:44','2024-05-07 21:12:44',0,'SUREPLEDGE PAWNSHOP INC.'),(23,'YEPITMG','TMG','YEPI','branch',1,NULL,'2024-05-07 21:13:04','2024-05-07 21:13:04',1,'YELLOW ENDURANCE PAWNSHOP INC. - TIMOG BRANCH'),(24,'YEPIVLA','VLA','YEPI','branch',1,NULL,'2024-05-07 21:13:25','2024-05-07 21:13:25',1,'YELLOW ENDURANCE PAWNSHOP INC. - V.LUNA BRANCH'),(25,'YEPIVLZ','VLZ','YEPI','branch',1,NULL,'2024-05-07 21:13:41','2024-05-07 21:13:41',1,'YELLOW ENDURANCE PAWNSHOP INC. - VELASQUEZ BRANCH'),(26,'YEPIVPC','VPC','YEPI','branch',1,NULL,'2024-05-07 21:13:56','2024-05-07 21:13:56',1,'YELLOW ENDURANCE PAWNSHOP INC. - VISPAC BRANCH'),(27,'YEPIWLA','WLA','YEPI','branch',1,NULL,'2024-05-07 21:14:11','2024-05-07 21:14:11',1,'YELLOW ENDURANCE PAWNSHOP INC. - WALLA BRANCH'),(28,'YEPIWPL','WPL','YEPI','branch',1,NULL,'2024-05-07 21:14:27','2024-05-07 21:14:27',1,'YELLOW ENDURANCE PAWNSHOP INC. - WALTERMART PLARIDEL'),(29,'PNB','PNB','0','branch',1,NULL,'2024-05-07 21:16:50','2024-05-07 21:16:50',0,'PINAGBUHATAN BRANCH'),(30,'SPIPNB','PNB','SPI','branch',1,'2024-05-08 06:51:56','2024-05-07 21:17:11','2024-05-07 22:51:56',1,'SUREPLEDGE PAWNSHOP INC. - PINAGBUHATAN BRANCH'),(31,'ANP','ANP','0','branch',1,NULL,'2024-05-07 22:41:14','2024-05-07 22:41:14',0,'ANNAPOLIS BRANCH'),(32,'ANS','ANS','0','branch',1,NULL,'2024-05-07 22:44:50','2024-05-07 22:44:50',0,'ANONAS'),(33,'SPIANP','ANP','SPI','branch',1,'2024-05-08 06:52:15','2024-05-07 22:46:06','2024-05-07 22:52:15',1,'SUREPLEDGE PAWNSHOP INC. - ANNAPOLIS BRANCH'),(34,'SPIANS','ANS','SPI','branch',1,'2024-05-08 06:52:05','2024-05-07 22:46:20','2024-05-07 22:52:05',1,'SUREPLEDGE PAWNSHOP INC. - ANONAS'),(35,'SPPI','SPPI','0','group',1,NULL,'2024-05-07 22:53:06','2024-05-07 22:53:06',0,'SUREPLEDGE PAWNSHOP INC.'),(36,'SPPIANP','ANP','SPPI','branch',1,NULL,'2024-05-07 22:53:55','2024-05-07 22:53:55',1,'SUREPLEDGE PAWNSHOP INC. - ANNAPOLIS BRANCH'),(37,'ASPI','ASPI','0','group',1,NULL,'2024-05-07 23:25:41','2024-05-07 23:25:41',0,'ASIAPHIL STAR PAWNSHOP INC.'),(38,'TQH','TQH','0','branch',1,NULL,'2024-05-07 23:31:08','2024-05-07 23:31:08',0,'ORTIGAS BRANCH'),(39,'ASPITQH','TQH','ASPI','branch',1,NULL,'2024-05-07 23:32:29','2024-05-07 23:32:29',1,'ASIAPHIL STAR PAWNSHOP INC. - ORTIGAS BRANCH'),(40,'KKPI','KKPI','0','group',1,NULL,'2024-05-07 23:36:54','2024-05-07 23:36:54',0,'KRYPTON KNIGHT PAWNSHOP INC.'),(41,'BLR2','BLR2','0','branch',1,NULL,'2024-05-07 23:40:09','2024-05-07 23:40:09',0,'BALER 2 BRANCH'),(42,'KKPIBLR2','BLR2','KKPI','branch',1,NULL,'2024-05-07 23:40:54','2024-05-07 23:40:54',1,'KRYPTON KNIGHT PAWNSHOP INC. - BALER 2 BRANCH'),(43,'TIA','TIA','0','branch',1,NULL,'2024-05-07 23:45:50','2024-05-07 23:45:50',0,'TIAONG BRANCH'),(44,'UAPI','UAPI','0','group',1,NULL,'2024-05-07 23:49:18','2024-05-07 23:49:18',0,'UNIWORLD ASIA PAWNSHOP INC.'),(45,'TSM','TSM','0','branch',1,NULL,'2024-05-07 23:50:15','2024-05-07 23:50:15',0,'TINA BRANCH'),(46,'LP2`','LP2`','0','branch',1,NULL,'2024-05-07 23:54:08','2024-05-07 23:54:08',0,'LIPA 2 BRANCH'),(47,'UAPILP2`','LP2`','UAPI','branch',1,NULL,'2024-05-07 23:54:45','2024-05-07 23:54:45',1,'UNIWORLD ASIA PAWNSHOP INC. - LIPA 2 BRANCH'),(48,'GRMH','GRMH','0','group',1,NULL,'2024-05-08 00:03:05','2024-05-08 00:03:05',0,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP.'),(49,'BCY2','BCY2','0','branch',1,NULL,'2024-05-08 00:16:54','2024-05-08 00:16:54',0,'BORACAY 2 BRANCH'),(50,'PHSE11','PHSE11','0','branch',1,NULL,'2024-05-08 00:22:08','2024-05-08 00:22:08',0,'PHASE 11 BRANCH'),(53,'BNG','BNG','0','branch',1,NULL,'2024-05-08 00:37:29','2024-05-08 00:37:29',0,'BAUANG'),(54,'SFDO L.U.','SFDO L.U.','0','branch',1,NULL,'2024-05-08 00:41:54','2024-05-08 00:41:54',0,'SAN FERNANDO PC BRANCH'),(55,'LGN','LGN','0','branch',1,NULL,'2024-05-08 00:47:57','2024-05-08 00:47:57',0,'LINGAYEN BRANCH'),(56,'HNBN','HNBN','0','branch',1,NULL,'2024-05-08 00:52:42','2024-05-08 00:52:42',0,'HINOBAAN BRANCH'),(57,'SSSPI','SSSPI','0','group',1,NULL,'2024-05-08 18:27:06','2024-05-08 18:27:06',0,'SAN SEBASTIAN SILVER PAWNSHOP INC.'),(58,'SBPI','SBPI','0','group',1,NULL,'2024-05-08 18:28:53','2024-05-08 18:28:53',0,'SAINT BARBARA PRIME PAWNSHOP INC.'),(59,'NWPI','NWPI','0','group',1,NULL,'2024-05-08 18:30:39','2024-05-08 18:30:39',0,'NORTH WESTERN PACIFIC PAWNSHOP INC.'),(60,'SRPI','SRPI','0','group',1,NULL,'2024-05-08 18:32:41','2024-05-08 18:32:41',0,'SAN RAMON PLATINUM PAWNSHOP INC'),(64,'UQK','UQK','0','branch',1,NULL,'2024-05-08 21:55:30','2024-05-08 21:55:30',0,'APARRI 2 BRANCH'),(72,'MMPI','MMPI','0','group',1,NULL,'2024-05-09 16:40:04','2024-05-09 16:40:04',0,'MONEYMAX PAWNSHOP INC.'),(73,'GTD','GTD','0','branch',1,NULL,'2024-05-09 16:44:10','2024-05-09 16:44:10',0,'GASTAMBIDE 2'),(74,'MMPIGTD','GTD','MMPI','branch',1,NULL,'2024-05-09 16:45:00','2024-05-09 16:45:00',1,'MONEYMAX PAWNSHOP INC. - GASTAMBIDE 2'),(75,'SRMD','SRMD','0','group',1,NULL,'2024-05-09 16:51:28','2024-05-09 16:51:28',0,'SIERRA MADRE'),(76,'GAPI','GAPI','0','group',1,NULL,'2024-05-09 16:54:16','2024-05-09 16:54:16',0,'GOLDSTAR ATLANTIC PAWNSHOP INC'),(77,'KGPI','KGPI','0','group',1,NULL,'2024-05-09 17:00:21','2024-05-09 17:00:21',0,'KRISTAL CLEAR DIAMOND & GOLD PAWNSHOP INC.'),(78,'GJPI','GJPI','0','group',1,NULL,'2024-05-09 17:01:38','2024-05-09 17:01:38',0,'GREEN AMBER JEWELRY AND PAWNSHOP INC.'),(79,'SRRM','SRRM','0','branch',1,NULL,'2024-05-09 17:17:39','2024-05-09 17:17:39',0,'SIERRA MADRE'),(80,'PMPI','PMPI','0','group',1,NULL,'2024-05-09 17:21:33','2024-05-09 17:21:33',0,'PACIFIC METROSTAR PAWNSHOP INC'),(81,'BRT1','BRT1','0','branch',1,NULL,'2024-05-09 17:26:12','2024-05-09 17:26:12',0,'BARRETTO 1'),(82,'KBW','KBW','0','branch',1,NULL,'2024-05-09 17:53:19','2024-05-09 17:53:19',0,'KIBAWE BRANCH'),(83,'GOA','GOA','0','branch',1,NULL,'2024-05-09 18:46:01','2024-05-09 18:46:01',0,'GOA BRANCH'),(88,'SCS','SCS','0','branch',1,NULL,'2024-05-09 20:05:54','2024-05-09 20:05:54',0,'SAN CARLOS BRANCH'),(89,'LTS','LTS','0','branch',1,NULL,'2024-05-09 21:21:18','2024-05-09 21:21:18',0,'LOTUS MALL BRANCH'),(90,'GMZ','GMZ','0','branch',1,NULL,'2024-05-09 21:29:07','2024-05-09 21:29:07',0,'GOMEZ BRANCH'),(91,'KGYN','KGYN','0','branch',1,NULL,'2024-05-09 21:33:21','2024-05-09 21:33:21',0,'KALIGAYAHAN BRANCH'),(92,'LSL','LSL','0','branch',1,NULL,'2024-05-09 21:36:33','2024-05-09 21:36:33',0,'LA SALLE BRANCH'),(93,'PTD','PTD','0','branch',1,NULL,'2024-05-09 21:43:28','2024-05-09 21:43:28',0,'PONTEVEDRA'),(94,'LABO','LABO','0','branch',1,NULL,'2024-05-09 22:49:21','2024-05-09 22:49:21',0,'LABO BRANCH'),(95,'PMPIKBW','KBW','PMPI','branch',1,NULL,'2024-05-09 22:52:43','2024-05-09 22:52:43',1,'PACIFIC METROSTAR PAWNSHOP INC - KIBAWE BRANCH'),(96,'PMPIBRT1','BRT1','PMPI','branch',1,NULL,'2024-05-09 22:53:07','2024-05-09 22:55:31',1,'PACIFIC METROSTAR PAWNSHOP INC - BARRETTO 1'),(97,'PMPILABO','LABO','PMPI','branch',1,NULL,'2024-05-09 22:55:56','2024-05-09 22:55:56',1,'PACIFIC METROSTAR PAWNSHOP INC - LABO BRANCH'),(98,'PMPIGOA','GOA','PMPI','branch',1,NULL,'2024-05-09 22:56:13','2024-05-09 22:56:13',1,'PACIFIC METROSTAR PAWNSHOP INC - GOA BRANCH'),(99,'GAPISRRM','SRRM','GAPI','branch',1,NULL,'2024-05-09 22:56:30','2024-05-09 22:56:30',1,'GOLDSTAR ATLANTIC PAWNSHOP INC - SIERRA MADRE BRANCH'),(100,'CLBG','CLBG','0','branch',1,NULL,'2024-05-09 22:58:19','2024-05-09 22:58:19',0,'CALABANGA BRANCH'),(101,'PMPICLBG','CLBG','PMPI','branch',1,NULL,'2024-05-09 22:58:45','2024-05-09 22:58:45',1,'PACIFIC METROSTAR PAWNSHOP INC - CALABANGA BRANCH'),(102,'CTNN','CTNN','0','branch',1,NULL,'2024-05-09 23:28:34','2024-05-09 23:28:34',0,'CATANUAN BRANCH'),(103,'PMPICTNN','CTNN','PMPI','branch',1,NULL,'2024-05-09 23:28:57','2024-05-09 23:28:57',1,'PACIFIC METROSTAR PAWNSHOP INC - CATANUAN BRANCH'),(104,'LTND','LTND','0','branch',1,NULL,'2024-05-10 00:11:35','2024-05-10 00:11:35',0,'LA TRINIDAD BRANCH'),(105,'PMPILTND','LTND','PMPI','branch',1,NULL,'2024-05-10 00:11:57','2024-05-10 00:11:57',1,'PACIFIC METROSTAR PAWNSHOP INC - LA TRINIDAD BRANCH'),(106,'KBSN','KBSN','0','branch',1,NULL,'2024-05-10 00:18:45','2024-05-10 00:18:45',0,'KABASALAN BRANCH'),(107,'PMPIKBSN','KBSN','PMPI','branch',1,NULL,'2024-05-10 00:21:15','2024-05-10 00:21:15',1,'PACIFIC METROSTAR PAWNSHOP INC - KABASALAN BRANCH'),(108,'KRND','KRND','0','branch',1,NULL,'2024-05-10 00:24:00','2024-05-10 00:24:00',0,'KORONADAL BRANCH'),(109,'PMPIKRND','KRND','PMPI','branch',1,NULL,'2024-05-10 00:24:16','2024-05-10 00:24:16',1,'PACIFIC METROSTAR PAWNSHOP INC - KORONADAL BRANCH'),(110,'PJPI','PJPI','0','group',1,NULL,'2024-05-12 17:35:42','2024-05-12 17:35:42',0,'PRINCESS CUT JEWELRY AND PAWNSHOP INC.'),(112,'BF1','BF1','0','branch',1,NULL,'2024-05-12 17:40:44','2024-05-12 17:40:44',0,'BF HOMES BRANCH'),(113,'PJPIBF1','BF1','PJPI','branch',1,NULL,'2024-05-12 17:41:25','2024-05-12 17:41:25',1,'PRINCESS CUT JEWELRY AND PAWNSHOP INC. - BF HOMES BRANCH'),(114,'AFS','AFS','0','branch',1,NULL,'2024-05-12 18:02:51','2024-05-12 18:02:51',0,'ALFONSO'),(115,'DVO','DVO','0','branch',1,NULL,'2024-05-12 18:06:08','2024-05-12 18:06:08',0,'DAVAO BRANCH'),(116,'SCJ','SCJ','0','branch',1,NULL,'2024-05-12 18:52:01','2024-05-12 18:52:01',0,'STA. CRUZ JOYAS BRANCH'),(117,'PKPI','PKPI','0','group',1,NULL,'2024-05-12 18:58:06','2024-05-12 18:58:06',0,'PUREGOLD KARAT PAWNSHOP INC'),(118,'STM','STM','0','branch',1,NULL,'2024-05-12 18:59:45','2024-05-12 18:59:45',0,'STA. MONICA BRANCH'),(119,'SJPI','SJPI','0','group',1,NULL,'2024-05-12 18:59:47','2024-05-12 18:59:47',0,'SILVERSTAR JEWELRY AND PAWNSHOP INC'),(120,'TBN','TBN','0','branch',1,NULL,'2024-05-12 19:08:31','2024-05-12 19:08:31',0,'TIGBAUAN BRANCH'),(121,'MLY','MLY','0','branch',1,NULL,'2024-05-12 19:11:37','2024-05-12 19:11:37',0,'MALANDAY BRANCH'),(122,'BNN','BNN','0','branch',1,NULL,'2024-05-12 19:15:12','2024-05-12 19:15:12',0,'BENIN BRANCH'),(123,'GZG','GZG','0','branch',1,NULL,'2024-05-12 19:19:18','2024-05-12 19:19:18',0,'GONZAGA BRANCH'),(124,'STAJ','STAJ','0','branch',1,NULL,'2024-05-12 19:22:06','2024-05-12 19:22:06',0,'STA. ANA JOYAS BRANCH'),(125,'MLR','MLR','0','branch',1,NULL,'2024-05-12 19:28:10','2024-05-12 19:28:10',0,'MALARIA BRANCH'),(126,'MLT','MLT','0','branch',1,NULL,'2024-05-12 19:39:33','2024-05-12 19:39:33',0,'MALITA BRANCH'),(127,'GLN','GLN','0','branch',1,NULL,'2024-05-12 19:42:05','2024-05-12 19:42:05',0,'GENERAL LUNA BRANCH'),(128,'AFSO','AFSO','0','branch',1,NULL,'2024-05-12 19:45:23','2024-05-12 19:45:23',0,'ALFONSO BRANCH'),(129,'PLY','PLY','0','branch',1,NULL,'2024-05-12 19:47:11','2024-05-12 19:47:11',0,'PELAYO BRANCH'),(130,'TBO','TBO','0','branch',1,NULL,'2024-05-12 21:10:24','2024-05-12 21:10:24',0,'TIBUNGCO BRANCH'),(131,'SLY','SLY','0','branch',1,NULL,'2024-05-12 21:16:50','2024-05-12 21:16:50',0,'SILAY BRANCH'),(132,'ELE','ELE','0','branch',1,NULL,'2024-05-12 21:20:29','2024-05-12 21:20:29',0,'ESCALANTE BRANCH'),(133,'PSI','PSI','0','branch',1,NULL,'2024-05-12 21:25:00','2024-05-12 21:25:00',0,'PASSI BRANCH'),(134,'AGY','AGY','0','branch',1,NULL,'2024-05-12 21:25:12','2024-05-12 21:25:12',0,'ARINGAY'),(135,'VTS','VTS','0','branch',1,NULL,'2024-05-12 21:29:34','2024-05-12 21:29:34',0,'VICTORIAS BRANCH'),(136,'TJO','TJO','0','branch',1,NULL,'2024-05-12 21:35:02','2024-05-12 21:35:02',0,'TEJERO BRANCH'),(137,'AVD','AVD','0','branch',1,NULL,'2024-05-12 21:44:40','2024-05-12 21:44:40',0,'AVENIDA BRANCH'),(138,'JRD','JRD','0','branch',1,NULL,'2024-05-12 21:45:04','2024-05-12 21:45:04',0,'JORDAN BRANCH'),(139,'MUS','MUS','0','branch',1,NULL,'2024-05-12 21:51:32','2024-05-12 21:51:32',0,'MARULAS BRANCH'),(140,'SJDM','SJDM','0','branch',1,NULL,'2024-05-12 21:57:08','2024-05-12 21:57:08',0,'STARMALL SJDM BRANCH'),(141,'BGYN','BGYN','0','branch',1,NULL,'2024-05-12 22:28:56','2024-05-12 22:28:56',0,'BAGUMBAYAN BRANCH'),(142,'SML','SML','0','branch',1,NULL,'2024-05-12 22:35:01','2024-05-12 22:35:01',0,'SOLIS MANILA'),(143,'CNND','CNND','0','branch',1,NULL,'2024-05-12 22:58:02','2024-05-12 22:58:02',0,'CANONADE BRANCH'),(144,'PMPICNND','CNND','PMPI','branch',1,NULL,'2024-05-12 22:58:21','2024-05-12 22:58:21',1,'PACIFIC METROSTAR PAWNSHOP INC - CANONADE BRANCH'),(145,'GNMR','GNMR','0','branch',1,NULL,'2024-05-12 23:06:06','2024-05-12 23:06:06',0,'GENMAR BRANCH'),(146,'PMPIGNMR','GNMR','PMPI','branch',1,NULL,'2024-05-12 23:06:24','2024-05-12 23:06:24',1,'PACIFIC METROSTAR PAWNSHOP INC - GENMAR BRANCH'),(147,'DGS 2','DGS 2','0','branch',1,NULL,'2024-05-12 23:46:43','2024-05-12 23:46:43',0,'DIGOS 2 BRANCH'),(148,'SBA','SBA','0','branch',1,NULL,'2024-05-12 23:52:08','2024-05-12 23:52:08',0,'STA. BARBARA'),(149,'PRS','PRS','0','branch',1,NULL,'2024-05-12 23:54:50','2024-05-12 23:54:50',0,'PRES. ROXAS'),(150,'BRGS','BRGS','0','branch',1,NULL,'2024-05-12 23:56:08','2024-05-12 23:56:08',0,'BURGOS BRANCH'),(151,'PMPIBRGS','BRGS','PMPI','branch',1,NULL,'2024-05-12 23:56:25','2024-05-12 23:56:25',1,'PACIFIC METROSTAR PAWNSHOP INC - BURGOS BRANCH'),(152,'LBO','LBO','0','branch',1,NULL,'2024-05-12 23:57:24','2024-05-12 23:57:24',0,'LAMBUNAO'),(153,'VLY','VLY','0','branch',1,NULL,'2024-05-13 00:20:08','2024-05-13 00:20:08',0,'VICTORY LEMERY BRANCH'),(154,'PCA','PCA','0','branch',1,NULL,'2024-05-13 00:23:58','2024-05-13 00:23:58',0,'POCA BRANCH'),(155,'ZBE','ZBE','0','branch',1,NULL,'2024-05-13 00:29:32','2024-05-13 00:29:32',0,'ZABARTE MALL BRANCH'),(159,'GRMHAFSO','AFSO','GRMH','branch',1,NULL,'2024-05-13 17:02:08','2024-05-14 17:16:29',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - ALFONSO BRANCH'),(161,'GRMHAGY','AGY','GRMH','branch',1,NULL,'2024-05-13 17:05:21','2024-05-13 18:41:47',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - ARINGAY BRANCH'),(165,'GRMHBNG','BNG','GRMH','branch',1,NULL,'2024-05-13 17:08:26','2024-05-13 18:44:23',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - BAUANG BRANCH'),(166,'GRMHBNN','BNN','GRMH','branch',1,NULL,'2024-05-13 17:08:54','2024-05-13 18:44:40',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - BENIN BRANCH'),(200,'GRMH11A','11A','GRMH','branch',1,NULL,'2024-05-13 22:52:55','2024-05-14 17:15:42',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - 11TH AVE BRANCH'),(201,'WCPI','WCPI','0','group',1,NULL,'2024-05-14 17:03:32','2024-05-14 17:03:32',0,'WORLDCREST PAWNSHOP INC.'),(202,'IMB','IMB','0','branch',1,NULL,'2024-05-14 17:07:41','2024-05-14 17:07:41',0,'IMALL BRANCH'),(203,'WCPIIMB','IMB','WCPI','branch',1,'2024-05-15 08:35:45','2024-05-14 17:08:47','2024-05-15 00:35:45',1,'WORLDCREST PAWNSHOP INC. - IMALL BRANCH'),(204,'GRMHAVD','AVD','GRMH','branch',1,NULL,'2024-05-14 17:27:43','2024-05-14 17:27:43',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - AVENIDA BRANCH'),(205,'GRMHCNND','CNND','GRMH','branch',1,NULL,'2024-05-14 17:30:41','2024-05-14 17:30:41',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - CANONADE BRANCH'),(206,'GRMHGNMR','GNMR','GRMH','branch',1,NULL,'2024-05-14 17:33:23','2024-05-14 17:33:23',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - GENMAR BRANCH'),(207,'SLPI','SLPI','0','group',1,NULL,'2024-05-14 17:34:02','2024-05-14 17:34:02',0,'SAFELOCK PAWNSHOP INC.'),(208,'GRMHKGYN','KGYN','GRMH','branch',1,NULL,'2024-05-14 17:34:47','2024-05-14 17:34:47',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - KALIGAYAHAN BRANCH'),(209,'GRMHIMB','IMB','GRMH','branch',1,NULL,'2024-05-14 17:37:47','2024-05-14 17:37:47',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - IMALL BRANCH'),(210,'GRMHLSL','LSL','GRMH','branch',1,NULL,'2024-05-14 17:39:13','2024-05-14 17:39:13',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - LA SALLE BRANCH'),(211,'GRMHLVS','LVS','GRMH','branch',1,'2024-05-22 00:47:26','2024-05-14 17:41:57','2024-05-21 16:47:26',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - LEVISTE BRANCH'),(212,'GRMHLTS','LTS','GRMH','branch',1,NULL,'2024-05-14 17:47:46','2024-05-14 17:47:46',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - LOTUS MALL BRANCH'),(213,'HNPI','HNPI','0','group',1,NULL,'2024-05-14 17:49:42','2024-05-14 17:49:42',0,'HOMENEEDS PAWNSHOP INC.'),(214,'SAPI','SAPI','0','group',1,NULL,'2024-05-14 18:59:32','2024-05-14 18:59:32',0,'SAFELOCK PAWNSHOP INC.'),(215,'MAR','MAR','0','branch',1,NULL,'2024-05-14 19:06:36','2024-05-14 19:06:36',0,'MARCITY BRANCH'),(216,'PNA','PNA','0','branch',1,NULL,'2024-05-14 19:13:15','2024-05-14 19:13:15',0,'PINAGSAMA BRANCH'),(217,'SFI','SFI','0','group',1,NULL,'2024-05-14 19:31:46','2024-05-14 19:31:46',0,'SAFELOCK PAWNSHOP INC.'),(218,'MARC','MARC','0','group',1,NULL,'2024-05-14 19:35:04','2024-05-14 19:35:04',0,'SAFELOCK PAWNSHOP INC.'),(219,'MIA','MIA','0','branch',1,NULL,'2024-05-14 19:51:40','2024-05-14 19:51:40',0,'MARIWASA BRANCH'),(220,'SLPIMIA','MIA','SLPI','branch',1,'2024-05-15 08:26:23','2024-05-14 19:52:31','2024-05-15 00:26:23',1,'SAFELOCK PAWNSHOP INC. - MARIWASA BRANCH'),(221,'KAN','KAN','0','branch',1,NULL,'2024-05-14 20:03:38','2024-05-14 20:03:38',0,'KABANKALAN BRANCH'),(222,'MPB','MPB','0','branch',1,NULL,'2024-05-14 21:03:29','2024-05-14 21:03:29',0,'MANAPLA BRANCH'),(223,'SLPIMPB','MPB','SLPI','branch',1,'2024-05-15 08:26:32','2024-05-14 21:04:24','2024-05-15 00:26:32',1,'SAFELOCK PAWNSHOP INC. - MANAPLA BRANCH'),(224,'SLPIMAR','MAR','SLPI','branch',1,'2024-05-15 08:26:12','2024-05-14 21:05:09','2024-05-15 00:26:12',1,'SAFELOCK PAWNSHOP INC. - MARCITY BRANCH'),(225,'SLPIPNA','PNA','SLPI','branch',1,'2024-05-15 08:27:07','2024-05-14 21:05:42','2024-05-15 00:27:07',1,'SAFELOCK PAWNSHOP INC. - PINAGSAMA BRANCH'),(226,'SLPIMUS','MUS','SLPI','branch',1,'2024-05-15 08:26:43','2024-05-14 21:06:22','2024-05-15 00:26:43',1,'SAFELOCK PAWNSHOP INC. - MARULAS BRANCH'),(227,'SLPIKAN','KAN','SLPI','branch',1,'2024-05-15 08:26:01','2024-05-14 21:09:40','2024-05-15 00:26:01',1,'SAFELOCK PAWNSHOP INC. - KABANKALAN BRANCH'),(228,'PUN','PUN','0','branch',1,NULL,'2024-05-14 21:16:52','2024-05-14 21:16:52',0,'PULILAN BRANCH'),(229,'SLPIPUN','PUN','SLPI','branch',1,'2024-05-15 08:27:16','2024-05-14 21:17:22','2024-05-15 00:27:16',1,'SAFELOCK PAWNSHOP INC. - PULILAN BRANCH'),(230,'PLB','PLB','0','branch',1,NULL,'2024-05-14 21:24:15','2024-05-14 21:24:15',0,'PIOVAL BRANCH'),(231,'SLPIPLB','PLB','SLPI','branch',1,'2024-05-15 08:27:00','2024-05-14 21:24:51','2024-05-15 00:27:00',1,'SAFELOCK PAWNSHOP INC. - PIOVAL BRANCH'),(232,'PAB','PAB','0','branch',1,NULL,'2024-05-14 21:36:01','2024-05-14 21:36:01',0,'PALA-PALA BRANCH'),(233,'SLPIPAB','PAB','SLPI','branch',1,'2024-05-15 08:26:52','2024-05-14 21:36:57','2024-05-15 00:26:52',1,'SAFELOCK PAWNSHOP INC. - PALA-PALA BRANCH'),(234,'CTB','CTB','0','branch',1,NULL,'2024-05-14 21:44:26','2024-05-14 21:44:26',0,'CHESTNUT 2 BRANCH'),(235,'SLPICTB','CTB','SLPI','branch',1,'2024-05-15 08:25:51','2024-05-14 21:44:54','2024-05-15 00:25:51',1,'SAFELOCK PAWNSHOP INC. - CHESTNUT 2 BRANCH'),(236,'THB','THB','0','branch',1,NULL,'2024-05-14 21:50:04','2024-05-14 21:50:04',0,'20TH BRANCH'),(237,'SLPITHB','THB','SLPI','branch',1,'2024-05-15 08:24:26','2024-05-14 21:50:34','2024-05-15 00:24:26',1,'SAFELOCK PAWNSHOP INC. - 20TH BRANCH'),(238,'WPI','WPI','0','group',1,NULL,'2024-05-14 21:52:16','2024-05-14 21:52:16',0,'WORLDCREST PAWNSHOP INC.'),(239,'LEV','LEV','0','branch',1,NULL,'2024-05-14 21:59:49','2024-05-14 21:59:49',0,'LEVISTE BRANCH'),(240,'WCPILEV','LEV','WCPI','branch',1,'2024-05-15 08:36:00','2024-05-14 22:00:24','2024-05-15 00:36:00',1,'WORLDCREST PAWNSHOP INC. - LEVISTE BRANCH'),(241,'ROS','ROS','0','branch',1,NULL,'2024-05-14 22:12:17','2024-05-14 22:12:17',0,'ROSARIO'),(242,'WCPIROS','ROS','WCPI','branch',1,'2024-05-15 08:36:18','2024-05-14 22:13:08','2024-05-15 00:36:18',1,'WORLDCREST PAWNSHOP INC. - ROSARIO'),(243,'ALB','ALB','0','branch',1,NULL,'2024-05-14 22:19:45','2024-05-14 22:19:45',0,'IMALL BRANCH'),(244,'WCPIALB','ALB','WCPI','branch',1,'2024-05-15 08:32:58','2024-05-14 22:20:16','2024-05-15 00:32:58',1,'WORLDCREST PAWNSHOP INC. - IMALL BRANCH'),(245,'TMA','TMA','0','branch',1,NULL,'2024-05-14 22:26:42','2024-05-14 22:26:42',0,'TUNGKONG BRANCH'),(246,'WCPITMA','TMA','WCPI','branch',1,'2024-05-15 08:37:38','2024-05-14 22:27:05','2024-05-15 00:37:38',1,'WORLDCREST PAWNSHOP INC. - TUNGKONG BRANCH'),(247,'BIN','BIN','0','branch',1,NULL,'2024-05-14 22:30:44','2024-05-14 22:30:44',0,'BINAKAYAN BRANCH'),(248,'WCPIBIN','BIN','WCPI','branch',1,'2024-05-15 08:33:45','2024-05-14 22:31:08','2024-05-15 00:33:45',1,'WORLDCREST PAWNSHOP INC. - BINAKAYAN BRANCH'),(249,'FOB','FOB','0','branch',1,NULL,'2024-05-14 22:35:21','2024-05-14 22:35:21',0,'FAJARDO BRANCH'),(250,'WCPIFOB','FOB','WCPI','branch',1,'2024-05-15 08:34:38','2024-05-14 22:35:45','2024-05-15 00:34:38',1,'WORLDCREST PAWNSHOP INC. - FAJARDO BRANCH'),(251,'TEB','TEB','0','branch',1,NULL,'2024-05-14 22:41:38','2024-05-14 22:41:38',0,'TEJERON BRANCH'),(252,'WCPITEB','TEB','WCPI','branch',1,'2024-05-15 08:37:22','2024-05-14 22:42:03','2024-05-15 00:37:22',1,'WORLDCREST PAWNSHOP INC. - TEJERON BRANCH'),(253,'UAW','UAW','0','branch',1,NULL,'2024-05-14 22:48:22','2024-05-14 22:48:22',0,'URDANETA NEW BRANCH'),(254,'WCPIUAW','UAW','WCPI','branch',1,'2024-05-15 08:37:52','2024-05-14 22:48:47','2024-05-15 00:37:52',1,'WORLDCREST PAWNSHOP INC. - URDANETA NEW BRANCH'),(255,'ECO','ECO','0','branch',1,NULL,'2024-05-14 22:52:21','2024-05-14 22:52:21',0,'EDSA CUBAO BRANCH'),(256,'WCPIECO','ECO','WCPI','branch',1,'2024-05-15 08:34:11','2024-05-14 22:52:57','2024-05-15 00:34:11',1,'WORLDCREST PAWNSHOP INC. - EDSA CUBAO BRANCH'),(257,'SFB','SFB','0','branch',1,NULL,'2024-05-14 23:01:42','2024-05-14 23:01:42',0,'SAN FERNANDO BRANCH'),(258,'WCPISFB','SFB','WCPI','branch',1,'2024-05-15 08:36:33','2024-05-14 23:02:15','2024-05-15 00:36:33',1,'WORLDCREST PAWNSHOP INC. - SAN FERNANDO BRANCH'),(259,'SGB','SGB','0','branch',1,NULL,'2024-05-14 23:07:19','2024-05-14 23:07:19',0,'SAGUIN BRANCH'),(260,'WCPISGB','SGB','WCPI','branch',1,'2024-05-15 08:36:48','2024-05-14 23:07:41','2024-05-15 00:36:48',1,'WORLDCREST PAWNSHOP INC. - SAGUIN BRANCH'),(261,'STS','STS','0','branch',1,NULL,'2024-05-14 23:12:11','2024-05-14 23:12:11',0,'STO. TOMAS BRANCH'),(262,'WCPISTS','STS','WCPI','branch',1,'2024-05-15 08:37:06','2024-05-14 23:12:33','2024-05-15 00:37:06',1,'WORLDCREST PAWNSHOP INC. - STO. TOMAS BRANCH'),(263,'HNI','HNI','0','group',1,NULL,'2024-05-14 23:14:44','2024-05-14 23:14:44',0,'HOMENEEDS PAWNSHOP INC.'),(264,'MAY','MAY','0','branch',1,NULL,'2024-05-14 23:18:35','2024-05-14 23:18:35',0,'MAYAMOT BRANCH'),(265,'HNIMAY','MAY','HNI','branch',1,NULL,'2024-05-14 23:19:01','2024-05-14 23:19:01',1,'HOMENEEDS PAWNSHOP INC. - MAYAMOT BRANCH'),(266,'REG','REG','0','branch',1,NULL,'2024-05-14 23:23:20','2024-05-14 23:23:20',0,'REGALADO BRANCH'),(267,'HNIREG','REG','HNI','branch',1,NULL,'2024-05-14 23:23:52','2024-05-14 23:23:52',1,'HOMENEEDS PAWNSHOP INC. - REGALADO BRANCH'),(268,'HAS','HAS','0','branch',1,NULL,'2024-05-14 23:27:52','2024-05-14 23:27:52',0,'HARRIPASS BRANCH'),(269,'HNIHAS','HAS','HNI','branch',1,NULL,'2024-05-14 23:28:17','2024-05-14 23:28:17',1,'HOMENEEDS PAWNSHOP INC. - HARRIPASS BRANCH'),(270,'SOL','SOL','0','branch',1,NULL,'2024-05-14 23:37:28','2024-05-14 23:37:28',0,'SOLOMIO BRANCH'),(271,'HNISOL','SOL','HNI','branch',1,NULL,'2024-05-14 23:37:51','2024-05-14 23:37:51',1,'HOMENEEDS PAWNSHOP INC. - SOLOMIO BRANCH'),(272,'MAB','MAB','0','branch',1,NULL,'2024-05-14 23:41:14','2024-05-14 23:41:14',0,'MAYOMBO BRANCH'),(273,'HNIMAB','MAB','HNI','branch',1,NULL,'2024-05-14 23:41:38','2024-05-14 23:41:38',1,'HOMENEEDS PAWNSHOP INC. - MAYOMBO BRANCH'),(274,'ESW','ESW','0','branch',1,NULL,'2024-05-14 23:44:30','2024-05-14 23:44:30',0,'EARNSHAW BRANCH'),(275,'HNIESW','ESW','HNI','branch',1,NULL,'2024-05-14 23:44:55','2024-05-14 23:44:55',1,'HOMENEEDS PAWNSHOP INC. - EARNSHAW BRANCH'),(276,'EMA','EMA','0','branch',1,NULL,'2024-05-14 23:49:41','2024-05-14 23:49:41',0,'E-MALL BRANCH'),(277,'HNIEMA','EMA','HNI','branch',1,NULL,'2024-05-14 23:50:09','2024-05-14 23:50:09',1,'HOMENEEDS PAWNSHOP INC. - E-MALL BRANCH'),(278,'SAB','SAB','0','branch',1,NULL,'2024-05-14 23:55:37','2024-05-14 23:55:37',0,'SAN JUAN BRANCH'),(279,'HNISAB','SAB','HNI','branch',1,NULL,'2024-05-14 23:56:00','2024-05-14 23:56:00',1,'HOMENEEDS PAWNSHOP INC. - SAN JUAN BRANCH'),(280,'FIN','FIN','0','branch',1,NULL,'2024-05-14 23:59:50','2024-05-14 23:59:50',0,'FINCA BRANCH'),(281,'HNIFIN','FIN','HNI','branch',1,NULL,'2024-05-15 00:00:11','2024-05-15 00:00:11',1,'HOMENEEDS PAWNSHOP INC. - FINCA BRANCH'),(282,'EXB','EXB','0','branch',1,NULL,'2024-05-15 00:10:45','2024-05-15 00:10:45',0,'EXCOM BRANCH'),(283,'HNIEXB','EXB','HNI','branch',1,NULL,'2024-05-15 00:11:14','2024-05-15 00:11:14',1,'HOMENEEDS PAWNSHOP INC. - EXCOM BRANCH'),(284,'SELK','SELK','0','group',1,NULL,'2024-05-15 00:47:05','2024-05-15 00:47:05',0,'SAFELOCK PAWNSHOP INC.'),(285,'WCTP','WCTP','0','group',1,NULL,'2024-05-15 00:49:06','2024-05-15 00:49:06',0,'WORLDCREST PAWNSHOP INC.'),(286,'SELKMAR','MAR','SELK','branch',1,NULL,'2024-05-15 00:49:29','2024-05-15 00:49:29',1,'SAFELOCK PAWNSHOP INC. - MARCITY BRANCH'),(287,'SELKPNA','PNA','SELK','branch',1,NULL,'2024-05-15 00:55:27','2024-05-15 00:55:27',1,'SAFELOCK PAWNSHOP INC. - PINAGSAMA BRANCH'),(288,'SELKMUS','MUS','SELK','branch',1,NULL,'2024-05-15 00:55:58','2024-05-15 00:55:58',1,'SAFELOCK PAWNSHOP INC. - MARULAS BRANCH'),(289,'SELKMIA','MIA','SELK','branch',1,NULL,'2024-05-15 00:58:00','2024-05-15 00:58:00',1,'SAFELOCK PAWNSHOP INC. - MARIWASA BRANCH'),(290,'SELKKAN','KAN','SELK','branch',1,NULL,'2024-05-15 00:58:34','2024-05-15 00:58:34',1,'SAFELOCK PAWNSHOP INC. - KABANKALAN BRANCH'),(291,'SELKMPB','MPB','SELK','branch',1,NULL,'2024-05-15 00:59:07','2024-05-15 00:59:07',1,'SAFELOCK PAWNSHOP INC. - MANAPLA BRANCH'),(292,'SELKPUN','PUN','SELK','branch',1,NULL,'2024-05-15 00:59:30','2024-05-15 00:59:30',1,'SAFELOCK PAWNSHOP INC. - PULILAN BRANCH'),(293,'SELKPLB','PLB','SELK','branch',1,NULL,'2024-05-15 01:00:06','2024-05-15 01:00:06',1,'SAFELOCK PAWNSHOP INC. - PIOVAL BRANCH'),(294,'SELKPAB','PAB','SELK','branch',1,NULL,'2024-05-15 01:00:36','2024-05-15 01:00:36',1,'SAFELOCK PAWNSHOP INC. - PALA-PALA BRANCH'),(295,'SELKCTB','CTB','SELK','branch',1,NULL,'2024-05-15 01:01:07','2024-05-15 01:01:07',1,'SAFELOCK PAWNSHOP INC. - CHESTNUT 2 BRANCH'),(296,'SELKTHB','THB','SELK','branch',1,NULL,'2024-05-15 01:01:30','2024-05-15 01:01:30',1,'SAFELOCK PAWNSHOP INC. - 20TH BRANCH'),(297,'WCTPLEV','LEV','WCTP','branch',1,NULL,'2024-05-15 01:08:06','2024-05-15 01:08:06',1,'WORLDCREST PAWNSHOP INC. - LEVISTE BRANCH'),(298,'WCTPROS','ROS','WCTP','branch',1,NULL,'2024-05-15 01:09:42','2024-05-15 01:09:42',1,'WORLDCREST PAWNSHOP INC. - ROSARIO BRANCH'),(299,'WCTPALB','ALB','WCTP','branch',1,NULL,'2024-05-15 01:13:36','2024-05-15 01:13:36',1,'WORLDCREST PAWNSHOP INC. - IMALL BRANCH'),(300,'WCTPTMA','TMA','WCTP','branch',1,NULL,'2024-05-15 01:15:04','2024-05-15 01:15:04',1,'WORLDCREST PAWNSHOP INC. - TUNGKONG MANGGA BRANCH'),(301,'WCTPBIN','BIN','WCTP','branch',1,NULL,'2024-05-15 01:16:13','2024-05-15 01:16:13',1,'WORLDCREST PAWNSHOP INC. - BINAKAYAN 2 BRANCH'),(302,'WCTPFOB','FOB','WCTP','branch',1,NULL,'2024-05-15 01:18:11','2024-05-15 01:18:11',1,'WORLDCREST PAWNSHOP INC. - FAJARDO 2 BRANCH'),(303,'WCTPTEB','TEB','WCTP','branch',1,NULL,'2024-05-15 01:19:34','2024-05-15 01:19:34',1,'WORLDCREST PAWNSHOP INC. - TEJERON NEW BRANCH'),(304,'WCTPUAW','UAW','WCTP','branch',1,NULL,'2024-05-15 01:20:36','2024-05-15 01:20:36',1,'WORLDCREST PAWNSHOP INC. - URDANETA NEW BRANCH'),(305,'WCTPSFB','SFB','WCTP','branch',1,NULL,'2024-05-15 01:22:12','2024-05-15 01:22:12',1,'WORLDCREST PAWNSHOP INC. - SAN FERNANDO BRANCH'),(306,'WCTPSGB','SGB','WCTP','branch',1,'2024-05-27 05:42:39','2024-05-15 01:22:41','2024-05-26 21:42:39',1,'WORLDCREST PAWNSHOP INC. - SAGUIN BRANCH'),(307,'WCTPSTS','STS','WCTP','branch',1,NULL,'2024-05-15 01:24:14','2024-05-15 01:24:14',1,'WORLDCREST PAWNSHOP INC. - STO. TOMAS 3 BRANCH'),(308,'GNTB','GNTB','0','branch',1,NULL,'2024-05-16 18:48:56','2024-05-16 18:48:56',0,'GEN.T BRANCH'),(309,'PMPIGNTB','GNTB','PMPI','branch',1,NULL,'2024-05-16 18:49:51','2024-05-16 18:49:51',1,'PACIFIC METROSTAR PAWNSHOP INC - GEN.T BRANCH'),(310,'LCBN','LCBN','0','branch',1,NULL,'2024-05-16 18:55:59','2024-05-16 18:55:59',0,'LUCBAN BRANCH'),(311,'PMPILCBN','LCBN','PMPI','branch',1,NULL,'2024-05-16 18:56:22','2024-05-16 18:56:22',1,'PACIFIC METROSTAR PAWNSHOP INC - LUCBAN BRANCH'),(312,'CYNB','CYNB','0','branch',1,NULL,'2024-05-16 19:04:17','2024-05-16 19:04:17',0,'CAUAYAN BRANCH'),(313,'PMPICYNB','CYNB','PMPI','branch',1,NULL,'2024-05-16 19:14:27','2024-05-16 19:14:27',1,'PACIFIC METROSTAR PAWNSHOP INC - CAUAYAN BRANCH'),(314,'FSTVM','FSTVM','0','branch',1,NULL,'2024-05-16 21:44:03','2024-05-16 21:44:03',0,'FESTIVAL MALL'),(315,'GAPIFSTVM','FSTVM','GAPI','branch',1,NULL,'2024-05-16 21:44:46','2024-05-16 21:44:46',1,'GOLDSTAR ATLANTIC PAWNSHOP INC - FESTIVAL MALL'),(316,'BHL1','BHL1','0','branch',1,NULL,'2024-05-16 22:20:27','2024-05-16 22:20:27',0,'BOHOL 1'),(317,'GAPIBHL1','BHL1','GAPI','branch',1,NULL,'2024-05-16 22:20:57','2024-05-16 22:20:57',1,'GOLDSTAR ATLANTIC PAWNSHOP INC - BOHOL 1'),(318,'BHL2','BHL2','0','branch',1,NULL,'2024-05-16 22:25:37','2024-05-16 22:25:37',0,'BOHOL 2 BRANCH'),(319,'GAPIBHL2','BHL2','GAPI','branch',1,NULL,'2024-05-16 22:25:54','2024-05-16 22:25:54',1,'GOLDSTAR ATLANTIC PAWNSHOP INC - BOHOL 2 BRANCH'),(320,'TAI','TAI','0','branch',1,NULL,'2024-05-16 23:04:55','2024-05-16 23:04:55',0,'DEPARO BRANCH'),(321,'DMGS','DMGS','0','branch',1,NULL,'2024-05-16 23:13:36','2024-05-16 23:13:36',0,'DUMANGAS BRANCH'),(322,'SCB','SCB','0','branch',1,NULL,'2024-05-16 23:28:19','2024-05-16 23:28:19',0,'SCABO NEW BRANCH'),(323,'SNJA','SNJA','0','branch',1,NULL,'2024-05-16 23:51:55','2024-05-16 23:51:55',0,'SAN JOSE ANTIQUE'),(324,'GAPISNJA','SNJA','GAPI','branch',1,NULL,'2024-05-16 23:52:22','2024-05-16 23:52:22',1,'GOLDSTAR ATLANTIC PAWNSHOP INC - SAN JOSE ANTIQUE'),(325,'PST','PST','0','branch',1,NULL,'2024-05-16 23:55:35','2024-05-16 23:55:35',0,'PESETA BRANCH'),(326,'TNGK2','TNGK2','0','branch',1,NULL,'2024-05-16 23:58:22','2024-05-16 23:58:22',0,'TUNGKO 2 BRANCH'),(327,'GAPITNGK2','TNGK2','GAPI','branch',1,NULL,'2024-05-16 23:58:41','2024-05-16 23:58:41',1,'GOLDSTAR ATLANTIC PAWNSHOP INC - TUNGKO 2 BRANCH'),(328,'AMO','AMO','0','branch',1,NULL,'2024-05-17 00:00:08','2024-05-17 00:00:08',0,'AMADEO BRANCH'),(329,'TRE','TRE','0','branch',1,NULL,'2024-05-17 00:03:05','2024-05-17 00:03:05',0,'STA QUITERIA BRANCH'),(330,'TLS','TLS','0','branch',1,NULL,'2024-05-17 00:08:36','2024-05-17 00:08:36',0,'TALISAY BRANCH'),(331,'URB','URB','0','branch',1,NULL,'2024-05-17 00:12:16','2024-05-17 00:12:16',0,'STARMALL BARNCH'),(332,'BRA1','BRA1','0','branch',1,NULL,'2024-05-17 00:18:28','2024-05-17 00:18:28',0,'BORA I BRANCH'),(333,'SPLY','SPLY','0','branch',1,NULL,'2024-05-17 00:24:03','2024-05-17 00:24:03',0,'SIPALAY BRANCH'),(334,'BNLG','BNLG','0','branch',1,NULL,'2024-05-17 00:27:06','2024-05-17 00:27:06',0,'BINALBAGAN BRANCH'),(335,'SVL','SVL','0','branch',1,NULL,'2024-05-17 00:31:01','2024-05-17 00:31:01',0,'SUNVALLEY BRANCH'),(336,'UUG2','UUG2','0','branch',1,NULL,'2024-05-17 00:33:30','2024-05-17 00:33:30',0,'UGONG 2 BRANCH'),(337,'DLHN','DLHN','0','branch',1,NULL,'2024-05-17 00:36:45','2024-05-17 00:36:45',0,'DALAHICAN BRANCH'),(338,'MLAK','MLAK','0','branch',1,NULL,'2024-05-17 00:40:31','2024-05-17 00:40:31',0,'MALAY AKLAN BRANCH'),(339,'LPA3','LPA3','0','branch',1,NULL,'2024-05-17 00:46:02','2024-05-17 00:46:02',0,'LIPA 3 BRANCH'),(340,'GRMHBNLG','BNLG','GRMH','branch',1,NULL,'2024-05-17 00:47:06','2024-05-17 00:47:06',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - BINALBAGAN BRANCH'),(341,'SLN','SLN','0','branch',1,NULL,'2024-05-17 00:47:54','2024-05-17 00:47:54',0,'SOLANO BRANCH'),(342,'GRMHBRA1','BRA1','GRMH','branch',1,NULL,'2024-05-17 00:48:06','2024-05-17 00:48:06',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - BORA I BRANCH'),(343,'GRMHGNTB','GNTB','GRMH','branch',1,NULL,'2024-05-17 00:51:31','2024-05-17 00:51:31',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - GEN.T BRANCH'),(344,'TGBN','TGBN','0','branch',1,NULL,'2024-05-17 00:53:03','2024-05-17 00:53:03',0,'TAGBINA BRANCH'),(345,'SPCL','SPCL','0','branch',1,NULL,'2024-05-17 17:08:24','2024-05-17 17:08:24',0,'SAN PASCUAL BRANCH'),(346,'WSTF','WSTF','0','branch',1,NULL,'2024-05-17 17:34:00','2024-05-17 17:34:00',0,'WESTAFF BRANCH'),(347,'LBDR','LBDR','0','branch',1,NULL,'2024-05-17 17:42:41','2024-05-17 17:42:41',0,'LOABRADOR BRANCH'),(348,'BLA','BLA','0','branch',1,NULL,'2024-05-17 17:46:12','2024-05-17 17:46:12',0,'BALETE AKLAN BRANCH'),(349,'PSQ','PSQ','0','branch',1,NULL,'2024-05-17 17:50:12','2024-05-17 17:50:12',0,'PASUQUIN BRANCH'),(350,'TLZ','TLZ','0','branch',1,NULL,'2024-05-17 17:52:57','2024-05-17 17:52:57',0,'LA CASTELLANA'),(351,'TCP','TCP','0','branch',1,NULL,'2024-05-17 17:55:38','2024-05-17 17:55:38',0,'LAPANDA BRANCH'),(352,'MLB','MLB','0','branch',1,NULL,'2024-05-17 18:01:30','2024-05-17 18:01:30',0,'MALAY BALAY 1 BRANCH'),(353,'RPB','RPB','0','branch',1,NULL,'2024-05-17 18:05:29','2024-05-17 18:05:29',0,'PANABO 2 BRANCH'),(354,'UOM','UOM','0','branch',1,NULL,'2024-05-17 18:18:47','2024-05-17 18:18:47',0,'POBLACION 2 SAN MIGUEL BRANCH'),(355,'TRW','TRW','0','branch',1,NULL,'2024-05-17 18:21:23','2024-05-17 18:21:23',0,'UGONG 1 BRANCH'),(356,'TOG','TOG','0','branch',1,NULL,'2024-05-17 18:24:09','2024-05-17 18:24:09',0,'DOMAIN BRANCH'),(357,'IBR','IBR','0','branch',1,NULL,'2024-05-17 18:29:47','2024-05-17 18:29:47',0,'IGBARAS BRANCH'),(358,'SPC','SPC','0','branch',1,NULL,'2024-05-17 19:15:37','2024-05-17 19:15:37',0,'SAMPALOC BRANCH'),(359,'FTA','FTA','0','branch',1,NULL,'2024-05-17 19:17:39','2024-05-17 19:17:39',0,'FATIMA BRANCH'),(360,'TPI','TPI','0','branch',1,NULL,'2024-05-17 19:19:52','2024-05-17 19:19:52',0,'TUPI BRANCH'),(361,'PPD','PPD','0','branch',1,NULL,'2024-05-17 19:25:04','2024-05-17 19:25:04',0,'PROSPERIDAD BRANCH'),(362,'LPL','LPL','0','branch',1,NULL,'2024-05-17 19:27:10','2024-05-17 19:27:10',0,'LAUREL BRANCH'),(363,'LIN','LIN','0','branch',1,NULL,'2024-05-17 19:29:21','2024-05-17 19:29:21',0,'LIAN BRANCH'),(364,'PLP','PLP','0','branch',1,NULL,'2024-05-17 19:32:53','2024-05-17 19:32:53',0,'PULANG LUPA BRANCH'),(365,'MBH','MBH','0','branch',1,NULL,'2024-05-17 19:36:34','2024-05-17 19:36:34',0,'MABINI BOHOL BRANCH'),(366,'LP3','LP3','0','branch',1,NULL,'2024-05-17 19:38:48','2024-05-17 19:38:48',0,'LIPA 1 BRANCH'),(367,'GMC','GMC','0','branch',1,NULL,'2024-05-17 19:43:55','2024-05-17 19:43:55',0,'GUMACA BRANCH'),(368,'GMB','GMB','0','branch',1,NULL,'2024-05-17 19:47:24','2024-05-17 19:47:24',0,'GUIMBA BRANCH'),(369,'MHK','MHK','0','branch',1,NULL,'2024-05-17 19:51:40','2024-05-17 19:51:40',0,'MAHARLIKA BRANCH'),(370,'MT1','MT1','0','branch',1,NULL,'2024-05-17 19:59:28','2024-05-17 19:59:28',0,'MATI 1 BRANCH'),(371,'MCO','MCO','0','branch',1,NULL,'2024-05-17 21:40:32','2024-05-17 21:40:32',0,'MACO BRANCH'),(372,'DSD','DSD','0','branch',1,NULL,'2024-05-17 21:43:29','2024-05-17 21:43:29',0,'DOÑA SOLIDAD'),(373,'MTG','MTG','0','branch',1,NULL,'2024-05-17 21:48:27','2024-05-17 21:48:27',0,'METROGATE BRANCH'),(374,'SFO','SFO','0','branch',1,NULL,'2024-05-17 21:51:56','2024-05-17 21:51:56',0,'SAN FRANCISCO BRANCH'),(375,'SLZ','SLZ','0','branch',1,NULL,'2024-05-17 21:54:46','2024-05-17 21:54:46',0,'SAN LORENZO BRANCH'),(376,'SFZ','SFZ','0','branch',1,NULL,'2024-05-17 21:59:50','2024-05-17 21:59:50',0,'SAN FRANZ BRANCH'),(377,'PNB1','PNB1','0','branch',1,NULL,'2024-05-17 22:06:57','2024-05-17 22:06:57',0,'PANABO 1 BRANCH'),(378,'QRN','QRN','0','branch',1,NULL,'2024-05-17 22:09:52','2024-05-17 22:09:52',0,'QUIRINO  BRANCH'),(379,'PRT','PRT','0','branch',1,NULL,'2024-05-17 22:19:04','2024-05-17 22:19:04',0,'PUERTO BRANCH'),(380,'ASPIUQK','UQK','ASPI','branch',1,NULL,'2024-05-17 22:41:20','2024-05-17 22:41:20',1,'ASIAPHIL STAR PAWNSHOP INC. - APARRI 2 BRANCH'),(381,'ASPITAI','TAI','ASPI','branch',1,NULL,'2024-05-17 22:44:36','2024-05-17 22:44:36',1,'ASIAPHIL STAR PAWNSHOP INC. - DEPARO BRANCH'),(382,'ASPIDMGS','DMGS','ASPI','branch',1,NULL,'2024-05-17 22:45:00','2024-05-17 22:45:00',1,'ASIAPHIL STAR PAWNSHOP INC. - DUMANGAS BRANCH'),(383,'ASPISCB','SCB','ASPI','branch',1,NULL,'2024-05-17 22:45:19','2024-05-17 22:45:19',1,'ASIAPHIL STAR PAWNSHOP INC. - SCABO NEW BRANCH'),(384,'ASPIPST','PST','ASPI','branch',1,NULL,'2024-05-17 22:45:42','2024-05-17 22:45:42',1,'ASIAPHIL STAR PAWNSHOP INC. - PESETA BRANCH'),(385,'ASPIAMO','AMO','ASPI','branch',1,NULL,'2024-05-17 22:46:01','2024-05-17 22:46:01',1,'ASIAPHIL STAR PAWNSHOP INC. - AMADEO BRANCH'),(386,'ASPITRE','TRE','ASPI','branch',1,NULL,'2024-05-17 22:46:24','2024-05-17 22:46:24',1,'ASIAPHIL STAR PAWNSHOP INC. - STA QUITERIA BRANCH'),(387,'ASPITLS','TLS','ASPI','branch',1,NULL,'2024-05-17 22:46:44','2024-05-17 22:46:44',1,'ASIAPHIL STAR PAWNSHOP INC. - TALISAY BRANCH'),(388,'ASPIURB','URB','ASPI','branch',1,NULL,'2024-05-17 22:47:22','2024-05-17 22:47:22',1,'ASIAPHIL STAR PAWNSHOP INC. - STARMALL BARNCH'),(389,'TYE','TYE','0','branch',1,NULL,'2024-05-17 22:50:25','2024-05-17 22:50:25',0,'BALITE BRANCH'),(390,'ASPITYE','TYE','ASPI','branch',1,NULL,'2024-05-17 22:50:45','2024-05-17 22:50:45',1,'ASIAPHIL STAR PAWNSHOP INC. - BALITE BRANCH'),(391,'SSSPIBRA1','BRA1','SSSPI','branch',1,NULL,'2024-05-17 22:51:37','2024-05-17 22:51:37',1,'SAN SEBASTIAN SILVER PAWNSHOP INC. - BORA I BRANCH'),(392,'SSSPISPLY','SPLY','SSSPI','branch',1,NULL,'2024-05-17 22:51:59','2024-05-17 22:51:59',1,'SAN SEBASTIAN SILVER PAWNSHOP INC. - SIPALAY BRANCH'),(393,'SSSPIBNLG','BNLG','SSSPI','branch',1,NULL,'2024-05-17 22:52:26','2024-05-17 22:52:26',1,'SAN SEBASTIAN SILVER PAWNSHOP INC. - BINALBAGAN BRANCH'),(394,'SSSPISVL','SVL','SSSPI','branch',1,NULL,'2024-05-17 22:52:50','2024-05-17 22:52:50',1,'SAN SEBASTIAN SILVER PAWNSHOP INC. - SUNVALLEY BRANCH'),(395,'SSSPIUUG2','UUG2','SSSPI','branch',1,NULL,'2024-05-17 22:53:10','2024-05-17 22:53:10',1,'SAN SEBASTIAN SILVER PAWNSHOP INC. - UGONG 2 BRANCH'),(396,'SSSPIDLHN','DLHN','SSSPI','branch',1,NULL,'2024-05-17 22:53:30','2024-05-17 22:53:30',1,'SAN SEBASTIAN SILVER PAWNSHOP INC. - DALAHICAN BRANCH'),(397,'SSSPIMLAK','MLAK','SSSPI','branch',1,NULL,'2024-05-17 22:55:33','2024-05-17 22:55:33',1,'SAN SEBASTIAN SILVER PAWNSHOP INC. - MALAY AKLAN BRANCH'),(398,'SSSPILPA3','LPA3','SSSPI','branch',1,NULL,'2024-05-17 22:55:55','2024-05-17 22:55:55',1,'SAN SEBASTIAN SILVER PAWNSHOP INC. - LIPA 3 BRANCH'),(399,'SSSPISLN','SLN','SSSPI','branch',1,NULL,'2024-05-17 22:56:18','2024-05-17 22:56:18',1,'SAN SEBASTIAN SILVER PAWNSHOP INC. - SOLANO BRANCH'),(400,'SSSPITGBN','TGBN','SSSPI','branch',1,NULL,'2024-05-17 22:56:37','2024-05-17 22:56:37',1,'SAN SEBASTIAN SILVER PAWNSHOP INC. - TAGBINA BRANCH'),(401,'SSSPISPCL','SPCL','SSSPI','branch',1,NULL,'2024-05-17 22:57:01','2024-05-17 22:57:01',1,'SAN SEBASTIAN SILVER PAWNSHOP INC. - SAN PASCUAL BRANCH'),(402,'SSSPIWSTF','WSTF','SSSPI','branch',1,NULL,'2024-05-17 22:57:34','2024-05-17 22:57:34',1,'SAN SEBASTIAN SILVER PAWNSHOP INC. - WESTAFF BRANCH'),(403,'LDR','LDR','0','branch',1,NULL,'2024-05-17 23:04:17','2024-05-17 23:04:17',0,'LABRADOR BRANCH'),(404,'SBPILDR','LDR','SBPI','branch',1,NULL,'2024-05-17 23:05:09','2024-05-17 23:05:09',1,'SAINT BARBARA PRIME PAWNSHOP INC. - LABRADOR BRANCH'),(405,'SBPIBLA','BLA','SBPI','branch',1,NULL,'2024-05-17 23:29:05','2024-05-17 23:29:05',1,'SAINT BARBARA PRIME PAWNSHOP INC. - BALETE AKLAN BRANCH'),(406,'SBPIPSQ','PSQ','SBPI','branch',1,NULL,'2024-05-17 23:29:28','2024-05-17 23:29:28',1,'SAINT BARBARA PRIME PAWNSHOP INC. - PASUQUIN BRANCH'),(407,'SBPITCP','TCP','SBPI','branch',1,NULL,'2024-05-17 23:29:48','2024-05-17 23:29:48',1,'SAINT BARBARA PRIME PAWNSHOP INC. - LAPANDA BRANCH'),(408,'SBPIMLB','MLB','SBPI','branch',1,NULL,'2024-05-17 23:30:08','2024-05-17 23:30:08',1,'SAINT BARBARA PRIME PAWNSHOP INC. - MALAY BALAY 1 BRANCH'),(409,'SBPIRPB','RPB','SBPI','branch',1,NULL,'2024-05-17 23:30:29','2024-05-17 23:30:29',1,'SAINT BARBARA PRIME PAWNSHOP INC. - PANABO 2 BRANCH'),(410,'SBPIUOM','UOM','SBPI','branch',1,NULL,'2024-05-17 23:30:54','2024-05-17 23:30:54',1,'SAINT BARBARA PRIME PAWNSHOP INC. - POBLACION 2 SAN MIGUEL BRANCH'),(411,'SBPITRW','TRW','SBPI','branch',1,NULL,'2024-05-17 23:31:16','2024-05-17 23:31:16',1,'SAINT BARBARA PRIME PAWNSHOP INC. - UGONG 1 BRANCH'),(412,'SBPITOG','TOG','SBPI','branch',1,NULL,'2024-05-17 23:31:35','2024-05-17 23:31:35',1,'SAINT BARBARA PRIME PAWNSHOP INC. - DOMAIN BRANCH'),(413,'NWPIIBR','IBR','NWPI','branch',1,NULL,'2024-05-17 23:31:56','2024-05-17 23:31:56',1,'NORTH WESTERN PACIFIC PAWNSHOP INC. - IGBARAS BRANCH'),(414,'NWPISPC','SPC','NWPI','branch',1,NULL,'2024-05-17 23:32:18','2024-05-17 23:32:18',1,'NORTH WESTERN PACIFIC PAWNSHOP INC. - SAMPALOC BRANCH'),(415,'NWPIFTA','FTA','NWPI','branch',1,NULL,'2024-05-17 23:32:42','2024-05-17 23:32:42',1,'NORTH WESTERN PACIFIC PAWNSHOP INC. - FATIMA BRANCH'),(416,'NWPITPI','TPI','NWPI','branch',1,NULL,'2024-05-17 23:33:01','2024-05-17 23:33:01',1,'NORTH WESTERN PACIFIC PAWNSHOP INC. - TUPI BRANCH'),(417,'NWPIPPD','PPD','NWPI','branch',1,NULL,'2024-05-17 23:33:20','2024-05-17 23:33:20',1,'NORTH WESTERN PACIFIC PAWNSHOP INC. - PROSPERIDAD BRANCH'),(418,'NWPILPL','LPL','NWPI','branch',1,NULL,'2024-05-17 23:33:46','2024-05-17 23:33:46',1,'NORTH WESTERN PACIFIC PAWNSHOP INC. - LAUREL BRANCH'),(419,'NWPILIN','LIN','NWPI','branch',1,NULL,'2024-05-17 23:35:31','2024-05-17 23:35:31',1,'NORTH WESTERN PACIFIC PAWNSHOP INC. - LIAN BRANCH'),(420,'NWPIPLP','PLP','NWPI','branch',1,NULL,'2024-05-17 23:35:54','2024-05-17 23:35:54',1,'NORTH WESTERN PACIFIC PAWNSHOP INC. - PULANG LUPA BRANCH'),(421,'NWPIMBH','MBH','NWPI','branch',1,NULL,'2024-05-17 23:36:44','2024-05-17 23:36:44',1,'NORTH WESTERN PACIFIC PAWNSHOP INC. - MABINI BOHOL BRANCH'),(422,'NWPILPA3','LPA3','NWPI','branch',1,NULL,'2024-05-17 23:37:11','2024-05-17 23:37:11',1,'NORTH WESTERN PACIFIC PAWNSHOP INC. - LIPA 3 BRANCH'),(423,'NWPIGMC','GMC','NWPI','branch',1,NULL,'2024-05-17 23:37:41','2024-05-17 23:37:41',1,'NORTH WESTERN PACIFIC PAWNSHOP INC. - GUMACA BRANCH'),(424,'NWPIGMB','GMB','NWPI','branch',1,NULL,'2024-05-17 23:38:01','2024-05-17 23:38:01',1,'NORTH WESTERN PACIFIC PAWNSHOP INC. - GUIMBA BRANCH'),(425,'NWPIMHK','MHK','NWPI','branch',1,NULL,'2024-05-17 23:38:22','2024-05-17 23:38:22',1,'NORTH WESTERN PACIFIC PAWNSHOP INC. - MAHARLIKA BRANCH'),(426,'SRPIMT1','MT1','SRPI','branch',1,NULL,'2024-05-17 23:39:04','2024-05-17 23:39:04',1,'SAN RAMON PLATINUM PAWNSHOP INC - MATI 1 BRANCH'),(427,'SRPIMCO','MCO','SRPI','branch',1,NULL,'2024-05-17 23:39:25','2024-05-17 23:39:25',1,'SAN RAMON PLATINUM PAWNSHOP INC - MACO BRANCH'),(428,'SRPIDSD','DSD','SRPI','branch',1,NULL,'2024-05-17 23:39:49','2024-05-17 23:39:49',1,'SAN RAMON PLATINUM PAWNSHOP INC - DOÑA SOLIDAD'),(429,'SRPIMTG','MTG','SRPI','branch',1,NULL,'2024-05-17 23:40:13','2024-05-17 23:40:13',1,'SAN RAMON PLATINUM PAWNSHOP INC - METROGATE BRANCH'),(430,'SRPISFO','SFO','SRPI','branch',1,NULL,'2024-05-17 23:40:44','2024-05-17 23:40:44',1,'SAN RAMON PLATINUM PAWNSHOP INC - SAN FRANCISCO BRANCH'),(431,'SRPISLZ','SLZ','SRPI','branch',1,NULL,'2024-05-17 23:41:08','2024-05-17 23:41:08',1,'SAN RAMON PLATINUM PAWNSHOP INC - SAN LORENZO BRANCH'),(432,'SRPISFZ','SFZ','SRPI','branch',1,NULL,'2024-05-17 23:41:34','2024-05-17 23:41:34',1,'SAN RAMON PLATINUM PAWNSHOP INC - SAN FRANZ BRANCH'),(433,'SRPIPNB1','PNB1','SRPI','branch',1,NULL,'2024-05-17 23:41:52','2024-05-17 23:41:52',1,'SAN RAMON PLATINUM PAWNSHOP INC - PANABO 1 BRANCH'),(434,'SRPIQRN','QRN','SRPI','branch',1,NULL,'2024-05-17 23:42:15','2024-05-17 23:42:15',1,'SAN RAMON PLATINUM PAWNSHOP INC - QUIRINO  BRANCH'),(435,'SRPIPRT','PRT','SRPI','branch',1,NULL,'2024-05-17 23:42:33','2024-05-17 23:42:33',1,'SAN RAMON PLATINUM PAWNSHOP INC - PUERTO BRANCH'),(436,'GRMHEXB','EXB','GRMH','branch',1,NULL,'2024-05-21 16:32:36','2024-05-21 16:32:36',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - EXCOM BRANCH'),(437,'GRMHLEV','LEV','GRMH','branch',1,NULL,'2024-05-21 16:47:49','2024-05-21 16:47:49',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - LEVISTE BRANCH'),(438,'GRMHLP3','LP3','GRMH','branch',1,NULL,'2024-05-21 16:48:28','2024-05-21 16:48:28',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - LIPA 1 BRANCH'),(439,'GRMHLPA3','LPA3','GRMH','branch',1,NULL,'2024-05-21 16:48:53','2024-05-21 16:48:53',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - LIPA 3 BRANCH'),(440,'GRMHMHK','MHK','GRMH','branch',1,NULL,'2024-05-21 16:49:43','2024-05-21 16:49:43',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - MAHARLIKA BRANCH'),(441,'GRMHPHSE11','PHSE11','GRMH','branch',1,NULL,'2024-05-21 16:53:24','2024-05-21 16:53:24',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - PHASE 11 BRANCH'),(442,'GRMHPLP','PLP','GRMH','branch',1,NULL,'2024-05-21 16:53:54','2024-05-21 16:53:54',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - PULANG LUPA BRANCH'),(443,'GRMHSGB','SGB','GRMH','branch',1,NULL,'2024-05-21 16:55:45','2024-05-21 16:55:45',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - SAGUIN BRANCH'),(444,'GRMHSFDO L.U.','SFDO L.U.','GRMH','branch',1,NULL,'2024-05-21 16:56:16','2024-05-21 16:56:16',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - SAN FERNANDO PC BRANCH'),(445,'GRMHSML','SML','GRMH','branch',1,NULL,'2024-05-21 16:57:16','2024-05-21 16:57:16',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - SOLIS MANILA'),(446,'GRMHUUG2','UUG2','GRMH','branch',1,NULL,'2024-05-21 16:59:38','2024-05-21 16:59:38',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - UGONG 2 BRANCH'),(447,'GRMHVPC','VPC','GRMH','branch',1,NULL,'2024-05-21 17:00:29','2024-05-21 17:00:29',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - VISPAC BRANCH'),(448,'GRMHWSTF','WSTF','GRMH','branch',1,NULL,'2024-05-21 17:02:26','2024-05-21 17:02:26',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - WESTAF BRANCH'),(449,'GRMHBLR2','BLR2','GRMH','branch',1,NULL,'2024-05-21 17:05:43','2024-05-21 17:05:43',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - BALER 2 BRANCH'),(450,'GRMHBYN','BYN','GRMH','branch',1,NULL,'2024-05-21 17:06:09','2024-05-21 17:06:09',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - BAYAWAN BRANCH'),(451,'GRMHBRGS','BRGS','GRMH','branch',1,NULL,'2024-05-21 17:07:24','2024-05-21 17:07:24',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - BURGOS BRANCH'),(452,'GRMHDMGS','DMGS','GRMH','branch',1,NULL,'2024-05-21 17:12:05','2024-05-21 17:12:05',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - DUMANGAS BRANCH'),(453,'GRMHFTA','FTA','GRMH','branch',1,NULL,'2024-05-21 17:12:47','2024-05-21 17:12:47',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - FATIMA BRANCH'),(454,'GRMHGLN','GLN','GRMH','branch',1,NULL,'2024-05-21 17:14:16','2024-05-21 17:14:16',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - GENERAL LUNA BRANCH'),(455,'GRMHGOA','GOA','GRMH','branch',1,NULL,'2024-05-21 17:15:57','2024-05-21 17:15:57',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - GOA BRANCH'),(456,'GRMHGMZ','GMZ','GRMH','branch',1,NULL,'2024-05-21 17:16:19','2024-05-21 17:16:19',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - GOMEZ BRANCH'),(457,'GRMHGMC','GMC','GRMH','branch',1,NULL,'2024-05-21 17:17:08','2024-05-21 17:17:08',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - GUMACA BRANCH'),(458,'GRMHHNBN','HNBN','GRMH','branch',1,NULL,'2024-05-21 17:17:40','2024-05-21 17:17:40',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - HINOBAAN BRANCH'),(459,'GRMHMBH','MBH','GRMH','branch',1,NULL,'2024-05-21 17:18:23','2024-05-21 17:18:23',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - MABINI BOHOL BRANCH'),(460,'GRMHMLR','MLR','GRMH','branch',1,NULL,'2024-05-21 17:19:01','2024-05-21 17:19:01',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - MALARIA BRANCH'),(461,'GRMHPTD','PTD','GRMH','branch',1,NULL,'2024-05-21 17:21:43','2024-05-21 17:21:43',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - PONTEVEDRA BRANCH'),(462,'GRMHSLN','SLN','GRMH','branch',1,NULL,'2024-05-21 17:24:33','2024-05-21 17:24:33',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - SOLANO BRANCH'),(463,'GRMHSVL','SVL','GRMH','branch',1,NULL,'2024-05-21 17:25:10','2024-05-21 17:25:10',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - SUNVALLEY BRANCH'),(464,'GRMHTBN','TBN','GRMH','branch',1,NULL,'2024-05-21 17:25:47','2024-05-21 17:25:47',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - TIGBAUAN BRANCH'),(465,'GRMHBRT1','BRT1','GRMH','branch',1,NULL,'2024-05-21 17:29:40','2024-05-21 17:29:40',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - BARRETTO 1 BRANCH'),(466,'GRMHCLBG','CLBG','GRMH','branch',1,NULL,'2024-05-21 17:31:47','2024-05-21 17:31:47',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - CALABANGA BRANCH'),(467,'GRMHCYNB','CYNB','GRMH','branch',1,NULL,'2024-05-21 17:32:32','2024-05-21 17:32:32',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - CAUAYAN BRANCH'),(468,'GRMHDVO','DVO','GRMH','branch',1,NULL,'2024-05-21 17:33:22','2024-05-21 17:33:22',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - DAVAO BRANCH'),(469,'GRMHGZG','GZG','GRMH','branch',1,NULL,'2024-05-21 17:34:09','2024-05-21 17:34:09',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - GONZAGA BRANCH'),(470,'GRMHGMB','GMB','GRMH','branch',1,NULL,'2024-05-21 17:34:47','2024-05-21 17:34:47',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - GUIMBA BRANCH'),(471,'GRMHIBR','IBR','GRMH','branch',1,NULL,'2024-05-21 17:35:21','2024-05-21 17:35:21',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - IGBARAS BRANCH'),(472,'GRMHKBSN','KBSN','GRMH','branch',1,NULL,'2024-05-21 17:36:41','2024-05-21 17:36:41',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - KABASALAN BRANCH'),(473,'GRMHKBW','KBW','GRMH','branch',1,NULL,'2024-05-21 17:37:21','2024-05-21 17:37:21',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - KIBAWE BRANCH'),(474,'GRMHKRND','KRND','GRMH','branch',1,NULL,'2024-05-21 17:38:38','2024-05-21 17:38:38',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - KORONADAL BRANCH'),(475,'GRMHLTND','LTND','GRMH','branch',1,NULL,'2024-05-21 17:39:16','2024-05-21 17:39:16',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - LA TRINIDAD BRANCH'),(476,'GRMHLABO','LABO','GRMH','branch',1,NULL,'2024-05-21 17:39:40','2024-05-21 17:39:40',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - LABO BRANCH'),(477,'GRMHLPL','LPL','GRMH','branch',1,NULL,'2024-05-21 17:40:03','2024-05-21 17:40:03',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - LAUREL BRANCH'),(478,'GRMHLIN','LIN','GRMH','branch',1,NULL,'2024-05-21 17:42:02','2024-05-21 17:42:02',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - LIAN BRANCH'),(479,'GRMHMLY','MLY','GRMH','branch',1,NULL,'2024-05-21 17:42:59','2024-05-21 17:42:59',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - MALANDAY BRANCH'),(480,'GRMHPPD','PPD','GRMH','branch',1,NULL,'2024-05-21 17:54:21','2024-05-21 17:54:21',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - PROSPERIDAD BRANCH'),(481,'GRMHSPC','SPC','GRMH','branch',1,NULL,'2024-05-21 17:54:51','2024-05-21 17:54:51',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - SAMPALOC BRANCH'),(482,'GRMHSPCL','SPCL','GRMH','branch',1,NULL,'2024-05-21 17:55:19','2024-05-21 17:55:19',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - SAN PASCUAL BRANCH'),(483,'GRMHTGBN','TGBN','GRMH','branch',1,NULL,'2024-05-21 17:57:36','2024-05-21 17:57:36',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - TAGBINA BRANCH'),(484,'GRMHTPI','TPI','GRMH','branch',1,NULL,'2024-05-21 18:00:35','2024-05-21 18:00:35',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - TUPI BRANCH'),(485,'SPPIANS','ANS','SPPI','branch',1,NULL,'2024-05-21 22:00:00','2024-05-21 22:00:00',1,'SUREPLEDGE PAWNSHOP INC. - ANONAS BRANCH'),(486,'SPPIPNB','PNB','SPPI','branch',1,NULL,'2024-05-21 22:00:41','2024-05-21 22:00:41',1,'SUREPLEDGE PAWNSHOP INC. - PINAGBUHATAN BRANCH'),(487,'SPPITIA','TIA','SPPI','branch',1,NULL,'2024-05-21 22:01:05','2024-05-21 22:01:05',1,'SUREPLEDGE PAWNSHOP INC. - TIAONG BRANCH'),(488,'SPPITSM','TSM','SPPI','branch',1,NULL,'2024-05-21 22:01:21','2024-05-21 22:01:21',1,'SUREPLEDGE PAWNSHOP INC. - TINA BRANCH'),(489,'HMA','HMA','0','branch',1,NULL,'2024-05-21 22:18:56','2024-05-21 22:18:56',0,'HERMOSA'),(490,'MDPI','MDPI','0','group',1,NULL,'2024-05-21 22:20:17','2024-05-21 22:20:17',0,'MEGAWORLD DOMESTIC PAWNSHOP INC.'),(491,'MDPIHMA','HMA','MDPI','branch',1,NULL,'2024-05-21 22:20:41','2024-05-21 22:20:41',1,'MEGAWORLD DOMESTIC PAWNSHOP INC. - HERMOSA'),(492,'PRA','PRA','0','branch',1,NULL,'2024-05-21 22:29:29','2024-05-21 22:29:29',0,'PEREA'),(493,'MDPIPRA','PRA','MDPI','branch',1,NULL,'2024-05-21 22:29:50','2024-05-21 22:29:50',1,'MEGAWORLD DOMESTIC PAWNSHOP INC. - PEREA'),(494,'LZN','LZN','0','branch',1,NULL,'2024-05-21 22:32:48','2024-05-21 22:32:48',0,'LUZON'),(495,'MDPILZN','LZN','MDPI','branch',1,NULL,'2024-05-21 22:33:10','2024-05-21 22:33:10',1,'MEGAWORLD DOMESTIC PAWNSHOP INC. - LUZON'),(496,'MTWN','MTWN','0','branch',1,NULL,'2024-05-21 22:36:50','2024-05-21 22:36:50',0,'METROTOWN'),(497,'MDPIMTWN','MTWN','MDPI','branch',1,NULL,'2024-05-21 22:37:11','2024-05-21 22:37:11',1,'MEGAWORLD DOMESTIC PAWNSHOP INC. - METROTOWN'),(498,'CNA','CNA','0','branch',1,NULL,'2024-05-21 22:39:47','2024-05-21 22:39:47',0,'CUENCA'),(499,'MDPICNA','CNA','MDPI','branch',1,NULL,'2024-05-21 22:40:07','2024-05-21 22:40:07',1,'MEGAWORLD DOMESTIC PAWNSHOP INC. - CUENCA'),(500,'SGA','SGA','0','branch',1,NULL,'2024-05-21 22:42:42','2024-05-21 22:42:42',0,'SIGMA'),(501,'MDPISGA','SGA','MDPI','branch',1,NULL,'2024-05-21 22:43:00','2024-05-21 22:43:00',1,'MEGAWORLD DOMESTIC PAWNSHOP INC. - SIGMA'),(502,'NIC','NIC','0','branch',1,NULL,'2024-05-21 22:46:19','2024-05-21 22:46:19',0,'NAIC'),(503,'MDPINIC','NIC','MDPI','branch',1,NULL,'2024-05-21 22:46:38','2024-05-21 22:46:38',1,'MEGAWORLD DOMESTIC PAWNSHOP INC. - NAIC'),(504,'MÑZ','MÑZ','0','branch',1,NULL,'2024-05-21 23:09:36','2024-05-21 23:09:36',0,'MUÑOZ'),(505,'MDPIMÑZ','MÑZ','MDPI','branch',1,NULL,'2024-05-21 23:09:54','2024-05-21 23:09:54',1,'MEGAWORLD DOMESTIC PAWNSHOP INC. - MUÑOZ'),(506,'NVRA','NVRA','0','branch',1,NULL,'2024-05-21 23:20:27','2024-05-21 23:20:27',0,'NOVASORA'),(507,'MDPINVRA','NVRA','MDPI','branch',1,NULL,'2024-05-21 23:21:02','2024-05-21 23:21:02',1,'MEGAWORLD DOMESTIC PAWNSHOP INC. - NOVASORA'),(508,'PRSA','PRSA','0','branch',1,NULL,'2024-05-21 23:23:29','2024-05-21 23:23:29',0,'PRES AVE'),(509,'MDPIPRSA','PRSA','MDPI','branch',1,NULL,'2024-05-21 23:23:45','2024-05-21 23:23:45',1,'MEGAWORLD DOMESTIC PAWNSHOP INC. - PRES AVE'),(510,'CLN','CLN','0','branch',1,NULL,'2024-05-21 23:26:52','2024-05-21 23:26:52',0,'CANLAON'),(511,'MDPICLN','CLN','MDPI','branch',1,NULL,'2024-05-21 23:27:59','2024-05-21 23:27:59',1,'MEGAWORLD DOMESTIC PAWNSHOP INC. - CANLAON'),(512,'PLW','PLW','0','branch',1,NULL,'2024-05-22 17:04:57','2024-05-22 17:04:57',0,'PALATIW BRANCH H.O'),(513,'ECT','ECT','0','branch',1,NULL,'2024-05-22 17:07:51','2024-05-22 17:07:51',0,'ESCOLTA BRANCH H.O'),(514,'SRPIECT','ECT','SRPI','branch',1,NULL,'2024-05-22 17:09:09','2024-05-22 17:09:09',1,'SAN RAMON PLATINUM PAWNSHOP INC - ESCOLTA BRANCH H.O'),(515,'NWPIPLW','PLW','NWPI','branch',1,NULL,'2024-05-22 17:09:41','2024-05-22 17:09:41',1,'NORTH WESTERN PACIFIC PAWNSHOP INC. - PALATIW BRANCH H.O'),(516,'CLT','CLT','0','branch',1,NULL,'2024-05-26 17:38:01','2024-05-26 17:38:01',0,'COLT'),(517,'PLC','PLC','0','branch',1,NULL,'2024-05-26 17:41:53','2024-05-26 17:41:53',0,'PALANCA'),(518,'NSB','NSB','0','branch',1,NULL,'2024-05-26 17:45:41','2024-05-26 17:45:41',0,'NASUGBU'),(519,'MUL','MUL','0','branch',1,NULL,'2024-05-26 17:49:07','2024-05-26 17:49:07',0,'MULANAY BRANCH'),(520,'GNL','GNL','0','branch',1,NULL,'2024-05-26 18:34:31','2024-05-26 18:34:31',0,'GEN. LUIS BRANCH'),(521,'NBN','NBN','0','branch',1,NULL,'2024-05-26 18:40:55','2024-05-26 18:40:55',0,'NABUNTURAN BRANCH'),(522,'SBN','SBN','0','branch',1,NULL,'2024-05-26 18:46:49','2024-05-26 18:46:49',0,'SAN BENITO BRANCH'),(523,'CTS','CTS','0','branch',1,NULL,'2024-05-26 18:51:53','2024-05-26 18:51:53',0,'CITRUS BRANCH'),(524,'SGN','SGN','0','branch',1,NULL,'2024-05-26 18:55:30','2024-05-26 18:55:30',0,'SAGUIN BRANCH'),(525,'SRL','SRL','0','branch',1,NULL,'2024-05-26 18:57:24','2024-05-26 18:57:24',0,'SAN RAFAEL BRANCH'),(526,'STD','STD','0','branch',1,NULL,'2024-05-26 19:02:57','2024-05-26 19:02:57',0,'STATESIDE PLAZA BRANCH'),(527,'NGK','NGK','0','branch',1,NULL,'2024-05-26 19:05:29','2024-05-26 19:05:29',0,'NANGKA BRANCH'),(528,'SGL','SGL','0','branch',1,NULL,'2024-05-26 19:08:13','2024-05-26 19:08:13',0,'SIGNAL NEW BRANCH'),(529,'CTV','CTV','0','branch',1,NULL,'2024-05-26 19:12:26','2024-05-26 19:12:26',0,'CALATRAVA BRANCH'),(530,'PJPIMLT','MLT','PJPI','branch',1,NULL,'2024-05-26 19:49:59','2024-05-26 19:49:59',1,'PRINCESS CUT JEWELRY AND PAWNSHOP INC. - MALITA BRANCH'),(531,'PJPIPLY','PLY','PJPI','branch',1,NULL,'2024-05-26 19:50:51','2024-05-26 19:50:51',1,'PRINCESS CUT JEWELRY AND PAWNSHOP INC. - PELAYO BRANCH'),(532,'PJPITBO','TBO','PJPI','branch',1,NULL,'2024-05-26 19:51:23','2024-05-26 19:51:23',1,'PRINCESS CUT JEWELRY AND PAWNSHOP INC. - TIBUNGCO BRANCH'),(533,'PJPISLY','SLY','PJPI','branch',1,NULL,'2024-05-26 21:15:40','2024-05-26 21:15:40',1,'PRINCESS CUT JEWELRY AND PAWNSHOP INC. - SILAY BRANCH'),(534,'PJPIELE','ELE','PJPI','branch',1,NULL,'2024-05-26 21:16:12','2024-05-26 21:16:12',1,'PRINCESS CUT JEWELRY AND PAWNSHOP INC. - ESCALANTE BRANCH'),(535,'PJPIPSI','PSI','PJPI','branch',1,NULL,'2024-05-26 21:16:42','2024-05-26 21:16:42',1,'PRINCESS CUT JEWELRY AND PAWNSHOP INC. - PASSI BRANCH'),(536,'PJPIVTS','VTS','PJPI','branch',1,NULL,'2024-05-26 21:17:07','2024-05-26 21:17:07',1,'PRINCESS CUT JEWELRY AND PAWNSHOP INC. - VICTORIAS BRANCH'),(537,'PJPITJO','TJO','PJPI','branch',1,NULL,'2024-05-26 21:17:37','2024-05-26 21:17:37',1,'PRINCESS CUT JEWELRY AND PAWNSHOP INC. - TEJERO BRANCH'),(538,'PJPIJRD','JRD','PJPI','branch',1,NULL,'2024-05-26 21:17:58','2024-05-26 21:17:58',1,'PRINCESS CUT JEWELRY AND PAWNSHOP INC. - JORDAN BRANCH'),(539,'PKPICLT','CLT','PKPI','branch',1,NULL,'2024-05-26 21:18:36','2024-05-26 21:18:36',1,'PUREGOLD KARAT PAWNSHOP INC - COLT BRANCH'),(540,'PKPIPLC','PLC','PKPI','branch',1,NULL,'2024-05-26 21:19:50','2024-05-26 21:19:50',1,'PUREGOLD KARAT PAWNSHOP INC - PALANCA BRANCH'),(541,'PKPINSB','NSB','PKPI','branch',1,NULL,'2024-05-26 21:20:23','2024-05-26 21:20:23',1,'PUREGOLD KARAT PAWNSHOP INC - NASUGBU BRANCH'),(542,'PKPIMUL','MUL','PKPI','branch',1,NULL,'2024-05-26 21:20:53','2024-05-26 21:20:53',1,'PUREGOLD KARAT PAWNSHOP INC - MULANAY BRANCH'),(543,'PKPIGNL','GNL','PKPI','branch',1,NULL,'2024-05-26 21:21:26','2024-05-26 21:21:26',1,'PUREGOLD KARAT PAWNSHOP INC - GEN. LUIS BRANCH'),(544,'PKPINBN','NBN','PKPI','branch',1,NULL,'2024-05-26 21:21:48','2024-05-26 21:21:48',1,'PUREGOLD KARAT PAWNSHOP INC - NABUNTURAN BRANCH'),(545,'PKPISBN','SBN','PKPI','branch',1,NULL,'2024-05-26 21:22:24','2024-05-26 21:22:24',1,'PUREGOLD KARAT PAWNSHOP INC - SAN BENITO BRANCH'),(546,'PKPICTS','CTS','PKPI','branch',1,NULL,'2024-05-26 21:22:52','2024-05-26 21:22:52',1,'PUREGOLD KARAT PAWNSHOP INC - CITRUS BRANCH'),(547,'PKPISRL','SRL','PKPI','branch',1,NULL,'2024-05-26 21:31:03','2024-05-26 21:31:03',1,'PUREGOLD KARAT PAWNSHOP INC - SAN RAFAEL BRANCH'),(548,'PKPISTD','STD','PKPI','branch',1,NULL,'2024-05-26 21:31:45','2024-05-26 21:31:45',1,'PUREGOLD KARAT PAWNSHOP INC - STATESIDE PLAZA BRANCH'),(549,'PKPINGK','NGK','PKPI','branch',1,NULL,'2024-05-26 21:32:08','2024-05-26 21:32:08',1,'PUREGOLD KARAT PAWNSHOP INC - NANGKA BRANCH'),(550,'PKPISGL','SGL','PKPI','branch',1,NULL,'2024-05-26 21:32:38','2024-05-26 21:32:38',1,'PUREGOLD KARAT PAWNSHOP INC - SIGNAL NEW BRANCH'),(551,'PKPICTV','CTV','PKPI','branch',1,NULL,'2024-05-26 21:33:15','2024-05-26 21:33:15',1,'PUREGOLD KARAT PAWNSHOP INC - CALATRAVA BRANCH'),(552,'SJPIMUS','MUS','SJPI','branch',1,NULL,'2024-05-26 21:34:35','2024-05-26 21:34:35',1,'SILVERSTAR JEWELRY AND PAWNSHOP INC - MARULAS BRANCH'),(553,'SJPISJDM','SJDM','SJPI','branch',1,NULL,'2024-05-26 21:35:17','2024-05-26 21:35:17',1,'SILVERSTAR JEWELRY AND PAWNSHOP INC - STARMALL SJDM BRANCH'),(554,'SJPIDGS 2','DGS 2','SJPI','branch',1,NULL,'2024-05-26 21:35:58','2024-05-26 21:35:58',1,'SILVERSTAR JEWELRY AND PAWNSHOP INC - DIGOS 2 BRANCH'),(555,'SJPISBA','SBA','SJPI','branch',1,NULL,'2024-05-26 21:36:26','2024-05-26 21:36:26',1,'SILVERSTAR JEWELRY AND PAWNSHOP INC - STA. BARBARA BRANCH'),(556,'SJPIPRS','PRS','SJPI','branch',1,NULL,'2024-05-26 21:36:50','2024-05-26 21:36:50',1,'SILVERSTAR JEWELRY AND PAWNSHOP INC - PRES. ROXAS BRANCH'),(557,'SJPILBO','LBO','SJPI','branch',1,NULL,'2024-05-26 21:37:21','2024-05-26 21:37:21',1,'SILVERSTAR JEWELRY AND PAWNSHOP INC - LAMBUNAO BRANCH'),(558,'SJPIVLY','VLY','SJPI','branch',1,NULL,'2024-05-26 21:37:55','2024-05-26 21:37:55',1,'SILVERSTAR JEWELRY AND PAWNSHOP INC - VICTORY LEMERY BRANCH'),(559,'SJPIPCA','PCA','SJPI','branch',1,NULL,'2024-05-26 21:38:17','2024-05-26 21:38:17',1,'SILVERSTAR JEWELRY AND PAWNSHOP INC - POCA BRANCH'),(560,'SJPIZBE','ZBE','SJPI','branch',1,NULL,'2024-05-26 21:38:50','2024-05-26 21:38:50',1,'SILVERSTAR JEWELRY AND PAWNSHOP INC - ZABARTE MALL BRANCH'),(561,'PKPISGB','SGB','PKPI','branch',1,'2024-05-27 05:44:25','2024-05-26 21:44:08','2024-05-26 21:44:25',1,'PUREGOLD KARAT PAWNSHOP INC - SAGUIN BRANCH'),(562,'PKPISGN','SGN','PKPI','branch',1,NULL,'2024-05-26 21:45:52','2024-05-26 21:45:52',1,'PUREGOLD KARAT PAWNSHOP INC - SAGUIN BRANCH'),(563,'TNO','TNO','0','branch',1,NULL,'2024-05-27 16:18:04','2024-05-27 16:18:04',0,'TRENTO BRANCH'),(564,'VCN','VCN','0','branch',1,NULL,'2024-05-27 16:21:49','2024-05-27 16:21:49',0,'VICTORY LACSON BRANCH'),(565,'TYB','TYB','0','branch',1,NULL,'2024-05-27 16:23:31','2024-05-27 16:23:31',0,'TAYABAS BRANCH'),(566,'VLC','VLC','0','branch',1,NULL,'2024-05-27 16:27:13','2024-05-27 16:27:13',0,'VALENCIA BRANCH'),(567,'TRM','TRM','0','branch',1,NULL,'2024-05-27 16:57:56','2024-05-27 16:57:56',0,'TRAMO BRANCH'),(568,'SPPITYB','TYB','SPPI','branch',1,NULL,'2024-05-27 16:58:33','2024-05-27 16:58:33',1,'SUREPLEDGE PAWNSHOP INC. - TAYABAS BRANCH'),(569,'SPPITRM','TRM','SPPI','branch',1,NULL,'2024-05-27 16:58:51','2024-05-27 16:58:51',1,'SUREPLEDGE PAWNSHOP INC. - TRAMO BRANCH'),(570,'SPPITNO','TNO','SPPI','branch',1,NULL,'2024-05-27 16:59:06','2024-05-27 16:59:06',1,'SUREPLEDGE PAWNSHOP INC. - TRENTO BRANCH'),(571,'SPPIVLC','VLC','SPPI','branch',1,NULL,'2024-05-27 16:59:23','2024-05-27 16:59:23',1,'SUREPLEDGE PAWNSHOP INC. - VALENCIA BRANCH'),(572,'SPPIVCN','VCN','SPPI','branch',1,NULL,'2024-05-27 16:59:38','2024-05-27 16:59:38',1,'SUREPLEDGE PAWNSHOP INC. - VICTORY LACSON BRANCH'),(573,'CVST','CVST','0','branch',1,NULL,'2024-05-28 00:19:05','2024-05-28 00:19:05',0,'CAVITE ST'),(574,'WGPI','WGPI','0','group',1,NULL,'2024-05-28 00:19:48','2024-05-28 00:19:48',0,'WORLDGEM PAWNSHOP INC.'),(575,'WGPICVST','CVST','WGPI','branch',1,NULL,'2024-05-28 00:21:52','2024-05-28 00:21:52',1,'WORLDGEM PAWNSHOP INC. - CAVITE ST'),(576,'TMST','TMST','0','branch',1,NULL,'2024-05-28 00:27:37','2024-05-28 00:27:37',0,'TIMES ST'),(577,'WGPITMST','TMST','WGPI','branch',1,NULL,'2024-05-28 00:28:00','2024-05-28 00:28:00',1,'WORLDGEM PAWNSHOP INC. - TIMES ST'),(578,'EVM','EVM','0','branch',1,NULL,'2024-05-28 00:30:28','2024-05-28 00:30:28',0,'EVACOM'),(579,'WGPIEVM','EVM','WGPI','branch',1,NULL,'2024-05-28 00:30:49','2024-05-28 00:30:49',1,'WORLDGEM PAWNSHOP INC. - EVACOM'),(580,'CMSR','CMSR','0','branch',1,NULL,'2024-05-28 00:38:35','2024-05-28 00:38:35',0,'CM STA ROSA'),(581,'WGPICMSR','CMSR','WGPI','branch',1,NULL,'2024-05-28 00:38:55','2024-05-28 00:38:55',1,'WORLDGEM PAWNSHOP INC. - CM STA ROSA'),(582,'CMDAO','CMDAO','0','branch',1,NULL,'2024-05-28 00:42:20','2024-05-28 00:42:20',0,'CM DANAO'),(583,'WGPICMDAO','CMDAO','WGPI','branch',1,NULL,'2024-05-28 00:42:37','2024-05-28 00:42:37',1,'WORLDGEM PAWNSHOP INC. - CM DANAO'),(584,'WSTK','WSTK','0','branch',1,NULL,'2024-05-28 00:46:26','2024-05-28 00:46:26',0,'WESTBANK'),(585,'WGPIWSTK','WSTK','WGPI','branch',1,NULL,'2024-05-28 00:46:44','2024-05-28 00:46:44',1,'WORLDGEM PAWNSHOP INC. - WESTBANK'),(586,'CRDO','CRDO','0','branch',1,NULL,'2024-05-28 16:22:07','2024-05-28 16:22:07',0,'CARRIEDO'),(587,'WGPICRDO','CRDO','WGPI','branch',1,NULL,'2024-05-28 16:23:05','2024-05-28 16:23:05',1,'WORLDGEM PAWNSHOP INC. - CARRIEDO'),(588,'MRL 3','MRL 3','0','branch',1,NULL,'2024-05-28 16:25:29','2024-05-28 16:25:29',0,'MARILAO 3'),(589,'WGPIMRL 3','MRL 3','WGPI','branch',1,NULL,'2024-05-28 16:25:46','2024-05-28 16:25:46',1,'WORLDGEM PAWNSHOP INC. - MARILAO 3'),(590,'KKPIBNG','BNG','KKPI','branch',1,NULL,'2024-05-28 16:28:14','2024-05-28 16:28:14',1,'KRYPTON KNIGHT PAWNSHOP INC. - BAUANG BRANCH'),(591,'RNW','RNW','0','branch',1,NULL,'2024-05-28 16:28:19','2024-05-28 16:28:19',0,'RAINBOW'),(592,'WGPIRNW','RNW','WGPI','branch',1,NULL,'2024-05-28 16:28:39','2024-05-28 16:28:39',1,'WORLDGEM PAWNSHOP INC. - RAINBOW'),(593,'KKPIGMZ','GMZ','KKPI','branch',1,NULL,'2024-05-28 16:29:11','2024-05-28 16:29:11',1,'KRYPTON KNIGHT PAWNSHOP INC. - GOMEZ BRANCH'),(594,'KKPIKGYN','KGYN','KKPI','branch',1,NULL,'2024-05-28 16:30:27','2024-05-28 16:30:27',1,'KRYPTON KNIGHT PAWNSHOP INC. - KALIGAYAHAN BRANCH'),(595,'ILRE','ILRE','0','branch',1,NULL,'2024-05-28 16:31:42','2024-05-28 16:31:42',0,'ILUSTRE'),(596,'KKPILSL','LSL','KKPI','branch',1,NULL,'2024-05-28 16:31:49','2024-05-28 16:31:49',1,'KRYPTON KNIGHT PAWNSHOP INC. - LA SALLE BRANCH'),(597,'WGPIILRE','ILRE','WGPI','branch',1,NULL,'2024-05-28 16:32:01','2024-05-28 16:32:01',1,'WORLDGEM PAWNSHOP INC. - ILUSTRE'),(598,'MCYN','MCYN','0','branch',1,NULL,'2024-05-28 16:34:58','2024-05-28 16:34:58',0,'MEYCAUAYAN'),(599,'WGPIMCYN','MCYN','WGPI','branch',1,NULL,'2024-05-28 16:35:16','2024-05-28 16:35:16',1,'WORLDGEM PAWNSHOP INC. - MEYCAUAYAN'),(600,'IWGPI','IWGPI','0','operation',1,NULL,'2024-05-28 16:36:01','2024-05-28 16:36:01',0,'INTERWORLD GEM PAWNSHOP INC.'),(601,'ANGT','ANGT','0','branch',1,NULL,'2024-05-28 16:37:01','2024-05-28 16:37:01',0,'ANGAT'),(602,'WGPIANGT','ANGT','WGPI','branch',1,NULL,'2024-05-28 16:37:40','2024-05-28 16:37:40',1,'WORLDGEM PAWNSHOP INC. - ANGAT'),(603,'UPS','UPS','0','branch',1,NULL,'2024-05-28 16:39:29','2024-05-28 16:39:29',0,'UPS 5'),(604,'VAN','VAN','0','branch',1,NULL,'2024-05-28 16:39:44','2024-05-28 16:39:44',0,'VICTORY ANTIPOLO BRANCH'),(605,'WGPIUPS','UPS','WGPI','branch',1,NULL,'2024-05-28 16:39:46','2024-05-28 16:39:46',1,'WORLDGEM PAWNSHOP INC. - UPS 5'),(606,'MJPI','MJPI','0','group',1,NULL,'2024-05-28 16:41:15','2024-05-28 16:41:15',0,'MAJOREVIM PAWNSHOP INC'),(607,'VPY','VPY','0','branch',1,NULL,'2024-05-28 16:42:30','2024-05-28 16:42:30',0,'VICTORY PASAY BRANCH'),(608,'AZA','AZA','0','branch',1,NULL,'2024-05-28 16:44:36','2024-05-28 16:44:36',0,'AZALEA BRANCH'),(609,'MLTE','MLTE','0','branch',1,NULL,'2024-05-28 16:44:50','2024-05-28 16:44:50',0,'MALATE'),(610,'MJPIMLTE','MLTE','MJPI','branch',1,NULL,'2024-05-28 16:45:10','2024-05-28 16:45:10',1,'MAJOREVIM PAWNSHOP INC - MALATE'),(611,'DAPA','DAPA','0','branch',1,NULL,'2024-05-28 16:52:26','2024-05-28 16:52:26',0,'DAPA BRANCH'),(612,'KKPILTS','LTS','KKPI','branch',1,NULL,'2024-05-28 16:53:03','2024-05-28 16:53:03',1,'KRYPTON KNIGHT PAWNSHOP INC. - LOTUS MALL BRANCH'),(613,'SGY','SGY','0','branch',1,NULL,'2024-05-28 16:53:05','2024-05-28 16:53:05',0,'SAGAY BRANCH'),(614,'GAPIDAPA','DAPA','GAPI','branch',1,NULL,'2024-05-28 16:53:28','2024-05-28 16:53:28',1,'GOLDSTAR ATLANTIC PAWNSHOP INC - DAPA BRANCH'),(615,'KKPIPHSE11','PHSE11','KKPI','branch',1,NULL,'2024-05-28 16:53:34','2024-05-28 16:53:34',1,'KRYPTON KNIGHT PAWNSHOP INC. - PHASE 11 BRANCH'),(616,'KKPIPTD','PTD','KKPI','branch',1,NULL,'2024-05-28 16:53:52','2024-05-28 16:53:52',1,'KRYPTON KNIGHT PAWNSHOP INC. - PONTEVEDRA BRANCH'),(617,'KKPILGN','LGN','KKPI','branch',1,NULL,'2024-05-28 16:54:16','2024-05-28 16:54:16',1,'KRYPTON KNIGHT PAWNSHOP INC. - LINGAYEN BRANCH'),(618,'KKPISFDO L.U.','SFDO L.U.','KKPI','branch',1,NULL,'2024-05-28 16:54:45','2024-05-28 16:54:45',1,'KRYPTON KNIGHT PAWNSHOP INC. - SAN FERNANDO PC BRANCH'),(619,'SHRN','SHRN','0','branch',1,NULL,'2024-05-28 16:54:45','2024-05-28 16:54:45',0,'SHORTHORN'),(620,'MJPISHRN','SHRN','MJPI','branch',1,NULL,'2024-05-28 16:55:05','2024-05-28 16:55:05',1,'MAJOREVIM PAWNSHOP INC. - SHORTHORN'),(621,'MLO','MLO','0','branch',1,NULL,'2024-05-28 17:02:46','2024-05-28 17:02:46',0,'MONTELIBANO BRANCH'),(622,'GGPI','GGPI','0','group',1,NULL,'2024-05-28 17:07:40','2024-05-28 17:07:40',0,'GALLIUM GRANITE PAWNSHOP INC'),(623,'GGPIAVD','AVD','GGPI','branch',1,NULL,'2024-05-28 17:08:10','2024-05-28 17:08:10',1,'GALLIUM GRANITE PAWNSHOP INC - AVENIDA BRANCH'),(624,'GGPIAFSO','AFSO','GGPI','branch',1,NULL,'2024-05-28 17:09:04','2024-05-28 17:09:04',1,'GALLIUM GRANITE PAWNSHOP INC - ALFONSO BRANCH'),(625,'FRO','FRO','0','branch',1,NULL,'2024-05-28 17:09:11','2024-05-28 17:09:11',0,'FRISCO BRANCH'),(626,'GGPIAGY','AGY','GGPI','branch',1,NULL,'2024-05-28 17:09:26','2024-05-28 17:09:26',1,'GALLIUM GRANITE PAWNSHOP INC - ARINGAY BRANCH'),(627,'GGPIBGYN','BGYN','GGPI','branch',1,NULL,'2024-05-28 17:09:47','2024-05-28 17:09:47',1,'GALLIUM GRANITE PAWNSHOP INC - BAGUMBAYAN BRANCH'),(628,'GGPIBNN','BNN','GGPI','branch',1,NULL,'2024-05-28 17:10:47','2024-05-28 17:10:47',1,'GALLIUM GRANITE PAWNSHOP INC - BENIN BRANCH'),(629,'GGPIDVO','DVO','GGPI','branch',1,NULL,'2024-05-28 17:11:02','2024-05-28 17:11:02',1,'GALLIUM GRANITE PAWNSHOP INC - DAVAO BRANCH'),(630,'RSCY','RSCY','0','branch',1,NULL,'2024-05-28 17:11:08','2024-05-28 17:11:08',0,'ROXAS CITY'),(631,'DEL','DEL','0','branch',1,NULL,'2024-05-28 17:11:23','2024-05-28 17:11:23',0,'DELGADO BRANCH'),(632,'MJPIRSCY','RSCY','MJPI','branch',1,NULL,'2024-05-28 17:11:26','2024-05-28 17:11:26',1,'MAJOREVIM PAWNSHOP INC. - ROXAS CITY'),(633,'GGPIGLN','GLN','GGPI','branch',1,NULL,'2024-05-28 17:13:15','2024-05-28 17:13:15',1,'GALLIUM GRANITE PAWNSHOP INC - GENERAL LUNA BRANCH'),(634,'GGPIGZG','GZG','GGPI','branch',1,NULL,'2024-05-28 17:13:44','2024-05-28 17:13:44',1,'GALLIUM GRANITE PAWNSHOP INC - GONZAGA BRANCH'),(635,'GTE','GTE','0','branch',1,NULL,'2024-05-28 17:13:57','2024-05-28 17:13:57',0,'GATE 3 BRANCH'),(636,'GGPIMLY','MLY','GGPI','branch',1,NULL,'2024-05-28 17:14:03','2024-05-28 17:14:03',1,'GALLIUM GRANITE PAWNSHOP INC - MALANDAY BRANCH'),(637,'GGPIMLR','MLR','GGPI','branch',1,NULL,'2024-05-28 17:14:21','2024-05-28 17:14:21',1,'GALLIUM GRANITE PAWNSHOP INC - MALARIA BRANCH'),(638,'MKAY 1','MKAY 1','0','branch',1,NULL,'2024-05-28 17:14:21','2024-05-28 17:14:21',0,'MASANGKAY 1'),(639,'GGPISML','SML','GGPI','branch',1,NULL,'2024-05-28 17:14:41','2024-05-28 17:14:41',1,'GALLIUM GRANITE PAWNSHOP INC - SOLIS MANILA'),(640,'GGPISCJ','SCJ','GGPI','branch',1,NULL,'2024-05-28 17:15:03','2024-05-28 17:15:03',1,'GALLIUM GRANITE PAWNSHOP INC - STA. CRUZ JOYAS BRANCH'),(641,'GGPISTM','STM','GGPI','branch',1,NULL,'2024-05-28 17:15:24','2024-05-28 17:15:24',1,'GALLIUM GRANITE PAWNSHOP INC - STA. MONICA BRANCH'),(642,'MJPIMKAY 1','MKAY 1','MJPI','branch',1,NULL,'2024-05-28 17:15:35','2024-05-28 17:15:35',1,'MAJOREVIM PAWNSHOP INC. - MASANGKAY 1'),(643,'GGPISTAJ','STAJ','GGPI','branch',1,NULL,'2024-05-28 17:15:43','2024-05-28 17:15:43',1,'GALLIUM GRANITE PAWNSHOP INC - STA. ANA JOYAS BRANCH'),(644,'GGPITBN','TBN','GGPI','branch',1,NULL,'2024-05-28 17:16:06','2024-05-28 17:16:06',1,'GALLIUM GRANITE PAWNSHOP INC - TIGBAUAN BRANCH'),(645,'SLS','SLS','0','branch',1,NULL,'2024-05-28 17:16:19','2024-05-28 17:16:19',0,'SOLIS ILOILO BRANCH'),(646,'MTL','MTL','0','branch',1,NULL,'2024-05-28 17:17:07','2024-05-28 17:17:07',0,'MATALINO'),(647,'MJPIMTL','MTL','MJPI','branch',1,NULL,'2024-05-28 17:17:24','2024-05-28 17:17:24',1,'MAJOREVIM PAWNSHOP INC. - MATALINO'),(648,'GTM','GTM','0','branch',1,NULL,'2024-05-28 17:18:14','2024-05-28 17:18:14',0,'GT PLAZA MALL BRANCH'),(649,'SNPDO','SNPDO','0','branch',1,NULL,'2024-05-28 17:20:40','2024-05-28 17:20:40',0,'SAN PEDRO'),(650,'MJPISNPDO','SNPDO','MJPI','branch',1,NULL,'2024-05-28 17:20:58','2024-05-28 17:20:58',1,'MAJOREVIM PAWNSHOP INC. - SAN PEDRO'),(651,'MCS','MCS','0','branch',1,NULL,'2024-05-28 17:25:06','2024-05-28 17:25:06',0,'MALABON CITI SQUARE'),(652,'MJPIMCS','MCS','MJPI','branch',1,NULL,'2024-05-28 17:25:20','2024-05-28 17:25:20',1,'MAJOREVIM PAWNSHOP INC. - MALABON CITI SQUARE'),(653,'MT2','MT2','0','branch',1,NULL,'2024-05-28 17:25:50','2024-05-28 17:25:50',0,'MATI 2 BRANCH'),(654,'IWGPIAZA','AZA','IWGPI','branch',1,NULL,'2024-05-28 17:26:15','2024-05-28 17:26:15',1,'INTERWORLD GEM PAWNSHOP INC. - AZALEA BRANCH'),(655,'BUE1','BUE1','0','branch',1,NULL,'2024-05-28 17:26:26','2024-05-28 17:26:26',0,'BUENAVISTA 1'),(656,'IWGPIDEL','DEL','IWGPI','branch',1,NULL,'2024-05-28 17:27:01','2024-05-28 17:27:01',1,'INTERWORLD GEM PAWNSHOP INC. - DELGADO BRANCH'),(657,'KAPSBUE1','BUE1','KAPS','branch',1,NULL,'2024-05-28 17:28:14','2024-05-28 17:28:14',1,'KING-ASIA GROUP PAWNSHOP INC. - BUENAVISTA 1'),(658,'FMS','FMS','0','branch',1,NULL,'2024-05-28 17:28:56','2024-05-28 17:28:56',0,'FORT MAGSAYSAY BRANCH'),(659,'GGPIFMS','FMS','GGPI','branch',1,NULL,'2024-05-28 17:29:18','2024-05-28 17:29:18',1,'GALLIUM GRANITE PAWNSHOP INC - FORT MAGSAYSAY BRANCH'),(660,'MSA','MSA','0','branch',1,NULL,'2024-05-28 17:29:28','2024-05-28 17:29:28',0,'MALOLOS AVE'),(661,'MJPIMSA','MSA','MJPI','branch',1,NULL,'2024-05-28 17:29:45','2024-05-28 17:29:45',1,'MAJOREVIM PAWNSHOP INC. - MALOLOS AVE'),(662,'PLQ','PLQ','0','branch',1,NULL,'2024-05-28 17:33:41','2024-05-28 17:33:41',0,'PALENQUE'),(663,'MJPIPLQ','PLQ','MJPI','branch',1,NULL,'2024-05-28 17:33:57','2024-05-28 17:33:57',1,'MAJOREVIM PAWNSHOP INC. - PALENQUE'),(664,'MYN','MYN','0','branch',1,NULL,'2024-05-28 17:37:31','2024-05-28 17:37:31',0,'MAYON'),(665,'MJPIMYN','MYN','MJPI','branch',1,NULL,'2024-05-28 17:38:04','2024-05-28 17:38:04',1,'MAJOREVIM PAWNSHOP INC. - MAYON'),(666,'LTR','LTR','0','branch',1,NULL,'2024-05-28 17:39:05','2024-05-28 17:39:05',0,'LETRE'),(667,'MWPI','MWPI','0','group',1,NULL,'2024-05-28 17:39:27','2024-05-28 17:39:27',0,'MAXI-WEALTH PAWNSHOP INC.'),(668,'ICM','ICM','0','branch',1,NULL,'2024-05-28 17:45:35','2024-05-28 17:45:35',0,'ICE MONSTER'),(669,'MWPIICM','ICM','MWPI','branch',1,NULL,'2024-05-28 17:45:53','2024-05-28 17:45:53',1,'MAXI-WEALTH PAWNSHOP INC. - ICE MONSTER'),(670,'IWGPIFRO','FRO','IWGPI','branch',1,NULL,'2024-05-28 17:47:42','2024-05-28 17:47:42',1,'INTERWORLD GEM PAWNSHOP INC. - FRISCO BRANCH'),(671,'IWGPIGTE','GTE','IWGPI','branch',1,NULL,'2024-05-28 17:47:54','2024-05-28 17:47:54',1,'INTERWORLD GEM PAWNSHOP INC. - GATE 3 BRANCH'),(672,'IWGPIGTM','GTM','IWGPI','branch',1,NULL,'2024-05-28 17:48:12','2024-05-28 17:48:12',1,'INTERWORLD GEM PAWNSHOP INC. - GT PLAZA MALL BRANCH'),(673,'IWGPIMT2','MT2','IWGPI','branch',1,NULL,'2024-05-28 17:49:14','2024-05-28 17:49:14',1,'INTERWORLD GEM PAWNSHOP INC. - MATI 2 BRANCH'),(674,'IWGPIMLO','MLO','IWGPI','branch',1,NULL,'2024-05-28 17:49:29','2024-05-28 17:49:29',1,'INTERWORLD GEM PAWNSHOP INC. - MONTELIBANO BRANCH'),(675,'IWGPISGY','SGY','IWGPI','branch',1,NULL,'2024-05-28 17:49:59','2024-05-28 17:49:59',1,'INTERWORLD GEM PAWNSHOP INC. - SAGAY BRANCH'),(676,'IWGPISLS','SLS','IWGPI','branch',1,NULL,'2024-05-28 17:50:32','2024-05-28 17:50:32',1,'INTERWORLD GEM PAWNSHOP INC. - SOLIS ILOILO BRANCH'),(677,'CLD','CLD','0','branch',1,NULL,'2024-05-28 17:50:37','2024-05-28 17:50:37',0,'CITYLAND'),(678,'MWPICLD','CLD','MWPI','branch',1,NULL,'2024-05-28 17:50:56','2024-05-28 17:50:56',1,'MAXI-WEALTH PAWNSHOP INC. - CITYLAND'),(679,'IWGPIVAN','VAN','IWGPI','branch',1,NULL,'2024-05-28 17:51:08','2024-05-28 17:51:08',1,'INTERWORLD GEM PAWNSHOP INC. - VICTORY ANTIPOLO BRANCH'),(680,'BCA2','BCA2','0','branch',1,NULL,'2024-05-28 17:51:13','2024-05-28 17:51:13',0,'BOCAUE 2 BRANCH'),(681,'IWGPIVPY','VPY','IWGPI','branch',1,NULL,'2024-05-28 17:51:24','2024-05-28 17:51:24',1,'INTERWORLD GEM PAWNSHOP INC. - VICTORY PASAY BRANCH'),(682,'PTS','PTS','0','branch',1,NULL,'2024-05-28 17:53:29','2024-05-28 17:53:29',0,'PATEROS'),(683,'MWPIPTS','PTS','MWPI','branch',1,NULL,'2024-05-28 17:53:49','2024-05-28 17:53:49',1,'MAXI-WEALTH PAWNSHOP INC. - PATEROS'),(684,'CNNY','CNNY','0','branch',1,NULL,'2024-05-28 18:18:13','2024-05-28 18:18:13',0,'CANNERY'),(685,'BGOB','BGOB','0','branch',1,NULL,'2024-05-28 18:18:28','2024-05-28 18:18:28',0,'BAGO BRANCH'),(686,'MWPICNNY','CNNY','MWPI','branch',1,NULL,'2024-05-28 18:18:41','2024-05-28 18:18:41',1,'MAXI-WEALTH PAWNSHOP INC. - CANNERY'),(687,'GAPIBGOB','BGOB','GAPI','branch',1,NULL,'2024-05-28 18:19:24','2024-05-28 18:19:24',1,'GOLDSTAR ATLANTIC PAWNSHOP INC - BAGO BRANCH'),(688,'MGPI','MGPI','0','operation',1,NULL,'2024-05-28 18:22:06','2024-05-28 18:22:06',0,'MULTIGAINED PAWNSHOP INC.'),(689,'GTA3','GTA3','0','branch',1,NULL,'2024-05-28 18:22:11','2024-05-28 18:22:11',0,'GLORIETTA 3'),(690,'MWPIGTA3','GTA3','MWPI','branch',1,NULL,'2024-05-28 18:22:35','2024-05-28 18:22:35',1,'MAXI-WEALTH PAWNSHOP INC. - GLORIETTA 3'),(691,'BNA2','BNA2','0','branch',1,NULL,'2024-05-28 18:24:50','2024-05-28 18:24:50',0,'BUENAVISTA 2'),(692,'BGD','BGD','0','branch',1,NULL,'2024-05-28 18:24:54','2024-05-28 18:24:54',0,'BUNGAD BRANCH'),(693,'MWPIBNA2','BNA2','MWPI','branch',1,NULL,'2024-05-28 18:25:21','2024-05-28 18:25:21',1,'MAXI-WEALTH PAWNSHOP INC. - BUENAVISTA 2'),(694,'MRD','MRD','0','branch',1,NULL,'2024-05-28 18:54:38','2024-05-28 18:54:38',0,'MIRANDA BRANCH'),(695,'GOO','GOO','0','branch',1,NULL,'2024-05-28 18:56:20','2024-05-28 18:56:20',0,'GERONIMO BRANCH'),(696,'ST2','ST2','0','branch',1,NULL,'2024-05-28 19:00:11','2024-05-28 19:00:11',0,'STO.TOMAS 2 BRANCH'),(697,'DCN','DCN','0','branch',1,NULL,'2024-05-28 19:02:17','2024-05-28 19:02:17',0,'DEL CARMEN BRANCH'),(698,'MRA','MRA','0','branch',1,NULL,'2024-05-28 19:03:55','2024-05-28 19:03:55',0,'MARIA AURORA BRANCH'),(699,'TYG','TYG','0','branch',1,NULL,'2024-05-28 19:05:47','2024-05-28 19:05:47',0,'TANYAG BRANCH'),(700,'KGO','KGO','0','branch',1,NULL,'2024-05-28 19:08:08','2024-05-28 19:08:08',0,'GAISANO KALIBO BRANCH'),(701,'BF2','BF2','0','branch',1,NULL,'2024-05-28 19:14:19','2024-05-28 19:14:19',0,'BF HOMES 2 BRANCH'),(702,'SNS','SNS','0','branch',1,NULL,'2024-05-28 19:16:55','2024-05-28 19:16:55',0,'SUNSHINE MALL BRANCH'),(703,'GRMHCVST','CVST','GRMH','branch',1,NULL,'2024-05-28 19:21:45','2024-05-28 19:21:45',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - CAVITE ST'),(704,'MGPIBF2','BF2','MGPI','branch',1,NULL,'2024-05-28 19:22:09','2024-05-28 19:22:09',1,'MULTIGAINED PAWNSHOP INC. - BF HOMES 2 BRANCH'),(705,'MGPIBGD','BGD','MGPI','branch',1,NULL,'2024-05-28 19:22:27','2024-05-28 19:22:27',1,'MULTIGAINED PAWNSHOP INC. - BUNGAD BRANCH'),(706,'GRMHCTS','CTS','GRMH','branch',1,NULL,'2024-05-28 19:22:43','2024-05-28 19:22:43',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - CITRUS BRANCH'),(707,'MGPIDCN','DCN','MGPI','branch',1,NULL,'2024-05-28 19:22:45','2024-05-28 19:22:45',1,'MULTIGAINED PAWNSHOP INC. - DEL CARMEN BRANCH'),(708,'MGPIKGO','KGO','MGPI','branch',1,NULL,'2024-05-28 19:23:06','2024-05-28 19:23:06',1,'MULTIGAINED PAWNSHOP INC. - GAISANO KALIBO BRANCH'),(709,'MGPIGOO','GOO','MGPI','branch',1,NULL,'2024-05-28 19:23:22','2024-05-28 19:23:22',1,'MULTIGAINED PAWNSHOP INC. - GERONIMO BRANCH'),(710,'MGPIMRD','MRD','MGPI','branch',1,NULL,'2024-05-28 19:24:04','2024-05-28 19:24:04',1,'MULTIGAINED PAWNSHOP INC. - MIRANDA BRANCH'),(711,'GRMHCLT','CLT','GRMH','branch',1,NULL,'2024-05-28 19:24:14','2024-05-28 19:24:14',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - COLT BRANCH'),(712,'MGPIST2','ST2','MGPI','branch',1,NULL,'2024-05-28 19:24:57','2024-05-28 19:24:57',1,'MULTIGAINED PAWNSHOP INC. - STO.TOMAS 2 BRANCH'),(713,'MGPISNS','SNS','MGPI','branch',1,NULL,'2024-05-28 19:25:13','2024-05-28 19:25:13',1,'MULTIGAINED PAWNSHOP INC. - SUNSHINE MALL BRANCH'),(714,'MGPITYG','TYG','MGPI','branch',1,NULL,'2024-05-28 19:25:27','2024-05-28 19:25:27',1,'MULTIGAINED PAWNSHOP INC. - TANYAG BRANCH'),(715,'GRMHILRE','ILRE','GRMH','branch',1,NULL,'2024-05-28 19:27:17','2024-05-28 19:27:17',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - ILUSTRE BRANCH'),(716,'GRMHEVM','EVM','GRMH','branch',1,NULL,'2024-05-28 19:28:37','2024-05-28 19:28:37',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - EVACOM BRANCH'),(717,'TLN4','TLN4','0','branch',1,NULL,'2024-05-28 19:30:35','2024-05-28 19:30:35',0,'TALON 4'),(718,'AJPSTLN4','TLN4','AJPS','branch',1,NULL,'2024-05-28 19:30:51','2024-05-28 19:30:51',1,'ALLEXITE JEWELRY PAWNSHOP INC. - TALON 4'),(719,'GRMHLTR','LTR','GRMH','branch',1,NULL,'2024-05-28 19:33:33','2024-05-28 19:33:33',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - LETRE BRANCH'),(720,'GRMHNGK','NGK','GRMH','branch',1,NULL,'2024-05-28 19:35:34','2024-05-28 19:35:34',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - NANGKA BRANCH'),(721,'GRMHPLC','PLC','GRMH','branch',1,NULL,'2024-05-28 19:36:32','2024-05-28 19:36:32',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - PALANCA BRANCH'),(722,'GRMHPTS','PTS','GRMH','branch',1,NULL,'2024-05-28 19:38:23','2024-05-28 19:38:23',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - PATEROS BRANCH'),(723,'GRMHROS','ROS','GRMH','branch',1,NULL,'2024-05-28 19:45:04','2024-05-28 19:45:04',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - ROSARIO BRANCH'),(724,'GRMHSRL','SRL','GRMH','branch',1,NULL,'2024-05-28 19:45:31','2024-05-28 19:45:31',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - SAN RAFAEL BRANCH'),(725,'GRMHSGL','SGL','GRMH','branch',1,NULL,'2024-05-28 19:46:10','2024-05-28 19:46:10',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - SIGNAL NEW BRANCH'),(726,'GRMHSTD','STD','GRMH','branch',1,NULL,'2024-05-28 19:47:16','2024-05-28 19:47:16',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - STATESIDE PLAZA BRANCH'),(727,'GRMHWSTK','WSTK','GRMH','branch',1,NULL,'2024-05-28 19:50:26','2024-05-28 19:50:26',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - WESTBANK BRANCH'),(728,'VCSR','VCSR','0','branch',1,NULL,'2024-05-28 19:51:55','2024-05-28 19:51:55',0,'VICTORY STA. ROSA BRANCH'),(729,'GAPIVCSR','VCSR','GAPI','branch',1,NULL,'2024-05-28 19:52:29','2024-05-28 19:52:29',1,'GOLDSTAR ATLANTIC PAWNSHOP INC - VICTORY STA. ROSA BRANCH'),(730,'GRMHBUE1','BUE1','GRMH','branch',1,NULL,'2024-05-28 20:01:13','2024-05-28 20:01:13',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - BUENAVISTA 1 BRANCH'),(731,'GRMHBNA2','BNA2','GRMH','branch',1,NULL,'2024-05-28 20:01:35','2024-05-28 20:01:35',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - BUENAVISTA 2 BRANCH'),(732,'LLMA','LLMA','0','branch',1,NULL,'2024-05-28 21:17:01','2024-05-28 21:17:01',0,'LA LOMA BRANCH'),(733,'GRMHCRDO','CRDO','GRMH','branch',1,NULL,'2024-05-28 21:17:27','2024-05-28 21:17:27',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - CARRIEDO BRANCH'),(734,'AJPSLLMA','LLMA','AJPS','branch',1,NULL,'2024-05-28 21:17:28','2024-05-28 21:17:28',1,'ALLEXITE JEWELRY PAWNSHOP INC. - LA LOMA BRANCH'),(735,'GRMHCTNN','CTNN','GRMH','branch',1,NULL,'2024-05-28 21:17:58','2024-05-28 21:17:58',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - CATANUAN BRANCH'),(736,'GRMHCMDAO','CMDAO','GRMH','branch',1,NULL,'2024-05-28 21:19:33','2024-05-28 21:19:33',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - CM DANAO BRANCH'),(737,'GRMHGNL','GNL','GRMH','branch',1,NULL,'2024-05-28 21:21:15','2024-05-28 21:21:15',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - GEN. LUIS BRANCH'),(738,'GRMHGTA3','GTA3','GRMH','branch',1,NULL,'2024-05-28 21:22:02','2024-05-28 21:22:02',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - GLORIETTA 3 BRANCH'),(739,'PNTF','PNTF','0','branch',1,NULL,'2024-05-28 21:23:51','2024-05-28 21:23:51',0,'PUNTA FUEGO BRANCH'),(740,'AJPSPNTF','PNTF','AJPS','branch',1,NULL,'2024-05-28 21:24:08','2024-05-28 21:24:08',1,'ALLEXITE JEWELRY PAWNSHOP INC. - PUNTA FUEGO BRANCH'),(741,'GML','GML','0','branch',1,NULL,'2024-05-28 21:26:45','2024-05-28 21:26:45',0,'GUIMBAL'),(742,'MWPIGML','GML','MWPI','branch',1,NULL,'2024-05-28 21:27:29','2024-05-28 21:27:29',1,'MAXI-WEALTH PAWNSHOP INC. - GUIMBAL BRANCH'),(743,'CGUR','CGUR','0','branch',1,NULL,'2024-05-28 21:32:17','2024-05-28 21:32:17',0,'CARIG SUR'),(744,'MWPICGUR','CGUR','MWPI','branch',1,NULL,'2024-05-28 21:32:35','2024-05-28 21:32:35',1,'MAXI-WEALTH PAWNSHOP INC. - CARIG SUR'),(745,'GRMHMUL','MUL','GRMH','branch',1,NULL,'2024-05-28 21:32:43','2024-05-28 21:32:43',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - MULANAY BRANCH'),(746,'MLGS','MLGS','0','branch',1,NULL,'2024-05-28 21:33:30','2024-05-28 21:33:30',0,'MALA'),(747,'GRMHSBN','SBN','GRMH','branch',1,NULL,'2024-05-28 21:33:41','2024-05-28 21:33:41',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - SAN BENITO BRANCH'),(748,'MBO','MBO','0','branch',1,NULL,'2024-05-28 21:34:55','2024-05-28 21:34:55',0,'MAMBUSAO BRANCH'),(749,'MWPIMBO','MBO','MWPI','branch',1,NULL,'2024-05-28 21:35:15','2024-05-28 21:35:15',1,'MAXI-WEALTH PAWNSHOP INC. - MAMBUSAO BRANCH'),(750,'TVA','TVA','0','branch',1,NULL,'2024-05-28 21:37:46','2024-05-28 21:37:46',0,'TALAVERA BRANCH'),(751,'GRMHSGA','SGA','GRMH','branch',1,NULL,'2024-05-28 21:38:03','2024-05-28 21:38:03',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - SIGMA BRANCH'),(752,'MWPITVA','TVA','MWPI','branch',1,NULL,'2024-05-28 21:38:05','2024-05-28 21:38:05',1,'MAXI-WEALTH PAWNSHOP INC. - TALAVERA BRANCH'),(753,'MLGN','MLGN','0','branch',1,NULL,'2024-05-28 21:38:09','2024-05-28 21:38:09',0,'MALAGASANG BRANCH'),(754,'AJPSMLGN','MLGN','AJPS','branch',1,NULL,'2024-05-28 21:38:38','2024-05-28 21:38:38',1,'ALLEXITE JEWELRY PAWNSHOP INC. - MALAGASANG BRANCH'),(755,'GRMHSPLY','SPLY','GRMH','branch',1,NULL,'2024-05-28 21:39:49','2024-05-28 21:39:49',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - SIPALAY BRANCH'),(756,'TKG','TKG','0','branch',1,NULL,'2024-05-28 21:40:54','2024-05-28 21:40:54',0,'TIKLING BRANCH'),(757,'MWPITKG','TKG','MWPI','branch',1,NULL,'2024-05-28 21:41:11','2024-05-28 21:41:11',1,'MAXI-WEALTH PAWNSHOP INC. - TIKLING BRANCH'),(758,'GRMHUPS','UPS','GRMH','branch',1,NULL,'2024-05-28 21:41:23','2024-05-28 21:41:23',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - UPS 5 BRANCH'),(759,'PSA','PSA','0','branch',1,NULL,'2024-05-28 21:42:59','2024-05-28 21:42:59',0,'PAG ASA BRANCH'),(760,'MWPIPSA','PSA','MWPI','branch',1,NULL,'2024-05-28 21:43:16','2024-05-28 21:43:16',1,'MAXI-WEALTH PAWNSHOP INC. - PAG ASA BRANCH'),(761,'GRMHBCA2','BCA2','GRMH','branch',1,NULL,'2024-05-28 21:44:00','2024-05-28 21:44:00',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - BOCAUE 2 BRANCH'),(762,'GRMHCNNY','CNNY','GRMH','branch',1,NULL,'2024-05-28 21:45:01','2024-05-28 21:45:01',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - CANNERY BRANCH'),(763,'PTA','PTA','0','branch',1,NULL,'2024-05-28 21:45:47','2024-05-28 21:45:47',0,'PORT AREA'),(764,'MWPIPTA','PTA','MWPI','branch',1,NULL,'2024-05-28 21:46:14','2024-05-28 21:46:14',1,'MAXI-WEALTH PAWNSHOP INC. - PORT AREA'),(765,'GRMHCMSR','CMSR','GRMH','branch',1,NULL,'2024-05-28 21:46:23','2024-05-28 21:46:23',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - CM STA ROSA BRANCH'),(766,'TNY','TNY','0','branch',1,NULL,'2024-05-28 21:48:07','2024-05-28 21:48:07',0,'TANAY BRANCH'),(767,'MWPITNY','TNY','MWPI','branch',1,NULL,'2024-05-28 21:48:49','2024-05-28 21:48:49',1,'MAXI-WEALTH PAWNSHOP INC. - TANAY BRANCH'),(768,'GRMHNBN','NBN','GRMH','branch',1,NULL,'2024-05-28 21:50:23','2024-05-28 21:50:23',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - NABUNTURAN BRANCH'),(769,'RTO','RTO','0','branch',1,NULL,'2024-05-28 21:50:28','2024-05-28 21:50:28',0,'RETIRO BRANCH'),(770,'MWPIRTO','RTO','MWPI','branch',1,NULL,'2024-05-28 21:50:57','2024-05-28 21:50:57',1,'MAXI-WEALTH PAWNSHOP INC. - RETIRO BRANCH'),(771,'GRMHNSB','NSB','GRMH','branch',1,NULL,'2024-05-28 21:50:59','2024-05-28 21:50:59',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - NASUGBU BRANCH'),(772,'GRMHPSA','PSA','GRMH','branch',1,NULL,'2024-05-28 21:52:32','2024-05-28 21:52:32',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - PAG ASA BRANCH'),(773,'GRMHTNY','TNY','GRMH','branch',1,NULL,'2024-05-28 21:55:14','2024-05-28 21:55:14',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - TANAY BRANCH'),(774,'SDE','SDE','0','branch',1,NULL,'2024-05-28 21:55:33','2024-05-28 21:55:33',0,'SEASIDE BRANCH'),(775,'MWPISDE','SDE','MWPI','branch',1,NULL,'2024-05-28 21:55:51','2024-05-28 21:55:51',1,'MAXI-WEALTH PAWNSHOP INC. - SEASIDE BRANCH'),(776,'GRMHTKG','TKG','GRMH','branch',1,NULL,'2024-05-28 21:57:03','2024-05-28 21:57:03',1,'GLOBAL RELIANCE MANAGEMENT AND HOLDINGS CORP. - TIKLING BRANCH'),(777,'MSPI','MSPI','0','group',1,NULL,'2024-05-28 21:57:17','2024-05-28 21:57:17',0,'METROGOLD STAR PAWNSHOP INC.'),(778,'CYL','CYL','0','branch',1,NULL,'2024-05-28 22:09:45','2024-05-28 22:09:45',0,'CITYHALL BRANCH'),(779,'MSPICYL','CYL','MSPI','branch',1,NULL,'2024-05-28 22:10:10','2024-05-28 22:10:10',1,'METROGOLD STAR PAWNSHOP INC. - CITYHALL BRANCH'),(780,'SRA','SRA','0','branch',1,NULL,'2024-05-28 22:13:27','2024-05-28 22:13:27',0,'STA RITA BRANCH'),(781,'MSPISRA','SRA','MSPI','branch',1,NULL,'2024-05-28 22:13:47','2024-05-28 22:13:47',1,'METROGOLD STAR PAWNSHOP INC. - STA RITA BRANCH'),(782,'MNDN','MNDN','0','branch',1,NULL,'2024-05-28 22:18:02','2024-05-28 22:18:02',0,'MUNDING BRANCH'),(783,'AJPSMNDN','MNDN','AJPS','branch',1,NULL,'2024-05-28 22:18:22','2024-05-28 22:18:22',1,'ALLEXITE JEWELRY PAWNSHOP INC. - MUNDING BRANCH'),(784,'DME','DME','0','branch',1,NULL,'2024-05-28 22:31:44','2024-05-28 22:31:44',0,'DEL MONTE'),(785,'MSPIDME','DME','MSPI','branch',1,NULL,'2024-05-28 22:32:00','2024-05-28 22:32:00',1,'METROGOLD STAR PAWNSHOP INC. - DEL MONTE'),(786,'ICO','ICO','0','branch',1,NULL,'2024-05-28 22:35:26','2024-05-28 22:35:26',0,'ILAGAN CENTRO BRANCH'),(787,'SNJN','SNJN','0','branch',1,NULL,'2024-05-28 22:36:20','2024-05-28 22:36:20',0,'SAN JUAN'),(788,'MSPIICO','ICO','MSPI','branch',1,NULL,'2024-05-28 22:37:38','2024-05-28 22:37:38',1,'METROGOLD STAR PAWNSHOP INC. - ILAGAN CENTRO BRANCH'),(789,'AJPSSNJN','SNJN','AJPS','branch',1,NULL,'2024-05-28 22:38:47','2024-05-28 22:38:47',1,'ALLEXITE JEWELRY PAWNSHOP INC. - SAN JUAN BR.'),(790,'DHAN','DHAN','0','branch',1,NULL,'2024-05-28 22:47:15','2024-05-28 22:47:15',0,'DIPLAHAN BRANCH'),(791,'MSPIDHAN','DHAN','MSPI','branch',1,NULL,'2024-05-28 22:47:31','2024-05-28 22:47:31',1,'METROGOLD STAR PAWNSHOP INC. - DIPLAHAN BRANCH'),(792,'CNYNY','CNYNY','0','branch',1,NULL,'2024-05-28 22:50:25','2024-05-28 22:50:25',0,'CANAYNAY BRANCH'),(793,'MSPICNYNY','CNYNY','MSPI','branch',1,NULL,'2024-05-28 22:50:44','2024-05-28 22:50:44',1,'METROGOLD STAR PAWNSHOP INC. - CANAYNAY BRANCH'),(794,'DVSR','DVSR','0','branch',1,NULL,'2024-05-28 23:24:24','2024-05-28 23:24:24',0,'DIVISORIA BRANCH'),(795,'AJPSDVSR','DVSR','AJPS','branch',1,NULL,'2024-05-28 23:25:56','2024-05-28 23:25:56',1,'ALLEXITE JEWELRY PAWNSHOP INC. - DIVISORIA BRANCH'),(796,'PGN','PGN','0','branch',1,NULL,'2024-05-28 23:59:19','2024-05-28 23:59:19',0,'PAGADIAN BRANCH'),(797,'MSPIPGN','PGN','MSPI','branch',1,NULL,'2024-05-28 23:59:36','2024-05-28 23:59:36',1,'METROGOLD STAR PAWNSHOP INC. - PAGADIAN BRANCH'),(798,'DMO','DMO','0','branch',1,NULL,'2024-05-29 00:03:49','2024-05-29 00:03:49',0,'DUMALINAO BRANCH'),(799,'MSPIDMO','DMO','MSPI','branch',1,NULL,'2024-05-29 00:04:05','2024-05-29 00:04:05',1,'METROGOLD STAR PAWNSHOP INC. - DUMALINAO BRANCH'),(800,'BBG','BBG','0','branch',1,NULL,'2024-05-29 00:06:47','2024-05-29 00:06:47',0,'BAMBANG BRANCH'),(801,'MSPIBBG','BBG','MSPI','branch',1,NULL,'2024-05-29 00:07:08','2024-05-29 00:07:08',1,'METROGOLD STAR PAWNSHOP INC. - BAMBANG BRANCH'),(802,'HBA','HBA','0','branch',1,NULL,'2024-05-29 00:10:02','2024-05-29 00:10:02',0,'HERBOSA BRANCH'),(803,'MSPIHBA','HBA','MSPI','branch',1,NULL,'2024-05-29 00:10:26','2024-05-29 00:10:26',1,'METROGOLD STAR PAWNSHOP INC. - HERBOSA BRANCH'),(804,'PHLO','PHLO','0','branch',1,NULL,'2024-05-29 00:14:02','2024-05-29 00:14:02',0,'PANGHULO BRANCH'),(805,'MSPIPHLO','PHLO','MSPI','branch',1,NULL,'2024-05-29 00:14:25','2024-05-29 00:14:25',1,'METROGOLD STAR PAWNSHOP INC. - PANGHULO BRANCH'),(806,'CLUI','CLUI','0','branch',1,NULL,'2024-05-29 00:17:38','2024-05-29 00:17:38',0,'CALAMAGUI BRANCH'),(807,'MSPICLUI','CLUI','MSPI','branch',1,NULL,'2024-05-29 00:17:58','2024-05-29 00:17:58',1,'METROGOLD STAR PAWNSHOP INC. - CALAMAGUI BRANCH'),(808,'SRE','SRE','0','branch',1,NULL,'2024-05-29 16:27:51','2024-05-29 16:27:51',0,'SAN ROQUE BRANCH'),(809,'MSPISRE','SRE','MSPI','branch',1,NULL,'2024-05-29 16:28:13','2024-05-29 16:28:13',1,'METROGOLD STAR PAWNSHOP INC. - SAN ROQUE BRANCH'),(810,'CGO','CGO','0','branch',1,NULL,'2024-05-29 16:29:45','2024-05-29 16:29:45',0,'COGEO BRANCH'),(811,'MSPICGO','CGO','MSPI','branch',1,NULL,'2024-05-29 16:30:03','2024-05-29 16:30:03',1,'METROGOLD STAR PAWNSHOP INC. - COGEO BRANCH'),(812,'TGM','TGM','0','branch',1,NULL,'2024-05-29 16:32:17','2024-05-29 16:32:17',0,'TAGUM BRANCH'),(813,'MSPITGM','TGM','MSPI','branch',1,NULL,'2024-05-29 16:32:30','2024-05-29 16:32:30',1,'METROGOLD STAR PAWNSHOP INC. - TAGUM BRANCH'),(814,'PLCB','PLCB','0','branch',1,NULL,'2024-05-29 16:54:07','2024-05-29 16:54:07',0,'PALICO BRANCH'),(815,'AJPSPLCB','PLCB','AJPS','branch',1,NULL,'2024-05-29 17:05:09','2024-05-29 17:05:09',1,'ALLEXITE JEWELRY PAWNSHOP INC. - PALICO BRANCH'),(816,'DSG','DSG','0','branch',1,NULL,'2024-05-30 21:46:29','2024-05-30 21:46:29',0,'DIMASALANG BRANCH'),(817,'KKPIDSG','DSG','KKPI','branch',1,NULL,'2024-05-30 21:46:51','2024-05-30 21:46:51',1,'KRYPTON KNIGHT PAWNSHOP INC. - DIMASALANG BRANCH'),(818,'ABO','ABO','0','branch',1,NULL,'2024-05-30 21:49:21','2024-05-30 21:49:21',0,'ARZOBISPADO'),(819,'DHA','DHA','0','branch',1,NULL,'2024-05-30 21:56:32','2024-05-30 21:56:32',0,'DAHLIA'),(820,'FRN','FRN','0','branch',1,NULL,'2024-05-30 22:01:11','2024-05-30 22:01:11',0,'FEREIN'),(821,'AIA','AIA','0','branch',1,NULL,'2024-05-30 22:04:16','2024-05-30 22:04:16',0,'ALICIA BRANCH'),(822,'MDO','MDO','0','branch',1,NULL,'2024-05-30 22:06:07','2024-05-30 22:06:07',0,'MINDANAO AVE.'),(823,'JPR','JPR','0','branch',1,NULL,'2024-05-30 22:07:04','2024-05-30 22:07:04',0,'J.P. RIZAL BRANCH'),(824,'ACL','ACL','0','branch',1,NULL,'2024-05-30 22:13:31','2024-05-30 22:13:31',0,'ALCALA'),(825,'GTN','GTN','0','branch',1,NULL,'2024-05-30 22:22:09','2024-05-30 22:22:09',0,'GATTARAN'),(826,'GTZ','GTZ','0','branch',1,NULL,'2024-05-30 22:25:25','2024-05-30 22:25:25',0,'G. TUAZON'),(827,'CTA','CTA','0','branch',1,NULL,'2024-05-30 22:33:34','2024-05-30 22:33:34',0,'CALATRAVA'),(828,'SSS','SSS','0','branch',1,NULL,'2024-05-30 22:36:33','2024-05-30 22:36:33',0,'SSS PANORAMA BRANCH'),(829,'CBN','CBN','0','branch',1,NULL,'2024-05-30 22:38:28','2024-05-30 22:38:28',0,'CABAGAN'),(830,'TMI','TMI','0','branch',1,NULL,'2024-05-30 22:38:37','2024-05-30 22:38:37',0,'TUMAUINI'),(831,'MRO2','MRO2','0','branch',1,NULL,'2024-05-30 22:42:13','2024-05-30 22:42:13',0,'MARILAO 2'),(832,'TPZ','TPZ','0','branch',1,NULL,'2024-05-30 22:43:12','2024-05-30 22:43:12',0,'TAPAZ BRANCH'),(833,'VMC','VMC','0','branch',1,NULL,'2024-05-30 22:44:51','2024-05-30 22:44:51',0,'VICTORY MALL CALOOCAN'),(834,'PRL','PRL','0','branch',1,NULL,'2024-05-30 22:47:56','2024-05-30 22:47:56',0,'PEARL DRIVE'),(835,'DLG','DLG','0','branch',1,NULL,'2024-05-30 22:49:54','2024-05-30 22:49:54',0,'DUMALAG'),(836,'ATP1','ATP1','0','branch',1,NULL,'2024-05-30 22:53:01','2024-05-30 22:53:01',0,'ANTIPOLO 1'),(837,'IPL1','IPL1','0','branch',1,NULL,'2024-05-30 22:53:14','2024-05-30 22:53:14',0,'IPIL 1 BRANCH'),(838,'AUR','AUR','0','branch',1,NULL,'2024-05-30 22:55:26','2024-05-30 22:55:26',0,'AURORA'),(839,'BLG','BLG','0','branch',1,NULL,'2024-05-30 22:57:46','2024-05-30 22:57:46',0,'BISLIG BRANCH'),(840,'BOC1','BOC1','0','branch',1,NULL,'2024-05-30 22:59:20','2024-05-30 22:59:20',0,'BOCAUE 1'),(841,'KGPIJPR','JPR','KGPI','branch',1,NULL,'2024-05-30 23:22:42','2024-05-30 23:22:42',1,'KRISTAL CLEAR DIAMOND & GOLD PAWNSHOP INC. - J.P. RIZAL BRANCH'),(842,'KGPIACL','ACL','KGPI','branch',1,NULL,'2024-05-30 23:23:19','2024-05-30 23:23:19',1,'KRISTAL CLEAR DIAMOND & GOLD PAWNSHOP INC. - ALCALA BRANCH'),(843,'KGPIGTN','GTN','KGPI','branch',1,NULL,'2024-05-30 23:23:40','2024-05-30 23:23:40',1,'KRISTAL CLEAR DIAMOND & GOLD PAWNSHOP INC. - GATTARAN BRANCH'),(844,'KGPISSS','SSS','KGPI','branch',1,NULL,'2024-05-30 23:24:43','2024-05-30 23:24:43',1,'KRISTAL CLEAR DIAMOND & GOLD PAWNSHOP INC. - SSS PANORAMA BRANCH'),(845,'KGPICBN','CBN','KGPI','branch',1,NULL,'2024-05-30 23:25:55','2024-05-30 23:25:55',1,'KRISTAL CLEAR DIAMOND & GOLD PAWNSHOP INC. - CABAGAN BRANCH'),(846,'KGPITPZ','TPZ','KGPI','branch',1,NULL,'2024-05-30 23:26:20','2024-05-30 23:26:20',1,'KRISTAL CLEAR DIAMOND & GOLD PAWNSHOP INC. - TAPAZ BRANCH'),(847,'KGPIDLG','DLG','KGPI','branch',1,NULL,'2024-05-30 23:26:41','2024-05-30 23:26:41',1,'KRISTAL CLEAR DIAMOND & GOLD PAWNSHOP INC. - DUMALAG BRANCH'),(848,'KGPIAIA','AIA','KGPI','branch',1,NULL,'2024-05-30 23:27:27','2024-05-30 23:27:27',1,'KRISTAL CLEAR DIAMOND & GOLD PAWNSHOP INC. - ALICIA BRANCH'),(849,'KGPIBLG','BLG','KGPI','branch',1,NULL,'2024-05-30 23:29:15','2024-05-30 23:29:15',1,'KRISTAL CLEAR DIAMOND & GOLD PAWNSHOP INC. - BISLIG BRANCH'),(850,'KGPIIPL1','IPL1','KGPI','branch',1,NULL,'2024-05-30 23:30:14','2024-05-30 23:30:14',1,'KRISTAL CLEAR DIAMOND & GOLD PAWNSHOP INC. - IPIL 1 BRANCH'),(851,'CLM2','CLM2','0','branch',1,NULL,'2024-05-30 23:36:21','2024-05-30 23:36:21',0,'CALUMPANG 2 BRANCH'),(852,'LBN','LBN','0','branch',1,NULL,'2024-05-30 23:39:51','2024-05-30 23:39:51',0,'LABANGON BRANCH'),(853,'MBY1','MBY1','0','branch',1,NULL,'2024-05-30 23:48:15','2024-05-30 23:48:15',0,'MABUHAY 1 BRANCH'),(854,'PSK','PSK','0','branch',1,NULL,'2024-05-30 23:51:11','2024-05-30 23:51:11',0,'PUSOK BRANCH'),(855,'RXS','RXS','0','branch',1,NULL,'2024-05-30 23:53:35','2024-05-30 23:53:35',0,'ROXAS ISABELA BRANCH'),(856,'SMT','SMT','0','branch',1,NULL,'2024-05-30 23:56:08','2024-05-30 23:56:08',0,'SAN MATEO BRANCH'),(857,'BGO2','BGO2','0','branch',1,NULL,'2024-05-30 23:59:57','2024-05-30 23:59:57',0,'BAGUIO 2 BRANCH'),(858,'BJC','BJC','0','branch',1,NULL,'2024-05-31 00:03:41','2024-05-31 00:03:41',0,'BAJAC-BAJAC BRANCH'),(859,'BAL','BAL','0','branch',1,NULL,'2024-05-31 00:06:56','2024-05-31 00:06:56',0,'BALANGA NEW BRANCH'),(860,'GJPIATP1','ATP1','GJPI','branch',1,NULL,'2024-05-31 00:07:42','2024-05-31 00:07:42',1,'GREEN AMBER JEWELRY AND PAWNSHOP INC. - ANTIPOLO 1 BRANCH'),(861,'GJPIAUR','AUR','GJPI','branch',1,NULL,'2024-05-31 00:08:02','2024-05-31 00:08:02',1,'GREEN AMBER JEWELRY AND PAWNSHOP INC. - AURORA BRANCH'),(862,'GJPIBOC1','BOC1','GJPI','branch',1,NULL,'2024-05-31 00:08:18','2024-05-31 00:08:18',1,'GREEN AMBER JEWELRY AND PAWNSHOP INC. - BOCAUE 1 BRANCH'),(863,'GJPICLM2','CLM2','GJPI','branch',1,NULL,'2024-05-31 00:08:34','2024-05-31 00:08:34',1,'GREEN AMBER JEWELRY AND PAWNSHOP INC. - CALUMPANG 2 BRANCH'),(864,'GJPILBN','LBN','GJPI','branch',1,NULL,'2024-05-31 00:08:45','2024-05-31 00:08:45',1,'GREEN AMBER JEWELRY AND PAWNSHOP INC. - LABANGON BRANCH'),(865,'GJPIMBY1','MBY1','GJPI','branch',1,NULL,'2024-05-31 00:09:02','2024-05-31 00:09:02',1,'GREEN AMBER JEWELRY AND PAWNSHOP INC. - MABUHAY 1 BRANCH'),(866,'GJPIPSK','PSK','GJPI','branch',1,NULL,'2024-05-31 00:09:49','2024-05-31 00:09:49',1,'GREEN AMBER JEWELRY AND PAWNSHOP INC. - PUSOK BRANCH'),(867,'GJPIRXS','RXS','GJPI','branch',1,NULL,'2024-05-31 00:10:03','2024-05-31 00:10:03',1,'GREEN AMBER JEWELRY AND PAWNSHOP INC. - ROXAS ISABELA BRANCH'),(868,'GJPISMT','SMT','GJPI','branch',1,NULL,'2024-05-31 00:10:21','2024-05-31 00:10:21',1,'GREEN AMBER JEWELRY AND PAWNSHOP INC. - SAN MATEO BRANCH'),(869,'GJPIBGO2','BGO2','GJPI','branch',1,NULL,'2024-05-31 00:10:43','2024-05-31 00:10:43',1,'GREEN AMBER JEWELRY AND PAWNSHOP INC. - BAGUIO 2 BRANCH'),(870,'GJPIBJC','BJC','GJPI','branch',1,NULL,'2024-05-31 00:10:58','2024-05-31 00:10:58',1,'GREEN AMBER JEWELRY AND PAWNSHOP INC. - BAJAC-BAJAC BRANCH'),(871,'GJPIBAL','BAL','GJPI','branch',1,NULL,'2024-05-31 00:11:12','2024-05-31 00:11:12',1,'GREEN AMBER JEWELRY AND PAWNSHOP INC. - BALANGA NEW BRANCH'),(872,'MMPIABO','ABO','MMPI','branch',1,NULL,'2024-05-31 00:12:12','2024-05-31 00:12:12',1,'MONEYMAX PAWNSHOP INC. - ARZOBISPADO BRANCH'),(873,'MMPIDHA','DHA','MMPI','branch',1,NULL,'2024-05-31 00:12:30','2024-05-31 00:12:30',1,'MONEYMAX PAWNSHOP INC. - DAHLIA BRANCH'),(874,'MMPIFRN','FRN','MMPI','branch',1,NULL,'2024-05-31 00:12:45','2024-05-31 00:12:45',1,'MONEYMAX PAWNSHOP INC. - FEREIN BRANCH'),(875,'MMPIMDO','MDO','MMPI','branch',1,NULL,'2024-05-31 00:13:02','2024-05-31 00:13:02',1,'MONEYMAX PAWNSHOP INC. - MINDANAO AVE. BRANCH'),(876,'MMPIGTZ','GTZ','MMPI','branch',1,NULL,'2024-05-31 00:13:24','2024-05-31 00:13:24',1,'MONEYMAX PAWNSHOP INC. - G. TUAZON BRANCH'),(877,'MMPICTV','CTV','MMPI','branch',1,'2024-05-31 08:17:03','2024-05-31 00:14:58','2024-05-31 00:17:03',1,'MONEYMAX PAWNSHOP INC. - CALATRAVA BRANCH'),(878,'MMPITMI','TMI','MMPI','branch',1,NULL,'2024-05-31 00:16:52','2024-05-31 00:16:52',1,'MONEYMAX PAWNSHOP INC. - TUMAUINI BRANCH'),(879,'MMPIMRO2','MRO2','MMPI','branch',1,NULL,'2024-05-31 00:17:10','2024-05-31 00:17:10',1,'MONEYMAX PAWNSHOP INC. - MARILAO 2 BRANCH'),(880,'MMPICTA','CTA','MMPI','branch',1,NULL,'2024-05-31 00:17:40','2024-05-31 00:17:40',1,'MONEYMAX PAWNSHOP INC. - CALATRAVA BRANCH'),(881,'MMPIVMC','VMC','MMPI','branch',1,NULL,'2024-05-31 00:18:03','2024-05-31 00:18:03',1,'MONEYMAX PAWNSHOP INC. - VICTORY MALL CALOOCAN BRANCH'),(882,'MMPIPRL','PRL','MMPI','branch',1,NULL,'2024-05-31 00:18:23','2024-05-31 00:18:23',1,'MONEYMAX PAWNSHOP INC. - PEARL DRIVE BRANCH');

--
-- Table structure for table `tbl_payment_terms`
--

CREATE TABLE `tbl_payment_terms` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `range` int(11) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tbl_payment_terms_code_unique` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_payment_terms`
--


--
-- Table structure for table `tbl_setup`
--

CREATE TABLE `tbl_setup` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `category` varchar(255) DEFAULT NULL,
  `value1` varchar(255) DEFAULT NULL,
  `value2` varchar(255) DEFAULT NULL,
  `value3` varchar(255) DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tbl_setup_code_index` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_setup`
--


--
-- Table structure for table `tbl_subsidiary_ledger`
--

CREATE TABLE `tbl_subsidiary_ledger` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `acc_code` varchar(255) NOT NULL,
  `sl_code` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `desc` varchar(255) NOT NULL,
  `normal_balance` varchar(255) NOT NULL,
  `map_table` varchar(255) DEFAULT NULL,
  `map_column` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tbl_subsidiary_ledger_acc_code_index` (`acc_code`),
  KEY `tbl_subsidiary_ledger_sl_code_index` (`sl_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_subsidiary_ledger`
--


--
-- Table structure for table `tbl_subsidiary_ledgers`
--

CREATE TABLE `tbl_subsidiary_ledgers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `gl_id` varchar(255) NOT NULL,
  `gl_code` varchar(255) DEFAULT NULL,
  `sl_code` varchar(255) NOT NULL,
  `transaction_date` date NOT NULL,
  `posted_date` datetime DEFAULT NULL,
  `acc_code` varchar(255) NOT NULL,
  `debit_credit` varchar(255) NOT NULL,
  `amount` decimal(18,2) DEFAULT 0.00,
  `beginning_balance` decimal(18,2) DEFAULT 0.00,
  `ending_balance` decimal(18,2) DEFAULT 0.00,
  `particulars` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tbl_subsidiary_ledgers_gl_id_index` (`gl_id`),
  KEY `tbl_subsidiary_ledgers_gl_code_index` (`gl_code`),
  KEY `tbl_subsidiary_ledgers_sl_code_index` (`sl_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_subsidiary_ledgers`
--


--
-- Table structure for table `tbl_taxes`
--

CREATE TABLE `tbl_taxes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `value` decimal(10,4) NOT NULL,
  `description` varchar(255) NOT NULL,
  `treatment` varchar(255) NOT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `status` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tbl_taxes_code_index` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_taxes`
--


--
-- Table structure for table `tbl_templates`
--

CREATE TABLE `tbl_templates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `temp_code` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tbl_templates_code_unique` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_templates`
--


--
-- Table structure for table `tbl_templates_details`
--

CREATE TABLE `tbl_templates_details` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `template_code` varchar(255) NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `category` varchar(255) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `sub_category` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `tbl_templates_details`
--


--
-- Table structure for table `tbl_transaction_codes`
--

CREATE TABLE `tbl_transaction_codes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tbl_transaction_codes_code_unique` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_transaction_codes`
--


--
-- Table structure for table `tbl_transaction_details`
--

CREATE TABLE `tbl_transaction_details` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `trans_code` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tbl_transaction_details_trans_code_index` (`trans_code`),
  KEY `tbl_transaction_details_code_index` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_transaction_details`
--


--
-- Table structure for table `tbl_transaction_history`
--

CREATE TABLE `tbl_transaction_history` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `date_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `transaction_id` varchar(255) NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `details` text DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `tbl_transaction_history`
--


--
-- Table structure for table `tbl_transaction_settings`
--

CREATE TABLE `tbl_transaction_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `transaction` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `columnCount` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tbl_transaction_settings_code_unique` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_transaction_settings`
--


--
-- Table structure for table `tbl_transaction_settings_details`
--

CREATE TABLE `tbl_transaction_settings_details` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `trans_code` varchar(255) NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `category` varchar(255) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `sub_category` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `tbl_transaction_settings_details`
--


--
-- Table structure for table `tbl_transactions`
--

CREATE TABLE `tbl_transactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `series` varchar(255) NOT NULL,
  `branch` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `checked_by` varchar(255) DEFAULT NULL,
  `approved_by` varchar(255) DEFAULT NULL,
  `posted_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tbl_transactions_code_unique` (`code`),
  UNIQUE KEY `tbl_transactions_series_unique` (`series`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_transactions`
--



