Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Ethel Cueto]

Hello All,

Would anyone know how to get / download a list of AX 2012 Data Dictionary Tables and its Fields without going through AOT?

Thank you in advance!

Best regards,

Ethel

——————————
Ethel Cueto
Financial Controller
Ultimate Positioning Group
Brisbane, Australia
——————————

[Andrew Russell]

If you have SQL access, you can pull from the database:

select * from sqldictionary where fieldid = 0 –lists all tables
select * from sqldictionary where tableid = 77 –lists all fields for specific table

Hope this helps.

——————————
Andrew Russell
Direct Wines
Reading, UK
——————————
——————————————-

[Bob Coward]

Hi Ethel,

Microsoft provided this table list for us years back.  Whether it is up to date, can’t say.  There are a few examples online showing how to abstract a field list from a provided table name.  Don’t know of a complete solution to your question but if you have a developer at hand it would be one of the simplest requests they have experienced

https://download.microsoft.com/download/1/E/2/1E2B531F-BDFF-4B15-954E-753A757127E5/Microsoft_Dynamics_AX_2012_Tables_and_Table_Groups.xlsx

——————————
Bob Coward
Dynamics AX/F&O Developer
DSG
Grayson GA
——————————
——————————————-