Share via

Table "CRM Integration Record"

ID 5331
Namespace: Microsoft.Integration.Dataverse

Properties

Name Value
Caption CRM Integration Record
DataClassification CustomerContent

Fields

Name Type Description
"CRM ID" Guid
"Integration ID" Guid
"Last Synch. Modified On" DateTime
"Last Synch. CRM Modified On" DateTime
"Table ID" Integer
"Last Synch. Result" Option
"Last Synch. CRM Result" Option
"Last Synch. Job ID" Guid
"Last Synch. CRM Job ID" Guid
Skipped Boolean
"Statistics Uploaded" Boolean
"Archived Sales Order" Boolean
"Archived Sales Order Updated" Boolean
SystemId Guid
SystemCreatedAt DateTime
SystemCreatedBy Guid
SystemModifiedAt DateTime
SystemModifiedBy Guid
SystemRowVersion BigInteger

Methods

GetCRMRecordID

procedure GetCRMRecordID(IntegrationTableID: Integer, var CRMRecID: RecordId): Boolean

Parameters

Name Type Description
IntegrationTableID Integer
CRMRecID RecordId

Returns

Type Description
Boolean

GetCRMRecordRef

procedure GetCRMRecordRef(IntegrationTableID: Integer, var RecRef: RecordRef): Boolean

Parameters

Name Type Description
IntegrationTableID Integer
RecRef RecordRef

Returns

Type Description
Boolean

GetLatestJobIDFilter

procedure GetLatestJobIDFilter(): Text

Returns

Type Description
Text

GetLatestError

procedure GetLatestError(var IntegrationSynchJobErrors: Record "Integration Synch. Job Errors"): Boolean

Parameters

Name Type Description
IntegrationSynchJobErrors Table Microsoft.Integration.SyncEngine."Integration Synch. Job Errors"

Returns

Type Description
Boolean

InsertRecord

procedure InsertRecord(CRMID: Guid, SysId: Guid, TableId: Integer)

Parameters

Name Type Description
CRMID Guid
SysId Guid
TableId Integer

IsCRMRecordRefCoupled

procedure IsCRMRecordRefCoupled(CRMRecordRef: RecordRef): Boolean

Parameters

Name Type Description
CRMRecordRef RecordRef

Returns

Type Description
Boolean

IsIntegrationIdCoupled

procedure IsIntegrationIdCoupled(IntegrationID: Guid, TableId: Integer): Boolean

Parameters

Name Type Description
IntegrationID Guid
TableId Integer

Returns

Type Description
Boolean

IsRecordCoupled

procedure IsRecordCoupled(DestinationRecordID: RecordId): Boolean

Parameters

Name Type Description
DestinationRecordID RecordId

Returns

Type Description
Boolean

FindByCRMID

procedure FindByCRMID(CRMID: Guid): Boolean

Parameters

Name Type Description
CRMID Guid

Returns

Type Description
Boolean

FindValidByCRMID

procedure FindValidByCRMID(CRMID: Guid): Boolean

Parameters

Name Type Description
CRMID Guid

Returns

Type Description
Boolean

FindRecordId

procedure FindRecordId(var RecId: RecordId): Boolean

Parameters

Name Type Description
RecId RecordId

Returns

Type Description
Boolean

FindSystemIdByRecordId

procedure FindSystemIdByRecordId(var SysId: Guid, RecId: RecordId): Boolean

Parameters

Name Type Description
SysId Guid
RecId RecordId

Returns

Type Description
Boolean

FindSystemIdByRecordRef

procedure FindSystemIdByRecordRef(var SysId: Guid, RecordRef: RecordRef): Boolean

Parameters

Name Type Description
SysId Guid
RecordRef RecordRef

Returns

Type Description
Boolean

FindByRecordID

procedure FindByRecordID(RecID: RecordId): Boolean

Parameters

Name Type Description
RecID RecordId

Returns

Type Description
Boolean

FindValidByRecordID

procedure FindValidByRecordID(RecID: RecordId, IntegrationTableID: Integer): Boolean

Parameters

Name Type Description
RecID RecordId
IntegrationTableID Integer

Returns

Type Description
Boolean

FindRecordIDFromID

procedure FindRecordIDFromID(SourceCRMID: Guid, DestinationTableID: Integer, var DestinationRecordId: RecordId): Boolean

Parameters

Name Type Description
SourceCRMID Guid
DestinationTableID Integer
DestinationRecordId RecordId

Returns

Type Description
Boolean

FindIDFromRecordID

procedure FindIDFromRecordID(SourceRecordID: RecordId, var DestinationCRMID: Guid): Boolean

Parameters

Name Type Description
SourceRecordID RecordId
DestinationCRMID Guid

Returns

Type Description
Boolean

FindIDFromRecordRef

procedure FindIDFromRecordRef(SourceRecordRef: RecordRef, var DestinationCRMID: Guid): Boolean

Parameters

Name Type Description
SourceRecordRef RecordRef
DestinationCRMID Guid

Returns

Type Description
Boolean

CoupleCRMIDToRecordID

procedure CoupleCRMIDToRecordID(CRMID: Guid, RecordID: RecordId)

Parameters

Name Type Description
CRMID Guid
RecordID RecordId

CoupleCRMIDToRecordRef

procedure CoupleCRMIDToRecordRef(CRMID: Guid, RecordRef: RecordRef)

Parameters

Name Type Description
CRMID Guid
RecordRef RecordRef

CoupleRecordIdToCRMID

procedure CoupleRecordIdToCRMID(RecordID: RecordId, CRMID: Guid)

Parameters

Name Type Description
RecordID RecordId
CRMID Guid

RemoveCouplingToRecord

procedure RemoveCouplingToRecord(RecordID: RecordId): Boolean

Parameters

Name Type Description
RecordID RecordId

Returns

Type Description
Boolean

RemoveCouplingToRecord

procedure RemoveCouplingToRecord(RecordRef: RecordRef): Boolean

Parameters

Name Type Description
RecordRef RecordRef

Returns

Type Description
Boolean

RemoveCouplingToCRMID

procedure RemoveCouplingToCRMID(CRMID: Guid, DestinationTableID: Integer): Boolean

Parameters

Name Type Description
CRMID Guid
DestinationTableID Integer

Returns

Type Description
Boolean

SetNewCRMId

procedure SetNewCRMId(CRMId: Guid)

Parameters

Name Type Description
CRMId Guid

SetNewIntegrationId

procedure SetNewIntegrationId(IntegrationId: Guid)

Parameters

Name Type Description
IntegrationId Guid

AssertRecordIDCanBeCoupled

procedure AssertRecordIDCanBeCoupled(RecordID: RecordId, CRMID: Guid)

Parameters

Name Type Description
RecordID RecordId
CRMID Guid

SetLastSynchResultFailed

procedure SetLastSynchResultFailed(SourceRecRef: RecordRef, DirectionToIntTable: Boolean, JobId: Guid)

Parameters

Name Type Description
SourceRecRef RecordRef
DirectionToIntTable Boolean
JobId Guid

SetLastSynchResultFailed

procedure SetLastSynchResultFailed(SourceRecRef: RecordRef, DirectionToIntTable: Boolean, JobId: Guid, var MarkedAsSkipped: Boolean)

Parameters

Name Type Description
SourceRecRef RecordRef
DirectionToIntTable Boolean
JobId Guid
MarkedAsSkipped Boolean

IsSkipped

procedure IsSkipped(SourceRecordRef: RecordRef, DirectionToIntTable: Boolean): Boolean

Parameters

Name Type Description
SourceRecordRef RecordRef
DirectionToIntTable Boolean

Returns

Type Description
Boolean

SetLastSynchModifiedOns

procedure SetLastSynchModifiedOns(SourceCRMID: Guid, DestinationTableID: Integer, CRMLastModifiedOn: DateTime, LastModifiedOn: DateTime, JobId: Guid, Direction: Option)

Parameters

Name Type Description
SourceCRMID Guid
DestinationTableID Integer
CRMLastModifiedOn DateTime
LastModifiedOn DateTime
JobId Guid
Direction Option

SetLastSynchCRMModifiedOn

procedure SetLastSynchCRMModifiedOn(CRMID: Guid, DestinationTableID: Integer, CRMLastModifiedOn: DateTime)

Parameters

Name Type Description
CRMID Guid
DestinationTableID Integer
CRMLastModifiedOn DateTime

IsModifiedAfterLastSynchonizedCRMRecord

procedure IsModifiedAfterLastSynchonizedCRMRecord(CRMID: Guid, DestinationTableID: Integer, CurrentModifiedOn: DateTime): Boolean

Parameters

Name Type Description
CRMID Guid
DestinationTableID Integer
CurrentModifiedOn DateTime

Returns

Type Description
Boolean

IsModifiedAfterLastSynchronizedRecord

procedure IsModifiedAfterLastSynchronizedRecord(RecordID: RecordId, CurrentModifiedOn: DateTime): Boolean

Parameters

Name Type Description
RecordID RecordId
CurrentModifiedOn DateTime

Returns

Type Description
Boolean

IsModifiedAfterLastSynchronizedRecord

procedure IsModifiedAfterLastSynchronizedRecord(RecordRef: RecordRef, CurrentModifiedOn: DateTime): Boolean

Parameters

Name Type Description
RecordRef RecordRef
CurrentModifiedOn DateTime

Returns

Type Description
Boolean

DeleteIfRecordDeleted

procedure DeleteIfRecordDeleted(CRMID: Guid, DestinationTableID: Integer): Boolean

Parameters

Name Type Description
CRMID Guid
DestinationTableID Integer

Returns

Type Description
Boolean

Events

OnBeforeIsModifiedAfterLastSynchronizedCRMRecord

[IntegrationEvent(False,False)]
local procedure OnBeforeIsModifiedAfterLastSynchronizedCRMRecord(CRMID: Guid, DestinationTableID: Integer, CurrentModifiedOn: DateTime, var IsModified: Boolean, var Handled: Boolean)

Parameters

Name Type Description
CRMID Guid
DestinationTableID Integer
CurrentModifiedOn DateTime
IsModified Boolean
Handled Boolean

OnBeforeIsModifiedAfterLastSynchronizedRecord

[IntegrationEvent(False,False)]
local procedure OnBeforeIsModifiedAfterLastSynchronizedRecord(RecordID: RecordId, CurrentModifiedOn: DateTime, var IsModified: Boolean, var Handled: Boolean)

Parameters

Name Type Description
RecordID RecordId
CurrentModifiedOn DateTime
IsModified Boolean
Handled Boolean

See also