X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FCA.pm;h=1a77102391f3db0662d554fd464c4bf2db4e9633;hb=1a344dd59350e494024e81054bc6c752b08c668c;hp=162a320f6e48764542deca63e1ffc56e2df0b68a;hpb=56041df395cc2d8971f822c54f4e48743cc4f22b;p=kivitendo-erp.git

diff --git a/SL/CA.pm b/SL/CA.pm
index 162a320f6..1a7710239 100644
--- a/SL/CA.pm
+++ b/SL/CA.pm
@@ -86,24 +86,39 @@ sub all_accounts {
       c.pos_eur,
       c.valid_from,
       c.datevautomatik,
-      ( 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(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(taxkey)
+        FROM tax tx
+        WHERE tx.id in (
+          SELECT tk.tax_id from taxkeys tk 
+          WHERE tk.chart_id = c.id
+        ) 
+        ORDER BY c.accno
+      ) AS taxkey,
 
       ( 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
-          )
+          WHERE tk.chart_id = c.id
         ) 
         ORDER BY c.accno
       ) AS taxdescription,
+      
+      ( SELECT comma(taxnumber)
+        FROM tax tx
+        WHERE tx.id in (
+          SELECT tk.tax_id from taxkeys tk 
+          WHERE tk.chart_id = c.id
+        ) 
+        ORDER BY c.accno
+      ) AS taxaccount,
 
       ( SELECT comma(tk.pos_ustva)
         FROM taxkeys tk