Table 2632 "Statistical Account"

StatisticalAccounts · Microsoft.Finance.Analysis.StatisticalAccount · BC29-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 2623 “Stat. Account Balance” (1 Learn page), Page 2631 “Statistical Account Card” (1), Page 2632 “Statistical Account List” (1).

Properties

Property	Value
Caption	Statistical Account
DataClassification	CustomerContent
LookupPageId	Statistical Account List
DrillDownPageId	Statistical Account List

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	No.	Code[20]	Specifies the statistical account number. via Page 2631 “Statistical Account Card”
2	Name	Text[100]	Specifies the statistical account name. via Page 2631 “Statistical Account Card”
6	Global Dimension 1 Code	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false)))
7	Global Dimension 2 Code	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false)))
13	Blocked	Boolean	Specifies that the statistical account cannot be used. via Page 2631 “Statistical Account Card”
28	Date Filter	Date	—	FlowFilter
29	Global Dimension 1 Filter	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))); FlowFilter
30	Global Dimension 2 Filter	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))); FlowFilter
31	Balance at Date	Decimal	—	FlowField: sum(“Statistical Ledger Entry”.Amount where(“Statistical Account No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(upperlimit(“Date Filter”)), “Dimension Set ID” = field(“Dimensi…; not editable
32	Net Change	Decimal	—	FlowField: sum(“Statistical Ledger Entry”.Amount where(“Statistical Account No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter”), “Dimension Set ID” = field(“Dimension Set ID Fi…; not editable
36	Balance	Decimal	Specifies the balance via Page 2631 “Statistical Account Card”	FlowField: sum(“Statistical Ledger Entry”.Amount where(“Statistical Account No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter”), “Dimension Set ID” = field(“Dimension Set ID Fi…; not editable
400	Dimension Set ID Filter	Integer	—	FlowFilter

Keys

Key1: No. (clustered)

Procedures

GetFeatureTelemetryName(): Text

Plus 1 local procedures.

Triggers

OnRename, OnDelete

Relations

drill-down page Page 2632 “Statistical Account List”
lookup page Page 2632 “Statistical Account List”
Balance: CalcFormula Table 2633 “Statistical Ledger Entry”
Balance at Date: CalcFormula Table 2633 “Statistical Ledger Entry”
Net Change: CalcFormula Table 2633 “Statistical Ledger Entry”
Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
Global Dimension 1 Filter: TableRelation Table 349 “Dimension Value”
Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
Global Dimension 2 Filter: TableRelation Table 349 “Dimension Value”

Referenced by

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

Table 2630 “Statistical Acc. Journal Batch”: Statistical Account Name, Statistical Account No.
Table 2631 “Statistical Acc. Journal Line”: Statistical Account Name, Statistical Account No.
Table 2633 “Statistical Ledger Entry”: Statistical Account No.
Table extension 2625 “StatAccAnalysisView”: Statistical Account Filter

Pages and codeunits on this table

Page 2623 “Stat. Account Balance” (source table)
Page 2631 “Statistical Account Card” (source table)
Page 2632 “Statistical Account List” (source table)

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Codeunit 408 “DimensionManagement” (4 calls: OnDelete → DeleteDefaultDim, OnRename → RenameDefaultDim, ValidateShortcutDimCode → SaveDefaultDim, …)

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. 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: "Statistical Account"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.