[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb:[4918] trunk/sql/coa
- Subject: SF.net SVN: ledger-smb:[4918] trunk/sql/coa
- From: ..hidden..
- Date: Tue, 19 Jun 2012 02:13:52 +0000
Revision: 4918
http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4918&view=rev
Author: einhverfr
Date: 2012-06-19 02:13:51 +0000 (Tue, 19 Jun 2012)
Log Message:
-----------
Correcting automation running amok on coa's
Modified Paths:
--------------
trunk/sql/coa/Sample-chart.sql
trunk/sql/coa/ar/chart/General.sql
trunk/sql/coa/ar/chart/Personal.sql
trunk/sql/coa/at/chart/General.sql
trunk/sql/coa/au/chart/General-0000.sql
trunk/sql/coa/au/chart/General-00000.sql
trunk/sql/coa/be/chart/General.sql
trunk/sql/coa/br/chart/General.sql
trunk/sql/coa/ca/chart/English_General.sql
trunk/sql/coa/ca/chart/French-Quebec_General.sql
trunk/sql/coa/ch/chart/German.sql
trunk/sql/coa/cn/chart/General.sql
trunk/sql/coa/co/chart/PUC.sql
trunk/sql/coa/cz/chart/General.sql
trunk/sql/coa/de/chart/DATEV-SKR03.sql
trunk/sql/coa/de/chart/General.sql
trunk/sql/coa/de/chart/SKR03.sql
trunk/sql/coa/dk/chart/General.sql
trunk/sql/coa/eg/chart/General.sql
trunk/sql/coa/fr/chart/General.sql
trunk/sql/coa/hu/chart/Complete.sql
trunk/sql/coa/hu/chart/Minimal.sql
trunk/sql/coa/hu/chart/Old-general.sql
trunk/sql/coa/id/chart/General.sql
trunk/sql/coa/it/chart/General.sql
trunk/sql/coa/it/chart/cc2424.sql
trunk/sql/coa/lv/chart/General.sql
trunk/sql/coa/nl/chart/General.sql
trunk/sql/coa/nl/chart/Simple.sql
trunk/sql/coa/no/chart/General.sql
trunk/sql/coa/pl/chart/General.sql
trunk/sql/coa/se/chart/Agriculture.sql
trunk/sql/coa/se/chart/Church_Society.sql
trunk/sql/coa/se/chart/General.sql
trunk/sql/coa/tw/chart/General.sql
trunk/sql/coa/uk/chart/General.sql
trunk/sql/coa/us/chart/General.sql
trunk/sql/coa/us/chart/Manufacturing.sql
trunk/sql/coa/us/chart/Service.sql
trunk/sql/coa/us/chart/UCOA-Form990.sql
trunk/sql/coa/us/chart/UCOA-Form990EZ.sql
trunk/sql/coa/ve/chart/General.sql
Modified: trunk/sql/coa/Sample-chart.sql
===================================================================
--- trunk/sql/coa/Sample-chart.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/Sample-chart.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -70,7 +70,7 @@
SELECT account__save(NULL,'5800','Licenses','E','', NULL, false,string_to_array('AP_amount', ':'), false, false);
SELECT account__save(NULL,'5810','Foreign Exchange Loss','E','', NULL, false,string_to_array('', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE id IN (select account_id FROM account_link
WHERE description = 'AP_paid');
--
Modified: trunk/sql/coa/ar/chart/General.sql
===================================================================
--- trunk/sql/coa/ar/chart/General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/ar/chart/General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -142,7 +142,7 @@
-- IVA Favor
INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '1.1.5.01'), 0.21);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE id IN (select account_id FROM account_link
WHERE description = 'AP_paid');
-- Sistema
Modified: trunk/sql/coa/ar/chart/Personal.sql
===================================================================
--- trunk/sql/coa/ar/chart/Personal.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/ar/chart/Personal.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -100,7 +100,7 @@
-- IVA Favor
INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '1.4.10'), 0.21);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE id IN (select account_id FROM account_link
WHERE description = 'AP_paid');
-- Sistema
Modified: trunk/sql/coa/at/chart/General.sql
===================================================================
--- trunk/sql/coa/at/chart/General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/at/chart/General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -161,6 +161,6 @@
FROM account_link
WHERE description LIKE '%_tax');
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno = '2810';
Modified: trunk/sql/coa/au/chart/General-0000.sql
===================================================================
--- trunk/sql/coa/au/chart/General-0000.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/au/chart/General-0000.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -19,7 +19,7 @@
SELECT account_heading_save(NULL, '1800', 'CAPITAL ASSETS', NULL);
SELECT account__save(NULL,'1060','Cheque Account','A','1000', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, 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('', ':'), false, false);
Modified: trunk/sql/coa/au/chart/General-00000.sql
===================================================================
--- trunk/sql/coa/au/chart/General-00000.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/au/chart/General-00000.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -5,7 +5,7 @@
SELECT account_heading_save(NULL, '10000', 'BANK AND CASH ACCOUNTS', NULL);
SELECT account__save(NULL,'10001','Bank Account','A','100', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
SELECT account__save(NULL,'10010','Petty Cash','A','100', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno in ('10001', '10010');
SELECT account_heading_save(NULL, '11000', 'CUSTOMERS AND SETTLEMENT ACCOUNTS', NULL);
Modified: trunk/sql/coa/be/chart/General.sql
===================================================================
--- trunk/sql/coa/be/chart/General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/be/chart/General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -454,6 +454,6 @@
FROM account_link
WHERE description LIKE '%_tax');
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno = '55';
Modified: trunk/sql/coa/br/chart/General.sql
===================================================================
--- trunk/sql/coa/br/chart/General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/br/chart/General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -4,7 +4,7 @@
SELECT account_heading_save(NULL, '1000', 'RECURSOS ATUAIS', NULL);
SELECT account__save(NULL,'1060','Checando Cliente','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
SELECT account__save(NULL,'1065','Caixa Baixo','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno in ('1060', '1065');
SELECT account__save(NULL,'1200','Contas a Receber','A','', NULL, false, false, string_to_array('AR', ':'), false, false);
Modified: trunk/sql/coa/ca/chart/English_General.sql
===================================================================
--- trunk/sql/coa/ca/chart/English_General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/ca/chart/English_General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -4,7 +4,7 @@
SELECT account_heading_save(NULL, '1000', 'CURRENT ASSETS', NULL);
SELECT account__save(NULL,'1060','Chequing Account','A','1002', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
SELECT account__save(NULL,'1065','Petty Cash','A','1001', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno in ('1060', '1065');
SELECT account__save(NULL,'1200','Accounts Receivables','A','1060', NULL, false, false, string_to_array('AR', ':'), false, false);
Modified: trunk/sql/coa/ca/chart/French-Quebec_General.sql
===================================================================
--- trunk/sql/coa/ca/chart/French-Quebec_General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/ca/chart/French-Quebec_General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -12,7 +12,7 @@
SELECT account_heading_save(NULL, '1000', 'ACTIF COURANT', NULL);
SELECT account__save(NULL,'1060','Compte chÃque','A','1002', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
SELECT account__save(NULL,'1065','Petite caisse','A','1001', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno in ('1060', '1065');
SELECT account__save(NULL,'1200','Comptes clients','A','1060', NULL, false, false, string_to_array('AR', ':'), false, false);
Modified: trunk/sql/coa/ch/chart/German.sql
===================================================================
--- trunk/sql/coa/ch/chart/German.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/ch/chart/German.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -179,6 +179,6 @@
FROM account_link
WHERE description LIKE '%_tax');
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno = '11102';
Modified: trunk/sql/coa/cn/chart/General.sql
===================================================================
--- trunk/sql/coa/cn/chart/General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/cn/chart/General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -66,7 +66,7 @@
SELECT account__save(NULL,'4320','èè','I','', NULL, false, false, string_to_array('AR_amount:IC_income', ':'), false, false);
SELECT account__save(NULL,'1200','åæåæ','A','', NULL, false, false, string_to_array('AR', ':'), false, false);
SELECT account__save(NULL,'1061','æçæå','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno in ('1061', '1065');
SELECT account__save(NULL,'2310','ååæåç','L','', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'), false, false);
Modified: trunk/sql/coa/co/chart/PUC.sql
===================================================================
--- trunk/sql/coa/co/chart/PUC.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/co/chart/PUC.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -786,7 +786,7 @@
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE id IN (select account_id FROM account_link
WHERE description = 'AP_paid');
commit;
Modified: trunk/sql/coa/cz/chart/General.sql
===================================================================
--- trunk/sql/coa/cz/chart/General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/cz/chart/General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -314,7 +314,7 @@
INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10605, '70200', 'KoneÄnà ÃÄet rozvaÅnÃ', 'A', 'A', '', '', false);
INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10607, '71000', 'ÃÄet ziskÅ a ztrÃt', 'A', 'A', '', '', false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE id IN (select account_id FROM account_link
WHERE description = 'AP_paid');
--
Modified: trunk/sql/coa/de/chart/DATEV-SKR03.sql
===================================================================
--- trunk/sql/coa/de/chart/DATEV-SKR03.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/de/chart/DATEV-SKR03.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -247,6 +247,6 @@
FROM account_link
WHERE description LIKE '%_tax');
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno = '0120000';
Modified: trunk/sql/coa/de/chart/General.sql
===================================================================
--- trunk/sql/coa/de/chart/General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/de/chart/General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -235,6 +235,6 @@
FROM account_link
WHERE description LIKE '%_tax');
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno BETWEEN '1700' AND '1820';
Modified: trunk/sql/coa/de/chart/SKR03.sql
===================================================================
--- trunk/sql/coa/de/chart/SKR03.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/de/chart/SKR03.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -284,6 +284,6 @@
FROM account_link
WHERE description LIKE '%_tax');
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno = '1200';
Modified: trunk/sql/coa/dk/chart/General.sql
===================================================================
--- trunk/sql/coa/dk/chart/General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/dk/chart/General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -4,7 +4,7 @@
SELECT account_heading_save(NULL,'1000','KORTFRISTEDE AKTIVER', NULL);
SELECT account__save(NULL,'1061','Bank','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
SELECT account__save(NULL,'1065','Kasse','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno in ('1061', '1065');
SELECT account__save(NULL,'1200','Indbetalinger','A','', NULL, false, false, string_to_array('AR', ':'), false, false);
Modified: trunk/sql/coa/eg/chart/General.sql
===================================================================
--- trunk/sql/coa/eg/chart/General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/eg/chart/General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -16,7 +16,7 @@
SELECT account__save(NULL,'5650','Capital Cost Allowance Expense','E','', NULL, false, false, string_to_array('', ':'), false, false);
SELECT account__save(NULL,'1060','ÙÙØÙØ ØØÙØÙÙ','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
SELECT account__save(NULL,'1065','ÙÙØÙØØØÙØÙØÙÙ','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno in ('1060', '1065');
SELECT account__save(NULL,'1520','ÙØØÙÙ - ÙØØ ØÙØØ ÙÙØÙÙØØ','A','', NULL, false, false, string_to_array('IC', ':'), false, false);
Modified: trunk/sql/coa/fr/chart/General.sql
===================================================================
--- trunk/sql/coa/fr/chart/General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/fr/chart/General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -940,7 +940,7 @@
SELECT account__save(NULL,'999000','Foreign Exchange Gain','I','', NULL, false, false, string_to_array('', ':'), false, false);
SELECT account__save(NULL,'999010','Foreign Exchange Loss','E','', NULL, false, false, string_to_array('', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE id IN (select account_id FROM account_link
WHERE description = 'AP_paid');
--
Modified: trunk/sql/coa/hu/chart/Complete.sql
===================================================================
--- trunk/sql/coa/hu/chart/Complete.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/hu/chart/Complete.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -413,7 +413,7 @@
SELECT account__save(NULL,'4673','FizetendÅ ÃFA 0%','','L', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'), false, false);
SELECT account__save(NULL,'4674','FizetendÅ ÃFA adÃmentes','','L', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE id IN (select account_id FROM account_link
WHERE description = 'AP_paid');
Modified: trunk/sql/coa/hu/chart/Minimal.sql
===================================================================
--- trunk/sql/coa/hu/chart/Minimal.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/hu/chart/Minimal.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -37,7 +37,7 @@
SELECT account__save(NULL,'9111','KÃlfÃldi ÃrbevÃtel','I','911', NULL, false, false, string_to_array('AR_amount:IC_sale:IC_income', ':'), false, false);
SELECT account__save(NULL,'9700','ÃrfolyamnyeresÃg','I','970', NULL, false, false, string_to_array('', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE id IN (select account_id FROM account_link
WHERE description = 'AP_paid');
--
Modified: trunk/sql/coa/hu/chart/Old-general.sql
===================================================================
--- trunk/sql/coa/hu/chart/Old-general.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/hu/chart/Old-general.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -37,7 +37,7 @@
SELECT account__save(NULL,'9111','KÃlfÃldi ÃrbevÃtel','I','911', NULL, false, false, string_to_array('AR_amount:IC_sale:IC_income', ':'), false, false);
SELECT account__save(NULL,'9700','ÃrfolyamnyeresÃg','I','970', NULL, false, false, string_to_array('', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE id IN (select account_id FROM account_link
WHERE description = 'AP_paid');
--
Modified: trunk/sql/coa/id/chart/General.sql
===================================================================
--- trunk/sql/coa/id/chart/General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/id/chart/General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -4,7 +4,7 @@
SELECT account_heading_save(NULL,'1000','AKTIVA LANCAR', NULL);
SELECT account__save(NULL,'1060','Bank','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
SELECT account__save(NULL,'1065','Kas Kecil','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno in ('1060', '1065');
SELECT account__save(NULL,'1200','Piutang','A','', NULL, false, false, string_to_array('AR', ':'), false, false);
Modified: trunk/sql/coa/it/chart/General.sql
===================================================================
--- trunk/sql/coa/it/chart/General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/it/chart/General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -198,6 +198,6 @@
FROM account_link
WHERE description LIKE '%_tax');
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno = '4480105';
Modified: trunk/sql/coa/it/chart/cc2424.sql
===================================================================
--- trunk/sql/coa/it/chart/cc2424.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/it/chart/cc2424.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -277,8 +277,8 @@
FROM account_link
WHERE description LIKE '%_tax');
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno = '114001';
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno = '114003';
Modified: trunk/sql/coa/lv/chart/General.sql
===================================================================
--- trunk/sql/coa/lv/chart/General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/lv/chart/General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -247,7 +247,7 @@
SELECT account__save(NULL,'2354','PVN samaksÃts 18%','','E', NULL, false, false, string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'), false, false);
SELECT account__save(NULL,'2352','PVN ieÃemtais 18%','','L', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE id IN (select account_id FROM account_link
WHERE description = 'AP_paid');
--
Modified: trunk/sql/coa/nl/chart/General.sql
===================================================================
--- trunk/sql/coa/nl/chart/General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/nl/chart/General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -252,6 +252,6 @@
FROM account_link
WHERE description LIKE '%_tax');
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno BETWEEN '1100' AND '1180';
Modified: trunk/sql/coa/nl/chart/Simple.sql
===================================================================
--- trunk/sql/coa/nl/chart/Simple.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/nl/chart/Simple.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -99,5 +99,5 @@
FROM account_link
WHERE description LIKE '%_tax');
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno = '1061';
Modified: trunk/sql/coa/no/chart/General.sql
===================================================================
--- trunk/sql/coa/no/chart/General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/no/chart/General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -292,7 +292,7 @@
SELECT account__save(NULL,'8980','Avsatt til fri egenkapital','E','', NULL, false, false, string_to_array('', ':'), false, false);
SELECT account__save(NULL,'8990','Udekket tap','E','', NULL, false, false, string_to_array('', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE id IN (select account_id FROM account_link
WHERE description = 'AP_paid');
--
Modified: trunk/sql/coa/pl/chart/General.sql
===================================================================
--- trunk/sql/coa/pl/chart/General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/pl/chart/General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -325,7 +325,7 @@
SELECT account__save(NULL,'893010000','Podatek dochodowy','Q','', NULL, false, false, string_to_array('', ':'), false, false);
SELECT account__save(NULL,'893020000','Inne obowiÂzkowe obciÂÂenia wyniku finansowego','Q','', NULL, false, false, string_to_array('', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE id IN (select account_id FROM account_link
WHERE description = 'AP_paid');
--
Modified: trunk/sql/coa/se/chart/Agriculture.sql
===================================================================
--- trunk/sql/coa/se/chart/Agriculture.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/se/chart/Agriculture.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -228,7 +228,7 @@
SELECT account__save(NULL,'1940','Bank och Ãvr bankkon','A','200', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno in ('1900', '1910', '1920', '1930', '1940');
SELECT account__save(NULL,'1950','Bankcertifikat ','A','200', NULL, false, false, string_to_array('', ':'), false, false);
Modified: trunk/sql/coa/se/chart/Church_Society.sql
===================================================================
--- trunk/sql/coa/se/chart/Church_Society.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/se/chart/Church_Society.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -44,7 +44,7 @@
SELECT account__save(NULL,'1940','Ãvriga bankkonto','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
SELECT account__save(NULL,'1941','Nordea vÃrdepappersfond','A','', NULL, false, false, string_to_array('', ':'), false, false);
SELECT account__save(NULL,'1942','Nordea girokapitalkonto','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno in ('1910', '1920', '1930', '1940', '1941', '1942');
SELECT account_heading_save(NULL,'2','Eget kapital och skulder', NULL);
Modified: trunk/sql/coa/se/chart/General.sql
===================================================================
--- trunk/sql/coa/se/chart/General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/se/chart/General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -215,7 +215,7 @@
SELECT account__save(NULL,'1920','Postgiro ','A','200', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
SELECT account__save(NULL,'1930','CheckrÃkningskonto ','A','200', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
SELECT account__save(NULL,'1940','Bank och Ãvriga bankkonton ','A','200', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno in ('1910', '1920', '1930', '1940');
SELECT account__save(NULL,'1950','Bankcertifikat ','A','200', NULL, false, false, string_to_array('', ':'), false, false);
Modified: trunk/sql/coa/tw/chart/General.sql
===================================================================
--- trunk/sql/coa/tw/chart/General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/tw/chart/General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -66,7 +66,7 @@
SELECT account__save(NULL,'4320','èè','I','', NULL, false, false, string_to_array('AR_amount:IC_income', ':'), false, false);
SELECT account__save(NULL,'1200','ææåæ','A','', NULL, false, false, string_to_array('AR', ':'), false, false);
SELECT account__save(NULL,'1061','æçæé','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno in ('1061', '1065');
SELECT account__save(NULL,'2310','ååæåç','L','', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'), false, false);
Modified: trunk/sql/coa/uk/chart/General.sql
===================================================================
--- trunk/sql/coa/uk/chart/General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/uk/chart/General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -23,7 +23,7 @@
SELECT account__save(NULL,'1220','Building Society Account','A','', NULL, false, false, string_to_array('', ':'), false, false);
SELECT account__save(NULL,'1230','Petty Cash','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
SELECT account__save(NULL,'1240','Company Credit Card','L','', NULL, false, false, string_to_array('', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno in ('1200', '1210', '1220', '1230', '1240');
SELECT account__save(NULL,'2100','Creditors Control Account','L','', NULL, false, false, string_to_array('AP', ':'), false, false);
Modified: trunk/sql/coa/us/chart/General.sql
===================================================================
--- trunk/sql/coa/us/chart/General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/us/chart/General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -5,7 +5,7 @@
SELECT account_heading_save(NULL,'1000','CURRENT ASSETS', NULL);
SELECT account__save(NULL,'1060','Checking Account','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
SELECT account__save(NULL,'1065','Petty Cash','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno in ('1060', '1065');
SELECT account__save(NULL,'1200','Accounts Receivables','A','', NULL, false, false, string_to_array('AR', ':'), false, false);
Modified: trunk/sql/coa/us/chart/Manufacturing.sql
===================================================================
--- trunk/sql/coa/us/chart/Manufacturing.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/us/chart/Manufacturing.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -5,7 +5,7 @@
SELECT account_heading_save(NULL,'1000','CURRENT ASSETS', NULL);
SELECT account__save(NULL,'1060','Checking Account','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
SELECT account__save(NULL,'1065','Petty Cash','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno in ('1060', '1065');
SELECT account__save(NULL,'1200','Accounts Receivables','A','', NULL, false, false, string_to_array('AR', ':'), false, false);
Modified: trunk/sql/coa/us/chart/Service.sql
===================================================================
--- trunk/sql/coa/us/chart/Service.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/us/chart/Service.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -5,7 +5,7 @@
SELECT account_heading_save(NULL,'1000','CURRENT ASSETS', NULL);
SELECT account__save(NULL,'1060','Checking Account','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
SELECT account__save(NULL,'1065','Petty Cash','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno in ('1060', '1065');
SELECT account__save(NULL,'1200','Accounts Receivables','A','', NULL, false, false, string_to_array('AR', ':'), false, false);
Modified: trunk/sql/coa/us/chart/UCOA-Form990.sql
===================================================================
--- trunk/sql/coa/us/chart/UCOA-Form990.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/us/chart/UCOA-Form990.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -6,7 +6,7 @@
SELECT account__save(NULL,'1020','Cash in bank-payroll','A','45', NULL, false, false, string_to_array('AP_paid', ':'), false, false);
SELECT account__save(NULL,'1040','Petty cash','A','45', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
SELECT account__save(NULL,'1070','Savings & short-term investments','A','46', NULL, false, false, string_to_array('', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno in ('1010', '1020', '1040', '1070');
SELECT account_heading_save(NULL,'1100','Accounts receivable', NULL);
Modified: trunk/sql/coa/us/chart/UCOA-Form990EZ.sql
===================================================================
--- trunk/sql/coa/us/chart/UCOA-Form990EZ.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/us/chart/UCOA-Form990EZ.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -6,7 +6,7 @@
SELECT account__save(NULL,'1020','Cash in bank-payroll','A','22', NULL, false, false, string_to_array('AP_paid', ':'), false, false);
SELECT account__save(NULL,'1040','Petty cash','A','22', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
SELECT account__save(NULL,'1070','Savings & short-term investments','A','22', NULL, false, false, string_to_array('', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno in ('1010', '1020', '1040', '1070');
SELECT account_heading_save(NULL,'1100','Accounts receivable', NULL);
Modified: trunk/sql/coa/ve/chart/General.sql
===================================================================
--- trunk/sql/coa/ve/chart/General.sql 2012-06-18 14:20:36 UTC (rev 4917)
+++ trunk/sql/coa/ve/chart/General.sql 2012-06-19 02:13:51 UTC (rev 4918)
@@ -10,7 +10,7 @@
SELECT account__save(NULL,'1110','Provincial','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
SELECT account__save(NULL,'1120','Venezuela','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
SELECT account__save(NULL,'1130','Banesco JD','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'), false, false);
-SELECT cr_coa_to_account__save(accno, accno || '--' || description, false)
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
FROM account WHERE accno in ('1050', '1100', '1110', '1120', '1130');
SELECT account__save(NULL,'1200','Cuentas por Cobrar','A','', NULL, false, false, string_to_array('AR', ':'), false, false);
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.