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
   [timestamp]
   ,[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]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$CDS Connection Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in CDS Connection Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(40)
3Server Address Searchnvarchar(500)
4User Name Searchnvarchar(500)
5User Password Key Searchuniqueidentifier
6Is Enabled Searchtinyint
7Business Events Enabled Searchtinyint
8Proxy Version Searchint
9CurrencyDecimalPrecision Searchint
10BaseCurrencyId Searchuniqueidentifier
11BaseCurrencyPrecision Searchint
12BaseCurrencySymbol Searchnvarchar(10)
13Authentication Type Searchint
14Connection String Searchnvarchar(4096)
15Domain Searchnvarchar(500)
16Disable Reason Searchnvarchar(500)
17Ownership Model Searchint
18Business Unit Id Searchuniqueidentifier
19Business Unit Name Searchnvarchar(320)
20Client Id Searchnvarchar(500)
21Client Secret Key Searchuniqueidentifier
22Redirect URL Searchnvarchar(500)
23Virtual Tables Config Id Searchuniqueidentifier
24$systemId Searchuniqueidentifier
25$systemCreatedAt Searchdatetime
26$systemCreatedBy Searchuniqueidentifier
27$systemModifiedAt Searchdatetime
28$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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