---
id: object/table/5330
type: object
title: Table 5330 "CRM Connection Setup"
summary: Table 5330 "CRM Connection Setup" in Base Application (Microsoft.Integration.D365Sales). 31 fields, 44 public procedures, 3 events. Present since at least BC23, still in BC30, changed in BC24-26, BC28.
tier: official
language: en
tags:
  - table
  - base application
versions:
  introduced: null
  last_changed: "28"
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 9979ebb2760f67346956b08de88cf228c92324d437d438558e6e9897f6718ce8
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Integration/D365Sales/CRMConnectionSetup.Table.al
    title: src/Layers/W1/BaseApp/Integration/D365Sales/CRMConnectionSetup.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 5330
name: CRM Connection Setup
caption: Microsoft Dynamics 365 Connection Setup
namespace: Microsoft.Integration.D365Sales
app: Base Application
extends: null
first_version: "23"
last_version: "30"
present_in:
  - "23"
  - "24"
  - "25"
  - "26"
  - "27"
  - "28"
  - "29"
  - "30"
changed_in:
  - "24"
  - "25"
  - "26"
  - "28"
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 31
  procedures: 69
  events: 3
  subscribers: 0
relations:
  out: 1
  referenced_by: 0
  pages: 2
  extended_by: 0
  event_subscribers: 2
  calls: 8
  called_by: 0
  implements: 0
---

# Table 5330 "CRM Connection Setup"

> Table 5330 "CRM Connection Setup" in Base Application (Microsoft.Integration.D365Sales). 31 fields, 44 public procedures, 3 events. Present since at least BC23, still in BC30, changed in BC24-26, BC28.

Base Application · Microsoft.Integration.D365Sales · captioned "Microsoft Dynamics 365 Connection Setup" · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Integration/D365Sales/CRMConnectionSetup.Table.al) · facts from BC29

## Properties

| Property | Value |
|---|---|
| Caption | Microsoft Dynamics 365 Connection Setup |
| DataClassification | CustomerContent |
| Permissions | tabledata "CRM Connection Setup" = r |

## Fields

Explanation: the field's ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Primary Key | Code[20] | — |  |
| 2 | Server Address | Text[250] | Specifies the URL of the Dynamics 365 Sales server that hosts the Dynamics 365 Sales solution that you want to connect to. |  |
| 3 | User Name | Text[250] | Specifies the user name of a Dynamics 365 Sales account. | DataClassification EndUserIdentifiableInformation |
| 4 | User Password Key | Guid | — | DataClassification EndUserPseudonymousIdentifiers |
| 59 | Restore Connection | Boolean | — |  |
| 60 | Is Enabled | Boolean | Specifies if the connection to Dynamics 365 Sales is enabled. When you check this checkbox, you will be prompted to sign-in to Dataverse with an administrator user account. The account will be used one time to give consent to, install and configure applications and components that the integration re... |  |
| 61 | Is User Mapping Required | Boolean | Business Central Users Must Map to Dynamics 365 Sales Users <small>caption</small> | obsolete Removed 26.0; #if not CLEANSCHEMA26 |
| 62 | Is User Mapped To CRM User | Boolean | — | obsolete Removed 26.0; #if not CLEANSCHEMA26 |
| 63 | CRM Version | Text[30] | — |  |
| 64 | Use Newest UI | Boolean | Specifies that coupled Dynamics 365 Sales entities should open in Sales Hub. | DataClassification SystemMetadata |
| 65 | Newest UI AppModuleId | Text[50] | — | DataClassification SystemMetadata |
| 66 | Is S.Order Integration Enabled | Boolean | Specifies that it is possible for Dynamics 365 Sales users to submit sales orders that can then be viewed and imported in Dynamics 365. |  |
| 67 | Is CRM Solution Installed | Boolean | Specifies if the Integration Solution is installed and configured in Dynamics 365 Sales. You cannot change this setting. |  |
| 68 | Is Enabled For User | Boolean | — | obsolete Removed 26.0; #if not CLEANSCHEMA26 |
| 69 | Dynamics NAV URL | Text[250] | Specifies the URL to the Business Central web client. From records in Dynamics 365 Sales, such as an account or product, users can open a corresponding (coupled) record in Business Central. Set this field to the URL of the Business Central web client instance to use. |  |
| 75 | Default CRM Price List ID | Guid | — |  |
| 76 | Proxy Version | Integer | Specifies the Microsoft Dynamics 365 (CRM) software development kit version that is used to connect to Dynamics 365 Sales. | DataClassification SystemMetadata |
| 80 | Auto Create Sales Orders | Boolean | Specifies that sales orders will be created automatically from sales orders that are submitted in Dynamics 365 Sales. | DataClassification SystemMetadata |
| 81 | Auto Process Sales Quotes | Boolean | Specifies that sales quotes will be automatically processed on sales quotes creation/revision/winning submitted in Dynamics 365 Sales quotes entities. | DataClassification SystemMetadata |
| 118 | CurrencyDecimalPrecision | Integer | Currency Decimal Precision <small>caption</small> |  |
| 124 | BaseCurrencyId | Guid | Currency <small>caption</small> | TableRelation [Table 5345 "CRM Transactioncurrency"](../table/5345.md) ("CRM Transactioncurrency".TransactionCurrencyId) |
| 133 | BaseCurrencyPrecision | Integer | Base Currency Precision <small>caption</small> |  |
| 134 | BaseCurrencySymbol | Text[5] | Base Currency Symbol <small>caption</small> |  |
| 135 | Authentication Type | Option | Specifies the authentication type that will be used to authenticate with Dynamics 365 Sales | OptionCaption: OAuth 2.0,AD,IFD,OAuth |
| 136 | Connection String | Text[250] | — |  |
| 137 | Domain | Text[250] | Specifies the domain name of your Dynamics 365 Sales deployment. | not editable; DataClassification OrganizationIdentifiableInformation |
| 138 | Server Connection String | BLOB | — |  |
| 139 | Disable Reason | Text[250] | — |  |
| 140 | Item Availability Enabled | Boolean | Specifies that item availability job queue entry will be scheduled. |  |
| 141 | Bidirectional Sales Order Int. | Boolean | Specifies that it is possible to synchronize Sales Order bidirectionally. This feature will also enable Archiving Orders. |  |
| 151 | Unit Group Mapping Enabled | Boolean | Specifies that unit group mapping is enabled. |  |

## Keys

- Key1: Primary Key (clustered)

## Events published

- `OnReadingCRMData(var SkipReading: Boolean)` (integration)
- `OnGetDefaultCRMConnection(var ConnectionName: Text)` (integration)
- `OnBeforeVerifyBaseCurrencyMatchesLCY(var IsHandled: Boolean)` (integration)

## Trigger event subscribers

- OnAfterInsertEvent: [Codeunit 5333 "CRM Integration Telemetry"](../codeunit/5333.md) OnAfterInsertConnectionSetup
- OnAfterModifyEvent: [Codeunit 5333 "CRM Integration Telemetry"](../codeunit/5333.md) OnAfterModifyConnectionSetup

## Procedures

- `EnsureCDSConnectionIsEnabled()`
- `LoadConnectionStringElementsFromCDSConnectionSetup()`
- `DeployCRMSolution(ForceRedeploy: Boolean)`
- `CountCRMJobQueueEntries(var ActiveJobs: Integer; var TotalJobs: Integer)`
- `HasPassword(): Boolean`
- `SetPassword(PasswordText: SecretText)`
- `DeletePassword()`
- `RegisterConnection()`
- `RegisterConnectionWithName(ConnectionName: Text)`
- `UnregisterConnection(): Boolean`
- `UnregisterConnectionWithName(ConnectionName: Text)`
- `GetSecretConnectionStringWithCredentials(): SecretText`
- `GetIntegrationUserID(): Guid`
- `GetSecretPassword(): SecretText`
- `GetJobQueueEntriesObjectIDToRunFilter(): Text`
- `PerformTestConnection()`
- `VerifyTestConnection(): Boolean`
- `TestConnection(): Boolean`
- `TestIntegrationUserRequirements()`
- `TryReadSystemUsers()`
- `IsVersionValid(): Boolean`
- `UpdateFromWizard(var SourceCRMConnectionSetup: Record "CRM Connection Setup"; PasswordText: SecretText)`
- `EnableCRMConnectionFromWizard()`
- `RestoreConnection()`
- `SetCRMSOPEnabled()`
- `SetCRMSOPDisabled()`
- `SetCRMSOPEnabledWithCredentials(AdminEmail: Text; AdminPassword: Text; SOPIntegrationEnable: Boolean)`
- `SetUserAsIntegrationUser()`
- `RefreshDataFromCRM()`
- `RefreshDataFromCRM(ResetSalesOrderMappingConfiguration: Boolean)`
- `PerformWebClientUrlReset()`
- `SynchronizeNow(DoFullSynch: Boolean)`
- `PromptForCredentials(var AdminEmail: Text; var AdminPassword: Text): Boolean`
- `PromptForCredentials(var AdminEmail: Text; var AdminPassword: Text; var AdminADDomain: Text): Boolean`
- `DoReadCRMData(): Boolean`
- `GetDefaultCRMConnection(ConnectionName: Text): Text`
- `UpdateConnectionString(): Text`
- `UpdateCRMJobQueueEntriesStatus()`
- `GetConnectionString(): Text`
- `SetConnectionString(ConnectionString: Text)`
- `IsEnabled(): Boolean`
- `IsBidirectionalSalesOrderIntEnabled(): Boolean`
- `SetUseNewestUI()`
- `GetProxyVersion(): Integer` (internal)

Plus 22 local procedures.

## Triggers

OnModify, OnDelete

## Relations

- BaseCurrencyId: TableRelation [Table 5345 "CRM Transactioncurrency"](../table/5345.md)

## Pages and codeunits on this table

- [Page 1817 "CRM Connection Setup Wizard"](../page/1817.md) (source table)
- [Page 5330 "CRM Connection Setup"](../page/5330.md) (source table)

## Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an `Object::"Name"` argument. Interface dispatch and calls through events are not counted, so the list is not complete.

- [Codeunit 5330 "CRM Integration Management"](../codeunit/5330.md) (13 calls: `DeployCRMSolution → CheckCRMConnectionURL`, `DeployCRMSolution → ImportCRMSolution`, `DeployCRMSolution → IsCRMSolutionInstalled`, …)
- [Codeunit 7201 "CDS Integration Impl."](../codeunit/7201.md) (8 calls: `DeployCRMSolution → GetAccessToken`, `GetSecretConnectionStringWithCredentials → GetCDSConnectionClientId`, `GetSecretConnectionStringWithCredentials → GetCDSConnectionClientSecret`, …)
- [Codeunit 1293 "Isolated Storage Management"](../codeunit/1293.md) (3 calls: `DeletePassword → Delete`, `GetSecretPassword → Get`, `SetPassword → Set`)
- [Codeunit 5334 "CRM Setup Defaults"](../codeunit/5334.md) (3 calls: `EnableIntegrationTables → ResetConfiguration`, `PerformWebClientUrlReset → ResetCRMNAVConnectionData`, `SynchronizeNow → GetPrioritizedMappingList`)
- [Codeunit 5344 "CRM Product Name"](../codeunit/5344.md) (3 calls: `CDSConnectionNotEnabledError → SHORT`, `GetIntegrationUserID → SHORT`, `VerifyTestConnection → SHORT`)
- [Codeunit 150 "System Initialization"](../codeunit/150.md) (1 call: `ShowError → IsInProgress`)
- [Codeunit 457 "Environment Information"](../codeunit/457.md) (1 call: `GetProxyVersion → IsSaaS`)
- [Page 1313 "Dynamics CRM Admin Credentials"](../page/1313.md) (1 call: `PromptForCredentials → (object)`)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC24-26, BC28

## Deprecations

- field Is Enabled For User: Removed 26.0 (#if not CLEANSCHEMA26), "Use field "Is Enabled" instead."
- field Is User Mapped To CRM User: Removed 26.0 (#if not CLEANSCHEMA26), "This functionality is not in use and not supported"
- field Is User Mapping Required: Removed 26.0 (#if not CLEANSCHEMA26), "This functionality is not in use and not supported"

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: `bcatlas_resolve_node(object_type: "table", object_name: "CRM Connection Setup")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.