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.

EngagementMilestoneSalesProgram

Data source: Dynamic CRM

<entity name="msp_salesprogram">
<attribute name="statecode"/>
<attribute name="msp_name"/>
<order attribute="msp_name" descending="false"/>
<filter type="and">
<condition attribute="statecode" operator="eq" value="0"/>
</filter>
<attribute name="msp_startdate"/>
<attribute name="msp_type"/>
<attribute name="msp_enddate"/>
<attribute name="ownerid"/>
<attribute name="msp_siteurl"/>
<attribute name="createdon"/>
<attribute name="msp_salesprogramid"/>
<link-entity name="msp_msp_engagementmilestone_msp_salesprogra" intersect="true" visible="false" to="msp_salesprogramid" from="msp_salesprogramid">
<link-entity name="msp_engagementmilestone" from="msp_engagementmilestoneid" to="msp_engagementmilestoneid" alias="bb">
<attribute name="msp_milestonenumber"/>
</link-entity>
</link-entity>
</entity>
</fetch>