Intelligent Cloud Setup – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables System Tables IIntelligent Cloud Setup

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:

Table Number: 4003

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
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
	Key to join to the User table. Show/hide example query SELECT [Intelligent Cloud Setup].[] ,[User].[User Name] FROM [] AS [Intelligent Cloud Setup] LEFT JOIN [User] AS [User] ON [Intelligent Cloud Setup].[] = [User].[User Name]
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
	Key to join to the User table. Show/hide example query SELECT [Intelligent Cloud Setup].[] ,[User].[User Security ID] FROM [] AS [Intelligent Cloud Setup] LEFT JOIN [User] AS [User] ON [Intelligent Cloud Setup].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16