Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/4003
Table Type: System
Table Name: Intelligent Cloud Setup
Database Table Name:
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 Setup can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[]Show/hide an example select of all columns by name
SELECT
FROM
[]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[] AS [Intelligent Cloud Setup]
LEFT JOIN
[User] AS [User]
ON
[Intelligent Cloud Setup].[Replication User] = [User].[User Name]
LEFT JOIN
[User] AS [User]
ON
[Intelligent Cloud Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Intelligent Cloud Setup].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Intelligent Cloud Setup table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Primary Key   | Primary Key | Normal | Code | 10 | ||
| 2 | Product ID | Product ID | Normal | Text | 250 | ||
| 3 | Sql Server Type | Sql Server Type | Normal | Option | 4 | ||
| 4 | Time to Run | Time to Run | Normal | Time | 4 | ||
| 5 | Replication Enabled | Replication Enabled | Normal | Boolean | 4 | ||
| 6 | Recurrence | Recurrence | Normal | Option | 4 | ||
| 7 | Sunday | Sunday | Normal | Boolean | 4 | ||
| 8 | Monday | Monday | Normal | Boolean | 4 | ||
| 9 | Tuesday | Tuesday | Normal | Boolean | 4 | ||
| 10 | Wednesday | Wednesday | Normal | Boolean | 4 | ||
| 11 | Thursday | Thursday | Normal | Boolean | 4 | ||
| 12 | Friday | Friday | Normal | Boolean | 4 | ||
| 13 | Saturday | Saturday | Normal | Boolean | 4 | ||
| 14 | Company Creation Task ID | Company Creation Task ID | Normal | GUID | 16 | ||
| 15 | Company Creation Task Status | Company Creation Task Status | Normal | Option | 4 | ||
| 16 | Company Creation Task Error | Company Creation Task Error | Normal | Text | 250 | ||
| 18 | Replication User | Replication User | Normal | Code | 50 | ||
| 19 | Deployed Version | Deployed Version | Normal | Code | 10 | ||
| 20 | Latest Version | Latest Version | Normal | Code | 10 | ||
| 21 | Upgrade Tag Backup ID | Upgrade Tag Backup ID | Normal | Integer | 4 | ||
| 22 | Schedule Upgrade | Schedule Upgrade | Normal | Boolean | 4 | ||
| 23 | Company Creation Session ID | Company Creation Session ID | Normal | Integer | 4 | ||
| 24 | DisabledReason | DisabledReason | Normal | Option | 4 | ||
| 25 | Use New UI | Use New UI | Normal | Option | 4 | ||
| 26 | Keep User Permissions | Keep User Permissions | Normal | Boolean | 4 | ||
| 40 | Source BC Version | Version of the On Premise BC database | Normal | Decimal | 12 | ||
| 41 | Use Legacy Upgrade Engine | Use Legacy Upgrade Engine | Normal | Boolean | 4 | ||
| 2000000000 | $systemId | System ID | Normal | GUID | 16 | ||
| 2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | ||
| 2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | ||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | ||
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 |