Object Options – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables System Tables OObject 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

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

FROM

   [Object Options]

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

SELECT
   *
FROM
   [Object Options] AS [Object Options]
LEFT JOIN
   [Company] AS [Company]
      ON
         [Object Options].[Company Name] = [Company].[Name]
LEFT JOIN
   [User] AS [User]
      ON
         [Object Options].[Created By] = [User].[User Name]
LEFT JOIN
   [User] AS [User]
      ON
         [Object Options].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Object Options].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Object Options table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Parameter Name	Parameter Name	Normal	Text	50	Parameter Name	nvarchar(100)
2	Object ID	Object ID	Normal	Integer	4	Object ID	int
3	Object Type	Object Type	Normal	Option	4	Object Type	int
	Available options are: “” “Report” “XMLportPage”
4	Company Name	Company Name	Normal	Text	30	Company Name	nvarchar(60)
	Key to join to the Company table. Show/hide example query SELECT [Object Options].[Company Name] ,[Company].[Name] FROM [Object Options] AS [Object Options] LEFT JOIN [Company] AS [Company] ON [Object Options].[Company Name] = [Company].[Name]
5	User Name	User Name	Normal	Code	50	User Name	nvarchar(100)
6	Option Data	Option Data	Normal	BLOB	8	Option Data	image
7	Public Visible	Public Visible	Normal	Boolean	4	Public Visible	tinyint
8	Temporary	Temporary	Normal	Boolean	4	Temporary	tinyint
9	Created By	Created By	Normal	Code	50	Created By	nvarchar(100)
	Key to join to the User table. Show/hide example query SELECT [Object Options].[Created By] ,[User].[User Name] FROM [Object Options] AS [Object Options] LEFT JOIN [User] AS [User] ON [Object Options].[Created By] = [User].[User Name]
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 [Object Options].[$systemCreatedBy] ,[User].[User Security ID] FROM [Object Options] AS [Object Options] LEFT JOIN [User] AS [User] ON [Object Options].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier