X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Falter2.1.sql;h=ae4ba4c67ed2ec46c16834024d734cdb13a70d9d;hb=871bc1f187ad6e5622a80c7dd8aadc48d8ea70fd;hp=05d16b357115e0954b37a2f0bd8636ba204f7186;hpb=d5a2671f2139a11be1d327649e59bb4fc7b18bd1;p=fa-stable.git diff --git a/sql/alter2.1.sql b/sql/alter2.1.sql index 05d16b35..ae4ba4c6 100644 --- a/sql/alter2.1.sql +++ b/sql/alter2.1.sql @@ -301,6 +301,7 @@ CREATE TABLE `0_trans_tax_details` ( `tran_date` date NOT NULL, `tax_type_id` int(11) NOT NULL default '0', `rate` double NOT NULL default '0', + `ex_rate` double NOT NULL default '1', `included_in_price` tinyint(1) NOT NULL default '0', `net_amount` double NOT NULL default '0', `amount` double NOT NULL default '0',