How to get list of tables with display name and physical name?
Posted on 2008-09-30
There are a few tedious ways to identify the physical table names and their corresponding display names in Great Plains using the interface, but I would like to be able to find the display name that corresponds to the physical name using a SQL query. That way I could use it with my query against the schema to display physical names, display names, and a list of columns and data types. I'm building an interface between GP and another system, and it would be nice not to have to use the Resource Descriptions, and determine the Product and Series before I can get the table associated with the display name. Great Plains, more like Great PAINS!