Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

SQL Tables Structure , relations and Data Flow

Posted on by 369

Hello All,

Would you please provide any valuable references to understand the table structure, relations and data flow in Dynamics NAV ?

Your feedback is highly appreciated

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SQL Tables Structure , relations and Data Flow

    I have created E/R diagrams for Navision 4.0 (http://navitools.com).

    ...and NAV 2016: https://dynamicsdocs.com

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SQL Tables Structure , relations and Data Flow

    In SQL database, all the NAV tables would have company name as prefix except the certain common tables.

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: SQL Tables Structure , relations and Data Flow

    Also, there is such tool available: community.dynamics.com/.../182841

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: SQL Tables Structure , relations and Data Flow

    It is actually available there, scroll down till you see dbo.CRONUS International Ltd.$Item

  • Ahmad_Safadi Profile Picture
    Ahmad_Safadi 369 on at
    RE: SQL Tables Structure , relations and Data Flow

    Thank you guys,

    I have been interested in the msdn reference, since I couldn't open the file included in the project (the big picture of NAV).

    One more question, as I review the tables in the MSD reference, I don't seem to find them in my "Demo" version of Dynamics NAV ?

    For instance, the reference says there is a table for item which is (ITEM). Although, I can't find it in the demo version of Cronus. See image below:

                                   3487.1.png

    Note: I have implemented the demo version of NAV 2016

    Your feedback is highly appreciated,

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: SQL Tables Structure , relations and Data Flow

    There is no full description of table relations, you would learn them from practice. However this link might be also helpful: msdn.microsoft.com/.../hh893827(v=nav.90).aspx

  • Verified answer
    Miguel Llorca Profile Picture
    Miguel Llorca User Group Leader on at
    RE: SQL Tables Structure , relations and Data Flow

    I recommend you this post: forum.mibuso.com/.../all-table-relations-from-nav (but you'll need a development licencse :-))

    BR,

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SQL Tables Structure , relations and Data Flow

    Hi Saf,

    Refer following link.

    shantanu-msd-nav.blogspot.in/.../msd-nav-table-field-relationship-part-i.html

    Check following link, if you have NAV development license.

    mibuso.com/.../the-big-picture-of-nav-v2

    If you have specific queries, you can always revert.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans