Does anyone know the source of SalesLogix: KEYVALUE, SITECODE, KEYTYPE and KEYDESC?

Question:

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.

Answer:

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 !

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!