Consolidation Code Field, Dimension Table

Specifies the code that is used for consolidation.

Do not make an entry here unless the entire company, including dimensions, will be transferred to the consolidated company when you consolidate.

If you are transferring the entire company, enter the dimension code in the consolidated company that corresponds to the dimension code in this business unit. For example, to consolidate the dimension Area in this business unit into the Area dimension in the consolidated company, enter Area here.

The table should be completed like this:

Code Name Consolidation Code


Sales Area


By using both the dimension and dimension value consolidation codes, you can create a company-specific consolidation from business unit to consolidated company.


You can give the same consolidation code to several dimensions if you want the entries for these dimensions to be added together when you consolidate.

The consolidation code is only used when the company is consolidated.


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 Table General Ledger
Dimension Table General Ledger

See Also

Other Resources

How to: Set Up Dimensions and Dimension Values
Dimensions - Detail
About Consolidations