projects
/
xtuple
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
30aec49
)
Include the view when building share_users.
author
Ben Thompson
<ben@xtuple.com>
Thu, 18 Sep 2014 18:17:20 +0000
(14:17 -0400)
committer
Ben Thompson
<ben@xtuple.com>
Thu, 18 Sep 2014 18:17:20 +0000
(14:17 -0400)
enyo-client/extensions/source/sales/database/source/xt/tables/sharetype.sql
patch
|
blob
|
history
enyo-client/extensions/source/sales/database/source/xt/views/share_users_shipto_cust.sql
patch
|
blob
|
history
diff --git
a/enyo-client/extensions/source/sales/database/source/xt/tables/sharetype.sql
b/enyo-client/extensions/source/sales/database/source/xt/tables/sharetype.sql
index
69301f3
..
3e343bf
100644
(file)
--- a/
enyo-client/extensions/source/sales/database/source/xt/tables/sharetype.sql
+++ b/
enyo-client/extensions/source/sales/database/source/xt/tables/sharetype.sql
@@
-54,6
+54,20
@@
insert into xt.sharetype (
'username'
);
'username'
);
+-- Customer that a Ship To is on CRM Account's users.
+delete from xt.sharetype where sharetype_tblname = 'share_users_shipto_cust';
+insert into xt.sharetype (
+ sharetype_nsname,
+ sharetype_tblname,
+ sharetype_col_obj_uuid,
+ sharetype_col_username
+) values (
+ 'xt',
+ 'share_users_shipto_cust',
+ 'obj_uuid',
+ 'username'
+);
+
-- Sales Order CRM Account's users.
delete from xt.sharetype where sharetype_tblname = 'share_users_cohead';
insert into xt.sharetype (
-- Sales Order CRM Account's users.
delete from xt.sharetype where sharetype_tblname = 'share_users_cohead';
insert into xt.sharetype (
diff --git
a/enyo-client/extensions/source/sales/database/source/xt/views/share_users_shipto_cust.sql
b/enyo-client/extensions/source/sales/database/source/xt/views/share_users_shipto_cust.sql
index
676a5ae
..
d852f1f
100644
(file)
--- a/
enyo-client/extensions/source/sales/database/source/xt/views/share_users_shipto_cust.sql
+++ b/
enyo-client/extensions/source/sales/database/source/xt/views/share_users_shipto_cust.sql
@@
-5,7
+5,7
@@
* a shared access that has been specifically granted.
*
* This view can be used to determine which users have personal privilege
* a shared access that has been specifically granted.
*
* This view can be used to determine which users have personal privilege
- * access to a C
ontact that is on a Ship To
based on what CRM Account the
+ * access to a C
ustomer that a Ship To is on
based on what CRM Account the
* Ship To belongs to.
*/
* Ship To belongs to.
*/