AX 2012 Ledger Dimension and Default Dimension AX2012

AX 2012 has two different types of dimension fields in LedgerJournalTrans and Order tables.

1. LedgerDimension field represents the Main Account and associated dimensions in Accounting structure and used in Journal transactions. 

It has been related to DimensionAttributeValueCombination table and it has an entry for each MainAccount + Dimensions selected.



2. DefaultDimension field is you see on Orders, it shows all default dimension attributes (like Cost Center, Business Unit, Department) and dimension values for each dimension attribute. 

                

It has been related to DimensionAttributeValueSet table and it has an entry for each Dimensions selected in DimensionAttributeValueSetItem table.

Thanks,

K. Arunsubramaniam