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: 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 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
   [timestamp]
   ,[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 columns in User table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2User Security ID Primary Key Searchuniqueidentifier
3User Name Searchnvarchar(100)
4Full Name Searchnvarchar(160)
5State Searchint
6Expiry Date Searchdatetime
7Windows Security ID Searchnvarchar(238)
8Change Password Searchtinyint
9License Type Searchint
10Authentication Email Searchnvarchar(500)
11Contact Email Searchnvarchar(500)
12Exchange Identifier Searchnvarchar(500)
13Application ID Searchuniqueidentifier
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 *