1 -- Customer CRM Account's users.
2 delete from xt.sharetype where sharetype_tblname = 'share_users_cust';
3 insert into xt.sharetype (
6 sharetype_col_obj_uuid,
15 -- Ship To CRM Account's users.
16 delete from xt.sharetype where sharetype_tblname = 'share_users_shipto';
17 insert into xt.sharetype (
20 sharetype_col_obj_uuid,
21 sharetype_col_username
29 -- Contact that is on a Ship To CRM Account's users.
30 delete from xt.sharetype where sharetype_tblname = 'share_users_shipto_cntct';
31 insert into xt.sharetype (
34 sharetype_col_obj_uuid,
35 sharetype_col_username
38 'share_users_shipto_cntct',
43 -- Address that is on a Ship To CRM Account's users.
44 delete from xt.sharetype where sharetype_tblname = 'share_users_shipto_addr';
45 insert into xt.sharetype (
48 sharetype_col_obj_uuid,
49 sharetype_col_username
52 'share_users_shipto_addr',
57 -- Customer that a Ship To is on CRM Account's users.
58 delete from xt.sharetype where sharetype_tblname = 'share_users_shipto_cust';
59 insert into xt.sharetype (
62 sharetype_col_obj_uuid,
63 sharetype_col_username
66 'share_users_shipto_cust',
71 -- Sales Order CRM Account's users.
72 delete from xt.sharetype where sharetype_tblname = 'share_users_cohead';
73 insert into xt.sharetype (
76 sharetype_col_obj_uuid,
77 sharetype_col_username