GAPS/Portal/System/IQD/Belege/Kasse_dere09_Fibu.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,O_21_9
DATASOURCENAME,C:\Gaps\Portal\System\IQD\Belege\Kasse_dere09_Fibu.imr
TITLE,Kasse_dere09_Fibu.imr
BEGIN SQL
select c1 as c1,
	   c2 as c2,
	   c3 as c3,
	   c4 as c4,
	   c5 as c5,
	   c6 as c6,
	   c7 as c7,
	   c8 as c8,
	   c9 as c9,
	   c10 as c10,
	   c11 as c11,
	   c12 as c12,
	   c13 as c13,
	   c14 as c14,
	   XMAX(c14 for c1) as c15,
	   c16 as c16
from 
(select c20 as c1,
	   c32 as c2,
	   c31 as c3,
	   c30 as c4,
	   c29 as c5,
	   c28 as c6,
	   c27 as c7,
	   (@CURRENT_DATE) - INTERVAL '001 00:00:00.000' as c8,
	   c26 as c9,
	   c25 as c10,
	   c24 as c11,
	   c23 as c12,
	   c22 as c13,
	   c21 as c14,
	   -1 as c16,
	   XMAX(c21 for c20) as c17
from 
(select T1."ACCT_NR" as c20,
	   T3."UNIQUE_IDENT" as c21,
	   T3."BOOKKEEP_DATE" as c22,
	   T2."FUNCTION_CODE" as c23,
	   (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 c24,
	   (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 c25,
	   CASE WHEN (T1."TRANSACT_DATE" < ((@CURRENT_DATE) - INTERVAL '001 00:00:00.000')) THEN ('1') ELSE ('0') END as c26,
	   (database()) as c27,
	   T1."TYPE_ACCTT" as c28,
	   T1."DEPT_SPLIT" as c29,
	   T1."LEDGER_ACCTS_NAME" as c30,
	   T1."HANDLER" as c31,
	   T1."TRANSACT_DATE" as c32
from "dere1143"."dbo"."ACCOUNT_INFO" T1,
	"dere1143"."dbo"."ACCT_DOC_KEY" T3,
	"dere1143"."dbo"."ACCT_DOC_DATA" T2
where (T1."ACCT_NR" = T3."ACCT_NO") and (T3."UNIQUE_IDENT" = T2."REFERENCE_IDENT")
and ((((T1."TYPE_ACCTT" = '1') and (T1."ACCT_NR" LIKE '100%')) and (T3."BOOKKEEP_DATE" = ((@CURRENT_DATE) - INTERVAL '001 00:00:00.000'))) and (T2."FUNCTION_CODE" = '1175'))
) D2
) D1
where (c14 = c17)
order by c1 asc

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,Function Code
COLUMN,12,Bookkeep Date
COLUMN,13,Unique Ident
COLUMN,14,Maximum Unique Ident
COLUMN,15,Wert1