- -- Czech chart of accounts
- -- Tomas.Fencl@centrum.cz
- -- Kompletn� ��tov� osnova platn� v roce 2001
- -- Osnova m� 2 m�sta pro tvorbu analytik
- --
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1000', 'Dlouhodob� nehmotn� majetek','A','','A','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1100', 'Z�izovac� v�daje','A','','A','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1200', 'Nehmotn� v�sledky v�zkumu a v�voje','A','','A','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1300', 'Software','A','','A','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1400', 'Oceniteln� pr�va','A','','A','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1800', 'Drobn� dlouhodob� nehmotn� majetek','A','','A','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1900', 'Ostatn� dlouhodob� nehmotn� majetek','A','','A','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2000', 'Dlouhodob� Hmotn� majetek odpisovan�','H','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2100', 'Stavby','A','','A','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2200', 'Samostatn� movit� v�ci a soubory movit�ch v�c�','A','','A','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2500', 'P�stitelsk� celky trval�ch porost�','A','','A','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2600', 'Z�kladn� st�do a ta�n� zv��ata','A','','A','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2800', 'Drobn� dlouhodob� hmotn� majetek','A','','A','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2900', 'Ostatn� dlouhodob� hmotn� majetek','A','','A','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3000', 'Dlouhodob� hmotn� majetek neodpisovan�','H','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3100', 'Pozemky','A','','A','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3200', 'Um�leck� d�la a sb�rky','A','','A','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4000', 'Po��zen� dlouhodob�ho nehmotn�ho a hmotn�ho majetku','A','','A','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4100', 'Po��zen� dlouhodob�ho nehmotn�ho majetku','A','','A','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4200', 'Po��zen� dlouhodob�ho hmotn�ho majetku','A','','A','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5000', 'Poskytnut� z�lohy na dlouhodob� nehmotn� a hmotn� majetek','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5100', 'Poskytnut� z�lohy na dlouhodob� nehmotn� majetek','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5200', 'Poskytnut� z�lohy na dlouhodob� hmotn� majetek','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6000', 'Dlouhodob� finan�n� majetek','H','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6100', 'Pod�lov� cenn� pap�ry a vklady v podnic�ch s rozhoduj�c�m','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6200', 'Pod�lov� cenn� pap�ry a vklady v podnic�ch s podstatn�m','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6300', 'Ostatn� dlouhodob� cenn� pap�ry a vklady','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6600', 'P�j�ky podnik�m ve skupin�','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6700', 'Ostatn� p�j�ky','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6900', 'Ostatn� dlouhodob� finan�n� majetek','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7000', 'Opr�vky k dlouhodob�mu nehmotn�mu majetku','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7100', 'Opr�vky ke z�izovac�m v�daj�m','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7200', 'Opr�vky k nehmotn�m v�sledk�m v�zkumu a v�voje','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7300', 'Opr�vky k softwaru','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7400', 'Opr�vky k oceniteln�m pr�v�m','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7800', 'Opr�vky k drobn�mu dlouhodob�mu nehmotn�mu majetku','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7900', 'Opr�vky k ostatn�mu dlouhodob�mu nehmotn�mu majetku','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8000', 'Opr�vky k dlouhodob�mu hmotn�mu majetku','H','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8100', 'Opr�vky ke stavb�m','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8200', 'Opr�vky k samostatn�m movit�m v�cem a soubor�m movit�ch v�c�','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8500', 'Opr�vky k p�stitelsk�m celk�m trval�ch porost�','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8600', 'Opr�vky k z�kladn�mu st�du a ta�n�m zv��at�m','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8800', 'Opr�vky k drobn�mu dlouhodob�mu hmotn�mu majetku','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8900', 'Opr�vky k ostatn�mu dlouhodob�mu hmotn�mu majetku','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9000', 'Opravn� polo�ky k dlouhodob�mu majetku','H','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9100', 'Opravn� polo�ka k dlouhodob�mu nehmotn�mu majetku','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9200', 'Opravn� polo�ka k dlouhodob�mu hmotn�mu majetku','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9300', 'Opravn� polo�ka k dlouhodob�mu nedokon�en�mu nehmotn�mu','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9400', 'Opravn� polo�ka k dlouhodob�mu nedokon�en�mu hmotn�mu','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9500', 'Opravn� polo�ka k poskytnut�m z�loh�m','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9600', 'Opravn� polo�ka k dlouhodob�mu finan�n�mu majetku','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9700', 'Opravn� polo�ka k nabyt�mu majetku','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9800', 'Opr�vky k opravn� polo�ce k nabyt�mu majetku','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('10000', 'Z�soby','H','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('11000', 'Materi�l','H','','A','IC');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('11100', 'Po��zen� materi�lu','A','','A','IC');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('11200', 'Materi�l na sklad�','A','','A','IC');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('11900', 'Materi�l na cest�','A','','A','IC');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12000', 'Z�soby vlastn� v�roby','H','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12100', 'Nedokon�en� v�roba','A','','A','IC');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12200', 'Polotovary vlastn� v�roby','A','','A','IC');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12300', 'V�robky','A','','A','IC');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12400', 'Zv��ata','A','','A','IC');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('13000', 'Zbo��','H','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('13100', 'Po��zen� zbo��','A','','A','IC');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('13200', 'Zbo�� na sklad� a v prodejn�ch','A','','A','IC');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('13900', 'Zbo�� na cest�','A','','A','IC');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19000', 'Opravn� polo�ky k z�sob�m','H','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19100', 'Opravn� polo�ka k materi�lu','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19200', 'Opravn� polo�ka k nedokon�en� v�rob�','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19300', 'Opravn� polo�ka k polotovar�m vlastn� v�roby','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19400', 'Opravn� polo�ka k v�robk�m','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19500', 'Opravn� polo�ka ke zv��at�m','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19600', 'Opravn� polo�ka ke zbo��','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('20000', 'Finan�n� ��ty','H','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('21000', 'Pen�ze','A','','A','AR_paid:AP_paid');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('21100', 'Pokladna','A','','A','AR_paid:AP_paid');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('21300', 'Ceniny','A','','A','AR_paid:AP_paid');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('22000', '��ty v bank�ch','H','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('22100', 'Bankovn� ��ty','A','','A','AR_paid:AP_paid');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('22200', 'Bankovn� ��ty klient�','A','','A','AR_paid:AP_paid');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('23000', 'B�n� bankovn� �v�ry','H','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('23100', 'Kr�tkodob� bankovn� �v�ry','A','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('23200', 'Eskontn� �v�ry','A','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('24000', 'Jin� kr�tkodob� finan�n� v�pomoci','H','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('24100', 'Emitovan� kr�tkodob� dluhopisy','A','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('24900', 'Ostatn� kr�tkodob� finan�n� v�pomoci','A','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('25000', 'Kr�tkodob� finan�n� majetek','H','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('25100', 'Majetkov� cenn� pap�ry','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('25200', 'Vlastn� akcie a vlastn� obchodn� pod�ly','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('25300', 'Dlu�n� cenn� pap�ry','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('25500', 'Vlastn� dluhopisy','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('25600', 'Ostatn� cenn� pap�ry','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('26000', 'P�evody mezi finan�n�mi ��ty','H','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('26100', 'Pen�ze na cest�','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('29000', 'Opravn� polo�ky ke kr�tkodob�mu finan�n�mu majetku','H','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('29100', 'Opravn� polo�ka k majetkov�m cenn�m pap�r�m','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('29300', 'Opravn� polo�ka k dlu�n�m cenn�m pap�r�m','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('30000', 'Z��tovac� vztahy','H','','H','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('31000', 'Pohled�vky','H','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('31100', 'Odb�ratel�','A','','A','AR');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('31200', 'Sm�nky k inkasu','A','','A','AR');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('31300', 'Pohled�vky za eskontovan� cenn� pap�ry','A','','A','AR');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('31400', 'Poskytnut� provozn� z�lohy','A','','A','AR');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('31500', 'Ostatn� pohled�vky','A','','A','AR');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('32000', 'Z�vazky','H','','L','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('32100', 'Dodavatel�','A','','L','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('32200', 'Sm�nky k �hrad�','A','','L','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('32400', 'P�ijat� z�lohy','A','','L','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('32500', 'Ostatn� z�vazky','A','','L','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('32600', ' Z�vazky v��i klient�m','A','','L','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('32700', ' Z�vazky v��i trh�m','A','','L','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('33000', 'Z��tov�n� se zam�stnanci a institucemi','H','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('33100', 'Zam�stnanci','A','','L','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('33300', 'Ostatn� z�vazky v��i zam�stnanc�m','A','','L','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('33500', 'Pohled�vky za zam�stnanci','A','','A','AR');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('33600', 'Z��tov�n� s institucemi soci�ln�ho zabezpe�en� a zdravotn�ho','A','','L','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34000', 'Z��tov�n� dan� a dotac�','H','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34100', 'Da� z p��jm�','A','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34200', 'Ostatn� p��m� dan�','A','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34300', 'Da� z p�idan� hodnoty - z��tov�n�','A','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34311', 'DPH 5% vstup','A','','L','AP_tax:IC_taxpart:IC_taxservice');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34312', 'DPH 22% vstup','A','','L','AP_tax:IC_taxpart:IC_taxservice');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34321', 'DPH 5% v�stup','A','','L','AR_tax:IC_taxpart:IC_taxservice');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34322', 'DPH 22% v�stup','A','','L','AR_tax:IC_taxpart:IC_taxservice');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34500', 'Ostatn� dan� a poplatky','A','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34600', 'Dotace ze st�tn�ho rozpo�tu','A','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34700', 'Ostatn� dotace','A','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('35000', 'Pohled�vky ke spole�n�k�m a sdru�en�','H','','A','AR');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('35100', 'Pohled�vky k podnik�m ve skupin�','A','','A','AR');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('35300', 'Pohled�vky za upsan� vlastn� kapit�l','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('35400', 'Pohled�vky za spole�n�ky p�i �hrad� ztr�ty','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('35500', 'Ostatn� pohled�vky za spole�n�ky','A','','A','AR');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('35800', 'Pohled�vky k ��astn�k�m sdru�en�','A','','A','AR');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36000', 'Z�vazky ke spole�n�k�m a sdru�en�','H','','L','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36100', 'Z�vazky k podnik�m ve skupin�','A','','L','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36400', 'Z�vazky ke spole�n�k�m p�i rozd�lov�n� zisku','A','','L','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36500', 'Ostatn� z�vazky ke spole�n�k�m','A','','L','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36600', 'Z�vazky ke spole�n�k�m a �len�m dru�stva ze z�visl�','A','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36700', 'Z�vazky z upsan�ch nesplacen�ch cenn�ch pap�r� a vklad�','A','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36800', 'Z�vazky k ��astn�k�m sdru�en�','A','','L','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37000', 'Jin� pohled�vky a z�vazky','H','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37100', 'Odlo�en� da�ov� pohled�vka a z�vazek','A','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37300', 'Nakoupen� opce','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37400', 'Prodan� opce','A','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37500', 'Pohled�vky z emitovan�ch dluhopis�','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37700', ' Z��tov�n� obchod�','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37800', 'Jin� pohled�vky','A','','A','AR');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37900', 'Jin� z�vazky','A','','L','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38000', 'P�echodn� ��ty aktiv a pas�v','H','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38100', 'N�klady p���t�ch obdob�','A','','A','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38200', 'Komplexn� n�klady p���t�ch obdob�','A','','A','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38300', 'V�daje p���t�ch obdob�','A','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38400', 'V�nosy p���t�ch obdob�','A','','L','AR');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38500', 'P��jmy p���t�ch obdob�','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38600', 'Kursov� rozd�ly aktivn�','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38700', 'Kursov� rozd�ly pas�vn�','A','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38800', 'Dohadn� ��ty aktivn�','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38900', 'Dohadn� ��ty pas�vn�','A','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('39000', 'Opravn� polo�ka k z��tovac�m vztah�m a vnit�n� z��tov�n�','H','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('39100', 'Opravn� polo�ka k pohled�vk�m','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('39500', 'Vnit�n� z��tov�n�','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('39800', 'Spojovac� ��et p�i sdru�en�','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('40000', 'Kapit�lov� ��ty a dlouhodob� z�vazky','H','','Q','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('41000', 'Z�kladn� kapit�l a kapit�lov� fondy','H','','Q','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('41100', 'Z�kladn� kapit�l','A','','Q','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('41200', 'Emisn� �io','A','','Q','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('41300', 'Ostatn� kapit�lov� fondy','A','','Q','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('41400', 'Oce�ovac� rozd�ly z p�ecen�n� majetku a z�vazk�','A','','Q','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42000', 'Fondy ze zisku a p�eveden� hospod��sk� v�sledky','H','','Q','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42100', 'Z�konn� rezervn� fond','A','','Q','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42200', 'Ned�liteln� fond','A','','Q','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42300', 'Statut�rn� fondy','A','','Q','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42700', 'Ostatn� fondy','A','','Q','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42800', 'Nerozd�len� zisk minul�ch let','A','','Q','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42900', 'Neuhrazen� ztr�ta minul�ch let','A','','Q','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('43000', 'Hospod��sk� v�sledek','H','','Q','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('43100', 'Hospod��sk� v�sledek ve schvalovac�m ��zen�','A','','Q','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('45000', 'Rezervy','H','','Q','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('45100', 'Rezervy z�konn�','A','','Q','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('45400', 'Rezerva na kursov� ztr�ty','A','','Q','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('45900', 'Ostatn� rezervy','A','','Q','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('46000', 'Bankovn� �v�ry','H','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('46100', 'Bankovn� �v�ry','A','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('47000', 'Dlouhodob� z�vazky','H','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('47100', 'Dlouhodob� z�vazky k podnik�m ve skupin�','A','','L','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('47300', 'Emitovan� dluhopisy','A','','L','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('47400', 'Z�vazky z pron�jmu','A','','L','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('47500', 'Dlouhodob� p�ijat� z�lohy','A','','L','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('47800', 'Dlouhodob� sm�nky k �hrad�','A','','L','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('47900', 'Ostatn� dlouhodob� z�vazky','A','','L','AP');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('49000', 'Individu�ln� podnikatel','A','','Q','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('49100', '��et individu�ln�ho podnikatele','A','','Q','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50000', 'Spot�ebovan� n�kupy','A','','E','AP_amount:IC_COGS');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50100', 'Spot�eba materi�lu','A','','E','AP_amount:IC_COGS');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50200', 'Spot�eba energie','A','','E','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50300', 'Spot�eba ostatn�ch neskladovateln�ch dod�vek','A','','E','AP_amount:IC_COGS');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50400', 'Prodan� zbo��','A','','E','AP_amount:IC_COGS');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('51000', 'Slu�by','A','','E','AP_amount:IC_expense');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('51100', 'Opravy a udr�ov�n�','A','','E','AP_amount:IC_expense');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('51200', 'Cestovn�','A','','E','AP_amount:IC_expense');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('51300', 'N�klady na reprezentaci','A','','E','AP_amount:IC_expense');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('51800', 'Ostatn� slu�by','A','','E','AP_amount:IC_expense');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52000', 'Osobn� n�klady','A','','E','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52100', 'Mzdov� n�klady','A','','E','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52200', 'P��jmy spole�n�k� a �len� dru�stva ze z�visl� �innosti','A','','E','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52300', 'Odm�ny �len�m org�n� spole�nosti a dru�stva','A','','E','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52400', 'Z�konn� soci�ln� poji�t�n�','A','','E','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52500', 'Ostatn� soci�ln� poji�t�n�','A','','E','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52600', 'Soci�ln� n�klady individu�ln�ho podnikatele','A','','E','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52700', 'Z�konn� soci�ln� n�klady','A','','E','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52800', 'Ostatn� soci�ln� n�klady','A','','E','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('53000', 'Dan� a poplatky','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('53100', 'Da� silni�n�','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('53200', 'Da� z nemovitost�','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('53800', 'Ostatn� dan� a poplatky','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54000', 'Jin� provozn� n�klady','A','','E','AP_amount:IC_expense');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54100', 'Z�statkov� cena prodan�ho dlouhodob�ho nehmotn�ho a hmotn�ho','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54200', 'Prodan� materi�l','A','','E','IC_COGS');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54300', 'Dary','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54400', 'Smluvn� pokuty a �roky z prodlen�','A','','E','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54500', 'Ostatn� pokuty a pen�le','A','','E','AP_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54600', 'Odpis pohled�vky','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54800', 'Ostatn� provozn� n�klady','A','','E','AP_amount:IC_expense');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55000', 'Odpisy, rezervy a opravn� polo�ky provozn�ch n�klad�','H','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55100', 'Odpisy dlouhodob�ho nehmotn�ho a hmotn�ho majetku','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55200', 'Tvorba z�konn�ch rezerv','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55400', 'Tvorba ostatn�ch rezerv','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55500', 'Z��tov�n� komplexn�ch n�klad� p���t�ch obdob�','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55700', 'Z��tov�n� opr�vky k opravn� polo�ce k nabyt�mu majetku','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55800', 'Tvorba z�konn�ch opravn�ch polo�ek','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55900', 'Tvorba opravn�ch polo�ek','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56000', 'Finan�n� n�klady','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56100', 'Prodan� cenn� pap�ry a vklady','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56200', '�roky','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56300', 'Kursov� ztr�ty','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56800', 'Ostatn� finan�n� n�klady','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('57000', 'Rezervy a opravn� polo�ky finan�n�ch n�klad�','H','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('57400', 'Tvorba rezerv','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('57900', 'Tvorba opravn�ch polo�ek','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58000', 'Mimo��dn� n�klady','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58100', 'N�klady na zm�nu metody','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58200', 'Manka a �kody','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58400', 'Tvorba rezerv','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58800', 'Ostatn� mimo��dn� n�klady','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58900', 'Tvorba opravn�ch polo�ek','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59000', 'Dan� z p��jm� a p�evodov� ��ty','H','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59100', 'Da� z p��jm� z b�n� �innosti - splatn�','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59200', 'Da� z p��jm� z b�n� �innosti - odlo�en�','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59300', 'Da� z p��jm� z mimo��dn� �innosti - splatn�','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59400', 'Da� z p��jm� z mimo��dn� �innosti - odlo�en�','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59500', 'Dodate�n� odvody dan� z p��jm�','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59600', 'P�evod pod�lu na hospod��sk�m v�sledku spole�n�k�m','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59700', 'P�evod provozn�ch n�klad�','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59800', 'P�evod finan�n�ch n�klad�','A','','E','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('60000', 'Tr�by za vlastn� v�kony a zbo��','A','','I','AR_amount:IC_sale:IC_Income');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('60100', 'Tr�by za vlastn� v�robky','A','','I','AR_amount:IC_sale');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('60200', 'Tr�by z prodeje slu�eb','A','','I','AR_amount:IC_income');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('60400', 'Tr�by za zbo��','A','','I','AR_amount:IC_sale');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('61000', 'Zm�ny stavu vnitropodnikov�ch z�sob','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('61100', 'Zm�na stavu nedokon�en� v�roby','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('61200', 'Zm�na stavu polotovar�','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('61300', 'Zm�na stavu v�robk�','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('61400', 'Zm�na stavu zv��at','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('62000', 'Aktivace','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('62100', 'Aktivace materi�lu a zbo��','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('62200', 'Aktivace vnitropodnikov�ch slu�eb','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('62300', 'Aktivace dlouhodob�ho nehmotn�ho majetku','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('62400', 'Aktivace dlouhodob�ho hmotn�ho majetku','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('64000', 'Jin� provozn� v�nosy.','A','','I','AR_amount:IC_sale:IC_Income');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('64100', 'Tr�by z prodeje dlouhodob�ho nehmotn�ho a hmotn�ho majetku','A','','I','AR_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('64200', 'Tr�by z prodeje materi�lu','A','','I','AR_amount:IC_sale');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('64400', 'Smluvn� pokuty a �roky z prodlen�','A','','I','AR_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('64600', 'V�nosy z odepsan�ch pohled�vek','A','','I','AR_amount');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('64800', 'Jin� provozn� v�nosy','A','','I','AR_amount:IC_sale:IC_Income');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65000', 'Z��tov�n� rezerv a opravn�ch polo�ek provozn�ch v�nos�','H','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65200', 'Z��tov�n� z�konn�ch rezerv','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65400', 'Z��tov�n� ostatn�ch rezerv','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65500', 'Z��tov�n� komplexn�ch n�klad� p���t�ch obdob�','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65700', 'Z��tov�n� opr�vky k opravn� polo�ce k nabyt�mu majetku','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65800', 'Z��tov�n� z�konn�ch opravn�ch polo�ek','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65900', 'Z��tov�n� opravn�ch polo�ek','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('66000', 'Finan�n� v�nosy','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('66100', 'Tr�by z prodeje cenn�ch pap�r� a vklad�','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('66200', '�roky','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('66300', 'Kursov� zisky','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('66500', 'V�nosy z dlouhodob�ho finan�n�ho majetku','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('66600', 'V�nosy z kr�tkodob�ho finan�n�ho majetku','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('66800', 'Ostatn� finan�n� v�nosy','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('67000', 'Z��tov�n� rezerv a opravn�ch polo�ek finan�n�ch v�nos�','H','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('67400', 'Z��tov�n� rezerv','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('67900', 'Z��tov�n� opravn�ch polo�ek','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('68000', 'Mimo��dn� v�nosy','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('68100', 'V�nosy ze zm�ny metody','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('68400', 'Z��tov�n� rezerv','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('68800', 'Ostatn� mimo��dn� v�nosy','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('68900', 'Z��tov�n� opravn�ch polo�ek','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('69000', 'P�evodov� ��ty','H','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('69700', 'P�evod provozn�ch v�nos�','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('69800', 'P�evod finan�n�ch v�nos�','A','','I','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('70000', '��ty rozva�n�','H','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('70100', 'Po��te�n� ��et rozva�n�','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('70200', 'Kone�n� ��et rozva�n�','A','','A','');
- insert into chart (accno,description,charttype,gifi_accno,category,link) values ('71000', '��et zisk� a ztr�t','A','','A','');
- --
- insert into tax (chart_id,rate) values ((select id from chart where accno = '34311'),0.05);
- insert into tax (chart_id,rate) values ((select id from chart where accno = '34312'),0.22);
- insert into tax (chart_id,rate) values ((select id from chart where accno = '34321'),0.05);
- insert into tax (chart_id,rate) values ((select id from chart where accno = '34322'),0.22);
- --
- update defaults set inventory_accno_id = (select id from chart where accno = '13200'), income_accno_id = (select id from chart where accno = '60000'), expense_accno_id = (select id from chart where accno = '50000'), fxgain_accno_id = (select id from chart where accno = '99998'), fxloss_accno_id = (select id from chart where accno = '99999'), curr = 'K� ', weightunit = 'kg';
- --
|