[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb: [2021] trunk/sql/coa/hu/chart
- Subject: SF.net SVN: ledger-smb: [2021] trunk/sql/coa/hu/chart
- From: ..hidden..
- Date: Sat, 29 Dec 2007 20:51:03 -0800
Revision: 2021
http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2021&view=rev
Author: einhverfr
Date: 2007-12-29 20:51:02 -0800 (Sat, 29 Dec 2007)
Log Message:
-----------
Adding Istvan's Hungarian charts
Added Paths:
-----------
trunk/sql/coa/hu/chart/Complete.sql
trunk/sql/coa/hu/chart/Default.sql
trunk/sql/coa/hu/chart/Old-general.sql
Removed Paths:
-------------
trunk/sql/coa/hu/chart/General.sql
Added: trunk/sql/coa/hu/chart/Complete.sql
===================================================================
--- trunk/sql/coa/hu/chart/Complete.sql (rev 0)
+++ trunk/sql/coa/hu/chart/Complete.sql 2007-12-30 04:51:02 UTC (rev 2021)
@@ -0,0 +1,446 @@
+begin;
+--Hungarian chart of accounts Complete
+-- Magyar fÃkÃnyvi szÃmlÃk, amely majdnem teljes
+--
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1111','AlapÃtÃs, ÃtszervezÃs aktivÃlt ÃrtÃke','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1131','Vagyoni ÃrtÃkÅ jogok','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1141','Szellemi termÃkek','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1171','ImmateriÃlis javak ÃrtÃkhelyesbÃtÃse','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1181','ImmateriÃlis javak terven felÃli ÃrtÃkcsÃkkenÃse','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1191','AlapitÃs, ÃtszervezÃs elszÃmolt ÃrtÃkcsÃkkenÃse','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1193','Vagyoni ÃrtÃkÅ jogok elszÃmolt ÃrtÃkcsÃkkenÃse','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1194','Szellemi termÃkek elszÃmolt ÃrtÃkcsÃkkenÃse','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1311','TermelÅ gÃpek, berendezÃsek','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1321','JÃrmÅvek','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1371','MÅszaki gÃpek, berendezÃsek, jÃrmÅvek ÃrtÃkhelyesbÃtÃse','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1381','MÅszaki gÃpek, berendezÃsek, jÃrmÅvek tereven felÃli ÃrtÃkcsÃkkenÃse','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1391','TermelÅ gÃpek, berendezÃsek elszÃmolt ÃrtÃkcsÃkkenÃse','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1392','JÃrmÅvek ÃrtÃkcsÃkkenÃse','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1411','EgyÃb gÃp, berendezÃse, szerszÃm','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1421','EgyÃb jÃrmÅvek','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1431','Irodai, igazgatÃsi berendezÃs, felszerelÃs','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1451','KisÃrtÃkÅ gÃp, berendezÃs, felszerelÃs','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1452','KisÃrtÃkÅ irodai, igazgatÃsi berendezÃs, felszerelÃs','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1471','EgyÃb gÃp, berendezÃs, szerszÃm ÃrtÃkhelyesbÃtÃse','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1472','EgyÃb jÃrmÅvek ÃrtÃkhelyesbÃtÃse','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1473','Irodai, igazgatÃsi berendezÃs, felszerelÃs ÃrtÃkhelyesbÃtÃse','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1481','EgyÃb gÃp, berendezÃs, felszerelÃs terven felÃli ÃrtÃkcsÃkkenÃse','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1482','EgyÃb jÃrmÅvek terven felÃli ÃrtÃkcsÃkkenÃse','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1483','Irodai, igazgatÃsi berendezÃsek terven felÃli ÃrtÃkcsÃkkenÃse','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1491','EgyÃb gÃp, berendezÃs, szerszÃm elszÃmolt ÃrtÃkcsÃkkenÃse','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1492','EgyÃb jÃrmÅvek elszÃmolt ÃrtÃkcsÃkkenÃse','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1493','Irodai, igazgatÃsi berendezÃs, felszerelÃs elszÃmolt ÃrtÃkcsÃkkenÃse','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1495','KisÃrtÃkÅ tÃrgyi eszkÃzÃk ÃrtÃkcsÃkkenÃse','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3920','KÃltsÃgek rÃforditÃsok aktiv idÅbeli elhatÃrolÃsa','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3910','BevÃtelek aktiv idÅbeli elhatÃrolÃsa','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2','KÃSZLETEK','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3930','Halasztott rÃforditÃsok','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3211','KÃvetelÃsek anyavÃllalattal szemben','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3251','Jegyzett, de mÃg be nem fizetett tÅke','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3291','KÃvetelÃsek ÃrtÃkvesztÃse ','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3311','KÃvetelÃsek egyÃb rÃszesedÃsi viszonyban lÃvÅ vÃllalattal szemben','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3321','Jegyzett, de mÃg be nem fizetett tÅke','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3391','EgyÃb rÃszesedÃsi viszonyban lÃvÅ vÃllakozÃssal szembeni kÃvetelÃs ÃrtÃkvesztÃse','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3410','BelfÃldi vÃltÃkÃvetelÃsek','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3460','KÃlfÃldi vÃltÃkÃvetelÃsek','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3510','ImmateriÃlis javakra adott elÅleg','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3520','BeruhÃzÃsokra adott elÅleg','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3530','KÃszletekre adott elÅleg','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3540','OsztalÃk elÅleg','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3550','VPOP ÃFA elszÃmolÃsi szÃmla','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3560','EgyÃb elÅlegek','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3610','MunkavÃllalÃkkal szembeni kÃvetelÃs','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3620','KÃltsÃgvetÃsi kiutÃlÃsi igÃnyek','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3630','KÃltsÃgvetÃsi kiutalÃsi igÃnyek teljesitÃse','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3640','VevÅtÅl kapott elÅleg ÃFÃ-ja','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3661','RÃvid lejÃratra adott pÃnzkÃlcsÃn','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3662','RÃvid lejÃratà betÃtek','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3710','RÃszesedÃs kapcsolt vÃllakozÃsban','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3720','EgyÃb rÃszesedÃs','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3680','EgyÃb kÃvetelÃsek','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3790','ÃrtÃkpapirok ÃrtÃkvesztÃse Ãs visszairÃsa','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3690','EgyÃb kÃvetelÃsek ÃrtÃkvesztÃse Ãs visszairÃsa','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3811','FÅpÃnztÃr','A','A','AR_paid:AP_paid','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3822','USD valutapÃnztÃr','A','A','AR_paid:AP_paid','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3821','EURO valutapÃnztÃr','A','A','AR_paid:AP_paid','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3841','BankszÃmla (Ft)','A','A','AR_paid:AP_paid','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3861','BankszÃmla (EUR)','A','A','AR_paid:AP_paid','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3893','ÃtvezetÃs Bank (HUF) - Bank (EUR)','A','A','AR_paid:AP_paid','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3891','ÃtvezetÃs Bank (HUF) - PÃnztÃr (HUF)','A','A','AR_paid:AP_paid','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3892','ÃtvezetÃs Bank (EUR) - PÃnztÃr (EUR)','A','A','AR_paid:AP_paid','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3894','ÃtvezetÃs PÃnztÃr (HUF) - PÃnztÃr (EUR)','A','A','AR_paid:AP_paid','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3111','BelfÃldi vevÅk','A','A','AR','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3150','BelfÃldi kÃvetelÃsek ÃrtÃkvesztÃse Ãs visszairÃsa','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3161','KÃlfÃldi vevÅk','A','A','AR','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3190','KÃlfÃldi kÃvetelÃsek ÃrtÃkvesztÃse Ãs visszairÃsa','A','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4110','Jegyzett tÅke','A','Q','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4120','TÅketartalÃk','A','Q','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4130','EredmÃnytartalÃk','A','Q','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4140','LekÃtÃtt tartalÃk','A','Q','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4170','ÃrtÃkelÃsi tartalÃk','A','Q','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4190','MÃrleg szerinti eredmÃny','A','Q','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4210','CÃltartalÃkok vÃrhatà kÃtelezettsÃgekre','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4220','CÃltartalÃkok a jÃvÅbeni kÃltsÃgekre','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4230','EgyÃb cÃltartalÃkok','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4421','Hosszà lejÃratra kapott kÃlcsÃnÃk','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4431','BeruhÃzÃsi Ãs fejlesztÃsi hitelek','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4441','EgyÃb hosszà lejÃratà hitel','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4461','TartÃs kÃtelezettsÃg','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4471','TartÃs kÃtelezettsÃg egyÃb vÃllakozÃssal szemben','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4491','EgyÃb hosszà lejÃratà kÃtelezettsÃg','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4511','VevÅktÅl kapott elÅleg','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4541','BelfÃldi szÃllÃtÃk','A','L','AP','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4542','KÃlfÃldi szÃllÃtÃk','A','L','AP','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4551','PÃnzÃgyi lÃzing (Ãven belÃli)','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4561','RÃvid lejÃratà kÃtelezettsÃg','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4571','RÃvid lejÃratà kÃtelezettsÃg egyÃb','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4591','EgyÃb rÃvid lejÃratà kÃtelezettsÃg','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4611','TÃrsasÃgi adÃ','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4619','TÃrsasÃgi adà megfizetÃse','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4621','MunkaviszonybÃl szÃrmazà SZJA','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4629','SZJA befizetÃs','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4631','NyugdÃjbiztosÃtÃs','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4632','EgÃszsÃgbiztosÃtÃs','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4633','MunkaadÃi jÃrulÃk','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4634','MunkavÃllalÃi jÃrulÃk','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4635','SzakkÃpzÃsi hozzÃjÃrulÃs','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4636','RehabilitÃciÃs hozzÃjÃrulÃs','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4637','EHO','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4638','ÃnellenÃrzÃsi, kÃsedelmi pÃtlÃk','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4641','NyugdÃjbiztosÃtÃs teljesitÃse','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4642','EEgÃszsÃgbiztosÃtÃs teljesitÃse','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4643','MunkaadÃi jÃrulÃk teljesitÃse','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4644','MunkavÃllalÃi jÃrulÃk teljesitÃse','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4645','SzakkÃpzÃsi hozzÃjÃrulÃs teljesitÃse','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4646','RehabilitÃciÃs hozzÃjÃrulÃs teljesitÃse','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4647','EHO teljesitÃse','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4648','ÃnellenÃrzÃsi, kÃsedelmi pÃtlÃk teljesitÃse','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4651','VPOP elszÃmolÃsi szÃmla','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4680','ÃFA elszÃmolÃsi szÃmla','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4691','IparÅzÃsi adÃ','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4692','GÃpjÃrmÅadÃ','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4693','KommunÃlis adÃ','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('47101','JÃvedelem elszÃmolÃs januÃr','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('47102','JÃvedelem elszÃmolÃs februÃr','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('47103','JÃvedelem elszÃmolÃs mÃrcius','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('47104','JÃvedelem elszÃmolÃs Ãprilis','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('47105','JÃvedelem elszÃmolÃs mÃjus','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('47106','JÃvedelem elszÃmolÃs jÃnius','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('47107','JÃvedelem elszÃmolÃs jÃlius','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('47108','JÃvedelem elszÃmolÃs augusztus','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('47109','JÃvedelem elszÃmolÃs szeptember','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('47110','JÃvedelem elszÃmolÃs oktÃber','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('47111','JÃvedelem elszÃmolÃs november','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('47112','JÃvedelem elszÃmolÃs december','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4721','Fel nem vett jÃrandÃsÃg','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('47311','NyugdÃjbiztosÃtÃsi Alap kÃtelezettsÃg','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('47319','NyugdÃjbiztosÃtÃsi Alap kÃtelezettsÃg teljesitÃse','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('47321','EgÃszsÃgbiztosÃtÃsi Alap kÃtelezettsÃg','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('47329','EgÃszsÃgbiztosÃtÃsi Alap kÃtelezettsÃg teljesitÃse','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('47331','MagÃnnyugdÃjpÃnztÃr','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4781','OsztalÃk','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4799','Technikai szÃmla','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4810','KÃltsÃgek, rÃforditÃsok passzÃv idÅbeli elhatÃrolÃsa','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4820','ÃrbevÃtelek passzÃv idÅbeli elhatÃrolÃsa','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4830','Halasztott bevÃtelek','A','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4910','NyitÃmÃrleg szÃmla','A','C','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4920','ZÃrà mÃrleg szÃmla','A','C','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4930','AdÃzott eredmÃny elszÃmolÃsi szÃmla','A','C','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5110','AnyagkÃltsÃg','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5120','Energia, szemÃt, kÃzÃzemi dÃj','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5130','Ãzemanyag','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5140','NyomtatvÃnyok, irodaszerek','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5150','TisztÃtÃszer','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5160','SzakkÃnyv, folyÃirat','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5190','EgyÃb anyagkÃltsÃg','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5211','BelfÃldi szÃllÃtÃsi kÃltsÃg','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5212','KÃlfÃldi szÃllÃtÃsi kÃltsÃg','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5221','IrodabÃrleti dÃj','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5241','BelfÃldi utazÃsi kÃltsÃg','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5242','KÃlfÃldi utazÃsi kÃltsÃg','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5251','ReklÃm kÃltsÃg','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5252','HirdetÃs kÃltsÃge','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5261','OktatÃs kÃltsÃge','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5271','Posta kÃltsÃg','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5281','TelefonkÃltsÃg','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5282','Internet kÃltsÃg','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('52901','KÃnyvvezetÃs kÃltsÃge','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('52902','ÃgyvÃdi kÃltsÃg','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5311','IlletÃkek, tagdÃjak','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5321','BankkÃltsÃg','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5331','VagyonbiztosÃtÃs','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5391','FaktordÃj','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5410','BÃrkÃltsÃg (munkavÃllalÃ, tag)','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5420','MegbizÃsi jogviszony kÃltsÃge','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5450','PrÃmium','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5510','ÃtkezÃsi jegy','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5520','ReprezentÃciÃ','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5590','EgyÃb szemÃlyi jellegÅ kifizetÃs','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5611','NyugdÃjbiztosÃtÃsi jÃrulÃk','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5612','EgÃszsÃgbiztosÃtÃsi jÃrulÃk','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5621','TÃteles EHO','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5622','SzÃzalÃkos EHO','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5630','MunkaadÃi jÃrulÃk','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5640','SzakkÃpzÃsi hozzÃjÃrulÃs','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5650','RehabilitÃciÃs hozzÃjÃrulÃs','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5690','EgyÃb bÃrjÃrulÃkok','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5710','Terv szerinti ÃrtÃkcsÃkkenÃsi leirÃs','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5720','KisÃrtÃkÅ eszkÃzÃk ÃrtÃkcsÃkkenÃse','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8110','AnyagkÃltsÃg','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8120','IgÃnybevett szolgÃltatÃs','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8130','Eladott szolgÃltatÃsok ÃrtÃke','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8150','Eladott (kÃzvetitett) szolgÃltatÃs ÃrtÃke','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8611','ÃrtÃkesitett immateriÃlis javak nyilvÃntartÃsi ÃrtÃke','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8612','ÃrtÃkesitett tÃrgyi eszkÃzÃk nyilvÃntartÃsi ÃrtÃke','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8631','kÃsedelmi kamatok','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8641','CÃltartalÃk kÃpzÃse','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8651','KÃvetelÃsek ÃrtÃkvesztÃse','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8652','ImmateriÃlis javak terven felÃli ÃrtÃkcsÃkkenÃse','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8653','TÃrgyi eszkÃzÃk terven felÃli ÃrtÃkcsÃkkenÃse','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8661','IparÅzÃsi adÃ','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8662','GÃpjÃrmÅadÃ','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8663','KommunÃlis adÃ','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8681','Le nem vonhatà ÃFA','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8682','ÃnellenÃrzÃsi pÃtlÃk','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8691','KÃresemÃnyek','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8694','ElÅzÅ Ãvet terhelÅ rÃforditÃsok','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8699','EgyÃb rÃforditÃsok','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8698','KerekitÃsi kÃlÃnbÃzet','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8710','Fizetett osztalÃk, rÃszesedÃs','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8720','RÃszesedÃsek, ÃrtÃkpapirok, bankbetÃtek ÃrtÃkvesztÃse','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8730','Befektett pÃnzÃgyi eszkÃzÃk Ãrfolyam vesztesÃge','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8741','Fizetett kamatok kapcsolt vÃllakozÃsnak','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8742','Fizetett kamatok egyÃb vÃllakozÃsoknak','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8743','PÃnzintÃzetnek fizetett kamatok','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8744','MagÃnszemÃlyeknek fizetett kamatok','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8761','Deviza Ãs valutakÃszletek ÃtvÃltÃsi ÃrfolyamvesztesÃge','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8762','KÃvetelÃsek Ãs kÃtelezettsÃgek ÃrfolyamvesztesÃge','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8791','FaktordÃj','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8820','TÃrsasÃgba bevitt vagyontÃrgyak nyilvÃntartÃs szerinti ÃrtÃke','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8830','VÃglegesen Ãtadott pÃnzeszkÃz','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8840','Elengedett kÃvetelÃs','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8890','EgyÃb rendkÃvÃli rÃforditÃsok','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8910','TÃrsasÃgi adÃ','A','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8140','ELÃBÃ','A','E','IC_cogs','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9611','ÃrtÃkesitett immateriÃlis javak bevÃtele','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9612','ÃrtÃkesitett tÃrgyi eszkÃzÃk bevÃtele','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9631','Kapott kÃsedelmi kamatok','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9641','CÃltartalÃk kÃpzÃse','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9651','KÃvetelÃsek ÃrtÃkvesztÃsÃnek visszairÃsa','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9652','ImmateriÃlis javak terven felÃli ÃrtÃkcsÃkkenÃsÃnek visszairÃsa','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9653','TÃrgyi eszkÃzÃk terven felÃli ÃrÃtkcsÃkkenÃsÃnek visszairÃsa','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9691','KÃresemÃnyek bevÃtelei','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9698','KerekÃtÃsi kÃlÃnbÃzet','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9699','EgyÃb bevÃtelek','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9710','Kapott osztalÃk, rÃszesedÃs','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9720','RÃszesedÃsek, ÃrtÃkpapirok, bankbetÃtek ÃrtÃkvesztÃsÃnek visszairÃsa','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9730','Befektetett pÃnzÃgyi eszkÃzÃk Ãrfolyam nyeresÃge','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9741','Kapott kamatok kapcsolt vÃllalkozÃstÃl','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9742','Kapott kamatok egyÃb vÃllakozÃstÃl','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9743','Kapott kamatok pÃnzintÃzettÅl','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9744','MagÃnszemÃlytÅl kapott kamatok','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9761','Deviza Ãs valutakÃszlet ÃtvÃltÃsi ÃrfolyamnyeresÃge','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9762','KÃvetelÃsek Ãs kÃtelezettsÃgek ÃrfolyamnyeresÃge','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9791','EgyÃb pÃnzÃgyi bevÃtelek','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9810','EllenÃrtÃk nÃlkÃl kapott eszkÃzÃk ÃrtÃke','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9820','TÃrsasÃgba bevitt vagyontÃrgyak szerzÅdÃs szerinti ÃrtÃke','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9830','VÃglegesen kapott pÃnzeszkÃz','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9840','Elengedett kÃtelezettsÃg','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9890','EgyÃb rendkÃvÃli bevÃtelek','A','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('52903','TanÃcsadÃs','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1611','Befejezetlen beruhÃzÃs','A','A','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3862','Deviza betÃtszÃmla USD','A','A','AR_paid:AP_paid','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3895','ÃtvezetÃs Bank (HUF) - Bank (USD)','A','A','AR_paid:AP_paid','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9112','BelfÃldi szolgÃltatÃs ÃrbevÃtele','A','I','AR_amount:IC_income','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9111','BelfÃldi termÃkÃrtÃkesÃtÃs ÃrbevÃtele','A','I','AR_amount:IC_sale','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9312','Export szolgÃltatÃs ÃrbevÃtele','A','I','AR_amount:IC_income','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5299','EgyÃb igÃnybevett szolgÃltatÃs','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2690','Uton levo keszlet','A','A','IC','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2610','Ãruk beszerzÃsi Ãron','A','A','IC','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('52904','VÃmÃgyintÃzÃs','A','E','AP_amount','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3896','BankkÃrtya ÃtvezetÃs','A','A','AR_paid:AP_paid','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9311','Export termekÃrtÃkesÃtÃs ÃrbevÃtele','A','I','AR_amount:IC_sale:IC_income','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1','BEFEKTETETT ESZKÃZÃK','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3','KÃVETELÃSEK','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8','RÃFORDÃTÃSOK','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9','BEVÃTELEK','H','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4','FORRÃSOK','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5','KÃLTSÃGNEMEK','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('11','ImmateriÃlis javak','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('12','Ingatlanok','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('13','MÅszaki gÃpek, berendezÃsek, jÃrmÅvek','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('14','EgyÃb gÃpek, berendezÃsek, jÃrmÅvek','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('15','BeruhÃzÃsok','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('114','Szellemi termÃkek','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('117','ImmateriÃlis javak ÃrtÃkhelyesbÃtÃse','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('118','ImmateriÃlis javak terven felÃli ÃrtÃkcsÃkkenÃse','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('119','ImmateriÃlis javak ÃrtÃkcsÃkkenÃse','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('131','TermelÅ gÃpek, berendezÃsek','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('132','JÃrmÅvek','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('139','MÃszeki gÃpek, berendezÃsek, jÃrmÅvek ÃrtÃkcsÃkkenÃse','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('137','MÅszaki gÃpek, berendezÃsek jÃrmÅvek ÃrtÃkhelyesbÃtÃse','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('138','MÅszaki gÃpek, berendezÃsek, jÃrmÅvek terven felÃli ÃrtÃkcsÃkkenÃse','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('141','EgyÃb gÃp, berendezÃs, szerszÃm','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('142','EgyÃb jÃrmÅvek','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('143','Irodai, igazgatÃsi berendezÃs, felszerelÃs','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('145','KisÃrtÃkÅ tÃrgyi eszkÃz','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('147','EgyÃb gÃpek, berendezÃsek, jÃrmÅvek ÃrtÃkhelyesbÃtÃse','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('149','EgyÃb gÃpek, berendezÃsek, jÃrmÅvek elszÃmolt ÃrtÃkcsÃkkenÃse','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('148','EgyÃb gÃpek, berendezÃsek, jÃrmÅvek terven felÃli ÃrtÃkcsÃkkenÃse','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('161','Befejezetlen beruhÃzÃsok','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('21','Anyagok','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('26','Kereskedelmi Ãruk','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('31','KÃvetelÃsek ÃruszÃllÃtÃsbÃl, szolgÃltatÃsbÃl','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('32','KÃvetelÃsek kapcsolt vÃllakozÃssal szemben','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('33','KÃvetelÃsek egyÃb rÃszesedÃsi viszonyban lÃvÅ vÃllalkozÃssal szemben','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('34','VÃltÃkÃvetelÃsek','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('35','Adott elÅlegek','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('36','EgyÃb kÃvetelÃsek','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('37','ÃrtÃkpapirok','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('38','PÃnzeszkÃzÃk','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('39','Aktiv idÅbeli elhatÃrolÃsok','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('321','KÃvetelÃsek','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('325','Jegyzett de be nem fizetett tÅke','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('329','KÃvetelÃsek ÃrtÃkvesztÃse','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('331','KÃvetelÃsek egyÃb rÃszesedÃsi viszonyban lÃvÅ vÃllalattal szemben','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('332','Jegyzett, de mÃg be nem fizetett tÅke egyÃb rÃszesedÃsi viszonyban lÃvÅ vÃllalkozÃstÃl','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('339','EgyÃb rÃszesedÃsi viszonyban lÃvÅ vÃllakozÃssal szembeni kÃvetelÃs ÃrtÃkvesztÃse','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('366','RÃvid lejÃratra adott pÃnzkÃlcsÃnÃk','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('381','PÃnztÃrak','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('382','ValutapÃnztÃrak','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('384','ElszÃmolÃsi betÃtszÃmlÃk (Ft)','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('386','Deviza betÃtszÃmlÃk','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('389','ÃtvezetÃsi szÃmlÃk','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('311','BelfÃldi vevÅk','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('316','KÃlfÃldi vevÅk','H','A','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('41','SajÃt tÅke','H','Q','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('42','CÃltartalÃkok','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('43','HÃtrasorolt kÃtelezettsÃgek','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('44','Hosszà lejÃratà kÃtelezettsÃgek','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('442','Hosszà lejÃratra kapott kÃlcsÃnÃk','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('443','BeruhÃzÃsi fejlesztÃsi hitelek','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('444','EgyÃb hosszà lejÃratà hitelek','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('447','TartÃs kÃtelezettsÃg egyÃb vÃllalkozÃssal szemben','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('446','TartÃs kÃtelezettsÃg kapcsolt vÃllalkozÃssal szemben','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('449','EgyÃb hosszà lejÃratà kÃtelezettsÃg','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('45','RÃvid lejÃratà kÃtelezettsÃgek','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('451','VevÅktÅl kapott elÅlegek','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('452','RÃvid lejÃratà kÃlcsÃnÃk','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('453','RÃvid lejÃratà hitelek','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('455','PÃnzÃgyi lÃzing miatti kÃtelezettsÃg','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('456','RÃvid lejÃratà kÃtelezettsÃg kapcsolt vÃllalkozÃssal szemben','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('457','RÃvid lejÃratà kÃtelezettsÃg egyÃb vÃllakozÃssal szemben','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('459','EgyÃb rÃvid lejÃratà kÃtelezettsÃg','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('46','AdÃhatÃsÃggal szembeni kÃtelezettsÃgek','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('461','TÃrsasÃgi adà elszÃmolÃsa','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('462','SZJA elszÃmolÃs','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('463','KÃltsÃgvetÃsi befizetÃsi kÃtelezettsÃg','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('464','KÃltsÃgvetÃsi befizetÃsi kÃtelezettsÃg teljesitÃse','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('465','VPOP elszÃmolÃsi szÃmla','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('466','ElÅzetesen felszÃmÃtottt ÃFA','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('467','FizetendÅ ÃFA','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('469','Helyi adÃk elszÃmolÃsi szÃmla','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('47','EgyÃb kÃtelezettsÃgek','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('471','JÃvedelem elszÃmolÃsi szÃmla','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('472','Fel nem vett jÃrandÃsÃg','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('473','NyugdÃj- Ãs egÃszsÃgbiztosÃtÃs','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4731','NyugdÃjbiztosÃtÃsi Alap','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4732','EgÃszsÃgbiztosÃtÃsi Alap','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4733','MagÃnnyugdÃjpÃnztÃr','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('478','OsztalÃkelszÃmolÃsi szÃmla','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('479','EgyÃb rÃvid lejÃratà kÃtelezettsÃg','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('48','PasszÃv idÅbeli elhatÃrolÃsok','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('49','Ãvi mÃrlegszÃmlÃk','H','C','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('51','AnyagjellegÅ kÃltsÃgek','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('52','IgÃnybevett szolgÃltatÃsok kÃltsÃgei','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('521','SzÃllÃtÃsi, rakodÃsi kÃltsÃg','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('524','UtazÃsi Ãs szÃllÃs kÃltsÃg','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('525','HirdetÃs Ãs reklÃm kÃltsÃg','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('526','OktatÃs, tovÃbbkÃpzÃs kÃltsÃge','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('527','Posta kÃltsÃg','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('528','KommunikÃciÃs kÃltsÃgek','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('529','EgyÃb igÃnybevett szolgÃltatÃsok','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('53','EgyÃb szolgÃltatÃsok kÃltsÃgei','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('531','HatÃsÃgi, igazgatÃsi, szolg. illetÃk','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('532','BankkÃltsÃg','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('533','BiztosÃtÃsi dÃjak','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('539','EgyÃb szolgÃltatÃsok ','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('54','BÃrkÃltsÃg','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('55','SzemÃlyi jellegÅ egyÃb kifizetÃs','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('56','BÃrjÃrulÃkok','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('561','NyugdÃj Ãs egÃszsÃgbiztosÃtÃs','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('562','EHO','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('57','ÃrtÃkcsÃkkenÃsi leirÃs','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('81','AnyagjellegÅ rÃforditÃsok','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('86','EgyÃb rÃforditÃsok','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('861','ÃrtÃkesitett eszkÃzÃk nyilvÃntartÃsi ÃrtÃke','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('863','EgyÃb eredmÃnyt csÃkkentÅ tÃtelek','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('864','CÃltartalÃk kÃpzÃse','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('865','ÃrtÃkvesztÃs, terven felÃli ÃrtÃkcsÃkkenÃs','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('866','ÃnkormÃnyzatokkal elszÃmolt adÃk, illetÃkek','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('868','Ãllami kÃltsÃgvetÃssel elszÃmolt adÃk','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('869','KÃlÃnfÃle egyÃb rÃforditÃsok','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('87','PÃnzÃgyi mÅveletek rÃforditÃsai','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('874','FizetendÅ kamatok Ãs kamatjellegÅ rÃforditÃsok','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('876','ÃtvÃltÃskori Ãs ÃrtÃkesitÃskori ÃrfolyamvesztesÃgek','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('879','EgyÃb pÃnzÃgyi rÃforditÃsok','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('88','RendkivÃli rÃforditÃsok','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('881','TÃritÃs nÃlkÃl Ãtadott eszkÃzÃk nyilvÃntartÃsi ÃrtÃke','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('89','NyeresÃget terhelÅ adÃk','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('91','ÃrtÃkesitÃs ÃrbevÃtele','H','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('911','BelfÃldi ÃrtÃkesitÃs ÃrbevÃtele','H','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('93','Export ÃrtÃkesitÃs ÃrbevÃtele','H','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('96','EgyÃb bevÃtelek','H','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('961','ÃrtÃkesitett eszkÃzÃk bevÃtele','H','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('963','EgyÃb eredmÃnyt nÃvelÅ tÃtelek','H','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('964','CÃltartalÃk kÃpzÃse','H','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('965','ÃrtÃkvesztÃs, terven felÃli ÃrÃtkcsÃkkenÃs visszairÃsa','H','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('969','KÃlÃnfÃle egyÃb bevÃtelek','H','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('97','PÃnzÃgyi bevÃtelek','H','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('974','Kapott kamatok Ãs kamatjellegÅ rÃforditÃsok','H','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('976','ÃtvÃltÃskori Ãs ÃrtÃkesitÃskori ÃrfolyamnyeresÃg','H','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('979','EgyÃb pÃnzÃgyi bevÃtelek','H','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('98','RendkivÃli bevÃtelek','H','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('454','KÃtelezettsÃgek ÃruszÃllÃtÃsbÃl Ãs szolgÃltatÃs nyÃjtÃsÃbÃl','H','L','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('522','BÃrleti dÃjak','H','E','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('931','Export ÃrtÃkesitÃs ÃrbevÃtele','H','I','','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4661','ElÅzetesen felszÃmÃtottt ÃFA 20%','A','L','AP_tax:IC_taxpart:IC_taxservice:CT_tax','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4662','ElÅzetesen felszÃmÃtottt ÃFA 5%','A','L','AP_tax:IC_taxpart:IC_taxservice:CT_tax','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4663','ElÅzetesen felszÃmÃtottt ÃFA 0%','A','L','AP_tax:IC_taxpart:IC_taxservice:CT_tax','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4664','ElÅzetesen felszÃmÃtottt ÃFA adÃmentes','A','L','AP_tax:IC_taxpart:IC_taxservice:CT_tax','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4671','FizetendÅ ÃFA 20%','A','L','AR_tax:IC_taxpart:IC_taxservice:CT_tax','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4672','FizetendÅ ÃFA 5%','A','L','AR_tax:IC_taxpart:IC_taxservice:CT_tax','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4673','FizetendÅ ÃFA 0%','A','L','AR_tax:IC_taxpart:IC_taxservice:CT_tax','');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4674','FizetendÅ ÃFA adÃmentes','A','L','AR_tax:IC_taxpart:IC_taxservice','');
+
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4661'),'0.20','VIS');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4662'),'0.05','VIS');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4663'),'0','VIS');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4664'),'0','VIS');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4671'),'0.20','FIZ');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4672'),'0.05','FIZ');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4673'),'0','FIZ');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4674'),'0','FIZ');
+--
+INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id',
+(SELECT id FROM chart WHERE accno = '2110'));
+
+INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '9111'));
+INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '8140'));
+INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE accno = '9761'));
+INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE accno = '8761'));
+INSERT INTO defaults (setting_key, value) VALUES ('curr', 'HUF:EUR:USD');
+INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+UPDATE defaults SET value = 'VK00000' WHERE setting_key = 'glnumber';
+UPDATE defaults SET value = 'VSZ10000' WHERE setting_key = 'sinumber';
+UPDATE defaults SET value = 'SZSZ10000' WHERE setting_key = 'vinumber';
+UPDATE defaults SET value = 'BR10000' WHERE setting_key = 'ponumber';
+UPDATE defaults SET value = 'VR10000' WHERE setting_key = 'sonumber';
+UPDATE defaults SET value = 'AA10000' WHERE setting_key = 'sqnumber';
+UPDATE defaults SET value = 'AK10000' WHERE setting_key = 'rfqnumber';
+UPDATE defaults SET value = 'ALK0000' WHERE setting_key = 'employeenumber';
+UPDATE defaults SET value = 'VEVO10000' WHERE setting_key = 'customernumber';
+UPDATE defaults SET value = 'SZALL10000' WHERE setting_key = 'vendornumber';
+UPDATE defaults SET value = 'PROJ10000' WHERE setting_key = 'projectnumber';
+
+commit;
Added: trunk/sql/coa/hu/chart/Default.sql
===================================================================
--- trunk/sql/coa/hu/chart/Default.sql (rev 0)
+++ trunk/sql/coa/hu/chart/Default.sql 2007-12-30 04:51:02 UTC (rev 2021)
@@ -0,0 +1,70 @@
+begin;
+--Hungarian chart of accounts
+-- Magyar fÃkÃnyvi szÃmlÃk, amelyek csak pÃldakÃnt szolgÃlnak
+--
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1140','Irodai eszkÃzÃk','A','A','','114');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1199','Irodai eszkÃzÃk ÃCS','A','A','','119');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2610','Ãruk ','A','A','IC','261');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3110','VevÃk','A','A','AR','311');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3111','KÃlfÃldi vevÃk','A','A','AR','311');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3810','PÃnztÃr 1','A','A','AR_paid:AP_paid','381');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3811','PÃnztÃr 2','A','A','AR_paid:AP_paid','381');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3840','Bank 1','A','A','AR_paid:AP_paid','384');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3841','Bank 2','A','A','AR_paid:AP_paid','384');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4540','BelfÃldi SzÃllÃtÃk','A','L','AP','454');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4541','KÃlfÃldi szÃllÃtÃk','A','L','AP','454');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4660','VisszaigÃnyelhetà ÃFA 20%','A','L','AP_tax:IC_taxpart:IC_taxservice','466');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4661','VisszaigÃnyelhetà ÃFA 12%','A','L','AP_tax:IC_taxpart:IC_taxservice','466');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4662','VisszaigÃnyelhetà ÃFA 5%','A','L','AP_tax:IC_taxpart:IC_taxservice','466');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4663','VisszaigÃnyelhetà ÃFA adÃmentes','A','L','AP_tax:IC_taxpart:IC_taxservice','466');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4670','Fizetendà ÃFA 20%','A','L','AR_tax:IC_taxpart:IC_taxservice','467');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4671','Fizetendà ÃFA 15%','A','L','AR_tax:IC_taxpart:IC_taxservice','467');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4672','Fizetendà ÃFA 5%','A','L','AR_tax:IC_taxpart:IC_taxservice','467');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4673','Fizetendà ÃFA adÃmentes','A','L','AR_tax:IC_taxpart:IC_taxservice','467');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5200','BÃrleti dÃj','A','E','AP_amount','520');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5210','Telefon','A','E','AP_amount','521');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5990','KÃltsÃgek','A','E','IC_expense','599');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8140','Eladott Ãruk beszerzÃsi ÃrtÃke','A','E','IC_cogs','814');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8700','ÃrfolyamvesztesÃg','A','E','','870');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9110','BelfÃldi ÃrbevÃtel','A','I','AR_amount:IC_sale:IC_income','911');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9111','KÃlfÃldi ÃrbevÃtel','A','I','AR_amount:IC_sale:IC_income','911');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9700','ÃrfolyamnyeresÃg','A','I','','970');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1','BEFEKTETETT ESZKÃZÃK','H','A','','1');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2','KÃSZLETEK','H','A','','2');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3','KÃVETELÃSEK','H','A','','3');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4','KÃTELEZETTSÃGEK','H','L','','4');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5','KÃLTSÃGEK','H','E','','5');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8','RÃFORDÃTÃSOK','H','E','','8');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9','BEVÃTELEK','H','I','','9');
+--
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4660'),'0.20','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4661'),'0.15','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4662'),'0.05','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4663'),'0','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4670'),'0.20','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4671'),'0.15','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4672'),'0.05','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4673'),'0','');
+--
+INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id',
+(SELECT id FROM chart WHERE accno = '2110'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '9110'));
+ INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '8140'));
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE accno = '9700'));
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE accno = '8700'));
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'HUF:EUR:USD');
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+ UPDATE defaults SET value = 'VK00000' WHERE setting_key = 'glnumber';
+ UPDATE defaults SET value = 'VSZ10000' WHERE setting_key = 'sinumber';
+ UPDATE defaults SET value = 'SZSZ10000' WHERE setting_key = 'vinumber';
+ UPDATE defaults SET value = 'BR10000' WHERE setting_key = 'ponumber';
+ UPDATE defaults SET value = 'VR10000' WHERE setting_key = 'sonumber';
+ UPDATE defaults SET value = 'AA10000' WHERE setting_key = 'sqnumber';
+ UPDATE defaults SET value = 'AK10000' WHERE setting_key = 'rfqnumber';
+ UPDATE defaults SET value = 'ALK0000' WHERE setting_key = 'employeenumber';
+ UPDATE defaults SET value = 'VEVO10000' WHERE setting_key = 'customernumber';
+ UPDATE defaults SET value = 'SZALL10000' WHERE setting_key = 'vendornumber';
+ UPDATE defaults SET value = 'PROJ10000' WHERE setting_key = 'projectnumber';
+
+commit;
Deleted: trunk/sql/coa/hu/chart/General.sql
===================================================================
--- trunk/sql/coa/hu/chart/General.sql 2007-12-29 23:23:49 UTC (rev 2020)
+++ trunk/sql/coa/hu/chart/General.sql 2007-12-30 04:51:02 UTC (rev 2021)
@@ -1,63 +0,0 @@
-begin;
---Hungarian chart of accounts
--- Magyar fÃkÃnyvi szÃmlÃk, amelyek csak pÃldakÃnt szolgÃlnak
---
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1140','Irodai eszkÃzÃk','A','A','','114');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1199','Irodai eszkÃzÃk ÃCS','A','A','','119');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2610','Ãruk ','A','A','IC','261');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3110','VevÃk','A','A','AR','311');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3111','KÃlfÃldi vevÃk','A','A','AR','311');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3810','PÃnztÃr 1','A','A','AR_paid:AP_paid','381');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3811','PÃnztÃr 2','A','A','AR_paid:AP_paid','381');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3840','Bank 1','A','A','AR_paid:AP_paid','384');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3841','Bank 2','A','A','AR_paid:AP_paid','384');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4540','BelfÃldi SzÃllÃtÃk','A','L','AP','454');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4541','KÃlfÃldi szÃllÃtÃk','A','L','AP','454');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4660','VisszaigÃnyelhetà ÃFA 25%','A','L','AP_tax:IC_taxpart:IC_taxservice','466');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4661','VisszaigÃnyelhetà ÃFA 12%','A','L','AP_tax:IC_taxpart:IC_taxservice','466');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4662','VisszaigÃnyelhetà ÃFA 5%','A','L','AP_tax:IC_taxpart:IC_taxservice','466');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4663','VisszaigÃnyelhetà ÃFA adÃmentes','A','L','AP_tax:IC_taxpart:IC_taxservice','466');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4670','Fizetendà ÃFA 25%','A','L','AR_tax:IC_taxpart:IC_taxservice','467');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4671','Fizetendà ÃFA 15%','A','L','AR_tax:IC_taxpart:IC_taxservice','467');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4672','Fizetendà ÃFA 5%','A','L','AR_tax:IC_taxpart:IC_taxservice','467');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4673','Fizetendà ÃFA adÃmentes','A','L','AR_tax:IC_taxpart:IC_taxservice','467');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5200','BÃrleti dÃj','A','E','AP_amount','520');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5210','Telefon','A','E','AP_amount','521');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5990','KÃltsÃgek','A','E','IC_expense','599');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8140','Eladott Ãruk beszerzÃsi ÃrtÃke','A','E','IC_cogs','814');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8700','ÃrfolyamvesztesÃg','A','E','','870');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9110','BelfÃldi ÃrbevÃtel','A','I','AR_amount:IC_sale:IC_income','911');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9111','KÃlfÃldi ÃrbevÃtel','A','I','AR_amount:IC_sale:IC_income','911');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9700','ÃrfolyamnyeresÃg','A','I','','970');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1','BEFEKTETETT ESZKÃZÃK','H','A','','1');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2','KÃSZLETEK','H','A','','2');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3','KÃVETELÃSEK','H','A','','3');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4','KÃTELEZETTSÃGEK','H','L','','4');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5','KÃLTSÃGEK','H','E','','5');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8','RÃFORDÃTÃSOK','H','E','','8');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9','BEVÃTELEK','H','I','','9');
---
-INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4660'),'0.25','');
-INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4661'),'0.15','');
-INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4662'),'0.05','');
-INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4663'),'0','');
-INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4670'),'0.25','');
-INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4671'),'0.15','');
-INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4672'),'0.05','');
-INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4673'),'0','');
---
-INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id',
-(SELECT id FROM chart WHERE accno = '2110'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '9110'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '8140'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE accno = '9700'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE accno = '8700'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('curr', 'HUF:EUR:USD');
-
- INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
-commit;
Added: trunk/sql/coa/hu/chart/Old-general.sql
===================================================================
--- trunk/sql/coa/hu/chart/Old-general.sql (rev 0)
+++ trunk/sql/coa/hu/chart/Old-general.sql 2007-12-30 04:51:02 UTC (rev 2021)
@@ -0,0 +1,63 @@
+begin;
+--Hungarian chart of accounts
+-- Magyar fÃkÃnyvi szÃmlÃk, amelyek csak pÃldakÃnt szolgÃlnak
+--
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1140','Irodai eszkÃzÃk','A','A','','114');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1199','Irodai eszkÃzÃk ÃCS','A','A','','119');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2610','Ãruk ','A','A','IC','261');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3110','VevÃk','A','A','AR','311');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3111','KÃlfÃldi vevÃk','A','A','AR','311');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3810','PÃnztÃr 1','A','A','AR_paid:AP_paid','381');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3811','PÃnztÃr 2','A','A','AR_paid:AP_paid','381');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3840','Bank 1','A','A','AR_paid:AP_paid','384');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3841','Bank 2','A','A','AR_paid:AP_paid','384');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4540','BelfÃldi SzÃllÃtÃk','A','L','AP','454');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4541','KÃlfÃldi szÃllÃtÃk','A','L','AP','454');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4660','VisszaigÃnyelhetà ÃFA 25%','A','L','AP_tax:IC_taxpart:IC_taxservice','466');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4661','VisszaigÃnyelhetà ÃFA 12%','A','L','AP_tax:IC_taxpart:IC_taxservice','466');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4662','VisszaigÃnyelhetà ÃFA 5%','A','L','AP_tax:IC_taxpart:IC_taxservice','466');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4663','VisszaigÃnyelhetà ÃFA adÃmentes','A','L','AP_tax:IC_taxpart:IC_taxservice','466');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4670','Fizetendà ÃFA 25%','A','L','AR_tax:IC_taxpart:IC_taxservice','467');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4671','Fizetendà ÃFA 15%','A','L','AR_tax:IC_taxpart:IC_taxservice','467');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4672','Fizetendà ÃFA 5%','A','L','AR_tax:IC_taxpart:IC_taxservice','467');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4673','Fizetendà ÃFA adÃmentes','A','L','AR_tax:IC_taxpart:IC_taxservice','467');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5200','BÃrleti dÃj','A','E','AP_amount','520');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5210','Telefon','A','E','AP_amount','521');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5990','KÃltsÃgek','A','E','IC_expense','599');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8140','Eladott Ãruk beszerzÃsi ÃrtÃke','A','E','IC_cogs','814');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8700','ÃrfolyamvesztesÃg','A','E','','870');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9110','BelfÃldi ÃrbevÃtel','A','I','AR_amount:IC_sale:IC_income','911');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9111','KÃlfÃldi ÃrbevÃtel','A','I','AR_amount:IC_sale:IC_income','911');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9700','ÃrfolyamnyeresÃg','A','I','','970');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1','BEFEKTETETT ESZKÃZÃK','H','A','','1');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2','KÃSZLETEK','H','A','','2');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3','KÃVETELÃSEK','H','A','','3');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4','KÃTELEZETTSÃGEK','H','L','','4');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5','KÃLTSÃGEK','H','E','','5');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8','RÃFORDÃTÃSOK','H','E','','8');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9','BEVÃTELEK','H','I','','9');
+--
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4660'),'0.25','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4661'),'0.15','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4662'),'0.05','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4663'),'0','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4670'),'0.25','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4671'),'0.15','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4672'),'0.05','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4673'),'0','');
+--
+INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id',
+(SELECT id FROM chart WHERE accno = '2110'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '9110'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '8140'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE accno = '9700'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE accno = '8700'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'HUF:EUR:USD');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+commit;
Property changes on: trunk/sql/coa/hu/chart/Old-general.sql
___________________________________________________________________
Name: svn:executable
+ *
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.