Wrong type for AP Surf Set in demo data.

[fa-stable.git] / sql / en_US-demo.sql

diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql
index 6ad419cba1eb49090f8c53347ddb77825eac0ecb..41b4cbb81c2952c747f19b57da11bae0b2b6277c 100644 (file)
--- a/sql/en_US-demo.sql
+++ b/sql/en_US-demo.sql
@@ -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);
@@ -1213,6 +1214,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 +1940,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 +2161,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 +2174,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');