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.
Voila
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:
Post a Comment