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.

AVAOpportunity

Data source: org7df2f13a.crm.dynamics.com

select
[ava_msxid] as CRMOpportunityID,
[ava_reporttypename] as ReportType,
[ava_businessvalueid] as BusinessValueID,
[ava_isoutputgenerated] as IsOutputGenerated,
[ava_businessvaluemapid] as BusinessValueMapID,
[ava_businessvaluereport] as BusinessValueReportID,
[ava_businessvaluereportname] as BusinessValueReportName,
'' as ETLDate
from [ava_businessvalue] b
left outer join [ava_businessvaluemap] m on m.[ava_businessvaluereport] = b.[ava_businessvalueid]