Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/2000000173
Table Type: System
Table Name: Intelligent Cloud Status
Database Table Name: Intelligent Cloud Status
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 Intelligent Cloud Status can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[Intelligent Cloud Status]Show/hide an example select of all columns by name
SELECT
[Table Name]
,[Company Name]
,[Table Id]
,[Synced Version]
,[Blocked]
,[Replicate Data]
,[Preserve Cloud Data]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[Intelligent Cloud Status]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[Intelligent Cloud Status] AS [Intelligent Cloud Status]
LEFT JOIN
[Company] AS [Company]
ON
[Intelligent Cloud Status].[Company Name] = [Company].[Name]
LEFT JOIN
[CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping]
ON
[Intelligent Cloud Status].[Table ID] = [Data Exch. Mapping].[Table ID]
LEFT JOIN
[User] AS [User]
ON
[Intelligent Cloud Status].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Intelligent Cloud Status].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Intelligent Cloud Status table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Table Name   | Table Name | Normal | Text | 250 | Table Name | nvarchar(500) |
| 2 | Company Name | Company Name | Normal | Text | 30 | Company Name | nvarchar(60) |
Key to join to the Company table.Show/hide example querySELECT
[Intelligent Cloud Status].[Company Name]
,[Company].[Name]
FROM
[Intelligent Cloud Status] AS [Intelligent Cloud Status]
LEFT JOIN
[Company] AS [Company]
ON
[Intelligent Cloud Status].[Company Name] = [Company].[Name] | |||||||
| 3 | Table Id | Table Id | Normal | Integer | 4 | Table Id | int |
Key to join to the Data Exch. Mapping table.Show/hide example querySELECT
[Intelligent Cloud Status].[Table Id]
,[Data Exch. Mapping].[Table ID]
FROM
[Intelligent Cloud Status] AS [Intelligent Cloud Status]
LEFT JOIN
[CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping]
ON
[Intelligent Cloud Status].[Table Id] = [Data Exch. Mapping].[Table ID] | |||||||
| 4 | Synced Version | Synced Version | Normal | BigInteger | 8 | Synced Version | bigint |
| 5 | Blocked | Blocked | Normal | Boolean | 4 | Blocked | tinyint |
| 6 | Replicate Data | Replicate Data | Normal | Boolean | 4 | Replicate Data | tinyint |
| 7 | Preserve Cloud Data | Preserve Cloud Data | Normal | Boolean | 4 | Preserve Cloud Data | tinyint |
| 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 querySELECT
[Intelligent Cloud Status].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[Intelligent Cloud Status] AS [Intelligent Cloud Status]
LEFT JOIN
[User] AS [User]
ON
[Intelligent Cloud Status].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[Intelligent Cloud Status].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[Intelligent Cloud Status] AS [Intelligent Cloud Status]
LEFT JOIN
[User] AS [User]
ON
[Intelligent Cloud Status].[$systemModifiedBy] = [User].[User Security ID] | |||||||