COGNOS QUERY
STRUCTURE,1,1
DATABASE,O21
DATASOURCENAME,C:\GlobalCube\SYSTEM\OPTIMA\IQD\belege\Bilanzbelege_O21_Salden.imr
TITLE,Bilanzbelege_O21_Salden.imr
BEGIN SQL
select T1."ACCT_NO" as c1,
	   T1."DEPARTMENT" as c2,
	   T1."BOOKKEEP_PERIOD" as c3,
	   T1."ORIGIN" as c4,
	   T1."TRANSACT_DATE" as c5,
	   T1."HANDLER" as c6,
	   T1."DEBIT_AMOUNT" as c7,
	   T1."CREDIT_AMOUNT" as c8,
	   T1."DEBIT_QUANTITY" as c9,
	   T1."CREDIT_QUANTITY" as c10,
	   T1."ACCT_NO_NEXT_CHART" as c11,
	   T1."DEPARTMENT_NEXT_CHART" as c12,
	   T1."CONV_FLAG" as c13,
	   T1."UNIQUE_IDENT" as c14,
	   T1."CLIENT_DB" as c15,
	   T2."ACCT_NR" as c16,
	   T2."LEDGER_ACCTS_NAME" as c17,
	   T2."TYPE_ACCTT" as c18,
	   T1."DEBIT_AMOUNT" + T1."CREDIT_AMOUNT" as c19,
	   T3."Hauptbetrieb_ID" as c20,
	   T3."Hauptbetrieb_Name" as c21,
	   T3."Standort_ID" as c22,
	   T3."Standort_Name" as c23,
	   T3."Marke_ID" as c24,
	   T3."Marke_Name" as c25,
	   T3."Marke_Name" as c26,
	   T2."TYPE_ACCTT" as c27,
	   (substring(T1."ACCT_NO" from 1 for 1)) as c28,
	   (db_name()) as c29,
	   (ascii(T1."BOOKKEEP_PERIOD")) || '01' as c30,
	   (cinteger(nconvert(((ascii(T1."BOOKKEEP_PERIOD")) || '01')),0)) as c31,
	   (cdate(((cinteger(nconvert(((ascii(T1."BOOKKEEP_PERIOD")) || '01')),0))))) as c32
from (("OPTIMA"."import"."ACCT_BALANCE" T1 left outer join "OPTIMA"."import"."ACCOUNT_INFO" T2 on (T2."ACCT_NR" = T1."ACCT_NO") and (T2."CLIENT_DB" = T1."CLIENT_DB")) left outer join "OPTIMA"."data"."GC_Department" T3 on ((substring(T1."DEPARTMENT" from 1 for 2)) = T3."Standort") and (T1."CLIENT_DB" = T3."Hauptbetrieb"))
where ((not T1."CLIENT_DB" IN ('11','1')) and (T2."TYPE_ACCTT" = '1'))
order by c1 asc

END SQL
COLUMN,0,Acct No
COLUMN,1,Department
COLUMN,2,Bookkeep Period
COLUMN,3,Origin
COLUMN,4,Transact Date
COLUMN,5,Handler
COLUMN,6,Debit Amount
COLUMN,7,Credit Amount
COLUMN,8,Debit Quantity
COLUMN,9,Credit Quantity
COLUMN,10,Acct No Next Chart
COLUMN,11,Department Next Chart
COLUMN,12,Conv Flag
COLUMN,13,Unique Ident
COLUMN,14,Client Db
COLUMN,15,Acct Nr
COLUMN,16,Ledger Accts Name
COLUMN,17,Type Acctt
COLUMN,18,Betrag_Bilanz
COLUMN,19,Hauptbetrieb Id
COLUMN,20,Hauptbetrieb Name
COLUMN,21,Standort Id
COLUMN,22,Standort Name
COLUMN,23,Marke Id
COLUMN,24,Marke Name
COLUMN,25,Marke
COLUMN,26,GuV_Bilanz
COLUMN,27,Susa
COLUMN,28,Mandant
COLUMN,29,Bookkeep Date_Zeichen
COLUMN,30,Bookkeep Date_Zahl
COLUMN,31,Bookkeep Date