BC Observatoryunofficial, made by waldo
tableFinanceofficial - Microsoftderived - from the source, no model text

Table 349 "Dimension Value"

Base Application · Microsoft.Finance.Dimension

Open in Claude349.mdSource on GitHub

Across versions

  1. BC23present
  2. BC24declaration changed
  3. BC253 fields changed
  4. BC262 fields changed, 1 fields removed
  5. BC27unchanged
  6. BC281 events added
  7. BC299 fields changed
  8. BC30unchanged

Neighbourhood 236 connected objects and pages

Table 348 "Dimension" (relates to)Table 412 "IC Dimension Value" (relates to)Page 560 "Dimension Value List" (pages and codeunits on it, 2 links)Dimension Value ListCodeunit 409 "Dimension Value-Indent" (pages and codeunits on it)Codeunit 480 "Get Shortcut Dimension Values" (event subscribers)Codeunit 1100 "Cost Account Mgt" (calls, 2 links)Cost Account MgtCodeunit 408 "DimensionManagement" (calls, 2 links)DimensionManagementTable 15 "G/L Account" (referenced by, 4 links)G/L AccountTable 18 "Customer" (referenced by, 4 links)Table 23 "Vendor" (referenced by, 4 links)VendorTable 2632 "Statistical Account" (referenced by, 4 links)Statistical AccountTable 27 "Item" (referenced by, 4 links)ItemTable 270 "Bank Account" (referenced by, 4 links)Table 376 "G/L Account (Analysis View)" (referenced by, 4 links)G/L Account (Analysis View)Table 482 "Reclas. Dimension Set Buffer" (referenced by, 4 links)Table 5200 "Employee" (referenced by, 4 links)Table 6210 "Sustainability Account" (referenced by, 4 links)Sustainability AccountTable 6225 "Sust. Account (Analysis View)" (referenced by, 4 links)Sust. Account (Analysis View)Table 83 "Item Journal Line" (referenced by, 4 links)Table 352 "Default Dimension" (referenced by, 3 links)Table 356 "Dim. Value per Account" (referenced by, 3 links)Dim. Value per AccountTable 5489 "Dimension Set Entry Buffer" (referenced by, 3 links)Dimension Set Entry BufferTable 1001 "Job Task" (referenced by, 2 links)Job TaskTable 1004 "Job WIP Entry" (referenced by, 2 links)Table 1005 "Job WIP G/L Entry" (referenced by, 2 links)Job WIP G/L EntryTable 110 "Sales Shipment Header" (referenced by, 2 links)Table 111 "Sales Shipment Line" (referenced by, 2 links)Table 112 "Sales Invoice Header" (referenced by, 2 links)Table 113 "Sales Invoice Line" (referenced by, 2 links)Table 114 "Sales Cr.Memo Header" (referenced by, 2 links)Table 115 "Sales Cr.Memo Line" (referenced by, 2 links)Table 120 "Purch. Rcpt. Header" (referenced by, 2 links)Table 121 "Purch. Rcpt. Line" (referenced by, 2 links)Table 122 "Purch. Inv. Header" (referenced by, 2 links)Table 123 "Purch. Inv. Line" (referenced by, 2 links)Table 124 "Purch. Cr. Memo Hdr." (referenced by, 2 links)Table 125 "Purch. Cr. Memo Line" (referenced by, 2 links)Table 13 "Salesperson/Purchaser" (referenced by, 2 links)(v1.0) dimensionValues resource type (Learn pages)(v1.0) Get dimensionValues (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.Dimension · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 20053 “APIV1 Dimension Values Entity” (2 Learn pages), Page 30040 “APIV2 Dimension Values Entity” (2), Page 537 “Dimension Values” (1), Page 539 “Dimension Value Combinations” (1), Page 560 “Dimension Value List” (1), Page 2587 “Dim Corr Values Overview” (1), Page 9253 “Dim. Value Combinations Matrix” (1).

Properties

Property Value
Caption Dimension Value
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 Dimension Code Δ BC25 Δ BC26 Δ BC29 Code[20] Specifies the dimension code for the dimension value. TableRelation Table 348 “Dimension”; NotBlank
2 Code Δ BC26 Δ BC29 Code[20] Specifies the code for the dimension value. NotBlank
3 Name Δ BC25 Δ BC29 Text[50] Specifies a descriptive name for the dimension value.
4 Dimension Value Type Δ BC29 Option Specifies the purpose of the dimension value. OptionCaption: Standard,Heading,Total,Begin-Total,End-Total
5 Totaling Δ BC25 Δ BC29 Text[250] Specifies an account interval or a list of account numbers. The entries of the account will be totaled to give a total balance. How entries are totaled depends on the value in the Account Type field. TableRelation Table 349 “Dimension Value” (if (“Dimension Value Type” = const(Total)) “Dimension Value”.“Dimension Code” where(“Dimension Code” = field(“Dimension Code”)))
6 Blocked Δ BC29 Boolean Specifies that the related record is blocked from being posted in transactions, for example a customer that is declared insolvent or an item that is placed in quarantine.
7 Consolidation Code Δ BC29 Code[20] Specifies the code that is used for consolidation.
8 Indentation Integer —
9 Global Dimension No. Integer —
10 Map-to IC Dimension Code Δ BC29 Code[20] Specifies the intercompany’s dimension code associated with the dimension of the current company.
11 Map-to IC Dimension Value Code Δ BC29 Code[20] Specifies which intercompany dimension value corresponds to the dimension value on the line. TableRelation Table 412 “IC Dimension Value” (“IC Dimension Value”.Code where(“Dimension Code” = field(“Map-to IC Dimension Code”)))
12 Dimension Value ID Integer — not editable; AutoIncrement
8001 Last Modified Date Time DateTime —
8002 Dimension Id Guid — TableRelation Dimension.SystemId

Keys

  • Key1: Dimension Code, Code (clustered)
  • Key2: Code, Global Dimension No.
  • Key3: Name

Events published

  • OnAfterCheckIfDimValueUsed(DimensionValue: Record "Dimension Value"; DimensionSetEntry: Record "Dimension Set Entry"; var Result: Boolean) (integration): Integration event raised after checking if a dimension value is used in the system. Allows extensions to customize the dimension value usage validation logic.
  • OnBeforeCheckIfDimValueUsedFromOnDelete(DimensionValue: Record "Dimension Value"; xDimensionValue: Record "Dimension Value"; var IsHandled: Boolean) (integration): Integration event raised before checking if a dimension value is used during deletion. Allows extensions to implement custom dimension value usage validation.
  • OnBeforeUpdateCostAccFromDim(var DimensionValue: Record "Dimension Value"; var xDimensionValue: Record "Dimension Value"; CallingTrigger: Option OnInsert,OnModify,,OnRename; var IsHandled: Boolean) (integration): Integration event raised before updating cost accounting accounts from dimension value changes. Allows extensions to customize cost accounting integration logic.
  • OnBeforeOnRename(var DimensionValue: Record "Dimension Value"; var xDimensionValue: Record "Dimension Value") (integration): Integration event raised before renaming a dimension value. Allows extensions to perform custom validation or processing before the rename operation.
  • OnGetGlobalDimensionNoOnElseCase(DimensionCode: Code[20]; var GlobalDimensionNo: Integer) + BC28 (integration): Integration event raised in the else case of GetGlobalDimensionNo function. Allows extensions to provide global dimension numbers for custom dimension codes.

Trigger event subscribers

Procedures

  • CheckIfDimValueUsed(): Boolean: Checks whether this dimension value is being used in posted entries or dimension sets. Prevents deletion or modification of dimension values that would cause data integrity issues.
  • LookUpDimFilter(Dim: Code[20]; var Text: Text): Boolean: Opens a lookup page for dimension values and returns a filter string of selected values. Used in filter fields to allow multi-selection of dimension values.
  • LookupDimValue(DimCode: Code[20]; var DimValueCode: Code[20]): Opens a lookup page for selecting a single dimension value. Used for dimension value selection in forms and fields.

Plus 11 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

Relations

Referenced by

450 fields in 216 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.

Countries that replace it

RU

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

Evidence 1 sources