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

Subject: SF.net SVN: ledger-smb:[2652] trunk/sql/coa
From: ..hidden..
Date: Fri, 12 Jun 2009 02:26:49 +0000
Revision: 2652
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2652&view=rev
Author:   einhverfr
Date:     2009-06-12 02:26:49 +0000 (Fri, 12 Jun 2009)

Log Message:
-----------
Dutch chart conversions

Modified Paths:
--------------
    trunk/sql/coa/lv/chart/General.sql
    trunk/sql/coa/nl/chart/General.sql

Modified: trunk/sql/coa/lv/chart/General.sql
===================================================================
--- trunk/sql/coa/lv/chart/General.sql	2009-06-12 02:24:48 UTC (rev 2651)
+++ trunk/sql/coa/lv/chart/General.sql	2009-06-12 02:26:49 UTC (rev 2652)
@@ -4,248 +4,248 @@
 -- Sept. 14, 2003
 -- checked and edited Sept. 20, 2003, D. Simader
 --
-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','');
+SELECT account_heading_save(NULL, '1', 'IlgtermiÃa ieguldÃjumi', NULL);
+SELECT account_heading_save(NULL, '2', 'ApgrozÃmie lÃdzekÃi', NULL);
+SELECT account_heading_save(NULL, '11', 'NemateriÃlie ieguldÃjumi', NULL);
+SELECT account_heading_save(NULL, '12', 'PamatlÃdzekÃi', NULL);
+SELECT account_save(NULL,'1210','Zemes gabali, Ãkas, bÃves, ilggadÃgie stÃdÃjumi un citi nekustamÃ ÃpaÃuma objekti','','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1290','PamatlÃdzekÃu nolietojums (pasÃvÃ)','','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_heading_save(NULL, '13', 'IlgtermiÃa finansu ieguldÃjumi', NULL);
+SELECT account_heading_save(NULL, '21', 'KrÃjumi', NULL);
+SELECT account_save(NULL,'2130','GatavÃs preces pÃrdoÃanai','','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'2310','NorÃÃini ar pircÃjiem un pasÃtÃtÃjiem','','L', NULL, false,string_to_array('AP', ':'));
+SELECT account_heading_save(NULL, '23', 'NorÃÃini par prasÃbÃm (ar debitoriem)', NULL);
+SELECT account_save(NULL,'2350','NorÃÃini ar citiem debitoriem','','A', NULL, false,string_to_array('AR_amount', ':'));
+SELECT account_heading_save(NULL, '26', 'Naudas lÃdzekÃi', NULL);
+SELECT account_save(NULL,'2610','Kase','','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1380','Aizdevumi uzÃÃmuma dalÃbniekiem un valdei','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1310','LÃdzdalÃba meitas uzÃÃmumu kapitÃlÃ','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1340','Aizdevumi saistÃtajiem uzÃÃmumiem','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1350','PÃrÃjie vÃrtspapÃri','','A', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '5', 'Kreditori', NULL);
+SELECT account_save(NULL,'1370','PaÃu akcijas un daÃas','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2210','PieauguÃie produktÃvie lopi','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3350','StatÃtos paredzÃtÃs rezerves','','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2220','Jaunlopi un sÃkie dzÃvnieki','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2320','Par piegÃdÃm un pasÃtÃjumiem saÃemtie vekseÃi','','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'2140','Nepabeigtie pasÃtÃjumi','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2370','ÃstermiÃa aizdevumi sabiedrÃbÃm dalÃbniekiem un vadÃbai','','A', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'1360','PÃrÃjie aizdevumi','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2120','Nepabeigtie raÃojumi','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2330','Meitas uzÃÃmumu parÃdi','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2340','SaistÃto uzÃÃmumu parÃdi','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2380','NorÃÃini par prasÃbÃm pret personÃlu un ÃstermiÃa aizdevumi personÃlam','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2410','NÃkamo periodu izdevumi','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2420','Akciju emisijas  nocenojums (disagio)','','A', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '25', 'VÃrtspapÃri apgrozÃmo lÃdzekÃu sastÃvÃ un ÃstermiÃa lÃdzdalÃba kapitÃlos', NULL);
+SELECT account_save(NULL,'2510','Meitas  uzÃÃmuma akcijas un daÃas ','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2520','SaistÃto uzÃÃmuma akcijas un daÃas ','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2530','PaÃu  uzÃÃmuma akcijas un daÃas ','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2540','PÃrÃjie vÃrtspapÃri un lÃdzdalÃba kapitÃlos','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2640','AkreditÃvi, Ãeki un ÃpaÃu norÃÃina  formu konti','','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'2650','Citi konti bankÃs','','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'2670','PÃrÃjie naudas lÃdzekÃi','','A', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '3', 'PaÃu kapitÃls', NULL);
+SELECT account_save(NULL,'3130','IlgtermiÃa ieguldÃjuma pÃrvÃrtÃÃanas rezerve','','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3120','Akciju emisijas uzcenojums (agio)','','Q', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '32', 'PrivÃtkonti', NULL);
+SELECT account_save(NULL,'3210','PrivÃtiem nolÃkiem izÃemtie lÃdzekÃi','','Q', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '33', 'Rezerves ', NULL);
+SELECT account_save(NULL,'3310','Rezerves kapitÃls','','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3330','Citas likumÃ paredzÃtÃs  rezerves','','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3340','Rezerves paÃu akcijÃm un daÃÃm','','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3360','PÃrÃjÃs rezerves','','Q', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '34', 'NesadalÃtÃ peÃÃa vai nesegtie zaudÃjumi', NULL);
+SELECT account_save(NULL,'3410','PÃrskata gada nesadalÃtÃ peÃÃa','','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3420','IepriekÃÃjo gadu nesadalÃtÃ peÃÃa','','Q', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '4', 'UzkrÃjumi', NULL);
+SELECT account_save(NULL,'4110','UzkrÃjumi pensijÃm pielÃdzinÃtÃm saistÃbÃm','','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4310','Citi uzkrÃjumi','','L', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '41', 'UzkrÃjumi pensijÃm pielÃdzinÃmÃtÃm saistÃbÃm', NULL);
+SELECT account_heading_save(NULL, '43', 'Citi uzkrÃjumi', NULL);
+SELECT account_heading_save(NULL, '42', 'UzkrÃjumi paredzamiem nodokÃiem', NULL);
+SELECT account_heading_save(NULL, '51', 'NorÃÃini par aizÃÃmumiem', NULL);
+SELECT account_save(NULL,'5110','AizÃÃmumi pret obligÃcijÃm','','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5120','AkcijÃs pÃrvÃÃamie aizÃÃmumi','','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5130','AizÃÃmumi ar lÃdzdalÃbu peÃÃÃ','','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5140','Citi aizÃÃmumi','','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5150','ÃstermiÃa aizÃÃmumi  no kredÃtiestÃdÃm','','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5160','IlgtermiÃa aizÃÃmumi no kredÃtiestÃdÃm','','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5170','AizÃÃmumi no kredÃtiestÃdÃm bez norÃdÃtÃ termiÃa','','L', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '52', 'NorÃÃini par saÃemtajiem avansiem', NULL);
+SELECT account_save(NULL,'5210','NorÃÃini par saÃemtiem avansiem','','L', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '54', 'MaksÃjamie vekseÃi', NULL);
+SELECT account_heading_save(NULL, '53', 'NorÃÃini par piegÃdÃtÃjiem un darbuzÃÃmÃjiem', NULL);
+SELECT account_save(NULL,'5310','NorÃÃini par piegÃdÃtÃjiem un darbuzÃÃmÃjiem','','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5410','NorÃÃini par paÃu izdotajiem vekseÃiem','','L', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'5510','NorÃÃini par parÃdiem meitas uzÃÃmumiem','','L', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'5540','NorÃÃini par parÃdiem citiem uzÃÃmumiem un dalÃbniekiem','','L', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'5550','NorÃÃini par parÃdiem personÃlam','','L', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'5520','NorÃÃini par parÃdiem saistÃtiem uzÃÃmumiem','','L', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'5530','NorÃÃini par parÃdiem uzÃÃmumiem, ar kuriem ir lÃgums par lÃdzdalÃbu','','L', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_heading_save(NULL, '57', 'NorÃÃini par nodokÃiem', NULL);
+SELECT account_heading_save(NULL, '58', 'NorÃÃini par  dividendÃm', NULL);
+SELECT account_heading_save(NULL, '61', 'IeÃÃmumi no pÃrdoÃanas, kas apliekami ar nodokÃiem vispÃrÃjÃ kÃrtÃbÃ', NULL);
+SELECT account_heading_save(NULL, '62', 'IeÃÃmumi no pÃrdoÃanas, kas citÃdi  apliekami ar nodokÃiem', NULL);
+SELECT account_save(NULL,'6220','Ar ÃpaÃiem nodokÃiem apliekamie pÃrdoÃanas ieÃÃmumi','','I', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_heading_save(NULL, '63', 'Komisijas, starpniecÃbas un citi ieÃÃmumi', NULL);
+SELECT account_save(NULL,'6310','Komisijas un starpniecÃbas ieÃÃmumi','','I', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'6320','IeÃÃmumi no atkritumu pÃrstrÃdes un realizÃcijas','','I', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'6330','IeÃÃmumi no taras realizÃcijas','','I', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'6340','Ar nodokÃiem neapliekamie apgrozÃjumi','','I', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_heading_save(NULL, '64', 'IeÃÃmumus samazinoÃas atlaides', NULL);
+SELECT account_save(NULL,'6410','PieÃÃirtÃs skonto atlaides','','I', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'6420','PieÃÃirtie bonusi','','I', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '59', 'NÃkamo periodu ieÃÃmumi', NULL);
+SELECT account_heading_save(NULL, '65', 'PÃrÃjie uzÃÃmuma ieÃÃmumi', NULL);
+SELECT account_save(NULL,'6510','IeÃÃmumi no vÃrtspapÃru kursa paaugstinÃÃanÃs','','I', NULL, false,string_to_array('AR_amount', ':'));
+SELECT account_save(NULL,'6530','IeÃÃmumi no zemes gabalu iznomÃÃanas','','I', NULL, false,string_to_array('AR_amount', ':'));
+SELECT account_save(NULL,'6540','IeÃÃmumi no apgrozÃmo lÃdzekÃu pÃrdoÃanas','','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6550','IeÃÃmumi no pamatlÃdzekÃu iznomÃÃanas','','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6560','IeÃÃmumos pÃrskaitÃtais rezervju un uzkrÃjumu samazinÃjums','','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6570','IepriekÃÃjo gadu nodokÃu samazinÃjums','','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6580','Papildus  ieguldÃjumi un citi ieÃÃmumi','','I', NULL, false,string_to_array('AR_amount', ':'));
+SELECT account_save(NULL,'6590','PaÃu uzÃÃmuma kapitÃlieguldÃjumiem izpildÃtie darbi','','I', NULL, false,string_to_array('AR_amount', ':'));
+SELECT account_heading_save(NULL, '67', 'Citu periodu ieÃÃmumi, kas attiecas uz pÃrskata periodu', NULL);
+SELECT account_save(NULL,'6710','Citu periodu ieÃÃmumi, kas attiecas uz pÃrskata periodu','','I', NULL, false,string_to_array('AR_amount', ':'));
+SELECT account_heading_save(NULL, '69', 'SociÃlÃs infrastruktÃras iestÃÃu un pasÃkumu ieÃÃmumi', NULL);
+SELECT account_save(NULL,'6930','SadzÃves paklpojumu ieÃÃmumi','','I', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'6920','KomunÃlÃs  saimniecÃbas ieÃÃmumi','','I', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_heading_save(NULL, '66', 'GatavÃs produkcijas  un nepabeigto  raÃojumu krÃjumu un vÃrtÃbas  izmaiÃas', NULL);
+SELECT account_save(NULL,'6610','GatavÃs produkcijas krÃjumu un vÃrtÃbas izmaiÃas','','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6620','Nepabeigto raÃojumu krÃjumu un vÃrtÃbas  izmaiÃas','','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6630','Nepabeigto pasÃtÃjumu atlikumu un vÃtÃbas izmaiÃas','','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6640','ProduktÃvo  un darba dzÃvnieku ganÃmpulka vÃrtÃbas izmaiÃas','','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6940','SabiedriskÃs ÃdinÃÃanas ieÃÃmumi','','I', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'6950','IzglÃtÃbas iestÃÃu ieÃÃmumi','','I', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'6960','MedicÃnas iestÃÃu ieÃÃmumi','','I', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'6970','KultÃras un sporta ietÃÃu un pasÃkumu ieÃÃmumi','','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6980','PÃrÃjie sociÃlÃs infrastruktÃras iestÃÃu un pasÃkumu ieÃÃmumi','','I', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '7', 'SaimnieciskÃs darbÃbas izdevumi', NULL);
+SELECT account_heading_save(NULL, '71', 'Izdevumi izejvielu, materiÃlu un preÃu iepirkÃanai', NULL);
+SELECT account_save(NULL,'7110','Izejvielu un materiÃlu iepirkÃanas un piegÃdes izdevumi','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'7120','PreÃu iepirkÃanas un piegÃdes izdevumi','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'7130','SaÃemtÃs atlaides','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'7140','Taras izdevumi','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'7150','Muitas un ievednodevas','','E', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'7160','PÃrÃjie ÃrÃjie izdevumi','','E', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'7170','Samaksa par darbiem un pakalpojumiem no Ãrienes','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'7190','Pirkto materiÃlu un preÃu krÃjumu un vÃrtÃbas izmaiÃas','','E', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '72', 'PersonÃla izmaksas', NULL);
+SELECT account_save(NULL,'7210','StrÃdnieku algas','','E', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'7230','SociÃlÃs  infrastruktÃras  iestÃÃu un pasÃkumu darbinieku algas','','E', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '73', 'SociÃlÃs nodevas un izmaksas', NULL);
+SELECT account_save(NULL,'7320','PÃrÃjÃs sociÃlÃs izmaksas','','E', NULL, false,string_to_array('AP_tax', ':'));
+SELECT account_heading_save(NULL, '74', 'PamatlÃdzekÃu nolietojums un citu ieguldÃjumu vÃrtÃbas norakstÃjumi', NULL);
+SELECT account_save(NULL,'7410','NemateriÃlo ieguldÃjumu vÃrtÃbas norakstÃÃana','','E', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '75', 'PÃrÃjie saimnieciskÃs darbÃbas  izdevumi', NULL);
+SELECT account_save(NULL,'7510','Dabas aizsardzÃbas izdevumi','','E', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'7530','Nodevas par raÃoÃanÃ izmantotiem zemes gabaliem','','E', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'7440','ApgrozÃmo lÃdzekÃu vÃrtÃbas norakstÃÃana','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'7540','ApdroÃinnÃÃanas maksÃjumi (izÃemot darbinieku apdroÃinÃÃanu)','','E', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'7550','PÃrÃjie saimnieciskÃs darbÃbas izdevumi','','E', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'7560','StrÃdnieku vervÃÃanas un apmÃcÃbas izdevumi','','E', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_heading_save(NULL, '76', 'PreÃu pÃrdoÃanas izdevumi', NULL);
+SELECT account_save(NULL,'7610','IesaiÃojamais materiÃls, tara','','E', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'7620','PreÃu transporta izdevumi','','E', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'7630','PreÃu transporta apdroÃinÃÃana','','E', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'7640','SamaksÃtÃs komisijas naudas','','E', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'7650','Citi pÃrdoÃanas izdevumi','','E', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_heading_save(NULL, '77', 'AdministrÃcijas izdevumi', NULL);
+SELECT account_save(NULL,'7710','Sakaru izdevumi','','E', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'7720','Kantora (biroja) izdevumi','','E', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'7730','Juristu pakalpojumu apmaksa','','E', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'7740','Gada pÃrskata un revÃzijas izdevumi','','E', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'7750','Naudas apgrozÃjuma blakus izdevumi','','E', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'7760','Transporta izdevumi administrÃcijas vajadzÃbÃm','','E', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'7770','Citi vadÃÃanas un administrÃcijas izdevumi','','E', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_heading_save(NULL, '78', 'PÃrskata periodÃ iekÃaujamie iepriekÃÃjo periodu izdevumi', NULL);
+SELECT account_save(NULL,'7810','PÃrskata periodÃ iekÃaujamie iepriekÃÃjo periodu izdevumi','','E', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_heading_save(NULL, '79', 'SociÃlÃs  infrastruktÃras uzturÃÃanas izdevumi', NULL);
+SELECT account_save(NULL,'7920','KomuÃlÃs saimniecÃbas izdevumi','','E', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'7940','SabiedriskÃs ÃdinÃÃanas izdevumi','','E', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'7950','IzglÃtÃbas iestÃÃu izdevumi','','E', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_heading_save(NULL, '8', 'DaÃÃdi ieÃÃmumi un izdevumi, peÃÃa un zaudÃjumi', NULL);
+SELECT account_heading_save(NULL, '81', 'DaÃÃdi ieÃÃmumi', NULL);
+SELECT account_save(NULL,'8110','IeÃÃmumi no lÃdzdalÃbas, vÃrtspapÃriem un aizdevumiem','','I', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'8120','PÃrÃjie ieÃÃmumi no procentiem un tiem pielÃdzinÃmi ieÃÃmumi','','I', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'7910','DzÃvokÃu saimniecÃbas izdevumi','','E', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'8130','VekseÃu diskonta ieÃÃmumi','','I', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'8150','IenÃkumi no valÃtas kursa paaugstinÃÃanÃs','','I', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'8160','SaÃemtÃs soda naudas un lÃgumsodi','','I', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'8170','PeÃÃa no Ãrzemju valÃtas pÃrdoÃanas vai pirkÃanas','','I', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'8190','Citi ieÃÃmumi','','I', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_heading_save(NULL, '82', 'DaÃÃdi izdevumi', NULL);
+SELECT account_save(NULL,'8210','ÃstermiÃa finansu ieguldÃjumu vÃrtÃbas norakstÃÃana','','E', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'8220','SamaksÃtie procenti un tiem pielÃdzinÃmie izdevumi','','E', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'8230','VekseÃu diskonta izmaksas','','E', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'8240','IlgtermiÃa aizdevumu procentu samaksa','','E', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'8260','SamaksÃtÃs soda naudas un lÃgumsodi','','E', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'8270','ZaudÃjumi no Ãrzemju valÃtas pirkÃanas un pÃrdoÃanas','','E', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'8290','Citi izdevumi','','E', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_heading_save(NULL, '83', 'ÃrkÃrtas ieÃÃmumi', NULL);
+SELECT account_save(NULL,'8310','ÃrkÃrtas ieÃÃmumi','','I', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_heading_save(NULL, '84', 'ÃrkÃrtas izdevumi', NULL);
+SELECT account_save(NULL,'8410','ÃrkÃrtas izdevumi','','E', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_heading_save(NULL, '86', 'PeÃÃa vai zaudÃjumi', NULL);
+SELECT account_save(NULL,'8610','PeÃÃa vai zaudÃjumi','','I', NULL, false,string_to_array('IC_income:IC_expense', ':'));
+SELECT account_save(NULL,'3220','PrivÃtie ieguldÃjumi','','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6110','IeÃÃmumi no pamatdarbÃbas  produkcijas un pakalpojumu pÃrdoÃanas','','I', NULL, false,string_to_array('AR_paid', ':'));
+SELECT account_save(NULL,'1220','TehnoloÃiskÃs  iekÃrtas un maÃÃnas','','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1240','PamatlÃdzekÃu izveidoÃana un nepabeigto celtniecÃbas objektu izmaksas','','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1320','Aizdevumi meitas uzÃÃmumam','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2110','Izejvielas un materiÃli','','A', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'2190','Avansa maksÃjumi par precÃm','','A', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'1130','UzÃÃmuma nemateriÃlÃ vÃrtÃba','','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1180','Avansa maksÃjumi par nemateriÃliem aktÃviem','','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1190','NemateriÃlo ieguldÃjumu vÃrtÃbas norakstÃtÃ daÃa (pasÃvÃ)','','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_heading_save(NULL, '22', 'ProduktÃvie un darba dzÃvnieki', NULL);
+SELECT account_save(NULL,'2230','Darba lopi','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2290','Darba lopu norakstÃtÃ vÃrtÃba (pasÃvÃ)','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2360','NorÃÃini par parakstÃtÃ sabiedrÃbas kapitÃlÃ neiemaksÃtÃm summÃm','','A', NULL, false,string_to_array('AR_paid', ':'));
+SELECT account_heading_save(NULL, '24', 'NÃkamo periodu izdevumi', NULL);
+SELECT account_save(NULL,'2620','NorÃÃinu konti bankÃ','','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'3110','PamatkapitÃls vai lÃdzdalÃbas kapitÃls','','Q', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '55', 'NorÃÃini ar uzÃÃmumiem, dalÃbniekiem un personÃlu', NULL);
+SELECT account_heading_save(NULL, '56', 'NorÃÃini  par darba samaksu  un ieturÃjumiem (izÃemot nodokÃus)', NULL);
+SELECT account_save(NULL,'5610','NorÃÃini par darba algu','','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5620','NorÃÃini par ieturÃjumiem no darba algas (izÃemot nodokÃus)','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5820','NorÃÃini par iepriekÃÃjo gadu neizmaksÃtajÃm dividendÃm','','L', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'5810','NorÃÃini par pÃrskata gada dividendÃm','','L', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'5910','NÃkamo periodu ieÃÃmumi','','I', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '6', 'IeÃÃmumi no uzÃÃmuma saimnieciskÃs darbÃbas', NULL);
+SELECT account_save(NULL,'6210','Ar nodokÃiem neapliekamie pÃrdoÃanas ieÃÃmumi','','I', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'6430','PieÃÃirtie rabati un citas tirdzniecÃbas  atlaides','','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6910','DzÃvokÃu saimniecÃbas ieÃÃmumi','','I', NULL, false,string_to_array('AR_paid', ':'));
+SELECT account_save(NULL,'7180','PÃrÃjie materiÃlie izdevumi (nodoklis par dabas resursu izmantoÃanu, celmu nauda u.c.)','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'7240','PÃrÃjÃs personÃla izmaksas','','E', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'7220','PÃrvaldes personÃla un administratÃvÃ personÃla algas','','E', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'7420','PamatlÃdzekÃu nolietojums','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'7570','KomandÃjuma izdevumi','','E', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'7930','SadzÃves pakalpojumu izdevumi','','E', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'7960','MedicÃniskÃs apkalpoÃanas izdevumi','','E', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'7970','KultÃras un sporta iestÃÃu un pasÃkumu izdevumi','','E', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'8140','Ziedojumi un citi tiem pielÃdzinÃmi ieÃÃmumi','','I', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'8250','ZaudÃjumi no valÃtu  kursa pazeminÃÃanÃs','','E', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'7980','PÃrÃjie sociÃlÃs infrastruktÃras uzturÃÃanas izdevumi','','E', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '87', 'PeÃÃas izlietojums (bez nodokÃiem)', NULL);
+SELECT account_heading_save(NULL, '88', 'NodoÃi no peÃÃas un citi saimnieciskÃs darbÃbas izdevumos neiekÃaujamie nodokÃi', NULL);
+SELECT account_save(NULL,'1110','PÃtniecÃbas un uzÃÃmuma attÃstÃbas izmaksas','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1120','Koncesijas, patenti, licences, tirdzniecÃbas zÃmes un lÃdzÃgas tiesÃbas; datoru programmas','','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1230','PÃrÃjie pamatlÃdzekÃi un inventÃrs','','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'5710','NorÃÃini par peÃÃas nodokli','','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2390','PÃrmaksÃtie nodokÃi, iepriekÃ samaksÃtie nodokÃi','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4210','UzkrÃjumi paredzamiem nodokÃiem','','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5720','NorÃÃini par citiem nodokÃiem, nodevÃm un maksÃjumiem budÃetam','','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'7310','SociÃlais nodoklis','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'8710','PeÃÃas izlietojums','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'8830','Nodoklis par zemi','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'8840','Citi saimnieciskÃs darbÃbas izmaksÃs neiekÃaujamie nodokÃi','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'8820','Nodoklis par dabas resursu izmantoÃanu no peÃÃas  maksÃjamÃ daÃÃ','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'8810','Nodoklis no peÃÃas','','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1330','LÃdzdalÃbas saistÃto uzÃÃmumu kapitÃlÃ','','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2354','PVN samaksÃts 18%','','E', NULL, false,string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'2352','PVN ieÃemtais 18%','','L', NULL, false,string_to_array('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','');

Modified: trunk/sql/coa/nl/chart/General.sql
===================================================================
--- trunk/sql/coa/nl/chart/General.sql	2009-06-12 02:24:48 UTC (rev 2651)
+++ trunk/sql/coa/nl/chart/General.sql	2009-06-12 02:26:49 UTC (rev 2652)
@@ -20,209 +20,209 @@
 -- operations is recorded (tax, donations, that kind of thing. Finally the 9999 account is used to kick the result to retained earnings and
 -- related accounts in the balance sheet, and we are ready for the next year
 --
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0000','Vaste Activa & Eigen Vermogen','H','0000','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0010','Terreinen','A','0010','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0015','Afschrijving Terreinen','A','0015','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0200','Gebouwen','A','0200','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0205','Afschrijving Gebouwen','A','0205','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0230','Inventaris','A','0230','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0235','Afschrijving Inventaris','A','0235','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0240','Computers','A','0240','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0245','Afschrijving Computers','A','0245','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0250','Auto','A','0250','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0255','Afschrijving Auto','A','0255','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0260','Machines','A','0260','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0265','Afschrijving Machines','A','0265','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0290','Goodwill','A','0290','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0295','Afschrijving Goodwill','A','0295','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0370','Overige Leningen u/g','A','0370','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0380','Aandelen & Effecten','A','0380','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0381','Beleggingen Spaarbeleg','A','0381','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0390','Beleggingen Legiolease','A','0390','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0400','Aandelenkapitaal','A','0400','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0410','Aandelen in portefeuille','A','0410','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0420','Aandelen uit te reiken','A','0420','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0430','Agioreserve','A','0430','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0440','Winstreserve','A','0440','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0450','Herwaarderingsreserve','A','0450','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0470','Oprichtingskosten','A','0470','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0480','Winst na belasting lopend jaar','A','0480','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0500','Eigen Vermogen','A','0500','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0510','Prive','A','0510','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0550','Onverdeeld Resultaat','A','0550','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0600','Voorziening Onderhoud','A','0600','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0610','Voorziening Garantie','A','0610','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0620','Voorziening Assurantie','A','0620','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0630','Voorziening Debiteuren','A','0630','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0700','Obligatielening','A','0700','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0710','Obligaties in portefeuille','A','0710','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0720','Converteerbare Obligatielening','A','0720','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0730','Agio op Obligaties','A','0730','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0740','Disagio op Obligaties','A','0740','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0800','Hypothecaire lening o/g','A','0800','L','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1000','Financiele Rekeningen','H','1000','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1001','Kas','A','1001','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1050','Contante Verkopen','A','1050','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1100','Interbank','A','1100','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1110','ABN-AMRO','A','1110','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1119','Postbank Plus','A','1119','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1120','Postbank Giro','A','1120','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1121','Postbank Kapitaal','A','1121','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1122','Postbank Leeuw','A','1122','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1139','Postbank Effectenrekening','A','1139','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1140','Rabobank','A','1140','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1141','Rabobank Rendementrekening','A','1141','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1160','van Lanschotbank','A','1160','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1170','Finansbank','A','1170','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1180','VISA Creditcard','A','1180','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1190','Kruisposten','A','1190','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1200','Debiteuren','A','1200','A','AR');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1205','Dubieuze Debiteuren','A','1205','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1321','Rekening Courant < A','A','1321','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1322','Rekening Courant < B','A','1322','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1340','Goederen ontvangen / GO','A','1340','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1500','Te betalen loonheffing','A','1500','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1520','Te betalen Sociale Lasten','A','1520','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1530','Te betalen Pensioenpremies','A','1530','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1600','Crediteuren','A','1600','L','AP');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1605','Nog te Ontvangen Facturen / NOF','A','1605','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1610','Te betalen tantiemes','A','1610','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1615','Te betalen Vennootschapsbelasting','A','1615','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1620','Interimdividend','A','1620','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1630','Te betalen dividend','A','1630','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1640','Te betalen dividendbelasting','A','1640','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1650','Aandeelhouders nog te storten','A','1650','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1700','Te betalen interest','A','1700','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1710','Te betalen coupons','A','1710','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1770','Uitgelote obligaties','A','1770','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1800','Te vorderen BTW hoog','A','1800','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1801','Te vorderen BTW laag','A','1801','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1810','Te betalen BTW hoog','A','1810','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1811','Te betalen BTW laag','A','1811','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1850','Saldo BTW','A','1850','L','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1941','Rekening Courant > A','A','1941','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1942','Rekening Courant > B','A','1942','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1960','Vooruitbetaalde bedragen','A','1960','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1970','Vooruitontvangen bedragen','A','1970','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1980','Nog te ontvangen bedragen','A','1980','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('1990','Nog te betalen bedragen','A','1990','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('2000','Tussenrekeningen','H','2000','L','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('2100','Vraagposten','A','2100','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('2400','Onbekende betalingen','A','2400','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('2800','Tussenrekening Lonen','A','2800','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('2900','Tussenrekening Beginbalans','A','2900','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('3000','Voorraad Grond- en Hulpstoffen','H','3000','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('3010','Voorraad Grondstof A','A','3010','A','IC');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4000','Kostenrekeningen','H','4000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4001','Verbruik Grondstoffen','A','4001','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4100','Directe Loonkosten','A','4100','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4110','Indirecte Loonkosten','A','4110','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4120','Sociale Lasten','A','4120','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4130','Kosten Pensioenen','A','4130','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4190','Overige Personeelskosten','A','4190','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4200','Kosten externe medewerkers','A','4200','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4210','Kosten Personeelsuitjes','A','4210','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4220','Kantinekosten','A','4220','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4240','Lief en Leedpot externe medewerkers','A','4240','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4300','Afschrijvingskosten Gebouwen','A','4300','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4330','Afschrijvingskosten Inventaris','A','4330','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4340','Afschrijvingskosten Computers','A','4340','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4350','Afschrijvingskosten Autos','A','4350','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4360','Afschrijvingskosten Machines','A','4360','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4390','Afschrijvingskosten Goodwill','A','4390','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4400','Huurkosten','A','4400','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4410','Asurantiekosten','A','4410','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4520','Gas, Licht & Water','A','4520','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4530','Vaste Lasten','A','4530','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4540','Reparatie- & Onderhoudskosten','A','4540','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4560','Verzekering en Beveiliging Pand','A','4560','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4600','Directe Verkoopkosten','A','4600','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4650','Indirecte Verkoopkosten','A','4650','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4730','Relatiegeschenken','A','4730','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4740','Reis en Verblijfkosten','A','4740','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4800','Kasverschillen','A','4800','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4810','Voorraadverschillen','A','4810','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4900','Telefoon & Faxkosten','A','4900','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4910','Contributies & Abonnementen','A','4910','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4920','Verzekeringen Algemeen','A','4920','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4930','Kantoorartikelen','A','4930','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4931','Kantoorbenodigdheden','A','4931','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4932','Vakliteratuur','A','4932','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4940','Licenties & Software','A','4940','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4941','Administratie & Acountantskosten','A','4941','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4943','Notaris & Advocaatkosten','A','4943','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4950','Drukwerk & Papier','A','4950','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4970','Porti','A','4970','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4980','Bankkosten','A','4980','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4981','Bankprovisie Effectenhandel','A','4981','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4990','Overige Algemene Kosten','A','4990','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4991','Bijzondere baten en lasten','A','4991','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('4999','Overboekingsrekening Rubriek 4','A','4999','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('5000','Verdeling Indirecte Kosten','H','5000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('5400','Indirecte fabricagekosten','A','5400','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('5450','Opslag Indirecte fabricagekosten','A','5450','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('5500','Indirecte verkoopkosten','A','5500','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('5550','Opslag Indirecte verkoopkosten','A','5550','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('5999','Overboekingsrekening Rubriek 5','A','5999','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('6000','Fabricagerekeningen','H','6000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('6001','Verbruik Grondstoffen','A','6001','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('6010','Directe Lonen','A','6010','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('6020','Toeslag Indirecte fabricagekosten','A','6020','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('6101','Standaard Verbruik Grondstoffen','A','6101','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('6110','Standaard Directe Lonen','A','6110','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('6120','Standaard Toeslag Indirecte fabricagekosten','A','6120','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('6999','Overboekingsrekening Rubriek 6','A','6999','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('7000','Voorraden gereed product','H','7000','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('7001','Voorraad A','A','7001','A','IC');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('7002','Voorraad B','A','7002','A','IC');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('7003','Voorraad C','A','7003','A','IC');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('7010','Voorraad Incourante goederen','A','7010','A','IC');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('7015','Afschrijving Incourante goederen','A','7015','L','IC');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('7200','Voorraad Goederen in bewerking','A','7200','A','IC');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('7300','Nog te Ontvangen Goederen / NOG','A','7300','A','IC');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('7350','Nog af te leveren goederen','A','7350','L','IC');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('7400','Prijsverschillen bij inkoop','A','7400','I','IC');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('7999','Overboekingsrekening Rubriek 7','A','7999','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('8000','Rekeningen tbv Verkoopresultaat','H','8000','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('8010','Inkoopkosten algemeen','A','8010','E','AP_amount:IC_cogs:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('8020','Kostprijs Verkopen A','A','8020','E','AP_amount:IC_cogs');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('8030','Kostprijs Verkopen B','A','8030','E','AP_amount:IC_cogs');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('8040','Kostprijs Verkopen C','A','8040','E','AP_amount:IC_cogs');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('8100','Directe Verkoopkosten','A','8100','E','AP_amount:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('8150','Toeslag Indirecte Verkoopkosten','E','8150','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('8300','Kortingen bij Verkoop','A','8300','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('8520','Opbrengst Verkopen A','A','8520','I','AR_amount:IC_sale');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('8530','Opbrengst Verkopen B','A','8530','I','AR_amount:IC_sale');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('8540','Opbrengst Verkopen C','A','8540','I','AR_amount:IC_sale');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('8999','Overboekingsrekening Rubriek 8','A','8999','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9000','Rekeningen tbv Resultatenrekening','H','9000','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9010','Resultaat Indirecte Kosten','A','9010','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9011','Resultaat Fabricage','A','9011','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9012','Resultaat Verkoop','A','9012','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9015','Resultaat Prijsverschillen','A','9015','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9030','Rente bate deposito','A','9030','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9040','Rente bate lening u/g','A','9040','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9050','Rente bate bank','A','9050','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9080','Rente bate Fiscus','A','9080','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9100','Rente last hypothecaire lening','A','9100','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9110','Rente last lening bank','A','9110','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9130','Rente last lening o/g','A','9130','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9150','Rente last bank','A','9150','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9180','Rente last Fiscus','A','9180','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9190','Rente last overig','A','9190','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9200','Ontvangen Dividend (bruto)','A','9200','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9205','Ingehouden Dividendbelasting','A','9205','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9210','Koersresultaat Effecten)','A','9210','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9220','Valutaresultaat','A','9220','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9300','Huuropbrengsten','A','9300','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9400','Resultaat tgv inhaalafschrijvingen','A','9400','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9500','Incidentele Resultaten','A','9500','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9600','Giften en Donaties','A','9600','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9700','Tantiemes','A','9700','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9800','Belasting Lopend Jaar','A','9800','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9810','Belasting Voorgaande Jaren','A','9810','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9900','Vennootschapsbelasting','A','9900','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('9999','Overboekingsrekening','A','9999','I','');
+SELECT account_heading_save(NULL,'0000','Vaste Activa & Eigen Vermogen', NULL));
+SELECT account_save(NULL,'0010','Terreinen','A','0010', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0015','Afschrijving Terreinen','A','0015', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0200','Gebouwen','A','0200', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0205','Afschrijving Gebouwen','A','0205', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0230','Inventaris','A','0230', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0235','Afschrijving Inventaris','A','0235', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0240','Computers','A','0240', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0245','Afschrijving Computers','A','0245', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0250','Auto','A','0250', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0255','Afschrijving Auto','A','0255', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0260','Machines','A','0260', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0265','Afschrijving Machines','A','0265', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0290','Goodwill','A','0290', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0295','Afschrijving Goodwill','A','0295', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0370','Overige Leningen u/g','A','0370', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0380','Aandelen & Effecten','A','0380', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0381','Beleggingen Spaarbeleg','A','0381', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0390','Beleggingen Legiolease','A','0390', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0400','Aandelenkapitaal','Q','0400', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0410','Aandelen in portefeuille','Q','0410', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0420','Aandelen uit te reiken','Q','0420', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0430','Agioreserve','Q','0430', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0440','Winstreserve','Q','0440', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0450','Herwaarderingsreserve','Q','0450', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0470','Oprichtingskosten','Q','0470', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0480','Winst na belasting lopend jaar','Q','0480', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0500','Eigen Vermogen','Q','0500', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0510','Prive','Q','0510', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0550','Onverdeeld Resultaat','Q','0550', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0600','Voorziening Onderhoud','Q','0600', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0610','Voorziening Garantie','Q','0610', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0620','Voorziening Assurantie','Q','0620', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0630','Voorziening Debiteuren','Q','0630', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0700','Obligatielening','Q','0700', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0710','Obligaties in portefeuille','Q','0710', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0720','Converteerbare Obligatielening','Q','0720', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0730','Agio op Obligaties','Q','0730', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0740','Disagio op Obligaties','Q','0740', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0800','Hypothecaire lening o/g','L','0800', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL,'1000','Financiele Rekeningen', NULL));
+SELECT account_save(NULL,'1001','Kas','A','1001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1050','Contante Verkopen','A','1050', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1100','Interbank','A','1100', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1110','ABN-AMRO','A','1110', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1119','Postbank Plus','A','1119', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1120','Postbank Giro','A','1120', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1121','Postbank Kapitaal','A','1121', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1122','Postbank Leeuw','A','1122', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1139','Postbank Effectenrekening','A','1139', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1140','Rabobank','A','1140', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1141','Rabobank Rendementrekening','A','1141', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1160','van Lanschotbank','A','1160', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1170','Finansbank','A','1170', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1180','VISA Creditcard','A','1180', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1190','Kruisposten','A','1190', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1200','Debiteuren','A','1200', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'1205','Dubieuze Debiteuren','A','1205', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1321','Rekening Courant < A','A','1321', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1322','Rekening Courant < B','A','1322', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1340','Goederen ontvangen / GO','A','1340', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1500','Te betalen loonheffing','A','1500', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1520','Te betalen Sociale Lasten','A','1520', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1530','Te betalen Pensioenpremies','A','1530', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1600','Crediteuren','L','1600', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'1605','Nog te Ontvangen Facturen / NOF','A','1605', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1610','Te betalen tantiemes','A','1610', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1615','Te betalen Vennootschapsbelasting','A','1615', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1620','Interimdividend','A','1620', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1630','Te betalen dividend','A','1630', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1640','Te betalen dividendbelasting','A','1640', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1650','Aandeelhouders nog te storten','A','1650', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1700','Te betalen interest','A','1700', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1710','Te betalen coupons','A','1710', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1770','Uitgelote obligaties','A','1770', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1800','Te vorderen BTW hoog','L','1800', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'1801','Te vorderen BTW laag','L','1801', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'1810','Te betalen BTW hoog','L','1810', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'1811','Te betalen BTW laag','L','1811', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'1850','Saldo BTW','L','1850', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1941','Rekening Courant > A','A','1941', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1942','Rekening Courant > B','A','1942', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1960','Vooruitbetaalde bedragen','A','1960', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1970','Vooruitontvangen bedragen','A','1970', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1980','Nog te ontvangen bedragen','A','1980', NULL, false,string_to_array('', ':'));

@@ Diff output truncated at 100000 characters. @@

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:[2651] trunk/sql/coa/it/chart
Next by Date: SF.net SVN: ledger-smb:[2653] trunk/sql/coa
Previous by thread: SF.net SVN: ledger-smb:[2651] trunk/sql/coa/it/chart
Next by thread: SF.net SVN: ledger-smb:[2653] trunk/sql/coa
Index(es):
- Date
- Thread