C11/System/LOCOSOFT/IQD/OP/OP_aus_LOC_Belege_8520.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,GC_LOCOSOFT
DATASOURCENAME,C:\GlobalCube\System\LOCOSOFT\IQD\op\OP_aus_LOC_Belege_8520.imr
TITLE,OP_aus_LOC_Belege_8520.imr
BEGIN SQL
select distinct T1."document_type" as c1,
	   T1."nominal_account_number" as c2,
	   T1."customer_contra_account" as c3,
	   T1."invoice_number" as c4,
	   T1."skr51_branch" as c5,
	   T1."subsidiary_to_company_ref" as c6,
	   (cast_numberToString(cast_integer(T1."skr51_branch"))) as c7,
	   '1' as c8,
	   T1."subsidiary_to_company_ref" as c9,
	   ((cast_numberToString(cast_integer(T1."skr51_branch")))) as c10
from "journal_accountings" T1
where (((T1."nominal_account_number" IN (8520)) and (T1."document_type" = 'R')) and (T1."invoice_date" >= DATE '2016-01-01'))
order by c4 asc,c2 asc

END SQL
COLUMN,0,Document Type
COLUMN,1,Nominal Account Number
COLUMN,2,Customer Contra Account
COLUMN,3,Invoice Number
COLUMN,4,Skr51 Branch
COLUMN,5,Rechtseinheit
COLUMN,6,Betrieb
COLUMN,7,Mandant
COLUMN,8,Hauptbetrieb
COLUMN,9,Standort