Table 2631 "Statistical Acc. Journal Line"

StatisticalAccounts · Microsoft.Finance.Analysis.StatisticalAccount · captioned “Statistical Account Journal” · BC29-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 2633 “Statistical Accounts Journal” (1 Learn page).

Properties

Property	Value
Caption	Statistical Account Journal
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	Journal Template Name	Code[10]	—	not editable
2	Journal Batch Name	Code[10]	Journal batch name caption	not editable
3	Line No.	Integer	—
7	Document No.	Code[20]	Specifies the number of the related document. via Page 2633 “Statistical Accounts Journal”
10	Statistical Account No.	Code[20]	Specifies the account number that the entry on the journal line will be posted to. via Page 2633 “Statistical Accounts Journal”	TableRelation Table 2632 “Statistical Account” (Statistical Account)
11	Posting Date	Date	Specifies the date of the transaction in the statistical ledger, and thereby the fiscal year and period. via Page 2633 “Statistical Accounts Journal”
12	Description	Text[100]	Specifies a description of the entry. via Page 2633 “Statistical Accounts Journal”
13	Amount	Decimal	Specifies the amount of the entry. via Page 2633 “Statistical Accounts Journal”
14	Amount Change	Decimal	Allocated Amt. (LCY) caption	FlowField: sum(“Statistical Acc. Journal Line”.Amount where(“Journal Template Name” = field(“Journal Template Name”), “Journal Batch Name” = field(“Journal Batch Name”), “Statistical Account No.” = field(“Statistical Account No.”))); not editable
24	Shortcut Dimension 1 Code	Code[20]	Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup page. via Page 2633 “Statistical Accounts Journal”	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false)))
25	Shortcut Dimension 2 Code	Code[20]	Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup page. via Page 2633 “Statistical Accounts Journal”	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false)))
50	Statistical Account Name	Text[100]	Specifies the name of the account. via Page 2633 “Statistical Accounts Journal”	FlowField: lookup(“Statistical Account”.Name where(“No.” = field(“Statistical Account No.”)))
480	Dimension Set ID	Integer	—	TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable

Keys

Key1: Journal Template Name, Journal Batch Name, Line No. (clustered)
Key2: Journal Template Name, Journal Batch Name, Statistical Account No.

Events published

OnAfterCreateDimensions(var StatisticalAccJournalLine: Record "Statistical Acc. Journal Line"; xStatisticalAccJournalLine: Record "Statistical Acc. Journal Line"; CurrentFieldNo: Integer; OldDimSetID: Integer; DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]) (integration)

Procedures

LookupBatchName(var JournalBatchName: Code[10]; var StatisticalAccJournalLine: Record "Statistical Acc. Journal Line") (internal)
SetName(JournalBatchName: Code[10]; var StatisticalAccJournalLine: Record "Statistical Acc. Journal Line") (internal)
CheckName(JournalBatchName: Code[10]): Boolean (internal)
ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20]) (internal)
ShowDimensions() (internal)
SelectJournal(var JournalBatchName: Code[10]) (internal)
SetUpNewLine(PreviousStatisticalAccJournalLine: Record "Statistical Acc. Journal Line"; JournalBatchName: Code[10]) (internal)
GetBalance(StatisticalAccountJournalLine: Record "Statistical Acc. Journal Line"; var BalanceAfterPosting: Decimal; var Balance: Decimal) (internal)
ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20]) (internal)

Plus 3 local procedures.

Relations

Amount Change: CalcFormula Table 2631 “Statistical Acc. Journal Line”
Statistical Account Name: CalcFormula Table 2632 “Statistical Account”
Statistical Account No.: TableRelation Table 2632 “Statistical Account”
Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”

Referenced by

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

Table 2630 “Statistical Acc. Journal Batch”: No. of Lines
Table 2631 “Statistical Acc. Journal Line”: Amount Change

Pages and codeunits on this table

Page 2633 “Statistical Accounts Journal” (source table)
Codeunit 2623 “Stat. Acc. Jnl Check Line” (codeunit runs on it)
Codeunit 2624 “Stat. Acc. Jnl. Line Post” (codeunit runs on it)
Codeunit 2626 “Stat. Acc. Post. Batch” (codeunit runs on it)

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” (5 calls: CreateDimensions → GetRecDefaultDimID, InitDefaultDimensionSources → AddDimSource, ShowDimensions → EditDimensionSet, …)
Page 2630 “Statistical Acc. Journal Batch” (1 call: LookupBatchName → (object))

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