Objects/Tables/Table 5331 CRM Integration Record
Table 5331 CRM Integration Record in 18
Jonas Paprotka, Base Application 18.5.29545.46345, checked
- App
- Base Application
Fields, 12Keys, 8Procedures, 40Events, 2
Versions171819202122232425262728latest
Source29
Fields, 12
| Id | Name | Type | Obsolete |
|---|
| 2 | CRM ID | Guid | - |
| 3 | Integration ID | Guid | - |
| 4 | Last Synch. Modified On | DateTime | - |
| 5 | Last Synch. CRM Modified On | DateTime | - |
| 6 | Table ID | Integer | - |
| 7 | Last Synch. Result | Option | - |
| 8 | Last Synch. CRM Result | Option | - |
| 9 | Last Synch. Job ID | Guid | - |
| 10 | Last Synch. CRM Job ID | Guid | - |
| 11 | Skipped | Boolean | - |
| 12 | Option Mapping Failure | Boolean | Pending 18.0 |
| This field is deprecated. |
| 13 | Statistics Uploaded | Boolean | - |
Keys, 8
| Name | Fields | Obsolete |
|---|
| Key1, clustered | CRM ID, Integration ID | - |
| Key2 | Integration ID | - |
| Key3 | Last Synch. Modified On, Integration ID | - |
| Key4 | Last Synch. CRM Modified On, CRM ID | - |
| Key5 | Skipped, Table ID | - |
| Key6 | Table ID | - |
| Key7 | Statistics Uploaded, Skipped, Table ID | - |
| Key8 | Integration ID, Statistics Uploaded, Skipped, Table ID | - |
Procedures, 40
| Name | Parameters | Returns | Access | Obsolete |
|---|
| GetTableID | () | Integer | public | - |
| RepairTableIdByLocalRecord | () | Boolean | internal | - |
| RepairTableIdByCRMRecord | () | Boolean | internal | - |
| GetCRMRecordID | (Integer, var RecordId) | Boolean | public | - |
| GetCRMRecordRef | (Integer, var RecordRef) | Boolean | public | - |
| GetLatestJobIDFilter | () | Text | public | - |
| GetLatestError | (var Record Integration Synch. Job Errors) | Boolean | public | - |
| InsertRecord | (Guid, Record Integration Record) | | public | 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 | - |
| IsCRMRecordRefCoupled | (RecordRef) | Boolean | public | - |
| IsIntegrationIdCoupled | (Guid) | Boolean | public | - |
| IsRecordCoupled | (RecordId) | Boolean | public | - |
| FindByCRMID | (Guid) | Boolean | public | - |
| FindValidByCRMID | (Guid) | Boolean | public | - |
| FindRecordId | (var RecordId) | Boolean | public | - |
| FindSystemIdByRecordId | (var Guid, RecordId) | Boolean | public | - |
| FindByRecordID | (RecordId) | Boolean | public | - |
| FindValidByRecordID | (RecordId, Integer) | Boolean | public | - |
| FindRecordIDFromID | (Guid, Integer, var RecordId) | Boolean | public | - |
| FindIDFromRecordID | (RecordId, var Guid) | Boolean | public | - |
| CoupleCRMIDToRecordID | (Guid, RecordId) | | public | - |
| CoupleRecordIdToCRMID | (RecordId, Guid) | | public | - |
| RemoveCouplingToRecord | (RecordId) | Boolean | public | - |
| RemoveCouplingToCRMID | (Guid, Integer) | Boolean | public | - |
| SetNewCRMId | (Guid) | | public | - |
| SetNewIntegrationId | (Guid) | | public | - |
| AssertRecordIDCanBeCoupled | (RecordId, Guid) | | public | - |
| SetLastSynchResultFailed | (RecordRef, Boolean, Guid) | | public | - |
| SetLastSynchResultFailed | (RecordRef, Boolean, Guid, var Boolean) | | public | - |
| IsSkipped | (RecordRef, Boolean) | Boolean | public | - |
| SetLastSynchModifiedOns | (Guid, Integer, DateTime, DateTime, Guid, Option) | | public | - |
| SetLastSynchCRMModifiedOn | (Guid, Integer, DateTime) | | public | - |
| IsModifiedAfterLastSynchonizedCRMRecord | (Guid, Integer, DateTime) | Boolean | public | - |
| IsModifiedAfterLastSynchronizedRecord | (RecordId, DateTime) | Boolean | public | - |
| DeleteIfRecordDeleted | (Guid, Integer) | Boolean | public | - |
| FindSystemIdByRecordRef | (var Guid, RecordRef) | Boolean | public | - |
| FindIDFromRecordRef | (RecordRef, var Guid) | Boolean | public | - |
| CoupleCRMIDToRecordRef | (Guid, RecordRef) | | public | - |
| RemoveCouplingToRecord | (RecordRef) | Boolean | public | - |
| IsModifiedAfterLastSynchronizedRecord | (RecordRef, DateTime) | Boolean | public | - |
Events, 2
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnBeforeIsModifiedAfterLastSynchronizedCRMRecord | (Guid, Integer, DateTime, var Boolean, var Boolean) | - |
| Integration event | OnBeforeIsModifiedAfterLastSynchronizedRecord | (RecordId, DateTime, var Boolean, var Boolean) | - |