diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-08-08 05:11:41 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-08-08 05:11:41 +0000 |
| commit | cb92467b6c9f4a6bd223ee7896cb5ad6ee012c97 (patch) | |
| tree | 990424c5b880cb151bb2d20bf7159110531b1afe /sql | |
| parent | d0a768c8d1d03468892c12ee0224f70c1586d9aa (diff) | |
Adding meta_number to company_billing_info return set
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2242 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to '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 ec530841..ce9723a0 100644 --- a/sql/modules/Company.sql +++ b/sql/modules/Company.sql @@ -247,6 +247,7 @@ $$ language plpgsql; CREATE TYPE company_billing_info AS ( legal_name text, +meta_number text, tax_id text, street1 text, street2 text, @@ -263,7 +264,7 @@ $$ DECLARE out_var company_billing_info; t_id INT; BEGIN - select c.legal_name, c.tax_id, a.line_one, a.line_two, a.line_three, + select c.legal_name, eca.meta_number, c.tax_id, a.line_one, a.line_two, a.line_three, a.city, a.state, a.mail_code, cc.name into out_var FROM company c |