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

[..hidden..]

Revision: 4434
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4434&view=rev
Author:   ehuelsmann
Date:     2012-03-10 11:15:58 +0000 (Sat, 10 Mar 2012)
Log Message:
-----------
More bank account recon setups added

Modified Paths:
--------------
    branches/1.3/sql/coa/at/chart/General.sql
    branches/1.3/sql/coa/be/chart/General.sql
    branches/1.3/sql/coa/ch/chart/German.sql
    branches/1.3/sql/coa/de/chart/DATEV-SKR03.sql
    branches/1.3/sql/coa/de/chart/General.sql
    branches/1.3/sql/coa/de/chart/SKR03.sql
    branches/1.3/sql/coa/it/chart/General.sql
    branches/1.3/sql/coa/it/chart/cc2424.sql
    branches/1.3/sql/coa/nl/chart/General.sql
    branches/1.3/sql/coa/nl/chart/Simple.sql

Modified: branches/1.3/sql/coa/at/chart/General.sql
===================================================================
--- branches/1.3/sql/coa/at/chart/General.sql	2012-03-10 11:13:05 UTC (rev 4433)
+++ branches/1.3/sql/coa/at/chart/General.sql	2012-03-10 11:15:58 UTC (rev 4434)
@@ -161,3 +161,6 @@
        FROM account_link
        WHERE description LIKE '%_tax');
 
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE accno = '2810';
+

Modified: branches/1.3/sql/coa/be/chart/General.sql
===================================================================
--- branches/1.3/sql/coa/be/chart/General.sql	2012-03-10 11:13:05 UTC (rev 4433)
+++ branches/1.3/sql/coa/be/chart/General.sql	2012-03-10 11:15:58 UTC (rev 4434)
@@ -454,3 +454,6 @@
        FROM account_link
        WHERE description LIKE '%_tax');
 
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE accno = '55';
+

Modified: branches/1.3/sql/coa/ch/chart/German.sql
===================================================================
--- branches/1.3/sql/coa/ch/chart/German.sql	2012-03-10 11:13:05 UTC (rev 4433)
+++ branches/1.3/sql/coa/ch/chart/German.sql	2012-03-10 11:15:58 UTC (rev 4434)
@@ -179,3 +179,6 @@
        FROM account_link
        WHERE description LIKE '%_tax');
 
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE accno = '11102';
+

Modified: branches/1.3/sql/coa/de/chart/DATEV-SKR03.sql
===================================================================
--- branches/1.3/sql/coa/de/chart/DATEV-SKR03.sql	2012-03-10 11:13:05 UTC (rev 4433)
+++ branches/1.3/sql/coa/de/chart/DATEV-SKR03.sql	2012-03-10 11:15:58 UTC (rev 4434)
@@ -247,3 +247,6 @@
        FROM account_link
        WHERE description LIKE '%_tax');
 
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE accno = '0120000';
+

Modified: branches/1.3/sql/coa/de/chart/General.sql
===================================================================
--- branches/1.3/sql/coa/de/chart/General.sql	2012-03-10 11:13:05 UTC (rev 4433)
+++ branches/1.3/sql/coa/de/chart/General.sql	2012-03-10 11:15:58 UTC (rev 4434)
@@ -235,3 +235,6 @@
        FROM account_link
        WHERE description LIKE '%_tax');
 
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE accno BETWEEN '1700' AND '1820';
+

Modified: branches/1.3/sql/coa/de/chart/SKR03.sql
===================================================================
--- branches/1.3/sql/coa/de/chart/SKR03.sql	2012-03-10 11:13:05 UTC (rev 4433)
+++ branches/1.3/sql/coa/de/chart/SKR03.sql	2012-03-10 11:15:58 UTC (rev 4434)
@@ -284,3 +284,6 @@
        FROM account_link
        WHERE description LIKE '%_tax');
 
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE accno = '1200';
+

Modified: branches/1.3/sql/coa/it/chart/General.sql
===================================================================
--- branches/1.3/sql/coa/it/chart/General.sql	2012-03-10 11:13:05 UTC (rev 4433)
+++ branches/1.3/sql/coa/it/chart/General.sql	2012-03-10 11:15:58 UTC (rev 4434)
@@ -198,3 +198,6 @@
        FROM account_link
        WHERE description LIKE '%_tax');
 
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE accno = '4480105';
+

Modified: branches/1.3/sql/coa/it/chart/cc2424.sql
===================================================================
--- branches/1.3/sql/coa/it/chart/cc2424.sql	2012-03-10 11:13:05 UTC (rev 4433)
+++ branches/1.3/sql/coa/it/chart/cc2424.sql	2012-03-10 11:15:58 UTC (rev 4434)
@@ -277,3 +277,8 @@
        FROM account_link
        WHERE description LIKE '%_tax');
 
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE accno = '114001';
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE accno = '114003';
+

Modified: branches/1.3/sql/coa/nl/chart/General.sql
===================================================================
--- branches/1.3/sql/coa/nl/chart/General.sql	2012-03-10 11:13:05 UTC (rev 4433)
+++ branches/1.3/sql/coa/nl/chart/General.sql	2012-03-10 11:15:58 UTC (rev 4434)
@@ -252,3 +252,6 @@
        FROM account_link
        WHERE description LIKE '%_tax');
 
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE accno BETWEEN '1100' AND '1180';
+

Modified: branches/1.3/sql/coa/nl/chart/Simple.sql
===================================================================
--- branches/1.3/sql/coa/nl/chart/Simple.sql	2012-03-10 11:13:05 UTC (rev 4433)
+++ branches/1.3/sql/coa/nl/chart/Simple.sql	2012-03-10 11:15:58 UTC (rev 4434)
@@ -99,3 +99,5 @@
        FROM account_link
        WHERE description LIKE '%_tax');
 
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE accno = '1061';

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