COGNOS QUERY
STRUCTURE,1,1
DATABASE,O_21_9
DATASOURCENAME,C:\Gaps\Portal\System\IQD\Belege\Kasse_dere09.imr
TITLE,Kasse_dere09.imr
BEGIN SQL
select T1."ACCT_NR" as c1,
	   T1."TRANSACT_DATE" as c2,
	   T1."HANDLER" as c3,
	   T1."LEDGER_ACCTS_NAME" as c4,
	   T1."DEPT_SPLIT" as c5,
	   T1."TYPE_ACCTT" as c6,
	   (database()) as c7,
	   (@CURRENT_DATE) - INTERVAL '001 00:00:00.000' as c8,
	   CASE WHEN (T1."TRANSACT_DATE" < ((@CURRENT_DATE) - INTERVAL '001 00:00:00.000')) THEN ('1') ELSE ('0') END as c9,
	   (asciiz(extract(YEAR FROM T1."TRANSACT_DATE"),4) || '-' || asciiz(extract(MONTH FROM T1."TRANSACT_DATE"),2) || '-' || asciiz(extract(DAY FROM T1."TRANSACT_DATE"),2)) as c10,
	   (substring(((asciiz(extract(YEAR FROM T1."TRANSACT_DATE"),4) || '-' || asciiz(extract(MONTH FROM T1."TRANSACT_DATE"),2) || '-' || asciiz(extract(DAY FROM T1."TRANSACT_DATE"),2))) from 9 for 2)) || '.' || (substring(((asciiz(extract(YEAR FROM T1."TRANSACT_DATE"),4) || '-' || asciiz(extract(MONTH FROM T1."TRANSACT_DATE"),2) || '-' || asciiz(extract(DAY FROM T1."TRANSACT_DATE"),2))) from 6 for 2)) || '.' || (substring(((asciiz(extract(YEAR FROM T1."TRANSACT_DATE"),4) || '-' || asciiz(extract(MONTH FROM T1."TRANSACT_DATE"),2) || '-' || asciiz(extract(DAY FROM T1."TRANSACT_DATE"),2))) from 1 for 4)) as c11,
	   1 as c12
from "dere1143"."dbo"."ACCOUNT_INFO" T1
where ((T1."TYPE_ACCTT" = '1') and (T1."ACCT_NR" LIKE '100%'))

END SQL
COLUMN,0,Acct Nr
COLUMN,1,Transact Date
COLUMN,2,Handler
COLUMN,3,Ledger Accts Name
COLUMN,4,Dept Split
COLUMN,5,Type Acctt
COLUMN,6,Mandant
COLUMN,7,Gestern
COLUMN,8,Kassenbuchung
COLUMN,9,Transact_Date_Text
COLUMN,10,Transaktion Datum
COLUMN,11,Wert1