diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-05-09 17:49:14 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-05-09 17:49:14 +0000 |
| commit | 7d9e94796fb4e4b76ae739088dc15c858272a90a (patch) | |
| tree | 6a248618135dea6587f65c21131601b5bba9b410 /sql/modules/Company.sql | |
| parent | 51b0e95ee7793a6903d4290deed2bbd9e19b006f (diff) | |
Correcting issues saving/retriving tax id for vendors/customers, and retrieving the cash id.
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2130 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql/modules/Company.sql')
| -rw-r--r-- | sql/modules/Company.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/modules/Company.sql b/sql/modules/Company.sql index faffe92e..d935317d 100644 --- a/sql/modules/Company.sql +++ b/sql/modules/Company.sql @@ -144,6 +144,7 @@ CREATE TYPE entity_credit_search_return AS ( enddate date, ar_ap_account_id int, cash_account_id int, + tax_id text, threshold numeric ); @@ -161,7 +162,7 @@ BEGIN ec.taxincluded, ec.creditlimit, ec.terms, ec.meta_number, ec.business_id, ec.language_code, ec.pricegroup_id, ec.curr::char(3), ec.startdate, ec.enddate, ec.ar_ap_account_id, - ec.cash_account_id, ec.threshold + ec.cash_account_id, c.tax_id, ec.threshold INTO out_row FROM company c JOIN entity e ON (c.entity_id = e.id) |