Table Type In NAV 2016

Nice features in NAV 2016 Table i.e One can specify the Table type

Earlier version we are using property called ‘LinkedObject’ to link the external table/view.

In New version we have property Table type which contains three different type as follows called ExternalSql’  wherein one can specify table/view from sql server that is not in MS Dynamics NAV DB

  • Normal :- Specified the table as normal table . This is default value whenever you create table in NAV
  • CRM:- Integration table for integrating NAV with Microsoft dynamics CRM
  • ExternalSQL:- Specify the table/view in sql server which is not in NAV database.

When one select ‘ExternalSQL’ two other properties will enable automatically

1) ExternalName :- specify the name of external table from database

2) External Schema :- Specify the database schema.

 

You can look at How to register External Tables

 

Cheers!!!!

Author: Ammolh Saallvi

I'm a Dynamics NAV/Navision developer and helps partners and end-users with their NAV implementations. I do everything from third-party management advisory, training to new NAV teams, project management, training, setup and development. Do you want to hire me to help getting your project a success? Then contact me via dropping one email from linkedin Expertise in end-to-end development of software products from requirement analysis to System Study, Documentation and Testing. Demonstrated abilities in analyzing information system needs, evaluating end-user requirements, custom designing solutions, troubleshooting for complex information systems management. Deft at carrying out risk analysis, impact analysis, project reviews and documentation. Strong Problem solving & Technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction as well as low operational costs. Certifications:- Microsoft Certified Technology Specialist -Dynamics Microsoft Sure Step Certified Professional Moderator at DUG Forum Specialties: • ERP Implementation • Client/Server Programming • Coding, Testing, troubleshooting and documentation. • Database Tuning and SQL • Database Performance • Debugging large programs • Project Management and Resource Management.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.