Permission Conflicts Overview

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

Table Type: Company

Table Name: Permission Conflicts Overview
Database Table Name: CRONUS UK Ltd_$Permission Conflicts Overview$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5555

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 Permission Conflicts Overview can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Permission Conflicts Overview$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[PermissionSetID]
   ,[Type]
   ,[Basic]
   ,[Team Member]
   ,[Essential]
   ,[Premium]
   ,[Device]
   ,[External Accountant]
   ,[Internal Admin]
   ,[Delegated Admin]
   ,[HelpDesk]
   ,[Viral]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Permission Conflicts Overview$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Permission Conflicts Overview table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2PermissionSetID Primary Key Searchnvarchar(40)
3Type Primary Key Searchint
4Basic Searchtinyint
5Team Member Searchtinyint
6Essential Searchtinyint
7Premium Searchtinyint
8Device Searchtinyint
9External Accountant Searchtinyint
10Internal Admin Searchtinyint
11Delegated Admin Searchtinyint
12HelpDesk Searchtinyint
13Viral Searchtinyint
14$systemId Searchuniqueidentifier
15$systemCreatedAt Searchdatetime
16$systemCreatedBy Searchuniqueidentifier
17$systemModifiedAt Searchdatetime
18$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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