COGNOS QUERY STRUCTURE,1,1 DATABASE,GC_Navision DATASOURCENAME,C:\GlobalCube\System\NAVISION\IQD\belege\Belege_GuV.imr TITLE,Belege_GuV.imr BEGIN SQL select T1."No_" as c1, T1."Name" as c2, T1."Search Description" as c3, T1."Account Type" as c4, T1."Department Code" as c5, T1."Make Code" as c6, T1."Income_Balance" as c7, T1."Last Date Modified" as c8, T2."Entry No_" as c9, T2."G_L Account No_" as c10, T2."Posting Date" as c11, T2."Document Type" as c12, T2."Document No_" as c13, T2."Description" as c14, T2."Bal_ Account No_" as c15, T2."Department Code" as c16, T2."Make Code" as c17, T2."User ID" as c18, T2."Source Code" as c19, T2."Quantity" as c20, T2."Reason Code" as c21, T2."Gen_ Posting Type" as c22, T2."Gen_ Bus_ Posting Group" as c23, T2."Gen_ Prod_ Posting Group" as c24, T2."Bal_ Account Type" as c25, T2."Transaction No_" as c26, T2."Document Date" as c27, T2."External Document No_" as c28, T2."Source Type" as c29, T2."Source No_" as c30, T2."No_ Series" as c31, T2."Branch Code" as c32, T2."Main Area" as c33, T2."VIN" as c34, T2."Book No_" as c35, T2."Veh_ Source Code" as c36, T2."Reposted" as c37, T2."Corrected" as c38, T2."Correction to curr_ No_" as c39, T2."Reposting to curr_ No_" as c40, T3."Code" as c41, T3."Name" as c42, T2."Posting Date" as c43, CASE WHEN ((T2."Branch Code" = 'MM') or (T2."Branch Code" = '')) THEN ('10') WHEN (T2."Branch Code" = 'VÖH') THEN ('20') WHEN (T2."Branch Code" = 'KRU') THEN ('30') WHEN (T2."Branch Code" = 'ULM') THEN ('40') WHEN (T2."Branch Code" = 'LL') THEN ('50') WHEN (T2."Branch Code" = 'GZ') THEN ('55') WHEN (T2."Branch Code" IN ('AAM','LEH','WTB')) THEN ('60') ELSE ((od_left(T1."Department Code",2))) END as c44, T2."G_L Account No_" as c45, ((cast_float(T2."Amount"))) * -1 as c46, (cast_float(T2."Amount")) as c47 from "NAVISION"."import"."G_L_Account" T1, ("NAVISION"."import"."G_L_Entry" T2 left outer join "NAVISION"."import"."Department" T3 on (T2."Department Code" = T3."Code") and (T2."Client_DB" = T3."Client_DB")) where ((T1."No_" = T2."G_L Account No_") and (T1."Client_DB" = T2."Client_DB")) and (((((T1."Income_Balance" = 0) and (T2."Document No_" <> 'ABSCHLUSS2008_1')) and (not T2."Document No_" IN ('ABSCHLUSS2009_1','ABSCHLUSS2009_2','ABSCHLUSS2009_3','ABSCHLUSS_1','ABSCHLUSS2011','ABSCHLUSS2012','ABSCHLUSS2013','ABSCHLUSS2014','ABSCHLUSS2015','ABSCHLUSS2016','ABSCHLUSS2017','ABSCHLUSS2018','ABSCHLUSS2019'))) and (T2."Source Code" <> 'JAHRABSCH')) and (T2."Posting Date" >= TIMESTAMP '2021-01-01 00:00:00.000')) END SQL COLUMN,0,No COLUMN,1,Name COLUMN,2,Search Description COLUMN,3,Account Type COLUMN,4,Department Code COLUMN,5,Make Code COLUMN,6,Income Balance COLUMN,7,Last Date Modified COLUMN,8,Entry No COLUMN,9,G L Account No COLUMN,10,Posting Date COLUMN,11,Document Type COLUMN,12,Document No COLUMN,13,Description COLUMN,14,Bal Account No COLUMN,15,Department Code COLUMN,16,Make Code COLUMN,17,User Id COLUMN,18,Source Code COLUMN,19,Quantity COLUMN,20,Reason Code COLUMN,21,Gen Posting Type COLUMN,22,Gen Bus Posting Group COLUMN,23,Gen Prod Posting Group COLUMN,24,Bal Account Type COLUMN,25,Transaction No COLUMN,26,Document Date COLUMN,27,External Document No COLUMN,28,Source Type COLUMN,29,Source No COLUMN,30,No Series COLUMN,31,Branch Code COLUMN,32,Main Area COLUMN,33,Vin COLUMN,34,Book No COLUMN,35,Veh Source Code COLUMN,36,Reposted COLUMN,37,Corrected COLUMN,38,Correction To Curr No COLUMN,39,Reposting To Curr No COLUMN,40,Code COLUMN,41,Name COLUMN,42,Jahr COLUMN,43,Betrieb Nr COLUMN,44,Konto Nr COLUMN,45,Betrag COLUMN,46,Amount_1