Codeunit 1180 Data Privacy Mgmt

Base Application, System.Privacy

src/Layers/W1/BaseApp/DataPrivacyMgmt.Codeunit.al665 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace System.Privacy;using Microsoft.CRM.Contact;using Microsoft.CRM.Interaction;using Microsoft.CRM.Team;using Microsoft.HumanResources.Employee;using Microsoft.Integration.Entity;using Microsoft.Projects.Resources.Resource;using Microsoft.Purchases.Archive;using Microsoft.Purchases.Document;using Microsoft.Purchases.History;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Archive;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;using Microsoft.Sales.History;using Microsoft.Utilities;using System.Diagnostics;using System.Environment;using System.Globalization;using System.IO;using System.Reflection;using System.Security.AccessControl;using System.Security.User;codeunit 1180 "Data Privacy Mgmt"{    trigger OnRun()    var        ActivityLog: Record "Activity Log";        ActivityLogPage: Page "Activity Log";    begin        Clear(ActivityLogPage);        ActivityLog.FilterGroup(2);        ActivityLog.SetRange(Context, ActivityContextTxt);        ActivityLog.FilterGroup(0);        ActivityLogPage.SetTableView(ActivityLog);        ActivityLogPage.Run();    end;    var        ConfigProgressBar: Codeunit "Config. Progress Bar";        TypeHelper: Codeunit "Type Helper";        ProgressBarText: Text;        ActivityContextTxt: Label 'Privacy Activity';        CreatingFieldDataTxt: Label 'Creating field data...';        RemovingConfigPackageTxt: Label 'Removing config package...';        ConfigDeleteStatusTxt: Label 'records.';    procedure CreateData(EntityTypeTableNo: Integer; EntityNo: Code[50]; var PackageCode: Code[20]; ActionType: Option "Export a data subject's data","Create a data privacy configuration package"; DataSensitivityOption: Option Sensitive,Personal,"Company Confidential",Normal,Unclassified)    var        RecRef: RecordRef;    begin        if EntityTypeTableNo in           [DATABASE::Customer, DATABASE::Vendor, DATABASE::Contact, DATABASE::Resource,            DATABASE::Employee, DATABASE::"Salesperson/Purchaser"]        then begin            if GetRecRefForPrivacyMasterTable(RecRef, EntityTypeTableNo, EntityNo) then                CreateRelatedData(RecRef, EntityTypeTableNo, EntityNo, PackageCode, ActionType, DataSensitivityOption);        end else            if EntityTypeTableNo = DATABASE::User then begin                if GetRecRefForUserTable(RecRef, EntityNo) then                    CreateRelatedData(RecRef, DATABASE::"User Setup", EntityNo, PackageCode, ActionType, DataSensitivityOption);            end else                OnCreateData(EntityTypeTableNo, EntityNo, PackageCode, ActionType, DataSensitivityOption);    end;    local procedure GetRecRefForPrivacyMasterTable(var RecRef: RecordRef; EntityTypeTableNo: Integer; EntityNo: Code[50]): Boolean    var        TempDataPrivacyEntities: Record "Data Privacy Entities" temporary;        DataClassificationMgt: Codeunit "Data Classification Mgt.";    begin        DataClassificationMgt.RaiseOnGetDataPrivacyEntities(TempDataPrivacyEntities);        if TempDataPrivacyEntities.Get(EntityTypeTableNo) then begin            RecRef.Open(EntityTypeTableNo);            RecRefGet(RecRef, TempDataPrivacyEntities."Key Field No.", Format(EntityNo, 20));            if RecRef.FindFirst() then                exit(true);        end;    end;    local procedure GetRecRefForUserTable(var RecRef: RecordRef; EntityNo: Code[50]): Boolean    var        User: Record User;        UserRecRef: RecordRef;        FieldRef: FieldRef;        UserNameFieldNo: Integer;    begin        // Find the user with "User Name" EntityNo        UserNameFieldNo := User.FieldNo("User Name");        UserRecRef.Open(DATABASE::User);        FieldRef := UserRecRef.Field(UserNameFieldNo);        FieldRef.SetRange(EntityNo);        // If the user exists, create related data using the User Setup table        if UserRecRef.FindFirst() then begin            RecRef.Open(DATABASE::"User Setup");            RecRefGet(RecRef, 1, EntityNo);            if RecRef.FindFirst() then                exit(true);        end;    end;    procedure CreateRelatedData(var RecRef: RecordRef; EntityTypeTableNo: Integer; EntityNo: Code[50]; var PackageCode: Code[20]; ActionType: Option "Export a data subject's data","Create a data privacy configuration package"; DataSensitivityOption: Option Sensitive,Personal,"Company Confidential",Normal,Unclassified)    var        ConfigPackage: Record "Config. Package";        PackageName: Text[50];    begin        PackageCode := GetPackageCode(EntityTypeTableNo, EntityNo, ActionType);        PackageName := CopyStr(StrSubstNo('Privacy Package for %1 %2',              Format(RecRef.Caption, 10), DelChr(Format(EntityNo, 20), '<', ' ')), 1, 50);        if ConfigPackage.Get(PackageCode) then begin            if ActionType = ActionType::"Export a data subject's data" then                // Recreate the package if they chose the option to create the config package or are using the "temp" config package,                // otherwise use the one already created                if StrPos(PackageCode, '*') = 0 then                    exit;            DeletePackage(PackageCode);        end;        CreatePackage(RecRef.Number, EntityTypeTableNo, EntityNo, PackageCode, PackageName, DataSensitivityOption);    end;    procedure GetPackageCode(EntityTypeTableNo: Integer; EntityNo: Code[50]; ActionType: Option "Export a data subject's data","Create a data privacy configuration package"): Code[20]    var        ConfigPackage: Record "Config. Package";        PackageCodeTemp: Code[20];        PackageCodePerm: Code[20];    begin        if EntityTypeTableNo in           [DATABASE::Customer, DATABASE::Vendor, DATABASE::Contact, DATABASE::Resource,            DATABASE::Employee, DATABASE::"Salesperson/Purchaser", DATABASE::"User Setup"]        then            GetPermAndTempPackageCodes(PackageCodePerm, PackageCodeTemp, EntityTypeTableNo, EntityNo)        else            OnAfterGetPackageCode(EntityTypeTableNo, EntityNo, ActionType, PackageCodeTemp, PackageCodePerm);        if ActionType = ActionType::"Create a data privacy configuration package" then            exit(PackageCodePerm);        if ConfigPackage.Get(PackageCodePerm) then            exit(PackageCodePerm);        exit(PackageCodeTemp);    end;    local procedure GetShortenedEntityNo(EntityNo: Code[50]): Code[17]    begin        if StrLen(EntityNo) <= 17 then            exit(CopyStr(EntityNo, 1, StrLen(EntityNo)));        exit(CopyStr(EntityNo, StrLen(EntityNo) - 16, 17));    end;    local procedure GetPermAndTempPackageCodes(var PackageCodePerm: Code[20]; var PackageCodeTemp: Code[20]; EntityTypeTableNo: Integer; EntityNo: Code[50])    var        TableName: Text;        ShortenedEntityNo: Code[17];    begin        TableName := GetTableName(EntityTypeTableNo);        ShortenedEntityNo := GetShortenedEntityNo(EntityNo);        PackageCodePerm := StrSubstNo('%1%2', CopyStr(TableName, 1, 3), ShortenedEntityNo);        PackageCodeTemp := StrSubstNo('%1*%2', CopyStr(TableName, 1, 2), ShortenedEntityNo);    end;    local procedure GetTableName(TableNo: Integer): Text    var        AllObjWithCaption: Record AllObjWithCaption;    begin        if AllObjWithCaption.Get(AllObjWithCaption."Object Type"::Table, TableNo) then            exit(AllObjWithCaption."Object Name");    end;    procedure DeletePackage(PackageCode: Code[20])    var        ConfigPackage: Record "Config. Package";    begin        ConfigProgressBar.Init(4, 1, RemovingConfigPackageTxt);        ProgressBarText := Format(ConfigPackage.TableCaption()) + ' ' + ConfigDeleteStatusTxt;        ConfigProgressBar.Update(ProgressBarText);        ConfigPackage.SetRange(Code, PackageCode);        ConfigPackage.DeleteAll(true);        ConfigProgressBar.Close();    end;    [Scope('OnPrem')]    procedure CreatePackage(TableNo: Integer; EntityTypeTableNo: Integer; EntityNo: Code[50]; PackageCode: Code[20]; PackageName: Code[50]; DataSensitivityOption: Option Sensitive,Personal,"Company Confidential",Normal,Unclassified)    var        ConfigPackage: Record "Config. Package";        ProcessingOrder: Integer;        EntityKeyField: Integer;    begin        GetPrivacyEntityKeyFieldAndTableNo(EntityKeyField, EntityTypeTableNo);        CreateConfigPackage(ConfigPackage, PackageCode, PackageName);        CreatePackageTable(PackageCode, EntityTypeTableNo);        CreatePackageFieldsAndFiltersForPrimaryKeys(PackageCode, EntityTypeTableNo, EntityKeyField, EntityNo, ProcessingOrder);        CreatePackageFieldsForDataSensitiveFields(PackageCode, TableNo, DataSensitivityOption, ProcessingOrder);        CreateDataForRelatedTables(ConfigPackage, TableNo, EntityKeyField, EntityNo, DataSensitivityOption, ProcessingOrder);        CreateDataForChangeLogEntries(PackageCode, EntityNo, EntityTypeTableNo);    end;    [Scope('OnPrem')]    procedure GetPrivacyEntityKeyFieldAndTableNo(var EntityKeyField: Integer; var EntityTypeTableNo: Integer)    var        TempDataPrivacyEntities: Record "Data Privacy Entities" temporary;        DataClassificationMgt: Codeunit "Data Classification Mgt.";    begin        DataClassificationMgt.RaiseOnGetDataPrivacyEntities(TempDataPrivacyEntities);        if EntityTypeTableNo = DATABASE::"User Setup" then            EntityTypeTableNo := DATABASE::User;        if TempDataPrivacyEntities.Get(EntityTypeTableNo) then            if EntityTypeTableNo = DATABASE::User then begin                EntityKeyField := 1;                EntityTypeTableNo := DATABASE::"User Setup";            end else                EntityKeyField := TempDataPrivacyEntities."Key Field No.";    end;    local procedure CreatePackageFieldsAndFiltersForPrimaryKeys(PackageCode: Code[20]; EntityTypeTableNo: Integer; EntityKeyField: Integer; EntityNo: Code[50]; var ProcessingOrder: Integer)    var        RecRef: RecordRef;        FieldRef: FieldRef;        FieldIndex: Integer;        IndicesFound: Integer;        AreAllIndicesFound: Boolean;        FieldCount: Integer;    begin        RecRef.Open(EntityTypeTableNo);        FieldCount := RecRef.FieldCount;        for FieldIndex := 1 to FieldCount do begin            FieldRef := RecRef.FieldIndex(FieldIndex);            if IsInPrimaryKey(FieldRef, IndicesFound, AreAllIndicesFound) then begin                ProcessingOrder += 1;                CreatePackageField(PackageCode, EntityTypeTableNo, FieldRef.Number, ProcessingOrder);                CreatePackageFilter(PackageCode, EntityTypeTableNo, EntityKeyField, Format(EntityNo));                if AreAllIndicesFound then begin                    RecRef.Close();                    exit;                end;            end;        end;    end;    local procedure CreatePackageFieldsForPrimaryKeys(PackageCode: Code[20]; EntityTypeTableNo: Integer; var ProcessingOrder: Integer)    var        RecRef: RecordRef;        FieldRef: FieldRef;        FieldIndex: Integer;        IndicesFound: Integer;        AreAllIndicesFound: Boolean;        FieldCount: Integer;    begin        RecRef.Open(EntityTypeTableNo);        FieldCount := RecRef.FieldCount;        for FieldIndex := 1 to FieldCount do begin            FieldRef := RecRef.FieldIndex(FieldIndex);            if IsInPrimaryKey(FieldRef, IndicesFound, AreAllIndicesFound) then begin                ProcessingOrder += 1;                CreatePackageField(PackageCode, EntityTypeTableNo, FieldRef.Number, ProcessingOrder);                if AreAllIndicesFound then begin                    RecRef.Close();                    exit;                end;            end;        end;    end;    local procedure CreatePackageFieldsForDataSensitiveFields(PackageCode: Code[20]; TableNo: Integer; DataSensitivityOption: Option Sensitive,Personal,"Company Confidential",Normal,Unclassified; var ProcessingOrder: Integer)    var        DataSensitivity: Record "Data Sensitivity";    begin        FilterDataSensitivityByDataSensitivityOption(DataSensitivity, TableNo, DataSensitivityOption);        if DataSensitivity.FindSet() then begin            CreatePackageTable(PackageCode, DataSensitivity."Table No");            repeat                ProcessingOrder += 1;                CreatePackageField(PackageCode, DataSensitivity."Table No", DataSensitivity."Field No", ProcessingOrder);            until DataSensitivity.Next() = 0;        end;    end;    local procedure CreateDataForRelatedTables(ConfigPackage: Record "Config. Package"; TableNo: Integer; EntityKeyField: Integer; EntityNo: Code[50]; DataSensitivityOption: Option Sensitive,Personal,"Company Confidential",Normal,Unclassified; var ProcessingOrder: Integer)    var        TableRelationsMetadata: Record "Table Relations Metadata";    begin        GetRelatedFields(TableRelationsMetadata, TableNo, EntityKeyField);        ConfigProgressBar.Init(TableRelationsMetadata.Count, 1, CreatingFieldDataTxt);        if TableRelationsMetadata.FindSet() then            CreateRelatedDataFields(TableRelationsMetadata, ConfigPackage, EntityNo, DataSensitivityOption, ProcessingOrder);        ConfigProgressBar.Close();    end;    local procedure CreateRelatedDataFields(var TableRelationsMetadata: Record "Table Relations Metadata"; var ConfigPackage: Record "Config. Package"; EntityNo: Code[50]; DataSensitivityOption: Option Sensitive,Personal,"Company Confidential",Normal,Unclassified; var ProcessingOrder: Integer)    var        DataClassificationMgt: Codeunit "Data Classification Mgt.";        FilterCreated: Boolean;        CurrentTableID: Integer;    begin        CurrentTableID := 0;        repeat            if DataClassificationMgt.IsSupportedTable(TableRelationsMetadata."Table ID") then begin                ConfigProgressBar.Update(TableRelationsMetadata.TableName);                FilterCreated := CreatePackageFilter(ConfigPackage.Code,                    TableRelationsMetadata."Table ID", TableRelationsMetadata."Field No.", EntityNo);                if FilterCreated then begin                    if CurrentTableID <> TableRelationsMetadata."Table ID" then begin                        CurrentTableID := TableRelationsMetadata."Table ID";                        CreatePackageTable(ConfigPackage.Code, TableRelationsMetadata."Table ID");                        CreatePackageFieldsForPrimaryKeys(ConfigPackage.Code, TableRelationsMetadata."Table ID", ProcessingOrder);                        CreatePackageFieldsForDataSensitiveFields(                            ConfigPackage.Code, TableRelationsMetadata."Table ID", DataSensitivityOption, ProcessingOrder);                    end;                    ProcessingOrder += 1;                    CreatePackageField(                        ConfigPackage.Code, TableRelationsMetadata."Table ID", TableRelationsMetadata."Field No.", ProcessingOrder);                end;            end;        until TableRelationsMetadata.Next() = 0;    end;    [Scope('OnPrem')]    procedure CreateConfigPackage(var ConfigPackage: Record "Config. Package"; PackageCode: Code[20]; PackageName: Text[50])    var        Language: Codeunit Language;        ApplicationSystemConstants: Codeunit "Application System Constants";    begin        ConfigPackage.Init();        ConfigPackage.Code := PackageCode;        ConfigPackage."Package Name" := PackageName;        ConfigPackage."Language ID" := Language.GetDefaultApplicationLanguageId();        ConfigPackage."Product Version" :=          CopyStr(ApplicationSystemConstants.ApplicationVersion(), 1, StrLen(ConfigPackage."Product Version"));        if not ConfigPackage.Insert() then;    end;    [Scope('OnPrem')]    procedure CreatePackageTable(PackageCode: Code[20]; TableId: Integer)    begin        InsertPackageTable(PackageCode, TableId, false);  // Do NOT fire the trigger as it will create the ConfigPackageField    end;    [Scope('OnPrem')]    procedure InsertPackageTable(PackageCode: Code[20]; TableId: Integer; FireInsertTrigger: Boolean)    var        ConfigPackageTable: Record "Config. Package Table";    begin        ConfigPackageTable.Init();        ConfigPackageTable."Package Code" := PackageCode;        ConfigPackageTable.Validate("Table ID", TableId);        ConfigPackageTable."Cross-Column Filter" := true;        if not ConfigPackageTable.Insert(FireInsertTrigger) then;    end;    [Scope('OnPrem')]    procedure CreatePackageField(ConfigPackageCode: Code[20]; TableId: Integer; FieldId: Integer; ProcessingOrder: Integer): Boolean    var        ConfigPackageField: Record "Config. Package Field";        "Field": Record "Field";    begin        if IsValidField(TableId, FieldId, Field) then begin            InitPackageField(ConfigPackageField, Field, ConfigPackageCode, TableId, ProcessingOrder, FieldId);            exit(ConfigPackageField.Insert(true));        end;    end;    local procedure InitPackageField(var ConfigPackageField: Record "Config. Package Field"; var "Field": Record "Field"; PackageCode: Code[20]; TableId: Integer; ProcessingOrder: Integer; FieldId: Integer)    begin        ConfigPackageField.Init();        ConfigPackageField."Package Code" := PackageCode;        ConfigPackageField."Table ID" := TableId;        ConfigPackageField.Validate("Field Name", Field.FieldName);        ConfigPackageField."Field Caption" := Field."Field Caption";        ConfigPackageField."Field ID" := FieldId;        ConfigPackageField."Processing Order" := ProcessingOrder;        ConfigPackageField.Validate("Validate Field", true);        ConfigPackageField.Validate("Include Field", true);    end;    [Scope('OnPrem')]    procedure CreatePackageFilter(ConfigPackageCode: Code[20]; TableId: Integer; EntityKeyField: Integer; FieldValue: Text[250]): Boolean    var        "Field": Record "Field";        ConfigPackage: Record "Config. Package";    begin        if ConfigPackage.Get(ConfigPackageCode) then            if TypeHelper.GetField(TableId, EntityKeyField, Field) then                if (Field.Class = Field.Class::Normal) and                   ((Field.Type = Field.Type::Integer) or (Field.Type = Field.Type::Text) or                    (Field.Type = Field.Type::Code) or (Field.Type = Field.Type::Option))                then begin                    FieldValue := GetPackageFilter(TableId, FieldValue);                    exit(InsertPackageFilter(ConfigPackageCode, TableId, EntityKeyField, FieldValue));                end;    end;    local procedure GetPackageFilter(TableNo: Integer; FieldValue: Text[250]): Text[250]    var        ContactPerson: Record Contact;        ContactCompany: Record Contact;    begin        if IsContactPersonTable(TableNo) then begin            if ContactPerson.Get(Format(FieldValue, 20)) then // FieldValue is the EntityNo for this method                if ContactCompany.Get(ContactPerson."Company No.") then                    FieldValue := FieldValue + ' | ' + ContactCompany."No.";        end else            OnGetPackageFilterTableNoCaseElse(TableNo, FieldValue);        exit(FieldValue);    end;    local procedure IsContactPersonTable(TableNo: Integer) Result: Boolean    begin        Result :=            TableNo in [                        DATABASE::Contact,                        DATABASE::"Contact Alt. Address",                        DATABASE::"Sales Header",                        DATABASE::"Purchase Header",                        DATABASE::"Sales Shipment Header",                        DATABASE::"Sales Invoice Header",                        DATABASE::"Sales Cr.Memo Header",                        DATABASE::"Purch. Rcpt. Header",                        DATABASE::"Purch. Inv. Header",                        Database::"Purch. Cr. Memo Entity Buffer",                        DATABASE::"Purch. Cr. Memo Hdr.",                        DATABASE::"Sales Header Archive",                        DATABASE::"Purchase Header Archive",                        DATABASE::"Sales Invoice Entity Aggregate",                        DATABASE::"Sales Order Entity Buffer",                        DATABASE::"Sales Quote Entity Buffer",                        DATABASE::"Sales Cr. Memo Entity Buffer",                        DATABASE::"Return Shipment Header",                        DATABASE::"Return Receipt Header",                        DATABASE::"Interaction Log Entry"                       ];        OnAfterIsContactPersonTable(TableNo, Result);    end;    local procedure InsertPackageFilter(PackageCode: Code[20]; TableId: Integer; FieldId: Integer; FieldFilter: Text[250]): Boolean    var        ConfigPackageFilter: Record "Config. Package Filter";    begin        ConfigPackageFilter.Init();        ConfigPackageFilter."Package Code" := PackageCode;        ConfigPackageFilter."Table ID" := TableId;        ConfigPackageFilter.Validate("Field ID", FieldId);        ConfigPackageFilter.Validate("Field Filter", FieldFilter);        exit(ConfigPackageFilter.Insert());    end;    [Scope('OnPrem')]    procedure CreateDataForChangeLogEntries(PackageCode: Code[20]; EntityNo: Code[50]; EntityTableID: Integer)    var        ConfigPackage: Record "Config. Package";        ConfigPackageTable: Record "Config. Package Table";        ChangeLogEntry: Record "Change Log Entry";    begin        if ConfigPackage.Get(PackageCode) then begin            // Create package table for Change Log table (405) and fire the insert trigger            // as it will create the ConfigPackageField            InsertPackageTable(PackageCode, DATABASE::"Change Log Entry", true);            // Change Log Entry filters must be AND'd together, not OR'd (Cross-Column Filter).            // With Cross-Column Filter enabled, the query becomes: "Table No." = X OR "Primary Key Field 1 Value" = Y            // which returns almost all records in tables with millions of entries, causing timeouts.            // Disabling Cross-Column Filter ensures the query is: "Table No." = X AND "Primary Key Field 1 Value" = Y            if ConfigPackageTable.Get(PackageCode, DATABASE::"Change Log Entry") then begin                ConfigPackageTable."Cross-Column Filter" := false;                ConfigPackageTable.Modify();            end;            // Create package filter for Table No = Change Log table (405) AND Primary key Field 1 value = Entity No            InsertPackageFilter(PackageCode, DATABASE::"Change Log Entry",              ChangeLogEntry.FieldNo("Table No."), Format(EntityTableID));            InsertPackageFilter(PackageCode, DATABASE::"Change Log Entry",              ChangeLogEntry.FieldNo("Primary Key Field 1 Value"), Format(EntityNo));        end;    end;    procedure SetPrivacyBlocked(EntityTypeTableNo: Integer; EntityNo: Code[50])    var        Customer: Record Customer;        Vendor: Record Vendor;        Contact: Record Contact;        Resource: Record Resource;        Employee: Record Employee;        SalespersonPurchaser: Record "Salesperson/Purchaser";    begin        case EntityTypeTableNo of            DATABASE::Customer:                SetPrivacyBlockedForPrivacyEntity(DATABASE::Customer, Customer.FieldNo("Privacy Blocked"), EntityNo);            DATABASE::Vendor:                SetPrivacyBlockedForPrivacyEntity(DATABASE::Vendor, Vendor.FieldNo("Privacy Blocked"), EntityNo);            DATABASE::Contact:                SetPrivacyBlockedForPrivacyEntity(DATABASE::Contact, Contact.FieldNo("Privacy Blocked"), EntityNo);            DATABASE::Resource:                SetPrivacyBlockedForPrivacyEntity(DATABASE::Resource, Resource.FieldNo("Privacy Blocked"), EntityNo);            DATABASE::Employee:                SetPrivacyBlockedForPrivacyEntity(DATABASE::Employee, Employee.FieldNo("Privacy Blocked"), EntityNo);            DATABASE::"Salesperson/Purchaser":                SetPrivacyBlockedForPrivacyEntity(DATABASE::"Salesperson/Purchaser",                  SalespersonPurchaser.FieldNo("Privacy Blocked"), EntityNo);            else                OnAfterSetPrivacyBlocked(EntityTypeTableNo, EntityNo);        end;    end;    local procedure SetPrivacyBlockedForPrivacyEntity(TableNo: Integer; PrivacyBlockedFieldNo: Integer; EntityNo: Code[50])    var        RecRef: RecordRef;        PrivacyBlockedFieldRef: FieldRef;    begin        RecRef.Open(TableNo);        RecRefGet(RecRef, 1, EntityNo);        if RecRef.FindFirst() then begin            PrivacyBlockedFieldRef := RecRef.Field(PrivacyBlockedFieldNo);            PrivacyBlockedFieldRef.Validate(true);            RecRef.Modify();        end;    end;    local procedure IsInPrimaryKey(FieldRef: FieldRef; var IndicesFound: Integer; var AreAllIndicesFound: Boolean): Boolean    var        RecRef: RecordRef;        KeyRef: KeyRef;        FieldIndex: Integer;        NumberOfKeys: Integer;    begin        RecRef := FieldRef.Record();        KeyRef := RecRef.KeyIndex(1);        NumberOfKeys := KeyRef.FieldCount;        for FieldIndex := 1 to NumberOfKeys do            if KeyRef.FieldIndex(FieldIndex).Number = FieldRef.Number then begin                IndicesFound += 1;                if IndicesFound = NumberOfKeys then                    AreAllIndicesFound := true;                exit(true);            end;        exit(false);    end;    local procedure IsValidField(TableId: Integer; FieldId: Integer; var "Field": Record "Field"): Boolean    begin        if TypeHelper.GetField(TableId, FieldId, Field) then            if (not ((Field.Type = Field.Type::Media) or                     (Field.Type = Field.Type::MediaSet) or (Field.Type = Field.Type::BLOB) or (Field.Type = Field.Type::GUID))) and               (Field.Class = Field.Class::Normal)            then                exit(true);    end;    local procedure GetRelatedFields(var TableRelationsMetadata: Record "Table Relations Metadata"; TableId: Integer; EntityKeyField: Integer)    begin        TableRelationsMetadata.Reset();        TableRelationsMetadata.SetRange("Related Table ID", TableId);        TableRelationsMetadata.SetRange("Related Field No.", EntityKeyField);        TableRelationsMetadata.SetRange("Validate Table Relation", true);        TableRelationsMetadata.SetRange("Condition Field No.", 0);        TableRelationsMetadata.SetFilter("Table ID", '<>%1', TableId);    end;    [Scope('OnPrem')]    procedure FilterDataSensitivityByDataSensitivityOption(var DataSensitivity: Record "Data Sensitivity"; TableID: Integer; DataSensitivityOption: Option Sensitive,Personal,"Company Confidential",Normal,Unclassified)    begin        DataSensitivity.Reset();        DataSensitivity.SetRange("Company Name", CompanyName);        DataSensitivity.SetRange("Table No", TableID);        case DataSensitivityOption of            DataSensitivityOption::Sensitive:                DataSensitivity.SetFilter("Data Sensitivity", '%1', DataSensitivity."Data Sensitivity"::Sensitive);            DataSensitivityOption::Personal:                DataSensitivity.SetFilter("Data Sensitivity", '%1|%2',                  DataSensitivity."Data Sensitivity"::Sensitive,                  DataSensitivity."Data Sensitivity"::Personal);            DataSensitivityOption::"Company Confidential":                DataSensitivity.SetFilter("Data Sensitivity", '%1|%2|%3',                  DataSensitivity."Data Sensitivity"::Sensitive,                  DataSensitivity."Data Sensitivity"::Personal,                  DataSensitivity."Data Sensitivity"::"Company Confidential");            DataSensitivityOption::Normal:                DataSensitivity.SetFilter("Data Sensitivity", '%1|%2|%3|%4',                  DataSensitivity."Data Sensitivity"::Sensitive,                  DataSensitivity."Data Sensitivity"::Personal,                  DataSensitivity."Data Sensitivity"::"Company Confidential",                  DataSensitivity."Data Sensitivity"::Normal);            DataSensitivityOption::Unclassified:                DataSensitivity.SetFilter("Data Sensitivity", '%1', DataSensitivity."Data Sensitivity"::Unclassified);        end;    end;    [Scope('OnPrem')]    procedure RecRefGet(var RecRef: RecordRef; PrimaryKeyFieldNo: Integer; "Filter": Text)    var        FieldRef: FieldRef;    begin        FieldRef := RecRef.Field(PrimaryKeyFieldNo);        FieldRef.SetRange(Filter);    end;    [IntegrationEvent(false, false)]    local procedure OnCreateData(EntityTypeTableNo: Integer; EntityNo: Code[50]; var PackageCode: Code[20]; ActionType: Option "Export a data subject's data","Create a data privacy configuration package"; DataSensitivityOption: Option Sensitive,Personal,"Company Confidential",Normal,Unclassified)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetPackageFilterTableNoCaseElse(TableNo: Integer; var FieldValue: Text[250])    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterGetPackageCode(EntityTypeTableNo: Integer; EntityNo: Code[50]; ActionType: Option "Export a data subject's data","Create a data privacy configuration package"; var PackageCodeTemp: Code[20]; var PackageCodeKeep: Code[20])    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterSetPrivacyBlocked(EntityTypeTableNo: Integer; EntityNo: Code[50])    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterIsContactPersonTable(TableNo: Integer; var Result: Boolean);    begin    end;}