SF.net SVN: ledger-smb:[2643] trunk/sql/coa/cn/chart/General.sql

[..hidden..]

Revision: 2643
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2643&view=rev
Author:   einhverfr
Date:     2009-06-12 01:38:06 +0000 (Fri, 12 Jun 2009)

Log Message:
-----------
More chart conversions

Modified Paths:
--------------
    trunk/sql/coa/cn/chart/General.sql

Modified: trunk/sql/coa/cn/chart/General.sql
===================================================================
--- trunk/sql/coa/cn/chart/General.sql	2009-06-12 01:35:37 UTC (rev 2642)
+++ trunk/sql/coa/cn/chart/General.sql	2009-06-12 01:38:06 UTC (rev 2643)
@@ -1,76 +1,76 @@
 begin;
 -- Default chart of accounts -- sample only
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2190','åäæåç','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2600','éæèå','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3300','èäèæ','H','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3500','äççé','H','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4000','éåçé','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4300','èèçé','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4400','ååçé','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5000','èéææ','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5400','èèæå','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5600','æååççæå','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1205','åååæ','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1000','æåèä','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1800','èæèä','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('1825','çèåæäæ - èçåèå.','A','','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('1845','çèåæäæ - èèåå','A','','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2000','æåèå','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2620','éèåæ','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3600','æåçé','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2160','åäååç','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3590','äççé - ååå','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3350','æéèä','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1500','åèèä','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5615','ååèé','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5790','åå','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5700','ååçå','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5800','æåé','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5610','äèæå','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5685','äé','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5660','åææå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5620','åå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5680','æåç','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5690','åæåéèæçè','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5410','èè','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5420','äéæå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5430','éäéæå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5440','èåéæå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5470','ååçå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4030','éå / èä','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4440','åæ','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5100','èè','A','','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5760','çé','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1530','åå / èä','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1540','åå / äçååéä','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4040','éå / äçååéä','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5030','èéææ / èä','A','','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5010','éè','A','','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5040','èéææ / äçååéä','A','','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1065','éçé','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1820','åååèçåèå','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5785','æèååä','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2680','èäèæ','A','','L','AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5795','æåè','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5780','çäè','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5781','çèèçè','A','','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5765','çäççè','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2311','åæç','A','','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4430','èéè','A','','I','IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1520','åå / çä','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5020','èéææ / çä','A','','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2100','åäåæ','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1840','èèåå','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4330','çåèè','A','','I','AR_amount:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4020','éå / çä','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4320','èè','A','','I','AR_amount:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1200','åæåæ','A','','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1061','æçæå','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2310','ååæåç','A','','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
+SELECT account_save(NULL,'2190','åäæåç','L','', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '2600', 'éæèå', NULL);
+SELECT account_heading_save(NULL, '3300', 'èäèæ', NULL);
+SELECT account_heading_save(NULL, '3500', 'äççé', NULL);
+SELECT account_heading_save(NULL, '4000', 'éåçé', NULL);
+SELECT account_heading_save(NULL, '4300', 'èèçé', NULL);
+SELECT account_heading_save(NULL, '4400', 'ååçé', NULL);
+SELECT account_heading_save(NULL, '5000', 'èéææ', NULL);
+SELECT account_heading_save(NULL, '5400', 'èèæå', NULL);
+SELECT account_heading_save(NULL, '5600', 'æååççæå', NULL);
+SELECT account_save(NULL,'1205','åååæ','A','', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '1000', 'æåèä', NULL);
+SELECT account_heading_save(NULL, '1800', 'èæèä', NULL);
+SELECT account_save(NULL,'1825','çèåæäæ - èçåèå.','A','', NULL, true,string_to_array('','1', ':'));
+SELECT account_save(NULL,'1845','çèåæäæ - èèåå','A','', NULL, true,string_to_array('','1', ':'));
+SELECT account_heading_save(NULL, '2000', 'æåèå', NULL);
+SELECT account_save(NULL,'2620','éèåæ','L','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3600','æåçé','Q','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2160','åäååç','L','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3590','äççé - ååå','Q','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3350','æéèä','Q','', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '1500', 'åèèä', NULL);
+SELECT account_save(NULL,'5615','ååèé','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5790','åå','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5700','ååçå','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5800','æåé','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5610','äèæå','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5685','äé','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5660','åææå','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5620','åå','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5680','æåç','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5690','åæåéèæçè','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5410','èè','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5420','äéæå','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5430','éäéæå','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5440','èåéæå','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5470','ååçå','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4030','éå / èä','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_save(NULL,'4440','åæ','I','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5100','èè','E','', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'5760','çé','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'1530','åå / èä','A','', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1540','åå / äçååéä','A','', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'4040','éå / äçååéä','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_save(NULL,'5030','èéææ / èä','E','', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_save(NULL,'5010','éè','E','', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'5040','èéææ / äçååéä','E','', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_save(NULL,'1065','éçé','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1820','åååèçåèå','A','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5785','æèååä','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2680','èäèæ','L','', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'5795','æåè','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5780','çäè','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5781','çèèçè','E','', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'5765','çäççè','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'2311','åæç','L','', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'4430','èéè','I','', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'1520','åå / çä','A','', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'5020','èéææ / çä','E','', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_save(NULL,'2100','åäåæ','L','', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'1840','èèåå','A','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'4330','çåèè','I','', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'4020','éå / çä','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_save(NULL,'4320','èè','I','', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'1200','åæåæ','A','', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'1061','æçæå','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'2310','ååæåç','L','', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
 --
 -- exchange rate
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4450','Foreign Exchange Gain','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5810','Foreign Exchange Loss','A','','E','');
+SELECT account_save(NULL,'4450','Foreign Exchange Gain','I','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5810','Foreign Exchange Loss','E','', NULL, false,string_to_array('', ':'));
 --
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.07);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2311'),0.08);


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