C11/System/ARIntelligence/IQD/Service/Kontenklasse_4_als_Kosten_Service.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,Navision2
DATASOURCENAME,C:\gaps_bmw\Portal\System\IQD\Service\Kontenklasse_4_als_Kosten_Service.imr
TITLE,Kontenklasse_4_als_Kosten_Service.imr
BEGIN SQL
select distinct T1."Entry No_" as c1,
	   T1."G_L Account No_" as c2,
	   T1."Posting Date" as c3,
	   T1."Document Type" as c4,
	   T1."Document No_" as c5,
	   T1."Description" as c6,
	   T1."Bal_ Account No_" as c7,
	   (cast_float(T1."Amount")) as c8,
	   T1."Department Code" as c9,
	   T1."Make Code" as c10,
	   T1."Source Code" as c11,
	   T1."Job No_" as c12,
	   T1."Quantity" as c13,
	   (cast_float(T1."Debit Amount")) as c14,
	   (cast_float(T1."Credit Amount")) as c15,
	   T1."Document Date" as c16,
	   T1."Source Type" as c17,
	   T1."Source No_" as c18,
	   T1."Branch Code" as c19,
	   T1."Main Area" as c20,
	   T1."VIN" as c21,
	   ((cast_float(T1."Amount"))) as c22,
	   T2."Source No_" as c23,
	   T3."No_" || ' - ' || T3."Name" as c24,
	   T4."Description" as c25
from "DMS1"."dbo"."Automag GmbH$G_L Entry" T1,
	(("DMS1"."dbo"."Automag GmbH$Service Ledger Entry" T2 left outer join "DMS1"."dbo"."Automag GmbH$Customer" T3 on T3."No_" = T2."Source No_") left outer join "DMS1"."dbo"."Automag GmbH$Customer Group" T4 on T3."Customer Group Code" = T4."Code")
where (T1."Document No_" = T2."Order No_")
and ((((T1."G_L Account No_" LIKE '4%') and (T1."Posting Date" >= TIMESTAMP '2017-01-01 00:00:00.000')) and ((T1."Document No_" LIKE 'WA1%') or (T1."Document No_" LIKE 'WLG%'))) and (not (od_left(T2."Source No_",3)) IN ('INT','GAR')))
order by c5 asc,c1 asc

END SQL
COLUMN,0,Entry No
COLUMN,1,G L Account No
COLUMN,2,Posting Date
COLUMN,3,Document Type
COLUMN,4,Document No
COLUMN,5,Description
COLUMN,6,Bal Account No
COLUMN,7,Amount
COLUMN,8,Department Code
COLUMN,9,Make Code
COLUMN,10,Source Code
COLUMN,11,Job No
COLUMN,12,Quantity
COLUMN,13,Debit Amount
COLUMN,14,Credit Amount
COLUMN,15,Document Date
COLUMN,16,Source Type
COLUMN,17,Source No
COLUMN,18,Branch Code
COLUMN,19,Main Area
COLUMN,20,Vin
COLUMN,21,ohne Berechnung FIBU
COLUMN,22,Source No
COLUMN,23,Kunde_Verkaufskunde
COLUMN,24,Kundenart_Verkaufskunde