User Default Style Sheet

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

Table Type: System

Table Name: User Default Style Sheet
Database Table Name: User Default Style Sheet

Table Number: 2000000067

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 Default Style Sheet can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [User Default Style Sheet]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[User ID]
   ,[Object Type]
   ,[Object ID]
   ,[Program ID]
   ,[Style Sheet ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [User Default Style Sheet]

Show/hide columns in User Default Style Sheet table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2User ID Primary Key Searchuniqueidentifier
3Object Type Primary Key Searchint
4Object ID Primary Key Searchint
5Program ID Primary Key Searchuniqueidentifier
6Style Sheet ID Searchuniqueidentifier
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 *