SF.net SVN: ledger-smb:[3404] trunk/sql/coa

[..hidden..]

Revision: 3404
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3404&view=rev
Author:   einhverfr
Date:     2011-07-01 10:46:25 +0000 (Fri, 01 Jul 2011)

Log Message:
-----------
hu and pl charts now load

Modified Paths:
--------------
    trunk/sql/coa/hu/chart/Complete.sql
    trunk/sql/coa/pl/chart/General.sql

Modified: trunk/sql/coa/hu/chart/Complete.sql
===================================================================
--- trunk/sql/coa/hu/chart/Complete.sql	2011-07-01 10:38:52 UTC (rev 3403)
+++ trunk/sql/coa/hu/chart/Complete.sql	2011-07-01 10:46:25 UTC (rev 3404)
@@ -396,21 +396,21 @@
 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,'3895','ÃtvezetÃs Bank (HUF) - Bank (USD)','','A', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
 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_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,'9111','BelfÃldi termÃkÃrtÃkesÃtÃs ÃrbevÃtele','','I', NULL, false, false, string_to_array('AR_amount', ':'));
 SELECT account_save(NULL,'9312','Export szolgÃltatÃs ÃrbevÃtele','','I', NULL, false, false, string_to_array('AR_amount:IC_income', ':'));
 SELECT account_save(NULL,'5299','EgyÃb igÃnybevett szolgÃltatÃs','','E', NULL, false, false, string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'2690','Uton levo keszlet','','A', NULL, false, false, string_to_array('IC', ':'));
 SELECT account_save(NULL,'2610','Ãruk beszerzÃsi Ãron','','A', NULL, false, false, string_to_array('IC', ':'));
 SELECT account_save(NULL,'52904','VÃmÃgyintÃzÃs','','E', NULL, false, false, string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'3896','BankkÃrtya ÃtvezetÃs','','A', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'9311','Export termekÃrtÃkesÃtÃs ÃrbevÃtele','','I', NULL, false, false, string_to_array('AR_amount:IC_sale:IC_income', ':'));
-SELECT account_save(NULL,'4661','ElÅzetesen felszÃmÃtottt ÃFA 20%','','L', NULL, false, false, string_to_array('AP_tax:IC_taxpart:IC_taxservice:CT_tax', ':'));
-SELECT account_save(NULL,'4662','ElÅzetesen felszÃmÃtottt ÃFA 5%','','L', NULL, false, false, string_to_array('AP_tax:IC_taxpart:IC_taxservice:CT_tax', ':'));
-SELECT account_save(NULL,'4663','ElÅzetesen felszÃmÃtottt ÃFA 0%','','L', NULL, false, false, string_to_array('AP_tax:IC_taxpart:IC_taxservice:CT_tax', ':'));
-SELECT account_save(NULL,'4664','ElÅzetesen felszÃmÃtottt ÃFA adÃmentes','','L', NULL, false, false, string_to_array('AP_tax:IC_taxpart:IC_taxservice:CT_tax', ':'));
-SELECT account_save(NULL,'4671','FizetendÅ ÃFA 20%','','L', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice:CT_tax', ':'));
-SELECT account_save(NULL,'4672','FizetendÅ ÃFA 5%','','L', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice:CT_tax', ':'));
-SELECT account_save(NULL,'4673','FizetendÅ ÃFA 0%','','L', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice:CT_tax', ':'));
+SELECT account_save(NULL,'9311','Export termekÃrtÃkesÃtÃs ÃrbevÃtele','','I', NULL, false, false, string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'4661','ElÅzetesen felszÃmÃtottt ÃFA 20%','','L', NULL, false, false, string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'4662','ElÅzetesen felszÃmÃtottt ÃFA 5%','','L', NULL, false, false, string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'4663','ElÅzetesen felszÃmÃtottt ÃFA 0%','','L', NULL, false, false, string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'4664','ElÅzetesen felszÃmÃtottt ÃFA adÃmentes','','L', NULL, false, false, string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'4671','FizetendÅ ÃFA 20%','','L', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'4672','FizetendÅ ÃFA 5%','','L', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'4673','FizetendÅ ÃFA 0%','','L', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
 SELECT account_save(NULL,'4674','FizetendÅ ÃFA adÃmentes','','L', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
 
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4661'),'0.20','VIS');

Modified: trunk/sql/coa/pl/chart/General.sql
===================================================================
--- trunk/sql/coa/pl/chart/General.sql	2011-07-01 10:38:52 UTC (rev 3403)
+++ trunk/sql/coa/pl/chart/General.sql	2011-07-01 10:46:25 UTC (rev 3404)
@@ -103,7 +103,7 @@
 SELECT account_save(NULL,'222020000','ZobowiÂzania wobec pozostaÂych jednostek','L','', NULL, false, false, string_to_array('AP', ':'));
 SELECT account_save(NULL,'222020100','Kredyty i poÂyczki','L','', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'222020200','ZobowiÂzania z tytuÂu emisji dÂuÂnych papierÃw wartoÂciowych','L','', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'222020300','Inne zobowiÂzania finasowe','L','', NULL, false, false, string_to_array('AP_Amount', ':'));
+SELECT account_save(NULL,'222020300','Inne zobowiÂzania finasowe','L','', NULL, false, false, string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'222020400','Zobowiazania z tytuÂu dostaw i usÂug','L','', NULL, false, false, string_to_array('AP', ':'));
 SELECT account_save(NULL,'222020500','ZobowiÂzania o okresie wymagalnoÂci do 12 miesiÃcy ','L','', NULL, false, false, string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'222020600','ZobowiÂzania o okresie wymagalnoÂci powyÂej 12 miesiÃy','L','', NULL, false, false, string_to_array('AP_amount', ':'));
@@ -143,7 +143,7 @@
 SELECT account_save(NULL,'225020300','ZobowiÂzania z tytuÂu emisji dÂuÂnych papierÃw wartoÂciowych','L','', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'225020400','Inne zobowiÂzania kredytowe','L','', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'225020500','Inne zobowiÂzania','L','', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'225030000','Rozrachunki z tytuÂu wpÂat na kapita zakÂadowy','L','', NULL, false, false, string_to_array('AR_amount:APamount', ':'));
+SELECT account_save(NULL,'225030000','Rozrachunki z tytuÂu wpÂat na kapita zakÂadowy','L','', NULL, false, false, string_to_array('AR_amount:AP_amount', ':'));
 SELECT account_save(NULL,'225040000','Rozrachunki z tytuÂu wkÂadÃw niepieniÃÂnych na kapita zakÂadowy','L','', NULL, false, false, string_to_array('AR_amount:AP_amount', ':'));
 SELECT account_save(NULL,'225050000','Rozrachunki z tytuÂu podwyÂszenia kapitaÂu ze ÂrodkÃw wÂasnych spÃÂki','L','', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'225060000','Rozrachunki z tytuÂu umorzenia udziaÂÃw wÂasnych','L','', NULL, false, false, string_to_array('', ':'));


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.