[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb:[2882] branches/1.2/sql/Latvia-chart.sql

Subject: SF.net SVN: ledger-smb:[2882] branches/1.2/sql/Latvia-chart.sql
From: ..hidden..
Date: Wed, 10 Feb 2010 04:43:40 +0000
Revision: 2882
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2882&view=rev
Author:   einhverfr
Date:     2010-02-10 04:43:40 +0000 (Wed, 10 Feb 2010)

Log Message:
-----------
Encoding of Latvian chart changed to utf8 (Janeks Kamerovskis)

Modified Paths:
--------------
    branches/1.2/sql/Latvia-chart.sql

Modified: branches/1.2/sql/Latvia-chart.sql
===================================================================
--- branches/1.2/sql/Latvia-chart.sql	2010-02-10 04:36:55 UTC (rev 2881)
+++ branches/1.2/sql/Latvia-chart.sql	2010-02-10 04:43:40 UTC (rev 2882)
@@ -3,252 +3,318 @@
 -- prepared by Kaspars Melkis <..hidden..>
 -- Sept. 14, 2003
 -- checked and edited Sept. 20, 2003, D. Simader
+-- modified by Janeks Kamerovskis <..hidden..>
+-- Nov. 5, 2009
+
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1','IlgtermiÅa ieguldÄjumi','H','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2','ApgrozÄmie lÄdzekÄi','H','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('11','NemateriÄlie ieguldÄjumi','H','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('12','PamatlÄdzekÄi','H','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1210','Zemes gabali,Äkas,bÅves,ilggadÄgie stÄdÄjumi un citi nekustamÄ ÄpaÅuma objekti','A','A','IC','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1290','PamatlÄdzekÄu nolietojums (pasÄvÄ)','A','A','IC','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('13','IlgtermiÅa finansu ieguldÄjumi','H','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('21','KrÄjumi','H','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2130','GatavÄs preces pÄrdoÅanai','A','A','IC','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2310','NorÄÄini ar pircÄjiem un pasÅtÄtÄjiem','A','L','AP','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('23','NorÄÄini par prasÄbÄm (ar debitoriem)','H','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2350','NorÄÄini ar citiem debitoriem','A','A','AR_amount','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('26','Naudas lÄdzekÄi','H','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2610','Kase','A','A','AR_paid:AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1380','Aizdevumi uzÅÄmuma dalÄbniekiem un valdei','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1310','LÄdzdalÄba meitas uzÅÄmumu kapitÄlÄ','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1340','Aizdevumi saistÄtajiem uzÅÄmumiem','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1350','PÄrÄjie vÄrtspapÄri','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5','Kreditori','H','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1370','PaÅu akcijas un daÄas','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2210','PieauguÅie produktÄvie lopi','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('3350','StatÅtos paredzÄtÄs rezerves','A','Q','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2220','Jaunlopi un sÄkie dzÄvnieki','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2320','Par piegÄdÄm un pasÅtÄjumiem saÅemtie vekseÄi','A','A','IC','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2140','Nepabeigtie pasÅtÄjumi','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2370','ÃstermiÅa aizdevumi sabiedrÄbÄm dalÄbniekiem un vadÄbai','A','A','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1360','PÄrÄjie aizdevumi','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2120','Nepabeigtie raÅojumi','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2330','Meitas uzÅÄmumu parÄdi','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2340','SaistÄto uzÅÄmumu parÄdi','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2380','NorÄÄini par prasÄbÄm pret personÄlu un ÄstermiÅa aizdevumi personÄlam','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2410','NÄkamo periodu izdevumi','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2420','Akciju emisijas  nocenojums (disagio)','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('25','VÄrtspapÄri apgrozÄmo lÄdzekÄu sastÄvÄ un ÄstermiÅa lÄdzdalÄba kapitÄlos','H','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2510','Meitas  uzÅÄmuma akcijas un daÄas ','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2520','SaistÄto uzÅÄmuma akcijas un daÄas ','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2530','PaÅu  uzÅÄmuma akcijas un daÄas ','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2540','PÄrÄjie vÄrtspapÄri un lÄdzdalÄba kapitÄlos','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2640','AkreditÄvi,Ãeki un ÄpaÅu norÄÄina  formu konti','A','A','AR_paid:AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2650','Citi konti bankÄs','A','A','AR_paid:AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2670','PÄrÄjie naudas lÄdzekÄi','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('3','PaÅu kapitÄls','H','Q','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('3130','IlgtermiÅa ieguldÄjuma pÄrvÄrtÄÅanas rezerve','A','Q','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('3120','Akciju emisijas uzcenojums (agio)','A','Q','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('32','PrivÄtkonti','H','Q','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('3210','PrivÄtiem nolÅkiem izÅemtie lÄdzekÄi','A','Q','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('33','Rezerves ','H','Q','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('3310','Rezerves kapitÄls','A','Q','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('3330','Citas likumÄ paredzÄtÄs  rezerves','A','Q','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('3340','Rezerves paÅu akcijÄm un daÄÄm','A','Q','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('3360','PÄrÄjÄs rezerves','A','Q','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('34','NesadalÄtÄ peÄÅa vai nesegtie zaudÄjumi','H','Q','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('3410','PÄrskata gada nesadalÄtÄ peÄÅa','A','Q','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('3420','IepriekÅÄjo gadu nesadalÄtÄ peÄÅa','A','Q','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('4','UzkrÄjumi','H','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('4110','UzkrÄjumi pensijÄm pielÄdzinÄtÄm saistÄbÄm','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('4310','Citi uzkrÄjumi','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('41','UzkrÄjumi pensijÄm pielÄdzinÄmÄtÄm saistÄbÄm','H','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('43','Citi uzkrÄjumi','H','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('42','UzkrÄjumi paredzamiem nodokÄiem','H','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('51','NorÄÄini par aizÅÄmumiem','H','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5110','AizÅÄmumi pret obligÄcijÄm','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5120','AkcijÄs pÄrvÄÅamie aizÅÄmumi','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5130','AizÅÄmumi ar lÄdzdalÄbu peÄÅÄ','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5140','Citi aizÅÄmumi','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5150','ÃstermiÅa aizÅÄmumi  no kredÄtiestÄdÄm','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5160','IlgtermiÅa aizÅÄmumi no kredÄtiestÄdÄm','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5170','AizÅÄmumi no kredÄtiestÄdÄm bez norÄdÄtÄ termiÅa','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('52','NorÄÄini par saÅemtajiem avansiem','H','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5210','NorÄÄini par saÅemtiem avansiem','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('54','MaksÄjamie vekseÄi','H','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('53','NorÄÄini par piegÄdÄtÄjiem un darbuzÅÄmÄjiem','H','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5310','NorÄÄini par piegÄdÄtÄjiem un darbuzÅÄmÄjiem','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5410','NorÄÄini par paÅu izdotajiem vekseÄiem','A','L','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5510','NorÄÄini par parÄdiem meitas uzÅÄmumiem','A','L','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5540','NorÄÄini par parÄdiem citiem uzÅÄmumiem un dalÄbniekiem','A','L','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5550','NorÄÄini par parÄdiem personÄlam','A','L','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5520','NorÄÄini par parÄdiem saistÄtiem uzÅÄmumiem','A','L','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5530','NorÄÄini par parÄdiem uzÅÄmumiem,ar kuriem ir lÄgums par lÄdzdalÄbu','A','L','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('57','NorÄÄini par nodokÄiem','H','L','AP_amount','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('58','NorÄÄini par  dividendÄm','H','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('61','IeÅÄmumi no pÄrdoÅanas,kas apliekami ar nodokÄiem vispÄrÄjÄ kÄrtÄbÄ','H','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('62','IeÅÄmumi no pÄrdoÅanas,kas citÄdi  apliekami ar nodokÄiem','H','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6220','Ar ÄpaÅiem nodokÄiem apliekamie pÄrdoÅanas ieÅÄmumi','A','I','AR_amount:IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('63','Komisijas,starpniecÄbas un citi ieÅÄmumi','H','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6310','Komisijas un starpniecÄbas ieÅÄmumi','A','I','IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6320','IeÅÄmumi no atkritumu pÄrstrÄdes un realizÄcijas','A','I','AR_amount:IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6330','IeÅÄmumi no taras realizÄcijas','A','I','AR_amount:IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6340','Ar nodokÄiem neapliekamie apgrozÄjumi','A','I','AR_amount:IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('64','IeÅÄmumus samazinoÅas atlaides','H','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6410','PieÅÄirtÄs skonto atlaides','A','I','IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6420','PieÅÄirtie bonusi','A','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('59','NÄkamo periodu ieÅÄmumi','H','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('65','PÄrÄjie uzÅÄmuma ieÅÄmumi','H','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6510','IeÅÄmumi no vÄrtspapÄru kursa paaugstinÄÅanÄs','A','I','AR_amount','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6530','IeÅÄmumi no zemes gabalu iznomÄÅanas','A','I','AR_amount','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6540','IeÅÄmumi no apgrozÄmo lÄdzekÄu pÄrdoÅanas','A','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6550','IeÅÄmumi no pamatlÄdzekÄu iznomÄÅanas','A','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6560','IeÅÄmumos pÄrskaitÄtais rezervju un uzkrÄjumu samazinÄjums','A','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6570','IepriekÅÄjo gadu nodokÄu samazinÄjums','A','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6580','Papildus  ieguldÄjumi un citi ieÅÄmumi','A','I','AR_amount','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6590','PaÅu uzÅÄmuma kapitÄlieguldÄjumiem izpildÄtie darbi','A','I','AR_amount','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('67','Citu periodu ieÅÄmumi,kas attiecas uz pÄrskata periodu','H','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6710','Citu periodu ieÅÄmumi,kas attiecas uz pÄrskata periodu','A','I','AR_amount','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('69','SociÄlÄs infrastruktÅras iestÄÅu un pasÄkumu ieÅÄmumi','H','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6930','SadzÄves paklpojumu ieÅÄmumi','A','I','IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6920','KomunÄlÄs  saimniecÄbas ieÅÄmumi','A','I','IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('66','GatavÄs produkcijas  un nepabeigto  raÅojumu krÄjumu un vÄrtÄbas  izmaiÅas','H','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6610','GatavÄs produkcijas krÄjumu un vÄrtÄbas izmaiÅas','A','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6620','Nepabeigto raÅojumu krÄjumu un vÄrtÄbas  izmaiÅas','A','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6630','Nepabeigto pasÅtÄjumu atlikumu un vÄtÄbas izmaiÅas','A','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6640','ProduktÄvo  un darba dzÄvnieku ganÄmpulka vÄrtÄbas izmaiÅas','A','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6940','SabiedriskÄs ÄdinÄÅanas ieÅÄmumi','A','I','IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6950','IzglÄtÄbas iestÄÅu ieÅÄmumi','A','I','IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6960','MedicÄnas iestÄÅu ieÅÄmumi','A','I','IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6970','KultÅras un sporta ietÄÅu un pasÄkumu ieÅÄmumi','A','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6980','PÄrÄjie sociÄlÄs infrastruktÅras iestÄÅu un pasÄkumu ieÅÄmumi','A','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7','SaimnieciskÄs darbÄbas izdevumi','H','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7130','SaÅemtÄs atlaides','A','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7140','Taras izdevumi','A','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7160','PÄrÄjie ÄrÄjie izdevumi','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('72','PersonÄla izmaksas','H','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7210','StrÄdnieku algas','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7230','SociÄlÄs  infrastruktÅras  iestÄÅu un pasÄkumu darbinieku algas','A','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('73','SociÄlÄs nodevas un izmaksas','H','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7320','PÄrÄjÄs sociÄlÄs izmaksas','A','E','AP_tax','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('74','PamatlÄdzekÄu nolietojums un citu ieguldÄjumu vÄrtÄbas norakstÄjumi','H','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7410','NemateriÄlo ieguldÄjumu vÄrtÄbas norakstÄÅana','A','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('75','PÄrÄjie saimnieciskÄs darbÄbas  izdevumi','H','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7510','Dabas aizsardzÄbas izdevumi','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7530','Nodevas par raÅoÅanÄ izmantotiem zemes gabaliem','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7440','ApgrozÄmo lÄdzekÄu vÄrtÄbas norakstÄÅana','A','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7540','ApdroÅinnÄÅanas maksÄjumi (izÅemot darbinieku apdroÅinÄÅanu)','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7550','PÄrÄjie saimnieciskÄs darbÄbas izdevumi','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7560','StrÄdnieku vervÄÅanas un apmÄcÄbas izdevumi','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7120','PreÄu iepirkÅanas un piegÄdes izdevumi','A','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7610','IesaiÅojamais materiÄls,tara','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7190','Pirkto materiÄlu un preÄu krÄjumu un vÄrtÄbas izmaiÅas','A','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7640','SamaksÄtÄs komisijas naudas','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7650','Citi pÄrdoÅanas izdevumi','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('77','AdministrÄcijas izdevumi','H','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7710','Sakaru izdevumi','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7720','Kantora (biroja) izdevumi','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7730','Juristu pakalpojumu apmaksa','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7740','Gada pÄrskata un revÄzijas izdevumi','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7750','Naudas apgrozÄjuma blakus izdevumi','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7760','Transporta izdevumi administrÄcijas vajadzÄbÄm','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7770','Citi vadÄÅanas un administrÄcijas izdevumi','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('78','PÄrskata periodÄ iekÄaujamie iepriekÅÄjo periodu izdevumi','H','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7810','PÄrskata periodÄ iekÄaujamie iepriekÅÄjo periodu izdevumi','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('79','SociÄlÄs  infrastruktÅras uzturÄÅanas izdevumi','H','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7920','KomuÄlÄs saimniecÄbas izdevumi','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7940','SabiedriskÄs ÄdinÄÅanas izdevumi','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7950','IzglÄtÄbas iestÄÅu izdevumi','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8','DaÅÄdi ieÅÄmumi un izdevumi,peÄÅa un zaudÄjumi','H','Q','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('81','DaÅÄdi ieÅÄmumi','H','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8110','IeÅÄmumi no lÄdzdalÄbas,vÄrtspapÄriem un aizdevumiem','A','I','IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8120','PÄrÄjie ieÅÄmumi no procentiem un tiem pielÄdzinÄmi ieÅÄmumi','A','I','IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7910','DzÄvokÄu saimniecÄbas izdevumi','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8130','VekseÄu diskonta ieÅÄmumi','A','I','IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8150','IenÄkumi no valÅtas kursa paaugstinÄÅanÄs','A','I','IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8160','SaÅemtÄs soda naudas un lÄgumsodi','A','I','IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8170','PeÄÅa no Ärzemju valÅtas pÄrdoÅanas vai pirkÅanas','A','I','IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8190','Citi ieÅÄmumi','A','I','IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('82','DaÅÄdi izdevumi','H','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8210','ÃstermiÅa finansu ieguldÄjumu vÄrtÄbas norakstÄÅana','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8220','SamaksÄtie procenti un tiem pielÄdzinÄmie izdevumi','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8230','VekseÄu diskonta izmaksas','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8240','IlgtermiÅa aizdevumu procentu samaksa','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8260','SamaksÄtÄs soda naudas un lÄgumsodi','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8270','ZaudÄjumi no Ärzemju valÅtas pirkÅanas un pÄrdoÅanas','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8290','Citi izdevumi','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('83','ÃrkÄrtas ieÅÄmumi','H','I','IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8310','ÃrkÄrtas ieÅÄmumi','A','I','IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('84','ÃrkÄrtas izdevumi','H','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8410','ÃrkÄrtas izdevumi','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('86','PeÄÅa vai zaudÄjumi','H','I','IC_income:IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8610','PeÄÅa vai zaudÄjumi','A','I','IC_income:IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('3220','PrivÄtie ieguldÄjumi','A','Q','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7630','PreÄu transporta apdroÅinÄÅana','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7110','Izejvielu un materiÄlu iepirkÅanas un piegÄdes izdevumi','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7150','Muitas un ievednodevas','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7170','Samaksa par darbiem un pakalpojumiem no Ärienes','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('71','Izdevumi izejvielu,materiÄlu un preÄu iepirkÅanai','H','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6110','IeÅÄmumi no pamatdarbÄbas  produkcijas un pakalpojumu pÄrdoÅanas','A','I','AR_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1220','TehnoloÃiskÄs  iekÄrtas un maÅÄnas','A','A','IC','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1240','PamatlÄdzekÄu izveidoÅana un nepabeigto celtniecÄbas objektu izmaksas','A','A','IC','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1320','Aizdevumi meitas uzÅÄmumam','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2110','Izejvielas un materiÄli','A','A','AP','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2190','Avansa maksÄjumi par precÄm','A','A','AR','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1130','UzÅÄmuma nemateriÄlÄ vÄrtÄba','A','A','IC','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1180','Avansa maksÄjumi par nemateriÄliem aktÄviem','A','A','IC','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1190','NemateriÄlo ieguldÄjumu vÄrtÄbas norakstÄtÄ daÄa (pasÄvÄ)','A','A','IC','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('22','ProduktÄvie un darba dzÄvnieki','H','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2230','Darba lopi','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2290','Darba lopu norakstÄtÄ vÄrtÄba (pasÄvÄ)','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2360','NorÄÄini par parakstÄtÄ sabiedrÄbas kapitÄlÄ neiemaksÄtÄm summÄm','A','A','AR_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('24','NÄkamo periodu izdevumi','H','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2620','NorÄÄinu konti bankÄ','A','A','AR_paid:AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('3110','PamatkapitÄls vai lÄdzdalÄbas kapitÄls','A','Q','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('55','NorÄÄini ar uzÅÄmumiem,dalÄbniekiem un personÄlu','H','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('56','NorÄÄini  par darba samaksu  un ieturÄjumiem (izÅemot nodokÄus)','H','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5610','NorÄÄini par darba algu','A','E','AP_amount','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5620','NorÄÄini par ieturÄjumiem no darba algas (izÅemot nodokÄus)','A','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5820','NorÄÄini par iepriekÅÄjo gadu neizmaksÄtajÄm dividendÄm','A','L','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5810','NorÄÄini par pÄrskata gada dividendÄm','A','L','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5910','NÄkamo periodu ieÅÄmumi','A','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6','IeÅÄmumi no uzÅÄmuma saimnieciskÄs darbÄbas','H','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6210','Ar nodokÄiem neapliekamie pÄrdoÅanas ieÅÄmumi','A','I','AR_amount:IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6430','PieÅÄirtie rabati un citas tirdzniecÄbas  atlaides','A','I','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6910','DzÄvokÄu saimniecÄbas ieÅÄmumi','A','I','AR_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7180','PÄrÄjie materiÄlie izdevumi (nodoklis par dabas resursu izmantoÅanu,celmu nauda u.c.)','A','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7240','PÄrÄjÄs personÄla izmaksas','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7220','PÄrvaldes personÄla un administratÄvÄ personÄla algas','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7420','PamatlÄdzekÄu nolietojums','A','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7570','KomandÄjuma izdevumi','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7930','SadzÄves pakalpojumu izdevumi','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7960','MedicÄniskÄs apkalpoÅanas izdevumi','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7970','KultÅras un sporta iestÄÅu un pasÄkumu izdevumi','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8140','Ziedojumi un citi tiem pielÄdzinÄmi ieÅÄmumi','A','I','IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8250','ZaudÄjumi no valÅtu  kursa pazeminÄÅanÄs','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7980','PÄrÄjie sociÄlÄs infrastruktÅras uzturÄÅanas izdevumi','A','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('87','PeÄÅas izlietojums (bez nodokÄiem)','H','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('88','NodoÄi no peÄÅas un citi saimnieciskÄs darbÄbas izdevumos neiekÄaujamie nodokÄi','H','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1110','PÄtniecÄbas un uzÅÄmuma attÄstÄbas izmaksas','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1120','Koncesijas,patenti,licences,tirdzniecÄbas zÄmes un lÄdzÄgas tiesÄbas; datoru programmas','A','A','IC','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5710','NorÄÄini par peÄÅas nodokli','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2390','PÄrmaksÄtie nodokÄi,iepriekÅ samaksÄtie nodokÄi','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('4210','UzkrÄjumi paredzamiem nodokÄiem','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5720','NorÄÄini par citiem nodokÄiem,nodevÄm un maksÄjumiem budÅetam','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7310','SociÄlais nodoklis','A','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8710','PeÄÅas izlietojums','A','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8830','Nodoklis par zemi','A','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8840','Citi saimnieciskÄs darbÄbas izmaksÄs neiekÄaujamie nodokÄi','A','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8820','Nodoklis par dabas resursu izmantoÅanu no peÄÅas  maksÄjamÄ daÄÄ','A','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8810','Nodoklis no peÄÅas','A','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1330','LÄdzdalÄbas saistÄto uzÅÄmumu kapitÄlÄ','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2354','PVN samaksÄts 18%','A','E','AP_tax:IC_taxpart:IC_taxservice','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2352','PVN ieÅemtais 18%','A','L','AR_tax:IC_taxpart:IC_taxservice','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('76','PreÄu pÄrdoÅanas izdevumi','H','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7620','PreÄu transporta izdevumi','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2353','PVN ieÅemtais 21%','A','L','AR_tax:IC_taxpart:IC_taxservice','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2355','PVN samaksÄts 21%','A','E','AP_tax:IC_taxpart:IC_taxservice','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1231','PÄrÄjie pamatlÄdzekÄi','A','A','IC','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1232','Datu uzkrÄÅanas iekÄrtas','A','A','IC','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5311','NorÄÄini ar piegÄdÄtÄjiem','A','L','AP','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1292','PÄrÄjo pamatlÄdzekÄu nolietojums','A','A','IC','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1291','Datu uzkrÄÅanas iekÄrtu nolietojums','A','A','IC','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2312','PVN par precÄm ES','A','L','AP','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2361','NorÄÄini par kapitÄlÄ neiemaksÄtÄm daÄÄm','A','A','AR_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2411','NÄkamo periodu izdevumi','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2611','Kase LVL','A','A','AR_paid:AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2621','SEB LVL','A','A','AR_paid:AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2622','Swedbank LVL','A','A','AR_paid:AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('3111','PamatkapitÄls','A','Q','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('3411','PÄrskata gada nesadalÄtÄ peÄÅa','A','Q','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('3412','IepriekÅÄjo gadu nesadalÄtÄ peÄÅa','A','Q','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('4311','UzkrÄjumi UIEN','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5312','NorÄÄini ar piegÄdÄtÄjiem preces ES','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5611','Darba samaksa','A','E','AP_amount','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5711','UzÅÄmuma ienÄkuma nodoklis','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5721','PVN','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('57212','PVN 18 % ES par precÄm','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5723','NorÄÄini par VSAOI','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5724','NorÄÄini par IIEN','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5727','NorÄÄini par UDRVN','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7111','MateriÄli','A','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7311','VSAOI','A','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7421','PamatlÄdzekÄu amortizÄcija','A','E','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7541','ApdroÅinÄÅanas izdevumi','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('6111','IeÅÄmumi no pakalpojumiem','A','I','AR_amount:IC_income:IC_sale','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2311','NorÄÄini ar pircÄjiem','A','L','AR','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7211','Darba samaksa','A','E','AP_paid:IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1230','PÄrÄjie pamatlÄdzekÄi un inventÄrs','A','A','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7555','Saimnieciskie izdevumi','A','E','AP_amount:IC_expense:IC_cogs','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('57211','PVN 18 %','A','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7571','KomandÄjuma izdevumi','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7622','DÄzeÄdegvielas izdevumi','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7624','PÄrÄjie transporta izdevumi','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7731','Juristu,advokÄtu,notÄru pakalpojumi','A','E','AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7772','UzÅÄmÄjdarbÄbas riska valsts nodeva','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7773','Valsts nodevas','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7778','ReprezentÄcijas izdevumi','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8121','Bankas % ieÅÄmumi','A','I','IC_income','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8291','Citi izdevumi','A','E','IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('8611','PeÄÅa vai zaudÄjumi','A','I','IC_income:IC_expense','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2111','MateriÄli','A','A','AP','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('57213','PVN 21 %','A','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2381','NorÄÄini ar J.BÄrziÅÅ','A','A','AR_paid:AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7441','InventÄrs','A','E','AP_amount:IC_expense:IC_cogs','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7721','Biroja izdevumi','A','E','AP_amount:IC_expense:IC_cogs','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7771','Citi administrÄcijas izdevumi','A','E','AP_amount:IC_expense:IC_cogs','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7741','GrÄmatvedÄbas pakalpojumi','A','E','AP_amount:IC_expense:IC_cogs','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7711','Sakaru izdevumi','A','E','AP_amount:IC_expense:IC_cogs','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7623','Rezerves daÄas','A','E','AP_amount:IC_expense:IC_cogs','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7625','Auto uzturÄÅanas izdevumi','A','E','AP_amount:IC_expense:IC_cogs','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7660','ReklÄmas izdevumi','A','E','AP_amount:IC_expense:IC_cogs','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7751','Bankas pakalpojumi','A','E','AP_amount:IC_expense:IC_cogs','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7621','BenzÄna izdevumi','A','E','AP_amount:IC_expense:IC_cogs','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('5729','NorÄÄini PVN ar budÅetu','A','L','','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('2382','NorÄÄini ar G.Ozolu','A','A','AR_paid:AP_paid','',false);
+INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('7553','ElektrÄbas izdevumi','A','E','AP_amount:IC_expense:IC_cogs','',false);
 --
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1','IlgtermiÃa ieguldÃjumi','H','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2','ApgrozÃmie lÃdzekÃi','H','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('11','NemateriÃlie ieguldÃjumi','H','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('12','PamatlÃdzekÃi','H','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1210','Zemes gabali, Ãkas, bÃves, ilggadÃgie stÃdÃjumi un citi nekustamÃ ÃpaÃuma objekti','A','A','IC','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1290','PamatlÃdzekÃu nolietojums (pasÃvÃ)','A','A','IC','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('13','IlgtermiÃa finansu ieguldÃjumi','H','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('21','KrÃjumi','H','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2130','GatavÃs preces pÃrdoÃanai','A','A','IC','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2310','NorÃÃini ar pircÃjiem un pasÃtÃtÃjiem','A','L','AP','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('23','NorÃÃini par prasÃbÃm (ar debitoriem)','H','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2350','NorÃÃini ar citiem debitoriem','A','A','AR_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('26','Naudas lÃdzekÃi','H','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2610','Kase','A','A','AR_paid:AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1380','Aizdevumi uzÃÃmuma dalÃbniekiem un valdei','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1310','LÃdzdalÃba meitas uzÃÃmumu kapitÃlÃ','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1340','Aizdevumi saistÃtajiem uzÃÃmumiem','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1350','PÃrÃjie vÃrtspapÃri','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5','Kreditori','H','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1370','PaÃu akcijas un daÃas','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2210','PieauguÃie produktÃvie lopi','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3350','StatÃtos paredzÃtÃs rezerves','A','Q','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2220','Jaunlopi un sÃkie dzÃvnieki','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2320','Par piegÃdÃm un pasÃtÃjumiem saÃemtie vekseÃi','A','A','IC','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2140','Nepabeigtie pasÃtÃjumi','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2370','ÃstermiÃa aizdevumi sabiedrÃbÃm dalÃbniekiem un vadÃbai','A','A','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1360','PÃrÃjie aizdevumi','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2120','Nepabeigtie raÃojumi','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2330','Meitas uzÃÃmumu parÃdi','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2340','SaistÃto uzÃÃmumu parÃdi','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2380','NorÃÃini par prasÃbÃm pret personÃlu un ÃstermiÃa aizdevumi personÃlam','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2410','NÃkamo periodu izdevumi','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2420','Akciju emisijas  nocenojums (disagio)','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('25','VÃrtspapÃri apgrozÃmo lÃdzekÃu sastÃvÃ un ÃstermiÃa lÃdzdalÃba kapitÃlos','H','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2510','Meitas  uzÃÃmuma akcijas un daÃas ','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2520','SaistÃto uzÃÃmuma akcijas un daÃas ','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2530','PaÃu  uzÃÃmuma akcijas un daÃas ','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2540','PÃrÃjie vÃrtspapÃri un lÃdzdalÃba kapitÃlos','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2640','AkreditÃvi, Ãeki un ÃpaÃu norÃÃina  formu konti','A','A','AR_paid:AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2650','Citi konti bankÃs','A','A','AR_paid:AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2670','PÃrÃjie naudas lÃdzekÃi','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3','PaÃu kapitÃls','H','Q','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3130','IlgtermiÃa ieguldÃjuma pÃrvÃrtÃÃanas rezerve','A','Q','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3120','Akciju emisijas uzcenojums (agio)','A','Q','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('32','PrivÃtkonti','H','Q','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3210','PrivÃtiem nolÃkiem izÃemtie lÃdzekÃi','A','Q','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('33','Rezerves ','H','Q','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3310','Rezerves kapitÃls','A','Q','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3330','Citas likumÃ paredzÃtÃs  rezerves','A','Q','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3340','Rezerves paÃu akcijÃm un daÃÃm','A','Q','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3360','PÃrÃjÃs rezerves','A','Q','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('34','NesadalÃtÃ peÃÃa vai nesegtie zaudÃjumi','H','Q','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3410','PÃrskata gada nesadalÃtÃ peÃÃa','A','Q','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3420','IepriekÃÃjo gadu nesadalÃtÃ peÃÃa','A','Q','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4','UzkrÃjumi','H','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4110','UzkrÃjumi pensijÃm pielÃdzinÃtÃm saistÃbÃm','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4310','Citi uzkrÃjumi','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('41','UzkrÃjumi pensijÃm pielÃdzinÃmÃtÃm saistÃbÃm','H','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('43','Citi uzkrÃjumi','H','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('42','UzkrÃjumi paredzamiem nodokÃiem','H','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('51','NorÃÃini par aizÃÃmumiem','H','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5110','AizÃÃmumi pret obligÃcijÃm','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5120','AkcijÃs pÃrvÃÃamie aizÃÃmumi','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5130','AizÃÃmumi ar lÃdzdalÃbu peÃÃÃ','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5140','Citi aizÃÃmumi','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5150','ÃstermiÃa aizÃÃmumi  no kredÃtiestÃdÃm','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5160','IlgtermiÃa aizÃÃmumi no kredÃtiestÃdÃm','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5170','AizÃÃmumi no kredÃtiestÃdÃm bez norÃdÃtÃ termiÃa','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('52','NorÃÃini par saÃemtajiem avansiem','H','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5210','NorÃÃini par saÃemtiem avansiem','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('54','MaksÃjamie vekseÃi','H','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('53','NorÃÃini par piegÃdÃtÃjiem un darbuzÃÃmÃjiem','H','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5310','NorÃÃini par piegÃdÃtÃjiem un darbuzÃÃmÃjiem','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5410','NorÃÃini par paÃu izdotajiem vekseÃiem','A','L','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5510','NorÃÃini par parÃdiem meitas uzÃÃmumiem','A','L','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5540','NorÃÃini par parÃdiem citiem uzÃÃmumiem un dalÃbniekiem','A','L','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5550','NorÃÃini par parÃdiem personÃlam','A','L','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5520','NorÃÃini par parÃdiem saistÃtiem uzÃÃmumiem','A','L','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5530','NorÃÃini par parÃdiem uzÃÃmumiem, ar kuriem ir lÃgums par lÃdzdalÃbu','A','L','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('57','NorÃÃini par nodokÃiem','H','L','AP_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('58','NorÃÃini par  dividendÃm','H','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('61','IeÃÃmumi no pÃrdoÃanas, kas apliekami ar nodokÃiem vispÃrÃjÃ kÃrtÃbÃ','H','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('62','IeÃÃmumi no pÃrdoÃanas, kas citÃdi  apliekami ar nodokÃiem','H','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6220','Ar ÃpaÃiem nodokÃiem apliekamie pÃrdoÃanas ieÃÃmumi','A','I','AR_amount:IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('63','Komisijas, starpniecÃbas un citi ieÃÃmumi','H','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6310','Komisijas un starpniecÃbas ieÃÃmumi','A','I','IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6320','IeÃÃmumi no atkritumu pÃrstrÃdes un realizÃcijas','A','I','AR_amount:IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6330','IeÃÃmumi no taras realizÃcijas','A','I','AR_amount:IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6340','Ar nodokÃiem neapliekamie apgrozÃjumi','A','I','AR_amount:IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('64','IeÃÃmumus samazinoÃas atlaides','H','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6410','PieÃÃirtÃs skonto atlaides','A','I','IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6420','PieÃÃirtie bonusi','A','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('59','NÃkamo periodu ieÃÃmumi','H','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('65','PÃrÃjie uzÃÃmuma ieÃÃmumi','H','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6510','IeÃÃmumi no vÃrtspapÃru kursa paaugstinÃÃanÃs','A','I','AR_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6530','IeÃÃmumi no zemes gabalu iznomÃÃanas','A','I','AR_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6540','IeÃÃmumi no apgrozÃmo lÃdzekÃu pÃrdoÃanas','A','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6550','IeÃÃmumi no pamatlÃdzekÃu iznomÃÃanas','A','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6560','IeÃÃmumos pÃrskaitÃtais rezervju un uzkrÃjumu samazinÃjums','A','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6570','IepriekÃÃjo gadu nodokÃu samazinÃjums','A','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6580','Papildus  ieguldÃjumi un citi ieÃÃmumi','A','I','AR_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6590','PaÃu uzÃÃmuma kapitÃlieguldÃjumiem izpildÃtie darbi','A','I','AR_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('67','Citu periodu ieÃÃmumi, kas attiecas uz pÃrskata periodu','H','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6710','Citu periodu ieÃÃmumi, kas attiecas uz pÃrskata periodu','A','I','AR_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('69','SociÃlÃs infrastruktÃras iestÃÃu un pasÃkumu ieÃÃmumi','H','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6930','SadzÃves paklpojumu ieÃÃmumi','A','I','IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6920','KomunÃlÃs  saimniecÃbas ieÃÃmumi','A','I','IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('66','GatavÃs produkcijas  un nepabeigto  raÃojumu krÃjumu un vÃrtÃbas  izmaiÃas','H','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6610','GatavÃs produkcijas krÃjumu un vÃrtÃbas izmaiÃas','A','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6620','Nepabeigto raÃojumu krÃjumu un vÃrtÃbas  izmaiÃas','A','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6630','Nepabeigto pasÃtÃjumu atlikumu un vÃtÃbas izmaiÃas','A','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6640','ProduktÃvo  un darba dzÃvnieku ganÃmpulka vÃrtÃbas izmaiÃas','A','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6940','SabiedriskÃs ÃdinÃÃanas ieÃÃmumi','A','I','IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6950','IzglÃtÃbas iestÃÃu ieÃÃmumi','A','I','IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6960','MedicÃnas iestÃÃu ieÃÃmumi','A','I','IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6970','KultÃras un sporta ietÃÃu un pasÃkumu ieÃÃmumi','A','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6980','PÃrÃjie sociÃlÃs infrastruktÃras iestÃÃu un pasÃkumu ieÃÃmumi','A','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7','SaimnieciskÃs darbÃbas izdevumi','H','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('71','Izdevumi izejvielu, materiÃlu un preÃu iepirkÃanai','H','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7110','Izejvielu un materiÃlu iepirkÃanas un piegÃdes izdevumi','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7120','PreÃu iepirkÃanas un piegÃdes izdevumi','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7130','SaÃemtÃs atlaides','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7140','Taras izdevumi','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7150','Muitas un ievednodevas','A','E','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7160','PÃrÃjie ÃrÃjie izdevumi','A','E','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7170','Samaksa par darbiem un pakalpojumiem no Ãrienes','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7190','Pirkto materiÃlu un preÃu krÃjumu un vÃrtÃbas izmaiÃas','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('72','PersonÃla izmaksas','H','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7210','StrÃdnieku algas','A','E','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7230','SociÃlÃs  infrastruktÃras  iestÃÃu un pasÃkumu darbinieku algas','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('73','SociÃlÃs nodevas un izmaksas','H','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7320','PÃrÃjÃs sociÃlÃs izmaksas','A','E','AP_tax','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('74','PamatlÃdzekÃu nolietojums un citu ieguldÃjumu vÃrtÃbas norakstÃjumi','H','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7410','NemateriÃlo ieguldÃjumu vÃrtÃbas norakstÃÃana','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('75','PÃrÃjie saimnieciskÃs darbÃbas  izdevumi','H','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7510','Dabas aizsardzÃbas izdevumi','A','E','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7530','Nodevas par raÃoÃanÃ izmantotiem zemes gabaliem','A','E','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7440','ApgrozÃmo lÃdzekÃu vÃrtÃbas norakstÃÃana','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7540','ApdroÃinnÃÃanas maksÃjumi (izÃemot darbinieku apdroÃinÃÃanu)','A','E','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7550','PÃrÃjie saimnieciskÃs darbÃbas izdevumi','A','E','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7560','StrÃdnieku vervÃÃanas un apmÃcÃbas izdevumi','A','E','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('76','PreÃu pÃrdoÃanas izdevumi','H','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7610','IesaiÃojamais materiÃls, tara','A','E','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7620','PreÃu transporta izdevumi','A','E','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7630','PreÃu transporta apdroÃinÃÃana','A','E','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7640','SamaksÃtÃs komisijas naudas','A','E','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7650','Citi pÃrdoÃanas izdevumi','A','E','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('77','AdministrÃcijas izdevumi','H','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7710','Sakaru izdevumi','A','E','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7720','Kantora (biroja) izdevumi','A','E','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7730','Juristu pakalpojumu apmaksa','A','E','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7740','Gada pÃrskata un revÃzijas izdevumi','A','E','IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7750','Naudas apgrozÃjuma blakus izdevumi','A','E','IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7760','Transporta izdevumi administrÃcijas vajadzÃbÃm','A','E','IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7770','Citi vadÃÃanas un administrÃcijas izdevumi','A','E','IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('78','PÃrskata periodÃ iekÃaujamie iepriekÃÃjo periodu izdevumi','H','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7810','PÃrskata periodÃ iekÃaujamie iepriekÃÃjo periodu izdevumi','A','E','IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('79','SociÃlÃs  infrastruktÃras uzturÃÃanas izdevumi','H','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7920','KomuÃlÃs saimniecÃbas izdevumi','A','E','IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7940','SabiedriskÃs ÃdinÃÃanas izdevumi','A','E','IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7950','IzglÃtÃbas iestÃÃu izdevumi','A','E','IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8','DaÃÃdi ieÃÃmumi un izdevumi, peÃÃa un zaudÃjumi','H','Q','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('81','DaÃÃdi ieÃÃmumi','H','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8110','IeÃÃmumi no lÃdzdalÃbas, vÃrtspapÃriem un aizdevumiem','A','I','IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8120','PÃrÃjie ieÃÃmumi no procentiem un tiem pielÃdzinÃmi ieÃÃmumi','A','I','IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7910','DzÃvokÃu saimniecÃbas izdevumi','A','E','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8130','VekseÃu diskonta ieÃÃmumi','A','I','IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8150','IenÃkumi no valÃtas kursa paaugstinÃÃanÃs','A','I','IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8160','SaÃemtÃs soda naudas un lÃgumsodi','A','I','IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8170','PeÃÃa no Ãrzemju valÃtas pÃrdoÃanas vai pirkÃanas','A','I','IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8190','Citi ieÃÃmumi','A','I','IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('82','DaÃÃdi izdevumi','H','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8210','ÃstermiÃa finansu ieguldÃjumu vÃrtÃbas norakstÃÃana','A','E','IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8220','SamaksÃtie procenti un tiem pielÃdzinÃmie izdevumi','A','E','IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8230','VekseÃu diskonta izmaksas','A','E','IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8240','IlgtermiÃa aizdevumu procentu samaksa','A','E','IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8260','SamaksÃtÃs soda naudas un lÃgumsodi','A','E','IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8270','ZaudÃjumi no Ãrzemju valÃtas pirkÃanas un pÃrdoÃanas','A','E','IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8290','Citi izdevumi','A','E','IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('83','ÃrkÃrtas ieÃÃmumi','H','I','IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8310','ÃrkÃrtas ieÃÃmumi','A','I','IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('84','ÃrkÃrtas izdevumi','H','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8410','ÃrkÃrtas izdevumi','A','E','IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('86','PeÃÃa vai zaudÃjumi','H','I','IC_income:IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8610','PeÃÃa vai zaudÃjumi','A','I','IC_income:IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3220','PrivÃtie ieguldÃjumi','A','Q','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6110','IeÃÃmumi no pamatdarbÃbas  produkcijas un pakalpojumu pÃrdoÃanas','A','I','AR_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1220','TehnoloÃiskÃs  iekÃrtas un maÃÃnas','A','A','IC','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1240','PamatlÃdzekÃu izveidoÃana un nepabeigto celtniecÃbas objektu izmaksas','A','A','IC','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1320','Aizdevumi meitas uzÃÃmumam','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2110','Izejvielas un materiÃli','A','A','AP','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2190','Avansa maksÃjumi par precÃm','A','A','AR','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1130','UzÃÃmuma nemateriÃlÃ vÃrtÃba','A','A','IC','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1180','Avansa maksÃjumi par nemateriÃliem aktÃviem','A','A','IC','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1190','NemateriÃlo ieguldÃjumu vÃrtÃbas norakstÃtÃ daÃa (pasÃvÃ)','A','A','IC','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('22','ProduktÃvie un darba dzÃvnieki','H','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2230','Darba lopi','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2290','Darba lopu norakstÃtÃ vÃrtÃba (pasÃvÃ)','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2360','NorÃÃini par parakstÃtÃ sabiedrÃbas kapitÃlÃ neiemaksÃtÃm summÃm','A','A','AR_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('24','NÃkamo periodu izdevumi','H','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2620','NorÃÃinu konti bankÃ','A','A','AR_paid:AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3110','PamatkapitÃls vai lÃdzdalÃbas kapitÃls','A','Q','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('55','NorÃÃini ar uzÃÃmumiem, dalÃbniekiem un personÃlu','H','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('56','NorÃÃini  par darba samaksu  un ieturÃjumiem (izÃemot nodokÃus)','H','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5610','NorÃÃini par darba algu','A','E','AP_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5620','NorÃÃini par ieturÃjumiem no darba algas (izÃemot nodokÃus)','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5820','NorÃÃini par iepriekÃÃjo gadu neizmaksÃtajÃm dividendÃm','A','L','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5810','NorÃÃini par pÃrskata gada dividendÃm','A','L','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5910','NÃkamo periodu ieÃÃmumi','A','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6','IeÃÃmumi no uzÃÃmuma saimnieciskÃs darbÃbas','H','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6210','Ar nodokÃiem neapliekamie pÃrdoÃanas ieÃÃmumi','A','I','AR_amount:IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6430','PieÃÃirtie rabati un citas tirdzniecÃbas  atlaides','A','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6910','DzÃvokÃu saimniecÃbas ieÃÃmumi','A','I','AR_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7180','PÃrÃjie materiÃlie izdevumi (nodoklis par dabas resursu izmantoÃanu, celmu nauda u.c.)','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7240','PÃrÃjÃs personÃla izmaksas','A','E','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7220','PÃrvaldes personÃla un administratÃvÃ personÃla algas','A','E','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7420','PamatlÃdzekÃu nolietojums','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7570','KomandÃjuma izdevumi','A','E','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7930','SadzÃves pakalpojumu izdevumi','A','E','IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7960','MedicÃniskÃs apkalpoÃanas izdevumi','A','E','IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7970','KultÃras un sporta iestÃÃu un pasÃkumu izdevumi','A','E','IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8140','Ziedojumi un citi tiem pielÃdzinÃmi ieÃÃmumi','A','I','IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8250','ZaudÃjumi no valÃtu  kursa pazeminÃÃanÃs','A','E','IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7980','PÃrÃjie sociÃlÃs infrastruktÃras uzturÃÃanas izdevumi','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('87','PeÃÃas izlietojums (bez nodokÃiem)','H','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('88','NodoÃi no peÃÃas un citi saimnieciskÃs darbÃbas izdevumos neiekÃaujamie nodokÃi','H','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1110','PÃtniecÃbas un uzÃÃmuma attÃstÃbas izmaksas','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1120','Koncesijas, patenti, licences, tirdzniecÃbas zÃmes un lÃdzÃgas tiesÃbas; datoru programmas','A','A','IC','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1230','PÃrÃjie pamatlÃdzekÃi un inventÃrs','A','A','IC','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5710','NorÃÃini par peÃÃas nodokli','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2390','PÃrmaksÃtie nodokÃi, iepriekÃ samaksÃtie nodokÃi','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4210','UzkrÃjumi paredzamiem nodokÃiem','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5720','NorÃÃini par citiem nodokÃiem, nodevÃm un maksÃjumiem budÃetam','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7310','SociÃlais nodoklis','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8710','PeÃÃas izlietojums','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8830','Nodoklis par zemi','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8840','Citi saimnieciskÃs darbÃbas izmaksÃs neiekÃaujamie nodokÃi','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8820','Nodoklis par dabas resursu izmantoÃanu no peÃÃas  maksÃjamÃ daÃÃ','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8810','Nodoklis no peÃÃas','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1330','LÃdzdalÃbas saistÃto uzÃÃmumu kapitÃlÃ','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2354','PVN samaksÃts 18%','A','E','AP_tax:IC_taxpart:IC_taxservice','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2352','PVN ieÃemtais 18%','A','L','AR_tax:IC_taxpart:IC_taxservice','');
---
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart where accno = '2352'),'0.18','');
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart where accno = '2354'),'0.18','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart where accno = '2353'),'0.21','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart where accno = '2355'),'0.21','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart where accno = '57211'),'0.18','');
+INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart where accno = '57213'),'0.21','');
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1230'));
 
@@ -265,3 +331,5 @@
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 
 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:[2881] trunk
Next by Date: SF.net SVN: ledger-smb:[2883] trunk
Previous by thread: SF.net SVN: ledger-smb:[2881] trunk
Next by thread: SF.net SVN: ledger-smb:[2883] trunk
Index(es):
- Date
- Thread