Friday, May 3, 2019

How to see enum values in D365

Enum values are unavailable anymore in D365. But we can still find them via SQL.

There are two tables of our interest: EnumValueTable with actual values and EnumIdTable with IDs; the latter can be found by a given name, for example, for LedgerPostingType.


USE [AxDB]
GO
SELECT * from ENUMVALUETABLE
 join ENUMIDTABLE
 on enumid = id
 and ENUMIDTABLE.NAME = 'LedgerPostingType'


Voila


No comments: