X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Fen_US-new.sql;h=09fe3108c6d170333a64605a80fc550fa1867a75;hb=ead566f5e20aec8925be69a83803d2de95c26bb8;hp=cd0bc1fc698a112f2b69c2a6453c0a37a87a52e4;hpb=090d7aa59c80c1fb5089f6b4376b51c46244eca5;p=fa-stable.git diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index cd0bc1fc..09fe3108 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -652,6 +652,7 @@ CREATE TABLE IF NOT EXISTS `0_debtor_trans` ( `dimension_id` int(11) NOT NULL default '0', `dimension2_id` int(11) NOT NULL default '0', `payment_terms` int(11) default NULL, + `tax_included` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`type`,`trans_no`), KEY `debtor_no` (`debtor_no`,`branch_code`), KEY `tran_date` (`tran_date`) @@ -765,6 +766,7 @@ CREATE TABLE IF NOT EXISTS `0_fiscal_year` ( INSERT INTO `0_fiscal_year` VALUES(1, '2008-01-01', '2008-12-31', 0); INSERT INTO `0_fiscal_year` VALUES(2, '2009-01-01', '2009-12-31', 0); INSERT INTO `0_fiscal_year` VALUES(3, '2010-01-01', '2010-12-31', 0); +INSERT INTO `0_fiscal_year` VALUES(4, '2011-01-01', '2011-12-31', 0); -- -- Table structure for table `0_gl_trans`