Application Dependency

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

Table Type: System

Table Name: Application Dependency
Database Table Name: Application Dependency

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [Application Dependency]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Runtime Package ID]
   ,[Dependency App ID]
   ,[Package ID]
   ,[Dependency Name]
   ,[Dependency Publisher]
   ,[Dependency Version Major]
   ,[Dependency Version Minor]
   ,[Dependency Version Build]
   ,[Dependency Version Revision]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Application Dependency]

Show/hide columns in Application Dependency table

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

Leave a Reply

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