-) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=84 ;
-
---
--- Dumping data for table `0_gl_trans`
---
-
-INSERT INTO `0_gl_trans` VALUES(1, 20, 7, '2014-06-21', '2100', '', -3465, 0, 0, 3, '2');
-INSERT INTO `0_gl_trans` VALUES(2, 20, 7, '2014-06-21', '1510', '', 1000, 0, 0, 3, '2');
-INSERT INTO `0_gl_trans` VALUES(3, 20, 7, '2014-06-21', '1510', '', 1100, 0, 0, 3, '2');
-INSERT INTO `0_gl_trans` VALUES(4, 20, 7, '2014-06-21', '1510', '', 1200, 0, 0, 3, '2');
-INSERT INTO `0_gl_trans` VALUES(5, 20, 7, '2014-06-21', '2150', '', 165, 0, 0, 3, '2');
-INSERT INTO `0_gl_trans` VALUES(6, 22, 4, '2014-06-21', '2100', '', 3465, 0, 0, 3, '2');
-INSERT INTO `0_gl_trans` VALUES(7, 22, 4, '2014-06-21', '1060', '', -3465, 0, 0, 3, '2');
-INSERT INTO `0_gl_trans` VALUES(8, 26, 1, '2014-06-21', '1510', '', -100, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(9, 26, 1, '2014-06-21', '1510', '', -110, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(10, 26, 1, '2014-06-21', '1510', '', -120, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(11, 26, 1, '2014-06-21', '1060', 'Overhead Cost', -10, 0, 0, 1, '1');
-INSERT INTO `0_gl_trans` VALUES(12, 26, 1, '2014-06-21', '1530', 'Overhead Cost', 10, 0, 0, 1, '1');
-INSERT INTO `0_gl_trans` VALUES(13, 26, 1, '2014-06-21', '1060', 'Labour Cost', -20, 0, 0, 1, '0');
-INSERT INTO `0_gl_trans` VALUES(14, 26, 1, '2014-06-21', '1530', 'Labour Cost', 20, 0, 0, 1, '0');
-INSERT INTO `0_gl_trans` VALUES(15, 26, 1, '2014-06-21', '1510', '', 330, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(16, 13, 2, '2014-06-21', '5010', '', 20, 0, 0, 2, '1');
-INSERT INTO `0_gl_trans` VALUES(17, 13, 2, '2014-06-21', '1510', '', -20, 0, 0, 2, '1');
-INSERT INTO `0_gl_trans` VALUES(18, 13, 3, '2014-06-21', '5010', '', 10, 0, 0, 2, '2');
-INSERT INTO `0_gl_trans` VALUES(19, 13, 3, '2014-06-21', '1510', '', -10, 0, 0, 2, '2');
-INSERT INTO `0_gl_trans` VALUES(20, 10, 17, '2014-06-21', '4010', '', -50, 0, 0, 2, '2');
-INSERT INTO `0_gl_trans` VALUES(21, 10, 17, '2014-06-21', '1200', '', 52.5, 0, 0, 2, '2');
-INSERT INTO `0_gl_trans` VALUES(22, 10, 17, '2014-06-21', '2150', '', -2.5, 0, 0, 2, '2');
-INSERT INTO `0_gl_trans` VALUES(23, 13, 4, '2014-06-21', '5010', '', 10, 2, 0, 2, '3');
-INSERT INTO `0_gl_trans` VALUES(24, 13, 4, '2014-06-21', '1510', '', -10, 0, 0, 2, '3');
-INSERT INTO `0_gl_trans` VALUES(25, 10, 18, '2014-06-21', '4010', '', -50, 2, 0, 2, '3');
-INSERT INTO `0_gl_trans` VALUES(26, 10, 18, '2014-06-21', '1200', '', 52.5, 0, 0, 2, '3');
-INSERT INTO `0_gl_trans` VALUES(27, 10, 18, '2014-06-21', '2150', '', -2.5, 0, 0, 2, '3');
-INSERT INTO `0_gl_trans` VALUES(28, 0, 18, '2014-02-20', '1060', '', 1000, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(29, 0, 18, '2014-02-20', '3350', '', -1000, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(30, 0, 19, '2014-02-21', '1060', '', 4000, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(31, 0, 19, '2014-02-21', '3350', '', -4000, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(32, 26, 3, '2014-06-21', '1510', '', -20, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(33, 26, 3, '2014-06-21', '1510', '', -22, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(34, 26, 3, '2014-06-21', '1510', '', -24, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(35, 26, 3, '2014-06-21', '1540', '', 66, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(36, 2, 5, '2014-06-21', '2150', 'Cash Sales', -4.76, 0, 0, 4, '3');
-INSERT INTO `0_gl_trans` VALUES(37, 2, 5, '2014-06-21', '4010', 'Cash Sales', -95.24, 0, 0, 4, '3');
-INSERT INTO `0_gl_trans` VALUES(38, 2, 5, '2014-06-21', '1060', '', 100, 0, 0, 4, '3');
-INSERT INTO `0_gl_trans` VALUES(39, 1, 8, '2014-06-21', '2150', 'Maintenance', 2.38, 0, 0, 4, '1');
-INSERT INTO `0_gl_trans` VALUES(40, 1, 8, '2014-06-21', '5765', 'Maintenance', 47.62, 0, 0, 4, '1');
-INSERT INTO `0_gl_trans` VALUES(41, 1, 8, '2014-06-21', '1060', '', -50, 0, 0, 4, '1');
-INSERT INTO `0_gl_trans` VALUES(42, 20, 8, '2014-06-21', '2100', '', -20, 0, 0, 3, '2');
-INSERT INTO `0_gl_trans` VALUES(43, 20, 8, '2014-06-21', '2150', '', 0.95, 0, 0, 3, '2');
-INSERT INTO `0_gl_trans` VALUES(44, 20, 8, '2014-06-21', '5780', '', 19.05, 0, 0, 3, '2');
-INSERT INTO `0_gl_trans` VALUES(45, 26, 4, '2014-06-21', '1510', '', -40, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(46, 26, 4, '2014-06-21', '1510', '', -44, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(47, 26, 4, '2014-06-21', '1510', '', -48, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(48, 26, 4, '2014-06-21', '1540', '', 132, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(49, 26, 2, '2014-06-21', '1510', '', -20, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(50, 26, 2, '2014-06-21', '1510', '', -22, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(51, 26, 2, '2014-06-21', '1510', '', -24, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(52, 26, 2, '2014-06-21', '1540', '', 66, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(53, 26, 5, '2014-06-21', '1510', '', -50, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(54, 26, 5, '2014-06-21', '1510', '', -55, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(55, 26, 5, '2014-06-21', '1510', '', -60, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(56, 26, 5, '2014-06-21', '1060', 'Overhead Cost', -10, 0, 0, 1, '1');
-INSERT INTO `0_gl_trans` VALUES(57, 26, 5, '2014-06-21', '1530', 'Overhead Cost', 10, 0, 0, 1, '1');
-INSERT INTO `0_gl_trans` VALUES(58, 26, 5, '2014-06-21', '1060', 'Labour Cost', -20, 0, 0, 1, '0');
-INSERT INTO `0_gl_trans` VALUES(59, 26, 5, '2014-06-21', '1530', 'Labour Cost', 20, 0, 0, 1, '0');
-INSERT INTO `0_gl_trans` VALUES(60, 26, 5, '2014-06-21', '1540', '', 165, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(61, 26, 6, '2014-06-21', '1510', '', 50, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(62, 26, 6, '2014-06-21', '1510', '', 55, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(63, 26, 6, '2014-06-21', '1510', '', 60, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(64, 26, 6, '2014-06-21', '1540', '', -165, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(65, 26, 7, '2014-06-21', '1510', '', 20, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(66, 26, 7, '2014-06-21', '1510', '', 22, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(67, 26, 7, '2014-06-21', '1510', '', 24, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(68, 26, 7, '2014-06-21', '1060', 'Overhead Cost', -10, 0, 0, 1, '1');
-INSERT INTO `0_gl_trans` VALUES(69, 26, 7, '2014-06-21', '1530', 'Overhead Cost', 10, 0, 0, 1, '1');
-INSERT INTO `0_gl_trans` VALUES(70, 26, 7, '2014-06-21', '1060', 'Labour Cost', -20, 0, 0, 1, '0');
-INSERT INTO `0_gl_trans` VALUES(71, 26, 7, '2014-06-21', '1530', 'Labour Cost', 20, 0, 0, 1, '0');
-INSERT INTO `0_gl_trans` VALUES(72, 26, 7, '2014-06-21', '1540', '', -66, 0, 0, NULL, '');
-INSERT INTO `0_gl_trans` VALUES(73, 13, 5, '2014-06-21', '5010', '', 10, 0, 0, 2, '2');
-INSERT INTO `0_gl_trans` VALUES(74, 13, 5, '2014-06-21', '1510', '', -10, 0, 0, 2, '2');
-INSERT INTO `0_gl_trans` VALUES(75, 10, 19, '2014-06-21', '4010', '', -47.62, 0, 0, 2, '2');
-INSERT INTO `0_gl_trans` VALUES(76, 10, 19, '2014-06-21', '1200', '', 55, 0, 0, 2, '2');
-INSERT INTO `0_gl_trans` VALUES(77, 10, 19, '2014-06-21', '4430', '', -5, 0, 0, 2, '2');
-INSERT INTO `0_gl_trans` VALUES(78, 10, 19, '2014-06-21', '2150', '', -2.38, 0, 0, 2, '2');
-INSERT INTO `0_gl_trans` VALUES(79, 11, 3, '2014-06-21', '5010', '', -10, 2, 0, 2, '3');
-INSERT INTO `0_gl_trans` VALUES(80, 11, 3, '2014-06-21', '1510', '', 10, 0, 0, 2, '3');
-INSERT INTO `0_gl_trans` VALUES(81, 11, 3, '2014-06-21', '4010', '', 50, 2, 0, 2, '3');
-INSERT INTO `0_gl_trans` VALUES(82, 11, 3, '2014-06-21', '1200', '', -52.5, 0, 0, 2, '3');
-INSERT INTO `0_gl_trans` VALUES(83, 11, 3, '2014-06-21', '2150', '', 2.5, 0, 0, 2, '3');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `0_grn_batch`
---
+) ENGINE=InnoDB AUTO_INCREMENT=55 ;
+
+-- Data of table `0_gl_trans` --
+
+INSERT INTO `0_gl_trans` VALUES
+('1', '25', '1', '2020-05-05', '1510', '101', '20000', '0', '0', NULL, NULL),
+('2', '25', '1', '2020-05-05', '1510', '102', '15000', '0', '0', NULL, NULL),
+('3', '25', '1', '2020-05-05', '1510', '103', '1000', '0', '0', NULL, NULL),
+('4', '25', '1', '2020-05-05', '1550', '', '-36000', '0', '0', NULL, NULL),
+('5', '13', '1', '2020-05-10', '5010', '', '4000', '0', '0', NULL, NULL),
+('6', '13', '1', '2020-05-10', '1510', '', '-4000', '0', '0', NULL, NULL),
+('7', '10', '1', '2020-05-10', '4010', '', '-5714.29', '0', '0', NULL, NULL),
+('8', '10', '1', '2020-05-10', '4010', '', '-228.57', '0', '0', NULL, NULL),
+('9', '10', '1', '2020-05-10', '1200', '', '6240', '0', '0', '2', '1'),
+('10', '10', '1', '2020-05-10', '2150', '', '-297.14', '0', '0', NULL, NULL),
+('11', '12', '1', '2020-05-10', '1065', '', '6240', '0', '0', NULL, NULL),
+('12', '12', '1', '2020-05-10', '1200', '', '-6240', '0', '0', '2', '1'),
+('13', '29', '1', '2020-05-05', '1510', '1 * iPad Air 2 16GB', '-400', '0', '0', NULL, NULL),
+('14', '29', '1', '2020-05-05', '1510', '1 * iPhone 6 64GB', '-300', '0', '0', NULL, NULL),
+('15', '29', '1', '2020-05-05', '1510', '1 * iPhone Cover Case', '-20', '0', '0', NULL, NULL),
+('16', '29', '1', '2020-05-05', '1530', '1 * Support', '720', '0', '0', NULL, NULL),
+('17', '26', '1', '2020-05-05', '1530', '', '-720', '0', '0', NULL, NULL),
+('18', '26', '1', '2020-05-05', '1510', '', '720', '0', '0', NULL, NULL),
+('19', '25', '2', '2020-05-05', '1510', '101', '3000', '0', '0', NULL, NULL),
+('20', '25', '2', '2020-05-05', '1550', '', '-3000', '0', '0', NULL, NULL),
+('21', '20', '1', '2020-05-05', '2150', '', '150', '0', '0', NULL, NULL),
+('22', '20', '1', '2020-05-05', '2100', '', '-3150', '0', '0', '3', '1'),
+('23', '20', '1', '2020-05-05', '1550', '', '3000', '0', '0', NULL, NULL),
+('24', '13', '2', '2020-05-07', '5010', '', '200', '0', '0', NULL, NULL),
+('25', '13', '2', '2020-05-07', '1510', '', '-200', '0', '0', NULL, NULL),
+('26', '10', '2', '2020-05-07', '4010', '', '-285.71', '0', '0', NULL, NULL),
+('27', '10', '2', '2020-05-07', '1200', '', '300', '0', '0', '2', '1'),
+('28', '10', '2', '2020-05-07', '2150', '', '-14.29', '0', '0', NULL, NULL),
+('29', '12', '2', '2020-05-07', '1065', '', '300', '0', '0', NULL, NULL),
+('30', '12', '2', '2020-05-07', '1200', '', '-300', '0', '0', '2', '1'),
+('31', '13', '3', '2020-05-07', '5010', '', '150', '1', '0', NULL, NULL),
+('32', '13', '3', '2020-05-07', '1510', '', '-150', '0', '0', NULL, NULL),
+('33', '13', '3', '2020-05-07', '5010', '', '10', '1', '0', NULL, NULL),
+('34', '13', '3', '2020-05-07', '1510', '', '-10', '0', '0', NULL, NULL),
+('35', '10', '3', '2020-05-07', '4010', '', '-250', '1', '0', NULL, NULL),
+('36', '10', '3', '2020-05-07', '4010', '', '-50', '1', '0', NULL, NULL),
+('37', '10', '3', '2020-05-07', '1200', '', '300', '0', '0', '2', '2'),
+('38', '12', '3', '2020-05-07', '1065', '', '0', '0', '0', NULL, NULL),
+('39', '1', '1', '2020-05-07', '5010', '', '5', '1', '0', NULL, NULL),
+('40', '1', '1', '2020-05-07', '1060', '', '-5', '0', '0', NULL, NULL),
+('41', '13', '5', '2021-01-21', '5010', '', '750', '0', '0', NULL, NULL),
+('42', '13', '5', '2021-01-21', '1510', '', '-750', '0', '0', NULL, NULL),
+('43', '10', '5', '2021-01-21', '4010', '', '-1190.48', '0', '0', NULL, NULL),
+('44', '10', '5', '2021-01-21', '1200', '', '1250', '0', '0', '2', '1'),
+('45', '10', '5', '2021-01-21', '2150', '', '-59.52', '0', '0', NULL, NULL),
+('46', '12', '4', '2021-01-21', '1065', '', '1250', '0', '0', NULL, NULL),
+('47', '12', '4', '2021-01-21', '1200', '', '-1250', '0', '0', '2', '1'),
+('48', '25', '3', '2021-01-21', '1510', '102', '900', '0', '0', NULL, NULL),
+('49', '25', '3', '2021-01-21', '1550', '', '-900', '0', '0', NULL, NULL),
+('50', '20', '2', '2021-01-21', '2150', '', '45', '0', '0', NULL, NULL),
+('51', '20', '2', '2021-01-21', '2100', '', '-945', '0', '0', '3', '1'),
+('52', '20', '2', '2021-01-21', '1550', '', '900', '0', '0', NULL, NULL),
+('53', '0', '1', '2020-12-31', '3590', 'Closing Year', '-2163.57', '0', '0', NULL, NULL),
+('54', '0', '1', '2020-12-31', '9990', 'Closing Year', '2163.57', '0', '0', NULL, NULL);
+
+-- Structure of table `0_grn_batch` --