CDS Connection Setup

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

Table Type: Company

Table Name: CDS Connection Setup
Database Table Name: CRONUS UK Ltd_$CDS Connection Setup$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 7200

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 CDS Connection Setup can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$CDS Connection Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Primary Key]
   ,[Server Address]
   ,[User Name]
   ,[User Password Key]
   ,[Is Enabled]
   ,[Business Events Enabled]
   ,[Proxy Version]
   ,[CurrencyDecimalPrecision]
   ,[BaseCurrencyId]
   ,[BaseCurrencyPrecision]
   ,[BaseCurrencySymbol]
   ,[Authentication Type]
   ,[Connection String]
   ,[Domain]
   ,[Disable Reason]
   ,[Ownership Model]
   ,[Business Unit Id]
   ,[Business Unit Name]
   ,[Client Id]
   ,[Client Secret Key]
   ,[Redirect URL]
   ,[Virtual Tables Config Id]
   ,[BaseCurrencyCode]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$CDS Connection Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$CDS Connection Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CDS Connection Setup]
LEFT JOIN
   [User] AS [User]
      ON
         [CDS Connection Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [CDS Connection Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in CDS Connection Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key Primary Key SearchPrimary KeyNormalCode20Primary Keynvarchar(40)
2Server Address SearchEnvironment URLNormalText250Server Addressnvarchar(500)
3User Name SearchUser NameNormalText250User Namenvarchar(500)
4User Password Key SearchUser Password KeyNormalGUID16User Password Keyuniqueidentifier
60Is Enabled SearchSynchronization EnabledNormalBoolean4Is Enabledtinyint
61Business Events Enabled SearchBusiness Events EnabledNormalBoolean4Business Events Enabledtinyint
76Proxy Version SearchProxy VersionNormalInteger4Proxy Versionint
118CurrencyDecimalPrecision SearchCurrency Decimal PrecisionNormalInteger4CurrencyDecimalPrecisionint
124BaseCurrencyId SearchCurrencyNormalGUID16BaseCurrencyIduniqueidentifier
133BaseCurrencyPrecision SearchBase Currency PrecisionNormalInteger4BaseCurrencyPrecisionint
134BaseCurrencySymbol SearchBase Currency SymbolNormalText5BaseCurrencySymbolnvarchar(10)
135Authentication Type SearchAuthentication TypeNormalOption4Authentication Typeint
Available options are:
  • “Office365”
  • “AD”
  • “IFD”
  • “OAuth”
136Connection String SearchConnection StringNormalText2048Connection Stringnvarchar(4096)
137Domain SearchDomainNormalText250Domainnvarchar(500)
139Disable Reason SearchDisable ReasonNormalText250Disable Reasonnvarchar(500)
140Ownership Model SearchOwnership ModelNormalOption4Ownership Modelint
Available options are:
  • “”
  • “Person”
  • “Team”
150Business Unit Id SearchBusiness Unit IDNormalGUID16Business Unit Iduniqueidentifier
151Business Unit Name SearchBusiness Unit NameNormalText160Business Unit Namenvarchar(320)
153Client Id SearchClient IdNormalText250Client Idnvarchar(500)
154Client Secret Key SearchClient Secret KeyNormalGUID16Client Secret Keyuniqueidentifier
155Redirect URL SearchRedirect URLNormalText250Redirect URLnvarchar(500)
156Virtual Tables Config Id SearchVirtual Tables Config IDNormalGUID16Virtual Tables Config Iduniqueidentifier
241BaseCurrencyCode SearchBase Currency CodeNormalText5BaseCurrencyCodenvarchar(10)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [CDS Connection Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$CDS Connection Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CDS Connection Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [CDS Connection Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [CDS Connection Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$CDS Connection Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CDS Connection Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [CDS Connection Setup].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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