Codeunit 5335 Integration Table Synch.

Base Application, Microsoft.Integration.SyncEngine

src/Layers/W1/BaseApp/Integration/SynchEngine/IntegrationTableSynch.Codeunit.al689 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Integration.SyncEngine;using Microsoft.Integration.Dataverse;codeunit 5335 "Integration Table Synch."{    trigger OnRun()    begin    end;    var        CurrentIntegrationSynchJob: Record "Integration Synch. Job";        CurrentIntegrationTableMapping: Record "Integration Table Mapping";        TempIntegrationFieldMapping: Record "Temp Integration Field Mapping" temporary;        IntegrationTableConnectionType: TableConnectionType;        SynchActionType: Option "None",Insert,Modify,ForceModify,IgnoreUnchanged,Fail,Skip,Delete,Uncouple,Couple;        SynchJobType: Option Synchronization,Ucoupling,Coupling;        JobState: Option Ready,Created,"In Progress";        JobQueueLogEntryNo: Integer;        IntegrationTableMappingHasNoMappedFieldsErr: Label 'There are no field mapping rows for the %2 %3 in the %1 table.', Comment = '%1="Integration Field Mapping" table caption, %2="Integration Field Mapping.Integration Table Mapping Name" field caption, %3 Integration Table Mapping value';        UnableToDetectSynchDirectionErr: Label 'The synchronization direction cannot be determined.';        MappingDoesNotAllowDirectionErr: Label 'The %1 %2 is not configured for %3 synchronization.', Comment = '%1 = Integration Table Mapping caption, %2 Integration Table Mapping Name, %3 = the calculated synch. direction (FromIntegrationTable|ToIntegrationTable)';        InvalidStateErr: Label 'The synchronization process is in a state that is not valid.';        DirectionChangeIsNotSupportedErr: Label 'You cannot change the synchronization direction after a job has started.';#pragma warning disable AA0470        TablesDoNotMatchMappingErr: Label 'Source table %1 and destination table %2 do not match integration table mapping %3.', Comment = '%1,%2 - tables Ids; %2 - name of the mapping.';#pragma warning restore AA0470    procedure BeginIntegrationSynchJob(ConnectionType: TableConnectionType; var IntegrationTableMapping: Record "Integration Table Mapping"; SourceTableID: Integer) JobID: Guid    begin        exit(BeginIntegrationSynchJob(ConnectionType, IntegrationTableMapping, SourceTableID, SynchJobType::Synchronization));    end;    procedure BeginIntegrationUncoupleJob(ConnectionType: TableConnectionType; var IntegrationTableMapping: Record "Integration Table Mapping"; SourceTableID: Integer) JobID: Guid    begin        exit(BeginIntegrationSynchJob(ConnectionType, IntegrationTableMapping, SourceTableID, SynchJobType::Ucoupling));    end;    procedure BeginIntegrationCoupleJob(ConnectionType: TableConnectionType; var IntegrationTableMapping: Record "Integration Table Mapping"; SourceTableID: Integer) JobID: Guid    begin        exit(BeginIntegrationSynchJob(ConnectionType, IntegrationTableMapping, SourceTableID, SynchJobType::Coupling));    end;    local procedure BeginIntegrationSynchJob(ConnectionType: TableConnectionType; var IntegrationTableMapping: Record "Integration Table Mapping"; SourceTableID: Integer; JobType: Option) JobID: Guid    var        DirectionIsDefined: Boolean;        ErrorMessage: Text;    begin        EnsureState(JobState::Ready);        Clear(CurrentIntegrationSynchJob);        Clear(CurrentIntegrationTableMapping);        IntegrationTableConnectionType := ConnectionType;        CurrentIntegrationTableMapping := IntegrationTableMapping;        JobQueueLogEntryNo := IntegrationTableMapping.GetJobLogEntryNo();        if JobType = SynchJobType::Synchronization then            DirectionIsDefined := DetermineSynchDirection(SourceTableID, ErrorMessage)        else            DirectionIsDefined := true;        JobID := InitIntegrationSynchJob(JobType);        if not IsNullGuid(JobID) then begin            JobState := JobState::Created;            OnAfterInitSynchJob(IntegrationTableConnectionType, IntegrationTableMapping."Integration Table ID");            if not DirectionIsDefined then                FinishIntegrationSynchJob(ErrorMessage);        end;    end;    procedure BeginIntegrationSynchJobLoging(ConnectionType: TableConnectionType; CodeunitID: Integer; JobLogEntryNo: Integer; TableID: Integer) JobID: Guid    begin        EnsureState(JobState::Ready);        Clear(CurrentIntegrationSynchJob);        Clear(CurrentIntegrationTableMapping);        IntegrationTableConnectionType := ConnectionType;        JobQueueLogEntryNo := JobLogEntryNo;        CurrentIntegrationTableMapping."Table ID" := TableID;        CurrentIntegrationTableMapping.Name := Format(CodeunitID);        CurrentIntegrationTableMapping.Direction := CurrentIntegrationTableMapping.Direction::ToIntegrationTable;        JobID := InitIntegrationSynchJob(SynchJobType::Synchronization);        if not IsNullGuid(JobID) then begin            JobState := JobState::Created;            OnAfterInitSynchJob(IntegrationTableConnectionType, CurrentIntegrationTableMapping."Integration Table ID");        end;    end;    procedure CheckTransferFields(var IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; var FieldsModified: Boolean; var BidirectionalFieldsModified: Boolean)    var        TempTempIntegrationFieldMapping: Record "Temp Integration Field Mapping" temporary;        IntegrationRecSynchInvoke: Codeunit "Integration Rec. Synch. Invoke";        IntegrationRecordSynch: Codeunit "Integration Record Synch.";        Direction: Option;        EmptyGuid: Guid;    begin        OnBeforeCheckTransferFields(SourceRecordRef, DestinationRecordRef, FieldsModified, BidirectionalFieldsModified);        if BidirectionalFieldsModified then            exit;        if SourceRecordRef.Number() = IntegrationTableMapping."Integration Table ID" then            Direction := IntegrationTableMapping.Direction::FromIntegrationTable        else            Direction := IntegrationTableMapping.Direction::ToIntegrationTable;        BuildTempIntegrationFieldMapping(IntegrationTableMapping, Direction, TempTempIntegrationFieldMapping);        IntegrationRecordSynch.SetFieldMapping(TempTempIntegrationFieldMapping);        IntegrationRecSynchInvoke.SetContext(          IntegrationTableMapping, SourceRecordRef, DestinationRecordRef,          IntegrationRecordSynch, SynchActionType::ForceModify, false, EmptyGuid,          IntegrationTableConnectionType);        IntegrationRecSynchInvoke.CheckTransferFields(IntegrationRecordSynch, IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, FieldsModified, BidirectionalFieldsModified);    end;    procedure Synchronize(var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; ForceModify: Boolean; IgnoreSynchOnlyCoupledRecords: Boolean): Boolean    var        IntegrationRecordSynch: Codeunit "Integration Record Synch.";        IntegrationRecSynchInvoke: Codeunit "Integration Rec. Synch. Invoke";        SynchAction: Option;        IsHandled: Boolean;    begin        OnBeforeSynchronize(SourceRecordRef, DestinationRecordRef, ForceModify, IgnoreSynchOnlyCoupledRecords, IsHandled);        if IsHandled then            exit(true);        if not DoesSourceMatchMapping(SourceRecordRef.Number) then begin            FinishIntegrationSynchJob(              StrSubstNo(                TablesDoNotMatchMappingErr, SourceRecordRef.Number, DestinationRecordRef.Number, CurrentIntegrationTableMapping.GetName()));            exit(false);        end;        EnsureState(JobState::Created);        // Ready to synch.        Commit();        // First synch. fixes direction        if JobState = JobState::Created then begin            JobState := JobState::"In Progress";            CurrentIntegrationSynchJob."Synch. Direction" := CurrentIntegrationTableMapping.Direction;            CurrentIntegrationSynchJob.Modify(true);            BuildTempIntegrationFieldMapping(              CurrentIntegrationTableMapping, CurrentIntegrationTableMapping.Direction, TempIntegrationFieldMapping);            Commit();        end else            if CurrentIntegrationTableMapping.Direction <> CurrentIntegrationSynchJob."Synch. Direction" then                Error(DirectionChangeIsNotSupportedErr);        if ForceModify then            SynchAction := SynchActionType::ForceModify        else            SynchAction := SynchActionType::Skip;        if SourceRecordRef.Count <> 0 then begin            if IsRecordSkipped(SourceRecordRef, CurrentIntegrationTableMapping.Direction = CurrentIntegrationTableMapping.Direction::ToIntegrationTable) then                SynchAction := SynchActionType::Skip            else begin                IntegrationRecordSynch.SetFieldMapping(TempIntegrationFieldMapping);                IntegrationRecSynchInvoke.SetContext(                  CurrentIntegrationTableMapping, SourceRecordRef, DestinationRecordRef,                  IntegrationRecordSynch, SynchAction, IgnoreSynchOnlyCoupledRecords, CurrentIntegrationSynchJob.ID,                  IntegrationTableConnectionType);                if not IntegrationRecSynchInvoke.Run() then begin                    SynchAction := SynchActionType::Fail;                    LogSynchError(SourceRecordRef, DestinationRecordRef, GetLastErrorText(), false);                    IntegrationRecSynchInvoke.MarkIntegrationRecordAsFailed(                      CurrentIntegrationTableMapping, SourceRecordRef, CurrentIntegrationSynchJob.ID, IntegrationTableConnectionType, SynchAction);                    IncrementSynchJobCounters(SynchAction);                    exit(false);                end;                IntegrationRecSynchInvoke.GetContext(                  CurrentIntegrationTableMapping, SourceRecordRef, DestinationRecordRef, IntegrationRecordSynch, SynchAction);            end;            IncrementSynchJobCounters(SynchAction);        end;        exit(true);    end;    procedure Uncouple(var LocalRecordRef: RecordRef; var IntegrationRecordRef: RecordRef): Boolean    var        IntegrationRecordSynch: Codeunit "Integration Record Synch.";        IntRecUncoupleInvoke: Codeunit "Int. Rec. Uncouple Invoke";        SynchAction: Option;        LocalRecordModified: Boolean;        IntegrationRecordModified: Boolean;        IsHandled: Boolean;    begin        OnBeforeUncouple(LocalRecordRef, IntegrationRecordRef, IsHandled);        if IsHandled then            exit(true);        EnsureState(JobState::Created);        Commit();        if JobState = JobState::Created then begin            JobState := JobState::"In Progress";            CurrentIntegrationSynchJob."Synch. Direction" := CurrentIntegrationTableMapping.Direction;            CurrentIntegrationSynchJob.Modify(true);            TempIntegrationFieldMapping.Reset();            TempIntegrationFieldMapping.DeleteAll();            Commit();        end else            if CurrentIntegrationTableMapping.Direction <> CurrentIntegrationSynchJob."Synch. Direction" then                Error(DirectionChangeIsNotSupportedErr);        SynchAction := SynchActionType::Uncouple;        IntegrationRecordSynch.SetFieldMapping(TempIntegrationFieldMapping); // set empty field mapping        IntRecUncoupleInvoke.SetContext(            CurrentIntegrationTableMapping, LocalRecordRef, IntegrationRecordRef,            SynchAction, LocalRecordModified, IntegrationRecordModified, CurrentIntegrationSynchJob.ID, IntegrationTableConnectionType);        if not IntRecUncoupleInvoke.Run() then begin            SynchAction := SynchActionType::Fail;            LogSynchError(LocalRecordRef, IntegrationRecordRef, GetLastErrorText());            exit(false);        end;        IntRecUncoupleInvoke.GetContext(            CurrentIntegrationTableMapping, LocalRecordRef, IntegrationRecordRef, SynchAction, LocalRecordModified, IntegrationRecordModified);        if LocalRecordModified or IntegrationRecordModified then            IncrementSynchJobCounters(SynchActionType::Modify);        IncrementSynchJobCounters(SynchAction);        exit(true);    end;    procedure Couple(var LocalRecordRef: RecordRef; var IntegrationRecordRef: RecordRef): Boolean    var        IntegrationRecordSynch: Codeunit "Integration Record Synch.";        IntRecCoupleInvoke: Codeunit "Int. Rec. Couple Invoke";        SynchAction: Option;        LocalRecordModified: Boolean;        IntegrationRecordModified: Boolean;        IsHandled: Boolean;    begin        OnBeforeCouple(LocalRecordRef, IntegrationRecordRef, IsHandled);        if IsHandled then            exit(true);        EnsureState(JobState::Created);        Commit();        if JobState = JobState::Created then begin            JobState := JobState::"In Progress";            CurrentIntegrationSynchJob."Synch. Direction" := CurrentIntegrationTableMapping.Direction;            CurrentIntegrationSynchJob.Modify(true);            TempIntegrationFieldMapping.Reset();            TempIntegrationFieldMapping.DeleteAll();            Commit();        end else            if CurrentIntegrationTableMapping.Direction <> CurrentIntegrationSynchJob."Synch. Direction" then                Error(DirectionChangeIsNotSupportedErr);        SynchAction := SynchActionType::Couple;        IntegrationRecordSynch.SetFieldMapping(TempIntegrationFieldMapping); // set empty field mapping        IntRecCoupleInvoke.SetContext(            CurrentIntegrationTableMapping, LocalRecordRef, IntegrationRecordRef,            SynchAction, LocalRecordModified, IntegrationRecordModified, CurrentIntegrationSynchJob.ID, IntegrationTableConnectionType);        if not IntRecCoupleInvoke.Run() then begin            SynchAction := SynchActionType::Fail;            LogSynchError(LocalRecordRef, IntegrationRecordRef, GetLastErrorText());            exit(false);        end;        IntRecCoupleInvoke.GetContext(            CurrentIntegrationTableMapping, LocalRecordRef, IntegrationRecordRef, SynchAction, LocalRecordModified, IntegrationRecordModified);        if LocalRecordModified or IntegrationRecordModified then            IncrementSynchJobCounters(SynchActionType::Modify);        IncrementSynchJobCounters(SynchAction);        exit(true);    end;    [Scope('OnPrem')]    procedure CoupleOption(var LocalRecordRef: RecordRef; var IntegrationRecordRef: RecordRef): Boolean    var        CRMOptionMapping: Record "CRM Option Mapping";        SynchAction: Option;    begin        EnsureState(JobState::Created);        Commit();        if JobState = JobState::Created then begin            JobState := JobState::"In Progress";            CurrentIntegrationSynchJob."Synch. Direction" := CurrentIntegrationTableMapping.Direction;            CurrentIntegrationSynchJob.Modify(true);            TempIntegrationFieldMapping.Reset();            TempIntegrationFieldMapping.DeleteAll();            Commit();        end else            if CurrentIntegrationTableMapping.Direction <> CurrentIntegrationSynchJob."Synch. Direction" then                Error(DirectionChangeIsNotSupportedErr);        SynchAction := SynchActionType::Couple;        if not CRMOptionMapping.InsertRecord(LocalRecordRef.RecordId, CRMOptionMapping.GetRecordRefOptionId(IntegrationRecordRef), CRMOptionMapping.GetRecordRefOptionValue(IntegrationRecordRef)) then begin            SynchAction := SynchActionType::Fail;            LogSynchError(LocalRecordRef, IntegrationRecordRef, GetLastErrorText());            exit(false);        end;        IncrementSynchJobCounters(SynchAction);        exit(true);    end;    procedure LogMatchBasedCouplingError(var LocalRecordRef: RecordRef; ErrorMessage: Text)    var        IntegrationRecordRef: RecordRef;    begin        EnsureState(JobState::Created);        Commit();        if JobState = JobState::Created then begin            JobState := JobState::"In Progress";            CurrentIntegrationSynchJob."Synch. Direction" := CurrentIntegrationTableMapping.Direction;            CurrentIntegrationSynchJob.Modify(true);            TempIntegrationFieldMapping.Reset();            TempIntegrationFieldMapping.DeleteAll();            Commit();        end else            if CurrentIntegrationTableMapping.Direction <> CurrentIntegrationSynchJob."Synch. Direction" then                Error(DirectionChangeIsNotSupportedErr);        LogSynchError(LocalRecordRef, IntegrationRecordRef, ErrorMessage);    end;    procedure Delete(RecRef: RecordRef): Boolean    var        IntegrationRecDeleteInvoke: Codeunit "Integration Rec. Delete Invoke";        SynchDirection: Option;        SynchAction: Option;    begin        EnsureState(JobState::Created);        JobState := JobState::"In Progress";        case RecRef.Number of            CurrentIntegrationTableMapping."Table ID":                SynchDirection := CurrentIntegrationTableMapping.Direction::FromIntegrationTable;            CurrentIntegrationTableMapping."Integration Table ID":                SynchDirection := CurrentIntegrationTableMapping.Direction::ToIntegrationTable;        end;        CurrentIntegrationSynchJob.Modify(true);        Commit();        SynchAction := SynchActionType::Delete;        IntegrationRecDeleteInvoke.SetContext(          CurrentIntegrationTableMapping, RecRef,          SynchAction, CurrentIntegrationSynchJob.ID);        if not IntegrationRecDeleteInvoke.Run() then begin            LogSynchError(RecRef, RecRef, GetLastErrorText);            exit(false);        end;        IntegrationRecDeleteInvoke.GetContext(          CurrentIntegrationTableMapping, RecRef, SynchAction);        IncrementSynchJobCounters(SynchAction);        exit(true);    end;    procedure EndIntegrationSynchJob(): Guid    begin        exit(EndIntegrationSynchJobWithMsg(''));    end;    procedure EndIntegrationSynchJobWithMsg(FinalMessage: Text): Guid    begin        if CurrentIntegrationSynchJob."Finish Date/Time" = 0DT then            FinishIntegrationSynchJob(FinalMessage);        JobState := JobState::Ready;        exit(CurrentIntegrationSynchJob.ID);    end;    procedure GetRowLastModifiedOn(IntegrationTableMapping: Record "Integration Table Mapping"; FromRecordRef: RecordRef): DateTime    var        ModifiedFieldRef: FieldRef;    begin        if FromRecordRef.Number = IntegrationTableMapping."Integration Table ID" then begin            ModifiedFieldRef := FromRecordRef.Field(IntegrationTableMapping."Int. Tbl. Modified On Fld. No.");            exit(ModifiedFieldRef.Value);        end;        if FromRecordRef.Number() = IntegrationTableMapping."Table ID" then begin            ModifiedFieldRef := FromRecordRef.Field(FromRecordRef.SystemModifiedAtNo());            exit(ModifiedFieldRef.Value);        end;        exit(0DT);    end;    local procedure EnsureState(RequiredState: Option)    begin        if (JobState = JobState::"In Progress") and (RequiredState = JobState::Created) then            exit;        if RequiredState <> JobState then            Error(InvalidStateErr);    end;    local procedure DetermineSynchDirection(TableID: Integer; var ErrorMessage: Text): Boolean    var        DummyIntegrationTableMapping: Record "Integration Table Mapping";        SynchDirection: Option;        IsHandled: Boolean;    begin        ErrorMessage := '';        OnDetermineSynchDirection(CurrentIntegrationTableMapping, TableID, ErrorMessage, IsHandled);        if IsHandled then            exit(ErrorMessage = '');        case TableID of            CurrentIntegrationTableMapping."Table ID":                SynchDirection := CurrentIntegrationTableMapping.Direction::ToIntegrationTable;            CurrentIntegrationTableMapping."Integration Table ID":                SynchDirection := CurrentIntegrationTableMapping.Direction::FromIntegrationTable;            else begin                ErrorMessage := UnableToDetectSynchDirectionErr;                exit(false);            end;        end;        if not (CurrentIntegrationTableMapping.Direction in [SynchDirection, CurrentIntegrationTableMapping.Direction::Bidirectional]) then begin            DummyIntegrationTableMapping.Direction := SynchDirection;            ErrorMessage :=              StrSubstNo(                MappingDoesNotAllowDirectionErr, CurrentIntegrationTableMapping.TableCaption(), CurrentIntegrationTableMapping.Name,                DummyIntegrationTableMapping.Direction);            exit(false);        end;        CurrentIntegrationTableMapping.Direction := SynchDirection;        exit(true);    end;    local procedure InitIntegrationSynchJob(JobType: Option): Guid    var        JobID: Guid;    begin        JobID := CreateIntegrationSynchJobEntry(JobType);        Commit();        exit(JobID);    end;    local procedure FinishIntegrationSynchJob(FinalMessage: Text)    begin        if FinalMessage <> '' then            CurrentIntegrationSynchJob.Message := CopyStr(FinalMessage, 1, MaxStrLen(CurrentIntegrationSynchJob.Message));        CurrentIntegrationSynchJob."Finish Date/Time" := CurrentDateTime;        CurrentIntegrationSynchJob.Modify(true);        Commit();    end;    local procedure CreateIntegrationSynchJobEntry(JobType: Option) JobID: Guid    begin        if IsNullGuid(CurrentIntegrationSynchJob.ID) then            JobID := InsertIntegrationSynchJobEntry(JobType)        else            if CurrentIntegrationSynchJob.IsEmpty() then                JobID := InsertIntegrationSynchJobEntry(JobType);    end;    local procedure InsertIntegrationSynchJobEntry(JobType: Option): Guid    begin        CurrentIntegrationSynchJob.Reset();        CurrentIntegrationSynchJob.Init();        CurrentIntegrationSynchJob.ID := CreateGuid();        CurrentIntegrationSynchJob."Start Date/Time" := CurrentDateTime;        CurrentIntegrationSynchJob."Integration Table Mapping Name" := CurrentIntegrationTableMapping.GetName();        CurrentIntegrationSynchJob."Synch. Direction" := CurrentIntegrationTableMapping.Direction;        CurrentIntegrationSynchJob."Job Queue Log Entry No." := JobQueueLogEntryNo;        CurrentIntegrationSynchJob.Type := JobType;        CurrentIntegrationSynchJob.Insert(true);        Commit();        exit(CurrentIntegrationSynchJob.ID);    end;    local procedure BuildTempIntegrationFieldMapping(var IntegrationTableMapping: Record "Integration Table Mapping"; SynchDirection: Option; var TempIntegrationFieldMapping: Record "Temp Integration Field Mapping")    var        IntegrationFieldMapping: Record "Integration Field Mapping";    begin        IntegrationFieldMapping.SetRange("Integration Table Mapping Name", IntegrationTableMapping.Name);        IntegrationFieldMapping.SetFilter(Direction, '%1|%2', SynchDirection, IntegrationFieldMapping.Direction::Bidirectional);        IntegrationFieldMapping.SetFilter(Status, '<>%1', IntegrationFieldMapping.Status::Disabled);        if IntegrationFieldMapping.IsEmpty() then            Error(              IntegrationTableMappingHasNoMappedFieldsErr, IntegrationFieldMapping.TableCaption(),              IntegrationFieldMapping.FieldCaption("Integration Table Mapping Name"), IntegrationTableMapping.Name);        TempIntegrationFieldMapping.DeleteAll();        IntegrationFieldMapping.FindSet();        repeat            TempIntegrationFieldMapping.Init();            TempIntegrationFieldMapping."No." := IntegrationFieldMapping."No.";            TempIntegrationFieldMapping."Integration Table Mapping Name" := IntegrationFieldMapping."Integration Table Mapping Name";            TempIntegrationFieldMapping."Constant Value" := IntegrationFieldMapping."Constant Value";            TempIntegrationFieldMapping."Not Null" := IntegrationFieldMapping."Not Null";            if SynchDirection = IntegrationTableMapping.Direction::ToIntegrationTable then begin                TempIntegrationFieldMapping."Source Field No." := IntegrationFieldMapping."Field No.";                TempIntegrationFieldMapping."Destination Field No." := IntegrationFieldMapping."Integration Table Field No.";                TempIntegrationFieldMapping."Validate Destination Field" := IntegrationFieldMapping."Validate Integration Table Fld";            end else begin                TempIntegrationFieldMapping."Source Field No." := IntegrationFieldMapping."Integration Table Field No.";                TempIntegrationFieldMapping."Destination Field No." := IntegrationFieldMapping."Field No.";                TempIntegrationFieldMapping."Validate Destination Field" := IntegrationFieldMapping."Validate Field";            end;            TempIntegrationFieldMapping.Bidirectional := IntegrationFieldMapping.Direction = IntegrationFieldMapping.Direction::Bidirectional;            TempIntegrationFieldMapping.Insert();        until IntegrationFieldMapping.Next() = 0;    end;    procedure LogSynchError(var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; ErrorMessage: Text): Guid    begin        exit(LogSynchError(SourceRecordRef, DestinationRecordRef, ErrorMessage, true));    end;    procedure LogSynchError(var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; ErrorMessage: Text; UpdateCounter: Boolean): Guid    var        IntegrationSynchJobErrors: Record "Integration Synch. Job Errors";        SourceRecordID: RecordID;        DestinationRecordID: RecordID;    begin        if UpdateCounter then            IncrementSynchJobCounters(SynchActionType::Fail);        if DestinationRecordRef.Number <> 0 then            DestinationRecordID := DestinationRecordRef.RecordId;        if SourceRecordRef.Number <> 0 then            SourceRecordID := SourceRecordRef.RecordId;        IntegrationSynchJobErrors.LogSynchError(          CurrentIntegrationSynchJob.ID, SourceRecordID, DestinationRecordID, ErrorMessage);        exit(CurrentIntegrationSynchJob.ID);    end;    procedure IncrementSynchJobCounters(SynchAction: Option)    begin        UpdateSynchJobCounters(SynchAction, 1)    end;    procedure UpdateSynchJobCounters(SynchAction: Option; Counter: Integer)    begin        if Counter = 0 then            exit;        case SynchAction of            SynchActionType::Insert:                CurrentIntegrationSynchJob.Inserted += Counter;            SynchActionType::Modify, SynchActionType::ForceModify:                CurrentIntegrationSynchJob.Modified += Counter;            SynchActionType::IgnoreUnchanged:                CurrentIntegrationSynchJob.Unchanged += Counter;            SynchActionType::Skip:                CurrentIntegrationSynchJob.Skipped += Counter;            SynchActionType::Fail:                CurrentIntegrationSynchJob.Failed += Counter;            SynchActionType::Delete:                CurrentIntegrationSynchJob.Deleted += Counter;            SynchActionType::Uncouple:                CurrentIntegrationSynchJob.Uncoupled += Counter;            SynchActionType::Couple:                CurrentIntegrationSynchJob.Coupled += Counter;            else                exit        end;        CurrentIntegrationSynchJob.Modify();        Commit();    end;    local procedure DoesSourceMatchMapping(SourceTableID: Integer): Boolean    begin        case CurrentIntegrationTableMapping.Direction of            CurrentIntegrationTableMapping.Direction::ToIntegrationTable:                exit(SourceTableID = CurrentIntegrationTableMapping."Table ID");            CurrentIntegrationTableMapping.Direction::FromIntegrationTable:                exit(SourceTableID = CurrentIntegrationTableMapping."Integration Table ID");        end;    end;    local procedure IsRecordSkipped(RecRef: RecordRef; DirectionToIntTable: Boolean): Boolean    var        IntegrationRecordManagement: Codeunit "Integration Record Management";    begin        exit(IntegrationRecordManagement.IsIntegrationRecordSkipped(IntegrationTableConnectionType, RecRef, DirectionToIntTable));    end;    procedure SynchronizeOption(var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; ForceModify: Boolean; IgnoreSynchOnlyCoupledRecords: Boolean): Boolean    var        IntOptionSynchInvoke: Codeunit "Int. Option Synch. Invoke";        SynchAction: Option;        IsHandled: Boolean;    begin        OnBeforeSynchronizeOption(SourceRecordRef, DestinationRecordRef, ForceModify, IgnoreSynchOnlyCoupledRecords, IsHandled);        if IsHandled then            exit(true);        EnsureState(JobState::Created);        // Ready to synch.        Commit();        // First synch. fixes direction        if JobState = JobState::Created then begin            JobState := JobState::"In Progress";            CurrentIntegrationSynchJob."Synch. Direction" := CurrentIntegrationTableMapping.Direction;            CurrentIntegrationSynchJob.Modify(true);            Commit();        end else            if CurrentIntegrationTableMapping.Direction <> CurrentIntegrationSynchJob."Synch. Direction" then                Error(DirectionChangeIsNotSupportedErr);        if ForceModify then            SynchAction := SynchActionType::ForceModify        else            SynchAction := SynchActionType::Skip;        if SourceRecordRef.Count <> 0 then begin            if IsOptionSkipped(SourceRecordRef, SourceRecordRef.Number() = CurrentIntegrationTableMapping."Table ID") then                SynchAction := SynchActionType::Skip            else begin                IntOptionSynchInvoke.SetContext(                  CurrentIntegrationTableMapping, SourceRecordRef, DestinationRecordRef, SynchAction, IgnoreSynchOnlyCoupledRecords, CurrentIntegrationSynchJob.ID);                if not IntOptionSynchInvoke.Run() then begin                    SynchAction := SynchActionType::Fail;                    LogSynchError(SourceRecordRef, DestinationRecordRef, GetLastErrorText(), false);                    IntOptionSynchInvoke.MarkOptionMappingAsFailed(                      CurrentIntegrationTableMapping, SourceRecordRef, CurrentIntegrationSynchJob.ID, SynchAction);                    IncrementSynchJobCounters(SynchAction);                    exit(false);                end;                IntOptionSynchInvoke.GetContext(                  CurrentIntegrationTableMapping, SourceRecordRef, DestinationRecordRef, SynchAction);            end;            IncrementSynchJobCounters(SynchAction);        end;        exit(true);    end;    local procedure IsOptionSkipped(RecRef: RecordRef; DirectionToIntTable: Boolean): Boolean    var        CRMOptionMapping: Record "CRM Option Mapping";    begin        exit(CRMOptionMapping.IsOptionMappingSkipped(RecRef, DirectionToIntTable));    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeSynchronize(var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; var ForceModify: Boolean; var IgnoreSynchOnlyCoupledRecords: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeSynchronizeOption(var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; var ForceModify: Boolean; var IgnoreSynchOnlyCoupledRecords: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckTransferFields(var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; var FieldsModified: Boolean; var BidirectionalFieldsModified: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeUncouple(var LocalRecordRef: RecordRef; var IntegrationRecordRef: RecordRef; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCouple(var LocalRecordRef: RecordRef; var IntegrationRecordRef: RecordRef; var IsHandled: Boolean)    begin    end;    [Scope('OnPrem')]    [IntegrationEvent(false, false)]    procedure OnAfterInitSynchJob(ConnectionType: TableConnectionType; IntegrationTableID: Integer)    begin    end;    [IntegrationEvent(false, false)]    procedure OnDetermineSynchDirection(var CurrentIntegrationTableMapping: Record "Integration Table Mapping"; var TableID: Integer; var ErrorMessage: Text; var IsHandled: Boolean)    begin    end;}