Table 762 "Account Schedules Chart Setup"

Base Application · Microsoft.Finance.FinancialReports · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Account Schedules Chart Setup
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	User ID Δ BC29	Text[132]	Specifies the ID of the user who posted the entry, to be used, for example, in the change log.	not editable; DataClassification EndUserIdentifiableInformation
2	Name Δ BC29	Text[30]	Specifies the name of the specific chart.
3	Description Δ BC29	Text[250]	Specifies the description of the specific chart.
10	Account Schedule Name Δ BC29	Code[10]	Specifies the name of the row definition that is used to generate the chart that is shown in the Finance Performance window.	TableRelation Table 84 “Acc. Schedule Name” (“Acc. Schedule Name”.Name)
20	Column Layout Name Δ BC29	Code[10]	Specifies the name of the column layout in the account schedule that is used to generate the advanced chart that is shown in the Finance Performance window.	TableRelation Table 333 “Column Layout Name” (“Column Layout Name”.Name)
30	Base X-Axis on Δ BC29	Option	Specifies how the values from the selected account schedule are displayed in the specific chart.	OptionCaption: Period,Acc. Sched. Line,Acc. Sched. Column
31	Start Date Δ BC29	Date	Specifies the first date on which account schedule values are included in the chart.
32	End Date Δ BC29	Date	Specifies the last date on which financial report values are included in the chart.
41	Period Length Δ BC29	Option	Specifies the length of periods in the chart.	OptionCaption: Day,Week,Month,Quarter,Year
42	No. of Periods Δ BC29	Integer	Specifies how many periods are shown in the chart.
50	Last Viewed	Boolean	—	not editable
51	Look Ahead	Boolean	—

Keys

Key1: User ID, Name (clustered)

Procedures

SetAccScheduleName(AccSchedName: Code[10]): Sets the account schedule name and updates the record. Validates and modifies the chart setup with new account schedule configuration.
SetColumnLayoutName(ColumnLayoutName: Code[10]): Sets the column layout name and updates the record. Validates and modifies the chart setup with new column layout configuration.
SetShowPer(ShowPer: Option): Sets the chart axis display option and updates the record. Configures what the X-axis represents in the chart visualization.
SetPeriodLength(PeriodLength: Option): Sets the period length for chart analysis and updates the record. Defines the time span for each period in the chart visualization.
SetLastViewed(): Marks this chart setup as the last viewed configuration. Updates the record and clears last viewed flag from other setups.
SetLinkToLines(var AccSchedChartSetupLine: Record "Acc. Sched. Chart Setup Line"): Sets filters on chart setup lines based on current chart configuration. Links chart setup lines to this configuration for data retrieval.
SetLinkToMeasureLines(var AccSchedChartSetupLine: Record "Acc. Sched. Chart Setup Line"): Sets filters on chart setup lines for measure-based chart display. Configures line filtering based on X-axis configuration for measure presentation.
SetLinkToDimensionLines(var AccSchedChartSetupLine: Record "Acc. Sched. Chart Setup Line"): Sets filters on chart setup lines for dimension-based chart display. Configures line filtering based on X-axis configuration for dimension presentation.
RefreshLines(Force: Boolean): Refreshes chart setup lines based on current account schedule and column layout configuration. Updates line data when configuration changes or when forced refresh is requested.
FilterAccSchedLines(var AccScheduleLine: Record "Acc. Schedule Line"): Applies filters to account schedule lines based on current chart setup configuration. Filters lines to match the assigned account schedule name and exclude empty descriptions.
FilterColumnLayout(var ColumnLayout: Record "Column Layout"): Applies filters to column layout records based on current chart setup configuration. Filters columns to match the assigned column layout name and exclude empty headers.
SetMeasureChartTypesToDefault(var AccSchedChartSetupLine: Record "Acc. Sched. Chart Setup Line"): Sets default chart types for measure lines in chart setup configuration. Assigns column chart types to unset measure lines up to maximum supported measures.
SetDimensionChartTypesToDefault(var AccSchedChartSetupLine: Record "Acc. Sched. Chart Setup Line"): Sets default chart types for dimension lines in chart setup configuration. Assigns default chart types to unset dimension lines for visualization.

Plus 4 local procedures.

Triggers

OnDelete

Relations

lookup page Page 767 “Account Schedule Chart List”
Column Layout Name: TableRelation Table 333 “Column Layout Name”
Account Schedule Name: TableRelation Table 84 “Acc. Schedule Name”

Referenced by

2 fields in 1 objects relate to this table (TableRelation or CalcFormula).

Table 763 “Acc. Sched. Chart Setup Line”: Name, User ID

Pages and codeunits on this table

Page 763 “Account Schedules Chart Setup” (source table)
Page 767 “Account Schedule Chart List” (source table)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Account Schedules Chart Setup"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.