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.

W365TPAccount

Data source: CRM

<fetch version="1.0" output-format="xml-platform" mapping="logical" returntotalrecordcount="true" page="1" count="50" no-lock="false" distinct="true">
<entity name="opportunity">
<attribute name="statecode"/>
<attribute name="name"/>
<attribute name="msp_parentopportunityid"/>
<attribute name="msp_opportunitynumber"/>
<attribute name="parentaccountid"/>
<attribute name="ownerid"/>
<attribute name="opportunityid"/>
<filter type="and">
<filter type="or">
</filter>
</filter>
<link-entity name="account" visible="false" to="parentaccountid" from="accountid" link-type="outer" alias="a_76946cd0245c4349bbb98a1ed211155a">
<attribute name="address1_stateorprovince"/><attribute name="address2_stateorprovince"/>
<attribute name="msp_mssalesid"/><attribute name="msp_mstopparentid"/>
</link-entity>
<link-entity name="systemuser" from="systemuserid" to="createdby" link-type="outer" alias="a_d48de7fff4214c7f8a336b13da8bcef8" visible="false">
<attribute name="address1_stateorprovince"/>
</link-entity>
<link-entity name="systemuser" from="systemuserid" to="modifiedby" link-type="outer" alias="a_718185a8992949de9280bbc7c0590c1a" visible="false">
<attribute name="address1_stateorprovince"/>
</link-entity>
<link-entity name="systemuser" from="systemuserid" to="msp_operationscontact" link-type="outer" alias="a_0db945880df04c17a16bd465fb9ed1ac" visible="false">
<attribute name="address1_stateorprovince"/>
</link-entity>
<attribute name="opportunityid" rowaggregate="CountChildren" alias="HierarchyDataChildCount6dcd9e4c001441b09237d51a34853d55"/>
<order attribute="name" descending="false"/>
</entity>
</fetch>