Object Options

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

Table Type: System

Table Name: Object Options
Database Table Name: Object Options

Table Number: 2000000196

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [Object Options]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Parameter Name]
   ,[Object ID]
   ,[Object Type]
   ,[User Name]
   ,[Company Name]
   ,[Option Data]
   ,[Public Visible]
   ,[Temporary]
   ,[Created By]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Object Options]

Show/hide columns in Object Options table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Parameter Name Primary Key Searchnvarchar(100)
3Object ID Primary Key Searchint
4Object Type Primary Key Searchint
5User Name Primary Key Searchnvarchar(100)
6Company Name Primary Key Searchnvarchar(60)
7Option Data Searchimage
8Public Visible Searchtinyint
9Temporary Searchtinyint
10Created By Searchnvarchar(100)
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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