Navision 2009 Table Structure

Eric Laurin
Eric Laurin Employee
Fourth Anniversary 25 Up Votes Level 100: Foundations of Building in Board Level 200: Building A Planning Solution in Board
in Platform

I am working with a client who is using an MS SQL Server table structure in the Navision 2009 format.  They wanted to know if there is someone who has extracted from this type of system and if they could reach out with some general questions.

Answers

  • Previous Member
    Previous Member
    500 Up Votes 500 Likes 500 Comments Second Anniversary

    Hi,

    We did various Board Project with Customer who are using Microsoft Dynamics NAV (Navision). Each company in Navision has its own set of tables in the SQL database. The format is <company><table>. 

    If you want to link Nav directly to Board then you need multiple data readers for every company. 

    Or you will generate in SQL some views that combine the tables and link the data readers to the view.

     

    Please don't hesitate to contact me in case you need further information.

     

    best regards,

     

    R.J. Van Kuppeveld

Categories