---
title: "Table 5331 CRM Integration Record"
author: "Jonas Paprotka"
url: https://jonas-paprotka.de/ref/table/5331-crm-integration-record/
type: table
id: 5331
name: "CRM Integration Record"
app: "Base Application"
namespace: Microsoft.Integration.Dataverse
versions: "17-28"
build: 28.5.54151.54365
source: "https://jonas-paprotka.de/ref/table/5331-crm-integration-record/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 5331 CRM Integration Record

Jonas Paprotka, https://jonas-paprotka.de/ref/table/5331-crm-integration-record/

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

## Fields

| Id | Name | Type | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| 2 | CRM ID | Guid | 17-28 | - | - |
| 3 | Integration ID | Guid | 17-28 | - | - |
| 4 | Last Synch. Modified On | DateTime | 17-28 | - | - |
| 5 | Last Synch. CRM Modified On | DateTime | 17-28 | - | - |
| 6 | Table ID | Integer | 17-28 | - | - |
| 7 | Last Synch. Result | Option | 17-28 | - | - |
| 8 | Last Synch. CRM Result | Option | 17-28 | - | - |
| 9 | Last Synch. Job ID | Guid | 17-28 | - | - |
| 10 | Last Synch. CRM Job ID | Guid | 17-28 | - | - |
| 11 | Skipped | Boolean | 17-28 | - | - |
| 12 | Option Mapping Failure | Boolean | 17-25 | Removed 21.0 | This field is deprecated. |
| 13 | Statistics Uploaded | Boolean | 17-28 | - | - |
| 14 | Archived Sales Order | Boolean | 21-28 | - | - |
| 15 | Archived Sales Order Updated | Boolean | 21-28 | - | - |

## Keys

| Name | Fields | Versions |
| --- | --- | --- |
| Key1, clustered | CRM ID, Integration ID | 17-28 |
| Key2 | Integration ID | 17-28 |
| Key3 | Last Synch. Modified On, Integration ID | 17-28 |
| Key4 | Last Synch. CRM Modified On, CRM ID | 17-28 |
| Key5 | Skipped, Table ID | 17-28 |
| Key6 | Table ID | 17-28 |
| Key7 | Statistics Uploaded, Skipped, Table ID | 17-28 |
| Key8 | Integration ID, Statistics Uploaded, Skipped, Table ID | 17-28 |

## Procedures

| Name | Parameters | Returns | Access | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- | --- |
| GetTableID | () | Integer | public | 17-28 | - | - |
| RepairTableIdByLocalRecord | () | Boolean | internal | 17-28 | - | - |
| RepairTableIdByCRMRecord | () | Boolean | internal | 17-28 | - | - |
| GetCRMRecordID | (Integer, var RecordId) | Boolean | public | 17-28 | - | - |
| GetCRMRecordRef | (Integer, var RecordRef) | Boolean | public | 17-28 | - | - |
| GetLatestJobIDFilter | () | Text | public | 17-28 | - | - |
| GetLatestError | (var Record Integration Synch. Job Errors) | Boolean | public | 17-28 | - | - |
| InsertRecord | (Guid, Record Integration Record) | - | public | 17-21 | Pending 17.0 | Table Integration Record is marked for removal. Reason: This functionality will be replaced by the systemID field. |
| InsertRecord | (Guid, Guid, Integer) | - | public | 17-28 | - | - |
| IsCRMRecordRefCoupled | (RecordRef) | Boolean | public | 17-28 | - | - |
| IsIntegrationIdCoupled | (Guid) | Boolean | public | 17-24 | Pending 22.0 | Replaced by IsIntegrationIdCoupled(IntegrationID: Guid; TableId: Integer) |
| IsRecordCoupled | (RecordId) | Boolean | public | 17-28 | - | - |
| FindByCRMID | (Guid) | Boolean | public | 17-28 | - | - |
| FindValidByCRMID | (Guid) | Boolean | public | 17-28 | - | - |
| FindRecordId | (var RecordId) | Boolean | public | 17-28 | - | - |
| FindSystemIdByRecordId | (var Guid, RecordId) | Boolean | public | 17-28 | - | - |
| FindByRecordID | (RecordId) | Boolean | public | 17-28 | - | - |
| FindValidByRecordID | (RecordId, Integer) | Boolean | public | 17-28 | - | - |
| FindRecordIDFromID | (Guid, Integer, var RecordId) | Boolean | public | 17-28 | - | - |
| FindIDFromRecordID | (RecordId, var Guid) | Boolean | public | 17-28 | - | - |
| CoupleCRMIDToRecordID | (Guid, RecordId) | - | public | 17-28 | - | - |
| CoupleRecordIdToCRMID | (RecordId, Guid) | - | public | 17-28 | - | - |
| RemoveCouplingToRecord | (RecordId) | Boolean | public | 17-28 | - | - |
| RemoveCouplingToCRMID | (Guid, Integer) | Boolean | public | 17-28 | - | - |
| SetNewCRMId | (Guid) | - | public | 17-28 | - | - |
| SetNewIntegrationId | (Guid) | - | public | 17-28 | - | - |
| AssertRecordIDCanBeCoupled | (RecordId, Guid) | - | public | 17-28 | - | - |
| SetLastSynchResultFailed | (RecordRef, Boolean, Guid) | - | public | 17-28 | - | - |
| SetLastSynchResultFailed | (RecordRef, Boolean, Guid, var Boolean) | - | public | 17-28 | - | - |
| IsSkipped | (RecordRef, Boolean) | Boolean | public | 17-28 | - | - |
| SetLastSynchModifiedOns | (Guid, Integer, DateTime, DateTime, Guid, Option) | - | public | 17-28 | - | - |
| SetLastSynchCRMModifiedOn | (Guid, Integer, DateTime) | - | public | 17-28 | - | - |
| IsModifiedAfterLastSynchonizedCRMRecord | (Guid, Integer, DateTime) | Boolean | public | 17-28 | - | - |
| IsModifiedAfterLastSynchronizedRecord | (RecordId, DateTime) | Boolean | public | 17-28 | - | - |
| DeleteIfRecordDeleted | (Guid, Integer) | Boolean | public | 17-28 | - | - |
| FindSystemIdByRecordRef | (var Guid, RecordRef) | Boolean | public | 18-28 | - | - |
| FindIDFromRecordRef | (RecordRef, var Guid) | Boolean | public | 18-28 | - | - |
| CoupleCRMIDToRecordRef | (Guid, RecordRef) | - | public | 18-28 | - | - |
| RemoveCouplingToRecord | (RecordRef) | Boolean | public | 18-28 | - | - |
| IsModifiedAfterLastSynchronizedRecord | (RecordRef, DateTime) | Boolean | public | 18-28 | - | - |
| IsSameFailureRepeatedTwice | (RecordRef, Guid, Guid) | Boolean | public | 20-28 | - | - |
| IsIntegrationIdCoupled | (Guid, Integer) | Boolean | public | 21-28 | - | - |

## Events

| Kind | Name | Parameters | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| Integration event | OnBeforeIsModifiedAfterLastSynchronizedCRMRecord | (Guid, Integer, DateTime, var Boolean, var Boolean) | 17-28 | - | - |
| Integration event | OnBeforeIsModifiedAfterLastSynchronizedRecord | (RecordId, DateTime, var Boolean, var Boolean) | 17-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.