Revision e5f64922
Von Werner Hahn vor etwa 2 Jahren hinzugefügt
- ID e5f649224637d8559dbf29f33a7371daf2d84443
- Vorgänger 5be34ccd
| sql/Pg-upgrade2/chart_add_columns_lohnbuchhaltung.sql | ||
|---|---|---|
| 1 |
-- @tag: chart_add_columns_lohnbuchhaltung_skr03 |
|
| 2 |
-- @description: Tabelle chart um Lohnbuchungskonten erweitern |
|
| 3 |
-- @depends: release_3_7_0 |
|
| 4 |
-- @ignore: 1 |
|
| 5 |
|
|
| 6 |
DO $$ |
|
| 7 |
BEGIN |
|
| 8 |
IF ( SELECT coa FROM defaults ) = 'Germany-DATEV-SKR03EU' THEN |
|
| 9 |
BEGIN |
|
| 10 |
IF ( SELECT COUNT(accno) FROM chart WHERE accno LIKE 1759 ) = 0 THEN |
|
| 11 |
INSERT INTO chart |
|
| 12 |
(accno , description , charttype , category , link , taxkey_id , pos_ustva , pos_bwa , pos_bilanz , pos_eur , datevautomatik) VALUES |
|
| 13 |
('1759' , 'Voraussichtliche Beitragsschuld gegenüber den Sozialversicherungsträgern' , 'A' , 'L' , 'AP' , 0 , NULL , NULL , NULL , 9 , FALSE);
|
|
| 14 |
END IF; |
|
| 15 |
IF ( SELECT COUNT(accno) FROM chart WHERE accno LIKE 4190 ) = 0 THEN |
|
| 16 |
INSERT INTO chart |
|
| 17 |
(accno , description , charttype , category , link , taxkey_id , pos_ustva , pos_bwa , pos_bilanz , pos_eur , datevautomatik) VALUES |
|
| 18 |
('4190' , 'Aushilfslöhne' , 'A' , 'E' , NULL , 0 , 10 , NULL , NULL , 9 , FALSE);
|
|
| 19 |
END IF; |
|
| 20 |
IF ( SELECT COUNT(accno) FROM chart WHERE accno LIKE 1742 ) = 0 THEN |
|
| 21 |
INSERT INTO chart |
|
| 22 |
(accno , description , charttype , category , link , taxkey_id , pos_ustva , pos_bwa , pos_bilanz , pos_eur , datevautomatik) VALUES |
|
| 23 |
('1742' , 'Verbindlichkeiten im Rahmen der sozialen Sicherheit ' , 'A' , 'L' , 'AP' , 0 , NULL , NULL , NULL , 9 , FALSE);
|
|
| 24 |
END IF; |
|
| 25 |
IF ( SELECT COUNT(accno) FROM chart WHERE accno LIKE 1741 ) = 0 THEN |
|
| 26 |
INSERT INTO chart |
|
| 27 |
(accno , description , charttype , category , link , taxkey_id , pos_ustva , pos_bwa , pos_bilanz , pos_eur , datevautomatik) VALUES |
|
| 28 |
('1741' , 'Verbindlichkeiten aus Lohn- und Kirchensteuer' , 'A' , 'L' , 'AP' , 0 , NULL , NULL , NULL , 9 , FALSE);
|
|
| 29 |
END IF; |
|
| 30 |
IF ( SELECT COUNT(accno) FROM chart WHERE accno LIKE 1755 ) = 0 THEN |
|
| 31 |
INSERT INTO chart |
|
| 32 |
(accno , description , charttype , category , link , taxkey_id , pos_ustva , pos_bwa , pos_bilanz , pos_eur , datevautomatik) VALUES |
|
| 33 |
('1755' , 'Lohn- und Gehaltsverrechnung ' , 'A' , 'L' , 'AP' , 0 , NULL , NULL , NULL , 9 , FALSE);
|
|
| 34 |
END IF; |
|
| 35 |
IF ( SELECT COUNT(accno) FROM chart WHERE accno LIKE 1520 ) = 0 THEN |
|
| 36 |
INSERT INTO chart |
|
| 37 |
(accno , description , charttype , category , link , taxkey_id , pos_ustva , pos_bwa , pos_bilanz , pos_eur , datevautomatik) VALUES |
|
| 38 |
('1520' , 'Forderungen gegenüber Krankenkassen aus Aufwendungsausgleichsgesetz' , 'A' , 'A' , NULL , 0 , NULL , NULL , NULL , NULL , FALSE);
|
|
| 39 |
END IF; |
|
| 40 |
END; |
|
| 41 |
END IF; |
|
| 42 |
|
|
| 43 |
IF ( SELECT coa FROM defaults ) = 'Germany-DATEV-SKR04EU' THEN |
|
| 44 |
BEGIN |
|
| 45 |
IF ( SELECT COUNT(accno) FROM chart WHERE accno LIKE 3759 ) = 0 THEN |
|
| 46 |
INSERT INTO chart |
|
| 47 |
(accno , description , charttype , category , link , taxkey_id , pos_ustva , pos_bwa , pos_bilanz , pos_eur , datevautomatik) VALUES |
|
| 48 |
('3759' , 'Voraussichtliche Beitragsschuld gegenüber den Sozialversicherungsträgern' , 'A' , 'L' , 'AP' , 0 , NULL , NULL , NULL , 9 , FALSE);
|
|
| 49 |
END IF; |
|
| 50 |
IF ( SELECT COUNT(accno) FROM chart WHERE accno LIKE 6030 ) = 0 THEN |
|
| 51 |
INSERT INTO chart |
|
| 52 |
(accno , description , charttype , category , link , taxkey_id , pos_ustva , pos_bwa , pos_bilanz , pos_eur , datevautomatik) VALUES |
|
| 53 |
('6030' , 'Aushilfslöhne' , 'A' , 'E' , NULL , 0 , 10 , NULL , NULL , 9 , FALSE);
|
|
| 54 |
END IF; |
|
| 55 |
IF ( SELECT COUNT(accno) FROM chart WHERE accno LIKE 3740 ) = 0 THEN |
|
| 56 |
INSERT INTO chart |
|
| 57 |
(accno , description , charttype , category , link , taxkey_id , pos_ustva , pos_bwa , pos_bilanz , pos_eur , datevautomatik) VALUES |
|
| 58 |
('3740' , 'Verbindlichkeiten im Rahmen der sozialen Sicherheit ' , 'A' , 'L' , 'AP' , 0 , NULL , NULL , NULL , 9 , FALSE);
|
|
| 59 |
END IF; |
|
| 60 |
IF ( SELECT COUNT(accno) FROM chart WHERE accno LIKE 3730 ) = 0 THEN |
|
| 61 |
INSERT INTO chart |
|
| 62 |
(accno , description , charttype , category , link , taxkey_id , pos_ustva , pos_bwa , pos_bilanz , pos_eur , datevautomatik) VALUES |
|
| 63 |
('3730' , 'Verbindlichkeiten aus Lohn- und Kirchensteuer' , 'A' , 'L' , 'AP' , 0 , NULL , NULL , NULL , 9 , FALSE);
|
|
| 64 |
END IF; |
|
| 65 |
IF ( SELECT COUNT(accno) FROM chart WHERE accno LIKE 3790 ) = 0 THEN |
|
| 66 |
INSERT INTO chart |
|
| 67 |
(accno , description , charttype , category , link , taxkey_id , pos_ustva , pos_bwa , pos_bilanz , pos_eur , datevautomatik) VALUES |
|
| 68 |
('3790' , 'Lohn- und Gehaltsverrechnung ' , 'A' , 'L' , 'AP' , 0 , NULL , NULL , NULL , 9 , FALSE);
|
|
| 69 |
END IF; |
|
| 70 |
IF ( SELECT COUNT(accno) FROM chart WHERE accno LIKE 1369 ) = 0 THEN |
|
| 71 |
INSERT INTO chart |
|
| 72 |
(accno , description , charttype , category , link , taxkey_id , pos_ustva , pos_bwa , pos_bilanz , pos_eur , datevautomatik) VALUES |
|
| 73 |
('1369' , 'Forderungen gegenüber Krankenkassen aus Aufwendungsausgleichsgesetz' , 'A' , 'A' , NULL , 0 , NULL , NULL , NULL , NULL , FALSE);
|
|
| 74 |
END IF; |
|
| 75 |
END; |
|
| 76 |
END IF; |
|
| 77 |
|
|
| 78 |
END $$ |
|
| 79 |
|
|
Auch abrufbar als: Unified diff
SQL-Update für Lohnbuchungskonten Datev-import