I ran the SalesLogix Profiler to see the SQL executed when an activity is completed. One of the statements executed was the following:
UPDATE SITEKEYS SET KEYVALUE = ‘A0001LO’, MODIFYDATE = ‘20090925 14:05:20’, MODIFYUSER = ‘UDEMOA00001H’ WHERE SITECODE = ‘DEMO’ AND KEYTYPE = 6 AND KEYVALUE = ‘A0001LN’
Does anyone know the source of KEYVALUE, SITECODE, KEYTYPE and KEYDESC?
KEYDESC doesnt apper in the SQL statement but is a field in the table.
Essentially, in order to generate unique keys, the SalesLogix system needs to know how to generate them.
For each user/remote office/remote user the sitekeys is used to generate new keys and each key is generated by type (e.g. a new account ID will be generated by the next key value for the keytype of 1 and for that user’s (if they are a remote user, otherwise the system sitecode is used) sitecode ID. it’s not something you’ll want to play with !