[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb:[4835] trunk
- Subject: SF.net SVN: ledger-smb:[4835] trunk
- From: ..hidden..
- Date: Mon, 04 Jun 2012 14:51:04 +0000
Revision: 4835
http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4835&view=rev
Author: einhverfr
Date: 2012-06-04 14:51:03 +0000 (Mon, 04 Jun 2012)
Log Message:
-----------
Most database load issues corrected. Now having issues with user creation
Modified Paths:
--------------
trunk/LedgerSMB.pm
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/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
trunk/sql/modules/Account.sql
trunk/sql/modules/Company.sql
trunk/sql/modules/Roles.sql
trunk/sql/modules/Util.sql
Modified: trunk/LedgerSMB.pm
===================================================================
--- trunk/LedgerSMB.pm 2012-06-04 13:15:28 UTC (rev 4834)
+++ trunk/LedgerSMB.pm 2012-06-04 14:51:03 UTC (rev 4835)
@@ -658,6 +658,7 @@
my $argstr = "";
my @results;
my $dbh = $LedgerSMB::App_State::DBH;
+ $dbh ||= $self->{dbh};
die 'Database handle not found!' if !$dbh;
if (!defined $procname){
Modified: trunk/sql/coa/Sample-chart.sql
===================================================================
--- trunk/sql/coa/Sample-chart.sql 2012-06-04 13:15:28 UTC (rev 4834)
+++ trunk/sql/coa/Sample-chart.sql 2012-06-04 14:51:03 UTC (rev 4835)
@@ -2,73 +2,73 @@
-- 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', ':'));
-SELECT account_save(NULL,'1065','Petty Cash','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'1200','Accounts Receivables','A','', NULL, false,string_to_array('AR', ':'));
-SELECT account_save(NULL,'1205','Allowance for doubtful accounts','A','', NULL, false,string_to_array('', ':'));
+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_heading_save(NULL, '1500', 'INVENTORY ASSETS', NULL);
-SELECT account_save(NULL,'1520','Inventory / General','A','', NULL, false,string_to_array('IC', ':'));
-SELECT account_save(NULL,'1530','Inventory / Aftermarket Parts','A','', NULL, false,string_to_array('IC', ':'));
+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_heading_save(NULL, '1800', 'CAPITAL ASSETS', NULL);
-SELECT account_save(NULL,'1820','Office Furniture & Equipment','A','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1825','Accum. Amort. -Furn. & Equip.','A','', NULL, true,string_to_array('',':'));
-SELECT account_save(NULL,'1840','Vehicle','A','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1845','Accum. Amort. -Vehicle','A','', NULL, true,string_to_array('',':'));
+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_heading_save(NULL, '2000', 'CURRENT LIABILITIES', NULL);
-SELECT account_save(NULL,'2100','Accounts Payable','L','', NULL, false,string_to_array('AP', ':'));
-SELECT account_save(NULL,'2160','Corporate Taxes Payable','L','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2190','Federal Income Tax Payable','L','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2210','Workers Comp Payable','L','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2220','Vacation Pay Payable','L','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2250','Pension Plan Payable','L','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2260','Employment Insurance Payable','L','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2280','Payroll Taxes Payable','L','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2310','VAT (10%)','L','', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'2320','VAT (14%)','L','', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'2330','VAT (30%)','L','', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_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_heading_save(NULL, '2600', 'LONG TERM LIABILITIES', NULL);
-SELECT account_save(NULL,'2620','Bank Loans','L','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2680','Loans from Shareholders','L','', NULL, false,string_to_array('AP_paid', ':'));
+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_heading_save(NULL, '3300', 'SHARE CAPITAL', NULL);
-SELECT account_save(NULL,'3350','Common Shares','Q','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3350','Common Shares','Q','', NULL, false,string_to_array('', ':'), 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', ':'));
-SELECT account_save(NULL,'4030','Sales / Aftermarket Parts','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+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_heading_save(NULL, '4300', 'CONSULTING REVENUE', NULL);
-SELECT account_save(NULL,'4320','Consulting','I','', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'4320','Consulting','I','', NULL, false,string_to_array('AR_amount:IC_income', ':'), 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', ':'));
-SELECT account_save(NULL,'4440','Interest','I','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'4450','Foreign Exchange Gain','I','', NULL, false,string_to_array('', ':'));
+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_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', ':'));
-SELECT account_save(NULL,'5020','COGS / General','E','', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
-SELECT account_save(NULL,'5030','COGS / Aftermarket Parts','E','', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
-SELECT account_save(NULL,'5100','Freight','E','', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+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_heading_save(NULL, '5400', 'PAYROLL EXPENSES', NULL);
-SELECT account_save(NULL,'5410','Wages & Salaries','E','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5420','Employment Insurance Expense','E','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5430','Pension Plan Expense','E','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5440','Workers Comp Expense','E','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5470','Employee Benefits','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'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_heading_save(NULL, '5600', 'GENERAL & ADMINISTRATIVE EXPENSES', NULL);
-SELECT account_save(NULL,'5610','Accounting & Legal','E','', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5615','Advertising & Promotions','E','', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5620','Bad Debts','E','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5650','Capital Cost Allowance Expense','E','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5660','Amortization Expense','E','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5680','Income Taxes','E','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5685','Insurance','E','', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5690','Interest & Bank Charges','E','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5700','Office Supplies','E','', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5760','Rent','E','', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5765','Repair & Maintenance','E','', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5780','Telephone','E','', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5785','Travel & Entertainment','E','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5790','Utilities','E','', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5795','Registrations','E','', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5800','Licenses','E','', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5810','Foreign Exchange Loss','E','', NULL, false,string_to_array('', ':'));
+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 cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE id IN (select account_id FROM account_link
Modified: trunk/sql/coa/ar/chart/General.sql
===================================================================
--- trunk/sql/coa/ar/chart/General.sql 2012-06-04 13:15:28 UTC (rev 4834)
+++ trunk/sql/coa/ar/chart/General.sql 2012-06-04 14:51:03 UTC (rev 4835)
@@ -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', ':'));
-SELECT account_save(NULL, '0.02','A Pagar','A','', (SELECT id FROM account WHERE accno LIKE '0.'), false, false, string_to_array('AP', ':'));
-SELECT account_save(NULL, '0.03','Inventario','A','', (SELECT id FROM account WHERE accno LIKE '0.'), false, false, string_to_array('IC', ':'));
+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);
-- 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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
+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_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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
+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_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('', ':'));
+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_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('', ':'));
-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('', ':'));
+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_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', ':'));
+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_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', ':'));
-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('', ':'));
+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_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', ':'));
+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_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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
+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_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', ':'));
-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', ':'));
+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_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', ':'));
-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', ':'));
-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', ':'));
+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_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('', ':'));
-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('', ':'));
+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_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('', ':'));
+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_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('', ':'));
+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_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('', ':'));
+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);
-- 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', ':'));
-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', ':'));
-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', ':'));
+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_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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
+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_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', ':'));
+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_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('', ':'));
+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_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('', ':'));
+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_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', ':'));
-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', ':'));
-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', ':'));
+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_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', ':'));
-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', ':'));
+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_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', ':'));
-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', ':'));
-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', ':'));
-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('', ':'));
+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);
-- 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', ':'));
-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', ':'));
-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', ':'));
+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_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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
+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_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', ':'));
-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', ':'));
+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_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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
+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_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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
+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_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', ':'));
-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('', ':'));
+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);
commit;
-- Impuestos
-- Ganancias
Modified: trunk/sql/coa/ar/chart/Personal.sql
===================================================================
--- trunk/sql/coa/ar/chart/Personal.sql 2012-06-04 13:15:28 UTC (rev 4834)
+++ trunk/sql/coa/ar/chart/Personal.sql 2012-06-04 14:51:03 UTC (rev 4835)
@@ -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', ':'));
-SELECT account_save(NULL, '0.10','A Pagar','A','', (SELECT id FROM account WHERE accno LIKE '0.'), false, false, string_to_array('AP', ':'));
-SELECT account_save(NULL, '0.20','Inventario','A','', (SELECT id FROM account WHERE accno LIKE '0.'), false, false, string_to_array('IC', ':'));
+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);
-- 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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
+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_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', ':'));
-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', ':'));
+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_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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
+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_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('', ':'));
-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', ':'));
-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('', ':'));
+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);
-- 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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
+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_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', ':'));
+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_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('', ':'));
+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);
-- 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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
+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_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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
+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);
-- 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', ':'));
-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', ':'));
-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', ':'));
+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_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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
-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', ':'));
+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_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', ':'));
-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', ':'));
-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', ':'));
+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_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', ':'));
-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', ':'));
-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', ':'));
+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);
commit;
-- Impuestos
-- Ganancias (9% - 35%)
Modified: trunk/sql/coa/at/chart/General.sql
===================================================================
--- trunk/sql/coa/at/chart/General.sql 2012-06-04 13:15:28 UTC (rev 4834)
+++ trunk/sql/coa/at/chart/General.sql 2012-06-04 14:51:03 UTC (rev 4835)
@@ -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', ':'));
+SELECT account_save(NULL,'0010','Firmenwert','A','015', NULL, false, false, string_to_array('AP_amount', ':'), 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', ':'));
+SELECT account_save(NULL,'0110','Rechte','A','011', NULL, false, false, string_to_array('AP_amount', ':'), 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', ':'));
-SELECT account_save(NULL,'0220','bebaute GrundstÃcke','A','021', NULL, false, false, string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'0229','kum. Abschreibung bebaute GrundstÃcke','A','039', NULL, true, false, string_to_array('', ':'));
+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_heading_save(NULL, '0400', 'MASCHINEN', NULL);
-SELECT account_save(NULL,'0410','Maschinen','A','041', NULL, false, false, string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'0419','kum. Abschreibung Maschinen','A','069', NULL, true, false, string_to_array('', ':'));
+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_heading_save(NULL, '0500', 'FAHRZEUGE', NULL);
-SELECT account_save(NULL,'0510','Fahrzeuge','A','063', NULL, false, false, string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'0519','kum. Abschreibung Fahrzeuge','A','069', NULL, true, false, string_to_array('', ':'));
+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_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', ':'));
-SELECT account_save(NULL,'0625','kum. Abschreibung Betriebs- und GeschÃftsausstattung','A','069', NULL, true, false, string_to_array('', ':'));
+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_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', ':'));
-SELECT account_save(NULL,'0820','Wertpapiere','A','080', NULL, false, false, string_to_array('AP_amount', ':'));
+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_heading_save(NULL, '1100', 'ROHSTOFFE', NULL);
-SELECT account_save(NULL,'1120','VorrÃte - Rohstoffe','A','110-119', NULL, false, false, string_to_array('IC', ':'));
+SELECT account_save(NULL,'1120','VorrÃte - Rohstoffe','A','110-119', NULL, false, false, string_to_array('IC', ':'), 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', ':'));
+SELECT account_save(NULL,'1220','VorrÃte - bezogene Teile','A','120-129', NULL, false, false, string_to_array('IC', ':'), 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', ':'));
-SELECT account_save(NULL,'1350','Betriebssstoffe','A','135-139', NULL, false, false, string_to_array('IC', ':'));
+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_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', ':'));
+SELECT account_save(NULL,'1420','VorrÃte - unfertige Erzeugnisse','A','140-149', NULL, false, false, string_to_array('IC', ':'), 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', ':'));
-SELECT account_save(NULL,'1530','VorrÃte - Software','A','150-159', NULL, false, false, string_to_array('IC', ':'));
-SELECT account_save(NULL,'1540','VorrÃte - Ersatzteile','A','150-159', NULL, false, false, string_to_array('IC', ':'));
+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_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', ':'));
-SELECT account_save(NULL,'2019','Wertberichtigung uneinbringliche Forderungen','A','20-21', NULL, false, false, string_to_array('', ':'));
+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_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', ':'));
+SELECT account_save(NULL,'2320','sonstige Forderungen','A','23-24', NULL, false, false, string_to_array('AP_amount', ':'), 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', ':'));
+SELECT account_save(NULL,'2520','sonstige Forderungen aus Abgebenverrechnung','A','25', NULL, false, false, string_to_array('AP_amount', ':'), 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', ':'));
+SELECT account_save(NULL,'2620','Wertpapiere UmlaufvermÃgen','A','26', NULL, false, false, string_to_array('AP_amount', ':'), 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', ':'));
+SELECT account_save(NULL,'2701','Kassa','A','27-28', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), 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', ':'));
-SELECT account_save(NULL,'2820','Bankguthaben','A','280-288', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+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_heading_save(NULL, '3100', 'LANGFRISTIGE VERBINDLICHKEITEN', NULL);
-SELECT account_save(NULL,'3110','Bank Verbindlichkeiten','L','31', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'3120','Kredite von EigentÃmern','L','310', NULL, false, false, string_to_array('AP_paid', ':'));
+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_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', ':'));
+SELECT account_save(NULL,'3310','Verbindlichkeiten aus Lieferungen und Leistungen','L','330-335', NULL, false, false, string_to_array('AP', ':'), 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('', ':'));
-SELECT account_save(NULL,'3520','Finanzamt Verrechnung Umsatzsteuer','L','350-359', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'3530','Mehrwertsteuer 0%','L','350-359', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'3531','Mehrwertsteuer 10%','L','350-359', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'3532','Mehrwertsteuer 20%','L','350-359', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'3540','Vorsteuer 0%','L','350-359', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'3541','Vorsteuer 10%','L','350-359', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'3542','Vorsteuer 20%','L','350-359', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+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_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', ':'));
-SELECT account_save(NULL,'4030','Verkauf - Software ','I','40-44', NULL, false, false, string_to_array('AR_amount:IC_sale', ':'));
-SELECT account_save(NULL,'4040','Verkauf - Ersatzteile','I','40-44', NULL, false, false, string_to_array('AR_amount:IC_sale', ':'));
+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_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', ':'));
-SELECT account_save(NULL,'4330','ErlÃse Programmierung','I','40-44', NULL, false, false, string_to_array('AR_amount:IC_income', ':'));
+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_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', ':'));
+SELECT account_save(NULL,'4630','FrachterlÃse','I','46-49', NULL, false, false, string_to_array('IC_income', ':'), 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', ':'));
-SELECT account_save(NULL,'5030','Wareneinsatz / Software','E','500-509', NULL, false, false, string_to_array('AP_amount:IC_cogs', ':'));
-SELECT account_save(NULL,'5040','Wareneinsatz / Ersatzteile','E','520-529', NULL, false, false, string_to_array('AP_amount:IC_cogs', ':'));
+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_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', ':'));
+SELECT account_save(NULL,'5610','Energie, Wasser','E','560-569', NULL, false, false, string_to_array('AP_amount', ':'), false);
SELECT account_heading_save(NULL, '6000', 'LOHNAUFWAND', NULL);
-SELECT account_save(NULL,'6010','Lohn ','E','600-619', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'6010','Lohn ','E','600-619', NULL, false, false, string_to_array('', ':'), false);
SELECT account_heading_save(NULL, '6200', 'GEAHLTSAUFWAND', NULL);
-SELECT account_save(NULL,'6210','Gehalt ','E','620-639', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'6210','Gehalt ','E','620-639', NULL, false, false, string_to_array('', ':'), 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('', ':'));
+SELECT account_save(NULL,'6510','Dienstgeberanteile','E','645-649', NULL, false, false, string_to_array('', ':'), 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('', ':'));
+SELECT account_save(NULL,'6710','freiwilliger Sozialaufwand','E','660-665', NULL, false, false, string_to_array('', ':'), false);
SELECT account_heading_save(NULL, '7000', 'ABSCHREIBUNGEN', NULL);
-SELECT account_save(NULL,'7010','Abschreibungen','E','700', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'7020','geringwertige WirtschaftsgÃter','E','701-708', NULL, false, false, string_to_array('AP_amount', ':'));
+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_heading_save(NULL, '7100', 'SONSTIGE STEUERN', NULL);
-SELECT account_save(NULL,'7110','Ertragssteuern','E','710-719', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'7120','Grundsteuern','E','710-719', NULL, false, false, string_to_array('', ':'));
+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_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', ':'));
+SELECT account_save(NULL,'7210','Reparatur und Instandhaltung','E','720-729', NULL, false, false, string_to_array('AP_amount', ':'), 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', ':'));
+SELECT account_save(NULL,'7310','Frachtaufwand','E','730-731', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'), 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', ':'));
-SELECT account_save(NULL,'7411','Lizenzen','E','748-749', NULL, false, false, string_to_array('AP_amount', ':'));
+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_heading_save(NULL, '7600', 'VERWALTUNGSKOSTEN', NULL);
-SELECT account_save(NULL,'7610','Beratungsaufwand','E','775-776', NULL, false, false, string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'7611','BÃromaterialien','E','760', NULL, false, false, string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'7615','Werbung und Marketing','E','765-768', NULL, false, false, string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'7620','uneinbringliche Forderungen','E','799', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'7630','Telephonkosten','E','738-739', NULL, false, false, string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'7631','Internetkosten','E','738-739', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'7632','Reise- und ReprÃsentationsaufwand','E','734-735', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'7634','RegistrierungsgebÃhren','E','748-749', NULL, false, false, string_to_array('AP_amount', ':'));
+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_heading_save(NULL, '7700', 'VERSICHERUNGEN', NULL);
-SELECT account_save(NULL,'7710','Versicherung','E','770-774', NULL, false, false, string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'7710','Versicherung','E','770-774', NULL, false, false, string_to_array('AP_amount', ':'), 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('', ':'));
+SELECT account_save(NULL,'8020','Bankzinsen und GebÃhren','E','80-83', NULL, false, false, string_to_array('', ':'), 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('', ':'));
+SELECT account_save(NULL,'8110','ErtrÃge aus Beteiligungen','I','800-804', NULL, false, false, string_to_array('', ':'), 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('', ':'));
-SELECT account_save(NULL,'9020','nicht einbezahltes Kapital','Q','919', NULL, false, false, string_to_array('', ':'));
+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_heading_save(NULL, '9200', 'KAPITALRÃCKLAGEN', NULL);
-SELECT account_save(NULL,'9210','freie RÃcklage','Q','920-929', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'9210','freie RÃcklage','Q','920-929', NULL, false, false, string_to_array('', ':'), false);
SELECT account_heading_save(NULL, '9300', 'GEWINN', NULL);
-SELECT account_save(NULL,'9310','Gewinnvortrag Vorjahr','Q','980', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'9320','Jahresgewinn','Q','985', NULL, false, false, string_to_array('', ':'));
+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_heading_save(NULL, '9400', 'RÃCKSTELLUNGEN', NULL);
-SELECT account_save(NULL,'9420','AbfertigungsrÃckstellung','L','300', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'9430','UrlaubsrÃckstellung','L','304-309', NULL, false, false, string_to_array('', ':'));
+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_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('', ':'));
-SELECT account_save(NULL,'8050','Devisenverluste','E','80-83', NULL, false, false, string_to_array('', ':'));
+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);
--
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);
Modified: trunk/sql/coa/au/chart/General-0000.sql
===================================================================
--- trunk/sql/coa/au/chart/General-0000.sql 2012-06-04 13:15:28 UTC (rev 4834)
+++ trunk/sql/coa/au/chart/General-0000.sql 2012-06-04 14:51:03 UTC (rev 4835)
@@ -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('', ':'));
+SELECT account_save(NULL,'5470','Staff Amenities','E','', NULL, false, false, string_to_array('', ':'), 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', ':'));
+SELECT account_save(NULL,'1520','SOH / Leather','A','1500', NULL, false, false, string_to_array('IC', ':'), 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', ':'));
+SELECT account_save(NULL,'1820','Plant & Equipment - at Cost','A','1800', NULL, false, false, string_to_array('AP_amount', ':'), 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', ':'));
+SELECT account_save(NULL,'1840','Motor Vehicles - at Cost','A','1800', NULL, false, false, string_to_array('AP_amount', ':'), 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', ':'));
+SELECT account_save(NULL,'1060','Cheque Account','A','1000', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false);
SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno = '1060';
-SELECT account_save(NULL,'1205','Less: Provision Doubtful Debts','A','1000', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'1210','Trade Debtors / Australia - with GST','A','1000', NULL, false, false, string_to_array('AR', ':'));
-SELECT account_save(NULL,'1220','Trade Debtors / Exports - GST free','A','1000', NULL, false, false, string_to_array('AR', ':'));
-SELECT account_save(NULL,'1230','GST / Refund','A','1000', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'1530','SOH / PVC','A','1500', NULL, false, false, string_to_array('IC', ':'));
-SELECT account_save(NULL,'1540','SOH / Fabrics','A','1500', NULL, false, false, string_to_array('IC', ':'));
-SELECT account_save(NULL,'1550','SOH / Metal Hardware / Fasteners / Accessories','A','1500', NULL, false, false, string_to_array('IC', ':'));
-SELECT account_save(NULL,'1560','SOH / Paint / Glue / Dye','A','1500', NULL, false, false, string_to_array('IC', ':'));
-SELECT account_save(NULL,'1570','SOH / Threads / Tapes / Cords / Laces','A','1500', NULL, false, false, string_to_array('IC', ':'));
-SELECT account_save(NULL,'1580','SOH / Other Goods','A','1500', NULL, false, false, string_to_array('IC', ':'));
-SELECT account_save(NULL,'2100','Trade Creditors','L','2000', NULL, false, false, string_to_array('AP', ':'));
-SELECT account_save(NULL,'2160','Taxation - Payable','L','2000', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'2210','Workers Compensation - Payable','L','2000', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'2250','Superannuation - Payable','L','2000', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'2260','Insurance - Payable','L','2000', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'2290','GST / Payable','L','2000', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'2300','GST Payments / Refunds','L','2000', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'2310','GST Adjustments','L','2000', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'3350','Issued & Paid up Capital','Q','3300', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'3370','Opening Account Balance','Q','3300', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'3380','Credit Payments / Holding Account','Q','', NULL, false, false, string_to_array('AR_paid', ':'));
-SELECT account_save(NULL,'4020','Sales / Manufactured Products','I','4000', NULL, false, false, string_to_array('AR_amount:IC_sale', ':'));
-SELECT account_save(NULL,'4030','Sales / General','I','4000', NULL, false, false, string_to_array('AR_amount:IC_sale:IC_income', ':'));
-SELECT account_save(NULL,'4410','Shop Labour','I','4000', NULL, false, false, string_to_array('IC_income', ':'));
-SELECT account_save(NULL,'4420','Design / Patternmaking','I','4000', NULL, false, false, string_to_array('IC_income', ':'));
-SELECT account_save(NULL,'4430','Shipping & Handling','I','4000', NULL, false, false, string_to_array('IC_income', ':'));
-SELECT account_save(NULL,'4440','Interest Received','I','4000', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'4450','Foreign Exchange Profit','I','4000', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'4460','Mark-Up / Price Adjustment','I','4000', NULL, false, false, string_to_array('IC_income', ':'));
-SELECT account_save(NULL,'4470','Computer Consultancy / Training','I','4000', NULL, false, false, string_to_array('IC_income', ':'));
-SELECT account_save(NULL,'2620','Bank Loans','L','2000', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'2640','Hire Purchase','L','2000', NULL, false, false, string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'2650','Other Loans','L','2000', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'5020','COGS / Leather','E','5000', NULL, false, false, string_to_array('IC_cogs', ':'));
-SELECT account_save(NULL,'5030','COGS / PVC','E','5000', NULL, false, false, string_to_array('IC_cogs', ':'));
-SELECT account_save(NULL,'5040','COGS / Fabrics','E','5000', NULL, false, false, string_to_array('IC_cogs', ':'));
-SELECT account_save(NULL,'5050','COGS / Metal Hardware / Fasteners / Accessories','E','5000', NULL, false, false, string_to_array('IC_cogs', ':'));
-SELECT account_save(NULL,'5060','COGS / Paint / Glue / Dye','E','5000', NULL, false, false, string_to_array('IC_cogs', ':'));
-SELECT account_save(NULL,'5070','COGS / Threads / Tapes / Cords / Laces','E','5000', NULL, false, false, string_to_array('IC_cogs', ':'));
-SELECT account_save(NULL,'5080','COGS / Other Goods','E','5000', NULL, false, false, string_to_array('IC_cogs', ':'));
-SELECT account_save(NULL,'5410','Wages','E','5000', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'5430','Superannuation','E','5000', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'5440','Workers Compensation','E','5000', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'5605','External labour costs','E','5000', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'5610','Accountancy','E','5000', NULL, false, false, string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5611','Legal Fees','E','5000', NULL, false, false, string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5613','Postage / Printing / Stationery','E','5000', NULL, false, false, string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5614','Freight and Cartage','E','5000', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
@@ Diff output truncated at 100000 characters. @@
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.