Profile

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

Table Type: System

Table Name: Profile
Database Table Name: Profile

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [Profile]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Profile ID]
   ,[Description]
   ,[Role Center ID]
   ,[Default Role Center]
   ,[Use Comments]
   ,[Use Notes]
   ,[Use Record Notes]
   ,[Record Notebook]
   ,[Use Page Notes]
   ,[Page Notebook]
   ,[Disable Personalization]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Profile]

Show/hide columns in Profile table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Profile ID Primary Key Searchnvarchar(60)
3Description Searchnvarchar(500)
4Role Center ID Searchint
5Default Role Center Searchtinyint
6Use Comments Searchtinyint
7Use Notes Searchtinyint
8Use Record Notes Searchtinyint
9Record Notebook Searchnvarchar(500)
10Use Page Notes Searchtinyint
11Page Notebook Searchnvarchar(500)
12Disable Personalization Searchtinyint
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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