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

Show/hide columns in CRM 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
6Last Update Invoice Entry No_ Searchint
7Restore Connection Searchtinyint
8Is Enabled Searchtinyint
9Is User Mapping Required Searchtinyint
10Is User Mapped To CRM User Searchtinyint
11CRM Version Searchnvarchar(60)
12Use Newest UI Searchtinyint
13Newest UI AppModuleId Searchnvarchar(100)
14Is S_Order Integration Enabled Searchtinyint
15Is CRM Solution Installed Searchtinyint
16Is Enabled For User Searchtinyint
17Dynamics NAV URL Searchnvarchar(500)
18Dynamics NAV OData URL Searchnvarchar(500)
19Dynamics NAV OData Username Searchnvarchar(500)
20Dynamics NAV OData Accesskey Searchnvarchar(500)
21Default CRM Price List ID Searchuniqueidentifier
22Proxy Version Searchint
23Auto Create Sales Orders Searchtinyint
24Auto Process Sales Quotes Searchtinyint
25CurrencyDecimalPrecision Searchint
26BaseCurrencyId Searchuniqueidentifier
27BaseCurrencyPrecision Searchint
28BaseCurrencySymbol Searchnvarchar(10)
29Authentication Type Searchint
30Connection String Searchnvarchar(500)
31Domain Searchnvarchar(500)
32Server Connection String Searchimage
33Disable Reason Searchnvarchar(500)
34Item Availability Enabled Searchtinyint
35$systemId Searchuniqueidentifier
36$systemCreatedAt Searchdatetime
37$systemCreatedBy Searchuniqueidentifier
38$systemModifiedAt Searchdatetime
39$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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