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

Subject: SF.net SVN: ledger-smb: [612] trunk/sql
From: ..hidden..
Date: Tue, 14 Nov 2006 20:53:55 -0800
Revision: 612
          http://svn.sourceforge.net/ledger-smb/?rev=612&view=rev
Author:   christopherm
Date:     2006-11-14 20:53:55 -0800 (Tue, 14 Nov 2006)

Log Message:
-----------
deleting old files

Removed Paths:
-------------
    trunk/sql/Canada-Quebec-UTF8-gifi.sql
    trunk/sql/Canada-Quebec_General-UTF8-chart.sql
    trunk/sql/Danish_Default-UTF8-chart.sql
    trunk/sql/Egypt-UTF8-chart.sql
    trunk/sql/Spain-UTF8-chart.sql

Deleted: trunk/sql/Canada-Quebec-UTF8-gifi.sql
===================================================================
--- trunk/sql/Canada-Quebec-UTF8-gifi.sql	2006-11-15 04:51:45 UTC (rev 611)
+++ trunk/sql/Canada-Quebec-UTF8-gifi.sql	2006-11-15 04:53:55 UTC (rev 612)
@@ -1,721 +0,0 @@
-begin;
--- French Canadian GIFI
--- CÃline des Ligneris
--- checked DS. March 3, 2004
---
-INSERT INTO gifi (accno,description) VALUES ('1000','Encaisse et dÃpÃts');
-INSERT INTO gifi (accno,description) VALUES ('1001','Encaisse');
-INSERT INTO gifi (accno,description) VALUES ('1002','DÃpÃts dans des banques et des institutions canadiennes Â monnaie canadienne');
-INSERT INTO gifi (accno,description) VALUES ('1003','DÃpÃts dans des banques et des institutions canadiennes Â devises ÃtrangÃres');
-INSERT INTO gifi (accno,description) VALUES ('1004','DÃpÃts dans des banques ÃtrangÃres Â monnaie canadienne');
-INSERT INTO gifi (accno,description) VALUES ('1005','DÃpÃts dans des banques ÃtrangÃres Â devises ÃtrangÃres');
-INSERT INTO gifi (accno,description) VALUES ('1006','Caisse de crÃdit Â dÃpÃt central');
-INSERT INTO gifi (accno,description) VALUES ('1007','Autres ÃlÃments de l\'actif assimilables Ã de l\'encaisse');
-INSERT INTO gifi (accno,description) VALUES ('1060','Comptes clients');
-INSERT INTO gifi (accno,description) VALUES ('1061','Provision pour crÃances douteuses');
-INSERT INTO gifi (accno,description) VALUES ('1062','Comptes clients commerciaux');
-INSERT INTO gifi (accno,description) VALUES ('1063','Provision pour mauvaises crÃances Â comptes clients commerciaux');
-INSERT INTO gifi (accno,description) VALUES ('1064','Comptes clients de personnes apparentÃes');
-INSERT INTO gifi (accno,description) VALUES ('1065','Provision pour mauvaises crÃances Â personnes apparentÃes');
-INSERT INTO gifi (accno,description) VALUES ('1066','ImpÃts Ã recevoir');
-INSERT INTO gifi (accno,description) VALUES ('1067','IntÃrÃts Ã recevoir');
-INSERT INTO gifi (accno,description) VALUES ('1068','Retenues de garantie Ã recevoir');
-INSERT INTO gifi (accno,description) VALUES ('1069','CrÃances au titre de baux');
-INSERT INTO gifi (accno,description) VALUES ('1070','Provision pour ÃlÃments douteux contenus dans certaines crÃances au titre de baux');
-INSERT INTO gifi (accno,description) VALUES ('1071','Comptes Ã recevoir d\'employÃs');
-INSERT INTO gifi (accno,description) VALUES ('1072','Provision pour mauvaises crÃances Â employÃs');
-INSERT INTO gifi (accno,description) VALUES ('1073','Montants Ã recevoir de membres d\'OSBL');
-INSERT INTO gifi (accno,description) VALUES ('1120','Stocks');
-INSERT INTO gifi (accno,description) VALUES ('1121','Stock de marchandises Ã vendre');
-INSERT INTO gifi (accno,description) VALUES ('1122','PiÃces et fournitures en stock');
-INSERT INTO gifi (accno,description) VALUES ('1123','Biens immobiliers figurant dans un inventaire');
-INSERT INTO gifi (accno,description) VALUES ('1124','Stocks d\'agrÃgats');
-INSERT INTO gifi (accno,description) VALUES ('1125','Travaux en cours');
-INSERT INTO gifi (accno,description) VALUES ('1126','MatiÃres premiÃres');
-INSERT INTO gifi (accno,description) VALUES ('1127','Titres figurant dans un inventaire');
-INSERT INTO gifi (accno,description) VALUES ('1180','Placements Ã court terme');
-INSERT INTO gifi (accno,description) VALUES ('1181','DÃpÃts Ã terme canadiens');
-INSERT INTO gifi (accno,description) VALUES ('1182','Actions de sociÃtÃs canadiennes');
-INSERT INTO gifi (accno,description) VALUES ('1183','Obligations canadiennes');
-INSERT INTO gifi (accno,description) VALUES ('1184','Bonds du TrÃsor canadien');
-INSERT INTO gifi (accno,description) VALUES ('1185','Titres acquis avec entente de rachat');
-INSERT INTO gifi (accno,description) VALUES ('1186','Autres placements canadiens Ã court terme');
-INSERT INTO gifi (accno,description) VALUES ('1187','Placements Ãtrangers Ã court terme');
-INSERT INTO gifi (accno,description) VALUES ('1240','PrÃts et effets Ã recevoir');
-INSERT INTO gifi (accno,description) VALUES ('1241','PrÃts remboursables sur demande');
-INSERT INTO gifi (accno,description) VALUES ('1242','Autres prÃts non remboursÃs');
-INSERT INTO gifi (accno,description) VALUES ('1243','Effets Ã recevoir');
-INSERT INTO gifi (accno,description) VALUES ('1244','HypothÃques Ã recevoir');
-INSERT INTO gifi (accno,description) VALUES ('1300','Sommes exigibles d\'actionnaire(s)/d\'administrateur(s)');
-INSERT INTO gifi (accno,description) VALUES ('1301','Sommes exigibles d\'actionnaire(s) (particuliers)');
-INSERT INTO gifi (accno,description) VALUES ('1302','Sommes exigibles d\'actionnaire(s) (sociÃtÃs)');
-INSERT INTO gifi (accno,description) VALUES ('1303','Sommes exigibles d\'administrateur(s)');
-INSERT INTO gifi (accno,description) VALUES ('1360','Placements dans une(des) coentreprise(s)/ sociÃtÃ(s) de personnes');
-INSERT INTO gifi (accno,description) VALUES ('1380','Sommes exigibles de coentreprise(s)/sociÃtÃ(s) de personnes');
-INSERT INTO gifi (accno,description) VALUES ('1400','Sommes exigibles des personnes apparentÃes/placements dans des personnes apparentÃes');
-INSERT INTO gifi (accno,description) VALUES ('1401','Billets Ã demande de personnes apparentÃes');
-INSERT INTO gifi (accno,description) VALUES ('1402','IntÃrÃts Ã recevoir de personnes apparentÃes');
-INSERT INTO gifi (accno,description) VALUES ('1403','PrÃts/avances Ã des personnes apparentÃes');
-INSERT INTO gifi (accno,description) VALUES ('1460','Dettes des clients pour acceptation');
-INSERT INTO gifi (accno,description) VALUES ('1480','Autres ÃlÃments d\'actif Ã court terme');
-INSERT INTO gifi (accno,description) VALUES ('1481','ImpÃts sur le revenu reportÃs');
-INSERT INTO gifi (accno,description) VALUES ('1482','Revenus de placements accumulÃs');
-INSERT INTO gifi (accno,description) VALUES ('1483','ImpÃts recouvrables/remboursables');
-INSERT INTO gifi (accno,description) VALUES ('1484','DÃpenses payÃes d\'avance');
-INSERT INTO gifi (accno,description) VALUES ('1485','Avances de forage');
-INSERT INTO gifi (accno,description) VALUES ('1486','Cautionnement/dÃpÃts sur soumissions');
-INSERT INTO gifi (accno,description) VALUES ('1599','Total de l\'actif Ã court terme');
-INSERT INTO gifi (accno,description) VALUES ('1600','Terrains');
-INSERT INTO gifi (accno,description) VALUES ('1601','Frais d\'amÃlioration des terrains');
-INSERT INTO gifi (accno,description) VALUES ('1602','Amortissement cumulÃ de l\'amÃlioration des terrains');
-INSERT INTO gifi (accno,description) VALUES ('1620','Biens Ãpuisables');
-INSERT INTO gifi (accno,description) VALUES ('1621','Amortissement cumulÃ des biens Ãpuisables');
-INSERT INTO gifi (accno,description) VALUES ('1622','Biens en ressources pÃtrolifÃres et en gaz naturel');
-INSERT INTO gifi (accno,description) VALUES ('1623','Amortissement cumulÃ des biens en ressources');
-INSERT INTO gifi (accno,description) VALUES ('1624','Biens miniers');
-INSERT INTO gifi (accno,description) VALUES ('1625','Amortissement cumulÃ des biens miniers');
-INSERT INTO gifi (accno,description) VALUES ('1626','Frais d\'exploration et d\'exploitation reportÃs');
-INSERT INTO gifi (accno,description) VALUES ('1627','Amortissement cumulÃ des frais d\'exploration et d\'exploitation reportÃs');
-INSERT INTO gifi (accno,description) VALUES ('1628','CarriÃres');
-INSERT INTO gifi (accno,description) VALUES ('1629','Amortissement cumulÃ des carriÃres');
-INSERT INTO gifi (accno,description) VALUES ('1630','CarriÃres de gravier');
-INSERT INTO gifi (accno,description) VALUES ('1631','Amortissement cumulÃ des carriÃres de gravier');
-INSERT INTO gifi (accno,description) VALUES ('1632','Concessions forestiÃres');
-INSERT INTO gifi (accno,description) VALUES ('1633','Amortissement cumulÃ des concessions forestiÃres');
-INSERT INTO gifi (accno,description) VALUES ('1680','BÃtiments');
-INSERT INTO gifi (accno,description) VALUES ('1681','Amortissement cumulÃ des bÃtiments');
-INSERT INTO gifi (accno,description) VALUES ('1682','Installations de fabrication et de traitement');
-INSERT INTO gifi (accno,description) VALUES ('1683','Amortissement cumulÃ des installations de fabrication et de traitement');
-INSERT INTO gifi (accno,description) VALUES ('1684','BÃtiments en construction');
-INSERT INTO gifi (accno,description) VALUES ('1740','Machines, matÃriel, meubles et accessoires');
-INSERT INTO gifi (accno,description) VALUES ('1741','Amortissement cumulÃ des machines, du matÃriel, des meubles et des accessoires');
-INSERT INTO gifi (accno,description) VALUES ('1742','VÃhicules automobiles');
-INSERT INTO gifi (accno,description) VALUES ('1743','Amortissement cumulÃ des vÃhicules automobiles');
-INSERT INTO gifi (accno,description) VALUES ('1744','Outils et matrices');
-INSERT INTO gifi (accno,description) VALUES ('1745','Amortissement cumulÃ sur les outils et les matrices');
-INSERT INTO gifi (accno,description) VALUES ('1746','MatÃriel de construction et d\'excavation');
-INSERT INTO gifi (accno,description) VALUES ('1747','Amortissement cumulÃ du matÃriel de construction et d\'excavation');
-INSERT INTO gifi (accno,description) VALUES ('1748','MatÃriel d\'exploitation forestiÃre');
-INSERT INTO gifi (accno,description) VALUES ('1749','Amortissement cumulÃ du matÃriel d\'exploitation forestiÃre');
-INSERT INTO gifi (accno,description) VALUES ('1750','Filets et matÃriel de pÃche');
-INSERT INTO gifi (accno,description) VALUES ('1751','Amortissement cumulÃ des filets et du matÃriel de pÃche');
-INSERT INTO gifi (accno,description) VALUES ('1752','MatÃriel d\'exploitation miniÃre');
-INSERT INTO gifi (accno,description) VALUES ('1753','Amortissement cumulÃ du matÃriel d\'exploitation miniÃre');
-INSERT INTO gifi (accno,description) VALUES ('1754','RÃseaux pÃtroliers et gaziers');
-INSERT INTO gifi (accno,description) VALUES ('1755','Amortissement cumulÃ des rÃseaux pÃtroliers et gaziers');
-INSERT INTO gifi (accno,description) VALUES ('1756','MatÃriel de production pour les industries de ressources naturelles');
-INSERT INTO gifi (accno,description) VALUES ('1757','Amortissement cumulÃ du matÃriel de production de ressources naturelles');
-INSERT INTO gifi (accno,description) VALUES ('1758','MatÃriel de production autre que pour les industries de ressources naturelles');
-INSERT INTO gifi (accno,description) VALUES ('1759','Amortissement cumulÃ du matÃriel de production autre que pour les industries des ressources  naturelles');
-INSERT INTO gifi (accno,description) VALUES ('1760','MatÃriel d\'exploration');
-INSERT INTO gifi (accno,description) VALUES ('1761','Amortissement cumulÃ du matÃriel d\'exploration');
-INSERT INTO gifi (accno,description) VALUES ('1762','MatÃriel d\'expÃdition');
-INSERT INTO gifi (accno,description) VALUES ('1763','Amortissement cumulÃ du matÃriel d\'expÃdition');
-INSERT INTO gifi (accno,description) VALUES ('1764','Navires et bateaux');
-INSERT INTO gifi (accno,description) VALUES ('1765','Amortissement cumulÃ des navires et des bateaux');
-INSERT INTO gifi (accno,description) VALUES ('1766','AÃronefs');
-INSERT INTO gifi (accno,description) VALUES ('1767','Amortissement cumulÃ des aÃronefs');
-INSERT INTO gifi (accno,description) VALUES ('1768','Panneaux indicateurs');
-INSERT INTO gifi (accno,description) VALUES ('1769','Amortissement cumulÃ des panneaux indicateurs');
-INSERT INTO gifi (accno,description) VALUES ('1770','Petits outils');
-INSERT INTO gifi (accno,description) VALUES ('1771','Amortissement cumulÃ des petits outils');
-INSERT INTO gifi (accno,description) VALUES ('1772','MatÃriel de radio et de communication');
-INSERT INTO gifi (accno,description) VALUES ('1773','Amortissement cumulÃ du matÃriel de radio et de communication');
-INSERT INTO gifi (accno,description) VALUES ('1774','MatÃriel informatique/logiciels');
-INSERT INTO gifi (accno,description) VALUES ('1775','Amortissement cumulÃ du matÃriel informatique / logiciels');
-INSERT INTO gifi (accno,description) VALUES ('1776','Instruments de musique');
-INSERT INTO gifi (accno,description) VALUES ('1777','Amortissement cumulÃ des instruments de musique');
-INSERT INTO gifi (accno,description) VALUES ('1778','Satellites');
-INSERT INTO gifi (accno,description) VALUES ('1779','Amortissement cumulÃ des satellites');
-INSERT INTO gifi (accno,description) VALUES ('1780','Stations terrestres');
-INSERT INTO gifi (accno,description) VALUES ('1781','Amortissement cumulÃ des stations terrestres');
-INSERT INTO gifi (accno,description) VALUES ('1782','Machines et matÃriel en cours de fabrication');
-INSERT INTO gifi (accno,description) VALUES ('1783','MatÃriel de transport');
-INSERT INTO gifi (accno,description) VALUES ('1784','Amortissement cumulÃ du matÃriel de transport');
-INSERT INTO gifi (accno,description) VALUES ('1785','Autres machines et matÃriel');
-INSERT INTO gifi (accno,description) VALUES ('1786','Amortissement cumulÃ des autres machines et d\'autre matÃriel');
-INSERT INTO gifi (accno,description) VALUES ('1787','Meubles et accessoires');
-INSERT INTO gifi (accno,description) VALUES ('1788','Amortissement cumulÃ des meubles et des accessoires');
-INSERT INTO gifi (accno,description) VALUES ('1900','Autres immobilisations');
-INSERT INTO gifi (accno,description) VALUES ('1901','Amortissement cumulÃ des autres immobilisations');
-INSERT INTO gifi (accno,description) VALUES ('1902','Chemins d\'exploitation forestiÃre');
-INSERT INTO gifi (accno,description) VALUES ('1903','Amortissement cumulÃ des chemins d\'exploitation forestiÃre');
-INSERT INTO gifi (accno,description) VALUES ('1904','Aires asphaltÃes et parcs de stationnement');
-INSERT INTO gifi (accno,description) VALUES ('1905','Amortissement des aires asphaltÃes et des parcs de stationnement');
-INSERT INTO gifi (accno,description) VALUES ('1906','Quais');
-INSERT INTO gifi (accno,description) VALUES ('1907','Amortissement cumulÃ des quais');
-INSERT INTO gifi (accno,description) VALUES ('1908','ClÃtures');
-INSERT INTO gifi (accno,description) VALUES ('1909','Amortissement cumulÃ des clÃtures');
-INSERT INTO gifi (accno,description) VALUES ('1910','Contrats de location Â acquisition (bÃtiments)');
-INSERT INTO gifi (accno,description) VALUES ('1911','Amortissement cumulÃ des contrats de location - acquisition (bÃtiments)');
-INSERT INTO gifi (accno,description) VALUES ('1912','Contrats de location Â acquisition (matÃriel)');
-INSERT INTO gifi (accno,description) VALUES ('1913','Amortissement cumulÃ des contrats de location Â acquisition (matÃriel)');
-INSERT INTO gifi (accno,description) VALUES ('1914','Contrats de location Â acquisition (vÃhicules)');
-INSERT INTO gifi (accno,description) VALUES ('1915','Amortissement cumulÃ des contrats de location Â acquisition (vÃhicules)');
-INSERT INTO gifi (accno,description) VALUES ('1916','Contrats de location Â acquisition (autres)panneaux');
-INSERT INTO gifi (accno,description) VALUES ('1917','Amortissement cumulÃ des contrats de location Â acquisition (autres)');
-INSERT INTO gifi (accno,description) VALUES ('1918','AmÃliorations locatives');
-INSERT INTO gifi (accno,description) VALUES ('1919','Amortissement cumulÃ des amÃliorations locatives');
-INSERT INTO gifi (accno,description) VALUES ('1920','Autres immobilisations en construction');
-INSERT INTO gifi (accno,description) VALUES ('1921','Aires de campings');
-INSERT INTO gifi (accno,description) VALUES ('1922','Amortissement cumulÃ des aires de campings');
-INSERT INTO gifi (accno,description) VALUES ('2008','Total des immobilisations');
-INSERT INTO gifi (accno,description) VALUES ('2009','Total de l\'amortissement cumulÃ des immobilisations');
-INSERT INTO gifi (accno,description) VALUES ('2010','Actif incorporel');
-INSERT INTO gifi (accno,description) VALUES ('2011','Amortissement cumulÃ de l\'actif incorporel');
-INSERT INTO gifi (accno,description) VALUES ('2012','Achalandage');
-INSERT INTO gifi (accno,description) VALUES ('2013','Amortissement cumulÃ de l\'achalandage');
-INSERT INTO gifi (accno,description) VALUES ('2014','Contingents');
-INSERT INTO gifi (accno,description) VALUES ('2015','Amortissement cumulÃ des contingents');
-INSERT INTO gifi (accno,description) VALUES ('2016','Permis');
-INSERT INTO gifi (accno,description) VALUES ('2017','Amortissement cumulÃ des permis');
-INSERT INTO gifi (accno,description) VALUES ('2018','Frais de constitution en sociÃtÃ');
-INSERT INTO gifi (accno,description) VALUES ('2019','Amortissement cumulÃ des frais de constitution en sociÃtÃ');
-INSERT INTO gifi (accno,description) VALUES ('2020','Marques de commerce et brevets');
-INSERT INTO gifi (accno,description) VALUES ('2021','Amortissement cumulÃ des marques de commerce et des brevets');
-INSERT INTO gifi (accno,description) VALUES ('2022','Listes de clients');
-INSERT INTO gifi (accno,description) VALUES ('2023','Amortissement cumulÃ des listes de clients');
-INSERT INTO gifi (accno,description) VALUES ('2024','Droits');
-INSERT INTO gifi (accno,description) VALUES ('2025','Amortissement cumulÃ des droits');
-INSERT INTO gifi (accno,description) VALUES ('2026','Recherche et dÃveloppement');
-INSERT INTO gifi (accno,description) VALUES ('2027','Amortissement cumulÃ de la recherche et du dÃveloppement');
-INSERT INTO gifi (accno,description) VALUES ('2070','Droits relatifs Ã des ressources');
-INSERT INTO gifi (accno,description) VALUES ('2071','Amortissement cumulÃ des droits relatifs Ã des ressources');
-INSERT INTO gifi (accno,description) VALUES ('2072','Droits de coupe');
-INSERT INTO gifi (accno,description) VALUES ('2073','Amortissement cumulÃ des droits de coupe');
-INSERT INTO gifi (accno,description) VALUES ('2074','Droits miniers');
-INSERT INTO gifi (accno,description) VALUES ('2075','Amortissement cumulÃ des droits miniers');
-INSERT INTO gifi (accno,description) VALUES ('2076','Droits pÃtroliers et gaziers');
-INSERT INTO gifi (accno,description) VALUES ('2077','Amortissement cumulÃ des droits pÃtroliers et gaziers');
-INSERT INTO gifi (accno,description) VALUES ('2178','Total de l\'actif incorporel');
-INSERT INTO gifi (accno,description) VALUES ('2179','Total de l\'amortissement cumulÃ de l\'actif incorporel');
-INSERT INTO gifi (accno,description) VALUES ('2180','Sommes exigibles d\'actionnaire(s)/ d\'administrateur(s)');
-INSERT INTO gifi (accno,description) VALUES ('2181','Sommes exigibles d\'actionnaire(s) (particuliers)');
-INSERT INTO gifi (accno,description) VALUES ('2182','Sommes exigibles d\'actionnaire(s) (sociÃtÃs)');
-INSERT INTO gifi (accno,description) VALUES ('2183','Sommes exigibles d\'administrateur(s)');
-INSERT INTO gifi (accno,description) VALUES ('2190','Sommes exigibles des membres');
-INSERT INTO gifi (accno,description) VALUES ('2200','Placements dans une(des) coentreprise(s)/sociÃtÃ(s) de personnes');
-INSERT INTO gifi (accno,description) VALUES ('2220','Sommes exigibles de coentreprise(s)/sociÃtÃ(s)de personnes');
-INSERT INTO gifi (accno,description) VALUES ('2240','Sommes exigibles des personnes apparentÃes/');
-INSERT INTO gifi (accno,description) VALUES ('2241','Sommes exigibles de/placements dans des personnes canadiennes apparentÃes');
-INSERT INTO gifi (accno,description) VALUES ('2242','Actions dans des sociÃtÃs canadiennes apparentÃes');
-INSERT INTO gifi (accno,description) VALUES ('2243','PrÃts/avances Ã des sociÃtÃs canadiennes apparentÃes');
-INSERT INTO gifi (accno,description) VALUES ('2244','Placements dans des sociÃtÃs canadiennes apparentÃes Ã la valeur d\'acquisition');
-INSERT INTO gifi (accno,description) VALUES ('2245','Placements dans des sociÃtÃs canadiennes apparentÃes Ã la valeur de consolidation');
-INSERT INTO gifi (accno,description) VALUES ('2246','Sommes exigibles de/placements dans des parties ÃtrangÃres apparentÃes');
-INSERT INTO gifi (accno,description) VALUES ('2247','Actions dans des sociÃtÃs ÃtrangÃres apparentÃes');
-INSERT INTO gifi (accno,description) VALUES ('2248','PrÃts/avances Ã des sociÃtÃs ÃtrangÃres apparentÃes');
-INSERT INTO gifi (accno,description) VALUES ('2249','Placements dans des sociÃtÃs ÃtrangÃres apparentÃes Ã la valeur d\'acquisition');
-INSERT INTO gifi (accno,description) VALUES ('2250','Placements dans des sociÃtÃs ÃtrangÃres apparentÃes Ã la valeur de consolidation');
-INSERT INTO gifi (accno,description) VALUES ('2280','Placements dans des locations en partenariat');
-INSERT INTO gifi (accno,description) VALUES ('2300','Placements Ã long terme');
-INSERT INTO gifi (accno,description) VALUES ('2301','Actions dans des sociÃtÃs ÃtrangÃres');
-INSERT INTO gifi (accno,description) VALUES ('2302','Autres genres de placements Ã l\'Ãtranger');
-INSERT INTO gifi (accno,description) VALUES ('2303','Actions dans des sociÃtÃs canadiennes');
-INSERT INTO gifi (accno,description) VALUES ('2304','Titres de crÃances du gouvernement du Canada');
-INSERT INTO gifi (accno,description) VALUES ('2305','Titres de crÃances des gouvernements provinciaux et des administrations municipales du Canada');
-INSERT INTO gifi (accno,description) VALUES ('2306','Obligations et dÃbentures de sociÃtÃs canadiennes');
-INSERT INTO gifi (accno,description) VALUES ('2307','Titres de crÃances');
-INSERT INTO gifi (accno,description) VALUES ('2308','Titres de participation');
-INSERT INTO gifi (accno,description) VALUES ('2309','Titres acquis Ã la suite d\'une entente de rachat');
-INSERT INTO gifi (accno,description) VALUES ('2310','Actions de la caisse de crÃdit centrale');
-INSERT INTO gifi (accno,description) VALUES ('2311','Autres placements canadiens Ã long terme');
-INSERT INTO gifi (accno,description) VALUES ('2360','PrÃts Ã long terme');
-INSERT INTO gifi (accno,description) VALUES ('2361','PrÃts hypothÃcaires');
-INSERT INTO gifi (accno,description) VALUES ('2362','PrÃts personnels et prÃts sur carte de crÃdit');
-INSERT INTO gifi (accno,description) VALUES ('2363','PrÃts au gouvernement et prÃts commerciaux');
-INSERT INTO gifi (accno,description) VALUES ('2364','Marge de crÃdit');
-INSERT INTO gifi (accno,description) VALUES ('2420','Autres ÃlÃments d\'actif Ã long terme');
-INSERT INTO gifi (accno,description) VALUES ('2421','ImpÃts sur le revenu reportÃs');
-INSERT INTO gifi (accno,description) VALUES ('2422','Frais du rÃgime de pension reportÃs');
-INSERT INTO gifi (accno,description) VALUES ('2423','Pertes de change non matÃrialisÃes reportÃes');
-INSERT INTO gifi (accno,description) VALUES ('2424','Autres ÃlÃments/frais reportÃs');
-INSERT INTO gifi (accno,description) VALUES ('2425','Amortissement cumulÃ des frais reportÃs');
-INSERT INTO gifi (accno,description) VALUES ('2426','Fonds de rÃserve');
-INSERT INTO gifi (accno,description) VALUES ('2427','Valeur de rachat de l\'assurance-vie');
-INSERT INTO gifi (accno,description) VALUES ('2589','Total de l\'actif Ã long terme');
-INSERT INTO gifi (accno,description) VALUES ('2590','Actif dÃtenu en fiducie');
-INSERT INTO gifi (accno,description) VALUES ('2599','Total de l\'actif');
-INSERT INTO gifi (accno,description) VALUES ('2600','DÃcouvert bancaire');
-INSERT INTO gifi (accno,description) VALUES ('2620','Montants et charges Ã payer');
-INSERT INTO gifi (accno,description) VALUES ('2621','Effets commerciaux Ã payer');
-INSERT INTO gifi (accno,description) VALUES ('2622','Effets commerciaux Ã payer Ã des personnes apparentÃes');
-INSERT INTO gifi (accno,description) VALUES ('2623','Retenues de garantie Ã payer');
-INSERT INTO gifi (accno,description) VALUES ('2624','Salaires Ã payer');
-INSERT INTO gifi (accno,description) VALUES ('2625','Frais de gestion Ã payer');
-INSERT INTO gifi (accno,description) VALUES ('2626','Gratifications Ã payer');
-INSERT INTO gifi (accno,description) VALUES ('2627','Retenues salariales Ã payer');
-INSERT INTO gifi (accno,description) VALUES ('2628','Retenues d\'impÃts et de taxes Ã payer');
-INSERT INTO gifi (accno,description) VALUES ('2629','IntÃrÃts Ã payer');
-INSERT INTO gifi (accno,description) VALUES ('2630','Montants Ã payer aux membres d\'OSBL');
-INSERT INTO gifi (accno,description) VALUES ('2680','Taxes et impÃts Ã payer');
-INSERT INTO gifi (accno,description) VALUES ('2700','Dettes Ã court terme');
-INSERT INTO gifi (accno,description) VALUES ('2701','Emprunts auprÃs de banques canadiennes');
-INSERT INTO gifi (accno,description) VALUES ('2702','ÃlÃment de passif pour les titres vendus Ã dÃcouvert');
-INSERT INTO gifi (accno,description) VALUES ('2703','ÃlÃment de passif pour les titres vendus Ã la suite d\'une entente de rachat');
-INSERT INTO gifi (accno,description) VALUES ('2704','Titres sur l\'or et sur l\'argent');
-INSERT INTO gifi (accno,description) VALUES ('2705','ChÃques et autres items en circulation');
-INSERT INTO gifi (accno,description) VALUES ('2706','Billets garantis');
-INSERT INTO gifi (accno,description) VALUES ('2770','Revenus reportÃs');
-INSERT INTO gifi (accno,description) VALUES ('2780','Sommes dues Ã un(des) actionnaire(s)/administrateur(s)');
-INSERT INTO gifi (accno,description) VALUES ('2781','Sommes dues Ã un(des) actionnaire(s) (particuliers)');
-INSERT INTO gifi (accno,description) VALUES ('2782','Sommes dues Ã un(des) actionnaire(s) (sociÃtÃs)');
-INSERT INTO gifi (accno,description) VALUES ('2783','Sommes dues Ã un(des) administrateur(s)');
-INSERT INTO gifi (accno,description) VALUES ('2840','Sommes dues Ã une(des) coentreprise(s)/ sociÃtÃ(s) de personnes');
-INSERT INTO gifi (accno,description) VALUES ('2860','Sommes dues Ã des personnes apparentÃes');
-INSERT INTO gifi (accno,description) VALUES ('2861','Billets Ã demande dus Ã des personnes apparentÃes');
-INSERT INTO gifi (accno,description) VALUES ('2862','IntÃrÃts Ã payer Ã des personnes apparentÃes');
-INSERT INTO gifi (accno,description) VALUES ('2863','Avances Ã payer Ã des personnes apparentÃes');
-INSERT INTO gifi (accno,description) VALUES ('2920','Portion Ã court terme du passif Ã long terme');
-INSERT INTO gifi (accno,description) VALUES ('2940','Acceptations de banque');
-INSERT INTO gifi (accno,description) VALUES ('2960','Autres ÃlÃments du passif Ã court terme');
-INSERT INTO gifi (accno,description) VALUES ('2961','Sommes reÃues en dÃpÃts');
-INSERT INTO gifi (accno,description) VALUES ('2962','Dividendes Ã payer');
-INSERT INTO gifi (accno,description) VALUES ('2963','ImpÃts sur le revenu reportÃs');
-INSERT INTO gifi (accno,description) VALUES ('2964','RÃserve pour garanties et indemnitÃs');
-INSERT INTO gifi (accno,description) VALUES ('2965','Provisions et rÃserves gÃnÃrales');
-INSERT INTO gifi (accno,description) VALUES ('2966','Parts des membres de l\'Ãquipage');
-INSERT INTO gifi (accno,description) VALUES ('3139','Total du passif Ã court terme');
-INSERT INTO gifi (accno,description) VALUES ('3140','Dette Ã long terme');
-INSERT INTO gifi (accno,description) VALUES ('3141','HypothÃques');
-INSERT INTO gifi (accno,description) VALUES ('3142','Emprunts d\'une sociÃtÃ de crÃdit agricole');
-INSERT INTO gifi (accno,description) VALUES ('3143','Emprunt d\'une banque Ã charte');
-INSERT INTO gifi (accno,description) VALUES ('3144','Emprunt d\'une caisse populaire/d\'une coopÃrative de crÃdit');
-INSERT INTO gifi (accno,description) VALUES ('3145','Emprunt du gouvernement provincial');
-INSERT INTO gifi (accno,description) VALUES ('3146','Emprunt d\'un fournisseur');
-INSERT INTO gifi (accno,description) VALUES ('3147','PrÃt personnel');
-INSERT INTO gifi (accno,description) VALUES ('3148','Emprunts d\'une fÃdÃration, d\'une centrale ou de');
-INSERT INTO gifi (accno,description) VALUES ('3149','Marge de crÃdit');
-INSERT INTO gifi (accno,description) VALUES ('3150','ÃlÃment de passif pour les titres vendus Ã');
-INSERT INTO gifi (accno,description) VALUES ('3151','ÃlÃment de passif pour les titres vendus Ã la suite d\'une entente de rachat');
-INSERT INTO gifi (accno,description) VALUES ('3152','Billets garantis');
-INSERT INTO gifi (accno,description) VALUES ('3200','Cautionnement des institutions financiÃres');
-INSERT INTO gifi (accno,description) VALUES ('3210','Obligations et dÃbentures');
-INSERT INTO gifi (accno,description) VALUES ('3220','Revenus reportÃs');
-INSERT INTO gifi (accno,description) VALUES ('3240','ImpÃts sur le revenu reportÃs');
-INSERT INTO gifi (accno,description) VALUES ('3260','Sommes dues Ã un(des) actionnaire(s)/ administrateur(s)');
-INSERT INTO gifi (accno,description) VALUES ('3261','Sommes dues Ã un(des) actionnaire(s) (particuliers)');
-INSERT INTO gifi (accno,description) VALUES ('3262','Sommes dues Ã un(des) actionnaire(s) (sociÃtÃs)');
-INSERT INTO gifi (accno,description) VALUES ('3263','Sommes dues Ã un(des) administrateur(s)');
-INSERT INTO gifi (accno,description) VALUES ('3270','Sommes dues Ã des membres');
-INSERT INTO gifi (accno,description) VALUES ('3280','Sommes dues Ã une(des) coentreprise(s)/sociÃtÃ(s) de personnes');
-INSERT INTO gifi (accno,description) VALUES ('3300','Sommes dues Ã des personnes apparentÃes');
-INSERT INTO gifi (accno,description) VALUES ('3301','Sommes dues Ã des personnes canadiennes apparentÃes');
-INSERT INTO gifi (accno,description) VALUES ('3302','Sommes dues Ã des personnes ÃtrangÃres apparentÃes');
-INSERT INTO gifi (accno,description) VALUES ('3320','Autres ÃlÃments de passif Ã long terme');
-INSERT INTO gifi (accno,description) VALUES ('3321','Obligations, engagements et location-acquisition Ã long terme');
-INSERT INTO gifi (accno,description) VALUES ('3322','RÃserves pour garanties et indemnitÃs');
-INSERT INTO gifi (accno,description) VALUES ('3323','Provision pour la restauration des sites d\'exploitation');
-INSERT INTO gifi (accno,description) VALUES ('3324','Contribution Ã une fiducie pour l\'environnement');
-INSERT INTO gifi (accno,description) VALUES ('3325','Provisions et rÃserves gÃnÃrales');
-INSERT INTO gifi (accno,description) VALUES ('3326','Redressement pour les actions privilÃgiÃes');
-INSERT INTO gifi (accno,description) VALUES ('3327','RÃpartition aux membres');
-INSERT INTO gifi (accno,description) VALUES ('3328','Revenus diffÃrÃs de contrats incomplets');
-INSERT INTO gifi (accno,description) VALUES ('3450','Total du passif Ã long terme');
-INSERT INTO gifi (accno,description) VALUES ('3460','Dettes de second rang');
-INSERT INTO gifi (accno,description) VALUES ('3470','Sommes dÃtenues en fiducie');
-INSERT INTO gifi (accno,description) VALUES ('3499','Total du passif');
-INSERT INTO gifi (accno,description) VALUES ('3500','Actions ordinaires');
-INSERT INTO gifi (accno,description) VALUES ('3520','Actions privilÃgiÃes');
-INSERT INTO gifi (accno,description) VALUES ('3540','Surplus d\'apport et autres surplus');
-INSERT INTO gifi (accno,description) VALUES ('3541','Surplus d\'apport');
-INSERT INTO gifi (accno,description) VALUES ('3542','Surplus d\'expertise');
-INSERT INTO gifi (accno,description) VALUES ('3543','RÃserve gÃnÃrale');
-INSERT INTO gifi (accno,description) VALUES ('3570','Compte du siÃge social');
-INSERT INTO gifi (accno,description) VALUES ('3600','BÃnÃfices non rÃpartis/dÃficit');
-INSERT INTO gifi (accno,description) VALUES ('3620','Total des capitaux propres');
-INSERT INTO gifi (accno,description) VALUES ('3640','Total du passif et des capitaux propres');
-INSERT INTO gifi (accno,description) VALUES ('3680','Revenu net/perte nette');
-INSERT INTO gifi (accno,description) VALUES ('3700','Dividendes dÃclarÃs');
-INSERT INTO gifi (accno,description) VALUES ('3701','Dividendes en espÃces');
-INSERT INTO gifi (accno,description) VALUES ('3702','Ristournes');
-INSERT INTO gifi (accno,description) VALUES ('3720','Redressements sur exercices antÃrieurs');
-INSERT INTO gifi (accno,description) VALUES ('3740','Autres ÃlÃments touchant les bÃnÃfices non rÃpartis');
-INSERT INTO gifi (accno,description) VALUES ('3741','Rachat d\'actions');
-INSERT INTO gifi (accno,description) VALUES ('3742','RÃserves spÃciales');
-INSERT INTO gifi (accno,description) VALUES ('3743','Redressements relatifs aux devises');
-INSERT INTO gifi (accno,description) VALUES ('3744','ÃlÃments inhabituels de revenus');
-INSERT INTO gifi (accno,description) VALUES ('3745','Transferts interfonds');
-INSERT INTO gifi (accno,description) VALUES ('3849','BÃnÃfices non rÃpartis/dÃficit Â fin de l\'exercice');
-INSERT INTO gifi (accno,description) VALUES ('8000','Ventes commerciales de biens et services');
-INSERT INTO gifi (accno,description) VALUES ('8020','Ventes de biens et de services Ã des personnes apparentÃes');
-INSERT INTO gifi (accno,description) VALUES ('8030','Ventes entre divisions');
-INSERT INTO gifi (accno,description) VALUES ('8040','Ventes de ressources naturelles');
-INSERT INTO gifi (accno,description) VALUES ('8041','Ventes de pÃtrole et de gaz naturel');
-INSERT INTO gifi (accno,description) VALUES ('8042','Ventes de pÃtrole et de gaz naturel Ã des personnes apparentÃes');
-INSERT INTO gifi (accno,description) VALUES ('8043','Commercialisation du gaz');
-INSERT INTO gifi (accno,description) VALUES ('8044','Revenus de traitement');
-INSERT INTO gifi (accno,description) VALUES ('8045','Revenus de transport par pipeline');
-INSERT INTO gifi (accno,description) VALUES ('8046','Ventes reliÃes Ã l\'exploration sÃismique');
-INSERT INTO gifi (accno,description) VALUES ('8047','Revenus provenant de l\'exploitation miniÃre');
-INSERT INTO gifi (accno,description) VALUES ('8048','Revenus provenant du charbon');
-INSERT INTO gifi (accno,description) VALUES ('8049','Revenus de sables bitumineux');
-INSERT INTO gifi (accno,description) VALUES ('8050','Revenus provenant des redevances');
-INSERT INTO gifi (accno,description) VALUES ('8051','Revenus/pertes d\'une sociÃtÃ de personnes/coentreprise Â pÃtrole et gaz');
-INSERT INTO gifi (accno,description) VALUES ('8052','Revenus/pertes d\'une sociÃtÃ de personnes/coentreprise Â mines');
-INSERT INTO gifi (accno,description) VALUES ('8053','Autres revenus de production');
-INSERT INTO gifi (accno,description) VALUES ('8089','Total des ventes de biens et services');
-INSERT INTO gifi (accno,description) VALUES ('8090','Revenus de placements');
-INSERT INTO gifi (accno,description) VALUES ('8091','IntÃrÃt de sources ÃtrangÃres');
-INSERT INTO gifi (accno,description) VALUES ('8092','IntÃrÃt d\'obligations et de dÃbentures canadiennes');
-INSERT INTO gifi (accno,description) VALUES ('8093','IntÃrÃt de prÃts hypothÃcaires canadiens');
-INSERT INTO gifi (accno,description) VALUES ('8094','IntÃrÃt d\'autres sources canadiennes');
-INSERT INTO gifi (accno,description) VALUES ('8095','Revenus de dividendes');
-INSERT INTO gifi (accno,description) VALUES ('8096','Dividendes de sources canadiennes');
-INSERT INTO gifi (accno,description) VALUES ('8097','Dividendes de sources ÃtrangÃres');
-INSERT INTO gifi (accno,description) VALUES ('8100','Revenus d\'intÃrÃt (institutions financiÃres)');
-INSERT INTO gifi (accno,description) VALUES ('8101','IntÃrÃt de prÃts');
-INSERT INTO gifi (accno,description) VALUES ('8102','IntÃrÃt de valeurs mobiliÃres');
-INSERT INTO gifi (accno,description) VALUES ('8103','IntÃrÃt des dÃpÃts en banque');
-INSERT INTO gifi (accno,description) VALUES ('8120','Revenus de commissions');
-INSERT INTO gifi (accno,description) VALUES ('8121','Revenus de commissions sur les transactions immobiliÃres');
-INSERT INTO gifi (accno,description) VALUES ('8140','Revenus de location');
-INSERT INTO gifi (accno,description) VALUES ('8141','Revenus de location immobiliÃre');
-INSERT INTO gifi (accno,description) VALUES ('8142','Revenus de location de films');
-INSERT INTO gifi (accno,description) VALUES ('8150','Contrats de location de vÃhicules');
-INSERT INTO gifi (accno,description) VALUES ('8160','Revenus provenant de la pÃche');
-INSERT INTO gifi (accno,description) VALUES ('8161','Ventes de poisson');
-INSERT INTO gifi (accno,description) VALUES ('8162','Autres produits marins');
-INSERT INTO gifi (accno,description) VALUES ('8163','Subventions, crÃdits et dÃgrÃvements de pÃche');
-INSERT INTO gifi (accno,description) VALUES ('8164','Subventions de pÃche');
-INSERT INTO gifi (accno,description) VALUES ('8165','IndemnitÃ pour perte d\'un revenu ou d\'un bien de pÃche');
-INSERT INTO gifi (accno,description) VALUES ('8166','Revenu de pÃcheur Ã la part');
-INSERT INTO gifi (accno,description) VALUES ('8210','Profits/pertes sur la disposition d\'ÃlÃments d\'actif');
-INSERT INTO gifi (accno,description) VALUES ('8211','Profits/pertes sur la vente de placements');
-INSERT INTO gifi (accno,description) VALUES ('8212','Profits/pertes sur la disposition d\'avoir minier');
-INSERT INTO gifi (accno,description) VALUES ('8220','Montants reÃus d\'OSBL');
-INSERT INTO gifi (accno,description) VALUES ('8221','Frais d\'adhÃsion');
-INSERT INTO gifi (accno,description) VALUES ('8222','Cotisations');
-INSERT INTO gifi (accno,description) VALUES ('8223','Dons');
-INSERT INTO gifi (accno,description) VALUES ('8224','Ventes et recettes brutes provenant d\'activitÃs de l\'organisme');
-INSERT INTO gifi (accno,description) VALUES ('8230','Autres revenus');
-INSERT INTO gifi (accno,description) VALUES ('8231','Gains/pertes sur devises ÃtrangÃres');
-INSERT INTO gifi (accno,description) VALUES ('8232','Revenus/pertes de filiales/de sociÃtÃs affiliÃes');
-INSERT INTO gifi (accno,description) VALUES ('8233','Revenus/pertes d\'autres divisions');
-INSERT INTO gifi (accno,description) VALUES ('8234','Revenus/pertes des coentreprises');
-INSERT INTO gifi (accno,description) VALUES ('8235','Revenus/pertes des sociÃtÃs de personnes');
-INSERT INTO gifi (accno,description) VALUES ('8236','RÃalisation de revenus diffÃrÃs');
-INSERT INTO gifi (accno,description) VALUES ('8237','Revenus de redevances autres que l\'exploitation des ressources naturelles');
-INSERT INTO gifi (accno,description) VALUES ('8238','CrÃdits d\'impÃts pour redevances de l\'Alberta');
-INSERT INTO gifi (accno,description) VALUES ('8239','Honoraires de gestion et d\'administration');
-INSERT INTO gifi (accno,description) VALUES ('8240','Revenus de tÃlÃcommunications');
-INSERT INTO gifi (accno,description) VALUES ('8241','Honoraires de consultation');
-INSERT INTO gifi (accno,description) VALUES ('8242','Subventions et octrois');
-INSERT INTO gifi (accno,description) VALUES ('8243','Ventes de sous-produits');
-INSERT INTO gifi (accno,description) VALUES ('8244','Frais d\'administration provenant du service des dÃpÃts');
-INSERT INTO gifi (accno,description) VALUES ('8245','Frais d\'administration provenant du service du crÃdit');
-INSERT INTO gifi (accno,description) VALUES ('8246','Frais d\'administration provenant du service des cartes bancaires');
-INSERT INTO gifi (accno,description) VALUES ('8247','Ristournes');
-INSERT INTO gifi (accno,description) VALUES ('8248','Recouvrement d\'assurance');
-INSERT INTO gifi (accno,description) VALUES ('8249','Recouvrement de frais');
-INSERT INTO gifi (accno,description) VALUES ('8250','Recouvrement des mauvaises crÃances');
-INSERT INTO gifi (accno,description) VALUES ('8299','Total des revenus');
-INSERT INTO gifi (accno,description) VALUES ('8300','Stock d\'ouverture');
-INSERT INTO gifi (accno,description) VALUES ('8301','Stock d\'ouverture Â produits finis');
-INSERT INTO gifi (accno,description) VALUES ('8302','Stock d\'ouverture Â matiÃres premiÃres');
-INSERT INTO gifi (accno,description) VALUES ('8303','Stock d\'ouverture Â produits en cours de fabrication');
-INSERT INTO gifi (accno,description) VALUES ('8320','Achats/coÃt des matÃriaux');
-INSERT INTO gifi (accno,description) VALUES ('8340','Salaires directs');
-INSERT INTO gifi (accno,description) VALUES ('8350','Avantages sociaux relatifs aux salaires directs');
-INSERT INTO gifi (accno,description) VALUES ('8360','Fournisseurs et sous-traitants');
-INSERT INTO gifi (accno,description) VALUES ('8370','CoÃts de production (autres que ressources naturelles)');
-INSERT INTO gifi (accno,description) VALUES ('8400','CoÃts de production des ressources naturelles');
-INSERT INTO gifi (accno,description) VALUES ('8401','Exploitation des pipelines');
-INSERT INTO gifi (accno,description) VALUES ('8402','Forage');
-INSERT INTO gifi (accno,description) VALUES ('8403','CoÃts de restauration des sites d\'exploitation');
-INSERT INTO gifi (accno,description) VALUES ('8404','Redevances dÃrogatoires brutes');
-INSERT INTO gifi (accno,description) VALUES ('8405','Redevances de propriÃtÃ franche');
-INSERT INTO gifi (accno,description) VALUES ('8406','Paiements de location de concessions publiques');
-INSERT INTO gifi (accno,description) VALUES ('8407','Prospection/travaux de gÃologie');
-INSERT INTO gifi (accno,description) VALUES ('8408','Exploitation des puits, carburant et matÃriel');
-INSERT INTO gifi (accno,description) VALUES ('8409','Abandon de puits et puits secs');
-INSERT INTO gifi (accno,description) VALUES ('8410','Autres paiements de location');
-INSERT INTO gifi (accno,description) VALUES ('8411','Frais d\'exploration');
-INSERT INTO gifi (accno,description) VALUES ('8412','Frais d\'amÃnagement');
-INSERT INTO gifi (accno,description) VALUES ('8435','Sommes exigÃes par la Couronne');
-INSERT INTO gifi (accno,description) VALUES ('8436','Redevances Ã la Couronne');
-INSERT INTO gifi (accno,description) VALUES ('8437','Frais de location de la Couronne');
-INSERT INTO gifi (accno,description) VALUES ('8438','ImpÃts sur le minerai de propriÃtÃ franche');
-INSERT INTO gifi (accno,description) VALUES ('8439','ImpÃts miniers');
-INSERT INTO gifi (accno,description) VALUES ('8440','Frais de location des sables bitumineux');
-INSERT INTO gifi (accno,description) VALUES ('8441','Surtaxe de la Saskatchewan sur les ressources');
-INSERT INTO gifi (accno,description) VALUES ('8450','Autres coÃts directs');
-INSERT INTO gifi (accno,description) VALUES ('8451','Location et exploitation de matÃriel');
-INSERT INTO gifi (accno,description) VALUES ('8452','Cour Ã bois');
-INSERT INTO gifi (accno,description) VALUES ('8453','CoÃts d\'exploitation forestiÃre');
-INSERT INTO gifi (accno,description) VALUES ('8454','CoÃts des chemins forestiers');
-INSERT INTO gifi (accno,description) VALUES ('8455','Droits de coupe');
-INSERT INTO gifi (accno,description) VALUES ('8456','CoÃts des redevances');
-INSERT INTO gifi (accno,description) VALUES ('8457','Frais de transport Ã l\'achat et droits');
-INSERT INTO gifi (accno,description) VALUES ('8458','Moins-value de l\'inventaire');
-INSERT INTO gifi (accno,description) VALUES ('8459','CoÃt direct de l\'amortissement des biens corporels');
-INSERT INTO gifi (accno,description) VALUES ('8460','CoÃt direct de l\'amortissement des biens constituÃs');
-INSERT INTO gifi (accno,description) VALUES ('8461','Autres frais indirects attribuÃs au coÃt des ventes');
-INSERT INTO gifi (accno,description) VALUES ('8500','Stock de fermeture');
-INSERT INTO gifi (accno,description) VALUES ('8501','Stock de fermeture Â produits finis');
-INSERT INTO gifi (accno,description) VALUES ('8502','Stock de fermeture Â matiÃres premiÃres');
-INSERT INTO gifi (accno,description) VALUES ('8503','Stock de fermeture Â travaux en cours de fabrication');
-INSERT INTO gifi (accno,description) VALUES ('8518','CoÃt des ventes');
-INSERT INTO gifi (accno,description) VALUES ('8519','Profit brut/perte brute');
-INSERT INTO gifi (accno,description) VALUES ('8520','PublicitÃ et promotion');
-INSERT INTO gifi (accno,description) VALUES ('8521','PublicitÃ');
-INSERT INTO gifi (accno,description) VALUES ('8522','Dons');
-INSERT INTO gifi (accno,description) VALUES ('8523','Repas et frais de reprÃsentation');
-INSERT INTO gifi (accno,description) VALUES ('8524','Promotion');
-INSERT INTO gifi (accno,description) VALUES ('8570','Amortissement de biens incorporels');
-INSERT INTO gifi (accno,description) VALUES ('8590','CrÃances irrÃcouvrables');
-INSERT INTO gifi (accno,description) VALUES ('8610','Pertes sur prÃts');
-INSERT INTO gifi (accno,description) VALUES ('8611','Provision pour les pertes sur prÃts');
-INSERT INTO gifi (accno,description) VALUES ('8620','Avantages sociaux');
-INSERT INTO gifi (accno,description) VALUES ('8621','Assurances collectives');
-INSERT INTO gifi (accno,description) VALUES ('8622','Partie de l\'employeur des avantages sociaux');
-INSERT INTO gifi (accno,description) VALUES ('8623','Cotisations aux rÃgimes de revenus diffÃrÃs');
-INSERT INTO gifi (accno,description) VALUES ('8650','Amortissement des biens constituÃs par des ressources naturelles');
-INSERT INTO gifi (accno,description) VALUES ('8670','Amortissement des biens corporels');
-INSERT INTO gifi (accno,description) VALUES ('8690','Assurances');
-INSERT INTO gifi (accno,description) VALUES ('8691','Assurance sur la vie des dirigeants');
-INSERT INTO gifi (accno,description) VALUES ('8710','IntÃrÃts et frais bancaires');
-INSERT INTO gifi (accno,description) VALUES ('8711','IntÃrÃts sur les dettes Ã court terme');
-INSERT INTO gifi (accno,description) VALUES ('8712','IntÃrÃts sur les obligations et les dÃbentures');
-INSERT INTO gifi (accno,description) VALUES ('8713','IntÃrÃts sur les prÃts hypothÃcaires');
-INSERT INTO gifi (accno,description) VALUES ('8714','IntÃrÃts sur les dettes Ã long terme');
-INSERT INTO gifi (accno,description) VALUES ('8715','Frais bancaires');
-INSERT INTO gifi (accno,description) VALUES ('8716','Frais de cartes de crÃdit');
-INSERT INTO gifi (accno,description) VALUES ('8717','Frais de recouvrement et de crÃdit');
-INSERT INTO gifi (accno,description) VALUES ('8740','IntÃrÃts payÃs (institutions financiÃres)');
-INSERT INTO gifi (accno,description) VALUES ('8741','IntÃrÃts payÃs sur dÃpÃts');
-INSERT INTO gifi (accno,description) VALUES ('8742','IntÃrÃts payÃs sur les obligations et les dÃbentures');
-INSERT INTO gifi (accno,description) VALUES ('8760','Taxes d\'affaires, droits d\'adhÃsion et licences');
-INSERT INTO gifi (accno,description) VALUES ('8761','Droits d\'adhÃsion');
-INSERT INTO gifi (accno,description) VALUES ('8762','Taxes d\'affaires');
-INSERT INTO gifi (accno,description) VALUES ('8763','Frais de franchise');
-INSERT INTO gifi (accno,description) VALUES ('8764','Frais Ã verser aux gouvernements');
-INSERT INTO gifi (accno,description) VALUES ('8780','Taxe des grandes sociÃtÃs du Nouveau-Brunswick');
-INSERT INTO gifi (accno,description) VALUES ('8790','Taxe des grandes sociÃtÃs de la Nouvelle-Ãcosse');
-INSERT INTO gifi (accno,description) VALUES ('8810','Frais de bureau');
-INSERT INTO gifi (accno,description) VALUES ('8811','Papeterie et fournitures de bureau');
-INSERT INTO gifi (accno,description) VALUES ('8812','Services de bureau');
-INSERT INTO gifi (accno,description) VALUES ('8813','Traitement des donnÃes');
-INSERT INTO gifi (accno,description) VALUES ('8860','Honoraires professionnels');
-INSERT INTO gifi (accno,description) VALUES ('8861','Frais lÃgaux');
-INSERT INTO gifi (accno,description) VALUES ('8862','Frais comptables');
-INSERT INTO gifi (accno,description) VALUES ('8863','Honoraires d\'experts-conseils');
-INSERT INTO gifi (accno,description) VALUES ('8864','Honoraires d\'architectes');
-INSERT INTO gifi (accno,description) VALUES ('8865','Frais d\'Ãvaluation');
-INSERT INTO gifi (accno,description) VALUES ('8866','Frais de laboratoire');
-INSERT INTO gifi (accno,description) VALUES ('8867','Honoraires mÃdicaux');
-INSERT INTO gifi (accno,description) VALUES ('8868','Frais de vÃtÃrinaire');
-INSERT INTO gifi (accno,description) VALUES ('8869','Frais de courtage');
-INSERT INTO gifi (accno,description) VALUES ('8870','Frais de transfert');
-INSERT INTO gifi (accno,description) VALUES ('8871','Frais de gestion et d\'administration');
-INSERT INTO gifi (accno,description) VALUES ('8872','Affinage et dosage');
-INSERT INTO gifi (accno,description) VALUES ('8873','Droits d\'enregistrement et frais d\'agents de transfert');
-INSERT INTO gifi (accno,description) VALUES ('8874','CoÃts de restructuration');
-INSERT INTO gifi (accno,description) VALUES ('8875','Commissions sur les titres et les valeurs mobiliÃres');
-INSERT INTO gifi (accno,description) VALUES ('8876','Frais de formation');
-INSERT INTO gifi (accno,description) VALUES ('8877','Studio et enregistrement');
-INSERT INTO gifi (accno,description) VALUES ('8910','Frais de location');
-INSERT INTO gifi (accno,description) VALUES ('8911','Loyer de biens immobiliers');
-INSERT INTO gifi (accno,description) VALUES ('8912','Frais d\'occupation');
-INSERT INTO gifi (accno,description) VALUES ('8913','Frais de copropriÃtÃ');
-INSERT INTO gifi (accno,description) VALUES ('8914','Location de matÃriel');
-INSERT INTO gifi (accno,description) VALUES ('8915','Location de vÃhicules motorisÃs');
-INSERT INTO gifi (accno,description) VALUES ('8916','Amarrage (bateau)');
-INSERT INTO gifi (accno,description) VALUES ('8917','Entreposage');
-INSERT INTO gifi (accno,description) VALUES ('8918','Location de contingents');
-INSERT INTO gifi (accno,description) VALUES ('8960','RÃparations et entretien');
-INSERT INTO gifi (accno,description) VALUES ('8961','RÃparations et entretien Â bÃtiments');
-INSERT INTO gifi (accno,description) VALUES ('8962','RÃparations et entretien Â vÃhicules');
-INSERT INTO gifi (accno,description) VALUES ('8963','RÃparations et entretien Â bateaux');
-INSERT INTO gifi (accno,description) VALUES ('8964','RÃparations et entretien Â machines et matÃriel');
-INSERT INTO gifi (accno,description) VALUES ('9010','Autres frais de rÃparation et d\'entretien');
-INSERT INTO gifi (accno,description) VALUES ('9011','DÃpense d\'usinage');
-INSERT INTO gifi (accno,description) VALUES ('9012','Frais relatifs aux routes');
-INSERT INTO gifi (accno,description) VALUES ('9013','SÃcuritÃ');
-INSERT INTO gifi (accno,description) VALUES ('9014','EnlÃvement des dÃchets');
-INSERT INTO gifi (accno,description) VALUES ('9060','Salaires et traitements');
-INSERT INTO gifi (accno,description) VALUES ('9061','Commissions');
-INSERT INTO gifi (accno,description) VALUES ('9062','Part de l\'Ãquipage');
-INSERT INTO gifi (accno,description) VALUES ('9063','Gratifications');
-INSERT INTO gifi (accno,description) VALUES ('9064','Jetons de prÃsence des administrateurs');
-INSERT INTO gifi (accno,description) VALUES ('9065','Salaires des cadres');
-INSERT INTO gifi (accno,description) VALUES ('9066','Salaires des employÃs');
-INSERT INTO gifi (accno,description) VALUES ('9110','Contrats de sous-traitance');
-INSERT INTO gifi (accno,description) VALUES ('9130','Fournitures');
-INSERT INTO gifi (accno,description) VALUES ('9131','Petit outillage');
-INSERT INTO gifi (accno,description) VALUES ('9132','Frais d\'atelier');
-INSERT INTO gifi (accno,description) VALUES ('9133','Uniformes');
-INSERT INTO gifi (accno,description) VALUES ('9134','Blanchissage');
-INSERT INTO gifi (accno,description) VALUES ('9135','Alimentation et restauration');
-INSERT INTO gifi (accno,description) VALUES ('9136','MatÃriel de pÃche');
-INSERT INTO gifi (accno,description) VALUES ('9137','Filets et piÃges');
-INSERT INTO gifi (accno,description) VALUES ('9138','Sel, appÃts et glace');
-INSERT INTO gifi (accno,description) VALUES ('9139','Fournitures de camp');
-INSERT INTO gifi (accno,description) VALUES ('9150','DÃpenses liÃes Ã l\'informatique');
-INSERT INTO gifi (accno,description) VALUES ('9151','AmÃliorations et modernisations');
-INSERT INTO gifi (accno,description) VALUES ('9152','Internet');
-INSERT INTO gifi (accno,description) VALUES ('9180','Taxes fonciÃres');
-INSERT INTO gifi (accno,description) VALUES ('9200','Frais de dÃplacement');
-INSERT INTO gifi (accno,description) VALUES ('9220','Services publics');
-INSERT INTO gifi (accno,description) VALUES ('9221','ÃlectricitÃ');
-INSERT INTO gifi (accno,description) VALUES ('9222','Eau');
-INSERT INTO gifi (accno,description) VALUES ('9223','Chauffage');
-INSERT INTO gifi (accno,description) VALUES ('9224','Frais de carburant');
-INSERT INTO gifi (accno,description) VALUES ('9270','Autres dÃpenses');
-INSERT INTO gifi (accno,description) VALUES ('9271','Ãcarts de caisse');
-INSERT INTO gifi (accno,description) VALUES ('9272','Remboursement de frais de la sociÃtÃ mÃre');
-INSERT INTO gifi (accno,description) VALUES ('9273','Frais de vente');
-INSERT INTO gifi (accno,description) VALUES ('9274','Frais de transport et d\'entreposage');
-INSERT INTO gifi (accno,description) VALUES ('9275','Livraison, fret et messageries');
-INSERT INTO gifi (accno,description) VALUES ('9276','Frais de garantie');
-INSERT INTO gifi (accno,description) VALUES ('9277','Frais de redevances Â rÃsidents');
-INSERT INTO gifi (accno,description) VALUES ('9278','Frais de redevances Â non-rÃsidents');
-INSERT INTO gifi (accno,description) VALUES ('9279','Frais de dÃchargement');
-INSERT INTO gifi (accno,description) VALUES ('9280','Frais d\'enfouissement');
-INSERT INTO gifi (accno,description) VALUES ('9281','Frais de vÃhicules');
-INSERT INTO gifi (accno,description) VALUES ('9282','Recherche et dÃveloppement');
-INSERT INTO gifi (accno,description) VALUES ('9283','Retenues d\'impÃts');
-INSERT INTO gifi (accno,description) VALUES ('9284','Frais d\'administration et frais gÃnÃraux');
-INSERT INTO gifi (accno,description) VALUES ('9285','DÃpenses entre divisions');
-INSERT INTO gifi (accno,description) VALUES ('9286','Transferts interfonds');
-INSERT INTO gifi (accno,description) VALUES ('9367','Total des frais d\'exploitation');
-INSERT INTO gifi (accno,description) VALUES ('9368','Total des dÃpenses');
-INSERT INTO gifi (accno,description) VALUES ('9369','Revenu non agricole net');
-INSERT INTO gifi (accno,description) VALUES ('9370','Grains et olÃagineux');
-INSERT INTO gifi (accno,description) VALUES ('9371','BlÃ');
-INSERT INTO gifi (accno,description) VALUES ('9372','Avoine');
-INSERT INTO gifi (accno,description) VALUES ('9373','Orge');
-INSERT INTO gifi (accno,description) VALUES ('9374','Grains mixtes');
-INSERT INTO gifi (accno,description) VALUES ('9375','MaÃs');
-INSERT INTO gifi (accno,description) VALUES ('9376','Canola');
-INSERT INTO gifi (accno,description) VALUES ('9377','Graine de lin');
-INSERT INTO gifi (accno,description) VALUES ('9378','FÃves soya');
-INSERT INTO gifi (accno,description) VALUES ('9379','Paiements de la Commission canadienne du blÃ');
-INSERT INTO gifi (accno,description) VALUES ('9420','Revenus d\'autres rÃcoltes');
-INSERT INTO gifi (accno,description) VALUES ('9421','Fruits');
-INSERT INTO gifi (accno,description) VALUES ('9422','Pommes de terre');
-INSERT INTO gifi (accno,description) VALUES ('9423','LÃgumes');
-INSERT INTO gifi (accno,description) VALUES ('9424','Tabac');
-INSERT INTO gifi (accno,description) VALUES ('9425','Produits de serre et de pÃpiniÃre');
-INSERT INTO gifi (accno,description) VALUES ('9426','RÃcolte de fourrage');
-INSERT INTO gifi (accno,description) VALUES ('9470','Revenus du bÃtail et des produits d\'origine');
-INSERT INTO gifi (accno,description) VALUES ('9471','Bovins');
-INSERT INTO gifi (accno,description) VALUES ('9472','Porcins');
-INSERT INTO gifi (accno,description) VALUES ('9473','Volaille');
-INSERT INTO gifi (accno,description) VALUES ('9474','Ovins');
-INSERT INTO gifi (accno,description) VALUES ('9475','Urine de jument gravide (UJG)');
-INSERT INTO gifi (accno,description) VALUES ('9476','Lait et crÃme (Ã l\'exclusion des subventions pour');
-INSERT INTO gifi (accno,description) VALUES ('9477','OEufs pour la consommation');
-INSERT INTO gifi (accno,description) VALUES ('9478','Couvaison des oeufs');
-INSERT INTO gifi (accno,description) VALUES ('9479','Aquaculture (couvÃe et Ãlevage)');
-INSERT INTO gifi (accno,description) VALUES ('9480','Chevaux (reproduction et viande)');
-INSERT INTO gifi (accno,description) VALUES ('9520','Autres produits');
-INSERT INTO gifi (accno,description) VALUES ('9521','Produits de l\'Ãrable');
-INSERT INTO gifi (accno,description) VALUES ('9522','InsÃmination artificielle');
-INSERT INTO gifi (accno,description) VALUES ('9523','Production de sperme');
-INSERT INTO gifi (accno,description) VALUES ('9524','Production d\'embryon');
-INSERT INTO gifi (accno,description) VALUES ('9540','Revenus des paiements de programmes');
-INSERT INTO gifi (accno,description) VALUES ('9541','Subventions laitiÃres');
-INSERT INTO gifi (accno,description) VALUES ('9542','Assurance-rÃcolte');
-INSERT INTO gifi (accno,description) VALUES ('9543','Paiements du CSRN');
-INSERT INTO gifi (accno,description) VALUES ('9544','Paiements provenant du programme d\'aide en cas de catastrophe');
-INSERT INTO gifi (accno,description) VALUES ('9570','Remises');
-INSERT INTO gifi (accno,description) VALUES ('9571','Remises Â carburant');
-INSERT INTO gifi (accno,description) VALUES ('9572','Remises Â intÃrÃt');
-INSERT INTO gifi (accno,description) VALUES ('9573','Remises Â taxes fonciÃres');
-INSERT INTO gifi (accno,description) VALUES ('9574','Reventes, Remises de la TPS pour les dÃpenses');
-INSERT INTO gifi (accno,description) VALUES ('9575','Remises de la TPS pour les dÃpenses non');
-INSERT INTO gifi (accno,description) VALUES ('9600','Autres revenus/pertes agricoles');
-INSERT INTO gifi (accno,description) VALUES ('9601','Travail sur commande ou en sous-traitance');
-INSERT INTO gifi (accno,description) VALUES ('9602','Ventes de bois');
-INSERT INTO gifi (accno,description) VALUES ('9603','Courses de chevaux');
-INSERT INTO gifi (accno,description) VALUES ('9604','Produits d\'assurance');
-INSERT INTO gifi (accno,description) VALUES ('9605','Ristournes');
-INSERT INTO gifi (accno,description) VALUES ('9606','Revenu de location');
-INSERT INTO gifi (accno,description) VALUES ('9607','Revenu en intÃrÃt');
-INSERT INTO gifi (accno,description) VALUES ('9608','Revenu de dividendes');
-INSERT INTO gifi (accno,description) VALUES ('9609','Profits/pertes sur la disposition de biens');
-INSERT INTO gifi (accno,description) VALUES ('9610','Gravier');
-INSERT INTO gifi (accno,description) VALUES ('9611','Camionnage');
-INSERT INTO gifi (accno,description) VALUES ('9612','Revente des denrÃes achetÃes');
-INSERT INTO gifi (accno,description) VALUES ('9613','Contrat-location (carburant, huile, puits, superficie, etc.)');
-INSERT INTO gifi (accno,description) VALUES ('9614','Location de machines');
-INSERT INTO gifi (accno,description) VALUES ('9615','Revenus/pertes des sociÃtÃs de personnes agricoles');
-INSERT INTO gifi (accno,description) VALUES ('9616','Revenus/pertes des coentreprises agricoles');
-INSERT INTO gifi (accno,description) VALUES ('9650','Revenu non agricole');
-INSERT INTO gifi (accno,description) VALUES ('9659','Total des revenus agricoles');
-INSERT INTO gifi (accno,description) VALUES ('9660','DÃpenses liÃes aux rÃcoltes');
-INSERT INTO gifi (accno,description) VALUES ('9661','Contenants, ficelles et fils pour emballage');
-INSERT INTO gifi (accno,description) VALUES ('9662','Engrais et chaux');
-INSERT INTO gifi (accno,description) VALUES ('9663','Pesticides');
-INSERT INTO gifi (accno,description) VALUES ('9664','Semences et plantes');
-INSERT INTO gifi (accno,description) VALUES ('9665','Primes d\'assurance (rÃcolte) CSRN SAR');
-INSERT INTO gifi (accno,description) VALUES ('9710','DÃpenses liÃes au bÃtail');
-INSERT INTO gifi (accno,description) VALUES ('9711','Fourrage, supplÃments, paille et litiÃre');
-INSERT INTO gifi (accno,description) VALUES ('9712','Achats de bÃtail');
-INSERT INTO gifi (accno,description) VALUES ('9713','Frais de vÃtÃrinaire, de mÃdicaments et de reproduction');
-INSERT INTO gifi (accno,description) VALUES ('9714','Sel et minÃraux');
-INSERT INTO gifi (accno,description) VALUES ('9760','DÃpenses liÃes aux machines');
-INSERT INTO gifi (accno,description) VALUES ('9761','Assurance pour les machines');
-INSERT INTO gifi (accno,description) VALUES ('9762','Plaques pour les machines');
-INSERT INTO gifi (accno,description) VALUES ('9763','RÃparation des machines');
-INSERT INTO gifi (accno,description) VALUES ('9764','Carburant pour les machines');
-INSERT INTO gifi (accno,description) VALUES ('9765','Contrat-location de machines');
-INSERT INTO gifi (accno,description) VALUES ('9790','DÃpenses agricoles gÃnÃrales');
-INSERT INTO gifi (accno,description) VALUES ('9791','Amortissement des biens corporels');
-INSERT INTO gifi (accno,description) VALUES ('9792','PublicitÃ, promotion et dÃpenses de mise en marchÃ');
-INSERT INTO gifi (accno,description) VALUES ('9793','Mauvaises crÃances');
-INSERT INTO gifi (accno,description) VALUES ('9794','Avantages sociaux liÃs aux salaires des employÃs');
-INSERT INTO gifi (accno,description) VALUES ('9795','RÃparations et entretien des bÃtiments');
-INSERT INTO gifi (accno,description) VALUES ('9796','DÃfrichage, nivellement et drainage de terrains');
-INSERT INTO gifi (accno,description) VALUES ('9797','Primes d\'assurance-rÃcolte, de RARB et de');
-INSERT INTO gifi (accno,description) VALUES ('9798','Travail sur commande ou en sous-traitance');
-INSERT INTO gifi (accno,description) VALUES ('9799','ÃlectricitÃ');
-INSERT INTO gifi (accno,description) VALUES ('9800','RÃparations et entretien des clÃtures');
-INSERT INTO gifi (accno,description) VALUES ('9801','Fret et camionnage');
-INSERT INTO gifi (accno,description) VALUES ('9802','Combustible pour chauffage et pour salaison');
-INSERT INTO gifi (accno,description) VALUES ('9803','Remboursement de paiements en trop provenant');
-INSERT INTO gifi (accno,description) VALUES ('9804','Autres primes d\'assurance');
-INSERT INTO gifi (accno,description) VALUES ('9805','IntÃrÃts et frais bancaires');
-INSERT INTO gifi (accno,description) VALUES ('9806','Droits versÃs Ã des offices de commercialisation');
-INSERT INTO gifi (accno,description) VALUES ('9807','Frais d\'adhÃsion');
-INSERT INTO gifi (accno,description) VALUES ('9808','DÃpenses de bureau');
-INSERT INTO gifi (accno,description) VALUES ('9809','Honoraires professionnels');
-INSERT INTO gifi (accno,description) VALUES ('9810','Taxes fonciÃres');
-INSERT INTO gifi (accno,description) VALUES ('9811','Location Â terrain et bÃtiments');
-INSERT INTO gifi (accno,description) VALUES ('9812','Location Â machines');
-INSERT INTO gifi (accno,description) VALUES ('9813','Autres frais de location');
-INSERT INTO gifi (accno,description) VALUES ('9814','Salaires et traitements');
-INSERT INTO gifi (accno,description) VALUES ('9815','Salaires (autre que conjoint et personnes Ã charge)');
-INSERT INTO gifi (accno,description) VALUES ('9816','Salaires versÃs aux personnes Ã charge');
-INSERT INTO gifi (accno,description) VALUES ('9817','CoÃts des ventes');
-INSERT INTO gifi (accno,description) VALUES ('9818','Fournitures');
-INSERT INTO gifi (accno,description) VALUES ('9819','DÃpenses concernant les vÃhicules motorisÃs');
-INSERT INTO gifi (accno,description) VALUES ('9820','Petit outillage');
-INSERT INTO gifi (accno,description) VALUES ('9821','Analyses des sols');
-INSERT INTO gifi (accno,description) VALUES ('9822','Entreposage/sÃchage');
-INSERT INTO gifi (accno,description) VALUES ('9823','Licences/permis');
-INSERT INTO gifi (accno,description) VALUES ('9824','TÃlÃphone');
-INSERT INTO gifi (accno,description) VALUES ('9825','Location de contingents (tabac, laitier)');
-INSERT INTO gifi (accno,description) VALUES ('9826','Gravier');
-INSERT INTO gifi (accno,description) VALUES ('9827','Achats de produits pour la revente');
-INSERT INTO gifi (accno,description) VALUES ('9828','Salaires et traitements payÃs au conjoint');
-INSERT INTO gifi (accno,description) VALUES ('9829','CoÃts de location et intÃrÃt sur un vÃhicule');
-INSERT INTO gifi (accno,description) VALUES ('9830','Aliments prÃparÃs');
-INSERT INTO gifi (accno,description) VALUES ('9831','Engraissement Ã forfait');
-INSERT INTO gifi (accno,description) VALUES ('9832','Amortissement des biens incorporels');
-INSERT INTO gifi (accno,description) VALUES ('9833','Amortissement de quote-part de lait');
-INSERT INTO gifi (accno,description) VALUES ('9834','Frais de dÃplacement');
-INSERT INTO gifi (accno,description) VALUES ('9835','Taxes d\'affaires/sur le capital');
-INSERT INTO gifi (accno,description) VALUES ('9850','DÃpenses non agricoles');
-INSERT INTO gifi (accno,description) VALUES ('9870','RÃgularisation des stocks');
-INSERT INTO gifi (accno,description) VALUES ('9899','Total des revenus agricoles nets');
-INSERT INTO gifi (accno,description) VALUES ('9970','Revenu net/perte nette avant impÃts et ÃlÃments');
-INSERT INTO gifi (accno,description) VALUES ('9975','ÃlÃment(s) extraordinaire(s)');
-INSERT INTO gifi (accno,description) VALUES ('9976','RÃglements juridiques');
-INSERT INTO gifi (accno,description) VALUES ('9980','Profits/pertes non matÃrialisÃs');
-INSERT INTO gifi (accno,description) VALUES ('9985','ÃlÃments inhabituels');
-INSERT INTO gifi (accno,description) VALUES ('9990','ImpÃts sur le revenu exigibles de l\'exercice');
-INSERT INTO gifi (accno,description) VALUES ('9995','Provision pour impÃts sur le revenu diffÃrÃs');
-INSERT INTO gifi (accno,description) VALUES ('9999','Revenu net/perte nette aprÃs impÃts et ÃlÃments');
-commit;

Deleted: trunk/sql/Canada-Quebec_General-UTF8-chart.sql
===================================================================
--- trunk/sql/Canada-Quebec_General-UTF8-chart.sql	2006-11-15 04:51:45 UTC (rev 611)
+++ trunk/sql/Canada-Quebec_General-UTF8-chart.sql	2006-11-15 04:53:55 UTC (rev 612)
@@ -1,92 +0,0 @@
-begin;
--- General French-Canadian (AKA QuÃbÃcois) COA
--- sample only
-
--- translated and adapted from the General Canadian COA, with the help
--- of the Grand Dictionnaire Terminologique:
--- http://granddictionnaire.com/
-
--- Some provisions have been made for QuÃbec-specifics, namely:
--- TVQ/TPS terminology, CSST, Assurance-emploi, RRQ, TVQ rate
-
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1000', 'ACTIF COURANT', 'H', 'A', '', '1000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1060', 'Compte chÃque', 'A', 'A', 'AR_paid:AP_paid', '1002');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1065', 'Petite caisse', 'A', 'A', 'AR_paid:AP_paid', '1001');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1200', 'Comptes clients', 'A', 'A', 'AR', '1060');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1205', 'Provisions pour crÃances douteuses', 'A', 'A', '', '1063');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1500', 'STOCKS', 'H', 'A', '', '1120');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1520', 'Stocks / GÃnÃral', 'A', 'A', 'IC', '1122');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1530', 'Stocks / PiÃces de rechange', 'A', 'A', 'IC', '1122');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1540', 'Stocks / MatiÃres premiÃres', 'A', 'A', 'IC', '1122');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1800', 'AUTRES IMMOBILISATIONS', 'H', 'A', '', '1900');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1820', 'Meubles et accessoires', 'A', 'A', '', '1787');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1825', 'Amortissement cumulÃ des meubles et des accessoires', 'A', 'A', '', '1788', '1');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1840', 'VÃhicules automobiles', 'A', 'A', '', '1742');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1845', 'Amortissement cumulÃ des vÃhicules automobiles', 'A', 'A', '', '1743', '1');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2000', 'PASSIF COURANT', 'H', 'L', '', '2620');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2100', 'Comptes fournisseurs', 'A', 'L', 'AP', '2621');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2160', 'Taxes fÃdÃrales Ã payer', 'A', 'L', '', '2683');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2170', 'Taxes provinciales Ã payer', 'A', 'L', '', '2684');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2310', 'TPS', 'A', 'L', 'AR_tax:AP_tax:IC_taxpart:IC_taxservice', '2685');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2320', 'TVQ', 'A', 'L', 'AR_tax:AP_tax:IC_taxpart:IC_taxservice', '2686');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2380', 'IndemnitÃs de vacances Ã payer', 'A', 'L', '', '2624');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2390', 'CSST Ã payer', 'A', 'L', '', '2627');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2400', 'RETENUES SUR SALAIRE', 'H', 'L', '', '2620');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2410', 'Assurance-emploi Ã payer', 'A', 'L', '', '2627');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2420', 'RRQ Ã payer', 'A', 'L', '', '2627');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2450', 'ImpÃt sur le revenu Ã payer', 'A', 'L', '', '2628');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2600', 'PASSIF Ã LONG TERME', 'H', 'L', '', '3140');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2620', 'Emprunts bancaires', 'A', 'L', '', '2701');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2680', 'Emprunt auprÃs des actionnaires', 'A', 'L', 'AP_paid', '2780');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3300', 'CAPITAL SOCIAL', 'H', 'Q', '', '3500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3350', 'Actions ordinaires', 'A', 'Q', '', '3500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4000', 'REVENUS DE VENTE', 'H', 'I', '', '8000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4020', 'Ventes gÃnÃrales', 'A', 'I', 'AR_amount:IC_sale:IC_income', '8000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4030', 'PiÃces de rechange', 'A', 'I', 'AR_amount:IC_sale', '8000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4400', 'AUTRES REVENUS', 'H', 'I', '', '8090');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4430', 'Transport et manutention', 'A', 'I', 'IC_income', '8457');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4440', 'IntÃrÃts', 'A', 'I', 'IC_income', '8090');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4450', 'Gain sur change', 'A', 'I', '', '8231');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5000', 'COÃT DES PRODUITS VENDUS', 'H', 'E', '', '8515');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5010', 'Achats', 'A', 'E', 'AP_amount:IC_cogs:IC_expense', '8320');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5050', 'PiÃces de rechange', 'A', 'E', 'AP_amount:IC_cogs', '8320');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5100', 'Frais de transport', 'A', 'E', 'AP_amount:IC_expense', '8457');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5400', 'FRAIS DE PERSONNEL', 'H', 'E', '', '');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5410', 'Salaires', 'A', 'E', '', '9060');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5420', 'DÃpenses d\'assurance-emploi', 'A', 'E', '', '8622');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5430', 'DÃpenses RRQ', 'A', 'E', '', '8622');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5440', 'DÃpenses CSST', 'A', 'E', '', '8622');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5600', 'DÃPENSES ADMINISTRATIVES ET GÃNÃRALES', 'H', 'E', '', '');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5610', 'Frais comptables et juridiques', 'A', 'E', 'AP_amount', '8862');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5615', 'PublicitÃ et promotion', 'A', 'E', 'AP_amount', '8520');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5620', 'CrÃances irrÃvocables', 'A', 'E', '', '8590');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5660', 'Amortissement de l\'exercice', 'A', 'E', '', '8670');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5680', 'ImpÃt sur le revenu', 'A', 'E', '', '9990');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5685', 'Assurances', 'A', 'E', 'AP_amount', '9804');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5690', 'IntÃrÃts et frais bancaires', 'A', 'E', '', '9805');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5700', 'Fournitures de bureau', 'A', 'E', 'AP_amount', '8811');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5760', 'Loyer', 'A', 'E', 'AP_amount', '9811');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5780', 'TÃlÃphone', 'A', 'E', 'AP_amount', '9225');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5785', 'Voyages et loisirs', 'A', 'E', '', '8523');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5790', 'Services publics', 'A', 'E', 'AP_amount', '8812');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5765', 'RÃparation et entretien', 'A', 'E', 'AP_amount', '8964');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5800', 'Taxes d\'affaires, droits d\'adhÃsion et permis', 'A', 'E', 'AP_amount', '8760');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5810', 'Perte sur change', 'A', 'E', '', '8231');
---
-insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.06);
-insert into tax (chart_id,rate,pass) values ((select id from chart where accno = '2320'),0.075,1);
---
-INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '4450'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '4450'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('curr', 'CAD:USD:EUR');
-
- INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
-commit;

Deleted: trunk/sql/Danish_Default-UTF8-chart.sql
===================================================================
--- trunk/sql/Danish_Default-UTF8-chart.sql	2006-11-15 04:51:45 UTC (rev 611)
+++ trunk/sql/Danish_Default-UTF8-chart.sql	2006-11-15 04:53:55 UTC (rev 612)
@@ -1,89 +0,0 @@
-begin;
--- Default chart of accounts
--- sample only
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1000','KORTFRISTEDE AKTIVER','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1061','Bank','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1065','Kasse','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1200','Indbetalinger','A','','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1205','HensÃttelser til formodet gÃld','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1210','Moms indgÃende','A','','A','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1500','LAGER-AKTIVER','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1520','Lager / udstyr','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1530','Lager / programmel','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1540','Lager / tillÃgssalg','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1550','Lager / arrangementer','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1800','AKTIVER','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1820','Kontorinventar og -udstyr','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('1825','Samlede afskrivninger, inventar, udstyr','A','','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1840','KÃretÃjer','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('1845','Samlede afskrivninger, kÃretÃjer','A','','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2000','KORTFRISTET GÃLD','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2100','Udbetalinger','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2160','Selskabsskat','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2190','Afgifter','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2311','Moms udgÃende','A','','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2600','LANGFRISTET GÃLD','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2620','BanklÃn','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3300','AKTIEKAPITAL','H','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3350','Almindelige aktier','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3500','EGENKAPITAL','H','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3510','Egenkapital primo','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3600','Ãrets resultat','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4000','SALGSINDTÃGT','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4020','Salg / udstyr','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4030','Salg / programmel','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4040','Salg / tillÃgssalg','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4050','Salg / arrangementer','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4300','KONSULENTINDTÃGT','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4320','Konsulentbistand','A','','I','AR_amount:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4330','Programmering','A','','I','AR_amount:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4400','ANDEN INDTÃGT','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4440','Renter','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','SALGSOMKOSTNINGER','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5020','Omkostninger / udstyr','A','','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5010','Anskaffelser under 8.000','A','','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5011','Anskaffelser over 8.000','A','','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5030','Omkostninger / programmel','A','','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5040','Omkostninger / tillÃgssalg','A','','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5050','Omkostninger / arrangementer','A','','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5100','Fragt, post','A','','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5400','LÃNUDGIFTER','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5410','LÃnninger og honorarer','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5420','ATP','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5470','Personalegoder','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5600','GENERELLE & ADMINISTRATIVE UDGIFTER','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5610','BogfÃring, revision, advokat','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5615','Marketing','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5620','DÃrlige skyldnere','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5660','Afdrag pÃ lÃn','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5680','A-skat','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5685','Forsikringer','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5690','Renter og bankgebyrer','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5700','Kontorudgifter','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5760','Husleje','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5765','Vedligeholdelse og reparation','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5780','Telefon','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5785','Rejser & reprÃsentation','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5790','El, vand, varme','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5800','Licenser','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5810','Foreign Exchange Loss','A','','E','');
---
-insert into tax (chart_id,rate) values ((select id from chart where accno = '1210'),0.25);
-insert into tax (chart_id,rate) values ((select id from chart where accno = '2311'),0.25);
---
-INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '4450'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '5810'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('curr', 'DKK');
-
- INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
---
-commit;

Deleted: trunk/sql/Egypt-UTF8-chart.sql
===================================================================
--- trunk/sql/Egypt-UTF8-chart.sql	2006-11-15 04:51:45 UTC (rev 611)
+++ trunk/sql/Egypt-UTF8-chart.sql	2006-11-15 04:53:55 UTC (rev 612)
@@ -1,93 +0,0 @@
-begin;
---
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2210','Workers Comp Payable','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2220','Vacation Pay Payable','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2250','Pension Plan Payable','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2260','Employment Insurance Payable','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5420','Employment Insurance Expense','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5430','Pension Plan Expense','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5440','Workers Comp Expense','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5470','Employee Benefits','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5650','Capital Cost Allowance Expense','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1060','ÙÙØÙØ ØØÙØÙÙ','A','A','AR_paid:AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1065','ÙÙØÙØØØÙØÙØÙÙ','A','A','AR_paid:AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1520','ÙØØÙÙ - ÙØØ ØÙØØ ÙÙØÙÙØØ','A','A','IC','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1530','ÙØØÙÙ - ØØØÙØ','A','A','IC','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1540','ÙØØÙÙ - ÙØØ ØØØÙ','A','A','IC','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1840','ØÙØØØØ','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1000','ØÙØØÙÙ ØÙÙØØØÙÙØ','H','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1500','ØÙÙØØÙÙ ÙØØÙ','H','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1800','ØÙØØÙÙ ØÙØØØØØ','H','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2000','ØÙØØØÙØØ ÙØÙØØ ØÙØØÙ','H','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2600','ØÙØØØÙØØ ØÙÙÙØ ØÙØØÙ','H','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1845','ÙØØØ ØÙÙØÙ ØÙØØØØ','A','A','','','1');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1820','ØØØØ ÙÙØØÙ Ù ÙØØØØ','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1825','ÙØØØ ØÙÙØÙ ØØØØ ÙÙØØÙ Ù ÙØØØØ','A','A','','','1');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2310','ØØÙØØ ÙØÙØØØ (10%)','A','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2320','ØØÙØØ ÙØÙØØØ (14%)','A','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2330','ØØÙØØ ÙØÙØØØ (30%)','A','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1200','ØÙÙØØ','A','A','AR','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1205','ÙØØØ ØÙÙÙ ÙØØÙÙØ','A','A','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2100','ÙÙØØÙÙ','A','L','AP','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2160','ØØÙØØ ØØÙØØ ÙØØØÙØ','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2190','ØØÙØØ ØØÙ ÙØØØÙØ','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2620','ÙØÙØ ÙÙ ØÙØÙÙÙ','A','L','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2680','ÙØÙØ ÙÙ ØÙÙØ ØÙØØÙÙ','A','L','AP_paid','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3300','ØÙÙÙ ØÙÙÙÙÙØ','H','Q','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4020','ÙØÙØØØ - ÙØØ ØÙØØ','A','I','AR_amount:IC_sale','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4030','ÙØÙØØØ ØØØÙØ','A','I','AR_amount:IC_sale','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4040','ÙØÙØØØ ØØØÙ','A','I','AR_amount:IC_sale','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4000','ØÙØØØ ØÙÙØÙØØØ','H','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4300','ØÙØØØ ØØØØØØØØ','H','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4320','ØØØØØØØØ','A','I','AR_amount:IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4330','ØØÙØØ','A','I','AR_amount:IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4400','ØÙØØØØØ ØØØÙ','H','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4430','ØØÙ Ù ØØØØØ','A','I','IC_income','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4440','ÙØØØØ','A','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4450','ØØØØØ ØØÙÙØ ØÙÙØ','A','I','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5000','ØÙÙÙØ ØÙØØØØØ ØÙÙØØØØ','H','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5010','ÙØØØÙØØ','A','E','AP_amount:IC_cogs:IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5020','ØÙÙÙØ ØÙØØØØØ ØÙÙØØØØ - ÙØØ ØÙØØ','A','E','AP_amount:IC_cogs','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5030','ØÙÙÙØ ØÙØØØØØ ØÙÙØØØØ - ØØØÙØ','A','E','AP_amount:IC_cogs','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5040','ØÙÙÙØ ØÙØØØØØ ØÙÙØØØØ - ØØØÙ','A','E','AP_amount:IC_cogs','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5100','ØØÙ','A','E','AP_amount:IC_expense','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5400','ÙØØÙÙØØ ØÙØØÙØ','H','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5410','ØÙÙØØØØØ','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3350','ØÙØØÙÙ','A','Q','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5600','ÙØØÙÙØØ ØØØØÙØ Ù ØÙÙÙÙØ','H','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5610','ÙØÙÙÙÙØ Ù ÙØØØØÙØ','A','E','AP_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5615','ØØØÙØ Ù ØØÙØÙ','A','E','AP_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5765','ØØÙØØ Ù ØÙØÙØ','A','E','AP_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5680','ØØÙØØ ØØÙ','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5685','ØØÙÙÙ','A','E','AP_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5620','ØÙÙÙ ÙØØÙÙØ ','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5660','ÙØØØÙÙ ØÙÙØÙ','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5690','ÙÙØØØ Ù ÙØØØÙÙ ØÙÙÙØ','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5700','ÙÙÙØØ ÙÙØØÙØ','A','E','AP_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5780','ØÙÙÙÙ','A','E','AP_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5760','ØÙØØØ','A','E','AP_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5785','ÙØØØÙÙ ØÙØ','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5795','ØØÙÙ','A','E','AP_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5800','ØØØ','A','E','AP_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5810','ØØØØØ ØØÙÙÙ ØÙÙØ','A','E','','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5790','ÙØØÙÙ','A','E','AP_amount','');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2280','ØØØØØ ÙØØØØØ ÙØØØÙØ','A','L','','');
-
-INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '1520'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '4020'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '5010'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE accno = '4450'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE accno = '5810'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
-INSERT INTO defaults (setting_key, value) VALUES ('curr', 'USD:CAD:EUR';
-
-INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno = '2310'),'0.1',NULL);
-INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno = '2320'),'0.14',NULL);
-INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno = '2330'),'0.3',NULL);
-
-commit;

Deleted: trunk/sql/Spain-UTF8-chart.sql
===================================================================
--- trunk/sql/Spain-UTF8-chart.sql	2006-11-15 04:51:45 UTC (rev 611)
+++ trunk/sql/Spain-UTF8-chart.sql	2006-11-15 04:53:55 UTC (rev 612)
@@ -1,146 +0,0 @@
-begin;
--- Chart of Accounts for Spain (Cuadro del Plan de Contabilidad espaÃol)
--- From: Federico Montesino Pouzols <..hidden..>
--- 23 Apr 2002
---
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('099999999','Grupo 1: financiaciÃn bÃsica','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('100000000','Capital','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('110000000','Reservas','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('120000000','Resultados pendientes de aplicaciÃn','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('130000000','Ingresos a distribuir en varios ejercicios','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('140000000','Provisiones para riesgos y gastos','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('150000000','EmprÃstitos y otras emisiones anÃlogas','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('160000000','Deudas a largo plazo con empresas del grupo y asociadas','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('170000000','Deudas a largo plazo por prestamos recibidos y otros conceptos','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('180000000','Fianzas y depÃsitos recibidos a largo plazo','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('190000000','Situaciones transitorias de financiaciÃn','A','','A','');
---
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('199999999','Grupo 2: inmovilizado','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('200000000','Gastos de establecimiento','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('210000000','Inmovilizaciones inmateriales','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('220000000','Inmovilizaciones materiales','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('230000000','Inmovilizaciones materiales en curso','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('240000000','Inversiones financieras en empresas del grupo y asociadas','A','', 'A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('250000000','Otras inversiones financieras permanentes','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('260000000','Fianzas y depÃsitos constituidos a largo plazo','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('270000000','Gastos a distribuir en varios ejercicios','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('280000000','AmortizaciÃn acumulada del inmovilizado','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('290000000','Provisiones de inmovilizado','A','','A','');
---
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('299999999','Grupo 3: existencias','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('300000000','Comerciales','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('310000000','Materias primas','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('320000000','Otros aprovisionamientos','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('330000000','Productos en curso','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('340000000','Productos semiterminados','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('350000000','Productos terminados','A','','A','IC');

@@ Diff output truncated at 100000 characters. @@

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
Prev by Date: SF.net SVN: ledger-smb: [611] trunk/sql
Next by Date: SF.net SVN: ledger-smb: [613] trunk/sql
Previous by thread: SF.net SVN: ledger-smb: [611] trunk/sql
Next by thread: SF.net SVN: ledger-smb: [613] trunk/sql
Index(es):
- Date
- Thread