Table "Dimension Value"

ID 349

Namespace: Microsoft.Finance.Dimension

Table Dimension Value (ID 349). Stores the individual values that can be assigned to dimensions for transaction analysis. Provides hierarchical organization with different value types for flexible reporting structures.

Properties

Name	Value
Caption	Dimension Value
LookupPageID	Page Microsoft.Finance.Dimension."Dimension Value List"
DataClassification	CustomerContent

Fields

Name	Type	Description
"Dimension Code"	Code[20]	The dimension code that this value belongs to. Links this dimension value to its parent dimension definition.
Code	Code[20]	The unique code that identifies this dimension value within its dimension. This code is used in transactions to specify the dimension analysis category.
Name	Text[50]	The descriptive name of the dimension value that appears in the user interface. Provides a user-friendly description of what this dimension value represents.
"Dimension Value Type"	Option	Defines the type of dimension value for reporting hierarchy purposes. Standard values can be posted to, while Heading, Total, Begin-Total, and End-Total are used for reporting structure.
Totaling	Text[250]	Filter specification for Total and End-Total dimension value types. Defines which dimension values are included in the total calculation for reporting.
Blocked	Boolean	Indicates whether the dimension value is blocked from being used in new transactions. Blocked dimension values cannot be selected in new documents but existing data remains unchanged.
"Consolidation Code"	Code[20]	The consolidation code used when consolidating financial data across business units. Links this dimension value to corresponding dimension values in subsidiary companies.
Indentation	Integer	Controls the visual indentation level for hierarchical display in reports and forms. Used to create structured layouts with heading and total dimension values.
"Global Dimension No."	Integer	Identifies which global dimension position this dimension value belongs to. Values 1-8 correspond to Global Dimension 1, Global Dimension 2, and Shortcut Dimensions 3-8.
"Map-to IC Dimension Code"	Code[20]	Maps this dimension value to an intercompany dimension for transactions between related companies. Must correspond to a valid IC dimension in the intercompany setup.
"Map-to IC Dimension Value Code"	Code[20]	Maps this dimension value to a specific intercompany dimension value code. Used for automatic translation during intercompany transactions.
"Dimension Value ID"	Integer	Unique system-generated identifier for the dimension value. Used internally for performance optimization in dimension set operations.
"Last Modified Date Time"	DateTime	System field that tracks when the dimension value record was last modified. Used for synchronization and audit purposes.
"Dimension Id"	Guid	System identifier linking this dimension value to its parent dimension record. Used for API integration and maintaining referential integrity.
SystemId	Guid
SystemCreatedAt	DateTime
SystemCreatedBy	Guid
SystemModifiedAt	DateTime
SystemModifiedBy	Guid
SystemCreatedByUserName	Text[50]
SystemCreatedByFullName	Text[80]
SystemModifiedByUserName	Text[50]
SystemModifiedByFullName	Text[80]
SystemRowVersion	BigInteger

Methods

CheckIfDimValueUsed

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.

procedure CheckIfDimValueUsed(): Boolean

Returns

Type	Description
Boolean	True if the dimension value is used in the system; false otherwise.

LookUpDimFilter

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.

procedure LookUpDimFilter(Dim: Code[20]; var Text: Text): Boolean

Parameters

Name	Type	Description
Dim	Code[20]	The dimension code to filter dimension values by.
Text	Text	Returns the filter string of selected dimension values.

Returns

Type	Description
Boolean	True if values were selected; false if cancelled.

LookupDimValue

Opens a lookup page for selecting a single dimension value. Used for dimension value selection in forms and fields.

procedure LookupDimValue(DimCode: Code[20]; var DimValueCode: Code[20])

Parameters

Name	Type	Description
DimCode	Code[20]	The dimension code to filter dimension values by.
DimValueCode	Code[20]	The current dimension value code, returns the selected value.

Events

OnAfterCheckIfDimValueUsed

Integration event raised after checking if a dimension value is used in the system. Allows extensions to customize the dimension value usage validation logic.

[IntegrationEvent(False,False)]
local procedure OnAfterCheckIfDimValueUsed(DimensionValue: Record "Dimension Value"; DimensionSetEntry: Record "Dimension Set Entry"; var Result: Boolean)

Parameters

Name	Type	Description
DimensionValue	Table Microsoft.Finance.Dimension."Dimension Value"	The dimension value being checked for usage.
DimensionSetEntry	Table Microsoft.Finance.Dimension."Dimension Set Entry"	The dimension set entry used in the usage check.
Result	Boolean	Returns true if the dimension value is used; can be modified by subscribers.

OnBeforeCheckIfDimValueUsedFromOnDelete

Integration event raised before checking if a dimension value is used during deletion. Allows extensions to implement custom dimension value usage validation.

[IntegrationEvent(False,False)]
local procedure OnBeforeCheckIfDimValueUsedFromOnDelete(DimensionValue: Record "Dimension Value"; xDimensionValue: Record "Dimension Value"; var IsHandled: Boolean)

Parameters

Name	Type	Description
DimensionValue	Table Microsoft.Finance.Dimension."Dimension Value"	The dimension value being deleted.
xDimensionValue	Table Microsoft.Finance.Dimension."Dimension Value"	The original dimension value record before changes.
IsHandled	Boolean	Set to true to skip standard usage checking logic.

OnBeforeUpdateCostAccFromDim

Integration event raised before updating cost accounting accounts from dimension value changes. Allows extensions to customize cost accounting integration logic.

[IntegrationEvent(False,False)]
local procedure OnBeforeUpdateCostAccFromDim(var DimensionValue: Record "Dimension Value"; var xDimensionValue: Record "Dimension Value"; CallingTrigger: Option; var IsHandled: Boolean)

Parameters

Name	Type	Description
DimensionValue	Table Microsoft.Finance.Dimension."Dimension Value"	The dimension value being modified.
xDimensionValue	Table Microsoft.Finance.Dimension."Dimension Value"	The original dimension value record before changes.
CallingTrigger	Option	Indicates which trigger called this event (OnInsert, OnModify, OnRename).
IsHandled	Boolean	Set to true to skip standard cost accounting update logic.

OnBeforeOnRename

Integration event raised before renaming a dimension value. Allows extensions to perform custom validation or processing before the rename operation.

[IntegrationEvent(False,False)]
local procedure OnBeforeOnRename(var DimensionValue: Record "Dimension Value"; var xDimensionValue: Record "Dimension Value")

Parameters

Name	Type	Description
DimensionValue	Table Microsoft.Finance.Dimension."Dimension Value"	The dimension value after rename with new values.
xDimensionValue	Table Microsoft.Finance.Dimension."Dimension Value"	The original dimension value record before rename.

OnGetGlobalDimensionNoOnElseCase

Integration event raised in the else case of GetGlobalDimensionNo function. Allows extensions to provide global dimension numbers for custom dimension codes.

[IntegrationEvent(False,False)]
local procedure OnGetGlobalDimensionNoOnElseCase(DimensionCode: Code[20]; var GlobalDimensionNo: Integer)

Parameters

Name	Type	Description
DimensionCode	Code[20]	The dimension code for which the global dimension number is being requested.
GlobalDimensionNo	Integer	Returns the global dimension number for the given dimension code; set by subscribers if the dimension code is custom.

See also

• Table