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

Subject: SF.net SVN: ledger-smb:[4913] trunk/sql/coa
From: ..hidden..
Date: Mon, 18 Jun 2012 12:25:29 +0000
Revision: 4913
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4913&view=rev
Author:   einhverfr
Date:     2012-06-18 12:25:28 +0000 (Mon, 18 Jun 2012)
Log Message:
-----------
sql coa changes due to account__save syntax change

Modified Paths:
--------------
    trunk/sql/coa/Sample-chart.sql
    trunk/sql/coa/ar/chart/General.sql
    trunk/sql/coa/ar/chart/Personal.sql
    trunk/sql/coa/at/chart/General.sql
    trunk/sql/coa/au/chart/General-0000.sql
    trunk/sql/coa/au/chart/General-00000.sql
    trunk/sql/coa/be/chart/General.sql
    trunk/sql/coa/br/chart/General.sql
    trunk/sql/coa/ca/chart/English_General.sql
    trunk/sql/coa/ca/chart/French-Quebec_General.sql
    trunk/sql/coa/ch/chart/German.sql
    trunk/sql/coa/cn/chart/General.sql
    trunk/sql/coa/co/chart/PUC.sql
    trunk/sql/coa/cz/chart/General.sql
    trunk/sql/coa/de/chart/DATEV-SKR03.sql
    trunk/sql/coa/de/chart/General.sql
    trunk/sql/coa/de/chart/SKR03.sql
    trunk/sql/coa/dk/chart/General.sql
    trunk/sql/coa/eg/chart/General.sql
    trunk/sql/coa/es/chart/General.sql
    trunk/sql/coa/es/chart/ISO.sql
    trunk/sql/coa/fr/chart/General.sql
    trunk/sql/coa/hu/chart/Complete.sql
    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
    trunk/sql/coa/lv/chart/General.sql
    trunk/sql/coa/nl/chart/General.sql
    trunk/sql/coa/nl/chart/Simple.sql
    trunk/sql/coa/no/chart/General.sql
    trunk/sql/coa/pl/chart/General.sql
    trunk/sql/coa/se/chart/Agriculture.sql
    trunk/sql/coa/se/chart/Church_Society.sql
    trunk/sql/coa/se/chart/General.sql
    trunk/sql/coa/tw/chart/General.sql
    trunk/sql/coa/uk/chart/General.sql
    trunk/sql/coa/us/chart/General.sql
    trunk/sql/coa/us/chart/Manufacturing.sql
    trunk/sql/coa/us/chart/Service.sql
    trunk/sql/coa/us/chart/UCOA-Form990.sql
    trunk/sql/coa/us/chart/UCOA-Form990EZ.sql
    trunk/sql/coa/ve/chart/General.sql

Modified: trunk/sql/coa/Sample-chart.sql
===================================================================
--- trunk/sql/coa/Sample-chart.sql	2012-06-18 12:06:54 UTC (rev 4912)
+++ trunk/sql/coa/Sample-chart.sql	2012-06-18 12:25:28 UTC (rev 4913)
@@ -2,75 +2,75 @@
 -- Default chart of accounts
 -- sample only
 SELECT account_heading_save(NULL, '1000', 'CURRENT ASSETS', NULL);
-SELECT account_save(NULL,'1060','Checking Account','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'), false);
-SELECT account_save(NULL,'1065','Petty Cash','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'), false);
-SELECT account_save(NULL,'1200','Accounts Receivables','A','', NULL, false,string_to_array('AR', ':'), false);
-SELECT account_save(NULL,'1205','Allowance for doubtful accounts','A','', NULL, false,string_to_array('', ':'), false);
+SELECT account__save(NULL,'1060','Checking Account','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'), false, false);
+SELECT account__save(NULL,'1065','Petty Cash','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'), false, false);
+SELECT account__save(NULL,'1200','Accounts Receivables','A','', NULL, false,string_to_array('AR', ':'), false, false);
+SELECT account__save(NULL,'1205','Allowance for doubtful accounts','A','', NULL, false,string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '1500', 'INVENTORY ASSETS', NULL);
-SELECT account_save(NULL,'1520','Inventory / General','A','', NULL, false,string_to_array('IC', ':'), false);
-SELECT account_save(NULL,'1530','Inventory / Aftermarket Parts','A','', NULL, false,string_to_array('IC', ':'), false);
+SELECT account__save(NULL,'1520','Inventory / General','A','', NULL, false,string_to_array('IC', ':'), false, false);
+SELECT account__save(NULL,'1530','Inventory / Aftermarket Parts','A','', NULL, false,string_to_array('IC', ':'), false, false);
 SELECT account_heading_save(NULL, '1800', 'CAPITAL ASSETS', NULL);
-SELECT account_save(NULL,'1820','Office Furniture & Equipment','A','', NULL, false,string_to_array('', ':'), false);
-SELECT account_save(NULL,'1825','Accum. Amort. -Furn. & Equip.','A','', NULL, true,string_to_array('',':'), false);
-SELECT account_save(NULL,'1840','Vehicle','A','', NULL, false,string_to_array('', ':'), false);
-SELECT account_save(NULL,'1845','Accum. Amort. -Vehicle','A','', NULL, true,string_to_array('',':'), false);
+SELECT account__save(NULL,'1820','Office Furniture & Equipment','A','', NULL, false,string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'1825','Accum. Amort. -Furn. & Equip.','A','', NULL, true,string_to_array('',':'), false, false);
+SELECT account__save(NULL,'1840','Vehicle','A','', NULL, false,string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'1845','Accum. Amort. -Vehicle','A','', NULL, true,string_to_array('',':'), false, false);
 SELECT account_heading_save(NULL, '2000', 'CURRENT LIABILITIES', NULL);
-SELECT account_save(NULL,'2100','Accounts Payable','L','', NULL, false,string_to_array('AP', ':'), false);
-SELECT account_save(NULL,'2160','Corporate Taxes Payable','L','', NULL, false,string_to_array('', ':'), false);
-SELECT account_save(NULL,'2190','Federal Income Tax Payable','L','', NULL, false,string_to_array('', ':'), false);
-SELECT account_save(NULL,'2210','Workers Comp Payable','L','', NULL, false,string_to_array('', ':'), false);
-SELECT account_save(NULL,'2220','Vacation Pay Payable','L','', NULL, false,string_to_array('', ':'), false);
-SELECT account_save(NULL,'2250','Pension Plan Payable','L','', NULL, false,string_to_array('', ':'), false);
-SELECT account_save(NULL,'2260','Employment Insurance Payable','L','', NULL, false,string_to_array('', ':'), false);
-SELECT account_save(NULL,'2280','Payroll Taxes Payable','L','', NULL, false,string_to_array('', ':'), false);
-SELECT account_save(NULL,'2310','VAT (10%)','L','', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'), false);
-SELECT account_save(NULL,'2320','VAT (14%)','L','', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'), false);
-SELECT account_save(NULL,'2330','VAT (30%)','L','', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'), false);
+SELECT account__save(NULL,'2100','Accounts Payable','L','', NULL, false,string_to_array('AP', ':'), false, false);
+SELECT account__save(NULL,'2160','Corporate Taxes Payable','L','', NULL, false,string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'2190','Federal Income Tax Payable','L','', NULL, false,string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'2210','Workers Comp Payable','L','', NULL, false,string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'2220','Vacation Pay Payable','L','', NULL, false,string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'2250','Pension Plan Payable','L','', NULL, false,string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'2260','Employment Insurance Payable','L','', NULL, false,string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'2280','Payroll Taxes Payable','L','', NULL, false,string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'2310','VAT (10%)','L','', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'), false, false);
+SELECT account__save(NULL,'2320','VAT (14%)','L','', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'), false, false);
+SELECT account__save(NULL,'2330','VAT (30%)','L','', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'), false, false);
 SELECT account_heading_save(NULL, '2600', 'LONG TERM LIABILITIES', NULL);
-SELECT account_save(NULL,'2620','Bank Loans','L','', NULL, false,string_to_array('', ':'), false);
-SELECT account_save(NULL,'2680','Loans from Shareholders','L','', NULL, false,string_to_array('AP_paid', ':'), false);
+SELECT account__save(NULL,'2620','Bank Loans','L','', NULL, false,string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'2680','Loans from Shareholders','L','', NULL, false,string_to_array('AP_paid', ':'), false, false);
 SELECT account_heading_save(NULL, '3300', 'SHARE CAPITAL', NULL);
-SELECT account_save(NULL,'3350','Common Shares','Q','', NULL, false,string_to_array('', ':'), false);
+SELECT account__save(NULL,'3350','Common Shares','Q','', NULL, false,string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '4000', 'SALES REVENUE', NULL);
-SELECT account_save(NULL,'4020','Sales / General','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'), false);
-SELECT account_save(NULL,'4030','Sales / Aftermarket Parts','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'), false);
+SELECT account__save(NULL,'4020','Sales / General','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'), false, false);
+SELECT account__save(NULL,'4030','Sales / Aftermarket Parts','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'), false, false);
 SELECT account_heading_save(NULL, '4300', 'CONSULTING REVENUE', NULL);
-SELECT account_save(NULL,'4320','Consulting','I','', NULL, false,string_to_array('AR_amount:IC_income', ':'), false);
+SELECT account__save(NULL,'4320','Consulting','I','', NULL, false,string_to_array('AR_amount:IC_income', ':'), false, false);
 SELECT account_heading_save(NULL, '4400', 'OTHER REVENUE', NULL);
-SELECT account_save(NULL,'4430','Shipping & Handling','I','', NULL, false,string_to_array('IC_income', ':'), false);
-SELECT account_save(NULL,'4440','Interest','I','', NULL, false,string_to_array('', ':'), false);
-SELECT account_save(NULL,'4450','Foreign Exchange Gain','I','', NULL, false,string_to_array('', ':'), false);
+SELECT account__save(NULL,'4430','Shipping & Handling','I','', NULL, false,string_to_array('IC_income', ':'), false, false);
+SELECT account__save(NULL,'4440','Interest','I','', NULL, false,string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'4450','Foreign Exchange Gain','I','', NULL, false,string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '5000', 'COST OF GOODS SOLD', NULL);
-SELECT account_save(NULL,'5010','Purchases','E','', NULL, false,string_to_array('AP_amount:IC_expense', ':'), false);
-SELECT account_save(NULL,'5020','COGS / General','E','', NULL, false,string_to_array('AP_amount:IC_cogs', ':'), false);
-SELECT account_save(NULL,'5030','COGS / Aftermarket Parts','E','', NULL, false,string_to_array('AP_amount:IC_cogs', ':'), false);
-SELECT account_save(NULL,'5100','Freight','E','', NULL, false,string_to_array('AP_amount:IC_expense', ':'), false);
+SELECT account__save(NULL,'5010','Purchases','E','', NULL, false,string_to_array('AP_amount:IC_expense', ':'), false, false);
+SELECT account__save(NULL,'5020','COGS / General','E','', NULL, false,string_to_array('AP_amount:IC_cogs', ':'), false, false);
+SELECT account__save(NULL,'5030','COGS / Aftermarket Parts','E','', NULL, false,string_to_array('AP_amount:IC_cogs', ':'), false, false);
+SELECT account__save(NULL,'5100','Freight','E','', NULL, false,string_to_array('AP_amount:IC_expense', ':'), false, false);
 SELECT account_heading_save(NULL, '5400', 'PAYROLL EXPENSES', NULL);
-SELECT account_save(NULL,'5410','Wages & Salaries','E','', NULL, false,string_to_array('', ':'), false);
-SELECT account_save(NULL,'5420','Employment Insurance Expense','E','', NULL, false,string_to_array('', ':'), false);
-SELECT account_save(NULL,'5430','Pension Plan Expense','E','', NULL, false,string_to_array('', ':'), false);
-SELECT account_save(NULL,'5440','Workers Comp Expense','E','', NULL, false,string_to_array('', ':'), false);
-SELECT account_save(NULL,'5470','Employee Benefits','E','', NULL, false,string_to_array('', ':'), false);
+SELECT account__save(NULL,'5410','Wages & Salaries','E','', NULL, false,string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'5420','Employment Insurance Expense','E','', NULL, false,string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'5430','Pension Plan Expense','E','', NULL, false,string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'5440','Workers Comp Expense','E','', NULL, false,string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'5470','Employee Benefits','E','', NULL, false,string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '5600', 'GENERAL & ADMINISTRATIVE EXPENSES', NULL);
-SELECT account_save(NULL,'5610','Accounting & Legal','E','', NULL, false,string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL,'5615','Advertising & Promotions','E','', NULL, false,string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL,'5620','Bad Debts','E','', NULL, false,string_to_array('', ':'), false);
-SELECT account_save(NULL,'5650','Capital Cost Allowance Expense','E','', NULL, false,string_to_array('', ':'), false);
-SELECT account_save(NULL,'5660','Amortization Expense','E','', NULL, false,string_to_array('', ':'), false);
-SELECT account_save(NULL,'5680','Income Taxes','E','', NULL, false,string_to_array('', ':'), false);
-SELECT account_save(NULL,'5685','Insurance','E','', NULL, false,string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL,'5690','Interest & Bank Charges','E','', NULL, false,string_to_array('', ':'), false);
-SELECT account_save(NULL,'5700','Office Supplies','E','', NULL, false,string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL,'5760','Rent','E','', NULL, false,string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL,'5765','Repair & Maintenance','E','', NULL, false,string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL,'5780','Telephone','E','', NULL, false,string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL,'5785','Travel & Entertainment','E','', NULL, false,string_to_array('', ':'), false);
-SELECT account_save(NULL,'5790','Utilities','E','', NULL, false,string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL,'5795','Registrations','E','', NULL, false,string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL,'5800','Licenses','E','', NULL, false,string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL,'5810','Foreign Exchange Loss','E','', NULL, false,string_to_array('', ':'), false);
+SELECT account__save(NULL,'5610','Accounting & Legal','E','', NULL, false,string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL,'5615','Advertising & Promotions','E','', NULL, false,string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL,'5620','Bad Debts','E','', NULL, false,string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'5650','Capital Cost Allowance Expense','E','', NULL, false,string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'5660','Amortization Expense','E','', NULL, false,string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'5680','Income Taxes','E','', NULL, false,string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'5685','Insurance','E','', NULL, false,string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL,'5690','Interest & Bank Charges','E','', NULL, false,string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'5700','Office Supplies','E','', NULL, false,string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL,'5760','Rent','E','', NULL, false,string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL,'5765','Repair & Maintenance','E','', NULL, false,string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL,'5780','Telephone','E','', NULL, false,string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL,'5785','Travel & Entertainment','E','', NULL, false,string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'5790','Utilities','E','', NULL, false,string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL,'5795','Registrations','E','', NULL, false,string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL,'5800','Licenses','E','', NULL, false,string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL,'5810','Foreign Exchange Loss','E','', NULL, false,string_to_array('', ':'), false, false);
  
-SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
 FROM account WHERE id IN (select account_id FROM account_link
                            WHERE description = 'AP_paid');
 --

Modified: trunk/sql/coa/ar/chart/General.sql
===================================================================
--- trunk/sql/coa/ar/chart/General.sql	2012-06-18 12:06:54 UTC (rev 4912)
+++ trunk/sql/coa/ar/chart/General.sql	2012-06-18 12:25:28 UTC (rev 4913)
@@ -2,133 +2,133 @@
 -- Plan de Cuenta para SRL Argentina
 -- Sumario
 SELECT account_heading_save(NULL, '0.','SUMARIO',NULL);
-SELECT account_save(NULL, '0.01','A Cobrar','A','', (SELECT id FROM account WHERE accno LIKE '0.'), false, false, string_to_array('AR', ':'), false);
-SELECT account_save(NULL, '0.02','A Pagar','A','', (SELECT id FROM account WHERE accno LIKE '0.'), false, false, string_to_array('AP', ':'), false);
-SELECT account_save(NULL, '0.03','Inventario','A','', (SELECT id FROM account WHERE accno LIKE '0.'), false, false, string_to_array('IC', ':'), false);
+SELECT account__save(NULL, '0.01','A Cobrar','A','', (SELECT id FROM account WHERE accno LIKE '0.'), false, false, string_to_array('AR', ':'), false, false);
+SELECT account__save(NULL, '0.02','A Pagar','A','', (SELECT id FROM account WHERE accno LIKE '0.'), false, false, string_to_array('AP', ':'), false, false);
+SELECT account__save(NULL, '0.03','Inventario','A','', (SELECT id FROM account WHERE accno LIKE '0.'), false, false, string_to_array('IC', ':'), false, false);
 -- Activo
 SELECT account_heading_save(NULL, '1.','ACTIVO',NULL);
 SELECT account_heading_save(NULL, '1.1.','CORRIENTE',(SELECT id FROM account_heading WHERE accno LIKE '1.'));
 SELECT account_heading_save(NULL, '1.1.1.','CAJAS - BANCOS',(SELECT id FROM account_heading WHERE accno LIKE '1.1.'));
-SELECT account_save(NULL, '1.1.1.01','Caja Chica Suc1','A','', (SELECT id FROM account WHERE accno LIKE '1.1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false);
-SELECT account_save(NULL, '1.1.1.02','Caja Chica Suc2','A','', (SELECT id FROM account WHERE accno LIKE '1.1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false);
-SELECT account_save(NULL, '1.1.1.10','Tesoreria','A','', (SELECT id FROM account WHERE accno LIKE '1.1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false);
-SELECT account_save(NULL, '1.1.1.20','Caja Ahorro Banco1','A','', (SELECT id FROM account WHERE accno LIKE '1.1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false);
-SELECT account_save(NULL, '1.1.1.21','Caja Ahorro Banco2','A','', (SELECT id FROM account WHERE accno LIKE '1.1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false);
-SELECT account_save(NULL, '1.1.1.30','Cuenta Corriente Banco1','A','', (SELECT id FROM account WHERE accno LIKE '1.1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false);
-SELECT account_save(NULL, '1.1.1.31','Cuenta Corriente Banco2','A','', (SELECT id FROM account WHERE accno LIKE '1.1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false);
+SELECT account__save(NULL, '1.1.1.01','Caja Chica Suc1','A','', (SELECT id FROM account WHERE accno LIKE '1.1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
+SELECT account__save(NULL, '1.1.1.02','Caja Chica Suc2','A','', (SELECT id FROM account WHERE accno LIKE '1.1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
+SELECT account__save(NULL, '1.1.1.10','Tesoreria','A','', (SELECT id FROM account WHERE accno LIKE '1.1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
+SELECT account__save(NULL, '1.1.1.20','Caja Ahorro Banco1','A','', (SELECT id FROM account WHERE accno LIKE '1.1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
+SELECT account__save(NULL, '1.1.1.21','Caja Ahorro Banco2','A','', (SELECT id FROM account WHERE accno LIKE '1.1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
+SELECT account__save(NULL, '1.1.1.30','Cuenta Corriente Banco1','A','', (SELECT id FROM account WHERE accno LIKE '1.1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
+SELECT account__save(NULL, '1.1.1.31','Cuenta Corriente Banco2','A','', (SELECT id FROM account WHERE accno LIKE '1.1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
 SELECT account_heading_save(NULL, '1.1.2.','CREDITO A CLIENTES',(SELECT id FROM account_heading WHERE accno LIKE '1.1.'));
-SELECT account_save(NULL, '1.1.2.01','Cliente1','A','', (SELECT id FROM account WHERE accno LIKE '1.1.2.'), false, false, string_to_array('AR_overpayment:AR_amount', ':'), false);
-SELECT account_save(NULL, '1.1.2.02','Cliente2','A','', (SELECT id FROM account WHERE accno LIKE '1.1.2.'), false, false, string_to_array('AR_overpayment:AR_amount', ':'), false);
-SELECT account_save(NULL, '1.1.2.03','Cliente3','A','', (SELECT id FROM account WHERE accno LIKE '1.1.2.'), false, false, string_to_array('AR_overpayment:AR_amount', ':'), false);
-SELECT account_save(NULL, '1.1.2.04','Cliente4','A','', (SELECT id FROM account WHERE accno LIKE '1.1.2.'), false, false, string_to_array('AR_overpayment:AR_amount', ':'), false);
+SELECT account__save(NULL, '1.1.2.01','Cliente1','A','', (SELECT id FROM account WHERE accno LIKE '1.1.2.'), false, false, string_to_array('AR_overpayment:AR_amount', ':'), false, false);
+SELECT account__save(NULL, '1.1.2.02','Cliente2','A','', (SELECT id FROM account WHERE accno LIKE '1.1.2.'), false, false, string_to_array('AR_overpayment:AR_amount', ':'), false, false);
+SELECT account__save(NULL, '1.1.2.03','Cliente3','A','', (SELECT id FROM account WHERE accno LIKE '1.1.2.'), false, false, string_to_array('AR_overpayment:AR_amount', ':'), false, false);
+SELECT account__save(NULL, '1.1.2.04','Cliente4','A','', (SELECT id FROM account WHERE accno LIKE '1.1.2.'), false, false, string_to_array('AR_overpayment:AR_amount', ':'), false, false);
 SELECT account_heading_save(NULL, '1.1.3.','RIESGO DE CREDITO',(SELECT id FROM account_heading WHERE accno LIKE '1.1.'));
-SELECT account_save(NULL, '1.1.3.01','Incobrables','A','', (SELECT id FROM account WHERE accno LIKE '1.1.3.'), false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL, '1.1.3.01','Incobrables','A','', (SELECT id FROM account WHERE accno LIKE '1.1.3.'), false, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '1.1.4.','OTROS A COBRAR	 ',(SELECT id FROM account_heading WHERE accno LIKE '1.1.'));
-SELECT account_save(NULL, '1.1.4.01','Anticipos a empleados','A','', (SELECT id FROM account WHERE accno LIKE '1.1.4.'), false, false, string_to_array('', ':'), false);
-SELECT account_save(NULL, '1.1.4.02','Anticipos a proveedores','A','', (SELECT id FROM account WHERE accno LIKE '1.1.4.'), false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL, '1.1.4.01','Anticipos a empleados','A','', (SELECT id FROM account WHERE accno LIKE '1.1.4.'), false, false, string_to_array('', ':'), false, false);
+SELECT account__save(NULL, '1.1.4.02','Anticipos a proveedores','A','', (SELECT id FROM account WHERE accno LIKE '1.1.4.'), false, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '1.1.5.','IMPUESTOS A FAVOR',(SELECT id FROM account_heading WHERE accno LIKE '1.1.'));
-SELECT account_save(NULL, '1.1.5.01','IVA','A','', (SELECT id FROM account WHERE accno LIKE '1.1.5.'), false, true, string_to_array('AP_tax', ':'), false);
+SELECT account__save(NULL, '1.1.5.01','IVA','A','', (SELECT id FROM account WHERE accno LIKE '1.1.5.'), false, true, string_to_array('AP_tax', ':'), false, false);
 SELECT account_heading_save(NULL, '1.1.6.','INVENTARIO',(SELECT id FROM account_heading WHERE accno LIKE '1.1.'));
-SELECT account_save(NULL, '1.1.6.01','Articulos','A','', (SELECT id FROM account WHERE accno LIKE '1.1.6.'), false, false, string_to_array('IC_sale:AR_amount', ':'), false);
-SELECT account_save(NULL, '1.1.6.02','Manufacturas','A','', (SELECT id FROM account WHERE accno LIKE '1.1.6.'), false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL, '1.1.6.01','Articulos','A','', (SELECT id FROM account WHERE accno LIKE '1.1.6.'), false, false, string_to_array('IC_sale:AR_amount', ':'), false, false);
+SELECT account__save(NULL, '1.1.6.02','Manufacturas','A','', (SELECT id FROM account WHERE accno LIKE '1.1.6.'), false, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '1.2.','FIJO',(SELECT id FROM account_heading WHERE accno LIKE '1.'));
 SELECT account_heading_save(NULL, '1.2.1.','PROPIEDADES INMOBILIARIAS',(SELECT id FROM account_heading WHERE accno LIKE '1.2.'));
-SELECT account_save(NULL, '1.2.1.01','Oficina Comercial','A','', (SELECT id FROM account WHERE accno LIKE '1.2.1.'), false, false, string_to_array('Fixed_Asset', ':'), false);
+SELECT account__save(NULL, '1.2.1.01','Oficina Comercial','A','', (SELECT id FROM account WHERE accno LIKE '1.2.1.'), false, false, string_to_array('Fixed_Asset', ':'), false, false);
 SELECT account_heading_save(NULL, '1.2.2.','FLOTA DE VEHICULOS',(SELECT id FROM account_heading WHERE accno LIKE '1.2.'));
-SELECT account_save(NULL, '1.2.2.01','Camion','A','', (SELECT id FROM account WHERE accno LIKE '1.2.2.'), false, false, string_to_array('Fixed_Asset', ':'), false);
-SELECT account_save(NULL, '1.2.2.02','Camioneta','A','', (SELECT id FROM account WHERE accno LIKE '1.2.2.'), false, false, string_to_array('Fixed_Asset', ':'), false);
-SELECT account_save(NULL, '1.2.2.03','Auto','A','', (SELECT id FROM account WHERE accno LIKE '1.2.2.'), false, false, string_to_array('Fixed_Asset', ':'), false);
-SELECT account_save(NULL, '1.2.2.04','Moto','A','', (SELECT id FROM account WHERE accno LIKE '1.2.2.'), false, false, string_to_array('Fixed_Asset', ':'), false);
+SELECT account__save(NULL, '1.2.2.01','Camion','A','', (SELECT id FROM account WHERE accno LIKE '1.2.2.'), false, false, string_to_array('Fixed_Asset', ':'), false, false);
+SELECT account__save(NULL, '1.2.2.02','Camioneta','A','', (SELECT id FROM account WHERE accno LIKE '1.2.2.'), false, false, string_to_array('Fixed_Asset', ':'), false, false);
+SELECT account__save(NULL, '1.2.2.03','Auto','A','', (SELECT id FROM account WHERE accno LIKE '1.2.2.'), false, false, string_to_array('Fixed_Asset', ':'), false, false);
+SELECT account__save(NULL, '1.2.2.04','Moto','A','', (SELECT id FROM account WHERE accno LIKE '1.2.2.'), false, false, string_to_array('Fixed_Asset', ':'), false, false);
 SELECT account_heading_save(NULL, '1.2.3.','MAQUINARIA Y MUEBLES',(SELECT id FROM account_heading WHERE accno LIKE '1.2.'));
-SELECT account_save(NULL, '1.2.3.01','Herramientas','A','', (SELECT id FROM account WHERE accno LIKE '1.2.3.'), false, false, string_to_array('Fixed_Asset', ':'), false);
-SELECT account_save(NULL, '1.2.3.02','Muebles Oficina','A','', (SELECT id FROM account WHERE accno LIKE '1.2.3.'), false, false, string_to_array('Fixed_Asset', ':'), false);
+SELECT account__save(NULL, '1.2.3.01','Herramientas','A','', (SELECT id FROM account WHERE accno LIKE '1.2.3.'), false, false, string_to_array('Fixed_Asset', ':'), false, false);
+SELECT account__save(NULL, '1.2.3.02','Muebles Oficina','A','', (SELECT id FROM account WHERE accno LIKE '1.2.3.'), false, false, string_to_array('Fixed_Asset', ':'), false, false);
 SELECT account_heading_save(NULL, '1.2.4.','DEPRECIACION ACUMULADA',(SELECT id FROM account_heading WHERE accno LIKE '1.2.'));
-SELECT account_save(NULL, '1.2.4.01','(-)Vehiculos','A','', (SELECT id FROM account WHERE accno LIKE '1.2.4.'), false, false, string_to_array('Asset_Dep', ':'), false);
-SELECT account_save(NULL, '1.2.4.02','(-)Herramientas','A','', (SELECT id FROM account WHERE accno LIKE '1.2.4.'), false, false, string_to_array('Asset_Dep', ':'), false);
-SELECT account_save(NULL, '1.2.4.03','(-)Muebles Oficina','A','', (SELECT id FROM account WHERE accno LIKE '1.2.4.'), false, false, string_to_array('Asset_Dep', ':'), false);
+SELECT account__save(NULL, '1.2.4.01','(-)Vehiculos','A','', (SELECT id FROM account WHERE accno LIKE '1.2.4.'), false, false, string_to_array('Asset_Dep', ':'), false, false);
+SELECT account__save(NULL, '1.2.4.02','(-)Herramientas','A','', (SELECT id FROM account WHERE accno LIKE '1.2.4.'), false, false, string_to_array('Asset_Dep', ':'), false, false);
+SELECT account__save(NULL, '1.2.4.03','(-)Muebles Oficina','A','', (SELECT id FROM account WHERE accno LIKE '1.2.4.'), false, false, string_to_array('Asset_Dep', ':'), false, false);
 SELECT account_heading_save(NULL, '1.3.','OTROS ACTIVOS',(SELECT id FROM account_heading WHERE accno LIKE '1.'));
 SELECT account_heading_save(NULL, '1.3.1.','PROMOCION',(SELECT id FROM account_heading WHERE accno LIKE '1.3.'));
-SELECT account_save(NULL, '1.3.1.01','Folleteria','A','', (SELECT id FROM account WHERE accno LIKE '1.3.1.'), false, false, string_to_array('', ':'), false);
-SELECT account_save(NULL, '1.3.1.02','Anuncios','A','', (SELECT id FROM account WHERE accno LIKE '1.3.1.'), false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL, '1.3.1.01','Folleteria','A','', (SELECT id FROM account WHERE accno LIKE '1.3.1.'), false, false, string_to_array('', ':'), false, false);
+SELECT account__save(NULL, '1.3.1.02','Anuncios','A','', (SELECT id FROM account WHERE accno LIKE '1.3.1.'), false, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '1.3.2.','INVESTIGACION',(SELECT id FROM account_heading WHERE accno LIKE '1.3.'));
-SELECT account_save(NULL, '1.3.2.01','Mercadeo','A','', (SELECT id FROM account WHERE accno LIKE '1.3.2.'), false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL, '1.3.2.01','Mercadeo','A','', (SELECT id FROM account WHERE accno LIKE '1.3.2.'), false, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '1.3.3.','DEPOSITOS EN GARANTIA',(SELECT id FROM account_heading WHERE accno LIKE '1.3.'));
-SELECT account_save(NULL, '1.3.3.01','Alquiler de propiedades','A','', (SELECT id FROM account WHERE accno LIKE '1.3.3.'), false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL, '1.3.3.01','Alquiler de propiedades','A','', (SELECT id FROM account WHERE accno LIKE '1.3.3.'), false, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '1.3.4.','AMORTIZACION ACUMULADA',(SELECT id FROM account_heading WHERE accno LIKE '1.3.'));
-SELECT account_save(NULL, '1.3.4.01','(-)Amortizacion','A','', (SELECT id FROM account WHERE accno LIKE '1.3.4.'), false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL, '1.3.4.01','(-)Amortizacion','A','', (SELECT id FROM account WHERE accno LIKE '1.3.4.'), false, false, string_to_array('', ':'), false, false);
 -- Pasivo
 SELECT account_heading_save(NULL, '2.','PASIVO',NULL);
 SELECT account_heading_save(NULL, '2.1.','CORRIENTE',(SELECT id FROM account_heading WHERE accno LIKE '2.'));
 SELECT account_heading_save(NULL, '2.1.1.','CUENTAS POR PAGAR',(SELECT id FROM account_heading WHERE accno LIKE '2.1.'));
-SELECT account_save(NULL, '2.1.1.01','Proveedores','L','', (SELECT id FROM account WHERE accno LIKE '2.1.1.'), false, false, string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL, '2.1.1.02','Sueldos','L','', (SELECT id FROM account WHERE accno LIKE '2.1.1.'), false, false, string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL, '2.1.1.03','Servicios','L','', (SELECT id FROM account WHERE accno LIKE '2.1.1.'), false, false, string_to_array('AP_amount', ':'), false);
+SELECT account__save(NULL, '2.1.1.01','Proveedores','L','', (SELECT id FROM account WHERE accno LIKE '2.1.1.'), false, false, string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL, '2.1.1.02','Sueldos','L','', (SELECT id FROM account WHERE accno LIKE '2.1.1.'), false, false, string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL, '2.1.1.03','Servicios','L','', (SELECT id FROM account WHERE accno LIKE '2.1.1.'), false, false, string_to_array('AP_amount', ':'), false, false);
 SELECT account_heading_save(NULL, '2.1.2.','IMPUESTOS',(SELECT id FROM account_heading WHERE accno LIKE '2.1.'));
-SELECT account_save(NULL, '2.1.2.01','Ganancias (9% - 35%)','L','', (SELECT id FROM account WHERE accno LIKE '2.1.2.'), false, true, string_to_array('IC_taxservice:IC_taxpart:AR_tax', ':'), false);
-SELECT account_save(NULL, '2.1.2.02','Bienes Personales (0,5% - 1,25%)','L','', (SELECT id FROM account WHERE accno LIKE '2.1.2.'), false, true, string_to_array('IC_taxservice:IC_taxpart:AR_tax', ':'), false);
-SELECT account_save(NULL, '2.1.2.03','Ganancia MiÂnima Presunta (1%)','L','', (SELECT id FROM account WHERE accno LIKE '2.1.2.'), false, true, string_to_array('IC_taxservice:IC_taxpart:AR_tax', ':'), false);
-SELECT account_save(NULL, '2.1.2.04','Valor Agregado (IVA 10,5% - 27%)','L','', (SELECT id FROM account WHERE accno LIKE '2.1.2.'), false, true, string_to_array('IC_taxservice:IC_taxpart:AR_tax', ':'), false);
+SELECT account__save(NULL, '2.1.2.01','Ganancias (9% - 35%)','L','', (SELECT id FROM account WHERE accno LIKE '2.1.2.'), false, true, string_to_array('IC_taxservice:IC_taxpart:AR_tax', ':'), false, false);
+SELECT account__save(NULL, '2.1.2.02','Bienes Personales (0,5% - 1,25%)','L','', (SELECT id FROM account WHERE accno LIKE '2.1.2.'), false, true, string_to_array('IC_taxservice:IC_taxpart:AR_tax', ':'), false, false);
+SELECT account__save(NULL, '2.1.2.03','Ganancia MiÂnima Presunta (1%)','L','', (SELECT id FROM account WHERE accno LIKE '2.1.2.'), false, true, string_to_array('IC_taxservice:IC_taxpart:AR_tax', ':'), false, false);
+SELECT account__save(NULL, '2.1.2.04','Valor Agregado (IVA 10,5% - 27%)','L','', (SELECT id FROM account WHERE accno LIKE '2.1.2.'), false, true, string_to_array('IC_taxservice:IC_taxpart:AR_tax', ':'), false, false);
 SELECT account_heading_save(NULL, '2.2.','LARGO PLAZO',(SELECT id FROM account_heading WHERE accno LIKE '2.'));
 SELECT account_heading_save(NULL, '2.2.1.','CREDITOS',(SELECT id FROM account_heading WHERE accno LIKE '2.2.'));
-SELECT account_save(NULL, '2.2.1.01','Hipotecario Banco Nacion','L','', (SELECT id FROM account WHERE accno LIKE '2.2.1.'), false, false, string_to_array('AP_amount', ':'), false);
+SELECT account__save(NULL, '2.2.1.01','Hipotecario Banco Nacion','L','', (SELECT id FROM account WHERE accno LIKE '2.2.1.'), false, false, string_to_array('AP_amount', ':'), false, false);
 SELECT account_heading_save(NULL, '2.2.2.','OTROS PASIVOS',(SELECT id FROM account_heading WHERE accno LIKE '2.2.'));
 -- Patrimonio
 SELECT account_heading_save(NULL, '3.','PATRIMONIO',NULL);
 SELECT account_heading_save(NULL, '3.1.','PATRIMONIO NETO',(SELECT id FROM account_heading WHERE accno LIKE '3.'));
 SELECT account_heading_save(NULL, '3.1.1.','CAPITAL SUSCRITO',(SELECT id FROM account_heading WHERE accno LIKE '3.1.'));
-SELECT account_save(NULL, '3.1.1.01','Capital Social','Q','', (SELECT id FROM account WHERE accno LIKE '3.1.1.'), false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL, '3.1.1.01','Capital Social','Q','', (SELECT id FROM account WHERE accno LIKE '3.1.1.'), false, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '3.1.2.','RESERVAS',(SELECT id FROM account_heading WHERE accno LIKE '3.1.'));
-SELECT account_save(NULL, '3.1.2.01','Reserva Legal','Q','', (SELECT id FROM account WHERE accno LIKE '3.1.2.'), false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL, '3.1.2.01','Reserva Legal','Q','', (SELECT id FROM account WHERE accno LIKE '3.1.2.'), false, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '3.1.3.','UTILIDADES',(SELECT id FROM account_heading WHERE accno LIKE '3.1.'));
 -- Ingresos
 SELECT account_heading_save(NULL, '4.','INGRESOS',NULL);
 SELECT account_heading_save(NULL, '4.1.','OPERACIONALES',(SELECT id FROM account_heading WHERE accno LIKE '4.'));
 SELECT account_heading_save(NULL, '4.1.1.','VENTAS',(SELECT id FROM account_heading WHERE accno LIKE '4.1.'));
-SELECT account_save(NULL, '4.1.1.01','Servicio','I','', (SELECT id FROM account WHERE accno LIKE '4.1.1.'), false, false, string_to_array('IC_income:AR_amount', ':'), false);
-SELECT account_save(NULL, '4.1.1.02','Articulo','I','', (SELECT id FROM account WHERE accno LIKE '4.1.1.'), false, false, string_to_array('IC_income:AR_amount', ':'), false);
-SELECT account_save(NULL, '4.1.1.03','Manufactura','I','', (SELECT id FROM account WHERE accno LIKE '4.1.1.'), false, false, string_to_array('IC_income:AR_amount', ':'), false);
+SELECT account__save(NULL, '4.1.1.01','Servicio','I','', (SELECT id FROM account WHERE accno LIKE '4.1.1.'), false, false, string_to_array('IC_income:AR_amount', ':'), false, false);
+SELECT account__save(NULL, '4.1.1.02','Articulo','I','', (SELECT id FROM account WHERE accno LIKE '4.1.1.'), false, false, string_to_array('IC_income:AR_amount', ':'), false, false);
+SELECT account__save(NULL, '4.1.1.03','Manufactura','I','', (SELECT id FROM account WHERE accno LIKE '4.1.1.'), false, false, string_to_array('IC_income:AR_amount', ':'), false, false);
 SELECT account_heading_save(NULL, '4.1.2.','VENTAS EXCENTAS',(SELECT id FROM account_heading WHERE accno LIKE '4.1.'));
-SELECT account_save(NULL, '4.1.2.01','Exportaciones','I','', (SELECT id FROM account WHERE accno LIKE '4.1.2.'), false, false, string_to_array('IC_income:AR_amount', ':'), false);
-SELECT account_save(NULL, '4.1.2.02','Sin IVA','I','', (SELECT id FROM account WHERE accno LIKE '4.1.2.'), false, false, string_to_array('IC_income:AR_amount', ':'), false);
+SELECT account__save(NULL, '4.1.2.01','Exportaciones','I','', (SELECT id FROM account WHERE accno LIKE '4.1.2.'), false, false, string_to_array('IC_income:AR_amount', ':'), false, false);
+SELECT account__save(NULL, '4.1.2.02','Sin IVA','I','', (SELECT id FROM account WHERE accno LIKE '4.1.2.'), false, false, string_to_array('IC_income:AR_amount', ':'), false, false);
 SELECT account_heading_save(NULL, '4.1.3.','DEVOLUCIONES',(SELECT id FROM account_heading WHERE accno LIKE '4.1.'));
 SELECT account_heading_save(NULL, '4.2.','NO OPERACIONALES',(SELECT id FROM account_heading WHERE accno LIKE '4.'));
 SELECT account_heading_save(NULL, '4.2.1.','OTROS INGRESOS	 ',(SELECT id FROM account_heading WHERE accno LIKE '4.2.'));
-SELECT account_save(NULL, '4.2.1.01','Intereses ganados','I','', (SELECT id FROM account WHERE accno LIKE '4.2.1.'), false, false, string_to_array('asset_gain', ':'), false);
-SELECT account_save(NULL, '4.2.1.02','Venta de activo fijo','I','', (SELECT id FROM account WHERE accno LIKE '4.2.1.'), false, false, string_to_array('asset_gain', ':'), false);
-SELECT account_save(NULL, '4.2.1.03','Rentas','I','', (SELECT id FROM account WHERE accno LIKE '4.2.1.'), false, false, string_to_array('asset_gain', ':'), false);
-SELECT account_save(NULL, '4.2.1.04','Cambio de moneda ganado','I','', (SELECT id FROM account WHERE accno LIKE '4.2.1.'), false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL, '4.2.1.01','Intereses ganados','I','', (SELECT id FROM account WHERE accno LIKE '4.2.1.'), false, false, string_to_array('asset_gain', ':'), false, false);
+SELECT account__save(NULL, '4.2.1.02','Venta de activo fijo','I','', (SELECT id FROM account WHERE accno LIKE '4.2.1.'), false, false, string_to_array('asset_gain', ':'), false, false);
+SELECT account__save(NULL, '4.2.1.03','Rentas','I','', (SELECT id FROM account WHERE accno LIKE '4.2.1.'), false, false, string_to_array('asset_gain', ':'), false, false);
+SELECT account__save(NULL, '4.2.1.04','Cambio de moneda ganado','I','', (SELECT id FROM account WHERE accno LIKE '4.2.1.'), false, false, string_to_array('', ':'), false, false);
 -- Gastos
 SELECT account_heading_save(NULL, '5.','GASTOS	 ',NULL);
 SELECT account_heading_save(NULL, '5.1.','COSTO',(SELECT id FROM account_heading WHERE accno LIKE '5.'));
 SELECT account_heading_save(NULL, '5.1.1.','VENTAS',(SELECT id FROM account_heading WHERE accno LIKE '5.1.'));
-SELECT account_save(NULL, '5.1.1.01','Servicio','E','', (SELECT id FROM account WHERE accno LIKE '5.1.1.'), false, false, string_to_array('AP_amount:IC_expense', ':'), false);
-SELECT account_save(NULL, '5.1.1.02','Articulo','E','', (SELECT id FROM account WHERE accno LIKE '5.1.1.'), false, false, string_to_array('AP_amount:IC_cogs', ':'), false);
-SELECT account_save(NULL, '5.1.1.03','Manufactura','E','', (SELECT id FROM account WHERE accno LIKE '5.1.1.'), false, false, string_to_array('AP_amount:asset_loss', ':'), false);
+SELECT account__save(NULL, '5.1.1.01','Servicio','E','', (SELECT id FROM account WHERE accno LIKE '5.1.1.'), false, false, string_to_array('AP_amount:IC_expense', ':'), false, false);
+SELECT account__save(NULL, '5.1.1.02','Articulo','E','', (SELECT id FROM account WHERE accno LIKE '5.1.1.'), false, false, string_to_array('AP_amount:IC_cogs', ':'), false, false);
+SELECT account__save(NULL, '5.1.1.03','Manufactura','E','', (SELECT id FROM account WHERE accno LIKE '5.1.1.'), false, false, string_to_array('AP_amount:asset_loss', ':'), false, false);
 SELECT account_heading_save(NULL, '5.2.','ADMINISTRACION',(SELECT id FROM account_heading WHERE accno LIKE '5.'));
 SELECT account_heading_save(NULL, '5.2.1.','RECURSOS HUMANOS',(SELECT id FROM account_heading WHERE accno LIKE '5.2.'));
-SELECT account_save(NULL, '5.2.1.01','Sueldos','E','', (SELECT id FROM account WHERE accno LIKE '5.2.1.'), false, false, string_to_array('AP_amount:IC_expense', ':'), false);
-SELECT account_save(NULL, '5.2.1.02','Salarios','E','', (SELECT id FROM account WHERE accno LIKE '5.2.1.'), false, false, string_to_array('AP_amount:IC_expense', ':'), false);
-SELECT account_save(NULL, '5.2.1.03','Vacaciones','E','', (SELECT id FROM account WHERE accno LIKE '5.2.1.'), false, false, string_to_array('AP_amount:IC_expense', ':'), false);
-SELECT account_save(NULL, '5.2.1.04','Aportes','E','', (SELECT id FROM account WHERE accno LIKE '5.2.1.'), false, false, string_to_array('AP_amount:IC_expense', ':'), false);
-SELECT account_save(NULL, '5.2.1.05','Adelantos','E','', (SELECT id FROM account WHERE accno LIKE '5.2.1.'), false, false, string_to_array('AP_amount:IC_expense', ':'), false);
+SELECT account__save(NULL, '5.2.1.01','Sueldos','E','', (SELECT id FROM account WHERE accno LIKE '5.2.1.'), false, false, string_to_array('AP_amount:IC_expense', ':'), false, false);
+SELECT account__save(NULL, '5.2.1.02','Salarios','E','', (SELECT id FROM account WHERE accno LIKE '5.2.1.'), false, false, string_to_array('AP_amount:IC_expense', ':'), false, false);
+SELECT account__save(NULL, '5.2.1.03','Vacaciones','E','', (SELECT id FROM account WHERE accno LIKE '5.2.1.'), false, false, string_to_array('AP_amount:IC_expense', ':'), false, false);
+SELECT account__save(NULL, '5.2.1.04','Aportes','E','', (SELECT id FROM account WHERE accno LIKE '5.2.1.'), false, false, string_to_array('AP_amount:IC_expense', ':'), false, false);
+SELECT account__save(NULL, '5.2.1.05','Adelantos','E','', (SELECT id FROM account WHERE accno LIKE '5.2.1.'), false, false, string_to_array('AP_amount:IC_expense', ':'), false, false);
 SELECT account_heading_save(NULL, '5.2.2.','COMISIONES',(SELECT id FROM account_heading WHERE accno LIKE '5.2.'));
-SELECT account_save(NULL, '5.2.2.01','Ventas','E','', (SELECT id FROM account WHERE accno LIKE '5.2.2.'), false, false, string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL, '5.2.2.02','Publicidad','E','', (SELECT id FROM account WHERE accno LIKE '5.2.2.'), false, false, string_to_array('AP_amount', ':'), false);
+SELECT account__save(NULL, '5.2.2.01','Ventas','E','', (SELECT id FROM account WHERE accno LIKE '5.2.2.'), false, false, string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL, '5.2.2.02','Publicidad','E','', (SELECT id FROM account WHERE accno LIKE '5.2.2.'), false, false, string_to_array('AP_amount', ':'), false, false);
 SELECT account_heading_save(NULL, '5.2.3.','SERVICIOS',(SELECT id FROM account_heading WHERE accno LIKE '5.2.'));
-SELECT account_save(NULL, '5.2.3.01','Alquiler inmobiliario','E','', (SELECT id FROM account WHERE accno LIKE '5.2.3.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false);
-SELECT account_save(NULL, '5.2.3.02','Electricidad','E','', (SELECT id FROM account WHERE accno LIKE '5.2.3.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false);
-SELECT account_save(NULL, '5.2.3.03','Gas','E','', (SELECT id FROM account WHERE accno LIKE '5.2.3.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false);
-SELECT account_save(NULL, '5.2.3.04','Municipal','E','', (SELECT id FROM account WHERE accno LIKE '5.2.3.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false);
-SELECT account_save(NULL, '5.2.3.05','Telefonia','E','', (SELECT id FROM account WHERE accno LIKE '5.2.3.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false);
-SELECT account_save(NULL, '5.2.3.06','Internet','E','', (SELECT id FROM account WHERE accno LIKE '5.2.3.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false);
+SELECT account__save(NULL, '5.2.3.01','Alquiler inmobiliario','E','', (SELECT id FROM account WHERE accno LIKE '5.2.3.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false, false);
+SELECT account__save(NULL, '5.2.3.02','Electricidad','E','', (SELECT id FROM account WHERE accno LIKE '5.2.3.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false, false);
+SELECT account__save(NULL, '5.2.3.03','Gas','E','', (SELECT id FROM account WHERE accno LIKE '5.2.3.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false, false);
+SELECT account__save(NULL, '5.2.3.04','Municipal','E','', (SELECT id FROM account WHERE accno LIKE '5.2.3.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false, false);
+SELECT account__save(NULL, '5.2.3.05','Telefonia','E','', (SELECT id FROM account WHERE accno LIKE '5.2.3.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false, false);
+SELECT account__save(NULL, '5.2.3.06','Internet','E','', (SELECT id FROM account WHERE accno LIKE '5.2.3.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false, false);
 SELECT account_heading_save(NULL, '5.2.4.','MANTENIMIENTO',(SELECT id FROM account_heading WHERE accno LIKE '5.2.'));
-SELECT account_save(NULL, '5.2.4.01','Inmobiliario','E','', (SELECT id FROM account WHERE accno LIKE '5.2.4.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false);
-SELECT account_save(NULL, '5.2.4.02','Flota de vehiculos','E','', (SELECT id FROM account WHERE accno LIKE '5.2.4.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false);
-SELECT account_save(NULL, '5.2.4.03','Combustible vehiculos','E','', (SELECT id FROM account WHERE accno LIKE '5.2.4.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false);
-SELECT account_save(NULL, '5.2.4.04','Varios','E','', (SELECT id FROM account WHERE accno LIKE '5.2.4.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false);
+SELECT account__save(NULL, '5.2.4.01','Inmobiliario','E','', (SELECT id FROM account WHERE accno LIKE '5.2.4.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false, false);
+SELECT account__save(NULL, '5.2.4.02','Flota de vehiculos','E','', (SELECT id FROM account WHERE accno LIKE '5.2.4.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false, false);
+SELECT account__save(NULL, '5.2.4.03','Combustible vehiculos','E','', (SELECT id FROM account WHERE accno LIKE '5.2.4.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false, false);
+SELECT account__save(NULL, '5.2.4.04','Varios','E','', (SELECT id FROM account WHERE accno LIKE '5.2.4.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false, false);
 SELECT account_heading_save(NULL, '5.2.5.','OTROS GASTOS',(SELECT id FROM account_heading WHERE accno LIKE '5.2.'));
-SELECT account_save(NULL, '5.2.5.01','Contribucion Escuela regional','E','', (SELECT id FROM account WHERE accno LIKE '5.2.5.'), false, false, string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL, '5.2.5.02','Cambio de moneda perdido','E','', (SELECT id FROM account WHERE accno LIKE '5.2.5.'), false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL, '5.2.5.01','Contribucion Escuela regional','E','', (SELECT id FROM account WHERE accno LIKE '5.2.5.'), false, false, string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL, '5.2.5.02','Cambio de moneda perdido','E','', (SELECT id FROM account WHERE accno LIKE '5.2.5.'), false, false, string_to_array('', ':'), false, false);
 commit;
 -- Impuestos
 -- Ganancias
@@ -142,7 +142,7 @@
 -- IVA Favor
 INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '1.1.5.01'), 0.21);
 
-SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
 FROM account WHERE id IN (select account_id FROM account_link
                            WHERE description = 'AP_paid');
 -- Sistema

Modified: trunk/sql/coa/ar/chart/Personal.sql
===================================================================
--- trunk/sql/coa/ar/chart/Personal.sql	2012-06-18 12:06:54 UTC (rev 4912)
+++ trunk/sql/coa/ar/chart/Personal.sql	2012-06-18 12:25:28 UTC (rev 4913)
@@ -2,85 +2,85 @@
 -- Plan de Cuentas para uso personal en Argentina
 -- Sumario
 SELECT account_heading_save(NULL, '0.','SUMARIO',NULL);
-SELECT account_save(NULL, '0.00','A Cobrar','A','', (SELECT id FROM account WHERE accno LIKE '0.'), false, false, string_to_array('AR', ':'), false);
-SELECT account_save(NULL, '0.10','A Pagar','A','', (SELECT id FROM account WHERE accno LIKE '0.'), false, false, string_to_array('AP', ':'), false);
-SELECT account_save(NULL, '0.20','Inventario','A','', (SELECT id FROM account WHERE accno LIKE '0.'), false, false, string_to_array('IC', ':'), false);
+SELECT account__save(NULL, '0.00','A Cobrar','A','', (SELECT id FROM account WHERE accno LIKE '0.'), false, false, string_to_array('AR', ':'), false, false);
+SELECT account__save(NULL, '0.10','A Pagar','A','', (SELECT id FROM account WHERE accno LIKE '0.'), false, false, string_to_array('AP', ':'), false, false);
+SELECT account__save(NULL, '0.20','Inventario','A','', (SELECT id FROM account WHERE accno LIKE '0.'), false, false, string_to_array('IC', ':'), false, false);
 -- Activo
 SELECT account_heading_save(NULL, '1.','ACTIVO',NULL);
 SELECT account_heading_save(NULL, '1.1.','CORRIENTE',(SELECT id FROM account_heading WHERE accno LIKE '1.'));
-SELECT account_save(NULL, '1.1.00','Efectivo','A','', (SELECT id FROM account WHERE accno LIKE '1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false);
-SELECT account_save(NULL, '1.1.10','Caja Seguridad','A','', (SELECT id FROM account WHERE accno LIKE '1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false);
-SELECT account_save(NULL, '1.1.20','Caja Ahorro Banco1','A','', (SELECT id FROM account WHERE accno LIKE '1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false);
-SELECT account_save(NULL, '1.1.21','Caja Ahorro Banco2','A','', (SELECT id FROM account WHERE accno LIKE '1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false);
-SELECT account_save(NULL, '1.1.30','TC Banco1','A','', (SELECT id FROM account WHERE accno LIKE '1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false);
-SELECT account_save(NULL, '1.1.31','TC Banco2','A','', (SELECT id FROM account WHERE accno LIKE '1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false);
-SELECT account_save(NULL, '1.1.40','Credito a Terceros','A','', (SELECT id FROM account WHERE accno LIKE '1.1.'), false, false, string_to_array('AR_overpayment:AR_amount', ':'), false);
+SELECT account__save(NULL, '1.1.00','Efectivo','A','', (SELECT id FROM account WHERE accno LIKE '1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
+SELECT account__save(NULL, '1.1.10','Caja Seguridad','A','', (SELECT id FROM account WHERE accno LIKE '1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
+SELECT account__save(NULL, '1.1.20','Caja Ahorro Banco1','A','', (SELECT id FROM account WHERE accno LIKE '1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
+SELECT account__save(NULL, '1.1.21','Caja Ahorro Banco2','A','', (SELECT id FROM account WHERE accno LIKE '1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
+SELECT account__save(NULL, '1.1.30','TC Banco1','A','', (SELECT id FROM account WHERE accno LIKE '1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
+SELECT account__save(NULL, '1.1.31','TC Banco2','A','', (SELECT id FROM account WHERE accno LIKE '1.1.'), false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
+SELECT account__save(NULL, '1.1.40','Credito a Terceros','A','', (SELECT id FROM account WHERE accno LIKE '1.1.'), false, false, string_to_array('AR_overpayment:AR_amount', ':'), false, false);
 SELECT account_heading_save(NULL, '1.2.','INVENTARIO',(SELECT id FROM account_heading WHERE accno LIKE '1.'));
-SELECT account_save(NULL, '1.2.00','Articulos','A','', (SELECT id FROM account WHERE accno LIKE '1.2.'), false, false, string_to_array('IC_sale:AR_amount', ':'), false);
-SELECT account_save(NULL, '1.2.10','Manufacturas','A','', (SELECT id FROM account WHERE accno LIKE '1.2.'), false, false, string_to_array('IC_sale:AR_amount', ':'), false);
+SELECT account__save(NULL, '1.2.00','Articulos','A','', (SELECT id FROM account WHERE accno LIKE '1.2.'), false, false, string_to_array('IC_sale:AR_amount', ':'), false, false);
+SELECT account__save(NULL, '1.2.10','Manufacturas','A','', (SELECT id FROM account WHERE accno LIKE '1.2.'), false, false, string_to_array('IC_sale:AR_amount', ':'), false, false);
 SELECT account_heading_save(NULL, '1.3.','NO CORRIENTE',(SELECT id FROM account_heading WHERE accno LIKE '1.'));
-SELECT account_save(NULL, '1.3.00','Propiedades','A','', (SELECT id FROM account WHERE accno LIKE '1.3.'), false, false, string_to_array('Fixed_Asset', ':'), false);
-SELECT account_save(NULL, '1.3.10','Vehiculos','A','', (SELECT id FROM account WHERE accno LIKE '1.3.'), false, false, string_to_array('Fixed_Asset', ':'), false);
-SELECT account_save(NULL, '1.3.20','Muebles','A','', (SELECT id FROM account WHERE accno LIKE '1.3.'), false, false, string_to_array('Fixed_Asset', ':'), false);
-SELECT account_save(NULL, '1.3.30','Electrodomesticos','A','', (SELECT id FROM account WHERE accno LIKE '1.3.'), false, false, string_to_array('Fixed_Asset', ':'), false);
-SELECT account_save(NULL, '1.3.40','Herramientas','A','', (SELECT id FROM account WHERE accno LIKE '1.3.'), false, false, string_to_array('Fixed_Asset', ':'), false);
-SELECT account_save(NULL, '1.3.100','(-)Depresiacion','A','', (SELECT id FROM account WHERE accno LIKE '1.3.'), false, false, string_to_array('Asset_Dep', ':'), false);
+SELECT account__save(NULL, '1.3.00','Propiedades','A','', (SELECT id FROM account WHERE accno LIKE '1.3.'), false, false, string_to_array('Fixed_Asset', ':'), false, false);
+SELECT account__save(NULL, '1.3.10','Vehiculos','A','', (SELECT id FROM account WHERE accno LIKE '1.3.'), false, false, string_to_array('Fixed_Asset', ':'), false, false);
+SELECT account__save(NULL, '1.3.20','Muebles','A','', (SELECT id FROM account WHERE accno LIKE '1.3.'), false, false, string_to_array('Fixed_Asset', ':'), false, false);
+SELECT account__save(NULL, '1.3.30','Electrodomesticos','A','', (SELECT id FROM account WHERE accno LIKE '1.3.'), false, false, string_to_array('Fixed_Asset', ':'), false, false);
+SELECT account__save(NULL, '1.3.40','Herramientas','A','', (SELECT id FROM account WHERE accno LIKE '1.3.'), false, false, string_to_array('Fixed_Asset', ':'), false, false);
+SELECT account__save(NULL, '1.3.100','(-)Depresiacion','A','', (SELECT id FROM account WHERE accno LIKE '1.3.'), false, false, string_to_array('Asset_Dep', ':'), false, false);
 SELECT account_heading_save(NULL, '1.4.','OTROS',(SELECT id FROM account_heading WHERE accno LIKE '1.'));
-SELECT account_save(NULL, '1.4.00','(-)Amortizacion','A','', (SELECT id FROM account WHERE accno LIKE '1.4.'), false, false, string_to_array('', ':'), false);
-SELECT account_save(NULL, '1.4.10','IVA a Favor','A','', (SELECT id FROM account WHERE accno LIKE '1.4.'), false, true, string_to_array('AP_tax', ':'), false);
-SELECT account_save(NULL, '1.4.20','Depositos de Alquiler','A','', (SELECT id FROM account WHERE accno LIKE '1.4.'), false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL, '1.4.00','(-)Amortizacion','A','', (SELECT id FROM account WHERE accno LIKE '1.4.'), false, false, string_to_array('', ':'), false, false);
+SELECT account__save(NULL, '1.4.10','IVA a Favor','A','', (SELECT id FROM account WHERE accno LIKE '1.4.'), false, true, string_to_array('AP_tax', ':'), false, false);
+SELECT account__save(NULL, '1.4.20','Depositos de Alquiler','A','', (SELECT id FROM account WHERE accno LIKE '1.4.'), false, false, string_to_array('', ':'), false, false);
 -- Pasivo
 SELECT account_heading_save(NULL, '2.','PASIVO',NULL);
 SELECT account_heading_save(NULL, '2.1.','CORRIENTE',(SELECT id FROM account_heading WHERE accno LIKE '2.'));
-SELECT account_save(NULL, '2.1.00','Servicios','L','', (SELECT id FROM account WHERE accno LIKE '2.1.'), false, false, string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL, '2.1.10','Proveedores','L','', (SELECT id FROM account WHERE accno LIKE '2.1.'), false, false, string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL, '2.1.20','Ganancias (9% - 35%)','L','', (SELECT id FROM account WHERE accno LIKE '2.1.'), false, true, string_to_array('IC_taxservice:IC_taxpart:AR_tax', ':'), false);
-SELECT account_save(NULL, '2.1.21','Jubilacion (11%)','L','', (SELECT id FROM account WHERE accno LIKE '2.1.'), false, true, string_to_array('IC_taxservice:IC_taxpart:AR_tax', ':'), false);
-SELECT account_save(NULL, '2.1.22','Jubilacion INSSJP (3%)','L','', (SELECT id FROM account WHERE accno LIKE '2.1.'), false, true, string_to_array('IC_taxservice:IC_taxpart:AR_tax', ':'), false);
-SELECT account_save(NULL, '2.1.23','Servicio Social (3%)','L','', (SELECT id FROM account WHERE accno LIKE '2.1.'), false, true, string_to_array('IC_taxservice:IC_taxpart:AR_tax', ':'), false);
-SELECT account_save(NULL, '2.1.24','Bienes Personales (0,5% - 1,25%)','L','', (SELECT id FROM account WHERE accno LIKE '2.1.'), false, true, string_to_array('IC_taxservice:IC_taxpart:AR_tax', ':'), false);
-SELECT account_save(NULL, '2.1.25','Valor Agregado (IVA 10,5% - 27%)','L','', (SELECT id FROM account WHERE accno LIKE '2.1.'), false, true, string_to_array('IC_taxservice:IC_taxpart:AR_tax', ':'), false);
-SELECT account_save(NULL, '2.1.26','Ingresos Brutos (3%)','L','', (SELECT id FROM account WHERE accno LIKE '2.1.'), false, true, string_to_array('IC_taxservice:IC_taxpart:AR_tax', ':'), false);
+SELECT account__save(NULL, '2.1.00','Servicios','L','', (SELECT id FROM account WHERE accno LIKE '2.1.'), false, false, string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL, '2.1.10','Proveedores','L','', (SELECT id FROM account WHERE accno LIKE '2.1.'), false, false, string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL, '2.1.20','Ganancias (9% - 35%)','L','', (SELECT id FROM account WHERE accno LIKE '2.1.'), false, true, string_to_array('IC_taxservice:IC_taxpart:AR_tax', ':'), false, false);
+SELECT account__save(NULL, '2.1.21','Jubilacion (11%)','L','', (SELECT id FROM account WHERE accno LIKE '2.1.'), false, true, string_to_array('IC_taxservice:IC_taxpart:AR_tax', ':'), false, false);
+SELECT account__save(NULL, '2.1.22','Jubilacion INSSJP (3%)','L','', (SELECT id FROM account WHERE accno LIKE '2.1.'), false, true, string_to_array('IC_taxservice:IC_taxpart:AR_tax', ':'), false, false);
+SELECT account__save(NULL, '2.1.23','Servicio Social (3%)','L','', (SELECT id FROM account WHERE accno LIKE '2.1.'), false, true, string_to_array('IC_taxservice:IC_taxpart:AR_tax', ':'), false, false);
+SELECT account__save(NULL, '2.1.24','Bienes Personales (0,5% - 1,25%)','L','', (SELECT id FROM account WHERE accno LIKE '2.1.'), false, true, string_to_array('IC_taxservice:IC_taxpart:AR_tax', ':'), false, false);
+SELECT account__save(NULL, '2.1.25','Valor Agregado (IVA 10,5% - 27%)','L','', (SELECT id FROM account WHERE accno LIKE '2.1.'), false, true, string_to_array('IC_taxservice:IC_taxpart:AR_tax', ':'), false, false);
+SELECT account__save(NULL, '2.1.26','Ingresos Brutos (3%)','L','', (SELECT id FROM account WHERE accno LIKE '2.1.'), false, true, string_to_array('IC_taxservice:IC_taxpart:AR_tax', ':'), false, false);
 SELECT account_heading_save(NULL, '2.2.','LARGO PLAZO',(SELECT id FROM account_heading WHERE accno LIKE '2.'));
-SELECT account_save(NULL, '2.2.00','Hipotecario Banco X','L','', (SELECT id FROM account WHERE accno LIKE '2.2.'), false, false, string_to_array('AP_amount', ':'), false);
+SELECT account__save(NULL, '2.2.00','Hipotecario Banco X','L','', (SELECT id FROM account WHERE accno LIKE '2.2.'), false, false, string_to_array('AP_amount', ':'), false, false);
 SELECT account_heading_save(NULL, '2.3.','OTROS PASIVOS',(SELECT id FROM account_heading WHERE accno LIKE '2.'));
 -- Patrimonio
 SELECT account_heading_save(NULL, '3.','PATRIMONIO',NULL);
 SELECT account_heading_save(NULL, '3.1.','PATRIMONIO NETO',(SELECT id FROM account_heading WHERE accno LIKE '3.'));
-SELECT account_save(NULL, '3.1.00','Capital Social','Q','', (SELECT id FROM account WHERE accno LIKE '3.1.'), false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL, '3.1.00','Capital Social','Q','', (SELECT id FROM account WHERE accno LIKE '3.1.'), false, false, string_to_array('', ':'), false, false);
 -- Ingresos
 SELECT account_heading_save(NULL, '4.','INGRESOS',NULL);
 SELECT account_heading_save(NULL, '4.1.','OPERACIONALES',(SELECT id FROM account_heading WHERE accno LIKE '4.'));
-SELECT account_save(NULL, '4.1.00','Acreditacion de Haberes','I','', (SELECT id FROM account WHERE accno LIKE '4.1.'), false, false, string_to_array('IC_income:AR_amount', ':'), false);
-SELECT account_save(NULL, '4.1.10','Servicios Prestados','I','', (SELECT id FROM account WHERE accno LIKE '4.1.'), false, false, string_to_array('IC_income:AR_amount', ':'), false);
-SELECT account_save(NULL, '4.1.20','Articulos Vendidos','I','', (SELECT id FROM account WHERE accno LIKE '4.1.'), false, false, string_to_array('IC_income:AR_amount', ':'), false);
-SELECT account_save(NULL, '4.1.30','Manufacturas Vendidas','I','', (SELECT id FROM account WHERE accno LIKE '4.1.'), false, false, string_to_array('IC_income:AR_amount', ':'), false);
+SELECT account__save(NULL, '4.1.00','Acreditacion de Haberes','I','', (SELECT id FROM account WHERE accno LIKE '4.1.'), false, false, string_to_array('IC_income:AR_amount', ':'), false, false);
+SELECT account__save(NULL, '4.1.10','Servicios Prestados','I','', (SELECT id FROM account WHERE accno LIKE '4.1.'), false, false, string_to_array('IC_income:AR_amount', ':'), false, false);
+SELECT account__save(NULL, '4.1.20','Articulos Vendidos','I','', (SELECT id FROM account WHERE accno LIKE '4.1.'), false, false, string_to_array('IC_income:AR_amount', ':'), false, false);
+SELECT account__save(NULL, '4.1.30','Manufacturas Vendidas','I','', (SELECT id FROM account WHERE accno LIKE '4.1.'), false, false, string_to_array('IC_income:AR_amount', ':'), false, false);
 SELECT account_heading_save(NULL, '4.2.','NO OPERACIONALES',(SELECT id FROM account_heading WHERE accno LIKE '4.'));
-SELECT account_save(NULL, '4.2.00','Intereses Ganados','I','', (SELECT id FROM account WHERE accno LIKE '4.2.'), false, false, string_to_array('asset_gain', ':'), false);
-SELECT account_save(NULL, '4.2.10','Venta de Activo Fijo','I','', (SELECT id FROM account WHERE accno LIKE '4.2.'), false, false, string_to_array('asset_gain', ':'), false);
-SELECT account_save(NULL, '4.2.20','Rentas','I','', (SELECT id FROM account WHERE accno LIKE '4.2.'), false, false, string_to_array('asset_gain', ':'), false);
-SELECT account_save(NULL, '4.2.30','Cambio de Moneda Ganado','I','', (SELECT id FROM account WHERE accno LIKE '4.2.'), false, false, string_to_array('asset_gain', ':'), false);
+SELECT account__save(NULL, '4.2.00','Intereses Ganados','I','', (SELECT id FROM account WHERE accno LIKE '4.2.'), false, false, string_to_array('asset_gain', ':'), false, false);
+SELECT account__save(NULL, '4.2.10','Venta de Activo Fijo','I','', (SELECT id FROM account WHERE accno LIKE '4.2.'), false, false, string_to_array('asset_gain', ':'), false, false);
+SELECT account__save(NULL, '4.2.20','Rentas','I','', (SELECT id FROM account WHERE accno LIKE '4.2.'), false, false, string_to_array('asset_gain', ':'), false, false);
+SELECT account__save(NULL, '4.2.30','Cambio de Moneda Ganado','I','', (SELECT id FROM account WHERE accno LIKE '4.2.'), false, false, string_to_array('asset_gain', ':'), false, false);
 -- Gastos
 SELECT account_heading_save(NULL, '5.','GASTOS	 ',NULL);
 SELECT account_heading_save(NULL, '5.1.','COSTO',(SELECT id FROM account_heading WHERE accno LIKE '5.'));
-SELECT account_save(NULL, '5.1.00','Servicios','E','', (SELECT id FROM account WHERE accno LIKE '5.1.'), false, false, string_to_array('AP_amount:IC_expense', ':'), false);
-SELECT account_save(NULL, '5.1.10','Articulos','E','', (SELECT id FROM account WHERE accno LIKE '5.1.'), false, false, string_to_array('AP_amount:IC_cogs', ':'), false);
-SELECT account_save(NULL, '5.1.20','Manufacturas','E','', (SELECT id FROM account WHERE accno LIKE '5.1.'), false, false, string_to_array('AP_amount:asset_loss', ':'), false);
+SELECT account__save(NULL, '5.1.00','Servicios','E','', (SELECT id FROM account WHERE accno LIKE '5.1.'), false, false, string_to_array('AP_amount:IC_expense', ':'), false, false);
+SELECT account__save(NULL, '5.1.10','Articulos','E','', (SELECT id FROM account WHERE accno LIKE '5.1.'), false, false, string_to_array('AP_amount:IC_cogs', ':'), false, false);
+SELECT account__save(NULL, '5.1.20','Manufacturas','E','', (SELECT id FROM account WHERE accno LIKE '5.1.'), false, false, string_to_array('AP_amount:asset_loss', ':'), false, false);
 SELECT account_heading_save(NULL, '5.2.','SERVICIOS',(SELECT id FROM account_heading WHERE accno LIKE '5.'));
-SELECT account_save(NULL, '5.2.00','Alquiler inmobiliario','E','', (SELECT id FROM account WHERE accno LIKE '5.2.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false);
-SELECT account_save(NULL, '5.2.01','Electricidad','E','', (SELECT id FROM account WHERE accno LIKE '5.2.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false);
-SELECT account_save(NULL, '5.2.02','Gas','E','', (SELECT id FROM account WHERE accno LIKE '5.2.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false);
-SELECT account_save(NULL, '5.2.03','Municipal','E','', (SELECT id FROM account WHERE accno LIKE '5.2.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false);
-SELECT account_save(NULL, '5.2.04','Telefonia','E','', (SELECT id FROM account WHERE accno LIKE '5.2.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false);
-SELECT account_save(NULL, '5.2.05','Internet','E','', (SELECT id FROM account WHERE accno LIKE '5.2.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false);
+SELECT account__save(NULL, '5.2.00','Alquiler inmobiliario','E','', (SELECT id FROM account WHERE accno LIKE '5.2.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false, false);
+SELECT account__save(NULL, '5.2.01','Electricidad','E','', (SELECT id FROM account WHERE accno LIKE '5.2.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false, false);
+SELECT account__save(NULL, '5.2.02','Gas','E','', (SELECT id FROM account WHERE accno LIKE '5.2.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false, false);
+SELECT account__save(NULL, '5.2.03','Municipal','E','', (SELECT id FROM account WHERE accno LIKE '5.2.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false, false);
+SELECT account__save(NULL, '5.2.04','Telefonia','E','', (SELECT id FROM account WHERE accno LIKE '5.2.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false, false);
+SELECT account__save(NULL, '5.2.05','Internet','E','', (SELECT id FROM account WHERE accno LIKE '5.2.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false, false);
 SELECT account_heading_save(NULL, '5.3.','MANTENIMIENTO',(SELECT id FROM account_heading WHERE accno LIKE '5.'));
-SELECT account_save(NULL, '5.3.00','Propiedades','E','', (SELECT id FROM account WHERE accno LIKE '5.3.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false);
-SELECT account_save(NULL, '5.3.10','Vehiculos','E','', (SELECT id FROM account WHERE accno LIKE '5.3.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false);
-SELECT account_save(NULL, '5.3.20','Varios','E','', (SELECT id FROM account WHERE accno LIKE '5.3.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false);
+SELECT account__save(NULL, '5.3.00','Propiedades','E','', (SELECT id FROM account WHERE accno LIKE '5.3.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false, false);
+SELECT account__save(NULL, '5.3.10','Vehiculos','E','', (SELECT id FROM account WHERE accno LIKE '5.3.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false, false);
+SELECT account__save(NULL, '5.3.20','Varios','E','', (SELECT id FROM account WHERE accno LIKE '5.3.'), false, false, string_to_array('AP_amount:asset_expense', ':'), false, false);
 SELECT account_heading_save(NULL, '5.4.','OTROS GASTOS',(SELECT id FROM account_heading WHERE accno LIKE '5.'));
-SELECT account_save(NULL, '5.4.00','Vacaciones','E','', (SELECT id FROM account WHERE accno LIKE '5.4.'), false, false, string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL, '5.4.10','Cooperadora Escuela','E','', (SELECT id FROM account WHERE accno LIKE '5.4.'), false, false, string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL, '5.4.20','Cambio de Moneda Perdido','E','', (SELECT id FROM account WHERE accno LIKE '5.4.'), false, false, string_to_array('AP_amount', ':'), false);
+SELECT account__save(NULL, '5.4.00','Vacaciones','E','', (SELECT id FROM account WHERE accno LIKE '5.4.'), false, false, string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL, '5.4.10','Cooperadora Escuela','E','', (SELECT id FROM account WHERE accno LIKE '5.4.'), false, false, string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL, '5.4.20','Cambio de Moneda Perdido','E','', (SELECT id FROM account WHERE accno LIKE '5.4.'), false, false, string_to_array('AP_amount', ':'), false, false);
 commit;
 -- Impuestos
 -- Ganancias (9% - 35%)
@@ -100,7 +100,7 @@
 -- IVA Favor
 INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '1.4.10'), 0.21);
 
-SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
 FROM account WHERE id IN (select account_id FROM account_link
                            WHERE description = 'AP_paid');
 -- Sistema

Modified: trunk/sql/coa/at/chart/General.sql
===================================================================
--- trunk/sql/coa/at/chart/General.sql	2012-06-18 12:06:54 UTC (rev 4912)
+++ trunk/sql/coa/at/chart/General.sql	2012-06-18 12:25:28 UTC (rev 4913)
@@ -4,137 +4,137 @@
 -- checked and completed, Thu, 7 Feb 2002, Dieter Simader
 --
 SELECT account_heading_save(NULL, '0000', 'AUFWENDUNGEN FÃR INGANGSETZEN UND ERWEITERN DES BETRIEBES', NULL);
-SELECT account_save(NULL,'0010','Firmenwert','A','015', NULL, false, false, string_to_array('AP_amount', ':'), false);
+SELECT account__save(NULL,'0010','Firmenwert','A','015', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
 SELECT account_heading_save(NULL, '0100', 'IMMATERIELLE VERMÃGENSGEGENSTÃNDE', NULL);
-SELECT account_save(NULL,'0110','Rechte','A','011', NULL, false, false, string_to_array('AP_amount', ':'), false);
+SELECT account__save(NULL,'0110','Rechte','A','011', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
 SELECT account_heading_save(NULL, '0200', 'GRUNDSTÃCKE', NULL);
-SELECT account_save(NULL,'0210','unbebaute GrundstÃcke','A','020', NULL, false, false, string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL,'0220','bebaute GrundstÃcke','A','021', NULL, false, false, string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL,'0229','kum. Abschreibung bebaute GrundstÃcke','A','039', NULL, true, false, string_to_array('', ':'), false);
+SELECT account__save(NULL,'0210','unbebaute GrundstÃcke','A','020', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL,'0220','bebaute GrundstÃcke','A','021', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL,'0229','kum. Abschreibung bebaute GrundstÃcke','A','039', NULL, true, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '0400', 'MASCHINEN', NULL);
-SELECT account_save(NULL,'0410','Maschinen','A','041', NULL, false, false, string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL,'0419','kum. Abschreibung Maschinen','A','069', NULL, true, false, string_to_array('', ':'), false);
+SELECT account__save(NULL,'0410','Maschinen','A','041', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL,'0419','kum. Abschreibung Maschinen','A','069', NULL, true, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '0500', 'FAHRZEUGE', NULL);
-SELECT account_save(NULL,'0510','Fahrzeuge','A','063', NULL, false, false, string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL,'0519','kum. Abschreibung Fahrzeuge','A','069', NULL, true, false, string_to_array('', ':'), false);
+SELECT account__save(NULL,'0510','Fahrzeuge','A','063', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL,'0519','kum. Abschreibung Fahrzeuge','A','069', NULL, true, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '0600', 'BETRIEBS- UND GESCHÃFTSAUSSTATTUNG', NULL);
-SELECT account_save(NULL,'0620','BÃroeinrichtungen','A','066', NULL, false, false, string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL,'0625','kum. Abschreibung Betriebs- und GeschÃftsausstattung','A','069', NULL, true, false, string_to_array('', ':'), false);
+SELECT account__save(NULL,'0620','BÃroeinrichtungen','A','066', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL,'0625','kum. Abschreibung Betriebs- und GeschÃftsausstattung','A','069', NULL, true, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '0700', 'GELEISTETE ANZAHLUNGEN', NULL);
 SELECT account_heading_save(NULL, '0800', 'FINANZANLAGEN', NULL);
-SELECT account_save(NULL,'0810','Beteiligungen','A','081', NULL, false, false, string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL,'0820','Wertpapiere','A','080', NULL, false, false, string_to_array('AP_amount', ':'), false);
+SELECT account__save(NULL,'0810','Beteiligungen','A','081', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL,'0820','Wertpapiere','A','080', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
 SELECT account_heading_save(NULL, '1100', 'ROHSTOFFE', NULL);
-SELECT account_save(NULL,'1120','VorrÃte - Rohstoffe','A','110-119', NULL, false, false, string_to_array('IC', ':'), false);
+SELECT account__save(NULL,'1120','VorrÃte - Rohstoffe','A','110-119', NULL, false, false, string_to_array('IC', ':'), false, false);
 SELECT account_heading_save(NULL, '1200', 'BEZOGENE TEILE', NULL);
-SELECT account_save(NULL,'1220','VorrÃte - bezogene Teile','A','120-129', NULL, false, false, string_to_array('IC', ':'), false);
+SELECT account__save(NULL,'1220','VorrÃte - bezogene Teile','A','120-129', NULL, false, false, string_to_array('IC', ':'), false, false);
 SELECT account_heading_save(NULL, '1300', 'HILFS- UND BETRIEBSSTOFFE', NULL);
-SELECT account_save(NULL,'1320','Hilfsstoffe','A','130-134', NULL, false, false, string_to_array('IC', ':'), false);
-SELECT account_save(NULL,'1350','Betriebssstoffe','A','135-139', NULL, false, false, string_to_array('IC', ':'), false);
+SELECT account__save(NULL,'1320','Hilfsstoffe','A','130-134', NULL, false, false, string_to_array('IC', ':'), false, false);
+SELECT account__save(NULL,'1350','Betriebssstoffe','A','135-139', NULL, false, false, string_to_array('IC', ':'), false, false);
 SELECT account_heading_save(NULL, '1400', 'UNFERTIGE ERZEUGNISSE', NULL);
-SELECT account_save(NULL,'1420','VorrÃte - unfertige Erzeugnisse','A','140-149', NULL, false, false, string_to_array('IC', ':'), false);
+SELECT account__save(NULL,'1420','VorrÃte - unfertige Erzeugnisse','A','140-149', NULL, false, false, string_to_array('IC', ':'), false, false);
 SELECT account_heading_save(NULL, '1500', 'FERTIGE ERZEUGNISSE', NULL);
-SELECT account_save(NULL,'1520','VorrÃte - Hardware','A','150-159', NULL, false, false, string_to_array('IC', ':'), false);
-SELECT account_save(NULL,'1530','VorrÃte - Software','A','150-159', NULL, false, false, string_to_array('IC', ':'), false);
-SELECT account_save(NULL,'1540','VorrÃte - Ersatzteile','A','150-159', NULL, false, false, string_to_array('IC', ':'), false);
+SELECT account__save(NULL,'1520','VorrÃte - Hardware','A','150-159', NULL, false, false, string_to_array('IC', ':'), false, false);
+SELECT account__save(NULL,'1530','VorrÃte - Software','A','150-159', NULL, false, false, string_to_array('IC', ':'), false, false);
+SELECT account__save(NULL,'1540','VorrÃte - Ersatzteile','A','150-159', NULL, false, false, string_to_array('IC', ':'), false, false);
 SELECT account_heading_save(NULL, '1600', 'WAREN', NULL);
 SELECT account_heading_save(NULL, '1700', 'NOCH NICHT ABGERECHNETE LEISTUNGEN', NULL);
 SELECT account_heading_save(NULL, '1800', 'GELEISTETE ANZAHLUNGEN', NULL);
 SELECT account_heading_save(NULL, '1900', 'WERTBERICHTIGUNGEN', NULL);
 SELECT account_heading_save(NULL, '2000', 'FORDEUNGEN AUS LIEFERUNGEN UND LEISTUNGEN', NULL);
-SELECT account_save(NULL,'2010','Forderungen Lieferung & Leistung','A','200-207', NULL, false, false, string_to_array('AR', ':'), false);
-SELECT account_save(NULL,'2019','Wertberichtigung uneinbringliche Forderungen','A','20-21', NULL, false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL,'2010','Forderungen Lieferung & Leistung','A','200-207', NULL, false, false, string_to_array('AR', ':'), false, false);
+SELECT account__save(NULL,'2019','Wertberichtigung uneinbringliche Forderungen','A','20-21', NULL, false, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '2300', 'SONSTIGE FORDERUNGEN', NULL);
-SELECT account_save(NULL,'2320','sonstige Forderungen','A','23-24', NULL, false, false, string_to_array('AP_amount', ':'), false);
+SELECT account__save(NULL,'2320','sonstige Forderungen','A','23-24', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
 SELECT account_heading_save(NULL, '2500', 'FORDERUNGEN AUS ABGABENVERRECHNUNG', NULL);
-SELECT account_save(NULL,'2520','sonstige Forderungen aus Abgebenverrechnung','A','25', NULL, false, false, string_to_array('AP_amount', ':'), false);
+SELECT account__save(NULL,'2520','sonstige Forderungen aus Abgebenverrechnung','A','25', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
 SELECT account_heading_save(NULL, '2600', 'WERTPAPIERE UND ANTEILE', NULL);
-SELECT account_save(NULL,'2620','Wertpapiere UmlaufvermÃgen','A','26', NULL, false, false, string_to_array('AP_amount', ':'), false);
+SELECT account__save(NULL,'2620','Wertpapiere UmlaufvermÃgen','A','26', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
 SELECT account_heading_save(NULL, '2700', 'KASSABESTAND', NULL);
-SELECT account_save(NULL,'2701','Kassa','A','27-28', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false);
+SELECT account__save(NULL,'2701','Kassa','A','27-28', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
 SELECT account_heading_save(NULL, '2800', 'SCHECKS, GUTHABEN BEI KREDITINSTITUTEN', NULL);
-SELECT account_save(NULL,'2810','Schecks','A','27-28', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false);
-SELECT account_save(NULL,'2820','Bankguthaben','A','280-288', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false);
+SELECT account__save(NULL,'2810','Schecks','A','27-28', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
+SELECT account__save(NULL,'2820','Bankguthaben','A','280-288', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
 SELECT account_heading_save(NULL, '3100', 'LANGFRISTIGE VERBINDLICHKEITEN', NULL);
-SELECT account_save(NULL,'3110','Bank Verbindlichkeiten','L','31', NULL, false, false, string_to_array('', ':'), false);
-SELECT account_save(NULL,'3120','Kredite von EigentÃmern','L','310', NULL, false, false, string_to_array('AP_paid', ':'), false);
+SELECT account__save(NULL,'3110','Bank Verbindlichkeiten','L','31', NULL, false, false, string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'3120','Kredite von EigentÃmern','L','310', NULL, false, false, string_to_array('AP_paid', ':'), false, false);
 SELECT account_heading_save(NULL, '3300', 'VERBINDLICHKEITEN AUS LIEFERUNGEN UND LEISTUNGEN', NULL);
-SELECT account_save(NULL,'3310','Verbindlichkeiten aus Lieferungen und Leistungen','L','330-335', NULL, false, false, string_to_array('AP', ':'), false);
+SELECT account__save(NULL,'3310','Verbindlichkeiten aus Lieferungen und Leistungen','L','330-335', NULL, false, false, string_to_array('AP', ':'), false, false);
 SELECT account_heading_save(NULL, '3500', 'VERBINDLICHKEITEN FINANZAMT', NULL);
-SELECT account_save(NULL,'3510','Finanzamt Verrechnung KÃrperschaftssteuer','L','350-359', NULL, false, false, string_to_array('', ':'), false);
-SELECT account_save(NULL,'3520','Finanzamt Verrechnung Umsatzsteuer','L','350-359', NULL, false, false, string_to_array('', ':'), false);
-SELECT account_save(NULL,'3530','Mehrwertsteuer 0%','L','350-359', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'), false);
-SELECT account_save(NULL,'3531','Mehrwertsteuer 10%','L','350-359', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'), false);
-SELECT account_save(NULL,'3532','Mehrwertsteuer 20%','L','350-359', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'), false);
-SELECT account_save(NULL,'3540','Vorsteuer 0%','L','350-359', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'), false);
-SELECT account_save(NULL,'3541','Vorsteuer 10%','L','350-359', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'), false);
-SELECT account_save(NULL,'3542','Vorsteuer 20%','L','350-359', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'), false);
+SELECT account__save(NULL,'3510','Finanzamt Verrechnung KÃrperschaftssteuer','L','350-359', NULL, false, false, string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'3520','Finanzamt Verrechnung Umsatzsteuer','L','350-359', NULL, false, false, string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'3530','Mehrwertsteuer 0%','L','350-359', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'), false, false);
+SELECT account__save(NULL,'3531','Mehrwertsteuer 10%','L','350-359', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'), false, false);
+SELECT account__save(NULL,'3532','Mehrwertsteuer 20%','L','350-359', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'), false, false);
+SELECT account__save(NULL,'3540','Vorsteuer 0%','L','350-359', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'), false, false);
+SELECT account__save(NULL,'3541','Vorsteuer 10%','L','350-359', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'), false, false);
+SELECT account__save(NULL,'3542','Vorsteuer 20%','L','350-359', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'), false, false);
 SELECT account_heading_save(NULL, '4000', 'UMSATZ', NULL);
-SELECT account_save(NULL,'4020','Verkauf - Hardware','I','40-44', NULL, false, false, string_to_array('AR_amount:IC_sale', ':'), false);
-SELECT account_save(NULL,'4030','Verkauf - Software ','I','40-44', NULL, false, false, string_to_array('AR_amount:IC_sale', ':'), false);
-SELECT account_save(NULL,'4040','Verkauf - Ersatzteile','I','40-44', NULL, false, false, string_to_array('AR_amount:IC_sale', ':'), false);
+SELECT account__save(NULL,'4020','Verkauf - Hardware','I','40-44', NULL, false, false, string_to_array('AR_amount:IC_sale', ':'), false, false);
+SELECT account__save(NULL,'4030','Verkauf - Software ','I','40-44', NULL, false, false, string_to_array('AR_amount:IC_sale', ':'), false, false);
+SELECT account__save(NULL,'4040','Verkauf - Ersatzteile','I','40-44', NULL, false, false, string_to_array('AR_amount:IC_sale', ':'), false, false);
 SELECT account_heading_save(NULL, '4300', 'UMSATZ BERATUNG', NULL);
-SELECT account_save(NULL,'4320','ErlÃse Beratung','I','40-44', NULL, false, false, string_to_array('AR_amount:IC_income', ':'), false);
-SELECT account_save(NULL,'4330','ErlÃse Programmierung','I','40-44', NULL, false, false, string_to_array('AR_amount:IC_income', ':'), false);
+SELECT account__save(NULL,'4320','ErlÃse Beratung','I','40-44', NULL, false, false, string_to_array('AR_amount:IC_income', ':'), false, false);
+SELECT account__save(NULL,'4330','ErlÃse Programmierung','I','40-44', NULL, false, false, string_to_array('AR_amount:IC_income', ':'), false, false);
 SELECT account_heading_save(NULL, '4600', 'SONSTIGE ERLÃSE', NULL);
-SELECT account_save(NULL,'4630','FrachterlÃse','I','46-49', NULL, false, false, string_to_array('IC_income', ':'), false);
+SELECT account__save(NULL,'4630','FrachterlÃse','I','46-49', NULL, false, false, string_to_array('IC_income', ':'), false, false);
 SELECT account_heading_save(NULL, '5000', 'WARENEINSATZ', NULL);
-SELECT account_save(NULL,'5020','Wareneinsatz / Hardware','E','500-509', NULL, false, false, string_to_array('AP_amount:IC_cogs', ':'), false);
-SELECT account_save(NULL,'5030','Wareneinsatz / Software','E','500-509', NULL, false, false, string_to_array('AP_amount:IC_cogs', ':'), false);
-SELECT account_save(NULL,'5040','Wareneinsatz / Ersatzteile','E','520-529', NULL, false, false, string_to_array('AP_amount:IC_cogs', ':'), false);
+SELECT account__save(NULL,'5020','Wareneinsatz / Hardware','E','500-509', NULL, false, false, string_to_array('AP_amount:IC_cogs', ':'), false, false);
+SELECT account__save(NULL,'5030','Wareneinsatz / Software','E','500-509', NULL, false, false, string_to_array('AP_amount:IC_cogs', ':'), false, false);
+SELECT account__save(NULL,'5040','Wareneinsatz / Ersatzteile','E','520-529', NULL, false, false, string_to_array('AP_amount:IC_cogs', ':'), false, false);
 SELECT account_heading_save(NULL, '5600', 'VERBRAUCH BRENN- UND TREIBSTOFFEN, ENERGIE UND WASSER', NULL);
-SELECT account_save(NULL,'5610','Energie, Wasser','E','560-569', NULL, false, false, string_to_array('AP_amount', ':'), false);
+SELECT account__save(NULL,'5610','Energie, Wasser','E','560-569', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
 SELECT account_heading_save(NULL, '6000', 'LOHNAUFWAND', NULL);
-SELECT account_save(NULL,'6010','Lohn ','E','600-619', NULL, false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL,'6010','Lohn ','E','600-619', NULL, false, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '6200', 'GEAHLTSAUFWAND', NULL);
-SELECT account_save(NULL,'6210','Gehalt ','E','620-639', NULL, false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL,'6210','Gehalt ','E','620-639', NULL, false, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '6500', 'GESETZLICHER SOZIALAUFWAND', NULL);
-SELECT account_save(NULL,'6510','Dienstgeberanteile','E','645-649', NULL, false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL,'6510','Dienstgeberanteile','E','645-649', NULL, false, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '6700', 'FREIWILLIGER SOZIALAUFWAND', NULL);
-SELECT account_save(NULL,'6710','freiwilliger Sozialaufwand','E','660-665', NULL, false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL,'6710','freiwilliger Sozialaufwand','E','660-665', NULL, false, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '7000', 'ABSCHREIBUNGEN', NULL);
-SELECT account_save(NULL,'7010','Abschreibungen','E','700', NULL, false, false, string_to_array('', ':'), false);
-SELECT account_save(NULL,'7020','geringwertige WirtschaftsgÃter','E','701-708', NULL, false, false, string_to_array('AP_amount', ':'), false);
+SELECT account__save(NULL,'7010','Abschreibungen','E','700', NULL, false, false, string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'7020','geringwertige WirtschaftsgÃter','E','701-708', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
 SELECT account_heading_save(NULL, '7100', 'SONSTIGE STEUERN', NULL);
-SELECT account_save(NULL,'7110','Ertragssteuern','E','710-719', NULL, false, false, string_to_array('', ':'), false);
-SELECT account_save(NULL,'7120','Grundsteuern','E','710-719', NULL, false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL,'7110','Ertragssteuern','E','710-719', NULL, false, false, string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'7120','Grundsteuern','E','710-719', NULL, false, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '7200', 'INSTANDHALTUNGSAUFWAND', NULL);
-SELECT account_save(NULL,'7210','Reparatur und Instandhaltung','E','720-729', NULL, false, false, string_to_array('AP_amount', ':'), false);
+SELECT account__save(NULL,'7210','Reparatur und Instandhaltung','E','720-729', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
 SELECT account_heading_save(NULL, '7300', 'TRANSPORTKOSTEN', NULL);
-SELECT account_save(NULL,'7310','Frachtaufwand','E','730-731', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'), false);
+SELECT account__save(NULL,'7310','Frachtaufwand','E','730-731', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'), false, false);
 SELECT account_heading_save(NULL, '7400', 'MIET-,PACHT-,LEASING-, LIZENZAUFWAND', NULL);
-SELECT account_save(NULL,'7410','Miete','E','740-743', NULL, false, false, string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL,'7411','Lizenzen','E','748-749', NULL, false, false, string_to_array('AP_amount', ':'), false);
+SELECT account__save(NULL,'7410','Miete','E','740-743', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL,'7411','Lizenzen','E','748-749', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
 SELECT account_heading_save(NULL, '7600', 'VERWALTUNGSKOSTEN', NULL);
-SELECT account_save(NULL,'7610','Beratungsaufwand','E','775-776', NULL, false, false, string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL,'7611','BÃromaterialien','E','760', NULL, false, false, string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL,'7615','Werbung und Marketing','E','765-768', NULL, false, false, string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL,'7620','uneinbringliche Forderungen','E','799', NULL, false, false, string_to_array('', ':'), false);
-SELECT account_save(NULL,'7630','Telephonkosten','E','738-739', NULL, false, false, string_to_array('AP_amount', ':'), false);
-SELECT account_save(NULL,'7631','Internetkosten','E','738-739', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'), false);
-SELECT account_save(NULL,'7632','Reise- und ReprÃsentationsaufwand','E','734-735', NULL, false, false, string_to_array('', ':'), false);
-SELECT account_save(NULL,'7634','RegistrierungsgebÃhren','E','748-749', NULL, false, false, string_to_array('AP_amount', ':'), false);
+SELECT account__save(NULL,'7610','Beratungsaufwand','E','775-776', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL,'7611','BÃromaterialien','E','760', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL,'7615','Werbung und Marketing','E','765-768', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL,'7620','uneinbringliche Forderungen','E','799', NULL, false, false, string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'7630','Telephonkosten','E','738-739', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
+SELECT account__save(NULL,'7631','Internetkosten','E','738-739', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'), false, false);
+SELECT account__save(NULL,'7632','Reise- und ReprÃsentationsaufwand','E','734-735', NULL, false, false, string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'7634','RegistrierungsgebÃhren','E','748-749', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
 SELECT account_heading_save(NULL, '7700', 'VERSICHERUNGEN', NULL);
-SELECT account_save(NULL,'7710','Versicherung','E','770-774', NULL, false, false, string_to_array('AP_amount', ':'), false);
+SELECT account__save(NULL,'7710','Versicherung','E','770-774', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
 SELECT account_heading_save(NULL, '8000', 'FINANZERTRÃGE UND FINANZAUFWENDUNGEN', NULL);
-SELECT account_save(NULL,'8020','Bankzinsen und GebÃhren','E','80-83', NULL, false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL,'8020','Bankzinsen und GebÃhren','E','80-83', NULL, false, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '8100', 'BETEILIGUNGSERTRÃGE', NULL);
-SELECT account_save(NULL,'8110','ErtrÃge aus Beteiligungen','I','800-804', NULL, false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL,'8110','ErtrÃge aus Beteiligungen','I','800-804', NULL, false, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '9000', 'KAPITAL', NULL);
-SELECT account_save(NULL,'9010','Aktien, GeschÃftsanteile','Q','900-918', NULL, false, false, string_to_array('', ':'), false);
-SELECT account_save(NULL,'9020','nicht einbezahltes Kapital','Q','919', NULL, false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL,'9010','Aktien, GeschÃftsanteile','Q','900-918', NULL, false, false, string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'9020','nicht einbezahltes Kapital','Q','919', NULL, false, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '9200', 'KAPITALRÃCKLAGEN', NULL);
-SELECT account_save(NULL,'9210','freie RÃcklage','Q','920-929', NULL, false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL,'9210','freie RÃcklage','Q','920-929', NULL, false, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '9300', 'GEWINN', NULL);
-SELECT account_save(NULL,'9310','Gewinnvortrag Vorjahr','Q','980', NULL, false, false, string_to_array('', ':'), false);
-SELECT account_save(NULL,'9320','Jahresgewinn','Q','985', NULL, false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL,'9310','Gewinnvortrag Vorjahr','Q','980', NULL, false, false, string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'9320','Jahresgewinn','Q','985', NULL, false, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '9400', 'RÃCKSTELLUNGEN', NULL);
-SELECT account_save(NULL,'9420','AbfertigungsrÃckstellung','L','300', NULL, false, false, string_to_array('', ':'), false);
-SELECT account_save(NULL,'9430','UrlaubsrÃckstellung','L','304-309', NULL, false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL,'9420','AbfertigungsrÃckstellung','L','300', NULL, false, false, string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'9430','UrlaubsrÃckstellung','L','304-309', NULL, false, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '9700', 'EINLAGEN STILLER GESELLSCHAFTER', NULL);
 SELECT account_heading_save(NULL, '9800', 'EB,SB,G+V KONTEN', NULL);
-SELECT account_save(NULL,'4640','Devisengewinne','I','80-83', NULL, false, false, string_to_array('', ':'), false);
-SELECT account_save(NULL,'8050','Devisenverluste','E','80-83', NULL, false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL,'4640','Devisengewinne','I','80-83', NULL, false, false, string_to_array('', ':'), false, false);
+SELECT account__save(NULL,'8050','Devisenverluste','E','80-83', NULL, false, false, string_to_array('', ':'), false, false);
 --
 insert into tax (chart_id,rate) values ((select id from chart where accno = '3530'),0.00);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '3531'),0.10);
@@ -161,6 +161,6 @@
        FROM account_link
        WHERE description LIKE '%_tax');
 
-SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
 FROM account WHERE accno = '2810';
 

Modified: trunk/sql/coa/au/chart/General-0000.sql
===================================================================
--- trunk/sql/coa/au/chart/General-0000.sql	2012-06-18 12:06:54 UTC (rev 4912)
+++ trunk/sql/coa/au/chart/General-0000.sql	2012-06-18 12:25:28 UTC (rev 4913)
@@ -7,109 +7,109 @@
 SELECT account_heading_save(NULL, '5600', 'GENERAL & ADMINISTRATIVE EXPENSES', NULL);
 SELECT account_heading_save(NULL, '6000', 'CAR EXPENSES', NULL);
 SELECT account_heading_save(NULL, '4300', 'OTHER REVENUE', NULL);
-SELECT account_save(NULL,'5470','Staff Amenities','E','', NULL, false, false, string_to_array('', ':'), false);
+SELECT account__save(NULL,'5470','Staff Amenities','E','', NULL, false, false, string_to_array('', ':'), false, false);
 SELECT account_heading_save(NULL, '1500', 'STOCK ON HAND', NULL);
 SELECT account_heading_save(NULL, '3300', 'EQUITY', NULL);
-SELECT account_save(NULL,'1520','SOH / Leather','A','1500', NULL, false, false, string_to_array('IC', ':'), false);
+SELECT account__save(NULL,'1520','SOH / Leather','A','1500', NULL, false, false, string_to_array('IC', ':'), false, false);
 SELECT account_heading_save(NULL, '1000', 'CURRENT ASSETS', NULL);
-SELECT account_save(NULL,'1820','Plant & Equipment - at Cost','A','1800', NULL, false, false, string_to_array('AP_amount', ':'), false);
+SELECT account__save(NULL,'1820','Plant & Equipment - at Cost','A','1800', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('1825', 'Less: Accumulated Depreciation', 'A', 'A', '', '1800', '1');
-SELECT account_save(NULL,'1840','Motor Vehicles - at Cost','A','1800', NULL, false, false, string_to_array('AP_amount', ':'), false);
+SELECT account__save(NULL,'1840','Motor Vehicles - at Cost','A','1800', NULL, false, false, string_to_array('AP_amount', ':'), false, false);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('1845', 'Less: Accumulated Depreciation', 'A', 'A', '', '1800', '1');
 SELECT account_heading_save(NULL, '1800', 'CAPITAL ASSETS', NULL);
-SELECT account_save(NULL,'1060','Cheque Account','A','1000', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false);
+SELECT account__save(NULL,'1060','Cheque Account','A','1000', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
 
-SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
 FROM account WHERE accno = '1060';
 
-SELECT account_save(NULL,'1205','Less: Provision Doubtful Debts','A','1000', NULL, false, false, string_to_array('', ':'), false);
-SELECT account_save(NULL,'1210','Trade Debtors / Australia - with GST','A','1000', NULL, false, false, string_to_array('AR', ':'), false);
-SELECT account_save(NULL,'1220','Trade Debtors / Exports - GST free','A','1000', NULL, false, false, string_to_array('AR', ':'), false);
-SELECT account_save(NULL,'1230','GST / Refund','A','1000', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'), false);
-SELECT account_save(NULL,'1530','SOH / PVC','A','1500', NULL, false, false, string_to_array('IC', ':'), false);
-SELECT account_save(NULL,'1540','SOH / Fabrics','A','1500', NULL, false, false, string_to_array('IC', ':'), false);

@@ Diff output truncated at 100000 characters. @@
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:[4912] trunk
Next by Date: SF.net SVN: ledger-smb:[4914] trunk/sql
Previous by thread: SF.net SVN: ledger-smb:[4912] trunk
Next by thread: SF.net SVN: ledger-smb:[4914] trunk/sql
Index(es):
- Date
- Thread