Finally I found the query to get this and its common for all, we can use the DefaultDimension key to get the details or we can join with transaction table using this field
select itemid, DimensionAttribute.Name, DimensionAttributeValueSetItem.DisplayValue
from InventJournalTrans A
left join DimensionAttributeValueSet on DimensionAttributeValueSet.RecId = A.DEFAULTDIMENSION
left join DimensionAttributeValueSetItem
on DimensionAttributeValueSetItem.DimensionAttributeValueSet = DimensionAttributeValueSet.RecId
left join DimensionAttributeValue
on DimensionAttributeValue.RecId = DimensionAttributeValueSetItem.DimensionAttributeValue
left join DimensionAttribute
on DimensionAttribute.RecId = DimensionAttributeValue.DimensionAttribute
where JOURNALID = 'W-00000153'
