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


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

CREATE TABLE `tbl_journal` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `entry_date` date NOT NULL,
  `transaction_date` date NOT NULL,
  `entity` varchar(255) NOT NULL,
  `reference_number` varchar(255) DEFAULT NULL,
  `amount` decimal(18,2) DEFAULT 0.00,
  `particulars` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `posted_by` varchar(255) DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tbl_journal_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=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'
--


