NAV App Published App

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

Table Type: System

Table Name: NAV App Published App
Database Table Name: NAV App Published App

Table Number: 2000000156

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 Published App can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [NAV App Published App]

Show/hide an example select of all columns by name

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

Show/hide columns in NAV App Published App table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2App ID Primary Key Searchuniqueidentifier
3Version Major Primary Key Searchint
4Version Minor Primary Key Searchint
5Version Build Primary Key Searchint
6Version Revision Primary Key Searchint
7Package ID Searchuniqueidentifier
8Name Searchnvarchar(500)
9Publisher Searchnvarchar(500)
10Content Hash Searchnvarchar(500)
11Hash Algorithm Searchint
12$systemId Searchuniqueidentifier
13$systemCreatedAt Searchdatetime
14$systemCreatedBy Searchuniqueidentifier
15$systemModifiedAt Searchdatetime
16$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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