Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
paulchacko 4/14/2017 3:31:58 PM

Find table and field a particular value reside

* This article, and all our great SQL (General) documentation, Is available on the SQL (General) menu
There are times (when we create a report in Crystal or SSRS or run an update statement in SQL), we want to know in which table and field a particular value resides. It can be a tedious and boring process to sift through all the table & field suspects in the DB.

Let's take an example. I want to update all the CHECKBOOK ID fields for all the Customers in the DB. I want to run an UPDATE statement such as:

UPDATE [TABLE] SET [XXXXX] WHERE CHECKBOOKID = 'BANKOFNY' and CUSTNMBR ='ABCD001'

But I do not know what fields in the RM00100 needs to be updated.

4Penny.net
Version: GP 8,GP 10,GP 2010,GP 2013,GP 2015
Section: Dynamics GP,VBA,Report Writer,SQL Scripts,Crystal Reports,SSRS






Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables