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

BC 21 and Higher - PowerShell Cmdlet (Replacement of Business Central Administration).

Hi Readers, As discussed in last article about deprecating of Business Central Administration, there are few common actions that we use in administration till Business Central 20. For our on-prem customers, we will still require doing activities. As Microsoft suggest we need to start using PowerShell cmdlet.    Let's see how to do those via PowerShell, or Administration Shell. I will be keep adding commands as you comment to this article.

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

MSDYN365BC - Data Upgrade To Microsoft Dynamics 365 Business Central on premises.

Hi Readers, We have already talked about the number of steps for upgrading to Business Central on Premises from different NAV versions. After that article, I received multiple requests for an article which list down steps for Data Migration. In this article, we will discuss steps of data migration to MSDYN365BC (on-Prem) from NAV 2017. For this article, I am considering a Cronus Demo Database without any customization. For an actual upgrade project, we will have to complete object merge using compare and Merge process. After the Merge Process, the next step is data migration. Let's discuss those steps. Direct Upgrade to Microsoft Dynamics 365 Business Central (on-Prem) is from following versions - 1. NAV 2015. 2. NAV 2016. 3. NAV 2017. 4. NAV 2018.