Table 2151 Upd Analysis View Entry Buffer

Base Application, Microsoft.Finance.Analysis

src/Layers/W1/BaseApp/Finance/Analysis/UpdAnalysisViewEntryBuffer.Table.al187 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.Analysis;using Microsoft.Finance.GeneralLedger.Setup;/// <summary>/// Temporary buffer table for staging analysis view entry updates during analysis view refresh operations./// Accumulates transaction data before final aggregation into analysis view entries and budget entries./// </summary>table 2151 "Upd Analysis View Entry Buffer"{    TableType = Temporary;    DataClassification = CustomerContent;    fields    {        /// <summary>        /// Auto-incrementing primary key for unique record identification in the temporary buffer.        /// Ensures each staged entry has a unique identifier during processing.        /// </summary>        field(1; "Primary Key"; Integer)        {            DataClassification = SystemMetadata;            AutoIncrement = true;        }        /// <summary>        /// Account number from the source transaction being processed for analysis view update.        /// G/L Account or Cash Flow Account number depending on the account source type.        /// </summary>        field(2; AccNo; Code[20])        {            DataClassification = CustomerContent;        }        /// <summary>        /// Business unit code for consolidation scenarios in analysis view updates.        /// Empty for single-company analysis, populated from source entries for consolidation.        /// </summary>        field(3; BusUnitCode; Code[20])        {            DataClassification = CustomerContent;        }        /// <summary>        /// Cash flow forecast number for cash flow analysis view updates.        /// Links to Cash Flow Forecast for cash flow account source entries.        /// </summary>        field(4; CashFlowForecastNo; Code[20])        {            DataClassification = CustomerContent;        }        /// <summary>        /// First dimension value code from source transactions for analysis view aggregation.        /// Staging area for dimension 1 values before final analysis entry creation.        /// </summary>        field(5; DimValue1; Code[20])        {            DataClassification = CustomerContent;        }        /// <summary>        /// Second dimension value code from source transactions for analysis view aggregation.        /// Staging area for dimension 2 values before final analysis entry creation.        /// </summary>        field(6; DimValue2; Code[20])        {            DataClassification = CustomerContent;        }        /// <summary>        /// Third dimension value code from source transactions for analysis view aggregation.        /// Staging area for dimension 3 values before final analysis entry creation.        /// </summary>        field(7; DimValue3; Code[20])        {            DataClassification = CustomerContent;        }        /// <summary>        /// Fourth dimension value code from source transactions for analysis view aggregation.        /// Staging area for dimension 4 values before final analysis entry creation.        /// </summary>        field(8; DimValue4; Code[20])        {            DataClassification = CustomerContent;        }        /// <summary>        /// Posting date from source transactions for period-based analysis view updates.        /// Used for date filtering and period aggregation during analysis view refresh.        /// </summary>        field(9; PostingDate; Date)        {            DataClassification = CustomerContent;        }        /// <summary>        /// Net amount from source transactions in local currency for analysis view aggregation.        /// Calculated as debit amount minus credit amount for final analysis entries.        /// </summary>        field(10; Amount; Decimal)        {            AutoFormatExpression = '';            AutoFormatType = 1;            DataClassification = CustomerContent;        }        /// <summary>        /// Debit amount from source transactions in local currency for analysis view updates.        /// Staged for aggregation into final analysis view entries with dimension breakdown.        /// </summary>        field(11; DebitAmount; Decimal)        {            AutoFormatExpression = '';            AutoFormatType = 1;            DataClassification = CustomerContent;        }        /// <summary>        /// Credit amount from source transactions in local currency for analysis view updates.        /// Staged for aggregation into final analysis view entries with dimension breakdown.        /// </summary>        field(12; CreditAmount; Decimal)        {            AutoFormatExpression = '';            AutoFormatType = 1;            DataClassification = CustomerContent;        }        /// <summary>        /// Net amount from source transactions in additional currency for multi-currency analysis.        /// Additional reporting currency amount for global financial reporting requirements.        /// </summary>        field(13; AmountACY; Decimal)        {            AutoFormatExpression = GetAdditionalReportingCurrencyCode();            AutoFormatType = 1;            DataClassification = CustomerContent;        }        /// <summary>        /// Debit amount from source transactions in additional currency for multi-currency analysis.        /// Additional reporting currency debit amount for global reporting compliance.        /// </summary>        field(14; DebitAmountACY; Decimal)        {            AutoFormatExpression = GetAdditionalReportingCurrencyCode();            AutoFormatType = 1;            DataClassification = CustomerContent;        }        /// <summary>        /// Credit amount from source transactions in additional currency for multi-currency analysis.        /// Additional reporting currency credit amount for global reporting compliance.        /// </summary>        field(15; CreditAmountACY; Decimal)        {            AutoFormatExpression = GetAdditionalReportingCurrencyCode();            AutoFormatType = 1;            DataClassification = CustomerContent;        }        /// <summary>        /// Entry number from source transactions for traceability and audit purposes.        /// Links back to the original G/L or Cash Flow entry that generated this buffer record.        /// </summary>        field(16; EntryNo; Integer)        {            DataClassification = CustomerContent;        }        /// <summary>        /// Account source type indicating whether this entry originates from G/L or Cash Flow accounts.        /// Determines the source table and processing logic for analysis view updates.        /// </summary>        field(17; "Account Source"; Enum "Analysis Account Source")        {            Caption = 'Account Source';        }    }    keys    {        key(Key1; "Primary Key")        {            Clustered = true;        }    }    local procedure GetAdditionalReportingCurrencyCode(): Code[10]    var        GLSetup: Record "General Ledger Setup";    begin        if GLSetup.Get() then            exit(GLSetup."Additional Reporting Currency");    end;}