{"id":9431,"date":"2016-11-07T10:11:36","date_gmt":"2016-11-07T10:11:36","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=9431"},"modified":"2016-11-07T10:11:36","modified_gmt":"2016-11-07T10:11:36","slug":"how-to-find-abbreviations-for-open-tables","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2016\/11\/07\/how-to-find-abbreviations-for-open-tables\/","title":{"rendered":"How to find Abbreviations for all Open Tables"},"content":{"rendered":"<p>You may come across a situation where you would like to know the abbreviations for open tables.\u00a0 Sage ERP X3 has a function called \u201c<strong>fileabre<\/strong>&#8221; which contains the abbreviations for all open tables.<\/p>\n<p><strong>fileabre <\/strong>is an Adonix system variable of the character string type that contains the abbreviations for all tables opened via the File or Local File instruction.<\/p>\n<p>It is sized to 101, and (0) is initialized with the empty string.<\/p>\n<p>The [S]<strong>adxmto<\/strong> variable sets the maximum number of tables that can be open simultaneously (100).<br \/>\n<strong>Syntax<\/strong>:\u00a0\u00a0\u00a0 [S]ffileabre (5) (101) Char<\/p>\n<p><strong>Example:<\/strong><\/p>\n<p>If we want to know the abbreviation of the open tables then kindly refer to the below snippet of code for better understanding.<\/p>\n<p><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2016\/11\/Abbreviations-for-Open-Tables.png\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-9432\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2016\/11\/Abbreviations-for-Open-Tables.png\" alt=\"Abbreviations for Open Tables\" width=\"569\" height=\"111\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Output:<\/p>\n<p><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2016\/11\/Abbreviations-Open-Tables.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-9433\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2016\/11\/Abbreviations-Open-Tables.png\" alt=\"Abbreviations Open Tables\" width=\"250\" height=\"134\" \/><\/a><\/p>\n<p>Hope this helps!<\/p>\n<h4 style=\"text-align: center\"><strong>About Us<\/strong><\/h4>\n<p>&nbsp;<\/p>\n<p>Greytrix is one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.<\/p>\n<p><a href=\"http:\/\/www.greytrix.com\/\" target=\"_blank\">Greytrix<\/a>\u00a0have some unique solutions of\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-x3-integration\" target=\"_blank\">Sage X3\u2019s integration with Sage CRM<\/a>,\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/sage-x3\/gumu-x3-salesforce-integration\" target=\"_blank\">Salesforce.com<\/a>\u00a0and\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/magento-sage-integrations\/sage-x3-magento\" target=\"_blank\">Magento eCommerce<\/a>. It also offers best-in-class\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/erp-development\/sage-x3\" target=\"_blank\">Sage X3 customization and development services<\/a>\u00a0to Sage business partners, end users, and Sage PSG worldwide.<\/p>\n<p>For more information on Sage X3 Integration and Services, please contact us at\u00a0<a href=\"mailto:x3@greytrix.com\" target=\"_blank\">x3@greytrix.com<\/a>\u00a0.We will be glad to assist you.<\/p>\n<p>Also read:<\/p>\n<p>&#8211;\u00a0<a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2016\/07\/25\/how-to-concatenate-two-strings\/\">How to Concatenate Two Strings<\/a><\/p>\n<p>&#8211;\u00a0<a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2016\/02\/20\/how-to-give-space-between-string-by-coding-in-sage-x3\/\">How to give space between string by coding in Sage X3?<\/a><\/p>\n<p>&#8211;\u00a0<a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2016\/02\/20\/how-to-extract-a-substring-from-the-leftmost-end-in-sage-x3\/\">How to extract a substring from the leftmost end in Sage X3?<\/a><\/p>\n<p>&#8211;\u00a0<a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2016\/02\/10\/how-to-add-a-string-in-a-new-line\/\">How to add a string in a new Line in Sage X3?<\/a><\/p>\n<p>&#8211;\u00a0<a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2014\/04\/26\/hiding-fields-in-screen-dynamically\/\">Hiding fields in Screen Dynamically<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>You may come across a situation where you would like to know the abbreviations for open tables.\u00a0 Sage ERP X3 has a function called \u201cfileabre&#8221; which contains the abbreviations for all open tables. fileabre is an Adonix system variable of the character string type that contains the abbreviations for all tables opened via the File\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2016\/11\/07\/how-to-find-abbreviations-for-open-tables\/\">Read More &raquo;<\/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":[8],"tags":[24,1780],"class_list":["post-9431","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","tag-abbreviations-for-all-open-tables","tag-sage-erp-x3"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/9431","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=9431"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/9431\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=9431"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=9431"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=9431"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}