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.

OpportunityProductDetail2

Data source: CRM

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true" returntotalrecordcount="true"  count="1000" no-lock="false">
<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">
</filter>
</link-entity>
</entity>
</fetch>