Thursday, January 7, 2016

Virtual Tables in Dynamics NAV


Virtual Table

Virtual Table : This tables store system provided information. You can use this tables as normal table , the difference is that you cannot change the information present in Virtual tables ie. Virtual Tables are only readable. Another difference is that, This tables are computed at runtime instead of storing in database as normal tables does.

Some of the Important Virtual Tables are :

Date, Integer, File, Drive, Monitor, Session, Database File, Table Information, Field, Server, Windows Object, Windows Group Member, SID - Account ID, User SID.

Table ID's range:

  • 2000000001 – 2000000203 In Dynamics Nav 2009 R2
  • 2000000001 – 2000000130 In Dynamics Nav 2013 R2


Information provided by virtual tables:


  • Integers in the range – 1.000.000.000 to 1.000.000.000.
  • Dates within a given period.
  • An overview of the operating system files.
  • An overview of the logical disk drives.
  • A trace of database requests from your client to the database.
  • An overview of the users that are currently connected to the database.
  • An overview of the operating system files that store the database.


How to use Virtual tables :


To view information from these virtual tables you can 



  • Create a "Form" with data source as a "Virtual Table" in Nav 2009 R2
  • Create a "Page" with  data source as a "Virtual Table" in Nav 2013 R2

Example :  You can find Virtual table in Dynamics Nav 2009 R2, Here 


  • Go to "File" >> "Database" >> "Information"
  • Go to "Sessions" Tab then Lookup in "Current Sessions" Value
 You will find a Form "Database Sessions" reflecting "Sessions" table (Virtual Table).

As shown below :



Database Sessions




Enjoyed the topic, Please do subscribe to our newsletter to get updated with every post without a miss.


Thanks for Reading,

Shubin Dongre


3 comments:

  1. This is my first time visit here. From the huge amounts of remarks on your articles,I surmise I am not just one having all the delight right here! Terry Dawson

    ReplyDelete
  2. If you are new user to sage 50 accounting software and looking for the sage 50 technical support.If yes than you have come to right place as we provide efficient technical support service to customers who show complete faith in us. With our efficient and highly qualified team ,we never disappoint our customers.You can reach us at 1800-910-4754 at any hour of the day. You can also visit our website at https://www.geekaccounting247.com/ for the complete knowledge of the sage products and services.

    The Services we offered are following-
    Sage 50 Technical Support Number
    Sage 100 Technical Support Number
    Sage 50 live chat
    Sage 50 Technical Support phone Number
    Sage 50 support phone number

    ReplyDelete