Table 365 "Analysis View Entry"
Base Application · Microsoft.Finance.Analysis
- 17fields
- 10procedures
- 5events
- 2Learn pages
- 1countries replace it
- 27fields reference it
- 4event subscribers
- 3objects it calls
Across versions
- BC23present
- BC24declaration changed
- BC25-27unchanged
- BC286 fields changed, 1 procedures added
- BC2916 fields changed
- BC30unchanged
Neighbourhood 17 connected objects and pages
Base Application · Microsoft.Finance.Analysis · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 558 “Analysis View Entries” (2 Learn pages).
Properties
| Property | Value |
|---|---|
| Caption | Analysis View Entry |
| 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 | Analysis View Code Δ BC29 | Code[10] | Specifies the analysis view. | TableRelation Table 363 “Analysis View” (“Analysis View” where(“Account Source” = field(“Account Source”))); NotBlank |
| 2 | Business Unit Code Δ BC29 | Code[20] | Specifies the code for the business unit that the analysis view is based on. | TableRelation Table 220 “Business Unit” (Business Unit) |
| 3 | Account No. Δ BC29 | Code[20] | Specifies the account that the analysis entry comes from. | TableRelation Table 15 “G/L Account”, Table 841 “Cash Flow Account” (if (“Account Source” = const(“G/L Account”)) “G/L Account” else if (“Account Source” = const(“Cash Flow Account”)) “Cash Flow Account”) |
| 4 | Dimension 1 Value Code Δ BC29 | Code[20] | Specifies the dimension value you selected for the analysis view dimension that you defined as Dimension 1 on the analysis view card. | |
| 5 | Dimension 2 Value Code Δ BC29 | Code[20] | Specifies the dimension value you selected for the analysis view dimension that you defined as Dimension 2 on the analysis view card. | |
| 6 | Dimension 3 Value Code Δ BC29 | Code[20] | Specifies the dimension value you selected for the analysis view dimension that you defined as Dimension 3 on the analysis view card. | |
| 7 | Dimension 4 Value Code Δ BC29 | Code[20] | Specifies the dimension value you selected for the analysis view dimension that you defined as Dimension 4 on the analysis view card. | |
| 8 | Posting Date Δ BC29 | Date | Specifies the entry’s posting date. | |
| 9 | Entry No. | Integer | — | |
| 10 | Amount Δ BC28 Δ BC29 | Decimal | Specifies the amount of the analysis view budget entry. | |
| 11 | Debit Amount Δ BC28 Δ BC29 | Decimal | Specifies the total of the ledger entries that represent debits. | |
| 12 | Credit Amount Δ BC28 Δ BC29 | Decimal | Specifies the total of the ledger entries that represent credits. | |
| 13 | Add.-Curr. Amount Δ BC28 Δ BC29 | Decimal | Specifies (in the additional reporting currency) the VAT difference that arises when you make a correction to a VAT amount on a sales or purchase document. | |
| 14 | Add.-Curr. Debit Amount Δ BC28 Δ BC29 | Decimal | Specifies, in the additional reporting currency, the amount of the debit entry. | |
| 15 | Add.-Curr. Credit Amount Δ BC28 Δ BC29 | Decimal | Specifies, in the additional reporting currency, the amount of the credit entry. | |
| 16 | Account Source Δ BC29 | Enum “Analysis Account Source” | Specifies an account that you can use as a filter to define what is displayed in the Analysis by Dimensions window. | enum Enum 7133 “Analysis Account Source” |
| 17 | Cash Flow Forecast No. Δ BC29 | Code[20] | Specifies a number for the cash flow forecast. | TableRelation Table 840 “Cash Flow Forecast” (Cash Flow Forecast) |
Keys
- Key1: Analysis View Code, Account No., Account Source, Dimension 1 Value Code, Dimension 2 Value Code, Dimension 3 Value Code, Dimension 4 Value Code, Business Unit Code, Posting Date, Entry No., Cash Flow Forecast No. (clustered)
- Key2: Analysis View Code, Account No., Account Source, Dimension 1 Value Code, Dimension 2 Value Code, Dimension 3 Value Code, Dimension 4 Value Code, Business Unit Code, Posting Date, Cash Flow Forecast No.
Events published
OnAfterGetCaptionClass(var AnalysisView: Record "Analysis View"; AnalysisViewDimType: Integer; var Result: Text[250])(integration): Integration event raised after calculating caption class for analysis view dimension fields. Enables customization of dimension field captions based on analysis view configuration.OnAfterDrillDown(var AnalysisViewEntry: Record "Analysis View Entry")(integration): Integration event raised after drilldown operation completes on analysis view entries. Enables additional processing after viewing detailed entries for analysis view records.OnBeforeGetCaptionClass(var AnalysisViewEntry: Record "Analysis View Entry"; AnalysisViewDimType: Integer; var AnalysisView: Record "Analysis View"; var Result: Text[250]; var IsHandled: Boolean)(integration): Integration event raised before calculating caption class for analysis view dimension fields. Enables custom logic to override standard caption class calculation.OnBeforeDrilldown(var AnalysisViewEntry: Record "Analysis View Entry"; var IsHandled: Boolean)(integration): Integration event raised before drilldown operation on analysis view entries. Enables custom drilldown logic to override standard G/L or Cash Flow entry display.- subscribers: Codeunit 2621 “Stat. Acc. Analysis View Mgt.” HandleOnBeforeDrilldown, Codeunit 6236 “Analysis View Entry Subscriber” OnBeforeDrilldown
OnLookupAccountNo(var AnalysisViewEntry: Record "Analysis View Entry"; var IsHandled: Boolean)(integration): Integration event raised when looking up account numbers in analysis view entries. Enables custom lookup logic for G/L accounts or Cash Flow accounts based on account source.- subscribers: Codeunit 2621 “Stat. Acc. Analysis View Mgt.” HandleOnLookupAccountNo, Codeunit 6236 “Analysis View Entry Subscriber” OnLookupAccountNo
Procedures
GetCaptionClass(AnalysisViewDimType: Integer): Text[250]: Gets the caption class for dimension fields based on analysis view configuration. Provides dynamic field captions based on the analysis view’s dimension setup and naming.DrillDown()CopyDimFilters(var AccSchedLine: Record "Acc. Schedule Line"): Copies dimension filters from account schedule line to analysis view entry. Transfers filter criteria for dimension-based analysis and reporting in account schedules.SetDimFilters(DimFilter1: Text; DimFilter2: Text; DimFilter3: Text; DimFilter4: Text): Sets dimension filters on analysis view entry using text filter expressions. Applies filter criteria for all four dimensions in analysis view queries and reports.
Plus 1 local procedures.
Relations
- drill-down page Page 558 “Analysis View Entries”
- lookup page Page 558 “Analysis View Entries”
- Account No.: TableRelation Table 15 “G/L Account” (conditional)
- Business Unit Code: TableRelation Table 220 “Business Unit”
- Analysis View Code: TableRelation Table 363 “Analysis View”
- Cash Flow Forecast No.: TableRelation Table 840 “Cash Flow Forecast”
- Account No.: TableRelation Table 841 “Cash Flow Account” (conditional)
Referenced by
27 fields in 3 objects relate to this table (TableRelation or CalcFormula).
- Table 6225 “Sust. Account (Analysis View)”: Bal. at Date (CO2e Emission), Balance (Carbon Fee), Balance (CH4), Balance (CO2), Balance (CO2e Emission), Balance (N2O), Balance at Date (Carbon Fee), Balance at Date (CH4), Balance at Date (CO2), Balance at Date (N2O), Net Change (Carbon Fee), Net Change (CH4), Net Change (CO2), Net Change (CO2e Emission), Net Change (N2O)
- Table 376 “G/L Account (Analysis View)”: Add.-Currency Balance at Date, Add.-Currency Credit Amount, Add.-Currency Debit Amount, Additional-Currency Balance, Additional-Currency Net Change, Balance, Balance at Date, Credit Amount, Debit Amount, Net Change
- Table 367 “Dimension Code Buffer”: Amount, Quantity
Pages and codeunits on this table
- Page 558 “Analysis View Entries” (source table)
Extended by
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 413 “AnalysisViewEntryToGLEntries” (2 calls:
DrillDown → GetCFLedgEntries,DrillDown → GetGLEntries) - Page 850 “Cash Flow Forecast Entries” (1 call:
DrillDown → (object)) - Query 2401 “General Ledger Entries” (1 call:
DrillDown → (object))
Countries that replace it
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). 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: "Analysis View Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.