Finding Table and Field Information in Microsoft Dynamics GP

re: Finding Table and Field Information in Microsoft Dynamics GP

Victoria Yudin — Fri, 10 Oct 2008 14:30:04 GMT

David,

Amazing collection of information!

Victoria

re: Finding Table and Field Information in Microsoft Dynamics GP

David Musgrave — Fri, 10 Oct 2008 18:53:26 GMT

Posting from the Dynamics GP Blogster

http://dynamicsgpblogster.blogspot.com/2008/10/david-musgrave-on-table-auto-stored.html

re: Finding Table and Field Information in Microsoft Dynamics GP

David Musgrave — Sat, 11 Oct 2008 03:23:52 GMT

Posting from Vaidy Mohan's blog

http://vmdyngp.blogspot.com/2008/10/all-about-zdp-resource-info-and-vstools.html

re: Finding Table and Field Information in Microsoft Dynamics GP

David Musgrave — Sat, 11 Oct 2008 03:24:51 GMT

Posting from DynamicAccounting.net

http://msdynamicsgp.blogspot.com/2008/10/lots-of-dynamics-gp-table-resources.html

re: Finding Table and Field Information in Microsoft Dynamics GP

Christina Belding — Sat, 11 Oct 2008 03:54:30 GMT

Exceptional post-thanks so much!

Chris

re: Finding Table and Field Information in Microsoft Dynamics GP

David Musgrave — Tue, 28 Oct 2008 03:28:39 GMT

Posting from the Dynamics GP Blogster

http://dynamicsgpblogster.blogspot.com/2008/10/often-overlooked-yet-powerful-table.html

Lots of Dynamics GP Table Resources

DynamicAccounting.net — Tue, 28 Oct 2008 17:02:04 GMT

New Rule: If you tell me that you can't find table resources for Dynamics GP I will hit you. Well

re: Finding Table and Field Information in Microsoft Dynamics GP

David Musgrave — Mon, 23 Feb 2009 02:53:07 GMT

Posting on Rose Business Systems Blog

http://rbsgp.blogspot.com/2009/02/dynamics-gp-top-technical-support.html

re: Finding Table and Field Information in Microsoft Dynamics GP

Jack — Fri, 29 May 2009 04:06:12 GMT

So, you're saying no translation from meaningful names to XXNNNNN is anywhere else in the database? Then where does it come from?

re: Finding Table and Field Information in Microsoft Dynamics GP

David Musgrave — Tue, 02 Jun 2009 11:15:26 GMT

Hi Jack

The tables are defined using Dexterity and are stored in the application dictionaries, such as Dynamics.dic. The table definitions include the Technical Name (the name used be developers), the Display Name (the name shown to users) and the Physical Name (the name used at the database level).

The information shown in the Table Resources window or the Support Debugging Tools, Resource Information and Resource Explorer windows are all read directly from the Dynamics.dic using Dexterity commands.

It is not stored in any SQL tables.

David

re: Finding Table and Field Information in Microsoft Dynamics GP

John Alexander — Thu, 30 Jul 2009 23:56:00 GMT

Thanks for the great post! I've been trying to find table info for GP Manufacturing without much luck. If you have any resources on that that you could point me towards,I'd be very greatful!

Regards,

John