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: 2000000177

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
   [App ID]
   ,[Profile ID]
   ,[Description]
   ,[Role Center ID]
   ,[Default Role Center]
   ,[Disable Personalization]
   ,[Metadata]
   ,[User AL Code]
   ,[Customization Status]
   ,[Emit Version]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Tenant Profile]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [Tenant Profile] AS [Tenant Profile]
LEFT JOIN
   [User] AS [User]
      ON
         [Tenant Profile].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Tenant Profile].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Tenant Profile table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1App ID Primary Key SearchApp IDNormalGUID16App IDuniqueidentifier
2Profile ID Primary Key SearchProfile IDNormalCode30Profile IDnvarchar(60)
3Description SearchDescriptionNormalText250Descriptionnvarchar(500)
4Role Center ID SearchRole Center IDNormalInteger4Role Center IDint
5Default Role Center SearchDefault Role CenterNormalBoolean4Default Role Centertinyint
6Disable Personalization SearchDisable PersonalizationNormalBoolean4Disable Personalizationtinyint
7Metadata SearchMetadataNormalBLOB8Metadataimage
8User AL Code SearchUser AL CodeNormalBLOB8User AL Codeimage
9Customization Status SearchCustomization StatusNormalOption4Customization Statusint
Available options are:
  • “Updated”
  • “Recompilation Needed”
  • “Recompilation Failed”
10Emit Version SearchEmit VersionNormalInteger4Emit Versionint
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Tenant Profile].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [Tenant Profile] AS [Tenant Profile]
LEFT JOIN
       [User] AS [User]
              ON
                     [Tenant Profile].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Tenant Profile].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [Tenant Profile] AS [Tenant Profile]
LEFT JOIN
       [User] AS [User]
              ON
                     [Tenant Profile].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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