SELECT cast(kdi.recnum AS INTEGER) AS "zahlcode",
		rtrim(CAST(kdi.frist AS CHAR(3))) + ' Tage Netto'
		+ (CASE SKONTO1P WHEN 0 THEN '' ELSE ' ' + rtrim(CAST(kdi.skonto1t AS CHAR(3))) + ' Tage ' + rtrim(CAST(CAST( kdi.skonto1p AS decimal(2,1)) AS CHAR(3))) + ' %' END)
		+ (CASE SKONTO2P WHEN 0 THEN '' ELSE ' ' + rtrim(CAST(kdi.skonto2t AS CHAR(3))) + ' Tage ' + rtrim(CAST(CAST( kdi.skonto2p AS decimal(2,1)) AS CHAR(3))) + ' %' END) AS "bezeichnung",
         kdi.frist AS "fristmahnung",
         kdi.skonto1t AS "frist1",
         kdi.skonto1p AS "skonto1",
         kdi.skonto2t AS "frist2",
         kdi.skonto2p AS "skonto2",
		CAST(1 AS INTEGER) AS "mandant_nr",
		CAST(kdi.mutdate AS datetime) AS "mutdate"
    FROM kdi