{"id":5023,"date":"2013-10-18T12:54:11","date_gmt":"2013-10-18T12:54:11","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=5023"},"modified":"2013-10-18T12:54:11","modified_gmt":"2013-10-18T12:54:11","slug":"quick-look-on-sage-crm-tables","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/18\/quick-look-on-sage-crm-tables\/","title":{"rendered":"Quick look on Sage CRM tables"},"content":{"rendered":"

In this blog we will have a quick look at some of the important and essential tables of Sage CRM.
\nGUMU :<\/span><\/strong>\u00a0Integrate your Sage 500 ERP system with latest Sage CRM\u00a0– Realtime<\/a><\/strong><\/span>
\n<\/a>
\nIn Sage CRM, entity data is stored into the tables with identical name.
\nFor example,
\n1. Company entity data is stored into the Company table.
\n2. Person entity data is stored into the Person table and so on.
\nHowever there are some tables which do not follow above pattern. However they are equally important.
\nA) Translation Tables<\/strong>
\nB) Reports Tables<\/strong>
\nC) Workflow Tables<\/strong>
\nA) Translation Tables
\n<\/strong>1) Custom_Captions: Stores each of the caption value existing in Sage CRM.
\n2) Custom_ContainerItems: Stores block and list entries which are used in the dashboards.
\n3) Custom_Database: Stores entries of other databases which are linked from within Sage CRM.
\n4) Custom_Edits: Stores all entries of all fields of all tables.
\n5) Custom_EmailAddress: Stores E-mail aliases setup in Sage CRM.
\n6) Custom_Lists: Stores all the Lists created along with their fields added to the list.
\n7) Custom_Pages: Stores information of special HTML pages used in Sage CRM.
\n8) Custom_Relationships: This table contains the linking of the different table. Most of the relationships are the primary key and foreign key. We cannot access this information in Sage CRM.
\n9) Custom_ScreenObjects: Stores all Lists, Blocks, Tabs, Groups and Screens entries available in CRM.
\n10) Custom_Screens: Stores entries of fields of all screens.
\n11) Custom_SysParams: Stores Global variables used in Sage CRM.
\n12) Custom_Tables: Stores tables created in Sage CRM.
\n13) Custom_Tabs: Stores information of Tabs of each entity.
\n14) Custom_Views: Stores all views available in sage CRM.
\nB) Reports Tables:
\n<\/strong>1) Custom_Reports: Stores Sage CRM reports information.
\n2) Custom_ReportFields: Stores information of fields used in all the reports.
\n3) Custom_ReportBands: Stores detail record or body record for the report.
\n4) Custom_ReportCharts: Stores information of reports which has Chart defined in report settings.
\n5) Custom_ReportFavourites: Stores information of all Favorite reports of user.
\n6) Custom_ReportGroups: Stores information of reports that has Group By clause.
\n7) Custom_ReportSearches: Stores all saved search options.
\nC) Workflow Tables:
\n<\/strong>1) Workflow: Stores all workflow existing in Sage CRM.
\n2) WorkflowRules: Stores all the rules of all workflow.
\n3) WorkflowState: Stores all states of all workflow.
\n4) WorkflowAction: Stores all actions that are defined in the workflow rules.
\n5) WorkflowInstance: Stores current instance\/state of an entity.
\n6) WorkflowTransition: Stores records of current state and its next state ID for all workflow.
\n7) WorkflowActionLinks: Updates done in related with workflow action records are done in this table.
\n8) WorkflowHistory: Stores all actions performed for all the workflow.
\nNote:<\/strong> Please ensure you have a proper backup before you try updating in the above tables.
\nAlso Read:<\/strong>
\n1) Run SQL Queries through Sage CRM Components<\/a>
\n2) Permissions To Modify The CRM Configurations<\/a>
\n3) Control tab display using multiple SQL clauses<\/a>
\n4) How to access views of Different Database in CRM<\/a>
\n5) Enable external access for CRM entities from within CRM<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

In this blog we will have a quick look at some of the important and essential tables of Sage CRM. GUMU :\u00a0Integrate your Sage 500 ERP system with latest Sage CRM\u00a0– Realtime In Sage CRM, entity data is stored into the tables with identical name. For example, 1. Company entity data is stored into the\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":[102,332,393],"tags":[2400],"class_list":["post-5023","post","type-post","status-publish","format-standard","hentry","category-database-sage-crm","category-sage-crm","category-tables","tag-tabels"],"yoast_head":"\nQuick look on Sage CRM tables - 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\/10\/18\/quick-look-on-sage-crm-tables\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Quick look on Sage CRM tables - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In this blog we will have a quick look at some of the important and essential tables of Sage CRM. GUMU :\u00a0Integrate your Sage 500 ERP system with latest Sage CRM\u00a0– Realtime In Sage CRM, entity data is stored into the tables with identical name. For example, 1. Company entity data is stored into the\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/18\/quick-look-on-sage-crm-tables\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2013-10-18T12:54:11+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=\"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\/10\/18\/quick-look-on-sage-crm-tables\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/18\/quick-look-on-sage-crm-tables\/\",\"name\":\"Quick look on Sage CRM tables - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2013-10-18T12:54:11+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/18\/quick-look-on-sage-crm-tables\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/18\/quick-look-on-sage-crm-tables\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/18\/quick-look-on-sage-crm-tables\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Quick look on Sage CRM tables\"}]},{\"@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":"Quick look on Sage CRM tables - 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\/10\/18\/quick-look-on-sage-crm-tables\/","og_locale":"en_US","og_type":"article","og_title":"Quick look on Sage CRM tables - Sage CRM \u2013 Tips, Tricks and Components","og_description":"In this blog we will have a quick look at some of the important and essential tables of Sage CRM. GUMU :\u00a0Integrate your Sage 500 ERP system with latest Sage CRM\u00a0– Realtime In Sage CRM, entity data is stored into the tables with identical name. For example, 1. Company entity data is stored into the\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/18\/quick-look-on-sage-crm-tables\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2013-10-18T12:54:11+00:00","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\/10\/18\/quick-look-on-sage-crm-tables\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/18\/quick-look-on-sage-crm-tables\/","name":"Quick look on Sage CRM tables - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2013-10-18T12:54:11+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/18\/quick-look-on-sage-crm-tables\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/18\/quick-look-on-sage-crm-tables\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/18\/quick-look-on-sage-crm-tables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Quick look on Sage CRM tables"}]},{"@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\/5023","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=5023"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/5023\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=5023"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=5023"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=5023"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}