Codeunit 8611 Config. Package Management

Base Application, System.IO

src/Layers/W1/BaseApp/System/RapidStart/ConfigPackageManagement.Codeunit.al2,761 lines, Copyright (c) Microsoft Corporation. MIT

namespace System.IO;using Microsoft.Finance.Dimension;using Microsoft.Foundation.Comment;using Microsoft.Foundation.Company;using System.Environment;using System.Environment.Configuration;using System.Reflection;using System.Telemetry;codeunit 8611 "Config. Package Management"{    TableNo = "Config. Package Record";    trigger OnRun()    begin        Clear(RecordsInsertedCount);        Clear(RecordsModifiedCount);        InsertPackageRecord(Rec);    end;    var        TempConfigRecordForProcessing: Record "Config. Record For Processing" temporary;        TempAppliedConfigPackageRecord: Record "Config. Package Record" temporary;        TempConfigPackageFieldCache: Record "Config. Package Field" temporary;        TempConfigPackageFieldOrdered: Record "Config. Package Field" temporary;        ConfigProgressBar: Codeunit "Config. Progress Bar";        ConfigValidateMgt: Codeunit "Config. Validate Management";        ConfigMgt: Codeunit "Config. Management";        TypeHelper: Codeunit "Type Helper";        ValidationFieldID: Integer;        RecordsInsertedCount: Integer;        RecordsModifiedCount: Integer;        ApplyMode: Option ,PrimaryKey,NonKeyFields;        ErrorTypeEnum: Option General,TableRelation;        HideDialog: Boolean;#pragma warning disable AA0470        KeyFieldValueMissingErr: Label 'The value of the key field %1 has not been filled in for record %2 : %3.', Comment = 'Parameter 1 - field name, 2 - table name, 3 - code value. Example: The value of the key field Customer Posting Group has not been filled in for record Customer : XXXXX.';#pragma warning restore AA0470        ValidatingTableRelationsMsg: Label 'Validating table relations';#pragma warning disable AA0470        RecordsXofYMsg: Label 'Records: %1 of %2', Comment = 'Sample: 5 of 1025. 1025 is total number of records, 5 is a number of the current record ';#pragma warning restore AA0470        ApplyingPackageMsg: Label 'Applying package %1', Comment = '%1 = The name of the package being applied.';        ApplyingTableMsg: Label 'Applying table %1', Comment = '%1 = The name of the table being applied.';        NoTablesAndErrorsMsg: Label '%1 tables are processed.\%2 errors found.\%3 records inserted.\%4 records modified.', Comment = '%1 = number of tables processed, %2 = number of errors, %3 = number of records inserted, %4 = number of records modified';        NoTablesMsg: Label '%1 tables are processed.', Comment = '%1 = The number of tables that were processed.';        UpdatingDimSetsMsg: Label 'Updating dimension sets';        ProcessingOrderErr: Label 'Cannot set up processing order numbers. A cycle reference exists in the primary keys for table %1.', Comment = '%1 = The name of the table.';        ReferenceSameTableErr: Label 'Some lines refer to the same table. You cannot assign a table to a package more than one time.';        BlankTxt: Label '[Blank]';        DimValueDoesNotExistsErr: Label 'Dimension Value %1 %2 does not exist.', Comment = '%1 = Dimension Code, %2 = Dimension Value Code';        MSGPPackageCodeTxt: Label 'GB.ENU.CSV';        QBPackageCodeTxt: Label 'DM.IIF';        RapidStartTxt: Label 'RapidStart', Locked = true;        ImportNotAllowedErr: Label 'Cannot import table %1 through a Configuration Package.', Comment = '%1 = The name of the table.';        RSNotificaitonMsg: Label 'Use configuration packages to import data when setting up new companies. Depending on the amount of data, this can take time and impact system performance for all users.';        UsingBigRSPackageTxt: Label 'The user is shown a warning for action: %1. reason: %2', Locked = true;        AcknowledgePerformanceImpactTxt: Label 'The user was informed about the potential of poor perfomance and decided to continue. Process: %1', Locked = true;        LearnMoreTok: Label 'Learn more';        ApplyPackageLbl: Label 'Apply Package';        DisableNotificationLbl: Label 'Don''t show this again';        PackagageImportedNotificationNameLbl: Label 'Configuration Package Imported';        PackagageImportedNotificationDescriptionLbl: Label 'Notify user when a configuration package has been imported.';        PackageImportedNotificationTxt: Label 'Configuration package %1 has been imported, now you need to apply it.', Comment = '%1 - package code';        RapidStartDocumentationUrlTxt: Label 'https://go.microsoft.com/fwlink/?linkid=2121629';        ConfigurationPackageApplyDataStartMsg: Label 'Configuration package apply started: %1', Comment = '%1 - package code', Locked = true;        ConfigurationPackageApplyDataFinishMsg: Label 'Configuration package applied successfully: %1', Locked = true;        ConfigurationPackageDeletedMsg: Label 'Configuration package deleted successfully: %1', Locked = true;    procedure InsertPackage(var ConfigPackage: Record "Config. Package"; PackageCode: Code[20]; PackageName: Text[50]; ExcludeConfigTables: Boolean)    begin        ConfigPackage.Code := PackageCode;        ConfigPackage."Package Name" := PackageName;        ConfigPackage."Exclude Config. Tables" := ExcludeConfigTables;        ConfigPackage.Insert();    end;    procedure InsertPackageTable(var ConfigPackageTable: Record "Config. Package Table"; PackageCode: Code[20]; TableID: Integer)    begin        if not ConfigPackageTable.Get(PackageCode, TableID) then begin            ConfigPackageTable.Init();            ConfigPackageTable.Validate("Package Code", PackageCode);            ConfigPackageTable.Validate("Table ID", TableID);            ConfigPackageTable.Insert(true);        end;    end;    procedure InsertPackageTableWithoutValidation(var ConfigPackageTable: Record "Config. Package Table"; PackageCode: Code[20]; TableID: Integer)    begin        if not ConfigPackageTable.Get(PackageCode, TableID) then begin            ConfigPackageTable.Init();            ConfigPackageTable."Package Code" := PackageCode;            ConfigPackageTable."Table ID" := TableID;            ConfigPackageTable.Insert();        end;    end;    procedure InsertPackageField(var ConfigPackageField: Record "Config. Package Field"; PackageCode: Code[20]; TableID: Integer; FieldID: Integer; FieldName: Text[30]; FieldCaption: Text[250]; SetInclude: Boolean; SetValidate: Boolean; SetLocalize: Boolean; SetDimension: Boolean)    var        SkipRelationTableID: Boolean;    begin        if not ConfigPackageField.Get(PackageCode, TableID, FieldID) then begin            ConfigPackageField.Init();            ConfigPackageField.Validate("Package Code", PackageCode);            ConfigPackageField.Validate("Table ID", TableID);            ConfigPackageField.Validate(Dimension, SetDimension);            OnInsertPackageFieldOnBeforeValidateFieldID(ConfigPackageField);            ConfigPackageField.Validate("Field ID", FieldID);            ConfigPackageField.Validate("Field Name", FieldName);            ConfigPackageField."Field Caption" := FieldCaption;            ConfigPackageField."Primary Key" := ConfigValidateMgt.IsKeyField(TableID, FieldID);            ConfigPackageField."Include Field" := SetInclude or ConfigPackageField."Primary Key";            SkipRelationTableID := not SetDimension;            OnInsertPackageFieldOnAfterCalcSkipRelationTableID(ConfigPackageField, SkipRelationTableID);            if SkipRelationTableID then begin                ConfigPackageField."Relation Table ID" := ConfigValidateMgt.GetRelationTableID(TableID, FieldID);                ConfigPackageField."Validate Field" :=                  ConfigPackageField."Include Field" and SetValidate and not ValidateException(TableID, FieldID);            end;            ConfigPackageField."Localize Field" := SetLocalize;            ConfigPackageField.Dimension := SetDimension;            if SetDimension then                ConfigPackageField."Processing Order" := ConfigPackageField."Field ID";            OnInsertPackageFieldOnBeforeInsert(ConfigPackageField);            ConfigPackageField.Insert();        end;    end;    procedure InsertPackageFilter(var ConfigPackageFilter: Record "Config. Package Filter"; PackageCode: Code[20]; TableID: Integer; ProcessingRuleNo: Integer; FieldID: Integer; FieldFilter: Text[250])    begin        if not ConfigPackageFilter.Get(PackageCode, TableID, 0, FieldID) then begin            ConfigPackageFilter.Init();            ConfigPackageFilter.Validate("Package Code", PackageCode);            ConfigPackageFilter.Validate("Table ID", TableID);            ConfigPackageFilter.Validate("Processing Rule No.", ProcessingRuleNo);            ConfigPackageFilter.Validate("Field ID", FieldID);            ConfigPackageFilter.Validate("Field Filter", FieldFilter);            ConfigPackageFilter.Insert();        end else            if ConfigPackageFilter."Field Filter" <> FieldFilter then begin                ConfigPackageFilter."Field Filter" := FieldFilter;                ConfigPackageFilter.Modify();            end;    end;    procedure InsertPackageRecord(ConfigPackageRecord: Record "Config. Package Record")    var        ConfigPackageTable: Record "Config. Package Table";        RecRef: RecordRef;        DelayedInsert: Boolean;        IsHandled: Boolean;    begin        if (ConfigPackageRecord."Package Code" = '') or (ConfigPackageRecord."Table ID" = 0) then            exit;        if ConfigMgt.IsSystemTable(ConfigPackageRecord."Table ID") then            exit;        RecRef.Open(ConfigPackageRecord."Table ID");        if not IsImportAllowed(ConfigPackageRecord."Table ID") then            Error(ImportNotAllowedErr, RecRef.Caption);        if ApplyMode <> ApplyMode::NonKeyFields then            RecRef.Init();        ConfigPackageTable.Get(ConfigPackageRecord."Package Code", ConfigPackageRecord."Table ID");        DelayedInsert := ConfigPackageTable."Delayed Insert";        IsHandled := false;        OnInsertPackageRecordOnAfterDelayedInsert(RecRef, ConfigPackageRecord, ConfigPackageTable, ApplyMode, DelayedInsert, IsHandled);        if IsHandled then            exit;        InsertPrimaryKeyFields(RecRef, ConfigPackageRecord, true, DelayedInsert);        if (ApplyMode = ApplyMode::NonKeyFields) or DelayedInsert then            ModifyRecordDataFields(RecRef, ConfigPackageRecord, true, DelayedInsert);        if ApplyMode = ApplyMode::PrimaryKey then            UpdateKeyInfoForConfigPackageRecord(RecRef, ConfigPackageRecord);    end;    procedure InsertPackageData(var ConfigPackageData: Record "Config. Package Data"; PackageCode: Code[20]; TableID: Integer; No: Integer; FieldID: Integer; Value: Text[2048]; Invalid: Boolean)    begin        if not ConfigPackageData.Get(PackageCode, TableID, No, FieldID) then begin            ConfigPackageData.Init();            ConfigPackageData."Package Code" := PackageCode;            ConfigPackageData."Table ID" := TableID;            ConfigPackageData."No." := No;            ConfigPackageData."Field ID" := FieldID;            ConfigPackageData.Value := Value;            ConfigPackageData.Invalid := Invalid;            ConfigPackageData.Insert();        end else            if ConfigPackageData.Value <> Value then begin                ConfigPackageData.Value := Value;                ConfigPackageData.Modify();            end;    end;    procedure InsertProcessingRule(var ConfigTableProcessingRule: Record "Config. Table Processing Rule"; ConfigPackageTable: Record "Config. Package Table"; RuleNo: Integer; NewAction: Option)    begin        ConfigTableProcessingRule.Validate("Package Code", ConfigPackageTable."Package Code");        ConfigTableProcessingRule.Validate("Table ID", ConfigPackageTable."Table ID");        ConfigTableProcessingRule.Validate("Rule No.", RuleNo);        ConfigTableProcessingRule.Validate(Action, NewAction);        ConfigTableProcessingRule.Insert(true);    end;    procedure InsertProcessingRuleCustom(var ConfigTableProcessingRule: Record "Config. Table Processing Rule"; ConfigPackageTable: Record "Config. Package Table"; RuleNo: Integer; CodeunitID: Integer)    begin        ConfigTableProcessingRule.Validate("Package Code", ConfigPackageTable."Package Code");        ConfigTableProcessingRule.Validate("Table ID", ConfigPackageTable."Table ID");        ConfigTableProcessingRule.Validate("Rule No.", RuleNo);        ConfigTableProcessingRule.Validate(Action, ConfigTableProcessingRule.Action::Custom);        ConfigTableProcessingRule.Validate("Custom Processing Codeunit ID", CodeunitID);        ConfigTableProcessingRule.Insert(true);    end;    procedure SetSkipTableTriggers(var ConfigPackageTable: Record "Config. Package Table"; PackageCode: Code[20]; TableID: Integer; Skip: Boolean)    begin        if ConfigPackageTable.Get(PackageCode, TableID) then begin            ConfigPackageTable.Validate("Skip Table Triggers", Skip);            ConfigPackageTable.Modify(true);        end;    end;    procedure GetNumberOfRecordsInserted(): Integer    begin        exit(RecordsInsertedCount);    end;    procedure GetNumberOfRecordsModified(): Integer    begin        exit(RecordsModifiedCount);    end;    local procedure InsertPrimaryKeyFields(var RecRef: RecordRef; ConfigPackageRecord: Record "Config. Package Record"; DoInsert: Boolean; var DelayedInsert: Boolean)    var        ConfigPackageData: Record "Config. Package Data";        ConfigPackageField: Record "Config. Package Field";        TempConfigPackageField: Record "Config. Package Field" temporary;        ConfigPackageError: Record "Config. Package Error";        RecRef1: RecordRef;        FieldRef: FieldRef;        IsHandled: Boolean;    begin        ConfigPackageData.SetRange("Package Code", ConfigPackageRecord."Package Code");        ConfigPackageData.SetRange("Table ID", ConfigPackageRecord."Table ID");        ConfigPackageData.SetRange("No.", ConfigPackageRecord."No.");        GetKeyFieldsOrder(RecRef, ConfigPackageRecord."Package Code", TempConfigPackageField);        GetFieldsMarkedAsPrimaryKey(ConfigPackageRecord."Package Code", RecRef.Number, TempConfigPackageField);        TempConfigPackageField.Reset();        TempConfigPackageField.SetCurrentKey("Package Code", "Table ID", "Processing Order");        TempConfigPackageField.FindSet();        repeat            FieldRef := RecRef.Field(TempConfigPackageField."Field ID");            ConfigPackageData.SetRange("Field ID", TempConfigPackageField."Field ID");            if ConfigPackageData.FindFirst() then begin                ConfigPackageField.Get(ConfigPackageData."Package Code", ConfigPackageData."Table ID", ConfigPackageData."Field ID");                IsHandled := false;                OnInsertPrimaryKeyFieldsOnBeforeUpdateValueUsingMapping(RecRef, ConfigPackageData, ConfigPackageField, ConfigPackageRecord, IsHandled);                if not IsHandled then                    UpdateValueUsingMapping(ConfigPackageData, ConfigPackageField, ConfigPackageRecord."Package Code");                ValidationFieldID := FieldRef.Number;                ConfigValidateMgt.EvaluateTextToFieldRef(                  ConfigPackageData.Value, FieldRef, ConfigPackageField."Validate Field" and (ApplyMode = ApplyMode::PrimaryKey));            end else                Error(KeyFieldValueMissingErr, FieldRef.Name, RecRef.Name, ConfigPackageData."No.");        until TempConfigPackageField.Next() = 0;        RecRef1 := RecRef.Duplicate();        if RecRef1.Find() then begin            RecRef := RecRef1;            exit        end;        if ((ConfigPackageRecord."Package Code" = QBPackageCodeTxt) or (ConfigPackageRecord."Package Code" = MSGPPackageCodeTxt)) and           (ConfigPackageRecord."Table ID" = 15)        then            if ConfigPackageError.Get(                 ConfigPackageRecord."Package Code", ConfigPackageRecord."Table ID", ConfigPackageRecord."No.", 1)            then                exit;        if DelayedInsert then            exit;        if DoInsert then begin            DelayedInsert := InsertRecord(RecRef, ConfigPackageRecord);            RecordsInsertedCount += 1;        end else            DelayedInsert := false;    end;    local procedure UpdateKeyInfoForConfigPackageRecord(RecRef: RecordRef; ConfigPackageRecord: Record "Config. Package Record")    var        ConfigPackageData: Record "Config. Package Data";        FieldRef: FieldRef;        KeyRef: KeyRef;        KeyFieldCount: Integer;    begin        KeyRef := RecRef.KeyIndex(1);        for KeyFieldCount := 1 to KeyRef.FieldCount do begin            FieldRef := KeyRef.FieldIndex(KeyFieldCount);            ConfigPackageData.Get(              ConfigPackageRecord."Package Code", ConfigPackageRecord."Table ID", ConfigPackageRecord."No.", FieldRef.Number);            ConfigPackageData.Value := Format(FieldRef.Value);            ConfigPackageData.Modify();        end;    end;    procedure InitPackageRecord(var ConfigPackageRecord: Record "Config. Package Record"; PackageCode: Code[20]; TableID: Integer)    var        NextNo: Integer;    begin        ConfigPackageRecord.Reset();        ConfigPackageRecord.SetRange("Package Code", PackageCode);        ConfigPackageRecord.SetRange("Table ID", TableID);        if ConfigPackageRecord.FindLast() then            NextNo := ConfigPackageRecord."No." + 1        else            NextNo := 1;        ConfigPackageRecord.Init();        ConfigPackageRecord."Package Code" := PackageCode;        ConfigPackageRecord."Table ID" := TableID;        ConfigPackageRecord."No." := NextNo;        ConfigPackageRecord.Insert();    end;    local procedure InsertRecord(var RecRef: RecordRef; ConfigPackageRecord: Record "Config. Package Record"): Boolean    var        ConfigPackageTable: Record "Config. Package Table";        ConfigInsertWithValidation: Codeunit "Config. Insert With Validation";        IsHandled: Boolean;    begin        ConfigPackageTable.Get(ConfigPackageRecord."Package Code", ConfigPackageRecord."Table ID");        if ConfigPackageTable."Skip Table Triggers" then begin            IsHandled := false;            OnInsertRecordOnBeforeInsertRecRef(RecRef, ConfigPackageRecord, IsHandled);            if not IsHandled then                RecRef.Insert();        end else begin            Commit();            ConfigInsertWithValidation.SetInsertParameters(RecRef);            if not ConfigInsertWithValidation.Run() then begin                ClearLastError();                exit(true);            end;        end;        exit(false);    end;    local procedure ModifyRecordDataFields(var RecRef: RecordRef; ConfigPackageRecord: Record "Config. Package Record"; DoModify: Boolean; DelayedInsert: Boolean)    var        ConfigPackageData: Record "Config. Package Data";        ConfigPackageField: Record "Config. Package Field";        ConfigQuestion: Record "Config. Question";        "Field": Record "Field";        ConfigPackageTable: Record "Config. Package Table";        ConfigPackageError: Record "Config. Package Error";        ConfigQuestionnaireMgt: Codeunit "Questionnaire Management";        IsHandled: Boolean;    begin        OnBeforeModifyRecordDataFields(RecRef, ConfigPackageRecord, DoModify, DelayedInsert);        ConfigPackageField.Reset();        ConfigPackageField.SetCurrentKey("Package Code", "Table ID", "Processing Order");        ConfigPackageField.SetRange("Package Code", ConfigPackageRecord."Package Code");        ConfigPackageField.SetRange("Table ID", ConfigPackageRecord."Table ID");        ConfigPackageField.SetRange("Include Field", true);        ConfigPackageField.SetRange(Dimension, false);        ConfigPackageTable.Get(ConfigPackageRecord."Package Code", ConfigPackageRecord."Table ID");        if DoModify or DelayedInsert then            ApplyTemplate(ConfigPackageTable, RecRef);        OnModifyRecordDataFieldsOnBeforeFindConfigPackageField(ConfigPackageField, ConfigPackageRecord, RecRef, DoModify, DelayedInsert);        if ConfigPackageField.FindSet() then            repeat                ValidationFieldID := ConfigPackageField."Field ID";                if ((ConfigPackageRecord."Package Code" = QBPackageCodeTxt) or (ConfigPackageRecord."Package Code" = MSGPPackageCodeTxt)) and                   ((ConfigPackageRecord."Table ID" = 15) or (ConfigPackageRecord."Table ID" = 18) or                    (ConfigPackageRecord."Table ID" = 23) or (ConfigPackageRecord."Table ID" = 27))                then                    if ConfigPackageError.Get(                         ConfigPackageRecord."Package Code", ConfigPackageRecord."Table ID", ConfigPackageRecord."No.", 1)                    then                        exit;                ModifyRecordDataField(                  ConfigPackageRecord, ConfigPackageField, ConfigPackageData, ConfigPackageTable, RecRef, DoModify, DelayedInsert, true);            until ConfigPackageField.Next() = 0;        if not DoModify then            exit;        if not RecRef.IsDirty() then            exit;        if DelayedInsert then begin            IsHandled := false;            OnModifyRecordDataFieldsOnBeforeRecRefInsert(RecRef, ConfigPackageTable, IsHandled, ConfigPackageRecord);            if not IsHandled then                RecRef.Insert(true);        end else begin            IsHandled := false;            OnModifyRecordDataFieldsOnBeforeRecRefModify(RecRef, ConfigPackageTable, RecordsModifiedCount, IsHandled, ConfigPackageRecord);            if not IsHandled then                RecRef.Modify(not ConfigPackageTable."Skip Table Triggers");            OnModifyRecordDataFieldsOnAfterRecRefModify(RecRef);            RecordsModifiedCount += 1;        end;        OnModifyRecordDataFieldsOnAfterRecRefUpdated(RecRef);        if RecRef.Number = Database::"Config. Question" then begin            RecRef.SetTable(ConfigQuestion);            SetFieldFilter(Field, ConfigQuestion."Table ID", ConfigQuestion."Field ID");            if Field.FindFirst() then                ConfigQuestionnaireMgt.ModifyConfigQuestionAnswer(ConfigQuestion, Field);        end;    end;    local procedure ModifyRecordDataField(var ConfigPackageRecord: Record "Config. Package Record"; var ConfigPackageField: Record "Config. Package Field"; var ConfigPackageData: Record "Config. Package Data"; var ConfigPackageTable: Record "Config. Package Table"; var RecRef: RecordRef; DoModify: Boolean; DelayInsert: Boolean; ReadConfigPackageData: Boolean)    var        FieldRef: FieldRef;        IsTemplate: Boolean;        SkipEvaluate: Boolean;        IsHandled: Boolean;    begin        if ConfigPackageField."Primary Key" or ConfigPackageField.AutoIncrement then            exit;        if ReadConfigPackageData then            if not ConfigPackageData.Get(                 ConfigPackageRecord."Package Code", ConfigPackageRecord."Table ID", ConfigPackageRecord."No.", ConfigPackageField."Field ID")            then                exit;        IsTemplate := IsTemplateField(ConfigPackageTable."Data Template", ConfigPackageField."Field ID");        if not IsTemplate or (IsTemplate and (ConfigPackageData.Value <> '')) then begin            FieldRef := RecRef.Field(ConfigPackageField."Field ID");            IsHandled := false;            OnModifyRecordDataFieldOnBeforeUpdateValueUsingMapping(ConfigPackageData, ConfigPackageField, ConfigPackageRecord, RecRef, IsHandled);            if not IsHandled then                UpdateValueUsingMapping(ConfigPackageData, ConfigPackageField, ConfigPackageRecord."Package Code");            GetCachedConfigPackageField(ConfigPackageData);            IsHandled := false;            OnModifyRecordDataFieldOnAfterGetCachedConfigPackageField(RecRef, FieldRef, ConfigPackageField, ConfigPackageData, IsHandled);            if not IsHandled then                case true of                    IsBLOBFieldInternal(TempConfigPackageFieldCache."Processing Order"):                        EvaluateBLOBToFieldRef(ConfigPackageData, FieldRef);                    IsMediaSetFieldInternal(TempConfigPackageFieldCache."Processing Order"):                        ImportMediaSetFiles(ConfigPackageData, FieldRef, DoModify);                    IsMediaFieldInternal(TempConfigPackageFieldCache."Processing Order"):                        ImportMediaFiles(ConfigPackageData, FieldRef, DoModify);                    else begin                        SkipEvaluate := false;                        OnModifyRecordDataFieldOnBeforeEvaluateTextToFieldRef(ConfigPackageField, ConfigPackageData, ConfigPackageTable, DelayInsert, ApplyMode, FieldRef, SkipEvaluate);                        if not SkipEvaluate then                            ConfigValidateMgt.EvaluateTextToFieldRef(ConfigPackageData.Value, FieldRef, ConfigPackageField."Validate Field" and ((ApplyMode = ApplyMode::NonKeyFields) or DelayInsert));                    end;                end;        end;    end;    procedure RemoveRecordsWithObsoleteTableID(TableID: Integer; TableIDFieldNo: Integer)    var        TableMetadata: Record "Table Metadata";        RecRef: RecordRef;        FieldRef: FieldRef;    begin        RecRef.Open(TableID);        FieldRef := RecRef.Field(TableIDFieldNo);        TableMetadata.SetRange(ObsoleteState, TableMetadata.ObsoleteState::Removed);        if TableMetadata.FindSet() then            repeat                FieldRef.SetRange(TableMetadata.ID);                if not RecRef.IsEmpty() then                    RecRef.DeleteAll(true);            until TableMetadata.Next() = 0;        RecRef.Close();    end;    local procedure ApplyTemplate(ConfigPackageTable: Record "Config. Package Table"; var RecRef: RecordRef)    var        ConfigTemplateHeader: Record "Config. Template Header";        ConfigTemplateMgt: Codeunit "Config. Template Management";    begin        if ConfigTemplateHeader.Get(ConfigPackageTable."Data Template") then begin            ConfigTemplateMgt.UpdateRecord(ConfigTemplateHeader, RecRef);            InsertDimensionsFromTemplates(ConfigPackageTable."Table ID", ConfigTemplateHeader, RecRef);        end;    end;    local procedure InsertDimensionsFromTemplates(TableID: Integer; ConfigTemplateHeader: Record "Config. Template Header"; var RecRef: RecordRef)    var        DimensionsTemplate: Record "Dimensions Template";        FieldRef: FieldRef;        KeyRef: KeyRef;    begin        KeyRef := RecRef.KeyIndex(1);        if KeyRef.FieldCount = 1 then begin            FieldRef := KeyRef.FieldIndex(1);            if Format(FieldRef.Value) <> '' then                DimensionsTemplate.InsertDimensionsFromTemplates(                  ConfigTemplateHeader, Format(FieldRef.Value), TableID);        end;    end;    local procedure IsTemplateField(TemplateCode: Code[20]; FieldNo: Integer): Boolean    var        ConfigTemplateHeader: Record "Config. Template Header";        ConfigTemplateLine: Record "Config. Template Line";    begin        if TemplateCode = '' then            exit(false);        if not ConfigTemplateHeader.Get(TemplateCode) then            exit(false);        ConfigTemplateLine.SetRange("Data Template Code", ConfigTemplateHeader.Code);        ConfigTemplateLine.SetRange("Field ID", FieldNo);        ConfigTemplateLine.SetRange(Type, ConfigTemplateLine.Type::Field);        if not ConfigTemplateLine.IsEmpty() then            exit(true);        ConfigTemplateLine.SetRange("Field ID");        ConfigTemplateLine.SetRange(Type, ConfigTemplateLine.Type::Template);        if ConfigTemplateLine.FindSet() then            repeat                if IsTemplateField(ConfigTemplateLine."Template Code", FieldNo) then                    exit(true);            until ConfigTemplateLine.Next() = 0;        exit(false);    end;    procedure ValidatePackageRelations(var ConfigPackageTable: Record "Config. Package Table"; var TempConfigPackageTable: Record "Config. Package Table" temporary; SetupProcessingOrderForTables: Boolean)    var        TableCount: Integer;    begin        if SetupProcessingOrderForTables then            SetupProcessingOrder(ConfigPackageTable);        TableCount := ConfigPackageTable.Count;        if not HideDialog then            ConfigProgressBar.Init(TableCount, 1, ValidatingTableRelationsMsg);        ConfigPackageTable.ModifyAll(Validated, false);        ConfigPackageTable.SetCurrentKey("Package Processing Order", "Processing Order");        if ConfigPackageTable.FindSet() then            repeat                ConfigPackageTable.CalcFields("Table Name");                if not HideDialog then                    ConfigProgressBar.Update(ConfigPackageTable."Table Name");                ValidateTableRelation(ConfigPackageTable."Package Code", ConfigPackageTable."Table ID", TempConfigPackageTable);                TempConfigPackageTable.Init();                TempConfigPackageTable."Package Code" := ConfigPackageTable."Package Code";                TempConfigPackageTable."Table ID" := ConfigPackageTable."Table ID";                TempConfigPackageTable.Insert();                ConfigPackageTable.Validated := true;                ConfigPackageTable.Modify();            until ConfigPackageTable.Next() = 0;        if not HideDialog then            ConfigProgressBar.Close();        if not HideDialog then            Message(NoTablesMsg, TableCount);    end;    local procedure ValidateTableRelation(PackageCode: Code[20]; TableId: Integer; var ValidatedConfigPackageTable: Record "Config. Package Table")    var        ConfigPackageField: Record "Config. Package Field";        ConfigPackageRecord: Record "Config. Package Record";        RecRef: RecordRef;        DelayedInsert: Boolean;    begin        ConfigPackageRecord.SetRange("Package Code", PackageCode);        ConfigPackageRecord.SetRange("Table ID", TableId);        if ConfigPackageRecord.FindSet() then            repeat                Clear(RecRef);                RecRef.Open(TableId, true);                InsertPrimaryKeyFields(RecRef, ConfigPackageRecord, false, DelayedInsert);                ConfigPackageField.SetCurrentKey("Package Code", "Table ID", "Processing Order");                ConfigPackageField.SetRange("Package Code", PackageCode);                ConfigPackageField.SetRange("Table ID", TableId);                ConfigPackageField.SetRange("Validate Field", true);                if ConfigPackageField.FindSet() then                    repeat                        ValidateFieldRelationInRecord(ConfigPackageField, ValidatedConfigPackageTable, ConfigPackageRecord, RecRef);                    until ConfigPackageField.Next() = 0;                RecRef.Close();            until ConfigPackageRecord.Next() = 0;    end;    procedure ValidateFieldRelationInRecord(ConfigPackageField: Record "Config. Package Field"; var ValidatedConfigPackageTable: Record "Config. Package Table"; ConfigPackageRecord: Record "Config. Package Record"; RecRef: RecordRef) NoValidateErrors: Boolean    var        ConfigPackageData: Record "Config. Package Data";    begin        NoValidateErrors := true;        ConfigPackageData.SetRange("Package Code", ConfigPackageField."Package Code");        ConfigPackageData.SetRange("Table ID", ConfigPackageField."Table ID");        ConfigPackageData.SetRange("Field ID", ConfigPackageField."Field ID");        ConfigPackageData.SetRange("No.", ConfigPackageRecord."No.");        if ConfigPackageData.FindSet() then            repeat                NoValidateErrors :=                  NoValidateErrors and                  ValidatePackageDataRelation(                    ConfigPackageData, ValidatedConfigPackageTable, ConfigPackageField, true, ConfigPackageRecord, RecRef);            until ConfigPackageData.Next() = 0;    end;    [Scope('OnPrem')]    procedure ValidateSinglePackageDataRelation(var ConfigPackageData: Record "Config. Package Data"): Boolean    var        TempConfigPackageTable: Record "Config. Package Table" temporary;        ConfigPackageField: Record "Config. Package Field";        ConfigPackageRecord: Record "Config. Package Record";        RecRef: RecordRef;        DelayedInsert: Boolean;    begin        RecRef.Open(ConfigPackageData."Table ID", true);        ConfigPackageRecord.Get(ConfigPackageData."Package Code", ConfigPackageData."Table ID", ConfigPackageData."No.");        InsertPrimaryKeyFields(RecRef, ConfigPackageRecord, false, DelayedInsert);        ConfigPackageField.Get(ConfigPackageData."Package Code", ConfigPackageData."Table ID", ConfigPackageData."Field ID");        exit(ValidatePackageDataRelation(ConfigPackageData, TempConfigPackageTable, ConfigPackageField, false, ConfigPackageRecord, RecRef));    end;    local procedure ValidatePackageDataRelation(var ConfigPackageData: Record "Config. Package Data"; var ValidatedConfigPackageTable: Record "Config. Package Table"; var ConfigPackageField: Record "Config. Package Field"; GenerateFieldError: Boolean; ConfigPackageRecord: Record "Config. Package Record"; RecRef: RecordRef): Boolean    var        ErrorText: Text[250];        RelationTableNo: Integer;        RelationFieldNo: Integer;        DataInPackageData: Boolean;    begin        if Format(ConfigPackageData.Value) <> '' then begin            DataInPackageData := false;            if GetRelationInfo(ConfigPackageField, RecRef, RelationTableNo, RelationFieldNo) then                DataInPackageData :=                  ValidateFieldRelationAgainstPackageData(                    ConfigPackageData, ValidatedConfigPackageTable, RelationTableNo, RelationFieldNo);            OnAfterValidatePackageDataRelation(              ConfigPackageData, ConfigPackageField, ValidatedConfigPackageTable, RelationTableNo, RelationFieldNo, DataInPackageData);            if not DataInPackageData then begin                ErrorText := ValidateFieldRelationAgainstCompanyData(ConfigPackageData, ConfigPackageRecord, RecRef);                if ErrorText <> '' then begin                    if GenerateFieldError then                        FieldError(ConfigPackageData, ErrorText, ErrorTypeEnum::TableRelation);                    exit(false);                end;            end;        end;        if PackageErrorsExists(ConfigPackageData, ErrorTypeEnum::TableRelation) then            CleanFieldError(ConfigPackageData);        exit(true);    end;    procedure ValidateException(TableID: Integer; FieldID: Integer) Result: Boolean    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeValidateException(TableID, FieldID, Result, IsHandled);        if IsHandled then            exit(Result);        case TableID of            // Dimension Value ID: ERROR message            Database::"Dimension Value":                exit(FieldID = 12);            // Default Dimension: multi-relations            Database::"Default Dimension":                exit(FieldID = 2);            // VAT %: CheckVATIdentifier            Database::Microsoft.Finance.VAT.Setup."VAT Posting Setup":                exit(FieldID = 4);            // Table ID - OnValidate            Database::"Config. Template Header":                exit(FieldID = 3);            // Field ID relation            Database::"Config. Template Line":                exit(FieldID in [4, 8, 12]);            // Dimensions as Columns            Database::"Config. Line":                exit(FieldID = 12);            // Customer : Contact OnValidate            Database::Microsoft.Sales.Customer.Customer:                exit(FieldID = 8);            // Vendor : Contact OnValidate            Database::Microsoft.Purchases.Vendor.Vendor:                exit(FieldID = 8);            // Item : Base Unit of Measure, Production BOM No. OnValidate            Database::Microsoft.Inventory.Item.Item:                exit(FieldID in [8, 99000751]);            // "No." to pass not manual No. Series            Database::Microsoft.Sales.Document."Sales Header", Database::Microsoft.Purchases.Document."Purchase Header":                exit(FieldID = 3);            // "Document No." conditional relation            Database::Microsoft.Sales.Document."Sales Line", Database::Microsoft.Purchases.Document."Purchase Line":                exit(FieldID = 3);            // "Code"/"City" fields of Post Code record            Database::Microsoft.Foundation.Address."Post Code":                exit(FieldID in [1, 2]);        end;        exit(false);    end;    internal procedure ShowWarningOnImportingBigConfPackageFromExcel(FileSize: Integer): Action    begin        exit(ShowWarningOnImportingBigConfPackage(FileSize, 'Excel'));    end;    internal procedure ShowWarningOnImportingBigConfPackageFromRapidStart(FileSize: Integer): Action    begin        exit(ShowWarningOnImportingBigConfPackage(FileSize, 'RapidStart'));    end;    local procedure ShowWarningOnImportingBigConfPackage(FileSize: Integer; ImportingThrough: Text): Action    var        EnvironmentInformation: Codeunit "Environment Information";        ConfigPackageWarning: Page "Config. Package Warning";        BigFileSize: Integer;    begin        if not EnvironmentInformation.IsSaaS() then            exit(Action::OK);        BigFileSize := 3145728; // 3 MBytes        if FileSize > BigFileSize then begin            Session.LogMessage('0000BV2', StrSubstNo(UsingBigRSPackageTxt, 'Import ' + ImportingThrough, 'FileSize: ' + Format(FileSize)), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', RapidStartTxt);            ConfigPackageWarning.SwitchContextToImport();            ConfigPackageWarning.RunModal();            if ConfigPackageWarning.GetAction() = Action::OK then                Session.LogMessage('0000BV3', StrSubstNo(AcknowledgePerformanceImpactTxt, 'Import ' + ImportingThrough), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', RapidStartTxt);            exit(ConfigPackageWarning.GetAction());        end;        exit(Action::OK);    end;    internal procedure ShowWarningOnApplyingBigConfPackage(RecordCount: Integer): Action    var        EnvironmentInformation: Codeunit "Environment Information";        ConfigPackageWarning: Page "Config. Package Warning";        RecordCountLimit: Integer;    begin        if not EnvironmentInformation.IsSaaS() then            exit(Action::OK);        RecordCountLimit := 5000;        if RecordCount > RecordCountLimit then begin            Session.LogMessage('0000BVJ', StrSubstNo(UsingBigRSPackageTxt, 'Apply Package', 'Records: ' + Format(RecordCount)), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', RapidStartTxt);            ConfigPackageWarning.SwitchContextToApply();            ConfigPackageWarning.RunModal();            if ConfigPackageWarning.GetAction() = Action::OK then                Session.LogMessage('0000BVK', StrSubstNo(AcknowledgePerformanceImpactTxt, 'Apply Package'), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', RapidStartTxt);            exit(ConfigPackageWarning.GetAction());        end;        exit(Action::OK);    end;    internal procedure SentPackageImportedNotification(ConfigPackageCode: Code[20])    var        MyNotifications: Record "My Notifications";        PackageImportedNotification: Notification;    begin        if not GuiAllowed() then            exit;        if not MyNotifications.IsEnabled(GetPackageImportedNotificationId()) then            exit;        PackageImportedNotification.Id := GetPackageImportedNotificationId();        PackageImportedNotification.Message(StrSubstNo(PackageImportedNotificationTxt, ConfigPackageCode));        PackageImportedNotification.SetData('PackageCode', ConfigPackageCode);        PackageImportedNotification.Scope(NotificationScope::LocalScope);        PackageImportedNotification.AddAction(ApplyPackageLbl, Codeunit::"Config. Package Management", 'ApplyPackageFromNotification');        PackageImportedNotification.AddAction(DisableNotificationLbl, Codeunit::"Config. Package Management", 'DisableNotification');        PackageImportedNotification.Send();    end;    local procedure GetPackageImportedNotificationId(): Guid    begin        exit('bf856162-cfac-4b73-94b5-ea744bc531a2');    end;    internal procedure ApplyPackageFromNotification(var PackageImportedNotification: Notification)    var        ConfigPackageTable: Record "Config. Package Table";        ConfigPackage: Record "Config. Package";        ConfigPackageMgt: Codeunit "Config. Package Management";        PackageCode: Code[20];    begin        PackageCode := CopyStr(PackageImportedNotification.GetData('PackageCode'), 1, MaxStrLen(PackageCode));        if not ConfigPackage.Get(PackageCode) then            exit;        ConfigPackageTable.SetRange("Package Code", PackageCode);        ConfigPackageMgt.ApplyPackage(ConfigPackage, ConfigPackageTable, true);    end;    internal procedure DisableNotification(var PackageImportedNotification: Notification)    var        MyNotifications: Record "My Notifications";    begin        MyNotifications.InsertDefault(PackageImportedNotification.Id, PackagageImportedNotificationNameLbl, PackagageImportedNotificationDescriptionLbl, false);        MyNotifications.Disable(PackageImportedNotification.Id)    end;    internal procedure ShowRapidStartNotification()    var        EnvironmentInformation: Codeunit "Environment Information";        RSNotificaiton: Notification;    begin        if not EnvironmentInformation.IsSaaS() then            exit;        if not IsExistingCompany() then            exit;        RSNotificaiton.Message(RSNotificaitonMsg);        RSNotificaiton.AddAction(LearnMoreTok, Codeunit::"Config. Package Management", 'LearnMoreNotificationAction');        RSNotificaiton.Send();    end;    internal procedure LearnMoreNotificationAction(var Notification: Notification)    begin        HyperLink(RapidStartDocumentationUrlTxt);    end;    local procedure IsExistingCompany(): Boolean    var        CompanyInformation: Record "Company Information";        ThreeMonths: Duration;    begin        if not CompanyInformation.Get() then            exit(false);        if CompanyInformation."Created DateTime" = 0DT then            exit(false);        ThreeMonths := CreateDateTime(CalcDate('<+3M>', Today()), Time()) - CurrentDateTime();        exit(CurrentDateTime() - CompanyInformation."Created DateTime" > ThreeMonths);    end;    procedure IsDimSetIDField(TableId: Integer; FieldId: Integer): Boolean    var        DimensionValue: Record "Dimension Value";    begin        exit((TableId = Database::"Dimension Value") and (DimensionValue.FieldNo("Dimension Value ID") = FieldId));    end;    local procedure GetRelationInfo(ConfigPackageField: Record "Config. Package Field"; RecRef: RecordRef; var RelationTableNo: Integer; var RelationFieldNo: Integer): Boolean    var        CommentLine: Record "Comment Line";        TableRelationsMetadata: Record "Table Relations Metadata";        RelatedRecRef: RecordRef;        FieldRef: FieldRef;        RelatedFieldRef: FieldRef;        RelatedKeyRef: KeyRef;    begin        if (ConfigPackageField."Table ID" = Database::"Comment Line") and           (ConfigPackageField."Field ID" = CommentLine.FieldNo("No."))        then begin            // Resolve the parent from this record's Table Name, not the static field metadata.            FieldRef := RecRef.Field(ConfigPackageField."Field ID");            RelationTableNo := FieldRef.Relation();            if RelationTableNo = 0 then                exit(false);            TableRelationsMetadata.SetRange("Table ID", ConfigPackageField."Table ID");            TableRelationsMetadata.SetRange("Field No.", ConfigPackageField."Field ID");            TableRelationsMetadata.SetRange("Related Table ID", RelationTableNo);            if not TableRelationsMetadata.FindFirst() then                exit(false);            RelationFieldNo := TableRelationsMetadata."Related Field No.";            TableRelationsMetadata.SetFilter("Related Field No.", '<>%1', RelationFieldNo);            if not TableRelationsMetadata.IsEmpty() then                exit(false);            RelatedRecRef.Open(RelationTableNo);            if RelationFieldNo <> 0 then                RelatedFieldRef := RelatedRecRef.Field(RelationFieldNo)            else begin                RelatedKeyRef := RelatedRecRef.KeyIndex(1);                if RelatedKeyRef.FieldCount <> 1 then                    exit(false);                RelatedFieldRef := RelatedKeyRef.FieldIndex(1);            end;            if (RelatedFieldRef.Type <> FieldRef.Type) or (RelatedFieldRef.Length <> FieldRef.Length) then                exit(false);            RelationFieldNo := RelatedFieldRef.Number;            exit(true);        end;        exit(          ConfigValidateMgt.GetRelationInfoByIDs(            ConfigPackageField."Table ID", ConfigPackageField."Field ID", RelationTableNo, RelationFieldNo));    end;    local procedure ValidateFieldRelationAgainstCompanyData(ConfigPackageData: Record "Config. Package Data"; ConfigPackageRecord: Record "Config. Package Record"; RecRef: RecordRef): Text[250]    var        ConfigPackageField: Record "Config. Package Field";        ConfigPackageTable: Record "Config. Package Table";        FieldRef: FieldRef;    begin        ConfigPackageField.Get(ConfigPackageData."Package Code", ConfigPackageData."Table ID", ConfigPackageData."Field ID");        ConfigPackageTable.Get(ConfigPackageData."Package Code", ConfigPackageData."Table ID");        ModifyRecordDataField(ConfigPackageRecord, ConfigPackageField, ConfigPackageData, ConfigPackageTable, RecRef, false, false, false);        FieldRef := RecRef.Field(ConfigPackageData."Field ID");        ConfigValidateMgt.EvaluateValue(FieldRef, ConfigPackageData.Value, false);        GetFieldsOrderInternal(RecRef, ConfigPackageRecord."Package Code");        exit(            ValidateFieldRefRelationAgainstCompanyDataAndPackage(                FieldRef, TempConfigPackageFieldOrdered, ConfigPackageRecord."Package Code"));    end;    procedure ValidateFieldRelationAgainstPackageData(ConfigPackageData: Record "Config. Package Data"; var ValidatedConfigPackageTable: Record "Config. Package Table"; RelationTableNo: Integer; RelationFieldNo: Integer): Boolean    var        RelatedConfigPackageData: Record "Config. Package Data";        ConfigPackageTable: Record "Config. Package Table";        TablePriority: Integer;    begin        if not ConfigPackageTable.Get(ConfigPackageData."Package Code", RelationTableNo) then            exit(false);        TablePriority := ConfigPackageTable."Processing Order";        if ConfigValidateMgt.IsRelationInKeyFields(ConfigPackageData."Table ID", ConfigPackageData."Field ID") then begin            ConfigPackageTable.Get(ConfigPackageData."Package Code", ConfigPackageData."Table ID");            if ConfigPackageTable."Processing Order" < TablePriority then                exit(false);            // That current order will be for apply data            ValidatedConfigPackageTable.Reset();            ValidatedConfigPackageTable.SetRange("Table ID", RelationTableNo);            if ValidatedConfigPackageTable.IsEmpty() then                exit(false);        end;        RelatedConfigPackageData.SetRange("Package Code", ConfigPackageData."Package Code");        RelatedConfigPackageData.SetRange("Table ID", RelationTableNo);        RelatedConfigPackageData.SetRange("Field ID", RelationFieldNo);        RelatedConfigPackageData.SetRange(Value, ConfigPackageData.Value);        exit(not RelatedConfigPackageData.IsEmpty);    end;    procedure RecordError(var ConfigPackageRecord: Record "Config. Package Record"; ValidationFieldID: Integer; ErrorText: Text[250])    var        ConfigPackageError: Record "Config. Package Error";        ConfigPackageData: Record "Config. Package Data";        RecordID: RecordID;    begin        if ErrorText = '' then            exit;        ConfigPackageError.Init();        ConfigPackageError."Package Code" := ConfigPackageRecord."Package Code";        ConfigPackageError."Table ID" := ConfigPackageRecord."Table ID";        ConfigPackageError."Record No." := ConfigPackageRecord."No.";        ConfigPackageError."Field ID" := ValidationFieldID;        ConfigPackageError."Error Text" := ErrorText;        ConfigPackageData.SetRange("Package Code", ConfigPackageRecord."Package Code");        ConfigPackageData.SetRange("Table ID", ConfigPackageRecord."Table ID");        ConfigPackageData.SetRange("No.", ConfigPackageRecord."No.");        if Evaluate(RecordID, GetRecordIDOfRecordError(ConfigPackageData)) then            ConfigPackageError."Record ID" := RecordID;        if not ConfigPackageError.Insert() then            ConfigPackageError.Modify();        ConfigPackageRecord.Invalid := true;        ConfigPackageRecord.Modify();    end;    procedure FieldError(var ConfigPackageData: Record "Config. Package Data"; ErrorText: Text[250]; ErrorType: Option ,TableRelation)    var        ConfigPackageRecord: Record "Config. Package Record";        ConfigPackageError: Record "Config. Package Error";        ConfigPackageData2: Record "Config. Package Data";        RecordID: RecordID;    begin        if ErrorText = '' then            exit;        ConfigPackageError.Init();        ConfigPackageError."Package Code" := ConfigPackageData."Package Code";        ConfigPackageError."Table ID" := ConfigPackageData."Table ID";        ConfigPackageError."Record No." := ConfigPackageData."No.";        ConfigPackageError."Field ID" := ConfigPackageData."Field ID";        ConfigPackageError."Error Text" := ErrorText;        ConfigPackageError."Error Type" := ErrorType;        ConfigPackageData2.SetRange("Package Code", ConfigPackageData."Package Code");        ConfigPackageData2.SetRange("Table ID", ConfigPackageData."Table ID");        ConfigPackageData2.SetRange("No.", ConfigPackageData."No.");        if Evaluate(RecordID, GetRecordIDOfRecordError(ConfigPackageData2)) then            ConfigPackageError."Record ID" := RecordID;        if not ConfigPackageError.Insert() then            ConfigPackageError.Modify();        ConfigPackageData.Invalid := true;        ConfigPackageData.Modify();        ConfigPackageRecord.Get(ConfigPackageData."Package Code", ConfigPackageData."Table ID", ConfigPackageData."No.");        ConfigPackageRecord.Invalid := true;        ConfigPackageRecord.Modify();    end;    procedure CleanRecordError(var ConfigPackageRecord: Record "Config. Package Record")    var        ConfigPackageError: Record "Config. Package Error";    begin        ConfigPackageError.SetRange("Package Code", ConfigPackageRecord."Package Code");        ConfigPackageError.SetRange("Table ID", ConfigPackageRecord."Table ID");        ConfigPackageError.SetRange("Record No.", ConfigPackageRecord."No.");        ConfigPackageError.DeleteAll();    end;    procedure CleanFieldError(var ConfigPackageData: Record "Config. Package Data")    var        ConfigPackageError: Record "Config. Package Error";        ConfigPackageRecord: Record "Config. Package Record";        HasError: Boolean;    begin        if ConfigPackageError.Get(ConfigPackageData."Package Code", ConfigPackageData."Table ID", ConfigPackageData."No.", ConfigPackageData."Field ID") then begin            ConfigPackageError.Delete();            ConfigPackageData.Invalid := false;            ConfigPackageData.Modify();            ConfigPackageRecord.Get(ConfigPackageData."Package Code", ConfigPackageData."Table ID", ConfigPackageData."No.");            HasError := IsRecordErrorsExists(ConfigPackageRecord);            if ConfigPackageRecord.Invalid <> HasError then begin                ConfigPackageRecord.Invalid := HasError;                ConfigPackageRecord.Modify();            end;        end;    end;    procedure CleanPackageErrors(PackageCode: Code[20]; TableFilter: Text)    var        ConfigPackageError: Record "Config. Package Error";    begin        ConfigPackageError.SetRange("Package Code", PackageCode);        if TableFilter <> '' then            ConfigPackageError.SetFilter("Table ID", TableFilter);        ConfigPackageError.DeleteAll();    end;    local procedure PackageErrorsExists(ConfigPackageData: Record "Config. Package Data"; ErrorType: Option General,TableRelation): Boolean    var        ConfigPackageError: Record "Config. Package Error";    begin        if not ConfigPackageError.Get(             ConfigPackageData."Package Code", ConfigPackageData."Table ID", ConfigPackageData."No.", ConfigPackageData."Field ID")        then            exit(false);        if ConfigPackageError."Error Type" = ErrorType then            exit(true);        exit(false)    end;    procedure GetValidationFieldID(): Integer    begin        exit(ValidationFieldID);    end;    procedure ApplyConfigLines(var ConfigLine: Record "Config. Line")    var        ConfigPackage: Record "Config. Package";        ConfigPackageTable: Record "Config. Package Table";        ConfigMgt: Codeunit "Config. Management";        "Filter": Text;    begin        ConfigLine.FindFirst();        ConfigPackage.Get(ConfigLine."Package Code");        ConfigPackageTable.SetRange("Package Code", ConfigLine."Package Code");        Filter := ConfigMgt.MakeTableFilter(ConfigLine, false);        if Filter = '' then            exit;        ConfigPackageTable.SetFilter("Table ID", Filter);        ApplyPackage(ConfigPackage, ConfigPackageTable, true);    end;    procedure ApplyPackage(ConfigPackage: Record "Config. Package"; var ConfigPackageTable: Record "Config. Package Table"; SetupProcessingOrderForTables: Boolean) ErrorCount: Integer    var        DimSetEntry: Record "Dimension Set Entry";        ConfigPackageTableParent: Record "Config. Package Table";        LocalConfigPackageRecord: Record "Config. Package Record";        LocalConfigPackageField: Record "Config. Package Field";        FeatureTelemetry: Codeunit "Feature Telemetry";        DimensionsNotifications: Codeunit "Dimensions Notifications";        TableCount: Integer;        RSApplyDataStartMsg: Label 'Apply of data started.', Locked = true;        RSApplyDataFinishMsg: Label 'Apply of data finished. Error count: %1. Duration: %2 milliseconds. Total Records: %3. Total Fields: %4.', Locked = true;        DurationAsInt: BigInteger;        StartTime: DateTime;        DimSetIDUsed: Boolean;        RecordCount: Integer;        FieldCount: Integer;        ExecutionId: Guid;        Dimensions: Dictionary of [Text, Text];        IsHandled: Boolean;    begin        FeatureTelemetry.LogUptake('0000E3E', 'Configuration packages', Enum::"Feature Uptake Status"::"Used");        LocalConfigPackageRecord.SetRange("Package Code", ConfigPackage.Code);        RecordCount := LocalConfigPackageRecord.Count();        LocalConfigPackageField.SetRange("Package Code", ConfigPackage.code);        FieldCount := LocalConfigPackageField.Count();        if GuiAllowed() then begin            Commit();            if ShowWarningOnApplyingBigConfPackage(RecordCount) = Action::Cancel then                exit;            if not DimensionsNotifications.ConfirmPackageHasDimensionsWarning(ConfigPackage.Code) then                exit;        end;        StartTime := CurrentDateTime();        ExecutionId := CreateGuid();        Dimensions.Add('Category', RapidStartTxt);        Dimensions.Add('PackageCode', ConfigPackage.SystemId);        Dimensions.Add('ExecutionId', Format(ExecutionId, 0, 4));        Session.LogMessage('0000E3N', StrSubstNo(ConfigurationPackageApplyDataStartMsg, ConfigPackage.SystemId), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::All, Dimensions);        Session.LogMessage('00009Q8', RSApplyDataStartMsg, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', RapidStartTxt);        ConfigPackage.CalcFields("No. of Records", "No. of Errors");        TableCount := ConfigPackageTable.Count();        if (ConfigPackage.Code <> MSGPPackageCodeTxt) and (ConfigPackage.Code <> QBPackageCodeTxt) then            // Hold the error count for duplicate records.            ErrorCount := ConfigPackage."No. of Errors";        if (TableCount = 0) or (ConfigPackage."No. of Records" = 0) then            exit;        IsHandled := false;        OnApplyPackageOnBeforeCleanPackageErrors(ConfigPackage, IsHandled);        if not IsHandled then            if (ConfigPackage.Code <> MSGPPackageCodeTxt) and (ConfigPackage.Code <> QBPackageCodeTxt) then                // Skip this code to hold the error count for duplicate records.                CleanPackageErrors(ConfigPackage.Code, ConfigPackageTable.GetFilter("Table ID"));        if SetupProcessingOrderForTables then begin            SetupProcessingOrder(ConfigPackageTable);            Commit();        end;        DimSetIDUsed := false;        if ConfigPackageTable.FindSet() then            repeat                DimSetIDUsed := ConfigMgt.IsDimSetIDTable(ConfigPackageTable."Table ID");            until (ConfigPackageTable.Next() = 0) or DimSetIDUsed;        if DimSetIDUsed and not DimSetEntry.IsEmpty() then            UpdateDimSetIDValues(ConfigPackage);        if (ConfigPackage.Code <> MSGPPackageCodeTxt) and (ConfigPackage.Code <> QBPackageCodeTxt) then            DeleteAppliedPackageRecords(TempAppliedConfigPackageRecord); // Do not delete PackageRecords till transactions are created        Commit();        OnApplyPackageOnAfterCommit(ConfigPackageTable);        TempAppliedConfigPackageRecord.DeleteAll();        TempConfigRecordForProcessing.DeleteAll();        Clear(RecordsInsertedCount);        Clear(RecordsModifiedCount);        // Handle independent tables        ConfigPackageTable.SetRange("Parent Table ID", 0);        ApplyPackageTables(ConfigPackage, ConfigPackageTable, ApplyMode::PrimaryKey);        ApplyPackageTables(ConfigPackage, ConfigPackageTable, ApplyMode::NonKeyFields);        // Handle children tables        ConfigPackageTable.SetFilter("Parent Table ID", '>0');        if ConfigPackageTable.FindSet() then            repeat                ConfigPackageTableParent.Get(ConfigPackage.Code, ConfigPackageTable."Parent Table ID");                if ConfigPackageTableParent."Parent Table ID" = 0 then                    ConfigPackageTable.Mark(true);            until ConfigPackageTable.Next() = 0;        ConfigPackageTable.MarkedOnly(true);        ApplyPackageTables(ConfigPackage, ConfigPackageTable, ApplyMode::PrimaryKey);        ApplyPackageTables(ConfigPackage, ConfigPackageTable, ApplyMode::NonKeyFields);        // Handle grandchildren tables        ConfigPackageTable.ClearMarks();        ConfigPackageTable.MarkedOnly(false);        if ConfigPackageTable.FindSet() then            repeat                ConfigPackageTableParent.Get(ConfigPackage.Code, ConfigPackageTable."Parent Table ID");                if ConfigPackageTableParent."Parent Table ID" > 0 then                    ConfigPackageTable.Mark(true);            until ConfigPackageTable.Next() = 0;        ConfigPackageTable.MarkedOnly(true);        ApplyPackageTables(ConfigPackage, ConfigPackageTable, ApplyMode::PrimaryKey);        ApplyPackageTables(ConfigPackage, ConfigPackageTable, ApplyMode::NonKeyFields);        ProcessAppliedPackageRecords(TempConfigRecordForProcessing, TempAppliedConfigPackageRecord);        if (ConfigPackage.Code <> MSGPPackageCodeTxt) and (ConfigPackage.Code <> QBPackageCodeTxt) then            DeleteAppliedPackageRecords(TempAppliedConfigPackageRecord); // Do not delete PackageRecords till transactions are created        ConfigPackage.CalcFields("No. of Errors");        ErrorCount := ConfigPackage."No. of Errors" - ErrorCount;        if ErrorCount < 0 then            ErrorCount := 0;        RecordsModifiedCount := MaxInt(RecordsModifiedCount - RecordsInsertedCount, 0);        DurationAsInt := CurrentDateTime() - StartTime;        Dimensions.Add('ErrorCount', Format(ErrorCount));        Dimensions.Add('ExecutionTimeInMs', Format(DurationAsInt));        Dimensions.Add('RecordCount', Format(RecordCount));        Dimensions.Add('FieldCount', Format(FieldCount));        Session.LogMessage('0000E3O', StrSubstNo(ConfigurationPackageApplyDataFinishMsg, ConfigPackage.SystemId), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::All, Dimensions);        // Tag used for analytics        Session.LogMessage('00009Q9', StrSubstNo(RSApplyDataFinishMsg, ErrorCount, DurationAsInt, RecordCount, FieldCount), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', RapidStartTxt);        FeatureTelemetry.LogUsage('0000E3B', 'Configuration packages', 'Package applied');        if not HideDialog then            Message(NoTablesAndErrorsMsg, TableCount, ErrorCount, RecordsInsertedCount, RecordsModifiedCount);    end;    local procedure ApplyPackageTables(ConfigPackage: Record "Config. Package"; var ConfigPackageTable: Record "Config. Package Table"; ApplyMode: Option ,PrimaryKey,NonKeyFields)    var        ConfigPackageRecord: Record "Config. Package Record";    begin        ConfigPackageTable.SetCurrentKey("Package Processing Order", "Processing Order");        if not HideDialog then            ConfigProgressBar.Init(ConfigPackageTable.Count, 1,              StrSubstNo(ApplyingPackageMsg, ConfigPackage.Code));        if ConfigPackageTable.FindSet() then            repeat                ConfigPackageTable.CalcFields("Table Name");                ConfigPackageRecord.SetRange("Package Code", ConfigPackageTable."Package Code");                ConfigPackageRecord.SetRange("Table ID", ConfigPackageTable."Table ID");                OnApplyPackageTablesOnFilterConfigPackageRecord(ConfigPackage, ConfigPackageRecord);                if not HideDialog then                    ConfigProgressBar.Update(ConfigPackageTable."Table Name");                if not IsTableErrorsExists(ConfigPackageTable) then// Added to show item duplicate errors                    ApplyPackageRecords(                      ConfigPackageRecord, ConfigPackageTable."Package Code", ConfigPackageTable."Table ID", ApplyMode);            until ConfigPackageTable.Next() = 0;        if not HideDialog then            ConfigProgressBar.Close();    end;    procedure ApplySelectedPackageRecords(var ConfigPackageRecord: Record "Config. Package Record"; PackageCode: Code[20]; TableNo: Integer)    begin        TempAppliedConfigPackageRecord.DeleteAll();        TempConfigRecordForProcessing.DeleteAll();        ApplyPackageRecords(ConfigPackageRecord, PackageCode, TableNo, ApplyMode::PrimaryKey);        ApplyPackageRecords(ConfigPackageRecord, PackageCode, TableNo, ApplyMode::NonKeyFields);        ProcessAppliedPackageRecords(TempConfigRecordForProcessing, TempAppliedConfigPackageRecord);        DeleteAppliedPackageRecords(TempAppliedConfigPackageRecord);    end;    local procedure ApplyPackageRecords(var ConfigPackageRecord: Record "Config. Package Record"; PackageCode: Code[20]; TableNo: Integer; ApplyMode: Option ,PrimaryKey,NonKeyFields)    var        ConfigPackageTable: Record "Config. Package Table";        ConfigTableProcessingRule: Record "Config. Table Processing Rule";        ConfigPackageMgt: Codeunit "Config. Package Management";        ConfigProgressBarRecord: Codeunit "Config. Progress Bar";        RecRef: RecordRef;        RecordCount: Integer;        StepCount: Integer;        Counter: Integer;        ProcessingRuleIsSet: Boolean;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeApplyPackageRecords(ConfigPackageRecord, PackageCode, TableNo, ApplyMode, ConfigPackageMgt, TempAppliedConfigPackageRecord, ProcessingRuleIsSet, TempConfigRecordForProcessing, ConfigTableProcessingRule, RecordsInsertedCount, RecordsModifiedCount, HideDialog, IsHandled);        if not IsHandled then begin            ConfigPackageTable.Get(PackageCode, TableNo);            ProcessingRuleIsSet := ConfigTableProcessingRule.FindTableRules(ConfigPackageTable);            ConfigPackageMgt.SetApplyMode(ApplyMode);            RecordCount := ConfigPackageRecord.Count();            if not HideDialog and (RecordCount > 1000) then begin                StepCount := Round(RecordCount / 100, 1);                ConfigPackageTable.CalcFields("Table Name");                ConfigProgressBarRecord.Init(                  RecordCount, StepCount, StrSubstNo(ApplyingTableMsg, ConfigPackageTable."Table Name"));            end;            Counter := 0;            if ConfigPackageRecord.FindSet() then begin                RecRef.Open(ConfigPackageRecord."Table ID");                if ConfigPackageTable."Delete Recs Before Processing" then begin                    RecRef.DeleteAll();                    Commit();                end;                repeat                    Counter := Counter + 1;                    if (ApplyMode = ApplyMode::PrimaryKey) or not IsRecordErrorsExistsInPrimaryKeyFields(ConfigPackageRecord) then begin                        if ConfigPackageMgt.Run(ConfigPackageRecord) then begin                            if not ((ApplyMode = ApplyMode::PrimaryKey) or IsRecordErrorsExists(ConfigPackageRecord)) then begin                                CollectAppliedPackageRecord(ConfigPackageRecord, TempAppliedConfigPackageRecord);                                if ProcessingRuleIsSet then                                    CollectRecordForProcessingAction(ConfigPackageRecord, ConfigTableProcessingRule);                            end                        end else                            if GetLastErrorText <> '' then begin                                ConfigPackageMgt.RecordError(                                  ConfigPackageRecord, ConfigPackageMgt.GetValidationFieldID(), CopyStr(GetLastErrorText, 1, 250));                                ClearLastError();                                Commit();                            end;                        RecordsInsertedCount += ConfigPackageMgt.GetNumberOfRecordsInserted();                        RecordsModifiedCount += ConfigPackageMgt.GetNumberOfRecordsModified();                    end;                    if not HideDialog and (RecordCount > 1000) then                        ConfigProgressBarRecord.Update(StrSubstNo(RecordsXofYMsg, Counter, RecordCount));                until ConfigPackageRecord.Next() = 0;            end;            if not HideDialog and (RecordCount > 1000) then                ConfigProgressBarRecord.Close();        end;        OnAfterApplyPackageRecords(ConfigPackageRecord, PackageCode, TableNo);    end;    local procedure CollectRecordForProcessingAction(ConfigPackageRecord: Record "Config. Package Record"; var ConfigTableProcessingRule: Record "Config. Table Processing Rule")    begin        ConfigTableProcessingRule.FindSet();        repeat            if ConfigPackageRecord.FitsProcessingFilter(ConfigTableProcessingRule."Rule No.") then                TempConfigRecordForProcessing.AddRecord(ConfigPackageRecord, ConfigTableProcessingRule."Rule No.");        until ConfigTableProcessingRule.Next() = 0;    end;    local procedure CollectAppliedPackageRecord(ConfigPackageRecord: Record "Config. Package Record"; var TempConfigPackageRecord: Record "Config. Package Record" temporary)    begin        TempConfigPackageRecord.Init();        TempConfigPackageRecord := ConfigPackageRecord;        TempConfigPackageRecord.Insert();    end;    local procedure DeleteAppliedPackageRecords(var TempConfigPackageRecord: Record "Config. Package Record" temporary)    var        ConfigPackageRecord: Record "Config. Package Record";    begin        if TempConfigPackageRecord.FindSet() then            repeat                ConfigPackageRecord.TransferFields(TempConfigPackageRecord);                ConfigPackageRecord.Delete(true);            until TempConfigPackageRecord.Next() = 0;        TempConfigPackageRecord.DeleteAll();        Commit();    end;    procedure ApplyConfigTables(ConfigPackage: Record "Config. Package")    var        ConfigPackageTable: Record "Config. Package Table";    begin        ConfigPackageTable.Reset();        ConfigPackageTable.SetRange("Package Code", ConfigPackage.Code);        ConfigPackageTable.SetFilter("Table ID", '%1|%2|%3|%4|%5|%6|%7|%8',          Database::"Config. Template Header", Database::"Config. Template Line",          Database::"Config. Questionnaire", Database::"Config. Question Area", Database::"Config. Question",          Database::"Config. Line", Database::"Config. Package Filter", Database::"Config. Table Processing Rule");        if not ConfigPackageTable.IsEmpty() then begin            Commit();            SetHideDialog(true);            ApplyPackageTables(ConfigPackage, ConfigPackageTable, ApplyMode::PrimaryKey);            ApplyPackageTables(ConfigPackage, ConfigPackageTable, ApplyMode::NonKeyFields);            DeleteAppliedPackageRecords(TempAppliedConfigPackageRecord);        end;    end;    local procedure ProcessAppliedPackageRecords(var TempConfigRecordForProcessing: Record "Config. Record For Processing" temporary; var TempConfigPackageRecord: Record "Config. Package Record" temporary)    var        ConfigTableProcessingRule: Record "Config. Table Processing Rule";        Subscriber: Variant;    begin        OnPreProcessPackage(TempConfigRecordForProcessing, Subscriber);        if TempConfigRecordForProcessing.FindSet() then            repeat                if not ConfigTableProcessingRule.Process(TempConfigRecordForProcessing) then begin                    TempConfigRecordForProcessing.FindConfigRecord(TempConfigPackageRecord);                    RecordError(TempConfigPackageRecord, 0, CopyStr(GetLastErrorText, 1, 250));                    TempConfigPackageRecord.Delete(); // Remove it from the buffer to avoid deletion in the package                    Commit();                end;            until TempConfigRecordForProcessing.Next() = 0;        TempConfigRecordForProcessing.DeleteAll();        OnPostProcessPackage();    end;    procedure SetApplyMode(NewApplyMode: Option ,PrimaryKey,NonKeyFields)    begin        ApplyMode := NewApplyMode;    end;    procedure SetFieldFilter(var "Field": Record "Field"; TableID: Integer; FieldID: Integer)    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeSetFieldFilter(Field, TableID, FieldID, IsHandled);        if IsHandled then            exit;        Field.Reset();        if TableID > 0 then            Field.SetRange(TableNo, TableID);        if FieldID > 0 then            Field.SetRange("No.", FieldID)        else            Field.SetFilter("No.", '<>%1&<>%2&<>%3&<>%4&<>%5',                    Field.FieldNo(SystemId),                    Field.FieldNo(SystemCreatedAt),                    Field.FieldNo(SystemCreatedBy),                    Field.FieldNo(SystemModifiedAt),                    Field.FieldNo(SystemModifiedBy));        Field.SetRange(Class, Field.Class::Normal);        Field.SetRange(Enabled, true);        Field.SetFilter(ObsoleteState, '<>%1', Field.ObsoleteState::Removed);    end;    procedure SelectAllPackageFields(var ConfigPackageField: Record "Config. Package Field"; SetInclude: Boolean)    var        ConfigPackageField2: Record "Config. Package Field";    begin        ConfigPackageField.SetRange("Primary Key", false);        ConfigPackageField.SetRange("Include Field", not SetInclude);        if ConfigPackageField.FindSet() then            repeat                ConfigPackageField2.Get(ConfigPackageField."Package Code", ConfigPackageField."Table ID", ConfigPackageField."Field ID");                ConfigPackageField2."Include Field" := SetInclude;                ConfigPackageField2."Validate Field" :=                  SetInclude and not ValidateException(ConfigPackageField."Table ID", ConfigPackageField."Field ID");                ConfigPackageField2.Modify();            until ConfigPackageField.Next() = 0;        ConfigPackageField.SetRange("Include Field");        ConfigPackageField.SetRange("Primary Key");    end;    procedure SetupProcessingOrder(var ConfigPackageTable: Record "Config. Package Table")    var        ConfigPackageTableLoop: Record "Config. Package Table";        TempConfigPackageTable: Record "Config. Package Table" temporary;        Flag: Integer;        IsHandled: Boolean;    begin        OnBeforeSetupProcessingOrder(ConfigPackageTable, IsHandled);        if IsHandled then            exit;        ConfigPackageTableLoop.CopyFilters(ConfigPackageTable);        if not ConfigPackageTableLoop.FindSet(true) then            exit;        Flag := -1; // flag for all selected records: record processing order no was not initialized        repeat            ConfigPackageTableLoop."Processing Order" := Flag;            ConfigPackageTableLoop.Modify();        until ConfigPackageTableLoop.Next() = 0;        ConfigPackageTable.FindSet(true);        repeat            if ConfigPackageTable."Processing Order" = Flag then begin                SetupTableProcessingOrder(ConfigPackageTable."Package Code", ConfigPackageTable."Table ID", TempConfigPackageTable, 1);                TempConfigPackageTable.Reset();                TempConfigPackageTable.DeleteAll();            end;        until ConfigPackageTable.Next() = 0;    end;    local procedure SetupTableProcessingOrder(PackageCode: Code[20]; TableId: Integer; var CheckedConfigPackageTable: Record "Config. Package Table"; StackLevel: Integer): Integer    var        ConfigPackageTable: Record "Config. Package Table";        RecRef: RecordRef;        FieldRef: FieldRef;        KeyRef: KeyRef;        I: Integer;        ProcessingOrder: Integer;    begin        if CheckedConfigPackageTable.Get(PackageCode, TableId) then            Error(ProcessingOrderErr, TableId);        CheckedConfigPackageTable.Init();        CheckedConfigPackageTable."Package Code" := PackageCode;        CheckedConfigPackageTable."Table ID" := TableId;        // level to cleanup temptable from field branch checking history for case with multiple field branches        CheckedConfigPackageTable."Processing Order" := StackLevel;        CheckedConfigPackageTable.Insert();        RecRef.Open(TableId);        KeyRef := RecRef.KeyIndex(1);        ProcessingOrder := 1;        for I := 1 to KeyRef.FieldCount do begin            FieldRef := KeyRef.FieldIndex(I);            if (FieldRef.Relation <> 0) and (FieldRef.Relation <> TableId) then                if ConfigPackageTable.Get(PackageCode, FieldRef.Relation) then begin                    ProcessingOrder :=                      MaxInt(                        SetupTableProcessingOrder(PackageCode, FieldRef.Relation, CheckedConfigPackageTable, StackLevel + 1) + 1, ProcessingOrder);                    ClearFieldBranchCheckingHistory(PackageCode, CheckedConfigPackageTable, StackLevel);                end;        end;        if TableId = Database::"Comment Line" then            ProcessingOrder :=                MaxInt(ProcessingOrder, SetupCommentLineProcessingOrder(PackageCode, CheckedConfigPackageTable, StackLevel));        if ConfigPackageTable.Get(PackageCode, TableId) then begin            ConfigPackageTable."Processing Order" := ProcessingOrder;            AdjustProcessingOrder(ConfigPackageTable);            ConfigPackageTable.Modify();        end;        exit(ProcessingOrder);    end;    local procedure SetupCommentLineProcessingOrder(PackageCode: Code[20]; var CheckedConfigPackageTable: Record "Config. Package Table"; StackLevel: Integer): Integer    var        CommentLine: Record "Comment Line";        RelatedConfigPackageTable: Record "Config. Package Table";        TableRelationsMetadata: Record "Table Relations Metadata";        ProcessingOrder: Integer;    begin        ProcessingOrder := 1;        TableRelationsMetadata.SetRange("Table ID", Database::"Comment Line");        TableRelationsMetadata.SetRange("Field No.", CommentLine.FieldNo("No."));        TableRelationsMetadata.SetFilter("Related Table ID", '<>%1&<>%2', 0, Database::"Comment Line");        if TableRelationsMetadata.FindSet() then            repeat                if RelatedConfigPackageTable.Get(PackageCode, TableRelationsMetadata."Related Table ID") then begin                    SetupTableProcessingOrder(PackageCode, RelatedConfigPackageTable."Table ID", CheckedConfigPackageTable, StackLevel + 1);                    RelatedConfigPackageTable.Get(PackageCode, TableRelationsMetadata."Related Table ID");                    // Use the final order, including adjustments such as the project-table delay.                    ProcessingOrder := MaxInt(ProcessingOrder, RelatedConfigPackageTable."Processing Order" + 1);                    ClearFieldBranchCheckingHistory(PackageCode, CheckedConfigPackageTable, StackLevel);                end;            until TableRelationsMetadata.Next() = 0;        exit(ProcessingOrder);    end;    local procedure AdjustProcessingOrder(var ConfigPackageTable: Record "Config. Package Table")    var        RelatedConfigPackageTable: Record "Config. Package Table";    begin        case ConfigPackageTable."Table ID" of            Database::Microsoft.Finance.GeneralLedger.Account."G/L Account Category":                // Pushing G/L Account Category before G/L Account                if RelatedConfigPackageTable.Get(ConfigPackageTable."Package Code", Database::Microsoft.Finance.GeneralLedger.Account."G/L Account") then                    ConfigPackageTable."Processing Order" := RelatedConfigPackageTable."Processing Order" - 1;            Database::Microsoft.Sales.Document."Sales Header" .. Database::Microsoft.Purchases.Document."Purchase Line":                // Moving Sales/Purchase Documents down                ConfigPackageTable."Processing Order" += 4;            Database::Microsoft.Pricing.Calculation."Price Calculation Setup",                Database::"Company Information":                ConfigPackageTable."Processing Order" += 1;            Database::Microsoft.Foundation.Reporting."Custom Report Layout":                // Moving Layouts to be on the top                ConfigPackageTable."Processing Order" := 0;            // Moving Jobs tables down so contacts table can be processed first            Database::Microsoft.Projects.Project.Job.Job, Database::Microsoft.Projects.Project.Job."Job Task",                Database::Microsoft.Projects.Project.Planning."Job Planning Line", Database::Microsoft.Projects.Project.Journal."Job Journal Line",                Database::Microsoft.Projects.Project.Journal."Job Journal Batch", Database::Microsoft.Projects.Project.Job."Job Posting Group",                Database::Microsoft.Projects.Project.Journal."Job Journal Template", Database::Microsoft.CRM.Setup."Job Responsibility":                ConfigPackageTable."Processing Order" += 4;        end;    end;    local procedure ClearFieldBranchCheckingHistory(PackageCode: Code[20]; var CheckedConfigPackageTable: Record "Config. Package Table"; StackLevel: Integer)    begin        CheckedConfigPackageTable.SetRange("Package Code", PackageCode);        CheckedConfigPackageTable.SetFilter("Processing Order", '>%1', StackLevel);        CheckedConfigPackageTable.DeleteAll();    end;    local procedure MaxInt(Int1: Integer; Int2: Integer): Integer    begin        if Int1 > Int2 then            exit(Int1);        exit(Int2);    end;    local procedure GetDimSetID(PackageCode: Code[20]; DimSetValue: Text[2048]): Integer    var        ConfigPackageData: Record "Config. Package Data";        ConfigPackageData2: Record "Config. Package Data";        TempDimSetEntry: Record "Dimension Set Entry" temporary;        DimMgt: Codeunit DimensionManagement;    begin        ConfigPackageData.SetRange("Package Code", PackageCode);        ConfigPackageData.SetRange("Table ID", Database::"Dimension Set Entry");        ConfigPackageData.SetRange("Field ID", TempDimSetEntry.FieldNo("Dimension Set ID"));        if ConfigPackageData.FindSet() then            repeat                if ConfigPackageData.Value = DimSetValue then begin                    TempDimSetEntry.Init();                    ConfigPackageData2.Get(                      ConfigPackageData."Package Code", ConfigPackageData."Table ID", ConfigPackageData."No.",                      TempDimSetEntry.FieldNo("Dimension Code"));                    TempDimSetEntry.Validate("Dimension Code", Format(ConfigPackageData2.Value));                    ConfigPackageData2.Get(                      ConfigPackageData."Package Code", ConfigPackageData."Table ID", ConfigPackageData."No.",                      TempDimSetEntry.FieldNo("Dimension Value Code"));                    TempDimSetEntry.Validate(                      "Dimension Value Code", CopyStr(Format(ConfigPackageData2.Value), 1, MaxStrLen(TempDimSetEntry."Dimension Value Code")));                    TempDimSetEntry.Insert();                end;            until ConfigPackageData.Next() = 0;        exit(DimMgt.GetDimensionSetID(TempDimSetEntry));    end;    procedure GetDimSetIDForRecord(ConfigPackageRecord: Record "Config. Package Record"): Integer    var        ConfigPackageData: Record "Config. Package Data";        ConfigPackageField: Record "Config. Package Field";        TempDimSetEntry: Record "Dimension Set Entry" temporary;        DimValue: Record "Dimension Value";        DimMgt: Codeunit DimensionManagement;        ConfigPackageMgt: Codeunit "Config. Package Management";        DimCode: Code[20];        DimValueCode: Code[20];        DimValueNotFound: Boolean;    begin        ConfigPackageData.SetRange("Package Code", ConfigPackageRecord."Package Code");        ConfigPackageData.SetRange("Table ID", ConfigPackageRecord."Table ID");        ConfigPackageData.SetRange("No.", ConfigPackageRecord."No.");        ConfigPackageData.SetRange("Field ID", ConfigMgt.DimensionFieldID(), ConfigMgt.DimensionFieldID() + 999);        ConfigPackageData.SetFilter(Value, '<>%1', '');        if ConfigPackageData.FindSet() then            repeat                if ConfigPackageField.Get(ConfigPackageData."Package Code", ConfigPackageData."Table ID", ConfigPackageData."Field ID") then begin                    ConfigPackageField.TestField(Dimension);                    DimCode := CopyStr(Format(ConfigPackageField."Field Name"), 1, 20);                    DimValueCode := CopyStr(Format(ConfigPackageData.Value), 1, MaxStrLen(TempDimSetEntry."Dimension Value Code"));                    TempDimSetEntry.Init();                    TempDimSetEntry.Validate("Dimension Code", DimCode);                    if DimValue.Get(DimCode, DimValueCode) then begin                        TempDimSetEntry.Validate("Dimension Value Code", DimValueCode);                        TempDimSetEntry.Insert();                    end else begin                        ConfigPackageMgt.FieldError(                          ConfigPackageData, StrSubstNo(DimValueDoesNotExistsErr, DimCode, DimValueCode), ErrorTypeEnum::General);                        DimValueNotFound := true;                    end;                end;            until ConfigPackageData.Next() = 0;        if DimValueNotFound then            exit(0);        exit(DimMgt.GetDimensionSetID(TempDimSetEntry));    end;    local procedure UpdateDimSetIDValues(ConfigPackage: Record "Config. Package")    var        ConfigPackageData: Record "Config. Package Data";        ConfigPackageTable: Record "Config. Package Table";        ConfigPackageTableDim: Record "Config. Package Table";        ConfigPackageDataDimSet: Record "Config. Package Data";        DimSetEntry: Record "Dimension Set Entry";    begin        ConfigPackageTableDim.SetRange("Package Code", ConfigPackage.Code);        ConfigPackageTableDim.SetRange("Table ID", Database::Dimension, Database::"Default Dimension Priority");        if not ConfigPackageTableDim.IsEmpty() then begin            ApplyPackageTables(ConfigPackage, ConfigPackageTableDim, ApplyMode::PrimaryKey);            ApplyPackageTables(ConfigPackage, ConfigPackageTableDim, ApplyMode::NonKeyFields);        end;        ConfigPackageDataDimSet.SetRange("Package Code", ConfigPackage.Code);        ConfigPackageDataDimSet.SetRange("Table ID", Database::"Dimension Set Entry");        ConfigPackageDataDimSet.SetRange("Field ID", DimSetEntry.FieldNo("Dimension Set ID"));        if ConfigPackageDataDimSet.IsEmpty() then            exit;        ConfigPackageData.Reset();        ConfigPackageData.SetRange("Package Code", ConfigPackage.Code);        ConfigPackageData.SetFilter("Table ID", '<>%1', Database::"Dimension Set Entry");        ConfigPackageData.SetRange("Field ID", Database::"Dimension Set Entry");        if ConfigPackageData.FindSet(true) then begin            if not HideDialog then                ConfigProgressBar.Init(ConfigPackageData.Count, 1, UpdatingDimSetsMsg);            repeat                ConfigPackageTable.Get(ConfigPackage.Code, ConfigPackageData."Table ID");                ConfigPackageTable.CalcFields("Table Name");                if not HideDialog then                    ConfigProgressBar.Update(ConfigPackageTable."Table Name");                if ConfigPackageData.Value <> '' then begin                    ConfigPackageData.Value := Format(GetDimSetID(ConfigPackage.Code, ConfigPackageData.Value));                    ConfigPackageData.Modify();                end;            until ConfigPackageData.Next() = 0;            if not HideDialog then                ConfigProgressBar.Close();        end;    end;    procedure UpdateDefaultDimValues(ConfigPackageRecord: Record "Config. Package Record"; MasterNo: Code[20])    var        ConfigPackageTableDim: Record "Config. Package Table";        ConfigPackageRecordDim: Record "Config. Package Record";        ConfigPackageDataDim: array[4] of Record "Config. Package Data";        ConfigPackageField: Record "Config. Package Field";        ConfigPackageData: Record "Config. Package Data";        DefaultDim: Record "Default Dimension";        DimValue: Record "Dimension Value";        RecordFound: Boolean;    begin        ConfigPackageRecord.TestField("Package Code");        ConfigPackageRecord.TestField("Table ID");        ConfigPackageData.SetRange("Package Code", ConfigPackageRecord."Package Code");        ConfigPackageData.SetRange("Table ID", ConfigPackageRecord."Table ID");        ConfigPackageData.SetRange("No.", ConfigPackageRecord."No.");        ConfigPackageData.SetRange("Field ID", ConfigMgt.DimensionFieldID(), ConfigMgt.DimensionFieldID() + 999);        ConfigPackageData.SetFilter(Value, '<>%1', '');        if ConfigPackageData.IsEmpty() then            exit;        if ConfigPackageData.FindSet() then            repeat                if ConfigPackageField.Get(ConfigPackageData."Package Code", ConfigPackageData."Table ID", ConfigPackageData."Field ID") then begin                    // find if Dimension Code already exist                    RecordFound := false;                    ConfigPackageDataDim[1].SetRange("Package Code", ConfigPackageRecord."Package Code");                    ConfigPackageDataDim[1].SetRange("Table ID", Database::"Default Dimension");                    ConfigPackageDataDim[1].SetRange("Field ID", DefaultDim.FieldNo("Table ID"));                    ConfigPackageDataDim[1].SetRange(Value, Format(ConfigPackageRecord."Table ID"));                    if not ConfigPackageDataDim[1].IsEmpty() then                        if ConfigPackageDataDim[1].FindSet() then                            repeat                                if ConfigPackageDataDim[2].Get(ConfigPackageRecord."Package Code", Database::"Default Dimension", ConfigPackageDataDim[1]."No.", DefaultDim.FieldNo("No.")) and                                    (ConfigPackageDataDim[2].Value = MasterNo)                                then                                    if ConfigPackageDataDim[3].Get(ConfigPackageRecord."Package Code", Database::"Default Dimension", ConfigPackageDataDim[2]."No.", DefaultDim.FieldNo("Dimension Code")) and                                        (ConfigPackageDataDim[3].Value = ConfigPackageField."Field Name")                                    then                                        RecordFound := true;                            until (ConfigPackageDataDim[1].Next() = 0) or RecordFound;                    if not RecordFound then begin                        if not ConfigPackageTableDim.Get(ConfigPackageRecord."Package Code", Database::"Default Dimension") then                            InsertPackageTable(ConfigPackageTableDim, ConfigPackageRecord."Package Code", Database::"Default Dimension");                        InitPackageRecord(ConfigPackageRecordDim, ConfigPackageTableDim."Package Code", ConfigPackageTableDim."Table ID");                        // Insert Default Dimension record                        InsertPackageData(ConfigPackageDataDim[4],                            ConfigPackageRecordDim."Package Code", ConfigPackageRecordDim."Table ID", ConfigPackageRecordDim."No.",                            DefaultDim.FieldNo("Table ID"), Format(ConfigPackageRecord."Table ID"), false);                        InsertPackageData(ConfigPackageDataDim[4],                            ConfigPackageRecordDim."Package Code", ConfigPackageRecordDim."Table ID", ConfigPackageRecordDim."No.",                            DefaultDim.FieldNo("No."), Format(MasterNo), false);                        InsertPackageData(ConfigPackageDataDim[4],                            ConfigPackageRecordDim."Package Code", ConfigPackageRecordDim."Table ID", ConfigPackageRecordDim."No.",                            DefaultDim.FieldNo("Dimension Code"), ConfigPackageField."Field Name", false);                        if IsBlankDim(ConfigPackageData.Value) then                            InsertPackageData(ConfigPackageDataDim[4],                                ConfigPackageRecordDim."Package Code", ConfigPackageRecordDim."Table ID", ConfigPackageRecordDim."No.",                                DefaultDim.FieldNo("Dimension Value Code"), '', false)                        else                            InsertPackageData(ConfigPackageDataDim[4],                                ConfigPackageRecordDim."Package Code", ConfigPackageRecordDim."Table ID", ConfigPackageRecordDim."No.",                                DefaultDim.FieldNo("Dimension Value Code"), ConfigPackageData.Value, false);                    end else begin                        ConfigPackageDataDim[3].Get(ConfigPackageRecord."Package Code", Database::"Default Dimension", ConfigPackageDataDim[2]."No.", DefaultDim.FieldNo("Dimension Value Code"));                        ConfigPackageDataDim[3].Value := ConfigPackageData.Value;                        ConfigPackageDataDim[3].Modify();                    end;                    // Insert Dimension value if needed                    if not IsBlankDim(ConfigPackageData.Value) then                        if not DimValue.Get(ConfigPackageField."Field Name", ConfigPackageData.Value) then begin                            ConfigPackageRecord.TestField("Package Code");                            if not ConfigPackageTableDim.Get(ConfigPackageRecord."Package Code", Database::"Dimension Value") then                                InsertPackageTable(ConfigPackageTableDim, ConfigPackageRecord."Package Code", Database::"Dimension Value");                            InitPackageRecord(ConfigPackageRecordDim, ConfigPackageTableDim."Package Code", ConfigPackageTableDim."Table ID");                            InsertPackageData(ConfigPackageDataDim[4],                                ConfigPackageRecordDim."Package Code", ConfigPackageRecordDim."Table ID", ConfigPackageRecordDim."No.",                                DimValue.FieldNo("Dimension Code"), ConfigPackageField."Field Name", false);                            InsertPackageData(ConfigPackageDataDim[4],                                ConfigPackageRecordDim."Package Code", ConfigPackageRecordDim."Table ID", ConfigPackageRecordDim."No.",                                DimValue.FieldNo(Code), ConfigPackageData.Value, false);                        end;                end;            until ConfigPackageData.Next() = 0;    end;    local procedure IsBlankDim(Value: Text[2048]): Boolean    begin        exit(UpperCase(Value) = UpperCase(BlankTxt));    end;    procedure SetHideDialog(NewHideDialog: Boolean)    begin        HideDialog := NewHideDialog;    end;    procedure AddConfigTables(PackageCode: Code[20])    var        ConfigPackageTable: Record "Config. Package Table";        ConfigPackageFilter: Record "Config. Package Filter";        ConfigLine: Record "Config. Line";    begin        ConfigPackageTable.Init();        InsertPackageTable(ConfigPackageTable, PackageCode, Database::"Config. Questionnaire");        InsertPackageTable(ConfigPackageTable, PackageCode, Database::"Config. Question Area");        InsertPackageTable(ConfigPackageTable, PackageCode, Database::"Config. Question");        InsertPackageTable(ConfigPackageTable, PackageCode, Database::"Config. Template Header");        InsertPackageTable(ConfigPackageTable, PackageCode, Database::"Config. Template Line");        InsertPackageTable(ConfigPackageTable, PackageCode, Database::"Config. Tmpl. Selection Rules");        InsertPackageTable(ConfigPackageTable, PackageCode, Database::"Config. Line");        InsertPackageFilter(ConfigPackageFilter, PackageCode, Database::"Config. Line", 0, ConfigLine.FieldNo("Package Code"), PackageCode);        InsertPackageTable(ConfigPackageTable, PackageCode, Database::"Config. Package Filter");        InsertPackageFilter(          ConfigPackageFilter, PackageCode, Database::"Config. Package Filter", 0, ConfigPackageFilter.FieldNo("Package Code"), PackageCode);        InsertPackageTable(ConfigPackageTable, PackageCode, Database::"Config. Field Map");        InsertPackageTable(ConfigPackageTable, PackageCode, Database::"Config. Table Processing Rule");        OnAddConfigTablesOnBeforeSetSkipTableTriggers(ConfigPackageTable, PackageCode);        SetSkipTableTriggers(ConfigPackageTable, PackageCode, Database::"Config. Table Processing Rule", true);        InsertPackageFilter(          ConfigPackageFilter, PackageCode, Database::"Config. Table Processing Rule", 0,          ConfigPackageFilter.FieldNo("Package Code"), PackageCode);    end;    procedure AssignPackage(var ConfigLine: Record "Config. Line"; PackageCode: Code[20])    var        ConfigLine2: Record "Config. Line";        TempConfigLine: Record "Config. Line" temporary;        ConfigPackageTable: Record "Config. Package Table";        ConfigPackageTable2: Record "Config. Package Table";        LineTypeFilter: Text;    begin        CreateConfigLineBuffer(ConfigLine, TempConfigLine, PackageCode);        CheckConfigLinesToAssign(TempConfigLine);        LineTypeFilter := ConfigLine.GetFilter("Line Type");        ConfigLine.SetFilter("Package Code", '<>%1', PackageCode);        ConfigLine.SetRange("Line Type");        if ConfigLine.FindSet(true) then            repeat                ConfigLine.CheckBlocked();                if ConfigLine.Status <= ConfigLine.Status::"In Progress" then begin                    if ConfigLine."Line Type" = ConfigLine."Line Type"::Table then begin                        ConfigLine.TestField("Table ID");                        if ConfigPackageTable.Get(ConfigLine."Package Code", ConfigLine."Table ID") then begin                            ConfigLine2.SetRange("Package Code", PackageCode);                            ConfigLine2.SetRange("Table ID", ConfigLine."Table ID");                            CheckConfigLinesToAssign(ConfigLine2);                            InsertPackageTable(ConfigPackageTable2, PackageCode, ConfigLine."Table ID");                            ChangePackageCode(ConfigLine."Package Code", PackageCode, ConfigLine."Table ID");                            ConfigPackageTable.Delete(true);                        end else                            if not ConfigPackageTable.Get(PackageCode, ConfigLine."Table ID") then                                InsertPackageTable(ConfigPackageTable, PackageCode, ConfigLine."Table ID");                    end;                    ConfigLine."Package Code" := PackageCode;                    ConfigLine.Modify();                end;            until ConfigLine.Next() = 0;        ConfigLine.SetRange("Package Code");        if LineTypeFilter <> '' then            ConfigLine.SetFilter("Line Type", LineTypeFilter);    end;    local procedure ChangePackageCode(OldPackageCode: Code[20]; NewPackageCode: Code[20]; TableID: Integer)    var        ConfigPackageRecord: Record "Config. Package Record";        TempConfigPackageRecord: Record "Config. Package Record" temporary;        ConfigPackageData: Record "Config. Package Data";        TempConfigPackageData: Record "Config. Package Data" temporary;        ConfigPackageFilter: Record "Config. Package Filter";        TempConfigPackageFilter: Record "Config. Package Filter" temporary;        ConfigPackageError: Record "Config. Package Error";        TempConfigPackageError: Record "Config. Package Error" temporary;    begin        TempConfigPackageRecord.DeleteAll();        ConfigPackageRecord.SetRange("Package Code", OldPackageCode);        ConfigPackageRecord.SetRange("Table ID", TableID);        if ConfigPackageRecord.FindSet(true) then            repeat                TempConfigPackageRecord := ConfigPackageRecord;                TempConfigPackageRecord."Package Code" := NewPackageCode;                TempConfigPackageRecord.Insert();            until ConfigPackageRecord.Next() = 0;        if TempConfigPackageRecord.FindSet() then            repeat                ConfigPackageRecord := TempConfigPackageRecord;                ConfigPackageRecord.Insert();            until TempConfigPackageRecord.Next() = 0;        TempConfigPackageData.DeleteAll();        ConfigPackageData.SetRange("Package Code", OldPackageCode);        ConfigPackageData.SetRange("Table ID", TableID);        if ConfigPackageData.FindSet(true) then            repeat                TempConfigPackageData := ConfigPackageData;                TempConfigPackageData."Package Code" := NewPackageCode;                TempConfigPackageData.Insert();            until ConfigPackageData.Next() = 0;        if TempConfigPackageData.FindSet() then            repeat                ConfigPackageData := TempConfigPackageData;                ConfigPackageData.Insert();            until TempConfigPackageData.Next() = 0;        TempConfigPackageError.DeleteAll();        ConfigPackageError.SetRange("Package Code", OldPackageCode);        ConfigPackageError.SetRange("Table ID", TableID);        if ConfigPackageError.FindSet(true) then            repeat                TempConfigPackageError := ConfigPackageError;                TempConfigPackageError."Package Code" := NewPackageCode;                TempConfigPackageError.Insert();            until ConfigPackageError.Next() = 0;        if TempConfigPackageError.FindSet() then            repeat                ConfigPackageError := TempConfigPackageError;                ConfigPackageError.Insert();            until TempConfigPackageError.Next() = 0;        TempConfigPackageFilter.DeleteAll();        ConfigPackageFilter.SetRange("Package Code", OldPackageCode);        ConfigPackageFilter.SetRange("Table ID", TableID);        if ConfigPackageFilter.FindSet(true) then            repeat                TempConfigPackageFilter := ConfigPackageFilter;                TempConfigPackageFilter."Package Code" := NewPackageCode;                TempConfigPackageFilter.Insert();            until ConfigPackageFilter.Next() = 0;        if TempConfigPackageFilter.FindSet() then            repeat                ConfigPackageFilter := TempConfigPackageFilter;                ConfigPackageFilter.Insert();            until TempConfigPackageFilter.Next() = 0;    end;    procedure CheckConfigLinesToAssign(var ConfigLine: Record "Config. Line")    var        TempAllObj: Record AllObj temporary;    begin        ConfigLine.SetRange("Line Type", ConfigLine."Line Type"::Table);        if ConfigLine.FindSet() then            repeat                if TempAllObj.Get(TempAllObj."Object Type"::Table, ConfigLine."Table ID") then                    Error(ReferenceSameTableErr);                TempAllObj."Object Type" := TempAllObj."Object Type"::Table;                TempAllObj."Object ID" := ConfigLine."Table ID";                TempAllObj.Insert();            until ConfigLine.Next() = 0;    end;    local procedure CreateConfigLineBuffer(var ConfigLineNew: Record "Config. Line"; var ConfigLineBuffer: Record "Config. Line"; PackageCode: Code[20])    var        ConfigLine: Record "Config. Line";    begin        ConfigLine.SetRange("Package Code", PackageCode);        AddConfigLineToBuffer(ConfigLine, ConfigLineBuffer);        AddConfigLineToBuffer(ConfigLineNew, ConfigLineBuffer);    end;    local procedure AddConfigLineToBuffer(var ConfigLine: Record "Config. Line"; var ConfigLineBuffer: Record "Config. Line")    begin        if ConfigLine.FindSet() then            repeat                if not ConfigLineBuffer.Get(ConfigLine."Line No.") then begin                    ConfigLineBuffer.Init();                    ConfigLineBuffer.TransferFields(ConfigLine);                    ConfigLineBuffer.Insert();                end;            until ConfigLine.Next() = 0;    end;    procedure GetRelatedTables(var ConfigPackageTable: Record "Config. Package Table")    var        TempConfigPackageTable: Record "Config. Package Table" temporary;        "Field": Record "Field";        IsHandled: Boolean;    begin        TempConfigPackageTable.DeleteAll();        if ConfigPackageTable.FindSet() then            repeat                SetFieldFilter(Field, ConfigPackageTable."Table ID", 0);                Field.SetFilter(RelationTableNo, '<>%1&<>%2&..%3', 0, ConfigPackageTable."Table ID", 99000999);                IsHandled := false;                OnBeforeGetFieldRelationTableNo(ConfigPackageTable, Field, TempConfigPackageTable, IsHandled);                if not IsHandled then                    if Field.FindSet() then                        repeat                            TempConfigPackageTable."Package Code" := ConfigPackageTable."Package Code";                            TempConfigPackageTable."Table ID" := Field.RelationTableNo;                            if TempConfigPackageTable.Insert() then;                        until Field.Next() = 0;            until ConfigPackageTable.Next() = 0;        ConfigPackageTable.Reset();        if TempConfigPackageTable.FindSet() then            repeat                if not ConfigPackageTable.Get(TempConfigPackageTable."Package Code", TempConfigPackageTable."Table ID") then                    InsertPackageTable(ConfigPackageTable, TempConfigPackageTable."Package Code", TempConfigPackageTable."Table ID");            until TempConfigPackageTable.Next() = 0;    end;    local procedure GetKeyFieldsOrder(RecRef: RecordRef; PackageCode: Code[20]; var TempConfigPackageField: Record "Config. Package Field" temporary)    var        ConfigPackageField: Record "Config. Package Field";        FieldRef: FieldRef;        KeyRef: KeyRef;        KeyFieldCount: Integer;    begin        KeyRef := RecRef.KeyIndex(1);        for KeyFieldCount := 1 to KeyRef.FieldCount do begin            FieldRef := KeyRef.FieldIndex(KeyFieldCount);            ValidationFieldID := FieldRef.Number;            if ConfigPackageField.Get(PackageCode, RecRef.Number, FieldRef.Number) then;            TempConfigPackageField.Init();            TempConfigPackageField."Package Code" := PackageCode;            TempConfigPackageField."Table ID" := RecRef.Number;            TempConfigPackageField."Field ID" := FieldRef.Number;            TempConfigPackageField."Processing Order" := ConfigPackageField."Processing Order";            TempConfigPackageField.Insert();        end;        OnAfterGetKeyFieldsOrder(RecRef, PackageCode, TempConfigPackageField, ValidationFieldID);    end;    local procedure GetFieldsMarkedAsPrimaryKey(PackageCode: Code[20]; TableID: Integer; var TempConfigPackageField: Record "Config. Package Field" temporary)    var        ConfigPackageField: Record "Config. Package Field";    begin        ConfigPackageField.SetRange("Package Code", PackageCode);        ConfigPackageField.SetRange("Table ID", TableID);        ConfigPackageField.FilterGroup(-1);        ConfigPackageField.SetRange("Primary Key", true);        ConfigPackageField.SetRange(AutoIncrement, true);        ConfigPackageField.FilterGroup(0);        if ConfigPackageField.FindSet() then            repeat                TempConfigPackageField.TransferFields(ConfigPackageField);                if TempConfigPackageField.Insert() then;            until ConfigPackageField.Next() = 0;    end;    procedure GetFieldsOrder(RecRef: RecordRef; PackageCode: Code[20]; var TempConfigPackageField: Record "Config. Package Field" temporary)    var        ConfigPackageField: Record "Config. Package Field";        FieldRef: FieldRef;        FieldCount: Integer;    begin        for FieldCount := 1 to RecRef.FieldCount do begin            FieldRef := RecRef.FieldIndex(FieldCount);            if ConfigPackageField.Get(PackageCode, RecRef.Number, FieldRef.Number) then;            TempConfigPackageField.Init();            TempConfigPackageField."Package Code" := PackageCode;            TempConfigPackageField."Table ID" := RecRef.Number;            TempConfigPackageField."Field ID" := FieldRef.Number;            TempConfigPackageField."Processing Order" := ConfigPackageField."Processing Order";            TempConfigPackageField.Insert();        end;    end;    local procedure GetFieldsOrderInternal(RecRef: RecordRef; PackageCode: Code[20])    begin        TempConfigPackageFieldOrdered.Reset();        TempConfigPackageFieldOrdered.SetRange("Package Code", PackageCode);        TempConfigPackageFieldOrdered.SetRange("Table ID", RecRef.Number);        if not TempConfigPackageFieldOrdered.IsEmpty() then            exit;        GetFieldsOrder(RecRef, PackageCode, TempConfigPackageFieldOrdered);    end;    local procedure IsRecordErrorsExists(ConfigPackageRecord: Record "Config. Package Record"): Boolean    var        ConfigPackageError: Record "Config. Package Error";    begin        ConfigPackageError.SetRange("Package Code", ConfigPackageRecord."Package Code");        ConfigPackageError.SetRange("Table ID", ConfigPackageRecord."Table ID");        ConfigPackageError.SetRange("Record No.", ConfigPackageRecord."No.");        exit(not ConfigPackageError.IsEmpty);    end;    local procedure IsRecordErrorsExistsInPrimaryKeyFields(ConfigPackageRecord: Record "Config. Package Record"): Boolean    var        ConfigPackageError: Record "Config. Package Error";    begin        ConfigPackageError.SetRange("Package Code", ConfigPackageRecord."Package Code");        ConfigPackageError.SetRange("Table ID", ConfigPackageRecord."Table ID");        ConfigPackageError.SetRange("Record No.", ConfigPackageRecord."No.");        if ConfigPackageError.FindSet() then            repeat                if ConfigValidateMgt.IsKeyField(ConfigPackageError."Table ID", ConfigPackageError."Field ID") then                    exit(true);            until ConfigPackageError.Next() = 0;        exit(false);    end;    procedure UpdateConfigLinePackageData(ConfigPackageCode: Code[20])    var        ConfigLine: Record "Config. Line";        ConfigPackageData: Record "Config. Package Data";        ShiftLineNo: BigInteger;        ShiftVertNo: Integer;        TempValue: BigInteger;    begin        ConfigLine.Reset();        if not ConfigLine.FindLast() then            exit;        ShiftLineNo := ConfigLine."Line No." + 10000L;        ShiftVertNo := ConfigLine."Vertical Sorting" + 1;        ConfigPackageData.SetRange("Package Code", ConfigPackageCode);        ConfigPackageData.SetRange("Table ID", Database::"Config. Line");        ConfigPackageData.SetRange("Field ID", ConfigLine.FieldNo("Line No."));        if ConfigPackageData.FindSet() then            repeat                if Evaluate(TempValue, ConfigPackageData.Value) then begin                    ConfigPackageData.Value := Format(TempValue + ShiftLineNo);                    ConfigPackageData.Modify();                end;            until ConfigPackageData.Next() = 0;        ConfigPackageData.SetRange("Field ID", ConfigLine.FieldNo("Vertical Sorting"));        if ConfigPackageData.FindSet() then            repeat                if Evaluate(TempValue, ConfigPackageData.Value) then begin                    ConfigPackageData.Value := Format(TempValue + ShiftVertNo);                    ConfigPackageData.Modify();                end;            until ConfigPackageData.Next() = 0;    end;    procedure HandlePackageDataDimSetIDForRecord(ConfigPackageRecord: Record "Config. Package Record")    var        ConfigPackageData: Record "Config. Package Data";        ConfigPackageMgt: Codeunit "Config. Package Management";        DimPackageDataExists: Boolean;        DimSetID: Integer;    begin        DimSetID := ConfigPackageMgt.GetDimSetIDForRecord(ConfigPackageRecord);        DimPackageDataExists :=          GetDimPackageDataFromRecord(ConfigPackageData, ConfigPackageRecord);        if DimSetID = 0 then begin            if DimPackageDataExists then                ConfigPackageData.Delete(true);        end else            if not DimPackageDataExists then                CreateDimPackageDataFromRecord(ConfigPackageData, ConfigPackageRecord, DimSetID)            else                if ConfigPackageData.Value <> Format(DimSetID) then begin                    ConfigPackageData.Value := Format(DimSetID);                    ConfigPackageData.Modify();                end;    end;    local procedure GetDimPackageDataFromRecord(var ConfigPackageData: Record "Config. Package Data"; ConfigPackageRecord: Record "Config. Package Record"): Boolean    begin        exit(          ConfigPackageData.Get(            ConfigPackageRecord."Package Code", ConfigPackageRecord."Table ID", ConfigPackageRecord."No.",            Database::"Dimension Set Entry"));    end;    local procedure CreateDimPackageDataFromRecord(var ConfigPackageData: Record "Config. Package Data"; ConfigPackageRecord: Record "Config. Package Record"; DimSetID: Integer)    var        ConfigPackageField: Record "Config. Package Field";    begin        if ConfigPackageField.Get(ConfigPackageRecord."Package Code", ConfigPackageRecord."Table ID", Database::"Dimension Set Entry") then begin            ConfigPackageField.Validate("Include Field", true);            ConfigPackageField.Modify(true);        end;        ConfigPackageData.Init();        ConfigPackageData."Package Code" := ConfigPackageRecord."Package Code";        ConfigPackageData."Table ID" := ConfigPackageRecord."Table ID";        ConfigPackageData."Field ID" := Database::"Dimension Set Entry";        ConfigPackageData."No." := ConfigPackageRecord."No.";        ConfigPackageData.Value := Format(DimSetID);        ConfigPackageData.Insert();    end;    local procedure UpdateValueUsingMapping(var ConfigPackageData: Record "Config. Package Data"; ConfigPackageField: Record "Config. Package Field"; PackageCode: Code[20])    var        ConfigFieldMap: Record "Config. Field Map";        NewValue: Text[2048];    begin        ConfigFieldMap.SetCurrentKey("Package Code", "Table ID", "Field ID", "Old Value");        ConfigFieldMap.SetRange("Package Code", ConfigPackageData."Package Code");        ConfigFieldMap.SetRange("Table ID", ConfigPackageField."Table ID");        ConfigFieldMap.SetRange("Field ID", ConfigPackageField."Field ID");        ConfigFieldMap.SetRange("Old Value", ConfigPackageData.Value);        if ConfigFieldMap.FindFirst() then            NewValue := ConfigFieldMap."New Value";        if (NewValue = '') and (ConfigPackageField."Relation Table ID" <> 0) then            NewValue := GetMappingFromPKOfRelatedTable(ConfigPackageField, ConfigPackageData.Value);        if NewValue <> '' then begin            ConfigPackageData.Validate(Value, NewValue);            ConfigPackageData.Modify();        end;        if ConfigPackageField."Create Missing Codes" then            CreateMissingCodes(ConfigPackageData, ConfigPackageField."Relation Table ID", PackageCode);    end;    local procedure CreateMissingCodes(var ConfigPackageData: Record "Config. Package Data"; RelationTableID: Integer; PackageCode: Code[20])    var        RecRef: RecordRef;        FieldRef: array[16] of FieldRef;        KeyRef: KeyRef;        i: Integer;    begin        RecRef.Open(RelationTableID);        KeyRef := RecRef.KeyIndex(1);        for i := 1 to KeyRef.FieldCount do begin            FieldRef[i] := KeyRef.FieldIndex(i);            FieldRef[i].Value(RelatedKeyFieldValue(ConfigPackageData, RelationTableID, FieldRef[i].Number));        end;        // even "Create Missing Codes" is marked we should not create for blank account numbers and blank/zero account categories should not be created        if ConfigPackageData."Table ID" <> 15 then begin            if RecRef.Insert() then;        end else            if (ConfigPackageData.Value <> '') and ((ConfigPackageData.Value <> '0') and (ConfigPackageData."Field ID" = 80)) or               ((PackageCode <> QBPackageCodeTxt) and (PackageCode <> MSGPPackageCodeTxt))            then                if RecRef.Insert() then;    end;    local procedure RelatedKeyFieldValue(var ConfigPackageData: Record "Config. Package Data"; TableID: Integer; FieldNo: Integer): Text[2048]    var        ConfigPackageDataOtherFields: Record "Config. Package Data";        TableRelationsMetadata: Record "Table Relations Metadata";    begin        TableRelationsMetadata.SetRange("Table ID", ConfigPackageData."Table ID");        TableRelationsMetadata.SetRange("Related Table ID", TableID);        TableRelationsMetadata.SetRange("Related Field No.", FieldNo);        if TableRelationsMetadata.FindFirst() then begin            ConfigPackageDataOtherFields.Get(              ConfigPackageData."Package Code", ConfigPackageData."Table ID", ConfigPackageData."No.", TableRelationsMetadata."Field No.");            exit(ConfigPackageDataOtherFields.Value);        end;        TableRelationsMetadata.SetRange("Table ID", TableID);        TableRelationsMetadata.SetRange("Field No.", FieldNo);        TableRelationsMetadata.SetRange("Related Table ID", ConfigPackageData."Table ID");        TableRelationsMetadata.SetRange("Related Field No.");        if TableRelationsMetadata.FindFirst() then begin            ConfigPackageDataOtherFields.Get(              ConfigPackageData."Package Code", ConfigPackageData."Table ID",              ConfigPackageData."No.", TableRelationsMetadata."Related Field No.");            exit(ConfigPackageDataOtherFields.Value);        end;        exit(ConfigPackageData.Value);    end;    local procedure GetMappingFromPKOfRelatedTable(ConfigPackageField: Record "Config. Package Field"; MappingOldValue: Text[2048]): Text[2048]    var        ConfigPackageField2: Record "Config. Package Field";        ConfigFieldMap: Record "Config. Field Map";    begin        ConfigPackageField2.SetRange("Package Code", ConfigPackageField."Package Code");        ConfigPackageField2.SetRange("Table ID", ConfigPackageField."Relation Table ID");        ConfigPackageField2.SetRange("Primary Key", true);        if ConfigPackageField2.FindFirst() then begin            ConfigFieldMap.SetCurrentKey("Package Code", "Table ID", "Field ID", "Old Value");            ConfigFieldMap.SetRange("Package Code", ConfigPackageField2."Package Code");            ConfigFieldMap.SetRange("Table ID", ConfigPackageField2."Table ID");            ConfigFieldMap.SetRange("Field ID", ConfigPackageField2."Field ID");            ConfigFieldMap.SetRange("Old Value", MappingOldValue);            if ConfigFieldMap.FindFirst() then                exit(ConfigFieldMap."New Value");        end;    end;    procedure ShowFieldMapping(ConfigPackageField: Record "Config. Package Field")    var        ConfigFieldMap: Record "Config. Field Map";        ConfigFieldMappingPage: Page "Config. Field Mapping";    begin        Clear(ConfigFieldMappingPage);        ConfigFieldMap.FilterGroup(2);        ConfigFieldMap.SetCurrentKey("Package Code", "Table ID", "Field ID", "Old Value");        ConfigFieldMap.SetRange("Package Code", ConfigPackageField."Package Code");        ConfigFieldMap.SetRange("Table ID", ConfigPackageField."Table ID");        ConfigFieldMap.SetRange("Field ID", ConfigPackageField."Field ID");        ConfigFieldMap.FilterGroup(0);        ConfigFieldMappingPage.SetTableView(ConfigFieldMap);        ConfigFieldMappingPage.RunModal();    end;    procedure IsBLOBField(TableId: Integer; FieldId: Integer): Boolean    var        "Field": Record "Field";    begin        if TypeHelper.GetField(TableId, FieldId, Field) then            exit(Field.Type = Field.Type::BLOB);        exit(false);    end;    local procedure IsBLOBFieldInternal(FieldType: Integer): Boolean    var        "Field": Record "Field";    begin        exit(FieldType = Field.Type::BLOB);    end;    local procedure EvaluateBLOBToFieldRef(var ConfigPackageData: Record "Config. Package Data"; var FieldRef: FieldRef)    begin        ConfigPackageData.CalcFields("BLOB Value");        FieldRef.Value := ConfigPackageData."BLOB Value";    end;    procedure IsMediaSetField(TableId: Integer; FieldId: Integer): Boolean    var        "Field": Record "Field";    begin        if TypeHelper.GetField(TableId, FieldId, Field) then            exit(Field.Type = Field.Type::MediaSet);        exit(false);    end;    local procedure IsMediaSetFieldInternal(FieldType: Integer): Boolean    var        "Field": Record "Field";    begin        exit(FieldType = Field.Type::MediaSet);    end;    local procedure ImportMediaSetFiles(var ConfigPackageData: Record "Config. Package Data"; var FieldRef: FieldRef; DoModify: Boolean)    var        TempConfigMediaBuffer: Record "Config. Media Buffer" temporary;        MediaSetIDConfigPackageData: Record "Config. Package Data";        BlobMediaSetConfigPackageData: Record "Config. Package Data";        BlobInStream: InStream;        MediaSetID: Text;    begin        if not CanImportMediaField(ConfigPackageData, FieldRef, DoModify, MediaSetID) then            exit;        MediaSetIDConfigPackageData.SetRange("Package Code", ConfigPackageData."Package Code");        MediaSetIDConfigPackageData.SetRange("Table ID", Database::"Config. Media Buffer");        MediaSetIDConfigPackageData.SetRange("Field ID", TempConfigMediaBuffer.FieldNo("Media Set ID"));        MediaSetIDConfigPackageData.SetRange(Value, MediaSetID);        if not MediaSetIDConfigPackageData.FindSet() then            exit;        TempConfigMediaBuffer.Init();        TempConfigMediaBuffer.Insert();        BlobMediaSetConfigPackageData.SetAutoCalcFields("BLOB Value");        repeat            BlobMediaSetConfigPackageData.Get(              MediaSetIDConfigPackageData."Package Code", MediaSetIDConfigPackageData."Table ID", MediaSetIDConfigPackageData."No.",              TempConfigMediaBuffer.FieldNo("Media Blob"));            BlobMediaSetConfigPackageData."BLOB Value".CreateInStream(BlobInStream);            TempConfigMediaBuffer."Media Set".ImportStream(BlobInStream, '');            TempConfigMediaBuffer.Modify();        until MediaSetIDConfigPackageData.Next() = 0;        FieldRef.Value := Format(TempConfigMediaBuffer."Media Set");    end;    procedure IsMediaField(TableId: Integer; FieldId: Integer): Boolean    var        "Field": Record "Field";    begin        if TypeHelper.GetField(TableId, FieldId, Field) then            exit(Field.Type = Field.Type::Media);        exit(false);    end;    local procedure IsMediaFieldInternal(FieldType: Integer): Boolean    var        "Field": Record "Field";    begin        exit(FieldType = Field.Type::Media);    end;    local procedure GetCachedConfigPackageField(ConfigPackageData: Record "Config. Package Data")    var        "Field": Record "Field";    begin        if not TempConfigPackageFieldCache.Get(ConfigPackageData."Package Code", ConfigPackageData."Table ID", ConfigPackageData."Field ID") then begin            TempConfigPackageFieldCache.Init();            TempConfigPackageFieldCache."Package Code" := ConfigPackageData."Package Code";            TempConfigPackageFieldCache."Table ID" := ConfigPackageData."Table ID";            TempConfigPackageFieldCache."Field ID" := ConfigPackageData."Field ID";            if TypeHelper.GetField(TempConfigPackageFieldCache."Table ID", TempConfigPackageFieldCache."Field ID", Field) then                TempConfigPackageFieldCache."Processing Order" := Field.Type;            TempConfigPackageFieldCache.Insert();        end;    end;    local procedure ImportMediaFiles(var ConfigPackageData: Record "Config. Package Data"; var FieldRef: FieldRef; DoModify: Boolean)    var        TempConfigMediaBuffer: Record "Config. Media Buffer" temporary;        MediaIDConfigPackageData: Record "Config. Package Data";        BlobMediaConfigPackageData: Record "Config. Package Data";        BlobInStream: InStream;        MediaID: Text;    begin        if not CanImportMediaField(ConfigPackageData, FieldRef, DoModify, MediaID) then            exit;        MediaIDConfigPackageData.SetRange("Package Code", ConfigPackageData."Package Code");        MediaIDConfigPackageData.SetRange("Table ID", Database::"Config. Media Buffer");        MediaIDConfigPackageData.SetRange("Field ID", TempConfigMediaBuffer.FieldNo("Media ID"));        MediaIDConfigPackageData.SetRange(Value, MediaID);        if not MediaIDConfigPackageData.FindFirst() then            exit;        BlobMediaConfigPackageData.SetAutoCalcFields("BLOB Value");        BlobMediaConfigPackageData.Get(          MediaIDConfigPackageData."Package Code", MediaIDConfigPackageData."Table ID", MediaIDConfigPackageData."No.",          TempConfigMediaBuffer.FieldNo("Media Blob"));        BlobMediaConfigPackageData."BLOB Value".CreateInStream(BlobInStream);        TempConfigMediaBuffer.Init();        TempConfigMediaBuffer.Media.ImportStream(BlobInStream, '');        TempConfigMediaBuffer.Insert();        FieldRef.Value := Format(TempConfigMediaBuffer.Media);    end;    local procedure CanImportMediaField(var ConfigPackageData: Record "Config. Package Data"; var FieldRef: FieldRef; DoModify: Boolean; var MediaID: Text): Boolean    var        RecRef: RecordRef;        DummyNotInitializedGuid: Guid;    begin        if not DoModify then            exit(false);        RecRef := FieldRef.Record();        if RecRef.Number = Database::"Config. Media Buffer" then            exit(false);        MediaID := Format(ConfigPackageData.Value);        if (MediaID = Format(DummyNotInitializedGuid)) or (MediaID = '') then            exit(false);        exit(true);    end;    local procedure GetRecordIDOfRecordError(var ConfigPackageData: Record "Config. Package Data"): Text    var        RecRef: RecordRef;        FieldRef: FieldRef;        KeyRef: KeyRef;        RecordID: Text;        KeyFieldCount: Integer;        KeyFieldValNotEmpty: Boolean;    begin        if not ConfigPackageData.FindSet() then            exit;        RecRef.Open(ConfigPackageData."Table ID");        KeyRef := RecRef.KeyIndex(1);        for KeyFieldCount := 1 to KeyRef.FieldCount do begin            FieldRef := KeyRef.FieldIndex(KeyFieldCount);            if not ConfigPackageData.Get(ConfigPackageData."Package Code", ConfigPackageData."Table ID", ConfigPackageData."No.",                 FieldRef.Number)            then                exit;            if ConfigPackageData.Value <> '' then                KeyFieldValNotEmpty := true;            if KeyFieldCount = 1 then                RecordID := RecRef.Name + ': ' + ConfigPackageData.Value            else                RecordID += ', ' + ConfigPackageData.Value;        end;        if not KeyFieldValNotEmpty then            exit;        exit(RecordID);    end;    local procedure IsTableErrorsExists(ConfigPackageTable: Record "Config. Package Table"): Boolean    var        ConfigPackageError: Record "Config. Package Error";    begin        if ConfigPackageTable."Table ID" = 27 then begin            ConfigPackageError.SetRange("Package Code", ConfigPackageTable."Package Code");            ConfigPackageError.SetRange("Table ID", ConfigPackageTable."Table ID");            if ConfigPackageError.Find('-') then                repeat                    if StrPos(ConfigPackageError."Error Text", 'is a duplicate item number') > 0 then                        exit(not ConfigPackageError.IsEmpty);                until ConfigPackageError.Next() = 0;        end    end;    procedure IsFieldMultiRelation(TableID: Integer; FieldID: Integer): Boolean    var        TableRelationsMetadata: Record "Table Relations Metadata";    begin        TableRelationsMetadata.SetRange("Table ID", TableID);        TableRelationsMetadata.SetRange("Field No.", FieldID);        exit(TableRelationsMetadata.Count > 1);    end;    procedure ValidateFieldRefRelationAgainstCompanyData(FieldRef: FieldRef; var ConfigPackageFieldOrder: Record "Config. Package Field"): Text[250]    begin        exit(ValidateFieldRefRelationAgainstCompanyDataAndPackage(FieldRef, ConfigPackageFieldOrder, ''));    end;    local procedure ValidateFieldRefRelationAgainstCompanyDataAndPackage(FieldRef: FieldRef; var ConfigPackageFieldOrder: Record "Config. Package Field"; PackageCode: Code[20]): Text[250];    var        ConfigTryValidate: Codeunit "Config. Try Validate";        RecRef: RecordRef;        RecRef2: RecordRef;        FieldRef2: FieldRef;    begin        RecRef := FieldRef.Record();        RecRef2.Open(RecRef.Number, true);        CopyRecRefFields(PackageCode, RecRef2, RecRef, FieldRef, ConfigPackageFieldOrder);        RecRef2.Insert();        FieldRef2 := RecRef2.Field(FieldRef.Number);        ConfigTryValidate.SetValidateParameters(FieldRef2, FieldRef.Value);        Commit();        if not ConfigTryValidate.Run() then            exit(CopyStr(GetLastErrorText, 1, 250));        exit('');    end;    local procedure CopyRecRefFields(PackageCode: Code[20]; RecRef: RecordRef; SourceRecRef: RecordRef; FieldRefToExclude: FieldRef; var ConfigPackageFieldOrder: Record "Config. Package Field")    var        FieldRef: FieldRef;        SourceFieldRef: FieldRef;    begin        ConfigPackageFieldOrder.Reset();        ConfigPackageFieldOrder.SetCurrentKey("Package Code", "Table ID", "Processing Order");        if PackageCode <> '' then            ConfigPackageFieldOrder.SetRange("Package Code", PackageCode);        ConfigPackageFieldOrder.SetRange("Table ID", RecRef.Number);        if ConfigPackageFieldOrder.FindSet() then            repeat                SourceFieldRef := SourceRecRef.Field(ConfigPackageFieldOrder."Field ID");                if FieldRefToExclude.Name = SourceFieldRef.Name then                    exit;                FieldRef := RecRef.Field(ConfigPackageFieldOrder."Field ID");                FieldRef.Value := SourceFieldRef.Value();            until ConfigPackageFieldOrder.Next() = 0;    end;    local procedure IsImportAllowed(TableId: Integer): Boolean    begin        exit(not (TableId in [Database::Microsoft.Integration.SyncEngine."Integration Table Mapping", Database::Microsoft.Integration.SyncEngine."Integration Field Mapping",                                Database::Microsoft.Integration.Entity."Sales Invoice Entity Aggregate", Database::Microsoft.Integration.Entity."Sales Order Entity Buffer",                                Database::Microsoft.Integration.Entity."Sales Quote Entity Buffer", Database::Microsoft.Integration.Entity."Sales Cr. Memo Entity Buffer",                                Database::Microsoft.Integration.Entity."Purch. Inv. Entity Aggregate", Database::Microsoft.Integration.Entity."Purch. Cr. Memo Entity Buffer"]));    end;    [EventSubscriber(ObjectType::Table, Database::"Config. Package", 'OnBeforeDeleteEvent', '', false, false)]    local procedure SendTelemetryOnDeleteConfigPackage(RunTrigger: Boolean; var Rec: Record "Config. Package")    var        Dimensions: Dictionary of [Text, Text];    begin        if Rec.IsTemporary() then            exit;        Dimensions.Add('Category', RapidStartTxt);        Dimensions.Add('PackageCode', Rec.SystemId);        Session.LogMessage('0000E3P', StrSubstNo(ConfigurationPackageDeletedMsg, Rec.SystemId), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::All, Dimensions);    end;    [IntegrationEvent(false, false)]    local procedure OnAfterApplyPackageRecords(var ConfigPackageRecord: Record "Config. Package Record"; PackageCode: Code[20]; TableNo: Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterGetKeyFieldsOrder(RecordRef: RecordRef; PackageCode: Code[20]; var TempConfigPackageField: Record "Config. Package Field" temporary; var ValidationFieldID: Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterValidatePackageDataRelation(ConfigPackageData: Record "Config. Package Data"; ConfigPackageField: Record "Config. Package Field"; var ConfigPackageTable: Record "Config. Package Table"; var RelationTableNo: Integer; var RelationFieldNo: Integer; var DataInPackageData: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeGetFieldRelationTableNo(ConfigPackageTable: Record "Config. Package Table"; var "Field": Record "Field"; var TempConfigPackageTable: Record "Config. Package Table" temporary; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeSetFieldFilter(var "Field": Record "Field"; TableID: Integer; FieldID: Integer; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeApplyPackageRecords(var ConfigPackageRecord: Record "Config. Package Record"; var PackageCode: Code[20]; var TableNo: Integer; var ApplyMode: Option; var ConfigPackageManagement: Codeunit "Config. Package Management"; var TempAppliedConfigPackageRecord: Record "Config. Package Record" temporary; var ProcessingRuleIsSet: Boolean; var TempConfigRecordForProcessing: Record "Config. Record For Processing" temporary; var ConfigTableProcessingRule: Record "Config. Table Processing Rule"; var RecordsInsertedCount: Integer; var RecordsModifiedCount: Integer; var HideDialog: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeModifyRecordDataFields(var RecRef: RecordRef; ConfigPackageRecord: Record "Config. Package Record"; DoModify: Boolean; DelayedInsert: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeSetupProcessingOrder(var ConfigPackageTable: Record "Config. Package Table"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeValidateException(TableID: Integer; FieldID: Integer; var Result: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnModifyRecordDataFieldOnBeforeEvaluateTextToFieldRef(var ConfigPackageField: Record "Config. Package Field"; var ConfigPackageData: Record "Config. Package Data"; var ConfigPackageTable: Record "Config. Package Table"; DelayedInsert: Boolean; ApplyMode: Option; FieldRef: FieldRef; var SkipEvaluate: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnModifyRecordDataFieldOnBeforeUpdateValueUsingMapping(var ConfigPackageData: Record "Config. Package Data"; var ConfigPackageField: Record "Config. Package Field"; ConfigPackageRecord: Record "Config. Package Record"; var RecordRef: RecordRef; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnModifyRecordDataFieldsOnBeforeFindConfigPackageField(var ConfigPackageField: Record "Config. Package Field"; ConfigPackageRecord: Record "Config. Package Record"; RecRef: RecordRef; DoModify: Boolean; DelayedInsert: Boolean)    begin    end;    [IntegrationEvent(false, false)]    [Scope('OnPrem')]    procedure OnPreProcessPackage(var ConfigRecordForProcessing: Record "Config. Record For Processing"; var Subscriber: Variant)    begin    end;    [IntegrationEvent(false, false)]    [Scope('OnPrem')]    procedure OnPostProcessPackage()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnModifyRecordDataFieldsOnAfterRecRefModify(var RecRef: RecordRef)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnModifyRecordDataFieldsOnAfterRecRefUpdated(var RecRef: RecordRef)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertPackageFieldOnAfterCalcSkipRelationTableID(var ConfigPackageField: Record "Config. Package Field"; var SkipRelationTableID: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertPackageFieldOnBeforeInsert(var ConfigPackageField: Record "Config. Package Field")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertPackageFieldOnBeforeValidateFieldID(var ConfigPackageField: Record "Config. Package Field")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertRecordOnBeforeInsertRecRef(var RecRef: RecordRef; ConfigPackageRecord: Record "Config. Package Record"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnModifyRecordDataFieldsOnBeforeRecRefInsert(var RecRef: RecordRef; ConfigPackageTable: Record "Config. Package Table"; var IsHandled: Boolean; ConfigPackageRecord: Record "Config. Package Record")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnModifyRecordDataFieldsOnBeforeRecRefModify(var RecRef: RecordRef; ConfigPackageTable: Record "Config. Package Table"; var RecordsModifiedCount: Integer; var IsHandled: Boolean; ConfigPackageRecord: Record "Config. Package Record")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnModifyRecordDataFieldOnAfterGetCachedConfigPackageField(var RecordRef: RecordRef; var FieldRef: FieldRef; var ConfigPackageField: Record "Config. Package Field"; var ConfigPackageData: Record "Config. Package Data"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnApplyPackageOnBeforeCleanPackageErrors(var ConfigPackage: Record "Config. Package"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnApplyPackageTablesOnFilterConfigPackageRecord(var ConfigPackage: Record "Config. Package"; var ConfigPackageRecord: Record "Config. Package Record")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertPackageRecordOnAfterDelayedInsert(var RecordRef: RecordRef; ConfigPackageRecord: Record "Config. Package Record"; ConfigPackageTable: Record "Config. Package Table"; var ApplyMode: Option; DelayedInsert: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertPrimaryKeyFieldsOnBeforeUpdateValueUsingMapping(var RecordRef: RecordRef; ConfigPackageData: Record "Config. Package Data"; var ConfigPackageField: Record "Config. Package Field"; ConfigPackageRecord: Record "Config. Package Record"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnApplyPackageOnAfterCommit(var ConfigPackageTable: Record "Config. Package Table")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAddConfigTablesOnBeforeSetSkipTableTriggers(var ConfigPackageTable: Record "Config. Package Table"; var PackageCode: Code[20])    begin    end;}