{"id":5894,"date":"2013-11-30T06:51:33","date_gmt":"2013-11-30T06:51:33","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=5894"},"modified":"2013-11-30T06:51:33","modified_gmt":"2013-11-30T06:51:33","slug":"how-address-company-person-links-are-stored","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/30\/how-address-company-person-links-are-stored\/","title":{"rendered":"How Address, Company Person links are stored"},"content":{"rendered":"

As you know, SageCRM supports multiple addresses to be created against the Company, Person records. We can also select address types etc. However whenever you want to create these records from COM\/DOTNET API, first question comes to mind is how to store these values.
\nThe New Stuff:<\/strong><\/em><\/span> Change Default dedupe behaviour<\/a>
\nLet us consider New company screen for better understanding.<\/p>\n

\"Img1\"<\/a><\/p>\n

When we save these details, Address details don\u2019t go into Company<\/b> table, rather they are saved in Address<\/b> table. Their relationship\/<\/b>linking are present in \u201cAddress_Link<\/b>\u201d table. So in order to link Company <\/b>with Address<\/b>, you need to first create record in Address<\/b> table and then create a link in \u201cAddress_Link<\/b>\u201d table.
\nAs you can see below, there is a section called \u201cType<\/b>\u201d in Address panel which contains \u201cCheck Boxes<\/b>\u201d under it. Now I will explain you how entries are created in \u201cAddress_Link<\/b>\u201d table based on above \u201cCheck Boxes<\/b>\u201d. Let\u2019s understand it one by one<\/p>\n

\"Img2_1\"<\/a><\/p>\n

\u00a0Case 1:-<\/b> When nothing is selected from available check boxes. Please refer below screen which explains how data is stored in \u201cCompany<\/b>\u201d ,\u201dAddress<\/b>\u201d and \u201cAddress<\/b> Link<\/b>\u201d table .<\/p>\n

DATA IN COMPANY TABLE:-<\/b>\"Img4\"<\/a>
\nDATA IN ADDRESS TABLE:-<\/b>\"Img5\"<\/a>
\nDATA IN ADDRESS LINK TABLE:-<\/b>\"Img6\"<\/a>
\nCase 2:-<\/b>When only \u201cBusiness<\/b>\u201d type is selected.<\/p>\n

DATA IN COMPANY TABLE:-<\/b>\"Img7\"<\/a><\/p>\n

DATA IN ADDRESS TABLE:-\"Img8\"<\/a><\/b><\/p>\n

DATA IN ADDRESS LINK TABLE:-<\/b>\"Img9\"<\/a><\/p>\n

Case 3:-<\/b>When only \u201cBilling<\/b>\u201d type is selected.<\/p>\n

DATA IN COMPANY TABLE:-<\/b>\"Img10\"<\/a><\/p>\n

DATA IN ADDRESS TABLE:-\"Img11\"<\/a><\/b><\/p>\n

DATA IN ADDRESS LINK TABLE:-<\/b>\"Img12\"<\/a><\/p>\n

Case 4:-<\/b>When only \u201cShipping<\/b>\u201d type is selected.<\/p>\n

DATA IN COMPANY TABLE:-<\/b>\"Img13\"<\/a><\/p>\n

DATA IN ADDRESS TABLE:- \"Img14\"<\/a><\/b><\/p>\n

DATA IN ADDRESS LINK TABLE:-<\/b>\"Img15\"<\/a><\/p>\n

Case 5:-<\/b>When \u201cBusiness<\/b>\u201d and \u201cBilling<\/b>\u201d type is selected.<\/p>\n

DATA IN COMPANY TABLE:-<\/b>\"Img16\"<\/a><\/p>\n

DATA IN ADDRESS TABLE:-<\/b>\"Img17\"<\/a><\/p>\n

DATA IN ADDRESS LINK TABLE:-\"Img18\"<\/a><\/b><\/p>\n

Case 6:-<\/b>When \u201cBusiness<\/b>\u201d and \u201cShipping<\/b>\u201d type is selected.<\/p>\n

DATA IN COMPANY TABLE:-<\/b>\"Img19\"<\/a><\/p>\n

DATA IN ADDRESS TABLE:-<\/b>\"Img20\"<\/a><\/p>\n

DATA IN ADDRESS LINK TABLE:-<\/b> \"Img21\"<\/a><\/p>\n

Case 7:-<\/b>When \u201cBilling<\/b>\u201d and \u201cShipping<\/b>\u201d type is selected.<\/p>\n

DATA IN COMPANY TABLE:-<\/b>\"Img22\"<\/a><\/p>\n

DATA IN ADDRESS TABLE:-<\/b>\"Img23\"<\/a><\/p>\n

DATA IN ADDRESS LINK TABLE:-<\/b>\"img24\"<\/a><\/p>\n

Case 8:-<\/b>When \u201cBusiness<\/b>\u201d, \u201cBilling<\/b>\u201d and \u201cShipping<\/b>\u201d type is selected.<\/p>\n

DATA IN COMPANY TABLE:-<\/b>\"Img25\"<\/a><\/p>\n

DATA IN ADDRESS TABLE:-<\/b>\"Img26\"<\/a><\/p>\n

DATA IN ADDRESS LINK TABLE:-<\/b>\"Img27\"<\/a><\/p>\n

You can see throughout the above explanation that 2 records are created in Address_Link<\/b> table. One entry has only company id and another has Company Id as well as Person Id. You need to write your API methods in such way that you create similar entries in tables as explained above, so that the functionality of SageCRM is not broken in any scenario.
\nAlso Read:<\/em><\/strong><\/span>
\n1) Hide Type field in Address panel of Sage CRM<\/a>
\n2) How to add the Mobile Phone and Private Phone fields to the views being used by Find screens, Reports and Groups<\/a>
\n3) How the address is arranged over multiple lines?<\/a>
\n4) 3 Easy Steps to Add Sage CRM Custom Entity in Advanced Find<\/a>
\n5) Create Document Template in Sage CRM 7.1 SP2 and SageCRM 7.2<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

As you know, SageCRM supports multiple addresses to be created against the Company, Person records. We can also select address types etc. However whenever you want to create these records from COM\/DOTNET API, first question comes to mind is how to store these values. The New Stuff: Change Default dedupe behaviour Let us consider New\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":[18,71,285,332,1],"tags":[530,720,1530,1761],"class_list":["post-5894","post","type-post","status-publish","format-standard","hentry","category-address-sage-crm","category-company","category-person","category-sage-crm","category-uncategorized","tag-address","tag-company","tag-linking","tag-person"],"yoast_head":"\nHow Address, Company Person links are stored - 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\/2013\/11\/30\/how-address-company-person-links-are-stored\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Address, Company Person links are stored - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"As you know, SageCRM supports multiple addresses to be created against the Company, Person records. We can also select address types etc. However whenever you want to create these records from COM\/DOTNET API, first question comes to mind is how to store these values. The New Stuff: Change Default dedupe behaviour Let us consider New\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/30\/how-address-company-person-links-are-stored\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2013-11-30T06:51:33+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/Img11.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=\"2 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\/2013\/11\/30\/how-address-company-person-links-are-stored\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/30\/how-address-company-person-links-are-stored\/\",\"name\":\"How Address, Company Person links are stored - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/30\/how-address-company-person-links-are-stored\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/30\/how-address-company-person-links-are-stored\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/Img11.jpg\",\"datePublished\":\"2013-11-30T06:51:33+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/30\/how-address-company-person-links-are-stored\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/30\/how-address-company-person-links-are-stored\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/30\/how-address-company-person-links-are-stored\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/Img11.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/Img11.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/30\/how-address-company-person-links-are-stored\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Address, Company Person links are stored\"}]},{\"@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 Address, Company Person links are stored - 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\/2013\/11\/30\/how-address-company-person-links-are-stored\/","og_locale":"en_US","og_type":"article","og_title":"How Address, Company Person links are stored - Sage CRM \u2013 Tips, Tricks and Components","og_description":"As you know, SageCRM supports multiple addresses to be created against the Company, Person records. We can also select address types etc. However whenever you want to create these records from COM\/DOTNET API, first question comes to mind is how to store these values. The New Stuff: Change Default dedupe behaviour Let us consider New\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/30\/how-address-company-person-links-are-stored\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2013-11-30T06:51:33+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/Img11.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/30\/how-address-company-person-links-are-stored\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/30\/how-address-company-person-links-are-stored\/","name":"How Address, Company Person links are stored - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/30\/how-address-company-person-links-are-stored\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/30\/how-address-company-person-links-are-stored\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/Img11.jpg","datePublished":"2013-11-30T06:51:33+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/30\/how-address-company-person-links-are-stored\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/30\/how-address-company-person-links-are-stored\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/30\/how-address-company-person-links-are-stored\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/Img11.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/Img11.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/30\/how-address-company-person-links-are-stored\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"How Address, Company Person links are stored"}]},{"@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\/5894","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=5894"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/5894\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=5894"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=5894"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=5894"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}