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

Community site session details

Session Id :
Dynamics 365 Community / Blogs / Another blog About Microsoft Dynamics GP / Finding Field Name and Tabl...

Finding Field Name and Table Name of custom table.

Views (3212)
Almas Mahfooz Profile Picture Almas Mahfooz 11,009 User Group Leader

Finding Field Name and Table Name of custom table.

This post is specially for our.NET team members who find it difficult to know field names and table names of custom table when need to use in sql scripts for their add on application for Dynamics GP.

Each time they need to come to some dexterity developer and ask for fields and tables, By similar way they can find field and table information of any GP additional product.

Let take an example of Customer Maintenance. We have added a table evsTable and it's two fields on a window.Field 1 and Field 2.

1

Now what you have to do is to open the window for whose field information you need, lets say we need to know in which table Field 1 will save data and what is the physical name of Field 1 to use in sql.

Just focus on some other field and press Alt+F8 and save macro file anywhere.

2

Now focus Field 1.

Again press Alt+F8.

Now go to the path where you have saved macro file and open it on notepad. You will find field name in it.

3

Now to find the table name, go to below navigation and open a window.

4

Now to find the table name, go to below navigation and open a window.

5

Select the product of your window, if you know the core good otherwise you have to use commonsense for window type, like customer means it must be sales.

6

Now you have table name as well as field information.

:)

Comments

*This post is locked for comments

  • PavanBujji Profile Picture PavanBujji 208
    Posted at
    @Almas. Please verify below Screencast video and please share me if I did any mistake. www.screencast.com/.../gsieo1L0MBfs Thanks, Pavan.
  • Almas Mahfooz Profile Picture Almas Mahfooz 11,009 User Group Leader
    Posted at
    @pavanBujji : I think you haven't focus the field you wanted to know about. But since you have product name, you can just go to Resource description window, select your product name and look for field name. let me know if helps you.
  • PavanBujji Profile Picture PavanBujji 208
    Posted at
    Hi Almas, Thanks for providing this. I have tried to find the custom field (SID#) in Dynamics GP 2010. But I didn't get like which you have shown in Notepad. Could you please help me in this regard. I found the notepad result as below. I don't find any database table in this for the field. ------------------------------------------------------------------------------------------------------ # DEXVERSION=11.00.0221.000 2 2 CheckActiveWin dictionary 'Mibar Modifications' form 'SOP_Entry' window 'SOP_Entry' WindowMove dictionary 'Mibar Modifications' form 'SOP_Entry' window 'SOP_Entry' pointh 131 pointv 89 WindowSize dictionary 'Mibar Modifications' form 'SOP_Entry' window 'SOP_Entry' pointh 0 pointv 0 ActivateWindow dictionary 'Mibar Modifications' form 'SOP_Entry' window 'SOP_Entry' ActivateWindow dictionary 'Mibar Modifications' form 'SOP_Entry' window 'SOP_Entry' ActivateWindow dictionary 'Mibar Modifications' form 'SOP_Entry' window 'SOP_Entry' -------------------------------------------------------------- This comment section is not supported to post the Images.So I'm unable to post the Screenshots. I'm posting the Screencast www.screencast.com/.../KwK6zsE8dhU.If it is not showing anything or error then click on the first link which is shown in error link . Then click on allow. Thanks in advance, Pavan G.