summaryrefslogtreecommitdiff
path: root/sql/German-Sample-gifi.sql
blob: 73161140b7abed661ea42fa0ec9753c272e95177 (plain)
  1. -- Einfacher Kontoplan für Deutschland
  2. --
  3. INSERT INTO gifi (accno,description) VALUES ('A0', 'Anlagevermögen');
  4. INSERT INTO gifi (accno,description) VALUES ('A1-1', 'Warenbestand');
  5. INSERT INTO gifi (accno,description) VALUES ('A1-2', 'Forderungen');
  6. INSERT INTO gifi (accno,description) VALUES ('A1-3', 'Liquide Mittel');
  7. INSERT INTO gifi (accno,description) VALUES ('A1-4', 'Aktive Rechnungsabgrenzung');
  8. INSERT INTO gifi (accno,description) VALUES ('E', 'Erträge');
  9. INSERT INTO gifi (accno,description) VALUES ('K0', 'Wareneinsatz');
  10. INSERT INTO gifi (accno,description) VALUES ('K1', 'Personalkosten');
  11. INSERT INTO gifi (accno,description) VALUES ('K2', 'Raumkosten');
  12. INSERT INTO gifi (accno,description) VALUES ('K3', 'Sonstige Kosten');
  13. INSERT INTO gifi (accno,description) VALUES ('NA', 'Neutrale Aufwendungen');
  14. INSERT INTO gifi (accno,description) VALUES ('NE', 'Neutrale Erlöse');
  15. INSERT INTO gifi (accno,description) VALUES ('P0', 'Eigenkapital');
  16. INSERT INTO gifi (accno,description) VALUES ('P1', 'Rückstellungen');
  17. INSERT INTO gifi (accno,description) VALUES ('P2', 'Fremdkapital Langfristig');
  18. INSERT INTO gifi (accno,description) VALUES ('P3', 'Fremdkapital Kurzfristig');
  19. INSERT INTO gifi (accno,description) VALUES ('P4', 'Passive Rechnungsabgrenzung');