NAV App Installed App

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

Table Type: System

Table Name: NAV App Installed App
Database Table Name: NAV App Installed 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 Installed App can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [NAV App Installed App]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[App ID]
   ,[Package ID]
   ,[Name]
   ,[Publisher]
   ,[Version Major]
   ,[Version Minor]
   ,[Version Build]
   ,[Version Revision]
   ,[Compatibility Major]
   ,[Compatibility Minor]
   ,[Compatibility Build]
   ,[Compatibility Revision]
   ,[Content Hash]
   ,[Hash Algorithm]
   ,[Extension Type]
   ,[Published As]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [NAV App Installed App]

Show/hide columns in NAV App Installed App table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2App ID Primary Key Searchuniqueidentifier
3Package ID 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
14Content Hash Searchnvarchar(500)
15Hash Algorithm Searchint
16Extension Type Searchint
17Published As Searchint
18$systemId Searchuniqueidentifier
19$systemCreatedAt Searchdatetime
20$systemCreatedBy Searchuniqueidentifier
21$systemModifiedAt Searchdatetime
22$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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