Revision dbafd846
Von Udo Spallek vor fast 18 Jahren hinzugefügt
| SL/CA.pm | ||
|---|---|---|
| 71 | 71 |
} |
| 72 | 72 |
$sth->finish; |
| 73 | 73 |
|
| 74 |
$query = qq|
|
|
| 74 |
$query = qq{
|
|
| 75 | 75 |
|
| 76 | 76 |
SELECT c.id, |
| 77 | 77 |
c.accno, |
| ... | ... | |
| 80 | 80 |
c.gifi_accno, |
| 81 | 81 |
c.category, |
| 82 | 82 |
c.link, |
| 83 |
c.pos_ustva, |
|
| 84 | 83 |
c.pos_bwa, |
| 85 | 84 |
c.pos_bilanz, |
| 86 | 85 |
c.pos_eur, |
| 87 | 86 |
c.valid_from, |
| 88 | 87 |
c.datevautomatik, |
| 89 |
-- ( SELECT comma(taxkey_id) |
|
| 90 |
-- FROM taxkeys tk |
|
| 91 |
-- WHERE tk.chart_id = c.id |
|
| 92 |
-- AND c.taxkey_id = tk.taxkey_id |
|
| 93 |
-- ORDER BY c.id |
|
| 94 |
-- ) AS taxkey_id, |
|
| 95 |
|
|
| 96 | 88 |
( SELECT comma(taxkey) |
| 97 | 89 |
FROM tax tx |
| 98 | 90 |
WHERE tx.id in ( |
| ... | ... | |
| 102 | 94 |
ORDER BY c.accno |
| 103 | 95 |
) AS taxkey, |
| 104 | 96 |
|
| 105 |
( SELECT comma(taxdescription) |
|
| 97 |
( SELECT comma(taxdescription || to_char (rate, '99V99' ) || '%')
|
|
| 106 | 98 |
FROM tax tx |
| 107 | 99 |
WHERE tx.id in ( |
| 108 | 100 |
SELECT tk.tax_id from taxkeys tk |
| ... | ... | |
| 123 | 115 |
( SELECT comma(tk.pos_ustva) |
| 124 | 116 |
FROM taxkeys tk |
| 125 | 117 |
WHERE tk.chart_id = c.id |
| 126 |
AND c.taxkey_id = tk.taxkey_id |
|
| 127 | 118 |
ORDER BY c.id |
| 128 | 119 |
) AS tk_ustva, |
| 129 | 120 |
|
| 130 | 121 |
( SELECT comma(startdate) |
| 131 | 122 |
FROM taxkeys tk |
| 132 | 123 |
WHERE tk.chart_id = c.id |
| 133 |
AND c.taxkey_id = tk.taxkey_id |
|
| 134 | 124 |
ORDER BY c.id |
| 135 | 125 |
) AS startdate, |
| 136 | 126 |
|
| ... | ... | |
| 140 | 130 |
) AS new_account |
| 141 | 131 |
FROM chart c |
| 142 | 132 |
ORDER BY accno |
| 143 |
|;
|
|
| 133 |
};
|
|
| 144 | 134 |
|
| 145 | 135 |
$sth = $dbh->prepare($query); |
| 146 | 136 |
$sth->execute || $form->dberror($query); |
Auch abrufbar als: Unified diff
Kontenliste: Steuerschlüssel Prozentsatz fehlte