Open Forum

Expand all | Collapse all

Finding Source of Tables in GP

  • 1.  Finding Source of Tables in GP

    GPUG ALL STAR
    Posted 21 days ago

    We ran GP Power Tools' Database Validation which surfaced a number of tables that exist in our GP database that didn't ie to anything in the dictionary.

    I know what the typical table prefixes stand for & their source (PM, GL, AA, etc) but is anyone aware of a source that perhaps lists all known GP & ISV table prefixes? I know this might be impractical to have ever been assembled but figured I'd throw the question out there...

    In our situation, I'm confident that what's out there is old ISV tables but I'd love to be able to pinpoint which one & ultimately rid our DB of the junk.




    ------------------------------
    Kyle Malone, CPA
    ⭐GPUG Allstar | Chapter Leader - Louisiana (New Orleans)
    GP Admin - CGB Enterprises, Inc.
    Lead Consultant/Blogger - https://alacarteGP.com
    Solugence | Find the software that FITS your business + integrates with GP. https://solugence.com
    ------------------------------
    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


  • 2.  RE: Finding Source of Tables in GP

    GOLD CONTRIBUTOR
    Posted 20 days ago
    While ISV sound a bit odd, check what other 3rd party products are running on the system.
    Did your current/past VAR do any development for you that required adjunct tables to support that development.
    We generally named tables something that would indicate it belonged to the client company.  For instance if we did something for your company, CGB, we would have named tables CGB00100, CGB00101, CGB00200, etc.,
    I hope this helps

    Happy New Year!

    Stay safe


    ------------------------------
    Tim Andaya
    Strategic Systems Group
    "There are no stupid questions."
    ------------------------------

    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


  • 3.  RE: Finding Source of Tables in GP

    GOLD CONTRIBUTOR
    Posted 20 days ago
    Hi Kyle,

    There are a couple ways to see the tables that compose of the data you are looking for.  Here are screen shots of those ways.  The first is using the built in GP resource.
    This will allow you to select the dictionary that you want information on.

    Next is using the utility provided if you have Smartlist builder.  Any window you open can be diagnosed with the corresponding tables attached.

    Now you can see all the tables that are used on that screen

    Hope this helps.
    Mike

    ------------------------------
    Michael Taranto, CPA
    President
    ERP Consulting, LLC
    Pataskala, OH 43062
    614-342-0098 mtaranto@erpconsultingLLC.com
    erpconsultingllc.com
    ------------------------------

    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


  • 4.  RE: Finding Source of Tables in GP

    GPUG ALL STAR
    Posted 20 days ago
    Hi All

    GP Power Tools Database Validation can identify tables that exist at the SQL level but don't have an associated Dexterity table definition in the loaded product dictionary.

    GP Power Tools also has an extremely powerful Resource Information window with Resource Explorer as will as a new Resource Finder window (Build 28 onwards).

    However, if the tables are not included in a dictionary then the built in Resource Description windows or the GPPT windows will not help as they can only see the definitions of tables in the loaded dictionaries.

    Can you provide examples of the names of the tables you have found?

    Regards

    David


    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------

    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


  • 5.  RE: Finding Source of Tables in GP

    GPUG ALL STAR
    Posted 20 days ago
    Kyle,

    this site is a good starting point (includes a few of the ISVs)
    http://dyndeveloper.com/DynModule.aspx

    ------------------------------
    Zubin Gidwani
    Dynamic Budgets
    San Francisco-Bay Area CA
    ------------------------------

    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


If you've found this thread useful, dive deeper into User Group community content by role