Navision table schema
foolosofo
Member Posts: 73
Hello,
I'm working with Navision since 1 year ago. Nowadays, I've realised that it was very useful to have a Navision table schema of most important tables of Navision.
I know it's difficult to view a complete schema, but I'm interested just in main tables, main processes, etc...
Do you know some place where I can find this?
Thank you very much.
I'm working with Navision since 1 year ago. Nowadays, I've realised that it was very useful to have a Navision table schema of most important tables of Navision.
I know it's difficult to view a complete schema, but I'm interested just in main tables, main processes, etc...
Do you know some place where I can find this?
Thank you very much.
0
Comments
-
There isn't such a thing but after a while you will realize that naming conventions make this unnecessary.
F.e. a non-standard example - if there would be a car renting solution there would be a master table called Car. It's primary key would be No. and it would have a Description field, maybe a Description 2 as well. It's movements were called Car Ledger Entry or Car Entry (Entry is for sure) and those entries were created by a Car Journal Line. Both would reference the car as Car No., would have Posting Date, Document No., Description, Quantity, the renting fee would be called Unit Something (f.e. Unit Fee) for one car and Something Amount (f.e. Fee Amount) for the whole line. If there were multiple lines in one transaction you would have a document like Car Renting Header and Car Renting Line and probably posted versions of the table as well. The header would either have No. or Document Type, No. as primary key and the line would reference it as Document Type, Document No., Line No. And so on.0 -
I'm also interested in this, especially the links & relationships between forms & codeunits (or reports)
eg onInsert -> codeunit to check permission....
-> codeunit to check configuration
Debug takes too long & cycles through too many places...NAV - Norton Anti Virus
ERP Consultant (not just Navision) & Navision challenger0 -
In NDT you see relationships between objects0
-
Hi again,
I've seen that in http://www.navitools.com there are a lot of (non-free) resources. It's the kind of thing I want, but, if it's possible, free.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 324 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions