Login / Register  search  syndication  about

          SalesLogix Questions & Answers

Your place to get answers to your SalesLogix related questions.

 Home  |   Subscribe via RSS  |   Subscribe via E-mail  |   

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 !

What's This?
  
Bookmark and Share

About SalesLogix Support

   Your SalesLogix Business Partner for SalesLogix Support.


Related Content
   Saleslogix XBar Installation
When installing the new XBar application I found the instructions a little vague so I thought I would pas
Posted on Jul 18, 2014 by Mark Duthoy to SalesLogix Support
 
   "Saleslogix’s affordable pricing and usability allow the product to rise above competitors in the space" - Info-Tech Research Group, Inc.
"SalesLogix’s affordable pricing and usability allow the product to rise above competitors in the sp
Posted on Jul 14, 2014 by Scott Weber to SalesLogix Product Blog
 
   Saleslogix Default Group Layout
How can I default the formatting of columns in my Saleslogix groups?
Posted on Jul 03, 2014 by Dale Richter to SalesLogix Questions & Answers
 
   Changing Contact Process Statuses in Bulk
Recently, I was asked if it was possible to cancel a group of running contact processes.The answer is yes
Posted on Jun 30, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Finding the Current Parent Record ID in SalesLogix Web
Sometimes it's the easiest things that can be a big barrier to entry for getting started with somet
Posted on Jun 27, 2014 by Ryan Farley to Ryan Farley's Blog
 
Comments

No Comments
All contents Copyright © 2014 Customer FX Corporation
Customer FX Corporation
2324 University Avenue West, Suite 115
Saint Paul, Minnesota 55114
Tel: 800.728.5783

  Follow @CustomerFX on twitter
Follow the best news, tips, and articles
  Subscribe to Customer FX on youtube
Watch SalesLogix tutorial videos from Customer FX
Login / Register