{"id":14300,"date":"2017-05-04T04:15:57","date_gmt":"2017-05-04T04:15:57","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=14300"},"modified":"2019-03-13T10:33:02","modified_gmt":"2019-03-13T10:33:02","slug":"role-of-crmemailphonedata-table-in-sage-crm","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/05\/04\/role-of-crmemailphonedata-table-in-sage-crm\/","title":{"rendered":"Role of \u201cCRMEmailPhoneData\u201d table in Sage CRM"},"content":{"rendered":"

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 \u201cCRMEmailPhoneData<\/strong>\u201d.<\/p>\n

New Stuff:\u00a0<\/em><\/strong>Greytrix Sage CRM CTI Framework<\/a><\/p>\n

As per the table name, table contains records related to Business Email, Business Phone Numbers and Fax Phone Numbers. \u00a0While working on same we got more information related to that table are as below.<\/p>\n

    \n
  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<\/strong> =5<\/strong> and for Person entity it will save the record with epd_EntityId<\/strong> =13<\/strong>.<\/li>\n
  2. Similarly it will save only Business Email address into epd_EmailAddress<\/strong> column but if we keep Business Email address as blank and add other email address like Sales<\/strong> and Support <\/strong>into company or person then it will not add those Email addresses into epd_EmailAddress<\/strong> 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<\/strong> table.<\/li>\n
  3. Also in this table there is another column name as epd_RecordId. <\/strong>For company record this column will add company ID (comp_companyID<\/strong>) and for person record this will add person ID (pers_PersonId<\/strong>).<\/li>\n
  4. epd_PhoneId<\/strong> column contain Phone Id (phon_PhoneId<\/strong>) and epd_FaxId <\/strong>column contain Fax Id which is nothing but same field as phone Id field (phon_PhoneId<\/strong>).<\/li>\n<\/ol>\n

    This table is maintained by triggers on PhoneLink<\/strong> and EmailLink<\/strong> table. It\u2018s never updated automatically.<\/p>\n

    About Us<\/strong><\/span>
    \n    Greytrix<\/a>\u00a0a 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.<\/p>\n

    Greytrix<\/a>\u00a0offers unique GUMU™ integrated solutions of\u00a0Sage 300 with Sage CRM,<\/a>\u00a0Salesforce.com\u00a0<\/a>and\u00a0Magento eCommerce<\/a>\u00a0along with Sage 300 Migration from\u00a0Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works<\/a>. We also offer best-in-class\u00a0Sage 300 customization and development services<\/a>\u00a0and integration service for applications such as\u00a0POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP<\/a>\u00a0and 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 \u00a0to 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\u00a0GreyMatrix<\/a>,\u00a0Document Attachment<\/a>,\u00a0Document Numbering<\/a>,\u00a0Auto-Bank Reconciliation<\/a>,\u00a0Purchase Approval System<\/a>,\u00a0Three way PO matching<\/a>,\u00a0Bill of Lading<\/a>\u00a0and\u00a0VAT for Middle East<\/a>.<\/p>\n

    For more details on Sage 300 and 300c Services, please contact us at\u00a0accpac@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

    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.\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[83,131,286,332],"tags":[],"class_list":["post-14300","post","type-post","status-publish","format-standard","hentry","category-crm72","category-email","category-phone","category-sage-crm"],"yoast_head":"\nRole of \u201cCRMEmailPhoneData\u201d table in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/05\/04\/role-of-crmemailphonedata-table-in-sage-crm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Role of \u201cCRMEmailPhoneData\u201d table in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"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.\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/05\/04\/role-of-crmemailphonedata-table-in-sage-crm\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-04T04:15:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-03-13T10:33:02+00:00\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/05\/04\/role-of-crmemailphonedata-table-in-sage-crm\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/05\/04\/role-of-crmemailphonedata-table-in-sage-crm\/\",\"name\":\"Role of \u201cCRMEmailPhoneData\u201d table in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2017-05-04T04:15:57+00:00\",\"dateModified\":\"2019-03-13T10:33:02+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/05\/04\/role-of-crmemailphonedata-table-in-sage-crm\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/05\/04\/role-of-crmemailphonedata-table-in-sage-crm\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/05\/04\/role-of-crmemailphonedata-table-in-sage-crm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Role of \u201cCRMEmailPhoneData\u201d table in Sage CRM\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Role of \u201cCRMEmailPhoneData\u201d table in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/05\/04\/role-of-crmemailphonedata-table-in-sage-crm\/","og_locale":"en_US","og_type":"article","og_title":"Role of \u201cCRMEmailPhoneData\u201d table in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","og_description":"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.\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/05\/04\/role-of-crmemailphonedata-table-in-sage-crm\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2017-05-04T04:15:57+00:00","article_modified_time":"2019-03-13T10:33:02+00:00","author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/05\/04\/role-of-crmemailphonedata-table-in-sage-crm\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/05\/04\/role-of-crmemailphonedata-table-in-sage-crm\/","name":"Role of \u201cCRMEmailPhoneData\u201d table in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2017-05-04T04:15:57+00:00","dateModified":"2019-03-13T10:33:02+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/05\/04\/role-of-crmemailphonedata-table-in-sage-crm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/05\/04\/role-of-crmemailphonedata-table-in-sage-crm\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/05\/04\/role-of-crmemailphonedata-table-in-sage-crm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Role of \u201cCRMEmailPhoneData\u201d table in Sage CRM"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/14300","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=14300"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/14300\/revisions"}],"predecessor-version":[{"id":21752,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/14300\/revisions\/21752"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=14300"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=14300"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=14300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}