Phone and Email Structure Changed in Sage CRM7.1

By | April 21, 2011

In the Sage CRM version we found that Sage has done away with the Pers_PhoneCountryCode, Pers_PhoneAreaCode and Pers_PhoneNumber fields for phone and Pers_FaxCountryCode, Pers_FaxAreaCode and Pers_FaxNumber for fax numbers which were part of the person table. Likewise, the pers_emailaddress field has been excluded from the person table.

Now this data would be stored in Phone and PhoneLink table and will be linked to the person in the person table. The phone table would store the phone number and the link table would specify if it was linked to company and/or person. Similarly the Email data is stored in Email and EmailLink table.

Pretty neat!! I never quite understood why CRM was storing the same information at two different places.

So all the customizations/scripts that were referring the phone and email fields better watch our when you do the upgrade. These scripts would tend to crash and hence you will have to make the necessary modification to refer the new fields.

The next thing on my wish list is to enter any number of phone records and should not be restricted to the ones shown on the screen. I can very well have customers who have 2 business phone numbers in my CRM. I wonder when this idea will see the light of the day.

If you find this content useful, please drop us an email at