summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/modules/Company.sql3
-rw-r--r--sql/modules/Roles.sql2
2 files changed, 4 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)
diff --git a/sql/modules/Roles.sql b/sql/modules/Roles.sql
index e8ae3bb4..b91298f1 100644
--- a/sql/modules/Roles.sql
+++ b/sql/modules/Roles.sql
@@ -577,6 +577,7 @@ IN ROLE "lsmb_<?lsmb dbname ?>__list_ap_transactions";
GRANT INSERT ON acc_trans TO "lsmb_<?lsmb dbname ?>__process_payment";
GRANT ALL ON acc_trans_entry_id_seq TO "lsmb_<?lsmb dbname ?>__process_payment";
+GRANT UPDATE ON ap TO "lsmb_<?lsmb dbname ?>__process_payment";
INSERT INTO menu_acl (node_id, acl_type, role_name)
@@ -591,6 +592,7 @@ IN ROLE "lsmb_<?lsmb dbname ?>__list_ar_transactions";
GRANT INSERT ON acc_trans TO "lsmb_<?lsmb dbname ?>__process_receipt";
GRANT ALL ON acc_trans_entry_id_seq TO "lsmb_<?lsmb dbname ?>__process_receipt";
+GRANT UPDATE ON ar TO "lsmb_<?lsmb dbname ?>__process_receipt";
INSERT INTO menu_acl (node_id, acl_type, role_name)
values (35, 'allow', 'lsmb_<?lsmb dbname ?>__process_receipt');