User Property – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables System Tables UUser 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: 2000000121

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

   [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 an example select of all columns including those from all joined tables

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

Show/hide columns in User Property table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	User Security ID	User Security ID	Normal	GUID	16	User Security ID	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [User Property].[User Security ID] ,[User].[User Security ID] FROM [User Property] AS [User Property] LEFT JOIN [User] AS [User] ON [User Property].[User Security ID] = [User].[User Security ID]
2	Password	Password	Normal	Text	80	Password	nvarchar(160)
3	Name Identifier	Name Identifier	Normal	Text	250	Name Identifier	nvarchar(500)
4	Authentication Key	Authentication Key	Normal	Text	80	Authentication Key	nvarchar(160)
5	WebServices Key	WebServices Key	Normal	Text	80	WebServices Key	nvarchar(160)
6	WebServices Key Expiry Date	WebServices Key Expiry Date	Normal	DateTime	8	WebServices Key Expiry Date	datetime
7	Authentication Object ID	Authentication Object ID	Normal	Text	80	Authentication Object ID	nvarchar(160)
8	Directory Role ID	Directory Role ID	Normal	Text	80	Directory Role ID	nvarchar(160)
9	Directory Role ID List	Directory Role ID List	Normal	BLOB	8	Directory Role ID List	image
10	Telemetry User ID	Telemetry User ID	Normal	GUID	16	Telemetry User ID	uniqueidentifier
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 [User Property].[$systemCreatedBy] ,[User].[User Security ID] FROM [User Property] AS [User Property] LEFT JOIN [User] AS [User] ON [User Property].[$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 [User Property].[$systemModifiedBy] ,[User].[User Security ID] FROM [User Property] AS [User Property] LEFT JOIN [User] AS [User] ON [User Property].[$systemModifiedBy] = [User].[User Security ID]