tableFinanceofficial - Microsoftderived - from the source, no model text

Table 480 "Dimension Set Entry"

Base Application · Microsoft.Finance.Dimension

Across versions

  1. BC23present
  2. BC242 fields changed
  3. BC25declaration changed
  4. BC26-27unchanged
  5. BC281 events added
  6. BC294 fields changed
  7. BC30unchanged

Neighbourhood 167 connected objects and pages

Table 348 "Dimension" (relates to, 2 links)Table 349 "Dimension Value" (relates to, 2 links)Page 479 "Dimension Set Entries" (pages and codeunits on it, 3 links)Page 2586 "Dim Corr Find by Dimension" (pages and codeunits on it)Page 30303 "API Finance - Dim Set Entries" (pages and codeunits on it)Page 480 "Edit Dimension Set Entries" (pages and codeunits on it)Page 699 "Dimension Set Entries FactBox" (pages and codeunits on it)Table 1004 "Job WIP Entry" (referenced by, 7 links)Job WIP EntryTable 1005 "Job WIP G/L Entry" (referenced by, 7 links)Job WIP G/L EntryTable 1570 "G/L Entry Posting Preview" (referenced by, 7 links)G/L Entry Posting PreviewTable 169 "Job Ledger Entry" (referenced by, 7 links)Job Ledger EntryTable 17 "G/L Entry" (referenced by, 7 links)G/L EntryTable 203 "Res. Ledger Entry" (referenced by, 7 links)Table 21 "Cust. Ledger Entry" (referenced by, 7 links)Cust. Ledger EntryTable 25 "Vendor Ledger Entry" (referenced by, 7 links)Vendor Ledger EntryTable 2633 "Statistical Ledger Entry" (referenced by, 7 links)Statistical Ledger EntryTable 271 "Bank Account Ledger Entry" (referenced by, 7 links)Table 281 "Phys. Inventory Ledger Entry" (referenced by, 7 links)Phys. Inventory Ledger EntryTable 32 "Item Ledger Entry" (referenced by, 7 links)Table 5222 "Employee Ledger Entry" (referenced by, 7 links)Employee Ledger EntryTable 5601 "FA Ledger Entry" (referenced by, 7 links)Table 5625 "Maintenance Ledger Entry" (referenced by, 7 links)Maintenance Ledger EntryTable 5802 "Value Entry" (referenced by, 7 links)Value EntryTable 5832 "Capacity Ledger Entry" (referenced by, 7 links)Capacity Ledger EntryTable 5907 "Service Ledger Entry" (referenced by, 7 links)Service Ledger EntryTable 5908 "Warranty Ledger Entry" (referenced by, 7 links)Table 6216 "Sustainability Ledger Entry" (referenced by, 7 links)Table 6227 "Sustainability Value Entry" (referenced by, 7 links)Table 6241 "Sust. Excise Taxes Trans. Log" (referenced by, 7 links)Table 6912 "Expense Ledger Entry" (referenced by, 7 links)Table 847 "Cash Flow Forecast Entry" (referenced by, 7 links)Table 2584 "Dim Correction Set Buffer" (referenced by, 2 links)Table 83 "Item Journal Line" (referenced by, 2 links)Table 110 "Sales Shipment Header" (referenced by)Table 111 "Sales Shipment Line" (referenced by)Table 112 "Sales Invoice Header" (referenced by)Table 113 "Sales Invoice Line" (referenced by)Table 114 "Sales Cr.Memo Header" (referenced by)Table 115 "Sales Cr.Memo Line" (referenced by)Work with dimensions to track and analyze data (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 479 “Dimension Set Entries” (1 Learn page), Page 480 “Edit Dimension Set Entries” (1), Page 699 “Dimension Set Entries FactBox” (1), Page 2586 “Dim Corr Find by Dimension” (1).

Properties

Property Value
Caption Dimension Set Entry
DataClassification CustomerContent
Permissions TableData “Dimension Set Entry” = rim, TableData “Dimension Set Tree Node” = rim

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 Set ID Integer —
2 Dimension Code Δ BC29 Code[20] Specifies the dimension. TableRelation Table 348 “Dimension”; NotBlank
3 Dimension Value Code Δ BC29 Code[20] Specifies the dimension value. TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Dimension Code” = field(“Dimension Code”), Blocked = const(false))); NotBlank
4 Dimension Value ID Integer —
5 Dimension Name Δ BC24 Δ BC29 Text[30] Specifies the descriptive name of the Dimension Code field. FlowField: lookup(Dimension.Name where(Code = field(“Dimension Code”))); not editable
6 Dimension Value Name Δ BC24 Δ BC29 Text[50] Specifies the descriptive name of the Dimension Value Code field. FlowField: lookup(“Dimension Value”.Name where(“Dimension Code” = field(“Dimension Code”), Code = field(“Dimension Value Code”))); not editable
8 Global Dimension No. Integer Shortcut Dimension No. caption

Keys

  • Key1: Dimension Set ID, Dimension Code (clustered)
  • Key2: Dimension Value ID
  • Key3: Dimension Code, Dimension Value Code, Dimension Set ID
  • Key4: SystemModifiedAt

Events published

  • OnBeforeGetDimensionSetID(var DimensionSetEntry: Record "Dimension Set Entry") (integration): Integration event raised before starting dimension set ID creation or retrieval process. Enables custom preprocessing or validation of dimension entries before set processing.
  • OnGetDimensionSetIDOnBeforeInsertTreeNode(var DimensionSetEntry: Record "Dimension Set Entry"; var Found: Boolean) (integration): Integration event raised before inserting nodes into the dimension set tree structure. Enables custom logic during tree node creation and duplicate detection process.
  • OnAfterGetGlobalDimNo(DimensionCode: Code[20]; var GlobalDimensionNo: Integer) + BC28 (integration): Integration event raised after determining global dimension number for a dimension code. Enables custom logic to assign global dimension numbers for dimensions not configured as shortcuts.

Procedures

  • GetDimensionSetID(var DimSetEntry: Record "Dimension Set Entry"): Integer: Creates or retrieves the dimension set ID for a collection of dimension entries. Uses tree structure optimization to avoid duplicate dimension sets and improve performance.
  • UpdateGlobalDimensionNo(DimensionCode: Code[20]; GlobalDimensionNo: Integer): Updates the global dimension number for all entries with the specified dimension code. Used when changing shortcut dimension assignments in General Ledger Setup.
  • GetGlobalDimNo(): Integer: Determines the global dimension number (3-8) for the current dimension code. Returns the shortcut dimension number configured in General Ledger Setup.

Plus 1 local procedures.

Triggers

OnInsert, OnModify

Relations

Referenced by

305 fields in 159 objects relate to this table (TableRelation or CalcFormula).

Pages and codeunits on this table

Ask your agent

Procedure bodies are not stored here (D10). 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 Set Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources