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


--
-- Table structure for table `tbl_journal_details`
--

CREATE TABLE `tbl_journal_details` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `journal_code` varchar(255) NOT NULL,
  `key` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
  `particulars` varchar(255) DEFAULT NULL,
  `status` int(11) 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 AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_journal_details`
--

INSERT INTO `tbl_journal_details` VALUES
(1,'JE2024000001','type','journal',NULL,0,NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(2,'JE2024000001','entry_date','2024-05-28',NULL,0,NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(3,'JE2024000001','transaction_date','2024-01-01',NULL,0,NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(4,'JE2024000001','entity','NA',NULL,0,NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(5,'JE2024000001','reference_number','JV-202405-0001',NULL,0,NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(6,'JE2024000001','amount','23975449.00',NULL,0,NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(7,'JE2024000001','particulars','Global Reliance - Beginning Balance',NULL,0,NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(8,'JE2024000001','status','draft',NULL,0,NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(9,'JE2024000001','created_by','admin',NULL,0,NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(10,'JE2024000002','type','journal',NULL,0,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(11,'JE2024000002','entry_date','2024-05-28',NULL,0,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(12,'JE2024000002','transaction_date','2024-01-01',NULL,0,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(13,'JE2024000002','entity','NA',NULL,0,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(14,'JE2024000002','reference_number','JV-202405-0002',NULL,0,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(15,'JE2024000002','amount','58539168.00',NULL,0,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(16,'JE2024000002','particulars','Princess Cut - Beginning Balance',NULL,0,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(17,'JE2024000002','status','draft',NULL,0,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(18,'JE2024000002','created_by','admin',NULL,0,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24');

--
-- Table structure for table `tbl_ledger_details`
--

CREATE TABLE `tbl_ledger_details` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ledger_id` varchar(255) NOT NULL,
  `ledger_code` varchar(255) DEFAULT NULL,
  `type` varchar(255) NOT NULL,
  `key` varchar(255) NOT NULL,
  `value` 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`)
) ENGINE=InnoDB AUTO_INCREMENT=911 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_ledger_details`
--

INSERT INTO `tbl_ledger_details` VALUES
(1,'1',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(2,'1',NULL,'GL','account','102-0000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(3,'1',NULL,'GL','customCode','0002','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(4,'1',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(5,'1',NULL,'GL','amount','5326505','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(6,'1',NULL,'GL','normalBalance','Dr','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(7,'1',NULL,'GL','accountName','CASH IN BANK','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(8,'1',NULL,'GL','counter','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(9,'1',NULL,'GL','index','0','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(10,'1',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(11,'1',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(12,'1',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(13,'1',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(14,'2',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(15,'2',NULL,'GL','account','301-0000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(16,'2',NULL,'GL','customCode','0012','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(17,'2',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(18,'2',NULL,'GL','amount','3635075','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(19,'2',NULL,'GL','normalBalance','Dr','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(20,'2',NULL,'GL','accountName','DEFFERED ASSETS','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(21,'2',NULL,'GL','counter','2','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(22,'2',NULL,'GL','index','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(23,'2',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(24,'2',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(25,'2',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(26,'2',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(27,'3',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(28,'3',NULL,'GL','account','201-0000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(29,'3',NULL,'GL','customCode','0006','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(30,'3',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(31,'3',NULL,'GL','amount','22780','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(32,'3',NULL,'GL','normalBalance','Dr','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(33,'3',NULL,'GL','accountName','LEASEHOLD IMPROVEMENT','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(34,'3',NULL,'GL','counter','3','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(35,'3',NULL,'GL','index','2','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(36,'3',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(37,'3',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(38,'3',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(39,'3',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(40,'4',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(41,'4',NULL,'GL','account','702-0000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(42,'4',NULL,'GL','customCode','0037','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(43,'4',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(44,'4',NULL,'GL','amount','14991089','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(45,'4',NULL,'GL','normalBalance','Dr','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(46,'4',NULL,'GL','accountName','RETAINED EARNINGS','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(47,'4',NULL,'GL','counter','4','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(48,'4',NULL,'GL','index','21','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(49,'4',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(50,'4',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(51,'4',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(52,'4',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(53,'5',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(54,'5',NULL,'GL','account','202-0000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(55,'5',NULL,'GL','customCode','0007','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(56,'5',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(57,'5',NULL,'GL','amount','22780','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(58,'5',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(59,'5',NULL,'GL','accountName','ACCUM.DEP.-LEASEHOLD IMPROVEMENT','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(60,'5',NULL,'GL','counter','5','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(61,'5',NULL,'GL','index','3','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(62,'5',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(63,'5',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(64,'5',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(65,'5',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(66,'6',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(67,'6',NULL,'GL','account','402-0000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(68,'6',NULL,'GL','customCode','0014A','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(69,'6',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(70,'6',NULL,'GL','amount','10000000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(71,'6',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(72,'6',NULL,'GL','accountName','ADVANCES FROM STAKEHOLDERS','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(73,'6',NULL,'GL','counter','6','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(74,'6',NULL,'GL','index','5','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(75,'6',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(76,'6',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(77,'6',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(78,'6',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(79,'7',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(80,'7',NULL,'GL','account','406-0000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(81,'7',NULL,'GL','customCode','0018','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(82,'7',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(83,'7',NULL,'GL','amount','100','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(84,'7',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(85,'7',NULL,'GL','accountName','WITHHOLDING TAX PAYABLE - PROFESSIONALS','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(86,'7',NULL,'GL','counter','7','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(87,'7',NULL,'GL','index','7','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(88,'7',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(89,'7',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(90,'7',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(91,'7',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(92,'8',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(93,'8',NULL,'GL','account','407-0000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(94,'8',NULL,'GL','customCode','0019','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(95,'8',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(96,'8',NULL,'GL','amount','100732.50','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(97,'8',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(98,'8',NULL,'GL','accountName','SSS PREMIUM PAYABLE - EMPLOYEE','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(99,'8',NULL,'GL','counter','8','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(100,'8',NULL,'GL','index','8','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(101,'8',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(102,'8',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(103,'8',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(104,'8',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(105,'9',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(106,'9',NULL,'GL','account','408-0000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(107,'9',NULL,'GL','customCode','0020','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(108,'9',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(109,'9',NULL,'GL','amount','215817.50','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(110,'9',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(111,'9',NULL,'GL','accountName','SSS/ECC PREMIUM PAYABLE-EMPLOYER','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(112,'9',NULL,'GL','counter','9','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(113,'9',NULL,'GL','index','9','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(114,'9',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(115,'9',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(116,'9',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(117,'9',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(118,'10',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(119,'10',NULL,'GL','account','411-0000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(120,'10',NULL,'GL','customCode','0023','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(121,'10',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(122,'10',NULL,'GL','amount','16300','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(123,'10',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(124,'10',NULL,'GL','accountName','PAG-IBIG PREMIUM PAYABLE-EMPLOYEE','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(125,'10',NULL,'GL','counter','10','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(126,'10',NULL,'GL','index','12','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(127,'10',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(128,'10',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(129,'10',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(130,'10',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(131,'11',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(132,'11',NULL,'GL','account','412-0000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(133,'11',NULL,'GL','customCode','0024','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(134,'11',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(135,'11',NULL,'GL','amount','16200','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(136,'11',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(137,'11',NULL,'GL','accountName','PAG-IBIG PREMIUM PAYABLE-EMPLOYER','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(138,'11',NULL,'GL','counter','11','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(139,'11',NULL,'GL','index','13','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(140,'11',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(141,'11',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(142,'11',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(143,'11',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(144,'12',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(145,'12',NULL,'GL','account','601-0000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(146,'12',NULL,'GL','customCode','0031','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(147,'12',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(148,'12',NULL,'GL','amount','1600000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(149,'12',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(150,'12',NULL,'GL','accountName','AUTHORIZED CAPITAL STOCK','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(151,'12',NULL,'GL','counter','12','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(152,'12',NULL,'GL','index','17','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(153,'12',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(154,'12',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(155,'12',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(156,'12',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(157,'13',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(158,'13',NULL,'GL','account','605-0000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(159,'13',NULL,'GL','customCode','0035','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(160,'13',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(161,'13',NULL,'GL','amount','5500000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(162,'13',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(163,'13',NULL,'GL','accountName','STOCKHOLDERS DEPOSIT PENDING SEC','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(164,'13',NULL,'GL','counter','13','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(165,'13',NULL,'GL','index','18','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(166,'13',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(167,'13',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(168,'13',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(169,'13',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(170,'14',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(171,'14',NULL,'GL','account','405-0000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(172,'14',NULL,'GL','customCode','0017','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(173,'14',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(174,'14',NULL,'GL','amount','302','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(175,'14',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(176,'14',NULL,'GL','accountName','WITHHOLDING TAX PAYABLE - RENT','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(177,'14',NULL,'GL','counter','14','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(178,'14',NULL,'GL','index','27','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(179,'14',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(180,'14',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(181,'14',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(182,'14',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(183,'15',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(184,'15',NULL,'GL','account','410-0000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(185,'15',NULL,'GL','customCode','0022','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(186,'15',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(187,'15',NULL,'GL','amount','44792','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(188,'15',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(189,'15',NULL,'GL','accountName','PHILHEALTH PREMIUM PAYABLE-EMPLOYER','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(190,'15',NULL,'GL','counter','15','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(191,'15',NULL,'GL','index','28','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(192,'15',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(193,'15',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(194,'15',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(195,'15',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(196,'16',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(197,'16',NULL,'GL','account','401-0000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(198,'16',NULL,'GL','customCode','0014','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(199,'16',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(200,'16',NULL,'GL','amount','5642688','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(201,'16',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(202,'16',NULL,'GL','accountName','ACCOUNTS PAYABLE','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(203,'16',NULL,'GL','counter','16','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(204,'16',NULL,'GL','index','29','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(205,'16',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(206,'16',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(207,'16',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(208,'16',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(209,'17',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(210,'17',NULL,'GL','account','413-0000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(211,'17',NULL,'GL','customCode','0025','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(212,'17',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(213,'17',NULL,'GL','amount','16319','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(214,'17',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(215,'17',NULL,'GL','accountName','PAG-IBIG LOAN PAYABLE','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(216,'17',NULL,'GL','counter','17','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(217,'17',NULL,'GL','index','30','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(218,'17',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(219,'17',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(220,'17',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(221,'17',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(222,'18',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(223,'18',NULL,'GL','account','409-0000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(224,'18',NULL,'GL','customCode','0021','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(225,'18',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(226,'18',NULL,'GL','amount','44792','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(227,'18',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(228,'18',NULL,'GL','accountName','PHILHEALTH PREMIUM PAYABLE-EMPLOYEE','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(229,'18',NULL,'GL','counter','18','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(230,'18',NULL,'GL','index','31','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(231,'18',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(232,'18',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(233,'18',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(234,'18',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(235,'19',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(236,'19',NULL,'GL','account','414-0000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(237,'19',NULL,'GL','customCode','0026','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(238,'19',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(239,'19',NULL,'GL','amount','46774','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(240,'19',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(241,'19',NULL,'GL','accountName','SSS LOAN PAYABLE','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(242,'19',NULL,'GL','counter','19','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(243,'19',NULL,'GL','index','32','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(244,'19',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(245,'19',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(246,'19',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(247,'19',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(248,'20',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(249,'20',NULL,'GL','account','419-0000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(250,'20',NULL,'GL','customCode','0029A','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(251,'20',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(252,'20',NULL,'GL','amount','707849','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(253,'20',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(254,'20',NULL,'GL','accountName','VAT PAYABLE','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(255,'20',NULL,'GL','counter','20','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(256,'20',NULL,'GL','index','33','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(257,'20',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(258,'20',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(259,'20',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(260,'20',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(261,'21',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(262,'21',NULL,'GL','account','416-0000','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(263,'21',NULL,'GL','customCode','0028','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(264,'21',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(265,'21',NULL,'GL','amount','3','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(266,'21',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(267,'21',NULL,'GL','accountName','ACCRUED EXPENSE','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(268,'21',NULL,'GL','counter','21','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(269,'21',NULL,'GL','index','35','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(270,'21',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(271,'21',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(272,'21',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(273,'21',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:18:37','2024-05-28 12:18:37'),
(274,'22',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(275,'22',NULL,'GL','account','102-0000','draft',NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(276,'22',NULL,'GL','customCode','0002','draft',NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(277,'22',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(278,'22',NULL,'GL','amount','5326505','draft',NULL,'2024-05-28 12:21:07','2024-05-28 12:21:07'),
(279,'22',NULL,'GL','normalBalance','Dr','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(280,'22',NULL,'GL','accountName','CASH IN BANK','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(281,'22',NULL,'GL','counter','1','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(282,'22',NULL,'GL','index','0','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(283,'22',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(284,'22',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(285,'22',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(286,'22',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(287,'23',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(288,'23',NULL,'GL','account','301-0000','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(289,'23',NULL,'GL','customCode','0012','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(290,'23',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(291,'23',NULL,'GL','amount','3635075','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(292,'23',NULL,'GL','normalBalance','Dr','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(293,'23',NULL,'GL','accountName','DEFFERED ASSETS','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(294,'23',NULL,'GL','counter','2','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(295,'23',NULL,'GL','index','1','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(296,'23',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(297,'23',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(298,'23',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(299,'23',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(300,'24',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(301,'24',NULL,'GL','account','201-0000','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(302,'24',NULL,'GL','customCode','0006','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(303,'24',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(304,'24',NULL,'GL','amount','22780','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(305,'24',NULL,'GL','normalBalance','Dr','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(306,'24',NULL,'GL','accountName','LEASEHOLD IMPROVEMENT','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(307,'24',NULL,'GL','counter','3','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(308,'24',NULL,'GL','index','2','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(309,'24',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(310,'24',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(311,'24',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(312,'24',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(313,'25',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(314,'25',NULL,'GL','account','702-0000','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(315,'25',NULL,'GL','customCode','0037','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(316,'25',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(317,'25',NULL,'GL','amount','14991089','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(318,'25',NULL,'GL','normalBalance','Dr','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(319,'25',NULL,'GL','accountName','RETAINED EARNINGS','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(320,'25',NULL,'GL','counter','4','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(321,'25',NULL,'GL','index','21','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(322,'25',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(323,'25',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(324,'25',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(325,'25',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(326,'26',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(327,'26',NULL,'GL','account','202-0000','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(328,'26',NULL,'GL','customCode','0007','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(329,'26',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(330,'26',NULL,'GL','amount','22780','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(331,'26',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(332,'26',NULL,'GL','accountName','ACCUM.DEP.-LEASEHOLD IMPROVEMENT','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(333,'26',NULL,'GL','counter','5','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(334,'26',NULL,'GL','index','3','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(335,'26',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(336,'26',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(337,'26',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(338,'26',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(339,'27',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(340,'27',NULL,'GL','account','402-0000','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(341,'27',NULL,'GL','customCode','0014A','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(342,'27',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(343,'27',NULL,'GL','amount','10000000','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(344,'27',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(345,'27',NULL,'GL','accountName','ADVANCES FROM STAKEHOLDERS','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(346,'27',NULL,'GL','counter','6','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(347,'27',NULL,'GL','index','5','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(348,'27',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(349,'27',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(350,'27',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(351,'27',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(352,'28',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(353,'28',NULL,'GL','account','406-0000','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(354,'28',NULL,'GL','customCode','0018','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(355,'28',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(356,'28',NULL,'GL','amount','100','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(357,'28',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(358,'28',NULL,'GL','accountName','WITHHOLDING TAX PAYABLE - PROFESSIONALS','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(359,'28',NULL,'GL','counter','7','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(360,'28',NULL,'GL','index','7','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(361,'28',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(362,'28',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(363,'28',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(364,'28',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(365,'29',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(366,'29',NULL,'GL','account','407-0000','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(367,'29',NULL,'GL','customCode','0019','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(368,'29',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(369,'29',NULL,'GL','amount','100732.50','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(370,'29',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(371,'29',NULL,'GL','accountName','SSS PREMIUM PAYABLE - EMPLOYEE','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(372,'29',NULL,'GL','counter','8','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(373,'29',NULL,'GL','index','8','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(374,'29',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(375,'29',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(376,'29',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(377,'29',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(378,'30',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(379,'30',NULL,'GL','account','408-0000','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(380,'30',NULL,'GL','customCode','0020','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(381,'30',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(382,'30',NULL,'GL','amount','215817.50','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(383,'30',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(384,'30',NULL,'GL','accountName','SSS/ECC PREMIUM PAYABLE-EMPLOYER','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(385,'30',NULL,'GL','counter','9','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(386,'30',NULL,'GL','index','9','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(387,'30',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(388,'30',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(389,'30',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(390,'30',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(391,'31',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(392,'31',NULL,'GL','account','411-0000','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(393,'31',NULL,'GL','customCode','0023','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(394,'31',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(395,'31',NULL,'GL','amount','16300','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(396,'31',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(397,'31',NULL,'GL','accountName','PAG-IBIG PREMIUM PAYABLE-EMPLOYEE','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(398,'31',NULL,'GL','counter','10','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(399,'31',NULL,'GL','index','12','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(400,'31',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(401,'31',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(402,'31',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(403,'31',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(404,'32',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(405,'32',NULL,'GL','account','412-0000','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(406,'32',NULL,'GL','customCode','0024','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(407,'32',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(408,'32',NULL,'GL','amount','16200','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(409,'32',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(410,'32',NULL,'GL','accountName','PAG-IBIG PREMIUM PAYABLE-EMPLOYER','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(411,'32',NULL,'GL','counter','11','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(412,'32',NULL,'GL','index','13','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(413,'32',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(414,'32',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(415,'32',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(416,'32',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(417,'33',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(418,'33',NULL,'GL','account','601-0000','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(419,'33',NULL,'GL','customCode','0031','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(420,'33',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(421,'33',NULL,'GL','amount','1600000','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(422,'33',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(423,'33',NULL,'GL','accountName','AUTHORIZED CAPITAL STOCK','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(424,'33',NULL,'GL','counter','12','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(425,'33',NULL,'GL','index','17','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(426,'33',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(427,'33',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(428,'33',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(429,'33',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(430,'34',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(431,'34',NULL,'GL','account','605-0000','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(432,'34',NULL,'GL','customCode','0035','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(433,'34',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(434,'34',NULL,'GL','amount','5500000','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(435,'34',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(436,'34',NULL,'GL','accountName','STOCKHOLDERS DEPOSIT PENDING SEC','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(437,'34',NULL,'GL','counter','13','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(438,'34',NULL,'GL','index','18','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(439,'34',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(440,'34',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(441,'34',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(442,'34',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(443,'35',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(444,'35',NULL,'GL','account','413-0000','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(445,'35',NULL,'GL','customCode','0025','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(446,'35',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(447,'35',NULL,'GL','amount','16319.12','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(448,'35',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(449,'35',NULL,'GL','accountName','PAG-IBIG LOAN PAYABLE','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(450,'35',NULL,'GL','counter','14','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(451,'35',NULL,'GL','index','0','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(452,'35',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(453,'35',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(454,'35',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(455,'35',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(456,'36',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(457,'36',NULL,'GL','account','405-0000','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(458,'36',NULL,'GL','customCode','0017','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(459,'36',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(460,'36',NULL,'GL','amount','302.63','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(461,'36',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(462,'36',NULL,'GL','accountName','WITHHOLDING TAX PAYABLE - RENT','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(463,'36',NULL,'GL','counter','15','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(464,'36',NULL,'GL','index','1','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(465,'36',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(466,'36',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(467,'36',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(468,'36',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(469,'37',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(470,'37',NULL,'GL','account','409-0000','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(471,'37',NULL,'GL','customCode','0021','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(472,'37',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(473,'37',NULL,'GL','amount','44792.54','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(474,'37',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(475,'37',NULL,'GL','accountName','PHILHEALTH PREMIUM PAYABLE-EMPLOYEE','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(476,'37',NULL,'GL','counter','16','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(477,'37',NULL,'GL','index','2','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(478,'37',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(479,'37',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(480,'37',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(481,'37',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(482,'38',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(483,'38',NULL,'GL','account','410-0000','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(484,'38',NULL,'GL','customCode','0022','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(485,'38',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(486,'38',NULL,'GL','amount','44792.25','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(487,'38',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(488,'38',NULL,'GL','accountName','PHILHEALTH PREMIUM PAYABLE-EMPLOYER','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(489,'38',NULL,'GL','counter','17','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(490,'38',NULL,'GL','index','3','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(491,'38',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(492,'38',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(493,'38',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(494,'38',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(495,'39',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(496,'39',NULL,'GL','account','414-0000','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(497,'39',NULL,'GL','customCode','0026','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(498,'39',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(499,'39',NULL,'GL','amount','46774.69','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(500,'39',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(501,'39',NULL,'GL','accountName','SSS LOAN PAYABLE','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(502,'39',NULL,'GL','counter','18','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(503,'39',NULL,'GL','index','4','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(504,'39',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(505,'39',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(506,'39',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(507,'39',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(508,'40',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(509,'40',NULL,'GL','account','401-0000','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(510,'40',NULL,'GL','customCode','0014','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(511,'40',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(512,'40',NULL,'GL','amount','5642688.57','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(513,'40',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(514,'40',NULL,'GL','accountName','ACCOUNTS PAYABLE','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(515,'40',NULL,'GL','counter','19','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(516,'40',NULL,'GL','index','5','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(517,'40',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(518,'40',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(519,'40',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(520,'40',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(521,'41',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(522,'41',NULL,'GL','account','419-0000','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(523,'41',NULL,'GL','customCode','0029A','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(524,'41',NULL,'GL','branch','LEV','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(525,'41',NULL,'GL','amount','707849.20','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(526,'41',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(527,'41',NULL,'GL','accountName','VAT PAYABLE','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(528,'41',NULL,'GL','counter','20','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(529,'41',NULL,'GL','index','6','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(530,'41',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(531,'41',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(532,'41',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(533,'41',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:21:08','2024-05-28 12:21:08'),
(534,'42',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(535,'42',NULL,'GL','account','101-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(536,'42',NULL,'GL','customCode','0001','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(537,'42',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(538,'42',NULL,'GL','amount','647757','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(539,'42',NULL,'GL','normalBalance','Dr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(540,'42',NULL,'GL','accountName','CASH ON HAND','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(541,'42',NULL,'GL','counter','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(542,'42',NULL,'GL','index','0','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(543,'42',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(544,'42',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(545,'42',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(546,'42',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(547,'43',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(548,'43',NULL,'GL','account','104-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(549,'43',NULL,'GL','customCode','0004','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(550,'43',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(551,'43',NULL,'GL','amount','11119500','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(552,'43',NULL,'GL','normalBalance','Dr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(553,'43',NULL,'GL','accountName','PLEDGED LOAN INVENTORY','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(554,'43',NULL,'GL','counter','2','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(555,'43',NULL,'GL','index','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(556,'43',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(557,'43',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(558,'43',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(559,'43',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(560,'44',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(561,'44',NULL,'GL','account','106-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(562,'44',NULL,'GL','customCode','0005','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(563,'44',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(564,'44',NULL,'GL','amount','262000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(565,'44',NULL,'GL','normalBalance','Dr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(566,'44',NULL,'GL','accountName','RECOVERABLE DEPOSITES','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(567,'44',NULL,'GL','counter','3','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(568,'44',NULL,'GL','index','2','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(569,'44',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(570,'44',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(571,'44',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(572,'44',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(573,'45',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(574,'45',NULL,'GL','account','107-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(575,'45',NULL,'GL','customCode','0005A','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(576,'45',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(577,'45',NULL,'GL','amount','642825','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(578,'45',NULL,'GL','normalBalance','Dr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(579,'45',NULL,'GL','accountName','PREPAID TAX','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(580,'45',NULL,'GL','counter','4','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(581,'45',NULL,'GL','index','3','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(582,'45',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(583,'45',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(584,'45',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(585,'45',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(586,'46',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(587,'46',NULL,'GL','account','201-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(588,'46',NULL,'GL','customCode','0006','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(589,'46',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(590,'46',NULL,'GL','amount','2260000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(591,'46',NULL,'GL','normalBalance','Dr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(592,'46',NULL,'GL','accountName','LEASEHOLD IMPROVEMENT','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(593,'46',NULL,'GL','counter','5','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(594,'46',NULL,'GL','index','4','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(595,'46',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(596,'46',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(597,'46',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(598,'46',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(599,'47',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(600,'47',NULL,'GL','account','203-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(601,'47',NULL,'GL','customCode','0008','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(602,'47',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(603,'47',NULL,'GL','amount','900000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(604,'47',NULL,'GL','normalBalance','Dr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(605,'47',NULL,'GL','accountName','OFFICE EQUIPMENT','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(606,'47',NULL,'GL','counter','6','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(607,'47',NULL,'GL','index','6','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(608,'47',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(609,'47',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(610,'47',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(611,'47',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(612,'48',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(613,'48',NULL,'GL','account','205-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(614,'48',NULL,'GL','customCode','0010','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(615,'48',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(616,'48',NULL,'GL','amount','36000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(617,'48',NULL,'GL','normalBalance','Dr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(618,'48',NULL,'GL','accountName','FURNITURE AND FIXTURES','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(619,'48',NULL,'GL','counter','7','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(620,'48',NULL,'GL','index','8','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(621,'48',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(622,'48',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(623,'48',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(624,'48',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(625,'49',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(626,'49',NULL,'GL','account','702-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(627,'49',NULL,'GL','customCode','0037','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(628,'49',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(629,'49',NULL,'GL','amount','42671086','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(630,'49',NULL,'GL','normalBalance','Dr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(631,'49',NULL,'GL','accountName','RETAINED EARNINGS','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(632,'49',NULL,'GL','counter','8','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(633,'49',NULL,'GL','index','29','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(634,'49',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(635,'49',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(636,'49',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(637,'49',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(638,'50',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(639,'50',NULL,'GL','account','202-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(640,'50',NULL,'GL','customCode','0007','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(641,'50',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(642,'50',NULL,'GL','amount','2260000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(643,'50',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(644,'50',NULL,'GL','accountName','ACCUM.DEP.-LEASEHOLD IMPROVEMENT','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(645,'50',NULL,'GL','counter','9','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(646,'50',NULL,'GL','index','5','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(647,'50',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(648,'50',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(649,'50',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(650,'50',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(651,'51',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(652,'51',NULL,'GL','account','204-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(653,'51',NULL,'GL','customCode','0009','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(654,'51',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(655,'51',NULL,'GL','amount','900000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(656,'51',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(657,'51',NULL,'GL','accountName','ACCUM.DEP.-OFFICE EQUIPMENT','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(658,'51',NULL,'GL','counter','10','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(659,'51',NULL,'GL','index','7','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(660,'51',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(661,'51',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(662,'51',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(663,'51',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(664,'52',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(665,'52',NULL,'GL','account','206-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(666,'52',NULL,'GL','customCode','0011','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(667,'52',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(668,'52',NULL,'GL','amount','36000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(669,'52',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(670,'52',NULL,'GL','accountName','ACCUM.DEP.-FURNITURE & FICTURES','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(671,'52',NULL,'GL','counter','11','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(672,'52',NULL,'GL','index','9','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(673,'52',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(674,'52',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(675,'52',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(676,'52',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(677,'53',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(678,'53',NULL,'GL','account','401-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(679,'53',NULL,'GL','customCode','0014','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(680,'53',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(681,'53',NULL,'GL','amount','15581061','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(682,'53',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(683,'53',NULL,'GL','accountName','ACCOUNTS PAYABLE','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(684,'53',NULL,'GL','counter','12','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(685,'53',NULL,'GL','index','10','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(686,'53',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(687,'53',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(688,'53',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(689,'53',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(690,'54',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(691,'54',NULL,'GL','account','402-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(692,'54',NULL,'GL','customCode','0014A','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(693,'54',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(694,'54',NULL,'GL','amount','14351100','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(695,'54',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(696,'54',NULL,'GL','accountName','ADVANCES FROM STAKEHOLDERS','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(697,'54',NULL,'GL','counter','13','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(698,'54',NULL,'GL','index','11','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(699,'54',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(700,'54',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(701,'54',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(702,'54',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(703,'55',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(704,'55',NULL,'GL','account','403-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(705,'55',NULL,'GL','customCode','0015','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(706,'55',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(707,'55',NULL,'GL','amount','13008','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(708,'55',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(709,'55',NULL,'GL','accountName','DOCUMENTARY STAMP TAX PAYABLE','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(710,'55',NULL,'GL','counter','14','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(711,'55',NULL,'GL','index','12','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(712,'55',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(713,'55',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(714,'55',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(715,'55',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(716,'56',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(717,'56',NULL,'GL','account','405-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(718,'56',NULL,'GL','customCode','0017','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(719,'56',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(720,'56',NULL,'GL','amount','8351','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(721,'56',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(722,'56',NULL,'GL','accountName','WITHHOLDING TAX PAYABLE - RENT','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(723,'56',NULL,'GL','counter','15','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(724,'56',NULL,'GL','index','13','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(725,'56',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(726,'56',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(727,'56',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(728,'56',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(729,'57',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(730,'57',NULL,'GL','account','406-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(731,'57',NULL,'GL','customCode','0018','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(732,'57',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(733,'57',NULL,'GL','amount','400','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(734,'57',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(735,'57',NULL,'GL','accountName','WITHHOLDING TAX PAYABLE - PROFESSIONALS','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(736,'57',NULL,'GL','counter','16','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(737,'57',NULL,'GL','index','14','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(738,'57',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(739,'57',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(740,'57',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(741,'57',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(742,'58',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(743,'58',NULL,'GL','account','407-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(744,'58',NULL,'GL','customCode','0019','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(745,'58',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(746,'58',NULL,'GL','amount','19778','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(747,'58',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(748,'58',NULL,'GL','accountName','SSS PREMIUM PAYABLE - EMPLOYEE','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(749,'58',NULL,'GL','counter','17','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(750,'58',NULL,'GL','index','15','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(751,'58',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(752,'58',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(753,'58',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(754,'58',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(755,'59',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(756,'59',NULL,'GL','account','408-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(757,'59',NULL,'GL','customCode','0020','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(758,'59',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(759,'59',NULL,'GL','amount','42353','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(760,'59',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(761,'59',NULL,'GL','accountName','SSS/ECC PREMIUM PAYABLE-EMPLOYER','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(762,'59',NULL,'GL','counter','18','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(763,'59',NULL,'GL','index','16','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(764,'59',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(765,'59',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(766,'59',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(767,'59',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(768,'60',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(769,'60',NULL,'GL','account','409-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(770,'60',NULL,'GL','customCode','0021','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(771,'60',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(772,'60',NULL,'GL','amount','8774','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(773,'60',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(774,'60',NULL,'GL','accountName','PHILHEALTH PREMIUM PAYABLE-EMPLOYEE','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(775,'60',NULL,'GL','counter','19','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(776,'60',NULL,'GL','index','17','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(777,'60',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(778,'60',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(779,'60',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(780,'60',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(781,'61',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(782,'61',NULL,'GL','account','410-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(783,'61',NULL,'GL','customCode','0022','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(784,'61',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(785,'61',NULL,'GL','amount','8773','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(786,'61',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(787,'61',NULL,'GL','accountName','PHILHEALTH PREMIUM PAYABLE-EMPLOYER','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(788,'61',NULL,'GL','counter','20','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(789,'61',NULL,'GL','index','18','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(790,'61',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(791,'61',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(792,'61',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(793,'61',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(794,'62',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(795,'62',NULL,'GL','account','411-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(796,'62',NULL,'GL','customCode','0023','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(797,'62',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(798,'62',NULL,'GL','amount','3200','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(799,'62',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(800,'62',NULL,'GL','accountName','PAG-IBIG PREMIUM PAYABLE-EMPLOYEE','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(801,'62',NULL,'GL','counter','21','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(802,'62',NULL,'GL','index','19','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(803,'62',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(804,'62',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(805,'62',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(806,'62',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(807,'63',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(808,'63',NULL,'GL','account','412-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(809,'63',NULL,'GL','customCode','0024','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(810,'63',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(811,'63',NULL,'GL','amount','3200','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(812,'63',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(813,'63',NULL,'GL','accountName','PAG-IBIG PREMIUM PAYABLE-EMPLOYER','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(814,'63',NULL,'GL','counter','22','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(815,'63',NULL,'GL','index','20','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(816,'63',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(817,'63',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(818,'63',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(819,'63',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(820,'64',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(821,'64',NULL,'GL','account','413-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(822,'64',NULL,'GL','customCode','0025','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(823,'64',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(824,'64',NULL,'GL','amount','4666','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(825,'64',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(826,'64',NULL,'GL','accountName','PAG-IBIG LOAN PAYABLE','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(827,'64',NULL,'GL','counter','23','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(828,'64',NULL,'GL','index','21','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(829,'64',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(830,'64',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(831,'64',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(832,'64',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(833,'65',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(834,'65',NULL,'GL','account','414-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(835,'65',NULL,'GL','customCode','0026','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(836,'65',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(837,'65',NULL,'GL','amount','1061','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(838,'65',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(839,'65',NULL,'GL','accountName','SSS LOAN PAYABLE','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(840,'65',NULL,'GL','counter','24','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(841,'65',NULL,'GL','index','22','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(842,'65',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(843,'65',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(844,'65',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(845,'65',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(846,'66',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(847,'66',NULL,'GL','account','415-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(848,'66',NULL,'GL','customCode','0027','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(849,'66',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(850,'66',NULL,'GL','amount','87596','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(851,'66',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(852,'66',NULL,'GL','accountName','DEFFERED INCOME','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(853,'66',NULL,'GL','counter','25','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(854,'66',NULL,'GL','index','23','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(855,'66',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(856,'66',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(857,'66',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(858,'66',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(859,'67',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(860,'67',NULL,'GL','account','416-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(861,'67',NULL,'GL','customCode','0028','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(862,'67',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(863,'67',NULL,'GL','amount','29847','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(864,'67',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(865,'67',NULL,'GL','accountName','ACCRUED EXPENSE','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(866,'67',NULL,'GL','counter','26','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(867,'67',NULL,'GL','index','24','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(868,'67',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(869,'67',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(870,'67',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(871,'67',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(872,'68',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(873,'68',NULL,'GL','account','501-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(874,'68',NULL,'GL','customCode','0030','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(875,'68',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(876,'68',NULL,'GL','amount','2180000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(877,'68',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(878,'68',NULL,'GL','accountName','LOANS PAYABLE','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(879,'68',NULL,'GL','counter','27','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(880,'68',NULL,'GL','index','25','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(881,'68',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(882,'68',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(883,'68',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(884,'68',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(885,'69',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(886,'69',NULL,'GL','account','602-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(887,'69',NULL,'GL','customCode','0032','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(888,'69',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(889,'69',NULL,'GL','amount','1000000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(890,'69',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(891,'69',NULL,'GL','accountName','SHARE CAPITAL STOCK','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(892,'69',NULL,'GL','counter','28','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(893,'69',NULL,'GL','index','26','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(894,'69',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(895,'69',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(896,'69',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(897,'69',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(898,'70',NULL,'GL','sequence','1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(899,'70',NULL,'GL','account','605-0000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(900,'70',NULL,'GL','customCode','0035','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(901,'70',NULL,'GL','branch','BF1','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(902,'70',NULL,'GL','amount','22000000','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(903,'70',NULL,'GL','normalBalance','Cr','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(904,'70',NULL,'GL','accountName','STOCKHOLDERS DEPOSIT PENDING SEC','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(905,'70',NULL,'GL','counter','29','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(906,'70',NULL,'GL','index','27','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(907,'70',NULL,'GL','type','journal','draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(908,'70',NULL,'GL','entity',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(909,'70',NULL,'GL','service',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24'),
(910,'70',NULL,'GL','description',NULL,'draft',NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24');

--
-- 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=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `tbl_journal` VALUES
(1,'JE2024000001','journal','2024-05-28','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-05-28','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');

--
-- 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,
  `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=71 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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','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','posted',NULL,NULL,'2024-05-28 12:48:24','2024-05-28 12:48:24');

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


