12345678910111213141516171819202122 |
- COGNOS QUERY
- STRUCTURE,1,1
- DATABASE,werwiso
- DATASOURCENAME,C:\GlobalCube\System\WERWISO\IQD\op\Kunden_OP.imr
- TITLE,Kunden_OP.imr
- BEGIN SQL
- select T1."Filial_ID" as c1,
- T1."Kundennummer" as c2,
- T1."Vorname" as c3,
- T1."Name1" as c4,
- T1."Name2" as c5,
- T1."Anrede" as c6
- from "\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."Kuadress" T1
- END SQL
- COLUMN,0,Filial Id
- COLUMN,1,Kundennummer
- COLUMN,2,Vorname
- COLUMN,3,Name1
- COLUMN,4,Name2
- COLUMN,5,Anrede
|