C11/System/WERWISO/IQD/NW/DATEV_VK_Hilfe_Boni.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,DATEV_DWH
DATASOURCENAME,C:\GlobalCube\System\WERWISO\IQD\nw\DATEV_VK_Hilfe_Boni.imr
TITLE,DATEV_VK_Hilfe_Boni.imr
BEGIN SQL
select T1."Mandant ID" as c1,
	   T1."Konto" as c2,
	   T1."Belegdatum" as c3,
	   T1."Buchungstext" as c4,
	   (od_left(T1."Belegfeld 1",9)) as c5,
	   T1."Herkunft-Kz" as c6,
	   T1."Belegfeld 2" as c7,
	   T1."KOST1 - Kostenstelle" as c8,
	   T1."KOST2 - Kostenstelle" as c9,
	   T1."Konto_Datev_Kontenbeschriftung" as c10,
	   T1."Kostenstelle_Traeger" as c11,
	   T1."Konto_Zeichen" as c12,
	   T1."Länge_Konto_Zeichen" as c13,
	   T1."Standort_ID" as c14,
	   T1."Marke_ID" as c15,
	   T1."KST_ID" as c16,
	   T1."Absatzkanal_ID" as c17,
	   T1."Antriebsart_ID" as c18,
	   T1."Bookkeep Date" as c19,
	   T1."Kostenträger_ID" as c20,
	   T1."Acct Nr" as c21,
	   T1."Umsatz Soll" as c22,
	   T1."Umsatz Haben" as c23,
	   (cast_float(T1."Betrag")) as c24,
	   T1."PK_Auto" as c25,
	   T1."Marke_mit_Bez" as c26,
	   T1."Kostenträger_mit_Bez" as c27,
	   T1."Absatzkanal_mit_Bez" as c28,
	   T1."KST_mit_Bez" as c29,
	   (cinteger(nconvert(((od_left(T1."Belegfeld 1",9)))),0)) as c30
from "ZdbSNCDatawarehouseDATEV"."dbo"."fBuchungsbelege" T1
where ((T1."Konto" IN (78000,78500)) and (((od_left(T1."Belegfeld 1",9))) BETWEEN '0' AND '9999999999999'))

END SQL
COLUMN,0,Mandant Id
COLUMN,1,Konto
COLUMN,2,Belegdatum
COLUMN,3,Buchungstext
COLUMN,4,Belegfeld 1
COLUMN,5,Herkunft-kz
COLUMN,6,Belegfeld 2
COLUMN,7,Kost1 - Kostenstelle
COLUMN,8,Kost2 - Kostenstelle
COLUMN,9,Konto Datev Kontenbeschriftung
COLUMN,10,Kostenstelle Traeger
COLUMN,11,Konto Zeichen
COLUMN,12,Länge Konto Zeichen
COLUMN,13,Standort Id
COLUMN,14,Marke Id
COLUMN,15,Kst Id
COLUMN,16,Absatzkanal Id
COLUMN,17,Antriebsart Id
COLUMN,18,Bookkeep Date
COLUMN,19,Kostenträger Id
COLUMN,20,Acct Nr
COLUMN,21,Umsatz Soll
COLUMN,22,Umsatz Haben
COLUMN,23,Betrag
COLUMN,24,Pk Auto
COLUMN,25,Marke Mit Bez
COLUMN,26,Kostenträger Mit Bez
COLUMN,27,Absatzkanal Mit Bez
COLUMN,28,Kst Mit Bez
COLUMN,29,Belegfeld_Zahl