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
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 ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | App ID  | uniqueidentifier |
| 3 | Profile ID | nvarchar(60) |
| 4 | Description | nvarchar(500) |
| 5 | Role Center ID | int |
| 6 | Default Role Center | tinyint |
| 7 | Disable Personalization | tinyint |
| 8 | Metadata | image |
| 9 | User AL Code | image |
| 10 | Customization Status | int |
| 11 | $systemId | uniqueidentifier |
| 12 | $systemCreatedAt | datetime |
| 13 | $systemCreatedBy | uniqueidentifier |
| 14 | $systemModifiedAt | datetime |
| 15 | $systemModifiedBy | uniqueidentifier |