X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FCA.pm;h=9eeb905f53dda4fcea4a2e6d96c2a37d91465594;hb=1410996dd10264247f118f1ac6f3a8daaf5e55e6;hp=4604f13e3a6009485a83e0ebcb3984cd4a8ac7d1;hpb=7d0e997b23aad589dc6d052a177bb277122cdf42;p=kivitendo-erp.git diff --git a/SL/CA.pm b/SL/CA.pm index 4604f13e3..9eeb905f5 100644 --- a/SL/CA.pm +++ b/SL/CA.pm @@ -76,11 +76,11 @@ sub all_accounts { c.pos_eur, c.valid_from, c.datevautomatik, - comma(tk.startdate) AS startdate, - comma(tk.taxkey_id) AS taxkey, + comma(tk.startdate::text) AS startdate, + comma(tk.taxkey_id::text) AS taxkey, comma(tx.taxdescription || to_char (tx.rate, '99V99' ) || '%') AS taxdescription, - comma(tx.taxnumber) AS taxaccount, - comma(tk.pos_ustva) AS tk_ustva, + comma(tx.taxnumber::text) AS taxaccount, + comma(tk.pos_ustva::text) AS tk_ustva, ( SELECT accno FROM chart c2 WHERE c2.id = c.id