Table 763 Acc. Sched. Chart Setup Line
src/Layers/W1/BaseApp/Finance/FinancialReports/AccSchedChartSetupLine.Table.al188 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.FinancialReports;using System.Visualization;/// <summary>/// Stores individual line configuration for account schedule chart setups with chart type and measure definitions./// Defines which account schedule lines and column layouts appear in charts with their visualization properties./// </summary>/// <remarks>/// Primary usage: Chart line configuration, measure and dimension setup for business chart visualization./// Integration: Links with Account Schedules Chart Setup, Account Schedule Lines, and Business Chart Buffer./// Extensibility: Standard table extension patterns for additional chart types and visualization options./// </remarks>table 763 "Acc. Sched. Chart Setup Line"{ Caption = 'Acc. Sched. Chart Setup Line'; DataClassification = CustomerContent; fields { /// <summary> /// User identifier associating the chart setup line with the owning user account. /// </summary> field(1; "User ID"; Text[132]) { Caption = 'User ID'; DataClassification = EndUserIdentifiableInformation; Editable = false; TableRelation = "Account Schedules Chart Setup"."User ID" where(Name = field(Name)); } /// <summary> /// Chart setup name linking this line to the parent chart configuration. /// </summary> field(2; Name; Text[30]) { Caption = 'Name'; Editable = false; TableRelation = "Account Schedules Chart Setup".Name where("User ID" = field("User ID")); } /// <summary> /// Account schedule name identifying the row definition source for chart data. /// </summary> field(3; "Account Schedule Name"; Code[10]) { Caption = 'Account Schedule Name'; ToolTip = 'Specifies the account schedule name.'; Editable = false; TableRelation = "Acc. Schedule Name".Name; } /// <summary> /// Line number within the account schedule identifying the specific row for chart display. /// </summary> field(4; "Account Schedule Line No."; Integer) { Caption = 'Account Schedule Line No.'; ToolTip = 'Specifies the number of the account schedule line that the chart is based on.'; Editable = false; TableRelation = "Acc. Schedule Line"."Line No." where("Schedule Name" = field("Account Schedule Name")); } /// <summary> /// Column layout name identifying the column definition source for chart data. /// </summary> field(5; "Column Layout Name"; Code[10]) { Caption = 'Column Layout Name'; ToolTip = 'Specifies the name. This field is intended only for internal use.'; Editable = false; TableRelation = "Column Layout Name".Name; } /// <summary> /// Line number within the column layout identifying the specific column for chart display. /// </summary> field(6; "Column Layout Line No."; Integer) { Caption = 'Column Layout Line No.'; ToolTip = 'Specifies the line number. This field is intended only for internal use.'; Editable = false; TableRelation = "Column Layout"."Line No." where("Column Layout Name" = field("Column Layout Name")); } /// <summary> /// Original measure name before user modifications for reference and reset functionality. /// </summary> field(10; "Original Measure Name"; Text[111]) { Caption = 'Original Measure Name'; ToolTip = 'Specifies the account schedule columns or lines that you select to include in the Account Schedules Chart Setup window.'; Editable = false; } /// <summary> /// Display name for the measure used in chart legends and labels. /// </summary> field(15; "Measure Name"; Text[111]) { Caption = 'Measure Name'; ToolTip = 'Specifies the account schedule columns or lines that the measures on the y-axis in the specific chart are based on.'; trigger OnValidate() begin TestField("Measure Name"); end; } /// <summary> /// Text representation of the calculated measure value for display purposes. /// </summary> field(20; "Measure Value"; Text[30]) { Caption = 'Measure Value'; Editable = false; } /// <summary> /// Chart visualization type determining how this measure is displayed in the chart. /// </summary> field(40; "Chart Type"; Enum "Account Schedule Chart Type") { Caption = 'Chart Type'; ToolTip = 'Specifies how the account schedule values are represented graphically in the chart.'; trigger OnValidate() var AccountSchedulesChartSetup: Record "Account Schedules Chart Setup"; AccSchedChartSetupLine: Record "Acc. Sched. Chart Setup Line"; BusinessChartBuffer: Record "Business Chart Buffer"; ActualNumMeasures: Integer; begin if ("Chart Type" <> "Chart Type"::" ") and IsMeasure() then begin AccountSchedulesChartSetup.Get("User ID", Name); AccountSchedulesChartSetup.SetLinkToMeasureLines(AccSchedChartSetupLine); AccSchedChartSetupLine.SetFilter("Chart Type", '<>%1', AccSchedChartSetupLine."Chart Type"::" "); ActualNumMeasures := 0; if AccSchedChartSetupLine.FindSet() then repeat if (AccSchedChartSetupLine."Account Schedule Line No." <> "Account Schedule Line No.") or (AccSchedChartSetupLine."Column Layout Line No." <> "Column Layout Line No.") then ActualNumMeasures += 1; until AccSchedChartSetupLine.Next() = 0; if ActualNumMeasures >= BusinessChartBuffer.GetMaxNumberOfMeasures() then BusinessChartBuffer.RaiseErrorMaxNumberOfMeasuresExceeded(); end; end; } } keys { key(Key1; "User ID", Name, "Account Schedule Line No.", "Column Layout Line No.") { Clustered = true; } } fieldgroups { } local procedure IsMeasure() Result: Boolean var AccountSchedulesChartSetup: Record "Account Schedules Chart Setup"; begin AccountSchedulesChartSetup.Get("User ID", Name); case AccountSchedulesChartSetup."Base X-Axis on" of AccountSchedulesChartSetup."Base X-Axis on"::Period: Result := true; AccountSchedulesChartSetup."Base X-Axis on"::"Acc. Sched. Line": if "Account Schedule Line No." = 0 then Result := true; AccountSchedulesChartSetup."Base X-Axis on"::"Acc. Sched. Column": if "Column Layout Line No." = 0 then Result := true; end; end; /// <summary> /// Returns the default chart type for account schedule chart setup lines. /// Provides consistent default visualization when creating new chart configurations. /// </summary> /// <returns>Default chart type enum value for account schedule charts</returns> procedure GetDefaultAccSchedChartType(): Enum "Account Schedule Chart Type" begin exit("Chart Type"::Column); end;}