NAV App Resource

Table Type: System

Table Name: NAV App Resource
Database Table Name: NAV App Resource

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [NAV App Resource]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Package ID]
   ,[Type]
   ,[Name]
   ,[Content]
   ,[Hash]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [NAV App Resource]

Show/hide columns in NAV App Resource table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Package ID	uniqueidentifier
3	Type	int
4	Name	nvarchar(500)
5	Content	image
6	Hash	nvarchar(128)
7	$systemId	uniqueidentifier
8	$systemCreatedAt	datetime
9	$systemCreatedBy	uniqueidentifier
10	$systemModifiedAt	datetime
11	$systemModifiedBy	uniqueidentifier