X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Fen_US-new.sql;h=078442bcdb3b0d8fad0a78b9029299dff24a7d12;hb=f36d4241ba673261532a1bb3c59b6b985901238e;hp=e2a761c87b69b7c0ce1b6d8c5e7da2722792e67d;hpb=ae91cfc98a8343d3886099df3f346bedd7a194b0;p=fa-stable.git

diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql
index e2a761c8..078442bc 100644
--- a/sql/en_US-new.sql
+++ b/sql/en_US-new.sql
@@ -1165,6 +1165,7 @@ CREATE TABLE IF NOT EXISTS `0_purch_orders` (
   `into_stock_location` varchar(5) NOT NULL default '',
   `delivery_address` tinytext NOT NULL,
   `total` double NOT NULL default '0',
+  `tax_included` tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (`order_no`),
   KEY `ord_date` (`ord_date`)
 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
@@ -1739,6 +1740,7 @@ CREATE TABLE IF NOT EXISTS `0_supp_trans` (
   `ov_gst` double NOT NULL default '0',
   `rate` double NOT NULL default '1',
   `alloc` double NOT NULL default '0',
+  `tax_included` tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (`type`,`trans_no`),
   KEY `supplier_id` (`supplier_id`),
   KEY `SupplierID_2` (`supplier_id`,`supp_reference`),