You’re offline. This is a read only version of the page.
Hi everyone, i want to know the relation between each table and by which column are related to.i don't have a licence .I follow this link https://msdn.microsoft.com/en-us/library/hh174016%28v=nav.70%29.aspx to identify each table and her column but i didn't find any documentation about how they related.thanks
*This post is locked for comments
you could use "The big picture", for that follow moxie4nav.wordpress.com/.../dynamics-nav-the-big-picture
If you need a version for nav 2013, please contact me.
You could work with "GDT Where-used-tool" or the Where-Used-Tool contained in OMA or "Statical Prism". These tools show all relations between tables and their fields, also relations to reports, pages, codeunits, ...
A developer lic. is needed to export all tables as text ... OR someone creates that text file for you on base of demo/cronus database and provides it for you. ;-)
here you are an example you can link customer, sales invoice header and line, sales credit memo line and return reason through Customer Ledger Entry table, ...this join works so beautiful
i hope shape has been usefull
Hi,
1) Sales Header (Primary Key - "Document Type",No.)
One Sales Header can have multiple Sales Lines (Key - Document No., Line No.)
2) Once you Post Sales Order > Shipment > It would post the shipment record in following tables.
Sales Shipment Header (Key - No.)
One Sales Shipment Header can have multiple Sales Shipment Lines (Key - Document No., Line No.)
Sales Order No. would flow to Sales Shipment Header.
3) Once you Post Sales Order > Invoice> It would post the Invoice record
Sales Invoice Header (Key - No.)
Sales Order No. would flow to Sales Invoice Header.
One Sales Invoice Header can have multiple Sales Invoice Lines (Key - Document No., Line No.)
4) Once you Post Return Sales Order > Shipment > It would post the Return Receipt record
Return Receipt Header (Key - No.)
One Return Receipt Header can have multiple Return Receipt Lines (Key - Document No., Line No.)
5) Once you Post Return Sales Order > Invoice> It would post the Credit Memo record
Sales Cr. Memo Header (Key - No.)
One Sales Cr. Memo Header can have multiple Sales Cr. Memo Lines (Key - Document No., Line No.)
Hope this helps.
I will do the same thing that you did .But first i have to work a little on the sales process so the i want to know the relation between :Customer ,Sales Header,Sales Line,Sales Shipment Header,Sales Shipment Line,Sales Invoice Header,Sales Invoice Line,Sales Cr.Memo Header,Sales Cr.Memo Line
you won't find all the table relations in the same article, it is specialy usefull for business inteligence developers, i´ve invested much time to find out the best key fields between them to build cubes and data warehouse to create reports and dashboards, would be useful to help you if you say what you need the information for, then i can suggest a couple of tables and they key fields
Hey Kamila,
Open this link and all Microsoft Dynamics NAV 2016 Standard Tables will get downloaded.
https://docs.google.com/uc?id=0B6693j0esfazVlpxX3BFQzV6aVE&export=download
Thanks
yes .
Hey Kamilla,
Which .txt file you want?? Do you want all NAV Standard Table Objects in .txt??
Thanks
Blog - rockwithnav.wordpress.com
if you could generate a file .txt for me then i can use any tools that determinated the relation between tables.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (