C11/System/ARI/IQD/Sievers-Group/dKunde.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,ARIntelligence
DATASOURCENAME,C:\GlobalCube\System\ARI\IQD\Sievers-Group\dKunde.imr
TITLE,dKunde.imr
BEGIN SQL
select '001' as c1,
	   T1."No_" as c2,
	   T1."Name" as c3,
	   T1."Search Name" as c4,
	   T1."Address Salutation Code" as c5,
	   T1."First Name" as c6,
	   'Country Region Code' as c7,
	   T1."Post Code" as c8,
	   T1."City" as c9,
	   T1."E-Mail" as c10,
	   T2."Description" as c11,
	   '1' as c12
from ("Vogl7x"."dbo"."BMW AH Vogl$Customer" T1 left outer join "Vogl7x"."dbo"."BMW AH Vogl$Customer Group" T2 on T1."Customer Group Code" = T2."Code")

END SQL
COLUMN,0,Mandant ID
COLUMN,1,Kundennummer
COLUMN,2,Kundenbezeichnung
COLUMN,3,Suchbegriff
COLUMN,4,Anrede
COLUMN,5,Vorname
COLUMN,6,Land
COLUMN,7,PLZ
COLUMN,8,Ort
COLUMN,9,EMail
COLUMN,10,Kundengruppenbezeichnung
COLUMN,11,Standort ID