How Do I Find a Table Name Using the Table ID for Docuref and Attachments?

The purpose of this article is to provide a guide to finding a table's name when you only have the table ID in Dynamics 365. This is a process that can be used when an attachment is added in Dynamics 365 but the name of the table is needed for the Lasernet Connector attachments setup or when using the Docuref table which uses RefTableID. Alternatively, this can be used to find the table ID when you have the table name.

Steps

1. Use SysTableBrowser to open the SysTableIdView and find your table name with the table ID. On the browser, add the following to your URL:&mi=SysTableBrowser&TableName=SysTableIdView

This will open the table which contains the Id and Name column.

2. Here, you can click the Id column and search for the table ID using the standard Dynamics 365 filtering options.

Example

You have added an attachment, in this case an image, to an area in Dynamics 365 and want to add this as an attachment on a Lasernet report. Follow these steps:

1. Click the paper clip icon to open the attachments for the record.

2. Right-click anywhere on the form and select Form information > Form name.

A form information dialog will come up.

3. Scroll down to the Administration FastTab and get the RefTableId number from the Query statement.

4. Use SysTableBrowser to open the SysTableIdView and find your table name with the table ID and add this to your URL: &mi=SysTableBrowser&TableName=SysTableIdView.

5. Now that you have the table name, you can open your query report's Query wizard, add the needed table, and configure the attachments.