BC Observatoryunofficial, made by waldo
tableFinanceofficial - Microsoftderived - from the source, no model text

Table 85 "Acc. Schedule Line"

Base Application · Microsoft.Finance.FinancialReports

Open in Claude85.mdSource on GitHub

Across versions

  1. BC23present
  2. BC241 fields changed
  3. BC25-27unchanged
  4. BC285 fields added
  5. BC2917 fields changed
  6. BC30unchanged

Neighbourhood 34 connected objects and pages

Table 1110 "Cost Budget Name" (relates to)Cost Budget NameTable 1112 "Cost Center" (relates to)Cost CenterTable 1113 "Cost Object" (relates to)Table 15 "G/L Account" (relates to)G/L AccountTable 220 "Business Unit" (relates to)Table 570 "G/L Account Category" (relates to)G/L Account CategoryTable 84 "Acc. Schedule Name" (relates to)Table 840 "Cash Flow Forecast" (relates to)Cash Flow ForecastTable 841 "Cash Flow Account" (relates to)Table 95 "G/L Budget Name" (relates to)G/L Budget NameCodeunit 8 "AccSchedManagement" (pages and codeunits on it)AccSchedManagementCodeunit 9 "Acc. Sched. KPI Dimensions" (pages and codeunits on it)Acc. Sched. KPI DimensionsPage 104 "Account Schedule" (pages and codeunits on it)Account SchedulePage 490 "Acc. Schedule Overview" (pages and codeunits on it)Acc. Schedule OverviewTable extension 6221 "Sust. Acc. Schedule Line" (extended by)Sust. Acc. Schedule LineCodeunit 198 "Acc. Sched. KPI Event Handler" (event subscribers, 3 links)Acc. Sched. KPI Event HandlerCodeunit 6238 "Acc. Schedule Line Subscribers" (event subscribers, 2 links)Codeunit 2622 "Stat. Acc. Fin Reporting Mgt" (event subscribers)Stat. Acc. Fin Reporting MgtTable 763 "Acc. Sched. Chart Setup Line" (referenced by)Acc. Sched. Chart Setup LineBuild financial reports using financial data and account categories (Learn pages)Column definitions in Financial Reporting (Learn pages)Create custom financial reports (Learn pages)Design your own financial reports (Learn pages)Financial analytics (Learn pages)Financial Reporting FAQ (Learn pages)Integrate financial reports with Excel (Learn pages)Make cash flow forecasts using financial reports (Learn pages)Organize report data using account categories (Learn pages)Primary capabilities of financial reporting (Learn pages)Row definitions in Financial Reporting (Learn pages)Set Up and Publish KPI Web Services Based on Financial Reports (Learn pages)Sustainability financial reporting (Learn pages)Troubleshoot Financial Reporting (Learn pages)View a financial report (Learn pages)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

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

Learn documents this table through its pages: Page 490 “Acc. Schedule Overview” (12 Learn pages), Page 104 “Account Schedule” (8).

Properties

Property Value
Caption Acc. Schedule Line
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 Schedule Name Δ BC24 Code[10] Specifies the unique name (code) of the financial report row definition. You can use up to 10 characters. TableRelation Table 84 “Acc. Schedule Name” (Acc. Schedule Name)
2 Line No. Integer —
3 Row No. Δ BC29 Code[10] Specifies a number that identifies the line.
4 Description Δ BC29 Text[100] Specifies text that will appear on the financial report line.
5 Totaling Text[250] — TableRelation Table 15 “G/L Account”, Table 570 “G/L Account Category”, Table 841 “Cash Flow Account” (if (“Totaling Type” = const(“Posting Accounts”)) “G/L Account” else if (“Totaling Type” = const(“Total Accounts”)) “G/L Account” else if (“Totaling Type” = const(“Account Category”)) “G/L Account Category” else if (“Totaling Type” = const(“Cash Flow Entry Accounts”)) “Cash Flow Account” else if (“To…)
6 Totaling Type Δ BC29 Enum “Acc. Schedule Line Totaling Type” Specifies the totaling type for the financial report line. The type determines which accounts within the totaling interval you specify in the Totaling field will be totaled. enum Enum 85 “Acc. Schedule Line Totaling Type”
7 New Page Δ BC29 Boolean Specifies whether there will be a page break after the current line when the financial report is exported to PDF or printed.
8 Indentation Integer —
11 Date Filter Date — FlowFilter
12 Dimension 1 Filter Code[20] — FlowFilter
13 Dimension 2 Filter Code[20] — FlowFilter
14 G/L Budget Filter Code[10] — TableRelation Table 95 “G/L Budget Name” (G/L Budget Name); FlowFilter
15 Business Unit Filter Code[20] — TableRelation Table 220 “Business Unit” (Business Unit); FlowFilter
16 Show Δ BC29 Enum “Acc. Schedule Line Show” Specifies whether the line will be printed on the report. enum Enum 851 “Acc. Schedule Line Show”
17 Dimension 3 Filter Code[20] — FlowFilter
18 Dimension 4 Filter Code[20] — FlowFilter
19 Dimension 1 Totaling Δ BC29 Text[250] Specifies which dimension value amounts will be totaled on this line.
20 Dimension 2 Totaling Δ BC29 Text[250] Specifies which dimension value amounts will be totaled on this line.
21 Dimension 3 Totaling Δ BC29 Text[250] Specifies which dimension value amounts will be totaled on this line.
22 Dimension 4 Totaling Δ BC29 Text[250] Specifies which dimension value amounts will be totaled on this line.
23 Bold Δ BC29 Boolean Specifies whether to print the amounts in this row in bold.
24 Italic Δ BC29 Boolean Specifies whether to print the amounts in this row in italics.
25 Underline Δ BC29 Boolean Specifies whether to underline the amounts in this row.
26 Show Opposite Sign Δ BC29 Boolean Specifies whether to show debits in reports as negative amounts with a minus sign and credits as positive amounts.
27 Row Type Δ BC29 Option Specifies the row type for the row definition. The type determines how the amounts in the row are calculated. OptionCaption: Net Change,Balance at Date,Beginning Balance
28 Amount Type Δ BC29 Enum “Account Schedule Amount Type” Specifies the type of entries that will be included in the amounts in the row definition. enum Enum 333 “Account Schedule Amount Type”
30 Double Underline Δ BC29 Boolean Specifies whether to double underline the amounts in this row.
40 Hide Currency Symbol Δ BC29 Boolean Specifies whether to hide currency symbols when a calculated result is not a currency.
41 Dimension 5 Filter + BC28 Text[250] — FlowFilter
42 Dimension 6 Filter + BC28 Text[250] — FlowFilter
43 Dimension 7 Filter + BC28 Text[250] — FlowFilter
45 Dimension 8 Filter + BC28 Text[250] — FlowFilter
46 Internal Description + BC28 Text[500] Specifies the internal description for the row definition line that highlights complex logic or areas needing review for the next report designer.
840 Cash Flow Forecast Filter Code[20] — TableRelation Table 840 “Cash Flow Forecast” (Cash Flow Forecast); FlowFilter
1100 Cost Center Filter Code[20] — TableRelation Table 1112 “Cost Center” (Cost Center); FlowFilter
1101 Cost Object Filter Code[20] — TableRelation Table 1113 “Cost Object” (Cost Object); FlowFilter
1102 Cost Center Totaling Text[80] —
1103 Cost Object Totaling Text[80] —
1104 Cost Budget Filter Code[10] — TableRelation Table 1110 “Cost Budget Name” (Cost Budget Name); FlowFilter

Keys

  • Key1: Schedule Name, Line No. (clustered)

Events published

  • OnAfterCheckFormula(var Formula: Code[250]) (integration): Integration event raised after formula validation to enable custom formula processing and validation logic. Allows extensions to modify or validate formulas beyond standard syntax checking.
  • OnAfterLookupTotaling(var AccScheduleLine: Record "Acc. Schedule Line") (integration): Integration event raised after totaling lookup to enable custom post-processing of selected totaling values. Allows extensions to modify totaling expressions or perform additional validation after user selection.
  • OnAfterGetAccSchedSetup(var AnalysisView: Record "Analysis View"; AccScheduleName: Record "Acc. Schedule Name") (integration): Integration event raised after account schedule setup retrieval to enable custom analysis view configuration. Allows extensions to modify analysis view settings or dimension codes for custom reporting requirements.
  • OnBeforeGetCaptionClass(var AccScheduleLine: Record "Acc. Schedule Line"; AccSchedName: Record "Acc. Schedule Name"; AnalysisViewDimType: Integer; var Result: Text[250]; var IsHandled: Boolean) (integration): Integration event raised before caption class generation to enable custom dimension caption handling. Allows extensions to provide custom caption class formatting for dimension fields.
  • OnBeforeLookupTotaling(var AccScheduleLine: Record "Acc. Schedule Line"; var IsHandled: Boolean) (integration): Integration event raised before totaling lookup to enable custom totaling selection logic. Allows extensions to provide alternative totaling lookup mechanisms or skip standard lookup.
  • OnBeforeLookUpDimFilter(var AccScheduleLine: Record "Acc. Schedule Line"; DimNo: Integer; var Text: Text; AccSchedName: Record "Acc. Schedule Name"; var Result: Boolean; var IsHandled: Boolean) (integration): Integration event raised before dimension filter lookup to enable custom dimension filtering logic. Allows extensions to provide alternative dimension value selection mechanisms or skip standard lookup.

Trigger event subscribers

Procedures

  • LookUpDimFilter(DimNo: Integer; var Text: Text): Boolean: Opens dimension value lookup dialog for the specified dimension number and returns selected filter values. Enables interactive dimension value selection for dimension-based filtering in account schedule calculations.
  • CheckFormula(Formula: Code[250]): Validates formula syntax for proper parentheses matching and operator placement in account schedule formulas. Ensures formulas are syntactically correct before use in financial calculations.
  • GetCaptionClass(AnalysisViewDimType: Integer): Text[250]: Generates caption class text for dimension fields based on analysis view configuration. Provides dynamic field captions that reflect the actual dimension codes configured in the analysis view.
  • LookupTotaling(): Opens appropriate lookup dialog based on totaling type for selecting accounts, cost types, or cash flow accounts. Provides user-friendly selection interface for building totaling expressions in account schedule lines.
  • LookupGLBudgetFilter(var Text: Text): Boolean: Opens G/L budget name lookup dialog and returns selected budget names as filter text. Enables interactive selection of G/L budgets for budget-based financial analysis.
  • LookupCostBudgetFilter(var Text: Text): Boolean: Opens cost budget name lookup dialog and returns selected budget names as filter text. Enables interactive selection of cost budgets for cost accounting-based financial analysis.
  • Indent(): Increases indentation level for hierarchical display of account schedule line. Maximum indentation level is 10.
  • Outdent(): Decreases indentation level for hierarchical display of account schedule line. Minimum indentation level is 0.

Plus 1 local procedures.

Triggers

OnInsert

Relations

Referenced by

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

Pages and codeunits on this table

Extended by

Countries that replace it

CH, ES, RU

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

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: "Acc. Schedule Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources