Dimension Value Type Field, Dimension Value Table
Specify the purpose of the dimension value in this field. The dimension value type is based on the same principles as Account Type in the Chart of Accounts and is used to create a hierarchical relationship between the dimension values. This characteristic can be used effectively to analyze commercial activities at different levels of detail. The program automatically assigns the dimension values to the Standard dimension value type, but you can change this. click the field to select one of the following options:
Dimension Value Type | Function |
---|---|
Standard |
Used for the standard posting of dimension values. |
Main |
A main dimension for a group of dimension values. |
Total |
Total is used for the program to total a series of dimension values that do not immediately have priority over the total dimension value. Use Total when you need to add up the dimension values of several groups of different dimension values. If you use the Total dimension value type, the Totaling field cannot be blank. |
Begin-Total |
A flag for the start of a series of dimension values that must be totaled, ends with an End-Total dimension value type. The dimension value type Begin-Total can also be posted in the same way as the Standard dimension value type. |
End-Total |
A total for the series of dimension values beginning with the Begin-Total dimension value. The total is defined in the Totaling field. |
Total and end total are used together to group dimension values, and also to create hierarchical relationships for groups within groups. In this example, you can see that a user has used the Dimension Value Type field to create a Northern European dimension value group within the European dimension value group:
Code | Name | Dimension Value Type |
---|---|---|
10 |
Europe |
Begin-Total |
20 |
Northern Europe |
Begin-Total |
30 |
Northern Europe (EU) |
Standard |
40 |
Northern Europe (not EU) |
Standard |
50 |
Northern Europe, Total |
End-Total |
60 |
Southern Europe |
Standard |
70 |
Europe, Total |
End-Total |
This means that a posting of the Northern Europe (EU) dimension value is an independent value, as well as a component of the total values of Europe and Northern Europe.
When you click the Functions button and then select Indent Dimension Values, the dimension values between Begin-Total and End-Total are automatically indented by one space. At the same time, the Totaling field of the dimension value of End-Greater type is filled in using the dimension values of the group. In the scenario above, sales from countries in the European Union and from those outside it would be totaled and the result displayed in the Northern Europe balance field, Total dimension field.
You can set the Indent function to fill in the Totaling field of the End-Total dimension values instead of entering the figures manually.
Click on the Dimension table for more information.
Tip
For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.
Parent Tables
Table | Location |
---|---|
Dimension Value Table | General Ledger |