Kunden_OP.iqd 482 B

12345678910111213141516171819202122
  1. COGNOS QUERY
  2. STRUCTURE,1,1
  3. DATABASE,werwiso
  4. DATASOURCENAME,C:\GlobalCube\System\WERWISO\IQD\op\Kunden_OP.imr
  5. TITLE,Kunden_OP.imr
  6. BEGIN SQL
  7. select T1."Filial_ID" as c1,
  8. T1."Kundennummer" as c2,
  9. T1."Vorname" as c3,
  10. T1."Name1" as c4,
  11. T1."Name2" as c5,
  12. T1."Anrede" as c6
  13. from "\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."Kuadress" T1
  14. END SQL
  15. COLUMN,0,Filial Id
  16. COLUMN,1,Kundennummer
  17. COLUMN,2,Vorname
  18. COLUMN,3,Name1
  19. COLUMN,4,Name2
  20. COLUMN,5,Anrede