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

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



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

Log Message:
-----------
Egypt chart conversions

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

Modified: trunk/sql/coa/eg/chart/General.sql
===================================================================
--- trunk/sql/coa/eg/chart/General.sql	2009-06-12 02:03:48 UTC (rev 2646)
+++ trunk/sql/coa/eg/chart/General.sql	2009-06-12 02:07:38 UTC (rev 2647)
@@ -1,77 +1,77 @@
 begin;
 --
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2210','Workers Comp Payable','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2220','Vacation Pay Payable','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2250','Pension Plan Payable','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2260','Employment Insurance Payable','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5420','Employment Insurance Expense','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5430','Pension Plan Expense','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5440','Workers Comp Expense','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5470','Employee Benefits','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5650','Capital Cost Allowance Expense','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1060','ÙÙØÙØ ØØÙØÙÙ','A','A','AR_paid:AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1065','ÙÙØÙØØØÙØÙØÙÙ','A','A','AR_paid:AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1520','ÙØØÙÙ - ÙØØ ØÙØØ ÙÙØÙÙØØ','A','A','IC','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1530','ÙØØÙÙ - ØØØÙØ','A','A','IC','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1540','ÙØØÙÙ - ÙØØ ØØØÙ','A','A','IC','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1840','ØÙØØØØ','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1000','ØÙØØÙÙ ØÙÙØØØÙÙØ','H','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1500','ØÙÙØØÙÙ ÙØØÙ','H','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1800','ØÙØØÙÙ ØÙØØØØØ','H','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2000','ØÙØØØÙØØ ÙØÙØØ ØÙØØÙ','H','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2600','ØÙØØØÙØØ ØÙÙÙØ ØÙØØÙ','H','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1845','ÙØØØ ØÙÙØÙ ØÙØØØØ','A','A','','','1');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1820','ØØØØ ÙÙØØÙ Ù ÙØØØØ','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1825','ÙØØØ ØÙÙØÙ ØØØØ ÙÙØØÙ Ù ÙØØØØ','A','A','','','1');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2310','ØØÙØØ ÙØÙØØØ (10%)','A','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2320','ØØÙØØ ÙØÙØØØ (14%)','A','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2330','ØØÙØØ ÙØÙØØØ (30%)','A','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1200','ØÙÙØØ','A','A','AR','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1205','ÙØØØ ØÙÙÙ ÙØØÙÙØ','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2100','ÙÙØØÙÙ','A','L','AP','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2160','ØØÙØØ ØØÙØØ ÙØØØÙØ','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2190','ØØÙØØ ØØÙ ÙØØØÙØ','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2620','ÙØÙØ ÙÙ ØÙØÙÙÙ','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2680','ÙØÙØ ÙÙ ØÙÙØ ØÙØØÙÙ','A','L','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3300','ØÙÙÙ ØÙÙÙÙÙØ','H','Q','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4020','ÙØÙØØØ - ÙØØ ØÙØØ','A','I','AR_amount:IC_sale','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4030','ÙØÙØØØ ØØØÙØ','A','I','AR_amount:IC_sale','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4040','ÙØÙØØØ ØØØÙ','A','I','AR_amount:IC_sale','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4000','ØÙØØØ ØÙÙØÙØØØ','H','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4300','ØÙØØØ ØØØØØØØØ','H','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4320','ØØØØØØØØ','A','I','AR_amount:IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4330','ØØÙØØ','A','I','AR_amount:IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4400','ØÙØØØØØ ØØØÙ','H','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4430','ØØÙ Ù ØØØØØ','A','I','IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4440','ÙØØØØ','A','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4450','ØØØØØ ØØÙÙØ ØÙÙØ','A','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5000','ØÙÙÙØ ØÙØØØØØ ØÙÙØØØØ','H','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5010','ÙØØØÙØØ','A','E','AP_amount:IC_cogs:IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5020','ØÙÙÙØ ØÙØØØØØ ØÙÙØØØØ - ÙØØ ØÙØØ','A','E','AP_amount:IC_cogs','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5030','ØÙÙÙØ ØÙØØØØØ ØÙÙØØØØ - ØØØÙØ','A','E','AP_amount:IC_cogs','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5040','ØÙÙÙØ ØÙØØØØØ ØÙÙØØØØ - ØØØÙ','A','E','AP_amount:IC_cogs','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5100','ØØÙ','A','E','AP_amount:IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5400','ÙØØÙÙØØ ØÙØØÙØ','H','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5410','ØÙÙØØØØØ','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3350','ØÙØØÙÙ','A','Q','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5600','ÙØØÙÙØØ ØØØØÙØ Ù ØÙÙÙÙØ','H','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5610','ÙØÙÙÙÙØ Ù ÙØØØØÙØ','A','E','AP_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5615','ØØØÙØ Ù ØØÙØÙ','A','E','AP_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5765','ØØÙØØ Ù ØÙØÙØ','A','E','AP_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5680','ØØÙØØ ØØÙ','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5685','ØØÙÙÙ','A','E','AP_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5620','ØÙÙÙ ÙØØÙÙØ ','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5660','ÙØØØÙÙ ØÙÙØÙ','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5690','ÙÙØØØ Ù ÙØØØÙÙ ØÙÙÙØ','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5700','ÙÙÙØØ ÙÙØØÙØ','A','E','AP_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5780','ØÙÙÙÙ','A','E','AP_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5760','ØÙØØØ','A','E','AP_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5785','ÙØØØÙÙ ØÙØ','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5795','ØØÙÙ','A','E','AP_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5800','ØØØ','A','E','AP_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5810','ØØØØØ ØØÙÙÙ ØÙÙØ','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5790','ÙØØÙÙ','A','E','AP_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2280','ØØØØØ ÙØØØØØ ÙØØØÙØ','A','L','','');
+SELECT account_heading_save(NULL, '1000', 'ØÙØØÙÙ ØÙÙØØØÙÙØ', NULL);
+SELECT account_heading_save(NULL, '1500', 'ØÙÙØØÙÙ ÙØØÙ', NULL);
+SELECT account_heading_save(NULL, '1800', 'ØÙØØÙÙ ØÙØØØØØ', NULL);
+SELECT account_heading_save(NULL, '2000', 'ØÙØØØÙØØ ÙØÙØØ ØÙØØÙ', NULL);
+SELECT account_heading_save(NULL, '2600', 'ØÙØØØÙØØ ØÙÙÙØ ØÙØØÙ', NULL);
+SELECT account_save(NULL,'2210','Workers Comp Payable','','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2220','Vacation Pay Payable','','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2250','Pension Plan Payable','','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2260','Employment Insurance Payable','','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5420','Employment Insurance Expense','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5430','Pension Plan Expense','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5440','Workers Comp Expense','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5470','Employee Benefits','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5650','Capital Cost Allowance Expense','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1060','ÙÙØÙØ ØØÙØÙÙ','','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1065','ÙÙØÙØØØÙØÙØÙÙ','','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1520','ÙØØÙÙ - ÙØØ ØÙØØ ÙÙØÙÙØØ','','A', NULL, false,string_to_array('IC', ':'));
+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,'1840','ØÙØØØØ','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL, '1845','ÙØØØ ØÙÙØÙ ØÙØØØØ','A','',NULL,'1', '{}');
+SELECT account_save(NULL,'1820','ØØØØ ÙÙØØÙ Ù ÙØØØØ','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save('1825','ÙØØØ ØÙÙØÙ ØØØØ ÙÙØØÙ Ù ÙØØØØ','','A',NULL,'1','{}');
+SELECT account_save(NULL,'2310','ØØÙØØ ÙØÙØØØ (10%)','','L', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'2320','ØØÙØØ ÙØÙØØØ (14%)','','L', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'2330','ØØÙØØ ÙØÙØØØ (30%)','','L', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'1200','ØÙÙØØ','','A', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'1205','ÙØØØ ØÙÙÙ ÙØØÙÙØ','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2100','ÙÙØØÙÙ','','L', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'2160','ØØÙØØ ØØÙØØ ÙØØØÙØ','','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2190','ØØÙØØ ØØÙ ÙØØØÙØ','','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2620','ÙØÙØ ÙÙ ØÙØÙÙÙ','','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2680','ÙØÙØ ÙÙ ØÙÙØ ØÙØØÙÙ','','L', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_heading_save(NULL, '3300', 'ØÙÙÙ ØÙÙÙÙÙØ', NULL);
+SELECT account_save(NULL,'4020','ÙØÙØØØ - ÙØØ ØÙØØ','','I', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_save(NULL,'4030','ÙØÙØØØ ØØØÙØ','','I', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_save(NULL,'4040','ÙØÙØØØ ØØØÙ','','I', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_heading_save(NULL, '4000', 'ØÙØØØ ØÙÙØÙØØØ', NULL);
+SELECT account_heading_save(NULL, '4300', 'ØÙØØØ ØØØØØØØØ', NULL);
+SELECT account_save(NULL,'4320','ØØØØØØØØ','','I', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'4330','ØØÙØØ','','I', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_heading_save(NULL, '4400', 'ØÙØØØØØ ØØØÙ', NULL);
+SELECT account_save(NULL,'4430','ØØÙ Ù ØØØØØ','','I', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'4440','ÙØØØØ','','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4450','ØØØØØ ØØÙÙØ ØÙÙØ','','I', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '5000', 'ØÙÙÙØ ØÙØØØØØ ØÙÙØØØØ', NULL);
+SELECT account_save(NULL,'5010','ÙØØØÙØØ','','E', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'5020','ØÙÙÙØ ØÙØØØØØ ØÙÙØØØØ - ÙØØ ØÙØØ','','E', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_save(NULL,'5030','ØÙÙÙØ ØÙØØØØØ ØÙÙØØØØ - ØØØÙØ','','E', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_save(NULL,'5040','ØÙÙÙØ ØÙØØØØØ ØÙÙØØØØ - ØØØÙ','','E', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_save(NULL,'5100','ØØÙ','','E', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_heading_save(NULL, '5400', 'ÙØØÙÙØØ ØÙØØÙØ', NULL);
+SELECT account_save(NULL,'5410','ØÙÙØØØØØ','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3350','ØÙØØÙÙ','','Q', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '5600', 'ÙØØÙÙØØ ØØØØÙØ Ù ØÙÙÙÙØ', NULL);
+SELECT account_save(NULL,'5610','ÙØÙÙÙÙØ Ù ÙØØØØÙØ','','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5615','ØØØÙØ Ù ØØÙØÙ','','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5765','ØØÙØØ Ù ØÙØÙØ','','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5680','ØØÙØØ ØØÙ','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5685','ØØÙÙÙ','','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5620','ØÙÙÙ ÙØØÙÙØ ','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5660','ÙØØØÙÙ ØÙÙØÙ','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5690','ÙÙØØØ Ù ÙØØØÙÙ ØÙÙÙØ','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5700','ÙÙÙØØ ÙÙØØÙØ','','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,'5760','ØÙØØØ','','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5785','ÙØØØÙÙ ØÙØ','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5795','ØØÙÙ','','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,'5810','ØØØØØ ØØÙÙÙ ØÙÙØ','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5790','ÙØØÙÙ','','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'2280','ØØØØØ ÙØØØØØ ÙØØØÙØ','','L', NULL, false,string_to_array('', ':'));
 
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '1520'));
 


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