Data Privacy Records

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

Table Type: Company

Table Name: Data Privacy Records
Database Table Name: CRONUS UK Ltd_$Data Privacy Records$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1181

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Data Privacy Records$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[ID]
   ,[Table No_]
   ,[Field No_]
   ,[Field DataType]
   ,[Field Value]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Data Privacy Records$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Data Privacy Records table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchint
3Table No_ Searchint
4Field No_ Searchint
5Field DataType Searchnvarchar(40)
6Field Value Searchnvarchar(500)
7$systemId Searchuniqueidentifier
8$systemCreatedAt Searchdatetime
9$systemCreatedBy Searchuniqueidentifier
10$systemModifiedAt Searchdatetime
11$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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