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.

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!