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.

MSXOpportunityTeam

Data source: microsoftsales.crm.dynamics.com

select
o.msp_opportunitynumber as CRMOpportunityID,
upper(u.domainname) as OpportunityTeamAlias,
u.msp_rolesummary as RoleSummary,
u.msp_gtmposition as GTMPosition,
u.msp_qualifier1 as Qualifier1,
u.msp_qualifier2 as Qualifier2,
t.msp_name as DisplayName,
t.statuscodename as TeamStatus,
t.msp_isownername as IsOwner,'' as ETLDate
from [dbo].[msp_dealteam] t
inner join [dbo].[opportunity] o on o.opportunityid = t.msp_parentopportunityid
inner join [dbo].[systemuser] u on u.systemuserid = t.msp_dealteamuserid