CRM Connection Setup – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCRM 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Primary Key	Primary Key	Normal	Code	20	Primary Key	nvarchar(40)
2	Server Address	Dynamics 365 Sales URL	Normal	Text	250	Server Address	nvarchar(500)
3	User Name	User Name	Normal	Text	250	User Name	nvarchar(500)
4	User Password Key	User Password Key	Normal	GUID	16	User Password Key	uniqueidentifier
5	Last Update Invoice Entry No.	Last Update Invoice Entry No.	Normal	Integer	4	Last Update Invoice Entry No_	int
59	Restore Connection	Restore Connection	Normal	Boolean	4	Restore Connection	tinyint
60	Is Enabled	Is Enabled	Normal	Boolean	4	Is Enabled	tinyint
61	Is User Mapping Required	Business Central Users Must Map to Dynamics 365 Sa	Normal	Boolean	4	Is User Mapping Required	tinyint
62	Is User Mapped To CRM User	Is User Mapped To CRM User	Normal	Boolean	4	Is User Mapped To CRM User	tinyint
63	CRM Version	CRM Version	Normal	Text	30	CRM Version	nvarchar(60)
64	Use Newest UI	Use Newest UI	Normal	Boolean	4	Use Newest UI	tinyint
65	Newest UI AppModuleId	Newest UI AppModuleId	Normal	Text	50	Newest UI AppModuleId	nvarchar(100)
66	Is S.Order Integration Enabled	Is S.Order Integration Enabled	Normal	Boolean	4	Is S_Order Integration Enabled	tinyint
67	Is CRM Solution Installed	Is CRM Solution Installed	Normal	Boolean	4	Is CRM Solution Installed	tinyint
68	Is Enabled For User	Is Enabled For User	Normal	Boolean	4	Is Enabled For User	tinyint
69	Dynamics NAV URL	Dynamics NAV URL	Normal	Text	250	Dynamics NAV URL	nvarchar(500)
70	Dynamics NAV OData URL	Dynamics NAV OData URL	Normal	Text	250	Dynamics NAV OData URL	nvarchar(500)
71	Dynamics NAV OData Username	Dynamics NAV OData Username	Normal	Text	250	Dynamics NAV OData Username	nvarchar(500)
72	Dynamics NAV OData Accesskey	Dynamics NAV OData Accesskey	Normal	Text	250	Dynamics NAV OData Accesskey	nvarchar(500)
75	Default CRM Price List ID	Default CRM Price List ID	Normal	GUID	16	Default CRM Price List ID	uniqueidentifier
76	Proxy Version	Proxy Version	Normal	Integer	4	Proxy Version	int
80	Auto Create Sales Orders	Automatically Create Sales Orders	Normal	Boolean	4	Auto Create Sales Orders	tinyint
81	Auto Process Sales Quotes	Automatically Process Sales Quotes	Normal	Boolean	4	Auto Process Sales Quotes	tinyint
118	CurrencyDecimalPrecision	Currency Decimal Precision	Normal	Integer	4	CurrencyDecimalPrecision	int
124	BaseCurrencyId	Currency	Normal	GUID	16	BaseCurrencyId	uniqueidentifier
133	BaseCurrencyPrecision	Base Currency Precision	Normal	Integer	4	BaseCurrencyPrecision	int
134	BaseCurrencySymbol	Base Currency Symbol	Normal	Text	5	BaseCurrencySymbol	nvarchar(10)
135	Authentication Type	Authentication Type	Normal	Option	4	Authentication Type	int
	Available options are: “Office365” “AD” “IFD” “OAuth”
136	Connection String	Connection String	Normal	Text	250	Connection String	nvarchar(500)
137	Domain	Domain	Normal	Text	250	Domain	nvarchar(500)
138	Server Connection String	Server Connection String	Normal	BLOB	8	Server Connection String	image
139	Disable Reason	Disable Reason	Normal	Text	250	Disable Reason	nvarchar(500)
140	Item Availability Enabled	Item Availability Enabled	Normal	Boolean	4	Item Availability Enabled	tinyint
141	Bidirectional Sales Order Int.	Bidirectional Sales Order Int.	Normal	Boolean	4	Bidirectional Sales Order Int_	tinyint
151	Unit Group Mapping Enabled	Unit Group Mapping Enabled	Normal	Boolean	4	Unit Group Mapping Enabled	tinyint
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [CRM Connection Setup].[$systemModifiedBy] ,[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].[$systemModifiedBy] = [User].[User Security ID]