Add-in

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

Table Type: System

Table Name: Add-in
Database Table Name: Add-in

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [Add-in]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Add-in Name]
   ,[Public Key Token]
   ,[Version]
   ,[Category]
   ,[Description]
   ,[Resource]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Add-in]

Show/hide columns in Add-in table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Add-in Name Primary Key Searchnvarchar(440)
3Public Key Token Primary Key Searchnvarchar(40)
4Version Primary Key Searchnvarchar(50)
5Category Searchint
6Description Searchnvarchar(500)
7Resource Searchimage
8$systemId Searchuniqueidentifier
9$systemCreatedAt Searchdatetime
10$systemCreatedBy Searchuniqueidentifier
11$systemModifiedAt Searchdatetime
12$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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