[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

SF.net SVN: ledger-smb:[4433] branches/1.3/sql/coa/se/chart



Revision: 4433
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4433&view=rev
Author:   einhverfr
Date:     2012-03-10 11:13:05 +0000 (Sat, 10 Mar 2012)
Log Message:
-----------
Reconciliation for .se accounts and cleaning up the General.sql a bit

Modified Paths:
--------------
    branches/1.3/sql/coa/se/chart/Agriculture.sql
    branches/1.3/sql/coa/se/chart/Church_Society.sql
    branches/1.3/sql/coa/se/chart/General.sql

Modified: branches/1.3/sql/coa/se/chart/Agriculture.sql
===================================================================
--- branches/1.3/sql/coa/se/chart/Agriculture.sql	2012-03-10 10:53:52 UTC (rev 4432)
+++ branches/1.3/sql/coa/se/chart/Agriculture.sql	2012-03-10 11:13:05 UTC (rev 4433)
@@ -226,6 +226,11 @@
 SELECT account_save(NULL,'1920','Plusgiro ','A','200', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'1930','CheckrÃkningskonto','A','200', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'1940','Bank och Ãvr bankkon','A','200', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+
+
+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('', ':'));
 SELECT account_save(NULL,'1960','Koncernkont moderbol','A','200', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1970','SÃrskilda bankkonton','A','200', NULL, false, false, string_to_array('', ':'));

Modified: branches/1.3/sql/coa/se/chart/Church_Society.sql
===================================================================
--- branches/1.3/sql/coa/se/chart/Church_Society.sql	2012-03-10 10:53:52 UTC (rev 4432)
+++ branches/1.3/sql/coa/se/chart/Church_Society.sql	2012-03-10 11:13:05 UTC (rev 4433)
@@ -44,6 +44,9 @@
 SELECT account_save(NULL,'1940','Ãvriga bankkonto','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'1941','Nordea vÃrdepappersfond','A','', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1942','Nordea girokapitalkonto','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 ('1910', '1920', '1930', '1940', '1941', '1942');
+
 SELECT account_heading_save(NULL,'2','Eget kapital och skulder', NULL);
 SELECT account_heading_save(NULL,'20','Eget kapital', NULL);
 SELECT account_save(NULL,'2000','Eget kapital EFS Ãsele','Q','', NULL, false, false, string_to_array('', ':'));

Modified: branches/1.3/sql/coa/se/chart/General.sql
===================================================================
--- branches/1.3/sql/coa/se/chart/General.sql	2012-03-10 10:53:52 UTC (rev 4432)
+++ branches/1.3/sql/coa/se/chart/General.sql	2012-03-10 11:13:05 UTC (rev 4433)
@@ -212,17 +212,12 @@
 SELECT account_save(NULL,'1900','Obsevationskonto ','A','200', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1910','Kassa ','A','200', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'1911','Huvudkassa ','A','200', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'1912','Kassa 2 ','A','200', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'1913','Kassa 3 ','A','200', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1920','Postgiro ','A','200', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'1921','Postgiro 1 ','A','200', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'1922','Postgiro 2 ','A','200', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1930','CheckrÃkningskonto ','A','200', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'1931','CheckrÃkningskonto 1 ','A','200', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'1932','CheckrÃkningskonto 2 ','A','200', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1940','Bank och Ãvriga bankkonton ','A','200', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'1941','Bankkonto 1 ','A','200', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'1942','Bankkonto 2 ','A','200', NULL, false, false, string_to_array('', ':'));
+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('', ':'));
 SELECT account_save(NULL,'1960','Koncernkonto moderbolag ','A','200', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1970','SÃrskilda bankkonton ','A','200', NULL, false, false, string_to_array('', ':'));
@@ -311,12 +306,6 @@
 SELECT account_save(NULL,'2310','Obligations- och fÃrlagslÃn ','L','329', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'2320','Konvertibla lÃn ','L','329', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'2330','CheckrÃkningskredit ','L','329', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'2331','CheckrÃkningskredit 1 ','L','329', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'2332','CheckrÃkningskredit 2 ','L','329', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'2333','Utnyttjad checkrÃkningskredit 1 ','L','329', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'2334','Utnyttjad checkrÃkningskredit 2 ','L','329', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'2335','Beviljad checkrÃkningskredit 1 ','L','329', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'2336','Beviljad checkrÃkningskredit 2 ','L','329', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'2340','Byggnadskreditiv ','L','329', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'2350','Andra skulder till kreditinstitut ','L','329', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'2351','FastighetslÃn ','L','329', NULL, false, false, string_to_array('', ':'));
@@ -440,7 +429,6 @@
 SELECT account_save(NULL,'2911','LÃneskulder ','L','305', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'2912','AckordsÃverskott ','L','305', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'2920','Upplupna semesterlÃner ','L','305', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'2921','Upplupna semesterlÃner ','L','305', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'2928','Betalda semesterlÃner ','L','305', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'2930','Upplupna pensionskostnader ','L','305', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'2931','Upplupna pensionsutbetalningar ','L','305', NULL, false, false, string_to_array('', ':'));

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