Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/9062
Table Type: System
Table Name: User Security Status
Database Table Name:
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 Security Status can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[]Show/hide an example select of all columns by name
SELECT
FROM
[]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[] AS [User Security Status]
LEFT JOIN
[User] AS [User]
ON
[User Security Status].[User Security ID] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[User Security Status].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[User Security Status].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in User Security Status 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 | ||
| 2 | User Name | User Name | FlowField | Code | 50 | ||
| 3 | Full Name | Full Name | FlowField | Text | 80 | ||
| 13 | Reviewed | Reviewed | Normal | Boolean | 4 | ||
| 14 | Belongs To Subscription Plan | Belongs To Subscription Plan | FlowField | Boolean | 4 | ||
| 15 | Belongs to User Group | Belongs to User Group | FlowField | Boolean | 4 | ||
| 20 | Users – To review | Users – To review | FlowField | Integer | 4 | ||
| 21 | Users – Without Subscriptions | Users – Without Subscriptions | FlowField | Integer | 4 | ||
| 22 | Users – Not Group Members | Users – Not Group Members | FlowField | Integer | 4 | ||
| 25 | CDS Integration Errors | Dataverse Integration Errors | FlowField | Integer | 4 | ||
| 26 | Coupled Data Synch Errors | Coupled Data Synch Errors | FlowField | Integer | 4 | ||
| 2000000000 | $systemId | System ID | Normal | GUID | 16 | ||
| 2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | ||
| 2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | ||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | ||
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 |