{"id":2700,"date":"2021-06-08T12:50:57","date_gmt":"2021-06-08T12:50:57","guid":{"rendered":"https:\/\/help.hbsoftware365.com\/?p=2700"},"modified":"2021-07-19T09:51:33","modified_gmt":"2021-07-19T09:51:33","slug":"database-structure","status":"publish","type":"post","link":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/exsion-help-eng\/exsion-eng-06-menu-options\/database-structure\/","title":{"rendered":"Database structure"},"content":{"rendered":"\n\n\t\t\t\t<img decoding=\"async\" src=\"http:\/\/help.hbsoftware365.com\/wp-content\/uploads\/ExsionMenu_DatabaseStructure.png\" alt=\"ExsionMenu_DatabaseStructure\" itemprop=\"image\" title=\"ExsionMenu_DatabaseStructure\" onerror=\"this.style.display='none'\"  \/>\n\t<p>This option will create a roadmap from your Dynamics NAV database to provide information about tables, fields, indexes, datatypes and possible joins. When the Excel format box is checked, the information will be displayed in an Excel document instead of a web page.<\/p>\n\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/help.hbsoftware365.com\/wp-content\/uploads\/DatabaseStructure_Connections.png\" alt=\"DatabaseStructure_Connections\" itemprop=\"image\" height=\"402\" width=\"542\" title=\"DatabaseStructure_Connections\" onerror=\"this.style.display='none'\"  \/>\n\t<p>When you click the &#8220;<b>OK<\/b>&#8221; button, all information is shown about the chosen connection.<\/p>\n\t\t\t\t<img decoding=\"async\" src=\"http:\/\/help.hbsoftware365.com\/wp-content\/uploads\/DataseStructure_Browser.png\" alt=\"DataseStructure_Browser\" itemprop=\"image\" title=\"DataseStructure_Browser\" onerror=\"this.style.display='none'\"  \/>\n\t<p>Click on a tablename to see the details about that table.<\/p>\n\t\t\t\t<img decoding=\"async\" src=\"http:\/\/help.hbsoftware365.com\/wp-content\/uploads\/DatabaseStructure_BrowserTable.png\" alt=\"DatabaseStructure_BrowserTable\" itemprop=\"image\" title=\"DatabaseStructure_BrowserTable\" onerror=\"this.style.display='none'\"  \/>\n\t<table>\n<tbody>\n<tr>\n<th>Column<\/th>\n<th>Description<\/th>\n<\/tr>\n<tr>\n<td>Column 1<\/td>\n<td>Row 1 holds the tablename. The other rows are the fieldnames in that table.<\/td>\n<\/tr>\n<tr>\n<td>Column 2<\/td>\n<td>The field numbers. These can be used to find a table when creating a dynamic download or function.<\/td>\n<\/tr>\n<tr>\n<td>Type<\/td>\n<td>The field&#8217;s datatype.<\/td>\n<\/tr>\n<tr>\n<td>Size<\/td>\n<td>Maximum field length.<\/td>\n<\/tr>\n<tr>\n<td>Class<\/td>\n<td>This defines if a field must contain a value or can be left blank.<\/td>\n<\/tr>\n<tr>\n<td>Index<\/td>\n<td>The indexes as defined for this table.<\/td>\n<\/tr>\n<tr>\n<td>SumFields<\/td>\n<td>The SUM fields as defined for this table.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n","protected":false},"excerpt":{"rendered":"<p>This option will create a roadmap from your Dynamics NAV database to provide information about tables, fields, indexes, datatypes and possible joins. When [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[67],"tags":[],"class_list":["post-2700","post","type-post","status-publish","format-standard","hentry","category-exsion-eng-06-menu-options"],"_links":{"self":[{"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/posts\/2700","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/comments?post=2700"}],"version-history":[{"count":4,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/posts\/2700\/revisions"}],"predecessor-version":[{"id":3068,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/posts\/2700\/revisions\/3068"}],"wp:attachment":[{"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/media?parent=2700"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/categories?post=2700"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/tags?post=2700"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}