User Personalization

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

Table Type: System

Table Name: User Personalization
Database Table Name: User Personalization

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 User Personalization can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [User Personalization]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[User SID]
   ,[Profile ID]
   ,[App ID]
   ,[Scope]
   ,[Language ID]
   ,[Company]
   ,[Debugger Break On Error]
   ,[Debugger Break On Rec Changes]
   ,[Debugger Skip System Triggers]
   ,[Locale ID]
   ,[Time Zone]
   ,[Customization Status]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [User Personalization]

Show/hide columns in User Personalization table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2User SID Primary Key Searchuniqueidentifier
3Profile ID Searchnvarchar(60)
4App ID Searchuniqueidentifier
5Scope Searchint
6Language ID Searchint
7Company Searchnvarchar(60)
8Debugger Break On Error Searchtinyint
9Debugger Break On Rec Changes Searchtinyint
10Debugger Skip System Triggers Searchtinyint
11Locale ID Searchint
12Time Zone Searchnvarchar(360)
13Customization Status Searchint
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 *