C11/System/NAVISION/IQD/NW/verkaeufer_aktiv_struktur.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,GC_Navision
DATASOURCENAME,C:\GlobalCube\System\NAVISION\IQD\nw\verkaeufer_aktiv_struktur.imr
TITLE,verkaeufer_aktiv_struktur.imr
BEGIN SQL
select T1."User ID" as c1,
	   T1."Employee No_" as c2,
	   T1."Salesperson" as c3,
	   T2."No_" as c4,
	   T2."First Name" as c5,
	   T2."Last Name" as c6,
	   T2."Name" as c7,
	   T2."Status" as c8,
	   T2."Inactive Date" as c9,
	   T2."Termination Date" as c10,
	   'aktive Verkäufer' as c11
from ("NAVISION"."import"."User_Setup" T1 left outer join "NAVISION"."import"."Employee" T2 on ((((((T2."No_" = T1."Employee No_") and (T2."Status" = 0)) and (T2."Inactive Date" = TIMESTAMP '1753-01-01 00:00:00.000')) and (T2."Termination Date" = TIMESTAMP '1753-01-01 00:00:00.000')) and (T1."Salesperson" <> ' ')) and (T1."Salesperson" <> 'DIV')) and (T2."Client_DB" = T1."Client_DB"))
where (((T1."Salesperson" <> ' ') and (not T1."Salesperson" IN ('DIV','BMWREL'))) and ((cast_float(T1."Salesperson")) BETWEEN 100 AND 999))
order by c3 asc

END SQL
COLUMN,0,User Id
COLUMN,1,Employee No
COLUMN,2,Salesperson
COLUMN,3,No
COLUMN,4,First Name
COLUMN,5,Last Name
COLUMN,6,Name
COLUMN,7,Status
COLUMN,8,Inactive Date
COLUMN,9,Termination Date
COLUMN,10,Verkäufer / Sonstige