SF.net SVN: ledger-smb:[6069] branches/1.3/sql/coa/hu/chart/Extended.sql

[..hidden..]

Revision: 6069
          http://sourceforge.net/p/ledger-smb/code/6069
Author:   pongracz
Date:     2013-09-20 12:08:32 +0000 (Fri, 20 Sep 2013)
Log Message:
-----------
Small modifications in the Hungarian COA: new VAT rates: 18% , 5%; link some accounts to the relevant form.

Modified Paths:
--------------
    branches/1.3/sql/coa/hu/chart/Extended.sql

Property Changed:
----------------
    branches/1.3/sql/coa/hu/chart/Extended.sql

Modified: branches/1.3/sql/coa/hu/chart/Extended.sql
===================================================================
--- branches/1.3/sql/coa/hu/chart/Extended.sql	2013-09-20 10:43:22 UTC (rev 6068)
+++ branches/1.3/sql/coa/hu/chart/Extended.sql	2013-09-20 12:08:32 UTC (rev 6069)
@@ -46,10 +46,10 @@
 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_save(NULL, '1491', 'EgyÃb gÃp, berendezÃs, szerszÃm elszÃmolt ÃrtÃkcsÃkkenÃse', 'A', '', NULL, false, false, string_to_array('Asset_Dep', ':'));
+SELECT account_save(NULL, '1492', 'EgyÃb jÃrmÅvek elszÃmolt ÃrtÃkcsÃkkenÃse', 'A', '', NULL, false, false, string_to_array('Asset_Dep', ':'));
+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('Asset_Dep', ':'));
+SELECT account_save(NULL, '1495', 'Kis ÃrtÃkÅ tÃrgyi eszkÃzÃk ÃrtÃkcsÃkkenÃse', 'A', '', NULL, false, false, string_to_array('Asset_Dep', ':'));
 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', ':'));
@@ -214,10 +214,14 @@
 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_save(NULL, '4663', 'ElÅzetesen felszÃmÃtott ÃFA 18%', 'L', '', NULL, false, false, string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL, '4664', 'ElÅzetesen felszÃmÃtott ÃFA 5%', '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, '4673', 'FizetendÅ ÃFA 18%', 'L', '', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL, '4674', 'FizetendÅ ÃFA 5%', '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('', ':'));
@@ -447,9 +451,13 @@
 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 = '4663'),0.18);
+INSERT INTO tax (chart_id,rate) VALUES ((SELECT id FROM chart WHERE accno = '4664'),0.05);
 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 tax (chart_id,rate) VALUES ((SELECT id FROM chart WHERE accno = '4673'),0.18);
+INSERT INTO tax (chart_id,rate) VALUES ((SELECT id FROM chart WHERE accno = '4674'),0.05);
 
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '2610')); 


Property changes on: branches/1.3/sql/coa/hu/chart/Extended.sql
___________________________________________________________________
Modified: svn:text-time
## -1 +1 ##
-2013-08-29T16:53:50.066478Z
+2013-09-03T15:38:01.000000Z
\ No newline at end of property
Modified: svn:unix-mode
## -1 +1 ##
-0775
+0770
\ No newline at end of property
Modified: svn:owner
## -1 +1 ##
-0 root
+33 www-data
\ No newline at end of property
Modified: svn:group
## -1 +1 ##
-0 root
+33 www-data
\ No newline at end of property
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.


------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. 
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits