Spotlight Tour Text

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

Table Type: Company

Table Name: Spotlight Tour Text
Database Table Name: CRONUS UK Ltd_$Spotlight Tour Text$63ca2fa4-4f03-4f2b-a480-172fef340d3f

Table Number: 1997

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 Spotlight Tour Text can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Spotlight Tour Text$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Guided Experience Item Code]
   ,[Guided Experience Item Version]
   ,[Spotlight Tour Step]
   ,[Spotlight Tour Text]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Spotlight Tour Text$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

Show/hide columns in Spotlight Tour Text table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Guided Experience Item Code Primary Key Searchnvarchar(600)
3Guided Experience Item Version Primary Key Searchint
4Spotlight Tour Step Primary Key Searchint
5Spotlight Tour Text Searchnvarchar(500)
6$systemId Searchuniqueidentifier
7$systemCreatedAt Searchdatetime
8$systemCreatedBy Searchuniqueidentifier
9$systemModifiedAt Searchdatetime
10$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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