How to 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.

Product:

Dynamics 365 for Finance and Operations

Steps:

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s