Revision 8ce50957
Von Jan Büren vor fast 3 Jahren hinzugefügt
| sql/Pg-upgrade2/defaults_advance_payment_transfer_charts.sql | ||
|---|---|---|
| 1 | 1 |
-- @tag: defaults_advance_payment_transfer_charts |
| 2 | 2 |
-- @description: Standardkonten für erhaltene versteuerte Anzahlungen 7% und 19% setzen |
| 3 |
-- @depends:new_chart_3260_1711 new_chart_3272_1718 |
|
| 3 |
-- @depends:new_chart_3260_1711 new_chart_3272_1718 defaults_advance_payment_clearing_chart_id
|
|
| 4 | 4 |
|
| 5 | 5 |
|
| 6 | 6 |
ALTER TABLE defaults ADD COLUMN advance_payment_taxable_19_id INTEGER; |
| 7 | 7 |
ALTER TABLE defaults ADD COLUMN advance_payment_taxable_7_id INTEGER; |
| 8 |
UPDATE charts set link ='AR' where id = (select advance_payment_clearing_chart_id from defaults); |
|
| 9 |
|
|
| 8 | 10 |
|
| 9 | 11 |
DO $$ |
| 10 | 12 |
BEGIN |
Auch abrufbar als: Unified diff
advance_payment_transfer_charts: Ergänzung Abhängigkeit und chart.link setzen