Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
304

Cordial Saludo:

Envió reporte de oportunidades:

SELECT T0.[OpenDate], T0.[CloseDate] as 'Fecha de Cierre', T0.[OpprId] as Oportunidad, T0.[Name], T0.[CardCode], T0.[CardName], T1.[SlpName] as 'Asesor Comercial', T0.[MaxSumLoc] as 'Monto Potencial',T2.[Descript] AS 'Nivel de Interes', T3.[Descript] as Fuente,T4.[IndName] as Sector , Estado= CASE T0.[Status] WHEN 'W' THEN 'GANADO' WHEN 'O' THEN 'ABIERTO' WHEN 'L' THEN 'PERDIDO' ELSE 'N/A' END, T0.[CloPrcnt] FROM OOPR T0  INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode INNER JOIN OOIR T2 ON T0.IntRate = T2.Num INNER JOIN OOSR T3 ON T0.Source = T3.Num INNER JOIN OOND T4 ON T0.Industry = T4.IndCode WHERE T0.[OpenDate] between [%0] and [%1] ORDER BY T0.[OpenDate] asc

A espera de sus comentarios.

Labels in this area