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

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

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

Modified Paths:
--------------
    trunk/sql/coa/hu/chart/Minimal.sql
    trunk/sql/coa/hu/chart/Old-general.sql
    trunk/sql/coa/id/chart/General.sql
    trunk/sql/coa/it/chart/General.sql
    trunk/sql/coa/it/chart/cc2424.sql

Modified: trunk/sql/coa/hu/chart/Minimal.sql
===================================================================
--- trunk/sql/coa/hu/chart/Minimal.sql	2009-06-13 04:42:30 UTC (rev 2677)
+++ trunk/sql/coa/hu/chart/Minimal.sql	2009-06-13 17:43:46 UTC (rev 2678)
@@ -9,33 +9,33 @@
 SELECT account_heading_save(NULL, '5', 'KÃLTSÃGEK', NULL);
 SELECT account_heading_save(NULL, '8', 'RÃFORDÃTÃSOK', NULL);
 SELECT account_heading_save(NULL, '9', 'BEVÃTELEK', NULL);
-SELECT account_save(NULL,'1140','Irodai eszkÃzÃk','114','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1199','Irodai eszkÃzÃk ÃCS','119','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2610','Ãruk ','261','A', NULL, false,string_to_array('IC', ':'));
-SELECT account_save(NULL,'3110','VevÃk','311','A', NULL, false,string_to_array('AR', ':'));
-SELECT account_save(NULL,'3111','KÃlfÃldi vevÃk','311','A', NULL, false,string_to_array('AR', ':'));
-SELECT account_save(NULL,'3810','PÃnztÃr 1','381','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'3811','PÃnztÃr 2','381','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'3840','Bank 1','384','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'3841','Bank 2','384','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'4540','BelfÃldi SzÃllÃtÃk','454','L', NULL, false,string_to_array('AP', ':'));
-SELECT account_save(NULL,'4541','KÃlfÃldi szÃllÃtÃk','454','L', NULL, false,string_to_array('AP', ':'));
-SELECT account_save(NULL,'4660','VisszaigÃnyelhetÃ ÃFA 20%','466','L', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'4661','VisszaigÃnyelhetÃ ÃFA 12%','466','L', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'4662','VisszaigÃnyelhetÃ ÃFA 5%','466','L', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'4663','VisszaigÃnyelhetÃ ÃFA adÃmentes','466','L', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'4670','FizetendÃ ÃFA 20%','467','L', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'4671','FizetendÃ ÃFA 15%','467','L', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'4672','FizetendÃ ÃFA 5%','467','L', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'4673','FizetendÃ ÃFA adÃmentes','467','L', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'5200','BÃrleti dÃj','520','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5210','Telefon','521','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5990','KÃltsÃgek','599','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'8140','Eladott Ãruk beszerzÃsi ÃrtÃke','814','E', NULL, false,string_to_array('IC_cogs', ':'));
-SELECT account_save(NULL,'8700','ÃrfolyamvesztesÃg','870','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'9110','BelfÃldi ÃrbevÃtel','911','I', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
-SELECT account_save(NULL,'9111','KÃlfÃldi ÃrbevÃtel','911','I', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
-SELECT account_save(NULL,'9700','ÃrfolyamnyeresÃg','970','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1140','Irodai eszkÃzÃk','A','114', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1199','Irodai eszkÃzÃk ÃCS','A','119', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2610','Ãruk ','A','261', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'3110','VevÃk','A','311', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'3111','KÃlfÃldi vevÃk','A','311', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'3810','PÃnztÃr 1','A','381', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'3811','PÃnztÃr 2','A','381', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'3840','Bank 1','A','384', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'3841','Bank 2','A','384', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'4540','BelfÃldi SzÃllÃtÃk','L','454', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'4541','KÃlfÃldi szÃllÃtÃk','L','454', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'4660','VisszaigÃnyelhetÃ ÃFA 20%','L','466', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'4661','VisszaigÃnyelhetÃ ÃFA 12%','L','466', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'4662','VisszaigÃnyelhetÃ ÃFA 5%','L','466', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'4663','VisszaigÃnyelhetÃ ÃFA adÃmentes','L','466', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'4670','FizetendÃ ÃFA 20%','L','467', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'4671','FizetendÃ ÃFA 15%','L','467', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'4672','FizetendÃ ÃFA 5%','L','467', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'4673','FizetendÃ ÃFA adÃmentes','L','467', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'5200','BÃrleti dÃj','E','520', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5210','Telefon','E','521', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5990','KÃltsÃgek','E','599', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'8140','Eladott Ãruk beszerzÃsi ÃrtÃke','E','814', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'8700','ÃrfolyamvesztesÃg','E','870', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'9110','BelfÃldi ÃrbevÃtel','I','911', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'9111','KÃlfÃldi ÃrbevÃtel','I','911', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'9700','ÃrfolyamnyeresÃg','I','970', NULL, false,string_to_array('', ':'));
 --
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4660'),'0.20','');
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4661'),'0.15','');

Modified: trunk/sql/coa/hu/chart/Old-general.sql
===================================================================
--- trunk/sql/coa/hu/chart/Old-general.sql	2009-06-13 04:42:30 UTC (rev 2677)
+++ trunk/sql/coa/hu/chart/Old-general.sql	2009-06-13 17:43:46 UTC (rev 2678)
@@ -2,33 +2,6 @@
 --Hungarian chart of accounts 
 -- Magyar fÃkÃnyvi szÃmlÃk, amelyek csak pÃldakÃnt szolgÃlnak
 --
-SELECT account_save(NULL,'1140','Irodai eszkÃzÃk','114','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1199','Irodai eszkÃzÃk ÃCS','119','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2610','Ãruk ','261','A', NULL, false,string_to_array('IC', ':'));
-SELECT account_save(NULL,'3110','VevÃk','311','A', NULL, false,string_to_array('AR', ':'));
-SELECT account_save(NULL,'3111','KÃlfÃldi vevÃk','311','A', NULL, false,string_to_array('AR', ':'));
-SELECT account_save(NULL,'3810','PÃnztÃr 1','381','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'3811','PÃnztÃr 2','381','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'3840','Bank 1','384','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'3841','Bank 2','384','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'4540','BelfÃldi SzÃllÃtÃk','454','L', NULL, false,string_to_array('AP', ':'));
-SELECT account_save(NULL,'4541','KÃlfÃldi szÃllÃtÃk','454','L', NULL, false,string_to_array('AP', ':'));
-SELECT account_save(NULL,'4660','VisszaigÃnyelhetÃ ÃFA 25%','466','L', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'4661','VisszaigÃnyelhetÃ ÃFA 12%','466','L', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'4662','VisszaigÃnyelhetÃ ÃFA 5%','466','L', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'4663','VisszaigÃnyelhetÃ ÃFA adÃmentes','466','L', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'4670','FizetendÃ ÃFA 25%','467','L', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'4671','FizetendÃ ÃFA 15%','467','L', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'4672','FizetendÃ ÃFA 5%','467','L', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'4673','FizetendÃ ÃFA adÃmentes','467','L', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'5200','BÃrleti dÃj','520','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5210','Telefon','521','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5990','KÃltsÃgek','599','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'8140','Eladott Ãruk beszerzÃsi ÃrtÃke','814','E', NULL, false,string_to_array('IC_cogs', ':'));
-SELECT account_save(NULL,'8700','ÃrfolyamvesztesÃg','870','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'9110','BelfÃldi ÃrbevÃtel','911','I', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
-SELECT account_save(NULL,'9111','KÃlfÃldi ÃrbevÃtel','911','I', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
-SELECT account_save(NULL,'9700','ÃrfolyamnyeresÃg','970','I', NULL, false,string_to_array('', ':'));
 SELECT account_heading_save(NULL, '1', 'BEFEKTETETT ESZKÃZÃK', NULL);
 SELECT account_heading_save(NULL, '2', 'KÃSZLETEK', NULL);
 SELECT account_heading_save(NULL, '3', 'KÃVETELÃSEK', NULL);
@@ -36,6 +9,33 @@
 SELECT account_heading_save(NULL, '5', 'KÃLTSÃGEK', NULL);
 SELECT account_heading_save(NULL, '8', 'RÃFORDÃTÃSOK', NULL);
 SELECT account_heading_save(NULL, '9', 'BEVÃTELEK', NULL);
+SELECT account_save(NULL,'1140','Irodai eszkÃzÃk','A','114', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1199','Irodai eszkÃzÃk ÃCS','A','119', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2610','Ãruk ','A','261', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'3110','VevÃk','A','311', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'3111','KÃlfÃldi vevÃk','A','311', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'3810','PÃnztÃr 1','A','381', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'3811','PÃnztÃr 2','A','381', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'3840','Bank 1','A','384', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'3841','Bank 2','A','384', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'4540','BelfÃldi SzÃllÃtÃk','L','454', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'4541','KÃlfÃldi szÃllÃtÃk','L','454', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'4660','VisszaigÃnyelhetÃ ÃFA 25%','L','466', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'4661','VisszaigÃnyelhetÃ ÃFA 12%','L','466', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'4662','VisszaigÃnyelhetÃ ÃFA 5%','L','466', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'4663','VisszaigÃnyelhetÃ ÃFA adÃmentes','L','466', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'4670','FizetendÃ ÃFA 25%','L','467', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'4671','FizetendÃ ÃFA 15%','L','467', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'4672','FizetendÃ ÃFA 5%','L','467', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'4673','FizetendÃ ÃFA adÃmentes','L','467', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'5200','BÃrleti dÃj','E','520', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5210','Telefon','E','521', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5990','KÃltsÃgek','E','599', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'8140','Eladott Ãruk beszerzÃsi ÃrtÃke','E','814', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'8700','ÃrfolyamvesztesÃg','E','870', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'9110','BelfÃldi ÃrbevÃtel','I','911', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'9111','KÃlfÃldi ÃrbevÃtel','I','911', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'9700','ÃrfolyamnyeresÃg','I','970', NULL, false,string_to_array('', ':'));
 --
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4660'),'0.25','');
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4661'),'0.15','');

Modified: trunk/sql/coa/id/chart/General.sql
===================================================================
--- trunk/sql/coa/id/chart/General.sql	2009-06-13 04:42:30 UTC (rev 2677)
+++ trunk/sql/coa/id/chart/General.sql	2009-06-13 17:43:46 UTC (rev 2678)
@@ -1,19 +1,19 @@
 begin;
 -- Default chart of accounts
 -- sample only
-SELECT account_heading_save(NULL,'1000','AKTIVA LANCAR', NULL));
+SELECT account_heading_save(NULL,'1000','AKTIVA LANCAR', NULL);
 SELECT account_save(NULL,'1060','Bank','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'1065','Kas Kecil','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'1200','Piutang','A','', NULL, false,string_to_array('AR', ':'));
-SELECT account_heading_save(NULL,'1500','INVENTORY', NULL));
+SELECT account_heading_save(NULL,'1500','INVENTORY', NULL);
 SELECT account_save(NULL,'1520','Inventory / Umum','A','', NULL, false,string_to_array('IC', ':'));
 SELECT account_save(NULL,'1530','Inventory / Aftermarket Parts','A','', NULL, false,string_to_array('IC', ':'));
-SELECT account_heading_save(NULL,'1800','AKTIVA TETAP', NULL));
+SELECT account_heading_save(NULL,'1800','AKTIVA TETAP', NULL);
 SELECT account_save(NULL,'1820','Perabot Kantor & Peralatan','A','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'1825','Akumulasi Amort. Perabot & Peralatan','A','', NULL, '1',string_to_array('', ':'));
 SELECT account_save(NULL,'1840','Kendaraan','A','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'1845','Akumulasi Amort. Kendaraan','A','', NULL, '1',string_to_array('', ':'));
-SELECT account_heading_save(NULL,'2000','HUTANG LANCAR', NULL));
+SELECT account_heading_save(NULL,'2000','HUTANG LANCAR', NULL);
 SELECT account_save(NULL,'2100','Hutang Dagang','L','', NULL, false,string_to_array('AP', ':'));
 SELECT account_save(NULL,'2160','Hutang Pajak','L','', NULL, false,string_to_array('', ':'));
 --SELECT account_save(NULL,'2190','Federal Income Tax Payable','L','', NULL, false,string_to_array('', ':'));
@@ -25,30 +25,30 @@
 SELECT account_save(NULL,'2310','PPn (10%)','L','', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
 --SELECT account_save(NULL,'2320','VAT (14%)','L','', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
 --SELECT account_save(NULL,'2330','VAT (30%)','L','', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_heading_save(NULL,'2600','HUTANG JANGKA PANJANG', NULL));
+SELECT account_heading_save(NULL,'2600','HUTANG JANGKA PANJANG', NULL);
 SELECT account_save(NULL,'2620','Hutang Bank','L','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'2680','Hutang ke Pemegang Saham','L','', NULL, false,string_to_array('AP_paid', ':'));
-SELECT account_heading_save(NULL,'3300','MODAL', NULL));
+SELECT account_heading_save(NULL,'3300','MODAL', NULL);
 SELECT account_save(NULL,'3350','Modal Umum','Q','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'4000','PENDAPATAN PENJUALAN', NULL));
+SELECT account_heading_save(NULL,'4000','PENDAPATAN PENJUALAN', NULL);
 SELECT account_save(NULL,'4020','Penjualan / General','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
 SELECT account_save(NULL,'4030','Penjualan / Aftermarket Parts','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
-SELECT account_heading_save(NULL,'4300','PENDAPATAN KONSULTASI', NULL));
+SELECT account_heading_save(NULL,'4300','PENDAPATAN KONSULTASI', NULL);
 SELECT account_save(NULL,'4320','Jasa Konsultasi','I','', NULL, false,string_to_array('AR_amount:IC_income', ':'));
-SELECT account_heading_save(NULL,'4400','PENDAPATAN LAIN', NULL));
+SELECT account_heading_save(NULL,'4400','PENDAPATAN LAIN', NULL);
 SELECT account_save(NULL,'4430','Jasa Pengiriman dan Pengepakan','I','', NULL, false,string_to_array('IC_income', ':'));
 SELECT account_save(NULL,'4440','Bunga','I','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'4450','Keuntungan Selisih Kurs','I','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'5000','BIAYA PENJUALAN', NULL));
+SELECT account_heading_save(NULL,'5000','BIAYA PENJUALAN', NULL);
 SELECT account_save(NULL,'5010','Pembelian','E','', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
 SELECT account_save(NULL,'5020','COGS / General','E','', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
 SELECT account_save(NULL,'5030','COGS / Aftermarket Parts','E','', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
 SELECT account_save(NULL,'5100','Ongkos Kirim','E','', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_heading_save(NULL,'5400','BIAYA GAJI', NULL));
+SELECT account_heading_save(NULL,'5400','BIAYA GAJI', NULL);
 SELECT account_save(NULL,'5410','Biaya Gaji','E','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'5420','Biaya Asuransi Karyawan','E','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'5430','Biaya Rencana Pensiun','E','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'5600','BIAYA UMUM DAN ADMINISTRASI', NULL));
+SELECT account_heading_save(NULL,'5600','BIAYA UMUM DAN ADMINISTRASI', NULL);
 SELECT account_save(NULL,'5610','Akunting dan Legalitas','E','', NULL, false,string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'5615','Iklan dan Promosi','E','', NULL, false,string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'5650','Capital Cost Allowance Expense','E','', NULL, false,string_to_array('', ':'));

Modified: trunk/sql/coa/it/chart/General.sql
===================================================================
--- trunk/sql/coa/it/chart/General.sql	2009-06-13 04:42:30 UTC (rev 2677)
+++ trunk/sql/coa/it/chart/General.sql	2009-06-13 17:43:46 UTC (rev 2678)
@@ -13,57 +13,57 @@
 -- ('2001111'5 Invertito i ruoli di ('6470005' e ('6470010' (erano sbagliati)
 -- ('2001111'5 Eliminata l'applicabilita' della RA al cliente test
 -- ('2001112'0 Aggiunto IC_expense al conto ('7005005' (mancava un conto di default per i servizi)
-SELECT account_heading_save(NULL,'2010000','COSTI DI RICERCA, DI SVILUPPO E DI PUBBLICITA\'', NULL));
+SELECT account_heading_save(NULL,'2010000','COSTI DI RICERCA, DI SVILUPPO E DI PUBBLICITA\'', NULL);
 SELECT account_save(NULL,'2010005','Spese di ricerca e di sviluppo','A','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'2010010','Spese di pubblicita\'','A','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'2015000','DIRITTI DI BREV. IND. E DIRITTI DI UTILIZZ DELLE OPERE DELL\'INGEGNO', NULL));
+SELECT account_heading_save(NULL,'2015000','DIRITTI DI BREV. IND. E DIRITTI DI UTILIZZ DELLE OPERE DELL\'INGEGNO', NULL);
 SELECT account_save(NULL,'2015005','Brevetti','A','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'2020005','Concessioni, licenze e diritti simili','A','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'2025005','Avviamento','A','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'2245000','TERRENI E FABBRICATI', NULL));
+SELECT account_heading_save(NULL,'2245000','TERRENI E FABBRICATI', NULL);
 SELECT account_save(NULL,'2245010','Fabbricati civili','A','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'2250000','IMPIANTI E MACCHINARI', NULL));
+SELECT account_heading_save(NULL,'2250000','IMPIANTI E MACCHINARI', NULL);
 SELECT account_save(NULL,'2250005','Impianti generici','A','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'2255000','ATTREZZATURE INDUSTRIALI E COMMERCIALI', NULL));
+SELECT account_heading_save(NULL,'2255000','ATTREZZATURE INDUSTRIALI E COMMERCIALI', NULL);
 SELECT account_save(NULL,'2255005','Attrezzature','A','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'2255010','Mobili','A','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'2255015','Macchine d\'ufficio','A','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'2255025','Autovetture','A','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'3005000','RIMANENZE MATERIE PRIME, SUSSIDIARIE E DI CONSUMO', NULL));
+SELECT account_heading_save(NULL,'3005000','RIMANENZE MATERIE PRIME, SUSSIDIARIE E DI CONSUMO', NULL);
 SELECT account_save(NULL,'3005005','Rimanenze materie prime','A','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'3020000','RIMANENZE PRODOTTI FINITI E MERCI', NULL));
+SELECT account_heading_save(NULL,'3020000','RIMANENZE PRODOTTI FINITI E MERCI', NULL);
 SELECT account_save(NULL,'3020005','Rimanenze prodotti finiti','A','', NULL, false,string_to_array('IC', ':'));
-SELECT account_heading_save(NULL,'4001000','CREDITI VERSO CL. PER FATT. EM. ESIGIBILI ENTRO L\'ESER. SUCC.', NULL));
+SELECT account_heading_save(NULL,'4001000','CREDITI VERSO CL. PER FATT. EM. ESIGIBILI ENTRO L\'ESER. SUCC.', NULL);
 SELECT account_save(NULL,'4001001','Crediti verso clienti per fatture emesse','A','', NULL, false,string_to_array('AR', ':'));
-SELECT account_heading_save(NULL,'4064000','CREDITI VERSO ALTRI - CREDITI D\'IMPOSTA', NULL));
+SELECT account_heading_save(NULL,'4064000','CREDITI VERSO ALTRI - CREDITI D\'IMPOSTA', NULL);
 SELECT account_save(NULL,'4064005','IRPEF acconto','A','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'4064020','IRPEG acconto','A','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'4064800','Credito verso erario per IVA','A','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'4400000','DISPONIBILITA\' LIQUIDE', NULL));
+SELECT account_heading_save(NULL,'4400000','DISPONIBILITA\' LIQUIDE', NULL);
 SELECT account_save(NULL,'4480105','Banca ...c/c','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'4480400','Assegni','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'4480500','Cassa e valori','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_heading_save(NULL,'5005000','CAPITALE', NULL));
+SELECT account_heading_save(NULL,'5005000','CAPITALE', NULL);
 SELECT account_save(NULL,'5005005','Capitale sociale','Q','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'5005010','Versamenti in conto capitale','Q','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'5020000','RISERVA LEGALE', NULL));
+SELECT account_heading_save(NULL,'5020000','RISERVA LEGALE', NULL);
 SELECT account_save(NULL,'5020005','Riserva legale','Q','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'5080000','UTILI (PERDITE) PORTATI A NUOVO', NULL));
+SELECT account_heading_save(NULL,'5080000','UTILI (PERDITE) PORTATI A NUOVO', NULL);
 SELECT account_save(NULL,'5080005','Utili esercizi precedenti','Q','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'5080010','Perdite esercizi precedenti','Q','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'5090000','UTILE (PERDITA) DELL\'ESERCIZIO', NULL));
+SELECT account_heading_save(NULL,'5090000','UTILE (PERDITA) DELL\'ESERCIZIO', NULL);
 SELECT account_save(NULL,'5090005','Utile dell\'esercizio','Q','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'5090010','Perdita dell\'esercizio','Q','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'6200000','TRATTAMENTO DI FINE RAPPORTO DI LAVORO SUBORDINATO', NULL));
+SELECT account_heading_save(NULL,'6200000','TRATTAMENTO DI FINE RAPPORTO DI LAVORO SUBORDINATO', NULL);
 SELECT account_save(NULL,'6220005','Trattamento di fine rapporto di lavoro subordinato','L','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'6220010','Anticipazioni erogate su trattamento di fine rapporto di lavoro subordinato','L','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'6435000','DEBITI VERSO BANCHE ESIGIBILI ENTRO ES. SUCC.', NULL));
+SELECT account_heading_save(NULL,'6435000','DEBITI VERSO BANCHE ESIGIBILI ENTRO ES. SUCC.', NULL);
 SELECT account_save(NULL,'6435005','Banca di ... c/c','L','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'6436000','DEBITI VERSO BANCHE ESIGIBILI OLTRE ES. SUCC.', NULL));
+SELECT account_heading_save(NULL,'6436000','DEBITI VERSO BANCHE ESIGIBILI OLTRE ES. SUCC.', NULL);
 SELECT account_save(NULL,'6436005','Mutuo banca di ...','L','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'6450000','DEBITI VERSO FORNITORI FATT. RICEVUTE ESIGIBILI ENTRO ES. SUCC.', NULL));
+SELECT account_heading_save(NULL,'6450000','DEBITI VERSO FORNITORI FATT. RICEVUTE ESIGIBILI ENTRO ES. SUCC.', NULL);
 SELECT account_save(NULL,'6450001','Debiti verso fornitori per fatture ricevute','L','', NULL, false,string_to_array('AP', ':'));
-SELECT account_heading_save(NULL,'6470000','DEBITI TRIBUTARI', NULL));
+SELECT account_heading_save(NULL,'6470000','DEBITI TRIBUTARI', NULL);
 SELECT account_save(NULL,'6470005','IRPEF dipendenti','L','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'6470010','IRPEF terzi','L','', NULL, false,string_to_array('AP_tax:IC_taxservice', ':'));
 SELECT account_save(NULL,'6470015','IVA da versare','L','', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
@@ -71,12 +71,12 @@
 SELECT account_save(NULL,'6470025','IRPEG sul reddito d\'esercizio','L','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'6470030','ILOR sul reddito d\'esercizio','L','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'6470050','Imposta patrimoniale','L','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'6475000','DEBITI VERSO ISTITUTI PREV. ESIGIBILI ENTRO ES. SUCC.', NULL));
+SELECT account_heading_save(NULL,'6475000','DEBITI VERSO ISTITUTI PREV. ESIGIBILI ENTRO ES. SUCC.', NULL);
 SELECT account_save(NULL,'6475005','INPS','L','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'6475010','INAIL','L','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'6475020','Servizio sanitario nazionale (S.S.N.)','L','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'6475025','ENASARCO','L','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'6480000','ALTRI DEBITI - IVA C/ERARIO', NULL));
+SELECT account_heading_save(NULL,'6480000','ALTRI DEBITI - IVA C/ERARIO', NULL);
 SELECT account_save(NULL,'6480003','IVA su acquisti (4%)','L','', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
 SELECT account_save(NULL,'6480004','IVA su acquisti (10%)','L','', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
 SELECT account_save(NULL,'6480005','IVA su acquisti (20%)','L','', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
@@ -92,10 +92,10 @@
 SELECT account_save(NULL,'6480045','IVA pro-rata indetraibile','L','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'6480050','IVA da contabilitÃ separata','L','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'6480055','IVA c/riepilogativo','L','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'6600000','RATEI E RISCONTI PASSIVI', NULL));
+SELECT account_heading_save(NULL,'6600000','RATEI E RISCONTI PASSIVI', NULL);
 SELECT account_save(NULL,'6690005','Ratei passivi','L','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'6692005','Risconti passivi','L','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'7005000','COSTI PER MATERIE PRIME, SUSSIDIARIE, DI CONSUMO E DI MERCI', NULL));
+SELECT account_heading_save(NULL,'7005000','COSTI PER MATERIE PRIME, SUSSIDIARIE, DI CONSUMO E DI MERCI', NULL);
 SELECT account_save(NULL,'7005005','Materie prime','E','', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
 SELECT account_save(NULL,'7005015','Merci destinate alla rivendita','E','', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
 SELECT account_save(NULL,'7005020','Materiali di consumo destinati alla produzione','E','', NULL, false,string_to_array('AP_amount', ':'));
@@ -104,7 +104,7 @@
 SELECT account_save(NULL,'7005040','Cancelleria','E','', NULL, false,string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'7005045','Materiale pubblicitario','E','', NULL, false,string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'7005050','Carburanti e lubrificanti','E','', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_heading_save(NULL,'7025000','SPESE DI GESTIONE', NULL));
+SELECT account_heading_save(NULL,'7025000','SPESE DI GESTIONE', NULL);
 SELECT account_save(NULL,'7025005','Energia elettrica','E','', NULL, false,string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'7025015','Spese telefoniche','E','', NULL, false,string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'7025025','Spese pubblicitÃ/propaganda','E','', NULL, false,string_to_array('AP_amount', ':'));
@@ -114,45 +114,45 @@
 SELECT account_save(NULL,'7025060','Spese di rappresentanza per servizi interamente detraibili','E','', NULL, false,string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'7025065','Altre spese di rappresentanza','E','', NULL, false,string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'7025100','Altri servizi','E','', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_heading_save(NULL,'7028000','CARBURANTI E LUBRIFICANTI PER AUTOTRAZIONE', NULL));
+SELECT account_heading_save(NULL,'7028000','CARBURANTI E LUBRIFICANTI PER AUTOTRAZIONE', NULL);
 SELECT account_save(NULL,'7028005','Carburanti e lubrificanti autovetture','E','', NULL, false,string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'7028010','Carburanti e lubrificanti autocarri etc.','E','', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_heading_save(NULL,'7030000','COMPENSI PROFESSIONALI', NULL));
+SELECT account_heading_save(NULL,'7030000','COMPENSI PROFESSIONALI', NULL);
 SELECT account_save(NULL,'7030005','Consulenza fiscale e tributaria','E','', NULL, false,string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'7030015','Consulenza legale','E','', NULL, false,string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'7030030','Compenso amministratori','E','', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_heading_save(NULL,'7035000','COSTI PER GODIMENTO BENI DI TERZI', NULL));
+SELECT account_heading_save(NULL,'7035000','COSTI PER GODIMENTO BENI DI TERZI', NULL);
 SELECT account_save(NULL,'7035005','Fitti passivi','E','', NULL, false,string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'7035050','Canoni di leasing','E','', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_heading_save(NULL,'7040000','COSTI PER IL PERSONALE', NULL));
+SELECT account_heading_save(NULL,'7040000','COSTI PER IL PERSONALE', NULL);
 SELECT account_save(NULL,'7040005','Salari e stipendi','E','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'7040010','Oneri sociali INPS','E','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'7040015','Oneri sociali INAIL','E','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'7040020','Oneri sociali C.E.','E','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'7043000','AMMORTAMENTI E SVALUTAZIONI', NULL));
+SELECT account_heading_save(NULL,'7043000','AMMORTAMENTI E SVALUTAZIONI', NULL);
 SELECT account_save(NULL,'7043005','Ammortamenti immobilizzazioni immateriali','E','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'7043100','Ammortamenti immobilizzazioni materiali','E','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'7056000','ONERI DIVERSI DI GESTIONE', NULL));
+SELECT account_heading_save(NULL,'7056000','ONERI DIVERSI DI GESTIONE', NULL);
 SELECT account_save(NULL,'7056010','Imposta di registro, bolli ,CC.GG., etc.','E','', NULL, false,string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'7056015','Imposta camerale','E','', NULL, false,string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'7056025','Tributi locali diversi','E','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'7056040','Tassa possesso autoveicoli','E','', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_heading_save(NULL,'7260000','INTERESSI E ONERI FINANZIARI', NULL));
+SELECT account_heading_save(NULL,'7260000','INTERESSI E ONERI FINANZIARI', NULL);
 SELECT account_save(NULL,'7260020','Interessi passivi bancari','E','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'7260025','Interessi passivi mutui','E','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'7875000','IMPOSTE SUL REDDITO DELL\'ESERCIZIO', NULL));
+SELECT account_heading_save(NULL,'7875000','IMPOSTE SUL REDDITO DELL\'ESERCIZIO', NULL);
 SELECT account_save(NULL,'7875005','IRPEG corrente','E','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'7875020','IRPEG differita','E','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'8005000','RICAVI DELLE VENDITE', NULL));
+SELECT account_heading_save(NULL,'8005000','RICAVI DELLE VENDITE', NULL);
 SELECT account_save(NULL,'8005005','Ricavi cessione beni','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
-SELECT account_heading_save(NULL,'8015000','RICAVI DELLE PRESTAZIONI', NULL));
+SELECT account_heading_save(NULL,'8015000','RICAVI DELLE PRESTAZIONI', NULL);
 SELECT account_save(NULL,'8015005','Ricavi per prestazioni a terzi','I','', NULL, false,string_to_array('AR_amount:IC_income', ':'));
 SELECT account_save(NULL,'8015015','Noleggio impianti e macchinari','I','', NULL, false,string_to_array('AR_amount', ':'));
-SELECT account_heading_save(NULL,'8041000','INCREMENTI IMMOBILIZZAZIONI IMMATERIALI', NULL));
+SELECT account_heading_save(NULL,'8041000','INCREMENTI IMMOBILIZZAZIONI IMMATERIALI', NULL);
 SELECT account_save(NULL,'8041005','Brevetti','I','', NULL, false,string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'8041010','Spese di costituzione societÃ','I','', NULL, false,string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'8041020','Spese pubblicitÃ e propaganda','I','', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_heading_save(NULL,'8045000','ALTRI RICAVI E PROVENTI', NULL));
+SELECT account_heading_save(NULL,'8045000','ALTRI RICAVI E PROVENTI', NULL);
 SELECT account_save(NULL,'8045001','Cessione di materie prime, sussidiarie e semilavorati','I','', NULL, false,string_to_array('AR_amount', ':'));
 --
 -- foreign exchange gain / loss

Modified: trunk/sql/coa/it/chart/cc2424.sql
===================================================================
--- trunk/sql/coa/it/chart/cc2424.sql	2009-06-13 04:42:30 UTC (rev 2677)
+++ trunk/sql/coa/it/chart/cc2424.sql	2009-06-13 17:43:46 UTC (rev 2678)
@@ -25,12 +25,12 @@
 --
 -- E' disponibile un cliente, un fornitore e un articolo di prova.
 --
-SELECT account_heading_save(NULL,'100000','ATTIVO', NULL));
-SELECT account_heading_save(NULL,'101000','IMMOBILIZZAZIONI IMMATERIALI', NULL));
+SELECT account_heading_save(NULL,'100000','ATTIVO', NULL);
+SELECT account_heading_save(NULL,'101000','IMMOBILIZZAZIONI IMMATERIALI', NULL);
 SELECT account_save(NULL,'101001','Costi di impianto e ampliamento','A','1.B.I.1', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'101002','Avviamento','A','1.B.I.5', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'101008','Altre immobilizzazioni immateriali','A','1.B.I.7', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'102000','IMMOBILIZZAZIONI MATERIALI', NULL));
+SELECT account_heading_save(NULL,'102000','IMMOBILIZZAZIONI MATERIALI', NULL);
 SELECT account_save(NULL,'102001','Terreni','A','1.B.II.1', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'102002','Fabbricati non strumentali','A','1.B.II.1', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'102003','Fabbricati','A','1.B.II.1', NULL, false,string_to_array('', ':'));
@@ -45,16 +45,16 @@
 SELECT account_save(NULL,'102024','Fondo ammortamento attrezzature d\'ufficio','A','1.B.II.3', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'102025','Fondo ammortamento arredamento','A','1.B.II.3', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'102026','Fondo ammortamento automezzi','A','1.B.II.3', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'103000','IMMOBILIZZAZIONI FINANZIARIE', NULL));
+SELECT account_heading_save(NULL,'103000','IMMOBILIZZAZIONI FINANZIARIE', NULL);
 SELECT account_save(NULL,'103001','Prestiti a terzi','A','1.B.III.2.d', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'105000','RIMANENZE', NULL));
+SELECT account_heading_save(NULL,'105000','RIMANENZE', NULL);
 SELECT account_save(NULL,'105001','Rimanenze di merci','A','1.C.I.4', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'105002','Rimanenze di imballaggi','A','1.C.I.4', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'105003','Rimanenze di materiali di consumo','A','1.C.I.1', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'105011','Fondo svalutazione magazzino','A','1.C.I.4', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'106000','CLIENTI', NULL));
+SELECT account_heading_save(NULL,'106000','CLIENTI', NULL);
 SELECT account_save(NULL,'106001','Crediti verso clienti','A','1.C.II.1', NULL, false,string_to_array('AR', ':'));
-SELECT account_heading_save(NULL,'111000','CREDITI COMMERCIALI', NULL));
+SELECT account_heading_save(NULL,'111000','CREDITI COMMERCIALI', NULL);
 SELECT account_save(NULL,'111002','Cambiali attive','A','1.C.II.1', NULL, false,string_to_array('AR_paid', ':'));
 SELECT account_save(NULL,'111003','Cambiali allo sconto','A','1.C.II.1', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'111005','Cambiali all\'incasso','A','1.C.II.1', NULL, false,string_to_array('', ':'));
@@ -63,7 +63,7 @@
 SELECT account_save(NULL,'111011','Fatture da emettere','A','1.C.II.1', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'111031','Fondo svalutazione crediti','A','1.C.II.1', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'111032','Fondo rischi su crediti','A','1.C.II.1', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'112000','CREDITI DIVERSI', NULL));
+SELECT account_heading_save(NULL,'112000','CREDITI DIVERSI', NULL);
 SELECT account_save(NULL,'112001','IVA nostro credito  4%','A','1.C.II.5', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
 SELECT account_save(NULL,'112002','IVA nostro credito 10%','A','1.C.II.5', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
 SELECT account_save(NULL,'112004','IVA nostro credito 20%','A','1.C.II.5', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
@@ -73,39 +73,39 @@
 SELECT account_save(NULL,'112072','Crediti v/istituti previdenziali','A','1.C.II.5', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'112073','Crediti per cauzioni','A','1.C.II.5', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'112074','Crediti diversi','A','1.C.II.5', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'113000','VALORI MOBILIARI', NULL));
+SELECT account_heading_save(NULL,'113000','VALORI MOBILIARI', NULL);
 SELECT account_save(NULL,'113001','Titoli','A','1.C.III.6', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'114000','DISPONIBILITA\' LIQUIDE', NULL));
+SELECT account_heading_save(NULL,'114000','DISPONIBILITA\' LIQUIDE', NULL);
 SELECT account_save(NULL,'114001','Banca c/c','A','1.C.IV.1', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'114003','Poste c/c','A','1.C.IV.1', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'114004','Assegni','A','1.C.IV.2', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'114005','Denaro e valori in cassa','A','1.C.IV.3', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_heading_save(NULL,'115000','RATEI E RISCONTI ATTIVI', NULL));
+SELECT account_heading_save(NULL,'115000','RATEI E RISCONTI ATTIVI', NULL);
 SELECT account_save(NULL,'115001','Ratei attivi','A','1.D', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'115002','Risconti attivi','A','1.D', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'200000','PASSIVO', NULL));
-SELECT account_heading_save(NULL,'216000','PATRIMONIO NETTO', NULL));
+SELECT account_heading_save(NULL,'200000','PASSIVO', NULL);
+SELECT account_heading_save(NULL,'216000','PATRIMONIO NETTO', NULL);
 SELECT account_save(NULL,'216001','Patrimonio netto','Q','2.A.I', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'216002','Utile d\'esercizio','Q','2.A.IX', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'216003','Perdita d\'esercizio','Q','2.A.IX', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'217000','FONDO ACCANTONAMENTO RISCHI E ONERI', NULL));
+SELECT account_heading_save(NULL,'217000','FONDO ACCANTONAMENTO RISCHI E ONERI', NULL);
 SELECT account_save(NULL,'217002','Fondo per imposte','L','2.B.2', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'217003','Fondo manutenzioni e riparazioni','L','2.B.3', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'217006','Altri fondi','L','2.B.3', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'218000','TFR LAVORO SUBORDINATO', NULL));
+SELECT account_heading_save(NULL,'218000','TFR LAVORO SUBORDINATO', NULL);
 SELECT account_save(NULL,'218001','Debito per TFRL','L','2.C', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'219000','DEBITI DI FINAZIAMENTO', NULL));
+SELECT account_heading_save(NULL,'219000','DEBITI DI FINAZIAMENTO', NULL);
 SELECT account_save(NULL,'219001','Mutui ipotecari','L','2.D.3', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'219002','Finanziamenti bancari','L','2.D.3', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'219003','Sovvenzioni bancarie','L','2.D.3', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'219004','Banche c/c passivi','L','2.D.3', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'219011','Finanziamenti non bancari','L','2.D.4', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'220000','FORNITORI', NULL));
+SELECT account_heading_save(NULL,'220000','FORNITORI', NULL);
 SELECT account_save(NULL,'220001','Debiti verso fornitori','L','2.D.6', NULL, false,string_to_array('AP', ':'));
-SELECT account_heading_save(NULL,'225000','DEBITI COMMERCIALI', NULL));
+SELECT account_heading_save(NULL,'225000','DEBITI COMMERCIALI', NULL);
 SELECT account_save(NULL,'225002','Cambiali passive','L','2.D.6', NULL, false,string_to_array('AP_paid', ':'));
 SELECT account_save(NULL,'225003','Fatture da ricevere','L','2.D.6', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'226000','DEBITI TRIBUTARI', NULL));
+SELECT account_heading_save(NULL,'226000','DEBITI TRIBUTARI', NULL);
 SELECT account_save(NULL,'226001','IVA nostro debito  4%','L','2.D.13', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
 SELECT account_save(NULL,'226002','IVA nostro debito 10%','L','2.D.13', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
 SELECT account_save(NULL,'226004','IVA nostro debito 20%','L','2.D.13', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
@@ -113,33 +113,33 @@
 SELECT account_save(NULL,'226065','Erario c/ritenute da versarare','L','2.D.13', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'226066','Altri debiti verso l\'erario','L','2.D.13', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'226067','Debiti per imposte','L','2.D.13', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'227000','DEBITI DIVERSI', NULL));
+SELECT account_heading_save(NULL,'227000','DEBITI DIVERSI', NULL);
 SELECT account_save(NULL,'227001','Personale c/retribuzioni','L','2.D.13', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'227002','Personale c/liquidazioni','L','2.D.13', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'227003','Debiti v/istituti previdenziali','L','2.D.12', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'227004','Debiti per cauzioni','L','2.D.13', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'227005','Debiti diversi','L','2.D.13', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'228000','RATEI E RISCONTI PASSIVI', NULL));
+SELECT account_heading_save(NULL,'228000','RATEI E RISCONTI PASSIVI', NULL);
 SELECT account_save(NULL,'228001','Ratei passivi','L','2.E', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'228002','Risconti passivi','L','2.E', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'300000','ALTRI CONTI PATRIMONIALI', NULL));
-SELECT account_heading_save(NULL,'329000','CONTI TRANSITORI E FINALALI', NULL));
+SELECT account_heading_save(NULL,'300000','ALTRI CONTI PATRIMONIALI', NULL);
+SELECT account_heading_save(NULL,'329000','CONTI TRANSITORI E FINALALI', NULL);
 SELECT account_save(NULL,'329006','Istituti previdenziali','A','2.D.12', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'329011','Conto del patrimonio','A','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'329012','Bilancio di apertura','A','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'400000','CONTI D\'ORDINE', NULL));
-SELECT account_heading_save(NULL,'431000','IMPEGNI', NULL));
+SELECT account_heading_save(NULL,'400000','CONTI D\'ORDINE', NULL);
+SELECT account_heading_save(NULL,'431000','IMPEGNI', NULL);
 SELECT account_save(NULL,'431001','Beni da ricevere','A','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'431002','Fornitori per beni da ricevere','A','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'431003','Beni da consegnare','A','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'431004','Clienti per beni da consegnare','A','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'431005','Beni in leasing','L','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'431006','Creditori per beni in leasing','A','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'432000','BENI DI TERZI', NULL));
-SELECT account_heading_save(NULL,'433000','BENI NOSTRI PRESSO TERZI', NULL));
-SELECT account_heading_save(NULL,'434000','RISCHI', NULL));
-SELECT account_heading_save(NULL,'500000','VALORE DELLA PRODUZIONE', NULL));
-SELECT account_heading_save(NULL,'541000','RICAVI VENDITE E PRESTAZIONI', NULL));
+SELECT account_heading_save(NULL,'432000','BENI DI TERZI', NULL);
+SELECT account_heading_save(NULL,'433000','BENI NOSTRI PRESSO TERZI', NULL);
+SELECT account_heading_save(NULL,'434000','RISCHI', NULL);
+SELECT account_heading_save(NULL,'500000','VALORE DELLA PRODUZIONE', NULL);
+SELECT account_heading_save(NULL,'541000','RICAVI VENDITE E PRESTAZIONI', NULL);
 SELECT account_save(NULL,'541001','Vendite di merci','I','3.A.1', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
 SELECT account_save(NULL,'541002','Vendite di imballaggi','I','3.A.1', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
 SELECT account_save(NULL,'541003','Ricavi per prestazione di servizi','I','3.A.1', NULL, false,string_to_array('AR_amount:IC_income', ':'));
@@ -147,19 +147,19 @@
 SELECT account_save(NULL,'541007','Ribassi e abbuoni passivi','I','3.A.1', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'541008','Premi a clienti','I','3.B.9.e', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'541010','Rimborso spese','I','3.A.5', NULL, false,string_to_array('AR_amount', ':'));
-SELECT account_heading_save(NULL,'542000','ALTRI RICAVI E PROVENTI', NULL));
+SELECT account_heading_save(NULL,'542000','ALTRI RICAVI E PROVENTI', NULL);
 SELECT account_save(NULL,'542001','Ricavi e proventi vari','I','3.A.5', NULL, false,string_to_array('AR_amount', ':'));
 SELECT account_save(NULL,'542002','Fitti attivi','I','3.A.5', NULL, false,string_to_array('AR_amount', ':'));
 SELECT account_save(NULL,'542003','Arrotondamenti positivi','I','3.A.5', NULL, false,string_to_array('AR_amount', ':'));
-SELECT account_heading_save(NULL,'600000','COSTI DELLA PRODUZIONE', NULL));
-SELECT account_heading_save(NULL,'645000','COSTI ACQUISTO MERCI E MATERIALI DI CONSUMO', NULL));
-SELECT account_save(NULL,'645001','Acquisti di merci','E','3.B.6', NULL, false,string_to_array('AP_amount:IC', ':'));
-SELECT account_save(NULL,'645002','Acquisti di imballaggi','E','3.B.6', NULL, false,string_to_array('AP_amount:IC', ':'));
-SELECT account_save(NULL,'645003','Acquisti di materiali di consumo','E','3.B.6', NULL, false,string_to_array('AP_amount:IC', ':'));
+SELECT account_heading_save(NULL,'600000','COSTI DELLA PRODUZIONE', NULL);
+SELECT account_heading_save(NULL,'645000','COSTI ACQUISTO MERCI E MATERIALI DI CONSUMO', NULL);
+SELECT account_save(NULL,'645001','Acquisti di merci','E','3.B.6', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'645002','Acquisti di imballaggi','E','3.B.6', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'645003','Acquisti di materiali di consumo','E','3.B.6', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
 SELECT account_save(NULL,'645006','Resi su acquisti','E','3.B.6', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'645007','Ribassi e abbuoni attivi','E','3.B.6', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'645008','Premi da fornitori','E','3.A.5', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'646000','COSTI PER PRESTAZIONI E SERVIZI', NULL));
+SELECT account_heading_save(NULL,'646000','COSTI PER PRESTAZIONI E SERVIZI', NULL);
 SELECT account_save(NULL,'646001','Costi di trasporto','E','3.B.7', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
 SELECT account_save(NULL,'646002','Costi di energia','E','3.B.7', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
 SELECT account_save(NULL,'646003','Costi di pubblicita\'','E','3.B.7', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
@@ -173,30 +173,30 @@
 SELECT account_save(NULL,'646011','IVA c/omaggi','E','3.B.9.e', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'646021','Provvigioni passive','E','3.B.9.e', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'646022','Competenze a terzi','E','3.B.9.e', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'647000','COSTI PER GODIMENTO BENI DI TERZI', NULL));
+SELECT account_heading_save(NULL,'647000','COSTI PER GODIMENTO BENI DI TERZI', NULL);
 SELECT account_save(NULL,'647001','Fitti passivi','E','3.B.8', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'647002','Canoni leasing','E','3.B.8', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'648000','COSTI PER IL PERSONALE', NULL));
+SELECT account_heading_save(NULL,'648000','COSTI PER IL PERSONALE', NULL);
 SELECT account_save(NULL,'648001','Salari e stipendi','E','3.B.9.a', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'648002','Oneri sociali','E','3.B.9.b', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'648003','Trattamenti di fine rapporto di lavoro','E','3.B.9.c', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'648004','Trattamenti di quiescenza e simili','E','3.B.9.d', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'648005','Altri costi per il personale','E','3.B.9.e', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'649000','AMMORTAMENTO IMMOBILIZZAZIONI IMMATERIALI', NULL));
+SELECT account_heading_save(NULL,'649000','AMMORTAMENTO IMMOBILIZZAZIONI IMMATERIALI', NULL);
 SELECT account_save(NULL,'649001','Ammortamento impianto e ampliamento','E','3.B.10.a', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'649002','Ammortamento avviamento','E','3.B.10.a', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'649008','Ammortamento di altre immobilizzazioni immateriali','E','3.B.10.a', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'650000','AMMORTAMENTO IMMOBILIZZAZIONI MATERIALI', NULL));
+SELECT account_heading_save(NULL,'650000','AMMORTAMENTO IMMOBILIZZAZIONI MATERIALI', NULL);
 SELECT account_save(NULL,'650001','Ammortamento fabbricati','E','3.B.10.b', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'650002','Ammortamento impianti e macchinari','E','3.B.10.b', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'650003','Ammortamento attrezzature commerciali','E','3.B.10.b', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'650005','Ammortamento attrezzature d\'ufficio','E','3.B.10.b', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'650006','Ammortamento arredamento','E','3.B.10.b', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'650007','Ammortamento automezzi','E','3.B.10.b', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'651000','SVALUTAZIONI', NULL));
+SELECT account_heading_save(NULL,'651000','SVALUTAZIONI', NULL);
 SELECT account_save(NULL,'651003','Svalutazione magazzino','E','3.B.11', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'651004','Svalutazione crediti','E','3.B.12', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'652000','ESISTENZA INIZIALE E RIMANENZE FINALI', NULL));
+SELECT account_heading_save(NULL,'652000','ESISTENZA INIZIALE E RIMANENZE FINALI', NULL);
 SELECT account_save(NULL,'652001','Esistenza iniziale merci','E','3.A.2', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'652002','Esistenza iniziale imballaggi','E','3.A.2', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'652003','Esistenza iniziale materie di consumo','E','3.A.2', NULL, false,string_to_array('', ':'));
@@ -206,15 +206,15 @@
 SELECT account_save(NULL,'652021','Variazioni merci','E','3.A.2', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'652022','Variazioni imballaggi','E','3.A.2', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'652023','Variazioni materie di consumo','E','3.A.2', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'653000','ACCANTONAMENTI PER RISCHI', NULL));
+SELECT account_heading_save(NULL,'653000','ACCANTONAMENTI PER RISCHI', NULL);
 SELECT account_save(NULL,'653001','Accantonamenti per rischi su crediti','E','3.B.12', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'653002','Accantonamenti su imposte','E','3.B.13', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'653004','Altri accantonamenti rischi-oneri','E','3.B.12', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'654000','ALTRI ACCANTONAMENTI', NULL));
+SELECT account_heading_save(NULL,'654000','ALTRI ACCANTONAMENTI', NULL);
 SELECT account_save(NULL,'654001','Accantonamenti per spese future','E','3.B.13', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'654005','Accantonamenti per manutenzioni e riparazioni','E','3.B.13', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'654006','Altri accantonamenti','E','3.B.13', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'655000','ONERI DIVERSI', NULL));
+SELECT account_heading_save(NULL,'655000','ONERI DIVERSI', NULL);
 SELECT account_save(NULL,'655001','Imposta di bollo','E','3.B.14', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'655002','Tassa di concessione governativa','E','3.B.14', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'655003','Imposte comunali','E','3.B.14', NULL, false,string_to_array('', ':'));
@@ -222,7 +222,7 @@
 SELECT account_save(NULL,'655006','Perdite su crediti','E','3.B.14', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'655011','Oneri e perdite varie','E','3.B.14', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'655012','Arrotondamenti negativi','E','3.B.14', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'700000','PROVENTI E ONERI FINANZIARI', NULL));
+SELECT account_heading_save(NULL,'700000','PROVENTI E ONERI FINANZIARI', NULL);
 SELECT account_save(NULL,'756000','PROVENTI FINANZIARI','I','', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'756001','Interessi attivi da banche','I','3.C.16.d', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'756002','Interessi attivi da clienti','I','3.C.16.d', NULL, false,string_to_array('', ':'));
@@ -230,7 +230,7 @@
 SELECT account_save(NULL,'756004','Interessi su titoli','I','3.C.16.d', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'756011','Proventi finanziari vari','I','3.C.16.d', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'756012','Utile su titoli','I','3.C.16.b', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'757000','ONERI FINANZIARI', NULL));
+SELECT account_heading_save(NULL,'757000','ONERI FINANZIARI', NULL);
 SELECT account_save(NULL,'757001','Interessi passivi a banche','I','3.C.17', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'757002','Interessi passivi a fornitori','I','3.C.17', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'757003','Interessi passivi su finanziamenti','I','3.C.17', NULL, false,string_to_array('', ':'));
@@ -238,14 +238,14 @@
 SELECT account_save(NULL,'757005','Interessi passivi vari','I','3.C.17', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'757011','Oneri finanziari vari','I','3.C.17', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'757012','Perdite su titoli','I','3.C.17', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'800000','PROVENTI E ONERI STRAORDINARI', NULL));
-SELECT account_heading_save(NULL,'860000','PROVENTI STRAORDINARI', NULL));
+SELECT account_heading_save(NULL,'800000','PROVENTI E ONERI STRAORDINARI', NULL);
+SELECT account_heading_save(NULL,'860000','PROVENTI STRAORDINARI', NULL);
 SELECT account_save(NULL,'860001','Plusvalenze','I','3.E.20', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'860002','Sopravvenienze e insussistenze attive','I','3.E.20', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'861000','ONERI STRAORDINARI', NULL));
+SELECT account_heading_save(NULL,'861000','ONERI STRAORDINARI', NULL);
 SELECT account_save(NULL,'861001','Minusvalenze','I','3.E.21', NULL, false,string_to_array('', ':'));
 SELECT account_save(NULL,'861002','Sopravvenienze e insussistenze passive','I','3.E.21', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'900000','CONTI DI RIEPILOGO ECONOMICI', NULL));
+SELECT account_heading_save(NULL,'900000','CONTI DI RIEPILOGO ECONOMICI', NULL);
 SELECT account_save(NULL,'970001','Conto del risultato economico','I','3.E.23', NULL, false,string_to_array('', ':'));
 
 INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '112001'), 0.04);


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