Inicio Explorar Ayuda
Registro Iniciar sesión
Valavuo
/
inventory
2
0
Fork 0
Archivos Incidencias 0 Pull Requests 0 Wiki
Árbol: 2932879887
Ramas Etiquetas
inventory
/
backend
/
database
/
finnish_chart_simple.sql

finnish_chart_simple.sql 9.8 KB
Histórico Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960 
  1. -- Finnish Chart of Accounts Structure
    2. 

  2. -- Following Finnish accounting standards and numbering system
    3. 

  3. 

  4. -- Disable foreign key checks temporarily
    5. 

  5. SET FOREIGN_KEY_CHECKS = 0;
    6. 

  6. 

  7. -- Clear existing data
    8. 

  8. TRUNCATE TABLE chart_of_accounts;
    9. 

  9. 

  10. -- Re-enable foreign key checks
    11. 

  11. SET FOREIGN_KEY_CHECKS = 1;
    12. 

  12. 

  13. -- ASSETS (VASTA-OMAISUUS) - 1000-1999
    14. 

  14. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('1000', 'Käyttöpääoma', 'asset', 'Pääomaisuus', 0.00, 0.00, 0.00, 1);
    15. 

  15. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('1100', 'Saamiset ja vaatimukset', 'asset', 'Tase-erät ja poistot', 0.00, 0.00, 0.00, 1);
    16. 

  16. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('1200', 'Aineelliset vaihto-omaisuudet', 'asset', 'Varasto ja raaka-aineet', 0.00, 0.00, 24.00, 1);
    17. 

  17. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('1300', 'Pitkän aikaiset sijoitukset', 'asset', 'Pitkän aikaiset sijoitukset', 0.00, 0.00, 0.00, 1);
    18. 

  18. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('1400', 'Kiinteistöt', 'asset', 'Kiinteistöt ja rakennukset', 0.00, 0.00, 0.00, 1);
    19. 

  19. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('1500', 'Koneet ja kalusto', 'asset', 'Koneet, kalusto ja laitteet', 0.00, 0.00, 24.00, 1);
    20. 

  20. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('1600', 'Aineettomat varat', 'asset', 'Aineettomat varat', 0.00, 0.00, 0.00, 1);
    21. 

  21. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('1700', 'Sijoitukset rahoituslaitoksissa', 'asset', 'Rahoituslaitokset', 0.00, 0.00, 0.00, 1);
    22. 

  22. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('1800', 'Erityiset vaihto-omaisuudet', 'asset', 'Erityiset vaihto-omaisuudet', 0.00, 0.00, 0.00, 1);
    23. 

  23. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('1900', 'Vaihto-omaisuudet luovutukseen', 'asset', 'Myyntikohteiset varat', 0.00, 0.00, 0.00, 1);
    24. 

  24. 

  25. -- LIABILITIES (VELAT) - 2000-2999
    26. 

  26. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('2000', 'Oma pääoma', 'liability', 'Oma pääoma', 0.00, 0.00, 0.00, 1);
    27. 

  27. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('2100', 'Pitkän aikaiset velat', 'liability', 'Pitkän aikaiset velat', 0.00, 0.00, 0.00, 1);
    28. 

  28. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('2200', 'Verovelat', 'liability', 'Verovelat ja vakuudet', 0.00, 0.00, 0.00, 1);
    29. 

  29. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('2300', 'Ostovelat ja saamiset', 'liability', 'Ostovelat ja saamiset', 0.00, 0.00, 0.00, 1);
    30. 

  30. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('2400', 'Maksuvelat ja ennakot', 'liability', 'Maksuvelat ja saadut ennakot', 0.00, 0.00, 0.00, 1);
    31. 

  31. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('2500', 'Verovelat konserneille', 'liability', 'Verovelat konserneille', 0.00, 0.00, 0.00, 1);
    32. 

  32. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('2600', 'Muut velat', 'liability', 'Muut velat', 0.00, 0.00, 0.00, 1);
    33. 

  33. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('2700', 'Siirrot konserninointiin', 'liability', 'Siirrot konserninointiin', 0.00, 0.00, 0.00, 1);
    34. 

  34. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('2800', 'Tilikaudin tuloverot', 'liability', 'Tilikaudin tuloverot', 0.00, 0.00, 0.00, 1);
    35. 

  35. 

  36. -- EQUITY (OMA PÄÄOMA) - 3000-3999
    37. 

  37. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('3000', 'Osakepääoma', 'equity', 'Osakepääoma', 0.00, 0.00, 0.00, 1);
    38. 

  38. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('3100', 'Sijoitetun pääoman rahastot', 'equity', 'Sijoitetun pääoman rahastot', 0.00, 0.00, 0.00, 1);
    39. 

  39. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('3200', 'Muut pääomat rahastot', 'equity', 'Muut pääomat rahastot', 0.00, 0.00, 0.00, 1);
    40. 

  40. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('3300', 'Tilikauden voitto', 'equity', 'Tilikauden voitto/tappio', 0.00, 0.00, 0.00, 1);
    41. 

  41. 

  42. -- REVENUE (TUOTOT) - 4000-4999
    43. 

  43. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('4000', 'Myyntituotot', 'revenue', 'Myyntituotot', 0.00, 0.00, 24.00, 1);
    44. 

  44. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('4100', 'Palvelutuotot', 'revenue', 'Palvelutuotot', 0.00, 0.00, 24.00, 1);
    45. 

  45. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('4200', 'Vuokratuotot', 'revenue', 'Vuokratuotot', 0.00, 0.00, 24.00, 1);
    46. 

  46. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('4300', 'Korko- ja valuuttatuotot', 'revenue', 'Korko- ja valuuttatuotot', 0.00, 0.00, 0.00, 1);
    47. 

  47. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('4400', 'Muu tuotto', 'revenue', 'Muu tuotto', 0.00, 0.00, 0.00, 1);
    48. 

  48. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('4500', 'Siirrot konserninointiin', 'revenue', 'Siirrot konserninointiin', 0.00, 0.00, 0.00, 1);
    49. 

  49. 

  50. -- EXPENSES (KULUT) - 5000-5999
    51. 

  51. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('5000', 'Aineelliset kulut', 'expense', 'Aineelliset kulut ja palvelut', 0.00, 0.00, 24.00, 1);
    52. 

  52. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('5100', 'Henkilöstökulut', 'expense', 'Henkilöstökulut', 0.00, 0.00, 0.00, 1);
    53. 

  53. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('5200', 'Poistot ja alennukset', 'expense', 'Poistot ja alennukset', 0.00, 0.00, 0.00, 1);
    54. 

  54. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('5300', 'Vuokrat ja vuokrakulut', 'expense', 'Vuokrat ja vuokrakulut', 0.00, 0.00, 0.00, 1);
    55. 

  55. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('5400', 'Korko- ja rahoituskulut', 'expense', 'Korko- ja rahoituskulut', 0.00, 0.00, 0.00, 1);
    56. 

  56. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('5500', 'Tase-erät ja poistot', 'expense', 'Tase-erät ja poistot', 0.00, 0.00, 0.00, 1);
    57. 

  57. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('5600', 'Arvonmäärityksen alennukset', 'expense', 'Arvonmäärityksen alennukset', 0.00, 0.00, 0.00, 1);
    58. 

  58. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('5700', 'Verotukset ja maksut', 'expense', 'Verotukset ja maksut', 0.00, 0.00, 0.00, 1);
    59. 

  59. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('5800', 'Muut kulut', 'expense', 'Muut kulut', 0.00, 0.00, 0.00, 1);
    60. 

  60. INSERT INTO chart_of_accounts (account_number, account_name, account_type, description, opening_balance, current_balance, vat_percentage, is_active) VALUES ('5900', 'Siirrot konserninointiin', 'expense', 'Siirrot konserninointiin', 0.00, 0.00, 0.00, 1);
    61.