dKundengruppe.iqd 374 B

12345678910111213141516
  1. COGNOS QUERY
  2. STRUCTURE,1,1
  3. DATABASE,ARIntelligence
  4. DATASOURCENAME,C:\GlobalCube\System\ARI\IQD\Sievers-Group\dKundengruppe.imr
  5. TITLE,dKundengruppe.imr
  6. BEGIN SQL
  7. select '001' as c1,
  8. T1."Code" as c2,
  9. T1."Description" as c3
  10. from "Vogl7x"."dbo"."BMW AH Vogl$Customer Group" T1
  11. END SQL
  12. COLUMN,0,Mandant ID
  13. COLUMN,1,Kundengruppennummer
  14. COLUMN,2,Kundengruppenbezeichnung