Additonal fixes to tax on foreign currency transactions.

[fa-stable.git] / sql / alter2.1.sql

diff --git a/sql/alter2.1.sql b/sql/alter2.1.sql
index 05d16b357115e0954b37a2f0bd8636ba204f7186..ae4ba4c67ed2ec46c16834024d734cdb13a70d9d 100644 (file)
--- 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',