Table 483 Change Global Dim. Log Entry

Base Application, Microsoft.Finance.Dimension

src/Layers/W1/BaseApp/Finance/Dimension/ChangeGlobalDimLogEntry.Table.al770 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Finance.Dimension;using Microsoft.Bank.Ledger;using Microsoft.Finance.GeneralLedger.Ledger;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.FixedAssets.Insurance;using Microsoft.FixedAssets.Ledger;using Microsoft.FixedAssets.Maintenance;using Microsoft.HumanResources.Payables;using Microsoft.Inventory.Counting.Journal;using Microsoft.Inventory.History;using Microsoft.Inventory.Ledger;using Microsoft.Projects.Project.Job;using Microsoft.Projects.Project.Ledger;using Microsoft.Projects.Project.WIP;using Microsoft.Projects.Resources.Ledger;using Microsoft.Purchases.History;using Microsoft.Purchases.Payables;using Microsoft.Sales.FinanceCharge;using Microsoft.Sales.History;using Microsoft.Sales.Receivables;using Microsoft.Sales.Reminder;using System.Environment;using System.Reflection;using System.Threading;/// <summary>/// Logs the progress and status of the Change Global Dimensions background process./// Tracks table-by-table progress, error counts, and processing statistics for dimension restructuring operations./// </summary>/// <remarks>/// Used by the Change Global Dimensions functionality to monitor multi-table dimension updates./// Provides audit trail and progress tracking for critical dimension restructuring operations./// Integrates with session management and background task processing systems./// </remarks>table 483 "Change Global Dim. Log Entry"{    Caption = 'Change Global Dim. Log Entry';    Permissions = TableData "G/L Entry" = rm,                  TableData "Cust. Ledger Entry" = rm,                  TableData "Vendor Ledger Entry" = rm,                  TableData "Item Ledger Entry" = rm,                  TableData "Sales Shipment Header" = rm,                  TableData "Sales Shipment Line" = rm,                  TableData "Sales Invoice Header" = rm,                  TableData "Sales Invoice Line" = rm,                  TableData "Sales Cr.Memo Header" = rm,                  TableData "Sales Cr.Memo Line" = rm,                  TableData "Purch. Rcpt. Header" = rm,                  TableData "Purch. Rcpt. Line" = rm,                  TableData "Purch. Inv. Header" = rm,                  TableData "Purch. Inv. Line" = rm,                  TableData "Purch. Cr. Memo Hdr." = rm,                  TableData "Purch. Cr. Memo Line" = rm,                  TableData "Job Ledger Entry" = rm,                  TableData "Res. Ledger Entry" = rm,                  TableData "Bank Account Ledger Entry" = rm,                  TableData "Phys. Inventory Ledger Entry" = rm,                  TableData "Issued Reminder Header" = rm,                  TableData "Issued Fin. Charge Memo Header" = rm,                  TableData "Detailed Cust. Ledg. Entry" = rm,                  TableData "Detailed Vendor Ledg. Entry" = rm,                  TableData "Job WIP G/L Entry" = rm,                  TableData "Employee Ledger Entry" = rm,                  TableData "Detailed Employee Ledger Entry" = rm,#if not CLEAN28                  TableData Microsoft.Manufacturing.Document."Production Order" = rm,                  TableData Microsoft.Manufacturing.Document."Prod. Order Line" = rm,                  TableData Microsoft.Manufacturing.Document."Prod. Order Component" = rm,                  TableData Microsoft.Manufacturing.Document."Prod. Order Routing Line" = rm,                  TableData Microsoft.Manufacturing.Document."Prod. Order Capacity Need" = rm,                  TableData Microsoft.Manufacturing.Document."Prod. Order Routing Tool" = rm,                  TableData Microsoft.Manufacturing.Document."Prod. Order Routing Personnel" = rm,                  TableData Microsoft.Manufacturing.Document."Prod. Order Rtng Qlty Meas." = rm,                  TableData Microsoft.Manufacturing.Document."Prod. Order Comment Line" = rm,                  TableData Microsoft.Manufacturing.Document."Prod. Order Rtng Comment Line" = rm,                  TableData Microsoft.Manufacturing.Document."Prod. Order Comp. Cmt Line" = rm,#endif                  TableData "Invt. Receipt Header" = rm,                  TableData "Invt. Receipt Line" = rm,                  TableData "Invt. Shipment Header" = rm,                  TableData "Invt. Shipment Line" = rm,                  TableData "FA Ledger Entry" = rm,                  TableData "Maintenance Ledger Entry" = rm,                  TableData "Ins. Coverage Ledger Entry" = rm,                  TableData "Value Entry" = rm,                  TableData Microsoft.Manufacturing.Capacity."Capacity Ledger Entry" = rm,#if not CLEAN28                  TableData Microsoft.Service.Document."Service Header" = rm,                  TableData Microsoft.Service.Document."Service Line" = rm,                  TableData Microsoft.Service.Document."Service Item Line" = rm,                  TableData Microsoft.Service.Ledger."Service Ledger Entry" = rm,                  TableData Microsoft.Service.Contract."Service Contract Header" = rm,                  TableData Microsoft.Service.Contract."Service Contract Line" = rm,                  TableData Microsoft.Service.History."Service Invoice Line" = rm,                  tabledata Microsoft.Service.History."Service Cr.Memo Header" = rm,                  tabledata Microsoft.Service.History."Service Cr.Memo Line" = rm,                  tabledata Microsoft.Service.History."Service Invoice Header" = rm,                  tabledata Microsoft.Service.History."Service Shipment Header" = rm,                  tabledata Microsoft.Service.History."Service Shipment Line" = rm,                  TableData Microsoft.Service.Contract."Filed Service Contract Header" = rm,#endif                  TableData "Return Shipment Header" = rm,                  TableData "Return Shipment Line" = rm,                  TableData "Return Receipt Header" = rm,                  TableData "Return Receipt Line" = rm;    ReplicateData = true;    DataClassification = CustomerContent;    fields    {        /// <summary>        /// Unique identifier of the table being processed during dimension change operation.        /// </summary>        field(1; "Table ID"; Integer)        {            Caption = 'Table ID';        }        /// <summary>        /// Name of the table being processed for display purposes.        /// </summary>        field(2; "Table Name"; Text[50])        {            Caption = 'Table Name';        }        /// <summary>        /// Total number of records in the table that need to be processed.        /// </summary>        field(3; "Total Records"; Integer)        {            Caption = 'Total Records';        }        /// <summary>        /// Number of records that have been successfully processed.        /// </summary>        field(4; "Completed Records"; Integer)        {            Caption = 'Completed Records';            trigger OnValidate()            begin                CalcProgress();            end;        }        /// <summary>        /// Processing progress percentage for tracking completion status.        /// </summary>        field(5; Progress; Decimal)        {            AutoFormatType = 0;            Caption = 'Progress';            ExtendedDatatype = Ratio;        }        /// <summary>        /// Current processing status of the table dimension change operation.        /// </summary>        field(6; Status; Option)        {            Caption = 'Status';            OptionCaption = ' ,Scheduled,In Progress,Completed,Incomplete';            OptionMembers = " ",Scheduled,"In Progress",Completed,Incomplete;        }        /// <summary>        /// Unique identifier of the scheduled task processing this table.        /// </summary>        field(7; "Task ID"; Guid)        {            Caption = 'Task ID';        }        /// <summary>        /// Session identifier for tracking the processing session.        /// </summary>        field(8; "Session ID"; Integer)        {            Caption = 'Session ID';        }        /// <summary>        /// Type of change operation for global dimension 1 (None, Blank, Replace, or New).        /// </summary>        field(9; "Change Type 1"; Option)        {            Caption = 'Change Type 1';            OptionCaption = 'None,Blank,Replace,New';            OptionMembers = "None",Blank,Replace,New;        }        /// <summary>        /// Type of change operation for global dimension 2 (None, Blank, Replace, or New).        /// </summary>        field(10; "Change Type 2"; Option)        {            Caption = 'Change Type 2';            OptionCaption = 'None,Blank,Replace,New';            OptionMembers = "None",Blank,Replace,New;        }        /// <summary>        /// Field number for global dimension 1 in this table.        /// </summary>        field(11; "Global Dim.1 Field No."; Integer)        {            Caption = 'Global Dim.1 Field No.';        }        /// <summary>        /// Field number for global dimension 2 in this table.        /// </summary>        field(12; "Global Dim.2 Field No."; Integer)        {            Caption = 'Global Dim.2 Field No.';        }        /// <summary>        /// Field number for dimension set ID in this table.        /// </summary>        field(13; "Dim. Set ID Field No."; Integer)        {            Caption = 'Dim. Set ID Field No.';        }        /// <summary>        /// Field number of the primary key field used for record processing.        /// </summary>        field(14; "Primary Key Field No."; Integer)        {            Caption = 'Primary Key Field No.';        }        /// <summary>        /// Table ID of the parent table when processing related tables in hierarchy.        /// </summary>        field(15; "Parent Table ID"; Integer)        {            Caption = 'Parent Table ID';        }        /// <summary>        /// Indicates whether this table is a parent table in the processing hierarchy.        /// </summary>        field(16; "Is Parent Table"; Boolean)        {            Caption = 'Is Parent Table';        }        /// <summary>        /// Earliest date and time when processing can start for this table.        /// </summary>        field(17; "Earliest Start Date/Time"; DateTime)        {            Caption = 'Earliest Start Date/Time';            ToolTip = 'Specifies the earliest date and time when the job should be run.';        }        /// <summary>        /// Estimated remaining time to complete processing this table.        /// </summary>        field(18; "Remaining Duration"; Duration)        {            Caption = 'Remaining Duration';            ToolTip = 'Specifies the remaining duration of the job.';        }        /// <summary>        /// Identifier of the server instance processing this table.        /// </summary>        field(19; "Server Instance ID"; Integer)        {            Caption = 'Server Instance ID';            DataClassification = SystemMetadata;        }    }    keys    {        key(Key1; "Table ID")        {            Clustered = true;        }        key(Key2; Progress)        {        }        key(Key3; "Parent Table ID")        {        }    }    fieldgroups    {    }    var        ErrorTraceTagMsg: Label 'Error on the task for table %1 (completed %2 of %3 records): %4.', Comment = '%1- table id; %2 ,%3 - integer values; %4 - error message';        RerunTraceTagMsg: Label 'Rerun the task for table %1 (start from %2 of %3 records).', Comment = '%1- table id; %2 ,%3 - integer values';        ScheduledTraceTagMsg: Label 'The task is scheduled for table %1 (%2 records) to start on %3.', Comment = '%1- table id; %2 - integer value; %3 - datetime';        TaskStartTraceTagMsg: Label 'Change Global Dimensions task started for a table.', Locked = true;        TagCategoryTxt: Label 'Change Global Dimensions';    local procedure CalcProgress()    begin        Progress := 10000;        if ("Total Records" <> 0) and ("Completed Records" <= "Total Records") then            Progress := "Completed Records" / "Total Records" * 10000;    end;    /// <summary>    /// Updates the progress of dimension change processing for this table entry.    /// Returns true if the processing is complete, false if still in progress.    /// </summary>    /// <param name="CurrentRecNo">Current record number being processed</param>    /// <param name="StartedFromRecord">Record number where processing started</param>    /// <returns>True if processing is complete, false if still in progress</returns>    procedure Update(CurrentRecNo: Integer; StartedFromRecord: Integer): Boolean    begin        if "Completed Records" = CurrentRecNo then            exit(false);        if CurrentRecNo >= "Total Records" then            RecalculateTotalRecords();        Validate("Completed Records", CurrentRecNo);        case "Completed Records" of            0:                begin                    Status := Status::Incomplete;                    Clear("Remaining Duration");                end;            "Total Records":                Status := Status::Completed;            else                if CurrentRecNo - StartedFromRecord <> 0 then                    "Remaining Duration" :=                      Round(                        ("Total Records" - CurrentRecNo) / (CurrentRecNo - StartedFromRecord) *                        (CurrentDateTime - "Earliest Start Date/Time"), 1);        end;        exit(Modify());    end;    /// <summary>    /// Updates progress with automatic commit and returns completion status.    /// </summary>    /// <param name="CurrentRecNo">Current record number being processed</param>    /// <param name="StartedFromRecord">Record number where processing started</param>    /// <returns>True if processing is complete, false if still in progress</returns>    procedure UpdateWithCommit(CurrentRecNo: Integer; StartedFromRecord: Integer) Completed: Boolean    begin        if Update(CurrentRecNo, StartedFromRecord) then            Commit();        Completed := Status = Status::Completed;    end;    /// <summary>    /// Updates progress without committing transaction and returns completion status.    /// </summary>    /// <param name="CurrentRecNo">Current record number being processed</param>    /// <param name="StartedFromRecord">Record number where processing started</param>    /// <returns>True if processing is complete, false if still in progress</returns>    procedure UpdateWithoutCommit(CurrentRecNo: Integer; StartedFromRecord: Integer) Completed: Boolean    begin        Update(CurrentRecNo, StartedFromRecord);        Completed := Status = Status::Completed;    end;    /// <summary>    /// Cancels the scheduled task associated with this dimension change operation.    /// Clears the Task ID field after canceling the scheduled task.    /// </summary>    procedure CancelTask()    var        ScheduledTask: Record "Scheduled Task";    begin        if not IsNullGuid("Task ID") then begin            if ScheduledTask.Get("Task ID") then                TASKSCHEDULER.CancelTask("Task ID");            Clear("Task ID");        end;    end;    /// <summary>    /// Changes the dimension value on a specific record field during dimension change processing.    /// </summary>    /// <param name="RecRef">Record reference to modify</param>    /// <param name="DimNo">Dimension number (1 or 2)</param>    /// <param name="GlobalDimFieldRef">Field reference for the global dimension field</param>    /// <param name="OldDimValueCode">Previous dimension value code</param>    procedure ChangeDimOnRecord(var RecRef: RecordRef; DimNo: Integer; GlobalDimFieldRef: FieldRef; OldDimValueCode: Code[20])    var        NewValue: Code[20];    begin        case GetChangeType(DimNo) of            "Change Type 1"::New:                NewValue := FindDimensionValueCode(RecRef, DimNo);            "Change Type 1"::Blank:                NewValue := '';            "Change Type 1"::Replace:                NewValue := OldDimValueCode;            "Change Type 1"::None:                exit;        end;        GlobalDimFieldRef.Value(NewValue);    end;    /// <summary>    /// Retrieves field references and current dimension values for global dimension fields.    /// </summary>    /// <param name="RecRef">Record reference to examine</param>    /// <param name="GlobalDimFieldRef">Array of field references for global dimensions</param>    /// <param name="DimValueCode">Array of current dimension value codes</param>    procedure GetFieldRefValues(RecRef: RecordRef; var GlobalDimFieldRef: array[2] of FieldRef; var DimValueCode: array[2] of Code[20])    begin        if "Global Dim.1 Field No." <> 0 then begin            GlobalDimFieldRef[1] := RecRef.Field("Global Dim.1 Field No.");            DimValueCode[1] := GlobalDimFieldRef[1].Value();        end;        if "Global Dim.2 Field No." <> 0 then begin            GlobalDimFieldRef[2] := RecRef.Field("Global Dim.2 Field No.");            DimValueCode[2] := GlobalDimFieldRef[2].Value();        end;    end;    /// <summary>    /// Locates and stores the field number for the Dimension Set ID field in the specified table.    /// </summary>    /// <param name="RecRef">Record reference to examine for dimension set ID field</param>    /// <returns>True if dimension set ID field is found, false otherwise</returns>    procedure FindDimensionSetIDField(RecRef: RecordRef): Boolean    var        "Field": Record "Field";    begin        if FindDefaultDimSetIDFieldNo(RecRef) then            exit(true);        Field.SetRange(TableNo, RecRef.Number);        Field.SetRange(RelationTableNo, DATABASE::"Dimension Set Entry");        Field.SetRange(FieldName, 'Dimension Set ID');        Field.SetFilter(ObsoleteState, '<>%1', Field.ObsoleteState::Removed);        if Field.FindFirst() then begin            "Dim. Set ID Field No." := Field."No.";            exit(true);        end;    end;    local procedure FindDefaultDimSetIDFieldNo(RecRef: RecordRef) Found: Boolean    begin        // W1 "Dimension Set ID" fields must have ID = 480        if RecRef.FieldExist(480) then begin            "Dim. Set ID Field No." := 480;            Found := true;        end;        OnAfterFindDefaultDimSetIDFieldNo(RecRef, Found);    end;    /// <summary>    /// Finds the dimension value code for a specific dimension on a given record.    /// </summary>    /// <param name="RecRef">Record reference to examine</param>    /// <param name="DimNo">Dimension number (1 or 2) to find value for</param>    /// <returns>Dimension value code for the specified dimension</returns>    procedure FindDimensionValueCode(RecRef: RecordRef; DimNo: Integer): Code[20]    var        GeneralLedgerSetup: Record "General Ledger Setup";        DimensionCode: Code[20];        DimensionValueCode: Code[20];        IsHandled: Boolean;    begin        GeneralLedgerSetup.Get();        case DimNo of            1:                DimensionCode := GeneralLedgerSetup."Global Dimension 1 Code";            2:                DimensionCode := GeneralLedgerSetup."Global Dimension 2 Code";        end;        if "Dim. Set ID Field No." = 0 then begin            if RecRef.Number = DATABASE::"Job Task" then                exit(FindJobTaskDimensionValueCode(RecRef, DimensionCode));            IsHandled := false;            OnBeforeFindDefaultDimensionValueCode(RecRef, DimensionCode, DimensionValueCode, IsHandled);            if IsHandled then                exit(DimensionValueCode);            exit(FindDefaultDimensionValueCode(RecRef, DimensionCode));        end;        exit(FindDimSetDimensionValueCode(RecRef, DimensionCode));    end;    local procedure FindDefaultDimensionValueCode(RecRef: RecordRef; DimensionCode: Code[20]): Code[20]    var        DefaultDimension: Record "Default Dimension";        PKFieldRef: FieldRef;        PKValue: Text;    begin        PKFieldRef := RecRef.Field("Primary Key Field No.");        PKValue := Format(PKFieldRef.Value());        if StrLen(PKValue) > MaxStrLen(DefaultDimension."No.") then            exit('');        if DefaultDimension.Get(RecRef.Number, PKValue, DimensionCode) then            exit(DefaultDimension."Dimension Value Code");        exit('');    end;    local procedure FindDimSetDimensionValueCode(RecRef: RecordRef; DimensionCode: Code[20]): Code[20]    var        DimensionSetEntry: Record "Dimension Set Entry";        DimSetIDFieldRef: FieldRef;        DimSetID: Integer;    begin        DimSetIDFieldRef := RecRef.Field("Dim. Set ID Field No.");        DimSetID := DimSetIDFieldRef.Value();        if DimensionSetEntry.Get(DimSetID, DimensionCode) then            exit(DimensionSetEntry."Dimension Value Code");        exit('');    end;    local procedure FindJobTaskDimensionValueCode(RecRef: RecordRef; DimensionCode: Code[20]): Code[20]    var        JobTask: Record "Job Task";        JobTaskDimension: Record "Job Task Dimension";    begin        RecRef.SetTable(JobTask);        if JobTaskDimension.Get(JobTask."Job No.", JobTask."Job Task No.", DimensionCode) then            exit(JobTaskDimension."Dimension Value Code");        exit('');    end;    local procedure FindParentTable(RecRef: RecordRef): Integer    var        ParentKeyFieldRef: FieldRef;    begin        if RecRef.FieldExist(2) then begin // typical for Detailed Ledger Entry tables            ParentKeyFieldRef := RecRef.Field(2);            if ParentKeyFieldRef.Type = FieldType::Integer then                exit(ParentKeyFieldRef.Relation);        end;    end;    /// <summary>    /// Initializes log entry data by analyzing the table structure and populating field numbers.    /// </summary>    /// <param name="RecRef">Record reference to analyze for dimension processing setup</param>    procedure FillData(RecRef: RecordRef)    var        PKeyFieldRef: FieldRef;    begin        "Total Records" := RecRef.Count();        if not FindDimensionSetIDField(RecRef) then begin            GetPrimaryKeyFieldRef(RecRef, PKeyFieldRef);            if PKeyFieldRef.Type = FieldType::Code then                "Primary Key Field No." := PKeyFieldRef.Number            else                "Parent Table ID" := FindParentTable(RecRef);        end;        FindFieldIDs();    end;    local procedure FindFieldIDs()    var        "Field": Record "Field";        DimensionManagement: Codeunit DimensionManagement;    begin        if DimensionManagement.FindDimFieldInTable("Table ID", 'Dimension 1 Code*|*Global Dim. 1', Field) then            "Global Dim.1 Field No." := Field."No.";        if DimensionManagement.FindDimFieldInTable("Table ID", 'Dimension 2 Code*|*Global Dim. 2', Field) then            "Global Dim.2 Field No." := Field."No.";    end;    local procedure GetChangeType(DimNo: Integer): Integer    begin        if DimNo = 1 then            exit("Change Type 1");        exit("Change Type 2");    end;    /// <summary>    /// Retrieves the primary key field reference for the table record.    /// </summary>    /// <param name="RecRef">Record reference to examine</param>    /// <param name="PKeyFieldRef">Returns the primary key field reference</param>    procedure GetPrimaryKeyFieldRef(RecRef: RecordRef; var PKeyFieldRef: FieldRef)    var        PKeyRef: KeyRef;    begin        PKeyRef := RecRef.KeyIndex(1);        PKeyFieldRef := PKeyRef.FieldIndex(1);    end;    local procedure RecalculateTotalRecords()    var        RecRef: RecordRef;    begin        RecRef.Open("Table ID");        "Total Records" := RecRef.Count();        RecRef.Close();    end;    /// <summary>    /// Logs error trace information for dimension change processing failures.    /// </summary>    procedure SendTraceTagOnError()    begin        Session.LogMessage('00001ZB', StrSubstNo(ErrorTraceTagMsg, "Table ID", "Completed Records", "Total Records", GetLastErrorText), Verbosity::Error, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, GetTraceTagCustomDimensions());    end;    /// <summary>    /// Logs trace information when dimension change processing is rerun.    /// </summary>    procedure SendTraceTagOnRerun()    begin        Session.LogMessage('00001ZC', StrSubstNo(RerunTraceTagMsg, "Table ID", "Completed Records", "Total Records"), Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, GetTraceTagCustomDimensions());    end;    /// <summary>    /// Logs trace information when dimension change processing is scheduled.    /// </summary>    procedure SendTraceTagOnScheduling()    begin        Session.LogMessage('00001ZD', StrSubstNo(ScheduledTraceTagMsg, "Table ID", "Total Records", Format("Earliest Start Date/Time", 0, 9)), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, GetTraceTagCustomDimensions());    end;    /// <summary>    /// Logs trace information when a scheduled session starts processing a table.    /// </summary>    procedure SendTraceTagOnTaskStart()    begin        Session.LogMessage('0000TMZ', TaskStartTraceTagMsg, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, GetTraceTagCustomDimensions());    end;    local procedure GetTraceTagCustomDimensions() CustomDimensions: Dictionary of [Text, Text]    begin        CustomDimensions.Add('Category', TagCategoryTxt);        CustomDimensions.Add('TableId', Format("Table ID"));        CustomDimensions.Add('TableName', "Table Name");        CustomDimensions.Add('TaskId', Format("Task ID"));        CustomDimensions.Add('ParentTableId', Format("Parent Table ID"));        CustomDimensions.Add('IsParentTable', Format("Is Parent Table"));        CustomDimensions.Add('CompletedRecords', Format("Completed Records"));        CustomDimensions.Add('TotalRecords', Format("Total Records"));        CustomDimensions.Add('EarliestStart', Format("Earliest Start Date/Time", 0, 9));        CustomDimensions.Add('Status', Format(Status));    end;    /// <summary>    /// Sets the session ID to track the current processing session.    /// Marks the status as "In Progress" for active processing tracking.    /// </summary>    procedure SetSessionInProgress()    begin        "Session ID" := SessionId();        "Server Instance ID" := ServiceInstanceId();        Status := Status::"In Progress";        Modify();    end;    /// <summary>    /// Updates the processing status based on current task and session state.    /// Returns the previous status value for comparison.    /// </summary>    /// <returns>Previous status value before the update</returns>    procedure UpdateStatus() OldStatus: Integer    begin        OldStatus := Status;        if IsNullGuid("Task ID") then            Status := Status::" "        else            if "Completed Records" = "Total Records" then begin                "Session ID" := -1; // to avoid match to real user sessions                "Server Instance ID" := -1;                Status := Status::Completed            end else                if "Session ID" = 0 then begin                    if IsTaskScheduled() then                        Status := Status::Scheduled                    else                        Status := Status::Incomplete;                end else                    if IsSessionActive() then                        Status := Status::"In Progress"                    else begin                        Status := Status::Incomplete;                        "Session ID" := -1;                        "Server Instance ID" := -1;                    end;    end;    /// <summary>    /// Checks if the session associated with this log entry is currently active.    /// Returns true if the session is running on the current server instance or another instance.    /// </summary>    /// <returns>True if the session is active, false if inactive or logged off</returns>    local procedure IsSessionActive(): Boolean;    var        ActiveSession: Record "Active Session";    begin        if "Server Instance ID" = ServiceInstanceId() then            exit(ActiveSession.Get("Server Instance ID", "Session ID"));        if "Server Instance ID" <= 0 then            exit(false);        exit(not IsSessionLoggedOff());    end;    /// <summary>    /// Checks if the session associated with this log entry has logged off.    /// Searches session event records for logoff events after the earliest start date/time.    /// </summary>    /// <returns>True if the session has logged off, false if still active</returns>    local procedure IsSessionLoggedOff(): Boolean;    var        SessionEvent: Record "Session Event";    begin        SessionEvent.SetRange("Server Instance ID", "Server Instance ID");        SessionEvent.SetRange("Session ID", "Session ID");        SessionEvent.SetRange("Event Type", SessionEvent."Event Type"::Logoff);        SessionEvent.SetFilter("Event Datetime", '>%1', "Earliest Start Date/Time");        SessionEvent.SetRange("User SID", UserSecurityId());        exit(not SessionEvent.IsEmpty);    end;    /// <summary>    /// Displays error details from job queue log entries for failed dimension change tasks.    /// Opens the Job Queue Log Entries page filtered to show errors for this table.    /// </summary>    procedure ShowError()    var        JobQueueLogEntry: Record "Job Queue Log Entry";    begin        if IsNullGuid("Task ID") then begin            JobQueueLogEntry.SetRange("Object Type to Run", JobQueueLogEntry."Object Type to Run"::Codeunit);            JobQueueLogEntry.SetRange("Object ID to Run", CODEUNIT::"Change Global Dim Err. Handler");            JobQueueLogEntry.SetRange(Description, "Table Name");        end else            JobQueueLogEntry.SetRange(ID, "Task ID");        JobQueueLogEntry.SetRange(Status, JobQueueLogEntry.Status::Error);        PAGE.RunModal(PAGE::"Job Queue Log Entries", JobQueueLogEntry);    end;    local procedure IsTaskScheduled() TaskExists: Boolean    var        ScheduledTask: Record "Scheduled Task";    begin        OnFindingScheduledTask("Task ID", TaskExists);        if not TaskExists then            exit(ScheduledTask.Get("Task ID"));    end;    /// <summary>    /// Integration event raised after attempting to find default dimension set ID field number.    /// Enables extensions to provide custom logic for identifying dimension set ID fields.    /// </summary>    /// <param name="RecRef">Record reference being examined</param>    /// <param name="Found">Indicates whether the field was found by standard logic</param>    [IntegrationEvent(true, false)]    local procedure OnAfterFindDefaultDimSetIDFieldNo(RecRef: RecordRef; var Found: Boolean)    begin    end;    /// <summary>    /// Integration event raised when checking if a scheduled task exists.    /// Enables extensions to provide custom task existence verification.    /// </summary>    /// <param name="TaskID">GUID of the task to check</param>    /// <param name="IsTaskExist">Returns whether the task exists</param>    [IntegrationEvent(false, false)]    local procedure OnFindingScheduledTask(TaskID: Guid; var IsTaskExist: Boolean)    begin    end;    /// <summary>    /// Integration event raised before finding default dimension value code.    /// Enables extensions to provide custom dimension value code lookup logic.    /// </summary>    /// <param name="RecRef">Record reference being examined</param>    /// <param name="DimensionCode">Dimension code to find value for</param>    /// <param name="DimensionValueCode">Returns the dimension value code</param>    /// <param name="IsHandled">Set to true to skip standard lookup logic</param>    [IntegrationEvent(false, false)]    local procedure OnBeforeFindDefaultDimensionValueCode(RecRef: RecordRef; DimensionCode: Code[20]; var DimensionValueCode: Code[20]; var IsHandled: Boolean)    begin    end;}