[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



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.