-('1', '25', '1', '2016-05-05', '1510', '101', '20000', '0', '0', NULL, NULL),
-('2', '25', '1', '2016-05-05', '1510', '102', '15000', '0', '0', NULL, NULL),
-('3', '25', '1', '2016-05-05', '1510', '103', '1000', '0', '0', NULL, NULL),
-('4', '25', '1', '2016-05-05', '1550', '', '-36000', '0', '0', NULL, NULL),
-('5', '13', '1', '2016-05-10', '5010', '', '4000', '0', '0', NULL, NULL),
-('6', '13', '1', '2016-05-10', '1510', '', '-4000', '0', '0', NULL, NULL),
-('7', '10', '1', '2016-05-10', '4010', '', '-5714.29', '0', '0', NULL, NULL),
-('8', '10', '1', '2016-05-10', '4010', '', '-228.57', '0', '0', NULL, NULL),
-('9', '10', '1', '2016-05-10', '1200', '', '6240', '0', '0', '2', '1'),
-('10', '10', '1', '2016-05-10', '2150', '', '-297.14', '0', '0', NULL, NULL),
-('11', '12', '1', '2016-05-10', '1065', '', '6240', '0', '0', NULL, NULL),
-('12', '12', '1', '2016-05-10', '1200', '', '-6240', '0', '0', '2', '1'),
-('13', '26', '1', '2016-05-05', '1510', '1 * iPad Air 2 16GB', '-400', '0', '0', NULL, NULL),
-('14', '26', '1', '2016-05-05', '1510', '1 * iPhone 6 64GB', '-300', '0', '0', NULL, NULL),
-('15', '26', '1', '2016-05-05', '1510', '1 * iPhone Cover Case', '-20', '0', '0', NULL, NULL),
-('16', '26', '1', '2016-05-05', '1510', 'Produced 2 * AP Surf Set', '720', '0', '0', NULL, NULL),
-('17', '25', '2', '2016-05-05', '1510', '101', '3000', '0', '0', NULL, NULL),
-('18', '25', '2', '2016-05-05', '1550', '', '-3000', '0', '0', NULL, NULL),
-('19', '20', '1', '2016-05-05', '2150', '', '150', '0', '0', NULL, NULL),
-('20', '20', '1', '2016-05-05', '2100', '', '-3150', '0', '0', '3', '1'),
-('21', '20', '1', '2016-05-05', '1550', '', '3000', '0', '0', NULL, NULL),
-('22', '13', '2', '2016-05-07', '5010', '', '200', '0', '0', NULL, NULL),
-('23', '13', '2', '2016-05-07', '1510', '', '-200', '0', '0', NULL, NULL),
-('24', '10', '2', '2016-05-07', '4010', '', '-285.71', '0', '0', NULL, NULL),
-('25', '10', '2', '2016-05-07', '1200', '', '300', '0', '0', '2', '1'),
-('26', '10', '2', '2016-05-07', '2150', '', '-14.29', '0', '0', NULL, NULL),
-('27', '12', '2', '2016-05-07', '1065', '', '300', '0', '0', NULL, NULL),
-('28', '12', '2', '2016-05-07', '1200', '', '-300', '0', '0', '2', '1'),
-('29', '13', '3', '2016-05-07', '5010', '', '150', '1', '0', NULL, NULL),
-('30', '13', '3', '2016-05-07', '1510', '', '-150', '0', '0', NULL, NULL),
-('31', '13', '3', '2016-05-07', '5010', '', '10', '1', '0', NULL, NULL),
-('32', '13', '3', '2016-05-07', '1510', '', '-10', '0', '0', NULL, NULL),
-('33', '10', '3', '2016-05-07', '4010', '', '-250', '1', '0', NULL, NULL),
-('34', '10', '3', '2016-05-07', '4010', '', '-50', '1', '0', NULL, NULL),
-('35', '10', '3', '2016-05-07', '1200', '', '300', '0', '0', '2', '2'),
-('36', '12', '3', '2016-05-07', '1065', '', '0', '0', '0', NULL, NULL),
-('37', '1', '1', '2016-05-07', '5010', '', '5', '1', '0', NULL, NULL),
-('38', '1', '1', '2016-05-07', '1060', '', '-5', '0', '0', NULL, NULL);
-
--- --------------------------------------------------------
-
---
--- Table structure for table `0_grn_batch`
---
+('1', '25', '1', '2018-05-05', '1510', '101', '20000', '0', '0', NULL, NULL),
+('2', '25', '1', '2018-05-05', '1510', '102', '15000', '0', '0', NULL, NULL),
+('3', '25', '1', '2018-05-05', '1510', '103', '1000', '0', '0', NULL, NULL),
+('4', '25', '1', '2018-05-05', '1550', '', '-36000', '0', '0', NULL, NULL),
+('5', '13', '1', '2018-05-10', '5010', '', '4000', '0', '0', NULL, NULL),
+('6', '13', '1', '2018-05-10', '1510', '', '-4000', '0', '0', NULL, NULL),
+('7', '10', '1', '2018-05-10', '4010', '', '-5714.29', '0', '0', NULL, NULL),
+('8', '10', '1', '2018-05-10', '4010', '', '-228.57', '0', '0', NULL, NULL),
+('9', '10', '1', '2018-05-10', '1200', '', '6240', '0', '0', '2', '1'),
+('10', '10', '1', '2018-05-10', '2150', '', '-297.14', '0', '0', NULL, NULL),
+('11', '12', '1', '2018-05-10', '1065', '', '6240', '0', '0', NULL, NULL),
+('12', '12', '1', '2018-05-10', '1200', '', '-6240', '0', '0', '2', '1'),
+('13', '29', '1', '2018-05-05', '1510', '1 * iPad Air 2 16GB', '-400', '0', '0', NULL, NULL),
+('14', '29', '1', '2018-05-05', '1510', '1 * iPhone 6 64GB', '-300', '0', '0', NULL, NULL),
+('15', '29', '1', '2018-05-05', '1510', '1 * iPhone Cover Case', '-20', '0', '0', NULL, NULL),
+('16', '29', '1', '2018-05-05', '1530', '1 * Support', '720', '0', '0', NULL, NULL),
+('17', '26', '1', '2018-05-05', '1530', '', '-720', '0', '0', NULL, NULL),
+('18', '26', '1', '2018-05-05', '1510', '', '720', '0', '0', NULL, NULL),
+('19', '25', '2', '2018-05-05', '1510', '101', '3000', '0', '0', NULL, NULL),
+('20', '25', '2', '2018-05-05', '1550', '', '-3000', '0', '0', NULL, NULL),
+('21', '20', '1', '2018-05-05', '2150', '', '150', '0', '0', NULL, NULL),
+('22', '20', '1', '2018-05-05', '2100', '', '-3150', '0', '0', '3', '1'),
+('23', '20', '1', '2018-05-05', '1550', '', '3000', '0', '0', NULL, NULL),
+('24', '13', '2', '2018-05-07', '5010', '', '200', '0', '0', NULL, NULL),
+('25', '13', '2', '2018-05-07', '1510', '', '-200', '0', '0', NULL, NULL),
+('26', '10', '2', '2018-05-07', '4010', '', '-285.71', '0', '0', NULL, NULL),
+('27', '10', '2', '2018-05-07', '1200', '', '300', '0', '0', '2', '1'),
+('28', '10', '2', '2018-05-07', '2150', '', '-14.29', '0', '0', NULL, NULL),
+('29', '12', '2', '2018-05-07', '1065', '', '300', '0', '0', NULL, NULL),
+('30', '12', '2', '2018-05-07', '1200', '', '-300', '0', '0', '2', '1'),
+('31', '13', '3', '2018-05-07', '5010', '', '150', '1', '0', NULL, NULL),
+('32', '13', '3', '2018-05-07', '1510', '', '-150', '0', '0', NULL, NULL),
+('33', '13', '3', '2018-05-07', '5010', '', '10', '1', '0', NULL, NULL),
+('34', '13', '3', '2018-05-07', '1510', '', '-10', '0', '0', NULL, NULL),
+('35', '10', '3', '2018-05-07', '4010', '', '-250', '1', '0', NULL, NULL),
+('36', '10', '3', '2018-05-07', '4010', '', '-50', '1', '0', NULL, NULL),
+('37', '10', '3', '2018-05-07', '1200', '', '300', '0', '0', '2', '2'),
+('38', '12', '3', '2018-05-07', '1065', '', '0', '0', '0', NULL, NULL),
+('39', '1', '1', '2018-05-07', '5010', '', '5', '1', '0', NULL, NULL),
+('40', '1', '1', '2018-05-07', '1060', '', '-5', '0', '0', NULL, NULL),
+('41', '13', '5', '2019-01-21', '5010', '', '750', '0', '0', NULL, NULL),
+('42', '13', '5', '2019-01-21', '1510', '', '-750', '0', '0', NULL, NULL),
+('43', '10', '5', '2019-01-21', '4010', '', '-1190.48', '0', '0', NULL, NULL),
+('44', '10', '5', '2019-01-21', '1200', '', '1250', '0', '0', '2', '1'),
+('45', '10', '5', '2019-01-21', '2150', '', '-59.52', '0', '0', NULL, NULL),
+('46', '12', '4', '2019-01-21', '1065', '', '1250', '0', '0', NULL, NULL),
+('47', '12', '4', '2019-01-21', '1200', '', '-1250', '0', '0', '2', '1'),
+('48', '25', '3', '2019-01-21', '1510', '102', '900', '0', '0', NULL, NULL),
+('49', '25', '3', '2019-01-21', '1550', '', '-900', '0', '0', NULL, NULL),
+('50', '20', '2', '2019-01-21', '2150', '', '45', '0', '0', NULL, NULL),
+('51', '20', '2', '2019-01-21', '2100', '', '-945', '0', '0', '3', '1'),
+('52', '20', '2', '2019-01-21', '1550', '', '900', '0', '0', NULL, NULL),
+('53', '0', '1', '2018-12-31', '3590', 'Closing Year', '-2163.57', '0', '0', NULL, NULL),
+('54', '0', '1', '2018-12-31', '9990', 'Closing Year', '2163.57', '0', '0', NULL, NULL);
+
+-- Structure of table `0_grn_batch` --