Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Database Schema for Dy...
Finance forum

Database Schema for Dynamics 365 for Finance and Operations

(0) ShareShare
ReportReport
Posted on by

Is there a database Schema for Dynamics 365 for Finance and Operations - I can't seem to find one anywhere.

  • spinecorp Profile Picture
    spinecorp 5 on at
    RE: Database Schema for Dynamics 365 for Finance and Operations

    The dynamics 365 Finops schema is totally different to AX2012R2

  • prodev42 Profile Picture
    prodev42 270 on at
    RE: Database Schema for Dynamics 365 for Finance and Operations

    [quote user="CQ789"]

    Is there a database Schema for Dynamics 365 for Finance and Operations - I can't seem to find one anywhere.

    [/quote]

    www.msdynamicsax2016.com

  • judyt Profile Picture
    judyt 5 on at
    RE: Database Schema for Dynamics 365 for Finance and Operations

    is it possible to repost it again? the link is no longer there :-(  thanks!

  • Sukrut Parab Profile Picture
    Sukrut Parab 71,656 Moderator on at
    RE: Database Schema for Dynamics 365 for Finance and Operations

    Please close this thread by marking verified . Thanks

  • Suggested answer
    CQ789 Profile Picture
    CQ789 on at
    RE: Database Schema for Dynamics 365 for Finance and Operations

    Thanks Sukrut, that is helpful.  Not exactly what i wanted, but that might work out!

  • Verified answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,656 Moderator on at
    RE: Database Schema for Dynamics 365 for Finance and Operations

    Hi CQ789,

    I don't think such a diagrams exist for D365, however you can utilize ax 2012 ERD for understanding

    www.microsoft.com/.../ax2012r2

    There  may be changes in D365 but for understanding above link is good

  • CQ789 Profile Picture
    CQ789 on at
    RE: Database Schema for Dynamics 365 for Finance and Operations

    Hi Sukrut,  When I posted this I was looking specifically for a diagram that shows how each table is connected.  Since then I am also interested in maybe a quick description of what each table is with it's name (in other words "DistinctProducts" is the table for x,y,z data.

  • Sukrut Parab Profile Picture
    Sukrut Parab 71,656 Moderator on at
    RE: Database Schema for Dynamics 365 for Finance and Operations

    what specifically you are looking for ? ERD diagrams ? can you please elaborate ?

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans