-- MySQL dump of database 'en_US-demo' on host 'localhost'
--- Backup Date and Time: 2019-01-21 11:16
--- Built by FrontAccounting 2.4.6
+-- Backup Date and Time: 2020-01-21 11:16
+-- Built by FrontAccounting 2.4.7
-- http://frontaccounting.com
-- Company: Training Co.
-- User: Administrator
-- Data of table `0_audit_trail` --
INSERT INTO `0_audit_trail` VALUES
-('1', '18', '1', '1', '2018-05-05 14:08:02', NULL, '1', '2018-05-05', '0'),
-('2', '25', '1', '1', '2018-05-05 14:08:14', NULL, '1', '2018-05-05', '1'),
-('3', '30', '1', '1', '2018-05-05 14:09:54', NULL, '1', '2018-05-10', '0'),
-('4', '13', '1', '1', '2018-05-05 14:09:55', NULL, '1', '2018-05-10', '13'),
-('5', '10', '1', '1', '2018-05-05 14:09:55', NULL, '1', '2018-05-10', '14'),
-('6', '12', '1', '1', '2018-05-05 14:09:55', NULL, '1', '2018-05-10', '15'),
-('7', '29', '1', '1', '2018-05-05 14:18:49', 'Quick production.', '1', '2018-05-05', '2'),
-('8', '18', '2', '1', '2018-05-05 14:22:32', NULL, '1', '2018-05-05', '0'),
-('9', '25', '2', '1', '2018-05-05 14:22:32', NULL, '1', '2018-05-05', '3'),
-('10', '20', '1', '1', '2018-05-05 14:22:32', NULL, '1', '2018-05-05', '4'),
-('11', '30', '2', '1', '2018-05-07 07:55:15', NULL, '1', '2018-05-07', '0'),
-('12', '13', '2', '1', '2018-05-07 07:55:16', NULL, '1', '2018-05-07', '7'),
-('13', '10', '2', '1', '2018-05-07 07:55:16', NULL, '1', '2018-05-07', '8'),
-('14', '12', '2', '1', '2018-05-07 07:55:16', NULL, '1', '2018-05-07', '9'),
-('15', '30', '3', '1', '2018-05-07 08:08:24', NULL, '1', '2018-05-07', '0'),
-('16', '30', '4', '1', '2018-05-07 09:18:44', NULL, '1', '2018-05-07', '0'),
-('17', '30', '5', '1', '2018-05-07 11:42:41', NULL, '1', '2018-05-07', '0'),
-('18', '13', '3', '1', '2018-05-07 11:42:41', NULL, '1', '2018-05-07', '10'),
-('19', '10', '3', '1', '2018-05-07 11:42:41', NULL, '1', '2018-05-07', '11'),
-('20', '30', '6', '1', '2018-05-07 14:02:35', NULL, '1', '2018-05-07', '0'),
-('21', '30', '7', '1', '2018-05-07 14:05:38', NULL, '1', '2018-05-07', '0'),
-('22', '13', '4', '1', '2018-05-07 14:05:38', NULL, '1', '2018-05-07', '0'),
-('23', '10', '4', '1', '2018-05-07 14:05:38', NULL, '1', '2018-05-07', '0'),
-('24', '12', '3', '1', '2018-05-07 14:05:38', NULL, '1', '2018-05-07', '0'),
-('25', '26', '1', '1', '2018-05-07 15:59:34', NULL, '1', '2018-05-07', NULL),
-('26', '29', '1', '1', '2018-05-07 15:59:01', 'Production.', '1', '2018-05-07', '5'),
-('27', '26', '1', '1', '2018-05-07 15:59:34', 'Released.', '1', '2018-05-07', '6'),
-('28', '1', '1', '1', '2018-05-07 16:01:00', NULL, '1', '2018-05-07', '12'),
-('29', '30', '8', '1', '2019-01-21 11:13:06', NULL, '2', '2019-01-21', '0'),
-('30', '13', '5', '1', '2019-01-21 11:13:06', NULL, '2', '2019-01-21', '0'),
-('31', '10', '5', '1', '2019-01-21 11:13:06', NULL, '2', '2019-01-21', '0'),
-('32', '12', '4', '1', '2019-01-21 11:13:06', NULL, '2', '2019-01-21', '0'),
-('33', '18', '3', '1', '2019-01-21 11:14:14', NULL, '2', '2019-01-21', '0'),
-('34', '25', '3', '1', '2019-01-21 11:14:14', NULL, '2', '2019-01-21', '0'),
-('35', '20', '2', '1', '2019-01-21 11:14:14', NULL, '2', '2019-01-21', '0'),
-('36', '0', '1', '1', '2019-01-21 11:15:35', NULL, '1', '2018-12-31', '16');
+('1', '18', '1', '1', '2019-05-05 14:08:02', NULL, '1', '2019-05-05', '0'),
+('2', '25', '1', '1', '2019-05-05 14:08:14', NULL, '1', '2019-05-05', '1'),
+('3', '30', '1', '1', '2019-05-05 14:09:54', NULL, '1', '2019-05-10', '0'),
+('4', '13', '1', '1', '2019-05-05 14:09:55', NULL, '1', '2019-05-10', '13'),
+('5', '10', '1', '1', '2019-05-05 14:09:55', NULL, '1', '2019-05-10', '14'),
+('6', '12', '1', '1', '2019-05-05 14:09:55', NULL, '1', '2019-05-10', '15'),
+('7', '29', '1', '1', '2019-05-05 14:18:49', 'Quick production.', '1', '2019-05-05', '2'),
+('8', '18', '2', '1', '2019-05-05 14:22:32', NULL, '1', '2019-05-05', '0'),
+('9', '25', '2', '1', '2019-05-05 14:22:32', NULL, '1', '2019-05-05', '3'),
+('10', '20', '1', '1', '2019-05-05 14:22:32', NULL, '1', '2019-05-05', '4'),
+('11', '30', '2', '1', '2019-05-07 07:55:15', NULL, '1', '2019-05-07', '0'),
+('12', '13', '2', '1', '2019-05-07 07:55:16', NULL, '1', '2019-05-07', '7'),
+('13', '10', '2', '1', '2019-05-07 07:55:16', NULL, '1', '2019-05-07', '8'),
+('14', '12', '2', '1', '2019-05-07 07:55:16', NULL, '1', '2019-05-07', '9'),
+('15', '30', '3', '1', '2019-05-07 08:08:24', NULL, '1', '2019-05-07', '0'),
+('16', '30', '4', '1', '2019-05-07 09:18:44', NULL, '1', '2019-05-07', '0'),
+('17', '30', '5', '1', '2019-05-07 11:42:41', NULL, '1', '2019-05-07', '0'),
+('18', '13', '3', '1', '2019-05-07 11:42:41', NULL, '1', '2019-05-07', '10'),
+('19', '10', '3', '1', '2019-05-07 11:42:41', NULL, '1', '2019-05-07', '11'),
+('20', '30', '6', '1', '2019-05-07 14:02:35', NULL, '1', '2019-05-07', '0'),
+('21', '30', '7', '1', '2019-05-07 14:05:38', NULL, '1', '2019-05-07', '0'),
+('22', '13', '4', '1', '2019-05-07 14:05:38', NULL, '1', '2019-05-07', '0'),
+('23', '10', '4', '1', '2019-05-07 14:05:38', NULL, '1', '2019-05-07', '0'),
+('24', '12', '3', '1', '2019-05-07 14:05:38', NULL, '1', '2019-05-07', '0'),
+('25', '26', '1', '1', '2019-05-07 15:59:34', NULL, '1', '2019-05-07', NULL),
+('26', '29', '1', '1', '2019-05-07 15:59:01', 'Production.', '1', '2019-05-07', '5'),
+('27', '26', '1', '1', '2019-05-07 15:59:34', 'Released.', '1', '2019-05-07', '6'),
+('28', '1', '1', '1', '2019-05-07 16:01:00', NULL, '1', '2019-05-07', '12'),
+('29', '30', '8', '1', '2020-01-21 11:13:06', NULL, '2', '2020-01-21', '0'),
+('30', '13', '5', '1', '2020-01-21 11:13:06', NULL, '2', '2020-01-21', '0'),
+('31', '10', '5', '1', '2020-01-21 11:13:06', NULL, '2', '2020-01-21', '0'),
+('32', '12', '4', '1', '2020-01-21 11:13:06', NULL, '2', '2020-01-21', '0'),
+('33', '18', '3', '1', '2020-01-21 11:14:14', NULL, '2', '2020-01-21', '0'),
+('34', '25', '3', '1', '2020-01-21 11:14:14', NULL, '2', '2020-01-21', '0'),
+('35', '20', '2', '1', '2020-01-21 11:14:14', NULL, '2', '2020-01-21', '0'),
+('36', '0', '1', '1', '2020-01-21 11:15:35', NULL, '1', '2019-12-31', '16');
-- Structure of table `0_bank_accounts` --
`bank_account_name` varchar(60) NOT NULL DEFAULT '',
`bank_account_number` varchar(100) NOT NULL DEFAULT '',
`bank_name` varchar(60) NOT NULL DEFAULT '',
- `bank_address` tinytext COLLATE utf8_unicode_ci,
+ `bank_address` tinytext,
`bank_curr_code` char(3) NOT NULL DEFAULT '',
`dflt_curr_act` tinyint(1) NOT NULL DEFAULT '0',
`id` smallint(6) NOT NULL AUTO_INCREMENT,
-- Data of table `0_bank_trans` --
INSERT INTO `0_bank_trans` VALUES
-('1', '12', '1', '2', '001/2018', '2018-05-10', '6240', '0', '0', '2', '1', NULL),
-('2', '12', '2', '2', '002/2018', '2018-05-07', '300', '0', '0', '2', '1', NULL),
-('3', '12', '3', '2', '003/2018', '2018-05-07', '0', '0', '0', '2', '1', NULL),
-('4', '1', '1', '1', '001/2018', '2018-05-07', '-5', '0', '0', '0', 'Goods received', NULL),
-('5', '12', '4', '2', '001/2019', '2019-01-21', '1250', '0', '0', '2', '1', NULL);
+('1', '12', '1', '2', '001/2019', '2019-05-10', '6240', '0', '0', '2', '1', NULL),
+('2', '12', '2', '2', '002/2019', '2019-05-07', '300', '0', '0', '2', '1', NULL),
+('3', '12', '3', '2', '003/2019', '2019-05-07', '0', '0', '0', '2', '1', NULL),
+('4', '1', '1', '1', '001/2019', '2019-05-07', '-5', '0', '0', '0', 'Goods received', NULL),
+('5', '12', '4', '2', '001/2020', '2020-01-21', '1250', '0', '0', '2', '1', NULL);
-- Structure of table `0_bom` --
-- Data of table `0_budget_trans` --
-
-- Structure of table `0_chart_class` --
DROP TABLE IF EXISTS `0_chart_class`;
INSERT INTO `0_chart_types` VALUES
('1', 'Current Assets', '1', '', '0'),
-('10', 'Cost of Goods Sold', '4', '', '0'),
-('11', 'Payroll Expenses', '4', '', '0'),
-('12', 'General & Administrative expenses', '4', '', '0'),
('2', 'Inventory Assets', '1', '', '0'),
('3', 'Capital Assets', '1', '', '0'),
('4', 'Current Liabilities', '2', '', '0'),
('6', 'Share Capital', '2', '', '0'),
('7', 'Retained Earnings', '2', '', '0'),
('8', 'Sales Revenue', '3', '', '0'),
-('9', 'Other Revenue', '3', '', '0');
+('9', 'Other Revenue', '3', '', '0'),
+('10', 'Cost of Goods Sold', '4', '', '0'),
+('11', 'Payroll Expenses', '4', '', '0'),
+('12', 'General & Administrative expenses', '4', '', '0');
-- Structure of table `0_comments` --
`type` int(11) NOT NULL DEFAULT '0',
`id` int(11) NOT NULL DEFAULT '0',
`date_` date DEFAULT '0000-00-00',
- `memo_` tinytext COLLATE utf8_unicode_ci,
+ `memo_` tinytext,
KEY `type_and_id` (`type`,`id`)
) ENGINE=InnoDB ;
-- Data of table `0_comments` --
INSERT INTO `0_comments` VALUES
-('12', '1', '2018-05-10', 'Cash invoice 1'),
-('12', '2', '2018-05-07', 'Cash invoice 2'),
-('13', '4', '2018-05-07', 'Recurrent Invoice covers period 04/01/2018 - 04/07/2018.'),
-('10', '4', '2018-05-07', 'Recurrent Invoice covers period 04/01/2018 - 04/07/2018.'),
-('12', '3', '2018-05-07', 'Cash invoice 4'),
-('12', '4', '2019-01-21', 'Default #5'),
-('0', '1', '2018-12-31', 'Closing Year');
+('12', '1', '2019-05-10', 'Cash invoice 1'),
+('12', '2', '2019-05-07', 'Cash invoice 2'),
+('13', '4', '2019-05-07', 'Recurrent Invoice covers period 04/01/2019 - 04/07/2019.'),
+('10', '4', '2019-05-07', 'Recurrent Invoice covers period 04/01/2019 - 04/07/2019.'),
+('12', '3', '2019-05-07', 'Cash invoice 4'),
+('12', '4', '2020-01-21', 'Default #5'),
+('0', '1', '2019-12-31', 'Closing Year');
-- Structure of table `0_credit_status` --
`ref` varchar(30) NOT NULL,
`name` varchar(60) NOT NULL,
`name2` varchar(60) DEFAULT NULL,
- `address` tinytext COLLATE utf8_unicode_ci,
+ `address` tinytext,
`phone` varchar(30) DEFAULT NULL,
`phone2` varchar(30) DEFAULT NULL,
`fax` varchar(30) DEFAULT NULL,
-- Data of table `0_cust_allocations` --
INSERT INTO `0_cust_allocations` VALUES
-('1', '1', '6240', '2018-05-10', '1', '12', '1', '10'),
-('2', '1', '300', '2018-05-07', '2', '12', '2', '10'),
-('3', '1', '0', '2018-05-07', '3', '12', '4', '10'),
-('4', '1', '1250', '2019-01-21', '4', '12', '5', '10');
+('1', '1', '6240', '2019-05-10', '1', '12', '1', '10'),
+('2', '1', '300', '2019-05-07', '2', '12', '2', '10'),
+('3', '1', '0', '2019-05-07', '3', '12', '4', '10'),
+('4', '1', '1250', '2020-01-21', '4', '12', '5', '10');
-- Structure of table `0_cust_branch` --
-- Data of table `0_debtor_trans` --
INSERT INTO `0_debtor_trans` VALUES
-('1', '10', '0', '1', '1', '2018-05-10', '2018-05-05', '001/2018', '1', '1', '6240', '0', '0', '0', '0', '6240', '0', '1', '1', '0', '0', '4', '1'),
-('2', '10', '0', '1', '1', '2018-05-07', '2018-05-07', '002/2018', '1', '2', '300', '0', '0', '0', '0', '300', '0', '1', '1', '0', '0', '4', '1'),
-('3', '10', '0', '2', '2', '2018-05-07', '2018-06-17', '003/2018', '1', '5', '267.14', '0', '0', '0', '0', '0', '0', '1.123', '1', '1', '0', '1', '1'),
-('4', '10', '0', '1', '1', '2018-05-07', '2018-05-07', '004/2018', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
-('5', '10', '0', '1', '1', '2019-01-21', '2019-01-21', '001/2019', '1', '8', '1250', '0', '0', '0', '0', '1250', '0', '1', '1', '0', '0', '4', '1'),
-('1', '12', '0', '1', '1', '2018-05-10', '0000-00-00', '001/2018', '0', '0', '6240', '0', '0', '0', '0', '6240', '0', '1', '0', '0', '0', NULL, '0'),
-('2', '12', '0', '1', '1', '2018-05-07', '0000-00-00', '002/2018', '0', '0', '300', '0', '0', '0', '0', '300', '0', '1', '0', '0', '0', NULL, '0'),
-('3', '12', '0', '1', '1', '2018-05-07', '0000-00-00', '003/2018', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', NULL, '0'),
-('4', '12', '0', '1', '1', '2019-01-21', '0000-00-00', '001/2019', '0', '0', '1250', '0', '0', '0', '0', '1250', '0', '1', '0', '0', '0', NULL, '0'),
-('1', '13', '1', '1', '1', '2018-05-10', '2018-05-05', 'auto', '1', '1', '6240', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
-('2', '13', '1', '1', '1', '2018-05-07', '2018-05-07', 'auto', '1', '2', '300', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
-('3', '13', '1', '2', '2', '2018-05-07', '2018-06-17', 'auto', '1', '5', '267.14', '0', '0', '0', '0', '0', '0', '1.123', '1', '1', '0', '1', '1'),
-('4', '13', '1', '1', '1', '2018-05-07', '2018-05-07', 'auto', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
-('5', '13', '1', '1', '1', '2019-01-21', '2019-01-21', 'auto', '1', '8', '1250', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1');
+('1', '10', '0', '1', '1', '2019-05-10', '2019-05-05', '001/2019', '1', '1', '6240', '0', '0', '0', '0', '6240', '0', '1', '1', '0', '0', '4', '1'),
+('2', '10', '0', '1', '1', '2019-05-07', '2019-05-07', '002/2019', '1', '2', '300', '0', '0', '0', '0', '300', '0', '1', '1', '0', '0', '4', '1'),
+('3', '10', '0', '2', '2', '2019-05-07', '2019-06-17', '003/2019', '1', '5', '267.14', '0', '0', '0', '0', '0', '0', '1.123', '1', '1', '0', '1', '1'),
+('4', '10', '0', '1', '1', '2019-05-07', '2019-05-07', '004/2019', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
+('5', '10', '0', '1', '1', '2020-01-21', '2020-01-21', '001/2020', '1', '8', '1250', '0', '0', '0', '0', '1250', '0', '1', '1', '0', '0', '4', '1'),
+('1', '12', '0', '1', '1', '2019-05-10', '0000-00-00', '001/2019', '0', '0', '6240', '0', '0', '0', '0', '6240', '0', '1', '0', '0', '0', NULL, '0'),
+('2', '12', '0', '1', '1', '2019-05-07', '0000-00-00', '002/2019', '0', '0', '300', '0', '0', '0', '0', '300', '0', '1', '0', '0', '0', NULL, '0'),
+('3', '12', '0', '1', '1', '2019-05-07', '0000-00-00', '003/2019', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', NULL, '0'),
+('4', '12', '0', '1', '1', '2020-01-21', '0000-00-00', '001/2020', '0', '0', '1250', '0', '0', '0', '0', '1250', '0', '1', '0', '0', '0', NULL, '0'),
+('1', '13', '1', '1', '1', '2019-05-10', '2019-05-05', 'auto', '1', '1', '6240', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
+('2', '13', '1', '1', '1', '2019-05-07', '2019-05-07', 'auto', '1', '2', '300', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
+('3', '13', '1', '2', '2', '2019-05-07', '2019-06-17', 'auto', '1', '5', '267.14', '0', '0', '0', '0', '0', '0', '1.123', '1', '1', '0', '1', '1'),
+('4', '13', '1', '1', '1', '2019-05-07', '2019-05-07', 'auto', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
+('5', '13', '1', '1', '1', '2020-01-21', '2020-01-21', 'auto', '1', '8', '1250', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1');
-- Structure of table `0_debtor_trans_details` --
`debtor_trans_no` int(11) DEFAULT NULL,
`debtor_trans_type` int(11) DEFAULT NULL,
`stock_id` varchar(20) NOT NULL DEFAULT '',
- `description` tinytext COLLATE utf8_unicode_ci,
+ `description` tinytext,
`unit_price` double NOT NULL DEFAULT '0',
`unit_tax` double NOT NULL DEFAULT '0',
`quantity` double NOT NULL DEFAULT '0',
`debtor_no` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL DEFAULT '',
`debtor_ref` varchar(30) NOT NULL,
- `address` tinytext COLLATE utf8_unicode_ci,
+ `address` tinytext,
`tax_id` varchar(55) NOT NULL DEFAULT '',
`curr_code` char(3) NOT NULL DEFAULT '',
`sales_type` int(11) NOT NULL DEFAULT '1',
-- Data of table `0_dimensions` --
INSERT INTO `0_dimensions` VALUES
-('1', '001/2018', 'Cost Centre', '1', '0', '2018-05-05', '2018-05-25');
+('1', '001/2019', 'Cost Centre', '1', '0', '2019-05-05', '2019-05-25');
-- Structure of table `0_exchange_rates` --
-- Data of table `0_exchange_rates` --
INSERT INTO `0_exchange_rates` VALUES
-('1', 'EUR', '1.123', '1.123', '2018-05-07');
+('1', 'EUR', '1.123', '1.123', '2019-05-07');
-- Structure of table `0_fiscal_year` --
-- Data of table `0_fiscal_year` --
INSERT INTO `0_fiscal_year` VALUES
-('1', '2018-01-01', '2018-12-31', '1'),
-('2', '2019-01-01', '2019-12-31', '0');
+('1', '2019-01-01', '2019-12-31', '1'),
+('2', '2020-01-01', '2020-12-31', '0');
-- Structure of table `0_gl_trans` --
-- Data of table `0_gl_trans` --
INSERT INTO `0_gl_trans` VALUES
-('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);
+('1', '25', '1', '2019-05-05', '1510', '101', '20000', '0', '0', NULL, NULL),
+('2', '25', '1', '2019-05-05', '1510', '102', '15000', '0', '0', NULL, NULL),
+('3', '25', '1', '2019-05-05', '1510', '103', '1000', '0', '0', NULL, NULL),
+('4', '25', '1', '2019-05-05', '1550', '', '-36000', '0', '0', NULL, NULL),
+('5', '13', '1', '2019-05-10', '5010', '', '4000', '0', '0', NULL, NULL),
+('6', '13', '1', '2019-05-10', '1510', '', '-4000', '0', '0', NULL, NULL),
+('7', '10', '1', '2019-05-10', '4010', '', '-5714.29', '0', '0', NULL, NULL),
+('8', '10', '1', '2019-05-10', '4010', '', '-228.57', '0', '0', NULL, NULL),
+('9', '10', '1', '2019-05-10', '1200', '', '6240', '0', '0', '2', '1'),
+('10', '10', '1', '2019-05-10', '2150', '', '-297.14', '0', '0', NULL, NULL),
+('11', '12', '1', '2019-05-10', '1065', '', '6240', '0', '0', NULL, NULL),
+('12', '12', '1', '2019-05-10', '1200', '', '-6240', '0', '0', '2', '1'),
+('13', '29', '1', '2019-05-05', '1510', '1 * iPad Air 2 16GB', '-400', '0', '0', NULL, NULL),
+('14', '29', '1', '2019-05-05', '1510', '1 * iPhone 6 64GB', '-300', '0', '0', NULL, NULL),
+('15', '29', '1', '2019-05-05', '1510', '1 * iPhone Cover Case', '-20', '0', '0', NULL, NULL),
+('16', '29', '1', '2019-05-05', '1530', '1 * Support', '720', '0', '0', NULL, NULL),
+('17', '26', '1', '2019-05-05', '1530', '', '-720', '0', '0', NULL, NULL),
+('18', '26', '1', '2019-05-05', '1510', '', '720', '0', '0', NULL, NULL),
+('19', '25', '2', '2019-05-05', '1510', '101', '3000', '0', '0', NULL, NULL),
+('20', '25', '2', '2019-05-05', '1550', '', '-3000', '0', '0', NULL, NULL),
+('21', '20', '1', '2019-05-05', '2150', '', '150', '0', '0', NULL, NULL),
+('22', '20', '1', '2019-05-05', '2100', '', '-3150', '0', '0', '3', '1'),
+('23', '20', '1', '2019-05-05', '1550', '', '3000', '0', '0', NULL, NULL),
+('24', '13', '2', '2019-05-07', '5010', '', '200', '0', '0', NULL, NULL),
+('25', '13', '2', '2019-05-07', '1510', '', '-200', '0', '0', NULL, NULL),
+('26', '10', '2', '2019-05-07', '4010', '', '-285.71', '0', '0', NULL, NULL),
+('27', '10', '2', '2019-05-07', '1200', '', '300', '0', '0', '2', '1'),
+('28', '10', '2', '2019-05-07', '2150', '', '-14.29', '0', '0', NULL, NULL),
+('29', '12', '2', '2019-05-07', '1065', '', '300', '0', '0', NULL, NULL),
+('30', '12', '2', '2019-05-07', '1200', '', '-300', '0', '0', '2', '1'),
+('31', '13', '3', '2019-05-07', '5010', '', '150', '1', '0', NULL, NULL),
+('32', '13', '3', '2019-05-07', '1510', '', '-150', '0', '0', NULL, NULL),
+('33', '13', '3', '2019-05-07', '5010', '', '10', '1', '0', NULL, NULL),
+('34', '13', '3', '2019-05-07', '1510', '', '-10', '0', '0', NULL, NULL),
+('35', '10', '3', '2019-05-07', '4010', '', '-250', '1', '0', NULL, NULL),
+('36', '10', '3', '2019-05-07', '4010', '', '-50', '1', '0', NULL, NULL),
+('37', '10', '3', '2019-05-07', '1200', '', '300', '0', '0', '2', '2'),
+('38', '12', '3', '2019-05-07', '1065', '', '0', '0', '0', NULL, NULL),
+('39', '1', '1', '2019-05-07', '5010', '', '5', '1', '0', NULL, NULL),
+('40', '1', '1', '2019-05-07', '1060', '', '-5', '0', '0', NULL, NULL),
+('41', '13', '5', '2020-01-21', '5010', '', '750', '0', '0', NULL, NULL),
+('42', '13', '5', '2020-01-21', '1510', '', '-750', '0', '0', NULL, NULL),
+('43', '10', '5', '2020-01-21', '4010', '', '-1190.48', '0', '0', NULL, NULL),
+('44', '10', '5', '2020-01-21', '1200', '', '1250', '0', '0', '2', '1'),
+('45', '10', '5', '2020-01-21', '2150', '', '-59.52', '0', '0', NULL, NULL),
+('46', '12', '4', '2020-01-21', '1065', '', '1250', '0', '0', NULL, NULL),
+('47', '12', '4', '2020-01-21', '1200', '', '-1250', '0', '0', '2', '1'),
+('48', '25', '3', '2020-01-21', '1510', '102', '900', '0', '0', NULL, NULL),
+('49', '25', '3', '2020-01-21', '1550', '', '-900', '0', '0', NULL, NULL),
+('50', '20', '2', '2020-01-21', '2150', '', '45', '0', '0', NULL, NULL),
+('51', '20', '2', '2020-01-21', '2100', '', '-945', '0', '0', '3', '1'),
+('52', '20', '2', '2020-01-21', '1550', '', '900', '0', '0', NULL, NULL),
+('53', '0', '1', '2019-12-31', '3590', 'Closing Year', '-2163.57', '0', '0', NULL, NULL),
+('54', '0', '1', '2019-12-31', '9990', 'Closing Year', '2163.57', '0', '0', NULL, NULL);
-- Structure of table `0_grn_batch` --
-- Data of table `0_grn_batch` --
INSERT INTO `0_grn_batch` VALUES
-('1', '1', '1', '001/2018', '2018-05-05', 'DEF', '1'),
-('2', '1', '2', 'auto', '2018-05-05', 'DEF', '1'),
-('3', '1', '3', 'auto', '2019-01-21', 'DEF', '1');
+('1', '1', '1', '001/2019', '2019-05-05', 'DEF', '1'),
+('2', '1', '2', 'auto', '2019-05-05', 'DEF', '1'),
+('3', '1', '3', 'auto', '2020-01-21', 'DEF', '1');
-- Structure of table `0_grn_items` --
`grn_batch_id` int(11) DEFAULT NULL,
`po_detail_item` int(11) NOT NULL DEFAULT '0',
`item_code` varchar(20) NOT NULL DEFAULT '',
- `description` tinytext COLLATE utf8_unicode_ci,
+ `description` tinytext,
`qty_recd` double NOT NULL DEFAULT '0',
`quantity_inv` double NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
-- Data of table `0_item_tax_type_exemptions` --
-
-- Structure of table `0_item_tax_types` --
DROP TABLE IF EXISTS `0_item_tax_types`;
-- Data of table `0_journal` --
INSERT INTO `0_journal` VALUES
-('0', '1', '2018-12-31', '001/2012', '', '2018-12-31', '2018-12-31', 'USD', '2163.57', '1');
+('0', '1', '2019-12-31', '001/2012', '', '2019-12-31', '2019-12-31', 'USD', '2163.57', '1');
-- Structure of table `0_loc_stock` --
`po_detail_item` int(11) NOT NULL AUTO_INCREMENT,
`order_no` int(11) NOT NULL DEFAULT '0',
`item_code` varchar(20) NOT NULL DEFAULT '',
- `description` tinytext COLLATE utf8_unicode_ci,
+ `description` tinytext,
`delivery_date` date NOT NULL DEFAULT '0000-00-00',
`qty_invoiced` double NOT NULL DEFAULT '0',
`unit_price` double NOT NULL DEFAULT '0',
-- Data of table `0_purch_order_details` --
INSERT INTO `0_purch_order_details` VALUES
-('1', '1', '101', 'iPad Air 2 16GB', '2018-05-15', '0', '200', '200', '200', '100', '100'),
-('2', '1', '102', 'iPhone 6 64GB', '2018-05-15', '0', '150', '150', '150', '100', '100'),
-('3', '1', '103', 'iPhone Cover Case', '2018-05-15', '0', '10', '10', '10', '100', '100'),
-('4', '2', '101', 'iPad Air 2 16GB', '2018-05-05', '15', '200', '200', '200', '15', '15'),
-('5', '3', '102', 'iPhone 6 64GB', '2019-01-21', '6', '150', '150', '150', '6', '6');
+('1', '1', '101', 'iPad Air 2 16GB', '2019-05-15', '0', '200', '200', '200', '100', '100'),
+('2', '1', '102', 'iPhone 6 64GB', '2019-05-15', '0', '150', '150', '150', '100', '100'),
+('3', '1', '103', 'iPhone Cover Case', '2019-05-15', '0', '10', '10', '10', '100', '100'),
+('4', '2', '101', 'iPad Air 2 16GB', '2019-05-05', '15', '200', '200', '200', '15', '15'),
+('5', '3', '102', 'iPhone 6 64GB', '2020-01-21', '6', '150', '150', '150', '6', '6');
-- Structure of table `0_purch_orders` --
CREATE TABLE `0_purch_orders` (
`order_no` int(11) NOT NULL AUTO_INCREMENT,
`supplier_id` int(11) NOT NULL DEFAULT '0',
- `comments` tinytext COLLATE utf8_unicode_ci,
+ `comments` tinytext,
`ord_date` date NOT NULL DEFAULT '0000-00-00',
`reference` tinytext NOT NULL,
- `requisition_no` tinytext COLLATE utf8_unicode_ci,
+ `requisition_no` tinytext,
`into_stock_location` varchar(5) NOT NULL DEFAULT '',
`delivery_address` tinytext NOT NULL,
`total` double NOT NULL DEFAULT '0',
-- Data of table `0_purch_orders` --
INSERT INTO `0_purch_orders` VALUES
-('1', '1', NULL, '2018-05-05', '001/2018', NULL, 'DEF', 'N/A', '37800', '0', '0', '0'),
-('2', '1', NULL, '2018-05-05', 'auto', 'rr4', 'DEF', 'N/A', '3150', '0', '0', '0'),
-('3', '1', NULL, '2019-01-21', 'auto', 'asd5', 'DEF', 'N/A', '945', '0', '0', '0');
+('1', '1', NULL, '2019-05-05', '001/2019', NULL, 'DEF', 'N/A', '37800', '0', '0', '0'),
+('2', '1', NULL, '2019-05-05', 'auto', 'rr4', 'DEF', 'N/A', '3150', '0', '0', '0'),
+('3', '1', NULL, '2020-01-21', 'auto', 'asd5', 'DEF', 'N/A', '945', '0', '0', '0');
-- Structure of table `0_quick_entries` --
-- Data of table `0_recurrent_invoices` --
INSERT INTO `0_recurrent_invoices` VALUES
-('1', 'Weekly Maintenance', '6', '1', '1', '7', '0', '2018-04-01', '2020-05-07', '2018-04-08');
+('1', 'Weekly Maintenance', '6', '1', '1', '7', '0', '2019-04-01', '2020-05-07', '2019-04-08');
-- Structure of table `0_reflines` --
-- Data of table `0_refs` --
INSERT INTO `0_refs` VALUES
-('1', '0', '001/2012'),
-('1', '1', '001/2018'),
-('1', '10', '001/2018'),
-('5', '10', '001/2019'),
-('2', '10', '002/2018'),
-('3', '10', '003/2018'),
-('4', '10', '004/2018'),
-('1', '12', '001/2018'),
-('4', '12', '001/2019'),
-('2', '12', '002/2018'),
-('3', '12', '003/2018'),
-('1', '18', '001/2018'),
-('1', '20', '001/2018'),
-('2', '20', '001/2019'),
-('1', '25', '001/2018'),
-('1', '26', '001/2018'),
-('2', '26', '002/2018'),
-('3', '26', '003/2018'),
-('3', '30', '001/2018'),
-('4', '30', '002/2018'),
-('6', '30', '003/2018'),
-('1', '40', '001/2018');
+('1', '1', '001/2019'),
+('1', '10', '001/2019'),
+('5', '10', '001/2020'),
+('2', '10', '002/2019'),
+('3', '10', '003/2019'),
+('4', '10', '004/2019'),
+('1', '12', '001/2019'),
+('4', '12', '001/2020'),
+('2', '12', '002/2019'),
+('3', '12', '003/2019'),
+('1', '18', '001/2019'),
+('1', '20', '001/2019'),
+('2', '20', '001/2020'),
+('1', '25', '001/2019'),
+('1', '26', '001/2019'),
+('2', '26', '002/2019'),
+('3', '26', '003/2019'),
+('3', '30', '001/2019'),
+('4', '30', '002/2019'),
+('6', '30', '003/2019'),
+('1', '40', '001/2019');
-- Structure of table `0_sales_order_details` --
`order_no` int(11) NOT NULL DEFAULT '0',
`trans_type` smallint(6) NOT NULL DEFAULT '30',
`stk_code` varchar(20) NOT NULL DEFAULT '',
- `description` tinytext COLLATE utf8_unicode_ci,
+ `description` tinytext,
`qty_sent` double NOT NULL DEFAULT '0',
`unit_price` double NOT NULL DEFAULT '0',
`quantity` double NOT NULL DEFAULT '0',
`branch_code` int(11) NOT NULL DEFAULT '0',
`reference` varchar(100) NOT NULL DEFAULT '',
`customer_ref` tinytext NOT NULL,
- `comments` tinytext COLLATE utf8_unicode_ci,
+ `comments` tinytext,
`ord_date` date NOT NULL DEFAULT '0000-00-00',
`order_type` int(11) NOT NULL DEFAULT '0',
`ship_via` int(11) NOT NULL DEFAULT '0',
`prep_amount` double NOT NULL DEFAULT '0',
`alloc` double NOT NULL DEFAULT '0',
PRIMARY KEY (`trans_type`,`order_no`)
-) ENGINE=InnoDB ;
+) ENGINE=InnoDB;
-- Data of table `0_sales_orders` --
INSERT INTO `0_sales_orders` VALUES
-('1', '30', '1', '0', '1', '1', 'auto', '', NULL, '2018-05-10', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2018-05-05', '4', '6240', '0', '0'),
-('2', '30', '1', '0', '1', '1', 'auto', '', NULL, '2018-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2018-05-07', '4', '300', '0', '0'),
-('3', '30', '0', '0', '1', '1', '001/2018', '', NULL, '2018-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2018-05-08', '4', '300', '0', '0'),
-('4', '30', '0', '0', '2', '2', '002/2018', '', NULL, '2018-05-07', '1', '1', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2018-05-08', '1', '267.14', '0', '0'),
-('5', '30', '1', '0', '2', '2', 'auto', '', NULL, '2018-05-07', '1', '1', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2018-06-17', '1', '267.14', '0', '0'),
-('6', '30', '0', '1', '1', '1', '003/2018', '', NULL, '2018-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2018-05-08', '4', '450', '0', '0'),
-('7', '30', '1', '0', '1', '1', 'auto', '', 'Recurrent Invoice covers period 04/01/2018 - 04/07/2018.', '2018-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2018-05-07', '4', '0', '0', '0'),
-('8', '30', '1', '0', '1', '1', 'auto', '', NULL, '2019-01-21', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2019-01-21', '4', '1250', '0', '0');
+('1', '30', '1', '0', '1', '1', 'auto', '', NULL, '2019-05-10', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2019-05-05', '4', '6240', '0', '0'),
+('2', '30', '1', '0', '1', '1', 'auto', '', NULL, '2019-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2019-05-07', '4', '300', '0', '0'),
+('3', '30', '0', '0', '1', '1', '001/2019', '', NULL, '2019-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2019-05-08', '4', '300', '0', '0'),
+('4', '30', '0', '0', '2', '2', '002/2019', '', NULL, '2019-05-07', '1', '1', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2019-05-08', '1', '267.14', '0', '0'),
+('5', '30', '1', '0', '2', '2', 'auto', '', NULL, '2019-05-07', '1', '1', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2019-06-17', '1', '267.14', '0', '0'),
+('6', '30', '0', '1', '1', '1', '003/2019', '', NULL, '2019-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2019-05-08', '4', '450', '0', '0'),
+('7', '30', '1', '0', '1', '1', 'auto', '', 'Recurrent Invoice covers period 04/01/2019 - 04/07/2019.', '2019-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2019-05-07', '4', '0', '0', '0'),
+('8', '30', '1', '0', '1', '1', 'auto', '', NULL, '2020-01-21', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2020-01-21', '4', '1250', '0', '0');
-- Structure of table `0_sales_pos` --
`id` int(11) NOT NULL AUTO_INCREMENT,
`role` varchar(30) NOT NULL,
`description` varchar(50) DEFAULT NULL,
- `sections` text COLLATE utf8_unicode_ci,
- `areas` text COLLATE utf8_unicode_ci,
+ `sections` text,
+ `areas` text,
`inactive` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `role` (`role`)
-- Data of table `0_stock_fa_class` --
-
-- Structure of table `0_stock_master` --
DROP TABLE IF EXISTS `0_stock_master`;
-- Data of table `0_stock_moves` --
INSERT INTO `0_stock_moves` VALUES
-('1', '1', '101', '25', 'DEF', '2018-05-05', '200', '', '100', '200'),
-('2', '1', '102', '25', 'DEF', '2018-05-05', '150', '', '100', '150'),
-('3', '1', '103', '25', 'DEF', '2018-05-05', '10', '', '100', '10'),
-('4', '1', '101', '13', 'DEF', '2018-05-10', '300', 'auto', '-20', '200'),
-('5', '1', '301', '13', 'DEF', '2018-05-10', '80', 'auto', '-3', '0'),
-('6', '1', '101', '29', 'DEF', '2018-05-05', '200', '001/2018', '-2', '200'),
-('7', '1', '102', '29', 'DEF', '2018-05-05', '150', '001/2018', '-2', '150'),
-('8', '1', '103', '29', 'DEF', '2018-05-05', '10', '001/2018', '-2', '10'),
-('9', '1', '301', '29', 'DEF', '2018-05-05', '0', '001/2018', '-2', '0'),
-('10', '1', '201', '26', 'DEF', '2018-05-05', '0', '001/2018', '2', '360'),
-('11', '2', '101', '25', 'DEF', '2018-05-05', '200', '', '15', '200'),
-('12', '2', '101', '13', 'DEF', '2018-05-07', '300', 'auto', '-1', '200'),
-('13', '3', '102', '13', 'DEF', '2018-05-07', '222.62', 'auto', '-1', '150'),
-('14', '3', '103', '13', 'DEF', '2018-05-07', '44.52', 'auto', '-1', '10'),
-('15', '4', '202', '13', 'DEF', '2018-05-07', '0', 'auto', '-5', '0'),
-('16', '5', '102', '13', 'DEF', '2019-01-21', '250', 'auto', '-5', '150'),
-('17', '3', '102', '25', 'DEF', '2019-01-21', '150', '', '6', '150');
+('1', '1', '101', '25', 'DEF', '2019-05-05', '200', '', '100', '200'),
+('2', '1', '102', '25', 'DEF', '2019-05-05', '150', '', '100', '150'),
+('3', '1', '103', '25', 'DEF', '2019-05-05', '10', '', '100', '10'),
+('4', '1', '101', '13', 'DEF', '2019-05-10', '300', 'auto', '-20', '200'),
+('5', '1', '301', '13', 'DEF', '2019-05-10', '80', 'auto', '-3', '0'),
+('6', '1', '101', '29', 'DEF', '2019-05-05', '200', '001/2019', '-2', '200'),
+('7', '1', '102', '29', 'DEF', '2019-05-05', '150', '001/2019', '-2', '150'),
+('8', '1', '103', '29', 'DEF', '2019-05-05', '10', '001/2019', '-2', '10'),
+('9', '1', '301', '29', 'DEF', '2019-05-05', '0', '001/2019', '-2', '0'),
+('10', '1', '201', '26', 'DEF', '2019-05-05', '0', '001/2019', '2', '360'),
+('11', '2', '101', '25', 'DEF', '2019-05-05', '200', '', '15', '200'),
+('12', '2', '101', '13', 'DEF', '2019-05-07', '300', 'auto', '-1', '200'),
+('13', '3', '102', '13', 'DEF', '2019-05-07', '222.62', 'auto', '-1', '150'),
+('14', '3', '103', '13', 'DEF', '2019-05-07', '44.52', 'auto', '-1', '10'),
+('15', '4', '202', '13', 'DEF', '2019-05-07', '0', 'auto', '-5', '0'),
+('16', '5', '102', '13', 'DEF', '2020-01-21', '250', 'auto', '-5', '150'),
+('17', '3', '102', '25', 'DEF', '2020-01-21', '150', '', '6', '150');
-- Structure of table `0_supp_allocations` --
-- Data of table `0_supp_allocations` --
-
-- Structure of table `0_supp_invoice_items` --
DROP TABLE IF EXISTS `0_supp_invoice_items`;
`grn_item_id` int(11) DEFAULT NULL,
`po_detail_item_id` int(11) DEFAULT NULL,
`stock_id` varchar(20) NOT NULL DEFAULT '',
- `description` tinytext COLLATE utf8_unicode_ci,
+ `description` tinytext,
`quantity` double NOT NULL DEFAULT '0',
`unit_price` double NOT NULL DEFAULT '0',
`unit_tax` double NOT NULL DEFAULT '0',
- `memo_` tinytext COLLATE utf8_unicode_ci,
+ `memo_` tinytext,
`dimension_id` int(11) NOT NULL DEFAULT '0',
`dimension2_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
-- Data of table `0_supp_trans` --
INSERT INTO `0_supp_trans` VALUES
-('1', '20', '1', '001/2018', 'rr4', '2018-05-05', '2018-05-15', '3000', '0', '150', '1', '0', '0'),
-('2', '20', '1', '001/2019', 'asd5', '2019-01-21', '2019-01-31', '900', '0', '45', '1', '0', '0');
+('1', '20', '1', '001/2019', 'rr4', '2019-05-05', '2019-05-15', '3000', '0', '150', '1', '0', '0'),
+('2', '20', '1', '001/2020', 'asd5', '2020-01-21', '2020-01-31', '900', '0', '45', '1', '0', '0');
-- Structure of table `0_suppliers` --
-- Data of table `0_sys_prefs` --
INSERT INTO `0_sys_prefs` VALUES
-('coy_name', 'setup.company', 'varchar', '60', 'Training Co'),
-('gst_no', 'setup.company', 'varchar', '25', '33445566'),
-('accounts_alpha', 'glsetup.general', 'tinyint', '1', '0'),
-('accumulate_shipping', 'glsetup.customer', 'tinyint', '1', '0'),
-('add_pct', 'setup.company', 'int', '5', '-1'),
-('allow_negative_prices', 'glsetup.inventory', 'tinyint', '1', '1'),
-('allow_negative_stock', 'glsetup.inventory', 'tinyint', '1', '0'),
-('alternative_tax_include_on_docs', 'setup.company', 'tinyint', '1', ''),
-('auto_curr_reval', 'setup.company', 'smallint', '6', '1'),
-('bank_charge_act', 'glsetup.general', 'varchar', '15', '5690'),
-('barcodes_on_stock', 'setup.company', 'tinyint', '1', '0'),
-('base_sales', 'setup.company', 'int', '11', '1'),
-('bcc_email', 'setup.company', 'varchar', '100', ''),
-('company_logo_report', 'setup.company', 'tinyint', '1', '0'),
-('coy_logo', 'setup.company', 'varchar', '100', 'logo_frontaccounting.jpg'),
-('coy_no', 'setup.company', 'varchar', '25', ''),
-('creditors_act', 'glsetup.purchase', 'varchar', '15', '2100'),
-('curr_default', 'setup.company', 'char', '3', 'USD'),
-('debtors_act', 'glsetup.sales', 'varchar', '15', '1200'),
-('default_adj_act', 'glsetup.items', 'varchar', '15', '5040'),
-('default_cogs_act', 'glsetup.items', 'varchar', '15', '5010'),
-('default_credit_limit', 'glsetup.customer', 'int', '11', '1000'),
-('default_delivery_required', 'glsetup.sales', 'smallint', '6', '1'),
-('default_dim_required', 'glsetup.dims', 'int', '11', '20'),
-('default_inv_sales_act', 'glsetup.items', 'varchar', '15', '4010'),
-('default_inventory_act', 'glsetup.items', 'varchar', '15', '1510'),
-('default_loss_on_asset_disposal_act', 'glsetup.items', 'varchar', '15', '5660'),
-('default_prompt_payment_act', 'glsetup.sales', 'varchar', '15', '4500'),
-('default_quote_valid_days', 'glsetup.sales', 'smallint', '6', '30'),
-('default_receival_required', 'glsetup.purchase', 'smallint', '6', '10'),
-('default_sales_act', 'glsetup.sales', 'varchar', '15', '4010'),
-('default_sales_discount_act', 'glsetup.sales', 'varchar', '15', '4510'),
-('default_wip_act', 'glsetup.items', 'varchar', '15', '1530'),
-('default_workorder_required', 'glsetup.manuf', 'int', '11', '20'),
+('coy_name', 'setup.company', 'varchar', 60, 'Company name'),
+('gst_no', 'setup.company', 'varchar', 25, ''),
+('coy_no', 'setup.company', 'varchar', 25, ''),
+('tax_prd', 'setup.company', 'int', 11, '1'),
+('tax_last', 'setup.company', 'int', 11, '1'),
+('postal_address', 'setup.company', 'tinytext', 0, 'N/A'),
+('phone', 'setup.company', 'varchar', 30, ''),
+('fax', 'setup.company', 'varchar', 30, ''),
+('email', 'setup.company', 'varchar', 100, ''),
+('coy_logo', 'setup.company', 'varchar', 100, ''),
+('domicile', 'setup.company', 'varchar', 55, ''),
+('curr_default', 'setup.company', 'char', 3, 'USD'),
+('use_dimension', 'setup.company', 'tinyint', 1, '1'),
+('f_year', 'setup.company', 'int', 11, '2'),
+('shortname_name_in_list','setup.company', 'tinyint', 1, '0'),
+('no_item_list', 'setup.company', 'tinyint', 1, '0'),
+('no_customer_list', 'setup.company', 'tinyint', 1, '0'),
+('no_supplier_list', 'setup.company', 'tinyint', 1, '0'),
+('base_sales', 'setup.company', 'int', 11, '1'),
+('time_zone', 'setup.company', 'tinyint', 1, '0'),
+('add_pct', 'setup.company', 'int', 5, '-1'),
+('round_to', 'setup.company', 'int', 5, '1'),
+('login_tout', 'setup.company', 'smallint', 6, '600'),
+('past_due_days', 'glsetup.general', 'int', 11, '30'),
+('profit_loss_year_act', 'glsetup.general', 'varchar', 15, '9990'),
+('retained_earnings_act', 'glsetup.general', 'varchar', 15, '3590'),
+('bank_charge_act', 'glsetup.general', 'varchar', 15, '5690'),
+('exchange_diff_act', 'glsetup.general', 'varchar', 15, '4450'),
+('tax_algorithm', 'glsetup.customer', 'tinyint', 1, '1'),
+('default_credit_limit', 'glsetup.customer', 'int', 11, '1000'),
+('accumulate_shipping', 'glsetup.customer', 'tinyint', 1, '0'),
+('legal_text', 'glsetup.customer', 'tinytext', 0, ''),
+('freight_act', 'glsetup.customer', 'varchar', 15, '4430'),
+('debtors_act', 'glsetup.sales', 'varchar', 15, '1200'),
+('default_sales_act', 'glsetup.sales', 'varchar', 15, '4010'),
+('default_sales_discount_act', 'glsetup.sales', 'varchar', 15, '4510'),
+('default_prompt_payment_act', 'glsetup.sales', 'varchar', 15, '4500'),
+('default_delivery_required', 'glsetup.sales', 'smallint', 6, '1'),
+('default_receival_required', 'glsetup.purchase', 'smallint', 6, '10'),
+('default_quote_valid_days', 'glsetup.sales', 'smallint', 6, '30'),
+('default_dim_required', 'glsetup.dims', 'int', 11, '20'),
+('pyt_discount_act', 'glsetup.purchase', 'varchar', 15, '5060'),
+('creditors_act', 'glsetup.purchase', 'varchar', 15, '2100'),
+('po_over_receive', 'glsetup.purchase', 'int', 11, '10'),
+('po_over_charge', 'glsetup.purchase', 'int', 11, '10'),
+('allow_negative_stock', 'glsetup.inventory', 'tinyint', 1, '0'),
+('default_inventory_act', 'glsetup.items', 'varchar', 15, '1510'),
+('default_cogs_act', 'glsetup.items', 'varchar', 15, '5010'),
+('default_adj_act', 'glsetup.items', 'varchar', 15, '5040'),
+('default_inv_sales_act', 'glsetup.items', 'varchar', 15, '4010'),
+('default_wip_act', 'glsetup.items', 'varchar', 15, '1530'),
+('default_workorder_required', 'glsetup.manuf', 'int', 11, '20'),
+('version_id', 'system', 'varchar', 11, '2.4.1'),
+('auto_curr_reval', 'setup.company', 'smallint', 6, '1'),
+('grn_clearing_act', 'glsetup.purchase', 'varchar', 15, '1550'),
+('bcc_email', 'setup.company', 'varchar', 100, ''),
('deferred_income_act', 'glsetup.sales', 'varchar', '15', '2105'),
+('gl_closing_date','setup.closing_date', 'date', 8, ''),
+('alternative_tax_include_on_docs','setup.company', 'tinyint', 1, '0'),
+('no_zero_lines_amount','glsetup.sales', 'tinyint', 1, '1'),
+('show_po_item_codes','glsetup.purchase', 'tinyint', 1, '0'),
+('accounts_alpha','glsetup.general', 'tinyint', 1, '0'),
+('loc_notification','glsetup.inventory', 'tinyint', 1, '0'),
+('print_invoice_no','glsetup.sales', 'tinyint', 1, '0'),
+('allow_negative_prices','glsetup.inventory', 'tinyint', 1, '1'),
+('print_item_images_on_quote','glsetup.inventory', 'tinyint', 1, '0'),
+('suppress_tax_rates','setup.company', 'tinyint', 1, '0'),
+('company_logo_report','setup.company', 'tinyint', 1, '0'),
+('barcodes_on_stock','setup.company', 'tinyint', 1, '0'),
+('print_dialog_direct','setup.company', 'tinyint', 1, '0'),
+('ref_no_auto_increase','setup.company', 'tinyint', 1, '0'),
+('default_loss_on_asset_disposal_act', 'glsetup.items', 'varchar', '15', '5660'),
('depreciation_period', 'glsetup.company', 'tinyint', '1', '1'),
-('domicile', 'setup.company', 'varchar', '55', ''),
-('email', 'setup.company', 'varchar', '100', 'delta@delta.com'),
-('exchange_diff_act', 'glsetup.general', 'varchar', '15', '4450'),
-('f_year', 'setup.company', 'int', '11', '2'),
-('fax', 'setup.company', 'varchar', '30', ''),
-('freight_act', 'glsetup.customer', 'varchar', '15', '4430'),
-('gl_closing_date', 'setup.closing_date', 'date', '8', '2018-12-31'),
-('grn_clearing_act', 'glsetup.purchase', 'varchar', '15', '1550'),
-('legal_text', 'glsetup.customer', 'tinytext', '0', ''),
-('loc_notification', 'glsetup.inventory', 'tinyint', '1', '0'),
-('login_tout', 'setup.company', 'smallint', '6', '600'),
-('no_customer_list', 'setup.company', 'tinyint', '1', '0'),
-('no_item_list', 'setup.company', 'tinyint', '1', '0'),
-('no_supplier_list', 'setup.company', 'tinyint', '1', '0'),
-('no_zero_lines_amount', 'glsetup.sales', 'tinyint', '1', '1'),
-('past_due_days', 'glsetup.general', 'int', '11', '30'),
-('phone', 'setup.company', 'varchar', '30', ''),
-('po_over_charge', 'glsetup.purchase', 'int', '11', '10'),
-('po_over_receive', 'glsetup.purchase', 'int', '11', '10'),
-('postal_address', 'setup.company', 'tinytext', '0', 'N/A'),
-('print_dialog_direct', 'setup.company', 'tinyint', '1', '0'),
-('print_invoice_no', 'glsetup.sales', 'tinyint', '1', '0'),
-('print_item_images_on_quote', 'glsetup.inventory', 'tinyint', '1', '0'),
-('profit_loss_year_act', 'glsetup.general', 'varchar', '15', '9990'),
-('pyt_discount_act', 'glsetup.purchase', 'varchar', '15', '5060'),
-('ref_no_auto_increase', 'setup.company', 'tinyint', '1', '0'),
-('retained_earnings_act', 'glsetup.general', 'varchar', '15', '3590'),
-('round_to', 'setup.company', 'int', '5', '1'),
-('shortname_name_in_list', 'setup.company', 'tinyint', '1', ''),
-('show_po_item_codes', 'glsetup.purchase', 'tinyint', '1', '0'),
-('suppress_tax_rates', 'setup.company', 'tinyint', '1', ''),
-('tax_algorithm', 'glsetup.customer', 'tinyint', '1', '1'),
-('tax_last', 'setup.company', 'int', '11', '1'),
-('tax_prd', 'setup.company', 'int', '11', '1'),
-('time_zone', 'setup.company', 'tinyint', '1', '0'),
-('use_dimension', 'setup.company', 'tinyint', '1', '1'),
-('use_fixed_assets', 'setup.company', 'tinyint', '1', '1'),
-('use_manufacturing', 'setup.company', 'tinyint', '1', '1'),
-('version_id', 'system', 'varchar', '11', '2.4.1');
-
--- Structure of table `0_sys_types` --
-
-DROP TABLE IF EXISTS `0_sys_types`;
-
-CREATE TABLE `0_sys_types` (
- `type_id` smallint(6) NOT NULL DEFAULT '0',
- `type_no` int(11) NOT NULL DEFAULT '1',
- `next_reference` varchar(100) NOT NULL DEFAULT '',
- PRIMARY KEY (`type_id`)
-) ENGINE=InnoDB ;
-
--- Data of table `0_sys_types` --
-
-INSERT INTO `0_sys_types` VALUES
-('0', '19', '3'),
-('1', '8', '2'),
-('2', '5', '2'),
-('4', '3', '1'),
-('10', '19', '4'),
-('11', '3', '2'),
-('12', '6', '1'),
-('13', '5', '2'),
-('16', '2', '1'),
-('17', '2', '1'),
-('18', '1', '3'),
-('20', '8', '3'),
-('21', '1', '1'),
-('22', '4', '2'),
-('25', '1', '2'),
-('26', '1', '8'),
-('28', '1', '1'),
-('29', '1', '2'),
-('30', '5', '6'),
-('32', '0', '1'),
-('35', '1', '1'),
-('40', '1', '3');
+('use_manufacturing','setup.company', 'tinyint', 1, '1'),
+('use_fixed_assets','setup.company', 'tinyint', 1, '1');
-- Structure of table `0_tag_associations` --
CREATE TABLE `0_tag_associations` (
`record_id` varchar(15) NOT NULL,
`tag_id` int(11) NOT NULL,
- UNIQUE KEY `record_id` (`record_id`,`tag_id`)
+ PRIMARY KEY (`record_id`,`tag_id`)
) ENGINE=InnoDB ;
-- Data of table `0_tag_associations` --
-
-- Structure of table `0_tags` --
DROP TABLE IF EXISTS `0_tags`;
-- Data of table `0_tags` --
-
-- Structure of table `0_tax_group_items` --
DROP TABLE IF EXISTS `0_tax_group_items`;
`included_in_price` tinyint(1) NOT NULL DEFAULT '0',
`net_amount` double NOT NULL DEFAULT '0',
`amount` double NOT NULL DEFAULT '0',
- `memo` tinytext COLLATE utf8_unicode_ci,
+ `memo` tinytext,
`reg_type` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `Type_and_Number` (`trans_type`,`trans_no`),
-- Data of table `0_trans_tax_details` --
INSERT INTO `0_trans_tax_details` VALUES
-('1', '13', '1', '2018-05-10', '1', '5', '1', '1', '5942.86', '297.14', 'auto', NULL),
-('2', '10', '1', '2018-05-10', '1', '5', '1', '1', '5942.86', '297.14', '001/2018', '0'),
-('3', '20', '1', '2018-05-05', '1', '5', '1', '0', '3000', '150', 'rr4', '1'),
-('4', '13', '2', '2018-05-07', '1', '5', '1', '1', '285.71', '14.29', 'auto', NULL),
-('5', '10', '2', '2018-05-07', '1', '5', '1', '1', '285.71', '14.29', '002/2018', '0'),
-('6', '13', '3', '2018-05-07', '0', '0', '1.123', '1', '267.14', '0', 'auto', NULL),
-('7', '10', '3', '2018-05-07', '0', '0', '1.123', '1', '267.14', '0', '003/2018', '0'),
-('8', '13', '5', '2019-01-21', '1', '5', '1', '1', '1190.48', '59.52', 'auto', NULL),
-('9', '10', '5', '2019-01-21', '1', '5', '1', '1', '1190.48', '59.52', '001/2019', '0'),
-('10', '20', '2', '2019-01-21', '1', '5', '1', '0', '900', '45', 'asd5', '1');
+('1', '13', '1', '2019-05-10', '1', '5', '1', '1', '5942.86', '297.14', 'auto', NULL),
+('2', '10', '1', '2019-05-10', '1', '5', '1', '1', '5942.86', '297.14', '001/2019', '0'),
+('3', '20', '1', '2019-05-05', '1', '5', '1', '0', '3000', '150', 'rr4', '1'),
+('4', '13', '2', '2019-05-07', '1', '5', '1', '1', '285.71', '14.29', 'auto', NULL),
+('5', '10', '2', '2019-05-07', '1', '5', '1', '1', '285.71', '14.29', '002/2019', '0'),
+('6', '13', '3', '2019-05-07', '0', '0', '1.123', '1', '267.14', '0', 'auto', NULL),
+('7', '10', '3', '2019-05-07', '0', '0', '1.123', '1', '267.14', '0', '003/2019', '0'),
+('8', '13', '5', '2020-01-21', '1', '5', '1', '1', '1190.48', '59.52', 'auto', NULL),
+('9', '10', '5', '2020-01-21', '1', '5', '1', '1', '1190.48', '59.52', '001/2020', '0'),
+('10', '20', '2', '2020-01-21', '1', '5', '1', '0', '900', '45', 'asd5', '1');
-- Structure of table `0_useronline` --
-- Data of table `0_users` --
INSERT INTO `0_users` VALUES
-('1', 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', '2', '', 'adm@example.com', 'C', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', '2018-05-07 13:58:33', '10', '1', '1', '1', '1', '0', 'orders', '30', '0', '1', '0', '0', '0');
+('1', 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', '2', '', 'adm@example.com', 'C', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', '2019-05-07 13:58:33', '10', '1', '1', '1', '1', '0', 'orders', '30', '0', '1', '0', '0', '0');
-- Structure of table `0_voided` --
-- Data of table `0_wo_costing` --
-
-- Structure of table `0_wo_issue_items` --
DROP TABLE IF EXISTS `0_wo_issue_items`;
-- Data of table `0_wo_issues` --
-
-- Structure of table `0_wo_manufacture` --
DROP TABLE IF EXISTS `0_wo_manufacture`;
-- Data of table `0_wo_manufacture` --
INSERT INTO `0_wo_manufacture` VALUES
-('1', '001/2018', '1', '2', '2018-05-05');
+('1', '001/2019', '1', '2', '2019-05-05');
-- Structure of table `0_wo_requirements` --
-- Data of table `0_workorders` --
INSERT INTO `0_workorders` VALUES
-('1', '001/2018', 'DEF', '2', '201', '2018-05-05', '0', '2018-05-05', '2018-05-05', '2', '1', '1', '0'),
-('2', '002/2018', 'DEF', '5', '201', '2018-05-07', '2', '2018-05-27', '2018-05-07', '0', '0', '1', '0'),
-('3', '003/2018', 'DEF', '5', '201', '2018-05-07', '2', '2018-05-27', '0000-00-00', '0', '0', '0', '0');
\ No newline at end of file
+('1', '001/2019', 'DEF', '2', '201', '2019-05-05', '0', '2019-05-05', '2019-05-05', '2', '1', '1', '0'),
+('2', '002/2019', 'DEF', '5', '201', '2019-05-07', '2', '2019-05-27', '2019-05-07', '0', '0', '1', '0'),
+('3', '003/2019', 'DEF', '5', '201', '2019-05-07', '2', '2019-05-27', '0000-00-00', '0', '0', '0', '0');
\ No newline at end of file
projects / fa-stable.git / blobdiff