From c22beebb571b727fcc80ee9c4e4741ab6ca10010 Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Sat, 13 Sep 2008 01:44:05 +0000
Subject: 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
---
sql/modules/Company.sql | 7 ++++++-
1 file changed, 6 insertions(+), 1 deletion(-)
(limited to 'sql/modules')
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,
--
cgit v1.2.3