tableFinanceofficial - Microsoftderived - from the source, no model text

Table 2633 "Statistical Ledger Entry"

StatisticalAccounts · Microsoft.Finance.Analysis.StatisticalAccount

Across versions

  1. BC23-28not present
  2. BC29-30present

Neighbourhood 7 connected objects and pages

Table 480 "Dimension Set Entry" (relates to, 7 links)Dimension Set EntryTable 349 "Dimension Value" (relates to, 2 links)Dimension ValueTable 2632 "Statistical Account" (relates to)Statistical AccountPage 2634 "Statistical Ledger Entry List" (pages and codeunits on it, 3 links)Statistical Ledger Entry ListCodeunit 408 "DimensionManagement" (calls)DimensionManagementTable 2632 "Statistical Account" (referenced by, 3 links)Statistical AccountUse Statistical Accounts to Analyze Non-Transactional Data (Learn pages)Use Statistical Accounts to …

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.

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

Learn documents this table through its pages: Page 2634 “Statistical Ledger Entry List” (1 Learn page).

Properties

Property Value
Caption Statistical Ledger Entry
DataClassification CustomerContent
LookupPageId Statistical Ledger Entry List
DrillDownPageId Statistical Ledger Entry 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 Entry No. Integer Specifies the entry number of the ledger entry. via Page 2634 “Statistical Ledger Entry List”
3 Statistical Account No. Code[20] Specifies the statistical account number of the ledger entry. via Page 2634 “Statistical Ledger Entry List” TableRelation Table 2632 “Statistical Account” (Statistical Account)
4 Posting Date Date Specifies the posting date of the ledger entry. via Page 2634 “Statistical Ledger Entry List”
6 Document No. Code[20] —
7 Description Text[100] Specifies the description of the ledger entry. via Page 2634 “Statistical Ledger Entry List”
17 Amount Decimal Specifies the amount of the ledger entry. via Page 2634 “Statistical Ledger Entry List”
23 Global Dimension 1 Code Code[20] Specifies the code for Global Dimension 1, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 2634 “Statistical Ledger Entry List” TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1)))
24 Global Dimension 2 Code Code[20] Specifies the code for Global Dimension 2, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 2634 “Statistical Ledger Entry List” TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2)))
27 User ID Code[50] Specifies the ID of the user who posted the entry. The ID is used, for example, in the change log. via Page 2634 “Statistical Ledger Entry List” TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
46 Journal Batch Name Code[10] —
52 Transaction No. Integer —
73 Reversed Boolean Specifies whether the entry has been part of a reverse transaction (correction) made by the Reverse action. via Page 2634 “Statistical Ledger Entry List”
74 Reversed by Entry No. Integer Specifies the number of the correcting entry. If this field shows a number the entry has already been reversed, and it cannot be reversed again. via Page 2634 “Statistical Ledger Entry List” TableRelation Table 2633 “Statistical Ledger Entry” (Statistical Ledger Entry)
75 Reversed Entry No. Integer Specifies the number of the original entry that was undone by the reverse transaction. via Page 2634 “Statistical Ledger Entry List” TableRelation Table 2633 “Statistical Ledger Entry” (Statistical Ledger Entry)
480 Dimension Set ID Integer Specifies a reference to a combination of dimension values. The actual values are stored in the Dimension Set Entry table. via Page 2634 “Statistical Ledger Entry List” TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable
481 Shortcut Dimension 3 Code Code[20] Specifies the code for Shortcut Dimension 3, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 2634 “Statistical Ledger Entry List” FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(3))); not editable
482 Shortcut Dimension 4 Code Code[20] Specifies the code for Shortcut Dimension 4, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 2634 “Statistical Ledger Entry List” FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(4))); not editable
483 Shortcut Dimension 5 Code Code[20] Specifies the code for Shortcut Dimension 5, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 2634 “Statistical Ledger Entry List” FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(5))); not editable
484 Shortcut Dimension 6 Code Code[20] Specifies the code for Shortcut Dimension 6, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 2634 “Statistical Ledger Entry List” FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(6))); not editable
485 Shortcut Dimension 7 Code Code[20] Specifies the code for Shortcut Dimension 7, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 2634 “Statistical Ledger Entry List” FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(7))); not editable
486 Shortcut Dimension 8 Code Code[20] Specifies the code for Shortcut Dimension 8, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 2634 “Statistical Ledger Entry List” FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(8))); not editable

Keys

  • Key1: Entry No. (clustered)
  • Key2: Posting Date
  • Key3: Statistical Account No.

Procedures

  • ShowDimensions() (internal)

Relations

Referenced by

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

Pages and codeunits on this 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.

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

Evidence 1 sources