Tenant Permission Set Rel. – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables System Tables TTenant Permission Set Rel.

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

Table Type: System

Table Name: Tenant Permission Set Rel.
Database Table Name: Tenant Permission Set Rel_

Table Number: 2000000253

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 Permission Set Rel. can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [Tenant Permission Set Rel_]

Show/hide an example select of all columns by name

SELECT

   [App ID]
   ,[Role ID]
   ,[Related App ID]
   ,[Related Role ID]
   ,[Type]
   ,[Related Scope]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [Tenant Permission Set Rel_]

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

SELECT
   *
FROM
   [Tenant Permission Set Rel_] AS [Tenant Permission Set Rel.]
LEFT JOIN
   [User] AS [User]
      ON
         [Tenant Permission Set Rel.].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Tenant Permission Set Rel.].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Tenant Permission Set Rel. table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	App ID	App ID	Normal	GUID	16	App ID	uniqueidentifier
2	Role ID	Role ID	Normal	Code	30	Role ID	nvarchar(60)
3	Related App ID	Related App ID	Normal	GUID	16	Related App ID	uniqueidentifier
4	Related Role ID	Related Role ID	Normal	Code	30	Related Role ID	nvarchar(60)
5	Type	Type	Normal	Option	4	Type	int
	Available options are: “Include” “Exclude”
6	Related Scope	Related Scope	Normal	Option	4	Related Scope	int
	Available options are: “System” “Tenant”
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Tenant Permission Set Rel.].[$systemCreatedBy] ,[User].[User Security ID] FROM [Tenant Permission Set Rel_] AS [Tenant Permission Set Rel.] LEFT JOIN [User] AS [User] ON [Tenant Permission Set Rel.].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Tenant Permission Set Rel.].[$systemModifiedBy] ,[User].[User Security ID] FROM [Tenant Permission Set Rel_] AS [Tenant Permission Set Rel.] LEFT JOIN [User] AS [User] ON [Tenant Permission Set Rel.].[$systemModifiedBy] = [User].[User Security ID]