Table 2633 "Statistical Ledger Entry"
StatisticalAccounts · Microsoft.Finance.Analysis.StatisticalAccount
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 7 connected objects and pages
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
- drill-down page Page 2634 “Statistical Ledger Entry List”
- lookup page Page 2634 “Statistical Ledger Entry List”
- Statistical Account No.: TableRelation Table 2632 “Statistical Account”
- Reversed by Entry No.: TableRelation Table 2633 “Statistical Ledger Entry”
- Reversed Entry No.: TableRelation Table 2633 “Statistical Ledger Entry”
- Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Shortcut Dimension 3 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 4 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 5 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 6 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 7 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 8 Code: CalcFormula Table 480 “Dimension Set Entry”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
Referenced by
5 fields in 2 objects relate to this table (TableRelation or CalcFormula).
- Table 2632 “Statistical Account”: Balance, Balance at Date, Net Change
- Table 2633 “Statistical Ledger Entry”: Reversed by Entry No., Reversed Entry No.
Pages and codeunits on this table
- Page 2634 “Statistical Ledger Entry 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” (1 call:
ShowDimensions → ShowDimensionSet)
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.