diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-09-13 01:44:05 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-09-13 01:44:05 +0000 |
| commit | c22beebb571b727fcc80ee9c4e4741ab6ca10010 (patch) | |
| tree | 7e944617e41485607e349cfc31a6e0729bd86ea4 /sql | |
| parent | 4dc9e97ad999bb6ea4fe5171be988ee8e6c156dc (diff) | |
Adding description and control code fields to vendor/customer search
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2324 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/modules/Company.sql | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/sql/modules/Company.sql b/sql/modules/Company.sql index 0ee77159..7d9dd747 100644 --- a/sql/modules/Company.sql +++ b/sql/modules/Company.sql @@ -2,9 +2,11 @@ CREATE TYPE company_search_result AS ( entity_id int, + entity_control_code text, company_id int, entity_credit_id int, meta_number text, + credit_description text, entity_class int, legal_name text, sic_code text, @@ -27,7 +29,8 @@ BEGIN FOR out_row IN - SELECT e.id, c.id, ec.id, ec.meta_number, ec.entity_class, + SELECT e.id, e.control_code, c.id, ec.id, ec.meta_number, + ec.description, ec.entity_class, c.legal_name, c.sic_code, b.description , ec.curr::text FROM entity e JOIN company c ON (e.id = c.entity_id) @@ -151,12 +154,14 @@ CREATE TYPE entity_credit_search_return AS ( legal_name text, id int, entity_id int, + entity_control_code text, entity_class int, discount numeric, taxincluded bool, creditlimit numeric, terms int2, meta_number text, + credit_description text, business_id int, language_code text, pricegroup_id int, |