Privacy Notice – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables System Tables PPrivacy Notice

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

Table Type: System

Table Name: Privacy Notice
Database Table Name: Privacy Notice

Table Number: 2000000237

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [Privacy Notice]

Show/hide an example select of all columns by name

SELECT

   [ID]
   ,[Integration Service Name]
   ,[Link]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [Privacy Notice]

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

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

Show/hide columns in Privacy Notice table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	ID	Privacy Notice ID	Normal	Code	50	ID	nvarchar(100)
2	Integration Service Name	Integration Service Name	Normal	Text	250	Integration Service Name	nvarchar(500)
3	Link	Privacy Link	Normal	Text	2048	Link	nvarchar(4096)
4	User SID Filter	User SID Filter	FlowFilter	GUID	16
5	Enabled	Enabled	FlowField	Boolean	4
6	Disabled	Disabled	FlowField	Boolean	4
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 [Privacy Notice].[$systemCreatedBy] ,[User].[User Security ID] FROM [Privacy Notice] AS [Privacy Notice] LEFT JOIN [User] AS [User] ON [Privacy Notice].[$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 [Privacy Notice].[$systemModifiedBy] ,[User].[User Security ID] FROM [Privacy Notice] AS [Privacy Notice] LEFT JOIN [User] AS [User] ON [Privacy Notice].[$systemModifiedBy] = [User].[User Security ID]