Revision 28ae0322
Von Moritz Bunkus vor etwa 18 Jahren hinzugefügt
| sql/Germany-DATEV-SKR03EU-chart.sql | ||
|---|---|---|
|
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4635', 'Geschenke ?ber 35EUR nicht abzugsf.', 'A', 'E', 'AP_amount', '4635', 0, NULL, 15, NULL, 18, FALSE);
|
||
|
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4655', 'Nicht abzugsf.Betriebsausg.a.Werbe-Repr?sentatisonk.etc.', 'A', 'E', 'AP_amount', '4655', 9, NULL, 15, NULL, 24, FALSE);
|
||
|
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4805', 'Rep.u.Instandhalt.v.and.Anlagen u.Betriebs-u.Gesch?ftsausst.', 'A', 'E', 'AP_amount', '4805', 9, NULL, 18, NULL, 19, FALSE);
|
||
|
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('8190', 'Erl?se,die mit den Durchschnittss?tzen d.?24UStG vers.werd.', 'A', 'I', 'AR_amount', '8190', NULL, NULL, NULL, NULL, 1, FALSE);
|
||
|
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('8195', 'Erl?se als Kleinunternehmer i.S.d.?19(1)UStG', 'A', 'I', 'AR_amount', '8195', NULL, NULL, 1, NULL, 1, FALSE);
|
||
|
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('8190', 'Erl?se,die mit den Durchschnittss?tzen d.?24UStG vers.werd.', 'A', 'I', 'AR_amount', '8190', 0, NULL, NULL, NULL, 1, FALSE);
|
||
|
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('8195', 'Erl?se als Kleinunternehmer i.S.d.?19(1)UStG', 'A', 'I', 'AR_amount', '8195', 0, NULL, 1, NULL, 1, FALSE);
|
||
|
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('8807', 'Erl?se a.Verk.Sachanlagen steuerfrei?4Nr.1aUStG(b.Buchverlust)', 'A', 'E', '', '8807', 0, NULL, NULL, NULL, 1, TRUE);
|
||
|
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('8808', 'Erl?se a.Verk.Sachanlagen steuerfrei?4Nr.1bUStG(b.Buchverlust)', 'A', 'E', '', '8808', 0, NULL, NULL, NULL, 1, TRUE);
|
||
|
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('8809', 'Erl?se aus Verk.Sachanlageverm?gen16% USt (bei Buchverlust)', 'A', 'E', '', '8809', 0, NULL, NULL, NULL, 2, TRUE);
|
||
| ... | ... | |
|
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4180', 'Bedienungsgelder', 'A', 'E', '', '4180', 0, NULL, 10, NULL, 9, FALSE);
|
||
|
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4826', 'Au?erplan.AfA a.immat.Verm?gensgeg.', 'A', 'E', '', '4826', 0, NULL, 17, NULL, 25, FALSE);
|
||
|
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4850', 'Abschr.a.Sachanl.aufgr.steuerl.Sondervorschriften', 'A', 'E', '', '4850', 0, NULL, 17, NULL, 25, FALSE);
|
||
|
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4870', 'Abschreibungen auf Finanzanlagen', 'A', 'E', '', '4870', NULL, NULL, NULL, NULL, NULL, FALSE);
|
||
|
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4870', 'Abschreibungen auf Finanzanlagen', 'A', 'E', '', '4870', 0, NULL, NULL, NULL, NULL, FALSE);
|
||
|
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4875', 'Abschr.a.Wertp.d.Umlaufverm?gens', 'A', 'E', '', '4875', 0, NULL, 17, NULL, NULL, FALSE);
|
||
|
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4880', 'Abschreibungen auf Umlaufverm. o.Wertpapiere (soweit un?bl.H?he', 'A', 'E', '', '4880', 0, NULL, 17, NULL, NULL, FALSE);
|
||
|
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2208', 'Solidarit?tszuschlag', 'A', 'E', '', '2208', 0, NULL, 35, NULL, NULL, FALSE);
|
||
| sql/Pg-upgrade2/invalid_taxkeys_2.sql | ||
|---|---|---|
|
-- @tag: invalid_taxkeys_2
|
||
|
-- @description: Ungültige Steuerschlüssel in den Kontenrahmendefinitionen und daraus resultierende falsche Einträge in anderen Tabellen werden korrigiert.
|
||
|
-- @depends: release_2_4_2
|
||
|
UPDATE chart SET taxkey_id = 0 WHERE taxkey_id ISNULL;
|
||
| sql/Pg-upgrade2/ustva_setup_2007_update_chart_taxkeys_tax.sql | ||
|---|---|---|
|
|
||
|
INSERT INTO chart (
|
||
|
accno, description,
|
||
|
charttype, category, link
|
||
|
charttype, category, link,
|
||
|
taxkey_id
|
||
|
)
|
||
|
SELECT
|
||
|
'1570','Anrechenbare Vorsteuer',
|
||
|
'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax'
|
||
|
'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax',
|
||
|
0
|
||
|
WHERE EXISTS ( -- update only for SKR03
|
||
|
SELECT coa FROM defaults
|
||
|
WHERE defaults.coa='Germany-DATEV-SKR03EU'
|
||
| ... | ... | |
|
|
||
|
INSERT INTO chart (
|
||
|
accno, description,
|
||
|
charttype, category, link
|
||
|
charttype, category, link,
|
||
|
taxkey_id
|
||
|
)
|
||
|
SELECT
|
||
|
'1574','Abziehbare Vorsteuer aus innergem. Erwerb 19 %',
|
||
|
'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax'
|
||
|
'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax',
|
||
|
0
|
||
|
WHERE EXISTS ( -- update only for SKR03
|
||
|
SELECT coa FROM defaults
|
||
|
WHERE defaults.coa='Germany-DATEV-SKR03EU'
|
||
| ... | ... | |
|
|
||
|
INSERT INTO chart (
|
||
|
accno, description,
|
||
|
charttype, category, link
|
||
|
charttype, category, link,
|
||
|
taxkey_id
|
||
|
)
|
||
|
SELECT
|
||
|
'1774','Umsatzsteuer aus innergem. Erwerb 19 %',
|
||
|
'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax'
|
||
|
'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax',
|
||
|
0
|
||
|
WHERE EXISTS ( -- update only for SKR03
|
||
|
SELECT coa FROM defaults
|
||
|
WHERE defaults.coa='Germany-DATEV-SKR03EU'
|
||
Auch abrufbar als: Unified diff
Ungültige und fehlende Einträge Einträge in der Spalte "taxkey_id" in der Kontenrahmendefinition vom SKR03.