Menu
Each table in the AOT has an ID, how can I discover the table name given an ID?
893
The search box is prominently displayed in the Microsoft Dynamics AX client, and you can view your recent search terms in the drop-down list. When you click the search icon, either in the Microsoft Dynamics AX client or Enterprise Portal for Microsoft Dynamics AX, the search results are displayed on a new page.
In SQL Server a way to retrieve the table id is: SELECT object_id(table_name);
Starting in Microsoft Dynamics AX 2012, all tables have the TableType property that replaces the Temporary property found in Microsoft Dynamics AX 2009 and earlier versions. Use the setTmp table method to make a non-temporary table temporary rather than creating a copy of the table, and then making it temporary.
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
