Table 480 "Dimension Set Entry"
Base Application · Microsoft.Finance.Dimension
Across versions
- BC23present
- BC242 fields changed
- BC25declaration changed
- BC26-27unchanged
- BC281 events added
- BC294 fields changed
- BC30unchanged
Neighbourhood 167 connected objects and pages
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
- drill-down page Page 479 “Dimension Set Entries”
- lookup page Page 479 “Dimension Set Entries”
- Dimension Name: CalcFormula Table 348 “Dimension”
- Dimension Code: TableRelation Table 348 “Dimension”
- Dimension Value Name: CalcFormula Table 349 “Dimension Value”
- Dimension Value Code: TableRelation Table 349 “Dimension Value”
Referenced by
305 fields in 159 objects relate to this table (TableRelation or CalcFormula).
- Table 1004 “Job WIP Entry”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 1005 “Job WIP G/L Entry”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 1570 “G/L Entry Posting Preview”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 169 “Job Ledger Entry”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 17 “G/L Entry”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 203 “Res. Ledger Entry”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 21 “Cust. Ledger Entry”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 25 “Vendor Ledger Entry”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 2633 “Statistical Ledger Entry”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 271 “Bank Account Ledger Entry”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 281 “Phys. Inventory Ledger Entry”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 32 “Item Ledger Entry”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 5222 “Employee Ledger Entry”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 5601 “FA Ledger Entry”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 5625 “Maintenance Ledger Entry”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 5802 “Value Entry”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 5832 “Capacity Ledger Entry”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 5907 “Service Ledger Entry”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 5908 “Warranty Ledger Entry”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 6216 “Sustainability Ledger Entry”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 6227 “Sustainability Value Entry”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 6241 “Sust. Excise Taxes Trans. Log”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 6912 “Expense Ledger Entry”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 847 “Cash Flow Forecast Entry”: Shortcut Dimension 3 Code, Shortcut Dimension 4 Code, Shortcut Dimension 5 Code, Shortcut Dimension 6 Code, Shortcut Dimension 7 Code, Shortcut Dimension 8 Code, Dimension Set ID
- Table 2584 “Dim Correction Set Buffer”: Dimension Set ID, Target Set ID
- Table 83 “Item Journal Line”: Dimension Set ID, New Dimension Set ID
- Table 110 “Sales Shipment Header”: Dimension Set ID
- Table 111 “Sales Shipment Line”: Dimension Set ID
- Table 112 “Sales Invoice Header”: Dimension Set ID
- Table 113 “Sales Invoice Line”: Dimension Set ID
- Table 114 “Sales Cr.Memo Header”: Dimension Set ID
- Table 115 “Sales Cr.Memo Line”: Dimension Set ID
- Table 120 “Purch. Rcpt. Header”: Dimension Set ID
- Table 121 “Purch. Rcpt. Line”: Dimension Set ID
- Table 122 “Purch. Inv. Header”: Dimension Set ID
- Table 123 “Purch. Inv. Line”: Dimension Set ID
- Table 124 “Purch. Cr. Memo Hdr.”: Dimension Set ID
- Table 125 “Purch. Cr. Memo Line”: Dimension Set ID
- Table 1690 “Bank Deposit Header”: Dimension Set ID
- Table 1691 “Posted Bank Deposit Header”: Dimension Set ID
- Table 1692 “Posted Bank Deposit Line”: Dimension Set ID
- Table 1706 “Deferral Posting Buffer”: Dimension Set ID
- Table 171 “Standard Sales Line”: Dimension Set ID
- Table 174 “Standard Purchase Line”: Dimension Set ID
- Table 181 “Posted Gen. Journal Line”: Dimension Set ID
- Table 207 “Res. Journal Line”: Dimension Set ID
- Table 210 “Job Journal Line”: Dimension Set ID
- Table 212 “Job Posting Buffer”: Dimension Set ID
- Table 221 “Gen. Jnl. Allocation”: Dimension Set ID
- Table 246 “Requisition Line”: Dimension Set ID
- and 109 more objects (109 fields): data/code/relations/29.json
Pages and codeunits on this table
- Page 2586 “Dim Corr Find by Dimension” (source table)
- Page 30303 “API Finance - Dim Set Entries” (source table)
- Page 479 “Dimension Set Entries” (source table)
- Page 480 “Edit Dimension Set Entries” (source table)
- Page 699 “Dimension Set Entries FactBox” (source 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.