Is there a table that matches table id's to table names?

Finance and Operations/AX Developer Forum
1

I know that I can get the table name from the id by using functions like tableid2pname().

But I’m working on a report outside of AX (using SQL reporting services), so I need to find the underlying table that contains that data. I’m using SysDatabaseLog, which only contains a table id, and I need to be able to limit my report to a particular table.

2

Nevermind.

It looks like that information can be found in BasTableLookup.

3

Hi,

see \System Documentation\Tables\SqlDictionary (AX 3.0)

Regards

Michael