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

[..hidden..]

Revision: 3405
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3405&view=rev
Author:   einhverfr
Date:     2011-07-01 11:08:15 +0000 (Fri, 01 Jul 2011)

Log Message:
-----------
se and ve charts now load

Modified Paths:
--------------
    trunk/sql/coa/se/chart/Agriculture.sql
    trunk/sql/coa/se/chart/General.sql
    trunk/sql/coa/ve/chart/General.sql

Modified: trunk/sql/coa/se/chart/Agriculture.sql
===================================================================
--- trunk/sql/coa/se/chart/Agriculture.sql	2011-07-01 10:46:25 UTC (rev 3404)
+++ trunk/sql/coa/se/chart/Agriculture.sql	2011-07-01 11:08:15 UTC (rev 3405)
@@ -224,7 +224,7 @@
 SELECT account_save(NULL,'1900','Observationskonto','A','200', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'1910','Kassa ','A','200', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'1920','Plusgiro ','A','200', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'1930','CheckrÃkningskonto','A','200', NULL, false, false, string_to_array('AR_paid:AP_paid:pg_accno:bg_accno', ':'));
+SELECT account_save(NULL,'1930','CheckrÃkningskonto','A','200', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'1940','Bank och Ãvr bankkon','A','200', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'1950','Bankcertifikat ','A','200', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1960','Koncernkont moderbol','A','200', NULL, false, false, string_to_array('', ':'));
@@ -369,24 +369,24 @@
 SELECT account_save(NULL,'2518','Betald prel.skatt ','L','301', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'26','Moms och sÃrskilda punktskatter', NULL);
 SELECT account_save(NULL,'2610','UtgÃende moms,25%','L','307', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'2611','Utg moms fÃrs Sv 25%','L','307', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice:CT_tax', ':'));
-SELECT account_save(NULL, '2612','Utg moms egn ut 25%', 'L','307',NULL,FALSE, '{}');
-SELECT account_save(NULL,'2613','Utg moms - uthyr 25%','L','307', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice:CT_tax', ':'));
+SELECT account_save(NULL,'2611','Utg moms fÃrs Sv 25%','L','307', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL, '2612','Utg moms egn ut 25%', 'L','307',NULL,false, false, '{}');
+SELECT account_save(NULL,'2613','Utg moms - uthyr 25%','L','307', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
 SELECT account_save(NULL,'2614','Ber u-mom tj.utl 25%','L','307', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'2615','Ber u-mom va.EU, 25%','L','307', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice:CT_tax', ':'));
+SELECT account_save(NULL,'2615','Ber u-mom va.EU, 25%','L','307', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
 SELECT account_save(NULL,'2618','Vil utg moms, 25% ','L','307', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'2620','UtgÃende moms, 12% ','L','307', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'2621','Utg moms fÃrs Sv 12%','L','307', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice:CT_tax', ':'));
+SELECT account_save(NULL,'2621','Utg moms fÃrs Sv 12%','L','307', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
 SELECT account_save(NULL,'2622','Utg moms egna ut 12%','L','307', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'2628','Vilande utg moms 12%','L','307', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'2630','UtgÃende moms, 6% ','L','307', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'2631','Utg moms fÃrs Sv 6%','L','307', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice:CT_tax', ':'));
+SELECT account_save(NULL,'2631','Utg moms fÃrs Sv 6%','L','307', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
 SELECT account_save(NULL,'2632','Utg moms egna ut 6%','L','307', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'2638','Vil utg moms 6% ','L','307', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'2640','Ing.moms ','L','307', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'2641','Deb ingÃende moms','L','307', NULL, false, false, string_to_array('AP_tax:IC_taxpart:IC_taxservice:CT_tax', ':'));
+SELECT account_save(NULL,'2641','Deb ingÃende moms','L','307', NULL, false, false, string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
 SELECT account_save(NULL,'2642','Deb ing.m.friv.sk.sk','L','307', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'2645','Ber ing.moms utl','L','307', NULL, false, false, string_to_array('AP_tax:IC_taxpart:IC_taxservice:CT_tax', ':'));
+SELECT account_save(NULL,'2645','Ber ing.moms utl','L','307', NULL, false, false, string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
 SELECT account_save(NULL,'2648','Vilande ing moms','L','307', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'2649','Ing moms - bl.verks ','L','307', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'2650','Redovisn.konto moms','L','307', NULL, false, false, string_to_array('', ':'));
@@ -841,7 +841,7 @@
 SELECT account_save(NULL,'5690','Ãvr.kostn trsp-medel','E','538', NULL, false, false, string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
 SELECT account_heading_save(NULL,'57','Frakter och transporter ', NULL);
 SELECT account_save(NULL,'5700','Frakter och transp','E','538', NULL, false, false, string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
-SELECT account_save(NULL,'5710','Frakt,trsp varudistr','E','538', NULL, false, false, string_to_array('AP_amount:IC_expence:IC_cogs', ':'));
+SELECT account_save(NULL,'5710','Frakt,trsp varudistr','E','538', NULL, false, false, string_to_array('AP_amount:IC_expense:IC_cogs', ':'));
 SELECT account_save(NULL,'5720','Tull- och sped.kostn','E','538', NULL, false, false, string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
 SELECT account_save(NULL,'5730','Arbetstransporter ','E','538', NULL, false, false, string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
 SELECT account_heading_save(NULL,'58','Resekostn ', NULL);
@@ -1173,7 +1173,7 @@
 SELECT account_save(NULL,'8223','Res fÃrs Ãvr vÃrdep','I','550/551', NULL, false, false, string_to_array('AR_amount', ':'));
 SELECT account_save(NULL,'8230','Valutak.diff.l-fr.fo','I','566', NULL, false, false, string_to_array('AP_amount:AR_amount', ':'));
 SELECT account_save(NULL,'8231','Valutak.vinst l-fr.f','I','566', NULL, false, false, string_to_array('AP_amount:AR_amount', ':'));
-SELECT account_save(NULL,'8236','Valutak.fÃrl.l-fr.fo','I','567', NULL, false, false, string_to_array('AP_aomunt:AR_amount', ':'));
+SELECT account_save(NULL,'8236','Valutak.fÃrl.l-fr.fo','I','567', NULL, false, false, string_to_array('AP_amount:AR_amount', ':'));
 SELECT account_save(NULL,'8250','Rta l-fr fo.vÃrdepap','I','568', NULL, false, false, string_to_array('AR_amount', ':'));
 SELECT account_save(NULL,'8251','Rta l-fr fordr.','I','568', NULL, false, false, string_to_array('AR_amount', ':'));
 SELECT account_save(NULL,'8252','Rta Ãvr vÃrdepapper','I','568', NULL, false, false, string_to_array('AR_amount', ':'));

Modified: trunk/sql/coa/se/chart/General.sql
===================================================================
--- trunk/sql/coa/se/chart/General.sql	2011-07-01 10:46:25 UTC (rev 3404)
+++ trunk/sql/coa/se/chart/General.sql	2011-07-01 11:08:15 UTC (rev 3405)
@@ -683,7 +683,7 @@
 SELECT account_save(NULL,'5690','Ãvriga kostnader fÃr transportmedel ','E','538', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'57','Frakter och transporter ', NULL);
 SELECT account_save(NULL,'5700','Frakter och transporter (gruppkonto) ','E','538', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'5710','Frakter, transporter och fÃrsÃkringar vid varudistribution ','E','538', NULL, false, false, string_to_array('AP_amount:IC_expence', ':'));
+SELECT account_save(NULL,'5710','Frakter, transporter och fÃrsÃkringar vid varudistribution ','E','538', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
 SELECT account_save(NULL,'5720','Tull- och speditionskostnader ','E','538', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'5730','Arbetstransporter ','E','538', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'58','Resekostnader ', NULL);

Modified: trunk/sql/coa/ve/chart/General.sql
===================================================================
--- trunk/sql/coa/ve/chart/General.sql	2011-07-01 10:46:25 UTC (rev 3404)
+++ trunk/sql/coa/ve/chart/General.sql	2011-07-01 11:08:15 UTC (rev 3405)
@@ -53,16 +53,16 @@
 SELECT account_save(NULL,'5100','Flete','E','', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
 -- HR
 SELECT account_heading_save(NULL,'5400','GASTO DE PERSONAL', NULL);
-SELECT account_save(NULL,'5405','Sueldos Directivo y Administradores','E','', NULL, false, false, string_to_array('HR_expense', ':'));
-SELECT account_save(NULL,'5410','Sueldos Empleados','E','', NULL, false, false, string_to_array('HR_expense', ':'));
-SELECT account_save(NULL,'5415','Comisiones Vendedores','E','', NULL, false, false, string_to_array('HR_expense', ':'));
-SELECT account_save(NULL,'5420','Vacaciones','E','', NULL, false, false, string_to_array('HR_expense', ':'));
-SELECT account_save(NULL,'5425','Bono Vacacional','E','', NULL, false, false, string_to_array('HR_expense', ':'));
-SELECT account_save(NULL,'5430','Utilidades','E','', NULL, false, false, string_to_array('HR_expense', ':'));
-SELECT account_save(NULL,'5435','Indemnizaciones','E','', NULL, false, false, string_to_array('HR_expense', ':'));
-SELECT account_save(NULL,'5440','Movilizaciones y Traslados','E','', NULL, false, false, string_to_array('HR_expense', ':'));
-SELECT account_save(NULL,'5445','Gastos de RepresentaciÃn','E','', NULL, false, false, string_to_array('HR_expense', ':'));
-SELECT account_save(NULL,'5450','InstrucciÃn y Mejoramiento','E','', NULL, false, false, string_to_array('HR_expense', ':'));
+SELECT account_save(NULL,'5405','Sueldos Directivo y Administradores','E','', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'5410','Sueldos Empleados','E','', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'5415','Comisiones Vendedores','E','', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'5420','Vacaciones','E','', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'5425','Bono Vacacional','E','', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'5430','Utilidades','E','', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'5435','Indemnizaciones','E','', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'5440','Movilizaciones y Traslados','E','', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'5445','Gastos de RepresentaciÃn','E','', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'5450','InstrucciÃn y Mejoramiento','E','', NULL, false, false, string_to_array('', ':'));
 
 SELECT account_heading_save(NULL,'5600','GASTOS GENERALES', NULL);
 SELECT account_save(NULL,'5610','Honorarios Profesionales','E','', NULL, false, false, string_to_array('AP_amount', ':'));


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