1 -- @tag: defaults_advance_payment_clearing_chart_id
2 -- @description: Voreingestelltes Konto für Verrechnung von Anzahlungen
3 -- @depends: new_chart_1593_1495
5 ALTER TABLE defaults ADD COLUMN advance_payment_clearing_chart_id INTEGER;
10 IF ( SELECT coa FROM defaults ) = 'Germany-DATEV-SKR03EU' THEN
12 clearing_accno text := '1593';
15 IF ( SELECT COUNT(accno) FROM chart WHERE accno LIKE clearing_accno ) = 1 THEN
16 UPDATE defaults SET advance_payment_clearing_chart_id = (SELECT id FROM chart WHERE accno LIKE clearing_accno);
21 IF ( SELECT coa FROM defaults ) = 'Germany-DATEV-SKR04EU' THEN
23 clearing_accno text := '1495';
26 IF ( SELECT COUNT(accno) FROM chart WHERE accno LIKE clearing_accno ) = 1 THEN
27 UPDATE defaults SET advance_payment_clearing_chart_id = (SELECT id FROM chart WHERE accno LIKE clearing_accno);