Hi There,
After adding some customized items to the "Status Reason of Lead", I noticed that the data type for the "statuscode" column in the LeadBase table is "int". On the screen, it is apprently a list of pair of "value" and "label". It also has three states: open, quilified, and disquilified. I am confused.
1. Could someone explain how the data is stored in the database? Did I look at the right table and column? Is only the "value" stored in the database and the other half of the pair, i.e. "label" stored in the XML? Where is the state information (open, quilified, and disqualified) stored?
2. Why do the numbers not add up? There are 4 status reasons for open state, 1 status reason for quilified state, and 6 stats reasons for disqulified state now on the screen. If I try to add anthor new item, the value shown on the screen will be 14. But, if I check the database table "LeadBase", the maximum value for the "statuscode" column is 9. I cannot add up the numbers.
Thank you very much in advance!
Rho
