NAV App Object Metadata

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

Table Type: System

Table Name: NAV App Object Metadata
Database Table Name: NAV App Object Metadata

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [NAV App Object Metadata]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[App Package ID]
   ,[Object Type]
   ,[Object ID]
   ,[Metadata Format]
   ,[Metadata]
   ,[User Code]
   ,[User AL Code]
   ,[Metadata Version]
   ,[Object Subtype]
   ,[Object Name]
   ,[Metadata Hash]
   ,[User Code Hash]
   ,[Object Flags]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [NAV App Object Metadata]

Show/hide columns in NAV App Object Metadata table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2App Package ID Primary Key Searchuniqueidentifier
3Object Type Primary Key Searchint
4Object ID Primary Key Searchint
5Metadata Format Searchint
6Metadata Searchimage
7User Code Searchimage
8User AL Code Searchimage
9Metadata Version Searchint
10Object Subtype Searchnvarchar(60)
11Object Name Searchnvarchar(60)
12Metadata Hash Searchnvarchar(128)
13User Code Hash Searchnvarchar(128)
14Object Flags Searchint
15$systemId Searchuniqueidentifier
16$systemCreatedAt Searchdatetime
17$systemCreatedBy Searchuniqueidentifier
18$systemModifiedAt Searchdatetime
19$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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