[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb:[2257] branches/1.2/sql/Czech-Republic-chart.sql

Subject: SF.net SVN: ledger-smb:[2257] branches/1.2/sql/Czech-Republic-chart.sql
From: ..hidden..
Date: Wed, 13 Aug 2008 19:28:11 +0000
Revision: 2257
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2257&view=rev
Author:   einhverfr
Date:     2008-08-13 19:28:09 +0000 (Wed, 13 Aug 2008)

Log Message:
-----------
Committing patch 1906081:  Making Czech COA UTF-8-friendly from Dr. Vladimir Botka

Modified Paths:
--------------
    branches/1.2/sql/Czech-Republic-chart.sql

Modified: branches/1.2/sql/Czech-Republic-chart.sql
===================================================================
--- branches/1.2/sql/Czech-Republic-chart.sql	2008-08-12 20:27:27 UTC (rev 2256)
+++ branches/1.2/sql/Czech-Republic-chart.sql	2008-08-13 19:28:09 UTC (rev 2257)
@@ -1,331 +1,336 @@
-begin;
 -- Czech chart of accounts
 -- ..hidden..
---    KompletnÃ ÃÃtovÃ osnova platnÃ v roce 2001
---    Osnova mÃ 2 mÃsta pro tvorbu analytik
 --
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1000', 'DlouhodobÃ nehmotnÃ majetek','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1100', 'ZÃizovacÃ vÃdaje','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1200', 'NehmotnÃ vÃsledky vÃzkumu a vÃvoje','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1300', 'Software','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1400', 'OcenitelnÃ prÃva','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1800', 'DrobnÃ dlouhodobÃ nehmotnÃ majetek','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1900', 'OstatnÃ dlouhodobÃ nehmotnÃ majetek','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2000', 'DlouhodobÃ HmotnÃ majetek odpisovanÃ','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2100', 'Stavby','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2200', 'SamostatnÃ movitÃ vÃci a soubory movitÃch vÃcÃ','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2500', 'PÃstitelskÃ celky trvalÃch porostÃ','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2600', 'ZÃkladnÃ stÃdo a taÂnÃ zvÃÃata','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2800', 'DrobnÃ dlouhodobÃ hmotnÃ majetek','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2900', 'OstatnÃ dlouhodobÃ hmotnÃ majetek','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3000', 'DlouhodobÃ hmotnÃ majetek neodpisovanÃ','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3100', 'Pozemky','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3200', 'UmÃleckÃ dÃla a sbÃrky','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4000', 'PoÃÃzenÃ dlouhodobÃho nehmotnÃho a hmotnÃho majetku','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4100', 'PoÃÃzenÃ dlouhodobÃho nehmotnÃho majetku','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4200', 'PoÃÃzenÃ dlouhodobÃho hmotnÃho majetku','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5000', 'PoskytnutÃ zÃlohy na dlouhodobÃ nehmotnÃ a hmotnÃ majetek','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5100', 'PoskytnutÃ zÃlohy na dlouhodobÃ nehmotnÃ majetek','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5200', 'PoskytnutÃ zÃlohy na dlouhodobÃ hmotnÃ majetek','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6000', 'DlouhodobÃ finanÃnÃ majetek','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6100', 'PodÃlovÃ cennÃ papÃry a vklady v podnicÃch s rozhodujÃcÃm','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6200', 'PodÃlovÃ cennÃ papÃry a vklady v podnicÃch s podstatnÃm','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6300', 'OstatnÃ dlouhodobÃ cennÃ papÃry a vklady','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6600', 'PÃjÃky podnikÃm ve skupinÃ','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6700', 'OstatnÃ pÃjÃky','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6900', 'OstatnÃ dlouhodobÃ finanÃnÃ majetek','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7000', 'OprÃvky k dlouhodobÃmu nehmotnÃmu majetku','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7100', 'OprÃvky ke zÃizovacÃm vÃdajÃm','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7200', 'OprÃvky k nehmotnÃm vÃsledkÃm vÃzkumu a vÃvoje','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7300', 'OprÃvky k softwaru','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7400', 'OprÃvky k ocenitelnÃm prÃvÃm','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7800', 'OprÃvky k drobnÃmu dlouhodobÃmu nehmotnÃmu majetku','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7900', 'OprÃvky k ostatnÃmu dlouhodobÃmu nehmotnÃmu majetku','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8000', 'OprÃvky k dlouhodobÃmu hmotnÃmu majetku','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8100', 'OprÃvky ke stavbÃm','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8200', 'OprÃvky k samostatnÃm movitÃm vÃcem a souborÃm movitÃch vÃcÃ','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8500', 'OprÃvky k pÃstitelskÃm celkÃm trvalÃch porostÃ','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8600', 'OprÃvky k zÃkladnÃmu stÃdu a taÂnÃm zvÃÃatÃm','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8800', 'OprÃvky k drobnÃmu dlouhodobÃmu hmotnÃmu majetku','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8900', 'OprÃvky k ostatnÃmu dlouhodobÃmu hmotnÃmu majetku','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9000', 'OpravnÃ poloÂky k dlouhodobÃmu majetku','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9100', 'OpravnÃ poloÂka k dlouhodobÃmu nehmotnÃmu majetku','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9200', 'OpravnÃ poloÂka k dlouhodobÃmu hmotnÃmu majetku','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9300', 'OpravnÃ poloÂka k dlouhodobÃmu nedokonÃenÃmu nehmotnÃmu','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9400', 'OpravnÃ poloÂka k dlouhodobÃmu nedokonÃenÃmu hmotnÃmu','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9500', 'OpravnÃ poloÂka k poskytnutÃm zÃlohÃm','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9600', 'OpravnÃ poloÂka k dlouhodobÃmu finanÃnÃmu majetku','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9700', 'OpravnÃ poloÂka k nabytÃmu majetku','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9800', 'OprÃvky k opravnÃ poloÂce k nabytÃmu majetku','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('10000', 'ZÃsoby','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('11000', 'MateriÃl','H','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('11100', 'PoÃÃzenÃ materiÃlu','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('11200', 'MateriÃl na skladÃ','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('11900', 'MateriÃl na cestÃ','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12000', 'ZÃsoby vlastnÃ vÃroby','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12100', 'NedokonÃenÃ vÃroba','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12200', 'Polotovary vlastnÃ vÃroby','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12300', 'VÃrobky','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12400', 'ZvÃÃata','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('13000', 'ZboÂÃ','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('13100', 'PoÃÃzenÃ zboÂÃ','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('13200', 'ZboÂÃ na skladÃ a v prodejnÃch','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('13900', 'ZboÂÃ na cestÃ','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19000', 'OpravnÃ poloÂky k zÃsobÃm','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19100', 'OpravnÃ poloÂka k materiÃlu','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19200', 'OpravnÃ poloÂka k nedokonÃenÃ vÃrobÃ','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19300', 'OpravnÃ poloÂka k polotovarÃm vlastnÃ vÃroby','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19400', 'OpravnÃ poloÂka k vÃrobkÃm','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19500', 'OpravnÃ poloÂka ke zvÃÃatÃm','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19600', 'OpravnÃ poloÂka ke zboÂÃ','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('20000', 'FinanÃnÃ ÃÃty','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('21000', 'PenÃze','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('21100', 'Pokladna','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('21300', 'Ceniny','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('22000', 'ÃÃty v bankÃch','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('22100', 'BankovnÃ ÃÃty','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('22200', 'BankovnÃ ÃÃty klientÃ','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('23000', 'BÃÂnÃ bankovnÃ ÃvÃry','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('23100', 'KrÃtkodobÃ bankovnÃ ÃvÃry','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('23200', 'EskontnÃ ÃvÃry','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('24000', 'JinÃ krÃtkodobÃ finanÃnÃ vÃpomoci','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('24100', 'EmitovanÃ krÃtkodobÃ dluhopisy','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('24900', 'OstatnÃ krÃtkodobÃ finanÃnÃ vÃpomoci','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('25000', 'KrÃtkodobÃ finanÃnÃ majetek','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('25100', 'MajetkovÃ cennÃ papÃry','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('25200', 'VlastnÃ akcie a vlastnÃ obchodnÃ podÃly','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('25300', 'DluÂnÃ cennÃ papÃry','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('25500', 'VlastnÃ dluhopisy','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('25600', 'OstatnÃ cennÃ papÃry','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('26000', 'PÃevody mezi finanÃnÃmi ÃÃty','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('26100', 'PenÃze na cestÃ','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('29000', 'OpravnÃ poloÂky ke krÃtkodobÃmu finanÃnÃmu majetku','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('29100', 'OpravnÃ poloÂka k majetkovÃm cennÃm papÃrÃm','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('29300', 'OpravnÃ poloÂka k dluÂnÃm cennÃm papÃrÃm','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('30000', 'ZÃÃtovacÃ vztahy','H','','H','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('31000', 'PohledÃvky','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('31100', 'OdbÃratelÃ','A','','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('31200', 'SmÃnky k inkasu','A','','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('31300', 'PohledÃvky za eskontovanÃ cennÃ papÃry','A','','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('31400', 'PoskytnutÃ provoznÃ zÃlohy','A','','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('31500', 'OstatnÃ pohledÃvky','A','','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('32000', 'ZÃvazky','H','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('32100', 'DodavatelÃ','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('32200', 'SmÃnky k ÃhradÃ','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('32400', 'PÃijatÃ zÃlohy','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('32500', 'OstatnÃ zÃvazky','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('32600', ' ZÃvazky vÃÃi klientÃm','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('32700', ' ZÃvazky vÃÃi trhÃm','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('33000', 'ZÃÃtovÃnÃ se zamÃstnanci a institucemi','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('33100', 'ZamÃstnanci','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('33300', 'OstatnÃ zÃvazky vÃÃi zamÃstnancÃm','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('33500', 'PohledÃvky za zamÃstnanci','A','','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('33600', 'ZÃÃtovÃnÃ s institucemi sociÃlnÃho zabezpeÃenÃ a zdravotnÃho','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34000', 'ZÃÃtovÃnÃ danÃ a dotacÃ','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34100', 'DaÃ z pÃÃjmÃ','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34200', 'OstatnÃ pÃÃmÃ danÃ','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34300', 'DaÃ z pÃidanÃ hodnoty - zÃÃtovÃnÃ','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34311', 'DPH 5% vstup','A','','L','AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34312', 'DPH 22% vstup','A','','L','AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34321', 'DPH 5% vÃstup','A','','L','AR_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34322', 'DPH 22% vÃstup','A','','L','AR_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34500', 'OstatnÃ danÃ a poplatky','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34600', 'Dotace ze stÃtnÃho rozpoÃtu','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34700', 'OstatnÃ dotace','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('35000', 'PohledÃvky ke spoleÃnÃkÃm a sdruÂenÃ','H','','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('35100', 'PohledÃvky k podnikÃm ve skupinÃ','A','','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('35300', 'PohledÃvky za upsanÃ vlastnÃ kapitÃl','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('35400', 'PohledÃvky za spoleÃnÃky pÃi ÃhradÃ ztrÃty','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('35500', 'OstatnÃ pohledÃvky za spoleÃnÃky','A','','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('35800', 'PohledÃvky k ÃÃastnÃkÃm sdruÂenÃ','A','','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36000', 'ZÃvazky ke spoleÃnÃkÃm a sdruÂenÃ','H','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36100', 'ZÃvazky k podnikÃm ve skupinÃ','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36400', 'ZÃvazky ke spoleÃnÃkÃm pÃi rozdÃlovÃnÃ zisku','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36500', 'OstatnÃ zÃvazky ke spoleÃnÃkÃm','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36600', 'ZÃvazky ke spoleÃnÃkÃm a ÃlenÃm druÂstva ze zÃvislÃ','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36700', 'ZÃvazky z upsanÃch nesplacenÃch cennÃch papÃrÃ a vkladÃ','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36800', 'ZÃvazky k ÃÃastnÃkÃm sdruÂenÃ','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37000', 'JinÃ pohledÃvky a zÃvazky','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37100', 'OdloÂenÃ daÃovÃ pohledÃvka a zÃvazek','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37300', 'NakoupenÃ opce','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37400', 'ProdanÃ opce','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37500', 'PohledÃvky z emitovanÃch dluhopisÃ','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37700', ' ZÃÃtovÃnÃ obchodÃ','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37800', 'JinÃ pohledÃvky','A','','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37900', 'JinÃ zÃvazky','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38000', 'PÃechodnÃ ÃÃty aktiv a pasÃv','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38100', 'NÃklady pÃÃÂtÃch obdobÃ','A','','A','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38200', 'KomplexnÃ nÃklady pÃÃÂtÃch obdobÃ','A','','A','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38300', 'VÃdaje pÃÃÂtÃch obdobÃ','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38400', 'VÃnosy pÃÃÂtÃch obdobÃ','A','','L','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38500', 'PÃÃjmy pÃÃÂtÃch obdobÃ','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38600', 'KursovÃ rozdÃly aktivnÃ','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38700', 'KursovÃ rozdÃly pasÃvnÃ','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38800', 'DohadnÃ ÃÃty aktivnÃ','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38900', 'DohadnÃ ÃÃty pasÃvnÃ','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('39000', 'OpravnÃ poloÂka k zÃÃtovacÃm vztahÃm a vnitÃnÃ zÃÃtovÃnÃ','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('39100', 'OpravnÃ poloÂka k pohledÃvkÃm','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('39500', 'VnitÃnÃ zÃÃtovÃnÃ','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('39800', 'SpojovacÃ ÃÃet pÃi sdruÂenÃ','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('40000', 'KapitÃlovÃ ÃÃty a dlouhodobÃ zÃvazky','H','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('41000', 'ZÃkladnÃ kapitÃl a kapitÃlovÃ fondy','H','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('41100', 'ZÃkladnÃ kapitÃl','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('41200', 'EmisnÃ ÃÂio','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('41300', 'OstatnÃ kapitÃlovÃ fondy','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('41400', 'OceÃovacÃ rozdÃly z pÃecenÃnÃ majetku a zÃvazkÃ','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42000', 'Fondy ze zisku a pÃevedenÃ hospodÃÃskÃ vÃsledky','H','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42100', 'ZÃkonnÃ rezervnÃ fond','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42200', 'NedÃlitelnÃ fond','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42300', 'StatutÃrnÃ fondy','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42700', 'OstatnÃ fondy','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42800', 'NerozdÃlenÃ zisk minulÃch let','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42900', 'NeuhrazenÃ ztrÃta minulÃch let','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('43000', 'HospodÃÃskÃ vÃsledek','H','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('43100', 'HospodÃÃskÃ vÃsledek ve schvalovacÃm ÃÃzenÃ','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('45000', 'Rezervy','H','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('45100', 'Rezervy zÃkonnÃ','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('45400', 'Rezerva na kursovÃ ztrÃty','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('45900', 'OstatnÃ rezervy','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('46000', 'BankovnÃ ÃvÃry','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('46100', 'BankovnÃ ÃvÃry','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('47000', 'DlouhodobÃ zÃvazky','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('47100', 'DlouhodobÃ zÃvazky k podnikÃm ve skupinÃ','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('47300', 'EmitovanÃ dluhopisy','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('47400', 'ZÃvazky z pronÃjmu','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('47500', 'DlouhodobÃ pÃijatÃ zÃlohy','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('47800', 'DlouhodobÃ smÃnky k ÃhradÃ','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('47900', 'OstatnÃ dlouhodobÃ zÃvazky','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('49000', 'IndividuÃlnÃ podnikatel','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('49100', 'ÃÃet individuÃlnÃho podnikatele','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50000', 'SpotÃebovanÃ nÃkupy','A','','E','AP_amount:IC_COGS');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50100', 'SpotÃeba materiÃlu','A','','E','AP_amount:IC_COGS');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50200', 'SpotÃeba energie','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50300', 'SpotÃeba ostatnÃch neskladovatelnÃch dodÃvek','A','','E','AP_amount:IC_COGS');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50400', 'ProdanÃ zboÂÃ','A','','E','AP_amount:IC_COGS');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('51000', 'SluÂby','A','','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('51100', 'Opravy a udrÂovÃnÃ','A','','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('51200', 'CestovnÃ','A','','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('51300', 'NÃklady na reprezentaci','A','','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('51800', 'OstatnÃ sluÂby','A','','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52000', 'OsobnÃ nÃklady','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52100', 'MzdovÃ nÃklady','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52200', 'PÃÃjmy spoleÃnÃkÃ a ÃlenÃ druÂstva ze zÃvislÃ Ãinnosti','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52300', 'OdmÃny ÃlenÃm orgÃnÃ spoleÃnosti a druÂstva','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52400', 'ZÃkonnÃ sociÃlnÃ pojiÂtÃnÃ','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52500', 'OstatnÃ sociÃlnÃ pojiÂtÃnÃ','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52600', 'SociÃlnÃ nÃklady individuÃlnÃho podnikatele','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52700', 'ZÃkonnÃ sociÃlnÃ nÃklady','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52800', 'OstatnÃ sociÃlnÃ nÃklady','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('53000', 'DanÃ a poplatky','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('53100', 'DaÃ silniÃnÃ','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('53200', 'DaÃ z nemovitostÃ','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('53800', 'OstatnÃ danÃ a poplatky','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54000', 'JinÃ provoznÃ nÃklady','A','','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54100', 'ZÃstatkovÃ cena prodanÃho dlouhodobÃho nehmotnÃho a hmotnÃho','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54200', 'ProdanÃ materiÃl','A','','E','IC_COGS');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54300', 'Dary','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54400', 'SmluvnÃ pokuty a Ãroky z prodlenÃ','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54500', 'OstatnÃ pokuty a penÃle','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54600', 'Odpis pohledÃvky','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54800', 'OstatnÃ provoznÃ nÃklady','A','','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55000', 'Odpisy, rezervy a opravnÃ poloÂky provoznÃch nÃkladÃ','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55100', 'Odpisy dlouhodobÃho nehmotnÃho a hmotnÃho majetku','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55200', 'Tvorba zÃkonnÃch rezerv','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55400', 'Tvorba ostatnÃch rezerv','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55500', 'ZÃÃtovÃnÃ komplexnÃch nÃkladÃ pÃÃÂtÃch obdobÃ','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55700', 'ZÃÃtovÃnÃ oprÃvky k opravnÃ poloÂce k nabytÃmu majetku','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55800', 'Tvorba zÃkonnÃch opravnÃch poloÂek','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55900', 'Tvorba opravnÃch poloÂek','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56000', 'FinanÃnÃ nÃklady','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56100', 'ProdanÃ cennÃ papÃry a vklady','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56200', 'Ãroky','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56300', 'KursovÃ ztrÃty','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56800', 'OstatnÃ finanÃnÃ nÃklady','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('57000', 'Rezervy a opravnÃ poloÂky finanÃnÃch nÃkladÃ','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('57400', 'Tvorba rezerv','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('57900', 'Tvorba opravnÃch poloÂek','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58000', 'MimoÃÃdnÃ nÃklady','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58100', 'NÃklady na zmÃnu metody','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58200', 'Manka a Âkody','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58400', 'Tvorba rezerv','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58800', 'OstatnÃ mimoÃÃdnÃ nÃklady','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58900', 'Tvorba opravnÃch poloÂek','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59000', 'DanÃ z pÃÃjmÃ a pÃevodovÃ ÃÃty','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59100', 'DaÃ z pÃÃjmÃ z bÃÂnÃ Ãinnosti - splatnÃ','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59200', 'DaÃ z pÃÃjmÃ z bÃÂnÃ Ãinnosti - odloÂenÃ','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59300', 'DaÃ z pÃÃjmÃ z mimoÃÃdnÃ Ãinnosti - splatnÃ','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59400', 'DaÃ z pÃÃjmÃ z mimoÃÃdnÃ Ãinnosti - odloÂenÃ','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59500', 'DodateÃnÃ odvody danÃ z pÃÃjmÃ','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59600', 'PÃevod podÃlu na hospodÃÃskÃm vÃsledku spoleÃnÃkÃm','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59700', 'PÃevod provoznÃch nÃkladÃ','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59800', 'PÃevod finanÃnÃch nÃkladÃ','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('60000', 'TrÂby za vlastnÃ vÃkony a zboÂÃ','A','','I','AR_amount:IC_sale:IC_Income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('60100', 'TrÂby za vlastnÃ vÃrobky','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('60200', 'TrÂby z prodeje sluÂeb','A','','I','AR_amount:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('60400', 'TrÂby za zboÂÃ','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('61000', 'ZmÃny stavu vnitropodnikovÃch zÃsob','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('61100', 'ZmÃna stavu nedokonÃenÃ vÃroby','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('61200', 'ZmÃna stavu polotovarÃ','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('61300', 'ZmÃna stavu vÃrobkÃ','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('61400', 'ZmÃna stavu zvÃÃat','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('62000', 'Aktivace','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('62100', 'Aktivace materiÃlu a zboÂÃ','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('62200', 'Aktivace vnitropodnikovÃch sluÂeb','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('62300', 'Aktivace dlouhodobÃho nehmotnÃho majetku','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('62400', 'Aktivace dlouhodobÃho hmotnÃho majetku','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('64000', 'JinÃ provoznÃ vÃnosy.','A','','I','AR_amount:IC_sale:IC_Income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('64100', 'TrÂby z prodeje dlouhodobÃho nehmotnÃho a hmotnÃho majetku','A','','I','AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('64200', 'TrÂby z prodeje materiÃlu','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('64400', 'SmluvnÃ pokuty a Ãroky z prodlenÃ','A','','I','AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('64600', 'VÃnosy z odepsanÃch pohledÃvek','A','','I','AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('64800', 'JinÃ provoznÃ vÃnosy','A','','I','AR_amount:IC_sale:IC_Income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65000', 'ZÃÃtovÃnÃ rezerv a opravnÃch poloÂek provoznÃch vÃnosÃ','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65200', 'ZÃÃtovÃnÃ zÃkonnÃch rezerv','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65400', 'ZÃÃtovÃnÃ ostatnÃch rezerv','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65500', 'ZÃÃtovÃnÃ komplexnÃch nÃkladÃ pÃÃÂtÃch obdobÃ','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65700', 'ZÃÃtovÃnÃ oprÃvky k opravnÃ poloÂce k nabytÃmu majetku','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65800', 'ZÃÃtovÃnÃ zÃkonnÃch opravnÃch poloÂek','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65900', 'ZÃÃtovÃnÃ opravnÃch poloÂek','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('66000', 'FinanÃnÃ vÃnosy','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('66100', 'TrÂby z prodeje cennÃch papÃrÃ a vkladÃ','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('66200', 'Ãroky','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('66300', 'KursovÃ zisky','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('66500', 'VÃnosy z dlouhodobÃho finanÃnÃho majetku','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('66600', 'VÃnosy z krÃtkodobÃho finanÃnÃho majetku','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('66800', 'OstatnÃ finanÃnÃ vÃnosy','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('67000', 'ZÃÃtovÃnÃ rezerv a opravnÃch poloÂek finanÃnÃch vÃnosÃ','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('67400', 'ZÃÃtovÃnÃ rezerv','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('67900', 'ZÃÃtovÃnÃ opravnÃch poloÂek','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('68000', 'MimoÃÃdnÃ vÃnosy','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('68100', 'VÃnosy ze zmÃny metody','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('68400', 'ZÃÃtovÃnÃ rezerv','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('68800', 'OstatnÃ mimoÃÃdnÃ vÃnosy','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('68900', 'ZÃÃtovÃnÃ opravnÃch poloÂek','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('69000', 'PÃevodovÃ ÃÃty','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('69700', 'PÃevod provoznÃch vÃnosÃ','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('69800', 'PÃevod finanÃnÃch vÃnosÃ','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('70000', 'ÃÃty rozvaÂnÃ','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('70100', 'PoÃÃteÃnÃ ÃÃet rozvaÂnÃ','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('70200', 'KoneÃnÃ ÃÃet rozvaÂnÃ','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('71000', 'ÃÃet ziskÃ a ztrÃt','A','','A','');
+-- 3.3.2008
+-- Vladimir Botka ..hidden..
+-- customized for http://www.ledgersmb.org/
+-- encoding UTF-8
 --
+
+INSERT INTO chart VALUES (10001, '1000', 'DlouhodobÃ nehmotnÃ majetek', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10033, '3200', 'UmÄleckÃ dÃla a sbÃrky', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10005, '1200', 'NehmotnÃ vÃsledky vÃzkumu a vÃvoje', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10007, '1300', 'Software', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10009, '1400', 'OcenitelnÃ prÃva', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10011, '1800', 'DrobnÃ dlouhodobÃ nehmotnÃ majetek', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10013, '1900', 'OstatnÃ dlouhodobÃ nehmotnÃ majetek', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10015, '2000', 'DlouhodobÃ HmotnÃ majetek odpisovanÃ', 'H', 'A', '', '', false);
+INSERT INTO chart VALUES (10017, '2100', 'Stavby', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10025, '2800', 'DrobnÃ dlouhodobÃ hmotnÃ majetek', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10027, '2900', 'OstatnÃ dlouhodobÃ hmotnÃ majetek', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10029, '3000', 'DlouhodobÃ hmotnÃ majetek neodpisovanÃ', 'H', 'A', '', '', false);
+INSERT INTO chart VALUES (10031, '3100', 'Pozemky', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10041, '5000', 'PoskytnutÃ zÃlohy na dlouhodobÃ nehmotnÃ a hmotnÃ majetek', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10043, '5100', 'PoskytnutÃ zÃlohy na dlouhodobÃ nehmotnÃ majetek', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10045, '5200', 'PoskytnutÃ zÃlohy na dlouhodobÃ hmotnÃ majetek', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10049, '6100', 'PodÃlovÃ cennÃ papÃry a vklady v podnicÃch s rozhodujÃcÃm', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10051, '6200', 'PodÃlovÃ cennÃ papÃry a vklady v podnicÃch s podstatnÃm', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10053, '6300', 'OstatnÃ dlouhodobÃ cennÃ papÃry a vklady', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10067, '7300', 'OprÃvky k softwaru', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10071, '7800', 'OprÃvky k drobnÃmu dlouhodobÃmu nehmotnÃmu majetku', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10073, '7900', 'OprÃvky k ostatnÃmu dlouhodobÃmu nehmotnÃmu majetku', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10075, '8000', 'OprÃvky k dlouhodobÃmu hmotnÃmu majetku', 'H', 'A', '', '', false);
+INSERT INTO chart VALUES (10077, '8100', 'OprÃvky ke stavbÃm', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10085, '8800', 'OprÃvky k drobnÃmu dlouhodobÃmu hmotnÃmu majetku', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10087, '8900', 'OprÃvky k ostatnÃmu dlouhodobÃmu hmotnÃmu majetku', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10107, '10000', 'ZÃsoby', 'H', 'A', '', '', false);
+INSERT INTO chart VALUES (10109, '11000', 'MateriÃl', 'H', 'A', 'IC', '', false);
+INSERT INTO chart VALUES (10117, '12000', 'ZÃsoby vlastnÃ vÃroby', 'H', 'A', '', '', false);
+INSERT INTO chart VALUES (10121, '12200', 'Polotovary vlastnÃ vÃroby', 'A', 'A', 'IC', '', false);
+INSERT INTO chart VALUES (10123, '12300', 'VÃrobky', 'A', 'A', 'IC', '', false);
+INSERT INTO chart VALUES (10151, '21000', 'PenÃze', 'A', 'A', 'AR_paid:AP_paid', '', false);
+INSERT INTO chart VALUES (10153, '21100', 'Pokladna', 'A', 'A', 'AR_paid:AP_paid', '', false);
+INSERT INTO chart VALUES (10155, '21300', 'Ceniny', 'A', 'A', 'AR_paid:AP_paid', '', false);
+INSERT INTO chart VALUES (10171, '24100', 'EmitovanÃ krÃtkodobÃ dluhopisy', 'A', 'L', '', '', false);
+INSERT INTO chart VALUES (10177, '25100', 'MajetkovÃ cennÃ papÃry', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10179, '25200', 'VlastnÃ akcie a vlastnÃ obchodnÃ podÃly', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10183, '25500', 'VlastnÃ dluhopisy', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10185, '25600', 'OstatnÃ cennÃ papÃry', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10199, '31000', 'PohledÃvky', 'H', 'A', '', '', false);
+INSERT INTO chart VALUES (10205, '31300', 'PohledÃvky za eskontovanÃ cennÃ papÃry', 'A', 'A', 'AR', '', false);
+INSERT INTO chart VALUES (10207, '31400', 'PoskytnutÃ provoznÃ zÃlohy', 'A', 'A', 'AR', '', false);
+INSERT INTO chart VALUES (10209, '31500', 'OstatnÃ pohledÃvky', 'A', 'A', 'AR', '', false);
+INSERT INTO chart VALUES (10211, '32000', 'ZÃvazky', 'H', 'L', 'AP', '', false);
+INSERT INTO chart VALUES (10213, '32100', 'DodavatelÃ', 'A', 'L', 'AP', '', false);
+INSERT INTO chart VALUES (10219, '32500', 'OstatnÃ zÃvazky', 'A', 'L', 'AP', '', false);
+INSERT INTO chart VALUES (10019, '2200', 'SamostatnÃ movitÃ vÄci a soubory movitÃch vÄcÃ', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10021, '2500', 'PÄstitelskÃ celky trvalÃch porostÅ', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10023, '2600', 'ZÃkladnÃ stÃdo a taÅnÃ zvÃÅata', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10035, '4000', 'PoÅÃzenÃ dlouhodobÃho nehmotnÃho a hmotnÃho majetku', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10139, '19200', 'OpravnÃ poloÅka k nedokonÃenÃ vÃrobÃ', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10255, '34700', 'OstatnÃ dotace', 'A', 'L', '', '', false);
+INSERT INTO chart VALUES (10261, '35300', 'PohledÃvky za upsanÃ vlastnÃ kapitÃl', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10283, '37000', 'JinÃ pohledÃvky a zÃvazky', 'H', 'L', '', '', false);
+INSERT INTO chart VALUES (10287, '37300', 'NakoupenÃ opce', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10289, '37400', 'ProdanÃ opce', 'A', 'L', '', '', false);
+INSERT INTO chart VALUES (10295, '37800', 'JinÃ pohledÃvky', 'A', 'A', 'AR', '', false);
+INSERT INTO chart VALUES (10297, '37900', 'JinÃ zÃvazky', 'A', 'L', 'AP', '', false);
+INSERT INTO chart VALUES (10311, '38600', 'KursovÃ rozdÃly aktivnÃ', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10313, '38700', 'KursovÃ rozdÃly pasÃvnÃ', 'A', 'L', '', '', false);
+INSERT INTO chart VALUES (10331, '41100', 'ZÃkladnÃ kapitÃl', 'A', 'Q', '', '', false);
+INSERT INTO chart VALUES (10335, '41300', 'OstatnÃ kapitÃlovÃ fondy', 'A', 'Q', '', '', false);
+INSERT INTO chart VALUES (10341, '42100', 'ZÃkonnÃ rezervnÃ fond', 'A', 'Q', '', '', false);
+INSERT INTO chart VALUES (10345, '42300', 'StatutÃrnÃ fondy', 'A', 'Q', '', '', false);
+INSERT INTO chart VALUES (10347, '42700', 'OstatnÃ fondy', 'A', 'Q', '', '', false);
+INSERT INTO chart VALUES (10357, '45000', 'Rezervy', 'H', 'Q', '', '', false);
+INSERT INTO chart VALUES (10359, '45100', 'Rezervy zÃkonnÃ', 'A', 'Q', '', '', false);
+INSERT INTO chart VALUES (10361, '45400', 'Rezerva na kursovÃ ztrÃty', 'A', 'Q', '', '', false);
+INSERT INTO chart VALUES (10363, '45900', 'OstatnÃ rezervy', 'A', 'Q', '', '', false);
+INSERT INTO chart VALUES (10369, '47000', 'DlouhodobÃ zÃvazky', 'H', 'L', '', '', false);
+INSERT INTO chart VALUES (10373, '47300', 'EmitovanÃ dluhopisy', 'A', 'L', '', '', false);
+INSERT INTO chart VALUES (10375, '47400', 'ZÃvazky z pronÃjmu', 'A', 'L', 'AP', '', false);
+INSERT INTO chart VALUES (10381, '47900', 'OstatnÃ dlouhodobÃ zÃvazky', 'A', 'L', 'AP', '', false);
+INSERT INTO chart VALUES (10383, '49000', 'IndividuÃlnÃ podnikatel', 'A', 'Q', '', '', false);
+INSERT INTO chart VALUES (10401, '51200', 'CestovnÃ', 'A', 'E', 'AP_amount:IC_expense', '', false);
+INSERT INTO chart VALUES (10403, '51300', 'NÃklady na reprezentaci', 'A', 'E', 'AP_amount:IC_expense', '', false);
+INSERT INTO chart VALUES (10407, '52000', 'OsobnÃ nÃklady', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10409, '52100', 'MzdovÃ nÃklady', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10419, '52600', 'SociÃlnÃ nÃklady individuÃlnÃho podnikatele', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10421, '52700', 'ZÃkonnÃ sociÃlnÃ nÃklady', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10423, '52800', 'OstatnÃ sociÃlnÃ nÃklady', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10433, '54000', 'JinÃ provoznÃ nÃklady', 'A', 'E', 'AP_amount:IC_expense', '', false);
+INSERT INTO chart VALUES (10437, '54200', 'ProdanÃ materiÃl', 'A', 'E', 'IC_COGS', '', false);
+INSERT INTO chart VALUES (10439, '54300', 'Dary', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10441, '54400', 'SmluvnÃ pokuty a Ãroky z prodlenÃ', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10443, '54500', 'OstatnÃ pokuty a penÃle', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10445, '54600', 'Odpis pohledÃvky', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10447, '54800', 'OstatnÃ provoznÃ nÃklady', 'A', 'E', 'AP_amount:IC_expense', '', false);
+INSERT INTO chart VALUES (10451, '55100', 'Odpisy dlouhodobÃho nehmotnÃho a hmotnÃho majetku', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10453, '55200', 'Tvorba zÃkonnÃch rezerv', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10455, '55400', 'Tvorba ostatnÃch rezerv', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10467, '56100', 'ProdanÃ cennÃ papÃry a vklady', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10469, '56200', 'Ãroky', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10471, '56300', 'KursovÃ ztrÃty', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10477, '57400', 'Tvorba rezerv', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10487, '58400', 'Tvorba rezerv', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10529, '62000', 'Aktivace', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10537, '62400', 'Aktivace dlouhodobÃho hmotnÃho majetku', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10539, '64000', 'JinÃ provoznÃ vÃnosy.', 'A', 'I', 'AR_amount:IC_sale:IC_Income', '', false);
+INSERT INTO chart VALUES (10547, '64600', 'VÃnosy z odepsanÃch pohledÃvek', 'A', 'I', 'AR_amount', '', false);
+INSERT INTO chart VALUES (10549, '64800', 'JinÃ provoznÃ vÃnosy', 'A', 'I', 'AR_amount:IC_sale:IC_Income', '', false);
+INSERT INTO chart VALUES (10569, '66200', 'Ãroky', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10571, '66300', 'KursovÃ zisky', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10243, '34311', 'DPH snÃÅenÃ vstup', 'A', 'L', 'AP_tax:IC_taxpart:IC_taxservice', '', false);
+INSERT INTO chart VALUES (10245, '34312', 'DPH zÃkladnÃ vstup', 'A', 'L', 'AP_tax:IC_taxpart:IC_taxservice', '', false);
+INSERT INTO chart VALUES (10247, '34321', 'DPH snÃÅenÃ vÃstup', 'A', 'L', 'AR_tax:IC_taxpart:IC_taxservice', '', false);
+INSERT INTO chart VALUES (10249, '34322', 'DPH zÃkladnÃ vÃstup', 'A', 'L', 'AR_tax:IC_taxpart:IC_taxservice', '', false);
+INSERT INTO chart VALUES (10003, '1100', 'ZÅizovacÃ vÃdaje', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10037, '4100', 'PoÅÃzenÃ dlouhodobÃho nehmotnÃho majetku', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10039, '4200', 'PoÅÃzenÃ dlouhodobÃho hmotnÃho majetku', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10047, '6000', 'DlouhodobÃ finanÄnÃ majetek', 'H', 'A', '', '', false);
+INSERT INTO chart VALUES (10055, '6600', 'PÃjÄky podnikÃm ve skupinÃ', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10057, '6700', 'OstatnÃ pÃjÄky', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10059, '6900', 'OstatnÃ dlouhodobÃ finanÄnÃ majetek', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10061, '7000', 'OprÃvky k dlouhodobÃmu nehmotnÃmu majetku', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10063, '7100', 'OprÃvky ke zÅizovacÃm vÃdajÃm', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10065, '7200', 'OprÃvky k nehmotnÃm vÃsledkÅm vÃzkumu a vÃvoje', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10069, '7400', 'OprÃvky k ocenitelnÃm prÃvÅm', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10079, '8200', 'OprÃvky k samostatnÃm movitÃm vÄcem a souborÃm movitÃch vÄcÃ', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10081, '8500', 'OprÃvky k pÄstitelskÃm celkÅm trvalÃch porostÅ', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10083, '8600', 'OprÃvky k zÃkladnÃmu stÃdu a taÅnÃm zvÃÅatÅm', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10089, '9000', 'OpravnÃ poloÅky k dlouhodobÃmu majetku', 'H', 'A', '', '', false);
+INSERT INTO chart VALUES (10091, '9100', 'OpravnÃ poloÅka k dlouhodobÃmu nehmotnÃmu majetku', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10093, '9200', 'OpravnÃ poloÅka k dlouhodobÃmu hmotnÃmu majetku', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10095, '9300', 'OpravnÃ poloÅka k dlouhodobÃmu nedokonÄenÃmu nehmotnÃmu', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10097, '9400', 'OpravnÃ poloÅka k dlouhodobÃmu nedokonÄenÃmu hmotnÃmu', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10099, '9500', 'OpravnÃ poloÅka k poskytnutÃm zÃlohÃm', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10101, '9600', 'OpravnÃ poloÅka k dlouhodobÃmu finanÄnÃmu majetku', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10103, '9700', 'OpravnÃ poloÅka k nabytÃmu majetku', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10105, '9800', 'OprÃvky k opravnÃ poloÅce k nabytÃmu majetku', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10111, '11100', 'PoÅÃzenÃ materiÃlu', 'A', 'A', 'IC', '', false);
+INSERT INTO chart VALUES (10113, '11200', 'MateriÃl na skladÄ', 'A', 'A', 'IC', '', false);
+INSERT INTO chart VALUES (10115, '11900', 'MateriÃl na cestÄ', 'A', 'A', 'IC', '', false);
+INSERT INTO chart VALUES (10119, '12100', 'NedokonÄenÃ vÃroba', 'A', 'A', 'IC', '', false);
+INSERT INTO chart VALUES (10125, '12400', 'ZvÃÅata', 'A', 'A', 'IC', '', false);
+INSERT INTO chart VALUES (10127, '13000', 'ZboÅÃ', 'H', 'A', '', '', false);
+INSERT INTO chart VALUES (10129, '13100', 'PoÅÃzenÃ zboÅÃ', 'A', 'A', 'IC', '', false);
+INSERT INTO chart VALUES (10131, '13200', 'ZboÅÃ na skladÄ a v prodejnÃch', 'A', 'A', 'IC', '', false);
+INSERT INTO chart VALUES (10133, '13900', 'ZboÅÃ na cestÄ', 'A', 'A', 'IC', '', false);
+INSERT INTO chart VALUES (10135, '19000', 'OpravnÃ poloÅky k zÃsobÃm', 'H', 'A', '', '', false);
+INSERT INTO chart VALUES (10137, '19100', 'OpravnÃ poloÅka k materiÃlu', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10141, '19300', 'OpravnÃ poloÅka k polotovarÅm vlastnÃ vÃroby', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10143, '19400', 'OpravnÃ poloÅka k vÃrobkÃm', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10145, '19500', 'OpravnÃ poloÅka ke zvÃÅatÅm', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10147, '19600', 'OpravnÃ poloÅka ke zboÅÃ', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10149, '20000', 'FinanÄnÃ ÃÄty', 'H', 'A', '', '', false);
+INSERT INTO chart VALUES (10157, '22000', 'ÃÄty v bankÃch', 'H', 'A', '', '', false);
+INSERT INTO chart VALUES (10159, '22100', 'BankovnÃ ÃÄty', 'A', 'A', 'AR_paid:AP_paid', '', false);
+INSERT INTO chart VALUES (10161, '22200', 'BankovnÃ ÃÄty klientÃ', 'A', 'A', 'AR_paid:AP_paid', '', false);
+INSERT INTO chart VALUES (10163, '23000', 'BÄÅnÃ bankovnÃ ÃvÄry', 'H', 'L', '', '', false);
+INSERT INTO chart VALUES (10165, '23100', 'KrÃtkodobÃ bankovnÃ ÃvÄry', 'A', 'L', '', '', false);
+INSERT INTO chart VALUES (10167, '23200', 'EskontnÃ ÃvÄry', 'A', 'L', '', '', false);
+INSERT INTO chart VALUES (10169, '24000', 'JinÃ krÃtkodobÃ finanÄnÃ vÃpomoci', 'H', 'L', '', '', false);
+INSERT INTO chart VALUES (10173, '24900', 'OstatnÃ krÃtkodobÃ finanÄnÃ vÃpomoci', 'A', 'L', '', '', false);
+INSERT INTO chart VALUES (10175, '25000', 'KrÃtkodobÃ finanÄnÃ majetek', 'H', 'A', '', '', false);
+INSERT INTO chart VALUES (10181, '25300', 'DluÅnÃ cennÃ papÃry', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10187, '26000', 'PÅevody mezi finanÄnÃmi ÃÄty', 'H', 'A', '', '', false);
+INSERT INTO chart VALUES (10189, '26100', 'PenÃze na cestÄ', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10191, '29000', 'OpravnÃ poloÅky ke krÃtkodobÃmu finanÄnÃmu majetku', 'H', 'A', '', '', false);
+INSERT INTO chart VALUES (10193, '29100', 'OpravnÃ poloÅka k majetkovÃm cennÃm papÃrÃm', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10195, '29300', 'OpravnÃ poloÅka k dluÅnÃm cennÃm papÃrÅm', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10197, '30000', 'ZÃÄtovacÃ vztahy', 'H', 'H', '', '', false);
+INSERT INTO chart VALUES (10201, '31100', 'OdbÄratelÃ', 'A', 'A', 'AR', '', false);
+INSERT INTO chart VALUES (10203, '31200', 'SmÄnky k inkasu', 'A', 'A', 'AR', '', false);
+INSERT INTO chart VALUES (10215, '32200', 'SmÄnky k ÃhradÄ', 'A', 'L', 'AP', '', false);
+INSERT INTO chart VALUES (10217, '32400', 'PÅijatÃ zÃlohy', 'A', 'L', 'AP', '', false);
+INSERT INTO chart VALUES (10221, '32600', ' ZÃvazky vÅÄi klientÅm', 'A', 'L', 'AP', '', false);
+INSERT INTO chart VALUES (10223, '32700', ' ZÃvazky vÅÄi trhÅm', 'A', 'L', 'AP', '', false);
+INSERT INTO chart VALUES (10225, '33000', 'ZÃÄtovÃnÃ se zamÄstnanci a institucemi', 'H', 'L', '', '', false);
+INSERT INTO chart VALUES (10227, '33100', 'ZamÄstnanci', 'A', 'L', 'AP', '', false);
+INSERT INTO chart VALUES (10229, '33300', 'OstatnÃ zÃvazky vÅÄi zamÄstnancÅm', 'A', 'L', 'AP', '', false);
+INSERT INTO chart VALUES (10231, '33500', 'PohledÃvky za zamÄstnanci', 'A', 'A', 'AR', '', false);
+INSERT INTO chart VALUES (10233, '33600', 'ZÅÄtovÃnÃ s institucemi sociÃlnÃho zabezpeÄenÃ a zp', 'A', 'L', 'AP', '', false);
+INSERT INTO chart VALUES (10235, '34000', 'ZÅÄtovÃnÃ danÃ a dotacÃ', 'H', 'L', '', '', false);
+INSERT INTO chart VALUES (10237, '34100', 'DaÅ z pÅÃjmu', 'A', 'L', '', '', false);
+INSERT INTO chart VALUES (10239, '34200', 'OstatnÃ pÅÃmÃ danÄ', 'A', 'L', '', '', false);
+INSERT INTO chart VALUES (10241, '34300', 'DaÅ z pÅidanÃ hodnoty - zÃÄtovÃnÃ', 'A', 'L', '', '', false);
+INSERT INTO chart VALUES (10251, '34500', 'OstatnÃ danÄ a poplatky', 'A', 'L', '', '', false);
+INSERT INTO chart VALUES (10253, '34600', 'Dotace ze stÃtnÃho rozpoÄtu', 'A', 'L', '', '', false);
+INSERT INTO chart VALUES (10257, '35000', 'PohledÃvky ke spoleÄnÃkÅm a sdruÅenÃ', 'H', 'A', 'AR', '', false);
+INSERT INTO chart VALUES (10259, '35100', 'PohledÃvky k podnikÅm ve skupinÄ', 'A', 'A', 'AR', '', false);
+INSERT INTO chart VALUES (10263, '35400', 'PohledÃvky za spoleÄnÃky pÅi ÃhradÄ ztrÃty', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10265, '35500', 'OstatnÃ pohledÃvky za spoleÄnÃky', 'A', 'A', 'AR', '', false);
+INSERT INTO chart VALUES (10267, '35800', 'PohledÃvky k ÃÄastnÃkÃm sdruÅenÃ', 'A', 'A', 'AR', '', false);
+INSERT INTO chart VALUES (10269, '36000', 'ZÃvazky ke spoleÄnÃkÅm a sdruÅenÃ', 'H', 'L', 'AP', '', false);
+INSERT INTO chart VALUES (10271, '36100', 'ZÃvazky k podnikÅm ve skupinÄ', 'A', 'L', 'AP', '', false);
+INSERT INTO chart VALUES (10273, '36400', 'ZÃvazky ke spoleÄnÃkÅm pÅi rozdÄlovÃnÃ zisku', 'A', 'L', 'AP', '', false);
+INSERT INTO chart VALUES (10275, '36500', 'OstatnÃ zÃvazky ke spoleÄnÃkÅm', 'A', 'L', 'AP', '', false);
+INSERT INTO chart VALUES (10277, '36600', 'ZÃvazky ke spoleÄnÃkÅm a ÄlenÅm druÅstva ze zÃvislÃ', 'A', 'L', '', '', false);
+INSERT INTO chart VALUES (10279, '36700', 'ZÃvazky z upsanÃch nesplacenÃch cennÃch papÃrÅ a vkladÅ', 'A', 'L', '', '', false);
+INSERT INTO chart VALUES (10281, '36800', 'ZÃvazky k ÃÄastnÃkÅm sdruÅenÃ', 'A', 'L', 'AP', '', false);
+INSERT INTO chart VALUES (10285, '37100', 'OdloÅenÃ daÅovÃ pohledÃvka a zÃvazek', 'A', 'L', '', '', false);
+INSERT INTO chart VALUES (10291, '37500', 'PohledÃvky z emitovanÃch dluhopisÅ', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10293, '37700', ' ZÃÄtovÃnÃ obchodÅ', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10299, '38000', 'PÅechodnÃ ÃÄty aktiv a pasiv', 'H', 'A', '', '', false);
+INSERT INTO chart VALUES (10301, '38100', 'NÃklady pÅÃÅtÃch obdobÃ', 'A', 'A', 'AP', '', false);
+INSERT INTO chart VALUES (10303, '38200', 'KomplexnÃ nÃklady pÅÃÅtÃch obdobÃ', 'A', 'A', 'AP', '', false);
+INSERT INTO chart VALUES (10305, '38300', 'VÃdaje pÅÃÅtÃch obdobÃ', 'A', 'L', '', '', false);
+INSERT INTO chart VALUES (10307, '38400', 'VÃnosy pÅÃÅtÃch obdobÃ', 'A', 'L', 'AR', '', false);
+INSERT INTO chart VALUES (10309, '38500', 'PÅÃjmy pÅÃÅtÃch obdobÃ', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10315, '38800', 'DohadnÃ ÃÄty aktivnÃ', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10317, '38900', 'DohadnÃ ÃÄty pasÃvnÃ', 'A', 'L', '', '', false);
+INSERT INTO chart VALUES (10319, '39000', 'OpravnÃ poloÅka k zÃÄtovacÃm vztahÅm a vnitÅnÃ zÃÄtovÃnÃ', 'H', 'A', '', '', false);
+INSERT INTO chart VALUES (10321, '39100', 'OpravnÃ poloÅka k pohledÃvkÃm', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10323, '39500', 'VnitÅnÃ zÃÄtovÃnÃ', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10325, '39800', 'SpojovacÃ ÃÄet pÅi sdruÅenÃ', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10327, '40000', 'KapitÃlovÃ ÃÄty a dlouhodobÃ zÃvazky', 'H', 'Q', '', '', false);
+INSERT INTO chart VALUES (10329, '41000', 'ZÃkladnÃ kapitÃl a kapitÃlovÃ fondy', 'H', 'Q', '', '', false);
+INSERT INTO chart VALUES (10333, '41200', 'EmisnÃ ÃÅio', 'A', 'Q', '', '', false);
+INSERT INTO chart VALUES (10337, '41400', 'OceÅovacÃ rozdÃly z pÅecenÄnÃ majetku a zÃvazkÅ', 'A', 'Q', '', '', false);
+INSERT INTO chart VALUES (10339, '42000', 'Fondy ze zisku a pÅevedenÃ hospodÃÅskÃ vÃsledky', 'H', 'Q', '', '', false);
+INSERT INTO chart VALUES (10343, '42200', 'NedÄlitelnÃ fond', 'A', 'Q', '', '', false);
+INSERT INTO chart VALUES (10349, '42800', 'NerozdÄlenÃ zisk minulÃch let', 'A', 'Q', '', '', false);
+INSERT INTO chart VALUES (10351, '42900', 'NeuhrazenÃ ztrÃta minulÃch let', 'A', 'Q', '', '', false);
+INSERT INTO chart VALUES (10353, '43000', 'HospodÃÅskÃ vÃsledek', 'H', 'Q', '', '', false);
+INSERT INTO chart VALUES (10355, '43100', 'HospodÃÅskÃ vÃsledek ve schvalovacÃm ÅÃzenÃ', 'A', 'Q', '', '', false);
+INSERT INTO chart VALUES (10365, '46000', 'BankovnÃ ÃvÄry', 'H', 'L', '', '', false);
+INSERT INTO chart VALUES (10367, '46100', 'BankovnÃ ÃvÄry', 'A', 'L', '', '', false);
+INSERT INTO chart VALUES (10371, '47100', 'DlouhodobÃ zÃvazky k podnikÅm ve skupinÄ', 'A', 'L', 'AP', '', false);
+INSERT INTO chart VALUES (10377, '47500', 'DlouhodobÃ pÅijatÃ zÃlohy', 'A', 'L', 'AP', '', false);
+INSERT INTO chart VALUES (10379, '47800', 'DlouhodobÃ smÄnky k ÃhradÄ', 'A', 'L', 'AP', '', false);
+INSERT INTO chart VALUES (10385, '49100', 'ÃÄet individuÃlnÃho podnikatele', 'A', 'Q', '', '', false);
+INSERT INTO chart VALUES (10387, '50000', 'SpotÅebovanÃ nÃkupy', 'A', 'E', 'AP_amount:IC_COGS', '', false);
+INSERT INTO chart VALUES (10389, '50100', 'SpotÅeba materiÃlu', 'A', 'E', 'AP_amount:IC_COGS', '', false);
+INSERT INTO chart VALUES (10391, '50200', 'SpotÅeba energie', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10393, '50300', 'SpotÅeba ostatnÃch neskladovatelnÃch dodÃvek', 'A', 'E', 'AP_amount:IC_COGS', '', false);
+INSERT INTO chart VALUES (10395, '50400', 'ProdanÃ zboÅÃ', 'A', 'E', 'AP_amount:IC_COGS', '', false);
+INSERT INTO chart VALUES (10397, '51000', 'SluÅby', 'A', 'E', 'AP_amount:IC_expense', '', false);
+INSERT INTO chart VALUES (10399, '51100', 'Opravy a udrÅovÃnÃ', 'A', 'E', 'AP_amount:IC_expense', '', false);
+INSERT INTO chart VALUES (10405, '51800', 'OstatnÃ sluÅby', 'A', 'E', 'AP_amount:IC_expense', '', false);
+INSERT INTO chart VALUES (10411, '52200', 'PÅÃjmy spoleÄnÃkÅ a ÄlenÅ druÅstva ze zÃvislÃ Äinnosti', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10413, '52300', 'OdmÄny ÄlenÅm orgÃnÅ spoleÄnosti a druÅstva', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10415, '52400', 'ZÃkonnÃ sociÃlnÃ pojiÅtÄnÃ', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10417, '52500', 'OstatnÃ sociÃlnÃ pojiÅtÄnÃ', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart VALUES (10425, '53000', 'DanÄ a poplatky', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10427, '53100', 'DaÅ silniÄnÃ', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10429, '53200', 'DaÅ z nemovitostÃ', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10431, '53800', 'OstatnÃ danÄ a poplatky', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10435, '54100', 'ZÅstatkovÃ cena prodanÃho dlouhodobÃho nehmotnÃho a hmotnÃho', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10449, '55000', 'Odpisy, rezervy a opravnÃ poloÅky provoznÃch nÃkladÅ', 'H', 'E', '', '', false);
+INSERT INTO chart VALUES (10457, '55500', 'ZÃÄtovÃnÃ komplexnÃch nÃkladÅ pÅÃÅtÃch obdobÃ', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10459, '55700', 'ZÃÄtovÃnÃ oprÃvky k opravnÃ poloÅce k nabytÃmu majetku', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10461, '55800', 'Tvorba zÃkonnÃch opravnÃch poloÅek', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10463, '55900', 'Tvorba opravnÃch poloÅek', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10465, '56000', 'FinanÄnÃ nÃklady', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10473, '56800', 'OstatnÃ finanÄnÃ nÃklady', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10475, '57000', 'Rezervy a opravnÃ poloÅky finanÄnÃch nÃkladÃ', 'H', 'E', '', '', false);
+INSERT INTO chart VALUES (10479, '57900', 'Tvorba opravnÃch poloÅek', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10481, '58000', 'MimoÅÃdnÃ nÃklady', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10483, '58100', 'NÃklady na zmÄnu metody', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10485, '58200', 'Manka a Åkody', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10489, '58800', 'OstatnÃ mimoÅÃdnÃ nÃklady', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10491, '58900', 'Tvorba opravnÃch poloÅek', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10493, '59000', 'DanÄ z pÅÃjmÃ a pÅevodovÃ ÃÄty', 'H', 'E', '', '', false);
+INSERT INTO chart VALUES (10495, '59100', 'DaÅ z pÅÃjmu z bÄÅnÃ Äinnosti - splatnÃ', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10497, '59200', 'DaÅ z pÅÃjmu z bÄÅnÃ Äinnosti - odloÅenÃ', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10499, '59300', 'DaÅ z pÅÃjmu z mimoÅÃdnÃ Äinnosti - splatnÃ', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10501, '59400', 'DaÅ z pÅÃjmu z mimoÅÃdnÃ Äinnosti - odloÅenÃ', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10503, '59500', 'DodateÄnÃ odvody danÄ z pÅÃjmu', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10505, '59600', 'PÅevod podÃlu na hospodÃÅskÃm vÃsledku spoleÄnÃkÃm', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10507, '59700', 'PÅevod provoznÃch nÃkladÅ', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10509, '59800', 'PÅevod finanÄnÃch nÃkladÃ', 'A', 'E', '', '', false);
+INSERT INTO chart VALUES (10511, '60000', 'TrÅby za vlastnÃ vÃkony a zboÅÃ', 'A', 'I', 'AR_amount:IC_sale:IC_Income', '', false);
+INSERT INTO chart VALUES (10513, '60100', 'TrÅby za vlastnÃ vÃrobky', 'A', 'I', 'AR_amount:IC_sale', '', false);
+INSERT INTO chart VALUES (10515, '60200', 'TrÅby z prodeje sluÅeb', 'A', 'I', 'AR_amount:IC_income', '', false);
+INSERT INTO chart VALUES (10517, '60400', 'TrÅby za zboÅÃ', 'A', 'I', 'AR_amount:IC_sale', '', false);
+INSERT INTO chart VALUES (10519, '61000', 'ZmÄny stavu vnitropodnikovÃch zÃsob', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10521, '61100', 'ZmÄna stavu nedokonÄenÃ vÃroby', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10523, '61200', 'ZmÄna stavu polotovarÅ', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10525, '61300', 'ZmÄna stavu vÃrobkÅ', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10527, '61400', 'ZmÄna stavu zvÃÅat', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10531, '62100', 'Aktivace materiÃlu a zboÅÃ', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10533, '62200', 'Aktivace vnitropodnikovÃch sluÅeb', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10535, '62300', 'Aktivace dlouhodobÃho nehmotnÃho majetku', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10541, '64100', 'TrÅby z prodeje dlouhodobÃho nehmotnÃho a hmotnÃho majetku', 'A', 'I', 'AR_amount', '', false);
+INSERT INTO chart VALUES (10543, '64200', 'TrÅby z prodeje materiÃlu', 'A', 'I', 'AR_amount:IC_sale', '', false);
+INSERT INTO chart VALUES (10545, '64400', 'SmluvnÃ pokuty a Ãroky z prodlenÃ', 'A', 'I', 'AR_amount', '', false);
+INSERT INTO chart VALUES (10551, '65000', 'ZÃÄtovÃnÃ rezerv a opravnÃch poloÅek provoznÃch vÃnosÅ', 'H', 'I', '', '', false);
+INSERT INTO chart VALUES (10553, '65200', 'ZÃÄtovÃnÃ zÃkonnÃch rezerv', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10555, '65400', 'ZÃÄtovÃnÃ ostatnÃch rezerv', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10557, '65500', 'ZÃÄtovÃnÃ komplexnÃch nÃkladÅ pÅÃÄtÃch obdobÃ', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10559, '65700', 'ZÃÄtovÃnÃ oprÃvky k opravnÃ poloÅce k nabytÃmu majetku', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10561, '65800', 'ZÃÄtovÃnÃ zÃkonnÃch opravnÃch poloÅek', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10563, '65900', 'ZÃÄtovÃnÃ opravnÃch poloÅek', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10565, '66000', 'FinanÄnÃ vÃnosy', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10567, '66100', 'TrÅby z prodeje cennÃch papÃrÅ a vkladÅ', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10573, '66500', 'VÃnosy z dlouhodobÃho finanÄnÃho majetku', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10575, '66600', 'VÃnosy z krÃtkodobÃho finanÄnÃho majetku', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10577, '66800', 'OstatnÃ finanÄnÃ vÃnosy', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10579, '67000', 'ZÃÄtovÃnÃ rezerv a opravnÃch poloÅek finanÄnÃch vÃnosÅ', 'H', 'I', '', '', false);
+INSERT INTO chart VALUES (10581, '67400', 'ZÃÄtovÃnÃ rezerv', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10583, '67900', 'ZÃÄtovÃnÃ opravnÃch poloÅek', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10585, '68000', 'MimoÅÃdnÃ vÃnosy', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10587, '68100', 'VÃnosy ze zmÄny metody', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10589, '68400', 'ZÃÄtovÃnÃ rezerv', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10591, '68800', 'OstatnÃ mimoÅÃdnÃ vÃnosy', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10593, '68900', 'ZÃÄtovÃnÃ opravnÃch poloÅek', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10595, '69000', 'PÅevodovÃ ÃÄty', 'H', 'I', '', '', false);
+INSERT INTO chart VALUES (10597, '69700', 'PÅevod provoznÃch vÃnosÅ', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10599, '69800', 'PÅevod finanÄnÃch vÃnosÅ', 'A', 'I', '', '', false);
+INSERT INTO chart VALUES (10601, '70000', 'ÃÄty rozvaÅnÃ', 'H', 'A', '', '', false);
+INSERT INTO chart VALUES (10603, '70100', 'PoÄÃteÄnÃ ÃÄet rozvaÅnÃ', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10605, '70200', 'KoneÄnÃ ÃÄet rozvaÅnÃ', 'A', 'A', '', '', false);
+INSERT INTO chart VALUES (10607, '71000', 'ÃÄet ziskÅ a ztrÃt', 'A', 'A', '', '', false);
+--
 insert into tax (chart_id,rate) values ((select id from chart where accno = '34311'),0.05);
-insert into tax (chart_id,rate) values ((select id from chart where accno = '34312'),0.22);
+insert into tax (chart_id,rate) values ((select id from chart where accno = '34312'),0.19);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '34321'),0.05);
-insert into tax (chart_id,rate) values ((select id from chart where accno = '34322'),0.22);
+insert into tax (chart_id,rate) values ((select id from chart where accno = '34322'),0.19);
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '13200'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '60000'));
+INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '60000'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '50000'));
+INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '50000'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '99998'));
+INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '99998'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '99999'));
+INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '99999'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('curr', 'KÃ ');
+INSERT INTO defaults (setting_key, value) VALUES ('curr', 'CZK');
 
- INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
 commit;
+
+--


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
Prev by Date: SF.net SVN: ledger-smb:[2256] trunk/dists/source/build.sh
Next by Date: SF.net SVN: ledger-smb:[2258] trunk/sql/coa/cz/chart/General.sql
Previous by thread: SF.net SVN: ledger-smb:[2256] trunk/dists/source/build.sh
Next by thread: SF.net SVN: ledger-smb:[2258] trunk/sql/coa/cz/chart/General.sql
Index(es):
- Date
- Thread