X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Fen_US-demo.sql;h=ff2055f5419a8d5be60f10ac2924f477b8e86d52;hb=317210096efdbe5b375d5a0112d4f10a3c3c0b53;hp=6ad419cba1eb49090f8c53347ddb77825eac0ecb;hpb=309b4272ec502e42d1288c4dfdee824b4f6c135a;p=fa-stable.git diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index 6ad419cb..ff2055f5 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -92,7 +92,7 @@ INSERT INTO `0_audit_trail` VALUES ('4', '13', '1', '1', '2017-05-05 14:09:55', NULL, '1', '2017-05-10', '0'), ('5', '10', '1', '1', '2017-05-05 14:09:55', NULL, '1', '2017-05-10', '0'), ('6', '12', '1', '1', '2017-05-05 14:09:55', NULL, '1', '2017-05-10', '0'), -('7', '26', '1', '1', '2017-05-05 14:18:49', 'Quick production.', '1', '2017-05-05', '0'), +('7', '29', '1', '1', '2017-05-05 14:18:49', 'Quick production.', '1', '2017-05-05', '0'), ('8', '18', '2', '1', '2017-05-05 14:22:32', NULL, '1', '2017-05-05', '0'), ('9', '25', '2', '1', '2017-05-05 14:22:32', NULL, '1', '2017-05-05', '0'), ('10', '20', '1', '1', '2017-05-05 14:22:32', NULL, '1', '2017-05-05', '0'), @@ -110,9 +110,9 @@ INSERT INTO `0_audit_trail` VALUES ('22', '13', '4', '1', '2017-05-07 14:05:38', NULL, '1', '2017-05-07', '0'), ('23', '10', '4', '1', '2017-05-07 14:05:38', NULL, '1', '2017-05-07', '0'), ('24', '12', '3', '1', '2017-05-07 14:05:38', NULL, '1', '2017-05-07', '0'), -('25', '26', '2', '1', '2017-05-07 15:59:34', NULL, '1', '2017-05-07', NULL), -('26', '26', '3', '1', '2017-05-07 15:59:01', NULL, '1', '2017-05-07', '0'), -('27', '26', '2', '1', '2017-05-07 15:59:34', 'Released.', '1', '2017-05-07', '0'), +('25', '26', '1', '1', '2017-05-07 15:59:34', NULL, '1', '2017-05-07', NULL), +('26', '29', '1', '1', '2017-05-07 15:59:01', 'Production.', '1', '2017-05-07', '0'), +('27', '26', '1', '1', '2017-05-07 15:59:34', 'Released.', '1', '2017-05-07', '0'), ('28', '1', '1', '1', '2017-05-07 16:01:00', NULL, '1', '2017-05-07', '0'); -- -------------------------------------------------------- @@ -301,6 +301,7 @@ INSERT INTO `0_chart_master` VALUES ('1825', '', 'Accum. Amort. -Furn. & Equ INSERT INTO `0_chart_master` VALUES ('1840', '', 'Vehicle', '3', 0); INSERT INTO `0_chart_master` VALUES ('1845', '', 'Accum. Amort. -Vehicle', '3', 0); INSERT INTO `0_chart_master` VALUES ('2100', '', 'Accounts Payable', '4', 0); +INSERT INTO `0_chart_master` VALUES ('2105', '', 'Deferred Income', '4', 0); INSERT INTO `0_chart_master` VALUES ('2110', '', 'Accrued Income Tax - Federal', '4', 0); INSERT INTO `0_chart_master` VALUES ('2120', '', 'Accrued Income Tax - State', '4', 0); INSERT INTO `0_chart_master` VALUES ('2130', '', 'Accrued Franchise Tax', '4', 0); @@ -497,7 +498,7 @@ INSERT INTO `0_crm_categories` VALUES (12, 'supplier', 'invoice', 'Invoices', 'I DROP TABLE IF EXISTS `0_crm_contacts`; CREATE TABLE IF NOT EXISTS `0_crm_contacts` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `person_id` int(11) NOT NULL DEFAULT '0' COMMENT 'foreign key to crm_contacts', + `person_id` int(11) NOT NULL DEFAULT '0' COMMENT 'foreign key to crm_persons', `type` varchar(20) NOT NULL COMMENT 'foreign key to crm_categories', `action` varchar(20) NOT NULL COMMENT 'foreign key to crm_categories', `entity_id` varchar(11) DEFAULT NULL COMMENT 'entity id in related class table', @@ -885,7 +886,7 @@ CREATE TABLE IF NOT EXISTS `0_gl_trans` ( KEY `dimension2_id` (`dimension2_id`), KEY `tran_date` (`tran_date`), KEY `account_and_tran_date` (`account`,`tran_date`) -) ENGINE=InnoDB AUTO_INCREMENT=39 ; +) ENGINE=InnoDB AUTO_INCREMENT=41 ; -- -- Dumping data for table `0_gl_trans` @@ -904,32 +905,34 @@ INSERT INTO `0_gl_trans` VALUES ('10', '10', '1', '2017-05-10', '2150', '', '-297.14', '0', '0', NULL, NULL), ('11', '12', '1', '2017-05-10', '1065', '', '6240', '0', '0', NULL, NULL), ('12', '12', '1', '2017-05-10', '1200', '', '-6240', '0', '0', '2', '1'), -('13', '26', '1', '2017-05-05', '1510', '1 * iPad Air 2 16GB', '-400', '0', '0', NULL, NULL), -('14', '26', '1', '2017-05-05', '1510', '1 * iPhone 6 64GB', '-300', '0', '0', NULL, NULL), -('15', '26', '1', '2017-05-05', '1510', '1 * iPhone Cover Case', '-20', '0', '0', NULL, NULL), -('16', '26', '1', '2017-05-05', '1510', 'Produced 2 * AP Surf Set', '720', '0', '0', NULL, NULL), -('17', '25', '2', '2017-05-05', '1510', '101', '3000', '0', '0', NULL, NULL), -('18', '25', '2', '2017-05-05', '1550', '', '-3000', '0', '0', NULL, NULL), -('19', '20', '1', '2017-05-05', '2150', '', '150', '0', '0', NULL, NULL), -('20', '20', '1', '2017-05-05', '2100', '', '-3150', '0', '0', '3', '1'), -('21', '20', '1', '2017-05-05', '1550', '', '3000', '0', '0', NULL, NULL), -('22', '13', '2', '2017-05-07', '5010', '', '200', '0', '0', NULL, NULL), -('23', '13', '2', '2017-05-07', '1510', '', '-200', '0', '0', NULL, NULL), -('24', '10', '2', '2017-05-07', '4010', '', '-285.71', '0', '0', NULL, NULL), -('25', '10', '2', '2017-05-07', '1200', '', '300', '0', '0', '2', '1'), -('26', '10', '2', '2017-05-07', '2150', '', '-14.29', '0', '0', NULL, NULL), -('27', '12', '2', '2017-05-07', '1065', '', '300', '0', '0', NULL, NULL), -('28', '12', '2', '2017-05-07', '1200', '', '-300', '0', '0', '2', '1'), -('29', '13', '3', '2017-05-07', '5010', '', '150', '1', '0', NULL, NULL), -('30', '13', '3', '2017-05-07', '1510', '', '-150', '0', '0', NULL, NULL), -('31', '13', '3', '2017-05-07', '5010', '', '10', '1', '0', NULL, NULL), -('32', '13', '3', '2017-05-07', '1510', '', '-10', '0', '0', NULL, NULL), -('33', '10', '3', '2017-05-07', '4010', '', '-250', '1', '0', NULL, NULL), -('34', '10', '3', '2017-05-07', '4010', '', '-50', '1', '0', NULL, NULL), -('35', '10', '3', '2017-05-07', '1200', '', '300', '0', '0', '2', '2'), -('36', '12', '3', '2017-05-07', '1065', '', '0', '0', '0', NULL, NULL), -('37', '1', '1', '2017-05-07', '5010', '', '5', '1', '0', NULL, NULL), -('38', '1', '1', '2017-05-07', '1060', '', '-5', '0', '0', NULL, NULL); +('13', '29', '1', '2017-05-05', '1510', '1 * iPad Air 2 16GB', '-400', '0', '0', NULL, NULL), +('14', '29', '1', '2017-05-05', '1510', '1 * iPhone 6 64GB', '-300', '0', '0', NULL, NULL), +('15', '29', '1', '2017-05-05', '1510', '1 * iPhone Cover Case', '-20', '0', '0', NULL, NULL), +('16', '29', '1', '2017-05-05', '1530', '1 * Support', '720', '0', '0', NULL, NULL), +('17', '26', '1', '2017-05-05', '1530', '', '-720', '0', '0', NULL, NULL), +('18', '26', '1', '2017-05-05', '1510', '', '720', '0', '0', NULL, NULL), +('19', '25', '2', '2017-05-05', '1510', '101', '3000', '0', '0', NULL, NULL), +('20', '25', '2', '2017-05-05', '1550', '', '-3000', '0', '0', NULL, NULL), +('21', '20', '1', '2017-05-05', '2150', '', '150', '0', '0', NULL, NULL), +('22', '20', '1', '2017-05-05', '2100', '', '-3150', '0', '0', '3', '1'), +('23', '20', '1', '2017-05-05', '1550', '', '3000', '0', '0', NULL, NULL), +('24', '13', '2', '2017-05-07', '5010', '', '200', '0', '0', NULL, NULL), +('25', '13', '2', '2017-05-07', '1510', '', '-200', '0', '0', NULL, NULL), +('26', '10', '2', '2017-05-07', '4010', '', '-285.71', '0', '0', NULL, NULL), +('27', '10', '2', '2017-05-07', '1200', '', '300', '0', '0', '2', '1'), +('28', '10', '2', '2017-05-07', '2150', '', '-14.29', '0', '0', NULL, NULL), +('29', '12', '2', '2017-05-07', '1065', '', '300', '0', '0', NULL, NULL), +('30', '12', '2', '2017-05-07', '1200', '', '-300', '0', '0', '2', '1'), +('31', '13', '3', '2017-05-07', '5010', '', '150', '1', '0', NULL, NULL), +('32', '13', '3', '2017-05-07', '1510', '', '-150', '0', '0', NULL, NULL), +('33', '13', '3', '2017-05-07', '5010', '', '10', '1', '0', NULL, NULL), +('34', '13', '3', '2017-05-07', '1510', '', '-10', '0', '0', NULL, NULL), +('35', '10', '3', '2017-05-07', '4010', '', '-250', '1', '0', NULL, NULL), +('36', '10', '3', '2017-05-07', '4010', '', '-50', '1', '0', NULL, NULL), +('37', '10', '3', '2017-05-07', '1200', '', '300', '0', '0', '2', '2'), +('38', '12', '3', '2017-05-07', '1065', '', '0', '0', '0', NULL, NULL), +('39', '1', '1', '2017-05-07', '5010', '', '5', '1', '0', NULL, NULL), +('40', '1', '1', '2017-05-07', '1060', '', '-5', '0', '0', NULL, NULL); -- -------------------------------------------------------- @@ -1213,6 +1216,7 @@ INSERT INTO `0_payment_terms` VALUES (1, 'Due 15th Of the Following Month', 0, 1 INSERT INTO `0_payment_terms` VALUES (2, 'Due By End Of The Following Month', 0, 30, 0); INSERT INTO `0_payment_terms` VALUES (3, 'Payment due within 10 days', 10, 0, 0); INSERT INTO `0_payment_terms` VALUES (4, 'Cash Only', 0, 0, 0); +INSERT INTO `0_payment_terms` VALUES (5, 'Prepaid', -1, 0, 0); -- -------------------------------------------------------- @@ -1938,11 +1942,11 @@ INSERT INTO `0_stock_moves` VALUES ('3', '1', '103', '25', 'DEF', '2017-05-05', '10', '', '100', '10'), ('4', '1', '101', '13', 'DEF', '2017-05-10', '300', 'auto', '-20', '200'), ('5', '1', '301', '13', 'DEF', '2017-05-10', '80', 'auto', '-3', '0'), -('6', '1', '101', '26', 'DEF', '2017-05-05', '200', '001/2017', '-2', '200'), -('7', '1', '102', '26', 'DEF', '2017-05-05', '150', '001/2017', '-2', '150'), -('8', '1', '103', '26', 'DEF', '2017-05-05', '10', '001/2017', '-2', '10'), -('9', '1', '301', '26', 'DEF', '2017-05-05', '0', '001/2017', '-2', '0'), -('10', '1', '201', '26', 'DEF', '2017-05-05', '0', '001/2017', '2', '0'), +('6', '1', '101', '29', 'DEF', '2017-05-05', '200', '001/2017', '-2', '200'), +('7', '1', '102', '29', 'DEF', '2017-05-05', '150', '001/2017', '-2', '150'), +('8', '1', '103', '29', 'DEF', '2017-05-05', '10', '001/2017', '-2', '10'), +('9', '1', '301', '29', 'DEF', '2017-05-05', '0', '001/2017', '-2', '0'), +('10', '1', '201', '26', 'DEF', '2017-05-05', '0', '001/2017', '2', '360'), ('11', '2', '101', '25', 'DEF', '2017-05-05', '200', '', '15', '200'), ('12', '2', '101', '13', 'DEF', '2017-05-07', '300', 'auto', '-1', '200'), ('13', '3', '102', '13', 'DEF', '2017-05-07', '222.62', 'auto', '-1', '150'), @@ -2159,7 +2163,7 @@ INSERT INTO `0_sys_prefs` VALUES ('version_id', 'system', 'varchar', 11, '2.4.1' INSERT INTO `0_sys_prefs` VALUES ('auto_curr_reval', 'setup.company', 'smallint', 6, '1'); INSERT INTO `0_sys_prefs` VALUES ('grn_clearing_act', 'glsetup.purchase', 'varchar', 15, '1550'); INSERT INTO `0_sys_prefs` VALUES ('bcc_email', 'setup.company', 'varchar', 100, ''); -INSERT INTO `0_sys_prefs` VALUES ('deferred_income_act', 'glsetup.sales', 'varchar', '15', ''); +INSERT INTO `0_sys_prefs` VALUES ('deferred_income_act', 'glsetup.sales', 'varchar', '15', '2105'); INSERT INTO `0_sys_prefs` VALUES ('gl_closing_date','setup.closing_date', 'date', 8, ''); INSERT INTO `0_sys_prefs` VALUES ('alternative_tax_include_on_docs','setup.company', 'tinyint', 1, '0'); INSERT INTO `0_sys_prefs` VALUES ('no_zero_lines_amount','glsetup.sales', 'tinyint', 1, '1'); @@ -2172,6 +2176,7 @@ INSERT INTO `0_sys_prefs` VALUES ('print_item_images_on_quote','glsetup.inventor INSERT INTO `0_sys_prefs` VALUES ('suppress_tax_rates','setup.company', 'tinyint', 1, '0'); INSERT INTO `0_sys_prefs` VALUES ('company_logo_report','setup.company', 'tinyint', 1, '0'); INSERT INTO `0_sys_prefs` VALUES ('barcodes_on_stock','setup.company', 'tinyint', 1, '0'); +INSERT INTO `0_sys_prefs` VALUES ('ref_no_auto_increase','setup.company', 'tinyint', 1, '0'); INSERT INTO `0_sys_prefs` VALUES ('default_loss_on_asset_disposal_act', 'glsetup.items', 'varchar', '15', '5660'); INSERT INTO `0_sys_prefs` VALUES ('depreciation_period', 'glsetup.company', 'tinyint', '1', '1'); INSERT INTO `0_sys_prefs` VALUES ('use_manufacturing','setup.company', 'tinyint', 1, '1'); @@ -2552,6 +2557,8 @@ CREATE TABLE IF NOT EXISTS `0_wo_manufacture` ( -- Dumping data for table `0_wo_manufacture` -- +INSERT INTO `0_wo_manufacture` VALUES (1, '001/2017', 1, 2, '2017-05-05'); + -- -------------------------------------------------------- -- @@ -2577,12 +2584,12 @@ CREATE TABLE IF NOT EXISTS `0_wo_requirements` ( -- INSERT INTO `0_wo_requirements` VALUES -('1', '1', '101', '1', '1', '0', 'DEF', '2'), -('2', '1', '102', '1', '1', '0', 'DEF', '2'), -('3', '1', '103', '1', '1', '0', 'DEF', '2'), +('1', '1', '101', '1', '1', '200', 'DEF', '2'), +('2', '1', '102', '1', '1', '150', 'DEF', '2'), +('3', '1', '103', '1', '1', '10', 'DEF', '2'), ('4', '1', '301', '1', '1', '0', 'DEF', '2'), -('5', '2', '101', '1', '1', '0', 'DEF', '0'), -('6', '2', '102', '1', '1', '0', 'DEF', '0'), -('7', '2', '103', '1', '1', '0', 'DEF', '0'), +('5', '2', '101', '1', '1', '200', 'DEF', '0'), +('6', '2', '102', '1', '1', '150', 'DEF', '0'), +('7', '2', '103', '1', '1', '10', 'DEF', '0'), ('8', '2', '301', '1', '1', '0', 'DEF', '0');