Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/2000000159
Table Type: System
Table Name: Data Sensitivity
Database Table Name: Data Sensitivity
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 Data Sensitivity can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[Data Sensitivity]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[Company Name]
,[Table No]
,[Field No]
,[Data Sensitivity]
,[Last Modified By]
,[Last Modified]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[Data Sensitivity]Show/hide columns in Data Sensitivity table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Company Name  | nvarchar(60) |
| 3 | Table No | int |
| 4 | Field No | int |
| 5 | Data Sensitivity | int |
| 6 | Last Modified By | uniqueidentifier |
| 7 | Last Modified | datetime |
| 8 | $systemId | uniqueidentifier |
| 9 | $systemCreatedAt | datetime |
| 10 | $systemCreatedBy | uniqueidentifier |
| 11 | $systemModifiedAt | datetime |
| 12 | $systemModifiedBy | uniqueidentifier |