summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2007-06-04 22:02:41 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2007-06-04 22:02:41 +0000
commit6b758978f4eaad8227a5222e64ab17157697466b (patch)
tree1060b9827227dc7df871ca50076f2138f98552a0
parent9962480601cef59d4637bb4360e3808be3c9f320 (diff)
More trunk fixes
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1253 4979c152-3d1c-0410-bac9-87ea11338e46
-rw-r--r--LedgerSMB/CA.pm2
-rw-r--r--sql/Pg-database.sql2
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),