C11/System/NAVISION/SQL/schema/NAVISION/views/ims.Verkaeufer_aktiv.sql

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE VIEW ims.verkaeufer_aktiv AS

select T1."User ID" as "User Id",
	   T1."Employee No_" as "Employee No",
	   T1."Salesperson" as "Salesperson",
	   T2."No_" as "No",
	   T2."First Name" as "First Name",
	   T2."Last Name" as "Last Name",
	   T2."Name" as "Name",
	   T2."Status" as "Status",
	   T2."Inactive Date" as "Inactive Date",
	   T2."Termination Date" as "Termination Date"
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" = convert(datetime, '1753-01-01 00:00:00.000'))) and (T2."Termination Date" = convert(datetime, '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 (T1."Salesperson" <> 'DIV')) and ((convert(float, T1."Salesperson")) BETWEEN 100 AND 999)) and (T2."Status" = 0))
-- order by "Salesperson" asc
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO