Role of “CRMEmailPhoneData” table in Sage CRM

By | May 4, 2017

Each application have a backend (SQL, Oracle etc.). A database is a collection of information that is organized so that it can easily be accessed, managed and updated. In Sage CRM different tables are available, each table contains different data information. Tables are nothing but the collection of rows and columns as we already know. While working on CRM Database one of the table caught my attention. Table name is “CRMEmailPhoneData”.

New Stuff: Greytrix Sage CRM CTI Framework

As per the table name, table contains records related to Business Email, Business Phone Numbers and Fax Phone Numbers.  While working on same we got more information related to that table are as below.

  1. In this table whenever we create the record for company and person with phone and email address it will add those records into the table. For company entity it will add record with epd_EntityId =5 and for Person entity it will save the record with epd_EntityId =13.
  2. Similarly it will save only Business Email address into epd_EmailAddress column but if we keep Business Email address as blank and add other email address like Sales and Support into company or person then it will not add those Email addresses into epd_EmailAddress table. Changes to other types of records will be ignored by the triggers. E.g. if we update the Sales phone number there will be no change in the CRMEmailPhoneData table.
  3. Also in this table there is another column name as epd_RecordId. For company record this column will add company ID (comp_companyID) and for person record this will add person ID (pers_PersonId).
  4. epd_PhoneId column contain Phone Id (phon_PhoneId) and epd_FaxId column contain Fax Id which is nothing but same field as phone Id field (phon_PhoneId).

This table is maintained by triggers on PhoneLink and EmailLink table. It‘s never updated automatically.

About Us
Greytrix a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix offers unique GUMU™ integrated solutions of Sage 300 with Sage CRM, Salesforce.com and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration service for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and in Sage 300c development services we offer services such as upgrades of older codes and screens to new web screens, newer integrations using sdata and web services  to Sage business partners, end users and Sage PSG worldwide. Greytrix offers over 20+ Sage 300 productivity enhancing utilities that we can help you with such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East.

For more details on Sage 300 and 300c Services, please contact us at accpac@greytrix.com. We will be glad to assist you.