Assisted Setup – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables AAssisted Setup

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

Table Type: Company

Table Name: Assisted Setup
Database Table Name: CRONUS UK Ltd_$Assisted Setup$63ca2fa4-4f03-4f2b-a480-172fef340d3f

Table Number: 1803

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Assisted Setup$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

Show/hide an example select of all columns by name

SELECT

   [Page ID]
   ,[Name]
   ,[Order]
   ,[Status]
   ,[Visible]
   ,[Parent]
   ,[Video Url]
   ,[Icon]
   ,[Item Type]
   ,[Featured]
   ,[Help Url]
   ,[Assisted Setup Page ID]
   ,[Tour Id]
   ,[Video Status]
   ,[Help Status]
   ,[Tour Status]
   ,[App ID]
   ,[Group Name]
   ,[Completed]
   ,[Video Category]
   ,[Description]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Assisted Setup$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

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

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

Show/hide columns in Assisted Setup table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Page ID	Page ID	Normal	Integer	4	Page ID	int
2	Name	Name	Normal	Text	2048	Name	nvarchar(4096)
3	Order	Order	Normal	Integer	4	Order	int
4	Status	Status	Normal	Option	4	Status	int
	Available options are: “Not Completed” “Completed” “Not Started” “Seen” “Watched” “Read” ” “
5	Visible	Visible	Normal	Boolean	4	Visible	tinyint
6	Parent	Parent	Normal	Integer	4	Parent	int
7	Video Url	Video Url	Normal	Text	250	Video Url	nvarchar(500)
8	Icon	Icon	Normal	Media	16	Icon	uniqueidentifier
9	Item Type	Item Type	Normal	Option	4	Item Type	int
	Available options are: ” “ “Group” “Setup and Help”
10	Featured	Featured	Normal	Boolean	4	Featured	tinyint
11	Help Url	Help Url	Normal	Text	250	Help Url	nvarchar(500)
12	Assisted Setup Page ID	Assisted Setup Page ID	Normal	Integer	4	Assisted Setup Page ID	int
13	Tour Id	Tour Id	Normal	Integer	4	Tour Id	int
14	Video Status	Video Status	Normal	Boolean	4	Video Status	tinyint
15	Help Status	Help Status	Normal	Boolean	4	Help Status	tinyint
16	Tour Status	Tour Status	Normal	Boolean	4	Tour Status	tinyint
19	App ID	App ID	Normal	GUID	16	App ID	uniqueidentifier
20	Extension Name	Extension Name	FlowField	Text	250
21	Group Name	Group	Normal	Option	4	Group Name	int
	Available options are: “Uncategorized” “GettingStarted” “Warehouse” “Journals” “Analysis” “Extensions” “Customize” “FirstInvoice” “FinancialReporting” “ReadyForBusiness” “Connect” “DoMoreWithBC” “ApprovalWorkflows” “Set Up Extended Security”
22	Completed	Completed	Normal	Boolean	4	Completed	tinyint
23	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”
24	Description	Description	Normal	Text	1024	Description	nvarchar(2048)
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 [Assisted Setup].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Assisted Setup$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Assisted Setup] LEFT JOIN [User] AS [User] ON [Assisted Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Dynamics 365 BC Table Reference Tables Company Tables AAssisted Setup

Show/hide an example select of all columns

Show/hide an example select of all columns by name

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

Show/hide columns in Assisted Setup table

Show/hide example query

Leave a Reply Cancel reply