Hi,
In Dynamics AX 2012, a field from a table can be extended from an enum type (or indirectly via an extended data type which is extended from an enum type). In order to have easy access to the enum elements value within SQL Server I'm trying to find my way through the table structures. Ultimately the data is used in PowerBI inquiries.
Please, does someone know the answer to this question: what table(s) must I use to find the connection between a table.field to the extended enum type?
Example
-- List all tables with their enum based fields
SELECT * FROM SQLDICTIONAIRY WHERE FIELDTYPE=4;
-- A bit more specific test: Only select the blocked field of the CustTable
SELECT * FROM MODELELEMENT WHERE PARENTID=77 AND AXID=14;
-- List the specific enum type
SELECT * FROM SRSMODELENTITYCACHE WHERE ENTITYTYPE=2 AND INSTANCESELECTION='Dropdown';
-- WHERE ...
I suspect I also need information on the tables field object within the model it was created/changed. What am I missing here in SQL?
