X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/kivitendo-erp.git/blobdiff_plain/7d0e997b23aad589dc6d052a177bb277122cdf42..b2f45e7ebfee8fd1cf79632baccad61d6814fd8c:/SL/CA.pm 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