---
--- Data in table `cust_allocations`
---
-
-INSERT INTO `0_cust_allocations` VALUES (1, 200, '2007-01-30', 6, 12, 6, 10);
-INSERT INTO `0_cust_allocations` VALUES (4, 133, '2007-03-09', 4, 2, 6, 10);
-
---
--- Data in table `cust_branch`
---
-
-INSERT INTO `0_cust_branch` VALUES (1, 1, 'Main', '', 1, 1, '', '', 'Lucky Luke Inc.', 'joe@frontaccounting.com', 'DEF', 2, '3000', '3000', '1500', '3200', 1, 0, 'The Road');
-INSERT INTO `0_cust_branch` VALUES (2, 1, 'Branch 2', '', 1, 1, '', '', '', '', 'DEF', 3, '3000', '3000', '1500', '3200', 1, 0, 'Another Road');
-INSERT INTO `0_cust_branch` VALUES (3, 2, 'Main', '', 1, 1, '', '', 'Money Makers Ltd.', '', 'DEF', 3, '3000', '3000', '1500', '3200', 1, 0, '');
-INSERT INTO `0_cust_branch` VALUES (4, 2, 'Main', '', 1, 1, '', '', 'Money Makers Ltd.', '', 'DEF', 3, '3000', '3000', '1500', '3200', 1, 0, 'UK,UK');
-INSERT INTO `0_cust_branch` VALUES (5, 3, 'Main', '', 1, 1, '', '', 'Junk Beer ApS', '', 'DEF', 3, '3000', '3000', '1500', '3200', 1, 0, '');
-
---
--- Data in table `debtor_trans`
---
-
-INSERT INTO `0_debtor_trans` VALUES (2, 10, 1, 1, '2006-01-18', '2006-01-18', '1', 1, 1, 1750, 0, 0, 0, 0, 1, 1);
-INSERT INTO `0_debtor_trans` VALUES (2, 11, 2, 3, '2006-01-18', '0000-00-00', '33', 1, 0, -1050, 0, 0, 0, 0, 1.2, 1);
-INSERT INTO `0_debtor_trans` VALUES (2, 12, 1, 1, '2006-01-18', '0000-00-00', '111', 0, 0, -10000, 0, 0, 0, 0, 1, 0);
-INSERT INTO `0_debtor_trans` VALUES (3, 10, 1, 1, '2006-01-18', '2006-01-18', '2', 1, 1, 1000, 0, 0, 0, 0, 1, 1);
-INSERT INTO `0_debtor_trans` VALUES (3, 12, 2, 3, '2006-01-18', '0000-00-00', '112', 0, 0, -200, 0, 0, 0, 0, 1.2, 0);
-INSERT INTO `0_debtor_trans` VALUES (4, 2, 1, 1, '2007-03-09', '0000-00-00', '13', 0, 0, -200, 0, 0, 0, 133, 1, 0);
-INSERT INTO `0_debtor_trans` VALUES (4, 10, 2, 3, '2006-01-18', '2006-01-18', '3', 1, 2, 1057.14285714, 52.8571428571, 0, 0, 0, 1.2, 1);
-INSERT INTO `0_debtor_trans` VALUES (4, 12, 2, 3, '2006-01-18', '0000-00-00', '113', 0, 0, -300, 0, 0, 0, 0, 1.2, 0);
-INSERT INTO `0_debtor_trans` VALUES (5, 10, 1, 1, '2007-01-28', '2007-01-28', '4', 1, 1, 93050, 0, 0, 0, 0, 1, 1);
-INSERT INTO `0_debtor_trans` VALUES (5, 12, 1, 1, '2006-01-18', '0000-00-00', '114', 0, 0, -500, 0, 0, 0, 0, 1, 0);
-INSERT INTO `0_debtor_trans` VALUES (6, 10, 1, 1, '2007-01-30', '2007-01-30', '5', 1, 3, 333, 0, 0, 0, 333, 1, 1);
-INSERT INTO `0_debtor_trans` VALUES (6, 12, 1, 1, '2007-01-30', '0000-00-00', '115', 0, 0, -200, 0, 0, 0, 200, 1, 0);
-INSERT INTO `0_debtor_trans` VALUES (7, 10, 1, 1, '2007-02-03', '2007-02-03', '6', 1, 4, 333, 0, 0, 0, 0, 1, 1);
-INSERT INTO `0_debtor_trans` VALUES (8, 10, 1, 1, '2007-02-03', '2007-02-03', '7', 1, 5, 333, 0, 0, 0, 0, 1, 1);
-INSERT INTO `0_debtor_trans` VALUES (9, 10, 2, 3, '2007-02-03', '2007-02-03', '8', 1, 6, 2857.1428571429, 142.85714285714, 0, 0, 0, 1.2, 1);
-INSERT INTO `0_debtor_trans` VALUES (10, 10, 1, 1, '2007-02-04', '2007-02-04', '9', 1, 9, 333, 0, 0, 0, 0, 1, 1);
-INSERT INTO `0_debtor_trans` VALUES (11, 10, 1, 1, '2007-02-04', '2007-03-22', '10', 1, 10, 333, 0, 0, 0, 0, 1, 1);
-INSERT INTO `0_debtor_trans` VALUES (12, 10, 1, 1, '2007-02-06', '2007-03-22', '11', 1, 11, 333, 0, 0, 0, 0, 1, 1);
-INSERT INTO `0_debtor_trans` VALUES (13, 10, 1, 1, '2007-02-25', '2007-03-22', '12', 1, 12, 333, 0, 0, 0, 0, 1, 1);
-INSERT INTO `0_debtor_trans` VALUES (14, 10, 1, 1, '2007-03-04', '2007-03-22', '13', 1, 13, 333, 0, 0, 0, 0, 1, 1);
-INSERT INTO `0_debtor_trans` VALUES (15, 10, 1, 1, '2007-03-05', '2007-03-22', '14', 1, 14, 333, 0, 25, 0, 0, 1, 1);
-INSERT INTO `0_debtor_trans` VALUES (16, 10, 1, 1, '2007-03-05', '2007-03-22', '15', 1, 15, 3000, 0, 44, 0, 0, 1, 1);
-
---
--- Data in table `debtor_trans_details`
---
-
-INSERT INTO `0_debtor_trans_details` VALUES (1, 2, 10, '102', '17 inch VGA Monitor', 250, 0, -2, 0, 0);
-INSERT INTO `0_debtor_trans_details` VALUES (2, 2, 10, '103', '32MB VGA Card', 3000, 0, -10, 0, 0);
-INSERT INTO `0_debtor_trans_details` VALUES (3, 2, 10, '104', '52x CD Drive', 50, 0, -5, 0, 0);
-INSERT INTO `0_debtor_trans_details` VALUES (4, 3, 10, '103', '32MB VGA Card', 3000, 0, -10, 0, 0);
-INSERT INTO `0_debtor_trans_details` VALUES (5, 2, 11, '102', '17 inch VGA Monitor', 210, 0, 5, 0, 0);
-INSERT INTO `0_debtor_trans_details` VALUES (6, 4, 10, '102', '17 inch VGA Monitor', 211.428571429, 10.5714285714, -5, 0, 0);
-INSERT INTO `0_debtor_trans_details` VALUES (7, 5, 10, '102', '17 inch VGA Monitor', 250, 0, -8, 0, 0);
-INSERT INTO `0_debtor_trans_details` VALUES (8, 5, 10, '103', '32MB VGA Card', 3000, 0, -30, 0, 0);
-INSERT INTO `0_debtor_trans_details` VALUES (9, 5, 10, '104', '52x CD Drive', 50, 0, -21, 0, 0);
-INSERT INTO `0_debtor_trans_details` VALUES (10, 6, 10, '102', '17 inch VGA Monitor', 333, 0, -1, 0, 0);
-INSERT INTO `0_debtor_trans_details` VALUES (11, 7, 10, '102', '17 inch VGA Monitor', 333, 0, -1, 0, 0);
-INSERT INTO `0_debtor_trans_details` VALUES (12, 8, 10, '102', '17 inch VGA Monitor', 333, 0, -1, 0, 0);
-INSERT INTO `0_debtor_trans_details` VALUES (13, 9, 10, '3400', 'P4 Business System', 2857.1428571429, 142.85714285714, -1, 0, 0);
-INSERT INTO `0_debtor_trans_details` VALUES (14, 10, 10, '102', '17 inch VGA Monitor', 333, 0, -1, 0, 0);
-INSERT INTO `0_debtor_trans_details` VALUES (15, 11, 10, '102', '17 inch VGA Monitor', 333, 0, -1, 0, 0);
-INSERT INTO `0_debtor_trans_details` VALUES (16, 12, 10, '102', '17 inch VGA Monitor', 333, 0, -1, 0, 0);
-INSERT INTO `0_debtor_trans_details` VALUES (17, 13, 10, '102', '17 inch VGA Monitor', 333, 0, -1, 0, 0);
-INSERT INTO `0_debtor_trans_details` VALUES (18, 14, 10, '102', '17 inch VGA Monitor', 333, 0, -1, 0, 0);
-INSERT INTO `0_debtor_trans_details` VALUES (19, 15, 10, '102', '17 inch VGA Monitor', 333, 0, -1, 0, 0);
-INSERT INTO `0_debtor_trans_details` VALUES (20, 16, 10, '103', '32MB VGA Card', 3000, 0, -1, 0, 0);
-
---
--- Data in table `debtor_trans_tax_details`
---
-
-INSERT INTO `0_debtor_trans_tax_details` VALUES (1, 4, 10, 1, NULL, 5, 1, 52.8571428571);
-INSERT INTO `0_debtor_trans_tax_details` VALUES (2, 9, 10, 1, NULL, 5, 1, 142.85714285714);
-
---
--- Data in table `debtors_master`
---
-
-INSERT INTO `0_debtors_master` VALUES (1, 'Lucky Luke Inc.', '35 Waldorf Street\r\nTown 19358, AR', 'joe@frontaccounting.com', '12311231', 'USD', 1, 0, 0, 1, 1, 0, 0, 1000);
-INSERT INTO `0_debtors_master` VALUES (2, 'Money Makers Ltd.', 'N/A', '', '9876543', 'GBP', 1, 0, 0, 1, 1, 0, 0, 1000);
-INSERT INTO `0_debtors_master` VALUES (3, 'Junk Beer ApS', 'N/A', '', '123321123', 'DKK', 1, 0, 0, 1, 1, 0, 0, 1000);
-
---
--- Data in table `dimensions`
---
-
-INSERT INTO `0_dimensions` VALUES (1, '1', 'Development', 1, 0, '2006-01-18', '2006-02-07');
-INSERT INTO `0_dimensions` VALUES (2, '2', 'Support', 1, 0, '2006-01-18', '2007-03-07');
-INSERT INTO `0_dimensions` VALUES (3, '3', 'Training', 2, 0, '2006-01-18', '2007-03-07');
-
---
--- Data in table `exchange_rates`
---
-
-INSERT INTO `0_exchange_rates` VALUES (1, 'LE', 0.149, 0.149, '2006-01-18');
-INSERT INTO `0_exchange_rates` VALUES (2, 'GBP', 1.2, 1.2, '2006-01-18');
-INSERT INTO `0_exchange_rates` VALUES (3, 'SEK', 0.1667, 0.1667, '2007-01-29');
-INSERT INTO `0_exchange_rates` VALUES (4, 'DKK', 0.2, 0.2, '2007-03-05');
-INSERT INTO `0_exchange_rates` VALUES (5, 'EUR', 1.1, 1.1, '2007-03-05');
-
---
--- Data in table `fiscal_year`
---
-
-INSERT INTO `0_fiscal_year` VALUES (1, '2006-01-01', '2006-12-31', 0);
-INSERT INTO `0_fiscal_year` VALUES (2, '2007-01-01', '2007-12-31', 0);
-INSERT INTO `0_fiscal_year` VALUES (5, '2005-01-01', '2005-12-31', 1);
-
---
--- Data in table `form_items`
---
-
-INSERT INTO `0_form_items` VALUES (1, 10, 10, 2, '', NULL);
-INSERT INTO `0_form_items` VALUES (1, 11, 11, 2, '', NULL);
-INSERT INTO `0_form_items` VALUES (1, 18, 18, 1, '', NULL);
-INSERT INTO `0_form_items` VALUES (1, 26, 26, 1, '', NULL);
-INSERT INTO `0_form_items` VALUES (1, 30, 30, 1, '', NULL);
-INSERT INTO `0_form_items` VALUES (1, 50, 1, 2, '', NULL);
-INSERT INTO `0_form_items` VALUES (1, 51, 12, 2, '', NULL);
-INSERT INTO `0_form_items` VALUES (1, 60, 16, 2, 'DEF', NULL);
-INSERT INTO `0_form_items` VALUES (1, 61, 17, 2, 'DEF', NULL);
-INSERT INTO `0_form_items` VALUES (1, 62, 11, 2, 'DEF', NULL);
-INSERT INTO `0_form_items` VALUES (2, 10, 10, 3, '', NULL);
-INSERT INTO `0_form_items` VALUES (2, 18, 18, 2, '', NULL);
-INSERT INTO `0_form_items` VALUES (2, 26, 26, 2, '', NULL);
-INSERT INTO `0_form_items` VALUES (2, 30, 30, 2, '', NULL);
-INSERT INTO `0_form_items` VALUES (2, 50, 1, 3, '', NULL);
-INSERT INTO `0_form_items` VALUES (2, 51, 12, 3, '', NULL);
-INSERT INTO `0_form_items` VALUES (2, 60, 10, 2, 'DEF', NULL);
-INSERT INTO `0_form_items` VALUES (2, 61, 16, 2, 'CWA', NULL);
-INSERT INTO `0_form_items` VALUES (3, 10, 10, 4, '', NULL);
-INSERT INTO `0_form_items` VALUES (3, 18, 18, 3, '', NULL);
-INSERT INTO `0_form_items` VALUES (3, 26, 26, 3, '', NULL);
-INSERT INTO `0_form_items` VALUES (3, 30, 30, 3, '', '');
-INSERT INTO `0_form_items` VALUES (3, 50, 1, 4, '', NULL);
-INSERT INTO `0_form_items` VALUES (3, 51, 12, 4, '', NULL);
-INSERT INTO `0_form_items` VALUES (3, 60, 10, 3, 'DEF', NULL);
-INSERT INTO `0_form_items` VALUES (3, 61, 25, 1, 'DEF', NULL);
-INSERT INTO `0_form_items` VALUES (4, 10, 10, 5, '', '');
-INSERT INTO `0_form_items` VALUES (4, 18, 18, 4, '', NULL);
-INSERT INTO `0_form_items` VALUES (4, 26, 26, 4, '', '');
-INSERT INTO `0_form_items` VALUES (4, 30, 30, 4, '', '');
-INSERT INTO `0_form_items` VALUES (4, 50, 4, 2, '1700', NULL);
-INSERT INTO `0_form_items` VALUES (4, 51, 12, 5, '', NULL);
-INSERT INTO `0_form_items` VALUES (4, 60, 10, 4, 'DEF', NULL);
-INSERT INTO `0_form_items` VALUES (4, 61, 25, 2, 'DEF', NULL);
-INSERT INTO `0_form_items` VALUES (5, 10, 10, 6, '', '');
-INSERT INTO `0_form_items` VALUES (5, 18, 18, 5, '', NULL);
-INSERT INTO `0_form_items` VALUES (5, 26, 26, 5, '', '');
-INSERT INTO `0_form_items` VALUES (5, 30, 30, 5, '', '');
-INSERT INTO `0_form_items` VALUES (5, 50, 22, 2, '', NULL);
-INSERT INTO `0_form_items` VALUES (5, 51, 4, 2, '1710', NULL);
-INSERT INTO `0_form_items` VALUES (5, 60, 28, 1, 'DEF', '');
-INSERT INTO `0_form_items` VALUES (5, 61, 25, 3, 'DEF', NULL);
-INSERT INTO `0_form_items` VALUES (6, 10, 10, 7, '', '');
-INSERT INTO `0_form_items` VALUES (6, 30, 30, 6, '', '');
-INSERT INTO `0_form_items` VALUES (6, 50, 22, 3, '', NULL);
-INSERT INTO `0_form_items` VALUES (6, 51, 2, 2, '0', 'mr. mgoo');
-INSERT INTO `0_form_items` VALUES (6, 60, 10, 5, 'DEF', '');
-INSERT INTO `0_form_items` VALUES (6, 61, 29, 1, 'DEF', '');
-INSERT INTO `0_form_items` VALUES (7, 10, 10, 8, '', '');
-INSERT INTO `0_form_items` VALUES (7, 30, 30, 7, '', '');
-INSERT INTO `0_form_items` VALUES (7, 50, 1, 5, '4', '1');
-INSERT INTO `0_form_items` VALUES (7, 51, 12, 6, '2', '1');
-INSERT INTO `0_form_items` VALUES (7, 60, 10, 6, 'DEF', '');
-INSERT INTO `0_form_items` VALUES (7, 61, 29, 2, 'DEF', '');
-INSERT INTO `0_form_items` VALUES (8, 10, 10, 9, '', '');
-INSERT INTO `0_form_items` VALUES (8, 30, 30, 8, '', '');
-INSERT INTO `0_form_items` VALUES (8, 50, 4, 3, '1700', '1705');
-INSERT INTO `0_form_items` VALUES (8, 51, 2, 3, '4', '2');
-INSERT INTO `0_form_items` VALUES (8, 60, 10, 7, 'DEF', '');
-INSERT INTO `0_form_items` VALUES (9, 10, 10, 10, '', '');
-INSERT INTO `0_form_items` VALUES (9, 30, 30, 9, '', '');
-INSERT INTO `0_form_items` VALUES (9, 50, 1, 6, '3', '1');
-INSERT INTO `0_form_items` VALUES (9, 51, 4, 3, '1705', '1700');
-INSERT INTO `0_form_items` VALUES (9, 60, 10, 8, 'DEF', '');
-INSERT INTO `0_form_items` VALUES (10, 10, 10, 11, '', '');
-INSERT INTO `0_form_items` VALUES (10, 30, 30, 10, '', '');
-INSERT INTO `0_form_items` VALUES (10, 50, 1, 7, '0', 'gylle transport');
-INSERT INTO `0_form_items` VALUES (10, 51, 2, 4, '2', '1');
-INSERT INTO `0_form_items` VALUES (10, 60, 10, 9, 'DEF', '');
-INSERT INTO `0_form_items` VALUES (11, 10, 10, 12, '', '');
-INSERT INTO `0_form_items` VALUES (11, 30, 30, 11, '', '');
-INSERT INTO `0_form_items` VALUES (11, 60, 10, 10, 'DEF', '');
-INSERT INTO `0_form_items` VALUES (12, 10, 10, 13, '', '');
-INSERT INTO `0_form_items` VALUES (12, 30, 30, 12, '', '');
-INSERT INTO `0_form_items` VALUES (12, 60, 10, 11, 'DEF', '');
-INSERT INTO `0_form_items` VALUES (13, 10, 10, 14, '', '');
-INSERT INTO `0_form_items` VALUES (13, 30, 30, 13, '', '');
-INSERT INTO `0_form_items` VALUES (13, 60, 10, 12, 'DEF', '');
-INSERT INTO `0_form_items` VALUES (14, 10, 10, 15, '', '');
-INSERT INTO `0_form_items` VALUES (14, 30, 30, 14, '', '');
-INSERT INTO `0_form_items` VALUES (14, 60, 10, 13, 'DEF', '');
-INSERT INTO `0_form_items` VALUES (15, 10, 10, 16, '', '');
-INSERT INTO `0_form_items` VALUES (15, 30, 30, 15, '', '');
-INSERT INTO `0_form_items` VALUES (15, 60, 10, 14, 'DEF', '');
-INSERT INTO `0_form_items` VALUES (16, 60, 10, 15, 'DEF', '');
-INSERT INTO `0_form_items` VALUES (17, 60, 10, 16, 'DEF', '');
-
---
--- Data in table `gl_trans`
---
-
-INSERT INTO `0_gl_trans` VALUES (1, 10, 2, '2006-01-18', '3000', '', -500, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (2, 10, 2, '2006-01-18', '3000', '', -1000, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (3, 10, 2, '2006-01-18', '3000', '', -250, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (4, 10, 2, '2006-01-18', '1500', '', 1750, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (5, 10, 3, '2006-01-18', '3000', '', -1000, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (6, 10, 3, '2006-01-18', '1500', '', 1000, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (7, 12, 2, '2006-01-18', '1700', '', 5000, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (8, 12, 2, '2006-01-18', '1500', '', -10000, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (9, 12, 3, '2006-01-18', '1700', '', 240, 0, 0, 2, 0x32);
-INSERT INTO `0_gl_trans` VALUES (10, 12, 3, '2006-01-18', '1500', '', -240, 0, 0, 2, 0x32);
-INSERT INTO `0_gl_trans` VALUES (11, 12, 4, '2006-01-18', '1700', '', 360, 0, 0, 2, 0x32);
-INSERT INTO `0_gl_trans` VALUES (12, 12, 4, '2006-01-18', '1500', '', -360, 0, 0, 2, 0x32);
-INSERT INTO `0_gl_trans` VALUES (13, 12, 5, '2006-01-18', '1700', '', 500, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (14, 12, 5, '2006-01-18', '1500', '', -500, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (15, 11, 2, '2006-01-18', '3000', '', 1260, 0, 0, 2, 0x32);
-INSERT INTO `0_gl_trans` VALUES (16, 11, 2, '2006-01-18', '1500', '', -1260, 0, 0, 2, 0x32);
-INSERT INTO `0_gl_trans` VALUES (17, 10, 4, '2006-01-18', '3000', '', -1268.57142857, 0, 0, 2, 0x32);
-INSERT INTO `0_gl_trans` VALUES (18, 10, 4, '2006-01-18', '1500', '', 1332, 0, 0, 2, 0x32);
-INSERT INTO `0_gl_trans` VALUES (19, 10, 4, '2006-01-18', '2660', '', -63.4285714286, 0, 0, 2, 0x32);
-INSERT INTO `0_gl_trans` VALUES (20, 1, 2, '2006-01-18', '1700', '', -25, 0, 0, 0, NULL);
-INSERT INTO `0_gl_trans` VALUES (21, 1, 2, '2006-01-18', '6600', '', 10, 0, 0, 0, NULL);
-INSERT INTO `0_gl_trans` VALUES (22, 1, 2, '2006-01-18', '6730', '', 15, 0, 0, 0, NULL);
-INSERT INTO `0_gl_trans` VALUES (23, 1, 3, '2006-01-18', '1705', '', -250, 0, 0, 0, NULL);
-INSERT INTO `0_gl_trans` VALUES (24, 1, 3, '2006-01-18', '6810', '', 3000, 0, 0, 0, NULL);
-INSERT INTO `0_gl_trans` VALUES (25, 1, 3, '2006-01-18', '6700', '', 150, 0, 0, 0, NULL);
-INSERT INTO `0_gl_trans` VALUES (26, 1, 4, '2006-01-18', '1700', '', -555, 0, 0, 4, 0x31);
-INSERT INTO `0_gl_trans` VALUES (27, 1, 4, '2006-01-18', '4500', '', 555, 0, 0, 4, 0x31);
-INSERT INTO `0_gl_trans` VALUES (28, 4, 2, '2006-01-18', '1700', '', -300, 0, 0, 0, NULL);
-INSERT INTO `0_gl_trans` VALUES (29, 4, 2, '2006-01-18', '1710', '', 300, 0, 0, 0, NULL);
-INSERT INTO `0_gl_trans` VALUES (30, 22, 2, '2006-01-18', '2630', '', 5000, 0, 0, 3, 0x31);
-INSERT INTO `0_gl_trans` VALUES (31, 22, 2, '2006-01-18', '1700', '', -5000, 0, 0, 3, 0x31);
-INSERT INTO `0_gl_trans` VALUES (32, 22, 3, '2006-01-18', '2630', '', 3960, 0, 0, 3, 0x32);
-INSERT INTO `0_gl_trans` VALUES (33, 22, 3, '2006-01-18', '1710', '', -3960, 0, 0, 3, 0x32);
-INSERT INTO `0_gl_trans` VALUES (34, 20, 2, '2006-01-18', '2630', '', -3445, 0, 0, 3, 0x31);
-INSERT INTO `0_gl_trans` VALUES (35, 20, 2, '2006-01-18', '1420', '', 1000, 0, 0, 3, 0x31);
-INSERT INTO `0_gl_trans` VALUES (36, 20, 2, '2006-01-18', '1420', '', 2250, 0, 0, 3, 0x31);
-INSERT INTO `0_gl_trans` VALUES (37, 20, 2, '2006-01-18', '2660', '', 162.5, 0, 0, 3, 0x31);
-INSERT INTO `0_gl_trans` VALUES (38, 20, 2, '2006-01-18', '2660', '', 32.5, 0, 0, 3, 0x31);
-INSERT INTO `0_gl_trans` VALUES (39, 20, 3, '2006-01-18', '2630', '', -26, 0, 0, 3, 0x31);
-INSERT INTO `0_gl_trans` VALUES (40, 20, 3, '2006-01-18', '1420', '', 26, 0, 0, 3, 0x31);
-INSERT INTO `0_gl_trans` VALUES (41, 2, 2, '2006-01-20', '1700', '', 1050, 0, 0, 0, NULL);
-INSERT INTO `0_gl_trans` VALUES (42, 2, 2, '2006-01-20', '4500', '', -1000, 0, 0, 0, NULL);
-INSERT INTO `0_gl_trans` VALUES (43, 2, 2, '2006-01-20', '6400', '', -50, 0, 0, 0, NULL);
-INSERT INTO `0_gl_trans` VALUES (44, 10, 5, '2007-01-28', '3000', '', -2000, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (45, 10, 5, '2007-01-28', '3000', '', -90000, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (46, 10, 5, '2007-01-28', '3000', '', -1050, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (47, 10, 5, '2007-01-28', '1500', '', 93050, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (48, 10, 6, '2007-01-30', '3000', '', -333, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (49, 10, 6, '2007-01-30', '1500', '', 333, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (50, 12, 6, '2007-01-30', '1700', '', 200, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (51, 12, 6, '2007-01-30', '1500', '', -200, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (52, 1, 5, '2007-01-30', '1700', '', -200, 0, 0, 4, 0x31);
-INSERT INTO `0_gl_trans` VALUES (53, 1, 5, '2007-01-30', '1400', 'Gylle', 200, 0, 0, 4, 0x31);
-INSERT INTO `0_gl_trans` VALUES (54, 2, 3, '2007-01-30', '1700', '', 70, 0, 0, 4, 0x32);
-INSERT INTO `0_gl_trans` VALUES (55, 2, 3, '2007-01-30', '4500', 'Packing', -50, 0, 0, 4, 0x32);
-INSERT INTO `0_gl_trans` VALUES (56, 2, 3, '2007-01-30', '6400', '', -20, 0, 0, 4, 0x32);
-INSERT INTO `0_gl_trans` VALUES (57, 20, 4, '2007-01-30', '2630', '', -17350, 0, 0, 3, 0x31);
-INSERT INTO `0_gl_trans` VALUES (58, 20, 4, '2007-01-30', '1420', '', 15100, 0, 0, 3, 0x31);
-INSERT INTO `0_gl_trans` VALUES (59, 20, 4, '2007-01-30', '1420', '', 2250, 0, 0, 3, 0x31);
-INSERT INTO `0_gl_trans` VALUES (60, 0, 2, '2007-02-02', '3000', 'nana', -100, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (61, 0, 2, '2007-02-02', '4010', 'jojo', 100, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (62, 0, 3, '2007-02-02', '3000', '', -25, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (63, 0, 3, '2007-02-02', '4000', '', 25, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (64, 0, 4, '2007-03-01', '3000', '', 25, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (65, 0, 4, '2007-03-01', '4000', '', -25, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (66, 0, 5, '2007-02-02', '3000', '', -50, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (67, 0, 5, '2007-02-02', '4000', '', 50, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (68, 0, 6, '2007-02-02', '3020', 'Til Ejnar', -400, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (69, 0, 6, '2007-02-02', '1500', 'Opdate forrige linje', 400, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (70, 20, 5, '2007-02-03', '2630', '', -6644, 0, 0, 3, 0x31);
-INSERT INTO `0_gl_trans` VALUES (71, 20, 5, '2007-02-03', '1420', '', 6644, 0, 0, 3, 0x31);
-INSERT INTO `0_gl_trans` VALUES (72, 10, 7, '2007-02-03', '3000', '', -333, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (73, 10, 7, '2007-02-03', '1500', '', 333, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (74, 10, 8, '2007-02-03', '3000', '', -333, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (75, 10, 8, '2007-02-03', '1500', '', 333, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (76, 10, 9, '2007-02-03', '3000', '', -3428.5714285714, 0, 0, 2, 0x32);
-INSERT INTO `0_gl_trans` VALUES (77, 10, 9, '2007-02-03', '1500', '', 3600, 0, 0, 2, 0x32);
-INSERT INTO `0_gl_trans` VALUES (78, 10, 9, '2007-02-03', '2660', '', -171.42857142857, 0, 0, 2, 0x32);
-INSERT INTO `0_gl_trans` VALUES (79, 10, 10, '2007-02-04', '3000', '', -333, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (80, 10, 10, '2007-02-04', '1500', '', 333, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (81, 10, 11, '2007-02-04', '3000', '', -333, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (82, 10, 11, '2007-02-04', '1500', '', 333, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (83, 10, 12, '2007-02-06', '3000', '', -333, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (84, 10, 12, '2007-02-06', '1500', '', 333, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (85, 0, 7, '2007-02-06', '1400', '', 100, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (86, 0, 7, '2007-02-06', '1500', '', -100, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (87, 0, 8, '2007-02-06', '1400', '', 100, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (88, 0, 8, '2007-02-06', '2000', '', -100, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (89, 0, 9, '2006-04-06', '1400', '', 100, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (90, 0, 9, '2006-04-06', '2000', '', -100, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (91, 0, 10, '2007-02-06', '1400', '', 100, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (92, 0, 10, '2007-02-06', '2050', '', -100, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (93, 0, 11, '2006-04-06', '1400', '', 100, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (94, 0, 11, '2006-04-06', '3000', '', -100, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (95, 0, 12, '2007-02-06', '1400', '', 100, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (96, 0, 12, '2007-02-06', '3000', '', -100, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (97, 0, 13, '2007-02-13', '1400', '', 10, 1, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (98, 0, 13, '2007-02-13', '1400', '', -10, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (99, 10, 13, '2007-02-25', '3000', '', -333, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (100, 10, 13, '2007-02-25', '1500', '', 333, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (101, 0, 14, '2007-02-25', '1400', '', 10, 1, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (102, 0, 14, '2007-02-25', '3000', '', -10, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (103, 0, 15, '2007-03-02', '1400', '', 10, 1, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (104, 0, 15, '2007-03-02', '1400', '', -10, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (105, 0, 16, '2007-03-02', '3000', '', 100, 1, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (106, 0, 16, '2007-03-02', '1430', '', -100, 1, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (107, 10, 14, '2007-03-04', '3000', '', -333, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (108, 10, 14, '2007-03-04', '1500', '', 333, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (109, 10, 15, '2007-03-05', '3000', '', -333, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (110, 10, 15, '2007-03-05', '1500', '', 358, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (111, 10, 15, '2007-03-05', '3800', '', -25, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (112, 10, 16, '2007-03-05', '3000', '', -3000, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (113, 10, 16, '2007-03-05', '1500', '', 3044, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (114, 10, 16, '2007-03-05', '3800', '', -44, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (115, 20, 6, '2007-03-05', '2630', '', -33.34, 0, 0, 3, 0x33);
-INSERT INTO `0_gl_trans` VALUES (116, 20, 6, '2007-03-05', '6730', '', 33.34, 1, 0, 3, 0x33);
-INSERT INTO `0_gl_trans` VALUES (117, 4, 3, '2007-03-09', '1700', '', -222, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (118, 4, 3, '2007-03-09', '1705', '', 222, 0, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (119, 2, 4, '2007-03-09', '1700', '', 200, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (120, 2, 4, '2007-03-09', '1400', '', -200, 0, 0, 2, 0x31);
-INSERT INTO `0_gl_trans` VALUES (121, 1, 6, '2007-03-22', '1700', '', -200, 0, 0, 3, 0x31);
-INSERT INTO `0_gl_trans` VALUES (122, 1, 6, '2007-03-22', '2630', '', 200, 0, 0, 3, 0x31);
-INSERT INTO `0_gl_trans` VALUES (123, 1, 7, '2007-03-22', '1700', '', -125, 0, 0, 0, 0x67796c6c657472616e73706f7274);
-INSERT INTO `0_gl_trans` VALUES (124, 1, 7, '2007-03-22', '6700', '', 100, 0, 0, 0, 0x67796c6c657472616e73706f7274);
-INSERT INTO `0_gl_trans` VALUES (125, 1, 7, '2007-03-22', '2682', '', 25, 0, 0, 0, 0x67796c6c657472616e73706f7274);
-INSERT INTO `0_gl_trans` VALUES (126, 0, 17, '2007-03-25', '3000', '', -300, 1, 0, NULL, NULL);
-INSERT INTO `0_gl_trans` VALUES (127, 0, 17, '2007-03-25', '4200', '', 300, 0, 0, NULL, NULL);
-
---
--- Data in table `grn_batch`
---
-
-INSERT INTO `0_grn_batch` VALUES (1, 1, 1, '1', '2006-01-18', 'DEF');
-INSERT INTO `0_grn_batch` VALUES (2, 1, 2, '2', '2006-01-18', 'DEF');
-INSERT INTO `0_grn_batch` VALUES (3, 1, 5, '3', '2006-01-18', 'DEF');
-
---
--- Data in table `grn_items`
---
-
-INSERT INTO `0_grn_items` VALUES (1, 1, 1, '102', '17 inch VGA Monitor', 10, 10);
-INSERT INTO `0_grn_items` VALUES (2, 1, 2, '103', '32MB VGA Card', 50, 50);
-INSERT INTO `0_grn_items` VALUES (3, 2, 3, '104', '52x CD Drive', 1, 1);
-INSERT INTO `0_grn_items` VALUES (4, 3, 6, '104', '52x CD Drive (upgraded)', 3020, 302);
-
---
--- Data in table `item_tax_types`
---
-
-INSERT INTO `0_item_tax_types` VALUES (1, 'Regular', 0);
-
---
--- Data in table `loc_stock`
---
-
-INSERT INTO `0_loc_stock` VALUES ('CWA', '102', 0);
-INSERT INTO `0_loc_stock` VALUES ('CWA', '103', 0);
-INSERT INTO `0_loc_stock` VALUES ('CWA', '104', 0);
-INSERT INTO `0_loc_stock` VALUES ('CWA', '201', 0);
-INSERT INTO `0_loc_stock` VALUES ('CWA', '3400', 0);
-INSERT INTO `0_loc_stock` VALUES ('DEF', '102', 0);
-INSERT INTO `0_loc_stock` VALUES ('DEF', '103', 0);
-INSERT INTO `0_loc_stock` VALUES ('DEF', '104', 0);
-INSERT INTO `0_loc_stock` VALUES ('DEF', '201', 0);
-INSERT INTO `0_loc_stock` VALUES ('DEF', '3400', 0);
-
---
--- Data in table `locations`
---
+### Data of table `0_cust_allocations` ###
+
+INSERT INTO `0_cust_allocations` VALUES ('1', '200', '2007-01-30', '6', '12', '6', '10');
+INSERT INTO `0_cust_allocations` VALUES ('4', '133', '2007-03-09', '4', '2', '6', '10');
+INSERT INTO `0_cust_allocations` VALUES ('5', '135', '2008-03-06', '1', '11', '5', '10');
+INSERT INTO `0_cust_allocations` VALUES ('6', '135', '2008-03-06', '2', '11', '6', '10');
+INSERT INTO `0_cust_allocations` VALUES ('7', '135', '2008-03-06', '3', '11', '4', '10');
+INSERT INTO `0_cust_allocations` VALUES ('8', '125', '2008-03-07', '4', '11', '4', '11');
+
+### Data of table `0_cust_branch` ###
+
+INSERT INTO `0_cust_branch` VALUES ('1', '1', 'Main', '', '1', '1', '', '', 'Lucky Luke Inc.', 'lucky@luke.com', 'DEF', '1', '3000', '3000', '1500', '3200', '1', '0', 'The Road');
+INSERT INTO `0_cust_branch` VALUES ('2', '1', 'Service divison', '', '4', '1', '', '', '', '', 'DEF', '2', '3000', '3000', '1500', '3200', '1', '0', 'Another Road');
+INSERT INTO `0_cust_branch` VALUES ('3', '2', 'Main', '', '4', '2', '', '', 'Money Makers Ltd.', '', 'DEF', '2', '3000', '3000', '1500', '3200', '1', '0', '');
+INSERT INTO `0_cust_branch` VALUES ('5', '3', 'Main', '', '4', '1', '', '', 'Junk Beer ApS', '', 'CWA', '2', '3000', '3000', '1500', '3200', '1', '0', '');
+INSERT INTO `0_cust_branch` VALUES ('6', '4', 'Johny Bravo', 'Never Mind 13', '1', '1', '123', '', 'Johny Bravo', '', 'DEF', '1', '3000', '3000', '1500', '3200', '1', '0', 'Never Mind 13');
+INSERT INTO `0_cust_branch` VALUES ('7', '3', 'Junk Beer ApS', 'N/A', '1', '1', '1223123', '', 'junk@junkbeer.dk', '', 'DEF', '1', '3000', '3000', '1500', '3200', '1', '0', 'N/A');
+
+### Data of table `0_debtor_trans` ###
+
+INSERT INTO `0_debtor_trans` VALUES ('1', '10', '0', '4', '6', '2008-03-06', '2008-03-16', '0', '1', '1', '125', '0', '10', '0', '0', '0', '1', '1', '1');
+INSERT INTO `0_debtor_trans` VALUES ('1', '11', '0', '4', '6', '2008-03-06', '0000-00-00', '0', '1', '5', '125', '0', '10', '0', '0', '0', '1', '1', '5');
+INSERT INTO `0_debtor_trans` VALUES ('1', '13', '1', '4', '6', '2008-03-06', '2008-03-16', '0', '1', '1', '125', '0', '10', '0', '0', '0', '1', '1', '1');
+INSERT INTO `0_debtor_trans` VALUES ('2', '10', '0', '4', '6', '2008-03-06', '2008-03-06', '1', '1', '2', '125', '0', '10', '0', '0', '0', '1', '1', '2');
+INSERT INTO `0_debtor_trans` VALUES ('2', '11', '0', '4', '6', '2008-03-06', '0000-00-00', '1', '1', '6', '125', '0', '10', '0', '0', '135', '1', '1', '6');
+INSERT INTO `0_debtor_trans` VALUES ('2', '13', '1', '4', '6', '2008-03-06', '2008-03-06', 'auto', '1', '2', '125', '0', '10', '0', '0', '0', '1', '1', '2');
+INSERT INTO `0_debtor_trans` VALUES ('3', '10', '0', '4', '6', '2008-03-06', '2008-03-06', '2', '1', '3', '125', '0', '10', '0', '0', '0', '1', '1', '3');
+INSERT INTO `0_debtor_trans` VALUES ('3', '11', '0', '4', '6', '2008-03-06', '0000-00-00', '2', '1', '4', '125', '0', '10', '0', '0', '135', '1', '1', '4');
+INSERT INTO `0_debtor_trans` VALUES ('3', '13', '1', '4', '6', '2008-03-06', '2008-03-06', 'auto', '1', '3', '125', '0', '10', '0', '0', '0', '1', '1', '3');
+INSERT INTO `0_debtor_trans` VALUES ('4', '10', '1', '4', '6', '2008-03-06', '2008-03-06', '3', '1', '4', '125', '0', '10', '0', '0', '135', '1', '1', '4');
+INSERT INTO `0_debtor_trans` VALUES ('4', '11', '0', '1', '1', '2008-03-07', '0000-00-00', '3', '1', '0', '100', '25', '0', '0', '0', '250', '1', '1', '0');
+INSERT INTO `0_debtor_trans` VALUES ('4', '13', '1', '4', '6', '2008-03-06', '2008-03-06', 'auto', '1', '4', '125', '0', '10', '0', '0', '0', '1', '1', '4');
+INSERT INTO `0_debtor_trans` VALUES ('5', '10', '1', '4', '6', '2008-03-06', '2008-03-06', '4', '1', '5', '125', '0', '10', '0', '0', '135', '1', '1', '5');
+INSERT INTO `0_debtor_trans` VALUES ('5', '13', '1', '4', '6', '2008-03-06', '2008-03-06', 'auto', '1', '5', '125', '0', '10', '0', '0', '0', '1', '1', '5');
+INSERT INTO `0_debtor_trans` VALUES ('6', '10', '1', '4', '6', '2008-03-06', '2008-03-06', '5', '1', '6', '125', '0', '10', '0', '0', '135', '1', '1', '6');
+INSERT INTO `0_debtor_trans` VALUES ('6', '13', '1', '4', '6', '2008-03-06', '2008-03-06', 'auto', '1', '6', '125', '0', '10', '0', '0', '0', '1', '1', '6');
+INSERT INTO `0_debtor_trans` VALUES ('7', '10', '0', '4', '6', '2008-03-08', '2008-03-08', '6', '1', '9', '125', '0', '10', '0', '0', '0', '1', '1', '9');
+INSERT INTO `0_debtor_trans` VALUES ('7', '12', '0', '1', '1', '2008-03-06', '0000-00-00', '6', '0', '0', '100', '0', '0', '0', '0', '0', '1', '0', '0');
+INSERT INTO `0_debtor_trans` VALUES ('7', '13', '0', '4', '6', '2008-03-06', '2008-03-06', '1', '1', '7', '125', '0', '10', '0', '0', '0', '1', '1', '0');
+INSERT INTO `0_debtor_trans` VALUES ('8', '10', '0', '4', '6', '2008-03-09', '2008-03-09', '7', '1', '10', '125', '0', '12.5', '0', '0', '0', '1', '1', '10');
+INSERT INTO `0_debtor_trans` VALUES ('8', '12', '0', '4', '6', '2008-03-06', '0000-00-00', '7', '0', '0', '100', '0', '0', '0', '0', '0', '1', '0', '0');
+INSERT INTO `0_debtor_trans` VALUES ('8', '13', '1', '4', '6', '2008-03-07', '2008-03-07', '2', '1', '8', '125', '0', '10', '0', '0', '0', '1', '1', '13');
+INSERT INTO `0_debtor_trans` VALUES ('9', '10', '0', '1', '1', '2008-03-09', '2008-03-09', '8', '2', '11', '100', '25', '10', '2.5', '0', '0', '1', '1', '11');
+INSERT INTO `0_debtor_trans` VALUES ('9', '12', '0', '1', '1', '2008-03-07', '0000-00-00', '8', '0', '0', '2000', '0', '0', '0', '0', '0', '1', '0', '0');
+INSERT INTO `0_debtor_trans` VALUES ('9', '13', '1', '4', '6', '2008-03-08', '2008-03-08', 'auto', '1', '9', '125', '0', '10', '0', '0', '0', '1', '1', '7');
+INSERT INTO `0_debtor_trans` VALUES ('10', '10', '0', '4', '6', '2008-03-09', '2008-03-09', '9', '1', '12', '125', '0', '10', '0', '0', '0', '1', '1', '12');
+INSERT INTO `0_debtor_trans` VALUES ('10', '13', '1', '4', '6', '2008-03-09', '2008-03-09', 'auto', '1', '10', '125', '0', '12.5', '0', '0', '0', '1', '1', '8');
+INSERT INTO `0_debtor_trans` VALUES ('11', '10', '0', '1', '1', '2008-03-10', '2008-03-20', '10', '2', '15', '100', '25', '0', '0', '0', '0', '1', '1', '14');
+INSERT INTO `0_debtor_trans` VALUES ('11', '13', '1', '1', '1', '2008-03-09', '2008-03-09', 'auto', '2', '11', '100', '25', '10', '2.5', '0', '0', '1', '1', '9');
+INSERT INTO `0_debtor_trans` VALUES ('12', '10', '0', '1', '1', '2008-03-10', '2008-03-29', '11', '2', '16', '100', '25', '0', '0', '0', '0', '1', '1', '15');
+INSERT INTO `0_debtor_trans` VALUES ('12', '13', '1', '4', '6', '2008-03-09', '2008-03-09', 'auto', '1', '12', '125', '0', '10', '0', '0', '0', '1', '1', '10');
+INSERT INTO `0_debtor_trans` VALUES ('13', '10', '0', '4', '6', '2008-03-07', '2008-03-07', '12', '1', '8', '125', '0', '10', '0', '0', '0', '1', '1', '8');
+INSERT INTO `0_debtor_trans` VALUES ('13', '13', '1', '4', '6', '2008-03-10', '2008-03-20', '3', '1', '14', '40', '0', '0', '0', '0', '0', '1', '1', '15');
+INSERT INTO `0_debtor_trans` VALUES ('14', '10', '0', '4', '6', '2008-03-10', '2008-03-10', '13', '1', '18', '125', '0', '10', '0', '0', '0', '1', '1', '17');
+INSERT INTO `0_debtor_trans` VALUES ('14', '13', '1', '1', '1', '2008-03-10', '2008-03-20', '4', '2', '15', '100', '25', '0', '0', '0', '0', '1', '1', '11');
+INSERT INTO `0_debtor_trans` VALUES ('15', '10', '0', '4', '6', '2008-03-10', '2008-04-17', '14', '1', '14', '40', '0', '0', '0', '0', '0', '1', '1', '13');
+INSERT INTO `0_debtor_trans` VALUES ('15', '13', '1', '1', '1', '2008-03-10', '2008-03-20', '5', '2', '16', '100', '25', '0', '0', '0', '0', '1', '1', '12');
+INSERT INTO `0_debtor_trans` VALUES ('16', '10', '0', '4', '6', '2008-03-17', '2008-04-17', '15', '1', '19', '125', '0', '10', '0', '0', '0', '1', '1', '18');
+INSERT INTO `0_debtor_trans` VALUES ('16', '13', '1', '3', '5', '2008-03-10', '2008-03-20', '6', '1', '17', '11', '0', '0', '0', '0', '0', '0.20563796227935', '1', '17');
+INSERT INTO `0_debtor_trans` VALUES ('17', '10', '0', '3', '5', '2008-03-10', '2008-04-17', '16', '1', '17', '11', '0', '0', '0', '0', '0', '0.20563796227935', '1', '16');
+INSERT INTO `0_debtor_trans` VALUES ('17', '13', '1', '4', '6', '2008-03-10', '2008-03-10', 'auto', '1', '18', '125', '0', '10', '0', '0', '0', '1', '1', '14');
+INSERT INTO `0_debtor_trans` VALUES ('18', '10', '0', '3', '5', '2008-03-29', '2008-04-17', '17', '1', '20', '0', '0', '0', '0', '0', '0', '0.20674817019223', '1', '19');
+INSERT INTO `0_debtor_trans` VALUES ('18', '13', '1', '4', '6', '2008-03-17', '2008-03-27', '7', '1', '19', '125', '0', '10', '0', '0', '0', '1', '1', '16');
+INSERT INTO `0_debtor_trans` VALUES ('19', '10', '0', '4', '6', '2008-03-29', '2008-04-17', '18', '1', '21', '125', '0', '0', '0', '0', '0', '1', '1', '20');
+INSERT INTO `0_debtor_trans` VALUES ('19', '13', '1', '3', '5', '2008-03-29', '2008-04-17', 'auto', '1', '20', '0', '0', '0', '0', '0', '0', '0.20674817019223', '1', '18');
+INSERT INTO `0_debtor_trans` VALUES ('20', '13', '1', '4', '6', '2008-03-29', '2008-04-08', '8', '1', '21', '125', '0', '0', '0', '0', '0', '1', '1', '19');
+
+### Data of table `0_debtor_trans_details` ###
+
+INSERT INTO `0_debtor_trans_details` VALUES ('1', '1', '13', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '1');
+INSERT INTO `0_debtor_trans_details` VALUES ('2', '1', '10', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '0');
+INSERT INTO `0_debtor_trans_details` VALUES ('3', '2', '13', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '1');
+INSERT INTO `0_debtor_trans_details` VALUES ('4', '2', '10', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '0');
+INSERT INTO `0_debtor_trans_details` VALUES ('5', '3', '13', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '1');
+INSERT INTO `0_debtor_trans_details` VALUES ('6', '3', '10', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '0');
+INSERT INTO `0_debtor_trans_details` VALUES ('7', '4', '13', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '1');
+INSERT INTO `0_debtor_trans_details` VALUES ('8', '4', '10', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '1');
+INSERT INTO `0_debtor_trans_details` VALUES ('9', '5', '13', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '1');
+INSERT INTO `0_debtor_trans_details` VALUES ('10', '5', '10', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '1');
+INSERT INTO `0_debtor_trans_details` VALUES ('11', '1', '11', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '0');
+INSERT INTO `0_debtor_trans_details` VALUES ('12', '6', '13', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '1');
+INSERT INTO `0_debtor_trans_details` VALUES ('13', '6', '10', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '1');
+INSERT INTO `0_debtor_trans_details` VALUES ('14', '7', '13', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '0');
+INSERT INTO `0_debtor_trans_details` VALUES ('15', '2', '11', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '0');
+INSERT INTO `0_debtor_trans_details` VALUES ('16', '3', '11', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '0');
+INSERT INTO `0_debtor_trans_details` VALUES ('17', '4', '11', '102', '17 inch VGA Monitor', '100', '25', '1', '0', '0', '0');
+INSERT INTO `0_debtor_trans_details` VALUES ('18', '8', '13', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '1');
+INSERT INTO `0_debtor_trans_details` VALUES ('19', '9', '13', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '1');
+INSERT INTO `0_debtor_trans_details` VALUES ('20', '7', '10', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '0');
+INSERT INTO `0_debtor_trans_details` VALUES ('21', '10', '13', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '1');
+INSERT INTO `0_debtor_trans_details` VALUES ('22', '8', '10', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '0');
+INSERT INTO `0_debtor_trans_details` VALUES ('23', '11', '13', '102', '17 inch VGA Monitor', '100', '25', '1', '0', '80', '1');
+INSERT INTO `0_debtor_trans_details` VALUES ('24', '9', '10', '102', '17 inch VGA Monitor', '100', '25', '1', '0', '80', '0');
+INSERT INTO `0_debtor_trans_details` VALUES ('25', '12', '13', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '1');
+INSERT INTO `0_debtor_trans_details` VALUES ('26', '10', '10', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '0');
+INSERT INTO `0_debtor_trans_details` VALUES ('27', '13', '13', '103', '32MB VGA Card', '40', '8', '1', '0', '20', '1');
+INSERT INTO `0_debtor_trans_details` VALUES ('28', '14', '13', '102', '17 inch VGA Monitor', '100', '25', '1', '0', '80', '1');
+INSERT INTO `0_debtor_trans_details` VALUES ('29', '11', '10', '102', '17 inch VGA Monitor', '100', '25', '1', '0', '80', '0');
+INSERT INTO `0_debtor_trans_details` VALUES ('30', '15', '13', '102', '17 inch VGA Monitor', '100', '25', '1', '0', '80', '1');
+INSERT INTO `0_debtor_trans_details` VALUES ('31', '12', '10', '102', '17 inch VGA Monitor', '100', '25', '1', '0', '80', '0');
+INSERT INTO `0_debtor_trans_details` VALUES ('32', '13', '10', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '0');
+INSERT INTO `0_debtor_trans_details` VALUES ('33', '16', '13', '102', '17 inch VGA Monitor', '11', '0', '1', '0', '80', '1');
+INSERT INTO `0_debtor_trans_details` VALUES ('34', '17', '13', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '1');
+INSERT INTO `0_debtor_trans_details` VALUES ('35', '14', '10', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '80', '0');
+INSERT INTO `0_debtor_trans_details` VALUES ('36', '15', '10', '103', '32MB VGA Card', '40', '8', '1', '0', '20', '0');
+INSERT INTO `0_debtor_trans_details` VALUES ('37', '18', '13', '102', '17 inch VGA Monitor', '125', '25', '0', '0', '-3.4114285714283', '0');
+INSERT INTO `0_debtor_trans_details` VALUES ('38', '18', '13', 'AA101', 'olie 5w40', '125', '25', '1', '0', '5.0599509174312', '1');
+INSERT INTO `0_debtor_trans_details` VALUES ('39', '16', '10', '102', '17 inch VGA Monitor', '125', '25', '0', '0', '-3.4114285714283', '0');
+INSERT INTO `0_debtor_trans_details` VALUES ('40', '16', '10', 'AA101', 'olie 5w40', '125', '25', '1', '0', '5.0599509174312', '0');
+INSERT INTO `0_debtor_trans_details` VALUES ('41', '17', '10', '102', '17 inch VGA Monitor', '11', '0', '1', '0', '80', '0');
+INSERT INTO `0_debtor_trans_details` VALUES ('42', '19', '13', '102', '17 inch VGA Monitor', '0', '0', '1', '0', '-3.4114285714283', '1');
+INSERT INTO `0_debtor_trans_details` VALUES ('43', '18', '10', '102', '17 inch VGA Monitor', '0', '0', '1', '0', '-3.4114285714283', '0');
+INSERT INTO `0_debtor_trans_details` VALUES ('44', '20', '13', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '-3.4114285714283', '1');
+INSERT INTO `0_debtor_trans_details` VALUES ('45', '19', '10', '102', '17 inch VGA Monitor', '125', '25', '1', '0', '-3.4114285714283', '0');
+
+### Data of table `0_debtor_trans_tax_details` ###
+
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('1', '1', '13', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('2', '1', '10', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('3', '2', '13', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('4', '2', '10', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('5', '3', '13', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('6', '3', '10', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('7', '4', '13', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('8', '4', '10', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('9', '5', '13', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('10', '5', '10', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('11', '1', '11', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('12', '6', '13', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('13', '6', '10', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('14', '7', '13', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('15', '2', '11', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('16', '3', '11', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('17', '4', '11', '3', NULL, '25', '0', '25');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('18', '8', '13', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('19', '9', '13', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('20', '7', '10', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('21', '10', '13', '3', NULL, '25', '1', '27.5');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('22', '8', '10', '3', NULL, '25', '1', '27.5');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('23', '11', '13', '3', NULL, '25', '0', '27.5');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('24', '9', '10', '3', NULL, '25', '0', '27.5');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('25', '12', '13', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('26', '10', '10', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('27', '13', '13', '3', NULL, '25', '1', '8');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('28', '14', '13', '3', NULL, '25', '0', '25');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('29', '11', '10', '3', NULL, '25', '0', '25');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('30', '15', '13', '3', NULL, '25', '0', '25');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('31', '12', '10', '3', NULL, '25', '0', '25');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('32', '13', '10', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('33', '17', '13', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('34', '14', '10', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('35', '15', '10', '3', NULL, '25', '1', '8');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('36', '18', '13', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('37', '16', '10', '3', NULL, '25', '1', '27');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('38', '20', '13', '3', NULL, '25', '1', '25');
+INSERT INTO `0_debtor_trans_tax_details` VALUES ('39', '19', '10', '3', NULL, '25', '1', '25');
+
+### Data of table `0_debtors_master` ###
+
+INSERT INTO `0_debtors_master` VALUES ('1', 'Lucky Luke Inc.', '35 Waldorf Street\r\nTown 19358, AR', 'joe@home.com', '12311231', 'USD', '2', '0', '0', '1', '1', '0', '0', '1000');
+INSERT INTO `0_debtors_master` VALUES ('2', 'Money Makers Ltd.', 'N/A', '', '9876543', 'GBP', '2', '0', '0', '1', '1', '0', '0', '1000');
+INSERT INTO `0_debtors_master` VALUES ('3', 'Junk Beer ApS', 'N/A', '', '123321123', 'DKK', '1', '0', '0', '1', '1', '0', '0', '1000');
+INSERT INTO `0_debtors_master` VALUES ('4', 'Retail clients', 'Never Mind 13', '', '', 'USD', '1', '0', '0', '1', '1', '0', '0', '1000');
+
+### Data of table `0_dimensions` ###
+
+INSERT INTO `0_dimensions` VALUES ('1', '1', 'Development', '1', '0', '2006-01-18', '2006-02-07');
+INSERT INTO `0_dimensions` VALUES ('2', '2', 'Support', '1', '0', '2006-01-18', '2007-03-07');
+INSERT INTO `0_dimensions` VALUES ('3', '3', 'Training', '2', '0', '2006-01-18', '2007-03-07');
+
+### Data of table `0_exchange_rates` ###
+
+INSERT INTO `0_exchange_rates` VALUES ('1', 'LE', '0.149', '0.149', '2006-01-18');
+INSERT INTO `0_exchange_rates` VALUES ('2', 'GBP', '1.2', '1.2', '2006-01-18');
+INSERT INTO `0_exchange_rates` VALUES ('3', 'SEK', '0.1667', '0.1667', '2007-01-29');
+INSERT INTO `0_exchange_rates` VALUES ('4', 'DKK', '0.2', '0.2', '2007-03-05');
+INSERT INTO `0_exchange_rates` VALUES ('5', 'EUR', '1.1', '1.1', '2007-03-05');
+INSERT INTO `0_exchange_rates` VALUES ('6', 'DKK', '0.20563796227935', '0.20563796227935', '2008-03-06');
+INSERT INTO `0_exchange_rates` VALUES ('7', 'EUR', '1.5561', '1.5561', '2008-03-15');
+INSERT INTO `0_exchange_rates` VALUES ('8', 'DKK', '0.20867920985932', '0.20867920985932', '2008-03-16');
+INSERT INTO `0_exchange_rates` VALUES ('9', 'GBP', '1.9816266221251', '1.9816266221251', '2008-03-24');
+INSERT INTO `0_exchange_rates` VALUES ('10', 'DKK', '0.20674817019223', '0.20674817019223', '2008-03-24');
+INSERT INTO `0_exchange_rates` VALUES ('11', 'EUR', '1.5569', '1.5569', '2008-03-25');
+INSERT INTO `0_exchange_rates` VALUES ('12', 'EUR', '1.5796', '1.5796', '2008-03-28');
+
+### Data of table `0_fiscal_year` ###
+
+INSERT INTO `0_fiscal_year` VALUES ('1', '2006-01-01', '2006-12-31', '0');
+INSERT INTO `0_fiscal_year` VALUES ('2', '2007-01-01', '2007-12-31', '0');
+INSERT INTO `0_fiscal_year` VALUES ('5', '2005-01-01', '2005-12-31', '1');
+INSERT INTO `0_fiscal_year` VALUES ('6', '2008-01-01', '2008-12-31', '0');
+
+### Data of table `0_gl_trans` ###
+
+INSERT INTO `0_gl_trans` VALUES ('1', '13', '1', '2008-03-06', '4010', '', '80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('2', '13', '1', '2008-03-06', '1420', '', '-80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('3', '10', '1', '2008-03-06', '3000', '', '-100', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('4', '10', '1', '2008-03-06', '1500', '', '135', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('5', '10', '1', '2008-03-06', '3800', '', '-8', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('6', '10', '1', '2008-03-06', '2664', '', '-27', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('7', '13', '2', '2008-03-06', '4010', '', '80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('8', '13', '2', '2008-03-06', '1420', '', '-80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('9', '10', '2', '2008-03-06', '3000', '', '-100', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('10', '10', '2', '2008-03-06', '1500', '', '135', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('11', '10', '2', '2008-03-06', '3800', '', '-8', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('12', '10', '2', '2008-03-06', '2664', '', '-27', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('13', '13', '3', '2008-03-06', '4010', '', '80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('14', '13', '3', '2008-03-06', '1420', '', '-80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('15', '10', '3', '2008-03-06', '3000', '', '-100', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('16', '10', '3', '2008-03-06', '1500', '', '135', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('17', '10', '3', '2008-03-06', '3800', '', '-8', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('18', '10', '3', '2008-03-06', '2664', '', '-27', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('19', '13', '4', '2008-03-06', '4010', '', '80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('20', '13', '4', '2008-03-06', '1420', '', '-80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('21', '10', '4', '2008-03-06', '3000', '', '-100', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('22', '10', '4', '2008-03-06', '1500', '', '135', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('23', '10', '4', '2008-03-06', '3800', '', '-8', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('24', '10', '4', '2008-03-06', '2664', '', '-27', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('25', '13', '5', '2008-03-06', '4010', '', '80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('26', '13', '5', '2008-03-06', '1420', '', '-80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('27', '10', '5', '2008-03-06', '3000', '', '-100', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('28', '10', '5', '2008-03-06', '1500', '', '135', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('29', '10', '5', '2008-03-06', '3800', '', '-8', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('30', '10', '5', '2008-03-06', '2664', '', '-27', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('31', '11', '1', '2008-03-06', '4010', '', '-80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('32', '11', '1', '2008-03-06', '1420', '', '80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('34', '11', '1', '2008-03-06', '1500', '', '-10', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('35', '11', '1', '2008-03-06', '3800', '', '8', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('36', '11', '1', '2008-03-06', '2664', '', '2', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('37', '13', '6', '2008-03-06', '4010', '', '80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('38', '13', '6', '2008-03-06', '1420', '', '-80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('39', '10', '6', '2008-03-06', '3000', '', '-100', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('40', '10', '6', '2008-03-06', '1500', '', '135', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('41', '10', '6', '2008-03-06', '3800', '', '-8', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('42', '10', '6', '2008-03-06', '2664', '', '-27', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('43', '13', '7', '2008-03-06', '4010', '', '80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('44', '13', '7', '2008-03-06', '1420', '', '-80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('45', '12', '7', '2008-03-06', '1700', '', '100', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('46', '12', '7', '2008-03-06', '1500', '', '-100', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('47', '12', '8', '2008-03-06', '1700', '', '100', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('48', '12', '8', '2008-03-06', '1500', '', '-100', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('49', '20', '7', '2008-03-06', '2630', '', '-550', '0', '0', '3', '1');
+INSERT INTO `0_gl_trans` VALUES ('50', '20', '7', '2008-03-06', '1420', '', '250', '0', '0', '3', '1');
+INSERT INTO `0_gl_trans` VALUES ('51', '20', '7', '2008-03-06', '1420', '', '300', '0', '0', '3', '1');
+INSERT INTO `0_gl_trans` VALUES ('52', '11', '2', '2008-03-06', '4010', '', '-80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('53', '11', '2', '2008-03-06', '1420', '', '80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('54', '11', '2', '2008-03-06', '3000', '', '125', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('55', '11', '2', '2008-03-06', '1500', '', '-135', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('56', '11', '2', '2008-03-06', '3800', '', '8', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('57', '11', '2', '2008-03-06', '2664', '', '2', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('58', '11', '3', '2008-03-06', '4010', '', '-80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('59', '11', '3', '2008-03-06', '1420', '', '80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('60', '11', '3', '2008-03-06', '3000', '', '100', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('61', '11', '3', '2008-03-06', '1500', '', '-135', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('62', '11', '3', '2008-03-06', '3800', '', '8', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('63', '11', '3', '2008-03-06', '2664', '', '27', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('64', '12', '9', '2008-03-07', '1700', '', '2000', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('65', '12', '9', '2008-03-07', '1500', '', '-2000', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('66', '11', '4', '2008-03-07', '3000', '', '100', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('67', '11', '4', '2008-03-07', '1500', '', '-125', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('68', '11', '4', '2008-03-07', '2664', '', '25', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('69', '26', '7', '2008-03-07', '1420', '', '-80', '0', '0', NULL, NULL);
+INSERT INTO `0_gl_trans` VALUES ('70', '26', '7', '2008-03-07', '1420', '', '-20', '0', '0', NULL, NULL);
+INSERT INTO `0_gl_trans` VALUES ('71', '26', '7', '2008-03-07', '1420', '', '-18', '0', '0', NULL, NULL);
+INSERT INTO `0_gl_trans` VALUES ('72', '26', '7', '2008-03-07', '1420', '', '118', '0', '0', NULL, NULL);
+INSERT INTO `0_gl_trans` VALUES ('73', '0', '18', '2008-03-07', '1400', '', '20', '0', '0', NULL, NULL);
+INSERT INTO `0_gl_trans` VALUES ('74', '0', '18', '2008-03-07', '3010', '', '-20', '0', '0', NULL, NULL);
+INSERT INTO `0_gl_trans` VALUES ('75', '13', '8', '2008-03-07', '4010', '', '80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('76', '13', '8', '2008-03-07', '1420', '', '-80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('77', '13', '9', '2008-03-08', '4010', '', '80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('78', '13', '9', '2008-03-08', '1420', '', '-80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('79', '10', '7', '2008-03-08', '3000', '', '-100', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('80', '10', '7', '2008-03-08', '1500', '', '135', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('81', '10', '7', '2008-03-08', '3800', '', '-8', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('82', '10', '7', '2008-03-08', '2664', '', '-27', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('83', '13', '10', '2008-03-09', '4010', '', '80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('84', '13', '10', '2008-03-09', '1420', '', '-80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('85', '10', '8', '2008-03-09', '3000', '', '-100', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('86', '10', '8', '2008-03-09', '1500', '', '137.5', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('87', '10', '8', '2008-03-09', '3800', '', '-10', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('88', '10', '8', '2008-03-09', '2664', '', '-27.5', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('89', '13', '11', '2008-03-09', '4010', '', '80', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('90', '13', '11', '2008-03-09', '1420', '', '-80', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('91', '10', '9', '2008-03-09', '3000', '', '-100', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('92', '10', '9', '2008-03-09', '1500', '', '137.5', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('93', '10', '9', '2008-03-09', '3800', '', '-10', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('94', '10', '9', '2008-03-09', '2664', '', '-27.5', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('95', '13', '12', '2008-03-09', '4010', '', '80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('96', '13', '12', '2008-03-09', '1420', '', '-80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('97', '10', '10', '2008-03-09', '3000', '', '-100', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('98', '10', '10', '2008-03-09', '1500', '', '135', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('99', '10', '10', '2008-03-09', '3800', '', '-8', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('100', '10', '10', '2008-03-09', '2664', '', '-27', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('103', '13', '13', '2008-03-10', '4010', '', '20', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('104', '13', '13', '2008-03-10', '1420', '', '-20', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('105', '13', '14', '2008-03-10', '4010', '', '80', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('106', '13', '14', '2008-03-10', '1420', '', '-80', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('107', '10', '11', '2008-03-10', '3000', '', '-100', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('108', '10', '11', '2008-03-10', '1500', '', '125', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('109', '10', '11', '2008-03-10', '2664', '', '-25', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('110', '13', '15', '2008-03-10', '4010', '', '80', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('111', '13', '15', '2008-03-10', '1420', '', '-80', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('112', '10', '12', '2008-03-10', '3000', '', '-100', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('113', '10', '12', '2008-03-10', '1500', '', '125', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('114', '10', '12', '2008-03-10', '2664', '', '-25', '0', '0', '2', '1');
+INSERT INTO `0_gl_trans` VALUES ('115', '10', '13', '2008-03-07', '3000', '', '-100', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('116', '10', '13', '2008-03-07', '1500', '', '135', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('117', '10', '13', '2008-03-07', '3800', '', '-8', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('118', '10', '13', '2008-03-07', '2664', '', '-27', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('119', '13', '16', '2008-03-10', '4010', '', '80', '0', '0', '2', '3');
+INSERT INTO `0_gl_trans` VALUES ('120', '13', '16', '2008-03-10', '1420', '', '-80', '0', '0', '2', '3');
+INSERT INTO `0_gl_trans` VALUES ('121', '13', '17', '2008-03-10', '4010', '', '80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('122', '13', '17', '2008-03-10', '1420', '', '-80', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('123', '10', '14', '2008-03-10', '3000', '', '-100', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('124', '10', '14', '2008-03-10', '1500', '', '135', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('125', '10', '14', '2008-03-10', '3800', '', '-8', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('126', '10', '14', '2008-03-10', '2664', '', '-27', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('127', '10', '15', '2008-03-10', '3000', '', '-32', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('128', '10', '15', '2008-03-10', '1500', '', '40', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('129', '10', '15', '2008-03-10', '2664', '', '-8', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('133', '20', '8', '2008-03-20', '2630', '', '0', '0', '0', '3', '2');
+INSERT INTO `0_gl_trans` VALUES ('134', '20', '8', '2008-03-20', '1420', '', '0', '0', '0', '3', '2');
+INSERT INTO `0_gl_trans` VALUES ('135', '20', '9', '2008-03-25', '2630', '', '-19.82', '0', '0', '3', '2');
+INSERT INTO `0_gl_trans` VALUES ('136', '20', '9', '2008-03-25', '1420', '', '19.82', '0', '0', '3', '2');
+INSERT INTO `0_gl_trans` VALUES ('149', '20', '10', '2008-03-25', '2630', '', '-40.48', '0', '0', '3', '4');
+INSERT INTO `0_gl_trans` VALUES ('150', '20', '10', '2008-03-25', '1420', '', '40.48', '0', '0', '3', '4');
+INSERT INTO `0_gl_trans` VALUES ('152', '20', '11', '2008-03-28', '2630', '', '-2618.19', '0', '0', '3', '4');
+INSERT INTO `0_gl_trans` VALUES ('153', '20', '11', '2008-03-28', '1420', '', '2094.55', '0', '0', '3', '4');
+INSERT INTO `0_gl_trans` VALUES ('154', '20', '11', '2008-03-28', '2682', '', '523.64', '0', '0', '3', '4');
+INSERT INTO `0_gl_trans` VALUES ('155', '13', '18', '2008-03-17', '4010', '', '5.0599509174312', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('156', '13', '18', '2008-03-17', '1420', '', '-5.0599509174312', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('157', '10', '16', '2008-03-17', '3000', '', '-100', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('158', '10', '16', '2008-03-17', '1500', '', '135', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('159', '10', '16', '2008-03-17', '3800', '', '-8', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('160', '10', '16', '2008-03-17', '2664', '', '-27', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('161', '10', '17', '2008-03-10', '3000', '', '-2.26', '0', '0', '2', '3');
+INSERT INTO `0_gl_trans` VALUES ('162', '10', '17', '2008-03-10', '1500', '', '2.26', '0', '0', '2', '3');
+INSERT INTO `0_gl_trans` VALUES ('163', '13', '19', '2008-03-29', '4010', '', '-3.4114285714283', '0', '0', '2', '3');
+INSERT INTO `0_gl_trans` VALUES ('164', '13', '19', '2008-03-29', '1420', '', '3.4114285714283', '0', '0', '2', '3');
+INSERT INTO `0_gl_trans` VALUES ('165', '13', '20', '2008-03-29', '4010', '', '-3.4114285714283', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('166', '13', '20', '2008-03-29', '1420', '', '3.4114285714283', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('167', '10', '19', '2008-03-29', '3000', '', '-100', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('168', '10', '19', '2008-03-29', '1500', '', '125', '0', '0', '2', '4');
+INSERT INTO `0_gl_trans` VALUES ('169', '10', '19', '2008-03-29', '2664', '', '-25', '0', '0', '2', '4');
+
+### Data of table `0_grn_batch` ###
+
+INSERT INTO `0_grn_batch` VALUES ('1', '1', '1', '1', '2006-01-18', 'DEF');
+INSERT INTO `0_grn_batch` VALUES ('2', '1', '2', '2', '2006-01-18', 'DEF');
+INSERT INTO `0_grn_batch` VALUES ('3', '1', '5', '3', '2006-01-18', 'DEF');
+INSERT INTO `0_grn_batch` VALUES ('4', '1', '6', '4', '2008-03-06', 'DEF');
+INSERT INTO `0_grn_batch` VALUES ('5', '4', '8', '5', '2008-03-17', 'DEF');
+INSERT INTO `0_grn_batch` VALUES ('6', '4', '8', '6', '2008-03-19', 'DEF');
+INSERT INTO `0_grn_batch` VALUES ('7', '2', '9', '7', '2008-03-20', 'DEF');
+INSERT INTO `0_grn_batch` VALUES ('8', '2', '10', '8', '2008-03-25', 'DEF');
+INSERT INTO `0_grn_batch` VALUES ('9', '4', '11', '9', '2008-03-25', 'DEF');
+INSERT INTO `0_grn_batch` VALUES ('10', '4', '13', '10', '2008-03-25', 'DEF');
+INSERT INTO `0_grn_batch` VALUES ('11', '4', '12', '11', '2008-03-25', 'DEF');
+INSERT INTO `0_grn_batch` VALUES ('12', '4', '13', '12', '2008-03-28', 'DEF');
+
+### Data of table `0_grn_items` ###
+
+INSERT INTO `0_grn_items` VALUES ('1', '1', '1', '102', '17 inch VGA Monitor', '10', '10');
+INSERT INTO `0_grn_items` VALUES ('2', '1', '2', '103', '32MB VGA Card', '50', '50');
+INSERT INTO `0_grn_items` VALUES ('3', '2', '3', '104', '52x CD Drive', '1', '1');
+INSERT INTO `0_grn_items` VALUES ('4', '3', '6', '104', '52x CD Drive (upgraded)', '3020', '302');
+INSERT INTO `0_grn_items` VALUES ('5', '4', '7', '102', '17 inch VGA Monitor', '10', '10');
+INSERT INTO `0_grn_items` VALUES ('6', '4', '8', '103', '32MB VGA Card', '10', '10');
+INSERT INTO `0_grn_items` VALUES ('7', '4', '9', '104', '52x CD Drive', '10', '0');
+INSERT INTO `0_grn_items` VALUES ('8', '4', '10', '202', 'Electric stimulator', '10', '0');
+INSERT INTO `0_grn_items` VALUES ('9', '5', '12', 'AA101', 'olie 5w40', '8', '8');
+INSERT INTO `0_grn_items` VALUES ('10', '6', '12', 'AA101', 'olie 5w40', '408', '408');
+INSERT INTO `0_grn_items` VALUES ('11', '7', '13', '102', '17 inch VGA Monitor', '5', '5');
+INSERT INTO `0_grn_items` VALUES ('12', '8', '14', '102', '17 inch VGA Monitor', '1', '1');
+INSERT INTO `0_grn_items` VALUES ('13', '9', '15', 'AA101', 'olie 5w40', '20', '0');
+INSERT INTO `0_grn_items` VALUES ('14', '10', '17', '102', '17 inch VGA Monitor', '5', '0');
+INSERT INTO `0_grn_items` VALUES ('15', '11', '16', '102', '17 inch VGA Monitor', '1', '0');
+INSERT INTO `0_grn_items` VALUES ('16', '12', '17', '102', '17 inch VGA Monitor', '5', '0');
+
+### Data of table `0_item_tax_type_exemptions` ###
+
+INSERT INTO `0_item_tax_type_exemptions` VALUES ('1', '1');
+INSERT INTO `0_item_tax_type_exemptions` VALUES ('1', '2');
+INSERT INTO `0_item_tax_type_exemptions` VALUES ('2', '2');
+INSERT INTO `0_item_tax_type_exemptions` VALUES ('2', '3');
+
+### Data of table `0_item_tax_types` ###
+
+INSERT INTO `0_item_tax_types` VALUES ('1', 'Regular', '0');
+INSERT INTO `0_item_tax_types` VALUES ('2', 'Recovery equipment', '0');
+
+### Data of table `0_item_units` ###
+
+INSERT INTO `0_item_units` VALUES ('each', 'each', '0');
+INSERT INTO `0_item_units` VALUES ('m', 'meters', '2');
+INSERT INTO `0_item_units` VALUES ('kgg', 'kilograms', '3');
+INSERT INTO `0_item_units` VALUES ('tons', 'tons', '2');
+INSERT INTO `0_item_units` VALUES ('lbs', 'pounds', '2');
+INSERT INTO `0_item_units` VALUES ('l', 'liters', '3');
+INSERT INTO `0_item_units` VALUES ('dozen', 'dozens', '0');
+INSERT INTO `0_item_units` VALUES ('pack', 'packs', '0');
+INSERT INTO `0_item_units` VALUES ('hrs', 'hours', '1');
+INSERT INTO `0_item_units` VALUES ('dz', 'dozijn', '0');
+
+### Data of table `0_loc_stock` ###
+
+INSERT INTO `0_loc_stock` VALUES ('CWA', '102', '0');
+INSERT INTO `0_loc_stock` VALUES ('CWA', '103', '0');
+INSERT INTO `0_loc_stock` VALUES ('CWA', '104', '0');
+INSERT INTO `0_loc_stock` VALUES ('CWA', '201', '0');
+INSERT INTO `0_loc_stock` VALUES ('CWA', '202', '0');
+INSERT INTO `0_loc_stock` VALUES ('CWA', '3400', '0');
+INSERT INTO `0_loc_stock` VALUES ('CWA', 'AA101', '0');
+INSERT INTO `0_loc_stock` VALUES ('DEF', '102', '0');
+INSERT INTO `0_loc_stock` VALUES ('DEF', '103', '0');
+INSERT INTO `0_loc_stock` VALUES ('DEF', '104', '0');
+INSERT INTO `0_loc_stock` VALUES ('DEF', '201', '0');
+INSERT INTO `0_loc_stock` VALUES ('DEF', '202', '0');
+INSERT INTO `0_loc_stock` VALUES ('DEF', '3400', '0');
+INSERT INTO `0_loc_stock` VALUES ('DEF', 'AA101', '0');
+
+### Data of table `0_locations` ###