Published Application

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

Table Type: System

Table Name: Published Application
Database Table Name: Published Application

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [Published Application]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Runtime Package ID]
   ,[Package ID]
   ,[ID]
   ,[Name]
   ,[Publisher]
   ,[Version Major]
   ,[Version Minor]
   ,[Version Build]
   ,[Version Revision]
   ,[Package Type]
   ,[Published As]
   ,[Tenant ID]
   ,[Brief]
   ,[Description]
   ,[Privacy Statement]
   ,[EULA]
   ,[Url]
   ,[Help]
   ,[Logo]
   ,[Screenshots]
   ,[Blob]
   ,[Symbols]
   ,[Content Hash]
   ,[Show My Code]
   ,[Package Hash]
   ,[Application Insights Key]
   ,[Key Vault URLs]
   ,[Publisher AAD Tenant ID]
   ,[Documentation]
   ,[App Insights Connection String]
   ,[Resource Exposure Policy]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Published Application]

Show/hide columns in Published Application table

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

Leave a Reply

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