How to identify the promotions (promotion id ) associated with a commerce item?

[Raja Ramachandran]

Hi,

I'm trying to build a data warehouse model for an ATG commerce schema. One of the requirement is to identify the promotions ( promotion_id) associated at an oder level and at item level. I was looking at the **amount_info and **price_det tables to see if it holds any sort of relation. I couldnt find. Can someone tell me if such a relation ship exists at a DB level OOTB or do I have to extend the CommerceItem and Order tables to hold this relationship?

Thanks,
Raja

[Matt Landau]

Look at the AmountInfo's "adjustments" property.

[Raja Ramachandran]

Thanks Matt.I was tied in a semi all day and could respond earlier. That worked.