Table "Dim. Value per Account"
Stores allowed dimension values per specific account configuration. Manages dimension value permissions and validation for individual accounts across different table types.
Remarks
Used to control which dimension values are permitted for specific accounts in various master data tables. Supports dimension value validation during posting and data entry operations. Integrates with default dimension management for account-specific dimension value restrictions.
Properties
| Name | Value |
|---|---|
| DataClassification | SystemMetadata |
Fields
| Name | Type | Description |
|---|---|---|
| "Table ID" | Integer | Table identifier specifying which master data table the account belongs to. |
| "No." | Code[20] | Account number or identifier within the specified table. |
| "Dimension Code" | Code[20] | Dimension code for which value permissions are being managed. |
| "Dimension Value Code" | Code[20] | Specific dimension value code that is allowed or restricted for this account. |
| "Dimension Value Name" | Text[50] | Display name of the dimension value for user interface presentation. |
| "Dimension Value Type" | Option | Type classification of the dimension value indicating its role in hierarchical structures. |
| Indentation | Integer | Indentation level for hierarchical display of dimension values in user interfaces. |
| Allowed | Boolean | Indicates whether this dimension value is allowed for the specified account. |
| 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
GetCaption
Generates a formatted caption string combining dimension code, table name, and account number. Provides user-friendly display text for dimension value per account records.
procedure GetCaption(): Text[250]Returns
| Type | Description |
|---|---|
| Text[250] |
Formatted caption text with dimension code, table caption, and account number |
Remarks
Uses table translation for localized table names and follows standard caption formatting patterns. Useful for display purposes in user interfaces and reports.
GetTableCaption
Retrieves the localized caption for the table specified by Table ID. Provides translated table name based on current user language settings.
procedure GetTableCaption(): Text[250]Returns
| Type | Description |
|---|---|
| Text[250] |
Localized table caption text |
Remarks
Uses Object Translation functionality to provide language-specific table names. Supports multilingual environments with proper table name localization.
RenameNo
Renames dimension value per account records when account numbers change. Updates all related dimension value permissions for the specified account and dimension.
procedure RenameNo(TableId: Integer; OldNo: Code[20]; NewNo: Code[20]; DimensionCode: Code[20])Parameters
| Name | Type | Description |
|---|---|---|
| TableId | Integer |
Table identifier containing the account |
| OldNo | Code[20] |
Original account number to be renamed |
| NewNo | Code[20] |
New account number after renaming |
| DimensionCode | Code[20] |
Dimension code for which permissions are being updated |
Remarks
Maintains data integrity during account renaming operations by updating all related dimension value permissions. Ensures dimension value restrictions follow the account through renaming processes.
RenameDimension
Renames dimension value per account records when dimension codes change. Updates all related dimension value permissions for the specified dimension across all accounts.
procedure RenameDimension(OldDimensionCode: Code[20]; NewDimensionCode: Code[20])Parameters
| Name | Type | Description |
|---|---|---|
| OldDimensionCode | Code[20] |
Original dimension code to be renamed |
| NewDimensionCode | Code[20] |
New dimension code after renaming |
Remarks
Maintains data integrity during dimension renaming operations by updating all related dimension value permissions. Ensures dimension value restrictions follow the dimension through renaming processes across all accounts.
RenameDimensionValue
Renames dimension value per account records when dimension value codes change. Updates all related dimension value permissions for the specified dimension value across all accounts.
procedure RenameDimensionValue(DimensionCode: Code[20]; OldDimensionValueCode: Code[20]; NewDimensionValueCode: Code[20])Parameters
| Name | Type | Description |
|---|---|---|
| DimensionCode | Code[20] |
Dimension code containing the value to be renamed |
| OldDimensionValueCode | Code[20] |
Original dimension value code to be renamed |
| NewDimensionValueCode | Code[20] |
New dimension value code after renaming |
Remarks
Maintains data integrity during dimension value renaming operations by updating all related permissions. Ensures dimension value restrictions follow the dimension value through renaming processes across all accounts.