BaseEnum values

Hey!

In D365FO some BaseEnums doesn’t have the Enum Value property in its elements.

This happens because the ABC BaseEnum is extensible.

To comply with the extension framework Microsoft introduced a new property on BaseEnums that determine if the enum is extensible or not. If the Enum is extensible then its elements will be automatically numbered.

If the enum is not extensible the Enum Values are stored as metadata in the enum XML file.

On the other hand, extensible enums have their values stored in SQL.

Here is a SQL script to help find out extensible enums Enum Values:

SELECT * FROM ENUMVALUETABLE
JOIN ENUMIDTABLE ON ENUMVALUETABLE.ENUMID = ENUMIDTABLE.ID
WHERE ENUMIDTABLE.NAME = 'BaseEnumName'