[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb:[2677] trunk/sql/coa

Subject: SF.net SVN: ledger-smb:[2677] trunk/sql/coa
From: ..hidden..
Date: Sat, 13 Jun 2009 04:42:30 +0000
Revision: 2677
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2677&view=rev
Author:   einhverfr
Date:     2009-06-13 04:42:30 +0000 (Sat, 13 Jun 2009)

Log Message:
-----------
More chart of accounts fixes

Modified Paths:
--------------
    trunk/sql/coa/eg/chart/General.sql
    trunk/sql/coa/es/chart/General.sql
    trunk/sql/coa/es/chart/ISO.sql
    trunk/sql/coa/fr/chart/General.sql

Modified: trunk/sql/coa/eg/chart/General.sql
===================================================================
--- trunk/sql/coa/eg/chart/General.sql	2009-06-13 04:30:33 UTC (rev 2676)
+++ trunk/sql/coa/eg/chart/General.sql	2009-06-13 04:42:30 UTC (rev 2677)
@@ -5,73 +5,73 @@
 SELECT account_heading_save(NULL, '1800', 'ØÙØØÙÙ ØÙØØØØØ', NULL);
 SELECT account_heading_save(NULL, '2000', 'ØÙØØØÙØØ ÙØÙØØ ØÙØØÙ', NULL);
 SELECT account_heading_save(NULL, '2600', 'ØÙØØØÙØØ ØÙÙÙØ ØÙØØÙ', NULL);
-SELECT account_save(NULL,'2210','Workers Comp Payable','','L', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2220','Vacation Pay Payable','','L', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2250','Pension Plan Payable','','L', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2260','Employment Insurance Payable','','L', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5420','Employment Insurance Expense','','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5430','Pension Plan Expense','','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5440','Workers Comp Expense','','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5470','Employee Benefits','','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5650','Capital Cost Allowance Expense','','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1060','ÙÙØÙØ ØØÙØÙÙ','','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'1065','ÙÙØÙØØØÙØÙØÙÙ','','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'1520','ÙØØÙÙ - ÙØØ ØÙØØ ÙÙØÙÙØØ','','A', NULL, false,string_to_array('IC', ':'));
-SELECT account_save(NULL,'1530','ÙØØÙÙ - ØØØÙØ','','A', NULL, false,string_to_array('IC', ':'));
-SELECT account_save(NULL,'1540','ÙØØÙÙ - ÙØØ ØØØÙ','','A', NULL, false,string_to_array('IC', ':'));
-SELECT account_save(NULL,'1840','ØÙØØØØ','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2210','Workers Comp Payable','L','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2220','Vacation Pay Payable','L','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2250','Pension Plan Payable','L','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2260','Employment Insurance Payable','L','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5420','Employment Insurance Expense','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5430','Pension Plan Expense','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5440','Workers Comp Expense','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5470','Employee Benefits','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5650','Capital Cost Allowance Expense','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1060','ÙÙØÙØ ØØÙØÙÙ','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1065','ÙÙØÙØØØÙØÙØÙÙ','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1520','ÙØØÙÙ - ÙØØ ØÙØØ ÙÙØÙÙØØ','A','', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1530','ÙØØÙÙ - ØØØÙØ','A','', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1540','ÙØØÙÙ - ÙØØ ØØØÙ','A','', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1840','ØÙØØØØ','A','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL, '1845','ÙØØØ ØÙÙØÙ ØÙØØØØ','A','',NULL,'1', '{}');
-SELECT account_save(NULL,'1820','ØØØØ ÙÙØØÙ Ù ÙØØØØ','','A', NULL, false,string_to_array('', ':'));
-SELECT account_save('1825','ÙØØØ ØÙÙØÙ ØØØØ ÙÙØØÙ Ù ÙØØØØ','','A',NULL,'1','{}');
-SELECT account_save(NULL,'2310','ØØÙØØ ÙØÙØØØ (10%)','','L', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'2320','ØØÙØØ ÙØÙØØØ (14%)','','L', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'2330','ØØÙØØ ÙØÙØØØ (30%)','','L', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'1200','ØÙÙØØ','','A', NULL, false,string_to_array('AR', ':'));
-SELECT account_save(NULL,'1205','ÙØØØ ØÙÙÙ ÙØØÙÙØ','','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2100','ÙÙØØÙÙ','','L', NULL, false,string_to_array('AP', ':'));
-SELECT account_save(NULL,'2160','ØØÙØØ ØØÙØØ ÙØØØÙØ','','L', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2190','ØØÙØØ ØØÙ ÙØØØÙØ','','L', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2620','ÙØÙØ ÙÙ ØÙØÙÙÙ','','L', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2680','ÙØÙØ ÙÙ ØÙÙØ ØÙØØÙÙ','','L', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'1820','ØØØØ ÙÙØØÙ Ù ÙØØØØ','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL, '1825','ÙØØØ ØÙÙØÙ ØØØØ ÙÙØØÙ Ù ÙØØØØ','A','',NULL,'1','{}');
+SELECT account_save(NULL,'2310','ØØÙØØ ÙØÙØØØ (10%)','L','', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'2320','ØØÙØØ ÙØÙØØØ (14%)','L','', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'2330','ØØÙØØ ÙØÙØØØ (30%)','L','', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'1200','ØÙÙØØ','A','', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'1205','ÙØØØ ØÙÙÙ ÙØØÙÙØ','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2100','ÙÙØØÙÙ','L','', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'2160','ØØÙØØ ØØÙØØ ÙØØØÙØ','L','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2190','ØØÙØØ ØØÙ ÙØØØÙØ','L','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2620','ÙØÙØ ÙÙ ØÙØÙÙÙ','L','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2680','ÙØÙØ ÙÙ ØÙÙØ ØÙØØÙÙ','L','', NULL, false,string_to_array('AP_paid', ':'));
 SELECT account_heading_save(NULL, '3300', 'ØÙÙÙ ØÙÙÙÙÙØ', NULL);
-SELECT account_save(NULL,'4020','ÙØÙØØØ - ÙØØ ØÙØØ','','I', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
-SELECT account_save(NULL,'4030','ÙØÙØØØ ØØØÙØ','','I', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
-SELECT account_save(NULL,'4040','ÙØÙØØØ ØØØÙ','','I', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_save(NULL,'4020','ÙØÙØØØ - ÙØØ ØÙØØ','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_save(NULL,'4030','ÙØÙØØØ ØØØÙØ','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_save(NULL,'4040','ÙØÙØØØ ØØØÙ','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
 SELECT account_heading_save(NULL, '4000', 'ØÙØØØ ØÙÙØÙØØØ', NULL);
 SELECT account_heading_save(NULL, '4300', 'ØÙØØØ ØØØØØØØØ', NULL);
-SELECT account_save(NULL,'4320','ØØØØØØØØ','','I', NULL, false,string_to_array('AR_amount:IC_income', ':'));
-SELECT account_save(NULL,'4330','ØØÙØØ','','I', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'4320','ØØØØØØØØ','I','', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'4330','ØØÙØØ','I','', NULL, false,string_to_array('AR_amount:IC_income', ':'));
 SELECT account_heading_save(NULL, '4400', 'ØÙØØØØØ ØØØÙ', NULL);
-SELECT account_save(NULL,'4430','ØØÙ Ù ØØØØØ','','I', NULL, false,string_to_array('IC_income', ':'));
-SELECT account_save(NULL,'4440','ÙØØØØ','','I', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'4450','ØØØØØ ØØÙÙØ ØÙÙØ','','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4430','ØØÙ Ù ØØØØØ','I','', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'4440','ÙØØØØ','I','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4450','ØØØØØ ØØÙÙØ ØÙÙØ','I','', NULL, false,string_to_array('', ':'));
 SELECT account_heading_save(NULL, '5000', 'ØÙÙÙØ ØÙØØØØØ ØÙÙØØØØ', NULL);
-SELECT account_save(NULL,'5010','ÙØØØÙØØ','','E', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
-SELECT account_save(NULL,'5020','ØÙÙÙØ ØÙØØØØØ ØÙÙØØØØ - ÙØØ ØÙØØ','','E', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
-SELECT account_save(NULL,'5030','ØÙÙÙØ ØÙØØØØØ ØÙÙØØØØ - ØØØÙØ','','E', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
-SELECT account_save(NULL,'5040','ØÙÙÙØ ØÙØØØØØ ØÙÙØØØØ - ØØØÙ','','E', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
-SELECT account_save(NULL,'5100','ØØÙ','','E', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'5010','ÙØØØÙØØ','E','', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'5020','ØÙÙÙØ ØÙØØØØØ ØÙÙØØØØ - ÙØØ ØÙØØ','E','', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_save(NULL,'5030','ØÙÙÙØ ØÙØØØØØ ØÙÙØØØØ - ØØØÙØ','E','', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_save(NULL,'5040','ØÙÙÙØ ØÙØØØØØ ØÙÙØØØØ - ØØØÙ','E','', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_save(NULL,'5100','ØØÙ','E','', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
 SELECT account_heading_save(NULL, '5400', 'ÙØØÙÙØØ ØÙØØÙØ', NULL);
-SELECT account_save(NULL,'5410','ØÙÙØØØØØ','','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'3350','ØÙØØÙÙ','','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5410','ØÙÙØØØØØ','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3350','ØÙØØÙÙ','Q','', NULL, false,string_to_array('', ':'));
 SELECT account_heading_save(NULL, '5600', 'ÙØØÙÙØØ ØØØØÙØ Ù ØÙÙÙÙØ', NULL);
-SELECT account_save(NULL,'5610','ÙØÙÙÙÙØ Ù ÙØØØØÙØ','','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5615','ØØØÙØ Ù ØØÙØÙ','','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5765','ØØÙØØ Ù ØÙØÙØ','','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5680','ØØÙØØ ØØÙ','','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5685','ØØÙÙÙ','','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5620','ØÙÙÙ ÙØØÙÙØ ','','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5660','ÙØØØÙÙ ØÙÙØÙ','','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5690','ÙÙØØØ Ù ÙØØØÙÙ ØÙÙÙØ','','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5700','ÙÙÙØØ ÙÙØØÙØ','','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5780','ØÙÙÙÙ','','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5760','ØÙØØØ','','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5785','ÙØØØÙÙ ØÙØ','','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5795','ØØÙÙ','','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5800','ØØØ','','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5810','ØØØØØ ØØÙÙÙ ØÙÙØ','','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5790','ÙØØÙÙ','','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'2280','ØØØØØ ÙØØØØØ ÙØØØÙØ','','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5610','ÙØÙÙÙÙØ Ù ÙØØØØÙØ','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5615','ØØØÙØ Ù ØØÙØÙ','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5765','ØØÙØØ Ù ØÙØÙØ','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5680','ØØÙØØ ØØÙ','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5685','ØØÙÙÙ','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5620','ØÙÙÙ ÙØØÙÙØ ','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5660','ÙØØØÙÙ ØÙÙØÙ','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5690','ÙÙØØØ Ù ÙØØØÙÙ ØÙÙÙØ','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5700','ÙÙÙØØ ÙÙØØÙØ','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5780','ØÙÙÙÙ','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5760','ØÙØØØ','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5785','ÙØØØÙÙ ØÙØ','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5795','ØØÙÙ','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5800','ØØØ','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5810','ØØØØØ ØØÙÙÙ ØÙÙØ','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5790','ÙØØÙÙ','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'2280','ØØØØØ ÙØØØØØ ÙØØØÙØ','L','', NULL, false,string_to_array('', ':'));
 
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '1520'));
 

Modified: trunk/sql/coa/es/chart/General.sql
===================================================================
--- trunk/sql/coa/es/chart/General.sql	2009-06-13 04:30:33 UTC (rev 2676)
+++ trunk/sql/coa/es/chart/General.sql	2009-06-13 04:42:30 UTC (rev 2677)
@@ -15,7 +15,7 @@
 SELECT account_save(NULL,'180000000','Fianzas y depÃsitos recibidos a largo plazo','A','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'190000000','Situaciones transitorias de financiaciÃn','A','', NULL, false,string_to_array('', ':'));
 --
-SELECT account_heading_save(NULL, '199999999','Grupo 2: inmovilizado', NULL)
+SELECT account_heading_save(NULL, '199999999','Grupo 2: inmovilizado', NULL);
 SELECT account_save(NULL,'200000000','Gastos de establecimiento','A','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'210000000','Inmovilizaciones inmateriales','A','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'220000000','Inmovilizaciones materiales','A','', NULL, false,string_to_array('', ':'));
@@ -77,7 +77,7 @@
 SELECT account_save(NULL,'590000000','Provisiones financieras','P','', NULL, false,string_to_array('', ':'));
 --
 SELECT account_heading_save(NULL, '599999999','Grupo 6: compras y gastos', NULL);
-SELECT account_save(NULL,'600000000','Compras','E','', NULL, false,string_to_array('AP:IC_cogs', ':'));
+SELECT account_save(NULL,'600000000','Compras','E','', NULL, false,string_to_array('AP_expense:IC_cogs', ':'));
 SELECT account_save(NULL,'608000000','Devoluciones de compras y operaciones similares','E','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'610000000','VariaciÃn de existencias','E','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'620000000','Servicios exteriores','E','', NULL, false,string_to_array('IC_expense', ':'));
@@ -92,7 +92,7 @@
 SELECT account_save(NULL,'690000000','Dotaciones a las provisiones','E','', NULL, false,string_to_array('', ':'));
 --
 SELECT account_heading_save(NULL, '699999999','Grupo 7: ventas e ingresos', NULL);
-SELECT account_save(NULL,'700000000','Ventas de servicios y productos','I','', NULL, false,string_to_array('AR:IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'700000000','Ventas de servicios y productos','I','', NULL, false,string_to_array('AR_income:IC_sale:IC_income', ':'));
 SELECT account_save(NULL,'708000000','Devoluciones de ventas y operaciones similares','I','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'710000000','VariaciÃn de existencias','I','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'730000000','Trabajos realizados para la empresa','I','', NULL, false,string_to_array('', ':'));
@@ -113,9 +113,6 @@
 INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '472000002'), 0.07);
 INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '472000003'), 0.16);
 -- Recargo equivalente: 0.5, 1 or 4%
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '472000004'), 0.005);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '472000005'), 0.01);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '472000006'), 0.04);
 --
 -- IVA repercutido
 INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '477000000'), 0.0);
@@ -123,9 +120,6 @@
 INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '477000002'), 0.07);
 INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '477000003'), 0.16);
 -- Recargo equivalente: 0.5, 1 or 4%
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '477000004'), 0.005);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '477000005'), 0.01);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '477000006'), 0.04);
 --
 -- update defaults
 --
@@ -140,7 +134,7 @@
  INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '668000000'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('curr', 'EUR');
- INSERT INTO defaults (setting_key, value) VALUES ('weightunit' , 'Kg';
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit' , 'Kg');
 --
 
 commit;

Modified: trunk/sql/coa/es/chart/ISO.sql
===================================================================
--- trunk/sql/coa/es/chart/ISO.sql	2009-06-13 04:30:33 UTC (rev 2676)
+++ trunk/sql/coa/es/chart/ISO.sql	2009-06-13 04:42:30 UTC (rev 2677)
@@ -77,7 +77,7 @@
 SELECT account_save(NULL,'590000000','Provisiones financieras','P','', NULL, false,string_to_array('', ':'));
 --
 SELECT account_heading_save(NULL, '599999999', 'Grupo 6: compras y gastos', NULL);
-SELECT account_save(NULL,'600000000','Compras','E','', NULL, false,string_to_array('AP:IC_cogs', ':'));
+SELECT account_save(NULL,'600000000','Compras','E','', NULL, false,string_to_array('AP_expense:IC_cogs', ':'));
 SELECT account_save(NULL,'608000000','Devoluciones de compras y operaciones similares','E','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'610000000','VariaciÃn de existencias','E','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'620000000','Servicios exteriores','E','', NULL, false,string_to_array('IC_expense', ':'));
@@ -92,7 +92,7 @@
 SELECT account_save(NULL,'690000000','Dotaciones a las provisiones','E','', NULL, false,string_to_array('', ':'));
 --
 SELECT account_heading_save(NULL, '699999999', 'Grupo 7: ventas e ingresos', NULL);
-SELECT account_save(NULL,'700000000','Ventas de mercaderÃas, de producciÃn propia, de servicios, etc.','I','', NULL, false,string_to_array('AR:IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'700000000','Ventas de mercaderÃas, de producciÃn propia, de servicios, etc.','I','', NULL, false,string_to_array('AR_income:IC_sale:IC_income', ':'));
 SELECT account_save(NULL,'708000000','Devoluciones de ventas y operaciones similares','I','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'710000000','VariaciÃn de existencias','I','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'730000000','Trabajos realizados para la empresa','I','', NULL, false,string_to_array('', ':'));
@@ -112,21 +112,12 @@
 INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '472000001'), 0.04);
 INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '472000002'), 0.07);
 INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '472000003'), 0.16);
--- Recargo equivalente: 0.5, 1 or 4%
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '472000004'), 0.005);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '472000005'), 0.01);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '472000006'), 0.04);
---
 -- IVA repercutido
 INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '477000000'), 0.0);
 INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '477000001'), 0.04);
 INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '477000002'), 0.07);
 INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '477000003'), 0.16);
 -- Recargo equivalente: 0.5, 1 or 4%
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '477000004'), 0.005);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '477000005'), 0.01);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '477000006'), 0.04);
---
 -- update defaults
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '300000000'));

Modified: trunk/sql/coa/fr/chart/General.sql
===================================================================
--- trunk/sql/coa/fr/chart/General.sql	2009-06-13 04:30:33 UTC (rev 2676)
+++ trunk/sql/coa/fr/chart/General.sql	2009-06-13 04:42:30 UTC (rev 2677)
@@ -3,6 +3,7 @@
 -- From: Oscar Buijten <..hidden..>
 -- Mon, 6 Aug 2001
 --
+SELECT account_heading_save(NULL, '0000', '----', NULL);
 INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('101000', 'CAPITAL', 'A', '', '', '');
 INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('101100', 'CAPITAL SOUSCRIT NON APPELE', 'A', '', '', '');
 INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('101200', 'CAPITAL SOUSCRIT APPELE NON VERSE', 'A', '', '', '');
@@ -905,7 +906,7 @@
 SELECT account_save(NULL,'512020','BANQUE DEBIT','E','', NULL, false,string_to_array('AP', ':'));
 SELECT account_save(NULL,'445711','TVA COLLECTEE  5.5%','I','', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
 SELECT account_save(NULL,'445661','TVA DEDUCTIBLE  5.5%','E','', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'512010','BANQUE CREDIT','I','', NULL, false,string_to_array('AR:AR_amount', ':'));
+SELECT account_save(NULL,'512010','BANQUE CREDIT','I','', NULL, false,string_to_array('AR_amount', ':'));
 SELECT account_save(NULL,'681730','STOCKS ET EN-COURS','A','', NULL, false,string_to_array('IC', ':'));
 SELECT account_save(NULL,'580010','VIREMENT INTERNE','E','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'580000','VIREMENT INTERNE','E','', NULL, false,string_to_array('AP_amount', ':'));


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
Prev by Date: SF.net SVN: ledger-smb:[2676] trunk/sql/coa
Next by Date: SF.net SVN: ledger-smb:[2678] trunk/sql/coa
Previous by thread: SF.net SVN: ledger-smb:[2676] trunk/sql/coa
Next by thread: SF.net SVN: ledger-smb:[2678] trunk/sql/coa
Index(es):
- Date
- Thread