web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Understands Dynamics G...
Microsoft Dynamics GP (Archived)

Understands Dynamics GP 2013 Tables and fields in detail.

(0) ShareShare
ReportReport
Posted on by Preetham theGP 17

Hello,

I am new to GP, can someone please suggest a book or a website to have detailed information on gp tables and fields. for example, I am working on RM30201 table and i have a question of possible values for APFRDCTY(apply from document type) but i am not finding this information any where in online in same way i have questions on lot of fields. So far i have tried below steps, Thanks in advance for your help.

--> DynamicsGP--> Tools --> Resource description --> Tables/Fileds 

--> victoriayudin.com/.../rm-tables

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    Preetham -

    You may also find dyndeveloper.com/default.aspx useful. It has additional information on tables, but has subscription based pricing for full access.  

    If you have SmartList Builder installed, there is a very cool tool, called Table Finder that installs with it.  

    www.eonesolutions.com/.../the-easiest-way-to-find-tables-in-gp-table-finder-smartlist-builder

  • Preetham theGP Profile Picture
    Preetham theGP 17 on at

    Harry,

    Thanks for your response. I already checked dyndeveloper.com and i am also ready to take subscription but i am not sure how much in detail their explanation would be and 2nd option won't work for me since SmartList Builder is not installed . Having said that, i have only one option to take subscription of dyndeveloper.com and to give it a try but i am really surprised why Microsoft is not maintaining the document which would be handy for all GP developers across the globe or am i missing something ?

  • Verified answer
    Tim W Profile Picture
    Tim W 2,925 on at

    What I usually do on any version is load out the latest SDK for GP.  You can find it on your media though you might also find it on Customersource (if they have ever fixed it).

    GP2015\Installation Files\Install Media\MDGP2015_R2_DVD_ENUS\Tools\SDK\Dynamics GP\   In it is a self extracting program (small) that will load a set of documentation for you.

    It has diagrams of tables and relationships, version changes but also has a Table Integration set of documents (word docs) and I find I spend 90% of my time in that area when I'm looking for answers similar to questions you are asking.

    The table integration documentation pre dates IM and eConnect and so is a detailed description of work tables you could write records to in the bad old days.   It does not describe open or historical tables (such as RM30201) but you can often extrapolate values back to the field descriptions of the work tables and it's helpful to answer questions such as yours above.

    From the RMTRX word doc for values in RM_Sales_Work:

               

    Field descriptions: (Required fields appear in bold and are underlined)

     

    Document Type:          Stores the value from the selected position of the Document Type drop-down list. This is stored in the work table to allow for future reordering of the Document Type list

     

    Field values:

                    1 = Invoice

                                        2 = Finance Charge

                                        3 = Miscellaneous Charge

                                        4 = Return

                                        5 = Credit Memo

       6 = Payment

     

    RM Document Type-All:                               Stores the actual document type.

     

     Field values:

                    0 = Reserved for Balance Carried Forward Records

                                        1 = Sales / Invoice

                                        2 = Reserved for Scheduled Payments

                                        3 = Debit Memos

                                        4 = Finance Charges

                                        5 = Service Repairs

                                        6 = Warranties

                                        7 = Credit Memos

                                        8 = Return

       9 = Payments

     

    RM Document Number

    -WORK:                        This is the 17-character editable field for entering document numbers that are unique for this document type. The next default document number for each document type is stored in the RM_Document_Setup table. When the document is created, this field's value should also be stored in the Document Number field.

     

    Etc.....

  • Verified answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    Preetham - the tool Microsoft does maintain is one you mentioned in your original post.  Not all our clients have SmartList Builder (many do), so in a pinch, I maintain a demo machine that has SLB installed, and I can get at the data I need that way. Perhaps you could install SLB, which you should be able to access from the test (TWO) database, without registering it?

  • Suggested answer
    iruser2 Profile Picture
    iruser2 2,048 on at

    Mark Polino has a site with every table in GP with every field in it.  Not the valid values for those fields, but it is inestimable in its value.  Its for GP2013 too!

    mpolino.com/.../excel-based-table-and-field-reference-for-dynamics-gp-2013

  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,095 Most Valuable Professional on at

    You can find information on fields and tables using the steps below:

    blogs.msdn.microsoft.com/.../finding-table-and-field-information-in-microsoft-dynamics-gp

    blogs.msdn.microsoft.com/.../getting-table-and-field-data-out-of-dexterity-dictionaries

    The issue with values for fields is that the information is sometimes only available by checking the source code as it is not documented or there are no static values (for DDLs).

    David

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans