tableFinanceofficial - Microsoftderived - from the source, no model text

Table 365 "Analysis View Entry"

Base Application · Microsoft.Finance.Analysis

Across versions

  1. BC23present
  2. BC24declaration changed
  3. BC25-27unchanged
  4. BC286 fields changed, 1 procedures added
  5. BC2916 fields changed
  6. BC30unchanged

Neighbourhood 17 connected objects and pages

Table 15 "G/L Account" (relates to)G/L AccountTable 220 "Business Unit" (relates to)Business UnitTable 363 "Analysis View" (relates to)Analysis ViewTable 840 "Cash Flow Forecast" (relates to)Cash Flow ForecastTable 841 "Cash Flow Account" (relates to)Cash Flow AccountPage 558 "Analysis View Entries" (pages and codeunits on it, 3 links)Analysis View EntriesTable extension 6223 "Sust. Analysis View Entry" (extended by)Sust. Analysis View EntryCodeunit 2621 "Stat. Acc. Analysis View Mgt." (event subscribers, 2 links)Stat. Acc. Analysis View Mgt.Codeunit 6236 "Analysis View Entry Subscriber" (event subscribers, 2 links)Analysis View Entry SubscriberCodeunit 413 "AnalysisViewEntryToGLEntries" (calls, 2 links)AnalysisViewEntryToGLEntriesPage 850 "Cash Flow Forecast Entries" (calls)Cash Flow Forecast EntriesQuery 2401 "General Ledger Entries" (calls)Table 6225 "Sust. Account (Analysis View)" (referenced by, 15 links)Sust. Account (Analysis View)Table 376 "G/L Account (Analysis View)" (referenced by, 10 links)G/L Account (Analysis View)Table 367 "Dimension Code Buffer" (referenced by, 2 links)Dimension Code BufferAnalyze data by dimensions (Learn pages)Create analysis reports (Learn pages)

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.

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.
  • 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.

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

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

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.

Countries that replace it

ES

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.

Evidence 1 sources