Assisted 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Page ID Primary Key SearchPage IDNormalInteger4Page IDint
2Name SearchNameNormalText2048Namenvarchar(4096)
3Order SearchOrderNormalInteger4Orderint
4Status SearchStatusNormalOption4Statusint
Available options are:
  • “Not Completed”
  • “Completed”
  • “Not Started”
  • “Seen”
  • “Watched”
  • “Read”
  • ” “
5Visible SearchVisibleNormalBoolean4Visibletinyint
6Parent SearchParentNormalInteger4Parentint
7Video Url SearchVideo UrlNormalText250Video Urlnvarchar(500)
8Icon SearchIconNormalMedia16Iconuniqueidentifier
9Item Type SearchItem TypeNormalOption4Item Typeint
Available options are:
  • ” “
  • “Group”
  • “Setup and Help”
10Featured SearchFeaturedNormalBoolean4Featuredtinyint
11Help Url SearchHelp UrlNormalText250Help Urlnvarchar(500)
12Assisted Setup Page ID SearchAssisted Setup Page IDNormalInteger4Assisted Setup Page IDint
13Tour Id SearchTour IdNormalInteger4Tour Idint
14Video Status SearchVideo StatusNormalBoolean4Video Statustinyint
15Help Status SearchHelp StatusNormalBoolean4Help Statustinyint
16Tour Status SearchTour StatusNormalBoolean4Tour Statustinyint
19App ID SearchApp IDNormalGUID16App IDuniqueidentifier
20Extension Name SearchExtension NameFlowFieldText250
21Group Name SearchGroupNormalOption4Group Nameint
Available options are:
  • “Uncategorized”
  • “GettingStarted”
  • “Warehouse”
  • “Journals”
  • “Analysis”
  • “Extensions”
  • “Customize”
  • “FirstInvoice”
  • “FinancialReporting”
  • “ReadyForBusiness”
  • “Connect”
  • “DoMoreWithBC”
  • “ApprovalWorkflows”
  • “Set Up Extended Security”
22Completed SearchCompletedNormalBoolean4Completedtinyint
23Video Category SearchVideo CategoryNormalOption4Video Categoryint
Available options are:
  • “Uncategorized”
  • “GettingStarted”
  • “Warehouse”
  • “Journals”
  • “Analysis”
  • “Extensions”
  • “Customize”
  • “FirstInvoice”
  • “FinancialReporting”
  • “ReadyForBusiness”
  • “Connect”
  • “DoMoreWithBC”
  • “ApprovalWorkflows”
24Description SearchDescriptionNormalText1024Descriptionnvarchar(2048)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Assisted Setup].[$systemModifiedBy]
       ,[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].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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