Note: This content is automatically generated by the ETL tool. Last build time is 2024-03-19 13:44:37. Please contact MWS Insights Data Infrastructure for the query.

OpportunityProductDetail

Data source: CRM

<entity name="opportunityproduct">
<attribute name="opportunityproductname"/>
<attribute name="transactioncurrencyid"/>
<order attribute="productid" descending="false"/>
<attribute name="uomid"/>
<attribute name="quantity"/>
<attribute name="msp_pricelist"/>
<attribute name="priceperunit"/>
<attribute name="msp_months"/>
<attribute name="extendedamount"/>
<attribute name="msp_committedmonths"/>
<attribute name="propertyconfigurationstatus"/>
<attribute name="productid"/>
<attribute name="opportunityproductid"/>
<link-entity name="opportunity" from="opportunityid" to="opportunityid" alias="bb">
<attribute name="msp_opportunitynumber"/>
<filter type="and">
<condition attribute="msp_solutionarea" operator="eq" value="394380002"/>
<condition attribute="estimatedclosedate" operator="on-or-after" value="2022-07-01"/>
</filter>
</link-entity>
</entity>
</fetch>