NAV App

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/

Table Type: System

Table Name: NAV App
Database Table Name: NAV App

Table Number: 0

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how NAV App can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [NAV App]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Package ID]
   ,[ID]
   ,[Name]
   ,[Publisher]
   ,[Version Major]
   ,[Version Minor]
   ,[Version Build]
   ,[Version Revision]
   ,[Compatibility Major]
   ,[Compatibility Minor]
   ,[Compatibility Build]
   ,[Compatibility Revision]
   ,[Brief]
   ,[Description]
   ,[Privacy Statement]
   ,[EULA]
   ,[Url]
   ,[Help]
   ,[Logo]
   ,[Screenshots]
   ,[Blob]
   ,[Package Type]
   ,[Symbols]
   ,[Content Hash]
   ,[Tenant ID]
   ,[Show My Code]
   ,[Scope]
   ,[Package Hash]
   ,[Application Insights Key]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [NAV App]

Show/hide columns in NAV App table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Package ID Primary Key Searchuniqueidentifier
3ID Searchuniqueidentifier
4Name Searchnvarchar(500)
5Publisher Searchnvarchar(500)
6Version Major Searchint
7Version Minor Searchint
8Version Build Searchint
9Version Revision Searchint
10Compatibility Major Searchint
11Compatibility Minor Searchint
12Compatibility Build Searchint
13Compatibility Revision Searchint
14Brief Searchnvarchar(500)
15Description Searchimage
16Privacy Statement Searchnvarchar(500)
17EULA Searchnvarchar(500)
18Url Searchnvarchar(500)
19Help Searchnvarchar(500)
20Logo Searchuniqueidentifier
21Screenshots Searchuniqueidentifier
22Blob Searchimage
23Package Type Searchint
24Symbols Searchimage
25Content Hash Searchnvarchar(500)
26Tenant ID Searchnvarchar(256)
27Show My Code Searchtinyint
28Scope Searchint
29Package Hash Searchnvarchar(128)
30Application Insights Key Searchuniqueidentifier
31$systemId Searchuniqueidentifier
32$systemCreatedAt Searchdatetime
33$systemCreatedBy Searchuniqueidentifier
34$systemModifiedAt Searchdatetime
35$systemModifiedBy Searchuniqueidentifier

Leave a Reply

Your email address will not be published. Required fields are marked *