- ( SELECT comma(taxkey_id)
- FROM taxkeys tk
- WHERE tk.chart_id = c.id
- AND c.taxkey_id = tk.taxkey_id
- ORDER BY c.id
- ) AS taxkey_id,
-
- ( SELECT comma(taxdescription)
- FROM tax tx
- WHERE tx.id in (
- SELECT tk.tax_id from taxkeys tk
- WHERE tk.chart_id = (
- SELECT id from chart
- WHERE chart.accno='0027' -- Beispielkonto aus dem SKR03
- )
- )
- ORDER BY c.accno
- ) AS taxdescription,
-
- ( SELECT comma(tk.pos_ustva)
- FROM taxkeys tk
- WHERE tk.chart_id = c.id
- AND c.taxkey_id = tk.taxkey_id
- ORDER BY c.id
- ) AS tk_ustva,
-
- ( SELECT comma(startdate)
- FROM taxkeys tk
- WHERE tk.chart_id = c.id
- AND c.taxkey_id = tk.taxkey_id
- ORDER BY c.id
- ) AS startdate,
-
+ comma(tk.startdate) AS startdate,
+ comma(tk.taxkey_id) AS taxkey,
+ comma(tx.taxdescription || to_char (tx.rate, '99V99' ) || '%') AS taxdescription,
+ comma(tx.taxnumber) AS taxaccount,
+ comma(tk.pos_ustva) AS tk_ustva,