SQL to display the enum values of an enum in D365FO

Hi,

In this post will provide the code to display the enum values for a given enum in D365FO. For demo purpose, choosen enum 'LedgerTransType'.

select * from enumvalueTable
join enumIdTable
on enumId = id
and enumIdTable.name = 'LedgerTransType'
order by enumvalue

Thanks,

Chaitanya Golla