[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb:[2680] trunk/sql/coa
- Subject: SF.net SVN: ledger-smb:[2680] trunk/sql/coa
- From: ..hidden..
- Date: Sat, 13 Jun 2009 18:05:09 +0000
Revision: 2680
http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2680&view=rev
Author: einhverfr
Date: 2009-06-13 18:05:09 +0000 (Sat, 13 Jun 2009)
Log Message:
-----------
More chart of accounts corrections
Modified Paths:
--------------
trunk/sql/coa/cz/chart/General.sql
trunk/sql/coa/pl/chart/General.sql
trunk/sql/coa/se/chart/Agriculture.sql
trunk/sql/coa/se/chart/Church_Society.sql
trunk/sql/coa/se/chart/General.sql
Modified: trunk/sql/coa/cz/chart/General.sql
===================================================================
--- trunk/sql/coa/cz/chart/General.sql 2009-06-13 17:48:57 UTC (rev 2679)
+++ trunk/sql/coa/cz/chart/General.sql 2009-06-13 18:05:09 UTC (rev 2680)
@@ -7,312 +7,312 @@
-- customized for http://www.ledgersmb.org/
-- encoding UTF-8
--
--- Needs to be converted to use new framework. Not working.
-
-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);
+-- Needs to be converted to use new framework. Works, though, for now.
+SELECT account_heading_save(NULL, '0000', '-----', NULL);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10001, '1000', 'Dlouhodobà nehmotnà majetek', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10033, '3200', 'UmÄleckà dÃla a sbÃrky', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10005, '1200', 'Nehmotnà vÃsledky vÃzkumu a vÃvoje', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10007, '1300', 'Software', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10009, '1400', 'Ocenitelnà prÃva', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10011, '1800', 'Drobnà dlouhodobà nehmotnà majetek', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10013, '1900', 'Ostatnà dlouhodobà nehmotnà majetek', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10015, '2000', 'Dlouhodobà Hmotnà majetek odpisovanÃ', 'H', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10017, '2100', 'Stavby', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10025, '2800', 'Drobnà dlouhodobà hmotnà majetek', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10027, '2900', 'Ostatnà dlouhodobà hmotnà majetek', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10029, '3000', 'Dlouhodobà hmotnà majetek neodpisovanÃ', 'H', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10031, '3100', 'Pozemky', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10041, '5000', 'Poskytnutà zÃlohy na dlouhodobà nehmotnà a hmotnà majetek', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10043, '5100', 'Poskytnutà zÃlohy na dlouhodobà nehmotnà majetek', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10045, '5200', 'Poskytnutà zÃlohy na dlouhodobà hmotnà majetek', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10049, '6100', 'PodÃlovà cennà papÃry a vklady v podnicÃch s rozhodujÃcÃm', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10051, '6200', 'PodÃlovà cennà papÃry a vklady v podnicÃch s podstatnÃm', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10053, '6300', 'Ostatnà dlouhodobà cennà papÃry a vklady', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10067, '7300', 'OprÃvky k softwaru', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10071, '7800', 'OprÃvky k drobnÃmu dlouhodobÃmu nehmotnÃmu majetku', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10073, '7900', 'OprÃvky k ostatnÃmu dlouhodobÃmu nehmotnÃmu majetku', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10075, '8000', 'OprÃvky k dlouhodobÃmu hmotnÃmu majetku', 'H', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10077, '8100', 'OprÃvky ke stavbÃm', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10085, '8800', 'OprÃvky k drobnÃmu dlouhodobÃmu hmotnÃmu majetku', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10087, '8900', 'OprÃvky k ostatnÃmu dlouhodobÃmu hmotnÃmu majetku', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10107, '10000', 'ZÃsoby', 'H', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10109, '11000', 'MateriÃl', 'H', 'A', 'IC', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10117, '12000', 'ZÃsoby vlastnà vÃroby', 'H', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10121, '12200', 'Polotovary vlastnà vÃroby', 'A', 'A', 'IC', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10123, '12300', 'VÃrobky', 'A', 'A', 'IC', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10151, '21000', 'PenÃze', 'A', 'A', 'AR_paid:AP_paid', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10153, '21100', 'Pokladna', 'A', 'A', 'AR_paid:AP_paid', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10155, '21300', 'Ceniny', 'A', 'A', 'AR_paid:AP_paid', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10171, '24100', 'Emitovanà krÃtkodobà dluhopisy', 'A', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10177, '25100', 'Majetkovà cennà papÃry', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10179, '25200', 'Vlastnà akcie a vlastnà obchodnà podÃly', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10183, '25500', 'Vlastnà dluhopisy', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10185, '25600', 'Ostatnà cennà papÃry', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10199, '31000', 'PohledÃvky', 'H', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10205, '31300', 'PohledÃvky za eskontovanà cennà papÃry', 'A', 'A', 'AR', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10207, '31400', 'Poskytnutà provoznà zÃlohy', 'A', 'A', 'AR', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10209, '31500', 'Ostatnà pohledÃvky', 'A', 'A', 'AR', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10211, '32000', 'ZÃvazky', 'H', 'L', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10213, '32100', 'DodavatelÃ', 'A', 'L', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10219, '32500', 'Ostatnà zÃvazky', 'A', 'L', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10019, '2200', 'Samostatnà movità vÄci a soubory movitÃch vÄcÃ', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10021, '2500', 'PÄstitelskà celky trvalÃch porostÅ', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10023, '2600', 'ZÃkladnà stÃdo a taÅnà zvÃÅata', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10035, '4000', 'PoÅÃzenà dlouhodobÃho nehmotnÃho a hmotnÃho majetku', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10139, '19200', 'Opravnà poloÅka k nedokonÃenà vÃrobÃ', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10255, '34700', 'Ostatnà dotace', 'A', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10261, '35300', 'PohledÃvky za upsanà vlastnà kapitÃl', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10283, '37000', 'Jinà pohledÃvky a zÃvazky', 'H', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10287, '37300', 'Nakoupenà opce', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10289, '37400', 'Prodanà opce', 'A', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10295, '37800', 'Jinà pohledÃvky', 'A', 'A', 'AR', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10297, '37900', 'Jinà zÃvazky', 'A', 'L', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10311, '38600', 'Kursovà rozdÃly aktivnÃ', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10313, '38700', 'Kursovà rozdÃly pasÃvnÃ', 'A', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10331, '41100', 'ZÃkladnà kapitÃl', 'A', 'Q', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10335, '41300', 'Ostatnà kapitÃlovà fondy', 'A', 'Q', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10341, '42100', 'ZÃkonnà rezervnà fond', 'A', 'Q', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10345, '42300', 'StatutÃrnà fondy', 'A', 'Q', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10347, '42700', 'Ostatnà fondy', 'A', 'Q', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10357, '45000', 'Rezervy', 'H', 'Q', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10359, '45100', 'Rezervy zÃkonnÃ', 'A', 'Q', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10361, '45400', 'Rezerva na kursovà ztrÃty', 'A', 'Q', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10363, '45900', 'Ostatnà rezervy', 'A', 'Q', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10369, '47000', 'Dlouhodobà zÃvazky', 'H', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10373, '47300', 'Emitovanà dluhopisy', 'A', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10375, '47400', 'ZÃvazky z pronÃjmu', 'A', 'L', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10381, '47900', 'Ostatnà dlouhodobà zÃvazky', 'A', 'L', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10383, '49000', 'IndividuÃlnà podnikatel', 'A', 'Q', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10401, '51200', 'CestovnÃ', 'A', 'E', 'AP_amount:IC_expense', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10403, '51300', 'NÃklady na reprezentaci', 'A', 'E', 'AP_amount:IC_expense', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10407, '52000', 'Osobnà nÃklady', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10409, '52100', 'Mzdovà nÃklady', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10419, '52600', 'SociÃlnà nÃklady individuÃlnÃho podnikatele', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10421, '52700', 'ZÃkonnà sociÃlnà nÃklady', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10423, '52800', 'Ostatnà sociÃlnà nÃklady', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10433, '54000', 'Jinà provoznà nÃklady', 'A', 'E', 'AP_amount:IC_expense', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10437, '54200', 'Prodanà materiÃl', 'A', 'E', 'IC_COGS', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10439, '54300', 'Dary', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10441, '54400', 'Smluvnà pokuty a Ãroky z prodlenÃ', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10443, '54500', 'Ostatnà pokuty a penÃle', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10445, '54600', 'Odpis pohledÃvky', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10447, '54800', 'Ostatnà provoznà nÃklady', 'A', 'E', 'AP_amount:IC_expense', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10451, '55100', 'Odpisy dlouhodobÃho nehmotnÃho a hmotnÃho majetku', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10453, '55200', 'Tvorba zÃkonnÃch rezerv', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10455, '55400', 'Tvorba ostatnÃch rezerv', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10467, '56100', 'Prodanà cennà papÃry a vklady', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10469, '56200', 'Ãroky', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10471, '56300', 'Kursovà ztrÃty', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10477, '57400', 'Tvorba rezerv', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10487, '58400', 'Tvorba rezerv', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10529, '62000', 'Aktivace', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10537, '62400', 'Aktivace dlouhodobÃho hmotnÃho majetku', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10539, '64000', 'Jinà provoznà vÃnosy.', 'A', 'I', 'AR_amount:IC_sale:IC_Income', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10547, '64600', 'VÃnosy z odepsanÃch pohledÃvek', 'A', 'I', 'AR_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10549, '64800', 'Jinà provoznà vÃnosy', 'A', 'I', 'AR_amount:IC_sale:IC_Income', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10569, '66200', 'Ãroky', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10571, '66300', 'Kursovà zisky', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10243, '34311', 'DPH snÃÅenà vstup', 'A', 'L', 'AP_tax:IC_taxpart:IC_taxservice', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10245, '34312', 'DPH zÃkladnà vstup', 'A', 'L', 'AP_tax:IC_taxpart:IC_taxservice', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10247, '34321', 'DPH snÃÅenà vÃstup', 'A', 'L', 'AR_tax:IC_taxpart:IC_taxservice', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10249, '34322', 'DPH zÃkladnà vÃstup', 'A', 'L', 'AR_tax:IC_taxpart:IC_taxservice', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10003, '1100', 'ZÅizovacà vÃdaje', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10037, '4100', 'PoÅÃzenà dlouhodobÃho nehmotnÃho majetku', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10039, '4200', 'PoÅÃzenà dlouhodobÃho hmotnÃho majetku', 'A', 'A', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10047, '6000', 'Dlouhodobà finanÄnà majetek', 'H', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10055, '6600', 'PÃjÄky podnikÃm ve skupinÃ', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10057, '6700', 'Ostatnà pÃjÄky', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10059, '6900', 'Ostatnà dlouhodobà finanÄnà majetek', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10061, '7000', 'OprÃvky k dlouhodobÃmu nehmotnÃmu majetku', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10063, '7100', 'OprÃvky ke zÅizovacÃm vÃdajÃm', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10065, '7200', 'OprÃvky k nehmotnÃm vÃsledkÅm vÃzkumu a vÃvoje', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10069, '7400', 'OprÃvky k ocenitelnÃm prÃvÅm', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) 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 (id, accno, description, charttype, category, link, gifi_accno, contra) values (10081, '8500', 'OprÃvky k pÄstitelskÃm celkÅm trvalÃch porostÅ', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10083, '8600', 'OprÃvky k zÃkladnÃmu stÃdu a taÅnÃm zvÃÅatÅm', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10089, '9000', 'Opravnà poloÅky k dlouhodobÃmu majetku', 'H', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10091, '9100', 'Opravnà poloÅka k dlouhodobÃmu nehmotnÃmu majetku', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10093, '9200', 'Opravnà poloÅka k dlouhodobÃmu hmotnÃmu majetku', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10095, '9300', 'Opravnà poloÅka k dlouhodobÃmu nedokonÄenÃmu nehmotnÃmu', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10097, '9400', 'Opravnà poloÅka k dlouhodobÃmu nedokonÄenÃmu hmotnÃmu', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10099, '9500', 'Opravnà poloÅka k poskytnutÃm zÃlohÃm', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10101, '9600', 'Opravnà poloÅka k dlouhodobÃmu finanÄnÃmu majetku', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10103, '9700', 'Opravnà poloÅka k nabytÃmu majetku', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10105, '9800', 'OprÃvky k opravnà poloÅce k nabytÃmu majetku', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10111, '11100', 'PoÅÃzenà materiÃlu', 'A', 'A', 'IC', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10113, '11200', 'MateriÃl na skladÄ', 'A', 'A', 'IC', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10115, '11900', 'MateriÃl na cestÄ', 'A', 'A', 'IC', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10119, '12100', 'NedokonÄenà vÃroba', 'A', 'A', 'IC', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10125, '12400', 'ZvÃÅata', 'A', 'A', 'IC', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10127, '13000', 'ZboÅÃ', 'H', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10129, '13100', 'PoÅÃzenà zboÅÃ', 'A', 'A', 'IC', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10131, '13200', 'ZboÅÃ na skladÄ a v prodejnÃch', 'A', 'A', 'IC', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10133, '13900', 'ZboÅÃ na cestÄ', 'A', 'A', 'IC', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10135, '19000', 'Opravnà poloÅky k zÃsobÃm', 'H', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10137, '19100', 'Opravnà poloÅka k materiÃlu', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10141, '19300', 'Opravnà poloÅka k polotovarÅm vlastnà vÃroby', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10143, '19400', 'Opravnà poloÅka k vÃrobkÃm', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10145, '19500', 'Opravnà poloÅka ke zvÃÅatÅm', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10147, '19600', 'Opravnà poloÅka ke zboÅÃ', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10149, '20000', 'FinanÄnà ÃÄty', 'H', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10157, '22000', 'ÃÄty v bankÃch', 'H', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10159, '22100', 'Bankovnà ÃÄty', 'A', 'A', 'AR_paid:AP_paid', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10161, '22200', 'Bankovnà ÃÄty klientÃ', 'A', 'A', 'AR_paid:AP_paid', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10163, '23000', 'BÄÅnà bankovnà ÃvÄry', 'H', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10165, '23100', 'KrÃtkodobà bankovnà ÃvÄry', 'A', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10167, '23200', 'Eskontnà ÃvÄry', 'A', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10169, '24000', 'Jinà krÃtkodobà finanÄnà vÃpomoci', 'H', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10173, '24900', 'Ostatnà krÃtkodobà finanÄnà vÃpomoci', 'A', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10175, '25000', 'KrÃtkodobà finanÄnà majetek', 'H', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10181, '25300', 'DluÅnà cennà papÃry', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10187, '26000', 'PÅevody mezi finanÄnÃmi ÃÄty', 'H', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10189, '26100', 'PenÃze na cestÄ', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10191, '29000', 'Opravnà poloÅky ke krÃtkodobÃmu finanÄnÃmu majetku', 'H', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10193, '29100', 'Opravnà poloÅka k majetkovÃm cennÃm papÃrÃm', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10195, '29300', 'Opravnà poloÅka k dluÅnÃm cennÃm papÃrÅm', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10197, '30000', 'ZÃÄtovacà vztahy', 'H', 'H', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10201, '31100', 'OdbÄratelÃ', 'A', 'A', 'AR', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10203, '31200', 'SmÄnky k inkasu', 'A', 'A', 'AR', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10215, '32200', 'SmÄnky k ÃhradÄ', 'A', 'L', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10217, '32400', 'PÅijatà zÃlohy', 'A', 'L', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10221, '32600', ' ZÃvazky vÅÄi klientÅm', 'A', 'L', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10223, '32700', ' ZÃvazky vÅÄi trhÅm', 'A', 'L', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10225, '33000', 'ZÃÄtovÃnà se zamÄstnanci a institucemi', 'H', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10227, '33100', 'ZamÄstnanci', 'A', 'L', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10229, '33300', 'Ostatnà zÃvazky vÅÄi zamÄstnancÅm', 'A', 'L', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10231, '33500', 'PohledÃvky za zamÄstnanci', 'A', 'A', 'AR', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10233, '33600', 'ZÅÄtovÃnà s institucemi sociÃlnÃho zabezpeÄenà a zp', 'A', 'L', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10235, '34000', 'ZÅÄtovÃnà danà a dotacÃ', 'H', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10237, '34100', 'DaÅ z pÅÃjmu', 'A', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10239, '34200', 'Ostatnà pÅÃmà danÄ', 'A', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10241, '34300', 'DaÅ z pÅidanà hodnoty - zÃÄtovÃnÃ', 'A', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10251, '34500', 'Ostatnà danÄ a poplatky', 'A', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10253, '34600', 'Dotace ze stÃtnÃho rozpoÄtu', 'A', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10257, '35000', 'PohledÃvky ke spoleÄnÃkÅm a sdruÅenÃ', 'H', 'A', 'AR', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10259, '35100', 'PohledÃvky k podnikÅm ve skupinÄ', 'A', 'A', 'AR', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10263, '35400', 'PohledÃvky za spoleÄnÃky pÅi ÃhradÄ ztrÃty', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10265, '35500', 'Ostatnà pohledÃvky za spoleÄnÃky', 'A', 'A', 'AR', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10267, '35800', 'PohledÃvky k ÃÄastnÃkÃm sdruÅenÃ', 'A', 'A', 'AR', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10269, '36000', 'ZÃvazky ke spoleÄnÃkÅm a sdruÅenÃ', 'H', 'L', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10271, '36100', 'ZÃvazky k podnikÅm ve skupinÄ', 'A', 'L', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10273, '36400', 'ZÃvazky ke spoleÄnÃkÅm pÅi rozdÄlovÃnà zisku', 'A', 'L', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10275, '36500', 'Ostatnà zÃvazky ke spoleÄnÃkÅm', 'A', 'L', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10277, '36600', 'ZÃvazky ke spoleÄnÃkÅm a ÄlenÅm druÅstva ze zÃvislÃ', 'A', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10279, '36700', 'ZÃvazky z upsanÃch nesplacenÃch cennÃch papÃrÅ a vkladÅ', 'A', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10281, '36800', 'ZÃvazky k ÃÄastnÃkÅm sdruÅenÃ', 'A', 'L', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10285, '37100', 'OdloÅenà daÅovà pohledÃvka a zÃvazek', 'A', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10291, '37500', 'PohledÃvky z emitovanÃch dluhopisÅ', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10293, '37700', ' ZÃÄtovÃnà obchodÅ', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10299, '38000', 'PÅechodnà ÃÄty aktiv a pasiv', 'H', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10301, '38100', 'NÃklady pÅÃÅtÃch obdobÃ', 'A', 'A', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10303, '38200', 'Komplexnà nÃklady pÅÃÅtÃch obdobÃ', 'A', 'A', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10305, '38300', 'VÃdaje pÅÃÅtÃch obdobÃ', 'A', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10307, '38400', 'VÃnosy pÅÃÅtÃch obdobÃ', 'A', 'L', 'AR', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10309, '38500', 'PÅÃjmy pÅÃÅtÃch obdobÃ', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10315, '38800', 'Dohadnà ÃÄty aktivnÃ', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10317, '38900', 'Dohadnà ÃÄty pasÃvnÃ', 'A', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10319, '39000', 'Opravnà poloÅka k zÃÄtovacÃm vztahÅm a vnitÅnà zÃÄtovÃnÃ', 'H', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10321, '39100', 'Opravnà poloÅka k pohledÃvkÃm', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10323, '39500', 'VnitÅnà zÃÄtovÃnÃ', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10325, '39800', 'Spojovacà ÃÄet pÅi sdruÅenÃ', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10327, '40000', 'KapitÃlovà ÃÄty a dlouhodobà zÃvazky', 'H', 'Q', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10329, '41000', 'ZÃkladnà kapitÃl a kapitÃlovà fondy', 'H', 'Q', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10333, '41200', 'Emisnà ÃÅio', 'A', 'Q', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10337, '41400', 'OceÅovacà rozdÃly z pÅecenÄnà majetku a zÃvazkÅ', 'A', 'Q', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10339, '42000', 'Fondy ze zisku a pÅevedenà hospodÃÅskà vÃsledky', 'H', 'Q', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10343, '42200', 'NedÄlitelnà fond', 'A', 'Q', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10349, '42800', 'NerozdÄlenà zisk minulÃch let', 'A', 'Q', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10351, '42900', 'Neuhrazenà ztrÃta minulÃch let', 'A', 'Q', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10353, '43000', 'HospodÃÅskà vÃsledek', 'H', 'Q', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10355, '43100', 'HospodÃÅskà vÃsledek ve schvalovacÃm ÅÃzenÃ', 'A', 'Q', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10365, '46000', 'Bankovnà ÃvÄry', 'H', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10367, '46100', 'Bankovnà ÃvÄry', 'A', 'L', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10371, '47100', 'Dlouhodobà zÃvazky k podnikÅm ve skupinÄ', 'A', 'L', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10377, '47500', 'Dlouhodobà pÅijatà zÃlohy', 'A', 'L', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10379, '47800', 'Dlouhodobà smÄnky k ÃhradÄ', 'A', 'L', 'AP', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10385, '49100', 'ÃÄet individuÃlnÃho podnikatele', 'A', 'Q', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10387, '50000', 'SpotÅebovanà nÃkupy', 'A', 'E', 'AP_amount:IC_COGS', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10389, '50100', 'SpotÅeba materiÃlu', 'A', 'E', 'AP_amount:IC_COGS', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10391, '50200', 'SpotÅeba energie', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10393, '50300', 'SpotÅeba ostatnÃch neskladovatelnÃch dodÃvek', 'A', 'E', 'AP_amount:IC_COGS', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10395, '50400', 'Prodanà zboÅÃ', 'A', 'E', 'AP_amount:IC_COGS', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10397, '51000', 'SluÅby', 'A', 'E', 'AP_amount:IC_expense', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10399, '51100', 'Opravy a udrÅovÃnÃ', 'A', 'E', 'AP_amount:IC_expense', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10405, '51800', 'Ostatnà sluÅby', 'A', 'E', 'AP_amount:IC_expense', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10411, '52200', 'PÅÃjmy spoleÄnÃkÅ a ÄlenÅ druÅstva ze zÃvislà Äinnosti', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10413, '52300', 'OdmÄny ÄlenÅm orgÃnÅ spoleÄnosti a druÅstva', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10415, '52400', 'ZÃkonnà sociÃlnà pojiÅtÄnÃ', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10417, '52500', 'Ostatnà sociÃlnà pojiÅtÄnÃ', 'A', 'E', 'AP_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10425, '53000', 'DanÄ a poplatky', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10427, '53100', 'DaÅ silniÄnÃ', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10429, '53200', 'DaÅ z nemovitostÃ', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10431, '53800', 'Ostatnà danÄ a poplatky', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10435, '54100', 'ZÅstatkovà cena prodanÃho dlouhodobÃho nehmotnÃho a hmotnÃho', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10449, '55000', 'Odpisy, rezervy a opravnà poloÅky provoznÃch nÃkladÅ', 'H', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10457, '55500', 'ZÃÄtovÃnà komplexnÃch nÃkladÅ pÅÃÅtÃch obdobÃ', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10459, '55700', 'ZÃÄtovÃnà oprÃvky k opravnà poloÅce k nabytÃmu majetku', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10461, '55800', 'Tvorba zÃkonnÃch opravnÃch poloÅek', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10463, '55900', 'Tvorba opravnÃch poloÅek', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10465, '56000', 'FinanÄnà nÃklady', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10473, '56800', 'Ostatnà finanÄnà nÃklady', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10475, '57000', 'Rezervy a opravnà poloÅky finanÄnÃch nÃkladÃ', 'H', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10479, '57900', 'Tvorba opravnÃch poloÅek', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10481, '58000', 'MimoÅÃdnà nÃklady', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10483, '58100', 'NÃklady na zmÄnu metody', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10485, '58200', 'Manka a Åkody', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10489, '58800', 'Ostatnà mimoÅÃdnà nÃklady', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10491, '58900', 'Tvorba opravnÃch poloÅek', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10493, '59000', 'DanÄ z pÅÃjmà a pÅevodovà ÃÄty', 'H', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10495, '59100', 'DaÅ z pÅÃjmu z bÄÅnà Äinnosti - splatnÃ', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10497, '59200', 'DaÅ z pÅÃjmu z bÄÅnà Äinnosti - odloÅenÃ', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10499, '59300', 'DaÅ z pÅÃjmu z mimoÅÃdnà Äinnosti - splatnÃ', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10501, '59400', 'DaÅ z pÅÃjmu z mimoÅÃdnà Äinnosti - odloÅenÃ', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10503, '59500', 'DodateÄnà odvody danÄ z pÅÃjmu', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10505, '59600', 'PÅevod podÃlu na hospodÃÅskÃm vÃsledku spoleÄnÃkÃm', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10507, '59700', 'PÅevod provoznÃch nÃkladÅ', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10509, '59800', 'PÅevod finanÄnÃch nÃkladÃ', 'A', 'E', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10511, '60000', 'TrÅby za vlastnà vÃkony a zboÅÃ', 'A', 'I', 'AR_amount:IC_sale:IC_Income', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10513, '60100', 'TrÅby za vlastnà vÃrobky', 'A', 'I', 'AR_amount:IC_sale', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10515, '60200', 'TrÅby z prodeje sluÅeb', 'A', 'I', 'AR_amount:IC_income', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10517, '60400', 'TrÅby za zboÅÃ', 'A', 'I', 'AR_amount:IC_sale', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10519, '61000', 'ZmÄny stavu vnitropodnikovÃch zÃsob', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10521, '61100', 'ZmÄna stavu nedokonÄenà vÃroby', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10523, '61200', 'ZmÄna stavu polotovarÅ', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10525, '61300', 'ZmÄna stavu vÃrobkÅ', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10527, '61400', 'ZmÄna stavu zvÃÅat', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10531, '62100', 'Aktivace materiÃlu a zboÅÃ', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10533, '62200', 'Aktivace vnitropodnikovÃch sluÅeb', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10535, '62300', 'Aktivace dlouhodobÃho nehmotnÃho majetku', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10541, '64100', 'TrÅby z prodeje dlouhodobÃho nehmotnÃho a hmotnÃho majetku', 'A', 'I', 'AR_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10543, '64200', 'TrÅby z prodeje materiÃlu', 'A', 'I', 'AR_amount:IC_sale', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10545, '64400', 'Smluvnà pokuty a Ãroky z prodlenÃ', 'A', 'I', 'AR_amount', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10551, '65000', 'ZÃÄtovÃnà rezerv a opravnÃch poloÅek provoznÃch vÃnosÅ', 'H', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10553, '65200', 'ZÃÄtovÃnà zÃkonnÃch rezerv', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10555, '65400', 'ZÃÄtovÃnà ostatnÃch rezerv', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10557, '65500', 'ZÃÄtovÃnà komplexnÃch nÃkladÅ pÅÃÄtÃch obdobÃ', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10559, '65700', 'ZÃÄtovÃnà oprÃvky k opravnà poloÅce k nabytÃmu majetku', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10561, '65800', 'ZÃÄtovÃnà zÃkonnÃch opravnÃch poloÅek', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10563, '65900', 'ZÃÄtovÃnà opravnÃch poloÅek', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10565, '66000', 'FinanÄnà vÃnosy', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10567, '66100', 'TrÅby z prodeje cennÃch papÃrÅ a vkladÅ', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10573, '66500', 'VÃnosy z dlouhodobÃho finanÄnÃho majetku', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10575, '66600', 'VÃnosy z krÃtkodobÃho finanÄnÃho majetku', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10577, '66800', 'Ostatnà finanÄnà vÃnosy', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10579, '67000', 'ZÃÄtovÃnà rezerv a opravnÃch poloÅek finanÄnÃch vÃnosÅ', 'H', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10581, '67400', 'ZÃÄtovÃnà rezerv', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10583, '67900', 'ZÃÄtovÃnà opravnÃch poloÅek', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10585, '68000', 'MimoÅÃdnà vÃnosy', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10587, '68100', 'VÃnosy ze zmÄny metody', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10589, '68400', 'ZÃÄtovÃnà rezerv', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10591, '68800', 'Ostatnà mimoÅÃdnà vÃnosy', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10593, '68900', 'ZÃÄtovÃnà opravnÃch poloÅek', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10595, '69000', 'PÅevodovà ÃÄty', 'H', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10597, '69700', 'PÅevod provoznÃch vÃnosÅ', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10599, '69800', 'PÅevod finanÄnÃch vÃnosÅ', 'A', 'I', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10601, '70000', 'ÃÄty rozvaÅnÃ', 'H', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10603, '70100', 'PoÄÃteÄnà ÃÄet rozvaÅnÃ', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10605, '70200', 'KoneÄnà ÃÄet rozvaÅnÃ', 'A', 'A', '', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) 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.19);
@@ -333,6 +333,6 @@
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
--
-rollback;
+commit;
--
Modified: trunk/sql/coa/pl/chart/General.sql
===================================================================
--- trunk/sql/coa/pl/chart/General.sql 2009-06-13 17:48:57 UTC (rev 2679)
+++ trunk/sql/coa/pl/chart/General.sql 2009-06-13 18:05:09 UTC (rev 2680)
@@ -2,7 +2,7 @@
-- Chart of Account for Poland
-- From: Peter Dabrowski <..hidden..>
-- Sun, 23 March 2003
-SELECT account_heading_save(NULL,'000000000','Aktywa TrwaÂe', NULL));
+SELECT account_heading_save(NULL,'000000000','Aktywa TrwaÂe', NULL);
SELECT account_save(NULL,'001000000','Ârodki TrwaÂe','A','', NULL, false,string_to_array('AP', ':'));
SELECT account_save(NULL,'001010000','Grunty wÂasne i prawa wieczystego uÂytkowania gruntÃw','A','', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'001020000','Budynki, locale i obiekty inÂynierii lÂdowej i wodnej','A','', NULL, false,string_to_array('AP_amount', ':'));
@@ -54,11 +54,11 @@
SELECT account_save(NULL,'009020000','Odpisy aktualizujÂce lokaty','A','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'009030000','Odpisy aktualizujÂce udzielone porzyczki dÂugoterminowe','A','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'009090000','Odpisy aktualizujÂce inne rodzaje dÂugoterminowych aktywÃw finansowych','A','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'100000000','Ârodki pieniÃÂne, rachunki bankowe oraz inne krÃtkoterminowe aktywa finansowe', NULL));
-SELECT account_save(NULL,'110000000','Ârodki pieniÃÂne w kasie','A','', NULL, false,string_to_array('AR:AP', ':'));
+SELECT account_heading_save(NULL,'100000000','Ârodki pieniÃÂne, rachunki bankowe oraz inne krÃtkoterminowe aktywa finansowe', NULL);
+SELECT account_save(NULL,'110000000','Ârodki pieniÃÂne w kasie','A','', NULL, false,string_to_array('AR', ':'));
SELECT account_save(NULL,'110010000','Kasa krajowych ÂrodkÃw pieniÃÂnych','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
SELECT account_save(NULL,'110020000','Kasa zagranicznych ÂrodkÃw pieniÃÂnych','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'113000000','Rachunki i kredyty bankowe','A','', NULL, false,string_to_array('AR:AP', ':'));
+SELECT account_save(NULL,'113000000','Rachunki i kredyty bankowe','A','', NULL, false,string_to_array('AR', ':'));
SELECT account_save(NULL,'113010000','Rachunek bieÂÂcy','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
SELECT account_save(NULL,'113020000','Rachunek ÂrodkÃw wyodrÃbnionych i zablokowanych','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
SELECT account_save(NULL,'113030000','Rachunki kredytÃw bankowych','A','', NULL, false,string_to_array('AR_paid:AP_amount:AP_paid', ':'));
@@ -77,7 +77,7 @@
SELECT account_save(NULL,'116000000','Inne aktywa pieniÃÂne','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
SELECT account_save(NULL,'117000000','Inne inwestycje krÃtkoterminowe','A','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'118000000','KrÃtkoterminowe rozliczenia miÃdzyokresowe','A','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'200000000','Rozrachunki i roszczenia', NULL));
+SELECT account_heading_save(NULL,'200000000','Rozrachunki i roszczenia', NULL);
SELECT account_save(NULL,'220000000','NaleÂnoÂci krÃtkoterminowe','L','', NULL, false,string_to_array('AR', ':'));
SELECT account_save(NULL,'220010000','NaleÂnoÂci od jednostek powiÂzanych','L','', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'220010100','NaleÂnoÂci z tytuÂu dostaw i usÂug','L','', NULL, false,string_to_array('AR_amount', ':'));
@@ -151,7 +151,7 @@
SELECT account_save(NULL,'225080000','Rozrachunki z tytuÂu dopÂat i zwrotu dopÂat','L','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'225090000','PozostaÂe rozrachunki ze wspÃlnikami','L','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'229000000','Odpisy aktualizujÂce rozrachunki','L','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'300000000','MateriaÂy i towary', NULL));
+SELECT account_heading_save(NULL,'300000000','MateriaÂy i towary', NULL);
SELECT account_save(NULL,'330000000','Rozliczenie zakupu','A','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'330010000','Rozliczenie wartoÂci materiaÂÃw i towarÃw w drodze','A','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'330020000','WartoÂci dostaw niefakturowanych','A','', NULL, false,string_to_array('', ':'));
@@ -173,7 +173,7 @@
SELECT account_save(NULL,'334000000','Odchylenia od cen ewidencyjnych materiaÂÃw i towarÃw','A','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'334010000','Odpisy aktualizujÂce wartoÂÃ materiaÂÃw','A','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'334020000','Odpisy aktualizujÂce wartoÂÃ towarÃw','A','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'400000000','Koszty wedÂug rodzajÃw i ich rozliczeÃ', NULL));
+SELECT account_heading_save(NULL,'400000000','Koszty wedÂug rodzajÃw i ich rozliczeÃ', NULL);
SELECT account_save(NULL,'440000000','Koszty wedÂug rodzajÃw','E','', NULL, false,string_to_array('AP', ':'));
SELECT account_save(NULL,'440010000','ZuÂycie materiaÂÃw i energii','E','', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'440010100','ZuÂycie materiaÂÃw biurowych','E','', NULL, false,string_to_array('AP_amount', ':'));
@@ -198,7 +198,7 @@
SELECT account_save(NULL,'449020000','PrzypadajÂce na przyszÂe okresy','E','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'449030000','Koszty zgromadzone','E','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'449040000','Koszty nie wliczane do wartoÂci sprzedaÂy','E','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'500000000','Koszty wedÂug typÃw dziaÂalnoÂci i ich rozliczenie', NULL));
+SELECT account_heading_save(NULL,'500000000','Koszty wedÂug typÃw dziaÂalnoÂci i ich rozliczenie', NULL);
SELECT account_save(NULL,'550000000','Koszty dziaÂalnoÂci podstawowej-produkcyjnej','E','', NULL, false,string_to_array('AP', ':'));
SELECT account_save(NULL,'550010000','Rozliczone koszta dziaÂalnoÂci','E','', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'550020000','Koszty nie zakoÃczonych dÂugotrwaÂych usÂug','E','', NULL, false,string_to_array('AP_amount', ':'));
@@ -215,7 +215,7 @@
SELECT account_save(NULL,'555010000','Koszty zarzÂdzania jednostkÂ','E','', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'555020000','Âwiadczenia usÂug na potrzeby reprezentacji i reklamy','E','', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'558000000','Rozliczenie kosztÃw dziaÂalnoÂci','E','', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_heading_save(NULL,'600000000','Produkty i rozliczenia miÃdzyokresowe', NULL));
+SELECT account_heading_save(NULL,'600000000','Produkty i rozliczenia miÃdzyokresowe', NULL);
SELECT account_save(NULL,'660000000','PÃÂprodukty i produkty w toku','A','', NULL, false,string_to_array('IC', ':'));
SELECT account_save(NULL,'661000000','Produkty gotowe','A','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'661010000','Wyroby gotowe','A','', NULL, false,string_to_array('', ':'));
@@ -229,7 +229,7 @@
SELECT account_save(NULL,'665000000','PozostaÂe rozliczenia miÃdzyokresowe','L','', NULL, false,string_to_array('AP', ':'));
SELECT account_save(NULL,'665010000','Czynne rozliczenia przyszÂych okresÃw','L','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'665020000','Bierne rozliczenia przyszÂych okresÃw','L','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'700000000','Przychody i koszty zwiÂzane z ich osiÂgniÃciem', NULL));
+SELECT account_heading_save(NULL,'700000000','Przychody i koszty zwiÂzane z ich osiÂgniÃciem', NULL);
SELECT account_save(NULL,'770000000','Sprzeda produktÃw','I','', NULL, false,string_to_array('AR', ':'));
SELECT account_save(NULL,'770010000','Sprzeda produktÃw na kraj','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
SELECT account_save(NULL,'770020000','Sprzeda produktÃw na eksport','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
@@ -296,7 +296,7 @@
SELECT account_save(NULL,'779130000','Koszt wytworzenia zakoÃczonych prac rozwojowych','E','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'779140000','Koszt wytworzenia produktÃw uznanych za niedobory','E','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'779150000','Koszt zaniechania okreÂlonego rodzaju dziaÂalnoÂci','E','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'800000000','KapitaÂy wÂasne i wynik finansowy', NULL));
+SELECT account_heading_save(NULL,'800000000','KapitaÂy wÂasne i wynik finansowy', NULL);
SELECT account_save(NULL,'880000000','Kapita podstawowy','Q','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'880010000','Kapita zakÂadowy','Q','', NULL, false,string_to_array('AP', ':'));
SELECT account_save(NULL,'881000000','Fundusze wydzielone jednostkom zaleÂnym','Q','', NULL, false,string_to_array('', ':'));
Modified: trunk/sql/coa/se/chart/Agriculture.sql
===================================================================
--- trunk/sql/coa/se/chart/Agriculture.sql 2009-06-13 17:48:57 UTC (rev 2679)
+++ trunk/sql/coa/se/chart/Agriculture.sql 2009-06-13 18:05:09 UTC (rev 2680)
@@ -35,7 +35,7 @@
SELECT account_save(NULL,'1088','FÃrsk imm anl.tillg','A','234', NULL, false,string_to_array('IC', ':'));
SELECT account_save(NULL,'1090','Ãvr imm anl.tillg','A','234', NULL, false,string_to_array('IC', ':'));
SELECT account_save(NULL,'1099','Ack avskr à im.an.t','C','234', NULL, false,string_to_array('IC', ':'));
-SELECT account_heading_save(NULL,'11','Byggnader och mark', NULL));
+SELECT account_heading_save(NULL,'11','Byggnader och mark', NULL);
SELECT account_save(NULL,'1110','Byggnader','A','237', NULL, false,string_to_array('IC', ':'));
SELECT account_save(NULL,'1111','Byggnader egen mark','A','237', NULL, false,string_to_array('IC', ':'));
SELECT account_save(NULL,'1112','Byggnader ofri grund','A','237', NULL, false,string_to_array('IC', ':'));
@@ -51,7 +51,7 @@
SELECT account_save(NULL,'1188','FÃrsk byggn/mark','A','237', NULL, false,string_to_array('IC', ':'));
SELECT account_save(NULL,'1190','Ãvr byggn/mark','A','237', NULL, false,string_to_array('IC', ':'));
SELECT account_save(NULL,'1199','Ack avskr Ãvr.byggn','C','237', NULL, false,string_to_array('IC', ':'));
-SELECT account_heading_save(NULL,'12','Maskiner och inv ', NULL));
+SELECT account_heading_save(NULL,'12','Maskiner och inv ', NULL);
SELECT account_save(NULL,'1200','Maskiner och inv','A','236', NULL, false,string_to_array('IC', ':'));
SELECT account_save(NULL,'1209','Ack av. mask o inv','C','236', NULL, false,string_to_array('IC', ':'));
SELECT account_save(NULL,'1210','Mask.tekn.anlÃggnin','A','236', NULL, false,string_to_array('IC', ':'));
@@ -83,7 +83,7 @@
SELECT account_save(NULL,'1291','Konst och likn','A','236', NULL, false,string_to_array('IC', ':'));
SELECT account_save(NULL,'1292','Inv.i annans fastig','A','236', NULL, false,string_to_array('IC', ':'));
SELECT account_save(NULL,'1299','Ack avs Ãvr ma./inv','C','236', NULL, false,string_to_array('IC', ':'));
-SELECT account_heading_save(NULL,'13','Finansiella anl.tillg', NULL));
+SELECT account_heading_save(NULL,'13','Finansiella anl.tillg', NULL);
SELECT account_save(NULL,'1310','Akt/andel koncernf.','A','230', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1311','Akt/and sv.do.fÃr.','A','230', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1312','Akt/and utl.do.fÃr','A','231', NULL, false,string_to_array('', ':'));
@@ -116,7 +116,7 @@
SELECT account_save(NULL,'1388','Olika lÃngfr fordr','A','233', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1389','VÃrderegl lÃngfr.f','A','233', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1390','VÃrder.vÃrdep/l.fr.f','A','233', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'14','Lager och pÃg arb', NULL));
+SELECT account_heading_save(NULL,'14','Lager och pÃg arb', NULL);
SELECT account_save(NULL,'1400','Lager','A','219', NULL, false,string_to_array('IC', ':'));
SELECT account_save(NULL,'1401','Inneliggande lager','A','219', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1402','Varor pà vÃg ','A','219', NULL, false,string_to_array('', ':'));
@@ -146,7 +146,7 @@
SELECT account_save(NULL,'1481','Remburs ','A','219', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1489','Ãvr.fÃrsk leverant','A','219', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1490','FÃr. lag.pÃg.arb','A','219', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'15','Kundfordringar', NULL));
+SELECT account_heading_save(NULL,'15','Kundfordringar', NULL);
SELECT account_save(NULL,'1500','Kundfordringar','A','204', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1510','Kundfordringar','A','204', NULL, false,string_to_array('AR', ':'));
SELECT account_save(NULL,'1512','BelÃnade kundfordr','A','204', NULL, false,string_to_array('', ':'));
@@ -172,7 +172,7 @@
SELECT account_save(NULL,'1579','VÃrderegl kundf','A','204', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1580','Kontokort och kup.','A','204', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1590','VÃrderegl kundfordr','A','204', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'16','Ãvr.kortfristiga fordringar', NULL));
+SELECT account_heading_save(NULL,'16','Ãvr.kortfristiga fordringar', NULL);
SELECT account_save(NULL,'1600','Ãvr kortfr fordr','A','220', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1610','Fordr anstÃllda ','A','220', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1611','ResefÃrskott ','A','220', NULL, false,string_to_array('', ':'));
@@ -198,7 +198,7 @@
SELECT account_save(NULL,'1687','Kortfr del l.fr.for','A','220', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1689','Ãvr kortfr fordr','A','220', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1690','VÃrderegl kortfr fordr','A','220', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'17','FÃrutbetalda kostn och upplupna int.', NULL));
+SELECT account_heading_save(NULL,'17','FÃrutbetalda kostn och upplupna int.', NULL);
SELECT account_save(NULL,'1700','FÃrutb kost uppl int','A','205', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1710','FÃrutb hyresutg','A','205', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1711','FÃrutb arrendeutg','A','205', NULL, false,string_to_array('', ':'));
@@ -210,7 +210,7 @@
SELECT account_save(NULL,'1770','Tillg av kostn.natur','A','205', NULL, false,string_to_array('', ':'));
@@ Diff output truncated at 100000 characters. @@
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.