Tenant Profile

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

Table Type: System

Table Name: Tenant Profile
Database Table Name: Tenant Profile

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [Tenant Profile]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[App ID]
   ,[Profile ID]
   ,[Description]
   ,[Role Center ID]
   ,[Default Role Center]
   ,[Disable Personalization]
   ,[Metadata]
   ,[User AL Code]
   ,[Customization Status]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Tenant Profile]

Show/hide columns in Tenant Profile table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2App ID Primary Key Searchuniqueidentifier
3Profile ID Primary Key Searchnvarchar(60)
4Description Searchnvarchar(500)
5Role Center ID Searchint
6Default Role Center Searchtinyint
7Disable Personalization Searchtinyint
8Metadata Searchimage
9User AL Code Searchimage
10Customization Status 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 *