How to find a table name by ID in Dynamics AX

axapta dynamics-ax-2009
David picture David · Jan 8, 2010 · Viewed 69k times · Source

Each table in the AOT has an ID, how can I discover the table name given an ID?

Answer

DAX picture DAX · Oct 11, 2012

Looking at the SQL dictironary is really the correct method. Search for the line with the FieldId equal to 0. Using TSQL this will tell the name of the table for tableid 505

select NAME 
  from SQLDICTIONARY
 where TABLEID = 505
   and FIELDID = 0

Related questions

Can I code in .NET/C# for Microsoft Dynamics AX?

I am a C# developer and want to start learning Dynamics AX. Please guide me can I use my .net/C# skills (knowledge of API) in Dynamics AX ? I know AX is developed in X++ but some one tell me …

Read More
How to pass a parameter between two forms in Axapta?

How can i pass a single parameter between a form in axapta ? I want to run a Form B from a clicked button event in a Form A and pass... for example the customer id ? How can i read it …

Read More
Finding the Total Available and Available physical for an Item/Warehouse

I have a method for a display field which does the following; return InventSum::find(_salesLine.ItemId, InventDim::_salesLine.InventDimId).AvailPhysical(); This gives me the on-hand Available Physical for the line site/warehouse/location. I need to see the total …

Read More