D365 F&O GET TABLE IDS

PURPOSE:

The purpose of this post is to demonstrate how we can get the table ids out of the development or production environment of Dynamics 365 for Finance and Operations.

 

In AX 2012, we used to find table ids from the properties window for a selected table in AOT, however this option is not available anymore in Dynamics 365 for Finance and Operations for production environments at least. However there is still a way to get table ids fortunately using the SysTableBrowser form. The SQL table SysTableIdView can be queried directly from SQL if it is a development environment or can be viewed from SysTableBrowser form if it is a production environment using the following URL:

https://base-url.sandbox.ax.dynamics.com/?cmp=USMF&mi=SysTableBrowser&tableName=SysTableIdView