SF.net SVN: ledger-smb:[4476] trunk/sql/coa

[..hidden..]

Revision: 4476
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4476&view=rev
Author:   einhverfr
Date:     2012-03-15 10:49:17 +0000 (Thu, 15 Mar 2012)
Log Message:
-----------
Final batch of COA entries to get recon data

Modified Paths:
--------------
    trunk/sql/coa/cz/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/lv/chart/General.sql
    trunk/sql/coa/pl/chart/General.sql

Modified: trunk/sql/coa/cz/chart/General.sql
===================================================================
--- trunk/sql/coa/cz/chart/General.sql	2012-03-15 10:19:22 UTC (rev 4475)
+++ trunk/sql/coa/cz/chart/General.sql	2012-03-15 10:49:17 UTC (rev 4476)
@@ -313,6 +313,10 @@
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10603, '70100', 'PoÄÃteÄnà ÃÄet rozvaÅnÃ', 'A', 'A', '', '', false);
 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)
+FROM account WHERE id IN (select account_id FROM account_link
+                           WHERE description = 'AP_paid');
 --
 insert into tax (chart_id,rate) values ((select id from chart where accno = '34311'),0.05);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '34312'),0.19);

Modified: trunk/sql/coa/fr/chart/General.sql
===================================================================
--- trunk/sql/coa/fr/chart/General.sql	2012-03-15 10:19:22 UTC (rev 4475)
+++ trunk/sql/coa/fr/chart/General.sql	2012-03-15 10:49:17 UTC (rev 4476)
@@ -939,6 +939,10 @@
 --
 SELECT account_save(NULL,'999000','Foreign Exchange Gain','I','', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'999010','Foreign Exchange Loss','E','', NULL, false, false, string_to_array('', ':'));
+
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE id IN (select account_id FROM account_link
+                           WHERE description = 'AP_paid');
 --
 -- insert taxes
 --

Modified: trunk/sql/coa/hu/chart/Complete.sql
===================================================================
--- trunk/sql/coa/hu/chart/Complete.sql	2012-03-15 10:19:22 UTC (rev 4475)
+++ trunk/sql/coa/hu/chart/Complete.sql	2012-03-15 10:49:17 UTC (rev 4476)
@@ -413,6 +413,10 @@
 SELECT account_save(NULL,'4673','FizetendÅ ÃFA 0%','','L', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
 SELECT account_save(NULL,'4674','FizetendÅ ÃFA adÃmentes','','L', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
 
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE id IN (select account_id FROM account_link
+                           WHERE description = 'AP_paid');
+
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4661'),'0.20','VIS');
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4662'),'0.05','VIS');
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4663'),'0','VIS');

Modified: trunk/sql/coa/hu/chart/Minimal.sql
===================================================================
--- trunk/sql/coa/hu/chart/Minimal.sql	2012-03-15 10:19:22 UTC (rev 4475)
+++ trunk/sql/coa/hu/chart/Minimal.sql	2012-03-15 10:49:17 UTC (rev 4476)
@@ -36,6 +36,10 @@
 SELECT account_save(NULL,'9110','BelfÃldi ÃrbevÃtel','I','911', NULL, false, false, string_to_array('AR_amount:IC_sale:IC_income', ':'));
 SELECT account_save(NULL,'9111','KÃlfÃldi ÃrbevÃtel','I','911', NULL, false, false, string_to_array('AR_amount:IC_sale:IC_income', ':'));
 SELECT account_save(NULL,'9700','ÃrfolyamnyeresÃg','I','970', NULL, false, false, string_to_array('', ':'));
+
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE id IN (select account_id FROM account_link
+                           WHERE description = 'AP_paid');
 --
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4660'),'0.20','');
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4661'),'0.15','');

Modified: trunk/sql/coa/hu/chart/Old-general.sql
===================================================================
--- trunk/sql/coa/hu/chart/Old-general.sql	2012-03-15 10:19:22 UTC (rev 4475)
+++ trunk/sql/coa/hu/chart/Old-general.sql	2012-03-15 10:49:17 UTC (rev 4476)
@@ -36,6 +36,10 @@
 SELECT account_save(NULL,'9110','BelfÃldi ÃrbevÃtel','I','911', NULL, false, false, string_to_array('AR_amount:IC_sale:IC_income', ':'));
 SELECT account_save(NULL,'9111','KÃlfÃldi ÃrbevÃtel','I','911', NULL, false, false, string_to_array('AR_amount:IC_sale:IC_income', ':'));
 SELECT account_save(NULL,'9700','ÃrfolyamnyeresÃg','I','970', NULL, false, false, string_to_array('', ':'));
+
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE id IN (select account_id FROM account_link
+                           WHERE description = 'AP_paid');
 --
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4660'),'0.25','');
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4661'),'0.15','');

Modified: trunk/sql/coa/lv/chart/General.sql
===================================================================
--- trunk/sql/coa/lv/chart/General.sql	2012-03-15 10:19:22 UTC (rev 4475)
+++ trunk/sql/coa/lv/chart/General.sql	2012-03-15 10:49:17 UTC (rev 4476)
@@ -246,6 +246,10 @@
 SELECT account_save(NULL,'1330','LÃdzdalÃbas saistÃto uzÃÃmumu kapitÃlÃ','','A', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'2354','PVN samaksÃts 18%','','E', NULL, false, false, string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
 SELECT account_save(NULL,'2352','PVN ieÃemtais 18%','','L', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE id IN (select account_id FROM account_link
+                           WHERE description = 'AP_paid');
 --
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart where accno = '2352'),'0.18','');
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart where accno = '2354'),'0.18','');

Modified: trunk/sql/coa/pl/chart/General.sql
===================================================================
--- trunk/sql/coa/pl/chart/General.sql	2012-03-15 10:19:22 UTC (rev 4475)
+++ trunk/sql/coa/pl/chart/General.sql	2012-03-15 10:49:17 UTC (rev 4476)
@@ -324,6 +324,10 @@
 SELECT account_save(NULL,'893000000','Odpisy z zysku netto w ciÂgu roku obrotowego','Q','', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'893010000','Podatek dochodowy','Q','', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'893020000','Inne obowiÂzkowe obciÂÂenia wyniku finansowego','Q','', NULL, false, false, string_to_array('', ':'));
+
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE id IN (select account_id FROM account_link
+                           WHERE description = 'AP_paid');
 --
 insert into tax (chart_id,rate) values ((select id from chart where accno = '223020100'),0.22);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '223020200'),0.07);

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