Skip to main content

Microsoft Dynamics NAV 2018 - List of System and Hidden Tables.

Hi Readers,

As we always discuss the list of the new system & hidden tables added in the new version, in this article we will see what new system and hidden tables added in NAV 2018.

If you are looking for system and hidden tables in the previous version refer below -

NAV 2009   NAV 2015   NAV 2016   & NAV 2017

Below is the list of Virtual and System tables in Microsoft Dynamics NAV 2018.


  • 10 New System tables added in NAV 2018.
Object ID
Object Name
Object Caption
2000000081
Upgrade Blob Storage
Upgrade Blob Storage
2000000082
Report Layout
Report Layout
2000000176
NAV App Resource
NAV App Resource
2000000177
Tenant Profile
Tenant Profile
2000000178
All Profile
All Profile
2000000179
OData Edm Type
OData Edm Type
2000000182
Media Resources
Media Resources
2000000186
Profile Page Metadata
Profile Page Metadata
2000000187
Tenant Profile Page Metadata
Tenant Profile Page Metadata
2000000188
User Page Metadata
User Page Metadata

  • 02 New Virtual / Hidden Tables added in NAV 2018.
Object ID
Object Name
Object Caption
2000000192
Page Control Field
Page Control Field
2000000193
Api Web Service
Api Web Service

  • List of all Hidden / Virtual Tables in NAV 2018

Object ID
Object Name
Object Caption
2000000001
Object
Object
2000000007
Date
Date
2000000009
Session
Session
2000000020
Drive
Drive
2000000022
File
File
2000000026
Integer
Integer
2000000028
Table Information
Table Information
2000000029
System Object
System Object
2000000038
AllObj
AllObj
2000000039
Printer
Printer
2000000040
License Information
License Information
2000000041
Field
Field
2000000043
License Permission
License Permission
2000000044
Permission Range
Permission Range
2000000045
Windows Language
Windows Language
2000000048
Database
Database
2000000049
Code Coverage
Code Coverage
2000000055
SID - Account ID
SID - Account ID
2000000058
AllObjWithCaption
AllObjWithCaption
2000000063
Key
Key
2000000101
Debugger Call Stack
Debugger Call Stack
2000000102
Debugger Variable
Debugger Variable
2000000103
Debugger Watch Value
Debugger Watch Value
2000000135
Table Synch. Setup
Table Synch. Setup
2000000136
Table Metadata
Table Metadata
2000000137
CodeUnit Metadata
CodeUnit Metadata
2000000138
Page Metadata
Page Metadata
2000000139
Report Metadata
Report Metadata
2000000140
Event Subscription
Event Subscription
2000000141
Table Relations Metadata
Table Relations Metadata
2000000142
Query Metadata
Query Metadata
2000000154
Database Locks
Database Locks
2000000164
Time Zone
Time Zone
2000000167
Aggregate Permission Set
Aggregate Permission Set
2000000171
Page Table Field
Page Table Field
2000000172
Table Field Types
Table Field Types
2000000173
Finish Design Save Mode
Finish Design Save Mode
2000000178
All Profile
All Profile
2000000192
Page Control Field
Page Control Field
2000000193
Api Web Service
Api Web Service

Thinking what these new tables do. Let me know, I will make sure that we cover them in future articles.

Thanks,
Saurav Dhyani

Comments

Popular posts from this blog

VIEW SERVER STATE permission on SQL Server?

Hi all, Sometime While trying to Login into a database we face an error message as shown below. --------------------------- Microsoft Dynamics NAV Classic --------------------------- You cannot start Microsoft Dynamics NAV Classic because you do not have the VIEW SERVER STATE permission on SQL Server. Contact your system administrator. --------------------------- OK    ---------------------------

NAV 2013 R2 - Cumulative update 12 Released.

Hi all, Please find below the details of  Cumulative Update 12 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 12 for Microsoft Dynamics NAV 2013 R2 Build No. - 38053 Release Date - October, 2014 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK, RU Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.

Error After Restore SQL Backup of NAV 2013 Database

Hi all, we are facing a conman issue during restoring a SQL Database backup restored for NAV 2013. While Trying to run object from Object Designer we get below listed error (even the service is configured properly) - --------------------------- Microsoft Dynamics NAV Development Environment --------------------------- There are no NAV Server instances available for this database. You must ensure that a NAV Server instance is running and is configured to use the database before you perform this activity. --------------------------- OK    ---------------------------