Table 5335 Integration Table Mapping
src/Layers/W1/BaseApp/Integration/SynchEngine/IntegrationTableMapping.Table.al1,269 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.CRM.Opportunity;using Microsoft.Integration.D365Sales;using Microsoft.Integration.Dataverse;using Microsoft.Sales.Document;using System.IO;using System.Reflection;using System.Telemetry;using System.Threading;table 5335 "Integration Table Mapping"{ Caption = 'Integration Table Mapping'; DrillDownPageID = "Integration Table Mapping List"; LookupPageID = "Integration Table Mapping List"; DataClassification = CustomerContent; fields { field(1; Name; Code[20]) { Caption = 'Name'; ToolTip = 'Specifies the name of the integration table mapping entry.'; NotBlank = true; } field(2; "Table ID"; Integer) { Caption = 'Table ID'; TableRelation = "Table Metadata".ID; } field(3; "Integration Table ID"; Integer) { Caption = 'Integration Table ID'; TableRelation = "Table Metadata".ID; } field(4; "Synch. Codeunit ID"; Integer) { Caption = 'Synch. Codeunit ID'; TableRelation = "Table Metadata".ID; } field(5; "Integration Table UID Fld. No."; Integer) { Caption = 'Integration Table UID Fld. No.'; Description = 'Integration Table Unique Identifier Field No.'; trigger OnValidate() var "Field": Record "Field"; TypeHelper: Codeunit "Type Helper"; begin Field.Get("Integration Table ID", "Integration Table UID Fld. No."); TypeHelper.TestFieldIsNotObsolete(Field); "Int. Table UID Field Type" := Field.Type; end; } field(6; "Int. Tbl. Modified On Fld. No."; Integer) { Caption = 'Int. Tbl. Modified On Fld. No.'; Description = 'Integration Table Modified On Field No.'; } field(7; "Int. Table UID Field Type"; Integer) { Caption = 'Int. Table UID Field Type'; Editable = false; } field(8; "Table Config Template Code"; Code[10]) { Caption = 'Table Config Template Code'; TableRelation = "Config. Template Header".Code where("Table ID" = field("Table ID")); /// Replaced with Integration Table Config Template table for Dataverse type mappings /// used only for Master Data Management mappings } field(9; "Int. Tbl. Config Template Code"; Code[10]) { Caption = 'Int. Tbl. Config Template Code'; TableRelation = "Config. Template Header".Code where("Table ID" = field("Integration Table ID")); /// Replaced with Integration Table Config Template table for Dataverse type mappings /// used only for Master Data Management mappings } field(10; Direction; Option) { Caption = 'Direction'; ToolTip = 'Specifies the synchronization direction.'; OptionCaption = 'Bidirectional,ToIntegrationTable,FromIntegrationTable'; OptionMembers = Bidirectional,ToIntegrationTable,FromIntegrationTable; trigger OnValidate() var "Field": Record "Field"; IntegrationFieldMapping: Record "Integration Field Mapping"; CRMFullSynchReviewLine: Record "CRM Full Synch. Review Line"; JobQueueEntry: Record "Job Queue Entry"; NoEnabledFieldMappingsExist: Boolean; begin if "Int. Table UID Field Type" = Field.Type::Option then if Direction = Direction::Bidirectional then Error(OptionMappingCannotBeBidirectionalErr) else begin IntegrationFieldMapping.SetRange("Integration Table Mapping Name", Name); IntegrationFieldMapping.ModifyAll(Direction, Direction); if CRMFullSynchReviewLine.Get(Name) then if CRMFullSynchReviewLine.Direction <> Direction then begin CRMFullSynchReviewLine.Direction := Direction; CRMFullSynchReviewLine.Modify(); end; if Direction = Direction::ToIntegrationTable then begin JobQueueEntry.SetRange("Record ID to Process", RecordId); JobQueueEntry.SetRange("Object ID to Run", Codeunit::"Integration Synch. Job Runner"); JobQueueEntry.SetRange("Object Type to Run", JobQueueEntry."Object Type to Run"::Codeunit); if JobQueueEntry.FindFirst() then if JobQueueEntry.Status = JobQueueEntry.Status::Ready then begin JobQueueEntry.Status := JobQueueEntry.Status::"On Hold with Inactivity Timeout"; JobQueueEntry.Modify(); end; end; end else begin IntegrationFieldMapping.SetRange("Integration Table Mapping Name", Rec.Name); IntegrationFieldMapping.SetRange(Status, IntegrationFieldMapping.Status::Enabled); NoEnabledFieldMappingsExist := IntegrationFieldMapping.IsEmpty(); IntegrationFieldMapping.SetRange(Direction, Rec.Direction); if not NoEnabledFieldMappingsExist then if IntegrationFieldMapping.IsEmpty() then if GuiAllowed() then Error(DirectionFieldsErr, Format(Rec.Direction)) else Error(DirectionFieldsNoUIHintErr, Format(Rec.Direction)) end; if Rec.Direction <> Rec.Direction::FromIntegrationTable then if Rec."Multi Company Synch. Enabled" then Message(ChangeDirectionMultiCompanyMsg); end; } field(11; "Int. Tbl. Caption Prefix"; Text[30]) { Caption = 'Int. Tbl. Caption Prefix'; ToolTip = 'Specifies text that appears before the caption of the integration table wherever the caption is used.'; } field(12; "Synch. Int. Tbl. Mod. On Fltr."; DateTime) { Caption = 'Synch. Int. Tbl. Mod. On Fltr.'; ToolTip = 'Specifies a date/time filter that uses the date on which records were modified to determine which records to synchronize to the integration system. The filter is based on the SystemModifiedAt field on the Business Central table records.'; Description = 'Scheduled synch. Integration Table Modified On Filter'; } field(13; "Synch. Modified On Filter"; DateTime) { Caption = 'Synch. Modified On Filter'; ToolTip = 'Specifies a date/time filter that uses the date on which records were modified to determine which records to synchronize from the system you are integrating with. The filter is based on the Modified On field on the integration table records.'; Description = 'Scheduled synch. Modified On Filter'; } field(14; "Table Filter"; BLOB) { Caption = 'Table Filter'; } field(15; "Integration Table Filter"; BLOB) { Caption = 'Integration Table Filter'; } field(16; "Synch. Only Coupled Records"; Boolean) { Caption = 'Synch. Only Coupled Records'; ToolTip = 'Specifies if the synchronization engine will process only currently coupled records or couple the newly created records as well.'; InitValue = true; trigger OnValidate() begin CheckDeletionConflictResolutionStrategy(); end; } field(17; "Parent Name"; Code[20]) { Caption = 'Parent Name'; } field(18; "Graph Delta Token"; Text[250]) { Caption = 'Graph Delta Token'; } field(19; "Int. Tbl. Delta Token Fld. No."; Integer) { Caption = 'Int. Tbl. Delta Token Fld. No.'; } field(20; "Int. Tbl. ChangeKey Fld. No."; Integer) { Caption = 'Int. Tbl. ChangeKey Fld. No.'; } field(21; "Int. Tbl. State Fld. No."; Integer) { Caption = 'Int. Tbl. State Fld. No.'; } field(22; "Delete After Synchronization"; Boolean) { Caption = 'Delete After Synchronization'; } field(23; "BC Rec Page Id"; Integer) { Caption = 'The Id of the BC Record Page'; } field(24; "CDS Rec Page Id"; Integer) { Caption = 'The Id of the Dataverse Record Page'; } field(25; "Deletion-Conflict Resolution"; Enum "Integration Deletion Conflict Resolution") { Caption = 'Resolve Deletion Conflicts'; ToolTip = 'Specifies the action to take when a coupled record is deleted in one of the connected applications.'; trigger OnValidate() begin CheckDeletionConflictResolutionStrategy(); end; } field(26; "Update-Conflict Resolution"; Enum "Integration Update Conflict Resolution") { Caption = 'Resolve Update Conflicts'; ToolTip = 'Specifies the action to take when a coupled record is updated in both of the connected applications.'; } field(27; "Uncouple Codeunit ID"; Integer) { Caption = 'Uncouple Codeunit ID'; TableRelation = "CodeUnit Metadata".ID; } field(28; "Coupling Codeunit ID"; Integer) { Caption = 'Coupling Codeunit ID'; TableRelation = "CodeUnit Metadata".ID; } field(29; "Synch. After Bulk Coupling"; Boolean) { Caption = 'Synch. After Match-Based Coupling'; } field(30; "Dependency Filter"; Text[250]) { Caption = 'Dependency Filter'; } field(31; "Create New in Case of No Match"; Boolean) { Caption = 'Create New in Case of No Match'; } field(32; Type; Enum "Integration Table Mapping Type") { Caption = 'Type'; } field(33; "Disable Event Job Resch."; Boolean) { Caption = 'Disable Event-driven Synch. Job Rescheduling'; ToolTip = 'Specifies if event-based rescheduling of synchronization jobs should be turned off for this table mapping.'; trigger OnValidate() begin if not GuiAllowed() then exit; if Rec."Disable Event Job Resch." then if not Confirm(DisableEventDrivenReshedulingQst) then Error(''); if not Confirm(EnableEventDrivenReshedulingQst) then Error(''); end; } field(34; "Multi Company Synch. Enabled"; Boolean) { Caption = 'Multi-Company Synchronization Enabled'; ToolTip = 'Specifies if the multi-company synchronization is enabled for this mapping.'; trigger OnValidate() var FeatureTelemetry: Codeunit "Feature Telemetry"; begin FeatureTelemetry.LogUptake('0000LCM', 'Dataverse Multi-Company Synch', Enum::"Feature Uptake Status"::Discovered); FeatureTelemetry.LogUptake('0000LCN', 'Dataverse Multi-Company Synch', Enum::"Feature Uptake Status"::"Set up"); if Rec."Multi Company Synch. Enabled" then Rec.EnableMultiCompanySynchronization() else Rec.DisableMultiCompanySynchronization(); end; } field(35; "Table Caption"; Text[250]) { Caption = 'Table Caption'; } field(98; "No. of Errors"; Integer) { Caption = 'Number of Errors'; ToolTip = 'Specifies the number of errors for this mapping.'; FieldClass = FlowField; CalcFormula = sum("Integration Synch. Job".Failed where("Integration Table Mapping Name" = field(Name))); } field(99; "No. of Skipped"; Integer) { Caption = 'Number of Skipped Records'; ToolTip = 'Specifies the number of records that are excluded from the synchronization because of repetitive errors.'; FieldClass = FlowField; CalcFormula = count("CRM Integration Record" where("Table ID" = field("Table ID"), Skipped = const(true))); } field(100; "Full Sync is Running"; Boolean) { Caption = 'Full Sync is Running'; Description = 'This is set to TRUE when FullSync starts, and to FALSE when FullSync completes.'; trigger OnValidate() begin if xRec.Get(Name) then; if (not xRec."Full Sync is Running") and "Full Sync is Running" then begin "Last Full Sync Start DateTime" := CurrentDateTime; "Full Sync Session ID" := SessionId(); end; if not "Full Sync is Running" then "Full Sync Session ID" := 0; end; } field(101; "Full Sync Session ID"; Integer) { Caption = 'Full Sync Session ID'; Description = 'The ID of the session running the FullSync must be 0 if FullSync is not running.'; } field(102; "Last Full Sync Start DateTime"; DateTime) { Caption = 'Last Full Sync Start DateTime'; Description = 'The starting date and time of the last time FullSync was run. This is used to re-run in case FullSync failed to reset these fields.'; } field(103; "User Defined"; Boolean) { Caption = 'User Defined'; ToolTip = 'Specifies if the field is generated manually through the integration table mapping wizard.'; Description = 'Indicates whether the table mapping was defined manually by the user or by the system.'; } } keys { key(Key1; Name) { Clustered = true; } key(Key2; "Table ID", "Integration Table ID") { } key(Key3; "Table ID", "Integration Table ID", Type) { } } fieldgroups { } trigger OnDelete() var IntegrationFieldMapping: Record "Integration Field Mapping"; ManIntegrationTableMapping: Record "Man. Integration Table Mapping"; TableConfigTemplate: Record "Table Config Template"; IntTableConfigTemplate: Record "Int. Table Config Template"; begin IntegrationFieldMapping.SetRange("Integration Table Mapping Name", Name); IntegrationFieldMapping.DeleteAll(); ManIntegrationTableMapping.SetRange(Name, Name); if ManIntegrationTableMapping.IsEmpty() then begin TableConfigTemplate.SetRange("Integration Table Mapping Name", Name); TableConfigTemplate.DeleteAll(); IntTableConfigTemplate.SetRange("Integration Table Mapping Name", Name); IntTableConfigTemplate.DeleteAll(); end; end; var JobLogEntryNo: Integer; DateType: Option ,Integration,Local; ConfirmIncludeEntitiesWithNoCompanyQst: Label 'Do you want the Integration Table Filter to include %1 entities with no value in %2 attribute?', Comment = '%1 - Dataverse service name; %2 - attribute name of a Dataverse entity'; OptionMappingCannotBeBidirectionalErr: Label 'Option mappings can only synchronize from integration table or to integration table.'; UserChoseNotToIncludeEntitiesWithEmptyCompanyNameTxt: Label 'User chose not to include %1 entities with empty company id in the Integration Table Filter of the %2 mapping.', Locked = true; RemoveCouplingStrategyQst: Label 'Synch. Only Coupled Records is unchecked. Therefore, if conflict resolution strategy removes a broken coupling, a subsequent scheduled synchronization job may recreate the coupling. Do you want to continue?'; TelemetryCategoryTok: Label 'AL Dataverse Integration', Locked = true; CompanyIdFieldNameTxt: Label 'CompanyId', Locked = true; DisableEventDrivenReshedulingQst: Label 'This will disable the event-based rescheduling of synchronization jobs for this table. \\The frequency of the synchronization job runs is specified in the Inactivity Timeout Period field on the corresponding job queue entry. \\Do you want to continue?'; EnableEventDrivenReshedulingQst: Label 'This will enable the event-based rescheduling of synchronization jobs for this table. \\The synchronization job will be rescheduled within 30-60 seconds after an insertion, change or deletion on the corresponding table. \\In case of no changes during a long period, the synchronization job will be rescheduled as specified in the Inactivity Timeout Period field on the corresponding job queue entry. \\Do you want to continue?'; CompanyFilterRemovedQst: Label 'This will remove the company field filter from Integration Table Filter and make the synchronization engine process %1 entities regardless of their Company field value. Do you want to continue?', Comment = '%1 - a table caption'; CompanyFilterRemovedExtendedMsg: Label '%1 entities will be synchronized regardless of their Company field value. To control which entities get synchronized to this company, set the Integration Table Filter on other fields. We strongly recommend to set the direction of this mapping to ''From Integration''. \\If you set it up to synchronize bidirectionally or to synchronize ''To Integration'', to avoid duplicates being created, use match-based coupling or consolidated filtering across companies instead of just unchecking the Synch. Only Coupled Records checkbox. \\If your number series do not guarantee uniqueness of primary key values across multiple companies, then use a transformation rule in the direction ''To Integration'' to add a prefix to primary key values, to ensure their uniqueness in Dataverse.', Comment = '%1 - a table caption'; CompanyFilterRemovedShortMsg: Label '%1 entities will be synchronized regardless of their Company field value. To control which entities get synchronized to this company, set the Integration Table Filter on other fields.', Comment = '%1 - a table caption'; CompanyFilterResetMsg: Label 'The company field filter on the Integration Table Filter is reset to default.'; CompanyFilterStrengthenedQst: Label 'This will make the synchronization engine process only %1 entities that correspond to the current company. Do you want to continue?', Comment = '%1 - a table caption'; CompanyFilterResetToDefaultQst: Label 'This will reset the company field filter from Integration Table Filter to the default. Do you want to continue?'; CompanyFilterStrengthenedMsg: Label 'The synchronization will consider only %1 entities that correspond to this company. \\To make Business Central process %1 entities that are originally created in %3, the %3 users must set their Company value to match the company %2.', Comment = '%1 - a table caption; %2 - current company name; %3 - Dynamics 365 service name'; InstallLatestSolutionConfirmLbl: Label 'This functionality requires the latest integration solution to be imported on your Dataverse environment. You will be prompted to sign in with your Dataverse administrator account credentials. Do you want to continue?'; OrTok: Label '%1|%2', Locked = true; ChangeDirectionMultiCompanyMsg: Label 'This mapping is set up for multi-company synchronization. We strongly recommend to set the direction of this mapping to ''From Integration''. \\If you set it up to synchronize bidirectionally or to synchronize ''To Integration'', to avoid duplicates being created, use match-based coupling or consolidated filtering across companies instead of just unchecking the Synch. Only Coupled Records checkbox. \\If your number series do not guarantee uniqueness of primary key values across multiple companies, then use a Transformation Rule in the direction ''To Integration'' to add a prefix to primary key values, to ensure their uniqueness in Dataverse.'; DirectionFieldsErr: Label 'You must set the direction of at least one enabled integration field mapping to ''%1''. Choose the Fields action to edit the integration field mappings.', Comment = '%1 - an option value'; DirectionFieldsNoUIHintErr: Label 'You must set the direction of at least one enabled integration field mapping to ''%1''.', Comment = '%1 - an option value'; MultipleConfigTemplatesLbl: Label '%1 templates', Comment = '%1 - number of templates'; procedure FindFilteredRec(RecordRef: RecordRef; var OutOfMapFilter: Boolean) Found: Boolean var TempRecRef: RecordRef; begin TempRecRef.Open(RecordRef.Number, true); CopyRecordReference(RecordRef, TempRecRef, false); if "Table ID" = RecordRef.Number then SetRecordRefFilter(TempRecRef) else SetIntRecordRefFilter(TempRecRef); Found := TempRecRef.Find(); OutOfMapFilter := not Found; TempRecRef.Close(); end; [Scope('Cloud')] procedure FindMapping(TableNo: Integer; IntegrationTableNo: Integer): Boolean begin SetRange("Table ID", TableNo); SetRange("Integration Table ID", IntegrationTableNo); SetRange("Delete After Synchronization", false); exit(FindFirst()); end; procedure FindMappingForTable(TableId: Integer): Boolean begin SetRange("Table ID", TableId); SetRange("Delete After Synchronization", false); exit(FindFirst()); end; procedure DoesExistForTable(TableId: Integer): Boolean begin SetRange("Table ID", TableId); SetRange("Delete After Synchronization", false); exit(not IsEmpty()); end; procedure IsFullSynch(): Boolean begin exit("Full Sync is Running" and "Delete After Synchronization"); end; procedure GetName() Result: Code[20] begin if "Delete After Synchronization" then Result := "Parent Name"; if Result = '' then Result := Name; end; procedure GetDirection(): Integer var IntegrationTableMapping: Record "Integration Table Mapping"; begin IntegrationTableMapping.Get(GetName()); exit(IntegrationTableMapping.Direction); end; procedure GetJobLogEntryNo(): Integer begin exit(JobLogEntryNo) end; procedure GetTempDescription(): Text var Separator: Text; begin case Direction of Direction::Bidirectional: Separator := '<->'; Direction::ToIntegrationTable: Separator := '->'; Direction::FromIntegrationTable: Separator := '<-'; end; exit( StrSubstNo( '%1 %2 %3', GetTableCaption("Table ID"), Separator, GetTableCaption("Integration Table ID"))); end; procedure GetExtendedIntegrationTableCaption(): Text var TableCaption: Text; begin TableCaption := GetTableExternalName("Integration Table ID"); if TableCaption <> '' then if "Int. Tbl. Caption Prefix" <> '' then exit(StrSubstNo('%1 %2', "Int. Tbl. Caption Prefix", TableCaption)); exit(TableCaption); end; procedure GetUserFriendlyMappingName(): Text var LocalRecordRef: RecordRef; IntegrationRecordRef: RecordRef; begin if (Rec."Table ID" = 0) or (Rec."Integration Table ID" = 0) then exit(''); LocalRecordRef.Open(Rec."Table ID"); IntegrationRecordRef.Open(Rec."Integration Table ID"); if Rec."Table ID" = Rec."Integration Table ID" then exit(LocalRecordRef.Caption()); exit(LocalRecordRef.Caption() + ' - ' + IntegrationRecordRef.Caption()); end; local procedure GetTableCaption(ID: Integer): Text var TableMetadata: Record "Table Metadata"; begin if TableMetadata.Get(ID) then exit(TableMetadata.Caption); exit(''); end; local procedure GetTableExternalName(ID: Integer): Text var TableMetadata: Record "Table Metadata"; begin if TableMetadata.Get(ID) then exit(TableMetadata.ExternalName); exit(''); end; procedure SetTableFilter("Filter": Text) var OutStream: OutStream; begin "Table Filter".CreateOutStream(OutStream); OutStream.Write(Filter); end; procedure GetTableFilter() Value: Text var InStream: InStream; begin CalcFields("Table Filter"); "Table Filter".CreateInStream(InStream); InStream.Read(Value); end; procedure SetIntegrationTableFilter(IntTableFilter: Text) var OutStream: OutStream; begin "Integration Table Filter".CreateOutStream(OutStream); OutStream.Write(IntTableFilter); end; [Scope('OnPrem')] procedure SuggestToIncludeEntitiesWithNullCompany(var IntTableFilter: Text); var Field: Record "Field"; CRMProductName: Codeunit "CRM Product Name"; CompanyIdFieldNo: Integer; CompanyIdFilterStartPos: Integer; CompanyIdFilter: Text; ModifiedCompanyIdFilter: Text; OrNullGuid: Text; begin OrNullGuid := '|{00000000-0000-0000-0000-000000000000}'; Field.SetRange(TableNo, "Integration Table ID"); Field.SetRange(Type, Field.Type::GUID); Field.SetRange(FieldName, CompanyIdFieldNameTxt); if not Field.FindFirst() then exit; CompanyIdFieldNo := Field."No."; CompanyIdFilterStartPos := IntTableFilter.IndexOf('Field' + Format(CompanyIdFieldNo) + '=1'); if CompanyIdFilterStartPos <= 0 then exit; CompanyIdFilter := CopyStr(IntTableFilter, CompanyIdFilterStartPos); CompanyIdFilter := CopyStr(CompanyIdFilter, 1, CompanyIdFilter.IndexOf(')')); if (CompanyIdFilter = '') or (CompanyIdFilter.IndexOf(OrNullGuid) > 0) then exit; if not Confirm(StrSubstNo(ConfirmIncludeEntitiesWithNoCompanyQst, CRMProductName.CDSServiceName(), Field."Field Caption")) then begin Session.LogMessage('0000EG4', StrSubstNo(UserChoseNotToIncludeEntitiesWithEmptyCompanyNameTxt, CRMProductName.CDSServiceName(), Name), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', TelemetryCategoryTok); exit; end; ModifiedCompanyIdFilter := CompanyIdFilter.Replace(')', OrNullGuid + ')'); IntTableFilter := IntTableFilter.Replace(CompanyIdFilter, ModifiedCompanyIdFilter); end; procedure GetIntegrationTableFilter() Value: Text var InStream: InStream; begin CalcFields("Integration Table Filter"); "Integration Table Filter".CreateInStream(InStream); InStream.Read(Value); end; procedure SetIntTableModifiedOn(ModifiedOn: DateTime) begin if (ModifiedOn <> 0DT) and (ModifiedOn > "Synch. Int. Tbl. Mod. On Fltr.") then begin "Synch. Int. Tbl. Mod. On Fltr." := ModifiedOn; Modify(true); end; end; procedure SetTableModifiedOn(ModifiedOn: DateTime) begin if (ModifiedOn <> 0DT) and (ModifiedOn > "Synch. Modified On Filter") then begin "Synch. Modified On Filter" := ModifiedOn; Modify(true); end; end; procedure SetJobLogEntryNo(NewJobLogEntryNo: Integer) begin JobLogEntryNo := NewJobLogEntryNo; end; procedure ShowLog(JobIDFilter: Text) begin ShowLog('', JobIDFilter, ''); end; procedure ShowSynchronizationLog(var IntegrationTableMapping: Record "Integration Table Mapping") var TempIntegrationSynchJob: Record "Integration Synch. Job" temporary; NameFilter: Text; begin NameFilter := GetNameFilter(IntegrationTableMapping); TempIntegrationSynchJob.SetRange(Type, TempIntegrationSynchJob.Type::Synchronization); ShowLog(NameFilter, '', TempIntegrationSynchJob.GetFilter(Type)); end; procedure ShowUncouplingLog(var IntegrationTableMapping: Record "Integration Table Mapping") var TempIntegrationSynchJob: Record "Integration Synch. Job" temporary; NameFilter: Text; begin NameFilter := GetNameFilter(IntegrationTableMapping); TempIntegrationSynchJob.SetRange(Type, TempIntegrationSynchJob.Type::Uncoupling); ShowLog(NameFilter, '', TempIntegrationSynchJob.GetFilter(Type)); end; procedure ShowCouplingLog(var IntegrationTableMapping: Record "Integration Table Mapping") var TempIntegrationSynchJob: Record "Integration Synch. Job" temporary; NameFilter: Text; begin NameFilter := GetNameFilter(IntegrationTableMapping); TempIntegrationSynchJob.SetRange(Type, TempIntegrationSynchJob.Type::Coupling); ShowLog(NameFilter, '', TempIntegrationSynchJob.GetFilter(Type)); end; procedure SetOriginalJobQueueEntryOnHold(var JobQueueEntry: Record "Job Queue Entry"; var PrevStatus: Option) var OriginalIntegrationTableMapping: Record "Integration Table Mapping"; begin if Rec."Full Sync is Running" then begin OriginalIntegrationTableMapping.Get(Rec."Parent Name"); JobQueueEntry.SetRange("Record ID to Process", OriginalIntegrationTableMapping.RecordId); if JobQueueEntry.FindFirst() then begin PrevStatus := JobQueueEntry.Status; JobQueueEntry.SetStatus(JobQueueEntry.Status::"On Hold"); end; end; end; procedure SetOriginalJobQueueEntryStatus(var JobQueueEntry: Record "Job Queue Entry"; Status: Option) var OriginalIntegrationTableMapping: Record "Integration Table Mapping"; begin if Rec."Full Sync is Running" then begin OriginalIntegrationTableMapping.Get(Rec."Parent Name"); OriginalIntegrationTableMapping.CopyModifiedOnFilters(Rec); if JobQueueEntry.FindFirst() then JobQueueEntry.SetStatus(Status); end; end; procedure UpdateTableMappingModifiedOn(LatestModifiedOn: array[2] of DateTime) var IsChanged: Boolean; begin if LatestModifiedOn[DateType::Integration] > Rec."Synch. Modified On Filter" then begin Rec."Synch. Modified On Filter" := LatestModifiedOn[DateType::Integration]; IsChanged := true; end; if LatestModifiedOn[DateType::Local] > Rec."Synch. Int. Tbl. Mod. On Fltr." then begin Rec."Synch. Int. Tbl. Mod. On Fltr." := LatestModifiedOn[DateType::Local]; IsChanged := true; end; if IsChanged then Rec.Modify(true); end; local procedure CopyRecordReference(FromRec: RecordRef; var ToRec: RecordRef; ValidateOnInsert: Boolean) var FromField: FieldRef; ToField: FieldRef; Counter: Integer; begin if FromRec.Number <> ToRec.Number then exit; ToRec.Init(); for Counter := 1 to FromRec.FieldCount do begin FromField := FromRec.FieldIndex(Counter); if not (FromField.Type in [FieldType::BLOB, FieldType::TableFilter]) then begin ToField := ToRec.Field(FromField.Number); ToField.Value := FromField.Value(); end; end; ToRec.Insert(ValidateOnInsert); end; local procedure ShowLog(NameFilter: Text; JobIDFilter: Text; JobTypeFilter: Text) var IntegrationSynchJob: Record "Integration Synch. Job"; begin if (NameFilter = '') and (Name = '') then exit; IntegrationSynchJob.SetCurrentKey("Start Date/Time", ID); IntegrationSynchJob.Ascending := false; IntegrationSynchJob.FilterGroup(2); if NameFilter <> '' then IntegrationSynchJob.SetFilter("Integration Table Mapping Name", NameFilter) else IntegrationSynchJob.SetRange("Integration Table Mapping Name", Name); IntegrationSynchJob.FilterGroup(0); if JobIDFilter <> '' then IntegrationSynchJob.SetFilter(ID, JobIDFilter); if JobTypeFilter <> '' then IntegrationSynchJob.SetFilter(Type, JobTypeFilter); if IntegrationSynchJob.FindFirst() then; Page.Run(Page::"Integration Synch. Job List", IntegrationSynchJob); end; local procedure GetNameFilter(var IntegrationTableMapping: Record "Integration Table Mapping"): Text var NameFilter: Text; begin if IntegrationTableMapping.FindSet() then repeat if Name <> '' then begin if NameFilter <> '' then NameFilter += '|'; NameFilter += IntegrationTableMapping.Name; end; until IntegrationTableMapping.Next() = 0; exit(NameFilter); end; procedure SynchronizeNow(ResetLastSynchModifiedOnDateTime: Boolean) begin SynchronizeNow(ResetLastSynchModifiedOnDateTime, false); end; procedure SynchronizeNow(ResetLastSynchModifiedOnDateTime: Boolean; ResetSynchonizationTimestampOnRecords: Boolean) var CRMIntegrationRecord: Record "CRM Integration Record"; CRMSetupDefaults: Codeunit "CRM Setup Defaults"; CRMIntegrationManagement: Codeunit "CRM Integration Management"; IsHandled: Boolean; begin OnSynchronizeNow(Rec, ResetLastSynchModifiedOnDateTime, ResetSynchonizationTimestampOnRecords, IsHandled); if IsHandled then exit; Codeunit.Run(Codeunit::"CRM Integration Management"); if ResetLastSynchModifiedOnDateTime then begin Clear("Synch. Modified On Filter"); Clear("Synch. Int. Tbl. Mod. On Fltr."); Modify(); end; if ResetSynchonizationTimestampOnRecords then begin CRMIntegrationManagement.RepairBrokenCouplings(true); CRMIntegrationRecord.SetRange("Table ID", "Table ID"); case Direction of Direction::ToIntegrationTable: CRMIntegrationRecord.ModifyAll("Last Synch. Modified On", 0DT); Direction::FromIntegrationTable: CRMIntegrationRecord.ModifyAll("Last Synch. CRM Modified On", 0DT); end end; Commit(); CRMSetupDefaults.CreateJobQueueEntry(Rec); end; [Scope('OnPrem')] procedure SynchronizeOptionNow(ResetLastSynchModifiedOnDateTime: Boolean; ResetSynchonizationTimestampOnRecords: Boolean) var CRMOptionMapping: Record "CRM Option Mapping"; CRMSetupDefaults: Codeunit "CRM Setup Defaults"; begin Codeunit.Run(Codeunit::"CRM Integration Management"); if ResetLastSynchModifiedOnDateTime then begin Clear("Synch. Modified On Filter"); Clear("Synch. Int. Tbl. Mod. On Fltr."); Modify(); end; if ResetSynchonizationTimestampOnRecords then begin CRMOptionMapping.SetRange("Table ID", "Table ID"); CRMOptionMapping.SetRange("Integration Table ID", "Integration Table ID"); if Direction = Direction::ToIntegrationTable then CRMOptionMapping.ModifyAll("Last Synch. Modified On", 0DT); end; Commit(); CRMSetupDefaults.CreateJobQueueEntry(Rec); end; procedure GetRecordRef(ID: Variant; var IntegrationRecordRef: RecordRef): Boolean var IDFieldRef: FieldRef; RecordID: RecordID; TextKey: Text; begin IntegrationRecordRef.Close(); if ID.IsGuid then begin IntegrationRecordRef.Open("Integration Table ID"); IDFieldRef := IntegrationRecordRef.Field("Integration Table UID Fld. No."); IDFieldRef.SetFilter(ID); exit(IntegrationRecordRef.FindFirst()); end; if ID.IsRecordId then begin RecordID := ID; if RecordID.TableNo = "Table ID" then exit(IntegrationRecordRef.Get(ID)); end; if ID.IsText then begin IntegrationRecordRef.Open("Integration Table ID"); IDFieldRef := IntegrationRecordRef.Field("Integration Table UID Fld. No."); TextKey := ID; IDFieldRef.SetFilter('%1', TextKey); exit(IntegrationRecordRef.FindFirst()); end; end; procedure SetIntRecordRefFilter(var IntRecordRef: RecordRef) var ModifiedOnFieldRef: FieldRef; TableFilter: Text; begin TableFilter := GetIntegrationTableFilter(); if TableFilter <> '' then IntRecordRef.SetView(TableFilter); if "Synch. Modified On Filter" <> 0DT then begin ModifiedOnFieldRef := IntRecordRef.Field("Int. Tbl. Modified On Fld. No."); ModifiedOnFieldRef.SetFilter('>%1', "Synch. Modified On Filter" - 999); end; end; procedure SetIntRecordRefFilter(var IntRecordRef: RecordRef; TableFilter: Text) var ModifiedOnFieldRef: FieldRef; begin if TableFilter <> '' then IntRecordRef.SetView(TableFilter); if "Synch. Modified On Filter" <> 0DT then begin ModifiedOnFieldRef := IntRecordRef.Field("Int. Tbl. Modified On Fld. No."); ModifiedOnFieldRef.SetFilter('>%1', "Synch. Modified On Filter" - 999); end; end; procedure SetRecordRefFilter(var RecordRef: RecordRef) var TableFilter: Text; begin TableFilter := GetTableFilter(); if TableFilter <> '' then RecordRef.SetView(TableFilter); end; procedure CopyModifiedOnFilters(FromIntegrationTableMapping: Record "Integration Table Mapping") begin "Synch. Modified On Filter" := FromIntegrationTableMapping."Synch. Modified On Filter"; "Synch. Int. Tbl. Mod. On Fltr." := FromIntegrationTableMapping."Synch. Int. Tbl. Mod. On Fltr."; Modify(); end; [Scope('Cloud')] procedure CreateRecord(MappingName: Code[20]; TableNo: Integer; IntegrationTableNo: Integer; IntegrationTableUIDFieldNo: Integer; IntegrationTableModifiedFieldNo: Integer; TableConfigTemplateCode: Code[10]; IntegrationTableConfigTemplateCode: Code[10]; SynchOnlyCoupledRecords: Boolean; DirectionArg: Option; Prefix: Text[30]) var IntegrationTableMapping: Record "Integration Table Mapping"; CDSIntegrationMgt: Codeunit "CDS Integration Mgt."; UncoupleCodeunitId: Integer; CouplingCodeunitId: Integer; begin if DirectionArg in [IntegrationTableMapping.Direction::ToIntegrationTable, IntegrationTableMapping.Direction::Bidirectional] then if CDSIntegrationMgt.HasCompanyIdField(IntegrationTableNo) then UncoupleCodeunitId := Codeunit::"CDS Int. Table Uncouple"; CouplingCodeunitId := Codeunit::"CDS Int. Table Couple"; CreateRecord(MappingName, TableNo, IntegrationTableNo, IntegrationTableUIDFieldNo, IntegrationTableModifiedFieldNo, TableConfigTemplateCode, IntegrationTableConfigTemplateCode, SynchOnlyCoupledRecords, DirectionArg, Prefix, Codeunit::"CRM Integration Table Synch.", UncoupleCodeunitId, CouplingCodeunitId); end; [Scope('Cloud')] procedure CreateRecord(MappingName: Code[20]; TableNo: Integer; IntegrationTableNo: Integer; IntegrationTableUIDFieldNo: Integer; IntegrationTableModifiedFieldNo: Integer; TableConfigTemplateCode: Code[10]; IntegrationTableConfigTemplateCode: Code[10]; SynchOnlyCoupledRecords: Boolean; DirectionArg: Option; Prefix: Text[30]; SynchCodeunitId: Integer; UncoupleCodeunitId: Integer) var Field: Record Field; begin if Get(MappingName) then Delete(true); Init(); Name := MappingName; "Table ID" := TableNo; "Integration Table ID" := IntegrationTableNo; "Synch. Codeunit ID" := SynchCodeunitId; "Uncouple Codeunit ID" := UncoupleCodeunitId; Validate("Integration Table UID Fld. No.", IntegrationTableUIDFieldNo); "Int. Tbl. Modified On Fld. No." := IntegrationTableModifiedFieldNo; Direction := DirectionArg; "Int. Tbl. Caption Prefix" := Prefix; "Synch. Only Coupled Records" := SynchOnlyCoupledRecords; if "Int. Table UID Field Type" = Field.Type::Option then "Coupling Codeunit ID" := Codeunit::"CDS Int. Option Couple" else "Coupling Codeunit ID" := Codeunit::"CDS Int. Table Couple"; Insert(true); if TableConfigTemplateCode <> '' then CreateTableConfigTemplate(Rec, TableConfigTemplateCode); if IntegrationTableConfigTemplateCode <> '' then CreateIntTableConfigTemplate(Rec, IntegrationTableConfigTemplateCode); end; [Scope('Cloud')] procedure CreateRecord(MappingName: Code[20]; TableNo: Integer; IntegrationTableNo: Integer; IntegrationTableUIDFieldNo: Integer; IntegrationTableModifiedFieldNo: Integer; TableConfigTemplateCode: Code[10]; IntegrationTableConfigTemplateCode: Code[10]; SynchOnlyCoupledRecords: Boolean; DirectionArg: Option; Prefix: Text[30]; SynchCodeunitId: Integer; UncoupleCodeunitId: Integer; CouplingCodeunitId: Integer) begin if Get(MappingName) then Delete(true); Init(); Name := MappingName; "Table ID" := TableNo; "Integration Table ID" := IntegrationTableNo; "Synch. Codeunit ID" := SynchCodeunitId; "Uncouple Codeunit ID" := UncoupleCodeunitId; Validate("Integration Table UID Fld. No.", IntegrationTableUIDFieldNo); "Int. Tbl. Modified On Fld. No." := IntegrationTableModifiedFieldNo; Direction := DirectionArg; "Int. Tbl. Caption Prefix" := Prefix; "Synch. Only Coupled Records" := SynchOnlyCoupledRecords; "Coupling Codeunit ID" := CouplingCodeunitId; Insert(true); if TableConfigTemplateCode <> '' then CreateTableConfigTemplate(Rec, TableConfigTemplateCode); if IntegrationTableConfigTemplateCode <> '' then CreateIntTableConfigTemplate(Rec, IntegrationTableConfigTemplateCode); end; procedure SetFullSyncStartAndCommit() begin Validate("Full Sync is Running", true); Modify(); Commit(); Get(Name); end; procedure SetFullSyncEndAndCommit() begin Validate("Full Sync is Running", false); Modify(); Commit(); Get(Name); end; procedure IsFullSyncAllowed(): Boolean begin Get(Name); if not "Full Sync is Running" then exit(true); if not IsSessionActive("Full Sync Session ID") then begin SetFullSyncEndAndCommit(); exit(true); end; if Abs(CurrentDateTime - "Last Full Sync Start DateTime") >= OneDayInMiliseconds() then exit(true); exit(false) end; internal procedure EnableMultiCompanySynchronization() var CRMConnectionSetup: Record "CRM Connection Setup"; CDSCompany: Record "CDS Company"; CDSIntegrationMgt: Codeunit "CDS Integration Mgt."; CDSIntegrationImpl: Codeunit "CDS Integration Impl."; CRMSetupDefaults: Codeunit "CRM Setup Defaults"; CRMIntegrationManagement: Codeunit "CRM Integration Management"; CRMProductName: Codeunit "CRM Product Name"; IntegrationRecordRef: RecordRef; CompanyIdFieldRef: FieldRef; IsHandled: Boolean; MessageTxt: Text; begin OnEnableMultiCompanySynchronization(Rec, IsHandled); if (IsHandled) then exit; if Rec.Type <> Rec.Type::Dataverse then exit; Codeunit.Run(Codeunit::"CRM Integration Management"); if CRMIntegrationManagement.IsCRMIntegrationEnabled() then if CRMIntegrationManagement.CheckSolutionVersionOutdated() then if CRMConnectionSetup.Get() then if GuiAllowed() then if Confirm(InstallLatestSolutionConfirmLbl) then CRMConnectionSetup.DeployCRMSolution(true) else Error(''); case Rec."Table ID" of Database::"Sales Header", Database::Opportunity: begin IntegrationRecordRef.Open(Rec."Integration Table ID"); if not CDSIntegrationImpl.FindCompanyIdField(IntegrationRecordRef, CompanyIdFieldRef) then exit; if not CDSIntegrationMgt.GetCDSCompany(CDSCompany) then exit; if GuiAllowed() then if not Confirm(StrSubstNo(CompanyFilterStrengthenedQst, IntegrationRecordRef.Caption())) then Error(''); IntegrationRecordRef.SetView(Rec.GetIntegrationTableFilter()); CompanyIdFieldRef.SetRange(CDSCompany.CompanyId); Rec.SetIntegrationTableFilter(CRMSetupDefaults.GetTableFilterFromView(Rec."Integration Table ID", IntegrationRecordRef.Caption(), IntegrationRecordRef.GetView())); MessageTxt := StrSubstNo(CompanyFilterStrengthenedMsg, IntegrationRecordRef.Caption(), CompanyName(), CRMProductName.SHORT()); if Rec.Modify() then if GuiAllowed() then if MessageTxt <> '' then Message(MessageTxt); end; else begin IntegrationRecordRef.Open(Rec."Integration Table ID"); if not CDSIntegrationImpl.FindCompanyIdField(IntegrationRecordRef, CompanyIdFieldRef) then exit; if GuiAllowed() then if not Confirm(StrSubstNo(CompanyFilterRemovedQst, IntegrationRecordRef.Caption())) then Error(''); IntegrationRecordRef.SetView(Rec.GetIntegrationTableFilter()); CompanyIdFieldRef.SetRange(); Rec.SetIntegrationTableFilter(CRMSetupDefaults.GetTableFilterFromView(Rec."Integration Table ID", IntegrationRecordRef.Caption(), IntegrationRecordRef.GetView())); if Rec.Modify() then if GuiAllowed() then if Rec.Direction = Rec.Direction::FromIntegrationTable then Message(StrSubstNo(CompanyFilterRemovedShortMsg, IntegrationRecordRef.Caption())) else Message(StrSubstNo(CompanyFilterRemovedExtendedMsg, IntegrationRecordRef.Caption())); end; end; end; internal procedure DisableMultiCompanySynchronization() var CDSCompany: Record "CDS Company"; CDSIntegrationMgt: Codeunit "CDS Integration Mgt."; CDSIntegrationImpl: Codeunit "CDS Integration Impl."; CRMSetupDefaults: Codeunit "CRM Setup Defaults"; IntegrationRecordRef: RecordRef; CompanyIdFieldRef: FieldRef; IsHandled: Boolean; EmptyGuid: Guid; begin OnDisableMultiCompanySynchronization(Rec, IsHandled); if (IsHandled) then exit; if Rec.Type <> Rec.Type::Dataverse then exit; Codeunit.Run(Codeunit::"CRM Integration Management"); IntegrationRecordRef.Open(Rec."Integration Table ID"); if not CDSIntegrationImpl.FindCompanyIdField(IntegrationRecordRef, CompanyIdFieldRef) then exit; if not CDSIntegrationMgt.GetCDSCompany(CDSCompany) then exit; if GuiAllowed() then if not Confirm(StrSubstNo(CompanyFilterResetToDefaultQst)) then Error(''); IntegrationRecordRef.SetView(Rec.GetIntegrationTableFilter()); CompanyIdFieldRef.SetFilter(StrSubstno(OrTok, CDSCompany.CompanyId, EmptyGuid)); Rec.SetIntegrationTableFilter(CRMSetupDefaults.GetTableFilterFromView(Rec."Integration Table ID", IntegrationRecordRef.Caption(), IntegrationRecordRef.GetView())); if Rec.Modify() then if GuiAllowed() then Message(CompanyFilterResetMsg); end; procedure IsMappingEnabled(RequestedDirection: Option Bidirectional,ToIntegrationTable,FromIntegrationTable): Boolean var IntegrationFieldMapping: Record "Integration Field Mapping"; IsHandled, Result : Boolean; begin OnBeforeIsMappingEnabled(RequestedDirection, Result, IsHandled); if IsHandled then exit(Result); if Rec.Direction <> RequestedDirection then case RequestedDirection of RequestedDirection::Bidirectional: exit(false); RequestedDirection::FromIntegrationTable: if Rec.Direction = Rec.Direction::ToIntegrationTable then exit(false); RequestedDirection::ToIntegrationTable: if Rec.Direction = Rec.Direction::FromIntegrationTable then exit(false); end; IntegrationFieldMapping.SetRange("Integration Table Mapping Name", Rec.Name); case RequestedDirection of RequestedDirection::Bidirectional: IntegrationFieldMapping.SetRange(Direction, IntegrationFieldMapping.Direction::Bidirectional); RequestedDirection::FromIntegrationTable: IntegrationFieldMapping.SetFilter(Direction, '%1|%2', IntegrationFieldMapping.Direction::FromIntegrationTable, IntegrationFieldMapping.Direction::Bidirectional); RequestedDirection::ToIntegrationTable: IntegrationFieldMapping.SetFilter(Direction, '%1|%2', IntegrationFieldMapping.Direction::ToIntegrationTable, IntegrationFieldMapping.Direction::Bidirectional); end; IntegrationFieldMapping.SetRange(Status, IntegrationFieldMapping.Status::Enabled); exit(not IntegrationFieldMapping.IsEmpty()); end; procedure IsFieldMappingEnabled(FieldNo: Integer; IntegrationTableFieldNo: Integer; RequestedDirection: Option Bidirectional,ToIntegrationTable,FromIntegrationTable): Boolean var IntegrationFieldMapping: Record "Integration Field Mapping"; IsHandled, Result : Boolean; begin OnBeforeIsFieldMappingEnabled(FieldNo, IntegrationTableFieldNo, RequestedDirection, Result, IsHandled); if IsHandled then exit(Result); if not IsMappingEnabled(RequestedDirection) then exit(false); IntegrationFieldMapping.SetRange("Integration Table Mapping Name", Rec.Name); IntegrationFieldMapping.SetRange("Field No.", FieldNo); IntegrationFieldMapping.SetRange("Integration Table Field No.", IntegrationTableFieldNo); case RequestedDirection of RequestedDirection::Bidirectional: IntegrationFieldMapping.SetRange(Direction, IntegrationFieldMapping.Direction::Bidirectional); RequestedDirection::FromIntegrationTable: IntegrationFieldMapping.SetFilter(Direction, '%1|%2', IntegrationFieldMapping.Direction::FromIntegrationTable, IntegrationFieldMapping.Direction::Bidirectional); RequestedDirection::ToIntegrationTable: IntegrationFieldMapping.SetFilter(Direction, '%1|%2', IntegrationFieldMapping.Direction::ToIntegrationTable, IntegrationFieldMapping.Direction::Bidirectional); end; IntegrationFieldMapping.SetRange(Status, IntegrationFieldMapping.Status::Enabled); exit(not IntegrationFieldMapping.IsEmpty()); end; local procedure OneDayInMiliseconds(): Integer begin exit(24 * 60 * 60 * 1000) end; procedure GetTableConfigTemplates(IntegrationTableMappingName: Code[20]): Text var TableConfigTemplate: Record "Table Config Template"; begin TableConfigTemplate.SetRange("Integration Table Mapping Name", IntegrationTableMappingName); case TableConfigTemplate.Count() of 0: exit(''); 1: begin TableConfigTemplate.FindFirst(); exit(TableConfigTemplate."Table Config Template Code"); end; else exit(StrSubstNo(MultipleConfigTemplatesLbl, Format(TableConfigTemplate.Count()))); end; end; procedure GetIntTableConfigTemplates(IntegrationTableMappingName: Code[20]): Text var IntegrationTableConfigTemplate: Record "Int. Table Config Template"; begin IntegrationTableConfigTemplate.SetRange("Integration Table Mapping Name", IntegrationTableMappingName); case IntegrationTableConfigTemplate.Count() of 0: exit(''); 1: begin IntegrationTableConfigTemplate.FindFirst(); exit(IntegrationTableConfigTemplate."Int. Tbl. Config Template Code"); end; else exit(StrSubstNo(MultipleConfigTemplatesLbl, Format(IntegrationTableConfigTemplate.Count()))); end; end; local procedure CreateTableConfigTemplate(IntegrationTableMapping: Record "Integration Table Mapping"; TableConfigTemplateCode: Code[10]) var TableConfigTemplate: Record "Table Config Template"; begin TableConfigTemplate."Integration Table Mapping Name" := IntegrationTableMapping.Name; TableConfigTemplate.Validate("Table ID", IntegrationTableMapping."Table ID"); TableConfigTemplate.Validate("Integration Table ID", IntegrationTableMapping."Integration Table ID"); TableConfigTemplate.Validate("Table Config Template Code", TableConfigTemplateCode); TableConfigTemplate.Insert(); end; local procedure CreateIntTableConfigTemplate(IntegrationTableMapping: Record "Integration Table Mapping"; IntegrationTableConfigTemplateCode: Code[10]) var IntTableConfigTemplate: Record "Int. Table Config Template"; begin IntTableConfigTemplate."Integration Table Mapping Name" := IntegrationTableMapping.Name; IntTableConfigTemplate.Validate("Integration Table ID", IntegrationTableMapping."Integration Table ID"); IntTableConfigTemplate.Validate("Table ID", IntegrationTableMapping."Table ID"); IntTableConfigTemplate.Validate("Int. Tbl. Config Template Code", IntegrationTableConfigTemplateCode); IntTableConfigTemplate.Insert(); end; [IntegrationEvent(false, false)] internal procedure OnIsCreateNewInCaseOfNoMatchControlVisible(var IntegrationTableMapping: Record "Integration Table Mapping"; var CreateNewInCaseOfNoMatchControlVisible: Boolean; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnSynchronizeNow(var IntegrationTableMapping: Record "Integration Table Mapping"; ResetLastSynchModifiedOnDateTime: Boolean; ResetSynchonizationTimestampOnRecords: Boolean; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] internal procedure OnEnableMultiCompanySynchronization(var IntegrationTableMapping: Record "Integration Table Mapping"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] internal procedure OnDisableMultiCompanySynchronization(var IntegrationTableMapping: Record "Integration Table Mapping"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeIsMappingEnabled(RequestedDirection: Option Bidirectional,ToIntegrationTable,FromIntegrationTable; var Result: Boolean; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeIsFieldMappingEnabled(FieldNo: Integer; IntegrationTableFieldNo: Integer; RequestedDirection: Option Bidirectional,ToIntegrationTable,FromIntegrationTable; var Result: Boolean; var IsHandled: Boolean) begin end; local procedure CheckDeletionConflictResolutionStrategy() begin if Rec."Deletion-Conflict Resolution" = Rec."Deletion-Conflict Resolution"::"Remove Coupling" then if not Rec."Synch. Only Coupled Records" then if GuiAllowed() then if not Confirm(RemoveCouplingStrategyQst) then Error(''); end;}