Dimensions table in Microsoft Dynamics 365 Business Central. 19 fields, 28 records in Cronus demo.
Dimension Value holds all the individual values for each dimension in Business Central — e.g. if you have a Department dimension, values like "Sales", "Marketing", and "IT" each get a row here. Dimensions drive virtually all analytical reporting and are posted against every ledger entry.
The primary key uniquely identifies each record in this table. It consists of: Dimension Code, Code.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Dimension Code PK | Code | Normal | → Dimension #348 |
| 2 | Code PK | Code | Normal | |
| 3 | Name | Text | Normal | |
| 4 | Dimension Value Type | Option | Normal | |
| 5 | Totaling | Text | Normal | |
| 6 | Blocked | Boolean | Normal | |
| 7 | Consolidation Code | Code | Normal | |
| 8 | Indentation | Integer | Normal | |
| 9 | Global Dimension No. | Integer | Normal | |
| 10 | Map-to IC Dimension Code | Code | Normal | |
| 11 | Map-to IC Dimension Value Code | Code | Normal | → IC Dimension Value #412 |
| 12 | Dimension Value ID | Integer | Normal | |
| 8001 | Last Modified Date Time | DateTime | Normal | |
| 8002 | Dimension Id | GUID | Normal | → Dimension #348 |
| 2000000000 | System ID | GUID | Normal | |
| 2000000001 | Created At | DateTime | Normal | |
| 2000000002 | Created By | GUID | Normal | |
| 2000000003 | Modified At | DateTime | Normal | |
| 2000000004 | Modified By | GUID | Normal |
Tables referenced by fields on the Dimension Value table through TableRelation properties.