Microsoft Great Plains

Posted on 2005-04-13
Medium Priority
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

simon_kirk earned 500 total points
ID: 13770685
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Integration Management Part 2
Loops Section Overview

840 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