[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb: [2022] trunk/sql/coa/hu/chart

Subject: SF.net SVN: ledger-smb: [2022] trunk/sql/coa/hu/chart
From: ..hidden..
Date: Sat, 29 Dec 2007 20:51:33 -0800
Revision: 2022
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2022&view=rev
Author:   einhverfr
Date:     2007-12-29 20:51:32 -0800 (Sat, 29 Dec 2007)

Log Message:
-----------
Moving Isvan's basic Hungarian chart to Minimal

Added Paths:
-----------
    trunk/sql/coa/hu/chart/Minimal.sql

Removed Paths:
-------------
    trunk/sql/coa/hu/chart/Default.sql

Deleted: trunk/sql/coa/hu/chart/Default.sql
===================================================================
--- trunk/sql/coa/hu/chart/Default.sql	2007-12-30 04:51:02 UTC (rev 2021)
+++ trunk/sql/coa/hu/chart/Default.sql	2007-12-30 04:51:32 UTC (rev 2022)
@@ -1,70 +0,0 @@
-begin;
---Hungarian chart of accounts 
--- Magyar fÃkÃnyvi szÃmlÃk, amelyek csak pÃldakÃnt szolgÃlnak
---
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1140','Irodai eszkÃzÃk','A','A','','114');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1199','Irodai eszkÃzÃk ÃCS','A','A','','119');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2610','Ãruk ','A','A','IC','261');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3110','VevÃk','A','A','AR','311');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3111','KÃlfÃldi vevÃk','A','A','AR','311');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3810','PÃnztÃr 1','A','A','AR_paid:AP_paid','381');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3811','PÃnztÃr 2','A','A','AR_paid:AP_paid','381');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3840','Bank 1','A','A','AR_paid:AP_paid','384');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3841','Bank 2','A','A','AR_paid:AP_paid','384');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4540','BelfÃldi SzÃllÃtÃk','A','L','AP','454');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4541','KÃlfÃldi szÃllÃtÃk','A','L','AP','454');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4660','VisszaigÃnyelhetÃ ÃFA 20%','A','L','AP_tax:IC_taxpart:IC_taxservice','466');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4661','VisszaigÃnyelhetÃ ÃFA 12%','A','L','AP_tax:IC_taxpart:IC_taxservice','466');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4662','VisszaigÃnyelhetÃ ÃFA 5%','A','L','AP_tax:IC_taxpart:IC_taxservice','466');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4663','VisszaigÃnyelhetÃ ÃFA adÃmentes','A','L','AP_tax:IC_taxpart:IC_taxservice','466');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4670','FizetendÃ ÃFA 20%','A','L','AR_tax:IC_taxpart:IC_taxservice','467');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4671','FizetendÃ ÃFA 15%','A','L','AR_tax:IC_taxpart:IC_taxservice','467');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4672','FizetendÃ ÃFA 5%','A','L','AR_tax:IC_taxpart:IC_taxservice','467');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4673','FizetendÃ ÃFA adÃmentes','A','L','AR_tax:IC_taxpart:IC_taxservice','467');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5200','BÃrleti dÃj','A','E','AP_amount','520');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5210','Telefon','A','E','AP_amount','521');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5990','KÃltsÃgek','A','E','IC_expense','599');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8140','Eladott Ãruk beszerzÃsi ÃrtÃke','A','E','IC_cogs','814');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8700','ÃrfolyamvesztesÃg','A','E','','870');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9110','BelfÃldi ÃrbevÃtel','A','I','AR_amount:IC_sale:IC_income','911');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9111','KÃlfÃldi ÃrbevÃtel','A','I','AR_amount:IC_sale:IC_income','911');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9700','ÃrfolyamnyeresÃg','A','I','','970');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1','BEFEKTETETT ESZKÃZÃK','H','A','','1');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2','KÃSZLETEK','H','A','','2');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3','KÃVETELÃSEK','H','A','','3');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4','KÃTELEZETTSÃGEK','H','L','','4');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5','KÃLTSÃGEK','H','E','','5');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8','RÃFORDÃTÃSOK','H','E','','8');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9','BEVÃTELEK','H','I','','9');
---
-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','');
-INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4662'),'0.05','');
-INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4663'),'0','');
-INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4670'),'0.20','');
-INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4671'),'0.15','');
-INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4672'),'0.05','');
-INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4673'),'0','');
---
-INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', 
-(SELECT id FROM chart WHERE accno = '2110'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '9110'));
- INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '8140'));
- INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE accno = '9700'));
- INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE accno = '8700'));
- INSERT INTO defaults (setting_key, value) VALUES ('curr', 'HUF:EUR:USD');
- INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
- UPDATE defaults SET value = 'VK00000'    WHERE setting_key = 'glnumber';
- UPDATE defaults SET value = 'VSZ10000'   WHERE setting_key = 'sinumber';  
- UPDATE defaults SET value = 'SZSZ10000'  WHERE setting_key = 'vinumber';  
- UPDATE defaults SET value = 'BR10000'    WHERE setting_key = 'ponumber';  
- UPDATE defaults SET value = 'VR10000'    WHERE setting_key = 'sonumber';  
- UPDATE defaults SET value = 'AA10000'    WHERE setting_key = 'sqnumber';  
- UPDATE defaults SET value = 'AK10000'    WHERE setting_key = 'rfqnumber';  
- UPDATE defaults SET value = 'ALK0000'    WHERE setting_key = 'employeenumber';  
- UPDATE defaults SET value = 'VEVO10000'  WHERE setting_key = 'customernumber';  
- UPDATE defaults SET value = 'SZALL10000' WHERE setting_key = 'vendornumber';  
- UPDATE defaults SET value = 'PROJ10000'  WHERE setting_key = 'projectnumber';  
-
-commit;

Copied: trunk/sql/coa/hu/chart/Minimal.sql (from rev 2021, trunk/sql/coa/hu/chart/Default.sql)
===================================================================
--- trunk/sql/coa/hu/chart/Minimal.sql	                        (rev 0)
+++ trunk/sql/coa/hu/chart/Minimal.sql	2007-12-30 04:51:32 UTC (rev 2022)
@@ -0,0 +1,70 @@
+begin;
+--Hungarian chart of accounts 
+-- Magyar fÃkÃnyvi szÃmlÃk, amelyek csak pÃldakÃnt szolgÃlnak
+--
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1140','Irodai eszkÃzÃk','A','A','','114');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1199','Irodai eszkÃzÃk ÃCS','A','A','','119');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2610','Ãruk ','A','A','IC','261');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3110','VevÃk','A','A','AR','311');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3111','KÃlfÃldi vevÃk','A','A','AR','311');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3810','PÃnztÃr 1','A','A','AR_paid:AP_paid','381');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3811','PÃnztÃr 2','A','A','AR_paid:AP_paid','381');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3840','Bank 1','A','A','AR_paid:AP_paid','384');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3841','Bank 2','A','A','AR_paid:AP_paid','384');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4540','BelfÃldi SzÃllÃtÃk','A','L','AP','454');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4541','KÃlfÃldi szÃllÃtÃk','A','L','AP','454');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4660','VisszaigÃnyelhetÃ ÃFA 20%','A','L','AP_tax:IC_taxpart:IC_taxservice','466');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4661','VisszaigÃnyelhetÃ ÃFA 12%','A','L','AP_tax:IC_taxpart:IC_taxservice','466');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4662','VisszaigÃnyelhetÃ ÃFA 5%','A','L','AP_tax:IC_taxpart:IC_taxservice','466');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4663','VisszaigÃnyelhetÃ ÃFA adÃmentes','A','L','AP_tax:IC_taxpart:IC_taxservice','466');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4670','FizetendÃ ÃFA 20%','A','L','AR_tax:IC_taxpart:IC_taxservice','467');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4671','FizetendÃ ÃFA 15%','A','L','AR_tax:IC_taxpart:IC_taxservice','467');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4672','FizetendÃ ÃFA 5%','A','L','AR_tax:IC_taxpart:IC_taxservice','467');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4673','FizetendÃ ÃFA adÃmentes','A','L','AR_tax:IC_taxpart:IC_taxservice','467');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5200','BÃrleti dÃj','A','E','AP_amount','520');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5210','Telefon','A','E','AP_amount','521');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5990','KÃltsÃgek','A','E','IC_expense','599');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8140','Eladott Ãruk beszerzÃsi ÃrtÃke','A','E','IC_cogs','814');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8700','ÃrfolyamvesztesÃg','A','E','','870');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9110','BelfÃldi ÃrbevÃtel','A','I','AR_amount:IC_sale:IC_income','911');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9111','KÃlfÃldi ÃrbevÃtel','A','I','AR_amount:IC_sale:IC_income','911');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9700','ÃrfolyamnyeresÃg','A','I','','970');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1','BEFEKTETETT ESZKÃZÃK','H','A','','1');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2','KÃSZLETEK','H','A','','2');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3','KÃVETELÃSEK','H','A','','3');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4','KÃTELEZETTSÃGEK','H','L','','4');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5','KÃLTSÃGEK','H','E','','5');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8','RÃFORDÃTÃSOK','H','E','','8');
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('9','BEVÃTELEK','H','I','','9');
+--
+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','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4662'),'0.05','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4663'),'0','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4670'),'0.20','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4671'),'0.15','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4672'),'0.05','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4673'),'0','');
+--
+INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', 
+(SELECT id FROM chart WHERE accno = '2110'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '9110'));
+ INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '8140'));
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE accno = '9700'));
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE accno = '8700'));
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'HUF:EUR:USD');
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+ UPDATE defaults SET value = 'VK00000'    WHERE setting_key = 'glnumber';
+ UPDATE defaults SET value = 'VSZ10000'   WHERE setting_key = 'sinumber';  
+ UPDATE defaults SET value = 'SZSZ10000'  WHERE setting_key = 'vinumber';  
+ UPDATE defaults SET value = 'BR10000'    WHERE setting_key = 'ponumber';  
+ UPDATE defaults SET value = 'VR10000'    WHERE setting_key = 'sonumber';  
+ UPDATE defaults SET value = 'AA10000'    WHERE setting_key = 'sqnumber';  
+ UPDATE defaults SET value = 'AK10000'    WHERE setting_key = 'rfqnumber';  
+ UPDATE defaults SET value = 'ALK0000'    WHERE setting_key = 'employeenumber';  
+ UPDATE defaults SET value = 'VEVO10000'  WHERE setting_key = 'customernumber';  
+ UPDATE defaults SET value = 'SZALL10000' WHERE setting_key = 'vendornumber';  
+ UPDATE defaults SET value = 'PROJ10000'  WHERE setting_key = 'projectnumber';  
+
+commit;


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
Prev by Date: SF.net SVN: ledger-smb: [2021] trunk/sql/coa/hu/chart
Next by Date: SF.net SVN: ledger-smb: [2023] trunk/CONTRIBUTORS
Previous by thread: SF.net SVN: ledger-smb: [2021] trunk/sql/coa/hu/chart
Next by thread: SF.net SVN: ledger-smb: [2023] trunk/CONTRIBUTORS
Index(es):
- Date
- Thread