CRM Connection Setup

Dynamics 365 BC Table ReferenceTablesCompany TablesCCRM Connection Setup

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

Table Type: Company

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

Table Number: 5330

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$CRM 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]
   ,[Last Update Invoice Entry No_]
   ,[Restore Connection]
   ,[Is Enabled]
   ,[Is User Mapping Required]
   ,[Is User Mapped To CRM User]
   ,[CRM Version]
   ,[Use Newest UI]
   ,[Newest UI AppModuleId]
   ,[Is S_Order Integration Enabled]
   ,[Is CRM Solution Installed]
   ,[Is Enabled For User]
   ,[Dynamics NAV URL]
   ,[Dynamics NAV OData URL]
   ,[Dynamics NAV OData Username]
   ,[Dynamics NAV OData Accesskey]
   ,[Default CRM Price List ID]
   ,[Proxy Version]
   ,[Auto Create Sales Orders]
   ,[Auto Process Sales Quotes]
   ,[CurrencyDecimalPrecision]
   ,[BaseCurrencyId]
   ,[BaseCurrencyPrecision]
   ,[BaseCurrencySymbol]
   ,[Authentication Type]
   ,[Connection String]
   ,[Domain]
   ,[Server Connection String]
   ,[Disable Reason]
   ,[Item Availability Enabled]
   ,[Bidirectional Sales Order Int_]
   ,[Unit Group Mapping Enabled]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$CRM 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_$CRM Connection Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CRM Connection Setup]
LEFT JOIN
   [User] AS [User]
      ON
         [CRM Connection Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [CRM Connection Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in CRM Connection Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key SearchPrimary KeyNormalCode20Primary Keynvarchar(40)
2Server Address Primary Key SearchDynamics 365 Sales URLNormalText250Server Addressnvarchar(500)
3User Name SearchUser NameNormalText250User Namenvarchar(500)
4User Password Key SearchUser Password KeyNormalGUID16User Password Keyuniqueidentifier
5Last Update Invoice Entry No. SearchLast Update Invoice Entry No.NormalInteger4Last Update Invoice Entry No_int
59Restore Connection SearchRestore ConnectionNormalBoolean4Restore Connectiontinyint
60Is Enabled SearchIs EnabledNormalBoolean4Is Enabledtinyint
61Is User Mapping Required SearchBusiness Central Users Must Map to Dynamics 365 SaNormalBoolean4Is User Mapping Requiredtinyint
62Is User Mapped To CRM User SearchIs User Mapped To CRM UserNormalBoolean4Is User Mapped To CRM Usertinyint
63CRM Version SearchCRM VersionNormalText30CRM Versionnvarchar(60)
64Use Newest UI SearchUse Newest UINormalBoolean4Use Newest UItinyint
65Newest UI AppModuleId SearchNewest UI AppModuleIdNormalText50Newest UI AppModuleIdnvarchar(100)
66Is S.Order Integration Enabled SearchIs S.Order Integration EnabledNormalBoolean4Is S_Order Integration Enabledtinyint
67Is CRM Solution Installed SearchIs CRM Solution InstalledNormalBoolean4Is CRM Solution Installedtinyint
68Is Enabled For User SearchIs Enabled For UserNormalBoolean4Is Enabled For Usertinyint
69Dynamics NAV URL SearchDynamics NAV URLNormalText250Dynamics NAV URLnvarchar(500)
70Dynamics NAV OData URL SearchDynamics NAV OData URLNormalText250Dynamics NAV OData URLnvarchar(500)
71Dynamics NAV OData Username SearchDynamics NAV OData UsernameNormalText250Dynamics NAV OData Usernamenvarchar(500)
72Dynamics NAV OData Accesskey SearchDynamics NAV OData AccesskeyNormalText250Dynamics NAV OData Accesskeynvarchar(500)
75Default CRM Price List ID SearchDefault CRM Price List IDNormalGUID16Default CRM Price List IDuniqueidentifier
76Proxy Version SearchProxy VersionNormalInteger4Proxy Versionint
80Auto Create Sales Orders SearchAutomatically Create Sales OrdersNormalBoolean4Auto Create Sales Orderstinyint
81Auto Process Sales Quotes SearchAutomatically Process Sales QuotesNormalBoolean4Auto Process Sales Quotestinyint
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 StringNormalText250Connection Stringnvarchar(500)
137Domain SearchDomainNormalText250Domainnvarchar(500)
138Server Connection String SearchServer Connection StringNormalBLOB8Server Connection Stringimage
139Disable Reason SearchDisable ReasonNormalText250Disable Reasonnvarchar(500)
140Item Availability Enabled SearchItem Availability EnabledNormalBoolean4Item Availability Enabledtinyint
141Bidirectional Sales Order Int. SearchBidirectional Sales Order Int.NormalBoolean4Bidirectional Sales Order Int_tinyint
151Unit Group Mapping Enabled SearchUnit Group Mapping EnabledNormalBoolean4Unit Group Mapping Enabledtinyint
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
	       [CRM Connection Setup].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$CRM Connection Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CRM Connection Setup]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [CRM Connection Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesCCRM Connection Setup

Leave a Reply

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