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: 1997Due 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.
SELECT
*
FROM
[CRONUS UK Ltd_$Spotlight Tour Text$63ca2fa4-4f03-4f2b-a480-172fef340d3f]
SELECT
[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]
SELECT
*
FROM
[CRONUS UK Ltd_$Spotlight Tour Text$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Spotlight Tour Text]
LEFT JOIN
[CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Guided Experience Item]
ON
[Spotlight Tour Text].[Guided Experience Item Code] = [Guided Experience Item].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Guided Experience Item]
ON
[Spotlight Tour Text].[Guided Experience Item Version] = [Guided Experience Item].[Version]
LEFT JOIN
[User] AS [User]
ON
[Spotlight Tour Text].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Spotlight Tour Text].[SystemModifiedBy] = [User].[User Security ID]
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|
| 1 | Guided Experience Item Code  | Guided Experience Item Code | Normal | Code | 300 | Guided Experience Item Code | nvarchar(600) |
| Key to join to the Guided Experience Item table.SELECT
[Spotlight Tour Text].[Guided Experience Item Code]
,[Guided Experience Item].[Code]
FROM
[CRONUS UK Ltd_$Spotlight Tour Text$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Spotlight Tour Text]
LEFT JOIN
[CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Guided Experience Item]
ON
[Spotlight Tour Text].[Guided Experience Item Code] = [Guided Experience Item].[Code] |
| 2 | Guided Experience Item Version  | Version | Normal | Integer | 4 | Guided Experience Item Version | int |
| Key to join to the Guided Experience Item table.SELECT
[Spotlight Tour Text].[Guided Experience Item Version]
,[Guided Experience Item].[Version]
FROM
[CRONUS UK Ltd_$Spotlight Tour Text$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Spotlight Tour Text]
LEFT JOIN
[CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Guided Experience Item]
ON
[Spotlight Tour Text].[Guided Experience Item Version] = [Guided Experience Item].[Version] |
| 3 | Spotlight Tour Step | Spotlight Tour Step | Normal | Option | 4 | Spotlight Tour Step | int |
| Available options are:
- “Step1Title”
- “Step1Text”
- “Step2Title”
- “Step2Text”
|
| 4 | Spotlight Tour Text | Spotlight Tour Text | Normal | Text | 250 | Spotlight Tour Text | nvarchar(500) |
| 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.SELECT
[Spotlight Tour Text].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Spotlight Tour Text$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Spotlight Tour Text]
LEFT JOIN
[User] AS [User]
ON
[Spotlight Tour Text].[$systemCreatedBy] = [User].[User Security ID] |
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
