summaryrefslogtreecommitdiff
path: root/sql/France-chart.sql
blob: 4529a57ae080e0402aea528d3444684b3b8a6104 (plain) 
    

  1. begin;
    2. 

  2. -- Chart of Accounts for France
    3. 

  3. -- From: Oscar Buijten <oscar@elbie.com>
    4. 

  4. -- Mon, 6 Aug 2001
    5. 

  5. --
    6. 

  6. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('101000', 'CAPITAL', 'A', '', '', '');
    7. 

  7. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('101100', 'CAPITAL SOUSCRIT NON APPELE', 'A', '', '', '');
    8. 

  8. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('101200', 'CAPITAL SOUSCRIT APPELE NON VERSE', 'A', '', '', '');
    9. 

  9. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('101300', 'CAPITAL SOUSCRIT APPELE VERSE', 'A', '', '', '');
    10. 

  10. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('101310', 'CAPITAL NON AMORTI', 'A', '', '', '');
    11. 

  11. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('101320', 'CAPITAL AMORTI', 'A', '', '', '');
    12. 

  12. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('101800', 'CAPITAL SOUSCR. A REGLEM. PART.', 'A', '', '', '');
    13. 

  13. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('104000', 'PRIMES LIEES AU CAPITAL SOCIAL', 'A', '', '', '');
    14. 

  14. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('104100', 'PRIMES D\'EMISSION', 'A', '', '', '');
    15. 

  15. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('104200', 'PRIMES DE FUSION', 'A', '', '', '');
    16. 

  16. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('104300', 'PRIMES D\'APPORT', 'A', '', '', '');
    17. 

  17. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('104400', 'PRIMES CONVERS. OBLIGAT. ACTIONS', 'A', '', '', '');
    18. 

  18. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('104500', 'BONS DE SOUSCRIPTION D\'ACTION', 'A', '', '', '');
    19. 

  19. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('105000', 'ECARTS DE REEVALUATION', 'A', '', '', '');
    20. 

  20. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('105100', 'RESERVE SPECIALE DE REEVALUATION', 'A', '', '', '');
    21. 

  21. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('105200', 'ECART DE REEVALUATION LIBRE', 'A', '', '', '');
    22. 

  22. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('105300', 'RESERVE DE REEVALUATION', 'A', '', '', '');
    23. 

  23. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('105500', 'ECARTS REEVAL. (AUT. OPER. LEG.)', 'A', '', '', '');
    24. 

  24. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('105700', 'AUT. ECARTS REEVAL. EN FRANCE', 'A', '', '', '');
    25. 

  25. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('105800', 'AUT. ECARTS REEVAL. A L\'ETRANGER', 'A', '', '', '');
    26. 

  26. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106000', 'RESERVES', 'A', '', '', '');
    27. 

  27. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106100', 'RESERVE LEGALE', 'A', '', '', '');
    28. 

  28. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106110', 'RESERVE LEGALE PROPREMENT DITE', 'A', '', '', '');
    29. 

  29. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106120', 'PLUS-VALUES NETTES A LONG TERME', 'A', '', '', '');
    30. 

  30. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106200', 'RESERVES INDISPONIBLES', 'A', '', '', '');
    31. 

  31. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106300', 'RESERVES STATUT. OU CONTRACTUELLES', 'A', '', '', '');
    32. 

  32. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106400', 'RESERVES REGLEMENTEES', 'A', '', '', '');
    33. 

  33. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106410', 'PLUS-VALUES NETTES A LONG TERME', 'A', '', '', '');
    34. 

  34. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106430', 'RESER. CONSEC. OCTROI SUBV. INVEST', 'A', '', '', '');
    35. 

  35. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106480', 'AUTRES RESERVES REGLEMENTEES', 'A', '', '', '');
    36. 

  36. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106800', 'AUTRES RESERVES', 'A', '', '', '');
    37. 

  37. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106810', 'RESERVE DE PROPRE ASSUREUR', 'A', '', '', '');
    38. 

  38. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('106880', 'RESERVES DIVERSES', 'A', '', '', '');
    39. 

  39. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('107000', 'ECART D\'EQUIVALENCE', 'A', '', '', '');
    40. 

  40. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('109000', 'ACTIONN. CAPITAL SOUSC. NON APPELE', 'A', '', '', '');
    41. 

  41. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('110000', 'REPORT A NOUVEAU (SOLDE CREDITEUR)', 'A', '', '', '');
    42. 

  42. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('119000', 'REPORT A NOUVEAU (SOLDE DEBITEUR)', 'A', '', '', '');
    43. 

  43. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('120000', 'RESULTAT DE L\'EXERCICE (BENEFICE)', 'A', '', '', '');
    44. 

  44. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('129000', 'RESULTAT DE L\'EXERCICE (PERTE)', 'A', '', '', '');
    45. 

  45. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('131000', 'SUBVENTIONS D\'EQUIPEMENT', 'A', '', '', '');
    46. 

  46. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('131100', 'ETAT', 'A', '', '', '');
    47. 

  47. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('131200', 'REGIONS', 'A', '', '', '');
    48. 

  48. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('131300', 'DEPARTEMENTS', 'A', '', '', '');
    49. 

  49. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('131400', 'COMMUNES', 'A', '', '', '');
    50. 

  50. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('131500', 'COLLECTIVITES PUBLIQUES', 'A', '', '', '');
    51. 

  51. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('131600', 'ENTREPRISES PUBLIQUES', 'A', '', '', '');
    52. 

  52. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('131700', 'ENTREPRISES ET ORGANISMES PRIVES', 'A', '', '', '');
    53. 

  53. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('131800', 'AUTRES', 'A', '', '', '');
    54. 

  54. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('138000', 'AUTRES SUBVENTIONS D\'INVESTIS.', 'A', '', '', '');
    55. 

  55. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('139000', 'SUBV. INVES. INSC. AU CPTE RESULT.', 'A', '', '', '');
    56. 

  56. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('139100', 'SUBVENTIONS D\'EQUIPEMENT', 'A', '', '', '');
    57. 

  57. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('139110', 'ETAT', 'A', '', '', '');
    58. 

  58. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('139120', 'REGIONS', 'A', '', '', '');
    59. 

  59. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('139130', 'DEPARTEMENTS', 'A', '', '', '');
    60. 

  60. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('139140', 'COMMUNES', 'A', '', '', '');
    61. 

  61. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('139150', 'COLLECTIVITES PUBLIQUES', 'A', '', '', '');
    62. 

  62. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('139160', 'ENTREPRISES PUBLIQUES', 'A', '', '', '');
    63. 

  63. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('139170', 'ENTREPRISES ET ORGANISMES PRIVES', 'A', '', '', '');
    64. 

  64. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('139180', 'AUTRES', 'A', '', '', '');
    65. 

  65. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('139800', 'AUTRES SUBVENTIONS D\'INVESTIS.', 'A', '', '', '');
    66. 

  66. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('142000', 'PROVIS. REGLEM. RELATIV. AUX IMMO.', 'A', '', '', '');
    67. 

  67. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('142300', 'PROVIS. POUR RECONSTITUTION GIS.', 'A', '', '', '');
    68. 

  68. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('142400', 'PROVIS. INVESTIS. (PARTIC. SALAR.)', 'A', '', '', '');
    69. 

  69. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('143000', 'PROVIS. REGLEMENT. RELATIV. STOCKS', 'A', '', '', '');
    70. 

  70. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('143100', 'HAUSSE DES PRIX', 'A', '', '', '');
    71. 

  71. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('143200', 'FLUCTUATION DES COURS', 'A', '', '', '');
    72. 

  72. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('144000', 'PROVIS. REGLEM. RELAT. ELEM. ACTIF', 'A', '', '', '');
    73. 

  73. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('145000', 'AMORTISSEMENTS DEROGATOIRES', 'A', '', '', '');
    74. 

  74. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('146000', 'PROVISION SPECIALE DE REEVALUATION', 'A', '', '', '');
    75. 

  75. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('147000', 'PLUS-VALUES REINVESTIES', 'A', '', '', '');
    76. 

  76. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('148000', 'AUTRES PROVISIONS REGLEMENTEES', 'A', '', '', '');
    77. 

  77. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('151000', 'PROVISIONS POUR RISQUES', 'A', '', '', '');
    78. 

  78. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('151100', 'PROVISIONS POUR LITIGES', 'A', '', '', '');
    79. 

  79. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('151200', 'PROV. GARANT. DONNEES AUX CLIENTS', 'A', '', '', '');
    80. 

  80. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('151300', 'PROV. PERTES SUR MARCHES A TERME.', 'A', '', '', '');
    81. 

  81. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('151400', 'PROVIS. POUR AMENDES ET PENALITES', 'A', '', '', '');
    82. 

  82. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('151500', 'PROVIS. POUR PERTES DE CHANGE', 'A', '', '', '');
    83. 

  83. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('151800', 'AUTRES PROVISIONS POUR RISQUES', 'A', '', '', '');
    84. 

  84. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('153000', 'PROVIS. PENSIONS ET OBLIG. SIMIL.', 'A', '', '', '');
    85. 

  85. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('155000', 'PROVISIONS POUR IMPOTS', 'A', '', '', '');
    86. 

  86. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('156000', 'PROVIS. RENOUV. IMMO (ETS CONCESS)', 'A', '', '', '');
    87. 

  87. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('157000', 'PROV. CHARG. A REPART. SUR EXERC.', 'A', '', '', '');
    88. 

  88. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('157200', 'PROVIS. POUR GROSSES REPARATIONS', 'A', '', '', '');
    89. 

  89. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('158000', 'AUTRES PROVISIONS POUR CHARGES', 'A', '', '', '');
    90. 

  90. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('158200', 'PROVIS. CHARG. SOCIA. FISC. SUR CP', 'A', '', '', '');
    91. 

  91. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('161000', 'EMPRUNTS OBLIGATOIRES CONVERTIBLES', 'A', '', '', '');
    92. 

  92. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('163000', 'AUTRES EMPRUNTS OBLIGATAIRES', 'A', '', '', '');
    93. 

  93. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('164000', 'EMPRUNTS AUPRES ETABLIS. DE CREDIT', 'A', '', '', '');
    94. 

  94. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('165000', 'DEPOTS ET CAUTIONNEMENTS RECUS', 'A', '', '', '');
    95. 

  95. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('165100', 'DEPOTS', 'A', '', '', '');
    96. 

  96. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('165500', 'CAUTIONNEMENTS', 'A', '', '', '');
    97. 

  97. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('166000', 'PARTICIP. SALARIES AUX RESULTAS', 'A', '', '', '');
    98. 

  98. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('166100', 'COMPTES BLOQUES', 'A', '', '', '');
    99. 

  99. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('166200', 'FONDS DE PARTICIPATION', 'A', '', '', '');
    100. 

  100. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('167000', 'EMPR. DETTES ASSORT. CONDIT. PART.', 'A', '', '', '');
    101. 

  101. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('167100', 'EMISSION DE TITRES PARTICIPATIFS', 'A', '', '', '');
    102. 

  102. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('167400', 'AVANCES CONDITIONNEES DE L\'ETAT', 'A', '', '', '');
    103. 

  103. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('167500', 'EMPRUNTS PARTICIPATIFS', 'A', '', '', '');
    104. 

  104. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168000', 'AUTRES EMPR. ET DETTES ASSIMILEES', 'A', '', '', '');
    105. 

  105. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168100', 'AUTRES EMPRUNTS', 'A', '', '', '');
    106. 

  106. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168500', 'RENTES VIAGERES CAPITALISEES', 'A', '', '', '');
    107. 

  107. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168700', 'AUTRES DETTES', 'A', '', '', '');
    108. 

  108. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168800', 'INTERETS COURUS', 'A', '', '', '');
    109. 

  109. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168810', 'SUR EMPR. OBLIGATAIR. CONVERTIBLES', 'A', '', '', '');
    110. 

  110. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168830', 'SUR AUTRES EMPRUNTS OBLIGATAIRES', 'A', '', '', '');
    111. 

  111. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168840', 'SUR EMPRUNTS AUPRES ETABLI. CREDIT', 'A', '', '', '');
    112. 

  112. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168850', 'SUR DEPOTS ET CAUTIONNEMENTS RECUS', 'A', '', '', '');
    113. 

  113. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168860', 'SUR PARTICIP. SALAR. RESULTATS ETS', 'A', '', '', '');
    114. 

  114. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168870', 'SUR EMPR. DETTES ASSOR. COND. PART', 'A', '', '', '');
    115. 

  115. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('168880', 'SUR AUTRES EMPR. DETTES ASSIMILEES', 'A', '', '', '');
    116. 

  116. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('169000', 'PRIMES REMBOURSEMENT OBLIGATIONS', 'A', '', '', '');
    117. 

  117. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('171000', 'DETTES RATTACH. A PARTIC. (GROUPE)', 'A', '', '', '');
    118. 

  118. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('174000', 'DETTES RATT. A PART. (HORS GROUPE)', 'A', '', '', '');
    119. 

  119. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('178000', 'DETTES RATTACH. A STES EN PARTIC.', 'A', '', '', '');
    120. 

  120. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('178100', 'PRINCIPAL', 'A', '', '', '');
    121. 

  121. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('178800', 'INTERETS COURUS', 'A', '', '', '');
    122. 

  122. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('181000', 'COMPTE DE LIAISON ETABLISSEMENTS', 'A', '', '', '');
    123. 

  123. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('186000', 'BIENS PREST. SERV. ECH. (CHARGES)', 'A', '', '', '');
    124. 

  124. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('187000', 'BIENS PREST. SERV. ECH. (PRODUITS)', 'A', '', '', '');
    125. 

  125. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('188000', 'COMPTES DE LIAISON STES EN PARTIC.', 'A', '', '', '');
    126. 

  126. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('201100', 'FRAIS DE CONSTITUTION', 'A', '', '', '');
    127. 

  127. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('201200', 'FRAIS DE PREMIER ETABLISSEMENT', 'A', '', '', '');
    128. 

  128. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('201210', 'FRAIS DE PROSPECTION', 'A', '', '', '');
    129. 

  129. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('201220', 'FRAIS DE PUBLICITE', 'A', '', '', '');
    130. 

  130. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('201300', 'FRAIS AUGMEN. CAPIT. OPER. DIVERS.', 'A', '', '', '');
    131. 

  131. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('203000', 'FRAIS RECHERCHE ET DEVELOPPEMENT', 'A', '', '', '');
    132. 

  132. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('205000', 'CONCESSIONS ET DROITS SIMILAIRES', 'A', '', '', '');
    133. 

  133. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('206000', 'DROIT AU BAIL', 'A', '', '', '');
    134. 

  134. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('207000', 'FONDS COMMERCIAL', 'A', '', '', '');
    135. 

  135. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('208000', 'AUTRES IMMOBILISATIONS INCORPOR.', 'A', '', '', '');
    136. 

  136. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211000', 'TERRAINS', 'A', '', '', '');
    137. 

  137. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211100', 'TERRAINS NUS', 'A', '', '', '');
    138. 

  138. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211200', 'TERRAINS AMENAGES', 'A', '', '', '');
    139. 

  139. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211300', 'SOUS-SOLS ET SUR-SOLS', 'A', '', '', '');
    140. 

  140. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211400', 'TERRAINS DE GISEMENT', 'A', '', '', '');
    141. 

  141. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211410', 'CARRIERES', 'A', '', '', '');
    142. 

  142. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211500', 'TERRAINS BATIS', 'A', '', '', '');
    143. 

  143. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211510', 'ENSEMBLES  IMMOBILIERS INDUSTRIELS', 'A', '', '', '');
    144. 

  144. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211550', 'ENSEMBLES IMMOB. ADM. ET COMMERC.', 'A', '', '', '');
    145. 

  145. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211580', 'AUTRES ENSEMBLES IMMOBILIERS', 'A', '', '', '');
    146. 

  146. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211581', 'AFFECTES AUX OPERAT. PROFESSION.', 'A', '', '', '');
    147. 

  147. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211588', 'AFFECTES AUX OPERAT. NON PROF.', 'A', '', '', '');
    148. 

  148. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('211600', 'COMPTE D\'ORDRE SUR IMMOBILISATIONS', 'A', '', '', '');
    149. 

  149. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('212000', 'AGENCEMENTS AMENAGEMENTS TERRAINS', 'A', '', '', '');
    150. 

  150. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213000', 'CONSTRUCTIONS', 'A', '', '', '');
    151. 

  151. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213100', 'BATIMENTS', 'A', '', '', '');
    152. 

  152. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213110', 'ENSEMBLES IMMOB. INDUSTRIELS', 'A', '', '', '');
    153. 

  153. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213150', 'ENSEMBLES IMMOB. ADM. ET COMMERC.', 'A', '', '', '');
    154. 

  154. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213180', 'AUTRES ENSEMBLES IMMOBILIERS', 'A', '', '', '');
    155. 

  155. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213181', 'AFFECTES AUX OPERAT. PROFESSION.', 'A', '', '', '');
    156. 

  156. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213188', 'AFFECTES AUX OPERAT. NON PROF.', 'A', '', '', '');
    157. 

  157. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213500', 'INSTALLATIONS GENERALES', 'A', '', '', '');
    158. 

  158. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213800', 'OUVRAGES D\'INFRASTRUCTURE', 'A', '', '', '');
    159. 

  159. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213810', 'VOIES DE TERRE', 'A', '', '', '');
    160. 

  160. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213820', 'VOIES DE FER', 'A', '', '', '');
    161. 

  161. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213830', 'VOIES D\'EAU', 'A', '', '', '');
    162. 

  162. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213840', 'BARRAGES', 'A', '', '', '');
    163. 

  163. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('213850', 'PISTES D\'AERODROMES', 'A', '', '', '');
    164. 

  164. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('214000', 'CONSTRUCTIONS SUR SOL D\'AUTRUI', 'A', '', '', '');
    165. 

  165. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('215000', 'INSTALL. TECH. MAT. OUTIL. INDUS.', 'A', '', '', '');
    166. 

  166. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('215100', 'INSTALL. COMPLEXES SPECIALISEES', 'A', '', '', '');
    167. 

  167. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('215110', 'SUR SOL PROPRE', 'A', '', '', '');
    168. 

  168. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('215140', 'SUR SOL D\'AUTRUI', 'A', '', '', '');
    169. 

  169. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('215300', 'INSTALL. A CARACTERE SPECIFIQUE', 'A', '', '', '');
    170. 

  170. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('215310', 'SUR SOL PROPRE', 'A', '', '', '');
    171. 

  171. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('215340', 'SUR SOL D\'AUTRUI', 'A', '', '', '');
    172. 

  172. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('215400', 'MATERIEL INDUSTRIEL', 'A', '', '', '');
    173. 

  173. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('215500', 'OUTILLAGE INDUSTRIEL', 'A', '', '', '');
    174. 

  174. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('215700', 'AGENCEM. AMENAG. MAT. OUTIL. INDUS', 'A', '', '', '');
    175. 

  175. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('218000', 'AUTRES IMMOBILISATIONS CORPORELLES', 'A', '', '', '');
    176. 

  176. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('218100', 'INSTALL. GENE. AGENC. AMENAG. DIV.', 'A', '', '', '');
    177. 

  177. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('218200', 'MATERIEL DE TRANSPORT', 'A', '', '', '');
    178. 

  178. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('218300', 'MATERIEL DE BUREAU ET INFORMATIQUE', 'A', '', '', '');
    179. 

  179. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('218400', 'MOBILIER', 'A', '', '', '');
    180. 

  180. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('218500', 'CHEPTEL', 'A', '', '', '');
    181. 

  181. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('218600', 'EMBALLAGES RECUPERABLES', 'A', '', '', '');
    182. 

  182. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('231000', 'IMMOBILISAT. CORPORELLES EN COURS', 'A', '', '', '');
    183. 

  183. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('231200', 'TERRAINS', 'A', '', '', '');
    184. 

  184. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('231300', 'CONSTRUCTIONS', 'A', '', '', '');
    185. 

  185. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('231500', 'INSTALL. TECH. MAT. OUTIL. INDUST.', 'A', '', '', '');
    186. 

  186. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('231800', 'AUTRES IMMOBILISATIONS CORPORELLES', 'A', '', '', '');
    187. 

  187. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('232000', 'IMMO. INCORPORELLES EN COURS', 'A', '', '', '');
    188. 

  188. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('237000', 'AVANC. ACOMPT. VERSES SUR IMM. INC', 'A', '', '', '');
    189. 

  189. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('238000', 'AVANC. ACOMP. VERSES CDES IMM. COR', 'A', '', '', '');
    190. 

  190. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('238200', 'TERRAINS', 'A', '', '', '');
    191. 

  191. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('238300', 'CONSTRUCTIONS', 'A', '', '', '');
    192. 

  192. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('238500', 'INSTALL. TECH. MAT. OUTIL. INDUST.', 'A', '', '', '');
    193. 

  193. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('238800', 'AUTRES IMMOBILISATIONS CORPORELLES', 'A', '', '', '');
    194. 

  194. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('261000', 'TITRES DE PARTICIPATION', 'A', '', '', '');
    195. 

  195. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('261100', 'ACTIONS', 'A', '', '', '');
    196. 

  196. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('261800', 'AUTRES TITRES', 'A', '', '', '');
    197. 

  197. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('266000', 'AUTRES FORMES DE PARTICIPATION', 'A', '', '', '');
    198. 

  198. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('267000', 'CREANCES RATTACHEES A PARTICIPAT.', 'A', '', '', '');
    199. 

  199. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('267100', 'CREANCES RATT. A PART. (GROUPE)', 'A', '', '', '');
    200. 

  200. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('267400', 'CREANC. RATT. PART. (HORS GROUPE)', 'A', '', '', '');
    201. 

  201. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('267500', 'VERSEM. D\'APPORTS NON CAPITALISES', 'A', '', '', '');
    202. 

  202. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('267600', 'AVANCES CONSOLIDABLES', 'A', '', '', '');
    203. 

  203. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('267700', 'AUTRES CREANCES RATT. A PART.', 'A', '', '', '');
    204. 

  204. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('267800', 'INTERETS COURUS', 'A', '', '', '');
    205. 

  205. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('268000', 'CREANCES RATT. A STE EN PART.', 'A', '', '', '');
    206. 

  206. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('268100', 'PRINCIPAL', 'A', '', '', '');
    207. 

  207. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('268800', 'INTERETS COURUS', 'A', '', '', '');
    208. 

  208. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('269000', 'VERS. REST. A EFFECT. SUR T.P.N.L.', 'A', '', '', '');
    209. 

  209. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('271000', 'TITRES IMMOBILISES (DROIT PROP.)', 'A', '', '', '');
    210. 

  210. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('271100', 'ACTIONS', 'A', '', '', '');
    211. 

  211. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('271800', 'AUTRES TITRES', 'A', '', '', '');
    212. 

  212. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('272000', 'TITRES IMMOBILISES (DROIT CREANCE)', 'A', '', '', '');
    213. 

  213. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('272100', 'OBLIGATIONS', 'A', '', '', '');
    214. 

  214. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('272200', 'BONS', 'A', '', '', '');
    215. 

  215. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('273000', 'TITRES IMMOBILISES DE L\'ACT. DE PORTEF.', 'A', '', '', '');
    216. 

  216. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('274000', 'PRETS', 'A', '', '', '');
    217. 

  217. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('274100', 'PRETS PARTICIPATIFS', 'A', '', '', '');
    218. 

  218. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('274200', 'PRETS AUX ASSOCIES', 'A', '', '', '');
    219. 

  219. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('274300', 'PRETS AU PERSONNEL', 'A', '', '', '');
    220. 

  220. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('274800', 'AUTRES PRETS', 'A', '', '', '');
    221. 

  221. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('275000', 'DEPOTS ET CAUTIONNEMENTS VERSES', 'A', '', '', '');
    222. 

  222. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('275100', 'DEPOTS', 'A', '', '', '');
    223. 

  223. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('275500', 'CAUTIONNEMENTS', 'A', '', '', '');
    224. 

  224. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('276000', 'AUTRES CREANCES IMMOBILISEES', 'A', '', '', '');
    225. 

  225. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('276100', 'CREANCES DIVERSES', 'A', '', '', '');
    226. 

  226. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('276800', 'INTERETS COURUS', 'A', '', '', '');
    227. 

  227. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('276820', 'SUR TITRES IMMOB. (DROIT CREANCE)', 'A', '', '', '');
    228. 

  228. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('276840', 'SUR PRETS', 'A', '', '', '');
    229. 

  229. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('276850', 'SUR DEPOTS ET CAUTIONNEMENTS', 'A', '', '', '');
    230. 

  230. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('276880', 'SUR CREANCES DIVERSES', 'A', '', '', '');
    231. 

  231. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('277100', 'ACTIONS PROPRES OU PARTS PROPRES', 'A', '', '', '');
    232. 

  232. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('277200', 'ACT. PRO. OU PARTS PRO. VOIE D\'ANNUL.', 'A', '', '', '');
    233. 

  233. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('279000', 'VERSEM. A EFFECT. SUR T.I.N.L.', 'A', '', '', '');
    234. 

  234. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('280000', 'AMORTISS. IMMOBILISATIONS INCORP.', 'A', '', '', '');
    235. 

  235. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('280100', 'FRAIS D\'ETABLISSEMENT', 'A', '', '', '');
    236. 

  236. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('280300', 'FRAIS DE RECHERCHE ET DEVELOPP.', 'A', '', '', '');
    237. 

  237. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('280500', 'CONCESSIONS ET DROITS SIMILAIRES', 'A', '', '', '');
    238. 

  238. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('280700', 'FONDS COMMERCIAL', 'A', '', '', '');
    239. 

  239. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('280800', 'AUTRES IMMOBILISATIONS INCORPOR.', 'A', '', '', '');
    240. 

  240. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('281000', 'AMORTISS. IMMOBILISATIONS CORPOR.', 'A', '', '', '');
    241. 

  241. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('281100', 'TERRAINS DE GISEMENT', 'A', '', '', '');
    242. 

  242. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('281200', 'AGENCEMENTS AMENAGEMENTS TERRAINS', 'A', '', '', '');
    243. 

  243. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('281300', 'CONSTRUCTIONS', 'A', '', '', '');
    244. 

  244. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('281400', 'CONSTRUCTIONS SUR SOL D\'AUTRUI', 'A', '', '', '');
    245. 

  245. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('281500', 'INSTALL TECH. MAT. OUTIL. INDUST.', 'A', '', '', '');
    246. 

  246. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('281800', 'AUTRES IMMOBILISATIONS CORPORELLES', 'A', '', '', '');
    247. 

  247. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('282000', 'AMORTISS. IMMOBIL. EN CONCESSION', 'A', '', '', '');
    248. 

  248. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('290000', 'PROVIS. DEPRECIATION IMMOB. INCORP', 'A', '', '', '');
    249. 

  249. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('290500', 'MARQUES PROCEDES DROITS ET VALEURS', 'A', '', '', '');
    250. 

  250. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('290600', 'DROIT AU BAIL', 'A', '', '', '');
    251. 

  251. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('290700', 'FONDS COMMERCIAL', 'A', '', '', '');
    252. 

  252. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('290800', 'AUTRES IMMOB. INCORPORELLES', 'A', '', '', '');
    253. 

  253. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('291000', 'PROVIS. DEPRECIATION IMMOB. CORPOR', 'A', '', '', '');
    254. 

  254. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('291100', 'TERRAINS (AUTRES QUE GISEMENT)', 'A', '', '', '');
    255. 

  255. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('292000', 'PROVIS. DEPRECIAT. IMMOB. CONCESS.', 'A', '', '', '');
    256. 

  256. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('293000', 'PROVIS. DEPRECIAT. IMMOB. EN COURS', 'A', '', '', '');
    257. 

  257. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('293100', 'IMMOBILISATIONS CORPOR. EN COURS', 'A', '', '', '');
    258. 

  258. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('293200', 'IMMO. INCORPORELLES EN COURS', 'A', '', '', '');
    259. 

  259. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('296000', 'PROV. DEPREC. PART ET CREANC. PART', 'A', '', '', '');
    260. 

  260. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('296100', 'TITRES DE PARTICIPATION', 'A', '', '', '');
    261. 

  261. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('296600', 'AUTRES FORMES DE PARTICIPATION', 'A', '', '', '');
    262. 

  262. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('296700', 'CREANCES RATT. A PARTICIPATION', 'A', '', '', '');
    263. 

  263. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('296800', 'CREANCES RATT. A STE EN PARTICIP.', 'A', '', '', '');
    264. 

  264. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('297000', 'PROVIS. DEPRECIATION AUTRES IMMOB.', 'A', '', '', '');
    265. 

  265. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('297100', 'TITRES IMMOBILISES DROIT PROPRIETE', 'A', '', '', '');
    266. 

  266. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('297200', 'TITRES IMMOBILISES DROIT CREANCE', 'A', '', '', '');
    267. 

  267. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('297300', 'TITRES IMMO. DE L\'ACT. DE PORTEF.', 'A', '', '', '');
    268. 

  268. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('297400', 'PRETS', 'A', '', '', '');
    269. 

  269. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('297500', 'DEPOTS ET CAUTIONNEMENTS VERSES', 'A', '', '', '');
    270. 

  270. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('297600', 'AUTRES CREANCES IMMOBILISEES', 'A', '', '', '');
    271. 

  271. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('311000', 'MATIERE (OU GROUPE) A', 'A', '', '', '');
    272. 

  272. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('312000', 'MATIERE (OU GROUPE) B', 'A', '', '', '');
    273. 

  273. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('317000', 'FOURNITURES A, B, C...', 'A', '', '', '');
    274. 

  274. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('321000', 'MATIERES CONSOMMABLES', 'A', '', '', '');
    275. 

  275. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('321100', 'MATIERE (OU GROUPE) C', 'A', '', '', '');
    276. 

  276. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('321200', 'MATIERE (OU GROUPE) D', 'A', '', '', '');
    277. 

  277. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('322000', 'FOURNITURES CONSOMMABLES', 'A', '', '', '');
    278. 

  278. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('322100', 'COMBUSTIBLES', 'A', '', '', '');
    279. 

  279. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('322200', 'PRODUITS D\'ENTRETIEN', 'A', '', '', '');
    280. 

  280. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('322300', 'FOURNITURES D\'ATELIER ET D\'USINE', 'A', '', '', '');
    281. 

  281. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('322400', 'FOURNITURES DE MAGASIN', 'A', '', '', '');
    282. 

  282. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('322500', 'FOURNITURES DE BUREAU', 'A', '', '', '');
    283. 

  283. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('326000', 'EMBALLAGES', 'A', '', '', '');
    284. 

  284. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('326100', 'EMBALLAGES PERDUS', 'A', '', '', '');
    285. 

  285. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('326500', 'EMBAL. RECUPER. NON IDENTIFIABLES', 'A', '', '', '');
    286. 

  286. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('326700', 'EMBALLAGES A USAGE MIXTE', 'A', '', '', '');
    287. 

  287. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('331000', 'PRODUITS EN COURS', 'A', '', '', '');
    288. 

  288. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('331100', 'PRODUITS EN COURS P1', 'A', '', '', '');
    289. 

  289. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('331200', 'PRODUITS EN COURS P2', 'A', '', '', '');
    290. 

  290. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('335000', 'TRAVAUX EN COURS', 'A', '', '', '');
    291. 

  291. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('335100', 'TRAVAUX EN COURS T1', 'A', '', '', '');
    292. 

  292. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('335200', 'TRAVAUX EN COURS T2', 'A', '', '', '');
    293. 

  293. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('341000', 'ETUDES EN COURS', 'A', '', '', '');
    294. 

  294. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('341100', 'ETUDE EN COURS E1', 'A', '', '', '');
    295. 

  295. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('341200', 'ETUDE EN COURS E2', 'A', '', '', '');
    296. 

  296. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('345000', 'PRESTATIONS DE SERVICES EN COURS', 'A', '', '', '');
    297. 

  297. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('345100', 'PRESTATION DE SERVICES S1', 'A', '', '', '');
    298. 

  298. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('345200', 'PRESTATION DE SERVICES S2', 'A', '', '', '');
    299. 

  299. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('351000', 'PRODUITS INTERMEDIAIRES', 'A', '', '', '');
    300. 

  300. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('351100', 'PRODUIT INTERMEDIAIRE (OU GRPE) A', 'A', '', '', '');
    301. 

  301. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('351200', 'PRODUIT INTERMEDIAIRE (OU GRPE) B', 'A', '', '', '');
    302. 

  302. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('355000', 'PRODUITS FINIS', 'A', '', '', '');
    303. 

  303. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('355100', 'PRODUIT FINI (OU GROUPE) A', 'A', '', '', '');
    304. 

  304. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('355200', 'PRODUIT FINI (OU GROUPE) B', 'A', '', '', '');
    305. 

  305. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('358000', 'PROD. RESIDUELS (OU MAT. RECUP.)', 'A', '', '', '');
    306. 

  306. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('358100', 'DECHETS', 'A', '', '', '');
    307. 

  307. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('358500', 'REBUTS', 'A', '', '', '');
    308. 

  308. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('358600', 'MATIERES DE RECUPERATION', 'A', '', '', '');
    309. 

  309. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('371000', 'MARCHANDISE (OU GROUPE) A', 'A', '', '', '');
    310. 

  310. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('372000', 'MARCHANDISE (OU GROUPE) B', 'A', '', '', '');
    311. 

  311. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('391000', 'PROVIS. POUR DEPRECIAT. MAT. PREM.', 'A', '', '', '');
    312. 

  312. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('391100', 'MATIERE (OU GROUPE) A', 'A', '', '', '');
    313. 

  313. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('391200', 'MATIERE (OU GROUPE) B', 'A', '', '', '');
    314. 

  314. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('391700', 'FOURNITURE A, B, C...', 'A', '', '', '');
    315. 

  315. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('392000', 'PROVIS. POUR DEPRECIAT. AUT. APPRO', 'A', '', '', '');
    316. 

  316. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('392100', 'MATIERES CONSOMMABLES', 'A', '', '', '');
    317. 

  317. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('392200', 'FOURNITURES CONSOMMABLES', 'A', '', '', '');
    318. 

  318. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('392600', 'EMBALLAGES', 'A', '', '', '');
    319. 

  319. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('393000', 'PROV. DEPREC. EN-COURS PROD. BIENS', 'A', '', '', '');
    320. 

  320. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('393100', 'PRODUITS EN COURS', 'A', '', '', '');
    321. 

  321. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('393500', 'TRAVAUX EN COURS', 'A', '', '', '');
    322. 

  322. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('394000', 'PROV. DEPREC. EN-COURS PROD. SERV.', 'A', '', '', '');
    323. 

  323. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('394100', 'ETUDES EN COURS', 'A', '', '', '');
    324. 

  324. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('394500', 'PRESTATIONS DE SERVICES EN COURS', 'A', '', '', '');
    325. 

  325. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('395000', 'PROV. POUR DEPREC. STOCKS DE PROD.', 'A', '', '', '');
    326. 

  326. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('395100', 'PRODUITS INTERMEDIAIRES', 'A', '', '', '');
    327. 

  327. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('395500', 'PRODUITS FINIS', 'A', '', '', '');
    328. 

  328. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('397000', 'PROV. POUR DEPREC. STOCKS MARCHAN.', 'A', '', '', '');
    329. 

  329. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('397100', 'MARCHANDISE OU GROUPE A', 'A', '', '', '');
    330. 

  330. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('397200', 'MARCHANDISE OU GROUPE B', 'A', '', '', '');
    331. 

  331. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('401000', 'FOURNISSEURS DIVERS', 'A', '', '', '');
    332. 

  332. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('403000', 'FOURNISSEURS - EFFETS A PAYER', 'A', '', '', '');
    333. 

  333. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('404000', 'FOURNISSEURS D\'IMMOBILISATIONS', 'A', '', '', '');
    334. 

  334. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('404100', 'FOURNISSEURS ACHATS D\'IMMOBILISAT.', 'A', '', '', '');
    335. 

  335. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('404700', 'FOURNIS. D\'IMMOB. RETENUES DE GAR.', 'A', '', '', '');
    336. 

  336. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('405000', 'FOURNIS. D\'IMMOB. EFFETS A PAYER', 'A', '', '', '');
    337. 

  337. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('408000', 'FOURNIS. FACTURES NON PARVENUES', 'A', '', '', '');
    338. 

  338. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('408100', 'FOURNISSEURS', 'A', '', '', '');
    339. 

  339. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('408400', 'FOURNISSEURS D\'IMMOBILISATIONS', 'A', '', '', '');
    340. 

  340. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('408800', 'FOURNISSEURS INTERETS COURUS', 'A', '', '', '');
    341. 

  341. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('409000', 'FOURNISSEURS DEBITEURS', 'A', '', '', '');
    342. 

  342. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('409100', 'FOURNIS. AVANC. & ACOMPT. SUR CDES', 'A', '', '', '');
    343. 

  343. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('409600', 'FOURN. CREAN. EMB. & MAT. A RENDRE', 'A', '', '', '');
    344. 

  344. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('409700', 'FOURNISSEURS AUTRES AVOIRS', 'A', '', '', '');
    345. 

  345. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('409710', 'FOURNISSEURS D\'EXPLOITATION', 'A', '', '', '');
    346. 

  346. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('409740', 'FOURNISSEURS D\'IMMOBILISATIONS', 'A', '', '', '');
    347. 

  347. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('409800', 'RABAIS REMISES RISTOUR. A OBTENIR', 'A', '', '', '');
    348. 

  348. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('410000', 'CLIENTS ET COMPTES RATTACHES', 'A', '', '', '');
    349. 

  349. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('411000', 'CLIENTS DIVERS', 'A', '', '', '');
    350. 

  350. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('413000', 'CLIENTS EFFETS A RECEVOIR', 'A', '', '', '');
    351. 

  351. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('416000', 'CLIENTS DOUTEUX OU LITIGIEUX', 'A', '', '', '');
    352. 

  352. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('417000', 'CREANC. SUR TRAV. NON ENCORE FACT.', 'A', '', '', '');
    353. 

  353. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('418000', 'CLIENTS PRODUITS NON ENCORE FACT.', 'A', '', '', '');
    354. 

  354. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('418100', 'CLIENTS FACTURES A ETABLIR', 'A', '', '', '');
    355. 

  355. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('418800', 'CLIENTS INTERETS COURUS', 'A', '', '', '');
    356. 

  356. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('419000', 'CLIENTS CREDITEURS', 'A', '', '', '');
    357. 

  357. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('419100', 'CLTS AVANC. & ACOMP. RECUS SUR CDE', 'A', '', '', '');
    358. 

  358. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('419600', 'CLTS DETT. POUR EMB. & MAT. CONSIG', 'A', '', '', '');
    359. 

  359. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('419700', 'CLIENTS - AUTRES AVOIRS', 'A', '', '', '');
    360. 

  360. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('419800', 'RABAIS REMISES RIST. A ACCORDER', 'A', '', '', '');
    361. 

  361. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('421000', 'PERSONNEL REMUNERATIONS DUES', 'A', '', '', '');
    362. 

  362. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('422000', 'COMITES D\'ENTREPRISE, D\'ETABLIS.', 'A', '', '', '');
    363. 

  363. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('424000', 'PARTICIP. DES SALAR. AUX RESULTATS', 'A', '', '', '');
    364. 

  364. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('424600', 'RESERVE SPECIALE (ART L442.2)', 'A', '', '', '');
    365. 

  365. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('424800', 'COMPTES COURANTS', 'A', '', '', '');
    366. 

  366. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('425000', 'PERSONNEL AVANCES ET ACOMPTES', 'A', '', '', '');
    367. 

  367. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('426000', 'PERSONNEL DEPOTS', 'A', '', '', '');
    368. 

  368. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('427000', 'PERSONNEL OPPOSITIONS', 'A', '', '', '');
    369. 

  369. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('428000', 'PERS. CHARG. A PAY. & PROD. A REC.', 'A', '', '', '');
    370. 

  370. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('428200', 'DETTES PROVISIO. POUR CONGES PAYES', 'A', '', '', '');
    371. 

  371. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('428400', 'DETT. PROV. PART. SAL. AUX RESULT.', 'A', '', '', '');
    372. 

  372. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('428600', 'AUTRES CHARGES A PAYER', 'A', '', '', '');
    373. 

  373. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('428700', 'PRODUITS A RECEVOIR', 'A', '', '', '');
    374. 

  374. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('438000', 'ORG. SOC. CHARG. A PAY. & PROD.', 'A', '', '', '');
    375. 

  375. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('438200', 'CHARGES SOCIALES SUR CONGES PAYES', 'A', '', '', '');
    376. 

  376. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('438700', 'PRODUITS A RECEVOIR', 'A', '', '', '');
    377. 

  377. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('441000', 'ETATS SUBVENTIONS A RECEVOIR', 'A', '', '', '');
    378. 

  378. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('441100', 'SUBVENTIONS D\'INVESTISSEMENT', 'A', '', '', '');
    379. 

  379. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('441700', 'SUBVENTIONS D\'EXPLOITATION', 'A', '', '', '');
    380. 

  380. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('441800', 'SUBVENTIONS D\'EQUILIBRE', 'A', '', '', '');
    381. 

  381. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('441900', 'AVANCES SUR SUBVENTIONS', 'A', '', '', '');
    382. 

  382. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('442000', 'ETAT IMP. & TAX. RECOUV. SUR TIERS', 'A', '', '', '');
    383. 

  383. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('442400', 'OBLIGATAIRES', 'A', '', '', '');
    384. 

  384. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('442500', 'ASSOCIES', 'A', '', '', '');
    385. 

  385. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('443000', 'OPERATIONS PART. AVEC L\'ETAT,...', 'A', '', '', '');
    386. 

  386. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('443100', 'CREANCES ETAT SUPPR. DECAL. TVA', 'A', '', '', '');
    387. 

  387. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('443800', 'INTERES COURUS CREANCES CPTE 443100', 'A', '', '', '');
    388. 

  388. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('444000', 'ETAT IMPOTS SUR LES BENEFICES', 'A', '', '', '');
    389. 

  389. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('444500', 'ETAT TAXES SUR LE CHIFFRE D\'AFF.', 'A', '', '', '');
    390. 

  390. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445200', 'TVA DUE INTRACOMMUNAUTAIRE', 'A', '', '', '');
    391. 

  391. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445510', 'TVA A DECAISSER', 'A', '', '', '');
    392. 

  392. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445580', 'TAXES ASSIMILEES A TVA', 'A', '', '', '');
    393. 

  393. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445600', 'TAXES SUR LE CA DEDUCTIBLES', 'A', '', '', '');
    394. 

  394. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445621', 'TVA SUR IMMO.  5.5%', 'A', '', '', '');
    395. 

  395. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445622', 'TVA SUR IMMO. 20.6%', 'A', '', '', '');
    396. 

  396. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445623', 'TVA SUR IMMO. 19.6%', 'A', '', '', '');
    397. 

  397. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445630', 'TVA TRANSFEREE PAR D\'AUTRES ETS', 'A', '', '', '');
    398. 

  398. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445662', 'TVA DEDUCTIBLE 20.6%', 'A', '', '', '');
    399. 

  399. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445670', 'CREDIT DE TVA A REPORTER', 'A', '', '', '');
    400. 

  400. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445680', 'TAXES ASSIMILEES A LA TVA', 'A', '', '', '');
    401. 

  401. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445700', 'TAXE SUR LE C.A. COLLECT. ENTREPR.', 'A', '', '', '');
    402. 

  402. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445712', 'TVA COLLECTEE 20.6%', 'A', '', '', '');
    403. 

  403. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445800', 'TAXES SUR CA A REGULAR. OU EN ATT.', 'A', '', '', '');
    404. 

  404. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445810', 'ACOMPTES REGIME SIMPLIFIE D\'IMPOS.', 'A', '', '', '');
    405. 

  405. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445820', 'ACOMPTES REGIME DU FORFAIT', 'A', '', '', '');
    406. 

  406. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445830', 'REMBOURS. TAXES SUR CA DEMANDE', 'A', '', '', '');
    407. 

  407. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445840', 'TVA RECUPEREE D\'AVANCE', 'A', '', '', '');
    408. 

  408. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445861', 'TVA EN ATTENTE DEDUCTIBLE  5.5%', 'A', '', '', '');
    409. 

  409. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445862', 'TVA EN ATTENTE DEDUCTIBLE 20.6%', 'A', '', '', '');
    410. 

  410. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445863', 'TVA EN ATTENTE DEDUCTIBLE 19.6%', 'A', '', '', '');
    411. 

  411. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445871', 'TVA EN ATTENTE COLLECTEE  5.5%', 'A', '', '', '');
    412. 

  412. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445872', 'TVA EN ATTENTE COLLECTEE 20.6%', 'A', '', '', '');
    413. 

  413. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445873', 'TVA EN ATTENTE COLLECTEE 19.6%', 'A', '', '', '');
    414. 

  414. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('446000', 'TITRES SUR TVA', 'A', '', '', '');
    415. 

  415. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('446100', 'OBLIGATIONS CAUTIONNEES', 'A', '', '', '');
    416. 

  416. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('446900', 'CREANCE TVA DECALAGE D\'UN MOIS', 'A', '', '', '');
    417. 

  417. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('447000', 'AUTRES IMPOTS, TAX. ET VERS. ASSIM', 'A', '', '', '');
    418. 

  418. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('448000', 'ETAT CHARG. A PAY. & PROD. A RECEV', 'A', '', '', '');
    419. 

  419. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('448200', 'CHARGES FISCALES SUR CONG. A PAYER', 'A', '', '', '');
    420. 

  420. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('448600', 'AUTRES CHARGES A PAYER', 'A', '', '', '');
    421. 

  421. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('448700', 'PRODUITS A RECEVOIR', 'A', '', '', '');
    422. 

  422. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('451000', 'GROUPE', 'A', '', '', '');
    423. 

  423. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('455000', 'ASSOCIES COMPTES COURANTS', 'A', '', '', '');
    424. 

  424. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('455100', 'PRINCIPAL', 'A', '', '', '');
    425. 

  425. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('455780', 'TAXES ASSIMILEES A LA TVA', 'A', '', '', '');
    426. 

  426. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('455800', 'INTERETS COURUS', 'A', '', '', '');
    427. 

  427. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('456000', 'ASSOCIES OPERATIONS SUR LE CAPITAL', 'A', '', '', '');
    428. 

  428. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('456100', 'ASSOCIES COMPTES D\'APPORT EN STE', 'A', '', '', '');
    429. 

  429. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('456110', 'APPORTS EN NATURE', 'A', '', '', '');
    430. 

  430. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('456150', 'APPORTS EN NUMERAIRE', 'A', '', '', '');
    431. 

  431. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('456200', 'APPORTEURS CAPIT. APPELE NON VERSE', 'A', '', '', '');
    432. 

  432. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('456210', 'ACTION. CAP. SOUSC. APP. NON VERSE', 'A', '', '', '');
    433. 

  433. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('456250', 'ASSOCIES CAPITAL APPELE NON VERSE', 'A', '', '', '');
    434. 

  434. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('456300', 'ASSOC. VERS. RECUS SUR AUGM. CAPIT', 'A', '', '', '');
    435. 

  435. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('456400', 'ASSOCIES VERSEMENTS ANTICIPES', 'A', '', '', '');
    436. 

  436. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('456600', 'ACTIONNAIRES DEFAILLANTS', 'A', '', '', '');
    437. 

  437. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('456700', 'ASSOCIES CAPITAL A REMBOURSER', 'A', '', '', '');
    438. 

  438. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('457000', 'ASSOCIES DIVIDENDES A PAYER', 'A', '', '', '');
    439. 

  439. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('458000', 'ASSOC. OPERAT. EN COMMUN ET EN GIE', 'A', '', '', '');
    440. 

  440. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('458100', 'OPERATIONS COURANTES', 'A', '', '', '');
    441. 

  441. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('458800', 'INTERETS COURUS', 'A', '', '', '');
    442. 

  442. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('462000', 'CREANCES SUR CESSIONS D\'IMMOBILIS.', 'A', '', '', '');
    443. 

  443. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('464000', 'DETTES SUR ACQUIS. VALEURS MOBI.', 'A', '', '', '');
    444. 

  444. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('465000', 'CREANC. SUR CESSIONS VALEURS MOB.', 'A', '', '', '');
    445. 

  445. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('467000', 'AUTRES COMPTES DEBIT. OU CREDIT.', 'A', '', '', '');
    446. 

  446. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('467200', 'DEBOURS PAYES', 'A', '', '', '');
    447. 

  447. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('468000', 'DIVERS CHARG. A PAY. & PROD. A REC', 'A', '', '', '');
    448. 

  448. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('468600', 'CHARGES A PAYER', 'A', '', '', '');
    449. 

  449. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('468700', 'PRODUITS A RECEVOIR', 'A', '', '', '');
    450. 

  450. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('471000', 'COMPTES D\'ATTENTE', 'A', '', '', '');
    451. 

  451. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('471100', 'REIMPUTATION', 'A', '', '', '');
    452. 

  452. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('476000', 'DIFFERENCES DE CONVERSION ACTIF', 'A', '', '', '');
    453. 

  453. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('476100', 'DIMINUTION DES CREANCES', 'A', '', '', '');
    454. 

  454. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('476200', 'AUGMENTATION DES DETTES', 'A', '', '', '');
    455. 

  455. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('476800', 'DIFFER. COMPENS. PAR COUV. CHANGE', 'A', '', '', '');
    456. 

  456. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('477000', 'DIFFERENCES DE CONVERSION PASSIF', 'A', '', '', '');
    457. 

  457. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('477100', 'AUGMENTATION DES CREANCES', 'A', '', '', '');
    458. 

  458. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('477200', 'DIMINUTION DES DETTES', 'A', '', '', '');
    459. 

  459. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('477800', 'DIFFER. COMPENS. PAR COUV. CHANGE', 'A', '', '', '');
    460. 

  460. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('478000', 'AUTRES COMPTES TRANSITOIRES', 'A', '', '', '');
    461. 

  461. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('481000', 'CHARG. A REPART. SUR PLUS. EXERC.', 'A', '', '', '');
    462. 

  462. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('481100', 'CHARGES DIFFEREES', 'A', '', '', '');
    463. 

  463. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('481200', 'FRAIS D\'ACQUISITION DES IMMOBILIS.', 'A', '', '', '');
    464. 

  464. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('481600', 'FRAIS D\'EMISSION DES EMPRUNTS', 'A', '', '', '');
    465. 

  465. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('481800', 'CHARGES A ETALER', 'A', '', '', '');
    466. 

  466. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('486000', 'CHARGES CONSTATEES D\'AVANCE', 'A', '', '', '');
    467. 

  467. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('487000', 'PRODUITS CONSTATES D\'AVANCE', 'A', '', '', '');
    468. 

  468. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('488000', 'CPTES REPART. PERIO. CHARG. & PROD', 'A', '', '', '');
    469. 

  469. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('488600', 'CHARGES', 'A', '', '', '');
    470. 

  470. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('488700', 'PRODUITS', 'A', '', '', '');
    471. 

  471. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('491000', 'PROVIS. POUR DEPREC. CPTES CLIENTS', 'A', '', '', '');
    472. 

  472. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('495000', 'PROV. POUR DEPREC. CPTES GRPE ASS', 'A', '', '', '');
    473. 

  473. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('495100', 'COMPTES DU GROUPE', 'A', '', '', '');
    474. 

  474. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('495500', 'COMPTES COURANTS DES ASSOCIES', 'A', '', '', '');
    475. 

  475. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('495800', 'OPERAT. FAITES EN COMMUN & EN GIE', 'A', '', '', '');
    476. 

  476. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('496000', 'PROVIS. POUR DEPREC. CPTES DEBIT.', 'A', '', '', '');
    477. 

  477. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('496200', 'CREANCES SUR CESSIONS D\'IMMOBILIS.', 'A', '', '', '');
    478. 

  478. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('496500', 'CREANC. SUR CESSIONS VALEURS MOB.', 'A', '', '', '');
    479. 

  479. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('496700', 'AUTRES COMPTES DEBITEURS', 'A', '', '', '');
    480. 

  480. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('501000', 'PARTS DANS DES ENTREPRISES LIEES', 'A', '', '', '');
    481. 

  481. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('502000', 'ACTIONS PROPRES', 'A', '', '', '');
    482. 

  482. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('503000', 'ACTIONS', 'A', '', '', '');
    483. 

  483. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('503100', 'TITRES COTES', 'A', '', '', '');
    484. 

  484. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('503500', 'TITRES NON COTES', 'A', '', '', '');
    485. 

  485. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('504000', 'AUTRES TITRES CONFERANT DROIT PROP', 'A', '', '', '');
    486. 

  486. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('505000', 'OBLIG. & BONS EMIS PAR LA SOCIETE', 'A', '', '', '');
    487. 

  487. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('506000', 'OBLIGATIONS', 'A', '', '', '');
    488. 

  488. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('506100', 'TITRES COTES', 'A', '', '', '');
    489. 

  489. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('506500', 'TITRES NON COTES', 'A', '', '', '');
    490. 

  490. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('507000', 'BONS TRESOR & BONS CAISSE A CT', 'A', '', '', '');
    491. 

  491. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('508000', 'AUTRES VALEURS MOB. ET CREANC. ASS', 'A', '', '', '');
    492. 

  492. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('508100', 'AUTRES VALEURS MOBILIERES', 'A', '', '', '');
    493. 

  493. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('508200', 'BONS DE SOUSCRIPTION', 'A', '', '', '');
    494. 

  494. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('508800', 'INTER. COURUS SUR OBLIGATIONS BONS', 'A', '', '', '');
    495. 

  495. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('509000', 'VERS. A EFFECT. SUR VALEURS MOBIL.', 'A', '', '', '');
    496. 

  496. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('511000', 'VALEURS A L\'ENCAISSEMENT', 'A', '', '', '');
    497. 

  497. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('511100', 'COUPONS ECHUS A L\'ENCAISSEMENT', 'A', '', '', '');
    498. 

  498. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('511200', 'CHEQUES A ENCAISSER', 'A', '', '', '');
    499. 

  499. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('511300', 'EFFETS A L\'ENCAISSEMENT', 'A', '', '', '');
    500. 

  500. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('511400', 'EFFETS A L\'ESCOMPTE', 'A', '', '', '');
    501. 

  501. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('512100', 'COMPTES EN MONNAIE NATIONALE', 'A', '', '', '');
    502. 

  502. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('512400', 'COMPTES EN DEVISES', 'A', '', '', '');
    503. 

  503. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('514000', 'CHEQUES POSTAUX', 'A', '', '', '');
    504. 

  504. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('515000', 'CAISSES DU TRESOR ET ETS PUBLICS', 'A', '', '', '');
    505. 

  505. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('516000', 'SOCIETE DE BOURSE', 'A', '', '', '');
    506. 

  506. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('517000', 'AUTRES ORGANISMES FINANCIERS', 'A', '', '', '');
    507. 

  507. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('518000', 'INTERETS EN COURS', 'A', '', '', '');
    508. 

  508. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('518600', 'INTERETS COURUS A PAYER', 'A', '', '', '');
    509. 

  509. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('518700', 'INTERETS COURUS A RECEVOIR', 'A', '', '', '');
    510. 

  510. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('519000', 'CONCOURS BANCAIRES COURANTS', 'A', '', '', '');
    511. 

  511. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('519100', 'CREDIT MOBIL. CREANC. CCIALES CMCC', 'A', '', '', '');
    512. 

  512. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('519300', 'MOBIL. CREANCES NEES A L\'ETRANGER', 'A', '', '', '');
    513. 

  513. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('519800', 'INT. COURUS SUR CONCOURS BANCAIRES', 'A', '', '', '');
    514. 

  514. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('520000', 'INSTRUMENTS DE TRESORERIE', 'A', '', '', '');
    515. 

  515. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('531000', 'CAISSE SIEGE SOCIAL', 'A', '', '', '');
    516. 

  516. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('531100', 'CAISSE EN MONNAIE NATIONALE', 'A', '', '', '');
    517. 

  517. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('531400', 'CAISSE EN DEVISES', 'A', '', '', '');
    518. 

  518. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('532000', 'CAISSE SUCCURSALE (OU USINE) A', 'A', '', '', '');
    519. 

  519. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('533000', 'CAISSE SUCCURSALE (OU USINE) B', 'A', '', '', '');
    520. 

  520. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('580100', 'VIREMENT DE TRESORERIE A TRESORERIE', 'A', '', '', '');
    521. 

  521. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('590000', 'PROVIS. POUR DEPREC. VALEURS MOB.', 'A', '', '', '');
    522. 

  522. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('590300', 'ACTIONS', 'A', '', '', '');
    523. 

  523. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('590400', 'AUTRES TIT. CONFERANT DROIT PROP.', 'A', '', '', '');
    524. 

  524. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('590600', 'OBLIGATIONS', 'A', '', '', '');
    525. 

  525. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('590800', 'AUTRES VALEURS MOB. & CREANC. ASS.', 'A', '', '', '');
    526. 

  526. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('601100', 'MATIERE (OU GROUPE) A', 'A', '', '', '');
    527. 

  527. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('601200', 'MATIERE (OU GROUPE) B', 'A', '', '', '');
    528. 

  528. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('601700', 'FOURNITURES A, B, C...', 'A', '', '', '');
    529. 

  529. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602000', 'ACHATS STOCKES AUTRES APPROV.', 'A', '', '', '');
    530. 

  530. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602100', 'MATIERES CONSOMMABLES', 'A', '', '', '');
    531. 

  531. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602110', 'MATIERE (OU GROUPE) C', 'A', '', '', '');
    532. 

  532. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602120', 'MATIERE (OU GROUPE) D', 'A', '', '', '');
    533. 

  533. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602200', 'FOURNITURES CONSOMMABLES', 'A', '', '', '');
    534. 

  534. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602210', 'COMBUSTIBLES', 'A', '', '', '');
    535. 

  535. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602220', 'PRODUITS D\'ENTRETIEN', 'A', '', '', '');
    536. 

  536. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602230', 'FOURNITURES D\'ATELIER / USINES', 'A', '', '', '');
    537. 

  537. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602240', 'FOURNITURES DE MAGASINS', 'A', '', '', '');
    538. 

  538. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602250', 'FOURNITURES DE BUREAU', 'A', '', '', '');
    539. 

  539. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602600', 'EMBALLAGES', 'A', '', '', '');
    540. 

  540. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602610', 'EMBALLAGES PERDUS', 'A', '', '', '');
    541. 

  541. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602650', 'EMBALL. RECUPERA. NON IDENTIF.', 'A', '', '', '');
    542. 

  542. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('602670', 'EMBALLAGES A USAGE MIXTE', 'A', '', '', '');
    543. 

  543. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('603000', 'VARIATION DES STOCKS', 'A', '', '', '');
    544. 

  544. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('603100', 'VARIAT. STOCKS MAT. PREM. ET FOURN', 'A', '', '', '');
    545. 

  545. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('603200', 'VARIAT. STOCKS AUTRES APPROVISION.', 'A', '', '', '');
    546. 

  546. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('603700', 'VARIATION STOCKS DE MARCHANDISES', 'A', '', '', '');
    547. 

  547. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('604000', 'ACHATS ETUDES ET PRESTAT. SERVICES', 'A', '', '', '');
    548. 

  548. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('605000', 'ACHATS MATERIEL EQUIPEM. TRAVAUX', 'A', '', '', '');
    549. 

  549. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('606000', 'ACHATS NON STOCKES DE MAT. PREM.', 'A', '', '', '');
    550. 

  550. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('606400', 'FOURNITURES ADMINISTRATIVES', 'A', '', '', '');
    551. 

  551. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('606500', 'ACHATS SPECIAUX', 'A', '', '', '');
    552. 

  552. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('606800', 'AUTRES MATIERES ET FOURNITURES', 'A', '', '', '');
    553. 

  553. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('607100', 'MARCHANDISE (OU GROUPE) A', 'A', '', '', '');
    554. 

  554. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('607200', 'MARCHANDISE (OU GROUPE) B', 'A', '', '', '');
    555. 

  555. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('608000', 'FRAIS ACCESSOIRES D\'ACHAT', 'A', '', '', '');
    556. 

  556. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('609000', 'RABAIS REMISES RIST. SUR ACHATS', 'A', '', '', '');
    557. 

  557. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('609100', 'DE MATIERES PREMIERES (ET FOURN.)', 'A', '', '', '');
    558. 

  558. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('609200', 'D\'AUTRES APPROVISIONN. STOCKES', 'A', '', '', '');
    559. 

  559. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('609500', 'DE MATERIEL EQUIPEMENTS DE TRAVAUX', 'A', '', '', '');
    560. 

  560. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('609600', 'D\'APPROVISIONNEMENTS NON STOCKES', 'A', '', '', '');
    561. 

  561. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('609700', 'DE MARCHANDISES', 'A', '', '', '');
    562. 

  562. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('609800', 'RABAIS REMISES RIST. NON AFFECTES', 'A', '', '', '');
    563. 

  563. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('612000', 'REDEVANCES DE CREDIT-BAIL', 'A', '', '', '');
    564. 

  564. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('612200', 'CREDIT-BAIL MOBILIER', 'A', '', '', '');
    565. 

  565. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('612500', 'CREDIT-BAIL IMMOBILIER', 'A', '', '', '');
    566. 

  566. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('613000', 'LOCATIONS', 'A', '', '', '');
    567. 

  567. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('613600', 'MALIS SUR EMBALLAGES', 'A', '', '', '');
    568. 

  568. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('614000', 'CHARGES LOCATIVES & DE COPROPRIETE', 'A', '', '', '');
    569. 

  569. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('615200', 'SUR BIENS IMMOBILIERS', 'A', '', '', '');
    570. 

  570. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('615500', 'SUR BIENS MOBILIERS', 'A', '', '', '');
    571. 

  571. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('615600', 'MAINTENANCE', 'A', '', '', '');
    572. 

  572. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('616100', 'MULTIRISQUES', 'A', '', '', '');
    573. 

  573. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('616200', 'ASSUR. OBLIGAT. DOMMAGE-CONSTRUCT.', 'A', '', '', '');
    574. 

  574. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('616300', 'ASSURANCE-TRANSPORT', 'A', '', '', '');
    575. 

  575. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('616360', 'SUR ACHATS', 'A', '', '', '');
    576. 

  576. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('616370', 'SUR VENTES', 'A', '', '', '');
    577. 

  577. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('616380', 'SUR AUTRES BIENS', 'A', '', '', '');
    578. 

  578. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('616400', 'RISQUES D\'EXPLOITATION', 'A', '', '', '');
    579. 

  579. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('616500', 'INSOLVABILITE CLIENTS', 'A', '', '', '');
    580. 

  580. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('618000', 'DIVERS', 'A', '', '', '');
    581. 

  581. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('618100', 'DOCUMENTATION GENERALE', 'A', '', '', '');
    582. 

  582. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('618500', 'FRAIS DE COLLOQUES, SEMIN., CONFER', 'A', '', '', '');
    583. 

  583. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('619000', 'RABAIS REMISES RIST. SUR SERV. EXT', 'A', '', '', '');
    584. 

  584. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('621000', 'PERSONNEL EXTERIEUR A L\'ENTREPRISE', 'A', '', '', '');
    585. 

  585. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('621400', 'PERSONNEL DETACHE OU PRETE A L\'ETS', 'A', '', '', '');
    586. 

  586. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('622000', 'REMUNERAT. D\'INTERM. ET HONORAIRES', 'A', '', '', '');
    587. 

  587. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('622100', 'COMMISSIONS & COURTAGES SUR ACHATS', 'A', '', '', '');
    588. 

  588. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('622200', 'COMMISSIONS & COURTAGES SUR VENTES', 'A', '', '', '');
    589. 

  589. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('622400', 'REMUNERATIONS DES TRANSITAIRES', 'A', '', '', '');
    590. 

  590. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('622500', 'REMUNERATIONS D\'AFFACTURAGE', 'A', '', '', '');
    591. 

  591. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('622800', 'DIVERS', 'A', '', '', '');
    592. 

  592. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('623000', 'PUBLICITE PUBLICAT. RELAT. PUBLIQ.', 'A', '', '', '');
    593. 

  593. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('623100', 'ANNONCES ET INSERTIONS', 'A', '', '', '');
    594. 

  594. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('623200', 'ECHANTILLONS', 'A', '', '', '');
    595. 

  595. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('623300', 'FOIRES ET EXPOSITIONS', 'A', '', '', '');
    596. 

  596. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('623500', 'PRIMES', 'A', '', '', '');
    597. 

  597. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('623600', 'CATALOGUES ET IMPRIMES', 'A', '', '', '');
    598. 

  598. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('623700', 'PUBLICATIONS', 'A', '', '', '');
    599. 

  599. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('623800', 'DIVERS (POURBOIRES, DONS COURANTS)', 'A', '', '', '');
    600. 

  600. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('624000', 'TRANSP. BIENS & TRANSP. COLL. PERS', 'A', '', '', '');
    601. 

  601. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('624100', 'TRANSPORTS SUR ACHATS', 'A', '', '', '');
    602. 

  602. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('624200', 'TRANSPORTS SUR VENTES', 'A', '', '', '');
    603. 

  603. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('624300', 'TRANSPORTS ENTRE ETS OU CHANTIERS', 'A', '', '', '');
    604. 

  604. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('624400', 'TRANSPORTS ADMINISTRATIFS', 'A', '', '', '');
    605. 

  605. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('624700', 'TRANSPORTS COLLECTIFS DU PERSONNEL', 'A', '', '', '');
    606. 

  606. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('624800', 'DIVERS', 'A', '', '', '');
    607. 

  607. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('625000', 'DEPLACEM. MISSIONS ET RECEPTIONS', 'A', '', '', '');
    608. 

  608. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('625500', 'FRAIS DE DEMENAGEMENT', 'A', '', '', '');
    609. 

  609. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('625700', 'RECEPTIONS', 'A', '', '', '');
    610. 

  610. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('627000', 'SERVICES BANCAIRES ET ASSIMILES', 'A', '', '', '');
    611. 

  611. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('627100', 'FRAIS SUR TITRES (ACHAT, VENTE,.).', 'A', '', '', '');
    612. 

  612. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('627200', 'COMMISSIONS & FRAIS SUR EMPRUNTS', 'A', '', '', '');
    613. 

  613. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('627500', 'FRAIS SUR EFFETS (COMM. D\'ENDOS,.)', 'A', '', '', '');
    614. 

  614. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('627600', 'LOCATION DE COFFRES', 'A', '', '', '');
    615. 

  615. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('627800', 'AUTRES FRAIS & COMM. PREST. SERV.', 'A', '', '', '');
    616. 

  616. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('628000', 'DIVERS', 'A', '', '', '');
    617. 

  617. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('628400', 'FRAIS DE RECRUTEMENT DU PERSONNEL', 'A', '', '', '');
    618. 

  618. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('629000', 'RABAIS REMISES RIST. SUR SERV. EXT', 'A', '', '', '');
    619. 

  619. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('631000', 'IMPOTS TAXES & VERS. SUR REMUNER.', 'A', '', '', '');
    620. 

  620. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('631100', 'TAXE SUR LES SALAIRES', 'A', '', '', '');
    621. 

  621. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('631200', 'TAXE D\'APPRENTISSAGE', 'A', '', '', '');
    622. 

  622. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('631300', 'PART. EMPLOY. A FORM. PROF. CONT.', 'A', '', '', '');
    623. 

  623. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('631400', 'COTIS. DEFAUT INVEST. DANS CONST.', 'A', '', '', '');
    624. 

  624. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('631800', 'AUTRES', 'A', '', '', '');
    625. 

  625. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('633000', 'IMPOTS TAXES & VERS. SUR REMUNER.', 'A', '', '', '');
    626. 

  626. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('633100', 'VERSEMENT SUR LE TRANSPORT', 'A', '', '', '');
    627. 

  627. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('633200', 'ALLOCATION LOGEMENT', 'A', '', '', '');
    628. 

  628. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('633300', 'PART. EMPLOY. A FORM.  PROF. CONT.', 'A', '', '', '');
    629. 

  629. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('633400', 'PART. EMPLOY. A EFFORT CONSTRUCT.', 'A', '', '', '');
    630. 

  630. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('633500', 'VERS. LIBERAT. A EXONER. TAXE APP.', 'A', '', '', '');
    631. 

  631. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('635000', 'AUTRES IMPOTS TAXES & VERS. ASS.', 'A', '', '', '');
    632. 

  632. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('635100', 'IMPOTS DIRECTS (SAUF IMPOT BENEF.)', 'A', '', '', '');
    633. 

  633. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('635120', 'TAXES FONCIERES', 'A', '', '', '');
    634. 

  634. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('635130', 'AUTRES IMPOTS LOCAUX', 'A', '', '', '');
    635. 

  635. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('635140', 'TAXE SUR LES VEHICULES SOCIETES', 'A', '', '', '');
    636. 

  636. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('635200', 'TAXES SUR CA NON RECUPERABLES', 'A', '', '', '');
    637. 

  637. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('635300', 'IMPOTS INDIRECTS', 'A', '', '', '');
    638. 

  638. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('635400', 'DROITS D\'ENREGISTREMENT ET TIMBRE', 'A', '', '', '');
    639. 

  639. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('635410', 'DROIT DE MUTATION', 'A', '', '', '');
    640. 

  640. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('635800', 'AUTRES DROITS', 'A', '', '', '');
    641. 

  641. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('637000', 'AUTRES IMPOTS TAXES ET VERS. ASS.', 'A', '', '', '');
    642. 

  642. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('637100', 'CONTRIB. SOC. SOLID. A CHARGE STES', 'A', '', '', '');
    643. 

  643. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('637200', 'TAXES PERCUES PAR ORG. PUBLICS INT', 'A', '', '', '');
    644. 

  644. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('637400', 'IMPOTS & TAXES EXIGIB. A L\'ETRANG.', 'A', '', '', '');
    645. 

  645. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('637800', 'TAXES DIVERSES', 'A', '', '', '');
    646. 

  646. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('641100', 'SALAIRES APPOINT. COMMIS. DE BASE', 'A', '', '', '');
    647. 

  647. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('641200', 'CONGES PAYES', 'A', '', '', '');
    648. 

  648. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('641300', 'PRIMES ET GRATIFICATIONS', 'A', '', '', '');
    649. 

  649. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('641400', 'SALAIRES, APPOINTEMENTS', 'A', '', '', '');
    650. 

  650. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('641500', 'SUPPLEMENT FAMILIAL', 'A', '', '', '');
    651. 

  651. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('644000', 'REMUNERATION TRAVAIL DE L\'EXPLOIT.', 'A', '', '', '');
    652. 

  652. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('647000', 'AUTRES CHARGES SOCIALES', 'A', '', '', '');
    653. 

  653. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('647100', 'PRESTATIONS DIRECTES', 'A', '', '', '');
    654. 

  654. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('647200', 'VERS. AUX COMITES D\'ETS & D\'ETAB.', 'A', '', '', '');
    655. 

  655. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('647300', 'VERS. AUX COMITES HYGIENE ET SECUR', 'A', '', '', '');
    656. 

  656. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('647400', 'VERSEMENTS AUX OEUVRES SOCIALES', 'A', '', '', '');
    657. 

  657. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('647500', 'MEDECINE DU TRAVAIL, PHARMACIE', 'A', '', '', '');
    658. 

  658. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('648000', 'AUTRES CHARGES DE PERSONNEL', 'A', '', '', '');
    659. 

  659. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('651000', 'REDEVANC. CONCESS. BREV. LICENC,..', 'A', '', '', '');
    660. 

  660. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('651100', 'REDEV. CONCESS. BREV, LIC, MARQ,..', 'A', '', '', '');
    661. 

  661. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('651600', 'DROITS D\'AUTEUR ET DE REPRODUCT.', 'A', '', '', '');
    662. 

  662. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('651800', 'AUTRES DROITS & VALEURS SIMILAIRES', 'A', '', '', '');
    663. 

  663. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('653000', 'JETONS DE PRESENCE', 'A', '', '', '');
    664. 

  664. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('654000', 'PERTES SUR CREANCES IRRECOUVRAB.', 'A', '', '', '');
    665. 

  665. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('654100', 'CREANCES DE L\'EXERCICE', 'A', '', '', '');
    666. 

  666. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('654400', 'CREANCES DES EXERCICES ANTERIEURS', 'A', '', '', '');
    667. 

  667. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('655000', 'QUOTE-PARTS RESULT. OPER. EN COMM.', 'A', '', '', '');
    668. 

  668. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('655100', 'Q-P BENEF. TRANSF. (CPTA GERANT)', 'A', '', '', '');
    669. 

  669. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('655500', 'QUOTE-PART PERTE SUPP. (CPTA ASS)', 'A', '', '', '');
    670. 

  670. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('658000', 'CHARGES DIVERSES GESTION COURANTE', 'A', '', '', '');
    671. 

  671. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('661000', 'CHARGES D\'INTERETS', 'A', '', '', '');
    672. 

  672. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('661100', 'INTERETS DES EMPRUNTS ET DETTES', 'A', '', '', '');
    673. 

  673. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('661160', 'DES EMPRUNTS ET DETTES ASSIMILEES', 'A', '', '', '');
    674. 

  674. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('661170', 'DES DETTES RATT. A PARTICIPATIONS', 'A', '', '', '');
    675. 

  675. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('661500', 'INTERETS CPTES COUR. & DEP. CREDIT', 'A', '', '', '');
    676. 

  676. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('661600', 'INTERETS BANC. & SUR OPER. FINANC.', 'A', '', '', '');
    677. 

  677. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('661700', 'INTERETS OBLIGATIONS CAUTIONNEES', 'A', '', '', '');
    678. 

  678. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('661800', 'INTERETS DES AUTRES DETTES', 'A', '', '', '');
    679. 

  679. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('661810', 'DES DETTES COMMERCIALES', 'A', '', '', '');
    680. 

  680. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('661880', 'DES DETTES DIVERSES', 'A', '', '', '');
    681. 

  681. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('664000', 'PERTES CREANCES LIEES A PARTICIP.', 'A', '', '', '');
    682. 

  682. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('665000', 'ESCOMPTES ACCORDES', 'A', '', '', '');
    683. 

  683. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('667000', 'CHARG. NETTES SUR CESS. VAL. MOBIL', 'A', '', '', '');
    684. 

  684. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('668000', 'AUTRES CHARGES FINANCIERES', 'A', '', '', '');
    685. 

  685. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('668800', 'ECART DE CONVERSION', 'A', '', '', '');
    686. 

  686. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('671000', 'CHARG. EXCEPT. SUR OPERAT. GESTION', 'A', '', '', '');
    687. 

  687. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('671100', 'PENALITES SUR MARCHES', 'A', '', '', '');
    688. 

  688. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('671200', 'PENALITES AMENDES FISC. & PENALES', 'A', '', '', '');
    689. 

  689. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('671300', 'DONS, LIBERALITES', 'A', '', '', '');
    690. 

  690. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('671400', 'CREANC. DEVEN. IRRECOUV. SUR BENEF', 'A', '', '', '');
    691. 

  691. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('671500', 'SUBVENTIONS ACCORDEES', 'A', '', '', '');
    692. 

  692. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('671700', 'RAPPEL D\'IMPOTS (AUTRE QUE BENEF)', 'A', '', '', '');
    693. 

  693. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('671800', 'AUT. CHARG. EXCEP. SUR OPER. GEST.', 'A', '', '', '');
    694. 

  694. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('672000', 'CHARGES SUR EXERCICES ANTERIEURS', 'A', '', '', '');
    695. 

  695. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('675000', 'VAL. COMPT. DES ELEM. ACTIF CEDES', 'A', '', '', '');
    696. 

  696. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('675100', 'IMMOBILISATIONS INCORPORELLES', 'A', '', '', '');
    697. 

  697. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('675200', 'IMMOBILISATIONS CORPORELLES', 'A', '', '', '');
    698. 

  698. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('675600', 'IMMOBILISATIONS FINANCIERES', 'A', '', '', '');
    699. 

  699. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('675800', 'AUTRES ELEMENTS D\'ACTIF', 'A', '', '', '');
    700. 

  700. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('678000', 'AUTRES CHARGES EXCEPTIONNELLES', 'A', '', '', '');
    701. 

  701. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('678100', 'MALIS PROVENANT DE CLAUSES INDEXAT', 'A', '', '', '');
    702. 

  702. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('678200', 'LOTS', 'A', '', '', '');
    703. 

  703. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('678300', 'MALIS DU RACHAT PAR ETS D\'ACTIONS', 'A', '', '', '');
    704. 

  704. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('678800', 'CHARGES EXCEPTIONNELLES DIVERSES', 'A', '', '', '');
    705. 

  705. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681100', 'DOTAT. AUX AMORT. DES IMMOB. CORPO', 'A', '', '', '');
    706. 

  706. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681110', 'IMMOBILISATIONS INCORPORELLES', 'A', '', '', '');
    707. 

  707. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681120', 'IMMOBILISATIONS CORPORELLES', 'A', '', '', '');
    708. 

  708. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681200', 'DOTAT. AUX AMORT. CHARG. EXPLOIT.', 'A', '', '', '');
    709. 

  709. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681500', 'DOTAT. AUX PROV. RISQ. & CHARG. EX', 'A', '', '', '');
    710. 

  710. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681600', 'DOTAT. AUX PROV. DEPREC. IMMOB.', 'A', '', '', '');
    711. 

  711. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681610', 'IMMOBILISATIONS INCORPORELLES', 'A', '', '', '');
    712. 

  712. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681620', 'IMMOBILISATIONS CORPORELLES', 'A', '', '', '');
    713. 

  713. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681700', 'DOTAT. AUX PROV. DEPREC. ACTIFS', 'A', '', '', '');
    714. 

  714. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681740', 'CREANCES', 'A', '', '', '');
    715. 

  715. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('686000', 'DOTAT. AUX AMORT. ET AUX PROVIS.', 'A', '', '', '');
    716. 

  716. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('686100', 'DOT. AUX AMORT. PRIME REMB. OBLIG.', 'A', '', '', '');
    717. 

  717. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('686500', 'DOT. AUX PROV. RISQ. & CHARG. FIN.', 'A', '', '', '');
    718. 

  718. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('686600', 'DOT. AUX PROV. DEPREC. ELEM. FINAN', 'A', '', '', '');
    719. 

  719. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('686620', 'IMMOBILISATIONS FINANCIERES', 'A', '', '', '');
    720. 

  720. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('686650', 'VALEURS MOBILIERES DE PLACEMENT', 'A', '', '', '');
    721. 

  721. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('686800', 'AUTRES DOTATIONS', 'A', '', '', '');
    722. 

  722. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('687000', 'DOTAT. AUX AMORT. ET PROVISIONS', 'A', '', '', '');
    723. 

  723. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('687100', 'DOTAT. AUX AMORT. EXCEPT. IMMOB.', 'A', '', '', '');
    724. 

  724. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('687200', 'DOTAT. AUX PROV. REGLEM. (IMMOB)', 'A', '', '', '');
    725. 

  725. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('687250', 'AMORTISSEMENTS DEROGATOIRES', 'A', '', '', '');
    726. 

  726. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('687300', 'DOTAT. AUX PROV. REGLEM. (STOCKS)', 'A', '', '', '');
    727. 

  727. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('687400', 'DOTAT. AUX AUTRES PROV. REGLEMENT.', 'A', '', '', '');
    728. 

  728. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('687500', 'DOTAT. PROV. RISQ. & CHARG. EXCEP.', 'A', '', '', '');
    729. 

  729. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('691000', 'PARTICIPATIONS DES SALARIES', 'A', '', '', '');
    730. 

  730. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('695200', 'CONTRIB. ADDITIO. IMPOT BENEFICES', 'A', '', '', '');
    731. 

  731. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('695400', 'IMPOTS DUS A L\'ETRANGER', 'A', '', '', '');
    732. 

  732. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('696000', 'SUPPLEMENT D\'IMPOTS', 'A', '', '', '');
    733. 

  733. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('697000', 'IMPOSITION FORF. ANUELLE', 'A', '', '', '');
    734. 

  734. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('698000', 'INTEGRATION FISCALE', 'A', '', '', '');
    735. 

  735. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('698100', 'INTEGRATION FISCALE - CHARGES', 'A', '', '', '');
    736. 

  736. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('698900', 'INTEGRATION FISCALE - PRODUITS', 'A', '', '', '');
    737. 

  737. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('699000', 'PRODUITS REP. EN ARR. DES DEFICITS', 'A', '', '', '');
    738. 

  738. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('701000', 'VENTES DE PRODUITS FINIS', 'A', '', '', '');
    739. 

  739. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('701100', 'PRODUIT FINI (OU GROUPE) A', 'A', '', '', '');
    740. 

  740. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('701200', 'PRODUIT FINI (OU GROUPE) B', 'A', '', '', '');
    741. 

  741. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('702000', 'VENTES DE PRODUITS INTERMEDIAIRES', 'A', '', '', '');
    742. 

  742. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('703000', 'VENTES DE PRODUITS RESIDUELS', 'A', '', '', '');
    743. 

  743. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('704000', 'TRAVAUX', 'A', '', '', '');
    744. 

  744. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('704100', 'TRAVAUX DE CATEG. (OU ACTIV.) A', 'A', '', '', '');
    745. 

  745. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('704200', 'TRAVAUX DE CATEG. (OU ACTIV.) B', 'A', '', '', '');
    746. 

  746. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('705000', 'ETUDES', 'A', '', '', '');
    747. 

  747. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('707100', 'MARCHANDISE (OU GROUPE) A', 'A', '', '', '');
    748. 

  748. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('707200', 'MARCHANDISE (OU GROUPE) B', 'A', '', '', '');
    749. 

  749. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('708000', 'PRODUITS DES ACTIVITES ANNEXES', 'A', '', '', '');
    750. 

  750. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('708100', 'PROD. SERV. EXPLOIT. INTER. PERSON', 'A', '', '', '');
    751. 

  751. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('708200', 'COMMISSIONS ET COURTAGES', 'A', '', '', '');
    752. 

  752. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('708300', 'LOCATIONS DIVERSES', 'A', '', '', '');
    753. 

  753. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('708400', 'MISE A DISPOS. PERSONNEL FACTUREE', 'A', '', '', '');
    754. 

  754. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('708500', 'PORTS ET FRAIS ACCESSOIRES FACT.', 'A', '', '', '');
    755. 

  755. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('708600', 'BONIS SUR REPRISES EMBALL. CONSIG.', 'A', '', '', '');
    756. 

  756. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('708700', 'BONIFICAT. CLTS & PRIMES VENTES', 'A', '', '', '');
    757. 

  757. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('708800', 'AUTRES PRODUITS ACTIVITES ANNEXES', 'A', '', '', '');
    758. 

  758. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('709000', 'RABAIS REMISES RIST. ACCORD. A ETS', 'A', '', '', '');
    759. 

  759. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('709100', 'SUR VENTES DE PRODUITS FINIS', 'A', '', '', '');
    760. 

  760. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('709200', 'SUR VENTES PRODUITS INTERMEDIAIRES', 'A', '', '', '');
    761. 

  761. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('709400', 'SUR TRAVAUX', 'A', '', '', '');
    762. 

  762. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('709500', 'SUR ETUDES', 'A', '', '', '');
    763. 

  763. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('709600', 'SUR PRESTATIONS DE SERVICES', 'A', '', '', '');
    764. 

  764. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('709700', 'SUR VENTES MARCHANDISES', 'A', '', '', '');
    765. 

  765. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('709800', 'SUR PRODUITS ACTIVITES ANNEXES', 'A', '', '', '');
    766. 

  766. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('713000', 'VARIAT. STOCKS (EN-COURS PRODUCT.)', 'A', '', '', '');
    767. 

  767. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('713300', 'VARIATION EN-COURS PRODUC. BIENS', 'A', '', '', '');
    768. 

  768. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('713310', 'PRODUITS EN COURS', 'A', '', '', '');
    769. 

  769. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('713350', 'TRAVAUX EN COURS', 'A', '', '', '');
    770. 

  770. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('713400', 'VARIATION EN-COURS PROD. SERVICES', 'A', '', '', '');
    771. 

  771. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('713410', 'ETUDES EN COURS', 'A', '', '', '');
    772. 

  772. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('713450', 'PRESTATIONS SERVICES EN COURS', 'A', '', '', '');
    773. 

  773. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('713500', 'VARIATION STOCKS DE PRODUITS', 'A', '', '', '');
    774. 

  774. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('713510', 'PRODUITS INTERMEDIAIRES', 'A', '', '', '');
    775. 

  775. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('713550', 'PRODUITS FINIS', 'A', '', '', '');
    776. 

  776. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('713580', 'PRODUITS RESIDUELS', 'A', '', '', '');
    777. 

  777. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('721000', 'IMMOBILISATIONS INCORPORELLES', 'A', '', '', '');
    778. 

  778. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('722000', 'IMMOBILISATIONS CORPORELLES', 'A', '', '', '');
    779. 

  779. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('731000', 'PROD. NETS PART. SUR OP. EN COURS', 'A', '', '', '');
    780. 

  780. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('739000', 'PROD. NETS PART. SUR OP. TERMINEES', 'A', '', '', '');
    781. 

  781. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('751000', 'REDEV. POUR CONCES. BREV. LIC....', 'A', '', '', '');
    782. 

  782. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('751100', 'REDEV. POUR CONCES. BREV. LIC...', 'A', '', '', '');
    783. 

  783. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('751600', 'DROITS D\'AUTEUR ET DE REPRODUCTION', 'A', '', '', '');
    784. 

  784. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('751800', 'AUTRES DROITS & VALEURS SIMILAIRES', 'A', '', '', '');
    785. 

  785. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('752000', 'REV. IMMEUB. NON AFFECT. ACT. PROF', 'A', '', '', '');
    786. 

  786. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('753000', 'JETONS PRESENCE ET REMUN. ADMINIST', 'A', '', '', '');
    787. 

  787. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('754000', 'RISTOURNES PERCUES COOPERATIVES', 'A', '', '', '');
    788. 

  788. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('755000', 'QUOTES-PARTS RESULT. OP. EN COMMUN', 'A', '', '', '');
    789. 

  789. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('755100', 'QUOTE-PART PERTE TRANSFEREE', 'A', '', '', '');
    790. 

  790. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('755500', 'QUOTE-PART BENEFICE ATTRIBUEE', 'A', '', '', '');
    791. 

  791. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('758000', 'PRODUITS DIVERS GESTION COURANTE', 'A', '', '', '');
    792. 

  792. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('761000', 'PRODUITS DE PARTICIPATIONS', 'A', '', '', '');
    793. 

  793. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('761100', 'REVENUS TITRES DE PARTICIPATION', 'A', '', '', '');
    794. 

  794. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('761600', 'REVENUS AUTRES FORMES PARTICIP.', 'A', '', '', '');
    795. 

  795. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('762000', 'PRODUITS AUTRES IMMOB. FINANC.', 'A', '', '', '');
    796. 

  796. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('762100', 'REVENUS DES TITRES IMMOBILISES', 'A', '', '', '');
    797. 

  797. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('762400', 'REVENUS DES PRETS', 'A', '', '', '');
    798. 

  798. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('762700', 'REVENUS CREANCES IMMOBILISEES', 'A', '', '', '');
    799. 

  799. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('763000', 'REVENUS DES AUTRES CREANCES', 'A', '', '', '');
    800. 

  800. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('763100', 'REVENUS CREANCES COMMERCIALES', 'A', '', '', '');
    801. 

  801. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('763800', 'REVENUS DES CREANCES DIVERSES', 'A', '', '', '');
    802. 

  802. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('764000', 'REVENUS VALEURS MOBIL. PLACEMENT', 'A', '', '', '');
    803. 

  803. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('765000', 'ESCOMPTES OBTENUS', 'A', '', '', '');
    804. 

  804. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('767000', 'PROD. NETS SUR CESS. VALEURS MOB.', 'A', '', '', '');
    805. 

  805. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('767100', 'REVENUS CRE. RATT. PARTICIPATIONS', 'A', '', '', '');
    806. 

  806. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('768000', 'AUTRES PRODUITS FINANCIERS', 'A', '', '', '');
    807. 

  807. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('771000', 'PRODUITS EXCEPT. SUR OPER. GESTION', 'A', '', '', '');
    808. 

  808. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('771100', 'DEDITS PENAL. SUR ACHATS & VENTES', 'A', '', '', '');
    809. 

  809. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('771300', 'LIBERALITES PERCUES', 'A', '', '', '');
    810. 

  810. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('771400', 'RENTREES SUR CREANCES AMORTIES', 'A', '', '', '');
    811. 

  811. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('771500', 'SUBVENTIONS D\'EQUILIBRE', 'A', '', '', '');
    812. 

  812. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('771700', 'DEGREVEM. IMPOTS (AUT. IMP. BENEF)', 'A', '', '', '');
    813. 

  813. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('771800', 'AUTRES PROD. EXCEPT. SUR OP. GEST.', 'A', '', '', '');
    814. 

  814. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('772000', 'PRODUITS SUR EXERCICES ANTERIEURS', 'A', '', '', '');
    815. 

  815. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('775000', 'PRODUITS CESSIONS ELEMENTS D\'ACTIF', 'A', '', '', '');
    816. 

  816. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('775100', 'IMMOBILISATIONS INCORPORELLES', 'A', '', '', '');
    817. 

  817. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('775200', 'IMMOBILISATIONS CORPORELLES', 'A', '', '', '');
    818. 

  818. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('775600', 'IMMOBILISATIONS FINANCIERES', 'A', '', '', '');
    819. 

  819. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('775800', 'AUTRES ELEMENTS D\'ACTIF', 'A', '', '', '');
    820. 

  820. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('777000', 'Q-P SUBV. INVEST. AU RESULT. EXERC', 'A', '', '', '');
    821. 

  821. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('778000', 'AUTRES PRODUITS EXCEPTIONNELS', 'A', '', '', '');
    822. 

  822. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('778100', 'BONIS PROVENANT CLAUSES D\'INDEXAT.', 'A', '', '', '');
    823. 

  823. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('778200', 'LOTS', 'A', '', '', '');
    824. 

  824. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('778300', 'BONIS RACHAT PAR ETS ACT. & OBLIG.', 'A', '', '', '');
    825. 

  825. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('778800', 'PRODUITS EXCEPTIONNELS DIVERS', 'A', '', '', '');
    826. 

  826. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('781000', 'REPRISES SUR AMORTISS. & PROVIS.', 'A', '', '', '');
    827. 

  827. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('781100', 'REPRIS. AMORT. IMMOB. CORP. & INC', 'A', '', '', '');
    828. 

  828. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('781110', 'IMMOBILISATIONS INCORPORELLES', 'A', '', '', '');
    829. 

  829. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('781120', 'IMMOBILISATIONS CORPORELLES', 'A', '', '', '');
    830. 

  830. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('781500', 'REPRIS. PROVIS. RISQ. & CH. EXPLOI', 'A', '', '', '');
    831. 

  831. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('781600', 'REP. PROV. DEPREC. IMM. CORP & INC', 'A', '', '', '');
    832. 

  832. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('781610', 'IMMOBILISATIONS INCORPORELLES', 'A', '', '', '');
    833. 

  833. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('781620', 'IMMOBILISATIONS CORPORELLES', 'A', '', '', '');
    834. 

  834. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('781700', 'REPRIS. PROV. DEPREC. ACT. CIRCUL.', 'A', '', '', '');
    835. 

  835. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('781730', 'STOCKS ET EN-COURS', 'A', '', '', '');
    836. 

  836. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('781740', 'CREANCES', 'A', '', '', '');
    837. 

  837. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('786000', 'REPRISES SUR PROVIS. POUR RISQUES', 'A', '', '', '');
    838. 

  838. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('786500', 'REP. PROV. RISQ. & CHARG. FINANC.', 'A', '', '', '');
    839. 

  839. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('786600', 'REPRIS. PROV. DEPREC. ELEM. FINANC', 'A', '', '', '');
    840. 

  840. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('786620', 'IMMOBILISATIONS FINANCIERES', 'A', '', '', '');
    841. 

  841. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('786650', 'VALEURS MOBILIERES DE PLACEMENT', 'A', '', '', '');
    842. 

  842. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('787000', 'REPRISES SUR PROVISIONS', 'A', '', '', '');
    843. 

  843. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('787200', 'REPRISES SUR PROV. REGLEMENTEES', 'A', '', '', '');
    844. 

  844. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('787250', 'AMORTISSEMENTS DEROGATOIRES', 'A', '', '', '');
    845. 

  845. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('787260', 'PROVISION SPECIALE DE REEVALUATION', 'A', '', '', '');
    846. 

  846. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('787270', 'PLUS-VALUES REINVESTIES', 'A', '', '', '');
    847. 

  847. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('787300', 'REPRISES SUR PROV. REGLEMENTEES', 'A', '', '', '');
    848. 

  848. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('787400', 'REPRIS. SUR AUTRES PROV. REGLEMENT', 'A', '', '', '');
    849. 

  849. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('787500', 'REPRIS. PROV. RISQ. & CHARG. EXPL.', 'A', '', '', '');
    850. 

  850. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('787600', 'REPRIS. PROV. POUR DEPREC. EXCEPT.', 'A', '', '', '');
    851. 

  851. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('791000', 'TRANSFERTS DE CHARGES D\'EXPLOIT.', 'A', '', '', '');
    852. 

  852. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('796000', 'TRANSFERTS DE CHARGES FINANC.', 'A', '', '', '');
    853. 

  853. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('797000', 'TRANSFERTS DE CHARGES EXCEPT.', 'A', '', '', '');
    854. 

  854. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('201000', 'FRAIS D\'ETABLISSEMENT', 'A', '', 'E', '');
    855. 

  855. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('209000', 'SORTIE D\'IMMOBILISATION', 'A', '', 'I', '');
    856. 

  856. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('474100', 'DIVERS A REINTEGRER', 'A', '', 'I', '');
    857. 

  857. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('474200', 'BENEFICE SCM', 'A', '', 'I', '');
    858. 

  858. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('475000', 'PLUS VALUES A COURT TERME', 'A', '', 'I', '');
    859. 

  859. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('530000', 'CAISSE', 'A', '', 'I', '');
    860. 

  860. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('760000', 'PRODUITS FINANCIERS', 'A', '', 'I', 'AR_amount');
    861. 

  861. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('770000', 'PRODUITS EXCEPTIONNELS', 'A', '', 'I', 'AR_amount');
    862. 

  862. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('530010', 'CAISSE', 'A', '', 'E', 'AP_amount');
    863. 

  863. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('607000', 'ACHATS DE MARCHANDISES', 'A', '', 'E', 'AP_amount');
    864. 

  864. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('622700', 'FRAIS D\'ACTES ET DE CONTENTIEUX', 'A', '', 'E', 'AP_amount');
    865. 

  865. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('438600', 'AUTRES CHARGES A PAYER', 'A', '', 'E', 'AP_amount');
    866. 

  866. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('473000', 'DIVERS A DEDUIRE', 'A', '', 'E', 'AP_amount');
    867. 

  867. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('613200', 'LOCATIONS IMMOBILIERES', 'A', '', 'E', 'AP_amount');
    868. 

  868. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('616000', 'PRIMES D\'ASSURANCE', 'A', '', 'E', 'AP_amount');
    869. 

  869. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('633800', 'AUTRES', 'A', '', 'E', 'AP_amount');
    870. 

  870. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('695000', 'IMPOTS SUR LES BENEFICES', 'A', '', 'E', 'AP_amount');
    871. 

  871. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('108100', 'COMPTE DE LEXPLOITANT', 'A', '', 'E', '');
    872. 

  872. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('512030', 'EPARGNE', 'A', '', 'A', 'AR_paid:AP_paid');
    873. 

  873. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('100000', 'CLASSE 1', 'H', '', '', '');
    874. 

  874. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('300000', 'CLASSE 3', 'H', '', '', '');
    875. 

  875. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('500000', 'CLASSE 5', 'H', '', '', '');
    876. 

  876. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('600000', 'CLASSE 6', 'H', '', '', '');
    877. 

  877. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('700000', 'CLASSE 7', 'H', '', '', '');
    878. 

  878. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('108000', 'COMPTE DE LEXPLOITANT', 'A', '', 'I', '');
    879. 

  879. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('200001', 'IMMOBILISATION', 'A', '', 'E', '');
    880. 

  880. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('200000', 'CLASSE 2', 'H', '', '', '');
    881. 

  881. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('400001', 'FOURNISSEURS ET COMPTES RATTACHES', 'A', '', '', '');
    882. 

  882. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('400000', 'CLASSE 4', 'H', '', '', '');
    883. 

  883. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('695100', 'IMPOTS DUS EN FRANCE', 'A', '', 'E', '');
    884. 

  884. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('646000', 'COTIS. SOCIAL. PERSON. EXPLOITANT', 'A', '', 'E', '');
    885. 

  885. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('645000', 'CHARGES DE SECUR. SOC. ET PREVOY.', 'A', '', 'E', '');
    886. 

  886. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('617000', 'ETUDES ET RECHERCHES', 'A', '', 'E', '');
    887. 

  887. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('615000', 'ENTRETIEN ET REPARATIONS', 'A', '', 'E', '');
    888. 

  888. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('613500', 'LOCATIONS MOBILIERES', 'A', '', 'E', '');
    889. 

  889. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('611000', 'SOUS-TRAITANCE GENERALE', 'A', '', 'E', '');
    890. 

  890. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('695500', 'DEBOURS PAYES POUR LE COMPTE', 'A', '', 'E', '');
    891. 

  891. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('690000', 'PARTICIP. SAL. / IMPOTS SUR BEN.', 'A', '', 'E', '');
    892. 

  892. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('687600', 'DOTAT. AUX PROV. DEPREC. EXCEPT.', 'A', '', 'E', '');
    893. 

  893. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681000', 'DOTATIONS AUX AMORT. & AUX PROVIS.', 'A', '', 'E', '');
    894. 

  894. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('628100', 'CONCOURS DIVERS (COTISATIONS,...)', 'A', '', 'E', '');
    895. 

  895. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('625600', 'MISSIONS', 'A', '', 'E', '');
    896. 

  896. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('645800', 'COTISATIONS AUX AUTRES ORG. SOC.', 'A', '', 'E', 'AP_amount');
    897. 

  897. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('641000', 'REMUNERATIONS DU PERSONNEL', 'A', '', '', '');
    898. 

  898. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('625020', 'DEPLACEMENTS MOTO', 'A', '', '', '');
    899. 

  899. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('622600', 'HONORAIRES', 'A', '', '', '');
    900. 

  900. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('621100', 'PERSONNEL INTERIMAIRE', 'A', '', '', '');
    901. 

  901. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445500', 'TAXES SUR CA A DECAISSER', 'A', '', '', '');
    902. 

  902. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('706000', 'PRESTATIONS DE SERVICES', 'A', '', 'I', 'IC_income');
    903. 

  903. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('707000', 'VENTES DE MARCHANDISES', 'A', '', 'I', 'IC_sale');
    904. 

  904. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445713', 'TVA COLLECTEE 19.6%', 'A', '', 'I', 'AR_tax:IC_taxpart:IC_taxservice');
    905. 

  905. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('512020', 'BANQUE DEBIT', 'A', '', 'E', 'AP');
    906. 

  906. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445711', 'TVA COLLECTEE  5.5%', 'A', '', 'I', 'AR_tax:IC_taxpart:IC_taxservice');
    907. 

  907. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445661', 'TVA DEDUCTIBLE  5.5%', 'A', '', 'E', 'AP_tax:IC_taxpart:IC_taxservice');
    908. 

  908. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('512010', 'BANQUE CREDIT', 'A', '', 'I', 'AR:AR_amount');
    909. 

  909. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('681730', 'STOCKS ET EN-COURS', 'A', '', 'A', 'IC');
    910. 

  910. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('580010', 'VIREMENT INTERNE', 'A', '', 'E', '');
    911. 

  911. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('580000', 'VIREMENT INTERNE', 'A', '', 'E', 'AP_amount');
    912. 

  912. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('766000', 'GAINS DE CHANGE', 'A', '', 'I', 'AR_amount:IC_income');
    913. 

  913. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('472000', 'MOINS VALUES A COURT TERME', 'A', '', 'E', '');
    914. 

  914. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('474000', 'DEFICIT SCM', 'A', '', 'E', '');
    915. 

  915. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('670000', 'CHARGES FINANCIERES', 'A', '', 'E', '');
    916. 

  916. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('645100', 'COTISATIONS A L\'URSSAF', 'A', '', 'E', 'AP_amount');
    917. 

  917. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('645200', 'COTISATIONS AUX MUTUELES', 'A', '', 'E', 'AP_amount');
    918. 

  918. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('645300', 'COTISATIONS AUX CAISSES RETR.', 'A', '', 'E', 'AP_amount');
    919. 

  919. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('646400', 'COTISATIONS AUX ASSEDIC', 'A', '', 'E', 'AP_amount');
    920. 

  920. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('623400', 'CADEAUX A LA CLIENTELE', 'A', '', 'E', 'AP_amount');
    921. 

  921. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('437000', 'AUTRES ORGANISMES SOCIAUX', 'A', '', 'E', 'AP_amount');
    922. 

  922. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('606100', 'FOURNITURES NON STOCK. EAU ENERG.', 'A', '', 'E', 'AP_amount');
    923. 

  923. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('606300', 'FOURNIT. ENTRETIEN & PETIT EQUIP.', 'A', '', 'E', 'AP_amount');
    924. 

  924. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('625010', 'DEPLACEMENTS AUTO', 'A', '', 'E', 'AP_amount');
    925. 

  925. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('635110', 'TAXE PROFESSIONNELLE', 'A', '', 'E', 'AP_amount');
    926. 

  926. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('645001', 'CSG', 'A', '', 'E', 'AP_amount');
    927. 

  927. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('660000', 'CHARGES FINANCIERES', 'A', '', 'E', 'AP_amount');
    928. 

  928. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('666000', 'PERTES DE CHANGE', 'A', '', 'E', 'AP_amount');
    929. 

  929. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('512040', 'EXPLOITANT', 'A', '', 'E', 'AP_paid');
    930. 

  930. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('431000', 'SECURITE SOCIALE', 'A', '', 'E', '');
    931. 

  931. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('609400', 'D\'ETUDES & PRESTATIONS DE SERVICES', 'A', '', '', '');
    932. 

  932. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('625100', 'VOYAGES ET DEPLACEMENTS', 'A', '', 'E', 'AP_amount');
    933. 

  933. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('618300', 'DOCUMENTATION TECHNIQUE', 'A', '', 'E', 'AP_amount');
    934. 

  934. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('445663', 'TVA DEDUCTIBLE 19.6%', 'A', '', 'E', 'AP_tax:IC_taxpart:IC_taxservice');
    935. 

  935. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('601000', 'ACHATS STOCKES MAT. PREM. (FOURN.)', 'A', '', 'E', 'AP_amount:IC_cogs');
    936. 

  936. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('626000', 'FRAIS POSTAUX ET TELECOMMUNIC.', 'A', '', 'E', 'AP_amount');
    937. 

  937. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('512000', 'BANQUE', 'A', '', 'A', 'AR_paid:AP_paid');
    938. 

  938. --
    939. 

  939. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('999000', 'Foreign Exchange Gain', 'A', '', 'I', '');
    940. 

  940. INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('999010', 'Foreign Exchange Loss', 'A', '', 'E', '');
    941. 

  941. --
    942. 

  942. -- insert taxes
    943. 

  943. --
    944. 

  944. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '445661'), 0.055);
    945. 

  945. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '445663'), 0.196);
    946. 

  946. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '445711'), 0.055);
    947. 

  947. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '445713'), 0.196);
    948. 

  948. --
    949. 

  949. -- update defaults
    950. 

  950. --
    951. 

  951. INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '681730'));
    952. 

  952. 

  953.  INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '707000'));
    954. 

  954. 

  955.  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '601000'));
    956. 

  956. 

  957.  INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '999000'));
    958. 

  958. 

  959.  INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '999010'));
    960. 

  960. 

  961.  INSERT INTO defaults (setting_key, value) VALUES ('curr', 'EUR');
    962. 

  962. 

  963.  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
    964. 

  964. --
    965. 

  965. commit;
    966.
generated by cgit v1.2.3 (git 2.39.1) at 2024-06-26 04:20:07 +0000