SELECT 'Activity' 'Type', T0.[ClgCode] 'DocEntry', T0.[ClgCode] 'DocNum', T0.[Closed], T0.[Recontact] AS DocDate, T2.[CardCode], T2.[CardName], T1.[U_NAME], COALESCE (LEFT(T3.firstName, 1) + LEFT(T3.lastName, 1), '') 'Initials', 0 'DocTotal', T0.[Details], T0.[BeginTime] 'ActivityTime', T4.[Name] 'ActivityName', T5.[SlpName] 'ActivitySalesEmployee', T0.[Notes] 'Content' FROM OCLG T0 INNER JOIN OUSR T1 ON T0.AttendUser = T1.USERID INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode LEFT OUTER JOIN OHEM T3 ON T0.[AttendUser] = T3.[USERID] LEFT OUTER JOIN OCPR T4 ON T0.CntctCode = T4.CntctCode LEFT OUTER JOIN OSLP T5 ON T0.SlpCode = T5.SlpCode WHERE COALESCE (T0.[parentType], 0) <> 97 AND T0.[Closed] = 'N' UNION ALL SELECT 'Quote', T0.[DocEntry], T0.[DocNum], T0.[DocStatus], T0.[DocDate], T0.[CardCode], T0.[CardName], T1.[SlpName], COALESCE (LEFT(T3.firstName, 1) + LEFT(T3.lastName, 1), ''), T0.[DocTotal], T0.[Comments], '', '', '', '' FROM OQUT T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode LEFT OUTER JOIN OPR1 T2 ON T0.[DocNum] = T2.[DocNumber] AND T2.[ObjType] = 23 LEFT OUTER JOIN OHEM T3 ON T1.[SlpCode] = T3.[salesPrson] WHERE T2.[OpprId] IS NULL AND T0.[DocStatus] <> 'C' UNION ALL SELECT 'Service Call', T0.[callID], T0.[callID], T1.[Name], T0.[createDate], T0.[customer], T0.[custmrName], COALESCE (T3.firstName + ' ' + T3.lastName, ''), COALESCE (LEFT(T3.firstName, 1) + LEFT(T3.lastName, 1), ''), 0, T0.[subject], T0.[createTime], '', T3.firstName + ' ' + T3.lastName, T0.[descrption] FROM [dbo].[OSCL] T0 INNER JOIN [dbo].[OSCS] T1 ON T0.status = T1.statusID LEFT OUTER JOIN OUSR T2 ON T0.assignee = T2.USERID LEFT OUTER JOIN OHEM T3 ON T2.[USERID] = T3.[userId] WHERE T0.status <> - 1