diff options
Diffstat (limited to 'sql/Hungary-chart.sql')
| -rwxr-xr-x | sql/Hungary-chart.sql | 64 |
1 files changed, 32 insertions, 32 deletions
diff --git a/sql/Hungary-chart.sql b/sql/Hungary-chart.sql index e4ac4a73..9cf16fbc 100755 --- a/sql/Hungary-chart.sql +++ b/sql/Hungary-chart.sql @@ -1,40 +1,40 @@ --Hungarian chart of accounts --- Magyar főkönyvi számlák, amelyek csak példaként szolgálnak +-- 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 ('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 25%','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 25%','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 ('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 25%','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 25%','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 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.25',''); INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4661'),'0.15',''); |