{"id":10503,"date":"2015-06-18T13:20:27","date_gmt":"2015-06-18T13:20:27","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=10503"},"modified":"2015-06-18T13:20:27","modified_gmt":"2015-06-18T13:20:27","slug":"how-sage-crm-changed-structure-of-phone-and-email-in-sage-crm-7-2","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/06\/18\/how-sage-crm-changed-structure-of-phone-and-email-in-sage-crm-7-2\/","title":{"rendered":"How Sage CRM changed Structure of Phone and Email in Sage CRM 7.2"},"content":{"rendered":"

Hi folks! You all must be familiar with the following entities in CRM \u201dEmail\u201d, \u201cEmail Link\u201d, \u201cPerson\u201d ,\u201cPerson Link\u201d ,\u201dphone\u201d<\/strong> and \u201cPhone Link\u201c<\/strong> table .These are the tables where person\u2019s and company\u2019s communicated related details are saved. But when you want to check one of these details in database for the related company or person we have to make use of joins to fetch the required data accordingly, which becomes very tedious. In this blog I will explain you the new way how you can achieve the above work.
\nRelated Post: <\/strong>Phone and Email Structure Changed in Sage CRM7.1<\/a>
\nSage has introduced a new table in CRM 7.2 version onwards named as \u201cCRMEmailPhoneData\u201d.<\/strong> These table stores the data related to Person, Company, Email and Phone. So by simply using select query on this table you will get the data in one go. So, no need to link several tables to get the data\u2019s.
\nTo make my point more clearly here below I am attaching a screen shot of attributes\/columns present in \u201cCRMEmailPhoneData\u201d<\/strong> table.
\nselect * from CRMEmailPhoneData (nolock) where epd_Deleted is null<\/strong><\/em>
\n\"Blog1\"<\/a>
\n<\/a>
\nHope you liked it!
\nAlso Read:<\/strong>
\n1. Phone Email block on a single screen<\/a>
\n2. Rearrange Phone\/Email Screen on Company Summary tab<\/a>
\n3. Multiple Phone Number Entry for a Person<\/a>
\n4. How Address, Company Person links are stored<\/a>
\n5. Enhance Phone-Email Tab with additional functionality as per User\u2019s requirement.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Hi folks! You all must be familiar with the following entities in CRM \u201dEmail\u201d, \u201cEmail Link\u201d, \u201cPerson\u201d ,\u201cPerson Link\u201d ,\u201dphone\u201d and \u201cPhone Link\u201c table .These are the tables where person\u2019s and company\u2019s communicated related details are saved. But when you want to check one of these details in database for the related company or person\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[102,332],"tags":[1042,1770,2402,2404],"class_list":["post-10503","post","type-post","status-publish","format-standard","hentry","category-database-sage-crm","category-sage-crm","tag-email","tag-phone-table","tag-table","tag-table-structure"],"yoast_head":"\nHow Sage CRM changed Structure of Phone and Email in Sage CRM 7.2 - 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\/2015\/06\/18\/how-sage-crm-changed-structure-of-phone-and-email-in-sage-crm-7-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Sage CRM changed Structure of Phone and Email in Sage CRM 7.2 - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Hi folks! You all must be familiar with the following entities in CRM \u201dEmail\u201d, \u201cEmail Link\u201d, \u201cPerson\u201d ,\u201cPerson Link\u201d ,\u201dphone\u201d and \u201cPhone Link\u201c table .These are the tables where person\u2019s and company\u2019s communicated related details are saved. But when you want to check one of these details in database for the related company or person\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/06\/18\/how-sage-crm-changed-structure-of-phone-and-email-in-sage-crm-7-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2015-06-18T13:20:27+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/06\/Blog1.jpg\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/06\/18\/how-sage-crm-changed-structure-of-phone-and-email-in-sage-crm-7-2\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/06\/18\/how-sage-crm-changed-structure-of-phone-and-email-in-sage-crm-7-2\/\",\"name\":\"How Sage CRM changed Structure of Phone and Email in Sage CRM 7.2 - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/06\/18\/how-sage-crm-changed-structure-of-phone-and-email-in-sage-crm-7-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/06\/18\/how-sage-crm-changed-structure-of-phone-and-email-in-sage-crm-7-2\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/06\/Blog1.jpg\",\"datePublished\":\"2015-06-18T13:20:27+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/06\/18\/how-sage-crm-changed-structure-of-phone-and-email-in-sage-crm-7-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/06\/18\/how-sage-crm-changed-structure-of-phone-and-email-in-sage-crm-7-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/06\/18\/how-sage-crm-changed-structure-of-phone-and-email-in-sage-crm-7-2\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/06\/Blog1.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/06\/Blog1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/06\/18\/how-sage-crm-changed-structure-of-phone-and-email-in-sage-crm-7-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Sage CRM changed Structure of Phone and Email in Sage CRM 7.2\"}]},{\"@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":"How Sage CRM changed Structure of Phone and Email in Sage CRM 7.2 - 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\/2015\/06\/18\/how-sage-crm-changed-structure-of-phone-and-email-in-sage-crm-7-2\/","og_locale":"en_US","og_type":"article","og_title":"How Sage CRM changed Structure of Phone and Email in Sage CRM 7.2 - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Hi folks! You all must be familiar with the following entities in CRM \u201dEmail\u201d, \u201cEmail Link\u201d, \u201cPerson\u201d ,\u201cPerson Link\u201d ,\u201dphone\u201d and \u201cPhone Link\u201c table .These are the tables where person\u2019s and company\u2019s communicated related details are saved. But when you want to check one of these details in database for the related company or person\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/06\/18\/how-sage-crm-changed-structure-of-phone-and-email-in-sage-crm-7-2\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2015-06-18T13:20:27+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/06\/Blog1.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/06\/18\/how-sage-crm-changed-structure-of-phone-and-email-in-sage-crm-7-2\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/06\/18\/how-sage-crm-changed-structure-of-phone-and-email-in-sage-crm-7-2\/","name":"How Sage CRM changed Structure of Phone and Email in Sage CRM 7.2 - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/06\/18\/how-sage-crm-changed-structure-of-phone-and-email-in-sage-crm-7-2\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/06\/18\/how-sage-crm-changed-structure-of-phone-and-email-in-sage-crm-7-2\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/06\/Blog1.jpg","datePublished":"2015-06-18T13:20:27+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/06\/18\/how-sage-crm-changed-structure-of-phone-and-email-in-sage-crm-7-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/06\/18\/how-sage-crm-changed-structure-of-phone-and-email-in-sage-crm-7-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/06\/18\/how-sage-crm-changed-structure-of-phone-and-email-in-sage-crm-7-2\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/06\/Blog1.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/06\/Blog1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/06\/18\/how-sage-crm-changed-structure-of-phone-and-email-in-sage-crm-7-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"How Sage CRM changed Structure of Phone and Email in Sage CRM 7.2"}]},{"@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\/10503","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=10503"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/10503\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=10503"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=10503"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=10503"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}