- [Instructor] Whether you're working with
Dynamics GP creating custom reports,
perhaps in an external reporting tool like SSRS,
or whether you're building integration programs,
if you're really getting into the nitty gritty
of understanding where data is stored in
the back end, in the database and the tables
of Great Plains, or, as it's now called,
Dynamics GP, what you do is click on the
main Microsoft Dynamics GP menu and then
select Tools, Resource Descriptions, and Tables.
And the entire data model of GP becomes
available for you to browse through.
Click on Table.
And you'll see that you can sort by the
physical name, that'll give you the table name.
If you change this to View by Table Physical Name
you are looking at the tables.
These are the names of tables.
You can change the series.
So I can find, for instance,
what is the customer master table?
It's this, RM00101 is the name of that table.
Now you know the name of the table,
so if you're writing a sequel query
against the back end and bypassing the
Dynamics GP graphical user interface,
the gooey, the front end, you're bypassing that,
you now know the table name, RM00101.
And if you click Okay, you'll see all of
the fields within the table.
These are the actual names of the columns
within the sequel table under Physical Name,
and the field name is a more descriptive,
more human readable name to help you
understand what's actually in that field.
It's also helpful when you have a field
that doesn't necessarily contain data,
but it contains some sort of type that
you're trying to understand.
What does that field mean?
So Hold, for instance, if we go to the
Field Info, it would show you that it's
a boolean, meaning zero or one.
Zero being false and one being true.
So that's pretty clear.
But there are other types of fields that
aren't booleans, they're integers,
Post Results To is an example.
Let's go to Field Info and it should show
you the static values, but it doesn't always
show you that, unfortunately.
If you look at a different table,
the account master, and if I look at
the account type, and I go to Field Info,
I can see there are static values here.
That one means a posting account,
a two means a unit account, three,
so that is very useful.
The static values under Field Info.
Unfortunately, it's not always loaded
with that information,
but often it is.
And sometimes it's the only way you can
understand what the meaning of those values
in those fields, especially integer fields, are.