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

Subject: SF.net SVN: ledger-smb:[3394] trunk/sql/coa/be/chart/General.sql
From: ..hidden..
Date: Thu, 30 Jun 2011 20:48:52 +0000
Revision: 3394
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3394&view=rev
Author:   ehuelsmann
Date:     2011-06-30 20:48:52 +0000 (Thu, 30 Jun 2011)

Log Message:
-----------
Fix loading of CoA file due to function arguments.

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

Modified: trunk/sql/coa/be/chart/General.sql
===================================================================
--- trunk/sql/coa/be/chart/General.sql	2011-06-30 19:27:12 UTC (rev 3393)
+++ trunk/sql/coa/be/chart/General.sql	2011-06-30 20:48:52 UTC (rev 3394)
@@ -4,13 +4,13 @@
 -- verified May 19, 2006
 --
 SELECT account_heading_save(NULL, '000', '', NULL);
-SELECT account_save(NULL,'756000','Produits financiers divers','I','75', NULL, '0',string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'555000','DEX02','A','55', NULL, '0',string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'499200','Compte de repartition NDC - Verdelingsrekening CN','L','', NULL, '0',string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'460','Acomptes reÃus sur commandes','L','46', NULL, '0',string_to_array('AR_paid', ':'));
-SELECT account_save(NULL,'4168','Rabais, ristournes, remises Ã obtenir et autres avoirs non encore reÃus','A','416', NULL, '0',string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'756000','Produits financiers divers','I','75', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'555000','DEX02','A','55', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'499200','Compte de repartition NDC - Verdelingsrekening CN','L','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'460','Acomptes reÃus sur commandes','L','46', NULL, false, false, string_to_array('AR_paid', ':'));
+SELECT account_save(NULL,'4168','Rabais, ristournes, remises Ã obtenir et autres avoirs non encore reÃus','A','416', NULL, false, false, string_to_array('AP_paid', ':'));
 SELECT account_heading_save(NULL, '43', 'Dettes financiÃres - FinanciÃle schulden', NULL);
-SELECT account_save(NULL,'2400','Mobilier - Meubilair','A','24', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'2400','Mobilier - Meubilair','A','24', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'240190','MatÃriel bureau amort. anterieurs - Afschr. op bureaumaterieel vorig boekj.','A','24', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'221900','Constructions amort. anterieurs - Afschr. op gebouwen vorig boekj.','A','22', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'221910','Constructions amort. de l''exercice - Afschr. op gebouwen dit boekj.','A','22', NULL, true, false, string_to_array('', ':'));
@@ -30,401 +30,401 @@
 SELECT account_save(NULL,'237900','Outillage amort. anterieurs - Afschr. op uitrusting vorig boekj.','A','23', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'237910','Outillage amort. exercice - Afschr. op uitrusting dit boekj.','A','23', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'260910','Amen. loc. louÃs amort. exercice - Inrichtingskost. dit boekj.','A','26', NULL, true, false, string_to_array('', ':'));
-SELECT account_save(NULL,'451541','TVA DUE VENTES 21%','L','451', NULL, '0',string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'612200','Carburants voitures','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'630','Dotations amort., rÃduction valeur s/immo. - Afschr., waardeverm. op v. a., toevoeging','E','63', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'613210','Honoraires avocats','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'712','Des encours de fabrication - In de vooraad goederen in bewerking','I','71', NULL, '0',string_to_array('IC_sale', ':'));
-SELECT account_save(NULL,'600','Achats matiÃres premiÃres - Aankopen van grondstoffen','E','60', NULL, '0',string_to_array('IC_cogs', ':'));
-SELECT account_save(NULL,'614400','EntrÃe aux foires','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'742','Plus-values crÃances com. - Meerwaarden realis. handelsvorderingen','I','74', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'613304','Traiteurs-rÃception clientÃle','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'451541','TVA DUE VENTES 21%','L','451', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'612200','Carburants voitures','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'630','Dotations amort., rÃduction valeur s/immo. - Afschr., waardeverm. op v. a., toevoeging','E','63', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'613210','Honoraires avocats','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'712','Des encours de fabrication - In de vooraad goederen in bewerking','I','71', NULL, false, false, string_to_array('IC_sale', ':'));
+SELECT account_save(NULL,'600','Achats matiÃres premiÃres - Aankopen van grondstoffen','E','60', NULL, false, false, string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'614400','EntrÃe aux foires','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'742','Plus-values crÃances com. - Meerwaarden realis. handelsvorderingen','I','74', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'613304','Traiteurs-rÃception clientÃle','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
 SELECT account_heading_save(NULL, '64', 'Autres charges exploitation - Andere bedrijfskosten', NULL);
 SELECT account_heading_save(NULL, '76', 'Produits exceptionnels - Uitzonderlijke opbrengsten', NULL);
-SELECT account_save(NULL,'743000','Ventes diverses - Diverse bedrijfsopbrengsten','I','74', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'760100','sur immobilisations corp. - op materiÃle vaste activa','I','760', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'611150','Charges locatives voitures','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'771200','Reprises de provisions fiscales - Terugn. fiscale voorz.','I','771', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'794','Intervention associÃ perte - Tussenkomst vennoten verlies','I','79', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'404','Produits Ã recevoir - Te innen opbrengsten','A','40', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'500','Action propres - Eigen aandelen','A','50', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'743000','Ventes diverses - Diverse bedrijfsopbrengsten','I','74', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'760100','sur immobilisations corp. - op materiÃle vaste activa','I','760', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'611150','Charges locatives voitures','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'771200','Reprises de provisions fiscales - Terugn. fiscale voorz.','I','771', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'794','Intervention associÃ perte - Tussenkomst vennoten verlies','I','79', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'404','Produits Ã recevoir - Te innen opbrengsten','A','40', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'500','Action propres - Eigen aandelen','A','50', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '41', 'Autres crÃances - Overige vorderingen', NULL);
-SELECT account_save(NULL,'407','CrÃances douteuses - Dubieuze debiteuren','A','40', NULL, '0',string_to_array('AR_paid', ':'));
-SELECT account_save(NULL,'442001','Fournisseurs essence','L','44', NULL, '0',string_to_array('AP', ':'));
-SELECT account_save(NULL,'608','Remises ristournes rabais obtenus - Ontvangen kortingen ristorno''s en rabatten (-)','E','60', NULL, '0',string_to_array('IC_cogs', ':'));
-SELECT account_save(NULL,'612140','Internet','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'407','CrÃances douteuses - Dubieuze debiteuren','A','40', NULL, false, false, string_to_array('AR_paid', ':'));
+SELECT account_save(NULL,'442001','Fournisseurs essence','L','44', NULL, false, false, string_to_array('AP', ':'));
+SELECT account_save(NULL,'608','Remises ristournes rabais obtenus - Ontvangen kortingen ristorno''s en rabatten (-)','E','60', NULL, false, false, string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'612140','Internet','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
 SELECT account_heading_save(NULL, '50', 'Actions propres - Eigen aandelen', NULL);
 SELECT account_heading_save(NULL, '6', 'CLASSE 6 -- CHARGES - KOSTEN', NULL);
-SELECT account_save(NULL,'611350','Entr. & Repar. Voitures & Veh. Mixtes','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'655000','Ecarts de conversion de devises','E','65', NULL, '0',string_to_array('AR_paid:IC_sale:IC_expense', ':'));
-SELECT account_save(NULL,'451560','TVA DUE CO-CONTRACTANT','L','451', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'609000','de matiÃres premiÃres - van grondstofen','E','60', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'411590','TVA ACHATS 6%','A','411', NULL, '0',string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'411591','TVA ACHATS 21%','A','411', NULL, '0',string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'411620','TVA Ã rÃgulariser (case 62)','A','411', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'611350','Entr. & Repar. Voitures & Veh. Mixtes','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'655000','Ecarts de conversion de devises','E','65', NULL, false, false, string_to_array('AR_paid:IC_sale:IC_expense', ':'));
+SELECT account_save(NULL,'451560','TVA DUE CO-CONTRACTANT','L','451', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'609000','de matiÃres premiÃres - van grondstofen','E','60', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'411590','TVA ACHATS 6%','A','411', NULL, false, false, string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'411591','TVA ACHATS 21%','A','411', NULL, false, false, string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'411620','TVA Ã rÃgulariser (case 62)','A','411', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '411', 'TVA A RECUPERER - TERUG TE VORDEREN BTW', NULL);
 SELECT account_heading_save(NULL, '44', 'Dettes commerciales - Handelsschulden', NULL);
-SELECT account_save(NULL,'409','RÃductions de valeur actÃes (-) - Geboekte waardevermindering','A','40', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'451540','TVA DUE VENTES 6%','L','451', NULL, '0',string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'640','Charges fiscales de l''exploitation - Bedrijfsbelastingen','E','64', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'713','Des Produits finis - In de voorraad gereed product','I','71', NULL, '0',string_to_array('IC_sale', ':'));
-SELECT account_save(NULL,'750','Produits immo. financiÃres - Opbrengsten financiÃle vaste activa','I','75', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'656500','IntÃrÃts retards sociaux - Sociale achterst. interest','E','65', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'755000','Ecarts de convers. devises - Resultats omrekening vreemde valuta','I','75', NULL, '0',string_to_array('IC_sale:IC_income', ':'));
-SELECT account_save(NULL,'754000','DiffÃrence de change - Wisselresultaten','I','75', NULL, '0',string_to_array('AR_amount:IC_income', ':'));
-SELECT account_save(NULL,'761','Reprises rÃduct. valeur immo. fin. - Terugneming waardeverm. fin. v. a.','I','76', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'773','ImpÃts Ãtrangers s/rÃsultat - Buitenl. belasting op resultaat','I','77', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'409','RÃductions de valeur actÃes (-) - Geboekte waardevermindering','A','40', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'451540','TVA DUE VENTES 6%','L','451', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'640','Charges fiscales de l''exploitation - Bedrijfsbelastingen','E','64', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'713','Des Produits finis - In de voorraad gereed product','I','71', NULL, false, false, string_to_array('IC_sale', ':'));
+SELECT account_save(NULL,'750','Produits immo. financiÃres - Opbrengsten financiÃle vaste activa','I','75', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'656500','IntÃrÃts retards sociaux - Sociale achterst. interest','E','65', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'755000','Ecarts de convers. devises - Resultats omrekening vreemde valuta','I','75', NULL, false, false, string_to_array('IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'754000','DiffÃrence de change - Wisselresultaten','I','75', NULL, false, false, string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'761','Reprises rÃduct. valeur immo. fin. - Terugneming waardeverm. fin. v. a.','I','76', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'773','ImpÃts Ãtrangers s/rÃsultat - Buitenl. belasting op resultaat','I','77', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '77', 'RÃgularisation d''impÃts, reprises provisions fiscales - Regul. belastingen en terugneming fiscale voorz.', NULL);
 SELECT account_heading_save(NULL, '7', 'CLASSE 7 -- PRODUITS - OPBRENGSTEN', NULL);
-SELECT account_save(NULL,'411640','TVA Ã recupÃrer s/NDC Ãmises (case 64)','A','411', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'612300','Abonnements & Documentations','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'410','Capital appelÃ, non versÃ - Opgevraagd, niet-gestort kapitaal','A','41', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'417','CrÃances douteuses - Dubieuze debiteuren','A','416', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'411640','TVA Ã recupÃrer s/NDC Ãmises (case 64)','A','411', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'612300','Abonnements & Documentations','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'410','Capital appelÃ, non versÃ - Opgevraagd, niet-gestort kapitaal','A','41', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'417','CrÃances douteuses - Dubieuze debiteuren','A','416', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '451', 'TVA A PAYER - TE BETALEN BTW', NULL);
-SELECT account_save(NULL,'499000','Compte d''attente - Wachtrekening','L','', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'455','RÃmunerations - Bezoldigingen','L','45', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'601','Achat des fournitures - Aankoop van hulpstoffen','E','60', NULL, '0',string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'499000','Compte d''attente - Wachtrekening','L','', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'455','RÃmunerations - Bezoldigingen','L','45', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'601','Achat des fournitures - Aankoop van hulpstoffen','E','60', NULL, false, false, string_to_array('IC_cogs', ':'));
 SELECT account_heading_save(NULL, '49', 'Comptes de rÃgularisation - Overlopende- en wachtrekeningen', NULL);
-SELECT account_save(NULL,'613220','Honoraires notaires','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'414100','IndeminitÃs s/sinistres Ã recevoir - Te ontvang. schadevergoed.','A','41', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'613220','Honoraires notaires','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'414100','IndeminitÃs s/sinistres Ã recevoir - Te ontvang. schadevergoed.','A','41', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '42', 'Dettes Ã plus d''un an Ãcheant dans l''annÃe - Schulden op meer dan ÃÃn jaar die binnen het jaar verfallen', NULL);
-SELECT account_save(NULL,'613311','Deplacements Ãtranger train, taxi, etc','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'611151','Charges locatives camions/camionnettes','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'432','Etabli. crÃdit, crÃdits d''acceptation - Acceptkrediten','L','43', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'433','Etabl. crÃdit, dettes cpt. courant - Schulden rekening courant','L','43', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'705100','DNS REGISTRY','I','70', NULL, '0',string_to_array('AR_amount:IC_income', ':'));
-SELECT account_save(NULL,'609100','de fourniture - van hulpstoffen','E','60', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'656100','Frais de banque','E','65', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'620000','Administrateurs ou gÃrants - Bestuurders of zaakvoerders','E','62', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'618','Divers','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'613311','Deplacements Ãtranger train, taxi, etc','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'611151','Charges locatives camions/camionnettes','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'432','Etabli. crÃdit, crÃdits d''acceptation - Acceptkrediten','L','43', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'433','Etabl. crÃdit, dettes cpt. courant - Schulden rekening courant','L','43', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'705100','DNS REGISTRY','I','70', NULL, false, false, string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'609100','de fourniture - van hulpstoffen','E','60', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'656100','Frais de banque','E','65', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'620000','Administrateurs ou gÃrants - Bestuurders of zaakvoerders','E','62', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'618','Divers','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
 SELECT account_heading_save(NULL, '65', 'Charges financiÃres', NULL);
-SELECT account_save(NULL,'442004','VISA - dÃcompte mensuel','L','44', NULL, '0',string_to_array('AP_paid', ':'));
-SELECT account_save(NULL,'620100','Personnel de direction - Directiepersoneel','E','62', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'617','Personnel intÃrimaire - Uitzendkrachten','E','61', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'440','Fournisseurs - Leveranciers','L','44', NULL, '0',string_to_array('AP', ':'));
+SELECT account_save(NULL,'442004','VISA - dÃcompte mensuel','L','44', NULL, false, false, string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'620100','Personnel de direction - Directiepersoneel','E','62', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'617','Personnel intÃrimaire - Uitzendkrachten','E','61', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'440','Fournisseurs - Leveranciers','L','44', NULL, false, false, string_to_array('AP', ':'));
 SELECT account_heading_save(NULL, '52', 'Titres Ã revenu fixe - Vastrentende Effecten', NULL);
 SELECT account_heading_save(NULL, '4529', '453 - 459 Dettes salariales et sociales - Bezoldigingen en sociale schulden', NULL);
-SELECT account_save(NULL,'620','RÃmunerations et avant. sociaux directs - Bezolgingen en rechts. sociale voordelen','E','62', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'602','Achats services, travaux, Ãtudes - Aankopen diensten, werk, studies','E','60', NULL, '0',string_to_array('IC_cogs', ':'));
-SELECT account_save(NULL,'612000','Eau','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'611351','Pneus Voitures & Vehic. Mixtes','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'641','Moins-values s/rÃalis. cour. d''immo. corp. - Minderwa. courante realis. vaste activa','E','64', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'715','Des immeubles constr. dest. Ã la vente - In de voorr. onroe. goederen best. v. verkoop','I','71', NULL, '0',string_to_array('IC_sale', ':'));
-SELECT account_save(NULL,'612400','ImprimÃs & fournitures de bureau','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'414200','Subsides en capital Ã recevoir - Te ontv. kapitaalsubsidies','A','41', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'620','RÃmunerations et avant. sociaux directs - Bezolgingen en rechts. sociale voordelen','E','62', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'602','Achats services, travaux, Ãtudes - Aankopen diensten, werk, studies','E','60', NULL, false, false, string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'612000','Eau','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'611351','Pneus Voitures & Vehic. Mixtes','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'641','Moins-values s/rÃalis. cour. d''immo. corp. - Minderwa. courante realis. vaste activa','E','64', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'715','Des immeubles constr. dest. Ã la vente - In de voorr. onroe. goederen best. v. verkoop','I','71', NULL, false, false, string_to_array('IC_sale', ':'));
+SELECT account_save(NULL,'612400','ImprimÃs & fournitures de bureau','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'414200','Subsides en capital Ã recevoir - Te ontv. kapitaalsubsidies','A','41', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '66', 'Charges exceptionnelles', NULL);
-SELECT account_save(NULL,'613230','Honoraires huissiers de justice','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'613313','Restaurants Ãtranger','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'613230','Honoraires huissiers de justice','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'613313','Restaurants Ãtranger','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
 SELECT account_heading_save(NULL, '74', 'Autres produits exploitation - Andere bedrijfsopbrengsten', NULL);
-SELECT account_save(NULL,'610','Loyers et charges locatives','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'610','Loyers et charges locatives','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
 SELECT account_heading_save(NULL, '70', 'Chiffre d''affaires - Omzet', NULL);
-SELECT account_save(NULL,'751','Produits actifs circulants - Opbrengsten uit vlottende activa','I','75', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'705200','WEB HOSTING','I','70', NULL, '0',string_to_array('AR_amount:IC_income', ':'));
-SELECT account_save(NULL,'442005','AMERICAN EXPRESS - dÃcompte mensuel','L','44', NULL, '0',string_to_array('AP_paid', ':'));
-SELECT account_save(NULL,'762','Reprises provisions risq. charg. except. - Terugn. voorz. uitz. risico en kosten','I','76', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'780','PrÃlÃvements s/impÃts diffÃrÃs - Onttrekking a. uitgesteld. belast.','I','78', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'751','Produits actifs circulants - Opbrengsten uit vlottende activa','I','75', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'705200','WEB HOSTING','I','70', NULL, false, false, string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'442005','AMERICAN EXPRESS - dÃcompte mensuel','L','44', NULL, false, false, string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'762','Reprises provisions risq. charg. except. - Terugn. voorz. uitz. risico en kosten','I','76', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'780','PrÃlÃvements s/impÃts diffÃrÃs - Onttrekking a. uitgesteld. belast.','I','78', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '78', 'PrÃlÃvements rÃserves immunisÃes et impÃts diffÃrÃs - Onttrek. belast.vrije reserves en de uitgestelde belastingen', NULL);
 SELECT account_heading_save(NULL, '53', 'DÃpÃts Ã terme - Termijndeposito''s', NULL);
-SELECT account_save(NULL,'614100','Catalogues et imprimÃes','I','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'451500','TVA DUE ACHATS INCO','L','451', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'613110','Assurance vol','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'451543','TVA due 2e trimestre','L','451', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'609400','de marchandises - van handelsgoederen','E','60', NULL, '0',string_to_array('AP_amount:IC_sale', ':'));
-SELECT account_save(NULL,'613305','Collations','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'612010','Chauffage','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'612410','Fournitures informatiques','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'613250','Honoraires sÃcretariat social','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'611362','Control technique voitures','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'482200','ASSOCIES - MEMBRES','L','48', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'612530','Petit outillage & petit matÃriel','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'613400','Seminaires & Recyclages','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'612540','Petit matÃriel informatique','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'603','Sous-traitances gÃnÃrales - Algemene onderaanemingen','E','60', NULL, '0',string_to_array('IC_cogs', ':'));
-SELECT account_save(NULL,'743200','COTISATION DE MEMBRE','I','74', NULL, '0',string_to_array('AR_amount:IC_income', ':'));
-SELECT account_save(NULL,'601000','Emballages perdus','E','60', NULL, '0',string_to_array('IC_cogs', ':'));
-SELECT account_save(NULL,'230010','Inst. techniques acquis. exercice - Installaties m.b.t. dit boekj.','A','23', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'570000','CAISSE ESPECES - CONTANTEN','A','57', NULL, '0',string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'451544','TVA due 3e trimestre','L','451', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'411000','Cpt. curr. TVA Ã rÃcuperer - Terug te vord. BTW: saldo BTW r/c','A','411', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'611152','Locations machines et outils','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'614100','Catalogues et imprimÃes','I','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'451500','TVA DUE ACHATS INCO','L','451', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'613110','Assurance vol','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'451543','TVA due 2e trimestre','L','451', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'609400','de marchandises - van handelsgoederen','E','60', NULL, false, false, string_to_array('AP_amount:IC_sale', ':'));
+SELECT account_save(NULL,'613305','Collations','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'612010','Chauffage','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'612410','Fournitures informatiques','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'613250','Honoraires sÃcretariat social','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'611362','Control technique voitures','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'482200','ASSOCIES - MEMBRES','L','48', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'612530','Petit outillage & petit matÃriel','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'613400','Seminaires & Recyclages','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'612540','Petit matÃriel informatique','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'603','Sous-traitances gÃnÃrales - Algemene onderaanemingen','E','60', NULL, false, false, string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'743200','COTISATION DE MEMBRE','I','74', NULL, false, false, string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'601000','Emballages perdus','E','60', NULL, false, false, string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'230010','Inst. techniques acquis. exercice - Installaties m.b.t. dit boekj.','A','23', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'570000','CAISSE ESPECES - CONTANTEN','A','57', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'451544','TVA due 3e trimestre','L','451', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'411000','Cpt. curr. TVA Ã rÃcuperer - Terug te vord. BTW: saldo BTW r/c','A','411', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'611152','Locations machines et outils','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
 SELECT account_heading_save(NULL, '56', 'Office des chÃques postaux - PostchÃque en girodienst', NULL);
-SELECT account_save(NULL,'411593','TVA RECUP. 1ER TRIMESTRE TOTAL (case 59)','A','411', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'411593','TVA RECUP. 1ER TRIMESTRE TOTAL (case 59)','A','411', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '51', 'Actions et parts - Aandelen', NULL);
-SELECT account_save(NULL,'510010','Montants non-appelÃs (-) - Niet opgevraagde bedragen aan. (-)','A','51', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'609500','d''immeubles achÃtÃs destinÃs Ã vente - van gek. onroer. goederen best. v. verkoop','E','60', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'510010','Montants non-appelÃs (-) - Niet opgevraagde bedragen aan. (-)','A','51', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'609500','d''immeubles achÃtÃs destinÃs Ã vente - van gek. onroer. goederen best. v. verkoop','E','60', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '58', 'Virements interns - Interne overboekingen', NULL);
 SELECT account_heading_save(NULL, '416', 'CrÃances diverses - Diverse vorderingen ', NULL);
-SELECT account_save(NULL,'416200','Cpt. courant associÃs - Rekening-courant vennoten','A','416', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'418','Cautionnements versÃs en numÃraire - Borgtochten betaald in contanten','A','416', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'416200','Cpt. courant associÃs - Rekening-courant vennoten','A','416', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'418','Cautionnements versÃs en numÃraire - Borgtochten betaald in contanten','A','416', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '67', 'ImpÃt sur le rÃsultat', NULL);
-SELECT account_save(NULL,'654','DiffÃrence de change','E','65', NULL, '0',string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'642','Moins-values s/rÃalis. crÃances com. - Minderwa. realis. handelsvorderingen','E','64', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'717','Des commandes en cours exÃcution - In de bestelling in uitvoering','I','71', NULL, '0',string_to_array('IC_sale', ':'));
-SELECT account_save(NULL,'752','Plus-values rÃalis. d''actifs circulants - Meerwaar. realis. v. vlottende activa','I','75', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'763','Plus-values s/rÃalis. actifs immo. - Meerwaar. realis. vaste a.','I','76', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'789','PrÃlÃvements s/rÃserves immunisÃes - Onttrekking a. belast.vrije reserves','I','78', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'654','DiffÃrence de change','E','65', NULL, false, false, string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'642','Moins-values s/rÃalis. crÃances com. - Minderwa. realis. handelsvorderingen','E','64', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'717','Des commandes en cours exÃcution - In de bestelling in uitvoering','I','71', NULL, false, false, string_to_array('IC_sale', ':'));
+SELECT account_save(NULL,'752','Plus-values rÃalis. d''actifs circulants - Meerwaar. realis. v. vlottende activa','I','75', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'763','Plus-values s/rÃalis. actifs immo. - Meerwaar. realis. vaste a.','I','76', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'789','PrÃlÃvements s/rÃserves immunisÃes - Onttrekking a. belast.vrije reserves','I','78', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '79', 'Affectations et prÃlÃvements - Resultaatverwerking', NULL);
-SELECT account_save(NULL,'412','ImpÃts, prÃcomptes Ã rÃcupÃrer - Terug te vorderen belast. en voorheffingen','A','41', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'120','Plus-values de rÃÃvaluation sur immo. incorp. - Herwaarderingsmeerwaarde','L','12', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'121','Plus-values de rÃÃvaluation sur immo. corp. - Herwaarderingsmeerwaarde','L','12', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'122','Plus-values de rÃÃvaluation sur immo. financiers - Herwaarderingsmeerwaarde','L','12', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'123','Plus-values de rÃÃvaluation sur stocks - Herwaarderingsmeerwaarde','L','12', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'124','Reprises de rÃduction de valeur sur placements trÃsorerie - Herwaarderingsmeerwaarde','L','12', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'412','ImpÃts, prÃcomptes Ã rÃcupÃrer - Terug te vorderen belast. en voorheffingen','A','41', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'120','Plus-values de rÃÃvaluation sur immo. incorp. - Herwaarderingsmeerwaarde','L','12', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'121','Plus-values de rÃÃvaluation sur immo. corp. - Herwaarderingsmeerwaarde','L','12', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'122','Plus-values de rÃÃvaluation sur immo. financiers - Herwaarderingsmeerwaarde','L','12', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'123','Plus-values de rÃÃvaluation sur stocks - Herwaarderingsmeerwaarde','L','12', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'124','Reprises de rÃduction de valeur sur placements trÃsorerie - Herwaarderingsmeerwaarde','L','12', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '12', 'Plus-values de rÃÃvaluation - Herwaarderingsmeerwaarde', NULL);
-SELECT account_save(NULL,'110','Primes d''Ãmission - Uitgiftepremies','L','11', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'110','Primes d''Ãmission - Uitgiftepremies','L','11', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '11', 'Primes d''Ãmission - Uitgiftepremies', NULL);
 SELECT account_heading_save(NULL, '643', '643-648 Charges d''exploitation diverses - Diverse berijfskosten', NULL);
-SELECT account_save(NULL,'612100','Telephone','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'612100','Telephone','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
 SELECT account_heading_save(NULL, '10', 'Capital - Kapitaal', NULL);
 SELECT account_heading_save(NULL, '1', 'CLASSE 1 -- CAPITAL PROPRE, ... - EIGEN VERMOGEN, ...', NULL);
 SELECT account_heading_save(NULL, '60', 'Approv. et marchandises', NULL);
-SELECT account_save(NULL,'717000','Valeur d''acquisition - Aanschaffingswaarde','I','717', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'717000','Valeur d''acquisition - Aanschaffingswaarde','I','717', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '68', 'Transferts comptes immunisÃes et impÃts diffÃrÃs', NULL);
-SELECT account_save(NULL,'130','RÃserve lÃgale - Wettelijke reserve','L','13', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'131100','Autres rÃserves indisponibles - Andere onbeschikbare reserves','L','13', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'132','RÃserves immunisÃes - Belastingvrije reserves','L','13', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'131000','RÃserves pour actions propres - Reserve voor eigen aandelen','L','13', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'133','RÃserves disponibles - Beschikbare reserves','L','13', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'101','Capital non appelÃ (-) - Niet opgevraagd kapitaal (-)','L','10', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'130','RÃserve lÃgale - Wettelijke reserve','L','13', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'131100','Autres rÃserves indisponibles - Andere onbeschikbare reserves','L','13', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'132','RÃserves immunisÃes - Belastingvrije reserves','L','13', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'131000','RÃserves pour actions propres - Reserve voor eigen aandelen','L','13', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'133','RÃserves disponibles - Beschikbare reserves','L','13', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'101','Capital non appelÃ (-) - Niet opgevraagd kapitaal (-)','L','10', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '14', 'BÃnÃfice/perte reportÃ(e) - Overgedragen winst/verlies', NULL);
-SELECT account_save(NULL,'100','Capital souscrit - Geplaatst kapitaal','L','10', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'601010','Emballages recuperables','E','60', NULL, '0',string_to_array('IC_cogs', ':'));
-SELECT account_save(NULL,'140','BÃnÃfice/perte reportÃ(e) - Overgedragen winst/verlies','Q','14', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'100','Capital souscrit - Geplaatst kapitaal','L','10', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'601010','Emballages recuperables','E','60', NULL, false, false, string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'140','BÃnÃfice/perte reportÃ(e) - Overgedragen winst/verlies','Q','14', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '15', 'Subsides en capital - Kapitaalsubsidies', NULL);
-SELECT account_save(NULL,'419','RÃductions de valeur actÃes (-) - Geboekte waardevermindering (-)','A','416', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'612450','Photocopies-Photographies','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'131','RÃserves indisponibles - Onbeschikbare reserves','L','13', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'419','RÃductions de valeur actÃes (-) - Geboekte waardevermindering (-)','A','416', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'612450','Photocopies-Photographies','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'131','RÃserves indisponibles - Onbeschikbare reserves','L','13', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '16', 'Provisions et impÃts diffÃrÃs - Voorz. en uitgestelde belastingen', NULL);
-SELECT account_save(NULL,'160','Provisions pensions et obligations - Voorz. pensioenen en soortg. verplichtingen','L','16', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'161','Provisions charges fiscales - Voorz. belastingen','L','16', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'162','Provisions gros entretiens et rÃparations - Voorz. grote herstel/onderh.','L','16', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'163','Provisions autres risques-charges - Voorzieningen voor Lijfrente','L','16', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'753','Subsides en capital et intÃrÃts - Kapitaal- en interestsubsidies','I','75', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'705000','Prestations de services - Verkopen en dienstprestaties','I','70', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'160','Provisions pensions et obligations - Voorz. pensioenen en soortg. verplichtingen','L','16', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'161','Provisions charges fiscales - Voorz. belastingen','L','16', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'162','Provisions gros entretiens et rÃparations - Voorz. grote herstel/onderh.','L','16', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'163','Provisions autres risques-charges - Voorzieningen voor Lijfrente','L','16', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'753','Subsides en capital et intÃrÃts - Kapitaal- en interestsubsidies','I','75', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'705000','Prestations de services - Verkopen en dienstprestaties','I','70', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '764', '764-769 Autres produits execptionnels - Andere uitz. opbrengsten', NULL);
-SELECT account_save(NULL,'790','BÃnÃfice reportÃ exercice prÃcÃd. - Overgedragen winst vorige boekj.','I','79', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'168200','ImpÃts diff. s/+value immo. corp. - Uitg. belast./meerwa./mat. v.a.','L','16', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'604','Achats marchandises - Aankopen van handelsgoederen','E','60', NULL, '0',string_to_array('IC_cogs', ':'));
-SELECT account_save(NULL,'168000','ImpÃts diff. s/subsides en capital - Uitgest. belast./Kapitaalsubsidie','L','16', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'613265','Honoraires d''autres','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'620800','Assurance revenus garantis','E','62', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'168800','ImpÃts diffÃrÃs Ãtrangers - Uitg. belast. buitenland','L','16', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'790','BÃnÃfice reportÃ exercice prÃcÃd. - Overgedragen winst vorige boekj.','I','79', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'168200','ImpÃts diff. s/+value immo. corp. - Uitg. belast./meerwa./mat. v.a.','L','16', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'604','Achats marchandises - Aankopen van handelsgoederen','E','60', NULL, false, false, string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'168000','ImpÃts diff. s/subsides en capital - Uitgest. belast./Kapitaalsubsidie','L','16', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'613265','Honoraires d''autres','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'620800','Assurance revenus garantis','E','62', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'168800','ImpÃts diffÃrÃs Ãtrangers - Uitg. belast. buitenland','L','16', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '17', 'Dettes Ã plus d''un an - Schulden op meer dan een jaar', NULL);
-SELECT account_save(NULL,'150','Montants obtenus - Kapitaalsubsidies','L','15', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'172000','Dettes location fin. et assimilÃes - Leasingschuld. van vaste activa','L','17', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'231010','Mach. et gros mat. acquis. exercice - Machines m.b.t. dit boekj.','A','23', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'451610','TVA Ã rÃgulariser (case 61)','L','45', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'456','PÃcules de vacances - Vakantiegeld','L','45', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'176','Acomptes reÃus sur commandes','L','17', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'150','Montants obtenus - Kapitaalsubsidies','L','15', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'172000','Dettes location fin. et assimilÃes - Leasingschuld. van vaste activa','L','17', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'231010','Mach. et gros mat. acquis. exercice - Machines m.b.t. dit boekj.','A','23', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'451610','TVA Ã rÃgulariser (case 61)','L','45', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'456','PÃcules de vacances - Vakantiegeld','L','45', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'176','Acomptes reÃus sur commandes','L','17', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '47', 'Dettes affectation rÃsultat - Schulden besteming resultaat', NULL);
-SELECT account_save(NULL,'620200','EmployÃs - Bedienden','E','62', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'178','Cautionnements reÃu en numÃraire - Borgtocht. ontvang. in contanten','L','17', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'179','Dettes diverses - Overige schulden','L','17', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'174','Autres emprunts - Overige schulden','L','17', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'620200','EmployÃs - Bedienden','E','62', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'178','Cautionnements reÃu en numÃraire - Borgtocht. ontvang. in contanten','L','17', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'179','Dettes diverses - Overige schulden','L','17', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'174','Autres emprunts - Overige schulden','L','17', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '2', 'CLASSE 2 -- FRAIS D''ETABLISSEMENT, ACTIFS IMMOBILISES, ... - OPRICHTINGSKOSTEN, VASTE ACTIVA, ...', NULL);
 SELECT account_heading_save(NULL, '20', 'Frais d''Ãtablissement - Oprichtingskosten', NULL);
-SELECT account_save(NULL,'200','Frais de constitution - Kosten van oprichting','A','20', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'200000','Fr. const. acquis. anterieurs - Kost. opricht./kapitaalverhoging','A','20', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'605','Achats d''immeubles destinÃs vente - Aankopen onroer. goederen bestemd v. verkoop','E','60', NULL, '0',string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'200','Frais de constitution - Kosten van oprichting','A','20', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'200000','Fr. const. acquis. anterieurs - Kost. opricht./kapitaalverhoging','A','20', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'605','Achats d''immeubles destinÃs vente - Aankopen onroer. goederen bestemd v. verkoop','E','60', NULL, false, false, string_to_array('IC_cogs', ':'));
 SELECT account_heading_save(NULL, '61', 'Services et biens divers', NULL);
 SELECT account_heading_save(NULL, '69', 'Affectations et prÃlÃvements', NULL);
-SELECT account_save(NULL,'200900','Fr. const. amort. anterieur - Afschr. kost. opricht./kap.verh. vorig','A','20', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'200910','Fr. const. amort. de l''exercice - Afschr. kost. opricht./kap.verh. dit','A','20', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'612020','ElectricitÃ','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'202','Autres frais d''Ãtablissement - Overige oprichtingskosten','A','20', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'204','Frais de restructuration - Herstructureringskosten','A','20', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'201','Frais d''Ãmission d''emprunts - Kosten bij uitgifte van leningen','A','20', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'200900','Fr. const. amort. anterieur - Afschr. kost. opricht./kap.verh. vorig','A','20', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'200910','Fr. const. amort. de l''exercice - Afschr. kost. opricht./kap.verh. dit','A','20', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'612020','ElectricitÃ','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'202','Autres frais d''Ãtablissement - Overige oprichtingskosten','A','20', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'204','Frais de restructuration - Herstructureringskosten','A','20', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'201','Frais d''Ãmission d''emprunts - Kosten bij uitgifte van leningen','A','20', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '21', 'Immobilisations incorporelles - Immateriele vaste activa', NULL);
-SELECT account_save(NULL,'211','Concessions, brevets, licences, ... - Consessies, octrooien, licenties, ...','A','21', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'210','Frais de recherches et developpement - Kosten van onderzoek en ontwikkeling','A','21', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'212','Goodwill','A','21', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'213','Acomptes versÃs - Vooruitbetalingen','A','21', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'214','Surprix affÃrents acquisition d''une participation','A','21', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'211','Concessions, brevets, licences, ... - Consessies, octrooien, licenties, ...','A','21', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'210','Frais de recherches et developpement - Kosten van onderzoek en ontwikkeling','A','21', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'212','Goodwill','A','21', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'213','Acomptes versÃs - Vooruitbetalingen','A','21', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'214','Surprix affÃrents acquisition d''une participation','A','21', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '22', 'Terrains et constructions - Terreinen en gebouwen', NULL);
 SELECT account_heading_save(NULL, '743', '743-749 Produits d''exploitation divers - Diverse bedrijfsopbrengsten', NULL);
-SELECT account_save(NULL,'580000','TRANSFERTS INTERNES DES FONDS - TRANSFERTEN','A','58', NULL, '0',string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'221','Constructions - Gebouwen','A','22', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'717100','BÃnÃfice pris en compte - Toegerekende winst','I','717', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'580000','TRANSFERTS INTERNES DES FONDS - TRANSFERTEN','A','58', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'221','Constructions - Gebouwen','A','22', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'717100','BÃnÃfice pris en compte - Toegerekende winst','I','717', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '756', '756-759 Produits financiers divers - Diverse financiÃle opbrengsten', NULL);
-SELECT account_save(NULL,'222','Terrains bÃtis - Bebouwde terreinen','A','22', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'222','Terrains bÃtis - Bebouwde terreinen','A','22', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '13', 'RÃserves - Reserves', NULL);
-SELECT account_save(NULL,'223','Autres droits rÃels sur immeubles - Overige zakelijke rechten op onroe.','A','22', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'221000','Constructions acquis. anterieurs - Geb. aanschaffingsprijs vorig. boekj.','A','22', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'411594','TVA RECUP. 2E TRIMESTRE TOTAL','A','411', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'771','ImpÃts belges sur le rÃsultat - Belgische belasting op het resultaat','I','77', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'223','Autres droits rÃels sur immeubles - Overige zakelijke rechten op onroe.','A','22', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'221000','Constructions acquis. anterieurs - Geb. aanschaffingsprijs vorig. boekj.','A','22', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'411594','TVA RECUP. 2E TRIMESTRE TOTAL','A','411', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'771','ImpÃts belges sur le rÃsultat - Belgische belasting op het resultaat','I','77', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '23', 'Installations, machines et outillage - Installaties, machines en uitrusting', NULL);
-SELECT account_save(NULL,'230','Installations - Installaties','A','23', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'230000','Inst. techniques acquis. anterieurs - Installaties m.b.t. vorig boekj.','A','23', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'620300','Ouvriers - Arbeiders','E','62', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'231','Machines','A','23', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'791','PrÃlÃvement s/capital et primes Ãmissions - Onttrek. kapitaal e. uitgiftepre.','I','79', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'220','Terrains - Terreinen','A','22', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'237','Outillage - Uitrusting','A','23', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'231000','Mach. et gros mat. acquis anterieurs - Machines m.b.t. vorig boekj.','A','23', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'613100','Assurance incendie','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'613275','Publications lÃgales','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'237000','Outillage acquis. anterieurs - Uitrusting m.b.t. vorig boekj.','A','23', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'230','Installations - Installaties','A','23', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'230000','Inst. techniques acquis. anterieurs - Installaties m.b.t. vorig boekj.','A','23', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'620300','Ouvriers - Arbeiders','E','62', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'231','Machines','A','23', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'791','PrÃlÃvement s/capital et primes Ãmissions - Onttrek. kapitaal e. uitgiftepre.','I','79', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'220','Terrains - Terreinen','A','22', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'237','Outillage - Uitrusting','A','23', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'231000','Mach. et gros mat. acquis anterieurs - Machines m.b.t. vorig boekj.','A','23', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'613100','Assurance incendie','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'613275','Publications lÃgales','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'237000','Outillage acquis. anterieurs - Uitrusting m.b.t. vorig boekj.','A','23', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '24', 'Mobilier et matÃriel roulant - Meubilair en rollend materieel', NULL);
-SELECT account_save(NULL,'2401','MatÃriel de bureau - Bureaumaterieel','A','24', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'2402','MatÃriel informatique - Hardware','A','24', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'241','Voiture - Rollend materieel (wagen)','A','24', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'2401','MatÃriel de bureau - Bureaumaterieel','A','24', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'2402','MatÃriel informatique - Hardware','A','24', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'241','Voiture - Rollend materieel (wagen)','A','24', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '62', 'RÃmunÃrations, charges sociales et pensions', NULL);
 SELECT account_heading_save(NULL, '25', 'Immobilis. en loc-financement - Vaste activa in leasing of op grond', NULL);
-SELECT account_save(NULL,'612120','GSM','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'242','Camions - Rollend materieel (vrachtwagen)','A','24', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'250','Terreins loc-fin - Terreinen in leasing','A','25', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'251','Install., machines loc-fin - Installaties, machines in leasing','A','25', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'309','RÃduction val. act. mat. premiÃres (-) - Geboekte waardev. grondst. (-)','A','30', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'253','MatÃriel en loc-fin - Uitrusting in leasing','A','25', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'254','Mat. inform. en loc-fin- Hardware in leasing','A','25', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'255','Mat. roulant en loc-fin - Rollend materieel leasing','A','25', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'612120','GSM','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'242','Camions - Rollend materieel (vrachtwagen)','A','24', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'250','Terreins loc-fin - Terreinen in leasing','A','25', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'251','Install., machines loc-fin - Installaties, machines in leasing','A','25', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'309','RÃduction val. act. mat. premiÃres (-) - Geboekte waardev. grondst. (-)','A','30', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'253','MatÃriel en loc-fin - Uitrusting in leasing','A','25', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'254','Mat. inform. en loc-fin- Hardware in leasing','A','25', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'255','Mat. roulant en loc-fin - Rollend materieel leasing','A','25', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '26', 'Autres immobilisations corp. - Andere materiele vaste activa', NULL);
-SELECT account_save(NULL,'260','Amenagement locaux louÃs - Inrichtingskost. gehuurde gebouw','A','26', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'613130','Assurance crÃdit','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'300','Approv. matiÃre premiÃre - Grondstoffen','A','30', NULL, '0',string_to_array('IC', ':'));
-SELECT account_save(NULL,'411595','TVA RECUP. 3E TRIMESTRE TOTAL','A','411', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'260','Amenagement locaux louÃs - Inrichtingskost. gehuurde gebouw','A','26', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'613130','Assurance crÃdit','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'300','Approv. matiÃre premiÃre - Grondstoffen','A','30', NULL, false, false, string_to_array('IC', ':'));
+SELECT account_save(NULL,'411595','TVA RECUP. 3E TRIMESTRE TOTAL','A','411', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '48', 'Dettes diverses - Diverse schulden', NULL);
-SELECT account_save(NULL,'270','Immo. corp. en cours et acomptes versÃs - V. activa in aanbouw en vooruit','A','27', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'613300','Deplacements Belg. train, taxi, etc','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'270','Immo. corp. en cours et acomptes versÃs - V. activa in aanbouw en vooruit','A','27', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'613300','Deplacements Belg. train, taxi, etc','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
 SELECT account_heading_save(NULL, '27', 'Immo. corp. en cours et acomptes versÃs - V. activa in aanbouw en vooruitÂ', NULL);
-SELECT account_save(NULL,'252','Mobilier en loc-fin - Meubilair in leasing','A','25', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'168100','ImpÃts diff. s/+value immo. incorp. - Uitg. belast./meerwa./immat. v.a.','L','16', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'168700','ImpÃts diff. s/+value fonds publ. belges - Uitg. bel./meerwa./belg. effecten','L','16', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'252','Mobilier en loc-fin - Meubilair in leasing','A','25', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'168100','ImpÃts diff. s/+value immo. incorp. - Uitg. belast./meerwa./immat. v.a.','L','16', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'168700','ImpÃts diff. s/+value fonds publ. belges - Uitg. bel./meerwa./belg. effecten','L','16', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '28', 'Immobilisations financiers - Financiele vaste activa', NULL);
-SELECT account_save(NULL,'620400','Autres membres du personnel - Andere personeelsleden','E','62', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'649','Ch. exploit. portÃes actif c. frais de restruct. (-) - Als herstruct.kost. geactiv. bedrijfsk. (-)','E','64', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'620400','Autres membres du personnel - Andere personeelsleden','E','62', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'649','Ch. exploit. portÃes actif c. frais de restruct. (-) - Als herstruct.kost. geactiv. bedrijfsk. (-)','E','64', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '71', 'Variation stocks et commandes en cours - Wijzigingen vorraden en in de bestellingen in uitvoering', NULL);
-SELECT account_save(NULL,'740','Subsides et montants compensat. - Subsidies en compens. bedragen','I','74', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'760','Reprises amort. et rÃduct. valeur - Terugneming afschr. en waardeverm.','E','76', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'280','Participations entreprises liÃes - Aanschaffingsw. deeln. verb. ond.','A','28', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'771000','RÃgularisations impÃts dus versÃs - Regularisiering versch. of betaal. belast.','I','771', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'281','CrÃances s/entreprises liÃes - Vorderingen op rekening','A','28', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'283','CrÃances s/entr. avec lien de part.','A','28', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'284','Autres actions et parts - Aanschaffingsw. and. aand.','A','28', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'285','Autres crÃances -  Overige vorderingen','A','28', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'288','Cautions versÃs en numeraire - Borgtocht. betaald in contanten','A','28', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'792','PrÃlÃvements rÃserves - Onttrekking reserves','I','79', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'173100','Promesses banque - Promessen bank','L','17', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'290','CrÃances commerciales - Commerciele vorderingen','A','29', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'441','Effets Ã payer - Te betalen wissels','L','44', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'430','Emprunts en compte Ã terme fixe - Leningen op rekeningen vaste termijn','L','43', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'451630','TVA sur NDC reÃues (case 63)','L','45', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'740','Subsides et montants compensat. - Subsidies en compens. bedragen','I','74', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'760','Reprises amort. et rÃduct. valeur - Terugneming afschr. en waardeverm.','E','76', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'280','Participations entreprises liÃes - Aanschaffingsw. deeln. verb. ond.','A','28', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'771000','RÃgularisations impÃts dus versÃs - Regularisiering versch. of betaal. belast.','I','771', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'281','CrÃances s/entreprises liÃes - Vorderingen op rekening','A','28', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'283','CrÃances s/entr. avec lien de part.','A','28', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'284','Autres actions et parts - Aanschaffingsw. and. aand.','A','28', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'285','Autres crÃances -  Overige vorderingen','A','28', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'288','Cautions versÃs en numeraire - Borgtocht. betaald in contanten','A','28', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'792','PrÃlÃvements rÃserves - Onttrekking reserves','I','79', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'173100','Promesses banque - Promessen bank','L','17', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'290','CrÃances commerciales - Commerciele vorderingen','A','29', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'441','Effets Ã payer - Te betalen wissels','L','44', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'430','Emprunts en compte Ã terme fixe - Leningen op rekeningen vaste termijn','L','43', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'451630','TVA sur NDC reÃues (case 63)','L','45', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '29', 'CrÃances Ã plus d''un an - Vorderingen op meer dan een jaar', NULL);
 SELECT account_heading_save(NULL, '45', 'Dettes fiscales, salariales, sociales - Schulden m. betrekking tot belastingen, bezoldingen en sociale lasten', NULL);
-SELECT account_save(NULL,'452','ImpÃts et taxes Ã payer','L','45', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'290000','Clients > 1 an - Handelsdebiteuren > 1 jaar','A','29', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'290100','Effects Ã recevoir >1 an - Te innen wissels > 1 jaar','A','29', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'290600','Acptes versÃs s/immo. financ. > 1 an - Vooruitbetalingen > 1 jaar','A','29', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'290700','CrÃances douteuses - Dubieuze debiteuren >1 jaar','A','29', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'290900','RÃduction valeur actÃe cr.dout. - Geboekte waardevermindering (-)','A','29', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'291','Autres CrÃances > 1 an - Over. vorderingen op rekening > 1 j.','A','29', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'452','ImpÃts et taxes Ã payer','L','45', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'290000','Clients > 1 an - Handelsdebiteuren > 1 jaar','A','29', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'290100','Effects Ã recevoir >1 an - Te innen wissels > 1 jaar','A','29', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'290600','Acptes versÃs s/immo. financ. > 1 an - Vooruitbetalingen > 1 jaar','A','29', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'290700','CrÃances douteuses - Dubieuze debiteuren >1 jaar','A','29', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'290900','RÃduction valeur actÃe cr.dout. - Geboekte waardevermindering (-)','A','29', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'291','Autres CrÃances > 1 an - Over. vorderingen op rekening > 1 j.','A','29', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '30', 'Approv. matiÃres premiÃres - Grondstoffen', NULL);
 SELECT account_heading_save(NULL, '3', 'CLASSE 3 -- STOCK ET COMMANDES EN COURS - GRONDSTOFFEN', NULL);
-SELECT account_save(NULL,'453','PrÃcompte retenus - Ingehouden voorheffingen','L','45', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'459','Autres dettes sociales - Andere sociale schulden','L','45', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'453','PrÃcompte retenus - Ingehouden voorheffingen','L','45', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'459','Autres dettes sociales - Andere sociale schulden','L','45', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '31', 'Approv. et fournitures - Hulpstoffen', NULL);
-SELECT account_save(NULL,'431','Etabli. crÃdit, promesses - Kreditinstellingen, promessen','L','43', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'400','Clients - Handelsdebiteuren','A','40', NULL, '0',string_to_array('AR', ':'));
-SELECT account_save(NULL,'319','RÃduction valeur actÃes (-) - Geboekte waardev. hulpstoffen (-)','A','31', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'431','Etabli. crÃdit, promesses - Kreditinstellingen, promessen','L','43', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'400','Clients - Handelsdebiteuren','A','40', NULL, false, false, string_to_array('AR', ':'));
+SELECT account_save(NULL,'319','RÃduction valeur actÃes (-) - Geboekte waardev. hulpstoffen (-)','A','31', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '32', 'Encours de fabrication - Goederen in bewerking', NULL);
-SELECT account_save(NULL,'708','Remis. rabais ristourn. accordÃs (-) - Toegek. korting. ristorno''s rabat. (-) ','I','70', NULL, '0',string_to_array('AR_amount:IC_expense', ':'));
-SELECT account_save(NULL,'741','Plus-values rÃalis. cour. immo. corp. -  Meerwaar. cour. realis. materiÃle v.a.','I','74', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'708','Remis. rabais ristourn. accordÃs (-) - Toegek. korting. ristorno''s rabat. (-) ','I','70', NULL, false, false, string_to_array('AR_amount:IC_expense', ':'));
+SELECT account_save(NULL,'741','Plus-values rÃalis. cour. immo. corp. -  Meerwaar. cour. realis. materiÃle v.a.','I','74', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '33', 'Produits finis - Gereed Product', NULL);
 SELECT account_heading_save(NULL, '72', 'Production immobilisÃe - Geproduceerde vaste activa', NULL);
-SELECT account_save(NULL,'656600','IntÃrÃts rÃtards com. - Com. achterst. interest','E','65', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'656600','IntÃrÃts rÃtards com. - Com. achterst. interest','E','65', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
 SELECT account_heading_save(NULL, '34', 'Marchandises - Handelsgoederen', NULL);
-SELECT account_save(NULL,'221010','Construction acquis. de l''exercice - Geb. aanschaffingsprijs dit boekj.','A','22', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'760000','sur immobilisations incorp. - op immateriÃle vaste activa','I','760', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'221010','Construction acquis. de l''exercice - Geb. aanschaffingsprijs dit boekj.','A','22', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'760000','sur immobilisations incorp. - op immateriÃle vaste activa','I','760', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '35', 'Immeubles destinÃs vente - Onroerende goederen bestemd. v. verk.', NULL);
-SELECT account_save(NULL,'771100','RÃgul. d''impÃts estimÃs - Regul. geraamde belasting','I','771', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'793','Perte Ã reporter - Over te dragen verlies','I','79', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'771100','RÃgul. d''impÃts estimÃs - Regul. geraamde belasting','I','771', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'793','Perte Ã reporter - Over te dragen verlies','I','79', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '4', 'CLASSE 4 -- CREANCES ET DETTES A UN AN AU PLUS - VORDERINGEN EN SCHULDEN OP TEN HOOGTE EEN JAAR', NULL);
-SELECT account_save(NULL,'552000','KBC56','A','55', NULL, '0',string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'411596','TVA RECUP. 4E TRIMESTRE TOTAL','A','411', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'444','Factures Ã recevoir - Te ontvangen facturen','L','44', NULL, '0',string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'552000','KBC56','A','55', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'411596','TVA RECUP. 4E TRIMESTRE TOTAL','A','411', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'444','Factures Ã recevoir - Te ontvangen facturen','L','44', NULL, false, false, string_to_array('AP_paid', ':'));
 SELECT account_heading_save(NULL, '40', 'CrÃances commerciales - Handelsvorderingen', NULL);
-SELECT account_save(NULL,'329','RÃduction valuer actÃe (-) - Geboekte waardeverminderingen (-) ','A','32', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'339','RÃductions de valeur actÃes (-) - Geboekte waardeverminderingen (-) ','A','33', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'340','Marchandises - Handelsgoederen','A','34', NULL, '0',string_to_array('IC', ':'));
-SELECT account_save(NULL,'451000','COMPTE COURANT TVA DUE','L','451', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'349','RÃduct. valeur actÃes (-) - Geboekte waardeverminderingen (-) ','A','34', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'359','RÃductions valeur actÃes (-) - Geboekte waardeverminderingen (-) ','A','35', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'613150','Assurance tous risques matÃriel Ãlec.','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'329','RÃduction valuer actÃe (-) - Geboekte waardeverminderingen (-) ','A','32', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'339','RÃductions de valeur actÃes (-) - Geboekte waardeverminderingen (-) ','A','33', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'340','Marchandises - Handelsgoederen','A','34', NULL, false, false, string_to_array('IC', ':'));
+SELECT account_save(NULL,'451000','COMPTE COURANT TVA DUE','L','451', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'349','RÃduct. valeur actÃes (-) - Geboekte waardeverminderingen (-) ','A','34', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'359','RÃductions valeur actÃes (-) - Geboekte waardeverminderingen (-) ','A','35', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'613150','Assurance tous risques matÃriel Ãlec.','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
 SELECT account_heading_save(NULL, '63', 'Amortissements, rÃd. val., provi. risques et charges - Afschrijvingen waardevermin. en voorzieningen v. risico''s kost.', NULL);
-SELECT account_save(NULL,'510000','Titres cotÃs - Aandelen op beurs','A','51', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'510000','Titres cotÃs - Aandelen op beurs','A','51', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '5', 'CLASSE 5 - PLACEMENTS DE TRESORIERIE - LIQUIDE MIDDELEN / GELDBELEGGINGEN', NULL);
 SELECT account_heading_save(NULL, '54', 'Valeurs Ãchues Ã encaissement - Te incasseren verfallen waarden', NULL);
 SELECT account_heading_save(NULL, '55', 'Banque - Rekening-courant', NULL);
-SELECT account_save(NULL,'613303','Restaurants','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'310','Valeur d''acquisition - Aanschaffingswaarde hulpstoffen','A','31', NULL, '0',string_to_array('IC', ':'));
-SELECT account_save(NULL,'320','Valeur d''acquisition - Aanschaffingsw. goed. bewerking','A','32', NULL, '0',string_to_array('IC', ':'));
-SELECT account_save(NULL,'330','Produits finis - Gereed product','A','33', NULL, '0',string_to_array('IC', ':'));
-SELECT account_save(NULL,'350','Immeubles - Aanschaffingsw. onr. goed. verkoop','A','35', NULL, '0',string_to_array('IC', ':'));
-SELECT account_save(NULL,'609','Variation de stock - Voorraadwijzigingen','E','60', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'621','Cotisation patronales d''assur. sociales - Werkgeversbijdragen soc. verzekeringen','E','62', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'451640','TVA Ã recupÃrer s/NDC Ãmises','L','45', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'454','O.N.S.S. - R.S.Z.','L','45', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'640700','TVA non-deductible','E','64', NULL, '0',string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'401','Effets Ã recevoir - Te innen wissels','A','40', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'414','Produits Ã recevoir - Te innen opbrengsten','A','41', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'450','Dettes fiscales estimÃes - Geramd bedrag der belastingschulden','L','45', NULL, '0',string_to_array('', ':'));
+SELECT account_save(NULL,'613303','Restaurants','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'310','Valeur d''acquisition - Aanschaffingswaarde hulpstoffen','A','31', NULL, false, false, string_to_array('IC', ':'));
+SELECT account_save(NULL,'320','Valeur d''acquisition - Aanschaffingsw. goed. bewerking','A','32', NULL, false, false, string_to_array('IC', ':'));
+SELECT account_save(NULL,'330','Produits finis - Gereed product','A','33', NULL, false, false, string_to_array('IC', ':'));
+SELECT account_save(NULL,'350','Immeubles - Aanschaffingsw. onr. goed. verkoop','A','35', NULL, false, false, string_to_array('IC', ':'));
+SELECT account_save(NULL,'609','Variation de stock - Voorraadwijzigingen','E','60', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'621','Cotisation patronales d''assur. sociales - Werkgeversbijdragen soc. verzekeringen','E','62', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'451640','TVA Ã recupÃrer s/NDC Ãmises','L','45', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'454','O.N.S.S. - R.S.Z.','L','45', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'640700','TVA non-deductible','E','64', NULL, false, false, string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'401','Effets Ã recevoir - Te innen wissels','A','40', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'414','Produits Ã recevoir - Te innen opbrengsten','A','41', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'450','Dettes fiscales estimÃes - Geramd bedrag der belastingschulden','L','45', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '46', 'Acomptes reÃus sur commandes', NULL);
-SELECT account_save(NULL,'499100','Compte de repartition - Verdelingsrekening','L','', NULL, '0',string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'553000','KBC40','A','55', NULL, '0',string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'613180','Assurance RC professionnelle','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'452500','PrÃcompte immobilier - Onroerende voorhoeffing','L','45', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'554000','KBC83','A','55', NULL, '0',string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'612150','Frais postaux','E','61', NULL, '0',string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
-SELECT account_save(NULL,'451545','TVA due 4e trimestre','L','451', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'200010','Fr. const. acquis. de l''exercice - Kost. opricht./kap.verh. dit boekjaar','A','20', NULL, '0',string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'451542','TVA due 1er trimestre (case 54)','L','451', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'451570','TVA DUE SUR IMPORTATIONS','L','451', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'540','ChÃques Ã encaisser - Te incasseren chÃques','A','54', NULL, '0',string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'611340','Entretiens & rÃparations locaux','E','61', NULL, '0',string_to_array('AR_amount:AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'665000','Pertes et charges diverses','E','66', NULL, '0',string_to_array('AR_paid:AP_amount', ':'));
-SELECT account_save(NULL,'665200','Perte dÃfinitive crÃance douteuse','E','66', NULL, '0',string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'237010','Outillage acquisition exercice - Uitrusting m.b.t. dit boekj.','A','23', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'623600','VÃtements de travail employÃs','E','62', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'612520','Emballages perdus','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'240200','Mat. informatique acquis anterieurs - Hardware m.b.t. vorig boekj.','A','24', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'240210','MatÃriel informatique acquis. exercice - Hardware m.b.t. dit boekj.','A','24', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'260000','Amenagement locaux louÃs acquis anterieurs - Inrichtingskost. m.b.t. vorig boekj.','A','26', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'240000','Mobilier acquis. anterieurs - Meubilair m.b.t. vorig boekj.','A','24', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'240010','Mobilier acquis. exercice - Meubilair m.b.t. dit boekj.','A','24', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'240110','Mat. bureau acquis. exercice - Bureaumaterieel m.b.t. dit boekj.','A','24', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'240100','Mat. bureau acquis. anterieurs - Bureaumaterieel m.b.t. vorig boekj.','A','24', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'241000','Voiture acquis. anterieurs - Wagen m.b.t. vorig boekj.','A','24', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'241010','Voiture acquis. exercice - Wagen m.b.t. dit boekj. ','A','24', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'499100','Compte de repartition - Verdelingsrekening','L','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'553000','KBC40','A','55', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'613180','Assurance RC professionnelle','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'452500','PrÃcompte immobilier - Onroerende voorhoeffing','L','45', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'554000','KBC83','A','55', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'612150','Frais postaux','E','61', NULL, false, false, string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'451545','TVA due 4e trimestre','L','451', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'200010','Fr. const. acquis. de l''exercice - Kost. opricht./kap.verh. dit boekjaar','A','20', NULL, false, false, string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'451542','TVA due 1er trimestre (case 54)','L','451', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'451570','TVA DUE SUR IMPORTATIONS','L','451', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'540','ChÃques Ã encaisser - Te incasseren chÃques','A','54', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'611340','Entretiens & rÃparations locaux','E','61', NULL, false, false, string_to_array('AR_amount:AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'665000','Pertes et charges diverses','E','66', NULL, false, false, string_to_array('AR_paid:AP_amount', ':'));
+SELECT account_save(NULL,'665200','Perte dÃfinitive crÃance douteuse','E','66', NULL, false, false, string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'237010','Outillage acquisition exercice - Uitrusting m.b.t. dit boekj.','A','23', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'623600','VÃtements de travail employÃs','E','62', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'612520','Emballages perdus','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'240200','Mat. informatique acquis anterieurs - Hardware m.b.t. vorig boekj.','A','24', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'240210','MatÃriel informatique acquis. exercice - Hardware m.b.t. dit boekj.','A','24', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'260000','Amenagement locaux louÃs acquis anterieurs - Inrichtingskost. m.b.t. vorig boekj.','A','26', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'240000','Mobilier acquis. anterieurs - Meubilair m.b.t. vorig boekj.','A','24', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'240010','Mobilier acquis. exercice - Meubilair m.b.t. dit boekj.','A','24', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'240110','Mat. bureau acquis. exercice - Bureaumaterieel m.b.t. dit boekj.','A','24', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'240100','Mat. bureau acquis. anterieurs - Bureaumaterieel m.b.t. vorig boekj.','A','24', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'241000','Voiture acquis. anterieurs - Wagen m.b.t. vorig boekj.','A','24', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'241010','Voiture acquis. exercice - Wagen m.b.t. dit boekj. ','A','24', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
 SELECT account_heading_save(NULL, '57', 'Caisses - Kassen', NULL);
-SELECT account_save(NULL,'510200','TitrÃs non-cotÃs - Aandelen niet op beurs','A','51', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'510090','RÃduct. valeur actÃes (-) - Geb. waardev. aandelen (-)','A','51', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'510210','	Montants non-appelÃs (-) - Niet opgevraagde bedragen aan. (-)','A','51', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'510290','RÃduct. valeur actÃes (-) - Geb. waardev. aandelen (-) ','A','51', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'614700','Frais de bonne politique','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'615000','Sous-traitants','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'630000','Amort.s/frais.constit.&aug.capi - Afschr.o.opricht./kapitaalverhoging','E','63', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'630210','Amort.s/constructions - Afschr. op gebouwen','E','63', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'630200','Amort.s/installations - Afschr. op installaties','E','63', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'630220','Amort.s/machines - Afschr. op machines','E','63', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'630221','Amort.s/outillage - Afschr. op uitrusting','E','63', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'630222','Amort.s/mobilier - Afschr. op meubilair','E','63', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'630223','Amort.s/mat.bureau - Afschr. op bureaumaterieel','E','63', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'630224','Amort.s/mat.informatique - Afschr. op hardware','E','63', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'630230','Amort.s/voitures - Afschr. op wagens','E','63', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'640000','Taxes circl. voitures - Belasting wagens','E','64', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'652000','Moins-value sur rÃalisation d''actifs circulants','E','65', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'640020','PrÃcompte immoblier - Onroerende voorhoeffing','E','64', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'640100','Timbres fiscaux','E','64', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'640230','Raccordement aux egouts','E','64', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'640310','Cotisation dÃpannage','E','64', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'630225','Amort.s/amÃn. locaux - Afschr. op inrichtingskost','E','63', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'650000','IntÃrÃts comm. & frais s/decouvert','E','65', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'656300','IntÃrÃts de retards fiscaux - Fiscale achterst. interest','E','65', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'693000','BÃnÃfice Ã reporter','E','69', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'663750','-Val.s/materiel informatique','E','66', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'743300','Intervention assurance salaires garant.','I','74', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'763750','+Val.s/mat.informatique','I','76', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'406','Acomptes versÃs - Vooruitbetalingen','A','40', NULL, '0',string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'510200','TitrÃs non-cotÃs - Aandelen niet op beurs','A','51', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'510090','RÃduct. valeur actÃes (-) - Geb. waardev. aandelen (-)','A','51', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'510210','	Montants non-appelÃs (-) - Niet opgevraagde bedragen aan. (-)','A','51', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'510290','RÃduct. valeur actÃes (-) - Geb. waardev. aandelen (-) ','A','51', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'614700','Frais de bonne politique','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'615000','Sous-traitants','E','61', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'630000','Amort.s/frais.constit.&aug.capi - Afschr.o.opricht./kapitaalverhoging','E','63', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'630210','Amort.s/constructions - Afschr. op gebouwen','E','63', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'630200','Amort.s/installations - Afschr. op installaties','E','63', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'630220','Amort.s/machines - Afschr. op machines','E','63', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'630221','Amort.s/outillage - Afschr. op uitrusting','E','63', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'630222','Amort.s/mobilier - Afschr. op meubilair','E','63', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'630223','Amort.s/mat.bureau - Afschr. op bureaumaterieel','E','63', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'630224','Amort.s/mat.informatique - Afschr. op hardware','E','63', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'630230','Amort.s/voitures - Afschr. op wagens','E','63', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'640000','Taxes circl. voitures - Belasting wagens','E','64', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'652000','Moins-value sur rÃalisation d''actifs circulants','E','65', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'640020','PrÃcompte immoblier - Onroerende voorhoeffing','E','64', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'640100','Timbres fiscaux','E','64', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'640230','Raccordement aux egouts','E','64', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'640310','Cotisation dÃpannage','E','64', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'630225','Amort.s/amÃn. locaux - Afschr. op inrichtingskost','E','63', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'650000','IntÃrÃts comm. & frais s/decouvert','E','65', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'656300','IntÃrÃts de retards fiscaux - Fiscale achterst. interest','E','65', NULL, false, false, string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'693000','BÃnÃfice Ã reporter','E','69', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'663750','-Val.s/materiel informatique','E','66', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'743300','Intervention assurance salaires garant.','I','74', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'763750','+Val.s/mat.informatique','I','76', NULL, false, false, string_to_array('', ':'));
+SELECT account_save(NULL,'406','Acomptes versÃs - Vooruitbetalingen','A','40', NULL, false, false, string_to_array('AP_paid', ':'));
 --
 INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '411590'), 0.06);
 INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '411591'), 0.21);


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:[3393] trunk/dists/deb/ubuntu/ubuntu.sh
Next by Date: SF.net SVN: ledger-smb:[3395] trunk
Previous by thread: SF.net SVN: ledger-smb:[3393] trunk/dists/deb/ubuntu/ubuntu.sh
Next by thread: SF.net SVN: ledger-smb:[3395] trunk
Index(es):
- Date
- Thread