---
title: "Table 5330 CRM Connection Setup"
author: "Jonas Paprotka"
url: https://jonas-paprotka.de/ref/table/5330-crm-connection-setup/
type: table
id: 5330
name: "CRM Connection Setup"
app: "Base Application"
namespace: Microsoft.Integration.D365Sales
versions: "17-28"
build: 28.5.54151.54365
source: "https://jonas-paprotka.de/ref/table/5330-crm-connection-setup/source/29/"
checked: 2026-09-20
subject: "Microsoft Dynamics 365 Business Central"
license: "Content © 2026 Jonas Paprotka. Quote freely with attribution and a link."
---

# Table 5330 CRM Connection Setup

Jonas Paprotka, https://jonas-paprotka.de/ref/table/5330-crm-connection-setup/

| | |
| --- | --- |
| App | Base Application |
| Namespace | Microsoft.Integration.D365Sales |
| Versions | 17-28 |
| Source file | Integration/D365Sales/CRMConnectionSetup.Table.al |

## Fields

| Id | Name | Type | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| 1 | Primary Key | Code[20] | 17-28 | - | - |
| 2 | Server Address | Text[250] | 17-28 | - | - |
| 3 | User Name | Text[250] | 17-28 | - | - |
| 4 | User Password Key | Guid | 17-28 | - | - |
| 5 | Last Update Invoice Entry No. | Integer | 17-25 | Removed 15.0 | Moved this field to Table 5328 - CRM Synch Status as this field is getting updated by job queue and it is blocking the record.  |
| 59 | Restore Connection | Boolean | 17-28 | - | - |
| 60 | Is Enabled | Boolean | 17-28 | - | - |
| 61 | Is User Mapping Required | Boolean | 17-28 | Removed 26.0 | This functionality is not in use and not supported |
| 62 | Is User Mapped To CRM User | Boolean | 17-28 | Removed 26.0 | This functionality is not in use and not supported |
| 63 | CRM Version | Text[30] | 17-28 | - | - |
| 64 | Use Newest UI | Boolean | 17-28 | - | - |
| 65 | Newest UI AppModuleId | Text[50] | 17-28 | - | - |
| 66 | Is S.Order Integration Enabled | Boolean | 17-28 | - | - |
| 67 | Is CRM Solution Installed | Boolean | 17-28 | - | - |
| 68 | Is Enabled For User | Boolean | 17-28 | Removed 26.0 | Use field "Is Enabled" instead. |
| 69 | Dynamics NAV URL | Text[250] | 17-28 | - | - |
| 70 | Dynamics NAV OData URL | Text[250] | 17-25 | Removed 23.0 | This functionality is replaced with new item availability job queue entry. |
| 71 | Dynamics NAV OData Username | Text[250] | 17-25 | Removed 23.0 | This functionality is replaced with new item availability job queue entry. |
| 72 | Dynamics NAV OData Accesskey | Text[250] | 17-25 | Removed 23.0 | This functionality is replaced with new item availability job queue entry. |
| 75 | Default CRM Price List ID | Guid | 17-28 | - | - |
| 76 | Proxy Version | Integer | 17-28 | - | - |
| 80 | Auto Create Sales Orders | Boolean | 17-28 | - | - |
| 81 | Auto Process Sales Quotes | Boolean | 17-28 | - | - |
| 118 | CurrencyDecimalPrecision | Integer | 17-28 | - | - |
| 124 | BaseCurrencyId | Guid | 17-28 | - | - |
| 133 | BaseCurrencyPrecision | Integer | 17-28 | - | - |
| 134 | BaseCurrencySymbol | Text[5] | 17-28 | - | - |
| 135 | Authentication Type | Option | 17-28 | - | - |
| 136 | Connection String | Text[250] | 17-28 | - | - |
| 137 | Domain | Text[250] | 17-28 | - | - |
| 138 | Server Connection String | Blob | 17-28 | - | - |
| 139 | Disable Reason | Text[250] | 17-28 | - | - |
| 140 | Item Availability Enabled | Boolean | 18-28 | - | - |
| 141 | Bidirectional Sales Order Int. | Boolean | 21-28 | - | - |
| 151 | Unit Group Mapping Enabled | Boolean | 21-28 | - | - |

## Keys

| Name | Fields | Versions |
| --- | --- | --- |
| Key1, clustered | Primary Key | 17-28 |

## Procedures

| Name | Parameters | Returns | Access | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- | --- |
| EnsureCDSConnectionIsEnabled | () | - | public | 17-28 | - | - |
| LoadConnectionStringElementsFromCDSConnectionSetup | () | - | public | 17-28 | - | - |
| DeployCRMSolution | (Boolean) | - | public | 17-28 | - | - |
| CountCRMJobQueueEntries | (var Integer, var Integer) | - | public | 17-28 | - | - |
| HasPassword | () | Boolean | public | 17-28 | - | - |
| SetPassword | (Text) | - | public | 17-27 | Pending 25.0 | Use SetPassword(PasswordText: SecretText) instead. |
| DeletePassword | () | - | public | 17-28 | - | - |
| UpdateAllConnectionRegistrations | () | - | public | 17-22 | Pending 20.0 | This functionality is not in use and not supported |
| UpdateIsEnabledState | () | - | public | 17-22 | Pending 20.0 | This functionality is not in use and not supported |
| RegisterConnection | () | - | public | 17-28 | - | - |
| RegisterConnectionWithName | (Text) | - | public | 17-28 | - | - |
| UnregisterConnection | () | Boolean | public | 17-28 | - | - |
| UnregisterConnectionWithName | (Text) | Boolean | public | 17-28 | - | - |
| GetConnectionStringWithCredentials | () | Text | public | 17-27 | Pending 25.0 | Use the GetSecretConnectionStringWithCredentials procedure instead. |
| RegisterUserConnection | () | Text | public | 17-22 | Pending 20.0 | Use RegisterConnection instead. |
| GetIntegrationUserID | () | Guid | public | 17-28 | - | - |
| GetPassword | () | Text | public | 17-27 | Pending 25.0 | Use the procedure GetSecretPassword instead. |
| GetJobQueueEntriesObjectIDToRunFilter | () | Text | public | 17-28 | - | - |
| PerformTestConnection | () | - | public | 17-28 | - | - |
| VerifyTestConnection | () | Boolean | public | 17-28 | - | - |
| TestConnection | () | Boolean | public | 17-28 | - | - |
| TestIntegrationUserRequirements | () | - | public | 17-28 | - | - |
| TryReadSystemUsers | () | Boolean | public | 17-28 | - | - |
| IsVersionValid | () | Boolean | public | 17-28 | - | - |
| IsCurrentUserMappedToCrmSystemUser | () | Boolean | public | 17-22 | Pending 20.0 | This functionality is not in use and not supported |
| UpdateFromWizard | (var Record CRM Connection Setup, Text) | - | public | 17-27 | Pending 25.0 | Use the procedure that receives PasswordText as SecretText instead. |
| EnableCRMConnectionFromWizard | () | - | public | 17-28 | - | - |
| RestoreConnection | () | - | public | 17-28 | - | - |
| SetCRMSOPEnabled | () | - | public | 17-28 | - | - |
| SetCRMSOPDisabled | () | - | public | 17-28 | - | - |
| SetCRMSOPEnabledWithCredentials | (Text[250], Text, Boolean) | - | public | 17 | - | - |
| SetUserAsIntegrationUser | () | - | public | 17-28 | - | - |
| RefreshDataFromCRM | () | - | public | 17-28 | - | - |
| PerformWebClientUrlReset | () | - | public | 17-28 | - | - |
| SynchronizeNow | (Boolean) | - | public | 17-28 | - | - |
| PromptForCredentials | (var Text, var Text) | Boolean | public | 17-28 | - | - |
| DoReadCRMData | () | Boolean | public | 17-28 | - | - |
| GetDefaultCRMConnection | (Text) | Text | public | 17-28 | - | - |
| UpdateConnectionString | () | Text | public | 17-28 | - | - |
| UpdateCRMJobQueueEntriesStatus | () | - | public | 17-28 | - | - |
| GetConnectionString | () | Text | public | 17-28 | - | - |
| SetConnectionString | (Text) | - | public | 17-28 | - | - |
| IsEnabled | () | Boolean | public | 17-28 | - | - |
| SetUseNewestUI | () | - | public | 17-28 | - | - |
| SetCRMSOPEnabledWithCredentials | (Text, Text, Boolean) | - | public | 18-28 | - | - |
| RefreshDataFromCRM | (Boolean) | - | public | 18-28 | - | - |
| PromptForCredentials | (var Text, var Text, var Text) | Boolean | public | 18-28 | - | - |
| IsBidirectionalSalesOrderIntEnabled | () | Boolean | public | 21-28 | - | - |
| GetProxyVersion | () | Integer | internal | 22-28 | - | - |
| SetPassword | (SecretText) | - | public | 25-28 | - | - |
| GetSecretConnectionStringWithCredentials | () | SecretText | public | 25-28 | - | - |
| GetSecretPassword | () | SecretText | public | 25-28 | - | - |
| UpdateFromWizard | (var Record CRM Connection Setup, SecretText) | - | public | 25-28 | - | - |

## Events

| Kind | Name | Parameters | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| Integration event | OnReadingCRMData | (var Boolean) | 17-28 | - | - |
| Integration event | OnGetDefaultCRMConnection | (var Text) | 17-28 | - | - |
| Integration event | OnBeforeVerifyBaseCurrencyMatchesLCY | (var Boolean) | 20-28 | - | - |

## Source

Symbols: Microsoft.BaseApplication.symbols.437dbf0e-84ff-417a-965d-ed2bb9650972, https://dynamicssmb2.pkgs.visualstudio.com/DynamicsBCPublicFeeds/_packaging/MSSymbols/nuget/v3/index.json, highest build per major on 2026-09-20.
AL source 29: https://github.com/microsoft/BCApps, MIT, releases/29.x at a66254c3b8b5bb1cea290dc8f9d097aec4381153.

Jonas Paprotka, 2026-09-20.