User

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

Table Type: System

Table Name: User
Database Table Name: User

Table Number: 2000000120

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [User]

Show/hide an example select of all columns by name

SELECT
   [User Security ID]
   ,[User Name]
   ,[Full Name]
   ,[State]
   ,[Expiry Date]
   ,[Windows Security ID]
   ,[Change Password]
   ,[License Type]
   ,[Authentication Email]
   ,[Contact Email]
   ,[Exchange Identifier]
   ,[Application ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [User]

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

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

Show/hide columns in User table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1User Security ID SearchUser Security IDNormalGUID16User Security IDuniqueidentifier
2User Name Primary Key SearchUser NameNormalCode50User Namenvarchar(100)
3Full Name SearchFull NameNormalText80Full Namenvarchar(160)
4State SearchStateNormalOption4Stateint
Available options are:
  • “Enabled”
  • “Disabled”
5Expiry Date SearchExpiry DateNormalDateTime8Expiry Datedatetime
7Windows Security ID SearchWindows Security IDNormalText119Windows Security IDnvarchar(238)
8Change Password SearchChange PasswordNormalBoolean4Change Passwordtinyint
10License Type SearchLicense TypeNormalOption4License Typeint
Available options are:
  • “Full User”
  • “Limited User”
  • “Device Only User”
  • “Windows Group”
  • “External User”
  • “External Administrator”
  • “External Accountant”
  • “Application”
  • “AAD Group”
11Authentication Email SearchAuthentication EmailNormalText250Authentication Emailnvarchar(500)
14Contact Email SearchContact EmailNormalText250Contact Emailnvarchar(500)
15Exchange Identifier SearchExchange IdentifierNormalText250Exchange Identifiernvarchar(500)
16Application ID SearchApplication IDNormalGUID16Application IDuniqueidentifier
Key to join to the Installed Application table.

Show/hide example query

SELECT
	       [User].[Application ID]
	       ,[Installed Application].[Package ID]
	FROM
	       [User] AS [User]
	LEFT JOIN
	       [] AS [Installed Application]
	              ON
	                     [User].[Application ID] = [Installed Application].[Package ID]
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Leave a Reply

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