SF.net SVN: ledger-smb:[4431] branches/1.3/sql/coa

[..hidden..]

Revision: 4431
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4431&view=rev
Author:   einhverfr
Date:     2012-03-10 10:46:46 +0000 (Sat, 10 Mar 2012)
Log Message:
-----------
Updating some charts of accounts to ensure reconciliation is set

Modified Paths:
--------------
    branches/1.3/sql/coa/au/chart/General-0000.sql
    branches/1.3/sql/coa/au/chart/General-00000.sql
    branches/1.3/sql/coa/br/chart/General.sql
    branches/1.3/sql/coa/ca/chart/English_General.sql
    branches/1.3/sql/coa/ca/chart/French-Quebec_General.sql
    branches/1.3/sql/coa/cn/chart/General.sql
    branches/1.3/sql/coa/dk/chart/General.sql
    branches/1.3/sql/coa/eg/chart/General.sql
    branches/1.3/sql/coa/id/chart/General.sql

Modified: branches/1.3/sql/coa/au/chart/General-0000.sql
===================================================================
--- branches/1.3/sql/coa/au/chart/General-0000.sql	2012-03-10 09:56:19 UTC (rev 4430)
+++ branches/1.3/sql/coa/au/chart/General-0000.sql	2012-03-10 10:46:46 UTC (rev 4431)
@@ -18,6 +18,10 @@
 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 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', ':'));

Modified: branches/1.3/sql/coa/au/chart/General-00000.sql
===================================================================
--- branches/1.3/sql/coa/au/chart/General-00000.sql	2012-03-10 09:56:19 UTC (rev 4430)
+++ branches/1.3/sql/coa/au/chart/General-00000.sql	2012-03-10 10:46:46 UTC (rev 4431)
@@ -5,6 +5,9 @@
 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', ':'));
 SELECT account_save(NULL,'10010','Petty Cash','A','100', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+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);
 SELECT account_save(NULL,'11001','Accounts Receivables','A','110', NULL, false, false, string_to_array('AR', ':'));
 SELECT account_heading_save(NULL, '12000', 'OTHER CURRENT ASSETS', NULL);

Modified: branches/1.3/sql/coa/br/chart/General.sql
===================================================================
--- branches/1.3/sql/coa/br/chart/General.sql	2012-03-10 09:56:19 UTC (rev 4430)
+++ branches/1.3/sql/coa/br/chart/General.sql	2012-03-10 10:46:46 UTC (rev 4431)
@@ -4,6 +4,9 @@
 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', ':'));
 SELECT account_save(NULL,'1065','Caixa Baixo','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+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', ':'));
 SELECT account_save(NULL,'1205','ProvisÃo para devedors duvidosos','A','', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '1500', 'INVENTÃRIO DE CLIENTES', NULL);

Modified: branches/1.3/sql/coa/ca/chart/English_General.sql
===================================================================
--- branches/1.3/sql/coa/ca/chart/English_General.sql	2012-03-10 09:56:19 UTC (rev 4430)
+++ branches/1.3/sql/coa/ca/chart/English_General.sql	2012-03-10 10:46:46 UTC (rev 4431)
@@ -4,6 +4,9 @@
 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', ':'));
 SELECT account_save(NULL,'1065','Petty Cash','A','1001', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+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', ':'));
 SELECT account_save(NULL,'1205','Allowance for doubtful accounts','A','1063', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '1500', 'INVENTORY ASSETS', NULL);

Modified: branches/1.3/sql/coa/ca/chart/French-Quebec_General.sql
===================================================================
--- branches/1.3/sql/coa/ca/chart/French-Quebec_General.sql	2012-03-10 09:56:19 UTC (rev 4430)
+++ branches/1.3/sql/coa/ca/chart/French-Quebec_General.sql	2012-03-10 10:46:46 UTC (rev 4431)
@@ -12,6 +12,9 @@
 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', ':'));
 SELECT account_save(NULL,'1065','Petite caisse','A','1001', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+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', ':'));
 SELECT account_save(NULL,'1205','Provisions pour crÃances douteuses','A','1063', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '1500', 'INVENTAIRE', NULL);

Modified: branches/1.3/sql/coa/cn/chart/General.sql
===================================================================
--- branches/1.3/sql/coa/cn/chart/General.sql	2012-03-10 09:56:19 UTC (rev 4430)
+++ branches/1.3/sql/coa/cn/chart/General.sql	2012-03-10 10:46:46 UTC (rev 4431)
@@ -66,6 +66,9 @@
 SELECT account_save(NULL,'4320','èè','I','', NULL, false, false, string_to_array('AR_amount:IC_income', ':'));
 SELECT account_save(NULL,'1200','åæåæ','A','', NULL, false, false, string_to_array('AR', ':'));
 SELECT account_save(NULL,'1061','æçæå','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+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', ':'));
 --
 -- exchange rate

Modified: branches/1.3/sql/coa/dk/chart/General.sql
===================================================================
--- branches/1.3/sql/coa/dk/chart/General.sql	2012-03-10 09:56:19 UTC (rev 4430)
+++ branches/1.3/sql/coa/dk/chart/General.sql	2012-03-10 10:46:46 UTC (rev 4431)
@@ -4,6 +4,9 @@
 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', ':'));
 SELECT account_save(NULL,'1065','Kasse','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+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', ':'));
 SELECT account_save(NULL,'1205','HensÃttelser til formodet gÃld','A','', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1210','Moms indgÃende','A','', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));

Modified: branches/1.3/sql/coa/eg/chart/General.sql
===================================================================
--- branches/1.3/sql/coa/eg/chart/General.sql	2012-03-10 09:56:19 UTC (rev 4430)
+++ branches/1.3/sql/coa/eg/chart/General.sql	2012-03-10 10:46:46 UTC (rev 4431)
@@ -16,6 +16,9 @@
 SELECT account_save(NULL,'5650','Capital Cost Allowance Expense','E','', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1060','ÙÙØÙØ ØØÙØÙÙ','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'1065','ÙÙØÙØØØÙØÙØÙÙ','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+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', ':'));
 SELECT account_save(NULL,'1530','ÙØØÙÙ - ØØØÙØ','A','', NULL, false, false, string_to_array('IC', ':'));
 SELECT account_save(NULL,'1540','ÙØØÙÙ - ÙØØ ØØØÙ','A','', NULL, false, false, string_to_array('IC', ':'));

Modified: branches/1.3/sql/coa/id/chart/General.sql
===================================================================
--- branches/1.3/sql/coa/id/chart/General.sql	2012-03-10 09:56:19 UTC (rev 4430)
+++ branches/1.3/sql/coa/id/chart/General.sql	2012-03-10 10:46:46 UTC (rev 4431)
@@ -4,6 +4,9 @@
 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', ':'));
 SELECT account_save(NULL,'1065','Kas Kecil','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+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', ':'));
 SELECT account_heading_save(NULL,'1500','INVENTORY', NULL);
 SELECT account_save(NULL,'1520','Inventory / Umum','A','', NULL, false, false, string_to_array('IC', ':'));

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.