1 -- @tag: defaults_advance_payment_transfer_charts
2 -- @description: Standardkonten für erhaltene versteuerte Anzahlungen 7% und 19% setzen
3 -- @depends:new_chart_3260_1711 new_chart_3272_1718 defaults_advance_payment_clearing_chart_id
6 ALTER TABLE defaults ADD COLUMN advance_payment_taxable_19_id INTEGER;
7 ALTER TABLE defaults ADD COLUMN advance_payment_taxable_7_id INTEGER;
8 UPDATE chart set link ='AR' where id = (select advance_payment_clearing_chart_id from defaults);
14 IF ( SELECT coa FROM defaults ) = 'Germany-DATEV-SKR03EU' THEN
16 clearing_accno text := '1718';
19 IF ( SELECT COUNT(accno) FROM chart WHERE accno LIKE clearing_accno ) = 1 THEN
20 UPDATE defaults SET advance_payment_taxable_19_id = (SELECT id FROM chart WHERE accno LIKE clearing_accno);
25 IF ( SELECT coa FROM defaults ) = 'Germany-DATEV-SKR04EU' THEN
27 clearing_accno text := '3272';
30 IF ( SELECT COUNT(accno) FROM chart WHERE accno LIKE clearing_accno ) = 1 THEN
31 UPDATE defaults SET advance_payment_taxable_19_id = (SELECT id FROM chart WHERE accno LIKE clearing_accno);
36 IF ( SELECT coa FROM defaults ) = 'Germany-DATEV-SKR03EU' THEN
38 clearing_accno text := '1711';
41 IF ( SELECT COUNT(accno) FROM chart WHERE accno LIKE clearing_accno ) = 1 THEN
42 UPDATE defaults SET advance_payment_taxable_7_id = (SELECT id FROM chart WHERE accno LIKE clearing_accno);
47 IF ( SELECT coa FROM defaults ) = 'Germany-DATEV-SKR04EU' THEN
49 clearing_accno text := '3260';
52 IF ( SELECT COUNT(accno) FROM chart WHERE accno LIKE clearing_accno ) = 1 THEN
53 UPDATE defaults SET advance_payment_taxable_7_id = (SELECT id FROM chart WHERE accno LIKE clearing_accno);