{"id":17,"date":"2014-01-31T06:16:00","date_gmt":"2014-01-31T06:16:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagemas\/?p=17"},"modified":"2024-06-25T04:55:00","modified_gmt":"2024-06-25T04:55:00","slug":"speed-up-development-by-copying-structure-of-an-existing-table-in-sage-100","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/01\/31\/speed-up-development-by-copying-structure-of-an-existing-table-in-sage-100\/","title":{"rendered":"Speed-up development by copying structure of an existing table in Sage 100"},"content":{"rendered":"
\n
\n

Custom development in Sage 100 has been made quite handy. It provides various features using which one can speed up the development efforts. Today, we are going to discuss one of such feature using which one can easily copy the structure of an existing table.\u00a0<\/p>\n

Let\u2019s look as how can we use it by taking an example. Every module has one common table XX_Options.M4T which has some same columns which stores the value of module set-up configurations. For copying the structure, just follow the below provided steps:\u00a0<\/p>\n<\/div>\n

1. \u00a0Open the NOMADS editor.\u00a0
2. \u00a0Click on the Dictionary >> Maintenance to open the below screen.\u00a0<\/div>\n
\"No<\/a><\/div>\n
3. \u00a0Enter the table name XX_Option, a message box will appear asking for confirmation if it is new data dictionary.\u00a0
4. \u00a0Click yes to create a new table definition.\u00a0
5. \u00a0Now, click on the Utilities >> Import Dictionary\u00a0
6. \u00a0Click on Browse button Point to the Providex.DDF file directory which contains the required table structure.<\/div>\n
\"Copy<\/a><\/div>\n
Select the table name from Dictionary list and click on the Copy button to copy the structure. Here in screen shot copying the columns from AP_Options.M4T to GT_Option.<\/div>\n
\"Data\"<\/a><\/div>\n
\n

Now change the Group and path accordingly and click on the update File button of Data Dictionary Maintenance Screen.<\/p>\n

With these few steps you can copy the structure of an existing table.\u00a0<\/p>\n<\/div>\n<\/div>\n\n\n

Greytrix<\/a> – a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.<\/p>\n\n\n\n

The unique GUMU™<\/a> integration solutions provided by Greytrix for Sage 100 include Sage 100 integration with Sage CRM<\/a>,\u00a0and\u00a0Salesforce.com<\/a>,\u00a0Dynamics 365 CRM<\/a>, the migration solutions include Sage 100 Migration from Sage 50 US<\/a>,\u00a0Sage Intacct<\/a>,\u00a0QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class\u00a0Sage 100 customization and development services\u00a0<\/a>to Sage business partners, end users, and Sage PSG worldwide. Sage 100 product listings by Greytrix include Salesforce \u2013 Sage ERP integration<\/a> available on Salesforce Appexchange<\/a>, Dynamics 365 CRM \u2013 Sage ERP integration<\/a> available on Microsoft Appsource (Free Trial)<\/a>.<\/p>\n\n\n\n

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button. <\/p>\n\n\n\n

For more details on Sage 100 Services, please contact us at sage@greytrix.com<\/a>. We will like to hear from you.<\/p>\n","protected":false},"excerpt":{"rendered":"

Custom development in Sage 100 has been made quite handy. It provides various features using which one can speed up the development efforts. Today, we are going to discuss one of such feature using which one can easily copy the structure of an existing table.\u00a0 Let\u2019s look as how can we use it by taking\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":188,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42,55,59,64,112,119,157,175],"tags":[],"class_list":["post-17","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-copy-table","category-customization","category-data-dictionary","category-ddf","category-m4t","category-mas-90","category-providex","category-sage-100"],"yoast_head":"\nSage 100 to expedite development by duplicating an existing table<\/title>\n<meta name=\"description\" content=\"Find out which one can replicate a table's structure with ease.\" \/>\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\/sagemas\/2014\/01\/31\/speed-up-development-by-copying-structure-of-an-existing-table-in-sage-100\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sage 100 to expedite development by duplicating an existing table\" \/>\n<meta property=\"og:description\" content=\"Find out which one can replicate a table's structure with ease.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/01\/31\/speed-up-development-by-copying-structure-of-an-existing-table-in-sage-100\/\" \/>\n<meta property=\"og:site_name\" content=\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-01-31T06:16:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-25T04:55:00+00:00\" \/>\n<meta name=\"author\" content=\"greysagemas\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagemas\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/01\/31\/speed-up-development-by-copying-structure-of-an-existing-table-in-sage-100\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/01\/31\/speed-up-development-by-copying-structure-of-an-existing-table-in-sage-100\/\",\"name\":\"Sage 100 to expedite development by duplicating an existing table\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/01\/31\/speed-up-development-by-copying-structure-of-an-existing-table-in-sage-100\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/01\/31\/speed-up-development-by-copying-structure-of-an-existing-table-in-sage-100\/#primaryimage\"},\"thumbnailUrl\":\"\",\"datePublished\":\"2014-01-31T06:16:00+00:00\",\"dateModified\":\"2024-06-25T04:55:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\"},\"description\":\"Find out which one can replicate a table's structure with ease.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/01\/31\/speed-up-development-by-copying-structure-of-an-existing-table-in-sage-100\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/01\/31\/speed-up-development-by-copying-structure-of-an-existing-table-in-sage-100\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/01\/31\/speed-up-development-by-copying-structure-of-an-existing-table-in-sage-100\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/01\/31\/speed-up-development-by-copying-structure-of-an-existing-table-in-sage-100\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Speed-up development by copying structure of an existing table in Sage 100\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\",\"name\":\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\",\"description\":\"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/?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\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\",\"name\":\"greysagemas\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/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\":\"greysagemas\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Sage 100 to expedite development by duplicating an existing table","description":"Find out which one can replicate a table's structure with ease.","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\/sagemas\/2014\/01\/31\/speed-up-development-by-copying-structure-of-an-existing-table-in-sage-100\/","og_locale":"en_US","og_type":"article","og_title":"Sage 100 to expedite development by duplicating an existing table","og_description":"Find out which one can replicate a table's structure with ease.","og_url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/01\/31\/speed-up-development-by-copying-structure-of-an-existing-table-in-sage-100\/","og_site_name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","article_published_time":"2014-01-31T06:16:00+00:00","article_modified_time":"2024-06-25T04:55:00+00:00","author":"greysagemas","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagemas","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/01\/31\/speed-up-development-by-copying-structure-of-an-existing-table-in-sage-100\/","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/01\/31\/speed-up-development-by-copying-structure-of-an-existing-table-in-sage-100\/","name":"Sage 100 to expedite development by duplicating an existing table","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/01\/31\/speed-up-development-by-copying-structure-of-an-existing-table-in-sage-100\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/01\/31\/speed-up-development-by-copying-structure-of-an-existing-table-in-sage-100\/#primaryimage"},"thumbnailUrl":"","datePublished":"2014-01-31T06:16:00+00:00","dateModified":"2024-06-25T04:55:00+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728"},"description":"Find out which one can replicate a table's structure with ease.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/01\/31\/speed-up-development-by-copying-structure-of-an-existing-table-in-sage-100\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/01\/31\/speed-up-development-by-copying-structure-of-an-existing-table-in-sage-100\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/01\/31\/speed-up-development-by-copying-structure-of-an-existing-table-in-sage-100\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/01\/31\/speed-up-development-by-copying-structure-of-an-existing-table-in-sage-100\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagemas\/"},{"@type":"ListItem","position":2,"name":"Speed-up development by copying structure of an existing table in Sage 100"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/","name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","description":"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagemas\/?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\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728","name":"greysagemas","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/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":"greysagemas"},"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/17","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/comments?post=17"}],"version-history":[{"count":4,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/17\/revisions"}],"predecessor-version":[{"id":5131,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/17\/revisions\/5131"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/media?parent=17"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/categories?post=17"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/tags?post=17"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}