web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Looking for a relationship diagram of all the Dynamics Finance data entities

(0) ShareShare
ReportReport
Posted on by 624

Dynamics Finance 10.0.19 - I am exporting data entities to my own SQL database.  I want to build the relationships in between all the data; I can manually work my way around, but do you know if there exists somewhere on the internet a list or diagram already built that I can refer to?  I need it to reference the data entities, not the SQL tables.

I have the same question (0)
  • Suggested answer
    greengrimms Profile Picture
    1,400 on at

    Hi,

    There's an ERD for AX2012 that contains some good info:

    alexdmeyer.com/.../

    I couldn't find one for D365 Data Entities, but for most of the tables, it's the same going to Finance & Ops, so it should be useful.

    Hope it helps.

  • Oceanfish26 Profile Picture
    624 on at

    Thanks.  Yeah, I found that too.  It certainly is close, but as you probably know, the entities in D365 sometimes are a combination of tables so it is not a one for one to the table names on Alex Meyer's list.

  • Suggested answer
    ergun sahin Profile Picture
    8,826 Moderator on at

    I don't know of a list or diagram but I can share a few links to make it easier.

    First of all, microsoft publishes a report that includes dataEntities. (At least you don't have to search AOT)

    docs.microsoft.com/.../axtechrefrep_61

    (You can also find a similar report with visual studio/Dynamics 365/Addins/Data Entity report)

    Secondly, records are inserted to some tables during dataEntity export. You can pull information from these tables (at least you can identify the entities used)

    experience.dynamics.com/.../

    There are reverse engineer-like tools that we used in the past. There is Ciellos's tool in the link I shared above. I can't recommend it as I haven't tested it myself.

    By similar logic these relations can be taken directly from metedata. If I have time during the day, I'm thinking of writing a code for this purpose(not a diagram just relations). If I don't have time, you can write it using the structure in the link below (there should be a method/field named dataEntity.AxDataEntityRelation or dataEntity.Relation)

    community.dynamics.com/.../d365fo---how-to-read-metadata-information-from-aot-through-x

    Note:I don't remember if there is a table named DMFentityTableExtension. It would not be easy/healthy to examine it from the info, that is way I think, Faysal extended the DMFEntity (table has own use so more likely copied it), added the fields he needed and put the records in this table. (I m'not sure)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 646 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans