[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb:[2642] trunk/sql/coa
- Subject: SF.net SVN: ledger-smb:[2642] trunk/sql/coa
- From: ..hidden..
- Date: Fri, 12 Jun 2009 01:35:38 +0000
Revision: 2642
http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2642&view=rev
Author: einhverfr
Date: 2009-06-12 01:35:37 +0000 (Fri, 12 Jun 2009)
Log Message:
-----------
Canadian chart conversions
Modified Paths:
--------------
trunk/sql/coa/Sample-chart.sql
trunk/sql/coa/at/chart/General.sql
trunk/sql/coa/be/chart/General.sql
trunk/sql/coa/br/chart/General.sql
trunk/sql/coa/ca/chart/English_General.sql
trunk/sql/coa/ca/chart/French-Quebec_General.sql
Modified: trunk/sql/coa/Sample-chart.sql
===================================================================
--- trunk/sql/coa/Sample-chart.sql 2009-06-12 00:33:44 UTC (rev 2641)
+++ trunk/sql/coa/Sample-chart.sql 2009-06-12 01:35:37 UTC (rev 2642)
@@ -1,74 +1,74 @@
begin;
-- Default chart of accounts
-- sample only
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1000','CURRENT ASSETS','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1060','Checking Account','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1065','Petty Cash','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1200','Accounts Receivables','A','','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1205','Allowance for doubtful accounts','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1500','INVENTORY ASSETS','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1520','Inventory / General','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1530','Inventory / Aftermarket Parts','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1800','CAPITAL ASSETS','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1820','Office Furniture & Equipment','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('1825','Accum. Amort. -Furn. & Equip.','A','','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1840','Vehicle','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('1845','Accum. Amort. -Vehicle','A','','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2000','CURRENT LIABILITIES','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2100','Accounts Payable','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2160','Corporate Taxes Payable','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2190','Federal Income Tax Payable','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2210','Workers Comp Payable','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2220','Vacation Pay Payable','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2250','Pension Plan Payable','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2260','Employment Insurance Payable','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2280','Payroll Taxes Payable','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2310','VAT (10%)','A','','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2320','VAT (14%)','A','','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2330','VAT (30%)','A','','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2600','LONG TERM LIABILITIES','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2620','Bank Loans','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2680','Loans from Shareholders','A','','L','AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3300','SHARE CAPITAL','H','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3350','Common Shares','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4000','SALES REVENUE','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4020','Sales / General','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4030','Sales / Aftermarket Parts','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4300','CONSULTING REVENUE','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4320','Consulting','A','','I','AR_amount:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4400','OTHER REVENUE','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4430','Shipping & Handling','A','','I','IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4440','Interest','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4450','Foreign Exchange Gain','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5000','COST OF GOODS SOLD','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5010','Purchases','A','','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5020','COGS / General','A','','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5030','COGS / Aftermarket Parts','A','','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5100','Freight','A','','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5400','PAYROLL EXPENSES','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5410','Wages & Salaries','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5420','Employment Insurance Expense','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5430','Pension Plan Expense','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5440','Workers Comp Expense','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5470','Employee Benefits','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5600','GENERAL & ADMINISTRATIVE EXPENSES','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5610','Accounting & Legal','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5615','Advertising & Promotions','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5620','Bad Debts','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5650','Capital Cost Allowance Expense','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5660','Amortization Expense','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5680','Income Taxes','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5685','Insurance','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5690','Interest & Bank Charges','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5700','Office Supplies','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5760','Rent','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5765','Repair & Maintenance','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5780','Telephone','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5785','Travel & Entertainment','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5790','Utilities','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5795','Registrations','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5800','Licenses','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5810','Foreign Exchange Loss','A','','E','');
+SELECT account_heading_save(NULL, '1000', 'CURRENT ASSETS', NULL);
+SELECT account_save(NULL,'1060','Checking Account','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1065','Petty Cash','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1200','Accounts Receivables','A','', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'1205','Allowance for doubtful accounts','A','', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '1500', 'INVENTORY ASSETS', NULL);
+SELECT account_save(NULL,'1520','Inventory / General','A','', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1530','Inventory / Aftermarket Parts','A','', NULL, false,string_to_array('IC', ':'));
+SELECT account_heading_save(NULL, '1800', 'CAPITAL ASSETS', NULL);
+SELECT account_save(NULL,'1820','Office Furniture & Equipment','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1825','Accum. Amort. -Furn. & Equip.','A','', NULL, true,string_to_array('','1', ':'));
+SELECT account_save(NULL,'1840','Vehicle','A','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1845','Accum. Amort. -Vehicle','A','', NULL, true,string_to_array('','1', ':'));
+SELECT account_heading_save(NULL, '2000', 'CURRENT LIABILITIES', NULL);
+SELECT account_save(NULL,'2100','Accounts Payable','L','', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'2160','Corporate Taxes Payable','L','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2190','Federal Income Tax Payable','L','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2210','Workers Comp Payable','L','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2220','Vacation Pay Payable','L','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2250','Pension Plan Payable','L','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2260','Employment Insurance Payable','L','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2280','Payroll Taxes Payable','L','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2310','VAT (10%)','L','', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'2320','VAT (14%)','L','', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'2330','VAT (30%)','L','', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_heading_save(NULL, '2600', 'LONG TERM LIABILITIES', NULL);
+SELECT account_save(NULL,'2620','Bank Loans','L','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2680','Loans from Shareholders','L','', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_heading_save(NULL, '3300', 'SHARE CAPITAL', NULL);
+SELECT account_save(NULL,'3350','Common Shares','Q','', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '4000', 'SALES REVENUE', NULL);
+SELECT account_save(NULL,'4020','Sales / General','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_save(NULL,'4030','Sales / Aftermarket Parts','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_heading_save(NULL, '4300', 'CONSULTING REVENUE', NULL);
+SELECT account_save(NULL,'4320','Consulting','I','', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_heading_save(NULL, '4400', 'OTHER REVENUE', NULL);
+SELECT account_save(NULL,'4430','Shipping & Handling','I','', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'4440','Interest','I','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4450','Foreign Exchange Gain','I','', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '5000', 'COST OF GOODS SOLD', NULL);
+SELECT account_save(NULL,'5010','Purchases','E','', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'5020','COGS / General','E','', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_save(NULL,'5030','COGS / Aftermarket Parts','E','', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_save(NULL,'5100','Freight','E','', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_heading_save(NULL, '5400', 'PAYROLL EXPENSES', NULL);
+SELECT account_save(NULL,'5410','Wages & Salaries','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5420','Employment Insurance Expense','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5430','Pension Plan Expense','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5440','Workers Comp Expense','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5470','Employee Benefits','E','', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '5600', 'GENERAL & ADMINISTRATIVE EXPENSES', NULL);
+SELECT account_save(NULL,'5610','Accounting & Legal','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5615','Advertising & Promotions','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5620','Bad Debts','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5650','Capital Cost Allowance Expense','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5660','Amortization Expense','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5680','Income Taxes','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5685','Insurance','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5690','Interest & Bank Charges','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5700','Office Supplies','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5760','Rent','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5765','Repair & Maintenance','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5780','Telephone','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5785','Travel & Entertainment','E','', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5790','Utilities','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5795','Registrations','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5800','Licenses','E','', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5810','Foreign Exchange Loss','E','', NULL, false,string_to_array('', ':'));
--
insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.1);
insert into tax (chart_id,rate) values ((select id from chart where accno = '2320'),0.14);
Modified: trunk/sql/coa/at/chart/General.sql
===================================================================
--- trunk/sql/coa/at/chart/General.sql 2009-06-12 00:33:44 UTC (rev 2641)
+++ trunk/sql/coa/at/chart/General.sql 2009-06-12 01:35:37 UTC (rev 2642)
@@ -3,138 +3,138 @@
-- Ferdinand Gassauer, Tue, 5 Feb 2002
-- checked and completed, Thu, 7 Feb 2002, Dieter Simader
--
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0000','AUFWENDUNGEN FÃR INGANGSETZEN UND ERWEITERN DES BETRIEBES','H','00','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0010','Firmenwert','A','015','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0100','IMMATERIELLE VERMÃGENSGEGENSTÃNDE','H','01','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0110','Rechte','A','011','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0200','GRUNDSTÃCKE','H','02-03','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0210','unbebaute GrundstÃcke','A','020','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0220','bebaute GrundstÃcke','A','021','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('0229','kum. Abschreibung bebaute GrundstÃcke','A','039','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0400','MASCHINEN','H','04-05','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0410','Maschinen','A','041','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('0419','kum. Abschreibung Maschinen','A','069','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0500','FAHRZEUGE','H','06','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0510','Fahrzeuge','A','063','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('0519','kum. Abschreibung Fahrzeuge','A','069','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0600','BETRIEBS- UND GESCHÃFTSAUSSTATTUNG','H','06','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0620','BÃroeinrichtungen','A','066','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('0625','kum. Abschreibung Betriebs- und GeschÃftsausstattung','A','069','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0700','GELEISTETE ANZAHLUNGEN','H','07','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0800','FINANZANLAGEN','H','08-09','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0810','Beteiligungen','A','081','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0820','Wertpapiere','A','080','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1100','ROHSTOFFE','H','1','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1120','VorrÃte - Rohstoffe','A','110-119','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1200','BEZOGENE TEILE','H','1','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1220','VorrÃte - bezogene Teile','A','120-129','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1300','HILFS- UND BETRIEBSSTOFFE','H','1','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1320','Hilfsstoffe','A','130-134','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1350','Betriebssstoffe','A','135-139','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1400','UNFERTIGE ERZEUGNISSE','H','1','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1420','VorrÃte - unfertige Erzeugnisse','A','140-149','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1500','FERTIGE ERZEUGNISSE','H','1','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1520','VorrÃte - Hardware','A','150-159','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1530','VorrÃte - Software','A','150-159','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1540','VorrÃte - Ersatzteile','A','150-159','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1600','WAREN','H','1','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1700','NOCH NICHT ABGERECHNETE LEISTUNGEN','H','1','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1800','GELEISTETE ANZAHLUNGEN','H','1','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1900','WERTBERICHTIGUNGEN','H','1','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2000','FORDEUNGEN AUS LIEFERUNGEN UND LEISTUNGEN','H','2','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2010','Forderungen Lieferung & Leistung','A','200-207','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2019','Wertberichtigung uneinbringliche Forderungen','A','20-21','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2300','SONSTIGE FORDERUNGEN','H','2','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2320','sonstige Forderungen','A','23-24','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2500','FORDERUNGEN AUS ABGABENVERRECHNUNG','H','2','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2520','sonstige Forderungen aus Abgebenverrechnung','A','25','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2600','WERTPAPIERE UND ANTEILE','H','2','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2620','Wertpapiere UmlaufvermÃgen','A','26','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2700','KASSABESTAND','H','2','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2701','Kassa','A','27-28','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2800','SCHECKS, GUTHABEN BEI KREDITINSTITUTEN','H','2','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2810','Schecks','A','27-28','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2820','Bankguthaben','A','280-288','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3100','LANGFRISTIGE VERBINDLICHKEITEN','H','3','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3110','Bank Verbindlichkeiten','A','31','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3120','Kredite von EigentÃmern','A','310','L','AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3300','VERBINDLICHKEITEN AUS LIEFERUNGEN UND LEISTUNGEN','H','33','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3310','Verbindlichkeiten aus Lieferungen und Leistungen','A','330-335','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3500','VERBINDLICHKEITEN FINANZAMT','H','35','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3510','Finanzamt Verrechnung KÃrperschaftssteuer','A','350-359','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3520','Finanzamt Verrechnung Umsatzsteuer','A','350-359','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3530','Mehrwertsteuer 0%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3531','Mehrwertsteuer 10%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3532','Mehrwertsteuer 20%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3540','Vorsteuer 0%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3541','Vorsteuer 10%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3542','Vorsteuer 20%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4000','UMSATZ','H','4','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4020','Verkauf - Hardware','A','40-44','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4030','Verkauf - Software ','A','40-44','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4040','Verkauf - Ersatzteile','A','40-44','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4300','UMSATZ BERATUNG','H','4','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4320','ErlÃse Beratung','A','40-44','I','AR_amount:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4330','ErlÃse Programmierung','A','40-44','I','AR_amount:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4600','SONSTIGE ERLÃSE','H','4','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4630','FrachterlÃse','A','46-49','I','IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5000','WARENEINSATZ','H','5','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5020','Wareneinsatz / Hardware','A','500-509','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5030','Wareneinsatz / Software','A','500-509','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5040','Wareneinsatz / Ersatzteile','A','520-529','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5600','VERBRAUCH BRENN- UND TREIBSTOFFEN, ENERGIE UND WASSER','H','5','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5610','Energie, Wasser','A','560-569','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6000','LOHNAUFWAND','H','6','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6010','Lohn ','A','600-619','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6200','GEAHLTSAUFWAND','H','6','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6210','Gehalt ','A','620-639','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6500','GESETZLICHER SOZIALAUFWAND','H','6','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6510','Dienstgeberanteile','A','645-649','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6700','FREIWILLIGER SOZIALAUFWAND','H','6','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6710','freiwilliger Sozialaufwand','A','660-665','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7000','ABSCHREIBUNGEN','H','7','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7010','Abschreibungen','A','700','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7020','geringwertige WirtschaftsgÃter','A','701-708','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7100','SONSTIGE STEUERN','H','71','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7110','Ertragssteuern','A','710-719','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7120','Grundsteuern','A','710-719','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7200','INSTANDHALTUNGSAUFWAND','H','7','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7210','Reparatur und Instandhaltung','A','720-729','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7300','TRANSPORTKOSTEN','H','73','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7310','Frachtaufwand','A','730-731','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7400','MIET-,PACHT-,LEASING-, LIZENZAUFWAND','H','74','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7410','Miete','A','740-743','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7411','Lizenzen','A','748-749','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7600','VERWALTUNGSKOSTEN','H','76','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7610','Beratungsaufwand','A','775-776','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7611','BÃromaterialien','A','760','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7615','Werbung und Marketing','A','765-768','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7620','uneinbringliche Forderungen','A','799','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7630','Telephonkosten','A','738-739','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7631','Internetkosten','A','738-739','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7632','Reise- und ReprÃsentationsaufwand','A','734-735','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7634','RegistrierungsgebÃhren','A','748-749','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7700','VERSICHERUNGEN','H','77-78','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7710','Versicherung','A','770-774','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8000','FINANZERTRÃGE UND FINANZAUFWENDUNGEN','H','8','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8020','Bankzinsen und GebÃhren','A','80-83','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8100','BETEILIGUNGSERTRÃGE','H','8','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8110','ErtrÃge aus Beteiligungen','A','800-804','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9000','KAPITAL','H','9','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9010','Aktien, GeschÃftsanteile','A','900-918','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9020','nicht einbezahltes Kapital','A','919','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9200','KAPITALRÃCKLAGEN','H','9','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9210','freie RÃcklage','A','920-929','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9300','GEWINN','H','939','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9310','Gewinnvortrag Vorjahr','A','980','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9320','Jahresgewinn','A','985','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9400','RÃCKSTELLUNGEN','H','3','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9420','AbfertigungsrÃckstellung','A','300','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9430','UrlaubsrÃckstellung','A','304-309','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9700','EINLAGEN STILLER GESELLSCHAFTER','H','9','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9800','EB,SB,G+V KONTEN','H','9','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4640','Devisengewinne','A','80-83','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8050','Devisenverluste','A','80-83','E','');
+SELECT account_heading_save(NULL, '0000', 'AUFWENDUNGEN FÃR INGANGSETZEN UND ERWEITERN DES BETRIEBES', NULL);
+SELECT account_save(NULL,'0010','Firmenwert','A','015', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_heading_save(NULL, '0100', 'IMMATERIELLE VERMÃGENSGEGENSTÃNDE', NULL);
+SELECT account_save(NULL,'0110','Rechte','A','011', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_heading_save(NULL, '0200', 'GRUNDSTÃCKE', NULL);
+SELECT account_save(NULL,'0210','unbebaute GrundstÃcke','A','020', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0220','bebaute GrundstÃcke','A','021', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0229','kum. Abschreibung bebaute GrundstÃcke','A','039', NULL, true,string_to_array('','1', ':'));
+SELECT account_heading_save(NULL, '0400', 'MASCHINEN', NULL);
+SELECT account_save(NULL,'0410','Maschinen','A','041', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0419','kum. Abschreibung Maschinen','A','069', NULL, true,string_to_array('','1', ':'));
+SELECT account_heading_save(NULL, '0500', 'FAHRZEUGE', NULL);
+SELECT account_save(NULL,'0510','Fahrzeuge','A','063', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0519','kum. Abschreibung Fahrzeuge','A','069', NULL, true,string_to_array('','1', ':'));
+SELECT account_heading_save(NULL, '0600', 'BETRIEBS- UND GESCHÃFTSAUSSTATTUNG', NULL);
+SELECT account_save(NULL,'0620','BÃroeinrichtungen','A','066', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0625','kum. Abschreibung Betriebs- und GeschÃftsausstattung','A','069', NULL, true,string_to_array('','1', ':'));
+SELECT account_heading_save(NULL, '0700', 'GELEISTETE ANZAHLUNGEN', NULL);
+SELECT account_heading_save(NULL, '0800', 'FINANZANLAGEN', NULL);
+SELECT account_save(NULL,'0810','Beteiligungen','A','081', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0820','Wertpapiere','A','080', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_heading_save(NULL, '1100', 'ROHSTOFFE', NULL);
+SELECT account_save(NULL,'1120','VorrÃte - Rohstoffe','A','110-119', NULL, false,string_to_array('IC', ':'));
+SELECT account_heading_save(NULL, '1200', 'BEZOGENE TEILE', NULL);
+SELECT account_save(NULL,'1220','VorrÃte - bezogene Teile','A','120-129', NULL, false,string_to_array('IC', ':'));
+SELECT account_heading_save(NULL, '1300', 'HILFS- UND BETRIEBSSTOFFE', NULL);
+SELECT account_save(NULL,'1320','Hilfsstoffe','A','130-134', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1350','Betriebssstoffe','A','135-139', NULL, false,string_to_array('IC', ':'));
+SELECT account_heading_save(NULL, '1400', 'UNFERTIGE ERZEUGNISSE', NULL);
+SELECT account_save(NULL,'1420','VorrÃte - unfertige Erzeugnisse','A','140-149', NULL, false,string_to_array('IC', ':'));
+SELECT account_heading_save(NULL, '1500', 'FERTIGE ERZEUGNISSE', NULL);
+SELECT account_save(NULL,'1520','VorrÃte - Hardware','A','150-159', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1530','VorrÃte - Software','A','150-159', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1540','VorrÃte - Ersatzteile','A','150-159', NULL, false,string_to_array('IC', ':'));
+SELECT account_heading_save(NULL, '1600', 'WAREN', NULL);
+SELECT account_heading_save(NULL, '1700', 'NOCH NICHT ABGERECHNETE LEISTUNGEN', NULL);
+SELECT account_heading_save(NULL, '1800', 'GELEISTETE ANZAHLUNGEN', NULL);
+SELECT account_heading_save(NULL, '1900', 'WERTBERICHTIGUNGEN', NULL);
+SELECT account_heading_save(NULL, '2000', 'FORDEUNGEN AUS LIEFERUNGEN UND LEISTUNGEN', NULL);
+SELECT account_save(NULL,'2010','Forderungen Lieferung & Leistung','A','200-207', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'2019','Wertberichtigung uneinbringliche Forderungen','A','20-21', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '2300', 'SONSTIGE FORDERUNGEN', NULL);
+SELECT account_save(NULL,'2320','sonstige Forderungen','A','23-24', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_heading_save(NULL, '2500', 'FORDERUNGEN AUS ABGABENVERRECHNUNG', NULL);
+SELECT account_save(NULL,'2520','sonstige Forderungen aus Abgebenverrechnung','A','25', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_heading_save(NULL, '2600', 'WERTPAPIERE UND ANTEILE', NULL);
+SELECT account_save(NULL,'2620','Wertpapiere UmlaufvermÃgen','A','26', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_heading_save(NULL, '2700', 'KASSABESTAND', NULL);
+SELECT account_save(NULL,'2701','Kassa','A','27-28', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_heading_save(NULL, '2800', 'SCHECKS, GUTHABEN BEI KREDITINSTITUTEN', NULL);
+SELECT account_save(NULL,'2810','Schecks','A','27-28', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'2820','Bankguthaben','A','280-288', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_heading_save(NULL, '3100', 'LANGFRISTIGE VERBINDLICHKEITEN', NULL);
+SELECT account_save(NULL,'3110','Bank Verbindlichkeiten','L','31', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3120','Kredite von EigentÃmern','L','310', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_heading_save(NULL, '3300', 'VERBINDLICHKEITEN AUS LIEFERUNGEN UND LEISTUNGEN', NULL);
+SELECT account_save(NULL,'3310','Verbindlichkeiten aus Lieferungen und Leistungen','L','330-335', NULL, false,string_to_array('AP', ':'));
+SELECT account_heading_save(NULL, '3500', 'VERBINDLICHKEITEN FINANZAMT', NULL);
+SELECT account_save(NULL,'3510','Finanzamt Verrechnung KÃrperschaftssteuer','L','350-359', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3520','Finanzamt Verrechnung Umsatzsteuer','L','350-359', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3530','Mehrwertsteuer 0%','L','350-359', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'3531','Mehrwertsteuer 10%','L','350-359', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'3532','Mehrwertsteuer 20%','L','350-359', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'3540','Vorsteuer 0%','L','350-359', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'3541','Vorsteuer 10%','L','350-359', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'3542','Vorsteuer 20%','L','350-359', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_heading_save(NULL, '4000', 'UMSATZ', NULL);
+SELECT account_save(NULL,'4020','Verkauf - Hardware','I','40-44', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_save(NULL,'4030','Verkauf - Software ','I','40-44', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_save(NULL,'4040','Verkauf - Ersatzteile','I','40-44', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_heading_save(NULL, '4300', 'UMSATZ BERATUNG', NULL);
+SELECT account_save(NULL,'4320','ErlÃse Beratung','I','40-44', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'4330','ErlÃse Programmierung','I','40-44', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_heading_save(NULL, '4600', 'SONSTIGE ERLÃSE', NULL);
+SELECT account_save(NULL,'4630','FrachterlÃse','I','46-49', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_heading_save(NULL, '5000', 'WARENEINSATZ', NULL);
+SELECT account_save(NULL,'5020','Wareneinsatz / Hardware','E','500-509', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_save(NULL,'5030','Wareneinsatz / Software','E','500-509', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_save(NULL,'5040','Wareneinsatz / Ersatzteile','E','520-529', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_heading_save(NULL, '5600', 'VERBRAUCH BRENN- UND TREIBSTOFFEN, ENERGIE UND WASSER', NULL);
+SELECT account_save(NULL,'5610','Energie, Wasser','E','560-569', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_heading_save(NULL, '6000', 'LOHNAUFWAND', NULL);
+SELECT account_save(NULL,'6010','Lohn ','E','600-619', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '6200', 'GEAHLTSAUFWAND', NULL);
+SELECT account_save(NULL,'6210','Gehalt ','E','620-639', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '6500', 'GESETZLICHER SOZIALAUFWAND', NULL);
+SELECT account_save(NULL,'6510','Dienstgeberanteile','E','645-649', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '6700', 'FREIWILLIGER SOZIALAUFWAND', NULL);
+SELECT account_save(NULL,'6710','freiwilliger Sozialaufwand','E','660-665', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '7000', 'ABSCHREIBUNGEN', NULL);
+SELECT account_save(NULL,'7010','Abschreibungen','E','700', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'7020','geringwertige WirtschaftsgÃter','E','701-708', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_heading_save(NULL, '7100', 'SONSTIGE STEUERN', NULL);
+SELECT account_save(NULL,'7110','Ertragssteuern','E','710-719', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'7120','Grundsteuern','E','710-719', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '7200', 'INSTANDHALTUNGSAUFWAND', NULL);
+SELECT account_save(NULL,'7210','Reparatur und Instandhaltung','E','720-729', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_heading_save(NULL, '7300', 'TRANSPORTKOSTEN', NULL);
+SELECT account_save(NULL,'7310','Frachtaufwand','E','730-731', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_heading_save(NULL, '7400', 'MIET-,PACHT-,LEASING-, LIZENZAUFWAND', NULL);
+SELECT account_save(NULL,'7410','Miete','E','740-743', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'7411','Lizenzen','E','748-749', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_heading_save(NULL, '7600', 'VERWALTUNGSKOSTEN', NULL);
+SELECT account_save(NULL,'7610','Beratungsaufwand','E','775-776', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'7611','BÃromaterialien','E','760', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'7615','Werbung und Marketing','E','765-768', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'7620','uneinbringliche Forderungen','E','799', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'7630','Telephonkosten','E','738-739', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'7631','Internetkosten','E','738-739', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'7632','Reise- und ReprÃsentationsaufwand','E','734-735', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'7634','RegistrierungsgebÃhren','E','748-749', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_heading_save(NULL, '7700', 'VERSICHERUNGEN', NULL);
+SELECT account_save(NULL,'7710','Versicherung','E','770-774', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_heading_save(NULL, '8000', 'FINANZERTRÃGE UND FINANZAUFWENDUNGEN', NULL);
+SELECT account_save(NULL,'8020','Bankzinsen und GebÃhren','E','80-83', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '8100', 'BETEILIGUNGSERTRÃGE', NULL);
+SELECT account_save(NULL,'8110','ErtrÃge aus Beteiligungen','I','800-804', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '9000', 'KAPITAL', NULL);
+SELECT account_save(NULL,'9010','Aktien, GeschÃftsanteile','Q','900-918', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'9020','nicht einbezahltes Kapital','Q','919', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '9200', 'KAPITALRÃCKLAGEN', NULL);
+SELECT account_save(NULL,'9210','freie RÃcklage','Q','920-929', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '9300', 'GEWINN', NULL);
+SELECT account_save(NULL,'9310','Gewinnvortrag Vorjahr','Q','980', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'9320','Jahresgewinn','Q','985', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '9400', 'RÃCKSTELLUNGEN', NULL);
+SELECT account_save(NULL,'9420','AbfertigungsrÃckstellung','L','300', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'9430','UrlaubsrÃckstellung','L','304-309', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '9700', 'EINLAGEN STILLER GESELLSCHAFTER', NULL);
+SELECT account_heading_save(NULL, '9800', 'EB,SB,G+V KONTEN', NULL);
+SELECT account_save(NULL,'4640','Devisengewinne','I','80-83', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'8050','Devisenverluste','E','80-83', NULL, false,string_to_array('', ':'));
--
insert into tax (chart_id,rate) values ((select id from chart where accno = '3530'),0.00);
insert into tax (chart_id,rate) values ((select id from chart where accno = '3531'),0.10);
Modified: trunk/sql/coa/be/chart/General.sql
===================================================================
--- trunk/sql/coa/be/chart/General.sql 2009-06-12 00:33:44 UTC (rev 2641)
+++ trunk/sql/coa/be/chart/General.sql 2009-06-12 01:35:37 UTC (rev 2642)
@@ -3,427 +3,428 @@
-- contribu. par Jens-Ingo Brodesser, ..hidden..
-- verified May 19, 2006
--
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('756000', 'Produits financiers divers', 'A', 'I', 'AR_paid:AP_paid', '75', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('555000', 'DEX02', 'A', 'A', 'AR_paid:AP_paid', '55', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('499200', 'Compte de repartition NDC - Verdelingsrekening CN', 'A', 'L', 'AR_paid:AP_paid', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('460', 'Acomptes reÃus sur commandes', 'A', 'L', 'AR_paid', '46', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('4168', 'Rabais, ristournes, remises à obtenir et autres avoirs non encore reÃus', 'A', 'A', 'AP_paid', '416', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('43', 'Dettes financiÃres - FinanciÃle schulden', 'H', 'L', '', '43', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('2400', 'Mobilier - Meubilair', 'A', 'A', '', '24', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('240190', 'MatÃriel bureau amort. anterieurs - Afschr. op bureaumaterieel vorig boekj.', 'A', 'A', '', '24', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('221900', 'Constructions amort. anterieurs - Afschr. op gebouwen vorig boekj.', 'A', 'A', '', '22', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('221910', 'Constructions amort. de l''exercice - Afschr. op gebouwen dit boekj.', 'A', 'A', '', '22', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('75', 'Produits financiers - FinanciÃle opbrengsten', 'H', 'I', '', '75', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('230900', 'Inst. techniques amort. anterieurs - Afschr. op installaties vorig boekj.', 'A', 'A', '', '23', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('240090', 'Mobilier amort. anter. - Afschr. op meubilair vorig boekj.', 'A', 'A', '', '24', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('240091', 'Mobilier amort. exercice - Afschr. op meubilair dit boekj.', 'A', 'A', '', '24', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('240191', 'MatÃriel bureau amort. exercice - Afschr. op bureaumaterieel dit boekj.', 'A', 'A', '', '24', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('240290', 'Materiel Informatique amort. anter. - Afschr. op hardware vorig boekj.', 'A', 'A', '', '24', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('240291', 'Mat. informat. amort. exercice - Afschr. op hardware dit boekj.', 'A', 'A', '', '24', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('241900', 'Voiture amort. anter. - Afschr. op wagen vorig boekj.', 'A', 'A', '', '24', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('241910', 'Voiture amort. exercice - Afschr. op wagen dit boekj. ', 'A', 'A', '', '24', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('260900', 'Amen. loc. louÃs amort. anter. - Inrichtingskost. vorig boekj.', 'A', 'A', '', '26', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('230910', 'Inst. techniques amort. exercice - Afschr. op installaties dit boekj.', 'A', 'A', '', '23', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('231900', 'Mach. et gros mat. amort. anterieurs - Afschr. op machines vorig boekj.', 'A', 'A', '', '23', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('231910', 'Mach. et gros mat. amort. exercice - Afschr. op machines dit boekj.', 'A', 'A', '', '23', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('237900', 'Outillage amort. anterieurs - Afschr. op uitrusting vorig boekj.', 'A', 'A', '', '23', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('237910', 'Outillage amort. exercice - Afschr. op uitrusting dit boekj.', 'A', 'A', '', '23', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('260910', 'Amen. loc. louÃs amort. exercice - Inrichtingskost. dit boekj.', 'A', 'A', '', '26', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('451541', 'TVA DUE VENTES 21%', 'A', 'L', 'AR_tax:IC_taxpart:IC_taxservice', '451', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612200', 'Carburants voitures', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('630', 'Dotations amort., rÃduction valeur s/immo. - Afschr., waardeverm. op v. a., toevoeging', 'A', 'E', '', '63', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613210', 'Honoraires avocats', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('712', 'Des encours de fabrication - In de vooraad goederen in bewerking', 'A', 'I', 'IC_sale', '71', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('600', 'Achats matiÃres premiÃres - Aankopen van grondstoffen', 'A', 'E', 'IC_cogs', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('614400', 'EntrÃe aux foires', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('742', 'Plus-values crÃances com. - Meerwaarden realis. handelsvorderingen', 'A', 'I', '', '74', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613304', 'Traiteurs-rÃception clientÃle', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('64', 'Autres charges exploitation - Andere bedrijfskosten', 'H', 'E', '', '64', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('76', 'Produits exceptionnels - Uitzonderlijke opbrengsten', 'H', 'I', '', '76', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('743000', 'Ventes diverses - Diverse bedrijfsopbrengsten', 'A', 'I', '', '74', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('760100', 'sur immobilisations corp. - op materiÃle vaste activa', 'A', 'I', '', '760', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('611150', 'Charges locatives voitures', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('771200', 'Reprises de provisions fiscales - Terugn. fiscale voorz.', 'A', 'I', '', '771', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('794', 'Intervention associà perte - Tussenkomst vennoten verlies', 'A', 'I', '', '79', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('404', 'Produits à recevoir - Te innen opbrengsten', 'A', 'A', '', '40', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('500', 'Action propres - Eigen aandelen', 'A', 'A', '', '50', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('41', 'Autres crÃances - Overige vorderingen', 'H', 'A', '', '41', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('407', 'CrÃances douteuses - Dubieuze debiteuren', 'A', 'A', 'AR_paid', '40', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('442001', 'Fournisseurs essence', 'A', 'L', 'AP', '44', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('608', 'Remises ristournes rabais obtenus - Ontvangen kortingen ristorno''s en rabatten (-)', 'A', 'E', 'IC_cogs', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612140', 'Internet', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('50', 'Actions propres - Eigen aandelen', 'H', 'A', '', '50', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('6', 'CLASSE 6 -- CHARGES - KOSTEN', 'H', 'E', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('611350', 'Entr. & Repar. Voitures & Veh. Mixtes', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('655000', 'Ecarts de conversion de devises', 'A', 'E', 'AR_paid:IC_sale:IC_expense', '65', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('451560', 'TVA DUE CO-CONTRACTANT', 'A', 'L', '', '451', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('609000', 'de matiÃres premiÃres - van grondstofen', 'A', 'E', '', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('411590', 'TVA ACHATS 6%', 'A', 'A', 'AP_tax:IC_taxpart:IC_taxservice', '411', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('411591', 'TVA ACHATS 21%', 'A', 'A', 'AP_tax:IC_taxpart:IC_taxservice', '411', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('411620', 'TVA Ã rÃgulariser (case 62)', 'A', 'A', '', '411', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('411', 'TVA A RECUPERER - TERUG TE VORDEREN BTW', 'H', 'A', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('44', 'Dettes commerciales - Handelsschulden', 'H', 'L', '', '44', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('409', 'RÃductions de valeur actÃes (-) - Geboekte waardevermindering', 'A', 'A', '', '40', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('451540', 'TVA DUE VENTES 6%', 'A', 'L', 'AR_tax:IC_taxpart:IC_taxservice', '451', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('640', 'Charges fiscales de l''exploitation - Bedrijfsbelastingen', 'A', 'E', '', '64', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('713', 'Des Produits finis - In de voorraad gereed product', 'A', 'I', 'IC_sale', '71', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('750', 'Produits immo. financiÃres - Opbrengsten financiÃle vaste activa', 'A', 'I', '', '75', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('656500', 'IntÃrÃts retards sociaux - Sociale achterst. interest', 'A', 'E', 'AP_amount:IC_expense', '65', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('755000', 'Ecarts de convers. devises - Resultats omrekening vreemde valuta', 'A', 'I', 'IC_sale:IC_income', '75', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('754000', 'DiffÃrence de change - Wisselresultaten', 'A', 'I', 'AR_amount:IC_income', '75', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('761', 'Reprises rÃduct. valeur immo. fin. - Terugneming waardeverm. fin. v. a.', 'A', 'I', '', '76', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('773', 'ImpÃts Ãtrangers s/rÃsultat - Buitenl. belasting op resultaat', 'A', 'I', '', '77', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('77', 'RÃgularisation d''impÃts, reprises provisions fiscales - Regul. belastingen en terugneming fiscale voorz.', 'H', 'I', '', '77', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('7', 'CLASSE 7 -- PRODUITS - OPBRENGSTEN', 'H', 'I', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('411640', 'TVA Ã recupÃrer s/NDC Ãmises (case 64)', 'A', 'A', '', '411', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612300', 'Abonnements & Documentations', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('410', 'Capital appelÃ, non versà - Opgevraagd, niet-gestort kapitaal', 'A', 'A', '', '41', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('417', 'CrÃances douteuses - Dubieuze debiteuren', 'A', 'A', '', '416', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('451', 'TVA A PAYER - TE BETALEN BTW', 'H', 'L', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('499000', 'Compte d''attente - Wachtrekening', 'A', 'L', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('455', 'RÃmunerations - Bezoldigingen', 'A', 'L', '', '45', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('601', 'Achat des fournitures - Aankoop van hulpstoffen', 'A', 'E', 'IC_cogs', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('49', 'Comptes de rÃgularisation - Overlopende- en wachtrekeningen', 'H', 'L', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613220', 'Honoraires notaires', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('414100', 'IndeminitÃs s/sinistres à recevoir - Te ontvang. schadevergoed.', 'A', 'A', '', '41', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('42', 'Dettes à plus d''un an Ãcheant dans l''annÃe - Schulden op meer dan ÃÃn jaar die binnen het jaar verfallen', 'H', 'L', '', '42', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613311', 'Deplacements Ãtranger train, taxi, etc', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('611151', 'Charges locatives camions/camionnettes', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('432', 'Etabli. crÃdit, crÃdits d''acceptation - Acceptkrediten', 'A', 'L', '', '43', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('433', 'Etabl. crÃdit, dettes cpt. courant - Schulden rekening courant', 'A', 'L', '', '43', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('705100', 'DNS REGISTRY', 'A', 'I', 'AR_amount:IC_income', '70', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('609100', 'de fourniture - van hulpstoffen', 'A', 'E', '', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('656100', 'Frais de banque', 'A', 'E', 'AP_amount:IC_expense', '65', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('620000', 'Administrateurs ou gÃrants - Bestuurders of zaakvoerders', 'A', 'E', '', '62', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('618', 'Divers', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('65', 'Charges financiÃres', 'H', 'E', '', '65', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('442004', 'VISA - dÃcompte mensuel', 'A', 'L', 'AP_paid', '44', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('620100', 'Personnel de direction - Directiepersoneel', 'A', 'E', '', '62', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('617', 'Personnel intÃrimaire - Uitzendkrachten', 'A', 'E', '', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('440', 'Fournisseurs - Leveranciers', 'A', 'L', 'AP', '44', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('52', 'Titres à revenu fixe - Vastrentende Effecten', 'H', 'A', '', '52', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('4529', '453 - 459 Dettes salariales et sociales - Bezoldigingen en sociale schulden', 'H', 'L', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('620', 'RÃmunerations et avant. sociaux directs - Bezolgingen en rechts. sociale voordelen', 'A', 'E', '', '62', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('602', 'Achats services, travaux, Ãtudes - Aankopen diensten, werk, studies', 'A', 'E', 'IC_cogs', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612000', 'Eau', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('611351', 'Pneus Voitures & Vehic. Mixtes', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('641', 'Moins-values s/rÃalis. cour. d''immo. corp. - Minderwa. courante realis. vaste activa', 'A', 'E', '', '64', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('715', 'Des immeubles constr. dest. Ã la vente - In de voorr. onroe. goederen best. v. verkoop', 'A', 'I', 'IC_sale', '71', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612400', 'ImprimÃs & fournitures de bureau', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('414200', 'Subsides en capital à recevoir - Te ontv. kapitaalsubsidies', 'A', 'A', '', '41', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('66', 'Charges exceptionnelles', 'H', 'E', '', '66', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613230', 'Honoraires huissiers de justice', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613313', 'Restaurants Ãtranger', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('74', 'Autres produits exploitation - Andere bedrijfsopbrengsten', 'H', 'I', '', '74', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('610', 'Loyers et charges locatives', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('70', 'Chiffre d''affaires - Omzet', 'H', 'I', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('751', 'Produits actifs circulants - Opbrengsten uit vlottende activa', 'A', 'I', '', '75', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('705200', 'WEB HOSTING', 'A', 'I', 'AR_amount:IC_income', '70', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('442005', 'AMERICAN EXPRESS - dÃcompte mensuel', 'A', 'L', 'AP_paid', '44', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('762', 'Reprises provisions risq. charg. except. - Terugn. voorz. uitz. risico en kosten', 'A', 'I', '', '76', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('780', 'PrÃlÃvements s/impÃts diffÃrÃs - Onttrekking a. uitgesteld. belast.', 'A', 'I', '', '78', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('78', 'PrÃlÃvements rÃserves immunisÃes et impÃts diffÃrÃs - Onttrek. belast.vrije reserves en de uitgestelde belastingen', 'H', 'I', '', '78', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('53', 'DÃpÃts à terme - Termijndeposito''s', 'H', 'A', '', '53', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('614100', 'Catalogues et imprimÃes', 'A', 'I', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('451500', 'TVA DUE ACHATS INCO', 'A', 'L', '', '451', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613110', 'Assurance vol', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('451543', 'TVA due 2e trimestre', 'A', 'L', '', '451', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('609400', 'de marchandises - van handelsgoederen', 'A', 'E', 'AP_amount:IC_sale', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613305', 'Collations', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612010', 'Chauffage', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612410', 'Fournitures informatiques', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613250', 'Honoraires sÃcretariat social', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('611362', 'Control technique voitures', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('482200', 'ASSOCIES - MEMBRES', 'A', 'L', '', '48', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612530', 'Petit outillage & petit matÃriel', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613400', 'Seminaires & Recyclages', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612540', 'Petit matÃriel informatique', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('603', 'Sous-traitances gÃnÃrales - Algemene onderaanemingen', 'A', 'E', 'IC_cogs', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('743200', 'COTISATION DE MEMBRE', 'A', 'I', 'AR_amount:IC_income', '74', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('601000', 'Emballages perdus', 'A', 'E', 'IC_cogs', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('230010', 'Inst. techniques acquis. exercice - Installaties m.b.t. dit boekj.', 'A', 'A', 'AP_amount:IC_expense', '23', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('570000', 'CAISSE ESPECES - CONTANTEN', 'A', 'A', 'AR_paid:AP_paid', '57', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('451544', 'TVA due 3e trimestre', 'A', 'L', '', '451', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('411000', 'Cpt. curr. TVA Ã rÃcuperer - Terug te vord. BTW: saldo BTW r/c', 'A', 'A', '', '411', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('611152', 'Locations machines et outils', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('56', 'Office des chÃques postaux - PostchÃque en girodienst', 'H', 'A', '', '56', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('411593', 'TVA RECUP. 1ER TRIMESTRE TOTAL (case 59)', 'A', 'A', '', '411', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('51', 'Actions et parts - Aandelen', 'H', 'A', '', '51', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('510010', 'Montants non-appelÃs (-) - Niet opgevraagde bedragen aan. (-)', 'A', 'A', '', '51', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('609500', 'd''immeubles achÃtÃs destinÃs à vente - van gek. onroer. goederen best. v. verkoop', 'A', 'E', '', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('58', 'Virements interns - Interne overboekingen', 'H', 'A', '', '58', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('416', 'CrÃances diverses - Diverse vorderingen ', 'H', 'A', '', '416', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('416200', 'Cpt. courant associÃs - Rekening-courant vennoten', 'A', 'A', '', '416', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('418', 'Cautionnements versÃs en numÃraire - Borgtochten betaald in contanten', 'A', 'A', '', '416', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('67', 'ImpÃt sur le rÃsultat', 'H', 'E', '', '67', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('654', 'DiffÃrence de change', 'A', 'E', 'AP_amount', '65', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('642', 'Moins-values s/rÃalis. crÃances com. - Minderwa. realis. handelsvorderingen', 'A', 'E', '', '64', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('717', 'Des commandes en cours exÃcution - In de bestelling in uitvoering', 'A', 'I', 'IC_sale', '71', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('752', 'Plus-values rÃalis. d''actifs circulants - Meerwaar. realis. v. vlottende activa', 'A', 'I', '', '75', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('763', 'Plus-values s/rÃalis. actifs immo. - Meerwaar. realis. vaste a.', 'A', 'I', '', '76', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('789', 'PrÃlÃvements s/rÃserves immunisÃes - Onttrekking a. belast.vrije reserves', 'A', 'I', '', '78', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('79', 'Affectations et prÃlÃvements - Resultaatverwerking', 'H', 'I', '', '79', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('412', 'ImpÃts, prÃcomptes à rÃcupÃrer - Terug te vorderen belast. en voorheffingen', 'A', 'A', '', '41', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('120', 'Plus-values de rÃÃvaluation sur immo. incorp. - Herwaarderingsmeerwaarde', 'A', 'L', '', '12', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('121', 'Plus-values de rÃÃvaluation sur immo. corp. - Herwaarderingsmeerwaarde', 'A', 'L', '', '12', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('122', 'Plus-values de rÃÃvaluation sur immo. financiers - Herwaarderingsmeerwaarde', 'A', 'L', '', '12', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('123', 'Plus-values de rÃÃvaluation sur stocks - Herwaarderingsmeerwaarde', 'A', 'L', '', '12', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('124', 'Reprises de rÃduction de valeur sur placements trÃsorerie - Herwaarderingsmeerwaarde', 'A', 'L', '', '12', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('12', 'Plus-values de rÃÃvaluation - Herwaarderingsmeerwaarde', 'H', 'L', '', '12', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('110', 'Primes d''Ãmission - Uitgiftepremies', 'A', 'L', '', '11', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('11', 'Primes d''Ãmission - Uitgiftepremies', 'H', 'L', '', '11', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('643', '643-648 Charges d''exploitation diverses - Diverse berijfskosten', 'H', 'E', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612100', 'Telephone', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('10', 'Capital - Kapitaal', 'H', 'L', '', '10', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('1', 'CLASSE 1 -- CAPITAL PROPRE, ... - EIGEN VERMOGEN, ...', 'H', 'L', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('60', 'Approv. et marchandises', 'H', 'E', '', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('717000', 'Valeur d''acquisition - Aanschaffingswaarde', 'A', 'I', '', '717', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('68', 'Transferts comptes immunisÃes et impÃts diffÃrÃs', 'H', 'E', '', '68', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('130', 'RÃserve lÃgale - Wettelijke reserve', 'A', 'L', '', '13', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('131100', 'Autres rÃserves indisponibles - Andere onbeschikbare reserves', 'A', 'L', '', '13', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('132', 'RÃserves immunisÃes - Belastingvrije reserves', 'A', 'L', '', '13', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('131000', 'RÃserves pour actions propres - Reserve voor eigen aandelen', 'A', 'L', '', '13', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('133', 'RÃserves disponibles - Beschikbare reserves', 'A', 'L', '', '13', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('101', 'Capital non appelà (-) - Niet opgevraagd kapitaal (-)', 'A', 'L', '', '10', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('14', 'BÃnÃfice/perte reportÃ(e) - Overgedragen winst/verlies', 'H', 'L', '', '14', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('100', 'Capital souscrit - Geplaatst kapitaal', 'A', 'L', '', '10', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('601010', 'Emballages recuperables', 'A', 'E', 'IC_cogs', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('140', 'BÃnÃfice/perte reportÃ(e) - Overgedragen winst/verlies', 'A', 'Q', '', '14', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('15', 'Subsides en capital - Kapitaalsubsidies', 'H', 'L', '', '15', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('419', 'RÃductions de valeur actÃes (-) - Geboekte waardevermindering (-)', 'A', 'A', '', '416', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612450', 'Photocopies-Photographies', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('131', 'RÃserves indisponibles - Onbeschikbare reserves', 'A', 'L', '', '13', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('16', 'Provisions et impÃts diffÃrÃs - Voorz. en uitgestelde belastingen', 'H', 'L', '', '16', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('160', 'Provisions pensions et obligations - Voorz. pensioenen en soortg. verplichtingen', 'A', 'L', '', '16', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('161', 'Provisions charges fiscales - Voorz. belastingen', 'A', 'L', '', '16', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('162', 'Provisions gros entretiens et rÃparations - Voorz. grote herstel/onderh.', 'A', 'L', '', '16', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('163', 'Provisions autres risques-charges - Voorzieningen voor Lijfrente', 'A', 'L', '', '16', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('753', 'Subsides en capital et intÃrÃts - Kapitaal- en interestsubsidies', 'A', 'I', '', '75', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('705000', 'Prestations de services - Verkopen en dienstprestaties', 'A', 'I', '', '70', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('764', '764-769 Autres produits execptionnels - Andere uitz. opbrengsten', 'H', 'I', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('790', 'BÃnÃfice reportà exercice prÃcÃd. - Overgedragen winst vorige boekj.', 'A', 'I', '', '79', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('168200', 'ImpÃts diff. s/+value immo. corp. - Uitg. belast./meerwa./mat. v.a.', 'A', 'L', '', '16', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('604', 'Achats marchandises - Aankopen van handelsgoederen', 'A', 'E', 'IC_cogs', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('168000', 'ImpÃts diff. s/subsides en capital - Uitgest. belast./Kapitaalsubsidie', 'A', 'L', '', '16', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613265', 'Honoraires d''autres', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('620800', 'Assurance revenus garantis', 'A', 'E', 'AP_amount:IC_expense', '62', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('168800', 'ImpÃts diffÃrÃs Ãtrangers - Uitg. belast. buitenland', 'A', 'L', '', '16', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('17', 'Dettes à plus d''un an - Schulden op meer dan een jaar', 'H', 'L', '', '17', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('150', 'Montants obtenus - Kapitaalsubsidies', 'A', 'L', '', '15', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('172000', 'Dettes location fin. et assimilÃes - Leasingschuld. van vaste activa', 'A', 'L', '', '17', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('231010', 'Mach. et gros mat. acquis. exercice - Machines m.b.t. dit boekj.', 'A', 'A', 'AP_amount:IC_expense', '23', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('451610', 'TVA Ã rÃgulariser (case 61)', 'A', 'L', '', '45', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('456', 'PÃcules de vacances - Vakantiegeld', 'A', 'L', '', '45', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('176', 'Acomptes reÃus sur commandes', 'A', 'L', '', '17', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('47', 'Dettes affectation rÃsultat - Schulden besteming resultaat', 'H', 'L', '', '47', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('620200', 'EmployÃs - Bedienden', 'A', 'E', '', '62', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('178', 'Cautionnements reÃu en numÃraire - Borgtocht. ontvang. in contanten', 'A', 'L', '', '17', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('179', 'Dettes diverses - Overige schulden', 'A', 'L', '', '17', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('174', 'Autres emprunts - Overige schulden', 'A', 'L', '', '17', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('2', 'CLASSE 2 -- FRAIS D''ETABLISSEMENT, ACTIFS IMMOBILISES, ... - OPRICHTINGSKOSTEN, VASTE ACTIVA, ...', 'H', 'A', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('20', 'Frais d''Ãtablissement - Oprichtingskosten', 'H', 'A', '', '20', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('200', 'Frais de constitution - Kosten van oprichting', 'A', 'A', '', '20', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('200000', 'Fr. const. acquis. anterieurs - Kost. opricht./kapitaalverhoging', 'A', 'A', '', '20', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('605', 'Achats d''immeubles destinÃs vente - Aankopen onroer. goederen bestemd v. verkoop', 'A', 'E', 'IC_cogs', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('61', 'Services et biens divers', 'H', 'E', '', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('69', 'Affectations et prÃlÃvements', 'H', 'E', '', '69', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('200900', 'Fr. const. amort. anterieur - Afschr. kost. opricht./kap.verh. vorig', 'A', 'A', '', '20', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('200910', 'Fr. const. amort. de l''exercice - Afschr. kost. opricht./kap.verh. dit', 'A', 'A', '', '20', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612020', 'ElectricitÃ', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('202', 'Autres frais d''Ãtablissement - Overige oprichtingskosten', 'A', 'A', '', '20', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('204', 'Frais de restructuration - Herstructureringskosten', 'A', 'A', '', '20', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('201', 'Frais d''Ãmission d''emprunts - Kosten bij uitgifte van leningen', 'A', 'A', '', '20', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('21', 'Immobilisations incorporelles - Immateriele vaste activa', 'H', 'A', '', '21', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('211', 'Concessions, brevets, licences, ... - Consessies, octrooien, licenties, ...', 'A', 'A', '', '21', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('210', 'Frais de recherches et developpement - Kosten van onderzoek en ontwikkeling', 'A', 'A', '', '21', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('212', 'Goodwill', 'A', 'A', '', '21', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('213', 'Acomptes versÃs - Vooruitbetalingen', 'A', 'A', '', '21', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('214', 'Surprix affÃrents acquisition d''une participation', 'A', 'A', '', '21', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('22', 'Terrains et constructions - Terreinen en gebouwen', 'H', 'A', '', '22', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('743', '743-749 Produits d''exploitation divers - Diverse bedrijfsopbrengsten', 'H', 'I', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('580000', 'TRANSFERTS INTERNES DES FONDS - TRANSFERTEN', 'A', 'A', 'AR_paid:AP_paid', '58', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('221', 'Constructions - Gebouwen', 'A', 'A', '', '22', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('717100', 'BÃnÃfice pris en compte - Toegerekende winst', 'A', 'I', '', '717', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('756', '756-759 Produits financiers divers - Diverse financiÃle opbrengsten', 'H', 'I', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('222', 'Terrains bÃtis - Bebouwde terreinen', 'A', 'A', '', '22', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('13', 'RÃserves - Reserves', 'H', 'L', '', '13', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('223', 'Autres droits rÃels sur immeubles - Overige zakelijke rechten op onroe.', 'A', 'A', '', '22', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('221000', 'Constructions acquis. anterieurs - Geb. aanschaffingsprijs vorig. boekj.', 'A', 'A', '', '22', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('411594', 'TVA RECUP. 2E TRIMESTRE TOTAL', 'A', 'A', '', '411', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('771', 'ImpÃts belges sur le rÃsultat - Belgische belasting op het resultaat', 'A', 'I', '', '77', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('23', 'Installations, machines et outillage - Installaties, machines en uitrusting', 'H', 'A', '', '23', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('230', 'Installations - Installaties', 'A', 'A', '', '23', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('230000', 'Inst. techniques acquis. anterieurs - Installaties m.b.t. vorig boekj.', 'A', 'A', '', '23', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('620300', 'Ouvriers - Arbeiders', 'A', 'E', '', '62', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('231', 'Machines', 'A', 'A', '', '23', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('791', 'PrÃlÃvement s/capital et primes Ãmissions - Onttrek. kapitaal e. uitgiftepre.', 'A', 'I', '', '79', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('220', 'Terrains - Terreinen', 'A', 'A', '', '22', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('237', 'Outillage - Uitrusting', 'A', 'A', '', '23', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('231000', 'Mach. et gros mat. acquis anterieurs - Machines m.b.t. vorig boekj.', 'A', 'A', '', '23', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613100', 'Assurance incendie', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613275', 'Publications lÃgales', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('237000', 'Outillage acquis. anterieurs - Uitrusting m.b.t. vorig boekj.', 'A', 'A', '', '23', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('24', 'Mobilier et matÃriel roulant - Meubilair en rollend materieel', 'H', 'A', '', '24', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('2401', 'MatÃriel de bureau - Bureaumaterieel', 'A', 'A', '', '24', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('2402', 'MatÃriel informatique - Hardware', 'A', 'A', '', '24', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('241', 'Voiture - Rollend materieel (wagen)', 'A', 'A', '', '24', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('62', 'RÃmunÃrations, charges sociales et pensions', 'H', 'E', '', '62', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('25', 'Immobilis. en loc-financement - Vaste activa in leasing of op grond', 'H', 'A', '', '25', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612120', 'GSM', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('242', 'Camions - Rollend materieel (vrachtwagen)', 'A', 'A', '', '24', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('250', 'Terreins loc-fin - Terreinen in leasing', 'A', 'A', '', '25', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('251', 'Install., machines loc-fin - Installaties, machines in leasing', 'A', 'A', '', '25', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('309', 'RÃduction val. act. mat. premiÃres (-) - Geboekte waardev. grondst. (-)', 'A', 'A', '', '30', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('253', 'MatÃriel en loc-fin - Uitrusting in leasing', 'A', 'A', '', '25', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('254', 'Mat. inform. en loc-fin- Hardware in leasing', 'A', 'A', '', '25', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('255', 'Mat. roulant en loc-fin - Rollend materieel leasing', 'A', 'A', '', '25', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('26', 'Autres immobilisations corp. - Andere materiele vaste activa', 'H', 'A', '', '26', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('260', 'Amenagement locaux louÃs - Inrichtingskost. gehuurde gebouw', 'A', 'A', '', '26', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613130', 'Assurance crÃdit', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('300', 'Approv. matiÃre premiÃre - Grondstoffen', 'A', 'A', 'IC', '30', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('411595', 'TVA RECUP. 3E TRIMESTRE TOTAL', 'A', 'A', '', '411', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('48', 'Dettes diverses - Diverse schulden', 'H', 'L', '', '48', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('270', 'Immo. corp. en cours et acomptes versÃs - V. activa in aanbouw en vooruit', 'A', 'A', '', '27', '0');
@@ Diff output truncated at 100000 characters. @@
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.