This is something I wrote for work. Most people won’t get it unless they work with SalesLogix regularly. I just want to keep it in case I need it for future reference.
Every Saleslogix record has a unique key, a twelve character code that can look a bit daunting. But these keys can be dissected into some useful information. I wanted to give an explanation to hopefully demystify these keys. What’s really great about this scheme is that it completely eliminates key collisions when entering data, even though users can be hitting different databases.
Use these keys for an example:
H6UJ9A0005TS
O8OJLA10000A
CIN4FA100000
A6UJ9A00CA4G
Every key can be broken down into four parts, the entity, site code, key base, and sequence.
Entity:
This is the type of record. By looking at the first character of the key, it will often tell you what type of record it is. One of the things I’ve learned in training is that the foundation of SalesLogix entities is the TACO, Tickets, Accounts, Contacts, and Opportunities.
t – Ticket
A – Account
C – Contact
O – Opportunity
H – History
V – Activity
B – Association
a – Address
This means that every record in the Account table will have a primary key that starts with the letter A, and every record in the Opportunity table will have a primary key that starts with the letter O.
When one of the main entity types is not involved, SalesLogix will use a Q. Notice that addresses have a lower-case A. Tickets use a lower case as well, but we don’t use tickets in our environment.
Site Code:
The site code refers to the database where a record was created. Every remote database, whether a remote office or a remote user, will have a unique code to identify it. The site code for our master database is 6UJ9. These codes are system defined and can’t be chosen. I expect that 95% of the data in our system will be created in 6UJ9. Keep in mind that this identifies the database and not always the user.
Here are some of the site codes in our environment:
6UJ9 – SLX Server
8OJL – BD-NE
9DVO – NE-R-EU
8I1X – BD-R-NY
Key Base:
The key base, simply put, is a version. From time to time, it becomes necessary to cut a remote database. When doing that, it increases the key base. The most frequent use of this would be when a laptop gets replaced. Key bases start at A0 and go as high as Z9. 6UJ9 will always have a key base of A0.
Sequence:
The sequence is just the series or ordinal for that type of record. It uses all ten digits plus the English alphabet.