Aggregated Assisted Setup

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

Table Type: Company

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

Table Number: 1808

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Page ID]
   ,[Name]
   ,[Order]
   ,[Status]
   ,[Visible]
   ,[Icon]
   ,[Item Type]
   ,[Assisted Setup Page ID]
   ,[External Assisted Setup]
   ,[Record ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Aggregated Assisted Setup$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

Show/hide columns in Aggregated Assisted Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Page ID Primary Key Searchint
3Name Searchnvarchar(500)
4Order Searchint
5Status Searchint
6Visible Searchtinyint
7Icon Searchuniqueidentifier
8Item Type Searchint
9Assisted Setup Page ID Searchint
10External Assisted Setup Searchtinyint
11Record ID Searchvarbinary(448)
12$systemId Searchuniqueidentifier
13$systemCreatedAt Searchdatetime
14$systemCreatedBy Searchuniqueidentifier
15$systemModifiedAt Searchdatetime
16$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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