User Property

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

Table Type: System

Table Name: User Property
Database Table Name: User Property

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [User Property]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[User Security ID]
   ,[Password]
   ,[Name Identifier]
   ,[Authentication Key]
   ,[WebServices Key]
   ,[WebServices Key Expiry Date]
   ,[Authentication Object ID]
   ,[Directory Role ID]
   ,[Directory Role ID List]
   ,[Telemetry User ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [User Property]

Show/hide columns in User Property table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2User Security ID Primary Key Searchuniqueidentifier
3Password Searchnvarchar(160)
4Name Identifier Searchnvarchar(500)
5Authentication Key Searchnvarchar(160)
6WebServices Key Searchnvarchar(160)
7WebServices Key Expiry Date Searchdatetime
8Authentication Object ID Searchnvarchar(160)
9Directory Role ID Searchnvarchar(160)
10Directory Role ID List Searchimage
11Telemetry User ID Searchuniqueidentifier
12$systemId Searchuniqueidentifier
13$systemCreatedAt Searchdatetime
14$systemCreatedBy Searchuniqueidentifier
15$systemModifiedAt Searchdatetime
16$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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