--- Customer CRM Account's users.\r
-insert into xt.sharetype (\r
- sharetype_nsname,\r
- sharetype_tblname,\r
- sharetype_col_obj_uuid,\r
- sharetype_col_username\r
-) values (\r
- 'xt',\r
- 'share_users_cust',\r
- 'obj_uuid',\r
- 'username'\r
-);\r
-\r
--- Ship To CRM Account's users.\r
-insert into xt.sharetype (\r
- sharetype_nsname,\r
- sharetype_tblname,\r
- sharetype_col_obj_uuid,\r
- sharetype_col_username\r
-) values (\r
- 'xt',\r
- 'share_users_shipto',\r
- 'obj_uuid',\r
- 'username'\r
-);\r
+-- Customer CRM Account's users.
+delete from xt.sharetype where sharetype_tblname = 'share_users_cust';
+insert into xt.sharetype (
+ sharetype_nsname,
+ sharetype_tblname,
+ sharetype_col_obj_uuid,
+ sharetype_col_username
+) values (
+ 'xt',
+ 'share_users_cust',
+ 'obj_uuid',
+ 'username'
+);
+
+-- Ship To CRM Account's users.
+delete from xt.sharetype where sharetype_tblname = 'share_users_shipto';
+insert into xt.sharetype (
+ sharetype_nsname,
+ sharetype_tblname,
+ sharetype_col_obj_uuid,
+ sharetype_col_username
+) values (
+ 'xt',
+ 'share_users_shipto',
+ 'obj_uuid',
+ 'username'
+);
+
+-- Contact that is on a Ship To CRM Account's users.
+delete from xt.sharetype where sharetype_tblname = 'share_users_shipto_cntct';
+insert into xt.sharetype (
+ sharetype_nsname,
+ sharetype_tblname,
+ sharetype_col_obj_uuid,
+ sharetype_col_username
+) values (
+ 'xt',
+ 'share_users_shipto_cntct',
+ 'obj_uuid',
+ 'username'
+);
+
+-- Address that is on a Ship To CRM Account's users.
+delete from xt.sharetype where sharetype_tblname = 'share_users_shipto_addr';
+insert into xt.sharetype (
+ sharetype_nsname,
+ sharetype_tblname,
+ sharetype_col_obj_uuid,
+ sharetype_col_username
+) values (
+ 'xt',
+ 'share_users_shipto_addr',
+ 'obj_uuid',
+ '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 (
+ sharetype_nsname,
+ sharetype_tblname,
+ sharetype_col_obj_uuid,
+ sharetype_col_username
+) values (
+ 'xt',
+ 'share_users_cohead',
+ 'obj_uuid',
+ 'username'
+);