NAV App Dependencies

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

Table Type: System

Table Name: NAV App Dependencies
Database Table Name: NAV App Dependencies

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [NAV App Dependencies]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Package ID]
   ,[ID]
   ,[Name]
   ,[Publisher]
   ,[Version Major]
   ,[Version Minor]
   ,[Version Build]
   ,[Version Revision]
   ,[Compatibility Major]
   ,[Compatibility Minor]
   ,[Compatibility Build]
   ,[Compatibility Revision]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [NAV App Dependencies]

Show/hide columns in NAV App Dependencies table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Package ID Primary Key Searchuniqueidentifier
3ID Primary Key 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
14$systemId Searchuniqueidentifier
15$systemCreatedAt Searchdatetime
16$systemCreatedBy Searchuniqueidentifier
17$systemModifiedAt Searchdatetime
18$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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