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