Table 1830 Consolidation Process

Base Application, Microsoft.Finance.Consolidation

src/Layers/W1/BaseApp/Finance/Consolidation/ConsolidationProcess.Table.al129 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.Consolidation;/// <summary>/// Stores consolidation process execution data and status tracking for multi-company consolidation operations./// Manages consolidation workflow state, parameters, and error handling for business unit data processing./// </summary>/// <remarks>/// Central table for consolidation process management containing execution parameters and status monitoring./// Integrates with business unit consolidation workflow for tracking multi-step consolidation operations./// Used by consolidation wizards and automated consolidation job processing./// </remarks>table 1830 "Consolidation Process"{    Caption = 'Consolidation Process';    ReplicateData = false;    Extensible = false;    DataClassification = CustomerContent;    fields    {        /// <summary>        /// Unique identifier for consolidation process execution tracking and reference.        /// </summary>        field(1; Id; Integer)        {            AutoIncrement = true;            DataClassification = SystemMetadata;        }        /// <summary>        /// Current status of consolidation process execution with workflow state tracking.        /// </summary>        field(2; Status; Option)        {            OptionMembers = NotStarted,InProgress,Failed,Completed;            OptionCaption = 'Not started,In Progress,Failed,Completed';            ToolTip = 'Status of the consolidation process';            DataClassification = SystemMetadata;        }        /// <summary>        /// Starting date for consolidation period defining the beginning of data extraction range.        /// </summary>        field(3; "Starting Date"; Date)        {            Caption = 'Starting Date';            ToolTip = 'Starting date for the entries in the consolidation';            ClosingDates = true;            DataClassification = CustomerContent;        }        /// <summary>        /// Ending date for consolidation period defining the conclusion of data extraction range.        /// </summary>        field(4; "Ending Date"; Date)        {            Caption = 'Ending Date';            ToolTip = 'Ending date for the entries in the consolidation';            ClosingDates = true;            DataClassification = CustomerContent;        }        /// <summary>        /// Journal template name for posting consolidated transactions during process execution.        /// </summary>        field(5; "Journal Template Name"; Code[10])        {            Caption = 'Journal Template Name';            DataClassification = CustomerContent;        }        /// <summary>        /// Journal batch name for organizing consolidated transaction postings by process.        /// </summary>        field(6; "Journal Batch Name"; Code[10])        {            Caption = 'Journal Batch Name';            DataClassification = CustomerContent;        }        /// <summary>        /// Document number used for consolidated journal entries created during process execution.        /// </summary>        field(7; "Document No."; Code[20])        {            Caption = 'Document No.';            DataClassification = CustomerContent;        }        /// <summary>        /// Parent company currency code for consolidation transactions and currency conversion.        /// </summary>        field(8; "Parent Currency Code"; Code[10])        {            Caption = 'Parent Currency Code';            DataClassification = CustomerContent;        }        /// <summary>        /// List of dimension codes to transfer during consolidation for multi-dimensional analysis.        /// </summary>        field(9; "Dimensions to Transfer"; Text[250])        {            Caption = 'Dimensions to Transfer';            DataClassification = CustomerContent;        }        /// <summary>        /// Error message text capturing consolidation process failures and exception details.        /// </summary>        field(10; "Error"; Text[2048])        {            Caption = 'Error';            DataClassification = SystemMetadata;        }    }    keys    {        key(Key1; Id)        {            Clustered = true;        }    }    trigger OnDelete()    var        BusUnitInConsProcess: Record "Bus. Unit In Cons. Process";    begin        BusUnitInConsProcess.SetRange("Consolidation Process Id", Id);        BusUnitInConsProcess.DeleteAll();    end;}