summaryrefslogtreecommitdiff
path: root/sql/Swiss-German-gifi.sql
blob: 814030f1ebceb9187c9d9bafc524d108386b7383 (plain)
  1. begin;
  2. --
  3. INSERT INTO gifi (accno,description) VALUES ('1','AKTIVEN');
  4. INSERT INTO gifi (accno,description) VALUES ('2','PASSIVEN');
  5. INSERT INTO gifi (accno,description) VALUES ('4','AUFWAND FÜR MATERIAL, WAREN UND DIENSTLEISTUNGEN');
  6. INSERT INTO gifi (accno,description) VALUES ('5','PERSONALAUFWAND');
  7. INSERT INTO gifi (accno,description) VALUES ('10000','ANLAGEVERMÖGEN');
  8. INSERT INTO gifi (accno,description) VALUES ('11000','Forderungen');
  9. INSERT INTO gifi (accno,description) VALUES ('11100','Bank');
  10. INSERT INTO gifi (accno,description) VALUES ('11110','MWST Vorsteuer auf Investitionen');
  11. INSERT INTO gifi (accno,description) VALUES ('11120','Angefangene Arbeiten');
  12. INSERT INTO gifi (accno,description) VALUES ('14150','Büromaschinen, EDV');
  13. INSERT INTO gifi (accno,description) VALUES ('18000','Gründungsaufwand');
  14. INSERT INTO gifi (accno,description) VALUES ('20000','FREMDKAPITAL LANGFRISTIG');
  15. INSERT INTO gifi (accno,description) VALUES ('21000','Kurzfristige Finanzverbindlichkeiten');
  16. INSERT INTO gifi (accno,description) VALUES ('21200','Sozialversicherungen');
  17. INSERT INTO gifi (accno,description) VALUES ('21210','Gesellschafter');
  18. INSERT INTO gifi (accno,description) VALUES ('21220','MWST (3,6)');
  19. INSERT INTO gifi (accno,description) VALUES ('21230','Passive Rechnungsabgrenzung');
  20. INSERT INTO gifi (accno,description) VALUES ('24000','Gesellschafter');
  21. INSERT INTO gifi (accno,description) VALUES ('28000','Stammkapital');
  22. INSERT INTO gifi (accno,description) VALUES ('28290','Gewinnvortrag');
  23. INSERT INTO gifi (accno,description) VALUES ('30000','ÜBRIGER ERTRAG');
  24. INSERT INTO gifi (accno,description) VALUES ('31000','Computer');
  25. INSERT INTO gifi (accno,description) VALUES ('32000','Software kommerz.');
  26. INSERT INTO gifi (accno,description) VALUES ('34000','Beratung');
  27. INSERT INTO gifi (accno,description) VALUES ('36000','Essen');
  28. INSERT INTO gifi (accno,description) VALUES ('37000','Eigenleistungen');
  29. INSERT INTO gifi (accno,description) VALUES ('38000','Bestandesänderungen');
  30. INSERT INTO gifi (accno,description) VALUES ('39000','Rabatte, Preisnachlässe');
  31. INSERT INTO gifi (accno,description) VALUES ('40000','AUFWANDMINDERUNGEN');
  32. INSERT INTO gifi (accno,description) VALUES ('41000','Übrige Produkte');
  33. INSERT INTO gifi (accno,description) VALUES ('42000','Software kommerz.');
  34. INSERT INTO gifi (accno,description) VALUES ('44000','Aufwand für Drittleistungen');
  35. INSERT INTO gifi (accno,description) VALUES ('47000','Einkaufsspesen');
  36. INSERT INTO gifi (accno,description) VALUES ('48000','Bestandesänderungen');
  37. INSERT INTO gifi (accno,description) VALUES ('49000','Aufwandminderungen');
  38. INSERT INTO gifi (accno,description) VALUES ('50000','Löhne und Gehälter');
  39. INSERT INTO gifi (accno,description) VALUES ('57000','FAK');
  40. INSERT INTO gifi (accno,description) VALUES ('58000','Spesen');
  41. INSERT INTO gifi (accno,description) VALUES ('60000','VERWALTUNGS- UND INFORMATIKAUFWAND');
  42. INSERT INTO gifi (accno,description) VALUES ('61000','Reinigung');
  43. INSERT INTO gifi (accno,description) VALUES ('61900','Unterhalt');
  44. INSERT INTO gifi (accno,description) VALUES ('62000','Fahrzeugaufwand');
  45. INSERT INTO gifi (accno,description) VALUES ('63000','Betriebsversicherungen');
  46. INSERT INTO gifi (accno,description) VALUES ('65000','Übriger Verwaltungsaufwand');
  47. INSERT INTO gifi (accno,description) VALUES ('66000','Werbeaufwand');
  48. INSERT INTO gifi (accno,description) VALUES ('67000','Produkteentwicklung');
  49. INSERT INTO gifi (accno,description) VALUES ('68000','Finanzaufwand');
  50. INSERT INTO gifi (accno,description) VALUES ('69000','Abschreibungen');
  51. INSERT INTO gifi (accno,description) VALUES ('80000','AUSSERORDENTLICHER UND BETRIEBSFREMDER ERFOLG, STEUERN');
  52. INSERT INTO gifi (accno,description) VALUES ('90000','ABSCHLUSS');
  53. INSERT INTO gifi (accno,description) VALUES ('91000','ERFOLGSRECHNUNG');
  54. INSERT INTO gifi (accno,description) VALUES ('92000','BILANZ');
  55. INSERT INTO gifi (accno,description) VALUES ('93000','GEWINNVERWENDUNG');
  56. INSERT INTO gifi (accno,description) VALUES ('99000','SAMMEL- UND FEHLBUCHUNGEN');
  57. commit;