Microsoft Great Plains

Posted on 2005-04-13
Last Modified: 2008-02-26
Hi all, not sure if this is the best area to ask this question but I'll give it a shot.

I am using Microsoft Access to interrogate the tables within our Great Plains system. However, there are so so many of them I cannot easily work out the table schema, what joins to where and when! Does anyone know of the key tables? Or where I can find a decent schema from?

Thanks in advance.
Question by:robfromplymouth
    1 Comment
    LVL 14

    Accepted Solution

    If you have installed the SDK for Great Plains, there's a folder that's installed named Erwin and it has both the logical and physical data models both in Erwin and PDF's.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now