From 6b758978f4eaad8227a5222e64ab17157697466b Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Mon, 4 Jun 2007 22:02:41 +0000
Subject: More trunk fixes

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1253 4979c152-3d1c-0410-bac9-87ea11338e46
---
 LedgerSMB/CA.pm     | 2 +-
 sql/Pg-database.sql | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/LedgerSMB/CA.pm b/LedgerSMB/CA.pm
index 61df47fd..8ce44f6a 100644
--- a/LedgerSMB/CA.pm
+++ b/LedgerSMB/CA.pm
@@ -370,7 +370,7 @@ sub all_transactions {
 			       ac.source, a.till, ac.chart_id
 			  FROM ar a
 			  JOIN acc_trans ac ON (ac.trans_id = a.id)
-			  JOIN customer c ON (a.customer_id = c.id)
+			  JOIN customer c USING (entity_id)
 			$dpt_join
 			 WHERE ac.chart_id = ?
 			$fromdate_where
diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql
index 78c22f90..5956879a 100644
--- a/sql/Pg-database.sql
+++ b/sql/Pg-database.sql
@@ -297,7 +297,7 @@ CREATE TABLE customer (
   cc text,
   bcc text,
   business_id int,
-  taxnumber varchar(32),
+  invoice_notes text,
   sic_code varchar(6),
   iban varchar(34),
   bic varchar(11),
-- 
cgit v1.2.3