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

Subject: SF.net SVN: ledger-smb:[2648] trunk/sql/coa/es/chart
From: ..hidden..
Date: Fri, 12 Jun 2009 02:16:41 +0000
Revision: 2648
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2648&view=rev
Author:   einhverfr
Date:     2009-06-12 02:16:41 +0000 (Fri, 12 Jun 2009)

Log Message:
-----------
Spanish chart conversions

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

Modified: trunk/sql/coa/es/chart/General.sql
===================================================================
--- trunk/sql/coa/es/chart/General.sql	2009-06-12 02:07:38 UTC (rev 2647)
+++ trunk/sql/coa/es/chart/General.sql	2009-06-12 02:16:41 UTC (rev 2648)
@@ -3,106 +3,106 @@
 -- From: Federico Montesino Pouzols <..hidden..>
 -- 23 Apr 2002
 --
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('099999999','Grupo 1: financiaciÃn bÃsica','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('100000000','Capital','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('110000000','Reservas','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('120000000','Resultados pendientes de aplicaciÃn','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('130000000','Ingresos a distribuir en varios ejercicios','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('140000000','Provisiones para riesgos y gastos','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('150000000','EmprÃstitos y otras emisiones anÃlogas','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('160000000','Deudas a largo plazo con empresas del grupo y asociadas','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('170000000','Deudas a largo plazo por prestamos recibidos y otros conceptos','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('180000000','Fianzas y depÃsitos recibidos a largo plazo','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('190000000','Situaciones transitorias de financiaciÃn','A','','A','');
+SELECT account_heading_save(NULL, '099999999','Grupo 1: financiaciÃn bÃsica',NULL);
+SELECT account_save(NULL,'100000000','Capital','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'110000000','Reservas','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'120000000','Resultados pendientes de aplicaciÃn','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'130000000','Ingresos a distribuir en varios ejercicios','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'140000000','Provisiones para riesgos y gastos','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'150000000','EmprÃstitos y otras emisiones anÃlogas','L','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'160000000','Deudas a largo plazo con empresas del grupo y asociadas','L','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'170000000','Deudas a largo plazo por prestamos recibidos y otros conceptos','L','', NULL, false,string_to_array('', ':'));
+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('', ':'));
 --
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('199999999','Grupo 2: inmovilizado','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('200000000','Gastos de establecimiento','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('210000000','Inmovilizaciones inmateriales','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('220000000','Inmovilizaciones materiales','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('230000000','Inmovilizaciones materiales en curso','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('240000000','Inversiones financieras en empresas del grupo y asociadas','A','', 'A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('250000000','Otras inversiones financieras permanentes','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('260000000','Fianzas y depÃsitos constituidos a largo plazo','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('270000000','Gastos a distribuir en varios ejercicios','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('280000000','AmortizaciÃn acumulada del inmovilizado','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('290000000','Provisiones de inmovilizado','A','','A','');
+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('', ':'));
+SELECT account_save(NULL,'230000000','Inmovilizaciones materiales en curso','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'240000000','Inversiones financieras en empresas del grupo y asociadas','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'250000000','Otras inversiones financieras permanentes','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'260000000','Fianzas y depÃsitos constituidos a largo plazo','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'270000000','Gastos a distribuir en varios ejercicios','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'280000000','AmortizaciÃn acumulada del inmovilizado','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'290000000','Provisiones de inmovilizado','A','', NULL, false,string_to_array('', ':'));
 --
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('299999999','Grupo 3: existencias','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('300000000','Comerciales','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('310000000','Materias primas','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('320000000','Otros aprovisionamientos','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('330000000','Productos en curso','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('340000000','Productos semiterminados','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('350000000','Productos terminados','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('360000000','Subproductos, residuos y materiales recuperados','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('390000000','Provisiones por depreciaciÃn de existencias','A','','A','');
+SELECT account_heading_save(NULL,'299999999','Grupo 3: existencias',NULL);
+SELECT account_save(NULL,'300000000','Comerciales','A','', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'310000000','Materias primas','A','', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'320000000','Otros aprovisionamientos','A','', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'330000000','Productos en curso','A','', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'340000000','Productos semiterminados','A','', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'350000000','Productos terminados','A','', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'360000000','Subproductos, residuos y materiales recuperados','A','', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'390000000','Provisiones por depreciaciÃn de existencias','A','', NULL, false,string_to_array('', ':'));
 --
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('399999999','Grupo 4: acreedores y deudores por operaciones de trÃfico','H','', '','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('400000000','Proveedores','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('410000000','Acreedores varios','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('430000000','Clientes','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('431000000','Clientes, efectos comerciales a cobrar','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('440000000','Deudores varios','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('460000000','Personal','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('470000000','Administraciones pÃblicas','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('472000000','Hacienda PÃblica, IVA soportado','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('472000001','IVA soportado 4%','A','','P','AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('472000002','IVA soportado 7%','A','','P','AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('472000003','IVA soportado 16%','A','','P','AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('475100000','Hacienda PÃblica, acreedor por retenciones practicadas','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('473000000','Hacienda PÃblica, retenciones y pagos a cuenta','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('477000000','Hacienda PÃblica, IVA repercutido','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('477000001','IVA repercutido 4%','A','','P','AR_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('477000002','IVA repercutido 7%','A','','P','AR_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('477000003','IVA repercutido 16%','A','','P','AR_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('480000000','Ajustes por periodificaciÃn','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('490000000','Provisiones por operaciones de trÃfico','A','','P','');
+SELECT account_heading_save (NULL, '399999999','Grupo 4: acreedores y deudores por operaciones de trÃfico', NULL);
+SELECT account_save(NULL,'400000000','Proveedores','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'410000000','Acreedores varios','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'430000000','Clientes','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'431000000','Clientes, efectos comerciales a cobrar','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'440000000','Deudores varios','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'460000000','Personal','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'470000000','Administraciones pÃblicas','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'472000000','Hacienda PÃblica, IVA soportado','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'472000001','IVA soportado 4%','P','', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'472000002','IVA soportado 7%','P','', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'472000003','IVA soportado 16%','P','', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'475100000','Hacienda PÃblica, acreedor por retenciones practicadas','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'473000000','Hacienda PÃblica, retenciones y pagos a cuenta','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'477000000','Hacienda PÃblica, IVA repercutido','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'477000001','IVA repercutido 4%','P','', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'477000002','IVA repercutido 7%','P','', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'477000003','IVA repercutido 16%','P','', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'480000000','Ajustes por periodificaciÃn','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'490000000','Provisiones por operaciones de trÃfico','P','', NULL, false,string_to_array('', ':'));
 --
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('499999999','Grupo 5: cuentas financieras','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('500000000','EmprÃstitos y otras emisiones anÃlogas a corto plazo','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('510000000','Deudas a corto plazo con empresas del grupo y asociadas','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('520000000','Deudas a corto plazo por prÃstamos recibidos y otros conceptos','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('530000000','Inversiones financieras a corto plazo en empresas del grupo y asociadas','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('540000000','Otras inversiones financieras temporales','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('550000000','Otras cuentas no bancarias','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('560000000','Fianzas y depÃsitos recibidos y constituidos a corto plazo','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('569000000','TesorerÃa','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('570000000','Caja, euros','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('571000000','Caja, moneda extranjera','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('572000000','Bancos e instituciones de crÃdito, c/c. vista, euros','A','','A','AR_paid:AP_paid:AP_amount:AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('573000000','Bancos e instituciones de crÃdito, c/c. vista, moneda extranjera','A','','A','AR_paid:AP_paid:AP_amount:AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('574000000','Bancos e instituciones de crÃdito, cuentas de ahorro, euros','A','','A','AR_paid:AP_paid:AP_amount:AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('575000000','Bancos e instituciones de crÃdito, cuentas de ahorro, moneda extranjera','A','','A','AR_paid:AP_paid:AP_amount:AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('580000000','Ajustes por periodificaciÃn','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('590000000','Provisiones financieras','A','','P','');
+SELECT account_heading_save(NULL, '499999999','Grupo 5: cuentas financieras', NULL);
+SELECT account_save(NULL,'500000000','EmprÃstitos y otras emisiones anÃlogas a corto plazo','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'510000000','Deudas a corto plazo con empresas del grupo y asociadas','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'520000000','Deudas a corto plazo por prÃstamos recibidos y otros conceptos','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'530000000','Inversiones financieras a corto plazo en empresas del grupo y asociadas','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'540000000','Otras inversiones financieras temporales','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'550000000','Otras cuentas no bancarias','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'560000000','Fianzas y depÃsitos recibidos y constituidos a corto plazo','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'569000000','TesorerÃa','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'570000000','Caja, euros','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'571000000','Caja, moneda extranjera','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'572000000','Bancos e instituciones de crÃdito, c/c. vista, euros','A','', NULL, false,string_to_array('AR_paid:AP_paid:AP_amount:AR_amount', ':'));
+SELECT account_save(NULL,'573000000','Bancos e instituciones de crÃdito, c/c. vista, moneda extranjera','A','', NULL, false,string_to_array('AR_paid:AP_paid:AP_amount:AR_amount', ':'));
+SELECT account_save(NULL,'574000000','Bancos e instituciones de crÃdito, cuentas de ahorro, euros','A','', NULL, false,string_to_array('AR_paid:AP_paid:AP_amount:AR_amount', ':'));
+SELECT account_save(NULL,'575000000','Bancos e instituciones de crÃdito, cuentas de ahorro, moneda extranjera','A','', NULL, false,string_to_array('AR_paid:AP_paid:AP_amount:AR_amount', ':'));
+SELECT account_save(NULL,'580000000','Ajustes por periodificaciÃn','Q','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'590000000','Provisiones financieras','P','', NULL, false,string_to_array('', ':'));
 --
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('599999999','Grupo 6: compras y gastos','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('600000000','Compras','A','','E','AP:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('608000000','Devoluciones de compras y operaciones similares','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('610000000','VariaciÃn de existencias','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('620000000','Servicios exteriores','A','','E','IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('630000000','Tributos','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('640000000','Gastos de personal','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('650000000','Otros gastos de gestiÃn','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('660000000','Gastos financieros','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('665000000','Descuentos sobre ventas por pronto pago','A','','E','IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('668000000','Diferencias negativas de cambio','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('670000000','PÃrdidas procedentes del inmovilizado y gastos excepcionales','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('680000000','Dotaciones para amortizaciones','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('690000000','Dotaciones a las provisiones','A','','E','');
+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,'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', ':'));
+SELECT account_save(NULL,'630000000','Tributos','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'640000000','Gastos de personal','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'650000000','Otros gastos de gestiÃn','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'660000000','Gastos financieros','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'665000000','Descuentos sobre ventas por pronto pago','E','', NULL, false,string_to_array('IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'668000000','Diferencias negativas de cambio','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'670000000','PÃrdidas procedentes del inmovilizado y gastos excepcionales','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'680000000','Dotaciones para amortizaciones','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'690000000','Dotaciones a las provisiones','E','', NULL, false,string_to_array('', ':'));
 --
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('699999999','Grupo 7: ventas e ingresos','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('700000000','Ventas de servicios y productos','A','','I','AR:IC_sale:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('708000000','Devoluciones de ventas y operaciones similares','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('710000000','VariaciÃn de existencias','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('730000000','Trabajos realizados para la empresa','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('740000000','Subvenciones a la explotaciÃn','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('750000000','Otros ingresos de gestiÃn','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('760000000','Ingresos financieros','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('765000000','Descuentos sobre compras por pronto pago','A','','I','IC_sale:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('768000000','Diferencias positivas de cambio','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('770000000','Beneficios procedentes de inmovilizados e ingresos excepcionales','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('790000000','Excesos y aplicaciones de provisiones','A','','I','');
+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,'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('', ':'));
+SELECT account_save(NULL,'740000000','Subvenciones a la explotaciÃn','I','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'750000000','Otros ingresos de gestiÃn','I','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'760000000','Ingresos financieros','I','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'765000000','Descuentos sobre compras por pronto pago','I','', NULL, false,string_to_array('IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'768000000','Diferencias positivas de cambio','I','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'770000000','Beneficios procedentes de inmovilizados e ingresos excepcionales','I','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'790000000','Excesos y aplicaciones de provisiones','I','', NULL, false,string_to_array('', ':'));
 --
 -- Taxes in Spain
 --

Modified: trunk/sql/coa/es/chart/ISO.sql
===================================================================
--- trunk/sql/coa/es/chart/ISO.sql	2009-06-12 02:07:38 UTC (rev 2647)
+++ trunk/sql/coa/es/chart/ISO.sql	2009-06-12 02:16:41 UTC (rev 2648)
@@ -3,106 +3,106 @@
 -- From: Federico Montesino Pouzols <..hidden..>
 -- 23 Apr 2002
 -- 
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('099999999','Grupo 1: financiaciÃn bÃsica','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('100000000','Capital','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('110000000','Reservas','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('120000000','Resultados pendientes de aplicaciÃn','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('130000000','Ingresos a distribuir en varios ejercicios','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('140000000','Provisiones para riesgos y gastos','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('150000000','EmprÃstitos y otras emisiones anÃlogas','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('160000000','Deudas a largo plazo con empresas del grupo y asociadas','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('170000000','Deudas a largo plazo por prestamos recibidos y otros conceptos','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('180000000','Fianzas y depÃsitos recibidos a largo plazo','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('190000000','Situaciones transitorias de financiaciÃn','A','','A','');
+SELECT account_heading_save(NULL, '099999999', 'Grupo 1: financiaciÃn bÃsica', NULL);
+SELECT account_save(NULL,'100000000','Capital','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'110000000','Reservas','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'120000000','Resultados pendientes de aplicaciÃn','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'130000000','Ingresos a distribuir en varios ejercicios','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'140000000','Provisiones para riesgos y gastos','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'150000000','EmprÃstitos y otras emisiones anÃlogas','L','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'160000000','Deudas a largo plazo con empresas del grupo y asociadas','L','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'170000000','Deudas a largo plazo por prestamos recibidos y otros conceptos','L','', NULL, false,string_to_array('', ':'));
+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('', ':'));
 --
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('199999999','Grupo 2: inmovilizado','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('200000000','Gastos de establecimiento','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('210000000','Inmovilizaciones inmateriales','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('220000000','Inmovilizaciones materiales','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('230000000','Inmovilizaciones materiales en curso','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('240000000','Inversiones financieras en empresas del grupo y asociadas','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('250000000','Otras inversiones financieras permanentes','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('260000000','Fianzas y depÃsitos constituidos a largo plazo','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('270000000','Gastos a distribuir en varios ejercicios','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('280000000','AmortizaciÃn acumulada del inmovilizado','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('290000000','Provisiones de inmovilizado','A','','A','');
+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('', ':'));
+SELECT account_save(NULL,'230000000','Inmovilizaciones materiales en curso','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'240000000','Inversiones financieras en empresas del grupo y asociadas','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'250000000','Otras inversiones financieras permanentes','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'260000000','Fianzas y depÃsitos constituidos a largo plazo','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'270000000','Gastos a distribuir en varios ejercicios','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'280000000','AmortizaciÃn acumulada del inmovilizado','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'290000000','Provisiones de inmovilizado','A','', NULL, false,string_to_array('', ':'));
 --
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('299999999','Grupo 3: existencias','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('300000000','Comerciales','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('310000000','Materias primas','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('320000000','Otros aprovisionamientos','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('330000000','Productos en curso','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('340000000','Productos semiterminados','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('350000000','Productos terminados','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('360000000','Subproductos, residuos y materiales recuperados','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('390000000','Provisiones por depreciaciÃn de existencias','A','','A','');
+SELECT account_heading_save(NULL, '299999999', 'Grupo 3: existencias', NULL);
+SELECT account_save(NULL,'300000000','Comerciales','A','', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'310000000','Materias primas','A','', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'320000000','Otros aprovisionamientos','A','', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'330000000','Productos en curso','A','', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'340000000','Productos semiterminados','A','', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'350000000','Productos terminados','A','', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'360000000','Subproductos, residuos y materiales recuperados','A','', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'390000000','Provisiones por depreciaciÃn de existencias','A','', NULL, false,string_to_array('', ':'));
 --
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('399999999','Grupo 4: acreedores y deudores por operaciones de trÃfico','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('400000000','Proveedores','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('410000000','Acreedores varios','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('430000000','Clientes','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('431000000','Clientes, efectos comerciales a cobrar','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('440000000','Deudores varios','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('460000000','Personal','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('470000000','Administraciones pÃblicas','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('472000000','Hacienda PÃblica, IVA soportado','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('472000001','IVA soportado 4%','A','','P','AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('472000002','IVA soportado 7%','A','','P','AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('472000003','IVA soportado 16%','A','','P','AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('475100000','Hacienda PÃblica, acreedor por retenciones practicadas','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('473000000','Hacienda PÃblica, retenciones y pagos a cuenta','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('477000000','Hacienda PÃblica, IVA repercutido','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('477000001','IVA repercutido 4%','A','','P','AR_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('477000002','IVA repercutido 7%','A','','P','AR_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('477000003','IVA repercutido 16%','A','','P','AR_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('480000000','Ajustes por periodificaciÃn','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('490000000','Provisiones por operaciones de trÃfico','A','','P','');
+SELECT account_heading_save(NULL, '399999999', 'Grupo 4: acreedores y deudores por operaciones de trÃfico', NULL);
+SELECT account_save(NULL,'400000000','Proveedores','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'410000000','Acreedores varios','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'430000000','Clientes','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'431000000','Clientes, efectos comerciales a cobrar','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'440000000','Deudores varios','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'460000000','Personal','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'470000000','Administraciones pÃblicas','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'472000000','Hacienda PÃblica, IVA soportado','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'472000001','IVA soportado 4%','P','', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'472000002','IVA soportado 7%','P','', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'472000003','IVA soportado 16%','P','', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'475100000','Hacienda PÃblica, acreedor por retenciones practicadas','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'473000000','Hacienda PÃblica, retenciones y pagos a cuenta','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'477000000','Hacienda PÃblica, IVA repercutido','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'477000001','IVA repercutido 4%','P','', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'477000002','IVA repercutido 7%','P','', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'477000003','IVA repercutido 16%','P','', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'480000000','Ajustes por periodificaciÃn','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'490000000','Provisiones por operaciones de trÃfico','P','', NULL, false,string_to_array('', ':'));
 --
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('499999999','Grupo 5: cuentas financieras','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('500000000','EmprÃstitos y otras emisiones anÃlogas a corto plazo','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('510000000','Deudas a corto plazo con empresas del grupo y asociadas','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('520000000','Deudas a corto plazo por prÃstamos recibidos y otros conceptos','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('530000000','Inversiones financieras a corto plazo en empresas del grupo y asociadas','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('540000000','Otras inversiones financieras temporales','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('550000000','Otras cuentas no bancarias','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('560000000','Fianzas y depÃsitos recibidos y constituidos a corto plazo','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('569000000','TesorerÃa','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('570000000','Caja, euros','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('571000000','Caja, moneda extranjera','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('572000000','Bancos e instituciones de crÃdito, c/c. vista, euros','A','','A','AR_paid:AP_paid:AP_amount:AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('573000000','Bancos e instituciones de crÃdito, c/c. vista, moneda extranjera','A','','A','AR_paid:AP_paid:AP_amount:AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('574000000','Bancos e instituciones de crÃdito, cuentas de ahorro, euros','A','','A','AR_paid:AP_paid:AP_amount:AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('575000000','Bancos e instituciones de crÃdito, cuentas de ahorro, moneda extranjera','A','','A','AR_paid:AP_paid:AP_amount:AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('580000000','Ajustes por periodificaciÃn','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('590000000','Provisiones financieras','A','','P','');
+SELECT account_heading_save(NULL, '499999999', 'Grupo 5: cuentas financieras', NULL);
+SELECT account_save(NULL,'500000000','EmprÃstitos y otras emisiones anÃlogas a corto plazo','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'510000000','Deudas a corto plazo con empresas del grupo y asociadas','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'520000000','Deudas a corto plazo por prÃstamos recibidos y otros conceptos','P','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'530000000','Inversiones financieras a corto plazo en empresas del grupo y asociadas','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'540000000','Otras inversiones financieras temporales','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'550000000','Otras cuentas no bancarias','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'560000000','Fianzas y depÃsitos recibidos y constituidos a corto plazo','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'569000000','TesorerÃa','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'570000000','Caja, euros','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'571000000','Caja, moneda extranjera','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'572000000','Bancos e instituciones de crÃdito, c/c. vista, euros','A','', NULL, false,string_to_array('AR_paid:AP_paid:AP_amount:AR_amount', ':'));
+SELECT account_save(NULL,'573000000','Bancos e instituciones de crÃdito, c/c. vista, moneda extranjera','A','', NULL, false,string_to_array('AR_paid:AP_paid:AP_amount:AR_amount', ':'));
+SELECT account_save(NULL,'574000000','Bancos e instituciones de crÃdito, cuentas de ahorro, euros','A','', NULL, false,string_to_array('AR_paid:AP_paid:AP_amount:AR_amount', ':'));
+SELECT account_save(NULL,'575000000','Bancos e instituciones de crÃdito, cuentas de ahorro, moneda extranjera','A','', NULL, false,string_to_array('AR_paid:AP_paid:AP_amount:AR_amount', ':'));
+SELECT account_save(NULL,'580000000','Ajustes por periodificaciÃn','Q','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'590000000','Provisiones financieras','P','', NULL, false,string_to_array('', ':'));
 --
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('599999999','Grupo 6: compras y gastos','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('600000000','Compras','A','','E','AP:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('608000000','Devoluciones de compras y operaciones similares','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('610000000','VariaciÃn de existencias','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('620000000','Servicios exteriores','A','','E','IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('630000000','Tributos','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('640000000','Gastos de personal','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('650000000','Otros gastos de gestiÃn','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('660000000','Gastos financieros','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('665000000','Descuentos sobre ventas por pronto pago','A','','E','IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('668000000','Diferencias negativas de cambio','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('670000000','PÃrdidas procedentes del inmovilizado y gastos excepcionales','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('680000000','Dotaciones para amortizaciones','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('690000000','Dotaciones a las provisiones','A','','E','');
+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,'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', ':'));
+SELECT account_save(NULL,'630000000','Tributos','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'640000000','Gastos de personal','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'650000000','Otros gastos de gestiÃn','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'660000000','Gastos financieros','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'665000000','Descuentos sobre ventas por pronto pago','E','', NULL, false,string_to_array('IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'668000000','Diferencias negativas de cambio','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'670000000','PÃrdidas procedentes del inmovilizado y gastos excepcionales','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'680000000','Dotaciones para amortizaciones','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'690000000','Dotaciones a las provisiones','E','', NULL, false,string_to_array('', ':'));
 --
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('699999999','Grupo 7: ventas e ingresos','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('700000000','Ventas de mercaderÃas, de producciÃn propia, de servicios, etc.','A','','I','AR:IC_sale:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('708000000','Devoluciones de ventas y operaciones similares','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('710000000','VariaciÃn de existencias','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('730000000','Trabajos realizados para la empresa','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('740000000','Subvenciones a la explotaciÃn','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('750000000','Otros ingresos de gestiÃn','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('760000000','Ingresos financieros','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('765000000','Descuentos sobre compras por pronto pago','A','','I','IC_sale:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('768000000','Diferencias positivas de cambio','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('770000000','Beneficios procedentes de inmovilizados e ingresos excepcionales','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('790000000','Excesos y aplicaciones de provisiones','A','','I','');
+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,'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('', ':'));
+SELECT account_save(NULL,'740000000','Subvenciones a la explotaciÃn','I','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'750000000','Otros ingresos de gestiÃn','I','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'760000000','Ingresos financieros','I','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'765000000','Descuentos sobre compras por pronto pago','I','', NULL, false,string_to_array('IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'768000000','Diferencias positivas de cambio','I','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'770000000','Beneficios procedentes de inmovilizados e ingresos excepcionales','I','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'790000000','Excesos y aplicaciones de provisiones','I','', NULL, false,string_to_array('', ':'));
 --
 -- Taxes in Spain
 --


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:[2647] trunk/sql/coa/eg/chart/General.sql
Next by Date: SF.net SVN: ledger-smb:[2649] trunk/sql/coa
Previous by thread: SF.net SVN: ledger-smb:[2647] trunk/sql/coa/eg/chart/General.sql
Next by thread: SF.net SVN: ledger-smb:[2649] trunk/sql/coa
Index(es):
- Date
- Thread