Table 926 G/L Acc. Balance Buffer
src/Layers/W1/BaseApp/Finance/Analysis/GLAccBalanceBuffer.Table.al99 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;/// <summary>/// Temporary buffer table for G/L account balance calculations and period-based analysis./// Stores calculated balance data for reporting and analysis across different time periods./// </summary>/// <remarks>/// Used by G/L account analysis and balance reporting functionality./// Provides period-based aggregation of G/L account balances with debit/credit breakdown./// </remarks>table 926 "G/L Acc. Balance Buffer"{ DataClassification = SystemMetadata; fields { /// <summary> /// Type of period used for balance calculation and grouping. /// </summary> field(5; "Period Type"; Option) { Caption = 'Period Type'; OptionMembers = Day,Week,Month,Quarter,Year,Period; DataClassification = SystemMetadata; } /// <summary> /// Descriptive name of the period for balance calculation. /// </summary> field(6; "Period Name"; Text[50]) { Caption = 'Period Name'; ToolTip = 'Specifies the name of the period shown in the line.'; DataClassification = SystemMetadata; } /// <summary> /// Starting date of the period for balance calculation. /// </summary> field(7; "Period Start"; Date) { Caption = 'Period Start'; ToolTip = 'Specifies the start date of the period defined on the line for the bank account balance.'; DataClassification = SystemMetadata; } /// <summary> /// Ending date of the period for balance calculation. /// </summary> field(8; "Period End"; Date) { Caption = 'Period End'; DataClassification = SystemMetadata; } /// <summary> /// Total debit amount for the period and account. /// </summary> field(10; "Debit Amount"; Decimal) { Caption = 'Debit Amount'; ToolTip = 'Specifies the debit amount for the period on the line.'; DataClassification = SystemMetadata; AutoFormatType = 1; AutoFormatExpression = ''; } /// <summary> /// Total credit amount for the period and account. /// </summary> field(11; "Credit Amount"; Decimal) { Caption = 'Credit Amount'; ToolTip = 'Specifies the credit amount for the period on the line.'; DataClassification = SystemMetadata; AutoFormatType = 1; AutoFormatExpression = ''; } /// <summary> /// Net change amount (debits minus credits) for the period and account. /// </summary> field(12; "Net Change"; Decimal) { Caption = 'Net Change'; ToolTip = 'Specifies changes in the actual general ledger amount.'; DataClassification = SystemMetadata; AutoFormatType = 1; AutoFormatExpression = ''; } } keys { key(Key1; "Period Type", "Period Start") { Clustered = true; } }}