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.

AMMPSolutionAssessment

Data source: msxserver.database.windows.net

SELECT [OpportunityNumber] AS CRMOpportunityID
,[SalesRequestID]
,[CreatedDate]
,[EstimatedCloseDate]
,[ActualCloseDate]
,[AreaName]
,[RegionName]
,[SubsidiaryName]
,[POD]
,[SegmentGroup]
,[ClosedMonthEnd]
,[Fiscalyear]
,[Status]
,[TPID/AccountNumber] AS TPID
,[TopParentName/AccountName] AS TopParent
,[SolutionArea]
,[AssessmentType]
,[MPNID]
,[PartnerName]
FROM [Partner].[All_SA_KPI_Feed_AMMP]