Search This Blog

Monday, February 20, 2012

AX2012 Financial journal Dimension Table Relations.



The view DimensionAttributeLevelValueView gives you the individual segments entered in a journal including the main account and each of the selected financial dimensions.  There is a record created in the view for each segment of the transaction.
  For example, if you create a payment journal and enter the vendor and two financial dimensions under the Financial dimensions button there will be 3 records in this view for that transaction.  The DisplayValue field in the view will show you the dimension you selected and all 3 of the records in the view will have the same value in the ValueCombinationRecId field.
The ValueCombinationRecId field in the DimensionAttributeLevelValueView = the RecId from the DimensionAttributeValueCombination table.  The DimensionAttributeValueCombination table stores all of the dimensions including the main account as a string in the DisplayValue field.  The RecId from the DimensionAttributeValueCombination is saved on the LedgerJournalTrans table in the LedgerDimension field.
Also in the DimensionAttributeLevelValueView view the DimensionAttribute field is the RecId of the DimensionAttribute table.  The DimensionAttribute table defines the dimension that the transaction is based on. 
 For example, if you are creating a payment journal the entity is coming from the VendTable.  You can find the entity type/table for the record (like VendTable) by querying the DimensionAttribute table using the DimensionAttribute field in the DimensionAttributeLevelValueView and retrieving the BackingEntityTableName field.  The EntityInstance field in the DimensionAttributeLevelValueView = RecId from the record in the BackingEntityTableName table.  In the case of a payment journal the EntityInstance returns a RecId from the VendTable.

No comments:

Post a Comment

Thanks for visiting my blog,
I will reply for your comment within 48 hours.

Thanks,
krishna.