--
-- Host: localhost    Database: ftlp_acctg
-- ------------------------------------------------------


--
-- Table structure for table `tbl_journal`
--

CREATE TABLE `tbl_journal` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `entry_date` date NOT NULL,
  `transaction_date` date NOT NULL,
  `entity` varchar(255) NOT NULL,
  `reference_number` varchar(255) DEFAULT NULL,
  `amount` decimal(18,2) DEFAULT 0.00,
  `particulars` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `posted_by` varchar(255) DEFAULT NULL,
  `created_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_journal_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_journal`
--

INSERT INTO `tbl_journal` VALUES
(1,'JE2024000001','journal','2024-01-01','2024-01-01','NA','JV-202405-0001',23975449.00,'Global Reliance - Beginning Balance','posted','admin','admin',NULL,'2024-05-28 12:18:37','2024-05-28 12:21:07'),
(2,'JE2024000002','journal','2024-01-01','2024-01-01','NA','JV-202405-0002',58539168.00,'Princess Cut - Beginning Balance','posted','admin','admin',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(3,'JE2024000003','journal','2024-05-31','2024-01-01','NA','JV-202405-0003',29773014.56,'Interworld Gem - Beginning Balance','posted','admin','admin',NULL,'2024-05-30 17:03:22','2024-05-30 17:21:52'),
(4,'JE2024000004','journal','2024-05-31','2024-01-01','NA','JV-202405-0004',30944751.50,'Superpledge Pawnshop - Beginning Balance','posted','admin','admin',NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(5,'JE2024000005','journal','2024-05-31','2024-01-01','NA','JV-202405-0005',38825535.28,'AsiaPhil Star - Beginning Balance','posted','admin','admin',NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(6,'JE2024000006','journal','2024-05-31','2024-01-01','NA','JV-202405-0006',22171850.55,'Multigained Pawnshop - Beginning Balance','posted','admin','admin',NULL,'2024-05-31 08:32:01','2024-05-31 08:32:01'),
(7,'JE2024000007','journal','2024-05-31','2024-01-01','NA','JV-202405-0007',54791041.32,'Silverstar Jewelry - Beginning Balance','posted','admin','admin',NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(8,'JE2024000008','journal','2024-05-31','2024-01-01','NA','JV-202405-0008',26113331.56,'Puregold Karat - Beginning Balance','posted','admin','admin',NULL,'2024-05-31 09:31:44','2024-05-31 09:31:44'),
(9,'JE2024000009','journal','2024-05-31','2024-01-01','NA','JV-202405-0009',14001710.00,'Gallium Granite - Beginning Balance','posted','admin','admin',NULL,'2024-05-31 09:39:30','2024-05-31 09:39:30'),
(10,'JE2024000010','journal','2024-05-31','2024-01-01','NA','JV-202405-0010',35187549.15,'Moneymax - Beginning Balance','posted','admin','admin',NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(11,'JE2024000011','journal','2024-05-31','2024-01-01','NA','JV-202405-0011',23918166.00,'San Ramon Platinum - Beginning Balance','posted','admin','admin',NULL,'2024-05-31 13:49:06','2024-05-31 13:49:06'),
(12,'JE2024000012','journal','2024-05-31','2024-01-01','NA','JV-202405-0012',29846399.00,'San Sebastian - Beginning Balance','posted','admin','admin',NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(13,'JE2024000013','journal','2024-05-31','2024-01-01','NA','JV-202405-0013',27950219.00,'North Western Pacific - Beginning Balance','posted','admin','admin',NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(14,'JE2024000014','journal','2024-05-31','2024-01-01','NA','JV-202405-0014',20390987.00,'Saint Barbara Prime - Beginning Balance','posted','admin','admin',NULL,'2024-05-31 14:22:55','2024-05-31 14:22:55'),
(15,'JE2024000015','journal','2024-05-31','2024-01-01','NA','JV-202405-0015',55660263.09,'Yellow Endurance - Beginning Balance','posted','admin','admin',NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38');

--
-- Table structure for table `tbl_general_ledgers`
--

CREATE TABLE `tbl_general_ledgers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) DEFAULT NULL,
  `journal_code` varchar(255) NOT NULL,
  `transaction_date` date DEFAULT NULL,
  `posted_date` datetime DEFAULT NULL,
  `acc_code` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT 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,
  `branch` varchar(255) DEFAULT NULL,
  `group` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `posted_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_general_ledgers_code_unique` (`code`),
  KEY `tbl_general_ledgers_acc_code_index` (`acc_code`)
) ENGINE=InnoDB AUTO_INCREMENT=390 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_general_ledgers`
--

INSERT INTO `tbl_general_ledgers` VALUES
(22,'GL2024000001','JE2024000001','2024-01-01','2024-01-01 00:00:00','102-0000',NULL,'Dr',5326505.00,0.00,5326505.00,'LEV','GRMH','posted',NULL,NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(23,'GL2024000002','JE2024000001','2024-01-01','2024-01-01 00:00:00','301-0000',NULL,'Dr',3635075.00,0.00,3635075.00,'LEV','GRMH','posted',NULL,NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(24,'GL2024000003','JE2024000001','2024-01-01','2024-01-01 00:00:00','201-0000',NULL,'Dr',22780.00,0.00,22780.00,'LEV','GRMH','posted',NULL,NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(25,'GL2024000004','JE2024000001','2024-01-01','2024-01-01 00:00:00','702-0000',NULL,'Dr',14991089.00,0.00,-14991089.00,'LEV','GRMH','posted',NULL,NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(26,'GL2024000005','JE2024000001','2024-01-01','2024-01-01 00:00:00','202-0000',NULL,'Cr',22780.00,0.00,-22780.00,'LEV','GRMH','posted',NULL,NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(27,'GL2024000006','JE2024000001','2024-01-01','2024-01-01 00:00:00','402-0000',NULL,'Cr',10000000.00,0.00,10000000.00,'LEV','GRMH','posted',NULL,NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(28,'GL2024000007','JE2024000001','2024-01-01','2024-01-01 00:00:00','406-0000',NULL,'Cr',100.00,0.00,100.00,'LEV','GRMH','posted',NULL,NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(29,'GL2024000008','JE2024000001','2024-01-01','2024-01-01 00:00:00','407-0000',NULL,'Cr',100732.50,0.00,100732.50,'LEV','GRMH','posted',NULL,NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(30,'GL2024000009','JE2024000001','2024-01-01','2024-01-01 00:00:00','408-0000',NULL,'Cr',215817.50,0.00,215817.50,'LEV','GRMH','posted',NULL,NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(31,'GL2024000010','JE2024000001','2024-01-01','2024-01-01 00:00:00','411-0000',NULL,'Cr',16300.00,0.00,16300.00,'LEV','GRMH','posted',NULL,NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(32,'GL2024000011','JE2024000001','2024-01-01','2024-01-01 00:00:00','412-0000',NULL,'Cr',16200.00,0.00,16200.00,'LEV','GRMH','posted',NULL,NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(33,'GL2024000012','JE2024000001','2024-01-01','2024-01-01 00:00:00','601-0000',NULL,'Cr',1600000.00,0.00,1600000.00,'LEV','GRMH','posted',NULL,NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(34,'GL2024000013','JE2024000001','2024-01-01','2024-01-01 00:00:00','605-0000',NULL,'Cr',5500000.00,0.00,5500000.00,'LEV','GRMH','posted',NULL,NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(35,'GL2024000014','JE2024000001','2024-01-01','2024-01-01 00:00:00','413-0000',NULL,'Cr',16319.12,0.00,16319.12,'LEV','GRMH','posted',NULL,NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(36,'GL2024000015','JE2024000001','2024-01-01','2024-01-01 00:00:00','405-0000',NULL,'Cr',302.63,0.00,302.63,'LEV','GRMH','posted',NULL,NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(37,'GL2024000016','JE2024000001','2024-01-01','2024-01-01 00:00:00','409-0000',NULL,'Cr',44792.54,0.00,44792.54,'LEV','GRMH','posted',NULL,NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(38,'GL2024000017','JE2024000001','2024-01-01','2024-01-01 00:00:00','410-0000',NULL,'Cr',44792.25,0.00,44792.25,'LEV','GRMH','posted',NULL,NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(39,'GL2024000018','JE2024000001','2024-01-01','2024-01-01 00:00:00','414-0000',NULL,'Cr',46774.69,0.00,46774.69,'LEV','GRMH','posted',NULL,NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(40,'GL2024000019','JE2024000001','2024-01-01','2024-01-01 00:00:00','401-0000',NULL,'Cr',5642688.57,0.00,5642688.57,'LEV','GRMH','posted',NULL,NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(41,'GL2024000020','JE2024000001','2024-01-01','2024-01-01 00:00:00','419-0000',NULL,'Cr',707849.20,0.00,707849.20,'LEV','GRMH','posted',NULL,NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(42,'GL2024000021','JE2024000002','2024-01-01','2024-01-01 00:00:00','101-0000',NULL,'Dr',647757.00,0.00,647757.00,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(43,'GL2024000022','JE2024000002','2024-01-01','2024-01-01 00:00:00','104-0000',NULL,'Dr',11119500.00,0.00,11119500.00,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(44,'GL2024000023','JE2024000002','2024-01-01','2024-01-01 00:00:00','106-0000',NULL,'Dr',262000.00,0.00,262000.00,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(45,'GL2024000024','JE2024000002','2024-01-01','2024-01-01 00:00:00','107-0000',NULL,'Dr',642825.00,0.00,642825.00,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(46,'GL2024000025','JE2024000002','2024-01-01','2024-01-01 00:00:00','201-0000',NULL,'Dr',2260000.00,22780.00,2282780.00,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(47,'GL2024000026','JE2024000002','2024-01-01','2024-01-01 00:00:00','203-0000',NULL,'Dr',900000.00,0.00,900000.00,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(48,'GL2024000027','JE2024000002','2024-01-01','2024-01-01 00:00:00','205-0000',NULL,'Dr',36000.00,0.00,36000.00,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(49,'GL2024000028','JE2024000002','2024-01-01','2024-01-01 00:00:00','702-0000',NULL,'Dr',42671086.00,-14991089.00,-57662175.00,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(50,'GL2024000029','JE2024000002','2024-01-01','2024-01-01 00:00:00','202-0000',NULL,'Cr',2260000.00,-22780.00,-2282780.00,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(51,'GL2024000030','JE2024000002','2024-01-01','2024-01-01 00:00:00','204-0000',NULL,'Cr',900000.00,0.00,-900000.00,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(52,'GL2024000031','JE2024000002','2024-01-01','2024-01-01 00:00:00','206-0000',NULL,'Cr',36000.00,0.00,-36000.00,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(53,'GL2024000032','JE2024000002','2024-01-01','2024-01-01 00:00:00','401-0000',NULL,'Cr',15581061.00,5642688.57,21223749.57,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(54,'GL2024000033','JE2024000002','2024-01-01','2024-01-01 00:00:00','402-0000',NULL,'Cr',14351100.00,10000000.00,24351100.00,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(55,'GL2024000034','JE2024000002','2024-01-01','2024-01-01 00:00:00','403-0000',NULL,'Cr',13008.00,0.00,13008.00,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(56,'GL2024000035','JE2024000002','2024-01-01','2024-01-01 00:00:00','405-0000',NULL,'Cr',8351.00,302.63,8653.63,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(57,'GL2024000036','JE2024000002','2024-01-01','2024-01-01 00:00:00','406-0000',NULL,'Cr',400.00,100.00,500.00,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(58,'GL2024000037','JE2024000002','2024-01-01','2024-01-01 00:00:00','407-0000',NULL,'Cr',19778.00,100732.50,120510.50,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(59,'GL2024000038','JE2024000002','2024-01-01','2024-01-01 00:00:00','408-0000',NULL,'Cr',42353.00,215817.50,258170.50,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(60,'GL2024000039','JE2024000002','2024-01-01','2024-01-01 00:00:00','409-0000',NULL,'Cr',8774.00,44792.54,53566.54,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(61,'GL2024000040','JE2024000002','2024-01-01','2024-01-01 00:00:00','410-0000',NULL,'Cr',8773.00,44792.25,53565.25,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(62,'GL2024000041','JE2024000002','2024-01-01','2024-01-01 00:00:00','411-0000',NULL,'Cr',3200.00,16300.00,19500.00,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(63,'GL2024000042','JE2024000002','2024-01-01','2024-01-01 00:00:00','412-0000',NULL,'Cr',3200.00,16200.00,19400.00,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(64,'GL2024000043','JE2024000002','2024-01-01','2024-01-01 00:00:00','413-0000',NULL,'Cr',4666.00,16319.12,20985.12,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(65,'GL2024000044','JE2024000002','2024-01-01','2024-01-01 00:00:00','414-0000',NULL,'Cr',1061.00,46774.69,47835.69,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(66,'GL2024000045','JE2024000002','2024-01-01','2024-01-01 00:00:00','415-0000',NULL,'Cr',87596.00,0.00,87596.00,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(67,'GL2024000046','JE2024000002','2024-01-01','2024-01-01 00:00:00','416-0000',NULL,'Cr',29847.00,0.00,29847.00,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(68,'GL2024000047','JE2024000002','2024-01-01','2024-01-01 00:00:00','501-0000',NULL,'Cr',2180000.00,0.00,2180000.00,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(69,'GL2024000048','JE2024000002','2024-01-01','2024-01-01 00:00:00','602-0000',NULL,'Cr',1000000.00,0.00,1000000.00,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(70,'GL2024000049','JE2024000002','2024-01-01','2024-01-01 00:00:00','605-0000',NULL,'Cr',22000000.00,5500000.00,27500000.00,'BF1','PJPI','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(95,'GL2024000050','JE2024000003','2024-01-01','2024-01-01 00:00:00','104-0000',NULL,'Dr',9653900.00,0.00,9653900.00,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(96,'GL2024000051','JE2024000003','2024-01-01','2024-01-01 00:00:00','101-0000',NULL,'Dr',1245281.25,0.00,1245281.25,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(97,'GL2024000052','JE2024000003','2024-01-01','2024-01-01 00:00:00','107-0000',NULL,'Dr',164211.53,0.00,164211.53,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(98,'GL2024000053','JE2024000003','2024-01-01','2024-01-01 00:00:00','201-0000',NULL,'Dr',925234.83,0.00,925234.83,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(99,'GL2024000054','JE2024000003','2024-01-01','2024-01-01 00:00:00','702-0000',NULL,'Dr',17784386.95,0.00,-17784386.95,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(100,'GL2024000055','JE2024000003','2024-01-01','2024-01-01 00:00:00','402-0000',NULL,'Cr',17230100.00,0.00,17230100.00,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(101,'GL2024000056','JE2024000003','2024-01-01','2024-01-01 00:00:00','406-0000',NULL,'Cr',425.00,0.00,425.00,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(102,'GL2024000057','JE2024000003','2024-01-01','2024-01-01 00:00:00','407-0000',NULL,'Cr',6570.00,0.00,6570.00,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(103,'GL2024000058','JE2024000003','2024-01-01','2024-01-01 00:00:00','408-0000',NULL,'Cr',13870.00,0.00,13870.00,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(104,'GL2024000059','JE2024000003','2024-01-01','2024-01-01 00:00:00','411-0000',NULL,'Cr',1000.00,0.00,1000.00,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(105,'GL2024000060','JE2024000003','2024-01-01','2024-01-01 00:00:00','412-0000',NULL,'Cr',1000.00,0.00,1000.00,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(106,'GL2024000061','JE2024000003','2024-01-01','2024-01-01 00:00:00','413-0000',NULL,'Cr',2883.80,0.00,2883.80,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(107,'GL2024000062','JE2024000003','2024-01-01','2024-01-01 00:00:00','414-0000',NULL,'Cr',5563.47,0.00,5563.47,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(108,'GL2024000063','JE2024000003','2024-01-01','2024-01-01 00:00:00','415-0000',NULL,'Cr',184873.00,0.00,184873.00,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(109,'GL2024000064','JE2024000003','2024-01-01','2024-01-01 00:00:00','416-0000',NULL,'Cr',40180.30,0.00,40180.30,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(110,'GL2024000065','JE2024000003','2024-01-01','2024-01-01 00:00:00','603-0000',NULL,'Cr',400000.00,0.00,400000.00,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(111,'GL2024000066','JE2024000003','2024-01-01','2024-01-01 00:00:00','605-0000',NULL,'Cr',10600000.00,0.00,10600000.00,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(112,'GL2024000067','JE2024000003','2024-01-01','2024-01-01 00:00:00','417-0000',NULL,'Cr',328423.06,0.00,328423.06,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(113,'GL2024000068','JE2024000003','2024-01-01','2024-01-01 00:00:00','202-0000',NULL,'Cr',925234.83,0.00,-925234.83,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(114,'GL2024000069','JE2024000003','2024-01-01','2024-01-01 00:00:00','403-0000',NULL,'Cr',13816.80,0.00,13816.80,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(115,'GL2024000070','JE2024000003','2024-01-01','2024-01-01 00:00:00','405-0000',NULL,'Cr',13160.96,0.00,13160.96,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(116,'GL2024000071','JE2024000003','2024-01-01','2024-01-01 00:00:00','421-0000',NULL,'Cr',121.94,0.00,121.94,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(117,'GL2024000072','JE2024000003','2024-01-01','2024-01-01 00:00:00','409-0000',NULL,'Cr',2895.73,0.00,2895.73,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(118,'GL2024000073','JE2024000003','2024-01-01','2024-01-01 00:00:00','410-0000',NULL,'Cr',2895.67,0.00,2895.67,'VAN','IWGPI','posted',NULL,NULL,'2024-05-30 17:21:52','2024-05-30 17:21:52'),
(119,'GL2024000074','JE2024000004','2024-01-01','2024-01-01 00:00:00','101-0000',NULL,'Dr',883402.92,0.00,883402.92,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(120,'GL2024000075','JE2024000004','2024-01-01','2024-01-01 00:00:00','104-0000',NULL,'Dr',7309150.00,0.00,7309150.00,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(121,'GL2024000076','JE2024000004','2024-01-01','2024-01-01 00:00:00','201-0000',NULL,'Dr',220000.00,0.00,220000.00,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(122,'GL2024000077','JE2024000004','2024-01-01','2024-01-01 00:00:00','203-0000',NULL,'Dr',63758.75,0.00,63758.75,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(123,'GL2024000078','JE2024000004','2024-01-01','2024-01-01 00:00:00','702-0000',NULL,'Dr',22398607.25,0.00,-22398607.25,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(124,'GL2024000079','JE2024000004','2024-01-01','2024-01-01 00:00:00','107-0000',NULL,'Dr',69832.58,0.00,69832.58,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(125,'GL2024000080','JE2024000004','2024-01-01','2024-01-01 00:00:00','202-0000',NULL,'Cr',220000.00,0.00,-220000.00,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(126,'GL2024000081','JE2024000004','2024-01-01','2024-01-01 00:00:00','204-0000',NULL,'Cr',63758.75,0.00,-63758.75,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(127,'GL2024000082','JE2024000004','2024-01-01','2024-01-01 00:00:00','402-0000',NULL,'Cr',12486082.58,0.00,12486082.58,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(128,'GL2024000083','JE2024000004','2024-01-01','2024-01-01 00:00:00','403-0000',NULL,'Cr',15458.00,0.00,15458.00,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(129,'GL2024000084','JE2024000004','2024-01-01','2024-01-01 00:00:00','405-0000',NULL,'Cr',12936.93,0.00,12936.93,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(130,'GL2024000085','JE2024000004','2024-01-01','2024-01-01 00:00:00','406-0000',NULL,'Cr',415.00,0.00,415.00,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(131,'GL2024000086','JE2024000004','2024-01-01','2024-01-01 00:00:00','407-0000',NULL,'Cr',8325.00,0.00,8325.00,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(132,'GL2024000087','JE2024000004','2024-01-01','2024-01-01 00:00:00','408-0000',NULL,'Cr',17575.00,0.00,17575.00,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(133,'GL2024000088','JE2024000004','2024-01-01','2024-01-01 00:00:00','409-0000',NULL,'Cr',3721.02,0.00,3721.02,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(134,'GL2024000089','JE2024000004','2024-01-01','2024-01-01 00:00:00','411-0000',NULL,'Cr',1600.00,0.00,1600.00,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(135,'GL2024000090','JE2024000004','2024-01-01','2024-01-01 00:00:00','412-0000',NULL,'Cr',1600.00,0.00,1600.00,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(136,'GL2024000091','JE2024000004','2024-01-01','2024-01-01 00:00:00','414-0000',NULL,'Cr',3507.01,0.00,3507.01,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(137,'GL2024000092','JE2024000004','2024-01-01','2024-01-01 00:00:00','410-0000',NULL,'Cr',3721.01,0.00,3721.01,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(138,'GL2024000093','JE2024000004','2024-01-01','2024-01-01 00:00:00','415-0000',NULL,'Cr',238452.00,0.00,238452.00,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(139,'GL2024000094','JE2024000004','2024-01-01','2024-01-01 00:00:00','416-0000',NULL,'Cr',56672.17,0.00,56672.17,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(140,'GL2024000095','JE2024000004','2024-01-01','2024-01-01 00:00:00','417-0000',NULL,'Cr',510927.03,0.00,510927.03,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(141,'GL2024000096','JE2024000004','2024-01-01','2024-01-01 00:00:00','602-0000',NULL,'Cr',1600000.00,0.00,1600000.00,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(142,'GL2024000097','JE2024000004','2024-01-01','2024-01-01 00:00:00','605-0000',NULL,'Cr',15700000.00,0.00,15700000.00,'PNB','SPPI','posted',NULL,NULL,'2024-05-30 17:47:29','2024-05-30 17:47:29'),
(143,'GL2024000098','JE2024000005','2024-01-01','2024-01-01 00:00:00','101-0000',NULL,'Dr',676621.00,0.00,676621.00,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(144,'GL2024000099','JE2024000005','2024-01-01','2024-01-01 00:00:00','104-0000',NULL,'Dr',21147380.00,0.00,21147380.00,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(145,'GL2024000100','JE2024000005','2024-01-01','2024-01-01 00:00:00','106-0000',NULL,'Dr',12936.00,0.00,12936.00,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(146,'GL2024000101','JE2024000005','2024-01-01','2024-01-01 00:00:00','107-0000',NULL,'Dr',522274.00,0.00,522274.00,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(147,'GL2024000102','JE2024000005','2024-01-01','2024-01-01 00:00:00','201-0000',NULL,'Dr',332083.56,0.00,332083.56,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(148,'GL2024000103','JE2024000005','2024-01-01','2024-01-01 00:00:00','203-0000',NULL,'Dr',55730.72,0.00,55730.72,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(149,'GL2024000104','JE2024000005','2024-01-01','2024-01-01 00:00:00','702-0000',NULL,'Dr',16078510.00,0.00,-16078510.00,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(150,'GL2024000105','JE2024000005','2024-01-01','2024-01-01 00:00:00','202-0000',NULL,'Cr',332083.56,0.00,-332083.56,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(151,'GL2024000106','JE2024000005','2024-01-01','2024-01-01 00:00:00','204-0000',NULL,'Cr',55730.72,0.00,-55730.72,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(152,'GL2024000107','JE2024000005','2024-01-01','2024-01-01 00:00:00','401-0000',NULL,'Cr',3633041.00,0.00,3633041.00,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(153,'GL2024000108','JE2024000005','2024-01-01','2024-01-01 00:00:00','402-0000',NULL,'Cr',22510080.00,0.00,22510080.00,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(154,'GL2024000109','JE2024000005','2024-01-01','2024-01-01 00:00:00','403-0000',NULL,'Cr',11440.00,0.00,11440.00,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(155,'GL2024000110','JE2024000005','2024-01-01','2024-01-01 00:00:00','421-0000',NULL,'Cr',123.93,0.00,123.93,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(156,'GL2024000111','JE2024000005','2024-01-01','2024-01-01 00:00:00','420-0000',NULL,'Cr',39.60,0.00,39.60,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(157,'GL2024000112','JE2024000005','2024-01-01','2024-01-01 00:00:00','422-0000',NULL,'Cr',64.19,0.00,64.19,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(158,'GL2024000113','JE2024000005','2024-01-01','2024-01-01 00:00:00','405-0000',NULL,'Cr',10386.28,0.00,10386.28,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(159,'GL2024000114','JE2024000005','2024-01-01','2024-01-01 00:00:00','406-0000',NULL,'Cr',430.00,0.00,430.00,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(160,'GL2024000115','JE2024000005','2024-01-01','2024-01-01 00:00:00','407-0000',NULL,'Cr',17190.00,0.00,17190.00,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(161,'GL2024000116','JE2024000005','2024-01-01','2024-01-01 00:00:00','408-0000',NULL,'Cr',37030.00,0.00,37030.00,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(162,'GL2024000117','JE2024000005','2024-01-01','2024-01-01 00:00:00','409-0000',NULL,'Cr',7648.51,0.00,7648.51,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(163,'GL2024000118','JE2024000005','2024-01-01','2024-01-01 00:00:00','410-0000',NULL,'Cr',7648.40,0.00,7648.40,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(164,'GL2024000119','JE2024000005','2024-01-01','2024-01-01 00:00:00','411-0000',NULL,'Cr',2600.00,0.00,2600.00,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(165,'GL2024000120','JE2024000005','2024-01-01','2024-01-01 00:00:00','412-0000',NULL,'Cr',2600.00,0.00,2600.00,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(166,'GL2024000121','JE2024000005','2024-01-01','2024-01-01 00:00:00','413-0000',NULL,'Cr',603.03,0.00,603.03,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(167,'GL2024000122','JE2024000005','2024-01-01','2024-01-01 00:00:00','414-0000',NULL,'Cr',1792.06,0.00,1792.06,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(168,'GL2024000123','JE2024000005','2024-01-01','2024-01-01 00:00:00','415-0000',NULL,'Cr',58848.00,0.00,58848.00,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(169,'GL2024000124','JE2024000005','2024-01-01','2024-01-01 00:00:00','416-0000',NULL,'Cr',36156.00,0.00,36156.00,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(170,'GL2024000125','JE2024000005','2024-01-01','2024-01-01 00:00:00','602-0000',NULL,'Cr',1600000.00,0.00,1600000.00,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(171,'GL2024000126','JE2024000005','2024-01-01','2024-01-01 00:00:00','605-0000',NULL,'Cr',10500000.00,0.00,10500000.00,'URB','ASPI','posted',NULL,NULL,'2024-05-30 18:30:20','2024-05-30 18:30:20'),
(172,'GL2024000127','JE2024000006','2024-01-01','2024-01-01 00:00:00','101-0000',NULL,'Dr',1242112.28,0.00,1242112.28,'BGD','MGPI','posted',NULL,NULL,'2024-05-31 08:32:01','2024-05-31 08:32:01'),
(173,'GL2024000128','JE2024000006','2024-01-01','2024-01-01 00:00:00','104-0000',NULL,'Dr',4457420.00,0.00,4457420.00,'BGD','MGPI','posted',NULL,NULL,'2024-05-31 08:32:01','2024-05-31 08:32:01'),
(174,'GL2024000129','JE2024000006','2024-01-01','2024-01-01 00:00:00','107-0000',NULL,'Dr',45299.17,0.00,45299.17,'BGD','MGPI','posted',NULL,NULL,'2024-05-31 08:32:01','2024-05-31 08:32:01'),
(175,'GL2024000130','JE2024000006','2024-01-01','2024-01-01 00:00:00','702-0000',NULL,'Dr',16427019.10,0.00,-16427019.10,'BGD','MGPI','posted',NULL,NULL,'2024-05-31 08:32:01','2024-05-31 08:32:01'),
(176,'GL2024000131','JE2024000006','2024-01-01','2024-01-01 00:00:00','401-0000',NULL,'Cr',8242507.74,0.00,8242507.74,'BGD','MGPI','posted',NULL,NULL,'2024-05-31 08:32:01','2024-05-31 08:32:01'),
(177,'GL2024000132','JE2024000006','2024-01-01','2024-01-01 00:00:00','402-0000',NULL,'Cr',11867530.00,0.00,11867530.00,'BGD','MGPI','posted',NULL,NULL,'2024-05-31 08:32:01','2024-05-31 08:32:01'),
(178,'GL2024000133','JE2024000006','2024-01-01','2024-01-01 00:00:00','403-0000',NULL,'Cr',15865.20,0.00,15865.20,'BGD','MGPI','posted',NULL,NULL,'2024-05-31 08:32:01','2024-05-31 08:32:01'),
(179,'GL2024000134','JE2024000006','2024-01-01','2024-01-01 00:00:00','405-0000',NULL,'Cr',7445.47,0.00,7445.47,'BGD','MGPI','posted',NULL,NULL,'2024-05-31 08:32:01','2024-05-31 08:32:01'),
(180,'GL2024000135','JE2024000006','2024-01-01','2024-01-01 00:00:00','406-0000',NULL,'Cr',275.00,0.00,275.00,'BGD','MGPI','posted',NULL,NULL,'2024-05-31 08:32:01','2024-05-31 08:32:01'),
(181,'GL2024000136','JE2024000006','2024-01-01','2024-01-01 00:00:00','407-0000',NULL,'Cr',6187.50,0.00,6187.50,'BGD','MGPI','posted',NULL,NULL,'2024-05-31 08:32:01','2024-05-31 08:32:01'),
(182,'GL2024000137','JE2024000006','2024-01-01','2024-01-01 00:00:00','408-0000',NULL,'Cr',13062.50,0.00,13062.50,'BGD','MGPI','posted',NULL,NULL,'2024-05-31 08:32:01','2024-05-31 08:32:01'),
(183,'GL2024000138','JE2024000006','2024-01-01','2024-01-01 00:00:00','410-0000',NULL,'Cr',2746.26,0.00,2746.26,'BGD','MGPI','posted',NULL,NULL,'2024-05-31 08:32:01','2024-05-31 08:32:01'),
(184,'GL2024000139','JE2024000006','2024-01-01','2024-01-01 00:00:00','411-0000',NULL,'Cr',1000.00,0.00,1000.00,'BGD','MGPI','posted',NULL,NULL,'2024-05-31 08:32:01','2024-05-31 08:32:01'),
(185,'GL2024000140','JE2024000006','2024-01-01','2024-01-01 00:00:00','412-0000',NULL,'Cr',1000.00,0.00,1000.00,'BGD','MGPI','posted',NULL,NULL,'2024-05-31 08:32:01','2024-05-31 08:32:01'),
(186,'GL2024000141','JE2024000006','2024-01-01','2024-01-01 00:00:00','415-0000',NULL,'Cr',57342.40,0.00,57342.40,'BGD','MGPI','posted',NULL,NULL,'2024-05-31 08:32:01','2024-05-31 08:32:01'),
(187,'GL2024000142','JE2024000006','2024-01-01','2024-01-01 00:00:00','416-0000',NULL,'Cr',35848.70,0.00,35848.70,'BGD','MGPI','posted',NULL,NULL,'2024-05-31 08:32:01','2024-05-31 08:32:01'),
(188,'GL2024000143','JE2024000006','2024-01-01','2024-01-01 00:00:00','417-0000',NULL,'Cr',318293.50,0.00,318293.50,'BGD','MGPI','posted',NULL,NULL,'2024-05-31 08:32:01','2024-05-31 08:32:01'),
(189,'GL2024000144','JE2024000006','2024-01-01','2024-01-01 00:00:00','602-0000',NULL,'Cr',1600000.00,0.00,1600000.00,'BGD','MGPI','posted',NULL,NULL,'2024-05-31 08:32:01','2024-05-31 08:32:01'),
(190,'GL2024000145','JE2024000006','2024-01-01','2024-01-01 00:00:00','409-0000',NULL,'Cr',2746.28,0.00,2746.28,'BGD','MGPI','posted',NULL,NULL,'2024-05-31 08:32:01','2024-05-31 08:32:01'),
(191,'GL2024000146','JE2024000007','2024-01-01','2024-01-01 00:00:00','101-0000',NULL,'Dr',614784.80,0.00,614784.80,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(192,'GL2024000147','JE2024000007','2024-01-01','2024-01-01 00:00:00','104-0000',NULL,'Dr',9399100.00,0.00,9399100.00,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(193,'GL2024000148','JE2024000007','2024-01-01','2024-01-01 00:00:00','107-0000',NULL,'Dr',26932.08,0.00,26932.08,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(194,'GL2024000149','JE2024000007','2024-01-01','2024-01-01 00:00:00','201-0000',NULL,'Dr',2260000.00,0.00,2260000.00,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(195,'GL2024000150','JE2024000007','2024-01-01','2024-01-01 00:00:00','203-0000',NULL,'Dr',900000.00,0.00,900000.00,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(196,'GL2024000151','JE2024000007','2024-01-01','2024-01-01 00:00:00','205-0000',NULL,'Dr',36000.00,0.00,36000.00,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(197,'GL2024000152','JE2024000007','2024-01-01','2024-01-01 00:00:00','702-0000',NULL,'Dr',41554224.44,0.00,-41554224.44,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(198,'GL2024000153','JE2024000007','2024-01-01','2024-01-01 00:00:00','202-0000',NULL,'Cr',2260000.00,0.00,-2260000.00,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(199,'GL2024000154','JE2024000007','2024-01-01','2024-01-01 00:00:00','204-0000',NULL,'Cr',900000.00,0.00,-900000.00,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(200,'GL2024000155','JE2024000007','2024-01-01','2024-01-01 00:00:00','206-0000',NULL,'Cr',36000.00,0.00,-36000.00,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(201,'GL2024000156','JE2024000007','2024-01-01','2024-01-01 00:00:00','401-0000',NULL,'Cr',4699550.00,0.00,4699550.00,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(202,'GL2024000157','JE2024000007','2024-01-01','2024-01-01 00:00:00','402-0000',NULL,'Cr',23254401.00,0.00,23254401.00,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(203,'GL2024000158','JE2024000007','2024-01-01','2024-01-01 00:00:00','421-0000',NULL,'Cr',105.60,0.00,105.60,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(204,'GL2024000159','JE2024000007','2024-01-01','2024-01-01 00:00:00','405-0000',NULL,'Cr',7543.45,0.00,7543.45,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(205,'GL2024000160','JE2024000007','2024-01-01','2024-01-01 00:00:00','406-0000',NULL,'Cr',370.00,0.00,370.00,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(206,'GL2024000161','JE2024000007','2024-01-01','2024-01-01 00:00:00','422-0000',NULL,'Cr',16.90,0.00,16.90,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(207,'GL2024000162','JE2024000007','2024-01-01','2024-01-01 00:00:00','407-0000',NULL,'Cr',19147.50,0.00,19147.50,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(208,'GL2024000163','JE2024000007','2024-01-01','2024-01-01 00:00:00','408-0000',NULL,'Cr',41042.50,0.00,41042.50,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(209,'GL2024000164','JE2024000007','2024-01-01','2024-01-01 00:00:00','409-0000',NULL,'Cr',8751.39,0.00,8751.39,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(210,'GL2024000165','JE2024000007','2024-01-01','2024-01-01 00:00:00','410-0000',NULL,'Cr',8751.30,0.00,8751.30,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(211,'GL2024000166','JE2024000007','2024-01-01','2024-01-01 00:00:00','412-0000',NULL,'Cr',3100.00,0.00,3100.00,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(212,'GL2024000167','JE2024000007','2024-01-01','2024-01-01 00:00:00','411-0000',NULL,'Cr',3100.00,0.00,3100.00,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(213,'GL2024000168','JE2024000007','2024-01-01','2024-01-01 00:00:00','413-0000',NULL,'Cr',7502.63,0.00,7502.63,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(214,'GL2024000169','JE2024000007','2024-01-01','2024-01-01 00:00:00','414-0000',NULL,'Cr',6875.59,0.00,6875.59,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(215,'GL2024000170','JE2024000007','2024-01-01','2024-01-01 00:00:00','415-0000',NULL,'Cr',82116.50,0.00,82116.50,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(216,'GL2024000171','JE2024000007','2024-01-01','2024-01-01 00:00:00','416-0000',NULL,'Cr',27748.56,0.00,27748.56,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(217,'GL2024000172','JE2024000007','2024-01-01','2024-01-01 00:00:00','501-0000',NULL,'Cr',2910000.00,0.00,2910000.00,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(218,'GL2024000173','JE2024000007','2024-01-01','2024-01-01 00:00:00','602-0000',NULL,'Cr',1000000.00,0.00,1000000.00,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(219,'GL2024000174','JE2024000007','2024-01-01','2024-01-01 00:00:00','605-0000',NULL,'Cr',19500000.00,0.00,19500000.00,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(220,'GL2024000175','JE2024000007','2024-01-01','2024-01-01 00:00:00','403-0000',NULL,'Cr',14918.40,0.00,14918.40,'MUS','SJPI','posted',NULL,NULL,'2024-05-31 08:46:08','2024-05-31 08:46:08'),
(221,'GL2024000176','JE2024000008','2024-01-01','2024-01-01 00:00:00','101-0000',NULL,'Dr',654267.80,0.00,654267.80,'CLT','PKPI','posted',NULL,NULL,'2024-05-31 09:31:44','2024-05-31 09:31:44'),
(222,'GL2024000177','JE2024000008','2024-01-01','2024-01-01 00:00:00','104-0000',NULL,'Dr',8765600.00,0.00,8765600.00,'CLT','PKPI','posted',NULL,NULL,'2024-05-31 09:31:44','2024-05-31 09:31:44'),
(223,'GL2024000178','JE2024000008','2024-01-01','2024-01-01 00:00:00','107-0000',NULL,'Dr',54532.69,0.00,54532.69,'CLT','PKPI','posted',NULL,NULL,'2024-05-31 09:31:44','2024-05-31 09:31:44'),
(224,'GL2024000179','JE2024000008','2024-01-01','2024-01-01 00:00:00','702-0000',NULL,'Dr',16638931.07,0.00,-16638931.07,'CLT','PKPI','posted',NULL,NULL,'2024-05-31 09:31:44','2024-05-31 09:31:44'),
(225,'GL2024000180','JE2024000008','2024-01-01','2024-01-01 00:00:00','402-0000',NULL,'Cr',15995900.00,0.00,15995900.00,'CLT','PKPI','posted',NULL,NULL,'2024-05-31 09:31:44','2024-05-31 09:31:44'),
(226,'GL2024000181','JE2024000008','2024-01-01','2024-01-01 00:00:00','403-0000',NULL,'Cr',14918.40,0.00,14918.40,'CLT','PKPI','posted',NULL,NULL,'2024-05-31 09:31:44','2024-05-31 09:31:44'),
(227,'GL2024000182','JE2024000008','2024-01-01','2024-01-01 00:00:00','405-0000',NULL,'Cr',12132.91,0.00,12132.91,'CLT','PKPI','posted',NULL,NULL,'2024-05-31 09:31:44','2024-05-31 09:31:44'),
(228,'GL2024000183','JE2024000008','2024-01-01','2024-01-01 00:00:00','406-0000',NULL,'Cr',510.00,0.00,510.00,'CLT','PKPI','posted',NULL,NULL,'2024-05-31 09:31:44','2024-05-31 09:31:44'),
(229,'GL2024000184','JE2024000008','2024-01-01','2024-01-01 00:00:00','407-0000',NULL,'Cr',9202.50,0.00,9202.50,'CLT','PKPI','posted',NULL,NULL,'2024-05-31 09:31:44','2024-05-31 09:31:44'),
(230,'GL2024000185','JE2024000008','2024-01-01','2024-01-01 00:00:00','408-0000',NULL,'Cr',19737.50,0.00,19737.50,'CLT','PKPI','posted',NULL,NULL,'2024-05-31 09:31:44','2024-05-31 09:31:44'),
(231,'GL2024000186','JE2024000008','2024-01-01','2024-01-01 00:00:00','409-0000',NULL,'Cr',4158.24,0.00,4158.24,'CLT','PKPI','posted',NULL,NULL,'2024-05-31 09:31:44','2024-05-31 09:31:44'),
(232,'GL2024000187','JE2024000008','2024-01-01','2024-01-01 00:00:00','410-0000',NULL,'Cr',4158.18,0.00,4158.18,'CLT','PKPI','posted',NULL,NULL,'2024-05-31 09:31:44','2024-05-31 09:31:44'),
(233,'GL2024000188','JE2024000008','2024-01-01','2024-01-01 00:00:00','411-0000',NULL,'Cr',1500.00,0.00,1500.00,'CLT','PKPI','posted',NULL,NULL,'2024-05-31 09:31:44','2024-05-31 09:31:44'),
(234,'GL2024000189','JE2024000008','2024-01-01','2024-01-01 00:00:00','412-0000',NULL,'Cr',1500.00,0.00,1500.00,'CLT','PKPI','posted',NULL,NULL,'2024-05-31 09:31:44','2024-05-31 09:31:44'),
(235,'GL2024000190','JE2024000008','2024-01-01','2024-01-01 00:00:00','413-0000',NULL,'Cr',2570.52,0.00,2570.52,'CLT','PKPI','posted',NULL,NULL,'2024-05-31 09:31:44','2024-05-31 09:31:44'),
(236,'GL2024000191','JE2024000008','2024-01-01','2024-01-01 00:00:00','415-0000',NULL,'Cr',106623.00,0.00,106623.00,'CLT','PKPI','posted',NULL,NULL,'2024-05-31 09:31:44','2024-05-31 09:31:44'),
(237,'GL2024000192','JE2024000008','2024-01-01','2024-01-01 00:00:00','416-0000',NULL,'Cr',27920.83,0.00,27920.83,'CLT','PKPI','posted',NULL,NULL,'2024-05-31 09:31:44','2024-05-31 09:31:44'),
(238,'GL2024000193','JE2024000008','2024-01-01','2024-01-01 00:00:00','417-0000',NULL,'Cr',312499.48,0.00,312499.48,'CLT','PKPI','posted',NULL,NULL,'2024-05-31 09:31:44','2024-05-31 09:31:44'),
(239,'GL2024000194','JE2024000008','2024-01-01','2024-01-01 00:00:00','602-0000',NULL,'Cr',1600000.00,0.00,1600000.00,'CLT','PKPI','posted',NULL,NULL,'2024-05-31 09:31:44','2024-05-31 09:31:44'),
(240,'GL2024000195','JE2024000008','2024-01-01','2024-01-01 00:00:00','605-0000',NULL,'Cr',8000000.00,0.00,8000000.00,'CLT','PKPI','posted',NULL,NULL,'2024-05-31 09:31:44','2024-05-31 09:31:44'),
(241,'GL2024000196','JE2024000009','2024-01-01','2024-01-01 00:00:00','101-0000',NULL,'Dr',917840.00,0.00,917840.00,'SML','GGPI','posted',NULL,NULL,'2024-05-31 09:39:30','2024-05-31 09:39:30'),
(242,'GL2024000197','JE2024000009','2024-01-01','2024-01-01 00:00:00','104-0000',NULL,'Dr',7970200.00,0.00,7970200.00,'SML','GGPI','posted',NULL,NULL,'2024-05-31 09:39:30','2024-05-31 09:39:30'),
(243,'GL2024000198','JE2024000009','2024-01-01','2024-01-01 00:00:00','107-0000',NULL,'Dr',54417.00,0.00,54417.00,'SML','GGPI','posted',NULL,NULL,'2024-05-31 09:39:30','2024-05-31 09:39:30'),
(244,'GL2024000199','JE2024000009','2024-01-01','2024-01-01 00:00:00','201-0000',NULL,'Dr',45000.00,0.00,45000.00,'SML','GGPI','posted',NULL,NULL,'2024-05-31 09:39:30','2024-05-31 09:39:30'),
(245,'GL2024000200','JE2024000009','2024-01-01','2024-01-01 00:00:00','702-0000',NULL,'Dr',5014253.00,0.00,-5014253.00,'SML','GGPI','posted',NULL,NULL,'2024-05-31 09:39:30','2024-05-31 09:39:30'),
(246,'GL2024000201','JE2024000009','2024-01-01','2024-01-01 00:00:00','202-0000',NULL,'Cr',45000.00,0.00,-45000.00,'SML','GGPI','posted',NULL,NULL,'2024-05-31 09:39:30','2024-05-31 09:39:30'),
(247,'GL2024000202','JE2024000009','2024-01-01','2024-01-01 00:00:00','401-0000',NULL,'Cr',3985100.00,0.00,3985100.00,'SML','GGPI','posted',NULL,NULL,'2024-05-31 09:39:30','2024-05-31 09:39:30'),
(248,'GL2024000203','JE2024000009','2024-01-01','2024-01-01 00:00:00','402-0000',NULL,'Cr',6899479.00,0.00,6899479.00,'SML','GGPI','posted',NULL,NULL,'2024-05-31 09:39:30','2024-05-31 09:39:30'),
(249,'GL2024000204','JE2024000009','2024-01-01','2024-01-01 00:00:00','405-0000',NULL,'Cr',10520.33,0.00,10520.33,'SML','GGPI','posted',NULL,NULL,'2024-05-31 09:39:30','2024-05-31 09:39:30'),
(250,'GL2024000205','JE2024000009','2024-01-01','2024-01-01 00:00:00','407-0000',NULL,'Cr',5130.00,0.00,5130.00,'SML','GGPI','posted',NULL,NULL,'2024-05-31 09:39:30','2024-05-31 09:39:30'),
(251,'GL2024000206','JE2024000009','2024-01-01','2024-01-01 00:00:00','409-0000',NULL,'Cr',2282.64,0.00,2282.64,'SML','GGPI','posted',NULL,NULL,'2024-05-31 09:39:30','2024-05-31 09:39:30'),
(252,'GL2024000207','JE2024000009','2024-01-01','2024-01-01 00:00:00','411-0000',NULL,'Cr',800.00,0.00,800.00,'SML','GGPI','posted',NULL,NULL,'2024-05-31 09:39:30','2024-05-31 09:39:30'),
(253,'GL2024000208','JE2024000009','2024-01-01','2024-01-01 00:00:00','415-0000',NULL,'Cr',31141.00,0.00,31141.00,'SML','GGPI','posted',NULL,NULL,'2024-05-31 09:39:30','2024-05-31 09:39:30'),
(254,'GL2024000209','JE2024000009','2024-01-01','2024-01-01 00:00:00','417-0000',NULL,'Cr',422257.03,0.00,422257.03,'SML','GGPI','posted',NULL,NULL,'2024-05-31 09:39:30','2024-05-31 09:39:30'),
(255,'GL2024000210','JE2024000009','2024-01-01','2024-01-01 00:00:00','602-0000',NULL,'Cr',400000.00,0.00,400000.00,'SML','GGPI','posted',NULL,NULL,'2024-05-31 09:39:30','2024-05-31 09:39:30'),
(256,'GL2024000211','JE2024000009','2024-01-01','2024-01-01 00:00:00','605-0000',NULL,'Cr',2200000.00,0.00,2200000.00,'SML','GGPI','posted',NULL,NULL,'2024-05-31 09:39:30','2024-05-31 09:39:30'),
(257,'GL2024000212','JE2024000010','2024-01-01','2024-01-01 00:00:00','101-0000',NULL,'Dr',638780.00,0.00,638780.00,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(258,'GL2024000213','JE2024000010','2024-01-01','2024-01-01 00:00:00','104-0000',NULL,'Dr',8933150.00,0.00,8933150.00,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(259,'GL2024000214','JE2024000010','2024-01-01','2024-01-01 00:00:00','106-0000',NULL,'Dr',200852.00,0.00,200852.00,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(260,'GL2024000215','JE2024000010','2024-01-01','2024-01-01 00:00:00','108-0000',NULL,'Dr',700001.00,0.00,700001.00,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(261,'GL2024000216','JE2024000010','2024-01-01','2024-01-01 00:00:00','201-0000',NULL,'Dr',466642.12,0.00,466642.12,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(262,'GL2024000217','JE2024000010','2024-01-01','2024-01-01 00:00:00','203-0000',NULL,'Dr',78486.03,0.00,78486.03,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(263,'GL2024000218','JE2024000010','2024-01-01','2024-01-01 00:00:00','702-0000',NULL,'Dr',24169638.00,0.00,-24169638.00,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(264,'GL2024000219','JE2024000010','2024-01-01','2024-01-01 00:00:00','202-0000',NULL,'Cr',466642.12,0.00,-466642.12,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(265,'GL2024000220','JE2024000010','2024-01-01','2024-01-01 00:00:00','204-0000',NULL,'Cr',78486.03,0.00,-78486.03,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(266,'GL2024000221','JE2024000010','2024-01-01','2024-01-01 00:00:00','402-0000',NULL,'Cr',15292910.00,0.00,15292910.00,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(267,'GL2024000222','JE2024000010','2024-01-01','2024-01-01 00:00:00','403-0000',NULL,'Cr',15834.00,0.00,15834.00,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(268,'GL2024000223','JE2024000010','2024-01-01','2024-01-01 00:00:00','421-0000',NULL,'Cr',44.00,0.00,44.00,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(269,'GL2024000224','JE2024000010','2024-01-01','2024-01-01 00:00:00','405-0000',NULL,'Cr',13148.00,0.00,13148.00,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(270,'GL2024000225','JE2024000010','2024-01-01','2024-01-01 00:00:00','406-0000',NULL,'Cr',410.00,0.00,410.00,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(271,'GL2024000226','JE2024000010','2024-01-01','2024-01-01 00:00:00','407-0000',NULL,'Cr',10665.00,0.00,10665.00,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(272,'GL2024000227','JE2024000010','2024-01-01','2024-01-01 00:00:00','408-0000',NULL,'Cr',22915.00,0.00,22915.00,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(273,'GL2024000228','JE2024000010','2024-01-01','2024-01-01 00:00:00','409-0000',NULL,'Cr',4710.00,0.00,4710.00,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(274,'GL2024000229','JE2024000010','2024-01-01','2024-01-01 00:00:00','410-0000',NULL,'Cr',4710.00,0.00,4710.00,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(275,'GL2024000230','JE2024000010','2024-01-01','2024-01-01 00:00:00','411-0000',NULL,'Cr',1600.00,0.00,1600.00,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(276,'GL2024000231','JE2024000010','2024-01-01','2024-01-01 00:00:00','412-0000',NULL,'Cr',1600.00,0.00,1600.00,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(277,'GL2024000232','JE2024000010','2024-01-01','2024-01-01 00:00:00','414-0000',NULL,'Cr',3968.00,0.00,3968.00,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(278,'GL2024000233','JE2024000010','2024-01-01','2024-01-01 00:00:00','415-0000',NULL,'Cr',132465.00,0.00,132465.00,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(279,'GL2024000234','JE2024000010','2024-01-01','2024-01-01 00:00:00','416-0000',NULL,'Cr',37442.00,0.00,37442.00,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(280,'GL2024000235','JE2024000010','2024-01-01','2024-01-01 00:00:00','602-0000',NULL,'Cr',1600000.00,0.00,1600000.00,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(281,'GL2024000236','JE2024000010','2024-01-01','2024-01-01 00:00:00','605-0000',NULL,'Cr',17500000.00,0.00,17500000.00,'GTD','MMPI','posted',NULL,NULL,'2024-05-31 09:49:24','2024-05-31 09:49:24'),
(282,'GL2024000237','JE2024000011','2024-01-01','2024-01-01 00:00:00','101-0000',NULL,'Dr',665031.00,0.00,665031.00,'ECT','SRPI','posted',NULL,NULL,'2024-05-31 13:49:06','2024-05-31 13:49:06'),
(283,'GL2024000238','JE2024000011','2024-01-01','2024-01-01 00:00:00','104-0000',NULL,'Dr',6249800.00,0.00,6249800.00,'ECT','SRPI','posted',NULL,NULL,'2024-05-31 13:49:06','2024-05-31 13:49:06'),
(284,'GL2024000239','JE2024000011','2024-01-01','2024-01-01 00:00:00','702-0000',NULL,'Dr',17003335.00,0.00,-17003335.00,'ECT','SRPI','posted',NULL,NULL,'2024-05-31 13:49:06','2024-05-31 13:49:06'),
(285,'GL2024000240','JE2024000011','2024-01-01','2024-01-01 00:00:00','401-0000',NULL,'Cr',7604109.00,0.00,7604109.00,'ECT','SRPI','posted',NULL,NULL,'2024-05-31 13:49:06','2024-05-31 13:49:06'),
(286,'GL2024000241','JE2024000011','2024-01-01','2024-01-01 00:00:00','402-0000',NULL,'Cr',3224054.00,0.00,3224054.00,'ECT','SRPI','posted',NULL,NULL,'2024-05-31 13:49:06','2024-05-31 13:49:06'),
(287,'GL2024000242','JE2024000011','2024-01-01','2024-01-01 00:00:00','403-0000',NULL,'Cr',15031.00,0.00,15031.00,'ECT','SRPI','posted',NULL,NULL,'2024-05-31 13:49:06','2024-05-31 13:49:06'),
(288,'GL2024000243','JE2024000011','2024-01-01','2024-01-01 00:00:00','407-0000',NULL,'Cr',2564.00,0.00,2564.00,'ECT','SRPI','posted',NULL,NULL,'2024-05-31 13:49:06','2024-05-31 13:49:06'),
(289,'GL2024000244','JE2024000011','2024-01-01','2024-01-01 00:00:00','408-0000',NULL,'Cr',5130.00,0.00,5130.00,'ECT','SRPI','posted',NULL,NULL,'2024-05-31 13:49:06','2024-05-31 13:49:06'),
(290,'GL2024000245','JE2024000011','2024-01-01','2024-01-01 00:00:00','409-0000',NULL,'Cr',1699.50,0.00,1699.50,'ECT','SRPI','posted',NULL,NULL,'2024-05-31 13:49:06','2024-05-31 13:49:06'),
(291,'GL2024000246','JE2024000011','2024-01-01','2024-01-01 00:00:00','410-0000',NULL,'Cr',1699.50,0.00,1699.50,'ECT','SRPI','posted',NULL,NULL,'2024-05-31 13:49:06','2024-05-31 13:49:06'),
(292,'GL2024000247','JE2024000011','2024-01-01','2024-01-01 00:00:00','413-0000',NULL,'Cr',1548.00,0.00,1548.00,'ECT','SRPI','posted',NULL,NULL,'2024-05-31 13:49:06','2024-05-31 13:49:06'),
(293,'GL2024000248','JE2024000011','2024-01-01','2024-01-01 00:00:00','414-0000',NULL,'Cr',4153.00,0.00,4153.00,'ECT','SRPI','posted',NULL,NULL,'2024-05-31 13:49:06','2024-05-31 13:49:06'),
(294,'GL2024000249','JE2024000011','2024-01-01','2024-01-01 00:00:00','415-0000',NULL,'Cr',26077.00,0.00,26077.00,'ECT','SRPI','posted',NULL,NULL,'2024-05-31 13:49:06','2024-05-31 13:49:06'),
(295,'GL2024000250','JE2024000011','2024-01-01','2024-01-01 00:00:00','417-0000',NULL,'Cr',432101.00,0.00,432101.00,'ECT','SRPI','posted',NULL,NULL,'2024-05-31 13:49:06','2024-05-31 13:49:06'),
(296,'GL2024000251','JE2024000011','2024-01-01','2024-01-01 00:00:00','602-0000',NULL,'Cr',1600000.00,0.00,1600000.00,'ECT','SRPI','posted',NULL,NULL,'2024-05-31 13:49:06','2024-05-31 13:49:06'),
(297,'GL2024000252','JE2024000011','2024-01-01','2024-01-01 00:00:00','605-0000',NULL,'Cr',11000000.00,0.00,11000000.00,'ECT','SRPI','posted',NULL,NULL,'2024-05-31 13:49:06','2024-05-31 13:49:06'),
(298,'GL2024000253','JE2024000012','2024-01-01','2024-01-01 00:00:00','101-0000',NULL,'Dr',610464.00,0.00,610464.00,'WSTF','SSSPI','posted',NULL,NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(299,'GL2024000254','JE2024000012','2024-01-01','2024-01-01 00:00:00','104-0000',NULL,'Dr',11819300.00,0.00,11819300.00,'WSTF','SSSPI','posted',NULL,NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(300,'GL2024000255','JE2024000012','2024-01-01','2024-01-01 00:00:00','107-0000',NULL,'Dr',26048.00,0.00,26048.00,'WSTF','SSSPI','posted',NULL,NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(301,'GL2024000256','JE2024000012','2024-01-01','2024-01-01 00:00:00','201-0000',NULL,'Dr',368693.00,0.00,368693.00,'WSTF','SSSPI','posted',NULL,NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(302,'GL2024000257','JE2024000012','2024-01-01','2024-01-01 00:00:00','203-0000',NULL,'Dr',44353.00,0.00,44353.00,'WSTF','SSSPI','posted',NULL,NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(303,'GL2024000258','JE2024000012','2024-01-01','2024-01-01 00:00:00','702-0000',NULL,'Dr',16977541.00,0.00,-16977541.00,'WSTF','SSSPI','posted',NULL,NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(304,'GL2024000259','JE2024000012','2024-01-01','2024-01-01 00:00:00','202-0000',NULL,'Cr',368693.00,0.00,-368693.00,'WSTF','SSSPI','posted',NULL,NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(305,'GL2024000260','JE2024000012','2024-01-01','2024-01-01 00:00:00','204-0000',NULL,'Cr',44353.00,0.00,-44353.00,'WSTF','SSSPI','posted',NULL,NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(306,'GL2024000261','JE2024000012','2024-01-01','2024-01-01 00:00:00','401-0000',NULL,'Cr',7217403.00,0.00,7217403.00,'WSTF','SSSPI','posted',NULL,NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(307,'GL2024000262','JE2024000012','2024-01-01','2024-01-01 00:00:00','402-0000',NULL,'Cr',9541417.00,0.00,9541417.00,'WSTF','SSSPI','posted',NULL,NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(308,'GL2024000263','JE2024000012','2024-01-01','2024-01-01 00:00:00','403-0000',NULL,'Cr',16695.00,0.00,16695.00,'WSTF','SSSPI','posted',NULL,NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(309,'GL2024000264','JE2024000012','2024-01-01','2024-01-01 00:00:00','407-0000',NULL,'Cr',2100.00,0.00,2100.00,'WSTF','SSSPI','posted',NULL,NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(310,'GL2024000265','JE2024000012','2024-01-01','2024-01-01 00:00:00','408-0000',NULL,'Cr',3368.00,0.00,3368.00,'WSTF','SSSPI','posted',NULL,NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(311,'GL2024000266','JE2024000012','2024-01-01','2024-01-01 00:00:00','409-0000',NULL,'Cr',1211.50,0.00,1211.50,'WSTF','SSSPI','posted',NULL,NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(312,'GL2024000267','JE2024000012','2024-01-01','2024-01-01 00:00:00','410-0000',NULL,'Cr',1213.50,0.00,1213.50,'WSTF','SSSPI','posted',NULL,NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(313,'GL2024000268','JE2024000012','2024-01-01','2024-01-01 00:00:00','411-0000',NULL,'Cr',400.00,0.00,400.00,'WSTF','SSSPI','posted',NULL,NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(314,'GL2024000269','JE2024000012','2024-01-01','2024-01-01 00:00:00','412-0000',NULL,'Cr',500.00,0.00,500.00,'WSTF','SSSPI','posted',NULL,NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(315,'GL2024000270','JE2024000012','2024-01-01','2024-01-01 00:00:00','414-0000',NULL,'Cr',2491.00,0.00,2491.00,'WSTF','SSSPI','posted',NULL,NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(316,'GL2024000271','JE2024000012','2024-01-01','2024-01-01 00:00:00','415-0000',NULL,'Cr',11488.00,0.00,11488.00,'WSTF','SSSPI','posted',NULL,NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(317,'GL2024000272','JE2024000012','2024-01-01','2024-01-01 00:00:00','416-0000',NULL,'Cr',35066.00,0.00,35066.00,'WSTF','SSSPI','posted',NULL,NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(318,'GL2024000273','JE2024000012','2024-01-01','2024-01-01 00:00:00','602-0000',NULL,'Cr',1600000.00,0.00,1600000.00,'WSTF','SSSPI','posted',NULL,NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(319,'GL2024000274','JE2024000012','2024-01-01','2024-01-01 00:00:00','605-0000',NULL,'Cr',11000000.00,0.00,11000000.00,'WSTF','SSSPI','posted',NULL,NULL,'2024-05-31 14:01:57','2024-05-31 14:01:57'),
(320,'GL2024000275','JE2024000013','2024-01-01','2024-01-01 00:00:00','101-0000',NULL,'Dr',650000.00,0.00,650000.00,'PLW','NWPI','posted',NULL,NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(321,'GL2024000276','JE2024000013','2024-01-01','2024-01-01 00:00:00','104-0000',NULL,'Dr',5796400.00,0.00,5796400.00,'PLW','NWPI','posted',NULL,NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(322,'GL2024000277','JE2024000013','2024-01-01','2024-01-01 00:00:00','201-0000',NULL,'Dr',237816.00,0.00,237816.00,'PLW','NWPI','posted',NULL,NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(323,'GL2024000278','JE2024000013','2024-01-01','2024-01-01 00:00:00','203-0000',NULL,'Dr',2411.00,0.00,2411.00,'PLW','NWPI','posted',NULL,NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(324,'GL2024000279','JE2024000013','2024-01-01','2024-01-01 00:00:00','702-0000',NULL,'Dr',21263592.00,0.00,-21263592.00,'PLW','NWPI','posted',NULL,NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(325,'GL2024000280','JE2024000013','2024-01-01','2024-01-01 00:00:00','202-0000',NULL,'Cr',237816.00,0.00,-237816.00,'PLW','NWPI','posted',NULL,NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(326,'GL2024000281','JE2024000013','2024-01-01','2024-01-01 00:00:00','204-0000',NULL,'Cr',2411.00,0.00,-2411.00,'PLW','NWPI','posted',NULL,NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(327,'GL2024000282','JE2024000013','2024-01-01','2024-01-01 00:00:00','401-0000',NULL,'Cr',12259084.00,0.00,12259084.00,'PLW','NWPI','posted',NULL,NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(328,'GL2024000283','JE2024000013','2024-01-01','2024-01-01 00:00:00','402-0000',NULL,'Cr',4751912.00,0.00,4751912.00,'PLW','NWPI','posted',NULL,NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(329,'GL2024000284','JE2024000013','2024-01-01','2024-01-01 00:00:00','403-0000',NULL,'Cr',10744.00,0.00,10744.00,'PLW','NWPI','posted',NULL,NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(330,'GL2024000285','JE2024000013','2024-01-01','2024-01-01 00:00:00','408-0000',NULL,'Cr',6450.00,0.00,6450.00,'PLW','NWPI','posted',NULL,NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(331,'GL2024000286','JE2024000013','2024-01-01','2024-01-01 00:00:00','409-0000',NULL,'Cr',2145.00,0.00,2145.00,'PLW','NWPI','posted',NULL,NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(332,'GL2024000287','JE2024000013','2024-01-01','2024-01-01 00:00:00','410-0000',NULL,'Cr',2145.00,0.00,2145.00,'PLW','NWPI','posted',NULL,NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(333,'GL2024000288','JE2024000013','2024-01-01','2024-01-01 00:00:00','411-0000',NULL,'Cr',800.00,0.00,800.00,'PLW','NWPI','posted',NULL,NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(334,'GL2024000289','JE2024000013','2024-01-01','2024-01-01 00:00:00','412-0000',NULL,'Cr',800.00,0.00,800.00,'PLW','NWPI','posted',NULL,NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(335,'GL2024000290','JE2024000013','2024-01-01','2024-01-01 00:00:00','413-0000',NULL,'Cr',426.00,0.00,426.00,'PLW','NWPI','posted',NULL,NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(336,'GL2024000291','JE2024000013','2024-01-01','2024-01-01 00:00:00','414-0000',NULL,'Cr',4129.00,0.00,4129.00,'PLW','NWPI','posted',NULL,NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(337,'GL2024000292','JE2024000013','2024-01-01','2024-01-01 00:00:00','415-0000',NULL,'Cr',44153.00,0.00,44153.00,'PLW','NWPI','posted',NULL,NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(338,'GL2024000293','JE2024000013','2024-01-01','2024-01-01 00:00:00','416-0000',NULL,'Cr',23979.00,0.00,23979.00,'PLW','NWPI','posted',NULL,NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(339,'GL2024000294','JE2024000013','2024-01-01','2024-01-01 00:00:00','602-0000',NULL,'Cr',1600000.00,0.00,1600000.00,'PLW','NWPI','posted',NULL,NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(340,'GL2024000295','JE2024000013','2024-01-01','2024-01-01 00:00:00','605-0000',NULL,'Cr',9000000.00,0.00,9000000.00,'PLW','NWPI','posted',NULL,NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(341,'GL2024000296','JE2024000013','2024-01-01','2024-01-01 00:00:00','407-0000',NULL,'Cr',3225.00,0.00,3225.00,'PLW','NWPI','posted',NULL,NULL,'2024-05-31 14:11:53','2024-05-31 14:11:53'),
(342,'GL2024000297','JE2024000014','2024-01-01','2024-01-01 00:00:00','101-0000',NULL,'Dr',603234.00,0.00,603234.00,'TCP','SBPI','posted',NULL,NULL,'2024-05-31 14:22:55','2024-05-31 14:22:55'),
(343,'GL2024000298','JE2024000014','2024-01-01','2024-01-01 00:00:00','104-0000',NULL,'Dr',7130150.00,0.00,7130150.00,'TCP','SBPI','posted',NULL,NULL,'2024-05-31 14:22:55','2024-05-31 14:22:55'),
(344,'GL2024000299','JE2024000014','2024-01-01','2024-01-01 00:00:00','107-0000',NULL,'Dr',250462.00,0.00,250462.00,'TCP','SBPI','posted',NULL,NULL,'2024-05-31 14:22:55','2024-05-31 14:22:55'),
(345,'GL2024000300','JE2024000014','2024-01-01','2024-01-01 00:00:00','702-0000',NULL,'Dr',12407141.00,0.00,-12407141.00,'TCP','SBPI','posted',NULL,NULL,'2024-05-31 14:22:55','2024-05-31 14:22:55'),
(346,'GL2024000301','JE2024000014','2024-01-01','2024-01-01 00:00:00','401-0000',NULL,'Cr',1614113.00,0.00,1614113.00,'TCP','SBPI','posted',NULL,NULL,'2024-05-31 14:22:55','2024-05-31 14:22:55'),
(347,'GL2024000302','JE2024000014','2024-01-01','2024-01-01 00:00:00','403-0000',NULL,'Cr',9256.00,0.00,9256.00,'TCP','SBPI','posted',NULL,NULL,'2024-05-31 14:22:55','2024-05-31 14:22:55'),
(348,'GL2024000303','JE2024000014','2024-01-01','2024-01-01 00:00:00','402-0000',NULL,'Cr',10058250.00,0.00,10058250.00,'TCP','SBPI','posted',NULL,NULL,'2024-05-31 14:22:55','2024-05-31 14:22:55'),
(349,'GL2024000304','JE2024000014','2024-01-01','2024-01-01 00:00:00','421-0000',NULL,'Cr',44.00,0.00,44.00,'TCP','SBPI','posted',NULL,NULL,'2024-05-31 14:22:55','2024-05-31 14:22:55'),
(350,'GL2024000305','JE2024000014','2024-01-01','2024-01-01 00:00:00','405-0000',NULL,'Cr',6899.00,0.00,6899.00,'TCP','SBPI','posted',NULL,NULL,'2024-05-31 14:22:55','2024-05-31 14:22:55'),
(351,'GL2024000306','JE2024000014','2024-01-01','2024-01-01 00:00:00','406-0000',NULL,'Cr',400.00,0.00,400.00,'TCP','SBPI','posted',NULL,NULL,'2024-05-31 14:22:55','2024-05-31 14:22:55'),
(352,'GL2024000307','JE2024000014','2024-01-01','2024-01-01 00:00:00','407-0000',NULL,'Cr',5746.50,0.00,5746.50,'TCP','SBPI','posted',NULL,NULL,'2024-05-31 14:22:55','2024-05-31 14:22:55'),
(353,'GL2024000308','JE2024000014','2024-01-01','2024-01-01 00:00:00','408-0000',NULL,'Cr',11152.37,0.00,11152.37,'TCP','SBPI','posted',NULL,NULL,'2024-05-31 14:22:55','2024-05-31 14:22:55'),
(354,'GL2024000309','JE2024000014','2024-01-01','2024-01-01 00:00:00','409-0000',NULL,'Cr',2116.58,0.00,2116.58,'TCP','SBPI','posted',NULL,NULL,'2024-05-31 14:22:55','2024-05-31 14:22:55'),
(355,'GL2024000310','JE2024000014','2024-01-01','2024-01-01 00:00:00','410-0000',NULL,'Cr',2116.55,0.00,2116.55,'TCP','SBPI','posted',NULL,NULL,'2024-05-31 14:22:55','2024-05-31 14:22:55'),
(356,'GL2024000311','JE2024000014','2024-01-01','2024-01-01 00:00:00','411-0000',NULL,'Cr',700.00,0.00,700.00,'TCP','SBPI','posted',NULL,NULL,'2024-05-31 14:22:55','2024-05-31 14:22:55'),
(357,'GL2024000312','JE2024000014','2024-01-01','2024-01-01 00:00:00','412-0000',NULL,'Cr',700.00,0.00,700.00,'TCP','SBPI','posted',NULL,NULL,'2024-05-31 14:22:55','2024-05-31 14:22:55'),
(358,'GL2024000313','JE2024000014','2024-01-01','2024-01-01 00:00:00','415-0000',NULL,'Cr',47613.00,0.00,47613.00,'TCP','SBPI','posted',NULL,NULL,'2024-05-31 14:22:55','2024-05-31 14:22:55'),
(359,'GL2024000314','JE2024000014','2024-01-01','2024-01-01 00:00:00','416-0000',NULL,'Cr',31880.00,0.00,31880.00,'TCP','SBPI','posted',NULL,NULL,'2024-05-31 14:22:55','2024-05-31 14:22:55'),
(360,'GL2024000315','JE2024000014','2024-01-01','2024-01-01 00:00:00','602-0000',NULL,'Cr',1600000.00,0.00,1600000.00,'TCP','SBPI','posted',NULL,NULL,'2024-05-31 14:22:55','2024-05-31 14:22:55'),
(361,'GL2024000316','JE2024000014','2024-01-01','2024-01-01 00:00:00','605-0000',NULL,'Cr',7000000.00,0.00,7000000.00,'TCP','SBPI','posted',NULL,NULL,'2024-05-31 14:22:55','2024-05-31 14:22:55'),
(362,'GL2024000317','JE2024000015','2024-01-01','2024-01-01 00:00:00','101-0000',NULL,'Dr',634527.00,0.00,634527.00,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(363,'GL2024000318','JE2024000015','2024-01-01','2024-01-01 00:00:00','103-0000',NULL,'Dr',1598793.21,0.00,1598793.21,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(364,'GL2024000319','JE2024000015','2024-01-01','2024-01-01 00:00:00','104-0000',NULL,'Dr',14586180.00,0.00,14586180.00,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(365,'GL2024000320','JE2024000015','2024-01-01','2024-01-01 00:00:00','106-0000',NULL,'Dr',54400.00,0.00,54400.00,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(366,'GL2024000321','JE2024000015','2024-01-01','2024-01-01 00:00:00','107-0000',NULL,'Dr',111367.00,0.00,111367.00,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(367,'GL2024000322','JE2024000015','2024-01-01','2024-01-01 00:00:00','108-0000',NULL,'Dr',615588.00,0.00,615588.00,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(368,'GL2024000323','JE2024000015','2024-01-01','2024-01-01 00:00:00','201-0000',NULL,'Dr',1346393.00,0.00,1346393.00,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(369,'GL2024000324','JE2024000015','2024-01-01','2024-01-01 00:00:00','301-0000',NULL,'Dr',654895.20,0.00,654895.20,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(370,'GL2024000325','JE2024000015','2024-01-01','2024-01-01 00:00:00','303-0000',NULL,'Dr',150.00,0.00,150.00,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(371,'GL2024000326','JE2024000015','2024-01-01','2024-01-01 00:00:00','702-0000',NULL,'Dr',36057969.68,0.00,-36057969.68,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(372,'GL2024000327','JE2024000015','2024-01-01','2024-01-01 00:00:00','202-0000',NULL,'Cr',1346393.00,0.00,-1346393.00,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(373,'GL2024000328','JE2024000015','2024-01-01','2024-01-01 00:00:00','402-0000',NULL,'Cr',15335115.00,0.00,15335115.00,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(374,'GL2024000329','JE2024000015','2024-01-01','2024-01-01 00:00:00','403-0000',NULL,'Cr',18626.40,0.00,18626.40,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(375,'GL2024000330','JE2024000015','2024-01-01','2024-01-01 00:00:00','405-0000',NULL,'Cr',11881.67,0.00,11881.67,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(376,'GL2024000331','JE2024000015','2024-01-01','2024-01-01 00:00:00','406-0000',NULL,'Cr',375.00,0.00,375.00,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(377,'GL2024000332','JE2024000015','2024-01-01','2024-01-01 00:00:00','421-0000',NULL,'Cr',19.92,0.00,19.92,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(378,'GL2024000333','JE2024000015','2024-01-01','2024-01-01 00:00:00','407-0000',NULL,'Cr',21577.50,0.00,21577.50,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(379,'GL2024000334','JE2024000015','2024-01-01','2024-01-01 00:00:00','408-0000',NULL,'Cr',45552.50,0.00,45552.50,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(380,'GL2024000335','JE2024000015','2024-01-01','2024-01-01 00:00:00','409-0000',NULL,'Cr',9600.12,0.00,9600.12,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(381,'GL2024000336','JE2024000015','2024-01-01','2024-01-01 00:00:00','410-0000',NULL,'Cr',9578.08,0.00,9578.08,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(382,'GL2024000337','JE2024000015','2024-01-01','2024-01-01 00:00:00','411-0000',NULL,'Cr',3500.00,0.00,3500.00,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(383,'GL2024000338','JE2024000015','2024-01-01','2024-01-01 00:00:00','412-0000',NULL,'Cr',3500.00,0.00,3500.00,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(384,'GL2024000339','JE2024000015','2024-01-01','2024-01-01 00:00:00','413-0000',NULL,'Cr',5227.15,0.00,5227.15,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(385,'GL2024000340','JE2024000015','2024-01-01','2024-01-01 00:00:00','414-0000',NULL,'Cr',9782.72,0.00,9782.72,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(386,'GL2024000341','JE2024000015','2024-01-01','2024-01-01 00:00:00','415-0000',NULL,'Cr',219925.00,0.00,219925.00,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(387,'GL2024000342','JE2024000015','2024-01-01','2024-01-01 00:00:00','416-0000',NULL,'Cr',19609.03,0.00,19609.03,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(388,'GL2024000343','JE2024000015','2024-01-01','2024-01-01 00:00:00','602-0000',NULL,'Cr',1600000.00,0.00,1600000.00,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38'),
(389,'GL2024000344','JE2024000015','2024-01-01','2024-01-01 00:00:00','605-0000',NULL,'Cr',37000000.00,0.00,37000000.00,'STZP','YEPI','posted',NULL,NULL,'2024-05-31 14:45:38','2024-05-31 14:45:38');

--
-- Table structure for table `tbl_ledgers`
--

CREATE TABLE `tbl_ledgers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `acc_code` varchar(255) NOT NULL,
  `period` varchar(255) NOT NULL,
  `posted_date` date NOT NULL,
  `trans_from` date NOT NULL,
  `trans_to` date NOT NULL,
  `beginning_balance` decimal(18,2) DEFAULT 0.00,
  `ending_balance` decimal(18,2) DEFAULT 0.00,
  `normal_balance` varchar(255) NOT NULL,
  `sub_book` varchar(255) DEFAULT 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`),
  KEY `tbl_ledgers_acc_code_index` (`acc_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_ledgers`
--


--
-- Table structure for table `tbl_chart_of_accounts`
--

CREATE TABLE `tbl_chart_of_accounts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `parent` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `normal_balance` varchar(255) NOT NULL,
  `node` int(11) NOT NULL,
  `level` int(11) NOT NULL,
  `order` int(11) NOT NULL,
  `custom_code` varchar(255) DEFAULT 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_chart_of_accounts_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_chart_of_accounts`
--

INSERT INTO `tbl_chart_of_accounts` VALUES
(1,'100-0000','0','assets','CURRENT ASSETS','Dr',0,1,1,'1000',1,'admin',NULL,NULL,'2024-05-21 23:30:49','2024-05-21 23:30:49'),
(2,'200-0000','0','assets','FIXED ASSETS','Dr',0,1,2,'2000',1,'admin',NULL,NULL,'2024-05-21 23:31:22','2024-05-21 23:31:22'),
(3,'101-0000','100-0000','assets','CASH ON HAND','Dr',1,2,1,'0001',1,'admin',NULL,NULL,'2024-05-21 23:31:56','2024-05-21 23:31:56'),
(4,'102-0000','100-0000','assets','CASH IN BANK','Dr',1,2,2,'0002',1,'admin',NULL,NULL,'2024-05-21 23:32:16','2024-05-21 23:32:16'),
(5,'103-0000','100-0000','assets','ACCOUNTS RECEIVABLE','Dr',1,2,3,'0003',1,'admin',NULL,NULL,'2024-05-21 23:32:55','2024-05-21 23:32:55'),
(6,'104-0000','100-0000','assets','PLEDGED LOAN INVENTORY','Dr',1,2,4,'0004',1,'admin',NULL,NULL,'2024-05-21 23:33:30','2024-05-21 23:33:30'),
(7,'105-0000','100-0000','assets','ACQUIRED PROPERTIES','Dr',1,2,5,'0004A',1,'admin',NULL,NULL,'2024-05-21 23:33:58','2024-05-21 23:33:58'),
(8,'106-0000','100-0000','assets','RECOVERABLE DEPOSITES','Dr',1,2,6,'0005',1,'admin',NULL,NULL,'2024-05-21 23:34:21','2024-05-21 23:34:21'),
(9,'201-0000','200-0000','assets','LEASEHOLD IMPROVEMENT','Dr',1,2,1,'0006',1,'admin',NULL,NULL,'2024-05-21 23:34:51','2024-05-21 23:34:51'),
(10,'202-0000','200-0000','assets','ACCUM.DEP.-LEASEHOLD IMPROVEMENT','Dr',1,2,2,'0007',1,'admin',NULL,NULL,'2024-05-21 23:35:45','2024-05-21 23:35:45'),
(11,'203-0000','200-0000','assets','OFFICE EQUIPMENT','Dr',1,2,3,'0008',1,'admin',NULL,NULL,'2024-05-21 23:36:12','2024-05-21 23:36:12'),
(12,'204-0000','200-0000','assets','ACCUM.DEP.-OFFICE EQUIPMENT','Dr',1,2,4,'0009',1,'admin',NULL,NULL,'2024-05-21 23:36:39','2024-05-21 23:36:39'),
(13,'205-0000','200-0000','assets','FURNITURE AND FIXTURES','Dr',1,2,5,'0010',1,'admin',NULL,NULL,'2024-05-21 23:37:23','2024-05-21 23:37:23'),
(14,'206-0000','200-0000','assets','ACCUM.DEP.-FURNITURE & FICTURES','Dr',1,2,6,'0011',1,'admin',NULL,NULL,'2024-05-21 23:37:58','2024-05-21 23:37:58'),
(15,'300-0000','0','assets','OTHER ASSETS','Dr',0,1,3,'3000',1,'admin',NULL,NULL,'2024-05-21 23:39:08','2024-05-21 23:39:08'),
(16,'301-0000','300-0000','assets','DEFFERED CHARGES','Dr',1,2,1,'0012',1,'admin','admin',NULL,'2024-05-21 23:39:38','2024-05-28 04:05:46'),
(17,'302-0000','300-0000','assets','DUE FROM BRANCHES','Dr',1,2,3,'0013',1,'admin','admin',NULL,'2024-05-21 23:40:11','2024-05-28 05:02:40'),
(18,'400-0000','0','liabilities','CURRENT LIABILITIES','Cr',0,1,4,'4000',1,'admin',NULL,NULL,'2024-05-21 23:41:50','2024-05-21 23:41:50'),
(19,'401-0000','400-0000','liabilities','ACCOUNTS PAYABLE','Cr',1,2,1,'0014',1,'admin',NULL,NULL,'2024-05-21 23:42:30','2024-05-21 23:42:30'),
(20,'402-0000','400-0000','liabilities','ADVANCES FROM STAKEHOLDERS','Cr',1,2,2,'0014A',1,'admin',NULL,NULL,'2024-05-21 23:43:09','2024-05-21 23:43:09'),
(21,'403-0000','400-0000','liabilities','DOCUMENTARY STAMP TAX PAYABLE','Cr',1,2,3,'0015',1,'admin',NULL,NULL,'2024-05-21 23:45:09','2024-05-21 23:45:09'),
(22,'404-0000','400-0000','liabilities','WITHHOLDING TAX PAYABLE','Cr',1,2,4,'0016',1,'admin',NULL,NULL,'2024-05-21 23:45:56','2024-05-21 23:45:56'),
(23,'405-0000','400-0000','liabilities','WITHHOLDING TAX PAYABLE - RENT','Cr',1,2,5,'0017',1,'admin',NULL,NULL,'2024-05-21 23:46:20','2024-05-21 23:46:20'),
(24,'406-0000','400-0000','liabilities','WITHHOLDING TAX PAYABLE - PROFESSIONALS','Cr',1,2,6,'0018',1,'admin',NULL,NULL,'2024-05-21 23:46:48','2024-05-21 23:46:48'),
(25,'407-0000','400-0000','liabilities','SSS PREMIUM PAYABLE - EMPLOYEE','Cr',1,2,7,'0019',1,'admin','admin',NULL,'2024-05-21 23:47:14','2024-05-21 23:48:11'),
(26,'408-0000','400-0000','liabilities','SSS/ECC PREMIUM PAYABLE-EMPLOYER','Cr',1,2,8,'0020',1,'admin',NULL,NULL,'2024-05-21 23:48:37','2024-05-21 23:48:37'),
(27,'409-0000','400-0000','liabilities','PHILHEALTH PREMIUM PAYABLE-EMPLOYEE','Cr',1,2,9,'0021',1,'admin',NULL,NULL,'2024-05-21 23:49:02','2024-05-21 23:49:02'),
(28,'410-0000','400-0000','liabilities','PHILHEALTH PREMIUM PAYABLE-EMPLOYER','Cr',1,2,10,'0022',1,'admin',NULL,NULL,'2024-05-21 23:49:26','2024-05-21 23:49:26'),
(29,'411-0000','400-0000','liabilities','PAG-IBIG PREMIUM PAYABLE-EMPLOYEE','Cr',1,2,11,'0023',1,'admin',NULL,NULL,'2024-05-21 23:49:52','2024-05-21 23:49:52'),
(30,'412-0000','400-0000','liabilities','PAG-IBIG PREMIUM PAYABLE-EMPLOYER','Cr',1,2,12,'0024',1,'admin',NULL,NULL,'2024-05-21 23:50:09','2024-05-21 23:50:09'),
(31,'413-0000','400-0000','liabilities','PAG-IBIG LOAN PAYABLE','Cr',1,2,13,'0025',1,'admin',NULL,NULL,'2024-05-21 23:50:32','2024-05-21 23:50:32'),
(32,'414-0000','400-0000','liabilities','SSS LOAN PAYABLE','Cr',1,2,14,'0026',1,'admin',NULL,NULL,'2024-05-21 23:50:49','2024-05-21 23:50:49'),
(33,'415-0000','400-0000','liabilities','DEFFERED INCOME','Cr',1,2,15,'0027',1,'admin',NULL,NULL,'2024-05-21 23:51:07','2024-05-21 23:51:07'),
(34,'416-0000','400-0000','liabilities','ACCRUED EXPENSE','Cr',1,2,16,'0028',1,'admin',NULL,NULL,'2024-05-21 23:51:26','2024-05-21 23:51:26'),
(35,'417-0000','400-0000','liabilities','INCOME TAX PAYABLE','Cr',1,2,17,'031A',1,'admin',NULL,NULL,'2024-05-21 23:52:29','2024-05-21 23:52:29'),
(36,'418-0000','400-0000','liabilities','HOME OFFICE','Cr',1,2,18,'0029',1,'admin',NULL,NULL,'2024-05-21 23:52:49','2024-05-21 23:52:49'),
(37,'500-0000','0','liabilities','LONG TERM LIABILITIES','Cr',0,1,5,'5000',1,'admin','admin',NULL,'2024-05-21 23:53:42','2024-05-22 00:06:21'),
(38,'501-0000','500-0000','liabilities','LOANS PAYABLE','Cr',1,2,1,'0030',1,'admin','admin',NULL,'2024-05-21 23:54:30','2024-05-22 00:06:01'),
(39,'600-0000','0','equity','STOCKHOLDERS EQUITY','Cr',0,1,6,'6000',1,'admin',NULL,NULL,'2024-05-21 23:55:29','2024-05-21 23:55:29'),
(40,'601-0000','600-0000','equity','AUTHORIZED CAPITAL STOCK','Cr',1,2,1,'0031',1,'admin',NULL,NULL,'2024-05-21 23:56:05','2024-05-21 23:56:05'),
(41,'602-0000','600-0000','equity','SHARE CAPITAL STOCK','Cr',1,2,2,'0032',1,'admin',NULL,NULL,'2024-05-21 23:56:26','2024-05-21 23:56:26'),
(42,'603-0000','600-0000','equity','SUBSCRIBE CAPITAL STOCK','Cr',1,2,3,'0033',1,'admin',NULL,NULL,'2024-05-21 23:57:10','2024-05-21 23:57:10'),
(43,'604-0000','600-0000','equity','SUBSCRIPTION RECEIVABLE','Cr',1,2,4,'0034',1,'admin',NULL,NULL,'2024-05-21 23:57:30','2024-05-21 23:57:30'),
(44,'605-0000','600-0000','equity','STOCKHOLDERS DEPOSIT PENDING SEC','Cr',1,2,5,'0035',1,'admin',NULL,NULL,'2024-05-21 23:57:52','2024-05-21 23:57:52'),
(45,'700-0000','0','equity','PAID UP CAPITAL','Cr',0,1,7,'7000',1,'admin','admin',NULL,'2024-05-21 23:58:56','2024-05-22 00:05:23'),
(46,'701-0000','700-0000','equity','ADDITIONAL PAID-IN CAPITAL','Cr',1,2,1,'0036',1,'admin','admin',NULL,'2024-05-21 23:59:38','2024-05-22 00:05:38'),
(47,'702-0000','700-0000','equity','RETAINED EARNINGS','Cr',1,2,2,'0037',1,'admin','admin',NULL,'2024-05-21 23:59:57','2024-05-22 00:05:49'),
(48,'800-0000','0','income','GROSS INCOME','Cr',0,1,8,'8000',1,'admin',NULL,NULL,'2024-05-22 00:01:28','2024-05-22 00:01:28'),
(49,'801-0000','800-0000','income','Gain/Loss on Sale of Assets','Cr',1,2,1,'0038',1,'admin',NULL,NULL,'2024-05-22 00:01:59','2024-05-22 00:01:59'),
(50,'802-0000','800-0000','income','Interest Income','Cr',1,2,2,'0039',1,'admin',NULL,NULL,'2024-05-22 00:02:49','2024-05-22 00:02:49'),
(51,'803-0000','800-0000','income','Money Remittance/Commission Income','Cr',1,2,3,'0040',1,'admin',NULL,NULL,'2024-05-22 00:03:35','2024-05-22 00:03:35'),
(52,'804-0000','800-0000','income','Money Changer/Service Income','Cr',1,2,4,'0041',1,'admin',NULL,NULL,'2024-05-22 00:04:03','2024-05-22 00:04:03'),
(53,'900-0000','0','expense','OPERATING EXPENSES','Dr',0,1,9,'9000',1,'admin',NULL,NULL,'2024-05-22 00:05:07','2024-05-22 00:05:07'),
(54,'901-0000','900-0000','expense','Salaries & Wages','Dr',1,2,1,'0042',1,'admin',NULL,NULL,'2024-05-22 00:08:08','2024-05-22 00:08:08'),
(55,'902-0000','900-0000','expense','SSS/ECC Premium - Co Share','Dr',1,2,2,'0043',1,'admin',NULL,NULL,'2024-05-22 00:08:29','2024-05-22 00:08:29'),
(56,'903-0000','900-0000','expense','Pag-ibig Premium - Co Share','Dr',1,2,3,'0044',1,'admin',NULL,NULL,'2024-05-22 00:08:50','2024-05-22 00:08:50'),
(57,'904-0000','900-0000','expense','Philhealth Premium - Co Share','Dr',1,2,4,'0045',1,'admin',NULL,NULL,'2024-05-22 00:09:11','2024-05-22 00:09:11'),
(58,'905-0000','900-0000','expense','Mgnt. & Other Prof. Fees','Dr',1,2,5,'0046',1,'admin',NULL,NULL,'2024-05-22 00:09:30','2024-05-22 00:09:30'),
(59,'906-0000','900-0000','expense','Rent','Dr',1,2,6,'0047',1,'admin',NULL,NULL,'2024-05-22 00:09:51','2024-05-22 00:09:51'),
(60,'907-0000','900-0000','expense','Taxes & Licenses','Dr',1,2,7,'0048',1,'admin',NULL,NULL,'2024-05-22 00:10:11','2024-05-22 00:10:11'),
(61,'908-0000','900-0000','expense','Light & Water','Dr',1,2,8,'0049',1,'admin',NULL,NULL,'2024-05-22 00:10:35','2024-05-22 00:10:35'),
(62,'909-0000','900-0000','expense','Depreciation-L/I','Dr',1,2,9,'0050',1,'admin',NULL,NULL,'2024-05-22 00:10:57','2024-05-22 00:10:57'),
(63,'910-0000','900-0000','expense','Depreciation-Office Equipment','Dr',1,2,10,'0051',1,'admin',NULL,NULL,'2024-05-22 00:11:16','2024-05-22 00:11:16'),
(64,'911-0000','900-0000','expense','Publication Expense','Dr',1,2,11,'0052',1,'admin',NULL,NULL,'2024-05-22 00:11:38','2024-05-22 00:11:38'),
(65,'912-0000','900-0000','expense','Printing Expense','Dr',1,2,12,'0053',1,'admin',NULL,NULL,'2024-05-22 00:11:57','2024-05-22 00:11:57'),
(66,'913-0000','900-0000','expense','Office Supplies','Dr',1,2,13,'0054',1,'admin',NULL,NULL,'2024-05-22 00:12:19','2024-05-22 00:12:19'),
(67,'914-0000','900-0000','expense','13th month pay','Dr',1,2,14,'0055',1,'admin',NULL,NULL,'2024-05-22 00:12:36','2024-05-22 00:12:36'),
(68,'419-0000','400-0000','liabilities','VAT PAYABLE','Cr',1,2,19,'0029A',1,'admin',NULL,NULL,'2024-05-28 04:01:57','2024-05-28 04:01:57'),
(69,'107-0000','100-0000','assets','PREPAID TAX','Dr',1,2,7,'0005A',1,'admin',NULL,NULL,'2024-05-28 04:36:08','2024-05-28 04:36:08'),
(70,'303-0000','300-0000','assets','EQUITY INVESTMENTS','Dr',1,2,2,'0012A',1,'admin',NULL,NULL,'2024-05-28 05:01:39','2024-05-28 05:01:39'),
(71,'420-0000','400-0000','liabilities','WITHHOLDING TAX PAYABLE-PRINTING','Cr',1,2,7,'0018A',1,'admin',NULL,NULL,'2024-05-28 05:04:36','2024-05-28 05:04:36'),
(72,'421-0000','400-0000','liabilities','WITHHOLDING TAX PAYABLE-CUSA','Cr',1,2,7,'0018B',1,'admin',NULL,NULL,'2024-05-28 05:05:01','2024-05-28 05:05:01'),
(73,'422-0000','400-0000','liabilities','WITHHOLDING TAX PAYABLE-LIGHT&WATER','Cr',1,2,8,'0018C',1,'admin',NULL,NULL,'2024-05-30 10:07:18','2024-05-30 10:07:18'),
(74,'108-0000','100-0000','assets','REFUNDABLE','Dr',1,2,8,'0005B',1,'admin',NULL,NULL,'2024-05-31 01:43:11','2024-05-31 01:43:11');

--
-- Dumping events for database 'ftlp_acctg'
--


