Guided Experience Item – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGuided Experience Item

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

Table Type: Company

Table Name: Guided Experience Item
Database Table Name: CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f

Table Number: 1990

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 Guided Experience Item can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

Show/hide an example select of all columns by name

SELECT

   [Code]
   ,[Version]
   ,[Object Type to Run]
   ,[Object ID to Run]
   ,[Link]
   ,[Title]
   ,[Short Title]
   ,[Description]
   ,[Expected Duration]
   ,[Extension ID]
   ,[Completed]
   ,[Guided Experience Type]
   ,[Assisted Setup Group]
   ,[Help Url]
   ,[Video Url]
   ,[Video Category]
   ,[Manual Setup Category]
   ,[Keywords]
   ,[Icon]
   ,[Spotlight Tour Type]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Guided Experience Item]
LEFT JOIN
   [CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Guided Experience Item]
      ON
         [Guided Experience Item].[Version] = [Guided Experience Item].[Version]
LEFT JOIN
   [User] AS [User]
      ON
         [Guided Experience Item].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Guided Experience Item].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Guided Experience Item table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Code	Code	Normal	Code	300	Code	nvarchar(600)
2	Version	Version	Normal	Integer	4	Version	int
3	Object Type to Run	Object Type to Run	Normal	Option	4	Object Type to Run	int
	Available options are: “Uninitialized” “Codeunit” “Page” “Report” “XmlPort”
4	Object ID to Run	Object ID to Run	Normal	Integer	4	Object ID to Run	int
5	Link	External Link	Normal	Text	250	Link	nvarchar(500)
6	Title	Title	Normal	Text	2048	Title	nvarchar(4096)
7	Short Title	Short Title	Normal	Text	50	Short Title	nvarchar(100)
8	Description	Description	Normal	Text	1024	Description	nvarchar(2048)
9	Expected Duration	Expected Duration	Normal	Integer	4	Expected Duration	int
10	Extension ID	Extension	Normal	GUID	16	Extension ID	uniqueidentifier
11	Extension Name	Extension Name	FlowField	Text	250
12	Completed	Completed	Normal	Boolean	4	Completed	tinyint
13	Guided Experience Type	Guided Experience Type	Normal	Option	4	Guided Experience Type	int
	Available options are: “Assisted Setup” “Manual Setup” “Learn” “Tour” “Spotlight Tour” “Video” “Application Feature”
14	Assisted Setup Group	Assisted Setup Group	Normal	Option	4	Assisted Setup Group	int
	Available options are: “Uncategorized” “GettingStarted” “Warehouse” “Journals” “Analysis” “Extensions” “Customize” “FirstInvoice” “FinancialReporting” “ReadyForBusiness” “Connect” “DoMoreWithBC” “ApprovalWorkflows” “Set Up Extended Security”
15	Help Url	Help Url	Normal	Text	250	Help Url	nvarchar(500)
16	Video Url	Video Url	Normal	Text	250	Video Url	nvarchar(500)
17	Video Category	Video Category	Normal	Option	4	Video Category	int
	Available options are: “Uncategorized” “GettingStarted” “Warehouse” “Journals” “Analysis” “Extensions” “Customize” “FirstInvoice” “FinancialReporting” “ReadyForBusiness” “Connect” “DoMoreWithBC” “ApprovalWorkflows”
18	Manual Setup Category	Manual Setup Category	Normal	Option	4	Manual Setup Category	int
	Available options are: “Uncategorized” “General” “Finance” “Sales” “Jobs” “Fixed Assets” “Purchasing” “Reference Data” “HR” “Inventory” “Service” “System” “Relationship Mgt” “Intercompany”
19	Keywords	Keywords	Normal	Text	250	Keywords	nvarchar(500)
20	Icon	Icon	Normal	Media	16	Icon	uniqueidentifier
21	Spotlight Tour Type	Spotlight Tour Type	Normal	Option	4	Spotlight Tour Type	int
	Available options are: “None” “Open in Excel” “Share to Teams” “Copilot”
22	Extension Publisher	Extension Publisher	FlowField	Text	250
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 [Guided Experience Item].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Guided Experience Item] LEFT JOIN [User] AS [User] ON [Guided Experience Item].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Guided Experience Item].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Guided Experience Item] LEFT JOIN [User] AS [User] ON [Guided Experience Item].[$systemModifiedBy] = [User].[User Security ID]