Installed Application

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

Table Type: System

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [Installed Application]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Runtime Package ID]
   ,[Tenant ID]
   ,[Package ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Installed Application]

Show/hide columns in Installed Application table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Runtime Package ID Primary Key Searchuniqueidentifier
3Tenant ID Primary Key Searchnvarchar(256)
4Package ID Searchuniqueidentifier
5$systemId Searchuniqueidentifier
6$systemCreatedAt Searchdatetime
7$systemCreatedBy Searchuniqueidentifier
8$systemModifiedAt Searchdatetime
9$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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