diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-03-06 03:32:20 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-03-06 03:32:20 +0000 |
| commit | 65abdb913a18af96946843572f46d8f224278b1f (patch) | |
| tree | a6f69248b51ed9e4ceadf182b1c20636089bd8de /sql/coa/fr | |
| parent | 716c5141fe18cf9f42c9b937c1619137ab46554f (diff) | |
Second installment of re-organized coa files
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@851 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql/coa/fr')
| -rwxr-xr-x | sql/coa/fr/chart/General.sql | 965 |
1 files changed, 965 insertions, 0 deletions
diff --git a/sql/coa/fr/chart/General.sql b/sql/coa/fr/chart/General.sql new file mode 100755 index 00000000..4529a57a --- /dev/null +++ b/sql/coa/fr/chart/General.sql @@ -0,0 +1,965 @@ +begin; +-- Chart of Accounts for France +-- From: Oscar Buijten <oscar@elbie.com> +-- Mon, 6 Aug 2001 +-- +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('101000', 'CAPITAL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('101100', 'CAPITAL SOUSCRIT NON APPELE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('101200', 'CAPITAL SOUSCRIT APPELE NON VERSE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('101300', 'CAPITAL SOUSCRIT APPELE VERSE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('101310', 'CAPITAL NON AMORTI', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('101320', 'CAPITAL AMORTI', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('101800', 'CAPITAL SOUSCR. A REGLEM. PART.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('104000', 'PRIMES LIEES AU CAPITAL SOCIAL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('104100', 'PRIMES D\'EMISSION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('104200', 'PRIMES DE FUSION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('104300', 'PRIMES D\'APPORT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('104400', 'PRIMES CONVERS. OBLIGAT. ACTIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('104500', 'BONS DE SOUSCRIPTION D\'ACTION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('105000', 'ECARTS DE REEVALUATION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('105100', 'RESERVE SPECIALE DE REEVALUATION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('105200', 'ECART DE REEVALUATION LIBRE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('105300', 'RESERVE DE REEVALUATION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('105500', 'ECARTS REEVAL. (AUT. OPER. LEG.)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('105700', 'AUT. ECARTS REEVAL. EN FRANCE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('105800', 'AUT. ECARTS REEVAL. A L\'ETRANGER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106000', 'RESERVES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106100', 'RESERVE LEGALE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106110', 'RESERVE LEGALE PROPREMENT DITE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106120', 'PLUS-VALUES NETTES A LONG TERME', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106200', 'RESERVES INDISPONIBLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106300', 'RESERVES STATUT. OU CONTRACTUELLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106400', 'RESERVES REGLEMENTEES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106410', 'PLUS-VALUES NETTES A LONG TERME', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106430', 'RESER. CONSEC. OCTROI SUBV. INVEST', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106480', 'AUTRES RESERVES REGLEMENTEES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106800', 'AUTRES RESERVES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106810', 'RESERVE DE PROPRE ASSUREUR', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106880', 'RESERVES DIVERSES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('107000', 'ECART D\'EQUIVALENCE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('109000', 'ACTIONN. CAPITAL SOUSC. NON APPELE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('110000', 'REPORT A NOUVEAU (SOLDE CREDITEUR)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('119000', 'REPORT A NOUVEAU (SOLDE DEBITEUR)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('120000', 'RESULTAT DE L\'EXERCICE (BENEFICE)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('129000', 'RESULTAT DE L\'EXERCICE (PERTE)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('131000', 'SUBVENTIONS D\'EQUIPEMENT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('131100', 'ETAT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('131200', 'REGIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('131300', 'DEPARTEMENTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('131400', 'COMMUNES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('131500', 'COLLECTIVITES PUBLIQUES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('131600', 'ENTREPRISES PUBLIQUES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('131700', 'ENTREPRISES ET ORGANISMES PRIVES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('131800', 'AUTRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('138000', 'AUTRES SUBVENTIONS D\'INVESTIS.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('139000', 'SUBV. INVES. INSC. AU CPTE RESULT.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('139100', 'SUBVENTIONS D\'EQUIPEMENT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('139110', 'ETAT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('139120', 'REGIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('139130', 'DEPARTEMENTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('139140', 'COMMUNES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('139150', 'COLLECTIVITES PUBLIQUES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('139160', 'ENTREPRISES PUBLIQUES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('139170', 'ENTREPRISES ET ORGANISMES PRIVES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('139180', 'AUTRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('139800', 'AUTRES SUBVENTIONS D\'INVESTIS.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('142000', 'PROVIS. REGLEM. RELATIV. AUX IMMO.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('142300', 'PROVIS. POUR RECONSTITUTION GIS.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('142400', 'PROVIS. INVESTIS. (PARTIC. SALAR.)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('143000', 'PROVIS. REGLEMENT. RELATIV. STOCKS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('143100', 'HAUSSE DES PRIX', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('143200', 'FLUCTUATION DES COURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('144000', 'PROVIS. REGLEM. RELAT. ELEM. ACTIF', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('145000', 'AMORTISSEMENTS DEROGATOIRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('146000', 'PROVISION SPECIALE DE REEVALUATION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('147000', 'PLUS-VALUES REINVESTIES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('148000', 'AUTRES PROVISIONS REGLEMENTEES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('151000', 'PROVISIONS POUR RISQUES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('151100', 'PROVISIONS POUR LITIGES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('151200', 'PROV. GARANT. DONNEES AUX CLIENTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('151300', 'PROV. PERTES SUR MARCHES A TERME.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('151400', 'PROVIS. POUR AMENDES ET PENALITES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('151500', 'PROVIS. POUR PERTES DE CHANGE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('151800', 'AUTRES PROVISIONS POUR RISQUES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('153000', 'PROVIS. PENSIONS ET OBLIG. SIMIL.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('155000', 'PROVISIONS POUR IMPOTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('156000', 'PROVIS. RENOUV. IMMO (ETS CONCESS)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('157000', 'PROV. CHARG. A REPART. SUR EXERC.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('157200', 'PROVIS. POUR GROSSES REPARATIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('158000', 'AUTRES PROVISIONS POUR CHARGES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('158200', 'PROVIS. CHARG. SOCIA. FISC. SUR CP', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('161000', 'EMPRUNTS OBLIGATOIRES CONVERTIBLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('163000', 'AUTRES EMPRUNTS OBLIGATAIRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('164000', 'EMPRUNTS AUPRES ETABLIS. DE CREDIT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('165000', 'DEPOTS ET CAUTIONNEMENTS RECUS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('165100', 'DEPOTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('165500', 'CAUTIONNEMENTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('166000', 'PARTICIP. SALARIES AUX RESULTAS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('166100', 'COMPTES BLOQUES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('166200', 'FONDS DE PARTICIPATION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('167000', 'EMPR. DETTES ASSORT. CONDIT. PART.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('167100', 'EMISSION DE TITRES PARTICIPATIFS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('167400', 'AVANCES CONDITIONNEES DE L\'ETAT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('167500', 'EMPRUNTS PARTICIPATIFS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168000', 'AUTRES EMPR. ET DETTES ASSIMILEES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168100', 'AUTRES EMPRUNTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168500', 'RENTES VIAGERES CAPITALISEES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168700', 'AUTRES DETTES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168800', 'INTERETS COURUS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168810', 'SUR EMPR. OBLIGATAIR. CONVERTIBLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168830', 'SUR AUTRES EMPRUNTS OBLIGATAIRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168840', 'SUR EMPRUNTS AUPRES ETABLI. CREDIT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168850', 'SUR DEPOTS ET CAUTIONNEMENTS RECUS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168860', 'SUR PARTICIP. SALAR. RESULTATS ETS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168870', 'SUR EMPR. DETTES ASSOR. COND. PART', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168880', 'SUR AUTRES EMPR. DETTES ASSIMILEES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('169000', 'PRIMES REMBOURSEMENT OBLIGATIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('171000', 'DETTES RATTACH. A PARTIC. (GROUPE)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('174000', 'DETTES RATT. A PART. (HORS GROUPE)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('178000', 'DETTES RATTACH. A STES EN PARTIC.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('178100', 'PRINCIPAL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('178800', 'INTERETS COURUS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('181000', 'COMPTE DE LIAISON ETABLISSEMENTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('186000', 'BIENS PREST. SERV. ECH. (CHARGES)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('187000', 'BIENS PREST. SERV. ECH. (PRODUITS)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('188000', 'COMPTES DE LIAISON STES EN PARTIC.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('201100', 'FRAIS DE CONSTITUTION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('201200', 'FRAIS DE PREMIER ETABLISSEMENT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('201210', 'FRAIS DE PROSPECTION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('201220', 'FRAIS DE PUBLICITE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('201300', 'FRAIS AUGMEN. CAPIT. OPER. DIVERS.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('203000', 'FRAIS RECHERCHE ET DEVELOPPEMENT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('205000', 'CONCESSIONS ET DROITS SIMILAIRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('206000', 'DROIT AU BAIL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('207000', 'FONDS COMMERCIAL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('208000', 'AUTRES IMMOBILISATIONS INCORPOR.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211000', 'TERRAINS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211100', 'TERRAINS NUS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211200', 'TERRAINS AMENAGES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211300', 'SOUS-SOLS ET SUR-SOLS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211400', 'TERRAINS DE GISEMENT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211410', 'CARRIERES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211500', 'TERRAINS BATIS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211510', 'ENSEMBLES IMMOBILIERS INDUSTRIELS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211550', 'ENSEMBLES IMMOB. ADM. ET COMMERC.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211580', 'AUTRES ENSEMBLES IMMOBILIERS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211581', 'AFFECTES AUX OPERAT. PROFESSION.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211588', 'AFFECTES AUX OPERAT. NON PROF.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211600', 'COMPTE D\'ORDRE SUR IMMOBILISATIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('212000', 'AGENCEMENTS AMENAGEMENTS TERRAINS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213000', 'CONSTRUCTIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213100', 'BATIMENTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213110', 'ENSEMBLES IMMOB. INDUSTRIELS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213150', 'ENSEMBLES IMMOB. ADM. ET COMMERC.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213180', 'AUTRES ENSEMBLES IMMOBILIERS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213181', 'AFFECTES AUX OPERAT. PROFESSION.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213188', 'AFFECTES AUX OPERAT. NON PROF.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213500', 'INSTALLATIONS GENERALES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213800', 'OUVRAGES D\'INFRASTRUCTURE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213810', 'VOIES DE TERRE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213820', 'VOIES DE FER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213830', 'VOIES D\'EAU', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213840', 'BARRAGES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213850', 'PISTES D\'AERODROMES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('214000', 'CONSTRUCTIONS SUR SOL D\'AUTRUI', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('215000', 'INSTALL. TECH. MAT. OUTIL. INDUS.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('215100', 'INSTALL. COMPLEXES SPECIALISEES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('215110', 'SUR SOL PROPRE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('215140', 'SUR SOL D\'AUTRUI', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('215300', 'INSTALL. A CARACTERE SPECIFIQUE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('215310', 'SUR SOL PROPRE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('215340', 'SUR SOL D\'AUTRUI', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('215400', 'MATERIEL INDUSTRIEL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('215500', 'OUTILLAGE INDUSTRIEL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('215700', 'AGENCEM. AMENAG. MAT. OUTIL. INDUS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('218000', 'AUTRES IMMOBILISATIONS CORPORELLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('218100', 'INSTALL. GENE. AGENC. AMENAG. DIV.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('218200', 'MATERIEL DE TRANSPORT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('218300', 'MATERIEL DE BUREAU ET INFORMATIQUE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('218400', 'MOBILIER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('218500', 'CHEPTEL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('218600', 'EMBALLAGES RECUPERABLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('231000', 'IMMOBILISAT. CORPORELLES EN COURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('231200', 'TERRAINS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('231300', 'CONSTRUCTIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('231500', 'INSTALL. TECH. MAT. OUTIL. INDUST.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('231800', 'AUTRES IMMOBILISATIONS CORPORELLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('232000', 'IMMO. INCORPORELLES EN COURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('237000', 'AVANC. ACOMPT. VERSES SUR IMM. INC', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('238000', 'AVANC. ACOMP. VERSES CDES IMM. COR', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('238200', 'TERRAINS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('238300', 'CONSTRUCTIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('238500', 'INSTALL. TECH. MAT. OUTIL. INDUST.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('238800', 'AUTRES IMMOBILISATIONS CORPORELLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('261000', 'TITRES DE PARTICIPATION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('261100', 'ACTIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('261800', 'AUTRES TITRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('266000', 'AUTRES FORMES DE PARTICIPATION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('267000', 'CREANCES RATTACHEES A PARTICIPAT.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('267100', 'CREANCES RATT. A PART. (GROUPE)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('267400', 'CREANC. RATT. PART. (HORS GROUPE)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('267500', 'VERSEM. D\'APPORTS NON CAPITALISES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('267600', 'AVANCES CONSOLIDABLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('267700', 'AUTRES CREANCES RATT. A PART.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('267800', 'INTERETS COURUS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('268000', 'CREANCES RATT. A STE EN PART.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('268100', 'PRINCIPAL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('268800', 'INTERETS COURUS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('269000', 'VERS. REST. A EFFECT. SUR T.P.N.L.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('271000', 'TITRES IMMOBILISES (DROIT PROP.)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('271100', 'ACTIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('271800', 'AUTRES TITRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('272000', 'TITRES IMMOBILISES (DROIT CREANCE)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('272100', 'OBLIGATIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('272200', 'BONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('273000', 'TITRES IMMOBILISES DE L\'ACT. DE PORTEF.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('274000', 'PRETS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('274100', 'PRETS PARTICIPATIFS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('274200', 'PRETS AUX ASSOCIES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('274300', 'PRETS AU PERSONNEL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('274800', 'AUTRES PRETS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('275000', 'DEPOTS ET CAUTIONNEMENTS VERSES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('275100', 'DEPOTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('275500', 'CAUTIONNEMENTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('276000', 'AUTRES CREANCES IMMOBILISEES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('276100', 'CREANCES DIVERSES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('276800', 'INTERETS COURUS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('276820', 'SUR TITRES IMMOB. (DROIT CREANCE)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('276840', 'SUR PRETS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('276850', 'SUR DEPOTS ET CAUTIONNEMENTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('276880', 'SUR CREANCES DIVERSES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('277100', 'ACTIONS PROPRES OU PARTS PROPRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('277200', 'ACT. PRO. OU PARTS PRO. VOIE D\'ANNUL.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('279000', 'VERSEM. A EFFECT. SUR T.I.N.L.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('280000', 'AMORTISS. IMMOBILISATIONS INCORP.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('280100', 'FRAIS D\'ETABLISSEMENT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('280300', 'FRAIS DE RECHERCHE ET DEVELOPP.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('280500', 'CONCESSIONS ET DROITS SIMILAIRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('280700', 'FONDS COMMERCIAL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('280800', 'AUTRES IMMOBILISATIONS INCORPOR.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('281000', 'AMORTISS. IMMOBILISATIONS CORPOR.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('281100', 'TERRAINS DE GISEMENT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('281200', 'AGENCEMENTS AMENAGEMENTS TERRAINS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('281300', 'CONSTRUCTIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('281400', 'CONSTRUCTIONS SUR SOL D\'AUTRUI', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('281500', 'INSTALL TECH. MAT. OUTIL. INDUST.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('281800', 'AUTRES IMMOBILISATIONS CORPORELLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('282000', 'AMORTISS. IMMOBIL. EN CONCESSION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('290000', 'PROVIS. DEPRECIATION IMMOB. INCORP', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('290500', 'MARQUES PROCEDES DROITS ET VALEURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('290600', 'DROIT AU BAIL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('290700', 'FONDS COMMERCIAL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('290800', 'AUTRES IMMOB. INCORPORELLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('291000', 'PROVIS. DEPRECIATION IMMOB. CORPOR', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('291100', 'TERRAINS (AUTRES QUE GISEMENT)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('292000', 'PROVIS. DEPRECIAT. IMMOB. CONCESS.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('293000', 'PROVIS. DEPRECIAT. IMMOB. EN COURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('293100', 'IMMOBILISATIONS CORPOR. EN COURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('293200', 'IMMO. INCORPORELLES EN COURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('296000', 'PROV. DEPREC. PART ET CREANC. PART', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('296100', 'TITRES DE PARTICIPATION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('296600', 'AUTRES FORMES DE PARTICIPATION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('296700', 'CREANCES RATT. A PARTICIPATION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('296800', 'CREANCES RATT. A STE EN PARTICIP.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('297000', 'PROVIS. DEPRECIATION AUTRES IMMOB.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('297100', 'TITRES IMMOBILISES DROIT PROPRIETE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('297200', 'TITRES IMMOBILISES DROIT CREANCE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('297300', 'TITRES IMMO. DE L\'ACT. DE PORTEF.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('297400', 'PRETS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('297500', 'DEPOTS ET CAUTIONNEMENTS VERSES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('297600', 'AUTRES CREANCES IMMOBILISEES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('311000', 'MATIERE (OU GROUPE) A', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('312000', 'MATIERE (OU GROUPE) B', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('317000', 'FOURNITURES A, B, C...', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('321000', 'MATIERES CONSOMMABLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('321100', 'MATIERE (OU GROUPE) C', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('321200', 'MATIERE (OU GROUPE) D', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('322000', 'FOURNITURES CONSOMMABLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('322100', 'COMBUSTIBLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('322200', 'PRODUITS D\'ENTRETIEN', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('322300', 'FOURNITURES D\'ATELIER ET D\'USINE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('322400', 'FOURNITURES DE MAGASIN', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('322500', 'FOURNITURES DE BUREAU', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('326000', 'EMBALLAGES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('326100', 'EMBALLAGES PERDUS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('326500', 'EMBAL. RECUPER. NON IDENTIFIABLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('326700', 'EMBALLAGES A USAGE MIXTE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('331000', 'PRODUITS EN COURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('331100', 'PRODUITS EN COURS P1', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('331200', 'PRODUITS EN COURS P2', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('335000', 'TRAVAUX EN COURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('335100', 'TRAVAUX EN COURS T1', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('335200', 'TRAVAUX EN COURS T2', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('341000', 'ETUDES EN COURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('341100', 'ETUDE EN COURS E1', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('341200', 'ETUDE EN COURS E2', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('345000', 'PRESTATIONS DE SERVICES EN COURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('345100', 'PRESTATION DE SERVICES S1', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('345200', 'PRESTATION DE SERVICES S2', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('351000', 'PRODUITS INTERMEDIAIRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('351100', 'PRODUIT INTERMEDIAIRE (OU GRPE) A', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('351200', 'PRODUIT INTERMEDIAIRE (OU GRPE) B', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('355000', 'PRODUITS FINIS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('355100', 'PRODUIT FINI (OU GROUPE) A', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('355200', 'PRODUIT FINI (OU GROUPE) B', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('358000', 'PROD. RESIDUELS (OU MAT. RECUP.)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('358100', 'DECHETS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('358500', 'REBUTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('358600', 'MATIERES DE RECUPERATION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('371000', 'MARCHANDISE (OU GROUPE) A', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('372000', 'MARCHANDISE (OU GROUPE) B', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('391000', 'PROVIS. POUR DEPRECIAT. MAT. PREM.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('391100', 'MATIERE (OU GROUPE) A', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('391200', 'MATIERE (OU GROUPE) B', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('391700', 'FOURNITURE A, B, C...', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('392000', 'PROVIS. POUR DEPRECIAT. AUT. APPRO', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('392100', 'MATIERES CONSOMMABLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('392200', 'FOURNITURES CONSOMMABLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('392600', 'EMBALLAGES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('393000', 'PROV. DEPREC. EN-COURS PROD. BIENS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('393100', 'PRODUITS EN COURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('393500', 'TRAVAUX EN COURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('394000', 'PROV. DEPREC. EN-COURS PROD. SERV.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('394100', 'ETUDES EN COURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('394500', 'PRESTATIONS DE SERVICES EN COURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('395000', 'PROV. POUR DEPREC. STOCKS DE PROD.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('395100', 'PRODUITS INTERMEDIAIRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('395500', 'PRODUITS FINIS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('397000', 'PROV. POUR DEPREC. STOCKS MARCHAN.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('397100', 'MARCHANDISE OU GROUPE A', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('397200', 'MARCHANDISE OU GROUPE B', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('401000', 'FOURNISSEURS DIVERS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('403000', 'FOURNISSEURS - EFFETS A PAYER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('404000', 'FOURNISSEURS D\'IMMOBILISATIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('404100', 'FOURNISSEURS ACHATS D\'IMMOBILISAT.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('404700', 'FOURNIS. D\'IMMOB. RETENUES DE GAR.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('405000', 'FOURNIS. D\'IMMOB. EFFETS A PAYER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('408000', 'FOURNIS. FACTURES NON PARVENUES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('408100', 'FOURNISSEURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('408400', 'FOURNISSEURS D\'IMMOBILISATIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('408800', 'FOURNISSEURS INTERETS COURUS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('409000', 'FOURNISSEURS DEBITEURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('409100', 'FOURNIS. AVANC. & ACOMPT. SUR CDES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('409600', 'FOURN. CREAN. EMB. & MAT. A RENDRE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('409700', 'FOURNISSEURS AUTRES AVOIRS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('409710', 'FOURNISSEURS D\'EXPLOITATION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('409740', 'FOURNISSEURS D\'IMMOBILISATIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('409800', 'RABAIS REMISES RISTOUR. A OBTENIR', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('410000', 'CLIENTS ET COMPTES RATTACHES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('411000', 'CLIENTS DIVERS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('413000', 'CLIENTS EFFETS A RECEVOIR', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('416000', 'CLIENTS DOUTEUX OU LITIGIEUX', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('417000', 'CREANC. SUR TRAV. NON ENCORE FACT.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('418000', 'CLIENTS PRODUITS NON ENCORE FACT.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('418100', 'CLIENTS FACTURES A ETABLIR', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('418800', 'CLIENTS INTERETS COURUS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('419000', 'CLIENTS CREDITEURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('419100', 'CLTS AVANC. & ACOMP. RECUS SUR CDE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('419600', 'CLTS DETT. POUR EMB. & MAT. CONSIG', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('419700', 'CLIENTS - AUTRES AVOIRS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('419800', 'RABAIS REMISES RIST. A ACCORDER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('421000', 'PERSONNEL REMUNERATIONS DUES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('422000', 'COMITES D\'ENTREPRISE, D\'ETABLIS.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('424000', 'PARTICIP. DES SALAR. AUX RESULTATS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('424600', 'RESERVE SPECIALE (ART L442.2)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('424800', 'COMPTES COURANTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('425000', 'PERSONNEL AVANCES ET ACOMPTES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('426000', 'PERSONNEL DEPOTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('427000', 'PERSONNEL OPPOSITIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('428000', 'PERS. CHARG. A PAY. & PROD. A REC.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('428200', 'DETTES PROVISIO. POUR CONGES PAYES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('428400', 'DETT. PROV. PART. SAL. AUX RESULT.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('428600', 'AUTRES CHARGES A PAYER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('428700', 'PRODUITS A RECEVOIR', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('438000', 'ORG. SOC. CHARG. A PAY. & PROD.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('438200', 'CHARGES SOCIALES SUR CONGES PAYES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('438700', 'PRODUITS A RECEVOIR', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('441000', 'ETATS SUBVENTIONS A RECEVOIR', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('441100', 'SUBVENTIONS D\'INVESTISSEMENT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('441700', 'SUBVENTIONS D\'EXPLOITATION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('441800', 'SUBVENTIONS D\'EQUILIBRE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('441900', 'AVANCES SUR SUBVENTIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('442000', 'ETAT IMP. & TAX. RECOUV. SUR TIERS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('442400', 'OBLIGATAIRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('442500', 'ASSOCIES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('443000', 'OPERATIONS PART. AVEC L\'ETAT,...', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('443100', 'CREANCES ETAT SUPPR. DECAL. TVA', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('443800', 'INTERES COURUS CREANCES CPTE 443100', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('444000', 'ETAT IMPOTS SUR LES BENEFICES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('444500', 'ETAT TAXES SUR LE CHIFFRE D\'AFF.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445200', 'TVA DUE INTRACOMMUNAUTAIRE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445510', 'TVA A DECAISSER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445580', 'TAXES ASSIMILEES A TVA', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445600', 'TAXES SUR LE CA DEDUCTIBLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445621', 'TVA SUR IMMO. 5.5%', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445622', 'TVA SUR IMMO. 20.6%', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445623', 'TVA SUR IMMO. 19.6%', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445630', 'TVA TRANSFEREE PAR D\'AUTRES ETS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445662', 'TVA DEDUCTIBLE 20.6%', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445670', 'CREDIT DE TVA A REPORTER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445680', 'TAXES ASSIMILEES A LA TVA', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445700', 'TAXE SUR LE C.A. COLLECT. ENTREPR.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445712', 'TVA COLLECTEE 20.6%', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445800', 'TAXES SUR CA A REGULAR. OU EN ATT.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445810', 'ACOMPTES REGIME SIMPLIFIE D\'IMPOS.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445820', 'ACOMPTES REGIME DU FORFAIT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445830', 'REMBOURS. TAXES SUR CA DEMANDE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445840', 'TVA RECUPEREE D\'AVANCE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445861', 'TVA EN ATTENTE DEDUCTIBLE 5.5%', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445862', 'TVA EN ATTENTE DEDUCTIBLE 20.6%', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445863', 'TVA EN ATTENTE DEDUCTIBLE 19.6%', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445871', 'TVA EN ATTENTE COLLECTEE 5.5%', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445872', 'TVA EN ATTENTE COLLECTEE 20.6%', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445873', 'TVA EN ATTENTE COLLECTEE 19.6%', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('446000', 'TITRES SUR TVA', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('446100', 'OBLIGATIONS CAUTIONNEES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('446900', 'CREANCE TVA DECALAGE D\'UN MOIS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('447000', 'AUTRES IMPOTS, TAX. ET VERS. ASSIM', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('448000', 'ETAT CHARG. A PAY. & PROD. A RECEV', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('448200', 'CHARGES FISCALES SUR CONG. A PAYER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('448600', 'AUTRES CHARGES A PAYER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('448700', 'PRODUITS A RECEVOIR', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('451000', 'GROUPE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('455000', 'ASSOCIES COMPTES COURANTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('455100', 'PRINCIPAL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('455780', 'TAXES ASSIMILEES A LA TVA', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('455800', 'INTERETS COURUS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('456000', 'ASSOCIES OPERATIONS SUR LE CAPITAL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('456100', 'ASSOCIES COMPTES D\'APPORT EN STE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('456110', 'APPORTS EN NATURE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('456150', 'APPORTS EN NUMERAIRE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('456200', 'APPORTEURS CAPIT. APPELE NON VERSE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('456210', 'ACTION. CAP. SOUSC. APP. NON VERSE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('456250', 'ASSOCIES CAPITAL APPELE NON VERSE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('456300', 'ASSOC. VERS. RECUS SUR AUGM. CAPIT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('456400', 'ASSOCIES VERSEMENTS ANTICIPES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('456600', 'ACTIONNAIRES DEFAILLANTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('456700', 'ASSOCIES CAPITAL A REMBOURSER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('457000', 'ASSOCIES DIVIDENDES A PAYER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('458000', 'ASSOC. OPERAT. EN COMMUN ET EN GIE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('458100', 'OPERATIONS COURANTES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('458800', 'INTERETS COURUS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('462000', 'CREANCES SUR CESSIONS D\'IMMOBILIS.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('464000', 'DETTES SUR ACQUIS. VALEURS MOBI.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('465000', 'CREANC. SUR CESSIONS VALEURS MOB.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('467000', 'AUTRES COMPTES DEBIT. OU CREDIT.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('467200', 'DEBOURS PAYES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('468000', 'DIVERS CHARG. A PAY. & PROD. A REC', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('468600', 'CHARGES A PAYER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('468700', 'PRODUITS A RECEVOIR', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('471000', 'COMPTES D\'ATTENTE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('471100', 'REIMPUTATION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('476000', 'DIFFERENCES DE CONVERSION ACTIF', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('476100', 'DIMINUTION DES CREANCES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('476200', 'AUGMENTATION DES DETTES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('476800', 'DIFFER. COMPENS. PAR COUV. CHANGE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('477000', 'DIFFERENCES DE CONVERSION PASSIF', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('477100', 'AUGMENTATION DES CREANCES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('477200', 'DIMINUTION DES DETTES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('477800', 'DIFFER. COMPENS. PAR COUV. CHANGE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('478000', 'AUTRES COMPTES TRANSITOIRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('481000', 'CHARG. A REPART. SUR PLUS. EXERC.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('481100', 'CHARGES DIFFEREES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('481200', 'FRAIS D\'ACQUISITION DES IMMOBILIS.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('481600', 'FRAIS D\'EMISSION DES EMPRUNTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('481800', 'CHARGES A ETALER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('486000', 'CHARGES CONSTATEES D\'AVANCE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('487000', 'PRODUITS CONSTATES D\'AVANCE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('488000', 'CPTES REPART. PERIO. CHARG. & PROD', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('488600', 'CHARGES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('488700', 'PRODUITS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('491000', 'PROVIS. POUR DEPREC. CPTES CLIENTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('495000', 'PROV. POUR DEPREC. CPTES GRPE ASS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('495100', 'COMPTES DU GROUPE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('495500', 'COMPTES COURANTS DES ASSOCIES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('495800', 'OPERAT. FAITES EN COMMUN & EN GIE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('496000', 'PROVIS. POUR DEPREC. CPTES DEBIT.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('496200', 'CREANCES SUR CESSIONS D\'IMMOBILIS.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('496500', 'CREANC. SUR CESSIONS VALEURS MOB.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('496700', 'AUTRES COMPTES DEBITEURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('501000', 'PARTS DANS DES ENTREPRISES LIEES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('502000', 'ACTIONS PROPRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('503000', 'ACTIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('503100', 'TITRES COTES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('503500', 'TITRES NON COTES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('504000', 'AUTRES TITRES CONFERANT DROIT PROP', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('505000', 'OBLIG. & BONS EMIS PAR LA SOCIETE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('506000', 'OBLIGATIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('506100', 'TITRES COTES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('506500', 'TITRES NON COTES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('507000', 'BONS TRESOR & BONS CAISSE A CT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('508000', 'AUTRES VALEURS MOB. ET CREANC. ASS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('508100', 'AUTRES VALEURS MOBILIERES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('508200', 'BONS DE SOUSCRIPTION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('508800', 'INTER. COURUS SUR OBLIGATIONS BONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('509000', 'VERS. A EFFECT. SUR VALEURS MOBIL.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('511000', 'VALEURS A L\'ENCAISSEMENT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('511100', 'COUPONS ECHUS A L\'ENCAISSEMENT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('511200', 'CHEQUES A ENCAISSER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('511300', 'EFFETS A L\'ENCAISSEMENT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('511400', 'EFFETS A L\'ESCOMPTE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('512100', 'COMPTES EN MONNAIE NATIONALE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('512400', 'COMPTES EN DEVISES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('514000', 'CHEQUES POSTAUX', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('515000', 'CAISSES DU TRESOR ET ETS PUBLICS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('516000', 'SOCIETE DE BOURSE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('517000', 'AUTRES ORGANISMES FINANCIERS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('518000', 'INTERETS EN COURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('518600', 'INTERETS COURUS A PAYER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('518700', 'INTERETS COURUS A RECEVOIR', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('519000', 'CONCOURS BANCAIRES COURANTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('519100', 'CREDIT MOBIL. CREANC. CCIALES CMCC', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('519300', 'MOBIL. CREANCES NEES A L\'ETRANGER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('519800', 'INT. COURUS SUR CONCOURS BANCAIRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('520000', 'INSTRUMENTS DE TRESORERIE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('531000', 'CAISSE SIEGE SOCIAL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('531100', 'CAISSE EN MONNAIE NATIONALE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('531400', 'CAISSE EN DEVISES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('532000', 'CAISSE SUCCURSALE (OU USINE) A', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('533000', 'CAISSE SUCCURSALE (OU USINE) B', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('580100', 'VIREMENT DE TRESORERIE A TRESORERIE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('590000', 'PROVIS. POUR DEPREC. VALEURS MOB.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('590300', 'ACTIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('590400', 'AUTRES TIT. CONFERANT DROIT PROP.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('590600', 'OBLIGATIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('590800', 'AUTRES VALEURS MOB. & CREANC. ASS.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('601100', 'MATIERE (OU GROUPE) A', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('601200', 'MATIERE (OU GROUPE) B', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('601700', 'FOURNITURES A, B, C...', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602000', 'ACHATS STOCKES AUTRES APPROV.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602100', 'MATIERES CONSOMMABLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602110', 'MATIERE (OU GROUPE) C', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602120', 'MATIERE (OU GROUPE) D', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602200', 'FOURNITURES CONSOMMABLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602210', 'COMBUSTIBLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602220', 'PRODUITS D\'ENTRETIEN', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602230', 'FOURNITURES D\'ATELIER / USINES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602240', 'FOURNITURES DE MAGASINS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602250', 'FOURNITURES DE BUREAU', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602600', 'EMBALLAGES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602610', 'EMBALLAGES PERDUS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602650', 'EMBALL. RECUPERA. NON IDENTIF.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602670', 'EMBALLAGES A USAGE MIXTE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('603000', 'VARIATION DES STOCKS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('603100', 'VARIAT. STOCKS MAT. PREM. ET FOURN', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('603200', 'VARIAT. STOCKS AUTRES APPROVISION.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('603700', 'VARIATION STOCKS DE MARCHANDISES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('604000', 'ACHATS ETUDES ET PRESTAT. SERVICES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('605000', 'ACHATS MATERIEL EQUIPEM. TRAVAUX', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('606000', 'ACHATS NON STOCKES DE MAT. PREM.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('606400', 'FOURNITURES ADMINISTRATIVES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('606500', 'ACHATS SPECIAUX', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('606800', 'AUTRES MATIERES ET FOURNITURES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('607100', 'MARCHANDISE (OU GROUPE) A', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('607200', 'MARCHANDISE (OU GROUPE) B', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('608000', 'FRAIS ACCESSOIRES D\'ACHAT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('609000', 'RABAIS REMISES RIST. SUR ACHATS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('609100', 'DE MATIERES PREMIERES (ET FOURN.)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('609200', 'D\'AUTRES APPROVISIONN. STOCKES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('609500', 'DE MATERIEL EQUIPEMENTS DE TRAVAUX', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('609600', 'D\'APPROVISIONNEMENTS NON STOCKES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('609700', 'DE MARCHANDISES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('609800', 'RABAIS REMISES RIST. NON AFFECTES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('612000', 'REDEVANCES DE CREDIT-BAIL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('612200', 'CREDIT-BAIL MOBILIER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('612500', 'CREDIT-BAIL IMMOBILIER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('613000', 'LOCATIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('613600', 'MALIS SUR EMBALLAGES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('614000', 'CHARGES LOCATIVES & DE COPROPRIETE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('615200', 'SUR BIENS IMMOBILIERS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('615500', 'SUR BIENS MOBILIERS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('615600', 'MAINTENANCE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('616100', 'MULTIRISQUES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('616200', 'ASSUR. OBLIGAT. DOMMAGE-CONSTRUCT.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('616300', 'ASSURANCE-TRANSPORT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('616360', 'SUR ACHATS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('616370', 'SUR VENTES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('616380', 'SUR AUTRES BIENS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('616400', 'RISQUES D\'EXPLOITATION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('616500', 'INSOLVABILITE CLIENTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('618000', 'DIVERS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('618100', 'DOCUMENTATION GENERALE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('618500', 'FRAIS DE COLLOQUES, SEMIN., CONFER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('619000', 'RABAIS REMISES RIST. SUR SERV. EXT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('621000', 'PERSONNEL EXTERIEUR A L\'ENTREPRISE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('621400', 'PERSONNEL DETACHE OU PRETE A L\'ETS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('622000', 'REMUNERAT. D\'INTERM. ET HONORAIRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('622100', 'COMMISSIONS & COURTAGES SUR ACHATS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('622200', 'COMMISSIONS & COURTAGES SUR VENTES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('622400', 'REMUNERATIONS DES TRANSITAIRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('622500', 'REMUNERATIONS D\'AFFACTURAGE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('622800', 'DIVERS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('623000', 'PUBLICITE PUBLICAT. RELAT. PUBLIQ.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('623100', 'ANNONCES ET INSERTIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('623200', 'ECHANTILLONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('623300', 'FOIRES ET EXPOSITIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('623500', 'PRIMES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('623600', 'CATALOGUES ET IMPRIMES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('623700', 'PUBLICATIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('623800', 'DIVERS (POURBOIRES, DONS COURANTS)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('624000', 'TRANSP. BIENS & TRANSP. COLL. PERS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('624100', 'TRANSPORTS SUR ACHATS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('624200', 'TRANSPORTS SUR VENTES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('624300', 'TRANSPORTS ENTRE ETS OU CHANTIERS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('624400', 'TRANSPORTS ADMINISTRATIFS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('624700', 'TRANSPORTS COLLECTIFS DU PERSONNEL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('624800', 'DIVERS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('625000', 'DEPLACEM. MISSIONS ET RECEPTIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('625500', 'FRAIS DE DEMENAGEMENT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('625700', 'RECEPTIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('627000', 'SERVICES BANCAIRES ET ASSIMILES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('627100', 'FRAIS SUR TITRES (ACHAT, VENTE,.).', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('627200', 'COMMISSIONS & FRAIS SUR EMPRUNTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('627500', 'FRAIS SUR EFFETS (COMM. D\'ENDOS,.)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('627600', 'LOCATION DE COFFRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('627800', 'AUTRES FRAIS & COMM. PREST. SERV.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('628000', 'DIVERS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('628400', 'FRAIS DE RECRUTEMENT DU PERSONNEL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('629000', 'RABAIS REMISES RIST. SUR SERV. EXT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('631000', 'IMPOTS TAXES & VERS. SUR REMUNER.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('631100', 'TAXE SUR LES SALAIRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('631200', 'TAXE D\'APPRENTISSAGE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('631300', 'PART. EMPLOY. A FORM. PROF. CONT.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('631400', 'COTIS. DEFAUT INVEST. DANS CONST.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('631800', 'AUTRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('633000', 'IMPOTS TAXES & VERS. SUR REMUNER.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('633100', 'VERSEMENT SUR LE TRANSPORT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('633200', 'ALLOCATION LOGEMENT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('633300', 'PART. EMPLOY. A FORM. PROF. CONT.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('633400', 'PART. EMPLOY. A EFFORT CONSTRUCT.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('633500', 'VERS. LIBERAT. A EXONER. TAXE APP.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('635000', 'AUTRES IMPOTS TAXES & VERS. ASS.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('635100', 'IMPOTS DIRECTS (SAUF IMPOT BENEF.)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('635120', 'TAXES FONCIERES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('635130', 'AUTRES IMPOTS LOCAUX', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('635140', 'TAXE SUR LES VEHICULES SOCIETES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('635200', 'TAXES SUR CA NON RECUPERABLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('635300', 'IMPOTS INDIRECTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('635400', 'DROITS D\'ENREGISTREMENT ET TIMBRE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('635410', 'DROIT DE MUTATION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('635800', 'AUTRES DROITS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('637000', 'AUTRES IMPOTS TAXES ET VERS. ASS.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('637100', 'CONTRIB. SOC. SOLID. A CHARGE STES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('637200', 'TAXES PERCUES PAR ORG. PUBLICS INT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('637400', 'IMPOTS & TAXES EXIGIB. A L\'ETRANG.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('637800', 'TAXES DIVERSES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('641100', 'SALAIRES APPOINT. COMMIS. DE BASE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('641200', 'CONGES PAYES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('641300', 'PRIMES ET GRATIFICATIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('641400', 'SALAIRES, APPOINTEMENTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('641500', 'SUPPLEMENT FAMILIAL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('644000', 'REMUNERATION TRAVAIL DE L\'EXPLOIT.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('647000', 'AUTRES CHARGES SOCIALES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('647100', 'PRESTATIONS DIRECTES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('647200', 'VERS. AUX COMITES D\'ETS & D\'ETAB.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('647300', 'VERS. AUX COMITES HYGIENE ET SECUR', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('647400', 'VERSEMENTS AUX OEUVRES SOCIALES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('647500', 'MEDECINE DU TRAVAIL, PHARMACIE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('648000', 'AUTRES CHARGES DE PERSONNEL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('651000', 'REDEVANC. CONCESS. BREV. LICENC,..', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('651100', 'REDEV. CONCESS. BREV, LIC, MARQ,..', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('651600', 'DROITS D\'AUTEUR ET DE REPRODUCT.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('651800', 'AUTRES DROITS & VALEURS SIMILAIRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('653000', 'JETONS DE PRESENCE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('654000', 'PERTES SUR CREANCES IRRECOUVRAB.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('654100', 'CREANCES DE L\'EXERCICE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('654400', 'CREANCES DES EXERCICES ANTERIEURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('655000', 'QUOTE-PARTS RESULT. OPER. EN COMM.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('655100', 'Q-P BENEF. TRANSF. (CPTA GERANT)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('655500', 'QUOTE-PART PERTE SUPP. (CPTA ASS)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('658000', 'CHARGES DIVERSES GESTION COURANTE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('661000', 'CHARGES D\'INTERETS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('661100', 'INTERETS DES EMPRUNTS ET DETTES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('661160', 'DES EMPRUNTS ET DETTES ASSIMILEES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('661170', 'DES DETTES RATT. A PARTICIPATIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('661500', 'INTERETS CPTES COUR. & DEP. CREDIT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('661600', 'INTERETS BANC. & SUR OPER. FINANC.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('661700', 'INTERETS OBLIGATIONS CAUTIONNEES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('661800', 'INTERETS DES AUTRES DETTES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('661810', 'DES DETTES COMMERCIALES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('661880', 'DES DETTES DIVERSES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('664000', 'PERTES CREANCES LIEES A PARTICIP.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('665000', 'ESCOMPTES ACCORDES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('667000', 'CHARG. NETTES SUR CESS. VAL. MOBIL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('668000', 'AUTRES CHARGES FINANCIERES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('668800', 'ECART DE CONVERSION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('671000', 'CHARG. EXCEPT. SUR OPERAT. GESTION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('671100', 'PENALITES SUR MARCHES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('671200', 'PENALITES AMENDES FISC. & PENALES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('671300', 'DONS, LIBERALITES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('671400', 'CREANC. DEVEN. IRRECOUV. SUR BENEF', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('671500', 'SUBVENTIONS ACCORDEES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('671700', 'RAPPEL D\'IMPOTS (AUTRE QUE BENEF)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('671800', 'AUT. CHARG. EXCEP. SUR OPER. GEST.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('672000', 'CHARGES SUR EXERCICES ANTERIEURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('675000', 'VAL. COMPT. DES ELEM. ACTIF CEDES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('675100', 'IMMOBILISATIONS INCORPORELLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('675200', 'IMMOBILISATIONS CORPORELLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('675600', 'IMMOBILISATIONS FINANCIERES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('675800', 'AUTRES ELEMENTS D\'ACTIF', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('678000', 'AUTRES CHARGES EXCEPTIONNELLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('678100', 'MALIS PROVENANT DE CLAUSES INDEXAT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('678200', 'LOTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('678300', 'MALIS DU RACHAT PAR ETS D\'ACTIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('678800', 'CHARGES EXCEPTIONNELLES DIVERSES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681100', 'DOTAT. AUX AMORT. DES IMMOB. CORPO', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681110', 'IMMOBILISATIONS INCORPORELLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681120', 'IMMOBILISATIONS CORPORELLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681200', 'DOTAT. AUX AMORT. CHARG. EXPLOIT.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681500', 'DOTAT. AUX PROV. RISQ. & CHARG. EX', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681600', 'DOTAT. AUX PROV. DEPREC. IMMOB.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681610', 'IMMOBILISATIONS INCORPORELLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681620', 'IMMOBILISATIONS CORPORELLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681700', 'DOTAT. AUX PROV. DEPREC. ACTIFS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681740', 'CREANCES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('686000', 'DOTAT. AUX AMORT. ET AUX PROVIS.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('686100', 'DOT. AUX AMORT. PRIME REMB. OBLIG.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('686500', 'DOT. AUX PROV. RISQ. & CHARG. FIN.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('686600', 'DOT. AUX PROV. DEPREC. ELEM. FINAN', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('686620', 'IMMOBILISATIONS FINANCIERES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('686650', 'VALEURS MOBILIERES DE PLACEMENT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('686800', 'AUTRES DOTATIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('687000', 'DOTAT. AUX AMORT. ET PROVISIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('687100', 'DOTAT. AUX AMORT. EXCEPT. IMMOB.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('687200', 'DOTAT. AUX PROV. REGLEM. (IMMOB)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('687250', 'AMORTISSEMENTS DEROGATOIRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('687300', 'DOTAT. AUX PROV. REGLEM. (STOCKS)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('687400', 'DOTAT. AUX AUTRES PROV. REGLEMENT.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('687500', 'DOTAT. PROV. RISQ. & CHARG. EXCEP.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('691000', 'PARTICIPATIONS DES SALARIES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('695200', 'CONTRIB. ADDITIO. IMPOT BENEFICES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('695400', 'IMPOTS DUS A L\'ETRANGER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('696000', 'SUPPLEMENT D\'IMPOTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('697000', 'IMPOSITION FORF. ANUELLE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('698000', 'INTEGRATION FISCALE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('698100', 'INTEGRATION FISCALE - CHARGES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('698900', 'INTEGRATION FISCALE - PRODUITS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('699000', 'PRODUITS REP. EN ARR. DES DEFICITS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('701000', 'VENTES DE PRODUITS FINIS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('701100', 'PRODUIT FINI (OU GROUPE) A', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('701200', 'PRODUIT FINI (OU GROUPE) B', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('702000', 'VENTES DE PRODUITS INTERMEDIAIRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('703000', 'VENTES DE PRODUITS RESIDUELS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('704000', 'TRAVAUX', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('704100', 'TRAVAUX DE CATEG. (OU ACTIV.) A', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('704200', 'TRAVAUX DE CATEG. (OU ACTIV.) B', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('705000', 'ETUDES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('707100', 'MARCHANDISE (OU GROUPE) A', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('707200', 'MARCHANDISE (OU GROUPE) B', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('708000', 'PRODUITS DES ACTIVITES ANNEXES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('708100', 'PROD. SERV. EXPLOIT. INTER. PERSON', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('708200', 'COMMISSIONS ET COURTAGES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('708300', 'LOCATIONS DIVERSES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('708400', 'MISE A DISPOS. PERSONNEL FACTUREE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('708500', 'PORTS ET FRAIS ACCESSOIRES FACT.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('708600', 'BONIS SUR REPRISES EMBALL. CONSIG.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('708700', 'BONIFICAT. CLTS & PRIMES VENTES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('708800', 'AUTRES PRODUITS ACTIVITES ANNEXES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('709000', 'RABAIS REMISES RIST. ACCORD. A ETS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('709100', 'SUR VENTES DE PRODUITS FINIS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('709200', 'SUR VENTES PRODUITS INTERMEDIAIRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('709400', 'SUR TRAVAUX', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('709500', 'SUR ETUDES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('709600', 'SUR PRESTATIONS DE SERVICES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('709700', 'SUR VENTES MARCHANDISES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('709800', 'SUR PRODUITS ACTIVITES ANNEXES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('713000', 'VARIAT. STOCKS (EN-COURS PRODUCT.)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('713300', 'VARIATION EN-COURS PRODUC. BIENS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('713310', 'PRODUITS EN COURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('713350', 'TRAVAUX EN COURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('713400', 'VARIATION EN-COURS PROD. SERVICES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('713410', 'ETUDES EN COURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('713450', 'PRESTATIONS SERVICES EN COURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('713500', 'VARIATION STOCKS DE PRODUITS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('713510', 'PRODUITS INTERMEDIAIRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('713550', 'PRODUITS FINIS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('713580', 'PRODUITS RESIDUELS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('721000', 'IMMOBILISATIONS INCORPORELLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('722000', 'IMMOBILISATIONS CORPORELLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('731000', 'PROD. NETS PART. SUR OP. EN COURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('739000', 'PROD. NETS PART. SUR OP. TERMINEES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('751000', 'REDEV. POUR CONCES. BREV. LIC....', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('751100', 'REDEV. POUR CONCES. BREV. LIC...', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('751600', 'DROITS D\'AUTEUR ET DE REPRODUCTION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('751800', 'AUTRES DROITS & VALEURS SIMILAIRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('752000', 'REV. IMMEUB. NON AFFECT. ACT. PROF', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('753000', 'JETONS PRESENCE ET REMUN. ADMINIST', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('754000', 'RISTOURNES PERCUES COOPERATIVES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('755000', 'QUOTES-PARTS RESULT. OP. EN COMMUN', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('755100', 'QUOTE-PART PERTE TRANSFEREE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('755500', 'QUOTE-PART BENEFICE ATTRIBUEE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('758000', 'PRODUITS DIVERS GESTION COURANTE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('761000', 'PRODUITS DE PARTICIPATIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('761100', 'REVENUS TITRES DE PARTICIPATION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('761600', 'REVENUS AUTRES FORMES PARTICIP.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('762000', 'PRODUITS AUTRES IMMOB. FINANC.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('762100', 'REVENUS DES TITRES IMMOBILISES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('762400', 'REVENUS DES PRETS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('762700', 'REVENUS CREANCES IMMOBILISEES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('763000', 'REVENUS DES AUTRES CREANCES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('763100', 'REVENUS CREANCES COMMERCIALES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('763800', 'REVENUS DES CREANCES DIVERSES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('764000', 'REVENUS VALEURS MOBIL. PLACEMENT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('765000', 'ESCOMPTES OBTENUS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('767000', 'PROD. NETS SUR CESS. VALEURS MOB.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('767100', 'REVENUS CRE. RATT. PARTICIPATIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('768000', 'AUTRES PRODUITS FINANCIERS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('771000', 'PRODUITS EXCEPT. SUR OPER. GESTION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('771100', 'DEDITS PENAL. SUR ACHATS & VENTES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('771300', 'LIBERALITES PERCUES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('771400', 'RENTREES SUR CREANCES AMORTIES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('771500', 'SUBVENTIONS D\'EQUILIBRE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('771700', 'DEGREVEM. IMPOTS (AUT. IMP. BENEF)', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('771800', 'AUTRES PROD. EXCEPT. SUR OP. GEST.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('772000', 'PRODUITS SUR EXERCICES ANTERIEURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('775000', 'PRODUITS CESSIONS ELEMENTS D\'ACTIF', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('775100', 'IMMOBILISATIONS INCORPORELLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('775200', 'IMMOBILISATIONS CORPORELLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('775600', 'IMMOBILISATIONS FINANCIERES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('775800', 'AUTRES ELEMENTS D\'ACTIF', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('777000', 'Q-P SUBV. INVEST. AU RESULT. EXERC', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('778000', 'AUTRES PRODUITS EXCEPTIONNELS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('778100', 'BONIS PROVENANT CLAUSES D\'INDEXAT.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('778200', 'LOTS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('778300', 'BONIS RACHAT PAR ETS ACT. & OBLIG.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('778800', 'PRODUITS EXCEPTIONNELS DIVERS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('781000', 'REPRISES SUR AMORTISS. & PROVIS.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('781100', 'REPRIS. AMORT. IMMOB. CORP. & INC', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('781110', 'IMMOBILISATIONS INCORPORELLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('781120', 'IMMOBILISATIONS CORPORELLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('781500', 'REPRIS. PROVIS. RISQ. & CH. EXPLOI', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('781600', 'REP. PROV. DEPREC. IMM. CORP & INC', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('781610', 'IMMOBILISATIONS INCORPORELLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('781620', 'IMMOBILISATIONS CORPORELLES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('781700', 'REPRIS. PROV. DEPREC. ACT. CIRCUL.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('781730', 'STOCKS ET EN-COURS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('781740', 'CREANCES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('786000', 'REPRISES SUR PROVIS. POUR RISQUES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('786500', 'REP. PROV. RISQ. & CHARG. FINANC.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('786600', 'REPRIS. PROV. DEPREC. ELEM. FINANC', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('786620', 'IMMOBILISATIONS FINANCIERES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('786650', 'VALEURS MOBILIERES DE PLACEMENT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('787000', 'REPRISES SUR PROVISIONS', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('787200', 'REPRISES SUR PROV. REGLEMENTEES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('787250', 'AMORTISSEMENTS DEROGATOIRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('787260', 'PROVISION SPECIALE DE REEVALUATION', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('787270', 'PLUS-VALUES REINVESTIES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('787300', 'REPRISES SUR PROV. REGLEMENTEES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('787400', 'REPRIS. SUR AUTRES PROV. REGLEMENT', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('787500', 'REPRIS. PROV. RISQ. & CHARG. EXPL.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('787600', 'REPRIS. PROV. POUR DEPREC. EXCEPT.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('791000', 'TRANSFERTS DE CHARGES D\'EXPLOIT.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('796000', 'TRANSFERTS DE CHARGES FINANC.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('797000', 'TRANSFERTS DE CHARGES EXCEPT.', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('201000', 'FRAIS D\'ETABLISSEMENT', 'A', '', 'E', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('209000', 'SORTIE D\'IMMOBILISATION', 'A', '', 'I', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('474100', 'DIVERS A REINTEGRER', 'A', '', 'I', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('474200', 'BENEFICE SCM', 'A', '', 'I', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('475000', 'PLUS VALUES A COURT TERME', 'A', '', 'I', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('530000', 'CAISSE', 'A', '', 'I', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('760000', 'PRODUITS FINANCIERS', 'A', '', 'I', 'AR_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('770000', 'PRODUITS EXCEPTIONNELS', 'A', '', 'I', 'AR_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('530010', 'CAISSE', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('607000', 'ACHATS DE MARCHANDISES', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('622700', 'FRAIS D\'ACTES ET DE CONTENTIEUX', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('438600', 'AUTRES CHARGES A PAYER', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('473000', 'DIVERS A DEDUIRE', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('613200', 'LOCATIONS IMMOBILIERES', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('616000', 'PRIMES D\'ASSURANCE', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('633800', 'AUTRES', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('695000', 'IMPOTS SUR LES BENEFICES', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('108100', 'COMPTE DE LEXPLOITANT', 'A', '', 'E', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('512030', 'EPARGNE', 'A', '', 'A', 'AR_paid:AP_paid'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('100000', 'CLASSE 1', 'H', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('300000', 'CLASSE 3', 'H', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('500000', 'CLASSE 5', 'H', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('600000', 'CLASSE 6', 'H', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('700000', 'CLASSE 7', 'H', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('108000', 'COMPTE DE LEXPLOITANT', 'A', '', 'I', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('200001', 'IMMOBILISATION', 'A', '', 'E', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('200000', 'CLASSE 2', 'H', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('400001', 'FOURNISSEURS ET COMPTES RATTACHES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('400000', 'CLASSE 4', 'H', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('695100', 'IMPOTS DUS EN FRANCE', 'A', '', 'E', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('646000', 'COTIS. SOCIAL. PERSON. EXPLOITANT', 'A', '', 'E', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('645000', 'CHARGES DE SECUR. SOC. ET PREVOY.', 'A', '', 'E', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('617000', 'ETUDES ET RECHERCHES', 'A', '', 'E', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('615000', 'ENTRETIEN ET REPARATIONS', 'A', '', 'E', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('613500', 'LOCATIONS MOBILIERES', 'A', '', 'E', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('611000', 'SOUS-TRAITANCE GENERALE', 'A', '', 'E', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('695500', 'DEBOURS PAYES POUR LE COMPTE', 'A', '', 'E', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('690000', 'PARTICIP. SAL. / IMPOTS SUR BEN.', 'A', '', 'E', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('687600', 'DOTAT. AUX PROV. DEPREC. EXCEPT.', 'A', '', 'E', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681000', 'DOTATIONS AUX AMORT. & AUX PROVIS.', 'A', '', 'E', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('628100', 'CONCOURS DIVERS (COTISATIONS,...)', 'A', '', 'E', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('625600', 'MISSIONS', 'A', '', 'E', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('645800', 'COTISATIONS AUX AUTRES ORG. SOC.', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('641000', 'REMUNERATIONS DU PERSONNEL', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('625020', 'DEPLACEMENTS MOTO', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('622600', 'HONORAIRES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('621100', 'PERSONNEL INTERIMAIRE', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445500', 'TAXES SUR CA A DECAISSER', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('706000', 'PRESTATIONS DE SERVICES', 'A', '', 'I', 'IC_income'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('707000', 'VENTES DE MARCHANDISES', 'A', '', 'I', 'IC_sale'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445713', 'TVA COLLECTEE 19.6%', 'A', '', 'I', 'AR_tax:IC_taxpart:IC_taxservice'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('512020', 'BANQUE DEBIT', 'A', '', 'E', 'AP'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445711', 'TVA COLLECTEE 5.5%', 'A', '', 'I', 'AR_tax:IC_taxpart:IC_taxservice'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445661', 'TVA DEDUCTIBLE 5.5%', 'A', '', 'E', 'AP_tax:IC_taxpart:IC_taxservice'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('512010', 'BANQUE CREDIT', 'A', '', 'I', 'AR:AR_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681730', 'STOCKS ET EN-COURS', 'A', '', 'A', 'IC'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('580010', 'VIREMENT INTERNE', 'A', '', 'E', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('580000', 'VIREMENT INTERNE', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('766000', 'GAINS DE CHANGE', 'A', '', 'I', 'AR_amount:IC_income'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('472000', 'MOINS VALUES A COURT TERME', 'A', '', 'E', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('474000', 'DEFICIT SCM', 'A', '', 'E', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('670000', 'CHARGES FINANCIERES', 'A', '', 'E', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('645100', 'COTISATIONS A L\'URSSAF', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('645200', 'COTISATIONS AUX MUTUELES', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('645300', 'COTISATIONS AUX CAISSES RETR.', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('646400', 'COTISATIONS AUX ASSEDIC', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('623400', 'CADEAUX A LA CLIENTELE', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('437000', 'AUTRES ORGANISMES SOCIAUX', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('606100', 'FOURNITURES NON STOCK. EAU ENERG.', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('606300', 'FOURNIT. ENTRETIEN & PETIT EQUIP.', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('625010', 'DEPLACEMENTS AUTO', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('635110', 'TAXE PROFESSIONNELLE', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('645001', 'CSG', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('660000', 'CHARGES FINANCIERES', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('666000', 'PERTES DE CHANGE', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('512040', 'EXPLOITANT', 'A', '', 'E', 'AP_paid'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('431000', 'SECURITE SOCIALE', 'A', '', 'E', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('609400', 'D\'ETUDES & PRESTATIONS DE SERVICES', 'A', '', '', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('625100', 'VOYAGES ET DEPLACEMENTS', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('618300', 'DOCUMENTATION TECHNIQUE', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445663', 'TVA DEDUCTIBLE 19.6%', 'A', '', 'E', 'AP_tax:IC_taxpart:IC_taxservice'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('601000', 'ACHATS STOCKES MAT. PREM. (FOURN.)', 'A', '', 'E', 'AP_amount:IC_cogs'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('626000', 'FRAIS POSTAUX ET TELECOMMUNIC.', 'A', '', 'E', 'AP_amount'); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('512000', 'BANQUE', 'A', '', 'A', 'AR_paid:AP_paid'); +-- +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('999000', 'Foreign Exchange Gain', 'A', '', 'I', ''); +INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('999010', 'Foreign Exchange Loss', 'A', '', 'E', ''); +-- +-- insert taxes +-- +INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '445661'), 0.055); +INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '445663'), 0.196); +INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '445711'), 0.055); +INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '445713'), 0.196); +-- +-- update defaults +-- +INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '681730')); + + INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '707000')); + + INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '601000')); + + INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '999000')); + + INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '999010')); + + INSERT INTO defaults (setting_key, value) VALUES ('curr', 'EUR'); + + INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg'); +-- +commit; |